{"text_format":"1","workbook":"xlsx","n_sheets":2,"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":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,"Плановое задание за ",{"$f":"DAY(TODAY())-1","v":28},{"$f":"план_график!A1","v":"2016-09-01"}]
["Наименование","План на месяц, м","план на сутки, м","План с начала месяца, м","Факт. выполнение с начала месяца, м","Выполнено с начала месяца, %","Выполнено к месячному плану, %",null,"               "]
["Товар 1",{"$f":"VLOOKUP(A3,план_график!$A$2:$D$6,3,0)","v":32595},{"$f":"VLOOKUP(A3,план_график!$A$2:$D$6,4,0)","v":6519},{"$f":"C3*5","v":32595},32595,{"$f":"IFERROR(E3*100/D3,\"\")","v":100},{"$f":"IFERROR(E3*100/B3,\"\")","v":100}]
["Товар 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*5","v":37500},38000,{"$f":"IFERROR(E4*100/D4,\"\")","v":101.33333333333333},{"$f":"IFERROR(E4*100/B4,\"\")","v":101.33333333333333}]
["Товар 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*27","v":180063},177000,98.29892870828543,91.519692245645061]

{"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,32595,6519,{"$f":"C2/D2","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5190000000000001,{"$f":"V2+6.519","v":13.038},{"$f":"W2+6.519","v":19.557000000000002},{"$f":"X2+6.519","v":26.076000000000001},{"$f":"Y2+6.519","v":32.594999999999999}]
[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,32.594999999999999]
["Товар 2",7,37500,7500,{"$f":"C4/D4","v":5},null,null,null,null,null,null,null,null,null,7.5,{"$f":"O4+7.5","v":15},22.5,30,37.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
["Товар 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,177]
[]
[null,null,null,null,null,null,"  "]
[]
[]
[null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Должно получиться"]
[]
["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,32595,6519,{"$f":"C15/D15","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5190000000000001,{"$f":"V15+6.519","v":13.038},{"$f":"W15+6.519","v":19.557000000000002},{"$f":"X15+6.519","v":26.076000000000001},{"$f":"Y15+6.519","v":32.594999999999999}]
[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,32.594999999999999]
["Товар 2",7,37500,7500,{"$f":"C17/D17","v":5},null,null,null,null,null,null,null,null,null,7.5,{"$f":"O17+7.5","v":15},{"$f":"P17+7.5","v":22.5},{"$f":"Q17+7.5","v":30},{"$f":"R17+7.5","v":37.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
["Товар 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,177]
[]
[]
["После заполнения столбца Е на листе \"отчет\", на листе \"план_график\" в строках 3, 5 и 7 должны появиться соответствующие данные за вчерашний день (с учетом выполненного плана, см. образец ниже)."]