{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["СПИСОК КЛИЕНТОВ 1-100","2","1","шаблон БЛАНК ЗАКАЗА"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"СПИСОК КЛИЕНТОВ 1-100","index":0,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["№","Дата","Клиент","Телефон","КОМЕННТАРИЙ",null,"Сумма","предоплата","остаток"]
[1,"2018-01-04T02:40:03","Фролов В.Ф.",79188860060,"кружка",{"$f":"'1'!G2","v":"сувенир"},{"$f":"'1'!I35","v":400},{"$f":"'1'!I36","v":150},{"$f":"'1'!I37","v":250},{"$f":"'1'!B36","v":"НЕ ОПЛАЧЕНО"}]
[2,"2018-01-05T03:21:42","Лыкова Л.В.",79886762222,"рест.Фото",{"$f":"'2'!G2","v":"полиграфия"},{"$f":"'2'!I35","v":445},{"$f":"'2'!I36","v":100},{"$f":"'2'!I37","v":345},{"$f":"'2'!B36","v":"НЕ ОПЛАЧЕНО"}]

{"sheet":"2","index":1,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[48,1,48,2],[49,1,49,2],[49,7,50,10],[50,1,50,2],[51,7,51,10],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[45,2,45,6],[46,2,46,6],[34,1,34,2],[34,4,34,7],[34,8,34,9],[35,1,36,2],[35,4,35,7],[35,8,35,9],[36,4,36,7],[36,8,36,9],[31,1,31,7],[31,8,31,9],[32,1,32,7],[32,8,32,9],[33,1,33,7],[33,8,33,9],[28,1,28,7],[28,8,28,9],[29,1,29,7],[29,8,29,9],[30,1,30,7],[30,8,30,9],[25,1,25,7],[25,8,25,9],[26,1,26,7],[26,8,26,9],[27,1,27,7],[27,8,27,9],[22,1,22,7],[22,8,22,9],[23,1,23,7],[23,8,23,9],[24,1,24,7],[24,8,24,9],[19,1,19,7],[19,8,19,9],[20,1,20,7],[20,8,20,9],[21,1,21,7],[21,8,21,9],[16,1,16,7],[16,8,16,9],[17,1,17,7],[17,8,17,9],[18,1,18,7],[18,8,18,9],[13,1,13,7],[13,8,13,9],[14,1,14,7],[14,8,14,9],[15,1,15,7],[15,8,15,9],[1,6,1,8],[7,1,7,2],[7,3,7,9],[8,1,8,2],[8,3,8,9],[9,1,9,2],[9,3,9,9]]}
[null,"дата",null,null,null,null,"реклама","полиграфия","сувенир"]
[null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!B3)","v":"2018-01-05T03:21:42"},null,null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!A3)","v":2},null,"полиграфия"]
[]
[]
[]
[]
[]
[null,"Ф.И.О. заказчика:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!C2)","v":"Фролов В.Ф."}]
[null,"Телефон:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!D2)","v":79188860060}]
[null,"E-MaiL:"]
[]
[]
[]
[null,{"$f":"'СПИСОК КЛИЕНТОВ 1-100'!E3","v":"рест.Фото"},null,null,null,null,null,null,"итоги"]
[null,"востановление старого фото сложное",null,null,null,null,null,null,400]
[null,"скан.",null,null,null,null,null,null,30]
[null,"печать 10х15мат.",null,null,null,null,null,null,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"общая сумма заказа",null,null,null,{"$f":"SUBTOTAL(109,I15:J34)","v":445}]
[null,"НЕ ОПЛАЧЕНО",null,null,"предоплата",null,null,null,100]
[null,null,null,null,"остаток",null,null,null,{"$f":"I35-I36","v":345}]
[null,null,null,null,"ОПЛАЧЕНО","НЕ ОПЛАЧЕНО","ОПЛАЧЕНО забрали","ОТКАЗАЛИСЬ"]
[null,"СРОК ИЗГОТОВЛЕНИЯ МАКЕТА",null,null,"Подпись заказчика об "]
[null,".  .   2018г.",null,null,"утверждении макета:"]
[null,"СРОК ИЗГОТОВЛЕНИЯ ЗАКАЗА",null,null,"Подпись заказчика о "]
[null,".  .  2018г.",null,null,"выдачи заказа:"]
[]
["     "]
[]
[null,null,{"$f":"$D8","v":"Фролов В.Ф."}]
[null,null,{"$f":"$B14","v":"рест.Фото"}]
[]
[null,"        общая сумма",null,{"$f":"$I35","v":445}]
[null,"        предоплата",null,{"$f":"$I36","v":100},null,null,null,"Виктор"]
[null,"        остаток",null,{"$f":"$I37","v":345}]
[null,null,null,null,null,null,null,"т.8-962-447-40-42"]

{"sheet":"1","index":2,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,6,1,8],[7,1,7,2],[7,3,7,9],[8,1,8,2],[8,3,8,9],[9,1,9,2],[9,3,9,9],[13,1,13,7],[13,8,13,9],[14,1,14,7],[14,8,14,9],[15,1,15,7],[15,8,15,9],[16,1,16,7],[16,8,16,9],[17,1,17,7],[17,8,17,9],[18,1,18,7],[18,8,18,9],[19,1,19,7],[19,8,19,9],[20,1,20,7],[20,8,20,9],[21,1,21,7],[21,8,21,9],[22,1,22,7],[22,8,22,9],[23,1,23,7],[23,8,23,9],[24,1,24,7],[24,8,24,9],[25,1,25,7],[25,8,25,9],[26,1,26,7],[26,8,26,9],[27,1,27,7],[27,8,27,9],[28,1,28,7],[28,8,28,9],[29,1,29,7],[29,8,29,9],[30,1,30,7],[30,8,30,9],[31,1,31,7],[31,8,31,9],[32,1,32,7],[32,8,32,9],[33,1,33,7],[33,8,33,9],[46,2,46,6],[34,1,34,2],[34,4,34,7],[34,8,34,9],[35,1,36,2],[35,4,35,7],[35,8,35,9],[36,4,36,7],[36,8,36,9],[48,1,48,2],[49,1,49,2],[49,7,50,10],[50,1,50,2],[51,7,51,10],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[45,2,45,6]]}
[null,"дата",null,null,null,null,"реклама","полиграфия","сувенир"]
[null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!B2)","v":"2018-01-04T02:40:03"},null,null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!A2)","v":1},null,"сувенир"]
[]
[]
[]
[]
[]
[null,"Ф.И.О. заказчика:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!C2)","v":"Фролов В.Ф."}]
[null,"Телефон:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!D2)","v":79188860060}]
[null,"E-MaiL:"]
[]
[]
[]
[null,{"$f":"'СПИСОК КЛИЕНТОВ 1-100'!E2","v":"кружка"},null,null,null,null,null,null,"итоги"]
[null,"кружка белая (китай)1шт",null,null,null,null,null,null,100]
[null,"дизайн",null,null,null,null,null,null,250]
[null,"коробка",null,null,null,null,null,null,50]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"общая сумма заказа",null,null,null,{"$f":"SUBTOTAL(109,I15:J34)","v":400}]
[null,"НЕ ОПЛАЧЕНО",null,null,"предоплата",null,null,null,150]
[null,null,null,null,"остаток",null,null,null,{"$f":"I35-I36","v":250}]
[null,null,null,null,"ОПЛАЧЕНО","НЕ ОПЛАЧЕНО","ОПЛАЧЕНО забрали","ОТКАЗАЛИСЬ"]
[null,"СРОК ИЗГОТОВЛЕНИЯ МАКЕТА",null,null,"Подпись заказчика об "]
[null,".  .   2018г.",null,null,"утверждении макета:"]
[null,"СРОК ИЗГОТОВЛЕНИЯ ЗАКАЗА",null,null,"Подпись заказчика о "]
[null,".  .  2018г.",null,null,"выдачи заказа:"]
[]
["     "]
[]
[null,null,{"$f":"$D8","v":"Фролов В.Ф."}]
[null,null,{"$f":"B14","v":"кружка"}]
[]
[null,"        общая сумма",null,{"$f":"I35","v":400}]
[null,"        предоплата",null,{"$f":"I36","v":150},null,null,null,"Виктор"]
[null,"        остаток",null,{"$f":"I37","v":250}]
[null,null,null,null,null,null,null,"т.8-962-447-40-42"]

{"sheet":"шаблон БЛАНК ЗАКАЗА","index":3,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[13,1,13,7],[16,8,16,9],[45,2,45,6],[46,2,46,6],[48,1,48,2],[1,6,1,8],[7,1,7,2],[7,3,7,9],[8,1,8,2],[8,3,8,9],[13,8,13,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[28,8,28,9],[14,1,14,7],[15,1,15,7],[16,1,16,7],[14,8,14,9],[15,8,15,9],[33,8,33,9],[34,8,34,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[30,8,30,9],[32,8,32,9],[17,1,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[22,1,22,7],[31,8,31,9],[17,8,17,9],[24,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[28,1,28,7],[29,8,29,9],[38,1,38,2],[29,1,29,7],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,7],[34,1,34,2],[9,1,9,2],[9,3,9,9],[36,8,36,9],[34,4,34,7],[35,4,35,7],[36,4,36,7],[35,1,36,2],[35,8,35,9],[23,1,23,7],[49,1,49,2],[50,1,50,2],[51,7,51,10],[49,7,50,10],[39,1,39,2],[40,1,40,2],[41,1,41,2]]}
[null,"дата",null,null,null,null,"реклама","полиграфия","сувенир"]
[null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!B2)","v":"2018-01-04T02:40:03"},null,null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!A2)","v":1},null,"реклама"]
[]
[]
[]
[]
[]
[null,"Ф.И.О. заказчика:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!C2)","v":"Фролов В.Ф."}]
[null,"Телефон:",null,{"$f":"('СПИСОК КЛИЕНТОВ 1-100'!D2)","v":79188860060}]
[null,"E-MaiL:"]
[]
[]
[]
[null,{"$f":"'СПИСОК КЛИЕНТОВ 1-100'!E2","v":"кружка"},null,null,null,null,null,null,"итоги"]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"общая сумма заказа",null,null,null,{"$f":"SUBTOTAL(109,I15:J34)","v":0}]
[null,"НЕ ОПЛАЧЕНО",null,null,"предоплата",null,null,null,0]
[null,null,null,null,"остаток",null,null,null,{"$f":"I35-I36","v":0}]
[null,null,null,null,"ОПЛАЧЕНО","НЕ ОПЛАЧЕНО","ОПЛАЧЕНО забрали","ОТКАЗАЛИСЬ"]
[null,"СРОК ИЗГОТОВЛЕНИЯ МАКЕТА",null,null,"Подпись заказчика об "]
[null,".  .   2018г.",null,null,"утверждении макета:"]
[null,"СРОК ИЗГОТОВЛЕНИЯ ЗАКАЗА",null,null,"Подпись заказчика о "]
[null,".  .  2018г.",null,null,"выдачи заказа:"]
[]
["     "]
[]
[null,null,{"$f":"$D8","v":"Фролов В.Ф."}]
[null,null,{"$f":"B14","v":"кружка"}]
[]
[null,"        общая сумма",null,{"$f":"I35","v":0}]
[null,"        предоплата",null,{"$f":"I36","v":0},null,null,null,"Виктор"]
[null,"        остаток",null,{"$f":"I37","v":0}]
[null,null,null,null,null,null,null,"т.8-962-447-40-42"]