{"text_format":"1","workbook":"xlsx","n_sheets":36,"sheets":["Overview","Instructions","TMS_OCC","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","AUDIT","SYS"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":33,"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":"Overview","index":0,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[[45,7,45,8],[6,1,6,8],[1,1,1,8],[61,20,62,20],[61,21,62,21],[61,19,62,19],[60,14,60,19],[61,12,62,12],[61,13,62,13],[61,18,62,18],[61,14,62,14],[61,15,62,15],[61,16,62,16],[61,17,62,17]]}
[]
[null,"Housekeeping Reconciliation - Monthly Overview"]
[]
[null,"Last Day of the Month",null,null,null,"2023-08-31"]
[null,"Rooms not cleaned last month"]
[]
[null,"HOTEL NAME"]
[]
[]
[null,"Cleaning Day","Weekday","Bank Holiday",null,"Rooms Cleaned",null,null,"Difference ",null,null,null,"Green Stay Rooms"]
[{"$f":"WEEKNUM(B11,2)","v":32},{"$f":"INDIRECT(\"'\"&ROW()-10&\"'!D8\")","v":"2023-08-01"},{"$f":"IF(D11=\"Y\",\"8\",WEEKDAY(B11,2))","v":2},"N",null,{"$f":"IF(MONTH($F$4)<>MONTH(B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D13\"))","v":0},null,null,{"$f":"IF(MONTH($F$4)<>MONTH(B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D51\"))","v":0},null,null,null,{"$f":"IF(MONTH($F$4)<>MONTH(B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D39\"))","v":0}]
[{"$f":"WEEKNUM(B12,2)","v":32},{"$f":"INDIRECT(\"'\"&ROW()-10&\"'!D8\")","v":"2023-08-02"},{"$f":"IF(D12=\"Y\",\"8\",WEEKDAY(B12,2))","v":3},"N",null,0,null,null,{"$f":"IF(MONTH($F$4)<>MONTH(B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D51\"))","v":0},null,null,null,{"$f":"IF(MONTH($F$4)<>MONTH(B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D39\"))","v":0}]
[32,"2023-08-03",4,"N",null,0,null,null,0,null,null,null,0]
[32,"2023-08-04",5,"N",null,0,null,null,0,null,null,null,0]
[32,"2023-08-05",6,"N",null,0,null,null,0,null,null,null,0]
[32,"2023-08-06",7,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-07",1,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-08",2,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-09",3,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-10",4,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-11",5,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-12",6,"N",null,0,null,null,0,null,null,null,0]
[33,"2023-08-13",7,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-14",1,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-15",2,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-16",3,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-17",4,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-18",5,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-19",6,"N",null,0,null,null,0,null,null,null,0]
[34,"2023-08-20",7,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-21",1,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-22",2,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-23",3,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-24",4,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-25",5,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-26",6,"N",null,0,null,null,0,null,null,null,0]
[35,"2023-08-27",7,"N",null,0,null,null,0,null,null,null,0]
[36,"2023-08-28",1,"N",null,0,null,null,0,null,null,null,0]
[36,"2023-08-29",2,"N",null,0,null,null,0,null,null,null,0]
[36,"2023-08-30",3,"N",null,0,null,null,0,null,null,null,0]
[36,"2023-08-31",4,"N",null,0,null,null,0,null,null,null,0]
[]
[null,null,null,null,{"$f":"CONCATENATE(\"Rooms to be invoiced \",E63,\":\")","v":"Rooms to be invoiced Mondays-Saturdays:"},{"$f":"+F46-F45-F44","v":0}]
[null,null,null,null,{"$f":"IF(F63<>\"\",CONCATENATE(\"Rooms to be invoiced \",F63,\":\"),\"\")","v":"Rooms to be invoiced Sundays Only:"},{"$f":"IF(F70=\"\",0,F70)","v":0}]
[null,null,null,null,{"$f":"IF(G63<>\"\",CONCATENATE(\"Rooms to be invoiced \",G63,\":\"),\"\")","v":"Rooms to be invoiced Bank Holidays:"},{"$f":"IF(G70=\"\",0,G70)","v":0}]
[null,null,null,null,"Rooms to be invoiced:",{"$f":"IF(B41=F4,SUM(F11:F41),IF(B40=F4,SUM(F11:F40),IF(B39=F4,SUM(F11:F39),IF(B38=F4,SUM(F11:F38),\"INCORRECT DATES\"))))","v":0},null,{"$f":"IF(SUM(I11:I41)=0,\"OK\",\"CHECK\")","v":"OK"}]
[]
[null,null,null,null,"Green Stay Rooms (not cleaned):",{"$f":"IF(B41=F4,SUM(M11:M41),IF(B40=F4,SUM(M11:M40),IF(B39=F4,SUM(M11:M39),IF(B38=F4,SUM(M11:M38),\"INCORRECT DATES\"))))","v":0}]
[]
[null,null,null,null,"Rooms to be cleaned next month:",{"$f":"INDIRECT(\"AUDIT!AD\" & 10 +DAY(F4))","v":0}]
[]
[null,"Approved by Housekeeping Manager",null,null,null,null,"Approved by Hotel Director"]
[]
[]
[]
[]
[]
[]
[null,"Bank Holiday price is",null,null,null,null,"Separate price"]
[null,{"$f":"IF(G59=\"Flat Rate\",\"\",\"Weekend price applies to\")","v":"Weekend price applies to"},null,null,null,null,"Sundays Only",{"$f":"IF(G60=\"\",IF(G59<>\"Flat rate\",\"Weekend price applies to has to be completed\",\"\"),\"\")","v":""}]
[]
[null,"Breakdown Weekly invoicing",null,null,null,null,null,null,null,null,null,null,"Total","Mondays-Sundays","Mondays-Saturdays","Mondays-Fridays","Sundays Only","Saturdays","Saturdays & Sundays","Bank Holidays","Sundays & Bank Holidays","Saturdays & Sundays & Bank Holidays"]
[null,null,null,null,{"$f":"IF(G59=\"Flat rate\",\"Mondays-Sundays\",IF(G60=\"Sundays Only\",\"Mondays-Saturdays\",\"Mondays-Fridays\"))","v":"Mondays-Saturdays"},{"$f":"IF(G59=\"Flat rate\",\"\",IF(G59=\"Same as weekend\",IF(G60=\"Sundays only\",\"Sundays & Bank Holidays\",\"Saturdays & Sundays & Bank Holidays\"),G60))","v":"Sundays Only"},{"$f":"IF(G59=\"Separate price\",\"Bank Holidays\",\"\")","v":"Bank Holidays"},null,"Total"]
[null,1,null,{"$f":"IF(B64>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13))","v":"Week 32"},{"$f":"HLOOKUP(E$63,$N$62:$W$76,$L64,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(F$63,$N$62:$W$76,$L64,FALSE),\"\")","v":0},{"$f":"IFERROR(HLOOKUP(G$63,$N$62:$W$76,$L64,FALSE),\"\")","v":0},null,{"$f":"SUM(E64:G64)","v":0},null,null,3,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"=6\")","v":0},{"$f":"Q64+R64","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C17,$C$11:$C$41,\"=8\")","v":0},{"$f":"Q64+T64","v":0},{"$f":"S64+T64","v":0}]
[null,{"$f":"+B64+1","v":2},null,{"$f":"IF(B65>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13+1))","v":"Week 33"},0,{"$f":"IFERROR(HLOOKUP(F$63,$N$62:$W$76,$L65,FALSE),\"\")","v":0},{"$f":"IFERROR(HLOOKUP(G$63,$N$62:$W$76,$L65,FALSE),\"\")","v":0},null,{"$f":"SUM(E65:G65)","v":0},null,null,{"$f":"+L64+1","v":4},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"=6\")","v":0},{"$f":"Q65+R65","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C18,$C$11:$C$41,\"=8\")","v":0},{"$f":"Q65+T65","v":0},{"$f":"S65+T65","v":0}]
[null,{"$f":"+B65+1","v":3},null,{"$f":"IF(B66>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13+2))","v":"Week 34"},0,0,0,null,0,null,null,{"$f":"+L65+1","v":5},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"=6\")","v":0},0,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C19,$C$11:$C$41,\"=8\")","v":0},0,0]
[null,{"$f":"+B66+1","v":4},null,{"$f":"IF(B67>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13+3))","v":"Week 35"},0,0,0,null,0,null,null,6,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"=6\")","v":0},0,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C20,$C$11:$C$41,\"=8\")","v":0},0,0]
[null,{"$f":"+B67+1","v":5},null,{"$f":"IF(B68>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13+4))","v":"Week 36"},0,0,0,null,0,null,null,7,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"=6\")","v":0},0,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C21,$C$11:$C$41,\"=8\")","v":0},0,0]
[null,{"$f":"+B68+1","v":6},null,{"$f":"IF(B69>SYS!$D$14,\"\",CONCATENATE(\"Week \",SYS!$C$13+5))","v":""},0,0,0,null,0,null,null,8,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"=6\")","v":0},0,{"$f":"SUMIFS($F$11:$F$41,$A$11:$A$41,SYS!$C22,$C$11:$C$41,\"=8\")","v":0},0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E64:E69)","v":0},{"$f":"IF(F63<>\"\",SUM(F64:F69),\"\")","v":0},{"$f":"IF(G63<>\"\",SUM(G64:G69),\"\")","v":0},null,{"$f":"SUM(I64:I69)","v":0},null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,11]
[null,"Breakdown Bi-Monthly invoicing",null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,{"$f":"E63","v":"Mondays-Saturdays"},{"$f":"F63","v":"Sundays Only"},{"$f":"G63","v":"Bank Holidays"},null,"Total",null,null,13]
[null,1,null,"1-15",{"$f":"IFERROR(HLOOKUP(E$63,$N$62:$W$76,$L75,FALSE),\"\")","v":0},{"$f":"IFERROR(HLOOKUP(F$63,$N$62:$W$76,$L75,FALSE),\"\")","v":0},{"$f":"IFERROR(HLOOKUP(G$63,$N$62:$W$76,$L75,FALSE),\"\")","v":0},null,{"$f":"SUM(E75:G75)","v":0},null,null,14,{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"<=8\")","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"<=7\")","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"<=6\")","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"<=5\")","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"=7\")","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"=6\")","v":0},{"$f":"Q75+R75","v":0},{"$f":"SUMIFS($F$11:$F$25,$C$11:$C$25,\"=8\")","v":0},{"$f":"Q75+T75","v":0},{"$f":"S75+T75","v":0}]
[null,{"$f":"+B75+1","v":2},null,{"$f":"CONCATENATE(\"16-\",DAY(F4))","v":"16-31"},{"$f":"IFERROR(HLOOKUP(E$63,$N$62:$W$76,$L76,FALSE),\"\")","v":0},0,0,null,0,null,null,15,{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"<=8\")","v":0},{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"<=7\")","v":0},{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"<=6\")","v":0},{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"<=5\")","v":0},{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"=7\")","v":0},{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"=6\")","v":0},0,{"$f":"SUMIFS($F$26:$F$41,$C$26:$C$41,\"=8\")","v":0},0,0]
[null,null,null,"TOTAL",{"$f":"SUM(E75:E76)","v":0},{"$f":"IF(F74<>\"\",SUM(F75:F76),\"\")","v":0},{"$f":"IF(G74<>\"\",SUM(G75:G76),\"\")","v":0},null,{"$f":"SUM(I75:I76)","v":0}]

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TMS_OCC","index":2,"n_rows":2,"n_cols":23,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Hotel","Date","Tot. Rooms","Blocked","Rooms","Confirmed","Available","Tentative","Min available","Total maximum to sell","Max occupancy %","Minimum occupancy %","Room in","Room out","Reserv.","Availability share","Pickup availability allotment","Guests In","Guests Out","Guest Stay","Extras","% Minimum PAX Occupancy","% Maximun PAX Occupancy"]
["ARCC.LANCA","2022-07-31",115,6,109,41,68,0,68,68,37.61,37.61,24,48,89,0,0,26,78,57,1,24.78,24.78]

{"sheet":"1","index":3,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-01"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-07-31"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"Overview!F5","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"Overview!F5","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"2","index":4,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-02"},null,"= Day (n+1)",{"$f":"DAY(D8)","v":2}]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-01"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"3","index":5,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-03"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-02"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"4","index":6,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-04"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-03"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"5","index":7,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-05"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-04"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"6","index":8,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-06"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-05"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"7","index":9,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-07"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-06"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)",null,{"$f":"IF(D49>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"8","index":10,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-08"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-07"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"9","index":11,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-09"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-08"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"10","index":12,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-10"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-09"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"11","index":13,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-11"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-10"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"12","index":14,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-12"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-11"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"13","index":15,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-13"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-12"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"14","index":16,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-14"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-13"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"15","index":17,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-15"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-14"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"16","index":18,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-16"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-15"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"17","index":19,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-17"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-16"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"18","index":20,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-18"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-17"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"19","index":21,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-19"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-18"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"20","index":22,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-20"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-19"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"21","index":23,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-21"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-20"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"22","index":24,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-22"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-21"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"23","index":25,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-23"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-22"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"24","index":26,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-24"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-23"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"25","index":27,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-25"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-24"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"26","index":28,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-26"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-25"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"27","index":29,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-27"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-26"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"28","index":30,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-28"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-27"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"29","index":31,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-29"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-28"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"30","index":32,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-30"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-29"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"31","index":33,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[59,2,63,2],[66,2,69,2],[1,1,1,2],[1,3,5,5],[2,1,5,2],[10,1,10,2],[53,2,56,2],[54,3,54,5]]}
[]
[null,{"$f":"CONCATENATE(\"Version \",SYS!C8)","v":"Version 2021.08.16"}]
[null,"Rooms reconciliation Housekeeping vs Revenue report"]
[]
[]
[]
[]
[null,null,"CLEANING ROOMS OF DAY:",{"$f":"DATE(YEAR(Overview!F4),MONTH(Overview!F4),IF(LEN(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))=1),CONCATENATE(\"0\",RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))),RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1),1))))","v":"2023-08-31"},null,"= Day (n+1)"]
[null,null,"Daily Revenue Report of the day:",{"$f":"D8-1","v":"2023-08-30"},null,"= Day n"]
[null,null,null,"Number"]
[null,"Total cleaned rooms (information from Housekeeping)",null,"Rooms",null,"Remarks"]
[]
[null,null,"CLEANED ROOMS (by Housekeeping on day \"n+1\")"]
[]
[null,"Minus","CLEANED today NOT PRODUCED yesterday"]
[null,null,"Dirty rooms of today, should have been cleaned today but are left dirty for tomorrow or subsequent days:"]
[null,null,"Day Use of today cleaned today",null,{"$f":"IF(D17>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Rappel or check-in after the night audit cleaned today",null,{"$f":"IF(D18>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Unexpected check-out of today cleaned today",null,{"$f":"IF(D19>0,\"Include room nº\",\"\")","v":""}]
[]
[null,{"$f":"INDIRECT(\"AUDIT\"&\"!AC\" & (DAY(D8)-1+10))","v":0},"Accumulated rooms: dirty from previous days, to be cleaned today",{"$f":"INDIRECT(DAY(D9) & \"!D32\")","v":0},{"$f":"IF(D21>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,null,"Miscellaneous:"]
[null,null,"Change Room Status from blocked to clean cleaned today",null,{"$f":"IF(D25>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Room change cleaned today (only if cleaning is generated)",null,{"$f":"IF(D26>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Sports groups or Crew with which there is a commitment to clean the room twice",null,{"$f":"IF(D27>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal cleaned today not produced yesterday",{"$f":"SUM(D17:D19)+D21+SUM(D25:D27)","v":0}]
[]
[null,"Plus","PRODUCED yesterday NOT CLEANED today"]
[null,null,"Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days",null,{"$f":"IF(D32>0,\"Include room nº\",\"\")","v":""}]
[null,null,"Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)",null,{"$f":"IF(D33>0,\"Include room nº\",\"\")","v":""}]
[]
[]
[null,"Plus","PRODUCED and OCCUPIED yesterday but DO NOT REQUIRE CLEANING"]
[null,null,"\"Do Not Disturb\" sign / No cleaning service requested by the guest",null,{"$f":"IF(D37>0,\"Include room nº\",\"\")","v":""}]
[null,null,"          The guest did not sleep in the hotel (rooms that have been found clean)",null,{"$f":"IF(D38>0,\"Include room nº\",\"\")","v":""}]
[null,null,"\"Green Stay\" rooms",null,{"$f":"IF(D39>0,\"Include room nº\",\"\")","v":""}]
[]
[null,null,"Subtotal Produced yesterday not cleaned today",{"$f":"SUM(D32:D33)+SUM(D37:D39)","v":0}]
[]
[]
[null,null,"Subtotal CLEAN rooms that must have been produced yesterday",{"$f":"D13-D29+D41","v":0}]
[]
[]
[null,null,"ESTIMATED PRODUCED ROOMS",{"$f":"D13-D29+D41","v":0}]
[]
[null,"F.O","PRODUCED ROOMS (Daily Production Report)"]
[]
[null,null,"DIFFERENCES (Produced rooms - Estimation)",{"$f":"D49-D47","v":0},null,{"$f":"IF(D51>0,\"Produced more rooms\",(IF(D51<0,\"Cleaned more rooms\",\"O.k.\")))","v":"O.k."}]
[]
[null,null,"EXPLAIN DIFFERENCES (Clean Vs Produced)"]
[]
[]
[]
[]
[]
[null,null,"Approved by Housekeeper                                              Approved by Front Office Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"Approved by General Manager"]

{"sheet":"AUDIT","index":34,"n_rows":44,"n_cols":30,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,3,7,9],[7,11,7,15]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(Overview!B7,\" - \",TMS_OCC!A2)","v":"HOTEL NAME - ARCC.LANCA"}]
[null,{"$f":"PROPER(TEXT((C9),\"MMMM\"))","v":"Augustus"},null,"Cleaned today not produced yesterday",null,null,null,null,null,null,null,"Not cleaned but produced yesterday",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Overview!F5","v":0}]
[null,null,{"$f":"Overview!F4","v":"2023-08-31"}]
[null,null,"CLEANED ROOMS","Day Use of today cleaned today","Rappel or check-in after the night audit cleaned today","Unexpected check-out of today cleaned today","Accumulated rooms: dirty from previous days, cleaned today","Change Room Status from blocked to clean cleaned today","Room change cleaned today (only if cleaning is generated)","Sports groups or Crew with which there is a commitment to clean the room twice","Subtotal cleaned today not produced yesterday","Dirty rooms that due to organizational task will be cleaned tomorrow or in subsequent days","Dirty rooms that due to maintenance tasks will be cleaned tomorrow or in subsequent days (dirty -> block)","\"Do Not Disturb\" sign / No cleaning service requested by the guest","The guest did not sleep in the hotel (rooms that have been found clean)","\"Green Stay\" rooms","Subtotal Produced yesterday not cleaned today","Subtotal CLEAN rooms that must have been produced yesterday","ESTIMATED PRODUCED ROOMS","PRODUCED ROOMS (Daily Production Report)","DIFFERENCES (Produced rooms - Estimation)",null,"TMS\nOCCUPANCY REPORT",null,"Control",null,"Cleaning %","Comments",null,"RT Previous days rooms not cleaned"]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B11","v":"2023-08-01"},{"$f":"Overview!F11","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D17\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D18\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D19\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D21\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D25\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D26\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D27\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D29\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D32\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D33\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D37\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D38\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D39\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D41\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D44\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D47\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D49\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B11),0,INDIRECT(\"'\"&ROW()-10&\"'!D51\"))","v":0},null,{"$f":"IFERROR(IF(B11>Overview!$F$4,0,VLOOKUP(B11-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,{"$f":"IF(T11=W11,\"OK\",\"NOT OK\")","v":"OK"},null,{"$f":"IFERROR(IF(C11=0,\"\",C11/W11),\"\")","v":""},null,null,{"$f":"AD8-G11+L11","v":0}]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B12","v":"2023-08-02"},{"$f":"Overview!F12","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D33\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D37\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D38\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D39\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D41\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D44\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D47\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D49\"))","v":0},{"$f":"IF(MONTH($C$9)<>MONTH($B12),0,INDIRECT(\"'\"&ROW()-10&\"'!D51\"))","v":0},null,{"$f":"IFERROR(IF(B12>Overview!$F$4,0,VLOOKUP(B12-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,{"$f":"IF(T12=W12,\"OK\",\"NOT OK\")","v":"OK"},null,{"$f":"IFERROR(IF(C12=0,\"\",C12/W12),\"\")","v":""},null,null,{"$f":"AD11-G12+L12","v":0}]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B13","v":"2023-08-03"},{"$f":"Overview!F13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B13>Overview!$F$4,0,VLOOKUP(B13-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,{"$f":"AD12-G13+L13","v":0}]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B14","v":"2023-08-04"},{"$f":"Overview!F14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B14>Overview!$F$4,0,VLOOKUP(B14-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B15","v":"2023-08-05"},{"$f":"Overview!F15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B15>Overview!$F$4,0,VLOOKUP(B15-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B16","v":"2023-08-06"},{"$f":"Overview!F16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B16>Overview!$F$4,0,VLOOKUP(B16-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B17","v":"2023-08-07"},{"$f":"Overview!F17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B17>Overview!$F$4,0,VLOOKUP(B17-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B18","v":"2023-08-08"},{"$f":"Overview!F18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B18>Overview!$F$4,0,VLOOKUP(B18-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B19","v":"2023-08-09"},{"$f":"Overview!F19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B19>Overview!$F$4,0,VLOOKUP(B19-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B20","v":"2023-08-10"},{"$f":"Overview!F20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B20>Overview!$F$4,0,VLOOKUP(B20-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B21","v":"2023-08-11"},{"$f":"Overview!F21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B21>Overview!$F$4,0,VLOOKUP(B21-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B22","v":"2023-08-12"},{"$f":"Overview!F22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B22>Overview!$F$4,0,VLOOKUP(B22-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B23","v":"2023-08-13"},{"$f":"Overview!F23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B23>Overview!$F$4,0,VLOOKUP(B23-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B24","v":"2023-08-14"},{"$f":"Overview!F24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B24>Overview!$F$4,0,VLOOKUP(B24-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B25","v":"2023-08-15"},{"$f":"Overview!F25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B25>Overview!$F$4,0,VLOOKUP(B25-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B26","v":"2023-08-16"},{"$f":"Overview!F26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B26>Overview!$F$4,0,VLOOKUP(B26-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B27","v":"2023-08-17"},{"$f":"Overview!F27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B27>Overview!$F$4,0,VLOOKUP(B27-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B28","v":"2023-08-18"},{"$f":"Overview!F28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B28>Overview!$F$4,0,VLOOKUP(B28-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B29","v":"2023-08-19"},{"$f":"Overview!F29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B29>Overview!$F$4,0,VLOOKUP(B29-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B30","v":"2023-08-20"},{"$f":"Overview!F30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B30>Overview!$F$4,0,VLOOKUP(B30-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B31","v":"2023-08-21"},{"$f":"Overview!F31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B31>Overview!$F$4,0,VLOOKUP(B31-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B32","v":"2023-08-22"},{"$f":"Overview!F32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B32>Overview!$F$4,0,VLOOKUP(B32-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B33","v":"2023-08-23"},{"$f":"Overview!F33","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B33>Overview!$F$4,0,VLOOKUP(B33-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B34","v":"2023-08-24"},{"$f":"Overview!F34","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B34>Overview!$F$4,0,VLOOKUP(B34-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B35","v":"2023-08-25"},{"$f":"Overview!F35","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B35>Overview!$F$4,0,VLOOKUP(B35-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B36","v":"2023-08-26"},{"$f":"Overview!F36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B36>Overview!$F$4,0,VLOOKUP(B36-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B37","v":"2023-08-27"},{"$f":"Overview!F37","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B37>Overview!$F$4,0,VLOOKUP(B37-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B38","v":"2023-08-28"},{"$f":"Overview!F38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B38>Overview!$F$4,0,VLOOKUP(B38-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B39","v":"2023-08-29"},{"$f":"Overview!F39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B39>Overview!$F$4,0,VLOOKUP(B39-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B40","v":"2023-08-30"},{"$f":"Overview!F40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B40>Overview!$F$4,0,VLOOKUP(B40-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[{"$f":"TMS_OCC!A2","v":"ARCC.LANCA"},{"$f":"Overview!B41","v":"2023-08-31"},{"$f":"Overview!F41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IFERROR(IF(B41>Overview!$F$4,0,VLOOKUP(B41-1,TMS_OCC!B:W,5,FALSE)),0)","v":0},null,"OK",null,"",null,null,0]
[]
[null,null,{"$f":"SUM(C11:C42)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(T11:T42)","v":0},{"$f":"SUM(U11:U42)","v":0},null,{"$f":"SUM(W11:W42)","v":0},null,null,null,""]
[null,null,{"$f":"SUM(C11:C42)+W43-T43","v":0}]

{"sheet":"SYS","index":35,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Version ","2021.08.16","v16"]
[]
[]
[]
[]
[null,"First Week",{"$f":"WEEKNUM(Overview!B11,2)","v":32}]
[null,"Last week",{"$f":"WEEKNUM(Overview!F4,2)","v":36},{"$f":"+C14-C13+1","v":5}]
[]
[]
[null,null,{"$f":"C13","v":32}]
[null,null,{"$f":"+C17+1","v":33}]
[null,null,{"$f":"+C18+1","v":34}]
[null,null,{"$f":"+C19+1","v":35}]
[null,null,{"$f":"+C20+1","v":36}]
[null,null,{"$f":"+C21+1","v":37}]