{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pārdošanas dati","Pārdošanas atskaite","Krājumi"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Pārdošanas dati","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"AR KASES APARĀTU IETIRGOTAIS DIENĀ"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"DATUMS","LAIKS","TRANSAKCIJAS NUMURS","NV/PRODUKTA NUMURS","APRAKSTS","PĀRDOŠANAS SUMMA","NODOKĻI ","PVN","KOPĀ"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"\",VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"No description found\")","v":"Sega"},{"v":74.95,"d":"74.95 €"},{"v":0.05,"d":"5.00%"},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]*tblPārdošanasDati[[#This Row],[NODOKĻI ]]","v":{"v":3.7475000000000005,"d":"3.75 €"}},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]+tblPārdošanasDati[[#This Row],[PVN]]","v":{"v":78.6975,"d":"78.70 €"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"\",VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"No description found\")","v":"Galdauts, 1,8 m apkārtmērs"},{"v":34.99,"d":"34.99 €"},{"v":0.05,"d":"5.00%"},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]*tblPārdošanasDati[[#This Row],[NODOKĻI ]]","v":{"v":1.7495000000000003,"d":"1.75 €"}},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]+tblPārdošanasDati[[#This Row],[PVN]]","v":{"v":36.7395,"d":"36.74 €"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"\",VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"No description found\")","v":"Apaļš šķīvis"},{"v":55.95,"d":"55.95 €"},{"v":0.05,"d":"5.00%"},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]*tblPārdošanasDati[[#This Row],[NODOKĻI ]]","v":{"v":2.7975000000000003,"d":"2.80 €"}},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]+tblPārdošanasDati[[#This Row],[PVN]]","v":{"v":58.7475,"d":"58.75 €"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"\",VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"No description found\")","v":"Kvadrātveida šķīvis"},{"v":2.95,"d":"2.95 €"},{"v":0.05,"d":"5.00%"},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]*tblPārdošanasDati[[#This Row],[NODOKĻI ]]","v":{"v":0.14750000000000002,"d":"0.15 €"}},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]+tblPārdošanasDati[[#This Row],[PVN]]","v":{"v":3.0975,"d":"3.10 €"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"\",VLOOKUP(tblPārdošanasDati[[#This Row],[NV/PRODUKTA NUMURS]],tblKrājumi[],2,0)),\"No description found\")","v":"Spilvens"},{"v":14.98,"d":"14.98 €"},{"v":0.05,"d":"5.00%"},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]*tblPārdošanasDati[[#This Row],[NODOKĻI ]]","v":{"v":0.7490000000000001,"d":"0.75 €"}},{"$f":"tblPārdošanasDati[[#This Row],[PĀRDOŠANAS SUMMA]]+tblPārdošanasDati[[#This Row],[PVN]]","v":{"v":15.729000000000001,"d":"15.73 €"}}]

{"sheet":"Pārdošanas atskaite","index":1,"n_rows":14,"n_cols":6,"rows_kept":14}
[]
[null,"AR KASES APARĀTU IETIRGOTAIS DIENĀ"]
[]
[]
[]
[]
[]
[null,"APRAKSTS","DATUMS","Pārdošanas summa ","PVN","Kopā"]
[null,"Sega","2012-02-01",{"v":74.95,"d":"74.95 €"},{"v":3.7475000000000005,"d":"3.75 €"},{"v":78.6975,"d":"78.70 €"}]
[null,"Galdauts, 1,8 m apkārtmērs","2012-02-01",{"v":34.99,"d":"34.99 €"},{"v":1.7495000000000003,"d":"1.75 €"},{"v":36.7395,"d":"36.74 €"}]
[null,"Apaļš šķīvis","2012-02-01",{"v":55.95,"d":"55.95 €"},{"v":2.7975000000000003,"d":"2.80 €"},{"v":58.7475,"d":"58.75 €"}]
[null,"Kvadrātveida šķīvis","2012-02-01",{"v":2.95,"d":"2.95 €"},{"v":0.14750000000000002,"d":"0.15 €"},{"v":3.0975,"d":"3.10 €"}]
[null,"Spilvens","2012-02-01",{"v":14.98,"d":"14.98 €"},{"v":0.7490000000000001,"d":"0.75 €"},{"v":15.729000000000001,"d":"15.73 €"}]
[null,"Gala summa",null,{"v":183.81999999999996,"d":"183.82 €"},{"v":9.191000000000003,"d":"9.19 €"},{"v":193.01100000000002,"d":"193.01 €"}]

{"sheet":"Krājumi","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"AR KASES APARĀTU IETIRGOTAIS DIENĀ"]
[]
[]
[]
[]
[]
[null,"NV/PRODUKTA NUMURS","APRAKSTS"]
[null,90001,"Sega"]
[null,90002,"Spilvens"]
[null,90003,"Palagi"]
[null,90004,"Kvadrātveida šķīvis"]
[null,90005,"Apaļš šķīvis"]
[null,90006,"Bļoda, liela"]
[null,90007,"Bļoda, maza"]
[null,90008,"Apaļš šķīvis, mazs"]
[null,90009,"Dakšiņa, maza"]
[null,90010,"Dakšiņa, liela"]
[null,90011,"Karote, maza"]
[null,90012,"Karote, liela"]
[null,90013,"Sviesta nazis, mazs"]
[null,90014,"Sviesta nazis, liels"]
[null,90015,"Galdauts, 10x5"]
[null,90016,"Galdauts, 8x5"]
[null,90017,"Galdauts, 8x8"]
[null,90018,"Galdauts, 6x8"]
[null,90019,"Galdauts, 6x4"]
[null,90020,"Galdauts, 4x4"]
[null,90021,"Galdauts, 3 m apkārtmērs"]
[null,90022,"Galdauts, 2,5 m apkārtmērs"]
[null,90023,"Galdauts, 1,8 m apkārtmērs"]