{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Dagligt kassaflöde","Månatligt kassaflöde","Årligt kassaflöde","Inkomster","Utgifter","Övrigt","Sparande"],"not_rendered":{"charts":4,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"PERSONLIGT KASSAFLÖDE"]
[null,"  Den här arbetsboken innehåller kalkylblad för årligt, månatligt och dagligt kassaflöde. \n  Välj den typ av kassaflöde som fungerar bäst för dig, eller använd alla för en insikt i ditt personliga kassaflöde."]
[]
[null,"Dagligt kassaflöde",null,null,"Månatligt kassaflöde",null,null,"Årligt kassaflöde"]
[]
[null,"Ange det uppskattade kassaflödesbeloppet för varje dag och granska de uppskattade månatliga och årliga totalsummorna.  Få med hjälp av det här en insikt i hur dina dagliga utgifter ser ut under en månad eller ett år.",null,null,"Ange det månatliga kassaflödet för varje månad eller uppskatta de återstående månaderna om du vill se det beräknade kassaflödet för året för varje månad.",null,null,"Ange ett årligt kassaflödesbelopp i fyra kalkylblad: Intäkter, Utgifter, Övrigt och Sparande. \nDu kan se den månatliga fördelningen, jämföra de olika områdena och, viktigast av allt, se vad slutresultatet är i siffror både per år och månad."]

{"sheet":"Dagligt kassaflöde","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"PERSONLIGT KASSAFLÖDE"]
[null,null,"Summa tillgängliga kontanter:",{"$f":"DagligtKassaflöde","v":{"v":577.8399999999999,"d":"577.84 kr"}},null,"OBS! Om du vill lägga till dagliga poster i tabellen uppskattar du deras månatliga belopp/värde och placerar värdet i rätt månadskolumn."]
[]
[null,"DAGLIG ÖVERSIKT"]
[null,"Totalsummor","Daglig","Månatlig","Årlig "]
[null,"Inkomster",{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Daglig])","v":{"v":342.47,"d":"342.47 kr"}},{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Månatlig])","v":{"v":10416.795833333334,"d":"10,416.80 kr"}},{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Årlig])","v":{"v":125001.55000000002,"d":"125,001.55 kr"}}]
[null,"Utgifter",{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Daglig])","v":{"v":136.05999999999997,"d":"136.06 kr"}},{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Månatlig])","v":{"v":4138.491666666667,"d":"4,138.49 kr"}},{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Årlig])","v":{"v":49661.899999999994,"d":"49,661.90 kr"}}]
[null,"Övrigt",{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Daglig])","v":{"v":36.29,"d":"36.29 kr"}},{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Månatlig])","v":{"v":1103.8208333333334,"d":"1,103.82 kr"}},{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Årlig])","v":{"v":13245.849999999999,"d":"13,245.85 kr"}}]
[null,"Sparande",{"$f":"SUMIF(Daglig[Typ],$B9,Daglig[Daglig])","v":{"v":63.019999999999996,"d":"63.02 kr"}},{"$f":"SUMIF(Daglig[Typ],$B9,Daglig[Månatlig])","v":{"v":1916.8583333333333,"d":"1,916.86 kr"}},{"$f":"SUMIF(Daglig[Typ],$B9,Daglig[Årlig])","v":{"v":23002.300000000003,"d":"23,002.30 kr"}}]
[]
[null,"Typ","Beskrivning","Daglig","Månatlig","Årlig"]
[null,"Inkomster","Lön",{"v":246.58,"d":"246.58 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":7500.141666666667,"d":"7,500.14 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":90001.70000000001,"d":"90,001.70 kr"}}]
[null,"Inkomster","Provisioner/bonus",{"v":13.7,"d":"13.70 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":416.7083333333333,"d":"416.71 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":5000.5,"d":"5,000.50 kr"}}]
[null,"Inkomster","Övrigt 1",{"v":82.19,"d":"82.19 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":2499.945833333333,"d":"2,499.95 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":29999.35,"d":"29,999.35 kr"}}]
[null,"Inkomster","Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Inkomster","Övrigt 3",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Inkomster","Övrigt 4",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Statlig inkomstskatt/egenavgifter/sjukförsäkring",{"v":41.1,"d":"41.10 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":1250.125,"d":"1,250.13 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":15001.5,"d":"15,001.50 kr"}}]
[null,"Utgifter","Kommunal inkomstskatt",{"v":6.85,"d":"6.85 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":208.35416666666666,"d":"208.35 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":2500.25,"d":"2,500.25 kr"}}]
[null,"Utgifter","Fordonsskatt/avgifter",{"v":0.55,"d":"0.55 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":16.729166666666668,"d":"16.73 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":200.75000000000003,"d":"200.75 kr"}}]
[null,"Utgifter","Avbetalningar fordon",{"v":10.96,"d":"10.96 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":333.3666666666667,"d":"333.37 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":4000.4,"d":"4,000.40 kr"}}]
[null,"Utgifter","Avbetalning bostad/hyra",{"v":41.1,"d":"41.10 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":1250.125,"d":"1,250.13 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":15001.5,"d":"15,001.50 kr"}}]
[null,"Utgifter","Försäkring",{"v":0.68,"d":"0.68 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":20.683333333333334,"d":"20.68 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":248.20000000000002,"d":"248.20 kr"}}]
[null,"Utgifter","Elektricitet",{"v":3.29,"d":"3.29 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":100.07083333333333,"d":"100.07 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":1200.85,"d":"1,200.85 kr"}}]
[null,"Utgifter","Bensin",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Utgifter","Vatten",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Utgifter","Avlopp",{"v":0.82,"d":"0.82 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":24.941666666666663,"d":"24.94 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":299.29999999999995,"d":"299.30 kr"}}]
[null,"Utgifter","Sophantering",{"v":0.41,"d":"0.41 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":12.470833333333331,"d":"12.47 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":149.64999999999998,"d":"149.65 kr"}}]
[null,"Utgifter","Telefon",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Utgifter","Internet",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Utgifter","Funktionsnedsättningshjälp",{"v":4.11,"d":"4.11 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":125.0125,"d":"125.01 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":1500.15,"d":"1,500.15 kr"}}]
[null,"Utgifter","Mat",{"v":13.7,"d":"13.70 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":416.7083333333333,"d":"416.71 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":5000.5,"d":"5,000.50 kr"}}]
[null,"Utgifter","Kläder",{"v":3.29,"d":"3.29 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":100.07083333333333,"d":"100.07 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":1200.85,"d":"1,200.85 kr"}}]
[null,"Utgifter","Sjukvård/Tandvård/Läkemedel",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Utgifter","Buss",{"v":1,"d":"1.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":30.416666666666668,"d":"30.42 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":365,"d":"365.00 kr"}}]
[null,"Utgifter","Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Övrigt 3",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Övrigt 4",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt","Restaurang",{"v":3.29,"d":"3.29 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":100.07083333333333,"d":"100.07 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":1200.85,"d":"1,200.85 kr"}}]
[null,"Övrigt","Gåvor",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Övrigt","Resor",{"v":6.16,"d":"6.16 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":187.36666666666667,"d":"187.37 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":2248.4,"d":"2,248.40 kr"}}]
[null,"Övrigt","Nöjen",{"v":3.29,"d":"3.29 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":100.07083333333333,"d":"100.07 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":1200.85,"d":"1,200.85 kr"}}]
[null,"Övrigt","Kroppsvård",{"v":0.82,"d":"0.82 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":24.941666666666663,"d":"24.94 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":299.29999999999995,"d":"299.30 kr"}}]
[null,"Övrigt","Shopping",{"v":5.48,"d":"5.48 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":166.68333333333334,"d":"166.68 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":2000.2,"d":"2,000.20 kr"}}]
[null,"Övrigt","Välgörenhet",{"v":1.64,"d":"1.64 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":49.883333333333326,"d":"49.88 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":598.5999999999999,"d":"598.60 kr"}}]
[null,"Övrigt","Förening/medlemskap",{"v":0.82,"d":"0.82 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":24.941666666666663,"d":"24.94 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":299.29999999999995,"d":"299.30 kr"}}]
[null,"Övrigt","Renoveringar",{"v":13.15,"d":"13.15 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":399.9791666666667,"d":"399.98 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":4799.75,"d":"4,799.75 kr"}}]
[null,"Övrigt","Övrigt 1",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt","Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Sparande","Kassareserver",{"v":13.7,"d":"13.70 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":416.7083333333333,"d":"416.71 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":5000.5,"d":"5,000.50 kr"}}]
[null,"Sparande","Pensionssparande",{"v":32.88,"d":"32.88 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":1000.1,"d":"1,000.10 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":12001.2,"d":"12,001.20 kr"}}]
[null,"Sparande","Sparkonto",{"v":16.44,"d":"16.44 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":500.05,"d":"500.05 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":6000.6,"d":"6,000.60 kr"}}]
[null,"Sparande","Övrigt 1",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Sparande","Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Daglig[[#This Row],[Årlig]]/12","v":{"v":0,"d":"0.00 kr"}},{"$f":"Daglig[[#This Row],[Daglig]]*365","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",null,{"$f":"SUMIF(Daglig[Typ],\"Inkomster\",Daglig[Daglig])-SUMIF(Daglig[Typ],\"<>Inkomster\",Daglig[Daglig])","v":{"v":107.10000000000014,"d":"107.10 kr"}},{"$f":"SUMIF(Daglig[Typ],\"Inkomster\",Daglig[Månatlig])-SUMIF(Daglig[Typ],\"<>Inkomster\",Daglig[Månatlig])","v":{"v":3257.625,"d":"3,257.63 kr"}},{"$f":"SUMIF(Daglig[Typ],\"Inkomster\",Daglig[Årlig])-SUMIF(Daglig[Typ],\"<>Inkomster\",Daglig[Årlig])","v":{"v":39091.500000000015,"d":"39,091.50 kr"}}]

{"sheet":"Månatligt kassaflöde","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":15}," "]
[null,null,"Månatlig kassaflödessumma:",{"$f":"MånatligtKassaflödeHittills","v":{"v":18380,"d":"18,380.00 kr"}},null,"Obs! Uppskatta det månatliga beloppet/värdet för dagliga poster, och placera det värdet i rätt månadskolumn.\n"]
[]
[null,"Typ","Beskrivning","Jan","Feb","Mars","Apr","Maj","Jun","Jul","Aug","Sep","Okt","Nov","Dec","Summa"]
[null,"Inkomster","Lön",{"v":7500,"d":"7,500.00 kr"},{"v":7500,"d":"7,500.00 kr"},{"v":7500,"d":"7,500.00 kr"},{"v":7500,"d":"7,500.00 kr"},{"v":7500,"d":"7,500.00 kr"},{"v":7500,"d":"7,500.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"45,000.00 kr"}}]
[null,"Inkomster","Provisioner/bonus",{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"v":500,"d":"500.00 kr"},{"v":200,"d":"200.00 kr"},{"v":0,"d":"0.00 kr"},{"v":600,"d":"600.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"2,100.00 kr"}}]
[null,"Inkomster","Övrigt 1",{"v":2500,"d":"2,500.00 kr"},{"v":2500,"d":"2,500.00 kr"},{"v":2500,"d":"2,500.00 kr"},{"v":2500,"d":"2,500.00 kr"},{"v":2500,"d":"2,500.00 kr"},{"v":2500,"d":"2,500.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"15,000.00 kr"}}]
[null,"Inkomster","Övrigt 2",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Inkomster","Övrigt 3",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Inkomster","Övrigt 4",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Statlig inkomstskatt/egenavgifter/sjukförsäkring",{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 kr"}}]
[null,"Utgifter","Kommunal inkomstskatt",{"v":208.33333333333334,"d":"208.33 kr"},{"v":208.33333333333334,"d":"208.33 kr"},{"v":208.33333333333334,"d":"208.33 kr"},{"v":208.33333333333334,"d":"208.33 kr"},{"v":208.33333333333334,"d":"208.33 kr"},{"v":208.33333333333334,"d":"208.33 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"1,250.00 kr"}}]
[null,"Utgifter","Fordonsskatt/avgifter",{"v":16.666666666666668,"d":"16.67 kr"},{"v":16.666666666666668,"d":"16.67 kr"},{"v":16.666666666666668,"d":"16.67 kr"},{"v":16.666666666666668,"d":"16.67 kr"},{"v":16.666666666666668,"d":"16.67 kr"},{"v":16.666666666666668,"d":"16.67 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"100.00 kr"}}]
[null,"Utgifter","Avbetalningar fordon",{"v":333.3333333333333,"d":"333.33 kr"},{"v":333.3333333333333,"d":"333.33 kr"},{"v":333.3333333333333,"d":"333.33 kr"},{"v":333.3333333333333,"d":"333.33 kr"},{"v":333.3333333333333,"d":"333.33 kr"},{"v":333.3333333333333,"d":"333.33 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"2,000.00 kr"}}]
[null,"Utgifter","Avbetalning bostad/hyra",{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"v":1250,"d":"1,250.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 kr"}}]
[null,"Utgifter","Försäkring",{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 kr"}}]
[null,"Utgifter","Elektricitet",{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"v":100,"d":"100.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 kr"}}]
[null,"Utgifter","Bensin",{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Utgifter","Vatten",{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Utgifter","Avlopp",{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 kr"}}]
[null,"Utgifter","Sophantering",{"v":12.5,"d":"12.50 kr"},{"v":12.5,"d":"12.50 kr"},{"v":12.5,"d":"12.50 kr"},{"v":12.5,"d":"12.50 kr"},{"v":12.5,"d":"12.50 kr"},{"v":12.5,"d":"12.50 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"75.00 kr"}}]
[null,"Utgifter","Telefon",{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Utgifter","Internet",{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Utgifter","Funktionsnedsättningshjälp",{"v":125,"d":"125.00 kr"},{"v":125,"d":"125.00 kr"},{"v":125,"d":"125.00 kr"},{"v":125,"d":"125.00 kr"},{"v":125,"d":"125.00 kr"},{"v":125,"d":"125.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"750.00 kr"}}]
[null,"Utgifter","Mat",{"v":400,"d":"400.00 kr"},{"v":500,"d":"500.00 kr"},{"v":450,"d":"450.00 kr"},{"v":400,"d":"400.00 kr"},{"v":450,"d":"450.00 kr"},{"v":425,"d":"425.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"2,625.00 kr"}}]
[null,"Utgifter","Kläder",{"v":50,"d":"50.00 kr"},{"v":75,"d":"75.00 kr"},{"v":100,"d":"100.00 kr"},{"v":75,"d":"75.00 kr"},{"v":125,"d":"125.00 kr"},{"v":75,"d":"75.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"500.00 kr"}}]
[null,"Utgifter","Sjukvård/Tandvård/Läkemedel",{"v":50,"d":"50.00 kr"},{"v":10,"d":"10.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":20,"d":"20.00 kr"},{"v":70,"d":"70.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"200.00 kr"}}]
[null,"Utgifter","Buss",{"v":30,"d":"30.00 kr"},{"v":30,"d":"30.00 kr"},{"v":30,"d":"30.00 kr"},{"v":20,"d":"20.00 kr"},{"v":30,"d":"30.00 kr"},{"v":30,"d":"30.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"170.00 kr"}}]
[null,"Utgifter","Övrigt 2",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Övrigt 3",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Utgifter","Övrigt 4",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt","Restaurang",{"v":50,"d":"50.00 kr"},{"v":150,"d":"150.00 kr"},{"v":100,"d":"100.00 kr"},{"v":50,"d":"50.00 kr"},{"v":150,"d":"150.00 kr"},{"v":100,"d":"100.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 kr"}}]
[null,"Övrigt","Gåvor",{"v":25,"d":"25.00 kr"},{"v":75,"d":"75.00 kr"},{"v":50,"d":"50.00 kr"},{"v":25,"d":"25.00 kr"},{"v":75,"d":"75.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Övrigt","Resor",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"2,000.00 kr"}}]
[null,"Övrigt","Nöjen",{"v":50,"d":"50.00 kr"},{"v":150,"d":"150.00 kr"},{"v":100,"d":"100.00 kr"},{"v":50,"d":"50.00 kr"},{"v":150,"d":"150.00 kr"},{"v":100,"d":"100.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 kr"}}]
[null,"Övrigt","Kroppsvård",{"v":15,"d":"15.00 kr"},{"v":25,"d":"25.00 kr"},{"v":35,"d":"35.00 kr"},{"v":15,"d":"15.00 kr"},{"v":25,"d":"25.00 kr"},{"v":35,"d":"35.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 kr"}}]
[null,"Övrigt","Shopping",{"v":100,"d":"100.00 kr"},{"v":200,"d":"200.00 kr"},{"v":150,"d":"150.00 kr"},{"v":175,"d":"175.00 kr"},{"v":150,"d":"150.00 kr"},{"v":175,"d":"175.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"950.00 kr"}}]
[null,"Övrigt","Välgörenhet",{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"v":50,"d":"50.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 kr"}}]
[null,"Övrigt","Förening/medlemskap",{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"v":25,"d":"25.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 kr"}}]
[null,"Övrigt","Renoveringar",{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"v":400,"d":"400.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"2,400.00 kr"}}]
[null,"Övrigt","Övrigt 1",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt","Övrigt 2",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Sparande","Kassareserver",{"v":416.6666666666667,"d":"416.67 kr"},{"v":416.6666666666667,"d":"416.67 kr"},{"v":416.6666666666667,"d":"416.67 kr"},{"v":416.6666666666667,"d":"416.67 kr"},{"v":416.6666666666667,"d":"416.67 kr"},{"v":416.6666666666667,"d":"416.67 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"2,500.00 kr"}}]
[null,"Sparande","Pensionssparande",{"v":1000,"d":"1,000.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"v":1000,"d":"1,000.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"6,000.00 kr"}}]
[null,"Sparande","Sparkonto",{"v":500,"d":"500.00 kr"},{"v":500,"d":"500.00 kr"},{"v":500,"d":"500.00 kr"},{"v":500,"d":"500.00 kr"},{"v":500,"d":"500.00 kr"},{"v":500,"d":"500.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"3,000.00 kr"}}]
[null,"Sparande","Övrigt 1",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Sparande","Övrigt 2",{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"v":0,"d":"0.00 kr"},{"$nulls":6},{"$f":"SUM(Månatlig[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",null,{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Jan])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Jan])","v":{"v":3692.5,"d":"3,692.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Feb])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Feb])","v":{"v":3247.5,"d":"3,247.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Mars])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Mars])","v":{"v":2522.5,"d":"2,522.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Apr])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Apr])","v":{"v":3427.5,"d":"3,427.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Maj])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Maj])","v":{"v":2887.5,"d":"2,887.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Jun])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Jun])","v":{"v":2602.5,"d":"2,602.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Jul])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Jul])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Aug])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Aug])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Sep])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Sep])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Okt])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Okt])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Nov])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Nov])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Dec])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Dec])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomster\",Månatlig[Summa])-SUMIF(Månatlig[Typ],\"<>Inkomster\",Månatlig[Summa])","v":{"v":18380,"d":"18,380.00 kr"}}]

{"sheet":"Årligt kassaflöde","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,"PERSONLIGT KASSAFLÖDE",{"$nulls":14}," "]
[null,null,"Kassaflöde totalsumma hittills:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"42,250.00 kr"}},null,null,"Det här är en årlig kalkyl.  Använd det här kalkylbladet om du vill visa årliga belopp med uppskattade månatliga värden. Använd kalkylbladen Intäkter, Utgifter, Övrigt och Sparande för att ange artiklar."]
[]
[null,"INKOMSTÖVERSIKT",{"$nulls":3},"UTGIFTSÖVERSIKT",{"$nulls":3},"ÖVERSIKT ÖVER ÖVRIGT",{"$nulls":3},"ÖVERSIKT ÖVER SPARANDE"]
[null,"Årlig totalsumma:",{"$f":"Inkomster!C11","v":{"v":125000,"d":"125,000.00 kr"}},null,null,"Årlig totalsumma:",{"$f":"Utgifter[[#Totals],[Årlig  ]]","v":{"v":46500,"d":"46,500.00 kr"}},null,null,"Årlig totalsumma:",{"$f":"Övrigt[[#Totals],[Årlig  ]]","v":{"v":13250,"d":"13,250.00 kr"}},null,null,"Årlig totalsumma:",{"$f":"Sparande[[#Totals],[Årlig  ]]","v":{"v":23000,"d":"23,000.00 kr"}}]
[]
[]
[null,"Månatlig totalsumma:",{"$f":"Inkomster!D11","v":{"v":10416.666666666668,"d":"10,416.67 kr"}},null,null,"Månatlig totalsumma:",{"$f":"Utgifter[[#Totals],[Månatlig ]]","v":{"v":3875,"d":"3,875.00 kr"}},null,null,"Månatlig totalsumma:",{"$f":"Övrigt[[#Totals],[Månatlig ]]","v":{"v":1104.1666666666665,"d":"1,104.17 kr"}},null,null,"Månatlig totalsumma:",{"$f":"Sparande!D10","v":{"v":1916.6666666666667,"d":"1,916.67 kr"}}]
[]
[{"$nulls":17},"Radetiketter","Årsinkomst",null,"Radetiketter","Summan av år",null,"Radetiketter","Summan av år",null,"Radetiketter","Summan av år"]
[{"$nulls":17},"Övrigt 2",{"v":0,"d":" 0 kr"},null,"Övrigt 2",{"v":0,"d":" 0 kr"},null,"Övrigt 2",{"v":0,"d":" 0 kr"},null,"Övrigt 2",{"v":0,"d":" 0 kr"}]
[{"$nulls":17},"Övrigt 3",{"v":0,"d":" 0 kr"},null,"Övrigt 1",{"v":0,"d":" 0 kr"},null,"Övrigt 1",{"v":0,"d":" 0 kr"},null,"Övrigt 1",{"v":0,"d":" 0 kr"}]
[{"$nulls":17},"Övrigt 4",{"v":0,"d":" 0 kr"},null,"Sophantering",{"v":150,"d":" 150 kr"},null,"Förening/medlemskap",{"v":300,"d":" 300 kr"},null,"Kassareserver",{"v":5000,"d":"5 000 kr"}]
[{"$nulls":17},"Provisioner/bonus",{"v":5000,"d":"5 000 kr"},null,"Fordonsskatt/avgifter",{"v":200,"d":" 200 kr"},null,"Kroppsvård",{"v":300,"d":" 300 kr"},null,"Sparande/investeringar",{"v":6000,"d":"6 000 kr"}]
[{"$nulls":17},"Övrigt 1",{"v":30000,"d":"30 000 kr"},null,"Försäkring",{"v":250,"d":" 250 kr"},null,"Välgörenhet",{"v":600,"d":" 600 kr"},null,"Pensionssparande",{"v":12000,"d":"12 000 kr"}]
[{"$nulls":17},"Lön",{"v":90000,"d":"90 000 kr"},null,"Internet",{"v":600,"d":" 600 kr"},null,"Gåvor",{"v":600,"d":" 600 kr"},null,"Totalsumma",{"v":23000,"d":"23 000 kr"}]
[{"$nulls":17},"Totalsumma",{"v":125000,"d":"125 000 kr"},null,"Sjukvård/Tandvård/Läkemedel",{"v":600,"d":" 600 kr"},null,"Nöjen",{"v":1200,"d":"1 200 kr"}]
[{"$nulls":20},"Bensin",{"v":600,"d":" 600 kr"},null,"Restaurang",{"v":1200,"d":"1 200 kr"}]
[{"$nulls":20},"Vatten/avlopp",{"v":600,"d":" 600 kr"},null,"Shopping",{"v":2000,"d":"2 000 kr"}]
[{"$nulls":20},"Telefon",{"v":600,"d":" 600 kr"},null,"Resor",{"v":2250,"d":"2 250 kr"}]
[{"$nulls":20},"Kläder",{"v":1200,"d":"1 200 kr"},null,"Renoveringar",{"v":4800,"d":"4 800 kr"}]
[{"$nulls":20},"Elektricitet",{"v":1200,"d":"1 200 kr"},null,"Totalsumma",{"v":13250,"d":"13 250 kr"}]
[{"$nulls":20},"Funktionsnedsättningshjälp",{"v":1500,"d":"1 500 kr"}]
[{"$nulls":20},"Kommunal inkomstskatt",{"v":2500,"d":"2 500 kr"}]
[{"$nulls":20},"Avbetalningar fordon",{"v":4000,"d":"4 000 kr"}]
[{"$nulls":20},"Mat",{"v":5000,"d":"5 000 kr"}]
[{"$nulls":20},"Statlig inkomstskatt/egenavgifter/sjukförsäkring",{"v":12500,"d":"12 500 kr"}]
[{"$nulls":20},"Avbetalning bostad/hyra",{"v":15000,"d":"15 000 kr"}]
[{"$nulls":20},"Totalsumma",{"v":46500,"d":"46 500 kr"}]

{"sheet":"Inkomster","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIGT KASSAFLÖDE"]
[null,null,"Kassaflöde totalsumma hittills:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"42,250.00 kr"}},null,"Det här är en årlig kalkyl.  Använd det här kalkylbladet om du vill visa årliga belopp med uppskattade månatliga värden.\nOm du vill lägga till dagliga poster i tabellen uppskattar du deras årliga belopp/värde och placerar värdet i rätt årskolumn."]
[]
[null,"Inkomster","Årlig  ","Månatlig "]
[null,"Lön",{"v":90000,"d":"90,000.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":7500,"d":"7,500.00 kr"}}]
[null,"Provisioner/bonus",{"v":5000,"d":"5,000.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":416.6666666666667,"d":"416.67 kr"}}]
[null,"Övrigt 1",{"v":30000,"d":"30,000.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":2500,"d":"2,500.00 kr"}}]
[null,"Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 3",{"v":0,"d":"0.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 4",{"v":0,"d":"0.00 kr"},{"$f":"Inkomster[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Inkomster[[Årlig  ]])","v":{"v":125000,"d":"125,000.00 kr"}},{"$f":"SUBTOTAL(109,Inkomster[[Månatlig ]])","v":{"v":10416.666666666668,"d":"10,416.67 kr"}}]

{"sheet":"Utgifter","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIGT KASSAFLÖDE"]
[null,null,"Kassaflöde totalsumma hittills:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"42,250.00 kr"}},null,"Det här är en årlig kalkyl.  Använd det här kalkylbladet om du vill visa årliga belopp med uppskattade månatliga värden\nOm du vill lägga till dagliga poster i tabellen uppskattar du deras årliga belopp/värde och placerar värdet i rätt årskolumn."]
[]
[null,"Utgifter","Årlig  ","Månatlig "]
[null,"Statlig inkomstskatt/egenavgifter/sjukförsäkring",{"v":12500,"d":"12,500.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 kr"}}]
[null,"Kommunal inkomstskatt",{"v":2500,"d":"2,500.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":208.33333333333334,"d":"208.33 kr"}}]
[null,"Fordonsskatt/avgifter",{"v":200,"d":"200.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":16.666666666666668,"d":"16.67 kr"}}]
[null,"Avbetalningar fordon",{"v":4000,"d":"4,000.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":333.3333333333333,"d":"333.33 kr"}}]
[null,"Avbetalning bostad/hyra",{"v":15000,"d":"15,000.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":1250,"d":"1,250.00 kr"}}]
[null,"Försäkring",{"v":250,"d":"250.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":20.833333333333332,"d":"20.83 kr"}}]
[null,"Elektricitet",{"v":1200,"d":"1,200.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":100,"d":"100.00 kr"}}]
[null,"Bensin",{"v":600,"d":"600.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Vatten/avlopp",{"v":600,"d":"600.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Sophantering",{"v":150,"d":"150.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":12.5,"d":"12.50 kr"}}]
[null,"Telefon",{"v":600,"d":"600.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Internet",{"v":600,"d":"600.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Funktionsnedsättningshjälp",{"v":1500,"d":"1,500.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":125,"d":"125.00 kr"}}]
[null,"Mat",{"v":5000,"d":"5,000.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":416.6666666666667,"d":"416.67 kr"}}]
[null,"Kläder",{"v":1200,"d":"1,200.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":100,"d":"100.00 kr"}}]
[null,"Sjukvård/Tandvård/Läkemedel",{"v":600,"d":"600.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Övrigt 1",{"v":0,"d":"0.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Utgifter[[Årlig  ]])","v":{"v":46500,"d":"46,500.00 kr"}},{"$f":"SUBTOTAL(109,Utgifter[[Månatlig ]])","v":{"v":3875,"d":"3,875.00 kr"}}]

{"sheet":"Övrigt","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIGT KASSAFLÖDE"]
[null,null,"Kassaflöde totalsumma hittills:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"42,250.00 kr"}},null,"Det här är en årlig kalkyl.  Använd det här kalkylbladet om du vill visa årliga belopp med uppskattade månatliga värden\nOm du vill lägga till dagliga poster i tabellen uppskattar du deras årliga belopp/värde och placerar värdet i rätt årskolumn."]
[]
[null,"Övrigt","Årlig  ","Månatlig "]
[null,"Restaurang",{"v":1200,"d":"1,200.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":100,"d":"100.00 kr"}}]
[null,"Gåvor",{"v":600,"d":"600.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Resor",{"v":2250,"d":"2,250.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":187.5,"d":"187.50 kr"}}]
[null,"Nöjen",{"v":1200,"d":"1,200.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":100,"d":"100.00 kr"}}]
[null,"Kroppsvård",{"v":300,"d":"300.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":25,"d":"25.00 kr"}}]
[null,"Shopping",{"v":2000,"d":"2,000.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":166.66666666666666,"d":"166.67 kr"}}]
[null,"Välgörenhet",{"v":600,"d":"600.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":50,"d":"50.00 kr"}}]
[null,"Förening/medlemskap",{"v":300,"d":"300.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":25,"d":"25.00 kr"}}]
[null,"Renoveringar",{"v":4800,"d":"4,800.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":400,"d":"400.00 kr"}}]
[null,"Övrigt 1",{"v":0,"d":"0.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Övrigt[[Årlig  ]])","v":{"v":13250,"d":"13,250.00 kr"}},{"$f":"SUBTOTAL(109,Övrigt[[Månatlig ]])","v":{"v":1104.1666666666665,"d":"1,104.17 kr"}}]

{"sheet":"Sparande","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":7}," "]
[null,null,"Kassaflöde totalsumma hittills:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"42,250.00 kr"}},null,"Det här är en årlig kalkyl.  Använd det här kalkylbladet om du vill visa årliga belopp med uppskattade månatliga värden\nOm du vill lägga till dagliga poster i tabellen uppskattar du deras årliga belopp/värde och placerar värdet i rätt årskolumn."]
[]
[null,"Sparande","Årlig  ","Månatlig "]
[null,"Kassareserver",{"v":5000,"d":"5,000.00 kr"},{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":416.6666666666667,"d":"416.67 kr"}}]
[null,"Pensionssparande",{"v":12000,"d":"12,000.00 kr"},{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":1000,"d":"1,000.00 kr"}}]
[null,"Sparande/investeringar",{"v":6000,"d":"6,000.00 kr"},{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":500,"d":"500.00 kr"}}]
[null,"Övrigt 1",{"v":0,"d":"0.00 kr"},{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",{"v":0,"d":"0.00 kr"},{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Sparande[[Årlig  ]])","v":{"v":23000,"d":"23,000.00 kr"}},{"$f":"SUBTOTAL(109,Sparande[[Månatlig ]])","v":{"v":1916.6666666666667,"d":"1,916.67 kr"}}]