{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Data Items","Score Scenario 1","Score Scenario 2","Score Scenario 3","Results-Detailed","Results-Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,0,3,2],[1,0,1,2],[11,0,11,2],[0,0,0,2],[7,0,7,2]]}
["Disaster Recovery Priority Ranking Tool--Instructions"]
["The purpose of the Disaster Recovery Priority Ranking Tool is to assist managers in evaluating different initiatives in a systematic way.  "]
[]
["On the \"Data Items\" tab, you must do three things:"]
[null,"1)","Identify between two and ten disaster recover initiatives  you are considering.  Detailed descriptions of the initiatives are ideal.  "]
[null,"2)","Identify the criteria that are the most important for determining your disaster recovery priorities.  Too few or too many criteria may hamper effective prioritizing.  You must specify at least two and at most six criteria for determining which initiatives to do first."]
[null,"3)","Create one to three possible scenaros; for example best case, most-likely case, and worst case."]
["On each \"Score Scenario\" tab, you must do three things:"]
[null,"1)","Assign a point weight to each criterion, representing the importance of the criterion.  The weights  must sum to 100 points."]
[null,"2)","Rate each initiative on the criteria, using a scale from 1 to 10: 1 = very weak (i.e., this initiative has the lowest rating on this criterion);   5 = neutral / medium (i.e., this initiative is okay, having a mid-level rating on this criterion); 10 = very strong (i.e., this initiative has a very strong rating on this evaluation criteria). "]
[null,"3)","Identify the minimum acceptable score for each criterion (see the step above for scoring details).  This should reflect the minimum level of performance you deem acceptable for a criterion under the scenario."]
["Having performed the six steps listed above, you will find the results of the analysis on the \"Results-Detailed\" and \"Results-Summary\" tabs.  On these sheets you will see your final initiative matrix, which provides the weighted rating of your initiatives on the criteria you specified.  The initiatives with the highest total score is the best, i.e., the one that should be tackled first.  Any initiatives that do not meet the minimum score on a criterion (see step 4, above) will be flagged on the \"Results-Detailed\" tab."]
[]
[]
[]
[]
["    "]
[]
[]
[]
[]
[" "]

{"sheet":"Data Items","index":1,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,2,7,3],[7,5,7,7],[4,5,4,7],[0,3,0,4],[1,3,1,4],[2,3,2,4],[5,5,5,7],[6,5,6,7],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,5,8,7],[11,5,11,7],[15,2,15,3],[12,5,12,7],[13,5,13,7],[14,5,14,7],[15,5,15,7],[9,5,9,7],[10,5,10,7],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[null,null,null,"# Criteria:",null,6,"[Select 2-6]"]
[null,null,null,"#  Initiatives:",null,4,"[Select 2-10]"]
[null,null,null,"# Scenarios:",null,3,"[Select 1-3]"]
[]
["Item",null,"Evaluation Criteria",null,null,"Initiatives",null,null,null,"Scenarios",null,{"$f":"COUNTA(INDIRECT(\"c8:c\"&(F2+7)))","v":4}]
[1,null,"Lowers operating costs and protects short-term liquidity",null,null,"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans",null,null,null,"Best Case",null,{"$f":"COUNTA(H6:J9)","v":3},null,{"$f":"C6","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"F6","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"}]
[2,null,"Assures staff health & wellbeing",null,null,"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs",null,null,null,"Most Likely Case",null,null,null,{"$f":"C7","v":"Assures staff health & wellbeing"},{"$f":"F7","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"}]
[3,null,"Reduces guest fear in travelling and lifts consumer demand (occupancy)",null,null,"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements",null,null,null,"Worst Case ",null,null,null,"Reduces guest fear in travelling and lifts consumer demand (occupancy)","Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"]
[4,null,"Supports community & governmental guidelines and parameters",null,null,"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods",null,null,null,null,null,null,null,"Supports community & governmental guidelines and parameters","Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"]
[5,null,"Builds on our core competencies",null,null,null,null,null,null,null,null,null,null,"Builds on our core competencies",0]
[6,null,"Differentiates the hotel compared to the competition",null,null,null,null,null,null,null,null,null,null,"Differentiates the hotel compared to the competition",0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,null,"a",null,null,null,null,null,null,null,null,null,null,"a",0]
[null,null,{"$f":"IF(COUNTA(INDIRECT(\"c6:c\" &5+F1))<F1,\"Some criteria are missing descriptions\",\"\")","v":""},null,null,{"$f":"IF(COUNTA(INDIRECT(\"f6:f\" &5+F2))<F2,\"Some initiatives are missing descriptions\",\"\")","v":""},null,null,null,{"$f":"IF(COUNTA(INDIRECT(\"j6:j\" &5+F3))<F3,\"Some scenarios are missing descriptions\",\"\")","v":""},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},""]

{"sheet":"Score Scenario 1","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,2,16,4],[17,2,17,4],[0,0,0,8],[5,0,8,0]]}
[{"$f":"\"Scenario: \" &'Data Items'!J6","v":"Scenario: Best Case"}]
[]
[null,null,"Evaluation Criteria:",{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C6,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN('Data Items'!C7)>0,'Data Items'!C7,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(LEN('Data Items'!C8)>0,'Data Items'!C8,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(LEN('Data Items'!C9)>0,'Data Items'!C9,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(LEN('Data Items'!C10)>0,'Data Items'!C10,\"\")","v":"Builds on our core competencies"},{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C11,\"\")","v":"Differentiates the hotel compared to the competition"},"Total",null,{"$f":"SUM(D4:G4)","v":61}]
[null,null,"Weight (out of 100 pts):",17,21,14,9,24,15,{"$f":"SUM(D4:I4)","v":100},{"$f":"IF(J4<>100,\"  The weights should sum to 100\",\"\")","v":""},{"$f":"COUNTA(D3:I3)","v":6}]
[null,null,"Minimum Desired Score (/10):",4,5,5,2,6,5,null,null,{"$f":"COUNTA(INDIRECT(\"c8:c\"&(#REF!+7)))","v":1}]
["Initiatives",1,{"$f":"IF(LEN('Data Items'!F6)>0,'Data Items'!F6,\"\")","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},5,10,10,9,5,8,null,null,{"$f":"COUNTA(D6:I9)","v":24}]
[null,2,{"$f":"IF(LEN('Data Items'!F7)>0,'Data Items'!F7,\"\")","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},4,9,7,9,8,8]
[null,3,{"$f":"IF(LEN('Data Items'!F8)>0,'Data Items'!F8,\"\")","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},5,7,8,7,8,7]
[null,4,{"$f":"IF(LEN('Data Items'!F9)>0,'Data Items'!F9,\"\")","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},10,6,6,6,8,7]
[null,5,{"$f":"IF(LEN('Data Items'!F10)>0,'Data Items'!F10,\"\")","v":""},5,10,4,9,5,8]
[null,6,{"$f":"IF(LEN('Data Items'!F11)>0,'Data Items'!F11,\"\")","v":""},4,9,8,9,8,8]
[null,7,{"$f":"IF(LEN('Data Items'!F12)>0,'Data Items'!F12,\"\")","v":""},5,7,9,7,8,7]
[null,8,{"$f":"IF(LEN('Data Items'!F13)>0,'Data Items'!F13,\"\")","v":""},10,6,3,6,8,7]
[null,9,{"$f":"IF(LEN('Data Items'!F14)>0,'Data Items'!F14,\"\")","v":""}]
[null,10,{"$f":"IF(LEN('Data Items'!F15)>0,'Data Items'!F15,\"\")","v":""}]
[null,null,8,null,null,null,null,8]
[null,null,"Provide values in the cells of this color"]
[null,null,"Rate (score) the initiatives in the cells of this color, on a scale of 0 (worst) to 10 (best)"]

{"sheet":"Score Scenario 2","index":3,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8],[16,2,16,4],[17,2,17,4],[5,0,8,0]]}
[{"$f":"\"Scenario: \" &'Data Items'!J7","v":"Scenario: Most Likely Case"}]
[]
[null,null,"Evaluation Criteria:",{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C6,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN('Data Items'!C7)>0,'Data Items'!C7,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(LEN('Data Items'!C8)>0,'Data Items'!C8,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(LEN('Data Items'!C9)>0,'Data Items'!C9,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(LEN('Data Items'!C10)>0,'Data Items'!C10,\"\")","v":"Builds on our core competencies"},{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C11,\"\")","v":"Differentiates the hotel compared to the competition"},"Total",null,{"$f":"SUM(D4:G4)","v":70}]
[null,null,"Weight (out of 100 pts):",10,15,20,25,19,11,{"$f":"SUM(D4:I4)","v":100},{"$f":"IF(J4<>100,\"  The weights should sum to 100\",\"\")","v":""},{"$f":"COUNTA(D3:I3)","v":6}]
[null,null,"Minimum Desired Score (/10):",1,2,3,4,5,6,null,null,{"$f":"COUNTA(INDIRECT(\"c8:c\"&(#REF!+7)))","v":1}]
["Initiatives",1,{"$f":"IF(LEN('Data Items'!F6)>0,'Data Items'!F6,\"\")","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},2,9,9,8,4,6,null,null,{"$f":"COUNTA(D6:I9)","v":24}]
[null,2,{"$f":"IF(LEN('Data Items'!F7)>0,'Data Items'!F7,\"\")","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},7,6,7,5,1,7]
[null,3,{"$f":"IF(LEN('Data Items'!F8)>0,'Data Items'!F8,\"\")","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},4,3,8,6,8,8]
[null,4,{"$f":"IF(LEN('Data Items'!F9)>0,'Data Items'!F9,\"\")","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},9,1,2,3,6,5]
[null,5,{"$f":"IF(LEN('Data Items'!F10)>0,'Data Items'!F10,\"\")","v":""},2,7,9,8,4,6]
[null,6,{"$f":"IF(LEN('Data Items'!F11)>0,'Data Items'!F11,\"\")","v":""},7,5,7,5,1,7]
[null,7,{"$f":"IF(LEN('Data Items'!F12)>0,'Data Items'!F12,\"\")","v":""},4,7,8,6,8,8]
[null,8,{"$f":"IF(LEN('Data Items'!F13)>0,'Data Items'!F13,\"\")","v":""},9,2,2,3,6,5]
[null,9,{"$f":"IF(LEN('Data Items'!F14)>0,'Data Items'!F14,\"\")","v":""}]
[null,10,{"$f":"IF(LEN('Data Items'!F15)>0,'Data Items'!F15,\"\")","v":""}]
[null,null,8]
[null,null,"Provide values in the cells of this color"]
[null,null,"Rate (score) the initiatives in the cells of this color, on a scale of 0 (worst) to 10 (best)"]

{"sheet":"Score Scenario 3","index":4,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8],[16,2,16,4],[17,2,17,4],[5,0,8,0]]}
[{"$f":"\"Scenario: \" &'Data Items'!J8","v":"Scenario: Worst Case "}]
[]
[null,null,"Evaluation Criteria:",{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C6,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN('Data Items'!C7)>0,'Data Items'!C7,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(LEN('Data Items'!C8)>0,'Data Items'!C8,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(LEN('Data Items'!C9)>0,'Data Items'!C9,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(LEN('Data Items'!C10)>0,'Data Items'!C10,\"\")","v":"Builds on our core competencies"},{"$f":"IF(LEN('Data Items'!C6)>0,'Data Items'!C11,\"\")","v":"Differentiates the hotel compared to the competition"},"Total",null,{"$f":"SUM(D4:G4)","v":74}]
[null,null,"Weight (out of 100 pts):",20,19,18,17,16,10,{"$f":"SUM(D4:I4)","v":100},{"$f":"IF(J4<>100,\"  The weights should sum to 100\",\"\")","v":""},{"$f":"COUNTA(D3:I3)","v":6}]
[null,null,"Minimum Desired Score (/10):",5,5,5,5,5,5,null,null,{"$f":"COUNTA(INDIRECT(\"c8:c\"&(#REF!+7)))","v":1}]
["Initiatives",1,{"$f":"IF(LEN('Data Items'!F6)>0,'Data Items'!F6,\"\")","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},2,7,6,7,4,5,null,null,{"$f":"COUNTA(D6:I9)","v":24}]
[null,2,{"$f":"IF(LEN('Data Items'!F7)>0,'Data Items'!F7,\"\")","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},3,4,2,4,1,5]
[null,3,{"$f":"IF(LEN('Data Items'!F8)>0,'Data Items'!F8,\"\")","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},2,5,4,5,8,7]
[null,4,{"$f":"IF(LEN('Data Items'!F9)>0,'Data Items'!F9,\"\")","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},9,1,1,2,6,5]
[null,5,{"$f":"IF(LEN('Data Items'!F10)>0,'Data Items'!F10,\"\")","v":""},2,7,6,7,4,2]
[null,6,{"$f":"IF(LEN('Data Items'!F11)>0,'Data Items'!F11,\"\")","v":""},3,4,5,4,1,4]
[null,7,{"$f":"IF(LEN('Data Items'!F12)>0,'Data Items'!F12,\"\")","v":""},8,5,4,5,7,5]
[null,8,{"$f":"IF(LEN('Data Items'!F13)>0,'Data Items'!F13,\"\")","v":""},9,1,4,2,6,9]
[null,9,{"$f":"IF(LEN('Data Items'!F14)>0,'Data Items'!F14,\"\")","v":""}]
[null,10,{"$f":"IF(LEN('Data Items'!F15)>0,'Data Items'!F15,\"\")","v":""}]
[null,null,8]
[null,null,"Provide values in the cells of this color"]
[null,null,"Rate (score) the initiatives in the cells of this color, on a scale of 0 (worst) to 10 (best)"]

{"sheet":"Results-Detailed","index":5,"n_rows":13,"n_cols":86,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,3,0,4],[3,0,6,0]]}
[null,null,"Scenario:","Best Case",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Items'!J6","v":"Best Case"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(D1,O3:O5,0)","v":1},{"$f":"'Data Items'!J7","v":"Most Likely Case"},null,"scenario 1"]
[null,null,"Evaluation Criteria >                                                                                                   ",{"$f":"'Score Scenario 1'!D3","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"'Score Scenario 1'!E3","v":"Assures staff health & wellbeing"},{"$f":"'Score Scenario 1'!F3","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"'Score Scenario 1'!G3","v":"Supports community & governmental guidelines and parameters"},{"$f":"'Score Scenario 1'!H3","v":"Builds on our core competencies"},{"$f":"'Score Scenario 1'!I3","v":"Differentiates the hotel compared to the competition"},null,"Overall Score (/100)","Relative Score","Potential Problems with this Initiative",null,{"$f":"'Data Items'!J6","v":"Best Case"},{"$f":"'Data Items'!J8","v":"Worst Case "},null,"Evaluation Criteria >                                                                                                   ",{"$f":"'Score Scenario 1'!D3","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"'Score Scenario 1'!E3","v":"Assures staff health & wellbeing"},{"$f":"'Score Scenario 1'!F3","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"'Score Scenario 1'!G3","v":"Supports community & governmental guidelines and parameters"},{"$f":"'Score Scenario 1'!H3","v":"Builds on our core competencies"},{"$f":"'Score Scenario 1'!I3","v":"Differentiates the hotel compared to the competition"},"Ovrl Scr","Rel Scr","Priority Rnk","Pot Prbs","Lrg-Sml",1,2,3,4,5,6,2,3,4,5,6,null,{"$f":"S3","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"T3","v":"Assures staff health & wellbeing"},"Reduces guest fear in travelling and lifts consumer demand (occupancy)","Supports community & governmental guidelines and parameters","Builds on our core competencies","Differentiates the hotel compared to the competition","Ovrl Scr","Rel Scr","Priority Rnk","Pot Prbs","Lrg-Sml",1,2,3,4,5,6,2,3,4,5,6,null,{"$f":"AP3","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"AQ3","v":"Assures staff health & wellbeing"},{"$f":"AR3","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"AS3","v":"Supports community & governmental guidelines and parameters"},{"$f":"AT3","v":"Builds on our core competencies"},{"$f":"AU3","v":"Differentiates the hotel compared to the competition"},"Ovrl Scr","Rel Scr","Priority Rnk","Pot Prbs","Lrg-Sml",1,2,3,4,5,6,2,3,4,5,6]
["Initiatives",{"$f":"IF(ScenarioSelected=1,MATCH(Q4,$AA$4:$AA$13,0),IF(ScenarioSelected=2,MATCH(Q4,$AX$4:$AX$13,0),MATCH(Q4,$BU$4:$BU$13,0)))","v":1},{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B4,0)","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B4,0)))","v":8.5},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B4,0)))","v":21},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B4,0)))","v":14},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B4,0)))","v":8.1},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B4,0)))","v":12},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B4,0)))","v":12},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B4,0)))","v":75.600000999999992},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B4,0)))","v":1},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B4,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B4,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B4,0)))","v":"Below the minimum desired score for: Builds on our core competencies"},null,{"$f":"'Data Items'!J7","v":"Most Likely Case"},"Initiatives",1,{"$f":"IF(LEN('Score Scenario 1'!C6)>0,'Score Scenario 1'!C6,\"\")","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D6/10","v":8.5},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E6/10","v":21},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F6/10","v":14},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G6/10","v":8.1},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H6/10","v":12},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I6/10","v":12},{"$f":"SUM(S4:X4)+0.000001*Q4","v":75.600000999999992},{"$f":"IF(Q4<='Data Items'!$F$2,Y4/MAX($Y$4:$Y$7),\"n/a\")","v":1},{"$f":"MATCH(Y4,$AC$4:$AC$7,0)","v":1},{"$f":"IF(LEN(AN4)>0,\"Below the minimum desired score for: \" &AN4,\"None!\")","v":"Below the minimum desired score for: Builds on our core competencies"},{"$f":"LARGE($Y$4:$Y$7,Q4)","v":75.600000999999992},{"$f":"IF(AND('Score Scenario 1'!D6<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E6<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F6<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G6<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H6<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 1'!I6<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},{"$f":"IF(LEN(AE4)>0,IF(LEN(AD4)>0,AD4&\"; \",\"\")&AE4,AD4)","v":""},{"$f":"IF(LEN(AF4)>0,IF(LEN(AJ4)>0,AJ4&\"; \",\"\")&AF4,AJ4)","v":""},{"$f":"IF(LEN(AG4)>0,IF(LEN(AK4)>0,AK4&\"; \",\"\")&AG4,AK4)","v":""},"Builds on our core competencies","Builds on our core competencies",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D6/10","v":2},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E6/10","v":13.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F6/10","v":18},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G6/10","v":20},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H6/10","v":7.6},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I6/10","v":6.6},{"$f":"SUM(AP4:AU4)+0.000001*Q4","v":67.700001},{"$f":"IF(Q4<='Data Items'!$F$2,AV4/MAX($AV$4:$AV$7),\"n/a\")","v":1},{"$f":"MATCH(AV4,$AZ$4:$AZ$7,0)","v":1},{"$f":"IF(LEN(BK4)>0,\"Below the minimum desired score for: \" &BK4,\"None!\")","v":"Below the minimum desired score for: Builds on our core competencies"},{"$f":"LARGE($AV$4:$AV$7,Q4)","v":67.700001},{"$f":"IF(AND('Score Scenario 2'!D6<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E6<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F6<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G6<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H6<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I6<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},{"$f":"IF(LEN(BB4)>0,IF(LEN(BA4)>0,BA4&\"; \",\"\")&BB4,BA4)","v":""},{"$f":"IF(LEN(BC4)>0,IF(LEN(BG4)>0,BG4&\"; \",\"\")&BC4,BG4)","v":""},{"$f":"IF(LEN(BD4)>0,IF(LEN(BH4)>0,BH4&\"; \",\"\")&BD4,BH4)","v":""},{"$f":"IF(LEN(BE4)>0,IF(LEN(BI4)>0,BI4&\"; \",\"\")&BE4,BI4)","v":"Builds on our core competencies"},{"$f":"IF(LEN(BF4)>0,IF(LEN(BJ4)>0,BJ4&\"; \",\"\")&BF4,BJ4)","v":"Builds on our core competencies"},null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D6/10","v":4},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E6/10","v":13.3},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F6/10","v":10.8},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G6/10","v":11.9},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H6/10","v":6.4},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I6/10","v":5},{"$f":"SUM(BM4:BR4)+0.000001*Q4","v":51.400000999999996},{"$f":"IF(Q4<='Data Items'!$F$2,BS4/MAX($BS$4:$BS$7),\"n/a\")","v":1},{"$f":"MATCH(BS4,$BW$4:$BW$7,0)","v":1},{"$f":"IF(LEN(CH4)>0,\"Below the minimum desired score for: \" &CH4,\"None!\")","v":"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Builds on our core competencies"},{"$f":"LARGE($BS$4:$BS$7,Q4)","v":51.400000999999996},{"$f":"IF(AND('Score Scenario 3'!D6<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E6<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!F6<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!G6<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!H6<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I6<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},{"$f":"IF(LEN(BY4)>0,IF(LEN(BX4)>0,BX4&\"; \",\"\")&BY4,BX4)","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN(BZ4)>0,IF(LEN(CD4)>0,CD4&\"; \",\"\")&BZ4,CD4)","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN(CA4)>0,IF(LEN(CE4)>0,CE4&\"; \",\"\")&CA4,CE4)","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(LEN(CB4)>0,IF(LEN(CF4)>0,CF4&\"; \",\"\")&CB4,CF4)","v":"Lowers operating costs and protects short-term liquidity; Builds on our core competencies"},{"$f":"IF(LEN(CC4)>0,IF(LEN(CG4)>0,CG4&\"; \",\"\")&CC4,CG4)","v":"Lowers operating costs and protects short-term liquidity; Builds on our core competencies"}]
[null,2,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B5,0)","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B5,0)))","v":6.8},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B5,0)))","v":18.899999999999999},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B5,0)))","v":9.8000000000000007},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B5,0)))","v":8.1},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B5,0)))","v":19.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B5,0)))","v":12},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B5,0)))","v":74.800001999999992},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B5,0)))","v":0.9894180027854762},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B5,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B5,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B5,0)))","v":"None!"},null,{"$f":"'Data Items'!J8","v":"Worst Case "},null,2,{"$f":"IF(LEN('Score Scenario 1'!C7)>0,'Score Scenario 1'!C7,\"\")","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D7/10","v":6.8},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E7/10","v":18.899999999999999},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F7/10","v":9.8000000000000007},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G7/10","v":8.1},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H7/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I7/10","v":12},{"$f":"SUM(S5:X5)+0.000001*Q5","v":74.800001999999992},{"$f":"IF(Q5<='Data Items'!$F$2,Y5/MAX($Y$4:$Y$7),\"n/a\")","v":0.9894180027854762},{"$f":"MATCH(Y5,$AC$4:$AC$7,0)","v":2},{"$f":"IF(LEN(AN5)>0,\"Below the minimum desired score for: \" &AN5,\"None!\")","v":"None!"},{"$f":"LARGE($Y$4:$Y$7,Q5)","v":74.800001999999992},{"$f":"IF(AND('Score Scenario 1'!D7<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E7<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F7<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G7<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H7<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I7<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},{"$f":"IF(LEN(AE5)>0,IF(LEN(AD5)>0,AD5&\"; \",\"\")&AE5,AD5)","v":""},{"$f":"IF(LEN(AF5)>0,IF(LEN(AJ5)>0,AJ5&\"; \",\"\")&AF5,AJ5)","v":""},{"$f":"IF(LEN(AG5)>0,IF(LEN(AK5)>0,AK5&\"; \",\"\")&AG5,AK5)","v":""},{"$f":"IF(LEN(AH5)>0,IF(LEN(AL5)>0,AL5&\"; \",\"\")&AH5,AL5)","v":""},{"$f":"IF(LEN(AI5)>0,IF(LEN(AM5)>0,AM5&\"; \",\"\")&AI5,AM5)","v":""},null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D7/10","v":7},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E7/10","v":9},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F7/10","v":14},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G7/10","v":12.5},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H7/10","v":1.9},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I7/10","v":7.7},{"$f":"SUM(AP5:AU5)+0.000001*Q5","v":52.100002000000003},{"$f":"IF(Q5<='Data Items'!$F$2,AV5/MAX($AV$4:$AV$7),\"n/a\")","v":0.76957165776112768},{"$f":"MATCH(AV5,$AZ$4:$AZ$7,0)","v":3},{"$f":"IF(LEN(BK5)>0,\"Below the minimum desired score for: \" &BK5,\"None!\")","v":"Below the minimum desired score for: Builds on our core competencies"},{"$f":"LARGE($AV$4:$AV$7,Q5)","v":63.500003},{"$f":"IF(AND('Score Scenario 2'!D7<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E7<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F7<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G7<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H7<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I7<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},{"$f":"IF(LEN(BB5)>0,IF(LEN(BA5)>0,BA5&\"; \",\"\")&BB5,BA5)","v":""},{"$f":"IF(LEN(BC5)>0,IF(LEN(BG5)>0,BG5&\"; \",\"\")&BC5,BG5)","v":""},"","Builds on our core competencies","Builds on our core competencies",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D7/10","v":6},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E7/10","v":7.6},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F7/10","v":3.6},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G7/10","v":6.8},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H7/10","v":1.6},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I7/10","v":5},{"$f":"SUM(BM5:BR5)+0.000001*Q5","v":30.600002},{"$f":"IF(Q5<='Data Items'!$F$2,BS5/MAX($BS$4:$BS$7),\"n/a\")","v":0.59533076662780615},{"$f":"MATCH(BS5,$BW$4:$BW$7,0)","v":4},{"$f":"IF(LEN(CH5)>0,\"Below the minimum desired score for: \" &CH5,\"None!\")","v":"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies"},{"$f":"LARGE($BS$4:$BS$7,Q5)","v":49.000003},{"$f":"IF(AND('Score Scenario 3'!D7<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E7<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F7<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G7<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H7<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I7<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},{"$f":"IF(LEN(BY5)>0,IF(LEN(BX5)>0,BX5&\"; \",\"\")&BY5,BX5)","v":"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing"},{"$f":"IF(LEN(BZ5)>0,IF(LEN(CD5)>0,CD5&\"; \",\"\")&BZ5,CD5)","v":"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies"]
[null,4,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B6,0)","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B6,0)))","v":17},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B6,0)))","v":12.6},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B6,0)))","v":8.4},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B6,0)))","v":5.4},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B6,0)))","v":19.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B6,0)))","v":10.5},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B6,0)))","v":73.100003999999998},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B6,0)))","v":0.96693125705117389},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B6,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B6,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B6,0)))","v":"None!"},null,null,null,3,{"$f":"IF(LEN('Score Scenario 1'!C8)>0,'Score Scenario 1'!C8,\"\")","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D8/10","v":8.5},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E8/10","v":14.7},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F8/10","v":11.2},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G8/10","v":6.3},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H8/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I8/10","v":10.5},70.400002999999998,{"$f":"IF(Q6<='Data Items'!$F$2,Y6/MAX($Y$4:$Y$7),\"n/a\")","v":0.93121695858178632},{"$f":"MATCH(Y6,$AC$4:$AC$7,0)","v":4},"None!",{"$f":"LARGE($Y$4:$Y$7,Q6)","v":73.100003999999998},{"$f":"IF(AND('Score Scenario 1'!D8<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E8<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F8<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G8<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H8<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I8<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","","","","",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D8/10","v":4},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E8/10","v":4.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F8/10","v":16},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G8/10","v":15},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H8/10","v":15.2},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I8/10","v":8.8000000000000007},63.500003,{"$f":"IF(Q6<='Data Items'!$F$2,AV6/MAX($AV$4:$AV$7),\"n/a\")","v":0.93796162573173369},{"$f":"MATCH(AV6,$AZ$4:$AZ$7,0)","v":2},"None!",{"$f":"LARGE($AV$4:$AV$7,Q6)","v":52.100002000000003},{"$f":"IF(AND('Score Scenario 2'!D8<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E8<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F8<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G8<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H8<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!I8<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},"","","","","",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D8/10","v":4},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E8/10","v":9.5},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F8/10","v":7.2},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G8/10","v":8.5},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H8/10","v":12.8},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I8/10","v":7},49.000003,{"$f":"IF(Q6<='Data Items'!$F$2,BS6/MAX($BS$4:$BS$7),\"n/a\")","v":0.95330743281503061},{"$f":"MATCH(BS6,$BW$4:$BW$7,0)","v":2},"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Reduces guest fear in travelling and lifts consumer demand (occupancy)",{"$f":"LARGE($BS$4:$BS$7,Q6)","v":39.700003999999993},{"$f":"IF(AND('Score Scenario 3'!D8<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E8<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!F8<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G8<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!H8<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!I8<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},"Lowers operating costs and protects short-term liquidity","Lowers operating costs and protects short-term liquidity; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Reduces guest fear in travelling and lifts consumer demand (occupancy)"]
[null,3,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B7,0)","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B7,0)))","v":8.5},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B7,0)))","v":14.7},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B7,0)))","v":11.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B7,0)))","v":6.3},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B7,0)))","v":19.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B7,0)))","v":10.5},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B7,0)))","v":70.400002999999998},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B7,0)))","v":0.93121695858178632},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B7,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B7,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B7,0)))","v":"None!"},null,null,null,4,{"$f":"IF(LEN('Score Scenario 1'!C9)>0,'Score Scenario 1'!C9,\"\")","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D9/10","v":17},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E9/10","v":12.6},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F9/10","v":8.4},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G9/10","v":5.4},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H9/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I9/10","v":10.5},73.100003999999998,{"$f":"IF(Q7<='Data Items'!$F$2,Y7/MAX($Y$4:$Y$7),\"n/a\")","v":0.96693125705117389},{"$f":"MATCH(Y7,$AC$4:$AC$7,0)","v":3},"None!",{"$f":"LARGE($Y$4:$Y$7,Q7)","v":70.400002999999998},{"$f":"IF(AND('Score Scenario 1'!D9<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E9<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F9<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G9<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H9<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I9<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","","","","",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D9/10","v":9},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E9/10","v":1.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F9/10","v":4},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G9/10","v":7.5},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H9/10","v":11.4},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I9/10","v":5.5},38.900003999999996,{"$f":"IF(Q7<='Data Items'!$F$2,AV7/MAX($AV$4:$AV$7),\"n/a\")","v":0.57459384675636849},{"$f":"MATCH(AV7,$AZ$4:$AZ$7,0)","v":4},"Below the minimum desired score for: Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Differentiates the hotel compared to the competition",{"$f":"LARGE($AV$4:$AV$7,Q7)","v":38.900003999999996},{"$f":"IF(AND('Score Scenario 2'!D9<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E9<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 2'!F9<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 2'!G9<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 2'!H9<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!I9<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Assures staff health & wellbeing","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D9/10","v":18},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E9/10","v":1.9},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F9/10","v":1.8},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G9/10","v":3.4},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H9/10","v":9.6},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I9/10","v":5},39.700003999999993,{"$f":"IF(Q7<='Data Items'!$F$2,BS7/MAX($BS$4:$BS$7),\"n/a\")","v":0.77237360365031893},{"$f":"MATCH(BS7,$BW$4:$BW$7,0)","v":3},"Below the minimum desired score for: Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters",{"$f":"LARGE($BS$4:$BS$7,Q7)","v":30.600002},{"$f":"IF(AND('Score Scenario 3'!D9<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!E9<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F9<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G9<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H9<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!I9<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},"Assures staff health & wellbeing","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters"]
[null,{"$error":"#N/A"},{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B8,0)","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B8,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B8,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B8,0)))","v":{"$error":"#N/A"}},null,null,null,5,{"$f":"IF(LEN('Score Scenario 1'!C10)>0,'Score Scenario 1'!C10,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D10/10","v":8.5},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E10/10","v":21},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F10/10","v":5.6},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G10/10","v":8.1},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H10/10","v":12},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I10/10","v":12},67.200005000000004,{"$f":"IF(Q8<='Data Items'!$F$2,Y8/MAX($Y$4:$Y$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(Y8,$AC$4:$AC$9,0)","v":6},"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy); Builds on our core competencies",{"$f":"LARGE($Y$4:$Y$9,Q8)","v":70.400002999999998},{"$f":"IF(AND('Score Scenario 1'!D10<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E10<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F10<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 1'!G10<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H10<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 1'!I10<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy); Builds on our core competencies","Reduces guest fear in travelling and lifts consumer demand (occupancy); Builds on our core competencies",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D10/10","v":2},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E10/10","v":10.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F10/10","v":18},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G10/10","v":20},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H10/10","v":7.6},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I10/10","v":6.6},64.700005000000004,{"$f":"IF(Q8<='Data Items'!$F$2,AV8/MAX($AV$4:$AV$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(AV8,$AZ$4:$AZ$9,0)","v":{"$error":"#N/A"}},"Below the minimum desired score for: Builds on our core competencies",{"$f":"LARGE($AV$4:$AV$9,Q8)","v":50.600006},{"$f":"IF(AND('Score Scenario 2'!D10<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E10<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F10<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G10<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H10<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I10<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},"","","","Builds on our core competencies","Builds on our core competencies",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D10/10","v":4},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E10/10","v":13.3},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F10/10","v":10.8},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G10/10","v":11.9},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H10/10","v":6.4},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I10/10","v":2},48.400005,{"$f":"IF(Q8<='Data Items'!$F$2,BS8/MAX($BS$4:$BS$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(BS8,$BW$4:$BW$9,0)","v":{"$error":"#N/A"}},"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Builds on our core competencies; Differentiates the hotel compared to the competition",{"$f":"LARGE($BS$4:$BS$9,Q8)","v":35.000005999999999},{"$f":"IF(AND('Score Scenario 3'!D10<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E10<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!F10<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!G10<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!H10<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I10<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity","Lowers operating costs and protects short-term liquidity","Lowers operating costs and protects short-term liquidity","Lowers operating costs and protects short-term liquidity; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Builds on our core competencies; Differentiates the hotel compared to the competition"]
[null,5,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B9,0)","v":""},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B9,0)))","v":8.5},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B9,0)))","v":21},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B9,0)))","v":5.6},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B9,0)))","v":8.1},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B9,0)))","v":12},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B9,0)))","v":12},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B9,0)))","v":67.200005000000004},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B9,0)))","v":"n/a"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B9,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B9,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B9,0)))","v":"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy); Builds on our core competencies"},null,null,null,6,{"$f":"IF(LEN('Score Scenario 1'!C11)>0,'Score Scenario 1'!C11,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D11/10","v":6.8},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E11/10","v":18.899999999999999},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F11/10","v":11.2},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G11/10","v":8.1},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H11/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I11/10","v":12},76.200006000000002,{"$f":"IF(Q9<='Data Items'!$F$2,Y9/MAX($Y$4:$Y$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(Y9,$AC$4:$AC$9,0)","v":{"$error":"#N/A"}},"None!",{"$f":"LARGE($Y$4:$Y$9,Q9)","v":67.200005000000004},{"$f":"IF(AND('Score Scenario 1'!D11<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E11<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F11<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G11<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H11<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I11<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","","","","",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D11/10","v":7},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E11/10","v":7.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F11/10","v":14},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G11/10","v":12.5},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H11/10","v":1.9},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I11/10","v":7.7},50.600006,{"$f":"IF(Q9<='Data Items'!$F$2,AV9/MAX($AV$4:$AV$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(AV9,$AZ$4:$AZ$9,0)","v":5},"Below the minimum desired score for: Builds on our core competencies",{"$f":"LARGE($AV$4:$AV$9,Q9)","v":38.900003999999996},{"$f":"IF(AND('Score Scenario 2'!D11<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E11<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F11<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G11<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H11<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I11<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},"","","","Builds on our core competencies","Builds on our core competencies",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D11/10","v":6},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E11/10","v":7.6},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F11/10","v":9},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G11/10","v":6.8},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H11/10","v":1.6},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I11/10","v":4},35.000005999999999,{"$f":"IF(Q9<='Data Items'!$F$2,BS9/MAX($BS$4:$BS$9),\"n/a\")","v":"n/a"},{"$f":"MATCH(BS9,$BW$4:$BW$9,0)","v":5},"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",{"$f":"LARGE($BS$4:$BS$9,Q9)","v":30.600002},{"$f":"IF(AND('Score Scenario 3'!D11<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E11<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F11<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!G11<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H11<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I11<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition"]
[null,8,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B10,0)","v":""},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B10,0)))","v":17},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B10,0)))","v":12.6},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B10,0)))","v":4.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B10,0)))","v":5.4},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B10,0)))","v":19.2},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B10,0)))","v":10.5},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B10,0)))","v":68.900008},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B10,0)))","v":"n/a"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B10,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B10,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B10,0)))","v":"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy)"},null,null,null,7,{"$f":"IF(LEN('Score Scenario 1'!C12)>0,'Score Scenario 1'!C12,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D12/10","v":8.5},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E12/10","v":14.7},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F12/10","v":12.6},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G12/10","v":6.3},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H12/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I12/10","v":10.5},71.800006999999994,{"$f":"IF(Q10<='Data Items'!$F$2,Y10/MAX($Y$4:$Y$13),\"n/a\")","v":"n/a"},{"$f":"MATCH(Y10,$AC$4:$AC$13,0)","v":{"$error":"#N/A"}},"None!",{"$f":"LARGE($Y$4:$Y$13,Q10)","v":68.900008},{"$f":"IF(AND('Score Scenario 1'!D12<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E12<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F12<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!G12<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H12<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I12<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","","","","",{"$f":"Q10<='Data Items'!$F$1","v":false},{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D12/10","v":4},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E12/10","v":10.5},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F12/10","v":16},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G12/10","v":15},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H12/10","v":15.2},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I12/10","v":8.8000000000000007},69.500006999999997,{"$f":"IF(Q10<='Data Items'!$F$2,AV10/MAX($AV$4:$AV$13),\"n/a\")","v":"n/a"},{"$f":"MATCH(AV10,$AZ$4:$AZ$13,0)","v":{"$error":"#N/A"}},"None!",{"$f":"LARGE($AV$4:$AV$13,Q10)","v":40.400008},{"$f":"IF(AND('Score Scenario 2'!D12<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E12<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F12<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!G12<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!H12<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!I12<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":""},"","","","","",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D12/10","v":16},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E12/10","v":9.5},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F12/10","v":7.2},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G12/10","v":8.5},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H12/10","v":11.2},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I12/10","v":5},57.400007000000002,{"$f":"IF(Q10<='Data Items'!$F$2,BS10/MAX($BS$4:$BS$13),\"n/a\")","v":"n/a"},{"$f":"MATCH(BS10,$BW$4:$BW$13,0)","v":{"$error":"#N/A"}},"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy)",{"$f":"LARGE($BS$4:$BS$13,Q10)","v":35.000005999999999},{"$f":"IF(AND('Score Scenario 3'!D12<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!E12<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!F12<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G12<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!H12<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!I12<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},"","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)"]
[null,{"$error":"#N/A"},{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B11,0)","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B11,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B11,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B11,0)))","v":{"$error":"#N/A"}},null,null,null,8,{"$f":"IF(LEN('Score Scenario 1'!C13)>0,'Score Scenario 1'!C13,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D13/10","v":17},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E13/10","v":12.6},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F13/10","v":4.2},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G13/10","v":5.4},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H13/10","v":19.2},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I13/10","v":10.5},68.900008,{"$f":"IF(Q11<='Data Items'!$F$2,Y11/MAX($Y$4:$Y$13),\"n/a\")","v":"n/a"},7,"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy)",67.200005000000004,{"$f":"IF(AND('Score Scenario 1'!D13<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!E13<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!F13<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 1'!G13<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!H13<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 1'!I13<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":""},"","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy)",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D13/10","v":9},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E13/10","v":3},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F13/10","v":4},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G13/10","v":7.5},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H13/10","v":11.4},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I13/10","v":5.5},40.400008,{"$f":"IF(Q11<='Data Items'!$F$2,AV11/MAX($AV$4:$AV$13),\"n/a\")","v":"n/a"},7,"Below the minimum desired score for: Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Differentiates the hotel compared to the competition",38.900003999999996,{"$f":"IF(AND('Score Scenario 2'!D13<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!E13<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!F13<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 2'!G13<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 2'!H13<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 2'!I13<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":"Differentiates the hotel compared to the competition"},"","Reduces guest fear in travelling and lifts consumer demand (occupancy)","Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D13/10","v":18},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E13/10","v":1.9},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F13/10","v":7.2},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G13/10","v":3.4},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H13/10","v":9.6},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I13/10","v":9},49.100007999999995,{"$f":"IF(Q11<='Data Items'!$F$2,BS11/MAX($BS$4:$BS$13),\"n/a\")","v":"n/a"},{"$error":"#N/A"},"Below the minimum desired score for: Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters",30.600002,{"$f":"IF(AND('Score Scenario 3'!D13<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!E13<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F13<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G13<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H13<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":""},{"$f":"IF(AND('Score Scenario 3'!I13<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":""},"Assures staff health & wellbeing","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters"]
[null,10,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B12,0)","v":""},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B12,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B12,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B12,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B12,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B12,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B12,0)))","v":0},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B12,0)))","v":9.9999999999999991E-6},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B12,0)))","v":"n/a"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B12,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B12,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B12,0)))","v":"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition"},null,null,null,9,{"$f":"IF(LEN('Score Scenario 1'!C14)>0,'Score Scenario 1'!C14,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D14/10","v":0},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E14/10","v":0},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F14/10","v":0},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G14/10","v":0},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H14/10","v":0},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I14/10","v":0},9.0000000000000002E-6,{"$f":"IF(Q12<='Data Items'!$F$2,Y12/MAX($Y$4:$Y$13),\"n/a\")","v":"n/a"},10,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.9999999999999991E-6,{"$f":"IF(AND('Score Scenario 1'!D14<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 1'!E14<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 1'!F14<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 1'!G14<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 1'!H14<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 1'!I14<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D14/10","v":0},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E14/10","v":0},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F14/10","v":0},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G14/10","v":0},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H14/10","v":0},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I14/10","v":0},9.0000000000000002E-6,{"$f":"IF(Q12<='Data Items'!$F$2,AV12/MAX($AV$4:$AV$13),\"n/a\")","v":"n/a"},10,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.9999999999999991E-6,{"$f":"IF(AND('Score Scenario 2'!D14<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 2'!E14<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 2'!F14<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 2'!G14<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 2'!H14<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I14<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D14/10","v":0},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E14/10","v":0},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F14/10","v":0},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G14/10","v":0},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H14/10","v":0},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I14/10","v":0},9.0000000000000002E-6,{"$f":"IF(Q12<='Data Items'!$F$2,BS12/MAX($BS$4:$BS$13),\"n/a\")","v":"n/a"},10,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.9999999999999991E-6,{"$f":"IF(AND('Score Scenario 3'!D14<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E14<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F14<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G14<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H14<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I14<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition"]
[null,9,{"$f":"OFFSET('Results-Detailed'!R$3,'Results-Detailed'!B13,0)","v":""},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!S$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AP$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BM$3,'Results-Detailed'!$B13,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!T$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AQ$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BN$3,'Results-Detailed'!$B13,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!U$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AR$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BO$3,'Results-Detailed'!$B13,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!V$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AS$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BP$3,'Results-Detailed'!$B13,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!W$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AT$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BQ$3,'Results-Detailed'!$B13,0)))","v":0},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!X$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AU$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BR$3,'Results-Detailed'!$B13,0)))","v":0},null,{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Y$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AV$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BS$3,'Results-Detailed'!$B13,0)))","v":9.0000000000000002E-6},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!Z$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AW$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BT$3,'Results-Detailed'!$B13,0)))","v":"n/a"},{"$f":"IF(ScenarioSelected=1,OFFSET('Results-Detailed'!AB$3,'Results-Detailed'!$B13,0),IF(ScenarioSelected=2,OFFSET('Results-Detailed'!AY$3,'Results-Detailed'!$B13,0),OFFSET('Results-Detailed'!BV$3,'Results-Detailed'!$B13,0)))","v":"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition"},null,null,null,10,{"$f":"IF(LEN('Score Scenario 1'!C15)>0,'Score Scenario 1'!C15,\"\")","v":""},{"$f":"'Score Scenario 1'!D$4*'Score Scenario 1'!D15/10","v":0},{"$f":"'Score Scenario 1'!E$4*'Score Scenario 1'!E15/10","v":0},{"$f":"'Score Scenario 1'!F$4*'Score Scenario 1'!F15/10","v":0},{"$f":"'Score Scenario 1'!G$4*'Score Scenario 1'!G15/10","v":0},{"$f":"'Score Scenario 1'!H$4*'Score Scenario 1'!H15/10","v":0},{"$f":"'Score Scenario 1'!I$4*'Score Scenario 1'!I15/10","v":0},9.9999999999999991E-6,{"$f":"IF(Q13<='Data Items'!$F$2,Y13/MAX($Y$4:$Y$13),\"n/a\")","v":"n/a"},9,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.0000000000000002E-6,{"$f":"IF(AND('Score Scenario 1'!D15<'Score Scenario 1'!D$5,AD$3<='Data Items'!CriteriaCount),S$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 1'!E15<'Score Scenario 1'!E$5,AE$3<='Data Items'!CriteriaCount),T$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 1'!F15<'Score Scenario 1'!F$5,AF$3<='Data Items'!CriteriaCount),U$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 1'!G15<'Score Scenario 1'!G$5,AG$3<='Data Items'!CriteriaCount),V$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 1'!H15<'Score Scenario 1'!H$5,AH$3<='Data Items'!CriteriaCount),W$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 1'!I15<'Score Scenario 1'!I$5,AI$3<='Data Items'!CriteriaCount),X$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 2'!D$4*'Score Scenario 2'!D15/10","v":0},{"$f":"'Score Scenario 2'!E$4*'Score Scenario 2'!E15/10","v":0},{"$f":"'Score Scenario 2'!F$4*'Score Scenario 2'!F15/10","v":0},{"$f":"'Score Scenario 2'!G$4*'Score Scenario 2'!G15/10","v":0},{"$f":"'Score Scenario 2'!H$4*'Score Scenario 2'!H15/10","v":0},{"$f":"'Score Scenario 2'!I$4*'Score Scenario 2'!I15/10","v":0},9.9999999999999991E-6,{"$f":"IF(Q13<='Data Items'!$F$2,AV13/MAX($AV$4:$AV$13),\"n/a\")","v":"n/a"},9,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.0000000000000002E-6,{"$f":"IF(AND('Score Scenario 2'!D15<'Score Scenario 2'!D$5,BA$3<='Data Items'!CriteriaCount),AP$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 2'!E15<'Score Scenario 2'!E$5,BB$3<='Data Items'!CriteriaCount),AQ$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 2'!F15<'Score Scenario 2'!F$5,BC$3<='Data Items'!CriteriaCount),AR$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 2'!G15<'Score Scenario 2'!G$5,BD$3<='Data Items'!CriteriaCount),AS$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 2'!H15<'Score Scenario 2'!H$5,BE$3<='Data Items'!CriteriaCount),AT$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 2'!I15<'Score Scenario 2'!I$5,BF$3<='Data Items'!CriteriaCount),AU$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",null,{"$f":"'Score Scenario 3'!D$4*'Score Scenario 3'!D15/10","v":0},{"$f":"'Score Scenario 3'!E$4*'Score Scenario 3'!E15/10","v":0},{"$f":"'Score Scenario 3'!F$4*'Score Scenario 3'!F15/10","v":0},{"$f":"'Score Scenario 3'!G$4*'Score Scenario 3'!G15/10","v":0},{"$f":"'Score Scenario 3'!H$4*'Score Scenario 3'!H15/10","v":0},{"$f":"'Score Scenario 3'!I$4*'Score Scenario 3'!I15/10","v":0},9.9999999999999991E-6,{"$f":"IF(Q13<='Data Items'!$F$2,BS13/MAX($BS$4:$BS$13),\"n/a\")","v":"n/a"},9,"Below the minimum desired score for: Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition",9.0000000000000002E-6,{"$f":"IF(AND('Score Scenario 3'!D15<'Score Scenario 3'!D$5,BX$3<='Data Items'!CriteriaCount),BM$3,\"\")","v":"Lowers operating costs and protects short-term liquidity"},{"$f":"IF(AND('Score Scenario 3'!E15<'Score Scenario 3'!E$5,BY$3<='Data Items'!CriteriaCount),BN$3,\"\")","v":"Assures staff health & wellbeing"},{"$f":"IF(AND('Score Scenario 3'!F15<'Score Scenario 3'!F$5,BZ$3<='Data Items'!CriteriaCount),BO$3,\"\")","v":"Reduces guest fear in travelling and lifts consumer demand (occupancy)"},{"$f":"IF(AND('Score Scenario 3'!G15<'Score Scenario 3'!G$5,CA$3<='Data Items'!CriteriaCount),BP$3,\"\")","v":"Supports community & governmental guidelines and parameters"},{"$f":"IF(AND('Score Scenario 3'!H15<'Score Scenario 3'!H$5,CB$3<='Data Items'!CriteriaCount),BQ$3,\"\")","v":"Builds on our core competencies"},{"$f":"IF(AND('Score Scenario 3'!I15<'Score Scenario 3'!I$5,CC$3<='Data Items'!CriteriaCount),BR$3,\"\")","v":"Differentiates the hotel compared to the competition"},"Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy)","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies","Lowers operating costs and protects short-term liquidity; Assures staff health & wellbeing; Reduces guest fear in travelling and lifts consumer demand (occupancy); Supports community & governmental guidelines and parameters; Builds on our core competencies; Differentiates the hotel compared to the competition"]

{"sheet":"Results-Summary","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,0,5],[0,7,0,9]]}
[null,null,null,"Scenarios (Overall Score)",null,null,null,"Scenarios (Relative Score)"]
[null,"Initiative",null,{"$f":"'Data Items'!J6","v":"Best Case"},{"$f":"'Data Items'!J7","v":"Most Likely Case"},{"$f":"'Data Items'!J8","v":"Worst Case "},null,{"$f":"D2","v":"Best Case"},{"$f":"E2","v":"Most Likely Case"},"Worst Case "]
[1,{"$f":"IF(LEN('Data Items'!F6)>0,'Data Items'!F6,\"\")","v":"Develop new health, sanitation & cleaning protocols throughout hotel - including training and guest illness plans"},null,{"$f":"'Results-Detailed'!Y4","v":75.600000999999992},{"$f":"'Results-Detailed'!AV4","v":67.700001},{"$f":"'Results-Detailed'!BS4","v":51.400000999999996},null,{"$f":"'Results-Detailed'!Z4","v":1},{"$f":"'Results-Detailed'!AW4","v":1},{"$f":"'Results-Detailed'!BT4","v":1}]
[2,{"$f":"IF(LEN('Data Items'!F7)>0,'Data Items'!F7,\"\")","v":"Examining new roles and responsibilities.  Redesigning some jobs, and using technology to replace traditional jobs"},null,{"$f":"'Results-Detailed'!Y5","v":74.800001999999992},{"$f":"'Results-Detailed'!AV5","v":52.100002000000003},{"$f":"'Results-Detailed'!BS5","v":30.600002},null,{"$f":"'Results-Detailed'!Z5","v":0.9894180027854762},{"$f":"'Results-Detailed'!AW5","v":0.76957165776112768},{"$f":"'Results-Detailed'!BT5","v":0.59533076662780615}]
[3,{"$f":"IF(LEN('Data Items'!F8)>0,'Data Items'!F8,\"\")","v":"Creating value-add offers to domestic & regional travelers.  Devising and updating all communication messages that support sales, marketing, social media, and PR elements"},null,{"$f":"'Results-Detailed'!Y6","v":70.400002999999998},{"$f":"'Results-Detailed'!AV6","v":63.500003},{"$f":"'Results-Detailed'!BS6","v":49.000003},null,{"$f":"'Results-Detailed'!Z6","v":0.93121695858178632},{"$f":"'Results-Detailed'!AW6","v":0.93796162573173369},{"$f":"'Results-Detailed'!BT6","v":0.95330743281503061}]
[4,{"$f":"IF(LEN('Data Items'!F9)>0,'Data Items'!F9,\"\")","v":"Revise capital expenditures budget - initiate and complete projects best done during low occupancy periods"},null,{"$f":"'Results-Detailed'!Y7","v":73.100003999999998},{"$f":"'Results-Detailed'!AV7","v":38.900003999999996},{"$f":"'Results-Detailed'!BS7","v":39.700003999999993},null,{"$f":"'Results-Detailed'!Z7","v":0.96693125705117389},{"$f":"'Results-Detailed'!AW7","v":0.57459384675636849},{"$f":"'Results-Detailed'!BT7","v":0.77237360365031893}]
[5,{"$f":"IF(LEN('Data Items'!F10)>0,'Data Items'!F10,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y8","v":67.200005000000004},{"$f":"'Results-Detailed'!AV8","v":64.700005000000004},{"$f":"'Results-Detailed'!BS8","v":48.400005},null,{"$f":"'Results-Detailed'!Z8","v":"n/a"},{"$f":"'Results-Detailed'!AW8","v":"n/a"},{"$f":"'Results-Detailed'!BT8","v":"n/a"}]
[6,{"$f":"IF(LEN('Data Items'!F11)>0,'Data Items'!F11,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y9","v":76.200006000000002},{"$f":"'Results-Detailed'!AV9","v":50.600006},{"$f":"'Results-Detailed'!BS9","v":35.000005999999999},null,{"$f":"'Results-Detailed'!Z9","v":"n/a"},{"$f":"'Results-Detailed'!AW9","v":"n/a"},{"$f":"'Results-Detailed'!BT9","v":"n/a"}]
[7,{"$f":"IF(LEN('Data Items'!F12)>0,'Data Items'!F12,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y10","v":71.800006999999994},{"$f":"'Results-Detailed'!AV10","v":69.500006999999997},{"$f":"'Results-Detailed'!BS10","v":57.400007000000002},null,{"$f":"'Results-Detailed'!Z10","v":"n/a"},{"$f":"'Results-Detailed'!AW10","v":"n/a"},{"$f":"'Results-Detailed'!BT10","v":"n/a"}]
[8,{"$f":"IF(LEN('Data Items'!F13)>0,'Data Items'!F13,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y11","v":68.900008},{"$f":"'Results-Detailed'!AV11","v":40.400008},{"$f":"'Results-Detailed'!BS11","v":49.100007999999995},null,{"$f":"'Results-Detailed'!Z11","v":"n/a"},{"$f":"'Results-Detailed'!AW11","v":"n/a"},{"$f":"'Results-Detailed'!BT11","v":"n/a"}]
[9,{"$f":"IF(LEN('Data Items'!F14)>0,'Data Items'!F14,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y12","v":9.0000000000000002E-6},{"$f":"'Results-Detailed'!AV12","v":9.0000000000000002E-6},{"$f":"'Results-Detailed'!BS12","v":9.0000000000000002E-6},null,{"$f":"'Results-Detailed'!Z12","v":"n/a"},{"$f":"'Results-Detailed'!AW12","v":"n/a"},{"$f":"'Results-Detailed'!BT12","v":"n/a"}]
[10,{"$f":"IF(LEN('Data Items'!F15)>0,'Data Items'!F15,\"\")","v":""},null,{"$f":"'Results-Detailed'!Y13","v":9.9999999999999991E-6},{"$f":"'Results-Detailed'!AV13","v":9.9999999999999991E-6},{"$f":"'Results-Detailed'!BS13","v":9.9999999999999991E-6},null,{"$f":"'Results-Detailed'!Z13","v":"n/a"},{"$f":"'Results-Detailed'!AW13","v":"n/a"},{"$f":"'Results-Detailed'!BT13","v":"n/a"}]