{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["G702","G703","Instructions","Sprinks","Alarms","ChequeList","Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":5,"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":"G702","index":0,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[32,8,32,12],[24,6,25,7],[24,8,25,13]]}
["APPLICATION AND CERTIFICATION FOR PAYMENT",null,null,null,null,null,"AIA DOCUMENT G702",null,null," "," ",null,"Rev: ","2019-02-10"]
[]
["TO CONTRACTOR:",null,null,"PROJECT:","La Caille Phase I",null,null,"APPLICATION NO:",0,null,"Distribution to:"]
[]
[null,null,"Milestone",null,"9565 South Wasatch Blvd",null,null,null,null,null,null,"OWNER"]
[]
[null,null,"1883 E 9400 S",null,"Sandy UT 84092-6009",null,null,"APPLICATION DATE:","2020-12-01",null,null,"ARCHITECT"]
[]
[null,null,"Sandy UT 84093",null,null,null,null,"PERIOD ENDNG:",{"$f":"+I7","v":"2020-12-01"},null,null,"CONTRACTOR"]
[]
["FROM SUBCONTRACTOR:",null,null,"VIA ARCHITECT:","Lu'na"]
[]
[null,null,"Fire Suppression Services Incorporated",null,"175 W 200 E #2020",null,null,"Contract Date","2020-11-01"]
[]
[null,null,"3802 South 2300 East",null,"SLC UT 84101",null,null,"Start Date","2020-12-10"]
[null,null,"Milcreek UT 84109",null,"(801) 350-2046",null,null,"CONTRACT NUMBER:","20YY-####"]
["CONTRACT FOR: ",null,"Div-21 Fire Suppression -Sprinklers",null,null,null,null,"Invoice Number",null,"Need number"]
[]
["CONTRACTOR'S APPLICATION FOR PAYMENT",null,null,null,null,null,"The undersigned Subcontractor certifies that to the best of the Subcontractor's knowledge, "]
["Application is made for payment, as shown below, in connection with the Contract.",null,null,null,null,null,"information and belief the Work covered by this Application for Payment has been"]
["Continuation Sheet, AIA Document G703, is attached.",null,null,null,null,null,"completed in accordance with the Subcontract Documents, that all amounts have been paid by "]
[" ",null,null,null,null,null,"the Subcontractor for Work for which previous Certificates for Payment were issued and "]
[" ",null,null,null,null,null,"payments received from the Contractor, and that current payment shown herein is now due."]
[]
["1.  ORIGINAL CONTRACT SUM ",null,null," $",{"$f":"4000+1500","v":5500},null,"Subcontractor:",null,"Fire Suppression Services Incorporated"]
["2.  Net change by Change Orders ",null,null," $",{"$f":"+D53","v":0}]
["3.  CONTRACT SUM TO DATE (Line 1 ± 2)                                        $",null,null,"$",{"$f":"SUM(E25:E26)","v":5500}]
["4.  TOTAL COMPLETED & STORED TO",null,null,"$",{"$f":"'G703'!K91","v":0},null,"By:",null,null,null," Date:"]
["         DATE       (Column G on G703)",null,null,null,null,null,"State of: ",null,null,"County of: "]
["5.  RETAINAGE:",null,null,null,null,null,"Subscribed and sworn to before me this ___________ day of  ___________ 2015"]
["a.",0," of Completed Work",{"$f":"'G703'!H94+'G703'!I94","v":0},{"$f":"+D31*B31","v":0}]
[null,"(Column D + E on G703)",null,null,null,null,"Notary Public:  _______________________________________________________________"]
["b.",0.05," of Stored Material",{"$f":"'G703'!J94","v":0},{"$f":"+D33*B33","v":0}]
[null,"(Column F on G703)"]
["           Total Retainage (Lines 5a + 5b or",null,null,null,{"$f":"+E31+E33","v":0},null,"My Commission expires:"]
[null,"Total in Column I of G703) ",null,"$",{"$f":"'G703'!N91","v":0},null,"CONTRACTORS CERTIFICATE FOR PAYMENT"]
["6.  TOTAL EARNED LESS RETAINAGE ",null,null,"$",{"$f":"IF(E36<E35,E28-E36,E28-E35)","v":0},null,"In accordance with the Contract Documents, based on on-site observations and the data"]
[null,"(Line 4 Less Line 5 Total)",null,null,null,null,"comprising the application, the Contractor certifies to the Owner that to the best of  the"]
["7.  LESS PREVIOUS CERTIFICATES FOR",null,null,null,null,null,"Contractor's knowledge, information and belief the Work has progressed as indicated,"]
["     PAYMENT (Line 6 from prior Certificate) ",null,null,"$",null,null,"the quality of the Work is in accordance with the Contract Documents, and the Subcontractor"]
["8.  CURRENT PAYMENT DUE ",null,null,"$",{"$f":"E37-E40","v":0},null,"is entitled to payment of the AMOUNT CERTIFIED."]
["9.  BALANCE TO FINISH, INCLUDING RETAINAGE",null,null,"$",0]
[null,"(Line 3 less Line 6)",null,null,null,null,"AMOUNT CERTIFIED . . . . . . . . . . . $"]
[]
["CHANGE ORDER SUMMARY",null,null,"ADDITIONS","DEDUCTIONS",null,"(Attach explanation if amount certified differs from the amount applied. Initial all figures on this"]
["     Total changes approved",null,null,null,null,null,"Application and on the Continuation Sheet that are changed to conform with the amount certified.)"]
["     in previous months by Owner",null,null,0,0,null,"CONTRACTOR"]
[]
["     Total approved this Month",null,null,0,0,null,"By:",null,null,null," Date:"]
[]
["     TOTALS",null,null,{"$f":"D47+D49","v":0},{"$f":"E47+E49","v":0},null,"This Certificate is not negotiable.  The AMOUNT CERTIFIED is payable only to the "]
[null,null,null,null,null,null,"Subcontractor named herein. Issuance, payment and acceptance of payment are without "]
["     NET CHANGES by Change Order",null,null,{"$f":"D51-E51","v":0},null,null,"prejudice to any rights of the Owner or Contractor under this Contract."]
[]
["AIA DOCUMENT G702 · APPLICATION AND CERTIFICATION FOR PAYMENT · 1992 EDITION · AIA  · ©1992",null,null,null,null,null,"THE AMERICAN INSTITUTE OF ARCHITECTS, 1735 NEW YORK AVE., N.W., WASHINGTON, DC 20006-5292",null,null,null,null,null,null,null," "]
["Users may obtain validation of this document by requesting a completed AIA Document D401 - Certification of Document's Authenticity from the Licensee.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+\"Rev: \"&TEXT(N1,\"yyyy-mm-dd;;;\")","v":"Rev: 2019-02-10"}]

{"sheet":"G703","index":1,"n_rows":112,"n_cols":15,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[null,"CONTINUATION SHEET",null,null,null,null,null,null,"AIA DOCUMENT G703"]
[]
[null,"AIA Document G702, APPLICATION AND CERTIFICATION FOR PAYMENT, containing",null,null,null,null,null,null,null,null,null,"APPLICATION NO:",{"$f":"'G702'!I3","v":0}]
[null,"Contractor's signed certification is attached.",null,null,null,null,null,null,"Bid Date:","2019-02-01",null,"APPLICATION DATE:",{"$f":"'G702'!I7","v":"2020-12-01"}]
[null,"In tabulations below, amounts are stated to the nearest dollar.",null,null,null,null,null,null,"Contract Date:",{"$f":"+'G702'!I13","v":"2020-11-01"},null,"PERIOD ENDING:",{"$f":"'G702'!I9","v":"2020-12-01"}]
[null,"Use Column I on Contracts where variable retainage for line items may apply.",null,null,null,null,{"$f":"+'G702'!B31","v":0},null,"Start Date:",{"$f":"+'G702'!I15","v":"2020-12-10"},null,"CONTRACT NUMBER:",{"$f":"'G702'!I16","v":"20YY-####"}]
[null,null,null,null,null,null,null,null,"End Date:",{"$f":"+J6+25","v":"2021-01-04"},null,"INVOICE#:",{"$f":"+'G702'!I17","v":0}]
[null,"A","B",null,null,null,"C","D","E","F","G",null,"H","I"]
[null,"ITEM","DESCRIPTION OF WORK",null,null,null,"SCHEDULED","WORK COMPLETED",null,"MATERIALS","TOTAL","%","BALANCE","RETAINAGE"]
[null,"NO.",{"$f":"IF('G702'!I17<1,\"see G702 Invoice number\",\"Inv#: \" &'G702'!I17)","v":"see G702 Invoice number"},null,null,null,"VALUE","FROM PREVIOUS","THIS PERIOD","PRESENTLY","COMPLETED","(G ÷ C)","TO FINISH","(IF VARIABLE"]
[null,null,null,null,null,null,null,"APPLICATION",null,"STORED","AND STORED",null,"(C - G)","RATE)"]
[null,null,null,null,null,null,null,"(D + E)",null,"(NOT IN","TO DATE"]
[null,null,null,null,null,null,null,null,null,"D OR E)","(D+E+F)"]
[null,{"$f":"+B13+1","v":1},"PRELIMINARYS"]
[null,{"$f":"+B14+1","v":2},null,"Bond",null,null,0,0,0,null,{"$f":"H15+I15+J15","v":0},{"$f":"IF(G15>0,K15/G15,0)","v":0},{"$f":"G15-K15","v":0},0,"No Retention"]
[null,{"$f":"+B15+1","v":3},null,"Design",null,null,{"$f":"2000+385+500","v":2885},0,0,null,{"$f":"H16+I16+J16","v":0},{"$f":"IF(G16>0,K16/G16,0)","v":0},{"$f":"G16-K16","v":2885},0,"No Retention"]
[null,4,null,"Submit",null,null,165,0,0,null,{"$f":"H17+I17+J17","v":0},0,{"$f":"G17-K17","v":165},0,"No Retention"]
[null,5,null,"Permit",null,null,200,0,0,null,{"$f":"H18+I18+J18","v":0},0,{"$f":"G18-K18","v":200},0,"No Retention"]
[null,6]
[null,7,null,"Printing / Drawings"]
[null,8,null,null,"Design-Submit stage",null,165,0,null,null,{"$f":"H21+I21+J21","v":0},{"$f":"IF(G21>0,K21/G21,0)","v":0},{"$f":"G21-K21","v":165},{"$f":"K21*$G$6","v":0}]
[null,9]
[null,10]
[null,11,"MOVEMENT"]
[null,12,null,"Mobilisation",null,null,0,0,0,null,{"$f":"H25+I25+J25","v":0},{"$f":"IF(G25>0,K25/G25,0)","v":0},{"$f":"G25-K25","v":0},{"$f":"K25*$G$6","v":0}]
[null,13,null,"Travel & Transport",null,null,0,0,0,null,0,0,0,0]
[null,14,null,"AWP",null,null,0,0,0,null,{"$f":"H27+I27+J27","v":0},{"$f":"IF(G27>0,K27/G27,0)","v":0},{"$f":"G27-K27","v":0},0]
[null,15,null,"Freight & Fuel",null,null,0,0,0,null,0,0,0,0]
[null,16,null,"Accommodation"]
[null,17,null,"DeMobilisation","see Finals section below"]
[null,18]
[null,19]
[null,20,"PARTS & MATERIALS"]
[null,21,null,"Riser"]
[null,22,null,null,"Parts",null,0,0,0,null,{"$f":"H35+I35+J35","v":0},{"$f":"IF(G35>0,K35/G35,0)","v":0},{"$f":"G35-K35","v":0},{"$f":"K35*$G$6","v":0}]
[null,23,null,null,"Dry + Trimmer",null,0,0,0,null,0,0,0,0]
[null,24,null,null,"Compressor-Riser Mount +AMD",null,0,0,0,null,0,0,0,0]
[null,25,null,null,"Head Box & Head Wrench",null,0,0,0,null,0,0,0,0]
[null,26,null,null,"BFP Strobe",null,0,0,0,null,0,0,0,0]
[null,27,null,"FDC"]
[null,28,null,null,"Parts-Plate Snoot Clappers",null,0,0,0,null,{"$f":"H41+I41+J41","v":0},{"$f":"IF(G41>0,K41/G41,0)","v":0},{"$f":"G41-K41","v":0},{"$f":"K41*$G$6","v":0}]
[null,29,null,null,"Knox Lock Cap/s",null,0,0,0,null,0,0,0,0]
[null,30,null,null,"Horn/Strobe",null,0,0,0,null,{"$f":"H43+I43+J43","v":0},{"$f":"IF(G43>0,K43/G43,0)","v":0},{"$f":"G43-K43","v":0},0]
[null,31,null,null,"Labour",null,0,0,0,null,{"$f":"H44+I44+J44","v":0},{"$f":"IF(G44>0,K44/G44,0)","v":0},{"$f":"G44-K44","v":0},0]
[null,32,null,null,null,null,0,0,0,null,0,0,0,0]
[null,33,null,"Ground Floor"]
[null,34,null,null,"Material",null,0,0,0,null,{"$f":"H47+I47+J47","v":0},{"$f":"IF(G47>0,K47/G47,0)","v":0},{"$f":"G47-K47","v":0},{"$f":"K47*$G$6","v":0}]
[null,35,null,null,"Labour",null,0,0,0,null,0,0,0,0]
[null,36,null,null,"Fabrication",null,0,0,0,null,0,0,0,0]
[null,37,null,"Attic Wet CPVC"]
[null,38,null,null,null,null,0,0,0,null,{"$f":"H51+I51+J51","v":0},{"$f":"IF(G51>0,K51/G51,0)","v":0},{"$f":"G51-K51","v":0},{"$f":"K51*$G$6","v":0}]
[null,39,null,null,null,null,0,0,0,null,0,0,0,0]
[null,40,null,null,null,null,0,0,0,null,0,0,0,0]
[null,41,null,null,null,null,0,0,0,null,{"$f":"H54+I54+J54","v":0},{"$f":"IF(G54>0,K54/G54,0)","v":0},{"$f":"G54-K54","v":0},0]
[null,42,null,null,null,null,0,0,0,null,0,0,0,0]
[null,43,null,"Attic Dry"]
[null,44,null,null,"Material",null,0,0,0,null,{"$f":"H57+I57+J57","v":0},{"$f":"IF(G57>0,K57/G57,0)","v":0},{"$f":"G57-K57","v":0},{"$f":"K57*$G$6","v":0}]
[null,45,null,null,"Labour",null,0,0,0,null,0,0,0,0]
[null,46,null,null,"Fabrication",null,0,0,0,null,0,0,0,0]
[null,47,null,null,null,null,0,0,0,null,0,0,0,0]
[null,48,"ANCILLIARY"]
[null,49,null,"Documentation/Publishing",null,null,0,0,0,null,{"$f":"H62+I62+J62","v":0},{"$f":"IF(G62>0,K62/G62,0)","v":0},{"$f":"G62-K62","v":0},{"$f":"K62*$G$6","v":0}]
[null,50,null,null,null,null,0,0,0,null,{"$f":"H63+I63+J63","v":0},{"$f":"IF(G63>0,K63/G63,0)","v":0},{"$f":"G63-K63","v":0},0]
[null,51,null,null,null,null,0,0,0,null,0,0,0,0]
[null,52]
[null,53,"EXTERNAL SUBS"]
[null,{"$f":"+B66+1","v":54},null,"Core Drilling, Remediation & Sleeves",null,null,0,0,0,null,{"$f":"H67+I67+J67","v":0},{"$f":"IF(G67>0,K67/G67,0)","v":0},{"$f":"G67-K67","v":0},{"$f":"K67*$G$6","v":0}]
[null,55,null,"Elecrical",null,null,0,0,0,null,{"$f":"H68+I68+J68","v":0},{"$f":"IF(G68>0,K68/G68,0)","v":0},{"$f":"G68-K68","v":0},0]
[null,56,null,"NICET Visits",null,null,0,0,0,null,{"$f":"H69+I69+J69","v":0},{"$f":"IF(G69>0,K69/G69,0)","v":0},{"$f":"G69-K69","v":0},0]
[null,57]
[null,58]
[null,59,"FINALS"]
[null,60,null,"Printing-Drawings-Manuals-Tags",null,null,0,0,0,null,{"$f":"H73+I73+J73","v":0},{"$f":"IF(G73>0,K73/G73,0)","v":0},{"$f":"G73-K73","v":0},{"$f":"K73*$G$6","v":0}]
[null,61,null,"Testing & Inspections Trip Test",null,null,0,0,0,null,{"$f":"H74+I74+J74","v":0},{"$f":"IF(G74>0,K74/G74,0)","v":0},{"$f":"G74-K74","v":0},{"$f":"K74*$G$6","v":0}]
[null,62,null,"Training",null,null,0,0,0,null,0,0,0,{"$f":"K75*$G$6","v":0}]
[null,63,null,"DeMobilisation",null,null,0,0,0,null,{"$f":"H76+I76+J76","v":0},{"$f":"IF(G76>0,K76/G76,0)","v":0},{"$f":"G76-K76","v":0},{"$f":"K76*$G$6","v":0}]
[null,64]
[null,65,"PROJECT MANAGEMENT"]
[null,66,null,null,null,null,0,0,0,null,{"$f":"H79+I79+J79","v":0},{"$f":"IF(G79>0,K79/G79,0)","v":0},{"$f":"G79-K79","v":0},{"$f":"K79*$G$6","v":0}]
[null,67,null,null,null,null,0,0,0,null,0,0,0,{"$f":"K80*$G$6","v":0}]
[null,68]
[null,69,"SCO-PCO-CCO"]
[null,70,null,"CCO-01",null,null,0,0,0,null,{"$f":"H83+I83+J83","v":0},{"$f":"IF(G83>0,K83/G83,0)","v":0},{"$f":"G83-K83","v":0},{"$f":"K83*$G$6","v":0}]
[null,71,null,"CCO-02",null,null,0,0,0,null,{"$f":"H84+I84+J84","v":0},{"$f":"IF(G84>0,K84/G84,0)","v":0},{"$f":"G84-K84","v":0},0]
[null,72,null,"CCO-03",null,null,0,0,0,null,0,0,0,0]
[null,73,null,"CCO-03",null,null,0,0,0,null,0,0,0,0]
[null,{"$f":"+B86+1","v":74},null,"CCO-04",null,null,0,0,0,null,0,0,0,0]
[null,75,null,"CCO-05",null,null,0,0,0,null,0,0,0,0]
[null,76,null,null,null,null,null,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,"GRAND TOTALS",null,null,null,{"$f":"SUM(G14:G90)","v":3415},{"$f":"SUM(H14:H90)","v":0},{"$f":"SUM(I14:I90)","v":0},{"$f":"SUM(J14:J90)","v":0},{"$f":"SUM(K14:K90)","v":0},{"$f":"K91/G91","v":0},{"$f":"G91-K91","v":3415},{"$f":"SUM(N14:N90)","v":0}]
[]
[null,"Users may obtain validation of this document by requesting of the license a completed AIA Document D401 - Certification of Document's Authenticity"]
[null,"V2017-09-20 12:11",null,null,null,null,null,{"$f":"SUM(H19:H90)","v":0},{"$f":"SUM(I19:I90)","v":0},{"$f":"+J91","v":0},{"$f":"SUM(K19:K90)","v":0},null,null,{"$f":"SUM(N19:N90)","v":0}]
[]
[]
[null,null,"CCO-PCO-SCO",null,null,null,null,"Amounts"]
[]
[null,null,"Note to Office"]
[null,null,{"$f":"+C10 &\"  is Main, & should show initial Sched of Values & total\"","v":"see G702 Invoice number  is Main, & should show initial Sched of Values & total"},null,null,null,null,{"$f":"+'G702'!E25","v":5500}]
[]
[null,null,null,{"$f":"+D83","v":"CCO-01"},null,null,{"$f":"IF(B102>0,G83,0)","v":0}]
[null,null,null,"CCO-02",null,null,0]
[null,null,null,"CCO-03",null,null,0]
[null,null,null,"CCO-03",null,null,0]
[null,null,null,"CCO-04",null,null,0]
[null,null,null,"CCO-05",null,null,0]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G98:G109)","v":0},{"$f":"SUM(H98:H109)+G110","v":5500}]
[]
[null,null,"Supplied Construction Extinguishers on site:",null,"None requested",0]

{"sheet":"Instructions","index":2,"n_rows":186,"n_cols":12,"rows_kept":186,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Note: This Workbook is Macro-Enabled"]
["INSTRUCTIONS for:"]
[null,"The G702 -Application & Certification for Payment & the G703 Continuation Sheet."]
[null,null,null,null,null,null,null,null,null,null,null,"Fire Suppression Services Incorporated"]
["Create a NEW file each month. (Copy this file to the General's Job-Payments Folder) and name it in format   yyyy-mm-dd Schedule of Values.xlsx"]
["Click 'View-ArrangeAll-select horizontal-Ok'  to see the sheet tabs at the bottom of the workbook."]
[null,"or if macros are disabled, The Security Warning: Macros have been disabled, above appears, click options and enable this Content"]
[null,null,null,null,null,null,null,null,"and we will resize the form for you."]
["Yellow = HiLite  Don't touch!   ,  Buff or Blue: You fill in data",null,null,null,null,"Grayed columns are where $retain calcs occur"]
[]
["G702"]
[null,"Fill in the G702  Application & Certification for Payment",null,null,null,null,null,null,null,null,null,"First page"]
[null,"TO:  Contractor (General's) Name and Address"]
[null,"Project name",null,null,"Architects Name Address"]
[null,"Application date"]
[null,"Period:   the dates this application covers"]
[null,"Contract number (off your Contract document)"]
[null,"Place an 'Tick' in the appropriate 'Distribution To' box"]
[null,"FROM:  Your Company name should be in to the 'From subcontractor'"]
[]
[null,"In the 'Contractor's Application for Payment' section,"]
[]
[]
[null,"LINE 1.","Fill in the sum from the ORIGINAL contract document.  It NEVER changes, from Start to End of the Contract term."]
[null,"LINE 2.","Net Change by Change Orders.  Add up in your head all the CCO's that have been APPROVED by the General"]
[null,null,"and enter the total here.",null,null,null,null,null,null,null,null,"2016-Dec  it now comes from D53 [NET CHANGES by Change Order]"]
[null,"LINE 3.","Contract Sum to Date, will total automatically"]
[null,"LINE 4.","Total Completed & Stored comes from the left side of column G on the G703"]
[null,"LINE 5.","Retainage"]
[null,null,"Your contract should set the retention terms, if any. (often it is 5%)"]
[null,null,null,"FSSI never accepts retention on Bonds, Design or Permitting"]
[null,null,null,"If we are required to underwrite a Bond/s for the GC or Owner, No Retention on any item."]
[null,null,null,null,"Bond is a 'Money-Back' guarantee. There is no need to also have retention."]
[null,null,null,null,"Bond/s serve same purpose as retention"]
[null,null,null,"If it's 5% for both, enter % in appropriate slot."]
[null,null,null,null,"5a","Completed  work.  Enter the appropriate %. "]
[null,null,null,null,null,null,"Amounts to the right are calculated from bottom of"]
[null,null,null,null,null,null,"column D + E on the G703",null,null,null,null,"CHECK with GENERAL, they may not"]
[null,null,null,null,"5b","Stored materials..  Enter the appropriate %",null,null,null,null,null,"      allow STORED Materials"]
[null,null,null,null,null,null,"Amounts to the right are calculated from bottom of"]
[null,null,null,null,null,null,"column F on the G703"]
[null,null,null,null,null,"Total retainage, the lesser is used because FSSI does not permit retainage"]
[null,null,null,null,null,null,null,null,null,null,null,"on Bond, Design or Permits"]
[null,"LINE 6.","Total Earned Less Retainage"]
[null,null,"Calculated using LINE4 minus the lesser of 5a or 5b"]
[]
[null,"LINE 7.","Enter the amount from your PREVIOUS pay applications LINE 6: Total Earned Less Retainage"]
[null,null,null,"Trust the paper trail; This application does NOT care whether you have been paid."]
[null,null,null,"It only cares whether you have EARNED additional payment."]
[null,null,null,"So do NOT enter payments received!",null,null,null,null,null,null,null,"Use the ChequeList sheet instead"]
[null,"LINE 8."]
[null,null,"Line6 minus Line7"]
[null,null,"It represents the value we should be paid for work during this pay period AND any change in retainage during the period."]
[null,"LINE 9.","Balance to Finish INCLUDING retainage."]
[null,null,"Line3 minus Line6"]
[null,null,"The payment you are still owed AFTER this application is paid"]
[]
[]
[null,"CHANGE ORDER SUMMARY TABLE"]
[null,null,"Separate out the CCO's that add money to your contract from those that subtract money from the contract."]
[null,null,"The Net Changes by Change Order should be EXACTLY equal to LINE 2"]
[null,null,"Amounts must also be added to the G703 Schedule of Values column"]
[null,null,null,null,null,null,null,null,null,null,null,"In the G703 lower section labeled SCO-PCO-CCO"]
[]
["G703"]
[null,"Fill in the G703  Continuation Sheet",null,null,null,null,null,null,null,null,null,"Second page"]
[null,"Column  A  Item number"]
[null,"Number the items in column A"]
[null,"FSSI always puts Bond first, Design, Permit & Submittals next"]
[null,null,"We MUST pay the Surety the full amount of the Bond within FIVE days of underwriting"]
[null,null,"      with SEASONED funds, or it is cancelled.  Which 'ticks-off' the Owner/GC"]
[null,null,"We must pay Design Engineers for their Stamp or they Lien the Property. NB: I said Lien, NOT 'SCR notice to rights to'."]
[null,null,"We are required by Law to pay, in full, all AHJ's upon submission of Request for Design approval & Plan Review."]
[null,null,null,"and for the Permit, else the Owner cannot release the property to the General for construction …"]
[null,null,null,"… and their insurance is compromised."]
[null,null,null,null,"(Submittals, to us FSS, means to an AHJ, NOT to the Owner/Contractor)"]
[]
[null,"Column  B  Description of Work"]
[null,"Enter the Item description in column B 'Description'   from your Cost Accounting folks or the Estimator's Bid Document."]
[null,null,null,null,null,null,null,null,null,null,null,"Note: BE BRIEF!"]
[null,"Extra Items like Net Change in CCO's that are approved are also entered.",null,null,null,null,null,null,null,null,null,"In the G703 lower section labeled SCO-PCO-CCO"]
[null,"Create a new line item by copying a cell line from spreadsheet column B to column K. i.e.  B30::N30"]
[null,null,null,null,null,null,null,null,null,null,null,"Never change the amount of any original line item."]
[null,null,null,null,null,null,null,null,null,null,null,"It forms the 'Schedule of Values' that is sent on Notice of Award"]
[null,"Column  C  From previous application"]
[null,"Enter the dollar amount of each item in column C 'Schedule of Values'   from your Cost Accounting folks or the Estimator's Bid Document."]
[null,null,"The total at the bottom of column C should initially total to the original contract amount"]
[null,null,"As  you add CCO net items, this total will change."]
[]
[null,"Column D & E  Work Completed"]
[null,null,"Column D"]
[null,null,"Enter the amounts for each item that you submitted from the PREVIOUS application"]
[null,null,"(The total of requested payments for work you submitted for all previous months)",null,null,null,null,null,null,null,null,"use the Addition method in the cell"]
[null,null,"Column E"]
[null,null,"Enter the amounts for each item that you have completed THIS period, & requesting payment for."]
[null,null,null,null,null,null,null,null,null,null,null,"E.g.. The work you did THIS month"]
[null,"Column F  Stored Materials"]
[null,null,"If you have delivered pipe, valves, sheetrock, framing or like materials ON TO the site enter their dollar amount here."]
[null,null,null,"This column is for items that are not yet attached to, or incorporated into, the building but will soon be, and .."]
[null,null,null,"are APPROVED for payment"]
[null,null,null,"Materials presently stored but not yet incorporated into the work are listed separately in Column F."]
[null,null,null,"Materials which continue to be stored in the following months pay periods should stay listed in Column F"]
[null,null,null,"until the materials are incorporated into the work, "]
[null,null,null,null,"at which time they are moved to Column E."]
[null,null,null,"Do NOT include labour or any NON-materials items."]
[null,null,null,"The Owner's Bank/Financier/Insurance folk need to know about these items."]
[null,null,null,"Our Bank/Insurance/Surety/Supplier/Lien Holder also need to know."]
[]
[]
[null,"Column G  Total completed and stored"]
[null,null,"Automatically calculates the amount and percentage completed"]
[]
[null,"Column H  Balance to finish"]
[null,null,"Automatically calculates how much you are still owed by the contractor/owner when you finish the job"]
[null,null,"and submit future applications for payments"]
[]
[null,"Column  I  Retainage"]
[null,null,"If it is at varying rates you may have to change the formula in these cells."]
[null,null,null,"The total at the bottom of the column should be the same as that on LINE 5 on the G702"]
[null,null,null,"Note, though, that FSSI does not permit retainage on Bond, Design Permit"]
[null,null,null,"and that if we supply a Bond, there should be ZERO retainage.  (AIA standards)"]
[]
[]
[]
[]
["Change Orders"]
[]
["Enter the amount(s) on BOTH the G702 AND the G703."]
[]
[null,"Additions     (Extras)"]
[]
[null,"G702:"]
[null,null,"Add the total value to the \"Change Order Summary\" in the Additions section."]
[null,null," It will automatically transfer to Line 2 and calculate Line 3."]
[null,"G703:"]
[null,null,"Do not change the amount of any original line item."]
[null,null," Create a new line item at the end and enter the total amount of the addition in the \"C\" column."]
[null,null,null,"Example:"]
[null,null,null,"(standard description)     \"Net of Change Order #1\":     1,000.00"]
[null,null,null,null,"Calculate the amount up to 100%, as the work is completed."]
[]
[null,"Credits or Deductions     (Negative Numbers)"]
[]
[null,"G702:"]
[null,null,"Add the total value to the \"Change Order Summary\" in the Deductions section."]
[null,null," It will automatically transfer to Line 2 and calculate Line 3."]
[null,"G703:"]
[null,null,"Do NOT change the amount of any original line items."]
[null,null,"Calculate the original amount in column \"C\" at 100% completed, after all work is completed."]
[null,null,null,"Create a new line item at the end of the list and enter the deduction amount with a minus sign."]
[null,null,null,"Example:"]
[null,null,null,"(standard description)     \"Net of Change Order #2\":     -5,000.00"]
[null,null,null,"Enter the amount in column \"C\" with a minus sign. (-)"]
[null,null,null,"Enter the amount in column \"E\" with a minus sign (-) after all work is completed."]
[null,null," Calculate retainage, column \"I\", if any. It will display a negative amount."]
[]
[null,null,"Accounting Tip, negative numbers:"]
[null,null,null,"To balance the accounting, calculate both the original line item amount and"]
[null,null,null,"the credit line item at 100% completed AFTER all work is completed."]
[null,"Author's Note:"]
[null,null,"It is good practice not to alter previous Pay Requests."]
[null,null,"\"Duplicate\" this file, then add any changes."]
[]
[]
["Finishing"]
[null,"When completed, click the Office button, top left corner"]
[null,"HOVER over 'Save as ..'        (the HOVER is important!)",null,null,null,null,null,null,"or Click [File]"]
[null,"And in the ‘Fly-out’ Click 'pdf or xps ..\" to save the page/s as a pdf file"]
[null,null,"save it as a pdf file"]
[null,null,"email the pdf to your upline (GC/Owner)"]
[null,"REPEAT the process with a new file each month"]
[]
["Arun (Mr.)"]
["CCM "]
["Fire Suppression Services Incorporated"]
["Authors Note:"]
[]
[null,"Our 'AIA G702-703' has been modified to reflect our Surety & Insurance & AHJ requirements, and may not quite suit 'Other Trades'"]
[null,"Specifically there is no retainage if we are Bonded to the Owner/GC, & no retainage on Bond Permit Design & Submittal to AHJ's)"]
[null,"The Calculated fields are 'Protected'  (Format Cells-Protection, in excel)"]
[null,"The Sheets are protected (Review-Protect Sheet, in excel)"]
[null,".. And"]
[null,".. this is by no means an exhaustive instruction set.  Refer to the AIA at:",null,null,null,null,null,"http://www.aia.org/"]
[null,"Created 2012-09-01",null,null,null,null,null,"Revised: 2014-05-02 added Stored Materials"]
[null,null,null,null,null,null,null,"Revised: 2014-10-22 Moved Stored Material info to Col F paragraph"]
[null,null,null,null,null,null,null,"Revised: 2016-12-05 Updated/Extended ChequeList Sheet"]

{"sheet":"Sprinks","index":3,"n_rows":76,"n_cols":10,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Sprinks"]
[null,"INCOMPLETE - WORK IN-PROGRESS TO EDIT ARUN"]
[]
[]
[null,null,null,"Enter Sq Foot",null,1.85,null,null,null,"Notes"]
[]
[null,null,"Ground",10848]
[null,null,"Attic",11704]
[null,null,"Area A",0]
[null,null,"Area B"]
[null,null,null,0,null,null,null,null,null,"<- Insert additional rows here if required"]
[]
[null,null,"Total",22552,null,41721.199999999997,null,null,null,"<-- Price should be near this"]
[]
[null,null,null,"Enter",null,"Enter Price","Don't touch",null,"Cost"]
[null,null,null,"Unit/s","Desc","each","extension",null,"Price","Notes"]
[]
[]
[null,null,null,22552,"Design",0.16,3608.32,null,0.13]
[null,null,null,1,"Submit",150,150]
[null,null,null,1,"Permit",1000,1000]
[]
[null,null,"Printing Drawings -Design-Submit stage",null,"Printing Drawings -Design-Submit stage"]
[]
[null,null,"Mobilisation",1,"Mobilisation",500,{"$f":"+D25*F25","v":500},null,null,"Mobilization, DeMob, ReMobilization"]
[]
[]
[null,null,"Riser",null,"Riser"]
[null,null,"Wet",1,"Transport",1000,1000]
[null,null,"Dry + Trimmer",1,"Drawings",150,150,null,null,"Prices for AWP's"]
[null,null,"Compressor-Riser Mount +AMD",1,"FDC",1500,1500,null,null,"Price for FDC"]
[null,null,"Head Box & Head Wrench",1,"Riser Assmbly",1860,1860]
[null,null,"FDC-BFP Strobe",1,"dry vlv, ac,  amd",5000,5000,null,null,"ENTER DATA ONLY IN the CYAN cells"]
[null,null,null,1,"Attic",5000,5000]
[null,null,"Ground Floor",1,"main floor",4000,4000]
[null,null,"Material",1,"Compressor",1800,1800]
[null,null,"Labour",null,"DeMob",null,0]
[null,null,"Fabrication",null,null,null,0,null,null,"<- Insert additional rows here if required"]
[null,null,"Attic",1,"Freight",1000,1000]
[null,null,"Material","Insert rows ABOVE here where needed"]
[null,null,"Labour"]
[null,null,"Fabrication",280,"Labor",50,14000,null,"2x Chaps","Davis Bacon"]
[null,null,null,null,"Labor OT",55,0]
[null,null,"Core Drilling, Remediation Sleeves"]
[null,null,null,1,"Project Management",0.02,811.37,40568.32,null,"You do PM labour"]
[null,null,"Alarms",1,"Training",55,55]
[null,null,"Horns Strobes Smokes, riser room fittings & Wire",1,"MarkUp",0.3,7970.5,26568.32,null,"you do not 'mark-up' labour"]
[null,null,"Pull  Station x4",null,"Commission",0.01,0]
[null,null,"FACP, Modules & Relays",1,"Fudge",0.82,0.82]
[null,null,"Labour"]
[null,null,null,null,"Total",null,49406]
[]
[null,null,null,null,null,null,2.19,null,null,"Price per Sq Ft"]
[null,null,null,null,"Bond",0.05,2470.3000000000002,null,3.5000000000000003E-2]
[null,null,"FE/FEC"]
[null,null,"FE's 1x ##lb ABC Badger series w/hooks @$70.00"]
[null,null,"FEC's 1x 1817F17 Ambassador series @204.00"]
[]
[]
[]
[null,null,"AWP"]
[null,null,"Freight"]
[null,null,"Travel & Transport  $250 x 4 wks"]
[null,null,"External Subs"]
[null,null,"Project Management"]
[]
[]
[null,null,"Finals"]
[null,null,"Printing-Drawings-Manuals-Tags"]
[null,null,"Testing & Inspections Trip Test"]
[null,null,"Training"]
[null,null,"DeMob"]
[]
[null,null,"SCO-PCO-CCO"]
[null,null,"Net CCO #1 External Dry heads   $8400"]
[null,null,"60 hours + 40 heads"]

{"sheet":"Alarms","index":4,"n_rows":42,"n_cols":28,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'G702'!E3","v":"La Caille Phase I"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal Services",null,null,null,null,null,null,null,"Testing",null,null,"Printing","Admin"]
[null,null,null,"Description",null,null,null,null,null,"Unit P","Extension","Design","Submit","Permit","Lien",null,"Parts","Pull","FACP","MDM","Labour",null,"Insp.Trip","Finals","Training","O&M's","PM","Freight"]
[]
[null,null,null,"Bond",null,null,null,null,null,0,{"$f":"+C4*J4","v":0}]
[null,null,1,"Design",null,null,null,null,null,450,450,{"$f":"+K5","v":450}]
[null,null,1,"Submit",null,null,null,null,null,200,200,null,{"$f":"+K6","v":200}]
[null,null,1,"Permit",null,null,null,null,null,125,125,null,null,{"$f":"+K7","v":125}]
[null,null,1,"Mobilization",null,null,null,null,null,75,75,null,null,null,null,null,null,null,null,{"$f":"+K8","v":75}]
[null,null,null,"Legal",null,null,null,null,null,15,0,null,null,null,{"$f":"+K9","v":0}]
[null,null,9,"Horns & Strobes",null,null,null,null,null,47,423,null,null,null,null,null,{"$f":"+K10","v":423}]
[null,null,1,"Horn/Strobe Weatherproof",null,null,null,null,null,105,105,null,null,null,null,null,{"$f":"+K11","v":105}]
[null,null,3,"Strobes",null,null,null,null,null,41,123,null,null,null,null,null,{"$f":"+K12","v":123}]
[null,null,19,"Addressable Smoke Detectors-Sounder Bases",null,null,null,null,null,68,1292,null,null,null,null,null,{"$f":"+K13","v":1292}]
[null,null,1,"VS1 Fire Panel (xx-zone)",null,null,null,null,null,525,525,null,null,null,null,null,null,null,{"$f":"+K14","v":525}]
[null,null,4,"CT1 Alarm contacts for riser",null,null,null,null,null,42,168,null,null,null,null,null,{"$f":"+K15","v":168}]
[null,null,4,"Pull Station",null,null,null,null,null,52,208,null,null,null,null,null,null,{"$f":"+K16","v":208}]
[null,null,2,"Control Relays & Modules",null,null,null,null,null,55,110,null,null,null,null,null,null,null,{"$f":"+K17","v":110}]
[null,null,2,"Monitor Modules",null,null,null,null,null,60,120,null,null,null,null,null,null,null,{"$f":"+K18","v":120}]
[null,null,null,"Booster Power Power Supplies",null,null,null,null,null,1800,0]
[null,null,null,"Adapter -Class A",null,null,null,null,null,68,0]
[null,null,2,"Wire -Fire 14/2",null,null,null,null,null,350,700,null,null,null,null,null,{"$f":"+K21","v":700}]
[null,null,1,"Parts & Accessories, back-boxes etc.",null,null,null,null,null,500,500,null,null,null,null,null,{"$f":"+K22","v":500}]
[null,null,1,"Panel Programming",null,null,null,null,null,75,75,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K23","v":75}]
[null,null,1,"Freight",null,null,null,null,null,50,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K24","v":50}]
[null,null,null,"Labour Description","Hours",null,"days",null,"Total Hours"]
[null,null,3,"     Labor Techs at",8,"hours over",5,null,{"$f":"+C26*E26*G26","v":120},70,{"$f":"+I26*J26","v":8400},null,null,null,null,null,null,null,null,null,{"$f":"+K26","v":8400}]
[null,null,null,"Finals"]
[null,null,1,"    Testing & Inspections Trip Test",null,null,null,null,null,150,{"$f":"+C28*J28","v":150},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K28","v":150}]
[null,null,1,"    De-Mob",null,null,null,null,null,75,{"$f":"+C29*J29","v":75},null,null,null,null,null,null,null,null,{"$f":"+K29","v":75}]
[null,null,1,"    Printing As-Builts, Manuals. Tags RedLines",null,null,null,null,null,150,{"$f":"+C30*J30","v":150},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K30","v":150}]
[null,null,null,"Legal",null,null,null,null,null,15,{"$f":"+C31*J31","v":0},null,null,null,{"$f":"+K31","v":0}]
[null,null,null,"Description","Hours",null,"days",null,"Total Hours"]
[null,null,1,"    Training",1,"hours over",1,null,{"$f":"+C33*E33*G33","v":1},75,{"$f":"+I33*J33","v":75},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K33","v":75}]
[null,null,1,"    Project Management",0.25,null,5,null,{"$f":"+C34*E34*G34","v":1.25},75,{"$f":"+I34*J34","v":93.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K34","v":93.75}]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,1,"Fudge",null,null,null,null,2.25,0,{"$f":"+C36*I36","v":2.25},null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,0.25]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K3:K37)","v":14195},{"$f":"SUM(L3:L37)","v":450},{"$f":"SUM(M3:M37)","v":200},{"$f":"SUM(N3:N37)","v":125},{"$f":"SUM(O3:O37)","v":0},null,{"$f":"SUM(Q3:Q37)","v":3311},{"$f":"SUM(R3:R37)","v":210},{"$f":"SUM(S3:S37)","v":755},{"$f":"SUM(T3:T37)","v":150},{"$f":"SUM(U3:U37)","v":8400},null,{"$f":"SUM(W3:W37)","v":225},{"$f":"SUM(X3:X37)","v":0},{"$f":"SUM(Y3:Y37)","v":75},{"$f":"SUM(Z3:Z37)","v":150},{"$f":"SUM(AA3:AA37)","v":94},50]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L38:AB38)","v":14195},{"$f":"+L2","v":"Design"},{"$f":"+M2","v":"Submit"},{"$f":"+N2","v":"Permit"},{"$f":"+O2","v":"Lien"},null,"Parts","Pull","FACP","MDM","Labour",null,"Insp.Trip","Finals","Training","O&M's",{"$f":"+AA2","v":"PM"},"Freight"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"14195-K39","v":0}]

{"sheet":"ChequeList","index":5,"n_rows":169,"n_cols":21,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[null,null,"1 = Design, 2 = Permit Submit",null,null,"START Date:-->",null,{"$f":"+'G703'!J6","v":"2020-12-10"},"2019-01-20","<--Enter Start of App Period"]
[null,null,"3 = Parts,  4 = Fabrication, 5 = Travel Transport AWP"]
[]
[null,null,null,null,null,null,null,"G702",{"$f":"SUM(I6:I167)","v":0},{"$f":"SUM(J6:J167)","v":0},0,0,0,0,0,0,0,0,null,null,"G702/$Net"]
[null,"Cheques to receive as @",null,{"$f":"NOW()","v":"2020-12-15T15:23:50.540"},"PAID","Date Rec'd","Chk #","App-#",{"$f":"+C7","v":"01 Design FSS"},{"$f":"+C8","v":"01 Design SFPS"},{"$f":"+C9","v":"02 Permit Submit AHJ"},{"$f":"+C10","v":"03 Parts FFab"},{"$f":"+C11","v":"03 Parts HD Supply"},{"$f":"+C12","v":"04 FabAFS"},{"$f":"+C13","v":"04 Fab Driller"},{"$f":"+C14","v":"05 AWP Howe"},{"$f":"+C15","v":"05 AWP FSS Fork Lift"},{"$f":"+C16","v":"Other"},null,{"$f":"+C18","v":"FSS"},"Gross"]
[null,null,null,null,null,null,null,1]
[{"$f":"+A5+1","v":1},null,"01 Design FSS",null,null,null,null,null,{"$f":"+E7","v":0}]
[{"$f":"+A7+1","v":2},null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E8","v":0}]
[3,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E9","v":0}]
[4,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E10","v":0}]
[5,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E11","v":0}]
[6,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E12","v":0}]
[7,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E13","v":0}]
[8,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E14","v":0}]
[9,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E15","v":0}]
[10,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E16","v":0}]
[11]
[12,null,"FSS",{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,0)),\"mmm\")&\" \"","v":"Period end:  Dec "},{"$f":"+U18-SUM(E6:E17)","v":0},null,null,{"$f":"+H6","v":1},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E18","v":0}]
[]
[{"$f":"+A18+1","v":13},null,{"$f":"+C7","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E20","v":0}]
[14,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E21","v":0}]
[15,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E22","v":0}]
[16,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E23","v":0}]
[17,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E24","v":0}]
[18,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E25","v":0}]
[19,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E26","v":0}]
[20,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E27","v":0}]
[21,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E28","v":0}]
[22,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E29","v":0}]
[23]
[24,null,{"$f":"+C18","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,1)),\"mmm\")&\" \"","v":"Period end:  Jan "},{"$f":"+U31-SUM(E19:E30)","v":0},null,null,{"$f":"+H18+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E31","v":0}]
[25]
[26,null,{"$f":"+C20","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E33","v":0}]
[27,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E34","v":0}]
[28,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E35","v":0}]
[29,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E36","v":0}]
[30,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E37","v":0}]
[31,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E38","v":0}]
[32,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E39","v":0}]
[33,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E40","v":0}]
[34,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E41","v":0}]
[35,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E42","v":0}]
[36]
[37,null,{"$f":"+C31","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,2)),\"mmm\")&\" \"","v":"Period end:  Feb "},{"$f":"+U44-SUM(E32:E43)","v":0},null,null,{"$f":"+H31+1","v":3},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E44","v":0}]
[38]
[39,null,{"$f":"+C33","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E46","v":0}]
[40,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E47","v":0}]
[41,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E48","v":0}]
[42,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E49","v":0}]
[43,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E50","v":0}]
[44,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E51","v":0}]
[45,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E52","v":0}]
[46,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E53","v":0}]
[47,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E54","v":0}]
[48,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E55","v":0}]
[49]
[50,null,{"$f":"+C44","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,3)),\"mmm\")&\" \"","v":"Period end:  Mar "},{"$f":"+U57-SUM(E45:E56)","v":0},null,null,{"$f":"+H44+1","v":4},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E57","v":0}]
[51]
[52,null,{"$f":"+C46","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E59","v":0}]
[53,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E60","v":0}]
[54,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E61","v":0}]
[55,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E62","v":0}]
[56,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E63","v":0}]
[57,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E64","v":0}]
[58,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E65","v":0}]
[59,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E66","v":0}]
[60,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E67","v":0}]
[61,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E68","v":0}]
[62]
[63,null,{"$f":"+C57","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,4)),\"mmm\")&\" \"","v":"Period end:  Apr "},{"$f":"+U70-SUM(E58:E69)","v":0},null,null,{"$f":"+H57+1","v":5},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E70","v":0}]
[64]
[{"$f":"+A71+1","v":65},null,{"$f":"+C59","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E72","v":0}]
[66,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E73","v":0}]
[67,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E74","v":0}]
[68,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E75","v":0}]
[69,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E76","v":0}]
[70,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E77","v":0}]
[71,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E78","v":0}]
[72,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E79","v":0}]
[73,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E80","v":0}]
[74,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E81","v":0}]
[75]
[76,null,{"$f":"+C70","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,5)),\"mmm\")&\" \"","v":"Period end:  May "},{"$f":"+U83-SUM(E71:E82)","v":0},null,null,{"$f":"+H70+1","v":6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E83","v":0}]
[77]
[78,null,{"$f":"+C72","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E85","v":0}]
[79,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E86","v":0}]
[80,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E87","v":0}]
[81,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E88","v":0}]
[82,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E89","v":0}]
[83,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E90","v":0}]
[84,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E91","v":0}]
[85,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E92","v":0}]
[86,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E93","v":0}]
[87,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E94","v":0}]
[88]
[89,null,{"$f":"+C83","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,6)),\"mmm\")&\" \"","v":"Period end:  Jun "},{"$f":"+U96-SUM(E84:E95)","v":0},null,null,{"$f":"+H83+1","v":7},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E96","v":0}]
[90]
[91,null,{"$f":"+C85","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E98","v":0}]
[92,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E99","v":0}]
[93,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E100","v":0}]
[94,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E101","v":0}]
[95,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E102","v":0}]
[96,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E103","v":0}]
[97,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E104","v":0}]
[98,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E105","v":0}]
[99,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E106","v":0}]
[100,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E107","v":0}]
[101]
[102,null,{"$f":"+C96","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,7)),\"mmm\")&\" \"","v":"Period end:  Jul "},{"$f":"+U109-SUM(E97:E108)","v":0},null,null,{"$f":"+H96+1","v":8},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E109","v":0}]
[103]
[104,null,{"$f":"+C98","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E111","v":0}]
[105,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E112","v":0}]
[106,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E113","v":0}]
[107,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E114","v":0}]
[108,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E115","v":0}]
[109,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E116","v":0}]
[110,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E117","v":0}]
[111,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E118","v":0}]
[112,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E119","v":0}]
[113,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E120","v":0}]
[114]
[115,null,{"$f":"+C109","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,8)),\"mmm\")&\" \"","v":"Period end:  Aug "},{"$f":"+U122-SUM(E110:E121)","v":0},null,null,{"$f":"+H109+1","v":9},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E122","v":0}]
[116]
[117,null,{"$f":"+C111","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E124","v":0}]
[118,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E125","v":0}]
[119,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E126","v":0}]
[120,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E127","v":0}]
[121,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E128","v":0}]
[122,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E129","v":0}]
[123,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E130","v":0}]
[124,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E131","v":0}]
[125,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E132","v":0}]
[126,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E133","v":0}]
[127]
[128,null,{"$f":"+C122","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,9)),\"mmm\")&\" \"","v":"Period end:  Sep "},{"$f":"+U135-SUM(E123:E134)","v":0},null,null,{"$f":"+H122+1","v":10},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E135","v":0}]
[{"$f":"+A135+1","v":129}]
[130,null,{"$f":"+C124","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E137","v":0}]
[{"$f":"+A137+1","v":131},null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E138","v":0}]
[132,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E139","v":0}]
[133,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E140","v":0}]
[134,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E141","v":0}]
[135,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E142","v":0}]
[136,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E143","v":0}]
[137,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E144","v":0}]
[138,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E145","v":0}]
[139,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E146","v":0}]
[140]
[141,null,{"$f":"+C135","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,10)),\"mmm\")&\" \"","v":"Period end:  Oct "},{"$f":"+U148-SUM(E136:E147)","v":0},null,null,{"$f":"+H135+1","v":11},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E148","v":0}]
[142]
[143,null,{"$f":"+C137","v":"01 Design FSS"},null,null,null,null,null,{"$f":"+E150","v":0}]
[144,null,"01 Design SFPS",null,null,null,null,null,null,{"$f":"+E151","v":0}]
[145,null,"02 Permit Submit AHJ",null,null,null,null,null,null,null,{"$f":"+E152","v":0}]
[146,null,"03 Parts FFab",null,null,null,null,null,null,null,null,{"$f":"+E153","v":0}]
[147,null,"03 Parts HD Supply",null,null,null,null,null,null,null,null,null,{"$f":"+E154","v":0}]
[148,null,"04 FabAFS",null,null,null,null,null,null,null,null,null,null,{"$f":"+E155","v":0}]
[149,null,"04 Fab Driller",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E156","v":0}]
[150,null,"05 AWP Howe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E157","v":0}]
[151,null,"05 AWP FSS Fork Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E158","v":0}]
[152,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E159","v":0}]
[153]
[154,null,{"$f":"+C148","v":"FSS"},{"$f":"\"Period end:  \"  & TEXT((EDATE($H$1,11)),\"mmm\")&\" \"","v":"Period end:  Nov "},{"$f":"+U161-SUM(E149:E160)","v":0},null,null,{"$f":"+H148+1","v":12},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E161","v":0}]
[155]
[]
[]
[]
["V2017-01-01 16:00"]
[]
[null,null,"Total To Receive",null,{"$f":"SUM(E6:E167)","v":0},null,null,null,{"$f":"+I4","v":0},{"$f":"+J4","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"+\"Total $\" &TEXT(SUM(I168:T168),\"#,##0.00;;;\")","v":"Total $"}]
[null,null,"Bal Owing ",null,{"$f":"+'G703'!G91-ChequeList!E168","v":3415},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+E169","v":3415}]

{"sheet":"Notes","index":6,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"2017-09-22","Added invoice color if blank"]
[]
[null,null,"2016-12-05","Added Orange Bar to ChequeList"]
[]
[null,null,null,"Requires Edate from Analysis ToolPak"]
[]
[null,null,"2016-08-22","2016-08-22 Needs Costing Sheets"]
[null,null,null,"remove Sprinks & Alarms ???"]
[]
[]
[null,null,null,null,null,null,null,"Column1"]
[null,null,null,null,null,null,null,"Div-10 44 16 Fire Extinguisher Cabinets or Extinguishers"]
[null,null,null,null,null,null,null,"Div-10 Fire Suppression Chemical -Clean Agent"]
[null,null,null,null,null,null,null,"Div-10 Fire Suppression Chemical-Kitchen Hoods"]
[null,null,null,null,null,null,null,"Div-21 Fire Suppression -Sprinklers"]