{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Pengestrøm","Månedlig indtægt","Månedlige udgifter","Diagramdata"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Pengestrøm","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Efternavn"]
[null,"Familiebudget"]
[null,{"$f":"\" For måneden \" & TEXT(TODAY(),\"mmmm åååå\")","v":" For måneden september 2021"}]
[]
[]
[null,"Pengestrømsanalyse"]
[]
[]
[null," ","Forventet","Faktisk","Afvigelse"]
[{"$f":"Indtægt[[#Totals],[Afvigelse]]","v":300},"Indtægt i alt",{"$f":"Indtægt[[#Totals],[Forventet]]","v":{"v":5700,"d":"kr. 5,700"}},{"$f":"Indtægt[[#Totals],[Faktisk]]","v":{"v":6000,"d":"kr. 6,000"}},{"$f":"A12","v":{"v":300,"d":"kr. 300"}}]
[{"$f":"Udgifter[[#Totals],[Afvigelse]]","v":-52},"Udgifter i alt",{"$f":"Udgifter[[#Totals],[Forventet]]","v":{"v":3603,"d":"kr. 3,603"}},{"$f":"Udgifter[[#Totals],[Faktisk]]","v":{"v":3655,"d":"kr. 3,655"}},{"$f":"A13","v":{"v":-52,"d":"kr. -52"}}]
[null,"Kontanter i alt",{"$f":"C12-C13","v":{"v":2097,"d":"kr. 2,097"}},{"$f":"D12-D13","v":{"v":2345,"d":"kr. 2,345"}},{"$f":"SUBTOTAL(109,Pengestrøm[Afvigelse])","v":{"v":248,"d":"kr. 248"}}]

{"sheet":"Månedlig indtægt","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Månedlig indtægt"]
[]
[]
[null," ","Forventet","Faktisk","Afvigelse"]
[null,"Indtægt 1",{"v":4000,"d":"kr. 4,000.00"},{"v":4000,"d":"kr. 4,000.00"},{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Indtægt 2",{"v":1400,"d":"kr. 1,400.00"},{"v":1500,"d":"kr. 1,500.00"},{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":{"v":100,"d":"kr. 100.00"}}]
[null,"Anden indtægt",{"v":300,"d":"kr. 300.00"},{"v":500,"d":"kr. 500.00"},{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":{"v":200,"d":"kr. 200.00"}}]
[null,"Indtægt i alt",{"$f":"SUBTOTAL(109,Indtægt[Forventet])","v":{"v":5700,"d":"kr. 5,700.00"}},{"$f":"SUBTOTAL(109,Indtægt[Faktisk])","v":{"v":6000,"d":"kr. 6,000.00"}},{"$f":"SUBTOTAL(109,Indtægt[Afvigelse])","v":{"v":300,"d":"kr. 300.00"}}]

{"sheet":"Månedlige udgifter","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Månedlige udgifter"]
[]
[]
[null," ","Forventet","Faktisk","Afvigelse"]
[null,"Bolig",{"v":1500,"d":"kr. 1,500.00"},{"v":1500,"d":"kr. 1,500.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Dagligvarer",{"v":250,"d":"kr. 250.00"},{"v":280,"d":"kr. 280.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":-30,"d":"kr. -30.00"}}]
[null,"Telefonnummer",{"v":38,"d":"kr. 38.00"},{"v":38,"d":"kr. 38.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"El/gas",{"v":65,"d":"kr. 65.00"},{"v":78,"d":"kr. 78.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":-13,"d":"kr. -13.00"}}]
[null,"Vand/kloak/affald",{"v":25,"d":"kr. 25.00"},{"v":21,"d":"kr. 21.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":4,"d":"kr. 4.00"}}]
[null,"Kabel-tv",{"v":75,"d":"kr. 75.00"},{"v":83,"d":"kr. 83.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":-8,"d":"kr. -8.00"}}]
[null,"Internet",{"v":60,"d":"kr. 60.00"},{"v":60,"d":"kr. 60.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Vedligeholdelse/reparation",{"v":0,"d":"kr. 0.00"},{"v":60,"d":"kr. 60.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":-60,"d":"kr. -60.00"}}]
[null,"Børnepasning",{"v":180,"d":"kr. 180.00"},{"v":150,"d":"kr. 150.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":30,"d":"kr. 30.00"}}]
[null,"Undervisning",{"v":250,"d":"kr. 250.00"},{"v":250,"d":"kr. 250.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Kæledyr",{"v":75,"d":"kr. 75.00"},{"v":80,"d":"kr. 80.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":-5,"d":"kr. -5.00"}}]
[null,"Transport",{"v":280,"d":"kr. 280.00"},{"v":260,"d":"kr. 260.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":20,"d":"kr. 20.00"}}]
[null,"Personlig pleje",{"v":75,"d":"kr. 75.00"},{"v":65,"d":"kr. 65.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":10,"d":"kr. 10.00"}}]
[null,"Forsikring",{"v":255,"d":"kr. 255.00"},{"v":255,"d":"kr. 255.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Kreditkort",{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Lån",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Skat",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Gaver/velgørenhed",{"v":150,"d":"kr. 150.00"},{"v":150,"d":"kr. 150.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Opsparing",{"v":225,"d":"kr. 225.00"},{"v":225,"d":"kr. 225.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$f":"Udgifter[[#This Row],[Forventet]]-Udgifter[[#This Row],[Faktisk]]","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Udgifter[Forventet])","v":{"v":3603,"d":"kr. 3,603.00"}},{"$f":"SUBTOTAL(109,Udgifter[Faktisk])","v":{"v":3655,"d":"kr. 3,655.00"}},{"$f":"SUBTOTAL(109,Udgifter[Afvigelse])","v":{"v":-52,"d":"kr. -52.00"}}]

{"sheet":"Diagramdata","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Diagramdata"]
[]
[null,null,"Forventet","Faktisk"]
[null,"Månedlig indtægt",{"$f":"Indtægt[[#Totals],[Forventet]]","v":5700},{"$f":"Indtægt[[#Totals],[Faktisk]]","v":6000}]
[null,"Månedlige udgifter",{"$f":"Udgifter[[#Totals],[Forventet]]","v":3603},{"$f":"Udgifter[[#Totals],[Faktisk]]","v":3655}]
[null,"Likviditet",{"$f":"Pengestrøm[[#Totals],[Forventet]]","v":2097},{"$f":"Pengestrøm[[#Totals],[Faktisk]]","v":2345}]