{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Payment Claim","A-Work Complete","B-Variation","C-Backcharges","D-Travel & Living","E-Previous Certifications","Payment Certificate","Rates Schedule","Certificate - Labour","Certificate - Goods","Certificate - Travel & Living","Forecast"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Payment Claim","index":0,"n_rows":53,"n_cols":57,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,22,4,35],[5,22,5,35],[30,33,30,35],[28,33,28,35],[24,33,24,35],[20,33,20,35],[19,33,19,35],[22,33,22,35],[13,22,13,35],[19,25,19,31],[20,25,20,31],[22,25,22,31],[29,25,29,31],[30,25,30,31],[24,25,24,31],[25,25,25,31],[12,18,12,21],[12,22,12,35],[11,18,11,35],[9,4,10,17],[11,4,11,17],[12,4,12,17],[9,18,9,25],[10,18,10,25],[9,26,9,35],[10,26,10,35],[16,33,17,35],[14,22,14,35],[15,22,15,35],[15,4,15,17],[3,0,3,3],[3,18,4,21],[4,0,4,3],[5,0,5,3],[5,18,5,21],[3,4,3,17],[4,4,4,17],[5,4,5,17],[6,0,6,3],[6,18,6,21],[9,0,10,3],[7,0,8,35],[13,4,13,17],[14,4,14,17],[18,0,18,1],[14,18,14,21],[15,0,15,3],[15,18,15,21],[16,0,17,12],[16,20,17,24],[16,13,17,19],[18,13,18,19],[28,0,28,1],[22,0,22,1],[19,13,19,19],[20,13,20,19],[22,13,22,19],[24,13,24,19],[25,13,25,19],[26,13,26,19],[27,13,27,19],[28,13,28,19],[25,0,25,1],[26,0,26,1],[24,0,24,1],[19,0,19,1],[20,0,20,1],[29,20,29,24],[30,20,30,24],[29,13,29,19],[30,13,30,19],[52,10,52,19],[52,23,52,35],[36,0,36,35],[32,20,32,24],[34,13,34,19],[32,13,32,19],[28,25,28,31],[18,25,18,31],[13,18,13,21],[26,25,26,31],[27,25,27,31],[6,4,6,17],[6,22,6,35],[0,0,2,18],[18,41,35,60],[3,41,15,54],[16,25,17,31],[18,20,18,24],[19,20,19,24],[20,20,20,24],[21,20,21,24],[22,20,22,24],[24,20,24,24],[25,20,25,24],[26,20,26,24],[27,20,27,24],[28,20,28,24]]}
["Place Supplier logo here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLIER PAYMENT CLAIM (SPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY & DECLARATION"]
[]
["Project",null,null,null,"[Project Name]",null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,"[Insert Phase-MMM-YY} e.g. BDD-Jan-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Update this part before anything else"]
["Phase",null,null,null,"[Project Phase]"]
["Supplier (SC)",null,null,null,"[Company Name]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,"2017-04-04"]
["SC's Repres.",null,null,null,"[SC's Representative]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"CONCATENATE(E12,\"-SPC-\", W4)","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["1. Contract Details"]
[]
["Subcontract Title",null,null,null,"[Contract Title]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Unit Basis Value",null,null,null,null,null,null,null,17869385.260000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Milestone Value",null,null,null,null,null,null,null,0]
["Subcontract No.",null,null,null,"[Contract #]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Value ($)"]
["Subcontract Start",null,null,null,"2016-12-23",null,null,null,null,null,null,null,null,null,null,null,null,null,"Work Value",null,null,null,{"$f":"AA10+'B-Variation'!N39","v":17869385.260000002}]
["Subcontract End",null,null,null,"2017-12-22",null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation(s) Value",null,null,null,{"$f":"'B-Variation'!N40","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E14<W6, \"WARNING! - past subcontract end date\", \"\")","v":""}]
["Currency",null,null,null,"CAD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,{"$f":"'D-Travel & Living'!S16","v":74950}]
["Holdback (%)",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(W13:AJ15)","v":17944335.260000002}]
["2. Summary",null,null,null,null,null,null,null,null,null,null,null,null,"Amount of This Certificate",null,null,null,null,null,null,"Previously Certified",null,null,null,null,"Total Certified to Date",null,null,null,null,null,null,null,"Expended (%)"]
[]
["A)",null,"Work Complete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing to fill here, everything updates automatically"]
[null,null,"1)","Unit Rate Basis",null,null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!AF40","v":13000},null,null,null,null,null,null,{"$f":"'A-Work Complete'!AX40","v":15500},null,null,null,null,{"$f":"SUM(N20:Y20)","v":28500},null,null,null,null,null,null,null,{"$f":"IF(Z20<>0,IFERROR(Z20/(AA10+'B-Variation'!N39), \"ERROR!\"), \"0%\")","v":1.5949065726282292E-3}]
[null,null,"2)","Milestone Basis",null,null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!U60","v":0},null,null,null,null,null,null,{"$f":"'A-Work Complete'!Z60","v":0},null,null,null,null,{"$f":"SUM(N21:Y21)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Z21<>0,IFERROR(Z21/AA11, \"ERROR!\"), \"0%\")","v":"0%"}]
[]
["B)",null,"Variation(s) (+/-)",null,null,null,null,null,null,null,null,null,null,{"$f":"'B-Variation'!X41","v":0},null,null,null,null,null,null,{"$f":"'B-Variation'!AC41","v":0},null,null,null,null,{"$f":"SUM(N23:Y23)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Z23<>0,IFERROR(Z23/(W14), \"ERROR!\"), \"0%\")","v":"0%"}]
[]
[null,null,"Total Work Complete",null,null,null,null,null,null,null,"A1+A2+B",null,null,{"$f":"SUM(N20:T23)","v":13000},null,null,null,null,null,null,{"$f":"SUM(U20:Y23)","v":15500},null,null,null,null,{"$f":"SUM(N25:Y25)","v":28500},null,null,null,null,null,null,null,{"$f":"IF(Z25<>0,IFERROR(Z25/(SUM(W13:AJ14,AA11)), \"ERROR!\"), \"0%\")","v":1.5949065726282292E-3}]
[null,null,null,"Less Holdback",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(N25*E16,2)*-1","v":0},null,null,null,null,null,null,{"$f":"ROUND(U25*E16,2)*-1","v":0},null,null,null,null,{"$f":"SUM(N26:Y26)","v":0}]
[null,null,"C)","Less Backcharges",null,null,null,null,null,null,null,null,null,{"$f":"'C-Backcharges'!S23","v":0},null,null,null,null,null,null,{"$f":"'C-Backcharges'!Y23","v":0},null,null,null,null,{"$f":"SUM(N27:Y27)","v":0}]
[]
["D)",null,"Travel & Living",null,null,null,null,null,null,null,null,null,null,{"$f":"'D-Travel & Living'!CB52","v":4128.543615676359},null,null,null,null,null,null,{"$f":"'E-Previous Certifications'!DB33","v":0},null,null,null,null,{"$f":"SUM(N29:Y29)","v":4128.543615676359},null,null,null,null,null,null,null,{"$f":"IF(Z29<>0,IFERROR(Z29/W15, \"ERROR!\"), \"0%\")","v":5.5083970856255625E-2}]
[]
[null,null,null,null,"Net Amount Payable",null,null,null,null,null,null,null,null,{"$f":"SUM(N25:T29)","v":17128.543615676361},null,null,null,null,null,null,{"$f":"SUM(U25:Y29)","v":15500},null,null,null,null,{"$f":"SUM(Z25:AF29)","v":32628.543615676361},null,null,null,null,null,null,null,{"$f":"IF(Z31<>0,IFERROR(Z31/W16, \"ERROR!\"), \"0%\")","v":1.8183199958601507E-3}]
[]
[null,null,null,null,"G.S.T. This Claim",null,null,null,null,null,null,null,null,{"$f":"N31*0.05","v":856.42718078381813},null,null,null,null,null,null,{"$f":"U31*0.05","v":775}]
[]
[null,null,null,null,"Total Payable This Claim",null,null,null,null,null,null,null,null,{"$f":"N33+N31","v":17984.97079646018}]
[]
[{"$f":"spellnumber(N35)","v":"Seventeen Thousand Nine Hundred Eighty Four Dollars and Ninety Seven Cents"}]
[]
["Certificate of Supplier"]
["I certify that:"]
["1. All authorizations required under the Subcontract have been obtained. The claim is consistent with the progress of the work and is in accordance "]
["with the Subcontract."]
["2. Indirect costs have been paid for or accrued in the accounts. Direct labour costs, direct materials and other direct costs under Subcontract have been "]
["received, accepted and either paid or accrued in my/our accounts following receipt of invoice from Supplier, and have been incurred exclusively for "]
["the purpose of the contract."]
["3. This claim is based on costs computed in accordance with Contract Cost Principles 1031-2, and includes the applicable negotiated amount of profit as set "]
["out in the Subcontract Rate Table for Basis of Payment. Further, it does not include an element of profit on the sale in excess of that normally obtained by the "]
["Supplier on the sale of services of like quality and quantity"]
["3. No liens, encumbrances, charges or other claims exist with respect to any materials, parts, work-in-process, or finished work for which the Supplier "]
["intends to claim payment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Supplier's Signature"]

{"sheet":"A-Work Complete","index":1,"n_rows":61,"n_cols":78,"rows_kept":61,"cut":false,"hidden":false,"merged":[[49,20,49,22],[48,0,48,1],[48,20,48,22],[55,2,55,9],[55,18,55,19],[54,0,54,1],[54,20,54,22],[47,18,47,19],[47,0,47,1],[47,2,47,9],[50,2,50,9],[59,20,59,22],[59,25,59,28],[59,0,59,17],[39,37,39,40],[51,0,51,1],[51,20,51,22],[52,0,52,1],[52,20,52,22],[53,0,53,1],[53,20,53,22],[56,25,56,28],[57,2,57,9],[57,18,57,19],[57,23,57,24],[44,10,44,17],[45,10,45,17],[46,10,46,17],[47,10,47,17],[55,10,55,17],[58,10,58,17],[50,20,50,22],[58,0,58,1],[58,20,58,22],[54,2,54,9],[54,18,54,19],[52,10,52,17],[53,10,53,17],[54,10,54,17],[57,0,57,1],[57,20,57,22],[56,0,56,1],[56,20,56,22],[55,0,55,1],[55,20,55,22],[56,2,56,9],[56,18,56,19],[56,10,56,17],[57,10,57,17],[33,53,33,55],[39,15,39,18],[48,10,48,17],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[25,56,25,59],[26,0,26,1],[26,2,26,9],[26,10,26,11],[26,12,26,14],[25,0,25,1],[25,2,25,9],[24,0,24,1],[24,56,24,59],[6,0,8,1],[24,35,24,36],[24,37,24,40],[8,35,8,36],[8,37,8,40],[24,2,24,9],[24,10,24,11],[24,12,24,14],[6,2,8,9],[25,10,25,11],[25,12,25,14],[24,19,24,22],[9,56,9,59],[9,12,9,14],[47,23,47,24],[47,25,47,28],[46,20,46,22],[51,18,51,19],[51,23,51,24],[51,25,51,28],[27,37,27,40],[47,20,47,22],[50,18,50,19],[50,23,50,24],[36,19,36,22],[37,19,37,22],[37,35,37,36],[37,37,37,40],[36,35,36,36],[36,37,36,40],[30,15,30,18],[31,15,31,18],[32,15,32,18],[33,15,33,18],[34,15,34,18],[35,15,35,18],[36,15,36,18],[37,15,37,18],[44,23,44,24],[44,25,44,28],[28,37,28,40],[31,25,31,28],[32,23,32,24],[32,25,32,28],[28,29,28,30],[33,23,33,24],[43,23,43,24],[43,25,43,28],[31,56,31,59],[30,35,30,36],[30,37,30,40],[30,56,30,59],[29,35,29,36],[29,37,29,40],[30,19,30,22],[32,35,32,36],[32,37,32,40],[32,56,32,59],[31,41,31,42],[31,43,31,46],[32,41,32,42],[32,43,32,46],[30,47,30,48],[30,49,30,52],[31,47,31,48],[31,49,31,52],[32,47,32,48],[32,49,32,52],[31,53,31,55],[32,53,32,55],[30,31,30,34],[31,29,31,30],[31,31,31,34],[32,29,32,30],[32,31,32,34],[30,25,30,28],[30,29,30,30],[30,0,30,1],[30,2,30,9],[30,10,30,11],[30,12,30,14],[29,0,29,1],[29,2,29,9],[29,10,29,11],[29,12,29,14],[27,0,27,1],[27,2,27,9],[27,10,27,11],[27,12,27,14],[49,2,49,9],[49,18,49,19],[48,2,48,9],[48,18,48,19],[53,2,53,9],[53,18,53,19],[52,2,52,9],[52,18,52,19],[51,2,51,9],[49,10,49,17],[50,10,50,17],[51,10,51,17],[50,0,50,1],[49,0,49,1],[43,10,43,17],[44,0,44,1],[44,2,44,9],[42,0,43,1],[42,2,43,9],[42,18,42,22],[60,0,60,59],[8,10,8,11],[8,12,8,14],[59,44,59,47],[45,44,45,47],[46,44,46,47],[45,23,45,24],[45,25,45,28],[42,10,42,17],[42,23,42,28],[46,0,46,1],[46,2,46,9],[46,18,46,19],[45,0,45,1],[45,2,45,9],[45,18,45,19],[45,20,45,22],[58,2,58,9],[58,18,58,19],[58,23,58,24],[58,25,58,28],[57,25,57,28],[46,23,46,24],[46,25,46,28],[34,0,34,1],[34,2,34,9],[34,10,34,11],[34,12,34,14],[34,19,34,22],[35,19,35,22],[28,0,28,1],[28,2,28,9],[44,77,58,92],[8,15,8,18],[30,53,30,55],[44,18,44,19],[43,18,43,19],[43,20,43,22],[8,53,8,55],[24,53,24,55],[25,53,25,55],[26,53,26,55],[27,53,27,55],[28,53,28,55],[29,53,29,55],[25,19,25,22],[26,19,26,22],[27,19,27,22],[28,19,28,22],[29,19,29,22],[8,19,8,22],[35,56,35,59],[34,37,34,40],[34,56,34,59],[33,35,33,36],[33,37,33,40],[33,56,33,59],[38,35,38,36],[38,37,38,40],[38,56,38,59],[37,56,37,59],[33,41,33,42],[33,43,33,46],[34,41,34,42],[58,41,58,43],[36,10,36,11],[37,10,37,11],[38,10,38,11],[42,41,42,47],[43,41,43,43],[44,41,44,43],[45,41,45,43],[46,41,46,43],[47,41,47,43],[48,41,48,43],[49,41,49,43],[38,19,38,22],[39,19,39,22],[39,35,39,36],[39,53,39,55],[44,20,44,22],[58,44,58,47],[48,25,48,28],[53,44,53,47],[57,44,57,47],[56,44,56,47],[50,44,50,47],[48,44,48,47],[36,12,36,14],[36,41,36,42],[36,43,36,46],[37,41,37,42],[37,43,37,46],[38,41,38,42],[38,43,38,46],[37,12,37,14],[38,15,38,18],[36,56,36,59],[29,56,29,59],[8,56,8,59],[24,15,24,18],[28,15,28,18],[29,15,29,18],[10,56,10,59],[34,35,34,36],[27,56,27,59],[26,35,26,36],[26,37,26,40],[26,56,26,59],[25,35,25,36],[25,37,25,40],[27,35,27,36],[25,15,25,18],[26,15,26,18],[27,15,27,18],[23,35,23,36],[20,35,20,36],[19,15,19,18],[20,15,20,18],[21,35,21,36],[23,53,23,55],[17,19,17,22],[18,19,18,22],[14,56,14,59],[15,53,15,55],[13,53,13,55],[14,53,14,55],[13,19,13,22],[39,0,39,14],[28,35,28,36],[32,0,32,1],[32,2,32,9],[32,10,32,11],[34,53,34,55],[35,53,35,55],[36,53,36,55],[37,53,37,55],[38,53,38,55],[31,19,31,22],[32,19,32,22],[33,19,33,22],[38,0,38,1],[38,2,38,9],[38,12,38,14],[37,0,37,1],[37,2,37,9],[36,0,36,1],[36,2,36,9],[35,0,35,1],[35,2,35,9],[35,10,35,11],[35,12,35,14],[36,23,36,24],[36,25,36,28],[37,23,37,24],[37,25,37,28],[33,29,33,30],[31,23,31,24],[32,12,32,14],[31,0,31,1],[31,2,31,9],[31,10,31,11],[31,12,31,14],[35,35,35,36],[35,37,35,40],[31,35,31,36],[31,37,31,40],[28,10,28,11],[28,12,28,14],[33,0,33,1],[33,2,33,9],[33,10,33,11],[33,12,33,14],[12,56,12,59],[11,35,11,36],[11,37,11,40],[11,56,11,59],[12,35,12,36],[11,15,11,18],[11,0,11,1],[11,2,11,9],[11,12,11,14],[11,10,11,11],[14,0,14,1],[14,2,14,9],[14,12,14,14],[13,15,13,18],[14,15,14,18],[13,2,13,9],[13,10,13,11],[13,12,13,14],[14,10,14,11],[13,0,13,1],[12,0,12,1],[12,2,12,9],[12,12,12,14],[28,56,28,59],[10,12,10,14],[9,19,9,22],[9,15,9,18],[9,0,9,1],[9,2,9,9],[9,53,9,55],[10,53,10,55],[10,19,10,22],[10,10,10,11],[10,35,10,36],[10,37,10,40],[10,15,10,18],[10,2,10,9],[9,35,9,36],[9,37,9,40],[9,10,9,11],[10,0,10,1],[11,53,11,55],[12,53,12,55],[11,19,11,22],[12,19,12,22],[12,10,12,11],[21,10,21,11],[21,2,21,9],[21,12,21,14],[21,19,21,22],[23,19,23,22],[16,0,16,1],[16,2,16,9],[16,12,16,14],[16,10,16,11],[15,2,15,9],[15,10,15,11],[15,12,15,14],[15,0,15,1],[18,0,18,1],[18,2,18,9],[18,12,18,14],[18,10,18,11],[17,2,17,9],[17,10,17,11],[17,12,17,14],[17,0,17,1],[17,15,17,18],[18,15,18,18],[22,0,22,1],[22,2,22,9],[22,10,22,11],[22,12,22,14],[22,15,22,18],[22,19,22,22],[22,35,22,36],[22,37,22,40],[22,53,22,55],[23,37,23,40],[19,2,19,9],[19,10,19,11],[19,12,19,14],[21,15,21,18],[19,0,19,1],[23,0,23,1],[23,2,23,9],[23,10,23,11],[23,12,23,14],[23,15,23,18],[21,0,21,1],[20,0,20,1],[20,2,20,9],[20,12,20,14],[20,10,20,11],[20,19,20,22],[23,23,23,24],[23,25,23,28],[22,31,22,34],[20,53,20,55],[21,53,21,55],[16,19,16,22],[22,56,22,59],[14,19,14,22],[19,35,19,36],[19,19,19,22],[18,37,18,40],[18,56,18,59],[17,53,17,55],[18,53,18,55],[21,37,21,40],[17,37,17,40],[17,56,17,59],[20,37,20,40],[20,56,20,59],[19,37,19,40],[19,56,19,59],[18,35,18,36],[17,35,17,36],[16,43,16,46],[17,41,17,42],[17,43,17,46],[18,41,18,42],[18,43,18,46],[19,41,19,42],[19,43,19,46],[20,41,20,42],[20,43,20,46],[22,29,22,30],[18,29,18,30],[16,41,16,42],[6,10,7,14],[7,15,7,22],[7,35,7,40],[7,53,7,59],[7,29,7,34],[7,23,7,28],[6,35,6,52],[9,77,38,96],[12,15,12,18],[16,35,16,36],[16,37,16,40],[16,56,16,59],[15,35,15,36],[15,37,15,40],[15,56,15,59],[14,35,14,36],[14,37,14,40],[15,19,15,22],[12,37,12,40],[16,53,16,55],[15,15,15,18],[16,15,16,18],[23,56,23,59],[21,56,21,59],[13,35,13,36],[13,37,13,40],[13,56,13,59],[19,53,19,55],[20,29,20,30],[20,31,20,34],[21,29,21,30],[21,31,21,34],[38,23,38,24],[38,25,38,28],[24,23,24,24],[24,25,24,28],[25,23,25,24],[25,25,25,28],[26,23,26,24],[26,25,26,28],[27,23,27,24],[27,25,27,28],[23,29,23,30],[12,23,12,24],[12,25,12,28],[13,23,13,24],[13,25,13,28],[14,23,14,24],[14,25,14,28],[15,23,15,24],[15,25,15,28],[16,23,16,24],[16,25,16,28],[17,23,17,24],[17,25,17,28],[28,23,28,24],[28,25,28,28],[29,23,29,24],[29,25,29,28],[30,23,30,24],[33,25,33,28],[34,23,34,24],[34,25,34,28],[35,23,35,24],[35,25,35,28],[18,23,18,24],[18,25,18,28],[19,23,19,24],[19,25,19,28],[20,23,20,24],[20,25,20,28],[21,23,21,24],[21,25,21,28],[22,23,22,24],[22,25,22,28],[18,31,18,34],[19,29,19,30],[19,31,19,34],[39,23,39,24],[39,25,39,28],[8,29,8,30],[8,31,8,34],[9,29,9,30],[9,31,9,34],[10,29,10,30],[10,31,10,34],[11,29,11,30],[11,31,11,34],[12,29,12,30],[12,31,12,34],[13,29,13,30],[13,31,13,34],[14,29,14,30],[14,31,14,34],[15,29,15,30],[15,31,15,34],[16,29,16,30],[16,31,16,34],[17,29,17,30],[17,31,17,34],[34,31,34,34],[35,29,35,30],[35,31,35,34],[36,29,36,30],[36,31,36,34],[37,31,37,34],[28,31,28,34],[29,29,29,30],[29,31,29,34],[8,23,8,24],[6,15,6,34],[7,41,7,46],[8,41,8,42],[8,43,8,46],[9,41,9,42],[9,43,9,46],[10,41,10,42],[10,43,10,46],[11,41,11,42],[11,43,11,46],[12,41,12,42],[12,43,12,46],[13,41,13,42],[13,43,13,46],[14,41,14,42],[14,43,14,46],[15,41,15,42],[15,43,15,46],[8,25,8,28],[9,23,9,24],[9,25,9,28],[10,23,10,24],[10,25,10,28],[11,23,11,24],[11,25,11,28],[27,43,27,46],[28,41,28,42],[28,43,28,46],[29,41,29,42],[33,31,33,34],[34,29,34,30],[30,43,30,46],[21,41,21,42],[21,43,21,46],[22,41,22,42],[22,43,22,46],[23,41,23,42],[23,43,23,46],[24,41,24,42],[24,43,24,46],[25,41,25,42],[25,43,25,46],[34,43,34,46],[29,43,29,46],[30,41,30,42],[24,31,24,34],[25,29,25,30],[25,31,25,34],[26,29,26,30],[26,31,26,34],[27,29,27,30],[27,31,27,34],[26,41,26,42],[26,43,26,46],[27,41,27,42],[23,31,23,34],[24,29,24,30],[58,29,58,30],[58,31,58,34],[51,29,51,30],[52,29,52,30],[53,29,53,30],[54,29,54,30],[55,29,55,30],[46,29,46,30],[47,29,47,30],[48,37,48,40],[49,35,49,36],[49,37,49,40],[45,31,45,34],[45,29,45,30],[44,31,44,34],[44,29,44,30],[38,29,38,30],[38,31,38,34],[58,35,58,36],[58,37,58,40],[43,31,43,34],[43,29,43,30],[42,29,42,34],[44,37,44,40],[44,35,44,36],[43,37,43,40],[43,35,43,36],[42,35,42,40],[59,31,59,34],[7,47,7,52],[8,47,8,48],[8,49,8,52],[9,47,9,48],[9,49,9,52],[10,47,10,48],[10,49,10,52],[11,47,11,48],[11,49,11,52],[12,47,12,48],[12,49,12,52],[13,47,13,48],[13,49,13,52],[14,47,14,48],[14,49,14,52],[15,47,15,48],[51,31,51,34],[52,31,52,34],[53,31,53,34],[54,31,54,34],[55,31,55,34],[46,31,46,34],[20,47,20,48],[20,49,20,52],[21,47,21,48],[21,49,21,52],[22,47,22,48],[22,49,22,52],[23,47,23,48],[23,49,23,52],[24,47,24,48],[24,49,24,52],[15,49,15,52],[16,47,16,48],[16,49,16,52],[17,47,17,48],[17,49,17,52],[18,47,18,48],[18,49,18,52],[19,47,19,48],[19,49,19,52],[33,47,33,48],[33,49,33,52],[34,47,34,48],[34,49,34,52],[35,47,35,48],[35,49,35,52],[36,47,36,48],[36,49,36,52],[25,47,25,48],[25,49,25,52],[26,47,26,48],[26,49,26,52],[27,47,27,48],[27,49,27,52],[28,47,28,48],[28,49,28,52],[29,47,29,48],[29,49,29,52],[59,37,59,40],[50,35,50,36],[50,37,50,40],[51,35,51,36],[51,37,51,40],[52,35,52,36],[52,37,52,40],[53,35,53,36],[53,37,53,40],[54,35,54,36],[54,37,54,40],[45,35,45,36],[45,37,45,40],[46,35,46,36],[46,37,46,40],[47,35,47,36],[47,37,47,40],[48,35,48,36],[10,60,10,61],[10,62,10,65],[10,66,10,67],[10,68,10,71],[11,60,11,61],[11,62,11,65],[11,66,11,67],[11,68,11,71],[12,60,12,61],[12,62,12,65],[12,66,12,67],[12,68,12,71],[7,60,7,65],[7,66,7,71],[8,60,8,61],[8,62,8,65],[8,66,8,67],[8,68,8,71],[9,60,9,61],[9,62,9,65],[9,66,9,67],[9,68,9,71],[16,60,16,61],[16,62,16,65],[16,66,16,67],[16,68,16,71],[17,60,17,61],[17,62,17,65],[17,66,17,67],[17,68,17,71],[18,60,18,61],[18,62,18,65],[18,66,18,67],[18,68,18,71],[13,60,13,61],[13,62,13,65],[13,66,13,67],[13,68,13,71],[14,60,14,61],[14,62,14,65],[14,66,14,67],[14,68,14,71],[15,60,15,61],[15,62,15,65],[15,66,15,67],[15,68,15,71],[22,60,22,61],[22,62,22,65],[22,66,22,67],[22,68,22,71],[23,60,23,61],[23,62,23,65],[23,66,23,67],[23,68,23,71],[24,60,24,61],[24,62,24,65],[24,66,24,67],[24,68,24,71],[19,60,19,61],[19,62,19,65],[19,66,19,67],[19,68,19,71],[20,60,20,61],[20,62,20,65],[20,66,20,67],[20,68,20,71],[21,60,21,61],[21,62,21,65],[21,66,21,67],[21,68,21,71],[28,60,28,61],[28,62,28,65],[28,66,28,67],[28,68,28,71],[29,60,29,61],[29,62,29,65],[29,66,29,67],[29,68,29,71],[30,60,30,61],[30,62,30,65],[30,66,30,67],[30,68,30,71],[25,60,25,61],[25,62,25,65],[25,66,25,67],[25,68,25,71],[26,60,26,61],[26,62,26,65],[26,66,26,67],[26,68,26,71],[27,60,27,61],[27,62,27,65],[27,66,27,67],[27,68,27,71],[40,0,41,59],[39,29,39,30],[39,31,39,34],[37,29,37,30],[34,60,34,61],[34,62,34,65],[34,66,34,67],[34,68,34,71],[35,60,35,61],[35,62,35,65],[35,66,35,67],[35,68,35,71],[36,60,36,61],[36,62,36,65],[36,66,36,67],[36,68,36,71],[31,60,31,61],[31,62,31,65],[31,66,31,67],[31,68,31,71],[32,60,32,61],[32,62,32,65],[32,66,32,67],[32,68,32,71],[33,60,33,61],[33,62,33,65],[33,66,33,67],[33,68,33,71],[35,41,35,42],[35,43,35,46],[39,41,39,42],[39,43,39,46],[37,60,37,61],[37,62,37,65],[37,66,37,67],[37,68,37,71],[38,60,38,61],[38,62,38,65],[38,66,38,67],[38,68,38,71],[39,60,39,61],[39,62,39,65],[39,66,39,67],[39,68,39,71],[38,47,38,48],[38,49,38,52],[39,47,39,48],[39,49,39,52],[37,47,37,48],[37,49,37,52],[39,56,39,59],[59,50,59,53],[59,56,59,59],[54,48,54,49],[54,50,54,53],[54,54,54,55],[54,56,54,59],[55,48,55,49],[55,50,55,53],[55,54,55,55],[55,56,55,59],[56,48,56,49],[56,50,56,53],[56,54,56,55],[56,56,56,59],[48,54,48,55],[48,56,48,59],[49,48,49,49],[49,50,49,53],[49,54,49,55],[49,56,49,59],[50,48,50,49],[50,50,50,53],[50,54,50,55],[50,56,50,59],[52,48,52,49],[52,50,52,53],[52,54,52,55],[52,56,52,59],[53,48,53,49],[53,50,53,53],[53,54,53,55],[53,56,53,59],[57,48,57,49],[57,50,57,53],[57,54,57,55],[57,56,57,59],[58,48,58,49],[58,50,58,53],[58,54,58,55],[58,56,58,59],[4,0,5,71],[6,53,6,71],[0,4,0,21],[0,22,1,25],[0,26,1,42],[1,4,1,21],[2,4,2,21],[2,22,2,25],[2,26,2,42],[3,4,3,21],[3,22,3,25],[3,26,3,42],[0,43,3,71],[51,48,51,49],[51,50,51,53],[51,54,51,55],[51,56,51,59],[45,48,45,49],[45,50,45,53],[45,54,45,55],[45,56,45,59],[46,48,46,49],[43,50,43,53],[43,54,43,55],[46,50,46,53],[46,54,46,55],[46,56,46,59],[47,48,47,49],[47,50,47,53],[47,54,47,55],[47,56,47,59],[42,48,42,53],[42,54,42,59],[43,48,43,49],[52,44,52,47],[51,44,51,47],[49,44,49,47],[54,44,54,47],[55,35,55,36],[55,37,55,40],[48,29,48,30],[48,31,48,34],[49,29,49,30],[49,31,49,34],[50,29,50,30],[50,31,50,34],[48,48,48,49],[48,50,48,53],[43,56,43,59],[44,48,44,49],[44,50,44,53],[44,54,44,55],[44,56,44,59],[44,44,44,47],[43,44,43,47],[47,44,47,47],[56,23,56,24],[55,44,55,47],[52,41,52,43],[51,41,51,43],[50,41,50,43],[56,41,56,43],[55,41,55,43],[55,25,55,28],[56,35,56,36]],"merged_total":1022,"flags":["merged_cut"]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Amounts in $CAD"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["A.1) Work Complete - Unit Rate Basis"]
[]
["Item",null,"Description",null,null,null,null,null,null,null,"Basis of Payment",null,null,null,null,"Current Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Month(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Work Done"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regular",null,null,null,null,null,null,null,"Travel",null,null,null,null,null,"Total",null,null,null,null,null,"Regular",null,null,null,null,null,"Travel",null,null,null,null,null,"Total",null,null,null,null,null,"Regular Hours",null,null,null,null,null,null,"Travel",null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,"UOM",null,"Rate",null,null,"Hours (qty.)",null,null,null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,null,"Amount",null,null,null,"Hours (qty.)",null,"Amount",null,null,null,"Hours (qty.)",null,"Amount"]
[1,null,{"$f":"'Rates Schedule'!A8","v":"CAT. 1 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C10,'Rates Schedule'!A1:V44,20,'Rates Schedule'!A1:V44), \"\")","v":100},null,null,50,null,null,null,{"$f":"IF(P10>0, P10*M10, \"\")","v":5000},null,null,null,80,null,{"$f":"IF(X10>0, X10*(M10), \"\")","v":8000},null,null,null,{"$f":"IF(X10+P10=0, \"\", X10+P10)","v":130},null,{"$f":"IFERROR(T10+Z10, \"\")","v":13000},null,null,null,75,null,{"$f":"IF(AJ10>0, AJ10*M10, \"\")","v":7500},null,null,null,80,null,{"$f":"IF(AP10>0, AP10*M10, \"\")","v":8000},null,null,null,{"$f":"IF(AP10+AJ10=0, \"\", AP10+AJ10)","v":155},null,{"$f":"IFERROR(AL10+AR10, \"\")","v":15500},null,null,null,{"$f":"IF(P10+AJ10>0,  P10+AJ10, \"\")","v":125},null,null,{"$f":"IFERROR(IF(BB10>0,BB10*M10, \"\"), \"\")","v":12500},null,null,null,{"$f":"IF(X10+AP10>0,  X10+AP10, \"\")","v":160},null,{"$f":"IFERROR(IF(BI10>0,BI10*M10, \"\"), \"\")","v":16000},null,null,null,{"$f":"IFERROR(IF(BI10+BB10=0, \"\", BI10+BB10), \"\")","v":285},null,{"$f":"IFERROR(BE10+BK10, \"\")","v":28500},null,null,null,null,null,null,null,null,"Update this part every month, if applciable"]
[2,null,{"$f":"'Rates Schedule'!A9","v":"CAT. 2 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C11,'Rates Schedule'!A1:V44,20,'Rates Schedule'!A1:V44), \"\")","v":0},null,null,null,null,null,null,{"$f":"IF(P11>0, P11*M11, \"\")","v":""},null,null,null,null,null,{"$f":"IF(X11>0, X11*G11, \"\")","v":""},null,null,null,{"$f":"IF(X11+P11=0, \"\", X11+P11)","v":""},null,{"$f":"IFERROR(T11+Z11, \"\")","v":""},null,null,null,null,null,{"$f":"IF(AJ11>0, AJ11*M11, \"\")","v":""},null,null,null,null,null,{"$f":"IF(AP11>0, AP11*S11, \"\")","v":""},null,null,null,{"$f":"IF(AP11+AJ11=0, \"\", AP11+AJ11)","v":""},null,{"$f":"IFERROR(AL11+AR11, \"\")","v":""},null,null,null,{"$f":"IF(P11+AJ11>0,  P11+AJ11, \"\")","v":""},null,null,{"$f":"IFERROR(IF(BB11>0,BB11*M11, \"\"), \"\")","v":""},null,null,null,{"$f":"IF(X11+AP11>0,  X11+AP11, \"\")","v":""},null,{"$f":"IFERROR(IF(BI11>0,BI11*M11, \"\"), \"\")","v":""},null,null,null,{"$f":"IFERROR(IF(BI11+BB11=0, \"\", BI11+BB11), \"\")","v":""},null,{"$f":"IFERROR(BE11+BK11, \"\")","v":""}]
[3,null,{"$f":"'Rates Schedule'!A10","v":"CAT. 3 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C12,'Rates Schedule'!A2:V45,20,'Rates Schedule'!A2:V45), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[4,null,{"$f":"'Rates Schedule'!A11","v":"CAT. 4 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C13,'Rates Schedule'!A3:V46,20,'Rates Schedule'!A3:V46), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[5,null,{"$f":"'Rates Schedule'!A12","v":"CAT. 5 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C14,'Rates Schedule'!A4:V47,20,'Rates Schedule'!A4:V47), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,{"$f":"IF(X14+P14=0, \"\", X14+P14)","v":""},null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(AL14+AR14, \"\")","v":""},null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[6,null,{"$f":"'Rates Schedule'!A13","v":"CAT. 6 2016"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C15,'Rates Schedule'!A5:V48,20,'Rates Schedule'!A5:V48), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,{"$f":"IFERROR(T15+Z15, \"\")","v":""},null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[7,null,{"$f":"'Rates Schedule'!A14","v":"CAT. 1 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C16,'Rates Schedule'!A6:V49,20,'Rates Schedule'!A6:V49), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[8,null,{"$f":"'Rates Schedule'!A15","v":"CAT. 2 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C17,'Rates Schedule'!A7:V50,20,'Rates Schedule'!A7:V50), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[9,null,{"$f":"'Rates Schedule'!A16","v":"CAT. 3 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C18,'Rates Schedule'!A8:V51,20,'Rates Schedule'!A8:V51), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[10,null,{"$f":"'Rates Schedule'!A17","v":"CAT. 4 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C19,'Rates Schedule'!A2:V45,20,'Rates Schedule'!A2:V45), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[11,null,{"$f":"'Rates Schedule'!A18","v":"CAT. 5 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C20,'Rates Schedule'!A3:V46,20,'Rates Schedule'!A3:V46), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[12,null,{"$f":"'Rates Schedule'!A19","v":"CAT. 6 2017"},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C21,'Rates Schedule'!A4:V47,20,'Rates Schedule'!A4:V47), \"\")","v":0},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[13,null,{"$f":"'Rates Schedule'!A20","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C22,'Rates Schedule'!A5:V48,20,'Rates Schedule'!A5:V48), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[14,null,{"$f":"'Rates Schedule'!A21","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C23,'Rates Schedule'!A6:V49,20,'Rates Schedule'!A6:V49), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[15,null,{"$f":"'Rates Schedule'!A22","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C24,'Rates Schedule'!A7:V50,20,'Rates Schedule'!A7:V50), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[16,null,{"$f":"'Rates Schedule'!A23","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C25,'Rates Schedule'!A8:V51,20,'Rates Schedule'!A8:V51), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[17,null,{"$f":"'Rates Schedule'!A24","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C26,'Rates Schedule'!A9:V52,20,'Rates Schedule'!A9:V52), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[18,null,{"$f":"'Rates Schedule'!A25","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C27,'Rates Schedule'!A10:V53,20,'Rates Schedule'!A10:V53), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[19,null,{"$f":"'Rates Schedule'!A26","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C28,'Rates Schedule'!A11:V54,20,'Rates Schedule'!A11:V54), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[20,null,{"$f":"'Rates Schedule'!A27","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C29,'Rates Schedule'!A12:V55,20,'Rates Schedule'!A12:V55), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[21,null,{"$f":"'Rates Schedule'!A28","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C30,'Rates Schedule'!A13:V56,20,'Rates Schedule'!A13:V56), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[22,null,{"$f":"'Rates Schedule'!A29","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C31,'Rates Schedule'!A14:V57,20,'Rates Schedule'!A14:V57), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[23,null,{"$f":"'Rates Schedule'!A30","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C32,'Rates Schedule'!A15:V58,20,'Rates Schedule'!A15:V58), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[24,null,{"$f":"'Rates Schedule'!A31","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C33,'Rates Schedule'!A16:V59,20,'Rates Schedule'!A16:V59), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[25,null,{"$f":"'Rates Schedule'!A32","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C34,'Rates Schedule'!A17:V60,20,'Rates Schedule'!A17:V60), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[26,null,{"$f":"'Rates Schedule'!A33","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C35,'Rates Schedule'!A18:V61,20,'Rates Schedule'!A18:V61), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[27,null,{"$f":"'Rates Schedule'!A34","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C36,'Rates Schedule'!A19:V62,20,'Rates Schedule'!A19:V62), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[28,null,{"$f":"'Rates Schedule'!A35","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C37,'Rates Schedule'!A20:V63,20,'Rates Schedule'!A20:V63), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[29,null,{"$f":"'Rates Schedule'!A36","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C38,'Rates Schedule'!A21:V64,20,'Rates Schedule'!A21:V64), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
[30,null,{"$f":"'Rates Schedule'!A37","v":0},null,null,null,null,null,null,null,"hr",null,{"$f":"IFERROR(VLOOKUP(C39,'Rates Schedule'!A22:V65,20,'Rates Schedule'!A22:V65), \"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"",null,"",null,null,null,"",null,null,"",null,null,null,"",null,"",null,null,null,"",null,""]
["Totals:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P10:S39)","v":50},null,null,null,{"$f":"SUM(T10:W39)","v":5000},null,null,null,{"$f":"SUM(X10:Y39)","v":80},null,{"$f":"SUM(Z10:AC39)","v":8000},null,null,null,{"$f":"SUM(AD10:AE39)","v":130},null,{"$f":"SUM(AF10:AI39)","v":13000},null,null,null,{"$f":"SUM(AJ10:AK39)","v":75},null,{"$f":"SUM(AL10:AO39)","v":7500},null,null,null,{"$f":"SUM(AP10:AQ39)","v":80},null,{"$f":"SUM(AR10:AU39)","v":8000},null,null,null,{"$f":"SUM(AV10:AW39)","v":155},null,{"$f":"SUM(AX10:BA39)","v":15500},null,null,null,{"$f":"SUM(BB10:BD39)","v":125},null,null,{"$f":"SUM(BE10:BH39)","v":12500},null,null,null,{"$f":"SUM(BI10:BJ39)","v":160},null,{"$f":"SUM(BK10:BN39)","v":16000},null,null,null,{"$f":"SUM(BO10:BP39)","v":285},null,{"$f":"SUM(BQ10:BT39)","v":28500}]
["A.2) Work Complete - Milestone Basis (GOODS ONLY)"]
[]
["Item",null,"Description",null,null,null,null,null,null,null,"Basis of Payment",null,null,null,null,null,null,null,"Current Month",null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Total Work Done",null,null,null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Previous Month(s)"]
[null,null,null,null,null,null,null,null,null,null,"Value",null,null,null,null,null,null,null,"% Comp.",null,"Amount",null,null,"% Comp.",null,"Amount",null,null,null,"% Comp.",null,"Amount",null,null,null,"% Comp.",null,"Amount",null,null,null,"% Comp.",null,null,"Amount",null,null,null,"% Comp.",null,"Amount",null,null,null,"% Comp.",null,"Amount"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S45=1, IF(X45<>1, K45, \"\"), \"\")","v":""},null,null,null,null,{"$f":"IF(X45=1,K45,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AD45=1,Q45,\"\")","v":""},null,null,null,null,null,{"$f":"IF(AJ45=1,W45,\"\")","v":""},null,null,null,{"$f":"S45","v":0},null,null,{"$f":"IF(AP45=1, K45, \"\")","v":""},null,null,null,null,null,{"$f":"IF(AW45=1,X45,\"\")","v":""},null,null,null,null,null,{"$f":"IF(BC45=1,AD45,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Update this part every month, if applicable"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,0,null,null,"",null,null,null,null,null,"",null,null,null,null,null,""]
["Totals:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U45:W59)","v":0},null,null,null,null,{"$f":"SUM(Z45:AC59)","v":0},null,null,null,null,null,{"$f":"SUM(AF45:AI59)","v":0},null,null,null,null,null,{"$f":"SUM(AL45:AO59)","v":0},null,null,null,null,null,null,{"$f":"SUM(AS45:AV59)","v":0},null,null,null,null,null,{"$f":"SUM(AY45:BB59)","v":0},null,null,null,null,null,{"$f":"SUM(BE45:BH59)","v":0}]
[{"$f":"\"All amounts in \"&'Payment Claim'!E15&\".\"","v":"All amounts in CAD."}]

{"sheet":"B-Variation","index":2,"n_rows":42,"n_cols":63,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,32,23,34],[23,35,23,38],[24,0,24,1],[24,2,24,9],[24,10,24,12],[24,13,24,18],[24,19,24,20],[24,21,24,22],[24,23,24,25],[24,26,24,27],[24,28,24,31],[24,32,24,34],[24,35,24,38],[23,0,23,1],[23,2,23,9],[23,10,23,12],[23,13,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,25],[23,26,23,27],[23,28,23,31],[21,32,21,34],[21,35,21,38],[22,0,22,1],[22,2,22,9],[22,10,22,12],[22,13,22,18],[22,19,22,20],[22,21,22,22],[22,23,22,25],[22,26,22,27],[22,28,22,31],[22,32,22,34],[22,35,22,38],[21,0,21,1],[21,2,21,9],[21,10,21,12],[21,13,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,25],[21,26,21,27],[21,28,21,31],[17,32,17,34],[17,35,17,38],[18,0,18,1],[18,2,18,9],[18,10,18,12],[18,13,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,25],[18,26,18,27],[18,28,18,31],[18,32,18,34],[18,35,18,38],[17,0,17,1],[17,2,17,9],[17,10,17,12],[17,13,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,25],[17,26,17,27],[17,28,17,31],[12,32,12,34],[12,35,12,38],[13,0,13,1],[13,2,13,9],[13,10,13,12],[13,13,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,25],[13,26,13,27],[13,28,13,31],[13,32,13,34],[13,35,13,38],[12,0,12,1],[12,2,12,9],[12,10,12,12],[12,13,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,25],[12,26,12,27],[12,28,12,31],[19,32,19,34],[19,35,19,38],[20,0,20,1],[20,2,20,9],[20,10,20,12],[20,13,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,25],[20,26,20,27],[20,28,20,31],[20,32,20,34],[20,35,20,38],[19,0,19,1],[19,2,19,9],[19,10,19,12],[19,13,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,25],[19,26,19,27],[19,28,19,31],[25,32,25,34],[25,35,25,38],[26,0,26,1],[26,2,26,9],[26,10,26,12],[26,13,26,18],[26,19,26,20],[26,21,26,22],[26,23,26,25],[26,26,26,27],[26,28,26,31],[26,32,26,34],[26,35,26,38],[41,0,41,38],[37,21,37,22],[37,10,37,12],[14,0,14,1],[14,2,14,9],[14,10,14,12],[14,13,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,25],[14,26,14,27],[14,28,14,31],[14,32,14,34],[14,35,14,38],[15,0,15,1],[15,2,15,9],[15,10,15,12],[15,13,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,25],[15,26,15,27],[15,28,15,31],[15,32,15,34],[8,32,8,34],[8,35,8,38],[9,10,9,12],[9,21,9,22],[10,10,10,12],[11,21,11,22],[27,21,27,22],[29,10,29,12],[28,10,28,12],[28,21,28,22],[29,21,29,22],[15,35,15,38],[16,10,16,12],[16,13,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,25],[16,26,16,27],[16,28,16,31],[16,32,16,34],[16,35,16,38],[25,10,25,12],[25,13,25,18],[25,19,25,20],[0,44,3,62],[3,0,3,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[0,16,1,19],[2,16,2,19],[3,16,3,19],[7,21,7,22],[4,0,5,38],[0,20,1,33],[2,20,2,33],[3,20,3,33],[6,10,7,12],[6,19,7,20],[6,13,7,18],[0,34,3,38],[8,44,37,55],[6,0,7,1],[6,2,7,9],[6,21,6,25],[6,26,6,31],[6,32,6,38],[7,23,7,25],[7,26,7,27],[7,28,7,31],[7,32,7,34],[7,35,7,38],[8,0,8,1],[8,2,8,9],[8,13,8,18],[8,23,8,25],[8,26,8,27],[10,21,10,22],[8,21,8,22],[8,10,8,12],[34,10,34,12],[30,10,30,12],[31,10,31,12],[11,10,11,12],[27,10,27,12],[9,0,9,1],[9,2,9,9],[9,13,9,18],[9,23,9,25],[9,26,9,27],[9,28,9,31],[9,32,9,34],[9,35,9,38],[10,0,10,1],[10,2,10,9],[10,13,10,18],[10,23,10,25],[10,26,10,27],[10,28,10,31],[10,32,10,34],[10,35,10,38],[11,0,11,1],[11,2,11,9],[11,13,11,18],[11,23,11,25],[11,26,11,27],[11,28,11,31],[11,32,11,34],[11,35,11,38],[27,0,27,1],[27,2,27,9],[27,13,27,18],[27,23,27,25],[27,26,27,27],[27,28,27,31],[27,32,27,34],[27,35,27,38],[16,0,16,1],[16,2,16,9],[25,0,25,1],[25,2,25,9],[25,21,25,22],[25,23,25,25],[25,26,25,27],[25,28,25,31],[28,35,28,38],[29,0,29,1],[29,2,29,9],[29,13,29,18],[29,23,29,25],[29,26,29,27],[29,28,29,31],[29,32,29,34],[29,35,29,38],[28,13,28,18],[28,0,28,1],[28,2,28,9],[28,23,28,25],[28,26,28,27],[28,28,28,31],[28,32,28,34],[30,0,30,1],[30,2,30,9],[30,13,30,18],[30,23,30,25],[30,26,30,27],[30,28,30,31],[30,32,30,34],[30,35,30,38],[31,0,31,1],[31,2,31,9],[31,13,31,18],[31,23,31,25],[31,26,31,27],[31,28,31,31],[31,32,31,34],[31,35,31,38],[31,21,31,22],[30,21,30,22],[32,0,32,1],[32,2,32,9],[32,13,32,18],[32,21,32,22],[32,23,32,25],[32,26,32,27],[32,28,32,31],[32,32,32,34],[32,35,32,38],[32,10,32,12],[32,19,32,20],[33,26,33,27],[33,28,33,31],[33,32,33,34],[33,35,33,38],[34,0,34,1],[34,2,34,9],[34,13,34,18],[34,23,34,25],[34,26,34,27],[34,28,34,31],[34,32,34,34],[34,35,34,38],[34,19,34,20],[33,21,33,22],[34,21,34,22],[33,10,33,12],[33,19,33,20],[36,19,36,20],[36,10,36,12],[36,21,36,22],[35,21,35,22],[35,10,35,12],[33,0,33,1],[33,2,33,9],[33,13,33,18],[33,23,33,25],[37,13,37,18],[37,23,37,25],[37,26,37,27],[37,28,37,31],[37,32,37,34],[37,35,37,38],[37,19,37,20],[35,0,35,1],[35,2,35,9],[35,13,35,18],[35,23,35,25],[35,26,35,27],[35,28,35,31],[35,32,35,34],[35,35,35,38],[36,0,36,1],[36,2,36,9],[36,13,36,18],[36,23,36,25],[36,26,36,27],[36,28,36,31],[36,32,36,34],[36,35,36,38],[35,19,35,20],[8,28,8,31],[40,23,40,25],[40,28,40,31],[40,35,40,38],[38,0,38,12],[38,13,38,18],[39,0,39,12],[39,13,39,18],[40,0,40,12],[40,13,40,18],[40,19,40,22],[38,19,38,38],[39,19,39,38],[8,19,8,20],[9,19,9,20],[10,19,10,20],[11,19,11,20],[27,19,27,20],[28,19,28,20],[29,19,29,20],[30,19,30,20],[31,19,31,20],[37,0,37,1],[37,2,37,9]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updates Automatically from Payment Claim Sheet"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["B) Variation(s) Summary"]
[]
["Item",null,"Change Orders",null,null,null,null,null,null,null,"Approved (Y/N)",null,null,"Value ($)",null,null,null,null,null,"LOE (Y/N)",null,"Current Month",null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Total Non-LOE Work Done"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Comp.",null,"Amount",null,null,"% Comp.",null,"Amount",null,null,null,"% Comp.",null,null,"Amount"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK9=\"N\",  IF(V9=1, IF(AA9<>1, N9, \"\"), \"\"), \"\")","v":""},null,null,null,null,{"$f":"IF(BK9=\"N\", IF(AA9=1,N9,\"\"), \"\")","v":""},null,null,null,{"$f":"IF(V9>0, V9, \"\")","v":""},null,null,{"$f":"IF(AG9=1, N9, \"\")","v":""},null,null,null,null,{"$f":"IF(AA9=1, IF(V9<>AA9, \"ERROR!\", \"\"), \"\")","v":""},null,null,null,"Update this part every month.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T9=\"N\", IF(K9=\"Y\", \"N\", \"\"), \"\")","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,{"$f":"IF(V10>0, V10, \"\")","v":""},null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,{"$f":"IF(AA12=1, IF(V12<>AA12, \"ERROR!\", \"\"), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(AG13=1, N13, \"\")","v":""},null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T19=\"N\", IF(K19=\"Y\", \"N\", \"\"), \"\")","v":""}]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"",null,null,null,"",null,null,"",null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["Limitation of Expenditure (LOE) (Sub-total):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(N9:N38,T9:T38, \"Y\", K9:K38, \"Y\")","v":0}]
["Other (Sub-total):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(N9:N38,T9:T38, \"N\", K9:K38, \"Y\")","v":0}]
["Total Value Approved:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N39:S40)","v":0},null,null,null,null,null,"Totals:",null,null,null,{"$f":"SUM(X9:Z38)","v":0},null,null,null,null,{"$f":"SUM(AC9:AF38)","v":0},null,null,null,null,null,null,{"$f":"SUM(AJ9:AM38)","v":0}]
[{"$f":"\"All amounts in \"&'Payment Claim'!E15&\".\"","v":"All amounts in CAD."}]

{"sheet":"C-Backcharges","index":3,"n_rows":24,"n_cols":42,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,30,21,35],[22,30,22,35],[14,30,14,35],[15,30,15,35],[16,30,16,35],[17,30,17,35],[18,30,18,35],[8,30,8,35],[9,30,9,35],[10,30,10,35],[11,30,11,35],[12,30,12,35],[13,30,13,35],[23,0,23,35],[6,2,6,17],[7,2,7,17],[8,2,8,17],[9,2,9,17],[10,2,10,17],[11,2,11,17],[12,2,12,17],[13,2,13,17],[14,2,14,17],[15,2,15,17],[16,2,16,17],[17,2,17,17],[18,2,18,17],[19,2,19,17],[20,2,20,17],[22,0,22,17],[21,2,21,17],[21,18,21,23],[22,18,22,23],[21,24,21,29],[22,24,22,29],[21,0,21,1],[20,0,20,1],[19,18,19,23],[20,18,20,23],[19,24,19,29],[20,24,20,29],[19,30,19,35],[19,0,19,1],[18,0,18,1],[17,18,17,23],[18,18,18,23],[17,24,17,29],[18,24,18,29],[17,0,17,1],[20,30,20,35],[16,0,16,1],[15,18,15,23],[16,18,16,23],[15,24,15,29],[16,24,16,29],[15,0,15,1],[14,0,14,1],[13,18,13,23],[14,18,14,23],[13,24,13,29],[14,24,14,29],[13,0,13,1],[6,30,6,35],[6,0,6,1],[6,18,6,23],[6,24,6,29],[12,0,12,1],[11,18,11,23],[12,18,12,23],[11,24,11,29],[12,24,12,29],[11,0,11,1],[10,0,10,1],[9,18,9,23],[10,18,10,23],[9,24,9,29],[10,24,10,29],[9,0,9,1],[4,0,5,35],[7,41,21,52],[0,41,3,59],[3,0,3,3],[3,4,3,17],[3,22,3,35],[0,0,0,3],[0,4,0,17],[0,18,1,21],[0,22,1,35],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[2,22,2,35],[3,18,3,21],[8,0,8,1],[7,18,7,23],[8,18,8,23],[7,24,7,29],[8,24,8,29],[7,30,7,35],[7,0,7,1]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updates Automatically from Payment Claim Sheet"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["C) Backcharges/Set-off"]
[]
["Item",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Month",null,null,null,null,null,"Previous Month(s)",null,null,null,null,null,"Total"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S8:AD8)<>0, SUM(S8:AD8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Update this part every month."]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S9:AD9)<>0, SUM(S9:AD9), \"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S10:AD10)<>0, SUM(S10:AD10), \"\")","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(S22:AD22)<>0, SUM(S22:AD22), \"\")","v":""}]
["Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:X22)*-1","v":0},null,null,null,null,null,{"$f":"SUM(Y8:AD22)*-1","v":0},null,null,null,null,null,{"$f":"SUM(AE8:AJ22)*-1","v":0}]
[{"$f":"\"All amounts in \"&'Payment Claim'!E15&\".\"","v":"All amounts in CAD."}]

{"sheet":"D-Travel & Living","index":4,"n_rows":55,"n_cols":90,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,89,10,104],[4,70,5,85],[6,70,6,85],[7,70,7,79],[8,70,8,79],[9,70,9,79],[10,70,10,79],[7,80,7,85],[8,80,8,85],[9,80,9,85],[10,80,10,85],[50,47,50,55],[50,56,50,59],[15,66,15,78],[49,52,49,55],[23,50,23,51],[23,47,23,49],[25,50,25,51],[27,50,27,51],[29,50,29,51],[31,50,31,51],[33,50,33,51],[35,50,35,51],[37,50,37,51],[39,50,39,51],[41,50,41,51],[43,50,43,51],[45,50,45,51],[47,50,47,51],[49,50,49,51],[25,47,25,49],[27,47,27,49],[29,47,29,49],[31,47,31,49],[36,52,36,53],[36,54,36,55],[35,52,35,55],[37,52,37,55],[34,47,34,49],[34,50,34,51],[34,52,34,53],[34,54,34,55],[49,47,49,49],[39,47,39,49],[43,52,43,55],[45,52,45,55],[47,52,47,55],[43,47,43,49],[45,47,45,49],[47,47,47,49],[46,50,46,51],[46,52,46,53],[46,54,46,55],[18,79,19,86],[19,60,19,68],[18,47,18,68],[51,0,51,78],[23,52,23,55],[25,52,25,55],[27,52,27,55],[29,52,29,55],[31,52,31,55],[33,52,33,55],[18,0,19,4],[18,5,19,10],[18,11,19,23],[18,24,19,28],[18,29,19,38],[18,39,19,46],[18,69,19,72],[18,73,19,78],[50,39,50,46],[19,56,19,59],[19,47,19,55],[33,47,33,49],[35,47,35,49],[37,47,37,49],[20,56,21,59],[22,56,23,59],[24,56,25,59],[26,56,27,59],[28,56,29,59],[30,56,31,59],[32,56,33,59],[34,56,35,59],[36,56,37,59],[44,56,45,59],[46,56,47,59],[48,56,49,59],[48,47,48,49],[48,50,48,51],[48,52,48,53],[48,54,48,55],[44,47,44,49],[44,50,44,51],[44,52,44,53],[44,54,44,55],[46,47,46,49],[50,29,50,38],[50,73,50,78],[20,89,49,108],[22,79,23,86],[24,79,25,86],[26,79,27,86],[28,79,29,86],[30,79,31,86],[32,79,33,86],[34,79,35,86],[36,79,37,86],[38,79,39,86],[40,79,41,86],[42,79,43,86],[44,79,45,86],[46,79,47,86],[48,79,49,86],[34,64,34,66],[34,67,34,68],[35,60,35,68],[36,60,36,63],[38,56,39,59],[40,56,41,59],[42,56,43,59],[16,0,17,86],[50,0,50,23],[51,79,51,86],[50,79,50,86],[50,60,50,68],[50,69,50,72],[48,60,48,63],[48,64,48,66],[48,67,48,68],[49,60,49,68],[20,79,21,86],[38,60,38,63],[38,64,38,66],[38,67,38,68],[39,60,39,68],[40,60,40,63],[40,64,40,66],[40,67,40,68],[41,60,41,68],[42,60,42,63],[42,64,42,66],[42,67,42,68],[33,60,33,68],[34,60,34,63],[52,79,52,86],[43,60,43,68],[44,60,44,63],[44,64,44,66],[44,67,44,68],[45,60,45,68],[46,60,46,63],[46,64,46,66],[46,67,46,68],[47,60,47,68],[45,73,45,78],[48,69,48,72],[49,69,49,72],[45,69,45,72],[46,69,46,72],[47,69,47,72],[46,73,46,78],[47,73,47,78],[48,73,48,78],[49,73,49,78],[36,64,36,66],[36,67,36,68],[37,60,37,68],[28,64,28,66],[28,67,28,68],[29,60,29,68],[30,60,30,63],[30,64,30,66],[30,67,30,68],[31,60,31,68],[32,60,32,63],[32,64,32,66],[32,67,32,68],[20,60,20,63],[20,64,20,66],[20,67,20,68],[21,60,21,68],[22,60,22,63],[22,64,22,66],[22,67,22,68],[23,60,23,68],[24,60,24,63],[24,64,24,66],[24,67,24,68],[25,60,25,68],[26,60,26,63],[26,64,26,66],[26,67,26,68],[27,60,27,68],[42,69,42,72],[43,69,43,72],[44,69,44,72],[28,60,28,63],[35,69,35,72],[36,69,36,72],[37,69,37,72],[38,69,38,72],[39,69,39,72],[40,69,40,72],[41,69,41,72],[26,69,26,72],[27,69,27,72],[28,69,28,72],[29,69,29,72],[30,69,30,72],[31,69,31,72],[32,69,32,72],[33,69,33,72],[36,73,36,78],[37,73,37,78],[38,73,38,78],[39,73,39,78],[40,73,40,78],[41,73,41,78],[42,73,42,78],[43,73,43,78],[44,73,44,78],[34,69,34,72],[20,69,20,72],[21,69,21,72],[22,69,22,72],[23,69,23,72],[42,47,42,49],[42,50,42,51],[42,52,42,53],[42,54,42,55],[38,47,38,49],[38,50,38,51],[38,52,38,53],[38,54,38,55],[24,69,24,72],[25,69,25,72],[40,47,40,49],[40,50,40,51],[40,52,40,53],[40,54,40,55],[39,52,39,55],[41,52,41,55],[41,47,41,49],[36,47,36,49],[36,50,36,51],[22,54,22,55],[20,54,20,55],[21,47,21,49],[21,52,21,55],[24,54,24,55],[32,47,32,49],[32,50,32,51],[32,52,32,53],[32,54,32,55],[30,47,30,49],[30,50,30,51],[30,52,30,53],[30,54,30,55],[26,50,26,51],[26,52,26,53],[26,54,26,55],[28,47,28,49],[28,50,28,51],[28,52,28,53],[28,54,28,55],[20,47,20,49],[20,50,20,51],[20,52,20,53],[26,47,26,49],[24,47,24,49],[24,50,24,51],[24,52,24,53],[21,50,21,51],[22,47,22,49],[22,50,22,51],[22,52,22,53],[49,29,49,38],[45,29,45,38],[46,29,46,30],[46,31,46,32],[46,34,46,36],[46,37,46,38],[47,29,47,38],[48,29,48,30],[48,31,48,32],[48,34,48,36],[39,29,39,38],[40,29,40,30],[40,31,40,32],[40,34,40,36],[40,37,40,38],[48,37,48,38],[41,29,41,38],[42,29,42,30],[42,31,42,32],[42,34,42,36],[42,37,42,38],[43,29,43,38],[44,29,44,30],[44,31,44,32],[44,34,44,36],[44,37,44,38],[35,29,35,38],[36,29,36,30],[36,31,36,32],[36,34,36,36],[36,37,36,38],[37,29,37,38],[38,29,38,30],[38,31,38,32],[38,34,38,36],[38,37,38,38],[29,29,29,38],[30,29,30,30],[30,31,30,32],[30,34,30,36],[30,37,30,38],[34,29,34,30],[34,31,34,32],[34,34,34,36],[34,37,34,38],[46,20,46,23],[20,29,20,30],[20,31,20,32],[20,34,20,36],[20,37,20,38],[21,29,21,38],[22,29,22,30],[22,31,22,32],[22,34,22,36],[22,37,22,38],[23,29,23,38],[24,29,24,30],[24,31,24,32],[24,34,24,36],[24,37,24,38],[25,29,25,38],[26,29,26,30],[26,31,26,32],[26,34,26,36],[26,37,26,38],[27,29,27,38],[28,29,28,30],[28,31,28,32],[28,34,28,36],[47,18,47,19],[48,18,48,19],[49,18,49,19],[29,20,29,23],[30,20,30,23],[31,20,31,23],[32,20,32,23],[33,20,33,23],[34,20,34,23],[35,20,35,23],[36,20,36,23],[37,20,37,23],[41,18,41,19],[46,18,46,19],[48,20,48,23],[49,20,49,23],[38,20,38,23],[39,20,39,23],[40,20,40,23],[41,20,41,23],[42,20,42,23],[43,20,43,23],[44,20,44,23],[45,20,45,23],[38,18,38,19],[39,18,39,19],[40,18,40,19],[20,20,20,23],[21,20,21,23],[22,20,22,23],[23,20,23,23],[24,20,24,23],[25,20,25,23],[26,20,26,23],[27,20,27,23],[28,20,28,23],[44,11,44,12],[39,13,39,17],[45,11,45,12],[48,13,48,17],[47,20,47,23],[49,13,49,17],[20,18,20,19],[21,18,21,19],[22,18,22,19],[23,18,23,19],[24,18,24,19],[25,18,25,19],[26,18,26,19],[27,18,27,19],[28,18,28,19],[29,18,29,19],[30,18,30,19],[31,18,31,19],[32,18,32,19],[33,18,33,19],[34,18,34,19],[35,18,35,19],[36,18,36,19],[37,18,37,19],[35,13,35,17],[36,13,36,17],[37,13,37,17],[38,13,38,17],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,13,40,17],[41,13,41,17],[40,11,40,12],[41,11,41,12],[26,13,26,17],[27,13,27,17],[28,13,28,17],[29,13,29,17],[30,13,30,17],[31,13,31,17],[32,13,32,17],[33,13,33,17],[34,13,34,17],[46,0,47,4],[48,0,49,4],[42,0,43,4],[44,0,45,4],[42,18,42,19],[43,18,43,19],[44,18,44,19],[45,18,45,19],[42,5,43,10],[44,5,45,10],[46,5,47,10],[48,5,49,10],[48,11,48,12],[49,11,49,12],[45,13,45,17],[46,13,46,17],[47,13,47,17],[46,11,46,12],[47,11,47,12],[42,13,42,17],[43,13,43,17],[44,13,44,17],[42,11,42,12],[43,11,43,12],[24,0,25,4],[38,0,39,4],[40,0,41,4],[34,0,35,4],[36,0,37,4],[36,5,37,10],[40,5,41,10],[34,5,35,10],[32,29,32,30],[33,29,33,38],[30,5,31,10],[32,5,33,10],[30,24,31,28],[32,24,33,28],[38,5,39,10],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[30,0,31,4],[32,0,33,4],[31,29,31,38],[20,5,21,10],[22,5,23,10],[24,5,25,10],[26,5,27,10],[28,5,29,10],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[20,13,20,17],[21,13,21,17],[22,13,22,17],[23,13,23,17],[24,13,24,17],[25,13,25,17],[20,0,21,4],[22,0,23,4],[11,18,11,23],[14,18,14,23],[12,18,12,23],[13,18,13,23],[11,2,11,17],[6,18,6,23],[10,18,10,23],[12,2,12,17],[13,2,13,17],[14,2,14,17],[31,73,31,78],[21,39,21,40],[23,39,23,40],[32,73,32,78],[33,73,33,78],[34,73,34,78],[35,73,35,78],[3,0,3,3],[3,4,3,17],[20,24,21,28],[22,24,23,28],[26,0,27,4],[28,0,29,4],[10,2,10,17],[9,18,9,23],[9,2,9,17],[11,0,11,1],[6,0,6,1],[9,0,9,1],[15,0,15,17],[15,18,15,23],[14,0,14,1],[12,0,12,1],[13,0,13,1],[22,73,22,78],[23,73,23,78],[24,73,24,78],[25,73,25,78],[26,73,26,78],[27,73,27,78],[28,73,28,78],[29,73,29,78],[30,73,30,78],[0,40,3,53],[9,40,14,53],[0,22,1,35],[2,22,2,35],[3,22,3,35],[4,0,5,35],[6,24,15,35],[20,73,20,78],[21,73,21,78],[10,0,10,1],[6,2,6,17],[8,0,8,1],[0,0,0,3],[0,4,0,17],[0,18,1,21],[1,0,1,3],[1,4,1,17],[2,0,2,3],[2,4,2,17],[2,18,2,21],[3,18,3,21],[8,18,8,23],[7,0,7,23],[8,2,8,17],[21,42,21,46],[23,42,23,46],[25,39,25,40],[25,42,25,46],[27,39,27,40],[27,42,27,46],[29,39,29,40],[29,42,29,46],[50,24,50,28],[40,24,41,28],[32,31,32,32],[32,34,32,36],[32,37,32,38],[24,24,25,28],[26,24,27,28],[28,24,29,28],[42,24,43,28],[44,24,45,28],[46,24,47,28],[48,24,49,28],[34,24,35,28],[36,24,37,28],[38,24,39,28],[28,37,28,38],[31,39,31,40],[31,42,31,46],[33,39,33,40],[33,42,33,46],[35,39,35,40],[35,42,35,46],[37,39,37,40],[37,42,37,46],[39,39,39,40],[39,42,39,46],[41,39,41,40],[41,42,41,46],[43,39,43,40],[43,42,43,46],[45,39,45,40],[45,42,45,46],[47,39,47,40],[47,42,47,46],[49,39,49,40],[49,42,49,46]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updates Automatically from Payment Claim Sheet"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["D.1) Travel & Living Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National Joint Directive - Meal & Incidental Rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Update this as new National Joint Council rates are issued"]
[0,null,"Original Budget Allocation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74950,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VSY to enter value. If blank, please contact your Subcontracting Authority",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As of 1-Oct-16"]
["Approved Additional Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Breakfast",null,null,null,null,null,null,null,null,null,17.149999999999999]
["Item",null,"Reference #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value ($)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lunch",null,null,null,null,null,null,null,null,null,18.05]
[1,null,"Ref.-No. XYZ456 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Update this part every month - attach supporting approval documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dinner",null,null,null,null,null,null,null,null,null,45.95]
[2,null,"Ref.-No. XYZ456 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incidentals",null,null,null,null,null,null,null,null,null,17.3]
[3,null,"Ref.-No. XYZ456 "]
[4,null,"Ref.-No. XYZ456 "]
[5,null,"Ref.-No. XYZ456 "]
[6,null,"Ref.-No. XYZ456 "]
["Total:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S7:X15)","v":74950}]
["D.2) Travel & Living Expense (Current Month)"]
[]
["Travel Request #",null,null,null,null,"Name, Individual",null,null,null,null,null,"Trip Details",null,null,null,null,null,null,null,null,null,null,null,null,"AIRFARE",null,null,null,null,"HOTEL",null,null,null,null,null,null,null,null,null,"MEALS + INCIDENTALS",null,null,null,null,null,null,null,"TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER",null,null,null,"Description",null,null,null,null,null,"TOTAL CLAIMABLE#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal*",null,null,null,null,null,null,null,null,"Taxi*",null,null,null,"Car Rental"]
["e.g. JSS-FD-063",null,null,null,null,"Bruce Wayne",null,null,null,null,null,"From:",null,"Ontario",null,null,null,null,"To:",null,"British Columbia",null,null,null,894,null,null,null,null,{"$f":"IFERROR(U22-N22, 0)","v":11},null,"nights",null,"@",{"$f":"IFERROR(AD22/AD21, 0)","v":98.63636363636364},null,null,"/ night",null,10,": B",11,": L",20,":D",10,":I",100,null,null,"km @",null,55.5,null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI22/(AD21+1), 0)","v":59},null,null,"/ day",null,0,null,null,null,"e.g. Fuel",null,null,null,null,null,{"$f":"BR22+BA22+BE21+AQ22+Y21+AD22+BI22+BR21","v":4128.543615676359},null,null,null,null,null,null,null,null,null,"Update this part every month."]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"2017-06-12",null,null,null,null,"End:",null,"2017-06-23",null,null,null,null,null,null,null,null,1085,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,0.05,{"$f":"IFERROR(IF(AD21>30,(((AN21*CC8)+(AP21*CC9)+(AR21*CC10)+(AT21*CC11))/(1+AP22))*0.75,((AN21*CC8)+(AP21*CC9)+(AR21*CC10)+(AT21*CC11))/(1+AP22)),0)","v":1392.4285714285713},null,null,null,null,"Tax Rate:",null,null,0.13,null,{"$f":"IFERROR((AV21*(BA21/100))/(1+AY22), 0)","v":49.115044247787623},null,null,null,null,null,null,null,708,null,null,null,null,null,null,null,null,0,null,null,null,"e.g.. Parking"]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U24-N24, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD24/AD23, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI24/(AD23+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR24+BA24+BE23+AQ24+Y23+AD24+BI24+BR23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD23>30,(((AN23*CC10)+(AP23*CC11)+(AR23*CC12)+(AT23*CC13))/(1+#REF!))*0.75,((AN23*CC10)+(AP23*CC11)+(AR23*CC12)+(AT23*CC13))/(1+AP24)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV23*(BA23/100))/(1+AY24), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U26-N26, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD26/AD25, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI26/(AD25+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR26+BA26+BE25+AQ26+Y25+AD26+BI26+BR25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD25>30,(((AN25*CC12)+(AP25*CC13)+(AR25*CC14)+(AT25*CC15))/(1+#REF!))*0.75,((AN25*CC12)+(AP25*CC13)+(AR25*CC14)+(AT25*CC15))/(1+AP26)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV25*(BA25/100))/(1+AY26), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U28-N28, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD28/AD27, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI28/(AD27+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR28+BA28+BE27+AQ28+Y27+AD28+BI28+BR27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD27>30,(((AN27*CC14)+(AP27*CC15)+(AR27*CC16)+(AT27*CC17))/(1+#REF!))*0.75,((AN27*CC14)+(AP27*CC15)+(AR27*CC16)+(AT27*CC17))/(1+AP28)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV27*(BA27/100))/(1+AY28), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U30-N30, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD30/AD29, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI30/(AD29+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR30+BA30+BE29+AQ30+Y29+AD30+BI30+BR29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD29>30,(((AN29*CC16)+(AP29*CC17)+(AR29*CC18)+(AT29*CC19))/(1+#REF!))*0.75,((AN29*CC16)+(AP29*CC17)+(AR29*CC18)+(AT29*CC19))/(1+AP30)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV29*(BA29/100))/(1+AY30), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U32-N32, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD32/AD31, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI32/(AD31+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR32+BA32+BE31+AQ32+Y31+AD32+BI32+BR31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD31>30,(((AN31*CC18)+(AP31*CC19)+(AR31*CC20)+(AT31*CC21))/(1+#REF!))*0.75,((AN31*CC18)+(AP31*CC19)+(AR31*CC20)+(AT31*CC21))/(1+AP32)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV31*(BA31/100))/(1+AY32), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U34-N34, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD34/AD33, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI34/(AD33+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR34+BA34+BE33+AQ34+Y33+AD34+BI34+BR33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD33>30,(((AN33*CC20)+(AP33*CC21)+(AR33*CC22)+(AT33*CC23))/(1+#REF!))*0.75,((AN33*CC20)+(AP33*CC21)+(AR33*CC22)+(AT33*CC23))/(1+AP34)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV33*(BA33/100))/(1+AY34), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U36-N36, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD36/AD35, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI36/(AD35+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR36+BA36+BE35+AQ36+Y35+AD36+BI36+BR35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD35>30,(((AN35*CC22)+(AP35*CC23)+(AR35*CC24)+(AT35*CC25))/(1+#REF!))*0.75,((AN35*CC22)+(AP35*CC23)+(AR35*CC24)+(AT35*CC25))/(1+AP36)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV35*(BA35/100))/(1+AY36), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U38-N38, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD38/AD37, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI38/(AD37+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR38+BA38+BE37+AQ38+Y37+AD38+BI38+BR37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD37>30,(((AN37*CC24)+(AP37*CC25)+(AR37*CC26)+(AT37*CC27))/(1+#REF!))*0.75,((AN37*CC24)+(AP37*CC25)+(AR37*CC26)+(AT37*CC27))/(1+AP38)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV37*(BA37/100))/(1+AY38), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U40-N40, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD40/AD39, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI40/(AD39+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR40+BA40+BE39+AQ40+Y39+AD40+BI40+BR39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD39>30,(((AN39*CC26)+(AP39*CC27)+(AR39*CC28)+(AT39*CC29))/(1+#REF!))*0.75,((AN39*CC26)+(AP39*CC27)+(AR39*CC28)+(AT39*CC29))/(1+AP40)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV39*(BA39/100))/(1+AY40), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U42-N42, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD42/AD41, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI42/(AD41+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR42+BA42+BE41+AQ42+Y41+AD42+BI42+BR41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD41>30,(((AN41*CC28)+(AP41*CC29)+(AR41*CC30)+(AT41*CC31))/(1+#REF!))*0.75,((AN41*CC28)+(AP41*CC29)+(AR41*CC30)+(AT41*CC31))/(1+AP42)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV41*(BA41/100))/(1+AY42), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U44-N44, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD44/AD43, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI44/(AD43+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR44+BA44+BE43+AQ44+Y43+AD44+BI44+BR43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD43>30,(((AN43*CC30)+(AP43*CC31)+(AR43*CC32)+(AT43*CC33))/(1+#REF!))*0.75,((AN43*CC30)+(AP43*CC31)+(AR43*CC32)+(AT43*CC33))/(1+AP44)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV43*(BA43/100))/(1+AY44), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U46-N46, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD46/AD45, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI46/(AD45+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR46+BA46+BE45+AQ46+Y45+AD46+BI46+BR45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD45>30,(((AN45*CC32)+(AP45*CC33)+(AR45*CC34)+(AT45*CC35))/(1+#REF!))*0.75,((AN45*CC32)+(AP45*CC33)+(AR45*CC34)+(AT45*CC35))/(1+AP46)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV45*(BA45/100))/(1+AY46), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U48-N48, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD48/AD47, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI48/(AD47+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR48+BA48+BE47+AQ48+Y47+AD48+BI48+BR47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD47>30,(((AN47*CC34)+(AP47*CC35)+(AR47*CC36)+(AT47*CC37))/(1+#REF!))*0.75,((AN47*CC34)+(AP47*CC35)+(AR47*CC36)+(AT47*CC37))/(1+AP48)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV47*(BA47/100))/(1+AY48), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"From:",null,"[province origin]",null,null,null,null,"To:",null,"[province destination]",null,null,null,0,null,null,null,null,{"$f":"IFERROR(U50-N50, 0)","v":0},null,"nights",null,"@",{"$f":"IFERROR(AD50/AD49, 0)","v":0},null,null,"/ night",null,"#",": B","#",": L","#",":D","#",":I","#",null,null,"km @",null,"#",null,"¢/km,  ",null,0,null,null,null,"mid-size",null,null,null,{"$f":"IFERROR(BI50/(AD49+1), 0)","v":0},null,null,"/ day",null,0,null,null,null,null,null,null,null,null,null,{"$f":"BR50+BA50+BE49+AQ50+Y49+AD50+BI50+BR49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Start:",null,"[DD-Mmm-YY]",null,null,null,null,"End:",null,"[DD-Mmm-YY]",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Tax Rate:",null,"%",{"$f":"IFERROR(IF(AD49>30,(((AN49*CC36)+(AP49*CC37)+(AR49*CC38)+(AT49*CC39))/(1+#REF!))*0.75,((AN49*CC36)+(AP49*CC37)+(AR49*CC38)+(AT49*CC39))/(1+AP50)),0)","v":0},null,null,null,null,"Tax Rate:",null,null,null,null,{"$f":"IFERROR((AV49*(BA49/100))/(1+AY50), 0)","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
["Subtotals:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y21:AC50)","v":894},null,null,null,null,{"$f":"SUM(AD50,AD48,AD46,AD44,AD42,AD40,AD38,AD36,AD34,AD32,AD30,AD28,AD26,AD24,AD22)","v":1085},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN50,AN48,AN46,AN44,AN42,AN40,AN38,AN36,AN34,AN32,AN30,AN28,AN26,AQ24,AQ22)","v":1392.4285714285713},null,null,null,null,null,null,null,{"$f":"SUM(BA50,BA48,BA46,BA44,BA42,BA40,BA38,BA36,BA34,BA32,BA30,BA28,BA26,BA24,BA22)","v":49.115044247787623},null,null,null,null,null,null,null,null,{"$f":"SUM(BE21:BH49)","v":0},null,null,null,{"$f":"SUM(BI50,BI48,BI46,BI44,BI42,BI40,BI38,BI36,BI34,BI32,BI30,BI28,BI24,BI26,BI22)","v":708},null,null,null,null,null,null,null,null,{"$f":"SUM(BR21:BU50)","v":0}]
["Totals:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CB21:CB50)","v":4128.543615676359}]
["ENTER ALL $ AMOUNTS IN CAD, EXCLUDING ANY GST/HST "]
["*Between work/home and airport terminal"]
["#: Total Amount per travel event which is claimable, i.e. less any GST/HST - the cumulative sum of these amounts is the travel amount claimed this SPC."]

{"sheet":"E-Previous Certifications","index":5,"n_rows":35,"n_cols":134,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,69,36,76],[34,105,36,112],[6,13,7,15],[8,13,8,15],[9,13,9,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15],[23,13,23,15],[25,57,25,58],[26,57,26,58],[7,46,7,50],[26,23,26,27],[25,41,25,45],[32,33,32,40],[32,23,32,32],[12,41,12,45],[12,46,12,50],[12,51,12,56],[13,41,13,45],[13,46,13,50],[13,51,13,56],[17,51,17,56],[18,33,18,40],[17,28,17,32],[18,28,18,32],[19,28,19,32],[20,28,20,32],[21,28,21,32],[22,28,22,32],[23,28,23,32],[24,28,24,32],[25,28,25,32],[32,41,32,45],[32,46,32,50],[32,51,32,56],[34,33,36,40],[34,0,34,9],[25,19,25,22],[26,19,26,22],[27,19,27,22],[28,19,28,22],[29,19,29,22],[30,19,30,22],[31,19,31,22],[32,19,32,22],[25,13,25,15],[26,13,26,15],[27,13,27,15],[28,13,28,15],[29,13,29,15],[30,13,30,15],[31,13,31,15],[26,28,26,32],[31,0,31,5],[31,6,31,9],[31,10,31,12],[31,16,31,18],[29,0,29,5],[29,6,29,9],[7,51,7,56],[9,19,9,22],[10,19,10,22],[11,19,11,22],[12,19,12,22],[13,19,13,22],[14,19,14,22],[15,19,15,22],[16,19,16,22],[7,28,7,32],[10,23,10,27],[11,23,11,27],[12,23,12,27],[13,23,13,27],[14,23,14,27],[15,23,15,27],[8,28,8,32],[9,28,9,32],[10,28,10,32],[11,28,11,32],[12,28,12,32],[13,28,13,32],[14,28,14,32],[15,28,15,32],[20,16,20,18],[0,4,0,21],[0,22,1,25],[1,4,1,21],[2,4,2,21],[2,22,2,25],[3,4,3,21],[3,22,3,25],[6,19,7,22],[8,19,8,22],[4,0,5,5],[4,6,5,123],[8,113,8,117],[8,118,8,123],[0,26,1,42],[2,26,2,42],[3,26,3,42],[0,43,3,130],[8,77,8,81],[8,82,8,86],[8,87,8,92],[6,57,7,58],[8,57,8,58],[8,93,8,94],[21,77,21,81],[21,82,21,86],[21,87,21,92],[18,19,18,22],[19,19,19,22],[20,19,20,22],[21,19,21,22],[22,19,22,22],[23,19,23,22],[18,23,18,27],[18,46,18,50],[18,51,18,56],[19,41,19,45],[19,46,19,50],[19,51,19,56],[32,95,32,104],[31,93,31,94],[32,77,32,81],[32,82,32,86],[32,87,32,92],[25,82,25,86],[25,87,25,92],[29,77,29,81],[29,82,29,86],[29,87,29,92],[28,77,28,81],[28,82,28,86],[28,87,28,92],[25,95,25,99],[9,100,9,104],[10,100,10,104],[11,100,11,104],[12,100,12,104],[16,93,16,94],[17,93,17,94],[18,93,18,94],[19,93,19,94],[9,57,9,58],[10,57,10,58],[11,57,11,58],[12,57,12,58],[13,57,13,58],[14,57,14,58],[15,57,15,58],[16,57,16,58],[17,57,17,58],[9,77,9,81],[9,82,9,86],[9,87,9,92],[10,77,10,81],[10,82,10,86],[11,77,11,81],[11,82,11,86],[8,51,8,56],[9,41,9,45],[9,46,9,50],[9,51,9,56],[25,100,25,104],[25,93,25,94],[24,64,24,68],[25,64,25,68],[25,59,25,63],[9,93,9,94],[18,59,18,63],[25,69,25,76],[17,46,17,50],[9,59,9,63],[10,59,10,63],[20,57,20,58],[21,57,21,58],[15,87,15,92],[13,100,13,104],[14,100,14,104],[15,100,15,104],[15,59,15,63],[18,57,18,58],[19,57,19,58],[7,64,7,68],[8,64,8,68],[9,64,9,68],[10,64,10,68],[11,64,11,68],[12,64,12,68],[13,64,13,68],[14,64,14,68],[8,133,31,150],[28,124,28,125],[31,100,31,104],[26,93,26,94],[29,105,29,112],[29,113,29,117],[29,118,29,123],[28,105,28,112],[27,77,27,81],[27,82,27,86],[27,87,27,92],[27,105,27,112],[27,113,27,117],[27,118,27,123],[21,105,21,112],[20,105,20,112],[32,59,32,68],[22,57,22,58],[19,33,19,40],[19,23,19,27],[20,23,20,27],[8,23,8,27],[9,23,9,27],[20,33,20,40],[20,41,20,45],[20,46,20,50],[20,51,20,56],[22,64,22,68],[31,46,31,50],[31,51,31,56],[16,33,16,40],[14,41,14,45],[14,46,14,50],[26,59,26,63],[27,59,27,63],[26,64,26,68],[27,64,27,68],[8,59,8,63],[8,41,8,45],[8,46,8,50],[7,41,7,45],[19,124,19,125],[16,77,16,81],[16,82,16,86],[16,87,16,92],[19,113,19,117],[6,59,6,92],[7,77,7,81],[7,82,7,86],[7,87,7,92],[7,113,7,117],[7,118,7,123],[6,93,7,94],[12,77,12,81],[12,82,12,86],[12,87,12,92],[17,87,17,92],[18,77,18,81],[18,82,18,86],[18,87,18,92],[15,77,15,81],[15,82,15,86],[10,93,10,94],[11,93,11,94],[32,69,32,76],[28,59,28,63],[28,126,28,130],[29,124,29,125],[29,126,29,130],[16,64,16,68],[17,64,17,68],[20,87,20,92],[19,77,19,81],[19,82,19,86],[18,64,18,68],[27,93,27,94],[28,93,28,94],[29,93,29,94],[27,100,27,104],[28,100,28,104],[29,100,29,104],[28,95,28,99],[29,95,29,99],[16,100,16,104],[29,64,29,68],[19,64,19,68],[20,64,20,68],[21,64,21,68],[6,95,6,123],[6,23,6,56],[7,23,7,27],[7,59,7,63],[7,95,7,99],[29,59,29,63],[8,95,8,99],[21,95,21,99],[22,95,22,99],[19,59,19,63],[20,59,20,63],[21,59,21,63],[22,59,22,63],[22,69,22,76],[22,77,22,81],[22,82,22,86],[20,93,20,94],[21,93,21,94],[25,105,25,112],[20,69,20,76],[28,113,28,117],[28,118,28,123],[16,41,16,45],[16,46,16,50],[20,113,20,117],[17,100,17,104],[18,100,18,104],[19,100,19,104],[20,100,20,104],[23,64,23,68],[19,118,19,123],[19,87,19,92],[17,77,17,81],[17,82,17,86],[21,100,21,104],[22,105,22,112],[23,77,23,81],[23,82,23,86],[23,87,23,92],[23,105,23,112],[23,95,23,99],[22,93,22,94],[18,69,18,76],[19,69,19,76],[17,69,17,76],[21,69,21,76],[20,77,20,81],[20,82,20,86],[31,105,31,112],[31,113,31,117],[31,118,31,123],[31,124,31,125],[31,126,31,130],[30,23,30,27],[30,77,30,81],[30,82,30,86],[30,105,30,112],[30,87,30,92],[31,77,31,81],[31,82,31,86],[31,87,31,92],[30,113,30,117],[30,118,30,123],[30,124,30,125],[30,126,30,130],[30,95,30,99],[31,95,31,99],[30,93,30,94],[30,100,30,104],[31,28,31,32],[31,33,31,40],[31,41,31,45],[31,69,31,76],[31,23,31,27],[31,57,31,58],[31,64,31,68],[31,59,31,63],[30,0,30,5],[30,6,30,9],[30,10,30,12],[30,16,30,18],[30,33,30,40],[30,41,30,45],[30,46,30,50],[30,51,30,56],[30,69,30,76],[30,57,30,58],[30,64,30,68],[30,59,30,63],[30,28,30,32],[29,10,29,12],[29,16,29,18],[29,33,29,40],[29,41,29,45],[29,46,29,50],[29,51,29,56],[29,69,29,76],[29,23,29,27],[29,28,29,32],[29,57,29,58],[28,0,28,5],[28,6,28,9],[28,10,28,12],[28,16,28,18],[28,33,28,40],[28,41,28,45],[28,46,28,50],[28,51,28,56],[28,69,28,76],[28,64,28,68],[28,28,28,32],[28,23,28,27],[28,57,28,58],[27,10,27,12],[27,16,27,18],[27,33,27,40],[27,41,27,45],[27,46,27,50],[27,51,27,56],[27,69,27,76],[27,57,27,58],[27,28,27,32],[27,126,27,130],[27,23,27,27],[26,95,26,99],[27,95,27,99],[26,0,26,5],[26,6,26,9],[26,10,26,12],[26,16,26,18],[26,33,26,40],[26,41,26,45],[26,46,26,50],[26,51,26,56],[26,69,26,76],[26,77,26,81],[26,82,26,86],[26,87,26,92],[26,105,26,112],[26,100,26,104],[26,113,26,117],[26,118,26,123],[26,124,26,125],[26,126,26,130],[27,0,27,5],[27,6,27,9],[24,82,24,86],[24,87,24,92],[25,0,25,5],[25,6,25,9],[25,10,25,12],[25,16,25,18],[25,33,25,40],[24,13,24,15],[25,77,25,81],[24,19,24,22],[25,46,25,50],[25,51,25,56],[25,23,25,27],[24,0,24,5],[24,6,24,9],[24,10,24,12],[24,16,24,18],[24,33,24,40],[24,41,24,45],[24,46,24,50],[24,51,24,56],[24,69,24,76],[22,100,22,104],[24,105,24,112],[24,57,24,58],[24,95,24,99],[24,23,24,27],[24,59,24,63],[23,100,23,104],[24,100,24,104],[23,93,23,94],[24,93,24,94],[22,33,22,40],[22,41,22,45],[22,46,22,50],[22,51,22,56],[22,23,22,27],[23,23,23,27],[22,87,22,92],[23,33,23,40],[23,41,23,45],[23,46,23,50],[23,51,23,56],[23,69,23,76],[23,57,23,58],[24,77,24,81],[21,0,21,5],[21,6,21,9],[21,10,21,12],[21,16,21,18],[21,33,21,40],[21,41,21,45],[21,23,21,27],[22,0,22,5],[23,59,23,63],[22,10,22,12],[22,16,22,18],[23,0,23,5],[23,6,23,9],[23,10,23,12],[23,16,23,18],[22,6,22,9],[21,46,21,50],[21,51,21,56],[20,118,20,123],[20,124,20,125],[20,126,20,130],[1,0,1,3],[4,125,5,130],[6,126,7,130],[8,126,8,130],[9,126,9,130],[10,126,10,130],[12,126,12,130],[13,126,13,130],[14,126,14,130],[15,126,15,130],[16,126,16,130],[17,126,17,130],[18,126,18,130],[19,126,19,130],[11,126,11,130],[7,100,7,104],[8,100,8,104],[20,0,20,5],[20,6,20,9],[20,10,20,12],[18,41,18,45],[32,126,32,130],[21,113,21,117],[21,118,21,123],[21,124,21,125],[21,126,21,130],[22,113,22,117],[22,118,22,123],[22,124,22,125],[32,113,32,117],[32,118,32,123],[24,113,24,117],[24,118,24,123],[24,124,24,125],[24,126,24,130],[22,126,22,130],[23,113,23,117],[23,118,23,123],[23,124,23,125],[23,126,23,130],[25,124,25,125],[25,126,25,130],[25,113,25,117],[25,118,25,123],[27,124,27,125],[8,69,8,76],[9,69,9,76],[10,69,10,76],[11,69,11,76],[12,69,12,76],[13,69,13,76],[14,69,14,76],[15,69,15,76],[16,69,16,76],[11,124,11,125],[15,124,15,125],[6,0,7,5],[6,6,7,9],[6,10,7,12],[6,16,7,18],[6,124,7,125],[7,105,7,112],[7,33,7,40],[15,118,15,123],[12,0,12,5],[11,16,11,18],[11,118,11,123],[12,6,12,9],[12,10,12,12],[12,16,12,18],[12,118,12,123],[12,124,12,125],[13,6,13,9],[13,10,13,12],[13,16,13,18],[14,0,14,5],[14,33,14,40],[15,33,15,40],[4,124,5,124],[9,0,9,5],[15,105,15,112],[2,0,2,3],[3,0,3,3],[0,0,0,3],[7,69,7,76],[8,33,8,40],[9,33,9,40],[10,33,10,40],[11,33,11,40],[12,33,12,40],[15,10,15,12],[9,95,9,99],[10,95,10,99],[15,113,15,117],[15,6,15,9],[9,118,9,123],[9,124,9,125],[13,124,13,125],[10,118,10,123],[10,124,10,125],[9,113,9,117],[13,33,13,40],[10,113,10,117],[11,105,11,112],[11,113,11,117],[11,41,11,45],[11,46,11,50],[11,51,11,56],[13,95,13,99],[12,105,12,112],[12,113,12,117],[13,105,13,112],[10,41,10,45],[10,46,10,50],[10,51,10,56],[11,87,11,92],[12,93,12,94],[13,93,13,94],[11,59,11,63],[12,59,12,63],[13,59,13,63],[13,113,13,117],[32,105,32,112],[15,16,15,18],[15,0,15,5],[19,0,19,5],[11,0,11,5],[19,6,19,9],[19,10,19,12],[19,16,19,18],[9,6,9,9],[9,10,9,12],[9,16,9,18],[20,95,20,99],[19,105,19,112],[9,105,9,112],[10,0,10,5],[11,6,11,9],[11,10,11,12],[11,95,11,99],[10,6,10,9],[10,10,10,12],[10,16,10,18],[10,105,10,112],[10,87,10,92],[12,95,12,99],[13,118,13,123],[14,95,14,99],[13,0,13,5],[15,95,15,99],[14,6,14,9],[14,10,14,12],[14,16,14,18],[14,105,14,112],[14,113,14,117],[14,118,14,123],[13,77,13,81],[13,82,13,86],[13,87,13,92],[14,77,14,81],[14,82,14,86],[14,87,14,92],[14,51,14,56],[15,93,15,94],[14,59,14,63],[14,93,14,94],[17,19,17,22],[15,41,15,45],[15,46,15,50],[15,51,15,56],[16,23,16,27],[17,23,17,27],[16,51,16,56],[17,41,17,45],[16,0,16,5],[16,6,16,9],[16,10,16,12],[16,16,16,18],[16,28,16,32],[17,118,17,123],[14,124,14,125],[16,105,16,112],[16,113,16,117],[16,118,16,123],[16,124,16,125],[17,95,17,99],[16,59,16,63],[17,59,17,63],[15,64,15,68],[16,95,16,99],[8,124,8,125],[19,95,19,99],[18,0,18,5],[8,0,8,5],[8,6,8,9],[8,10,8,12],[8,16,8,18],[8,105,8,112],[17,124,17,125],[17,33,17,40],[18,6,18,9],[18,10,18,12],[18,16,18,18],[18,105,18,112],[18,113,18,117],[18,118,18,123],[18,124,18,125],[18,95,18,99],[17,0,17,5],[17,6,17,9],[17,10,17,12],[17,16,17,18],[17,105,17,112],[17,113,17,117]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Amounts in $CAD"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["E) Previous Certifications"]
[]
["Payment Claim Ref No.",null,null,null,null,null,"Purchase Order #",null,null,null,"Payment Currency ",null,null,"F/X Rate",null,null,"Invoice Currency",null,null,"Labour Hours",null,null,null,"Labour - Previously Certified ($CAD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment Received (Y/N)",null,"Goods - Previously Certified ($CAD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment Received (Y/N)",null,"Travel & Living - Previously Certified ($CAD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment Received (Y/N)",null,"Total Invoiced\n($CAD)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice #",null,null,null,null,"Invoice Date",null,null,null,null,"Labour",null,null,null,null,null,null,null,"Holdback",null,null,null,null,"G.S.T.",null,null,null,null,"Invoice Total",null,null,null,null,null,null,null,"Invoice #",null,null,null,null,"Invoice Date",null,null,null,null,"Goods",null,null,null,null,null,null,null,"Holdback",null,null,null,null,"G.S.T.",null,null,null,null,"Invoice Total",null,null,null,null,null,null,null,"Invoice #",null,null,null,null,"Invoice Date",null,null,null,null,"Travel & Living",null,null,null,null,null,null,null,"G.S.T.",null,null,null,null,"Invoice Total"]
["[Enter Previous Claim Ref No.]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH9*'Payment Claim'!$E$16)","v":0},null,null,null,null,{"$f":"AH9*0.05","v":0},null,null,null,null,{"$f":"SUM(AH9:AY9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR9*'Payment Claim'!$E$16)","v":0},null,null,null,null,{"$f":"BR9*0.05","v":0},null,null,null,null,{"$f":"SUM(BR9:CI9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DB9*0.05","v":0},null,null,null,null,{"$f":"SUM(DB9:DN9)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(DO9,CJ9,AZ9)","v":0},null,null,null,null,null,null,"Update this part every month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH10*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(AH10:AY10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR10*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(BR10:CI10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH11*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR11*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH12*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR12*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH13*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR13*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH14*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR14*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH15*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR15*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH16*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR16*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH17*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR17*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH18*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR18*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH19*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR19*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH20*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR20*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH21*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(AH21:AY21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR21*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(BR21:CI21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH22*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(AH22:AY22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR22*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,{"$f":"SUM(BR22:CI22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"SUM(DB22:DN22)","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH23*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR23*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH24*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR24*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH25*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR25*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH26*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR26*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH27*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR27*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH28*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR28*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH29*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR29*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH30*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR30*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH31*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR31*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH$8=\"Goods\", 0, AH32*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BR$8=\"Goods\", 0, BR32*'Payment Claim'!$E$16)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T9:W32)","v":0},null,null,null,"Sub-totals:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH9:AO32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AP9:AT32)","v":0},null,null,null,null,{"$f":"SUM(AU9:AY32)","v":0},null,null,null,null,{"$f":"SUM(AZ9:BE32)","v":0},null,null,null,null,null,null,null,"Sub-totals:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(BR9:BY32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(BZ9:CD32)","v":0},null,null,null,null,{"$f":"SUM(CE9:CI32)","v":0},null,null,null,null,{"$f":"SUM(CJ9:CO32)","v":0},null,null,null,null,null,null,null,"Sub-totals:",null,null,null,null,null,null,null,null,null,{"$f":"SUM(DB9:DI32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(DJ9:DN32)","v":0},null,null,null,null,{"$f":"SUM(DO9:DT32)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(DW9:EA32)","v":0}]
[]
[{"$f":"IF(VLOOKUP(AA4,A9:EA32, 132)<>0, \"ERROR! - Uncertified payment claim entered\", \"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH33<>('A-Work Complete'!AL40), \"ERROR! Should = previous months value of unit rate (work complete tab)\", \"\")","v":"ERROR! Should = previous months value of unit rate (work complete tab)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR33<>'A-Work Complete'!Z60, \"ERROR! Should = previous months value of goods (work complete tab)\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DB33<>'D-Travel & Living'!#REF!, \"ERROR! Should = previous months value of Travel & Living  tab\", \"\")","v":{"$error":"#REF!"}}]

{"sheet":"Payment Certificate","index":6,"n_rows":57,"n_cols":42,"rows_kept":57,"cut":false,"hidden":false,"merged":[[8,37,10,39],[5,0,5,3],[5,4,5,17],[5,18,6,21],[5,22,6,35],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[7,18,7,21],[7,22,7,35],[8,0,8,3],[8,4,8,17],[8,18,8,21],[8,22,8,35],[9,0,10,35],[11,0,12,3],[11,4,12,17],[11,18,11,25],[11,26,11,35],[27,29,27,35],[25,18,25,22],[25,23,25,28],[25,29,25,35],[31,29,31,35],[18,23,19,28],[18,29,19,35],[18,0,19,22],[20,23,20,28],[20,29,20,35],[21,18,21,22],[21,23,21,28],[21,29,21,35],[23,23,23,28],[23,29,23,35],[53,10,53,19],[53,23,53,35],[56,10,56,19],[56,23,56,35],[41,18,41,22],[41,23,41,28],[41,29,41,35],[43,18,43,22],[45,0,45,35],[5,41,43,60],[43,29,43,35],[33,18,33,22],[33,23,33,28],[33,29,33,35],[30,18,30,22],[38,18,38,22],[38,23,38,28],[38,29,38,35],[39,18,39,22],[39,23,39,28],[39,29,39,35],[23,18,23,22],[31,18,31,22],[36,18,36,22],[20,18,20,22],[35,23,35,28],[35,29,35,35],[30,23,30,28],[30,29,30,35],[24,18,24,22],[24,23,24,28],[24,29,24,35],[26,18,26,22],[3,30,3,35],[33,3,33,8],[39,3,39,8],[3,25,3,29],[17,0,17,3],[17,4,17,17],[17,18,17,21],[17,22,17,35],[15,4,15,17],[15,18,15,21],[15,22,15,35],[16,4,16,17],[16,18,16,21],[16,22,16,35],[12,18,12,25],[12,26,12,35],[13,18,13,35],[14,4,14,17],[14,18,14,21],[14,22,14,35],[20,0,26,8],[29,0,32,8],[35,0,38,8],[27,3,27,8],[36,23,36,28],[36,29,36,35],[37,18,37,22],[37,23,37,28],[37,29,37,35],[26,23,26,28],[26,29,26,35],[29,18,29,22],[29,23,29,28],[29,29,29,35],[32,18,32,22],[35,18,35,22],[31,23,31,28],[32,23,32,28],[32,29,32,35],[27,18,27,22],[27,23,27,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLIER PAYMENT CLAIM (SPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAYMENT CERTIFICATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order #",null,null,null,null,"[Insert PO# Here]"]
[]
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing to fill here, everything updates automatically\n\nVSY to enter PO# and  Invoice #s prior to certification"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((VLOOKUP(W9, 'E-Previous Certifications'!A9:DW32, 132))=0, \"\", \"ERROR! \nPrevious Certifications tab\")","v":{"$error":"#N/A"}}]
["1. Contract Details"]
[]
["Subcontract Title",null,null,null,{"$f":"'Payment Claim'!E10","v":"[Contract Title]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Unit Basis Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA10","v":17869385.260000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Milestone Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA11","v":0}]
["Subcontract No.",null,null,null,{"$f":"'Payment Claim'!E12","v":"[Contract #]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Value ($)"]
["Subcontract Start",null,null,null,{"$f":"'Payment Claim'!E13","v":"2016-12-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Work Value",null,null,null,{"$f":"'Payment Claim'!W13","v":17869385.260000002}]
["Subcontract End",null,null,null,{"$f":"'Payment Claim'!E14","v":"2017-12-22"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation(s) Value",null,null,null,{"$f":"'Payment Claim'!W14","v":0}]
["Currency",null,null,null,{"$f":"'Payment Claim'!E15","v":"CAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,{"$f":"'Payment Claim'!W15","v":74950}]
["Holdback (%)",null,null,null,{"$f":"'Payment Claim'!E16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"'Payment Claim'!W16","v":17944335.260000002}]
["2. Amount Invoiced This Claim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previously Invoiced",null,null,null,null,null,"Total Invoiced to Date"]
[]
["Labour",null,null,null,null,null,null,null,null,"Regular Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!T40","v":5000},null,null,null,null,{"$f":"'A-Work Complete'!AL40","v":7500},null,null,null,null,null,{"$f":"'A-Work Complete'!BE40","v":12500}]
[null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!Z40","v":8000},null,null,null,null,{"$f":"'A-Work Complete'!AR40","v":8000},null,null,null,null,null,{"$f":"'A-Work Complete'!BK40","v":16000}]
[]
[null,null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N20","v":13000},null,null,null,null,{"$f":"'Payment Claim'!U20","v":15500},null,null,null,null,null,{"$f":"'Payment Claim'!Z20","v":28500}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S24*-E18","v":0},null,null,null,null,{"$f":"'Payment Claim'!U26","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z26","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,{"$f":"'C-Backcharges'!S23:X23","v":0},null,null,null,null,{"$f":"'C-Backcharges'!Y23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z27","v":0}]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W26)*0.05","v":650},null,null,null,null,{"$f":"SUM(X24:AC25)*0.05","v":775},null,null,null,null,null,{"$f":"SUM(AD24:AJ25)*0.05","v":1425}]
["Invoice #",null,null,"[Enter Invoice #]",null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W27)","v":13650},null,null,null,null,{"$f":"SUM(X24:AC27)","v":16275},null,null,null,null,null,{"$f":"SUM(AD24:AJ27)","v":29925}]
[]
["Goods",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N21+'Payment Claim'!N23","v":0},null,null,null,null,{"$f":"'Payment Claim'!U21+'Payment Claim'!U23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z21+'Payment Claim'!Z23","v":0}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S30*-E18","v":0},null,null,null,null,{"$f":"X30*-E18","v":0},null,null,null,null,null,{"$f":"AD30*-E18","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W31)*0.05","v":0},null,null,null,null,{"$f":"SUM(X30:AC31)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ31)*0.05","v":0}]
["Invoice #",null,null,"[Enter Invoice #]",null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W33)","v":0},null,null,null,null,{"$f":"SUM(X30:AC33)","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ33)","v":0}]
[]
["Travel & Living",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N29","v":4128.543615676359},null,null,null,null,{"$f":"'Payment Claim'!U29","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z29","v":4128.543615676359}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"S36*0.05","v":206.42718078381796},null,null,null,null,{"$f":"SUM(X36:AC36)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ36)*0.05","v":206.42718078381796}]
["Invoice #",null,null,"[Enter Invoice #]",null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S36:W39)","v":4334.9707964601766},null,null,null,null,{"$f":"SUM(X36:AC39)","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ39)","v":4334.9707964601766}]
[]
[null,null,null,"Net Amount Certified This Claim (excl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S22:W26,S36:W36)","v":25128.543615676361},null,null,null,null,{"$f":"SUM(X22:AC26,X30:AC32,X36:AC38)","v":23500},null,null,null,null,null,{"$f":"SUM(AD22:AJ26,AD30:AJ32,AD36:AJ38)","v":48628.543615676361}]
[]
[null,null,null,"Total Amount Certified This Claim (incl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S40,S28,S34)","v":17984.970796460177}]
[]
[{"$f":"spellnumber(S44)","v":"Seventeen Thousand Nine Hundred Eighty Four Dollars and Ninety Seven Cents"}]
[]
["Certificate of Payment"]
["I certify that To the best of my knowledge, the claim is consistent with the progress of the work and is in accordance with the contract. This claim, however, "]
["may be subject to further verification and any necessary adjustment before final settlement."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority - Project Lead"]

{"sheet":"Rates Schedule","index":7,"n_rows":52,"n_cols":42,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,22,50,35],[50,0,50,3],[50,4,50,7],[50,8,50,12],[50,13,50,18],[50,19,50,21],[49,0,49,3],[49,4,49,7],[49,8,49,12],[49,13,49,18],[49,19,49,21],[48,0,48,3],[48,4,48,7],[48,8,48,12],[48,13,48,18],[48,19,48,21],[47,0,47,3],[47,4,47,7],[47,8,47,12],[47,13,47,18],[47,19,47,21],[46,0,46,3],[46,4,46,7],[46,8,46,12],[46,13,46,18],[46,19,46,21],[45,0,45,3],[45,4,45,7],[45,8,45,12],[45,13,45,18],[45,19,45,21],[44,0,44,3],[44,4,44,7],[44,8,44,12],[44,13,44,18],[44,19,44,21],[43,0,43,3],[43,4,43,7],[43,8,43,12],[43,13,43,18],[43,19,43,21],[42,0,42,3],[42,4,42,7],[42,8,42,12],[42,13,42,18],[42,19,42,21],[41,0,41,3],[41,4,41,7],[41,8,41,12],[41,13,41,18],[41,19,41,21],[40,0,40,3],[40,4,40,7],[40,8,40,12],[40,13,40,18],[40,19,40,21],[39,0,39,3],[39,4,39,7],[39,8,39,12],[39,13,39,18],[39,19,39,21],[38,0,38,3],[38,4,38,7],[38,8,38,12],[38,13,38,18],[38,19,38,21],[37,0,37,3],[37,4,37,7],[37,8,37,12],[37,13,37,18],[37,19,37,21],[36,0,36,3],[36,4,36,7],[36,8,36,12],[36,13,36,18],[36,19,36,21],[35,0,35,3],[35,4,35,7],[35,8,35,12],[35,13,35,18],[35,19,35,21],[34,0,34,3],[34,4,34,7],[34,8,34,12],[34,13,34,18],[34,19,34,21],[33,0,33,3],[33,4,33,7],[33,8,33,12],[33,13,33,18],[33,19,33,21],[32,0,32,3],[32,4,32,7],[32,8,32,12],[32,13,32,18],[32,19,32,21],[31,0,31,3],[31,4,31,7],[31,8,31,12],[31,13,31,18],[31,19,31,21],[30,0,30,3],[30,4,30,7],[30,8,30,12],[30,13,30,18],[30,19,30,21],[29,0,29,3],[29,4,29,7],[29,8,29,12],[29,13,29,18],[29,19,29,21],[28,0,28,3],[28,4,28,7],[28,8,28,12],[28,13,28,18],[28,19,28,21],[27,0,27,3],[27,4,27,7],[27,8,27,12],[27,13,27,18],[27,19,27,21],[26,0,26,3],[26,4,26,7],[26,8,26,12],[26,13,26,18],[26,19,26,21],[25,0,25,3],[25,4,25,7],[25,8,25,12],[25,13,25,18],[25,19,25,21],[24,0,24,3],[24,4,24,7],[24,8,24,12],[24,13,24,18],[24,19,24,21],[23,0,23,3],[23,4,23,7],[23,8,23,12],[23,13,23,18],[23,19,23,21],[2,4,2,17],[2,18,2,21],[2,22,2,35],[3,0,3,3],[3,4,3,17],[3,18,3,21],[3,22,3,35],[20,0,20,3],[20,4,20,7],[20,8,20,12],[20,13,20,18],[20,19,20,21],[19,0,19,3],[19,4,19,7],[19,8,19,12],[19,13,19,18],[19,19,19,21],[10,0,10,3],[11,0,11,3],[12,0,12,3],[6,4,6,7],[7,4,7,7],[8,4,8,7],[9,4,9,7],[10,4,10,7],[11,4,11,7],[12,4,12,7],[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[18,4,18,7],[51,0,51,35],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7],[17,4,17,7],[16,8,16,12],[17,8,17,12],[18,8,18,12],[13,8,13,12],[14,8,14,12],[22,0,22,3],[22,4,22,7],[22,8,22,12],[22,13,22,18],[22,19,22,21],[21,0,21,3],[15,8,15,12],[18,19,18,21],[21,4,21,7],[21,8,21,12],[21,13,21,18],[21,19,21,21],[6,22,6,35],[10,8,10,12],[11,8,11,12],[12,8,12,12],[6,8,6,12],[6,13,6,18],[9,8,9,12],[8,19,8,21],[7,13,7,18],[8,13,8,18],[7,8,7,12],[8,8,8,12],[11,19,11,21],[12,19,12,21],[9,13,9,18],[10,13,10,18],[11,13,11,18],[12,13,12,18],[0,41,50,57],[14,13,14,18],[15,13,15,18],[16,13,16,18],[17,13,17,18],[18,13,18,18],[13,19,13,21],[14,19,14,21],[15,19,15,21],[16,19,16,21],[17,19,17,21],[13,13,13,18],[6,19,6,21],[7,19,7,21],[9,19,9,21],[10,19,10,21],[4,0,5,35],[0,0,0,3],[0,4,0,17],[0,18,1,21],[0,22,1,35],[1,0,1,3],[1,4,1,17],[2,0,2,3]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As per the subcontract. If a revision is necessary, please contact the subcontract authority."]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["Labour Rate Table"]
[]
["Labour Rate Type",null,null,null,"Hour Type",null,null,null,"Period From",null,null,null,null,"Period To",null,null,null,null,null,"Regular \nBilling Rate"]
["CAT. 1 2016",null,null,null,"REG",null,null,null,"2016-01-01",null,null,null,null,"2016-12-31",null,null,null,null,null,100]
["CAT. 2 2016",null,null,null,"REG",null,null,null,"2016-01-02",null,null,null,null,"2017-01-01"]
["CAT. 3 2016",null,null,null,"REG",null,null,null,"2016-01-03",null,null,null,null,"2017-01-02"]
["CAT. 4 2016",null,null,null,"REG",null,null,null,"2016-01-04",null,null,null,null,"2017-01-03"]
["CAT. 5 2016",null,null,null,"REG",null,null,null,"2016-01-05",null,null,null,null,"2017-01-04"]
["CAT. 6 2016",null,null,null,"REG",null,null,null,"2016-01-06",null,null,null,null,"2017-01-05"]
["CAT. 1 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
["CAT. 2 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
["CAT. 3 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
["CAT. 4 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
["CAT. 5 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
["CAT. 6 2017",null,null,null,"REG",null,null,null,"2017-01-01",null,null,null,null,"2017-12-31"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"All amounts in \"&'Payment Claim'!E15&\".\"","v":"All amounts in CAD."}]

{"sheet":"Certificate - Labour","index":8,"n_rows":57,"n_cols":42,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,25,3,29],[3,30,3,35],[5,0,5,3],[5,4,5,17],[5,18,6,21],[5,22,6,35],[5,41,43,60],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[7,18,7,21],[7,22,7,35],[8,0,8,3],[8,4,8,17],[8,18,8,21],[8,22,8,35],[8,37,10,39],[9,0,10,35],[11,0,12,3],[11,4,12,17],[11,18,11,25],[11,26,11,35],[12,18,12,25],[12,26,12,35],[16,4,16,17],[16,18,16,21],[16,22,16,35],[17,0,17,3],[17,4,17,17],[17,18,17,21],[17,22,17,35],[13,18,13,35],[14,4,14,17],[14,18,14,21],[14,22,14,35],[15,4,15,17],[15,18,15,21],[15,22,15,35],[18,0,19,22],[18,23,19,28],[18,29,19,35],[23,18,23,22],[23,23,23,28],[23,29,23,35],[24,18,24,22],[24,23,24,28],[24,29,24,35],[33,29,33,35],[27,3,27,8],[27,18,27,22],[27,23,27,28],[27,29,27,35],[25,18,25,22],[25,23,25,28],[25,29,25,35],[26,18,26,22],[26,23,26,28],[26,29,26,35],[20,0,26,8],[20,18,20,22],[20,23,20,28],[20,29,20,35],[21,18,21,22],[21,23,21,28],[21,29,21,35],[29,29,29,35],[29,23,29,28],[29,18,29,22],[29,0,32,8],[31,18,31,22],[43,18,43,22],[43,29,43,35],[45,0,45,35],[53,10,53,19],[53,23,53,35],[56,10,56,19],[56,23,56,35],[39,3,39,8],[39,18,39,22],[39,23,39,28],[39,29,39,35],[41,18,41,22],[41,23,41,28],[41,29,41,35],[31,23,31,28],[31,29,31,35],[30,23,30,28],[30,18,30,22],[36,18,36,22],[35,0,38,8],[35,18,35,22],[35,23,35,28],[35,29,35,35],[38,18,38,22],[38,23,38,28],[38,29,38,35],[36,23,36,28],[36,29,36,35],[37,18,37,22],[30,29,30,35],[32,18,32,22],[32,23,32,28],[32,29,32,35],[37,23,37,28],[37,29,37,35],[33,3,33,8],[33,18,33,22],[33,23,33,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLIER PAYMENT CLAIM (SPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour Certificate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period of performance "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order #",null,null,null,null,{"$f":"'Payment Certificate'!AE4:AJ4","v":"[Insert PO# Here]"},null,null,null,null,null,null,"review cut off - month end in SubC. "]
[]
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing to fill here, everything updates automatically"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((VLOOKUP(W9, 'E-Previous Certifications'!A9:DW32, 132))=0, \"\", \"ERROR! \nPrevious Certifications tab\")","v":{"$error":"#N/A"}}]
["1. Contract Details"]
[]
["Subcontract Title",null,null,null,{"$f":"'Payment Claim'!E10","v":"[Contract Title]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Unit Basis Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA10","v":17869385.260000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Milestone Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA11","v":0}]
["Subcontract No.",null,null,null,{"$f":"'Payment Claim'!E12","v":"[Contract #]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Value ($)"]
["Subcontract Start",null,null,null,{"$f":"'Payment Claim'!E13","v":"2016-12-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Work Value",null,null,null,{"$f":"'Payment Claim'!W13","v":17869385.260000002}]
["Subcontract End",null,null,null,{"$f":"'Payment Claim'!E14","v":"2017-12-22"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation(s) Value",null,null,null,{"$f":"'Payment Claim'!W14","v":0}]
["Currency",null,null,null,{"$f":"'Payment Claim'!E15","v":"CAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,{"$f":"'Payment Claim'!W15","v":74950}]
["Holdback (%)",null,null,null,{"$f":"'Payment Claim'!E16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"'Payment Claim'!W16","v":17944335.260000002}]
["2. Amount Invoiced This Claim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previously Invoiced",null,null,null,null,null,"Total Invoiced to Date"]
[]
["Labour",null,null,null,null,null,null,null,null,"Regular Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!T40","v":5000},null,null,null,null,{"$f":"'A-Work Complete'!AL40","v":7500},null,null,null,null,null,{"$f":"'A-Work Complete'!BE40","v":12500}]
[null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!Z40","v":8000},null,null,null,null,{"$f":"'A-Work Complete'!AR40","v":8000},null,null,null,null,null,{"$f":"'A-Work Complete'!BK40","v":16000}]
[]
[null,null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N20","v":13000},null,null,null,null,{"$f":"'Payment Claim'!U20","v":15500},null,null,null,null,null,{"$f":"'Payment Claim'!Z20","v":28500}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S24*-E18","v":0},null,null,null,null,{"$f":"'Payment Claim'!U26","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z26","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,{"$f":"'C-Backcharges'!S23:X23","v":0},null,null,null,null,{"$f":"'C-Backcharges'!Y23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z27","v":0}]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W26)*0.05","v":650},null,null,null,null,{"$f":"SUM(X24:AC25)*0.05","v":775},null,null,null,null,null,{"$f":"SUM(AD24:AJ25)*0.05","v":1425}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D28:I28","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W27)","v":13650},null,null,null,null,{"$f":"SUM(X24:AC27)","v":16275},null,null,null,null,null,{"$f":"SUM(AD24:AJ27)","v":29925}]
[]
["Goods",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N21+'Payment Claim'!N23","v":0},null,null,null,null,{"$f":"'Payment Claim'!U21+'Payment Claim'!U23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z21+'Payment Claim'!Z23","v":0}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S30*-E18","v":0},null,null,null,null,{"$f":"X30*-E18","v":0},null,null,null,null,null,{"$f":"AD30*-E18","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W31)*0.05","v":0},null,null,null,null,{"$f":"SUM(X30:AC31)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ31)*0.05","v":0}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D34:I34","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W33)","v":0},null,null,null,null,{"$f":"SUM(X30:AC33)","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ33)","v":0}]
[]
["Travel & Living",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N29","v":4128.543615676359},null,null,null,null,{"$f":"'Payment Claim'!U29","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z29","v":4128.543615676359}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"S36*0.05","v":206.42718078381796},null,null,null,null,{"$f":"SUM(X36:AC36)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ36)*0.05","v":206.42718078381796}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D40:I40","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S36:W39)","v":4334.9707964601766},null,null,null,null,{"$f":"SUM(X36:AC39)","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ39)","v":4334.9707964601766}]
[]
[null,null,null,"Net Amount Certified This Claim (excl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W26)","v":13000},null,null,null,null,{"$f":"SUM(X24:AC26)","v":15500},null,null,null,null,null,{"$f":"SUM(AD24:AJ26)","v":28500}]
[]
[null,null,null,"Total Amount Certified This Claim (incl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S28)","v":13650}]
[]
[{"$f":"spellnumber(S44)","v":"Thirteen Thousand Six Hundred Fifty  Dollars and No Cents"}]
[]
["Certificate of Payment"]
["I certify that To the best of my knowledge, the claim is consistent with the progress of the work and is in accordance with the contract. This claim, however, "]
["may be subject to further verification and any necessary adjustment before final settlement."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority - Project Lead"]

{"sheet":"Certificate - Goods","index":9,"n_rows":57,"n_cols":42,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,25,3,29],[3,30,3,35],[5,0,5,3],[5,4,5,17],[5,18,6,21],[5,22,6,35],[5,41,43,60],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[7,18,7,21],[7,22,7,35],[8,0,8,3],[8,4,8,17],[8,18,8,21],[8,22,8,35],[8,37,10,39],[9,0,10,35],[11,0,12,3],[11,4,12,17],[11,18,11,25],[11,26,11,35],[12,18,12,25],[12,26,12,35],[16,4,16,17],[16,18,16,21],[16,22,16,35],[17,0,17,3],[17,4,17,17],[17,18,17,21],[17,22,17,35],[13,18,13,35],[14,4,14,17],[14,18,14,21],[14,22,14,35],[15,4,15,17],[15,18,15,21],[15,22,15,35],[25,18,25,22],[25,23,25,28],[25,29,25,35],[26,18,26,22],[26,23,26,28],[26,29,26,35],[18,0,19,22],[18,23,19,28],[18,29,19,35],[23,18,23,22],[23,23,23,28],[23,29,23,35],[24,18,24,22],[24,23,24,28],[24,29,24,35],[20,0,26,8],[20,18,20,22],[20,23,20,28],[20,29,20,35],[21,18,21,22],[21,23,21,28],[21,29,21,35],[30,29,30,35],[31,18,31,22],[31,23,31,28],[31,29,31,35],[32,18,32,22],[32,23,32,28],[32,29,32,35],[36,29,36,35],[27,3,27,8],[27,18,27,22],[27,23,27,28],[27,29,27,35],[29,0,32,8],[29,18,29,22],[29,23,29,28],[29,29,29,35],[30,18,30,22],[30,23,30,28],[45,0,45,35],[53,10,53,19],[53,23,53,35],[56,10,56,19],[56,23,56,35],[39,3,39,8],[39,18,39,22],[39,23,39,28],[39,29,39,35],[41,18,41,22],[41,23,41,28],[41,29,41,35],[43,18,43,22],[43,29,43,35],[37,18,37,22],[37,23,37,28],[37,29,37,35],[38,18,38,22],[38,23,38,28],[38,29,38,35],[33,3,33,8],[33,18,33,22],[33,23,33,28],[33,29,33,35],[35,0,38,8],[35,18,35,22],[35,23,35,28],[35,29,35,35],[36,18,36,22],[36,23,36,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLIER PAYMENT CLAIM (SPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goods Certificate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order #",null,null,null,null,{"$f":"'Payment Certificate'!AE4:AJ4","v":"[Insert PO# Here]"}]
[]
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing to fill here, everything updates automatically"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((VLOOKUP(W9, 'E-Previous Certifications'!A9:DW32, 132))=0, \"\", \"ERROR! \nPrevious Certifications tab\")","v":{"$error":"#N/A"}}]
["1. Contract Details"]
[]
["Subcontract Title",null,null,null,{"$f":"'Payment Claim'!E10","v":"[Contract Title]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Unit Basis Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA10","v":17869385.260000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Milestone Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA11","v":0}]
["Subcontract No.",null,null,null,{"$f":"'Payment Claim'!E12","v":"[Contract #]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Value ($)"]
["Subcontract Start",null,null,null,{"$f":"'Payment Claim'!E13","v":"2016-12-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Work Value",null,null,null,{"$f":"'Payment Claim'!W13","v":17869385.260000002}]
["Subcontract End",null,null,null,{"$f":"'Payment Claim'!E14","v":"2017-12-22"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation(s) Value",null,null,null,{"$f":"'Payment Claim'!W14","v":0}]
["Currency",null,null,null,{"$f":"'Payment Claim'!E15","v":"CAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,{"$f":"'Payment Claim'!W15","v":74950}]
["Holdback (%)",null,null,null,{"$f":"'Payment Claim'!E16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"'Payment Claim'!W16","v":17944335.260000002}]
["2. Amount Invoiced This Claim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previously Invoiced",null,null,null,null,null,"Total Invoiced to Date"]
[]
["Labour",null,null,null,null,null,null,null,null,"Regular Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!T40","v":5000},null,null,null,null,{"$f":"'A-Work Complete'!AL40","v":7500},null,null,null,null,null,{"$f":"'A-Work Complete'!BE40","v":12500}]
[null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!Z40","v":8000},null,null,null,null,{"$f":"'A-Work Complete'!AR40","v":8000},null,null,null,null,null,{"$f":"'A-Work Complete'!BK40","v":16000}]
[]
[null,null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N20","v":13000},null,null,null,null,{"$f":"'Payment Claim'!U20","v":15500},null,null,null,null,null,{"$f":"'Payment Claim'!Z20","v":28500}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S24*-E18","v":0},null,null,null,null,{"$f":"'Payment Claim'!U26","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z26","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,{"$f":"'C-Backcharges'!S23:X23","v":0},null,null,null,null,{"$f":"'C-Backcharges'!Y23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z27","v":0}]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W26)*0.05","v":650},null,null,null,null,{"$f":"SUM(X24:AC25)*0.05","v":775},null,null,null,null,null,{"$f":"SUM(AD24:AJ25)*0.05","v":1425}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D28:I28","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W27)","v":13650},null,null,null,null,{"$f":"SUM(X24:AC27)","v":16275},null,null,null,null,null,{"$f":"SUM(AD24:AJ27)","v":29925}]
[]
["Goods",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N21+'Payment Claim'!N23","v":0},null,null,null,null,{"$f":"'Payment Claim'!U21+'Payment Claim'!U23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z21+'Payment Claim'!Z23","v":0}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S30*-E18","v":0},null,null,null,null,{"$f":"X30*-E18","v":0},null,null,null,null,null,{"$f":"AD30*-E18","v":0},null,null,null,null,null,null,null,"Profit"]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W31)*0.05","v":0},null,null,null,null,{"$f":"SUM(X30:AC31)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ31)*0.05","v":0}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D34:I34","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W33)","v":0},null,null,null,null,{"$f":"SUM(X30:AC33)","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ33)","v":0}]
[]
["Travel & Living",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N29","v":4128.543615676359},null,null,null,null,{"$f":"'Payment Claim'!U29","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z29","v":4128.543615676359}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"S36*0.05","v":206.42718078381796},null,null,null,null,{"$f":"SUM(X36:AC36)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ36)*0.05","v":206.42718078381796}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D40:I40","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S36:W39)","v":4334.9707964601766},null,null,null,null,{"$f":"SUM(X36:AC39)","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ39)","v":4334.9707964601766}]
[]
[null,null,null,"Net Amount Certified This Claim (excl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W32)","v":0},null,null,null,null,{"$f":"SUM(X30:AC32)","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ32)","v":0}]
[]
[null,null,null,"Total Amount Certified This Claim (incl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S34)","v":0}]
[]
[{"$f":"spellnumber(S44)","v":"No Dollars and No Cents"}]
[]
["Certificate of Payment"]
["I certify that To the best of my knowledge, the claim is consistent with the progress of the work and is in accordance with the contract. This claim, however, "]
["may be subject to further verification and any necessary adjustment before final settlement."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority - Project Lead"]

{"sheet":"Certificate - Travel & Living","index":10,"n_rows":57,"n_cols":42,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,25,3,29],[3,30,3,35],[5,0,5,3],[5,4,5,17],[5,18,6,21],[5,22,6,35],[5,41,43,60],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[7,18,7,21],[7,22,7,35],[8,0,8,3],[8,4,8,17],[8,18,8,21],[8,22,8,35],[8,37,10,39],[9,0,10,35],[11,0,12,3],[11,4,12,17],[11,18,11,25],[11,26,11,35],[12,18,12,25],[12,26,12,35],[16,4,16,17],[16,18,16,21],[16,22,16,35],[17,0,17,3],[17,4,17,17],[17,18,17,21],[17,22,17,35],[13,18,13,35],[14,4,14,17],[14,18,14,21],[14,22,14,35],[15,4,15,17],[15,18,15,21],[15,22,15,35],[25,18,25,22],[25,23,25,28],[25,29,25,35],[26,18,26,22],[26,23,26,28],[26,29,26,35],[18,0,19,22],[18,23,19,28],[18,29,19,35],[23,18,23,22],[23,23,23,28],[23,29,23,35],[24,18,24,22],[24,23,24,28],[24,29,24,35],[20,0,26,8],[20,18,20,22],[20,23,20,28],[20,29,20,35],[21,18,21,22],[21,23,21,28],[21,29,21,35],[30,29,30,35],[31,18,31,22],[31,23,31,28],[31,29,31,35],[32,18,32,22],[32,23,32,28],[32,29,32,35],[36,29,36,35],[27,3,27,8],[27,18,27,22],[27,23,27,28],[27,29,27,35],[29,0,32,8],[29,18,29,22],[29,23,29,28],[29,29,29,35],[30,18,30,22],[30,23,30,28],[45,0,45,35],[53,10,53,19],[53,23,53,35],[56,10,56,19],[56,23,56,35],[39,3,39,8],[39,18,39,22],[39,23,39,28],[39,29,39,35],[41,18,41,22],[41,23,41,28],[41,29,41,35],[43,18,43,22],[43,29,43,35],[37,18,37,22],[37,23,37,28],[37,29,37,35],[38,18,38,22],[38,23,38,28],[38,29,38,35],[33,3,33,8],[33,18,33,22],[33,23,33,28],[33,29,33,35],[35,0,38,8],[35,18,35,22],[35,23,35,28],[35,29,35,35],[36,18,36,22],[36,23,36,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLIER PAYMENT CLAIM (SPC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel & Living Certificate"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order #",null,null,null,null,{"$f":"'Payment Certificate'!AE4:AJ4","v":"[Insert PO# Here]"}]
[]
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nothing to fill here, everything updates automatically"]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((VLOOKUP(W9, 'E-Previous Certifications'!A9:DW32, 132))=0, \"\", \"ERROR! \nPrevious Certifications tab\")","v":{"$error":"#N/A"}}]
["1. Contract Details"]
[]
["Subcontract Title",null,null,null,{"$f":"'Payment Claim'!E10","v":"[Contract Title]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Unit Basis Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA10","v":17869385.260000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Milestone Value",null,null,null,null,null,null,null,{"$f":"'Payment Claim'!AA11","v":0}]
["Subcontract No.",null,null,null,{"$f":"'Payment Claim'!E12","v":"[Contract #]"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Value ($)"]
["Subcontract Start",null,null,null,{"$f":"'Payment Claim'!E13","v":"2016-12-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Work Value",null,null,null,{"$f":"'Payment Claim'!W13","v":17869385.260000002}]
["Subcontract End",null,null,null,{"$f":"'Payment Claim'!E14","v":"2017-12-22"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Variation(s) Value",null,null,null,{"$f":"'Payment Claim'!W14","v":0}]
["Currency",null,null,null,{"$f":"'Payment Claim'!E15","v":"CAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,{"$f":"'Payment Claim'!W15","v":74950}]
["Holdback (%)",null,null,null,{"$f":"'Payment Claim'!E16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,{"$f":"'Payment Claim'!W16","v":17944335.260000002}]
["2. Amount Invoiced This Claim",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previously Invoiced",null,null,null,null,null,"Total Invoiced to Date"]
[]
["Labour",null,null,null,null,null,null,null,null,"Regular Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!T40","v":5000},null,null,null,null,{"$f":"'A-Work Complete'!AL40","v":7500},null,null,null,null,null,{"$f":"'A-Work Complete'!BE40","v":12500}]
[null,null,null,null,null,null,null,null,null,"Travel Value",null,null,null,null,null,null,null,null,{"$f":"'A-Work Complete'!Z40","v":8000},null,null,null,null,{"$f":"'A-Work Complete'!AR40","v":8000},null,null,null,null,null,{"$f":"'A-Work Complete'!BK40","v":16000}]
[]
[null,null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N20","v":13000},null,null,null,null,{"$f":"'Payment Claim'!U20","v":15500},null,null,null,null,null,{"$f":"'Payment Claim'!Z20","v":28500}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S24*-E18","v":0},null,null,null,null,{"$f":"'Payment Claim'!U26","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z26","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,{"$f":"'C-Backcharges'!S23:X23","v":0},null,null,null,null,{"$f":"'C-Backcharges'!Y23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z27","v":0}]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W26)*0.05","v":650},null,null,null,null,{"$f":"SUM(X24:AC25)*0.05","v":775},null,null,null,null,null,{"$f":"SUM(AD24:AJ25)*0.05","v":1425}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D28:I28","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S24:W27)","v":13650},null,null,null,null,{"$f":"SUM(X24:AC27)","v":16275},null,null,null,null,null,{"$f":"SUM(AD24:AJ27)","v":29925}]
[]
["Goods",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N21+'Payment Claim'!N23","v":0},null,null,null,null,{"$f":"'Payment Claim'!U21+'Payment Claim'!U23","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z21+'Payment Claim'!Z23","v":0}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,{"$f":"S30*-E18","v":0},null,null,null,null,{"$f":"X30*-E18","v":0},null,null,null,null,null,{"$f":"AD30*-E18","v":0}]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W31)*0.05","v":0},null,null,null,null,{"$f":"SUM(X30:AC31)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ31)*0.05","v":0}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D34:I34","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S30:W33)","v":0},null,null,null,null,{"$f":"SUM(X30:AC33)","v":0},null,null,null,null,null,{"$f":"SUM(AD30:AJ33)","v":0}]
[]
["Travel & Living",null,null,null,null,null,null,null,null,"Total Value",null,null,null,null,null,null,null,null,{"$f":"'Payment Claim'!N29","v":4128.543615676359},null,null,null,null,{"$f":"'Payment Claim'!U29","v":0},null,null,null,null,null,{"$f":"'Payment Claim'!Z29","v":4128.543615676359}]
[null,null,null,null,null,null,null,null,null,"Holdback This Invoice",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"Backcharges",null,null,null,null,null,null,null,null,"-",null,null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"G.S.T. This Invoice",null,null,null,null,null,null,null,null,{"$f":"S36*0.05","v":206.42718078381796},null,null,null,null,{"$f":"SUM(X36:AC36)*0.05","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ36)*0.05","v":206.42718078381796}]
["Invoice #",null,null,{"$f":"'Payment Certificate'!D40:I40","v":"[Enter Invoice #]"},null,null,null,null,null,"Total Payable This Invoice",null,null,null,null,null,null,null,null,{"$f":"SUM(S36:W39)","v":4334.9707964601766},null,null,null,null,{"$f":"SUM(X36:AC39)","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ39)","v":4334.9707964601766}]
[]
[null,null,null,"Net Amount Certified This Claim (excl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S36:W38)","v":4128.543615676359},null,null,null,null,{"$f":"SUM(X36:AC38)","v":0},null,null,null,null,null,{"$f":"SUM(AD36:AJ38)","v":4128.543615676359}]
[]
[null,null,null,"Total Amount Certified This Claim (incl. taxes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S40)","v":4334.9707964601766}]
[]
[{"$f":"spellnumber(S44)","v":"Four Thousand Three Hundred Thirty Four Dollars and Ninety Seven Cents"}]
[]
["Certificate of Payment"]
["I certify that To the best of my knowledge, the claim is consistent with the progress of the work and is in accordance with the contract. This claim, however, "]
["may be subject to further verification and any necessary adjustment before final settlement."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Subcontract Authority - Project Lead"]

{"sheet":"Forecast","index":11,"n_rows":19,"n_cols":27,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,12],[0,13,1,16],[0,17,1,29],[1,0,1,3],[1,4,1,12],[6,0,7,5],[6,6,7,9],[2,17,2,29],[3,0,3,3],[3,4,3,12],[3,13,3,16],[3,17,3,29],[2,0,2,3],[2,4,2,12],[2,13,2,16],[4,0,5,29],[6,10,7,13],[6,14,7,17],[6,18,7,21],[6,26,7,29],[8,30,17,36],[9,0,9,5],[9,6,9,9],[8,18,8,21],[8,22,8,25],[8,26,8,29],[8,0,8,5],[8,6,8,9],[10,0,10,5],[10,6,10,9],[9,18,9,21],[9,22,9,25],[9,26,9,29],[12,26,12,29],[12,0,12,5],[12,6,12,9],[11,10,11,13],[13,18,13,21],[14,18,14,21],[12,22,12,25],[13,22,13,25],[14,22,14,25],[14,0,14,5],[14,6,14,9],[13,26,13,29],[13,0,13,5],[13,6,13,9],[14,26,14,29],[18,26,18,29],[17,18,17,21],[17,26,17,29],[17,0,17,5],[17,6,17,9],[11,14,11,17],[6,22,7,25],[16,26,16,29],[16,0,16,5],[16,6,16,9],[15,26,15,29],[15,0,15,5],[15,6,15,9],[15,18,15,21],[16,18,16,21],[15,22,15,25],[16,22,16,25],[11,22,11,25],[11,26,11,29],[11,0,11,5],[11,6,11,9],[8,10,8,13],[9,10,9,13],[10,10,10,13],[10,18,10,21],[10,22,10,25],[8,14,8,17],[9,14,9,17],[10,14,10,17],[10,26,10,29],[17,14,17,17],[12,10,12,13],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[12,14,12,17],[13,14,13,17],[14,14,14,17],[15,14,15,17],[16,14,16,17],[17,22,17,25],[11,18,11,21],[12,18,12,21]]}
["Project",null,null,null,{"$f":"'Payment Claim'!E4","v":"[Project Name]"},null,null,null,null,null,null,null,null,"SPC No.",null,null,null,{"$f":"'Payment Claim'!W4","v":"[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["Phase",null,null,null,{"$f":"'Payment Claim'!E5","v":"[Project Phase]"}]
["Supplier (SC)",null,null,null,{"$f":"'Payment Claim'!E6","v":"[Company Name]"},null,null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Payment Claim'!W6","v":"2017-04-04"}]
["SC's Repres.",null,null,null,{"$f":"'Payment Claim'!E7","v":"[SC's Representative]"},null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,{"$f":"'Payment Claim'!W7","v":"[Contract #]-SPC-[Insert Phase-MMM-YY} e.g. BDD-Jan-17"}]
["Cash Flow Forecast (Three Month Rolling Forecast)"]
[]
["Forecast Month",null,null,null,null,null,"Labour ",null,null,null,"Goods",null,null,null,"Travel & Living",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[]
["[*insert following Month MMDDYY]",null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G9:Z10)","v":0}]
["[*insert following Month MMDDYY]",null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G10:Z11)","v":0}]
["[*insert following Month MMDDYY]",null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=SUM(AE9:AH18)"]