{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["17.01.23 VISIO BMM","16.02.23 VISIO BMM ","22.02.2023 BRESSUIRE D41B","07.03.23 CLISSON D2","8 ET 09.03.23 MORTAGNE D3","14.03.23 NANTES D41B","29.03.23 BRESSUIRE BMM","25.07.23 CHOLET BMM","D2","D3","D4-1B","BMM"],"not_rendered":{"macros":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"17.01.23 VISIO BMM","index":0,"n_rows":13,"n_cols":21,"rows_kept":13}
["ID","DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,{"$f":"RIGHT(C2,7)","v":"1701-23"},"BMM-1701-23","VISIO","ERM T","XXX",0,49300,"CHOLET","POMIES","WILLIAM",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-001",null,null,{"$f":"IF(ISBLANK(E2),0,395)","v":{"v":395,"d":"395.00 €"}}]
[2,{"$f":"RIGHT(C3,7)","v":"1701-23"},"BMM-1701-23","VISIO","ERM P","XXX",0,49300,"CHOLET","MARTINS","LIONEL",{"$nulls":3},"2022-12-29",{"$nulls":5},{"$f":"IF(ISBLANK(E3),0,395)","v":{"v":395,"d":"395.00 €"}}]
[3,"1701-23","BMM-1701-23","VISIO","ERM B","XXX",0,49300,"CHOLET","DABOND","JULIEN",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-002",null,null,{"v":395,"d":"395.00 €"}]
[4,"1701-23","BMM-1701-23","VISIO","ERM B","XXX",0,49300,"CHOLET","ROULLIER","JULIEN",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-003",null,null,{"v":395,"d":"395.00 €"}]
[5,"1701-23","BMM-1701-23","VISIO","ERM M","XXX",0,49300,"CHOLET","REYNES","THIERRY",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-004",null,null,{"v":395,"d":"395.00 €"}]
[6,"1701-23","BMM-1701-23","VISIO","ERM M","XXX",0,49300,"CHOLET","SAUVIER","PATRICE",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-005",null,null,{"v":395,"d":"395.00 €"}]
[7,"1701-23","BMM-1701-23","VISIO","ERM L","XXX",0,49300,"CHOLET","LETOMBE","ARMAND",{"$nulls":3},"2022-12-29",null,null,"VLABMM23-006",null,null,{"v":395,"d":"395.00 €"}]
[8,"1701-23","BMM-1701-23","VISIO","ERM SN","XXX",0,49300,"CHOLET","HUMBERT","PASCAL",{"$nulls":3},"2022-12-29",{"$nulls":5},{"v":395,"d":"395.00 €"}]
[9,{"$nulls":19},0]
[10,{"$nulls":19},0]
[{"$nulls":4},"documents fait le 28/12/2022"]
[null,"format date 17/01/2023 automatique"]

{"sheet":"16.02.23 VISIO BMM ","index":1,"n_rows":25,"n_cols":21,"rows_kept":25}
["ID","DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,{"$f":"RIGHT(C2,7)","v":"1602-23"},"BMM-1602-23","VISIO","ERM L","XX",0,49300,"CHOLET","AUBERT","BASTIEN",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-009",null,null,{"$f":"IF(ISBLANK(E2),0,395)","v":{"v":395,"d":"395.00 €"}}]
[2,{"$f":"RIGHT(C3,7)","v":"1602-23"},"BMM-1602-23","VISIO","ERM PF","XX",0,49300,"CHOLET","HENRYON","MAXIME",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-010",null,null,{"$f":"IF(ISBLANK(E3),0,395)","v":{"v":395,"d":"395.00 €"}}]
[3,"1602-23","BMM-1602-23","VISIO","ERM G","XX",0,49300,"CHOLET","LE QUERE","JOHNNY",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-011",null,null,{"v":395,"d":"395.00 €"}]
[4,"1602-23","BMM-1602-23","VISIO","ERM F","XX",0,49300,"CHOLET","GARRIDO","DENIS",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-012",null,null,{"v":395,"d":"395.00 €"}]
[5,"1602-23","BMM-1602-23","VISIO","ERM LP","XX",0,49300,"CHOLET","PEREZ","JOSE",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-013",null,null,{"v":395,"d":"395.00 €"}]
[6,"1602-23","BMM-1602-23","VISIO","ERM LP","XX",0,49300,"CHOLET","MACAREZ  ","JEROME",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-014",null,null,{"v":395,"d":"395.00 €"}]
[7,"1602-23","BMM-1602-23","VISIO","ERM V","XX",0,49300,"CHOLET","PELARD","FRANCK",{"$nulls":3},"2022-12-29",{"$nulls":5},{"v":395,"d":"395.00 €"}]
[8,"1602-23","BMM-1602-23","VISIO","ERM V","XX",0,49300,"CHOLET","DE OLIVEIRA","JULIEN",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-015",null,null,{"v":395,"d":"395.00 €"}]
[9,"1602-23","BMM-1602-23","VISIO","ERM P","XX",0,49300,"CHOLET","GRESSENT","VALENTIN",{"$nulls":3},"2022-12-29",null,null,"INOEAD23-016",null,null,{"v":395,"d":"395.00 €"}]
[10,{"$nulls":4},"","","","",{"$nulls":3},"",null,"2022-12-29",{"$nulls":5},0]
[]
[null,"format date 17/01/2023 automatique",null,null,"documents fait le 28/12/2022"]
[]
[]
[{"$nulls":12},"Étiquettes de lignes","Somme de MONTANT HT"]
[{"$nulls":12},"(vide)",0]
[{"$nulls":12},"ERM L",{"v":395,"d":"395 €"}]
[{"$nulls":12},"ERM PF",{"v":395,"d":"395 €"}]
[{"$nulls":12},"ERM G",{"v":395,"d":"395 €"}]
[{"$nulls":12},"ERM F",{"v":395,"d":"395 €"}]
[{"$nulls":12},"ERM LP",{"v":790,"d":"790 €"}]
[{"$nulls":12},"ERM V",{"v":790,"d":"790 €"}]
[{"$nulls":12},"ERM P",{"v":395,"d":"395 €"}]
[{"$nulls":12},"Total général",{"v":3555,"d":"3,555 €"}]

{"sheet":"22.02.2023 BRESSUIRE D41B","index":2,"n_rows":13,"n_cols":21,"rows_kept":13}
["ID","DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,{"$f":"RIGHT(C2,7)","v":"2202-23"},"D41B-2202-23","BRESSUIRE","SNP","XX","X",49300,"CHOLET","FRANCK","PIERRE",{"$nulls":6},"VLA1B23-001",null,null,{"$f":"IF(ISBLANK(E2),0,450)","v":{"v":450,"d":"450.00 €"}}]
[2,{"$f":"RIGHT(C3,7)","v":"2202-23"},"D41B-2202-23","BRESSUIRE","MV","XX",0,49300,"CHOLET","MARGUET","BENOIT",{"$nulls":6},"VLA1B23-002",null,null,{"$f":"IF(ISBLANK(E3),0,450)","v":{"v":450,"d":"450.00 €"}}]
[null,"",{"$nulls":18},0]
[null,"",{"$nulls":18},0]
[null,"",{"$nulls":18},0]
[null,"",{"$nulls":18},0]
[null,"",{"$nulls":18},0]
[null,"",{"$nulls":18},0]
[{"$nulls":20},0]
[{"$nulls":20},0]
[]
[null,"format date 17/01/2023 automatique"]

{"sheet":"07.03.23 CLISSON D2","index":3,"n_rows":26,"n_cols":21,"rows_kept":26}
["ID","DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,{"$f":"RIGHT(C2,7)","v":"0703-23"},"D2-0703-23","CLISSON","AE","XX",0,49300,"cholet","FRANCK","BASTIEN",{"$nulls":4},6,12,"VLA223-001","15/12/2022",null,{"$f":"IF(ISBLANK(E2),0,395)","v":{"v":395,"d":"395.00 €"}}]
[2,{"$f":"RIGHT(C3,7)","v":"0703-23"},"D2-0703-23","CLISSON","VC","XX",0,49300,"cholet","MARGUET","MAXIME",{"$nulls":4},6,12,"VLA223-002",null,null,{"$f":"IF(ISBLANK(E3),0,395)","v":{"v":395,"d":"395.00 €"}}]
[null,"0703-23","D2-0703-23","CLISSON","AA","XX",0,49300,"cholet","AUBERT","JOHNNY",{"$nulls":4},6,12,"VLA223-003",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","AMT","XX",0,49300,"cholet","HENRYON","DENIS",{"$nulls":4},6,8,"VLA223-004",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","AMT","XX",0,49300,"cholet","LE QUERE","JULIEN",{"$nulls":4},5,55,"VLA223-005",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","TCA","XX",0,49300,"cholet","GARRIDO","VALENTIN",{"$nulls":4},9,1,"VLA223-006",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","ERP","XX",0,49300,"cholet","CERDAN","JULIEN",{"$nulls":4},7,12,"VLA223-007",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","EAED","XX",0,49300,"cholet","CHABBERT","JULIEN",{"$nulls":4},2,5,"VLA223-008",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","EAED","XX",0,49300,"cholet","REYNES","Patric",{"$nulls":4},3,12,"VLA223-009",null,null,{"v":395,"d":"395.00 €"}]
[null,"0703-23","D2-0703-23","CLISSON","MP","XX",0,49300,"cholet","SAUVIER","Arnaud",{"$nulls":4},6,8,"VLA223-010",null,null,{"v":395,"d":"395.00 €"}]
[]
[]
[]
[]
[null,"format date 17/01/2023 automatique",{"$nulls":10},"Étiquettes de lignes","Nombre de NOM","Somme de MONTANT HT"]
[{"$nulls":12},"(vide)"]
[{"$nulls":12},"AE",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"VC",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"AA",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"AMT",2,{"v":790,"d":"790 €"}]
[{"$nulls":12},"TCA",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"ERP",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"EAED",2,{"v":790,"d":"790 €"}]
[{"$nulls":12},"MP",1,{"v":395,"d":"395 €"}]
[{"$nulls":12},"Total général",10,{"v":3950,"d":"3,950 €"}]

{"sheet":"8 ET 09.03.23 MORTAGNE D3","index":4,"n_rows":11,"n_cols":20,"rows_kept":11}
["ID","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,null,"MORTAGNE","PO","XX",0,49300,"CHOLET",{"$nulls":8},"VLA323-001",null,null,{"$f":"IF(ISBLANK(D2),0,825)","v":{"v":825,"d":"825.00 €"}}]
[2,null,"MORTAGNE","TR","XX",0,49300,"CHOLET",{"$nulls":8},"VLA323-002",null,null,{"$f":"IF(ISBLANK(D3),0,825)","v":{"v":825,"d":"825.00 €"}}]
[{"$nulls":4},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,6,FALSE))","v":""},{"$nulls":7},0]

{"sheet":"14.03.23 NANTES D41B","index":5,"n_rows":11,"n_cols":20,"rows_kept":11}
["ID","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,null,"NANTES",null,{"$f":"IF(ISBLANK(D2),\"\",VLOOKUP(D2,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D2),\"\",VLOOKUP(D2,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D2),\"\",VLOOKUP(D2,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D2),\"\",VLOOKUP(D2,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D2),\"\",VLOOKUP(D2,#REF!,6,FALSE))","v":""},{"$nulls":7},{"$f":"IF(ISBLANK(D2),0,450)","v":0}]
[2,null,"NANTES",null,{"$f":"IF(ISBLANK(D3),\"\",VLOOKUP(D3,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D3),\"\",VLOOKUP(D3,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D3),\"\",VLOOKUP(D3,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D3),\"\",VLOOKUP(D3,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D3),\"\",VLOOKUP(D3,#REF!,6,FALSE))","v":""},{"$nulls":7},{"$f":"IF(ISBLANK(D3),0,450)","v":0}]
[{"$nulls":4},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D4),\"\",VLOOKUP(D4,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D5),\"\",VLOOKUP(D5,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D6),\"\",VLOOKUP(D6,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",VLOOKUP(D7,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D8),\"\",VLOOKUP(D8,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D9),\"\",VLOOKUP(D9,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D10),\"\",VLOOKUP(D10,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":4},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D11),\"\",VLOOKUP(D11,#REF!,6,FALSE))","v":""},{"$nulls":7},0]

{"sheet":"29.03.23 BRESSUIRE BMM","index":6,"n_rows":11,"n_cols":20,"rows_kept":11}
["ID","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,null,"BRESSUIRE","TM","XX",0,49300,"CHOLET","CERDAN","Patric",{"$nulls":6},"VLABMM23-012",null,null,{"$f":"IF(ISBLANK(D2),0,395)","v":{"v":395,"d":"395.00 €"}}]
[2,null,"BRESSUIRE","TM","XX",0,49300,"CHOLET","CHABBERT","Arnaud",{"$nulls":6},"VLABMM23-011",null,null,{"$f":"IF(ISBLANK(D3),0,395)","v":{"v":395,"d":"395.00 €"}}]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]
[{"$nulls":19},0]

{"sheet":"25.07.23 CHOLET BMM","index":7,"n_rows":13,"n_cols":21,"rows_kept":13}
["ID","DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
[1,{"$f":"RIGHT(C2,7)","v":"2507-23"},"BMM-2507-23","CHOLET","MP","XX",0,49300,"CHOLET","DEGOS","CHRISTOPHE",{"$nulls":6},"VLABMM23-007",null,null,{"$f":"IF(ISBLANK(E2),0,395)","v":{"v":395,"d":"395.00 €"}}]
[2,{"$f":"RIGHT(C3,7)","v":"2507-23"},"BMM-2507-23","CHOLET","AE","XX",0,49300,"CHOLET","LABERNY","Philippe",{"$nulls":6},"VLABMM23-008",null,null,{"v":395,"d":"395.00 €"}]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E4),\"\",VLOOKUP(E4,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E4),\"\",VLOOKUP(E4,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E4),\"\",VLOOKUP(E4,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E4),\"\",VLOOKUP(E4,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E4),\"\",VLOOKUP(E4,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E5),\"\",VLOOKUP(E5,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E5),\"\",VLOOKUP(E5,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E5),\"\",VLOOKUP(E5,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E5),\"\",VLOOKUP(E5,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E5),\"\",VLOOKUP(E5,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E6),\"\",VLOOKUP(E6,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E6),\"\",VLOOKUP(E6,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E6),\"\",VLOOKUP(E6,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E6),\"\",VLOOKUP(E6,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E6),\"\",VLOOKUP(E6,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E7),\"\",VLOOKUP(E7,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E7),\"\",VLOOKUP(E7,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E7),\"\",VLOOKUP(E7,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E7),\"\",VLOOKUP(E7,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E7),\"\",VLOOKUP(E7,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E8),\"\",VLOOKUP(E8,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E8),\"\",VLOOKUP(E8,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E8),\"\",VLOOKUP(E8,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E8),\"\",VLOOKUP(E8,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E8),\"\",VLOOKUP(E8,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[null,"",{"$nulls":3},{"$f":"IF(ISBLANK(E9),\"\",VLOOKUP(E9,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E9),\"\",VLOOKUP(E9,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E9),\"\",VLOOKUP(E9,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E9),\"\",VLOOKUP(E9,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E9),\"\",VLOOKUP(E9,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":5},{"$f":"IF(ISBLANK(E10),\"\",VLOOKUP(E10,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E10),\"\",VLOOKUP(E10,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E10),\"\",VLOOKUP(E10,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E10),\"\",VLOOKUP(E10,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E10),\"\",VLOOKUP(E10,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[{"$nulls":5},{"$f":"IF(ISBLANK(E11),\"\",VLOOKUP(E11,#REF!,2,FALSE))","v":""},{"$f":"IF(ISBLANK(E11),\"\",VLOOKUP(E11,#REF!,3,FALSE))","v":""},{"$f":"IF(ISBLANK(E11),\"\",VLOOKUP(E11,#REF!,4,FALSE))","v":""},{"$f":"IF(ISBLANK(E11),\"\",VLOOKUP(E11,#REF!,5,FALSE))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(E11),\"\",VLOOKUP(E11,#REF!,6,FALSE))","v":""},{"$nulls":7},0]
[]
[null,"format date 17/01/2023 automatique"]

{"sheet":"D2","index":8,"n_rows":33,"n_cols":20,"rows_kept":33}
["DATE FORMATON","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
["retrouver toutes les informations à partir du n° de certificat selon les titres de colonnes dans tous les onglets du classeurs",{"$nulls":15},"VLA223-001"]
[{"$nulls":16},"VLA223-002"]
[{"$nulls":16},"VLA223-003"]
[{"$nulls":16},"VLA223-004"]
[{"$nulls":16},"VLA223-005"]
[{"$nulls":16},"VLA223-006"]
[{"$nulls":16},"VLA223-007"]
[{"$nulls":16},"VLA223-008"]
[{"$nulls":16},"VLA223-009"]
[{"$nulls":16},"VLA223-010"]
[{"$nulls":16},"VLA223-011"]
[{"$nulls":16},"VLA223-012"]
[{"$nulls":16},"VLA223-013"]
[{"$nulls":16},"VLA223-014"]
[{"$nulls":16},"VLA223-015"]
[{"$nulls":16},"VLA223-016"]
[{"$nulls":16},"VLA223-017"]
[{"$nulls":16},"VLA223-018"]
[{"$nulls":16},"VLA223-019"]
[{"$nulls":16},"VLA223-020"]
[{"$nulls":16},"VLA223-021"]
[{"$nulls":16},"VLA223-022"]
[{"$nulls":16},"VLA223-023"]
[{"$nulls":16},"VLA223-024"]
[{"$nulls":16},"VLA223-025"]
[{"$nulls":16},"VLA223-026"]
[{"$nulls":16},"VLA223-027"]
[{"$nulls":16},"VLA223-028"]
[{"$nulls":16},"VLA223-029"]
[{"$nulls":16},"VLA223-030"]
[{"$nulls":16},"VLA223-031"]
[{"$nulls":16},"VLA223-032"]

{"sheet":"D3","index":9,"n_rows":31,"n_cols":20,"rows_kept":31}
["DATE FORMATION","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
["retrouver toutes les informations à partir du n° de certificat selon les titres de colonnes dans tous les onglets du classeurs",{"$nulls":15},"VLA323-001"]
[{"$nulls":16},"VLA323-002"]
[{"$nulls":16},"VLA323-003"]
[{"$nulls":16},"VLA323-004"]
[{"$nulls":16},"VLA323-005"]
[{"$nulls":16},"VLA323-006"]
[{"$nulls":16},"VLA323-007"]
[{"$nulls":16},"VLA323-008"]
[{"$nulls":16},"VLA323-009"]
[{"$nulls":16},"VLA323-010"]
[{"$nulls":16},"VLA323-011"]
[{"$nulls":16},"VLA323-012"]
[{"$nulls":16},"VLA323-013"]
[{"$nulls":16},"VLA323-014"]
[{"$nulls":16},"VLA323-015"]
[{"$nulls":16},"VLA323-016"]
[{"$nulls":16},"VLA323-017"]
[{"$nulls":16},"VLA323-018"]
[{"$nulls":16},"VLA323-019"]
[{"$nulls":16},"VLA323-020"]
[{"$nulls":16},"VLA323-021"]
[{"$nulls":16},"VLA323-022"]
[{"$nulls":16},"VLA323-023"]
[{"$nulls":16},"VLA323-024"]
[{"$nulls":16},"VLA323-025"]
[{"$nulls":16},"VLA323-026"]
[{"$nulls":16},"VLA323-027"]
[{"$nulls":16},"VLA323-028"]
[{"$nulls":16},"VLA323-029"]
[{"$nulls":16},"VLA323-030"]

{"sheet":"D4-1B","index":10,"n_rows":31,"n_cols":20,"rows_kept":31}
["DATE FORMATION","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
["retrouver toutes les informations à partir du n° de certificat selon les titres de colonnes dans tous les onglets du classeurs",{"$nulls":15},"VLA1B23-001"]
[{"$nulls":16},"VLA1B23-002"]
[{"$nulls":16},"VLA1B23-003"]
[{"$nulls":16},"VLA1B23-004"]
[{"$nulls":16},"VLA1B23-005"]
[{"$nulls":16},"VLA1B23-006"]
[{"$nulls":16},"VLA1B23-007"]
[{"$nulls":16},"VLA1B23-008"]
[{"$nulls":16},"VLA1B23-009"]
[{"$nulls":16},"VLA1B23-010"]
[{"$nulls":16},"VLA1B23-011"]
[{"$nulls":16},"VLA1B23-012"]
[{"$nulls":16},"VLA1B23-013"]
[{"$nulls":16},"VLA1B23-014"]
[{"$nulls":16},"VLA1B23-015"]
[{"$nulls":16},"VLA1B23-016"]
[{"$nulls":16},"VLA1B23-017"]
[{"$nulls":16},"VLA1B23-018"]
[{"$nulls":16},"VLA1B23-019"]
[{"$nulls":16},"VLA1B23-020"]
[{"$nulls":16},"VLA1B23-021"]
[{"$nulls":16},"VLA1B23-022"]
[{"$nulls":16},"VLA1B23-023"]
[{"$nulls":16},"VLA1B23-024"]
[{"$nulls":16},"VLA1B23-025"]
[{"$nulls":16},"VLA1B23-026"]
[{"$nulls":16},"VLA1B23-027"]
[{"$nulls":16},"VLA1B23-028"]
[{"$nulls":16},"VLA1B23-029"]
[{"$nulls":16},"VLA1B23-030"]

{"sheet":"BMM","index":11,"n_rows":32,"n_cols":20,"rows_kept":32}
["DATE FORMATION","N° FORMATION","LIEU DE FORMATION","SOCIETE","ADRESSE","Adresse 2","CP","VILLE","NOM","PRENOM","Email Technicien","Email doc","FINANCEMENT","Documents envoyé le","Note Début","Note Participant","N° Certificat","Certificat fait le ","N°FACTURE","MONTANT HT"]
["retrouver toutes les informations à partir du n° de certificat selon les titres de colonnes dans tous les onglets du classeurs",{"$nulls":15},"VLABMM23-001"]
[{"$nulls":16},"VLABMM23-002"]
[{"$nulls":16},"VLABMM23-003"]
[{"$nulls":16},"VLABMM23-004"]
[{"$nulls":16},"VLABMM23-005"]
[{"$nulls":16},"VLABMM23-006"]
[{"$nulls":16},"VLABMM23-007"]
[{"$nulls":16},"VLABMM23-008"]
[{"$nulls":16},"VLABMM23-009"]
[{"$nulls":16},"VLABMM23-010"]
[{"$nulls":16},"VLABMM23-011"]
[{"$nulls":16},"VLABMM23-012"]
[{"$nulls":16},"VLABMM23-013"]
[{"$nulls":16},"VLABMM23-014"]
[{"$nulls":16},"VLABMM23-015"]
[{"$nulls":16},"VLABMM23-016"]
[{"$nulls":16},"VLABMM23-017"]
[{"$nulls":16},"VLABMM23-018"]
[{"$nulls":16},"VLABMM23-019"]
[{"$nulls":16},"VLABMM23-020"]
[{"$nulls":16},"VLABMM23-021"]
[{"$nulls":16},"VLABMM23-022"]
[{"$nulls":16},"VLABMM23-023"]
[{"$nulls":16},"VLABMM23-024"]
[{"$nulls":16},"VLABMM23-025"]
[{"$nulls":16},"VLABMM23-026"]
[{"$nulls":16},"VLABMM23-027"]
[{"$nulls":16},"VLABMM23-028"]
[{"$nulls":16},"VLABMM23-029"]
[{"$nulls":16},"VLABMM23-030"]
[{"$nulls":16},"VLABMM23-031"]