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

{"sheet":"Pengestrøm","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Navn"]
[null,"Familiebudget"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"January"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Bemærk! Tabellen Pengestrøm beregnes automatisk ud fra indtastninger i regnearkene Månedlig indtægt og Månedlig udgift"]
[null,"Pengestrøm","Forventet","Faktisk","Afvigelse"]
[null,"Indtægt i alt",{"$f":"Indtægt[[#Totals],[Forventet]]","v":{"v":5700,"d":"5,700"}},{"$f":"Indtægt[[#Totals],[Faktisk]]","v":{"v":5500,"d":"5,500"}},{"$f":"Indtægt[[#Totals],[Afvigelse]]","v":-200}]
[null,"Udgifter i alt",{"$f":"Udgift[[#Totals],[Forventet]]","v":{"v":3603,"d":"3,603"}},{"$f":"Udgift[[#Totals],[Faktisk]]","v":{"v":3655,"d":"3,655"}},{"$f":"Udgift[[#Totals],[Afvigelse]]","v":-52}]
[null,"Kontanter i alt",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,Pengestrøm[Afvigelse])","v":-252}]

{"sheet":"Månedlig indtægt","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Navn","v":"Navn"}]
[null,{"$f":"Budgettitel","v":"Familiebudget"}]
[null,{"$f":"Måned","v":"January"}]
[null,{"$f":"År","v":2017}]
[null,"Månedlig indtægt","Forventet","Faktisk","Afvigelse"]
[null,"Indtægt 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":0}]
[null,"Indtægt 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":100}]
[null,"Anden indtægt",300,0,{"$f":"Indtægt[[#This Row],[Faktisk]]-Indtægt[[#This Row],[Forventet]]","v":-300}]
[null,"Indtægt i alt",{"$f":"SUBTOTAL(109,Indtægt[Forventet])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,Indtægt[Faktisk])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,Indtægt[Afvigelse])","v":-200}]

{"sheet":"Månedlig udgift","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Navn","v":"Navn"}]
[null,{"$f":"Budgettitel","v":"Familiebudget"}]
[null,{"$f":"Måned","v":"January"}]
[null,{"$f":"År","v":2017}]
[null,"Månedlig udgift","Forventet","Faktisk","Afvigelse"]
[null,"Bolig",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Dagligvarer",250,280,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":-30}]
[null,"Telefonnummer",38,38,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"El/gas",65,78,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":-13}]
[null,"Vand/kloak/affald",25,21,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":4}]
[null,"Kabel-tv",75,83,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":-8}]
[null,"Internet",60,60,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Vedligeholdelse/reparation",0,60,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":-60}]
[null,"Børnepasning",180,150,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":30}]
[null,"Undervisning",250,250,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Kæledyr",75,80,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":-5}]
[null,"Transport",280,260,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":20}]
[null,"Personlig pleje",75,65,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":10}]
[null,"Forsikring",255,255,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Kreditkort",100,100,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Lån",0,0,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Skat",0,0,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Gaver/velgørenhed",150,150,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Opsparing",225,225,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"Andet",0,0,{"$f":"Udgift[[#This Row],[Forventet]]-Udgift[[#This Row],[Faktisk]]","v":0}]
[null,"I alt",{"$f":"SUBTOTAL(109,Udgift[Forventet])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,Udgift[Faktisk])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,Udgift[Afvigelse])","v":-52}]

{"sheet":"DIAGRAMDATA","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"DIAGRAMDATA"]
[]
[null,null,"Forventet","Faktisk"]
[null,"Pengestrøm",{"$f":"Pengestrøm[[#Totals],[Forventet]]","v":2097},{"$f":"Pengestrøm[[#Totals],[Faktisk]]","v":1845}]
[null,"Månedlig indtægt",{"$f":"Indtægt[[#Totals],[Forventet]]","v":5700},{"$f":"Indtægt[[#Totals],[Faktisk]]","v":5500}]
[null,"Månedlig udgift",{"$f":"Udgift[[#Totals],[Forventet]]","v":3603},{"$f":"Udgift[[#Totals],[Faktisk]]","v":3655}]