{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Ievads","Kāpēc tas ir svarīgi","Merge cells - NĒ!","Macros","Table 1","Get data - datu tabula","Automatisks epasts","Tips&Tricks","Jautājumi"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ievads","index":0,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Mazāk klikšķu, vairāk rezultātu: Excel praksē"]
[null,null,null,null,null,null,"1. Kāpēc tas ir svarīgi"]
[null,null,null,null,null,null,"2. Merge cells - Pivot"]
[null,null,null,null,null,null,"3. Macros + MI"]
[null,null,null,null,null,null,"4. Get data"]
[null,null,null,null,null,null,"5. Epasta sūtīšana ar Excel"]
[null,null,null,null,null,null,"6. Padomi un \"triki\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*AI ģenerēts attēls",null,null,"Elvis Ērmanis"]

{"sheet":"Kāpēc tas ir svarīgi","index":1,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dati priekš \"Data validation\" H9 šūnā."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,"Darbinieku skaits, kas strādā Excelī",2,"darbinieki",null,null,null,null,null,null,null,null,"Macros",null,null,null,null,14]
[null,null,null,"Vidējais stundu skaits, ko darbinieks pavada Excelī dienā",3,"stundas",null,null,null,null,null,null,null,null,"Developer - Insert",null,"File-Options-Customize Ribbon-Ķeksis labajā pusē",null,null,15]
[null,null,null,"Darbinieka efektivitātes uzlabojums",20,"%",0,null,null,null,null,null,1,null,"Developer - Insert",null,null,null,null,16]
[null,null,null,"Vidējā darbinieka stundas attiecināmā izmaksa",{"$f":"H9","v":26},"EUR",null,26,"(izvēlies vērtību no saraksta)",null,null,null,null,null,"Data validation",null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,"Tavs ietaupījums:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,"Dienā -",{"$f":"E6*E7*E8/100*E9","v":31.2},"EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,"https://forms.gle/HSsE8k9rS9ztBRHE7"]
[null,null,null,"Mēnesī -",{"$f":"E12*20","v":624},"EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,"Gadā -",{"$f":"E13*12","v":7488},"EUR",null,{"$f":"\"Vai Tu gribu ietaupīt \"&E14&\" gadā gadā?\"","v":"Vai Tu gribu ietaupīt 7488 gadā gadā?"},null,null,null,null,null,null,"< -  Piespied \"Jā!\"",null,null,null,null,22]
[null,null,null,null,{"$f":"E14/E9","v":288},"Stundas gadā",null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,{"$f":"E15/8","v":36},"Dienas gadā",null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,27]
[null,null,null,null,null,null,null,null,"Zvani : 25994694, Elvis",null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,"Paldies un uz saziņu",null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]

{"sheet":"Merge cells - NĒ!","index":2,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,17,6,19]]}
[]
["1.","ALT + HOI","izlīdzina kolonu platumus"]
["2.","ALT + HOA","izlīdzina rindu augstumus"]
["3.","vlookup"]
["4.","Merge cells - Pivot tabula",null,null,null,null,null,"Vismīļakais auglis"]
["5.","Datu organizēšana tabulā",null,null,"ID","Vārds","Statuss","Auglis","Augļa cena, EUR/kg"]
["6.","Pivot #2",null,null,101,"Jānis","Vismīļakais auglis","Ābols",{"$f":"VLOOKUP(H7,$R$8:$T$20,2,FALSE)","v":2.4900000000000002},{"$f":"HYPERLINK(\"mailto:\"&F7,\"Sūtīt epastu\")","v":"Sūtīt epastu"},null,null,null,null,null,null,null,"Atslēgas dati"]
["7.","Slicer",null,null,102,"Anna","Vismīļakais auglis","Ābols",2.4900000000000002,null,null,null,null,null,null,null,null,"Auglis","Augļa cena, EUR/kg","Krāsa"]
[8,"Data validation",null,null,103,"Mārtiņš","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Row Labels","Sum of Augļa cena, EUR/kg","Count of Augļa cena, EUR/kg2",null,null,null,null,"Ābols",2.4900000000000002,"sarkans"]
[null,null,null,null,104,"Līga","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Ananāss",2.4900000000000002,1,null,null,null,null,"Mango",1.49,"dzeltens"]
[null,"Montāžas Excel",null,null,105,"Andris","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Madara",2.4900000000000002,1,null,null,null,null,"Kivi",3.99,"brūns"]
[null,null,null,null,106,"Elīna","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Apelsīns",7.17,3,null,null,null,null,"Apelsīns",2.39,"oranžš"]
[null,null,null,null,107,"Rihards","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Inese",2.39,1,null,null,null,null,"Banāns",40,"dzeltens"]
[null,null,null,null,108,"Zane","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Līga",2.39,1,null,null,null,null,"Melone",1.49,"zaļgana"]
[null,null,null,null,109,"Kaspars","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Nils",2.39,1,null,null,null,null,"Arbūzs",1.19,"zaļš"]
[null,null,null,null,110,"Ilze","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Arbūzs",2.38,2,null,null,null,null,"Vīnoga",4.9800000000000004,"zaļa"]
[null,null,null,null,111,"Artūrs","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Kristīne",1.19,1,null,null,null,null,"Persiks",3.49,"oranžš"]
[null,null,null,null,112,"Madara","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Rihards",1.19,1,null,null,null,null,"Plūme",2.99,"violeta"]
[null,null,null,null,113,"Edgars","Vismīļakais auglis","Vīnoga",4.9800000000000004,null,"Ābols",39.840000000000018,16,null,null,null,null,"Ananāss",2.4900000000000002,"dzeltens"]
[null,null,null,null,114,"Kristīne","Vismīļakais auglis","Arbūzs",1.19,null,"Andris",2.4900000000000002,1,null,null,null,null,"Bumbieris",2.29,"zaļš"]
[null,null,null,null,115,"Toms","Vismīļakais auglis","Melone",1.49,null,"Anna",2.4900000000000002,1]
[null,null,null,null,116,"Baiba","Vismīļakais auglis","Banāns",40,null,"Artūrs",2.4900000000000002,1]
[null,null,null,null,117,"Nils","Vismīļakais auglis","Apelsīns",2.39,null,"Baiba",2.4900000000000002,1]
[null,null,null,null,118,"Inese","Vismīļakais auglis","Kivi",3.99,null,"Elīna",2.4900000000000002,1]
[null,null,null,null,119,"Uģis","Vismīļakais auglis","Mango",1.49,null,"Ilze",2.4900000000000002,1]
[null,null,null,null,120,"Laura","Vismīļakais auglis","Ābols",2.4900000000000002,null,"Jānis",4.9800000000000004,2]
[null,null,null,null,101,"Jānis","Otrs mīļakais auglis","Ābols",{"$f":"VLOOKUP(H27,$R$8:$T$20,2,FALSE)","v":2.4900000000000002},null,"Kaspars",2.4900000000000002,1]
[null,null,null,null,102,"Anna","Otrs mīļakais auglis","Mango",1.49,null,"Laura",4.9800000000000004,2]
[null,null,null,null,103,"Mārtiņš","Otrs mīļakais auglis","Kivi",3.99,null,"Līga",2.4900000000000002,1]
[null,null,null,null,104,"Līga","Otrs mīļakais auglis","Apelsīns",2.39,null,"Madara",2.4900000000000002,1]
[null,null,null,null,105,"Andris","Otrs mīļakais auglis","Banāns",40,null,"Mārtiņš",2.4900000000000002,1]
[null,null,null,null,106,"Elīna","Otrs mīļakais auglis","Melone",1.49,null,"Rihards",2.4900000000000002,1]
[null,null,null,null,107,"Rihards","Otrs mīļakais auglis","Arbūzs",1.19,null,"Zane",2.4900000000000002,1]
[null,null,null,null,108,"Zane","Otrs mīļakais auglis","Vīnoga",4.9800000000000004,null,"Banāns",160,4]
[null,null,null,null,109,"Kaspars","Otrs mīļakais auglis","Vīnoga",4.9800000000000004,null,"Andris",40,1]
[null,null,null,null,110,"Ilze","Otrs mīļakais auglis","Persiks",3.49,null,"Baiba",40,1]
[null,null,null,null,111,"Artūrs","Otrs mīļakais auglis","Plūme",2.99,null,"Edgars",40,1]
[null,null,null,null,112,"Madara","Otrs mīļakais auglis","Ananāss",2.4900000000000002,null,"Uģis",40,1]
[null,null,null,null,113,"Edgars","Otrs mīļakais auglis","Banāns",40,null,"Bumbieris",2.29,1]
[null,null,null,null,114,"Kristīne","Otrs mīļakais auglis","Mango",1.49,null,"Nils",2.29,1]
[null,null,null,null,115,"Toms","Otrs mīļakais auglis","Kivi",3.99,null,"Kivi",11.97,3]
[null,null,null,null,116,"Baiba","Otrs mīļakais auglis","Ābols",2.4900000000000002,null,"Inese",3.99,1]
[null,null,null,null,117,"Nils","Otrs mīļakais auglis","Bumbieris",2.29,null,"Mārtiņš",3.99,1]
[null,null,null,null,118,"Inese","Otrs mīļakais auglis","Apelsīns",2.39,null,"Toms",3.99,1]
[null,null,null,null,119,"Uģis","Otrs mīļakais auglis","Banāns",40,null,"Mango",4.47,3]
[null,null,null,null,120,"Laura","Otrs mīļakais auglis","Ābols",2.4900000000000002,null,"Anna",1.49,1]
[null,null,null,null,null,null,null,null,null,null,"Kristīne",1.49,1]
[null,null,null,null,null,null,null,null,null,null,"Uģis",1.49,1]
[null,null,null,null,null,null,null,null,null,null,"Melone",2.98,2]
[null,null,null,null,null,null,null,null,null,null,"Elīna",1.49,1]
[null,null,null,null,null,null,null,null,null,null,"Toms",1.49,1]
[null,null,null,null,null,null,null,null,null,null,"Persiks",3.49,1]
[null,null,null,null,null,null,null,null,null,null,"Ilze",3.49,1]
[null,null,null,null,null,null,null,null,null,null,"Plūme",2.99,1]
[null,null,null,null,null,null,null,null,null,null,"Artūrs",2.99,1]
[null,null,null,null,null,null,null,null,null,null,"Vīnoga",14.940000000000001,3]
[null,null,null,null,null,null,null,null,null,null,"Edgars",4.9800000000000004,1]
[null,null,null,null,null,null,null,null,null,null,"Kaspars",4.9800000000000004,1]
[null,null,null,null,null,null,null,null,null,null,"Zane",4.9800000000000004,1]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",255.01000000000008,40]

{"sheet":"Macros","index":3,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["1","Standarta lietojuma Macros"]
["2","Kā izmantot Macrosu ar MI (ALT + F11)"]
["3","Macros ar random pogu 2. slaidā"]
[null,null,null,null,null,null,null,"1. Standarta lietojuma Macros",null,null,null,null,null,"2. Kā izmantot Macrosu ar MI (ALT + F11)"]
[null,"Ja ir slinkums vai neiespējami pietiekami detalizēti aprakstīt, kā nepieciešams pārveidot datus - var ierakstīt Macros manuāli un tad lūgt AI veikt korekcijas kodā"]
[]
[null,"CTRL+Z nestrādā pēc Macros palaišanas"]

{"sheet":"Table 1","index":4,"n_rows":41,"n_cols":21,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21"]
["Gurķis RIMI gab.",0,99,"€/gab.","3,30\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.49]
["Āboli Red Jonaprince 80-90 mm 1.šķira kg",0,99,"€/kg","0,99\n                    €/kg","1.12kg","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.29,null,null,null,null,null,null,null,null,"Aptuvenais gabalu skaits:"]
["Paprika Rimi saldā koniskā 250g",1,59,"€/gab.","6,36\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Skābais krējums Exporta 25% 360g",1,19,"€/gab.","3,31\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",2.19,4.82,null,null,null,2]
["Olas Rimi kūtī dētas A/M Nr.2 15 gab.",3,99,"€/gab.","0,27\n                    €/gab.","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",4.59]
["Cukini zaļi 325-375g/gab kg",2,99,"€/kg","2,99\n                    €/kg","0.37kg","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",4.99,null,null,null,null,null,null,null,null,"Aptuvenais gabalu skaits:"]
["Brokoļi RIMI 350 g",0,99,"€/gab.","2,83\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.89]
["Grieķu jogurts Baltais bez piedevām 400g",1,49,"€/gab.","3,72\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.75,3.2,null,null,null,2]
["Šampinjoni Rimi 250g",0,99,"€/gab.","3,96\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.39]
["Kviešu milti Dobele ekstra 2kg",2,29,"€/gab.","1,15\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,1,49,"0,75 €/kg",null,"30 dienu zemākā cena: 2,29 €",2.29]
["Biezpiena sieriņš Kārums vaniļas 45g",0,39,"€/gab.","8,67\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",0.52,6.71,null,null,null,2]
["Tomāti Romantica RIMI 1kl. 300g",1,99,"€/gab.","6,63\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",2.99]
["Vīnogas gaišās b/k Ivory 1.šk. kg",3,99,"€/kg","3,99\n                    €/kg","0.8kg","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",4.99]
["Salāti Rimi Roman gab.",1,39,"€/gab.","6,95\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Biezpiens Valmiera 5% 180g",0,99,"€/gab.","5,50\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.55,3.61,null,null,null,2]
["Biezenis I Love Eco āb.ban.zem.av.no 6mēn.90g",0,75,"€/gab.","8,33\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,null,null,null,null,"30 dienu zemākā cena: 0,59 €",0.59]
["Cāļu krūtiņas filejas gabaliņi Rimi 400g",2,79,"€/gab.","6,97\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",3.99]
["Piens Tere 2,5% 1,5l",1,19,"€/gab.","0,79\n                    €/l","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Ciets siers Rimi rīvēts 80g",0,99,"€/gab.","12,38\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.39,17.82,null,null,null,2]
["Redīsi sarkanie 500G",1,19,"€/gab.","2,38\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.49]
["Avokado, gab",0,59,"€/gab.","0,59\n                    €/gab.","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",0.89]
["Salāti Rimi Ledus, gab.",1,39,"€/gab.","4,63\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Cāļu stilbi Rimi 500g",1,69,"€/gab.","3,38\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",2.29]
["Biezenis I Love Eco āb.ban.aprik.no 6mēn.90g",0,75,"€/gab.","8,33\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,null,null,null,null,"30 dienu zemākā cena: 0,59 €",0.59]
["Vīnogas zaļās Autumn Crisp b/k 1.šķ 500g",1,69,"€/gab.","3,38\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",2.4900000000000002]
["Liellopa maltā gaļa Rimi 400g",3,99,"€/gab.","9,97\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",4.49]
["Mozzarella siers Rimi rīvēts 150g",1,59,"€/gab.","10,60\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.89]
["Pilnpiena biezpiens Valmiera 9% 180g",0,99,"€/gab.","5,50\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.59,3.61,null,null,null,2]
["Dilles Rimi 100g",1,19,"€/gab.","11,90\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.39]
["Cepumi Selga 180g",1,29,"€/gab.","7,17\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,0,79,"4,39 €/kg",null,"30 dienu zemākā cena: 1,29 €",1.29]
["Minerālūdens Tērvete gāzēts 1,5l",0,85,"€/gab.","0,57\n                    €/l","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,0,49,"0,33 €/l",null,null,null,"-42%","+ depozīts 0,10 €","4 un vairāk",0.85]
["Biezenis I Love Eco āb.ban.bum. no 6mēn.90g",0,59,"€/gab.","6,56\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",0.94]
["Marinēti gurķi Rimi 3-6cm 670g/370g",1,99,"€/gab.","5,38\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,1,59,"4,30 €/kg",null,"30 dienu zemākā cena: 1,99 €",1.99]
["Siers Džiugas rīvēts 40% 100g",1,79,"€/gab.","17,90\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",2.19,17.82,null,null,null,2]
["Siers Siera Nams Tilzītes kg",4,99,"€/kg","4,99\n                    €/kg","0.35kg","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",12.99]
["Piens Marge UHT 2% 1l",1,49,"€/gab.","1,49\n                    €/l","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.89,1.58,null,null,null,2]
["Minerālūdens Mangaļi gāzēts 1,5l",0,75,"€/gab.","0,50\n                    €/l","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,0,49,"0,33 €/l",null,null,null,"-35%","+ depozīts 0,10 €","2 un vairāk",0.75]
["Sēklu tostermaize bagātīgā 450g",1,55,"€/gab.","3,44\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Cepumi Rimi ar šokolādes gabaliņiem 150g",1,29,"€/gab.","8,60\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",1.99]
["Cukurs Rimi 1kg",0,99,"€/gab.","0,99\n                    €/kg","","Pievienot favorītiem","Pievienot grozam","Pievienot favorītiem",null,null,0,69,"0,69 €/kg",null,"30 dienu zemākā cena: 0,99 €",0.99]

{"sheet":"Get data - datu tabula","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Column1","Cena","Column4","Column5","Column16","Column22",null,null,"Kad Rimi akciju katalogs mājaslapā nomainīsies, pamēģini :"]
["Gurķis RIMI gab.",0.99,"€/gab.","3,30\n                    €/kg",null,null,null,null,"Data -> Refresh all"]
["Āboli Red Jonaprince 80-90 mm 1.šķira kg",0.99,"€/kg","0,99\n                    €/kg"]
["Paprika Rimi saldā koniskā 250g",1.5899999999999999,"€/gab.","6,36\n                    €/kg"]
["Skābais krējums Exporta 25% 360g",1.19,"€/gab.","3,31\n                    €/kg"]
["Olas Rimi kūtī dētas A/M Nr.2 15 gab.",3.99,"€/gab.","0,27\n                    €/gab."]
["Cukini zaļi 325-375g/gab kg",2.99,"€/kg","2,99\n                    €/kg"]
["Brokoļi RIMI 350 g",0.99,"€/gab.","2,83\n                    €/kg"]
["Grieķu jogurts Baltais bez piedevām 400g",1.49,"€/gab.","3,72\n                    €/kg"]
["Šampinjoni Rimi 250g",0.99,"€/gab.","3,96\n                    €/kg"]
["Kviešu milti Dobele ekstra 2kg",2.29,"€/gab.","1,15\n                    €/kg","30 dienu zemākā cena: 2,29 €"]
["Biezpiena sieriņš Kārums vaniļas 45g",0.39,"€/gab.","8,67\n                    €/kg"]
["Tomāti Romantica RIMI 1kl. 300g",1.99,"€/gab.","6,63\n                    €/kg"]
["Vīnogas gaišās b/k Ivory 1.šk. kg",3.99,"€/kg","3,99\n                    €/kg"]
["Salāti Rimi Roman gab.",1.3900000000000001,"€/gab.","6,95\n                    €/kg"]
["Biezpiens Valmiera 5% 180g",0.99,"€/gab.","5,50\n                    €/kg"]
["Biezenis I Love Eco āb.ban.zem.av.no 6mēn.90g",0.75,"€/gab.","8,33\n                    €/kg","30 dienu zemākā cena: 0,59 €","Regulārā cena: 0,94 €"]
["Cāļu krūtiņas filejas gabaliņi Rimi 400g",2.79,"€/gab.","6,97\n                    €/kg"]
["Piens Tere 2,5% 1,5l",1.19,"€/gab.","0,79\n                    €/l"]
["Ciets siers Rimi rīvēts 80g",0.99,"€/gab.","12,38\n                    €/kg"]
["Redīsi sarkanie 500G",1.19,"€/gab.","2,38\n                    €/kg"]
["Avokado, gab",0.59,"€/gab.","0,59\n                    €/gab."]
["Salāti Rimi Ledus, gab.",1.3900000000000001,"€/gab.","4,63\n                    €/kg"]
["Cāļu stilbi Rimi 500g",1.69,"€/gab.","3,38\n                    €/kg"]
["Biezenis I Love Eco āb.ban.aprik.no 6mēn.90g",0.75,"€/gab.","8,33\n                    €/kg","30 dienu zemākā cena: 0,59 €","Regulārā cena: 0,94 €"]
["Vīnogas zaļās Autumn Crisp b/k 1.šķ 500g",1.69,"€/gab.","3,38\n                    €/kg"]
["Liellopa maltā gaļa Rimi 400g",3.99,"€/gab.","9,97\n                    €/kg"]
["Mozzarella siers Rimi rīvēts 150g",1.5899999999999999,"€/gab.","10,60\n                    €/kg"]
["Pilnpiena biezpiens Valmiera 9% 180g",0.99,"€/gab.","5,50\n                    €/kg"]
["Dilles Rimi 100g",1.19,"€/gab.","11,90\n                    €/kg"]
["Cepumi Selga 180g",1.29,"€/gab.","7,17\n                    €/kg","30 dienu zemākā cena: 1,29 €"]
["Minerālūdens Tērvete gāzēts 1,5l",0.85,"€/gab.","0,57\n                    €/l"]
["Biezenis I Love Eco āb.ban.bum. no 6mēn.90g",0.59,"€/gab.","6,56\n                    €/kg"]
["Marinēti gurķi Rimi 3-6cm 670g/370g",1.99,"€/gab.","5,38\n                    €/kg","30 dienu zemākā cena: 1,99 €"]
["Siers Džiugas rīvēts 40% 100g",1.79,"€/gab.","17,90\n                    €/kg"]
["Siers Siera Nams Tilzītes kg",4.99,"€/kg","4,99\n                    €/kg"]
["Piens Marge UHT 2% 1l",1.49,"€/gab.","1,49\n                    €/l"]
["Minerālūdens Mangaļi gāzēts 1,5l",0.75,"€/gab.","0,50\n                    €/l"]
["Sēklu tostermaize bagātīgā 450g",1.55,"€/gab.","3,44\n                    €/kg"]
["Cepumi Rimi ar šokolādes gabaliņiem 150g",1.29,"€/gab.","8,60\n                    €/kg"]
["Cukurs Rimi 1kg",0.99,"€/gab.","0,99\n                    €/kg","30 dienu zemākā cena: 0,99 €"]

{"sheet":"Automatisks epasts","index":6,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Epasta tēma:","Tava dāvana"]
["Epasta teksts","Sveiciens mans vismīļākais kolēģi,"]
[]
[]
["ID","Epasts","Statuss","Auglis","Augļa cena, EUR/kg"]
[101,"Jānis@elvis.lv","Vismīļakais auglis","Ābols",2.4900000000000002,{"$f":"IF(E6>2,\"Tavs \"&D6&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tavs Ābols ir pārāk dārgs"},{"$f":"HYPERLINK(\"mailto:\" & B6 & \"?subject=\" & _xlfn.ENCODEURL($B$1) & \"&body=\" & _xlfn.ENCODEURL($B$2) & \"%0D%0A%0D%0A\" & _xlfn.ENCODEURL(F6), \"Sūtīt e‑pastu\")","v":"Sūtīt e‑pastu"}]
[102,"Anna@elvis.lv","Vismīļakais auglis","Banāns",1.39,{"$f":"IF(E7>2,\"Tavs \"&D7&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tevi HR kabinetā gaida veselīga dāvana"},{"$f":"HYPERLINK(\"mailto:\" & B7 & \"?subject=\" & _xlfn.ENCODEURL($B$1) & \"&body=\" & _xlfn.ENCODEURL($B$2) & \"%0D%0A%0D%0A\" & _xlfn.ENCODEURL(F7), \"Sūtīt e‑pastu\")","v":"Sūtīt e‑pastu"}]
[103,"Mārtiņš@elvis.lv","Vismīļakais auglis","Apelsīns",0.1,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[104,"Līga@elvis.lv","Vismīļakais auglis","Bumbieris",2.29,{"$f":"IF(E9>2,\"Tavs \"&D9&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tavs Bumbieris ir pārāk dārgs"},"Sūtīt e‑pastu"]
[105,"Andris@elvis.lv","Vismīļakais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]
[106,"Elīna@elvis.lv","Vismīļakais auglis","Kivi",3.99,"Tavs Kivi ir pārāk dārgs","Sūtīt e‑pastu"]
[107,"Rihards@elvis.lv","Vismīļakais auglis","Mango",1.49,{"$f":"IF(E12>2,\"Tavs \"&D12&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tevi HR kabinetā gaida veselīga dāvana"},"Sūtīt e‑pastu"]
[108,"Zane@elvis.lv","Vismīļakais auglis","Banāns",1.39,{"$f":"IF(E13>2,\"Tavs \"&D13&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tevi HR kabinetā gaida veselīga dāvana"},"Sūtīt e‑pastu"]
[109,"Kaspars@elvis.lv","Vismīļakais auglis","Ananāss",2.4900000000000002,{"$f":"IF(E14>2,\"Tavs \"&D14&\" ir pārāk dārgs\",\"Tevi HR kabinetā gaida veselīga dāvana\")","v":"Tavs Ananāss ir pārāk dārgs"},"Sūtīt e‑pastu"]
[110,"Ilze@elvis.lv","Vismīļakais auglis","Plūme",2.99,"Tavs Plūme ir pārāk dārgs","Sūtīt e‑pastu"]
[111,"Artūrs@elvis.lv","Vismīļakais auglis","Persiks",3.49,"Tavs Persiks ir pārāk dārgs","Sūtīt e‑pastu"]
[112,"Madara@elvis.lv","Vismīļakais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]
[113,"Edgars@elvis.lv","Vismīļakais auglis","Vīnoga",4.9800000000000004,"Tavs Vīnoga ir pārāk dārgs","Sūtīt e‑pastu"]
[114,"Kristīne@elvis.lv","Vismīļakais auglis","Arbūzs",1.19,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[115,"Toms@elvis.lv","Vismīļakais auglis","Melone",1.49,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[116,"Baiba@elvis.lv","Vismīļakais auglis","Banāns",1.39,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[117,"Nils@elvis.lv","Vismīļakais auglis","Apelsīns",2.39,"Tavs Apelsīns ir pārāk dārgs","Sūtīt e‑pastu"]
[118,"Inese@elvis.lv","Vismīļakais auglis","Kivi",3.99,"Tavs Kivi ir pārāk dārgs","Sūtīt e‑pastu"]
[119,"Uģis@elvis.lv","Vismīļakais auglis","Mango",1.49,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[120,"Laura@elvis.lv","Vismīļakais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]
[101,"Jānis@elvis.lv","Otrs mīļākais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]
[102,"Anna@elvis.lv","Otrs mīļākais auglis","Mango",1.49,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[103,"Mārtiņš@elvis.lv","Otrs mīļākais auglis","Kivi",3.99,"Tavs Kivi ir pārāk dārgs","Sūtīt e‑pastu"]
[104,"Līga@elvis.lv","Otrs mīļākais auglis","Apelsīns",2.39,"Tavs Apelsīns ir pārāk dārgs","Sūtīt e‑pastu"]
[105,"Andris@elvis.lv","Otrs mīļākais auglis","Banāns",1.39,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[106,"Elīna@elvis.lv","Otrs mīļākais auglis","Melone",1.49,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[107,"Rihards@elvis.lv","Otrs mīļākais auglis","Arbūzs",1.19,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[108,"Zane@elvis.lv","Otrs mīļākais auglis","Vīnoga",4.9800000000000004,"Tavs Vīnoga ir pārāk dārgs","Sūtīt e‑pastu"]
[109,"Kaspars@elvis.lv","Otrs mīļākais auglis","Vīnoga",4.9800000000000004,"Tavs Vīnoga ir pārāk dārgs","Sūtīt e‑pastu"]
[110,"Ilze@elvis.lv","Otrs mīļākais auglis","Persiks",3.49,"Tavs Persiks ir pārāk dārgs","Sūtīt e‑pastu"]
[111,"Artūrs@elvis.lv","Otrs mīļākais auglis","Plūme",2.99,"Tavs Plūme ir pārāk dārgs","Sūtīt e‑pastu"]
[112,"Madara@elvis.lv","Otrs mīļākais auglis","Ananāss",2.4900000000000002,"Tavs Ananāss ir pārāk dārgs","Sūtīt e‑pastu"]
[113,"Edgars@elvis.lv","Otrs mīļākais auglis","Banāns",1.39,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[114,"Kristīne@elvis.lv","Otrs mīļākais auglis","Mango",1.49,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[115,"Toms@elvis.lv","Otrs mīļākais auglis","Kivi",3.99,"Tavs Kivi ir pārāk dārgs","Sūtīt e‑pastu"]
[116,"Baiba@elvis.lv","Otrs mīļākais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]
[117,"Nils@elvis.lv","Otrs mīļākais auglis","Bumbieris",2.29,"Tavs Bumbieris ir pārāk dārgs","Sūtīt e‑pastu"]
[118,"Inese@elvis.lv","Otrs mīļākais auglis","Apelsīns",2.39,"Tavs Apelsīns ir pārāk dārgs","Sūtīt e‑pastu"]
[119,"Uģis@elvis.lv","Otrs mīļākais auglis","Banāns",1.39,"Tevi HR kabinetā gaida veselīga dāvana","Sūtīt e‑pastu"]
[120,"Laura@elvis.lv","Otrs mīļākais auglis","Ābols",2.4900000000000002,"Tavs Ābols ir pārāk dārgs","Sūtīt e‑pastu"]

{"sheet":"Tips&Tricks","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ja ļot gribam izmantot Merge, tad Center across selection"]
[null,null,null,"ALT","HOA"]
[null,null,null,"ALT","HOI"]
[null,null,null,"ALT","WEF",null,null,null,null,null,null,null,"Tabulas nosaukums"]
[null,null,null,"ALT","WN"]
[null,null,null,"CTRL ","Z"]
[null,null,null,"CTRL ","Y "]
[null,null,null,"CTRL ","G"]
[]
[null,null,null,null,null,"=TRANSLATE(D15;DETECTLANGUAGE(B89);\"lv\")"]
[null,null,null,"View - New window",null,{"$f":"_xlfn.TRANSLATE(D14,_xlfn.DETECTLANGUAGE(B89),\"lv\")","v":"Skats - jauns logs"}]
[null,null,null,"Formulas - Trace dependents",null,{"$f":"_xlfn.TRANSLATE(D15,_xlfn.DETECTLANGUAGE(B90),\"lv\")","v":"Formulas — atkarību izsekošana"}]
[null,null,null,"Formulas - Watch window",null,{"$f":"_xlfn.TRANSLATE(D16,_xlfn.DETECTLANGUAGE(B91),\"lv\")","v":"Formulas — skatīšanās logs"}]

{"sheet":"Jautājumi","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}