{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["padomi","kopsavilkums","jan","feb","mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec"],"not_rendered":{"charts":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"padomi","index":0,"n_rows":18,"n_cols":1,"rows_kept":18}
["PADOMI PAR VEIDNI"]
["Vai pastāv vienkāršs veids, kā pāriet no kopsavilkuma lapas Izdevumu tendences uz detalizētu mēnešu izdevumu lapām un pretēji?"]
["Lai ātri pārietu uz noteikta mēneša izdevumiem, noklikšķiniet uz saistītās navigācijas saites virs diagrammas, piemēram, navigācijas saites Jan šūnā B2. Lai atgrieztos darblapā Izdevumu tendences, noklikšķiniet uz navigācijas saites Kopsavilkums šūnā D1. "]
["Lai atgrieztos šajā padomu darblapā, kopsavilkuma darblapā atlasiet šūnu N2. Jebkura mēneša darblapā atlasiet šūnu E1."]
["Kā izdevumu kopsavilkumā pievienot jaunu izdevumu veidu vai jaunus ikmēneša izdevumus?"]
["Izmaksu kopsavilkums zem diagrammas un katra mēneša detalizētais izdevumu skats ir Excel tabulas. Lai jebkurai Excel tabulai pievienotu jaunu rindu, veiciet kādu no tālāk aprakstītajām darbībām."]
[{"$f":"ROW(A1)&\". Ja tabulā nav kopsummas rindas, sāciet rakstīt zem tabulas, un tā tiks automātiski izvērsta, kad nospiedīsit taustiņu Enter vai tabulēšanas taustiņu.\"","v":"1. Ja tabulā nav kopsummas rindas, sāciet rakstīt zem tabulas, un tā tiks automātiski izvērsta, kad nospiedīsit taustiņu Enter vai tabulēšanas taustiņu."}]
[{"$f":"ROW(A2)&\". Novietojiet šūnas rādītāju pēdējā šūnā virs kopsummas rindas, piemēram, pēdējo izdevumu kopsummā, un pēc tam nospiediet tabulēšanas taustiņu.\"","v":"2. Novietojiet šūnas rādītāju pēdējā šūnā virs kopsummas rindas, piemēram, pēdējo izdevumu kopsummā, un pēc tam nospiediet tabulēšanas taustiņu."}]
[{"$f":"ROW(A3)&\". Ar peles labo pogu noklikšķiniet tabulā un uznirstošajā izvēlnē, norādiet uz Ievietot un pēc tam noklikšķiniet uz Tabulas rindas augstāk vai Tabulas rindas zemāk.\"","v":"3. Ar peles labo pogu noklikšķiniet tabulā un uznirstošajā izvēlnē, norādiet uz Ievietot un pēc tam noklikšķiniet uz Tabulas rindas augstāk vai Tabulas rindas zemāk."}]
[{"$f":"ROW(A4)&\". Tabulas apakšējā labajā stūrī novietojiet peli uz tabulas lielummaiņas tura un velciet uz leju, lai palielinātu pieejamo tabulas rindu skaitu.\"","v":"4. Tabulas apakšējā labajā stūrī novietojiet peli uz tabulas lielummaiņas tura un velciet uz leju, lai palielinātu pieejamo tabulas rindu skaitu."}]
["Ievadiet izdevumus darblapā kopsavilkums tabulas Izdevumu_kopsavilkums kolonnā Izdevumi."]
["Pievienojiet katra izdevumu veida izdevumu summu atbilstošā mēneša darblapā."]
["Piemērs. Izdevumi_1 ir bijuši no janvāra līdz jūnijam un decembrī. "]
[{"$f":"ROW(A1)&\". Vērtība Izdevumi_1 tiek ievietota kopsavilkuma darblapā tabulas Izdevumu_kopsavilkums sadaļā Izdevumi (kā izdevumu tipa virsraksts)\"","v":"1. Vērtība Izdevumi_1 tiek ievietota kopsavilkuma darblapā tabulas Izdevumu_kopsavilkums sadaļā Izdevumi (kā izdevumu tipa virsraksts)"}]
[{"$f":"ROW(A2)&\". Katrā mēnesī, kad rodas izdevumi, ievadiet izdevumu summu atbilstošā mēneša darblapā.\"","v":"2. Katrā mēnesī, kad rodas izdevumi, ievadiet izdevumu summu atbilstošā mēneša darblapā."}]
[{"$f":"ROW(A3)&\". Izdevums tips no darblapas Izdevumu_kopsavilkums izveido kategoriju sarakstu kolonnai Kategorija katra mēneša darblapā.\"","v":"3. Izdevums tips no darblapas Izdevumu_kopsavilkums izveido kategoriju sarakstu kolonnai Kategorija katra mēneša darblapā."}]
[{"$f":"ROW(A4)&\". Izmantojiet kategoriju sarakstu kolonnā Kategorija, lai atlasītu atbilstošo izdevumu veidu ievadītajai izdevumu summai\"","v":"4. Izmantojiet kategoriju sarakstu kolonnā Kategorija, lai atlasītu atbilstošo izdevumu veidu ievadītajai izdevumu summai"}]
[{"$f":"ROW(A5)&\". Lai kādam mēnesim pievienotu jaunus izdevumus, pievienojiet jaunu rindu tabulai Izdevumu_kopsavilkums kopsavilkuma darblapā, pēc tam ievadiet atbilstošo izdevumu detalizēto informāciju tā mēneša darblapā, uz kuru tie attiecas.\"","v":"5. Lai kādam mēnesim pievienotu jaunus izdevumus, pievienojiet jaunu rindu tabulai Izdevumu_kopsavilkums kopsavilkuma darblapā, pēc tam ievadiet atbilstošo izdevumu detalizēto informāciju tā mēneša darblapā, uz kuru tie attiecas."}]

{"sheet":"kopsavilkums","index":1,"n_rows":10,"n_cols":15,"rows_kept":10}
["IZDEVUMU TENDENCES"]
[null,"Jan","Feb","Mar","Apr","Mai","Jūn","Jūl","Aug","Sep","Okt","Nov","Dec","Padomi"]
[]
["Izdevumi","Jan","Feb","Mar","Apr","Mai","Jūn","Jūl","Aug","Sep","Okt","Nov","Dec","Kopsumma","Tendence"]
["Izdevumi_1",{"$f":"SUMIFS(Izd_jan[Summa],Izd_jan[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(Izd_feb[Summa],Izd_feb[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":375,"d":"375.00"}},{"$f":"SUMIFS(Izd_mar[Summa],Izd_mar[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(Izd_apr[Summa],Izd_apr[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":45,"d":"45.00"}},{"$f":"SUMIFS(Izd_mai[Summa],Izd_mai[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":375,"d":"375.00"}},{"$f":"SUMIFS(Izd_jūn[Summa],Izd_jūn[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":201,"d":"201.00"}},{"$f":"SUMIFS(Izd_jūl[Summa],Izd_jūl[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_aug[Summa],Izd_aug[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_sep[Summa],Izd_sep[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_okt[Summa],Izd_okt[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_nov[Summa],Izd_nov[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_dec[Summa],Izd_dec[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":201,"d":"201.00"}},{"$f":"SUM(Izdevumu_kopsavilkums[[#This Row],[Jan]:[Dec]])","v":{"v":1263,"d":"1,263.00"}}]
["Izdevumi_2",{"$f":"SUMIFS(Izd_jan[Summa],Izd_jan[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(Izd_feb[Summa],Izd_feb[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(Izd_mar[Summa],Izd_mar[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":238,"d":"238.00"}},{"$f":"SUMIFS(Izd_apr[Summa],Izd_apr[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":123,"d":"123.00"}},{"$f":"SUMIFS(Izd_mai[Summa],Izd_mai[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":111,"d":"111.00"}},{"$f":"SUMIFS(Izd_jūn[Summa],Izd_jūn[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":98,"d":"98.00"}},{"$f":"SUMIFS(Izd_jūl[Summa],Izd_jūl[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_aug[Summa],Izd_aug[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_sep[Summa],Izd_sep[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_okt[Summa],Izd_okt[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_nov[Summa],Izd_nov[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_dec[Summa],Izd_dec[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":440,"d":"440.00"}},{"$f":"SUM(Izdevumu_kopsavilkums[[#This Row],[Jan]:[Dec]])","v":{"v":1486,"d":"1,486.00"}}]
["Izdevumi_3",{"$f":"SUMIFS(Izd_jan[Summa],Izd_jan[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(Izd_feb[Summa],Izd_feb[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(Izd_mar[Summa],Izd_mar[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":110,"d":"110.00"}},{"$f":"SUMIFS(Izd_apr[Summa],Izd_apr[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":125,"d":"125.00"}},{"$f":"SUMIFS(Izd_mai[Summa],Izd_mai[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":333,"d":"333.00"}},{"$f":"SUMIFS(Izd_jūn[Summa],Izd_jūn[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":122,"d":"122.00"}},{"$f":"SUMIFS(Izd_jūl[Summa],Izd_jūl[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_aug[Summa],Izd_aug[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_sep[Summa],Izd_sep[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_okt[Summa],Izd_okt[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_nov[Summa],Izd_nov[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_dec[Summa],Izd_dec[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":122,"d":"122.00"}},{"$f":"SUM(Izdevumu_kopsavilkums[[#This Row],[Jan]:[Dec]])","v":{"v":1032,"d":"1,032.00"}}]
["Izdevumi_4",{"$f":"SUMIFS(Izd_jan[Summa],Izd_jan[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":426,"d":"426.00"}},{"$f":"SUMIFS(Izd_feb[Summa],Izd_feb[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":84,"d":"84.00"}},{"$f":"SUMIFS(Izd_mar[Summa],Izd_mar[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":84,"d":"84.00"}},{"$f":"SUMIFS(Izd_apr[Summa],Izd_apr[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":426,"d":"426.00"}},{"$f":"SUMIFS(Izd_mai[Summa],Izd_mai[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":125,"d":"125.00"}},{"$f":"SUMIFS(Izd_jūn[Summa],Izd_jūn[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":187,"d":"187.00"}},{"$f":"SUMIFS(Izd_jūl[Summa],Izd_jūl[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_aug[Summa],Izd_aug[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_sep[Summa],Izd_sep[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_okt[Summa],Izd_okt[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_nov[Summa],Izd_nov[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_dec[Summa],Izd_dec[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":187,"d":"187.00"}},{"$f":"SUM(Izdevumu_kopsavilkums[[#This Row],[Jan]:[Dec]])","v":{"v":1519,"d":"1,519.00"}}]
["Izdevumi_5",{"$f":"SUMIFS(Izd_jan[Summa],Izd_jan[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":54,"d":"54.00"}},{"$f":"SUMIFS(Izd_feb[Summa],Izd_feb[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":54,"d":"54.00"}},{"$f":"SUMIFS(Izd_mar[Summa],Izd_mar[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":109,"d":"109.00"}},{"$f":"SUMIFS(Izd_apr[Summa],Izd_apr[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":98,"d":"98.00"}},{"$f":"SUMIFS(Izd_mai[Summa],Izd_mai[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":33,"d":"33.00"}},{"$f":"SUMIFS(Izd_jūn[Summa],Izd_jūn[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":441,"d":"441.00"}},{"$f":"SUMIFS(Izd_jūl[Summa],Izd_jūl[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_aug[Summa],Izd_aug[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_sep[Summa],Izd_sep[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_okt[Summa],Izd_okt[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_nov[Summa],Izd_nov[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":0,"d":"0.00"}},{"$f":"SUMIFS(Izd_dec[Summa],Izd_dec[Kategorija],Izdevumu_kopsavilkums[Izdevumi])","v":{"v":99,"d":"99.00"}},{"$f":"SUM(Izdevumu_kopsavilkums[[#This Row],[Jan]:[Dec]])","v":{"v":888,"d":"888.00"}}]
["Kopsumma",{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Jan])","v":{"v":861,"d":"861.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Feb])","v":{"v":861,"d":"861.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Mar])","v":{"v":574,"d":"574.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Apr])","v":{"v":817,"d":"817.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Mai])","v":{"v":977,"d":"977.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Jūn])","v":{"v":1049,"d":"1,049.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Jūl])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Aug])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Sep])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Okt])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Nov])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Dec])","v":{"v":1049,"d":"1,049.00"}},{"$f":"SUBTOTAL(109,Izdevumu_kopsavilkums[Kopsumma])","v":{"v":6188,"d":"6,188.00"}}]

{"sheet":"jan","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["JANVĀRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),1,4)","v":"2017-01-04"},"A-12345",{"v":33,"d":"33.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),1,5)","v":"2017-01-05"},"A-12346",{"v":238,"d":"238.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_4"]
[null,null,{"v":110,"d":"110.00"},"Izdevumi_3"]
[null,null,{"v":84,"d":"84.00"},"Izdevumi_4"]
[null,null,{"v":54,"d":"54.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_jan[Summa])","v":{"v":861,"d":"861.00"}}]

{"sheet":"feb","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["FEBRUĀRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),2,3)","v":"2017-02-03"},"A-12345",{"v":33,"d":"33.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),2,4)","v":"2017-02-04"},"A-12346",{"v":238,"d":"238.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_1"]
[null,null,{"v":110,"d":"110.00"},"Izdevumi_3"]
[null,null,{"v":84,"d":"84.00"},"Izdevumi_4"]
[null,null,{"v":54,"d":"54.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_feb[Summa])","v":{"v":861,"d":"861.00"}}]

{"sheet":"mar","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["MARTA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),3,5)","v":"2017-03-05"},"A-12345",{"v":33,"d":"33.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2017-03-06"},"A-12346",{"v":238,"d":"238.00"},"Izdevumi_2"]
[null,null,{"v":55,"d":"55.00"},"Izdevumi_5"]
[null,null,{"v":110,"d":"110.00"},"Izdevumi_3"]
[null,null,{"v":84,"d":"84.00"},"Izdevumi_4"]
[null,null,{"v":54,"d":"54.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_mar[Summa])","v":{"v":574,"d":"574.00"}}]

{"sheet":"apr","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["APRĪĻA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2017-04-04"},"A-12345",{"v":45,"d":"45.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),4,8)","v":"2017-04-08"},"A-12346",{"v":123,"d":"123.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_4"]
[null,null,{"v":125,"d":"125.00"},"Izdevumi_3"]
[null,null,{"v":84,"d":"84.00"},"Izdevumi_4"]
[null,null,{"v":98,"d":"98.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_apr[Summa])","v":{"v":817,"d":"817.00"}}]

{"sheet":"mai","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["MAIJA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),5,3)","v":"2017-05-03"},"A-12345",{"v":33,"d":"33.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),5,8)","v":"2017-05-08"},"A-12346",{"v":111,"d":"111.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_1"]
[null,null,{"v":333,"d":"333.00"},"Izdevumi_3"]
[null,null,{"v":125,"d":"125.00"},"Izdevumi_4"]
[null,null,{"v":33,"d":"33.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_mai[Summa])","v":{"v":977,"d":"977.00"}}]

{"sheet":"jūn","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["JŪNIJA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),6,7)","v":"2017-06-07"},"A-12345",{"v":201,"d":"201.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),6,8)","v":"2017-06-08"},"A-12346",{"v":98,"d":"98.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_5"]
[null,null,{"v":122,"d":"122.00"},"Izdevumi_3"]
[null,null,{"v":187,"d":"187.00"},"Izdevumi_4"]
[null,null,{"v":99,"d":"99.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_jūn[Summa])","v":{"v":1049,"d":"1,049.00"}}]

{"sheet":"jūl","index":8,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["JŪLIJA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),7,9)","v":"2017-07-09"},"A-12345",null,"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),7,14)","v":"2017-07-14"},"A-12346",null,"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_3"]
[{"$nulls":3},"Izdevumi_4"]
[{"$nulls":3},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_jūl[Summa])","v":{"v":0,"d":"0.00"}}]

{"sheet":"aug","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["AUGUSTA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),8,8)","v":"2017-08-08"},"A-12345",null,"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),8,9)","v":"2017-08-09"},"A-12346",null,"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_3"]
[{"$nulls":3},"Izdevumi_4"]
[{"$nulls":3},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_aug[Summa])","v":{"v":0,"d":"0.00"}}]

{"sheet":"sep","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["SEPTEMBRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),9,9)","v":"2017-09-09"},"A-12345",null,"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),9,15)","v":"2017-09-15"},"A-12346",null,"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_3"]
[{"$nulls":3},"Izdevumi_4"]
[{"$nulls":3},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_sep[Summa])","v":{"v":0,"d":"0.00"}}]

{"sheet":"okt","index":11,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["OKTOBRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),10,10)","v":"2017-10-10"},"A-12345",null,"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),10,21)","v":"2017-10-21"},"A-12346",null,"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_3"]
[{"$nulls":3},"Izdevumi_4"]
[{"$nulls":3},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_okt[Summa])","v":{"v":0,"d":"0.00"}}]

{"sheet":"nov","index":12,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["NOVEMBRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),11,14)","v":"2017-11-14"},"A-12345",null,"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),11,21)","v":"2017-11-21"},"A-12346",null,"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_2"]
[{"$nulls":3},"Izdevumi_3"]
[{"$nulls":3},"Izdevumi_4"]
[{"$nulls":3},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_nov[Summa])","v":{"v":0,"d":"0.00"}}]

{"sheet":"dec","index":13,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,2]]}
["DECEMBRA IZDEVUMI",null,null,"Kopsavilkums","Padomi"]
["Datums","Čeka numurs","Summa","Kategorija","Apraksts"]
[{"$f":"DATE(YEAR(TODAY()),12,2)","v":"2017-12-02"},"A-12345",{"v":201,"d":"201.00"},"Izdevumi_1","Materiāli"]
[{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2017-12-24"},"A-12346",{"v":98,"d":"98.00"},"Izdevumi_2"]
[null,null,{"v":342,"d":"342.00"},"Izdevumi_2"]
[null,null,{"v":122,"d":"122.00"},"Izdevumi_3"]
[null,null,{"v":187,"d":"187.00"},"Izdevumi_4"]
[null,null,{"v":99,"d":"99.00"},"Izdevumi_5"]
["Kopsumma",null,{"$f":"SUBTOTAL(109,Izd_dec[Summa])","v":{"v":1049,"d":"1,049.00"}}]