{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["instructions","OurWinnipeg","service list and class estimate","authorization","cash flow","net impact","project 1","project 2","project 3","project 4","project 5","project 6","project 7","project 8","project 9","project 10","project 11","project 12","project 13","project 14","project 15"],"not_rendered":{"images":3,"external_links":2,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"instructions","index":0,"n_rows":82,"n_cols":4,"rows_kept":82,"merged":[[1,0,1,3],[3,0,3,3],[4,0,4,3],[7,2,7,3],[9,2,9,3],[11,2,11,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[21,0,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[29,0,29,3],[31,0,31,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[37,2,37,3],[38,2,38,3],[40,1,40,3],[41,2,41,3],[42,1,42,3],[43,2,43,3],[45,2,45,3],[47,2,47,3],[49,2,49,3],[50,2,50,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[66,2,66,3],[69,2,69,3],[70,2,70,3]]}
["CAPITAL PROJECTS DETAIL TEMPLATE INSTRUCTIONS"]
["PLEASE DO NOT MAKE ANY FORMATTING CHANGES, AS THIS FILE WILL BE PRINTED OUT AND USED FOR THE \"CAPITAL PROJECT DETAIL\" IN THE BUDGET BOOK."]
[]
["This Excel template creates a standard format for capital information to be submitted as part of your Budget Submission."]
["Refer to the Financial Guidelines in the Call Letter for additional information."]
[]
["GENERAL:"]
[null,"u","Type the department and fund names into the yellow cell below, the department and fund names will automatically be copied to all other tabs."]
[null,null,"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"]
[null,"u","Type the commencement year for the Capital Budget into the yellow cell below, the year in the column headers on all pages will automatically update."]
[null,null,"CAPITAL BUDGET FOR YEAR COMMENCING ",2016]
[null,"u","Type the Budget Status into the yellow cell below, the status of the appropriate cells on all pages will automatically update."]
[null,null,"CAPITAL BUDGET STATUS ","Estimate"]
[null,{"$f":"+$B$8","v":"u"},"Data entry cells have been highlighted in yellow for ease of data entry.  Do not enter information into cells that are not yellow."]
[null,"u","Column A is for Corporate Finance purposes only in conjunction with publishing the capital book.  Please do not enter any data into this column."]
[null,"u","Cells which contain formulas are shown in blue font."]
[null,"u","Description cells are set to wrap, but row heights may need to be manually adjusted."]
[null,"u","\"Cash to Capital\" refers to financing for tax-supported projects.  Indicate the appropriate source of funding as required (i.e. Reserves, External Debt, etc.)."]
[null,"u","Most information on the authorization, cash flow, and net impact tabs is created by formulas from the project tabs.  "]
[null,"u","New programming should only be reflected in the last 3 years of the forecast, preferably in the last 2 years."]
[]
["Authorization tab - summarizes project authorizations"]
[null,{"$f":"+$B$8","v":"u"},"Complete the Assumptions/Comments/Notes section and include any capital investment strategies and relevant results from cost/benefit analysis."]
[null,"u","Please use the priority column to rank tax-supported projects in the six-year investment plan in numerical order with #1 being the top priority."]
[null,"u","The cost / benefit ratio column is a linked field from the capital project detail sheets."]
[null,"u","Contingency:  Each project should contain a minimum of 5% of the capital cost for contingency purposes.  However the actual amount allowed for contingency is dependent upon the individual project and different values of contingencies should be included based on the department’s review of the project if warranted and supported.  Contingency need only be identified for projects whose estimate classification is Class 2 or Class 1."]
[null,"u","Escalation /Inflation:  Escalation should be incorporated into the capital budget for each project from that date of the estimate to the anticipated date of award. The rate for escalation should be taken from the escalation table provided.  It is recommended for budget purposes that we anticipate that more than three bids will be received unless the project is specialized and it is likely that we will receive less than three competitive bids."]
[null,"u","For more information on the above items - please consult \"The Capital Asset Classification\" document found on the intranet under http://citynet/finance/budget_development.stm"]
[]
["Cash Flow tab - summarizes project cash flows. "]
[]
["Net Impact tab - summarizes project net operating impacts."]
[]
[null,{"$f":"+$B$8","v":"u"},"Most information on the above tabs is entered by formulas from other tabs, some row heights may need to be manually adjusted.  Add appropriate formulas for the \"Financed by\" sections in the authorization and cash flow tabs."]
[null,{"$f":"+$B$8","v":"u"},"Ensure that the authorization and cash flow dollars balance for each project.  The cash flow  tab cells will show an ERROR if they are not balanced."]
[null,{"$f":"+$B$8","v":"u"},"If there are less than 20 projects delete the unnecessary project lines on the authorization, cash flow, and net impact tabs. "]
["Project tabs"]
[null,{"$f":"+$B$8","v":"u"},"Enter project specific information into yellow cells including Project Name, Department, Dept ID, Project Number, Service, OurWinnipeg, Authorizations, Cash Flow, Net Operating Impact, Project Description and maps/pictures."]
[null,{"$f":"+$B$8","v":"u"},"Order/name the detail sheet tabs in the same order as the projects appear on the Capital Investment Plan - Authorization."]
["CAPITAL PROJECT DETAIL:"]
[null,"Service:"]
[null,{"$f":"+$B$8","v":"u"},"Select the service from the drop down list within the cell."]
[null,"OurWinnipeg Reference:"]
[null,{"$f":"+$B$8","v":"u"},"Select the 'OurWinnipeg' reference from the drop down list within the cell.  For more detailed information on the references, see the 'OurWinnipeg' tab."]
[null,"Authorization - Previous Budget:"]
[null,{"$f":"+$B$8","v":"u"},"Please ensure that the Previous Budget amount in the Authorization section is correct.  For on-going annual programs use the default \"N/A\" (not applicable).  For new projects enter \"0\", and enter specific amount of adopted budget(s) if it is a capital project spanning multiple years."]
[null,"Financed by section:"]
[null,{"$f":"+$B$8","v":"u"},"Types of financing include:  Cash to Capital, External Debt, Provincial Funding, Reserves, Retained Earnings and Other (specify other)."]
[null,"Cash Flow section:"]
[null,{"$f":"+$B$8","v":"u"},"Only cash flow the 6-year authorization dollars requested."]
[null,{"$f":"+$B$8","v":"u"},"Cash Flow Total will show an ERROR if the Authorization and Cash Flow totals do not balance."]
[null,"Net Operating Impact section (format consistent with the Financial Impact Statement (FIS):"]
[null,{"$f":"+$B$8","v":"u"},"Calculate the net impact on the operating budget for the first three years of the authorizations requested."]
[null,{"$f":"+$B$8","v":"u"},"Operating costs - total maintenance, utilities, and other costs related to the project."]
[null,{"$f":"+$B$8","v":"u"},"External debt and finance charges - if the project is financed by external debt, include the external debt and finance charges.  The financing rates would be in the Budget Development website."]
[null,{"$f":"+$B$8","v":"u"},"Transfer to General Capital Fund - should balance to the total cash to capital authorization."]
[null,{"$f":"+$B$8","v":"u"},"Incremental revenue or recovery - include any operating revenue, corporate and any departmental capital charges."]
[null,"Project Description:"]
[null,{"$f":"+$B$8","v":"u"},"Class Estimate:  the class estimate for all projects should be identified by selecting from a drop down list (class estimate 1, 2, 3, 4, 5 or not applicable for scalable programs) to provide an indication of the expected accuracy of the budgeted amount.  The classification should be between Class 5 and Class 1 based on the classification system found on the intranet under http://citynet/finance/budget_development.stm."]
[null,"u","Type the project description starting in the first yellow shaded cell below the Net Operating Impact section. This cell is set up to wrap across columns B to M.    This area may be formatted as required.  Please remember this information will be made public later in the budget process."]
[null,"u","Input project description, including project timeframe, justification, and maps if applicable."]
[null,"u","Include estimated life of the asset."]
[null,"u","Provide specifics on cross-jurisdictional agreements."]
[null,"u","Previous Budgets - Never leave it blank. Use actual previous budget amount, \"N/A\" or \"0 (dash)\". If the project is on-going the following narrative should be added:"]
[null,null,"\"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature.\" "]
["OTHER:"]
[null,{"$f":"+$B$8","v":"u"},"Include the cost / benefit ratio calculated from the multi-criteria prioritization model.  For programs with multiple cost benefit ratios (i.e., Regional and Local Streets), enter \"See detail below.\"  In the detailed tables, enter the cost benefit ratio for each project or program.  Type in \"Not applicable\" for rolling capital programs and capital grants.  This information is for internal purposes only and will not be published."]
[null,{"$f":"+$B$8","v":"u"},"Insert additional project worksheets as needed.  Click on the border to the left of column A and above row 1 to select and copy the entire worksheet, this way all formats will be copied.  Go to cell A1 of newly inserted worksheets and select paste.  Ensure that formulas on the authorization, cash flow, net impact and summary tabs are updated for the new worksheets."]
["PRINTING:"]
[null,{"$f":"+$B$8","v":"u"},"Check the print preview before printing and ensure that row heights show all lines of text.  Please ensure that the print size is approximately 80%.  If it is less than 80%, either shorten the description or print on 2 pages.  Pages are set to print in black and white so yellow data entry cells are not highlighted."]
[null,{"$f":"+$B$8","v":"u"},"To print correct page numbers for the budget submission, group the tabs 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,null,"Grant Heather","986-4325"]
[null,null,"Knight Morton","986-2283"]
[null,null,"Liza Pablo","986-2550"]
[null,null,"Kerry Zakowich","986-2128"]
[]
[null,null,"For specific information on the \"Capital Asset Classification\" documentation:"]
[]
[null,null,"Jason Ruby","986-3403"]

{"sheet":"OurWinnipeg","index":1,"n_rows":125,"n_cols":4,"rows_kept":125,"merged":[[6,0,11,0],[6,2,8,2],[9,2,11,2],[12,2,14,2],[18,2,20,2],[26,2,28,2],[29,2,31,2],[37,2,39,2],[43,0,48,0],[43,2,45,2],[49,0,50,0],[49,2,51,2],[52,0,54,0],[88,0,90,0],[96,0,98,0]]}
[]
[null,null,"OurWinnipeg"]
[null,null," WINNIPEG'S VISION FOR THE NEXT 25 YEARS"]
[]
["AREAS OF FOCUS:",null,"KEY DIRECTIONS:","Strategic Directions:"]
[]
["A City That Works","01 - 1a","OurWinnipeg's Approach to City Building","Develop and apply direction strategies."]
[{"$nulls":3},"Develop and maintain an urban structure planning tool."]
[{"$nulls":3},"Promote compact urban form and manage the extension of municipal services for new growth."]
[null,"01 - 1b","Key Directions for the Entire City","Key directions for building a city that works."]
[{"$nulls":3},"Key directions for providing options to accommodate growth."]
[{"$nulls":3},"Key directions for connecting and expanding our sustainable transportation and infrastructure network."]
[null,"01 - 1c","Key Directions for Specific City Areas ","Downtown."]
[{"$nulls":3},"Centres and corridors."]
[{"$nulls":3},"Major redevelopment sites."]
[{"$nulls":3},"New communities."]
[{"$nulls":3},"Areas of stability."]
[{"$nulls":3},"Capital region."]
[null,"01 - 2a","Collaborate to Make Safe Communities","Provide a visible and effective community police presence."]
[{"$nulls":3},"Take leadership in addressing gang violence."]
[{"$nulls":3},"Promote safety in buildings."]
[{"$nulls":3},"Promote safety on streets and sidewalks."]
[{"$nulls":3},"Plan for crime prevention in the built and natural environments."]
[{"$nulls":3},"Take a broad-scaled, complete and collaborative approach to crime prevention."]
[{"$nulls":3},"Implement an approach to safety and security that is collaborative and involves the community."]
[{"$nulls":3},"Help people and communities make safe places in safe neighbourhoods."]
[null,"01 - 2b","Emergency Preparedness, Response and Recovery","Provide emergency fire/rescue and pre-hospital paramedical response."]
[{"$nulls":3},"Prepare for disasters and emergencies."]
[{"$nulls":3},"Maintain emergency planning efforts to prevent hazards from developing into disasters and to reduce the effects of natural hazards including extreme weather."]
[null,"01 - 3","Prosperity","Provide efficient and focused civic administration and governance."]
[{"$nulls":3},"Provide a predictable and cost-effective business environment that promotes investment and growth."]
[{"$nulls":3},"Maintain strong intergovernmental cooperation."]
[{"$nulls":3},"Collaborate with all public, private and community economic development agencies to advance economic advantages. "]
[{"$nulls":3},"Demonstrate visionary civic leadership and commitment to sustainable long-term planning."]
[{"$nulls":3},"Plan for a rising share of employment growth and productivity."]
[{"$nulls":3},"Create favourable conditions for development that is consistent with the principles and goals of Complete Communities."]
[{"$nulls":3},"Encourage activities beneficial to the Winnipeg economy."]
[null,"01 - 4","Housing","Support diverse housing options in each neighbourhood or neighbourhood cluster throughout the City."]
[{"$nulls":3},"Collaborate with other levels of government and other partners to renew and regenerate Winnipeg’s housing stock. "]
[{"$nulls":3},"Establish partnerships with the private, not-for-profit and government sectors to provide affordable housing throughout the city, with a particular focus on locations near a variety of transportation options."]
[{"$nulls":3},"Provide leadership in encouraging and enforcing property-related housing standards that create and promote safe living conditions for homeowners, tenants and for communities as a whole. "]
[{"$nulls":3},"Support the integration of specialty housing within residential neighbourhoods, with a particular focus on locations near a variety of transportation options. "]
[{"$nulls":3},"Encourage residential development downtown. "]
[null,"01 - 5","Recreation","Promote and enable opportunities for all age groups to be active as part of their daily lives."]
[{"$nulls":3},"Work with community partners to provide services that are responsive to the community’s recreation and leisure needs."]
[{"$nulls":3},"Directly provide, or facilitate through partnerships, equitable access to a base level of recreation, culture and leisure services for all Winnipeggers."]
[{"$nulls":3},"With community partners, participate as a leader in planning and delivering recreation and leisure services in Winnipeg. "]
[{"$nulls":3},"Provide or facilitate community development and recreation opportunities for vulnerable youth."]
[{"$nulls":3},"Plan for sustainable and connected recreation and leisure infrastructure."]
[null,"01 - 6","Libraries","Provide quality, responsive and innovative library programs and services that emphasize literacy and life-long learning and that enrich all Winnipeggers and their communities."]
[{"$nulls":3},"Provide library facilities that are safe, convenient and accessible community places."]
[{"$nulls":3},"Market and promote the collections, programs and services of the library system to ensure maximum public benefit."]
["A Sustainable City","02 - 1","Sustainability","The foundation: leading by example."]
[{"$nulls":3},"Track progress."]
[{"$nulls":3},"Integrate sustainability into internal decision-making."]
[{"$nulls":3},"Create and invest in sustainability tools."]
[null,"02 - 2","Environment","Reduce the environmental impact of our activities, through strategies such as planning for sustainable energy use and greenhouse gas reduction."]
[{"$nulls":3},"Recognize and preserve Winnipeg’s parks, green spaces and riverbanks as green oases in our urban setting."]
[{"$nulls":3},"Set long range goals for solid waste diversion."]
[{"$nulls":3},"Collaborate to ensure water and air quality."]
[{"$nulls":3},"Provide safe and effective pest and weed control in City operations."]
[{"$nulls":3},"Enable the protection of ecologically significant lands."]
[{"$nulls":3},"Promote the use of rivers and riverbanks."]
[{"$nulls":3},"Support waterway management."]
[{"$nulls":3},"Protect and enhance the urban forest."]
[null,"02 - 3","Heritage ","Plan for heritage conservation."]
[{"$nulls":3},"Conserve, protect and celebrate the significant heritage resources that illustrate the broad range of Winnipeg’s heritage values. "]
[{"$nulls":3},"Provide leadership in heritage conservation that links to broader civic goals of economic development, sustainability and neighbourhood planning."]
[{"$nulls":3},"Conserve downtown’s rich legacy of heritage resources that provide significant and sustainable development opportunities."]
[{"$nulls":3},"Enhance the viability of the Exchange District National Historic Site."]
[{"$nulls":3},"Plan for the sustainable development of healthy neighbourhoods based on their particular historic identity and character. "]
["Quality of Life","03 - 1","Opportunity","Strive to use mandated municipal services areas, such as libraries and recreation, as opportunities to foster strong cross cultural relations that contribute to healthy communities."]
[{"$nulls":3},"Provide equitable access to municipal programs, services and facilities. "]
[{"$nulls":3},"Work with community partners to foster an inclusive and equitable community."]
[{"$nulls":3},"Work within municipal service areas as a collaborator on poverty reduction."]
[{"$nulls":3},"Acknowledge that Aboriginal Winnipeggers bring a diverse richness of cultures, traditions, languages, teachings, values, skills and perspectives to our city. "]
[{"$nulls":3},"Foster opportunities for Aboriginal Winnipeggers, particularly youth, to obtain meaningful employment by building on current civic practices, processes and community partnerships."]
[{"$nulls":3},"Develop community directed strategies to support quality of life for our growing communities of international newcomers."]
[{"$nulls":3},"Include age-friendliness in City of Winnipeg strategic planning."]
[{"$nulls":3},"Collaborate with developers, community organizations and other partners to foster an age-friendly and accessible urban environment."]
[null,"03 - 2","Vitality","Strive to eliminate derelict buildings."]
[{"$nulls":3},"Deliver a coordinated, integrated, and seamless service response to address community needs and priorities that contribute to building healthy communities. "]
[{"$nulls":3},"Work in partnership with communities to identify and address neighbourhood issues."]
[{"$nulls":3},"Maintain the health and safety of neighbourhoods by enforcing animal control by-laws and promoting responsible pet ownership."]
[{"$nulls":3},"Support effective public health inspection services. "]
[{"$nulls":3},"Promote cleanliness and beautification."]
[{"$nulls":3},"Recognize and support the essential role that volunteers and volunteerism play in building a healthy and vibrant Winnipeg."]
[{"$nulls":3},"Working through community partnerships, respond to food needs as identified by communities."]
[null,"03 - 3","Creativity","Continue to develop Winnipeg’s unique artistic identity and diversity of expression."]
[{"$nulls":3},"Act as a responsible steward for City-owned museums, archives and collections."]
[{"$nulls":3},"Support a wide range of arts and cultural facilities."]
[{"$nulls":3},"Support and enable meaningful community expression."]
[{"$nulls":3},"Foster life-long arts learning opportunities."]
[{"$nulls":3},"Promote awareness of the richness of Winnipeg’s arts and culture within and outside Winnipeg. "]
[{"$nulls":3},"Grow support for creative industries and entrepreneurs. "]
[{"$nulls":3},"Establish Winnipeg as a city of choice and desired destination for artists and creative professionals."]
["Implementation","04 - 1","OurWinnipeg Action Plan","Relationship building, outreach and marketing."]
[{"$nulls":3},"Implementation plans."]
[{"$nulls":3},"Monitoring, measuring and continuous improvement."]
[null,"04 - 2","Responsibility for Implementation"]
[null,"04 - 3 ","Subsidiary Plans"]
[null,"04 - 4","Budget"]
[null,"04 - 5","Amendments"]
[]
[]
[null,null,"OurWinnipeg's Approach to City Building"]
[null,null,"Key Directions for the Entire City"]
[null,null,"Key Directions for Specific City Areas "]
[null,null,"Collaborate to Make Safe Communities"]
[null,null,"Emergency Preparedness, Response and Recovery"]
[null,null,"Prosperity"]
[null,null,"Housing"]
[null,null,"Recreation"]
[null,null,"Libraries"]
[null,null,"Sustainability"]
[null,null,"Environment"]
[null,null,"Heritage "]
[null,null,"Opportunity"]
[null,null,"Vitality"]
[null,null,"Creativity"]
[null,null,"OurWinnipeg Action Plan"]
[null,null,"Responsibility for Implementation"]
[null,null,"Subsidiary Plans"]
[null,null,"Budget"]
[null,null,"Amendments"]

{"sheet":"service list and class estimate","index":2,"n_rows":42,"n_cols":10,"rows_kept":42}
[]
[]
[null,null,"Service Based Budget - List of Services",{"$nulls":5},"Class Estimate"]
[{"$nulls":8},1]
[null,null,"Animal Services SOA",null,"Roadway Constr. & Maint.",{"$nulls":3},2]
[null,null,"Arts, Entertainment and Culture",null,"Transp. Planning and Traffic Management",{"$nulls":3},3]
[null,null,"Assessment, Taxation and Corporate",null,"Roadway Snow Rem. & Ice Control",{"$nulls":3},"3 - applies to 2016 only","Update"]
[null,null,"Cemeteries",null,"Public Transit",{"$nulls":3},4]
[null,null,"City Beautification",null,"Water",{"$nulls":3},5]
[null,null,"City Planning",null,"Wastewater",{"$nulls":3},"Not applicable"]
[null,null,"Community Liveability",null,"Land Drainage & Flood Control",{"$nulls":3},"Not applicable, as this is a scalable program"]
[null,null,"Contact Centre - 311",null,"Solid Waste Collection & Disposal",{"$nulls":3},"Select from a drop down list"]
[null,null,"Council Services",null,"Recycling & Waste Min."]
[null,null,"Crime Prevention",null,"Parks and Urban Forestry"]
[null,null,"Development Approvals, Building Permits and Inspections",null,"City Beautification"]
[null,null,"Disaster Preparedness and Response",null,"Fleet Mamagement Agency (SOA)"]
[null,null,"Economic Development",null,"Parking Authority (SOA)"]
[null,null,"Fire and Injury Prevention",null,"City Planning"]
[null,null,"Fire and Rescue Response",null,"Neighbourhood "]
[null,null,"Fleet Management Agency SOA",null,"Building Permits and Inspections"]
[null,null,"Golf Services SOA",null,"Economic Development"]
[null,null,"Heritage Conservation",null,"Heritage Conservation"]
[null,null,"Insect Control",null,"Property Asset Management"]
[null,null,"Land Drainage and Flood Control",null,"Cemeteries"]
[null,null,"Libraries",null,"Police Response"]
[null,null,"Medical Response",null,"Crime Prevention"]
[null,null,"Neighbourhood Revitalization",null,"Contact Centre - 311"]
[null,null,"Organizational Support Services",null,"Traffic Safety and\nEnforcement"]
[null,null,"Parking Authority SOA",null,"Fire and Rescue Response"]
[null,null,"Parks and Urban Forestry",null,"Fire and Injury Prevention"]
[null,null,"Police Response",null,"Medical Response"]
[null,null,"Property Asset Management",null,"Disaster Prep. & Response"]
[null,null,"Public Transit",null,"Recreation"]
[null,null,"Recreation",null,"Golf Services (SOA)"]
[null,null,"Recycling and Waste Diversion",null,"Community Health and\nSocial Support"]
[null,null,"Roadway Construction and Maintenance",null,"Libraries"]
[null,null,"Roadway Snow Removal and Ice Control",null,"Arts, Entertainment and Culture"]
[null,null,"Solid Waste Collection and Disposal",null,"Animal Services "]
[null,null,"Traffic Safety and Enforcement",null,"Insect Control"]
[null,null,"Transportation Planning and Traffic Management",null,"Organizational Services"]
[null,null,"Wastewater",null,"Assessment, Taxation and Corporate"]
[null,null,"Water",null,"Council Services"]

{"sheet":"authorization","index":3,"n_rows":40,"n_cols":15,"rows_kept":40,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[5,3,5,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,12,6,12],[5,13,6,13],[5,14,6,14],[40,1,40,10],[41,1,41,10],[42,1,42,10],[43,1,43,10],[44,1,44,10],[45,1,45,10],[46,1,46,10],[47,1,47,10],[48,1,48,10],[49,1,49,10],[50,1,50,10]]}
[{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
["Capital Investment Plan - Authorization"]
["($000's)"]
[]
[null,null,"Authorization"]
[null,null,{"$f":"+instructions!$D$11","v":2016},"Forecast",{"$nulls":4},"Cost / Benefit Ratio","Priority","6-Year Total",null,"Class Estimate","% Contingency","% Construction Inflation"]
[null,null,{"$f":"+instructions!$D$13","v":"Estimate"},{"$f":"C6+1","v":2017},{"$f":"D7+1","v":2018},{"$f":"E7+1","v":2019},{"$f":"F7+1","v":2020},{"$f":"G7+1","v":2021}]
["List of Capital Projects:"]
[]
[1,{"$f":"+'project 1'!$D$3","v":"Type Project name here"},{"$f":"+'project 1'!F12","v":0},{"$f":"+'project 1'!G12","v":0},{"$f":"+'project 1'!H12","v":0},{"$f":"+'project 1'!I12","v":0},{"$f":"+'project 1'!J12","v":0},{"$f":"+'project 1'!K12","v":0},{"$f":"+'project 1'!$O$12","v":0},null,{"$f":"SUM(C10:H10)","v":0},null,{"$f":"+'project 1'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[2,{"$f":"+'project 2'!$D$3","v":"Type Project name here"},{"$f":"+'project 2'!F12","v":0},{"$f":"+'project 2'!G12","v":0},{"$f":"+'project 2'!H12","v":0},{"$f":"+'project 2'!I12","v":0},{"$f":"+'project 2'!J12","v":0},{"$f":"+'project 2'!K12","v":0},{"$f":"+'project 2'!$O$12","v":0},null,0,null,{"$f":"+'project 2'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[3,{"$f":"+'project 3'!$D$3","v":"Type Project name here"},{"$f":"'project 3'!F12","v":0},{"$f":"+'project 3'!G12","v":0},{"$f":"+'project 3'!H12","v":0},{"$f":"+'project 3'!I12","v":0},{"$f":"+'project 3'!J12","v":0},{"$f":"+'project 4'!K12","v":0},{"$f":"+'project 3'!$O$12","v":0},null,0,null,{"$f":"+'project 3'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[4,{"$f":"+'project 4'!$D$3","v":"Type Project name here"},{"$f":"+'project 4'!F13","v":0},{"$f":"+'project 4'!G13","v":0},{"$f":"+'project 4'!H13","v":0},{"$f":"+'project 4'!I13","v":0},{"$f":"+'project 4'!J13","v":0},{"$f":"+'project 4'!K13","v":0},{"$f":"+'project 4'!$O$12","v":0},null,0,null,{"$f":"+'project 4'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[5,{"$f":"+'project 5'!$D$3","v":"Type Project name here"},{"$f":"+'project 5'!F13","v":0},{"$f":"+'project 5'!G13","v":0},{"$f":"+'project 5'!H13","v":0},{"$f":"+'project 5'!I13","v":0},{"$f":"+'project 5'!J13","v":0},{"$f":"+'project 5'!K13","v":0},{"$f":"+'project 5'!$O$12","v":0},null,0,null,{"$f":"+'project 5'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[6,{"$f":"+'project 6'!$D$3","v":"Type Project name here"},{"$f":"+'project 6'!F13","v":0},{"$f":"+'project 6'!G13","v":0},{"$f":"+'project 6'!H13","v":0},{"$f":"+'project 6'!I13","v":0},{"$f":"+'project 6'!J13","v":0},{"$f":"+'project 6'!K13","v":0},{"$f":"+'project 6'!$O$12","v":0},null,0,null,{"$f":"+'project 6'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[7,{"$f":"+'project 7'!$D$3","v":"Type Project name here"},{"$f":"+'project 7'!F13","v":0},{"$f":"+'project 7'!G13","v":0},{"$f":"+'project 7'!H13","v":0},{"$f":"+'project 7'!I13","v":0},{"$f":"+'project 7'!J13","v":0},{"$f":"+'project 7'!K13","v":0},{"$f":"+'project 7'!$O$12","v":0},null,0,null,{"$f":"+'project 7'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[8,{"$f":"+'project 8'!$D$3","v":"Type Project name here"},{"$f":"+'project 8'!F13","v":0},{"$f":"+'project 8'!G13","v":0},{"$f":"+'project 8'!H13","v":0},{"$f":"+'project 8'!I13","v":0},{"$f":"+'project 8'!J13","v":0},{"$f":"+'project 8'!K13","v":0},{"$f":"+'project 8'!$O$12","v":0},null,0,null,{"$f":"+'project 8'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[9,{"$f":"+'project 9'!$D$3","v":"Type Project name here"},{"$f":"+'project 9'!F13","v":0},{"$f":"+'project 9'!G13","v":0},{"$f":"+'project 9'!H13","v":0},{"$f":"+'project 9'!I13","v":0},{"$f":"+'project 9'!J13","v":0},{"$f":"+'project 9'!K13","v":0},{"$f":"+'project 9'!$O$12","v":0},null,0,null,{"$f":"+'project 9'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[10,{"$f":"+'project 10'!$D$3","v":"Type Project name here"},{"$f":"+'project 10'!F13","v":0},{"$f":"+'project 10'!G13","v":0},{"$f":"+'project 10'!H13","v":0},{"$f":"+'project 10'!I13","v":0},{"$f":"+'project 10'!J13","v":0},{"$f":"+'project 10'!K13","v":0},{"$f":"+'project 10'!$O$12","v":0},null,0,null,{"$f":"+'project 10'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[11,{"$f":"+'project 11'!$D$3","v":"Type Project name here"},{"$f":"+'project 11'!F13","v":0},{"$f":"+'project 11'!G13","v":0},{"$f":"+'project 11'!H13","v":0},{"$f":"+'project 11'!I13","v":0},{"$f":"+'project 11'!J13","v":0},{"$f":"+'project 11'!K13","v":0},{"$f":"+'project 11'!$O$12","v":0},null,0,null,{"$f":"+'project 11'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[12,{"$f":"+'project 12'!$D$3","v":"Type Project name here"},{"$f":"+'project 12'!F13","v":0},{"$f":"+'project 12'!G13","v":0},{"$f":"+'project 12'!H13","v":0},{"$f":"+'project 12'!I13","v":0},{"$f":"+'project 12'!J13","v":0},{"$f":"+'project 12'!K13","v":0},{"$f":"+'project 12'!$O$12","v":0},null,0,null,{"$f":"+'project 12'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[13,{"$f":"+'project 13'!$D$3","v":"Type Project name here"},{"$f":"+'project 13'!F13","v":0},{"$f":"+'project 13'!G13","v":0},{"$f":"+'project 13'!H13","v":0},{"$f":"+'project 13'!I13","v":0},{"$f":"+'project 13'!J13","v":0},{"$f":"+'project 13'!K13","v":0},{"$f":"+'project 13'!$O$12","v":0},null,0,null,{"$f":"+'project 13'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[14,{"$f":"+'project 14'!$D$3","v":"Type Project name here"},{"$f":"+'project 14'!F13","v":0},{"$f":"+'project 14'!G13","v":0},{"$f":"+'project 14'!H13","v":0},{"$f":"+'project 14'!I13","v":0},{"$f":"+'project 14'!J13","v":0},{"$f":"+'project 14'!K13","v":0},{"$f":"+'project 14'!$O$12","v":0},null,0,null,{"$f":"+'project 14'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
[15,{"$f":"+'project 15'!$D$3","v":"Type Project name here"},{"$f":"+'project 15'!F13","v":0},{"$f":"+'project 15'!G13","v":0},{"$f":"+'project 15'!H13","v":0},{"$f":"+'project 15'!I13","v":0},{"$f":"+'project 15'!J13","v":0},{"$f":"+'project 15'!K13","v":0},{"$f":"+'project 15'!$O$12","v":0},null,0,null,{"$f":"+'project 15'!D36","v":"Select from a drop down list"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"}]
["(insert additional lines here, copy entire row to inserted line)"]
[]
[]
[null,"TOTAL CAPITAL PROJECTS",{"$f":"SUM(C8:C27)","v":0},{"$f":"SUM(D8:D27)","v":0},0,0,0,0,null,null,0]
[]
["Financed by:"]
[" "]
["Cash to Capital",null,"(insert formulas based on funding for capital projects)",{"$nulls":7},{"$f":"SUM(C32:H32)","v":0}]
["External Debt",{"$nulls":9},0]
["Provincial Funding",{"$nulls":9},0]
["Reserves",{"$nulls":9},0]
["Retained Earnings",{"$nulls":9},0]
[{"$nulls":10},0]
[null,"TOTAL CAPITAL FINANCING",{"$f":"SUM(C32:C37)","v":0},0,0,0,0,0,null,null,0]
[]
["Assumptions/Comments/Notes"]

{"sheet":"cash flow","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,9],[6,3,6,7]]}
[]
[{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
["Capital Investment Plan - Cash Flow "]
["($000's)"]
[]
[null,null,"Cash Flow"]
[null,null,{"$f":"+instructions!$D$11","v":2016},"Forecast",{"$nulls":4},"Beyond","6-Year"]
[null,null,{"$f":"+instructions!$D$13","v":"Estimate"},{"$f":"C7+1","v":2017},{"$f":"D8+1","v":2018},{"$f":"E8+1","v":2019},{"$f":"F8+1","v":2020},{"$f":"G8+1","v":2021},{"$f":"+H8","v":2021},"Total"]
["List of Capital Projects:"]
[]
[1,{"$f":"+'project 1'!$D$3","v":"Type Project name here"},{"$f":"+'project 1'!F19","v":0},{"$f":"+'project 1'!G19","v":0},{"$f":"+'project 1'!H19","v":0},{"$f":"+'project 1'!I19","v":0},{"$f":"+'project 1'!J19","v":0},{"$f":"+'project 1'!K19","v":0},{"$f":"+'project 1'!L19","v":0},{"$f":"IF(SUM(C11:I11)=authorization!K10,SUM(C11:I11),\"ERR\")","v":0}]
[2,{"$f":"+'project 2'!$D$3","v":"Type Project name here"},{"$f":"+'project 3'!F19","v":0},{"$f":"+'project 3'!G19","v":0},{"$f":"+'project 3'!H19","v":0},{"$f":"+'project 3'!I19","v":0},{"$f":"+'project 3'!J19","v":0},{"$f":"+'project 3'!K19","v":0},{"$f":"+'project 3'!L19","v":0},{"$f":"IF(SUM(C12:I12)=authorization!K11,SUM(C12:I12),\"ERR\")","v":0}]
[3,{"$f":"+'project 3'!$D$3","v":"Type Project name here"},{"$f":"+'project 3'!F19","v":0},{"$f":"+'project 3'!G19","v":0},{"$f":"+'project 3'!H19","v":0},{"$f":"+'project 3'!I19","v":0},{"$f":"+'project 3'!J19","v":0},{"$f":"+'project 3'!K19","v":0},{"$f":"+'project 4'!L19","v":0},{"$f":"IF(SUM(C13:I13)=authorization!K12,SUM(C13:I13),\"ERR\")","v":0}]
[4,{"$f":"+'project 4'!$D$3","v":"Type Project name here"},{"$f":"+'project 4'!F20","v":0},{"$f":"+'project 4'!G20","v":0},{"$f":"+'project 4'!H20","v":0},{"$f":"+'project 4'!I20","v":0},{"$f":"+'project 4'!J20","v":0},{"$f":"+'project 4'!K20","v":0},{"$f":"+'project 4'!L20","v":0},{"$f":"IF(SUM(C14:I14)=authorization!K13,SUM(C14:I14),\"ERR\")","v":0}]
[5,{"$f":"+'project 5'!$D$3","v":"Type Project name here"},{"$f":"+'project 5'!F20","v":0},{"$f":"+'project 5'!G20","v":0},{"$f":"+'project 5'!H20","v":0},{"$f":"+'project 5'!I20","v":0},{"$f":"+'project 5'!J20","v":0},{"$f":"+'project 5'!K20","v":0},{"$f":"+'project 5'!L20","v":0},{"$f":"IF(SUM(C15:I15)=authorization!K14,SUM(C15:I15),\"ERR\")","v":0}]
[6,{"$f":"+'project 6'!$D$3","v":"Type Project name here"},{"$f":"+'project 6'!F20","v":0},{"$f":"+'project 6'!G20","v":0},{"$f":"+'project 6'!H20","v":0},{"$f":"+'project 6'!I20","v":0},{"$f":"+'project 6'!J20","v":0},{"$f":"+'project 6'!K20","v":0},{"$f":"+'project 6'!L20","v":0},{"$f":"IF(SUM(C16:I16)=authorization!K15,SUM(C16:I16),\"ERR\")","v":0}]
[7,{"$f":"+'project 7'!$D$3","v":"Type Project name here"},{"$f":"+'project 7'!F20","v":0},{"$f":"+'project 7'!G20","v":0},{"$f":"+'project 7'!H20","v":0},{"$f":"+'project 7'!I20","v":0},{"$f":"+'project 7'!J20","v":0},{"$f":"+'project 7'!K20","v":0},{"$f":"+'project 7'!L20","v":0},{"$f":"IF(SUM(C17:I17)=authorization!K16,SUM(C17:I17),\"ERR\")","v":0}]
[8,{"$f":"+'project 8'!$D$3","v":"Type Project name here"},{"$f":"+'project 8'!F20","v":0},{"$f":"+'project 8'!G20","v":0},{"$f":"+'project 8'!H20","v":0},{"$f":"+'project 8'!I20","v":0},{"$f":"+'project 8'!J20","v":0},{"$f":"+'project 8'!K20","v":0},{"$f":"+'project 8'!L20","v":0},{"$f":"IF(SUM(C18:I18)=authorization!K17,SUM(C18:I18),\"ERR\")","v":0}]
[9,{"$f":"+'project 9'!$D$3","v":"Type Project name here"},{"$f":"+'project 9'!F20","v":0},{"$f":"+'project 9'!G20","v":0},{"$f":"+'project 9'!H20","v":0},{"$f":"+'project 9'!I20","v":0},{"$f":"+'project 9'!J20","v":0},{"$f":"+'project 9'!K20","v":0},{"$f":"+'project 9'!L20","v":0},{"$f":"IF(SUM(C19:I19)=authorization!K18,SUM(C19:I19),\"ERR\")","v":0}]
[10,{"$f":"+'project 10'!$D$3","v":"Type Project name here"},{"$f":"+'project 10'!F20","v":0},{"$f":"+'project 10'!G20","v":0},{"$f":"+'project 10'!H20","v":0},{"$f":"+'project 10'!I20","v":0},{"$f":"+'project 10'!J20","v":0},{"$f":"+'project 10'!K20","v":0},{"$f":"+'project 10'!L20","v":0},{"$f":"IF(SUM(C20:I20)=authorization!K19,SUM(C20:I20),\"ERR\")","v":0}]
[11,{"$f":"+'project 11'!$D$3","v":"Type Project name here"},{"$f":"+'project 11'!F20","v":0},{"$f":"+'project 11'!G20","v":0},{"$f":"+'project 11'!H20","v":0},{"$f":"+'project 11'!I20","v":0},{"$f":"+'project 11'!J20","v":0},{"$f":"+'project 11'!K20","v":0},{"$f":"+'project 11'!L20","v":0},{"$f":"IF(SUM(C21:I21)=authorization!K20,SUM(C21:I21),\"ERR\")","v":0}]
[12,{"$f":"+'project 12'!$D$3","v":"Type Project name here"},{"$f":"+'project 12'!F20","v":0},{"$f":"+'project 12'!G20","v":0},{"$f":"+'project 12'!H20","v":0},{"$f":"+'project 12'!I20","v":0},{"$f":"+'project 12'!J20","v":0},{"$f":"+'project 12'!K20","v":0},{"$f":"+'project 12'!L20","v":0},{"$f":"IF(SUM(C22:I22)=authorization!K21,SUM(C22:I22),\"ERR\")","v":0}]
[13,{"$f":"+'project 13'!$D$3","v":"Type Project name here"},{"$f":"+'project 13'!F20","v":0},{"$f":"+'project 13'!G20","v":0},{"$f":"+'project 13'!H20","v":0},{"$f":"+'project 13'!I20","v":0},{"$f":"+'project 13'!J20","v":0},{"$f":"+'project 13'!K20","v":0},{"$f":"+'project 13'!L20","v":0},{"$f":"IF(SUM(C23:I23)=authorization!K22,SUM(C23:I23),\"ERR\")","v":0}]
[14,{"$f":"+'project 14'!$D$3","v":"Type Project name here"},{"$f":"+'project 14'!F20","v":0},{"$f":"+'project 14'!G20","v":0},{"$f":"+'project 14'!H20","v":0},{"$f":"+'project 14'!I20","v":0},{"$f":"+'project 14'!J20","v":0},{"$f":"+'project 14'!K20","v":0},{"$f":"+'project 14'!L20","v":0},{"$f":"IF(SUM(C24:I24)=authorization!K23,SUM(C24:I24),\"ERR\")","v":0}]
[15,{"$f":"+'project 15'!$D$3","v":"Type Project name here"},{"$f":"+'project 15'!F20","v":0},{"$f":"+'project 15'!G20","v":0},{"$f":"+'project 15'!H20","v":0},{"$f":"+'project 15'!I20","v":0},{"$f":"+'project 15'!J20","v":0},{"$f":"+'project 15'!K20","v":0},{"$f":"+'project 15'!L20","v":0},{"$f":"IF(SUM(C25:I25)=authorization!K24,SUM(C25:I25),\"ERR\")","v":0}]
["(insert additional lines here, copy entire row to inserted line)"]
[]
[]
[null,"TOTAL CAPITAL PROJECTS",{"$f":"SUM(C9:C28)","v":0},0,0,0,0,0,0,0]
[]
["Financed by:"]
[" "]
["Cash to Capital",null,"(insert formulas based on funding for capital projects)",{"$nulls":6},{"$f":"SUM(C33:I33)","v":0}]
["External Debt",{"$nulls":8},0]
["Provincial Funding",{"$nulls":8},0]
["Reserves",{"$nulls":8},0]
["Retained Earnings",{"$nulls":8},0]
[{"$nulls":9},0]
[null,"TOTAL CAPITAL FINANCING",{"$f":"SUM(C33:C38)","v":0},0,0,0,0,0,0,{"$f":"SUM(J33:J38)","v":0}]

{"sheet":"net impact","index":5,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[40,1,40,5],[41,1,41,5]]}
[]
[{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
["Summary of Net Operating Impact"]
["($000's)"]
[]
[null,null,"Net Operating Impact"]
[]
[null,null,{"$f":"authorization!C6","v":2016},{"$f":"C8+1","v":2017},{"$f":"D8+1","v":2018},"Total"]
["List of Capital Projects:"]
[]
[1,{"$f":"+'project 1'!$D$3","v":"Type Project name here"},{"$f":"+'project 1'!F31","v":0},{"$f":"+'project 1'!G31","v":0},{"$f":"+'project 1'!H31","v":0},{"$f":"SUM(C11:E11)","v":0}]
[2,{"$f":"+'project 2'!$D$3","v":"Type Project name here"},{"$f":"+'project 2'!F31","v":0},{"$f":"+'project 2'!G31","v":0},{"$f":"+'project 2'!H31","v":0},0]
[3,{"$f":"+'project 3'!$D$3","v":"Type Project name here"},{"$f":"+'project 3'!F31","v":0},{"$f":"+'project 3'!G31","v":0},{"$f":"+'project 3'!H31","v":0},0]
[4,{"$f":"+'project 4'!$D$3","v":"Type Project name here"},{"$f":"+'project 4'!F31","v":0},{"$f":"+'project 4'!G31","v":0},{"$f":"+'project 4'!H31","v":0},0]
[5,{"$f":"+'project 5'!$D$3","v":"Type Project name here"},{"$f":"+'project 5'!F31","v":0},{"$f":"+'project 5'!G31","v":0},{"$f":"+'project 5'!H31","v":0},0]
[6,{"$f":"+'project 6'!$D$3","v":"Type Project name here"},{"$f":"+'project 6'!F31","v":0},{"$f":"+'project 6'!G31","v":0},{"$f":"+'project 6'!H31","v":0},0]
[7,{"$f":"+'project 7'!$D$3","v":"Type Project name here"},{"$f":"+'project 7'!F31","v":0},{"$f":"+'project 7'!G31","v":0},{"$f":"+'project 7'!H31","v":0},0]
[8,{"$f":"+'project 8'!$D$3","v":"Type Project name here"},{"$f":"+'project 8'!F31","v":0},{"$f":"+'project 8'!G31","v":0},{"$f":"+'project 8'!H31","v":0},0]
[9,{"$f":"+'project 9'!$D$3","v":"Type Project name here"},{"$f":"+'project 9'!F31","v":0},{"$f":"+'project 9'!G31","v":0},{"$f":"+'project 9'!H31","v":0},0]
[10,{"$f":"+'project 10'!$D$3","v":"Type Project name here"},{"$f":"+'project 10'!F31","v":0},{"$f":"+'project 10'!G31","v":0},{"$f":"+'project 10'!H31","v":0},0]
[11,{"$f":"+'project 11'!$D$3","v":"Type Project name here"},{"$f":"+'project 11'!F31","v":0},{"$f":"+'project 11'!G31","v":0},{"$f":"+'project 11'!H31","v":0},0]
[12,{"$f":"+'project 12'!$D$3","v":"Type Project name here"},{"$f":"+'project 12'!F31","v":0},{"$f":"+'project 12'!G31","v":0},{"$f":"+'project 12'!H31","v":0},0]
[13,{"$f":"+'project 13'!$D$3","v":"Type Project name here"},{"$f":"+'project 13'!F31","v":0},{"$f":"+'project 13'!G31","v":0},{"$f":"+'project 13'!H31","v":0},0]
[14,{"$f":"+'project 14'!$D$3","v":"Type Project name here"},{"$f":"+'project 14'!F31","v":0},{"$f":"+'project 14'!G31","v":0},{"$f":"+'project 14'!H31","v":0},0]
[15,{"$f":"+'project 15'!$D$3","v":"Type Project name here"},{"$f":"+'project 15'!F31","v":0},{"$f":"+'project 15'!G31","v":0},{"$f":"+'project 15'!H31","v":0},0]
["(insert additional lines here, copy entire row to inserted line)",{"$nulls":4},{"$f":"SUM(C26:E26)","v":0}]
[{"$nulls":5},{"$f":"SUM(C27:E27)","v":0}]
[]
[null,"TOTAL NET OPERATING IMPACT",{"$f":"SUM(C9:C28)","v":0},{"$f":"SUM(D9:D28)","v":0},{"$f":"SUM(E9:E28)","v":0},{"$f":"SUM(F9:F28)","v":0}]
[]
["Notes/Comments:"]

{"sheet":"project 1","index":6,"n_rows":56,"n_cols":15,"rows_kept":56,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","NET OPERATING IMPACT ($000's)",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
["note","- If the project is on-going use the following in the narrative:"]
["note"]
["note","* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]
["note"]
["note"]
["note"]
["note"]
[]
["img"]

{"sheet":"project 2","index":7,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","NET OPERATING IMPACT ($000's)",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 3","index":8,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 4","index":9,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Equity in Capital Assets Fund",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,"Cash to Capital",{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 5","index":10,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 6","index":11,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 7","index":12,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 8","index":13,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 9","index":14,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 10","index":15,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 11","index":16,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 12","index":17,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 13","index":18,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 14","index":19,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]

{"sheet":"project 15","index":20,"n_rows":50,"n_cols":15,"rows_kept":50,"merged":[[2,3,2,12],[4,3,4,5],[5,3,5,5],[5,9,5,12],[6,3,7,5],[6,9,6,12],[7,9,7,12],[9,1,10,3],[9,4,10,4],[9,5,10,5],[9,6,9,10],[9,11,10,11],[9,12,10,12],[9,14,10,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[47,1,47,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,1,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,1,60,12]]}
[null,{"$f":"+instructions!C9","v":"SAMPLE DEPARTMENT - GENERAL CAPITAL FUND"}]
[]
["projdesc","Project Name:",null,"Type Project name here"]
[]
[null,"Dept ID:",null,"Type DeptID"]
["projdetail","Department:",null,"Type Department",{"$nulls":4},"Service:"]
["projdetail","Project:",null,"Type project number",{"$nulls":4},"OurWinnipeg:"]
["projdetail"]
[]
["authtitle","AUTHORIZATION",null,null,"Previous Budgets",{"$f":"TEXT(G11-1,\"0\")&\" \" &instructions!D13","v":"2016 Estimate"},"FORECAST",{"$nulls":4},"Five-Year Forecast Total","Six-Year Total",null,"Cost / Benefit Ratio"]
["authtitle2",{"$nulls":5},{"$f":"instructions!D11+1","v":2017},{"$f":"G11+1","v":2018},{"$f":"H11+1","v":2019},{"$f":"I11+1","v":2020},{"$f":"J11+1","v":2021}]
["authcost","Project Costs ($000's)",null,null,"N/A *",{"$f":"SUM(F14:F16)","v":0},0,0,0,0,0,{"$f":"IF(SUM(G12:K12)=SUM(L14:L16),SUM(G12:K12),\"ERROR\")","v":0},{"$f":"IF((F12+L12)=SUM(M14:M16),(F12+L12),\"ERROR\")","v":0}]
["authfin","Financed by:"]
["authdata",null,"Cash to Capital",{"$nulls":8},{"$f":"SUM(G14:K14)","v":0},{"$f":"F14+L14","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G15:K15)","v":0},{"$f":"F15+L15","v":0}]
["authdata",{"$nulls":10},{"$f":"SUM(G16:K16)","v":0},{"$f":"F16+L16","v":0}]
[]
["cftitle","CASH FLOW",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"F18+1","v":2017},{"$f":"G18+1","v":2018},{"$f":"H18+1","v":2019},{"$f":"I18+1","v":2020},{"$f":"J18+1","v":2021},"Beyond 2021","Total"]
["cfcost","Project Costs ($000's)",{"$nulls":3},{"$f":"SUM(F21:F23)","v":0},{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,{"$f":"IF(SUM(F19:L19)=M12,SUM(F19:L19),\"ERROR\")","v":0}]
["cffin","Financed by:"]
["cfdata",null,{"$f":"+C14","v":"Cash to Capital"},{"$nulls":9},{"$f":"SUM(F21:L21)","v":0}]
["cfdata",null,{"$f":"+C15","v":0},{"$nulls":9},{"$f":"SUM(F22:L22)","v":0}]
["cfdata",null,{"$f":"+C16","v":0},{"$nulls":9},{"$f":"SUM(F23:L23)","v":0}]
[]
["netoptitle","OPERATING IMPACT",{"$nulls":3},{"$f":"instructions!D11","v":2016},{"$f":"+F25+1","v":2017},{"$f":"+G25+1","v":2018}]
["netopdata","Operating costs"]
["netopdata","External Debt and finance charges"]
["netopdata","Transfer to General Capital Fund"]
["netoptotal","Total Direct Costs",{"$nulls":3},{"$f":"SUM(F26:F28)","v":0},0,0]
["netopless","Less: Incremental Revenue/Recovery"]
["netoptotal","Net Cost/(Benefit)",{"$nulls":3},{"$f":"+F29-F30","v":0},{"$f":"+G29-G30","v":0},0]
["netopdata","    "]
["netoptotal","Incremental Full Time Equivalent Positions ",{"$nulls":3},0,0,0]
[]
[]
["note","Class Estimate:",null,"Select from a drop down list"]
["note"]
["note","Sample"]
["note","The current funding requirements are based on planning level assessments and are subject to a great deal of uncertainty.  These funding requirements will be revised as engineering progresses; cost estimates will be updated to class 3 prior to construction. "]
["note","Detailed design work in 2016 will provide a class 3 cost estimate prior to construction in 2017.  "]
["note","Preliminary scoping is being undertaken to update project to class 3 cost estimate prior to construction."]
["note","Several distinct projects within the program will require a class 3 or better estimate and a cost benefit for each before construction can begin."]
["note"]
["note","These cells are set to wrap text but the row height may need to be manually adjusted to show the wrapped portion."]
["note","- Input project description, including project timeframe, justification, and maps if applicable."]
["note","- Include the estimated life of the asset in this narrative."]
["note","- Provide specifics on cross-jurisdictional agreements."]
[null,"- If the project is on-going use the following in the narrative:"]
["img"]
[null,"* N/A - No amounts have been included in the \"Previous Budgets\" due to this project's on-going nature."]