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

{"sheet":"Guide","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"GUIDE","INKOMST"]
[null,"PERSONLIGT KASSAFLÖDE"]
[null,"Den här arbetsboken innehåller kalkylblad för årligt, månatligt och dagligt kassaflöde.  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,"Årligt kassaflöde",null,"Månatligt kassaflöde",null,"Dagligt kassaflöde"]
[null,"Ange ett årligt kassaflödesbelopp för olika områden. Du 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.",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,"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."]

{"sheet":"Årligt kassaflöde","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":4},"GUIDE","ÅRLIGT KASSAFLÖDE",null,"MÅNATLIGT \nKASSAFLÖDE"]
[null,"Kassaflödessumma hittills:",null,{"$f":"ÅrligtKassaflödeHittills","v":{"v":39750,"d":"39,750.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 andra kalkylblad för att lägga till dagliga poster."]
[null,"INKOMSTÖVERSIKT",{"$nulls":3},"UTGIFTSÖVERSIKT",{"$nulls":3},"ÖVERSIKT ÖVER ÖVRIGT",{"$nulls":3},"ÖVERSIKT ÖVER SPARANDE"]
[null,"Årlig totalsumma:",{"$f":"Inkomst!C10","v":{"v":125000,"d":"125,000.00 kr"}},null,null,"Årlig totalsumma:",{"$f":"Utgifter[[#Totals],[Årlig  ]]","v":{"v":49000,"d":"49,000.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,"Cirkeldiagram som visar inkomster från olika källor finns i den här cellen.",{"$nulls":3},"Cirkeldiagram som visar faktiska utgifter finns i den här cellen.",{"$nulls":3},"Cirkeldiagram som visar övriga utgifter finns i den här cellen.",{"$nulls":3},"Cirkeldiagram som visar sparande och investeringar finns i den här cellen."]
[null,"Månatlig totalsumma:",{"$f":"Inkomst!D10","v":{"v":10416.666666666668,"d":"10,416.67 kr"}},null,null,"Månatlig totalsumma:",{"$f":"Utgifter[[#Totals],[Månatlig ]]","v":{"v":4083.333333333333,"d":"4,083.33 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!D9","v":{"v":1916.6666666666667,"d":"1,916.67 kr"}}]

{"sheet":"Månatligt kassaflöde","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":5},"GUIDE","ÅRLIGT KASSAFLÖDE","MÅNATLIGT KASSAFLÖDE","DAGLIG ÖVERSIKT"]
[null,"Månatlig kassaflödessumma:",null,{"$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."]
[null,"Typ","Beskrivning","Jan","Feb","Mars","April","Maj","Juni","Juli","Aug","Sep","Okt","Nov","Dec","Summa"]
[null,"Inkomst","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,"Inkomst","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,"Inkomst","Ö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,"Inkomst","Ö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,"Inkomst","Ö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,"Inkomst","Ö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","Personförsäkringar",{"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/investeringskonto",{"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],\"Inkomst\",Månatlig[Jan])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Jan])","v":{"v":3692.5,"d":"3,692.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Feb])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Feb])","v":{"v":3247.5,"d":"3,247.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Mars])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Mars])","v":{"v":2522.5,"d":"2,522.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[April])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[April])","v":{"v":3427.5,"d":"3,427.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Maj])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Maj])","v":{"v":2887.5,"d":"2,887.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Juni])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Juni])","v":{"v":2602.5,"d":"2,602.50 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Juli])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Juli])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Aug])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Aug])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Sep])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Sep])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Okt])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Okt])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Nov])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Nov])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Dec])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Dec])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUMIF(Månatlig[Typ],\"Inkomst\",Månatlig[Summa])-SUMIF(Månatlig[Typ],\"<>Inkomst\",Månatlig[Summa])","v":{"v":18380,"d":"18,380.00 kr"}}]

{"sheet":"Daglig översikt","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,1,12]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":3},"GUIDE","MÅNATLIGT \nKASSAFLÖDE","DAGLIG ÖVERSIKT","INKOMST"]
[null,"Summa tillgängliga kontanter:",null,{"$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,"Inkomst",{"$f":"SUMIF(Daglig[Typ],$B5,Daglig[Daglig])","v":{"v":342.47,"d":"342.47 kr"}},{"$f":"SUMIF(Daglig[Typ],$B5,Daglig[Månatlig])","v":{"v":10416.795833333334,"d":"10,416.80 kr"}},{"$f":"SUMIF(Daglig[Typ],$B5,Daglig[Årlig])","v":{"v":125001.55000000002,"d":"125,001.55 kr"}}]
[null,"Utgifter",{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Daglig])","v":{"v":136.05999999999997,"d":"136.06 kr"}},{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Månatlig])","v":{"v":4138.491666666667,"d":"4,138.49 kr"}},{"$f":"SUMIF(Daglig[Typ],$B6,Daglig[Årlig])","v":{"v":49661.899999999994,"d":"49,661.90 kr"}}]
[null,"Övrigt",{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Daglig])","v":{"v":36.29,"d":"36.29 kr"}},{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Månatlig])","v":{"v":1103.8208333333334,"d":"1,103.82 kr"}},{"$f":"SUMIF(Daglig[Typ],$B7,Daglig[Årlig])","v":{"v":13245.849999999999,"d":"13,245.85 kr"}}]
[null,"Sparande",{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Daglig])","v":{"v":63.019999999999996,"d":"63.02 kr"}},{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Månatlig])","v":{"v":1916.8583333333333,"d":"1,916.86 kr"}},{"$f":"SUMIF(Daglig[Typ],$B8,Daglig[Årlig])","v":{"v":23002.300000000003,"d":"23,002.30 kr"}}]
[null,"Typ","Beskrivning","Daglig","Månatlig","Årlig"]
[null,"Inkomst","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,"Inkomst","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,"Inkomst","Ö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,"Inkomst","Ö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,"Inkomst","Ö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,"Inkomst","Ö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","Personförsäkringar",{"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/investeringskonto",{"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],\"Inkomst\",Daglig[Daglig])-SUMIF(Daglig[Typ],\"<>Inkomst\",Daglig[Daglig])","v":{"v":107.10000000000014,"d":"107.10 kr"}},{"$f":"SUMIF(Daglig[Typ],\"Inkomst\",Daglig[Månatlig])-SUMIF(Daglig[Typ],\"<>Inkomst\",Daglig[Månatlig])","v":{"v":3257.625,"d":"3,257.63 kr"}},{"$f":"SUMIF(Daglig[Typ],\"Inkomst\",Daglig[Årlig])-SUMIF(Daglig[Typ],\"<>Inkomst\",Daglig[Årlig])","v":{"v":39091.500000000015,"d":"39,091.50 kr"}}]

{"sheet":"Inkomst","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":3},"GUIDE","DAGLIG ÖVERSIKT","INKOMST","UTGIFTER"]
[null,"Kassaflödessumma hittills:",null,{"$f":"ÅrligtKassaflödeHittills","v":{"v":39750,"d":"39,750.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,"Inkomst","Årlig  ","Månatlig "]
[null,"Lön",{"v":90000,"d":"90,000.00 kr"},{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":7500,"d":"7,500.00 kr"}}]
[null,"Provisioner/bonus",{"v":5000,"d":"5,000.00 kr"},{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":416.6666666666667,"d":"416.67 kr"}}]
[null,"Övrigt 1",{"v":30000,"d":"30,000.00 kr"},{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":2500,"d":"2,500.00 kr"}}]
[null,"Övrigt 2",null,{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 3",null,{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 4",null,{"$f":"Inkomst[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Inkomst[[Årlig  ]])","v":{"v":125000,"d":"125,000.00 kr"}},{"$f":"SUBTOTAL(109,Inkomst[[Månatlig ]])","v":{"v":10416.666666666668,"d":"10,416.67 kr"}}]

{"sheet":"Utgifter","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":3},"GUIDE","INKOMST","UTGIFTER","ÖVRIGT"]
[null,"Kassaflödessumma hittills:",null,{"$f":"ÅrligtKassaflödeHittills","v":{"v":39750,"d":"39,750.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":15000,"d":"15,000.00 kr"},{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":1250,"d":"1,250.00 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,"Personförsäkringar",{"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",null,{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",null,{"$f":"Utgifter[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Utgifter[[Årlig  ]])","v":{"v":49000,"d":"49,000.00 kr"}},{"$f":"SUBTOTAL(109,Utgifter[[Månatlig ]])","v":{"v":4083.333333333333,"d":"4,083.33 kr"}}]

{"sheet":"Övrigt","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":3},"GUIDE","UTGIFTER","ÖVRIGT","SPARANDE"]
[null,"Kassaflödessumma hittills:",null,{"$f":"ÅrligtKassaflödeHittills","v":{"v":39750,"d":"39,750.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,"Övriga utgifter","Å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",null,{"$f":"Övrigt[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",null,{"$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":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONLIGT KASSAFLÖDE",{"$nulls":3},"GUIDE","ÖVRIGT","SPARANDE"]
[null,"Kassaflödessumma hittills:",null,{"$f":"ÅrligtKassaflödeHittills","v":{"v":39750,"d":"39,750.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",null,{"$f":"Sparande[[#This Row],[Årlig  ]]/12","v":{"v":0,"d":"0.00 kr"}}]
[null,"Övrigt 2",null,{"$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"}}]