{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Лист1","index":0,"n_rows":77,"n_cols":27,"rows_kept":77,"cut":false,"hidden":false,"merged":[[6,0,6,4],[6,10,6,18],[6,5,6,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Расход труб, шт.",{"$f":"SUBTOTAL(9,E9:E830)/12050","v":57.008298755186722},12050,{"$f":"N2*N3*M2","v":274780},"в пересчете на кг"]
[null,null,null,null,null,null,null,null,"Формулы до 999 стороки",null,null,"Использ.",{"$f":"((SUBTOTAL(9,M9:M830)+SUBTOTAL(9,O9:O830)+SUBTOTAL(9,Q9:Q830)+SUBTOTAL(9,S9:S830)+SUBTOTAL(9,G9:G830)))/(SUBTOTAL(9,E9:E830))","v":0.94837033262974013},0.4,{"$f":"O2*M3","v":260593.19999999998}]
[null,null,null,null,null,null,null,null,null,null,null,"Отход.",{"$f":"((SUBTOTAL(9,J9:J830))/(SUBTOTAL(9,E9:E830)))","v":5.1629667370259848E-2},null,{"$f":"O2*M4","v":14186.800000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"Невозвр. отх.",{"$f":"((SUBTOTAL(9,G9:G830))/(SUBTOTAL(9,E9:E830)))","v":7.0310794089817308E-4},null,{"$f":"O2*M5","v":193.2}]
[]
["Входной контроль",null,null,null,null,"Вычисляемые параметры",null,null,null,null,"Раскрой"]
["Завод","Входн.№ ПСК","Зав. №","Серт. №","Длина трубы, мм","Невозв. отх., % (вход. в исп.)","Рез, мм","Исп., %","Остаток, %","Остаток, мм","Номер раскроя","Сегмент #1","Длина сегмента, мм","Сегмент #2","Длина сегмента, мм","Сегмент #3","Длина сегмента, мм","Сегмент #4","Длина сегмента, мм",null,"Сегмент","Длина сегмента, мм","Номер раскроя","Завод","Входн.№ ПСК","Зав. №","Серт. №"]
["ЗМЗ",501,435,601,12150,{"$f":"G9/E9","v":1.1522633744855968E-3},{"$f":"(COUNTA(L9,N9,P9,R9)*7)","v":14},{"$f":"(M9+G9+O9+Q9+S9)/E9","v":0.98880658436213997},{"$f":"J9/E9","v":1.1193415637860082E-2},{"$f":"(E9-G9)-M9-O9-Q9-S9","v":136},1,"СД2.ВС: С-17.1-1",7500,"СД2.ВС: С-1.21-1",4500,null,null,null,null,null,"СД2.ВС: С-17.1-1",7500,1,"ЗМЗ",501,435,601]
["ЗМЗ",502,436,602,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,2,"СД2.ВС: С-17.1-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.21-1",4500,1,"ЗМЗ",501,435,601]
["ЗМЗ",503,437,603,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,3,"СД2.ВС: С-17.1-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-17.1-2",12000,2,"ЗМЗ",502,436,602]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,4,"СД2.ВС: С-1.1-1",4500,"СД2.ВС: С-1.2-1",7500,null,null,null,null,null,"СД2.ВС: С-17.1-3",9000,3,"ЗМЗ",503,437,603]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,5,"СД2.ВС: С-1.1-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.1-1",4500,4]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,6,"СД2.ВС: С-1.1-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.2-1",7500,4]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,7,"СД2.ВС: С-1.2-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.1-2",12000,5]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,8,"СД2.ВС: С-1.2-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.1-3",12000,6]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,9,"СД2.ВС: С-1.3-1",4500,"СД2.ВС: С-1.4-1",7500,null,null,null,null,null,"СД2.ВС: С-1.2-2",12000,7]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,10,"СД2.ВС: С-1.3-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.2-3",9000,8]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,11,"СД2.ВС: С-1.3-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.3-1",4500,9]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,12,"СД2.ВС: С-1.4-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.4-1",7500,9]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,13,"СД2.ВС: С-1.4-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.3-2",12000,10]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,14,"СД2.ВС: С-1.5-1",4500,"СД2.ВС: С-1.6-1",7500,null,null,null,null,null,"СД2.ВС: С-1.3-3",12000,11]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,15,"СД2.ВС: С-1.5-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.4-2",12000,12]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,16,"СД2.ВС: С-1.5-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.4-3",9000,13]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,17,"СД2.ВС: С-1.6-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.5-1",4500,14]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,18,"СД2.ВС: С-1.6-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.6-1",7500,14]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,19,"СД2.ВС: С-1.7-1",4500,"СД2.ВС: С-1.8-1",7500,null,null,null,null,null,"СД2.ВС: С-1.5-2",12000,15]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,20,"СД2.ВС: С-1.7-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.5-3",12000,16]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,21,"СД2.ВС: С-1.7-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.6-2",12000,17]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,22,"СД2.ВС: С-1.8-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.6-3",9000,18]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,23,"СД2.ВС: С-1.8-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.7-1",4500,19]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,24,"СД2.ВС: С-1.9-1",4500,"СД2.ВС: С-1.10-1",7500,null,null,null,null,null,"СД2.ВС: С-1.8-1",7500,19]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,25,"СД2.ВС: С-1.9-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.7-2",12000,20]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,26,"СД2.ВС: С-1.9-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.7-3",12000,21]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,27,"СД2.ВС: С-1.10-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.8-2",12000,22]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,28,"СД2.ВС: С-1.10-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.8-3",9000,23]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,29,"СД2.ВС: С-1.11-1",4500,"СД2.ВС: С-1.12-1",7500,null,null,null,null,null,"СД2.ВС: С-1.9-1",4500,24]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,30,"СД2.ВС: С-1.11-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.10-1",7500,24]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,31,"СД2.ВС: С-1.11-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.9-2",12000,25]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,32,"СД2.ВС: С-1.12-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.9-3",12000,26]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,33,"СД2.ВС: С-1.12-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.10-2",12000,27]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,34,"СД2.ВС: С-1.13-1",4500,"СД2.ВС: С-1.14-1",7500,null,null,null,null,null,"СД2.ВС: С-1.10-3",9000,28]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,35,"СД2.ВС: С-1.13-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.11-1",4500,29]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,36,"СД2.ВС: С-1.13-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.12-1",7500,29]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,37,"СД2.ВС: С-1.14-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.11-2",12000,30]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,38,"СД2.ВС: С-1.14-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.11-3",12000,31]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,39,"СД2.ВС: С-1.15-1",4500,"СД2.ВС: С-1.16-1",7500,null,null,null,null,null,"СД2.ВС: С-1.12-2",12000,32]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,40,"СД2.ВС: С-1.15-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.12-3",9000,33]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,41,"СД2.ВС: С-1.15-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.13-1",4500,34]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,42,"СД2.ВС: С-1.16-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.14-1",7500,34]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,43,"СД2.ВС: С-1.16-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.13-2",12000,35]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,44,"СД2.ВС: С-1.17-1",4500,"СД2.ВС: С-1.18-1",7500,null,null,null,null,null,"СД2.ВС: С-1.13-3",12000,36]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,45,"СД2.ВС: С-1.17-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.14-2",12000,37]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,46,"СД2.ВС: С-1.17-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.14-3",9000,38]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,47,"СД2.ВС: С-1.18-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.15-1",4500,39]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,48,"СД2.ВС: С-1.18-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.16-1",7500,39]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,49,"СД2.ВС: С-1.19-1",4500,"СД2.ВС: С-1.20-1",7500,null,null,null,null,null,"СД2.ВС: С-1.15-2",12000,40]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,50,"СД2.ВС: С-1.19-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.15-3",12000,41]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,51,"СД2.ВС: С-1.19-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.16-2",12000,42]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,52,"СД2.ВС: С-1.20-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.16-3",9000,43]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.74746887966804976,0.25253112033195019,3043,53,"СД2.ВС: С-1.20-3",9000,null,null,null,null,null,null,null,"СД2.ВС: С-1.17-1",4500,44]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,54,"СД2.ВС: С-1.21-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.18-1",7500,44]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,55,"СД2.ВС: С-1.21-3",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.17-2",12000,45]
[null,null,null,null,12050,1.1618257261410789E-3,14,0.99701244813278012,2.9875518672199172E-3,36,56,"СД2.ВС: С-2.1-1",4500,"СД2.ВС: С-2.2-1",7500,null,null,null,null,null,"СД2.ВС: С-1.17-3",12000,46]
[null,null,null,null,12050,5.8091286307053946E-4,7,0.99643153526970951,3.5684647302904565E-3,43,57,"СД2.ВС: С-2.1-2",12000,null,null,null,null,null,null,null,"СД2.ВС: С-1.18-2",12000,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.18-3",9000,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.19-1",4500,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.20-1",7500,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.19-2",12000,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.19-3",12000,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.20-2",12000,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.20-3",9000,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.21-2",12000,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-1.21-3",12000,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-2.1-1",4500,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-2.2-1",7500,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СД2.ВС: С-2.1-2",12000,57]

{"sheet":"Лист2","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Сегмент ","Длина сегмента, мм","Номер раскроя","Завод","Входн.№ ПСК","Зав. №","Серт. №"]
["СД2.ВС: С-17.1-1",7500,1,"ЗМЗ",501,435,601]
["СД2.ВС: С-1.21-1",4500,1,"ЗМЗ",501,435,601]
["СД2.ВС: С-17.1-2",12000,2,"ЗМЗ",502,436,602]
["СД2.ВС: С-17.1-3",9000,3,"ЗМЗ",503,437,603]