{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Synthèse réservation","Gestion Mot DE Passe","GestionLISTE","Menu","LV 5","Tx Location","Cadre","Couleurs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":340,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Synthèse réservation","index":0,"n_rows":11,"n_cols":28,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["N° ID","N° de facture","Date d'enregistrement de la réservation","Heure d'enregistrement de la réservation","Nom Locataire","Prix de la Location","Nombre de nuitées","Date arrivée","Heure arrivée","Date départ","Heure départ","Date début mois arrivée","Durée réservation","Nombre d'accompagnants","Nombre d'usagers","Nombre Total de personnes","Adresse","Code postal","Ville","Téléphone 1","Téléphone 2","Adresse mail","Total à payer","Avance Paiement","Reste à payer","Payé","Commentaires","Liens documents attachés"]
[1,"MAS Baraqueville_00000001","01/03/2018","","AB 4",120,"","2018-03-16","08:00:00","2018-03-16","15:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":0.29166666666424135},"2","0","2","Avenue La Grande Rue","22 130","PONT ARCY","01-02-03-04-05","06-07-08-09-10","oriaule-tephane@wanadoo.fr",250,250,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},"Il ne vient pas pour s'amuser. Il demande à être tranquille.","C:\\Users\\entretien\\Documents\\a garder.txt"]
[2,"MAS Baraqueville_00000002","01/03/2018","","redge",120,"","2018-03-18","08:00:00","2018-03-18","15:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":0.29166666666424135},"2","","2","","","","","","",200,200,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},"efggeg"]
[3,"MAS Baraqueville_00000003","01/03/2018","","rrrrr",120,"","2018-03-20","08:00:00","2018-03-20","15:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":0.29166666666424135},"2","","2","","","","","","",200,200,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},""]
[4,"MAS Baraqueville_00000004","21/03/2018","10:56","redge",120,"5","2018-03-22","08:00:00","2018-03-22","10:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":8.3333333328482695E-2},"2","3","4","impasse des peupliers","12450","La primaube","565701965","781895787","reglaet@free.fr",100,100,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},"rerererere"]
[5,"MAS Baraqueville_00000005","2018-03-21","11:09:00","redge",120,null,"2018-03-28","08:00:00","2018-03-28","09:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":4.1666666664241347E-2},2,null,null,null,null,null,null,null,"",100,20,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":80},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":0},"ooo"]
[6,"MAS Baraqueville_00000006","21/03/2018","22:00","redge",120,"","2018-03-30","14:00:00","2018-03-30","17:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":0.125},"2","","","ttrrt","","","","","",100,100,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},"trtrt"]
[7,"MAS Baraqueville_00000007","23/03/2018","10:38","redge",null,"","2018-03-23","08:00:00","2018-03-23","10:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":8.3333333328482695E-2},"","","","eee","","","","","",150,0,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":150},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":0},"eeee"]
[8,"MAS Baraqueville_00000008","23/03/2018","14:32","ALET-AUREJAC Nadine",null,"","2018-03-30","21:00:00","2018-03-31","22:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":1.0416666666642413},"15","12","27","","","","","","",150,20,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":130},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":0},"vvfvf"]
[9,"MAS Baraqueville_00000009","23/03/2018","15:20","redge",null,"","2018-03-29","08:00:00","2018-03-29","09:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":4.1666666664241347E-2},"","","","","","","","","",200,0,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":200},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":0},"",""]
[10,"MAS Baraqueville_00000010","23/03/2018","15:22","redge",null,"","2018-03-24","08:00:00","2018-03-24","09:00:00",{"$f":"BD[[#This Row],[Date arrivée]]-DAY(BD[[#This Row],[Date arrivée]])+1","v":"2018-03-01"},{"$f":"BD[[#This Row],[Date départ]]+BD[[#This Row],[Heure départ]]-(BD[[#This Row],[Date arrivée]]+BD[[#This Row],[Heure arrivée]])","v":4.1666666664241347E-2},"","","","","","","","","",100,100,{"$f":"BD[[#This Row],[Total à payer]]-BD[[#This Row],[Avance Paiement]]","v":0},{"$f":"IF(BD[[#This Row],[Reste à payer]]>0,0,1)","v":1},"",""]

{"sheet":"Gestion Mot DE Passe","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Users","Passworld","Niveau","Date"]
["Users","Passworld","Niveau","Date"]
["reservation LV5","titi",1,"2016-02-02"]

{"sheet":"GestionLISTE","index":2,"n_rows":99,"n_cols":19,"rows_kept":99,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["Paramètre GMAO",null,null,null,"Liste Véhicule","Liste Personnel",null,"Liste de Fonction",null,"Liste Lieu de Vie",null,"Heure de Départ ou de Retour",null,"Liste Résidents",null,{"$f":"YEAR(TODAY())","v":2018},null,null,"Chemin pour sauvegarde auto"]
["Couleur de fond des userform Valeurs RGB",96,138,195,"LV 5","redge",null,"AMP",null,"LV 1",null,"00:15:00.288",null,null,null,{"$f":"DATE(P2,1,1)","v":"2018-01-01"},"1er  Janvier"]
[null,null,null,null,null,null,null,"AS",null,"LV 2",null,"00:29:59.712",null,null,null,{"$f":"ROUND(DATE(P2,4,MOD(234-11*MOD(P2,19),30))/7,)*7-6","v":"2018-04-01"},"Pâques"]
["Sauvegarde pour multi utilisateur 1=Yes 2=No",1,null,null,null,null,null,"COORDINATRICE ",null,"LV 3",null,"00:45:00",null,null,null,{"$f":"SUM(P4+1)","v":"2018-04-02"},"Lundi de Pâques"]
[null,null,null,null,null,null,null,"COORDINATRICE SOINS",null,"LV 4",null,"01:00:00.288",null,null,null,{"$f":"DATE(P2,5,1)","v":"2018-05-01"},"1er  Mai"]
["Liste intervenant",2,null,null,null,null,null,"IDE",null,"LV 5",null,"01:14:59.712",null,null,null,{"$f":"DATE(P2,5,8)","v":"2018-05-08"}," 8 Mai Victoire 1945"]
[null,null,null,null,null,null,null,"REMPLACANTE",null,null,null,"01:30:00",null,null,null,{"$f":"P4+39","v":"2018-05-10"},"Jeudi de l'Ascension"]
["blocage des touches 1= ok , autres = noOk","No",null,null,null,null,null,"AGENT D'ENTRETIEN",null,null,null,"01:45:00.288",null,null,null,{"$f":"P4+49","v":"2018-05-20"},"Pentecôte"]
["date de la dernière purge du fichier synthèse","2018-01-12",null,null,null,null,null,"COMPTABLE",null,null,null,"01:59:59.712",null,null,null,{"$f":"SUM(P9+1)","v":"2018-05-21"},"Lundi de Pentecôte"]
["Dernière mise à jour date","2018-03-01",null,null,null,null,null,"CHEF DE SERVICE",null,null,null,"02:15:00",null,null,null,{"$f":"DATE(P2,7,14)","v":"2018-07-14"},"Fête Nationale France"]
["Durée Maxi du prêt",360,null,null,null,null,null,"DIRECTEUR",null,null,null,"02:30:00.288",null,null,null,{"$f":"DATE(P2,8,15)","v":"2018-08-15"},"Assomption"]
["Préfix Facture",null,null,null,null,null,null,"SECRETARIAT",null,null,null,"02:44:59.712",null,null,null,{"$f":"DATE(P2,11,1)","v":"2018-11-01"},"Toussaint"]
["MAS Baraqueville_",null,null,null,null,null,null,null,null,null,null,"03:00:00",null,null,null,{"$f":"DATE(P2,11,11)","v":"2018-11-11"},"Armistice 1918"]
["Sufixe monnaie",null,null,null,null,null,null,null,null,null,null,"03:15:00.288",null,null,null,{"$f":"DATE(P2,12,25)","v":"2018-12-25"},"Noël"]
[" €",null,null,null,null,null,null,null,null,null,null,"03:29:59.712"]
["N° Réservation",null,null,null,null,null,null,null,null,null,null,"03:45:00"]
[{"$f":"MAX(BD[N° ID])","v":10},null,null,null,null,null,null,null,null,null,null,"04:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"04:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"04:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"04:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"04:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"05:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"05:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"05:44:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"06:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"06:15:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"06:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"06:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"07:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"07:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"07:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"07:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"07:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"08:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"08:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"08:44:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"09:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"09:15:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"09:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"09:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"10:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"10:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"10:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"10:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"10:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"11:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"11:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"11:44:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"12:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"12:15:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"12:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"12:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"13:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"13:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"13:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"13:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"13:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"14:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"14:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"14:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"15:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"15:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"15:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"15:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"16:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"16:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"16:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"16:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"16:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"17:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"17:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"17:44:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"18:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"18:15:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"18:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"18:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"19:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"19:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"19:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"19:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"19:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"20:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"20:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"20:44:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"21:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"21:15:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"21:29:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"21:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,"22:00:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"22:14:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"22:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,"22:45:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"22:59:59.712"]
[null,null,null,null,null,null,null,null,null,null,null,"23:15:00"]
[null,null,null,null,null,null,null,null,null,null,null,"23:30:00.288"]
[null,null,null,null,null,null,null,null,null,null,null,"23:45:00"]
[null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"     "]

{"sheet":"Menu","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,4,5,8]]}
[]
[]
[]
[]
[]
[null,null,null,null,"Nombre de Séjours en cours de paiement",null,null,null,null,{"$f":"COUNTIF(BD[Payé],0)","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
["                                             "]

{"sheet":"LV 5","index":4,"n_rows":739,"n_cols":97,"rows_kept":739,"cut":false,"hidden":false,"merged":[[0,0,0,36]]}
["RESERVATION LV 5"]
["Retour Menu"]
[null,"00:00:00","00:15:00.288","00:29:59.712","00:45:00","01:00:00.288","01:14:59.712","01:30:00","01:45:00.288","01:59:59.712","02:15:00","02:30:00.288","02:44:59.712","03:00:00","03:15:00.288","03:29:59.712","03:45:00","04:00:00.288","04:14:59.712","04:30:00","04:45:00.288","04:59:59.712","05:15:00","05:30:00.288","05:44:59.712","06:00:00","06:15:00.288","06:29:59.712","06:45:00","07:00:00.288","07:14:59.712","07:30:00","07:45:00.288","07:59:59.712","08:15:00","08:30:00.288","08:44:59.712","09:00:00","09:15:00.288","09:29:59.712","09:45:00","10:00:00.288","10:14:59.712","10:30:00","10:45:00.288","10:59:59.712","11:15:00","11:30:00.288","11:44:59.712","12:00:00","12:15:00.288","12:29:59.712","12:45:00","13:00:00.288","13:14:59.712","13:30:00","13:45:00.288","13:59:59.712","14:15:00","14:30:00.288","14:44:59.712","15:00:00","15:15:00.288","15:29:59.712","15:45:00","16:00:00.288","16:14:59.712","16:30:00","16:45:00.288","16:59:59.712","17:15:00","17:30:00.288","17:44:59.712","18:00:00","18:15:00.288","18:29:59.712","18:45:00","19:00:00.288","19:14:59.712","19:30:00","19:45:00.288","19:59:59.712","20:15:00","20:30:00.288","20:44:59.712","21:00:00","21:15:00.288","21:29:59.712","21:45:00","22:00:00.288","22:14:59.712","22:30:00","22:45:00.288","22:59:59.712","23:15:00","23:30:00.288","23:44:59.712"]
["2018-03-01"]
[{"$f":"A4+1","v":"2018-03-02"}]
["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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB 4"]
["2018-03-17"]
["2018-03-18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-19"]
["2018-03-20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rrrrr"]
["2018-03-21"]
["2018-03-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-25"]
["2018-03-26"]
["2018-03-27"]
["2018-03-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge"]
["2018-03-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"redge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALET-AUREJAC Nadine"]
["2018-03-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALET-AUREJAC Nadine"]
["2018-04-01"]
["2018-04-02"]
["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"]
["2018-05-02"]
["2018-05-03"]
["2018-05-04"]
[{"$f":"A68+1","v":"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"]
["2018-06-01"]
["2018-06-02"]
["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"]
["2018-07-02"]
["2018-07-03"]
["2018-07-04"]
["2018-07-05"]
["2018-07-06"]
["2018-07-07"]
[{"$f":"A132+1","v":"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"]
["2018-08-01"]
["2018-08-02"]
["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"]
["2018-09-01"]
["2018-09-02"]
["2018-09-03"]
["2018-09-04"]
["2018-09-05"]
["2018-09-06"]
["2018-09-07"]
["2018-09-08"]
["2018-09-09"]
[{"$f":"A196+1","v":"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"]
["2018-10-02"]
["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"]
["2018-11-01"]
["2018-11-02"]
["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"]
[{"$f":"A260+1","v":"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"]
["2018-12-02"]
["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"]
["2019-01-01"]
["2019-01-02"]
["2019-01-03"]
["2019-01-04"]
["2019-01-05"]
["2019-01-06"]
["2019-01-07"]
["2019-01-08"]
["2019-01-09"]
["2019-01-10"]
["2019-01-11"]
["2019-01-12"]
["2019-01-13"]
["2019-01-14"]
["2019-01-15"]
[{"$f":"A324+1","v":"2019-01-16"}]
["2019-01-17"]
["2019-01-18"]
["2019-01-19"]
["2019-01-20"]
["2019-01-21"]
["2019-01-22"]
["2019-01-23"]
["2019-01-24"]
["2019-01-25"]
["2019-01-26"]
["2019-01-27"]
["2019-01-28"]
["2019-01-29"]
["2019-01-30"]
["2019-01-31"]
["2019-02-01"]
["2019-02-02"]
["2019-02-03"]
["2019-02-04"]
["2019-02-05"]
["2019-02-06"]
["2019-02-07"]
["2019-02-08"]
["2019-02-09"]
["2019-02-10"]
["2019-02-11"]
["2019-02-12"]
["2019-02-13"]
["2019-02-14"]
["2019-02-15"]
["2019-02-16"]
["2019-02-17"]
["2019-02-18"]
["2019-02-19"]
["2019-02-20"]
["2019-02-21"]
["2019-02-22"]
["2019-02-23"]
["2019-02-24"]
["2019-02-25"]
["2019-02-26"]
["2019-02-27"]
["2019-02-28"]
["2019-03-01"]
["2019-03-02"]
["2019-03-03"]
["2019-03-04"]
["2019-03-05"]
["2019-03-06"]
["2019-03-07"]
["2019-03-08"]
["2019-03-09"]
["2019-03-10"]
["2019-03-11"]
["2019-03-12"]
["2019-03-13"]
["2019-03-14"]
["2019-03-15"]
["2019-03-16"]
["2019-03-17"]
["2019-03-18"]
["2019-03-19"]
["2019-03-20"]
[{"$f":"A388+1","v":"2019-03-21"}]
["2019-03-22"]
["2019-03-23"]
["2019-03-24"]
["2019-03-25"]
["2019-03-26"]
["2019-03-27"]
["2019-03-28"]
["2019-03-29"]
["2019-03-30"]
["2019-03-31"]
["2019-04-01"]
["2019-04-02"]
["2019-04-03"]
["2019-04-04"]
["2019-04-05"]
["2019-04-06"]
["2019-04-07"]
["2019-04-08"]
["2019-04-09"]
["2019-04-10"]
["2019-04-11"]
["2019-04-12"]
["2019-04-13"]
["2019-04-14"]
["2019-04-15"]
["2019-04-16"]
["2019-04-17"]
["2019-04-18"]
["2019-04-19"]
["2019-04-20"]
["2019-04-21"]
["2019-04-22"]
["2019-04-23"]
["2019-04-24"]
["2019-04-25"]
["2019-04-26"]
["2019-04-27"]
["2019-04-28"]
["2019-04-29"]
["2019-04-30"]
["2019-05-01"]
["2019-05-02"]
["2019-05-03"]
["2019-05-04"]
["2019-05-05"]
["2019-05-06"]
["2019-05-07"]
["2019-05-08"]
["2019-05-09"]
["2019-05-10"]
["2019-05-11"]
["2019-05-12"]
["2019-05-13"]
["2019-05-14"]
["2019-05-15"]
["2019-05-16"]
["2019-05-17"]
["2019-05-18"]
["2019-05-19"]
["2019-05-20"]
["2019-05-21"]
["2019-05-22"]
["2019-05-23"]
[{"$f":"A452+1","v":"2019-05-24"}]
["2019-05-25"]
["2019-05-26"]
["2019-05-27"]
["2019-05-28"]
["2019-05-29"]
["2019-05-30"]
["2019-05-31"]
["2019-06-01"]
["2019-06-02"]
["2019-06-03"]
["2019-06-04"]
["2019-06-05"]
["2019-06-06"]
["2019-06-07"]
["2019-06-08"]
["2019-06-09"]
["2019-06-10"]
["2019-06-11"]
["2019-06-12"]
["2019-06-13"]
["2019-06-14"]
["2019-06-15"]
["2019-06-16"]
["2019-06-17"]
["2019-06-18"]
["2019-06-19"]
["2019-06-20"]
["2019-06-21"]
["2019-06-22"]
["2019-06-23"]
["2019-06-24"]
["2019-06-25"]
["2019-06-26"]
["2019-06-27"]
["2019-06-28"]
["2019-06-29"]
["2019-06-30"]
["2019-07-01"]
["2019-07-02"]
["2019-07-03"]
["2019-07-04"]
["2019-07-05"]
["2019-07-06"]
["2019-07-07"]
["2019-07-08"]
["2019-07-09"]
["2019-07-10"]
["2019-07-11"]
["2019-07-12"]
["2019-07-13"]
["2019-07-14"]
["2019-07-15"]
["2019-07-16"]
["2019-07-17"]
["2019-07-18"]
["2019-07-19"]
["2019-07-20"]
["2019-07-21"]
["2019-07-22"]
["2019-07-23"]
["2019-07-24"]
["2019-07-25"]
["2019-07-26"]
[{"$f":"A516+1","v":"2019-07-27"}]
["2019-07-28"]
["2019-07-29"]
["2019-07-30"]
["2019-07-31"]
["2019-08-01"]
["2019-08-02"]
["2019-08-03"]
["2019-08-04"]
["2019-08-05"]
["2019-08-06"]
["2019-08-07"]
["2019-08-08"]
["2019-08-09"]
["2019-08-10"]
["2019-08-11"]
["2019-08-12"]
["2019-08-13"]
["2019-08-14"]
["2019-08-15"]
["2019-08-16"]
["2019-08-17"]
["2019-08-18"]
["2019-08-19"]
["2019-08-20"]
["2019-08-21"]
["2019-08-22"]
["2019-08-23"]
["2019-08-24"]
["2019-08-25"]
["2019-08-26"]
["2019-08-27"]
["2019-08-28"]
["2019-08-29"]
["2019-08-30"]
["2019-08-31"]
["2019-09-01"]
["2019-09-02"]
["2019-09-03"]
["2019-09-04"]
["2019-09-05"]
["2019-09-06"]
["2019-09-07"]
["2019-09-08"]
["2019-09-09"]
["2019-09-10"]
["2019-09-11"]
["2019-09-12"]
["2019-09-13"]
["2019-09-14"]
["2019-09-15"]
["2019-09-16"]
["2019-09-17"]
["2019-09-18"]
["2019-09-19"]
["2019-09-20"]
["2019-09-21"]
["2019-09-22"]
["2019-09-23"]
["2019-09-24"]
["2019-09-25"]
["2019-09-26"]
["2019-09-27"]
["2019-09-28"]
[{"$f":"A580+1","v":"2019-09-29"}]
["2019-09-30"]
["2019-10-01"]
["2019-10-02"]
["2019-10-03"]
["2019-10-04"]
["2019-10-05"]
["2019-10-06"]
["2019-10-07"]
["2019-10-08"]
["2019-10-09"]
["2019-10-10"]
["2019-10-11"]
["2019-10-12"]
["2019-10-13"]
["2019-10-14"]
["2019-10-15"]
["2019-10-16"]
["2019-10-17"]
["2019-10-18"]
["2019-10-19"]
["2019-10-20"]
["2019-10-21"]
["2019-10-22"]
["2019-10-23"]
["2019-10-24"]
["2019-10-25"]
["2019-10-26"]
["2019-10-27"]
["2019-10-28"]
["2019-10-29"]
["2019-10-30"]
["2019-10-31"]
["2019-11-01"]
["2019-11-02"]
["2019-11-03"]
["2019-11-04"]
["2019-11-05"]
["2019-11-06"]
["2019-11-07"]
["2019-11-08"]
["2019-11-09"]
["2019-11-10"]
["2019-11-11"]
["2019-11-12"]
["2019-11-13"]
["2019-11-14"]
["2019-11-15"]
["2019-11-16"]
["2019-11-17"]
["2019-11-18"]
["2019-11-19"]
["2019-11-20"]
["2019-11-21"]
["2019-11-22"]
["2019-11-23"]
["2019-11-24"]
["2019-11-25"]
["2019-11-26"]
["2019-11-27"]
["2019-11-28"]
["2019-11-29"]
["2019-11-30"]
["2019-12-01"]
[{"$f":"A644+1","v":"2019-12-02"}]
["2019-12-03"]
["2019-12-04"]
["2019-12-05"]
["2019-12-06"]
["2019-12-07"]
["2019-12-08"]
["2019-12-09"]
["2019-12-10"]
["2019-12-11"]
["2019-12-12"]
["2019-12-13"]
["2019-12-14"]
["2019-12-15"]
["2019-12-16"]
["2019-12-17"]
["2019-12-18"]
["2019-12-19"]
["2019-12-20"]
["2019-12-21"]
["2019-12-22"]
["2019-12-23"]
["2019-12-24"]
["2019-12-25"]
["2019-12-26"]
["2019-12-27"]
["2019-12-28"]
["2019-12-29"]
["2019-12-30"]
["2019-12-31"]
["2020-01-01"]
["2020-01-02"]
["2020-01-03"]
["2020-01-04"]
["2020-01-05"]
["2020-01-06"]
["2020-01-07"]
["2020-01-08"]
["2020-01-09"]
["2020-01-10"]
["2020-01-11"]
["2020-01-12"]
["2020-01-13"]
["2020-01-14"]
["2020-01-15"]
["2020-01-16"]
["2020-01-17"]
["2020-01-18"]
["2020-01-19"]
["2020-01-20"]
["2020-01-21"]
["2020-01-22"]
["2020-01-23"]
["2020-01-24"]
["2020-01-25"]
["2020-01-26"]
["2020-01-27"]
["2020-01-28"]
["2020-01-29"]
["2020-01-30"]
["2020-01-31"]
["2020-02-01"]
["2020-02-02"]
["2020-02-03"]
[{"$f":"A708+1","v":"2020-02-04"}]
["2020-02-05"]
["2020-02-06"]
["2020-02-07"]
["2020-02-08"]
["2020-02-09"]
["2020-02-10"]
["2020-02-11"]
["2020-02-12"]
["2020-02-13"]
["2020-02-14"]
["2020-02-15"]
["2020-02-16"]
["2020-02-17"]
["2020-02-18"]
["2020-02-19"]
["2020-02-20"]
["2020-02-21"]
["2020-02-22"]
["2020-02-23"]
["2020-02-24"]
["2020-02-25"]
["2020-02-26"]
["2020-02-27"]
["2020-02-28"]
["2020-02-29"]
["2020-03-01"]
["2020-03-02"]
["2020-03-03"]
["2020-03-04"]
["2020-03-05"]

{"sheet":"Tx Location","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Mois"," Durée location","nb jours","Tx occupation"]
["2018-03-01",2.3333333333066548,{"$f":"VALUE(TEXT(EOMONTH(EDATE(0,MONTH(A4)),0),\"JJ\"))","v":31},{"$f":"B4/C4","v":7.5268817203440475E-2}]
["Total général",2.3333333333066548]

{"sheet":"Cadre","index":6,"n_rows":3,"n_cols":97,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,36]]}
["RESERVATION"]
["Retour Menu"]
[null,"00:00:00","00:15:00.288","00:29:59.712","00:45:00","01:00:00.288","01:14:59.712","01:30:00","01:45:00.288","01:59:59.712","02:15:00","02:30:00.288","02:44:59.712","03:00:00","03:15:00.288","03:29:59.712","03:45:00","04:00:00.288","04:14:59.712","04:30:00","04:45:00.288","04:59:59.712","05:15:00","05:30:00.288","05:44:59.712","06:00:00","06:15:00.288","06:29:59.712","06:45:00","07:00:00.288","07:14:59.712","07:30:00","07:45:00.288","07:59:59.712","08:15:00","08:30:00.288","08:44:59.712","09:00:00","09:15:00.288","09:29:59.712","09:45:00","10:00:00.288","10:14:59.712","10:30:00","10:45:00.288","10:59:59.712","11:15:00","11:30:00.288","11:44:59.712","12:00:00","12:15:00.288","12:29:59.712","12:45:00","13:00:00.288","13:14:59.712","13:30:00","13:45:00.288","13:59:59.712","14:15:00","14:30:00.288","14:44:59.712","15:00:00","15:15:00.288","15:29:59.712","15:45:00","16:00:00.288","16:14:59.712","16:30:00","16:45:00.288","16:59:59.712","17:15:00","17:30:00.288","17:44:59.712","18:00:00","18:15:00.288","18:29:59.712","18:45:00","19:00:00.288","19:14:59.712","19:30:00","19:45:00.288","19:59:59.712","20:15:00","20:30:00.288","20:44:59.712","21:00:00","21:15:00.288","21:29:59.712","21:45:00","22:00:00.288","22:14:59.712","22:30:00","22:45:00.288","22:59:59.712","23:15:00","23:30:00.288","23:44:59.712"]

{"sheet":"Couleurs","index":7,"n_rows":57,"n_cols":2,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Colorindex"]
[null,{"$f":"indice_couleur(A2)","v":1}]
[null,{"$f":"indice_couleur(A3)","v":2}]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]