{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["About the Workbook","Dashboard","Appendix","HIDE"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS"]
[null,"All inputs are to be entered in the 'Dashboard'."]
[null,"Cells in light blue are input cells; other cells are protected to secure the integrity of the Workbook."]
[null,"The Dashboard will display a summary of space planning results."]
[]
[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 Workpoint Details"]
[]
[null,null,null,null,null,null,null,"VERSION RELEASE DATE:","2022-10-11"]

{"sheet":"Dashboard","index":1,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,19,5,21],[7,8,7,9],[8,8,8,9],[9,8,9,9],[24,2,24,3],[25,2,25,3],[21,1,21,2],[22,1,23,1],[24,1,26,1],[3,4,3,12],[4,4,4,12],[6,4,6,12],[7,10,7,11],[8,10,8,11],[9,10,9,11],[27,4,29,4],[21,7,21,8],[22,14,27,14],[28,14,32,14],[31,15,31,16],[32,15,32,16],[31,7,31,8],[34,15,34,16],[21,14,21,16],[33,14,34,14],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[29,15,29,16],[30,15,30,16],[27,15,27,16],[28,15,28,16],[33,15,33,16],[31,1,31,2],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[27,1,29,1],[29,2,29,3],[22,2,22,3],[30,2,30,3],[23,2,23,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,4,23,4],[24,4,26,4],[40,1,40,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[32,1,35,1],[36,1,39,1]]}
["GCworkplace SPACE PLANNING WORKBOOK"]
[]
[null,null,"INPUT PROJECT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,"VERIFY OUTPUT"]
[null,null,null,"Project Name / Department:",null,null,null,null,null,null,null,null,null,null,null,"Total Space",{"$f":"E13","v":0}]
[null,null,null,"Project Address:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Circulation (\"&S5&\"%)\"","v":"Circulation (35%)"},{"$f":"SUM(E13*-(S5/100))","v":0},null,35,"Adjust Circulation (35 - 40%) and \nBuilding Fit Factor (6 - 10%) as required"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Building Fit Factor (\"&S6&\"%)\"","v":"Building Fit Factor (6%)"},{"$f":"E13*-(S6/100)","v":0},null,6]
[null,null,"CHOOSE ACTIVITY PROFILE",null,"WORKPOINT DISTRIBUTION COMPARISON",null,null,null,null,null,null,null,null,null,null,"PLANNING SPACE",{"$f":"SUM(Q4:Q6)","v":0}]
[null,null,2,null,"Activity Profile",null,null,null,{"$f":"HIDE!A37","v":"Autonomous"},null,{"$f":"HIDE!A38","v":"Balanced"},null,{"$f":"HIDE!A39","v":"Interactive"}]
[null,null,null,null,"Individual Workpoints",null,null,null,"50-65%",null,"30-50%",null,"5-30%",null,null,"Individual Workpoints",{"$f":"M31","v":0}]
[null,null,null,null,"Collaborative Workpoints and Support Spaces",null,null,null,"35-50%",null,"50-70%",null,"70-95%",null,null,"Collaborative Workpoints",{"$f":"M41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Support Spaces",{"$f":"X36","v":0}]
[null,null,"INPUT KEY DATA",null,null,null,null,null,null,null,null,null,null,null,null,"ALLOCATED SPACE",{"$f":"SUM(Q9:Q11)","v":0}]
[null,null,null,"Space Solution in m2u:",null,null,"(does NOT include any Special Purpose Space (SPS))"]
[null,null,null,"Target occupancy:",{"$f":"ROUND(E13/11,0)","v":0},null,"(obtained by dividing the space solution by 11m2u)",null,null,null,null,null,null,null,null,"Planning Space",{"$f":"Q7","v":0}]
[null,null,null,"Current number of FTEs:",null,null,"(excludes occupants working in SPS)",null,null,null,null,null,null,null,null,"Allocated Space",{"$f":"-Q12","v":0}]
[null,null,null,"Built-in growth:",{"$f":"IF(E14-E15<>E14,E14-E15,0)","v":0},null,"(obtained by subtracting actual population from target occupancy)",null,null,null,null,null,null,null,null,{"$f":"IF(Q16=0,\"NO SURPLUS / DEFICIT\", IF(Q16>0,\"SURPLUS\",\"DEFICIT\"))","v":"NO SURPLUS / DEFICIT"},{"$f":"Q7-Q12","v":0}]
[null,null,null,"Full Time SPS Population:",null,null,"(only when directly adjacent to the general office)"]
[]
[null,null,"ADJUST NUMBER OF WORKPOINTS",null,null,null,null,null,null,null,null,null,null,null,null,"VERIFY SURPLUS / DEFICIT",{"$f":"Q16","v":0}]
[]
[]
[null,"INDIVIDUAL WORKPOINTS",null,null,"Total number of seats","Standard Allocation","QTY.","Adjust required workpoint quantities using scrollbars",null,null,"Suggested size",null,"Required area",null,"SUPPORT SPACES",null,null,"Standard Allocation","QTY.","Adjust required workpoint quantities using scrollbars",null,"Suggested size",null,"Required area"]
[null,{"$f":"HIDE!A6","v":"PRIMARY \nINDIVIDUAL \nOPEN"},{"$f":"HIDE!B6","v":"Workstation"},null,{"$f":"G23+G24","v":0},{"$f":"HIDE!M6","v":0},0,null,null,"x",3.5,"=",{"$f":"G23*K23","v":0},null,{"$f":"HIDE!A22","v":"GENERAL PURPOSE \nOFFICE SPACE"},{"$f":"HIDE!B22","v":"Kitchenette"},null,{"$f":"HIDE!M22","v":0},0,2,"x",5,"=",{"$f":"S23*V23","v":0}]
[null,null,{"$f":"HIDE!B7","v":"Work Pod"},null,null,{"$f":"HIDE!M7","v":0},0,null,null,"x",2.5,"=",0,null,null,{"$f":"HIDE!B23","v":"Wellness Room"},null,{"$f":"HIDE!M23","v":0},0,2,"x",7.5,"=",0]
[null,{"$f":"HIDE!A8","v":"PRIMARY INDIVIDUAL ENCLOSED"},{"$f":"HIDE!B8","v":"Focus Room"},null,{"$f":"G25+G26+G27","v":0},{"$f":"HIDE!M8","v":0},0,null,null,"x",7.5,"=",0,null,null,{"$f":"HIDE!B24","v":"Equipment Area"},null,{"$f":"HIDE!M24","v":0},0,2,"x",5,"=",0]
[null,null,{"$f":"HIDE!B9","v":"Ministerial Dedicated \n(Deputy Head or Minister)"},null,null,{"$f":"HIDE!M9","v":0},0,null,null,"x",29,"=",0,null,null,{"$f":"HIDE!B25","v":"Lockers \n(Area is per FTE)"},null,{"$f":"HIDE!M25","v":0},0,116,"x",0.5,"=",0]
[null,null,{"$f":"HIDE!B10","v":"Study \n(4m2 per occupant)"},null,null,{"$f":"HIDE!M10","v":0},0,null,null,"x",4,"=",0,null,null,{"$f":"HIDE!B26","v":"Shared Storage"},null,{"$f":"HIDE!M26","v":0},0,1,"x",5,"=",0]
[null,{"$f":"HIDE!A11","v":"SECONDARY INDIVIDUAL"},{"$f":"HIDE!B11","v":"Focus Pod"},null,{"$f":"G28+G29+G30","v":0},{"$f":"HIDE!M11","v":0},0,null,null,"x",2.5,"=",{"$f":"G28*K28","v":0},null,null,{"$f":"HIDE!B27","v":"Dedicated Server/Telecom Room\n(1 per floor)"},null,{"$f":"HIDE!M27","v":0},0,1,"x",10,"=",0]
[null,null,{"$f":"HIDE!B12","v":"Touchdown\n(1.5m2 per occupant)"},null,null,{"$f":"HIDE!M12","v":0},0,null,null,"x",1.5,"=",0,null,{"$f":"HIDE!A28","v":"EXTRA WORKPOINTS AND SUPPORT SPACES FOR ADJACENT SPS POPULATION"},{"$f":"HIDE!B28","v":"Phonebooth"},null,{"$f":"HIDE!M28","v":0},0,0,"x",5,"=",0]
[null,null,{"$f":"HIDE!B13","v":"Phonebooth"},null,null,{"$f":"HIDE!M13","v":0},0,null,null,"x",5,"=",0,null,null,{"$f":"HIDE!B29","v":"Lounge"},null,{"$f":"HIDE!M29","v":0},0,0,"x",10,"=",0]
[null,null,"Total number of individual seats",null,{"$f":"SUM(E23:E30)","v":0},null,null,null,null,null,null,"Total space for individual workpoints",{"$f":"SUM(M23:M30)","v":0},null,null,{"$f":"HIDE!B30","v":"Work Room"},null,{"$f":"HIDE!M30","v":0},0,0,"x",15,"=",0]
[null,"COLLABORATIVE WORKPOINTS",null,null,"Est. number of seats","Standard Allocation","QTY.","Adjust required workpoint quantities using scrollbars",null,null,"Suggested size",null,"Required area",null,null,{"$f":"HIDE!B31","v":"Kitchenette"},null,{"$f":"HIDE!M31","v":0},0,0,"x",5,"=",0]
[null,{"$f":"HIDE!A14","v":"COLLABORATIVE \nOPEN"},{"$f":"HIDE!B14","v":"Chat Point"},null,{"$f":"SUM(G33)*4","v":0},{"$f":"HIDE!M14","v":0},0,null,null,"x",4,"=",{"$f":"G33*K33","v":0},null,null,{"$f":"HIDE!B32","v":"Lockers Area \n(Area is per FTE)"},null,{"$f":"HIDE!M32","v":0},0,0,"x",0.5,"=",0]
[null,null,{"$f":"HIDE!B15","v":"Huddle "},null,{"$f":"SUM(G34)*4","v":0},{"$f":"HIDE!M15","v":0},0,null,null,"x",5,"=",0,null,{"$f":"HIDE!A33","v":"OTHER"},{"$f":"HIDE!B33","v":"Custom Support Space"},null,{"$f":"HIDE!M33","v":0},0,0,"x",0,"=",{"$f":"S34*V34","v":0}]
[null,null,{"$f":"HIDE!B16","v":"Teaming Area"},null,{"$f":"SUM(G35)*8","v":0},{"$f":"HIDE!M16","v":0},0,null,null,"x",15,"=",0,null,null,{"$f":"HIDE!B34","v":"Custom Workpoint"},null,{"$f":"HIDE!M34","v":0},0,0,"x",0,"=",0]
[null,null,{"$f":"HIDE!B17","v":"Lounge"},null,{"$f":"SUM(G36)*10","v":0},{"$f":"HIDE!M17","v":0},0,null,null,"x",10,"=",0,null,null,null,null,null,null,null,null,null,"Total space for support spaces",{"$f":"SUM(X23:X35)","v":0}]
[null,{"$f":"HIDE!A18","v":"COLLABORATIVE \nENCLOSED"},{"$f":"HIDE!B18","v":"Work Room"},null,{"$f":"SUM(G37)*6","v":0},{"$f":"HIDE!M18","v":0},0,null,null,"x",16,"=",0]
[null,null,{"$f":"HIDE!B19","v":"Project Room"},null,{"$f":"SUM(G38)*8","v":0},{"$f":"HIDE!M19","v":0},0,null,null,"x",20,"=",0]
[null,null,{"$f":"HIDE!B20","v":"Medium Meeting Room"},null,{"$f":"SUM(G39)*12","v":0},{"$f":"HIDE!M20","v":0},0,null,null,"x",32,"=",0]
[null,null,{"$f":"HIDE!B21","v":"Large Meeting Room"},null,{"$f":"SUM(G40)*20","v":0},{"$f":"HIDE!M21","v":0},0,null,null,"x",60,"=",0]
[null,"Estimated number of collaborative seats",null,null,{"$f":"SUM(E33:E40)","v":0},null,null,null,null,null,null,"Total space for collaborative workpoints",{"$f":"SUM(M33:M40)","v":0}]

{"sheet":"Appendix","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,6,0,7],[20,0,25,0],[9,0,11,0],[16,0,19,0],[12,0,15,0],[4,0,5,0],[6,0,8,0],[2,1,2,7]]}
["APPENDIX: GCworkplace WORKPOINT DETAILS",null,null,null,null,null,"Back to 'About the Workbook'"]
[]
["WORKPOINTS","A workpoint is any space where someone can perform their work, and is designed specifically to support different functional requirements and/or personal preferences. Each workpoint is equipped with furnishings and digital tools that support a variety of tasks and varying degrees of interaction or concentration."]
[null,"Workpoint name","Typical activity and duration","Number of seat","Visual privacy level","Acoustic privacy level","Typical size","Recommended zone"]
[{"$f":"HIDE!A6","v":"PRIMARY \nINDIVIDUAL \nOPEN"},{"$f":"HIDE!B6","v":"Workstation"},"Mid-long term focused work",1,"Low-Med","Low",{"$f":"HIDE!C6","v":3.5},"Any"]
[null,{"$f":"HIDE!B7","v":"Work Pod"},"Short-mid term focused work in semi-enclosed furniture",1,"Low-Med","Low",{"$f":"HIDE!C7","v":2.5},"Quiet/Transitional"]
[{"$f":"HIDE!A8","v":"PRIMARY INDIVIDUAL ENCLOSED"},{"$f":"HIDE!B8","v":"Focus Room"},"Mid-long term focused work",1,"Med-High","Med",{"$f":"HIDE!C8","v":7.5},"Any"]
[null,{"$f":"HIDE!B9","v":"Ministerial Dedicated \n(Deputy Head or Minister)"},"Dedicated office (including 9m2 washroom) for a Minister",1,"Med - High","Med - High",{"$f":"HIDE!C9","v":29},"Transitional"]
[null,{"$f":"HIDE!B10","v":"Study \n(4m2 per occupant)"},"Short-mid-long term shared quiet room for focused work with a variety of individual workpoints",1,"Low-Med","Med",{"$f":"HIDE!C10","v":4},"Quiet"]
[{"$f":"HIDE!A11","v":"SECONDARY INDIVIDUAL"},{"$f":"HIDE!B11","v":"Focus Pod"},"Short-mid term focused work in informal semi-enclosed furniture",1,"Low-Med","Low",{"$f":"HIDE!C11","v":2.5},"Quiet"]
[null,{"$f":"HIDE!B12","v":"Touchdown\n(1.5m2 per occupant)"},"Short term landing between activities",1,"Low","Low",{"$f":"HIDE!C12","v":1.5},"Any"]
[null,{"$f":"HIDE!B13","v":"Phonebooth"},"Short term room for phone calls",1,"Med","Med- High",{"$f":"HIDE!C13","v":5},"Any"]
[{"$f":"HIDE!A14","v":"COLLABORATIVE \nOPEN"},{"$f":"HIDE!B14","v":"Chat Point"},"Area for brief impromptu conversations",4,"Low","Low",{"$f":"HIDE!C14","v":4},"Interactive/Transitional"]
[null,{"$f":"HIDE!B15","v":"Huddle "},"Informal short-mid term meeting area, open or semi-enclosed",4,"Low- Med","Low",{"$f":"HIDE!C15","v":5},"Interactive/Transitional"]
[null,{"$f":"HIDE!B16","v":"Teaming Area"},"Informal area to support mid term team work and idea generation",8,"Low- Med","Low",{"$f":"HIDE!C16","v":15},"Interactive"]
[null,{"$f":"HIDE!B17","v":"Lounge"},"Open area with furniture for dining and/or social interaction","10+","Low","Low",{"$f":"HIDE!C17","v":10},"Interactive/Transitional"]
[{"$f":"HIDE!A18","v":"COLLABORATIVE \nENCLOSED"},{"$f":"HIDE!B18","v":"Work Room"},"Enclosed room for short-mid term team work or informal meetings",6,"Med- High","Med",{"$f":"HIDE!C18","v":16},"Interactive/Transitional"]
[null,{"$f":"HIDE!B19","v":"Project Room"},"Enclosed room for mid-long term collaborative or creative work",8,"Med- High","Med",{"$f":"HIDE!C19","v":20},"Interactive/Transitional"]
[null,{"$f":"HIDE!B20","v":"Medium Meeting Room"},"Enclosed room for short-mid term team work or meetings",12,"Med- High","Med-High",{"$f":"HIDE!C20","v":32},"Interactive/Transitional"]
[null,{"$f":"HIDE!B21","v":"Large Meeting Room"},"Enclosed room for formal meetings and presentations","20+","Med- High","Med-High",{"$f":"HIDE!C21","v":60},"Interactive/Transitional"]
[{"$f":"HIDE!A22","v":"GENERAL PURPOSE \nOFFICE SPACE"},{"$f":"HIDE!B22","v":"Kitchenette"},"Kitchen millwork and appliances only - to be combined with a Lounge to include seating","N/A","Med","Med",{"$f":"HIDE!C22","v":5},"Interactive/Transitional"]
[null,{"$f":"HIDE!B23","v":"Wellness Room"},"Short-mid term relaxation room",1,"Med-High","Med",{"$f":"HIDE!C23","v":7.5},"Quiet/Transitional"]
[null,{"$f":"HIDE!B24","v":"Equipment Area"},"Business centre and printers","N/A","Low","Low",{"$f":"HIDE!C24","v":5},"Transitional"]
[null,{"$f":"HIDE!B25","v":"Lockers \n(Area is per FTE)"},"Individual storage lockers in centralized areas, benches and coat storage","N/A","Low","Low",{"$f":"HIDE!C25","v":0.5},"Transitional"]
[null,{"$f":"HIDE!B26","v":"Shared Storage"},"Open or enclosed space for shared resources or filling","N/A","Low","Low",{"$f":"HIDE!C26","v":5},"Transitional"]
[null,{"$f":"HIDE!B27","v":"Dedicated Server/Telecom Room\n(1 per floor)"},"Enclosed room for telecommunications systems to be accessible from outside secure zone off elevator lobby","N/A","N/A","N/A",{"$f":"HIDE!C27","v":10},"N/A"]

{"sheet":"HIDE","index":3,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":true,"merged":[[7,0,9,0],[10,0,12,0],[27,0,31,0],[26,5,26,9],[32,0,33,0],[13,0,16,0],[17,0,20,0],[21,0,26,0],[2,13,2,14],[2,5,2,9],[3,5,3,9],[3,13,3,14],[5,0,6,0]]}
["FORMULAS AND CALCULATIONS"]
["HEADINGS IN RED INDICATE COLUMNS WHERE DATA CAN BE ALTERED. HEADINGS IN BLACK ARE CALCULATED USING FORMULAS."]
["Names input here are what the \"Dashboard\" and \"Appendix\" use to populate the name of workpoint categories","Names input here are what the \"Dashboard\" and \"Appendix\" use to populate workpoint names","This column identifies the m2 that the Reset button on the \"Dashboard\" uses in the Suggested Size column. This column is also used to populate the Suggested Size column on the \"Appendix\" tab.","This column identifies the m2 at which cells in the Suggested Size column on the \"Dashboard\" turn orange.","This is the factor used to calculate minimum permitted quantity (column \"N\" on this tab).","These columns set the quantity baselines for a target occupancy of 100. Values may be determined by a formula or be a manual input.",null,null,null,null,"This is the factor used to calculate maximum permitted quantity (column \"O\" on this tab).","This determines what activity profile on the \"Dashboard\" and displays the suggested quantities for a target occupancy of 100.","This uses the Activity Profile column on this sheet and determines the suggested number of workpoints based on Target Occupancy input in the \"Dashboard\". These quantites are used to populate the Standard Allocation columns on the \"Dashboard\"","These columns calculate, and round, the quantity range for each workpoint based on target occupancy (or SPS population for rows 28 to 32) result from m2 input in the \"Dashboard\". These quantities are used to determine when a cell should go blue or orange when a user adjusts the sliders."]
["TYPE","WORKPOINT","SUGGESTED SIZE","MAX. SIZE",null,"QTY. FOR 100 PEOPLE (1100m2u)",null,null,null,null,null,"ACTIVITY PROFILE","SUGGESTED QTY.","QTY. RANGE",null,"COMMENTS"]
[null,null,null,null,"FACTOR","MINIMUM","AUTONOMOUS","BALANCED","INTERACTIVE","MAXIMUM","FACTOR",{"$f":"IF(Dashboard!C8=1,\"AUTONOMOUS\",IF(Dashboard!C8=2,\"BALANCED\",\"INTERACTIVE\"))","v":"BALANCED"},null,"LOW","HIGH"]
["PRIMARY \nINDIVIDUAL \nOPEN","Workstation",3.5,4.5,{"$f":"F6/100","v":0.15},15,40,30,20,60,{"$f":"J6/100","v":0.6},{"$f":"CHOOSE(Dashboard!$C$8, G6,H6,I6)","v":30},{"$f":"ROUND(Dashboard!$E$14*HIDE!L6/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E6, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K6, 0)","v":0}]
[null,"Work Pod",2.5,3.5,0.02,2,6,5,4,10,0.1,{"$f":"CHOOSE(Dashboard!$C$8, G7,H7,I7)","v":5},{"$f":"ROUND(Dashboard!$E$14*HIDE!L7/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E7, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K7, 0)","v":0}]
["PRIMARY INDIVIDUAL ENCLOSED","Focus Room",7.5,10,0.04,4,8,7,6,12,0.12,{"$f":"CHOOSE(Dashboard!$C$8, G8,H8,I8)","v":7},{"$f":"ROUND(Dashboard!$E$14*HIDE!L8/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E8, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K8, 0)","v":0}]
[null,"Ministerial Dedicated \n(Deputy Head or Minister)",29,29,0,0,0,0,0,0,0,{"$f":"CHOOSE(Dashboard!$C$8, G9,H9,I9)","v":0},{"$f":"ROUND(Dashboard!$E$14*HIDE!L9/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E9, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K9, 0)","v":0}]
[null,"Study \n(4m2 per occupant)",4,4,0.1,10,12,12,12,15,0.15,{"$f":"CHOOSE(Dashboard!$C$8, G10,H10,I10)","v":12},{"$f":"ROUND(Dashboard!$E$14*HIDE!L10/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E10, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K10, 0)","v":0}]
["SECONDARY INDIVIDUAL","Focus Pod",2.5,3.5,0.02,2,4,4,4,6,0.06,{"$f":"CHOOSE(Dashboard!$C$8, G11,H11,I11)","v":4},{"$f":"ROUND(Dashboard!$E$14*HIDE!L11/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E11, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K11, 0)","v":0}]
[null,"Touchdown\n(1.5m2 per occupant)",1.5,2,0.08,8,12,14,16,30,0.3,{"$f":"CHOOSE(Dashboard!$C$8, G12,H12,I12)","v":14},{"$f":"ROUND(Dashboard!$E$14*HIDE!L12/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E12, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K12, 0)","v":0}]
[null,"Phonebooth",5,5,0.04,4,6,5,4,10,0.1,{"$f":"CHOOSE(Dashboard!$C$8, G13,H13,I13)","v":5},{"$f":"ROUND(Dashboard!$E$14*HIDE!L13/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E13, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K13, 0)","v":0}]
["COLLABORATIVE \nOPEN","Chat Point",4,8,0.01,1,1,2,3,5,0.05,{"$f":"CHOOSE(Dashboard!$C$8, G14,H14,I14)","v":2},{"$f":"ROUND(Dashboard!$E$14*HIDE!L14/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E14, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K14, 0)","v":0}]
[null,"Huddle ",5,6,0.01,1,2,2,3,6,0.06,{"$f":"CHOOSE(Dashboard!$C$8, G15,H15,I15)","v":2},{"$f":"ROUND(Dashboard!$E$14*HIDE!L15/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E15, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K15, 0)","v":0}]
[null,"Teaming Area",15,20,0.01,1,1,1,2,4,0.04,{"$f":"CHOOSE(Dashboard!$C$8, G16,H16,I16)","v":1},{"$f":"ROUND(Dashboard!$E$14*HIDE!L16/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E16, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K16, 0)","v":0}]
[null,"Lounge",10,15,0.02,2,2,2,2,3,0.03,{"$f":"CHOOSE(Dashboard!$C$8, G17,H17,I17)","v":2},{"$f":"ROUND(Dashboard!$E$14*HIDE!L17/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E17, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K17, 0)","v":0}]
["COLLABORATIVE \nENCLOSED","Work Room",16,20,0.02,2,3,3,4,6,0.06,{"$f":"CHOOSE(Dashboard!$C$8, G18,H18,I18)","v":3},{"$f":"ROUND(Dashboard!$E$14*HIDE!L18/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E18, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K18, 0)","v":0}]
[null,"Project Room",20,25,0.01,1,1,2,3,6,0.06,{"$f":"CHOOSE(Dashboard!$C$8, G19,H19,I19)","v":2},{"$f":"ROUND(Dashboard!$E$14*HIDE!L19/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E19, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K19, 0)","v":0}]
[null,"Medium Meeting Room",32,40,0.01,1,1,2,2,4,0.04,{"$f":"CHOOSE(Dashboard!$C$8, G20,H20,I20)","v":2},{"$f":"ROUND(Dashboard!$E$14*HIDE!L20/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E20, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K20, 0)","v":0}]
[null,"Large Meeting Room",60,70,0,0,1,1,1,2,0.02,{"$f":"CHOOSE(Dashboard!$C$8, G21,H21,I21)","v":1},{"$f":"ROUND(Dashboard!$E$14*HIDE!L21/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E21, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K21, 0)","v":0}]
["GENERAL PURPOSE \nOFFICE SPACE","Kitchenette",{"$f":"IF(Dashboard!$E$14<25,5,IF(AND(Dashboard!$E$14>=25,Dashboard!$E$14<50),10,15))","v":5},"N/A","N/A",1,1,1,1,1,"N/A",{"$f":"CHOOSE(Dashboard!$C$8, G22,H22,I22)","v":1},{"$f":"IF(Dashboard!$E$14=0,0,ROUNDUP(Dashboard!$E$14/150,0))","v":0},{"$f":"ROUNDUP(Dashboard!$E$14/150, 0)","v":0},{"$f":"ROUNDUP(Dashboard!$E$14/150, 0)","v":0},"1-5m2 for 1-24 occupants; 1-10m2 for 25-49 occupants; 1-15m2 for 50-150 occupants; 2-15m2 for 151-300 occupants and so on"]
[null,"Wellness Room",7.5,10,"N/A",2,2,2,2,2,"N/A",{"$f":"CHOOSE(Dashboard!$C$8, G23,H23,I23)","v":2},{"$f":"IF(Dashboard!$E$14=0,0,ROUNDUP(Dashboard!$E$14*HIDE!L23/100,0))","v":0},{"$f":"ROUNDUP(Dashboard!$E$14/50, 0)","v":0},{"$f":"ROUNDUP(Dashboard!$E$14/50, 0)","v":0},"1 - 7,5m2 for  every 50 occupants"]
[null,"Equipment Area",5,10,{"$f":"F24/100","v":0.01},1,2,2,2,2,{"$f":"J24/100","v":0.02},{"$f":"CHOOSE(Dashboard!$C$8, G24,H24,I24)","v":2},{"$f":"IF(Dashboard!$E$14=0,0,ROUNDUP(Dashboard!$E$14*HIDE!L24/100,0))","v":0},{"$f":"ROUNDUP(Dashboard!$E$14*E24, 0)","v":0},{"$f":"ROUNDUP(Dashboard!$E$14*K24, 0)","v":0},"1 - 5m2 for every 50 occupants"]
[null,"Lockers \n(Area is per FTE)",0.5,"N/A",{"$f":"F25/100","v":1},100,100,100,100,125,{"$f":"J25/100","v":1.25},{"$f":"CHOOSE(Dashboard!$C$8, G25,H25,I25)","v":100},{"$f":"ROUND(Dashboard!$E$14*HIDE!L25/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E25, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K25, 0)","v":0},"At least 1 per occupants (include space for coat closets and benches)"]
[null,"Shared Storage",5,10,{"$f":"F26/100","v":0},0,0,0,0,1,{"$f":"J26/100","v":0.01},{"$f":"CHOOSE(Dashboard!$C$8, G26,H26,I26)","v":0},{"$f":"ROUND(Dashboard!$E$14*HIDE!L26/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$14*E26, 0)","v":0},{"$f":"ROUND(Dashboard!$E$14*K26, 0)","v":0},"Default is 0. 1-5m2 per 100 occupants"]
[null,"Dedicated Server/Telecom Room\n(1 per floor)",10,"N/A","N/A","This workpoint always defaults to 1 regardless of m2, except when m2 = 0, then it defaults to 0",null,null,null,null,"N/A",{"$f":"IF(Dashboard!E13=0,0,1)","v":0},{"$f":"L27","v":0},0,{"$f":"L27","v":0},"Default is 1, but can be removed if not needed"]
["EXTRA WORKPOINTS AND SUPPORT SPACES FOR ADJACENT SPS POPULATION","Phonebooth",5,5,{"$f":"F28/100","v":0.04},4,6,5,4,8,{"$f":"J28/100","v":0.08},{"$f":"CHOOSE(Dashboard!$C$8, G28,H28,I28)","v":5},{"$f":"ROUND(Dashboard!$E$17*HIDE!L28/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*E28,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*K28,0)","v":0}]
[null,"Lounge",10,15,{"$f":"F29/100","v":0.02},2,2,2,2,3,{"$f":"J29/100","v":0.03},{"$f":"CHOOSE(Dashboard!$C$8, G29,H29,I29)","v":2},{"$f":"ROUND(Dashboard!$E$17*HIDE!L29/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*E29,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*K29,0)","v":0}]
[null,"Work Room",15,20,{"$f":"F30/100","v":0.02},2,2,3,4,6,{"$f":"J30/100","v":0.06},{"$f":"CHOOSE(Dashboard!$C$8, G30,H30,I30)","v":3},{"$f":"ROUND(Dashboard!$E$17*HIDE!L30/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*E30,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*K30,0)","v":0}]
[null,"Kitchenette",{"$f":"IF(Dashboard!$E$17<25,5,IF(AND(Dashboard!$E$17>=25,Dashboard!$E$17<50),10,15))","v":5},"N/A","N/A",1,1,1,1,1,"N/A",{"$f":"CHOOSE(Dashboard!$C$8, G31,H31,I31)","v":1},{"$f":"IF(Dashboard!$E$17=0, 0, ROUNDUP(Dashboard!$E$17/150,0))","v":0},{"$f":"ROUNDUP(Dashboard!$E$17/150, 0)","v":0},{"$f":"ROUNDUP(Dashboard!$E$17/150, 0)","v":0},"1-5m2 for 1-24 occupants; 1-10m2 for 25-49 occupants; 1-15m2 for 50-150 occupants; 2-15m2 for 151-300 occupants and so on"]
[null,"Lockers Area \n(Area is per FTE)",0.5,"N/A",{"$f":"F32/100","v":1},100,100,100,100,125,{"$f":"J32/100","v":1.25},{"$f":"CHOOSE(Dashboard!$C$8, G32,H32,I32)","v":100},{"$f":"ROUND(Dashboard!$E$17*HIDE!L32/100,0)","v":0},{"$f":"ROUND(Dashboard!$E$17*E32, 0)","v":0},{"$f":"ROUND(Dashboard!$E$17*K32, 0)","v":0}]
["OTHER","Custom Support Space",{"$f":"ROUND(Dashboard!Q7*0.01,0)","v":0},{"$f":"ROUND(Dashboard!Q7*0.015,0)","v":0},"N/A",null,null,null,null,null,null,{"$f":"CHOOSE(Dashboard!$C$8, G33,H33,I33)","v":0},{"$f":"CHOOSE(Dashboard!$C$8, H33,I33,J33)","v":0},0,0,"Can be used as required. Default size is 1% of total space for planning. Minimum is 0% and Maximum is 1.5%"]
[null,"Custom Workpoint",0,"N/A","N/A",null,null,null,null,null,null,{"$f":"CHOOSE(Dashboard!$C$8, G34,H34,I34)","v":0},{"$f":"CHOOSE(Dashboard!$C$8, H34,I34,J34)","v":0},0,0,"If adding a custom workpoint to support a specific function, specify quantity and size. Equal quantities of other workpoints will need to be reduced. Justification is required."]
[]
["ACTIVITY PROFILE DROPDOWN LIST"]
["Autonomous"]
["Balanced"]
["Interactive"]