{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["TEMPLATE INSTRUCTIONS","Project Options Analysis ","Status Quo","NPV Option1","NPV Option 2","NPV Option 3","NPV Option 4","Benefits","Conversion Tables","Dropdowns","Weighting Scale"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":56,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TEMPLATE INSTRUCTIONS","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,2],[5,1,5,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[13,1,13,2],[20,1,20,2],[21,1,21,2],[28,1,28,2],[29,1,29,2]]}
[null,"Net Present Value(NPV) and Benefit Calculation Template Instructions"]
[null,"This template was developed to assess options that address a need or take advantage of an opportunity to enhance a level of service . The template compares investment options for one particular project (ex. should a road be build using asphalt or concrete?). It cannot be used to evaluate different types of projects (ex. do we build a road or a new library?).  \n\nThis template includes a Net Present Value (NPV) calculation module and Option Benefits Evaluation module. NPV is the difference between the present value of cash inflows and the present value of cash outflows over a period of time. NPV is used in capital budgeting and investment planning to analyze the profitability of a projected investment or project.  NPV compares the value of the dollar today to the value of that same dollar in the future —taking returns and inflation into account.\n\nThe Option Benefits Evaluation process follows the same principles and methodology used during the Capital Investment Prioritization stage of the Investment Planning Framework.  It provides an objective means of selecting the best option to address an identified need,  consistent with the department's long term investment plans for maintaining or enhancing levels of service."]
[null,"The NPV is intended to be used to facilitate discussion with stakeholders to understand the current cost of various solutions and to select the option best suited for business case development.  Multiple options are to be presented for projects in order to provide feasible alternatives.  While multiple options are not required for programs, the NPV calculation and review of benefits for the consolidated projects within the program is still required.  This information will carry through to the options analysis in the Business Case template and could also be used to provide information for the Capital Detail Sheets and other reports."]
[null,"There are four parts to the NPV template:\n\n1) Project Options Analysis Summary Tab\n     This tab is used to enter the general information that identifies the options being assessed.\n\n2) Status Quo Tab\n      This tab is used to evaluate the costs of maintaining the current behavior and provides a baseline for assessing operating costs for \n       the options being considered.\n\n3) NPV Option Tabs\n     The Net Present Value of up to four options are calculated using the NPV Options 1 to NPV Options 4 worksheets. The calculation is \n     broken down into Capex (capital expenditures) and Opex (operational expenditures).  \n\n4) Benefits Tab\n    Use the Benefits Evaluation Procedure to evaluate the benefits of each option under consideration for a project.  Benefit assessment \n    must be performed for each option.   \n\nData for the project options analysis summary, status quo and options tabs is to be entered only in the areas that are shaded in YELLOW. \n"]
[]
[null,"Project Options Analysis Summary Tab"]
[null,"Project Details ","Investment Title:  Assign investment title. This should be relevant to the project being proposed and will also be used in the Business Case as the investment title.\nNPV Author: Individual(s) involved in completing the NPV and Benefit Calculation Template.\nDate: Date template was completed\nEstimate Year: This is \"Year 0\" for the calculation of the Project's NPV. Estimate Year should be the current year in which next capital budget is being prepared (i.e. 2019 for a business case being prepared for 2020)"]
[null,"Financial Data","Table of rates used in options analysis. These rates will be used to calculate lifecycle costs and net present value of investments.  Calculation will be completed automatically based on the capital and operational costs inputted into the status quo and option tabs.  Rates will be reviewed annually and updated as required."]
[null,"Project Analysis Summary: Status Quo Analysis","Status quo is defined as maintaining the current operations and maintenance behavior.  The NPV of the operating costs is automatically populated based on the operating cost baseline established in the Status Quo tab."]
[null,"Project Analysis Summary: NPV and Benefit Options Summary Table","Under option description, provide a Title to designate each Option being assessed. This title is automatically transferred to the corresponding worksheets.\n\nThe remaining cells in the table are automatically generated based on the data inputted into the four options tabs.\n\n• NPV Capex: Amount calculated from the NPV Option worksheet for that option\n• NPV Opex: Amount calculated from the NPV Option worksheet for that option\n• NPV: Total of the Capex and Opex NPV\n• Benefit Score: The benefits score from the Benefit worksheet for that option\n• Benefit Score adjusted for Program: The worksheet will adjust the benefit score for the number of  \n   projects within a program. . \n• Cost/Benefit: Divides the NPV by the life-cycle benefit score. Lower is better.\n\nThis table can be used to provide information for the Capital Detail sheets or as a summary for other reports.\n\nNPV Selected Option & Rationale:  Outline key assumptions, notes, or commentary that support the option selected."]
[null,"Project Analysis Summary: Lifecycle Cost Summary Table","All cells in this table are automatically generated based  on the information entered into the Status Quo and Options tabs.  Lifecycle costs for the selected option provide the starting point for creating a Basis of Estimate for that option as it demonstrates the true cost of ownership."]
[null,"Document Control","As projects progress and more accurate information becomes available, it is recommended that the NPV be revisited and updated to confirm that the option previously selected is still the optimal choice. When revisions are necessary, identify items that changed from the previous version of the NPV.  The NPV 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 NPV 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."]
[]
[null,"Status Quo Tab"]
[null,"Type","Choose one option from the list that best describes the investment item. The relevant Opex options for completing the status quo section are: Operate and Maintain. "]
[null,"Description","Provide a brief description of the Opex item."]
[null,"Operating Cost NPV","The NPV will be automatically calculated based on the information provided in the cash flow columns."]
[null,"Cash Flow","Provide the operating cash flows for each year. The status quo will be used as a baseline for assessing operating costs for each option and the lifecycle period of each option considered, and for the status quo,  must be equivalent to the option with the longest period up to a maximum of 30 years. This helps account for major maintenance events or renewals that may take place within the lifecycle of each option.\n\nOperating Escalation Costs (inflation rates)  will be automatically calculated for costs beyond year 0 within the lifecycle period.\n\n"]
[null,"Total Lifecycle Operating Cost","The total lifecycle operating costs will be automatically calculated based on the information provided in the cash flow columns."]
[]
[null,"NPV Options Tabs"]
[null,"Complete a separate NPV option tab for each option identified. There are two sections to be filled out for each option, one to detail capital costs and another for operating costs. This template allows users to evaluate up to 4 options. If additional options are to be evaluated please contact the Corporate Asset Management Office for an expanded template."]
[null,"Type","Choose one option from the list that best describes the investment item. \n\nThe Capex options are: Pre-construction, Construction, Decommission, Equipment, Interest Charges and Capex Benefits.  A Capex Benefit generally relates to the sale of an asset;  for example the sale of land.\n\nThe Opex options are: Operate, Maintain, Salaries & Benefits, Debt & Financing Charges and Opex Benefits. Incorporate only the items for which the annual operating expenditures will vary as a result of the investment (i.e. net cost or net saving on operating cost compared to the Opex identified in the Status Quo tab). An Opex Benefit relates to all the potential operating benefits as a result of the investment, such as new revenue generation activity or reduction in costs (e.g. sale of excess electricity from solar panels on a new building, reduction in energy usage, etc.)."]
[null,"Description","Provide a brief description of the Capex or Opex item."]
[null,"Total NPV","The NPV will be automatically calculated based on the cash flow information provided in the cash flow columns."]
[null,"Cash Flow","Provide the cash flows for each year up to a maximum of 30 years. When comparing investment options for a particular project, the lifecycle period of each option considered must be equivalent to the option with the longest period (30 yr. max.). This helps account for major maintenance events or renewals that may take place within the lifecycle of each option.\n\nFor Capital Costs, the number must include:\n1. Cost for planning, product/materials and execution (i.e. the amount required to address the Need)\n2. Construction Escalation Costs (inflation rates) will be automatically calculated for costs beyond year 0 within the lifecycle period. \n3. Any other cost as appropriate and determined by the Business Unit\n\nFor Operating Costs, the number must include:\n1. The Net Increase in operating costs as a result of the investment (e.g. if the current operating cost (status quo) of the asset is $1000, and the operating cost of the new asset is $1100, the net increase in operating cost should be $100). \n2.  The Net decrease in operating costs as a result of the investment (e.g. if the current energy cost (status quo) to operate the asset is $750 and the energy cost for the new asset is $500, the net savings is $250).\n3. Operating Escalation Costs (inflation rates)  will be automatically calculated for costs beyond year 0 within the lifecycle period.\n\n"]
[null,"Total Lifecycle Costs","The lifecycle capital, operating, and total costs will be automatically calculated based on the information provided in the cash flow columns."]
[]
[null,"Benefits Tab"]
[null,"STEP 1: Describe the Options\nFor each option start by filling out the \"General\" section and related columns:"]
[null,"Options","Automatically generated based on option title entered in the NPV Summary Tab."]
[null,"Investment Type","Choose between the two types of investments: Project or Program. A selection must be made in order for benefits to be calculated."]
[null,"Number of Projects included in the Program","Put the number of projects included in the program. For linear asset projects, it may be difficult to know the number of Projects included in the Program. In that case, estimate the number of projects you will/could do for the investment amount requested.  A number must be entered in order for program benefits to calculate."]
[null,"Option Total NPV ($k)","The option NPV will be automatically filled in based on the information provided in the NPV Options section."]
[null,"STEP 2: Assess the Benefits of each Option\nThis step includes understanding what the main driver of the project is and then assessing the benefits for each option to calculate a total benefit score for each option. The process of assessing benefits is outlined in greater detail within the Investment Planning: Benefit Evaluation Procedure.  \n\n"]

{"sheet":"Project Options Analysis ","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,2,8,9],[31,2,31,3],[32,2,32,3],[23,2,23,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[18,1,18,9],[16,1,16,9],[17,1,17,4],[11,3,11,9],[12,3,12,9],[35,1,35,9],[25,1,25,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[29,6,29,7],[30,6,30,7],[29,2,29,3],[30,2,30,3],[33,2,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[27,1,27,9],[26,1,26,9],[1,2,2,9],[31,6,31,7],[32,6,32,7],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[15,1,15,9],[6,2,6,9],[4,1,4,9],[10,1,10,9],[7,2,7,9],[13,3,13,9],[19,1,19,9],[28,1,28,9],[5,2,5,9],[37,2,37,3],[37,4,37,5],[37,6,37,9],[38,2,38,3],[38,4,38,5],[38,6,38,9],[43,2,43,3],[43,4,43,5],[43,6,43,9],[36,2,36,9],[41,2,41,3],[41,4,41,5],[41,6,41,9],[42,2,42,3],[42,4,42,5],[42,6,42,9],[39,2,39,3],[39,4,39,5],[39,6,39,9],[40,2,40,3],[40,4,40,5],[40,6,40,9]]}
[]
[null,null,"Project Options Analysis Summary"]
[]
[]
[null,"PROJECT DETAILS"]
[null,"Investment Title: "]
[null,"NPV Author:"]
[null,"Date:"]
[null,"Estimate Year",2023]
[]
[null,"FINANCIAL DATA"]
[null,"Capital Inflation Rate:",0.03,"Source: Economic Research Office"]
[null,"Operating Inflation Rate:",0.02,"Source: Economic Research Office"]
[null,"Discount Rate: ",5.5E-2,"The discount rate represents the City's borrowing cost. This rate will be applied to initial capital costs and all operational/maintenance activities beyond year 0 within the lifecycle period.  Discounting must also be applied to revenue should those values be available.\nSource: Corporate Finance - Treasury Division\n"]
[]
[null,"PROJECT ANALYSIS SUMMARY"]
[null,"Status Quo Analysis"]
[null,"Baseline NPV Opex (Sk)",null,null,null,{"$f":"'Status Quo'!G3","v":0}]
[null,"*Status quo is defined as maintaining the current operations and maintenance behaviour. This is typically the O&M recommendations defined by the manufacturer or designer.  Status quo provides the realistic operating cost baseline to be used to compare the project options against."]
[null,"NPV and Benefit Options Summary Table"]
[null,"Option Number","Option Description",null,"NPV Capex ($k)","NPV Opex\n ($k)","NPV\n ($k)","Benefit Score\n(in points)","Cost/Benefit","Cost/Benefit Rank"]
[null,"Option 1",null,null,{"$f":"IF('NPV Option1'!G3=0,\"\",'NPV Option1'!G3)","v":""},{"$f":"IF('NPV Option1'!G4=0,\"\",'NPV Option1'!G4)","v":""},{"$f":"IF('NPV Option1'!G3+'NPV Option1'!G4=0,\"\",'NPV Option1'!G3+'NPV Option1'!G4)","v":""},{"$f":"Benefits!Z16","v":0},{"$f":"Benefits!AB16","v":""},{"$f":"Benefits!AC16","v":""}]
[null,"Option 2",null,null,{"$f":"IF('NPV Option 2'!G3=0,\"\",'NPV Option 2'!G3)","v":""},{"$f":"IF('NPV Option 2'!G4=0,\"\",'NPV Option 2'!G4)","v":""},{"$f":"IF('NPV Option 2'!G3+'NPV Option 2'!G4=0,\"\",'NPV Option 2'!G3+'NPV Option 2'!G4)","v":""},{"$f":"Benefits!Z17","v":0},{"$f":"Benefits!AB17","v":""},{"$f":"Benefits!AC17","v":""}]
[null,"Option 3",null,null,{"$f":"IF('NPV Option 3'!G3=0,\"\",'NPV Option 3'!G3)","v":""},{"$f":"IF('NPV Option 3'!G4=0,\"\",'NPV Option 3'!G4)","v":""},{"$f":"IF('NPV Option 3'!G3+'NPV Option 3'!G4=0,\"\",'NPV Option 3'!G3+'NPV Option 3'!G4)","v":""},{"$f":"Benefits!Z18","v":0},{"$f":"Benefits!AB18","v":""},{"$f":"Benefits!AC18","v":""}]
[null,"Option 4",null,null,{"$f":"IF('NPV Option 4'!G3=0,\"\",'NPV Option 4'!G3)","v":""},{"$f":"IF('NPV Option 4'!G4=0,\"\",'NPV Option 4'!G4)","v":""},{"$f":"IF('NPV Option 4'!G3+'NPV Option 4'!G4=0,\"\",'NPV Option 4'!G3+'NPV Option 4'!G4)","v":""},{"$f":"Benefits!Z19","v":0},{"$f":"Benefits!AB19","v":""},{"$f":"Benefits!AC19","v":""}]
[]
[null,"NPV Selected Option & Rationale (Inlcude key assumptions, notes, or commentary that support the option selected)"]
[]
[null,"Lifecycle Cost Summary Table"]
[null,"Option Number"," Description",null,"Total Lifecycle\n Capital Cost\n($k)",null,"Total Lifecycle \nOperating Cost\n($k)",null,"Total Lifecycle\n Cost\n($k)"]
[null,"Option 1",{"$f":"C22","v":0},null,{"$f":"IF('NPV Option1'!C42=0,\"\",'NPV Option1'!C42)","v":""},null,{"$f":"IF('NPV Option1'!C43=0,\"\",'NPV Option1'!C43)","v":""},null,{"$f":"IF('NPV Option1'!C42+'NPV Option1'!C43=0,\"\",'NPV Option1'!C42+'NPV Option1'!C43)","v":""}]
[null,"Option 2",{"$f":"C23","v":0},null,{"$f":"IF('NPV Option 2'!C42=0,\"\",'NPV Option 2'!C42)","v":""},null,{"$f":"IF('NPV Option 2'!C43=0,\"\",'NPV Option 2'!C43)","v":""},null,{"$f":"IF('NPV Option 2'!C42+'NPV Option 2'!C43=0,\"\",'NPV Option 2'!C42+'NPV Option 2'!C43)","v":""}]
[null,"Option 3",{"$f":"C24","v":0},null,{"$f":"IF('NPV Option 3'!C42=0,\"\",'NPV Option 3'!C42)","v":""},null,{"$f":"IF('NPV Option 3'!C43=0,\"\",'NPV Option 3'!C43)","v":""},null,{"$f":"IF('NPV Option 3'!C42+'NPV Option 3'!C43=0,\"\",'NPV Option 3'!C42+'NPV Option 3'!C43)","v":""}]
[null,"Option 4",{"$f":"C25","v":0},null,{"$f":"IF('NPV Option 4'!C42=0,\"\",'NPV Option 4'!C42)","v":""},null,{"$f":"IF('NPV Option 4'!C43=0,\"\",'NPV Option 4'!C43)","v":""},null,{"$f":"IF('NPV Option 4'!C42+'NPV Option 4'!C43=0,\"\",'NPV Option 4'!C42+'NPV Option 4'!C43)","v":""}]
[]
[null,"Document Control"]
[null,"Major Changes from Previous Version"]
[null,"Version #","Date",null,"Author",null,"Rationale"]

{"sheet":"Status Quo","index":2,"n_rows":23,"n_cols":109,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,1],[3,6,3,7],[19,0,19,1],[20,0,20,1],[4,2,4,32],[8,2,8,32],[2,3,2,5],[3,3,3,5],[2,6,2,7],[1,3,1,5],[1,6,1,7]]}
["City of Winnipeg"]
["Business Case Development"]
["Operating Cost and NPV Calculation",null,null,"NPV Total Operating Cost",null,null,{"$f":"BZ21","v":0}]
[]
["Status Quo Analysis",null,"Detail by Year ($k)"]
[null,null,{"$f":"EstimateYear","v":2023},{"$f":"C6+1","v":2024},{"$f":"D6+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
[null,"Cost Escalation/Operating Inflation ",0,{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02}]
[]
["Operating Cost","Description","Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA19+1","v":2024},{"$f":"CB19+1","v":2025},{"$f":"CC19+1","v":2026},{"$f":"CD19+1","v":2027},{"$f":"CE19+1","v":2028},{"$f":"CF19+1","v":2029},{"$f":"CG19+1","v":2030},{"$f":"CH19+1","v":2031},{"$f":"CI19+1","v":2032},{"$f":"CJ19+1","v":2033},{"$f":"CK19+1","v":2034},{"$f":"CL19+1","v":2035},{"$f":"CM19+1","v":2036},{"$f":"CN19+1","v":2037},{"$f":"CO19+1","v":2038},{"$f":"CP19+1","v":2039},{"$f":"CQ19+1","v":2040},{"$f":"CR19+1","v":2041},{"$f":"CS19+1","v":2042},{"$f":"CT19+1","v":2043},{"$f":"CU19+1","v":2044},{"$f":"CV19+1","v":2045},{"$f":"CW19+1","v":2046},{"$f":"CX19+1","v":2047},{"$f":"CY19+1","v":2048},{"$f":"CZ19+1","v":2049},{"$f":"DA19+1","v":2050},{"$f":"DB19+1","v":2051},{"$f":"DC19+1","v":2052},{"$f":"DD19+1","v":2053}]
["Total Annual Opex:",null,{"$f":"SUM(C10:C19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA20+NPV(DiscountRate,CB20:DE20)","v":0},{"$f":"IF(C20=\"\",0,C20)","v":0},{"$f":"IF(D20=\"\",0,D20)","v":0},{"$f":"IF(E20=\"\",0,E20)","v":0},{"$f":"IF(F20=\"\",0,F20)","v":0},{"$f":"IF(G20=\"\",0,G20)","v":0},{"$f":"IF(H20=\"\",0,H20)","v":0},{"$f":"IF(I20=\"\",0,I20)","v":0},{"$f":"IF(J20=\"\",0,J20)","v":0},{"$f":"IF(K20=\"\",0,K20)","v":0},{"$f":"IF(L20=\"\",0,L20)","v":0},{"$f":"IF(M20=\"\",0,M20)","v":0},{"$f":"IF(N20=\"\",0,N20)","v":0},{"$f":"IF(O20=\"\",0,O20)","v":0},{"$f":"IF(P20=\"\",0,P20)","v":0},{"$f":"IF(Q20=\"\",0,Q20)","v":0},{"$f":"IF(R20=\"\",0,R20)","v":0},{"$f":"IF(S20=\"\",0,S20)","v":0},{"$f":"IF(T20=\"\",0,T20)","v":0},{"$f":"IF(U20=\"\",0,U20)","v":0},{"$f":"IF(V20=\"\",0,V20)","v":0},{"$f":"IF(W20=\"\",0,W20)","v":0},{"$f":"IF(X20=\"\",0,X20)","v":0},{"$f":"IF(Y20=\"\",0,Y20)","v":0},{"$f":"IF(Z20=\"\",0,Z20)","v":0},{"$f":"IF(AA20=\"\",0,AA20)","v":0},{"$f":"IF(AB20=\"\",0,AB20)","v":0},{"$f":"IF(AC20=\"\",0,AC20)","v":0},{"$f":"IF(AD20=\"\",0,AD20)","v":0},{"$f":"IF(AE20=\"\",0,AE20)","v":0},{"$f":"IF(AF20=\"\",0,AF20)","v":0},0]
["Total Annual Opex with Inflation:",null,{"$f":"ROUNDUP(C20*POWER((1+C$7), (C$6-$C$6)),0)","v":0},{"$f":"ROUNDUP(D20*POWER((1+D$7), (D$6-$C$6)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA21+NPV(DiscountRate,CB21:DE21)","v":0},{"$f":"IF(C21=\"\",0,C21)","v":0},{"$f":"IF(D21=\"\",0,D21)","v":0},{"$f":"IF(E21=\"\",0,E21)","v":0},{"$f":"IF(F21=\"\",0,F21)","v":0},{"$f":"IF(G21=\"\",0,G21)","v":0},{"$f":"IF(H21=\"\",0,H21)","v":0},{"$f":"IF(I21=\"\",0,I21)","v":0},{"$f":"IF(J21=\"\",0,J21)","v":0},{"$f":"IF(K21=\"\",0,K21)","v":0},{"$f":"IF(L21=\"\",0,L21)","v":0},{"$f":"IF(M21=\"\",0,M21)","v":0},{"$f":"IF(N21=\"\",0,N21)","v":0},{"$f":"IF(O21=\"\",0,O21)","v":0},{"$f":"IF(P21=\"\",0,P21)","v":0},{"$f":"IF(Q21=\"\",0,Q21)","v":0},{"$f":"IF(R21=\"\",0,R21)","v":0},{"$f":"IF(S21=\"\",0,S21)","v":0},{"$f":"IF(T21=\"\",0,T21)","v":0},{"$f":"IF(U21=\"\",0,U21)","v":0},{"$f":"IF(V21=\"\",0,V21)","v":0},{"$f":"IF(W21=\"\",0,W21)","v":0},{"$f":"IF(X21=\"\",0,X21)","v":0},{"$f":"IF(Y21=\"\",0,Y21)","v":0},{"$f":"IF(Z21=\"\",0,Z21)","v":0},{"$f":"IF(AA21=\"\",0,AA21)","v":0},{"$f":"IF(AB21=\"\",0,AB21)","v":0},{"$f":"IF(AC21=\"\",0,AC21)","v":0},{"$f":"IF(AD21=\"\",0,AD21)","v":0},{"$f":"IF(AE21=\"\",0,AE21)","v":0},{"$f":"IF(AF21=\"\",0,AF21)","v":0},{"$f":"IF(AG21=\"\",0,AG21)","v":0}]
[]
["TOTAL LIFECYCLE OPERATING COST",null,{"$f":"SUM(C21:AG21)","v":0}]

{"sheet":"NPV Option1","index":3,"n_rows":44,"n_cols":109,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,2,27,32],[25,0,25,1],[5,0,5,1],[2,3,2,5],[2,6,2,7],[6,0,6,1],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[11,0,11,1],[11,2,11,32],[24,0,24,1],[13,2,13,32],[38,0,38,1],[39,0,39,1],[41,0,41,1],[42,0,42,1],[43,0,43,1]]}
["City of Winnipeg"]
["Business Case Development",null,null,"LIFECYCLE COST SUMMARY NET PRESENT VALUE (NPV)"]
["Lifecycle Cost and NPV Calculation",null,null,"NPV Total Capital Cost",null,null,{"$f":"BZ26","v":0}]
[null,null,null,"NPV Total Operating Cost",null,null,{"$f":"BZ40","v":0}]
["Project:",null,null,"TOTAL NET PRESENT VALUE COST",null,null,{"$f":"BZ26+BZ40","v":0}]
[{"$f":"'Project Options Analysis '!C6","v":0}]
[{"$f":"\"Option 1: \"&'Project Options Analysis '!C22","v":"Option 1: "}]
[]
[null,"Cost Escalatation/Construction Inflation",0,{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03}]
[null,"Cost Escalation/Operating Inflation ",0,{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02}]
[]
["Cost Components",null,"Detail by Year ($k)"]
["Type","Description",{"$f":"EstimateYear","v":2023},{"$f":"C13+1","v":2024},{"$f":"D13+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Capital Cost",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA24+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Capex:",null,{"$f":"SUM(C15:C24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA25+NPV(DiscountRate,CB25:DE25)","v":0},{"$f":"IF(C25=\"\",0,C25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S25=\"\",0,S25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Capex with Inflation",null,{"$f":"ROUNDUP(C25*POWER((1+C$9),(C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D25*POWER((1+D$9),(D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E25*POWER((1+E$9),(E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA26+NPV(DiscountRate,CB26:DE26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating Cost",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA38+1","v":2024},{"$f":"CB38+1","v":2025},{"$f":"CC38+1","v":2026},{"$f":"CD38+1","v":2027},{"$f":"CE38+1","v":2028},{"$f":"CF38+1","v":2029},{"$f":"CG38+1","v":2030},{"$f":"CH38+1","v":2031},{"$f":"CI38+1","v":2032},{"$f":"CJ38+1","v":2033},{"$f":"CK38+1","v":2034},{"$f":"CL38+1","v":2035},{"$f":"CM38+1","v":2036},{"$f":"CN38+1","v":2037},{"$f":"CO38+1","v":2038},{"$f":"CP38+1","v":2039},{"$f":"CQ38+1","v":2040},{"$f":"CR38+1","v":2041},{"$f":"CS38+1","v":2042},{"$f":"CT38+1","v":2043},{"$f":"CU38+1","v":2044},{"$f":"CV38+1","v":2045},{"$f":"CW38+1","v":2046},{"$f":"CX38+1","v":2047},{"$f":"CY38+1","v":2048},{"$f":"CZ38+1","v":2049},{"$f":"DA38+1","v":2050},{"$f":"DB38+1","v":2051},{"$f":"DC38+1","v":2052},{"$f":"DD38+1","v":2053}]
["Total Annual Opex:",null,{"$f":"SUM(C29:C38)","v":0},{"$f":"SUM(D29:D38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA39+NPV(DiscountRate,CB39:DE39)","v":0},{"$f":"IF(C39=\"\",0,C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S39=\"\",0,S39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Opex with Inflation:",null,{"$f":"ROUNDUP(C39*POWER((1+C$10), (C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D39*POWER((1+D$10), (D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E39*POWER((1+E$10), (E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA40+NPV(DiscountRate,CB40:DE40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL LIFECYCLE CAPITAL COST",null,{"$f":"SUM(C26:AG26)","v":0}]
["TOTAL LIFECYCLE OPERATING COST",null,{"$f":"SUM(C40:AG40)","v":0}]
["TOTAL LIFECYCLE COST ",null,{"$f":"C42+C43","v":0}]

{"sheet":"NPV Option 2","index":4,"n_rows":44,"n_cols":109,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,2,27,32],[25,0,25,1],[5,0,5,1],[2,3,2,5],[2,6,2,7],[6,0,6,1],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[11,0,11,1],[11,2,11,32],[24,0,24,1],[13,2,13,32],[38,0,38,1],[39,0,39,1],[41,0,41,1],[42,0,42,1],[43,0,43,1]]}
["City of Winnipeg"]
["Business Case Development",null,null,"LIFECYCLE COST SUMMARY NET PRESENT VALUE (NPV)"]
["Lifecycle Cost and NPV Calculation",null,null,"NPV Total Capital Cost",null,null,{"$f":"BZ26","v":0}]
[null,null,null,"NPV Total Operating Cost",null,null,{"$f":"BZ40","v":0}]
["Project:",null,null,"TOTAL NET PRESENT VALUE COST",null,null,{"$f":"BZ26+BZ40","v":0}]
[{"$f":"'Project Options Analysis '!C6","v":0}]
[{"$f":"\"Option 2: \"&'Project Options Analysis '!C23","v":"Option 2: "}]
[]
[null,"Cost Escalatation/Construction Inflation",0,{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03}]
[null,"Cost Escalation/Operating Inflation ",0,{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02}]
[]
["Cost Components",null,"Detail by Year ($k)"]
["Type","Description",{"$f":"EstimateYear","v":2023},{"$f":"C13+1","v":2024},{"$f":"D13+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Capital Cost",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA24+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Capex:",null,{"$f":"SUM(C15:C24)","v":0},{"$f":"SUM(D15:D24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA25+NPV(DiscountRate,CB25:DE25)","v":0},{"$f":"IF(C25=\"\",0,C25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S25=\"\",0,S25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Capex with Inflation",null,{"$f":"ROUNDUP(C25*POWER((1+C$9),(C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D25*POWER((1+D$9),(D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E25*POWER((1+E$9),(E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA26+NPV(DiscountRate,CB26:DE26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating Cost",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA38+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Opex:",null,{"$f":"SUM(C29:C38)","v":0},{"$f":"SUM(D29:D38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA39+NPV(DiscountRate,CB39:DE39)","v":0},{"$f":"IF(C39=\"\",0,C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S39=\"\",0,S39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Opex with Inflation:",null,{"$f":"ROUNDUP(C39*POWER((1+C$10), (C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D39*POWER((1+D$10), (D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E39*POWER((1+E$10), (E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA40+NPV(DiscountRate,CB40:DE40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL LIFECYCLE CAPITAL COST",null,{"$f":"SUM(C26:AG26)","v":0}]
["TOTAL LIFECYCLE OPERATING COST",null,{"$f":"SUM(C40:AG40)","v":0}]
["TOTAL LIFECYCLE COST ",null,{"$f":"C42+C43","v":0}]

{"sheet":"NPV Option 3","index":5,"n_rows":44,"n_cols":109,"rows_kept":44,"cut":false,"hidden":false,"merged":[[27,2,27,32],[25,0,25,1],[5,0,5,1],[2,3,2,5],[2,6,2,7],[6,0,6,1],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[11,0,11,1],[11,2,11,32],[24,0,24,1],[13,2,13,32],[38,0,38,1],[39,0,39,1],[41,0,41,1],[42,0,42,1],[43,0,43,1]]}
["City of Winnipeg"]
["Business Case Development",null,null,"LIFECYCLE COST SUMMARY NET PRESENT VALUE (NPV)"]
["Lifecycle Cost and NPV Calculation",null,null,"NPV Total Capital Cost",null,null,{"$f":"BZ26","v":0}]
[null,null,null,"NPV Total Operating Cost",null,null,{"$f":"BZ40","v":0}]
["Project:",null,null,"TOTAL NET PRESENT VALUE COST",null,null,{"$f":"BZ26+BZ40","v":0}]
[{"$f":"'Project Options Analysis '!C6","v":0}]
[{"$f":"\"Option 3: \"&'Project Options Analysis '!C24","v":"Option 3: "}]
[]
[null,"Cost Escalatation/Construction Inflation",0,{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03},{"$f":"'Project Options Analysis '!$C$12","v":0.03}]
[null,"Cost Escalation/Operating Inflation ",0,{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02}]
[]
["Cost Components",null,"Detail by Year ($k)"]
["Type","Description",{"$f":"EstimateYear","v":2023},{"$f":"C13+1","v":2024},{"$f":"D13+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Capital",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA24+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Capex:",null,{"$f":"SUM(C15:C24)","v":0},{"$f":"SUM(D15:D24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA25+NPV(DiscountRate,CB25:DE25)","v":0},{"$f":"IF(C25=\"\",0,C25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S25=\"\",0,S25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Capex with Inflation",null,{"$f":"ROUNDUP(C25*POWER((1+C$9),(C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D25*POWER((1+D$9),(D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E25*POWER((1+E$9),(E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA26+NPV(DiscountRate,CB26:DE26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA38+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Opex:",null,{"$f":"SUM(C29:C38)","v":0},{"$f":"SUM(D29:D38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA39+NPV(DiscountRate,CB39:DE39)","v":0},{"$f":"IF(C39=\"\",0,C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S39=\"\",0,S39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Opex with Inflation:",null,{"$f":"ROUNDUP(C39*POWER((1+C$10), (C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D39*POWER((1+D$10), (D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E39*POWER((1+E$10), (E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA40+NPV(DiscountRate,CB40:DE40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL LIFECYCLE CAPITAL COST",null,{"$f":"SUM(C26:AG26)","v":0}]
["TOTAL LIFECYCLE OPERATING COST",null,{"$f":"SUM(C40:AG40)","v":0}]
["TOTAL LIFECYCLE COST ",null,{"$f":"C42+C43","v":0}]

{"sheet":"NPV Option 4","index":6,"n_rows":44,"n_cols":109,"rows_kept":44,"cut":false,"hidden":false,"merged":[[39,0,39,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[25,0,25,1],[2,3,2,5],[2,6,2,7],[3,3,3,5],[3,6,3,7],[4,3,4,5],[4,6,4,7],[27,2,27,32],[38,0,38,1],[5,0,5,1],[6,0,6,1],[11,0,11,1],[11,2,11,32],[24,0,24,1],[13,2,13,32]]}
["City of Winnipeg"]
["Business Case Development",null,null,"LIFECYCLE COST SUMMARY NET PRESENT VALUE (NPV)"]
["Lifecycle Cost and NPV Calculation",null,null,"NPV Total Capital Cost",null,null,{"$f":"BZ26","v":0}]
[null,null,null,"NPV Total Operating Cost",null,null,{"$f":"BZ40","v":0}]
["Project:",null,null,"TOTAL NET PRESENT VALUE COST",null,null,{"$f":"BZ26+BZ40","v":0}]
[{"$f":"'Project Options Analysis '!C6","v":0}]
[{"$f":"\"Option 4: \"&'Project Options Analysis '!C25","v":"Option 4: "}]
[]
[null,"Cost Escalatation/Construction Inflation",0,{"$f":"'Project Options Analysis '!$C$12","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,"Cost Escalation/Operating Inflation ",0,{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02},{"$f":"'Project Options Analysis '!$C$13","v":0.02}]
[]
["Cost Components",null,"Detail by Year ($k)"]
["Type","Description",{"$f":"EstimateYear","v":2023},{"$f":"C13+1","v":2024},{"$f":"D13+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Capital",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA24+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Capex:",null,{"$f":"SUM(C15:C24)","v":0},{"$f":"SUM(D15:D24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA25+NPV(DiscountRate,CB25:DE25)","v":0},{"$f":"IF(C25=\"\",0,C25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S25=\"\",0,S25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Capex with Inflation",null,{"$f":"ROUNDUP(C25*POWER((1+C$9),(C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D25*POWER((1+D$9),(D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E25*POWER((1+E$9),(E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA26+NPV(DiscountRate,CB26:DE26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Operating",null,"Enter cash flow in current dollars ($K). Inflation will be automatically calculated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NPV",{"$f":"EstimateYear","v":2023},{"$f":"CA38+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053]
["Total Annual Opex:",null,{"$f":"SUM(C29:C38)","v":0},{"$f":"SUM(D29:D38)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA39+NPV(DiscountRate,CB39:DE39)","v":0},{"$f":"IF(C39=\"\",0,C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(S39=\"\",0,S39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Annual Opex with Inflation:",null,{"$f":"ROUNDUP(C39*POWER((1+C$10), (C$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(D39*POWER((1+D$10), (D$13-$C$13)),0)","v":0},{"$f":"ROUNDUP(E39*POWER((1+E$10), (E$13-$C$13)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CA40+NPV(DiscountRate,CB40:DE40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["TOTAL LIFECYCLE CAPITAL COST",null,{"$f":"SUM(C26:AG26)","v":0}]
["TOTAL LIFECYCLE OPERATING COST",null,{"$f":"SUM(C40:AG40)","v":0}]
["TOTAL LIFECYCLE COST ",null,{"$f":"C42+C43","v":0}]

{"sheet":"Benefits","index":7,"n_rows":19,"n_cols":61,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,0,7,4],[7,7,7,12],[7,13,7,16],[7,18,7,25],[7,26,7,28],[2,17,2,18],[11,46,12,47],[6,5,6,17],[8,27,9,27],[8,26,9,26],[8,28,9,28],[8,7,13,7],[8,8,12,10],[8,11,12,12],[8,13,13,13],[8,14,13,14],[8,15,13,15],[8,16,13,16],[8,17,13,17],[11,60,13,60],[7,5,7,6],[11,50,12,51],[11,52,12,53],[11,54,12,55],[11,58,13,58],[11,59,13,59],[8,58,8,63],[10,40,10,47],[10,48,10,55],[10,56,13,56],[10,57,13,57],[10,58,10,60],[11,40,12,41],[11,42,12,45],[11,48,12,49]]}
["City of Winnipeg"]
["Business Case Development"]
["Options Benefit Evaluation"]
[]
["Project:"]
[{"$f":"'Project Options Analysis '!C6","v":0}]
[null,null,null,null,null,"BENEFIT EVALUATION"]
["Investment Details",null,null,null,null,"Multiplier",null,"Level of Service - Benefit Analysis",null,null,null,null,null,"Strategic Alignment - Benefit Analysis",null,null,null,"Multiplier","Benefits Score Summary",null,null,null,null,null,null,null,"Rank"]
["Options","Department","Service","Investment Type","Option Total NPV ($k)","Service Impact\nof Project","User-hrs\n(per year)","Compliance with New Legislation","Maintain Level of Service",null,null,"Enhance Level of Service",null,"Environmental Sustainability","Enables Growth","Operational Efficiency/Revenue Generation","Culture/ Heritage","Service Usage","New Regulation","Maintain LOS","Enhance LOS","Environment","Enables Growth","Operational Efficiency","Cultural/\nHeritage","Total Benefit Score ","Benefit Rank","Cost/ Benefit Points Ratio","Cost/\nBenefit Rank"]
[]
[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,"LOS Benefits",null,null,null,null,null,null,null,"Strategic Alignment",null,null,null,null,null,null,null,"Total Benefit Score \n(Usage & Importance)","Total Benefit Score \n(Service Impact)","Multiplier"]
[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,"Compliance with New Legislation",null,"Maintain Level of Service",null,null,null,"Enhance Level of Service",null,"Environmental Sustainability",null,"Enables Growth",null,"Operational Efficiency/Revenue Generation",null,"Culture/Heritage",null,null,null,"Service Usage","Service Importance","Service Impact"]
[]
[null,null,null,null,null,null,null,null,"Category","From","To","Category","Score",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,"Score","Weighted Score","From","To","Total Score","Weighted Score","Score","Weighted Score","Score","Weighted Score","Score","Weighted Score","Score","Weighted Score","Score","Weighted Score"]
[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,{"$f":"IFERROR(IF(#REF!=#REF!,#REF!/Z15,IF(#REF!=#REF!,(#REF!/#REF!)/Z15,\"\")),\"\")","v":""},{"$f":"IFERROR(RANK(AB15,$AB$16:$AB$19,1),\"\")","v":""}]
[{"$f":"\"Option 1: \"&'Project Options Analysis '!C22","v":"Option 1: "},null,null,null,{"$f":"'Project Options Analysis '!G22","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G16/158475797","v":0},{"$f":"AP16","v":0},{"$f":"AT16","v":0},{"$f":"AV16","v":0},{"$f":"AX16","v":0},{"$f":"AZ16","v":0},{"$f":"BB16","v":0},{"$f":"BD16","v":0},{"$f":"BF16","v":0},{"$f":"IFERROR(RANK(Z16,$Z$16:$Z$19,0),\"\")","v":1},{"$f":"IFERROR(IF(D16=\"Project\",E16/Z16,IF(D16=\"Program\",E16/Z16,\"\")),\"\")","v":""},{"$f":"IFERROR(RANK(AB16,$AB$16:$AB$19,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H16,'Conversion Tables'!$G$8:$N$12,3,FALSE)/'Conversion Tables'!$I$12*Max_Point,0)","v":0},{"$f":"AO16*'Weighting Scale'!$H$10*BG16*BH16","v":0},{"$f":"IFERROR(VLOOKUP(J16,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K16,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"(AQ16-AR16)/'Conversion Tables'!$C$32*Max_Point","v":0},{"$f":"AS16*'Weighting Scale'!$H$11*BG16*BH16","v":0},{"$f":"IFERROR(VLOOKUP(M16,'Conversion Tables'!$G$8:$N$12,2,FALSE)/'Conversion Tables'!$H$12*Max_Point,0)","v":0},{"$f":"AU16*'Weighting Scale'!$H$12*BG16*BH16","v":0},{"$f":"IFERROR(VLOOKUP(N16,'Conversion Tables'!$G$8:$N$12,6,FALSE)/'Conversion Tables'!$L$12*Max_Point,0)","v":0},{"$f":"AW16*'Weighting Scale'!$H$15*BG16*BH16","v":0},{"$f":"IFERROR(VLOOKUP(O16,'Conversion Tables'!$G$8:$N$12,4,FALSE)/'Conversion Tables'!$J$12*Max_Point,0)","v":0},{"$f":"AY16*'Weighting Scale'!$H$13*BG16*BH16","v":0},{"$f":"IFERROR(VLOOKUP(P16,'Conversion Tables'!$G$8:$N$12,7,FALSE)/'Conversion Tables'!$M$12*Max_Point,0)","v":0},{"$f":"BA16*'Weighting Scale'!$H$16*BG16*BH16","v":0},{"$f":"IF(Q16=\"Yes\",('Conversion Tables'!$N$12)/'Conversion Tables'!$N$12*Max_Point,0)","v":0},{"$f":"BC16*'Weighting Scale'!$H$17*BG16*BH16","v":0},{"$f":"AP16+AT16+AV16+AX16+AZ16+BB16+BD16","v":0},{"$f":"BE16*BI16","v":0},{"$f":"R16","v":0},{"$f":"IF(C16=Dropdowns!$C$7,Dropdowns!$B$7,IF(C16=Dropdowns!$C$8,Dropdowns!$B$8,IF(C16=Dropdowns!$C$9,Dropdowns!$B$9,IF(C16=Dropdowns!$C$10,Dropdowns!$B$10,IF(C16=Dropdowns!$C$11,Dropdowns!$B$11,IF(C16=Dropdowns!$C$12,Dropdowns!$B$12,IF(C16=Dropdowns!$C$13,Dropdowns!$B$13,IF(C16=Dropdowns!$C$14,Dropdowns!$B$14,IF(C16=Dropdowns!$C$15,Dropdowns!$B$15,IF(C16=Dropdowns!$C$16,Dropdowns!$B$16,IF(C16=Dropdowns!$C$17,Dropdowns!$B$17,IF(C16=Dropdowns!$C$18,Dropdowns!$B$18,IF(C16=Dropdowns!$C$19,Dropdowns!$B$19,IF(C16=Dropdowns!$C$20,Dropdowns!$B$20,IF(C16=Dropdowns!$C$21,Dropdowns!$B$21,IF(C16=Dropdowns!$C$22,Dropdowns!$B$22,IF(C16=Dropdowns!$C$23,Dropdowns!$B$23,IF(C16=Dropdowns!$C$24,Dropdowns!$B$24,IF(C16=Dropdowns!$C$25,Dropdowns!$B$25,IF(C16=Dropdowns!$C$26,Dropdowns!$B$26,IF(C16=Dropdowns!$C$27,Dropdowns!$B$27,IF(C16=Dropdowns!$C$28,Dropdowns!$B$28,IF(C16=Dropdowns!$C$29,Dropdowns!$B$29,IF(C16=Dropdowns!$C$30,Dropdowns!$B$30,IF(C16=Dropdowns!$C$31,Dropdowns!$B$31,IF(C16=Dropdowns!$C$32,Dropdowns!$B$32,IF(C16=Dropdowns!$C$33,Dropdowns!$B$33,IF(C16=Dropdowns!$C$34,Dropdowns!$B$34,IF(C16=Dropdowns!$C$35,Dropdowns!$B$35,IF(C16=Dropdowns!$C$36,Dropdowns!$B$36,IF(C16=Dropdowns!$C$37,Dropdowns!$B$37,IF(C16=Dropdowns!$C$38,Dropdowns!$B$38,IF(C16=Dropdowns!$C$39,Dropdowns!$B$39,IF(C16=Dropdowns!$C$40,Dropdowns!$B$40,IF(C16=Dropdowns!$C$41,Dropdowns!$B$41,IF(C16=Dropdowns!$C$42,Dropdowns!$B$42,IF(C16=Dropdowns!$C$43,Dropdowns!$B$43,IF(C16=Dropdowns!$C$44,Dropdowns!$B$44,IF(C16=Dropdowns!$C$45,Dropdowns!$B$45,IF(C16=Dropdowns!$C$46,Dropdowns!$B$46,\"0\"))))))))))))))))))))))))))))))))))))))))","v":"0"},{"$f":"IF(F16=Dropdowns!$F$15,Dropdowns!$G$15,IF(F16=Dropdowns!$F$16,Dropdowns!$G$16,IF(F16=Dropdowns!$F$17,Dropdowns!$G$17,\"0\")))","v":"0"}]
[{"$f":"\"Option 2: \"&'Project Options Analysis '!C23","v":"Option 2: "},null,null,null,{"$f":"'Project Options Analysis '!G23","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G17/158475797","v":0},{"$f":"AP17","v":0},{"$f":"AT17","v":0},{"$f":"AV17","v":0},{"$f":"AX17","v":0},{"$f":"AZ17","v":0},{"$f":"BB17","v":0},{"$f":"BD17","v":0},{"$f":"BF17","v":0},{"$f":"IFERROR(RANK(Z17,$Z$16:$Z$19,0),\"\")","v":1},{"$f":"IFERROR(IF(D17=\"Project\",E17/Z17,IF(D17=\"Program\",E17/Z17,\"\")),\"\")","v":""},{"$f":"IFERROR(RANK(AB17,$AB$16:$AB$19,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H17,'Conversion Tables'!$G$8:$N$12,3,FALSE)/'Conversion Tables'!$I$12*Max_Point,0)","v":0},{"$f":"AO17*'Weighting Scale'!$H$10*BG17*BH17","v":0},{"$f":"IFERROR(VLOOKUP(J17,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K17,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"(AQ17-AR17)/'Conversion Tables'!$C$32*Max_Point","v":0},{"$f":"AS17*'Weighting Scale'!$H$11*BG17*BH17","v":0},{"$f":"IFERROR(VLOOKUP(M17,'Conversion Tables'!$G$8:$N$12,2,FALSE)/'Conversion Tables'!$H$12*Max_Point,0)","v":0},{"$f":"AU17*'Weighting Scale'!$H$12*BG17*BH17","v":0},{"$f":"IFERROR(VLOOKUP(N17,'Conversion Tables'!$G$8:$N$12,6,FALSE)/'Conversion Tables'!$L$12*Max_Point,0)","v":0},{"$f":"AW17*'Weighting Scale'!$H$15*BG17*BH17","v":0},{"$f":"IFERROR(VLOOKUP(O17,'Conversion Tables'!$G$8:$N$12,4,FALSE)/'Conversion Tables'!$J$12*Max_Point,0)","v":0},{"$f":"AY17*'Weighting Scale'!$H$13*BG17*BH17","v":0},{"$f":"IFERROR(VLOOKUP(P17,'Conversion Tables'!$G$8:$N$12,7,FALSE)/'Conversion Tables'!$M$12*Max_Point,0)","v":0},{"$f":"BA17*'Weighting Scale'!$H$16*BG17*BH17","v":0},{"$f":"IF(Q17=\"Yes\",('Conversion Tables'!$N$12)/'Conversion Tables'!$N$12*Max_Point,0)","v":0},{"$f":"BC17*'Weighting Scale'!$H$17*BG17*BH17","v":0},{"$f":"AP17+AT17+AV17+AX17+AZ17+BB17+BD17","v":0},{"$f":"BE17*BI17","v":0},{"$f":"R17","v":0},{"$f":"IF(C17=Dropdowns!$C$7,Dropdowns!$B$7,IF(C17=Dropdowns!$C$8,Dropdowns!$B$8,IF(C17=Dropdowns!$C$9,Dropdowns!$B$9,IF(C17=Dropdowns!$C$10,Dropdowns!$B$10,IF(C17=Dropdowns!$C$11,Dropdowns!$B$11,IF(C17=Dropdowns!$C$12,Dropdowns!$B$12,IF(C17=Dropdowns!$C$13,Dropdowns!$B$13,IF(C17=Dropdowns!$C$14,Dropdowns!$B$14,IF(C17=Dropdowns!$C$15,Dropdowns!$B$15,IF(C17=Dropdowns!$C$16,Dropdowns!$B$16,IF(C17=Dropdowns!$C$17,Dropdowns!$B$17,IF(C17=Dropdowns!$C$18,Dropdowns!$B$18,IF(C17=Dropdowns!$C$19,Dropdowns!$B$19,IF(C17=Dropdowns!$C$20,Dropdowns!$B$20,IF(C17=Dropdowns!$C$21,Dropdowns!$B$21,IF(C17=Dropdowns!$C$22,Dropdowns!$B$22,IF(C17=Dropdowns!$C$23,Dropdowns!$B$23,IF(C17=Dropdowns!$C$24,Dropdowns!$B$24,IF(C17=Dropdowns!$C$25,Dropdowns!$B$25,IF(C17=Dropdowns!$C$26,Dropdowns!$B$26,IF(C17=Dropdowns!$C$27,Dropdowns!$B$27,IF(C17=Dropdowns!$C$28,Dropdowns!$B$28,IF(C17=Dropdowns!$C$29,Dropdowns!$B$29,IF(C17=Dropdowns!$C$30,Dropdowns!$B$30,IF(C17=Dropdowns!$C$31,Dropdowns!$B$31,IF(C17=Dropdowns!$C$32,Dropdowns!$B$32,IF(C17=Dropdowns!$C$33,Dropdowns!$B$33,IF(C17=Dropdowns!$C$34,Dropdowns!$B$34,IF(C17=Dropdowns!$C$35,Dropdowns!$B$35,IF(C17=Dropdowns!$C$36,Dropdowns!$B$36,IF(C17=Dropdowns!$C$37,Dropdowns!$B$37,IF(C17=Dropdowns!$C$38,Dropdowns!$B$38,IF(C17=Dropdowns!$C$39,Dropdowns!$B$39,IF(C17=Dropdowns!$C$40,Dropdowns!$B$40,IF(C17=Dropdowns!$C$41,Dropdowns!$B$41,IF(C17=Dropdowns!$C$42,Dropdowns!$B$42,IF(C17=Dropdowns!$C$43,Dropdowns!$B$43,IF(C17=Dropdowns!$C$44,Dropdowns!$B$44,IF(C17=Dropdowns!$C$45,Dropdowns!$B$45,IF(C17=Dropdowns!$C$46,Dropdowns!$B$46,\"0\"))))))))))))))))))))))))))))))))))))))))","v":"0"},{"$f":"IF(F17=Dropdowns!$F$15,Dropdowns!$G$15,IF(F17=Dropdowns!$F$16,Dropdowns!$G$16,IF(F17=Dropdowns!$F$17,Dropdowns!$G$17,\"0\")))","v":"0"}]
[{"$f":"\"Option 3 : \"&'Project Options Analysis '!C24","v":"Option 3 : "},null,null,null,{"$f":"'Project Options Analysis '!G24","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AP18","v":0},{"$f":"AT18","v":0},{"$f":"AV18","v":0},{"$f":"AX18","v":0},{"$f":"AZ18","v":0},{"$f":"BB18","v":0},{"$f":"BD18","v":0},{"$f":"BF18","v":0},{"$f":"IFERROR(RANK(Z18,$Z$16:$Z$19,0),\"\")","v":1},{"$f":"IFERROR(IF(D18=\"Project\",E18/Z18,IF(D18=\"Program\",E18/Z18,\"\")),\"\")","v":""},{"$f":"IFERROR(RANK(AB18,$AB$16:$AB$19,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H18,'Conversion Tables'!$G$8:$N$12,3,FALSE)/'Conversion Tables'!$I$12*Max_Point,0)","v":0},{"$f":"AO18*'Weighting Scale'!$H$10*BG18*BH18","v":0},{"$f":"IFERROR(VLOOKUP(J18,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K18,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"(AQ18-AR18)/'Conversion Tables'!$C$32*Max_Point","v":0},{"$f":"AS18*'Weighting Scale'!$H$11*BG18*BH18","v":0},{"$f":"IFERROR(VLOOKUP(M18,'Conversion Tables'!$G$8:$N$12,2,FALSE)/'Conversion Tables'!$H$12*Max_Point,0)","v":0},{"$f":"AU18*'Weighting Scale'!$H$12*BG18*BH18","v":0},{"$f":"IFERROR(VLOOKUP(N18,'Conversion Tables'!$G$8:$N$12,6,FALSE)/'Conversion Tables'!$L$12*Max_Point,0)","v":0},{"$f":"AW18*'Weighting Scale'!$H$15*BG18*BH18","v":0},{"$f":"IFERROR(VLOOKUP(O18,'Conversion Tables'!$G$8:$N$12,4,FALSE)/'Conversion Tables'!$J$12*Max_Point,0)","v":0},{"$f":"AY18*'Weighting Scale'!$H$13*BG18*BH18","v":0},{"$f":"IFERROR(VLOOKUP(P18,'Conversion Tables'!$G$8:$N$12,7,FALSE)/'Conversion Tables'!$M$12*Max_Point,0)","v":0},{"$f":"BA18*'Weighting Scale'!$H$16*BG18*BH18","v":0},{"$f":"IF(Q18=\"Yes\",('Conversion Tables'!$N$12)/'Conversion Tables'!$N$12*Max_Point,0)","v":0},{"$f":"BC18*'Weighting Scale'!$H$17*BG18*BH18","v":0},0,0,0,{"$f":"IF(C18=Dropdowns!$C$7,Dropdowns!$B$7,IF(C18=Dropdowns!$C$8,Dropdowns!$B$8,IF(C18=Dropdowns!$C$9,Dropdowns!$B$9,IF(C18=Dropdowns!$C$10,Dropdowns!$B$10,IF(C18=Dropdowns!$C$11,Dropdowns!$B$11,IF(C18=Dropdowns!$C$12,Dropdowns!$B$12,IF(C18=Dropdowns!$C$13,Dropdowns!$B$13,IF(C18=Dropdowns!$C$14,Dropdowns!$B$14,IF(C18=Dropdowns!$C$15,Dropdowns!$B$15,IF(C18=Dropdowns!$C$16,Dropdowns!$B$16,IF(C18=Dropdowns!$C$17,Dropdowns!$B$17,IF(C18=Dropdowns!$C$18,Dropdowns!$B$18,IF(C18=Dropdowns!$C$19,Dropdowns!$B$19,IF(C18=Dropdowns!$C$20,Dropdowns!$B$20,IF(C18=Dropdowns!$C$21,Dropdowns!$B$21,IF(C18=Dropdowns!$C$22,Dropdowns!$B$22,IF(C18=Dropdowns!$C$23,Dropdowns!$B$23,IF(C18=Dropdowns!$C$24,Dropdowns!$B$24,IF(C18=Dropdowns!$C$25,Dropdowns!$B$25,IF(C18=Dropdowns!$C$26,Dropdowns!$B$26,IF(C18=Dropdowns!$C$27,Dropdowns!$B$27,IF(C18=Dropdowns!$C$28,Dropdowns!$B$28,IF(C18=Dropdowns!$C$29,Dropdowns!$B$29,IF(C18=Dropdowns!$C$30,Dropdowns!$B$30,IF(C18=Dropdowns!$C$31,Dropdowns!$B$31,IF(C18=Dropdowns!$C$32,Dropdowns!$B$32,IF(C18=Dropdowns!$C$33,Dropdowns!$B$33,IF(C18=Dropdowns!$C$34,Dropdowns!$B$34,IF(C18=Dropdowns!$C$35,Dropdowns!$B$35,IF(C18=Dropdowns!$C$36,Dropdowns!$B$36,IF(C18=Dropdowns!$C$37,Dropdowns!$B$37,IF(C18=Dropdowns!$C$38,Dropdowns!$B$38,IF(C18=Dropdowns!$C$39,Dropdowns!$B$39,IF(C18=Dropdowns!$C$40,Dropdowns!$B$40,IF(C18=Dropdowns!$C$41,Dropdowns!$B$41,IF(C18=Dropdowns!$C$42,Dropdowns!$B$42,IF(C18=Dropdowns!$C$43,Dropdowns!$B$43,IF(C18=Dropdowns!$C$44,Dropdowns!$B$44,IF(C18=Dropdowns!$C$45,Dropdowns!$B$45,IF(C18=Dropdowns!$C$46,Dropdowns!$B$46,\"0\"))))))))))))))))))))))))))))))))))))))))","v":"0"},{"$f":"IF(F18=Dropdowns!$F$15,Dropdowns!$G$15,IF(F18=Dropdowns!$F$16,Dropdowns!$G$16,IF(F18=Dropdowns!$F$17,Dropdowns!$G$17,\"0\")))","v":"0"}]
[{"$f":"\"Option 4: \"&'Project Options Analysis '!C25","v":"Option 4: "},null,null,null,{"$f":"'Project Options Analysis '!G25","v":""},null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AP19","v":0},{"$f":"AT19","v":0},{"$f":"AV19","v":0},{"$f":"AX19","v":0},{"$f":"AZ19","v":0},{"$f":"BB19","v":0},{"$f":"BD19","v":0},{"$f":"BF19","v":0},{"$f":"IFERROR(RANK(Z19,$Z$16:$Z$19,0),\"\")","v":1},{"$f":"IFERROR(IF(D19=\"Project\",E19/Z19,IF(D19=\"Program\",E19/Z19,\"\")),\"\")","v":""},{"$f":"IFERROR(RANK(AB19,$AB$16:$AB$19,1),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H19,'Conversion Tables'!$G$8:$N$12,3,FALSE)/'Conversion Tables'!$I$12*Max_Point,0)","v":0},{"$f":"AO19*'Weighting Scale'!$H$10*BG19*BH19","v":0},{"$f":"IFERROR(VLOOKUP(J19,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(K19,'Conversion Tables'!$B$8:$C$32,2,FALSE),0)","v":0},{"$f":"(AQ19-AR19)/'Conversion Tables'!$C$32*Max_Point","v":0},{"$f":"AS19*'Weighting Scale'!$H$11*BG19*BH19","v":0},{"$f":"IFERROR(VLOOKUP(M19,'Conversion Tables'!$G$8:$N$12,2,FALSE)/'Conversion Tables'!$H$12*Max_Point,0)","v":0},{"$f":"AU19*'Weighting Scale'!$H$12*BG19*BH19","v":0},{"$f":"IFERROR(VLOOKUP(N19,'Conversion Tables'!$G$8:$N$12,6,FALSE)/'Conversion Tables'!$L$12*Max_Point,0)","v":0},{"$f":"AW19*'Weighting Scale'!$H$15*BG19*BH19","v":0},{"$f":"IFERROR(VLOOKUP(O19,'Conversion Tables'!$G$8:$N$12,4,FALSE)/'Conversion Tables'!$J$12*Max_Point,0)","v":0},{"$f":"AY19*'Weighting Scale'!$H$13*BG19*BH19","v":0},{"$f":"IFERROR(VLOOKUP(P19,'Conversion Tables'!$G$8:$N$12,7,FALSE)/'Conversion Tables'!$M$12*Max_Point,0)","v":0},{"$f":"BA19*'Weighting Scale'!$H$16*BG19*BH19","v":0},{"$f":"IF(Q19=\"Yes\",('Conversion Tables'!$N$12)/'Conversion Tables'!$N$12*Max_Point,0)","v":0},{"$f":"BC19*'Weighting Scale'!$H$17*BG19*BH19","v":0},0,0,0,{"$f":"IF(C19=Dropdowns!$C$7,Dropdowns!$B$7,IF(C19=Dropdowns!$C$8,Dropdowns!$B$8,IF(C19=Dropdowns!$C$9,Dropdowns!$B$9,IF(C19=Dropdowns!$C$10,Dropdowns!$B$10,IF(C19=Dropdowns!$C$11,Dropdowns!$B$11,IF(C19=Dropdowns!$C$12,Dropdowns!$B$12,IF(C19=Dropdowns!$C$13,Dropdowns!$B$13,IF(C19=Dropdowns!$C$14,Dropdowns!$B$14,IF(C19=Dropdowns!$C$15,Dropdowns!$B$15,IF(C19=Dropdowns!$C$16,Dropdowns!$B$16,IF(C19=Dropdowns!$C$17,Dropdowns!$B$17,IF(C19=Dropdowns!$C$18,Dropdowns!$B$18,IF(C19=Dropdowns!$C$19,Dropdowns!$B$19,IF(C19=Dropdowns!$C$20,Dropdowns!$B$20,IF(C19=Dropdowns!$C$21,Dropdowns!$B$21,IF(C19=Dropdowns!$C$22,Dropdowns!$B$22,IF(C19=Dropdowns!$C$23,Dropdowns!$B$23,IF(C19=Dropdowns!$C$24,Dropdowns!$B$24,IF(C19=Dropdowns!$C$25,Dropdowns!$B$25,IF(C19=Dropdowns!$C$26,Dropdowns!$B$26,IF(C19=Dropdowns!$C$27,Dropdowns!$B$27,IF(C19=Dropdowns!$C$28,Dropdowns!$B$28,IF(C19=Dropdowns!$C$29,Dropdowns!$B$29,IF(C19=Dropdowns!$C$30,Dropdowns!$B$30,IF(C19=Dropdowns!$C$31,Dropdowns!$B$31,IF(C19=Dropdowns!$C$32,Dropdowns!$B$32,IF(C19=Dropdowns!$C$33,Dropdowns!$B$33,IF(C19=Dropdowns!$C$34,Dropdowns!$B$34,IF(C19=Dropdowns!$C$35,Dropdowns!$B$35,IF(C19=Dropdowns!$C$36,Dropdowns!$B$36,IF(C19=Dropdowns!$C$37,Dropdowns!$B$37,IF(C19=Dropdowns!$C$38,Dropdowns!$B$38,IF(C19=Dropdowns!$C$39,Dropdowns!$B$39,IF(C19=Dropdowns!$C$40,Dropdowns!$B$40,IF(C19=Dropdowns!$C$41,Dropdowns!$B$41,IF(C19=Dropdowns!$C$42,Dropdowns!$B$42,IF(C19=Dropdowns!$C$43,Dropdowns!$B$43,IF(C19=Dropdowns!$C$44,Dropdowns!$B$44,IF(C19=Dropdowns!$C$45,Dropdowns!$B$45,IF(C19=Dropdowns!$C$46,Dropdowns!$B$46,\"0\"))))))))))))))))))))))))))))))))))))))))","v":"0"},{"$f":"IF(F19=Dropdowns!$F$15,Dropdowns!$G$15,IF(F19=Dropdowns!$F$16,Dropdowns!$G$16,IF(F19=Dropdowns!$F$17,Dropdowns!$G$17,\"0\")))","v":"0"}]

{"sheet":"Conversion Tables","index":8,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[[5,13,6,13],[4,6,4,13],[4,15,4,16],[5,1,6,1],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12]]}
["City of Winnipeg"]
["Net Present Value Template"]
["Conversion Tables"]
[]
[null,"Maintain LOS Benefits",null,null,null,null,"Other Benefits",null,null,null,null,null,null,null,null,"Residual Risk"]
[null,"Score","Maintain LOS",null,null,null,"Score","Enhance LOS","New Regulation","Enable Growth","Economy","Environment","Operational Efficiency","Culture/ Heritage",null,"Rating","Score"]
[null,null,"Essential","Quality","Image",null,null,null,null,null,null,null,null,null,null,"VLVL",1]
[null,"VLVL",1,1,1,null,"VL",1,1,1,1,1,1,1,null,"VLL",3]
[null,"VLL",3,3,3,null,"L",3,3,3,3,3,3,3,null,"VLM",10]
[null,"VLM",10,10,10,null,"M",10,10,10,10,10,10,10,null,"VLH",30]
[null,"VLH",30,30,30,null,"H",30,30,30,30,30,30,30,null,"VLVH",100]
[null,"VLVH",100,100,100,null,"VH",100,100,100,100,100,100,100,null,"LVL",3]
[null,"LVL",3,3,3,null,null,null,null,null,null,null,null,null,null,"LL",9]
[null,"LL",9,9,9,null,null,null,null,null,null,null,null,null,null,"LM",30]
[null,"LM",30,30,30,null,null,null,null,null,null,null,null,null,null,"LH",90]
[null,"LH",90,90,90,null,null,null,null,null,null,null,null,null,null,"LVH",300]
[null,"LVH",300,300,300,null,null,null,null,null,null,null,null,null,null,"MVL",10]
[null,"MVL",10,10,10,null,null,null,null,null,null,null,null,null,null,"ML",30]
[null,"ML",30,30,30,null,null,null,null,null,null,null,null,null,null,"MM",100]
[null,"MM",100,100,100,null,null,null,null,null,null,null,null,null,null,"MH",300]
[null,"MH",300,300,300,null,null,null,null,null,null,null,null,null,null,"MVH",1000]
[null,"MVH",1000,1000,1000,null,null,null,null,null,null,null,null,null,null,"HVL",30]
[null,"HVL",30,30,30,null,null,null,null,null,null,null,null,null,null,"HL",90]
[null,"HL",90,90,90,null,null,null,null,null,null,null,null,null,null,"HM",300]
[null,"HM",300,300,300,null,null,null,null,null,null,null,null,null,null,"HH",900]
[null,"HH",900,900,900,null,null,null,null,null,null,null,null,null,null,"HVH",3000]
[null,"HVH",3000,3000,3000,null,null,null,null,null,null,null,null,null,null,"VHVL",100]
[null,"VHVL",100,100,100,null,null,null,null,null,null,null,null,null,null,"VHL",300]
[null,"VHL",300,300,300,null,null,null,null,null,null,null,null,null,null,"VHM",1000]
[null,"VHM",1000,1000,1000,null,null,null,null,null,null,null,null,null,null,"VHH",3000]
[null,"VHH",3000,3000,3000,null,null,null,null,null,null,null,null,null,null,"VHVH",10000]
[null,"VHVH",10000,10000,10000,null,null,null,null,null,null,null,null,null,null,"\"\"",0]

{"sheet":"Dropdowns","index":9,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["City of Winnipeg"]
["Net Present Value Template"]
["Dropdown Menus"]
[]
[null,"BASE 3"]
["Select from list","Base3","Select from list",null,null,"Select from list"]
["Assessment & Taxation",441,"Active Transportation",null,null,"Project"]
["Assets and Project Management",143,"Animal Services (SOA)",null,null,"Program"]
["Audit",10,"Arts, Entertainment & Culture",null,null,null,null,null,"Select from list",null,null,null,null,null,"Matrix","Scale"]
["Chief Administrative Offices",441,"Assessment, Taxation and Corporate",null,null,"Select from list",null,null,"Maintain LOS",null,null,"Quality",null,null,"VLVL","VL"]
["Chief Financial Officer",441,"Bridges - Local",null,null,"Yes",null,null,null,null,null,"Reliability",null,null,"VLL","L"]
["City Clerks",664,"Bridges - Regional",null,null,"No",null,null,null,null,null,"Condition",null,null,"VLM","M"]
["Community Services",10,"Cemeteries",null,null,null,null,null,null,null,null,null,null,null,"VLH","H"]
["Corporate Finance",143,"City Beautification",null,null,"Service Impact",null,null,"Enhance LOS",null,null,"Quality",null,null,"VLVH","VH"]
["Customer Service and Communications",441,"City Planning",null,null,"Direct",1,null,null,null,null,"Reliability",null,null,"LVL"]
["Emergency Preparedness Program",441,"Community Liveability",null,null,"Indirect",0.5,null,null,null,null,null,null,null,"LL"]
["Employee Benefits",441,"Contact Centre - 311",null,null,"Supplemental/Support",0.1,null,null,null,null,null,null,null,"LM"]
["Fire Paramedic Service",441,"Development Approvals, Building Permits & Inspections",null,null,null,null,null,null,null,null,null,null,null,"LH"]
["Innovation and Technology",143,"Economic Development",null,null,"Select from List",null,null,null,null,null,null,null,null,"LVH"]
["Legal Services",903,"Emergency Management",null,null,1,null,null,null,null,null,null,null,null,"MVL"]
["Mayor's Office",903,"Fire & Injury Prevention",null,null,2,null,null,null,null,null,null,null,null,"ML"]
["Planning, Property, and Development",903,"Fire & Rescue Response",null,null,3,null,null,null,null,null,null,null,null,"MM"]
["Public Works",10,"Golf Services (SOA)",null,null,4,null,null,null,null,null,null,null,null,"MH"]
["Water and Waste",10,"Heritage Conservation",null,null,5,null,null,null,null,null,null,null,null,"MVH"]
["Winnipeg Police Service",143,"Insect Control",null,null,null,null,null,null,null,null,null,null,null,"HVL"]
["Winnipeg Transit",664,"Land Drainage & Flood Control",null,null,"Select from list",null,null,null,null,null,null,null,null,"HL"]
[null,143,"Libraries",null,null,"Funded",null,null,null,null,null,null,null,null,"HM"]
[null,903,"Medical Response",null,null,"Unfunded",null,null,null,null,null,null,null,null,"HH"]
[null,664,"Multiple Organizational Support Services",null,null,null,null,null,null,null,null,null,null,null,"HVH"]
[null,143,"Neighborhood Revitalization",null,null,null,null,null,null,null,null,null,null,null,"VHVL"]
[null,143,"Parking (SOA)",null,null,null,null,null,null,null,null,null,null,null,"VHL"]
[null,143,"Parks - Local",null,null,null,null,null,null,null,null,null,null,null,"VHM"]
[null,441,"Parks - Regional",null,null,null,null,null,null,null,null,null,null,null,"VHH"]
[null,903,"Police Response/Crime Prevention",null,null,null,null,null,null,null,null,null,null,null,"VHVH"]
[null,441,"Property Asset Management"]
[null,664,"Public Transit"]
[null,143,"Recreation"]
[null,143,"Recycling & Waste Diversion"]
[null,441,"Roads - Local"]
[null,664,"Roads - Regional"]
[null,664,"Solid Waste Collection"]
[null,664,"Solid Waste Disposal"]
[null,441,"Transportation Planning and Traffic Management"]
[null,441,"Urban Forestry"]
[null,1000,"Wastewater"]
[null,1000,"Water"]
["NPV OPTION TABS"]
[]
["Capex Categories"]
["Pre-Construction"]
["Construction"]
["Decommission"]
["Equipment"]
["Interest Charges"]
["Capex Benefit"]
[]
["Opex Categories"]
["Operate"]
["Maintain"]
["Salaries & Benefits"]
["Debt & Financing Charges"]
["Opex Benefit"]
[]
["STATUS QUO TAB"]
[]
["Opex Categories"]
["Operate"]
["Maintain"]
["Salaries & Benefits"]

{"sheet":"Weighting Scale","index":10,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":true,"merged":[[8,0,8,1],[5,12,5,14]]}
["City of Winnipeg"]
["Net Present Value Template"]
["Weightnig Criteria"]
[]
[null,null,"Multiplying Factor (f) - Original",2469]
[null,null,"Multiplying Factor (f) - Modified",10000,"Refered to as Max_Point in formulas",null,null,null,null,null,null,null,"Exponential Distribution w/ Usage and Importance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Factor (f)",10000]
[]
[null,null,null,null,null,null,"Modified (Adjustments - 2020 Budget Cycle)",null,null,null,null,null,"Weight",0.31]
[null,null,null,null,null,null,"New Regulation",0.31,0.30999999999999994,null,null,null,"New Regulation",null,3100000]
[null,null,null,null,null,null,"Maintain LOS",0.31,0.30999999999999994,null,null,null,null,"f=1",310]
[null,null,null,null,null,null,"Enhance Level of Service",7.0000000000000007E-2,6.9999999999999993E-2,null,null,null,"Weight",0.31]
[null,null,null,null,null,null,"Growth",7.0000000000000007E-2,6.9999999999999993E-2,null,null,null,"Maintain LOS",null,3099690]
[null,null,null,null,null,null,"Economy",7.0000000000000007E-2,6.9999999999999993E-2,null,null,null,null,"f=1",309.96899999999999,null,null,null,"MAX"]
[null,null,null,null,null,null,"Environmental",7.0000000000000007E-2,6.9999999999999993E-2,null,null,null,"Weight",7.0000000000000007E-2,null,null,"Usage Multiplier",null,1]
[null,null,null,null,null,null,"Operational Efficiency",7.0000000000000007E-2,6.9999999999999993E-2,null,null,null,"Enhance LOS",null,700000.00000000012,null,"Importance Multiplier",null,1000]
[null,null,null,null,null,null,"Culture/Heritage",0.03,2.9999999999999992E-2,null,null,null,null,"f=1",70]
[null,null,null,null,null,null,null,1.0000000000000002,0.99999999999999967,null,null,null,"Weight",7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Environment",null,700000.00000000012]
[null,null,null,null,null,null,null,"Multiplier",null,null,null,null,null,"f=1",70]
[null,null,null,null,null,null,"Score","Usage","Importance",null,null,null,"Weight",7.0000000000000007E-2]
[null,null,null,null,null,null,"VL",1,1,null,null,null,"Enable Growth",null,700000.00000000012]
[null,null,null,null,null,null,"L",3,3,null,null,null,null,"f=1",70]
[null,null,null,null,null,null,"M",10,10,null,null,null,"Weight",7.0000000000000007E-2]
[null,null,null,null,null,null,"H",30,30,null,null,null,"Economy",null,700000.00000000012]
[null,null,null,null,null,null,"VH",100,100,null,null,null,null,"f=1",70]
[null,null,null,null,null,null,"Max Scale (Factor of 10)",100,0,null,null,null,"Weight",7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oper. Efficiency",null,700000.00000000012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"f=1",70]
[null,null,null,null,null,null,null,null,null,null,null,null,"Weight",0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,"Culture/Heritage",null,300000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"f=1",30]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Benefit",9999690]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor check",10000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"New Factor",10000.310009610297]