{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Sammanfattning","Månadsinkomst","Månadsutgifter","Månadssparande","Diagramdata"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Sammanfattning","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"Personlig budget"]
[null,"Procent av inkomst som spenderats","Sammanfattning"]
[null,{"$f":"Procent_av_inkomst_som_spenderats","v":{"v":0.6229333333333333,"d":"62%"}},"SUMMA MÅNADSINKOMST","Stapeldiagram som visar summa för månadsinkomst och månadsutgifter i den här cellen."]
[null,null,{"$f":"SUM(Månadsinkomst[[#All],[BELOPP]])","v":{"v":3750,"d":"3,750 kr"}}]
[null,null,"SUMMA MÅNADSUTGIFTER"]
[null,null,{"$f":"SUM(Månadsutgifter[[#All],[BELOPP]])","v":{"v":2336,"d":"2,336 kr"}}]
[null,null,"SUMMA MÅNADSSPARANDE"]
[null,null,{"$f":"SUM(Sparande[[#All],[BELOPP]])","v":{"v":550,"d":"550 kr"}}]
[null,null,"SALDO"]
[null,null,{"$f":"SummaMånadsinkomst-SummaMånadsutgifter-SummaMånadssparande","v":{"v":864,"d":"864 kr"}}]

{"sheet":"Månadsinkomst","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"Budgetrubrik","v":"Personlig budget"}]
[null,"Månadsinkomst"]
[null,"VARA","BELOPP"]
[null,"Inkomstkälla 1",{"v":2500,"d":"2,500.00 kr"}]
[null,"Inkomstkälla 2",{"v":1000,"d":"1,000.00 kr"}]
[null,"Övrigt",{"v":250,"d":"250.00 kr"}]

{"sheet":"Månadsutgifter","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"Budgetrubrik","v":"Personlig budget"}]
[null,"Månadsutgifter"]
[null,"VARA","FÖRFALLODATUM","BELOPP"]
[null,"Hyra/bolån","Datum",{"v":800,"d":"800.00 kr"}]
[null,"El","Datum",{"v":120,"d":"120.00 kr"}]
[null,"Gas","Datum",{"v":50,"d":"50.00 kr"}]
[null,"Mobiltelefon","Datum",{"v":45,"d":"45.00 kr"}]
[null,"Matvaror","Datum",{"v":500,"d":"500.00 kr"}]
[null,"Bilavbetalning","Datum",{"v":273,"d":"273.00 kr"}]
[null,"Bilutgifter","Datum",{"v":120,"d":"120.00 kr"}]
[null,"Studielån","Datum",{"v":50,"d":"50.00 kr"}]
[null,"Kreditkort","Datum",{"v":100,"d":"100.00 kr"}]
[null,"Bilförsäkring","Datum",{"v":78,"d":"78.00 kr"}]
[null,"Hygien","Datum",{"v":50,"d":"50.00 kr"}]
[null,"Underhållning","Datum",{"v":100,"d":"100.00 kr"}]
[null,"Övrigt","Datum",{"v":50,"d":"50.00 kr"}]

{"sheet":"Månadssparande","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"Budgetrubrik","v":"Personlig budget"}]
[null,"Månadssparande"]
[null,"DATUM","BELOPP"]
[null,"Datum",{"v":200,"d":"200.00 kr"}]
[null,"Datum",{"v":250,"d":"250.00 kr"}]
[null,"Datum",{"v":100,"d":"100.00 kr"}]

{"sheet":"Diagramdata","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"DIAGRAMDATA"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(SummaMånadsutgifter/SummaMånadsinkomst,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(SummaMånadsutgifter/SummaMånadsinkomst)>1","v":false}]