{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["участок №1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":false,"merged":[[51,1,52,1],[53,1,54,1],[55,1,56,1],[75,1,76,1],[75,10,76,11],[75,12,76,13],[77,1,78,1],[77,10,78,11],[77,12,78,13],[71,1,72,1],[71,10,72,11],[71,12,72,13],[73,1,74,1],[73,10,74,11],[73,12,74,13],[57,10,58,11],[61,10,62,11],[15,12,16,13],[19,10,20,11],[21,10,22,11],[67,1,68,1],[67,12,68,13],[67,10,68,11],[69,1,70,1],[69,10,70,11],[69,12,70,13],[63,1,64,1],[65,1,66,1],[47,10,48,11],[65,12,66,13],[63,12,64,13],[65,10,66,11],[63,10,64,11],[59,10,60,11],[59,12,60,13],[61,12,62,13],[57,1,58,1],[59,1,60,1],[61,1,62,1],[47,1,48,1],[49,1,50,1],[37,12,38,13],[35,12,36,13],[33,12,34,13],[25,12,26,13],[29,10,30,11],[35,10,36,11],[37,10,38,11],[23,12,24,13],[17,12,18,13],[19,12,20,13],[21,12,22,13],[31,10,32,11],[27,12,28,13],[29,12,30,13],[31,12,32,13],[23,10,24,11],[25,10,26,11],[27,10,28,11],[17,10,18,11],[33,10,34,11],[13,1,14,1],[15,1,16,1],[17,1,18,1],[6,10,8,13],[0,10,1,13],[2,10,3,11],[4,10,5,11],[2,12,3,13],[4,12,5,13],[0,2,12,2],[0,3,5,9],[0,1,12,1],[6,3,12,3],[6,4,12,4],[6,5,12,5],[6,6,12,6],[6,7,12,7],[6,8,12,8],[6,9,12,9],[9,10,12,11],[9,12,12,13],[13,10,14,11],[13,12,14,13],[15,10,16,11],[49,12,50,13],[55,10,56,11],[53,10,54,11],[51,10,52,11],[49,10,50,11],[43,12,44,13],[55,12,56,13],[57,12,58,13],[45,10,46,11],[51,12,52,13],[53,12,54,13],[47,12,48,13],[29,1,30,1],[31,1,32,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[41,1,42,1],[43,1,44,1],[45,1,46,1],[39,10,40,11],[39,12,40,13],[41,12,42,13],[45,12,46,13],[39,1,40,1],[41,10,42,11],[43,10,44,11]]}
[null,"Дата","Смена","Загружено шаров (тн)",null,null,null,null,null,null,{"$f":"\"Остаток на \"&TEXT(TODAY(),\"ДД.ММ.\")&MID(CELL(\"имяфайла\"),SEARCH(\"ы\",CELL(\"имяфайла\"),1)+2,4)","v":"Остаток на 29.07.2017"},null,null,null,"ДАТА",100,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Остаток на 01.\"&\"0\"&ROW(A1)&\".\"&MID(CELL(\"имяфайла\"),SEARCH(\"ы\",CELL(\"имяфайла\"),1)+2,4)","v":"Остаток на 01.01.2017"},{"$f":"IF(TODAY()=DATEVALUE(MID(O2,12,10)),$K$5,\"нет данных\")","v":"нет данных"},{"$f":"IF(TODAY()=DATEVALUE(MID(O2,12,10)),$M$5,\"нет данных\")","v":"нет данных"},{"$f":"DATEVALUE(MID(O2,12,10))","v":"2017-01-01"}]
[null,null,null,null,null,null,null,null,null,null,"Шары 100мм",null,"Шары 40мм",null,{"$f":"\"Остаток на 01.\"&\"0\"&ROW(A2)&\".\"&MID(CELL(\"имяфайла\"),SEARCH(\"ы\",CELL(\"имяфайла\"),1)+2,4)","v":"Остаток на 01.02.2017"},{"$f":"IF(TODAY()=DATEVALUE(MID(O3,12,10)),$K$5,\"нет данных\")","v":"нет данных"},{"$f":"IF(TODAY()=DATEVALUE(MID(O3,12,10)),$M$5,\"нет данных\")","v":"нет данных"},{"$f":"DATEVALUE(MID(O3,12,10))","v":"2017-02-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на 01.03.2017",{"$f":"IF(TODAY()=DATEVALUE(MID(O4,12,10)),$K$5,\"нет данных\")","v":"нет данных"},{"$f":"IF(TODAY()=DATEVALUE(MID(O4,12,10)),$M$5,\"нет данных\")","v":"нет данных"},"2017-03-01"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(SUM(K14:L365)-SUM(D14:G365),\"0,00\")&\" тн\"","v":"3,44 тн"},null,{"$f":"TEXT(SUM(M14:N365)-SUM(H14:J365),\"0,00\")&\" тн\"","v":"8,13 тн"},null,"Остаток на 01.04.2017",5.3,7.31,"2017-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на 01.05.2017",6.14,6.43,"2017-05-01"]
[null,null,null,"ШМ №1 100 мм","ШМ №2 100 мм","ШМ №3 100 мм","ШМ №4 100 мм","ШМ №5 40 мм","ШМ №6 40 мм","ШМ №7 40 мм","Привоз (тн)",null,null,null,"Остаток на 01.06.2017",9.0500000000000007,13.11,"2017-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на 01.07.2017",8.8800000000000008,8.1300000000000008,"2017-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на 01.08.2017",3.44,8.1300000000000008,"2017-08-01"]
[null,null,null,null,null,null,null,null,null,null,"Шары 100мм",null,"Шары 40мм",null,"Остаток на 01.09.2017","нет данных","нет данных","2017-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Остаток на 01.\"&ROW(A10)&\".\"&MID(CELL(\"имяфайла\"),SEARCH(\"ы\",CELL(\"имяфайла\"),1)+2,4)","v":"Остаток на 01.10.2017"},"нет данных","нет данных","2017-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Остаток на 01.\"&ROW(A11)&\".\"&MID(CELL(\"имяфайла\"),SEARCH(\"ы\",CELL(\"имяфайла\"),1)+2,4)","v":"Остаток на 01.11.2017"},"нет данных","нет данных","2017-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Остаток на 01.12.2017",{"$f":"IF(TODAY()=DATEVALUE(MID(O13,12,10)),$K$5,\"нет данных\")","v":"нет данных"},{"$f":"IF(TODAY()=DATEVALUE(MID(O13,12,10)),$M$5,\"нет данных\")","v":"нет данных"},"2017-12-01"]
[null,"2017-03-23",null,null,null,null,null,3,null,null,0,null,5]
[]
[null,"2017-03-24",null,null,null,null,null,null,null,2,5.3,null,7.31]
[]
[null,"2017-03-28"]
[]
[null,"2017-03-29",null,1]
[]
[null,"2017-04-05"]
[null,null,null,null,null,2]
[null,"2017-04-11",null,null,null,null,null,null,null,3]
[]
[null,"2017-04-12",null,2,null,null,null,null,null,null,6.14]
[]
[null,"2017-04-17",null,null,0.3,null,null,null,null,null,null,null,6.42]
[]
[null,"2017-04-18"]
[]
[null,"2017-04-04",null,null,null,null,null,null,4.3]
[]
[null,"2017-05-05",null,null,null,null,null,null,null,null,6.91,null,6.68]
[]
[null,"2017-05-14",null,null,null,2]
[]
[null,"2017-05-20",null,2]
[]
[null,"2017-06-13",null,null,null,null,null,3]
[]
[null,"2017-06-15",null,null,null,2]
[]
[null,"2017-06-16",null,null,null,null,null,null,3]
[]
[null,"2017-06-20",null,null,null,null,null,null,null,null,6.83,null,7.02]
[]
[null,"2017-06-23",null,null,null,3]
[]
[null,"2017-06-24",null,null,null,null,null,null,3]
[]
[null,"2017-06-26",null,null,null,null,2]
[]
[null,"2017-06-29",null,null,null,null,null,3]
[]
[null,"2017-07-01",null,null,null,2]
[]
[null,"2017-07-05",null,1]
[]
[null,"2017-07-06",null,null,3]
[]
[null,"2017-07-14",null,null,null,null,null,null,null,null,5.56]
[]
[null,"2017-07-18",null,null,null,null,3]
[]
[null,"2017-07-29",null,null,null,2]