{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INVERSIÓN","FINANCIACIÓN","INGRESOS Y COSTES","ESTADOS FINANCIEROS","VALORACIÓN Y RENTABILIDAD","ANÁLISIS DE RIESGO"],"not_rendered":{"charts":15,"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":"INVERSIÓN","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"VAN",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F2","v":548675.29532205523}]
[null,null,"TIR",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F3","v":0.17904917042371715}]
[null,null,"TIR Capital",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F4","v":0.27368271124511612}]
[null,null,null,null,null,"Cuadro de Amortización Técnica"]
[null,"Concepto","Cuantía","Coef.",1,{"$f":"E6+1","v":2},{"$f":"F6+1","v":3},4,5]
[null,"Inmovilizado Material"]
[null,"Terrenos",240000,0,{"$f":"D8*C8","v":0},{"$f":"IF($E8<($C8-SUM($E8:E8)),$E8,($C8-SUM($E8:E8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:F8)),$E8,($C8-SUM($E8:F8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:G8)),$E8,($C8-SUM($E8:G8)))","v":0},{"$f":"IF($E8<($C8-SUM($E8:H8)),$E8,($C8-SUM($E8:H8)))","v":0}]
[null,"Edificios",{"$f":"'ANÁLISIS DE RIESGO'!D12","v":430000},0.03,{"$f":"D9*C9","v":12900},{"$f":"IF($E9<($C9-SUM($E9:E9)),$E9,($C9-SUM($E9:E9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:F9)),$E9,($C9-SUM($E9:F9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:G9)),$E9,($C9-SUM($E9:G9)))","v":12900},{"$f":"IF($E9<($C9-SUM($E9:H9)),$E9,($C9-SUM($E9:H9)))","v":12900}]
[null,"Maquinaria",73000,0.12,8760,{"$f":"IF($E10<($C10-SUM($E10:E10)),$E10,($C10-SUM($E10:E10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:F10)),$E10,($C10-SUM($E10:F10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:G10)),$E10,($C10-SUM($E10:G10)))","v":8760},{"$f":"IF($E10<($C10-SUM($E10:H10)),$E10,($C10-SUM($E10:H10)))","v":8760}]
[null,"Equipamiento",61350,0.15,9202.5,{"$f":"IF($E11<($C11-SUM($E11:E11)),$E11,($C11-SUM($E11:E11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:F11)),$E11,($C11-SUM($E11:F11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:G11)),$E11,($C11-SUM($E11:G11)))","v":9202.5},{"$f":"IF($E11<($C11-SUM($E11:H11)),$E11,($C11-SUM($E11:H11)))","v":9202.5}]
[null,"Mobiliario",140000,0.12,16800,{"$f":"IF($E12<($C12-SUM($E12:E12)),$E12,($C12-SUM($E12:E12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:F12)),$E12,($C12-SUM($E12:F12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:G12)),$E12,($C12-SUM($E12:G12)))","v":16800},{"$f":"IF($E12<($C12-SUM($E12:H12)),$E12,($C12-SUM($E12:H12)))","v":16800}]
[null,"Equipos Informáticos",40000,0.23,9200,{"$f":"IF($E13<($C13-SUM($E13:E13)),$E13,($C13-SUM($E13:E13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:F13)),$E13,($C13-SUM($E13:F13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:G13)),$E13,($C13-SUM($E13:G13)))","v":9200},{"$f":"IF($E13<($C13-SUM($E13:H13)),$E13,($C13-SUM($E13:H13)))","v":3200}]
[null,"Varios",34000,0.15,5100,{"$f":"IF($E14<($C14-SUM($E14:E14)),$E14,($C14-SUM($E14:E14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:F14)),$E14,($C14-SUM($E14:F14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:G14)),$E14,($C14-SUM($E14:G14)))","v":5100},{"$f":"IF($E14<($C14-SUM($E14:H14)),$E14,($C14-SUM($E14:H14)))","v":5100}]
[null,"Otros",0,0,0,{"$f":"IF($E15<($C15-SUM($E15:E15)),$E15,($C15-SUM($E15:E15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:F15)),$E15,($C15-SUM($E15:F15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:G15)),$E15,($C15-SUM($E15:G15)))","v":0},{"$f":"IF($E15<($C15-SUM($E15:H15)),$E15,($C15-SUM($E15:H15)))","v":0}]
[null,"Otros",0,0,0,{"$f":"IF($E16<($C16-SUM($E16:E16)),$E16,($C16-SUM($E16:E16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:F16)),$E16,($C16-SUM($E16:F16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:G16)),$E16,($C16-SUM($E16:G16)))","v":0},{"$f":"IF($E16<($C16-SUM($E16:H16)),$E16,($C16-SUM($E16:H16)))","v":0}]
[null,"Total Inmovilizado Material",{"$f":"SUM(C8:C16)","v":1018350},null,{"$f":"SUM(E8:E16)","v":61962.5},{"$f":"SUM(F8:F16)","v":61962.5},{"$f":"SUM(G8:G16)","v":61962.5},61962.5,{"$f":"SUM(I8:I16)","v":55962.5}]
[null,"Inmovilizado Intangible"]
[null,"Propiedad Intelectual",23000,0.2,{"$f":"D19*C19","v":4600},{"$f":"IF($E19<($C19-SUM($E19:E19)),$E19,($C19-SUM($E19:E19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:F19)),$E19,($C19-SUM($E19:F19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:G19)),$E19,($C19-SUM($E19:G19)))","v":4600},{"$f":"IF($E19<($C19-SUM($E19:H19)),$E19,($C19-SUM($E19:H19)))","v":4600}]
[null,"Aplicaciones Informáticas",3500,0.2,{"$f":"D20*C20","v":700},{"$f":"IF($E20<($C20-SUM($E20:E20)),$E20,($C20-SUM($E20:E20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:F20)),$E20,($C20-SUM($E20:F20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:G20)),$E20,($C20-SUM($E20:G20)))","v":700},{"$f":"IF($E20<($C20-SUM($E20:H20)),$E20,($C20-SUM($E20:H20)))","v":700}]
[null,"Otros",2450,0.2,{"$f":"D21*C21","v":490},{"$f":"IF($E21<($C21-SUM($E21:E21)),$E21,($C21-SUM($E21:E21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:F21)),$E21,($C21-SUM($E21:F21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:G21)),$E21,($C21-SUM($E21:G21)))","v":490},{"$f":"IF($E21<($C21-SUM($E21:H21)),$E21,($C21-SUM($E21:H21)))","v":490}]
[null,"Total Inmovilizado Intangible",{"$f":"SUM(C19:C21)","v":28950},null,{"$f":"SUM(E19:E21)","v":5790},{"$f":"SUM(F19:F21)","v":5790},{"$f":"SUM(G19:G21)","v":5790},5790,5790]
[]
[null,"Total Inmovilizado",{"$f":"C17+C22","v":1047300},null,{"$f":"E17+E22","v":67752.5},67752.5,{"$f":"G17+G22","v":67752.5},67752.5,61752.5]
[]
[]
[null,"Total Inversión Inicial"]
[null,"Inmovilizado",{"$f":"C24","v":1047300}]
[null,"Fondo de Maniobra Inicial",{"$f":"'ESTADOS FINANCIEROS'!C34-'ESTADOS FINANCIEROS'!C43","v":61166.666666666664}]
[null,"Total",{"$f":"SUM(C28:C29)","v":1108466.6666666667}]

{"sheet":"FINANCIACIÓN","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Total a Financiar",{"$f":"INVERSIÓN!C30","v":1108466.6666666667},null,null,null,{"$f":"INVERSIÓN!C2","v":"VAN"},{"$f":"INVERSIÓN!D2","v":548675.29532205523}]
[null,null,null,null,null,null,{"$f":"INVERSIÓN!C3","v":"TIR"},{"$f":"INVERSIÓN!D3","v":0.17904917042371715}]
[null,"Composición de la financiación inicial",null,null,null,null,{"$f":"INVERSIÓN!C4","v":"TIR Capital"},{"$f":"INVERSIÓN!D4","v":0.27368271124511612}]
[null,null,"Porcentaje","Coste","Cuantía"]
[null,"Capital",0.4,0.15,{"$f":"C6*$C$2","v":443386.66666666674}]
[null,"Subvención",0.05,null,{"$f":"C7*$C$2","v":55423.333333333343}]
[null,"Deuda",{"$f":"1-C7-C6","v":0.54999999999999993},{"$f":"C13*(1-'ESTADOS FINANCIEROS'!E3)","v":4.1999999999999996E-2},{"$f":"C8*$C$2","v":609656.66666666663}]
[null,null,"CCMP =",{"$f":"D6*C6+D8*C8","v":8.3099999999999993E-2}]
[]
[null,"Datos del préstamo"]
[null,"Cuantía",{"$f":"E8","v":609656.66666666663}]
[null,"Tasa",0.06]
[null,"Duración",10]
[]
[null,"Cuadro de amortización del préstamo"]
[null,"Periodo",1,{"$f":"C17+1","v":2},{"$f":"D17+1","v":3},4,5,6]
[null,"Cap. Pend. Inicial",{"$f":"C12","v":609656.66666666663},{"$f":"C18-C19","v":563403.26015122153},{"$f":"D18-D19","v":514374.64924484969},462404.32168409554,407315.77446969616,{"$f":"G18-G19","v":348921.91442243278}]
[null,"Amortización",{"$f":"IF(C17<=$C$14,-PPMT($C$13,C17,$C$14,$C$12),0)","v":46253.406515445131},{"$f":"IF(D17<=$C$14,-PPMT($C$13,D17,$C$14,$C$12),0)","v":49028.61090637184},51970.327560754151,55088.547214399405,58393.860047263363,{"$f":"IF(H17<=$C$14,-PPMT($C$13,H17,$C$14,$C$12),0)","v":61897.491650099168}]
[null,"Intereses",{"$f":"$C$13*C18","v":36579.399999999994},{"$f":"$C$13*D18","v":33804.195609073293},30862.478954690981,27744.259301045731,24438.94646818177,{"$f":"$C$13*H18","v":20935.314865345965}]
[null,"Cuota",{"$f":"C19+C20","v":82832.806515445118},{"$f":"D19+D20","v":82832.806515445132},82832.806515445132,82832.806515445132,82832.806515445132,82832.806515445132]
[null,"Cap. Pend. Final",{"$f":"C18-C19","v":563403.26015122153},{"$f":"D18-D19","v":514374.64924484969},462404.32168409554,407315.77446969616,348921.91442243278,{"$f":"H18-H19","v":287024.42277233361}]

{"sheet":"INGRESOS Y COSTES","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"FINANCIACIÓN!G2","v":"VAN"},{"$f":"FINANCIACIÓN!H2","v":548675.29532205523}]
[null,{"$f":"FINANCIACIÓN!G3","v":"TIR"},{"$f":"FINANCIACIÓN!H3","v":0.17904917042371715}]
[null,{"$f":"FINANCIACIÓN!G4","v":"TIR Capital"},{"$f":"FINANCIACIÓN!H4","v":0.27368271124511612},{"$f":"INVERSIÓN!E6","v":1},{"$f":"D4+1","v":2},{"$f":"E4+1","v":3},4,5,6]
[null,"IPC",0.03,{"$f":"C5","v":0.03},{"$f":"D5","v":0.03},0.03,0.03,0.03]
[null,"Índice",null,1,{"$f":"D6*(1+D5)","v":1.03},{"$f":"E6*(1+E5)","v":1.0609},1.092727,1.1255088100000001,1.1592740743000001]
[]
[null,"Ingresos",null,{"$f":"D4","v":1},2,3,4,5,6]
[null,"Producto A"]
[null,"Precio",{"$f":"'ANÁLISIS DE RIESGO'!D9","v":50},{"$f":"$C$10*D6","v":50},51.5,53.044999999999995,54.63635,56.275440500000009,57.963703715000001]
[null,"Unidades",5000,{"$f":"C11","v":5000},{"$f":"D11*(1+E12)","v":6250},{"$f":"E11*(1+F12)","v":7500},8625,{"$f":"G11*(1+H12)","v":9056.25},9327.9375]
[null,"Crecimiento",null,null,0.25,0.2,0.15,0.05,{"$f":"'VALORACIÓN Y RENTABILIDAD'!C2","v":0.03}]
[null,"Ingresos",null,{"$f":"D11*D10","v":250000},{"$f":"E11*E10","v":321875},397837.49999999994,{"$f":"G11*G10","v":471238.51874999999},509644.45802812511,{"$f":"I11*I10","v":540681.80552203779}]
[]
[null,"Producto B"]
[null,"Precio",60,{"$f":"$C$16*D6","v":60},61.800000000000004,63.653999999999996,65.56362,67.530528600000011,69.556444458000001]
[null,"Unidades",{"$f":"'ANÁLISIS DE RIESGO'!D10","v":4000},{"$f":"C17","v":4000},{"$f":"D17*(1+E18)","v":5200},{"$f":"E17*(1+F18)","v":6240},{"$f":"F17*(1+G18)","v":7175.9999999999991},{"$f":"G17*(1+H18)","v":7534.7999999999993},7760.8439999999991]
[null,"Crecimiento",null,null,0.3,0.2,0.15,0.05,{"$f":"'VALORACIÓN Y RENTABILIDAD'!C2","v":0.03}]
[null,"Ingresos",null,{"$f":"D17*D16","v":240000},{"$f":"E17*E16","v":321360},397200.95999999996,{"$f":"G17*G16","v":470484.53711999994},508829.02689528005,{"$f":"I17*I16","v":539816.71463320253}]
[]
[null,"Total Ingresos",null,{"$f":"D13+D19","v":490000},643235,795038.46,941723.05586999992,1018473.4849234051,1080498.5201552403]
[]
[null,"Costes Fijos",null,{"$f":"D8","v":1},2,3,4,5,6]
[null,"Personal",{"$f":"'ANÁLISIS DE RIESGO'!D11","v":160000},{"$f":"$C24*D$6","v":160000},164800,169744,174836.32,{"$f":"$C24*H$6","v":180081.40960000001},185483.851888]
[null,"Gastos Generales",35000,35000,36050,37131.5,38245.445,39392.808350000007,40574.5926005]
[null,"Gastos Varios",15000,15000,15450,15913.5,16390.904999999999,16882.632150000001,17389.1111145]
[null,"Gastos de Constitución",2000,{"$f":"C27","v":2000}]
[null,"Total Costes Fijos",null,{"$f":"SUM(D24:D27)","v":212000},{"$f":"SUM(E24:E27)","v":216300},222789,229472.67,{"$f":"SUM(H24:H27)","v":236356.85010000001},243447.55560300002]
[]
[null,"Costes Variables",null,{"$f":"D4","v":1},2,3,4,5,6]
[null,{"$f":"B9","v":"Producto A"}]
[null,"Materias Primas",0.4,{"$f":"$C32*D$13","v":100000},128750,159135,188495.4075,203857.78321125006,216272.72220881513]
[null,"Otros",0.1,25000,32187.5,39783.75,47123.851875,50964.445802812515,54068.180552203783]
[null,{"$f":"\"Variables  \"&B31","v":"Variables  Producto A"},null,{"$f":"SUM(D32:D33)","v":125000},160937.5,198918.75,235619.25937499999,{"$f":"SUM(H32:H33)","v":254822.22901406258},270340.90276101889]
[]
[null,{"$f":"B15","v":"Producto B"}]
[null,"Materias Primas",{"$f":"'ANÁLISIS DE RIESGO'!D13","v":0.45},{"$f":"$C37*D$19","v":108000},144612,178740.432,211718.04170399997,228973.06210287602,242917.52158494113]
[null,"Otros",0.08,19200,25708.799999999999,31776.076799999999,37638.762969599993,40706.322151622408,43185.337170656203]
[null,{"$f":"\"Variables  \"&B36","v":"Variables  Producto B"},null,{"$f":"SUM(D37:D38)","v":127200},170320.8,210516.50880000001,249356.80467359995,{"$f":"SUM(H37:H38)","v":269679.38425449841},286102.85875559732]
[]
[null,"Total Materias Primas",null,{"$f":"D32+D37","v":208000},273362,337875.43200000003,400213.44920399995,432830.84531412611,459190.24379375624]
[]
[null,"Total Costes Variables",null,{"$f":"D34+D39","v":252200},331258.3,409435.25880000001,484976.06404859992,524501.61326856096,556443.76151661621]
[]
[null,"Costes Totales",null,{"$f":"D28+D43","v":464200},547558.30000000005,632224.25879999995,714448.73404859996,760858.463368561,799891.3171196162]

{"sheet":"ESTADOS FINANCIEROS","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Datos para Fondo de Maniobra",null,"Varios"]
[null,"Meses de Existencias",2,"Tasa impositiva",0.3,null,{"$f":"'INGRESOS Y COSTES'!B2","v":"VAN"},{"$f":"'INGRESOS Y COSTES'!C2","v":548675.29532205523}]
[null,"Meses de Cuentas a Cobrar",2,"Interés Activo",0.05,null,{"$f":"'INGRESOS Y COSTES'!B3","v":"TIR"},{"$f":"'INGRESOS Y COSTES'!C3","v":0.17904917042371715}]
[null,"Meses de Tesorería Operativa",1.5,"Dividendos",0.4,null,{"$f":"'INGRESOS Y COSTES'!B4","v":"TIR Capital"},{"$f":"'INGRESOS Y COSTES'!C4","v":0.27368271124511612}]
[null,"Meses de Cuentas a Pagar",1]
[null,null,null,{"$f":"'INGRESOS Y COSTES'!D8","v":1},{"$f":"'INGRESOS Y COSTES'!E8","v":2},{"$f":"'INGRESOS Y COSTES'!F8","v":3},{"$f":"'INGRESOS Y COSTES'!G8","v":4},{"$f":"'INGRESOS Y COSTES'!H8","v":5}]
[null,"Cuenta de Resultados",null,{"$f":"D7","v":1},{"$f":"E7","v":2},3,4,5]
[null,"Ingresos de Explotación",null,{"$f":"'INGRESOS Y COSTES'!D21","v":490000},{"$f":"'INGRESOS Y COSTES'!E21","v":643235},{"$f":"'INGRESOS Y COSTES'!F21","v":795038.46},{"$f":"'INGRESOS Y COSTES'!G21","v":941723.05586999992},{"$f":"'INGRESOS Y COSTES'!H21","v":1018473.4849234051}]
[null," Costes Variables",null,{"$f":"'INGRESOS Y COSTES'!D43","v":252200},{"$f":"'INGRESOS Y COSTES'!E43","v":331258.3},{"$f":"'INGRESOS Y COSTES'!F43","v":409435.25880000001},{"$f":"'INGRESOS Y COSTES'!G43","v":484976.06404859992},{"$f":"'INGRESOS Y COSTES'!H43","v":524501.61326856096}]
[null," Margen Bruto",null,{"$f":"D9-D10","v":237800},{"$f":"E9-E10","v":311976.7},385603.20119999995,{"$f":"G9-G10","v":456746.99182140001},493971.87165484414]
[null," Costes Fijos",null,{"$f":"'INGRESOS Y COSTES'!D28","v":212000},{"$f":"'INGRESOS Y COSTES'!E28","v":216300},{"$f":"'INGRESOS Y COSTES'!F28","v":222789},{"$f":"'INGRESOS Y COSTES'!G28","v":229472.67},{"$f":"'INGRESOS Y COSTES'!H28","v":236356.85010000001}]
[null," Amortización",null,{"$f":"INVERSIÓN!E24","v":67752.5},{"$f":"INVERSIÓN!F24","v":67752.5},{"$f":"INVERSIÓN!G24","v":67752.5},{"$f":"INVERSIÓN!H24","v":67752.5},{"$f":"INVERSIÓN!I24","v":61752.5}]
[null,"  BAIT",null,{"$f":"D11-D12-D13","v":-41952.5},{"$f":"E11-E12-E13","v":27924.200000000012},95061.701199999952,{"$f":"G11-G12-G13","v":159521.82182139999},195862.52155484413]
[null,"Imputación de la Subvención",null,{"$f":"C40/5","v":11084.666666666668},{"$f":"D15","v":11084.666666666668},11084.666666666668,{"$f":"F15","v":11084.666666666668},{"$f":"G15","v":11084.666666666668}]
[null,"  Gastos Financieros",null,{"$f":"FINANCIACIÓN!C20","v":36579.399999999994},{"$f":"FINANCIACIÓN!D20","v":33804.195609073293},{"$f":"FINANCIACIÓN!E20","v":30862.478954690981},{"$f":"FINANCIACIÓN!F20","v":27744.259301045731},{"$f":"FINANCIACIÓN!G20","v":24438.94646818177}]
[null,"Ingresos Financieros",null,{"$f":"$E$4*C35","v":4.0017766878008846E-12},{"$f":"$E$4*D35","v":-1.1641532182693482E-11},0,2421.4658938758776,6946.9578239782295]
[null,"  BAT",null,{"$f":"D14+D15-D16+D17","v":-67447.233333333323},{"$f":"E14+E15-E16+E17","v":5204.6710575933785},75283.888911975635,145283.69508089678,189455.19957730727]
[null,"Base Imponible",null,{"$f":"D18","v":-67447.233333333323},{"$f":"IF(D19<0,E18+D19,E18)","v":-62242.562275739947},13041.326636235688,{"$f":"IF(F19<0,G18+F19,G18)","v":145283.69508089678},{"$f":"IF(G19<0,H18+G19,H18)","v":189455.19957730727}]
[null,"  Impuestos",null,{"$f":"MAX(0,$E$3*D19)","v":0},{"$f":"MAX(0,$E$3*E19)","v":0},{"$f":"MAX(0,$E$3*F19)","v":3912.3979908707061},{"$f":"MAX(0,$E$3*G19)","v":43585.108524269031},{"$f":"MAX(0,$E$3*H19)","v":56836.559873192178}]
[null,"  BDT",null,{"$f":"D18-D20","v":-67447.233333333323},{"$f":"E18-E20","v":5204.6710575933785},71371.490921104923,{"$f":"G18-G20","v":101698.58655662775},132618.63970411511]
[null,"Dividendos",null,null,{"$f":"MAX(0,$E$5*D21)","v":0},{"$f":"MAX(0,$E$5*E21)","v":2081.8684230373515},{"$f":"MAX(0,$E$5*F21)","v":28548.596368441969},{"$f":"MAX(0,$E$5*G21)","v":40679.434622651104}]
[null,"Beneficio retenido",null,{"$f":"D21-D22","v":-67447.233333333323},{"$f":"E21-E22","v":5204.6710575933785},69289.622498067576,73149.99018818578,91939.205081463995]
[]
[null,"Balance","Inicio",{"$f":"D7","v":1},{"$f":"E7","v":2},{"$f":"F7","v":3},{"$f":"G7","v":4},{"$f":"H7","v":5}]
[null,"Inmovilizado Material",{"$f":"INVERSIÓN!C17","v":1018350},{"$f":"C26","v":1018350},{"$f":"D26","v":1018350},{"$f":"E26","v":1018350},{"$f":"F26","v":1018350},{"$f":"G26","v":1018350}]
[null,"(Amortización Acumulada)",null,{"$f":"C27+INVERSIÓN!E17","v":61962.5},{"$f":"D27+INVERSIÓN!F17","v":123925},{"$f":"E27+INVERSIÓN!G17","v":185887.5},{"$f":"F27+INVERSIÓN!H17","v":247850},{"$f":"G27+INVERSIÓN!I17","v":303812.5}]
[null,"Inmovilizado Intangible",{"$f":"INVERSIÓN!C22","v":28950},{"$f":"C28","v":28950},{"$f":"D28","v":28950},{"$f":"E28","v":28950},{"$f":"F28","v":28950},{"$f":"G28","v":28950}]
[null,"(Amortización Acumulada)",null,{"$f":"C29+INVERSIÓN!E22","v":5790},{"$f":"D29+INVERSIÓN!F22","v":11580},{"$f":"E29+INVERSIÓN!G22","v":17370},{"$f":"F29+INVERSIÓN!H22","v":23160},{"$f":"G29+INVERSIÓN!I22","v":28950}]
[null,"Inmovilizado Neto",{"$f":"C26+C28-C27-C29","v":1047300},{"$f":"D26+D28-D27-D29","v":979547.5},911795,{"$f":"F26+F28-F27-F29","v":844042.5},776290,714537.5]
[null,"Existencias",{"$f":"$C$3/12*'INGRESOS Y COSTES'!D41","v":34666.666666666664},{"$f":"$C$3/12*'INGRESOS Y COSTES'!E41","v":45560.333333333328},{"$f":"$C$3/12*'INGRESOS Y COSTES'!F41","v":56312.572},{"$f":"$C$3/12*'INGRESOS Y COSTES'!G41","v":66702.241533999986},{"$f":"$C$3/12*'INGRESOS Y COSTES'!H41","v":72138.474219021009},{"$f":"$C$3/12*'INGRESOS Y COSTES'!I41","v":76531.707298959373}]
[null,"Cuentas a Cobrar",null,{"$f":"$C$4/12*'INGRESOS Y COSTES'!D21","v":81666.666666666657},{"$f":"$C$4/12*'INGRESOS Y COSTES'!E21","v":107205.83333333333},{"$f":"$C$4/12*'INGRESOS Y COSTES'!F21","v":132506.40999999997},{"$f":"$C$4/12*'INGRESOS Y COSTES'!G21","v":156953.84264499997},{"$f":"$C$4/12*'INGRESOS Y COSTES'!H21","v":169745.5808205675}]
[null,"Tesorería Operativa",{"$f":"$C$5/12*'INGRESOS Y COSTES'!D28","v":26500},{"$f":"$C$5/12*'INGRESOS Y COSTES'!E28","v":27037.5},{"$f":"$C$5/12*'INGRESOS Y COSTES'!F28","v":27848.625},{"$f":"$C$5/12*'INGRESOS Y COSTES'!G28","v":28684.083750000002},{"$f":"$C$5/12*'INGRESOS Y COSTES'!H28","v":29544.606262500001},{"$f":"$C$5/12*'INGRESOS Y COSTES'!I28","v":30430.944450375002}]
[null,"Activo Corriente",{"$f":"SUM(C31:C33)","v":61166.666666666664},{"$f":"SUM(D31:D33)","v":154264.5},191367.03033333333,{"$f":"SUM(F31:F33)","v":227892.73528399994},258636.92312652097,276708.23256990185]
[null,"Excedente de Tesorería",{"$f":"C45-C30-C34","v":8.0035533756017685E-11},-2.3283064365386963E-10,0,48429.317877517547,138939.15647956458,222199.95419597079]
[null,"Total Activo",{"$f":"C30+C34+C35","v":1108466.6666666667},{"$f":"D30+D34+D35","v":1133811.9999999998},1103162.0303333334,{"$f":"F30+F34+F35","v":1120364.5531615175},1173866.0796060856,1213445.6867658726]
[]
[null,"Capital",{"$f":"FINANCIACIÓN!E6","v":443386.66666666674},{"$f":"MAX(C38,D30+D34-D39-D40-D42-D43-D44)","v":554833.97318211175},{"$f":"MAX(D38,E30+E34-E39-E40-E42-E43-E44)","v":572146.0850308903},{"$f":"MAX(E38,F30+F34-F39-F40-F42-F43-F44)","v":572146.0850308903},{"$f":"MAX(F38,G30+G34-G39-G40-G42-G43-G44)","v":572146.0850308903},{"$f":"MAX(G38,H30+H34-H39-H40-H42-H43-H44)","v":572146.0850308903}]
[null,"Reservas",null,{"$f":"C39+D23","v":-67447.233333333323},{"$f":"D39+E23","v":-62242.562275739947},7047.0602223276292,80197.050410513417,172136.25549197741]
[null,"Subvención",{"$f":"FINANCIACIÓN!E7","v":55423.333333333343},{"$f":"C40-D15","v":44338.666666666672},{"$f":"D40-E15","v":33254},{"$f":"E40-F15","v":22169.333333333332},{"$f":"F40-G15","v":11084.666666666664},{"$f":"G40-H15","v":0}]
[null,"Patrimonio Neto",{"$f":"C38+C39+C40","v":498810.00000000012},{"$f":"D38+D39+D40","v":531725.40651544509},543157.52275515033,{"$f":"F38+F39+F40","v":601362.47858655127},{"$f":"G38+G39+G40","v":663427.80210807035},{"$f":"H38+H39+H40","v":744282.34052286774}]
[null,"Deuda",{"$f":"FINANCIACIÓN!E8","v":609656.66666666663},{"$f":"FINANCIACIÓN!C22","v":563403.26015122153},{"$f":"FINANCIACIÓN!D22","v":514374.64924484969},{"$f":"FINANCIACIÓN!E22","v":462404.32168409554},{"$f":"FINANCIACIÓN!F22","v":407315.77446969616},{"$f":"FINANCIACIÓN!G22","v":348921.91442243278}]
[null,"Cuentas a Pagar",null,{"$f":"$C$6/12*'INGRESOS Y COSTES'!D45","v":38683.333333333328},{"$f":"$C$6/12*'INGRESOS Y COSTES'!E45","v":45629.858333333337},{"$f":"$C$6/12*'INGRESOS Y COSTES'!F45","v":52685.354899999991},{"$f":"$C$6/12*'INGRESOS Y COSTES'!G45","v":59537.394504049997},{"$f":"$C$6/12*'INGRESOS Y COSTES'!H45","v":63404.871947380081}]
[null,"Hacienda",null,{"$f":"D20","v":0},{"$f":"E20","v":0},{"$f":"F20","v":3912.3979908707061},{"$f":"G20","v":43585.108524269031},{"$f":"H20","v":56836.559873192178}]
[null,"Total Patrimonio Neto y Pasivo",{"$f":"SUM(C41:C44)","v":1108466.6666666667},{"$f":"SUM(D41:D44)","v":1133811.9999999998},1103162.0303333334,{"$f":"SUM(F41:F44)","v":1120364.5531615175},1173866.0796060856,1213445.6867658726]
[]
[null,"Fondo de Maniobra Operativo",{"$f":"C34-C43-C44","v":61166.666666666664},115581.16666666667,145737.17199999999,171294.98239312926,155514.42009820195,156466.80074932962]
[]
[null,"Deuda Neta",{"$f":"C42-C35","v":609656.66666666651},{"$f":"D42-D35","v":563403.26015122177},514374.64924484969,413975.003806578,268376.61799013161,126721.96022646199]

{"sheet":"VALORACIÓN Y RENTABILIDAD","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Crecimiento Residual",0.03,null,"VAN",{"$f":"NPV(C5,D15:H15)+C15","v":548675.29532205523}]
[null,"Reinversión Residual",0.3,null,"TIR",{"$f":"IRR(C15:H15)","v":0.17904917042371715}]
[null,"Rentabilidad Residual implícita",{"$f":"C2/C3","v":0.1},null,"TIR Capital",{"$f":"IRR(C26:H26)","v":0.27368271124511612}]
[null,"CCMP",{"$f":"FINANCIACIÓN!D9","v":8.3099999999999993E-2}]
[]
[null,"Flujos del Proyecto"]
[null,null,{"$f":"'ESTADOS FINANCIEROS'!C25","v":"Inicio"},{"$f":"'ESTADOS FINANCIEROS'!D25","v":1},{"$f":"'ESTADOS FINANCIEROS'!E25","v":2},{"$f":"'ESTADOS FINANCIEROS'!F25","v":3},{"$f":"'ESTADOS FINANCIEROS'!G25","v":4},{"$f":"'ESTADOS FINANCIEROS'!H25","v":5}]
[null,"BAIT",null,{"$f":"'ESTADOS FINANCIEROS'!D14","v":-41952.5},{"$f":"'ESTADOS FINANCIEROS'!E14","v":27924.200000000012},{"$f":"'ESTADOS FINANCIEROS'!F14","v":95061.701199999952},{"$f":"'ESTADOS FINANCIEROS'!G14","v":159521.82182139999},{"$f":"'ESTADOS FINANCIEROS'!H14","v":195862.52155484413}]
[null,"NOPAT",null,{"$f":"D9*(1-'ESTADOS FINANCIEROS'!D20/'ESTADOS FINANCIEROS'!D18)","v":-41952.5},{"$f":"E9*(1-'ESTADOS FINANCIEROS'!E20/'ESTADOS FINANCIEROS'!E18)","v":27924.200000000012},{"$f":"F9*(1-'ESTADOS FINANCIEROS'!F20/'ESTADOS FINANCIEROS'!F18)","v":90121.478077115171},{"$f":"G9*(1-'ESTADOS FINANCIEROS'!G20/'ESTADOS FINANCIEROS'!G18)","v":111665.27527497998},{"$f":"H9*(1-'ESTADOS FINANCIEROS'!H20/'ESTADOS FINANCIEROS'!H18)","v":137103.76508839088}]
[null,"  + Amortización",null,{"$f":"'ESTADOS FINANCIEROS'!D13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!E13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!F13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!G13","v":67752.5},{"$f":"'ESTADOS FINANCIEROS'!H13","v":61752.5}]
[null,"  - Ajuste Fondo de Maniobra",{"$f":"'ESTADOS FINANCIEROS'!C47","v":61166.666666666664},{"$f":"'ESTADOS FINANCIEROS'!D47-'ESTADOS FINANCIEROS'!C47","v":54414.500000000007},{"$f":"'ESTADOS FINANCIEROS'!E47-'ESTADOS FINANCIEROS'!D47","v":30156.00533333332},{"$f":"'ESTADOS FINANCIEROS'!F47-'ESTADOS FINANCIEROS'!E47","v":25557.810393129272},{"$f":"'ESTADOS FINANCIEROS'!G47-'ESTADOS FINANCIEROS'!F47","v":-15780.562294927309},{"$f":"'ESTADOS FINANCIEROS'!H47-'ESTADOS FINANCIEROS'!G47","v":952.38065112766344}]
[null,"  -  Inversiones Inmovilizado",{"$f":"'ESTADOS FINANCIEROS'!C30","v":1047300}]
[null,"  + Valor en Continuidad",null,null,null,null,null,{"$f":"H10*(1+C2)*(1-C3)/(C5-C2)","v":1861616.0947030098}]
[null,"Flujo Neto de Caja del Proyecto",{"$f":"C10+C11-C12-C13+C14","v":-1108466.6666666667},{"$f":"D10+D11-D12-D13+D14","v":-28614.500000000007},65520.694666666692,132316.1676839859,195198.33756990731,2059519.9791402731]
[]
[null,"Flujos del Capital"]
[null,null,{"$f":"C8","v":"Inicio"},1,2,3,4,5]
[null,"BDT",null,{"$f":"'ESTADOS FINANCIEROS'!D21","v":-67447.233333333323},{"$f":"'ESTADOS FINANCIEROS'!E21","v":5204.6710575933785},{"$f":"'ESTADOS FINANCIEROS'!F21","v":71371.490921104923},{"$f":"'ESTADOS FINANCIEROS'!G21","v":101698.58655662775},{"$f":"'ESTADOS FINANCIEROS'!H21","v":132618.63970411511}]
[null,"  + Amortización",null,{"$f":"D11","v":67752.5},67752.5,67752.5,67752.5,61752.5]
[null,"  - Ajuste Fondo de Maniobra",{"$f":"C12","v":61166.666666666664},54414.500000000007,30156.00533333332,25557.810393129272,-15780.562294927309,952.38065112766344]
[null,"  +  Ajuste Deuda Neta",{"$f":"'ESTADOS FINANCIEROS'!C49","v":609656.66666666651},{"$f":"'ESTADOS FINANCIEROS'!D49-'ESTADOS FINANCIEROS'!C49","v":-46253.406515444745},{"$f":"'ESTADOS FINANCIEROS'!E49-'ESTADOS FINANCIEROS'!D49","v":-49028.61090637208},{"$f":"'ESTADOS FINANCIEROS'!F49-'ESTADOS FINANCIEROS'!E49","v":-100399.64543827169},{"$f":"'ESTADOS FINANCIEROS'!G49-'ESTADOS FINANCIEROS'!F49","v":-145598.38581644639},{"$f":"'ESTADOS FINANCIEROS'!H49-'ESTADOS FINANCIEROS'!G49","v":-141654.65776366962}]
[null,"  + Ajuste Subvención",{"$f":"'ESTADOS FINANCIEROS'!C40","v":55423.333333333343},{"$f":"-'ESTADOS FINANCIEROS'!D15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!E15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!F15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!G15","v":-11084.666666666668},{"$f":"-'ESTADOS FINANCIEROS'!H15","v":-11084.666666666668}]
[null,"  -  Inversiones Inmovilizado",{"$f":"C13","v":1047300}]
[null," + Valor en Continuidad",null,null,null,null,null,{"$f":"H14-'ESTADOS FINANCIEROS'!H49","v":1734894.1344765478}]
[null,"Flujo Neto de Caja del Capital",{"$f":"C19+C20-C21+C22+C23-C24+C25","v":-443386.66666666674},{"$f":"D19+D20-D21+D22+D23-D24+D25","v":-111447.30651544475},-17312.111848778684,2081.8684230372783,28548.596368442017,1775573.569099199]
[]
[null,null,"Tasa",{"$f":"F2","v":548675.29532205523},null,"Tasa","VAN"]
[null,null,0.06,1798708.4536742794,null,7.0000000000000007E-2,{"$f":"NPV(F29,$D$15:$H$15)+$C$15","v":647353.68758207629}]
[null,null,7.0000000000000007E-2,1082046.5817336163,null,0.08,571399.99800087488]
[null,null,0.08,649953.04527058755,null,0.09,499431.41379168583]
[null,null,0.09,360290.29993533739,null,0.1,431203.54246964795]
[null,null,0.1,152132.12143371301,null,0.11,366489.06939784647]
[null,null,0.11,-4992.7159336148761,null,0.12,305076.42233747733]
[null,null,0.12,-128019.27420323389,null,0.13,246768.55127881351]
[null,null,0.13,-227114.03532454802,null,0.14000000000000001,191381.81268438813]
[null,null,0.14000000000000001,-308751.11621527269,null,0.15,138744.94838531199]
[null,null,0.15,-377250.40999601909,null,0.16,88698.150359261548]
[null,null,0.16,-435605.84401762811,null,0.17,41092.203499029856]
[null,null,0.17,-485958.69380028138,null,0.18,-4212.300734321354]
[null,null,0.18,-529881.5913764768,null,0.19,-47345.686178339645]

{"sheet":"ANÁLISIS DE RIESGO","index":5,"n_rows":590,"n_cols":10,"rows_kept":590,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"C3","v":"Base"},"Medio"]
[null,null,null,null,null,"VAN",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F2","v":548675.29532205523},{"$f":"C86","v":538498.69263721746}]
[null,"Escenario","Base",null,null,"TIR",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F3","v":0.17904917042371715},{"$f":"D86","v":0.17641214564917274}]
[null,null,null,null,null,"TIR Capital",{"$f":"'VALORACIÓN Y RENTABILIDAD'!F4","v":0.27368271124511612},{"$f":"E86","v":0.26912877534157242}]
[]
[]
[null,"Variables consideradas en el análisis de riesgo"]
[null,null,null,null,"Pesimista","Base","Optmista","Aleatorio","Pesimista","Optimista"]
[null,null,"Precio Producto A",{"$f":"IF($C$3=$E$8,E9,IF($C$3=$F$8,F9,IF($C$3=$G$8,G9,H9)))","v":50},47,50,53,{"$f":"RANDBETWEEN(E9*10,G9*10)/10","v":48.3},{"$f":"(E9-F9)/F9","v":-0.06},{"$f":"(G9-F9)/F9","v":0.06}]
[null,null,"Cuantía Producto B",{"$f":"IF($C$3=$E$8,E10,IF($C$3=$F$8,F10,IF($C$3=$G$8,G10,H10)))","v":4000},3800,4000,4200,{"$f":"RANDBETWEEN(E10,G10)","v":4082},{"$f":"(E10-F10)/F10","v":-0.05},{"$f":"(G10-F10)/F10","v":0.05}]
[null,null,"Personal",{"$f":"IF($C$3=$E$8,E11,IF($C$3=$F$8,F11,IF($C$3=$G$8,G11,H11)))","v":160000},180000,160000,140000,{"$f":"RANDBETWEEN(G11,E11)","v":162980},{"$f":"-(E11-F11)/F11","v":-0.125},{"$f":"-(G11-F11)/F11","v":0.125}]
[null,null,"Coste Edificios",{"$f":"IF($C$3=$E$8,E12,IF($C$3=$F$8,F12,IF($C$3=$G$8,G12,H12)))","v":430000},460000,430000,400000,{"$f":"RANDBETWEEN(G12,E12)","v":411755},{"$f":"-(E12-F12)/F12","v":-6.9767441860465115E-2},{"$f":"-(G12-F12)/F12","v":6.9767441860465115E-2}]
[null,null,"Coste Materias Producto B",{"$f":"IF($C$3=$E$8,E13,IF($C$3=$F$8,F13,IF($C$3=$G$8,G13,H13)))","v":0.45},0.5,0.45,0.4,{"$f":"RANDBETWEEN(G13*1000,E13*1000)/1000","v":0.496},{"$f":"-(E13-F13)/F13","v":-0.11111111111111108},0.11111111111111108]
[]
[null,"Análisis de Escenarios"]
[null,null,null,null,{"$f":"E8","v":"Pesimista"},{"$f":"F8","v":"Base"},{"$f":"G8","v":"Optmista"}]
[null,null,null,{"$f":"G2","v":548675.29532205523},87028.849755040603,548675.29532205523,1249621.5290571579]
[null,null,null,{"$f":"G3","v":0.17904917042371715},9.9130239193384595E-2,0.17904917042371715,0.28051762944602276]
[null,null,null,{"$f":"G4","v":0.27368271124511612},0.14483199324730012,0.27368271124511612,0.4214683405406221]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Análsisi de Sensibilidad"]
[]
[null,{"$f":"C9","v":"Precio Producto A"},{"$f":"E9","v":47},{"$f":"F9","v":50},{"$f":"G9","v":53}]
[null,{"$f":"IF(C3=F8,G2,0)","v":548675.29532205523},421227.5316333794,548675.29532205523,675560.45632333541]
[null,{"$f":"C10","v":"Cuantía Producto B"},{"$f":"E10","v":3800},{"$f":"F10","v":4000},{"$f":"G10","v":4200}]
[null,{"$f":"IF(C3=F8,G2,0)","v":548675.29532205523},449716.41448187525,548675.29532205523,647328.16548004001]
[null,{"$f":"C11","v":"Personal"},{"$f":"E11","v":180000},{"$f":"F11","v":160000},{"$f":"G11","v":140000}]
[null,{"$f":"IF(C3=F8,G2,0)","v":548675.29532205523},339196.69454581244,548675.29532205523,756535.37645383365]
[null,{"$f":"C12","v":"Coste Edificios"},{"$f":"E12","v":460000},{"$f":"F12","v":430000},{"$f":"G12","v":400000}]
[null,{"$f":"IF(C3=F8,G2,0)","v":548675.29532205523},514256.46719429502,548675.29532205523,583118.69138674205]
[null,{"$f":"C13","v":"Coste Materias Producto B"},{"$f":"E13","v":0.5},{"$f":"F13","v":0.45},{"$f":"G13","v":0.4}]
[null,{"$f":"IF(C3=F8,G2,0)","v":548675.29532205523},325656.57994474005,548675.29532205523,770580.10493898788]
[]
[null,"Resumen",{"$f":"E8","v":"Pesimista"},{"$f":"F8","v":"Base"},{"$f":"G8","v":"Optmista"},"Jerarquía"]
[null,{"$f":"B38","v":"Precio Producto A"},{"$f":"C39","v":421227.5316333794},{"$f":"D39","v":548675.29532205523},675560.45632333541,{"$f":"RANK(C50,$C$50:$C$54)","v":3}]
[null,{"$f":"B40","v":"Cuantía Producto B"},{"$f":"C41","v":449716.41448187525},{"$f":"D41","v":548675.29532205523},647328.16548004001,{"$f":"RANK(C51,$C$50:$C$54)","v":2}]
[null,{"$f":"B42","v":"Personal"},{"$f":"C43","v":339196.69454581244},{"$f":"D43","v":548675.29532205523},756535.37645383365,4]
[null,{"$f":"B44","v":"Coste Edificios"},{"$f":"C45","v":514256.46719429502},{"$f":"D45","v":548675.29532205523},583118.69138674205,1]
[null,{"$f":"B46","v":"Coste Materias Producto B"},{"$f":"C47","v":325656.57994474005},{"$f":"D47","v":548675.29532205523},770580.10493898788,5]
[]
[null,"Reordenación",{"$f":"C49","v":"Pesimista"},{"$f":"E49","v":"Optmista"},"Pesmimista *","Optimista *"]
[null,{"$f":"OFFSET(B$49,MATCH(1,$F$50:$F$54,0),0)","v":"Coste Edificios"},{"$f":"OFFSET(C$49,MATCH(1,$F$50:$F$54,0),0)","v":514256.46719429502},{"$f":"OFFSET(E$49,MATCH(1,$F$50:$F$54,0),0)","v":583118.69138674205},{"$f":"C57-$D$50","v":-34418.828127760207},{"$f":"D57-$D$50","v":34443.396064686822}]
[null,{"$f":"OFFSET(B$49,MATCH(2,$F$50:$F$54,0),0)","v":"Cuantía Producto B"},{"$f":"OFFSET(C$49,MATCH(2,$F$50:$F$54,0),0)","v":449716.41448187525},{"$f":"OFFSET(E$49,MATCH(2,$F$50:$F$54,0),0)","v":647328.16548004001},{"$f":"C58-$D$50","v":-98958.880840179976},{"$f":"D58-$D$50","v":98652.870157984784}]
[null,{"$f":"OFFSET(B$49,MATCH(3,$F$50:$F$54,0),0)","v":"Precio Producto A"},{"$f":"OFFSET(C$49,MATCH(3,$F$50:$F$54,0),0)","v":421227.5316333794},{"$f":"OFFSET(E$49,MATCH(3,$F$50:$F$54,0),0)","v":675560.45632333541},-127447.76368867583,126885.16100128018]
[null,{"$f":"OFFSET(B$49,MATCH(4,$F$50:$F$54,0),0)","v":"Personal"},{"$f":"OFFSET(C$49,MATCH(4,$F$50:$F$54,0),0)","v":339196.69454581244},{"$f":"OFFSET(E$49,MATCH(4,$F$50:$F$54,0),0)","v":756535.37645383365},-209478.60077624279,207860.08113177842]
[null,{"$f":"OFFSET(B$49,MATCH(5,$F$50:$F$54,0),0)","v":"Coste Materias Producto B"},{"$f":"OFFSET(C$49,MATCH(5,$F$50:$F$54,0),0)","v":325656.57994474005},{"$f":"OFFSET(E$49,MATCH(5,$F$50:$F$54,0),0)","v":770580.10493898788},-223018.71537731518,221904.80961693265]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Simulación de Monte Carlo"]
[]
[null,null,{"$f":"F2","v":"VAN"},{"$f":"F3","v":"TIR"},{"$f":"F4","v":"TIR Capital"}]
[null,"Máximo",{"$f":"MAX(C91:C590)","v":989386.85487600695},{"$f":"MAX(D91:D590)","v":0.24383663782039866},0.37023699360307583]
[null,"Mínimo",{"$f":"MIN(C91:C590)","v":91135.81348561286},{"$f":"MIN(D91:D590)","v":0.10038966585883613},0.14864810312655785]
[null,"Promedio",{"$f":"AVERAGE(C91:C590)","v":538498.69263721746},{"$f":"AVERAGE(D91:D590)","v":0.17641214564917274},0.26912877534157242]
[null,"Desviación Típica",{"$f":"STDEV(C91:C590)","v":201084.29756840173},{"$f":"STDEV(D91:D590)","v":3.1985267854973597E-2},4.9713313320185644E-2]
[]
[null,null,{"$f":"C83","v":"VAN"},{"$f":"D83","v":"TIR"},"TIR Capital"]
[null,null,{"$f":"G2","v":548675.29532205523},{"$f":"G3","v":0.17904917042371715},{"$f":"G4","v":0.27368271124511612}]
[null,"Sim.1",448046.76918157493,0.16345872271849915,0.24850996493435895]
[null,"Sim.2",513823.04005872877,0.17388514347107664,0.26621748948543744]
[null,"Sim.3",679985.33147490444,0.19953864635232366,0.30660078770175581]
[null,"Sim.4",348315.76938847639,0.14684810569990336,0.22291113819563457]
[null,"Sim.5",440901.58414000575,0.16101274457187809,0.24585490347462091]
[null,"Sim.6",458809.77845868538,0.16491089383511337,0.25066347584656423,null,null,"Frec. Acum.","Frecuencia"]
[null,"Sim.7",557244.00510294549,0.1810750881764962,0.2753300171612223,null,{"$f":"C85","v":91135.81348561286},{"$f":"COUNTIF($C$91:$C$590,\"<=\"&G97)/500","v":2E-3},{"$f":"H97","v":2E-3}]
[null,"Sim.8",268448.88085590932,0.13209645628687894,0.19979754152072471,null,{"$f":"G97+($C$84-$C$85)/20","v":136048.36555513256},{"$f":"COUNTIF($C$91:$C$590,\"<=\"&G98)/500","v":1.7999999999999999E-2},{"$f":"H98-H97","v":1.6E-2}]
[null,"Sim.9",642015.05208258494,0.19473849865940385,0.29878411443846109,null,180960.91762465227,4.2000000000000003E-2,{"$f":"H99-H98","v":2.4000000000000004E-2}]
[null,"Sim.10",783863.53677169397,0.21438214749150997,0.32848012348872047,null,225873.46969417197,6.2E-2,1.9999999999999997E-2]
[null,"Sim.11",436191.65124111157,0.1615441900532717,0.2461549138983552,null,270786.02176369168,9.4E-2,3.2000000000000001E-2]
[null,"Sim.12",681580.84045031271,0.19812253501881405,0.30475600187772312,null,315698.57383321138,0.154,0.06]
[null,"Sim.13",133235.16979346867,0.10887306301380906,0.16252540574164365,null,360611.12590273109,0.20399999999999999,4.9999999999999989E-2]
[null,"Sim.14",480508.3951977503,0.16940229802851214,0.25882398722943001,null,405523.67797225079,0.28000000000000003,7.600000000000004E-2]
[null,"Sim.15",606481.07064350857,0.18890723947365617,0.287649300898845,null,450436.2300417705,0.33,4.9999999999999989E-2]
[null,"Sim.16",817700.21747313021,0.21850914097564722,0.33368411538071707,null,495348.7821112902,0.42599999999999999,9.5999999999999974E-2]
[null,"Sim.17",801903.71981261508,0.21901222767781392,0.33507152155871367,null,540261.33418080991,0.51,8.4000000000000019E-2]
[null,"Sim.18",579942.92882071319,0.18268225128028259,0.27924040611345036,null,585173.88625032967,0.59,7.999999999999996E-2]
[null,"Sim.19",633613.22470252705,0.19052149768177595,0.29009649492852407,null,630086.43831984932,0.65800000000000003,6.800000000000006E-2]
[null,"Sim.20",607718.3895755976,0.18970938471153187,0.29133356506973018,null,674998.99038936896,0.73399999999999999,7.5999999999999956E-2]
[null,"Sim.21",627842.0074542542,0.19102398294270384,0.29259714576062601,null,719911.54245888861,0.80200000000000005,6.800000000000006E-2]
[null,"Sim.22",574050.81174167944,0.18456934688005822,0.28172817713357734,null,764824.09452840826,0.84799999999999998,4.599999999999993E-2]
[null,"Sim.23",233663.85064397031,0.12795428659347041,0.19346211350680886,null,809736.6465979279,0.90400000000000003,5.600000000000005E-2]
[null,"Sim.24",522241.15078403964,0.17480612654483663,0.26655025031227186,null,854649.19866744755,0.94399999999999995,3.9999999999999925E-2]
[null,"Sim.25",459895.13712325343,0.16387566617240101,0.24946149135403317,null,899561.75073696719,0.96399999999999997,2.0000000000000018E-2]
[null,"Sim.26",347925.83885660442,0.14502230018243134,0.22026948092395626,null,944474.30280648684,0.97799999999999998,1.4000000000000012E-2]
[null,"Sim.27",541384.29932172876,0.17914005880935235,0.27445789341701454,null,989386.85487600649,0.998,2.0000000000000018E-2]
[null,"Sim.28",722468.82266529836,0.20522629228552325,0.31421473439680225]
[null,"Sim.29",712839.0088014577,0.20315940331016868,0.31100912736508035]
[null,"Sim.30",808780.44487090595,0.21938407711724395,0.3357066530663193]
[null,"Sim.31",560447.59616651852,0.18094210669612498,0.27627435330516237]
[null,"Sim.32",248844.32452109456,0.13007124376330892,0.19610029640986504]
[null,"Sim.33",459332.2130096152,0.16429600882185369,0.25029389037997318]
[null,"Sim.34",473723.55446291785,0.1689172643402832,0.2576448780872691]
[null,"Sim.35",734395.62781448173,0.2096913458474543,0.32064012307038281]
[null,"Sim.36",731150.53290907806,0.20961616326375299,0.32113986186247478]
[null,"Sim.37",451826.89780023997,0.16513495136095546,0.25161333936866925]
[null,"Sim.38",767160.17521912721,0.21231200606500011,0.32565301926339041]
[null,"Sim.39",887684.88292904873,0.23078161351929816,0.35191004576651919]
[null,"Sim.40",810423.02786878427,0.21920256295238127,0.33352898111905382]
[null,"Sim.41",771205.13837077864,0.21169984364155048,0.32449135849998889]
[null,"Sim.42",459979.58318742574,0.16432822226794697,0.24997093098626788]
[null,"Sim.43",764578.08390345331,0.21391830552194091,0.32760612372215947]
[null,"Sim.44",721165.00336080976,0.20672478476944178,0.31682830626078706]
[null,"Sim.45",764693.70173481503,0.20952382915049017,0.32171758809033091]
[null,"Sim.46",774954.42428676551,0.21316065064240552,0.32607534261800808]
[null,"Sim.47",707458.47550263396,0.20484684679449217,0.31330734486358591]
[null,"Sim.48",451297.01506056474,0.16495716264476212,0.2528435834069851]
[null,"Sim.49",581745.06185054174,0.18610567986919468,0.28375589325471462]
[null,"Sim.50",367343.59135810402,0.15013435053838053,0.22788024201085122]
[null,"Sim.51",704700.85981235048,0.20019119677771902,0.30596890623662798]
[null,"Sim.52",511657.28172352863,0.17109182622092045,0.26064646034168448]
[null,"Sim.53",485130.16611955781,0.17024365797265362,0.25990276190014283]
[null,"Sim.54",659739.26245601778,0.19545150429236302,0.30038434946834469]
[null,"Sim.55",207102.81413353956,0.12247256910783944,0.18442643144095805]
[null,"Sim.56",555743.64399288408,0.17880720499247094,0.27377201760447134]
[null,"Sim.57",810847.83267251123,0.21975704357533288,0.33579724344504536]
[null,"Sim.58",526679.61722701858,0.17530119830273949,0.2675356777000204]
[null,"Sim.59",275263.45254634111,0.13368091996031617,0.20256580171479688]
[null,"Sim.60",297014.26597775752,0.13651974050978954,0.20697622132965932]
[null,"Sim.61",119026.40522230766,0.10553923634411277,0.15688774451618559]
[null,"Sim.62",929963.01870870008,0.23607161323573855,0.35916690712742172]
[null,"Sim.63",326714.72633826244,0.14307352441915677,0.21695671540186368]
[null,"Sim.64",616489.27358398237,0.18877121516848261,0.2892680230340301]
[null,"Sim.65",832831.80062295217,0.22105474221774268,0.33804604835819685]
[null,"Sim.66",449288.74921195791,0.16331655898096598,0.25031425732433643]
[null,"Sim.67",370502.68897605594,0.15147326729351529,0.23025506833762699]
[null,"Sim.68",651658.86326576467,0.19522705599030132,0.2997471771016722]
[null,"Sim.69",507605.70301159471,0.17413601099801679,0.2662658461677283]
[null,"Sim.70",515216.15982680768,0.17474069793522506,0.26778056577219767]
[null,"Sim.71",966661.44426924968,0.24321625780683553,0.36889544098546723]
[null,"Sim.72",463254.93395622098,0.16670294452842693,0.25445671393504221]
[null,"Sim.73",474507.62648791703,0.1659243028466717,0.25298355546424256]
[null,"Sim.74",599928.49450036301,0.18663050002791692,0.28715802261997569]
[null,"Sim.75",508770.05611254321,0.17472676770354179,0.26682485824282409]
[null,"Sim.76",310454.26394784427,0.14040042968155508,0.21279137145473381]
[null,"Sim.77",370176.16304211039,0.14962634126787799,0.2277296013237966]
[null,"Sim.78",388133.09499150538,0.15341272205502943,0.23396630101902161]
[null,"Sim.79",581603.64304765477,0.18607604770333031,0.28414735163472971]
[null,"Sim.80",304858.47982158326,0.13847801284816796,0.21050004086650431]
[null,"Sim.81",349871.16100449092,0.14639657100565207,0.22275479679528276]
[null,"Sim.82",276284.78512998228,0.13541470366202968,0.20581557554355512]
[null,"Sim.83",306833.34588204301,0.13868729016465497,0.21035537825854167]
[null,"Sim.84",618601.87150452542,0.19054567792259047,0.29196227202171299]
[null,"Sim.85",481565.63970970642,0.16854446321663863,0.25676360014829047]
[null,"Sim.86",504943.82608482894,0.1705756671291101,0.26004048855511197]
[null,"Sim.87",421469.11821572343,0.15977250607225191,0.24408904786654562]
[null,"Sim.88",632679.46418482857,0.19122898663887855,0.29383265691095728]
[null,"Sim.89",716455.92568865651,0.20434366335131293,0.31327821619228557]
[null,"Sim.90",857505.58991389233,0.22763329484719974,0.34698979500835181]
[null,"Sim.91",650656.82891131681,0.19638179250880494,0.30101757457383083]
[null,"Sim.92",518227.52422896726,0.17580426183592301,0.26821604409261623]
[null,"Sim.93",690190.08007556316,0.20016919305022607,0.30649555289797448]
[null,"Sim.94",340049.78372308309,0.14446554512715837,0.21928869983057897]
[null,"Sim.95",291384.0283414938,0.13661875869507845,0.20735609094482843]
[null,"Sim.96",486929.27750337264,0.17091605016897904,0.26053738948459437]
[null,"Sim.97",670822.95560984942,0.19676155351331204,0.30067432094631297]
[null,"Sim.98",472516.59625344723,0.16759919797287171,0.25608388656566339]
[null,"Sim.99",262047.93348170817,0.13064547066788856,0.19768092254785308]
[null,"Sim.100",416529.536698777,0.15689119015058273,0.23965164374252312]
[null,"Sim.101",772892.17928188411,0.21274999952133333,0.3263798539259628]
[null,"Sim.102",329088.60795592587,0.14306314083291261,0.21724683797062627]
[null,"Sim.103",494150.94344819058,0.17246560019103496,0.26283732942115701]
[null,"Sim.104",532587.65197280957,0.17717429639110716,0.2712941471868946]
[null,"Sim.105",724232.54800905543,0.20378245553566909,0.31359828324773797]
[null,"Sim.106",583257.34843265032,0.18395895839935905,0.28223534819214713]
[null,"Sim.107",382350.22028998355,0.15230908420118872,0.23214492507333562]
[null,"Sim.108",755390.3782314437,0.20858337797261606,0.31866850598186547]
[null,"Sim.109",684667.2690755506,0.2006108216192255,0.30759124358060408]
[null,"Sim.110",767394.50492184819,0.21437960379994769,0.32760698510311403]
[null,"Sim.111",320672.98425626196,0.14059929401833604,0.21302896436958929]
[null,"Sim.112",333693.81742495857,0.14350429426054268,0.21838401779834427]
[null,"Sim.113",807098.14403689117,0.21784065121497642,0.33261062072162462]
[null,"Sim.114",573577.46860470972,0.18084114818327879,0.27646674642901914]
[null,"Sim.115",704291.82067166525,0.20157552463963202,0.30931023959140891]
[null,"Sim.116",693150.93336134101,0.20322391968612941,0.31038965018480624]
[null,"Sim.117",735908.71498702723,0.20734610295203626,0.31682423849259744]
[null,"Sim.118",304106.03050584579,0.13824685038653617,0.21013565881910345]
[null,"Sim.119",422273.4878253818,0.15829276974690565,0.24204403770643301]
[null,"Sim.120",546794.42273448012,0.18001468085083272,0.27524121599041429]
[null,"Sim.121",541697.47578375624,0.17716188437634317,0.27047711409747932]
[null,"Sim.122",188696.43791854312,0.11862969042679117,0.17788922556072184]
[null,"Sim.123",747856.91579887946,0.20661961788303795,0.31695380590073863]
[null,"Sim.124",502320.69582389458,0.17208147643865046,0.26376696812377376]
[null,"Sim.125",565845.67603099928,0.18289105369420056,0.27772069252397991]
[null,"Sim.126",344635.74954865919,0.14460903713321427,0.21987261088540255]
[null,"Sim.127",696248.98038327438,0.19966123075622333,0.30614380008374709]
[null,"Sim.128",104095.27960296813,0.10267728679228338,0.15217585147326806]
[null,"Sim.129",529574.21660522511,0.17647406351264738,0.26988112281889598]
[null,"Sim.130",133277.58590436098,0.10821491866018573,0.1612424541451738]
[null,"Sim.131",628578.87265580287,0.18946788403104042,0.29065050735082254]
[null,"Sim.132",310645.08651294583,0.14038440163215116,0.21336417089504756]
[null,"Sim.133",599635.45688693761,0.18509764700400733,0.28357977918323662]
[null,"Sim.134",556239.98689633398,0.18046490523339109,0.27533238467585575]
[null,"Sim.135",392704.84071306069,0.15564299406784388,0.23721403926699836]
[null,"Sim.136",957635.88189288322,0.24225208623205963,0.36795454756336499]
[null,"Sim.137",143358.39363894612,0.10995642986460918,0.16447765223620148]
[null,"Sim.138",619821.82964124996,0.19036986897981545,0.29136789560841492]
[null,"Sim.139",954830.92000944586,0.24135922450019232,0.36680577970237205]
[null,"Sim.140",182250.68497425527,0.11805670429561155,0.17711811704815483]
[null,"Sim.141",452579.33060662495,0.16447190095312747,0.25110252826949964]
[null,"Sim.142",393417.81348803197,0.1529550306762455,0.23355254862159081]
[null,"Sim.143",516803.42499591573,0.17453490072698052,0.26726809179001498]
[null,"Sim.144",631992.58695992525,0.19365378981804371,0.29523596428742738]
[null,"Sim.145",505296.06290377397,0.17280417966231854,0.26456866164550252]
[null,"Sim.146",235302.19049136457,0.12650165774076449,0.19150468675946741]
[null,"Sim.147",639211.73862646939,0.19484761112807769,0.29763752732591153]
[null,"Sim.148",869378.43604536005,0.22558026524413877,0.34433864907383738]
[null,"Sim.149",520154.51464804937,0.1734509251354559,0.26503628209628172]
[null,"Sim.150",255966.1103087943,0.13006462808512143,0.19655249590220225]
[null,"Sim.151",569763.3660259333,0.18365797402771911,0.28110591495533122]
[null,"Sim.152",201689.84864393016,0.12135845143227608,0.18207632096678883]
[null,"Sim.153",396895.49048878974,0.15508283294187519,0.23585180163185382]
[null,"Sim.154",333550.94496437418,0.14247039619406143,0.21621066969603397]
[null,"Sim.155",723008.45662756427,0.20313227956427471,0.31207843477708974]
[null,"Sim.156",726082.04866439709,0.20626440521820322,0.31658733607640555]
[null,"Sim.157",559967.23295704904,0.1807229587646868,0.2759641467546825]
[null,"Sim.158",464831.61896978621,0.16770725962993094,0.25650245975454178]
[null,"Sim.159",864703.97065389971,0.2248550961265714,0.3437303067492119]
[null,"Sim.160",425615.11456612824,0.15836091285126197,0.2408583845601393]
[null,"Sim.161",361412.87808664842,0.15003932027486999,0.22834078764958154]
[null,"Sim.162",504519.10647845245,0.17290864794564897,0.26330953161484372]
[null,"Sim.163",556426.86520998762,0.17770554462421706,0.27054932489022954]
[null,"Sim.164",614852.21526632132,0.18975838411992352,0.29030075565773239]
[null,"Sim.165",394459.49516045791,0.15302976463997364,0.23289872174966253]
[null,"Sim.166",349526.26112212008,0.14642667999011616,0.22216501389380916]
[null,"Sim.167",626254.55323419557,0.18905051461031186,0.2898529427129819]
[null,"Sim.168",600464.07954761549,0.18477210516245979,0.28337142140300431]
[null,"Sim.169",584947.5770884857,0.18586050517731079,0.2856463119609014]
[null,"Sim.170",512188.369455609,0.1741507169583969,0.26521140822436462]
[null,"Sim.171",667383.62056810549,0.19956647845756481,0.3050733345185499]
[null,"Sim.172",324076.40131757222,0.14290497204575114,0.21632775878130062]
[null,"Sim.173",267330.19231353956,0.13204480398540919,0.20039970213826575]
[null,"Sim.174",367195.31128628412,0.15077244199848661,0.22963926155154746]
[null,"Sim.175",847672.86197093781,0.22396304928545097,0.34152416508036176]
[null,"Sim.176",177503.8991518463,0.11629242918462501,0.17470734752280115]
[null,"Sim.177",778723.4355094065,0.21424422802010357,0.32790888492258263]
[null,"Sim.178",398032.57351372344,0.15447015779482376,0.23530654169226528]
[null,"Sim.179",765724.97375542484,0.21483167617498666,0.3288917916835421]
[null,"Sim.180",648594.99450342078,0.19209428447339727,0.29278274723332354]
[null,"Sim.181",393416.17126797419,0.15482628054115666,0.235549949753461]
[null,"Sim.182",598791.62376959505,0.18642110121843736,0.28666076027553244]
[null,"Sim.183",758160.24354590871,0.2130388575139075,0.3259388280130735]
[null,"Sim.184",737444.65565281198,0.20661313770288126,0.31642706665919307]
[null,"Sim.185",825658.74154573213,0.2214839792937553,0.33854473942730068]
[null,"Sim.186",674845.7331333654,0.19709574750803194,0.30325953896553992]
[null,"Sim.187",534113.23768835864,0.17862897794831545,0.27215123703319799]
[null,"Sim.188",520928.2012141014,0.17379402504245722,0.26586359451085073]
[null,"Sim.189",500437.26599949063,0.17075116355082409,0.26033705522943817]
[null,"Sim.190",200443.11471957504,0.12036594099679032,0.18084738390358668]
[null,"Sim.191",779058.96333045885,0.21695194588739963,0.33172777794623753]
[null,"Sim.192",640263.43032303452,0.19252214384538058,0.29479883966547815]
[null,"Sim.193",318679.1852690198,0.14052254238859718,0.21328910379318367]
[null,"Sim.194",570140.06969109178,0.18179938892684078,0.2780499525478406]
[null,"Sim.195",560196.5329194481,0.18125457517329768,0.27582971753558905]
[null,"Sim.196",496037.16730588302,0.17056414015256038,0.26054806402725794]
[null,"Sim.197",500106.71920095175,0.17136902137985355,0.26337348824946405]
[null,"Sim.198",368342.66799819586,0.15100344425442991,0.23020070885087374]
[null,"Sim.199",531059.03420091397,0.17524536272019908,0.26685302482077633]
[null,"Sim.200",455323.62509693322,0.16522876677399667,0.25251535277427406]
[null,"Sim.201",670534.43112675333,0.19853006212797575,0.30164549205348612]
[null,"Sim.202",545015.53883106774,0.17714064375707883,0.27185652396910065]
[null,"Sim.203",615453.27137146238,0.19099871014817382,0.29352567852215627]
[null,"Sim.204",251610.08343999251,0.12906849768028783,0.19495791380181826]
[null,"Sim.205",492202.26713227341,0.17029485693029334,0.25961627743117099]
[null,"Sim.206",390331.10776154418,0.15386246574977958,0.23454029414024546]
[null,"Sim.207",815125.1060100873,0.21793905018702286,0.33377664059812506]
[null,"Sim.208",141611.35799329169,0.1095080252214613,0.16371532857493332]
[null,"Sim.209",648682.05339384708,0.19425433939061865,0.29804980041497786]
[null,"Sim.210",333508.01435272326,0.14364427321200446,0.21839151012296809]
[null,"Sim.211",495880.58086570818,0.17125364285046141,0.26203279060128337]
[null,"Sim.212",631823.13214101689,0.19332035770075895,0.29478313207413498]
[null,"Sim.213",240507.8283309543,0.12781916851850528,0.19272209238715043]
[null,"Sim.214",583842.6021381109,0.18426467758087872,0.28031414576994562]
[null,"Sim.215",553758.28795629204,0.17823368508805548,0.27230906657149601]
[null,"Sim.216",468860.07796348631,0.16749659175966936,0.25514329199139296]
[null,"Sim.217",804972.3692773059,0.2178684853161863,0.33373986116228105]
[null,"Sim.218",368564.70304302848,0.15047594718545287,0.22918284648101128]
[null,"Sim.219",772001.43504567537,0.2136534838623978,0.32707592573727795]
[null,"Sim.220",315073.18754295935,0.13989103109069245,0.21267993604534863]
[null,"Sim.221",630587.23858826188,0.19226348272138649,0.29445550972568024]
[null,"Sim.222",295382.27766638878,0.13651358385366619,0.20730041223742979]
[null,"Sim.223",660642.90146981156,0.19934576026611661,0.30574868867396265]
[null,"Sim.224",830907.46197102452,0.22063677341668053,0.33712462131596377]
[null,"Sim.225",318202.76911829808,0.14112134009057153,0.21354246557373657]
[null,"Sim.226",391015.033658067,0.15269287811431065,0.23228258402940516]
[null,"Sim.227",635785.20843349514,0.1920549201444075,0.29431458885813733]
[null,"Sim.228",691674.68310636771,0.19905610190079903,0.30474823051386601]
[null,"Sim.229",691294.42727795499,0.19953936675154349,0.30637720827768655]
[null,"Sim.230",654166.58433649852,0.19479580076818581,0.29904822661054631]
[null,"Sim.231",234834.22163264034,0.12613586032340152,0.19053238508973536]
[null,"Sim.232",108031.82311599539,0.10358837129937015,0.15342564211435072]
[null,"Sim.233",767968.45471033105,0.20955282177790191,0.32053832831413942]
[null,"Sim.234",630507.69296309864,0.19392944260856027,0.29746721054128566]
[null,"Sim.235",610827.72571694804,0.18788101055366968,0.2889814792725347]
[null,"Sim.236",174428.6296003554,0.11666752014272674,0.17484841928239803]
[null,"Sim.237",726412.47493664245,0.20609978442916121,0.31668292547099597]
[null,"Sim.238",854376.21129673813,0.22288040807595921,0.34077268150876683]
[null,"Sim.239",229363.84061172209,0.12581708934459468,0.19023544801719194]
[null,"Sim.240",254231.70319323242,0.12971693589864297,0.19684107017788355]
[null,"Sim.241",678838.0626217993,0.19849642704706927,0.30411694426252023]
[null,"Sim.242",445483.76253614505,0.16141035668590775,0.24682883068645722]
[null,"Sim.243",527034.18665724504,0.17722170385865588,0.27085202658384167]
[null,"Sim.244",544880.02972932323,0.17872813890837969,0.27303583789455388]
[null,"Sim.245",962087.04452934116,0.23903060472033366,0.36315521922555938]
[null,"Sim.246",151195.54994652676,0.11120848712333187,0.16646816821725841]
[null,"Sim.247",431313.61069598631,0.16023001363492262,0.24396037390172887]
[null,"Sim.248",515608.52713065222,0.17298930164727522,0.26494097509630055]
[null,"Sim.249",767421.31414322834,0.21413279719119749,0.32797122937872336]
[null,"Sim.250",114086.93791028531,0.10500832399504989,0.15547593367462786]
[null,"Sim.251",628955.55995608261,0.19064970321191255,0.2915140567814023]
[null,"Sim.252",532479.20515151042,0.17753521610212708,0.2721857255038993]
[null,"Sim.253",989386.85487600695,0.24067346230191378,0.36589158727746796]
[null,"Sim.254",176311.56366864592,0.11717569890096646,0.17567216466679825]
[null,"Sim.255",91135.81348561286,0.10038966585883613,0.14864810312655785]
[null,"Sim.256",531473.36264879536,0.17432878504826688,0.26551408511373786]
[null,"Sim.257",457550.28807488456,0.16529682173592719,0.25188803716150754]
[null,"Sim.258",518884.79148024484,0.17470579570084621,0.26683083112335448]
[null,"Sim.259",368030.99637473398,0.15100238765188467,0.22965043744174229]
[null,"Sim.260",883083.77087235241,0.22768771854272218,0.34730061095789844]
[null,"Sim.261",933500.44342530542,0.23429523494321591,0.35705126976135504]
[null,"Sim.262",281956.26242222614,0.1340799544840825,0.2030792014564724]
[null,"Sim.263",354494.89609749056,0.14649190484416574,0.2225118459998725]
[null,"Sim.264",377402.1114818987,0.1501490426937917,0.22819040412458369]
[null,"Sim.265",573410.21710637375,0.18084662060803036,0.27635422800204923]
[null,"Sim.266",637393.67156617669,0.19507439152445705,0.29894997649651311]
[null,"Sim.267",696594.33438936342,0.20038976410152265,0.30764470459372295]
[null,"Sim.268",243716.08544729464,0.12869573641924537,0.19396185689182222]
[null,"Sim.269",665468.7031964357,0.19801149665249151,0.30378503282175373]
[null,"Sim.270",492901.73553197063,0.17152259469854414,0.26100028623598748]
[null,"Sim.271",670656.86796116852,0.19718774947569551,0.30298798563893592]
[null,"Sim.272",641384.65497772559,0.1904771531852929,0.29106113479904683]
[null,"Sim.273",859985.89847832499,0.22831039193957592,0.34826737679607112]
[null,"Sim.274",365612.86423447728,0.14979263090233941,0.22728156290644908]
[null,"Sim.275",156910.19004685828,0.11333068294232929,0.16978193625328175]
[null,"Sim.276",482838.08040001988,0.16810451735363685,0.25730986587830484]
[null,"Sim.277",630524.93107261951,0.19415264449392655,0.29751544230479454]
[null,"Sim.278",571288.97986278264,0.18192820590089687,0.2771690023305533]
[null,"Sim.279",671047.54505117121,0.20039958812931324,0.30710133174236875]
[null,"Sim.280",277760.81093368772,0.13459223444442459,0.20491140776504913]
[null,"Sim.281",524492.04000830557,0.17539687275807481,0.26799251464126628]
[null,"Sim.282",712023.99866988603,0.20617877579841926,0.31555212524998622]
[null,"Sim.283",581073.59739920963,0.18489129622930522,0.28340129500631317]
[null,"Sim.284",705202.2447973832,0.20196392173478883,0.31094870619373038]
[null,"Sim.285",945598.41193904914,0.2366033914556458,0.36027646410812886]
[null,"Sim.286",285091.9837435626,0.13634537238033562,0.20740166774513891]
[null,"Sim.287",496158.54344143742,0.17084193230815536,0.26028464603852441]
[null,"Sim.288",392009.34555269894,0.15443690799823773,0.2350875405905033]
[null,"Sim.289",502993.55010097614,0.17103898359652225,0.26102280737293304]
[null,"Sim.290",470941.61432669009,0.16851693597595574,0.25840202796993506]
[null,"Sim.291",676807.44318475947,0.19821633947920447,0.30435100001000381]
[null,"Sim.292",487741.1590080054,0.16978558663301713,0.26012822638667621]
[null,"Sim.293",757247.80896012369,0.2128050397547081,0.32588667601950871]
[null,"Sim.294",380248.87389919674,0.15279854694917572,0.23319654229989761]
[null,"Sim.295",711129.01568756322,0.20445910396137879,0.31410620782169185]
[null,"Sim.296",400204.84714578604,0.15709944370157003,0.23953838476258738]
[null,"Sim.297",694296.80539075658,0.20131467783490553,0.30890768648108957]
[null,"Sim.298",349653.17458652006,0.14680800327912324,0.22411856214189418]
[null,"Sim.299",491298.32158056833,0.1686603865156715,0.25829517951052172]
[null,"Sim.300",477942.35229610559,0.16708345586002538,0.25464738530102138]
[null,"Sim.301",828927.6572313474,0.22232102893693928,0.33981200489651364]
[null,"Sim.302",755579.51316925464,0.21215417999114305,0.32410859835873396]
[null,"Sim.303",586264.16402922221,0.18301947826386211,0.28072363346938256]
[null,"Sim.304",268121.55956959305,0.1334959614414335,0.20155891667000292]
[null,"Sim.305",790075.88324890891,0.21368674341799787,0.32787301811716874]
[null,"Sim.306",271839.63710072683,0.13407588558869632,0.20324065177865958]
[null,"Sim.307",777971.79172542202,0.21559664297731906,0.32961609830169603]
[null,"Sim.308",329906.85936172609,0.14332097575614,0.21802897152873202]
[null,"Sim.309",185890.51144336164,0.11785117083089025,0.17690616718793417]
[null,"Sim.310",784601.38129513222,0.21649308484629315,0.33155696446256622]
[null,"Sim.311",486442.45147647872,0.17084392601554277,0.261764138322925]
[null,"Sim.312",596090.29679678916,0.18689850028184929,0.28583576921065634]
[null,"Sim.313",317437.84989166702,0.13994212713352039,0.21253654679419887]
[null,"Sim.314",304963.83768137568,0.13845175605799476,0.20961715295797756]
[null,"Sim.315",394677.67851686152,0.153191268134373,0.23397354568249162]
[null,"Sim.316",672381.14169670013,0.19643417524084383,0.30139754294001597]
[null,"Sim.317",358225.68381282198,0.14744244282012797,0.22372320167904136]
[null,"Sim.318",369689.60579161276,0.1505607341118691,0.22907486911203856]
[null,"Sim.319",900059.95539606339,0.23289094441538061,0.35383055342552705]
[null,"Sim.320",438926.89101777948,0.16145206767918663,0.24553722366430719]
[null,"Sim.321",890318.24236522219,0.22864010314055472,0.349122632170622]
[null,"Sim.322",347549.47999232635,0.14614974919344714,0.22246673100190351]
[null,"Sim.323",750853.86684345105,0.21021617929780678,0.32256887589279137]
[null,"Sim.324",700711.3992067643,0.20052887912454254,0.30858110923758053]
[null,"Sim.325",473261.13721384527,0.16624975611004422,0.25374929112652045]
[null,"Sim.326",288464.42905647797,0.13641125719426528,0.20769619105114701]
[null,"Sim.327",582884.13084342936,0.18489972590862158,0.28313436548020765]
[null,"Sim.328",756310.41181789176,0.21091322774095889,0.32364005380254723]
[null,"Sim.329",164767.62021628837,0.11445024878757071,0.17161370894255956]
[null,"Sim.330",419528.5849694137,0.15854657348634205,0.2420478850549832]
[null,"Sim.331",233461.69598278427,0.1268667639444705,0.19179041149159426]
[null,"Sim.332",164696.39738126541,0.11428419859750605,0.17097479793833226]
[null,"Sim.333",467923.47152289585,0.16686165517949658,0.25403524650331311]
[null,"Sim.334",552677.43816512683,0.18016356706343939,0.27417980974664546]
[null,"Sim.335",399413.35102675832,0.1544020408008262,0.2348887842196552]
[null,"Sim.336",462843.76806310075,0.16626256430302822,0.25290873815232451]
[null,"Sim.337",472798.13518345915,0.1677610634018103,0.2551252758887077]
[null,"Sim.338",399199.72100959625,0.15437995340327482,0.23499875939761661]
[null,"Sim.339",507256.69636006909,0.1710458546166449,0.26097199902089452]
[null,"Sim.340",466664.87653013691,0.16535404553180011,0.25237757891607693]
[null,"Sim.341",347769.9966615357,0.14712951766249405,0.2229676224035877]
[null,"Sim.342",633881.33554774523,0.19189079983009405,0.29522463309885305]
[null,"Sim.343",500365.10766238975,0.17262139920721564,0.26227698344325057]
[null,"Sim.344",900178.76213983796,0.23245957414516538,0.35323600774865338]
[null,"Sim.345",607241.46829785896,0.18730383169530929,0.2852787996254138]
[null,"Sim.346",508573.65873715933,0.17529478603604542,0.26827404396695109]
[null,"Sim.347",821442.5669864628,0.22262803365439598,0.3402646540741876]
[null,"Sim.348",453146.16920595826,0.16320585681558231,0.24867180140731504]
[null,"Sim.349",158757.14768252801,0.11348527613502446,0.16942559065288032]
[null,"Sim.350",754720.84558974253,0.20961054667697443,0.32144053269870798]
[null,"Sim.351",338667.61575238733,0.14454118259058824,0.22026732638512936]
[null,"Sim.352",567507.13222395908,0.18283159658032377,0.27831286423104862]
[null,"Sim.353",972216.55924055143,0.24177534998758543,0.36725762677450824]
[null,"Sim.354",628439.95132421749,0.19288219898487013,0.29583929727371538]
[null,"Sim.355",685721.61321255309,0.19933799205399017,0.30404375002805617]
[null,"Sim.356",444798.58234547032,0.16290558102758856,0.24730371650256289]
[null,"Sim.357",445284.80557114445,0.1651140554458026,0.25272052134917855]
[null,"Sim.358",276935.24406093219,0.13492693964727165,0.20365666281669981]
[null,"Sim.359",938464.08062951779,0.23828745790146799,0.36243299370136661]
[null,"Sim.360",513226.68831141386,0.17463123362757327,0.26561135256689328]
[null,"Sim.361",617592.4411387716,0.18945267317039183,0.29095809859421817]
[null,"Sim.362",386348.03276337404,0.15150289426505692,0.23063193534856663]
[null,"Sim.363",481907.41850141645,0.16905028331096594,0.25960474300868031]
[null,"Sim.364",609538.82171837846,0.18732916732468707,0.28698293891791282]
[null,"Sim.365",109568.99004584644,0.10391042589491084,0.15369984456944685]
[null,"Sim.366",465843.74397987057,0.16548697029519288,0.25160882562961051]
[null,"Sim.367",477438.16963084158,0.16818893187062733,0.25610806769995165]
[null,"Sim.368",851609.46557147009,0.22615010494300369,0.34476097780152704]
[null,"Sim.369",535578.01256577671,0.17853306433238636,0.27281704719266653]
[null,"Sim.370",279181.8697176422,0.13376300610599223,0.20324639834240377]
[null,"Sim.371",479895.92954903818,0.17051992465971555,0.2603170112298121]
[null,"Sim.372",311549.19951063488,0.13930845397626235,0.21182671183446788]
[null,"Sim.373",983340.10937767336,0.24344885870095956,0.36959800599334702]
[null,"Sim.374",584686.82399850292,0.18471397856124616,0.28315130780010356]
[null,"Sim.375",691428.1466606434,0.20232656386560643,0.31005537267569916]
[null,"Sim.376",289246.51613018452,0.1366344982786285,0.20667913699450269]
[null,"Sim.377",100995.65385279246,0.10215583097771486,0.15116702829973905]
[null,"Sim.378",857834.65487760678,0.22286291682532822,0.3401937162362012]
[null,"Sim.379",449687.94900313392,0.16353247902674251,0.25073926092914745]
[null,"Sim.380",699270.2648240861,0.20337382245820113,0.30994005169553618]
[null,"Sim.381",732754.88422432053,0.20655105826196252,0.316669532032406]
[null,"Sim.382",639135.24884377117,0.1924245843360155,0.29396754087042054]
[null,"Sim.383",808920.18115507229,0.21905402696297305,0.33471754013802291]
[null,"Sim.384",557220.89143474866,0.18215462664036264,0.27911860254925536]
[null,"Sim.385",708348.29651291459,0.20576662075301533,0.31547349225410337]
[null,"Sim.386",304518.19887683098,0.13790291612102235,0.20929030438381102]
[null,"Sim.387",598899.86670482391,0.18482772071107778,0.28358663359984582]
[null,"Sim.388",657001.9282312945,0.19753518928435709,0.30306437634065819]
[null,"Sim.389",451506.24705609423,0.16261303241190483,0.24807982194237588]
[null,"Sim.390",392526.9026911729,0.15491813798594545,0.2363332966975773]
[null,"Sim.391",362353.59383947472,0.14819425207496995,0.22500703759664642]
[null,"Sim.392",172145.51535305544,0.11562599106862836,0.1730294783617885]
[null,"Sim.393",373186.67588862637,0.15107225062663665,0.23048524919175351]
[null,"Sim.394",460012.86400431301,0.16435318884739569,0.25059249724585286]
[null,"Sim.395",694781.2639067946,0.19860338279582179,0.30263047436305457]
[null,"Sim.396",470802.12220964511,0.16750459903441772,0.2561539437696756]
[null,"Sim.397",634653.39917228278,0.19195321807211707,0.29460479661974581]
[null,"Sim.398",907323.05979972705,0.2339120494198581,0.35550328482784654]
[null,"Sim.399",707143.93900352693,0.20102261194917292,0.3081950542531473]
[null,"Sim.400",432319.22922658059,0.16152311460853608,0.24518584606409988]
[null,"Sim.401",672340.44787157211,0.19927871087691496,0.30483269430976434]
[null,"Sim.402",481090.53164044325,0.16834590707903452,0.25636238109837817]
[null,"Sim.403",876284.68130124686,0.22786945185364327,0.34734130597116342]
[null,"Sim.404",393812.11040076497,0.15260460558524835,0.23207989586537803]
[null,"Sim.405",834858.29163481528,0.2237690739705589,0.3415248384005849]
[null,"Sim.406",470893.93887121091,0.16614386971104844,0.2528586656765206]
[null,"Sim.407",365552.39561242331,0.1483710894708663,0.22562652532851302]
[null,"Sim.408",285465.52137671993,0.13597838302479848,0.20542098714715351]
[null,"Sim.409",208560.64733538171,0.12185831892508903,0.18383204578870194]
[null,"Sim.410",979324.36811664677,0.24383663782039866,0.37023699360307583]
[null,"Sim.411",518029.63675790187,0.172012595666164,0.26280821366768503]
[null,"Sim.412",574551.41459711874,0.18378938170134562,0.27934987949672441]
[null,"Sim.413",793949.38307219907,0.2186323966880428,0.3341345626352179]
[null,"Sim.414",283593.63201328344,0.13403999253058418,0.20294293486290438]
[null,"Sim.415",724722.69542116462,0.20765626987927455,0.31743069963217407]
[null,"Sim.416",331152.6632903819,0.1437378721917455,0.21770876798371552]
[null,"Sim.417",563657.43839014228,0.18023161001760335,0.27700083514903162]
[null,"Sim.418",557699.60125901201,0.17960709250535767,0.27455573378895459]
[null,"Sim.419",741786.3330118244,0.20548986398761482,0.31394198205302049]
[null,"Sim.420",364240.29125690204,0.14986449234667343,0.22726405944923611]
[null,"Sim.421",390916.1803745206,0.15276106215884111,0.23301600591427318]
[null,"Sim.422",583733.32241736329,0.18432440517448501,0.28286439668914221]
[null,"Sim.423",704259.99779349007,0.20354417792584822,0.31152707098705279]
[null,"Sim.424",304415.17669163202,0.13911452868123009,0.21115390319482907]
[null,"Sim.425",798745.82553521125,0.21870844056285121,0.33418665904824163]
[null,"Sim.426",626562.91116494732,0.19127975485506132,0.29332653533761932]
[null,"Sim.427",708916.24061326333,0.20469947342262595,0.31453926441681279]
[null,"Sim.428",664666.76823932747,0.19718707779579669,0.30288899755971821]
[null,"Sim.429",420277.92496650503,0.15736116849002735,0.24080958908644501]
[null,"Sim.430",851606.22350426693,0.22410741802157608,0.34172492379456365]
[null,"Sim.431",810328.59853447601,0.21615793947446527,0.33051690106429588]
[null,"Sim.432",830113.13032629876,0.21970543873138459,0.33595770734642283]
[null,"Sim.433",478434.29445893806,0.16707243982922115,0.2549587205560313]
[null,"Sim.434",781755.28074408555,0.21477099294339097,0.32860237288593996]
[null,"Sim.435",282168.76929933671,0.13518278456171462,0.20549104065604329]
[null,"Sim.436",487877.6291710122,0.16741833558541908,0.25581293507614444]
[null,"Sim.437",620216.91076829564,0.19045338402808487,0.29010669760354468]
[null,"Sim.438",465833.35461639892,0.1664712041989691,0.25405676915463826]
[null,"Sim.439",871889.65528551792,0.23034267542250886,0.35098953494886476]
[null,"Sim.440",309181.01542145666,0.13956565531123744,0.21209646615675992]
[null,"Sim.441",421728.63024629839,0.15718410901042135,0.23932996765405412]
[null,"Sim.442",535082.03302977281,0.17883122789393036,0.27358914764084608]
[null,"Sim.443",806066.30082342331,0.21492271702942833,0.32908109697225885]
[null,"Sim.444",629508.69496029732,0.19157079006835698,0.29280817683798688]
[null,"Sim.445",437995.34811128187,0.16136081374422462,0.2454713607725596]
[null,"Sim.446",435611.82951521617,0.16033940709258454,0.24485667920659382]
[null,"Sim.447",499394.45053317491,0.16989940238059531,0.25941305948538584]
[null,"Sim.448",822221.64608980506,0.22003066115547298,0.3367577750876285]
[null,"Sim.449",837982.44108163705,0.22098953110716146,0.33830816607456549]
[null,"Sim.450",613242.48967450485,0.19108997146466455,0.29336838539794718]
[null,"Sim.451",432369.09204317513,0.15916576580068931,0.24311997325033596]
[null,"Sim.452",385361.06186402752,0.15171036710592789,0.23160491102933789]
[null,"Sim.453",800505.19768719352,0.21545258866686434,0.33047341708008382]
[null,"Sim.454",428285.30931755109,0.15983911426353137,0.24383886451476378]
[null,"Sim.455",705300.79484741786,0.20178501074845245,0.31007323989123203]
[null,"Sim.456",501417.99479879416,0.17205495294494688,0.26206722595367382]
[null,"Sim.457",619748.07205803203,0.19048627019163411,0.29229763762263117]
[null,"Sim.458",559533.69765373156,0.18219981645003114,0.27869254019273781]
[null,"Sim.459",656458.66053093667,0.19373179675264462,0.29755224708621486]
[null,"Sim.460",706257.04853878147,0.20273258467053767,0.30958108064911127]
[null,"Sim.461",396532.616728744,0.15495603822395121,0.2357929302742765]
[null,"Sim.462",640665.3257767905,0.1955447394020069,0.29981870716427572]
[null,"Sim.463",825709.51259016478,0.22216621750640453,0.33917982566005711]
[null,"Sim.464",436547.7735024679,0.1625412214769637,0.24750010603855199]
[null,"Sim.465",487096.13554019132,0.16845861665529105,0.25647857847118827]
[null,"Sim.466",487477.29369906103,0.17062482049776095,0.25920489106240097]
[null,"Sim.467",663417.51099017821,0.19605942283668409,0.30081329386676758]
[null,"Sim.468",798551.48962263018,0.21590342448039923,0.33095890530558636]
[null,"Sim.469",784422.98100968404,0.21256113281024591,0.32495469820127876]
[null,"Sim.470",695948.69820029871,0.19991934818491819,0.30679635487049306]
[null,"Sim.471",621519.66249387758,0.1900331785318532,0.29079612682233025]
[null,"Sim.472",310066.03777474212,0.13951881009161915,0.21210347349974978]
[null,"Sim.473",915375.28936515725,0.23494549655936936,0.35770325360331534]
[null,"Sim.474",578128.66761572729,0.18363721333308569,0.27929160849766399]
[null,"Sim.475",786808.59606273938,0.21321754262718873,0.3270749442573937]
[null,"Sim.476",554002.96017280431,0.18081352530456551,0.27450958082571097]
[null,"Sim.477",659888.42329870118,0.19706280282094335,0.30177321270348778]
[null,"Sim.478",716652.13241150836,0.20607346652989755,0.31625645905393318]
[null,"Sim.479",620816.14577868325,0.19054738010325645,0.29253892325104336]
[null,"Sim.480",300971.63709864998,0.13816390418721047,0.20908496215190309]
[null,"Sim.481",400497.84425221174,0.15400613322485857,0.23462114086998831]
[null,"Sim.482",823602.40684075863,0.21754924062822512,0.33291018262630545]
[null,"Sim.483",512153.16389476182,0.17133313630808278,0.26123399838577566]
[null,"Sim.484",221002.67884061509,0.12513080822791234,0.18879211970633802]
[null,"Sim.485",624753.27906203177,0.19268510101907643,0.29351965662804069]
[null,"Sim.486",211441.68866993045,0.12315288493714749,0.18580313887486022]
[null,"Sim.487",270436.74409152428,0.13294433087169577,0.20129350575019767]
[null,"Sim.488",574532.31655081944,0.18418361882484247,0.27976449713019069]
[null,"Sim.489",445224.14832621114,0.16203602307350429,0.24651700583301439]
[null,"Sim.490",972930.67210961133,0.2436175292684466,0.36972941327371145]
[null,"Sim.491",320427.06544170459,0.14109582024509382,0.21428597968774898]
[null,"Sim.492",945827.36721056327,0.23671091908528141,0.36057668137126409]
[null,"Sim.493",605536.09672381845,0.18727463728038596,0.28625884363847232]
[null,"Sim.494",593173.29100161954,0.18637907318853397,0.28506794162659088]
[null,"Sim.495",284159.27696017595,0.13681023481729859,0.20796071362481494]
[null,"Sim.496",595135.55676207552,0.18426033339124404,0.28133244507933397]
[null,"Sim.497",215447.37020412949,0.12401322546264759,0.1861988171704978]
[null,"Sim.498",693589.26158974785,0.20179405062408962,0.30866091603336732]
[null,"Sim.499",440075.92778229434,0.16102544186640499,0.24562041169180548]
[null,"Sim.500",141529.25238805404,0.10993441506265111,0.16390095878140643]