{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Julbudget","Listpost","Listinformation"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Julbudget","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[13,4,19,4]]}
[null,"Julbudget för inköp",null,null,"Ljusslinga i den här cellen.","TILL LISTPOST >"]
[{"$nulls":5},"TILL LISTINFORMATION >"]
[null,"TOTALSUMMOR",null,"Grupperat stapeldiagram som visar kostnadstilldelning och hur mycket som använts hittills."]
[null,"KOSTNADSTILLDELNING",{"$f":"SUM(Gåvodata[KOSTNAD])","v":{"v":377,"d":"377.00 kr"}}]
[null,"ANVÄNT HITTILLS",{"$f":"SUMIF(Gåvodata[KÖPT],\"Köpt\",Gåvodata[KOSTNAD])","v":{"v":233,"d":"233.00 kr"}}]
[null,"DIFFERENS",{"$f":"C4-C5","v":{"v":144,"d":"144.00 kr"}}]
[null,"Uppdatera rapporten genom att Uppdatera den.",null,null,"Utsnitt för att filtrera tabelldata baserat på inslagningsstatus finns i den här cellen.","Utsnitt för att filtrera tabelldata baserat på köpt finns i den här cellen."]
[null,"FÖRDELNING",null,"Utsnitt för att filtrera tabelldata baserat på avsedd mottagare finns i den här cellen."]
[null,null,"Gåvokostnad"]
[null,"Namn 1",{"v":39,"d":"39.00 kr"}]
[null,"Köpt"]
[null,"Tröja",{"v":39,"d":"39.00 kr"}]
[]
[null,"Namn 2",{"v":59,"d":"59.00 kr"},null,"Utsnitt för att filtrera tabelldata baserat på leveransstatus finns i den här cellen.","Utsnitt för att filtrera tabelldata baserat på gåvokategori finns i den här cellen."]
[null,"Köpt"]
[null,"Dockhus",{"v":36,"d":"36.00 kr"}]
[null,"Strumpor",{"v":23,"d":"23.00 kr"}]
[]
[null,"Namn 3",{"v":71,"d":"71.00 kr"}]
[null,"Köpt"]
[null,"Leksakståg",{"v":26,"d":"26.00 kr"}]
[null,"Pussel",{"v":16,"d":"16.00 kr"}]
[null,"Inte köpt"]
[null,"Cykel",{"v":29,"d":"29.00 kr"}]
[]
[null,"Namn 4",{"v":44,"d":"44.00 kr"}]
[null,"Köpt"]
[null,"Fotoalbum",{"v":30,"d":"30.00 kr"}]
[null,"Material för urklippsbok",{"v":14,"d":"14.00 kr"}]
[]
[null,"Namn 5",{"v":118,"d":"118.00 kr"}]
[null,"Köpt"]
[null,"Xbox-spel",{"v":49,"d":"49.00 kr"}]
[null,"Inte köpt"]
[null,"Presentkort",{"v":32,"d":"32.00 kr"}]
[null,"Skjorta",{"v":37,"d":"37.00 kr"}]
[]
[null,"Namn 6",{"v":46,"d":"46.00 kr"}]
[null,"Inte köpt"]
[null,"Strumpor",{"v":46,"d":"46.00 kr"}]
[]
[null,"Grand Total",{"v":377,"d":"377.00 kr"}]

{"sheet":"Listpost","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"Inköpslista",null,"Ljusslinga i den här cellen.",{"$nulls":3},"TILL LISTINFORMATION >"]
[{"$nulls":7},"< TILL JULBUDGET"]
[null,"FÖR","GÅVOKATEGORI","GÅVA","KOSTNAD","KÖPT","LEVERANSSTATUS","INSLAGNINGSSTATUS"]
[null,"Namn 3","Familjegåva","Leksakståg",{"v":26,"d":"26.00 kr"},"Köpt","Ankommen","Inslagen"]
[null,"Namn 2","Allmän gåva","Strumpor",{"v":23,"d":"23.00 kr"},"Köpt","Ankommen","Inslagen"]
[null,"Namn 3","Allmän gåva","Pussel",{"v":16,"d":"16.00 kr"},"Köpt","Ankommen","Inte inslagen"]
[null,"Namn 4","Allmän gåva","Material för urklippsbok",{"v":14,"d":"14.00 kr"},"Köpt","Under transport","Inte inslagen"]
[null,"Namn 5","Allmän gåva","Xbox-spel",{"v":49,"d":"49.00 kr"},"Köpt","Under transport","Inte inslagen"]
[null,"Namn 5","Allmän gåva","Skjorta",{"v":37,"d":"37.00 kr"},"Inte köpt","Under transport","Inte inslagen"]
[null,"Namn 1","Allmän gåva","Tröja",{"v":39,"d":"39.00 kr"},"Köpt","Under transport","Inte inslagen"]
[null,"Namn 2","Allmän gåva","Dockhus",{"v":36,"d":"36.00 kr"},"Köpt","Ankommen","Inte inslagen"]
[null,"Namn 3","Allmän gåva","Cykel",{"v":29,"d":"29.00 kr"},"Inte köpt"]
[null,"Namn 4","Allmän gåva","Fotoalbum",{"v":30,"d":"30.00 kr"},"Köpt","Ankommen"]
[null,"Namn 5","Allmän gåva","Presentkort",{"v":32,"d":"32.00 kr"},"Inte köpt"]
[null,"Namn 6","Allmän gåva","Strumpor",{"v":46,"d":"46.00 kr"},"Inte köpt"]

{"sheet":"Listinformation","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"Listinformation","Ljusslinga i den här cellen.",null,"< TILL LISTPOST"]
[{"$nulls":4},"< TILL HELGDAGSBUDGET"]
[null,"PERSONER",null,"GÅVOKATEGORIER"]
[null,"Namn 1",null,"Småpresenter"]
[null,"Namn 2",null,"Allmän gåva"]
[null,"Namn 3",null,"Gåva make/maka"]
[null,"Namn 4",null,"Familjegåva"]
[null,"Namn 5",null,"Särskild gåva"]
[null,"Namn 6"]