{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Mode d'emploi","Jours fériés","RECAPITULATIF","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":19,"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":"Mode d'emploi","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Mode d'emploi"]
[1,"Précisez l'année de travail dans l'onglet \"Jours fériés\" en B1\nLe calendrier des jours fériés se met à jour et toutes les onglets mois se mettent également à jour.  La mise en couleur des dates se fait à l'aide de la Mise en forme conditionnelle (MEFC)\nATTENTION : NE PAS CHANGER L'ANNEE DANS LES ONGLETS MOIS"]
[{"$f":"A2+1","v":2},"Encoder les nouveaux chantiers dans l'onglet \"Récapitulatif\" et lancer le tri à l'aide du bouton TRI en B3"]
[{"$f":"A3+1","v":3},"Encoder les données dans chacun des mois concernés :\n- sélectionner le numéro de chantier à l'aide de la liste déroulante\n- le nom du chantier s'affiche automatiquement\n- encoder les données quantitatives\n- les totaux se réalisent horizontalement et verticalement"]
[4,"L'onglet \"Récapitulatif\" se complète des données provenant des colonnes \"TOTAL\" de chaque mois pour en faire une synthèse"]
[5,"La table des jours fériés est apte à travailler pour 3 pays : Quebec naturellement mais aussi Belgique et France : il suffit de choisir le pays en D1 grâce à la liste déroulante. La méthode de calcul est expliquée en colonne \"E\""]
[6,"Les noms utilisés dans le classeur sont présentés en colonne \"E\" également.\nEnfin, une table de conversion des noms des mois en numéro de mois est également présente dans cet onglet (colonne \"A\")"]
[7,"TOUTES LES FEUILLES MOIS SONT IDENTIQUES : C'EST LE NOM DE LA FEUILLE QUI DETERMINE TOUS LES CALCULS.  AINSI IL SUFFIT DE DUPLIQUER LA FEUILLE ET DE METTRE LE NOM DU MOIS POUR QUE TOUS LES CALCULS SE REALISENT"]
[8,"Il est conseillé de conserver un exemplaire vierge du classeur de manière à pouvoir le dupliquer chaque année pour recommencer une nouvelle année"]

{"sheet":"Jours fériés","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Année:",2018,"PAYS :","Quebec"]
["Evènements","Date",null,null,"Méthodes de calculs"]
["Jour de l’An",{"$f":"DATE($B$1,1,1)","v":"2018-01-01"},null,null,"Jour imposé"]
[{"$f":"IF(Pays=\"Quebec\",\"Vendredi Saint\",\"Réservé pour le Quebec\")","v":"Vendredi Saint"},{"$f":"IF(Pays=\"Quebec\",B5-3,\"\")","v":"2018-03-30"},null,null,"Lundi de Pâques - 3"]
["Lundi de Pâques",{"$f":"(ROUND(DATE(An_ref,4,1)/7+MOD(19*MOD(An_ref,19)-7,30)*14%,0)*7-6)+1","v":"2018-04-02"},null,null,"=(ARRONDI(DATE(An_ref;4;1)/7+MOD(19*MOD(An_ref;19)-7;30)*14%;0)*7-6)+1","Algorythme de calcul direct du dimanche de Pâques"]
[{"$f":"IF(Pays=\"Quebec\",\"Réservé Belgique+France\",\"Fête du travail\")","v":"Réservé Belgique+France"},{"$f":"IF(Pays=\"Quebec\",\"\",DATE($B$1,5,1))","v":""},null,null,{"$f":"IF(Pays=\"Quebec\",\"\",\"Jour imposé\")","v":""}]
[{"$f":"IF(Pays=\"France\",\"Armistice 40/45\",\"Réservé France\")","v":"Réservé France"},{"$f":"IF(D1=\"France\",DATE($B$1,5,8),\"\")","v":""},null,null,{"$f":"IF(Pays=\"France\",\"Jour imposé\",\"\")","v":""}]
[{"$f":"IF(Pays=\"Quebec\",\"Réservé Belgique+France\",\"Ascension\")","v":"Réservé Belgique+France"},{"$f":"IF(Pays=\"Quebec\",\"\",B5-1+39)","v":""},null,null,{"$f":"IF(Pays=\"Quebec\",\"\",\"Lundi de Pâques + 38\")","v":""}]
[{"$f":"IF(Pays=\"Quebec\",\"Fête de la Reine\",\"Lundi de la Pentecôte\")","v":"Fête de la Reine"},{"$f":"IF(Pays=\"Quebec\",DATE(An_ref,5,25)-(WEEKDAY(DATE(An_ref,5,25),2)-1),B5-1+49+1)","v":"2018-05-21"},null,null,{"$f":"IF(Pays=\"Quebec\",\"1er lundi avant le 25 mai\",\"Dimanche de Pâques + 50 jours\")","v":"1er lundi avant le 25 mai"}]
[{"$f":"IF(Pays=\"Quebec\",\"Fête nationale Quebec\",\"Fête nationale\")","v":"Fête nationale Quebec"},{"$f":"IF(Pays=\"Belgique\",DATE($B$1,7,21),IF(Pays=\"France\",DATE($B$1,7,14),IF(Pays=\"Quebec\",DATE($B$1,6,24))))","v":"2018-06-24"},null,null,"Jour imposé"]
[{"$f":"IF(Pays=\"Quebec\",\"Fête nationale Canada\",\"Assomption\")","v":"Fête nationale Canada"},{"$f":"IF(Pays=\"Quebec\",DATE(An_ref,7,1),DATE($B$1,8,15))","v":"2018-07-01"},null,null,"Jour imposé"]
[{"$f":"IF(Pays=\"Quebec\",\"Fête du travail\",\"Réservé pour le Quebec\")","v":"Fête du travail"},{"$f":"IF(Pays=\"Quebec\",DATE(An_ref,9,1)+CHOOSE(WEEKDAY(DATE(An_ref,9,1),2),0,6,5,4,3,2,1),\"\")","v":"2018-09-03"},null,null,{"$f":"IF(Pays=\"Quebec\",\"1er lundi du mois de septembre\",\"\")","v":"1er lundi du mois de septembre"}]
[{"$f":"IF(Pays=\"Quebec\",\"Action de grâce\",\"Toussaint\")","v":"Action de grâce"},{"$f":"IF(Pays=\"Quebec\",DATE(An_ref,10,1)+CHOOSE(WEEKDAY(DATE(An_ref,10,1),2),7,13,12,11,10,9,8),(DATE(An_ref,11,1)))","v":"2018-10-08"},null,null,{"$f":"IF(Pays=\"Quebec\",\"2ème lundi d'octobre\",\"Jour imposé\")","v":"2ème lundi d'octobre"}]
["Armistice 14/18",{"$f":"DATE($B$1,11,11)","v":"2018-11-11"},null,null,"Jour imposé"]
["Noël",{"$f":"DATE($B$1,12,25)","v":"2018-12-25"},null,null,"Jour imposé"]
[{"$f":"IF(Pays=\"Quebec\",\"Après Noël\",\"Réservé pour le Quebec\")","v":"Après Noël"},{"$f":"DATE($B$1,12,26)","v":"2018-12-26"},null,null,{"$f":"IF(Pays=\"Quebec\",\"Jour imposé\",\"\")","v":"Jour imposé"}]
["Jour congé convenu"]
["Jour congé convenu"]
["Jour congé convenu"]
["Mardi gras",{"$f":"B5-1-47","v":"2018-02-13"},null,null,"informatif"]
[]
["Table des mois",null,null,null,"Noms utilisés dans le classeur"]
["Janvier",1,null,null,"An_ref","='Jours fériés'!$B$1"]
["Février",2,null,null,"An_réf","='Jours fériés'!$B$1"]
["Mars",3,null,null,"ANNEE","=Janvier!$A$3"]
["Avril",4,null,null,"JF","='Jours fériés'!$B$3:$B$19"]
["Mai",5,null,null,"MOIS","='Jours fériés'!$A$23:$B$34"]
["Juin",6,null,null,"Pays","='Jours fériés'!$D$1"]
["Juillet",7]
["Août",8]
["Septembre",9]
["Octobre",10]
["Novembre",11]
["Décembre",12]

{"sheet":"RECAPITULATIF","index":2,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
["ANNEE :",{"$f":"'Jours fériés'!An_ref","v":2018}]
["N.CHANTIER","DESIGNATIONS","MOIS","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
[null,null,"TOTAL",{"$f":"SUM(D4:D152)","v":0},{"$f":"SUM(E4:E152)","v":0},0,0,0,0,0,0,0,0,0,0]
["16-5229","PLACE VERSAILLES",{"$f":"SUM(D4:O4)","v":0},{"$f":"IFERROR(INDEX(INDIRECT(D$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A4,INDIRECT(D$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["16-5248","PAVILLON BONENFANT",{"$f":"SUM(D5:O5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["16-5259","PÈRE MARQUETTE",{"$f":"SUM(D6:O6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["16-5307","HOPITAL LAVAL",{"$f":"SUM(D7:O7)","v":0},{"$f":"IFERROR(INDEX(INDIRECT(D$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A7,INDIRECT(D$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["16-5321","FONTAINE BLEAU",{"$f":"SUM(D8:O8)","v":0},{"$f":"IFERROR(INDEX(INDIRECT(D$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A8,INDIRECT(D$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["17-5331","MARLY CHATEL 3",{"$f":"SUM(D9:O9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5360","REPARATIONS GARANTIES",{"$f":"SUM(D10:O10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5375","LE ST-LAURENT",{"$f":"SUM(D11:O11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5386","ODÉON",{"$f":"SUM(D12:O12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5392","TERRASSE DU SÉMINAIRE",{"$f":"SUM(D13:O13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5395","HOTEL CLASSIQUE",{"$f":"SUM(D14:O14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5399","MAISON DES AINÉS",{"$f":"SUM(D15:O15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5400","736 PÈRE MARQUETTE",{"$f":"SUM(D16:O16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5401","LOUIS HÉMON",{"$f":"SUM(D17:O17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5404","ILOT ST-PATRICK",{"$f":"SUM(D18:O18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5406","CENTRE DES CONGRES",{"$f":"SUM(D19:O19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5407","BENMORE",{"$f":"SUM(D20:O20)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A20,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["17-5411","2323 CHAPDELEINE",{"$f":"SUM(D21:O21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5414","MERICI",{"$f":"SUM(D22:O22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5415","PAVILLON LACERTE",{"$f":"SUM(D23:O23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5424","FIDUCIE ST-DOMINIQUE",{"$f":"SUM(D24:O24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5425","GROUPE MACH",{"$f":"SUM(D25:O25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5429","WENDAKE",{"$f":"SUM(D26:O26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5430","PERISCOPE",{"$f":"SUM(D27:O27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5434","IRDPQ",{"$f":"SUM(D28:O28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5437","CHAMONIX",{"$f":"SUM(D29:O29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5440","LE NOBLET",{"$f":"SUM(D30:O30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5441","LE BERNIERES",{"$f":"SUM(D31:O31)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5444","PLACE CHARLESBOURG",{"$f":"SUM(D32:O32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5446","HOTEL CLARION",{"$f":"SUM(D33:O33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5447","LAUDANCE",{"$f":"SUM(D34:O34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5448","GRAND JEAN",{"$f":"SUM(D35:O35)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5449","ST-AUGUSTIN",{"$f":"SUM(D36:O36)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A36,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["17-5451","ST-PAUL",{"$f":"SUM(D37:O37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5453","LE BERNIERES",{"$f":"SUM(D38:O38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5454","JARDINS DU PARC",{"$f":"SUM(D39:O39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5455","RENAISSANCE 2",{"$f":"SUM(D40:O40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5460","LES FACADES DE L'ILE",{"$f":"SUM(D41:O41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5463","MÉRICI",{"$f":"SUM(D42:O42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5465","VALCARTIER",{"$f":"SUM(D43:O43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5466","ST LAURENT",{"$f":"SUM(D44:O44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5490","MARLY",{"$f":"SUM(D45:O45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5496","TB4",{"$f":"SUM(D46:O46)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5497","DOOLY'S",{"$f":"SUM(D47:O47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-55","LABERGE",{"$f":"SUM(D48:O48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5501","HOTEL CLASSIQUE",{"$f":"SUM(D49:O49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5503","LEVIS",{"$f":"SUM(D50:O50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5506","CHU",{"$f":"SUM(D51:O51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["17-5507","SAMUEL HOLLAND",{"$f":"SUM(D52:O52)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A52,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
["17-5509","CCBN",{"$f":"SUM(D53:O53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["99-01","ADM",{"$f":"SUM(D54:O54)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["99-02","AUTRES",{"$f":"SUM(D55:O55)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D56:O56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D57:O57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D58:O58)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D59:O59)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D60:O60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D61:O61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D62:O62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D63:O63)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D64:O64)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D65:O65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D66:O66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D67:O67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D68:O68)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A68,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D69:O69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D70:O70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D71:O71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D72:O72)","v":0},{"$f":"IFERROR(INDEX(INDIRECT(D$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A72,INDIRECT(D$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D73:O73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D74:O74)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D75:O75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D76:O76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D77:O77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D78:O78)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D79:O79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D80:O80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D81:O81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D82:O82)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D83:O83)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D84:O84)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A84,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D85:O85)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D86:O86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D87:O87)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D88:O88)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D89:O89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D90:O90)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D91:O91)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D92:O92)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D93:O93)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D94:O94)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D95:O95)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D96:O96)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D97:O97)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D98:O98)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D99:O99)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D100:O100)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A100,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D101:O101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D102:O102)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D103:O103)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D104:O104)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D105:O105)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D106:O106)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D107:O107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D108:O108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D109:O109)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D110:O110)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D111:O111)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D112:O112)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D113:O113)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D114:O114)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D115:O115)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D116:O116)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A116,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D117:O117)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D118:O118)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D119:O119)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D120:O120)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D121:O121)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D122:O122)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D123:O123)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D124:O124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D125:O125)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D126:O126)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D127:O127)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D128:O128)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D129:O129)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D130:O130)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D131:O131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D132:O132)","v":0},0,{"$f":"IFERROR(INDEX(INDIRECT(E$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A132,INDIRECT(E$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D133:O133)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D134:O134)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D135:O135)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D136:O136)","v":0},{"$f":"IFERROR(INDEX(INDIRECT(D$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A136,INDIRECT(D$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D137:O137)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D138:O138)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D139:O139)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D140:O140)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D141:O141)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D142:O142)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D143:O143)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D144:O144)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D145:O145)","v":0},0,0,0,0,{"$f":"IFERROR(INDEX(INDIRECT(H$2&\"!\"&\"$AH$5:$AH$27\"),MATCH($A145,INDIRECT(H$2&\"!\"&\"$B$5:$B$27\"),0),1),0)","v":0},0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D146:O146)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D147:O147)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D148:O148)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D149:O149)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D150:O150)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D151:O151)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(D152:O152)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Janvier","index":3,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-01-01"},{"$f":"C3+1","v":"2018-01-02"},{"$f":"D3+1","v":"2018-01-03"},"2018-01-04","2018-01-05","2018-01-06","2018-01-07","2018-01-08","2018-01-09","2018-01-10","2018-01-11","2018-01-12","2018-01-13","2018-01-14","2018-01-15","2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20","2018-01-21","2018-01-22","2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27","2018-01-28","2018-01-29","2018-01-30","2018-01-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Février","index":4,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-02-01"},{"$f":"C3+1","v":"2018-02-02"},{"$f":"D3+1","v":"2018-02-03"},"2018-02-04","2018-02-05","2018-02-06","2018-02-07","2018-02-08","2018-02-09","2018-02-10","2018-02-11","2018-02-12","2018-02-13","2018-02-14","2018-02-15","2018-02-16","2018-02-17","2018-02-18","2018-02-19","2018-02-20","2018-02-21","2018-02-22","2018-02-23","2018-02-24","2018-02-25","2018-02-26","2018-02-27","2018-02-28","2018-03-01","2018-03-02","2018-03-03","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Mars","index":5,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-03-01"},{"$f":"C3+1","v":"2018-03-02"},{"$f":"D3+1","v":"2018-03-03"},"2018-03-04","2018-03-05","2018-03-06","2018-03-07","2018-03-08","2018-03-09","2018-03-10","2018-03-11","2018-03-12","2018-03-13","2018-03-14","2018-03-15","2018-03-16","2018-03-17","2018-03-18","2018-03-19","2018-03-20","2018-03-21","2018-03-22","2018-03-23","2018-03-24","2018-03-25","2018-03-26","2018-03-27","2018-03-28","2018-03-29","2018-03-30","2018-03-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Avril","index":6,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-04-01"},{"$f":"C3+1","v":"2018-04-02"},{"$f":"D3+1","v":"2018-04-03"},"2018-04-04","2018-04-05","2018-04-06","2018-04-07","2018-04-08","2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14","2018-04-15","2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21","2018-04-22","2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28","2018-04-29","2018-04-30","2018-05-01","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Mai","index":7,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-05-01"},{"$f":"C3+1","v":"2018-05-02"},{"$f":"D3+1","v":"2018-05-03"},"2018-05-04","2018-05-05","2018-05-06","2018-05-07","2018-05-08","2018-05-09","2018-05-10","2018-05-11","2018-05-12","2018-05-13","2018-05-14","2018-05-15","2018-05-16","2018-05-17","2018-05-18","2018-05-19","2018-05-20","2018-05-21","2018-05-22","2018-05-23","2018-05-24","2018-05-25","2018-05-26","2018-05-27","2018-05-28","2018-05-29","2018-05-30","2018-05-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Juin","index":8,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-06-01"},{"$f":"C3+1","v":"2018-06-02"},{"$f":"D3+1","v":"2018-06-03"},"2018-06-04","2018-06-05","2018-06-06","2018-06-07","2018-06-08","2018-06-09","2018-06-10","2018-06-11","2018-06-12","2018-06-13","2018-06-14","2018-06-15","2018-06-16","2018-06-17","2018-06-18","2018-06-19","2018-06-20","2018-06-21","2018-06-22","2018-06-23","2018-06-24","2018-06-25","2018-06-26","2018-06-27","2018-06-28","2018-06-29","2018-06-30","2018-07-01","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Juillet","index":9,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-07-01"},{"$f":"C3+1","v":"2018-07-02"},{"$f":"D3+1","v":"2018-07-03"},"2018-07-04","2018-07-05","2018-07-06","2018-07-07","2018-07-08","2018-07-09","2018-07-10","2018-07-11","2018-07-12","2018-07-13","2018-07-14","2018-07-15","2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20","2018-07-21","2018-07-22","2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27","2018-07-28","2018-07-29","2018-07-30","2018-07-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Août","index":10,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-08-01"},{"$f":"C3+1","v":"2018-08-02"},{"$f":"D3+1","v":"2018-08-03"},"2018-08-04","2018-08-05","2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10","2018-08-11","2018-08-12","2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17","2018-08-18","2018-08-19","2018-08-20","2018-08-21","2018-08-22","2018-08-23","2018-08-24","2018-08-25","2018-08-26","2018-08-27","2018-08-28","2018-08-29","2018-08-30","2018-08-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Septembre","index":11,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-09-01"},{"$f":"C3+1","v":"2018-09-02"},{"$f":"D3+1","v":"2018-09-03"},"2018-09-04","2018-09-05","2018-09-06","2018-09-07","2018-09-08","2018-09-09","2018-09-10","2018-09-11","2018-09-12","2018-09-13","2018-09-14","2018-09-15","2018-09-16","2018-09-17","2018-09-18","2018-09-19","2018-09-20","2018-09-21","2018-09-22","2018-09-23","2018-09-24","2018-09-25","2018-09-26","2018-09-27","2018-09-28","2018-09-29","2018-09-30","2018-10-01","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Octobre","index":12,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-10-01"},{"$f":"C3+1","v":"2018-10-02"},{"$f":"D3+1","v":"2018-10-03"},"2018-10-04","2018-10-05","2018-10-06","2018-10-07","2018-10-08","2018-10-09","2018-10-10","2018-10-11","2018-10-12","2018-10-13","2018-10-14","2018-10-15","2018-10-16","2018-10-17","2018-10-18","2018-10-19","2018-10-20","2018-10-21","2018-10-22","2018-10-23","2018-10-24","2018-10-25","2018-10-26","2018-10-27","2018-10-28","2018-10-29","2018-10-30","2018-10-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Novembre","index":13,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-11-01"},{"$f":"C3+1","v":"2018-11-02"},{"$f":"D3+1","v":"2018-11-03"},"2018-11-04","2018-11-05","2018-11-06","2018-11-07","2018-11-08","2018-11-09","2018-11-10","2018-11-11","2018-11-12","2018-11-13","2018-11-14","2018-11-15","2018-11-16","2018-11-17","2018-11-18","2018-11-19","2018-11-20","2018-11-21","2018-11-22","2018-11-23","2018-11-24","2018-11-25","2018-11-26","2018-11-27","2018-11-28","2018-11-29","2018-11-30","2018-12-01","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]

{"sheet":"Décembre","index":14,"n_rows":29,"n_cols":37,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[3,2,3,32]]}
[]
[]
[{"$f":"An_réf","v":2018},null,{"$f":"DATE(ANNEE,VLOOKUP(MID(CELL(\"nomfichier\",A1),SEARCH(\"]\",CELL(\"nomfichier\",A1),1)+1,15),MOIS,2,FALSE),1)","v":"2018-12-01"},{"$f":"C3+1","v":"2018-12-02"},{"$f":"D3+1","v":"2018-12-03"},"2018-12-04","2018-12-05","2018-12-06","2018-12-07","2018-12-08","2018-12-09","2018-12-10","2018-12-11","2018-12-12","2018-12-13","2018-12-14","2018-12-15","2018-12-16","2018-12-17","2018-12-18","2018-12-19","2018-12-20","2018-12-21","2018-12-22","2018-12-23","2018-12-24","2018-12-25","2018-12-26","2018-12-27","2018-12-28","2018-12-29","2018-12-30","2018-12-31","TOTAL"]
["CHANTIERS"]
[{"$f":"IFERROR(VLOOKUP($B5,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOPITAL LAVAL"},"16-5307",null,null,null,null,null,null,null,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":"SUM(C5:AG5)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B6,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PERISCOPE"},"17-5430",null,null,null,null,null,null,null,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":"SUM(C6:AG6)","v":0}]
[{"$f":"IFERROR(VLOOKUP($B7,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"LE NOBLET"},"17-5440",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B8,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"MARLY"},"17-5490",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B9,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"HOTEL CLASSIQUE"},"17-5501",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B10,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"CHU"},"17-5506",null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B11,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":"PÈRE MARQUETTE"},"16-5259",null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B12,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B13,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B14,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B15,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B16,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B17,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B18,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B19,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B20,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B21,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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," "]
[{"$f":"IFERROR(VLOOKUP($B22,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B23,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B24,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B25,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B26,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
[{"$f":"IFERROR(VLOOKUP($B27,RECAPITULATIF!$A$4:$B$152,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,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]
["TOTAUX",null,{"$f":"SUM(C5:C27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH5:AH27)","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," "]