{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Template","Claim 1","Claim 2","Claim 3","Claim 4","Claim 5","Claim 6","Claim 7","Claim 8","Claim 9","Claim 10"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":63,"n_cols":13,"rows_kept":63,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$nulls":7},"       Yes","      No",1]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$nulls":11},"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$nulls":7},"FCF \n20   /20  ",null,null,"Eligible Costs"]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,"Authorized Assistance   %"]
[]
[{"$nulls":7},"FCF Free Balance",{"$f":"SUM(I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance"]
[]
[{"$nulls":10},"Outstanding Advance"]
[{"$nulls":4},"Postal Code"]
[{"$nulls":10},"Available Balance",{"$f":"SUM(L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$nulls":9},"%",null,{"$f":"+L10*H18","v":0}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+C22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},0]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},"*Gross Approved Assistance    % ",{"$nulls":3},0]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},0]
["%"]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE =",null,{"$f":"J24+J26","v":0},null,{"$f":"L24+L26","v":0}]
[]
[{"$nulls":7},"Outstanding Advance              =",{"$nulls":3},{"$f":"J32+J33","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                   +",null,{"$f":"J28-J30","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:J33)","v":0},null,{"$f":"L28+L30","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per"]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},null,{"$f":"E56*F56","v":0}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":0}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"-IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]

{"sheet":"Claim 1","index":1,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",1,{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF(Template!A6=\"\",\"\",Template!A6)","v":""},null,{"$f":"IF(Template!C6=\"\",\"\",Template!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF(Template!A8=\"\",\"\",Template!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"Template!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"Template!L10","v":0}]
[{"$f":"IF(Template!A11=\"\",\"\",Template!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"I8-I10","v":0},null,"Less: Cumulative Net Approved Assistance",0]
[]
[{"$nulls":10},"Outstanding Advance",0]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF(Template!E16=\"\",\"\",Template!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"SUM(L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF(Template!H18=\"\",\"\",Template!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+C22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+Template!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"J24","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"Template!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"J28","v":0}]
[]
[{"$nulls":7},"Outstanding Advance              =",{"$nulls":3},{"$f":"J32+J33","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                   +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISERROR(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK(Template!F56),\"\",Template!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"+G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"-IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 2","index":2,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4:G4=\"\",\"\",Template!A4:G4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 1'!J4+1","v":2},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"+IF('Claim 1'!A6:B6=\"\",\"\",'Claim 1'!A6:B6)","v":""},null,{"$f":"+IF('Claim 1'!C6:D6=\"\",\"\",'Claim 1'!C6:D6)","v":""},null,{"$f":"+IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"+IF(Template!H6:I6=\"\",\"\",Template!H6:I6)","v":""},null,{"$f":"+IF(Template!J6:K6=\"\",\"\",Template!J6:K6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 1'!A8=\"\",\"\",'Claim 1'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 1'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 1'!L10:M11","v":0}]
[{"$f":"IF('Claim 1'!A11=\"\",\"\",'Claim 1'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"SUM(I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 1'!L24),\"\",'Claim 1'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 1'!L30),\"\",'Claim 1'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 1'!E16=\"\",\"\",'Claim 1'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 1'!H18=\"\",\"\",'Claim 1'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 1'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 1'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 1'!L24:M25),\"\",J24+'Claim 1'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"'Claim 1'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE  =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance               =",null,{"$f":"'Claim 1'!J32:K32+'Claim 1'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                    +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 1'!F56),\"\",'Claim 1'!F56)","v":""},{"$f":"+IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 3","index":3,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 2'!J4+1","v":3},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 2'!A6=\"\",\"\",'Claim 2'!A6)","v":""},null,{"$f":"IF('Claim 2'!C6=\"\",\"\",'Claim 2'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 2'!A8=\"\",\"\",'Claim 2'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 2'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 2'!L10","v":0}]
[{"$f":"IF('Claim 2'!A11=\"\",\"\",'Claim 2'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 2'!L24),\"\",'Claim 2'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 2'!L30),\"\",'Claim 2'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 2'!E16=\"\",\"\",'Claim 2'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 2'!H18=\"\",\"\",'Claim 2'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 2'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 2'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 2'!L24:M25),\"\",J24+'Claim 2'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"'Claim 2'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance               =",null,{"$f":"'Claim 2'!J32:K32+'Claim 2'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                   +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 2'!F56),\"\",'Claim 2'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 4","index":4,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 3'!J4+1","v":4},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 3'!A6=\"\",\"\",'Claim 3'!A6)","v":""},null,{"$f":"IF('Claim 3'!C6=\"\",\"\",'Claim 3'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes          No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 3'!A8=\"\",\"\",'Claim 3'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 3'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 3'!L10","v":0}]
[{"$f":"IF('Claim 3'!A11=\"\",\"\",'Claim 3'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 3'!L24),\"\",'Claim 3'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 3'!L30),\"\",'Claim 3'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 3'!E16=\"\",\"\",'Claim 3'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"HoldBack Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 3'!H18=\"\",\"\",'Claim 3'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 3'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 3'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 3'!L24:M25),\"\",J24+'Claim 3'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"'Claim 3'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE  =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance                =",null,{"$f":"'Claim 3'!J32:K32+'Claim 3'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                   +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 3'!F56),\"\",'Claim 3'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 5","index":5,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 4'!J4+1","v":5},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 4'!A6=\"\",\"\",'Claim 4'!A6)","v":""},null,{"$f":"IF('Claim 4'!C6=\"\",\"\",'Claim 4'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes          No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 4'!A8=\"\",\"\",'Claim 4'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 4'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 4'!L10","v":0}]
[{"$f":"IF('Claim 4'!A11=\"\",\"\",'Claim 4'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 4'!L24),\"\",'Claim 4'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 4'!L30),\"\",'Claim 4'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 4'!E16=\"\",\"\",'Claim 4'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 4'!H18=\"\",\"\",'Claim 4'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 4'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 4'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 4'!L24:M25),\"\",J24+'Claim 4'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"'Claim 4'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE  =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance               =",null,{"$f":"'Claim 4'!J32:K32+'Claim 4'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                  +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 4'!F56),\"\",'Claim 4'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 6","index":6,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 5'!J4+1","v":6},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 5'!A6=\"\",\"\",'Claim 5'!A6)","v":""},null,{"$f":"IF('Claim 5'!C6=\"\",\"\",'Claim 5'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"       Yes        No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF(Template!A8=\"\",\"\",Template!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 5'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 5'!L10","v":0}]
[{"$f":"IF(Template!A11=\"\",\"\",Template!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 5'!L24),\"\",'Claim 5'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 5'!L30),\"\",'Claim 5'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF(Template!E16=\"\",\"\",Template!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Other Control"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 5'!H18=\"\",\"\",'Claim 5'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 5'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 5'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 5'!L24:M25),\"\",J24+'Claim 5'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                   %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"+'Claim 5'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE  =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance               =",null,{"$f":"'Claim 5'!J32:K32+'Claim 5'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                  +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 5'!F56),\"\",'Claim 5'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 7","index":7,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 6'!J4+1","v":7},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 6'!A6=\"\",\"\",'Claim 6'!A6)","v":""},null,{"$f":"IF(Template!C6=\"\",\"\",Template!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 6'!A8=\"\",\"\",'Claim 6'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 6'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 6'!L10","v":0}]
[{"$f":"IF('Claim 6'!A11=\"\",\"\",'Claim 6'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 6'!L24),\"\",'Claim 6'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 6'!L30),\"\",'Claim 6'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 6'!E16=\"\",\"\",'Claim 6'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 6'!H18=\"\",\"\",'Claim 6'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 6'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 6'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 6'!L24:M25),\"\",J24+'Claim 6'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"+'Claim 6'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance              =",null,{"$f":"'Claim 6'!J32:K32+'Claim 6'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                                   +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 6'!F56),\"\",'Claim 6'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 8","index":8,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 7'!J4+1","v":8},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 7'!A6=\"\",\"\",'Claim 7'!A6)","v":""},null,{"$f":"IF('Claim 7'!C6=\"\",\"\",'Claim 7'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 7'!A8=\"\",\"\",'Claim 7'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 7'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 7'!L10","v":0}]
[{"$f":"IF('Claim 7'!A11=\"\",\"\",'Claim 7'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 7'!L24),\"\",'Claim 7'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 7'!L30),\"\",'Claim 7'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 7'!E16=\"\",\"\",'Claim 7'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 7'!H18=\"\",\"\",'Claim 7'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 7'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 7'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 7'!L24:M25),\"\",J24+'Claim 7'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                          %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"+'Claim 7'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE                      =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance        =",null,{"$f":"'Claim 7'!J32:K32+'Claim 7'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                              +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 7'!F56),\"\",'Claim 7'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 9","index":9,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 8'!J4+1","v":9},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 8'!A6=\"\",\"\",'Claim 8'!A6)","v":""},null,{"$f":"IF('Claim 8'!C6=\"\",\"\",'Claim 8'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 8'!A8=\"\",\"\",'Claim 8'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 8'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 8'!L10","v":0}]
[{"$f":"IF('Claim 8'!A11=\"\",\"\",'Claim 8'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 8'!L24),\"\",'Claim 8'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 8'!L30),\"\",'Claim 8'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 8'!E16=\"\",\"\",'Claim 8'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Other Control"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 8'!H18=\"\",\"\",'Claim 8'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 8'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 8'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 8'!L24:M25),\"\",J24+'Claim 8'!L24:M25)","v":0}]
[]
["ISED/FedNor Share",{"$nulls":6},"*Holdback                          %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"+'Claim 8'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE                      =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance        =",null,{"$f":"'Claim 8'!J32:K32+'Claim 8'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing (receivable)                              +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["ISED/FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 8'!F56),\"\",'Claim 8'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]

{"sheet":"Claim 10","index":10,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,6],[2,7,2,8],[3,0,3,6],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[5,0,5,1],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[6,0,6,6],[6,7,6,12],[7,0,8,6],[7,7,8,7],[7,8,8,9],[7,10,8,10],[7,11,8,12],[9,0,9,6],[9,7,10,7],[9,8,10,9],[9,10,10,10],[9,11,10,12],[10,0,13,6],[11,7,12,7],[11,8,12,9],[11,10,12,10],[11,11,12,12],[13,7,15,9],[13,10,14,10],[13,11,14,12],[14,0,15,3],[14,4,14,6],[15,4,15,6],[15,11,15,12],[16,0,16,3],[16,4,16,6],[16,7,16,12],[17,0,17,3],[17,4,17,6],[17,7,17,8],[17,11,17,12],[18,0,18,12],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,19,12],[20,0,20,1],[20,2,20,3],[20,4,20,6],[20,9,20,10],[20,11,20,12],[21,0,22,1],[21,2,21,3],[21,4,21,6],[21,7,22,8],[21,9,22,10],[21,11,22,12],[22,2,22,3],[22,4,22,6],[23,0,24,1],[23,2,24,3],[23,4,24,6],[23,7,24,8],[23,9,24,10],[23,11,24,12],[25,0,25,1],[25,2,26,3],[25,4,26,6],[25,7,26,8],[25,9,26,10],[25,11,26,12],[26,0,26,1],[27,0,28,1],[27,2,28,6],[27,7,28,8],[27,9,28,10],[27,11,28,12],[29,0,30,6],[29,7,29,8],[29,9,29,10],[29,11,31,12],[30,7,30,8],[30,9,30,10],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,0,33,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[33,7,33,8],[33,9,33,10],[33,11,33,12],[34,0,34,6],[34,7,34,12],[35,0,35,6],[35,7,35,12],[36,0,36,6],[36,7,36,9],[36,10,36,12],[37,0,37,6],[37,7,37,9],[37,10,37,12],[38,0,38,6],[38,7,38,12],[39,0,40,6],[39,7,39,12],[40,7,40,11],[41,0,42,6],[41,7,41,11],[42,7,42,10],[42,11,42,12],[43,0,43,6],[43,7,43,10],[43,11,43,12],[44,1,44,5],[44,7,44,12],[45,0,45,6],[45,7,45,11],[46,0,46,6],[46,7,46,11],[47,0,47,3],[47,4,47,6],[47,7,47,10],[47,11,47,12],[48,0,48,3],[48,4,48,6],[48,7,48,10],[48,11,48,12],[49,0,49,12],[50,0,50,1],[50,2,50,5],[50,6,50,7],[50,8,50,12],[51,0,51,1],[51,2,51,5],[52,0,52,7],[53,4,53,7],[54,6,54,7],[55,6,55,7],[56,0,56,7],[57,0,57,2],[57,3,57,4],[57,5,60,7],[58,0,58,2],[58,3,58,4],[59,0,59,2],[59,3,59,4],[59,8,59,10],[59,11,59,12],[60,0,60,2],[60,3,60,4],[60,8,60,10],[60,11,60,12],[61,0,61,12],[62,0,62,1],[62,2,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,12],[63,0,63,1],[63,2,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,12]]}
["• Submit Original to Federal Economic Development for Northern Ontario (FedNor)"]
["• Shaded Areas are for Department Use Only"]
["Program",{"$nulls":6},"Final Claim",null,"Claim No.","Endeavour","Project No.","PPG Code"]
[{"$f":"IF(Template!A4=\"\",\"\",Template!A4)","v":""},{"$nulls":6},"       Yes","      No",{"$f":"'Claim 9'!J4+1","v":10},{"$f":"IF(Template!K4=\"\",\"\",Template!K4)","v":""},{"$f":"IF(Template!L4=\"\",\"\",Template!L4)","v":""},{"$f":"IF(Template!M4=\"\",\"\",Template!M4)","v":""}]
["Project Start",null,"Project Completion ",null,"Commercial Production",null,null,"Eligibility Date",null,"Offer Accepted Date",null,"Holdback Threshold Reached"]
[{"$f":"IF('Claim 9'!A6=\"\",\"\",'Claim 9'!A6)","v":""},null,{"$f":"IF('Claim 9'!C6=\"\",\"\",'Claim 9'!C6)","v":""},null,{"$f":"IF(Template!E6=\"\",\"\",Template!E6)","v":""},null,null,{"$f":"IF(Template!H6=\"\",\"\",Template!H6)","v":""},null,{"$f":"IF(Template!J6=\"\",\"\",Template!J6)","v":""},null,"        Yes         No"]
["Name of Recipient(s) and Joint Payee (if applicable)",{"$nulls":6},"CONTROL POINTS"]
[{"$f":"IF('Claim 9'!A8=\"\",\"\",'Claim 9'!A8)","v":""},{"$nulls":6},"FCF \n20   /20  ",null,null,"Eligible Costs",{"$f":"'Claim 9'!L8","v":0}]
[]
["Address",{"$nulls":6},"Less: CY Pmts to Date",null,null,{"$f":"+Template!K10","v":"Authorized Assistance   %"},{"$f":"'Claim 9'!L10","v":0}]
[{"$f":"IF('Claim 9'!A11=\"\",\"\",'Claim 9'!A11)","v":""}]
[{"$nulls":7},"FCF Free Balance",{"$f":"IF(ISERROR(I8-I10),\"\",I8-I10)","v":0},null,"Less: Cumulative Net Approved Assistance",{"$f":"IF(ISERROR('Claim 9'!L24),\"\",'Claim 9'!L24)","v":0}]
[]
[{"$nulls":10},"Outstanding Advance",{"$f":"IF(ISERROR('Claim 9'!L30),\"\",'Claim 9'!L30)","v":0}]
[{"$nulls":4},"Postal Code"]
[{"$nulls":4},{"$f":"IF('Claim 9'!E16=\"\",\"\",'Claim 9'!E16)","v":""},{"$nulls":5},"Available Balance",{"$f":"IF(ISERROR(L10-L12-L14),\"\",L10-L12-L14)","v":0}]
["Contact",{"$nulls":3},"Telephone Number",null,null,"Holdback Threshold"]
[{"$f":"IF(Template!A18=\"\",\"\",Template!A18)","v":""},{"$nulls":3},{"$f":"IF(Template!E18=\"\",\"\",Template!E18)","v":""},null,null,{"$f":"IF('Claim 9'!H18=\"\",\"\",'Claim 9'!H18)","v":""},null,"%","$",{"$f":"IF(ISERROR(L10*H18),\"\",L10*H18)","v":""}]
["CLAIM"]
["1.  Eligible Costs",null,"ELIGIBLE COSTS CLAIMED",{"$nulls":4},"* CMIS KEYED ENTRY",null,"PAYMENT CALCULATION"]
["         Incurred           Paid",null,"Current",null,"Total to Date",{"$nulls":4},"Current",null,"Cumulative"]
["Period Covered",null,"From (YYYY-MM-DD)",null,{"$f":"+'Claim 1'!E22:G22","v":"From (YYYY-MM-DD)"},null,null,"*Approved Eligible Costs",{"$nulls":3},{"$f":"J22+'Claim 9'!L22:M23","v":0}]
[null,null,"To (YYYY-MM-DD)",null,{"$f":"+C23","v":"To (YYYY-MM-DD)"}]
["Total Eligible Costs (as per \"Detailed Claim\" attached)",{"$nulls":6},{"$f":"+'Claim 9'!H24","v":"*Gross Approved Assistance    % "},{"$nulls":3},{"$f":"IF(ISERROR(J24+'Claim 9'!L24:M25),\"\",J24+'Claim 9'!L24:M25)","v":0}]
[]
["FedNor Share",{"$nulls":6},"*Holdback                                    %",{"$nulls":3},{"$f":"J26","v":0}]
[{"$f":"+'Claim 9'!A27","v":"%"}]
["2.   ADVANCES",null,"(only when provided for in the Contribution Agreement - attach \"Recipient's Cost Forecast)",{"$nulls":4},"NET APPROVED ASSISTANCE =",null,{"$f":"IF(ISERROR(J24+J26),\"\",J24+J26)","v":0},null,{"$f":"IF(ISERROR(L24+L26),\"\",L24+L26)","v":0}]
[]
[{"$nulls":7},"Outstanding Advance              =",null,{"$f":"'Claim 9'!J32:K32+'Claim 9'!J33:K33","v":0},null,{"$f":"IF(ISERROR(J32+J33),\"\",J32+J33)","v":0}]
[{"$nulls":7},"Amount Owing\n(receivable)                                  +",null,{"$f":"IF(ISERROR(J28-J30),\"\",J28-J30)","v":0}]
["FedNor Share - estimate cash requirements for period specified",null,null,{"$f":"IF(ISBLANK(D61),\" \",D61)","v":0},null,"------------------------------",null,"*ADVANCE",null,{"$f":"D32","v":0}]
[{"$nulls":7},"Adjustments or Recoveries (explain below)",null,{"$f":"IF(+J31>0,0,-J31)","v":0}]
[{"$nulls":7},"REQUESTED PAYMENT",null,{"$f":"SUM(J31:K33)","v":0},null,{"$f":"IF(ISERROR(L28+L30),\"\",L28+L30)","v":0}]
["CERTIFICATION (by recipient for each claim)",{"$nulls":6},"APPROVED and CERTIFIED pursuant to Departmental Signing Authorities."]
["I certify that:",{"$nulls":6},"The amount payable relates to costs that:"]
["(a) the costs described in this claim and considered eligible were or will be incurred under the contract;",{"$nulls":6},"are eligible and reasonable;",null,null,"will be incurred within the advance period;"]
["(b) generally accepted and consistently followed accounting practices have been used;",{"$nulls":6},"are reasonable in step with work performed in a satisfactory manner;",null,null,"all required terms and conditions of the agreement are being met."]
["(c) Her Majesty's payment will be applied to the project in accordance with the contract and costing memorandum;"]
["(d) if applicable, disclosure has been made of assets involved in or resulting from the project which ceased to be used or which were transferred to productive use, sold, leased or otherwise disposed of;",{"$nulls":6},"Recommended by"]
[{"$nulls":7},"Title",{"$nulls":4},"FSA Number"]
["(e) if applicable, environmental protection measures have been implemented and are maintained; requirements of all regulatory bodies have been satisfied."]
[{"$nulls":7},"Signature",{"$nulls":3},"Date"]
[]
[{"$nulls":7},"Approved and Certified pursuant to Section 34 1(b) of the FAA."]
["Signature of Authorized Official",{"$nulls":6},"Title",{"$nulls":4},"FSA Number"]
[]
["Title",{"$nulls":3},"Date",null,null,"Signature",{"$nulls":3},"Date"]
[]
["REMARKS (DEPARTMENTAL USE)"]
["Sample Requested Date",{"$nulls":5},"Sample Received Date"]
["Advance Authorized per",null,{"$f":"+IF(Template!C52=\"\",\"\",Template!C52)","v":""}]
[]
["Month/Quarter","Month/Quarter","Month/Quarter","Quarter"]
[{"$nulls":4},"Total","%","Advance"]
[{"$nulls":4},{"$f":"SUM(A56:D56)","v":0},{"$f":"IF(ISBLANK('Claim 9'!F56),\"\",'Claim 9'!F56)","v":""},{"$f":"IF(ISERROR(E56*F56),\"\",E56*F56)","v":""}]
[]
["Advance (period above)",null,null,{"$f":"G56","v":""}]
["plus Advance Retention-period ____________"]
["less Advance Outstanding",null,null,{"$f":"IF(J31<0,-J31,0)","v":0},{"$nulls":4},"Claim Received Date"]
["Total Advance",null,null,{"$f":"SUM(D58:E60)","v":0},{"$nulls":4},"Next Claim Due Date"]
["DEPARTMENT CASH FORECAST"]
["CFY   20     20",null,"CFY+1   20    20",null,"CFY+2   20     20",null,null,"CFY+3   20     20",null,"CFY+4   20     20"]
[{"$f":"+IF(I8=\"\",\"\",I8)","v":""}]