{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Shared Cost Summary","Area Allocation"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":5,"defined_names":35,"comments":1,"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":"Shared Cost Summary","index":0,"n_rows":96,"n_cols":16,"rows_kept":96,"cut":false,"hidden":false,"merged":[[15,1,15,14],[17,5,17,14],[1,1,1,5],[3,1,3,5],[4,1,4,5],[9,1,9,5],[11,1,11,5],[2,1,2,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[5,1,5,5],[14,1,14,14]]}
[]
[null,"User Instructions"]
[null,"_The workbook is a starting point to work out and communicate the area allocation and associated operational costs of the co-location. When complete the Annual Estimate of Shared Costs and Area Allocation tables are included in the Co-location Agreement. Please check all formulas are working correctly before issuing."]
[null,"_Fill out the Area Allocation tab first. This will populate the first 4 rows of the Shared Costs table below."]
[null,"_Fill out the financial assumptions in the grey boxes. The grey boxes amount should relate to the unit of measure as described."]
[null,"_Most agencies use a comparable site's operational spend to assess what the estimates might be. Feel free to add working sheets to calculate your agency's financial assumptions and work them appropriately. Add assumptions and/or specific notes about the calculation in the comments column. You can also add any specifics about the service being offered in that column."]
[null,"_Customise any red text. Feel free to customise other descriptions to better reflect what services are being provided in the Co-location. Any comments or clarifications can also be added to the comments column."]
[null,"_Hide any unneeded Occupant columns. Try not to delete columns as this can affect formulas. If you add columns then adjust formulas as required."]
[null,"_A relatively comprehensive list of possible services have been included in the costings below. If your co-location is not providing some of the services you can hide any unneeded items or keep at nil/not applicable. Try not to delete rows as this can affect formulas. If you would like to add services, add in rows in the applicable area and adjust formulas as required."]
[null,"_Amend unit of measures as appropriate to your co-location - note that this will likely affect the row's formula."]
[]
[]
[]
[]
[null,"[Building]: Annual Estimate of Shared Costs"]
[null,"[insert date]"]
[]
[null,null,null,"Unit of Measure","Cost per Unit of Measure","Annual charge",null,null,null,null,null,null,null,null,null,"Comments/Assumptions for calculations used"]
[null,"Square meterage per Lease",null,null,null,{"$f":"'Area Allocation'!$C64","v":0},{"$f":"'Area Allocation'!$C65","v":0},{"$f":"'Area Allocation'!$C66","v":0},{"$f":"'Area Allocation'!$C67","v":0},{"$f":"'Area Allocation'!$C68","v":0},{"$f":"'Area Allocation'!$C69","v":0},{"$f":"'Area Allocation'!$C70","v":0},{"$f":"'Area Allocation'!$C71","v":0},{"$f":"'Area Allocation'!$C72","v":0},{"$f":"SUM(F19:N19)","v":0},"Comments/Assumptions for calculations used"]
[null,null,null,null,null,{"$f":"'Area Allocation'!$B16","v":"Lead agency"},{"$f":"'Area Allocation'!$B17","v":"Occupant 2"},{"$f":"'Area Allocation'!$B18","v":"Occupant 3"},{"$f":"'Area Allocation'!$B19","v":"Occupant 4"},{"$f":"'Area Allocation'!$B20","v":"Occupant 5"},{"$f":"'Area Allocation'!$B21","v":"Occupant 6"},{"$f":"'Area Allocation'!$B22","v":"Occupant 7"},{"$f":"'Area Allocation'!$B23","v":"Occupant 8"},{"$f":"'Area Allocation'!$B24","v":"Occupant 9"},"TOTAL"]
[null,"Adjusted NLA Share",null,"Per Lease Agreement",null,{"$f":"'Area Allocation'!F64","v":0},{"$f":"'Area Allocation'!F65","v":0},{"$f":"'Area Allocation'!$F66","v":0},{"$f":"'Area Allocation'!$F67","v":0},{"$f":"'Area Allocation'!$F68","v":0},{"$f":"'Area Allocation'!$F69","v":0},{"$f":"'Area Allocation'!$F70","v":0},{"$f":"'Area Allocation'!$F71","v":0},{"$f":"'Area Allocation'!$F72","v":0},{"$f":"SUM(F21:N21)","v":0},"Comments/Assumptions for calculations used"]
[null,"Number of people",null,null,null,{"$f":"'Area Allocation'!C16","v":0},{"$f":"'Area Allocation'!C17","v":0},{"$f":"'Area Allocation'!$C18","v":0},{"$f":"'Area Allocation'!$C19","v":0},{"$f":"'Area Allocation'!$C20","v":0},{"$f":"'Area Allocation'!$C21","v":0},{"$f":"'Area Allocation'!$C22","v":0},{"$f":"'Area Allocation'!$C23","v":0},{"$f":"'Area Allocation'!$C24","v":0},{"$f":"SUM(F22:N22)","v":0},"Comments/Assumptions for calculations used"]
[null,"Number of carparks",null,null,null,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F23:N23)","v":0},"Comments/Assumptions for calculations used"]
[null,"Rent",null,"Annual per SQM",0,{"$f":"$E$24*F19","v":0},{"$f":"$E$24*G19","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F24:N24)","v":0},"Comments/Assumptions for calculations used"]
[null,"Car Park Rental",null,"Annual per car park",0,{"$f":"$E$25*F$23","v":0},{"$f":"$E$25*G$23","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F25:N25)","v":0},"Comments/Assumptions for calculations used"]
[null,"TOTAL RENT",null,null,null,{"$f":"SUM(F24:F25)","v":0},{"$f":"SUM(G24:G25)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O24:O25)","v":0}]
[]
[null,"CAPITAL CONTRIBUTION",null,"Total capital",0,{"$f":"$E$28*F21","v":0},{"$f":"$E$28*G21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F28:N28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments/Assumptions for calculations used"]
[null,"ESTIMATES Shared Costs: Outgoings and consumables",null,null,null,null,null,null,null,null,null,null,null,null,null,"Comments/Assumptions for calculations used"]
[null,null,"Non IT costs - general",null,null,null,null,null,null,null,null,null,null,null,null,"Comments/Assumptions for calculations used"]
[null,null,"Building security","Annual per SQM",0,{"$f":"$E$32*F$19","v":0},{"$f":"$E$32*G$19","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F32:N32)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Cleaning (including recycling and rubbish removal)","Annual per SQM",0,{"$f":"$E$33*F$19","v":0},{"$f":"$E$33*G$19","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F33:N33)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Heat, light & power","Annual per SQM",0,{"$f":"$E$34*F$19","v":0},{"$f":"$E$34*G$19","v":0},0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Insurance","Annual per SQM",0,{"$f":"$E$35*F$19","v":0},{"$f":"$E$35*G$19","v":0},0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Office maintenance","Annual per SQM",0,{"$f":"$E36*F$19","v":0},{"$f":"$E36*G$19","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F36:N36)","v":0},"Comments/Assumptions for calculations used"]
[null,"TOTAL NON IT COSTS GENERAL",null,null,null,{"$f":"SUM(F32:F36)","v":0},{"$f":"SUM(G32:G36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O32:O36)","v":0}]
[]
[null,null,"Non IT cost - consumables"]
[null,null,"Kitchen consumables","Annual charge",0,{"$f":"$E40*F$21","v":0},{"$f":"$E40*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F40:N40)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Printing and Stationery","Annual charge",0,{"$f":"$E41*F$21","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(F41:N41)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Emergency consumables (Civil Defence, First Aid, Grab-bags)","Annual charge",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F42:N42)","v":0},"Comments/Assumptions for calculations used"]
[null,"TOTAL NON IT COSTS - CONSUMABLES",null,null,null,{"$f":"SUM(F40:F42)","v":0},{"$f":"SUM(G40:G42)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O40:O42)","v":0}]
[]
[null,null,"Non IT cost - Other"]
[null,null,"Health & Safety training ","Annual charge",0,{"$f":"$E46*F$21","v":0},{"$f":"$E46*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F46:N46)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Building support/management resources","Annual charge",0,{"$f":"$E47*F$21","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(F47:N47)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Insert additional services","Annual charge",0,0,0,0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,"TOTAL NON IT COSTS OTHER",null,null,null,{"$f":"SUM(F46:F48)","v":0},{"$f":"SUM(G46:G48)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O46:O48)","v":0}]
[]
[]
[null,null,"IT costs"]
[null,null,"Base connectivity - wireless primary - Medium Site","Annual per user",0,{"$f":"E53*F22*12","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(F53:N53)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Uplift - Enhanced wifi","Annual per bundle",0,{"$f":"E54*F19*12","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(F54:N54)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Uplift - Switching uplift","Annual charge all switches",0,{"$f":"E55*F19*12","v":0},0,0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Uplift - legacy overlay","Agency specific",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F56:N56)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"High Availability - WAN ","Annual per bundle",0,{"$f":"E57*12*F$21","v":0},{"$f":"F57*12*G$21","v":0},0,0,0,0,0,0,{"$f":"M57*12*N$21","v":0},0,"Comments/Assumptions for calculations used"]
[null,null,"High Availability - LAN","Annual per bundle",0,{"$f":"E58*12*F$21","v":0},0,0,0,0,0,0,0,{"$f":"M58*12*N$21","v":0},0,"Comments/Assumptions for calculations used"]
[null,null,"High Availability - Wireless","Annual per bundle",0,0,0,0,0,0,0,0,0,{"$f":"M59*12*N$21","v":0},0,"Comments/Assumptions for calculations used"]
[null,null,"Meeting room support","Annual charge all rooms",0,{"$f":"E60*F21*12","v":0},0,0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"DIA Lead Agency Fee in total","2.5% of total costs above",null,{"$f":"SUM(F53:F60)*2.5%","v":0},{"$f":"SUM(G53:G60)*2.5%","v":0},0,0,0,0,0,0,{"$f":"SUM(N53:N60)*2.5%","v":0},0,"Comments/Assumptions for calculations used"]
[null,null,"Service Desk support","Annual per user or proportion of resource salary or per call",0,{"$f":"E62*F$21","v":0},{"$f":"F62*G21","v":0},0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Telephony - workpoint calls","Annual per user",0,{"$f":"$E63*F$22","v":0},{"$f":"$E63*G$22","v":0},0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Telephony - individual device lease ","Annual per user",0,{"$f":"$E64*F$22","v":0},0,0,0,0,0,0,0,0,0,"Comments/Assumptions for calculations used"]
[null,null,"Telephony - meeting room calls","Annual charge all rooms",0,{"$f":"E65*12*F21","v":0},{"$f":"F65*12","v":0},0,0,0,0,0,0,{"$f":"M65*12","v":0},0,"Comments/Assumptions for calculations used"]
[null,null,"Resource booking service [Federated resource booking | web based solution]","Annual charge ",0,{"$f":"$E66*F$21","v":0},{"$f":"$E66*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F66:N66)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Visitor registration service (who's on location or similar kiosk solution)","Annual charge",0,{"$f":"$E67*F$21","v":0},{"$f":"$E67*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(F67:N67)","v":0},"Comments/Assumptions for calculations used"]
[null,"TOTAL IT COSTS",null,null,null,{"$f":"SUM(F53:F65)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL SHARED COSTS",null,null,null,{"$f":"F68+F43+F37+F49","v":0},0,0,0,0,0,0,0,0,0]
[null,null," "]
[null,"ESTIMATES Lease of Assets"]
[null,null,"Fitout and furniture Depreciation (12 years - lease agreement)",null,0,{"$f":"E73*F$21","v":0},{"$f":"$E73*G$21","v":0},{"$f":"$E73*H$21","v":0},0,0,0,0,0,0,{"$f":"SUM(F73:N73)","v":0},"Annual cost = total fitout and furniture investment / 12. Each agency calculation is then proportionate."]
[null,null,"Capital Charge - currently 6%, excludes Lead Agency",null,{"$f":"E73*6%","v":0},"n/a",{"$f":"$E74*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(G74:N74)","v":0},"Comments/Assumptions for calculations used"]
[null,null,"Shared IT equipment depreciation (number of years)",null,0,{"$f":"$E75*F$21","v":0},{"$f":"$E75*G$21","v":0},0,0,0,0,0,0,0,{"$f":"SUM(G75:N75)","v":0},"Comments/Assumptions for calculations used"]
[null,"TOTAL LEASE OF ASSETS",null,null,null,{"$f":"SUM(F73:F75)","v":0},{"$f":"SUM(G73:G75)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(O73:O75)","v":0}]
[]
[null,"TOTAL annual on-going operating costs",null,null,null,{"$f":"+F76+F70+F26+F49","v":0},{"$f":"+G76+G70+G26","v":0},0,0,0,0,0,0,0,0]
[null,"Monthly charge",null,null,null,{"$f":"F78/12","v":0},{"$f":"G78/12","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,"Core Assumptions:"]
[]
[null,"1. The rent is based on NLA (net leasable area)"]
[null,"2. The car park rental is based on the actual number of car parks used by each agency"]
[null,"3. The operating costs are based on either:"]
[null,"     i. the square meters"]
[null,"     ii. a per user charge"]
[null,"4. The IT costs are based on either:"]
[null,"     i. a fixed cost"]
[null,"     ii. a per user charge"]
[null,"5. The cost associated with capital are:"]
[null,"    i. capital charge (based on 6%)"]
[null,"    ii. depreciation costs (12 years -  the lease term)"]

{"sheet":"Area Allocation","index":1,"n_rows":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[[84,1,84,7],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[80,1,80,7],[2,1,2,7],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7]]}
[]
[null,"User instructions:"]
[null,"_Fill out grey cells with total Net Lettable Area (NLA), Occupant names, number of workpoints and area of dedicated spaces."]
[null,"_Insert relevant information in areas with red text."]
[null,"_Add extra Occupants by inserting lines. This may affect overall formulas - adjust as necessary."]
[null,"_Add or amend calculation principles and notes as required for your co-location"]
[null,"_Please check all formulas before issuing."]
[]
[null,"[Building] Area Allocation"]
[null,"[insert date]"]
[null,"Total NLA*",null,"sqm"]
[]
[1,"GROSS NLA SHARE"]
[null,"Percentage of building based on workpoints"]
[null,"Occupant","Workpoints","% Share","Comments"]
[null,"Lead agency",0,{"$f":"IFERROR(C16/$C$25,0)","v":0}]
[null,"Occupant 2",0,{"$f":"IFERROR(C17/$C$25,0)","v":0}]
[null,"Occupant 3",0,0]
[null,"Occupant 4",0,0]
[null,"Occupant 5",0,0]
[null,"Occupant 6",0,0]
[null,"Occupant 7",0,0]
[null,"Occupant 8",0,0]
[null,"Occupant 9",0,0]
[null,"Occupant allocated Workpoints",{"$f":"SUM(C16:C24)","v":0}]
[null,"Spare workpoints/ reception",0]
[null,"Total workpoints",{"$f":"SUM(C25:C26)","v":0}]
[]
[2,"DEDICATED AREA"]
[null,"Spaces exclusive to an Occupant**"]
[null,"Occupant","SQM","Description of space"]
[null,{"$f":"B16","v":"Lead agency"},0,"Description of space"]
[null,{"$f":"B17","v":"Occupant 2"},0,"Description of space"]
[null,"Occupant 3",0,"Description of space"]
[null,"Occupant 4",0,"Description of space"]
[null,"Occupant 5",0,"Description of space"]
[null,"Occupant 6",0,"Description of space"]
[null,"Occupant 7",0,"Description of space"]
[null,"Occupant 8",0,"Description of space"]
[null,"Occupant 9",0,"Description of space"]
[null,"TOTAL ",{"$f":"SUM(C32:C40)","v":0},"sqm"]
[]
[3,"ADJUSTED NLA"]
[null,"NLA less Dedicated"]
[null,{"$f":"C11-C41","v":0},"sqm"]
[]
[4,"NLA SHARE MINUS DEDICATED"]
[null,"Share of workspace and associated facilities (excluding carparks)"]
[null,"Occupants","SQM"]
[null,{"$f":"B16","v":"Lead agency"},{"$f":"B45*D16","v":0},"sqm"]
[null,{"$f":"B17","v":"Occupant 2"},{"$f":"B45*D17","v":0},"sqm"]
[null,"Occupant 3",{"$f":"B45*D18","v":0},"sqm"]
[null,"Occupant 4",{"$f":"B45*D19","v":0},"sqm"]
[null,"Occupant 5",{"$f":"B45*D20","v":0},"sqm"]
[null,"Occupant 6",{"$f":"B45*D21","v":0},"sqm"]
[null,"Occupant 7",{"$f":"B45*D22","v":0},"sqm"]
[null,"Occupant 8",{"$f":"B45*D23","v":0},"sqm"]
[null,"Occupant 9",{"$f":"B45*D24","v":0},"sqm"]
[null,"TOTAL",{"$f":"SUM(C50:C58)","v":0},"sqm"]
[]
[5,"ADJUSTED NLA SHARE"]
[null,"Share of NLA plus dedicated spaces attributed to agencies"]
[null,"Occupants","SQM",null,null,"Adjusted % Share"]
[null,{"$f":"B16","v":"Lead agency"},{"$f":"C50+C32","v":0},"sqm",null,{"$f":"IFERROR(C64/$C$73,0)","v":0}]
[null,{"$f":"B17","v":"Occupant 2"},0,"sqm",null,{"$f":"IFERROR(C65/$C$73,0)","v":0}]
[null,"Occupant 3",0,"sqm",null,0]
[null,"Occupant 4",0,"sqm",null,0]
[null,"Occupant 5",0,"sqm",null,0]
[null,"Occupant 6",0,"sqm",null,0]
[null,"Occupant 7",0,"sqm",null,0]
[null,"Occupant 8",0,"sqm",null,0]
[null,"Occupant 9",0,"sqm",null,{"$f":"IFERROR(C72/$C$73,0)","v":0}]
[null,"TOTAL",{"$f":"SUM(C64:C72)","v":0},"sqm","Equals Adjusted NLA"]
[]
[]
[null,"Calculation Principles"]
[null,"1. All space is shared other than dedicated rooms/spaces that are for exclusive use of one agency. "]
[null,"2. Share (%) is calculated on total NLA minus dedicated area."]
[null,"3. Dedicated space is then added back into a single agency's share"]
[null,"4. Adjusted share of the building is then calculated"]
[null,"5. Treat this as an exercise in the method of space allocation, not the actual areas that agencies will finally occupy. This will change as the design develops. "]
[null,"Notes/Assumptions"]
[null,"*NLA does not include any leased space on other levels. Carparks etc."]
[null,"*NLA as per basebuild information as at [insert date and/or drawing version information]"]
[null,"**Agency areas are based on [insert layout version or lease reference information]. "]