{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["отчет","план_график","факт","смена"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,"Плановое задание за ",{"$f":"DAY(H1)","v":28},{"$f":"план_график!A1","v":"2016-09-01"},null,"2016-09-28"]
["Наименование","План на месяц, м","план на сутки, м","План с начала месяца, м","Факт. выполнение с начала месяца, м","Выполнено с начала месяца, %","Выполнено к месячному плану, %",null,"               "]
["Товар 1",13000,2600,{"$f":"C3*FLOOR(COUNTIF(смена!B7:BK7,\">0\")/2,1)","v":13000},{"$f":"смена!BL7","v":12976},{"$f":"IFERROR(E3*100/D3,\"\")","v":99.815384615384616},{"$f":"IFERROR(E3*100/B3,\"\")","v":99.815384615384616}]
["Товар 2",{"$f":"VLOOKUP(A4,план_график!$A$2:$D$6,3,0)","v":37500},{"$f":"VLOOKUP(A4,план_график!$A$2:$D$6,4,0)","v":7500},{"$f":"C4*FLOOR(COUNTIF(смена!B8:BK8,\">0\")/2,1)","v":37500},{"$f":"смена!BL8","v":37560},{"$f":"IFERROR(E4*100/D4,\"\")","v":100.16},{"$f":"IFERROR(E4*100/B4,\"\")","v":100.16}]
["Товар 3",{"$f":"VLOOKUP(A5,план_график!$A$2:$D$6,3,0)","v":193401},{"$f":"VLOOKUP(A5,план_график!$A$2:$D$6,4,0)","v":6669},{"$f":"C5*COUNTIF(смена!B9:BK9,\">0\")/2","v":186732},{"$f":"смена!BL9","v":191952},102.79545016387122,99.250779468565312,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-30"]

{"sheet":"план_график","index":1,"n_rows":23,"n_cols":36,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[14,0,15,0],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[18,0,19,0],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4]]}
["2016-09-01","№ линии","План на месяц","план на сутки","ст. дн.",{"$f":"A1","v":"2016-09-01"},{"$f":"F1+1","v":"2016-09-02"},{"$f":"G1+1","v":"2016-09-03"},"2016-09-04","2016-09-05","2016-09-06","2016-09-07","2016-09-08","2016-09-09","2016-09-10","2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17","2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24","2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30","2016-10-01"]
["Товар 1",7,13000,2600,{"$f":"C2/D2","v":5},null,null,null,2.6,{"$f":"I2+2.6","v":5.2},{"$f":"J2+2.6","v":7.8000000000000007},10.4,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.976000000000001]
["Товар 2",6,37500,7500,{"$f":"C4/D4","v":5},null,7.5,{"$f":"G4+7.5","v":15},22.5,30,37.5]
[null,null,null,null,null,null,null,null,null,null,37.56]
["Товар 3",3,193401,6669,{"$f":"C6/D6","v":29},6.6689999999999996,{"$f":"F6+6.669","v":13.337999999999999},20.006999999999998,26.675999999999998,33.344999999999999,40.013999999999996,46.682999999999993,53.35199999999999,60.020999999999987,66.689999999999984,73.35899999999998,80.027999999999977,86.696999999999974,93.365999999999971,100.03499999999997,106.70399999999997,113.37299999999996,120.04199999999996,126.71099999999996,133.37999999999997,140.04899999999998,146.71799999999999,153.387,{"$f":"AB6+6.669","v":160.05600000000001},{"$f":"AC6+6.669","v":166.72500000000002},{"$f":"AD6+6.669","v":173.39400000000003},{"$f":"AE6+6.669","v":180.06300000000005},{"$f":"AF6+6.669","v":186.73200000000006},{"$f":"AG6+6.669","v":193.40100000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191.952]
[]
[null,null,null,null,null,null,"  "]
[]
[]
[null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Должно получиться за 28.09.2016"]
[]
["2016-09-01","№ линии","План на месяц","план на сутки","ст. дн.",{"$f":"A14","v":"2016-09-01"},{"$f":"F14+1","v":"2016-09-02"},{"$f":"G14+1","v":"2016-09-03"},{"$f":"H14+1","v":"2016-09-04"},{"$f":"I14+1","v":"2016-09-05"},{"$f":"J14+1","v":"2016-09-06"},{"$f":"K14+1","v":"2016-09-07"},{"$f":"L14+1","v":"2016-09-08"},{"$f":"M14+1","v":"2016-09-09"},{"$f":"N14+1","v":"2016-09-10"},{"$f":"O14+1","v":"2016-09-11"},{"$f":"P14+1","v":"2016-09-12"},{"$f":"Q14+1","v":"2016-09-13"},{"$f":"R14+1","v":"2016-09-14"},{"$f":"S14+1","v":"2016-09-15"},{"$f":"T14+1","v":"2016-09-16"},{"$f":"U14+1","v":"2016-09-17"},{"$f":"V14+1","v":"2016-09-18"},{"$f":"W14+1","v":"2016-09-19"},{"$f":"X14+1","v":"2016-09-20"},{"$f":"Y14+1","v":"2016-09-21"},{"$f":"Z14+1","v":"2016-09-22"},{"$f":"AA14+1","v":"2016-09-23"},{"$f":"AB14+1","v":"2016-09-24"},{"$f":"AC14+1","v":"2016-09-25"},{"$f":"AD14+1","v":"2016-09-26"},{"$f":"AE14+1","v":"2016-09-27"},{"$f":"AF14+1","v":"2016-09-28"},{"$f":"AG14+1","v":"2016-09-29"},{"$f":"AH14+1","v":"2016-09-30"},{"$f":"AI14+1","v":"2016-10-01"}]
["Товар 1",7,13000,2600,{"$f":"C15/D15","v":5},null,null,null,2.6,{"$f":"I15+2.6","v":5.2},{"$f":"J15+2.6","v":7.8000000000000007},10.4,13]
[null,null,null,null,null,null,null,null,null,null,null,null,12.976000000000001]
["Товар 2",6,37500,7500,{"$f":"C17/D17","v":5},null,7.5,{"$f":"G17+7.5","v":15},{"$f":"H17+7.5","v":22.5},{"$f":"I17+7.5","v":30},{"$f":"J17+7.5","v":37.5}]
[null,null,null,null,null,null,null,null,null,null,37.56]
["Товар 3",3,193401,6669,{"$f":"C19/D19","v":29},6.6689999999999996,{"$f":"F19+6.669","v":13.337999999999999},{"$f":"G19+6.669","v":20.006999999999998},{"$f":"H19+6.669","v":26.675999999999998},{"$f":"I19+6.669","v":33.344999999999999},{"$f":"J19+6.669","v":40.013999999999996},{"$f":"K19+6.669","v":46.682999999999993},{"$f":"L19+6.669","v":53.35199999999999},{"$f":"M19+6.669","v":60.020999999999987},{"$f":"N19+6.669","v":66.689999999999984},{"$f":"O19+6.669","v":73.35899999999998},{"$f":"P19+6.669","v":80.027999999999977},{"$f":"Q19+6.669","v":86.696999999999974},{"$f":"R19+6.669","v":93.365999999999971},{"$f":"S19+6.669","v":100.03499999999997},{"$f":"T19+6.669","v":106.70399999999997},{"$f":"U19+6.669","v":113.37299999999996},{"$f":"V19+6.669","v":120.04199999999996},{"$f":"W19+6.669","v":126.71099999999996},{"$f":"X19+6.669","v":133.37999999999997},{"$f":"Y19+6.669","v":140.04899999999998},{"$f":"Z19+6.669","v":146.71799999999999},{"$f":"AA19+6.669","v":153.387},{"$f":"AB19+6.669","v":160.05600000000001},{"$f":"AC19+6.669","v":166.72500000000002},{"$f":"AD19+6.669","v":173.39400000000003},{"$f":"AE19+6.669","v":180.06300000000005},{"$f":"AF19+6.669","v":186.73200000000006},{"$f":"AG19+6.669","v":193.40100000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,191.952]
[]
[]
["После заполнения столбца Е на листе \"отчет\", на листе \"план_график\" в строках 3, 5 и 7 должны появиться соответствующие данные за вчерашний день (с учетом выполненного плана, см. образец ниже)."]

{"sheet":"факт","index":2,"n_rows":9,"n_cols":66,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,25,5,26],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[5,17,5,18],[3,57,3,58],[3,59,3,60],[3,61,3,62],[5,27,5,28],[5,29,5,30],[5,31,5,32],[5,33,5,34],[5,35,5,36],[4,65,5,65],[5,61,5,62],[5,49,5,50],[5,51,5,52],[5,53,5,54],[5,55,5,56],[5,57,5,58],[5,59,5,60],[5,37,5,38],[5,39,5,40],[5,41,5,42],[5,43,5,44],[5,45,5,46],[5,47,5,48],[3,63,3,64],[4,0,5,0],[5,19,5,20],[5,21,5,22],[5,23,5,24],[3,43,3,44],[3,45,3,46],[3,47,3,48],[3,49,3,50],[3,51,3,52],[3,53,3,54],[3,31,3,32],[3,33,3,34],[3,35,3,36],[3,37,3,38],[3,39,3,40],[3,41,3,42],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[3,55,3,56],[2,61,2,62],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[2,49,2,50],[2,51,2,52],[2,53,2,54],[2,55,2,56],[2,57,2,58],[2,59,2,60],[2,37,2,38],[2,39,2,40],[2,41,2,42],[2,43,2,44],[2,45,2,46],[2,47,2,48],[2,25,2,26],[2,27,2,28],[2,29,2,30],[2,31,2,32],[2,33,2,34],[2,35,2,36],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,49,1,50],[1,51,1,52],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14]]}
[null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"2016-09-01",null,"2016-09-02",null,"2016-09-03",null,"2016-09-04",null,"2016-09-05",null,"2016-09-06",null,"2016-09-07",null,"2016-09-08",null,"2016-09-09",null,"2016-09-10",null,"2016-09-11",null,"2016-09-12",null,"2016-09-13",null,"2016-09-14",null,"2016-09-15",null,"2016-09-16",null,"2016-09-17",null,"2016-09-18",null,"2016-09-19",null,"2016-09-20",null,"2016-09-21",null,"2016-09-22",null,"2016-09-23",null,"2016-09-24",null,"2016-09-25",null,"2016-09-26",null,"2016-09-27",null,"2016-09-28",null,"2016-09-29",null,"2016-09-30",null,"2016-10-01"]
[null,"2016-09-01",null,"2016-09-02",null,"2016-09-03",null,"2016-09-04",null,"2016-09-05",null,"2016-09-06",null,"2016-09-07",null,"2016-09-08",null,"2016-09-09",null,"2016-09-10",null,"2016-09-11",null,"2016-09-12",null,"2016-09-13",null,"2016-09-14",null,"2016-09-15",null,"2016-09-16",null,"2016-09-17",null,"2016-09-18",null,"2016-09-19",null,"2016-09-20",null,"2016-09-21",null,"2016-09-22",null,"2016-09-23",null,"2016-09-24",null,"2016-09-25",null,"2016-09-26",null,"2016-09-27",null,"2016-09-28",null,"2016-09-29",null,"2016-09-30",null,"2016-10-01"]
["Наименование товаров","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","План","Выполнение плана","%"]
[null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"м","м"]
["Товар 1",null,null,null,null,null,null,1264,1304,1304,1304,1304,1304,1304,1304,1304,1280,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13000,{"$f":"SUM(B7:BK7)","v":12976},{"$f":"BM7/BL7","v":0.99815384615384617}]
["Товар 2",null,null,3720,3720,3720,3720,3720,3720,3720,3720,3720,3720,360,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37500,{"$f":"SUM(B8:BK8)","v":37560},{"$f":"BM8/BL8","v":1.0016}]
["Товар 3",1872,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,3456,1449,null,null,null,null,null,193401,193401,1]

{"sheet":"смена","index":3,"n_rows":9,"n_cols":64,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,21,1,22],[1,49,1,50],[1,51,1,52],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[1,15,1,16],[1,17,1,18],[1,19,1,20],[2,29,2,30],[2,31,2,32],[2,33,2,34],[2,35,2,36],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,61,2,62],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[2,49,2,50],[2,51,2,52],[2,53,2,54],[2,55,2,56],[2,57,2,58],[2,59,2,60],[2,37,2,38],[2,39,2,40],[2,41,2,42],[2,43,2,44],[2,45,2,46],[2,47,2,48],[2,25,2,26],[2,27,2,28],[4,0,5,0],[5,1,5,2],[5,3,5,4],[5,5,5,6],[3,43,3,44],[3,45,3,46],[3,47,3,48],[3,31,3,32],[3,33,3,34],[3,35,3,36],[3,37,3,38],[3,39,3,40],[3,41,3,42],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[5,9,5,10],[5,11,5,12],[5,13,5,14],[3,55,3,56],[3,57,3,58],[3,59,3,60],[3,61,3,62],[3,49,3,50],[3,51,3,52],[3,53,3,54],[5,55,5,56],[5,57,5,58],[5,59,5,60],[5,61,5,62],[5,43,5,44],[5,45,5,46],[5,47,5,48],[5,49,5,50],[5,51,5,52],[5,53,5,54],[5,31,5,32],[5,33,5,34],[5,35,5,36],[5,37,5,38],[5,39,5,40],[5,41,5,42],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26],[5,27,5,28],[5,29,5,30],[5,7,5,8],[5,15,5,16],[5,17,5,18]]}
[null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"2016-09-01",null,{"$f":"B3+1","v":"2016-09-02"},null,{"$f":"D3+1","v":"2016-09-03"},null,{"$f":"F3+1","v":"2016-09-04"},null,{"$f":"H3+1","v":"2016-09-05"},null,{"$f":"J3+1","v":"2016-09-06"},null,{"$f":"L3+1","v":"2016-09-07"},null,{"$f":"N3+1","v":"2016-09-08"},null,{"$f":"P3+1","v":"2016-09-09"},null,{"$f":"R3+1","v":"2016-09-10"},null,{"$f":"T3+1","v":"2016-09-11"},null,{"$f":"V3+1","v":"2016-09-12"},null,{"$f":"X3+1","v":"2016-09-13"},null,{"$f":"Z3+1","v":"2016-09-14"},null,{"$f":"AB3+1","v":"2016-09-15"},null,{"$f":"AD3+1","v":"2016-09-16"},null,{"$f":"AF3+1","v":"2016-09-17"},null,{"$f":"AH3+1","v":"2016-09-18"},null,{"$f":"AJ3+1","v":"2016-09-19"},null,{"$f":"AL3+1","v":"2016-09-20"},null,{"$f":"AN3+1","v":"2016-09-21"},null,{"$f":"AP3+1","v":"2016-09-22"},null,{"$f":"AR3+1","v":"2016-09-23"},null,{"$f":"AT3+1","v":"2016-09-24"},null,{"$f":"AV3+1","v":"2016-09-25"},null,{"$f":"AX3+1","v":"2016-09-26"},null,{"$f":"AZ3+1","v":"2016-09-27"},null,{"$f":"BB3+1","v":"2016-09-28"},null,{"$f":"BD3+1","v":"2016-09-29"},null,{"$f":"BF3+1","v":"2016-09-30"},null,{"$f":"BH3+1","v":"2016-10-01"}]
[null,"2016-09-01",null,"2016-09-02",null,"2016-09-03",null,"2016-09-04",null,"2016-09-05",null,"2016-09-06",null,"2016-09-07",null,"2016-09-08",null,"2016-09-09",null,"2016-09-10",null,"2016-09-11",null,"2016-09-12",null,"2016-09-13",null,"2016-09-14",null,"2016-09-15",null,"2016-09-16",null,"2016-09-17",null,"2016-09-18",null,"2016-09-19",null,"2016-09-20",null,"2016-09-21",null,"2016-09-22",null,"2016-09-23",null,"2016-09-24",null,"2016-09-25",null,"2016-09-26",null,"2016-09-27",null,"2016-09-28",null,"2016-09-29",null,"2016-09-30",null,"2016-10-01"]
["Наименование товаров","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","день","ночь","Выполнение плана"]
[null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"Кол-во пог.м",null,"м"]
["Товар 1",{"$f":"IF(B$3<=отчет!$H$1,факт!B7,\"\")","v":0},{"$f":"IF(B$3<=отчет!$H$1,факт!C7,\"\")","v":0},{"$f":"IF(D$3<=отчет!$H$1,факт!D7,\"\")","v":0},{"$f":"IF(D$3<=отчет!$H$1,факт!E7,\"\")","v":0},{"$f":"IF(F$3<=отчет!$H$1,факт!F7,\"\")","v":0},{"$f":"IF(F$3<=отчет!$H$1,факт!G7,\"\")","v":0},{"$f":"IF(H$3<=отчет!$H$1,факт!H7,\"\")","v":1264},{"$f":"IF(H$3<=отчет!$H$1,факт!I7,\"\")","v":1304},{"$f":"IF(J$3<=отчет!$H$1,факт!J7,\"\")","v":1304},{"$f":"IF(J$3<=отчет!$H$1,факт!K7,\"\")","v":1304},{"$f":"IF(L$3<=отчет!$H$1,факт!L7,\"\")","v":1304},{"$f":"IF(L$3<=отчет!$H$1,факт!M7,\"\")","v":1304},{"$f":"IF(N$3<=отчет!$H$1,факт!N7,\"\")","v":1304},{"$f":"IF(N$3<=отчет!$H$1,факт!O7,\"\")","v":1304},{"$f":"IF(P$3<=отчет!$H$1,факт!P7,\"\")","v":1304},{"$f":"IF(P$3<=отчет!$H$1,факт!Q7,\"\")","v":1280},{"$f":"IF(R$3<=отчет!$H$1,факт!R7,\"\")","v":0},{"$f":"IF(R$3<=отчет!$H$1,факт!S7,\"\")","v":0},{"$f":"IF(T$3<=отчет!$H$1,факт!T7,\"\")","v":0},{"$f":"IF(T$3<=отчет!$H$1,факт!U7,\"\")","v":0},{"$f":"IF(V$3<=отчет!$H$1,факт!V7,\"\")","v":0},{"$f":"IF(V$3<=отчет!$H$1,факт!W7,\"\")","v":0},{"$f":"IF(X$3<=отчет!$H$1,факт!X7,\"\")","v":0},{"$f":"IF(X$3<=отчет!$H$1,факт!Y7,\"\")","v":0},{"$f":"IF(Z$3<=отчет!$H$1,факт!Z7,\"\")","v":0},{"$f":"IF(Z$3<=отчет!$H$1,факт!AA7,\"\")","v":0},{"$f":"IF(AB$3<=отчет!$H$1,факт!AB7,\"\")","v":0},{"$f":"IF(AB$3<=отчет!$H$1,факт!AC7,\"\")","v":0},{"$f":"IF(AD$3<=отчет!$H$1,факт!AD7,\"\")","v":0},{"$f":"IF(AD$3<=отчет!$H$1,факт!AE7,\"\")","v":0},{"$f":"IF(AF$3<=отчет!$H$1,факт!AF7,\"\")","v":0},{"$f":"IF(AF$3<=отчет!$H$1,факт!AG7,\"\")","v":0},{"$f":"IF(AH$3<=отчет!$H$1,факт!AH7,\"\")","v":0},{"$f":"IF(AH$3<=отчет!$H$1,факт!AI7,\"\")","v":0},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AJ7,\"\")","v":0},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AK7,\"\")","v":0},{"$f":"IF(AL$3<=отчет!$H$1,факт!AL7,\"\")","v":0},{"$f":"IF(AL$3<=отчет!$H$1,факт!AM7,\"\")","v":0},{"$f":"IF(AN$3<=отчет!$H$1,факт!AN7,\"\")","v":0},{"$f":"IF(AN$3<=отчет!$H$1,факт!AO7,\"\")","v":0},{"$f":"IF(AP$3<=отчет!$H$1,факт!AP7,\"\")","v":0},{"$f":"IF(AP$3<=отчет!$H$1,факт!AQ7,\"\")","v":0},{"$f":"IF(AR$3<=отчет!$H$1,факт!AR7,\"\")","v":0},{"$f":"IF(AR$3<=отчет!$H$1,факт!AS7,\"\")","v":0},{"$f":"IF(AT$3<=отчет!$H$1,факт!AT7,\"\")","v":0},{"$f":"IF(AT$3<=отчет!$H$1,факт!AU7,\"\")","v":0},{"$f":"IF(AV$3<=отчет!$H$1,факт!AV7,\"\")","v":0},{"$f":"IF(AV$3<=отчет!$H$1,факт!AW7,\"\")","v":0},{"$f":"IF(AX$3<=отчет!$H$1,факт!AX7,\"\")","v":0},{"$f":"IF(AX$3<=отчет!$H$1,факт!AY7,\"\")","v":0},{"$f":"IF(AZ$3<=отчет!$H$1,факт!AZ7,\"\")","v":0},{"$f":"IF(AZ$3<=отчет!$H$1,факт!BA7,\"\")","v":0},{"$f":"IF(BB$3<=отчет!$H$1,факт!BB7,\"\")","v":0},{"$f":"IF(BB$3<=отчет!$H$1,факт!BC7,\"\")","v":0},{"$f":"IF(BD$3<=отчет!$H$1,факт!BD7,\"\")","v":0},{"$f":"IF(BD$3<=отчет!$H$1,факт!BE7,\"\")","v":0},{"$f":"IF(BF$3<=отчет!$H$1,факт!BF7,\"\")","v":""},{"$f":"IF(BF$3<=отчет!$H$1,факт!BG7,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BH7,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BI7,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BJ7,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BK7,\"\")","v":""},{"$f":"SUM(B7:BK7)","v":12976}]
["Товар 2",{"$f":"IF(B$3<=отчет!$H$1,факт!B8,\"\")","v":0},{"$f":"IF(B$3<=отчет!$H$1,факт!C8,\"\")","v":0},{"$f":"IF(D$3<=отчет!$H$1,факт!D8,\"\")","v":3720},{"$f":"IF(D$3<=отчет!$H$1,факт!E8,\"\")","v":3720},{"$f":"IF(F$3<=отчет!$H$1,факт!F8,\"\")","v":3720},{"$f":"IF(F$3<=отчет!$H$1,факт!G8,\"\")","v":3720},{"$f":"IF(H$3<=отчет!$H$1,факт!H8,\"\")","v":3720},{"$f":"IF(H$3<=отчет!$H$1,факт!I8,\"\")","v":3720},{"$f":"IF(J$3<=отчет!$H$1,факт!J8,\"\")","v":3720},{"$f":"IF(J$3<=отчет!$H$1,факт!K8,\"\")","v":3720},{"$f":"IF(L$3<=отчет!$H$1,факт!L8,\"\")","v":3720},{"$f":"IF(L$3<=отчет!$H$1,факт!M8,\"\")","v":3720},{"$f":"IF(N$3<=отчет!$H$1,факт!N8,\"\")","v":360},{"$f":"IF(N$3<=отчет!$H$1,факт!O8,\"\")","v":0},{"$f":"IF(P$3<=отчет!$H$1,факт!P8,\"\")","v":0},{"$f":"IF(P$3<=отчет!$H$1,факт!Q8,\"\")","v":0},{"$f":"IF(R$3<=отчет!$H$1,факт!R8,\"\")","v":0},{"$f":"IF(R$3<=отчет!$H$1,факт!S8,\"\")","v":0},{"$f":"IF(T$3<=отчет!$H$1,факт!T8,\"\")","v":0},{"$f":"IF(T$3<=отчет!$H$1,факт!U8,\"\")","v":0},{"$f":"IF(V$3<=отчет!$H$1,факт!V8,\"\")","v":0},{"$f":"IF(V$3<=отчет!$H$1,факт!W8,\"\")","v":0},{"$f":"IF(X$3<=отчет!$H$1,факт!X8,\"\")","v":0},{"$f":"IF(X$3<=отчет!$H$1,факт!Y8,\"\")","v":0},{"$f":"IF(Z$3<=отчет!$H$1,факт!Z8,\"\")","v":0},{"$f":"IF(Z$3<=отчет!$H$1,факт!AA8,\"\")","v":0},{"$f":"IF(AB$3<=отчет!$H$1,факт!AB8,\"\")","v":0},{"$f":"IF(AB$3<=отчет!$H$1,факт!AC8,\"\")","v":0},{"$f":"IF(AD$3<=отчет!$H$1,факт!AD8,\"\")","v":0},{"$f":"IF(AD$3<=отчет!$H$1,факт!AE8,\"\")","v":0},{"$f":"IF(AF$3<=отчет!$H$1,факт!AF8,\"\")","v":0},{"$f":"IF(AF$3<=отчет!$H$1,факт!AG8,\"\")","v":0},{"$f":"IF(AH$3<=отчет!$H$1,факт!AH8,\"\")","v":0},{"$f":"IF(AH$3<=отчет!$H$1,факт!AI8,\"\")","v":0},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AJ8,\"\")","v":0},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AK8,\"\")","v":0},{"$f":"IF(AL$3<=отчет!$H$1,факт!AL8,\"\")","v":0},{"$f":"IF(AL$3<=отчет!$H$1,факт!AM8,\"\")","v":0},{"$f":"IF(AN$3<=отчет!$H$1,факт!AN8,\"\")","v":0},{"$f":"IF(AN$3<=отчет!$H$1,факт!AO8,\"\")","v":0},{"$f":"IF(AP$3<=отчет!$H$1,факт!AP8,\"\")","v":0},{"$f":"IF(AP$3<=отчет!$H$1,факт!AQ8,\"\")","v":0},{"$f":"IF(AR$3<=отчет!$H$1,факт!AR8,\"\")","v":0},{"$f":"IF(AR$3<=отчет!$H$1,факт!AS8,\"\")","v":0},{"$f":"IF(AT$3<=отчет!$H$1,факт!AT8,\"\")","v":0},{"$f":"IF(AT$3<=отчет!$H$1,факт!AU8,\"\")","v":0},{"$f":"IF(AV$3<=отчет!$H$1,факт!AV8,\"\")","v":0},{"$f":"IF(AV$3<=отчет!$H$1,факт!AW8,\"\")","v":0},{"$f":"IF(AX$3<=отчет!$H$1,факт!AX8,\"\")","v":0},{"$f":"IF(AX$3<=отчет!$H$1,факт!AY8,\"\")","v":0},{"$f":"IF(AZ$3<=отчет!$H$1,факт!AZ8,\"\")","v":0},{"$f":"IF(AZ$3<=отчет!$H$1,факт!BA8,\"\")","v":0},{"$f":"IF(BB$3<=отчет!$H$1,факт!BB8,\"\")","v":0},{"$f":"IF(BB$3<=отчет!$H$1,факт!BC8,\"\")","v":0},{"$f":"IF(BD$3<=отчет!$H$1,факт!BD8,\"\")","v":0},{"$f":"IF(BD$3<=отчет!$H$1,факт!BE8,\"\")","v":0},{"$f":"IF(BF$3<=отчет!$H$1,факт!BF8,\"\")","v":""},{"$f":"IF(BF$3<=отчет!$H$1,факт!BG8,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BH8,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BI8,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BJ8,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BK8,\"\")","v":""},{"$f":"SUM(B8:BK8)","v":37560}]
["Товар 3",{"$f":"IF(B$3<=отчет!$H$1,факт!B9,\"\")","v":1872},{"$f":"IF(B$3<=отчет!$H$1,факт!C9,\"\")","v":3456},{"$f":"IF(D$3<=отчет!$H$1,факт!D9,\"\")","v":3456},{"$f":"IF(D$3<=отчет!$H$1,факт!E9,\"\")","v":3456},{"$f":"IF(F$3<=отчет!$H$1,факт!F9,\"\")","v":3456},{"$f":"IF(F$3<=отчет!$H$1,факт!G9,\"\")","v":3456},{"$f":"IF(H$3<=отчет!$H$1,факт!H9,\"\")","v":3456},{"$f":"IF(H$3<=отчет!$H$1,факт!I9,\"\")","v":3456},{"$f":"IF(J$3<=отчет!$H$1,факт!J9,\"\")","v":3456},{"$f":"IF(J$3<=отчет!$H$1,факт!K9,\"\")","v":3456},{"$f":"IF(L$3<=отчет!$H$1,факт!L9,\"\")","v":3456},{"$f":"IF(L$3<=отчет!$H$1,факт!M9,\"\")","v":3456},{"$f":"IF(N$3<=отчет!$H$1,факт!N9,\"\")","v":3456},{"$f":"IF(N$3<=отчет!$H$1,факт!O9,\"\")","v":3456},{"$f":"IF(P$3<=отчет!$H$1,факт!P9,\"\")","v":3456},{"$f":"IF(P$3<=отчет!$H$1,факт!Q9,\"\")","v":3456},{"$f":"IF(R$3<=отчет!$H$1,факт!R9,\"\")","v":3456},{"$f":"IF(R$3<=отчет!$H$1,факт!S9,\"\")","v":3456},{"$f":"IF(T$3<=отчет!$H$1,факт!T9,\"\")","v":3456},{"$f":"IF(T$3<=отчет!$H$1,факт!U9,\"\")","v":3456},{"$f":"IF(V$3<=отчет!$H$1,факт!V9,\"\")","v":3456},{"$f":"IF(V$3<=отчет!$H$1,факт!W9,\"\")","v":3456},{"$f":"IF(X$3<=отчет!$H$1,факт!X9,\"\")","v":3456},{"$f":"IF(X$3<=отчет!$H$1,факт!Y9,\"\")","v":3456},{"$f":"IF(Z$3<=отчет!$H$1,факт!Z9,\"\")","v":3456},{"$f":"IF(Z$3<=отчет!$H$1,факт!AA9,\"\")","v":3456},{"$f":"IF(AB$3<=отчет!$H$1,факт!AB9,\"\")","v":3456},{"$f":"IF(AB$3<=отчет!$H$1,факт!AC9,\"\")","v":3456},{"$f":"IF(AD$3<=отчет!$H$1,факт!AD9,\"\")","v":3456},{"$f":"IF(AD$3<=отчет!$H$1,факт!AE9,\"\")","v":3456},{"$f":"IF(AF$3<=отчет!$H$1,факт!AF9,\"\")","v":3456},{"$f":"IF(AF$3<=отчет!$H$1,факт!AG9,\"\")","v":3456},{"$f":"IF(AH$3<=отчет!$H$1,факт!AH9,\"\")","v":3456},{"$f":"IF(AH$3<=отчет!$H$1,факт!AI9,\"\")","v":3456},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AJ9,\"\")","v":3456},{"$f":"IF(AJ$3<=отчет!$H$1,факт!AK9,\"\")","v":3456},{"$f":"IF(AL$3<=отчет!$H$1,факт!AL9,\"\")","v":3456},{"$f":"IF(AL$3<=отчет!$H$1,факт!AM9,\"\")","v":3456},{"$f":"IF(AN$3<=отчет!$H$1,факт!AN9,\"\")","v":3456},{"$f":"IF(AN$3<=отчет!$H$1,факт!AO9,\"\")","v":3456},{"$f":"IF(AP$3<=отчет!$H$1,факт!AP9,\"\")","v":3456},{"$f":"IF(AP$3<=отчет!$H$1,факт!AQ9,\"\")","v":3456},{"$f":"IF(AR$3<=отчет!$H$1,факт!AR9,\"\")","v":3456},{"$f":"IF(AR$3<=отчет!$H$1,факт!AS9,\"\")","v":3456},{"$f":"IF(AT$3<=отчет!$H$1,факт!AT9,\"\")","v":3456},{"$f":"IF(AT$3<=отчет!$H$1,факт!AU9,\"\")","v":3456},{"$f":"IF(AV$3<=отчет!$H$1,факт!AV9,\"\")","v":3456},{"$f":"IF(AV$3<=отчет!$H$1,факт!AW9,\"\")","v":3456},{"$f":"IF(AX$3<=отчет!$H$1,факт!AX9,\"\")","v":3456},{"$f":"IF(AX$3<=отчет!$H$1,факт!AY9,\"\")","v":3456},{"$f":"IF(AZ$3<=отчет!$H$1,факт!AZ9,\"\")","v":3456},{"$f":"IF(AZ$3<=отчет!$H$1,факт!BA9,\"\")","v":3456},{"$f":"IF(BB$3<=отчет!$H$1,факт!BB9,\"\")","v":3456},{"$f":"IF(BB$3<=отчет!$H$1,факт!BC9,\"\")","v":3456},{"$f":"IF(BD$3<=отчет!$H$1,факт!BD9,\"\")","v":3456},{"$f":"IF(BD$3<=отчет!$H$1,факт!BE9,\"\")","v":3456},{"$f":"IF(BF$3<=отчет!$H$1,факт!BF9,\"\")","v":""},{"$f":"IF(BF$3<=отчет!$H$1,факт!BG9,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BH9,\"\")","v":""},{"$f":"IF(BH$3<=отчет!$H$1,факт!BI9,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BJ9,\"\")","v":""},{"$f":"IF(BJ$3<=отчет!$H$1,факт!BK9,\"\")","v":""},191952]