{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["About the Workbook","Dashboard","Calculations","HIDE","Appendix - Workpoints"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":4,"comments":3,"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":"About the Workbook","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[16,1,16,8],[0,0,0,8],[26,2,26,8],[28,2,28,8],[30,2,30,8],[14,1,14,8],[15,1,15,8],[44,2,44,8],[32,1,32,8],[22,1,22,8],[24,1,24,8],[34,1,34,8],[39,1,39,8],[41,0,41,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"All inputs are to be entered in the 'Dashboard'."]
[null,"Cells in light blue are input cells; other cells are proteteced to secure the integrity of the workbook."]
[null,"The Dashboard will display a summary of space planning results. For details of the calculations, click on the link to go to the 'Detailed Calculation'."]
[]
[null,"HOW TO USE THIS WORKBOOK"]
[]
[]
[]
[null,"1) ENTER the name of the Project / Department and the Project Address in the appropriate fields."]
[]
[null,"2) SELECT THE DESIRED ACTIVITY PROFILE\nSelect from the combo box one of the 3 profiles based on the following:"]
[]
[null,null,"The Autonomous Profile is better suited to groups that will work individually in the office with limited level of interaction. It features the highest proportion of individual workpoints."]
[]
[null,null,"The Balanced Profile is better suited to groups that will work both individually and collaboratively in the office with moderate level of interaction. It has the most balanced distribution of workpoint with an equal proportion of individual and collaborative workpoints. "]
[]
[null,null,"The Interactive Profile is better suited to groups that will work collaboratively in the office with high level of interaction. It features the highest proportion of collaborative workpoints."]
[]
[null,"3) ENTER YOUR KNOWN DATA\nEnter the key data in the appropriate cells. Enter the new or existing space in m²u, and the appropriate population. This will determine the target occupancy which is used to calculate optimal workpoint ratios and distributions."]
[]
[null,"4) ADJUST EACH INDIVIDUAL WORKPOINT AS REQUIRED\nAn ideal workpoint quantity distribution will be automatically calculated for each category. These can be manually modified to meet specific client requirements or preferences, within a predetermined range, by using the scroll bars located beside each cell. Cell will turn orange if a quantity is too high and cell will turn blue if a quantity is too low."]
[null,null,"- Scroll the bar to the right direction to increase quantities (increases by 1 unit)"]
[null,null,"- Scroll the bar to the left direction to decrease quantities (decreases by 1 unit)"]
[null,"Click on the button 'Reset'' to reset all cells to the suggested amounts."]
[]
[null,"5) CHECK-IN ON THE SURPLUS/DEFICIT AMOUNT TO ENSURE OPTIMAL SPACE PLANNING\nShould you exceed the available space, the number will turn RED to highlight the deficit. Should you have space remaining to plan with, the number will turn GREEN to show the surplus. Simply adjust workpoint quantities accordingly."]
[]
["CLICK HERE TO START PLANNING"]
[]
[]
[null,"APPENDIX","GCworkplace workpoints at a glance"]
[]
[null,null,null,null,null,null,null,"VERSION RELEASE DATE:","2022-05-01"]

{"sheet":"Dashboard","index":1,"n_rows":92,"n_cols":29,"rows_kept":92,"cut":false,"hidden":false,"merged":[[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[2,3,2,12],[3,3,3,12],[7,14,7,22],[21,3,22,5],[36,1,36,2],[36,13,36,14],[25,3,28,3],[29,3,31,3],[32,3,34,3],[7,6,7,12],[8,6,8,9],[9,6,9,9],[10,6,10,9],[25,2,26,2],[25,4,26,4],[25,5,26,5],[37,1,40,1],[41,1,44,1],[24,1,24,2],[25,1,28,1],[29,1,31,1],[32,1,34,1],[27,2,28,2],[37,13,37,14],[24,12,24,14],[25,12,30,12],[31,12,35,12],[36,12,37,12],[25,13,25,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[34,13,34,14],[35,13,35,14],[32,13,32,14],[33,13,33,14],[26,13,26,14],[27,9,28,9],[27,10,28,10],[27,4,28,4],[27,5,28,5],[27,6,28,6],[27,8,28,8],[27,7,28,7]]}
["GCworkplace Space Planning Workbook"]
[]
[null,null,"Project Name / Department",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check remaining Surplus / Deficit:",null,{"$f":"AC13","v":0}]
[null,null,"Project Address"]
[]
[]
[]
[null,null,"Choose activity profile",2,null,null,"WORKPOINT DISTRIBUTION COMPARISON",null,null,null,null,null,null,null,"SPACE PLANNING SUMMARY:"]
[null,null,null,null,null,null,"Activity Profile",null,null,null,"Autonomous","Balanced","Interactive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning Space",{"$f":"Calculations!K67","v":0}]
[null,null,null,null,null,null,"Individual Workpoints",null,null,null,"50-65%","30-50%","5-30%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Individual Workpoints Space",{"$f":"Calculations!K68","v":0}]
[null,null,"Input key data",null,null,null,"Collaborative and Support Spaces",null,null,null,"35-50%","50-70%","70-95%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Collaborative Space",{"$f":"Calculations!K69","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Support Space",{"$f":"Calculations!K70","v":0}]
[null,null,"Space Solution in m2u:",0,"(NOT including any Special Purpose Space)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remaining Surplus / Deficit",{"$f":"AC9-AC10-AC11-AC12","v":0}]
[null,null,"Target occupancy*:",{"$f":"D13/11","v":0},"*obtained by dividing the space solution by 11m2u\n",null,null,null,null,null,null,"Total Space =",{"$f":"Calculations!I17","v":0}]
[null,null,"Actual Population:",null,"(excluding any occupants working in SPS)",null,null,null,null,null,null,"Circulation (35%) =",{"$f":"-Calculations!I18","v":0}]
[null,null,"Built-in growth:",{"$f":"IF(D14-D15<>D14,D14-D15,0)","v":0},null,null,null,null,null,null,null,"Building Fit Factor (6%) =",{"$f":"-Calculations!I19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB9","v":"Planning Space"},{"$f":"AC9","v":0}]
[null,null,"Full Time SPS Population:",null,"(only when directly adjacent to the general office)",null,null,null,null,null,null,"REMAINING SPACE FOR PLANNING =",{"$f":"Calculations!I21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC13>0,\"Surplus\",\"Deficit\")","v":"Deficit"},{"$f":"ABS(AC13)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total allocated:",{"$f":"SUM(AC10:AC12)","v":0}]
[]
[]
[null,null,"Adjust number of workpoints","Adjust as required using the scroll bars beside each workpoint"]
[]
[]
[null,"INDIVIDUAL WORKPOINTS",null,"Total number of seats","Suggested quantity","Quantity","Adjust quantities as required",null,"Average size",null,"Required area",null,"SUPPORT SPACES",null,null,"Suggested quantity","Quantity","Adjust quantities as required",null,"Average size",null,"Required area"]
[null,"Primary Individual Open","Workstation",{"$f":"F26+F28","v":0},{"$f":"Calculations!E27","v":0},{"$f":"G26","v":0},0,"x",3.5,"=",{"$f":"Calculations!K27","v":0},null,"General Purpose Office","Kitchenette",null,{"$f":"Calculations!E49","v":0},{"$f":"R26","v":0},0,"x",5,"=",{"$f":"Calculations!K49","v":0},null,null,{"$f":"HIDE!M8","v":3.5},{"$f":"IF($D$14<25,5,IF(AND($D$14>=25,$D$14<50),10,15))","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellness Room",null,{"$f":"Calculations!E51","v":0},{"$f":"R27","v":0},0,"x",7.5,"=",{"$f":"Calculations!K50","v":0},null,null,null,{"$f":"HIDE!M25","v":7.5}]
[null,null,"Work Pod",null,{"$f":"Calculations!E28","v":0},{"$f":"G28","v":0},0,"x",2.5,"=",{"$f":"Calculations!K28","v":0},null,null,"Equipment Area",null,{"$f":"Calculations!E51","v":0},{"$f":"R28","v":0},0,"x",5,"=",{"$f":"Calculations!K51","v":0},null,null,{"$f":"HIDE!M9","v":2.5},{"$f":"HIDE!M26","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lockers Area (area is per FTE)",null,{"$f":"D14","v":0},{"$f":"R29","v":0},0,"x",0.5,"=",{"$f":"Calculations!K52","v":0},null,null,{"$f":"HIDE!M9","v":2.5},{"$f":"HIDE!M27","v":0.5}]
[null,"Primary Individual      Enclosed","Focus Room",{"$f":"F30+F31+F32","v":0},{"$f":"Calculations!E29","v":0},{"$f":"G30","v":0},0,"x",7.5,"=",{"$f":"Calculations!K29","v":0},null,null,"Shared Storage",null,{"$f":"Calculations!E53","v":0},0,0,"x",10,"=",{"$f":"Calculations!K53","v":0},null,null,{"$f":"HIDE!M10","v":7.5},{"$f":"HIDE!M28","v":10}]
[null,null,"Ministerial Dedicated (Deputy Head or Minister)",null,{"$f":"Calculations!E30","v":0},{"$f":"G31","v":0},0,"x",29,"=",{"$f":"Calculations!K30","v":0},null,null,"Dedicated Server/Telecom Room - 1 per floor",null,{"$f":"Calculations!E54","v":0},0,0,"x",10,"=",{"$f":"Calculations!K54","v":0},null,null,{"$f":"HIDE!M11","v":29},{"$f":"HIDE!M29","v":10}]
[null,null,"Study (4m2 per occupant)",null,{"$f":"Calculations!E31","v":0},0,0,"x",4,"=",{"$f":"Calculations!K31","v":0},null,"Extra workpoints to support adjacent SPS population","Phonebooth",null,{"$f":"Calculations!E55","v":0},0,0,"x",5,"=",{"$f":"Calculations!K55","v":0},null,null,{"$f":"HIDE!M12","v":4},{"$f":"HIDE!M30","v":5}]
[null,"Secondary Individual ","Focus Pod",{"$f":"F33+F34+F35","v":0},{"$f":"Calculations!E32","v":0},0,0,"x",2.5,"=",{"$f":"Calculations!K32","v":0},null,null,"Lounge",null,{"$f":"Calculations!E56","v":0},0,0,"x",10,"=",{"$f":"Calculations!K56","v":0},null,null,{"$f":"HIDE!M13","v":2.5},{"$f":"HIDE!M31","v":10}]
[null,null,"Touchdown (1,5m2  per occupant)",null,{"$f":"Calculations!E33","v":0},{"$f":"G34","v":0},0,"x",1.5,"=",{"$f":"Calculations!K33","v":0},null,null,"Work Room",null,{"$f":"Calculations!E57","v":0},0,0,"x",15,"=",{"$f":"Calculations!K57","v":0},null,null,{"$f":"HIDE!M14","v":1.5},{"$f":"HIDE!M32","v":15}]
[null,null,"Phonebooth",null,{"$f":"Calculations!E34","v":0},0,0,"x",5,"=",{"$f":"Calculations!K34","v":0},null,null,"Kitchenette",null,{"$f":"Calculations!E58","v":0},0,0,"x",5,"=",{"$f":"Calculations!K58","v":0},null,null,{"$f":"HIDE!M15","v":5},{"$f":"IF($D$14<25,5,IF(AND($D$14>=25,$D$14<50),10,15))","v":5}]
[null,null,"Total no. of individual seats",{"$f":"SUM(D26:D35)","v":0},null,null,null,null,null,"Total space for individual workpoints",{"$f":"SUM(K26:K35)","v":0},null,null,"Lockers Area (area is per FTE)",null,{"$f":"Calculations!E59","v":0},0,0,"x",0.5,"=",{"$f":"Calculations!K59","v":0},null,null,null,{"$f":"HIDE!M34","v":0.5}]
[null,"COLLABORATIVE WORKPOINTS",null,"Total number of seats","Suggested quantity","Quantity","Suggested quantity",null,null,null,"Required area",null,"Other","Custom support space",null,{"$f":"Calculations!E60","v":0},0,0,"x",{"$f":"$M$17*0.01","v":0},"=",{"$f":"Q37*T37","v":0}]
[null,"Collaborative Open","Chat Point",{"$f":"SUM(F38)*4","v":0},{"$f":"Calculations!E38","v":0},{"$f":"G38","v":0},0,"x",4,"=",{"$f":"Calculations!K38","v":0},null,null,"Custom Workpoint",null,{"$f":"Calculations!E61","v":0},0,0,"x",{"$f":"0","v":0},"=",0,null,null,{"$f":"HIDE!M16","v":4}]
[null,null,"Huddle ",{"$f":"SUM(F39)*4","v":0},{"$f":"Calculations!E39","v":0},{"$f":"G39","v":0},0,"x",5,"=",{"$f":"Calculations!K39","v":0},null,null,null,null,null,null,null,null,null,"Total space for support spaces",{"$f":"SUM(V26:V38)","v":0},null,null,{"$f":"HIDE!M17","v":5}]
[null,null,"Teaming Area",{"$f":"SUM(F40)*8","v":0},{"$f":"Calculations!E40","v":0},0,0,"x",15,"=",{"$f":"Calculations!K40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M18","v":15}]
[null,null,"Lounge",{"$f":"SUM(F41)*10","v":0},{"$f":"Calculations!E41","v":0},0,0,"x",10,"=",{"$f":"Calculations!K41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M19","v":10}]
[null,"Collaborative Enclosed","Work Room",{"$f":"SUM(F42)*6","v":0},{"$f":"Calculations!E42","v":0},0,0,"x",16,"=",{"$f":"Calculations!K42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M20","v":16}]
[null,null,"Project Room",{"$f":"SUM(F43)*8","v":0},{"$f":"Calculations!E43","v":0},0,0,"x",20,"=",{"$f":"Calculations!K43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M21","v":20}]
[null,null,"Medium Meeting Room",{"$f":"SUM(F44)*12","v":0},{"$f":"Calculations!E44","v":0},0,0,"x",32,"=",{"$f":"Calculations!K44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M22","v":32}]
[null,null,"Large Meeting Room",{"$f":"SUM(F45)*20","v":0},{"$f":"Calculations!E45","v":0},0,0,"x",60,"=",{"$f":"Calculations!K45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HIDE!M23","v":60}]
[null,null,"Estimated number of collaborative seats",{"$f":"SUM(D38:D45)","v":0},null,null,null,null,null,"Total space for collaborative workpoints",{"$f":"SUM(K38:K45)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"AUTONOMOUS"]
[null,null,"BALANCED"]
[null,null,"INTERACTIVE"]

{"sheet":"Calculations","index":2,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":true,"merged":[[1,0,1,11],[2,2,2,9],[68,0,68,8],[69,0,69,8],[70,0,70,8],[54,0,58,0],[41,0,44,0],[45,0,45,1],[47,0,47,1],[48,0,53,0],[12,6,12,7],[13,1,13,7],[14,1,14,7],[25,0,25,1],[26,0,27,0],[26,2,27,2],[58,13,58,14],[59,0,60,0],[66,0,66,8],[67,0,67,8],[63,0,63,10],[53,13,53,14],[28,0,30,0],[28,2,30,2],[31,0,33,0],[31,2,33,2],[36,0,36,1],[37,0,40,0],[22,0,22,10],[2,13,2,15],[5,13,5,15],[9,1,9,7],[4,13,4,16],[3,2,3,9],[7,0,7,10]]}
[]
[{"$f":"IF(Dashboard!$D$8=1,\"AUTONOMOUS\",IF(Dashboard!$D$8=2,\"BALANCED\",IF(Dashboard!$D$8=3,\"INTERACTIVE\",\"N/A\")))&\" PROFILE\"","v":"BALANCED PROFILE"}]
[null,"Project Name / Department",{"$f":"IF(Dashboard!D3<>\"\",Dashboard!D3,\"n/a\")","v":"n/a"},null,null,null,null,null,null,null,null,null,null,"SPACE PLANNING SUMMARY"]
[null,"Project Address",{"$f":"IF(Dashboard!D4<>\"\",Dashboard!D4,\"n/a\")","v":"n/a"},null,null,null,null,null,null,null,null,null,null,"REMAINING SURPLUS / DEFICIT","=",{"$f":"K71","v":0}]
[]
[]
[]
["KEY DATA (from Dashboard):"]
[]
[null,"Space Solution in m2u (NOT including any Special Purpose Space):",null,null,null,null,null,null,{"$f":"Dashboard!D13","v":0}]
[]
[null,null,null,null,null,null,null,"Target Occupancy*:",{"$f":"I10/11","v":0}]
[null,null,null,null,null,null,"Actual Population:",null,{"$f":"Dashboard!D15","v":0}]
[null,"Built-in growth:",null,null,null,null,null,null,{"$f":"I12-I13","v":0}]
[null,"Full Time Special Purpose Space Population:",null,null,null,null,null,null,{"$f":"Dashboard!D17","v":0}]
[]
[null,null,null,null,null,null,null,"Total Space =",{"$f":"I10","v":0}]
[null,null,null,null,null,null,null,"Circulation (35%)= ",{"$f":"I17*0.35","v":0}]
[null,null,null,null,null,null,null,"Building Fit Factor (6%)= ",{"$f":"I17*0.06","v":0}]
[]
[null,null,null,null,null,null,null,"REMAINING SPACE FOR PLANNING =",{"$f":"I17 -SUM(I18) -SUM(I19)","v":0}]
[]
["WORKPOINT QUANTITIES"]
[]
[]
["INDIVIDUAL      WORKPOINTS",null,"Total number of seats","Formula","Suggested quantity","rounded","Adjust quantities as required",null,"Average size (m²)",null,"Required Area"]
["Primary Individual Open","Workstation",{"$f":"F27+F28","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H8,HIDE!I8,HIDE!J8)","v":30},{"$f":"ROUND($I$12*D27/100,0)","v":0},{"$f":"ROUND(G27,0)","v":0},{"$f":"Dashboard!F26","v":0},"x",{"$f":"Dashboard!I26","v":3.5},"=",{"$f":"F27*I27","v":0}]
[null,"Work Pod",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H9,HIDE!I9,HIDE!J9)","v":5},{"$f":"ROUND($I$12*D28/100,0)","v":0},{"$f":"ROUND(G28,0)","v":0},{"$f":"Dashboard!F28","v":0},"x",{"$f":"Dashboard!I28","v":2.5},"=",{"$f":"F28*I28","v":0}]
["Primary Individual      Enclosed","Focus Room",{"$f":"F29+F30+F31","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H10,HIDE!I10,HIDE!J10)","v":7},0,{"$f":"ROUND(G29,0)","v":0},{"$f":"Dashboard!F30","v":0},"x",{"$f":"Dashboard!I30","v":7.5},"=",0]
[null,"Ministerial Dedicated (Deputy Head or Minister) total includes 9m2 washroom.",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H11,HIDE!I11,HIDE!J11)","v":0},0,0,{"$f":"Dashboard!F31","v":0},"x",{"$f":"Dashboard!I31","v":29},"=",0]
[null,"Study (4m2 per occupant)",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H12,HIDE!I12,HIDE!J12)","v":12},0,0,{"$f":"Dashboard!F32","v":0},"x",{"$f":"Dashboard!I32","v":4},"=",0]
["Secondary Individual ","Focus Pod",{"$f":"F32+F33+F34","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H13,HIDE!I13,HIDE!J13)","v":4},{"$f":"ROUND($I$12*D32/100,0)","v":0},0,{"$f":"Dashboard!F33","v":0},"x",{"$f":"Dashboard!I33","v":2.5},"=",0]
[null,"Touchdown (1,5m2 per occupant)",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H14,HIDE!I14,HIDE!J14)","v":14},0,0,{"$f":"Dashboard!F34","v":0},"x",{"$f":"Dashboard!I34","v":1.5},"=",0]
[null,"Phonebooth",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H15,HIDE!I15,HIDE!J15)","v":5},0,0,{"$f":"Dashboard!F35","v":0},"x",{"$f":"Dashboard!I35","v":5},"=",0]
[null,"Total no. of individual seats",{"$f":"SUM(G27:G34)","v":0},null,null,null,null,null,null,"Total space for individual workpoints",{"$f":"SUM(K27:K34)","v":0}]
[]
["COLLABORATIVE WORKPOINTS",null,"Total number of seats","Formula","Suggested quantity","rounded","Adjust quantities as required",null,"Average size (m²)",null,"Required Area"]
["Collaborative Open","Chat Point",{"$f":"SUM(F38)*4","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H16,HIDE!I16,HIDE!J16)","v":2},{"$f":"ROUND($I$12*D38/100,0)","v":0},{"$f":"ROUND(G38,0)","v":0},{"$f":"Dashboard!F38","v":0},"x",{"$f":"Dashboard!I38","v":4},"=",{"$f":"F38*I38","v":0}]
[null,"Huddle ",{"$f":"SUM(F39)*4","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H17,HIDE!I17,HIDE!J17)","v":2},0,{"$f":"ROUND(G39,0)","v":0},{"$f":"Dashboard!F39","v":0},"x",{"$f":"Dashboard!I39","v":5},"=",{"$f":"F39*I39","v":0}]
[null,"Teaming Area",{"$f":"SUM(F40)*10","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H18,HIDE!I18,HIDE!J18)","v":1},0,0,{"$f":"Dashboard!F40","v":0},"x",{"$f":"Dashboard!I40","v":15},"=",0]
[null,"Lounge",{"$f":"SUM(F41)*10","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H19,HIDE!I19,HIDE!J19)","v":2},0,0,{"$f":"Dashboard!F41","v":0},"x",{"$f":"Dashboard!I41","v":10},"=",0]
["Collaborative Enclosed","Work Room",{"$f":"SUM(F42)*4","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H20,HIDE!I20,HIDE!J20)","v":3},0,0,{"$f":"Dashboard!F42","v":0},"x",{"$f":"Dashboard!I42","v":16},"=",0]
[null,"Project Room",{"$f":"SUM(F43)*6","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H21,HIDE!I21,HIDE!J21)","v":2},0,0,{"$f":"Dashboard!F43","v":0},"x",{"$f":"Dashboard!I43","v":20},"=",0]
[null,"Medium Meeting Room",{"$f":"SUM(F44)*12","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H22,HIDE!I22,HIDE!J22)","v":2},0,0,{"$f":"Dashboard!F44","v":0},"x",{"$f":"Dashboard!I44","v":32},"=",0]
[null,"Large Meeting Room",{"$f":"SUM(F45)*20","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H23,HIDE!I23,HIDE!J23)","v":1},0,0,{"$f":"Dashboard!F45","v":0},"x",{"$f":"Dashboard!I45","v":60},"=",0]
["Estimated number of collaborative seats",null,{"$f":"SUM(C38:C45)","v":0},null,null,null,null,null,null,"Total space for collaborative workpoints",{"$f":"SUM(K38:K45)","v":0}]
[]
["SUPPORT  SPACES",null,"Total number of seats","Formula","Suggested quantity","rounded","Adjust quantities as required",null,"Average size (m²)",null,"Required Area"]
["General Purpose Office","Kitchenette","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H24,HIDE!I24,HIDE!J24)","v":0},{"$f":"IF(Dashboard!D13=0,0,IF(HIDE!$E$24<1,1,HIDE!$E$24))","v":0},{"$f":"ROUND(G49,0)","v":0},{"$f":"Dashboard!Q26","v":0},"x",{"$f":"Dashboard!T26","v":5},"=",{"$f":"F49*I49","v":0}]
[null,"Wellness Room",null,{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H25,HIDE!I25,HIDE!J25)","v":0},{"$f":"HIDE!E25","v":0},{"$f":"ROUND(G50,0)","v":0},{"$f":"Dashboard!Q27","v":0},"x",{"$f":"Dashboard!T27","v":7.5},"=",0]
[null,"Equipment Area","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H26,HIDE!I26,HIDE!J26)","v":1.8},{"$f":"ROUND($I$12*D51/100,0)","v":0},{"$f":"ROUND(G51,0)","v":0},{"$f":"Dashboard!Q28","v":0},"x",{"$f":"Dashboard!T28","v":5},"=",0]
[null,"Lockers Area (area is per FTE)","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H27,HIDE!I27,HIDE!J27)","v":0},{"$f":"SUM($I$12)","v":0},0,{"$f":"Dashboard!Q29","v":0},"x",{"$f":"Dashboard!T29","v":0.5},"=",0]
[null,"Shared Storage","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H28,HIDE!I28,HIDE!J28)","v":0.5},{"$f":"ROUND($I$12*D53/100,0)","v":0},0,{"$f":"Dashboard!Q30","v":0},"x",{"$f":"Dashboard!T30","v":10},"=",0]
[null,"Dedicated Server/Telecom Room - 1 per floor","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H29,HIDE!I29,HIDE!J29)","v":0},{"$f":"IF(Dashboard!D13=0,0,1)","v":0},0,{"$f":"Dashboard!Q31","v":0},"x",{"$f":"Dashboard!T31","v":10},"=",0]
["Extra workpoints to support adjacent SPS population","Phonebooth",{"$f":"F55","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H30,HIDE!I30,HIDE!J30)","v":6},{"$f":"ROUND($I$15*D55/100,0)","v":0},0,{"$f":"Dashboard!Q32","v":0},"x",{"$f":"Dashboard!T32","v":5},"=",0]
[null,"Lounge",{"$f":"SUM(F56)*10","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H31,HIDE!I31,HIDE!J31)","v":2},{"$f":"ROUND($I$15*D56/100,0)","v":0},0,{"$f":"Dashboard!Q33","v":0},"x",{"$f":"Dashboard!T33","v":10},"=",0]
[null,"Work Room",{"$f":"SUM(F57)*4","v":0},{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H32,HIDE!I32,HIDE!J32)","v":3.8},{"$f":"ROUND($I$15*D57/100,0)","v":0},0,{"$f":"Dashboard!Q34","v":0},"x",{"$f":"Dashboard!T34","v":15},"=",0]
[null,"Kitchenette","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H33,HIDE!I33,HIDE!J33)","v":0},0,0,{"$f":"Dashboard!Q35","v":0},"x",{"$f":"Dashboard!T35","v":5},"=",0]
[null,"Lockers Area (area is per FTE)","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H34,HIDE!I34,HIDE!J34)","v":0},{"$f":"SUM($I$15)","v":0},0,{"$f":"Dashboard!Q36","v":0},"x",{"$f":"Dashboard!T36","v":0.5},"=",0]
["Other","Custom support space","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H35,HIDE!I35,HIDE!J35)","v":0},0,0,{"$f":"Dashboard!Q37","v":0},"x",{"$f":"Dashboard!T37","v":0},"=",{"$f":"F60*I60","v":0}]
[null,"Custom Workpoint","-",{"$f":"CHOOSE(Dashboard!$D$8,HIDE!H36,HIDE!I36,HIDE!J36)","v":0},0,0,{"$f":"Dashboard!Q38","v":0},"x",{"$f":"Dashboard!T38","v":0},"=",{"$f":"F61*I61","v":0}]
[null,null,null,null,null,null,null,null,null,"Total space for support spaces",{"$f":"SUM(K49:K61)","v":0}]
[]
["SURPLUS/DEFICIT AMOUNT\n"]
[]
[null,null,null,null,null,null,null,null,"SPACE PLANNING SUMMARY"]
["PLANNING SPACE",null,null,null,null,null,null,null,null,"=",{"$f":"I21","v":0}]
["TOTAL INDIVIDUAL WORKPOINT SPACE  ",null,null,null,null,null,null,null,null,"=",{"$f":"K35","v":0}]
["TOTAL COLLABORATIVE SPACE  ",null,null,null,null,null,null,null,null,"=",{"$f":"K46","v":0}]
["TOTAL SUPPORT SPACE  ",null,null,null,null,null,null,null,null,"=",{"$f":"K62","v":0}]
["REMAINING SURPLUS* / DEFICIT* ",null,null,null,null,null,null,null,null,"=",{"$f":"SUM(K67)-(K68+K69+K70)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"*SIGNIFICANT SURPLUS WILL SHOW IN GREEN = ADD MORE WORKPOINTS"]
[null,null,null,null,null,null,null,null,null,null,"*SIGNIFICANT DEFICIT WILL SHOW IN RED = REDUCE SOME WORKPOINTS"]

{"sheet":"HIDE","index":3,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":true,"merged":[[5,0,6,1],[5,4,5,5],[5,6,5,10],[34,0,35,0],[15,0,18,0],[19,0,22,0],[23,0,28,0],[7,0,8,0],[9,0,11,0],[12,0,14,0],[29,0,33,0],[5,2,5,3]]}
["Formulas"]
[]
[]
[]
[]
["WORKPOINTS",null,"RANGE",null,"RANGE (ROUND)",null,"FOR 100 PEOPLE (1100m2u)",null,null,null,null,null,"SUGGESTED SIZE","MAX SIZE"]
[null,null,"LOW","HIGH","LOW","HIGH","MINIMUM","AUTONOMOUS","BALANCED","INTERACTIVE","MAXIMUM"]
["Primary Individual Open","Workstation",{"$f":"Calculations!$I$12*0.15","v":0},{"$f":"Calculations!$I$12*0.6","v":0},{"$f":"ROUND(C8,0)","v":0},{"$f":"ROUND(D8,0)","v":0},15,40,30,20,60,null,3.5,4.5,"Workstation"]
[null,"Work Pod",{"$f":"Calculations!$I$12*0.02","v":0},{"$f":"Calculations!$I$12*0.1","v":0},{"$f":"ROUND(C9,0)","v":0},0,2,6,5,4,10,null,2.5,3.5,"Work Pod"]
["Primary Individual      Enclosed","Focus Room",{"$f":"Calculations!$I$12*0.04","v":0},{"$f":"Calculations!$I$12*0.12","v":0},0,0,4,8,7,6,12,null,7.5,10,"Focus Room"]
[null,"Ministerial Dedicated (Deputy Head or Minister) total includes 9m2 washroom.",{"$f":"Calculations!$I$12*0","v":0},{"$f":"Calculations!$I$12*0","v":0},0,0,null,null,null,null,null,null,29,29,"Ministerial Dedicated (Deputy Head or Minister) total includes 9m2 washroom."]
[null,"Study (3m2 per occupant, min. 10 occupants)",{"$f":"(Calculations!$I$12*0.1)","v":0},{"$f":"(Calculations!$I$12*0.15)","v":0},0,0,10,12,12,12,15,null,4,4,"Study (3m2 per occupant, min. 10 occupants)"]
["Secondary Individual ","Focus Pod",{"$f":"Calculations!$I$12*0.02","v":0},{"$f":"Calculations!$I$12*0.06","v":0},0,0,2,4,4,4,6,null,2.5,3.5,"Focus Pod"]
[null,"Touchdown",{"$f":"Calculations!$I$12*0.08","v":0},{"$f":"Calculations!$I$12*0.3","v":0},0,0,8,12,14,16,30,null,1.5,2,"Touchdown"]
[null,"Phonebooth",{"$f":"Calculations!$I$12*0.04","v":0},{"$f":"Calculations!$I$12*0.1","v":0},0,0,4,6,5,4,10,null,5,5,"Phonebooth"]
["Collaborative Open","Chat Point",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.05","v":0},0,0,1,1,2,3,5,null,4,8,"Chat Point"]
[null,"Huddle ",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.06","v":0},0,0,1,2,2,3,6,null,5,6,"Huddle "]
[null,"Teaming Area",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.04","v":0},0,0,1,1,1,2,4,null,15,20,"Teaming Area"]
[null,"Lounge",{"$f":"Calculations!$I$12*0.02","v":0},{"$f":"Calculations!$I$12*0.03","v":0},0,0,2,2,2,2,3,null,10,15,"Lounge"]
["Collaborative Enclosed","Work Room",{"$f":"Calculations!$I$12*0.02","v":0},{"$f":"Calculations!$I$12*0.06","v":0},0,0,2,3,3,4,6,null,16,20,"Work Room"]
[null,"Project Room",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.06","v":0},0,0,1,1,2,3,6,null,20,25,"Project Room"]
[null,"Medium Meeting Room",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.04","v":0},0,0,1,1,2,2,4,null,32,40,"Medium Meeting Room"]
[null,"Large Meeting Room",{"$f":"Calculations!$I$12*0","v":0},{"$f":"Calculations!$I$12*0.02","v":0},0,0,0,1,1,1,2,null,60,70,"Large Meeting Room"]
["General Purpose Office","Kitchenette",{"$f":"Calculations!$I$12/150","v":0},null,{"$f":"ROUNDUP(C24,0)","v":0},null,null,null,null,null,null,null,null,null,"Kitchenette"]
[null,"Wellness Room",{"$f":"Calculations!I12/50","v":0},null,{"$f":"ROUND(C25,0)","v":0},null,null,null,null,null,null,null,7.5,10,"Wellness Room"]
[null,"Equipment Area",{"$f":"Calculations!$I$12*0.01","v":0},{"$f":"Calculations!$I$12*0.02","v":0},0,0,null,1.8,1.8,1.8,null,null,5,10,"Equipment Area"]
[null,"Lockers (area is per FTE)",{"$f":"Calculations!$I$12*0.5","v":0},{"$f":"Calculations!$I$12*1.25","v":0},0,0,null,null,null,null,null,null,0.5,null,"Lockers (area is per FTE)"]
[null,"Shared Storage",{"$f":"Calculations!$I$12*0.005","v":0},{"$f":"Calculations!$I$12*0.02","v":0},0,0,null,0.5,0.5,0.5,null,null,10,15,"Shared Storage"]
[null,"Dedicated Server/Telecom Room - 1 per floor",null,null,null,null,null,null,null,null,null,null,10,null,"Dedicated Server/Telecom Room - 1 per floor"]
["Extra workpoints to support adjacent SPS population","Phonebooth",{"$f":"Calculations!$I$15*0.04","v":0},{"$f":"Calculations!$I$15*0.08","v":0},0,0,4,6,6,6,8,null,5,5,"Phonebooth"]
[null,"Lounge",{"$f":"Calculations!$I$15*0.01","v":0},{"$f":"Calculations!$I$15*0.02","v":0},0,0,2,2,2,2,3,null,10,15,"Lounge"]
[null,"Work Room",{"$f":"Calculations!$I$15*0.02","v":0},{"$f":"Calculations!$I$15*0.06","v":0},0,0,2,2,3.8,5,6,null,15,20,"Work Room"]
[null,"Kitchenette",0,null,0,null,null,null,null,null,null,null,null,null,"Kitchenette"]
[null,"Lockers Area (area is per FTE)",{"$f":"Calculations!$I$15*0.5","v":0},{"$f":"Calculations!$I$15*1.25","v":0},0,0,null,null,null,null,null,null,0.5,null,"Lockers (area is per FTE)"]
["Other","Custom support space",{"$f":"Calculations!$I$21*0","v":0},{"$f":"Calculations!$I$21*0.015","v":0},0,0]
[null,"Custom Workpoint",{"$f":"Calculations!$I$12*0","v":0},{"$f":"Calculations!$I$12*0","v":0},0,0,null,null,null,null,null,null,null,null,"Custom Collaborative Workpoint 1"]
[null,"Average size",0,{"$f":"Calculations!$I$21*1.5%","v":0},{"$f":"ROUND(C37,0)","v":0},{"$f":"ROUND(D37,1)","v":0}]

{"sheet":"Appendix - Workpoints","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,1,4,1],[2,2,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,4,8],[3,0,4,0],[5,0,6,0],[5,2,5,3],[6,2,6,3],[7,0,9,0],[7,2,7,3],[9,2,9,3],[8,2,8,3],[10,0,12,0],[10,2,10,3],[11,2,11,3],[12,2,12,3],[17,0,20,0],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[13,0,16,0],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[21,0,25,0],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3]]}
[null,null,null,null,null,null,null,"Back to 'About the Workbook'"]
[]
[null,"Name","Function",null,"Target occupancy","Visual Privacy","Acoustic Privacy","Avg. Size","Recommended Zone"]
["Workpoint"]
[]
["Primary Individual Open","Workstation","Mid-long term focused work",null,1,"Low-Med","Low",3.5,"Quiet/Transitional"]
[null,"Work Pod","Short-mid term focused work",null,1,"Low-Med","Low",2.5,"Any"]
["Primary Individual Enclosed","Focus Room","Mid-long term focused work",null,1,"Med-High","Med","7.5m²","Quiet/Transitional"]
[null,"Ministerial Dedicated (Deputy Head or Minister) total includes 9m2 washroom.","Dedicated office (including 9m2 washroom) for a Minister",null,1,"Med - High","Med - High","29m²","Transitional"]
[null,"Study","Short-mid-long term shared quiet room for focused work (4m2 per occupant)",null,1,"Low-Med","Med",4,"Quiet"]
["Secondary Individual ","Focus pod","Short-mid term refuge",null,1,"Low-Med","Low",2.5,"Quiet/Transitional"]
[null,"Touchdown","Short term landing between activities",null,1,"Low","Low",1.5,"Any"]
[null,"Phonebooth","Short term room for phone calls",null,1,"Med","Med- High",5,"Quiet"]
["Collaborative Open","Chat Point","Area for brief impromptu conversations",null,4,"Low","Low",4,"Interactive/Transitional"]
[null,"Huddle ","Informal short-mid length meeting area, open or semi-enclosed",null,4,"Low- Med","Low",5,"Interactive/Transitional"]
[null,"Teaming Area","Informal area to support team work and idea generation",null,8,"Low- Med","Low",15,"Interactive"]
[null,"Lounge","Open area with furniture for dining and/or social interaction",null,"10+","Low","Low",10,"Transitional"]
["Collaborative Enclosed","Work Room","Enclosed room for short-mid- term team work or meetings",null,6,"Med- High","Med",16,"Interactive/Transitional"]
[null,"Project Room","Enclosed room for mid-long term collaborative or creative work",null,8,"Med- High","Med",20,"Interactive/Transitional"]
[null,"Medium Meeting Room","Enclosed room for short-mid- term team work or meetings",null,12,"Med- High","Med-High",32,"Interactive/Transitional"]
[null,"Large Meeting Room","Enclosed room for formal meetings and presentations",null,"20+","Med- High","Med-High",60,"Interactive/Transitional"]
["Support Space","Kitchenette","Kitchen millwork and appliances only - to be combined with a Lounge to include seating",null,"N/A","Med","Med",15,"Transitional"]
[null,"Equipment","Business centre and printers",null,"N/A","Low","Low","5 m²","Transitional"]
[null,"Lockers","Individual storage lockers in centralized areas",null,"N/A","Low","Low","0.5m² per FTE","Transitional"]
[null,"Shared Storage","Open or enclosed space for shared resources or coat storage",null,"N/A","Low","Low","10 m²","Transitional"]
[null,"Dedicated Telecommunications Room","Enclosed room for telecommunications systems to be accessible from outside secure zone off elevator lobby",null,"N/A","N/A","N/A","10 m²","N/A"]