{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ОТЧЕТ БЛАНК (2)","ОТЧЕТ БЛАНК","ОСТАТКИ","Лист4","Лист6","Лист7"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"ОТЧЕТ БЛАНК (2)","index":0,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":false,"merged":[[23,6,23,7],[26,0,26,8],[28,0,28,3],[28,4,28,8],[63,1,63,2],[6,1,7,1],[8,6,8,7],[15,6,15,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[0,1,0,2],[2,0,2,4],[3,0,3,3],[3,6,3,7],[4,0,4,1],[4,2,4,4]]}
["СМЕННЫЙ ОТЧЕТ ЗА ","2015-03-01",null,"2015 Г.",null,null,"- ЯЧЕЙКА ДЛЯ ВВОДА ДАННЫХ БАРМЕНОМ"]
[]
["ДЕНЕЖНЫЙ ОТЧЕТ"]
["ОСТАТОК НА НАЧАЛО СМЕНЫ, РУБ",null,null,null,13605,null,"ДАННЫЕ ПО ОТЧЕТУ"]
["ПРИХОД",null,"РАСХОД",null,null,null,"КАССА",{"$f":"VALUE(D24)","v":21863.5}]
["ОТ КОГО","СУММА","КОМУ","СУММА","ПОДПИСЬ",null,"ТОВАР",{"$f":"VALUE(D53)","v":18554.5}]
["РЕАЛИЗАЦИЯ ПОКУПАТЕЛЯМ ",{"$f":"ABS(E4-D23-D24+B23)","v":8258.5},null,0,null,null,"ИТОГО"]
[" (БЕЗ ТЕРМИНАЛА)",null,null,0]
[null,0,null,0,null,null,"ДАННЫЕ РЕВИЗИИ"]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0,null,null,"ИТОГ РЕВИЗИИ"]
[null,0,null,0,null,null,"ИЗЛ(+)/НЕДОСТАЧ(-)",{"$f":"H7-H5-H6","v":-40418}]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0,null,null,"ОСТАТОК ТМЦ НА НАЧАЛО СМЕНЫ, РУБ"]
[null,0,null,0,null,null,"ПРИХОД, РУБ"]
["ИТОГО",{"$f":" SUM(B8:B22)","v":0},"ИТОГО",{"$f":"SUM(D7:D22)","v":0},null,null,"РАСХОД, РУБ"]
["ОСТАТОК НА КОНЕЦ СМЕНЫ, РУБ",null,null,21863.5,null,null,"ОСТАТОК ТМЦ НА КОНЕЦ СМЕНЫ, РУБ"]
[]
[]
["ТОВАРНЫЙ ОТЧЕТ"]
["ОСТАТОК НА НАЧАЛО СМЕНЫ, РУБ",null,null,26813]
["ПРИХОД",null,null,null,"РАСХОД (СПИСАНИЕ)"]
["НАИМЕНОВАНИЕ","КОЛ-ВО","ЦЕНА","СУММА","НАИМЕНОВАНИЕ","КОЛ-ВО","ЦЕНА","СУММА","ПРИМЕЧАНИЕ"]
[null,0,0,{"$f":"PRODUCT(B31,C31)","v":0},null,0,0,{"$f":"PRODUCT(F31,G31)","v":0}]
[null,0,0,0,null,0,0,{"$f":"PRODUCT(F32,G32)","v":0}]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
["ИТОГО",null,"Х",{"$f":"SUM(D31:D49)","v":0},"ИТОГО",null,"Х",{"$f":"SUM(H31:H49)","v":0},"Х"]
["РЕАЛИЗОВАНО ПОКУПАТЕЛЯМ, РУБ",null,null,{"$f":"VALUE(B7)+D52","v":8258.5}]
["РЕАЛИЗОВАНО ПОКУПАТЕЛЯМ ТЕРМИНАЛ, РУБ"]
["ОСТАТОК НА КОНЕЦ СМЕНЫ, РУБ",null,null,{"$f":" D28-H50-D51+D50","v":18554.5}]
[]
[]
[]
[]
["ОТВЕТСТВЕННОЕ ЛИЦО"]
[]
[]
[]
[]
[]
["РЕЕСТР ВХОДЯЩИХ ДОКУМЕНТОВ ЗА ______________",{"$f":"VALUE(B1)","v":"2015-03-01"}]
["№, ДАТА ","СУММА","ПОСТАВЩИК"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ИТОГО"]

{"sheet":"ОТЧЕТ БЛАНК","index":1,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":false,"merged":[[63,1,63,2],[28,4,28,8],[3,6,3,7],[15,6,15,7],[26,0,26,8],[8,6,8,7],[0,1,0,2],[28,0,28,3],[6,1,7,1],[22,6,22,7],[23,6,23,7],[2,0,2,4],[3,0,3,3],[20,6,20,7],[4,0,4,1],[4,2,4,4],[21,6,21,7]]}
["СМЕННЫЙ ОТЧЕТ ЗА ","2015-03-01",null,"2015 Г.",null,null,"- ЯЧЕЙКА ДЛЯ ВВОДА ДАННЫХ БАРМЕНОМ"]
[]
["ДЕНЕЖНЫЙ ОТЧЕТ"]
["ОСТАТОК НА НАЧАЛО СМЕНЫ, РУБ",null,null,null,13605,null,"ДАННЫЕ ПО ОТЧЕТУ"]
["ПРИХОД",null,"РАСХОД",null,null,null,"КАССА",{"$f":"VALUE(D24)","v":21863.5}]
["ОТ КОГО","СУММА","КОМУ","СУММА","ПОДПИСЬ",null,"ТОВАР",{"$f":"VALUE(D53)","v":18554.5}]
["РЕАЛИЗАЦИЯ ПОКУПАТЕЛЯМ ",{"$f":"ABS(E4-D23-D24+B23)","v":8258.5},null,0,null,null,"ИТОГО"]
[" (БЕЗ ТЕРМИНАЛА)",null,null,0]
[null,0,null,0,null,null,"ДАННЫЕ РЕВИЗИИ"]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0,null,null,"ИТОГ РЕВИЗИИ"]
[null,0,null,0,null,null,"ИЗЛ(+)/НЕДОСТАЧ(-)",{"$f":"H7-H5-H6","v":-40418}]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0,null,null,"ОСТАТОК ТМЦ НА НАЧАЛО СМЕНЫ, РУБ"]
[null,0,null,0,null,null,"ПРИХОД, РУБ"]
["ИТОГО",{"$f":" SUM(B8:B22)","v":0},"ИТОГО",{"$f":"SUM(D7:D22)","v":0},null,null,"РАСХОД, РУБ"]
["ОСТАТОК НА КОНЕЦ СМЕНЫ, РУБ",null,null,21863.5,null,null,"ОСТАТОК ТМЦ НА КОНЕЦ СМЕНЫ, РУБ"]
[]
[]
["ТОВАРНЫЙ ОТЧЕТ"]
["ОСТАТОК НА НАЧАЛО СМЕНЫ, РУБ",null,null,26813]
["ПРИХОД",null,null,null,"РАСХОД (СПИСАНИЕ)"]
["НАИМЕНОВАНИЕ","КОЛ-ВО","ЦЕНА","СУММА","НАИМЕНОВАНИЕ","КОЛ-ВО","ЦЕНА","СУММА","ПРИМЕЧАНИЕ"]
[null,0,0,{"$f":"PRODUCT(B31,C31)","v":0},null,0,0,{"$f":"PRODUCT(F31,G31)","v":0}]
[null,0,0,0,null,0,0,{"$f":"PRODUCT(F32,G32)","v":0}]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
[null,0,0,0,null,0,0,0]
["ИТОГО",null,"Х",{"$f":"SUM(D31:D49)","v":0},"ИТОГО",null,"Х",{"$f":"SUM(H31:H49)","v":0},"Х"]
["РЕАЛИЗОВАНО ПОКУПАТЕЛЯМ, РУБ",null,null,{"$f":"VALUE(B7)+D52","v":8258.5}]
["РЕАЛИЗОВАНО ПОКУПАТЕЛЯМ ТЕРМИНАЛ, РУБ"]
["ОСТАТОК НА КОНЕЦ СМЕНЫ, РУБ",null,null,{"$f":" D28-H50-D51+D50","v":18554.5}]
[]
[]
[]
[]
["ОТВЕТСТВЕННОЕ ЛИЦО"]
[]
[]
[]
[]
[]
["РЕЕСТР ВХОДЯЩИХ ДОКУМЕНТОВ ЗА ______________",{"$f":"VALUE(B1)","v":"2015-03-01"}]
["№, ДАТА ","СУММА","ПОСТАВЩИК"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ИТОГО"]

{"sheet":"ОСТАТКИ","index":2,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["ОСТАТКИ ТМЦ НА",null,"2015Г"]
[]
["НАИМЕНОВАНИЕ","КОЛ-ВО","ЦЕНА","СУММА","ПРИМЕЧАНИЕ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ИТОГО",null,"Х",null,"Х"]
[]
["ТОВАР"]
["НАЛИЧНЫЕ В КАССЕ"]
["ИТОГО ОСТАТОК ТМЦ"]

{"sheet":"Лист4","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["SheЮЮ..Юets(Format(Date, \"yyyy.mm.dd\")).Select"]

{"sheet":"Лист6","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист7","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}