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

{"sheet":"Kassaflöde","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Familjenamn"]
[null,"Familjebudget"]
[null,{"$f":"\" För månaden \" & TEXT(TODAY(),\"MMMM ÅÅÅÅ\")","v":" För månaden september 2021"}]
[]
[]
[null,"Kassaflödesanalys"]
[]
[]
[null," ","Beräknad","Faktisk","Varians"]
[{"$f":"Inkomster[[#Totals],[Varians]]","v":300},"Total inkomst",{"$f":"Inkomster[[#Totals],[Beräknad]]","v":{"v":5700,"d":"5,700 kr"}},{"$f":"Inkomster[[#Totals],[Faktisk]]","v":{"v":6000,"d":"6,000 kr"}},{"$f":"A12","v":{"v":300,"d":"300 kr"}}]
[{"$f":"Utgifter[[#Totals],[Avvikelse]]","v":{"v":-52,"d":"-52.00 kr"}},"Summa utgifter",{"$f":"Utgifter[[#Totals],[Beräknad]]","v":{"v":3603,"d":"3,603 kr"}},{"$f":"Utgifter[[#Totals],[Faktisk]]","v":{"v":3655,"d":"3,655 kr"}},{"$f":"A13","v":{"v":-52,"d":"-52 kr"}}]
[null,"Summa kontanter",{"$f":"C12-C13","v":{"v":2097,"d":"2,097 kr"}},{"$f":"D12-D13","v":{"v":2345,"d":"2,345 kr"}},{"$f":"SUBTOTAL(109,Kassaflöde[Varians])","v":{"v":248,"d":"248 kr"}}]

{"sheet":"Månadsinkomst","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Månadsinkomst"]
[]
[]
[null," ","Beräknad","Faktisk","Varians"]
[null,"Inkomst 1",{"v":4000,"d":"4,000.00 kr"},{"v":4000,"d":"4,000.00 kr"},{"$f":"Inkomster[[#This Row],[Faktisk]]-Inkomster[[#This Row],[Beräknad]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Inkomst 2",{"v":1400,"d":"1,400.00 kr"},{"v":1500,"d":"1,500.00 kr"},{"$f":"Inkomster[[#This Row],[Faktisk]]-Inkomster[[#This Row],[Beräknad]]","v":{"v":100,"d":"100.00 kr"}}]
[null,"Annan inkomst",{"v":300,"d":"300.00 kr"},{"v":500,"d":"500.00 kr"},{"$f":"Inkomster[[#This Row],[Faktisk]]-Inkomster[[#This Row],[Beräknad]]","v":{"v":200,"d":"200.00 kr"}}]
[null,"Summa Inkomster",{"$f":"SUBTOTAL(109,Inkomster[Beräknad])","v":{"v":5700,"d":"5,700.00 kr"}},{"$f":"SUBTOTAL(109,Inkomster[Faktisk])","v":{"v":6000,"d":"6,000.00 kr"}},{"$f":"SUBTOTAL(109,Inkomster[Varians])","v":{"v":300,"d":"300.00 kr"}}]

{"sheet":"Månadsutgifter","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Månadsutgifter"]
[]
[]
[null," ","Beräknad","Faktisk","Avvikelse"]
[null,"Bostad",{"v":1500,"d":"1,500.00 kr"},{"v":1500,"d":"1,500.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Matvaror",{"v":250,"d":"250.00 kr"},{"v":280,"d":"280.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":-30,"d":"-30.00 kr"}}]
[null,"Telefon",{"v":38,"d":"38.00 kr"},{"v":38,"d":"38.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"El/gas",{"v":65,"d":"65.00 kr"},{"v":78,"d":"78.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":-13,"d":"-13.00 kr"}}]
[null,"Vatten/avlopp/sopor",{"v":25,"d":"25.00 kr"},{"v":21,"d":"21.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":4,"d":"4.00 kr"}}]
[null,"Kabel-TV",{"v":75,"d":"75.00 kr"},{"v":83,"d":"83.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":-8,"d":"-8.00 kr"}}]
[null,"Internet",{"v":60,"d":"60.00 kr"},{"v":60,"d":"60.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Underhåll/reparationer",{"v":0,"d":"0.00 kr"},{"v":60,"d":"60.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":-60,"d":"-60.00 kr"}}]
[null,"Barnomsorg",{"v":180,"d":"180.00 kr"},{"v":150,"d":"150.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":30,"d":"30.00 kr"}}]
[null,"Skolavgifter",{"v":250,"d":"250.00 kr"},{"v":250,"d":"250.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Husdjur",{"v":75,"d":"75.00 kr"},{"v":80,"d":"80.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":-5,"d":"-5.00 kr"}}]
[null,"Transport",{"v":280,"d":"280.00 kr"},{"v":260,"d":"260.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":20,"d":"20.00 kr"}}]
[null,"Hygien",{"v":75,"d":"75.00 kr"},{"v":65,"d":"65.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":10,"d":"10.00 kr"}}]
[null,"Försäkring",{"v":255,"d":"255.00 kr"},{"v":255,"d":"255.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Kreditkort",{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Lån",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Skatter",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Gåvor/välgörenhet",{"v":150,"d":"150.00 kr"},{"v":150,"d":"150.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Sparande",{"v":225,"d":"225.00 kr"},{"v":225,"d":"225.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$f":"Utgifter[[#This Row],[Beräknad]]-Utgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Utgifter[Beräknad])","v":{"v":3603,"d":"3,603.00 kr"}},{"$f":"SUBTOTAL(109,Utgifter[Faktisk])","v":{"v":3655,"d":"3,655.00 kr"}},{"$f":"SUBTOTAL(109,Utgifter[Avvikelse])","v":{"v":-52,"d":"-52.00 kr"}}]

{"sheet":"Diagramdata","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Diagramdata"]
[]
[null,null,"Beräknade","Faktisk"]
[null,"Månadsinkomst",{"$f":"Inkomster[[#Totals],[Beräknad]]","v":5700},{"$f":"Inkomster[[#Totals],[Faktisk]]","v":6000}]
[null,"Månadsutgifter",{"$f":"Utgifter[[#Totals],[Beräknad]]","v":3603},{"$f":"Utgifter[[#Totals],[Faktisk]]","v":3655}]
[null,"Kassaflöde",{"$f":"Kassaflöde[[#Totals],[Beräknad]]","v":2097},{"$f":"Kassaflöde[[#Totals],[Faktisk]]","v":2345}]