{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Application ","Appendix A","Appendix B"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":12,"comments":1,"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":130,"n_cols":14,"rows_kept":130,"cut":false,"hidden":false,"merged":[[127,0,127,37],[128,1,128,37],[129,1,129,37],[130,0,130,37],[119,0,119,37],[120,0,120,37],[121,0,121,37],[122,0,122,37],[123,1,123,37],[124,0,124,37],[125,1,125,37],[126,0,126,37],[110,0,110,37],[111,0,111,37],[112,0,112,37],[113,0,113,37],[114,0,114,37],[115,0,115,37],[116,0,116,37],[117,0,117,37],[118,0,118,37],[101,1,101,37],[102,0,102,37],[103,0,103,37],[104,0,104,37],[105,1,105,37],[106,0,106,37],[107,0,107,37],[108,0,108,37],[109,0,109,37],[93,0,93,37],[94,0,94,37],[95,1,95,37],[96,0,96,37],[97,0,97,37],[98,0,98,37],[99,0,99,3],[99,4,99,37],[100,0,100,37],[84,0,84,37],[85,0,85,37],[86,0,86,37],[87,1,87,37],[88,0,88,37],[89,0,89,37],[90,0,90,37],[91,1,91,37],[92,0,92,37],[76,0,76,37],[77,0,77,37],[78,0,78,37],[79,0,79,4],[79,5,79,37],[80,0,80,37],[81,0,81,37],[82,0,82,37],[83,1,83,37],[68,0,68,37],[69,0,69,4],[69,5,69,37],[70,0,70,37],[71,0,71,37],[72,0,72,37],[73,0,73,37],[74,0,74,37],[75,0,75,4],[75,5,75,37],[60,0,60,37],[61,0,61,37],[62,0,62,37],[63,0,63,4],[63,5,63,37],[64,0,64,37],[65,0,65,37],[66,0,66,37],[67,0,67,37],[52,0,52,37],[53,0,53,37],[54,0,54,37],[55,0,55,37],[56,0,56,37],[57,0,57,2],[57,3,57,37],[58,0,58,37],[59,0,59,4],[59,5,59,37],[43,0,43,37],[44,0,44,37],[45,0,45,37],[46,0,46,37],[47,1,47,37],[48,0,48,37],[49,0,49,37],[50,0,50,37],[51,0,51,37],[36,0,36,37],[37,0,37,37],[38,0,38,37],[39,0,39,37],[40,0,40,37],[41,1,41,37],[42,0,42,37],[35,0,35,37],[32,0,32,37],[33,0,33,37],[34,0,34,37],[0,0,0,12],[0,13,0,37],[1,0,2,37],[3,0,3,37],[4,0,4,37],[6,0,6,37],[7,0,7,37],[8,0,8,37],[9,0,9,37],[30,0,30,37],[31,0,31,37],[5,0,5,37],[10,0,10,37],[11,0,11,37],[12,0,12,37],[13,0,13,37],[25,0,25,37],[26,0,26,37],[27,0,27,37],[28,0,28,37],[29,0,29,37],[14,0,14,37],[15,0,15,37],[16,0,16,37],[17,0,17,37],[18,0,18,37],[19,0,19,37],[20,0,20,37],[21,0,21,37],[22,0,22,37],[23,0,23,37],[24,0,24,37]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax Credits Available\n in Resource Regions\nVersion : 2016-05-01"]
["Instructions – \nApplication for an Employee Certificate - for Base Calendar Year"]
[]
["This document is intended for companies that hold an initial qualification certificate for one of the tax credits available in resource regions, namely the tax credit for processing activities in resource regions, the tax credit for Gaspésie and Certain Maritime Regions of Québec, and the tax credit for Aluminum Valley. It describes the procedure for completing the application form for employee certificate for base calendar year. Claims for tax credits are made by completing a CO-17 income tax return with the relevant schedules, and filing it with Revenu Québec within the prescribed deadline."]
[]
["We strongly recommend that you refer to the detailed fact sheet on our website regarding the tax credit concerned by the application before filling out this form. Be sure to use the latest version of the form.  You can also consult Chapiter XI of Schedule A of the Act respecting the sectoral parameters of certain fiscal measures, which includes all the sectoral parameters applicable to these measures. "]
[]
["APPLICABLE DEADLINES FOR FISCAL YEARS STARTING BEFORE MARCH 27, 2015"]
["Under the Taxation Act, the corporation has eighteen (18) months to submit an application for a tax credit to Revenu Québec; the application must include the business qualification certificate and employee certificates issued by Investissement Québec. This deadline is mandatory but it may be extended by Revenu Québec in certain situations and under certain conditions, in particular when Investissement Québec receives a complete application by the last day of the fifteenth (15th) month following the end of the corporation's fiscal year, at the latest. "]
[]
["In general, Investissement Québec does not grant priority in processing files. Thus, if the Application for a Business Qualification Certificate and an Employee Certificate is filed after the end of the fifteenth (15th) month following the end of the corporation's fiscal year, Investissement Québec cannot guarantee that the corporation will obtain its certificates before the expiration of the eighteen (18) month period following the end of its fiscal year."]
[]
["Consequently, we strongly recommend that you file the Application for a Business Qualification Certificate and an Employee Certificate to Investissement Québec before the end of the fifteenth (15th) month following the end of the corporation's fiscal year during which the calendar year for which the corporation is claiming a credit ends. For example, if the fiscal year ends on March 31 2015, you must file your Application for a Business Qualification Certificate and an Employee Certificate for the 2014 calendar year no earlier than April 1, 2015 and before June 30, 2016."]
[]
["APPLICABLE DEADLINES FOR FISCAL YEARS STARTING AFTER MARCH 26, 2015"]
["In the 2015–2016 budget of March 26, 2015, the rules were amended regarding deadlines for submission of an application for a refundable tax credit for fiscal years starting after March 26, 2015."]
[]
["Filing of an application for an annual certificate with Investissement Québec"]
["The corporation must file its application for an annual qualification certificate with Investissement Québec before the expiration of the 15th month following the end of the corporation's fiscal year. If the application is filed after that date but before the expiration of the 18-month period following the end of the corporation's fiscal year, Investissement Québec may, at its discretion, accept the application if it considers that the grounds for the delay are reasonable and justify such a \"late\" application. Consequently, if you are in such a situation, please attach a document setting out the grounds for your delay."]
[]
["Nevertheless, an application for a qualification certificate filed with Investissement Québec after the expiration of the 18-month period will be refused."]
[]
["Submission of documents to Revenu Québec"]
["The corporation must submit its application for a tax credit and its certificates to Revenu Québec by the later of the following dates:\n   - The last day of the 18th month following the end of the corporation's fiscal year in question\n   - The last day of the 3-month period following the date of issuance of the certificates by Investissement Québec."]
[]
["In addition, only complete applications will be processed. Any application received prior to the end of the fiscal year in question will be returned to the applicant. "]
[]
["A complete application* includes:\n   - A duly completed and signed Application for a Business Qualification Certificate and an Employee Certificate;\n   - Appendices A and B;\n   - The corporation's non-consolidated financial statements (balance sheet and income statement) for the fiscal year in \n     question.**"]
["Note that Investissement Québec indicates the date of receipt of the complete application on the certificates. Consequently, it is your responsibility to respect the deadlines prescribed by Revenu Québec, since the corporation could otherwise lose its right to receive its tax credit for a given year. "]
["* Please note that the documents required for a complete application do not exempt the corporation from the obligation to provide the documents mentioned in section 5 of the Application for a Business Qualification Certificate and an Employee Certificate.   \n** Financial statements can be in draft form, provided that you send us a final version of the statements as soon as they are available."]
[]
["INFORMATION ABOUT COMPLETING THE FORMS"]
[]
["Application for an Employee Certificate for the Calendar Year of Eligibility"]
[]
["You must fill out this form for the base calendar year of the eligible corporation."]
[]
["Appendix A\n\nPlease provide the requested information (name, social insurance number, position, address of the establishment, employment period, number of pay periods, total salary, eligible salary) for each corporation employee who works in establishments located in regions eligible for the credits for resource regions."]
[]
["For administrative reasons, it is important to follow the format shown in the application forms and in the appendices."]
[]
[null,"Employment period"]
[]
["The employment period must be included in the calendar year covered by the application, i.e. between January 1 and December 31. If the corporation is closed during certain periods of the year (for instance, during the Christmas Holidays), these leave periods must be included in the employment period if the employee maintained his employment relation with the corporation. Accordingly, if the corporation closes its doors from December 25 to January 5, the date of the end of the employment period will be December 31 and the date of the beginning of the employment period will be January 1 if the employee was employed by the corporation at the beginning of the calendar year."]
[]
["Once the employment relation with the corporation is severed, the employee is no longer certified even if amounts are paid to him after his departure (such as vacation pay).\n\nFor instance, if an employee retires and his last day of work is December 4, 2014, the last period counted will be the one that includes December 4, 2014. If amounts were paid to him before the end of  2014 and even in 2015, the employee cannot be certified during these pay periods and may not be included as part of the application covering calendar year 2015."]
[]
[null,"Total number of pay periods worked"]
[]
["For each employee, indicate the number of pay periods worked during the employment period covered. In some cases, you must include periods where the employee was absent from work. In this regard, please refer to the “Exceptions” section below, which explains how to treat these exceptional cases. "]
[]
["The pay periods you must include in the calendar year covered by the application must end during the calendar year covered (between January 1 and December 31, inclusive), regardless of the date they are paid. For example, the pay period ending December 31, 2014 must be included in calendar year 2014, even if it is paid in January 2015.\n\n\n"]
[]
["Consequently, some years may have more pay periods than the normal number, which is 52 for employees paid on a weekly basis. For instance, in 2014, if the periods end on a Saturday, it is possible to have 53 pay periods for an employee who worked the whole year.\n\n"]
[]
["For instance, in the case mentioned in the third paragraph above, Revenu Québec could assign the vacation pay subsequently paid in 2015 or even in 2014 to a pay period ended before December 4, 2015."]
[]
[null,null,null," Exceptions"]
[]
[null,null,null,null,null,"a) Vacation "]
[]
["Generally, the pay period during which the employee is on vacation must be considered as worked, regardless of when the vacation pay is paid."]
[]
[null,null,null,null,null,"b) Employment insurance"]
[]
["A pay period during which an employee receives employment insurance in the event of a temporary lay-off or, of course, in the case of firing or dismissal (the employment relation is severed in the latter two cases) is not counted."]
[]
["A period during which the employee receives employment insurance for parental leave or sick leave must be counted (provided the employment relation is not severed)."]
[]
[null,null,null,null,null,"c) CSST"]
[]
["An employment period in which the employee receives CSST benefits for temporary disability or sickness must be counted."]
[]
["If the absence for sickness or disability is permanent, the period cannot be counted because the employment relation is severed."]
[]
[null,null,null,null,null,"d) Salary insurance"]
[]
["A period during which an employee receives salary insurance benefits paid by a third-party payer other than the corporation is counted provided, once again, the period of absence is temporary."]
[]
[null,null,null,null,null,"e) No income"]
[]
["A pay period during which an employee is laid off temporarily without pay or is on unpaid leave is not counted."]
[]
[null,"Number of eligible pay periods "]
[]
["For each employee, indicate the number of eligible pay periods for the employment period covered. An eligible pay period is one during which the employee devoted at least 75% of his time to eligible tasks. The percentage is calculated including overtime, if any."]
[]
[null,"Eligible salary"]
[]
["For each eligible employee, indicate the amount of eligible salary. The information collected by Investissement Québec on this account is used for statistical purposes only since Revenu Québec is solely responsible for validating eligibility for the calculation of the tax credit. For more information on this subject, please refer to the technical fact sheet on the tax measure concerned (on our website)."]
[]
[null,"Total salary for the year"]
[]
["For each employee, indicate the total salary paid according to Box A of the Relevé 1 slip issued or to be issued by the corporation for the employee for the base calendar year."]
[]
[null,"Comments"]
[]
["In this column, provide any additional information that may help us process your application more quickly.\n\nIf the total number of pay periods worked and the number of eligible periods are different, please state the reason why. A brief explanation is sufficient, for instance:"]
[]
[null,null,null,null,"• Employee on call;\n• Temporary layoff with return expected;\n• Less than 75% of time dedicated to supervision, support or conducting of eligible activities for certain periods (if necessary, please provide detailed time sheets).\n"]
[]
[null,"Employee working outside Québec "]
[]
["If, during a given pay period, an employee worked outside Québec more than 50% of the time, he is ineligible for the tax measure for that pay period. Please mention that in the comments column, if need be."]
[]
[null,"Employee assigned to research and development (SR&ED) activities"]
[]
["As described in the detailed fact sheet of the tax measure, an employee who devoted more than 25% of his time to SR&ED activities during a given pay period is ineligible for the tax measure for that pay period. If need be, please provide us with the time sheets used in the SR&ED report you file with Revenu Québec."]
[]
["Appendix B\n\nProvide a job description, including the percentage of time devoted to each task, for each position to which the employees of the corporationss establishments located in eligible regions are assigned."]
[]
["AGREEMENT ON THE EXCHANGE OF INFORMATION"]
["On October 7, 2009, Investissement Québec and Revenu Québec signed an agreement entitled “Entente portant sur l’échange de renseignements nécessaires à l’administration de mesures fiscales ou à l’application d’une loi fiscale” [agreement on the exchange of information required for the administration of fiscal measures or the enforcement of a tax statute]. Under that agreement, the two organizations can share information required for the exercise of their respective mandates without being obliged to ask for the consent of the individual in question. We disclose information to Revenu Québec solely within the framework of this agreement.  The Commission d'accès à l'information du Québec approved this agreement after analyzing the nature of the information provided and the reasons for which it would be disclosed, as well as the procedures adopted to ensure confidentiality and the security measures."]
[]
["FEES"]
[]
["Investissement Québec charges fees for the certificates it issues. If you wish to obtain more information about this, consult the rate schedule available on the website. "]
[]
["MAILING ADDRESSES AND HOW TO FILE THE APPLICATION FOR AN EMPLOYEE CERTIFICATE"]
["We recommend that you submit the signed application by e-mail to expedite processing of your application. For that purpose, please attach the duly signed page of the Application for an Employee Certificate in a PDF file."]
["The application can also be sent to one of the following mailing addresses."]
["In any case, be sure to send the electronic file containing your application (including appendices) and the supporting documents."]
["The signed applications regarding establishments in the administrative regions of Bas-Saint-Laurent, Côte-Nord, Gaspésie—Îles-de-la-Madeleine, Nord-du-Québec and Saguenay—Lac-Saint-Jean must be sent to the following address:"]
[null,"Investissement Québec\nDirection, Mesures fiscales (Québec)\nÉdifice Iberville 1\n1195, avenue Lavigerie, bureau 060\nQuébec (Québec)  G1V 4N3\nFax: 418 528-8480"]
[]
[" -","by email, to the following address: mfquebec@invest-quebec.com;"]
[]
["The signed applications regarding establishments in the administrative regions of Abitibi-Témiscamingue and Mauricie, or in the regional municipal counties (RCMs) of Antoine-Labelle, Pontiac and Vallée-de-la-Gatineau must be sent to the following address:"]
[null,"Investissement Québec\nDirection, Mesures fiscales (Montréal)\n1001, boulevard Robert-Bourassa, bureau 1000\nMontréal (Québec) H3B 4L4\nFax: 514 864-7933"]
[" -","by email, to the following address: mfmontreal@invest-quebec.com;"]

{"sheet":"Application ","index":1,"n_rows":88,"n_cols":35,"rows_kept":88,"cut":false,"hidden":false,"merged":[[43,0,43,25],[43,27,43,33],[44,0,44,25],[44,27,44,32],[41,27,41,33],[41,34,41,37],[40,34,40,37],[42,0,42,37],[37,0,37,33],[38,0,38,25],[38,26,38,33],[40,0,40,25],[40,27,40,32],[41,0,41,25],[78,0,78,37],[79,0,79,37],[80,0,80,37],[86,0,86,20],[86,21,86,28],[86,29,86,37],[87,0,87,20],[87,21,87,28],[87,29,87,37],[81,0,81,37],[82,1,82,33],[83,0,83,33],[84,1,84,33],[85,0,85,33],[54,0,54,37],[47,29,47,30],[47,22,47,27],[47,15,47,21],[47,0,47,8],[46,0,46,37],[3,0,3,37],[7,1,7,21],[7,23,7,37],[8,1,8,37],[9,1,9,13],[9,23,9,37],[10,0,10,37],[11,1,11,37],[20,0,20,37],[21,0,21,37],[50,0,50,37],[52,0,52,37],[13,0,13,37],[47,13,47,14],[18,0,18,7],[18,10,18,17],[18,20,18,27],[36,0,36,37],[18,30,18,37],[15,0,15,37],[16,0,16,37],[17,0,17,7],[17,10,17,17],[17,20,17,27],[17,30,17,37],[39,0,39,37],[28,0,28,37],[32,0,32,25],[29,0,29,25],[29,26,29,37],[27,0,27,37],[19,0,19,37],[31,34,31,37],[34,34,34,37],[31,27,31,33],[34,27,34,33],[32,27,32,33],[32,34,32,37],[33,0,33,37],[62,0,62,37],[57,17,57,23],[63,0,63,37],[64,1,64,34],[65,0,65,33],[4,0,4,37],[6,0,6,37],[5,0,5,37],[14,0,14,37],[47,31,47,37],[25,0,25,37],[26,0,26,25],[26,26,26,37],[22,0,22,37],[23,0,23,25],[23,26,23,37],[24,0,24,37],[34,0,34,25],[45,0,45,37],[35,0,35,25],[35,27,35,33],[35,34,35,37],[30,0,30,37],[31,0,31,25],[75,1,75,37],[76,0,76,37],[77,0,77,37],[49,0,49,37],[57,31,57,37],[57,1,57,16],[61,17,61,23],[61,24,61,30],[60,17,60,23],[60,24,60,30],[60,31,60,37],[61,31,61,37],[61,0,61,16],[59,1,59,16],[66,1,66,34],[67,0,67,33],[68,1,68,34],[69,1,69,30],[70,0,70,33],[71,1,71,34],[72,1,72,34],[73,1,73,34],[74,1,74,37],[56,31,56,37],[0,0,0,12],[1,0,1,37],[0,13,0,37],[2,0,2,37],[60,1,60,16],[58,17,58,23],[58,24,58,30],[58,31,58,37],[58,1,58,16],[59,17,59,23],[59,24,59,30],[59,31,59,37],[47,9,47,12],[55,0,55,16],[55,17,55,23],[55,24,55,30],[57,24,57,30],[12,0,12,37],[55,31,55,37],[53,0,53,37],[48,0,48,37],[56,0,56,16],[56,17,56,23],[56,24,56,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version : 2016-05-01"]
["Application for an Employee Certificate"]
["for Base Calendar Year"]
["Before completing this form, please read the instructions. "]
["1. REFUNDABLE TAX CREDIT CONCERNED"]
[]
["A single application must be submitted for all the corporation's eligible activities during the calendar year covered by this application."]
[null,"Processing Activities in the Resource Regions"]
[null," "]
[null,"Gaspésie and Certain Maritime Regions"]
[]
[null,"Aluminum Valley"]
[]
["2. CORPORATION IDENTIFICATION "]
["Corporation name"]
[]
[]
["NEQ",null,null,null,null,null,null,null,null,null,"IQ business number*",null,null,null,null,null,null,null,null,null,"IQ file number*",null,null,null,null,null,null,null,null,null,"Date of incorporation"]
[]
[]
["Business or file number assigned by Investissement Québec (IQ) for the tax credit(s) available in resources regions. Not required for the initial application. In the case of a second application, you will find these numbers on the correspondence received from IQ."]
[]
["Website"]
[]
[]
["Mailing address"]
[]
[]
["Authorized corporation representative"]
[]
[]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone",null,null,null,null,null,null,"Extension"]
[]
[]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax"]
[]
[]
["Corporation's authorized agent (if applicable)"]
[]
[]
["Agent's title",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephone",null,null,null,null,null,null,"Extension"]
[]
[]
["Agent's email address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax"]
[]
[]
["3. BASE CALENDAR YEAR AND FISCAL YEAR COVERED BY THIS APPLICATION"]
["Base calendar year:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal year from:",null,null,null,null,null,null,null,null,null,null,null,null,null,"to:"]
[]
["4. INFORMATION ABOUT EMPLOYEES"]
["This information must cover all the corporation's employees in each of the corporation's establishments in Québec. For each of these establishments, the number of employees must include all the establishment's employees, regardless of whether they are eligible or not, whether they are full-time, part-time or seasonal employees, or whether they were in the corporation's employ for the entire year or for a shorter period. The same applies to the number of hours worked, which must include all the hours worked: regular hours, overtime, vacations and statutory holidays."]
[]
["Information relating to the total payroll paid to employees must correspond to the total amount subject to the Health Services Fund (HSF), as shown on line 28 of the Summary of Source Deductions and Employer Contributions for the calendar year covered."]
["Indicate the total number of the corporation employees for each of the establishments located in Québec in the base calendar year."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total number "]
["Address of establishment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total number of employees",null,null,null,null,null,null,"of hours worked",null,null,null,null,null,null,"Total payroll"]
[1]
[2]
[3]
[4]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R58:X61)","v":0},null,null,null,null,null,null,{"$f":"SUM(Y58:AE61)","v":0},null,null,null,null,null,null,{"$f":"SUM(AF58:AL61)","v":0}]
[]
["5. DOCUMENTS TO ENCLOSE WITH THE APPLICATION (check off the documents enclosed)"]
["—  ","Copy of the corporation's non-consolidated financial statements1 for the fiscal year covered by this application;"]
[]
["—  ","Organization chart showing the hierarchy of the different types of jobs;"]
[]
["—  ","Summary of Source Deductions and Employer Contributions (Summary of Relevé 1 slips) for the calendar year"]
[null,"of eligibility and the base calendar year, if not already provided;"]
[]
["—  ","Duly signed power of attorney designating an agent to represent the corporation in its dealings with "]
[null,"Investissement Québec (to be provided only if not already provided). You can use the model available on the "]
[null,"Investissement Québec website at http://www.investquebec.com/documents/fr/formulaires/Procuration_fr.doc"]
[null,"In the event that the documents are not enclosed, please explain why."]
[]
[]
["1 The financial statements may be in draft form, provided that you send us a final version of them when they are available."]
[]
["6. DECLARATION OF THE AUTHORIZED CORPORATION REPRESENTATIVE"]
["I, the undersigned, duly authorized representative or agent of the corporation, declare that the information provided in this application, the appendices and the related documents is complete and accurate in all respects. "]
["Furthermore, unless otherwise expressly stated, I authorize the Tax Measures Department to share with the other departments of Investissement Québec any information obtained in the course of this application that could prove necessary for the analysis of any application for financing, investment or any other service provided by Investissement Québec."]
[null," I authorize the sharing of information"]
[]
[null," I do not authorize the sharing of information"]
["Finally, I certify that the company has not modified the contents of this application."]
[]
["Signature of the corporation's authorized representative or agent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"Appendix A","index":2,"n_rows":34,"n_cols":27,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,1,5,4],[16,4,16,6],[16,7,16,10],[18,9,21,9],[10,1,10,2],[18,10,21,10],[17,0,17,10],[18,6,21,6],[18,4,20,5],[18,7,21,7],[18,0,21,0],[18,1,21,1],[18,2,21,2],[18,3,21,3],[18,8,21,8],[15,0,15,10],[0,3,0,10],[1,0,1,10],[2,0,2,10],[0,0,0,2],[4,0,4,10],[3,0,3,10],[16,0,16,3],[10,7,10,8],[10,9,10,10],[14,0,14,10],[13,0,13,10],[6,0,6,10],[7,1,7,5],[7,7,7,8],[8,1,8,5],[12,8,12,9],[9,0,9,10]]}
[null,null,null,"Version : 2016-05-01"]
["Appendix A—Application for an Employee Certificate for the Base Calendar Year"]
["(Appendix A is an integral part of this application.)"]
["Before completing this application, please read the instructions."]
["Refundable tax credits concerned"]
[]
[]
[null,"Corporation name",null,null,null,null,null,"IQ file number",null,"NEQ"]
[null,{"$f":"IF('Application '!A16=\"\",\"\",'Application '!A16)","v":""},null,null,null,null,null,{"$f":"IF('Application '!U19=\"\",\"\",'Application '!U19)","v":""},null,{"$f":"IF('Application '!A19=\"\",\"\",'Application '!A19)","v":""}]
[]
[null,"Calendar year of eligibility",null,"Fiscal year from","from",null,"to",null,null,"IQ business number "]
[null,{"$f":"IF('Application '!J48=\"\",\"\",'Application '!J48)","v":""},null,null,{"$f":"IF('Application '!W48=\"\",\"\",'Application '!W48)","v":""},null,{"$f":"IF('Application '!AF48=\"\",\"\",'Application '!AF48)","v":""},null,null,{"$f":"IF('Application '!K19=\"\",\"\",'Application '!K19)","v":""}]
[null,"(yyyy)",null,null,"(yyyy-mm-dd)",null,"(yyyy-mm-dd)"]
[]
["Please complete fiscal year fields before completing the table."]
[]
["Type of pay period (e.g. weekly, biweekly, semimonthly or monthly):"]
[]
["Employee name\nEnter as follows:                                Last name (1 space) \nFirst name","S.I.N.\n999-999-999","Position (Complete Appendix B for each of these positions.)\nExample :                                                  Heavy machinery operator","Establishment (address)\nEnter as follows:                                                999, rue XXXXXXXXX, Suite 99, City (Québec) X9X 9X9","Employment period during the base calendar year",null,"Total number of pay periods worked","Number of eligible pay periods"," Total wages or salary for year\nExample:                     $45,550.00","Eligible wages or salary\nExample:          $35,550.00","Comments"]
[]
[]
[null,null,null,null,"From:                           (yyyy-mm-dd)","To:                                     (yyyy-mm-dd)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($F23),AND($E23>=DATE($B$12,1,1),$E23<=DATE($B$12,12,31)),AND($E23>=DATE($B$12,1,1),$E23<=DATE($B$12,12,31),$E23<=$F23))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($F24),AND($E24>=DATE($B$12,1,1),$E24<=DATE($B$12,12,31)),AND($E24>=DATE($B$12,1,1),$E24<=DATE($B$12,12,31),$E24<=$F24))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]

{"sheet":"Appendix B","index":3,"n_rows":49,"n_cols":42,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,4],[16,0,16,4],[17,1,17,4],[19,0,19,1],[19,2,19,3],[13,0,13,2],[14,0,14,1],[14,2,14,4],[15,2,15,4],[8,0,8,4],[10,0,10,2],[11,0,11,2],[12,0,12,2],[0,3,0,4],[6,0,6,1],[6,2,6,4],[6,25,6,27],[7,0,7,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[4,0,4,4]]}
[null,null,null,"Version : 2016-05-01"]
["Appendix B—Application for an Employee Certificate"]
["for the Base Calendar Year"]
["(Appendix B is an integral part of this application.)\n\nBefore completing this appendix, please read the instructions. (Please provide the requested information for all employees (eligible or not) of the establishments.)"]
["For more information, please consult our \"Guidelines for task descriptions on eligibility certificate applications\" on our website at the following address: http://www.investquebec.com/documents/en/publications/NouvellesLignesDirectrices_FiscalMeasures.pdf"]
["REFUNDABLE TAX CREDITS CONCERNED"]
[]
[]
["Use one Appendix B for each position. However, if the responsibilities and tasks are in all respects identical for more than one employee for the calendar year of eligibility, use a single appendix and list the employees concerned on the \"Incumbent(s)\" line.\n\nThe job description includes all of the responsibilities and tasks performed by the employee for the corporation."]
[]
["Corporation name",null,null,null,"IQ file number "]
[{"$f":"IF('Application '!A16=\"\",\"\",'Application '!A16)","v":""},null,null,null,{"$f":"IF('Application '!U19=\"\",\"\",'Application '!U19)","v":""}]
[" ",null,null,null,"Calendar year of eligibility"]
[" ",null,null,null,{"$f":"IF('Application '!J48=\"\",\"\",'Application '!J48)","v":""}]
["Job title",null,"Immediate superior"]
[]
["Incumbent(s)"]
[]
[]
["Detailed description of responsibilities and tasks",null,"Time dedicated to these activities (%)",null,"Reserved for IQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total (must add up to 100%):",null,{"$f":"SUM(C21:C47)","v":0},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (must add up to 100%):"]
["The description of responsibilities and tasks conforms to reality and nothing has been added to or removed from the responsibilities and tasks carried out by the incumbent(s) during the base calendar year."]