{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Commentary","Project Info","Record Docs","App For Payment-Template","Certificates For Payment","Cert For Pay (Annual or Phased)","Lookups","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":36,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Commentary","index":0,"n_rows":94,"n_cols":3,"rows_kept":94,"cut":false,"hidden":false,"merged":[[92,2,92,12],[93,2,93,12],[91,2,91,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Revision History"]
[null,"Jan 2019","The instructions were expanded to address protecting and unprotecting sheets."]
[null,"July 2018","A line was added to the lookup table so the workbook works in Ontario with either the old Construction Lien Act or the new Construction Act. The lookup tables have been expanded with parameters from the other jurisdictions in Canada besides Ontario for use on projects in those jurisdictions. In addition the labels on the tabs have been enhanced to reflect the terminology/parameters of the selected jurisdiction."]
[null,"May 2017","The Certificate For Payment was reorganized to better reflect that the certification is of the value of the work completed to date and the amount owing to the contractor this payment period. The calculation are provided for convenience and information, and are themselves not being certified."]
[null,"May 2017","The calculation of statutory holdback has been changed to explicitly show separate line items for basic and finishing holdback. This requires one additional step by the user for projects in Ontario: to enter the amount of work complete at Substantial Performance (In the labelled cell that is part of the Trial Certificate of Substantial Performance). It does however permit the workbook to be used for projects being done in other provinces or territories where there may be no finishing holdback or a different calculation may be required."]

{"sheet":"Project Info","index":1,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":false,"merged":[[9,1,9,11],[10,1,10,11],[10,12,10,22],[2,1,2,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[4,1,4,11],[3,1,3,11]]}
["Schedule of Values/Certificate for Payment workbook",null,null,null,null,null,null,null,null,null,null,"Rev. 2019 01"]
["History"]
[null,"The version was updated to work with the new Construction Act, and at the same time was expanded to work with the lien legislation of the other jurisdictions in Canada. It is made available through the OAA's PAR committee."]
[null,"The first public version was made available through the OAA's CCA committee. It worked with the Construction Lien Act of Ontario only."]
[null,"The original version of this workbook was developed 30 years ago to assist the author in checking applications for payment."]
["Initial Instructions:"]
[0,"The proper functioning of this workbook depends on the operation of macro programming written using Visual Basic for Applications (VBA). The VBA language is a part of the applications in the Microsoft Office suite. Unless macros are enabled, this workbook will not function properly."]
[null,"If used with malicious intent, VBA macros can  be used to attack or damage computer files. The macros used in this workbook copy tabs and information between tabs. They do not access any other file or the internet, nor have they caused any known issues with other programs."]
[null,"To avoid anyone easily tampering with the macros and circulating an infected file, access to the macros is protected. To protect yourself, you should download a copy of the workbook directly from the OAA web site. This also ensures you have the latest version of the workbook complete with any bug fixes and enhancements."]
[null,"Before this workbook will function, you wil need to enable macros by clicking on the button below the menu bar or by declaring this file to be a trusted file or by putting it in a trusted folder."]
[null,"When protected, you should be able to enter data into any of the green shaded cells. It is recommended that you protect the sheets to avoid accidentally changing or deleting formulas."]
[]
[]
[1,"Fill in the initial information in the green shaded cells below."]
[]
[null,"Client Name","Favourite Client Company"]
[null,"Client Address 1","Client Address 1"]
[null,"Client Address 2","Client Address 2"]
[null,"Client Representative","Favourite Person"]
[null,"Building Permit Number","18 111999 BLD 00 BA"]
[null,"Project Number","18.32001.00"]
[null,"Project Name","Award Winner"]
[null,"Project Type","Sustainable Office"]
[null,"Consultant","Visionary Architects"]
[null,"Consultant Address 1","Address line 1"]
[null,"Consultant Address 2","Address line 2"]
[null,"Consultant Telephone","(999) 123-4567"]
[null,"Consultant Fax","(000) 987-6543"]
[null,"Contractor","Quality Contractors Inc."]
[null,"Contract Amount",1234567.8899999999]
[null,"Start of First Payment Period",{"$f":"DATE(C32,C33,C34)","v":"2018-07-01"}]
[null,"Year",2018,"YYYY"]
[null,"Month",7,"MM"]
[null,"Day",1,"DD"]
[null,"Province"," Ontario "]
[null,"Applicable Legislation","Construction Act, Ontario"]
[null,"Basic Holdback %",0.1]
[null,"Finishing Holdback %",{"$f":"Lookups!W30","v":0.1}]
[null,"Basis of Holdback Release","-"]
[null,{"$f":"IF(C39=Lookups!O7, \"Annual release date:\",IF(C39=Lookups!O8,\"List phases:\",\" \"))","v":" "}]
[null,"Tax Rate",{"$f":"Lookups!H30","v":0.13}]
[null,"Tax Type",{"$f":"Lookups!F30","v":"HST"}]
[]
[]
[{"$f":"1+A14","v":2},"Insert or delete line items as needed to reflect the current project in the schedule of values on the \"App For Payment-Template\" tab. "]
[{"$f":"A45+1","v":3},"If the sheet is protected, go to the Review tab and click on Unprotect Sheet."]
[{"$f":"A46+1","v":4},"Ensure the formulas are copied into the newly inserted lines."]
[5,"Repeat across all columns."]
[6,"Use the Record Docs tab to determine an appropriate value for the entire record documents."]
[7,"Divide the total as appropriate across the various disciplines."]
[8,"If not already included as part of the bid documents, send a PDF copy of the schedule of values portion of the worksheet"]
[null,"to the Contractor as a template for their use in submitting the contract breakdown."]
[]
["Usage Instructions:"]
[{"$f":"A51+1","v":9},"Copy the agreed upon contract breakdown values provided by the Contractor into the \"Contract Amount\" column."]
[{"$f":"1+A55","v":10},"When complete, go to the Review tab and click on Protect Sheet."]
[11,"Click on the \"Create a new Schedule of Values\" button to create one."]
[{"$f":"1+A57","v":12},"Enter the percent complete into the green shaded cells in the \"% to Date\" column."]
[{"$f":"1+A58","v":13},"Enter any holdback released or deficiency amounts into the green boxes in the Certificate section."]
[{"$f":"1+A58","v":13},"Compare the totals and certificate values with the Contractor's application for payment."]
[null,"If all agrees,  prepare a Certificate For Payment."]
[null,"If there are differences, advise the Contractor and attempt to resolve them."]
[{"$f":"1+A60","v":14},"Submit a PDF of the schedule of values portion of the worksheet with the Certificate for Payment."]
[{"$f":"1+A63","v":15},"Convert the Date Issued field on the schedule of values from a formula to a date value (Copy and Paste values)"]
[]
["Change Orders:"]
[{"$f":"1+A64","v":16},"Change orders are handled the same way as line items in the schedule of values section with one major difference."]
[null,"The difference allows you to enter the change order information when it is issued, but not have it affect the contract amount until approved."]
[null,"There is a formula in the contract amount column"]
[null,"The change order amount is initially entered in the green shaded \"CO Amount\" column."]
[null,"When the change order is signed by the Owner and Contractor, an entry is made in the green shaded \"Approved\" column."]
[null,"This causes the amount to be displayed in the \"Contract Amount\" column."]
[]
["Substantial Performance:"]
[{"$f":"1+A67","v":17},"The substantial performance section below the schedule of values section automatically calculates and displays the status of the project."]
[null,"When substantial performance has been achieved, enter the value of the work completed at substantial performance in the cell indicated."]
[null,"Doing so allows the finishing holdback to be calculated at a different rate where required by the jurisdiction of the place of the work."]
[]
["Deemed Completion:"]
[{"$f":"1+A75","v":18},"The deemed completion section below the substantial performance section automatically calculates and displays the status of the project."]
[]
["Deficiency Retainage"]
[{"$f":"1+A80","v":19},"The Deficiency Retainage line item on the certificates for payment is provided for those who use this method."]
[null,"It is preferable to reflect the value to correct deficient work in the appropriate line items of the schedule of values"]
[null,"so that you are only certifying the value of work completed in accordance with the contract documents."]
[null,"The latter method makes it explicit to the general contractor and the sub-contractors which items are deficient."]
[null,"It also makes it easier to adjust the schedule of values as the deficiencies are completed."]

{"sheet":"Record Docs","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,2,1,3],[23,1,23,6],[19,1,19,6],[21,1,21,6]]}
[null,"Proposed Value of As-Builts/Close-out Documents"]
[null,null,"Hide these 2 columns"]
[null,"Initial Contract Value:",null,null,{"$f":"'Project Info'!$C$30","v":1234567.8899999999}]
[]
[null,"Calculations of value based on percentage of initial contract value"]
["Calc 1","Initial Contract Value Range","Limits","Percentage",{"$f":"D6","v":"Percentage"},"As-Built Value","Rounded"]
[null,{"$f":"\"Less than $\"&$C$7","v":"Less than $150000"},150000,0.03,{"$f":"$D$7","v":0.03}]
[null,{"$f":"\"From $\"&$C$7&\" to $\"&$C$8","v":"From $150000 to $300000"},300000,0.02,{"$f":"$D$8","v":0.02}]
[null,{"$f":"\"From $\"&$C$8&\" to $\"&$C$9","v":"From $300000 to $750000"},750000,0.01,{"$f":"$D$9","v":0.01}]
[null,{"$f":"\"Greater than $\"&$C$9","v":"Greater than $750000"},null,5.0000000000000001E-3,{"$f":"$D$10","v":5.0000000000000001E-3}]
[null,null,null,null,{"$f":"$D$10","v":5.0000000000000001E-3}]
[null,null,null,null,{"$f":"IF($E$3<C7,D7,IF($E$3<C8,D8,IF($E$3<C9,D9,D10)))","v":5.0000000000000001E-3},{"$f":"$E$3*E12","v":6172.8394499999995},{"$f":"ROUNDUP(F12,-1)","v":6180}]
["Calc 2","Initial Contract Value","Differential",null,{"$f":"E6","v":"Percentage"},"As-Built Value","Rounded"]
[null,{"$f":"\"On the first $\"&$C$7","v":"On the first $150000"},{"$f":"$C$7","v":150000},{"$f":"$D$7","v":0.03},{"$f":"$D$7","v":0.03},{"$f":"IF($E$3>0,IF($E$3<$C$7,$E$3*$D$7,$C$7*$D$7),0)","v":4500}]
[null,{"$f":"\"On the next $\"&$C$8-$C$7","v":"On the next $150000"},{"$f":"$C$8-$C$7","v":150000},{"$f":"$D$8","v":0.02},{"$f":"$D$8","v":0.02},{"$f":"IF($E$3>$C$7,IF($E$3<$C$8,($E$3-$C$7)*$D$8,($C$8-$C$7)*$D$8),0)","v":3000}]
[null,{"$f":"\"On the next $\"&$C$9-$C$8","v":"On the next $450000"},{"$f":"$C$9-$C$8","v":450000},{"$f":"$D$9","v":0.01},{"$f":"$D$9","v":0.01},{"$f":"IF($E$3>$C$8,IF($E$3<$C$9,($E$3-$C$8)*$D$9,($C$9-$C$8)*$D$9),0)","v":4500}]
[null,{"$f":"\"On the remaining $\"&IF($E$3>$C$9,$E$3-$C$9,0)","v":"On the remaining $484567.89"},{"$f":"IF($E$3>$C$9,$E$3-$C$9,0)","v":484567.8899999999},{"$f":"$D$10","v":5.0000000000000001E-3},{"$f":"$D$10","v":5.0000000000000001E-3},{"$f":"IF($E$3<$C$9,0,($E$3-$C$9)*$D$10)","v":2422.8394499999995}]
[null,null,null,null,null,{"$f":"SUM(F14:F17)","v":14422.839449999999},{"$f":"ROUNDUP(F18,-1)","v":14430}]
[]
[null,{"$f":"\"If this value exceeds \"&TEXT($G$32,\"$0,0.00\")&\" then Substantial Performance/Completion cannot be achieved without Close-out Document completion.\"","v":"If this value exceeds $34,691.36 then Substantial Performance/Completion cannot be achieved without Close-out Document completion."}]
[]
[null,{"$f":"\"If this value is less than \"&TEXT($G$39,\"$0,0.00\")&\" then Deemed Completion can be achieved without Close-out Documents.\"","v":"If this value is less than $5,000.00 then Deemed Completion can be achieved without Close-out Documents."}]
[]
[null,"The appropriate record document value will vary depending on the nature of the project. Enter the desired value in the Schedule of Values before sending to the Contractor."]
[]
[]
[null,"Substantial Performance: ",null,null,null,null,{"$f":"\"Based on the \"&Lookups!$AE$30","v":"Based on the Construction Act, Ontario"}]
[null,"Initial Contract Amount",null,null,{"$f":"$E$3","v":1234567.8899999999}]
[null,{"$f":"Lookups!$O$30*100&\"% on 1st $\"&Lookups!$P$30","v":"3% on 1st $1000000"},null,null,{"$f":"IF(E28>Lookups!$P$30,Lookups!$P$30,E28)","v":1000000},{"$f":"Lookups!$O$30","v":0.03},{"$f":"ROUND($E29*$F29,2)","v":30000}]
[null,{"$f":"Lookups!$Q$30*100&\"% on next $\"&Lookups!$R$30","v":"2% on next $1000000"},null,null,{"$f":"IF(E28>Lookups!$P$30+Lookups!$R$30,Lookups!$R$30,E28-E29)","v":234567.8899999999},{"$f":"Lookups!$Q$30","v":0.02},{"$f":"ROUND($E30*$F30,2)","v":4691.3599999999997}]
[null,{"$f":"Lookups!$S$30*100&\"% on remainder\"","v":"1% on remainder"},null,null,{"$f":"IF(F31=0,0,IF(E28>Lookups!$P$30+Lookups!$R$30,E28-E29-E30,0))","v":0},{"$f":"Lookups!$S$30","v":0.01},{"$f":"ROUND($E31*$F31,2)","v":0}]
[null,"Maximum outstanding per Act",null,null,null,null,{"$f":"SUM(G29:G31)","v":34691.360000000001}]
[]
[null,"Deemed Completion: ",null,null,null,null,{"$f":"\"Based on the \"&Lookups!$AE$30","v":"Based on the Construction Act, Ontario"}]
[null,"Initial Contract Amount",null,null,{"$f":"$E$3","v":1234567.8899999999}]
[null,"A  % of contract amount",null,null,null,{"$f":"Lookups!$Y$30","v":0.01},{"$f":"ROUND(E35*F36,2)","v":12345.68}]
[null,{"$f":"\"B  \" & Act","v":"B  Construction Act, Ontario"},null,null,null,null,{"$f":"Lookups!$Z$30","v":5000}]
[null,{"$f":"IF(TRIM(Province)=\"Ontario\",\"  (Section 2 subsection (3) limit)\",\"\")","v":"  (Section 2 subsection (3) limit)"}]
[null,"Maximum outstanding per Act (lesser of A and B)",null,null,null,null,{"$f":"IF(G36>G37,G37,G36)","v":5000}]
[]
[]
[null,"To change any of the calculation parameters, unhide columns C and D."]

{"sheet":"App For Payment-Template","index":3,"n_rows":199,"n_cols":12,"rows_kept":199,"cut":false,"hidden":false,"merged":[[140,2,140,3],[140,4,140,5],[174,5,175,6],[180,4,180,5]]}
[{"$f":"'Project Info'!$C$16","v":"Favourite Client Company"},null,null,null,null,null,null,"Document 00 62 73"]
["Project Name:",{"$f":"'Project Info'!$C$22&\" - \"&'Project Info'!$C$23","v":"Award Winner - Sustainable Office"},null,null,null,null,null,"SCHEDULE OF VALUES"]
["Project Number:",{"$f":"'Project Info'!$C$21","v":"18.32001.00"},null,null,null,null,"Application for Payment #: ",0]
["Consultant:",{"$f":"'Project Info'!$C$24","v":"Visionary Architects"},null,null,null,null,"Issue Date:  ",{"$f":"NOW()","v":"2020-05-07T14:21:47.040"}]
["Contractor:",{"$f":"'Project Info'!$C$29","v":"Quality Contractors Inc."},null,null,null,null,"For Period Ending: ","2018-07-31"]
["Spec. Section","Item","Contract Amount","%\nto Date","Previous Amount","Amount\nThis Draw","Completed \nto Date","Balance\nto Complete"]
["General","Insurance",0,0,0,{"$f":"G7-E7","v":0},{"$f":"ROUND(C7*D7,2)","v":0},{"$f":"C7-G7","v":0}]
[null,"Bonding",0,0,0,0,0,0]
[null,"Mobilization",0,0,0,0,0,0]
[null,"Supervision",0,0,0,0,0,0]
[null,"Disposal",0,0,0,0,0,0]
[null,"Labour",0,0,0,0,0,0]
[null,"General Conditions",0,0,0,0,0,0]
["01 73 29","Cutting & Patching",0,0,0,0,0,0]
["01 77 00","Project Record Docs (Manuals/Docs/ As-builts)",0,0,0,0,0,0]
["03 33 00","Cast-in-Place Concrete (below grade)",0,0,0,{"$f":"G16-E16","v":0},{"$f":"ROUND(C16*D16,2)","v":0},{"$f":"C16-G16","v":0}]
["03 33 00","Cast-in-Place Concrete (above grade)",0,0,0,{"$f":"G17-E17","v":0},{"$f":"ROUND(C17*D17,2)","v":0},{"$f":"C17-G17","v":0}]
["03 45 00","Precast Concrete",0,0,0,{"$f":"G18-E18","v":0},{"$f":"ROUND(C18*D18,2)","v":0},{"$f":"C18-G18","v":0}]
["04 21 13","Brick Masonry",0,0,0,{"$f":"G19-E19","v":0},{"$f":"ROUND(C19*D19,2)","v":0},{"$f":"C19-G19","v":0}]
["04 22 00","Concrete Unit Masonry",0,0,0,{"$f":"G20-E20","v":0},{"$f":"ROUND(C20*D20,2)","v":0},{"$f":"C20-G20","v":0}]
["05 12 00","Structural Steel Framing",0,0,0,{"$f":"G21-E21","v":0},{"$f":"ROUND(C21*D21,2)","v":0},{"$f":"C21-G21","v":0}]
["05 31 00","Steel Decking",0,0,0,0,0,0]
["05 50 00","Metal Fabrications",0,0,0,0,0,0]
["05 73 00","Handrail Railings",0,0,0,0,0,0]
["06 10 00","Rough Carpentry",0,0,0,0,0,0]
["06 40 23","Architectural Woodwork",0,0,0,0,0,0]
["06 90 00","General Installations",0,0,0,0,0,0]
["07 24 15","EIFS",0,0,0,{"$f":"G28-E28","v":0},{"$f":"ROUND(C28*D28,2)","v":0},{"$f":"C28-G28","v":0}]
["07 51 00","Roofing",0,0,0,{"$f":"G29-E29","v":0},{"$f":"ROUND(C29*D29,2)","v":0},{"$f":"C29-G29","v":0}]
["07 62 00","Sheet Metal Flashing & Trim",0,0,0,{"$f":"G30-E30","v":0},{"$f":"ROUND(C30*D30,2)","v":0},{"$f":"C30-G30","v":0}]
["07 92 00","Joint Sealants",0,0,0,0,0,0]
["08 11 13","HM Doors/Frames",0,0,0,0,0,0]
["08 11 16/08 43 29","Aluminum Sliding Doors",0,0,0,0,0,0]
["08 41 13","Aluminum Framed Entrances",0,0,0,0,0,0]
["08 51 13","Aluminum Windows",0,0,0,0,0,0]
["08 71 00","Door Hardware Supply",0,0,0,0,0,0]
["08 81 00/08 83 13","Glass Glazing/Mirrors",0,0,0,0,0,0]
["08 87 00","Glazing Surface Film",0,0,0,0,0,0]
["09 21 16","Gypsum Board Assemblies",0,0,0,0,0,0]
["09 51 00","Acoustical Ceilings",0,0,0,0,0,0]
["09 65 00","Resilient Flooring",0,0,0,0,0,0]
["09 68 13","Tile Carpeting",0,0,0,0,0,0]
["09 90 00","Painting & Coating",0,0,0,0,0,0]
["09 91 00","Painting",0,0,0,0,0,0]
["10 21 13.13","Metal Toilet Compartments",0,0,0,0,0,0]
["10 26 13","Corner Guards",0,0,0,0,0,0]
["10 26 16","Bumper Guards",0,0,0,0,0,0]
["11 52 13","Projection Screens",0,0,0,0,0,0]
["11 52 23","TV/VCR Mount",0,0,0,{"$f":"G49-E49","v":0},{"$f":"ROUND(C49*D49,2)","v":0},{"$f":"C49-G49","v":0}]
["12 48 16","Entrance Floor Grilles",0,0,0,0,0,0]
["12 24 13","Roller Shades",0,0,0,0,0,0]
["32 12 16","Asphalt Paving",0,0,0,{"$f":"G52-E52","v":0},{"$f":"ROUND(C52*D52,2)","v":0},{"$f":"C52-G52","v":0}]
["32 31 13","Chain Link Fencing",0,0,0,{"$f":"G53-E53","v":0},{"$f":"ROUND(C53*D53,2)","v":0},{"$f":"C53-G53","v":0}]
[null,"Architectural subtotal:",{"$f":"SUM(C7:C53)","v":0},{"$f":"IF(C54=0,0,G54/C54)","v":0},{"$f":"SUM(E7:E53)","v":0},{"$f":"SUM(F7:F53)","v":0},{"$f":"SUM(G7:G53)","v":0},{"$f":"SUM(H7:H53)","v":0}]
[]
["21 00 00","Fire Supression - Labour",0,0,0,{"$f":"G56-E56","v":0},{"$f":"ROUND(C56*D56,2)","v":0},{"$f":"C56-G56","v":0}]
[null,"Fire Supression - other",0,0,0,0,0,0]
[null,"Piping",0,0,0,0,0,0]
[null,"Supports",0,0,0,0,0,0]
[null,"Sprinkler heads",0,0,0,0,0,0]
[null,"Fire Stopping/Sealants",0,0,0,{"$f":"G61-E61","v":0},{"$f":"ROUND(C61*D61,2)","v":0},{"$f":"C61-G61","v":0}]
[null,"Manuals/Documentation/As-builts",0,0,0,0,0,0]
[]
["22 00 00","Plumbing - Labour",0,0,0,{"$f":"G64-E64","v":0},{"$f":"ROUND(C64*D64,2)","v":0},{"$f":"C64-G64","v":0}]
[null,"Plumbing - other",0,0,0,0,0,0]
[null,"Piping",0,0,0,0,0,0]
[null,"Insulation",0,0,0,0,0,0]
[null,"Fixtures",0,0,0,0,0,0]
[null,"Manuals/Documentation/As-builts",0,0,0,0,0,0]
[]
["23 00 00","HVAC - Labour",0,0,0,{"$f":"G71-E71","v":0},{"$f":"ROUND(C71*D71,2)","v":0},{"$f":"C71-G71","v":0}]
[null,"Roof top units",0,0,0,{"$f":"G72-E72","v":0},{"$f":"ROUND(C72*D72,2)","v":0},{"$f":"C72-G72","v":0}]
[null,"Chillers",0,0,0,{"$f":"G73-E73","v":0},{"$f":"ROUND(C73*D73,2)","v":0},{"$f":"C73-G73","v":0}]
[null,"Condensors",0,0,0,0,0,0]
[null,"Ductwork",0,0,0,0,0,0]
[null,"Grilles/diffusers",0,0,0,0,0,0]
[null,"Controls",0,0,0,0,0,0]
[null,"Clean up",0,0,0,0,0,0]
[null,"Installation",0,0,0,0,0,0]
[null,"Insulation",0,0,0,0,0,0]
[null,"Baseboard Heaters",0,0,0,0,0,0]
[null,"Air Balancing",0,0,0,0,0,0]
[null,"Manuals/Documentation/As-builts",0,0,0,{"$f":"G83-E83","v":0},{"$f":"ROUND(C83*D83,2)","v":0},{"$f":"C83-G83","v":0}]
[null,"Mechanical subtotal:",{"$f":"SUM(C56:C83)","v":0},{"$f":"IF(C84=0,0,G84/C84)","v":0},{"$f":"SUM(E56:E83)","v":0},{"$f":"SUM(F56:F83)","v":0},{"$f":"SUM(G56:G83)","v":0},{"$f":"SUM(H56:H83)","v":0}]
[]
["26 00 00","Electrical - Labour",0,0,0,{"$f":"G86-E86","v":0},{"$f":"ROUND(C86*D86,2)","v":0},{"$f":"C86-G86","v":0}]
[null,"Electrical - other",0,0,0,0,0,0]
[null,"Lighting - Rough-in",null,0,0,0,0,0]
[null,"Lighting Fixtures",0,0,0,0,0,0]
[null,"Transformers",0,0,0,{"$f":"G90-E90","v":0},{"$f":"ROUND(C90*D90,2)","v":0},{"$f":"C90-G90","v":0}]
[null,"Switchgear",0,0,0,{"$f":"G91-E91","v":0},{"$f":"ROUND(C91*D91,2)","v":0},{"$f":"C91-G91","v":0}]
[null,"Panels",0,0,0,0,0,0]
[null,"Power - Rough-in",0,0,0,0,0,0]
[null,"Devices",3000000,0,0,0,0,3000000]
[null,"Manuals/Documentation/As-builts",0,0,0,0,0,0]
[null,null,null,null,null,null,0]
["27 10 00","Data Cabling",0,0,0,{"$f":"G97-E97","v":0},0,{"$f":"C97-G97","v":0}]
["27 51 19","Sound Masking ",0,0,0,{"$f":"G98-E98","v":0},0,{"$f":"C98-G98","v":0}]
[null,"Electrical subtotal:",{"$f":"SUM(C86:C98)","v":3000000},{"$f":"IF(C99=0,0,G99/C99)","v":0},{"$f":"SUM(E86:E98)","v":0},{"$f":"SUM(F86:F98)","v":0},{"$f":"SUM(G86:G98)","v":0},{"$f":"SUM(H86:H98)","v":3000000}]
[]
[null,"Base Contract subtotal:",{"$f":"C54+C84+C99","v":3000000},{"$f":"IF(C101=0,0,G101/C101)","v":0},{"$f":"E54+E84+E99","v":0},{"$f":"F54+F84+F99","v":0},{"$f":"G54+G84+G99","v":0},{"$f":"H54+H84+H99","v":3000000}]
[null,null,{"$f":"IF(Contract_Amount<>'App For Payment-Template'!C101,\"The base contract subtotal doesn't match the amount on the Project Info tab.\",\"\")","v":"The base contract subtotal doesn't match the amount on the Project Info tab."}]
["Cash Allowances:"]
[1,null,0,0,0,{"$f":"G104-E104","v":0},{"$f":"ROUND(C104*D104,2)","v":0},{"$f":"C104-G104","v":0}]
[2,null,0,0,0,{"$f":"G105-E105","v":0},{"$f":"ROUND(C105*D105,2)","v":0},{"$f":"C105-G105","v":0}]
[3,null,0,null,0,{"$f":"G106-E106","v":0},{"$f":"ROUND(C106*D106,2)","v":0},{"$f":"C106-G106","v":0}]
[null,"Cash Allowance subtotal:",{"$f":"SUM(C104:C106)","v":0},{"$f":"IF(C107=0,0,G107/C107)","v":0},{"$f":"SUM(E104:E106)","v":0},{"$f":"SUM(F104:F106)","v":0},{"$f":"SUM(G104:G106)","v":0},{"$f":"SUM(H104:H106)","v":0}]
[]
[null,"Contract subtotal:",{"$f":"C101+C107","v":3000000},{"$f":"IF(C109=0,0,G109/C109)","v":0},{"$f":"E101+E107","v":0},{"$f":"F101+F107","v":0},{"$f":"G101+G107","v":0},{"$f":"H101+H107","v":3000000}]
[]
[]
["Issued Change Orders:",null,null,null,null,null,null,null,"Approved","CO Amount"]
[1,"CO title",{"$f":"IF(ISBLANK($I113),0,$J113)","v":0},0,0,{"$f":"G113-E113","v":0},{"$f":"ROUND(C113*D113,2)","v":0},{"$f":"C113-G113","v":0},null,0]
[2,null,{"$f":"IF(ISBLANK($I114),0,$J114)","v":0},0,0,0,{"$f":"ROUND(C114*D114,2)","v":0},0,null,0]
[3,null,0,0,0,0,0,0,null,0]
[4,null,0,0,0,0,0,0,null,0]
[5,null,0,0,0,0,0,0,null,0]
[6,null,0,0,0,0,0,0,null,0]
[7,null,0,0,0,0,0,0,null,0]
[8,null,0,0,0,0,0,0,null,0]
[9,null,0,0,0,0,0,0,null,0]
[10,null,0,null,0,0,0,0,null,0]
[null,"Change Order subtotal:",{"$f":"SUM(C113:C122)","v":0},{"$f":"IF(C123=0,0,G123/C123)","v":0},{"$f":"SUM(E113:E122)","v":0},{"$f":"SUM(F113:F122)","v":0},{"$f":"SUM(G113:G122)","v":0},{"$f":"SUM(H113:H122)","v":0},null,{"$f":"SUM(J113:J122)","v":0}]
[null,"Contract amount:",{"$f":"C109+C123","v":3000000},{"$f":"IF(C124=0,0,G124/C124)","v":0},{"$f":"E109+E123","v":0},{"$f":"F109+F123","v":0},{"$f":"G109+G123","v":0},{"$f":"H109+H123","v":3000000}]
[]
["Issued Change Directives:",null,null,null,null,null,null,null,"Approved","Undisputed Amount",null,"Estimated CD Amount"]
[1,"CD title",{"$f":"IF(ISBLANK($I127),0,$J127)","v":0},0,0,{"$f":"G127-E127","v":0},{"$f":"ROUND(C127*D127,2)","v":0},{"$f":"C127-G127","v":0},null,0,null,0]
[2,null,{"$f":"IF(ISBLANK($I128),0,$J128)","v":0},0,0,0,{"$f":"ROUND(C128*D128,2)","v":0},0,null,0,null,0]
[3,null,0,0,0,0,0,0,null,0,null,0]
[4,null,0,0,0,0,0,0,null,0,null,0]
[5,null,0,0,0,0,0,0,null,0,null,0]
[6,null,0,0,0,0,0,0,null,0,null,0]
[7,null,0,0,0,0,0,0,null,0,null,0]
[8,null,0,0,0,0,0,0,null,0,null,0]
[9,null,0,0,0,0,0,0,null,0,null,0]
[10,null,0,null,0,0,0,0,null,0,null,0]
[null,"Change Directive subtotal:",{"$f":"SUM(C127:C136)","v":0},{"$f":"IF(C137=0,0,G137/C137)","v":0},{"$f":"SUM(E127:E136)","v":0},{"$f":"SUM(F127:F136)","v":0},{"$f":"SUM(G127:G136)","v":0},{"$f":"SUM(H127:H136)","v":0},null,{"$f":"SUM(J127:J136)","v":0},null,{"$f":"SUM(L127:L136)","v":0}]
[null,"Contract amount:",{"$f":"C124+C137","v":3000000},{"$f":"IF(C138=0,0,G138/C138)","v":0},{"$f":"E124+E137","v":0},{"$f":"F124+F137","v":0},0,3000000]
[]
[]
["Trial Certificate For Payment:",null,"-",null,{"$f":"IF(CertQualifier=\"-\", \"<-- Select certificate qualifier\",\"\")","v":"<-- Select certificate qualifier"}]
[null,null,{"$f":"C6","v":"Contract Amount"},"%\nto Date","Previous Amount","Amount\nThis Draw","Completed \nto Date","Balance\nto Complete"]
[null,"Sub Total",{"$f":"C54+C84+C99+C107+C123+C137","v":3000000},{"$f":"IF(C143=0,0,G143/C143)","v":0},{"$f":"E54+E84+E99+E107+E123+E137","v":0},0,0,3000000,"asdf"]
[null,{"$f":"'Project Info'!$C$42&\" at \"&$D158*100&\"%\"","v":"HST at 13%"},{"$f":"ROUND(C143*$D$158,2)","v":390000}]
[null,"Total Contract",{"$f":"SUM(C143:C144)","v":3390000}]
[]
[null,null,"Deficiency retainage"]
[null,null,"Basic holdback of",{"$f":"'Project Info'!C37","v":0.1},null,null,{"$f":"IF($F$174=\"Substantially performed\",ROUND($H$176*$D$148,2),ROUND(WorkFinished*$D$148,2))","v":0}]
[null,null,"Finishing holdback of",{"$f":"'Project Info'!C38","v":0.1},null,null,{"$f":"IF($H$176=0,0,ROUND((WorkFinished-$H$176)*$D$149,2))","v":0}]
[null,null,"Current work less holdbacks",null,null,null,{"$f":"G143-G147-G148-G149","v":0}]
[]
[null,null,"Holdback previously released",null,null,0]
[null,null,"Holdback released this issue",null,null,null,null,{"$f":"HbCurRel","v":0}]
[null,null,"Total holdback released",null,null,null,{"$f":"F152+F153","v":0}]
[null,null,"Payable to date",null,null,null,{"$f":"G150+G154","v":0}]
[null,null,"Previously payable  (from payable to date on previous certificate)",null,null,null,null,{"$f":"IF(ISBLANK(G156),\"<-enter value\",IF(ROUND($F$143*0.9,2)=$G$157,\" - \",\"Check previously payable amount.\"))","v":"<-enter value"}]
[null,null,"Payable this issue",null,null,null,{"$f":"G155-G156","v":0}]
[null,null,{"$f":"'Project Info'!$C$42&\" payable\"","v":"HST payable"},{"$f":"'Project Info'!$C$41","v":0.13},null,null,{"$f":"ROUND(G157*D158,2)","v":0}]
[null,null,null,null,null,"Total:",{"$f":"G157+G158","v":0}]
[null,null,null,null,null,"Adjustment to match invoice:",0]
[null,null,null,null,null,"Total payable:",{"$f":"G159+G160","v":0}]
[]
[]
["Trial Certificate of Substantial Performance:",null,null,null,{"$f":"\"Based on the \"&Lookups!$AE$30","v":"Based on the Construction Act, Ontario"},null,null,"yyyy-mm-dd"]
[null,"Initial Contract Amount",{"$f":"'Project Info'!$C$30","v":1234567.8899999999},null,null,{"$f":"Lookups!U30&\":\"","v":"Date of Publication:"}]
[null,"Revised Contract Amount",{"$f":"IF(C$143=0,C$165,C$143)","v":3000000},null,null,"Lien Period:",{"$f":"Lookups!N30","v":60},"days"]
[null,{"$f":"Lookups!$O$30*100&\"% on 1st $\"&Lookups!$P$30","v":"3% on 1st $1000000"},{"$f":"IF(C166>Lookups!$P$30,Lookups!$P$30,C166)","v":1000000},{"$f":"Lookups!$O$30","v":0.03},{"$f":"ROUND($C167*$D167,2)","v":30000},"Expiry of Lien Period:",null,{"$f":"IF(ISBLANK(H165),\"\",H165+G166)","v":""}]
[null,{"$f":"Lookups!$Q$30*100&\"% on next $\"&Lookups!$R$30","v":"2% on next $1000000"},{"$f":"IF(C166>Lookups!$P$30+Lookups!$R$30,Lookups!$R$30,C166-C167)","v":1000000},{"$f":"Lookups!$Q$30","v":0.02},{"$f":"ROUND($C168*$D168,2)","v":20000},null,null,{"$f":"IF(ISBLANK(H165),\"\",LOOKUP(WEEKDAY(H167),DOW))","v":""}]
[null,{"$f":"Lookups!$S$30*100&\"% on remainder\"","v":"1% on remainder"},{"$f":"IF(D169=0,0,IF(C166>Lookups!$P$30+Lookups!$R$30,C166-C167-C168,0))","v":1000000},{"$f":"Lookups!$S$30","v":0.01},{"$f":"ROUND($C169*$D169,2)","v":10000},"Release of Holdback:",null,{"$f":"IF(ISBLANK(H165),\"\",H165+G166+1)","v":""}]
[null,"Maximum outstanding per lien act",null,null,{"$f":"SUM(E167:E169)","v":60000},null,null,{"$f":"IF(ISBLANK(H165),\"\",LOOKUP(WEEKDAY(H169),DOW))","v":""}]
[]
[null,"Balance to complete per Schedule of Values",null,null,{"$f":"H143","v":3000000},{"$f":"IF(E172<0.01,Lookups!AC30,IF(E170>E172, \"Substantially performed before deferals\", \"Not Substantially performed before deferals\"))","v":"Not Substantially performed before deferals"}]
[null,"Amount agreed to be deferred"]
[null,"Adjusted Balance to Complete",null,null,{"$f":"E172-E173","v":3000000},{"$f":"IF(E174<0.01,Lookups!AC30,IF(E170>E174,\"Substantially performed\",\"Not Substantially performed\"))","v":"Not Substantially performed"}]
[null,"Margin",null,null,{"$f":"E170-E174","v":-2940000},{"$f":"IF($F$174=\"Substantially performed\",\"Enter the value of the work completed to date (Amount this Draw) at substantial performance:\",\"Leave blank until substantially performed:\")","v":"Leave blank until substantially performed:"}]
[null,"Sliding percentage:",null,{"$f":"IF(C166=0,0,SUM(E167:E169)/C166)","v":0.02},null,null,null,0]
[]
[]
[{"$f":"\"Holdback Released after \"&Lookups!U30 &\" of \" &Lookups!V30 &\": \"","v":"Holdback Released after Date of Publication of Certificate of Substantial Performance: "}]
[null,"Revised Contract Amount",{"$f":"IF(C$143=0,C$165,C$143)","v":3000000}]
[null,"A1 Basic holdback:",{"$f":"IF($H$176=0,ROUND($D$181*$G$181,2),ROUND($D$181*$H$176,2))","v":0},{"$f":"D148","v":0.1},{"$f":"IF($F$174=\"Substantially performed\",\"of the value of work completed at substantial performance.\",\"of the value of work completed to date. \")","v":"of the value of work completed to date. "},null,{"$f":"IF($H$176=0,G$143,$H$176)","v":0}]
[null,"A2 Finishing holdback:",{"$f":"ROUND((WorkFinished-$H$176)*D182,2)","v":0},{"$f":"IF($H$176=0,0,D149)","v":0},{"$f":"IF($H$176=0,\"\",\"of the value of work completed after substantial.\")","v":""}]
[null,null,{"$f":"C181+C182","v":0}]
[null,"B  Previously released:",{"$f":"F$152","v":0}]
[null,"C Holdback remaining:",{"$f":"C183-C184","v":0}]
[]
[]
[null,"Balance to Complete per schedule of values",null,null,{"$f":"H$143","v":3000000}]
[]
[]
[{"$f":"\"Trial \" &Lookups!AA30 &\":\"","v":"Trial Deemed Completion:"},null,null,null,{"$f":"\"Based on the \"&Lookups!$AE$30","v":"Based on the Construction Act, Ontario"},null,null,"yyyy-mm-dd"]
[null,"Revised Contract Amount",{"$f":"IF(C143=0,C165,C143)","v":3000000},null,null,{"$f":"\"Date \"&Lookups!$AD$30&\": \"","v":"Date Deemed Complete: "}]
[null,"A  % of contract amount",null,{"$f":"Lookups!$Y$30","v":0.01},{"$f":"ROUND(C192*D193,2)","v":30000},"Lien Period:",{"$f":"Lookups!X30","v":60},"days"]
[null,{"$f":"\"B  \" & Act","v":"B  Construction Act, Ontario"},null,null,{"$f":"Lookups!$Z$30","v":5000},"Expiry of Lien Period:",null,{"$f":"IF(ISBLANK(H192),\"\",H192+G193)","v":""}]
[null,{"$f":"IF(TRIM(Province)=\"Ontario\",\"  (Section 2 subsection (3) limit)\",\"\")","v":"  (Section 2 subsection (3) limit)"},null,null,null,null,null,{"$f":"IF(ISBLANK(H192),\"\",LOOKUP(WEEKDAY(H194),DOW))","v":""}]
[null,"Maximum outstanding per lien act (lesser of A and B)",null,null,{"$f":"IF(E193>E194,E194,E193)","v":5000},{"$f":"\"Release of \" &Lookups!AB30 &\":\"","v":"Release of Finishing Holdback:"},null,{"$f":"IF(ISBLANK(H192),\"\",H192+G193+1)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H192),\"\",LOOKUP(WEEKDAY(H196),DOW))","v":""}]
[null,"Balance to Complete per schedule of values",null,null,{"$f":"IF(D193=0,0,H143)","v":3000000},{"$f":"IF(D193=0,\"Not Applicable\",IF(E196>E198,Lookups!$AD$30,\"Not \"&Lookups!$AD$30))","v":"Not Deemed Complete"}]
[null,null,null,null,null,null,null,{"$f":"'Project Info'!$L$1","v":"Rev. 2019 01"}]

{"sheet":"Certificates For Payment","index":4,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,0,13,9],[20,1,20,4],[20,7,20,9],[23,7,23,9],[18,0,18,4],[18,7,18,9],[14,0,14,9],[16,0,16,9]]}
[{"$f":"'Project Info'!C24","v":"Visionary Architects"},null,null,null,null,null,null,"Certificate for Payment",null,null,null,null,"template",{"$f":"IF($M$1=\"Template\",\"App For Payment-\" & $M$1, IF($M$1<10,\"App For Payment-0\" & $M$1,\"App For Payment-\" & $M$1))","v":"App For Payment-template"},"Enter the number of the Application for Payment for which you want to show the Certificate for Payment:"]
[{"$f":"'Project Info'!C25","v":"Address line 1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$1=\"Template\",\"StartDate\", IF($M$1<2,\"StartDate\",IF($M$1<11,\"App For Payment-0\" & $M$1-1,\"App For Payment-\" & $M$1-1)))","v":"StartDate"}]
[{"$f":"'Project Info'!C26","v":"Address line 2"}]
[{"$f":"\"Tel: \" & 'Project Info'!C27 & \"     Fax: \" &  'Project Info'!C28","v":"Tel: (999) 123-4567     Fax: (000) 987-6543"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":141}]
["Project:",null,{"$f":"'Project Info'!C22","v":"Award Winner"},null,null,null,null,"Certificate for Payment:",{"$f":"$M$1","v":"template"},null,null,null,null,{"$f":"ADDRESS(N5,N4,4,1)","v":"C141"}]
["Project Number:",null,{"$f":"'Project Info'!C21","v":"18.32001.00"},null,null,null,null,{"$f":"IF(INDIRECT(\"'\"& $N$1 & \"'\" & \"!CertQualifier\")=\"-\",\"Select Certificate qualifier in cell \" & $N$6 & \" on the AfP tab before printing this certificate.\",INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":"Select Certificate qualifier in cell C141 on the AfP tab before printing this certificate."}]
["Owner:",null,{"$f":"'Project Info'!C16","v":"Favourite Client Company"},null,null,null,null,"Issue Date:",{"$f":"TEXT(INDIRECT(\"'\"& $N$1 & \"'\" &\"!IssueDate\"), \"YYYY MM DD\")","v":"2020 05 07"}]
[null,null,{"$f":"'Project Info'!C17","v":"Client Address 1"}]
[null,null,{"$f":"'Project Info'!C18","v":"Client Address 2"}]
[]
["Attention:",null,{"$f":"'Project Info'!C19","v":"Favourite Person"},null,null,null,null,"File:"]
[]
[{"$f":"\"This is to certify that \"&'Project Info'!C29&\" has completed work and delivered products to the place of the work to date, to the value of \"&TEXT(E31,\"$#,##0.00\")&\" and is entitled to \"&TEXT(H43,\"$#,##0.00\")&\" for the period from \" & TEXT( INDIRECT($N$2), \"MMMM DD, YYYY\")&\" to \"&TEXT( INDIRECT(\"'\"&$N$1&\"'\"&\"!PeriodEnding\"),\"MMMM DD, YYYY\")&\".\"","v":"This is to certify that Quality Contractors Inc. has completed work and delivered products to the place of the work to date, to the value of $0.00 and is entitled to $0.00 for the period from July 01, 2018 to July 31, 2018."}]
["By law, the amount certified is subject to reduction by the amount of any lien of which you have received written notice. The certificate is not negotiable, and is payable to the payee named in it. Issuance, payment, and acceptance are without prejudice to any rights of the Owner or Contractor under their contract."]
[]
["The issue of this Certificate for Payment shall not be taken as a representation that the Consultant has made any examination to ascertain how and for what purpose the Contractor has used monies paid on account of the contract or that the Contractor has discharged the obligations imposed on him/her by law under the Worker's Compensation Act, or other applicable statutes, non-compliance with which may render the Client personaly liable for the Contractor's default."]
[]
[{"$f":"'Project Info'!C24","v":"Visionary Architects"},null,null,null,null,null,null,{"$f":"'Project Info'!C29","v":"Quality Contractors Inc."}]
[]
["Per:"]
["Consultant's Signature:",null,null,null,null,null,null,"Contractor's Acknowledgement"]
[]
[]
[null,null,null,null,null,null,null,"Date"]
[]
[]
["Original Contract Amount",null,null,null,{"$f":"'Project Info'!$C$30","v":1234567.8899999999}]
["Total Changes to Date",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!ChangesToDate\")","v":0}]
["Current Contract Amount",null,null,null,{"$f":"E28+E29","v":1234567.8899999999},null,null,{"$f":"E30","v":1234567.8899999999}]
["Value of Work Finished",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!WorkFinished\")","v":0}]
["Deficiency Retainage",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!DeficiencyRetainage\")","v":0}]
[{"$f":" \"Statutory Holdback (basic) @ \" & TEXT('Project Info'!C37*100,\"#0\") & \" %\"","v":"Statutory Holdback (basic) @ 10 %"},null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!StatHoldback\")","v":0}]
[{"$f":" \"Statutory Holdback (finishing) @ \" & TEXT('Project Info'!C38*100,\"#0\") & \" %\"","v":"Statutory Holdback (finishing) @ 10 %"},null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!StatFinHoldback\")","v":0}]
["Current Work less Holdbacks",null,null,null,{"$f":"E31-E32-E33-E34","v":0},null,null,{"$f":"E35","v":0}]
["Holdback Previously Released",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!HbPrevRel\")","v":0}]
["Holdback Released This Issue",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!HbCurRel\")","v":0}]
["Total Holdback Released",null,null,null,{"$f":"E36+E37","v":0},null,null,{"$f":"E38","v":0}]
["Payable to Date",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!PayableToDate\")","v":0}]
["Less Previously Payable",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!PreviouslyPayable\")","v":0}]
["Payable This Issue",null,null,null,null,null,null,{"$f":"H39-H40","v":0}]
[{"$f":"\"Applicable Taxes for Place of the Work \" & 'Project Info'!C42 & \" @ \" & TEXT('Project Info'!C41*100,\"#0\") & \" %\"","v":"Applicable Taxes for Place of the Work HST @ 13 %"},null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!TaxesThisIssue\")","v":0}]
["Total Payable This Issue",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!TotalPayable\")","v":0}]

{"sheet":"Cert For Pay (Annual or Phased)","index":5,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,7,23,9],[13,0,13,9],[14,0,14,9],[16,0,16,9],[18,0,18,4],[18,7,18,9],[20,1,20,4],[20,7,20,9]]}
[{"$f":"'Project Info'!C24","v":"Visionary Architects"},null,null,null,null,null,null,"Certificate for Payment",null,null,null,null,"template",{"$f":"IF($M$1=\"Template\",\"App For Payment-\" & $M$1, IF($M$1<10,\"App For Payment-0\" & $M$1,\"App For Payment-\" & $M$1))","v":"App For Payment-template"},"Enter the number of the Application for Payment for which you want to show the Certificate for Payment:"]
[{"$f":"'Project Info'!C25","v":"Address line 1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($M$1=\"Template\",\"StartDate\", IF($M$1<2,\"StartDate\",IF($M$1<11,\"App For Payment-0\" & $M$1-1,\"App For Payment-\" & $M$1-1)))","v":"StartDate"}]
[{"$f":"'Project Info'!C26","v":"Address line 2"}]
[{"$f":"\"Tel: \" & 'Project Info'!C27 & \"     Fax: \" &  'Project Info'!C28","v":"Tel: (999) 123-4567     Fax: (000) 987-6543"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":141}]
["Project:",null,{"$f":"'Project Info'!C22","v":"Award Winner"},null,null,null,null,"Certificate for Payment:",{"$f":"$M$1","v":"template"},null,null,null,null,{"$f":"ADDRESS(N5,N4,4,1)","v":"C141"}]
["Project Number:",null,{"$f":"'Project Info'!C21","v":"18.32001.00"},null,null,null,null,{"$f":"IF(INDIRECT(\"'\"& $N$1 & \"'\" & \"!CertQualifier\")=\"-\",\"Select Certificate qualifier in cell \" & $N$6 & \" on the AfP tab before printing this certificate.\",INDIRECT(\"'\"& $N$1 & \"'\" &\"!CertQualifier\"))","v":"Select Certificate qualifier in cell C141 on the AfP tab before printing this certificate."}]
["Owner:",null,{"$f":"'Project Info'!C16","v":"Favourite Client Company"},null,null,null,null,"Issue Date:",{"$f":"TEXT(INDIRECT(\"'\"& $N$1 & \"'\" &\"!IssueDate\"), \"YYYY MM DD\")","v":"2020 05 07"}]
[null,null,{"$f":"'Project Info'!C17","v":"Client Address 1"}]
[null,null,{"$f":"'Project Info'!C18","v":"Client Address 2"}]
[]
["Attention:",null,{"$f":"'Project Info'!C19","v":"Favourite Person"},null,null,null,null,"File:"]
[]
[{"$f":"\"This is to certify that \"&'Project Info'!C29&\" has completed work and delivered products to the place of the work to date, to the value of \"&TEXT(E31,\"$#,##0.00\")&\" and is entitled to \"&TEXT(H42,\"$#,##0.00\")&\" for the period from \" & TEXT( INDIRECT($N$2), \"MMMM DD, YYYY\")&\" to \"&TEXT( INDIRECT(\"'\"&$N$1&\"'\"&\"!PeriodEnding\"),\"MMMM DD, YYYY\")&\".\"","v":"This is to certify that Quality Contractors Inc. has completed work and delivered products to the place of the work to date, to the value of $0.00 and is entitled to $0.00 for the period from July 01, 2018 to July 31, 2018."}]
["By law, the amount certified is subject to reduction by the amount of any lien of which you have received written notice. The certificate is not negotiable, and is payable to the payee named in it. Issuance, payment, and acceptance are without prejudice to any rights of the Owner or Contractor under their contract."]
[]
["The issue of this Certificate for Payment shall not be taken as a representation that the Consultant has made any examination to ascertain how and for what purpose the Contractor has used monies paid on account of the contract or that the Contractor has discharged the obligations imposed on him/her by law under the Worker's Compensation Act, or other applicable statutes, non-compliance with which may render the Client personaly liable for the Contractor's default."]
[]
[{"$f":"'Project Info'!C24","v":"Visionary Architects"},null,null,null,null,null,null,{"$f":"'Project Info'!C29","v":"Quality Contractors Inc."}]
[]
["Per:"]
["Consultant's Signature:",null,null,null,null,null,null,"Contractor's Acknowledgement"]
[]
[]
[null,null,null,null,null,null,null,"Date"]
[]
[]
["Original Contract Amount",null,null,null,{"$f":"'Project Info'!$C$30","v":1234567.8899999999}]
["Total Changes to Date",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!ChangesToDate\")","v":0}]
["Current Contract Amount",null,null,null,{"$f":"E28+E29","v":1234567.8899999999},null,null,{"$f":"E30","v":1234567.8899999999}]
["Value of Work Finished",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!WorkFinished\")","v":0}]
["Deficiency Retainage",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!DeficiencyRetainage\")","v":0}]
[{"$f":" \"Statutory Holdback  @ \" & TEXT('Project Info'!C38*100,\"#0\") & \" %\"","v":"Statutory Holdback  @ 10 %"},null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!StatFinHoldback\")","v":0}]
["Current Work less Holdbacks",null,null,null,{"$f":"E31-E32-E33","v":0},null,null,{"$f":"E34","v":0}]
["Holdback Previously Released",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!HbPrevRel\")","v":0}]
["Holdback Released This Issue",null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!HbCurRel\")","v":0}]
["Total Holdback Released",null,null,null,{"$f":"E35+E36","v":0},null,null,{"$f":"E37","v":0}]
["Payable to Date",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!PayableToDate\")","v":0}]
["Less Previously Payable",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!PreviouslyPayable\")","v":0}]
["Payable This Issue",null,null,null,null,null,null,{"$f":"H38-H39","v":0}]
[{"$f":"\"Applicable Taxes for Place of the Work \" & 'Project Info'!C42 & \" @ \" & TEXT('Project Info'!C41*100,\"#0\") & \" %\"","v":"Applicable Taxes for Place of the Work HST @ 13 %"},null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!TaxesThisIssue\")","v":0}]
["Total Payable This Issue",null,null,null,null,null,null,{"$f":"INDIRECT(\"'\"& $N$1 & \"'\" &\"!TotalPayable\")","v":0}]

{"sheet":"Lookups","index":6,"n_rows":101,"n_cols":32,"rows_kept":101,"cut":false,"hidden":false,"merged":[[46,8,46,9],[26,26,26,29],[16,10,16,11],[26,14,26,19],[26,8,26,13],[26,22,26,25],[26,20,26,21]]}
[]
["Project location:",{"$f":"Province","v":" Ontario "}]
[null,null,null,null,null,null,"ProvinceList",null,null,null,"CfP_Purpose",null,null,null,"HB_Release"]
[null,null,null,null,null,null," Ontario ",null,null,null,"-",null,null,null,"-"]
[null,null,null,null,null,null," British Columbia ",null,null,null,"Progress Payment",null,null,null,"Substantial Performance"]
[null,null,null,null,null,null," Alberta ",null,null,null,"Substantial Performance",null,null,null,"Completion"]
[null,null,null,null,null,null," Saskatchewan ",null,null,null,"Release of Basic Holdback",null,null,null,"Annual Release"]
[null,null,null,null,null,null," Manitoba ",null,null,null,"Release of Finishing Holdback",null,null,null,"Phased Release"]
[null,null,null,null,null,null," Quebec",null,null,null,"Release of Holdback"]
["DOW","Name","Add to skip weekend",null,null,null," New Brunswick ",null,null,null,"Release of Holdback (Annual)"]
[1,"Sunday",1,null,null,null," Nova Scotia ",null,null,null,"Release of Holdback (Phased)"]
[2,"Monday",0,null,null,null," Prince Edward Island ",null,null,null,"Deemed Completion"]
[3,"Tuesday",0,null,null,null," Newfoundland ",null,null,null,"Completion"]
[4,"Wednesday",0,null,null,null," Yukon ",null,null,null,"Achevement substantiel de l'ouvrage"]
[5,"Thursday",0,null,null,null," Nunavut "]
[6,"Friday",0,null,null,null," Northwest Territory "]
[7,"Saturday",2,null,null,null,null,null,null,null,"Deemed Completion"]
[]
[]
[null,null,null,"GST",0.05]
[null,null,null,"QST",9.5000000000000001E-2]
[null,null,null,"QST_Blended",{"$f":"((1+E20)*(1+E21)-1)","v":0.14975000000000005}]
[]
["The information in this table must be manually updated to reflect any changes in the applicable lien legislation or tax rates."]
["The information was valid when first entered, but must be confirmed in each jurisdiction prior to use for that jurisdiction."]
[]
[null,null,null,null,null,null,null,null,"Calculation of Basic Holdback",null,null,null,null,null,"Calculation of Substantial Performance",null,null,null,null,null,"Release of Basic Holdback",null,"Calculation of Finishing Holdback",null,null,null,"Release of Finishing Holdback"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Province/Territory","Location Selected","Prov Tax Type","Prov Tax Rate","VAT Tax Type","VAT Tax Rate","Tax Rate","Basic Holdback %","%","Change of Rate Threshold","%","Minimum Holdback @ Rate Change"," Lien Period ","%","Limit","%","Limit","%",null,"Lien Period Trigger","Document Issued/Status Achieved","Finishing Holdback ","Finishing Lien Period ","%","Limit of Outstanding Work","Lien Period Trigger",null,null,null,"Legislation","Comments"]
["Selected:",{"$f":"Province","v":" Ontario "},"X",{"$f":"VLOOKUP(\"X\",$C$31:$AF$44,D$28,FALSE)","v":0},0,"HST",0.13,0.13,0.1,0,0,1,0,60,0.03,1000000,0.02,1000000,0.01,0,"Date of Publication","Certificate of Substantial Performance",0.1,60,0.01,5000,"Deemed Completion","Finishing Holdback","Substantially Performed","Deemed Complete","Construction Act, Ontario",0]
["5 CLA"," Ontario ",{"$f":"IF(Province=$B31,IF(Act=$AE31,\"X\",\"\"),\"\")","v":""},null,null,{"$f":"IF(NOW()>DATE(2010,7,1),\"HST\",\"GST\")","v":"HST"},0.13,{"$f":"G31","v":0.13},0.1,null,null,1,null,45,0.03,500000,0.02,500000,0.01,null,"Date of Publication","Certificate of Substantial Performance",0.1,45,0.01,1000,"Deemed Completion","Finishing Holdback","Substantially Performed","Deemed Complete","Construction Lien Act, Ontario"]
["5 CA"," Ontario ",{"$f":"IF(Province=$B32,IF(Act=$AE32,\"X\",\"\"),\"\")","v":"X"},null,null,{"$f":"IF(NOW()>DATE(2010,7,1),\"HST\",\"GST\")","v":"HST"},0.13,{"$f":"G32","v":0.13},0.1,null,null,1,null,60,0.03,1000000,0.02,1000000,0.01,null,"Date of Publication","Certificate of Substantial Performance",0.1,60,0.01,5000,"Deemed Completion","Finishing Holdback","Substantially Performed","Deemed Complete","Construction Act, Ontario"]
[6," Quebec ",{"$f":"IF(Province=$B33,\"X\",\"\")","v":""},"QST",{"$f":"QST","v":9.5000000000000001E-2},"GST",{"$f":"GST","v":0.05},{"$f":"((1+G33)*(1+E33)-1)","v":0.14975000000000005},0.1,null,null,1,null,30,0.03,500000,0.02,500000,0.01,null,"Date of Issuance","Certificat d'achevement substantiel de l'ouvrage",0.1,30,0.01,1000,"Deemed Completion","Finishing Holdback","Substantially Performed","Deemed Complete","Civil Code Quebec article 2727","based on common practice"]
[1," British Columbia ","",null,null,{"$f":"IF(NOW()>DATE(2013,4,1),\"GST\",\"HST\")","v":"GST"},{"$f":"GST","v":0.05},{"$f":"G34","v":0.05},0.1,null,null,1,null,55,0,0,0,0,0,null,"Date of Issuance","Certificate of Completion",0,0,0,0,"No Finishing Holdback","Holdback","Completed",null,"Builders Lien Act, BC "]
[2," Alberta ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,0.1,null,null,1,null,45,0.03,500000,0.02,500000,0.01,null,"Date of Issuance","Certificate of Substantial Performance",0.1,45,0,0,"Completion","Finishing Holdback","Substantially Performed","Complete","Builder's Lien Act, Alberta"]
[3," Saskatchewan ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,0.1,null,null,1,null,40,0.03,500000,0.02,500000,0.01,null,"Date of Issuance","Certificate of Substantial Performance",0.1,40,0.01,1000,"Deemed Completion","Finishing Holdback","Substantially Performed","Deemed Complete","Builders Lien Act, Saskatchewan"]
[4," Manitoba ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,7.4999999999999997E-2,null,null,1,null,40,0.03,250000,0.02,250000,0.01,null,"Date of Issuance","Certificate of Substantial Performance",7.4999999999999997E-2,40,0,0,"Completion","Finishing Holdback","Substantially Performed","Complete","The Builders' Liens Act, Manitoba"]
[7," New Brunswick ","",null,null,"HST",0.13,0.13,{"$f":"IF(Contract_Amount>=K38,IF($I$47<K38,J38,L38),J38)","v":0.2},0.2,15000,0.15,{"$f":"J38*K38","v":3000},60,0,0,0,0,0,null,"Date of Issuance","Certificate of Completion",0,0,0,0,"No Finishing Holdback","Holdback","Completed",null,"Mechanics' Lien Act, New Brunswick","$3,000 min or 20% if contract is < $15,000.00"]
[8," Nova Scotia ","",null,null,"HST",{"$f":"IF(NOW()>DATE(2010,7,1),0.15,0.13)","v":0.15},0.15,0.1,null,null,1,null,60,2.5000000000000001E-2,500000,2.5000000000000001E-2,500000,2.5000000000000001E-2,null,"Date of Issuance","Certificate of Substantial Performance",2.5000000000000001E-2,60,0,0,"Completion","Finishing Holdback","Substantially Performed","Complete","Builders Lien Act, Nova Scotia","Finishing holdback is 2.5% of work done, not of work remaining"]
[9," Prince Edward Island ","",null,null,"HST",0.14000000000000001,0.14000000000000001,{"$f":"IF(Contract_Amount>=K40,IF($I$47<K40,J40,L40),J40)","v":0.2},0.2,15000,0.15,{"$f":"J40*K40","v":3000},60,0,0,0,0,0,null,"Date of Issuance","Certificate of Completion",0,0,0,0,"No Finishing Holdback","Holdback","Substantially Performed",null,"Mechanics' Lien Act, P.E.I.","$3,000 min or 20% if contract is < $15,000.00"]
[10," Newfoundland ","",null,null,"HST",0.13,0.13,0.1,null,null,1,null,30,0.03,250000,0.02,250000,0.01,null,"Date of Issuance","Certificate of Substantial Performance",0,0,0,0,"No Finishing Holdback","Holdback","Substantially Performed",null,"Mechanics' Lien Act, Newfoundland"]
[11," Yukon ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,0.1,null,null,1,null,30,0,0,0,0,0,null,"Date of Achievement","Completion",0,0,0,0,"No Finishing Holdback","Holdback","Completed",null,"Lien Act, Yukon"]
[12," Nunavut ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,0.1,null,null,1,null,45,0,0,0,0,0,null,"Date of Achievement","Completion",0,0,0,0,"No Finishing Holdback","Holdback","Completed",null,"Mechanics Lien, Nunavut"]
[13," Northwest Territory ","",null,null,"GST",{"$f":"GST","v":0.05},0.05,0.1,null,null,1,null,45,0,0,0,0,0,null,"Date of Achievement","Completion",0,0,0,0,"No Finishing Holdback","Holdback","Completed",null,"Lien Act, NWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert above this row"]
[]
[null,"Completed to date calculation for NB & PEI due to sliding scale of holdback percentages",null,null,null,null,null,null,{"$f":"MAX(O50:O97)","v":0}]
[]
[null,null,"Sheet name","Cert #","Named range",null,null,"Concatenation of cell address",null,null,null,null,null,null,null,"NB","PEI"]
[null,"Schedule of Values-","App For Payment-","01","'!WorkFinished",null,{"$f":" \"'\" &$C$50 & $D50 & $E$50","v":"'App For Payment-01'!WorkFinished"},null,null,null,null,null,{"$f":"INDIRECT(G50)","v":{"$error":"#REF!"}},null,{"$f":"IF(ISERR(M50),0,M50)","v":0},{"$f":"IF(Contract_Amount>=$K$38,IF($O50<=$K$38,$J$38,$L$38),$J$38)","v":0.2},{"$f":"IF(Contract_Amount>=$K$40,IF($O50<=$K$40,$J$40,$L$40),$J$40)","v":0.2}]
[null,null,null,"02",null,null,"'App For Payment-02'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,{"$f":"IF(ISERR(M51),0,M51)","v":0},0.2,0.2]
[null,null,null,"03",null,null,"'App For Payment-03'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"04",null,null,"'App For Payment-04'!WorkFinished",null,null,null,null,null,{"$f":"INDIRECT(G53)","v":{"$error":"#REF!"}},null,{"$f":"IF(ISERR(M53),0,M53)","v":0},0.2,0.2]
[null,null,null,"05",null,null,"'App For Payment-05'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"06",null,null,"'App For Payment-06'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"07",null,null,"'App For Payment-07'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"08",null,null,"'App For Payment-08'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"09",null,null,"'App For Payment-09'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"10",null,null,"'App For Payment-10'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"11",null,null,"'App For Payment-11'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"12",null,null,"'App For Payment-12'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"13",null,null,"'App For Payment-13'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"14",null,null,"'App For Payment-14'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"15",null,null,"'App For Payment-15'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"16",null,null,"'App For Payment-16'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"17",null,null,"'App For Payment-17'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"18",null,null,"'App For Payment-18'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"19",null,null,"'App For Payment-19'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"20",null,null,"'App For Payment-20'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"21",null,null,"'App For Payment-21'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"22",null,null,"'App For Payment-22'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"23",null,null,"'App For Payment-23'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"24",null,null,"'App For Payment-24'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"25",null,null,"'App For Payment-25'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"26",null,null,"'App For Payment-26'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"27",null,null,"'App For Payment-27'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"28",null,null,"'App For Payment-28'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"29",null,null,"'App For Payment-29'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"30",null,null,"'App For Payment-30'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"31",null,null,"'App For Payment-31'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"32",null,null,"'App For Payment-32'!WorkFinished",null,null,null,null,null,{"$f":"INDIRECT(G81)","v":{"$error":"#REF!"}},null,{"$f":"IF(ISERR(M81),0,M81)","v":0},0.2,0.2]
[null,null,null,"33",null,null,"'App For Payment-33'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"34",null,null,"'App For Payment-34'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"35",null,null,"'App For Payment-35'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"36",null,null,"'App For Payment-36'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"37",null,null,"'App For Payment-37'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"38",null,null,"'App For Payment-38'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"39",null,null,"'App For Payment-39'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"40",null,null,"'App For Payment-40'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"41",null,null,"'App For Payment-41'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"42",null,null,"'App For Payment-42'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"43",null,null,"'App For Payment-43'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"44",null,null,"'App For Payment-44'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"45",null,null,"'App For Payment-45'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"46",null,null,"'App For Payment-46'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"47",null,null,"'App For Payment-47'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"48",null,null,"'App For Payment-48'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"49",null,null,"'App For Payment-49'!WorkFinished",null,null,null,null,null,{"$f":"INDIRECT(G98)","v":{"$error":"#REF!"}},null,{"$f":"IF(ISERR(M98),0,M98)","v":0},0.2,0.2]
[null,null,null,"50",null,null,"'App For Payment-50'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"51",null,null,"'App For Payment-51'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]
[null,null,null,"52",null,null,"'App For Payment-52'!WorkFinished",null,null,null,null,null,{"$error":"#REF!"},null,0,0.2,0.2]

{"sheet":"Sheet1","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["DOW","Name","Add to skip weekend"]
[1,"Sunday",1]
[2,"Monday",0]
[3,"Tuesday",0]
[4,"Wednesday",0]
[5,"Thursday",0]
[6,"Friday",0]
[7,"Saturday",2]