{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pardavimo duomenys","Pardavimo ataskaita","Atsargos"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Pardavimo duomenys","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"KASOS DIENOS APYVARTA"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"DATA ","LAIKAS","OPERACIJOS NUMERIS","SKU/PRODUKTO NUMERIS","APRAŠAS","PARDAVIMO SUMA","MOKESČIO %","PARDAVIMO MOKESTIS","IŠ VISO"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"\",VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"Aprašo nerasta\")","v":"Paklodė"},{"v":74.95,"d":"74.95 Lt"},{"v":0.05,"d":"5.00%"},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]*tblPardavimoDuomenys[[#This Row],[MOKESČIO %]]","v":{"v":3.7475000000000005,"d":"3.75 Lt"}},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]+tblPardavimoDuomenys[[#This Row],[PARDAVIMO MOKESTIS]]","v":{"v":78.6975,"d":"78.70 Lt"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"\",VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"Aprašo nerasta\")","v":"Apvali staltiesė, 6 col."},{"v":34.99,"d":"34.99 Lt"},{"v":0.05,"d":"5.00%"},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]*tblPardavimoDuomenys[[#This Row],[MOKESČIO %]]","v":{"v":1.7495000000000003,"d":"1.75 Lt"}},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]+tblPardavimoDuomenys[[#This Row],[PARDAVIMO MOKESTIS]]","v":{"v":36.7395,"d":"36.74 Lt"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"\",VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"Aprašo nerasta\")","v":"Apvali lėkštė"},{"v":55.95,"d":"55.95 Lt"},{"v":0.05,"d":"5.00%"},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]*tblPardavimoDuomenys[[#This Row],[MOKESČIO %]]","v":{"v":2.7975000000000003,"d":"2.80 Lt"}},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]+tblPardavimoDuomenys[[#This Row],[PARDAVIMO MOKESTIS]]","v":{"v":58.7475,"d":"58.75 Lt"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"\",VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"Aprašo nerasta\")","v":"Keturkampė lėkštė"},{"v":2.95,"d":"2.95 Lt"},{"v":0.05,"d":"5.00%"},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]*tblPardavimoDuomenys[[#This Row],[MOKESČIO %]]","v":{"v":0.14750000000000002,"d":"0.15 Lt"}},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]+tblPardavimoDuomenys[[#This Row],[PARDAVIMO MOKESTIS]]","v":{"v":3.0975,"d":"3.10 Lt"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"\",VLOOKUP(tblPardavimoDuomenys[[#This Row],[SKU/PRODUKTO NUMERIS]],tblAtsargos[],2,0)),\"Aprašo nerasta\")","v":"Pagalvė"},{"v":14.98,"d":"14.98 Lt"},{"v":0.05,"d":"5.00%"},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]*tblPardavimoDuomenys[[#This Row],[MOKESČIO %]]","v":{"v":0.7490000000000001,"d":"0.75 Lt"}},{"$f":"tblPardavimoDuomenys[[#This Row],[PARDAVIMO SUMA]]+tblPardavimoDuomenys[[#This Row],[PARDAVIMO MOKESTIS]]","v":{"v":15.729000000000001,"d":"15.73 Lt"}}]

{"sheet":"Pardavimo ataskaita","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"KASOS DIENOS APYVARTA"]
[]
[]
[]
[]
[]
[null,"SKU/PRODUKTO NUMERIS ","APRAŠAS","DATA","Pardavimo suma ","Pardavimo mokestis ","Iš viso "]
[null,90001,"Paklodė","2012-02-01",{"v":74.95,"d":"74.95 Lt"},{"v":3.7475000000000005,"d":"3.75 Lt"},{"v":78.6975,"d":"78.70 Lt"}]
[null,90002,"Pagalvė","2012-02-01",{"v":14.98,"d":"14.98 Lt"},{"v":0.7490000000000001,"d":"0.75 Lt"},{"v":15.729000000000001,"d":"15.73 Lt"}]
[null,90004,"Keturkampė lėkštė","2012-02-01",{"v":2.95,"d":"2.95 Lt"},{"v":0.14750000000000002,"d":"0.15 Lt"},{"v":3.0975,"d":"3.10 Lt"}]
[null,90005,"Apvali lėkštė","2012-02-01",{"v":55.95,"d":"55.95 Lt"},{"v":2.7975000000000003,"d":"2.80 Lt"},{"v":58.7475,"d":"58.75 Lt"}]
[null,90023,"Apvali staltiesė, 6 col.","2012-02-01",{"v":34.99,"d":"34.99 Lt"},{"v":1.7495000000000003,"d":"1.75 Lt"},{"v":36.7395,"d":"36.74 Lt"}]
[null,"Bendroji suma",null,null,{"v":183.82000000000002,"d":"183.82 Lt"},{"v":9.191000000000003,"d":"9.19 Lt"},{"v":193.011,"d":"193.01 Lt"}]

{"sheet":"Atsargos","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"KASOS DIENOS APYVARTA"]
[]
[]
[]
[]
[]
[null,"SKU/PRODUKTO NUMERIS ","APRAŠAS"]
[null,90001,"Paklodė"]
[null,90002,"Pagalvė"]
[null,90003,"Paklodės"]
[null,90004,"Keturkampė lėkštė"]
[null,90005,"Apvali lėkštė"]
[null,90006,"Didelis dubuo"]
[null,90007,"Mažas dubuo"]
[null,90008,"Maža apvali lėkštė"]
[null,90009,"Maža šakutė"]
[null,90010,"Didelė šakutė"]
[null,90011,"Mažas šaukštas"]
[null,90012,"Didelis šaukštas"]
[null,90013,"Mažas peilis sviestui"]
[null,90014,"Didelis peilis sviestui"]
[null,90015,"Staltiesė, 10 x 5"]
[null,90016,"Staltiesė, 8 x 5"]
[null,90017,"Staltiesė, 8 x 8"]
[null,90018,"Staltiesė, 6 x 6"]
[null,90019,"Staltiesė, 6 x 4"]
[null,90020,"Staltiesė, 4 x 4"]
[null,90021,"Apvali staltiesė, 10 col."]
[null,90022,"Apvali staltiesė, 8 col."]
[null,90023,"Apvali staltiesė, 6 col."]