{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Instructions","Basic Information","Financial Reporting ","Reporting on Results","Supporting Documents","Acknowledgement of Compliance","Program Evaluation","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":2,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":1,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[19,0,19,3],[0,0,0,1],[1,0,1,1],[2,0,2,1],[4,0,4,1],[18,0,18,3],[26,0,33,0],[5,0,5,3],[6,0,6,3],[8,0,8,3],[13,0,13,3],[11,0,11,3],[12,0,12,3],[17,0,17,3],[14,0,14,3],[10,0,10,3],[7,0,7,3],[9,0,9,3],[16,0,16,3],[15,0,15,3],[21,0,21,1],[22,0,22,3]]}
["Municipal Affairs"]
["Regional Collaboration Program"]
["Due: Various dates (refer to Program Guidelines)"]
[]
["Reporting Form Instructions"]
[]
["Basic Information "]
["This tab contains basic information such as key contact information for the grant recipient submitting the report as well as program contact information if there are any questions on completing the requirements. "]
["Financial Reporting "]
["The financial reporting tab is a statement of funding and expenditures. Specific instructions for completing the various fields in this report are noted as comments in the specific cells. "]
["Reporting on Results "]
["The information collected in this tab is used to assess the progress of the project in meeting its expected outputs (as originally identified in the application form). Any variance from the expected results to the actual results achieved should be explained. "]
["Supporting Documents "]
["Supporting documents could include evidence that funding was spent in accordance with the conditions of the grant agreement or any additional requirements that are specifically relevant to the nature of the program or type of projects and activities funded. "]
["Acknowledgement of Compliance "]
["The Acknowledgement of Compliance is a certification by the required authority that program funds were used in accordance with conditions of the grant agreement. This needs to be printed, signed and submitted with the report. "]
["Program Evaluation"]
["This section is optional to complete. The purpose of the program evaluation is to provide an opportunity for the grant recipient to share thoughts and suggestions on the grant program. This information will be used by the program to evaluate results and determine where improvements can be made for subsequent years of the program. "]
["Legal Statement"]
["The personal information being collected on this form will be used to administer the Regional Collaboration Program.\nThe personal information is being collected under the authority of section 33(c) of the Freedom of Information and Protection of Privacy (FOIP) Act and will be managed in accordance with the privacy provisions in the FOIP Act. If you have any questions concerning the collection of this information, please contact the Director, Municipal Grants, Alberta Municipal Affairs, 17th Floor, \n10155 - 102 Street, Edmonton, Alberta, T5J 4L4."]
[]
["Method of Submission "]
[]
[]
["Method of Submission","Submit the signed reporting package via mail, fax, or email.   It is only necessary to submit your reporting using one method."]
[]
["Submission Address","Alberta Municipal Affairs"]
[null,"Grants and Education Property Tax Branch"]
[null,"Municipal Grants Unit"]
[null,"17th Floor, 10155 – 102 Street"]
[null,"Edmonton, AB   T5J 4L4"]
[]
[null,"Fax: 780-422-9133"]
[null,"rcp.grants@gov.ab.ca"]

{"sheet":"Basic Information","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,4,24,5],[25,2,25,3],[24,2,24,3],[13,0,14,0],[25,4,25,5],[13,1,14,5],[15,1,16,5],[22,0,22,5],[15,0,16,0],[17,1,18,5],[17,0,18,0],[0,0,0,4],[1,0,1,4],[2,0,2,3],[11,1,12,5],[8,0,8,5],[10,1,10,5],[11,0,12,0],[9,1,9,5]]}
[{"$f":"Instructions!A1","v":"Municipal Affairs"}]
[{"$f":"Instructions!A2","v":"Regional Collaboration Program"}]
[{"$f":"Instructions!A3","v":"Due: Various dates (refer to Program Guidelines)"}]
[]
["Basic Information"]
[]
["1. Municipality / Organization information"]
[]
["Information of primary contact at municipality/organization"]
["Name of municipality / organization"]
["Legal status"]
["Contact name and title"]
[]
["Contact primary phone number "]
[]
["Contact email address"]
[]
["Contact mailing address"]
[]
[]
["2. Program assistance"]
[]
["Please contact your local Regional Collaboration Prgram representative for assistance on completing the reporting requirements"]
[]
["Office of program contact","Program Component","Contact phone number",null,"Contact email address (if applicable)"]
["Municipal Affairs         Compliance Advisor ","Regional Collaboration, Municipal Internship, Mediation and Cooperative Processes, Organization Sponsorship, and Strategic Initiatives","780-427-2225",null,"rcp.grants@gov.ab.ca"]

{"sheet":"Financial Reporting ","index":3,"n_rows":51,"n_cols":22,"rows_kept":51,"cut":false,"hidden":false,"merged":[[9,9,11,9],[33,7,33,8],[48,0,51,11],[50,12,50,14],[50,16,50,18],[38,12,42,19],[43,12,44,19],[46,14,46,15],[46,16,46,18],[28,4,28,6],[29,4,29,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[14,21,31,22],[37,21,48,22],[27,4,27,6],[30,4,30,6],[31,4,31,6],[48,12,49,14],[47,14,47,15],[48,16,49,18],[32,7,32,8],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[0,0,0,4],[1,0,1,4],[2,0,2,3],[4,0,4,8],[14,4,14,6],[12,4,12,6],[13,4,13,6],[10,4,11,6],[10,7,11,7],[9,8,11,8],[5,20,5,22],[6,21,8,22],[7,0,7,19],[8,0,8,3],[8,19,11,19],[9,4,9,7],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,20,11,20],[10,21,11,23],[9,18,11,18],[9,17,11,17],[9,10,11,10],[9,11,11,11],[4,11,4,12],[9,14,11,14],[9,15,11,15],[9,12,11,12],[9,13,11,13],[4,13,4,17],[9,16,11,16]]}
["Municipal Affairs"]
["Regional Collaboration Program"]
["Due: Various dates"]
[]
["Statement of Funding and Expenditures",null,null,null,null,null,null,null,null,"Please note comment in the cell to the left",null,"For Reporting Period:"]
["Municipality/ Organization Name",{"$f":"'Basic Information'!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A separate statement is required for each grant program"]
["PROJECT EXPENDITURE LIST"]
["{1}",null,null,null,"{2}",null,null,null,"{3}","{4}","{5}","{6-a}","{6-b}","{6-c}","{7}","{8}","{9}","{10}",null,"This Column for Municipal use only  "]
["Project ID",null,null,null,"Project Description",null,null,null,"Project Status as at Reporting Date","Provincial share of qualifying project costs remaining from previous years to be funded from grant program ","Actual Project Expenditures ","Non-Eligible Items: GST,  Admin, Developer contribution etc.","Other Program Grants and Interest Applied","This Program Interest Earned Applied","Net Eligible Project Expenditures","Grant plus Interest Earned Applied to Expenditures","Maximum Reporting Year Provincial Share Eligible","Municipal Contribution","Provincial share of qualifying project costs remaining to be funded from future year grant program allocations"]
["Project Number","Program Component","Phase No.","Additional project identifier information","Project Name",null,null,"Project Activity Details per Conditional Grant Agreement                                       (if required)",null,null,null,null,null,null,null,null,null,null,null,null,"<","Pass mouse over this area to view comments and instructions for each column"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K13-L13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K14-L14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"All totals are calculated automatically when using the Excel version of this form"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,"SUB TOTAL THIS PAGE",null,{"$f":"SUM(J13:J32)","v":0},0,0,0,0,0,{"$f":"SUM(P13:P32)","v":0},null,{"$f":"SUM(R13:R32)","v":0}]
[null,null,null,null,null,null,null,"TOTAL ALL PAGES",null,{"$f":"J33","v":0},{"$f":"SUM(K$31)","v":0},0,0,0,0,0,{"$f":"Q33","v":0},{"$f":"R33","v":0},{"$f":"S33","v":0}]
[null,null,null,null,"Note:  All projects listed on this statement must first be accepted on a previously submitted grant application for this reporting year."]
[]
[]
["GRANT / INTEREST SUMMARY",null,null,null,null,null,null,null,null,null,null,null,"CERTIFICATION",null,null,null,null,null,null,null,null,"This statement may not be accepted by the grant program until it is signed by the Chief Administrative Officer who are personally responsible for the content and are authorized to make this certification."]
[null,null,null,null,null,null,null,"GRANT",null,null,"INTEREST & other INCOME",null,"This is to certify that all information contained in this Statement of Funding and Expenditures is a true and correct representation of actual funding and expenditures and that this information complies with the Guidelines, Administrative Procedures, and other relevant documentation for the Regional Collaboration Program.  It also certifies that all non-shareable costs defined for this program have been deducted from the total cost or otherwise excluded from the amounts identified as Net Eligible Project Expenditures."]
[]
["Amount Carried Forward from",null,null,null,null,null,"(1)"]
["ENTER",null,"Grant Received ",null,null,null,"(2)"]
["ADD:",null,"Interest Earned",null,null,null,"(3)"]
["TOTAL AMOUNT AVAILABLE",null,null,null,null,null,"(4)=(1+2+3)",{"$f":"SUM(H41:H43)","v":0},null,null,null,null,"In all respects, the information in this Statement complies with the terms of the Conditional Grant Agreement between Municipal Affairs and the Municipality/Organization. "]
["LESS:",null,"Expenditures (Grant Applied)",null,null,null,"(5)",{"$f":"P33","v":0}]
["Project Variance",null,null,null,null,null,"(6)=(4-5)",{"$f":"H44-H45","v":0}]
[null,null,""]
["Comments",null,null,null,null,null,null,null,null,null,{"$f":"IF(Q34>R34,Q34-R34,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,"Chief Administrative Officer"]

{"sheet":"Reporting on Results","index":4,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[45,0,45,3],[44,0,44,3],[32,0,34,0],[35,0,36,0],[38,0,38,3],[39,0,40,0],[41,0,41,3],[28,0,28,3],[29,0,31,0],[24,0,25,0],[0,0,0,3],[1,0,1,3],[2,0,2,3],[8,0,8,3],[18,0,18,3],[20,0,20,3],[22,0,23,0]]}
[{"$f":"Instructions!A1","v":"Municipal Affairs"}]
[{"$f":"Instructions!A2","v":"Regional Collaboration Program"}]
[{"$f":"Instructions!A3","v":"Due: Various dates (refer to Program Guidelines)"}]
[]
["Reporting on Results"]
[]
["Functional Category of Project"]
[]
["Identify the functional category(ies) under which the project applies and indicate what percentage of total actual project costs were spent per category. If there were no expenditures made under the functional category, insert \"0%\" in the \"% of Total Actual Project Costs column.\" "]
[]
["Functional Category of the Project","% of Total Actual Project Costs"]
["Governance"]
["Planning and Development"]
["Municipal Careers"]
["Total",{"$f":"SUM(B12:B14)","v":0}]
[]
["Anticipated Project Results"]
[]
["Identify the outputs that were achieved by the project. Referring to your original application, Section\n\"4. Functional Category Details\", will assist you in completing this portion. "]
["Output","Category","Actual Quantity","Unit"]
["Governance:  Activities that support the ongoing management of the municipality through its elected officials."]
["Reports and studies","Regional governance exploration or implementation",null,"Number of reports/studies"]
["Agreements","Resolved conflict",null,"Number of resolved conflicts"]
[null,"Cooperation protocols",null,"Number of cooperation protocols established"]
["Policies","New",null,"Number of policies developed"]
[null,"Revised",null,"Number of policies revised"]
["Revenue/cost-sharing models","Models",null,"Number of models developed"]
["Regional Service Commissions (RSC)","Start-up costs",null,"Number of RSC Start-ups"]
["Planning and Development:  Activities that contribute to land use planning, integrated community sustainability planning, or planning related to specific municipal function or service."]
["Reports or studies","Capacity building",null,"Number of reports/studies"]
[null,"Regional collaboration",null,"Number of reports/studies"]
[null,"Cooperation assessment",null,"Number of reports/studies"]
["Regional plans","Land Use",null,"Number of plans developed"]
[null,"Service delivery",null,"Number of plans developed"]
[null,"Business Plan",null,"Number of plans developed"]
["Start-up activities","Communications",null,"Number of activities undertaken"]
[null,"Information management systems",null,"Number of systems established"]
["Consultation","Consultations",null,"Number of consultations undertaken"]
["Municipal Careers:  Activities that support the retention and attraction of skilled employees of local governments."]
["Placement of municipal intern in a participating municipality or service agency","Administrator",null,"Number of municipal interns"]
[null,"Land Use planner",null,"Number of municipal interns"]
["For any of the above Functional Categories (Governance, Planning and Development, or Municipal Careers."]
["Other output (identify)",null,null,"Number"]
[]
["If there were variances from the expected results to the actual results achieved, please explain."]

{"sheet":"Supporting Documents","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,25,0],[24,1,25,3],[9,0,9,8],[6,1,6,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[7,1,7,8],[8,1,8,8],[10,0,10,8],[16,0,17,0],[16,1,17,3],[12,0,13,3],[12,4,13,5],[14,0,15,0],[14,1,15,3],[11,0,11,8],[22,0,23,0],[22,1,23,3],[18,0,19,0],[18,1,19,3],[20,0,21,0],[20,1,21,3]]}
["Municipal Affairs"]
["Regional Collaboration Program"]
["Due: Various dates (refer to Program Guidelines)"]
[]
["Supporting Documents"]
[]
[1,"Provide the documents listed in the table below. "]
[2,"Submit supporting documentation via mail, fax, or email.   It is only necessary to submit your application using one method. "]
[3,"If you have any questions on the completion of this section, please please refer to the \"Basic Information\" tab for program contact information"]
[]
["Supporting Documents Checklist"]
["Check \"Yes\" for each supporting document required, as applicable. "]
["Required documentation",null,null,null,"Submitted (Yes/No)"]
[]
[1,"Municipal Internship Program for Administrators - Interim Report Questions for Supervisors",null,null,"Yes",null,false]
[null,null,null,null,"No",null,false]
[2,"Municipal Internship for Program Administrators - Final Report for Supervisors",null,null,"Yes",null,false]
[null,null,null,null,"No",null,false]
[3,"Municipal Internship Program for Land Use Planners - Interim Report Questions for Supervisors",null,null,"Yes",null,false]
[null,null,null,null,"\n\nNo",null,false]
[4,"Municipal Internship Program for Land Use Planners - Year One Report Requirements for Supervisors",null,null,"Yes",null,false]
[null,null,null,null,"\nNo",null,true]
[5,"Municipal Internship Program for Land Use Planners - Final Report Requirements for Supervisors",null,null,"Yes",null,false]
[null,null,null,null,"\n\nNo",null,false]
[6,"Collaborative Governance Initiative -  Final Project Report (Assessment Phase)",null,null,"Yes",null,false]
[null,null,null,null,"No",null,false]

{"sheet":"Acknowledgement of Compliance","index":6,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[42,0,42,3],[42,5,42,7],[37,5,37,7],[37,0,39,3],[41,0,41,3],[21,1,21,8],[20,1,20,9],[36,5,36,7],[41,5,41,7],[36,0,36,3],[32,5,32,7],[29,0,29,3],[32,0,32,3],[29,5,29,7],[31,0,31,3],[25,0,28,3],[25,5,28,7],[23,1,23,8],[31,5,31,7],[24,1,24,8],[15,11,18,19],[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[6,0,6,8],[18,1,18,8],[17,4,17,7],[10,6,10,8],[11,6,11,8],[15,1,16,8],[17,1,17,3],[11,0,11,5],[13,0,14,9],[9,0,9,8]]}
[{"$f":"Instructions!A1","v":"Municipal Affairs"}]
[{"$f":"Instructions!A2","v":"Regional Collaboration Program"}]
[{"$f":"Instructions!A3","v":"Due: Various dates (refer to Program Guidelines)"}]
[]
["Acknowledgement of Compliance"]
[]
["Certification"]
[]
["Name of Municipality / Organization"]
[{"$f":"'Basic Information'!B10","v":0}]
["Name of Project",null,null,null,null,null,"Grant Amount\n"]
[]
[]
["I certify that the following information is true and correct. "]
[]
[1,"The entire grant (plus any income earned, if applicable) was used for the purpose(s) stated in the conditional grant agreement, without material alteration, as signed by the Minister of "]
[]
[null,"Municipal Affairs, or his delegate on ",null,null,"<insert date that agreement was signed> ",null,null,null," or as amended on"]
[null,"<insert date of agreement amendment if applicable Month/DD/Year>."]
[]
[2,"The grant (plus any income earned, if applicable) was expended and the work was completed by "]
[null,"<insert date Month/DD/YYYY>."]
[]
[3,"The municipality / organization did not use any portion of the grant to pay for work done or materials obtained before "]
[null,"<insert date from clause under section 2 of the grant agreement (or date agreement signed) Month/DD/YYYY>."]
[]
[]
[]
[]
["Chief Administrative Officer",null,null,null,null,"Date"]
[]
[]
["Print Name",null,null,null,null,"Telephone Number"]

{"sheet":"Program Evaluation","index":7,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[37,0,46,8],[9,0,18,8],[5,0,5,8],[36,0,36,8],[22,0,22,8],[23,0,32,8],[6,0,6,8],[20,0,20,8],[8,0,8,8],[34,0,34,8]]}
[{"$f":"Instructions!A1","v":"Municipal Affairs"}]
[{"$f":"Instructions!A2","v":"Regional Collaboration Program"}]
[{"$f":"Instructions!A3","v":"Due: Various dates (refer to Program Guidelines)"}]
[]
["Program Evaluation"]
[]
["Grant Program Structure"]
[]
["Please provide comments and ideas for the future with regards to how the grant program helps your municipality / organization meet its needs. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Grant Program Administration"]
[]
["Please provide comments and ideas for the future with regards to the administration of the grant program. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Other Comments"]
[]
["Please provide other comments you have regarding the grant program."]

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