{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["5_days","НСИ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":137,"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":"5_days","index":0,"n_rows":40,"n_cols":40,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Заявка на отгрузки",null,null,null,100,300,300,200,null,null,null,100,100,100,100,null,null,null,150,200,250,400,null,null,null,50,200,70,10,null,null,null,100,200,300,500]
[]
[null,null,null,"Послед",1,1,1,1,1,1,"Послед",2,2,2,2,2,2,"Послед",3,3,3,3,3,3,"Послед",4,4,4,4,4,4,"Послед",5,5,5,5,5,5]
[null,null,null,null,"A","B","C","D","I","ИТОГО",null,"A","B","C","D","I","ИТОГО",null,"A","B","C","D","I","ИТОГО",null,"A","B","C","D","I","ИТОГО",null,"A","B","C","D","I","ИТОГО",null,"ВСЕГО"]
["Процессное время",null,null,null,0,0,0,0,0,{"$f":"SUM(E5:H5)","v":0},null,0,0,0,0,0,{"$f":"SUM(L5:O5)","v":0},null,0,0,0,0,0,{"$f":"SUM(S5:V5)","v":0},null,0,0,0,0,0,{"$f":"SUM(Z5:AC5)","v":0},null,0,0,0,0,0,{"$f":"SUM(AG5:AJ5)","v":0}]
["Последовательность",null,null,null,1,0,0,0,0,{"$f":"SUM(E6:H6)","v":1},null,0,0,0,0,0,{"$f":"SUM(L6:O6)","v":0},null,0,0,0,0,0,{"$f":"SUM(S6:V6)","v":0},null,0,0,0,0,0,{"$f":"SUM(Z6:AC6)","v":0},null,0,0,0,0,0,{"$f":"SUM(AG6:AJ6)","v":0}]
["Проверка последовательности",null,null,null,{"$f":"COUNTIF($E$6:$I$6,E6)","v":1},4,4,4,{"$f":"COUNTIF($E$6:$I$6,I6)","v":4},{"$f":"SUM(E7:H7)","v":13},null,{"$f":"COUNTIF($L$6:$P$6,L6)","v":5},{"$f":"COUNTIF($L$6:$P$6,M6)","v":5},5,5,5,20,null,{"$f":"COUNTIF($S$6:$W$6,S6)","v":5},{"$f":"COUNTIF($S$6:$W$6,T6)","v":5},5,5,5,20,null,{"$f":"COUNTIF($Z$6:$AD$6,Z6)","v":5},{"$f":"COUNTIF($Z$6:$AD$6,AA6)","v":5},5,5,5,20,null,{"$f":"COUNTIF($AG$6:$AK$6,AG6)","v":5},{"$f":"COUNTIF($AG$6:$AK$6,AH6)","v":5},5,5,5,20,null,{"$f":"SUM(J7,Q7,X7,AE7,AL7)","v":93}]
["Объем производства",null,null,null,{"$f":"E24*E5","v":0},{"$f":"F24*F5","v":0},0,0,null,0,null,{"$f":"L24*L5","v":0},{"$f":"M24*M5","v":0},0,0,null,0,null,{"$f":"S24*S5","v":0},{"$f":"T24*T5","v":0},0,0,null,0,null,{"$f":"Z24*Z5","v":0},{"$f":"AA24*AA5","v":0},0,0,null,0,null,{"$f":"AG24*AG5","v":0},{"$f":"AH24*AH5","v":0},0,0,null,0]
["Отгрузка",null,null,null,{"$f":"E1","v":100},{"$f":"F1","v":300},300,200,null,900,null,{"$f":"L1","v":100},{"$f":"M1","v":100},100,100,null,400,null,{"$f":"S1","v":150},{"$f":"T1","v":200},250,400,null,1000,null,{"$f":"Z1","v":50},{"$f":"AA1","v":200},70,10,null,330,null,{"$f":"AG1","v":100},{"$f":"AH1","v":200},300,500,null,1100]
["Остаток на складе",null,null,null,{"$f":"E8-E9","v":-100},{"$f":"F8-F9","v":-300},-300,-200,null,-900,null,{"$f":"E10+L8-L9","v":-200},{"$f":"F10+M8-M9","v":-400},-400,-300,null,-1300,null,{"$f":"L10+S8-S9","v":-350},{"$f":"M10+T8-T9","v":-600},{"$f":"N10+U8-U9","v":-650},{"$f":"O10+V8-V9","v":-700},null,-2300,null,{"$f":"S10+Z8-Z9","v":-400},{"$f":"T10+AA8-AA9","v":-800},{"$f":"U10+AB8-AB9","v":-720},{"$f":"V10+AC8-AC9","v":-710},null,-2630,null,{"$f":"Z10+AG8-AG9","v":-500},{"$f":"AA10+AH8-AH9","v":-1000},{"$f":"AB10+AI8-AI9","v":-1020},{"$f":"AC10+AJ8-AJ9","v":-1210},null,-3730]
[]
["Время на переналадку",null,null,null,{"$f":"E30","v":0},{"$f":"F30","v":5},5,10,null,null,null,{"$f":"L30","v":0},{"$f":"M30","v":5},5,10,null,null,null,{"$f":"S30","v":0},{"$f":"T30","v":5},5,10,null,null,null,{"$f":"Z30","v":0},{"$f":"AA30","v":5},5,10,null,null,null,{"$f":"AG30","v":0},{"$f":"AH30","v":5},5,10]
["Фонд времени",null,null,null,{"$f":"E5+E12","v":0},{"$f":"F5+F12","v":5},5,10,0,{"$f":"SUM(E13:I13)","v":20},null,{"$f":"L5+L12","v":0},{"$f":"M5+M12","v":5},{"$f":"N5+N12","v":5},{"$f":"O5+O12","v":10},{"$f":"P5+P12","v":0},{"$f":"SUM(L13:P13)","v":20},null,{"$f":"S5+S12","v":0},{"$f":"T5+T12","v":5},{"$f":"U5+U12","v":5},{"$f":"V5+V12","v":10},{"$f":"W5+W12","v":0},{"$f":"SUM(S13:W13)","v":20},null,{"$f":"Z5+Z12","v":0},{"$f":"AA5+AA12","v":5},{"$f":"AB5+AB12","v":5},{"$f":"AC5+AC12","v":10},{"$f":"AD5+AD12","v":0},{"$f":"SUM(Z13:AD13)","v":20},null,{"$f":"AG5+AG12","v":0},{"$f":"AH5+AH12","v":5},{"$f":"AI5+AI12","v":5},{"$f":"AJ5+AJ12","v":10},{"$f":"AK5+AK12","v":0},{"$f":"SUM(AG13:AK13)","v":20}]
[]
["Потери",null,null,0,{"$f":"E37","v":0},{"$f":"F37","v":0},-5,-20,null,null,null,{"$f":"L37","v":0},{"$f":"M37","v":0},-5,-20,null,null,null,{"$f":"S37","v":0},{"$f":"T37","v":0},-5,-20,null,null,null,{"$f":"Z37","v":0},{"$f":"AA37","v":0},-5,-20,null,null,null,{"$f":"AG37","v":0},{"$f":"AH37","v":0},-5,-20]
["Товарный выпуск",null,null,null,{"$f":"E8*E21","v":0},{"$f":"F8*F21","v":0},0,0,0,{"$f":"SUM(E16:I16)","v":0},null,{"$f":"L8*L21","v":0},{"$f":"M8*M21","v":0},0,0,0,{"$f":"SUM(L16:P16)","v":0},null,{"$f":"S8*S21","v":0},{"$f":"T8*T21","v":0},0,0,0,{"$f":"SUM(S16:W16)","v":0},null,{"$f":"Z8*Z21","v":0},{"$f":"AA8*AA21","v":0},0,0,0,{"$f":"SUM(Z16:AD16)","v":0},null,{"$f":"AG8*AG21","v":0},{"$f":"AH8*AH21","v":0},0,0,0,{"$f":"SUM(AG16:AK16)","v":0}]
["Себестоимостьпроизводства",null,null,null,{"$f":"-E8*E22","v":0},{"$f":"-F8*F22","v":0},0,0,0,{"$f":"SUM(E17:I17)","v":0},null,{"$f":"-L8*L22","v":0},{"$f":"-M8*M22","v":0},0,0,0,{"$f":"SUM(L17:P17)","v":0},null,{"$f":"-S8*S22","v":0},{"$f":"-T8*T22","v":0},0,0,0,{"$f":"SUM(S17:W17)","v":0},null,{"$f":"-Z8*Z22","v":0},{"$f":"-AA8*AA22","v":0},0,0,0,{"$f":"SUM(Z17:AD17)","v":0},null,{"$f":"-AG8*AG22","v":0},{"$f":"-AH8*AH22","v":0},0,0,0,{"$f":"SUM(AG17:AK17)","v":0}]
["Себестоимость потерь",null,null,null,{"$f":"E15*E23","v":0},{"$f":"F15*F23","v":0},-25,-20,0,-45,null,{"$f":"L15*L23","v":0},{"$f":"M15*M23","v":0},-25,-20,0,-45,null,{"$f":"S15*S23","v":0},{"$f":"T15*T23","v":0},-25,-20,0,-45,null,{"$f":"Z15*Z23","v":0},{"$f":"AA15*AA23","v":0},-25,-20,0,-45,null,{"$f":"AG15*AG23","v":0},{"$f":"AH15*AH23","v":0},-25,-20,0,-45]
["Фнансовый результат",null,null,null,{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},-25,-20,0,-45,null,{"$f":"SUM(L16:L18)","v":0},{"$f":"SUM(M16:M18)","v":0},{"$f":"SUM(N16:N18)","v":-25},{"$f":"SUM(O16:O18)","v":-20},{"$f":"SUM(P16:P18)","v":0},-45,null,{"$f":"SUM(S16:S18)","v":0},{"$f":"SUM(T16:T18)","v":0},{"$f":"SUM(U16:U18)","v":-25},{"$f":"SUM(V16:V18)","v":-20},{"$f":"SUM(W16:W18)","v":0},-45,null,{"$f":"SUM(Z16:Z18)","v":0},{"$f":"SUM(AA16:AA18)","v":0},{"$f":"SUM(AB16:AB18)","v":-25},{"$f":"SUM(AC16:AC18)","v":-20},{"$f":"SUM(AD16:AD18)","v":0},-45,null,{"$f":"SUM(AG16:AG18)","v":0},{"$f":"SUM(AH16:AH18)","v":0},{"$f":"SUM(AI16:AI18)","v":-25},{"$f":"SUM(AJ16:AJ18)","v":-20},{"$f":"SUM(AK16:AK18)","v":0},-45,null,{"$f":"SUM(J19,Q19,X19,AE19,AL19)","v":-225}]
[]
["Цена продаж",null,null,null,{"$f":"НСИ!$D$16","v":9},{"$f":"НСИ!$E$16","v":12},{"$f":"НСИ!$F$16","v":15},{"$f":"НСИ!$G$16","v":7},null,null,null,{"$f":"НСИ!$D$16","v":9},{"$f":"НСИ!$E$16","v":12},{"$f":"НСИ!$F$16","v":15},{"$f":"НСИ!$G$16","v":7},null,null,null,{"$f":"НСИ!$D$16","v":9},{"$f":"НСИ!$E$16","v":12},{"$f":"НСИ!$F$16","v":15},{"$f":"НСИ!$G$16","v":7},null,null,null,{"$f":"НСИ!$D$16","v":9},{"$f":"НСИ!$E$16","v":12},{"$f":"НСИ!$F$16","v":15},{"$f":"НСИ!$G$16","v":7},null,null,null,{"$f":"НСИ!$D$16","v":9},{"$f":"НСИ!$E$16","v":12},{"$f":"НСИ!$F$16","v":15},{"$f":"НСИ!$G$16","v":7}]
["Себестоимость производства",null,null,null,{"$f":"НСИ!$D$17","v":6},{"$f":"НСИ!$E$17","v":6},{"$f":"НСИ!$F$17","v":10},{"$f":"НСИ!$G$17","v":6},null,null,null,{"$f":"НСИ!$D$17","v":6},{"$f":"НСИ!$E$17","v":6},{"$f":"НСИ!$F$17","v":10},{"$f":"НСИ!$G$17","v":6},null,null,null,{"$f":"НСИ!$D$17","v":6},{"$f":"НСИ!$E$17","v":6},{"$f":"НСИ!$F$17","v":10},{"$f":"НСИ!$G$17","v":6},null,null,null,{"$f":"НСИ!$D$17","v":6},{"$f":"НСИ!$E$17","v":6},{"$f":"НСИ!$F$17","v":10},{"$f":"НСИ!$G$17","v":6},null,null,null,{"$f":"НСИ!$D$17","v":6},{"$f":"НСИ!$E$17","v":6},{"$f":"НСИ!$F$17","v":10},{"$f":"НСИ!$G$17","v":6}]
["Себестоимость потерь",null,null,null,{"$f":"НСИ!$D$18","v":3},{"$f":"НСИ!$E$18","v":8},{"$f":"НСИ!$F$18","v":5},{"$f":"НСИ!$G$18","v":1},null,null,null,{"$f":"НСИ!$D$18","v":3},{"$f":"НСИ!$E$18","v":8},{"$f":"НСИ!$F$18","v":5},{"$f":"НСИ!$G$18","v":1},null,null,null,{"$f":"НСИ!$D$18","v":3},{"$f":"НСИ!$E$18","v":8},{"$f":"НСИ!$F$18","v":5},{"$f":"НСИ!$G$18","v":1},null,null,null,{"$f":"НСИ!$D$18","v":3},{"$f":"НСИ!$E$18","v":8},{"$f":"НСИ!$F$18","v":5},{"$f":"НСИ!$G$18","v":1},null,null,null,{"$f":"НСИ!$D$18","v":3},{"$f":"НСИ!$E$18","v":8},{"$f":"НСИ!$F$18","v":5},{"$f":"НСИ!$G$18","v":1}]
["Производительность",null,null,null,{"$f":"НСИ!$D$13","v":12},{"$f":"НСИ!$E$13","v":12},{"$f":"НСИ!$F$13","v":8},{"$f":"НСИ!$G$13","v":9},null,null,null,{"$f":"НСИ!$D$13","v":12},{"$f":"НСИ!$E$13","v":12},{"$f":"НСИ!$F$13","v":8},{"$f":"НСИ!$G$13","v":9},null,null,null,{"$f":"НСИ!$D$13","v":12},{"$f":"НСИ!$E$13","v":12},{"$f":"НСИ!$F$13","v":8},{"$f":"НСИ!$G$13","v":9},null,null,null,{"$f":"НСИ!$D$13","v":12},{"$f":"НСИ!$E$13","v":12},{"$f":"НСИ!$F$13","v":8},{"$f":"НСИ!$G$13","v":9},null,null,null,{"$f":"НСИ!$D$13","v":12},{"$f":"НСИ!$E$13","v":12},{"$f":"НСИ!$F$13","v":8},{"$f":"НСИ!$G$13","v":9}]
["Норматив времени на переналадку",null,"A",{"$f":"E6","v":1},{"$f":"НСИ!$D$9","v":0},{"$f":"НСИ!$E$9","v":5},{"$f":"НСИ!$F$9","v":5},{"$f":"НСИ!$G$9","v":10},null,null,{"$f":"L6","v":0},{"$f":"НСИ!$D$9","v":0},{"$f":"НСИ!$E$9","v":5},{"$f":"НСИ!$F$9","v":5},{"$f":"НСИ!$G$9","v":10},null,null,{"$f":"S6","v":0},{"$f":"НСИ!$D$9","v":0},{"$f":"НСИ!$E$9","v":5},{"$f":"НСИ!$F$9","v":5},{"$f":"НСИ!$G$9","v":10},null,null,{"$f":"Z6","v":0},{"$f":"НСИ!$D$9","v":0},{"$f":"НСИ!$E$9","v":5},{"$f":"НСИ!$F$9","v":5},{"$f":"НСИ!$G$9","v":10},null,null,{"$f":"AG6","v":0},{"$f":"НСИ!$D$9","v":0},{"$f":"НСИ!$E$9","v":5},{"$f":"НСИ!$F$9","v":5},{"$f":"НСИ!$G$9","v":10}]
[null,null,"B",{"$f":"F6","v":0},{"$f":"НСИ!$D$10","v":5},{"$f":"НСИ!$E$10","v":0},{"$f":"НСИ!$F$10","v":8},{"$f":"НСИ!$G$10","v":12},null,null,{"$f":"M6","v":0},{"$f":"НСИ!$D$10","v":5},{"$f":"НСИ!$E$10","v":0},{"$f":"НСИ!$F$10","v":8},{"$f":"НСИ!$G$10","v":12},null,null,{"$f":"T6","v":0},{"$f":"НСИ!$D$10","v":5},{"$f":"НСИ!$E$10","v":0},{"$f":"НСИ!$F$10","v":8},{"$f":"НСИ!$G$10","v":12},null,null,{"$f":"AA6","v":0},{"$f":"НСИ!$D$10","v":5},{"$f":"НСИ!$E$10","v":0},{"$f":"НСИ!$F$10","v":8},{"$f":"НСИ!$G$10","v":12},null,null,{"$f":"AH6","v":0},{"$f":"НСИ!$D$10","v":5},{"$f":"НСИ!$E$10","v":0},{"$f":"НСИ!$F$10","v":8},{"$f":"НСИ!$G$10","v":12}]
[null,null,"C",{"$f":"G6","v":0},{"$f":"НСИ!$D$11","v":8},{"$f":"НСИ!$E$11","v":10},{"$f":"НСИ!$F$11","v":0},{"$f":"НСИ!$G$11","v":15},null,null,{"$f":"N6","v":0},{"$f":"НСИ!$D$11","v":8},{"$f":"НСИ!$E$11","v":10},{"$f":"НСИ!$F$11","v":0},{"$f":"НСИ!$G$11","v":15},null,null,{"$f":"U6","v":0},{"$f":"НСИ!$D$11","v":8},{"$f":"НСИ!$E$11","v":10},{"$f":"НСИ!$F$11","v":0},{"$f":"НСИ!$G$11","v":15},null,null,{"$f":"AB6","v":0},{"$f":"НСИ!$D$11","v":8},{"$f":"НСИ!$E$11","v":10},{"$f":"НСИ!$F$11","v":0},{"$f":"НСИ!$G$11","v":15},null,null,{"$f":"AI6","v":0},{"$f":"НСИ!$D$11","v":8},{"$f":"НСИ!$E$11","v":10},{"$f":"НСИ!$F$11","v":0},{"$f":"НСИ!$G$11","v":15}]
[null,null,"D",{"$f":"H6","v":0},{"$f":"НСИ!$D$12","v":10},{"$f":"НСИ!$E$12","v":8},{"$f":"НСИ!$F$12","v":5},{"$f":"НСИ!$G$12","v":0},null,null,{"$f":"O6","v":0},{"$f":"НСИ!$D$12","v":10},{"$f":"НСИ!$E$12","v":8},{"$f":"НСИ!$F$12","v":5},{"$f":"НСИ!$G$12","v":0},null,null,{"$f":"V6","v":0},{"$f":"НСИ!$D$12","v":10},{"$f":"НСИ!$E$12","v":8},{"$f":"НСИ!$F$12","v":5},{"$f":"НСИ!$G$12","v":0},null,null,{"$f":"AC6","v":0},{"$f":"НСИ!$D$12","v":10},{"$f":"НСИ!$E$12","v":8},{"$f":"НСИ!$F$12","v":5},{"$f":"НСИ!$G$12","v":0},null,null,{"$f":"AJ6","v":0},{"$f":"НСИ!$D$12","v":10},{"$f":"НСИ!$E$12","v":8},{"$f":"НСИ!$F$12","v":5},{"$f":"НСИ!$G$12","v":0}]
[null,null,"I",{"$f":"I5","v":0},null,null,null,null,null,null,{"$f":"P5","v":0},null,null,null,null,null,null,{"$f":"W5","v":0},null,null,null,null,null,null,{"$f":"AD5","v":0},null,null,null,null,null,null,{"$f":"AK5","v":0}]
["Время на переналадку",null,null,null,{"$f":"SUMPRODUCT(E25:E28,--($D$25:$D$28=E6+1))","v":0},{"$f":"SUMPRODUCT(F25:F28,--($D$25:$D$28=F6+1))","v":5},5,10,0,null,null,{"$f":"SUMPRODUCT(L25:L28,--($D$25:$D$28=L6+1))","v":0},{"$f":"SUMPRODUCT(M25:M28,--($D$25:$D$28=M6+1))","v":5},5,10,0,null,null,{"$f":"SUMPRODUCT(S25:S28,--($D$25:$D$28=S6+1))","v":0},{"$f":"SUMPRODUCT(T25:T28,--($D$25:$D$28=T6+1))","v":5},5,10,0,null,null,{"$f":"SUMPRODUCT(Z25:Z28,--($D$25:$D$28=Z6+1))","v":0},{"$f":"SUMPRODUCT(AA25:AA28,--($D$25:$D$28=AA6+1))","v":5},5,10,0,null,null,{"$f":"SUMPRODUCT(AG25:AG28,--($D$25:$D$28=AG6+1))","v":0},{"$f":"SUMPRODUCT(AH25:AH28,--($D$25:$D$28=AH6+1))","v":5},5,10,0]
[]
["Номатив потерь",null,"A",{"$f":"D25","v":1},{"$f":"НСИ!$D$5","v":0},{"$f":"НСИ!$E$5","v":0},{"$f":"НСИ!$F$5","v":-5},{"$f":"НСИ!$G$5","v":-20},null,null,{"$f":"K25","v":0},{"$f":"НСИ!$D$5","v":0},{"$f":"НСИ!$E$5","v":0},{"$f":"НСИ!$F$5","v":-5},{"$f":"НСИ!$G$5","v":-20},null,null,{"$f":"R25","v":0},{"$f":"НСИ!$D$5","v":0},{"$f":"НСИ!$E$5","v":0},{"$f":"НСИ!$F$5","v":-5},{"$f":"НСИ!$G$5","v":-20},null,null,{"$f":"Y25","v":0},{"$f":"НСИ!$D$5","v":0},{"$f":"НСИ!$E$5","v":0},{"$f":"НСИ!$F$5","v":-5},{"$f":"НСИ!$G$5","v":-20},null,null,{"$f":"AF25","v":0},{"$f":"НСИ!$D$5","v":0},{"$f":"НСИ!$E$5","v":0},{"$f":"НСИ!$F$5","v":-5},{"$f":"НСИ!$G$5","v":-20}]
[null,null,"B",{"$f":"D26","v":0},{"$f":"НСИ!$D$6","v":-10},{"$f":"НСИ!$E$6","v":0},{"$f":"НСИ!$F$6","v":0},{"$f":"НСИ!$G$6","v":0},null,null,{"$f":"K26","v":0},{"$f":"НСИ!$D$6","v":-10},{"$f":"НСИ!$E$6","v":0},{"$f":"НСИ!$F$6","v":0},{"$f":"НСИ!$G$6","v":0},null,null,{"$f":"R26","v":0},{"$f":"НСИ!$D$6","v":-10},{"$f":"НСИ!$E$6","v":0},{"$f":"НСИ!$F$6","v":0},{"$f":"НСИ!$G$6","v":0},null,null,{"$f":"Y26","v":0},{"$f":"НСИ!$D$6","v":-10},{"$f":"НСИ!$E$6","v":0},{"$f":"НСИ!$F$6","v":0},{"$f":"НСИ!$G$6","v":0},null,null,{"$f":"AF26","v":0},{"$f":"НСИ!$D$6","v":-10},{"$f":"НСИ!$E$6","v":0},{"$f":"НСИ!$F$6","v":0},{"$f":"НСИ!$G$6","v":0}]
[null,null,"C",0,{"$f":"НСИ!$D$7","v":0},{"$f":"НСИ!$E$7","v":0},{"$f":"НСИ!$F$7","v":0},{"$f":"НСИ!$G$7","v":0},null,null,0,{"$f":"НСИ!$D$7","v":0},{"$f":"НСИ!$E$7","v":0},{"$f":"НСИ!$F$7","v":0},{"$f":"НСИ!$G$7","v":0},null,null,0,{"$f":"НСИ!$D$7","v":0},{"$f":"НСИ!$E$7","v":0},{"$f":"НСИ!$F$7","v":0},{"$f":"НСИ!$G$7","v":0},null,null,0,{"$f":"НСИ!$D$7","v":0},{"$f":"НСИ!$E$7","v":0},{"$f":"НСИ!$F$7","v":0},{"$f":"НСИ!$G$7","v":0},null,null,0,{"$f":"НСИ!$D$7","v":0},{"$f":"НСИ!$E$7","v":0},{"$f":"НСИ!$F$7","v":0},{"$f":"НСИ!$G$7","v":0}]
[null,null,"D",0,{"$f":"НСИ!$D$8","v":0},{"$f":"НСИ!$E$8","v":-5},{"$f":"НСИ!$F$8","v":0},{"$f":"НСИ!$G$8","v":0},null,null,0,{"$f":"НСИ!$D$8","v":0},{"$f":"НСИ!$E$8","v":-5},{"$f":"НСИ!$F$8","v":0},{"$f":"НСИ!$G$8","v":0},null,null,0,{"$f":"НСИ!$D$8","v":0},{"$f":"НСИ!$E$8","v":-5},{"$f":"НСИ!$F$8","v":0},{"$f":"НСИ!$G$8","v":0},null,null,0,{"$f":"НСИ!$D$8","v":0},{"$f":"НСИ!$E$8","v":-5},{"$f":"НСИ!$F$8","v":0},{"$f":"НСИ!$G$8","v":0},null,null,0,{"$f":"НСИ!$D$8","v":0},{"$f":"НСИ!$E$8","v":-5},{"$f":"НСИ!$F$8","v":0},{"$f":"НСИ!$G$8","v":0}]
[null,null,"I"]
["Потери",null,null,null,{"$f":"SUMPRODUCT(E32:E35,--($D$25:$D$28=E14+1))","v":0},{"$f":"SUMPRODUCT(F32:F35,--($D$25:$D$28=F14+1))","v":0},-5,-20,0,null,null,{"$f":"SUMPRODUCT(L32:L35,--($D$25:$D$28=L14+1))","v":0},{"$f":"SUMPRODUCT(M32:M35,--($D$25:$D$28=M14+1))","v":0},-5,-20,0,null,null,{"$f":"SUMPRODUCT(S32:S35,--($D$25:$D$28=S14+1))","v":0},{"$f":"SUMPRODUCT(T32:T35,--($D$25:$D$28=T14+1))","v":0},-5,-20,0,null,null,{"$f":"SUMPRODUCT(Z32:Z35,--($D$25:$D$28=Z14+1))","v":0},{"$f":"SUMPRODUCT(AA32:AA35,--($D$25:$D$28=AA14+1))","v":0},-5,-20,0,null,null,{"$f":"SUMPRODUCT(AG32:AG35,--($D$25:$D$28=AG14+1))","v":0},{"$f":"SUMPRODUCT(AH32:AH35,--($D$25:$D$28=AH14+1))","v":0},-5,-20,0]
[]
["Минимальный остаток",null,null,null,{"$f":"НСИ!$D$14","v":50},{"$f":"НСИ!$E$14","v":30},{"$f":"НСИ!$F$14","v":100},{"$f":"НСИ!$G$14","v":75},null,{"$f":"SUM(E39:I39)","v":255},null,{"$f":"НСИ!$D$14","v":50},{"$f":"НСИ!$E$14","v":30},{"$f":"НСИ!$F$14","v":100},{"$f":"НСИ!$G$14","v":75},null,{"$f":"SUM(L39:P39)","v":255},null,{"$f":"НСИ!$D$14","v":50},{"$f":"НСИ!$E$14","v":30},{"$f":"НСИ!$F$14","v":100},{"$f":"НСИ!$G$14","v":75},null,{"$f":"SUM(S39:W39)","v":255},null,{"$f":"НСИ!$D$14","v":50},{"$f":"НСИ!$E$14","v":30},{"$f":"НСИ!$F$14","v":100},{"$f":"НСИ!$G$14","v":75},null,{"$f":"SUM(Z39:AD39)","v":255},null,{"$f":"НСИ!$D$14","v":50},{"$f":"НСИ!$E$14","v":30},{"$f":"НСИ!$F$14","v":100},{"$f":"НСИ!$G$14","v":75},null,{"$f":"SUM(AG39:AK39)","v":255}]
["Максимальный остаток",null,null,null,{"$f":"НСИ!$D$15","v":400},{"$f":"НСИ!$E$15","v":400},{"$f":"НСИ!$F$15","v":500},{"$f":"НСИ!$G$15","v":700},null,{"$f":"SUM(E40:I40)","v":2000},null,{"$f":"НСИ!$D$15","v":400},{"$f":"НСИ!$E$15","v":400},{"$f":"НСИ!$F$15","v":500},{"$f":"НСИ!$G$15","v":700},null,{"$f":"SUM(L40:P40)","v":2000},null,{"$f":"НСИ!$D$15","v":400},{"$f":"НСИ!$E$15","v":400},{"$f":"НСИ!$F$15","v":500},{"$f":"НСИ!$G$15","v":700},null,{"$f":"SUM(S40:W40)","v":2000},null,{"$f":"НСИ!$D$15","v":400},{"$f":"НСИ!$E$15","v":400},{"$f":"НСИ!$F$15","v":500},{"$f":"НСИ!$G$15","v":700},null,{"$f":"SUM(Z40:AD40)","v":2000},null,{"$f":"НСИ!$D$15","v":400},{"$f":"НСИ!$E$15","v":400},{"$f":"НСИ!$F$15","v":500},{"$f":"НСИ!$G$15","v":700},null,{"$f":"SUM(AG40:AK40)","v":2000}]

{"sheet":"НСИ","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"A","B","C","D"]
[null,"Потери","A",0,null,-5,-20]
[null,"Потери","B",-10,0]
[null,"Потери","C",null,null,0]
[null,"Потери","D",null,-5,null,0]
[null,"Время на переналадку","A",0,5,5,10]
[null,"Время на переналадку","B",5,0,8,12]
[null,"Время на переналадку","C",8,10,0,15]
[null,"Время на переналадку","D",10,8,5,0]
[null,"Производительность",null,12,12,8,9]
[null,"Минимальный остаток",null,50,30,100,75]
[null,"Максимальный остаток",null,400,400,500,700]
[null,"Цена продаж",null,9,12,15,7]
[null,"Себестоимость производства",null,6,6,10,6]
[null,"Себестоимость потерь",null,3,8,5,1]