{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Eligible & Ineligible Costs","1. Budget - Pilot Project","2. Sources of Funding","Phases"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["WORK PLAN AND BUDGET - PILOT PROJECT"]
["INSTRUCTIONS\n▪ PHASES: A phase is defined as a collection of tasks aimed at completing a major deliverable (a milestone). GMF mandatory phases must be included in your workplan, as indicated in the table below. If any phase has already been completed, or is not part of your study, explain in the “Notes” section below.  For details, see the Phases worksheet.\n▪ ADDITIONAL PHASES: You cannot add phases to the workplan due to the template structure, but you can edit the two additional blank phases at the bottom of the table. \n▪ START/END DATES: Enter the estimated start and end dates for each phase. Note: FCM expects that in most circumstances, funded initiatives will be complete within three years of the date of approval. This requirement will be noted in your contract with FCM."]
["▪ TASKS: A task is defined as a single activity undertaken to achieve a phase. For each task identified, provide a description of what it entails and estimate the cost. Individual tasks should generally be less than $50,000. Costs should be separated into GMF’s eligible and ineligible categories. Refer to the eligible and ineligible costs table for a list of costs that can be partially reimbursed by FCM. \n▪ IN-KIND COSTS: The budget should include cash costs only.  Add eligible or ineligible in-kind costs to the “In-kind costs” rows near the bottom of the table. Note that eligible in-kind costs cannot exceed 10 per cent of the total eligible costs. \n▪ CONTINGENCY COSTS: Contingency costs are eligible, but cannot be listed as a separate budget item. Allocate contingency costs within the relevant budget items as and where appropriate, and add an explanation of the contingency percentage or amount in the “Contingency costs” section below the table."]
["▪ PUBLIC and/or STAKEHOLDER CONSULTATION:  Specify when and how public and/or stakeholder consultation will be conducted by adding task(s) to one or more phases, as necessary.\n▪ TAXES: You may include the portion of taxes for which your organization is not eligible for a rebate (provincial, territorial, or federal) in your budget. Allocate this amount within the relevant tasks as and where appropriate.\n▪ DELETING ROWS: Rows cannot be deleted, due to the template’s structure. Please leave extra or empty rows blank."]

{"sheet":"Eligible & Ineligible Costs","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["GMF Eligible and Ineligible Costs — Pilot Projects"]
["This table outlines what costs can be partially reimbursed by FCM. Please pay particular attention to any costs that may be ineligible."]
["Note: If your application is approved, expenses that are eligible for partial reimbursement must be: \n· incurred after the date the application is received by FCM (except consulting services to prepare the application undertaken up to 90 days prior to receipt of the application by FCM).\n·  invoiced directly to your organization.\n·  an integral and an essential component of the initiative and required to help achieve the environmental objective of the initiative.\n· actually and reasonably incurred in accordance with applicable industry standards.\n·  accompanied by backup documentation (i.e. invoices) if the expense is over $1,000. Please also include invoices submitted by subcontractors. The backup documentation must equal at least 50% of the total eligible costs claimed (excluding in-kind).\n"]
[]
["Cost Category","Eligible costs","Ineligible costs"]
["Section A: Costs incurred prior to date application received by FCM"]
["1) Pre-application","Consulting costs to write the GMF application incurred up to 90 days prior to application receipt date","All other costs incurred prior to application receipt date"]
["Section B: Costs incurred after date application received by FCM"]
["2) Administrative ","Administrative costs that are directly linked to and have been incurred for the pilot project, such as: ","Office space, supplies and general overhead costs incurred in the ordinary course of business."]
[null,"·         communication costs (e.g. long-distance calls or faxes) "]
[null,"·         permits or certifications required for the pilot project"]
[null,"·         printing or photocopying by outside suppliers"]
[null,"·         acquisition of documents used exclusively for the pilot project"]
[null,"·         document translation"]
["3) Advertising ","Advertising costs essential to communicating the pilot project to the public, as well as pilot project evaluation such as: ","·         Advertising costs for general education or publicity that is a result of ongoing or other business activity and not a specific requirement of the pilot project."]
[null,"·         fees for advertising development","·         Promotional items."]
[null,"·         fees for media distribution"]
[null,"·         website development"]
[null,"·         public surveys"]
["4) Audit","The cost of a financial audit if required by FCM."]
["5) Capital","Rental or purchase of equipment or assets which are essential for conducting the small-scale activity. This would include specialized system hardware and software, construction costs, materials, renovation and modernization costs, and installations costs.","·         Any major capital costs."]
[null,null,"·         Purchase or lease of real property."]
["6) Equipment rental","Rental of tools and equipment.","Rental of tools or equipment related to ongoing or other business activities."]
["7) Meetings and public gatherings","Costs related to meetings and public gatherings that communicate the pilot project to the public and that collect feedback, such as:","Any hospitality expenses such as:"]
[null,"·         facility rental ","·         food and drink"]
[null,"·         audiovisual equipment rental ","·         alcohol"]
[null,null,"·         door prizes"]
[null,null,"·         entertainment"]
[null,null,"·         music"]
[null,null,"·         decorations"]
[null,null,"·         flowers, centerpieces"]
["8) Services","Fees for professional or technical consultants and contractors.","·         Any costs associated with person(s) enrolled on your organization’s payroll, except for those defined under the category listed as “in-kind.”"]
[null,null,"·         Costs for engineering studies, audit studies or feasibility studies for which grants or contributions are provided by or committed to be provided by any program of the Government of Canada."]
["9) Supplies and materials","Supplies and materials that are specifically needed to undertake the pilot project. ","Costs related to ongoing or other business activities, and not a specific requirement of the pilot project."]
["10) Transportation, shipping and courier charges","Transportation costs for delivery of materials and services essential for the pilot project. ","Any transportation expense related to ongoing or other business activities. "]
["11) Travel and accommodation","Travel and associated expenses for you and consultants to the extent that the travel and accommodation rates comply with Treasury Board of Canada guidelines and to the extent the such travel is necessary to conduct the pilot project.","·   Travel and associated expenses of a partner in the project."]
[null,null,"·   Travel, accommodation and fees to attend conferences, missions, trade shows, etc."]
["12) Taxes","The portion of taxes for which your organization is not otherwise eligible for rebate.","The portion of taxes for which your organization is eligible for rebate (provincial, territorial or federal)."]
["In-kind","Contribution of staff time by your organization’s employees (including permanent and contract employees). The value of the total in-kind contributions for staff salaries or other remuneration cannot exceed 10% of the other eligible costs. ","·   In-kind contribution of goods and services other than salaries."]
[null,"To claim this type of in-kind contribution, you will have to submit a letter from an authorized officer within your organization confirming the details of the in kind contribution.","·   In-kind contribution made by anyone other than your organization."]
[null,null,"·   In-kind contribution by your organization above 10% of eligible costs."]

{"sheet":"1. Budget - Pilot Project","index":2,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["WORK PLAN AND BUDGET - PILOT PROJECT"]
["Lead Applicant:"]
["Project title:"]
["Phases","Start date","End date","Eligible Costs ($)","Ineligible Costs ($)","Total Costs ($)"]
["Phase 1: Develop pilot plan","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D6+E6","v":0}]
["[Add task description here]",null,null,null,null,{"$f":"D7+E7","v":0}]
["[Add task description here]",null,null,null,null,{"$f":"(D8+E8)","v":0}]
["[Add task description here]",null,null,null,null,{"$f":"(D9+E9)","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,{"$f":"D11+E11","v":0}]
["[Add task description here]",null,null,null,null,{"$f":"D12+E12","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 1 Subtotal",null,null,null,null,{"$f":"SUM(F6:F17)","v":0}]
["Phase 2: Prepare and set up pilot","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D20+E20","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 2 Subtotal",null,null,null,null,{"$f":"SUM(F20:F29)","v":0}]
["Phase 3: Conduct pilot","mm/yyyy","mm/yyyy","u"]
["[Add task description here]",null,null,null,null,{"$f":"D32+E32","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 3 Subtotal",null,null,null,null,{"$f":"SUM(F32:F41)","v":0}]
["Phase 4: Analyze and make recommendations","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D44+E44","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 4 Subtotal",null,null,null,null,{"$f":"SUM(F44:F53)","v":0}]
["Phase 5: Reporting","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D56+E56","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 5 Subtotal",null,null,null,null,{"$f":"SUM(F56:F65)","v":0}]
["Phase 6: Additional Phase","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D68+E68","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 6 Subtotal",null,null,null,null,{"$f":"SUM(F68:F77)","v":0}]
["Phase 7: Additional Phase","mm/yyyy","mm/yyyy"]
["[Add task description here]",null,null,null,null,{"$f":"D80+E80","v":0}]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["[Add task description here]",null,null,null,null,0]
["Phase 7 Subtotal",null,null,null,null,{"$f":"SUM(F80:F89)","v":0}]
["Subtotal - Cash costs:",null,null,{"$f":"(SUM(D6:OFFSET(D91,-1,0)))","v":0},{"$f":"(SUM(E6:OFFSET(E91,-1,0)))","v":0},{"$f":"D91+E91","v":0}]
["In-kind costs (Lead applicant - staff time)  - Change ONLY if less than 10% of Eligible Cash Costs",null,null,{"$f":"ROUNDDOWN((0.1*D91), -2)","v":0},0,{"$f":"D92+E92","v":0}]
["In-kind costs (Other)",null,null,"n/a",0,{"$f":"E93","v":0}]
["Total Costs",null,null,{"$f":"D91+Protection","v":0},{"$f":"E91+E92+E93","v":0},{"$f":"D94 + E94","v":0}]
[]
[null,null,null,"Total Eligible Costs",null,{"$f":"D94","v":0}]
[]
["NB: Click on the Calculate Budget button to round budget off to the nearest $100."]
[]
[]
["Contingency costs: Have you included room for contingencies in some or all of your task costs? Please explain."]
["[Add explanation about contingency here]"]
[]
["Other Notes:"]
["[Add any other relevant details about your workplan and budget here]"]

{"sheet":"2. Sources of Funding","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["SOURCES OF FUNDING"]
["INSTRUCTIONS\nEnter all funding sources for this environmental or sustainable initiative. For each funding source, please indicate the amount of the funding, and when the funding is confirmed or expected to be confirmed. The total of all funding sources must equal the total project costs in your Workplan and Budget table (tab 1). \nThe municipal government's cash contribution must be at least 10 per cent of the eligible costs for a pilot project. \n\nNote: FCM offers grants, which cover up to 50% of eligible costs to a maximum of $350,000, to undertake eligible pilot projects. The spreadsheet will auto-calculate the maximum eligible GMF grant amount according to the Total Eligible Costs in the budget. FCM will cap the GMF grant amounts according to the other confirmed sources of funding."]
["Funding source","Description","Confirmed (Y/N)","Date Committed\nDD-MM-YYYY","Amount","Percentage of Total Budget"]
["Green Municipal Fund","Grant","N",null,{"$f":"ROUND(MIN(0.5*'1. Budget - Pilot Project'!F96, 350000), -2)","v":0},{"$f":"E4/$E$25","v":{"$error":"#DIV/0!"}}]
["Municipality X","Cash",null,null,null,{"$f":"E5/$E$25","v":{"$error":"#DIV/0!"}}]
["Lead Applicant","In-kind",null,null,{"$f":"'1. Budget - Pilot Project'!D92","v":0},{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
["Additional Funding Source",null,null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Total Funding:",{"$f":"SUM(E4:OFFSET(E22,-1,0))","v":0}]
["[Should equal Total Costs from the Workplan and Budget Table, below]"]
[]
[null,null,"Budget Total Costs",null,{"$f":"'1. Budget - Pilot Project'!F94","v":0}]
[null,null,"Budget Total Eligible Costs",null,{"$f":"'1. Budget - Pilot Project'!F96","v":0}]

{"sheet":"Phases","index":4,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Phases for pilot projects"]
["Phase A: Develop pilot plan"]
["The first phase entails planning the details of how the pilot project will be conducted. Tasks may include setting pilot objectives, determining the methodology and designing the pilot (duration of the testing, the sampling methodology, etc.), and establishing performance measures or criteria to evaluate the pilot results. If a task has already been completed, please specify this."]
["Phase B: Prepare and set up pilot"]
["In this phase, tasks could include applying for and obtaining necessary permits or approvals, leasing and setting up equipment, materials and/or procedures in accordance with the pilot plan."]
["Phase C: Conduct pilot"]
["Tasks in this phase may include testing the equipment, materials and/or procedures, monitoring the testing as it proceeds and collecting data."]
["Phase D: Analyze and make recommendations"]
["During this phase, tasks should include analyzing the data, evaluating the results, and making recommendations for full-scale implementation of the municipal environmental project. The analysis should include an evaluation of the environmental and financial impacts of full-scale implementation, if this is recommended. A municipal environmental project is a project that responds to a municipal need and contributes to cleaner air, water, and/or soil, and/or reduces greenhouse gas emissions. The recommendations should respond to the objectives of the pilot project, and indicate the next steps in the process toward implementation."]
["Phase E: Reporting"]
["The last phase requires preparation of a final version of the pilot report, and council approval for it."]