{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Inicio RP","Básico RP","Complejo RP","Impuestos RP","Oculto RP"],"not_rendered":{"charts":3,"images":8,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Inicio RP","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[22,0,22,2],[31,10,31,11]]}
{"$rows_empty":22}
["    Descargue la versión Kindle"]
{"$rows_empty":8}
[{"$nulls":10},"Miguel Cervantes Jiménez"]

{"sheet":"Básico RP","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[17,1,17,3],[18,1,18,3],[21,1,21,2],[22,1,22,2]]}
["RESTRICCIÓN"]
["PRESUPUESTAL"]
[null,"RECTA PRESUPUESTAL"]
[null,"m","p1","x1","p2","x2"]
[null,{"v":100,"d":"100.0"},{"v":2,"d":"2.0"},{"$f":"'Oculto RP'!D27","v":{"v":20,"d":"20.0"}},{"v":1,"d":"1.0"},{"$f":"'Oculto RP'!F27","v":{"v":60,"d":"60.0"}}]
[null,null,"Inserte los datos correspondientes"]
[]
[null,"PARÁMETROS DE LA RECTA PRESUPUESTAL"]
[]
[]
[]
[null,"x2","b0","-B1","x1"]
[null,{"$f":"'Oculto RP'!B30","v":{"v":60,"d":"60.0"}},{"$f":"'Oculto RP'!C30","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!D30","v":{"v":-2,"d":"-2.0"}},{"v":20,"d":"20.0"}]
[null,null,"Inserte los datos correspondientes"]
[]
[]
[]
[null,"Máxima cantidad de x1",null,null,{"$f":"'Oculto RP'!D32","v":{"v":50,"d":"50.0"}}]
[null,"Máxima cantidad de x2",null,null,{"$f":"'Oculto RP'!D33","v":{"v":100,"d":"100.0"}}]
[null,"Precio Relativo (<0)",null,null,{"$f":"'Oculto RP'!D34","v":{"v":-2,"d":"-2.0"}}]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]

{"sheet":"Complejo RP","index":2,"n_rows":27,"n_cols":6,"rows_kept":27,"hidden":true,"merged":[[0,0,0,5],[9,1,9,2],[10,1,10,2],[11,1,11,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[24,1,24,2],[25,1,25,2],[26,1,26,2]]}
["RESTRICCIÓN PRESUPUESTAL"]
[]
[null,"RECTA PRESUPUESTAL"]
[null,"m","p1","x1","p2","x2"]
[null,{"v":100,"d":"100.0"},{"v":2,"d":"2.0"},{"$f":"'Oculto RP'!M27","v":{"v":25,"d":"25.0"}},{"v":1,"d":"1.0"},{"$f":"'Oculto RP'!O27","v":{"v":50,"d":"50.0"}}]
[null,"Inserte los datos correspondientes"]
[null,"x2","b0","b1","x1"]
[null,{"$f":"'Oculto RP'!K30","v":{"v":50,"d":"50.0"}},{"$f":"'Oculto RP'!L30","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!M30","v":{"v":-2,"d":"-2.0"}},{"v":25,"d":"25.0"}]
[{"$nulls":4},"Cambie la cantidad de x1"]
[null,"Máxima cantidad de x1",null,{"$f":"'Oculto RP'!M32","v":{"v":50,"d":"50.0"}}]
[null,"Máxima cantidad de x2",null,{"$f":"'Oculto RP'!M33","v":{"v":100,"d":"100.0"}}]
[null,"Precio Relativo (<0)",null,{"$f":"'Oculto RP'!M34","v":{"v":-2,"d":"-2.0"}}]
[]
[null,"NUEVA RECTA PRESUPUESTAL"]
[null,"m","p1","x1","p2","x2"]
[null,{"$f":"B5","v":{"v":100,"d":"100.0"}},{"$f":"C5","v":{"v":2,"d":"2.0"}},{"$f":"'Oculto RP'!M38","v":{"v":25,"d":"25.0"}},{"$f":"'Oculto RP'!N38","v":{"v":1,"d":"1.0"}},{"$f":"'Oculto RP'!O38","v":{"v":50,"d":"50.0"}}]
[null,"Inserte los datos correspondientes"]
[null,"x2","b0","b1","x1"]
[null,{"$f":"'Oculto RP'!K41","v":{"v":50,"d":"50.0"}},{"$f":"'Oculto RP'!L41","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!M41","v":{"v":-2,"d":"-2.0"}},{"$f":"'Oculto RP'!N41","v":{"v":25,"d":"25.0"}}]
[]
[null,"Máxima cantidad de x1",null,{"$f":"'Oculto RP'!M43","v":{"v":50,"d":"50.0"}}]
[null,"Máxima cantidad de x2",null,{"$f":"'Oculto RP'!M44","v":{"v":100,"d":"100.0"}}]
[null,"Precio Relativo (<0)",null,{"$f":"'Oculto RP'!M45","v":{"v":-2,"d":"-2.0"}}]
[]
[null,"Títulos"]
[null,"Resultados"]
[null,"Insertar datos"]

{"sheet":"Impuestos RP","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"hidden":true,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"RESTRICCIÓN PRESUPUESTAL"]
[null,"RECTA PRESUPUESTAL INICIAL"]
[null,"m","p1","x1","p2","x2"]
[null,{"v":100,"d":"100.0"},{"v":2,"d":"2.0"},{"$f":"'Oculto RP'!AD29","v":{"v":30,"d":"30.0"}},{"v":1,"d":"1.0"},{"$f":"'Oculto RP'!AF29","v":{"v":40,"d":"40.0"}}]
[null,"Inserte los datos correspondientes"]
[null,"x2","b0","-b1","x1"]
[null,{"$f":"'Oculto RP'!AB32","v":{"v":40,"d":"40.0"}},{"$f":"'Oculto RP'!AC32","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!AD32","v":{"v":-2,"d":"-2.0"}},{"v":30,"d":"30.0"}]
[{"$nulls":4},"Cambie la cantidad de x1"]
[null,"Máxima cantidad de x1",null,{"$f":"'Oculto RP'!AD34","v":{"v":50,"d":"50.0"}}]
[null,"Máxima cantidad de x2",null,{"$f":"'Oculto RP'!AD35","v":{"v":100,"d":"100.0"}}]
[null,"Precio Relativo (<0)",null,{"$f":"'Oculto RP'!AD36","v":{"v":-2,"d":"-2.0"}}]
[]
[null,"NUEVA RESTRICCIÓN CON IMPUESTOS"]
[null,"m","p1","x1","p2","x2"]
[null,{"$f":"'Oculto RP'!AB40","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!AC40","v":{"v":2,"d":"2.0"}},{"$f":"'Oculto RP'!AD40","v":{"v":30,"d":"30.0"}},{"$f":"'Oculto RP'!AE40","v":{"v":1,"d":"1.0"}},{"$f":"'Oculto RP'!AF40","v":{"v":40,"d":"40.0"}}]
[null,"Inserte los datos correspondientes"]
[null,"x2","b0","-b1","x1"]
[null,{"$f":"'Oculto RP'!AB43","v":{"v":40,"d":"40.0"}},{"$f":"'Oculto RP'!AC43","v":{"v":100,"d":"100.0"}},{"$f":"'Oculto RP'!AD43","v":{"v":-2,"d":"-2.0"}},{"$f":"'Oculto RP'!AE43","v":{"v":30,"d":"30.0"}}]
[]
[null,"Máxima cantidad de x1",null,{"$f":"'Oculto RP'!AD45","v":{"v":50,"d":"50.0"}}]
[null,"Máxima cantidad de x2",null,{"$f":"'Oculto RP'!AD46","v":{"v":100,"d":"100.0"}}]
[null,"Precio relativo (<0)",null,{"$f":"'Oculto RP'!AD47","v":{"v":-2,"d":"-2.0"}}]
[]
[null,"Impuesto al ingreso",null,{"v":0,"d":"0.0"}]
[null,"Impuesto al precio",null,{"v":0,"d":"0.0"}]
[{"$nulls":3},"Inserte al valor en tanto por uno (5%=0.05)"]
[{"$nulls":3},"Inserte unitario en pesos"]
[{"$nulls":3},"(Para subsidio el signo será negativo)"]

{"sheet":"Oculto RP","index":4,"n_rows":50,"n_cols":34,"rows_kept":50,"hidden":true,"merged":[[25,27,25,31],[26,27,26,31],[31,1,31,2],[31,10,31,11],[32,1,32,2],[32,10,32,11],[33,1,33,2],[33,10,33,11],[42,10,42,11],[43,10,43,11],[44,10,44,11]]}
["BÁSICO",{"$nulls":8},"COMPLEJO",{"$nulls":12},"IMPUESTOS"]
["Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"x1","x2","x2lin",null,null,"Unidades","ponderador","x1","x2","x1lin",null,"x2lin",null,"x1","x2","x2lin"]
[1,0,{"$f":"$D$32*B3","v":0},{"$f":"$C$30+($D$30*C3)","v":{"v":100,"d":"100.00"}},{"$f":"$D$27","v":{"v":20,"d":"20.0"}},{"$f":"B3*$F$27","v":0},{"$f":"$D$27*B3","v":0},{"$f":"$F$27","v":{"v":60,"d":"60.0"}},null,1,0,{"$f":"K3*$M$32","v":0},{"$f":"$L$30+($M$30*L3)","v":{"v":100,"d":"100.00"}},{"$f":"$M$27","v":{"v":25,"d":"25.0"}},{"$f":"K3*$O$27","v":0},{"$f":"K3*$M$27","v":0},{"$f":"$O$27","v":{"v":50,"d":"50.0"}},{"$f":"K3*$M$43","v":0},{"$f":"$L$41+($M$41*R3)","v":{"v":100,"d":"100.00"}},{"$f":"K3*$N$41","v":0},{"$f":"$K$41","v":{"v":50,"d":"50.00"}},null,1,0,{"$f":"X3*$AD$34","v":0},{"$f":"$AC$32+($AD$32*Y3)","v":{"v":100,"d":"100.00"}},{"$f":"$AD$29","v":{"v":30,"d":"30.0"}},{"$f":"MAX($AF$29,$AF$40)*X3","v":0},{"$f":"X3*$AD$29","v":0},{"$f":"$AF$29","v":{"v":40,"d":"40.0"}},{"$f":"$AD$45*X3","v":0},{"$f":"$AC$43+($AD$43*AE3)","v":{"v":100,"d":"100.00"}},{"$f":"$AE$43*X3","v":0},{"$f":"$AB$43","v":{"v":40,"d":"40.00"}}]
[2,0.05,{"$f":"$D$32*B4","v":{"v":2.5,"d":"2.50"}},{"$f":"$C$30+($D$30*C4)","v":{"v":95,"d":"95.00"}},{"$f":"$D$27","v":{"v":20,"d":"20.0"}},{"$f":"B4*$F$27","v":{"v":3,"d":"3.00"}},{"$f":"$D$27*B4","v":{"v":1,"d":"1.00"}},{"$f":"$F$27","v":{"v":60,"d":"60.0"}},null,2,0.05,{"$f":"K4*$M$32","v":{"v":2.5,"d":"2.50"}},{"$f":"$L$30+($M$30*L4)","v":{"v":95,"d":"95.00"}},{"$f":"$M$27","v":{"v":25,"d":"25.0"}},{"$f":"K4*$O$27","v":{"v":2.5,"d":"2.50"}},{"$f":"K4*$M$27","v":1.25},{"$f":"$O$27","v":{"v":50,"d":"50.0"}},{"$f":"K4*$M$43","v":{"v":2.5,"d":"2.50"}},{"$f":"$L$41+($M$41*R4)","v":{"v":95,"d":"95.00"}},{"$f":"K4*$N$41","v":1.25},{"$f":"$K$41","v":{"v":50,"d":"50.00"}},null,2,0.05,{"$f":"X4*$AD$34","v":{"v":2.5,"d":"2.50"}},{"$f":"$AC$32+($AD$32*Y4)","v":{"v":95,"d":"95.00"}},{"$f":"$AD$29","v":{"v":30,"d":"30.0"}},{"v":2,"d":"2.00"},{"$f":"X4*$AD$29","v":{"v":1.5,"d":"1.50"}},{"$f":"$AF$29","v":{"v":40,"d":"40.0"}},{"$f":"$AD$45*X4","v":{"v":2.5,"d":"2.50"}},{"$f":"$AC$43+($AD$43*AE4)","v":{"v":95,"d":"95.00"}},{"$f":"$AE$43*X4","v":{"v":1.5,"d":"1.50"}},{"$f":"$AB$43","v":{"v":40,"d":"40.00"}}]
[3,{"v":0.1,"d":"0.10"},{"v":5,"d":"5.00"},{"v":90,"d":"90.00"},{"v":20,"d":"20.0"},{"v":6,"d":"6.00"},{"v":2,"d":"2.00"},{"v":60,"d":"60.0"},null,3,{"v":0.1,"d":"0.10"},{"v":5,"d":"5.00"},{"v":90,"d":"90.00"},{"v":25,"d":"25.0"},{"v":5,"d":"5.00"},{"v":2.5,"d":"2.50"},{"v":50,"d":"50.0"},{"v":5,"d":"5.00"},{"v":90,"d":"90.00"},{"v":2.5,"d":"2.50"},{"v":50,"d":"50.00"},null,3,{"v":0.1,"d":"0.10"},{"v":5,"d":"5.00"},{"v":90,"d":"90.00"},{"v":30,"d":"30.0"},{"v":4,"d":"4.00"},{"v":3,"d":"3.00"},{"v":40,"d":"40.0"},{"v":5,"d":"5.00"},{"v":90,"d":"90.00"},{"v":3,"d":"3.00"},{"v":40,"d":"40.00"}]
[4,0.15,{"v":7.5,"d":"7.50"},{"v":85,"d":"85.00"},{"v":20,"d":"20.0"},{"v":9,"d":"9.00"},{"v":3,"d":"3.00"},{"v":60,"d":"60.0"},null,4,0.15,{"v":7.5,"d":"7.50"},{"v":85,"d":"85.00"},{"v":25,"d":"25.0"},{"v":7.5,"d":"7.50"},3.75,{"v":50,"d":"50.0"},{"v":7.5,"d":"7.50"},{"v":85,"d":"85.00"},3.75,{"v":50,"d":"50.00"},null,4,0.15,{"v":7.5,"d":"7.50"},{"v":85,"d":"85.00"},{"v":30,"d":"30.0"},{"v":6,"d":"6.00"},{"v":4.5,"d":"4.50"},{"v":40,"d":"40.0"},{"v":7.5,"d":"7.50"},{"v":85,"d":"85.00"},{"v":4.5,"d":"4.50"},{"v":40,"d":"40.00"}]
[5,{"v":0.2,"d":"0.20"},{"v":10,"d":"10.00"},{"v":80,"d":"80.00"},{"v":20,"d":"20.0"},{"v":12,"d":"12.00"},{"v":4,"d":"4.00"},{"v":60,"d":"60.0"},null,5,{"v":0.2,"d":"0.20"},{"v":10,"d":"10.00"},{"v":80,"d":"80.00"},{"v":25,"d":"25.0"},{"v":10,"d":"10.00"},{"v":5,"d":"5.00"},{"v":50,"d":"50.0"},{"v":10,"d":"10.00"},{"v":80,"d":"80.00"},{"v":5,"d":"5.00"},{"v":50,"d":"50.00"},null,5,{"v":0.2,"d":"0.20"},{"v":10,"d":"10.00"},{"v":80,"d":"80.00"},{"v":30,"d":"30.0"},{"v":8,"d":"8.00"},{"v":6,"d":"6.00"},{"v":40,"d":"40.0"},{"v":10,"d":"10.00"},{"v":80,"d":"80.00"},{"v":6,"d":"6.00"},{"v":40,"d":"40.00"}]
[6,0.25,{"v":12.5,"d":"12.50"},{"v":75,"d":"75.00"},{"v":20,"d":"20.0"},{"v":15,"d":"15.00"},{"v":5,"d":"5.00"},{"v":60,"d":"60.0"},null,6,0.25,{"v":12.5,"d":"12.50"},{"v":75,"d":"75.00"},{"v":25,"d":"25.0"},{"v":12.5,"d":"12.50"},6.25,{"v":50,"d":"50.0"},{"v":12.5,"d":"12.50"},{"v":75,"d":"75.00"},6.25,{"v":50,"d":"50.00"},null,6,0.25,{"v":12.5,"d":"12.50"},{"v":75,"d":"75.00"},{"v":30,"d":"30.0"},{"v":10,"d":"10.00"},{"v":7.5,"d":"7.50"},{"v":40,"d":"40.0"},{"v":12.5,"d":"12.50"},{"v":75,"d":"75.00"},{"v":7.5,"d":"7.50"},{"v":40,"d":"40.00"}]
[7,{"v":0.3,"d":"0.30"},{"v":15,"d":"15.00"},{"v":70,"d":"70.00"},{"v":20,"d":"20.0"},{"v":18,"d":"18.00"},{"v":6,"d":"6.00"},{"v":60,"d":"60.0"},null,7,{"v":0.3,"d":"0.30"},{"v":15,"d":"15.00"},{"v":70,"d":"70.00"},{"v":25,"d":"25.0"},{"v":15,"d":"15.00"},{"v":7.5,"d":"7.50"},{"v":50,"d":"50.0"},{"v":15,"d":"15.00"},{"v":70,"d":"70.00"},{"v":7.5,"d":"7.50"},{"v":50,"d":"50.00"},null,7,{"v":0.3,"d":"0.30"},{"v":15,"d":"15.00"},{"v":70,"d":"70.00"},{"v":30,"d":"30.0"},{"v":12,"d":"12.00"},{"v":9,"d":"9.00"},{"v":40,"d":"40.0"},{"v":15,"d":"15.00"},{"v":70,"d":"70.00"},{"v":9,"d":"9.00"},{"v":40,"d":"40.00"}]
[8,0.35,{"v":17.5,"d":"17.50"},{"v":65,"d":"65.00"},{"v":20,"d":"20.0"},{"v":21,"d":"21.00"},{"v":7,"d":"7.00"},{"v":60,"d":"60.0"},null,8,0.35,{"v":17.5,"d":"17.50"},{"v":65,"d":"65.00"},{"v":25,"d":"25.0"},{"v":17.5,"d":"17.50"},8.75,{"v":50,"d":"50.0"},{"v":17.5,"d":"17.50"},{"v":65,"d":"65.00"},8.75,{"v":50,"d":"50.00"},null,8,0.35,{"v":17.5,"d":"17.50"},{"v":65,"d":"65.00"},{"v":30,"d":"30.0"},{"v":14,"d":"14.00"},{"v":10.5,"d":"10.50"},{"v":40,"d":"40.0"},{"v":17.5,"d":"17.50"},{"v":65,"d":"65.00"},{"v":10.5,"d":"10.50"},{"v":40,"d":"40.00"}]
[9,{"v":0.4,"d":"0.40"},{"v":20,"d":"20.00"},{"v":60,"d":"60.00"},{"v":20,"d":"20.0"},{"v":24,"d":"24.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.0"},null,9,{"v":0.4,"d":"0.40"},{"v":20,"d":"20.00"},{"v":60,"d":"60.00"},{"v":25,"d":"25.0"},{"v":20,"d":"20.00"},{"v":10,"d":"10.00"},{"v":50,"d":"50.0"},{"v":20,"d":"20.00"},{"v":60,"d":"60.00"},{"v":10,"d":"10.00"},{"v":50,"d":"50.00"},null,9,{"v":0.4,"d":"0.40"},{"v":20,"d":"20.00"},{"v":60,"d":"60.00"},{"v":30,"d":"30.0"},{"v":16,"d":"16.00"},{"v":12,"d":"12.00"},{"v":40,"d":"40.0"},{"v":20,"d":"20.00"},{"v":60,"d":"60.00"},{"v":12,"d":"12.00"},{"v":40,"d":"40.00"}]
[10,0.45,{"v":22.5,"d":"22.50"},{"v":55,"d":"55.00"},{"v":20,"d":"20.0"},{"v":27,"d":"27.00"},{"v":9,"d":"9.00"},{"v":60,"d":"60.0"},null,10,0.45,{"v":22.5,"d":"22.50"},{"v":55,"d":"55.00"},{"v":25,"d":"25.0"},{"v":22.5,"d":"22.50"},11.25,{"v":50,"d":"50.0"},{"v":22.5,"d":"22.50"},{"v":55,"d":"55.00"},11.25,{"v":50,"d":"50.00"},null,10,0.45,{"v":22.5,"d":"22.50"},{"v":55,"d":"55.00"},{"v":30,"d":"30.0"},{"v":18,"d":"18.00"},{"v":13.5,"d":"13.50"},{"v":40,"d":"40.0"},{"v":22.5,"d":"22.50"},{"v":55,"d":"55.00"},{"v":13.5,"d":"13.50"},{"v":40,"d":"40.00"}]
[11,{"v":0.5,"d":"0.50"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":20,"d":"20.0"},{"v":30,"d":"30.00"},{"v":10,"d":"10.00"},{"v":60,"d":"60.0"},null,11,{"v":0.5,"d":"0.50"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":25,"d":"25.0"},{"v":25,"d":"25.00"},{"v":12.5,"d":"12.50"},{"v":50,"d":"50.0"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":12.5,"d":"12.50"},{"v":50,"d":"50.00"},null,11,{"v":0.5,"d":"0.50"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.0"},{"v":20,"d":"20.00"},{"v":15,"d":"15.00"},{"v":40,"d":"40.0"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":15,"d":"15.00"},{"v":40,"d":"40.00"}]
[12,0.55,{"v":27.500000000000004,"d":"27.50"},{"v":44.99999999999999,"d":"45.00"},{"v":20,"d":"20.0"},{"v":33,"d":"33.00"},{"v":11,"d":"11.00"},{"v":60,"d":"60.0"},null,12,0.55,{"v":27.500000000000004,"d":"27.50"},{"v":44.99999999999999,"d":"45.00"},{"v":25,"d":"25.0"},{"v":27.500000000000004,"d":"27.50"},{"v":13.750000000000002,"d":"13.75"},{"v":50,"d":"50.0"},{"v":27.500000000000004,"d":"27.50"},{"v":44.99999999999999,"d":"45.00"},{"v":13.750000000000002,"d":"13.75"},{"v":50,"d":"50.00"},null,12,0.55,{"v":27.500000000000004,"d":"27.50"},{"v":44.99999999999999,"d":"45.00"},{"v":30,"d":"30.0"},{"v":22,"d":"22.00"},{"v":16.5,"d":"16.50"},{"v":40,"d":"40.0"},{"v":27.500000000000004,"d":"27.50"},{"v":44.99999999999999,"d":"45.00"},{"v":16.5,"d":"16.50"},{"v":40,"d":"40.00"}]
[13,{"v":0.6,"d":"0.60"},{"v":30,"d":"30.00"},{"v":40,"d":"40.00"},{"v":20,"d":"20.0"},{"v":36,"d":"36.00"},{"v":12,"d":"12.00"},{"v":60,"d":"60.0"},null,13,{"v":0.6,"d":"0.60"},{"v":30,"d":"30.00"},{"v":40,"d":"40.00"},{"v":25,"d":"25.0"},{"v":30,"d":"30.00"},{"v":15,"d":"15.00"},{"v":50,"d":"50.0"},{"v":30,"d":"30.00"},{"v":40,"d":"40.00"},{"v":15,"d":"15.00"},{"v":50,"d":"50.00"},null,13,{"v":0.6,"d":"0.60"},{"v":30,"d":"30.00"},{"v":40,"d":"40.00"},{"v":30,"d":"30.0"},{"v":24,"d":"24.00"},{"v":18,"d":"18.00"},{"v":40,"d":"40.0"},{"v":30,"d":"30.00"},{"v":40,"d":"40.00"},{"v":18,"d":"18.00"},{"v":40,"d":"40.00"}]
[14,0.65,{"v":32.5,"d":"32.50"},{"v":35,"d":"35.00"},{"v":20,"d":"20.0"},{"v":39,"d":"39.00"},{"v":13,"d":"13.00"},{"v":60,"d":"60.0"},null,14,0.65,{"v":32.5,"d":"32.50"},{"v":35,"d":"35.00"},{"v":25,"d":"25.0"},{"v":32.5,"d":"32.50"},16.25,{"v":50,"d":"50.0"},{"v":32.5,"d":"32.50"},{"v":35,"d":"35.00"},16.25,{"v":50,"d":"50.00"},null,14,0.65,{"v":32.5,"d":"32.50"},{"v":35,"d":"35.00"},{"v":30,"d":"30.0"},{"v":26,"d":"26.00"},{"v":19.5,"d":"19.50"},{"v":40,"d":"40.0"},{"v":32.5,"d":"32.50"},{"v":35,"d":"35.00"},{"v":19.5,"d":"19.50"},{"v":40,"d":"40.00"}]
[15,{"v":0.7,"d":"0.70"},{"v":35,"d":"35.00"},{"v":30,"d":"30.00"},{"v":20,"d":"20.0"},{"v":42,"d":"42.00"},{"v":14,"d":"14.00"},{"v":60,"d":"60.0"},null,15,{"v":0.7,"d":"0.70"},{"v":35,"d":"35.00"},{"v":30,"d":"30.00"},{"v":25,"d":"25.0"},{"v":35,"d":"35.00"},{"v":17.5,"d":"17.50"},{"v":50,"d":"50.0"},{"v":35,"d":"35.00"},{"v":30,"d":"30.00"},{"v":17.5,"d":"17.50"},{"v":50,"d":"50.00"},null,15,{"v":0.7,"d":"0.70"},{"v":35,"d":"35.00"},{"v":30,"d":"30.00"},{"v":30,"d":"30.0"},{"v":28,"d":"28.00"},{"v":21,"d":"21.00"},{"v":40,"d":"40.0"},{"v":35,"d":"35.00"},{"v":30,"d":"30.00"},{"v":21,"d":"21.00"},{"v":40,"d":"40.00"}]
[16,0.75,{"v":37.5,"d":"37.50"},{"v":25,"d":"25.00"},{"v":20,"d":"20.0"},{"v":45,"d":"45.00"},{"v":15,"d":"15.00"},{"v":60,"d":"60.0"},null,16,0.75,{"v":37.5,"d":"37.50"},{"v":25,"d":"25.00"},{"v":25,"d":"25.0"},{"v":37.5,"d":"37.50"},18.75,{"v":50,"d":"50.0"},{"v":37.5,"d":"37.50"},{"v":25,"d":"25.00"},18.75,{"v":50,"d":"50.00"},null,16,0.75,{"v":37.5,"d":"37.50"},{"v":25,"d":"25.00"},{"v":30,"d":"30.0"},{"v":30,"d":"30.00"},{"v":22.5,"d":"22.50"},{"v":40,"d":"40.0"},{"v":37.5,"d":"37.50"},{"v":25,"d":"25.00"},{"v":22.5,"d":"22.50"},{"v":40,"d":"40.00"}]
[17,{"v":0.8,"d":"0.80"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.0"},{"v":48,"d":"48.00"},{"v":16,"d":"16.00"},{"v":60,"d":"60.0"},null,17,{"v":0.8,"d":"0.80"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":25,"d":"25.0"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":50,"d":"50.0"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},null,17,{"v":0.8,"d":"0.80"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":30,"d":"30.0"},{"v":32,"d":"32.00"},{"v":24,"d":"24.00"},{"v":40,"d":"40.0"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},{"v":24,"d":"24.00"},{"v":40,"d":"40.00"}]
[18,0.85,{"v":42.5,"d":"42.50"},{"v":15,"d":"15.00"},{"v":20,"d":"20.0"},{"v":51,"d":"51.00"},{"v":17,"d":"17.00"},{"v":60,"d":"60.0"},null,18,0.85,{"v":42.5,"d":"42.50"},{"v":15,"d":"15.00"},{"v":25,"d":"25.0"},{"v":42.5,"d":"42.50"},21.25,{"v":50,"d":"50.0"},{"v":42.5,"d":"42.50"},{"v":15,"d":"15.00"},21.25,{"v":50,"d":"50.00"},null,18,0.85,{"v":42.5,"d":"42.50"},{"v":15,"d":"15.00"},{"v":30,"d":"30.0"},{"v":34,"d":"34.00"},{"v":25.5,"d":"25.50"},{"v":40,"d":"40.0"},{"v":42.5,"d":"42.50"},{"v":15,"d":"15.00"},{"v":25.5,"d":"25.50"},{"v":40,"d":"40.00"}]
[19,{"v":0.9,"d":"0.90"},{"v":45,"d":"45.00"},{"v":10,"d":"10.00"},{"v":20,"d":"20.0"},{"v":54,"d":"54.00"},{"v":18,"d":"18.00"},{"v":60,"d":"60.0"},null,19,{"v":0.9,"d":"0.90"},{"v":45,"d":"45.00"},{"v":10,"d":"10.00"},{"v":25,"d":"25.0"},{"v":45,"d":"45.00"},{"v":22.5,"d":"22.50"},{"v":50,"d":"50.0"},{"v":45,"d":"45.00"},{"v":10,"d":"10.00"},{"v":22.5,"d":"22.50"},{"v":50,"d":"50.00"},null,19,{"v":0.9,"d":"0.90"},{"v":45,"d":"45.00"},{"v":10,"d":"10.00"},{"v":30,"d":"30.0"},{"v":36,"d":"36.00"},{"v":27,"d":"27.00"},{"v":40,"d":"40.0"},{"v":45,"d":"45.00"},{"v":10,"d":"10.00"},{"v":27,"d":"27.00"},{"v":40,"d":"40.00"}]
[20,0.95,{"v":47.5,"d":"47.50"},{"v":5,"d":"5.00"},{"v":20,"d":"20.0"},{"v":57,"d":"57.00"},{"v":19,"d":"19.00"},{"v":60,"d":"60.0"},null,20,0.95,{"v":47.5,"d":"47.50"},{"v":5,"d":"5.00"},{"v":25,"d":"25.0"},{"v":47.5,"d":"47.50"},23.75,{"v":50,"d":"50.0"},{"v":47.5,"d":"47.50"},{"v":5,"d":"5.00"},23.75,{"v":50,"d":"50.00"},null,20,0.95,{"v":47.5,"d":"47.50"},{"v":5,"d":"5.00"},{"v":30,"d":"30.0"},{"v":38,"d":"38.00"},{"v":28.5,"d":"28.50"},{"v":40,"d":"40.0"},{"v":47.5,"d":"47.50"},{"v":5,"d":"5.00"},{"v":28.5,"d":"28.50"},{"v":40,"d":"40.00"}]
[21,{"v":1,"d":"1.00"},{"v":50,"d":"50.00"},0,{"v":20,"d":"20.0"},{"v":60,"d":"60.00"},{"v":20,"d":"20.00"},{"v":60,"d":"60.0"},null,21,{"v":1,"d":"1.00"},{"v":50,"d":"50.00"},0,{"v":25,"d":"25.0"},{"v":50,"d":"50.00"},{"v":25,"d":"25.00"},{"v":50,"d":"50.0"},{"v":50,"d":"50.00"},0,{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},null,21,{"v":1,"d":"1.00"},{"v":50,"d":"50.00"},0,{"v":30,"d":"30.0"},{"$f":"MAX($AF$29,$AF$40)*X23","v":{"v":40,"d":"40.00"}},{"v":30,"d":"30.00"},{"v":40,"d":"40.0"},{"v":50,"d":"50.00"},0,{"v":30,"d":"30.00"},{"v":40,"d":"40.00"}]
[]
[]
[null,"m","p1","x1","p2","x2",{"$nulls":4},"m","p1","x1","p2","x2",{"$nulls":8},"impuesto al ingreso",{"$f":"1-Z26","v":{"v":1,"d":"100%"}},{"$f":"'Impuestos RP'!D24","v":{"v":0,"d":"0%"}},null,"RESTRICCIÓN PRESUPUESTARIA"]
[null,{"$f":"'Básico RP'!B5","v":{"v":100,"d":"100.0"}},{"$f":"'Básico RP'!C5","v":{"v":2,"d":"2.0"}},{"$f":"E30","v":{"v":20,"d":"20.0"}},{"$f":"'Básico RP'!E5","v":{"v":1,"d":"1.0"}},{"$f":"B30","v":{"v":60,"d":"60.0"}},{"$nulls":4},{"$f":"'Complejo RP'!B5","v":{"v":100,"d":"100.0"}},{"$f":"'Complejo RP'!C5","v":{"v":2,"d":"2.0"}},{"$f":"N30","v":{"v":25,"d":"25.0"}},{"$f":"'Complejo RP'!E5","v":{"v":1,"d":"1.0"}},{"$f":"K30","v":{"v":50,"d":"50.0"}},{"$nulls":7},2,"Impuesto Advalorem",{"$f":"(1+Z27)*'Impuestos RP'!C4","v":{"v":2,"d":"200%"}},{"$f":"'Impuestos RP'!D25","v":{"v":0,"d":"0%"}},null,"RESTRICCIÓN PRESUPUESTARIA INICIAL"]
[{"$nulls":10},"Inserte los datos correspondientes",{"$nulls":12},"Impuesto Unitario",{"$f":"'Impuestos RP'!C4+'Oculto RP'!Z28","v":2},{"$f":"'Impuestos RP'!D25","v":0},null,"m","p1","x1","p2","x2"]
[null,"x2","b0","-B1","x1",{"$nulls":5},"x2","b0","b1","x1",{"$nulls":13},{"$f":"'Impuestos RP'!B4","v":{"v":100,"d":"100.0"}},{"$f":"'Impuestos RP'!C4","v":{"v":2,"d":"2.0"}},{"$f":"AE32","v":{"v":30,"d":"30.0"}},{"$f":"'Impuestos RP'!E4","v":{"v":1,"d":"1.0"}},{"$f":"AB32","v":{"v":40,"d":"40.0"}}]
[null,{"$f":"C30+(D30*E30)","v":{"v":60,"d":"60.0"}},{"$f":"B27/E27","v":{"v":100,"d":"100.0"}},{"$f":"C27/E27*-1","v":{"v":-2,"d":"(2.0)"}},{"$f":"'Básico RP'!E13","v":{"v":20,"d":"20.0"}},{"$nulls":5},{"$f":"L30+(M30*N30)","v":{"v":50,"d":"50.0"}},{"$f":"K27/N27","v":{"v":100,"d":"100.0"}},{"$f":"L27/N27*-1","v":{"v":-2,"d":"(2.0)"}},{"$f":"'Complejo RP'!E8","v":{"v":25,"d":"25.0"}},{"$nulls":9},{"$f":"IF(W27=1,X27,X28)","v":"Impuesto Unitario"},{"$f":"VLOOKUP(X30,X27:Y28,2,FALSE)","v":2},null,null,"Inserte los datos correspondientes"]
[{"$nulls":13},"Cambie la Cantidad de x1",{"$nulls":13},"x2","b0","-b1","x1"]
[null,"Máxima cantidad de x1",null,{"$f":"B27/C27","v":{"v":50,"d":"50.0"}},{"$nulls":6},"Máxima cantidad de x1",null,{"$f":"K27/L27","v":{"v":50,"d":"50.0"}},{"$nulls":14},{"$f":"AC32+(AD32*AE32)","v":{"v":40,"d":"40.0"}},{"$f":"AB29/AE29","v":{"v":100,"d":"100.0"}},{"$f":"AC29/AE29*-1","v":{"v":-2,"d":"(2.0)"}},{"$f":"'Impuestos RP'!E7","v":{"v":30,"d":"30.0"}}]
[null,"Máxima cantidad de x2",null,{"$f":"B27/E27","v":{"v":100,"d":"100.0"}},{"$nulls":6},"Máxima cantidad de x2",null,{"$f":"K27/N27","v":{"v":100,"d":"100.0"}},{"$nulls":17},"Cambie la Cantidad de x1"]
[null,"Precio Relativo (<0)",null,{"$f":"D30","v":{"v":-2,"d":"(2.0)"}},{"$nulls":6},"Precio Relativo (<0)",null,{"$f":"M30","v":{"v":-2,"d":"(2.0)"}},{"$nulls":14},"Máxima cantidad de x1",null,{"$f":"AB29/AC29","v":{"v":50,"d":"50.0"}}]
[{"$nulls":27},"Máxima cantidad de x2",null,{"$f":"AB29/AE29","v":{"v":100,"d":"100.0"}}]
[{"$nulls":10},"NUEVA RESTRICCIÓN PRESUPUESTARIA",{"$nulls":16},"Precio Relativo (<0)",null,{"$f":"AD32","v":{"v":-2,"d":"(2.0)"}}]
[{"$nulls":10},"m","p1","x1","p2","x2"]
[{"$nulls":10},{"$f":"'Complejo RP'!B16","v":{"v":100,"d":"100.0"}},{"$f":"'Complejo RP'!C16","v":{"v":2,"d":"2.0"}},{"$f":"M27","v":{"v":25,"d":"25.0"}},{"$f":"N27","v":{"v":1,"d":"1.0"}},{"$f":"K41","v":{"v":50,"d":"50.0"}},{"$nulls":12},"NUEVA RESTRICCIÓN CON IMPUESTOS"]
[{"$nulls":10},"Inserte los datos correspondientes",{"$nulls":16},"m","p1","x1","p2","x2"]
[{"$nulls":10},"x2","b0","b1","x1",{"$nulls":13},{"$f":"IF(AD49<1,AB29*(1-AD49),AB29-AD49)","v":{"v":100,"d":"100.0"}},{"$f":"Y30","v":{"v":2,"d":"2.0"}},{"$f":"AE43","v":{"v":30,"d":"30.0"}},{"$f":"AE29","v":{"v":1,"d":"1.0"}},{"$f":"AB43","v":{"v":40,"d":"40.0"}}]
[{"$nulls":10},{"$f":"L41+(M41*N41)","v":{"v":50,"d":"50.0"}},{"$f":"K38/N38","v":{"v":100,"d":"100.0"}},{"$f":"L38/N38*-1","v":{"v":-2,"d":"(2.0)"}},{"$f":"N30","v":{"v":25,"d":"25.0"}},{"$nulls":13},"Inserte los datos correspondientes"]
[{"$nulls":27},"x2","b0","-b1","x1"]
[{"$nulls":10},"Máxima cantidad de x1",null,{"$f":"K38/L38","v":{"v":50,"d":"50.0"}},{"$nulls":14},{"$f":"AC43+(AD43*AE43)","v":{"v":40,"d":"40.0"}},{"$f":"AB40/AE40","v":{"v":100,"d":"100.0"}},{"$f":"AC40/AE40*-1","v":{"v":-2,"d":"(2.0)"}},{"$f":"AE32","v":{"v":30,"d":"30.0"}}]
[{"$nulls":10},"Máxima cantidad de x2",null,{"$f":"K38/N38","v":{"v":100,"d":"100.0"}}]
[{"$nulls":10},"Precio Relativo (<0)",null,{"$f":"M41","v":{"v":-2,"d":"(2.0)"}},{"$nulls":14},"Máxima cantidad de x1",null,{"$f":"AB40/AC40","v":{"v":50,"d":"50.0"}}]
[{"$nulls":27},"Máxima cantidad de x2",null,{"$f":"AB40/AE40","v":{"v":100,"d":"100.0"}}]
[{"$nulls":27},"Precio Relativo (<0)",null,{"$f":"AD43","v":{"v":-2,"d":"(2.0)"}}]
[]
[{"$nulls":27},"Impuesto al Ingreso",null,{"$f":"'Impuestos RP'!D24","v":0}]
[{"$nulls":27},"Impuesto Unitario",null,{"$f":"'Impuestos RP'!D25","v":0}]