{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Etat préparatoire","Liste des familles","Etat TP","Constantes","Facture 1","Facture 2","Facture 3","Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":16,"comments":0,"pivot_tables":1},"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":"Menu","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Choix de la période"]
[null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Formulaire"]

{"sheet":"Etat préparatoire","index":1,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["N° facture","Période","Titre","Nom-prénom","Nom","Prénom","Adresse","CP","Ville","Nom  enfant","Prénom enfant","Période","Lundi","Mardi","Jeudi","Nbre jours","Prix","Montant","Montant en lettre","Total","Nbe enfant"]
[1,1,"M.",{"$f":"CONCATENATE(E2,\" \",F2)","v":"Aubin Raymond"},"Aubin","Raymond",{"$f":"VLOOKUP(D2,Etat_famille,4)","v":"11 rue des Aubépines"},{"$f":"VLOOKUP(D2,Etat_famille,5)","v":80440},{"$f":"VLOOKUP($D2,Etat_famille,6)","v":"Glisy"},{"$f":"IF(E2=\"\",\"\",E2)","v":"Aubin"},"Timothée",{"$f":"IF(B2=\"\",\"\",VLOOKUP(B2,tableau_des_périodes,2))","v":"du 07 septembre au 15 octobre 2015"},4,5,5,14,{"$f":"IF(E2=\"\",\"\",prix)","v":1},{"$f":"IF(P2>0,P2*Q2,\"\")","v":14},{"$f":"IF(T2>0,chiffrelettre(T2),\"\")","v":"quatorze Euros "},{"$f":"IF(U2=1,R2,SUMIFS(R:R,A:A,A2,D:D,D2))","v":14},{"$f":"VLOOKUP($D2,Etat_famille,7)","v":1}]
[2,1,"M.","Belkacem Michel","Belkacem","Michel","13 rue des vignes",80440,{"$f":"VLOOKUP(D3,Etat_famille,6)","v":"Glisy"},"Belkacem","Inès","du 07 septembre au 15 octobre 2015",7,7,0,{"$f":"IF(SUM(M3:O3)=0,\"\",SUM(M3:O3))","v":14},{"$f":"prix","v":1},14,{"$f":"IF(T3>0,chiffrelettre(T3),\"\")","v":"quatorze Euros "},14,1]
[3,1,"M.","Bouillez André","Bouillez","André","28 rue du Vert-Bout",80440,"Glisy","Bouillez","Théotim","du 07 septembre au 15 octobre 2015",7,7,7,{"$f":"IF(SUM(M4:O4)=0,\"\",SUM(M4:O4))","v":21},1,21,{"$f":"IF(T4>0,chiffrelettre(T4),\"\")","v":"vingt et un Euros "},21,1]
[4,1,"M.","Couturier Blaise","Couturier","Blaise","4 rue Neuve",80440,"Glisy","Couturier","Telma","du 07 septembre au 15 octobre 2015",7,7,7,{"$f":"IF(SUM(M5:O5)=0,\"\",SUM(M5:O5))","v":21},1,21,{"$f":"IF(T5>0,chiffrelettre(T5),\"\")","v":"vingt et un Euros "},21,1]
[14,1,"M.",{"$f":"CONCATENATE(E6,\" \",F6)","v":"Delcroix Claude"},"Delcroix","Claude",{"$f":"VLOOKUP(D6,Etat_famille,4)","v":"5 rue des Sarments"},{"$f":"VLOOKUP(D6,Etat_famille,5)","v":80440},{"$f":"VLOOKUP(D6,Etat_famille,6)","v":"Glisy"},"Delcroix","Sarah",{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,tableau_des_périodes,2))","v":"du 07 septembre au 15 octobre 2015"},3,3,3,{"$f":"IF(SUM(M6:O6)=0,\"\",SUM(M6:O6))","v":9},{"$f":"IF(E6=\"\",\"\",prix)","v":1},{"$f":"IF(E6=\"\",\"\",P6*Q6)","v":9},{"$f":"IF(T6>0,chiffrelettre(T6),\"\")","v":"cent deux Euros "},102,3]
[14,1,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy","Delcroix","Arthur","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T7>0,chiffrelettre(T7),\"\")","v":"cent deux Euros "},102,3]
[14,1,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy","Delcroix","Elsa","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T8>0,chiffrelettre(T8),\"\")","v":"cent deux Euros "},102,3]
[5,1,"M.","Fouré Brice","Fouré","Brice","7 rue des Vieux Ceps",80440,"Glisy",{"$f":"+E9","v":"Fouré"},"Angèle","du 07 septembre au 15 octobre 2015",6,0,0,{"$f":"SUM(M9:O9)","v":6},1,6,{"$f":"IF(T9>0,chiffrelettre(T9),\"\")","v":"six Euros "},6,1]
[6,1,"M.","Gérard Odette","Gérard","Odette","4 rue des Moissons",80440,"Blangy-Tronville",{"$f":"+E10","v":"Gérard"},"Hubert","du 07 septembre au 15 octobre 2015",7,7,7,{"$f":"SUM(M10:O10)","v":21},1,21,{"$f":"IF(T10>0,chiffrelettre(T10),\"\")","v":"vingt et un Euros "},21,1]
[7,1,"M.","Wuyts Gontran","Wuyts","Gontran","28 rue des Trèmières",80440,"Glisy",{"$f":"+E11","v":"Wuyts"},"Basile","du 07 septembre au 15 octobre 2015",0,7,0,{"$f":"SUM(M11:O11)","v":7},1,7,{"$f":"IF(T11>0,chiffrelettre(T11),\"\")","v":"sept Euros "},7,1]
[8,1,"M.","Dubois Charles","Dubois","Charles","17 rue du Vert Bout",80440,"Glisy",{"$f":"IF(E12=\"\",\"\",E12)","v":"Dubois"},"Chloé","du 07 septembre au 15 octobre 2015",7,7,7,{"$f":"IF(SUM(M12:O12)=0,\"\",SUM(M12:O12))","v":21},{"$f":"IF(E12=\"\",\"\",prix)","v":1},{"$f":"IF(E12=\"\",\"\",P12*Q12)","v":21},{"$f":"IF(T12>0,chiffrelettre(T12),\"\")","v":"quarante deux Euros "},42,2]
[8,1,"M.","Dubois Charles","Dubois","Charles","17 rue du Vert Bout",80440,"Glisy","Dubois","Arthur","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T13>0,chiffrelettre(T13),\"\")","v":"quarante deux Euros "},42,2]
[9,1,"M.","Dupont Vincent","Dupont","Vincent","8 rue Francis Desavoix",80440,"Glisy","Dupont","Romane","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T14>0,chiffrelettre(T14),\"\")","v":"trente cinq Euros "},35,2]
[9,1,"M.","Dupont Vincent","Dupont","Vincent","8 rue Francis Desavoix",80440,"Glisy","Dupont","Ambre","du 07 septembre au 15 octobre 2015",7,0,7,14,1,14,{"$f":"IF(T15>0,chiffrelettre(T15),\"\")","v":"trente cinq Euros "},35,2]
[10,1,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy","Klavinski","Noé","du 07 septembre au 15 octobre 2015",7,0,7,14,1,14,{"$f":"IF(T16>0,chiffrelettre(T16),\"\")","v":"quatorze Euros "},14,1]
[10,1,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy","Klavinski","Lalie","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T17>0,chiffrelettre(T17),\"\")","v":"vingt et un Euros "},21,1]
[11,1,"M.","Messe Armel","Messe","Armel","12 rue de la République",80440,"Glisy","Messe","Léo","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,{"$f":"IF(T18>0,chiffrelettre(T18),\"\")","v":"vingt et un Euros "},21,1]
[11,2,"M.","Messe Armel","Messe","Armel","12 rue de la République",80440,"Glisy","Messe","Ugo","du 2 novembre au 17 décembre 2015",7,7,7,21,1,21,{"$f":"IF(T19>0,chiffrelettre(T19),\"\")","v":"vingt et un Euros "},21,1]
[12,2,"M.","Parisseaux Roger","Parisseaux","Roger","rue de la petite Vallée",80440,"Glisy","Parisseaux","Valentin","du 2 novembre au 17 décembre 2015",7,7,7,21,1,21,{"$f":"IF(T20>0,chiffrelettre(T20),\"\")","v":"quarante deux Euros "},42,2]
[12,2,"M.","Parisseaux Roger","Parisseaux","Roger","rue de la petite Vallée",80440,"Glisy","Parisseaux","Théo","du 2 novembre au 17 décembre 2015",7,7,7,21,1,21,{"$f":"IF(T21>0,chiffrelettre(T21),\"\")","v":"quarante deux Euros "},42,2]
[13,2,"M.","Diruit Emile","Diruit","Emile","4 rue des Cépages",80440,"Glisy","Ragout","Lucile","du 2 novembre au 17 décembre 2015",0,7,7,14,1,14,{"$f":"IF(T22>0,chiffrelettre(T22),\"\")","v":"vingt huit Euros "},28,2]
[13,2,"M.","Diruit Emile","Diruit","Emile","4 rue des Cépages",80440,"Glisy","Ragout","Elise","du 2 novembre au 17 décembre 2015",0,7,7,14,1,14,{"$f":"IF(T23>0,chiffrelettre(T23),\"\")","v":"vingt huit Euros "},28,2]
[14,2,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E24=\"\",\"\",E24)","v":"Delcroix"},"Sarah","du 2 novembre au 17 décembre 2015",3,3,3,9,1,9,{"$f":"IF(T24>0,chiffrelettre(T24),\"\")","v":"cent deux Euros "},102,3]
[14,2,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E25=\"\",\"\",E25)","v":"Delcroix"},"Arthur","du 2 novembre au 17 décembre 2015",7,7,7,21,1,21,{"$f":"IF(T25>0,chiffrelettre(T25),\"\")","v":"cent deux Euros "},102,3]
[14,2,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E26=\"\",\"\",E26)","v":"Delcroix"},"Elsa","du 2 novembre au 17 décembre 2015",7,7,7,21,1,21,{"$f":"IF(T26>0,chiffrelettre(T26),\"\")","v":"cent deux Euros "},102,3]
[15,2,"M.","Montigny Denis","Montigny","Denis","219 rue Saint Fuscien appart.11",80000,"Amiens",{"$f":"+E27","v":"Montigny"},"Lisa","du 2 novembre au 17 décembre 2015",7,7,7,{"$f":"SUM(M27:O27)","v":21},1,{"$f":"IF(P27>0,P27*Q27,\"\")","v":21},{"$f":"IF(T27>0,chiffrelettre(T27),\"\")","v":"vingt et un Euros "},21,1]
[16,2,"Mme","Rousselle Valérie","Rousselle","Valérie","22 rue des Trémières",80440,"Glisy",{"$f":"+E28","v":"Rousselle"},"Etienne","du 2 novembre au 17 décembre 2015",7,0,7,{"$f":"SUM(M28:O28)","v":14},1,{"$f":"IF(P28>0,P28*Q28,\"\")","v":14},{"$f":"IF(T28>0,chiffrelettre(T28),\"\")","v":"quatorze Euros "},14,1]
[17,2,"M.","Dizambourg Alban","Dizambourg","Alban","9 rue d'en Haut",80440,"Glisy",{"$f":"IF(E29=\"\",\"\",E29)","v":"Dizambourg"},"Danaé","du 2 novembre au 17 décembre 2015",7,7,7,{"$f":"IF(SUM(M29:O29)=0,\"\",SUM(M29:O29))","v":21},1,{"$f":"IF(E29=\"\",\"\",P29*Q29)","v":21},{"$f":"IF(T29>0,chiffrelettre(T29),\"\")","v":"quarante deux Euros "},42,2]
[17,2,"M.","Dizambourg Alban","Dizambourg","Alban","9 rue d'en Haut",80440,"Glisy",{"$f":"IF(E30=\"\",\"\",E30)","v":"Dizambourg"},"Noé","du 2 novembre au 17 décembre 2015",7,7,7,{"$f":"IF(SUM(M30:O30)=0,\"\",SUM(M30:O30))","v":21},1,21,{"$f":"IF(T30>0,chiffrelettre(T30),\"\")","v":"quarante deux Euros "},42,2]
[18,2,"M.","Aubin Raymond","Aubin","Raymond","11 rue des Aubépines",80440,"Glisy",{"$f":"IF(E31=\"\",\"\",E31)","v":"Aubin"},"Timothée","du 2 novembre au 17 décembre 2015",6,7,7,20,{"$f":"prix","v":1},20,{"$f":"IF(T31>0,chiffrelettre(T31),\"\")","v":"vingt Euros "},20,1]
[19,2,"Mme","Gérard Odette","Gérard","Odette","4 rue des Moissons",80440,"Blangy-Tronville",{"$f":"+E32","v":"Gérard"},"Hubert","du 2 novembre au 17 décembre 2015",6,7,7,{"$f":"SUM(M32:O32)","v":20},{"$f":"prix","v":1},20,{"$f":"IF(T32>0,chiffrelettre(T32),\"\")","v":"vingt Euros "},20,1]
[20,2,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy",{"$f":"IF(E33=\"\",\"\",E33)","v":"Klavinski"},"Noé","du 2 novembre au 17 décembre 2015",6,0,7,{"$f":"IF(SUM(M33:O33)=0,\"\",SUM(M33:O33))","v":13},{"$f":"IF(E33=\"\",\"\",prix)","v":1},13,{"$f":"IF(T33>0,chiffrelettre(T33),\"\")","v":"treize Euros "},13,1]
[20,2,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy",{"$f":"IF(E34=\"\",\"\",E34)","v":"Klavinski"},"Lalie","du 2 novembre au 17 décembre 2015",6,7,7,{"$f":"IF(SUM(M34:O34)=0,\"\",SUM(M34:O34))","v":20},{"$f":"IF(E34=\"\",\"\",prix)","v":1},20,{"$f":"IF(T34>0,chiffrelettre(T34),\"\")","v":"vingt Euros "},20,1]
[21,3,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E35=\"\",\"\",E35)","v":"Delcroix"},"Sarah","du 04 janvier au 04 février 2016",6,7,7,{"$f":"IF(SUM(M35:O35)=0,\"\",SUM(M35:O35))","v":20},{"$f":"IF(E35=\"\",\"\",prix)","v":1},20,{"$f":"IF(T35>0,chiffrelettre(T35),\"\")","v":"soixante Euros "},60,3]
[21,3,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E36=\"\",\"\",E36)","v":"Delcroix"},"Arthur","du 04 janvier au 04 février 2016",6,7,7,{"$f":"IF(SUM(M36:O36)=0,\"\",SUM(M36:O36))","v":20},{"$f":"IF(E36=\"\",\"\",prix)","v":1},20,{"$f":"IF(T36>0,chiffrelettre(T36),\"\")","v":"soixante Euros "},60,3]
[21,3,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",{"$f":"IF(E37=\"\",\"\",E37)","v":"Delcroix"},"Elsa","du 04 janvier au 04 février 2016",6,7,7,{"$f":"IF(SUM(M37:O37)=0,\"\",SUM(M37:O37))","v":20},{"$f":"IF(E37=\"\",\"\",prix)","v":1},20,{"$f":"IF(T37>0,chiffrelettre(T37),\"\")","v":"soixante Euros "},60,3]

{"sheet":"Liste des familles","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Titre","Nom Prénom","Nom","Prénom","Adresse","CP","Ville","Nbre Enfants"]
["M.",{"$f":"CONCATENATE(C2,\" \",D2)","v":"Aubin Raymond"},"Aubin","Raymond","11 rue des Aubépines",80440,"Glisy",1]
["M.","Belkacem Michel","Belkacem","Michel","13 rue des vignes",80440,"Glisy",1]
["M.","Bouillez André","Bouillez","André","28 rue du Vert-Bout",80440,"Glisy",1]
["M.","Couturier Blaise","Couturier","Blaise","4 rue Neuve",80440,"Glisy",1]
["M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy",3]
["M.","Diruit Emile","Diruit","Emile","4 rue des Cépages",80440,"Glisy",2]
["M.","Dizambourg Alban","Dizambourg","Alban","9 rue d'en Haut",80440,"Glisy",2]
["M.","Dubois Charles","Dubois","Charles","17 rue du Vert Bout",80440,"Glisy",2]
["M.","Dupont Vincent","Dupont","Vincent","8 rue Francis Desavoix",80440,"Glisy",2]
["M.","Fouré Brice","Fouré","Brice","7 rue des Vieux Ceps",80440,"Glisy",1]
["M.","Gérard Daniel","Gérard","Daniel","3 rue du stade",80440,"Glisy",1]
["Mme","Gérard Odette","Gérard","Odette","4 rue des Moissons",80440,"Blangy-Tronville",1]
["Mme","Jarry PierrE","Jarry","PierrE","lA GARE",80000,"Glasy","3"]
["M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy",1]
["M.","Messe Armel","Messe","Armel","12 rue de la République",80440,"Glisy",1]
["M.","Montigny Denis","Montigny","Denis","219 rue Saint Fuscien appart.11",80000,"Amiens",1]
["M.","Parisseaux Roger","Parisseaux","Roger","rue de la petite Vallée",80440,"Glisy",2]
["Mme","Rousselle Valérie","Rousselle","Valérie","22 rue des Trémières",80440,"Glisy",1]
["M.","Wuyts Gontran","Wuyts","Gontran","28 rue des Trèmières",80440,"Glisy",1]

{"sheet":"Etat TP","index":3,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Période","(Plusieurs éléments)"]
[]
[null,null,null,null,null,null,"Données"]
["N° facture","Nom","Titre","Adresse","Total dû","Prénom enfant","Lundi :","Mardi :","Jeudi :","Nbre jours :","Prix unitaire","Montant dû"]
[1,"Aubin","M.","11 rue des Aubépines",14,"Timothée",4,5,5,14,1,14]
[2,"Belkacem","M.","13 rue des vignes",14,"Inès",7,7,0,14,1,14]
[3,"Bouillez","M.","28 rue du Vert-Bout",21,"Théotim",7,7,7,21,1,21]
[4,"Couturier","M.","4 rue Neuve",21,"Telma",7,7,7,21,1,21]
[5,"Fouré","M.","7 rue des Vieux Ceps",6,"Angèle",6,0,0,6,1,6]
[6,"Gérard","M.","4 rue des Moissons",21,"Hubert",7,7,7,21,1,21]
[7,"Wuyts","M.","28 rue des Trèmières",7,"Basile",0,7,0,7,1,7]
[8,"Dubois","M.","17 rue du Vert Bout",42,"Arthur",7,7,7,21,1,21]
[null,null,null,null,null,"Chloé",7,7,7,21,1,21]
[9,"Dupont","M.","8 rue Francis Desavoix",35,"Ambre",7,0,7,14,1,14]
[null,null,null,null,null,"Romane",7,7,7,21,1,21]
[10,"Klavinski","M.","4 rue des Alcoves",35,"Lalie",7,7,7,21,1,21]
[null,null,null,null,null,"Noé",7,0,7,14,1,14]
[11,"Messe","M.","12 rue de la République",42,"Léo",7,7,7,21,1,21]
[null,null,null,null,null,"Ugo",7,7,7,21,1,21]
[12,"Parisseaux","M.","rue de la petite Vallée",42,"Théo",7,7,7,21,1,21]
[null,null,null,null,null,"Valentin",7,7,7,21,1,21]
[13,"Diruit","M.","4 rue des Cépages",28,"Elise",0,7,7,14,1,14]
[null,null,null,null,null,"Lucile",0,7,7,14,1,14]
[14,"Delcroix","M.","5 rue des Sarments",51,"Arthur",7,7,7,21,1,21]
[null,null,null,null,null,"Elsa",7,7,7,21,1,21]
[null,null,null,null,null,"Sarah",3,3,3,9,1,9]
[15,"Montigny","M.","219 rue Saint Fuscien appart.11",21,"Lisa",7,7,7,21,1,21]
[16,"Rousselle","Mme","22 rue des Trémières",14,"Etienne",7,0,7,14,1,14]
[17,"Dizambourg","M.","9 rue d'en Haut",42,"Danaé",7,7,7,21,1,21]
[null,null,null,null,null,"Noé",7,7,7,21,1,21]
[18,"Aubin","M.","11 rue des Aubépines",20,"Timothée",6,7,7,20,1,20]
[19,"Gérard","Mme","4 rue des Moissons",20,"Hubert",6,7,7,20,1,20]
[20,"Klavinski","M.","4 rue des Alcoves",33,"Lalie",6,7,7,20,1,20]
[null,null,null,null,null,"Noé",6,0,7,13,1,13]
[21,"Delcroix","M.","5 rue des Sarments",60,"Arthur",6,7,7,20,1,20]
[null,null,null,null,null,"Elsa",6,7,7,20,1,20]
[null,null,null,null,null,"Sarah",6,7,7,20,1,20]
["Total général",null,null,null,null,null,195,190,204,589,33,589]

{"sheet":"Constantes","index":4,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["N°","Périodes",null,"N° Facture",null,"Nom Prénom",null,"Nom",null,"Prénom",null,"Prénom enfant"]
[1,"du 07 septembre au 15 octobre 2015",null,{"$f":"MAX('Etat préparatoire'!A:A)+1","v":22},null,"Aubin Raymond",null,"Aubin",null,"Alban",null,"Ambre"]
[2,"du 2 novembre au 17 décembre 2015",null,null,null,"Belkacem Michel",null,"Belkacem",null,"André",null,"Angèle"]
[3,"du 04 janvier au 04 février 2016",null,"Titre",null,"Bouillez André",null,"Bouillez",null,"Armel",null,"Arthur"]
[4,"du 22 février au 31 mars 2016",null,"M.",null,"Couturier Blaise",null,"Couturier",null,"Blaise",null,"Basile"]
[5,"du 18 avril au 30 juin 2016",null,"Mme",null,"Delcroix Claude",null,"Delcroix",null,"Boris",null,"Chloé"]
[null,null,null,null,null,"Diruit Emile",null,"Diruit",null,"Brice",null,"Danaé"]
[null,null,null,"prix",null,"Dizambourg Alban",null,"Dizambourg",null,"Charles",null,"Elise"]
[null,null,null,1,null,"Dubois Charles",null,"Dubois",null,"Claude",null,"Elsa"]
[null,null,null,null,null,"Dupont Vincent",null,"Dupont",null,"Daniel",null,"Etienne"]
[null,null,null,"Présence",null,"Fouré Brice",null,"Fouré",null,"Denis",null,"Hubert"]
[null,null,null,1,null,"Gérard Daniel",null,"Gérard",null,"Emile",null,"Inès"]
[null,null,null,2,null,"Gérard Odette",null,"Jarry",null,"Gontran",null,"Lalie"]
[null,null,null,3,null,"Jarry PierrE",null,"Klavinski",null,"Michel",null,"Léo"]
[null,null,null,4,null,"Klavinski Boris",null,"Messe",null,"Odette",null,"Lisa"]
[null,null,null,5,null,"Messe Armel",null,"Montigny",null,"PierrE",null,"Lucile"]
[null,null,null,6,null,"Montigny Denis",null,"Parisseaux",null,"Raymond",null,"Noé"]
[null,null,null,7,null,"Parisseaux Roger",null,"Rousselle",null,"Roger",null,"Romane"]
[null,null,null,null,null,"Rousselle Valérie",null,"Wuyts",null,"Valérie",null,"Sarah"]
[null,null,null,null,null,"Wuyts Gontran",null,null,null,"Vincent",null,"Telma"]
[null,null,null,null,null,null,null,null,null,null,null,"Théo"]
[null,null,null,null,null,null,null,null,null,null,null,"Théotim"]
[null,null,null,null,null,null,null,null,null,null,null,"Timothée"]
[null,null,null,null,null,null,null,null,null,null,null,"Ugo"]
[null,null,null,null,null,null,null,null,null,null,null,"Valentin"]

{"sheet":"Facture 1","index":5,"n_rows":11,"n_cols":21,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["N° facture","Période","Titre","Nom-prénom","Nom","Prénom","Adresse","CP","Ville","Nom  enfant","Prénom enfant","Période","Lundi","Mardi","Jeudi","Nbre jours","Prix","Montant","Montant en lettre","Total","Nbe enfant"]
[1,1,"M.","Aubin Raymond","Aubin","Raymond","11 rue des Aubépines",80440,"Glisy","Aubin","Timothée","du 07 septembre au 15 octobre 2015",4,5,5,14,1,14,"quatorze Euros ",14,1]
[2,1,"M.","Belkacem Michel","Belkacem","Michel","13 rue des vignes",80440,"Glisy","Belkacem","Inès","du 07 septembre au 15 octobre 2015",7,7,0,14,1,14,"quatorze Euros ",14,1]
[3,1,"M.","Bouillez André","Bouillez","André","28 rue du Vert-Bout",80440,"Glisy","Bouillez","Théotim","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"vingt et un Euros ",21,1]
[4,1,"M.","Couturier Blaise","Couturier","Blaise","4 rue Neuve",80440,"Glisy","Couturier","Telma","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"vingt et un Euros ",21,1]
[5,1,"M.","Fouré Brice","Fouré","Brice","7 rue des Vieux Ceps",80440,"Glisy","Fouré","Angèle","du 07 septembre au 15 octobre 2015",6,0,0,6,1,6,"six Euros ",6,1]
[6,1,"M.","Gérard Odette","Gérard","Odette","4 rue des Moissons",80440,"Blangy-Tronville","Gérard","Hubert","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"vingt et un Euros ",21,1]
[7,1,"M.","Wuyts Gontran","Wuyts","Gontran","28 rue des Trèmières",80440,"Glisy","Wuyts","Basile","du 07 septembre au 15 octobre 2015",0,7,0,7,1,7,"sept Euros ",7,1]
[10,1,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy","Klavinski","Noé","du 07 septembre au 15 octobre 2015",7,0,7,14,1,14,"quatorze Euros ",14,1]
[10,1,"M.","Klavinski Boris","Klavinski","Boris","4 rue des Alcoves",80440,"Glisy","Klavinski","Lalie","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"vingt et un Euros ",21,1]
[11,1,"M.","Messe Armel","Messe","Armel","12 rue de la République",80440,"Glisy","Messe","Léo","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"vingt et un Euros ",21,1]

{"sheet":"Facture 2","index":6,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N° facture","Période","Titre","Nom-prénom","Nom","Prénom","Adresse","CP","Ville","Nom  enfant","Prénom enfant","Période","Lundi","Mardi","Jeudi","Nbre jours","Prix","Montant","Montant en lettre","Total","Nbe enfant"]
[8,1,"M.","Dubois Charles","Dubois","Charles","17 rue du Vert Bout",80440,"Glisy","Dubois","Chloé","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"quarante deux Euros ",42,2]
[8,1,"M.","Dubois Charles","Dubois","Charles","17 rue du Vert Bout",80440,"Glisy","Dubois","Arthur","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"quarante deux Euros ",42,2]
[9,1,"M.","Dupont Vincent","Dupont","Vincent","8 rue Francis Desavoix",80440,"Glisy","Dupont","Romane","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"trente cinq Euros ",35,2]
[9,1,"M.","Dupont Vincent","Dupont","Vincent","8 rue Francis Desavoix",80440,"Glisy","Dupont","Ambre","du 07 septembre au 15 octobre 2015",7,0,7,14,1,14,"trente cinq Euros ",35,2]

{"sheet":"Facture 3","index":7,"n_rows":4,"n_cols":21,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["N° facture","Période","Titre","Nom-prénom","Nom","Prénom","Adresse","CP","Ville","Nom  enfant","Prénom enfant","Période","Lundi","Mardi","Jeudi","Nbre jours","Prix","Montant","Montant en lettre","Total","Nbe enfant"]
[14,1,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy","Delcroix","Sarah","du 07 septembre au 15 octobre 2015",3,3,3,9,1,9,"cent deux Euros ",102,3]
[14,1,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy","Delcroix","Arthur","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"cent deux Euros ",102,3]
[14,1,"M.","Delcroix Claude","Delcroix","Claude","5 rue des Sarments",80440,"Glisy","Delcroix","Elsa","du 07 septembre au 15 octobre 2015",7,7,7,21,1,21,"cent deux Euros ",102,3]

{"sheet":"Feuil1","index":8,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[" Dim appWD As Word.Application"]
[" Set appWD = CreateObject(\"Word.Application\") ' un objet"]
[" word est créé"]
[" appWD.Documents.Open Filename:=\"C:\\......\\x.doc\""]
[" ...."]
[" appWD.Quit ' je quitte Word"]