{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Claim Summary","(1)Direct Labour","(2)Direct Materials & Equipment","(3)Direct Fibre","(4)Travel","(5)Other Direct Costs","(6)Ineligible Costs"],"read":"whole","date_system":"1900"}

{"sheet":"Claim Summary","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"merged":[[1,1,1,3],[2,1,2,3],[3,2,3,3],[4,2,4,3],[13,1,13,2],[15,1,15,2],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,21,3],[22,1,23,3]]}
[]
[null,"Expenses Claim Form"]
[null,"Summary"]
[null,"Project #","Proponent Name"]
[]
[null,"Claim #","Claim Start Date","Claim End Date"]
[]
[null,"Schedule #","CATEGORY","TOTAL REPORTED\nELIGIBLE COSTS"]
[null,1,"Direct Labour",{"$f":"'(1)Direct Labour'!J10","v":0}]
[null,2,"Direct Materials & Equipment",{"$f":"'(2)Direct Materials & Equipment'!L7","v":0}]
[null,3,"Direct Fibre",{"$f":"'(3)Direct Fibre'!L7","v":0}]
[null,4,"Travel",{"$f":"'(4)Travel'!J7","v":0}]
[null,5,"Other Direct Costs",{"$f":"'(5)Other Direct Costs'!L7","v":0}]
[null,"Total Eligible Costs",null,{"$f":"SUM(D9:D13)","v":0}]
[null,6,"Ineligible Costs",{"$f":"'(6)Ineligible Costs'!L7","v":0}]
[null,"Total Project Costs",null,{"$f":"D15+D14","v":0}]
[]
[null,"Notes/Instructions:"]
[null,"Only complete yellow sections, as applicable, on each tab."]
[null,"If multiple claims are being submitted, there must be no overlap in expenses/dates."]
[null,"Refer to the Application Guide for Eligible and Ineligible Costs. Contact connectingbc@northerndevelopment.bc.ca if you need a copy."]
[]
[null,"Northern Development will review reported expenses and identify which items require invoice(s)/support to be submitted."]
[]
[{"$nulls":3},"Published August 2020 – Ver. 1.3"]

{"sheet":"(1)Direct Labour","index":1,"n_rows":113,"n_cols":12,"rows_kept":113,"merged":[[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[10,10,10,11]]}
[]
[null,"Direct Labour - Schedule 1"]
[null,"Notes:"]
[null,"Gross hourly/daily rate is the normal periodic wage.                           "]
[null,"Under Phase 2: Associated CPP, EI, WCB are eligible. Any premiums above actual gross pay (e.g. overtime, shift differentials, and any reimbursement or benefit conferred in lieu of salaries or wage) are ineligible."]
[null,"Under Phase 3: CPP, EI, WCB, and other benefits are ineligible."]
[null,"Timesheets must be kept for all labour claimed."]
[null,"Contractors' labour must be reported under the \"Other Direct Costs\"."]
[{"$nulls":9},"Total Eligible\nDirect Labour"]
[{"$nulls":9},{"$f":"SUM(Table13[Total Eligible Costs\n(Rate x Quantity)])","v":0}]
[{"$nulls":10},"Northern Development Use Only"]
[null,"Work Period\nStart Date\n(MM/DD/YY)","Work Period\nEnd Date\n(MM/DD/YY)","Employee Name","Position/Title","Rate\n($)","Rate Type\n(/hour or /day)","Quantity","Qty Type\n(hours or days)","Total Eligible Costs\n(Rate x Quantity)","Timesheet\nSelected for Review?","Northern Development Comments"]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":8},{"$f":"IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Day\",\"days\",IF(Table13[[#This Row],[Rate Type\n(/hour or /day)]]=\"/Hour\",\"hours\",\" \"))","v":" "},{"$f":"Table13[[#This Row],[Rate\n($)]]*Table13[[#This Row],[Quantity]]","v":0}]
[{"$nulls":11},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]

{"sheet":"(2)Direct Materials & Equipment","index":2,"n_rows":110,"n_cols":14,"rows_kept":110,"merged":[[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[7,12,7,13]]}
[]
[null,"Direct Materials & Equipment - Schedule 2"]
[null,"Notes:"]
[null,"If multiple items on an invoice, consider using a row for each item."]
[null,"Materials and equipment purchased from foreign suppliers must be reporting in Canadian dollars using the market exchange rate in effect at the time of invoice payment."]
[{"$nulls":11},"Total Eligible\nDirect Materials\n& Equipment"]
[{"$nulls":11},{"$f":"SUM(Table14[Total Eligible Costs\n(Subtotal + PST)])","v":0}]
[{"$nulls":12},"Northern Development Use Only"]
[null,"Invoice Date\n(MM/DD/YY)","Invoice #","Vendor","Description of Item\n(i.e.model no., product type, etc.)","Quantity","Cost per Unit","Subtotal\n($)","GST\n($)","PST\n($)","Invoice\nTotal","Total Eligible Costs\n(Subtotal + PST)","Invoice\nSelected for Review?","Northern Development Comments"]
[{"$nulls":10},{"$f":"SUM(H10:J10)","v":0},{"$f":"+H10+J10","v":0}]
[{"$nulls":10},{"$f":"SUM(H11:J11)","v":0},{"$f":"+H11+J11","v":0}]
[{"$nulls":10},{"$f":"SUM(H12:J12)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H14:J14)","v":0},{"$f":"+H14+J14","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H46:J46)","v":0},{"$f":"+H46+J46","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H70:J70)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":13},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]

{"sheet":"(3)Direct Fibre","index":3,"n_rows":110,"n_cols":14,"rows_kept":110,"merged":[[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[7,12,7,13]]}
[]
[null,"Direct Fibre - Schedule 3"]
[null,"Notes:"]
[null,"If multiple items on an invoice, consider using a row for each item."]
[null,"Materials and equipment purchased from foreign suppliers must be reporting in Canadian dollars using the market exchange rate in effect at the time of invoice payment."]
[{"$nulls":11},"Total Eligible\nDirect Fibre"]
[{"$nulls":11},{"$f":"SUM(Table15[Total Eligible Costs\n(Subtotal + PST)])","v":0}]
[{"$nulls":12},"Northern Development Use Only"]
[null,"Invoice Date\n(MM/DD/YY)","Invoice #","Vendor","Description of Item ","Cable Length\n(m)","Cost per unit\n(per m)","Subtotal\n($)","GST\n($)","PST\n($)","Invoice\nTotal","Total Eligible Costs\n(Subtotal + PST)","Invoice\nSelected for Review?","Northern Development Comments"]
[{"$nulls":10},{"$f":"SUM(H10:J10)","v":0},{"$f":"+H10+J10","v":0}]
[{"$nulls":10},{"$f":"SUM(H11:J11)","v":0},{"$f":"+H11+J11","v":0}]
[{"$nulls":10},{"$f":"SUM(H12:J12)","v":0},{"$f":"+H12+J12","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H16:J16)","v":0},{"$f":"+H16+J16","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H48:J48)","v":0},{"$f":"+H48+J48","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H70:J70)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":13},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]

{"sheet":"(4)Travel","index":4,"n_rows":110,"n_cols":12,"rows_kept":110,"merged":[[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[7,10,7,11]]}
[]
[null,"Travel - Schedule 4"]
[null,"Notes:"]
[null,"Travel logs must be kept for all travel costs claimed."]
[null,"Contractos' travel costs must be reported under \"Other Direct Costs\"."]
[{"$nulls":9},"Total Eligible\nOther Direct Costs"]
[{"$nulls":9},{"$f":"SUM(Table16[Total Eligible Costs\n(Subtotal + PST)])","v":0}]
[{"$nulls":10},"Northern Development Use Only"]
[null,"Travel Period\nStart Date\n(MM/DD/YY)","Travel Period\nEnd Date\n(MM/DD/YY)","Employee Name","Expense Type\n(i.e. mileage, airfare, hotel, meal allowance)","Subtotal\n($)","GST\n($)","PST\n($)","Invoice\nTotal","Total Eligible Costs\n(Subtotal + PST)","Invoice\nSelected for Review?","Northern Development Comments"]
[{"$nulls":8},{"$f":"SUM(F10:H10)","v":0},{"$f":"+F10+H10","v":0}]
[{"$nulls":8},{"$f":"SUM(F11:H11)","v":0},{"$f":"+F11+H11","v":0}]
[{"$nulls":8},{"$f":"SUM(F12:H12)","v":0},0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},{"$f":"SUM(F18:H18)","v":0},0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},{"$f":"SUM(F22:H22)","v":0},{"$f":"+F22+H22","v":0}]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},{"$f":"SUM(F54:H54)","v":0},{"$f":"+F54+H54","v":0}]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":8},0,0]
[{"$nulls":11},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]

{"sheet":"(5)Other Direct Costs","index":5,"n_rows":110,"n_cols":14,"rows_kept":110,"merged":[[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[7,12,7,13]]}
[]
[null,"Other Direct Costs - Schedule 5"]
[null,"Notes:"]
[null,"If multiple items on an invoice, consider using a row for each item."]
[null,"Materials and equipment purchased from foreign suppliers must be reporting in Canadian dollars using the market exchange rate in effect at the time of invoice payment."]
[{"$nulls":11},"Total Eligible\nOther Direct Costs"]
[{"$nulls":11},{"$f":"SUM(Table1[Total Eligible Costs\n(Subtotal + PST)])","v":0}]
[{"$nulls":12},"Northern Development Use Only"]
[null,"Invoice Date\n(MM/DD/YY)","Invoice #","Vendor","Description of Item ","Quantity","Cost Per Unit\n(if applicable)","Subtotal\n($)","GST\n($)","PST\n($)","Invoice\nTotal","Total Eligible Costs\n(Subtotal + PST)","Invoice/Timesheet\nSelected for Review?","Northern Development Comments"]
[{"$nulls":10},{"$f":"SUM(H10:J10)","v":0},{"$f":"+H10+J10","v":0}]
[{"$nulls":10},{"$f":"SUM(H11:J11)","v":0},{"$f":"+H11+J11","v":0}]
[{"$nulls":10},{"$f":"SUM(H12:J12)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H14:J14)","v":0},0]
[{"$nulls":10},{"$f":"SUM(H15:J15)","v":0},{"$f":"+H15+J15","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H18:J18)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H22:J22)","v":0},{"$f":"+H22+J22","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},{"$f":"SUM(H54:J54)","v":0},{"$f":"+H54+J54","v":0}]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":13},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]

{"sheet":"(6)Ineligible Costs","index":6,"n_rows":110,"n_cols":13,"rows_kept":110,"merged":[[1,1,1,12],[2,1,2,12],[3,1,3,12],[4,1,4,12]]}
[]
[null,"Ineligible Costs - Schedule 6"]
[null,"Notes:"]
[null,"If multiple items on an invoice, consider using a row for each item."]
[null,"Materials and equipment purchased from foreign suppliers must be reporting in Canadian dollars using the market exchange rate in effect at the time of invoice payment."]
[{"$nulls":11},"Total Ineligible\nCosts"]
[{"$nulls":11},{"$f":"SUM(Table17[Total Ineligible Costs\n(Subtotal + PST)])","v":0}]
[{"$nulls":12},"Northern Development Use Only"]
[null,"Invoice Date\n(MM/DD/YY)","Invoice #","Vendor","Description of Item ","Quantity","Cost Per Unit\n(if applicable)","Subtotal\n($)","GST\n($)","PST\n($)","Invoice\nTotal","Total Ineligible Costs\n(Subtotal + PST)","Northern Development Comments"]
[{"$nulls":10},{"$f":"SUM(H10:J10)","v":0},{"$f":"+H10+J10","v":0}]
[{"$nulls":10},{"$f":"SUM(H11:J11)","v":0},{"$f":"+H11+J11","v":0}]
[{"$nulls":10},{"$f":"SUM(H12:J12)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,{"$f":"+H17+J17","v":0}]
[{"$nulls":10},{"$f":"SUM(H18:J18)","v":0},0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":10},0,0]
[{"$nulls":12},{"$f":"'Claim Summary'!D25","v":"Published August 2020 – Ver. 1.3"}]