{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Vejledning","Daglig pengestrøm","Månedlig pengestrøm","Årlig pengestrøm","Indtægt","Udgifter","Selvforvaltet","Besparelser"],"not_rendered":{"charts":4,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Vejledning","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"PERSONLIG PENGESTRØM"]
[null,"  Denne projektmappe har regneark med årlig, månedlig og daglig pengestrøm. \n  Vælg den pengestrømstype, der fungerer bedst for dig, eller brug dem alle til at få indsigt i din personlige pengestrøm."]
[]
[null,"Daglig pengestrøm",null,null,"Månedlig pengestrøm",null,null,"Årlig pengestrøm"]
[]
[null,"Angiv anslag på det cashflow, du oplever dagligt, og gennemgå de anslåede måneds- og årstotaler.  Brug det til at få en fornemmelse af, hvordan dine daglige forbrugsvaner ser ud i løbet af en måned eller et år.",null,null,"Angiv det månedlige pengestrømsbeløb, du oplever månedligt, eller anslå de resterende måneder for at se årets forventede pengestrøm for hver måned.",null,null,"Angiv et årligt pengestrømsbeløb på fire regneark: Indtægter, udgifter, skøn og besparelser. \nSe den månedlige opdeling, se beløbene i forhold til hinanden, og ikke mindst tallene på bundlinjen, både årlige og månedlige."]

{"sheet":"Daglig pengestrøm","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"PERSONLIG PENGESTRØM"]
[null,null,"Tilgængelige kontanter i alt:",{"$f":"DagligPengestrøm","v":{"v":577.8399999999999,"d":"kr. 577.84"}},null,"BEMÆRK: Hvis du vil føje daglige poster til tabellen, skal du anslå det månedlige beløb/værdien og skrive værdien i kolonnen for den relevante måned."]
[]
[null,"DAGLIG OVERSIGT"]
[null,"Samlede beløb","Dagligt","Månedligt","Årligt "]
[null,"Indtægt",{"$f":"SUMIF(Dagligt[Type],$B6,Dagligt[Dagligt])","v":{"v":342.47,"d":"kr. 342.47"}},{"$f":"SUMIF(Dagligt[Type],$B6,Dagligt[Månedligt])","v":{"v":10416.795833333334,"d":"kr. 10,416.80"}},{"$f":"SUMIF(Dagligt[Type],$B6,Dagligt[Årligt])","v":{"v":125001.55000000002,"d":"kr. 125,001.55"}}]
[null,"Udgifter",{"$f":"SUMIF(Dagligt[Type],$B7,Dagligt[Dagligt])","v":{"v":136.05999999999997,"d":"kr. 136.06"}},{"$f":"SUMIF(Dagligt[Type],$B7,Dagligt[Månedligt])","v":{"v":4138.491666666667,"d":"kr. 4,138.49"}},{"$f":"SUMIF(Dagligt[Type],$B7,Dagligt[Årligt])","v":{"v":49661.899999999994,"d":"kr. 49,661.90"}}]
[null,"Selvforvaltet",{"$f":"SUMIF(Dagligt[Type],$B8,Dagligt[Dagligt])","v":{"v":36.29,"d":"kr. 36.29"}},{"$f":"SUMIF(Dagligt[Type],$B8,Dagligt[Månedligt])","v":{"v":1103.8208333333334,"d":"kr. 1,103.82"}},{"$f":"SUMIF(Dagligt[Type],$B8,Dagligt[Årligt])","v":{"v":13245.849999999999,"d":"kr. 13,245.85"}}]
[null,"Opsparing",{"$f":"SUMIF(Dagligt[Type],$B9,Dagligt[Dagligt])","v":{"v":63.019999999999996,"d":"kr. 63.02"}},{"$f":"SUMIF(Dagligt[Type],$B9,Dagligt[Månedligt])","v":{"v":1916.8583333333333,"d":"kr. 1,916.86"}},{"$f":"SUMIF(Dagligt[Type],$B9,Dagligt[Årligt])","v":{"v":23002.300000000003,"d":"kr. 23,002.30"}}]
[]
[null,"Type","Beskrivelse","Dagligt","Månedligt","Årligt"]
[null,"Indtægt","Løn",{"v":246.58,"d":"kr. 246.58"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":7500.141666666667,"d":"kr. 7,500.14"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":90001.70000000001,"d":"kr. 90,001.70"}}]
[null,"Indtægt","Provisioner/bonus",{"v":13.7,"d":"kr. 13.70"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":416.7083333333333,"d":"kr. 416.71"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":5000.5,"d":"kr. 5,000.50"}}]
[null,"Indtægt","Andet 1",{"v":82.19,"d":"kr. 82.19"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":2499.945833333333,"d":"kr. 2,499.95"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":29999.35,"d":"kr. 29,999.35"}}]
[null,"Indtægt","Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Indtægt","Andet 3",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Indtægt","Andet 4",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Sundhedsforsikring",{"v":41.1,"d":"kr. 41.10"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":1250.125,"d":"kr. 1,250.13"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":15001.5,"d":"kr. 15,001.50"}}]
[null,"Udgifter","Indkomstskat",{"v":6.85,"d":"kr. 6.85"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":208.35416666666666,"d":"kr. 208.35"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":2500.25,"d":"kr. 2,500.25"}}]
[null,"Udgifter","Vægtafgift",{"v":0.55,"d":"kr. 0.55"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":16.729166666666668,"d":"kr. 16.73"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":200.75000000000003,"d":"kr. 200.75"}}]
[null,"Udgifter","Afbetaling af bil",{"v":10.96,"d":"kr. 10.96"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":333.3666666666667,"d":"kr. 333.37"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":4000.4,"d":"kr. 4,000.40"}}]
[null,"Udgifter","Realkreditlån/leje",{"v":41.1,"d":"kr. 41.10"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":1250.125,"d":"kr. 1,250.13"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":15001.5,"d":"kr. 15,001.50"}}]
[null,"Udgifter","Forsikring",{"v":0.68,"d":"kr. 0.68"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":20.683333333333334,"d":"kr. 20.68"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":248.20000000000002,"d":"kr. 248.20"}}]
[null,"Udgifter","El",{"v":3.29,"d":"kr. 3.29"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":100.07083333333333,"d":"kr. 100.07"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":1200.85,"d":"kr. 1,200.85"}}]
[null,"Udgifter","Benzin",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Udgifter","Vand",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Udgifter","Kloakafgift",{"v":0.82,"d":"kr. 0.82"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":24.941666666666663,"d":"kr. 24.94"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":299.29999999999995,"d":"kr. 299.30"}}]
[null,"Udgifter","Renovation",{"v":0.41,"d":"kr. 0.41"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":12.470833333333331,"d":"kr. 12.47"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":149.64999999999998,"d":"kr. 149.65"}}]
[null,"Udgifter","Telefonnummer",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Udgifter","Internet",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Udgifter","Handicap-præmier",{"v":4.11,"d":"kr. 4.11"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":125.0125,"d":"kr. 125.01"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":1500.15,"d":"kr. 1,500.15"}}]
[null,"Udgifter","Mad",{"v":13.7,"d":"kr. 13.70"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":416.7083333333333,"d":"kr. 416.71"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":5000.5,"d":"kr. 5,000.50"}}]
[null,"Udgifter","Beklædning",{"v":3.29,"d":"kr. 3.29"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":100.07083333333333,"d":"kr. 100.07"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":1200.85,"d":"kr. 1,200.85"}}]
[null,"Udgifter","Medicin/tandlæge",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Udgifter","Bus",{"v":1,"d":"kr. 1.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":30.416666666666668,"d":"kr. 30.42"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":365,"d":"kr. 365.00"}}]
[null,"Udgifter","Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Andet 3",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Andet 4",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Selvforvaltet","Restaurant",{"v":3.29,"d":"kr. 3.29"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":100.07083333333333,"d":"kr. 100.07"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":1200.85,"d":"kr. 1,200.85"}}]
[null,"Selvforvaltet","Gaver",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Selvforvaltet","Rejser",{"v":6.16,"d":"kr. 6.16"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":187.36666666666667,"d":"kr. 187.37"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":2248.4,"d":"kr. 2,248.40"}}]
[null,"Selvforvaltet","Underholdning",{"v":3.29,"d":"kr. 3.29"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":100.07083333333333,"d":"kr. 100.07"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":1200.85,"d":"kr. 1,200.85"}}]
[null,"Selvforvaltet","Personlig pleje",{"v":0.82,"d":"kr. 0.82"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":24.941666666666663,"d":"kr. 24.94"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":299.29999999999995,"d":"kr. 299.30"}}]
[null,"Selvforvaltet","Indkøb",{"v":5.48,"d":"kr. 5.48"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":166.68333333333334,"d":"kr. 166.68"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":2000.2,"d":"kr. 2,000.20"}}]
[null,"Selvforvaltet","Velgørenhed",{"v":1.64,"d":"kr. 1.64"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":49.883333333333326,"d":"kr. 49.88"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":598.5999999999999,"d":"kr. 598.60"}}]
[null,"Selvforvaltet","Foreninger/medlemskaber",{"v":0.82,"d":"kr. 0.82"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":24.941666666666663,"d":"kr. 24.94"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":299.29999999999995,"d":"kr. 299.30"}}]
[null,"Selvforvaltet","Forbedringer i hjemmet",{"v":13.15,"d":"kr. 13.15"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":399.9791666666667,"d":"kr. 399.98"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":4799.75,"d":"kr. 4,799.75"}}]
[null,"Selvforvaltet","Andet 1",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Selvforvaltet","Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Opsparing","Kontantreserver",{"v":13.7,"d":"kr. 13.70"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":416.7083333333333,"d":"kr. 416.71"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":5000.5,"d":"kr. 5,000.50"}}]
[null,"Opsparing","Pensionsopsparing",{"v":32.88,"d":"kr. 32.88"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":1000.1,"d":"kr. 1,000.10"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":12001.2,"d":"kr. 12,001.20"}}]
[null,"Opsparing","Opsparingskonto",{"v":16.44,"d":"kr. 16.44"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":500.05,"d":"kr. 500.05"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":6000.6,"d":"kr. 6,000.60"}}]
[null,"Opsparing","Andet 1",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Opsparing","Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Dagligt[[#This Row],[Årligt]]/12","v":{"v":0,"d":"kr. 0.00"}},{"$f":"Dagligt[[#This Row],[Dagligt]]*365","v":{"v":0,"d":"kr. 0.00"}}]
[null," Total ",null,{"$f":"SUMIF(Dagligt[Type],\"Indtægt\",Dagligt[Dagligt])-SUMIF(Dagligt[Type],\"<>Indtægt\",Dagligt[Dagligt])","v":{"v":107.10000000000014,"d":"kr. 107.10"}},{"$f":"SUMIF(Dagligt[Type],\"Indtægt\",Dagligt[Månedligt])-SUMIF(Dagligt[Type],\"<>Indtægt\",Dagligt[Månedligt])","v":{"v":3257.625,"d":"kr. 3,257.63"}},{"$f":"SUMIF(Dagligt[Type],\"Indtægt\",Dagligt[Årligt])-SUMIF(Dagligt[Type],\"<>Indtægt\",Dagligt[Årligt])","v":{"v":39091.500000000015,"d":"kr. 39,091.50"}}]

{"sheet":"Månedlig pengestrøm","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"PERSONLIG PENGESTRØM",{"$nulls":15}," "]
[null,null,"Månedlig pengestrøm i alt:",{"$f":"MånedligtCashflowTilDato","v":{"v":18380,"d":"kr. 18,380.00"}},null,"BEMÆRK! For daglige poster skal du anslå det månedlige beløb/værdien og skrive værdien i kolonnen for den relevante måned.\n"]
[]
[null,"Type","Beskrivelse","Jan","Feb","Mar","Apr","Maj","Jun","Jul","Aug","Sep","Okt","Nov","Dec","I alt"]
[null,"Indtægt","Løn",{"v":7500,"d":"kr. 7,500.00"},{"v":7500,"d":"kr. 7,500.00"},{"v":7500,"d":"kr. 7,500.00"},{"v":7500,"d":"kr. 7,500.00"},{"v":7500,"d":"kr. 7,500.00"},{"v":7500,"d":"kr. 7,500.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"kr. 45,000.00"}}]
[null,"Indtægt","Provisioner/bonus",{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"v":500,"d":"kr. 500.00"},{"v":200,"d":"kr. 200.00"},{"v":0,"d":"kr. 0.00"},{"v":600,"d":"kr. 600.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"kr. 2,100.00"}}]
[null,"Indtægt","Andet 1",{"v":2500,"d":"kr. 2,500.00"},{"v":2500,"d":"kr. 2,500.00"},{"v":2500,"d":"kr. 2,500.00"},{"v":2500,"d":"kr. 2,500.00"},{"v":2500,"d":"kr. 2,500.00"},{"v":2500,"d":"kr. 2,500.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"kr. 15,000.00"}}]
[null,"Indtægt","Andet 2",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Indtægt","Andet 3",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Indtægt","Andet 4",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Sundhedsforsikring",{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"kr. 7,500.00"}}]
[null,"Udgifter","Indkomstskat",{"v":208.33333333333334,"d":"kr. 208.33"},{"v":208.33333333333334,"d":"kr. 208.33"},{"v":208.33333333333334,"d":"kr. 208.33"},{"v":208.33333333333334,"d":"kr. 208.33"},{"v":208.33333333333334,"d":"kr. 208.33"},{"v":208.33333333333334,"d":"kr. 208.33"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"kr. 1,250.00"}}]
[null,"Udgifter","Vægtafgift",{"v":16.666666666666668,"d":"kr. 16.67"},{"v":16.666666666666668,"d":"kr. 16.67"},{"v":16.666666666666668,"d":"kr. 16.67"},{"v":16.666666666666668,"d":"kr. 16.67"},{"v":16.666666666666668,"d":"kr. 16.67"},{"v":16.666666666666668,"d":"kr. 16.67"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"kr. 100.00"}}]
[null,"Udgifter","Afbetaling af bil",{"v":333.3333333333333,"d":"kr. 333.33"},{"v":333.3333333333333,"d":"kr. 333.33"},{"v":333.3333333333333,"d":"kr. 333.33"},{"v":333.3333333333333,"d":"kr. 333.33"},{"v":333.3333333333333,"d":"kr. 333.33"},{"v":333.3333333333333,"d":"kr. 333.33"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"kr. 2,000.00"}}]
[null,"Udgifter","Realkreditlån/leje",{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"v":1250,"d":"kr. 1,250.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"kr. 7,500.00"}}]
[null,"Udgifter","Forsikring",{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"kr. 150.00"}}]
[null,"Udgifter","El",{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"v":100,"d":"kr. 100.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"kr. 600.00"}}]
[null,"Udgifter","Benzin",{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Udgifter","Vand",{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Udgifter","Kloakafgift",{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"kr. 150.00"}}]
[null,"Udgifter","Renovation",{"v":12.5,"d":"kr. 12.50"},{"v":12.5,"d":"kr. 12.50"},{"v":12.5,"d":"kr. 12.50"},{"v":12.5,"d":"kr. 12.50"},{"v":12.5,"d":"kr. 12.50"},{"v":12.5,"d":"kr. 12.50"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"kr. 75.00"}}]
[null,"Udgifter","Telefonnummer",{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Udgifter","Internet",{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Udgifter","Handicap-præmier",{"v":125,"d":"kr. 125.00"},{"v":125,"d":"kr. 125.00"},{"v":125,"d":"kr. 125.00"},{"v":125,"d":"kr. 125.00"},{"v":125,"d":"kr. 125.00"},{"v":125,"d":"kr. 125.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"kr. 750.00"}}]
[null,"Udgifter","Mad",{"v":400,"d":"kr. 400.00"},{"v":500,"d":"kr. 500.00"},{"v":450,"d":"kr. 450.00"},{"v":400,"d":"kr. 400.00"},{"v":450,"d":"kr. 450.00"},{"v":425,"d":"kr. 425.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"kr. 2,625.00"}}]
[null,"Udgifter","Beklædning",{"v":50,"d":"kr. 50.00"},{"v":75,"d":"kr. 75.00"},{"v":100,"d":"kr. 100.00"},{"v":75,"d":"kr. 75.00"},{"v":125,"d":"kr. 125.00"},{"v":75,"d":"kr. 75.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"kr. 500.00"}}]
[null,"Udgifter","Medicin/tandlæge",{"v":50,"d":"kr. 50.00"},{"v":10,"d":"kr. 10.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":20,"d":"kr. 20.00"},{"v":70,"d":"kr. 70.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"kr. 200.00"}}]
[null,"Udgifter","Bus",{"v":30,"d":"kr. 30.00"},{"v":30,"d":"kr. 30.00"},{"v":30,"d":"kr. 30.00"},{"v":20,"d":"kr. 20.00"},{"v":30,"d":"kr. 30.00"},{"v":30,"d":"kr. 30.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"kr. 170.00"}}]
[null,"Udgifter","Andet 2",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Andet 3",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Udgifter","Andet 4",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Selvforvaltet","Restaurant",{"v":50,"d":"kr. 50.00"},{"v":150,"d":"kr. 150.00"},{"v":100,"d":"kr. 100.00"},{"v":50,"d":"kr. 50.00"},{"v":150,"d":"kr. 150.00"},{"v":100,"d":"kr. 100.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"kr. 600.00"}}]
[null,"Selvforvaltet","Gaver",{"v":25,"d":"kr. 25.00"},{"v":75,"d":"kr. 75.00"},{"v":50,"d":"kr. 50.00"},{"v":25,"d":"kr. 25.00"},{"v":75,"d":"kr. 75.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Selvforvaltet","Rejser",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":1000,"d":"kr. 1,000.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":1000,"d":"kr. 1,000.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"kr. 2,000.00"}}]
[null,"Selvforvaltet","Underholdning",{"v":50,"d":"kr. 50.00"},{"v":150,"d":"kr. 150.00"},{"v":100,"d":"kr. 100.00"},{"v":50,"d":"kr. 50.00"},{"v":150,"d":"kr. 150.00"},{"v":100,"d":"kr. 100.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"kr. 600.00"}}]
[null,"Selvforvaltet","Personlig pleje",{"v":15,"d":"kr. 15.00"},{"v":25,"d":"kr. 25.00"},{"v":35,"d":"kr. 35.00"},{"v":15,"d":"kr. 15.00"},{"v":25,"d":"kr. 25.00"},{"v":35,"d":"kr. 35.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"kr. 150.00"}}]
[null,"Selvforvaltet","Indkøb",{"v":100,"d":"kr. 100.00"},{"v":200,"d":"kr. 200.00"},{"v":150,"d":"kr. 150.00"},{"v":175,"d":"kr. 175.00"},{"v":150,"d":"kr. 150.00"},{"v":175,"d":"kr. 175.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"kr. 950.00"}}]
[null,"Selvforvaltet","Velgørenhed",{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"v":50,"d":"kr. 50.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"kr. 300.00"}}]
[null,"Selvforvaltet","Foreninger/medlemskaber",{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"v":25,"d":"kr. 25.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"kr. 150.00"}}]
[null,"Selvforvaltet","Forbedringer i hjemmet",{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"v":400,"d":"kr. 400.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"kr. 2,400.00"}}]
[null,"Selvforvaltet","Andet 1",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Selvforvaltet","Andet 2",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Opsparing","Kontantreserver",{"v":416.6666666666667,"d":"kr. 416.67"},{"v":416.6666666666667,"d":"kr. 416.67"},{"v":416.6666666666667,"d":"kr. 416.67"},{"v":416.6666666666667,"d":"kr. 416.67"},{"v":416.6666666666667,"d":"kr. 416.67"},{"v":416.6666666666667,"d":"kr. 416.67"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"kr. 2,500.00"}}]
[null,"Opsparing","Pensionsopsparing",{"v":1000,"d":"kr. 1,000.00"},{"v":1000,"d":"kr. 1,000.00"},{"v":1000,"d":"kr. 1,000.00"},{"v":1000,"d":"kr. 1,000.00"},{"v":1000,"d":"kr. 1,000.00"},{"v":1000,"d":"kr. 1,000.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"kr. 6,000.00"}}]
[null,"Opsparing","Opsparingskonto",{"v":500,"d":"kr. 500.00"},{"v":500,"d":"kr. 500.00"},{"v":500,"d":"kr. 500.00"},{"v":500,"d":"kr. 500.00"},{"v":500,"d":"kr. 500.00"},{"v":500,"d":"kr. 500.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"kr. 3,000.00"}}]
[null,"Opsparing","Andet 1",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Opsparing","Andet 2",{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"v":0,"d":"kr. 0.00"},{"$nulls":6},{"$f":"SUM(Månedligt[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"kr. 0.00"}}]
[null," Total",null,{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Jan])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Jan])","v":{"v":3692.5,"d":"kr. 3,692.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Feb])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Feb])","v":{"v":3247.5,"d":"kr. 3,247.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Mar])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Mar])","v":{"v":2522.5,"d":"kr. 2,522.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Apr])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Apr])","v":{"v":3427.5,"d":"kr. 3,427.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Maj])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Maj])","v":{"v":2887.5,"d":"kr. 2,887.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Jun])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Jun])","v":{"v":2602.5,"d":"kr. 2,602.50"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Jul])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Jul])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Aug])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Aug])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Sep])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Sep])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Okt])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Okt])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Nov])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Nov])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[Dec])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[Dec])","v":{"v":0,"d":"kr. 0.00"}},{"$f":"SUMIF(Månedligt[Type],\"Indtægt\",Månedligt[I alt])-SUMIF(Månedligt[Type],\"<>Indtægt\",Månedligt[I alt])","v":{"v":18380,"d":"kr. 18,380.00"}}]

{"sheet":"Årlig pengestrøm","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"merged":[[1,3,1,4],[1,6,1,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[7,2,7,3],[7,6,7,7],[7,10,7,11],[7,14,7,15]]}
[null,"PERSONLIG PENGESTRØM",{"$nulls":14}," "]
[null,null,"Samlet pengestrøm til dato:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"kr. 42,250.00"}},null,null,"Det er et skøn for året. Brug dette regneark, hvis du vil have vist årlige beløb med anslåede månedlige værdier. Brug regnearkene Indtægter, Udgifter, Skøn og Opsparing til at angive elementer."]
[]
[null,"OVERSIGT OVER INDTÆGTER",{"$nulls":3},"OVERSIGT OVER UDGIFTER",{"$nulls":3},"OVERSIGT OVER SKØN",{"$nulls":3},"OVERSIGT OVER OPSPARING"]
[null,"Årligt samlet beløb:",{"$f":"Indtægt!C11","v":{"v":125000,"d":"kr. 125,000.00"}},null,null,"Årligt samlet beløb:",{"$f":"Udgifter[[#Totals],[Årligt  ]]","v":{"v":46500,"d":"kr. 46,500.00"}},null,null,"Årligt samlet beløb:",{"$f":"Selvforvaltet[[#Totals],[Årligt  ]]","v":{"v":13250,"d":"kr. 13,250.00"}},null,null,"Årligt samlet beløb:",{"$f":"Besparelser[[#Totals],[Årligt  ]]","v":{"v":23000,"d":"kr. 23,000.00"}}]
[]
[]
[null,"Månedligt samlet beløb:",{"$f":"Indtægt!D11","v":{"v":10416.666666666668,"d":"kr. 10,416.67"}},null,null,"Månedligt samlet beløb:",{"$f":"Udgifter[[#Totals],[Månedligt ]]","v":{"v":3875,"d":"kr. 3,875.00"}},null,null,"Månedligt samlet beløb:",{"$f":"Selvforvaltet[[#Totals],[Månedligt ]]","v":{"v":1104.1666666666665,"d":"kr. 1,104.17"}},null,null,"Månedligt samlet beløb:",{"$f":"Besparelser!D10","v":{"v":1916.6666666666667,"d":"kr. 1,916.67"}}]
[]
[{"$nulls":17},"Rækkemærkater","Årlig indtægt",null,"Rækkemærkater","Summen af årlige beløb",null,"Rækkemærkater","Summen af årlige beløb",null,"Rækkemærkater","Summen af årlige beløb"]
[{"$nulls":17},"Andet 3",{"v":0,"d":"kr. 0"},null,"Andet 1",{"v":0,"d":"kr. 0"},null,"Andet 2",{"v":0,"d":"kr. 0"},null,"Andet 1",{"v":0,"d":"kr. 0"}]
[{"$nulls":17},"Andet 4",{"v":0,"d":"kr. 0"},null,"Andet 2",{"v":0,"d":"kr. 0"},null,"Andet 1",{"v":0,"d":"kr. 0"},null,"Andet 2",{"v":0,"d":"kr. 0"}]
[{"$nulls":17},"Andet 2",{"v":0,"d":"kr. 0"},null,"Renovation",{"v":150,"d":"kr. 150"},null,"Foreninger/medlemskaber",{"v":300,"d":"kr. 300"},null,"Kontantreserver",{"v":5000,"d":"kr. 5,000"}]
[{"$nulls":17},"Provisioner/bonus",{"v":5000,"d":"kr. 5,000"},null,"Vægtafgift",{"v":200,"d":"kr. 200"},null,"Personlig pleje",{"v":300,"d":"kr. 300"},null,"Opsparing/investering",{"v":6000,"d":"kr. 6,000"}]
[{"$nulls":17},"Andet 1",{"v":30000,"d":"kr. 30,000"},null,"Forsikring",{"v":250,"d":"kr. 250"},null,"Gaver",{"v":600,"d":"kr. 600"},null,"Pensionsopsparing",{"v":12000,"d":"kr. 12,000"}]
[{"$nulls":17},"Løn",{"v":90000,"d":"kr. 90,000"},null,"Internet",{"v":600,"d":"kr. 600"},null,"Velgørenhed",{"v":600,"d":"kr. 600"},null,"Samlet i alt",{"v":23000,"d":"kr. 23,000"}]
[{"$nulls":17},"Samlet i alt",{"v":125000,"d":"kr. 125,000"},null,"Medicin/tandlæge",{"v":600,"d":"kr. 600"},null,"Restaurant",{"v":1200,"d":"kr. 1,200"}]
[{"$nulls":20},"Vand/kloak",{"v":600,"d":"kr. 600"},null,"Underholdning",{"v":1200,"d":"kr. 1,200"}]
[{"$nulls":20},"Benzin",{"v":600,"d":"kr. 600"},null,"Indkøb",{"v":2000,"d":"kr. 2,000"}]
[{"$nulls":20},"Telefonnummer",{"v":600,"d":"kr. 600"},null,"Rejser",{"v":2250,"d":"kr. 2,250"}]
[{"$nulls":20},"Beklædning",{"v":1200,"d":"kr. 1,200"},null,"Forbedringer i hjemmet",{"v":4800,"d":"kr. 4,800"}]
[{"$nulls":20},"El",{"v":1200,"d":"kr. 1,200"},null,"Samlet i alt",{"v":13250,"d":"kr. 13,250"}]
[{"$nulls":20},"Handicap-præmier",{"v":1500,"d":"kr. 1,500"}]
[{"$nulls":20},"Indkomstskat",{"v":2500,"d":"kr. 2,500"}]
[{"$nulls":20},"Afbetaling af bil",{"v":4000,"d":"kr. 4,000"}]
[{"$nulls":20},"Mad",{"v":5000,"d":"kr. 5,000"}]
[{"$nulls":20},"Sundhedsforsikring",{"v":12500,"d":"kr. 12,500"}]
[{"$nulls":20},"Realkreditlån/leje",{"v":15000,"d":"kr. 15,000"}]
[{"$nulls":20},"Samlet i alt",{"v":46500,"d":"kr. 46,500"}]

{"sheet":"Indtægt","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIG PENGESTRØM"]
[null,null,"Samlet pengestrøm til dato:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"kr. 42,250.00"}},null,"Det er et skøn for året. Brug dette regneark, hvis du vil have vist årlige beløb med anslåede månedlige værdier.\nHvis du vil føje daglige poster til tabellerne, skal du anslå det årlige beløb/den årlige værdi og skrive værdien i kolonnen Årligt."]
[]
[null,"Indtægt","Årligt  ","Månedligt "]
[null,"Løn",{"v":90000,"d":"kr. 90,000.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":7500,"d":"kr. 7,500.00"}}]
[null,"Provisioner/bonus",{"v":5000,"d":"kr. 5,000.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":416.6666666666667,"d":"kr. 416.67"}}]
[null,"Andet 1",{"v":30000,"d":"kr. 30,000.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":2500,"d":"kr. 2,500.00"}}]
[null,"Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet 3",{"v":0,"d":"kr. 0.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet 4",{"v":0,"d":"kr. 0.00"},{"$f":"Indtægt[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"  Total",{"$f":"SUBTOTAL(109,Indtægt[[Årligt  ]])","v":{"v":125000,"d":"kr. 125,000.00"}},{"$f":"SUBTOTAL(109,Indtægt[[Månedligt ]])","v":{"v":10416.666666666668,"d":"kr. 10,416.67"}}]

{"sheet":"Udgifter","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIG PENGESTRØM"]
[null,null,"Samlet pengestrøm til dato:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"kr. 42,250.00"}},null,"Det er et skøn for året. Brug dette regneark, hvis du vil have vist årlige beløb med anslåede månedlige værdier.\nHvis du vil føje daglige poster til tabellerne, skal du anslå det årlige beløb/den årlige værdi og skrive værdien i kolonnen Årligt."]
[]
[null,"Udgifter","Årligt  ","Månedligt "]
[null,"Sundhedsforsikring",{"v":12500,"d":"kr. 12,500.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":1041.6666666666667,"d":"kr. 1,041.67"}}]
[null,"Indkomstskat",{"v":2500,"d":"kr. 2,500.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":208.33333333333334,"d":"kr. 208.33"}}]
[null,"Vægtafgift",{"v":200,"d":"kr. 200.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":16.666666666666668,"d":"kr. 16.67"}}]
[null,"Afbetaling af bil",{"v":4000,"d":"kr. 4,000.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":333.3333333333333,"d":"kr. 333.33"}}]
[null,"Realkreditlån/leje",{"v":15000,"d":"kr. 15,000.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":1250,"d":"kr. 1,250.00"}}]
[null,"Forsikring",{"v":250,"d":"kr. 250.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":20.833333333333332,"d":"kr. 20.83"}}]
[null,"El",{"v":1200,"d":"kr. 1,200.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":100,"d":"kr. 100.00"}}]
[null,"Benzin",{"v":600,"d":"kr. 600.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Vand/kloak",{"v":600,"d":"kr. 600.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Renovation",{"v":150,"d":"kr. 150.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":12.5,"d":"kr. 12.50"}}]
[null,"Telefonnummer",{"v":600,"d":"kr. 600.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Internet",{"v":600,"d":"kr. 600.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Handicap-præmier",{"v":1500,"d":"kr. 1,500.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":125,"d":"kr. 125.00"}}]
[null,"Mad",{"v":5000,"d":"kr. 5,000.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":416.6666666666667,"d":"kr. 416.67"}}]
[null,"Beklædning",{"v":1200,"d":"kr. 1,200.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":100,"d":"kr. 100.00"}}]
[null,"Medicin/tandlæge",{"v":600,"d":"kr. 600.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Andet 1",{"v":0,"d":"kr. 0.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Udgifter[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"   Total",{"$f":"SUBTOTAL(109,Udgifter[[Årligt  ]])","v":{"v":46500,"d":"kr. 46,500.00"}},{"$f":"SUBTOTAL(109,Udgifter[[Månedligt ]])","v":{"v":3875,"d":"kr. 3,875.00"}}]

{"sheet":"Selvforvaltet","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIG PENGESTRØM"]
[null,null,"Samlet pengestrøm til dato:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"kr. 42,250.00"}},null,"Det er et skøn for året. Brug dette regneark, hvis du vil have vist årlige beløb med anslåede månedlige værdier.\nHvis du vil føje daglige poster til tabellerne, skal du anslå det årlige beløb/den årlige værdi og skrive værdien i kolonnen Årligt."]
[]
[null,"Selvforvaltet","Årligt  ","Månedligt "]
[null,"Restaurant",{"v":1200,"d":"kr. 1,200.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":100,"d":"kr. 100.00"}}]
[null,"Gaver",{"v":600,"d":"kr. 600.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Rejser",{"v":2250,"d":"kr. 2,250.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":187.5,"d":"kr. 187.50"}}]
[null,"Underholdning",{"v":1200,"d":"kr. 1,200.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":100,"d":"kr. 100.00"}}]
[null,"Personlig pleje",{"v":300,"d":"kr. 300.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":25,"d":"kr. 25.00"}}]
[null,"Indkøb",{"v":2000,"d":"kr. 2,000.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":166.66666666666666,"d":"kr. 166.67"}}]
[null,"Velgørenhed",{"v":600,"d":"kr. 600.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":50,"d":"kr. 50.00"}}]
[null,"Foreninger/medlemskaber",{"v":300,"d":"kr. 300.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":25,"d":"kr. 25.00"}}]
[null,"Forbedringer i hjemmet",{"v":4800,"d":"kr. 4,800.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":400,"d":"kr. 400.00"}}]
[null,"Andet 1",{"v":0,"d":"kr. 0.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Selvforvaltet[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"   Total",{"$f":"SUBTOTAL(109,Selvforvaltet[[Årligt  ]])","v":{"v":13250,"d":"kr. 13,250.00"}},{"$f":"SUBTOTAL(109,Selvforvaltet[[Månedligt ]])","v":{"v":1104.1666666666665,"d":"kr. 1,104.17"}}]

{"sheet":"Besparelser","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIG PENGESTRØM",{"$nulls":7}," "]
[null,null,"Samlet pengestrøm til dato:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"kr. 42,250.00"}},null,"Det er et skøn for året. Brug dette regneark, hvis du vil have vist årlige beløb med anslåede månedlige værdier.\nHvis du vil føje daglige poster til tabellerne, skal du anslå det årlige beløb/den årlige værdi og skrive værdien i kolonnen Årligt."]
[]
[null,"Besparelser","Årligt  ","Månedligt "]
[null,"Kontantreserver",{"v":5000,"d":"kr. 5,000.00"},{"$f":"Besparelser[[#This Row],[Årligt  ]]/12","v":{"v":416.6666666666667,"d":"kr. 416.67"}}]
[null,"Pensionsopsparing",{"v":12000,"d":"kr. 12,000.00"},{"$f":"Besparelser[[#This Row],[Årligt  ]]/12","v":{"v":1000,"d":"kr. 1,000.00"}}]
[null,"Opsparing/investering",{"v":6000,"d":"kr. 6,000.00"},{"$f":"Besparelser[[#This Row],[Årligt  ]]/12","v":{"v":500,"d":"kr. 500.00"}}]
[null,"Andet 1",{"v":0,"d":"kr. 0.00"},{"$f":"Besparelser[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"Andet 2",{"v":0,"d":"kr. 0.00"},{"$f":"Besparelser[[#This Row],[Årligt  ]]/12","v":{"v":0,"d":"kr. 0.00"}}]
[null,"   Total",{"$f":"SUBTOTAL(109,Besparelser[[Årligt  ]])","v":{"v":23000,"d":"kr. 23,000.00"}},{"$f":"SUBTOTAL(109,Besparelser[[Månedligt ]])","v":{"v":1916.6666666666667,"d":"kr. 1,916.67"}}]