{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Чек"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"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":"Чек","index":0,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[25,1,27,5],[23,1,24,5],[4,4,4,6],[3,1,3,6],[5,4,5,6],[4,2,4,3],[21,1,22,5]]}
[null,{"$f":"IF(C1=\"\",\"\",INDEX(#REF!,MATCH(C1,#REF!,0),2))","v":{"$error":"#REF!"}},"Жидкость охлаждающая ТОСОЛ -40С 10кг",1,{"$f":"IF(C1=\"\",\"\",VALUE(INDEX(#REF!,MATCH(C1,#REF!,0),4)))","v":{"$error":"#REF!"}}]
[null,666,"Тест",5,1000,{"$f":"IF(E8=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,698]
[null,{"$f":"J4&TEXT(K4,\"00000\")&\" \"&L4&\" \"&TEXT(M4,\"ДД.ММ.ГГГГ\")","v":"Товарный чек №00698 от 19.04.2017"},null,null,null,null,null,null,null,"Товарный чек №",698,"от",{"$f":"TODAY()","v":"2017-04-19"}]
[null,"Отпустил:",null,null,null,null,null,null,null,"Александр"]
[null,null,null,null,"(номер дисконтной карты)"]
[null,"Код детали","Наименование детали","Кол-во","Цена","Скидка","Сумма со скидкой"]
[null,null,null,null,null,{"$f":"IF(E8=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},{"$f":"IF(C8=\"\",\"\",(E8-(E8/100*F8*100))*D8)","v":""}]
[null,null,null,null,null,{"$f":"IF(E9=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},{"$f":"IF(C9=\"\",\"\",(E9-(E9/100*F9*100))*D9)","v":""}]
[null,null,null,null,null,{"$f":"IF(E10=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},{"$f":"IF(C10=\"\",\"\",(E10-(E10/100*F10*100))*D10)","v":""}]
[null,null,null,null,null,{"$f":"IF(E11=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},{"$f":"IF(C11=\"\",\"\",(E11-(E11/100*F11*100))*D11)","v":""}]
[null,null,null,null,null,{"$f":"IF(E12=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},{"$f":"IF(C12=\"\",\"\",(E12-(E12/100*F12*100))*D12)","v":""}]
[null,null,null,null,null,{"$f":"IF(E13=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,{"$f":"IF(E14=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,{"$f":"IF(E16=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,{"$f":"IF(E17=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,{"$f":"IF(E18=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($E$5,#REF!,0),2),\"\"))","v":""},""]
[null,null,null,null,null,null,{"$f":"SUM(G8:G18)","v":0}]