{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pers. naudas plūsmas izsekotājs","Mēneša kopsavilkums","Diagrammas dati"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Pers. naudas plūsmas izsekotājs","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[19,1,20,1],[21,1,23,1]]}
[null,"Personiskais naudas plūsmas izsekotājs"]
[]
[{"$nulls":3},"Naudas kopsavilkums"]
[{"$nulls":3},"Konts","Skaidra nauda sākumā","Izdevumu kopsumma","Atlikusi skaidra nauda"]
[{"$nulls":3},"Notiek pārbaude",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(IztērētāNauda[Konts],\"=\" &NaudasKopsavilkumaTabula[[#This Row],[Konts]],IztērētāNauda[Summa])","v":{"v":428,"d":"428.00"}},{"$f":"NaudasKopsavilkumaTabula[[#This Row],[Skaidra nauda sākumā]]-NaudasKopsavilkumaTabula[[#This Row],[Izdevumu kopsumma]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Ietaupījumi",{"v":500,"d":"500.00"},{"$f":"SUMIF(IztērētāNauda[Konts],\"=\" &NaudasKopsavilkumaTabula[[#This Row],[Konts]],IztērētāNauda[Summa])","v":{"v":450,"d":"450.00"}},{"$f":"NaudasKopsavilkumaTabula[[#This Row],[Skaidra nauda sākumā]]-NaudasKopsavilkumaTabula[[#This Row],[Izdevumu kopsumma]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Cits",{"v":200,"d":"200.00"},{"$f":"SUMIF(IztērētāNauda[Konts],\"=\" &NaudasKopsavilkumaTabula[[#This Row],[Konts]],IztērētāNauda[Summa])","v":{"v":30,"d":"30.00"}},{"$f":"NaudasKopsavilkumaTabula[[#This Row],[Skaidra nauda sākumā]]-NaudasKopsavilkumaTabula[[#This Row],[Izdevumu kopsumma]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Kopā",{"$f":"SUBTOTAL(109,NaudasKopsavilkumaTabula[Skaidra nauda sākumā])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,NaudasKopsavilkumaTabula[Izdevumu kopsumma])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,NaudasKopsavilkumaTabula[Atlikusi skaidra nauda])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Manis iztērētā nauda"]
[{"$nulls":3},"Datums","Apraksts","Summa","Konts"]
[{"$nulls":3},"2012-01-04","Izņemšana no bankomāta",{"v":40,"d":"40.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-01-05","Pusdienas",{"v":5,"d":"5.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-01-06","Maksājums par automašīnu",{"v":230,"d":"230.00"},"Ietaupījumi"]
[{"$nulls":3},"2012-02-03","Maksājums par elektrību",{"v":70,"d":"70.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-02-07","Vakariņas",{"v":53,"d":"53.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-03-01","Skaidras naudas izņemšana",{"v":100,"d":"100.00"},"Ietaupījumi"]
[{"$nulls":3},"2012-03-06","Maksājums par automašīnu",{"v":230,"d":"230.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-04-06","Maksājums par elektrību",{"v":70,"d":"70.00"},"Ietaupījumi"]
[null,"Atlikusi skaidra nauda:",null,"2012-04-20","Izņemšana no bankomāta",{"v":30,"d":"30.00"},"Notiek pārbaude"]
[{"$nulls":3},"2012-05-03","Izņemšana no bankomāta",{"v":50,"d":"50.00"},"Ietaupījumi"]
[null,{"$f":"NaudasKopsavilkumaTabula[[#Totals],[Atlikusi skaidra nauda]]/NaudasKopsavilkumaTabula[[#Totals],[Skaidra nauda sākumā]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","Izņemšana no bankomāta",{"v":30,"d":"30.00"},"Cits"]

{"sheet":"Mēneša kopsavilkums","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Mēneša kopsavilkums"]
[null,"Konta kopsavilkums"]
{"$rows_empty":13}
[null,"Izdevumu kopsavilkums"]
[null,"Detaļas"]
[null,null,"Cits","Ietaupījumi","Notiek pārbaude","Gala summa"]
[null,"jan",null,{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},{"v":275,"d":"275.00"}]
[null,"feb",null,null,{"v":123,"d":"123.00"},{"v":123,"d":"123.00"}]
[null,"mar",null,{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},{"v":330,"d":"330.00"}]
[null,"Maksājums par automašīnu",null,null,{"v":230,"d":"230.00"},{"v":230,"d":"230.00"}]
[null,"Skaidras naudas izņemšana",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"apr",null,{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"Gala summa",{"v":30,"d":"30.00"},{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":908,"d":"908.00"}]

{"sheet":"Diagrammas dati","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Rakursdiagrammas dati"]
[null,"Šī rakurstabula ir lapā Mēneša kopsavilkums esošās rakursdiagrammas Konta kopsavilkums datu avots"]
[null,"Summa no Summa","Kolonnu etiķetes"]
[null,"Rindu etiķetes","Cits","Ietaupījumi","Notiek pārbaude","Gala summa"]
[null,"jan",null,{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},{"v":275,"d":"275.00"}]
[null,"feb",null,null,{"v":123,"d":"123.00"},{"v":123,"d":"123.00"}]
[null,"mar",null,{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},{"v":330,"d":"330.00"}]
[null,"apr",null,{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},null,{"v":80,"d":"80.00"}]
[null,"Gala summa",{"v":30,"d":"30.00"},{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":908,"d":"908.00"}]