{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Pinigų srautas","Mėnesio pajamos","Mėnesio išlaidos","Diagramos duomenys"],"not_rendered":{"charts":1,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Pinigų srautas","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Šeimos pavardė"]
[null,"Šeimos biudžetas"]
[null,{"$f":"\" Mėnesiui: \" & TEXT(TODAY(),\"mmmm yyyy\")","v":" Mėnesiui: rugsėjis 2021"}]
[]
[]
[null,"Pinigų srauto analizė"]
[]
[]
[null," ","Numatomos","Faktinės","Nuokrypis"]
[{"$f":"Pajamos[[#Totals],[Nuokrypis]]","v":300},"Pajamų suma",{"$f":"Pajamos[[#Totals],[Numatomos]]","v":{"v":5700,"d":"5,700 EUR"}},{"$f":"Pajamos[[#Totals],[Faktinės]]","v":{"v":6000,"d":"6,000 EUR"}},{"$f":"A12","v":{"v":300,"d":"300 EUR"}}]
[{"$f":"Išlaidos[[#Totals],[Nuokrypis]]","v":-52},"Išlaidų suma",{"$f":"Išlaidos[[#Totals],[Numatomos]]","v":{"v":3603,"d":"3,603 EUR"}},{"$f":"Išlaidos[[#Totals],[Faktinės]]","v":{"v":3655,"d":"3,655 EUR"}},{"$f":"A13","v":{"v":-52,"d":"-52 EUR"}}]
[null,"Iš viso pinigų",{"$f":"C12-C13","v":{"v":2097,"d":"2,097 EUR"}},{"$f":"D12-D13","v":{"v":2345,"d":"2,345 EUR"}},{"$f":"SUBTOTAL(109,PinigųSrautai[Nuokrypis])","v":{"v":248,"d":"248 EUR"}}]

{"sheet":"Mėnesio pajamos","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Mėnesio pajamos"]
[]
[]
[null," ","Numatomos","Faktinės","Nuokrypis"]
[null,"1 pajamos",{"v":4000,"d":"4,000.00 EUR"},{"v":4000,"d":"4,000.00 EUR"},{"$f":"Pajamos[[#This Row],[Faktinės]]-Pajamos[[#This Row],[Numatomos]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"2 pajamos",{"v":1400,"d":"1,400.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"$f":"Pajamos[[#This Row],[Faktinės]]-Pajamos[[#This Row],[Numatomos]]","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Kitos pajamos",{"v":300,"d":"300.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$f":"Pajamos[[#This Row],[Faktinės]]-Pajamos[[#This Row],[Numatomos]]","v":{"v":200,"d":"200.00 EUR"}}]
[null,"Pajamų suma",{"$f":"SUBTOTAL(109,Pajamos[Numatomos])","v":{"v":5700,"d":"5,700.00 EUR"}},{"$f":"SUBTOTAL(109,Pajamos[Faktinės])","v":{"v":6000,"d":"6,000.00 EUR"}},{"$f":"SUBTOTAL(109,Pajamos[Nuokrypis])","v":{"v":300,"d":"300.00 EUR"}}]

{"sheet":"Mėnesio išlaidos","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Mėnesio išlaidos"]
[]
[]
[null," ","Numatomos","Faktinės","Nuokrypis"]
[null,"Būstas",{"v":1500,"d":"1,500.00 EUR"},{"v":1500,"d":"1,500.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Maisto prekės",{"v":250,"d":"250.00 EUR"},{"v":280,"d":"280.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":-30,"d":"-30.00 EUR"}}]
[null,"Telefonas",{"v":38,"d":"38.00 EUR"},{"v":38,"d":"38.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Elektra / dujos",{"v":65,"d":"65.00 EUR"},{"v":78,"d":"78.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":-13,"d":"-13.00 EUR"}}]
[null,"Vanduo / kanalizacija / šiukšlės",{"v":25,"d":"25.00 EUR"},{"v":21,"d":"21.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":4,"d":"4.00 EUR"}}]
[null,"Kabelinė televizija",{"v":75,"d":"75.00 EUR"},{"v":83,"d":"83.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":-8,"d":"-8.00 EUR"}}]
[null,"Internetas",{"v":60,"d":"60.00 EUR"},{"v":60,"d":"60.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Priežiūra / remontas",{"v":0,"d":"0.00 EUR"},{"v":60,"d":"60.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":-60,"d":"-60.00 EUR"}}]
[null,"Vaiko priežiūra",{"v":180,"d":"180.00 EUR"},{"v":150,"d":"150.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":30,"d":"30.00 EUR"}}]
[null,"Mokestis už mokslą",{"v":250,"d":"250.00 EUR"},{"v":250,"d":"250.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Gyvūnai",{"v":75,"d":"75.00 EUR"},{"v":80,"d":"80.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":-5,"d":"-5.00 EUR"}}]
[null,"Transportas",{"v":280,"d":"280.00 EUR"},{"v":260,"d":"260.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":20,"d":"20.00 EUR"}}]
[null,"Asmens priežiūra",{"v":75,"d":"75.00 EUR"},{"v":65,"d":"65.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":10,"d":"10.00 EUR"}}]
[null,"Draudimas",{"v":255,"d":"255.00 EUR"},{"v":255,"d":"255.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Kredito kortelės",{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Paskolos",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Mokesčiai",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Dovanos / labdara",{"v":150,"d":"150.00 EUR"},{"v":150,"d":"150.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Santaupos",{"v":225,"d":"225.00 EUR"},{"v":225,"d":"225.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Kita",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$f":"Išlaidos[[#This Row],[Numatomos]]-Išlaidos[[#This Row],[Faktinės]]","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Suma",{"$f":"SUBTOTAL(109,Išlaidos[Numatomos])","v":{"v":3603,"d":"3,603.00 EUR"}},{"$f":"SUBTOTAL(109,Išlaidos[Faktinės])","v":{"v":3655,"d":"3,655.00 EUR"}},{"$f":"SUBTOTAL(109,Išlaidos[Nuokrypis])","v":{"v":-52,"d":"-52.00 EUR"}}]

{"sheet":"Diagramos duomenys","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Diagramos duomenys"]
[]
[null,null,"Numatomas","Faktinės"]
[null,"Mėnesio pajamos",{"$f":"Pajamos[[#Totals],[Numatomos]]","v":5700},{"$f":"Pajamos[[#Totals],[Faktinės]]","v":6000}]
[null,"Mėnesio išlaidos",{"$f":"Išlaidos[[#Totals],[Numatomos]]","v":3603},{"$f":"Išlaidos[[#Totals],[Faktinės]]","v":3655}]
[null,"Pinigų srautas",{"$f":"PinigųSrautai[[#Totals],[Numatomos]]","v":2097},{"$f":"PinigųSrautai[[#Totals],[Faktinės]]","v":2345}]