{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Datos Asegurado","Instrucciones","Comparativo","Template PDF","Template PDF Comparativo","Brochure","Objetos Estructura","Master"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":4,"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":"Datos Asegurado","index":0,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,7,2,13],[3,10,3,12],[23,2,23,3],[1,0,2,5],[36,0,36,1],[6,2,6,3],[36,10,36,12],[11,4,12,5]]}
[]
["   Cotización",null,null,null,null,null,null,"   Integrantes adicionales a cotizar"]
[]
["   1. Ingrese los datos del asegurado",null,null,null,null,null,null,null,null,null,"Fecha de Nacimiento"]
[null,null,null,null,null,null,null,"Número ","Relación","Género","Día","Mes","Año","Edad"]
[null,"Fecha Cotización:",{"$f":"TODAY()","v":"2022-03-29"}]
[null,"Nombre del titular:"]
[null,"Edad del titular:"]
[null,"Género:"]
[]
[null,"Lugar de residencia:",null,"Zona:",{"$f":"VLOOKUP(C11,Master!B3:C35,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Número de integrantes adicionales a cotizar:"]
[]
[]
["   2. Datos del agente"]
[]
[null,"Nombre del agente:"]
[null,"Agencia:"]
[]
[]
["   3. Datos de la póliza"]
[]
[null,"Tipo de  cliente:"]
[]
[null,"Zona:",{"$f":"'Datos Asegurado'!E11","v":{"$error":"#N/A"}}]
[null,"Suma asegurada (mxn):"]
[null,null,null,"Maternidad"]
[null,"Deducible (mxn):",null,"Titular:","No"]
[null,null,null,"Conyuge:","No"]
[null,"Coaseguro:",null,"Descuento Nuevo Negocio:","Si"]
[null,null,null,"Asistencia en el extranjero:","Si"]
[]
[]
["    4. Costo Poliza",null,null,null,null,null,null,"   5. Compara"]
[]
["Concepto ",null,null,"Semestral","Trimestral","Mensual",null,null,"Guardar para comparar",null,"Limpiar"]
[null,"Prima del asegurado titular:",null,{"$f":"(C38*4.5%+C38)/2","v":0},{"$f":"(C38*7.5% + C38)/4","v":0},{"$f":"(C38*11%+C38)/12","v":0}]
[null,"Prima cónyuge:",null,{"$f":"(C39*4.5%+C39)/2","v":0},{"$f":"(C39*7.5% + C39)/4","v":0},{"$f":"(C39*11%+C39)/12","v":0}]
[null,"Prima hijo(s):",null,0,0,0]
[null,"Dependientes económicos",null,0,0,0,null,null,null,null,null,null,null,null,null," "]
[null,"Total Prima:",{"$f":"SUM(C38:C41)","v":0},{"$f":"SUM(D38:D41)","v":0},0,0]
[null,"10% de descuento (Anual)",{"$f":"IF($E$31=\"Si\",(-1)*C42*10%,0)","v":0},{"$f":"IF($E$31=\"Si\",(-1)*C42*10%,0)","v":0},{"$f":"IF($E$31=\"Si\",(-1)*C42*10%,0)","v":0},{"$f":"IF($E$31=\"Si\",(-1)*C42*10%,0)","v":0}]
[null,"Asistencia en el extranjero:",{"$f":"IF($E$32=\"Si\",1632,0)","v":1632},{"$f":"IF($E$32=\"Si\",1632,0)","v":1632},1632,1632]
[null,"Descuento asistencia en el extranjero",{"$f":"IF($E$32=\"Si\",-1632,0)","v":-1632},{"$f":"IF($E$32=\"Si\",-1632,0)","v":-1632},-1632,-1632]
[null,"Derecho de póliza:",{"$f":"Master!U3","v":1500},1500,1500,1500]
[null,"IVA (16%)",{"$f":"(C42+C43+C46) * 16%","v":240},{"$f":"(((($C$42+$C$43)*1.045)/2)+$D$46)*16%","v":240},{"$f":"(((($C$42+$C$43)*1.075)/4)+$D$46)*16%","v":240},{"$f":"(((($C$42+$C$43)*1.11)/12)+$D$46)*16%","v":240}]
[null,"Primer Pago:",{"$f":"C42+C46+C47+C43+C44+C45","v":1740},{"$f":"(((($C$42+$C$43)*1.045)/2)+D46)*1.16","v":1739.9999999999998},{"$f":"(((($C$42+$C$43)*1.075)/4)+E46)*1.16","v":1739.9999999999998},{"$f":"(((($C$42+$C$43)*1.11)/12)+F46)*1.16","v":1739.9999999999998}]
[null,"Pagos Subsecuentes:",null,{"$f":"(((($C$42+$C$43)*1.045)/2))*1.16","v":0},{"$f":"(((($C$42+$C$43)*1.075)/4))*1.16","v":0},{"$f":"(((($C$42+$C$43)*1.11)/12))*1.16","v":0}]

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

{"sheet":"Comparativo","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[null,"   Datos de usuario"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   Datos de póliza",null,null,null,null,null,null,"  Opción  1"]
[null,null,null,null,null,null,null,null,null,"Datos de cotización"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   Datos de póliza"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"   Datos de póliza"]

{"sheet":"Template PDF","index":3,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,1,49,5],[50,1,50,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cotización"]
[]
[null,"Datos Titular"]
[null,"Nombre del titular:",{"$f":"'Datos Asegurado'!C7","v":0},"Nombre Agente:",{"$f":"'Datos Asegurado'!C18","v":0}]
[null,"Edad:",{"$f":"'Datos Asegurado'!C8","v":0},"Agencia:",{"$f":"'Datos Asegurado'!C19","v":0}]
[null,"Género:",{"$f":"'Datos Asegurado'!C9","v":0},{"$f":"'Datos Asegurado'!B6","v":"Fecha Cotización:"},{"$f":"'Datos Asegurado'!C6","v":"2022-03-29"}]
[null,"Lugar de residencia:",{"$f":"'Datos Asegurado'!C11","v":0}]
[null,"Número de integrantes a cotizar:",{"$f":"'Datos Asegurado'!C13","v":0}]
[]
[null,"Características de la Póliza"]
[null,"Suma asegurada (mxn):",{"$f":"'Datos Asegurado'!C27","v":0}]
[null,"Deducible (mxn):",{"$f":"'Datos Asegurado'!C29","v":0}]
[null,"Coaseguro",{"$f":"'Datos Asegurado'!C31","v":0}]
[null,"Tipo de cliente:",{"$f":"'Datos Asegurado'!C24:D24","v":0}]
[null,{"$f":"'Datos Asegurado'!D28","v":"Maternidad"},{"$f":"'Datos Asegurado'!D29","v":"Titular:"},{"$f":"'Datos Asegurado'!E29","v":"No"}]
[null,null,{"$f":"'Datos Asegurado'!D30","v":"Conyuge:"},{"$f":"'Datos Asegurado'!E30","v":"No"}]
[]
[null,"Costo Poliza"]
[null,"Concepto","Anual","Semestral","Trimestral","Mensual"]
[null,{"$f":"'Datos Asegurado'!B38","v":"Prima del asegurado titular:"},{"$f":"'Datos Asegurado'!C38","v":0},{"$f":"'Datos Asegurado'!D38","v":0},{"$f":"'Datos Asegurado'!E38","v":0},{"$f":"'Datos Asegurado'!F38","v":0}]
[null,{"$f":"'Datos Asegurado'!B39","v":"Prima cónyuge:"},{"$f":"'Datos Asegurado'!C39","v":0},{"$f":"'Datos Asegurado'!D39","v":0},{"$f":"'Datos Asegurado'!E39","v":0},{"$f":"'Datos Asegurado'!F39","v":0}]
[null,{"$f":"'Datos Asegurado'!B40","v":"Prima hijo(s):"},{"$f":"'Datos Asegurado'!C40","v":0},{"$f":"'Datos Asegurado'!D40","v":0},{"$f":"'Datos Asegurado'!E40","v":0},{"$f":"'Datos Asegurado'!F40","v":0}]
[null,{"$f":"'Datos Asegurado'!B41","v":"Dependientes económicos"},{"$f":"'Datos Asegurado'!C41","v":0},{"$f":"'Datos Asegurado'!D41","v":0},{"$f":"'Datos Asegurado'!E41","v":0},{"$f":"'Datos Asegurado'!F41","v":0}]
[null,{"$f":"'Datos Asegurado'!B42","v":"Total Prima:"},{"$f":"'Datos Asegurado'!C42","v":0},{"$f":"'Datos Asegurado'!D42","v":0},{"$f":"'Datos Asegurado'!E42","v":0},{"$f":"'Datos Asegurado'!F42","v":0}]
[null,{"$f":"'Datos Asegurado'!B43","v":"10% de descuento (Anual)"},{"$f":"'Datos Asegurado'!C43","v":0},{"$f":"'Datos Asegurado'!D43","v":0},{"$f":"'Datos Asegurado'!E43","v":0},{"$f":"'Datos Asegurado'!F43","v":0}]
[null,{"$f":"'Datos Asegurado'!B44","v":"Asistencia en el extranjero:"},{"$f":"'Datos Asegurado'!C44","v":1632},{"$f":"'Datos Asegurado'!D44","v":1632},{"$f":"'Datos Asegurado'!E44","v":1632},{"$f":"'Datos Asegurado'!F44","v":1632}]
[null,{"$f":"'Datos Asegurado'!B45","v":"Descuento asistencia en el extranjero"},{"$f":"'Datos Asegurado'!C45","v":-1632},{"$f":"'Datos Asegurado'!D45","v":-1632},{"$f":"'Datos Asegurado'!E45","v":-1632},{"$f":"'Datos Asegurado'!F45","v":-1632}]
[null,{"$f":"'Datos Asegurado'!B46","v":"Derecho de póliza:"},{"$f":"'Datos Asegurado'!C46","v":1500},{"$f":"'Datos Asegurado'!D46","v":1500},{"$f":"'Datos Asegurado'!E46","v":1500},{"$f":"'Datos Asegurado'!F46","v":1500}]
[null,{"$f":"'Datos Asegurado'!B47","v":"IVA (16%)"},{"$f":"'Datos Asegurado'!C47","v":240},{"$f":"'Datos Asegurado'!D47","v":240},{"$f":"'Datos Asegurado'!E47","v":240},{"$f":"'Datos Asegurado'!F47","v":240}]
[null,{"$f":"'Datos Asegurado'!B48","v":"Primer Pago:"},{"$f":"'Datos Asegurado'!C48","v":1740},{"$f":"'Datos Asegurado'!D48","v":1739.9999999999998},{"$f":"'Datos Asegurado'!E48","v":1739.9999999999998},{"$f":"'Datos Asegurado'!F48","v":1739.9999999999998}]
[null,{"$f":"'Datos Asegurado'!B49","v":"Pagos Subsecuentes:"},{"$f":"'Datos Asegurado'!C49","v":0},{"$f":"'Datos Asegurado'!D49","v":0},{"$f":"'Datos Asegurado'!E49","v":0},{"$f":"'Datos Asegurado'!F49","v":0}]
[]
[null,"Tarifas expresadas en $MXN – Válidas a partir del 15 de junio del 2020"]
[]
[null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una pólizade seguro Bupa esta sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[null,"Si tu residencia es zona 2, pero quieres tener acceso a zona 1; puedes también contratarlo. De acuerdo a lo señalado en condiciones generales de tu producto."]

{"sheet":"Template PDF Comparativo","index":4,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[14,1,14,5],[80,1,81,5],[82,1,82,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comparativo Cotizaciones"]
[]
[null,"Nombre del titular",{"$f":"Comparativo!D5","v":"00:00:00"},{"$f":"'Datos Asegurado'!B18","v":"Nombre del agente:"},{"$f":"'Datos Asegurado'!C18","v":"00:00:00"}]
[null,"Edad",{"$f":"'Datos Asegurado'!C8","v":0},{"$f":"'Datos Asegurado'!B19","v":"Agencia:"},{"$f":"'Datos Asegurado'!C19","v":"00:00:00"}]
[null,"Género",{"$f":"'Datos Asegurado'!C9","v":0},{"$f":"'Datos Asegurado'!B6","v":"Fecha Cotización:"},{"$f":"'Datos Asegurado'!C6","v":"2022-03-29"}]
[null,"Lugar de residencia",{"$f":"'Datos Asegurado'!C11","v":0}]
[null,"Número de integrantes a cotizar",{"$f":"'Datos Asegurado'!C13","v":0}]
[]
[null,"Opción 1"]
[null,"Suma asegurada (mxn)",{"$f":"Comparativo!D21","v":0},"Coaseguro",{"$f":"Comparativo!D25","v":0}]
[null,"Deducible (mxn)",{"$f":"Comparativo!D23","v":0},"Tipo de cliente",{"$f":"Comparativo!D18","v":0}]
[null,{"$f":"Comparativo!E22","v":0},{"$f":"CONCATENATE(Comparativo!E23,\" \",Comparativo!F23)","v":" "},null,{"$f":"CONCATENATE(Comparativo!E24,\" \",Comparativo!F24)","v":" "}]
[]
[null,"Concepto","Anual","Semestral","Trimestral","Mensual"]
[null,{"$f":"Comparativo!K19","v":0},{"$f":"Comparativo!L19","v":0},{"$f":"Comparativo!M19","v":0},{"$f":"Comparativo!N19","v":0},{"$f":"Comparativo!O19","v":0}]
[null,{"$f":"Comparativo!K20","v":0},{"$f":"Comparativo!L20","v":0},{"$f":"Comparativo!M20","v":0},{"$f":"Comparativo!N20","v":0},{"$f":"Comparativo!O20","v":0}]
[null,{"$f":"Comparativo!K21","v":0},{"$f":"Comparativo!L21","v":0},{"$f":"Comparativo!M21","v":0},{"$f":"Comparativo!N21","v":0},{"$f":"Comparativo!O21","v":0}]
[null,{"$f":"Comparativo!K22","v":0},{"$f":"Comparativo!L22","v":0},{"$f":"Comparativo!M22","v":0},{"$f":"Comparativo!N22","v":0},{"$f":"Comparativo!O22","v":0}]
[null,{"$f":"Comparativo!K23","v":0},{"$f":"Comparativo!L23","v":0},{"$f":"Comparativo!M23","v":0},{"$f":"Comparativo!N23","v":0},{"$f":"Comparativo!O23","v":0}]
[null,{"$f":"Comparativo!K24","v":0},{"$f":"Comparativo!L24","v":0},{"$f":"Comparativo!M24","v":0},{"$f":"Comparativo!N24","v":0},{"$f":"Comparativo!O24","v":0}]
[null,{"$f":"Comparativo!K25","v":0},{"$f":"Comparativo!L25","v":0},{"$f":"Comparativo!M25","v":0},{"$f":"Comparativo!N25","v":0},{"$f":"Comparativo!O25","v":0}]
[null,{"$f":"Comparativo!K26","v":0},{"$f":"Comparativo!L26","v":0},{"$f":"Comparativo!M26","v":0},{"$f":"Comparativo!N26","v":0},{"$f":"Comparativo!O26","v":0}]
[null,{"$f":"Comparativo!K27","v":0},{"$f":"Comparativo!L27","v":0},{"$f":"Comparativo!M27","v":0},{"$f":"Comparativo!N27","v":0},{"$f":"Comparativo!O27","v":0}]
[null,{"$f":"Comparativo!K28","v":0},{"$f":"Comparativo!L28","v":0},{"$f":"Comparativo!M28","v":0},{"$f":"Comparativo!N28","v":0},{"$f":"Comparativo!O28","v":0}]
[null,{"$f":"Comparativo!K29","v":0},{"$f":"Comparativo!L29","v":0},{"$f":"Comparativo!M29","v":0},{"$f":"Comparativo!N29","v":0},{"$f":"Comparativo!O29","v":0}]
[null,{"$f":"Comparativo!K30","v":0},{"$f":"Comparativo!L30","v":0},{"$f":"Comparativo!M30","v":0},{"$f":"Comparativo!N30","v":0},{"$f":"Comparativo!O30","v":0}]
[]
[null,"Opción 2"]
[null,"Suma asegurada (mxn)",{"$f":"Comparativo!D37","v":0},"Coaseguro",{"$f":"Comparativo!D41","v":0}]
[null,"Deducible (mxn)",{"$f":"Comparativo!D39","v":0},"Tipo de cliente",{"$f":"Comparativo!D34","v":0}]
[null,{"$f":"Comparativo!E38","v":0},{"$f":"CONCATENATE(Comparativo!E39,\" \",Comparativo!F39)","v":" "},null,{"$f":"CONCATENATE(Comparativo!E40,\" \",Comparativo!F40)","v":" "}]
[]
[null,"Concepto","Anual","Semestral","Trimestral","Mensual"]
[null,{"$f":"Comparativo!K35","v":0},{"$f":"Comparativo!L35","v":0},{"$f":"Comparativo!M35","v":0},{"$f":"Comparativo!N35","v":0},{"$f":"Comparativo!O35","v":0}]
[null,{"$f":"Comparativo!K36","v":0},{"$f":"Comparativo!L36","v":0},{"$f":"Comparativo!M36","v":0},{"$f":"Comparativo!N36","v":0},{"$f":"Comparativo!O36","v":0}]
[null,{"$f":"Comparativo!K37","v":0},{"$f":"Comparativo!L37","v":0},{"$f":"Comparativo!M37","v":0},{"$f":"Comparativo!N37","v":0},{"$f":"Comparativo!O37","v":0}]
[null,{"$f":"Comparativo!K38","v":0},{"$f":"Comparativo!L38","v":0},{"$f":"Comparativo!M38","v":0},{"$f":"Comparativo!N38","v":0},{"$f":"Comparativo!O38","v":0}]
[null,{"$f":"Comparativo!K39","v":0},{"$f":"Comparativo!L39","v":0},{"$f":"Comparativo!M39","v":0},{"$f":"Comparativo!N39","v":0},{"$f":"Comparativo!O39","v":0}]
[null,{"$f":"Comparativo!K40","v":0},{"$f":"Comparativo!L40","v":0},{"$f":"Comparativo!M40","v":0},{"$f":"Comparativo!N40","v":0},{"$f":"Comparativo!O40","v":0}]
[null,{"$f":"Comparativo!K41","v":0},{"$f":"Comparativo!L41","v":0},{"$f":"Comparativo!M41","v":0},{"$f":"Comparativo!N41","v":0},{"$f":"Comparativo!O41","v":0}]
[null,{"$f":"Comparativo!K42","v":0},{"$f":"Comparativo!L42","v":0},{"$f":"Comparativo!M42","v":0},{"$f":"Comparativo!N42","v":0},{"$f":"Comparativo!O42","v":0}]
[null,{"$f":"Comparativo!K43","v":0},{"$f":"Comparativo!L43","v":0},{"$f":"Comparativo!M43","v":0},{"$f":"Comparativo!N43","v":0},{"$f":"Comparativo!O43","v":0}]
[null,{"$f":"Comparativo!K44","v":0},{"$f":"Comparativo!L44","v":0},{"$f":"Comparativo!M44","v":0},{"$f":"Comparativo!N44","v":0},{"$f":"Comparativo!O44","v":0}]
[null,{"$f":"Comparativo!K45","v":0},{"$f":"Comparativo!L45","v":0},{"$f":"Comparativo!M45","v":0},{"$f":"Comparativo!N45","v":0},{"$f":"Comparativo!O45","v":0}]
[null,{"$f":"Comparativo!K46","v":0},{"$f":"Comparativo!L46","v":0},{"$f":"Comparativo!M46","v":0},{"$f":"Comparativo!N46","v":0},{"$f":"Comparativo!O46","v":0}]
[]
[null,"Opción 3"]
[null,"Suma asegurada (mxn)",{"$f":"Comparativo!D53","v":0},"Coaseguro",{"$f":"Comparativo!D57","v":0}]
[null,"Deducible (mxn)",{"$f":"Comparativo!D55","v":0},"Tipo de cliente",{"$f":"Comparativo!D50","v":0}]
[null,{"$f":"Comparativo!E54","v":0},{"$f":"CONCATENATE(Comparativo!E55,\" \",Comparativo!F55)","v":" "},null,{"$f":"CONCATENATE(Comparativo!E56,\" \",Comparativo!F56)","v":" "}]
[]
[null,"Concepto","Anual","Semestral","Trimestral","Mensual"]
[null,{"$f":"Comparativo!K51","v":0},{"$f":"Comparativo!L51","v":0},{"$f":"Comparativo!M51","v":0},{"$f":"Comparativo!N51","v":0},{"$f":"Comparativo!O51","v":0}]
[null,{"$f":"Comparativo!K52","v":0},{"$f":"Comparativo!L52","v":0},{"$f":"Comparativo!M52","v":0},{"$f":"Comparativo!N52","v":0},{"$f":"Comparativo!O52","v":0}]
[null,{"$f":"Comparativo!K53","v":0},{"$f":"Comparativo!L53","v":0},{"$f":"Comparativo!M53","v":0},{"$f":"Comparativo!N53","v":0},{"$f":"Comparativo!O53","v":0}]
[null,{"$f":"Comparativo!K54","v":0},{"$f":"Comparativo!L54","v":0},{"$f":"Comparativo!M54","v":0},{"$f":"Comparativo!N54","v":0},{"$f":"Comparativo!O54","v":0}]
[null,{"$f":"Comparativo!K55","v":0},{"$f":"Comparativo!L55","v":0},{"$f":"Comparativo!M55","v":0},{"$f":"Comparativo!N55","v":0},{"$f":"Comparativo!O55","v":0}]
[null,{"$f":"Comparativo!K56","v":0},{"$f":"Comparativo!L56","v":0},{"$f":"Comparativo!M56","v":0},{"$f":"Comparativo!N56","v":0},{"$f":"Comparativo!O56","v":0}]
[null,{"$f":"Comparativo!K57","v":0},{"$f":"Comparativo!L57","v":0},{"$f":"Comparativo!M57","v":0},{"$f":"Comparativo!N57","v":0},{"$f":"Comparativo!O57","v":0}]
[null,{"$f":"Comparativo!K58","v":0},{"$f":"Comparativo!L58","v":0},{"$f":"Comparativo!M58","v":0},{"$f":"Comparativo!N58","v":0},{"$f":"Comparativo!O58","v":0}]
[null,{"$f":"Comparativo!K59","v":0},{"$f":"Comparativo!L59","v":0},{"$f":"Comparativo!M59","v":0},{"$f":"Comparativo!N59","v":0},{"$f":"Comparativo!O59","v":0}]
[null,{"$f":"Comparativo!K60","v":0},{"$f":"Comparativo!L60","v":0},{"$f":"Comparativo!M60","v":0},{"$f":"Comparativo!N60","v":0},{"$f":"Comparativo!O60","v":0}]
[null,{"$f":"Comparativo!K61","v":0},{"$f":"Comparativo!L61","v":0},{"$f":"Comparativo!M61","v":0},{"$f":"Comparativo!N61","v":0},{"$f":"Comparativo!O61","v":0}]
[null,{"$f":"Comparativo!K62","v":0},{"$f":"Comparativo!L62","v":0},{"$f":"Comparativo!M62","v":0},{"$f":"Comparativo!N62","v":0},{"$f":"Comparativo!O62","v":0}]
[]
[null,"Tarifas expresadas en $MXN – Válidas a partir del 15 de junio del 2020"]
[null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una pólizade seguro Bupa esta sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[null,"Si tu residencia es zona 2, pero quieres tener acceso a zona 1; puedes también contratarlo. De acuerdo a lo señalado en condiciones generales de tu producto."]

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

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

{"sheet":"Master","index":7,"n_rows":87,"n_cols":40,"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,"Aplica descuento nuevo negocio","Asistencia en el extranjero"]
["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"]
["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'!C24,Master!I3:J5,2,FALSE)","v":{"$error":"#N/A"}},"Administracion",0.15,0.15,0.15,400,{"$f":"R3","v":0},{"$f":"S3*$W$14+$AB$3","v":{"$error":"#N/A"}},{"$f":"AC3","v":0},{"$f":"AD3/(1-SUM($Y$3:$Y$5))","v":{"$error":"#N/A"}},{"$f":"AE3","v":0},{"$f":"AD3/(1-SUM($Z$3:$Z$5))","v":{"$error":"#N/A"}},{"$f":"AF3","v":{"$error":"#N/A"}},{"$f":"AI3*90%","v":{"$error":"#N/A"}},{"$f":"AI3","v":{"$error":"#N/A"}},null,"No","No"]
["Femenino","Baja California Norte","Zona 1",1,"Conyuge","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'!C11,Master!B3:D35,3,FALSE)","v":{"$error":"#N/A"}},"Adquisicion",0.2,0.17,0.09,null,1,{"$f":"S4*$W$14+$AB$3","v":{"$error":"#N/A"}},{"$f":"AC4","v":1},{"$f":"AD4/(1-SUM($Y$3:$Y$5))","v":{"$error":"#N/A"}},{"$f":"AE4","v":1},{"$f":"AD4/(1-SUM($Z$3:$Z$5))","v":{"$error":"#N/A"}},{"$f":"AF4","v":{"$error":"#N/A"}},{"$f":"AI4*90%","v":{"$error":"#N/A"}},{"$f":"AI4","v":{"$error":"#N/A"}}]
[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'!C27,Master!K3:L6,2,FALSE)","v":{"$error":"#N/A"}},"Utilidad",0.04,0.04,0.04,null,2,{"$error":"#N/A"},2,{"$error":"#N/A"},2,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Campeche","Zona 2",0.8,"Dependiente economico","04","04",1949,null,null,50000000,1,55000,"No",0.95747000000000004,null,null,3,11563.463583180401,null,null,"Deducible",{"$f":"VLOOKUP('Datos Asegurado'!C29,Master!M3:O11,3,FALSE)","v":{"$error":"#N/A"}},"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":"#N/A"},3,{"$error":"#N/A"},3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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'!C31,Master!P3:Q7,2,FALSE)","v":1},"1-Total",{"$f":"1-Y6","v":0.6100000000000001},{"$f":"1-Z6","v":0.64},{"$f":"1-AA6","v":0.72},null,4,{"$error":"#N/A"},4,{"$error":"#N/A"},4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},5,{"$error":"#N/A"},5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},6,{"$error":"#N/A"},6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},7,{"$error":"#N/A"},7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ciudad de Mexico 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":"#N/A"},8,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Estado de Mexico","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":"#N/A"},9,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},10,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"}},null,null,null,null,null,11,{"$error":"#N/A"},11,{"$error":"#N/A"},11,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"}},null,null,null,null,null,12,{"$error":"#N/A"},12,{"$error":"#N/A"},12,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},13,{"$error":"#N/A"},13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},14,{"$error":"#N/A"},14,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},15,{"$error":"#N/A"},15,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},16,{"$error":"#N/A"},16,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},17,{"$error":"#N/A"},17,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},18,{"$error":"#N/A"},18,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},19,{"$error":"#N/A"},19,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},20,{"$error":"#N/A"},20,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},21,{"$error":"#N/A"},21,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Quintana Roo zona 1","Zona 1",1,null,"23",null,1968,null,null,null,null,null,null,null,null,null,22,20091.669946625963,null,null,null,null,null,null,null,null,null,22,{"$error":"#N/A"},22,{"$error":"#N/A"},22,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},23,{"$error":"#N/A"},23,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},24,{"$error":"#N/A"},24,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},25,{"$error":"#N/A"},25,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},26,{"$error":"#N/A"},26,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},27,{"$error":"#N/A"},27,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},28,{"$error":"#N/A"},28,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},29,{"$error":"#N/A"},29,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},30,{"$error":"#N/A"},30,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},31,{"$error":"#N/A"},31,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},32,{"$error":"#N/A"},32,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},33,{"$error":"#N/A"},33,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},34,{"$error":"#N/A"},34,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},35,{"$error":"#N/A"},35,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},36,{"$error":"#N/A"},36,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},37,{"$error":"#N/A"},37,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},38,{"$error":"#N/A"},38,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},39,{"$error":"#N/A"},39,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},40,{"$error":"#N/A"},40,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},41,{"$error":"#N/A"},41,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},42,{"$error":"#N/A"},42,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},43,{"$error":"#N/A"},43,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},44,{"$error":"#N/A"},44,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},45,{"$error":"#N/A"},45,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},46,{"$error":"#N/A"},46,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},47,{"$error":"#N/A"},47,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},48,{"$error":"#N/A"},48,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},49,{"$error":"#N/A"},49,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},50,{"$error":"#N/A"},50,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},51,{"$error":"#N/A"},51,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},52,{"$error":"#N/A"},52,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},53,{"$error":"#N/A"},53,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},54,{"$error":"#N/A"},54,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},55,{"$error":"#N/A"},55,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},56,{"$error":"#N/A"},56,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},57,{"$error":"#N/A"},57,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},58,{"$error":"#N/A"},58,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},59,{"$error":"#N/A"},59,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},60,{"$error":"#N/A"},60,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},61,{"$error":"#N/A"},61,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},62,{"$error":"#N/A"},62,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},63,{"$error":"#N/A"},63,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},64,{"$error":"#N/A"},64,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"}},{"$f":"AC68","v":65},{"$f":"AD68/(1-SUM($Y$3:$Y$5))","v":{"$error":"#N/A"}},{"$f":"AE68","v":65},{"$f":"AD68/(1-SUM($Z$3:$Z$5))","v":{"$error":"#N/A"}},{"$f":"AF68","v":{"$error":"#N/A"}},{"$f":"AI68*90%","v":{"$error":"#N/A"}},{"$f":"AI68","v":{"$error":"#N/A"}}]
[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":"#N/A"},66,{"$error":"#N/A"},66,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},67,{"$error":"#N/A"},67,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},68,{"$error":"#N/A"},68,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},69,{"$error":"#N/A"},69,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},70,{"$error":"#N/A"},70,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},71,{"$error":"#N/A"},71,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},72,{"$error":"#N/A"},72,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},73,{"$error":"#N/A"},73,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},74,{"$error":"#N/A"},74,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,267500.33409993676,null,null,null,null,null,null,null,null,null,75,{"$error":"#N/A"},75,{"$error":"#N/A"},75,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},76,{"$error":"#N/A"},76,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},77,{"$error":"#N/A"},77,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},78,{"$error":"#N/A"},78,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},79,{"$error":"#N/A"},79,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},80,{"$error":"#N/A"},80,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},81,{"$error":"#N/A"},81,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},82,{"$error":"#N/A"},82,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},83,{"$error":"#N/A"},83,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[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":"#N/A"},84,{"$error":"#N/A"},84,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]