{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Brīvdienu budžets","Ierakstu saraksts","Saraksta informācija"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Brīvdienu budžets","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[2,3,5,5],[6,4,12,4],[6,5,12,5],[7,3,22,3],[13,4,19,4],[13,5,20,5]]}
[null,"Svētku iepirkšanās budžets",null,null,"Šajā šūnā ir lampiņu virtene.","UZ IERAKSTU SARAKSTS >"]
[{"$nulls":5},"UZ SARAKSTA INFORMĀCIJA >"]
[null,"KOPSUMMAS",null,"Sagrupētu joslu diagramma, kurā attēlots izmaksu sadalījums un līdz šodienas datumam iztērētā summa šajā šūnā."]
[null,"IZMAKSU SADALĪJUMS",{"$f":"SUM(DāvanasDati[CENA])","v":{"v":377,"d":"377.00 EUR"}}]
[null,"LĪDZ ŠODIENAS DATUMAM IZTĒRĒTĀ SUMMA",{"$f":"SUMIF(DāvanasDati[IEGĀDĀTS],\"Iegādāts\",DāvanasDati[CENA])","v":{"v":233,"d":"233.00 EUR"}}]
[null,"STARPĪBA",{"$f":"C4-C5","v":{"v":144,"d":"144.00 EUR"}}]
[null,"Lai atjauninātu atskaiti, atsvaidziniet to.",null,null,"Datu griezums, lai tabulas datus filtrētu atbilstoši Iesaiņojuma statuss, ir šajā šūnā.","Datu griezums, lai tabulas datus filtrētu atbilstoši iegādāts dāvanām, ir šajā šūnā."]
[null,"SADALĪJUMS",null,"Datu griezums, lai tabulas datus filtrētu atbilstoši saņēmējs, ir šajā šūnā."]
[null,null,"Dāvanu izmaksas"]
[null,"3. vārds"]
[null,"Iegādāts"]
[null,"Rotaļu vilciens",{"v":26,"d":"26.00 EUR"}]
[null,"Puzle",{"v":16,"d":"16.00 EUR"}]
[{"$nulls":4},"Datu griezums, lai tabulas datus filtrētu atbilstoši Piegādes statuss, ir šajā šūnā.","Datu griezums, lai tabulas datus filtrētu atbilstoši dāvanas kategorija, ir šajā šūnā."]
[null,"Nav iegādāts"]
[null,"Divritenis",{"v":29,"d":"29.00 EUR"}]
[]
[null,"2. vārds"]
[null,"Iegādāts"]
[null,"Zeķes",{"v":23,"d":"23.00 EUR"}]
[null,"Leļļu māja",{"v":36,"d":"36.00 EUR"}]
[]
[null,"4. vārds"]
[null,"Iegādāts"]
[null,"Izgriezumu albumu materiāli",{"v":14,"d":"14.00 EUR"}]
[null,"Fotoalbums",{"v":30,"d":"30.00 EUR"}]
[]
[null,"5. vārds"]
[null,"Iegādāts"]
[null,"Xbox spēle",{"v":49,"d":"49.00 EUR"}]
[]
[null,"Nav iegādāts"]
[null,"Krekls",{"v":37,"d":"37.00 EUR"}]
[null,"Dāvanu karte",{"v":32,"d":"32.00 EUR"}]
[]
[null,"1. vārds"]
[null,"Iegādāts"]
[null,"Džemperis",{"v":39,"d":"39.00 EUR"}]
[]
[null,"6. vārds"]
[null,"Nav iegādāts"]
[null,"Zeķes",{"v":46,"d":"46.00 EUR"}]
[]
[null,"Kopsumma",{"v":377,"d":"377.00 EUR"}]

{"sheet":"Ierakstu saraksts","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"Pirkumu saraksts",null,"Šajā šūnā ir lampiņu virtene.",{"$nulls":3},"UZ SARAKSTA INFORMĀCIJA >"]
[{"$nulls":7},"< UZ BRĪVDIENU BUDŽETS"]
[null,"SAŅĒMĒJS","DĀVANAS KATEGORIJA","DĀVANA","CENA","IEGĀDĀTS","PIEGĀDES STATUSS","IESAIŅOJUMA STATUSS"]
[null,"3. vārds","Ģimenes dāvana","Rotaļu vilciens",{"v":26,"d":"26.00 EUR"},"Iegādāts","Piegādāts","Iesaiņots"]
[null,"2. vārds","Vispārīga dāvana","Zeķes",{"v":23,"d":"23.00 EUR"},"Iegādāts","Piegādāts","Iesaiņots"]
[null,"3. vārds","Vispārīga dāvana","Puzle",{"v":16,"d":"16.00 EUR"},"Iegādāts","Piegādāts","Nav iesaiņots"]
[null,"4. vārds","Vispārīga dāvana","Izgriezumu albumu materiāli",{"v":14,"d":"14.00 EUR"},"Iegādāts","Piegādē","Nav iesaiņots"]
[null,"5. vārds","Vispārīga dāvana","Xbox spēle",{"v":49,"d":"49.00 EUR"},"Iegādāts","Piegādē","Nav iesaiņots"]
[null,"5. vārds","Vispārīga dāvana","Krekls",{"v":37,"d":"37.00 EUR"},"Nav iegādāts","Piegādē","Nav iesaiņots"]
[null,"1. vārds","Vispārīga dāvana","Džemperis",{"v":39,"d":"39.00 EUR"},"Iegādāts","Piegādē","Nav iesaiņots"]
[null,"2. vārds","Vispārīga dāvana","Leļļu māja",{"v":36,"d":"36.00 EUR"},"Iegādāts","Piegādāts","Nav iesaiņots"]
[null,"3. vārds","Vispārīga dāvana","Divritenis",{"v":29,"d":"29.00 EUR"},"Nav iegādāts"]
[null,"4. vārds","Vispārīga dāvana","Fotoalbums",{"v":30,"d":"30.00 EUR"},"Iegādāts","Piegādāts"]
[null,"5. vārds","Vispārīga dāvana","Dāvanu karte",{"v":32,"d":"32.00 EUR"},"Nav iegādāts"]
[null,"6. vārds","Vispārīga dāvana","Zeķes",{"v":46,"d":"46.00 EUR"},"Nav iegādāts"]

{"sheet":"Saraksta informācija","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"Saraksta informācija","Šajā šūnā ir lampiņu virtene.",null,"< UZ IERAKSTU SARAKSTS"]
[{"$nulls":4},"< UZ BRĪVDIENU BUDŽETS"]
[null,"PERSONAS",null,"DĀVANU KATEGORIJAS"]
[null,"1. vārds",null,"Dāvanu zeķe"]
[null,"2. vārds",null,"Vispārīga dāvana"]
[null,"3. vārds",null,"Dzīvesbiedra dāvana"]
[null,"4. vārds",null,"Ģimenes dāvana"]
[null,"5. vārds",null,"Īpaša dāvana"]
[null,"6. vārds"]