{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Proj Category & Fin Sources","Sample","Template"],"not_rendered":{"external_links":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":36,"n_cols":2,"rows_kept":36}
[]
[null,"LONG-TERM CAPITAL PROJECTIONS TEMPLATE INSTRUCTIONS"]
[]
[]
["Project Table"]
[1,"Type the department name into the yellow cell below; the department name will automatically be copied to the Template tab."]
[null,"Department Name"]
[2,"Project Name and Description - Enter the project name and a brief description of the project.  Adjust row heights as required."]
[3,"Project Category - Select the appropriate category from the drop down list.  "]
[4,"Enter the total amount (in 000's) requested for each year."]
[5,"Financing detail - Enter reference to financing table below including percentage breakdown if less than 100% to a single financing source."]
[6,"Notes - Enter reference to notes section below and include any additional information that may be important to decision makers."]
[7,"Delete any unused rows."]
[8,"Sort projects by project category."]
[9,"Add subtotals by Project Category for each year."]
[10,"Ensure that the totals add up correctly."]
[]
["Proposed Financing Sources Table"]
[1,"Select the appropriate financing from the drop down list."]
[2,"Enter the total of each financing source for all projects for each year."]
[3,"Verify that total financing equals the total for all projects."]
[]
["Notes"]
[1,"Input any relevant notes for specific projects."]
[]
[]
["Printing"]
[1,"Print setups have been set up for each tab, minimal change should be required.  Pages will print in black and white so yellow data entry cells are not highlighted."]
[2,"To print correct page numbers for the budget submission, group the pages that require printing and under file/page setup/page/first page number, type the appropriate starting page number."]
[]
["Questions"]
[null,"Please call your Financial Planning & Review Analyst with any questions related to this template."]
[null,"Grant Heather - 204-986-4325"]
[null,"Knight Morton - 204-986-2283"]
[null,"Ryan Marsh - 204-986-7525"]
[null,"Kerry Zakowich - 204-986-2128"]

{"sheet":"Proj Category & Fin Sources","index":1,"n_rows":38,"n_cols":2,"rows_kept":38}
["Project Categories","Financing Sources"]
[]
["Active Transportation Facilities","Building Manitoba Fund"]
["Assessment and Taxation","Canada Strategic Infrastructure Fund"]
["Assiniboine Park","Cash to Capital "]
["Building Communities","Debt"]
["Buses","Developers"]
["City Clerks","Economic Development Reserve"]
["Community Incentive Grant Program","Environmental Projects Reserve"]
["Corporate Support Services","Federal Gas Tax"]
["Fire Paramedic Service","Federal Government Funding "]
["Garbage Collection","Frontage Levy "]
["Land Drainage and Flood Control","General Purpose  Reserve (Repayment) "]
["Libraries","Golf Course Reserve"]
["Local Improvements","Interim Financing (Repayment)"]
["Municipal Accommodations","Land Operating Reserve"]
["New Transportation Facilities","Local Street Renewal Reserve"]
["Other","Regional Street Renewal Reserve"]
["Other Streets Projects","Manitoba Winnipeg Infrastructure Program"]
["Parks and Open Space","Manitoba Winnipeg Infrastructure Agreement (MWIA)"]
["Rapid Transit","Prior Years' Surplus/Authorization"]
["Recreation","Provincial Funding for Road Improvements"]
["Regional and Local Streets","Provincial Government Funding"]
["Riverbanks","Public Private Partnership Authorization"]
["Sewage Disposal - Collection","Public Private Partnership Lease Payments"]
["Sewage Disposal - Treatment","Southwest Rapid Transit Corridor - Stage 2 Reserve (formerly Rapid Transit Infrastructure Reserve)"]
["Solid Waste Disposal System - Landfill","Riverbank Management Committee Fund (Fund 002)"]
["Solid Waste Disposal System - Collection","Sewer System Rehabilitation Reserve"]
["Street Improvements","Transit Bus Replacement Reserve"]
["Waterway Crossings and Grade Separations","Transit Retained Earnings"]
["Waterworks - Supply and Treatment","Utilities Retained Earnings"]
["Waterworks - Distribution","Veterans Affairs Canada"]
["Winnipeg Police Service","Waste Diversion Reserve"]
["Winnipeg Golf Services","Watermain Renewal Reserve"]
["Winnipeg Animal Services","Select financing source from drop down list"]
["Winnipeg Parking Authority"]
["Winnipeg Fleet Management"]
["Select category from drop down list"]

{"sheet":"Sample","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"merged":[[3,3,3,7],[4,0,4,1],[13,3,13,7],[14,0,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
["Long Term Capital Projections"]
[]
[null,"Department:","Template Department"]
[{"$nulls":3},"In $000's"]
["Project Name and Description",null,"Project Category",2022,{"$f":"D5+1","v":2023},{"$f":"E5+1","v":2024},{"$f":"F5+1","v":2025},"Total","Financing Detail","Note"]
[1,"Replace roof at West End library (2022) and Transcona library (2024).","Libraries",{"v":1000,"d":"1,000"},null,{"v":1200,"d":"1,200"},null,{"$f":"SUM(D6:G6)","v":{"v":2200,"d":"2,200"}},"50% - 1, 50% - 2",1]
[2,"Replace furniture at various library branches.","Libraries",100,{"v":1300,"d":"1,300"},100,{"v":1300,"d":"1,300"},{"$f":"SUM(D7:G7)","v":{"v":2800,"d":"2,800"}},1]
[null,"Subtotal - Libraries",null,{"$f":"SUBTOTAL(9,D6:D7)","v":{"v":1100,"d":"1,100"}},{"$f":"SUBTOTAL(9,E6:E7)","v":{"v":1300,"d":"1,300"}},{"$f":"SUBTOTAL(9,F6:F7)","v":{"v":1300,"d":"1,300"}},{"$f":"SUBTOTAL(9,G6:G7)","v":{"v":1300,"d":"1,300"}},{"$f":"SUM(D8:G8)","v":{"v":5000,"d":"5,000"}}]
[3,"Software upgrade - implement phase two of Management Information System.","Other",200,{"$nulls":3},{"$f":"SUM(D9:G9)","v":200},1,2]
[null,"Subtotal - Other",null,{"$f":"SUBTOTAL(9,D9:D9)","v":200},{"$f":"SUBTOTAL(9,E9:E9)","v":0},{"$f":"SUBTOTAL(9,F9:F9)","v":0},{"$f":"SUBTOTAL(9,G9:G9)","v":0},{"$f":"SUM(D10:G10)","v":200}]
[]
[null,"Total",null,{"$f":"+D8+D10","v":{"v":1300,"d":"1,300"}},{"$f":"+E8+E10","v":{"v":1300,"d":"1,300"}},{"$f":"+F8+F10","v":{"v":1300,"d":"1,300"}},{"$f":"+G8+G10","v":{"v":1300,"d":"1,300"}},{"$f":"+H8+H10","v":{"v":5200,"d":"5,200"}}]
[]
[{"$nulls":3},"In $000's"]
["Proposed Financing Sources",null,null,{"$f":"+D5","v":2022},{"$f":"D15+1","v":2023},{"$f":"E15+1","v":2024},{"$f":"F15+1","v":2025},"Total"]
[1,"Cash to Capital ",null,800,{"v":1300,"d":"1,300"},700,{"v":1300,"d":"1,300"},{"$f":"SUM(D16:G16)","v":{"v":4100,"d":"4,100"}}]
[2,"Provincial Government Funding",null,500,null,600,null,{"v":1100,"d":"1,100"}]
[3,{"$nulls":6},0]
[4,{"$nulls":6},0]
[5,{"$nulls":6},0]
[6,{"$nulls":6},0]
[7,{"$nulls":6},0]
[8,{"$nulls":6},0]
[9,{"$nulls":6},0]
[10]
[null,"Total",null,{"$f":"SUM(D16:D25)","v":{"v":1300,"d":"1,300"}},{"$f":"SUM(E16:E25)","v":{"v":1300,"d":"1,300"}},{"$f":"SUM(F16:F25)","v":{"v":1300,"d":"1,300"}},{"$f":"SUM(G16:G25)","v":{"v":1300,"d":"1,300"}},{"$f":"SUM(H16:H25)","v":{"v":5200,"d":"5,200"}}]
[]
["Notes"]
[1,"Note related to project 1"]
[2,"Note related to project 3"]

{"sheet":"Template","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[3,3,3,7],[4,0,4,1],[21,1,21,2],[23,3,23,7],[24,0,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[38,1,38,9],[39,1,39,9],[40,1,40,9],[41,1,41,9],[42,1,42,9],[43,1,43,9],[44,1,44,9],[45,1,45,9],[46,1,46,9],[47,1,47,9],[48,1,48,9]]}
["Long Term Capital Projections"]
[]
[null,"Department:",{"$f":"+Instructions!B7","v":"Department Name"}]
[{"$nulls":3},"In $000's"]
["Project Name and Description",null,"Project Category",{"$f":"Sample!D5","v":2022},{"$f":"Sample!E5","v":2023},{"$f":"Sample!F5","v":2024},{"$f":"Sample!G5","v":2025},"Total","Financing Detail","Note"]
[1,"Project 1","Select category from drop down list",{"$nulls":4},{"$f":"SUM(D6:G6)","v":0}]
[2,"Project 2","Select category from drop down list",{"$nulls":4},{"$f":"SUM(D7:G7)","v":0}]
[3,"Project 3","Select category from drop down list",{"$nulls":4},0]
[4,"Project 4","Select category from drop down list",{"$nulls":4},0]
[5,"Project 5","Select category from drop down list",{"$nulls":4},0]
[6,"Project 6","Select category from drop down list",{"$nulls":4},0]
[7,"Project 7","Select category from drop down list",{"$nulls":4},0]
[8,"Project 8","Select category from drop down list",{"$nulls":4},0]
[9,"Project 9","Select category from drop down list",{"$nulls":4},0]
[10,"Project 10","Select category from drop down list",{"$nulls":4},0]
[11,"Project 11","Select category from drop down list",{"$nulls":4},0]
[12,"Project 12","Select category from drop down list",{"$nulls":4},0]
[13,"Project 13","Select category from drop down list",{"$nulls":4},0]
[14,"Project 14","Select category from drop down list",{"$nulls":4},0]
[15,"Project 15","Select category from drop down list",{"$nulls":4},0]
[{"$nulls":7},{"$f":"SUM(D21:G21)","v":0}]
[null,"Total",null,{"$f":"SUM(D6:D21)","v":0},{"$f":"SUM(E6:E21)","v":0},{"$f":"SUM(F6:F21)","v":0},{"$f":"SUM(G6:G21)","v":0},{"$f":"SUM(H6:H21)","v":0}]
[]
[{"$nulls":3},"In $000's"]
["Proposed Financing Sources",null,null,{"$f":"Sample!D15","v":2022},{"$f":"Sample!E15","v":2023},{"$f":"Sample!F15","v":2024},{"$f":"Sample!G15","v":2025},"Total"]
[1,"Select financing source from drop down list",{"$nulls":5},{"$f":"SUM(D26:G26)","v":0}]
[2,"Select financing source from drop down list",{"$nulls":5},0]
[3,"Select financing source from drop down list",{"$nulls":5},0]
[4,"Select financing source from drop down list",{"$nulls":5},0]
[5,"Select financing source from drop down list",{"$nulls":5},0]
[6,"Select financing source from drop down list",{"$nulls":5},0]
[7,"Select financing source from drop down list",{"$nulls":5},0]
[8,"Select financing source from drop down list",{"$nulls":5},0]
[9,"Select financing source from drop down list",{"$nulls":5},0]
[10,"Select financing source from drop down list",{"$nulls":5},0]
[null,"Total",null,{"$f":"SUM(D26:D35)","v":0},{"$f":"SUM(E26:E35)","v":0},{"$f":"SUM(F26:F35)","v":0},{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(H26:H35)","v":0}]
[]
["Notes"]