{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Ceļvedis","Gada naudas plūsma","Mēneša naudas plūsma","Dienas kopsavilkums","Ienākumi","Izdevumi","Personīgie darījumi","Ietaupījumi"],"not_rendered":{"charts":4,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"Ceļvedis","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"CEĻVEDIS","IENĀKUMI"]
[null,"PERSONISKĀ NAUDAS PLŪSMA"]
[null,"Šajā darbgrāmatā ir gada,  mēneša un dienas naudas plūsmas darblapas.  Izvēlieties sev piemērotāko naudas plūsmas veidu vai izmantojiet tos visus, lai gūtu ieskatu savā personiskajā naudas plūsmā."]
[]
[null,"Gada naudas plūsma",null,"Mēneša naudas plūsma",null,"Dienas naudas plūsma"]
[null,"Ievadiet datus par gada naudas plūsmu no dažādiem avotiem. Skatiet mēneša kopsavilkumu un salīdzinājumu, kā arī gada un mēneša naudas plūsmas rādītājus.",null,"Ievadiet mēneša naudas plūsmu vai prognozējiet atlikušo gada mēnešu naudas plūsmas rādītājus.",null,"Ievadiet plānoto dienas naudas plūsmas summu un pārskatiet prognozētās mēneša un gada kopsummas.  Izmantojiet šo opciju, lai novērtētu ikdienas izdevumu paradumus un prognozētu mēneša vai gada rādītājus."]

{"sheet":"Gada naudas plūsma","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":4},"CEĻVEDIS","GADA NAUDAS PLŪSMA",null,"MĒNEŠA \nNAUDAS PLŪSMA"]
[null,"Kopējā naudas plūsma līdz šodienas datumam:",null,{"$f":"Gada_naudas_plūsma_līdz_šodienas_datumam","v":{"v":39750,"d":"39,750.00 EUR"}},null,null,"Šis ir gada novērtējums.  Izmantojiet šo darblapu, lai skatītu gada summas ar prognozētām mēneša vērtībām. Izmantojiet pārējās darblapas, lai pievienotu ikdienas darījumus."]
[null,"IENĀKUMU KOPSAVILKUMS",{"$nulls":3},"IZDEVUMU KOPSAVILKUMS",{"$nulls":3},"PERSONĪGO DARĪJUMU KOPSAVILKUMS",{"$nulls":3},"IETAUPĪJUMU KOPSAVILKUMS"]
[null,"Kopējā gada summa:",{"$f":"Ienākumi!C10","v":{"v":125000,"d":"125,000.00 EUR"}},null,null,"Kopējā gada summa:",{"$f":"Izdevumi[[#Totals],[Gadā  ]]","v":{"v":49000,"d":"49,000.00 EUR"}},null,null,"Kopējā gada summa:",{"$f":"Personīgie_darījumi[[#Totals],[Gadā  ]]","v":{"v":13250,"d":"13,250.00 EUR"}},null,null,"Kopējā gada summa:",{"$f":"Ietaupījumi[[#Totals],[Gadā  ]]","v":{"v":23000,"d":"23,000.00 EUR"}}]
[null,"Šajā šūnā ir sektoru diagramma, kurā parādīti ienākumi no dažādiem avotiem.",{"$nulls":3},"Šajā šūnā ir sektoru diagramma, kurā atspoguļoti izdevumi.",{"$nulls":3},"Šajā šūnā ir sektoru diagramma, kurā parādīti personīgo darījumu izdevumi.",{"$nulls":3},"Šajā šūnā ir sektoru diagramma, kurā parādīti ietaupījumi un ieguldījumi."]
[null,"Kopējā mēneša summa:",{"$f":"Ienākumi!D10","v":{"v":10416.666666666668,"d":"10,416.67 EUR"}},null,null,"Kopējā mēneša summa:",{"$f":"Izdevumi[[#Totals],[Mēnesī ]]","v":{"v":4083.333333333333,"d":"4,083.33 EUR"}},null,null,"Kopējā mēneša summa:",{"$f":"Personīgie_darījumi[[#Totals],[Mēnesī ]]","v":{"v":1104.1666666666665,"d":"1,104.17 EUR"}},null,null,"Kopējā mēneša summa:",{"$f":"Ietaupījumi!D9","v":{"v":1916.6666666666667,"d":"1,916.67 EUR"}}]

{"sheet":"Mēneša naudas plūsma","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":5},"CEĻVEDIS","GADA NAUDAS PLŪSMA","MĒNEŠA NAUDAS PLŪSMA","DIENAS KOPSAVILKUMS"]
[null,"Kopējā mēneša naudas plūsma:",null,{"$f":"Mēneša_naudas_plūsma_līdz_šodienas_datumam","v":{"v":18380,"d":"18,380.00 EUR"}},null,"PIEZĪME. Lai pievienotu ikdienas darījumus, aprēķiniet mēneša summu/vērtību un ierakstiet to atbilstošajā mēneša kolonnā."]
[null,"Veids","Apraksts","Jan","Feb","Mar","Apr","Mai","Jūn","Jūl","Aug","Sep","Okt","Nov","Dec","Kopā"]
[null,"Ienākumi","Atalgojums",{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"v":7500,"d":"7,500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":45000,"d":"45,000.00 EUR"}}]
[null,"Ienākumi","Komisijas maksas/prēmijas",{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":600,"d":"600.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":2100,"d":"2,100.00 EUR"}}]
[null,"Ienākumi","Citi 1",{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"v":2500,"d":"2,500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":15000,"d":"15,000.00 EUR"}}]
[null,"Ienākumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ienākumi","Citi 3",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ienākumi","Citi 4",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Sociālā/veselības apdrošināšana",{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Izdevumi","Ienākumu nodoklis",{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"v":208.33333333333334,"d":"208.33 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":1250,"d":"1,250.00 EUR"}}]
[null,"Izdevumi","Transportlīdzekļa nodoklis/izmaksas",{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"v":16.666666666666668,"d":"16.67 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":100.00000000000001,"d":"100.00 EUR"}}]
[null,"Izdevumi","Maksājumi par transportlīdzekli",{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"v":333.3333333333333,"d":"333.33 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":1999.9999999999998,"d":"2,000.00 EUR"}}]
[null,"Izdevumi","Hipotekārais kredīts/īre",{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"v":1250,"d":"1,250.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Izdevumi","Apdrošināšana",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Izdevumi","Elektrība",{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Izdevumi","Gāze",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Izdevumi","Ūdens",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Izdevumi","Kanalizācija",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Izdevumi","Atkritumi",{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"v":12.5,"d":"12.50 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":75,"d":"75.00 EUR"}}]
[null,"Izdevumi","Tālrunis",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Izdevumi","Internets",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Izdevumi","Dzīvības apdrošināšana/invaliditātes pabalsti",{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":125,"d":"125.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":750,"d":"750.00 EUR"}}]
[null,"Izdevumi","Pārtika",{"v":400,"d":"400.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":450,"d":"450.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":450,"d":"450.00 EUR"},{"v":425,"d":"425.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":2625,"d":"2,625.00 EUR"}}]
[null,"Izdevumi","Apģērbs",{"v":50,"d":"50.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":125,"d":"125.00 EUR"},{"v":75,"d":"75.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":500,"d":"500.00 EUR"}}]
[null,"Izdevumi","Medicīna/zobārstniecība",{"v":50,"d":"50.00 EUR"},{"v":10,"d":"10.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":20,"d":"20.00 EUR"},{"v":70,"d":"70.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":200,"d":"200.00 EUR"}}]
[null,"Izdevumi","Sabiedriskais transports",{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":20,"d":"20.00 EUR"},{"v":30,"d":"30.00 EUR"},{"v":30,"d":"30.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":170,"d":"170.00 EUR"}}]
[null,"Izdevumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Citi 3",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Citi 4",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Personīgie darījumi","Ēšana",{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Personīgie darījumi","Dāvanas",{"v":25,"d":"25.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":75,"d":"75.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Personīgie darījumi","Ceļojums",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":2000,"d":"2,000.00 EUR"}}]
[null,"Personīgie darījumi","Izklaide",{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":100,"d":"100.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":600,"d":"600.00 EUR"}}]
[null,"Personīgie darījumi","Personiskā higiēna",{"v":15,"d":"15.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":35,"d":"35.00 EUR"},{"v":15,"d":"15.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":35,"d":"35.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Personīgie darījumi","Iepirkšanās",{"v":100,"d":"100.00 EUR"},{"v":200,"d":"200.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":175,"d":"175.00 EUR"},{"v":150,"d":"150.00 EUR"},{"v":175,"d":"175.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":950,"d":"950.00 EUR"}}]
[null,"Personīgie darījumi","Labdarība",{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"v":50,"d":"50.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":300,"d":"300.00 EUR"}}]
[null,"Personīgie darījumi","Dalība klubos/abonementi",{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"v":25,"d":"25.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":150,"d":"150.00 EUR"}}]
[null,"Personīgie darījumi","Mājokļa uzlabojumi",{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"v":400,"d":"400.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":2400,"d":"2,400.00 EUR"}}]
[null,"Personīgie darījumi","Citi 1",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Personīgie darījumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ietaupījumi","Skaidras naudas rezerves",{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"v":416.6666666666667,"d":"416.67 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":2500,"d":"2,500.00 EUR"}}]
[null,"Ietaupījumi","Pensijas plāns/u.c.",{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"v":1000,"d":"1,000.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":6000,"d":"6,000.00 EUR"}}]
[null,"Ietaupījumi","Uzkrājumu/investīciju konts",{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"v":500,"d":"500.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"3,000.00 EUR"}}]
[null,"Ietaupījumi","Citi 1",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ietaupījumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"v":0,"d":"0.00 EUR"},{"$nulls":6},{"$f":"SUM(Mēnesī[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma",null,{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Jan])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Jan])","v":{"v":3692.5,"d":"3,692.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Feb])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Feb])","v":{"v":3247.5,"d":"3,247.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Mar])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Mar])","v":{"v":2522.5,"d":"2,522.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Apr])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Apr])","v":{"v":3427.5,"d":"3,427.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Mai])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Mai])","v":{"v":2887.5,"d":"2,887.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Jūn])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Jūn])","v":{"v":2602.5,"d":"2,602.50 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Jūl])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Jūl])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Aug])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Aug])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Sep])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Sep])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Okt])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Okt])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Nov])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Nov])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Dec])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Dec])","v":{"v":0,"d":"0.00 EUR"}},{"$f":"SUMIF(Mēnesī[Veids],\"Ienākumi\",Mēnesī[Kopā])-SUMIF(Mēnesī[Veids],\"<>Ienākumi\",Mēnesī[Kopā])","v":{"v":18380,"d":"18,380.00 EUR"}}]

{"sheet":"Dienas kopsavilkums","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,1,12]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":3},"CEĻVEDIS","MĒNEŠA \nNAUDAS PLŪSMA","DIENAS KOPSAVILKUMS","IENĀKUMI"]
[null,"Pieejamās skaidrās naudas kopsumma:",null,{"$f":"Dienas_naudas_plūsma","v":{"v":577.8399999999999,"d":"577.84 EUR"}},null,"PIEZĪME. Lai tabulā pievienotu ikdienas darījumus, aprēķiniet to mēneša summu/vērtību un ierakstiet to atbilstošajā mēneša kolonnā."]
[null,"DIENAS KOPSAVILKUMS"]
[null,"KOPSUMMAS","Dienā","Mēnesī","Gadā "]
[null,"Ienākumi",{"$f":"SUMIF(Dienā[Veids],$B5,Dienā[Dienā])","v":{"v":342.47,"d":"342.47 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B5,Dienā[Mēnesī])","v":{"v":10416.795833333334,"d":"10,416.80 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B5,Dienā[Gadā])","v":{"v":125001.55000000002,"d":"125,001.55 EUR"}}]
[null,"Izdevumi",{"$f":"SUMIF(Dienā[Veids],$B6,Dienā[Dienā])","v":{"v":136.05999999999997,"d":"136.06 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B6,Dienā[Mēnesī])","v":{"v":4138.491666666667,"d":"4,138.49 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B6,Dienā[Gadā])","v":{"v":49661.899999999994,"d":"49,661.90 EUR"}}]
[null,"Personīgie darījumi",{"$f":"SUMIF(Dienā[Veids],$B7,Dienā[Dienā])","v":{"v":36.29,"d":"36.29 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B7,Dienā[Mēnesī])","v":{"v":1103.8208333333334,"d":"1,103.82 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B7,Dienā[Gadā])","v":{"v":13245.849999999999,"d":"13,245.85 EUR"}}]
[null,"Ietaupījumi",{"$f":"SUMIF(Dienā[Veids],$B8,Dienā[Dienā])","v":{"v":63.019999999999996,"d":"63.02 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B8,Dienā[Mēnesī])","v":{"v":1916.8583333333333,"d":"1,916.86 EUR"}},{"$f":"SUMIF(Dienā[Veids],$B8,Dienā[Gadā])","v":{"v":23002.300000000003,"d":"23,002.30 EUR"}}]
[null,"Veids","Apraksts","Dienā","Mēnesī","Gadā"]
[null,"Ienākumi","Atalgojums",{"v":246.58,"d":"246.58 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":7500.141666666667,"d":"7,500.14 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":90001.70000000001,"d":"90,001.70 EUR"}}]
[null,"Ienākumi","Komisijas maksas/prēmijas",{"v":13.7,"d":"13.70 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Ienākumi","Citi 1",{"v":82.19,"d":"82.19 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":2499.945833333333,"d":"2,499.95 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":29999.35,"d":"29,999.35 EUR"}}]
[null,"Ienākumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ienākumi","Citi 3",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ienākumi","Citi 4",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Sociālā/veselības apdrošināšana",{"v":41.1,"d":"41.10 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":1250.125,"d":"1,250.13 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":15001.5,"d":"15,001.50 EUR"}}]
[null,"Izdevumi","Ienākumu nodoklis",{"v":6.85,"d":"6.85 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":208.35416666666666,"d":"208.35 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":2500.25,"d":"2,500.25 EUR"}}]
[null,"Izdevumi","Transportlīdzekļa nodoklis/izmaksas",{"v":0.55,"d":"0.55 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":16.729166666666668,"d":"16.73 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":200.75000000000003,"d":"200.75 EUR"}}]
[null,"Izdevumi","Maksājumi par transportlīdzekli",{"v":10.96,"d":"10.96 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":333.3666666666667,"d":"333.37 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":4000.4,"d":"4,000.40 EUR"}}]
[null,"Izdevumi","Hipotekārais kredīts/īre",{"v":41.1,"d":"41.10 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":1250.125,"d":"1,250.13 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":15001.5,"d":"15,001.50 EUR"}}]
[null,"Izdevumi","Apdrošināšana",{"v":0.68,"d":"0.68 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":20.683333333333334,"d":"20.68 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":248.20000000000002,"d":"248.20 EUR"}}]
[null,"Izdevumi","Elektrība",{"v":3.29,"d":"3.29 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Izdevumi","Gāze",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Izdevumi","Ūdens",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Izdevumi","Kanalizācija",{"v":0.82,"d":"0.82 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Izdevumi","Atkritumi",{"v":0.41,"d":"0.41 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":12.470833333333331,"d":"12.47 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":149.64999999999998,"d":"149.65 EUR"}}]
[null,"Izdevumi","Tālrunis",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Izdevumi","Internets",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Izdevumi","Dzīvības apdrošināšana/invaliditātes pabalsti",{"v":4.11,"d":"4.11 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":125.0125,"d":"125.01 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":1500.15,"d":"1,500.15 EUR"}}]
[null,"Izdevumi","Pārtika",{"v":13.7,"d":"13.70 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Izdevumi","Apģērbs",{"v":3.29,"d":"3.29 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Izdevumi","Medicīna/zobārstniecība",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Izdevumi","Sabiedriskais transports",{"v":1,"d":"1.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":30.416666666666668,"d":"30.42 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":365,"d":"365.00 EUR"}}]
[null,"Izdevumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Citi 3",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Izdevumi","Citi 4",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Personīgie darījumi","Ēšana",{"v":3.29,"d":"3.29 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Personīgie darījumi","Dāvanas",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Personīgie darījumi","Ceļojums",{"v":6.16,"d":"6.16 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":187.36666666666667,"d":"187.37 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":2248.4,"d":"2,248.40 EUR"}}]
[null,"Personīgie darījumi","Izklaide",{"v":3.29,"d":"3.29 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":100.07083333333333,"d":"100.07 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":1200.85,"d":"1,200.85 EUR"}}]
[null,"Personīgie darījumi","Personiskā higiēna",{"v":0.82,"d":"0.82 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Personīgie darījumi","Iepirkšanās",{"v":5.48,"d":"5.48 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":166.68333333333334,"d":"166.68 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":2000.2,"d":"2,000.20 EUR"}}]
[null,"Personīgie darījumi","Labdarība",{"v":1.64,"d":"1.64 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":49.883333333333326,"d":"49.88 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":598.5999999999999,"d":"598.60 EUR"}}]
[null,"Personīgie darījumi","Dalība klubos/abonementi",{"v":0.82,"d":"0.82 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":24.941666666666663,"d":"24.94 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":299.29999999999995,"d":"299.30 EUR"}}]
[null,"Personīgie darījumi","Mājokļa uzlabojumi",{"v":13.15,"d":"13.15 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":399.9791666666667,"d":"399.98 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":4799.75,"d":"4,799.75 EUR"}}]
[null,"Personīgie darījumi","Citi 1",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Personīgie darījumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ietaupījumi","Skaidras naudas rezerves",{"v":13.7,"d":"13.70 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":416.7083333333333,"d":"416.71 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":5000.5,"d":"5,000.50 EUR"}}]
[null,"Ietaupījumi","Pensijas plāns/u.c.",{"v":32.88,"d":"32.88 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":1000.1,"d":"1,000.10 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":12001.2,"d":"12,001.20 EUR"}}]
[null,"Ietaupījumi","Uzkrājumu/investīciju konts",{"v":16.44,"d":"16.44 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":500.05,"d":"500.05 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":6000.6,"d":"6,000.60 EUR"}}]
[null,"Ietaupījumi","Citi 1",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Ietaupījumi","Citi 2",{"v":0,"d":"0.00 EUR"},{"$f":"Dienā[[#This Row],[Gadā]]/12","v":{"v":0,"d":"0.00 EUR"}},{"$f":"Dienā[[#This Row],[Dienā]]*365","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma   ",null,{"$f":"SUMIF(Dienā[Veids],\"Ienākumi\",Dienā[Dienā])-SUMIF(Dienā[Veids],\"<>Ienākumi\",Dienā[Dienā])","v":{"v":107.10000000000014,"d":"107.10 EUR"}},{"$f":"SUMIF(Dienā[Veids],\"Ienākumi\",Dienā[Mēnesī])-SUMIF(Dienā[Veids],\"<>Ienākumi\",Dienā[Mēnesī])","v":{"v":3257.625,"d":"3,257.63 EUR"}},{"$f":"SUMIF(Dienā[Veids],\"Ienākumi\",Dienā[Gadā])-SUMIF(Dienā[Veids],\"<>Ienākumi\",Dienā[Gadā])","v":{"v":39091.500000000015,"d":"39,091.50 EUR"}}]

{"sheet":"Ienākumi","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":3},"CEĻVEDIS","DIENAS KOPSAVILKUMS","IENĀKUMI","IZDEVUMI"]
[null,"Kopējā naudas plūsma līdz šodienas datumam:",null,{"$f":"Gada_naudas_plūsma_līdz_šodienas_datumam","v":{"v":39750,"d":"39,750.00 EUR"}},null,"Šis ir gada novērtējums.  Izmantojiet šo darblapu, lai skatītu gada summas ar prognozētām mēneša vērtībām\nLai tabulā pievienotu ikdienas darījumus, aprēķiniet to gada summu/vērtību un ierakstiet to gada kolonnā."]
[null,"Ienākumi","Gadā  ","Mēnesī "]
[null,"Atalgojums",{"v":90000,"d":"90,000.00 EUR"},{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":7500,"d":"7,500.00 EUR"}}]
[null,"Komisijas maksas/prēmijas",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"Citi 1",{"v":30000,"d":"30,000.00 EUR"},{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":2500,"d":"2,500.00 EUR"}}]
[null,"Citi 2",null,{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi 3",null,{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi 4",null,{"$f":"Ienākumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma",{"$f":"SUBTOTAL(109,Ienākumi[[Gadā  ]])","v":{"v":125000,"d":"125,000.00 EUR"}},{"$f":"SUBTOTAL(109,Ienākumi[[Mēnesī ]])","v":{"v":10416.666666666668,"d":"10,416.67 EUR"}}]

{"sheet":"Izdevumi","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":3},"CEĻVEDIS","IENĀKUMI","IZDEVUMI","PERSONĪGIE DARĪJUMI"]
[null,"Kopējā naudas plūsma līdz šodienas datumam:",null,{"$f":"Gada_naudas_plūsma_līdz_šodienas_datumam","v":{"v":39750,"d":"39,750.00 EUR"}},null,"Šis ir gada novērtējums.  Izmantojiet šo darblapu, lai skatītu gada summas ar prognozētām mēneša vērtībām\nLai tabulā pievienotu ikdienas darījumus, aprēķiniet to gada summu/vērtību un ierakstiet to gada kolonnā."]
[null,"Izdevumi","Gadā  ","Mēnesī "]
[null,"Sociālā/veselības apdrošināšana",{"v":15000,"d":"15,000.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":1250,"d":"1,250.00 EUR"}}]
[null,"Ienākumu nodoklis",{"v":2500,"d":"2,500.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":208.33333333333334,"d":"208.33 EUR"}}]
[null,"Transportlīdzekļa nodoklis/izmaksas",{"v":200,"d":"200.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":16.666666666666668,"d":"16.67 EUR"}}]
[null,"Maksājumi par transportlīdzekli",{"v":4000,"d":"4,000.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":333.3333333333333,"d":"333.33 EUR"}}]
[null,"Hipotekārais kredīts/īre",{"v":15000,"d":"15,000.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":1250,"d":"1,250.00 EUR"}}]
[null,"Apdrošināšana",{"v":250,"d":"250.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":20.833333333333332,"d":"20.83 EUR"}}]
[null,"Elektrība",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Gāze",{"v":600,"d":"600.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Ūdens/kanalizācija",{"v":600,"d":"600.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Atkritumi",{"v":150,"d":"150.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":12.5,"d":"12.50 EUR"}}]
[null,"Tālrunis",{"v":600,"d":"600.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Internets",{"v":600,"d":"600.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Dzīvības apdrošināšana/invaliditātes pabalsti",{"v":1500,"d":"1,500.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":125,"d":"125.00 EUR"}}]
[null,"Pārtika",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"Apģērbs",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Medicīna/zobārstniecība",{"v":600,"d":"600.00 EUR"},{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Citi 1",null,{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi 2",null,{"$f":"Izdevumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma",{"$f":"SUBTOTAL(109,Izdevumi[[Gadā  ]])","v":{"v":49000,"d":"49,000.00 EUR"}},{"$f":"SUBTOTAL(109,Izdevumi[[Mēnesī ]])","v":{"v":4083.333333333333,"d":"4,083.33 EUR"}}]

{"sheet":"Personīgie darījumi","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":3},"CEĻVEDIS","IZDEVUMI","PERSONĪGIE DARĪJUMI","IETAUPĪJUMI"]
[null,"Kopējā naudas plūsma līdz šodienas datumam:",null,{"$f":"Gada_naudas_plūsma_līdz_šodienas_datumam","v":{"v":39750,"d":"39,750.00 EUR"}},null,"Šis ir gada novērtējums.  Izmantojiet šo darblapu, lai skatītu gada summas ar prognozētām mēneša vērtībām\nLai tabulā pievienotu ikdienas darījumus, aprēķiniet to gada summu/vērtību un ierakstiet to gada kolonnā."]
[null,"Personīgo darījumu izmaksas","Gadā  ","Mēnesī "]
[null,"Ēšana",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Dāvanas",{"v":600,"d":"600.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Ceļojums",{"v":2250,"d":"2,250.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":187.5,"d":"187.50 EUR"}}]
[null,"Izklaide",{"v":1200,"d":"1,200.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":100,"d":"100.00 EUR"}}]
[null,"Personiskā higiēna",{"v":300,"d":"300.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":25,"d":"25.00 EUR"}}]
[null,"Iepirkšanās",{"v":2000,"d":"2,000.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":166.66666666666666,"d":"166.67 EUR"}}]
[null,"Labdarība",{"v":600,"d":"600.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":50,"d":"50.00 EUR"}}]
[null,"Dalība klubos/abonementi",{"v":300,"d":"300.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":25,"d":"25.00 EUR"}}]
[null,"Mājokļa uzlabojumi",{"v":4800,"d":"4,800.00 EUR"},{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":400,"d":"400.00 EUR"}}]
[null,"Citi 1",null,{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi 2",null,{"$f":"Personīgie_darījumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma",{"$f":"SUBTOTAL(109,Personīgie_darījumi[[Gadā  ]])","v":{"v":13250,"d":"13,250.00 EUR"}},{"$f":"SUBTOTAL(109,Personīgie_darījumi[[Mēnesī ]])","v":{"v":1104.1666666666665,"d":"1,104.17 EUR"}}]

{"sheet":"Ietaupījumi","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"PERSONISKĀ NAUDAS PLŪSMA",{"$nulls":3},"CEĻVEDIS","PERSONĪGIE DARĪJUMI","IETAUPĪJUMI"]
[null,"Kopējā naudas plūsma līdz šodienas datumam:",null,{"$f":"Gada_naudas_plūsma_līdz_šodienas_datumam","v":{"v":39750,"d":"39,750.00 EUR"}},null,"Šis ir gada novērtējums.  Izmantojiet šo darblapu, lai skatītu gada summas ar prognozētām mēneša vērtībām\nLai tabulā pievienotu ikdienas darījumus, aprēķiniet to gada summu/vērtību un ierakstiet to gada kolonnā."]
[null,"Ietaupījumi","Gadā  ","Mēnesī "]
[null,"Skaidras naudas rezerves",{"v":5000,"d":"5,000.00 EUR"},{"$f":"Ietaupījumi[[#This Row],[Gadā  ]]/12","v":{"v":416.6666666666667,"d":"416.67 EUR"}}]
[null,"Pensijas plāns/u.c.",{"v":12000,"d":"12,000.00 EUR"},{"$f":"Ietaupījumi[[#This Row],[Gadā  ]]/12","v":{"v":1000,"d":"1,000.00 EUR"}}]
[null,"Uzkrājumi/investīcijas",{"v":6000,"d":"6,000.00 EUR"},{"$f":"Ietaupījumi[[#This Row],[Gadā  ]]/12","v":{"v":500,"d":"500.00 EUR"}}]
[null,"Citi 1",null,{"$f":"Ietaupījumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null,"Citi 2",null,{"$f":"Ietaupījumi[[#This Row],[Gadā  ]]/12","v":{"v":0,"d":"0.00 EUR"}}]
[null," Kopsumma",{"$f":"SUBTOTAL(109,Ietaupījumi[[Gadā  ]])","v":{"v":23000,"d":"23,000.00 EUR"}},{"$f":"SUBTOTAL(109,Ietaupījumi[[Mēnesī ]])","v":{"v":1916.6666666666667,"d":"1,916.67 EUR"}}]