{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instrucciones","Datos Asegurado","máster","Brochure","Template PDF","Objetos Estructura","Master"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Instrucciones","index":0,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,"     Ingresa tus datos "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"     Si requieres cotizar a más integrantes de la póliza , selecciona primero el número de integrantes aquí"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"    Selecciona la suma asegurada que desees cotizar"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"     Y para finalizar imprime"]

{"sheet":"Datos Asegurado","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,7,30,10],[31,0,42,0],[1,7,2,10],[1,0,2,5],[15,2,15,3],[16,2,16,3],[28,1,28,4]]}
[]
["   Cotización",null,null,null,null,null,null,"   2. Integrantes adicionales a cotizar"]
[]
["   1. Ingrese los datos del asegurado"]
[null,null,null,null,null,null,null,"Número ","Relación","Género","Edad"]
[null,"Fecha Cotización:",{"$f":"TODAY()","v":"2022-01-19"}]
[null,"Nombre del titular:","Usuario"]
[null,"Edad del titular:",45]
[null,"Género:","Femenino"]
[]
[null,"Número de integrantes adicionales a cotizar:",0]
[]
[]
["   3. Datos del agente"]
[]
[null,"Nombre del agente:","Maria"]
[null,"Agencia:","Bupa Mex"]
[]
[]
["   4. Datos de la póliza"]
[null,null,null,null,"$ 1,000,000 MNX"]
["Tipo de  cliente:","Nuevo negocio ",null,null,"$ 2,000,000 MNX"]
[null,null,null,null,"$ 3,000,000 MNX"]
[null,null,"Asistencia en el extranjero:","No","$ 5,000,000 MNX"]
[null,null,"Deducible:",10000]
["Suma asegurada (mxn):","$ 1,000,000 MNX","Coaseguro:",0.2]
[null,null,"Zona:","Zona 1: CDMX, Area Metropolitana y Monterrey"]
[]
[null,"Te recordamos que contamos con la promoción de eliminación el deducible y coaseguro de por vida del Plan Bupa Nacional Vital para contrataciones desde el 18 de enero hasta el 30 de junio del 2022."]
[{"$f":"+B26","v":"$ 1,000,000 MNX"},{"$f":"VLOOKUP($A$30,máster!$F$78:$G$81,2,0)","v":"1M"}]
["Suma asegurada","Concepto ","Anual","Semestral ","Trimestral","Mensual",null,"   5. Imprime"]
[{"$f":"+A30","v":"$ 1,000,000 MNX"},"Prima del asegurado titular:",{"$f":"IF(máster!J51<>0,máster!J51-C37,0)","v":23781},{"$f":"IF(C32<>0,(C32-máster!O20)*1.045+máster!O20,0)","v":24851.144999999997},{"$f":"IF(C32<>0,(C32-máster!O20)*1.075+máster!O20,0)","v":25564.575000000001},{"$f":"IF(C32<>0,(C32-máster!O20)*1.11+máster!O20,0)","v":26396.910000000003}]
[null,"Prima cónyuge:",{"$f":"IF(máster!J52<>0,máster!J52-C37,0)","v":0},{"$f":"IF($C$33<>0,($C$33-(máster!O20*máster!$N$32))*1.045+(máster!O20*máster!$N$32),0)","v":0},{"$f":"IF($C$33<>0,($C$33-(máster!O20*máster!$N$32))*1.075+(máster!O20*máster!$N$32),0)","v":0},{"$f":"IF($C$33<>0,($C$33-(máster!O20*máster!$N$32))*1.11+(máster!O20*máster!$N$32),0)","v":0}]
[null,"Prima hijo(s):",{"$f":"IF(máster!J53<>0,máster!J53-C37,0)","v":0},{"$f":"IF($C$34<>0,($C$34-(máster!O20*máster!$N$22))*1.045+(máster!O20*máster!$N$22),0)","v":0},{"$f":"IF($C$34<>0,($C$34-(máster!O20*máster!$N$22))*1.075+(máster!O20*máster!$N$22),0)","v":0},{"$f":"IF($C$34<>0,($C$34-(máster!O20*máster!$N$22))*1.11+(máster!O20*máster!$N$22),0)","v":0}]
[null,"Dependientes económicos",{"$f":"IF(máster!J54<>0,máster!J54-C37,0)","v":0},{"$f":"IF($C$35<>0,($C$35-(máster!O20*máster!$N$42))*1.045+(máster!O20*máster!$N$42),0)","v":0},{"$f":"IF($C$35<>0,($C$35-(máster!O20*máster!$N$42))*1.075+(máster!O20*máster!$N$42),0)","v":0},{"$f":"IF($C$35<>0,($C$35-(máster!O20*máster!$N$42))*1.11+(máster!O20*máster!$N$42),0)","v":0}]
[null,"Total Prima:",{"$f":"SUM(C32:C35)+C37","v":23781},{"$f":"($C$36-(máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))) * 1.045 + (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))","v":24851.144999999997},{"$f":"($C$36-(máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))) * 1.075 + (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))","v":25564.575000000001},{"$f":"($C$36-(máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))) * 1.11 + (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1))","v":26396.910000000003}]
[null,"Asistencia en el extranjero:",{"$f":"máster!J56","v":0},{"$f":"IF($D$24=\"Si\",Master!$AO$2,0)","v":0},{"$f":"IF($D$24=\"Si\",Master!$AO$2,0)","v":0},{"$f":"IF($D$24=\"Si\",Master!$AO$2,0)","v":0}]
[null,"Derecho de póliza:",{"$f":"máster!J57","v":1500},{"$f":"+máster!K57","v":1500},{"$f":"+máster!L57","v":1500},{"$f":"+máster!M57","v":1500}]
[null,"Total descuento\n(derecho de póliza y recargo por pago fraccionado)",-1500,{"$f":"-1500-($C$36 -(máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.045","v":-2570.145},{"$f":"-1500-($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.075","v":-3283.5749999999998},{"$f":"-1500-($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.11","v":-4115.91}]
[null,"IVA (16%)",{"$f":"(C36+C38+C39)*16%","v":3804.96},{"$f":"(D36/2+D38+D39)*16%","v":1816.8683999999996},{"$f":"(E36/4+E38+E39)*16%","v":737.21100000000013},{"$f":"(F36/12+F38+F39)*16%","v":-66.586799999999926}]
[null,"Costo Total:",{"$f":"C36+C38+C39+C40","v":27585.96},{"$f":"(D36+D38+D39)*1.16","v":27585.959999999995},{"$f":"(E36+E38+E39)*1.16","v":27585.96},27585.960000000003]
[null,"Primer Pago:",{"$f":"C36+C38+C39+C40","v":27585.96},{"$f":"(D36/2-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.045)/2)*1.16","v":13792.979999999998},{"$f":"(E36/4-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.075)/4)*1.16","v":6896.49},{"$f":"(F36/12-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.11)/12)*1.16","v":2298.83}]
[null,"Pagos Subsecuentes:",{"$f":"+máster!J60","v":0},{"$f":"(D36/2-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.045)/2)*1.16","v":13792.979999999998},{"$f":"(E36/4-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.075)/4)*1.16","v":6896.49},{"$f":"(F36/12-(($C$36 - (máster!O20*(máster!$N$22+máster!$N$32+máster!$N$42+1)))*0.11)/12)*1.16","v":2298.83}]

{"sheet":"máster","index":2,"n_rows":349,"n_cols":29,"rows_kept":349,"cut":false,"hidden":true,"merged":[[42,33,45,33],[0,0,0,1],[1,0,1,1],[42,30,45,30],[42,31,45,31],[42,32,45,32]]}
["Bupa Nacional Vital Individual"]
["Prima en Pesos Mexicanos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zonas",null,null,"Coaseguro","Deducible"]
[null,"Z1","Z2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zona 1: CDMX, Area Metropolitana y Monterrey",{"$f":"IF('Datos Asegurado'!D25=0,4,2)","v":2},null,0.2,10000]
["Deducible",10000,10000,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zona 2: Republica mexicana, excepto CDMX, Area Metropolitana y Monterrey",{"$f":"IF('Datos Asegurado'!D25=0,4,3)","v":3}]
["Coaseguro",20,20,0]
["Edad","Prima de Tarifa","Prima de tarifa","Prima de tarifa",null,null,null,{"$f":"+'Datos Asegurado'!B30","v":"1M"},"% de recargo ",0,4.4999999999999998E-2,7.4999999999999997E-2,0.11]
["01M",9814,9814,12919.616019833338,null,"Concepto","Edad","Patrón de edad","Prima (desde base) ","Anual ","Semestral ","Trimestral ","Mensual ",null,null,null,null,null,"Familia "]
["11M",8750,8750,11515.039327696741,null,"Prima del asegurado (títular) ",{"$f":"+'Datos Asegurado'!C8","v":45},{"$f":"CONCATENATE(G8,$H$6)","v":"451M"},{"$f":"VLOOKUP(H8,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":23781},{"$f":"$I$8*J6+$I$8+máster!O20","v":23781},{"$f":"$I$8*K6+$I$8+(250)","v":25101.145},{"$f":"$I$8*L6+$I$8+(250)","v":25814.575000000001},{"$f":"$I$8*M6+$I$8+(250)","v":26646.91},null,null,null,null,null,34,{"$f":"+B299","v":23631},0.11700000000000001]
["21M",7603,7603,9999.9244809787651,1,{"$f":"+'Datos Asegurado'!I6","v":0},{"$f":"+'Datos Asegurado'!K6","v":0},"01M",{"$f":"VLOOKUP(H9,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$9*J6+$I$9","v":9814},{"$f":"+$I$9*K6+$I$9","v":10255.629999999999},10550.05,{"$f":"+$I$9*M6+$I$9","v":10893.54},null,null,null,null,null,46,{"$f":"+B311","v":32661},7.4999999999999997E-2]
["31M",7108,7108,9346.0698139496581,2,{"$f":"+'Datos Asegurado'!I7","v":0},{"$f":"+'Datos Asegurado'!K7","v":0},"01M",{"$f":"VLOOKUP(H10,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)","v":9814},{"$f":"+$I$10*J6+$I$10","v":9814},{"$f":"+$I$10*K6+$I$10","v":10255.629999999999},10550.05,{"$f":"+$I$10*M6+$I$10","v":10893.54},null,null,null,null,null,10,{"$f":"+B275","v":10464},4.4999999999999998E-2]
["41M",6571,6571,8636.3601783511622,3,{"$f":"+'Datos Asegurado'!I8","v":0},{"$f":"+'Datos Asegurado'!K8","v":0},"01M",{"$f":"VLOOKUP(H11,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$11*J6+$I$11","v":9814},{"$f":"+$I$11*K6+$I$11","v":10255.629999999999},10550.05,{"$f":"+$I$11*M6+$I$11","v":10893.54},null,null,null,null,null,5,{"$f":"+B270","v":8926},0]
["51M",6780,6780,8913.2914560833215,4,{"$f":"+'Datos Asegurado'!I9","v":0},{"$f":"+'Datos Asegurado'!K9","v":0},"01M",{"$f":"VLOOKUP(H12,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$12*J6+$I$12","v":9814},{"$f":"+$I$12*K6+$I$12","v":10255.629999999999},10550.05,10893.54,null,null,null,null,null,"TOTAL ",{"$f":"SUM(T8:T11)","v":75682}]
["61M",6998,6998,9200.3781826462819,5,{"$f":"+'Datos Asegurado'!I10","v":0},{"$f":"+'Datos Asegurado'!K10","v":0},"01M",{"$f":"VLOOKUP(H13,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$13*J6+$I$13","v":9814},{"$f":"+$I$13*K6+$I$13","v":10255.629999999999},10550.05,{"$f":"+$I$13*M6+$I$13","v":10893.54},null,null,null,null,null,"IVA",0.16]
["71M",7223,7223,9497.2297638542368,6,{"$f":"+'Datos Asegurado'!I11","v":0},{"$f":"+'Datos Asegurado'!K11","v":0},"01M",{"$f":"VLOOKUP(H14,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$14*J6+$I$14","v":9814},{"$f":"+$I$14*K6+$I$14","v":10255.629999999999},10550.05,{"$f":"+$I$14*M6+$I$14","v":10893.54},null,null,null,null,null,null,{"$f":"+T12*T13","v":12109.12}]
["81M",7455,7455,9803.8461997071918,7,{"$f":"+'Datos Asegurado'!I12","v":0},{"$f":"+'Datos Asegurado'!K12","v":0},"01M",{"$f":"VLOOKUP(H15,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$15*J6+$I$15","v":9814},{"$f":"+$I$15*K6+$I$15","v":10255.629999999999},10550.05,10893.54,null,null,null,null,null,"derecho de poliza",500,"x poliza (pendiente de revisar)solo una vez,primer recibo "]
["91M",7695,7695,10121.399272762545,8,{"$f":"+'Datos Asegurado'!I13","v":0},{"$f":"+'Datos Asegurado'!K13","v":0},"01M",{"$f":"VLOOKUP(H16,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$16*J6+$I$16","v":9814},{"$f":"+$I$16*K6+$I$16","v":10255.629999999999},10550.05,10893.54,null,null,null,null,null,"uso de la red",250,"x asegurado "]
["101M",7944,7944,10449.4983888345,9,{"$f":"+'Datos Asegurado'!I14","v":0},{"$f":"+'Datos Asegurado'!K14","v":0},"01M",{"$f":"VLOOKUP(H17,$A$7:$D$349,(VLOOKUP('Datos Asegurado'!D27,máster!Y3:Z4,2,0)),0)+J56","v":9814},{"$f":"+$I$17*J6+$I$17","v":9814},{"$f":"+$I$17*K6+$I$17","v":10255.629999999999},{"$f":"+$I$17*L6+$I$17","v":10550.05},10893.54]
["111M",8201,8201,10788.924736294648,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total ",{"$f":"+T12","v":75682}]
["121M",8467,8467,11140.068909328797,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T15","v":500},null,"recargo porpagofracccionado"]
["131M",8742,8742,11503.712096308544,null,null,null,null,null,5,6,7,8,"uso de red",0,null,null,null,null,{"$f":"+T16","v":250},null,"FORMAS DE PAGO",null,"mismos"]
["141M",9026,9026,11879.073108862289,null,"Hij@",1,null,null,{"$f":"IFERROR(VLOOKUP(F21,F9:M9,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F21,F9:M9,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F21,F9:M9,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F21,F9:M9,8,0),0)","v":0},"Hij@",null,null,null,null,null,{"$f":"SUM(T18:T20)","v":76432},null,"MENSUAL ",0.11700000000000001]
["151M",9320,9320,12267.323729547432,null,"Hij@",2,null,null,{"$f":"IFERROR(VLOOKUP(F22,F10:M10,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F22,F10:M10,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F22,F10:M10,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F22,F10:M10,8,0),0)","v":0},{"$f":"COUNTIF(F9:F17,N21)","v":0},{"$f":"(N22*$O$20)","v":0},null,null,null,0.16,{"$f":"+T21*S22","v":12229.12},null,"TRIMESTRAL ",7.4999999999999997E-2]
["161M",9624,9624,12668.854552549774,null,"Hij@",3,null,null,0,0,0,0,null,null,null,null,null,null,{"$f":"+T21+T22","v":88661.119999999995},null,"SEMESTRAL ",4.4999999999999998E-2]
["171M",9939,9939,13085.227954612512,null,"Hij@",4,null,null,0,0,0,0,null,null,null,null,null,null,null,null,"ANUAL ",0]
["181M",10226,10226,13463.909017745558,null,"Hij@",5,null,null,0,0,0,0]
["191M",10529,10529,13863.926288277924,null,"Hij@",6,null,null,0,0,0,0]
["201M",10841,10841,14275.94407692626,null,"Hij@",7,null,null,0,0,0,0]
["211M",11162,11162,14700.322399234048,null,"Hij@",8,null,null,0,0,0,0]
["221M",11493,11493,15137.432071211071,null,"Hij@",9,null,null,{"$f":"IFERROR(VLOOKUP(F29,F17:M17,5,0),0)","v":0},0,0,0]
["231M",11834,11834,15587.655033347401,null,"Total de hijos",null,null,null,{"$f":"SUM(J21:J29)","v":0},{"$f":"SUM(K21:K29)","v":0},0,0]
["241M",12185,12185,16051.384684347824,null,"Cónyuge",1,null,null,{"$f":"IFERROR(VLOOKUP(F31,F9:M9,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F31,F9:M9,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F31,F9:M9,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F31,F9:M9,8,0),0)","v":0},"Cónyuge"]
["251M",12547,12547,16529.026224878256,null,"Cónyuge",2,null,null,{"$f":"IFERROR(VLOOKUP(F32,F10:M10,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F32,F10:M10,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F32,F10:M10,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F32,F10:M10,8,0),0)","v":0},{"$f":"COUNTIF(F9:F17,N31)","v":0},{"$f":"(N32*$O$20)","v":0}]
["261M",12919,12919,17020.997011624611,null,"Cónyuge",3,null,null,0,0,0,0]
["271M",13303,13303,17527.726921973346,null,"Cónyuge",4,null,null,0,0,0,0]
["281M",13698,13698,18049.658729632549,null,"Cónyuge",5,null,null,0,0,0,0]
["291M",14105,14105,18587.248491521525,null,"Cónyuge",6,null,null,0,0,0,0]
["301M",15918,14525,19140.965946267173,null,"Cónyuge",7,null,null,0,0,0,0]
["311M",16391,14956,19711.294924655183,null,"Cónyuge",8,null,null,0,0,0,{"$f":"IFERROR(VLOOKUP(F38,F16:M16,8,0),0)","v":0}]
["321M",16879,15401,20298.733772394844,null,"Cónyuge",9,null,null,0,0,0,0]
["331M",17382,15859,20903.795785566694,null,"Total de conyuge",null,null,null,{"$f":"SUM(J31:J39)","v":0},{"$f":"SUM(K31:K39)","v":0},{"$f":"SUM(L31:L39)","v":0},{"$f":"SUM(M31:M39)","v":0}]
["341M",17899,16331,21527.009659133688,null,"Dependiente económico",1,null,null,{"$f":"IFERROR(VLOOKUP(F41,F9:M9,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F41,F9:M9,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F41,F9:M9,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F41,F9:M9,8,0),0)","v":0},"Dependiente económico"]
["351M",18432,16817,22168.919948907704,null,"Dependiente económico",2,null,null,{"$f":"IFERROR(VLOOKUP(F42,F10:M10,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F42,F10:M10,6,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F42,F10:M10,7,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(F42,F10:M10,8,0),0)","v":0},{"$f":"COUNTIF(F9:F17,N41)","v":0},{"$f":"(N42*$O$20)","v":0}]
["361M",18981,17318,22830.087547374929,null,"Dependiente económico",3,null,null,0,0,0,{"$f":"IFERROR(VLOOKUP(F43,F11:M11,8,0),0)","v":0}]
["371M",19547,17834,23511.090173796176,null,"Dependiente económico",4,null,null,0,0,0,0]
["381M",20129,18365,24212.522879010063,null,"Dependiente económico",5,null,null,0,0,0,0]
["391M",20729,18912,24934.998565380367,null,"Dependiente económico",6,null,null,0,0,0,0]
["401M",19569,19569,25803.173515168681,null,"Dependiente económico",7,null,null,0,0,0,0]
["411M",20347,20347,26830.100455775424,null,"Dependiente económico",8,null,null,0,0,0,0]
["421M",21155,21155,27898.104474006443,null,"Dependiente económico",9,null,null,0,0,0,0]
["431M",21996,21996,29008.828652966702,null,"Total de dependiente económico",null,null,null,{"$f":"SUM(J41:J49)","v":0},{"$f":"SUM(K41:K49)","v":0},{"$f":"SUM(L41:L49)","v":0},{"$f":"SUM(M41:M49)","v":0}]
["441M",22871,22871,30163.981799085373,null,"Prima del asegurado titular:",null,null,null,{"$f":"+J8","v":23781},{"$f":"+K8","v":25101.145},{"$f":"+L8","v":25814.575000000001},{"$f":"+M8","v":26646.91}]
["451M",23781,23781,31365.341071048781,null,"Prima cónyuge:",null,null,null,{"$f":"(J40+$O$32)","v":0},{"$f":"(K40+$O$32)","v":0},{"$f":"(L40+$O$32)","v":0},{"$f":"(M40+$O$32)","v":0}]
["461M",24727,24727,32614.754713890739,null,"Prima hijo(s):",null,null,null,{"$f":"(J30+$O$22)","v":0},{"$f":"(K30+$O$22)","v":0},{"$f":"(L30+$O$22)","v":0},{"$f":"(M30+$O$22)","v":0}]
["471M",25710,25710,33914.144902446365,null,"Dependientes económicos",null,null,null,{"$f":"(J50+$O$42)","v":0},{"$f":"(K50+$O$42)","v":0},0,0]
["481M",26734,26734,35265.510698544225,null,"Total Prima:",null,null,null,{"$f":"SUM(J51:J54)","v":23781},{"$f":"SUM(K51:K54)","v":25101.145},{"$f":"SUM(L51:L54)","v":25814.575000000001},{"$f":"SUM(M51:M54)","v":26646.91}]
["491M",27798,27798,36670.931126485993,null,"Asistencia en el extranjero:",null,null,null,{"$f":"IF('Datos Asegurado'!$D$24=\"Si\",Master!$AO$2,0)","v":0},{"$f":"IF('Datos Asegurado'!$D$24=\"Si\",Master!$AO$2,0)","v":0},{"$f":"IF('Datos Asegurado'!$D$24=\"Si\",Master!$AO$2,0)","v":0},{"$f":"IF('Datos Asegurado'!$D$24=\"Si\",Master!$AO$2,0)","v":0}]
["501M",28904,28904,38132.568371545429,null,"Derecho de póliza:",null,null,null,1500,1500,1500,1500]
["511M",30199,30199,39842.683948264974,null,"IVA (16%)",null,null,null,{"$f":"(J55+J57)*16%","v":4044.96},{"$f":"(K55/2+K57)*16%","v":2248.0916000000002},{"$f":"(L55/4+L57)*16%","v":1272.5830000000001},{"$f":"(M55/12+M57)*16%","v":595.29213333333337}]
["521M",31703,31703,41828.318145678226,null,"Primer Pago:",null,null,null,{"$f":"J55+J57+J58","v":29325.96},{"$f":"((K55/2)+K57)*1.16","v":16298.6641},{"$f":"((L55/4)+L57)*1.16","v":9226.2267499999998},{"$f":"((M55/12)+M57)*1.16","v":4315.8679666666667}]
["531M",33281,33281,43913.234052962143,null,"Pagos Subsecuentes:",null,null,null,0,{"$f":"(K55/2*1.16)","v":14558.6641},{"$f":"(L55/4*1.16)","v":7486.2267499999998},{"$f":"(M55/12*1.16)","v":2575.8679666666667}]
["541M",34939,34939,46102.39575561024]
["551M",36679,36679,48401.015543390771]
["561M",38507,38507,50814.566320560305]
["571M",40426,40426,53348.794636588311]
["581M",42441,42441,56009.734368417747]
["591M",44556,44556,58803.721086838639]
["601M",51292,46777,61737.407141180563]
["611M",54106,49343,65125.814533945493]
["621M",57344,52296,69025.563405982219]
["631M",60777,55426,73159.297210341159]
["641M",64416,58743,77541.055042961627]
["651M",68273,62260,82185.718345539324]
["661M",72361,65988,87109.061446271691]
["671M",76695,69940,92327.805133048008,null,"Cónyuge",{"$f":"COUNTIF('Datos Asegurado'!I6:I14,máster!F74)","v":0},{"$f":"(G74*$G$77)","v":0}]
["681M",81289,74128,97859.6734410309,null,"Dependiente económico",{"$f":"COUNTIF('Datos Asegurado'!I7:I15,máster!F75)","v":0},{"$f":"(G75*$G$77)","v":0}]
["691M",86159,78568,103723.45384749275,null,"Hij@",{"$f":"COUNTIF('Datos Asegurado'!I8:I16,máster!F76)","v":0},{"$f":"(G76*$G$77)","v":0}]
["701M",91321,83274,109939.06107834232,null,"Uso de red ",0]
["711M",96792,88263,116527.60474304287,null,"$ 1,000,000 MNX","1M"]
["721M",102592,93551,123511.46102762544,null,"$ 2,000,000 MNX","2M"]
["731M",108739,99156,130914.34868928298,null,"$ 3,000,000 MNX","3M"]
["741M",115256,105098,138761.40961063994,null,"$ 5,000,000 MNX","5M"]
["751M",122164,111396,147079.29418727834]
["761M",129486,118072,155896.25183851508]
["771M",137247,125148,165242.22694882596]
["781M",145474,132649,175148.96056575552]
["791M",154195,140601,185650.09819970088]
["801M",163438,149029,196781.30409168295]
["811M",173237,157963,208580.38233718395]
["821M",183623,167433,221087.40527741497]
["831M",194633,177471,234344.8495940599]
["841M",206303,188111,248397.74056970354]
[]
["02M",11136,11136,14665.416773415378]
["12M",9927,9927,13069.11336768603]
["22M",8623,8623,11347.183192262191]
["32M",8061,8061,10604.076434422666]
["42M",7450,7450,9797.4904254654339]
["52M",7688,7688,10112.223215972137]
["62M",7935,7935,10438.497688500242]
["72M",8191,8191,10775.869932202773]
["82M",8455,8455,11124.33994707973]
["92M",8728,8728,11485.239465672044]
["102M",9010,9010,11858.124577132738]
["112M",9302,9302,12243.88310315576]
["122M",9604,9604,12642.958954588097]
["132M",9917,9917,13056.239953123699]
["142M",10240,10240,13482.838277068608]
["152M",10574,10574,13924.085658963761]
["162M",10920,10920,14380.426009656134]
["172M",11278,11278,14853.634972533631]
["182M",11604,11604,15284.006538677846]
["192M",11948,11948,15738.626734838183]
["202M",12303,12303,16206.885536883328]
["212M",12668,12668,16689.192102989829]
["222M",13044,13044,17185.967866079522]
["232M",13432,13432,17697.646902061908]
["242M",13831,13831,18224.676309123763]
["252M",14242,14242,18767.516598397473]
["262M",14665,14665,19326.642096349406]
["272M",15101,15101,19902.541359239884]
["282M",15550,15550,20495.717600017084]
["292M",16013,16013,21106.689128017595]
["302M",18073,16489,21735.989801858123]
["312M",18611,16980,22384.169495913866]
["322M",19165,17486,23051.794580791284]
["332M",19736,18006,23739.448418215026]
["342M",20325,18543,24447.731870761472]
["352M",20930,19095,25177.263826884322]
["362M",21554,19664,25928.681741690849]
["372M",22197,20250,26702.642193941578]
["382M",22859,20854,27499.821459759823]
["392M",23541,21475,28320.916103552619]
["402M",22222,22222,29307.598167176955]
["412M",23106,23106,30474.702093864034]
["422M",24025,24025,31688.490177618594]
["432M",24981,24981,32950.829784723341]
["442M",25975,25975,34263.662976112275]
["452M",27009,27009,35629.009495156759]
["462M",28084,28084,37048.969874963048]
["472M",29202,29202,38525.728669961565]
["482M",30365,30365,40061.557816760032]
["492M",31574,31574,41658.820129430431]
["502M",32832,32832,43319.972934607642]
["512M",34304,34304,45263.521716664996]
["522M",36013,36013,47520.197802498231]
["532M",37807,37807,49889.707692623153]
["542M",39690,39690,52377.693077254298]
["552M",41669,41669,54990.077731117031]
["562M",43745,43745,57733.081617672891]
["572M",45926,45926,60613.23569855652]
["582M",48216,48216,63637.397483484368]
["592M",50620,50620,66812.76735765858]
["602M",58275,53145,70146.90572554151]
["612M",61473,56061,73997.835540446293]
["622M",65154,59417,78429.905672873065]
["632M",69055,62974,83127.900013245468]
["642M",73191,66744,88107.774014040173]
["652M",77575,70741,93386.440454882613]
["662M",82221,74978,98981.826882175592]
["672M",87147,79469,104912.93649510613]
["682M",92368,84229,111199.91268481249]
["692M",97902,89275,117864.10744590123]
["702M",103768,94624,124928.15389265533]
["712M",109987,100293,132416.04312621467]
["722M",116578,106303,140353.20571378752]
["732M",123565,112673,148766.59805661478]
["742M",130971,119426,157684.79394001164]
["752M",138821,126584,167138.0815764124]
["762M",147143,134171,177158.56647099718]
["772M",155964,142214,187780.28045925696]
["782M",165314,150739,199039.29728681236]
["792M",175225,159775,210973.85512402115]
["802M",185730,169354,223624.48643146246]
["812M",196866,179507,237034.15561735019]
["822M",208670,190270,251248.40495439121]
["832M",221183,201678,266315.50925165473]
["842M",234446,213771,282286.63980675401]
[]
["03M",12053,12053,15876.864795767793]
["13M",10744,10744,14147.518173315402]
["23M",9331,9331,12282.074472399721]
["33M",8722,8722,11477.033803327056]
["43M",8060,8060,10603.223232416049]
["53M",8318,8318,10944.187291180993]
["63M",8586,8586,11297.654968462]
["73M",8863,8863,11663.145355854605]
["83M",9148,9148,12040.658453358812]
["93M",9444,9444,12431.63698618801]
["103M",9750,9750,12835.600045937736]
["113M",10067,10067,13253.50944941691]
["123M",10394,10394,13685.846105030008]
["133M",10733,10733,14133.571829585953]
["143M",11083,11083,14595.724806275812]
["153M",11445,11445,15073.747760312985]
["163M",11819,11819,15568.121600101935]
["173M",12207,12207,16080.769959260511]
["183M",12561,12561,16547.010657388317]
["193M",12933,12933,17039.520977109965]
["203M",13318,13318,17546.806606423263]
["213M",13713,13713,18069.310804615958]
["223M",14121,14121,18607.490128754442]
["233M",14540,14540,19161.814832617078]
["243M",14973,14973,19732.769277595584]
["253M",15418,15418,20320.852355923449]
["263M",15877,15877,20926.577926601163]
["273M",16349,16349,21550.475264399192]
["283M",16836,16836,22193.089522331171]
["293M",17337,17337,22854.982208001107]
["303M",19568,17853,23536.731674241142]
["313M",20151,18385,24238.933624468373]
["323M",20752,18932,24962.201633202425]
["333M",21370,19496,25707.167682198502]
["343M",22008,20077,26474.482712664456]
["353M",22664,20676,27264.817194044394]
["363M",23340,21292,28078.861709865723]
["373M",24036,21927,28917.327561161692]
["383M",24754,22581,29780.947387996541]
["393M",25492,23254,30670.475809636442]
["403M",24064,24064,31739.392462973719]
["413M",25021,25021,33003.768161492662]
["423M",26017,26017,34318.718887952367]
["433M",27052,27052,35686.267643470463]
["443M",28129,28129,37108.518349209291]
["453M",29249,29249,38587.659083177656]
["463M",30414,30414,40125.965446504764]
["473M",31625,31625,41725.804064364958]
["483M",32885,32885,43389.636226939561]
["493M",34195,34195,45120.021676017139]
["503M",35558,35558,46919.62254305782]
["513M",37152,37152,49025.155557495425]
["523M",39003,39003,51469.913335370198]
["533M",40947,40947,54036.909002138716]
["543M",42988,42988,56732.254452245645]
["553M",45131,45131,59562.367174857929]
["563M",47381,47381,62533.985533600833]
["573M",49743,49743,65654.184810280858]
["583M",52224,52224,68930.39405079493]
["593M",54828,54828,72370.413753334695]
["603M",63121,57563,75982.434441001402]
["613M",66586,60722,80154.318335256481]
["623M",70573,64358,84955.777435371856]
["633M",74800,68211,90045.324081494182]
["643M",79280,72296,95440.243526383842]
["653M",84029,76626,101158.8581379669]
["663M",89063,81216,107220.58962624491]
["673M",94399,86081,113646.02500381961]
["683M",100055,91238,120456.98650404878]
["693M",106051,96705,127676.60569429171]
["703M",112406,102499,135329.40203594923]
["713M",119142,108641,143441.36615810619]
["723M",126283,115152,152040.04812759257]
["733M",133852,122053,161154.65101524812]
["743M",141876,129369,170816.13007616301]
["753M",150380,137123,181057.29788073283]
["763M",159396,145343,191912.93575357681]
["773M",168951,154055,203419.91189879138]
["783M",179081,163291,215617.30661271885]
["793M",189818,173081,228546.54500948201]
["803M",201199,183458,242251.53771005096]
["813M",213263,194457,256778.82997265406]
["823M",226051,206117,272177.75977101328]
["833M",239606,218476,288500.62535727414]
["843M",253975,231577,305802.86287871061]
[]
["05M",12938,12938,17045.535851418448]
["15M",11531,11531,15187.843849167626]
["25M",10014,10014,13183.954172657364]
["35M",9359,9359,12319.166516437155]
["45M",8649,8649,11380.505123753694]
["55M",8926,8926,11746.774208735847]
["65M",9213,9213,12126.47488216587]
["75M",9511,9511,12519.090544488065]
["85M",9818,9818,12924.621195702437]
["95M",10136,10136,13344.616634476055]
["105M",10464,10464,13778.560261253218]
["115M",10804,10804,14227.485275145305]
["125M",11156,11156,14691.908275708012]
["135M",11520,11520,15172.862462052706]
["145M",11896,11896,15669.314635068005]
["155M",12285,12285,16182.814593420986]
["165M",12687,12687,16713.878936667326]
["175M",13104,13104,17264.574063029773]
["185M",13483,13483,17765.417332268422]
["195M",13884,13884,18294.479852236469]
["205M",14296,14296,18839.414247803568]
["215M",14721,14721,19400.696675237672]
["225M",15159,15159,19978.817575494802]
["235M",15610,15610,20574.282102759647]
["245M",16074,16074,21187.610565842435]
["255M",16553,16553,21819.338882817709]
["265M",17045,17045,22470.019049302246]
["275M",17553,17553,23140.21962078131]
["285M",18075,18075,23830.526209404754]
["295M",18614,18614,24541.54199568689]
["305M",21011,19168,25273.8882555575]
["315M",21637,19739,26028.204903224225]
["325M",22282,20328,26805.151050320957]
["335M",22947,20934,27605.405581830586]
["345M",23631,21558,28429.667749285501]
["355M",24336,22201,29278.657781764068]
["365M",25063,22863,30153.117515216989]
["375M",25811,23545,31053.8110406735]
["385M",26581,24247,31981.525371893702]
["395M",27375,24971,32937.071133050515]
["405M",25840,25840,34085.318622707287]
["415M",26868,26868,35443.531367615571]
["425M",27938,27938,36856.072622320193]
["435M",29050,29050,38325.115527212998]
["445M",30207,30207,39852.920148301535]
["455M",31410,31410,41441.836954233586]
["465M",32661,32661,43094.310432402941]
["475M",33963,33963,44812.882849699054]
["485M",35316,35316,46600.198163687019]
["495M",36723,36723,48459.006090234499]
["505M",38187,38187,50392.166333843874]
["515M",39900,39900,52653.963818866854]
["525M",41888,41888,55280.162009810192]
["535M",43976,43976,58037.670110300707]
["545M",46168,46168,60933.053615815727]
["555M",48470,48470,63973.206296606535]
["565M",50887,50887,67165.366611436868]
["575M",53425,53425,70517.134942008706]
["585M",56090,56090,74036.491689109156]
["595M",58888,58888,77731.816273564604]
["605M",67796,61826,81611.907087242842]
["615M",71518,65219,86093.411977041193]
["625M",75801,69124,91251.21669566365]
["635M",80342,73264,96718.489697403493]
["645M",85154,77652,102513.79907924771]
["655M",90256,82303,108656.82702400259]
["665M",95663,87234,115168.43664544275]
["675M",101395,92460,122070.74284416932]
["685M",107471,98000,129387.18741481951]
["695M",113912,103872,137142.61865970865]
["705M",120739,110097,145363.37577929118]
["715M",127975,116695,154077.3783260487]
["725M",135646,123689,163314.22102561156]
["735M",143777,131102,173105.27428714826]
["745M",152396,138960,183483.79074437715]
["755M",161532,147290,194485.01818903984]
["765M",171216,156120,206146.31928038227]
["775M",181481,165479,218507.29843720511]
["785M",192362,175400,231609.93634343744]
["795M",203896,185916,245498.73252404373]
["805M",216122,197064,260220.85647548642]
["815M",229081,208880,275826.30786401551]
["825M",242818,221405,292368.08633585653]
["835M",257379,234681,309902.37151600793]
["845M",272814,248754,328488.71380696847]

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

{"sheet":"Template PDF","index":4,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,1,53,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cotización"]
[]
[null,"Datos Titular"]
[null,"Nombre del titular:",{"$f":"'Datos Asegurado'!C7","v":"Usuario"},"Nombre Agente:",{"$f":"'Datos Asegurado'!C16","v":"Maria"}]
[null,"Edad:",{"$f":"'Datos Asegurado'!C8","v":45},"Agencia:",{"$f":"'Datos Asegurado'!C17","v":"Bupa Mex"}]
[null,"Género:",{"$f":"'Datos Asegurado'!C9","v":"Femenino"},{"$f":"'Datos Asegurado'!B6","v":"Fecha Cotización:"},{"$f":"'Datos Asegurado'!C6","v":"2022-01-19"}]
[null,"Zona residencia:",{"$f":"'Datos Asegurado'!D27","v":"Zona 1: CDMX, Area Metropolitana y Monterrey"}]
[null,"Número de integrantes a cotizar:",{"$f":"'Datos Asegurado'!C11","v":0}]
[]
[null,"Características de la Póliza"]
[]
[null,"Suma asegurada (mxn):",{"$f":"'Datos Asegurado'!B26","v":"$ 1,000,000 MNX"}]
[null,"Deducible (mxn):",{"$f":"'Datos Asegurado'!D25","v":10000}]
[null,"Coaseguro",{"$f":"'Datos Asegurado'!D26","v":0.2}]
[null,"Tipo de cliente:",{"$f":"+'Datos Asegurado'!B22","v":"Nuevo negocio "}]
[null,"Asistencia en el extranjero: ",{"$f":"'Datos Asegurado'!D24","v":"No"}]
[null,"Costo Poliza"]
[]
[null,"Concepto","Anual","Semestral","Trimestral","Mensual"]
[null,"Prima del asegurado titular:",{"$f":"'Datos Asegurado'!C32","v":23781},{"$f":"'Datos Asegurado'!D32","v":24851.144999999997},{"$f":"'Datos Asegurado'!E32","v":25564.575000000001},{"$f":"'Datos Asegurado'!F32","v":26396.910000000003}]
[null,"Prima cónyuge:",{"$f":"'Datos Asegurado'!C33","v":0},{"$f":"'Datos Asegurado'!D33","v":0},{"$f":"'Datos Asegurado'!E33","v":0},{"$f":"'Datos Asegurado'!F33","v":0}]
[null,"Prima hijo(s):",{"$f":"'Datos Asegurado'!C34","v":0},{"$f":"'Datos Asegurado'!D34","v":0},{"$f":"'Datos Asegurado'!E34","v":0},{"$f":"'Datos Asegurado'!F34","v":0}]
[null,"Dependientes económicos",{"$f":"'Datos Asegurado'!C35","v":0},{"$f":"'Datos Asegurado'!D35","v":0},{"$f":"'Datos Asegurado'!E35","v":0},{"$f":"'Datos Asegurado'!F35","v":0}]
[null,"Total Prima:",{"$f":"'Datos Asegurado'!C36","v":23781},{"$f":"'Datos Asegurado'!D36","v":24851.144999999997},{"$f":"'Datos Asegurado'!E36","v":25564.575000000001},{"$f":"'Datos Asegurado'!F36","v":26396.910000000003}]
[null,"Asistencia en el extranjero:",{"$f":"'Datos Asegurado'!C37","v":0},{"$f":"'Datos Asegurado'!D37","v":0},{"$f":"'Datos Asegurado'!E37","v":0},{"$f":"'Datos Asegurado'!F37","v":0}]
[null,"Derecho de póliza:",{"$f":"'Datos Asegurado'!C38","v":1500},{"$f":"'Datos Asegurado'!D38","v":1500},{"$f":"'Datos Asegurado'!E38","v":1500},{"$f":"'Datos Asegurado'!F38","v":1500}]
[null,"Total descuento\n(derecho de póliza y recargo por pago fraccionado)",{"$f":"'Datos Asegurado'!C39","v":-1500},{"$f":"'Datos Asegurado'!D39","v":-2570.145},{"$f":"'Datos Asegurado'!E39","v":-3283.5749999999998},{"$f":"'Datos Asegurado'!F39","v":-4115.91}]
[null,"IVA (16%)",{"$f":"'Datos Asegurado'!C40","v":3804.96},{"$f":"'Datos Asegurado'!D40","v":1816.8683999999996},{"$f":"'Datos Asegurado'!E40","v":737.21100000000013},{"$f":"'Datos Asegurado'!F40","v":-66.586799999999926}]
[null,"Total a pagar:",{"$f":"'Datos Asegurado'!C41","v":27585.96},{"$f":"'Datos Asegurado'!D41","v":27585.959999999995},{"$f":"'Datos Asegurado'!E41","v":27585.96},{"$f":"'Datos Asegurado'!F41","v":27585.960000000003}]
[null,"Primer Pago:",{"$f":"'Datos Asegurado'!C42","v":27585.96},{"$f":"'Datos Asegurado'!D42","v":13792.979999999998},{"$f":"'Datos Asegurado'!E42","v":6896.49},{"$f":"'Datos Asegurado'!F42","v":2298.83}]
[null,"Pagos Subsecuentes:",{"$f":"'Datos Asegurado'!C43","v":0},{"$f":"'Datos Asegurado'!D43","v":13792.979999999998},{"$f":"'Datos Asegurado'!E43","v":6896.49},{"$f":"'Datos Asegurado'!F43","v":2298.83}]
[]
[null,"Tarifas expresadas en $MXN – Válidas a partir del 27 de agosto del 2021"]
[null,"La presente cotización es de carácter informativo, no constituye una solicitud de seguro y/o el monto de la prima definitiva y/o las condiciones de la misma y/o una oferta de aseguramiento en términos del artículo 5to de la Ley Sobre el Contrato de Seguro. La emisión de la póliza así como posibles cambios en la tarifa están sujetos a valoración del riesgo de acuerdo con las políticas de Suscripción de Bupa México y es susceptible de modificaciones, por lo que Bupa podrá aceptar o negar el aseguramiento del riesgo propuesto."]

{"sheet":"Objetos Estructura","index":5,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Estructuras Maestras"]
[]
["Estructura asegurado"]
[null,"Seleccione una opción","Masculino",18]

{"sheet":"Master","index":6,"n_rows":87,"n_cols":41,"rows_kept":87,"cut":false,"hidden":true,"merged":[[0,17,0,18],[1,21,1,22],[0,28,0,29],[0,30,0,31],[0,32,0,33]]}
["Datos Maestros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prima Base",null,null,null,null,null,null,null,null,null,null,"Prima Riesgo Nuevo NN Eliminacion periodos de espera",null,"Prima Tarifa Nuevo Producto NN Eliminacion periodos de espera",null,"Prima Tarifa Nuevo Producto Ren Eliminacion periodos de espera",null,"Tarifa Base, elimación","Aceptación Periodos de Espera","Bupa Internacional",null,"Descuento nuevo negocio","Asistencia en el extranjero","Asistencia Extranjero Valor"]
["Genero","Lugares de residencia","Zona","FD Zona","Parentezco","Dias","Meses","Años","Tipo Cliente","Factor descuento","Sumas aseguradas","FD Suma asegurada","Deducibles","Maternidad Aplica","FD Deducible","Coasegurado","FD Coasegurado","Edad",40000,"Factor es mujer","Administración","Factor descuento",null,"Recargos","NN","Renovacion","Transfer","Seguro dental","Edad","Valor","Edad","Valor","Edad","Valor","Valor","Valor","Valor",null,"Si","Si",1632]
["Masculino","Aguascalientes","Zona 2",0.8,"Seleccione una opción","01","01",1946,"Nuevo negocio - con periodos de espera",0.89,5000000,0.87261999999999995,9000,"Si",1.1146,0,1,0,16257.969000000003,2600,1500,"Tipo cliente",{"$f":"VLOOKUP('Datos Asegurado'!#REF!,Master!I3:J5,2,FALSE)","v":{"$error":"#REF!"}},"Administracion",0.15,0.15,0.15,400,{"$f":"R3","v":0},{"$f":"S3*$W$14+$AB$3","v":{"$error":"#REF!"}},{"$f":"AC3","v":0},{"$f":"AD3/(1-SUM($Y$3:$Y$5))","v":{"$error":"#REF!"}},{"$f":"AE3","v":0},{"$f":"AD3/(1-SUM($Z$3:$Z$5))","v":{"$error":"#REF!"}},{"$f":"AF3","v":{"$error":"#REF!"}},{"$f":"AI3*90%","v":{"$error":"#REF!"}},{"$f":"AI3","v":{"$error":"#REF!"}},null,"No","No"]
["Femenino","Baja California Norte","Zona 1",1,"Cónyuge","02","02",1947,"Nuevo negocio - reconocimiento de antigüedad",0.95,10000000,0.91164999999999996,17000,"Si",1.0789200000000001,0.1,0.94257000000000002,1,14413.027840764884,null,null,"Zona",{"$f":"VLOOKUP('Datos Asegurado'!#REF!,Master!B3:D35,3,FALSE)","v":{"$error":"#REF!"}},"Adquisicion",0.2,0.17,0.09,null,1,{"$f":"S4*$W$14+$AB$3","v":{"$error":"#REF!"}},{"$f":"AC4","v":1},{"$f":"AD4/(1-SUM($Y$3:$Y$5))","v":{"$error":"#REF!"}},{"$f":"AE4","v":1},{"$f":"AD4/(1-SUM($Z$3:$Z$5))","v":{"$error":"#REF!"}},{"$f":"AF4","v":{"$error":"#REF!"}},{"$f":"AI4*90%","v":{"$error":"#REF!"}},{"$f":"AI4","v":{"$error":"#REF!"}}]
[null,"Baja California Sur","Zona 1",1,"Hij@","03","03",1948,"Transfer Bupa Internacional",1,20000000,0.95067000000000002,35000,"Si",1.01542,0.2,0.91091,2,12422.519968606075,null,null,"Suma asegurada",{"$f":"VLOOKUP('Datos Asegurado'!#REF!,Master!K3:L6,2,FALSE)","v":{"$error":"#REF!"}},"Utilidad",0.04,0.04,0.04,null,2,{"$error":"#REF!"},2,{"$error":"#REF!"},2,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Campeche","Zona 2",0.8,"Dependiente económico","04","04",1949,null,null,50000000,1,55000,"No",0.95747000000000004,null,null,3,11563.463583180401,null,null,"Deducible",{"$f":"VLOOKUP('Datos Asegurado'!#REF!,Master!M3:O11,3,FALSE)","v":{"$error":"#REF!"}},"Total",{"$f":"SUM(Y3:Y5)","v":0.38999999999999996},{"$f":"SUM(Z3:Z5)","v":0.36},{"$f":"SUM(AA3:AA5)","v":0.27999999999999997},null,3,{"$error":"#REF!"},3,{"$error":"#REF!"},3,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Coahuila","Zona 2",0.8,null,"05","05",1950,null,null,null,null,115000,"No",0.82316999999999996,null,null,4,10630.927064436317,null,null,"Coasegurado",{"$f":"VLOOKUP('Datos Asegurado'!#REF!,Master!P3:Q7,2,FALSE)","v":{"$error":"#REF!"}},"1-Total",{"$f":"1-Y6","v":0.6100000000000001},{"$f":"1-Z6","v":0.64},{"$f":"1-AA6","v":0.72},null,4,{"$error":"#REF!"},4,{"$error":"#REF!"},4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Colima","Zona 2",0.8,null,"06","06",1951,null,null,null,null,null,null,null,null,null,5,10995.294412953532,null,null,"Cobertura Extranjero: (no)",0.85492999999999997,null,null,null,null,null,5,{"$error":"#REF!"},5,{"$error":"#REF!"},5,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Chiapas","Zona 2",0.8,null,"07","07",1952,null,null,null,null,null,null,null,null,null,6,11372.150189230695,null,null,"Reducción Honorarios: (Reducido)",0.9,null,null,null,null,null,6,{"$error":"#REF!"},6,{"$error":"#REF!"},6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Chihuahua","Zona 2",0.8,null,"08","08",1953,null,null,null,null,null,null,null,null,null,7,11761.922425111356,null,null,"Copago Medicamentos: (0)",1,null,null,null,null,null,7,{"$error":"#REF!"},7,{"$error":"#REF!"},7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Ciudad de México y área metropolitana","Zona 1",1,null,"09","09",1954,null,null,null,null,null,null,null,null,null,8,12165.053822921418,null,null,"Reduccion a Consultas: (25)",0.98,null,null,null,null,null,8,{"$error":"#REF!"},8,{"$error":"#REF!"},8,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Estado de México","Zona 2",0.8,null,"10","10",1955,null,null,null,null,null,null,null,null,null,9,12582.002258289331,null,null,"Re. Renuncia utilidad: (Si)",0.95,null,null,null,null,null,9,{"$error":"#REF!"},9,{"$error":"#REF!"},9,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Durango","Zona 2",0.8,null,"11","11",1956,null,null,null,null,null,null,null,null,null,10,13013.241300200078,null,null,"Re. Adicional Actuarial: (Si)",0.95,null,null,null,null,null,10,{"$error":"#REF!"},10,{"$error":"#REF!"},10,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Guanajuato","Zona 2",0.8,null,"12","12",1957,null,null,null,null,null,null,null,null,null,11,13459.260748873632,null,null,"Factor descuento sin tipo cliente",{"$f":"W5*W6*W7*W8*W9*W10*W11*W12*W13*W4","v":{"$error":"#REF!"}},null,null,null,null,null,11,{"$error":"#REF!"},11,{"$error":"#REF!"},11,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Guerrero","Zona 2",0.8,null,"13",null,1958,null,null,null,null,null,null,null,null,null,12,13920.567192078823,null,null,"Factor descuento con tipo cliente",{"$f":"W3*W4*W5*W6*W7*W8*W9*W10*W11*W12*W13","v":{"$error":"#REF!"}},null,null,null,null,null,12,{"$error":"#REF!"},12,{"$error":"#REF!"},12,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Hidalgo","Zona 2",0.8,null,"14",null,1959,null,null,null,null,null,null,null,null,null,13,14397.684580514455,null,null,null,null,null,null,null,null,null,13,{"$error":"#REF!"},13,{"$error":"#REF!"},13,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Jalisco","Zona 1",1,null,"15",null,1960,null,null,null,null,null,null,null,null,null,14,14891.15482291118,null,null,null,null,null,null,null,null,null,14,{"$error":"#REF!"},14,{"$error":"#REF!"},14,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Michoacán","Zona 2",0.8,null,"16",null,1961,null,null,null,null,null,null,null,null,null,15,15401.538401530081,null,null,null,null,null,null,null,null,null,15,{"$error":"#REF!"},15,{"$error":"#REF!"},15,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Morelos","Zona 2",0.8,null,"17",null,1962,null,null,null,null,null,null,null,null,null,16,15929.415008757012,null,null,null,null,null,null,null,null,null,16,{"$error":"#REF!"},16,{"$error":"#REF!"},16,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Nayarit","Zona 2",0.8,null,"18",null,1963,null,null,null,null,null,null,null,null,null,17,16475.384205515762,null,null,null,null,null,null,null,null,null,17,{"$error":"#REF!"},17,{"$error":"#REF!"},17,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Nuevo León","Zona 1",1,null,"19",null,1964,null,null,null,null,null,null,null,null,null,18,16973.026013074697,null,null,null,null,null,null,null,null,null,18,{"$error":"#REF!"},18,{"$error":"#REF!"},18,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Oaxaca","Zona 2",0.8,null,"20",null,1965,null,null,null,null,null,null,null,null,null,19,17712.20798378098,null,null,null,null,null,null,null,null,null,19,{"$error":"#REF!"},19,{"$error":"#REF!"},19,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Puebla","Zona 2",0.8,null,"21",null,1966,null,null,null,null,null,null,null,null,null,20,18521.788237411674,null,null,null,null,null,null,null,null,null,20,{"$error":"#REF!"},20,{"$error":"#REF!"},20,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Querétaro","Zona 2",0.8,null,"22",null,1967,null,null,null,null,null,null,null,null,null,21,19331.368491042362,null,null,null,null,null,null,null,null,null,21,{"$error":"#REF!"},21,{"$error":"#REF!"},21,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Quintana Roo zona 1","Zona 1",1,null,"23","s",1968,null,null,null,null,null,null,null,null,null,22,20091.669946625963,null,null,null,null,null,null,null,null,null,22,{"$error":"#REF!"},22,{"$error":"#REF!"},22,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Quintana Roo zona 2","Zona 2",0.8,null,"24",null,1969,null,null,null,null,null,null,null,null,null,23,20957.56882659618,null,null,null,null,null,null,null,null,null,23,{"$error":"#REF!"},23,{"$error":"#REF!"},23,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"San Luis Potosí","Zona 2",0.8,null,"25",null,1970,null,null,null,null,null,null,null,null,null,24,21767.149080226867,null,null,null,null,null,null,null,null,null,24,{"$error":"#REF!"},24,{"$error":"#REF!"},24,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Sinaloa","Zona 2",0.8,null,"26",null,1971,null,null,null,null,null,null,null,null,null,25,22330.335343622126,null,null,null,null,null,null,null,null,null,25,{"$error":"#REF!"},25,{"$error":"#REF!"},25,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Sonora","Zona 1",1,null,"27",null,1972,null,null,null,null,null,null,null,null,null,26,23196.234223592342,null,null,null,null,null,null,null,null,null,26,{"$error":"#REF!"},26,{"$error":"#REF!"},26,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Tabasco","Zona 2",0.8,null,"28",null,1973,null,null,null,null,null,null,null,null,null,27,24033.973790392793,null,null,null,null,null,null,null,null,null,27,{"$error":"#REF!"},27,{"$error":"#REF!"},27,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Tamaulipas","Zona 2",0.8,null,"29",null,1974,null,null,null,null,null,null,null,null,null,28,24899.872670363009,null,null,null,null,null,null,null,null,null,28,{"$error":"#REF!"},28,{"$error":"#REF!"},28,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Tlaxcala","Zona 2",0.8,null,"30",null,1975,null,null,null,null,null,null,null,null,null,29,25962.886742521569,null,null,null,null,null,null,null,null,null,29,{"$error":"#REF!"},29,{"$error":"#REF!"},29,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Veracruz","Zona 2",0.8,null,"31",null,1976,null,null,null,null,null,null,null,null,null,30,28307.93176704795,null,null,null,null,null,null,null,null,null,30,{"$error":"#REF!"},30,{"$error":"#REF!"},30,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Yucatán","Zona 2",0.8,null,null,null,1977,null,null,null,null,null,null,null,null,null,31,29506.423423678807,null,null,null,null,null,null,null,null,null,31,{"$error":"#REF!"},31,{"$error":"#REF!"},31,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Zacatecas","Zona 2",0.8,null,null,null,1978,null,null,null,null,null,null,null,null,null,32,30690.209661209905,null,null,null,null,null,null,null,null,null,32,{"$error":"#REF!"},32,{"$error":"#REF!"},32,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1979,null,null,null,null,null,null,null,null,null,33,31513.713130796754,null,null,null,null,null,null,null,null,null,33,{"$error":"#REF!"},33,{"$error":"#REF!"},33,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1980,null,null,null,null,null,null,null,null,null,34,32396.038276782663,null,null,null,null,null,null,null,null,null,34,{"$error":"#REF!"},34,{"$error":"#REF!"},34,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1981,null,null,null,null,null,null,null,null,null,35,33212.18903681964,null,null,null,null,null,null,null,null,null,{"$f":"R38","v":35},{"$error":"#REF!"},35,{"$error":"#REF!"},35,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1982,null,null,null,null,null,null,null,null,null,36,34065.10334460601,null,null,null,null,null,null,null,null,null,36,{"$error":"#REF!"},36,{"$error":"#REF!"},36,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1983,null,null,null,null,null,null,null,null,null,37,34918.017652392395,null,null,null,null,null,null,null,null,null,37,{"$error":"#REF!"},37,{"$error":"#REF!"},37,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1984,null,null,null,null,null,null,null,null,null,38,35734.168412429361,null,null,null,null,null,null,null,null,null,38,{"$error":"#REF!"},38,{"$error":"#REF!"},38,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1985,null,null,null,null,null,null,null,null,null,39,36851.780264011511,null,null,null,null,null,null,null,null,null,39,{"$error":"#REF!"},39,{"$error":"#REF!"},39,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1986,null,null,null,null,null,null,null,null,null,40,37866.454181895308,null,null,null,null,null,null,null,null,null,40,{"$error":"#REF!"},40,{"$error":"#REF!"},40,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1987,null,null,null,null,null,null,null,null,null,41,38866.42268067933,null,null,null,null,null,null,null,null,null,41,{"$error":"#REF!"},41,{"$error":"#REF!"},41,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1988,null,null,null,null,null,null,null,null,null,42,39881.096598563126,null,null,null,null,null,null,null,null,null,42,{"$error":"#REF!"},42,{"$error":"#REF!"},42,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1989,null,null,null,null,null,null,null,null,null,43,41042.824707444583,null,null,null,null,null,null,null,null,null,43,{"$error":"#REF!"},43,{"$error":"#REF!"},43,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1990,null,null,null,null,null,null,null,null,null,44,42241.316364075443,null,null,null,null,null,null,null,null,null,44,{"$error":"#REF!"},44,{"$error":"#REF!"},44,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1991,null,null,null,null,null,null,null,null,null,45,43879.640848355128,null,null,null,null,null,null,null,null,null,45,{"$error":"#REF!"},45,{"$error":"#REF!"},45,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1992,null,null,null,null,null,null,null,null,null,46,45128.037065547964,null,null,null,null,null,null,null,null,null,46,{"$error":"#REF!"},46,{"$error":"#REF!"},46,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1993,null,null,null,null,null,null,null,null,null,47,46316.985843826849,null,null,null,null,null,null,null,null,null,47,{"$error":"#REF!"},47,{"$error":"#REF!"},47,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1994,null,null,null,null,null,null,null,null,null,48,48598.281312149455,null,null,null,null,null,null,null,null,null,48,{"$error":"#REF!"},48,{"$error":"#REF!"},48,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1995,null,null,null,null,null,null,null,null,null,49,50188.500303097469,null,null,null,null,null,null,null,null,null,49,{"$error":"#REF!"},49,{"$error":"#REF!"},49,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1996,null,null,null,null,null,null,null,null,null,50,52090.974788972402,null,null,null,null,null,null,null,null,null,50,{"$error":"#REF!"},50,{"$error":"#REF!"},50,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1997,null,null,null,null,null,null,null,null,null,51,53427.603520763827,null,null,null,null,null,null,null,null,null,51,{"$error":"#REF!"},51,{"$error":"#REF!"},51,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1998,null,null,null,null,null,null,null,null,null,52,55865.808939693517,null,null,null,null,null,null,null,null,null,52,{"$error":"#REF!"},52,{"$error":"#REF!"},52,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,1999,null,null,null,null,null,null,null,null,null,53,59037.329805752437,null,null,null,null,null,null,null,null,null,53,{"$error":"#REF!"},53,{"$error":"#REF!"},53,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2000,null,null,null,null,null,null,null,null,null,54,62777.903458783665,null,null,null,null,null,null,null,null,null,54,{"$error":"#REF!"},54,{"$error":"#REF!"},54,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2001,null,null,null,null,null,null,null,null,null,55,67440.851058753353,null,null,null,null,null,null,null,null,null,55,{"$error":"#REF!"},55,{"$error":"#REF!"},55,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2002,null,null,null,null,null,null,null,null,null,56,72945.292800612777,null,null,null,null,null,null,null,null,null,56,{"$error":"#REF!"},56,{"$error":"#REF!"},56,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2003,null,null,null,null,null,null,null,null,null,57,76482.180755049383,null,null,null,null,null,null,null,null,null,57,{"$error":"#REF!"},57,{"$error":"#REF!"},57,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2004,null,null,null,null,null,null,null,null,null,58,82089.638650921552,null,null,null,null,null,null,null,null,null,58,{"$error":"#REF!"},58,{"$error":"#REF!"},58,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2005,null,null,null,null,null,null,null,null,null,59,87834.060317238851,null,null,null,null,null,null,null,null,null,59,{"$error":"#REF!"},59,{"$error":"#REF!"},59,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2006,null,null,null,null,null,null,null,null,null,60,94150.507142474147,null,null,null,null,null,null,null,null,null,60,{"$error":"#REF!"},60,{"$error":"#REF!"},60,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2007,null,null,null,null,null,null,null,null,null,61,100587.80435339635,null,null,null,null,null,null,null,null,null,61,{"$error":"#REF!"},61,{"$error":"#REF!"},61,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2008,null,null,null,null,null,null,null,null,null,62,107226.51887379673,null,null,null,null,null,null,null,null,null,62,{"$error":"#REF!"},62,{"$error":"#REF!"},62,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2009,null,null,null,null,null,null,null,null,null,63,116830.0961897157,null,null,null,null,null,null,null,null,null,63,{"$error":"#REF!"},63,{"$error":"#REF!"},63,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2010,null,null,null,null,null,null,null,null,null,64,127859.7080567401,null,null,null,null,null,null,null,null,null,64,{"$error":"#REF!"},64,{"$error":"#REF!"},64,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,65,138163.35718618514,null,null,null,null,null,null,null,null,null,65,{"$f":"S68*$W$14+$AB$3","v":{"$error":"#REF!"}},{"$f":"AC68","v":65},{"$f":"AD68/(1-SUM($Y$3:$Y$5))","v":{"$error":"#REF!"}},{"$f":"AE68","v":65},{"$f":"AD68/(1-SUM($Z$3:$Z$5))","v":{"$error":"#REF!"}},{"$f":"AF68","v":{"$error":"#REF!"}},{"$f":"AI68*90%","v":{"$error":"#REF!"}},{"$f":"AI68","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,null,66,147274.4594028907,null,null,null,null,null,null,null,null,null,66,{"$error":"#REF!"},66,{"$error":"#REF!"},66,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,null,67,156556.39478615948,null,null,null,null,null,null,null,null,null,67,{"$error":"#REF!"},67,{"$error":"#REF!"},67,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2014,null,null,null,null,null,null,null,null,null,68,169084.16033412964,null,null,null,null,null,null,null,null,null,68,{"$error":"#REF!"},68,{"$error":"#REF!"},68,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,69,181864.10817559794,null,null,null,null,null,null,null,null,null,69,{"$error":"#REF!"},69,{"$error":"#REF!"},69,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,70,194701.00040592061,null,null,null,null,null,null,null,null,null,70,{"$error":"#REF!"},70,{"$error":"#REF!"},70,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,71,207668.05123933902,null,null,null,null,null,null,null,null,null,71,{"$error":"#REF!"},71,{"$error":"#REF!"},71,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,null,72,220740.85593777284,null,null,null,null,null,null,null,null,null,72,{"$error":"#REF!"},72,{"$error":"#REF!"},72,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,73,236189.05514270486,null,null,null,null,null,null,null,null,null,73,{"$error":"#REF!"},73,{"$error":"#REF!"},73,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,74,251767.41295073269,null,null,null,null,null,null,null,null,null,74,{"$error":"#REF!"},74,{"$error":"#REF!"},74,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,2021,null,null,null,null,null,null,null,null,null,75,267500.33409993676,null,null,null,null,null,null,null,null,null,75,{"$error":"#REF!"},75,{"$error":"#REF!"},75,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,283379.68367762357,null,null,null,null,null,null,null,null,null,76,{"$error":"#REF!"},76,{"$error":"#REF!"},76,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,299372.92203301931,null,null,null,null,null,null,null,null,null,77,{"$error":"#REF!"},77,{"$error":"#REF!"},77,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,315813.58058655675,null,null,null,null,null,null,null,null,null,78,{"$error":"#REF!"},78,{"$error":"#REF!"},78,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,332441.34213204443,null,null,null,null,null,null,null,null,null,79,{"$error":"#REF!"},79,{"$error":"#REF!"},79,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,349264.34158217575,null,null,null,null,null,null,null,null,null,80,{"$error":"#REF!"},80,{"$error":"#REF!"},80,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,366062.93629422662,null,null,null,null,null,null,null,null,null,81,{"$error":"#REF!"},81,{"$error":"#REF!"},81,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,383138.11803785607,null,null,null,null,null,null,null,null,null,82,{"$error":"#REF!"},82,{"$error":"#REF!"},82,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,400359.72820996825,null,null,null,null,null,null,null,null,null,83,{"$error":"#REF!"},83,{"$error":"#REF!"},83,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,417573.20346938702,null,null,null,null,null,null,null,null,null,84,{"$error":"#REF!"},84,{"$error":"#REF!"},84,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]