{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Outil de calcul","Tarification 2023"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Outil de calcul","index":0,"n_rows":204,"n_cols":74,"rows_kept":204,"cut":false,"hidden":false,"merged":[[36,13,38,13],[37,10,37,11],[31,16,32,16],[33,10,33,11],[38,10,38,11],[36,14,38,14],[36,15,38,15],[20,10,20,11],[22,0,22,8],[36,10,36,11],[32,10,32,11],[25,10,25,11],[31,10,31,11],[26,10,26,11],[28,10,28,11],[34,3,34,10],[30,0,30,8],[0,10,0,15],[15,10,15,11],[15,13,16,13],[15,14,16,14],[15,15,16,15],[7,11,7,13],[8,11,8,13],[7,14,7,15],[8,14,8,15],[13,0,13,8],[11,13,11,15],[11,1,12,12],[16,10,16,11],[5,10,5,14]]}
[null,null,null,null,null,null,null,null,null,null,"Série Y-Z - Personnel d'encadrement des secteurs public et parapublic du Québec"]
[]
[]
["Instruction :",null,null,null,"Compléter les cases encadrées en rouge",null,null,null,null,null,null,null,null,null,null,"Outil de calcul des primes"]
["Identification de l'adhérent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K7*5","v":0}]
[null,"Nom de l'adhérent (facultatif)"]
[null,"Salaire annuel"]
[null,"Salaire par période de 14 jours",null,null,null,null,null,null,null,null,{"$f":"+$K$7/26","v":0},"Âge de l'adhérent pour la garantie maladie :",null,null,{"$f":"IF(K9=\"\",\"\",+BS165)","v":""},null,null,{"$f":"+$K$7/26","v":0}]
[null,"Date de naissance",null,null,null,null,null,null,null,null,null,"Âge de l'adhérent pour toutes les autres garanties :",null,null,{"$f":"IF(K9=\"\",\"\",+BL165)","v":""}]
[null,"Sexe de l'adhérent"]
[]
[null,{"$f":"IF(AND(TODAY()>='Tarification 2023'!B4,TODAY()<='Tarification 2023'!C4),\"\",CONCATENATE(\"Veuillez prendre note que les primes en vigueur dans ce document sont valides seulement pour la période du \",TEXT(+'Tarification 2023'!B4,\"AAAA-MM-JJ\"),\" au \",TEXT(+'Tarification 2023'!C4,\"AAAA-MM-JJ\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Primes (par période de 14 jours)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Employé","Employeur","Total",null,null,null,{"$f":"IF(AND(O9<65,P9<>65),HLOOKUP(K16,'Tarification 2023'!P12:S15,2,FALSE),IF(AND(O9>64,K17=\"Inscrit à la RAMQ\"),HLOOKUP(K16,'Tarification 2023'!P12:S15,3,FALSE),IF(AND(O9=64,P9=65,K17=\"Désengagé de la RAMQ\"),HLOOKUP('Outil de calcul'!K16:L16,'Tarification 2023'!$P$12:$S$15,4,FALSE),IF(AND(O9>64,K17=\"Désengagé de la RAMQ\"),HLOOKUP(K16,'Tarification 2023'!P12:S15,5,FALSE),\"\"))))","v":""}]
["Régime obligatoire de base d'assurance accident maladie"]
[]
[null,null,"Statut de protection",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O8>=65,K17=\"\"),\"\",IF(K16=\"\",\"\",VLOOKUP($O$8,'Tarification 2023'!$B$13:$J$14,VLOOKUP(CONCATENATE(VLOOKUP($K$16,$BJ$118:$BK$121,2,FALSE),VLOOKUP(IF($K$17=\"\",\"Désengagé de la RAMQ\",$K$17),$BJ$154:$BK$155,2,FALSE)),'Tarification 2023'!$L$12:$M$20,2,FALSE),TRUE)))","v":""},{"$f":"IF(N16=\"\",\"\",IF(O9>=65,IF(K16=\"Individuelle\",'Tarification 2023'!C16,IF(K16=\"Monoparentale\",'Tarification 2023'!E16,IF(K16=\"Familiale\",'Tarification 2023'!G16,\"\"))),IF(K16=\"Individuelle\",'Tarification 2023'!C15,IF(K16=\"Monoparentale\",'Tarification 2023'!E15,IF(K16=\"Familiale\",'Tarification 2023'!G15,\"\")))))","v":""},{"$f":"IF(ISERROR(+N16+O16),\"\",+N16+O16)","v":""}]
[null,null,"Si adhérent de plus de 65 ans"]
[null,{"$f":"IF(OR(K16=\"\",K16=\"Exemption\"),\"\",IF(AND(K9=\"\",K16<>\"\"),\"Vous devez saisir la date de naissance dans la section identification de l'adhérent\",IF(AND(O9>=65,K16<>\"\",K17=\"\",O9<>\"\"),\"Vous devez indiquer si la personne adhérente, de 65 ans et plus, est inscrite ou non à la RAMQ.\",\"\")))","v":""}]
["Régime obligatoire de base d'assurance salaire de longue durée"]
[]
[null,null,"Régime de base et régime complémentaire (RCO)",null,null,null,null,null,null,null,"Obligatoire",null,null,null,{"$f":"IF(ROUND(+K8*'Tarification 2023'!D18,2)=0,\"\",ROUND(+K8*'Tarification 2023'!D18,2))","v":""},{"$f":"IF(SUM(N21:O21)=0,\"\",SUM(N21:O21))","v":""}]
[null,{"$f":"IF(K7=\"\",\"Vous devez entrer le salaire dans la section identification de l'adhérent.\",\"\")","v":"Vous devez entrer le salaire dans la section identification de l'adhérent."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(O9=64,P9=65,K17=\"Désengagé de la RAMQ\"),HLOOKUP('Outil de calcul'!K16:L16,'Tarification 2023'!$P$12:$S$15,4,FALSE),\"\")","v":""}]
["Régime obligatoire de base d'assurance vie"]
[]
[]
[null,null,"Assurance vie de l'adhérent",null,null,null,null,null,null,null,"Obligatoire",null,null,{"$f":"IF(ROUND(+K7*'Tarification 2023'!D20/26,2)=0,\"\",ROUND(+K7*'Tarification 2023'!D20/26,2))","v":""},null,{"$f":"IF(SUM(N26:O26)=0,\"\",SUM(N26:O26))","v":""}]
[null,null,"Assurance vie du conjoint et des enfants à charge",null,null,null,null,null,null,null,"Obligatoire",null,null,{"$f":"IF(ROUND(K7*'Tarification 2023'!D21/26,2)=0,\"\",ROUND(K7*'Tarification 2023'!D21/26,2))","v":""},null,{"$f":"IF(SUM(N27:O27)=0,\"\",SUM(N27:O27))","v":""}]
[null,{"$f":"IF(K7=\"\",\"Vous devez entrer le salaire dans la section identification de l'adhérent.\",\"\")","v":"Vous devez entrer le salaire dans la section identification de l'adhérent."}]
[null,null,"Ass.en cas de mutilation acc.de l'adhérent, du conjoint et des enfants à charge",null,null,null,null,null,null,null,"Obligatoire",null,null,{"$f":"IF(ROUND(K7*'Tarification 2023'!D22/26,2)=0,\"\",ROUND(K7*'Tarification 2023'!D22/26,2))","v":""},null,{"$f":"IF(SUM(N29:O29)=0,\"\",SUM(N29:O29))","v":""}]
[null,{"$f":"IF(K7=\"\",\"Vous devez entrer le salaire dans la section identification de l'adhérent.\",\"\")","v":"Vous devez entrer le salaire dans la section identification de l'adhérent."}]
["Régimes facultatifs d'assurance vie additionnelle"]
[null,"Assurance vie additionnelle de l'adhérent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant selon salaire","Limitation","Montant de ptotection"]
[null,null,"Habitudes tabagiques de l'adhérent",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF(ISERROR(ROUND(+L35/1000*R35,2)),0,ROUND(+L35/1000*R35,2))=0,\"\",IF(ISERROR(ROUND(+L35/1000*R35,2)),0,ROUND(+L35/1000*R35,2)))","v":""},null,{"$f":"IF(SUM(N33:O33)=0,\"\",SUM(N33:O33))","v":""},null,{"$f":"VLOOKUP(K32,$BJ$128:$BK$132,2,FALSE)*K7","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K34,$BJ$168:$BK$170,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"MIN(R33:S33)","v":{"$error":"#N/A"}}]
[null,null,"Montant de protection limité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(K10,$BJ$115:$BK$116,2,FALSE),VLOOKUP(K33,$BJ$135:$BK$136,2,FALSE))","v":{"$error":"#N/A"}}]
[null,null,null,"Montant de protection utilisé pour le calcul de la prime",null,null,null,null,null,null,null,{"$f":"IF(OR(K32=\"Non\",K32=\"\",K33=\"\",K34=\"\"),\"\",MIN(R33:S33))","v":""},null,null,null,null,null,{"$f":"VLOOKUP($O$9,'Tarification 2023'!$B$45:$F$56,VLOOKUP(R34,'Tarification 2023'!$J$27:$K$38,2,FALSE),TRUE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(OR(K32=\"Non\",K32=\"\"),\"\",IF(AND(K32<>\"Non\",K33=\"\"),\"Vous devez saisir un statut pour les habitudes tabagiques\",IF(AND(K32<>\"Non\",K34=\"\"),\"Vous devez inscire si le montant de protection est limité\",IF($K$10=\"\",\"Vous devez saisir le sexe de l'adhérent\",IF($K$9=\"\",\"Vous devez saisir la date de naissance de l'adhérent\",IF($K$7=\"\",\"Vous devez saisir le salaire de l'adhérent\",\"\"))))))","v":""}]
[null,"Assurance vie additionnelle du conjoint",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF(ISERROR(ROUND(+K37/1000*R39,2)),0,ROUND(+K37/1000*R39,2))=0,\"\",IF(ISERROR(ROUND(+K37/1000*R39,2)),0,ROUND(+K37/1000*R39,2)))","v":""},null,{"$f":"IF(SUM(N37:O37)=0,\"\",SUM(N37:O37))","v":""}]
[null,null,"Habitudes tabagiques du conjoint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(VLOOKUP(K39,$BJ$115:$BK$116,2,FALSE),VLOOKUP(K38,$BJ$135:$BK$136,2,FALSE))","v":{"$error":"#N/A"}}]
[null,null,"Sexe du conjoint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($O$9,'Tarification 2023'!$B$45:$F$56,VLOOKUP(R38,'Tarification 2023'!$J$45:$K$48,2,FALSE),TRUE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(OR(K37=0,K37=\"\"),\"\",IF(AND(OR(K32=\"Non\",K32=\"\"),K37<>\"\"),\"Cette garantie n'est pas disponible si la vie additionnelle de l'adhérent n'est pas choisie\",IF(AND(K37<>0,K38=\"\"),\"Saisir un statut pour les habitudes tabagiques\",IF(AND(K37<>0,K39=\"\"),\"Saisir le sexe du conjoint\",IF(AND($K$7=\"\",K9=\"\"),\"Vous devez saisir le salaire et la date de naissance de l'adhérent\",\"\")))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sous-total",{"$f":"SUM(N16:N41)","v":0},{"$f":"SUM(O16:O41)","v":0},{"$f":"SUM(P16:P41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Taxe",{"$f":"ROUNDUP(N42*0.09,2)","v":0},{"$f":"ROUNDUP(O42*0.09,2)","v":0},{"$f":"ROUNDUP(P42*0.09,2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total des primes",{"$f":"+N43+N42","v":0},{"$f":"+O43+O42","v":0},{"$f":"+P43+P42","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeurs utilisées dans les listes déroulantes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-01-10"},{"$f":"+BO113","v":44936}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Féminin","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Masculin","M"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Individuelle","I"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Familiale","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monoparentale","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exemption","E"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oui","O"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non","N"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 fois le salaire",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 fois le salaire",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 fois le salaire",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 fois le salaire",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 fois le salaire",5]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fumeur","F",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-fumeur","NF",3]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enfant(s) seulement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conjoint(e) et enfant(s)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+BJ143+10000","v":20000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+BJ144+10000","v":30000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inscrit à la RAMQ","RAMQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Désengagé de la RAMQ","SSQ"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ajouter le 2021-05-03 pour le calcul de la surprime"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Données utilisées pour le calcul de l'âge",null,null,null,null,null,null,"Données utilisées pour le calcul de l'âge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date du renouvellement",{"$f":"+'Tarification 2023'!I3","v":"2023-01-01"},null,null,"Date de naissance",{"$f":"+K9","v":0},null,"Date du jour",{"$f":"TODAY()","v":"2023-01-10"},null,null,"Date de naissance",{"$f":"+K9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mois",{"$f":"VLOOKUP(MONTH($BK$159),$BJ$174:$BK$204,2,FALSE)","v":"01"},null,null,"Mois",{"$f":"VLOOKUP(MONTH($BO$159),$BJ$174:$BK$204,2,FALSE)","v":"01"},null,"Mois",{"$f":"VLOOKUP(MONTH($BR$159),$BJ$174:$BK$204,2,FALSE)","v":"01"},null,null,"Mois",{"$f":"VLOOKUP(MONTH($BO$159),$BJ$174:$BK$204,2,FALSE)","v":"01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour",{"$f":"VLOOKUP(DAY($BK$159),$BJ$174:$BK$204,2,FALSE)","v":"01"},null,null,"Jour",{"$f":"VLOOKUP(DAY($BO$159),$BJ$174:$BK$204,2,FALSE)","v":{"$error":"#N/A"}},null,"Jour",{"$f":"VLOOKUP(DAY($BR$159),$BJ$174:$BK$204,2,FALSE)","v":"10"},null,null,"Jour",{"$f":"VLOOKUP(DAY($BO$159),$BJ$174:$BK$204,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"date(texte)",{"$f":"CONCATENATE(YEAR(BK159),BK160,BK161)","v":"20230101"},null,null,"date(texte)",{"$f":"CONCATENATE(YEAR(BO159),BO160,BO161)","v":{"$error":"#N/A"}},null,"date(texte)",{"$f":"CONCATENATE(YEAR(BR159),BR160,BR161)","v":"20230110"},null,null,"date(texte)",{"$f":"CONCATENATE(YEAR(BV159),BV160,BV161)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+BK162-BO162","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"+BR162-BV162","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Âge de l'adhérent",{"$f":"ROUNDDOWN(+BL164/10000,0)","v":{"$error":"#N/A"}},null,null,null,null,null,"Âge de l'adhérent",{"$f":"ROUNDDOWN(+BS164/10000,0)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limitation au maximum sans preuve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aucune limitation",10000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Limité à \",LEFT(BK169,2),\" \",RIGHT(BK169,3),\" $\")","v":"Limité à 74 700 $"},{"$f":"+'Tarification 2023'!I7","v":74700}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Limité à \",LEFT(BK170,3),\" \",RIGHT(BK170,3),\" $\")","v":"Limité à 179 200 $"},{"$f":"+'Tarification 2023'!I6","v":179200}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jour(num)","Jour(texte)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"31"]

{"sheet":"Tarification 2023","index":1,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":true,"merged":[[24,1,24,5],[42,1,42,5],[2,6,2,7],[19,1,19,2],[23,1,23,5],[21,1,21,2],[20,1,20,2]]}
[]
[null,"Tarification"]
[null,"du","au",null,null,null,"Dernier renouvellement",null,"2023-01-01"]
[null,"2023-01-01","2023-12-31"]
[null,null,null,null,null,null,"Maximum sans preuve pour l'année ( modifier chaque année )"]
[null,null,null,null,null,null,"Entre 40 et 49 ans",null,179200]
[null,null,null,null,null,null,"50 ans et plus",null,74700]
[]
[]
[null,"Tarification YZ"]
[null,"Assurance maladie"]
[null,null,"IRAMQ","ISSQ","MRAMQ","MSSQ","FRAMQ","FSSQ","ERAMQ","ESSQ",null,"IRAMQ",2]
[null,0,50.43,{"$f":"C13","v":50.43},60.5,{"$f":"E13","v":60.5},110.94,{"$f":"G13","v":110.94},0,0,null,"ISSQ",3]
[null,65,25.46,134.63999999999999,35.53,166.55,61.01,301.20999999999998,0,0,null,"MRAMQ",4]
[null,"Part yeur - 0",24.55,24.55,29.45,29.45,54.01,54.01,0,0,null,"MSSQ",5]
[null,"Part yeur - 65",24.55,24.55,29.45,29.45,54.01,54.01,0,0,null,"FRAMQ",6]
[null,null,null,null,null,null,null,null,null,null,null,"FSSQ",7]
[null,"Assurance traitement",null,7.5599999999999999E-3,"( Prendre \"Obligatoire de base d'ass. Salaire de longue durée + Compl. Obligatoire d'ass. Sal.\")",null,null,null,null,null,null,"ERAMQ",8]
[null,null,null,null,null,null,null,null,null,null,null,"ESSQ",9]
[null,"Vie base Adhérent",null,6.3000000000000003E-4]
[null,"Vie base conj. Enfants",null,1.8000000000000001E-4]
[null,"MMA",null,6.0000000000000002E-5]
[]
[null,"Assurance vie additionnelle"]
[null,"Adhérent et conjoint"]
[null,null,"FF","FNF","MF","MNF",null,null,null,"Titre","# de colonne"]
[null,0,2.5999999999999998E-4,1E-4,5.5000000000000003E-4,2.9E-4,null,null,null,"FF",2]
[null,30,2.5999999999999998E-4,1E-4,5.5000000000000003E-4,2.9E-4,null,null,null,"FNF",3]
[null,35,6.4999999999999997E-4,3.4000000000000002E-4,9.1E-4,3.8999999999999999E-4,null,null,null,"MF",4]
[null,40,1.17E-3,5.5000000000000003E-4,1.3600000000000001E-3,6.4999999999999997E-4,null,null,null,"MNF",5]
[null,45,1.72E-3,8.1999999999999998E-4,2.2200000000000002E-3,1.0300000000000001E-3]
[null,50,2.82E-3,1.39E-3,3.7000000000000002E-3,1.9499999999999999E-3]
[null,55,4.1900000000000001E-3,2.5500000000000002E-3,6.11E-3,3.5300000000000002E-3]
[null,60,9.7800000000000005E-3,3.48E-3,1.235E-2,4.5100000000000001E-3]
[null,65,1.277E-2,4.8300000000000001E-3,1.8460000000000001E-2,6.5700000000000003E-3]
[null,70,1.609E-2,7.1199999999999996E-3,2.5870000000000001E-2,1.0410000000000001E-2]
[null,75,1.8870000000000001E-2,9.3100000000000006E-3,3.3480000000000003E-2,1.502E-2]
[null,80,3.9640000000000002E-2,2.6349999999999998E-2,5.3319999999999999E-2,3.703E-2]
[]
[]
[]
[]
[null,"Adhérent et conjoint"]
[null,null,"FF","FNF","MF","MNF",null,null,null,"Titre"]
[null,0,0.01,4.0000000000000001E-3,2.1000000000000001E-2,1.0999999999999999E-2,null,null,null,"FF",2]
[null,30,0.01,4.0000000000000001E-3,2.1000000000000001E-2,1.0999999999999999E-2,null,null,null,"FNF",3]
[null,35,2.5000000000000001E-2,1.2999999999999999E-2,3.5000000000000003E-2,1.4999999999999999E-2,null,null,null,"MF",4]
[null,40,4.4999999999999998E-2,2.1000000000000001E-2,5.1999999999999998E-2,2.5000000000000001E-2,null,null,null,"MNF",5]
[null,45,6.6000000000000003E-2,3.2000000000000001E-2,8.5000000000000006E-2,0.04]
[null,50,0.108,5.2999999999999999E-2,0.14199999999999999,7.4999999999999997E-2]
[null,55,0.161,9.8000000000000004E-2,0.23400000000000001,0.13500000000000001]
[null,60,0.375,0.13300000000000001,0.47299999999999998,0.17299999999999999]
[null,65,0.48899999999999999,0.185,0.70699999999999996,0.252]
[null,70,0.61699999999999999,0.27300000000000002,0.99099999999999999,0.39900000000000002]
[null,75,0.72299999999999998,0.35699999999999998,1.2829999999999999,0.57599999999999996]
[null,80,1.5189999999999999,1.01,2.044,1.419]