{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["BoE Template Instructions ","Rate Table","BoE Summary","BoE Capital Cost Detail","BoE Operating Cost Detail","Data","Rationale"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":11,"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":"BoE Template Instructions ","index":0,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,1],[19,0,19,1],[38,0,38,1],[2,0,2,1],[1,0,1,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[10,0,10,1],[61,0,61,1],[59,0,59,1],[39,0,39,1],[40,0,40,1],[42,0,42,1],[41,0,41,1],[60,0,60,1]]}
["Basis of Estimate (BoE) Template Instructions"]
["This template identifies the key elements that formulate the Cost Estimate for an investment. This is a standardized template to be used across the City to identify the entire cost of an investment.  The Basis of Estimate (BoE) is the foundation for the budget request outlined in the Business Case (BC).\n\nThe BoE is a companion-document to the investment's BC.  Although the development of the BC and the BoE is an iterative process and will be updated multiple times as an investment matures along the project lifecycle, the BoE and BC need to be tightly integrated and aligned at specific reporting milestones. "]
["The BoE is intended to be shared with project stakeholder's so that everyone understands the key elements that make up the cost of an investment.\n\n"]
["There are five parts to the BoE Template:\n\n1. Rate Table Tab\n    Includes all relevant inflation and financing rates required to complete the various sections of the BoE template.\n\n"]
["2.  BoE Summary Tab\n      Provides key information specific to the investment and how the estimate was assembled.\n      Specific information from this tab can be copied directly into or from the Business Case."]
["3.  BoE Capital Cost Detail Tab\n     Itemized costs to perform all activities to deliver the investment. \n     The concept is to identify costs at the level of detail necessary based on project maturity. \n     These costs are then spread out over the length of the project in order to apply inflationary costs related to construction, interest, etc.\n\n ** It is important that specific cost groups and cost items not be deleted or left blank. Insert a $0 if the items are not applicable.     \n     Rationale: If the cost items were deleted (entire line),  the reviewer would not be able to determine if the author considered them.\n\n     Note: Capital costs that were originally identified in the Net Present Value (NPV) tool for the selected option should be inserted into the BoE Cost  \n                 Detail tab and updated as required."]
["4. BoE Operating Cost Detail Tab\n     Operating budget implications as a result of the capital project. This includes incremental Full Time Equivalents (FTEs), operation and  \n     maintenance costs and debt and financing charges.  These costs will be used to populate the operating impact section of the BoE Cost \n     Detail tab as well as the Capital Detail Sheets.\n\n   Note: Operating costs that were originally identified in the Net Present Value (NPV) tool for the selected option should be inserted into the BoE \n              Cost Detail tab and updated as required."]
["5. Rationale Tab\nOPTIONAL.  A blank tab is available to allow users to add additional cost detail and/or supporting calculations for the BoE."]
[]
["1. Rate Table Tab"]
["Includes all relevant inflation and financing rates required to complete the various sections of the BoE template.\n\nThe Rate table information is reviewed and updated annually by the Infrastructure Planning Office.\n\n\n\n\n\n\n\n\n\n\n\n \n\n\n\n"]
["Construction/Capital Inflation","Sourced by Economic Research Office"]
["Operation & Maintenance Inflation","Sourced by Economic Research Office"]
["Internal Debt Financing ","Sourced by Corporate Finance - Treasury Division"]
["Long term Debt Financing \n(external, 30 year term)*","Sourced by Corporate Finance - Treasury Division"]
["Corporate Admin","Sourced by Financial Planning & Review"]
["Corporate Interest","Sourced by Financial Planning & Review"]
["Principle Repayment (30 year term)","Sourced by Corporate Finance - Treasury Division"]
[]
["2. BoE Summary Tab"]
["Investment Title","The Investment Name exactly as on the Business Case."]
["Investment Description","Short, simple description of the investment to provide additional detail on what the investment includes, such that a variety of stakeholders (including the public) could understand."]
["Department","Full name of the responsible Department(s)."]
["BoE Date","The date on which the BoE was first approved, or the date of each subsequent approved update/revision."]
["BoE Author","Name of the individual responsible for preparing the information in the BoE Template."]
["BoE Estimating Team","List the individual(s) who have contributed to the development of the BoE."]
["BoE Reviewed by","Name of the individual(s) who reviewed the BoE. This should be (however not always) the same individual who reviewed the Business Case.\nIt is recommended that the department's Asset Management Office review all Business Cases, Basis of Estimate, and Class of Estimate - Deliverables Maturity Assessment Checklist(s).  Other reviews and approvals may also be required."]
["Business Case ID","The Departmental Business Case ID."]
[]
["Investment Capital Cost Summary","This table will automatically populate based on information entered into the BoE Capital Cost Detail Tab."]
["Investment Operating Cost Summary","This table will automatically populate based on the information entered into the BoE Operating Cost Detail Tab."]
[]
["Estimate Classification","Select from dropdown list the overall class estimate for the project determined by completing the Class of Estimate - Deliverables Maturity Assessment Checklist template for the relevant industry.\nBased on AACE recommended practices."]
["Assumptions","Identify and list key assumptions made in developing the basis of estimate. "]
["Risks and Opportunities","List or reference the detailed Risk Assessment that identifies the key risks and opportunities. This will be used to determine specific contingency dollars in the contingency section of the Capital Cost Detail Tab."]
["Reference Documents ","List reference material used in the development of the BoE such as the Preliminary Design Report. DO NOT EMBED DOCUMENTS, however be prepared to provide copies of any reference materials if requested.  \nThis section will be used to support your Class of Estimate. "]
["Document Control","Identify items that changed from the previous version of the BoE.  The BoE Author must use discretion as to how much detail to include; it is suggested to note only the items that have substantially changed the estimate. \n\nWhen substantial changes are made a new version of the BoE should be saved (include version number in the file name) and the previous version archived for reference. Fill in the version number, date, author and rationale for the revision (ex. draft, final, approved, preliminary design, etc.)  in the table."]
[]
["3. BoE Capital Cost Detail Tab"]
["The purpose of this tab is to capture all the costs associated with the investment. \nThis information will also be used in the Capital Detail Sheets.\n\nData for the Capital Cost Detail tab should ONLY be entered in the areas that are shaded YELLOW. \n"]
["1. \"Estimate Detail\" groupings: \n\nThe Estimator has the flexibility to identify the cost elements within each \"Estimate Detail\" grouping. That is, within the Construction/Equipment Cost group, the Estimator can identify any number of cost items that are appropriate for their specific investment. "]
["2. Entering Costs: \n\nEnter the cost for the specific cost items in the \"Estimate Year\" column. \nThen enter the percentage of work that will be completed in a specific year (in the \"% of Project Work Undertaken\" section of the worksheet). The years do not need to be sequential. \nEnter data that is appropriate for the type of investment and industry associated with the BoE.  \nTaxes (MRST, PST) should not be broken out, however should be included in line items.\n"]
["3. Administrative Charges: \n\nThis section outlines the Administrative charges that are applicable to all projects (including Major Capital) as well as the interim debt and financing charges that are applicable to debt funded projects.\n"]
["Investment Title","Transferred from the BoE Summary tab."]
["Business Case ID","Transferred from the BoE Summary tab."]
["BoE Date","Transferred from the BoE Summary tab."]
["Class of Estimate","Transferred from the BoE Summary tab."]
["Major Capital? ","If project meets the threshold for major capital, select \"yes\" from the dropdown menu. \nAdditional sections will appear for eligible cost detail and interest charge detail that must be provided for major capital projects."]
["In Service Year","Indicate the year that the asset will be available for use. \nAll deliverables for the project may not be fully complete, however the asset is available and fit for use."]
["Construction / Capital Inflation","Sourced from the the Rate Table tab and indicates the inflation/escalation % per year starting from the Estimate Year.\nThe inflation/escalation rate in future years will be automatically added to the costs of each line item based on the year that the work occurs."]
["Estimate Year","This is the year in which the cost estimates have been based. \nA warning note appears if the estimate year entered is greater than current year to notify the Estimator. \n\nEnter the year that the work will occur. The years do not need to be sequential. That is, work does not need to start the first year after the Estimate Year and work does not have to occur for 1 or more years. "]
["10 Year Template/6 Year Template","The spreadsheet opens as a 10 Year template.  The 10 year view used for this template should provide sufficient detail to show the capital and operating impact for the majority of projects. If there are any projects that need to go beyond 10 years please contact the Corporate Asset Management Office.  If the project does not warrant the additional cells, the 6 Year template can be selected to hide the unused columns. "]
["Estimate Detail","Detail the construction/equipment, consultant (internal & external) , utility, and other costs associated with the investment.  Within the consultant section both professional and non professional services required for the project should be detailed.  The consultant section is also where costs for redeployment of internal staff and staff augmentation should be detailed.  Ex. Project Manager (external staff), $150/hour. OR Project Manager (internal redeployment), WAPSO 4. Consult with department finance/HR for internal staff rates.\n\nData is ONLY to be entered in cells highlighted yellow. Other cells will populate automatically. Additional rows are available, however have been hidden. Unhide to add rows.\n\nIn column A,  provide a description of each cost under the relevant grouping. \nThe total cost of the item should be entered in column C and then the % item completion in each year is to be entered in columns P-Y. \nA warning note appears if the total % does not add up to 100% in column Z, otherwise \"error\" will appear in column Z and a warning message will appear at the top of the worksheet."]
["Contingency Costs","The contingency line items are to be generated from the Risk Management Plan.  Note the specific contingency allotment for each risk item.   \nThis grouping cannot be deleted however the Estimator has flexibility to note the specific risk line items.  \nThe specific contingency line items need to be determined based on the risk assessment results, industry type and Class of Estimate.\n\n"]
["Administrative Charges Detail","Consult with department Finance to complete this section. \nSeveral of these charges are automatically generated however there are some modifications that the Estimator needs to be aware of:\n▪ Departmental Staff Charges:  For departmental  use to recover costs for their resources  allocated to a project.\n▪ Corporate Administration (max $100,000) :  The % noted are standard however the rate may change over time.\n     Refer to the Rate Table tab and adjust as necessary.\n     Maximum charge of $100,000 per project. The formulas will calculate each year based on the % rate and only  allow to a maximum of $100,000 total over the course of the project.\n▪ Municipal Accommodations Overhead (ONLY if Municipal Accommodations(MA) is delivering the project): \n     The MA Overhead is intended to recover a portion of costs incurred by MA for capital project/program delivery.  \n     These costs include staff time (Division Manager, Executive Assistant, Supervisors,  Project Officers, etc.) as well\n     as other costs like office space, supplies and equipment.  The rates used to calculate the MA Overhead is 2% of \n     the first $2 million of each year’s “Project Sub-total before Administrative Charges Subtotal”  amount and 1% of\n     any amount over $2 million.  \n     \n     Select 'Yes' or 'No' from dropdown list whether Municipal Accommodations is delivering the project, or if this is a Municipal Accomodation project. The MA Overhead is automatically calculated.\n\n     If this is a Major Capital Project delivered by MA, discuss the appropriate MA Overhead with MA Finance and\n     overide this calculation by selecting 'No' for MA Overhead to be calculated here.  Then add the MA Overhead \n     charge as a new row at the end of this section to account for MA Overhead.\n"]
["Administrative Charges Detail (continued)","▪ Research (SMIR) (Construction Only, only applies to Public Works): Is applicable only to Public Works and\n     construction cost items.  \n▪ Corporate Interest: The % noted are typically standard however the rate may change over time.  Refer to the Rate\n     Table tab and adjust as necessary.\n\nBlank rows have been added  to columns A - N for the Estimator to add any additional charges or fees as required. This is also where additional ineligible costs can be added for major capital projects."]
["Eligible Costs Detail","Outlines the eligible and ineligible costs to be considered for 3rd party funding and calculation of interest charges.  Indicate the % assumed City contribution, this will automatically populate the cells for each year of the project.\n\nIt is important to complete the 'Assumed City Contribution (%)' cell, to allow for the Corporate Interest to calculate on the correct % to be assumed by the City.  If this percentage is less than 100%, the funding is required to be from guaranteed funding source, where a formal agreement is signed."]
["Interest Charges Detail\n\nThis section will only appear if you have selected 'Yes' to the Major Capital Project question","APPLICABLE FOR MAJOR CAPITAL PROJECTS ONLY.  Consult with department Finance to complete this section.  \nRefer to the Rate Table tab to update the interim and long term rates.  \nInterest is charged to the project until the asset is in service at which time interest is then charged to the operating budget. \nIf there is no external interest to be charged in a particular year leave the cell blank (DO NOT ENTER 0) so that interest will not be calculated for that year.\n\nConcept:  The interim financing charges are similar to what an individual would incur if they built a house and needed to utilize a personal Line of Credit to pay project costs."]
["Total Capital Project Costs\n","Total Capital Project Costs in cell N218 is calculated through the addition of the Project Subtotals (N171), the Administration Charges (N188), and the Interest Charges (N211).  As a secondary check, the value in cell N222 calculates the Total Capital Project Costs by summing the year to year project costs (D218-M218), and should match the yellow highlighted Total Capital Project Costs in cell N218. "]
[]
["4. BoE Operating Cost Detail Tab"]
["The purpose of this tab is to detail the incremental operating budget impacts of the project, both positive and negative. \nThe operating impact will typically start in the year following completion of construction, however in some instances there may be costs incurred prior to project completion and this must be detailed here. \nThis information will also be used for the Net Operating Impact section of the Capital Detail Sheets.\n\nData for the Operating Impact tab should ONLY be entered in the areas that are shaded YELLOW. \n\nThis section should be completed in consultation with the division responsible for operation and maintenance of the asset(s) and department finance. Please identify these resources as part of the Estimating Team."]
["Operating Budget Impact Detail Table","[Cell B7, B8] Enter the estimate year and the 1st year in which incremental operating costs will be incurred.  This will then auto-populate the remaining years in the table. \n\nYear of operating impact should start in the first year that there is an impact to the operating budget as a result of the project and continue for a minimum of 2 years past the in service date to show the impact of all costs (including debt & financing) on the operating budget.  The 10 year view used for this template should provide sufficient detail to show the operating impact for the majority of projects. If there are any projects that need to go beyond 10 years please contact the Corporate Asset Management Office for an expanded template.\n\n[Cell C11] Enter the incremental revenue/recovery for each year. \n[Cell C13] Enter the number of incremental full time equivalent (FTE)positions for each year.  \nThe remaining information in this table auto-populates based on information inputted on the estimate detail rows below. "]
["Operation & Maintenance Inflation ","\nSourced from the Rate Table tab.  \nThe numbers entered in the budget impact detail sections will be automatically updated to include inflation.\n"]
["Budget Impact Detail: \n     Salaries & Benefits","Consult with department Finance and Human Resources to complete this section.  \n\nStarting at [Cell A20] Enter new position title(s) required to support the new asset(s).  \nStarting at [Cell C20] Enter costs in current dollars in yellow highlighted cells. \n\nInflation will be automatically calculated.\nExplain why additional FTEs are needed. "]
["Budget Impact Detail: \n     Operation & Maintenance","Consult the area that will be responsible for asset operation and maintenance to complete this section.\n\nSample categories are provided (services, materials, parts & supplies, assets & purchases, other). \n\nStarting at [CellA34] Enter sample category, as required.\nStarting at [CellC34] Enter additional costs or savings estimated for operation and maintenance of the assets. \n\nExplain assumptions made to calculate any costs added or saved. \nIndicate the category for any incremental costs as a result of the project.  \n\nNote: It may be helpful to refer to historic operation/maintenance spending record to help forecast the net operating impact costs."]
["Budget Impact Detail: \n     Debt & Financing Charges","Consult with department Finance to complete this section. \n\nInclude Long-Term Debt Financing (External) and Principle Repayment financing charges.   \nNote the annual amount owing, repayment term/amortization period, and total amount owing over the term. \n\nStarting at [CellC51] Calculate the Long-Term Debt Financing (External) using the rate located in the Rate Table tab.\nStarting at [CellC52] Calculate the Principle Repayment using the rate located in the Rate Table tab.\n\nData is ONLY to be entered in cells highlighted yellow. Other cells will populate automatically. Additional rows are available, however have been hidden. Unhide to add rows."]

{"sheet":"Rate Table","index":1,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["                      Rate Table for Basis of Estimate",null,null,null,null,null,null,null,null,null,null,null,"Column to be hidden\nFor template maintenance ONLY."]
[]
["Rates",2025,{"$f":"B3+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,"Source"]
["Construction/Capital Inflation",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,"Economic Research Office","BoECApitalCosts tab line c9"]
["Operation & Maintenance Inflation",0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,"Economic Research Office","BoE Operating line 15"]
["Internal Debt Financing ",0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,"Corporate Finance - Treasury Division","BoE Capital line A206, A207"]
["Long term Debt Financing (external, 30 year term)*",0.05,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,"Corporate Finance - Treasury Division","BoE Capital line A208, A209"]
["Corporate Admin",1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,1.2500000000000001E-2,"Financial Planning & Review","BoE Capital line 178"]
["Corporate Interest",0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,"Financial Planning & Review","BoE Capital line 181"]
["Principle Repayment (30 year term)",1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,1.9400000000000001E-2,"Corporate Finance - Treasury Division","BoE Operating line 52"]
["* Rates from 2025 to 2034 have been updated from the previous version of the BoE template"]
["Note: Rate Table information is reviewed and updated annually by the Corporate Asset Management Office."]

{"sheet":"BoE Summary","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[39,5,39,11],[40,5,40,11],[41,5,41,11],[42,5,42,11],[43,5,43,11],[44,5,44,11],[88,5,88,11],[10,0,10,11],[21,0,21,11],[31,1,31,11],[32,1,32,11],[33,1,33,11],[34,1,34,11],[36,0,36,11],[37,1,37,11],[38,5,38,11],[83,5,83,10],[82,5,82,10],[75,5,75,10],[88,1,88,2],[88,3,88,4],[86,1,86,2],[39,3,39,4],[84,3,84,4],[84,5,84,10],[86,3,86,4],[86,5,86,10],[39,1,39,2],[84,1,84,2],[85,1,85,2],[85,3,85,4],[85,5,85,10],[87,1,87,2],[87,3,87,4],[87,5,87,10],[74,1,74,2],[75,1,75,2],[82,1,82,2],[83,1,83,2],[83,3,83,4],[82,3,82,4],[76,5,76,10],[74,5,74,10],[81,5,81,10],[80,5,80,10],[79,5,79,10],[78,5,78,10],[77,5,77,10],[38,1,38,2],[38,3,38,4],[75,3,75,4],[74,3,74,4],[73,1,73,2],[72,1,72,2],[71,1,71,2],[70,1,70,2],[68,1,68,2],[69,1,69,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[67,3,67,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[54,1,54,2],[55,1,55,2],[45,5,45,10],[80,1,80,2],[81,1,81,2],[81,3,81,4],[80,3,80,4],[79,3,79,4],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,1,79,2],[78,3,78,4],[77,3,77,4],[76,3,76,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[48,1,48,2],[72,5,72,10],[73,5,73,10],[48,3,48,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[48,5,48,10],[65,5,65,10],[66,5,66,10],[67,5,67,10],[68,5,68,10],[64,3,64,4],[69,5,69,10],[70,5,70,10],[64,5,64,10],[54,5,54,10],[56,1,56,2],[57,1,57,2],[56,5,56,10],[60,5,60,10],[46,5,46,10],[47,5,47,10],[55,5,55,10],[71,5,71,10],[67,1,67,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[66,1,66,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[53,1,53,2],[65,3,65,4],[66,3,66,4],[62,5,62,10],[63,5,63,10],[61,5,61,10],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[57,5,57,10],[58,5,58,10],[59,5,59,10],[59,3,59,4],[60,3,60,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[49,5,49,10],[50,5,50,10],[51,5,51,10],[52,5,52,10],[53,5,53,10]]}
["Basis of Estimate (BoE) Summary"]
["Investment Title"]
["Investment Description"]
["Department"]
["BoE Date"]
["BoE Author"]
["BoE Estimating Team"]
["BoE Reviewed by "]
["Business Case ID"]
[]
["Investment Capital Cost Summary"]
["CAPITAL COSTS ($000's)",{"$f":"'BoE Capital Cost Detail'!D11","v":2025},{"$f":"'BoE Capital Cost Detail'!E11","v":2026},{"$f":"'BoE Capital Cost Detail'!F11","v":2027},{"$f":"'BoE Capital Cost Detail'!G11","v":2028},{"$f":"'BoE Capital Cost Detail'!H11","v":2029},{"$f":"'BoE Capital Cost Detail'!I11","v":2030},{"$f":"'BoE Capital Cost Detail'!J11","v":2031},{"$f":"'BoE Capital Cost Detail'!K11","v":2032},{"$f":"'BoE Capital Cost Detail'!L11","v":2033},{"$f":"'BoE Capital Cost Detail'!M11","v":2034},"Total"]
["Construction/Equipment ",{"$f":"'BoE Capital Cost Detail'!D53","v":0},{"$f":"'BoE Capital Cost Detail'!E53","v":0},{"$f":"'BoE Capital Cost Detail'!F53","v":0},{"$f":"'BoE Capital Cost Detail'!G53","v":0},{"$f":"'BoE Capital Cost Detail'!H53","v":0},{"$f":"'BoE Capital Cost Detail'!I53","v":0},{"$f":"'BoE Capital Cost Detail'!J53","v":0},{"$f":"'BoE Capital Cost Detail'!K53","v":0},{"$f":"'BoE Capital Cost Detail'!L53","v":0},{"$f":"'BoE Capital Cost Detail'!M53","v":0},{"$f":"'BoE Capital Cost Detail'!N53","v":0}]
["Consultant ",{"$f":"'BoE Capital Cost Detail'!D81","v":0},{"$f":"'BoE Capital Cost Detail'!E81","v":0},{"$f":"'BoE Capital Cost Detail'!F81","v":0},{"$f":"'BoE Capital Cost Detail'!G81","v":0},{"$f":"'BoE Capital Cost Detail'!H81","v":0},{"$f":"'BoE Capital Cost Detail'!I81","v":0},{"$f":"'BoE Capital Cost Detail'!J81","v":0},{"$f":"'BoE Capital Cost Detail'!K81","v":0},{"$f":"'BoE Capital Cost Detail'!L81","v":0},{"$f":"'BoE Capital Cost Detail'!M81","v":0},{"$f":"'BoE Capital Cost Detail'!N81","v":0}]
["Utility ",{"$f":"'BoE Capital Cost Detail'!D111","v":0},{"$f":"'BoE Capital Cost Detail'!E111","v":0},{"$f":"'BoE Capital Cost Detail'!F111","v":0},{"$f":"'BoE Capital Cost Detail'!G111","v":0},{"$f":"'BoE Capital Cost Detail'!H111","v":0},{"$f":"'BoE Capital Cost Detail'!I111","v":0},{"$f":"'BoE Capital Cost Detail'!J111","v":0},{"$f":"'BoE Capital Cost Detail'!K111","v":0},{"$f":"'BoE Capital Cost Detail'!L111","v":0},{"$f":"'BoE Capital Cost Detail'!M111","v":0},{"$f":"'BoE Capital Cost Detail'!N111","v":0}]
["Other ",{"$f":"'BoE Capital Cost Detail'!D139","v":0},{"$f":"'BoE Capital Cost Detail'!E139","v":0},{"$f":"'BoE Capital Cost Detail'!F139","v":0},{"$f":"'BoE Capital Cost Detail'!G139","v":0},{"$f":"'BoE Capital Cost Detail'!H139","v":0},{"$f":"'BoE Capital Cost Detail'!I139","v":0},{"$f":"'BoE Capital Cost Detail'!J139","v":0},{"$f":"'BoE Capital Cost Detail'!K139","v":0},{"$f":"'BoE Capital Cost Detail'!L139","v":0},{"$f":"'BoE Capital Cost Detail'!M139","v":0},{"$f":"'BoE Capital Cost Detail'!N139","v":0}]
["Contingencies",{"$f":"'BoE Capital Cost Detail'!D169","v":0},{"$f":"'BoE Capital Cost Detail'!E169","v":0},{"$f":"'BoE Capital Cost Detail'!F169","v":0},{"$f":"'BoE Capital Cost Detail'!G169","v":0},{"$f":"'BoE Capital Cost Detail'!H169","v":0},{"$f":"'BoE Capital Cost Detail'!I169","v":0},{"$f":"'BoE Capital Cost Detail'!J169","v":0},{"$f":"'BoE Capital Cost Detail'!K169","v":0},{"$f":"'BoE Capital Cost Detail'!L169","v":0},{"$f":"'BoE Capital Cost Detail'!M169","v":0},{"$f":"'BoE Capital Cost Detail'!N169","v":0}]
["Administration ",{"$f":"'BoE Capital Cost Detail'!D188","v":0},{"$f":"'BoE Capital Cost Detail'!E188","v":0},{"$f":"'BoE Capital Cost Detail'!F188","v":0},{"$f":"'BoE Capital Cost Detail'!G188","v":0},{"$f":"'BoE Capital Cost Detail'!H188","v":0},{"$f":"'BoE Capital Cost Detail'!I188","v":0},{"$f":"'BoE Capital Cost Detail'!J188","v":0},{"$f":"'BoE Capital Cost Detail'!K188","v":0},{"$f":"'BoE Capital Cost Detail'!L188","v":0},{"$f":"'BoE Capital Cost Detail'!M188","v":0},{"$f":"'BoE Capital Cost Detail'!N188","v":0}]
["Interest",{"$f":"'BoE Capital Cost Detail'!D211","v":0},{"$f":"'BoE Capital Cost Detail'!E211","v":0},{"$f":"'BoE Capital Cost Detail'!F211","v":0},{"$f":"'BoE Capital Cost Detail'!G211","v":0},{"$f":"'BoE Capital Cost Detail'!H211","v":0},{"$f":"'BoE Capital Cost Detail'!I211","v":0},{"$f":"'BoE Capital Cost Detail'!J211","v":0},{"$f":"'BoE Capital Cost Detail'!K211","v":0},{"$f":"'BoE Capital Cost Detail'!L211","v":0},{"$f":"'BoE Capital Cost Detail'!M211","v":0},{"$f":"'BoE Capital Cost Detail'!N211","v":0}]
["Total",{"$f":"'BoE Capital Cost Detail'!D218","v":0},{"$f":"'BoE Capital Cost Detail'!E218","v":0},{"$f":"'BoE Capital Cost Detail'!F218","v":0},{"$f":"'BoE Capital Cost Detail'!G218","v":0},{"$f":"'BoE Capital Cost Detail'!H218","v":0},{"$f":"'BoE Capital Cost Detail'!I218","v":0},{"$f":"'BoE Capital Cost Detail'!J218","v":0},{"$f":"'BoE Capital Cost Detail'!K218","v":0},{"$f":"'BoE Capital Cost Detail'!L218","v":0},{"$f":"'BoE Capital Cost Detail'!M218","v":0},{"$f":"'BoE Capital Cost Detail'!N218","v":0}]
[]
["Investment Operating Cost Summary"]
["NET OPERATING IMPACT ($000's)",{"$f":"'BoE Operating Cost Detail'!C7","v":2025},{"$f":"'BoE Operating Cost Detail'!D7","v":2026},{"$f":"'BoE Operating Cost Detail'!E7","v":2027},{"$f":"'BoE Operating Cost Detail'!F7","v":2028},{"$f":"'BoE Operating Cost Detail'!G7","v":2029},{"$f":"'BoE Operating Cost Detail'!H7","v":2030},{"$f":"'BoE Operating Cost Detail'!I7","v":2031},{"$f":"'BoE Operating Cost Detail'!J7","v":2032},{"$f":"'BoE Operating Cost Detail'!K7","v":2033},{"$f":"'BoE Operating Cost Detail'!L7","v":2034},"Total"]
["Operating Costs",{"$f":"'BoE Operating Cost Detail'!C8","v":0},{"$f":"'BoE Operating Cost Detail'!D8","v":0},{"$f":"'BoE Operating Cost Detail'!E8","v":0},{"$f":"'BoE Operating Cost Detail'!F8","v":0},{"$f":"'BoE Operating Cost Detail'!G8","v":0},{"$f":"'BoE Operating Cost Detail'!H8","v":0},{"$f":"'BoE Operating Cost Detail'!I8","v":0},{"$f":"'BoE Operating Cost Detail'!J8","v":0},{"$f":"'BoE Operating Cost Detail'!K8","v":0},{"$f":"'BoE Operating Cost Detail'!L8","v":0},{"$f":"SUM(B24:K24)","v":0}]
["Debt & Finance Charges",{"$f":"'BoE Operating Cost Detail'!C9","v":0},{"$f":"'BoE Operating Cost Detail'!D9","v":0},{"$f":"'BoE Operating Cost Detail'!E9","v":0},{"$f":"'BoE Operating Cost Detail'!F9","v":0},{"$f":"'BoE Operating Cost Detail'!G9","v":0},{"$f":"'BoE Operating Cost Detail'!H9","v":0},{"$f":"'BoE Operating Cost Detail'!I9","v":0},{"$f":"'BoE Operating Cost Detail'!J9","v":0},{"$f":"'BoE Operating Cost Detail'!K9","v":0},{"$f":"'BoE Operating Cost Detail'!L9","v":0},{"$f":"SUM(B25:K25)","v":0}]
["Total Direct Costs",{"$f":"'BoE Operating Cost Detail'!C10","v":0},{"$f":"'BoE Operating Cost Detail'!D10","v":0},{"$f":"'BoE Operating Cost Detail'!E10","v":0},{"$f":"'BoE Operating Cost Detail'!F10","v":0},{"$f":"'BoE Operating Cost Detail'!G10","v":0},{"$f":"'BoE Operating Cost Detail'!H10","v":0},{"$f":"'BoE Operating Cost Detail'!I10","v":0},{"$f":"'BoE Operating Cost Detail'!J10","v":0},{"$f":"'BoE Operating Cost Detail'!K10","v":0},{"$f":"'BoE Operating Cost Detail'!L10","v":0},{"$f":"SUM(B26:K26)","v":0}]
["Less: Incremental Revenue/Recovery",{"$f":"'BoE Operating Cost Detail'!C11","v":0},{"$f":"'BoE Operating Cost Detail'!D11","v":0},{"$f":"'BoE Operating Cost Detail'!E11","v":0},{"$f":"'BoE Operating Cost Detail'!F11","v":0},{"$f":"'BoE Operating Cost Detail'!G11","v":0},{"$f":"'BoE Operating Cost Detail'!H11","v":0},{"$f":"'BoE Operating Cost Detail'!I11","v":0},{"$f":"'BoE Operating Cost Detail'!J11","v":0},{"$f":"'BoE Operating Cost Detail'!K11","v":0},{"$f":"'BoE Operating Cost Detail'!L11","v":0}]
["Net Cost/(Benefit)",{"$f":"'BoE Operating Cost Detail'!C12","v":0},{"$f":"'BoE Operating Cost Detail'!D12","v":0},{"$f":"'BoE Operating Cost Detail'!E12","v":0},{"$f":"'BoE Operating Cost Detail'!F12","v":0},{"$f":"'BoE Operating Cost Detail'!G12","v":0},{"$f":"'BoE Operating Cost Detail'!H12","v":0},{"$f":"'BoE Operating Cost Detail'!I12","v":0},{"$f":"'BoE Operating Cost Detail'!J12","v":0},{"$f":"'BoE Operating Cost Detail'!K12","v":0},{"$f":"'BoE Operating Cost Detail'!L12","v":0}]
[]
["Incremental Full Time Equivalent Positions",{"$f":"'BoE Operating Cost Detail'!C13","v":0},{"$f":"'BoE Operating Cost Detail'!D13","v":0},{"$f":"'BoE Operating Cost Detail'!E13","v":0},{"$f":"'BoE Operating Cost Detail'!F13","v":0},{"$f":"'BoE Operating Cost Detail'!G13","v":0},{"$f":"'BoE Operating Cost Detail'!H13","v":0},{"$f":"'BoE Operating Cost Detail'!I13","v":0},{"$f":"'BoE Operating Cost Detail'!J13","v":0},{"$f":"'BoE Operating Cost Detail'!K13","v":0},{"$f":"'BoE Operating Cost Detail'!L13","v":0}]
[]
["Estimate Classification"]
["Assumptions"]
["Risks and Opportunities"]
["Reference Documents "]
[]
["Document Control"]
["Major Changes from Previous Estimate"]
["Version #","Date",null,"Author",null,"Rationale"]

{"sheet":"BoE Capital Cost Detail","index":3,"n_rows":222,"n_cols":88,"rows_kept":222,"cut":false,"hidden":false,"merged":[[9,15,9,24],[9,3,9,12],[3,6,3,7],[4,1,4,2],[5,6,5,7],[0,0,0,13],[1,1,1,13],[4,6,4,7],[2,1,2,13],[171,11,171,12]]}
["Basis of Estimate (BoE) Capital Cost Detail"]
["Investment Title",{"$f":"InvestmentTitle","v":0}]
["Business Case ID",{"$f":"BC_ID","v":0}]
[{"$f":"IF(COUNTIF(Z13:Z181, \"error\"),\"There is an error in % of Project Work Undertaken. Please correct\",\"\")","v":""},null,{"$f":"IF(C11>D11,\"You cannot enter a future dated estimate year.  Please correct\")","v":false},null,null,"BoE Date",{"$f":"'BoE Summary'!$B$5","v":"00:00:00"}]
[null,"Is this a Major Capital project?",null,"No",null,"In Service Year"]
[null,null,null,null,null,"Class of Estimate",{"$f":"'BoE Summary'!B32","v":0}]
[]
["ESTIMATE DETAIL"]
[null,null,"Construction / Capital Inflation",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,"Estimate Year","Year Project Work Undertaken",null,null,null,null,null,null,null,null,null,null,null,"% of Project Work Undertaken",null,null,null,null,null,null,null,null,null,"Check",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,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,null,null,null,null,null,null,null,"Yes"]
[null,null,2024,2025,{"$f":"D11+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,"Total",null,{"$f":"D11","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,"Total \n%",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,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,null,null,null,null,null,null,null,"No"]
["Construction/Equipment Costs","% of Const.","($000's)"]
[null,{"$f":"IFERROR(C13/$C$53,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C13*P13*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,{"$f":"ROUNDUP($C13*U13*POWER((1+I$9),(I$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C13*V13*POWER((1+J$9),(J$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C13*W13*POWER((1+K$9),(K$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C13*X13*POWER((1+L$9),(L$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C13*Y13*POWER((1+M$9),(M$11-$C$11)),0)","v":0},{"$f":"SUM(D13:M13)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P13:Y13)=100%,\"100%\",IF(SUM(P13:Y13)=0,\"0%\",\"error\"))","v":"0%"},null,null,null,{"$f":"IF(SUM(P13:Y13)<100,\"\",\"error\")","v":""}]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D14:M14)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C15*P15*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C15*Q15*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C15*R15*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C15*S15*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C15*T15*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,{"$f":"SUM(D15:M15)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C19/$C$53,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C19*P19*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C19*Q19*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C19*R19*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C19*S19*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C19*T19*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C34/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C35/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C36/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C37/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C38/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C39/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C48*P48*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D48:M48)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D49:M49)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D50:M50)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D51:M51)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D52:M52)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Construction Costs Sub-total",{"$f":"IFERROR(C53/C53,\"-\")","v":"-"},{"$f":"SUM(C13:C52)","v":0},0,0,0,0,0,{"$f":"SUM(I13:I52)","v":0},{"$f":"SUM(J13:J52)","v":0},{"$f":"SUM(K13:K52)","v":0},{"$f":"SUM(L13:L52)","v":0},{"$f":"SUM(M13:M52)","v":0},0]
[]
["Consultant Costs (Internal & External)","% of Const","($000's)"]
[null,{"$f":"IFERROR(C56/$C$53,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C56*P56*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*Q56*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*R56*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*S56*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*T56*POWER((1+H$9),(H$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*U56*POWER((1+I$9),(I$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*V56*POWER((1+J$9),(J$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*W56*POWER((1+K$9),(K$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*X56*POWER((1+L$9),(L$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C56*Y56*POWER((1+M$9),(M$11-$C$11)),0)","v":0},{"$f":"SUM(D56:M56)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C57/$C$53,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C57*P57*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C57*Q57*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C57*R57*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C57*S57*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C57*T57*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,{"$f":"SUM(D57:M57)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C78/$C$53,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C78*P78*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D78:M78)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C79/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D79:M79)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C80/$C$53,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D80:M80)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Consultant Costs Sub-total",{"$f":"IFERROR(C81/C53,\"-\")","v":"-"},{"$f":"SUM(C56:C80)","v":0},{"$f":"SUM(D56:D80)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Construction & Consultant Sub-total",null,{"$f":"C53+C81","v":0},{"$f":"D53+D81","v":0},{"$f":"E53+E81","v":0},0,0,0,0,0,0,0,0,{"$f":"N53+N81","v":0}]
[]
["Utility Costs","% C&C","($000's)"]
["Hydro",{"$f":"IFERROR(C86/$C$83,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C86*P86*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,{"$f":"ROUNDUP($C86*U86*POWER((1+I$9),(I$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C86*V86*POWER((1+J$9),(J$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C86*W86*POWER((1+K$9),(K$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C86*X86*POWER((1+L$9),(L$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C86*Y86*POWER((1+M$9),(M$11-$C$11)),0)","v":0},{"$f":"SUM(D86:M86)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Communication - MTS",{"$f":"IFERROR(C87/$C$83,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D87:M87)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Communication - Shaw","-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D88:M88)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C89*P89*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C89*Q89*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C89*R89*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C89*S89*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C89*T89*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,{"$f":"SUM(D89:M89)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C109*P109*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D109:M109)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D110:M110)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Utility Costs Sub-total",{"$f":"IFERROR(C111/C83,\"-\")","v":"-"},{"$f":"SUM(C86:C110)","v":0},0,0,0,0,0,{"$f":"SUM(I86:I110)","v":0},{"$f":"SUM(J86:J110)","v":0},{"$f":"SUM(K86:K110)","v":0},{"$f":"SUM(L86:L110)","v":0},{"$f":"SUM(M86:M110)","v":0},0]
[]
["Other Costs","% C&C","($000's)"]
["Land Acquisition",{"$f":"IFERROR(C114/$C$83,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C114*P114*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,{"$f":"ROUNDUP($C114*U114*POWER((1+I$9),(I$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C114*V114*POWER((1+J$9),(J$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C114*W114*POWER((1+K$9),(K$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C114*X114*POWER((1+L$9),(L$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C114*Y114*POWER((1+M$9),(M$11-$C$11)),0)","v":0},{"$f":"SUM(D114:M114)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Insurance",{"$f":"IFERROR(C115/$C$83,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D115:M115)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C116*P116*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C116*Q116*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C116*R116*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C116*S116*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C116*T116*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,{"$f":"SUM(D116:M116)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C135*P135*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D135:M135)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D136:M136)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D137:M137)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C138/$C$83,\"-\")","v":"-"},null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D138:M138)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
["Other Costs Sub-total",{"$f":"IFERROR(C139/C83,\"-\")","v":"-"},{"$f":"SUM(C114:C138)","v":0},0,0,0,0,0,{"$f":"SUM(I114:I138)","v":0},{"$f":"SUM(J114:J138)","v":0},{"$f":"SUM(K114:K138)","v":0},{"$f":"SUM(L114:L138)","v":0},{"$f":"SUM(M114:M138)","v":0},0]
[]
["Project Costs before Contingencies Sub-total",null,{"$f":"C53+C81+C111+C139","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Contingencies Costs","% Proj Cost","($000's)"]
[null,{"$f":"IFERROR(C144/$C$141,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C144*P144*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D144:M144)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(P144:Y144)=100%,\"100%\",IF(SUM(P144:Y144)=0,\"0%\",\"error\"))","v":"0%"}]
[null,{"$f":"IFERROR(C145/$C$141,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C145*P145*POWER((1+D$9),(D$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C145*Q145*POWER((1+E$9),(E$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C145*R145*POWER((1+F$9),(F$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C145*S145*POWER((1+G$9),(G$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C145*T145*POWER((1+H$9),(H$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C145*U145*POWER((1+I$9),(I$11-$C$11)),0)","v":0},0,0,0,0,{"$f":"SUM(D145:M145)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,{"$f":"ROUNDUP($C149*U149*POWER((1+I$9),(I$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C149*V149*POWER((1+J$9),(J$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C149*W149*POWER((1+K$9),(K$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C149*X149*POWER((1+L$9),(L$11-$C$11)),0)","v":0},{"$f":"ROUNDUP($C149*Y149*POWER((1+M$9),(M$11-$C$11)),0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,{"$f":"IFERROR(C162/$C$141,\"-\")","v":"-"},null,{"$f":"ROUNDUP($C162*P162*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,{"$f":"ROUNDUP($C162*T162*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,{"$f":"SUM(D162:M162)","v":0},null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,{"$f":"ROUNDUP($C164*T164*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,{"$f":"ROUNDUP($C165*T165*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,{"$f":"ROUNDUP($C166*T166*POWER((1+H$9),(H$11-$C$11)),0)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,{"$f":"ROUNDUP($C167*P167*POWER((1+D$9),(D$11-$C$11)),0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[null,"-",null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"0%"]
[" Contingencies Costs Sub-total",{"$f":"IFERROR(C169/C141,\"-\")","v":"-"},{"$f":"SUM(C144:C168)","v":0},0,0,0,0,0,{"$f":"SUM(I144:I168)","v":0},{"$f":"SUM(J144:J168)","v":0},{"$f":"SUM(K144:K168)","v":0},{"$f":"SUM(L144:L168)","v":0},{"$f":"SUM(M144:M168)","v":0},0]
[]
["Project Sub-total before Administrative Charges Subtotal",null,{"$f":"C53+C81+C111+C139+C169","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"% increase from base",null,{"$f":"IFERROR(N171/C171,\"-\")","v":"-"}]
[null,null,null,{"$f":"ROUNDUP(D171*$B$178,0)","v":0},{"$f":"E171*$B$178","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Administrative Charges Detail (Please ensure this section is completed)"]
[]
[" Administrative Charges (consult with department Finance)"]
["Departmental Staff Charges:",null,{"$f":"IFERROR(ROUNDUP(C$171*$B177,1),\"\")","v":0},{"$f":"ROUNDUP(D$171*$B177,0)","v":0},{"$f":"ROUNDUP(E$171*$B177,0)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D177:M177)","v":0}]
["Corporate Admininstration (max $100,000):",{"$f":"CorpAdminRate","v":1.2500000000000001E-2},{"$f":"IFERROR(IF($C$171*B178>100,100,C171*B178),\"\")","v":0},{"$f":"IF(AND(N171*B178>100,D173>100),100,D173)","v":0},{"$f":"(MAX(0,IF(SUM($D$173:E173)>=100,100-SUM($D$173:D173),IF(E173<100,E173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:F173)>=100,100-SUM($D$173:E173),IF(F173<100,F173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:G173)>=100,100-SUM($D$173:F173),IF(G173<100,G173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:H173)>=100,100-SUM($D$173:G173),IF(H173<100,H173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:I173)>=100,100-SUM($D$173:H173),IF(I173<100,I173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:J173)>=100,100-SUM($D$173:I173),IF(J173<100,J173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:K173)>=100,100-SUM($D$173:J173),IF(K173<100,K173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:L173)>=100,100-SUM($D$173:K173),IF(L173<100,L173,100))))","v":0},{"$f":"(MAX(0,IF(SUM($D$173:M173)>=100,100-SUM($D$173:L173),IF(M173<100,M173,100))))","v":0},0]
["Municipal Accommodations Admin Overhead \n(ONLY if Municipal Accommodations is delivering the project):",null,{"$f":"IFERROR(IF(OR($B$179=\"No\",$B$179=\"\"),0,ROUNDUP(IF(C$171>2000,IF((C$171-2000)*0.01+40>80,80,(C$171-2000)*0.01+40),C$171*0.02),0)),\"\")","v":0},{"$f":"IFERROR(IF(OR($B$179=\"No\",$B$179=\"\"),0,ROUNDUP(IF(D$171>2000,IF((D$171-2000)*0.01+40>80,80,(D$171-2000)*0.01+40),D$171*0.02),0)),\"\")","v":0},0,0,0,0,0,0,0,0,0,0]
["Research (SMIR) (Construction Only, ONLY applies to Public Works):",null,{"$f":"IFERROR(ROUNDUP(C$171*$B180,1),\"\")","v":0},{"$f":"ROUNDUP($B$180*(D53+D111),0)","v":0},{"$f":"ROUNDUP($B$180*(E53+E111),0)","v":0},{"$f":"ROUNDUP($B$180*(F53+F111),0)","v":0},0,0,0,0,0,0,0,0]
["Corporate Interest:",0.02,{"$f":"IFERROR(ROUNDUP((C$171*C200)*$B181,1),\"\")","v":0},{"$f":"ROUNDUP((D$171*$C$200)*$B181,0)","v":0},{"$f":"ROUNDUP((E$171*$C$200)*$B181,0)","v":0},{"$f":"ROUNDUP((F$171*$C$200)*$B181,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"ROUNDUP(D$171*$B182,0)","v":0},{"$f":"ROUNDUP(E$171*$B182,0)","v":0},{"$f":"ROUNDUP(F$171*$B182,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,0,{"$f":"ROUNDUP(D$171*$B183,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0]
["Administrative Charges Sub-total",{"$f":"IFERROR(C188/C201,\"-\")","v":"-"},{"$f":"SUM(C177:C187)","v":0},{"$f":"SUM(D177:D187)","v":0},0,0,0,0,{"$f":"SUM(I177:I187)","v":0},{"$f":"SUM(J177:J187)","v":0},{"$f":"SUM(K177:K187)","v":0},{"$f":"SUM(L177:L187)","v":0},{"$f":"SUM(M177:M187)","v":0},0]
[]
["Project Sub-total before Interest Charges Sub-total ",null,{"$f":"C53+C81+C111+C139+C169+C188","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"Eligible Costs Detail "]
["INELIGIBLE COSTS: "]
["Land Acquisition",null,{"$f":"C114","v":0},0,0,0,0,0,{"$f":"I114","v":0},{"$f":"J114","v":0},{"$f":"K114","v":0},{"$f":"L114","v":0},{"$f":"M114","v":0},0]
["Administrative Charges",null,{"$f":"C188","v":0},0,0,0,0,0,{"$f":"I188","v":0},{"$f":"J188","v":0},{"$f":"K188","v":0},{"$f":"L188","v":0},{"$f":"M188","v":0},0]
["Sub total Ineligible Costs",null,{"$f":"C194+C195","v":0},{"$f":"SUM(D194:D195)","v":0},0,0,0,0,{"$f":"SUM(I194:I195)","v":0},{"$f":"SUM(J194:J195)","v":0},{"$f":"SUM(K194:K195)","v":0},{"$f":"SUM(L194:L195)","v":0},{"$f":"SUM(M194:M195)","v":0},0]
[]
["TOTAL ELIGIBLE COSTS",null,null,{"$f":"D190-D196","v":0},0,0,0,0,{"$f":"I190-I196","v":0},{"$f":"J190-J196","v":0},{"$f":"K190-K196","v":0},{"$f":"L190-L196","v":0},{"$f":"M190-M196","v":0},0]
[]
["Assumed City Contribution (%)",null,null,{"$f":"$C$200","v":0},{"$f":"$C$200","v":0},0,0,0,0,0,0,0,0]
["City's Share of Eligible Project Costs",null,{"$f":"C198*C200","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D201:M201)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Interest Charges Detail (For MAJOR CAPITAL Projects ONLY)"]
["If the project is a major capital project zero out corporate interest percentage in the administrative charges section and enter the rates for interim and long-term:"]
["Internal Debt Financing",null,null,{"$f":"SUM(D196+D201)*D207","v":0},{"$f":"SUM(E196+E201)*E207","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D206:M206)","v":0}]
[null,null,"Internal Rate"]
[null,null,"Long-Term Rate"]
["Long-Term Debt Financing (External)",null,null,null,{"$f":"IF(E208=\"\",\"$0\",(D196+D201)*E208)","v":"$0"},{"$f":"IF(F208=\"\",\"$0\",(E196+E201)*F208+E209)","v":"$0"},"$0","$0","$0","$0","$0","$0","$0",{"$f":"SUM(D209:M209)","v":0}]
[]
["Interest Charges Sub-total",null,null,{"$f":"D206+D209","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Total Ineligible Costs (Land Acquisition + Administration + Interest)",null,null,{"$f":"D196+D211","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D213:M213)","v":0}]
[]
["Total City Costs (Portion of Eligible + Total Ineligible",null,null,{"$f":"D201+D213","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D215:M215)","v":0}]
["Total 3rd Party Costs (Total Project Costs - Total City Costs)",null,null,{"$f":"D190-D196-D201","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D216:M216)","v":0}]
[]
["TOTAL CAPITAL PROJECT COST",null,{"$f":"C171+C188","v":0},{"$f":"D171+D188+D211","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D218:M218)","v":0}]

{"sheet":"BoE Operating Cost Detail","index":4,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[54,1,55,1],[7,1,12,1],[15,0,15,12],[13,0,13,12],[16,0,16,12],[48,0,48,12],[17,0,17,12],[45,1,46,1],[29,1,30,1],[1,1,1,12],[4,0,4,11],[5,2,5,11],[0,0,0,12],[3,1,3,3],[2,1,2,12]]}
["Basis of Estimate (BoE) Operating Cost Detail"]
["Investment Title",{"$f":"InvestmentTitle","v":0}]
["Business Case ID",{"$f":"BC_ID","v":0}]
[null,{"$f":"IF(B7>C7,\"You cannot enter a future dated estimate year.  Please correct\", \"\")","v":""}]
["Operating Budget Impact Detail Table"]
[null,"Estimate Year","Year  of Operating Impact"]
["NET OPERATING IMPACT ($000's)",2024,2025,{"$f":"C7+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034]
["Operating Costs",null,{"$f":"SUM(C47,C31)","v":0},0,0,0,0,0,0,0,0,0]
["Debt & Finance Charges",null,{"$f":"C56","v":0},0,0,0,0,0,0,0,0,0]
["Total Direct Costs",null,{"$f":"SUM(C8:C9)","v":0},0,0,0,0,0,0,0,0,0]
["Less: Incremental Revenue/Recovery"]
["Net Cost/(Benefit)",null,{"$f":"C10-C11","v":0},0,0,0,0,0,0,0,0,0]
["Incremental Full Time Equivalent Positions"]
[]
["Operation & Maintenance Inflation",null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
["Budget Impact Detail"]
["OPERATING COSTS"]
["Salaries and Benefits (consult with Finance and Human Resources)","($000's)","Enter in current dollars in yellow highlighted cells. Inflation will be automatically calculated.",null,null,null,null,null,null,null,null,null,"EXPLANATION/ASSUMPTIONS"]
["Position #1"]
["Position #2"]
["Position #3"]
["Position #4"]
[]
[]
[]
[]
[]
[]
["Sub-total",null,{"$f":"SUM(C20:C29)","v":0},0,0,0,0,0,0,0,0,0]
["Sub-total with Inflation",null,{"$f":"ROUNDUP(C30*POWER((1+C$15),(C$7-$B$7)),0)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Operation & Maintenance Costs (consult with Operations)","($000's)",null,null,null,null,null,null,null,null,null,null,"EXPLANATION/ASSUMPTIONS"]
["Services"]
["Materials, Parts & Supplies"]
["Assets & Purchases"]
["Other"]
[]
[]
[]
[]
[]
[]
[]
[]
["Sub-total",null,{"$f":"SUM(C34:C45)","v":0},0,0,0,0,0,0,0,0,0]
["Sub-total with Inflation",null,{"$f":"ROUNDUP(C46*POWER((1+C$15),(C$7-$B$7)),0)","v":0},0,0,0,0,0,0,0,0,0]
[]
["DEBT & FINANCING CHARGES"]
["Debt & Finance Charges (consult with Finance) ","($000's)",null,null,null,null,null,null,null,null,null,null,"EXPLANATION/ASSUMPTIONS"]
["Long-Term Debt Financing (External) "]
["Principle Repayment "]
[]
[]
["Sub-total",null,{"$f":"SUM(C51:C54)","v":0},{"$f":"SUM(D51:D54)","v":0},{"$f":"SUM(E51:E54)","v":0},0,0,0,0,0,{"$f":"SUM(K51:K54)","v":0},{"$f":"SUM(L51:L54)","v":0}]
["Sub-total with Inflation",null,{"$f":"ROUNDUP(C55*POWER((1+C$15),(C$7-$B$7)),1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Data","index":5,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Class of Estimate",null,"Corporate Interest Rate",null,"Corporate Admin Rate",null,null,null,null,null,null,"Departments"]
["Class 5",null,0.02,null,1.2500000000000001E-2,null,null,null,null,null,null,"Assets and Project Management"]
["Class 4",null,null,null,null,null,null,null,null,null,null,"Assessment and Taxation"]
["Class 3",null,null,null,null,null,null,null,null,null,null,"Audit"]
["Class 2",null,null,null,1,2,3,4,5,null,null,"City Clerks"]
["Class 1",null,null,null,6,7,8,9,10,null,null,"Community Services"]
["N/A",null,null,null,null,null,null,null,null,null,null,"Corporate Finance"]
[null,1,null,null,null,null,null,null,null,null,null,"Fire Paramedic Services"]
[null,2,null,null,null,null,null,null,null,null,null,"Fleet"]
[null,3,null,null,null,null,null,null,null,null,null,"Innovation & Technology"]
[null,4,null,null,null,null,null,null,null,null,null,"Legal Services"]
[null,5,null,null,null,null,null,null,null,null,null,"Police"]
[null,null,null,null,null,null,null,null,null,null,null,"Property, Planning and Development"]
[null,null,null,null,null,null,null,null,null,null,null,"Public Works"]
[null,null,null,null,null,null,null,null,null,null,null,"Transit"]
[null,null,"n/a",null,null,null,null,null,null,null,null,"Water and Waste"]
[null,null,null,null,"Class 1",null,null,null,null,null,null,"Winnipeg Parking Authority"]
[null,null,null,null,"Class 2"]
[null,null,null,null,"Class 3"]
[null,null,null,null,"Class 4"]
[null,null,null,null,"Class 5"]

{"sheet":"Rationale","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}