{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Údaje o prodeji","Výkaz o prodeji","Inventář"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Údaje o prodeji","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"DENNÍ PRODEJ Z REGISTRAČNÍ POKLADNY"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"DATUM","ČAS","ČÍSLO TRANSAKCE","SKU/ČÍSLO VÝROBKU","POPIS","ČÁSTKA PRODEJE","% DPH","ČÁSTKA DPH","CELKEM"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"\",VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"Popis není dostupný\")","v":"Přikrývka"},{"v":74.95,"d":"74.95 Kč"},{"v":0.05,"d":"5.00%"},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]*tblÚdajeOProdeji[[#This Row],[% DPH]]","v":{"v":3.7475000000000005,"d":"3.75 Kč"}},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]+tblÚdajeOProdeji[[#This Row],[ČÁSTKA DPH]]","v":{"v":78.6975,"d":"78.70 Kč"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"\",VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"Popis není dostupný\")","v":"Ubrus, 180 cm, kulatý"},{"v":34.99,"d":"34.99 Kč"},{"v":0.05,"d":"5.00%"},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]*tblÚdajeOProdeji[[#This Row],[% DPH]]","v":{"v":1.7495000000000003,"d":"1.75 Kč"}},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]+tblÚdajeOProdeji[[#This Row],[ČÁSTKA DPH]]","v":{"v":36.7395,"d":"36.74 Kč"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"\",VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"Popis není dostupný\")","v":"Kulatý talíř"},{"v":55.95,"d":"55.95 Kč"},{"v":0.05,"d":"5.00%"},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]*tblÚdajeOProdeji[[#This Row],[% DPH]]","v":{"v":2.7975000000000003,"d":"2.80 Kč"}},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]+tblÚdajeOProdeji[[#This Row],[ČÁSTKA DPH]]","v":{"v":58.7475,"d":"58.75 Kč"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"\",VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"Popis není dostupný\")","v":"Čtvercový talíř"},{"v":2.95,"d":"2.95 Kč"},{"v":0.05,"d":"5.00%"},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]*tblÚdajeOProdeji[[#This Row],[% DPH]]","v":{"v":0.14750000000000002,"d":"0.15 Kč"}},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]+tblÚdajeOProdeji[[#This Row],[ČÁSTKA DPH]]","v":{"v":3.0975,"d":"3.10 Kč"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"\",VLOOKUP(tblÚdajeOProdeji[[#This Row],[SKU/ČÍSLO VÝROBKU]],tblInventář[],2,0)),\"Popis není dostupný\")","v":"Polštář"},{"v":14.98,"d":"14.98 Kč"},{"v":0.05,"d":"5.00%"},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]*tblÚdajeOProdeji[[#This Row],[% DPH]]","v":{"v":0.7490000000000001,"d":"0.75 Kč"}},{"$f":"tblÚdajeOProdeji[[#This Row],[ČÁSTKA PRODEJE]]+tblÚdajeOProdeji[[#This Row],[ČÁSTKA DPH]]","v":{"v":15.729000000000001,"d":"15.73 Kč"}}]

{"sheet":"Výkaz o prodeji","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"DENNÍ PRODEJ Z REGISTRAČNÍ POKLADNY"]
[]
[]
[]
[]
[]
[null,"SKU/ČÍSLO VÝROBKU","POPIS","DATUM","ČÁSTKA PRODEJE ","ČÁSTKA DPH ","CELKEM "]
[null,90001,"Přikrývka","2012-02-01",{"v":74.95,"d":"74.95 Kč"},{"v":3.7475000000000005,"d":"3.75 Kč"},{"v":78.6975,"d":"78.70 Kč"}]
[null,90002,"Polštář","2012-02-01",{"v":14.98,"d":"14.98 Kč"},{"v":0.7490000000000001,"d":"0.75 Kč"},{"v":15.729000000000001,"d":"15.73 Kč"}]
[null,90004,"Čtvercový talíř","2012-02-01",{"v":2.95,"d":"2.95 Kč"},{"v":0.14750000000000002,"d":"0.15 Kč"},{"v":3.0975,"d":"3.10 Kč"}]
[null,90005,"Kulatý talíř","2012-02-01",{"v":55.95,"d":"55.95 Kč"},{"v":2.7975000000000003,"d":"2.80 Kč"},{"v":58.7475,"d":"58.75 Kč"}]
[null,90023,"Ubrus, 180 cm, kulatý","2012-02-01",{"v":34.99,"d":"34.99 Kč"},{"v":1.7495000000000003,"d":"1.75 Kč"},{"v":36.7395,"d":"36.74 Kč"}]
[null,"Celkový součet",null,null,{"v":183.82000000000002,"d":"183.82 Kč"},{"v":9.191000000000003,"d":"9.19 Kč"},{"v":193.011,"d":"193.01 Kč"}]

{"sheet":"Inventář","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"DENNÍ PRODEJ Z REGISTRAČNÍ POKLADNY"]
[]
[]
[]
[]
[]
[null,"SKU/ČÍSLO VÝROBKU","POPIS"]
[null,90001,"Přikrývka"]
[null,90002,"Polštář"]
[null,90003,"Povlečení"]
[null,90004,"Čtvercový talíř"]
[null,90005,"Kulatý talíř"]
[null,90006,"Mísa, velká"]
[null,90007,"Miska, malá"]
[null,90008,"Kulatý talíř, malý"]
[null,90009,"Vidlička, malá"]
[null,90010,"Vidlička, velká"]
[null,90011,"Lžíce, malá"]
[null,90012,"Lžíce, velká"]
[null,90013,"Nůž na máslo, malý"]
[null,90014,"Nůž na máslo, velký"]
[null,90015,"Ubrus, 300 x 150 cm"]
[null,90016,"Ubrus, 240 x 150 cm"]
[null,90017,"Ubrus, 240 x 240 cm"]
[null,90018,"Ubrus, 180×180 cm"]
[null,90019,"Ubrus, 180×120 cm"]
[null,90020,"Ubrus, 120×120 cm"]
[null,90021,"Ubrus, 300 cm, kulatý"]
[null,90022,"Ubrus, 240 cm, kulatý"]
[null,90023,"Ubrus, 180 cm, kulatý"]