{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Informācijas panelis","Izdevumu žurnāls","Personisko izdevumu dati"],"not_rendered":{"charts":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Informācijas panelis","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,1,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,"personisko izdevumu informācijas panelis",{"$nulls":3},"uz izdevumu žurnālu >"]
[null,"Šajā šūnā ir rakursdiagramma, kurā ir parādīti izdevumi pēc kategorijas un mēneša. Zemāk šūnās B3, D3 un F3 ir datu griezumi izdevumu filtrēšanai pēc datuma, kategorijas un apakškategorijas."]
[null,"Šajā šūnā ir datu griezums tabulas datu filtrēšanai pēc datuma.",null,"Šajā šūnā ir datu griezums tabulas datu filtrēšanai pēc kategorijas.",null,"Šajā šūnā ir datu griezums tabulas datu filtrēšanai pēc apakškategorijas."]

{"sheet":"Izdevumu žurnāls","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"izdevumu žurnāls",{"$nulls":3},"< uz informācijas paneli"]
[null,"datums","kategorija","apakškategorija","summa","piezīme"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2018-03-02"},"Mājoklis","Internets",{"v":29,"d":"29.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2018-03-02"},"Mājoklis","Fiksētais tālrunis",{"v":39,"d":"39.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2018-03-04"},"Mājoklis","Elektrība",{"v":62,"d":"62.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2018-03-04"},"Izklaide","Sporta zāle",{"v":29,"d":"29.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2018-03-06"},"Ikdienas","Apģērbs",{"v":42,"d":"42.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2018-03-06"},"Transports","Sabiedriskais transports",{"v":21,"d":"21.00 EUR"},"Braukšanas biļete martā"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2018-04-02"},"Transports","Degviela",{"v":54,"d":"54.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2018-04-02"},"Ikdienas","Frizieris",{"v":12,"d":"12.00 EUR"}]
[null,"2018-04-02","Ikdienas","Tēja/kafija",{"v":12,"d":"12.00 EUR"}]
[null,"2018-04-02","Ikdienas","Saldumi",{"v":2.75,"d":"2.75 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Mājoklis","Internets",{"v":29,"d":"29.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Mājoklis","Fiksētais tālrunis",{"v":39,"d":"39.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Mājoklis","Elektrība",{"v":62,"d":"62.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2018-04-04"},"Ikdienas","Kontaktlēcas",{"v":29,"d":"29.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2018-04-06"},"Ikdienas","Apģērbs",{"v":42,"d":"42.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2018-04-06"},"Transports","Sabiedriskais transports",{"v":21,"d":"21.00 EUR"},"Braukšanas biļete aprīlī"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2018-05-01"},"Transports","Degviela",{"v":54,"d":"54.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Ikdienas","Frizieris",{"v":12,"d":"12.00 EUR"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2018-07-01"},"Izklaide","Kino",{"v":21,"d":"21.00 EUR"},"Klasisko filmu nakts"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2018-08-01"},"Ikdienas","Saldumi",{"v":2.75,"d":"2.75 EUR"}]

{"sheet":"Personisko izdevumu dati","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"personisko izdevumu dati"]
[null,"Tālāk esošā rakurstabula ir informācijas panelī esošās personisko izdevumu rakursdiagrammas datu avots. Veiktās izmaiņas var radīt vizuālas modifikācijas rakursdiagrammā vai kļūdas."]
[null,"Rindu etiķetes","Summa no summa"]
[null,"marts",222]
[null,"Izklaide",29]
[null,"Transports",21]
[null,"Ikdienas",42]
[null,"Mājoklis",130]
[null,"apr",302.75]
[null,"Transports",75]
[null,"Ikdienas",97.75]
[null,"Mājoklis",130]
[null,"maijs",54]
[null,"Transports",54]
[null,"jūn",12]
[null,"Ikdienas",12]
[null,"jūl",21]
[null,"Izklaide",21]
[null,"aug",2.75]
[null,"Ikdienas",2.75]
[null,"Gala summa",614.5]