{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Menú principal","Programación lineal","Programación por metas","Optimización de redes","Teoría de decisiones","Cadenas de Markov","Líneas de espera"],"not_rendered":{"charts":0,"images":91,"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":"Menú principal","index":0,"n_rows":10,"n_cols":27,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M/G/1:PEPS/inf/inf","S ","Dia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M/M/S:PEPS/inf/inf","Lambda","Hora"]
[null,null,null," Software para Investigación de Operaciones (IOpeTec)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M/M/S:PEPS/N/inf","Mu","Minuto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M/M/S:PEPS/N/N","U","Segundo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lq"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wq"]

{"sheet":"Programación lineal","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Programación por metas","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Optimización de redes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Teoría de decisiones","index":4,"n_rows":67,"n_cols":19,"rows_kept":67,"cut":false,"hidden":true,"merged":[[53,14,53,17],[11,1,11,4],[12,1,13,1],[12,2,12,4],[19,1,20,1],[19,2,19,4],[11,12,11,17]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Captura de datos",null,null,null,null,null,null,null,null,null,null,"Árbol de decisiones con información muestral"]
[null,"Decisión","Estado de la naturaleza",null,null,null,null,null,null,null,null,null,"VEcIM","Prob. indic.","VE mayor","Valor esp.","Prob. post.","Pago"]
[null,null,"E1","E2","E3"]
[null,"Alternativa 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 1",0.28571000000000002,0,"E1"]
[null,"Alternativa 2",null,null,null,null,null,null,null,null,null,null,null,null,null,".",0.71428999999999998,0,"E2"]
[null,"Alternativa 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[null,"Probabilidades previas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicador 1",null,"Alternativa 2",0.28571000000000002,0,"E1"]
[null,"Estado de la naturaleza","Probabilidad condicional",null,null,null,null,null,null,null,null,null,null,0.23330000000000001,".",".",0.71428999999999998,0,"E2"]
[null,null,"Ind. 1","Ind. 2","Ind. 3",null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[null,"Estado 1",0.2,0.3,0.5]
[null,"Estado 2",0.5,0.5,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 3",0.28571000000000002,0,"E1"]
[null,"Estado 3",null,null,1,null,null,null,null,null,null,null,null,null,null,".",0.71428999999999998,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 1",0.375,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0.625,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicador 2",null,"Alternativa 2",0.375,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,".",0.26669999999999999,".",".",0.625,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 3",0.375,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0.625,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0,"E3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 1",0.33333000000000002,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",".",0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66666999999999998,0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicador 3",null,"Alternativa 2",0.33333000000000002,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,".",".",".",0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66666999999999998,0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 3",0.33333000000000002,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",".",0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66666999999999998,0,"E3"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Árbol de decisiones sin información muestral"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEsIM","Valor esp.","Prob. previa","Pago"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 1",0.33333333333333331,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0.33333333333333331,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33333333333333331,0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 2",0.33333333333333331,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",".",0.33333333333333331,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33333333333333331,0,"E3"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alternativa 3",0.33333333333333331,0,"E1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",0.33333333333333331,0,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33333333333333331,0,"E3"]

{"sheet":"Cadenas de Markov","index":5,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,2,9,4],[9,13,9,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Captura de probabilidades",null,null,null,null,null,null,null,null,null,null,"Tiempos promedio de primer paso "]
[null,"De \\ A","Estado 1","Estado 2","Estado 3",null,null,null,null,null,null,null,null,"De \\ A","Estado 1","Estado 2","Estado 3"]
[null,"Estado 1",0.2,0.3,0.5,null,null,null,null,null,null,null,null,"Estado 1",2.7250000000000001,2.9545454545454546,3.1999999999999997]
[null,"Estado 2",0.5,0.5,null,null,null,null,null,null,null,null,null,"Estado 2",2,2.4772727272727275,5.2]
[null,"Estado 3",0.4,0.4,0.2,null,null,null,null,null,null,null,null,"Estado 3",2.25,2.7272727272727271,4.3599999999999994]
[null,"Prob. iniciales",null,null,null,null,null,null,null,null,null,null,null,"Prob. de estado estable",0.36697247706422015,0.40366972477064217,0.22935779816513766]

{"sheet":"Líneas de espera","index":6,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[[9,1,9,2],[9,4,9,5],[9,7,9,9],[10,7,11,7],[10,8,11,8],[10,9,11,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Captura de datos",null,null,"Medidas de desempeño: modelo M/M/1:PEPS/inf/inf",null,null,"Cálculo de probabilidades"]
[null,"Tasa de llegadas (lambda)",1,null,"Utilización del servidor (U)",0.5,null,"n clientes","Probabilidad (Pn)","Probabilidad acumulada"]
[null,"Tasa de servicio (mu)",2,null,"Probabilidad de que no haya clientes en el sistema (P0)",0.5]
[null,"Número de servidores (S)",1,null,"Prob. de que un cliente que llega tenga que esperar (PW)",0.5,null,0,0.5,0.5]
[null,"Costo de espera/Hora",null,null,"Número promedio de clientes en el sistema (L)",1,null,1,0.25,0.75]
[null,"Costo del servidor/Hora",null,null,"Número promedio de clientes en la cola (Lq)",0.5,null,2,0.125,0.875]
[null,null,null,null,"Tiempo promedio de espera en el sistema (W)",1,"Horas",3,6.25E-2,0.9375]
[null,null,null,null,"Tiempo promedio de espera en cola (Wq)",0.5,"Horas",4,3.125E-2,0.96875]
[null,null,null,null,"Costo de espera",0,null,5,1.5625E-2,0.984375]
[null,null,null,null,"Costo de servicio",0,null,6,7.8125E-3,0.9921875]
[null,null,null,null,"Costo total",0,null,7,3.90625E-3,0.99609375]
[null,null,null,null,null,null,null,8,1.953125E-3,0.998046875]
[null,null,null,null,null,null,null,9,9.765625E-4,0.9990234375]
[null,null,null,null,null,null,null,10,4.8828125E-4,0.99951171875]
[null,null,null,null,null,null,null,11,2.44140625E-4,0.999755859375]
[null,null,null,null,null,null,null,12,1.220703125E-4,0.9998779296875]
[null,null,null,null,null,null,null,13,6.103515625E-5,0.99993896484375]
[null,null,null,null,null,null,null,14,3.0517578125E-5,0.999969482421875]
[null,null,null,null,null,null,null,15,1.52587890625E-5,0.9999847412109375]
[null,null,null,null,null,null,null,16,7.62939453125E-6,0.99999237060546875]
[null,null,null,null,null,null,null,17,3.814697265625E-6,0.99999618530273438]
[null,null,null,null,null,null,null,18,1.9073486328125E-6,0.99999809265136719]
[null,null,null,null,null,null,null,19,9.5367431640625E-7,0.99999904632568359]
[null,null,null,null,null,null,null,20,4.76837158203125E-7,0.9999995231628418]
[null,null,null,null,null,null,null,21,2.384185791015625E-7,0.9999997615814209]
[null,null,null,null,null,null,null,22,1.1920928955078125E-7,0.99999988079071045]
[null,null,null,null,null,null,null,23,5.9604644775390625E-8,0.99999994039535522]
[null,null,null,null,null,null,null,"L=",{"$f":"SUMPRODUCT(H13:H36,I13:I36)","v":0.99999850988388062}]