{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SAISIE","TABLEAU","Données","Objectif"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"SAISIE","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,8,9,10],[10,8,11,10],[12,8,14,10],[37,0,37,6],[38,0,38,6],[9,0,9,1],[10,0,10,1],[12,2,12,3],[11,2,11,3],[13,2,13,3],[12,0,12,1],[26,0,26,1],[24,2,24,6],[25,2,25,6],[21,2,21,6],[22,2,22,6],[39,0,39,6],[5,7,6,7],[15,7,26,9],[29,7,33,9],[34,0,35,6],[11,0,11,1],[13,0,13,1],[14,0,14,1],[29,0,29,6],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[15,2,16,6],[9,2,9,3],[10,2,10,3],[0,0,1,6],[3,0,4,1],[5,0,6,1],[5,4,6,5],[36,0,36,6],[3,3,4,6],[5,3,6,3],[7,2,8,3],[7,0,8,1],[3,2,4,2],[5,2,6,2],[5,6,6,6],[7,4,8,4],[7,5,8,5],[14,2,14,3],[15,0,16,1],[24,0,24,1],[25,0,25,1],[20,2,20,6],[17,0,17,1],[19,0,19,1],[7,6,8,6],[7,7,8,7],[27,0,27,1],[28,0,28,1],[17,2,17,6],[18,2,18,6],[19,2,19,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[18,0,18,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[23,2,23,6]]}
["Saisie tableau de bords"]
[]
[]
["Nombre de chambre vendu",null,54,"Nombre de chambres vendu le jour de la cloture"]
[]
["Nombre d'arrivée",null,14,"Arrivée J+1","Nombre départ",null,18,"départ j+1"]
[]
["No show",null,"Montant Facturé",null,"Type (débiteur, rsp, nanr)","Statut (CP, arrivée repportée, Annulée)","Durée Séjour","Total séjour","- Montant facturé = Montant réellement débiter (charger une nuit pour les tarifs BAR)"]
[]
["prahalad Shubra",null,60,null,"nanr","in (306)",1,60]
["TIWARI",null,0,null,"BAR","Reportée",8,504,"- Durée séjour = durée total du séjour en nuit"]
["GOVARDANA",null,0,null,"BAR","Reportée",8,504]
[null,null,null,null,null,null,null,null,"- Total séjour = montant total du séjour"]
[]
[]
["Chambres hors service",null,"Raison",null,null,null,null,"Chambres hors service sur protel. Donner la raison"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Chiffre d'affaire",null,null,null,null,null,null,"Chiffre d'affaire jour de cloture trouvé dans le rapport \"après CM / C.A J/M/A vs bdgt N-1 HT\""]
["Hébergement",null,2750.51]
["Petit dejeuner",null,227.5]
["Parking",null,50]
["Divers",null,10]
["Commentaire"]

{"sheet":"TABLEAU","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,0,7,0],[6,5,7,5],[9,5,10,5],[31,1,31,2],[32,1,32,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[22,0,22,1],[47,0,48,2],[47,3,48,5],[46,0,46,2],[46,3,46,5],[33,1,33,2],[34,1,34,2],[37,0,38,5],[39,0,40,5],[41,0,42,5],[43,0,44,5],[0,0,1,5],[2,0,3,5],[26,0,27,5],[36,0,36,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[28,4,28,5],[6,2,7,2],[5,2,5,4],[23,4,24,4],[20,0,21,5],[23,3,24,3]]}
["Tableau de bord - Neuilly bords de marne"]
[]
[{"$f":"TODAY()-1","v":"2018-01-20"}]
[]
[]
["Chambres vendu",null,"Chiffre d'affaire H.T.du jour",null,null,"Prix moyen Heberg."]
[{"$f":"SAISIE!C4","v":54},null,{"$f":"SUM(SAISIE!C31:G34)","v":3038.01},"Dont Hébergement",{"$f":"SUM(SAISIE!C31:G31)","v":2750.51},{"$f":"E7/A7","v":50.935370370370372}]
[null,null,null,"Petit déjeuner",{"$f":"SUM(SAISIE!C32:G32)","v":227.5}]
[null,null,null,null,null,"T. O."]
["Chambres Bloquées","Hors-Service","No show","Libre propre",null,{"$f":"(A7+B11)/(65-A11)","v":0.83076923076923082}]
[0,{"$f":"COUNTA(SAISIE!A18:B29)","v":0},{"$f":"COUNTA(SAISIE!A10:B15)","v":3},{"$f":"65-(A7+A11+B11)","v":11}]
[]
["No Show","Type","Statut","Montant Facturé","Durée Séjour","Total séjour"]
[{"$f":"SAISIE!A10","v":"prahalad Shubra"},{"$f":"SAISIE!E10","v":"nanr"},{"$f":"SAISIE!F10","v":"in (306)"},{"$f":"SAISIE!C10","v":60},{"$f":"SAISIE!G10 & \" Nuit(s)\"","v":"1 Nuit(s)"},{"$f":"SAISIE!H10","v":60}]
[{"$f":"SAISIE!A11","v":"TIWARI"},{"$f":"SAISIE!E11","v":"BAR"},{"$f":"SAISIE!F11","v":"Reportée"},{"$f":"SAISIE!C11","v":0},{"$f":"SAISIE!G11 & \" Nuit(s)\"","v":"8 Nuit(s)"},{"$f":"SAISIE!H11","v":504}]
[{"$f":"SAISIE!A12","v":"GOVARDANA"},{"$f":"SAISIE!E12","v":"BAR"},{"$f":"SAISIE!F12","v":"Reportée"},{"$f":"SAISIE!C12","v":0},{"$f":"SAISIE!G12 & \" Nuit(s)\"","v":"8 Nuit(s)"},{"$f":"SAISIE!H12","v":504}]
[{"$f":"SAISIE!A13","v":0},{"$f":"SAISIE!E13","v":0},{"$f":"SAISIE!F13","v":0},{"$f":"SAISIE!C13","v":0},{"$f":"SAISIE!G13 & \" Nuit(s)\"","v":" Nuit(s)"},{"$f":"SAISIE!H13","v":0}]
[{"$f":"SAISIE!A14","v":0},{"$f":"SAISIE!E14","v":0},{"$f":"SAISIE!F14","v":0},{"$f":"SAISIE!C14","v":0},{"$f":"SAISIE!G14 & \" Nuit(s)\"","v":" Nuit(s)"},{"$f":"SAISIE!H14","v":0}]
[{"$f":"SAISIE!A15","v":0},{"$f":"SAISIE!E15","v":0},{"$f":"SAISIE!F15","v":0},{"$f":"SAISIE!C15","v":0},{"$f":"SAISIE!G15 & \" Nuit(s)\"","v":" Nuit(s)"},{"$f":"SAISIE!H15","v":0}]
[]
[{"$f":"TODAY()","v":"2018-01-21"}]
[]
["Previsionnel du jour",null,null,"Occupation prévu","Chambre libre"]
["Nombre de départs",{"$f":"SAISIE!G6","v":18},null,{"$f":"(A7-B24+B25)","v":50},{"$f":"(65-A11-B11)-D24","v":15}]
["Nombre d'arrivées",{"$f":"SAISIE!C6","v":14}]
[]
["Hors services"]
[]
["Chambre","Raison",null,"Chambre","Raison"]
[{"$f":"SAISIE!A18","v":0},{"$f":"SAISIE!C18","v":0},null,{"$f":"SAISIE!A24","v":0},{"$f":"SAISIE!C24","v":0}]
[{"$f":"SAISIE!A19","v":0},{"$f":"SAISIE!C19","v":0},null,{"$f":"SAISIE!A25","v":0},{"$f":"SAISIE!C25","v":0}]
[{"$f":"SAISIE!A20","v":0},{"$f":"SAISIE!C20","v":0},null,{"$f":"SAISIE!A26","v":0},{"$f":"SAISIE!C26","v":0}]
[{"$f":"SAISIE!A21","v":0},{"$f":"SAISIE!C21","v":0},null,{"$f":"SAISIE!A27","v":0},{"$f":"SAISIE!C27","v":0}]
[{"$f":"SAISIE!A22","v":0},{"$f":"SAISIE!C22","v":0},null,{"$f":"SAISIE!A28","v":0},{"$f":"SAISIE!C28","v":0}]
[{"$f":"SAISIE!A23","v":0},{"$f":"SAISIE!C23","v":0},null,{"$f":"SAISIE!A29","v":0},{"$f":"SAISIE!C29","v":0}]
[]
["Observations:"]
[{"$f":"SAISIE!A37","v":0}]
[]
[{"$f":"SAISIE!A38","v":0}]
[]
[{"$f":"SAISIE!A39","v":0}]
[]
[{"$f":"SAISIE!A40","v":0}]
[]
[]
["Validation Réception:",null,null,"Validation responsable:"]

{"sheet":"Données","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Objectif","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,6]]}
["Objectif 2018"]
[]
[]
[null,"Janvier",100000]
[null,"Février",100000]
[null,"Mars",100000]
[null,"Avril",100000]
[null,"Mai",100000]
[null,"Juin",100000]
[null,"Juillet",100000]
[null,"Août",100000]
[null,"Septembre",100000]
[null,"Octobre",100000]
[null,"Novembre",100000]
[null,"Décembre",100000]
[]
[null,"Total",{"$f":"SUM(C4:C15)","v":1200000}]