{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,15,4,15],[2,13,2,14],[1,2,1,15],[29,2,30,2],[31,2,32,2],[31,4,32,4],[31,3,32,3],[31,13,32,13],[31,12,32,12],[31,11,32,11],[31,10,32,10],[31,9,32,9],[31,8,32,8],[31,7,32,7],[31,6,32,6],[31,5,32,5],[6,2,6,13],[7,2,8,2],[9,2,10,2],[11,2,12,2],[23,2,24,2],[25,2,26,2],[27,2,28,2],[13,2,14,2],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2]]}
[]
[320,null,"ЗАДАНИЕ"]
[340,null,"№",1,2,3,4,5,6,7,8,9,10,"формат",null,"вес 1 мм"]
[350,null,"форматы, мм",510,600,840,1350,1160,null,null,null,null,null,"мин","макс",0.58799999999999997]
[370,null,"вес, кг",2000,4000,6000,2500,2500,null,null,null,null,null,2400,2550]
[380]
[400,null,"РЕШЕНИЕ"]
[420,null,"формат №1, шт/кг",1,1,null,1,null,null,null,null,null,null,{"$f":"$D$4*D8+$E$4*E8+$F$4*F8+$G$4*G8+$H$4*H8+$I$4*I8+$J$4*J8+$K$4*K8+$L$4*L8+$M$4*M8","v":2460}]
[440,null,null,{"$f":"D$4*$P$4*D8","v":299.88},{"$f":"E$4*$P$4*E8","v":352.79999999999995},0,793.8,0,{"$f":"I$4*$P$4*I8","v":0},0,0,0,0]
[450,null,"формат №2, шт/кг",1,1,null,1,null,null,null,null,null,null,{"$f":"$D$4*D10+$E$4*E10+$F$4*F10+$G$4*G10+$H$4*H10+$I$4*I10+$J$4*J10+$K$4*K10+$L$4*L10+$M$4*M10","v":2460}]
[470,null,null,{"$f":"D$4*$P$4*D10","v":299.88},{"$f":"E$4*$P$4*E10","v":352.79999999999995},{"$f":"F$4*$P$4*F10","v":0},{"$f":"G$4*$P$4*G10","v":793.8},{"$f":"H$4*$P$4*H10","v":0},{"$f":"I$4*$P$4*I10","v":0},{"$f":"J$4*$P$4*J10","v":0},{"$f":"K$4*$P$4*K10","v":0},{"$f":"L$4*$P$4*L10","v":0},{"$f":"M$4*$P$4*M10","v":0}]
[500,null,"формат №3, шт/кг",null,null,null,1,1,null,null,null,null,null,{"$f":"$D$4*D12+$E$4*E12+$F$4*F12+$G$4*G12+$H$4*H12+$I$4*I12+$J$4*J12+$K$4*K12+$L$4*L12+$M$4*M12","v":2510}]
[510,null,null,0,0,0,793.8,682.07999999999993,0,0,0,0,0]
[520,null,"формат №4, шт/кг",1,null,1,null,1,null,null,null,null,null,{"$f":"$D$4*D14+$E$4*E14+$F$4*F14+$G$4*G14+$H$4*H14+$I$4*I14+$J$4*J14+$K$4*K14+$L$4*L14+$M$4*M14","v":2510}]
[580,null,null,299.88,0,493.91999999999996,0,682.07999999999993,0,0,0,0,0]
[600,null,"формат №5, шт/кг",1,2,1,null,null,null,null,null,null,null,{"$f":"$D$4*D16+$E$4*E16+$F$4*F16+$G$4*G16+$H$4*H16+$I$4*I16+$J$4*J16+$K$4*K16+$L$4*L16+$M$4*M16","v":2550}]
[610,null,null,299.88,705.59999999999991,493.91999999999996,0,0,0,0,0,0,0]
[620,null,"формат №6, шт/кг",1,null,1,null,1,null,null,null,null,null,{"$f":"$D$4*D18+$E$4*E18+$F$4*F18+$G$4*G18+$H$4*H18+$I$4*I18+$J$4*J18+$K$4*K18+$L$4*L18+$M$4*M18","v":2510}]
[640,null,null,299.88,0,493.91999999999996,0,682.07999999999993,0,0,0,0,0]
[680,null,"формат №7, шт/кг",1,2,1,null,null,null,null,null,null,null,{"$f":"$D$4*D20+$E$4*E20+$F$4*F20+$G$4*G20+$H$4*H20+$I$4*I20+$J$4*J20+$K$4*K20+$L$4*L20+$M$4*M20","v":2550}]
[720,null,null,299.88,705.59999999999991,493.91999999999996,0,0,0,0,0,0,0]
[760,null,"формат №8, шт/кг",1,2,1,null,null,null,null,null,null,null,{"$f":"$D$4*D22+$E$4*E22+$F$4*F22+$G$4*G22+$H$4*H22+$I$4*I22+$J$4*J22+$K$4*K22+$L$4*L22+$M$4*M22","v":2550}]
[810,null,null,299.88,705.59999999999991,493.91999999999996,0,0,0,0,0,0,0]
[820,null,"формат №9, шт/кг",null,null,3,null,null,null,null,null,null,null,{"$f":"$D$4*D24+$E$4*E24+$F$4*F24+$G$4*G24+$H$4*H24+$I$4*I24+$J$4*J24+$K$4*K24+$L$4*L24+$M$4*M24","v":2520}]
[835,null,null,0,0,1481.7599999999998,0,0,0,0,0,0,0]
[840,null,"формат №10, шт/кг",1,null,1,null,1,null,null,null,null,null,{"$f":"$D$4*D26+$E$4*E26+$F$4*F26+$G$4*G26+$H$4*H26+$I$4*I26+$J$4*J26+$K$4*K26+$L$4*L26+$M$4*M26","v":2510}]
[845,null,null,299.88,0,493.91999999999996,0,682.07999999999993,0,0,0,0,0]
[900,null,"формат №11, шт/кг",null,null,3,null,null,null,null,null,null,null,{"$f":"$D$4*D28+$E$4*E28+$F$4*F28+$G$4*G28+$H$4*H28+$I$4*I28+$J$4*J28+$K$4*K28+$L$4*L28+$M$4*M28","v":2520}]
[960,null,null,0,0,1481.7599999999998,0,0,0,0,0,0,0]
[1060,null,"формат №12, шт/кг",null,4,null,null,null,null,null,null,null,null,{"$f":"$D$4*D30+$E$4*E30+$F$4*F30+$G$4*G30+$H$4*H30+$I$4*I30+$J$4*J30+$K$4*K30+$L$4*L30+$M$4*M30","v":2400}]
[1160,null,null,0,1411.1999999999998,0,0,0,0,0,0,0,0]
[1200,null,"всего, кг",{"$f":"SUM(D9+D11+D13+D15+D17+D19+D21+D23+D25+D27+D29+D31)","v":2399.0400000000004},{"$f":"SUM(E9+E11+E13+E15+E17+E19+E21+E23+E25+E27+E29+E31)","v":4233.5999999999995},5927.0399999999991,2381.3999999999996,2728.3199999999997,0,0,0,0,0,{"$f":"SUM(D32:M33)","v":17669.399999999998}]
[1350]
[1400]
[null,null,"Необходимо расчитать оптимальный ширины формат (от 2400 мм до 2550 мм) с учётом заданного веса."]
[null,null,"Всё как в таблице \"Решение\", только формулами или с помощью VBA."]