{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sommaire","Janvier","Février","Mars","Avril","Mai"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sommaire","index":0,"n_rows":10,"n_cols":56,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number",null,"Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
[]
[]
[]
["Sommaire annuel","2019-01-01","au/to","2019-12-31"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]

{"sheet":"Janvier","index":1,"n_rows":21,"n_cols":56,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number","Date de génération du relevé de primes/Date premium statement generated","Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
["Ce fichier n'est pas une facture, il présente seulement les données de facturation. Cependant la facture papier et/ou PDF prévaut sur le fichier Excel.  Veuillez utiliser le bordereau de la facture pour fin de paiement."]
["This file is not an invoice; it merely provides invoicing data. The paper and/or PDF invoice takes precedence over the Excel file.  Please use the invoice stub for payment purposes."]
[]
["Renseignements détaillés pour la période du/Detailed information for the period from","2019-01-01","au/to","2019-01-31"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]
[null,null,null,null,"0024342876","AAA","aaa",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,365.63,32.92,"QC",0,null,null,398.55]
[null,null,null,null,"0024343148","BBB","bbb",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,365.63,32.92,"QC",0,null,null,398.55]
[null,null,null,null,"0024342835","CCC","ccc",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,82000,null,14.35,null,null,50000,null,5.95,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,32.69,2.95,"QC",0,null,null,35.64]
[null,null,null,null,"0024343205","DDD","ddd",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,365.63,32.92,"QC",0,null,null,398.55]
[null,null,null,null,"0024343668","EEE","eee",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,365.63,32.92,"QC",0,null,null,398.55]
[null,null,null,null,"0024342850","FFF","fff",null,"A",null,null,null,"I",98.68,null,null,null,"I",26.1,null,null,28000,"I",4.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28000,"I",0.84,null,null,null,null,null,130.55000000000001,11.75,"QC",0,null,null,142.30000000000001]
[null,null,null,null,"0024343510","GGG","ggg",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.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,353.24,31.8,"QC",0,null,null,385.04]
[null,null,null,null,"0024342926","HHH","hhh",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,164000,"F",28.86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,164000,"F",4.92,null,null,null,null,null,388.08,34.94,"QC",0,null,null,423.02]
[null,null,null,null,"0024343528","III","iii",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,12.39,1.1200000000000001,"QC",0,null,null,13.51]
[null,null,null,null,"0024343585","JJJ","jjj",null,"A",null,null,null,"F",282.07,null,null,null,"F",71.17,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,365.63,32.92,"QC",0,null,null,398.55]
[null,null,null,null,"0024343379","KKK","kkk",null,"A",null,null,null,null,null,null,null,null,"F",71.17,null,null,27500,"F",4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,27500,"F",0.83,null,null,null,null,null,77.900000000000006,7.02,"QC",0,null,null,84.92]

{"sheet":"Février","index":2,"n_rows":21,"n_cols":56,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number","Date de génération du relevé de primes/Date premium statement generated","Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
["Ce fichier n'est pas une facture, il présente seulement les données de facturation. Cependant la facture papier et/ou PDF prévaut sur le fichier Excel.  Veuillez utiliser le bordereau de la facture pour fin de paiement."]
["This file is not an invoice; it merely provides invoicing data. The paper and/or PDF invoice takes precedence over the Excel file.  Please use the invoice stub for payment purposes."]
[]
["Renseignements détaillés pour la période du/Detailed information for the period from","2019-02-01","au/to","2019-02-28"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]
["$",null,null,null,"0024342876","AAA","aaa",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024343148","BBB","bbb",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342835","CCC","ccc",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,82000,null,14.35,null,null,50000,null,5.95,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,32.69,2.95,"QC",0,null,null,35.64]
["$",null,null,null,"0024343205","DDD","ddd",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024343668","EEE","eee",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024342850","FFF","fff",null,"A",null,null,null,"I",99.52,null,null,null,"I",27.3,null,null,28000,"I",4.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28000,"I",0.84,null,null,null,null,null,132.59,11.94,"QC",0,null,null,144.53]
["$",null,null,null,"0024343510","GGG","ggg",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358.91,32.299999999999997,"QC",0,null,null,391.21]
["$",null,null,null,"0024342926","HHH","hhh",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,164000,"F",28.86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,164000,"F",4.92,null,null,null,null,null,393.75,35.44,"QC",0,null,null,429.19]
[null,null,null,null,"0024343528","III","iii",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,12.39,1.1200000000000001,"QC",0,null,null,13.51]
["$",null,null,null,"0024343585","JJJ","jjj",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024343379","KKK","kkk","2","A","F",282.07,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,27500,"F",4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,27500,"F",0.83,null,null,null,null,null,365.64,32.909999999999997,"QC",282.07,25.39,"QC",706.01]

{"sheet":"Mars","index":3,"n_rows":21,"n_cols":56,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number","Date de génération du relevé de primes/Date premium statement generated","Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
["Ce fichier n'est pas une facture, il présente seulement les données de facturation. Cependant la facture papier et/ou PDF prévaut sur le fichier Excel.  Veuillez utiliser le bordereau de la facture pour fin de paiement."]
["This file is not an invoice; it merely provides invoicing data. The paper and/or PDF invoice takes precedence over the Excel file.  Please use the invoice stub for payment purposes."]
[]
["Renseignements détaillés pour la période du/Detailed information for the period from","2019-03-01","au/to","2019-03-31"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]
[null,null,null,null,"0024342876","AAA","aaa",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343148","BBB","bbb",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342835","CCC","ccc",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,82000,null,14.35,null,null,50000,null,5.95,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,32.69,2.95,"QC",0,null,null,35.64]
[null,null,null,null,"0024343205","DDD","ddd",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343668","EEE","eee",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342850","FFF","fff",null,"A",null,null,null,"I",99.52,null,null,null,"I",27.3,null,null,28000,"I",4.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28000,"I",0.84,null,null,null,null,null,132.59,11.94,"QC",0,null,null,144.53]
[null,null,null,null,"0024343510","GGG","ggg",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358.91,32.299999999999997,"QC",0,null,null,391.21]
[null,null,null,null,"0024342926","HHH","hhh",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,164000,"F",28.86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,164000,"F",4.92,null,null,null,null,null,393.75,35.44,"QC",0,null,null,429.19]
[null,null,null,null,"0024343528","III","iii",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,12.39,1.1200000000000001,"QC",0,null,null,13.51]
[null,null,null,null,"0024343585","JJJ","jjj",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024343379","KKK","kkk",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,27500,"F",4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,27500,"F",0.83,null,null,null,null,null,365.64,32.909999999999997,"QC",0,null,null,398.55]

{"sheet":"Avril","index":4,"n_rows":21,"n_cols":56,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number","Date de génération du relevé de primes/Date premium statement generated","Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
["Ce fichier n'est pas une facture, il présente seulement les données de facturation. Cependant la facture papier et/ou PDF prévaut sur le fichier Excel.  Veuillez utiliser le bordereau de la facture pour fin de paiement."]
["This file is not an invoice; it merely provides invoicing data. The paper and/or PDF invoice takes precedence over the Excel file.  Please use the invoice stub for payment purposes."]
[]
["Renseignements détaillés pour la période du/Detailed information for the period from","2019-04-01","au/to","2019-04-30"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]
[null,null,null,null,"0024342876","AAA","aaa",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343148","BBB","bbb",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
["$",null,null,null,"0024342835","CCC","ccc",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,82000,null,25.26,null,null,50000,null,5.95,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,43.6,3.93,"QC",0,null,null,47.53]
[null,null,null,null,"0024343205","DDD","ddd",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343668","EEE","eee",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342850","FFF","fff",null,"A",null,null,null,"I",99.52,null,null,null,"I",27.3,null,null,28000,"I",4.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28000,"I",0.84,null,null,null,null,null,132.59,11.94,"QC",0,null,null,144.53]
[null,null,null,null,"0024343510","GGG","ggg",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358.91,32.299999999999997,"QC",0,null,null,391.21]
[null,null,null,null,"0024342926","HHH","hhh",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,164000,"F",28.86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,164000,"F",4.92,null,null,null,null,null,393.75,35.44,"QC",0,null,null,429.19]
[null,null,null,null,"0024343528","III","iii",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,12.39,1.1200000000000001,"QC",0,null,null,13.51]
[null,null,null,null,"0024343585","JJJ","jjj",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343379","KKK","kkk",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,27500,"F",4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,27500,"F",0.83,null,null,null,null,null,365.64,32.909999999999997,"QC",0,null,null,398.55]

{"sheet":"Mai","index":5,"n_rows":21,"n_cols":56,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Nom du contact/Contact name","Numéro du groupe/Group number","Numéro d'employeur/Employer number","Nom employeur/Employer name","Numéro de facture/Invoice number","Numéro du compte de facturation/Invoice account number","Date de génération du relevé de primes/Date premium statement generated","Adresse/Address","Adresse2/Address2","Code postal/Postal code"]
["Miss Untel",987987,"0001","Membres du conseil (109601-0006)","R-0000214057","L321321321",null,"123456 Blabla Rd","St-Glinglin QC","G1Q 1Q9"]
[]
["Ce fichier n'est pas une facture, il présente seulement les données de facturation. Cependant la facture papier et/ou PDF prévaut sur le fichier Excel.  Veuillez utiliser le bordereau de la facture pour fin de paiement."]
["This file is not an invoice; it merely provides invoicing data. The paper and/or PDF invoice takes precedence over the Excel file.  Please use the invoice stub for payment purposes."]
[]
["Renseignements détaillés pour la période du/Detailed information for the period from","2019-05-01","au/to","2019-05-31"]
[null,null,null,null,null,null,null,null,null,"MAL",null,null,null,null,"DENT",null,null,null,null,"VIBA",null,null,null,null,"VIFA",null,null,null,null,"VIFC",null,null,null,null,"VIBPAC",null,null,null,null,"MMABA",null,null,null,null,"ILD"]
["($ si la prime de l'adhérent a été modifiée)","Catégorie 1","Catégorie 2","Catégorie 3","Numero adherent","Prénom","Nom","Codes d'ajustement","Statut","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Type de protection ajustement","Ajustement","Montant d'assurance","Type de protection","Prime","Montant total des primes","Montant total des taxes des primes","Province de taxation des primes","Montant total des ajustements","Montant total des taxes des ajustements","Province de taxation des ajustements","Montant total"]
["($ if this participant's premium was modified)","Category 1","Category 2","Category 3","Participant number","First name","Last name","Adjustment codes","Status","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Type of coverage adjustment","Adjustment","Insurance amount","Type of coverage","Premium","Total premium amount","Total premium tax amount","Premium tax province","Total adjustments amount","Total tax adjustment amount","Tax adjustment province","Total amount"]
[null,null,null,null,"0024342876","AAA","aaa",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343148","BBB","bbb",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342835","CCC","ccc",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,82000,null,25.26,null,null,50000,null,5.95,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,43.6,3.93,"QC",0,null,null,47.53]
[null,null,null,null,"0024343205","DDD","ddd",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343668","EEE","eee",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024342850","FFF","fff",null,"A",null,null,null,"I",99.52,null,null,null,"I",27.3,null,null,28000,"I",4.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28000,"I",0.84,null,null,null,null,null,132.59,11.94,"QC",0,null,null,144.53]
[null,null,null,null,"0024343510","GGG","ggg",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,358.91,32.299999999999997,"QC",0,null,null,391.21]
[null,null,null,null,"0024342926","HHH","hhh",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,164000,"F",28.86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,164000,"F",4.92,null,null,null,null,null,393.75,35.44,"QC",0,null,null,429.19]
[null,null,null,null,"0024343528","III","iii",null,"A",null,null,null,null,null,null,null,null,null,null,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,12.39,1.1200000000000001,"QC",0,null,null,13.51]
[null,null,null,null,"0024343585","JJJ","jjj",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,55000,"F",9.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,55000,"F",1.65,null,null,null,null,null,371.3,33.42,"QC",0,null,null,404.72]
[null,null,null,null,"0024343379","KKK","kkk",null,"A",null,null,null,"F",284.47000000000003,null,null,null,"F",74.44,null,null,27500,"F",4.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.06,null,null,27500,"F",0.83,null,null,null,null,null,365.64,32.909999999999997,"QC",0,null,null,398.55]