{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Naudas plūsma","Ikmēneša ienākumi","Ikmēneša izdevumi","Diagrammas dati"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Naudas plūsma","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Uzvārds"]
[null,"Ģimenes budžets"]
[null,{"$f":"\" Par mēnesi ar \" & TEXT(TODAY(),\"mmmm yyyy\")","v":" Par mēnesi ar septembris 2021"}]
[]
[]
[null,"Naudas plūsmas analīze"]
[]
[]
[null," ","Plānotie","Faktiskie","Novirze"]
[{"$f":"Ienākumi[[#Totals],[Novirze]]","v":300},"Kopējie ienākumi",{"$f":"Ienākumi[[#Totals],[Plānotie]]","v":{"v":5700,"d":"5,700 EUR"}},{"$f":"Ienākumi[[#Totals],[Faktiskie]]","v":{"v":6000,"d":"6,000 EUR"}},{"$f":"A12","v":{"v":300,"d":"300 EUR"}}]
[{"$f":"Izdevumi[[#Totals],[Novirze]]","v":-52},"Kopējie izdevumi",{"$f":"Izdevumi[[#Totals],[Plānotie]]","v":{"v":3603,"d":"3,603 EUR"}},{"$f":"Izdevumi[[#Totals],[Faktiskie]]","v":{"v":3655,"d":"3,655 EUR"}},{"$f":"A13","v":{"v":-52,"d":"-52 EUR"}}]
[null,"Kopējā naudas summa",{"$f":"C12-C13","v":{"v":2097,"d":"2,097 EUR"}},{"$f":"D12-D13","v":{"v":2345,"d":"2,345 EUR"}},{"$f":"SUBTOTAL(109,NaudasPlūsma[Novirze])","v":{"v":248,"d":"248 EUR"}}]

{"sheet":"Ikmēneša ienākumi","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Ikmēneša ienākumi"]
[]
[]
[null," ","Plānotie","Faktiskie","Novirze"]
[null,"Ienākumi 1",{"v":4000,"d":"4,000.00 EUR"},{"v":4000,"d":"4,000.00 EUR"},{"$f":"Ienākumi[[#This Row],[Faktiskie]]-Ienākumi[[#This Row],[Plānotie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ienākumi 2",{"v":1400,"d":"1,400.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"$f":"Ienākumi[[#This Row],[Faktiskie]]-Ienākumi[[#This Row],[Plānotie]]","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Citi ienākumi",{"v":300,"d":"300.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$f":"Ienākumi[[#This Row],[Faktiskie]]-Ienākumi[[#This Row],[Plānotie]]","v":{"v":200,"d":"200.00 EUR"}}]
[null,"Kopējie ienākumi",{"$f":"SUBTOTAL(109,Ienākumi[Plānotie])","v":{"v":5700,"d":"5,700.00 EUR"}},{"$f":"SUBTOTAL(109,Ienākumi[Faktiskie])","v":{"v":6000,"d":"6,000.00 EUR"}},{"$f":"SUBTOTAL(109,Ienākumi[Novirze])","v":{"v":300,"d":"300.00 EUR"}}]

{"sheet":"Ikmēneša izdevumi","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Ikmēneša izdevumi"]
[]
[]
[null," ","Plānotie","Faktiskie","Novirze"]
[null,"Mājoklis",{"v":1500,"d":"1,500.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Pārtikas preces",{"v":250,"d":"250.00 EUR"},{"v":280,"d":"280.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":-30,"d":"-30.00 EUR"}}]
[null,"Tālrunis",{"v":38,"d":"38.00 EUR"},{"v":38,"d":"38.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Elektrība/gāze",{"v":65,"d":"65.00 EUR"},{"v":78,"d":"78.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":-13,"d":"-13.00 EUR"}}]
[null,"Ūdens/kanalizācija/atkritumi",{"v":25,"d":"25.00 EUR"},{"v":21,"d":"21.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":4,"d":"4.00 EUR"}}]
[null,"Kabeļtelevīzija",{"v":75,"d":"75.00 EUR"},{"v":83,"d":"83.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":-8,"d":"-8.00 EUR"}}]
[null,"Internets",{"v":60,"d":"60.00 EUR"},{"v":60,"d":"60.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Apkope/remonts",{"v":0,"d":"0.00 EUR"},{"v":60,"d":"60.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":-60,"d":"-60.00 EUR"}}]
[null,"Bērnu aprūpe",{"v":180,"d":"180.00 EUR"},{"v":150,"d":"150.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":30,"d":"30.00 EUR"}}]
[null,"Mācību maksa",{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Mājdzīvnieki",{"v":75,"d":"75.00 EUR"},{"v":80,"d":"80.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":-5,"d":"-5.00 EUR"}}]
[null,"Transports",{"v":280,"d":"280.00 EUR"},{"v":260,"d":"260.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":20,"d":"20.00 EUR"}}]
[null,"Personiskā higiēna",{"v":75,"d":"75.00 EUR"},{"v":65,"d":"65.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":10,"d":"10.00 EUR"}}]
[null,"Apdrošināšana",{"v":255,"d":"255.00 EUR"},{"v":255,"d":"255.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Kredītkartes",{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Aizdevumi",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Nodokļi",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Dāvanas/labdarība",{"v":150,"d":"150.00 EUR"},{"v":150,"d":"150.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ietaupījumi",{"v":225,"d":"225.00 EUR"},{"v":225,"d":"225.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Izdevumi[[#This Row],[Plānotie]]-Izdevumi[[#This Row],[Faktiskie]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Kopsumma",{"$f":"SUBTOTAL(109,Izdevumi[Plānotie])","v":{"v":3603,"d":"3,603.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumi[Faktiskie])","v":{"v":3655,"d":"3,655.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumi[Novirze])","v":{"v":-52,"d":"-52.00 EUR"}}]

{"sheet":"Diagrammas dati","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Diagrammas dati"]
[]
[null,null,"Prognozētie","Faktiskie"]
[null,"Ikmēneša ienākumi",{"$f":"Ienākumi[[#Totals],[Plānotie]]","v":5700},{"$f":"Ienākumi[[#Totals],[Faktiskie]]","v":6000}]
[null,"Ikmēneša izdevumi",{"$f":"Izdevumi[[#Totals],[Plānotie]]","v":3603},{"$f":"Izdevumi[[#Totals],[Faktiskie]]","v":3655}]
[null,"Naudas plūsma",{"$f":"NaudasPlūsma[[#Totals],[Plānotie]]","v":2097},{"$f":"NaudasPlūsma[[#Totals],[Faktiskie]]","v":2345}]