{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Invoice","Calcs","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":28,"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":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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],[6,10,6,13],[12,4,12,5],[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],[12,0,12,1],[12,2,12,3],[6,0,11,0],[12,6,12,8],[9,1,9,8],[9,10,9,13],[11,10,11,13],[10,10,10,13],[10,1,10,8],[8,1,8,8],[6,9,11,9],[6,1,6,8],[13,2,13,3],[53,3,54,4],[22,2,22,10],[21,2,21,10],[16,2,16,3],[13,4,13,5],[13,6,13,8],[53,0,54,2],[51,0,52,2],[45,2,45,10],[29,2,29,10],[30,2,30,10],[25,2,25,10],[16,4,16,8],[36,2,36,10],[17,1,17,3],[40,2,40,10],[46,0,46,10],[13,0,13,1],[32,2,32,10],[44,2,44,10],[15,0,15,1],[14,7,14,8],[16,0,16,1],[65,4,65,10],[62,3,62,6],[64,4,64,10],[62,7,62,10],[47,9,47,10],[48,9,52,10],[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],[55,6,56,8],[61,3,61,6],[54,9,56,10],[48,3,49,4],[48,5,49,5],[53,9,53,10],[47,3,47,4],[47,6,47,8],[61,7,61,10],[55,0,56,2],[18,1,18,3],[19,1,19,3],[35,2,35,10],[61,12,62,13],[61,11,62,11],[55,11,55,12],[54,11,54,12],[47,11,47,12],[60,0,60,2],[51,3,52,4],[60,3,60,11],[48,0,49,2],[50,0,50,2],[31,2,31,10],[27,2,27,10],[26,2,26,10],[28,2,28,10],[37,2,37,10],[34,2,34,10],[19,7,19,8],[39,2,39,10],[38,2,38,10],[33,2,33,10]]}
[null,null,null,null,"Fire Suppression Services, Inc.",null,null,null,null,null,null,null,null,"INVOICE",null,"<-- 01 Select from the drop-down","Enter Start Date",null,null,"InvIndex",2]
[null,null,null,null,"3802 South 2300 East",null,null,null,null,null,null,null,{"$f":"+InvTecInit","v":"AUR"},233310,null,"<-- 02 Enter invoice number",null,null,null,"InvTechName",{"$f":"INDEX(rngTechList,rngInvIndex)","v":"Arun"}]
[null,null,null,null,"Millcreek, Utah  84109-3421",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InvLicType",{"$f":"IF(INDEX(rngLType,rngInvIndex)>0,INDEX(rngLType,rngInvIndex),\"\")","v":""}]
[null,null,null,null,"Contractor License No. 92-252208-5501",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"Monitoring\",\"02a Enter Start-of-Service Date\",\"the cell below should be blank\")","v":"the cell below should be blank"},null,null,"InvLicNumber",{"$f":"IF(INDEX(LNumber,rngInvIndex)>0,INDEX(LNumber,rngInvIndex),\"\")","v":""}]
[null,null,null,null,"801.277.6464  •  800.273.6465  •  801.278.2199 - FAX",null,null,null,null,null,null,null,"DATE","2022-07-22",null,null,null,null,null,"InvTecInit",{"$f":"INDEX(rngTechInitial,rngInvIndex)","v":"AUR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N1=\"invoice\",\"DUE:\",\"EXPIRES:\")","v":"DUE:"},"2021-08-20",null,null,{"$f":"IF(AND(N1=\"INVOICE\",B19=\"Monitoring\",F19=\"09 Invoice\"),EDATE(N5,10),\"\")","v":""}]
["BILLING",null,null,null,null,null,null,null,null,"JOB SITE",null,null,null,null,null,null,{"$f":"IF(M1=\"invoice\",N5+21,IF(M1=\"Monitoring Invoice\",DATE(YEAR(N5),MONTH(N5)+1,1),+N5+30))","v":"2022-08-21"},"<-- Default date is:",null,null,"Rate"]
[null,"Consolidated Fire Protection",null,null,null,null,null,null,null,null,"Public Storage #24608",null,null,null,null,null,null,null,null,"Fire",60]
[null,"2929 N. Central Expressway Ste 315",null,null,null,null,null,null,null,null,"2942 S. 3600 W",null,null,null,null,"03 Choose Sales person -->",null,null,null,"Burg",50]
[null,"Richardson. TX 75080",null,null,null,null,null,null,null,null,"West Valley City.  UT "]
[null,"Attn: Rosalyn Crockett"]
[null,null,null,null,null,null,null,null,null,null,"Attn: Sandy ?"]
[null,null,"Billing",null,"Job Site",null,null,null,null,null,"TECHNICIAN",{"$f":"IF(L14=\"\",\"\",\"Licence\")","v":""}]
["CONTACT",null,null,null,"Sandy",null,null,null,null,null,{"$f":"+InvTechName","v":"Arun"},{"$f":"InvLicType","v":""},{"$f":"+InvLicNumber","v":""}]
["OFFICE",null,9497273277,null,8019736079,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(H62)=0","v":false}]
["CELL",null,9496330512,null,null,null,"Send to  eMail:",null,null,null,null,null,null,null,null,null,{"$f":"+F69","v":"THIS INVOICE  IS  ALSO YOUR STATEMENT"}]
[null,null,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  $1,630.00"}]
[null,"Division",null,null,null,"Schedule",null,"Periodicity",null,null,null,"Mileage One-Way","","TIME",null,"ReFile",{"$f":"IF(N1=\"INVOICE\",\"Re-file date:-   \" &TEXT(J55,\"yyyy-mmm\"),\"\")","v":"Re-file date:-   No ReFile"}]
[null,"Hydrants",null,null,null,"10 Incurred Costs",null,"One-time",null,null,null,"Drive Time One-Way","0 H 00 Min","00:00:00",null,{"$f":"H19","v":"One-time"}]
[null,null,null,null,null,null,null,null,null,null,null,"UNIT PRICE","NON TAX","TAXABLE",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":"No ReFile"}]
["T","#",null,null,null,null,null,{"$f":"+N5","v":"2022-07-22"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A22=0,B22*L22,0)","v":0},{"$f":"+IF(A22=\"T\",B22*L22,\"\")","v":""},"_ fold"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A23=\"T\",B23*L23,\"\")","v":""}]
[null,null,"Prelim assessment extent of damage to Hydrant, valve & components",null,null,null,null,null,null,null,null,null,0,""]
[null,null,"Incurred cost for liaise with AHJ and techs:",null,null,null,null,null,null,null,null,0,0,""]
[null,8,"Research, permit and Underground line flow assessment: tech hours",null,null,null,null,null,null,null,null,200,1600,""]
[null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,"Fire Tech hours",null,null,null,null,null,null,null,null,0,0,"",null,null,null,"Cell format is:"]
[null,null,"Fire Tech Travel",null,null,null,null,null,null,null,null,0,0,"",null,null,null,"Accounting w/ bracket-Neagative & blank zero"]
[null,null,"Truck fee",null,null,null,null,null,null,null,null,0,0,"",null,null,null," _($* 0.00_);_($* (0.00)_;;\" \""]
[null,null,null,null,null,null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,0,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,1475]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,null,null,1400]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A37=\"T\",J37*L37,\"\")","v":""},null,null,null,null,600]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTALS:",{"$f":"SUM(M21:M37)","v":1600},{"$f":"SUM(N21:N37)","v":0},null,null,null,null,250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S34:S38)","v":3845}]
[]
[null,null,"Tech hours"]
[null,null,"Tech/s",null,"2022-03-21","@",null,{"$f":"IF(B42>0,IF(B42>1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,{"$f":"+B42*G42","v":0},{"$f":"IF(B42>0,\"Man Hours\",\"\")","v":""},0,{"$f":"+IF(A42=\"\",J42*L42,0)","v":0},{"$f":"+IF(A42=\"T\",J42*L42,0)","v":0}]
[null,null,null,null,null,"@",null,{"$f":"IF(B43>0,IF(B43>1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,{"$f":"+IF(B43>0,(B43*G43),0)","v":0},{"$f":"IF(B43>0,\"Man Hours\",\"\")","v":""},0,{"$f":"+IF(A43=\"\",J43*L43,0)","v":0},{"$f":"+IF(A43=\"T\",J43*L43,0)","v":0}]
[null,null,null,null,null,"@",null,{"$f":"IF(B44>0,IF(B44>1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,{"$f":"+IF(B44>0,(B44*G44),0)","v":0},{"$f":"IF(B44>0,\"Man Hours\",\"\")","v":""},0,null,{"$f":"+IF(A44=\"T\",J44*L44,0)","v":0}]
[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,{"$f":"IF(AND(A45=FALSE,ISBLANK(B45)),\"No Reporting? Clear L45\",IF(A45=TRUE,IF(B45<>0,\"Compliance Report Fee\",\"Missing B45 count\"),\"A45 is unChecked\"))","v":"No Reporting? Clear L45"},null,"-Fold"]
[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,{"$f":"IF(AND(A46=FALSE,ISBLANK(B46)),\"No Utility Reporting? Clear L46\",IF(A46=TRUE,IF(B46<>0,\"Compliance Report Fee\",\"Missing B46 count\"),\"A46 is unChecked\"))","v":"No Utility Reporting? Clear L46"}]
[]
[null,null,null,"DUE WHEN",null,null,"NUMBER ON PROPERTY",null,null,"CODE"]
["EXTINGUISHER",null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L49=TRUE,SUM(M42:M44)+SUM(N42:N44),0)","v":0},null,{"$f":"IF(L49=TRUE,\"yes\",\"no\")","v":"no"}]
[null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L50=TRUE,ROUNDUP((+M38+N38)*P50,0),0)","v":0},null,{"$f":"+rngMarkUp","v":0.08},"<- ALWAYS. On subTotals in M38 & N38"]
["Alarms",null,null,null,null,null,null,null,null,null,null,true,"Travel/Transport",30,null,"<- To Tech for his/her vehicle & their travel cost"]
["EM / EX LIGHTING",null,null,null,null,null,null,null,null,null,null,false,"Freight",{"$f":"IF(L52=TRUE,ROUNDUP(rngFreight*(M38+N38),0),0)","v":0},null,"<- Our charge to deliver"]
[null,null,null,null,null,null,null,null,null,null,null,false,"Handling",{"$f":"IF(L53=TRUE,ROUNDUP(rngHandling*(M38+N38),0),0)","v":0},null,"<- The folks that load it"]
["HOOD CLEANING",null,null,null,null,null,null,null,null,{"$f":"IF(N1=\"Invoice\",\"REFILE\",\"\")","v":"REFILE"},null,false,null,{"$f":"IF(L54=TRUE,ROUNDUP((+M38+N38)*7%,0),0)","v":0},null,"<- EPA regulation"]
[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=\"Quarterly\",EDATE($N$5,2),IF(H19=\"Monthly\",EDATE($N$5,1),\"No ReFile\"))))","v":"No ReFile"},null,{"$f":"IF(OR(AND(A45=TRUE,B45>0),AND(A46=TRUE,B46>0)),\"Reporting Fees\",\"\")","v":""},null,{"$f":"SUM(N45:N46)","v":0},null,{"$f":"IF(OR(AND(A45=TRUE,B45>0),AND(A46=TRUE,B46>0)),\"Reporting Fees\",\"\")","v":""},null,{"$f":"IF((OR(AND(A45=TRUE,B45<>0),AND(A46=TRUE,B46<>0))),\"Clear the Reporting A Column\",\"blank\")","v":"blank"}]
["RISER",null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L56=TRUE,(((+M38+N38)+SUM(N49:N55))*P56),\"\")","v":""},null,0.03,"AmEx"]
[null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(L57=TRUE,IF(N38>0,N38*rngTaxCity,0)+(SUM(N49:N56)*rngTaxCity),0)","v":0},null,"<- moveable assets only"]
["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"]
[null,null,"Cash","WORK AUTHORIZATION NUMBER",null,null,null,0,null,null,null,{"$f":"IF(N1=\"INVOICE\",\"TOTAL DUE\",\"Estimated at:\")","v":"TOTAL DUE"},{"$f":"SUM(N49:N57)+M38+N38","v":1630},null,null,"Type in the red cells and"]
[null,null,"Check","PURCHASE / WORK  ORDER NUMBER",null,null,null,"220526-0178",null,null,null,null,null,null,null,"the colour will dissappear"]
[null,null,"Credit Card","RECEIVED IN GOOD ORDER  AND ACCEPTED",null,null,null,null,null,null,null,"TIMES ARE CORRECT AND JOB COMPLETED SATISFACTORILY ",null,null,null,null,{"$f":"IF(N38>0,N38*rngTaxMillcreek,0)+SUM(N49:N56)","v":30}]
[null,null,null,"BY X",null,null,null,null,null,null,null,"CLAIMS WILL NOT BE HONORED AFTER TEN (10) DAYS FROM DATE"]
[null,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: 2021-03-26    21:20",null,null,null,null,{"$f":"IF(N1=\"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"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"=IF(AND(A45=FALSE,ISBLANK(B45)),\"BOTH MT\",IF(A45=TRUE,IF(B45<>0,\"Compliance Report Fee\",\"Missing B45 count\"),\"A45 is unChecked\"))"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A45=TRUE,IF(B45<>0,\"Compliance Report Fee\",\"Missing B45 count\"),\"A45 is unChecked\")","v":"A45 is unChecked"}]

{"sheet":"Calcs","index":1,"n_rows":118,"n_cols":12,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"rngTechList",null,null,null,null,null,null,null,null,"Service"]
[null,null,null,"rngTechList","rngLType","LNumber","TechInitial","ABPA"]
[]
[null,null,1,"ADangerfield","L1","S102811",{"$f":"LEFT(D7,2)","v":"AD"},"45-02227"]
[null,null,2,"Arun",null,null,"AUR"]
[null,null,3,"BGubler","HE",13,{"$f":"LEFT(D9,2)","v":"BG"}]
[null,null,4,"BHolbrook","HE",48,{"$f":"LEFT(D10,2)","v":"BH"}]
[null,null,5,"BNielson","HE",8687,{"$f":"LEFT(D11,2)","v":"BN"}]
[null,null,6,"Bonnie",null,null,{"$f":"LEFT(D12,1)","v":"B"}]
[null,null,7,"DCawley","HE",5355,{"$f":"LEFT(D13,2)","v":"DC"}]
[null,null,8,"Glenn","EE",1463,{"$f":"LEFT(D14,2)","v":"Gl"}]
[null,null,9,"HDangerfield","L3","S102811",{"$f":"LEFT(D15,2)","v":"HD"},"45-01369"]
[null,null,10,"JLeavitt","HE",11107,{"$f":"LEFT(D16,2)","v":"JL"}]
[null,null,11,"KCall","HE",111011,{"$f":"LEFT(D17,2)","v":"KC"}]
[null,null,12,"Kristen",null,null,{"$f":"LEFT(D18,1)","v":"K"}]
[null,null,13,"MKimball","AE",11131,{"$f":"LEFT(D19,2)","v":"MK"}]
[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,17,"Zach&Mike","AE","248/11131","ZM"]
[]
[null,null,null,{"$f":"\"There are \"&COUNTA(E25:AK25)&\" ranges\"","v":"There are 0 ranges"}]
[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,"rngTaxCity"]
[null,null,null,null,null,"Millcreek Tax"]
[null,null,null,null,null,7.2499999999999995E-2]
[]
[]
[null,null,null,null,"rngMarkUp"]
[null,null,null,null,null,"Ins&Misc"]
[null,null,null,null,null,0.08]
[]
[null,null,null,null,"rngHandling"]
[null,null,null,null,null,"Handling charge"]
[null,null,null,null,null,2.5000000000000001E-2]
[]
[]
[]
[null,null,null,null,"rngFreight"]
[null,null,null,null,null,"Freight Charge"]
[null,null,null,null,null,0.01]
[]
[]
[null,null,null,null,"rngInvoiceType"]
[]
[null,null,null,null,null,"BID ONLY"]
[null,null,null,null,null,"Estimate"]
[null,null,null,null,null,"INVOICE"]
[null,null,null,null,null,"Monitoring Invoice"]
[null,null,null,null,null,"Quote"]
[]
[]
[null,null,null,null,"rngtaxChoice"]
[]
[null,null,null,null,null,"T"]
[]
[null,null,null,null,"Contacts","cEmail"]
[null,null,null,null,"Invoice"]
[null,null,null,null,"Quote"]
[]
[]
[null,null,null,null,"rngTravel"]
[null,null,null,null,null,"Reimburse for travel"]
[null,null,null,null,null,0]
[null,null,null,null,null,15]
[null,null,null,null,null,30]
[null,null,null,null,null,35]
[null,null,null,null,null,40]
[null,null,null,null,null,45]
[null,null,null,null,null,55]
[]
[null,null,null,null,"rngItemsJob"]
[]
[null,null,null,null,null,"Alarms"]
[null,null,null,null,null,"Back flow preventor"]
[null,null,null,null,null,"eLites"]
[null,null,null,null,null,"Emergency D&G"]
[null,null,null,null,null,"Exhaust cleaning"]
[null,null,null,null,null,"Extinguishers"]
[null,null,null,null,null,"Fire Pump"]
[null,null,null,null,null,"Hydrants"]
[null,null,null,null,null,"Monitoring"]
[null,null,null,null,null,"Other"]
[null,null,null,null,null,"Suppression Chemical"]
[null,null,null,null,null,"Suppression Clean Agent"]
[null,null,null,null,null,"Suppression Sprinkler"]
[]
[null,null,null,null,"rngItemsSchedule"]
[]
[null,null,null,null,null,"01 Prelims"]
[null,null,null,null,null,"02 Mobilisation"]
[null,null,null,null,null,"03 Progress Payment"]
[null,null,null,null,null,"04 Installation"]
[null,null,null,null,null,"05 Finals"]
[null,null,null,null,null,"06 Repair"]
[null,null,null,null,null,"07 Inspection"]
[null,null,null,null,null,"08 Time & Materials"]
[null,null,null,null,null,"09 Invoice"]
[null,null,null,null,null,"10 Incurred Costs"]
[]
[]
[null,null,null,null,"rngPeriodicity"]
[]
[null,null,null,null,null,"Annual"]
[null,null,null,null,null,"Bi-Annual"]
[null,null,null,null,null,"Monthly"]
[null,null,null,null,null,"One-time"]
[null,null,null,null,null,"Quarterly"]

{"sheet":"Sheet1","index":2,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2022-07-27T11:49:00"]
[null,null,null,null,"Time"]
[null,null,null,null,"in hours","Man Hours"]
[null,null,null,null,{"$f":"SUM(E6:E14)","v":8},{"$f":"SUM(G6:G14)","v":0}]
[]
[null,"01 Waiting for Access",2,"Tekz",2,{"$f":"+C7*E7","v":4}]
[null,"02 Wiring & Devices",2,"Tekz",4,{"$f":"+C8*E8","v":8}]
[null,"03 Install Dialer",2,"Tekz",1,{"$f":"+C9*E9","v":2}]
[null,"04 Annual Insp",2,"Tekz",1,{"$f":"+C10*E10","v":2}]
[null,null,null,null,null,{"$f":"+C11*E11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2022-03-21 Telgian WM1573 CLA-Val Assessment Inv 23#### $2250"]
[null,null,null,null,null,"2022-03-20 Monitoring S1##### Owner Site Street Inv ###### $$$$"]
[]
[1,"rngItemsJob","=Calcs!$F$74:$F$85",null,1,"rngItemsJob","=Calcs!$K$73:$K$84"]
[{"$f":"+A25+1","v":2},"rngItemsSchedule","=Calcs!$F$88:$F$97",null,{"$f":"+E25+1","v":2},"rngItemsSchedule","=Calcs!$K$87:$K$96"]
[{"$f":"+A26+1","v":3},"rngPeriodicity","=Calcs!$F$101:$F$106",null,{"$f":"+E26+1","v":3},"rngPeriodicity","=Calcs!$K$100:$K$104"]
[4,"rngPrintCalcs","=Calcs!$C$4:$AL$107",null,4,"rngPrintCalcs","=Calcs!$C$4:$Z$70"]
[5,"rngTechList","=Calcs!$D$7:$D$23",null,5,"rngTechList","=Calcs!$D$7:$D$22"]
[]
[{"$f":"+A29+1","v":6},"rngLType","=Calcs!$E$7:$E$23",null,{"$f":"+E29+1","v":6},"LType","=Calcs!$E$7:$E$22"]
[7,"rngTCE","=Calcs!$F$28:$F$31",null,7,"rngTCE","=Calcs!$K$28:$K$31"]
[8,"LNumber","=Calcs!$F$7:$F$23",null,8,"LNumber","=Calcs!$F$7:$F$22"]
[9,"rngTechInitial","=Calcs!$G$7:$G$23",null,9,"TechInitial","=Calcs!$G$7:$G$22"]
[10,null,null,null,10]
[]
[{"$f":"+A35+1","v":11},"rngTaxCity","=Calcs!$F$36",null,{"$f":"+E35+1","v":11}]
[12,"rngTaxMillcreek","=Calcs!$F$36",null,12,"rngTaxMillcreek","=Calcs!$K$34"]
[13,"rngMarkUp","=Calcs!$F$41",null,13,"rngMarkUp","=Calcs!$K$39"]
[14,"rngHandling","=Calcs!$F$45",null,14,"rngHandling","=Calcs!$K$44"]
[15,"rngFreight","=Calcs!$F$51",null,15,"rngFreight","=Calcs!$K$51"]
[]
[{"$f":"+A41+1","v":16},"rngtaxChoice","=Calcs!$F$55:$F$56",null,{"$f":"+E41+1","v":16},"rngtaxChoice","=Calcs!$K$54:$K$55"]
[17,"Contacts","=Calcs!$E$59:$E$60",null,17,"Contacts","=Calcs!$J$58:$J$59"]
[18,"cEmail","=Calcs!$F$59:$F$60",null,18,"cEmail","=Calcs!$K$58:$K$59"]
[19,"rngTravel","=Calcs!$F$65:$F$71",null,19,"rngTravel","=Calcs!$K$64:$K$70"]
[20,"rngPrnInvoice","=Invoice!$A$1:$N$69",null,20,"rngPrnInvoice","=Invoice!$A$1:$N$69"]
[]
[{"$f":"+A47+1","v":21},"rngInvIndex","=Invoice!$U$1",null,{"$f":"+E47+1","v":21},"InvIndex","=Invoice!$U$1"]
[22,"InvTechName","=Invoice!$U$2",null,22,"InvTechName","=Invoice!$U$2"]
[23,"InvLicType","=Invoice!$U$3",null,23,"InvLicType","=Invoice!$U$3"]
[24,"InvLicNumber","=Invoice!$U$4",null,24,"InvLicNumber","=Invoice!$U$4"]
[25,"InvTecInit","=Invoice!$U$5",null,25,"InvTecInit","=Invoice!$U$5"]
[]
[{"$f":"+A53+1","v":26},"rngRateFire","=Invoice!$U$8",null,{"$f":"+E53+1","v":26},"rngRateFire","=Invoice!$Q$13"]
[27,"rngRateBurg","=Invoice!$U$9",null,27,"rngRateBurg","=Invoice!$Q$14"]
[28,"rngInvoiceType","=Calcs!$F$55:$F$60",null,28,"rngInvoiceType","=Calcs!$K$108:$K$113"]
[null,null,null,null,29,"rngAcctMonitor","=Invoice!$Q$11"]
[null,"rngABPAlicence","=Calcs!$H$7:$H$23"]