{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Modelo"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Modelo","index":0,"n_rows":20,"n_cols":32,"rows_kept":20,"cut":false,"hidden":false,"merged":[[7,6,7,7],[7,8,7,9],[7,22,7,27],[1,1,2,2],[2,5,3,30],[1,5,1,30]]}
[]
[null,"FABRICACION DE TORNILLOS 6\" X 1/2 ACERO",null,null,null,"SIMULADOR INDUSTRIAL RESTRICCIONES"]
[null,null,null,null,null,"Una planta industrial de mecanizado tiene en su centro de manufactura las siguientes maquinas, a través de simulación determine la capacidad utilizada y restricción."]
[null,"Turno/horas:",null,1]
[null,"Seg/turno",null,{"$f":"(D4*60*60)*(100%-D37)","v":3600}]
[null,"Seg/Trascurridos:",null,132,null,"RESTRICCION →",null,{"$f":"MAX(F10:F19)","v":10.199999999999999},{"$f":"INDEX(B10:G19,MATCH(H6,F10:F19,0),2)","v":"Empaque"},null,null,{"$f":"D6","v":132},{"$f":"L6-($D$5/20)","v":-48},{"$f":"M6-($D$5/20)","v":-228},-408,-588,-768,-948,-1128,-1308,-1488,-1668,-1848,-2028,-2208,-2388,-2568,-2748,-2928,-3108,-3288,{"$f":"IFERROR(D6/D5,0)","v":3.6666666666666667E-2}]
[null,"% de ocupación",null,{"$f":"D6/D5","v":3.6666666666666667E-2}]
[null,null,null,null,null,null,"ENTRADA",null,"SALIDA",null,null,null,"Unidades Optimas",null,null,null,null,null,null,null,null,null,{"$f":"D5/MIN(F10:F19)","v":1285.7142857142858}]
[null,"N°","Maquina",null,null,"USP/seg","Tiempo","Unidades","Tiempo","Unidades","ID"]
[null,1,"Corte varilla",null,null,4.5,{"$f":"D5-I10","v":3468},{"$f":"G10/F10","v":770.66666666666663},{"$f":"$D$6","v":132},{"$f":"I10/F10","v":29.333333333333332},{"$f":"AF10","v":2.2814814814814812E-2},{"$f":"J10","v":29.333333333333332},{"$f":"L10-($W$8/20)","v":-34.952380952380963},{"$f":"M10-($W$8/20)","v":-99.238095238095255},-163.52380952380955,-227.80952380952385,-292.09523809523813,-356.38095238095241,-420.66666666666669,-484.95238095238096,-549.2380952380953,-613.52380952380963,-677.80952380952397,-742.0952380952383,-806.38095238095264,-870.66666666666697,-934.9523809523813,-999.23809523809564,-1063.5238095238099,-1127.8095238095241,-1192.0952380952383,{"$f":"J10/$W$8","v":2.2814814814814812E-2}]
[null,2,"Troquelado cabeza",null,null,2.8,{"$f":"H11*F11","v":0},{"$f":"J10-J11","v":0},{"$f":"$D$6","v":132},{"$f":"IF(J10>(I11/F11),(I11/F11),J10)","v":29.333333333333332},{"$f":"AF11","v":2.2814814814814812E-2},{"$f":"J11","v":29.333333333333332},{"$f":"L11-($W$8/20)","v":-34.952380952380963},-99.238095238095255,-163.52380952380955,-227.80952380952385,-292.09523809523813,-356.38095238095241,-420.66666666666669,-484.95238095238096,-549.2380952380953,-613.52380952380963,-677.80952380952397,-742.0952380952383,-806.38095238095264,-870.66666666666697,-934.9523809523813,-999.23809523809564,-1063.5238095238099,-1127.8095238095241,-1192.0952380952383,{"$f":"J11/$W$8","v":2.2814814814814812E-2}]
[null,3,"Roscado tornillo",null,null,6,{"$f":"H12*F12","v":43.999999999999993},{"$f":"J11-J12","v":7.3333333333333321},{"$f":"$D$6","v":132},{"$f":"IF(J11>(I12/F12),(I12/F12),J11)","v":22},1.7111111111111112E-2,22,{"$f":"L12-($W$8/20)","v":-42.285714285714292},-106.57142857142858,-170.85714285714289,-235.14285714285717,-299.42857142857144,-363.71428571428572,-428,-492.28571428571428,-556.57142857142856,-620.85714285714289,-685.14285714285722,-749.42857142857156,-813.71428571428589,-878.00000000000023,-942.28571428571456,-1006.5714285714289,-1070.8571428571431,-1135.1428571428573,-1199.4285714285716,1.7111111111111112E-2]
[null,4,"Pulido",null,null,7.5,{"$f":"H13*F13","v":32.999999999999986},{"$f":"J12-J13","v":4.3999999999999986},{"$f":"$D$6","v":132},{"$f":"IF(J12>(I13/F13),(I13/F13),J12)","v":17.600000000000001},1.3688888888888889E-2,17.600000000000001,{"$f":"L13-($W$8/20)","v":-46.68571428571429},-110.97142857142859,-175.25714285714287,-239.54285714285714,-303.82857142857142,-368.1142857142857,-432.4,-496.68571428571425,-560.97142857142853,-625.25714285714287,-689.5428571428572,-753.82857142857154,-818.11428571428587,-882.4000000000002,-946.68571428571454,-1010.9714285714289,-1075.2571428571432,-1139.5428571428574,-1203.8285714285716,1.3688888888888889E-2]
[null,5,"Empaque",null,null,10.199999999999999,{"$f":"H14*F14","v":47.52000000000001},{"$f":"J13-J14","v":4.6588235294117659},{"$f":"$D$6","v":132},{"$f":"IF(J13>(I14/F14),(I14/F14),J13)","v":12.941176470588236},1.0065359477124183E-2,12.941176470588236,{"$f":"L14-($W$8/20)","v":-51.34453781512606},-115.63025210084035,-179.91596638655466,-244.20168067226894,-308.48739495798321,-372.77310924369749,-437.05882352941177,-501.34453781512605,-565.63025210084038,-629.91596638655471,-694.20168067226905,-758.48739495798338,-822.77310924369772,-887.05882352941205,-951.34453781512639,-1015.6302521008407,-1079.9159663865551,-1144.2016806722693,-1208.4873949579835,1.0065359477124183E-2]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F10:F19)","v":31},null,{"$f":"SUM(H10:H19)","v":787.05882352941171}]