{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Номенклатура","Заказ","Все заказы","Отчет"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":45,"n_cols":1,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["10/3"]
["10/3 х/б Белая"]
["10/3 х/б Серая"]
["10/3 х/б с ПВХ Белая"]
["10/3 х/б с ПВХ Серая"]
["10/3 х/б с ПВХ белая (Точка)"]
["10/3 х/б с ПВХ белая (Волна)"]
["10/3 х/б с ПВХ белая (Протектор)"]
["10/3 х/б с ПВХ Серая (Точка)"]
["10/3 х/б с ПВХ Серая (Волна)"]
["10/3 х/б с ПВХ Серая (Протектор)"]
["10/4"]
["10/4 х/б Белая"]
["10/4 х/б Серая"]
["10/4 х/б с ПВХ Белая"]
["10/4 х/б с ПВХ Серая"]
["10/4 х/б с ПВХ белая (Точка)"]
["10/4 х/б с ПВХ белая (Волна)"]
["10/4 х/б с ПВХ белая (Протектор)"]
["10/4 х/б с ПВХ Серая (Точка)"]
["10/4 х/б с ПВХ Серая (Волна)"]
["10/4 х/б с ПВХ Серая (Протектор)"]
["10/5"]
["10/5 х/б Белая"]
["10/5 х/б Серая"]
["10/5 х/б Черная"]
["10/5 х/б Желтая"]
["10/5 х/б Розовая"]
["10/5 х/б с ПВХ Белая"]
["10/5 х/б с ПВХ Серая"]
["10/5 х/б с ПВХ Черная"]
["10/5 х/б с ПВХ Желтая"]
["10/5 х/б с ПВХ Розовая"]
["10/5 х/б с ПВХ белая (Точка)"]
["10/5 х/б с ПВХ белая (Волна)"]
["10/5 х/б с ПВХ белая (Протектор)"]
["10/5 х/б с ПВХ Серая (Точка)"]
["10/5 х/б с ПВХ Серая (Волна)"]
["10/5 х/б с ПВХ Серая (Протектор)"]
["10/5 х/б с ПВХ Черная (Точка)"]
["10/5 х/б с ПВХ Черная (Волна)"]
["10/5 х/б с ПВХ Черная (Протектор)"]
["10/5 х/б с ПВХ Желтая (Точка)"]
["10/5 х/б с ПВХ Желтая (Волна)"]
["10/5 х/б с ПВХ Желтая (Протектор)"]

{"sheet":"Заказ","index":1,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Заказ клиента"]
[]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общая сумма","№ Счета"]
["Дядя ваня","10/3 х/б Белая",1000,"10/4 х/б Белая",500,"10/5 х/б Белая",100,{"$f":"SUM(C4:C12,E4:E12,G4:G12)","v":1600},152]
[null,"10/3 х/б Серая"]

{"sheet":"Все заказы","index":2,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[34,10,34,11],[29,15,30,15],[26,10,27,10],[0,6,0,8],[10,3,11,3],[10,6,10,8],[28,3,29,3],[28,6,28,8],[29,10,29,11],[10,0,11,2],[13,15,14,15],[13,14,14,14],[55,0,56,2],[55,3,56,3],[55,6,55,8],[37,0,38,2],[37,3,38,3],[37,6,37,8],[46,0,47,2],[46,3,47,3],[46,6,46,8],[19,0,20,2],[19,3,20,3],[19,6,19,8],[28,0,29,2]]}
[null,"Оплаченаые",null,"Понедельник",null,"Число","2004-05-21",null,null,null,"10/3","10/4","10/5",null,"10/3","10/4","10/5"]
[null,null,null,null,null,null,null,null,null,"ВЫД","10/3 х/б Белая","10/4 х/б Белая","10/5 х/б Белая",null,"Белая","Белая","Белая"]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета",null,{"$f":"IF($J4,C4,0)","v":0},null,null,null,{"$f":"K7+K11+K13+K15","v":0},{"$f":"L7+L11+L13+L15","v":0},{"$f":"M13+M23+M25+M27","v":0}]
["Дядя ваня","10/3 х/б с ПВХ Серая",10000,"10/4 х/б Белая",152,"10/5 х/б Белая",500,null,null,false,"10/3 х/б Серая","10/4 х/б Серая","10/5 х/б Серая",null,"Серая","Серая","Серая"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K9+K17+K19+K21","v":0},{"$f":"SUM(L9+L17+L19+L21)","v":0},{"$f":"M15+M29+M31+M33","v":0}]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ Белая","10/4 х/б с ПВХ Белая","10/5 х/б Черная",null,null,null,"Черная"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M17+M35+M37+M39","v":0}]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ Серая","10/4 х/б с ПВХ Серая","10/5 х/б Желтая",null,null,null,"Желтая"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M19+M41+M43+M45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ белая (Точка)","10/4 х/б с ПВХ белая (Точка)","10/5 х/б Розовая",null,null,null,"Розовая"]
[null,null,null,"Вторник",null,"Число","2004-05-21",null,null,null,null,null,null,null,null,null,{"$f":"M21+M47+M49+M51","v":0}]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ белая (Волна)","10/4 х/б с ПВХ белая (Волна)","10/5 х/б с ПВХ Белая"]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета",null,null,null,null,null,null,"Сумма ПВХ"]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ белая (Протектор)","10/4 х/б с ПВХ белая (Протектор)","10/5 х/б с ПВХ Серая",null,null,{"$f":"SUM(O3,O5,P3,P5,Q3,Q5,Q7,Q9,Q11)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ Серая (Точка)","10/4 х/б с ПВХ Серая (Точка)","10/5 х/б с ПВХ Черная"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10/3","10/4","10/5"]
[null,null,null,null,null,null,null,null,null,null,"10/3 х/б с ПВХ Серая (Волна)","10/4 х/б с ПВХ Серая (Волна)","10/5 х/б с ПВХ Желтая",null,"Белая","Белая","Белая"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K3","v":0},{"$f":"L3","v":0},{"$f":"M3","v":0}]
[null,null,null,"Среда",null,"Число","2004-05-21",null,null,null,"10/3 х/б с ПВХ Серая (Протектор)","10/4 х/б с ПВХ Серая (Протектор)","10/5 х/б с ПВХ Розовая",null,"Серая","Серая","Серая"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K5","v":0},{"$f":"L5","v":0},{"$f":"M5","v":0}]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета",null,null,null,"10/5 х/б с ПВХ белая (Точка)",null,null,null,"Черная"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ белая (Волна)",null,null,null,"Желтая"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M9","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Общая Сумма",null,"10/5 х/б с ПВХ белая (Протектор)",null,null,null,"Розовая"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K3,K5,K7,K9,K11,K13,K15,K17,K19,K21,L3,L5,L7,L9,L11,L13,L15,L17,L19,L21,M3,M5,M7,M9,M11,M13,M15,M17,M19,M21,M23,M25,M27,M29,M31,M33,M35,M37,M39,M41,M43,M45,M47,M49,M51)","v":0},null,null,null,null,null,{"$f":"M11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Серая (Точка)"]
[null,null,null,"Четверг",null,"Число","2004-05-21",null,null,null,null,null,null,null,null,"Сумма Х/Б"]
[null,null,null,null,null,null,null,null,null,null,"Выделить все галочки",null,"10/5 х/б с ПВХ Серая (Волна)",null,null,{"$f":"SUM(O19,O21,P19,P21,Q19,Q21,Q23,Q25,Q27)","v":0}]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Серая (Протектор)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Черная (Точка)"]
[null,null,null,null,null,null,null,null,null,null,"снять все галочки"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Черная (Волна)"]
[]
[null,null,null,"Пятница",null,"Число","2004-05-21",null,null,null,null,null,"10/5 х/б с ПВХ Черная (Протектор)"]
[]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета",null,null,null,"10/5 х/б с ПВХ Желтая (Точка)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Желтая (Волна)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Желтая (Протектор)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Розовая (Точка)"]
[null,null,null,"Суббота",null,"Число","2004-05-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ Розовая (Волна)"]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10/5 х/б с ПВХ розовая (Протектор)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Сумма"]
[null,null,null,null,null,null,null,null,null,null,"10/3","10/4","10/5"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K3,K5,K7,K9,K11,K13,K15,K17,K19,K21)","v":0},{"$f":"SUM(L3,L5,L7,L9,L11,L13,L15,L17,L19,L21)","v":0},{"$f":"SUM(M3,M5,M7,M9,M11,M13,M15,M17,M19,M21,M23,M25,M27,M29,M31,M33,M35,M37,M39,M41,M43,M45,M47,M49,M51)","v":0}]
[null,null,null,"Воскр",null,"Число","2004-05-21"]
[]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета"]
[]
[]
[]
[]
[]
[]
[]
[null,"Не оплаченые "]
[]
["Клиент","10/3","кол","10/4","кол","10/5","кол","Общ","№ Счета"]
[null,{"$f":"VLOOKUP($A$70,Клиент,MATCH(B68,Заказ!$A$3:$G$3,0),FALSE)","v":"10/3 х/б Белая"},{"$f":"VLOOKUP($A$70,Клиент,MATCH(C68,Заказ!$A$3:$G$3,0),FALSE)","v":1000},{"$f":"VLOOKUP($A$70,Клиент,MATCH(D68,Заказ!$A$3:$G$3,0),FALSE)","v":"10/4 х/б Белая"},{"$f":"VLOOKUP($A$70,Клиент,MATCH(E68,Заказ!$A$3:$G$3,0),FALSE)","v":1000},{"$f":"VLOOKUP($A$70,Клиент,MATCH(F68,Заказ!$A$3:$G$3,0),FALSE)","v":"10/5 х/б Белая"},{"$f":"VLOOKUP($A$70,Клиент,MATCH(G68,Заказ!$A$3:$G$3,0),FALSE)","v":1000}]
["Дядя ваня"]

{"sheet":"Отчет","index":3,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,2,11,2],[6,2,8,2]]}
["Итог"]
["10/3","Общий итог","Цвет Итог ПВХ"]
["10/3 х/б Белая"]
["10/3 х/б Серая"]
["10/3 х/б с ПВХ Белая"]
["10/3 х/б с ПВХ Серая"]
["10/3 х/б с ПВХ белая (Точка)"]
["10/3 х/б с ПВХ белая (Волна)",null,null,"Белые"]
["10/3 х/б с ПВХ белая (Протектор)"]
["10/3 х/б с ПВХ Серая (Точка)"]
["10/3 х/б с ПВХ Серая (Волна)",null,null,"Серые"]
["10/3 х/б с ПВХ Серая (Протектор)"]
["10/4"]
["10/4 х/б Белая"]
["10/4 х/б Серая"]
["10/4 х/б с ПВХ Белая"]
["10/4 х/б с ПВХ Серая"]
["10/4 х/б с ПВХ белая (Точка)"]
["10/4 х/б с ПВХ белая (Волна)"]
["10/4 х/б с ПВХ белая (Протектор)"]
["10/4 х/б с ПВХ Серая (Точка)"]
["10/4 х/б с ПВХ Серая (Волна)"]
["10/4 х/б с ПВХ Серая (Протектор)"]
["10/5"]
["10/5 х/б Белая"]
["10/5 х/б Серая"]
["10/5 х/б Черная"]
["10/5 х/б Желтая"]
["10/5 х/б Розовая"]
["10/5 х/б с ПВХ Белая"]
["10/5 х/б с ПВХ Серая"]
["10/5 х/б с ПВХ Черная"]
["10/5 х/б с ПВХ Желтая"]
["10/5 х/б с ПВХ Розовая"]
["10/5 х/б с ПВХ белая (Точка)"]
["10/5 х/б с ПВХ белая (Волна)"]
["10/5 х/б с ПВХ белая (Протектор)"]
["10/5 х/б с ПВХ Серая (Точка)"]
["10/5 х/б с ПВХ Серая (Волна)"]
["10/5 х/б с ПВХ Серая (Протектор)"]
["10/5 х/б с ПВХ Черная (Точка)"]
["10/5 х/б с ПВХ Черная (Волна)"]
["10/5 х/б с ПВХ Черная (Протектор)"]
["10/5 х/б с ПВХ Желтая (Точка)"]
["10/5 х/б с ПВХ Желтая (Волна)"]
["10/5 х/б с ПВХ Желтая (Протектор)"]