{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoice","Calcs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":34,"comments":2,"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":"Invoice","index":0,"n_rows":67,"n_cols":20,"rows_kept":67,"cut":false,"hidden":false,"merged":[[63,4,63,10],[60,3,60,6],[62,4,62,10],[60,7,60,10],[45,9,45,10],[46,9,50,10],[46,11,46,12],[45,11,45,12],[61,3,61,10],[51,5,52,5],[51,6,52,8],[46,6,47,8],[49,6,50,8],[48,3,48,4],[49,5,50,5],[53,3,54,4],[53,5,54,5],[59,3,59,6],[52,9,54,10],[53,6,54,8],[58,0,58,2],[49,3,50,4],[58,3,58,11],[54,11,54,12],[59,7,59,10],[59,12,60,13],[59,11,60,11],[49,0,50,2],[51,3,52,4],[53,11,53,12],[59,0,59,2],[53,0,54,2],[51,0,52,2],[52,11,52,12],[12,4,12,5],[13,4,13,5],[13,0,13,1],[32,2,32,10],[31,2,31,10],[27,2,27,10],[26,2,26,10],[28,2,28,10],[37,2,37,10],[13,6,13,8],[34,2,34,10],[18,2,18,3],[19,7,19,8],[35,2,35,10],[33,2,33,10],[12,2,12,3],[29,2,29,10],[30,2,30,10],[25,2,25,10],[16,4,16,8],[36,2,36,10],[0,12,1,13],[1,4,1,11],[2,4,2,11],[3,4,3,11],[0,4,0,11],[7,1,7,8],[7,10,7,13],[4,4,4,11],[11,12,11,13],[8,10,8,13],[9,10,9,13],[10,10,10,13],[10,1,10,8],[8,1,8,8],[6,9,11,9],[6,1,6,8],[6,10,6,13],[6,0,11,0],[12,6,12,8],[9,1,9,8],[14,0,14,1],[15,4,15,5],[24,2,24,10],[19,2,19,3],[15,6,15,8],[15,2,15,3],[20,7,20,10],[20,2,20,6],[23,2,23,10],[14,4,14,5],[14,2,14,3],[17,7,17,8],[18,7,18,8],[22,2,22,10],[21,2,21,10],[16,2,16,3],[14,7,14,8],[15,0,15,1],[16,0,16,1],[12,0,12,1],[13,2,13,3],[46,0,47,2],[46,3,47,4],[46,5,47,5],[51,9,51,10],[48,0,48,2],[17,2,17,3],[44,0,44,10],[45,3,45,4],[45,6,45,8],[43,2,43,10],[42,2,42,10],[41,2,41,10],[40,2,40,10],[38,2,38,10]]}
[null,null,null,null,"Fire Suppression Services, Inc.",null,null,null,null,null,null,null,"Quote",null,null,null,null,null,"InvIndex",8]
[null,null,null,null,"3802 South 2300 East",null,null,null,null,null,null,null,null,null,null,null,null,null,"InvTechName",{"$f":"INDEX(TechList,InvIndex)","v":"HDangerfield"}]
[null,null,null,null,"Millcreek, Utah  84109-3421",null,null,null,null,null,null,null,{"$f":"+InvTecInit","v":"HD"},"3#####",null,null,"Choose Sales person",null,"InvLicType",{"$f":"IF(INDEX(LType,InvIndex)>0,INDEX(LType,InvIndex),\"\")","v":"L3"}]
[null,null,null,null,"Contractor License No. 92-252208-5501",null,null,null,null,null,null,null,null,null,null,null,null,null,"InvLicNumber",{"$f":"IF(INDEX(LNumber,InvIndex)>0,INDEX(LNumber,InvIndex),\"\")","v":"S102811"}]
[null,null,null,null,"801.277.6464  •  800.273.6465  •  801.278.2199 - FAX",null,null,null,null,null,null,null,"DATE","2020-05-09",null,null,null,null,"InvTecInit",{"$f":"INDEX(TechInitial,InvIndex)","v":"HD"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M1=\"invoice\",\"DUE:\",\"EXPIRES:\")","v":"EXPIRES:"},{"$f":"IF(M1=\"invoice\",N5+15,+N5+30)","v":"2020-06-08"}]
["BILLING",null,null,null,null,null,null,null,null,"JOB SITE"]
[null,"Meadowbrook HOA",null,null,null,null,null,null,null,null,"Meadowbrook HOA street-side hydrant",null,null,null,null,null,{"$f":"IF(AND(M1=\"Invoice\",G18=TRUE),EDATE(N5,10),\"\")","v":""}]
[null,"857 Clover Circle",null,null,null,null,null,null,null,null,"Outside 874 S. Clover Circle",null,null,null,null,null,{"$f":"IF(M1=\"invoice\",\"Re-file date:-   \" &TEXT(J53,\"yyyy-mmm\"),\"\")","v":""}]
[null,"Ogden UT 84404",null,null,null,null,null,null,null,null,"Ogden UT 84404",null,null,null,null,null,{"$f":"+F67","v":"Quote/Estimate ONLY"}]
[null,"attn: Corky Sweet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M60>0,\"Total  $\"& TEXT(SUM(M60:M60),\"#,##0.00;;;\"),\"\")","v":"Total  $2,803.31"}]
[null,null,null,null,null,null,null,null,null,null,null,"Hydrant"]
[null,null,"Billing",null,"Job Site",null,"SALESPERSON",null,null,false,null,"DATE","TYPE","DATE"]
["CONTACT",null,"Corky Sweet",null,null,null,{"$f":"+InvTechName","v":"HDangerfield"},null,null,false,null,1985,"Mueller"]
["OFFICE",null,null,null,null,null,{"$f":"+InvLicType","v":"L3"},{"$f":"+InvLicNumber","v":"S102811"},null,false]
["CELL",null,8017261811,null,null,null,"Send to  eMail:",null,null,false]
[null,null,null,null,"MeadowBrookHOA148@gmail.com",null,null,null,null,false,false]
[null,false,null,null,false,null,false,null,null,true,null,"Mileage One-Way","","TIME"]
[null,false,null,null,false,null,true,null,null,true,null,"Drive Time One-Way","0 H 00 Min","00:00:00"]
[null,false,null,null,false,null,false,null,null,true,null,"UNIT PRICE","NON TAX","TAXABLE"]
["T","#",null,null,null,null,null,{"$f":"+N5","v":"2020-05-09"}]
[null,null,"Service as yet unknown for hydrant out side 874 S Clover Cir. Ogden",null,null,null,null,null,null,null,null,null,{"$f":"+IF(A22=\"\",B22*L22,0)","v":0},{"$f":"+IF(A22=\"T\",B22*L22,\"\")","v":""}]
[null,null,"Existing Green/Yellow Hydrant is a Mueller 1985",null,null,null,null,null,null,null,null,null,{"$f":"+IF(A23=\"\",B23*L23,0)","v":0},{"$f":"+IF(A23=\"T\",B23*L23,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
["T",1,"Hyrdant and shut-off valve repair",null,null,null,null,null,null,null,null,1900,0,1900]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Rick Masters will invoice",null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A37=\"T\",J37*L37,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A38=\"T\",J38*L38,\"\")","v":""}]
[null,null,"Tech hours",null,null,null,null,null,null,null,null,null,{"$f":"+IF(A39=\"\",B39*L39,0)","v":0},{"$f":"+IF(A39=\"T\",J39*L39,\"\")","v":""}]
["T",1,"Tech/s",null,null,"@",5,{"$f":"IF(B40>0,IF(B40>1,\"hours each is:\",\"hours is: \"),\"\")","v":"hours is: "},null,{"$f":"+B40*G40","v":5},{"$f":"IF(B40>0,\"Man Hours\",\"\")","v":"Man Hours"},65,{"$f":"+IF(A40=\"\",J40*L40,0)","v":0},{"$f":"+IF(A40=\"T\",J40*L40,\"\")","v":325}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A42=\"\",B42*L42,0)","v":0},""]
[false,null,{"$f":"IF(A43=TRUE,\"Compliance reporting fee: \",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"+IF(A43=TRUE,B43*L43,0)","v":0}]
[true,1,{"$f":"IF(A44=TRUE,\"WATER Utility reporting fee: \",\"\")","v":"WATER Utility reporting fee: "},null,null,null,null,null,null,null,null,30,{"$f":"+IF(A44=TRUE,B44*L44,0)","v":30},""]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTALS:",{"$f":"SUM(M21:M39)","v":0},{"$f":"SUM(N21:N40)","v":2225}]
[null,null,null,"DUE WHEN",null,"LAST COMPANY","NUMBER ON PROPERTY",null,null,"CODE",null,"Non-Taxable Total",null,{"$f":"+M45","v":0}]
["EXTINGUISHER",null,null,null,null,null,null,null,null,null,null,"Taxable Sales",null,{"$f":"+N45","v":2225}]
[null,null,null,null,null,null,null,null,null,null,null,true,null,{"$f":"IF(L48=TRUE,ROUNDUP((+N46+N47)*8%,0),0)","v":178},null,"<- ALWAYS"]
["Alarms",null,null,null,null,null,null,null,null,null,null,true,"Sales Tax",{"$f":"IF(L49=TRUE,+(N45*rngTaxMillcreek),0)","v":161.3125},null,"<- moveable assets only"]
["EM / EX LIGHTING",null,null,null,null,null,null,null,null,null,null,false,"Travel/Transport",0,null,"<- To Tech for his/her vehicle & their travel cost"]
[null,null,null,null,null,null,null,null,null,null,null,true,"Freight",{"$f":"IF(L51=TRUE,ROUNDUP(rngFreight*(M45+N45),0),0)","v":23},null,"<- Our charge to deliver"]
["HOOD CLEANING",null,null,null,null,null,null,null,null,{"$f":"IF(M1=\"Invoice\",\"REFILE\",\"\")","v":""},null,true,"Handling",{"$f":"IF(L52=TRUE,30,0)","v":30},null,"<- The folks that load it"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(M1=\"Invoice\",G18=TRUE),EDATE(N5,10),\"\")","v":""},null,true,null,{"$f":"IF(L53=TRUE,ROUNDUP((+M45+N45)*7%,0),0)","v":156},null,"<- EPA regulation"]
["RISER",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A43=TRUE,A44=TRUE),\"Compliance reporting fee\",\"\")","v":"Compliance reporting fee"},null,{"$f":"SUM(M43:M44)","v":30}]
[]
["I, RECEIPT OF COPY: CUSTOMER ACKNOWLEDGES RECEIPT OF COPY AND THAT HE UNDERSTANDS ALL OF THIS AGREEMENT AND PARTICULARLY PARAGRAPHS 1,2,3,4 AND 5 ON THE REVERSE "]
["WHICH SETS FORTH COMPANY'S MAXIMUM LIABILITY.  THE SYSTEM'S HAVE BEEN SERVICED  IN ACCORDANCE WITH NATIONAL FIRE PROTECTION STANDARDS AND CODES OR CURRENT MFG."]
["SERVICE REQUIREMENTS AND DOES NOT CERTIFY THE DESIGN AND / OR THE INSTALLATION CRITERIA."]
[]
["Net 15 Days",null,null,"WORK AUTHORIZATION NUMBER",null,null,null,null,null,null,null,{"$f":"IF(M1=\"INVOICE\",\"TOTAL DUE\",\"Estimated at:\")","v":"Estimated at:"},{"$f":"SUM(N46:N48)+SUM(N49:N55)","v":2803.3125},null,null,"Type in the red cells and"]
[null,null,null,"PURCHASE / WORK  ORDER NUMBER",null,null,null,null,null,null,null,null,null,null,null,"the colour will dissappear"]
["  Cash",null,null,"RECEIVED IN GOOD ORDER  AND ACCEPTED",null,null,null,null,null,null,null,"TIMES ARE CORRECT AND JOB COMPLETED SATISFACTORILY "]
["  Check",null,null,"BY X",null,null,null,null,null,null,null,"CLAIMS WILL NOT BE HONORED AFTER TEN (10) DAYS FROM DATE"]
["   Credit card",null,null,null,"BUYER SHALL PAY SELLER FOR THIS PURCHASE",null,null,null,null,null,null,"OF SERVICE."]
["INTEREST & COLLECTION FEES WILL BE CHARGED ON  OVERDUE ACCOUNTS.",null,null,null,null,null,null,"3% PER MONTH",null,null,"MINIMUM BILLING OF $45.00"]
[]
["Rev: 2020-07-30    11:29",null,null,null,null,{"$f":"IF(M1=\"INVOICE\",\"THIS INVOICE  IS  ALSO YOUR STATEMENT\",\"Quote/Estimate ONLY\")","v":"Quote/Estimate ONLY"},null,null,null,null,null,null,null,"THANK YOU"]

{"sheet":"Calcs","index":1,"n_rows":62,"n_cols":23,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"rngTechList",null,null,null,null,null,null,null,null,"Service"]
[null,null,null,"TechList","LType","LNumber","TechInitial"]
[]
[null,null,1,"ADangerfield","L1","S102811",{"$f":"LEFT(D7,2)","v":"AD"}]
[null,null,2,"Arun",null,null,"AUR"]
[null,null,3,"BHolbrook","HE",48,{"$f":"LEFT(D9,2)","v":"BH"}]
[null,null,4,"BGubler","HE",13,{"$f":"LEFT(D10,2)","v":"BG"}]
[null,null,5,"Bonnie",null,null,{"$f":"LEFT(D11,1)","v":"B"}]
[null,null,6,"DCawley","HE",5355,{"$f":"LEFT(D12,2)","v":"DC"}]
[null,null,7,"Glenn","EE",1463,{"$f":"LEFT(D13,2)","v":"Gl"}]
[null,null,8,"HDangerfield","L3","S102811",{"$f":"LEFT(D14,2)","v":"HD"}]
[null,null,9,"KCall","HE",111011,{"$f":"LEFT(D15,2)","v":"KC"}]
[null,null,10,"MKimball","AE",11131,{"$f":"LEFT(D16,2)","v":"MK"}]
[null,null,11,"Kristen",null,null,{"$f":"LEFT(D17,1)","v":"K"}]
[null,null,12,"JLeavitt","HE",11107,{"$f":"LEFT(D18,2)","v":"JL"}]
[null,null,13,"BNielson","HE",8687,{"$f":"LEFT(D19,2)","v":"BN"}]
[null,null,14,"Office",null,null,{"$f":"LEFT(D20,1)","v":"O"}]
[null,null,15,"TStrickland","HE",3638,{"$f":"LEFT(D21,1)","v":"T"}]
[null,null,16,"Zach","AE",248,{"$f":"LEFT(D22,2)","v":"Za"}]
[]
[]
[null,null,null,null,"rngTCE"]
[null,null,null,null,null,"TCE SP"]
[null,null,null,null,null,0]
[null,null,null,null,null,30]
[null,null,null,null,null,50]
[null,null,null,null,null,55]
[]
[null,null,null,null,null,null,null,"rngTaxMillcreek"]
[null,null,null,null,null,null,null,null,"Millcreek Tax"]
[null,null,null,null,null,null,null,null,{"$f":"0.0725","v":7.2499999999999995E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"rngMarkUp"]
[null,null,null,null,null,null,null,null,null,null,null,"Ins&Misc"]
[null,null,null,null,null,null,null,null,null,null,null,0.08]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"rngFreight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freight Charge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngtaxChoice"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contacts","cEmail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice","apquestions@emcorgroup.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quote","ldschurch@emcorgroup.com"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngTravel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reimburse for travel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]