{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Данные по заказам","Касса","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["№ договора","Дата","Контрагент","Название/ФИО","Контакты","Общая сумма","дата предоплаты","Предоплата","Задание передано в ЦЕХ (дата)","Готовность (дата)","Монтаж (да/нет)","Монтаж (дата)","Дата \nИтоговой выплаты","Итоговая выплата","Дата контрольного звонка","Результат\n контрольного звонка"]
["136-112-102","2015-12-08",null,"Сидоров Петр Алексеевич",89051250909,19000,"2015-12-08",18000,null,null,null,null,"2015-12-10",{"$f":"F2-H2","v":1000},"2016-01-11"]
[null,null,null,null,null,19000,"2015-12-08",18000,null,null,null,null,null,{"$f":"F3-H3","v":1000}]
[null,null,null,null,null,19000,"2015-12-08",18000,null,null,null,null,null,1000]
[null,null,null,null,null,19000,"2015-12-08",18000,null,null,null,null,null,1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Итого за месяц",null,{"$f":"SUM(H2:H32)+N2:N32","v":{"$error":"#VALUE!"}}]

{"sheet":"Касса","index":1,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Дата","Денег в кассе1","Денег в кассе2","Итого в Кассе","Взято из кассы","Дата","Кто взял","Остаток в кассе"]
["2015-12-01",{"$f":"IFERROR(VLOOKUP(A2,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A2,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C2+B2","v":0},0,null,null,{"$f":"D2-E2","v":0}]
["2015-12-02",{"$f":"IFERROR(VLOOKUP(A3,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A3,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C3+B3+H2","v":0},0,null,null,0]
["2015-12-03",{"$f":"IFERROR(VLOOKUP(A4,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A4,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C4+B4+H3","v":0},0,null,null,0]
["2015-12-04",{"$f":"IFERROR(VLOOKUP(A5,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A5,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},0,0,null,null,0]
["2015-12-05",{"$f":"IFERROR(VLOOKUP(A6,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A6,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},0,0,null,null,0]
["2015-12-06",{"$f":"IFERROR(VLOOKUP(A7,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A7,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},0,0,null,null,0]
["2015-12-07",{"$f":"IFERROR(VLOOKUP(A8,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A8,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},0,0,null,null,0]
["2015-12-08",{"$f":"IFERROR(VLOOKUP(A9,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":18000},{"$f":"IFERROR(VLOOKUP(A9,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},18000,0,null,null,{"$f":"D9-E9","v":18000}]
["2015-12-09",{"$f":"IFERROR(VLOOKUP(A10,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A10,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},18000,0,null,null,{"$f":"D10-E10","v":18000}]
["2015-12-10",{"$f":"IFERROR(VLOOKUP(A11,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A11,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":1000},{"$f":"C11+B11+H10","v":19000},0,null,null,19000]
["2015-12-11",{"$f":"IFERROR(VLOOKUP(A12,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A12,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C12+B12+H11","v":19000},0,null,null,19000]
["2015-12-12",{"$f":"IFERROR(VLOOKUP(A13,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A13,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C13+B13+H12","v":19000},70000,"2015-12-12","А",-51000]
["2015-12-13",{"$f":"IFERROR(VLOOKUP(A14,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A14,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-14",{"$f":"IFERROR(VLOOKUP(A15,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A15,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-15",{"$f":"IFERROR(VLOOKUP(A16,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A16,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-16",{"$f":"IFERROR(VLOOKUP(A17,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A17,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-17",{"$f":"IFERROR(VLOOKUP(A18,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A18,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-18",{"$f":"IFERROR(VLOOKUP(A19,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A19,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-19",{"$f":"IFERROR(VLOOKUP(A20,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A20,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-20",{"$f":"IFERROR(VLOOKUP(A21,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A21,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-21",{"$f":"IFERROR(VLOOKUP(A22,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A22,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-22",{"$f":"IFERROR(VLOOKUP(A23,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A23,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-23",{"$f":"IFERROR(VLOOKUP(A24,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A24,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-24",{"$f":"IFERROR(VLOOKUP(A25,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A25,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-25",{"$f":"IFERROR(VLOOKUP(A26,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A26,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-26",{"$f":"IFERROR(VLOOKUP(A27,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A27,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-27",{"$f":"IFERROR(VLOOKUP(A28,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A28,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-28",{"$f":"IFERROR(VLOOKUP(A29,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A29,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-29",{"$f":"IFERROR(VLOOKUP(A30,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A30,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-30",{"$f":"IFERROR(VLOOKUP(A31,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A31,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2015-12-31",{"$f":"IFERROR(VLOOKUP(A32,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A32,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
[]
["2016-01-01",{"$f":"IFERROR(VLOOKUP(A34,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A34,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C34+B34+H32","v":-51000},0,null,null,-51000]
["2016-01-02",{"$f":"IFERROR(VLOOKUP(A35,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A35,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},{"$f":"C35+B35+H34","v":-51000},0,null,null,-51000]
["2016-01-03",{"$f":"IFERROR(VLOOKUP(A36,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A36,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-04",{"$f":"IFERROR(VLOOKUP(A37,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A37,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-05",{"$f":"IFERROR(VLOOKUP(A38,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A38,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-06",{"$f":"IFERROR(VLOOKUP(A39,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A39,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-07",{"$f":"IFERROR(VLOOKUP(A40,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A40,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-08",{"$f":"IFERROR(VLOOKUP(A41,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A41,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-09",{"$f":"IFERROR(VLOOKUP(A42,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A42,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-10",{"$f":"IFERROR(VLOOKUP(A43,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A43,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-11",{"$f":"IFERROR(VLOOKUP(A44,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A44,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-12",{"$f":"IFERROR(VLOOKUP(A45,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A45,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-13",{"$f":"IFERROR(VLOOKUP(A46,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A46,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-14",{"$f":"IFERROR(VLOOKUP(A47,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A47,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-15",{"$f":"IFERROR(VLOOKUP(A48,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A48,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-16",{"$f":"IFERROR(VLOOKUP(A49,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A49,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-17",{"$f":"IFERROR(VLOOKUP(A50,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A50,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-18",{"$f":"IFERROR(VLOOKUP(A51,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A51,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-19",{"$f":"IFERROR(VLOOKUP(A52,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A52,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-20",{"$f":"IFERROR(VLOOKUP(A53,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A53,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-21",{"$f":"IFERROR(VLOOKUP(A54,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A54,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-22",{"$f":"IFERROR(VLOOKUP(A55,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A55,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-23",{"$f":"IFERROR(VLOOKUP(A56,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A56,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-24",{"$f":"IFERROR(VLOOKUP(A57,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A57,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-25",{"$f":"IFERROR(VLOOKUP(A58,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A58,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-26",{"$f":"IFERROR(VLOOKUP(A59,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A59,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-27",{"$f":"IFERROR(VLOOKUP(A60,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A60,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-28",{"$f":"IFERROR(VLOOKUP(A61,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A61,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-29",{"$f":"IFERROR(VLOOKUP(A62,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A62,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-30",{"$f":"IFERROR(VLOOKUP(A63,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A63,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]
["2016-01-31",{"$f":"IFERROR(VLOOKUP(A64,'Данные по заказам'!$G$2:$H$32,2,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(A64,'Данные по заказам'!$M$2:$N$32,2,0),0)","v":0},-51000,0,null,null,-51000]

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