{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Kopsavilkums","Mēneša ienākumi","Mēneša izdevumi","Mēneša ietaupījumi","Diagrammas dati"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Kopsavilkums","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"Personiskais budžets"]
[null,"Iztērētie ienākumi procentos","Kopsavilkums"]
[null,{"$f":"Iztērēto_ienākumu_procents","v":{"v":0.6229333333333333,"d":"62%"}},"KOPĒJIE IKMĒNEŠA IENĀKUMI","Šajā šūnā ir stabiņu diagramma, kas salīdzina mēneša ienākumu kopsummu un mēneša izdevumu kopsummu."]
[null,null,{"$f":"SUM(IkmēnešaIenākumi[[#All],[SUMMA]])","v":{"v":3750,"d":"3,750 EUR"}}]
[null,null,"KOPĒJIE IKMĒNEŠA IZDEVUMI"]
[null,null,{"$f":"SUM(IkmēnešaIzdevumi[[#All],[SUMMA]])","v":{"v":2336,"d":"2,336 EUR"}}]
[null,null,"KOPĒJIE IKMĒNEŠA IETAUPĪJUMI"]
[null,null,{"$f":"SUM(Ietaupījumi[[#All],[SUMMA]])","v":{"v":550,"d":"550 EUR"}}]
[null,null,"NAUDAS ATLIKUMS"]
[null,null,{"$f":"MēnešaIenākumuKopsumma-MēnešaIzdevumuKopsumma-MēnešaIetaupījumuKopsumma","v":{"v":864,"d":"864 EUR"}}]

{"sheet":"Mēneša ienākumi","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudžetaVirsraksts","v":"Personiskais budžets"}]
[null,"Ikmēneša ienākumi"]
[null,"VIENĪBA","SUMMA"]
[null,"1. ienākumu avots",{"v":2500,"d":"2,500.00 EUR"}]
[null,"2. ienākumu avots",{"v":1000,"d":"1,000.00 EUR"}]
[null,"Citi",{"v":250,"d":"250.00 EUR"}]

{"sheet":"Mēneša izdevumi","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"BudžetaVirsraksts","v":"Personiskais budžets"}]
[null,"Ikmēneša izdevumi"]
[null,"VIENĪBA","IZPILDES DATUMS","SUMMA"]
[null,"Noma/hipotēka","Datums",{"v":800,"d":"800.00 EUR"}]
[null,"Elektrība","Datums",{"v":120,"d":"120.00 EUR"}]
[null,"Gāze","Datums",{"v":50,"d":"50.00 EUR"}]
[null,"Mobilais tālrunis","Datums",{"v":45,"d":"45.00 EUR"}]
[null,"Pārtikas preces","Datums",{"v":500,"d":"500.00 EUR"}]
[null,"Maksājums par automašīnu","Datums",{"v":273,"d":"273.00 EUR"}]
[null,"Auto izdevumi","Datums",{"v":120,"d":"120.00 EUR"}]
[null,"Studiju kredīti","Datums",{"v":50,"d":"50.00 EUR"}]
[null,"Kredītkartes","Datums",{"v":100,"d":"100.00 EUR"}]
[null,"Auto apdrošināšana","Datums",{"v":78,"d":"78.00 EUR"}]
[null,"Personiskā higiēna","Datums",{"v":50,"d":"50.00 EUR"}]
[null,"Izklaide","Datums",{"v":100,"d":"100.00 EUR"}]
[null,"Dažādi","Datums",{"v":50,"d":"50.00 EUR"}]

{"sheet":"Mēneša ietaupījumi","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudžetaVirsraksts","v":"Personiskais budžets"}]
[null,"Ikmēneša ietaupījumi"]
[null,"DATUMS","SUMMA"]
[null,"Datums",{"v":200,"d":"200.00 EUR"}]
[null,"Datums",{"v":250,"d":"250.00 EUR"}]
[null,"Datums",{"v":100,"d":"100.00 EUR"}]

{"sheet":"Diagrammas dati","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"DIAGRAMMAS DATI"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(MēnešaIzdevumuKopsumma/MēnešaIenākumuKopsumma,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(MēnešaIzdevumuKopsumma/MēnešaIenākumuKopsumma)>1","v":false}]