{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Report"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":2,"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":"Report","index":0,"n_rows":472,"n_cols":19,"rows_kept":472,"cut":false,"hidden":false,"merged":[[411,9,411,11],[402,5,402,7],[403,5,403,7],[404,5,404,7],[405,5,405,7],[406,5,406,7],[407,5,407,7],[408,5,408,7],[409,5,409,7],[410,5,410,7],[402,9,402,11],[403,9,403,11],[404,9,404,11],[405,9,405,11],[406,9,406,11],[407,9,407,11],[408,9,408,11],[409,9,409,11],[410,9,410,11],[411,5,411,7],[353,6,353,7],[354,6,354,7],[355,6,355,7],[356,6,356,7],[357,6,357,7],[358,6,358,7],[359,6,359,7],[360,6,360,7],[361,6,361,7],[353,10,353,11],[354,10,354,11],[355,10,355,11],[356,10,356,11],[357,10,357,11],[358,10,358,11],[359,10,359,11],[360,10,360,11],[361,10,361,11],[344,10,344,11],[345,10,345,11],[346,10,346,11],[347,10,347,11],[348,10,348,11],[344,6,344,7],[345,6,345,7],[346,6,346,7],[347,6,347,7],[348,6,348,7],[316,10,316,11],[317,10,317,11],[318,10,318,11],[319,10,319,11],[320,10,320,11],[316,6,316,7],[317,6,317,7],[318,6,318,7],[319,6,319,7],[320,6,320,7],[197,1,197,2],[198,1,198,2],[199,1,199,2],[307,10,307,11],[308,10,308,11],[309,10,309,11],[310,10,310,11],[311,10,311,11],[307,6,307,7],[308,6,308,7],[309,6,309,7],[310,6,310,7],[311,6,311,7],[221,4,223,4],[221,6,223,6],[212,1,212,2],[213,1,213,2],[200,1,200,2],[204,1,204,2],[205,1,205,2],[206,1,206,2],[207,1,207,2],[211,1,211,2],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[21,13,21,14],[23,13,23,14],[22,13,22,14],[24,13,24,14],[25,13,25,14],[26,13,26,14],[27,13,27,14],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[471,3,471,5],[471,10,471,11],[468,3,468,5],[468,10,468,11],[469,3,469,5],[469,10,469,11],[470,3,470,5],[470,10,470,11],[465,3,465,5],[465,10,465,11],[466,3,466,5],[466,10,466,11],[467,3,467,5],[467,10,467,11],[465,6,465,7],[466,6,466,7],[467,6,467,7],[468,6,468,7],[469,6,469,7],[470,6,470,7],[471,6,471,7],[462,3,462,5],[462,10,462,11],[463,3,463,5],[463,10,463,11],[464,3,464,5],[464,10,464,11],[462,6,462,7],[463,6,463,7],[464,6,464,7],[459,3,459,5],[459,10,459,11],[460,3,460,5],[460,10,460,11],[461,3,461,5],[461,10,461,11],[459,6,459,7],[460,6,460,7],[461,6,461,7],[456,3,456,5],[456,10,456,11],[457,3,457,5],[457,10,457,11],[458,3,458,5],[458,10,458,11],[453,3,453,5],[453,10,453,11],[454,3,454,5],[454,10,454,11],[455,3,455,5],[455,10,455,11],[453,6,453,7],[454,6,454,7],[455,6,455,7],[456,6,456,7],[457,6,457,7],[458,6,458,7],[442,2,442,4],[442,5,442,7],[443,2,443,4],[443,5,443,7],[452,3,452,5],[452,10,452,11],[439,2,439,4],[439,5,439,7],[440,2,440,4],[440,5,440,7],[441,2,441,4],[441,5,441,7],[452,6,452,7],[436,2,436,4],[436,5,436,7],[437,2,437,4],[437,5,437,7],[438,2,438,4],[438,5,438,7],[429,2,429,4],[430,2,430,4],[434,2,434,4],[434,5,434,7],[435,2,435,4],[435,5,435,7],[411,1,411,2],[411,3,411,4],[426,2,426,4],[427,2,427,4],[428,2,428,4],[408,1,408,2],[408,3,408,4],[409,1,409,2],[409,3,409,4],[410,1,410,2],[410,3,410,4],[405,1,405,2],[405,3,405,4],[406,1,406,2],[406,3,406,4],[407,1,407,2],[407,3,407,4],[402,1,402,2],[402,3,402,4],[403,1,403,2],[403,3,403,4],[404,1,404,2],[404,3,404,4],[375,3,375,5],[375,10,375,11],[376,3,376,5],[376,10,376,11],[378,2,378,3],[378,4,378,5],[378,6,378,7],[372,3,372,5],[372,10,372,11],[373,3,373,5],[373,10,373,11],[374,3,374,5],[374,10,374,11],[372,6,372,7],[373,6,373,7],[374,6,374,7],[375,6,375,7],[376,6,376,7],[369,3,369,5],[369,10,369,11],[370,3,370,5],[370,10,370,11],[371,3,371,5],[371,10,371,11],[360,3,360,5],[361,3,361,5],[362,3,362,5],[367,3,367,5],[367,10,367,11],[368,3,368,5],[368,10,368,11],[362,10,362,11],[362,6,362,7],[367,6,367,7],[368,6,368,7],[369,6,369,7],[370,6,370,7],[371,6,371,7],[354,3,354,5],[355,3,355,5],[356,3,356,5],[357,3,357,5],[358,3,358,5],[359,3,359,5],[344,3,344,5],[345,3,345,5],[346,3,346,5],[347,3,347,5],[348,3,348,5],[353,3,353,5],[332,3,332,5],[333,3,333,5],[333,10,333,11],[334,3,334,5],[336,2,336,3],[336,4,336,5],[336,6,336,7],[329,3,329,5],[329,10,329,11],[330,3,330,5],[330,10,330,11],[331,3,331,5],[331,10,331,11],[329,6,329,7],[330,6,330,7],[331,6,331,7],[332,6,332,7],[333,6,333,7],[334,6,334,7],[332,10,332,11],[334,10,334,11],[326,3,326,5],[326,10,326,11],[327,3,327,5],[327,10,327,11],[328,3,328,5],[328,10,328,11],[317,3,317,5],[318,3,318,5],[319,3,319,5],[320,3,320,5],[325,3,325,5],[325,10,325,11],[325,6,325,7],[326,6,326,7],[327,6,327,7],[328,6,328,7],[316,3,316,5],[294,1,294,2],[295,1,295,2],[296,1,296,2],[297,1,297,2],[298,1,298,2],[299,1,299,2],[290,1,290,2],[291,1,291,2],[292,1,292,2],[293,1,293,2],[307,3,307,5],[308,3,308,5],[309,3,309,5],[310,3,310,5],[311,3,311,5],[191,1,191,2],[192,1,192,2],[140,1,140,2],[141,1,141,2],[143,1,143,2],[144,1,144,2],[145,1,145,2],[146,1,146,2],[147,1,147,2],[155,1,155,2],[156,1,156,2],[157,1,157,2],[178,1,178,2],[179,1,179,2],[180,1,180,2],[181,1,181,2],[182,1,182,2],[183,1,183,2],[184,1,184,2],[185,1,185,2],[186,1,186,2],[187,1,187,2],[81,2,81,3],[81,4,81,5],[81,6,81,7],[100,7,103,7],[101,5,102,5],[101,6,102,6],[137,1,137,2],[138,1,138,2],[139,1,139,2],[115,4,117,4],[117,5,118,5],[117,6,118,6],[78,1,78,2],[78,6,78,7],[79,1,79,2],[79,6,79,7],[80,2,80,3],[80,4,80,5],[80,6,80,7],[75,1,75,2],[75,6,75,7],[76,1,76,2],[76,6,76,7],[77,1,77,2],[77,6,77,7],[72,1,72,2],[72,6,72,7],[73,1,73,2],[73,6,73,7],[74,1,74,2],[74,6,74,7],[61,1,61,2],[61,5,61,6],[70,1,70,2],[70,6,70,7],[71,1,71,2],[71,6,71,7],[27,2,27,3],[59,1,59,2],[59,5,59,6],[60,1,60,2],[60,5,60,6],[55,1,55,2],[55,5,55,6],[56,1,56,2],[56,5,56,6],[57,1,57,2],[57,5,57,6],[7,2,7,3],[5,2,5,3],[52,1,52,2],[52,5,52,6],[53,1,53,2],[53,5,53,6],[54,1,54,2],[54,5,54,6],[58,1,58,2],[58,5,58,6],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3]]}
[]
[]
[null,null,"DAILY REPORTING BY OUTLET"]
[]
[]
[null,"OUTLET",{"$f":"MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+1,3)","v":"TSU"},null,null,null,"PUBLIC HOLIDAY EVE",null,null,"PUBLIC HOLIDAY EVE",false]
[]
[null,"DATE",{"$f":"TEXT(DATE(MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+4,4),MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+8,2),MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+10,2)),\"DD MMMM YYYY\")&\" \"&TEXT(DATE(MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+4,4),MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+8,2),MID(CELL(\"FILENAME\",$A$1),FIND(\"[\",CELL(\"FILENAME\",$A$1))+10,2)),\"DDDD\")","v":"14 June 2014 Saturday"},null,null,null,"PUBLIC HOLIDAY",null,null,"PUBLIC HOLIDAY",false]
[]
[]
[null,"A : MANPOWER"]
[null,"A01 : MANPOWER UPDATE"]
[null,"STAFF ID","STAFF NAME",null,"DEPARTMENT","EMPLOYMENT","STATUS",null,null,"DEPARTMENT","EMPLOYMENT ( LIST)","EMPLOYMENT","STATUS ( LIST )","STATUS"]
[null,null,null,null,{"$f":"$J14","v":0},{"$f":"$L14","v":0},{"$f":"$N14","v":0},null,null,null,"FULL TIME",null,"CONFIRMED ON"]
[null,null,null,null,0,{"$f":"$L15","v":0},0,null,null,null,"PART TIME",null,"PROMOTED TO"]
[null,null,null,null,0,{"$f":"$L16","v":0},0,null,null,null,"OUT-SOURCED",null,"REPORTED DUTY ON"]
[null,null,null,null,0,0,0,null,null,null,null,null,"RESIGNED BY"]
[null,null,null,null,0,0,0,null,null,null,null,null,"SUSPENDED TILL"]
[null,null,null,null,0,0,0,null,null,null,null,null,"TERMINATED ON"]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,"A02 : ATTENDANCE"]
[null,"DEPARTMENT","A.M.",null,null,"P.M."]
[null,null,"PLANNED","ACTUAL","% ATTENDANCE","PLANNED","ACTUAL","% ATTENDANCE"]
[null,"FOR FULL TIME STAFF ( BY PAX )"]
[null,"SUPERVISOR",null,{"$f":"$C33-COUNTIFS($J$53:$J$62,$B33,$L$53:$L$62,$C$30,$P$53:$P$62,\"=ABSENT\")-0.5*COUNTIFS($J$53:$J$62,$B33,$L$53:$L$62,\"MID\",$P$53:$P$62,\"=ABSENT\")","v":0},{"$f":"IFERROR($D33/$C33,\"\")","v":""},null,{"$f":"$F33-COUNTIFS($J$53:$J$62,$B33,$L$53:$L$62,$F$30,$P$53:$P$62,\"=ABSENT\")-0.5*COUNTIFS($J$53:$J$62,$B33,$L$53:$L$62,\"MID\",$P$53:$P$62,\"=ABSENT\")","v":0},{"$f":"IFERROR($G33/$F33,\"\")","v":""}]
[null,"RECEPTION",null,{"$f":"$C34-COUNTIFS($J$53:$J$62,$B34,$L$53:$L$62,$C$30,$P$53:$P$62,\"=ABSENT\")-0.5*COUNTIFS($J$53:$J$62,$B34,$L$53:$L$62,\"MID\",$P$53:$P$62,\"=ABSENT\")","v":0},{"$f":"IFERROR($D34/$C34,\"\")","v":""},null,{"$f":"$F34-COUNTIFS($J$53:$J$62,$B34,$L$53:$L$62,$F$30,$P$53:$P$62,\"=ABSENT\")-0.5*COUNTIFS($J$53:$J$62,$B34,$L$53:$L$62,\"MID\",$P$53:$P$62,\"=ABSENT\")","v":0},{"$f":"IFERROR($G34/$F34,\"\")","v":""}]
[null,"BAR",null,0,"",null,0,""]
[null,"FLOOR",null,0,"",null,0,""]
[null,"KITCHEN",null,0,"",null,0,""]
[null,"TECHNICAL",null,0,"",null,0,""]
[null,"CLEANER",null,0,"",null,0,""]
[null,null,null,0,"",null,0,""]
[null,null,null,0,"",null,0,""]
[null,null,null,0,"",null,0,""]
[null,"TOTAL ( BY PAX )",{"$f":"SUM(C$33:C$42)","v":0},{"$f":"SUM(D$33:D$42)","v":0},"",{"$f":"SUM(F$33:F$39)","v":0},{"$f":"SUM(G$33:G$39)","v":0},""]
[null,"FOR PART TIME STAFF ( BY HOURS )",null,null,null,null,null,null,null,"DEPARTMENT"]
[null,{"$f":"$J45","v":0},null,null,{"$f":"IFERROR($D45/$C45,\"\")","v":""},null,null,{"$f":"IFERROR($G45/$F45,\"\")","v":""}]
[null,{"$f":"$J46","v":0},null,null,"",null,null,""]
[null,{"$f":"$J47","v":0},null,null,"",null,null,""]
[null,{"$f":"$J48","v":0},null,null,"",null,null,""]
[null,{"$f":"$J49","v":0},null,null,"",null,null,""]
[null,"TOTAL ( HOURS )",{"$f":"SUM(C$45:C$49)","v":0},{"$f":"SUM(D$45:D$49)","v":0},"",{"$f":"SUM(F$45:F$49)","v":0},{"$f":"SUM(G$45:G$49)","v":0},""]
[null,"A03 : ABSENT FROM / LATE FOR WORK ( FOR FULL TIME STAFF ONLY )"]
[null,"STAFF NAME",null,"DEPARTMENT","SHIFT","REASON FOR ABSENCE",null,"LATE ( MINUTES )",null,"DEPARTMENT","SHIFT ( LIST )","SHIFT ","REASON ( LIST )","REASON 01","REASON 02","REASON 03","LATE","LATE ( A.M. )","LATE ( P.M. )"]
[null,null,null,{"$f":"$J53","v":0},{"$f":"$L53","v":0},{"$f":"$N53&\" \"&$O53","v":" "},null,{"$f":"$R53","v":0},null,null,"A.M.",null,"ABS",null,null,{"$f":"IF(OR($N53=\"ABS\",$N53=\"CL\",$N53=\"EL\",$N53=\"ML\"),\"ABSENT\",\"\")","v":""},null,{"$f":"IFERROR(IF($L53=\"A.M.\",VALUE($Q53),0)+IF(AND($L53=\"MID\",VALUE($Q53)<=240),VALUE($Q53),0)+IF(AND($L53=\"MID\",VALUE($Q53)>240),240,0),\"\")","v":0},{"$f":"IFERROR(IF($L53=\"P.M.\",VALUE($Q53),0)+IF(AND($L53=\"MID\",VALUE($Q53)>240),VALUE($Q53)-240,0),\"\")","v":0}]
[null,null,null,0,{"$f":"$L54","v":0},{"$f":"$N54&\" \"&$O54","v":" "},null,0,null,null,"P.M.",null,"CL",null,null,{"$f":"IF(OR($N54=\"ABS\",$N54=\"CL\",$N54=\"EL\",$N54=\"ML\"),\"ABSENT\",\"\")","v":""},null,0,0]
[null,null,null,0,0," ",null,0,null,null,"MID",null,"EL",null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,"ML",null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,null,null,0,0," ",null,0,null,null,null,null,null,null,null,"",null,0,0]
[null,"SHIFT","ABS","CL","EL","ML","LATE"]
[null,null,"no. of pax","no. of pax","no. of pax","no. of pax","no. of pax","minutes"]
[null,"A.M.",{"$f":"COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,$B65,$N$53:$N$62,C$63)+0.5*COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,\"MID\",$N$53:$N$62,C$63)","v":0},{"$f":"COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,$B65,$N$53:$N$62,D$63)+0.5*COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,\"MID\",$N$53:$N$62,D$63)","v":0},0,0,{"$f":"COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,$B65,$R$53:$R$62,\">0\")+0.5*COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,\"MID\",$R$53:$R$62,\">0\")","v":0},{"$f":"SUM($R$53:$R$62)","v":0}]
[null,"P.M.",{"$f":"COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,$B66,$N$53:$N$62,C$63)+0.5*COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,\"MID\",$N$53:$N$62,C$63)","v":0},0,0,0,{"$f":"COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,$B66,$R$53:$R$62,\">0\")+0.5*COUNTIFS($B$53:$B$62,\"<>\"&\"\",$L$53:$L$62,\"MID\",$R$53:$R$62,\">0\")","v":0},{"$f":"SUM($S$53:$S$62)","v":0}]
[null,"TOTAL",{"$f":"SUM(C$65:C$66)","v":0},0,0,0,0,0]
[null,"A04 : OVERTIME ( FOR FULL TIME STAFF ONLY )"]
[null,"STAFF NAME",null,"DEPARTMENT","SHIFT","OVERTIME ","REASON",null,null,"DEPARTMENT","SHIFT","OVERTIME","OVERTIME"]
[null,null,null,null,null,"( MINUTES )"]
[null,null,null,{"$f":"$J71","v":0},{"$f":"$K71","v":0},{"$f":"$L71","v":0},null,null,null,null,null,null,{"$f":"IFERROR(VALUE($L71),\"\")","v":0}]
[null,null,null,0,0,0,null,null,null,null,null,null,{"$f":"IFERROR(VALUE($L72),\"\")","v":0}]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,null,null,0]
[null,"TOTAL OVERTIME","A.M.",null,"P.M.",null,"TOTAL"]
[null,"IN MINUTES",{"$f":"SUMIF($K$71:$K$80,$C$81,$M$71:$M$80)+0.5*SUMIF($K$71:$K$80,\"MID\",$M$71:$M$80)","v":0},null,{"$f":"SUMIF($K$71:$K$80,$E$81,$M$71:$M$80)+0.5*SUMIF($K$71:$K$80,\"MID\",$M$71:$M$80)","v":0},null,{"$f":"SUM($C$82:$F$82)","v":0}]
[null,"A05 : EFFECTIVE MAN HOUR FOR THE DAY ( IN HH:MM )"]
[null,"DEPARTMENT","A.M.",null,null,"P.M."]
[null,null,"PLANNED","ACTUAL","% ATTENDANCE","PLANNED","ACTUAL","% ATTENDANCE"]
[null,{"$f":"IF($B33<>\"\",$B33,\"\")","v":"SUPERVISOR"},{"$f":"IFERROR(($C33*8)/24,\"\")","v":0},{"$f":"IFERROR(($D33*8-SUMIF($J$53:$J$62,$B86,$R$53:$R$62)/60+1.5*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B86,$K$71:$K$80,$C$84)/60)+0.75*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B86,$K$71:$K$80,\"MID\")/60))/24,\"\")","v":0},{"$f":"IFERROR($D86/$C86,\"\")","v":""},{"$f":"IFERROR(($F33*8)/24,\"\")","v":0},{"$f":"IFERROR(($G33*8-SUMIF($J$53:$J$62,$B86,$S$53:$S$62)/60+1.5*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B86,$K$71:$K$80,$F$84)/60)+0.75*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B86,$K$71:$K$80,\"MID\")/60))/24,\"\")","v":0},{"$f":"IFERROR($G86/$F86,\"\")","v":""}]
[null,{"$f":"IF($B34<>\"\",$B34,\"\")","v":"RECEPTION"},{"$f":"IFERROR(($C34*8)/24,\"\")","v":0},{"$f":"IFERROR(($D34*8-SUMIF($J$53:$J$62,$B87,$R$53:$R$62)/60+1.5*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B87,$K$71:$K$80,$C$84)/60)+0.75*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B87,$K$71:$K$80,\"MID\")/60))/24,\"\")","v":0},{"$f":"IFERROR($D87/$C87,\"\")","v":""},{"$f":"IFERROR(($F34*8)/24,\"\")","v":0},{"$f":"IFERROR(($G34*8-SUMIF($J$53:$J$62,$B87,$S$53:$S$62)/60+1.5*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B87,$K$71:$K$80,$F$84)/60)+0.75*(SUMIFS($M$71:$M$80,$J$71:$J$80,$B87,$K$71:$K$80,\"MID\")/60))/24,\"\")","v":0},{"$f":"IFERROR($G87/$F87,\"\")","v":""}]
[null,"BAR",0,0,"",0,0,""]
[null,"FLOOR",0,0,"",0,0,""]
[null,"KITCHEN",0,0,"",0,0,""]
[null,"TECHNICAL",0,0,"",0,0,""]
[null,"CLEANER",0,0,"",0,0,""]
[null,"",0,0,"",0,0,""]
[null,"",0,0,"",0,0,""]
[null,"",0,0,"",0,0,""]
[null,"TOTAL EFFECTIVE ",{"$f":"SUM(C$86:C$95)","v":0},{"$f":"SUM(D$86:D$95)","v":0},{"$f":"IFERROR($D$96/$C$96,\"\")","v":""},{"$f":"SUM(F$86:F$95)","v":0},{"$f":"SUM(G$86:G$95)","v":0},{"$f":"IFERROR($G$96/$F$96,\"\")","v":""}]
[null,"MAN HOUR FOR DAY"]
[]
[null,"B : SALES PERFORMANCE "]
[null,"B01 : SALES FOR THE DAY"]
[null,"SHIFT","CASH SALES","CARD SALES","SUB-TOTAL","PAY OUT","SPECIAL PAY OUT"]
[null,"A.M.",5729.1,182,{"$f":"$C102+$D102","v":5911.1}]
[null,"P.M.",7775.7,1506.6,{"$f":"$C103+$D103","v":9282.2999999999993}]
[null,"SUB-TOTAL",{"$f":"SUM(C$102:C$103)","v":13504.8},{"$f":"SUM(D$102:D$103)","v":1688.6},{"$f":"SUM($C$102:$D$103)","v":15193.4},66.849999999999994]
[null,"B02 : ROOM"]
[null,"TOTAL NO. OF ROOMS IN OUTLET",null,46,null,null,null,null,null,"TIME"]
[null,"UTILISATION OF ROOMS",null,null,"UTILISATION OF ROOMS ( PARTY , BIG )"]
[null,"SESSION","ROOMS USED","% USED","ROOM","TIME","PAX","AMOUNT "]
[null,"NOON K",33,{"$f":"IFERROR($C109/$D$106,\"\")","v":0.71739130434782605},201,{"$f":"$J109/(24*60*60)","v":"00:00:00"},{"$f":"10+12","v":22},{"$f":"162+384.4","v":546.4},null,0]
[null,"HAPPY",44,{"$f":"IFERROR($C110/$D$106,\"\")","v":0.95652173913043481},217,{"$f":"$J110/(24*60*60)","v":"00:00:00"},{"$f":"10+6+13","v":29},{"$f":"119.2+252+151.2","v":522.4},null,0]
[null,"NORMAL",68,{"$f":"IFERROR($C111/(2*$D$106),\"\")","v":0.73913043478260865},301,{"$f":"$J111/(24*60*60)","v":"00:00:00"},{"$f":"7+8","v":15},{"$f":"126+556","v":682},null,0]
[null,"MIDNIGHT",19,{"$f":"IFERROR($C112/$D$106,\"\")","v":0.41304347826086957},308,{"$f":"$J112/(24*60*60)","v":"00:00:00"},{"$f":"7+7","v":14},{"$f":"113.4+112","v":225.4},null,0]
[null,"TOTAL",{"$f":"SUM(C$109:C$112)","v":164},{"$f":"IFERROR($C113/(5*$D$106),\"\")","v":0.71304347826086956},null,{"$f":"$J113/(24*60*60)","v":"00:00:00"},null,null,null,0]
[null,"B03 : PAX"]
[null,"SESSION","TOTAL PAX","CHILDREN","LADIES","SENIOR CITIZEN","STUDENT","AVE. PAX / ROOM"]
[null,"NOON K",116,4,null,null,null,{"$f":"IFERROR($C116/$C109,\"\")","v":3.5151515151515151}]
[null,"HAPPY",157,1,null,null,null,{"$f":"IFERROR($C117/$C110,\"\")","v":3.5681818181818183}]
[null,"NORMAL",251,10,null,null,null,{"$f":"IFERROR($C118/$C111,\"\")","v":3.6911764705882355}]
[null,"MIDNIGHT",82,4,null,null,null,{"$f":"IFERROR($C119/$C112,\"\")","v":4.3157894736842106}]
[null,"TOTAL",{"$f":"SUM(C$116:C$119)","v":606},{"$f":"SUM(D$116:D$119)","v":19},{"$f":"E$119","v":0},{"$f":"F$117","v":0},{"$f":"G$117","v":0},{"$f":"IFERROR($C120/$C113,\"\")","v":3.6951219512195124}]
[null,"B04 : PACKAGE ( BEER )"]
[null,"DESCRIPTION",null,"NO. OF PACKAGE SOLD IN SESSION",null,null,null,null,null,"TYPE OF PACKAGE","TYPE OF BEER","QTY OF BEER","TYPE OF PACKAGE","TYPE OF BEER","QTY OF BEER CONSUMED ( BY BOTTLE )"]
[null,"PACKAGE TYPE","BEER TYPE","NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL",null,"( LIST )","( LIST )","( BY BOTTLE )","( SELECTED )","( SELECTED )","NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,{"$f":"$M124","v":"04BP ( before 7 )"},{"$f":"$N124","v":0},null,null,null,null,{"$f":"SUM($D124:$G124)","v":0},null,"04BP ( before 7 )",{"$f":"IF($B253<>\"\",$B253,\"\")","v":"GUINNESS"},12,"04BP ( before 7 )",null,{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M124,$J$124:$J$133,0),1)*$D124,\"\")","v":0},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M124,$J$124:$J$133,0),1)*$E124,\"\")","v":0},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M124,$J$124:$J$133,0),1)*$F124,\"\")","v":0},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M124,$J$124:$J$133,0),1)*$G124,\"\")","v":0},{"$f":"SUM($O124:$R124)","v":0}]
[null,"04BP ( after 7 )",0,null,null,3,3,{"$f":"SUM($D125:$G125)","v":6},null,"04BP ( after 7 )",{"$f":"IF($B254<>\"\",$B254,\"\")","v":"HEINEKEN"},12,"04BP ( after 7 )",null,{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M125,$J$124:$J$133,0),1)*$D125,\"\")","v":0},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M125,$J$124:$J$133,0),1)*$E125,\"\")","v":0},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M125,$J$124:$J$133,0),1)*$F125,\"\")","v":36},{"$f":"IFERROR(INDEX($L$124:$L$133,MATCH($M125,$J$124:$J$133,0),1)*$G125,\"\")","v":36},{"$f":"SUM($O125:$R125)","v":72}]
[null,0,0,null,null,null,null,{"$f":"SUM($D126:$G126)","v":0},null,null,"TIGER",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,"",null,null,null,"","","","",0]
[null,"B05 : PACKAGE ( LIQUOR & WINE )"]
[null,"DESCRIPTION",null,"NO. OF PACKAGE SOLD IN SESSION",null,null,null,null,null,"TYPE OF LIQUOR / WINE","TYPE OF LIQUOR / WINE","TYPE OF LIQUOR / WINE","QTY OF LIQUOR / WINE CONSUMED"]
[null,null,null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL",null,"( LIST )","( SELECTED )","( SELECTED )","NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"LIQUOR PACKAGE | 02LP",null,null,null,null,null,null,null,"LIQUOR",null,null,{"$f":"SUMIF($K$138:$K$158,$J138,$D$138:$D$158)+SUMIF($L$138:$L$158,$J138,$D$138:$D$158)","v":0},{"$f":"SUMIF($K$138:$K$158,$J138,$E$138:$E$158)+SUMIF($L$138:$L$158,$J138,$E$138:$E$158)","v":0},{"$f":"SUMIF($K$138:$K$158,$J138,$F$138:$F$158)+SUMIF($L$138:$L$158,$J138,$F$138:$F$158)","v":0},{"$f":"SUMIF($K$138:$K$158,$J138,$G$138:$G$158)+SUMIF($L$138:$L$158,$J138,$G$138:$G$158)","v":0},{"$f":"SUMIF($K$138:$K$158,$J138,$G$138:$G$158)+SUMIF($L$138:$L$158,$J138,$G$138:$G$158)","v":0}]
[null,{"$f":"$K138","v":0},null,null,null,null,null,{"$f":"SUM($D138:$G138)","v":0},null,{"$f":"IF($B264<>\"\",$B264,\"\")","v":"ABSOLUT BLUE"},null,null,{"$f":"SUMIF($K$138:$K$154,$J138,$D$138:$D$154)+SUMIF($L$138:$L$154,$J138,$D$138:$D$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J138,$E$138:$E$154)+SUMIF($L$138:$L$154,$J138,$E$138:$E$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J138,$F$138:$F$154)+SUMIF($L$138:$L$154,$J138,$F$138:$F$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J138,$G$138:$G$154)+SUMIF($L$138:$L$154,$J138,$G$138:$G$154)","v":0},{"$f":"SUM($M138:$P138)","v":0}]
[null,{"$f":"$K139","v":0},null,null,null,null,null,{"$f":"SUM($D139:$G139)","v":0},null,{"$f":"IF($B265<>\"\",$B265,\"\")","v":"ABSOLUT VANILA"},null,null,{"$f":"SUMIF($K$138:$K$154,$J139,$D$138:$D$154)+SUMIF($L$138:$L$154,$J139,$D$138:$D$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J139,$E$138:$E$154)+SUMIF($L$138:$L$154,$J139,$E$138:$E$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J139,$F$138:$F$154)+SUMIF($L$138:$L$154,$J139,$F$138:$F$154)","v":0},{"$f":"SUMIF($K$138:$K$154,$J139,$G$138:$G$154)+SUMIF($L$138:$L$154,$J139,$G$138:$G$154)","v":0},{"$f":"SUM($M139:$P139)","v":0}]
[null,{"$f":"$K140","v":0},null,null,null,null,null,{"$f":"SUM($D140:$G140)","v":0},null,"BACARDI APPLE",null,null,0,0,0,0,0]
[null,{"$f":"$K141","v":0},null,null,null,null,null,{"$f":"SUM($D141:$G141)","v":0},null,"BACARDI BLANC",null,null,0,0,0,0,0]
[null,{"$f":"$K142","v":0},null,null,null,null,null,{"$f":"SUM($D142:$G142)","v":0},null,"BACARDI LEMON",null,null,0,0,0,0,0]
[null,"LIQUOR PACKAGE | 06LP",null,null,null,null,null,null,null,"CHIVAS REGAL 12",null,null,0,0,0,0,0]
[null,{"$f":"$K144","v":0},null,null,null,null,null,{"$f":"SUM($D144:$G144)","v":0},null,"GORDON'S GIN",null,null,0,0,0,0,0]
[null,{"$f":"$K145","v":0},null,null,null,null,null,{"$f":"SUM($D145:$G145)","v":0},null,"HENNESSY VSOP",null,null,0,0,0,0,0]
[null,{"$f":"$K146","v":0},null,null,null,null,null,{"$f":"SUM($D146:$G146)","v":0},null,"JOSE CUERVO",null,null,0,0,0,0,0]
[null,{"$f":"$K147","v":0},null,null,null,null,null,{"$f":"SUM($D147:$G147)","v":0},null,"JW BLACK",null,null,0,0,0,0,0]
[null,{"$f":"$K148","v":0},null,null,null,null,null,{"$f":"SUM($D148:$G148)","v":0},null,"MALIBU",null,null,0,0,0,0,0]
[null,"LIQUOR PACKAGE | 12LP",null,null,null,null,null,null,null,"MARTELL VSOP",null,null,0,0,0,0,0]
[null,{"$f":"$K150","v":0},{"$f":"$L150","v":0},null,null,null,null,{"$f":"SUM($D150:$G150)","v":0},null,"",null,null,0,0,0,0,0]
[null,{"$f":"$K151","v":0},{"$f":"$L151","v":0},null,null,null,null,{"$f":"SUM($D151:$G151)","v":0},null,"",null,null,0,0,0,0,0]
[null,{"$f":"$K152","v":0},{"$f":"$L152","v":0},null,null,null,null,{"$f":"SUM($D152:$G152)","v":0},null,"",null,null,0,0,0,0,0]
[null,{"$f":"$K153","v":0},{"$f":"$L153","v":0},null,null,null,null,{"$f":"SUM($D153:$G153)","v":0},null,"",null,null,0,0,0,0,0]
[null,{"$f":"$K154","v":0},{"$f":"$L154","v":0},null,null,null,null,{"$f":"SUM($D154:$G154)","v":0},null,"",null,null,0,0,0,0,0]
[null,"WINE PACKAGE | 02WP",null,null,null,null,null,null,null,"WINE"]
[null,{"$f":"$K156","v":0},null,null,null,null,null,{"$f":"SUM($D156:$G156)","v":0},null,"RED WINE",null,null,{"$f":"2*SUMIF($K$156:$K$158,$J156,$D$156:$D$158)+M$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J156,$E$156:$E$158)+N$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J156,$F$156:$F$158)+O$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J156,$G$156:$G$158)+P$158","v":0},{"$f":"SUM($M156:$P156)","v":0}]
[null,{"$f":"$K157","v":0},null,null,null,null,null,{"$f":"SUM($D157:$G157)","v":0},null,"WHITE WINE",null,null,{"$f":"2*SUMIF($K$156:$K$158,$J157,$D$156:$D$158)+M$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J157,$E$156:$E$158)+N$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J157,$F$156:$F$158)+O$158","v":0},{"$f":"2*SUMIF($K$156:$K$158,$J157,$G$156:$G$158)+P$158","v":0},{"$f":"SUM($M157:$P157)","v":0}]
[null,{"$f":"$K158","v":0},null,null,null,null,null,{"$f":"SUM($D158:$G158)","v":0},null,"RED + WHITE WINE",null,null,{"$f":"SUMIF($K$156:$K$158,$J158,$D$156:$D$158)","v":0},{"$f":"SUMIF($K$156:$K$158,$J158,$E$156:$E$158)","v":0},{"$f":"SUMIF($K$156:$K$158,$J158,$F$156:$F$158)","v":0},{"$f":"SUMIF($K$156:$K$158,$J158,$G$156:$G$158)","v":0}]
[null,"B06 : SIDE ORDER ( ALCOHOLIC BEVERAGE )"]
[null,"DESCRIPTION",null,"QTY SOLD IN SESSION",null,null,null,null,null,"TYPE OF DRINKS","TYPE OF SERVING","TYPE OF SERVING","QTY OF BEER CONSUMED ( BY BOTTLE )"]
[null,null,null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL",null,"( SELECTED )","( LIST )","( SELECTED )","NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"BEER ( BY TYPE OF SERVING )",null,null,null,null,null,null,null,"BEER"]
[null,{"$f":"$J163","v":"HEINEKEN"},{"$f":"$L163","v":"BOTTLE"},null,null,4,null,{"$f":"SUM($D163:$G163)","v":4},null,"HEINEKEN","BOTTLE","BOTTLE",{"$f":"IF(OR($L163=\"BOTTLE\",$L163=\"EXCHANGE\"),$D163,IF($L163=\"BUCKET\",4*$D163,IF($L163=\"ROUND\",12*$D163,\"\")))","v":0},{"$f":"IF(OR($L163=\"BOTTLE\",$L163=\"EXCHANGE\"),$E163,IF($L163=\"BUCKET\",4*$E163,IF($L163=\"ROUND\",12*$E163,\"\")))","v":0},{"$f":"IF(OR($L163=\"BOTTLE\",$L163=\"EXCHANGE\"),$F163,IF($L163=\"BUCKET\",4*$F163,IF($L163=\"ROUND\",12*$F163,\"\")))","v":4},{"$f":"IF(OR($L163=\"BOTTLE\",$L163=\"EXCHANGE\"),$G163,IF($L163=\"BUCKET\",4*$G163,IF($L163=\"ROUND\",12*$G163,\"\")))","v":0},{"$f":"SUM($M163:$P163)","v":4}]
[null,"HEINEKEN","BUCKET",null,null,10,null,{"$f":"SUM($D164:$G164)","v":10},null,"HEINEKEN","BUCKET","BUCKET",{"$f":"IF(OR($L164=\"BOTTLE\",$L164=\"EXCHANGE\"),$D164,IF($L164=\"BUCKET\",4*$D164,IF($L164=\"ROUND\",12*$D164,\"\")))","v":0},{"$f":"IF(OR($L164=\"BOTTLE\",$L164=\"EXCHANGE\"),$E164,IF($L164=\"BUCKET\",4*$E164,IF($L164=\"ROUND\",12*$E164,\"\")))","v":0},{"$f":"IF(OR($L164=\"BOTTLE\",$L164=\"EXCHANGE\"),$F164,IF($L164=\"BUCKET\",4*$F164,IF($L164=\"ROUND\",12*$F164,\"\")))","v":40},{"$f":"IF(OR($L164=\"BOTTLE\",$L164=\"EXCHANGE\"),$G164,IF($L164=\"BUCKET\",4*$G164,IF($L164=\"ROUND\",12*$G164,\"\")))","v":0},40]
[null,"HEINEKEN","ROUND",null,null,1,null,{"$f":"SUM($D165:$G165)","v":1},null,"HEINEKEN","EXCHANGE","ROUND",0,0,12,0,12]
[null,"TIGER","BOTTLE",null,null,null,null,0,null,"TIGER","ROUND","BOTTLE",0,0,0,0,0]
[null,"TIGER","BUCKET",null,null,12,null,12,null,"TIGER",null,"BUCKET",0,0,48,0,48]
[null,"TIGER","ROUND",null,null,4,null,4,null,"TIGER",null,"ROUND",0,0,48,0,48]
[null,"GUINNESS","BOTTLE",null,null,null,null,0,null,"GUINNESS",null,"BOTTLE",0,0,0,0,0]
[null,"GUINNESS","BUCKET",null,null,1,null,1,null,"GUINNESS",null,"BUCKET",0,0,4,0,4]
[null,"GUINNESS","ROUND",null,null,null,null,0,null,"GUINNESS",null,"ROUND",0,0,0,0,0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,0,0,null,null,null,null,0,null,null,null,null,"","","","",0]
[null,"LIQUOR ( BY BOTTLE )",null,null,null,null,null,null,null,"LIQUOR",null,null,{"$f":"SUMIF($K$138:$K$158,$J178,$H$138:$H$158)+SUMIF($L$138:$L$158,$J178,$H$138:$H$158)","v":0}]
[null,{"$f":"$J179","v":0},null,null,null,null,null,{"$f":"SUM($D179:$G179)","v":0},null,null,null,null,null,null,{"$f":"$H179","v":0}]
[null,0,null,null,null,null,null,{"$f":"SUM($D180:$G180)","v":0},null,null,null,null,null,null,{"$f":"$H180","v":0}]
[null,0,null,null,null,null,null,{"$f":"SUM($D181:$G181)","v":0},null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,0,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,"B07 : PROMOTION"]
[null,"DESCRIPTION",null,"QTY SOLD IN SESSION"]
[null,"E.G. K-LUNCH, K-DINNER",null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"K-Lunch",null,112,null,null,null,{"$f":"SUM($D192:$G192)","v":112}]
[null,"LOK-LOK",null,null,null,null,null,{"$f":"SUM($D193:$G193)","v":0}]
[null,"Member 30%",null,null,null,null,null,{"$f":"SUM($D194:$G194)","v":0}]
[null,"Member Package",null,null,null,null,null,0]
[null,"Tiger (2+1) Round",null,null,null,null,null,0]
[null,"Student Member Card",null,null,null,null,null,0]
[null,"Student Member Price",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"B08 : KITCHEN"]
[null,"DESCRIPTION",null,"QTY SOLD IN SESSION"]
[null,null,null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"CHINESE",null,null,null,79,null,{"$f":"SUM($D205:$G205)","v":79}]
[null,"WESTERN",null,null,null,null,null,{"$f":"SUM($D206:$G206)","v":0}]
[null,"SNACKS",null,null,null,null,null,{"$f":"SUM($D207:$G207)","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D$205:D$207)","v":0},{"$f":"SUM(E$205:E$207)","v":0},{"$f":"SUM(F$205:F$207)","v":79},{"$f":"SUM(G$205:G$207)","v":0},{"$f":"SUM($D208:$G208)","v":79}]
[null,"B09 : MEMBERSHIP"]
[null,"DESCRIPTION",null,"QTY SOLD IN SESSION"]
[null,null,null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"NEW SUBSCRIPTION",null,null,5,19,1,{"$f":"SUM($D212:$G212)","v":25}]
[null,"RENEWAL",null,null,null,null,null,{"$f":"SUM($D213:$G213)","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D$212:D$213)","v":0},{"$f":"SUM(E$212:E$213)","v":5},{"$f":"SUM(F$212:F$213)","v":19},{"$f":"SUM(G$212:G$213)","v":1},{"$f":"SUM($D214:$G214)","v":25}]
[null,"B10 : SUMMARY OF SALES PERFORMANCE AND MANPOWER UTILISATION"]
[null,"SESSION",null,"NOON K","HAPPY","NORMAL","MIDNIGHT","TOTAL"]
[null,"STATISTICS OF SALES FOR THE DAY"]
[null,"ROOM USED",null,{"$f":"$C$109","v":33},{"$f":"$C$110","v":44},{"$f":"$C$111","v":68},{"$f":"$C$112","v":19},{"$f":"SUM($D218:$G218)","v":164}]
[null,"% ROOM UTILISATION",null,{"$f":"$D$109","v":0.71739130434782605},{"$f":"$D$110","v":0.95652173913043481},{"$f":"$D$111","v":0.73913043478260865},{"$f":"$D$112","v":0.41304347826086957},{"$f":"$D$113","v":0.71304347826086956}]
[null,"PAX",null,{"$f":"$C$116","v":116},{"$f":"$C$117","v":157},{"$f":"$C$118","v":251},{"$f":"$C$119","v":82},{"$f":"SUM($D220:$G220)","v":606}]
[null,"AVERAGE PAX / ROOM",null,{"$f":"$H$116","v":3.5151515151515151},{"$f":"$H$117","v":3.5681818181818183},{"$f":"$H$118","v":3.6911764705882355},{"$f":"$H$119","v":4.3157894736842106},{"$f":"IFERROR($H$220/$H$218,\"\")","v":3.6951219512195124}]
[null,"TOTAL SALES FOR THE DAY",null,{"$f":"$E$102","v":5911.1},null,{"$f":"$E$103","v":9282.2999999999993},null,{"$f":"$E$104","v":15193.4}]
[null,"AVERAGE SALES / ROOM",null,{"$f":"IFERROR($D$222/($D$218+$E$218),\"\")","v":76.767532467532476},null,{"$f":"IFERROR($F$222/($F$218+$G$218),\"\")","v":106.69310344827585},null,{"$f":"IFERROR($H$222/$H$218,\"\")","v":92.642682926829266}]
[null,"AVERAGE SALES / PAX",null,{"$f":"IFERROR($D$222/($D$220+$E$220),\"\")","v":21.652380952380955},null,{"$f":"IFERROR($F$222/($F$220+$G$220),\"\")","v":27.874774774774771},null,{"$f":"IFERROR($H$222/$H$220,\"\")","v":25.071617161716173}]
[null,"CONSUMPTION OF BEER ( PER BOTTLE )"]
[null,"CONSUMPTION OF BEER BY PACKAGE",null,{"$f":"SUM(O$124:O$133)","v":0},{"$f":"SUM(P$124:P$133)","v":0},{"$f":"SUM(Q$124:Q$133)","v":36},{"$f":"SUM(R$124:R$133)","v":36},{"$f":"SUM($D226:$G226)","v":72}]
[null,"COMSUMPTION OF BEER BY EXCHANGE",null,{"$f":"SUMIF($L$163:$L$177,\"EXCHANGE\",M$163:M$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"EXCHANGE\",N$163:N$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"EXCHANGE\",O$163:O$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"EXCHANGE\",P$163:P$177)","v":0},0]
[null,"COMSUMPTION OF BEER BY BOTTLE",null,{"$f":"SUMIF($L$163:$L$177,\"BOTTLE\",M$163:M$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"BOTTLE\",N$163:N$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"BOTTLE\",O$163:O$177)","v":4},{"$f":"SUMIF($L$163:$L$177,\"BOTTLE\",P$163:P$177)","v":0},4]
[null,"CONSUMPTION OF BEER BY BUCKET",null,{"$f":"SUMIF($L$163:$L$177,\"BUCKET\",M$163:M$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"BUCKET\",N$163:N$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"BUCKET\",O$163:O$177)","v":92},{"$f":"SUMIF($L$163:$L$177,\"BUCKET\",P$163:P$177)","v":0},92]
[null,"CONSUMPTION OF BEER BY ROUND",null,{"$f":"SUMIF($L$163:$L$177,\"ROUND\",M$163:M$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"ROUND\",N$163:N$177)","v":0},{"$f":"SUMIF($L$163:$L$177,\"ROUND\",O$163:O$177)","v":60},{"$f":"SUMIF($L$163:$L$177,\"ROUND\",P$163:P$177)","v":0},60]
[null,"TOTAL CONSUMPTION OF BEER",null,{"$f":"SUM(D$226:D$230)","v":0},{"$f":"SUM(E$226:E$230)","v":0},{"$f":"SUM(F$226:F$230)","v":192},{"$f":"SUM(G$226:G$230)","v":36},228]
[null,"RATIO OF BEER CONSUMED TO PAX",null,{"$f":"IF(D$231>0,D$231/GCD(D$231,D$220)&\":\"&D$220/GCD(D$231,D$220),\"\")","v":""},{"$f":"IF(E$231>0,E$231/GCD(E$231,E$220)&\":\"&E$220/GCD(E$231,E$220),\"\")","v":""},{"$f":"IF(F$231>0,F$231/GCD(F$231,F$220)&\":\"&F$220/GCD(F$231,F$220),\"\")","v":"192:251"},{"$f":"IF(G$231>0,G$231/GCD(G$231,G$220)&\":\"&G$220/GCD(G$231,G$220),\"\")","v":"18:41"},{"$f":"IF(H$231>0,H$231/GCD(H$231,H$220)&\":\"&H$220/GCD(H$231,H$220),\"\")","v":"38:101"}]
[null,"CONSUMPTION OF LIQUOR ( PER BOTTLE )"]
[null,"CONSUMPTION OF LIQUOR BY PACKAGE",null,{"$f":"SUM(M$138:M$154)","v":0},{"$f":"SUM(N$138:N$154)","v":0},{"$f":"SUM(O$138:O$154)","v":0},{"$f":"SUM(P$138:P$154)","v":0},{"$f":"SUM($D234:$G234)","v":0}]
[null,"CONSUMPTION OF LIQUOR BY BOTTLE",null,{"$f":"SUM(D$179:D$188)","v":0},{"$f":"SUM(E$179:E$188)","v":0},{"$f":"SUM(F$179:F$188)","v":0},{"$f":"SUM(G$179:G$188)","v":0},{"$f":"SUM($D235:$G235)","v":0}]
[null,"TOTAL CONSUMPTION OF LIQUOR",null,{"$f":"SUM(D$234:D$235)","v":0},{"$f":"SUM(E$234:E$235)","v":0},{"$f":"SUM(F$234:F$235)","v":0},{"$f":"SUM(G$234:G$235)","v":0},{"$f":"SUM($D236:$G236)","v":0}]
[null,"RATIO OF LIQUOR CONSUMED TO PAX",null,{"$f":"IF(D$236>0,D$236/GCD(D$236,D$220)&\":\"&D$220/GCD(D$236,D$220),\"\")","v":""},{"$f":"IF(E$236>0,E$236/GCD(E$236,E$220)&\":\"&E$220/GCD(E$236,E$220),\"\")","v":""},{"$f":"IF(F$236>0,F$236/GCD(F$236,F$220)&\":\"&F$220/GCD(F$236,F$220),\"\")","v":""},{"$f":"IF(G$236>0,G$236/GCD(G$236,G$220)&\":\"&G$220/GCD(G$236,G$220),\"\")","v":""},{"$f":"IF(H$236>0,H$236/GCD(H$236,H$220)&\":\"&H$220/GCD(H$236,H$220),\"\")","v":""}]
[null,"CONSUMPTION OF WINE ( PER BOTTLE )"]
[null,"TOTAL CONSUMPTION OF WINE",null,{"$f":"SUM(M$156:M$157)","v":0},{"$f":"SUM(N$156:N$157)","v":0},{"$f":"SUM(O$156:O$157)","v":0},{"$f":"SUM(P$156:P$157)","v":0},{"$f":"SUM($D239:$G239)","v":0}]
[null,"RATIO OF WINE CONSUMED TO PAX",null,{"$f":"IF(D$239>0,D$239/GCD(D$239,D$220)&\":\"&D$220/GCD(D$239,D$220),\"\")","v":""},{"$f":"IF(E$239>0,E$239/GCD(E$239,E$220)&\":\"&E$220/GCD(E$239,E$220),\"\")","v":""},{"$f":"IF(F$239>0,F$239/GCD(F$239,F$220)&\":\"&F$220/GCD(F$239,F$220),\"\")","v":""},{"$f":"IF(G$239>0,G$239/GCD(G$239,G$220)&\":\"&G$220/GCD(G$239,G$220),\"\")","v":""},{"$f":"IF(H$239>0,H$239/GCD(H$239,H$220)&\":\"&H$220/GCD(H$239,H$220),\"\")","v":""}]
[null,"STATISTICS OF MANPOWER UTITLISATION"]
[null,"EFFECTIVE MAN HOUR PER SESSION ( HH:MM )",null,{"$f":"3/8*$D$96","v":0},{"$f":"5/8*$D$96","v":0},{"$f":"5/8*$G$96","v":0},{"$f":"3/8*$G$96","v":0},{"$f":"SUM($D242:$G242)","v":0}]
[null,"MAN HOUR ( HH:MM ) SPENT SERVING ONE ROOM",null,{"$f":"IFERROR(D$242/D$218,\"\")","v":0},{"$f":"IFERROR(E$242/E$218,\"\")","v":0},{"$f":"IFERROR(F$242/F$218,\"\")","v":0},{"$f":"IFERROR(G$242/G$218,\"\")","v":0},{"$f":"IFERROR(H$242/H$218,\"\")","v":0}]
[null,"MAN HOUR ( HH:MM ) SPENT SELLING ONE PINT",null,{"$f":"IFERROR(D$242/(D$231+2*D$236+2*D$239),\"\")","v":""},{"$f":"IFERROR(E$242/(E$231+2*E$236+2*E$239),\"\")","v":""},{"$f":"IFERROR(F$242/(F$231+2*F$236+2*F$239),\"\")","v":0},{"$f":"IFERROR(G$242/(G$231+2*G$236+2*G$239),\"\")","v":0},{"$f":"IFERROR(H$242/(H$231+2*H$236+2*H$239),\"\")","v":0}]
[null,"MAN HOUR ( HH:MM ) SPENT SELLING ONE MEAL",null,{"$f":"IFERROR(D$242/D$208,\"\")","v":""},{"$f":"IFERROR(E$242/E$208,\"\")","v":""},{"$f":"IFERROR(F$242/F$208,\"\")","v":0},{"$f":"IFERROR(G$242/G$208,\"\")","v":""},{"$f":"IFERROR(H$242/H$208,\"\")","v":0}]
[null,"SALES EARNED PER MAN HOUR",null,{"$f":"IFERROR($D$222/(24*($D$242+$E$242)),\"\")","v":""},null,{"$f":"IFERROR($F$222/(24*($F$242+$G$242)),\"\")","v":""},null,{"$f":"IFERROR($H$222/(24*$H$242),\"\")","v":""}]
[]
[null,"C : COST MANAGEMENT"]
[null,"C01 : DAILY STOCK CONTROL FOR ALCOHOLIC BEVERAGES"]
[null,"TYPE OF BEER","OPENING STOCK","QTY IN ( + )","QTY OUT ( - )","CLOSING STOCK","IN CUSTODY","VARIANCE ( + / - )"]
[null,null,null,"( PURCHASED )","( SOLD )"]
[null,"BEER ( BY BOTTLE )"]
[null,"GUINNESS",54,null,{"$f":"SUMIF($N$124:$N$133,$B253,$S$124:$S$133)+SUMIF($J$163:$J$177,$B253,$Q$163:$Q$177)","v":4},{"$f":"$C253+$D253-$E253","v":50}]
[null,"HEINEKEN",374,null,56,{"$f":"$C254+$D254-$E254","v":318},5]
[null,"TIGER",203,null,96,107,3]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,"LIQUOR ( BY BOTTLE )"]
[null,"ABSOLUT BLUE",null,null,{"$f":"SUMIF($J$138:$J$154,$B264,$Q$138:$Q$154)+SUMIF($J$179:$J$188,$B264,$H$179:$H$188)","v":0},{"$f":"$C264+$D264-$E264","v":0}]
[null,"ABSOLUT VANILA",null,null,{"$f":"SUMIF($J$138:$J$154,$B265,$Q$138:$Q$154)+SUMIF($J$179:$J$188,$B265,$H$179:$H$188)","v":0},{"$f":"$C265+$D265-$E265","v":0}]
[null,"BACARDI APPLE",null,null,0,0]
[null,"BACARDI BLANC",null,null,0,0]
[null,"BACARDI LEMON",null,null,0,0]
[null,"CHIVAS REGAL 12",null,null,0,0]
[null,"GORDON'S GIN",null,null,0,0]
[null,"HENNESSY VSOP",null,null,0,0]
[null,"JOSE CUERVO",null,null,0,0]
[null,"JW BLACK",null,null,0,0]
[null,"MALIBU",null,null,0,0]
[null,"MARTELL VSOP",null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,"WINE ( BY BOTTLE )"]
[null,"RED WINE",null,null,{"$f":"SUMIF($J$156:$J$157,$B285,$Q$156:$Q$157)","v":0},{"$f":"$C285+$D285-$E285","v":0}]
[null,"WHITE WINE",null,null,{"$f":"SUMIF($J$156:$J$157,$B286,$Q$156:$Q$157)","v":0},{"$f":"$C286+$D286-$E286","v":0}]
[null,"C02 : DAILY STOCK CONTROL FOR NON-ALCOHOLIC ESSENTIAL GOODS"]
[null,"DESCRIPTION",null,"OPENING STOCK","QTY IN ( + )","QTY OUT ( - )","CLOSING STOCK","VARIANCE ( + / - )"]
[null,null,null,null,"( PURCHASED )","( SOLD )"]
[null,"CIGARETTE AND OTHERS"]
[null,"CIGARETTE ( ALL TYPES BY PACK )",null,181,null,10,{"$f":"$D291+$E291-$F291","v":171}]
[null,null,null,null,null,null,{"$f":"$D292+$E292-$F292","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,"D : MAINTENANCE"]
[null,"D01 : SCHEDULED MAINTENANCE WORKS"]
[null,"SHIFT","LOCATION","DESCRIPTION OF SCHEDULED WORKS",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"CANCELLED DUE "]
[null,null,null,null,null,null,"COMPLETED"]
[null,null,null,null,null,null,"POSTPONED TO"]
[null,{"$f":"$J308","v":0},null,null,null,null,{"$f":"$K308","v":0}]
[null,{"$f":"$J309","v":0},null,null,null,null,{"$f":"$K309","v":0}]
[null,{"$f":"$J310","v":0},null,null,null,null,{"$f":"$K310","v":0}]
[null,{"$f":"$J311","v":0},null,null,null,null,{"$f":"$K311","v":0}]
[null,{"$f":"$J312","v":0},null,null,null,null,{"$f":"$K312","v":0}]
[null,"D02 : AD HOC MAINTENANCE WORKS"]
[null,"TIME","LOCATION","DESCRIPTION OF AD HOC WORKS",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"COMPLETED IN "]
[null,null,null,null,null,null,"IN PORGRESS"]
[null,{"$f":"$J317/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K317","v":0}]
[null,{"$f":"$J318/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K318","v":0}]
[null,{"$f":"$J319/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K319","v":0}]
[null,{"$f":"$J320/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K320","v":0}]
[null,{"$f":"$J321/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K321","v":0}]
[null,"D03 : REPORT ON MAINTENANCE OCCURANCE"]
[null,"TIME","LOCATION","DESCRIPTION OF OCCURANCE",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"FOLLOW UP BY"]
[null,null,null,null,null,null,"RESOLVED BY"]
[null,{"$f":"$J326/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K326","v":0}]
[null,{"$f":"$J327/(24*60*60)","v":"00:00:00"},null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"SUMMARY OF","NO. OF REPORTED OCCURANCE",null,"NO. OF RESOLVED OCCURANCE",null,"NO. OF UNRESOLVED OCCURANCE"]
[null,"REPORT",{"$f":"COUNTIF($B$326:$B$335,\">0\")","v":0},null,{"$f":"COUNTIF($K$326:$K$335,\"R*\")","v":0},null,{"$f":"$C$337-$E$337","v":0}]
[]
[null,"E : TECHNICAL ( AUDIO VIDEO COMPUTER SYSTEM )"]
[null,"E01 : SCHEDULED TECHNICAL WORKS"]
[null,"SHIFT","LOCATION","DESCRIPTION OF SCHEDULED WORKS",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"CANCELLED DUE "]
[null,null,null,null,null,null,"COMPLETED"]
[null,null,null,null,null,null,"POSTPONED TO"]
[null,{"$f":"$J345","v":0},null,null,null,null,{"$f":"$K345","v":0}]
[null,{"$f":"$J346","v":0},null,null,null,null,{"$f":"$K346","v":0}]
[null,{"$f":"$J347","v":0},null,null,null,null,{"$f":"$K347","v":0}]
[null,{"$f":"$J348","v":0},null,null,null,null,{"$f":"$K348","v":0}]
[null,{"$f":"$J349","v":0},null,null,null,null,{"$f":"$K349","v":0}]
[null,"E02 : AD HOC TECHNICAL WORKS"]
[null,"TIME","LOCATION","DESCRIPTION OF AD HOC WORKS",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"COMPLETED IN "]
[null,null,null,null,null,null,"IN PROGRESS"]
[null,{"$f":"$J354/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K354","v":0}]
[null,{"$f":"$J355/(24*60*60)","v":"00:00:00"},null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,{"$f":"$J359/(24*60*60)","v":"00:00:00"},null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"E03 : REPORT ON TECHNICAL OCCURANCE"]
[null,"TIME","LOCATION","DESCRIPTION OF OCCURANCE",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"FOLLOW UP BY"]
[null,null,null,null,null,null,"RESOLVED BY"]
[null,{"$f":"$J368/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K368","v":0}]
[null,{"$f":"$J369/(24*60*60)","v":"00:00:00"},null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"SUMMARY OF","NO. OF REPORTED OCCURANCE",null,"NO. OF RESOLVED OCCURANCE",null,"NO. OF UNRESOLVED OCCURANCE"]
[null,"REPORT",{"$f":"COUNTIF($B$368:$B$377,\">0\")","v":0},null,{"$f":"COUNTIF($K$368:$K$377,\"R*\")","v":0},null,{"$f":"$C$379-$E$379","v":0}]
[null,"E04 : REPORT ON SONG REQUESTS BY CUSTOMER"]
[null,"LANGUAGE OF SONG REQUESTED"]
[null,"CANTONESE","CHINESE","ENGLISH","HOKKIEN","JAPANESE / KOREAN","MALAY","OTHERS"]
[null,"粤语","国语","英语","闽南","日语 / 韩语","马来语","其它"]
[]
[null,"TOTAL NO. OF SONG REQUESTED",null,{"$f":"SUM(B384:H384)","v":0},"LIST OF SONG REQUESTED SUBMITTED TO AVC DEPARTMENT ?",null,null,{"$f":"IF($K$385=TRUE,\"YES\",\"NO\")","v":"NO"},null,"SONG UPDATE"]
[null,"E05 : REPORT ON COMPLAINTS OF SONG QUALITY BY CUSTOMER"]
[null,"SONG TITLE",null,"SINGER",null,"DESCRIPTION OF COMPLAINT",null,null,null,"DESCRIPTION OF COMPLAINT"]
[null,null,null,null,null,"MTV HAS BAD PICTURE QUALITY"]
[null,null,null,null,null,"MTV HAS BAD SOUND QUALITY"]
[null,null,null,null,null,"MTV HAS MISALIGNED ANALOG CHANNELS"]
[null,null,null,null,null,"MTV INFRINGES COPYRIGHTS"]
[null,null,null,null,null,"MTV IS NOT FOUND IN DATABASE"]
[null,null,null,null,null,"MTV IS NOT IN OR WRONG COUNTRY CATEGORY"]
[null,null,null,null,null,"MTV IS NOT IN OR WRONG SEX CATEGORY"]
[null,null,null,null,null,"MTV IS NOT IN OR WRONG SINGER CATEGORY"]
[null,null,null,null,null,"MTV IS NOT IN OR WRONG WORD COUNT CATEGORY"]
[null,null,null,null,null,"MTV IS NOT KARAOKE-ENABLED"]
[null,null,null,null,null,"MTV IS NOT ORIGINAL"]
[null,null,null,null,null,"MTV IS WRONG FOR SONG (OR VICE VERSA)"]
[null,null,null,null,null,"MTV LAGS DURING PLAY"]
[]
[]
[null,null,null,null,null,{"$f":"$J403","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[null,"F : CUSTOMER SATISFACTION"]
[null,"F01 : RATINGS FROM FEEDBACK FORMS"]
[null,"AREA OF RATING","RATING",null,null,null,"TOTAL NO. OF","% OF \"POOR\""]
[null,null,"EXCELLENT","GOOD","NORMAL","POOR","RATINGS","RATING"]
[null,"RECEPTION",null,null,null,null,{"$f":"SUM($C418:$F418)","v":0},{"$f":"IFERROR($F418/$G418,\"\")","v":""}]
[null,"MV / AUDIO",null,null,null,null,0,""]
[null,"F&B",null,null,null,null,0,""]
[null,"OVERALL EXPERIENCE",null,null,null,null,0,""]
[null,null,null,null,null,null,0,""]
[null,"TOTAL",{"$f":"SUM(C$418:C$422)","v":0},{"$f":"SUM(D$418:D$422)","v":0},{"$f":"SUM(E$418:E$422)","v":0},{"$f":"SUM(F$418:F$422)","v":0},0,""]
[null,"% RATINGS",{"$f":"IFERROR(C$423/SUM($C$423:$F$423),\"\")","v":""},{"$f":"IFERROR(D$423/SUM($C$423:$F$423),\"\")","v":""},{"$f":"IFERROR(E$423/SUM($C$423:$F$423),\"\")","v":""},{"$f":"IFERROR(F$423/SUM($C$423:$F$423),\"\")","v":""}]
[null,"F02 : QUESTIONAIRE FROM FEEDBACK FORMS"]
[null,"ITEM","QUESTION",null,null,"YES","NO","% OF \"NOs\""]
[null,"Q01","WERE WE ABLE TO DELIGHT YOU WITH OUR SERVICES?",null,null,null,null,{"$f":"IFERROR($G427/($F427+$G427),0)","v":0}]
[null,"Q02","SHALL WE HAVE THE PLEASURE OF SEEING YOU AGAIN?",null,null,null,null,{"$f":"IFERROR($G428/($F428+$G428),0)","v":0}]
[null,"Q03",null,null,null,null,null,{"$f":"IFERROR($G429/($F429+$G429),0)","v":0}]
[null,"Q04",null,null,null,null,null,{"$f":"IFERROR($G430/($F430+$G430),0)","v":0}]
[null,"Q05",null,null,null,null,null,{"$f":"IFERROR($G431/($F431+$G431),0)","v":0}]
[null,"F03 : OTHER VALUABLE COMMENTS FROM CUSTOMERS"]
[null,"TYPE OF","DESCRIPTION OF COMPLIMENT J / COMPLAINT L",null,null,"PROPOSED ACTION",null,null,null,"TYPE OF COMMENTS","TYPE OF COMMENTS"]
[null,"COMMENT",null,null,null,null,null,null,null,"( LIST )","( SELECTED)"]
[null,{"$f":"$K435","v":0},null,null,null,null,null,null,null,"J"]
[null,0,null,null,null,null,null,null,null,"L"]
[null,0,null,null,null,null,null,null,null,"LL"]
[null,0,null,null,null,null,null,null,null,"LLL"]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,"TYPE OF COMMENT ",null,"J","L","LL","LLL","TOTAL"]
[null,"NO. OF COMMENT ACCORDING TO TYPES RECEIVED ",null,{"$f":"COUNTIF($K$435:$K$444,D$445)","v":0},{"$f":"COUNTIF($K$435:$K$444,E$445)","v":0},{"$f":"COUNTIF($K$435:$K$444,F$445)","v":0},{"$f":"COUNTIF($K$435:$K$444,G$445)","v":0},{"$f":"SUM($D446:$G446)","v":0}]
[null,"% OF COMMENT ACCORDING TO TYPES RECEIVED ",null,{"$f":"IFERROR(D$446/$H$446,\"\")","v":""},{"$f":"IFERROR(E$446/$H$446,\"\")","v":""},{"$f":"IFERROR(F$446/$H$446,\"\")","v":""},{"$f":"IFERROR(G$446/$H$446,\"\")","v":""}]
[]
[null,"G : OTHER SPECIAL INCIDENT(S) TO REPORT"]
[null,"TIME","LOCATION","DESCRIPTION OF OCCURANCE",null,null,"REMARKS",null,null,"TIME","REMARKS"]
[null,null,null,null,null,null,"FOLLOW UP BY"]
[null,null,null,null,null,null,"RESOLVED BY"]
[null,{"$f":"$J453/(24*60*60)","v":"00:00:00"},null,null,null,null,{"$f":"$K453","v":0}]
[null,{"$f":"$J454/(24*60*60)","v":"00:00:00"},null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]
[null,"00:00:00",null,null,null,null,0]