{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoice","Calcs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":39,"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":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":false,"merged":[[37,3,37,6],[37,7,37,8],[48,0,49,2],[48,3,49,4],[48,5,49,5],[53,9,53,10],[50,0,50,2],[46,0,46,10],[47,3,47,4],[47,6,47,8],[45,2,45,10],[51,0,52,2],[53,3,54,4],[44,2,44,10],[43,2,43,10],[42,2,42,10],[40,2,40,10],[6,0,11,0],[12,6,12,8],[9,1,9,8],[14,0,14,1],[15,4,15,5],[24,2,24,10],[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],[13,4,13,5],[13,6,13,8],[11,10,11,13],[12,0,12,1],[13,2,13,3],[9,10,9,13],[18,1,18,3],[19,1,19,3],[35,2,35,10],[33,2,33,10],[14,7,14,8],[15,0,15,1],[16,0,16,1],[31,2,31,10],[27,2,27,10],[26,2,26,10],[28,2,28,10],[34,2,34,10],[19,7,19,8],[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],[8,10,8,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],[12,4,12,5],[61,0,61,2],[55,0,56,2],[53,0,54,2],[54,11,54,12],[12,2,12,3],[29,2,29,10],[30,2,30,10],[25,2,25,10],[16,4,16,8],[36,2,36,10],[17,1,17,3],[60,0,60,2],[51,3,52,4],[60,3,60,11],[56,11,56,12],[13,0,13,1],[32,2,32,10],[65,4,65,10],[62,3,62,6],[64,4,64,10],[62,7,62,10],[47,9,47,10],[48,9,52,10],[47,11,47,12],[63,3,63,10],[53,5,54,5],[53,6,54,8],[48,6,49,8],[51,6,52,8],[50,3,50,4],[51,5,52,5],[55,3,56,4],[55,5,56,5],[61,3,61,6],[54,9,56,10],[55,6,56,8],[61,7,61,10],[61,12,62,13],[61,11,62,11],[55,11,55,12]]}
[null,null,null,null,"Fire Suppression Services, Inc.",null,null,null,null,null,null,null,"INVOICE",null,null,null,{"$f":"IF(B19=\"Monitoring\",\"Enter Start Date\",\"\")","v":"Enter Start Date"},null,"InvIndex",5]
[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":"Bonnie"}]
[null,null,null,null,"Millcreek, Utah  84109-3421",null,null,null,null,null,null,null,{"$f":"+InvTecInit","v":"B"},231387,null,null,"Choose Sales person",null,"InvLicType",{"$f":"IF(INDEX(LType,InvIndex)>0,INDEX(LType,InvIndex),\"\")","v":""}]
[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":""}]
[null,null,null,null,"(801) 277-6464  •  (800) 273-6465  •  (801) 278-2199 - FAX",null,null,null,null,null,null,null,"DATE:","2021-03-31",null,null,null,null,"InvTecInit",{"$f":"INDEX(TechInitial,InvIndex)","v":"B"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M1=\"INVOICE\",M1=\"Monitoring Invoice\"),\"DUE:\",\"EXPIRES:\")","v":"DUE:"},{"$f":"IF(ISBLANK(Q2),+Q6,Q2)","v":"2021-04-21"},null,"Default->",{"$f":"IF(M1=\"invoice\",N5+21,IF(M1=\"Monitoring Invoice\",DATE(YEAR(N5),MONTH(N5)+1,1),+N5+30))","v":"2021-04-21"}]
["BILLING",null,null,null,null,null,null,null,null,"JOB SITE"]
[null,"Enter Billing Client name",null,null,null,null,null,null,null,null,"sitename"]
[null,"Billing street",null,null,null,null,null,null,null,null,"street",null,null,null,null,null,{"$f":"IF(M1=\"invoice\",\"Re-file date:-   \" &TEXT(J55,\"yyyy-mmm\"),\"\")","v":"Re-file date:-   2022-Jan"}]
[null,"City State Zip",null,null,null,null,null,null,null,null,"City State Zip",null,null,null,null,null,{"$f":"+F69","v":"THIS INVOICE  IS  ALSO YOUR STATEMENT"}]
[null,"Attn: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(M62>0,\"Total  $\"& TEXT(SUM(M62:M62),\"#,##0.00;;;\"),\"\")","v":"Total  $799.01"}]
[]
[null,null,"Billing",null,"Job Site",null,null,null,null,null,"TECHNICIAN",{"$f":"IF(L14=\"\",\"\",\"Licence\")","v":""}]
["CONTACT",null,"enter name",null,"enter name",null,null,null,null,null,{"$f":"+InvTechName","v":"Bonnie"},{"$f":"InvLicType","v":""},{"$f":"+InvLicNumber","v":""}]
["OFFICE",null,8885151212,null,8885151212]
["CELL",null,8885151212,null,8885151212,null,"Send to  eMail:"]
[null,null,null,null,"enter clients eMail address",null,null,null,null,null,null,null,null,null,null,"ReFile"]
[null,"Category",null,null,null,"Schedule",null,"Periodicity",null,null,null,"Mileage One-Way","","TIME",null,{"$f":"IF(H19=\"Annual\",EDATE($N$5,10),IF(H19=\"Bi-Annual\",EDATE($N$5,4),IF(H19=6,EDATE($N$5,2),IF(H19=\"Monthly\",EDATE($N$5,1),\"No ReFile\"))))","v":"2022-01-31"}]
[null,"Monitoring",null,null,null,"09 Invoice",null,"Annual",null,null,null,"Drive Time One-Way","0 H 00 Min","00:00:00",null,{"$f":"H19","v":"Annual"}]
[null,null,null,null,null,null,null,null,null,null,null,"UNIT PRICE","NON TAX","TAXABLE"]
["T","#",null,null,null,null,null,{"$f":"+N5","v":"2021-03-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A22=\"T\",\"\",B22*L22)","v":0},{"$f":"+IF(A22=\"T\",B22*L22,\"\")","v":""}]
[null,null,"Code required Off-Site Monitoring annual fee for S1-2305",null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A23=\"T\",B23*L23,\"\")","v":""}]
[null,null,"for period from 2021-May-01 to 2022-Apr-30",null,null,null,null,null,null,null,null,null,0,""]
["T",12,"Annual monitoring of  Fire Alarm Control Panel a/c# S12305",null,null,null,null,null,null,null,null,72,"",864]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
["T",-2,"Discount if paid in advance of service",null,null,null,null,null,null,null,null,72,"",-144]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
["T",1,"One-time Data SetUp fee",null,null,null,null,null,null,null,null,25,"",25]
[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,"Next payment due before: ",null,null,null,{"$f":"P38","v":"2022-04-21"},null,null,null,"SUBTOTALS:",{"$f":"SUM(M21:M37)","v":0},{"$f":"SUM(N21:N37)","v":745},null,{"$f":"IF(H19=\"Annual\",EDATE($N$6,12),IF(H19=\"Bi-Annual\",EDATE($N$6,4),IF(H19=6,EDATE($N$6,2),IF(H19=\"Monthly\",EDATE($N$6,1),IF(H19=\"Quarterly\",EDATE($N$6,3),\"No ReFile\")))))","v":"2022-04-21"},"<- Next due"]
[]
[]
[null,null,"Tech hours"]
[null,null,"Tech/s",null,null,"@",null,{"$f":"IF(B42>0,IF(B42>1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,null,{"$f":"IF(B42>0,\"Man Hours\",\"\")","v":""},null,{"$f":"+IF(A42=\"T\",\"\",J42*L42)","v":0},{"$f":"+IF(A42=\"T\",J42*L42,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[false,null,{"$f":"IF(A45=TRUE,\"Compliance reporting fee: \",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A45=TRUE,B45*L45,\"\")","v":""},null,"<- AHJ Reporting fee. Use the check-box first"]
[false,null,{"$f":"IF(A46=TRUE,\"WATER Utility reporting fee: \",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A46=TRUE,B46*L46,\"\")","v":""},null,"<- UTILITY Reporting fee . Use the check-box first"]
[]
[null,null,null,"DUE WHEN",null,"LAST COMPANY","NUMBER ON PROPERTY",null,null,"CODE"]
["EXTINGUISHER",null,null,null,null,null,null,null,null,null,null,true,null,{"$f":"IF(L49=TRUE,+M42,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L50=TRUE,ROUNDUP((+M38+N38)*8%,0),0)","v":0},null,"<- ALWAYS"]
["Alarms",null,null,null,null,null,null,null,null,null,null,false,"Sales Tax",{"$f":"IF(N38>0,N38*rngTaxMillcreek,\"\")","v":54.012499999999996},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,false,"Freight",{"$f":"IF(L53=TRUE,ROUNDUP(rngFreight*(M38+N38),0),0)","v":0},null,"<- Our charge to deliver"]
["HOOD CLEANING",null,null,null,null,null,null,null,null,{"$f":"IF(M1=\"Invoice\",\"REFILE\",IF((J55)=\"No Refile\",\"\",\"ReFile Date:\"))","v":"REFILE"},null,false,"Handling",{"$f":"IF(L54=TRUE,ROUNDUP(rngHandling*(M38+N38),0),0)","v":0},null,"<- The folks that load it"]
[null,null,null,null,null,null,null,null,null,{"$f":"+P59","v":"2022-01-31"},null,false,null,{"$f":"IF(L55=TRUE,ROUNDUP((+M38+N38)*7%,0),0)","v":0},null,"<- EPA regulation"]
["RISER",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A45=TRUE,A46=TRUE),\"Compliance reporting fee\",\"\")","v":""},null,{"$f":"SUM(M45:M46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L57=TRUE,(((+M38+N38)+SUM(N49:N56))*P57),\"\")","v":""},null,0.03,"AmEx"]
["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.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H19=\"Annual\",EDATE($N$5,10),IF(H19=\"Bi-Annual\",EDATE($N$5,4),IF(H19=6,EDATE($N$5,2),IF(H19=\"Monthly\",EDATE($N$5,1),\"No ReFile\"))))","v":"2022-01-31"}]
["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":"TOTAL DUE"},{"$f":"SUM(N49:N57)+N38","v":799.01250000000005},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-08-08    10:15",null,null,null,null,{"$f":"IF(OR(M1=\"INVOICE\",M1=\"Monitoring Invoice\"),\"THIS INVOICE  IS  ALSO YOUR STATEMENT\",\"Quote/Estimate ONLY\")","v":"THIS INVOICE  IS  ALSO YOUR STATEMENT"},null,null,null,null,null,null,null,"THANK YOU"]

{"sheet":"Calcs","index":1,"n_rows":112,"n_cols":12,"rows_kept":112,"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,null,null,null,null,null,"rngTCE"]
[null,null,null,null,null,null,null,null,null,null,"TCE SP"]
[]
[null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,"rngTaxMillcreek"]
[null,null,null,null,null,null,null,null,null,null,"Millcreek Tax"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"0.0725","v":7.2499999999999995E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngMarkUp"]
[null,null,null,null,null,null,null,null,null,null,"Ins&Misc"]
[null,null,null,null,null,null,null,null,null,null,0.08]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngHandling"]
[null,null,null,null,null,null,null,null,null,null,"Handling charge"]
[null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngFreight"]
[null,null,null,null,null,null,null,null,null,null,"Freight Charge"]
[null,null,null,null,null,null,null,null,null,null,0.01]
[]
[null,null,null,null,null,null,null,null,null,"rngtaxChoice"]
[]
[null,null,null,null,null,null,null,null,null,null,"T"]
[]
[null,null,null,null,null,null,null,null,null,"Contacts","cEmail"]
[null,null,null,null,null,null,null,null,null,"Invoice","noEmail"]
[null,null,null,null,null,null,null,null,null,"Quote","noEmail"]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngTravel"]
[null,null,null,null,null,null,null,null,null,null,"Reimburse for travel"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,55]
[]
[null,null,null,null,null,null,null,null,null,"rngItemsJob"]
[]
[null,null,null,null,null,null,null,null,null,null,"Alarms"]
[null,null,null,null,null,null,null,null,null,null,"Back flow preventor"]
[null,null,null,null,null,null,null,null,null,null,"eLites"]
[null,null,null,null,null,null,null,null,null,null,"Emergency D&G"]
[null,null,null,null,null,null,null,null,null,null,"Exhaust cleaning"]
[null,null,null,null,null,null,null,null,null,null,"Extinguishers"]
[null,null,null,null,null,null,null,null,null,null,"Monitoring"]
[null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,"Suppression Chemical"]
[null,null,null,null,null,null,null,null,null,null,"Suppression Clean Agent"]
[null,null,null,null,null,null,null,null,null,null,"Suppression Sprinkler"]
[]
[null,null,null,null,null,null,null,null,null,"rngItemsSchedule"]
[]
[null,null,null,null,null,null,null,null,null,null,"01 Prelims"]
[null,null,null,null,null,null,null,null,null,null,"02 Mobilisation"]
[null,null,null,null,null,null,null,null,null,null,"03 Progress Payment"]
[null,null,null,null,null,null,null,null,null,null,"04 Installation"]
[null,null,null,null,null,null,null,null,null,null,"05 Finals"]
[null,null,null,null,null,null,null,null,null,null,"06 Repair"]
[null,null,null,null,null,null,null,null,null,null,"07 Inspection"]
[null,null,null,null,null,null,null,null,null,null,"08 Time & Materials"]
[null,null,null,null,null,null,null,null,null,null,"09 Invoice"]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngPeriodicity"]
[]
[null,null,null,null,null,null,null,null,null,null,"Annual"]
[null,null,null,null,null,null,null,null,null,null,"Bi-Annual"]
[null,null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,"Quarterly"]
[]
[]
[null,null,null,null,null,null,null,null,null,"rngInvoiceType"]
[]
[null,null,null,null,null,null,null,null,null,null,"BID ONLY"]
[null,null,null,null,null,null,null,null,null,null,"Estimate"]
[null,null,null,null,null,null,null,null,null,null,"INVOICE"]
[null,null,null,null,null,null,null,null,null,null,"Monitoring Invoice"]