{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Personlig månadsbudget"],"read":"whole","date_system":"1900"}

{"sheet":"Personlig månadsbudget","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"Personlig månadsbudget"]
[]
[null,"PLANERAD MÅNADSINKOMST","Inkomst 1",null,{"v":2500,"d":"2,500 kr"},null,"SUMMA PLANERAD UTGIFT ","(Planerad inkomst minus utgifter)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"2,060 kr"}}]
[null,null,"Extrainkomst",null,{"v":500,"d":"500 kr"},null,"SUMMA VERKLIG UTGIFT ","(Verklig inkomst minus utgifter)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"2,040 kr"}}]
[null,null,"Summa av månadsinkomst",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"3,000 kr"}},null,"Skillnad i summa utgifter",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"20 kr"}}]
[null,"VERKLIG MÅNADSINKOMST","Inkomst 1",null,{"v":2500,"d":"2,500 kr"},null,"PLANERAT SALDO","(Planerad inkomst minus utgifter)",null,{"$f":"E5-J3","v":{"v":940,"d":"940 kr"}}]
[null,null,"Extrainkomst",null,{"v":500,"d":"500 kr"},null,"VERKLIGT SALDO","(Verklig inkomst minus utgifter)",null,{"$f":"E8-J4","v":{"v":960,"d":"960 kr"}}]
[null,null,"Summa av månadsinkomst",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"3,000 kr"}},null,"SKILLNAD I SALDO (verkligt minus planerat)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"20 kr"}}]
[]
[null,"BOSTAD","Planerad kostnad","Verklig kostnad","Skillnad",null,"NÖJEN","Planerad kostnad","Verklig kostnad","Skillnad"]
[null,"Bostadslån eller hyra",{"v":1500,"d":"1,500 kr"},{"v":1400,"d":"1,400 kr"},{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":100,"d":"100 kr"}},null,"Video/DVD",{"v":0,"d":"0 kr"},{"v":50,"d":"50 kr"},{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":-50,"d":"-50 kr"}}]
[null,"Telefon",{"v":60,"d":"60 kr"},{"v":100,"d":"100 kr"},{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":-40,"d":"-40 kr"}},null,"CD",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Elektricitet",{"v":50,"d":"50 kr"},{"v":60,"d":"60 kr"},{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":-10,"d":"-10 kr"}},null,"Bio",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Gas",{"v":200,"d":"200 kr"},{"v":180,"d":"180 kr"},{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":20,"d":"20 kr"}},null,"Konserter",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"VA-avgifter",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Sportevenemang",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Kabel-TV",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Teater",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Sophämtning",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Annat",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Underhåll eller reparationer",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Annat",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Material",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Övrigt",null,null,{"$f":"Nöjen[[#This Row],[Planerad kostnad]]-Nöjen[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Övrigt",null,null,{"$f":"Bostad[[#This Row],[Planerad kostnad]]-Bostad[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Nöjen[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Nöjen[Verklig kostnad])","v":{"v":50,"d":"50 kr"}},{"$f":"SUBTOTAL(109,Nöjen[Skillnad])","v":{"v":-50,"d":"-50 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Bostad[Planerad kostnad])","v":{"v":1810,"d":"1,810 kr"}},{"$f":"SUBTOTAL(109,Bostad[Verklig kostnad])","v":{"v":1740,"d":"1,740 kr"}},{"$f":"SUBTOTAL(109,Bostad[Skillnad])","v":{"v":70,"d":"70 kr"}}]
[{"$nulls":6},"LÅN","Planerad kostnad","Verklig kostnad","Skillnad"]
[null,"TRANSPORT","Planerad kostnad","Verklig kostnad","Skillnad",null,"Privat",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Avbetalning, fordon",{"v":250,"d":"250 kr"},{"v":250,"d":"250 kr"},{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Student",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Buss/taxi",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Kreditkort",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Försäkring",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Kreditkort",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Licensavgift",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Kreditkort",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Bränsle",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Övrigt",null,null,{"$f":"Lån[[#This Row],[Planerad kostnad]]-Lån[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Underhåll",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Lån[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Lån[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Lån[Skillnad])","v":{"v":0,"d":"0 kr"}}]
[null,"Övrigt",null,null,{"$f":"Transport[[#This Row],[Planerad kostnad]]-Transport[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Transport[Planerad kostnad])","v":{"v":250,"d":"250 kr"}},{"$f":"SUBTOTAL(109,Transport[Verklig kostnad])","v":{"v":250,"d":"250 kr"}},{"$f":"SUBTOTAL(109,Transport[Skillnad])","v":{"v":0,"d":"0 kr"}},null,"SKATTER","Planerad kostnad","Verklig kostnad","Skillnad"]
[{"$nulls":6},"Stat",null,null,{"$f":"Skatter[[#This Row],[Planerad kostnad]]-Skatter[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"FÖRSÄKRING","Planerad kostnad","Verklig kostnad","Skillnad",null,"Landsting",null,null,{"$f":"Skatter[[#This Row],[Planerad kostnad]]-Skatter[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Hemförsäkring",null,null,{"$f":"Försäkring[[#This Row],[Planerad kostnad]]-Försäkring[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Kommunal",null,null,{"$f":"Skatter[[#This Row],[Planerad kostnad]]-Skatter[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Sjukförsäkring",null,null,{"$f":"Försäkring[[#This Row],[Planerad kostnad]]-Försäkring[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Övrigt",null,null,{"$f":"Skatter[[#This Row],[Planerad kostnad]]-Skatter[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Livförsäkring",null,null,{"$f":"Försäkring[[#This Row],[Planerad kostnad]]-Försäkring[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Skatter[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Skatter[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Skatter[Skillnad])","v":{"v":0,"d":"0 kr"}}]
[null,"Övrigt",null,null,{"$f":"Försäkring[[#This Row],[Planerad kostnad]]-Försäkring[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Försäkring[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Försäkring[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Försäkring[Skillnad])","v":{"v":0,"d":"0 kr"}},null,"SPARANDE ELLER INVESTERINGAR","Planerad kostnad","Verklig kostnad","Skillnad"]
[{"$nulls":6},"Pensionssparande",null,null,{"$f":"Sparande_eller_investeringar[[#This Row],[Planerad kostnad]]-Sparande_eller_investeringar[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"MAT","Planerad kostnad","Verklig kostnad","Skillnad",null,"Investeringskonto",null,null,{"$f":"Sparande_eller_investeringar[[#This Row],[Planerad kostnad]]-Sparande_eller_investeringar[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Matvaror",null,null,{"$f":"Mat[[#This Row],[Planerad kostnad]]-Mat[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Övrigt",null,null,{"$f":"Sparande_eller_investeringar[[#This Row],[Planerad kostnad]]-Sparande_eller_investeringar[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Restaurangbesök",null,null,{"$f":"Mat[[#This Row],[Planerad kostnad]]-Mat[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Sparande_eller_investeringar[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Sparande_eller_investeringar[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Sparande_eller_investeringar[Skillnad])","v":{"v":0,"d":"0 kr"}}]
[null,"Övrigt",null,null,{"$f":"Mat[[#This Row],[Planerad kostnad]]-Mat[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Mat[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Mat[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Mat[Skillnad])","v":{"v":0,"d":"0 kr"}},null,"GÅVOR OCH DONATIONER","Planerad kostnad","Verklig kostnad","Skillnad"]
[{"$nulls":6},"Välgörenhet 1",null,null,{"$f":"Gåvor_och_donationer[[#This Row],[Planerad kostnad]]-Gåvor_och_donationer[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"HUSDJUR","Planerad kostnad","Verklig kostnad","Skillnad",null,"Välgörenhet 2",null,null,{"$f":"Gåvor_och_donationer[[#This Row],[Planerad kostnad]]-Gåvor_och_donationer[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Mat",null,null,{"$f":"Husdjur[[#This Row],[Planerad kostnad]]-Husdjur[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Välgörenhet 3",null,null,{"$f":"Gåvor_och_donationer[[#This Row],[Planerad kostnad]]-Gåvor_och_donationer[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Medicin",null,null,{"$f":"Husdjur[[#This Row],[Planerad kostnad]]-Husdjur[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Gåvor_och_donationer[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Gåvor_och_donationer[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Gåvor_och_donationer[Skillnad])","v":{"v":0,"d":"0 kr"}}]
[null,"Omvårdnad",null,null,{"$f":"Husdjur[[#This Row],[Planerad kostnad]]-Husdjur[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Leksaker",null,null,{"$f":"Husdjur[[#This Row],[Planerad kostnad]]-Husdjur[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"JURIDISKT","Planerad kostnad","Verklig kostnad","Skillnad"]
[null,"Övrigt",null,null,{"$f":"Husdjur[[#This Row],[Planerad kostnad]]-Husdjur[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Advokat",null,null,{"$f":"Juridiskt[[#This Row],[Planerad kostnad]]-Juridiskt[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Husdjur[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Husdjur[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Husdjur[Skillnad])","v":{"v":0,"d":"0 kr"}},null,"Underhåll",null,null,{"$f":"Juridiskt[[#This Row],[Planerad kostnad]]-Juridiskt[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[{"$nulls":6},"Betalning av fordran",null,null,{"$f":"Juridiskt[[#This Row],[Planerad kostnad]]-Juridiskt[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"HYGIEN","Planerad kostnad","Verklig kostnad","Skillnad",null,"Övrigt",null,null,{"$f":"Juridiskt[[#This Row],[Planerad kostnad]]-Juridiskt[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Medicin",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Juridiskt[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Juridiskt[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Juridiskt[Skillnad])","v":{"v":0,"d":"0 kr"}}]
[null,"Hår/naglar",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Kläder",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Kemtvätt",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Gym",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Medlemsavgifter",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Övrigt",null,null,{"$f":"Hygien[[#This Row],[Planerad kostnad]]-Hygien[[#This Row],[Verklig kostnad]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Hygien[Planerad kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Hygien[Verklig kostnad])","v":{"v":0,"d":"0 kr"}},{"$f":"SUBTOTAL(109,Hygien[Skillnad])","v":{"v":0,"d":"0 kr"}}]