{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Kassaflöde","Månadsinkomst","Månadsutgift","DIAGRAMDATA"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Kassaflöde","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Namn"]
[null,"Familjebudget"]
[null,{"$f":"TEXT(TODAY(),\"MMMM\")","v":"januari"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Obs! Tabellen över betalningar beräknas automatiskt baserat på dina poster från kalkylbladen Månadsinkomst och Månadsutgift"]
[null,"Kassaflöde","Beräknad","Faktisk","Varians"]
[null,"Summa inkomster",{"$f":"Inkomst[[#Totals],[Beräknad]]","v":{"v":57000,"d":"57,000"}},{"$f":"Inkomst[[#Totals],[Faktisk]]","v":{"v":55000,"d":"55,000"}},{"$f":"Inkomst[[#Totals],[Varians]]","v":{"v":-2000,"d":"-2,000"}}]
[null,"Summa utgifter",{"$f":"Utgift[[#Totals],[Beräknad]]","v":{"v":36030,"d":"36,030"}},{"$f":"Utgift[[#Totals],[Faktisk]]","v":{"v":36550,"d":"36,550"}},{"$f":"Utgift[[#Totals],[Varians]]","v":-520}]
[null,"Summa",{"$f":"C7-C8","v":{"v":20970,"d":"20,970"}},{"$f":"D7-D8","v":{"v":18450,"d":"18,450"}},{"$f":"SUBTOTAL(109,Kassaflöde[Varians])","v":{"v":-2520,"d":"-2,520"}}]

{"sheet":"Månadsinkomst","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Namn","v":"Namn"}]
[null,{"$f":"Budgetrubrik","v":"Familjebudget"}]
[null,{"$f":"Månad","v":"januari"}]
[null,{"$f":"År","v":2017}]
[null,"Månadsinkomst","Beräknad","Faktisk","Varians"]
[null,"Inkomst 1",{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"$f":"Inkomst[[#This Row],[Faktisk]]-Inkomst[[#This Row],[Beräknad]]","v":0}]
[null,"Inkomst 2",{"v":14000,"d":"14,000"},{"v":15000,"d":"15,000"},{"$f":"Inkomst[[#This Row],[Faktisk]]-Inkomst[[#This Row],[Beräknad]]","v":{"v":1000,"d":"1,000"}}]
[null,"Annan inkomst",{"v":3000,"d":"3,000"},0,{"$f":"Inkomst[[#This Row],[Faktisk]]-Inkomst[[#This Row],[Beräknad]]","v":{"v":-3000,"d":"-3,000"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Inkomst[Beräknad])","v":{"v":57000,"d":"57,000"}},{"$f":"SUBTOTAL(109,Inkomst[Faktisk])","v":{"v":55000,"d":"55,000"}},{"$f":"SUBTOTAL(109,Inkomst[Varians])","v":{"v":-2000,"d":"-2,000"}}]

{"sheet":"Månadsutgift","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Namn","v":"Namn"}]
[null,{"$f":"Budgetrubrik","v":"Familjebudget"}]
[null,{"$f":"Månad","v":"januari"}]
[null,{"$f":"År","v":2017}]
[null,"Månadsutgift","Beräknad","Faktisk","Varians"]
[null,"Bostad",{"v":15000,"d":"15,000"},{"v":15000,"d":"15,000"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Matvaror",{"v":2500,"d":"2,500"},{"v":2800,"d":"2,800"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":-300}]
[null,"Telefon",380,380,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"El/gas",650,780,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":-130}]
[null,"Vatten/avlopp/sopor",250,210,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":40}]
[null,"Kabel-TV",750,830,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":-80}]
[null,"Internet",600,600,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Underhåll/reparationer",0,600,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":-600}]
[null,"Barnomsorg",{"v":1800,"d":"1,800"},{"v":1500,"d":"1,500"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":300}]
[null,"Skolavgifter",{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Husdjur",750,800,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":-50}]
[null,"Transport",{"v":2800,"d":"2,800"},{"v":2600,"d":"2,600"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":200}]
[null,"Hygien",750,650,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":100}]
[null,"Försäkring",{"v":2550,"d":"2,550"},{"v":2550,"d":"2,550"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Kreditkort",{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Lån",0,0,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Skatter",0,0,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Gåvor/välgörenhet",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Sparande",{"v":2250,"d":"2,250"},{"v":2250,"d":"2,250"},{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Övrigt",0,0,{"$f":"Utgift[[#This Row],[Beräknad]]-Utgift[[#This Row],[Faktisk]]","v":0}]
[null,"Summa",{"$f":"SUBTOTAL(109,Utgift[Beräknad])","v":{"v":36030,"d":"36,030"}},{"$f":"SUBTOTAL(109,Utgift[Faktisk])","v":{"v":36550,"d":"36,550"}},{"$f":"SUBTOTAL(109,Utgift[Varians])","v":-520}]

{"sheet":"DIAGRAMDATA","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"DIAGRAMDATA"]
[]
[null,null,"Beräknad","Faktisk"]
[null,"Kassaflöde",{"$f":"Kassaflöde[[#Totals],[Beräknad]]","v":20970},{"$f":"Kassaflöde[[#Totals],[Faktisk]]","v":18450}]
[null,"Månadsinkomst",{"$f":" Inkomst[[#Totals],[Beräknad]]","v":57000},{"$f":" Inkomst[[#Totals],[Faktisk]]","v":55000}]
[null,"Månadsutgift",{"$f":"Utgift[[#Totals],[Beräknad]]","v":36030},{"$f":"Utgift[[#Totals],[Faktisk]]","v":36550}]