{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Informe de respuestas 1","Informe de sensibilidad 1","Informe de límites 1","Hoja1","Hoja2","Hoja3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":89,"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":"Informe de respuestas 1","index":0,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 12.0 Informe de respuestas"]
["Hoja de cálculo: [SOLVER.xlsm]Hoja1"]
["Informe creado: 06/05/2012 07:04:19 a.m."]
[]
[]
["Celda objetivo (Máximo)"]
[null,"Celda","Nombre","Valor original","Valor final"]
[null,"$A$2","UTILIDAD GLOBAL",null,50499.999999958061]
[]
[]
["Celdas cambiantes"]
[null,"Celda","Nombre","Valor original","Valor final"]
[null,"$B$5","PRODUCCION E",6,4.4999999999822897]
[null,"$C$5","PRODUCCION F",2,7.0000000000116547]
[]
[]
["Restricciones"]
[null,"Celda","Nombre","Valor de la celda","Fórmula","Estado","Divergencia"]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,"$D$7<=$F$7","Obligatorio",0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,"$D$8<=$F$8","Obligatorio",0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,"$D$9>=$F$9","Opcional",69.999999999585214]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,"$D$10<=$F$10","Opcional",16.500000000052676]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,"$D$11>=$F$11","Opcional",6.4999999999939444]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,"$D$7<=$F$7","Obligatorio",0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,"$D$8<=$F$8","Obligatorio",0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,"$D$9>=$F$9","Opcional",69.999999999585214]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,"$D$10<=$F$10","Opcional",16.500000000052676]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,"$D$11>=$F$11","Opcional",6.4999999999939444]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,"$D$7<=$F$7","Obligatorio",0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,"$D$8<=$F$8","Obligatorio",0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,"$D$9>=$F$9","Opcional",69.999999999585214]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,"$D$10<=$F$10","Opcional",16.500000000052676]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,"$D$11>=$F$11","Opcional",6.4999999999939444]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,"$D$7<=$F$7","Obligatorio",0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,"$D$8<=$F$8","Obligatorio",0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,"$D$9>=$F$9","Opcional",69.999999999585214]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,"$D$10<=$F$10","Opcional",16.500000000052676]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,"$D$11>=$F$11","Opcional",6.4999999999939444]
[null,"$B$5","PRODUCCION E",4.4999999999822897,"$B$5>=0","Opcional",4.4999999999822897]
[null,"$C$5","PRODUCCION F",7.0000000000116547,"$C$5>=0","Opcional",7.0000000000116547]
[null,"$B$5","PRODUCCION E",4.4999999999822897,"$B$5>=0","Opcional",4.4999999999822897]
[null,"$C$5","PRODUCCION F",7.0000000000116547,"$C$5>=0","Opcional",7.0000000000116547]
[null,"$B$5","PRODUCCION E",4.4999999999822897,"$B$5>=0","Opcional",4.4999999999822897]
[null,"$C$5","PRODUCCION F",7.0000000000116547,"$C$5>=0","Opcional",7.0000000000116547]
[null,"$B$5","PRODUCCION E",4.4999999999822897,"$B$5>=0","Opcional",4.4999999999822897]
[null,"$C$5","PRODUCCION F",7.0000000000116547,"$C$5>=0","Opcional",7.0000000000116547]

{"sheet":"Informe de sensibilidad 1","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 12.0 Informe de sensibilidad"]
["Hoja de cálculo: [SOLVER.xlsm]Hoja1"]
["Informe creado: 06/05/2012 07:04:20 a.m."]
[]
[]
["Celdas cambiantes"]
[null,null,null,"Valor","Gradiente"]
[null,"Celda","Nombre","Igual","reducido"]
[null,"$B$5","PRODUCCION E",4.4999999999822897,0]
[null,"$C$5","PRODUCCION F",7.0000000000116547,0]
[]
["Restricciones"]
[null,null,null,"Valor","Multiplicador"]
[null,"Celda","Nombre","Igual","de Lagrange"]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,0]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,0]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,0]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,0]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,0]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,0]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,0]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,0]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,0]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,0]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,0]
[null,"$D$7","DEPARTAMENTO A: VALOR",149.99999999999773,150.00000000062013]
[null,"$D$8","DEPARTAMENTO B: VALOR",159.99999999976234,174.99999999968045]
[null,"$D$9","VERIFICACION: VALOR",204.99999999958521,0]
[null,"$D$10","UNA F CADA 3E: VALOR",-16.500000000052676,0]
[null,"$D$11","AL MENOS 5: VALOR",11.499999999993944,0]

{"sheet":"Informe de límites 1","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 12.0 Informe de límites"]
["Hoja de cálculo: [SOLVER.xlsm]Informe de límites 1"]
["Informe creado: 06/05/2012 07:04:20 a.m."]
[]
[]
[null,null,"Celda objetivo"]
[null,"Celda","Nombre","Igual"]
[null,"$A$2","UTILIDAD GLOBAL",50499.999999958061]
[]
[]
[null,null,"Celdas cambiantes",null,null,"Límite","Celda",null,"Límite","Celda"]
[null,"Celda","Nombre","Igual",null,"inferior","objetivo",null,"superior","objetivo"]
[null,"$B$5","PRODUCCION E",4.4999999999822897,null,2.1666666666659138,38833.333333376184,null,4.4999999999807674,50499.999999950451]
[null,"$C$5","PRODUCCION F",7.0000000000116547,null,1.4999999999907292,28499.999999874366,null,7.000000000027276,50500.000000020547]

{"sheet":"Hoja1","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,1,5,2]]}
["UTILIDAD GLOBAL"]
[{"$f":"B4*B5+C4*C5","v":50499.999999958061}]
["PRODUCTOS ","E","F"]
["UTILIDAD MARGINAL",5000,4000]
["PRODUCCION",4.4999999999822897,7.0000000000116547]
[null,"RESTRICCIONES ",null,"VALOR",null,"LIMITE "]
["DEPARTAMENTO A:",10,15,{"$f":"SUMPRODUCT($B$5:$C$5,B7:C7)","v":149.99999999999773},"<=",150]
["DEPARTAMENTO B:",20,10,{"$f":"SUMPRODUCT($B$5:$C$5,B8:C8)","v":159.99999999976234},"<=",160]
["VERIFICACION:",30,10,204.99999999958521,">=",135]
["UNA F CADA 3E:",1,-3,-16.500000000052676,"<=",0]
["AL MENOS 5:",1,1,11.499999999993944,">=",5]

{"sheet":"Hoja2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hoja3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}