{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Invoice","Calcs","Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":42,"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":27,"rows_kept":69,"cut":false,"hidden":false,"merged":[[48,11,48,12],[6,0,11,0],[12,6,12,8],[9,1,9,8],[14,0,14,1],[15,4,15,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],[48,0,49,2],[48,3,49,4],[48,5,49,5],[15,6,15,8],[36,2,36,10],[33,2,33,10],[14,7,14,8],[31,2,31,10],[27,2,27,10],[26,2,26,10],[28,2,28,10],[16,2,16,3],[34,2,34,10],[15,2,15,3],[20,7,20,10],[20,2,20,6],[19,7,19,8],[12,4,12,5],[14,2,14,3],[17,7,17,8],[18,7,18,8],[24,2,24,10],[23,4,23,10],[16,0,16,1],[0,12,1,13],[1,4,1,11],[2,4,2,11],[0,4,0,11],[7,1,7,8],[7,10,7,13],[6,9,11,9],[6,1,6,8],[6,10,6,13],[9,10,9,13],[10,10,10,13],[8,10,8,11],[8,1,8,4],[8,5,8,6],[8,7,8,8],[13,4,13,5],[13,6,13,8],[11,10,11,13],[10,2,10,8],[15,0,15,1],[61,0,61,2],[55,0,56,2],[53,0,54,2],[12,2,12,3],[29,2,29,10],[30,2,30,10],[25,2,25,10],[16,4,16,8],[37,2,37,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],[12,0,12,1],[13,2,13,3],[44,2,44,10],[18,1,18,3],[19,1,19,3],[38,2,38,10],[35,2,35,10],[14,4,14,5],[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],[49,11,49,12]]}
[null,null,null,null,"Fire Suppression Services, Inc.",null,null,null,null,null,null,null,"INVOICE",null,"<-",1,"Select DocType"]
[null,null,null,null,"3802 South 2300 East",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     <--- re calculate the sheet"]
[null,null,null,null,"Millcreek, Utah  84109-3421",null,null,null,null,null,null,null,{"$f":"+InvTecInit","v":"AUR"},238548,"<-",2,"Enter Invoice number\n        else leave blank if Quote/Estimate","3. Choose Sales person"]
[null,null,null,null,"801.277.6464  •  800.273.6465",null,null,null,null,null,null,null,null,null,"->",3,"   ====>         ====>            ====>"]
[null,null,null,null,"Contractor License No. 92-252208-5501",null,null,null,null,null,null,null,"DATE","2026-01-16","<-",4,"Enter Invoice Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M1=\"invoice\",\"DUE:\",\"EXPIRES:\")","v":"DUE:"},{"$f":"IF(M1=\"invoice\",N5+21,+N5+30)","v":"2026-02-06"}]
["BILLING","DFS Construction, Inc.",null,null,null,null,null,null,null,"JOB SITE","Omega Pools Park East III",null,null,null,"<-",5,"Enter Billing and Site addresses. Note? -->",null,4]
[null,"PO Box 17577",null,null,null,null,null,null,null,null,"41516 North Forestdale Dr. Suite 47"]
[null,"Holladay",null,null,null,"Utah",null,84117,null,null,"Park City/Snyderville",null,"Utah",84098,null,null,null,"Cell E66 check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F69","v":"THIS INVOICE  IS  ALSO YOUR STATEMENT"}]
[null,"Ref: Billing Contact name","Forest Seaman",null,null,null,null,null,null,null,null,null,null,null,"<-",6,"Enter Contact info",{"$f":"+IF(M62>0,\"Total:  $\"& TEXT(SUM(M62:M62),\"#,##0.00;;;\"),\"\")","v":"Total:  $4,400.00"}]
[]
[null,null,"Billing",null,"Job Site",null,null,null,null,null,{"$f":"IF(OR(K14=\"Arun\",K14=\"Bonnie\",K14=\"Kristen\",K14=\"Office 10\",K14=\"Office 23\"),\"Sales\",\"TECHNICIAN\")","v":"Sales"},{"$f":"IF(L14=\"\",\"\",\"Licence\")","v":""}]
["CONTACT",null,"D. Forest Seaman",null,null,null,null,null,null,null,{"$f":"+InvTechName","v":"Arun"},{"$f":"InvLicType","v":""},{"$f":"+InvLicNumber","v":""}]
["OFFICE"]
["CELL",null,8019184604,null,null,null,"Send to  eMail:",null,null,null,null,null,null,null,"<-",7,"Enter Contact phone numbers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<-",8,"Enter Contact eMail"]
[null,"Division",null,null,null,"Schedule",null,"Periodicity",null,null,null,"Mileage One-Way",35,"TIME"]
[null,"Suppression Sprinkler",null,null,null,"01 Prelims",null,"One-time",null,null,null,"Drive Time One-Way",{"$f":"IF(M18=0,\"\",((M18/60)*60)&\" mins\")","v":"35 mins"},"00:00:00","<-",9,"Select Division, Inspection,  Periodicity  from the DropDown Selection Lists."]
[null,null,null,null,null,null,null,null,null,null,null,"UNIT PRICE","NON TAX","TAXABLE",null,10,"If this is an Alarm a/c & we monitor it, enter account number below:"]
[null,"#",null,null,null,null,null,{"$f":"+N5","v":"2026-01-16"},null,null,null,null,null,null,null,null,"Select LineCard below","Enter Acct# below"," =OR($Q$22<=0,LEN(Q22)=0,ISNONTEXT(Q22))\\",null,null,null,null,null,null,"Rate"]
[null,null,{"$f":"+IF(AND(OR(B19=\"Monitoring\",(B19=\"Alarms\")),R22<>\"\",Q22<>\"\"),\"CMS Account: \"&Q22&\"-\"&R22&\"  <<-  monitoring account number\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A22=\"T\",B22*L22,\"\")","v":""},"_ fold",null,null,null,{"$f":"IF(B19=\"Monitoring\",\"<<= Enter Monitoring Acc#\",\"\")","v":""},null,null,null,null,null,"Fire",60," rngRateFire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(A23=\"T\",B23*L23,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Burg",50," rngRateBurg"]
["T",null,"SUMMARY",null,null,null,null,null,null,null,null,null,{"$f":"+IF(ISBLANK(A24),B24*L24,\"\")","v":""},0]
[null,null,"Hydraulic Calculations and Design",null,null,null,null,null,null,null,null,0,{"$f":"+IF(ISBLANK(A25),B25*L25,\"\")","v":0},"",null,null,"ReFile check cells",{"$f":"+IF(M70>0,\"Total  $\"& TEXT(SUM(M70:M70),\"#,##0.00;;;\"),\"\")","v":""}]
[null,null,"CAD drawing Design and prepare drawings and Submittals to AHJ for Permiting",null,null,null,null,null,null,null,null,null,0,"",null,null,{"$f":"J55","v":"No ReFile"},{"$f":"IF(OR(M1=\"INVOICE\",M1=\"Monitoring Invoice\"),\"Re-file date:-   \" &TEXT(J55,\"yyyy-mmm \"),\"\")","v":"Re-file date:-   No ReFile"},null,"<- fix this to account for 5-year refile"]
[null,1,"AKA DS&P",null,null,null,null,null,null,null,null,4400,4400,"",null,null,{"$f":"IF(H19<>\"\",H19,\"\")","v":"One-time"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,0,0,"",null,null,"ReFile check:-",{"$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"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,{"$f":"H19","v":"One-time"}]
[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,"Updates here? Transfer to MasterBAK Documents masters invoice",null,null,"😉"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,"       F:\\Documents\\MASTERS\\Invoice\\[Latest date folder]"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+IF(A35=\"T\",B35*L35,\"\")","v":""}]
[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(A38=\"T\",J38*L38,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"SUBTOTALS:",{"$f":"SUM(M21:M38)","v":4400},{"$f":"SUM(N21:N38)","v":0}]
[]
[null,null,"Tech hours"]
[null,false,{"$f":"IF(B42=TRUE,\"Tech/s\",\"\")","v":""},null,null,"@",null,{"$f":"IF(B42=TRUE,IF(E42>=1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,{"$f":"IF(B42=TRUE,+E42*G42,\"\")","v":""},{"$f":"IF(B42=TRUE,\"Man Hours @\",\"\")","v":""},{"$f":"IF(B42=TRUE,125,0)","v":0},{"$f":"+IF(B42=TRUE,IF(A42=\"\",J42*L42,\"\"),\"\")","v":""},{"$f":"+IF(A42=\"T\",B42*L42,\"\")","v":""},"<-",11,"If Tech worked at this site, First enter a CHECK in column B, then fill in the blue fields."]
[null,false,{"$f":"IF(B43=TRUE,\"Tech/s\",\"\")","v":""},null,null,"@",null,{"$f":"IF(B43=TRUE,IF(E43>=1,\"hours each is:\",\"hours is: \"),\"\")","v":""},null,{"$f":"IF(B43=TRUE,+E43*G43,\"\")","v":""},{"$f":"IF(B43=TRUE,\"Man Hours @\",\"\")","v":""},{"$f":"IF(B43=TRUE,125,0)","v":0},{"$f":"+IF(B43=TRUE,IF(A43=\"\",J43*L43,\"\"),\"\")","v":""},"","<-","11b","If Tech worked at this site, First enter a CHECK in column B, then fill in the blue fields."]
[null,false,{"$f":"IF(B44=TRUE,\"Tech/s\",\"\")","v":""},null,null,"@",null,{"$f":"IF(B44=TRUE,IF(E44>=1,\"OT hours each is:\",\"hours OT is: \"),\"\")","v":""},null,{"$f":"IF(B44=TRUE,+E44*G44,\"\")","v":""},{"$f":"IF(B44=TRUE,\"Man Hours @\",\"\")","v":""},{"$f":"IF(B44=TRUE,L43*1.5,0)","v":0},{"$f":"+IF(B44=TRUE,IF(A44=\"\",J44*L44,\"\"),\"\")","v":""},{"$f":"+IF(A44=\"T\",B44*L44,\"\")","v":""},"<-","11c","OVERTIME",null,null,"_FOLD"]
[false,null,{"$f":"IF(A45=TRUE,\"Compliance reporting fee: \",\"\")","v":""},null,null,null,null,null,null,null,null,0,{"$f":"+IF(A45=TRUE,IF(B45>0,B45*L45,\"number required in B45\"),\"\")","v":""},null,"<-",12,"If Compliance reporting, enter a CHECK in column A45 & a number in B45",null,null,null,{"$f":"IF(L45>0,IF(AND(A45=FALSE,ISBLANK(B45)),\"No Utility Reporting? Clear L45\",IF(A45=TRUE,IF(B45<>0,\"UTILITY Report Fee\",\"Missing B45 count\"),\"A45 is unChecked\")),\"\")","v":""}]
[false,null,{"$f":"IF(A46=TRUE,\"WATER Utility reporting fee: \",\"\")","v":""},null,null,null,null,null,null,null,null,0,{"$f":"+IF(A46=TRUE,IF(B46>0,B46*L46,\"number required in B46\"),\"\")","v":""},null,"<-",null,"Enter how many reporting fees in column B, then choose a fee from the DropDown in column L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINE 46:  If a Utility fee (BackFlow), Check Column A, enter a Count in column B LINE 46"]
[null,null,null,"DUE WHEN",null,"LAST COMPANY","NUMBER ON PROPERTY",null,null,"CODE",null,null,null,null,null,null,"         and select a fee from the DropDown in Column L",null,{"$f":"IF(L46>0,IF(AND(A46=FALSE,ISBLANK(B46)),\"No Utility Reporting? Clear L46\",IF(A46=TRUE,IF(B46<>0,\"UTILITY Report Fee\",\"Missing B46 count\"),\"A46 is unChecked\")),\"\")","v":""}]
["EXTINGUISHER",null,null,null,null,null,null,null,null,null,null,"Labour",null,{"$f":"IF(P49=TRUE,+SUM(M42:M44),\"\")","v":0},"<-",true,{"$f":"IF(L49=FALSE,\"If you have tech labour, enter a check here.\",\"Technician hours\")","v":"Technician hours"}]
[null,null,null,null,null,null,null,null,null,null,null,"Misc. Materials & Insurance",null,{"$f":"IF(P50=TRUE,ROUNDUP((+M39+N39)*8%,0),0)","v":0},"<-",false,"ALWAYS applied to subTotals in M38 & N38",{"$f":"+rngMMI","v":0.08}]
["Alarms",null,null,null,null,null,null,null,null,null,null,null,"Sales Tax",{"$f":"IF(N39>0,N39*rngTaxMillcreek,\"\")","v":""},"<-",null,"moveable assets only. Column A should show a 'T'"]
["EM / EX LIGHTING",null,null,null,null,null,null,null,null,null,null,0,"Travel/Transport",{"$f":"IF(L52>0,L52,P52)","v":0},"<-",null,"To Tech for his/her vehicle & their travel cost","https://www.dollartimes.com/road-trip/230"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Freight",{"$f":"IF(P53=TRUE,ROUNDUP(rngFreight*(M39+N39),0),0)","v":0},"<-",false,"Our charge to deliver"]
["HOOD CLEANING",null,null,null,null,null,null,null,null,{"$f":"IF(M1=\"Invoice\",\"REFILE\",\"\")","v":"REFILE"},null,null,"Handling",{"$f":"IF(P54=TRUE,ROUNDUP(rngHandling*(M39+N39),0),0)","v":0},"<-",false,"The folks that load it"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H19=\"5-Year\",EDATE($N$5,60),IF(H19=\"Annual\",EDATE($N$5,12),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"},null,null,"HAZ-MAT Disposal",{"$f":"IF(P55=TRUE,ROUNDUP((+M39+N39)*7%,0),0)","v":0},"<-",false,"EPA regulation"]
["RISER",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A45=TRUE,A46=TRUE),\"Total Compliance reporting\",\"\")","v":""},null,{"$f":"SUM(M45:M46)","v":0},null,null,"https://www.xelplus.com/excel-checkboxes/"]
[]
["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,"OMEGPC-DFS",null,null,null,{"$f":"IF(M1=\"INVOICE\",\"TOTAL DUE\",\"Estimated at:\")","v":"TOTAL DUE"},{"$f":"M39+N39+N39+SUM(N48:N57)","v":4400},null,"<-",null,{"$f":"IF(AND($M$1=\"Invoice\",LEN(H62)=0),\"Type Work Auth number in the red cells and\",\"Work Auth entered or not required\")","v":"Work Auth entered or not required"}]
[null,null,null,"PURCHASE / WORK  ORDER NUMBER",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($M$1=\"Invoice\",LEN(H62)=0),\"the colour will dissappear\",\"\")","v":""}]
["  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"]
[]
[{"$f":"\"Rev: \"&Calcs!D1 &\", \" &TEXT(Calcs!F1,\"yyyy-mm-dd  \") &TEXT(Calcs!G1,\"hh:mm\")","v":"Rev: 11, 2025-11-26  11:25"},null,null,null,null,{"$f":"IF(M1=\"INVOICE\",\"THIS INVOICE  IS  ALSO YOUR STATEMENT\",\"QUOTE / ESTIMATE ONLY\")","v":"THIS INVOICE  IS  ALSO YOUR STATEMENT"},null,null,null,null,{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"2026-01-13 DFS Construction Omega Pools DS&P Inv 238548 $4400.xlsm"},null,null,"THANK YOU"]

{"sheet":"Calcs","index":1,"n_rows":175,"n_cols":47,"rows_kept":175,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"getver()","v":11},{"$f":"GetSubVer()","v":1115},{"$f":"GetVerDate()","v":"2025-11-26T11:25:00"},{"$f":"GetVerTime()","v":"11:25:00"},null,null,null,null,null,null,null,null,null,null,null,"InvIndex",3]
[null,null,true,{"$f":"IF(C2=TRUE,\" Same as Site Address\",\" Billing address differs from site address\")","v":" Same as Site Address"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InvTechName",{"$f":"INDEX(TechList,InvIndex)","v":"Arun"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"InvLicType",{"$f":"IF(INDEX(LType,InvIndex)>0,INDEX(LType,InvIndex),\"\")","v":""}]
[null,null,"rngTechList",null,null,"ref:  https://firemarshal.utah.gov/licensees/",null,null,null,null,null,"Service",null,null,null,null,null,null,"InvLicNumber",{"$f":"IF(INDEX(LNumber,InvIndex)>0,INDEX(LNumber,InvIndex),\"\")","v":""}]
[null,null,null,"TechList","LType","LNumber","TechInitial",null,null,null,null,null,null,null,null,null,null,null,"InvTecInit",{"$f":"INDEX(TechInitial,InvIndex)","v":"AUR"}]
[]
[null,null,0,null,null,null,{"$f":"LEFT(D7,2)","v":""}]
[null,null,1,"ADangerfield","L1","S102811",{"$f":"LEFT(D8,2)","v":"AD"}]
[null,null,2,"Arun",null,null,"AUR"]
[null,null,3,"BHolbrook","EE/HE",48,{"$f":"LEFT(D10,2)","v":"BH"}]
[null,null,5,"BNielson","HE/FE/KE",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,"GMusick","EE",1463,"GM"]
[null,null,9,"GWilliams","EE/HE",166866,"GW"]
[null,null,11,"HDangerfield","L3","S102811","HD"]
[null,null,12,"JLeavitt","EE/HE/KE",11107,"JL"]
[null,null,13,"KCall","EE/HE",111011,"KC"]
[null,null,14,"KGilson","AE",178466,{"$f":"LEFT(D19,2)","v":"KG"}]
[null,null,15,"Kristen",null,null,{"$f":"LEFT(D20,1)","v":"K"}]
[null,null,16,"NPehrson",null,null,{"$f":"LEFT(D21,2)","v":"NP"}]
[null,null,17,"RPerez","EE/HE/KE",61881,{"$f":"LEFT(D22,2)","v":"RP"}]
[null,null,18,"Office 10",null,null,{"$f":"LEFT(D23,1)&\" 10\"","v":"O 10"}]
[null,null,19,"Office 23",null,null,{"$f":"LEFT(D24,1)&\" 23\"","v":"O 23"}]
[null,null,20,"RBooth","EE/HE/SE",90101,{"$f":"LEFT(D25,2)","v":"RB"}]
[null,null,21,"TStrickland","HE/EE",3638,{"$f":"LEFT(D26,2)","v":"TS"}]
[null,null,22,"ZHagblom","AE/NICET",248,{"$f":"LEFT(D27,2)","v":"ZH"}]
[]
[]
[null,null,null,null,"rngTCE"]
[null,null,null,null,null,"TCE SP"]
[null,null,null,null,null,0]
[null,null,null,null,null,38]
[null,null,null,null,null,50]
[null,null,null,null,null,55]
[]
[null,null,null,null,null,null,null,"rngTaxMillcreek","ref:   https://tax.utah.gov/salestax/rate/25q2combined.pdf"]
[null,null,null,null,null,null,null,null,"Millcreek Tax",null,"Citycode is18-094"]
[null,null,null,null,null,null,null,null,{"$f":"+K39","v":7.4499999999999997E-2},null,{"$f":"(4.85+1+0.25+0.3+0.25+0.25+0.25+0.2+0.1)%","v":7.4499999999999997E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"rngMarkUp"]
[null,null,null,null,null,null,null,null,null,null,null,"MiscMaterials&Insurance"]
[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,"rngHandling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handling charge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[]
[]
[]
[]
[null,null,null,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,null,null,null,"Freight Charge"]
[null,null,null,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,null,null,null,"rngtaxChoice"]
[]
[null,null,null,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,null,null,null,"Contacts","cEmail"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invoice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quote"]
[]
[]
[null,null,null,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,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,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,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,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,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,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,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,null,null,null,55]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngItemsJob"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alarms"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back flow preventor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eLites"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency D&G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhaust cleaning"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extinguishers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monitoring"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suppression Chemical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suppression Clean Agent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suppression Sprinkler"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngItemsSchedule"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01 Prelims"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02 Mobilisation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03 Progress Payment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04 Installation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05 Finals"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06 Repair"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07 Inspection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08 Time & Materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09 Invoice"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngPeriodicity"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bi-Annual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"One-time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-Year"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngPricingDialers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NapCo Starlink"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank",405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,505]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngLineCardAbbreviations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0R"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SG"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rngStateList"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Wyoming"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Idaho"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alabama"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alaska"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arizona"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arkansas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"California"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colorado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connecticut"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delaware"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Florida"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Georgia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hawaii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Illinois"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indiana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iowa"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kansas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kentucky"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Louisiana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maryland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Massachusetts"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michigan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minnesota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mississippi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Missouri"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nebraska"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Hampshire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Jersey"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Mexico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New York"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ohio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oklahoma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oregon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rhode Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South Carolina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tennessee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texas"]

{"sheet":"Notes","index":2,"n_rows":102,"n_cols":8,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Rev: 2025-11-05    15:00","May Print mod changes"]
[]
[]
[null,null,"Rev: 2025-09-25    13:20","Added IF statement to Column L Tech hours"]
[]
[null,null,"Rev: 2025-09-23    14:00","Added Print button"]
[null,null,null,null,"The cursor for an ActiveX button will remain the same - a North West facing arrow."]
[null,null,null,null,"The Forms button cursor will change to a hand with the index finger extended"]
[null,null,"Rev: 2025-09-04    14:45","Moved prnInvoice to its own subRoutine, and resolved the PrintWhat to 'Selection' dot."]
[null,null,null,null,"response = PrintDialog.Show(, , , , , , , , , , , 1)"]
[null,null,"Rev: 2025-08-14    12:15","Moved check boxes off the printed page to the right of the amount cells"]
[null,null,null,"And ajusted their formulae and cell references"]
[]
[null,null,"Rev: 2025-07-18    09:00","Changed ReFile formula annual from 10 to 12 months"]
[null,null,null,"Added side-note: moveable assets only. Column A should show a 'T'"]
[]
[null,null,"Rev: 2025-05-17    22:30","Alt-F-T  >Formulas  > turned off background error checking"]
[]
[null,null,"Rev: 2025-03-18    08:30","Checking Name and address cells"]
[null,null,null,null,{"$f":"OR($B$19=\"Company Name\",LEN(B19)=0,ISNONTEXT(B19))","v":true}]
[null,null,null,null,"=AND($B$7=\"Company Name\",OR(LEN(B7)=0,ISTEXT(N3)))"]
[]
[]
[null,null,"Rev: 2025-03-13    09:30","Conditional formatting:"]
[null,null,null,"Added test for cell M1=Invoice, and if so, make Work Auth Cell RED fill"]
[null,null,null,"If cell M1= Estimate, make Work Auth cell no fill"]
[]
[null,null,null,"Added 5-Year to Periodicity range in Calcs sheet"]
[null,null,null,"Removed FAX number from letterhead"]
[null,null,null,"Removed Mike Kimbal from Tech range in Calcs sheet. Added Kolby"]
[]
[]
[]
[]
[]
[null,null,"Last Rev: 2020-08-08    10:15","Cell M1 affects cell H62 Work Auth cell, F69 and L62"]
[null,null,null,"F69","=IF(M1=\"INVOICE\",\"THIS INVOICE  IS  ALSO YOUR STATEMENT\",\"Quote/Estimate ONLY\")"]
[null,null,null,"H62","The Work Auth input cell:-     Data validation:  =AND($M$1=\"Invoice\",LEN(H62)=0)      If cell M1 contains Quote or Bid, then M62 will have NoFill"]
[null,null,null,"J54","=IF(M1=\"Invoice\",\"REFILE\",\"\")"]
[null,null,null,"L62","=IF(M1=\"INVOICE\",\"TOTAL DUE\",\"Estimated at:\")"]
[null,null,null,"M6","=IF(M1=\"invoice\",\"DUE:\",\"EXPIRES:\")"]
[null,null,null,"N6","=IF(M1=\"invoice\",N5+21,+N5+30)"]
[null,null,null,"Q8","=IF(AND(M1=\"Invoice\",G18=TRUE),EDATE(N5,10),\"\")"]
[null,null,null,"Q9","=IF(M1=\"invoice\",\"Re-file date:-   \" &TEXT(J55,\"yyyy-mmm\"),\"\")"]
[]
[]
[null,null,null,"Q11","=+IF(M62>0,\"Total  $\"& TEXT(SUM(M62:M62),\"#,##0.00;;;\"),\"\")     What ever is in M62 is shown in Q11"]
[]
[]
[null,null,null,"Cell N5 affects"]
[null,null,null,"N6"," =IF(M1=\"invoice\",N5+21,+N5+30)     "]
[null,null,null,"Q8"," =IF(AND(M1=\"Invoice\",G18=TRUE),EDATE(N5,10),\"\")"]
[null,null,null,"P18"," =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\"))))"]
[null,null,null,"H21"," =+N5     format: ddd, mmm, dd, yyyy"]
[null,null,null,"J55"," =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\"))))"]
[]
[null,null,null,"Q19"," =H19"]
[null,null,null,"Q18"," =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\"))))"]
[]
[null,null,null,"Cell H19 affects:"]
[null,null,null,"J55"," =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\"))))"]
[null,null,null,"Q18"," =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\"))))"]
[null,null,null,"Q19"," =H19"]
[]
[]
[]
[]
[null,null,null,"M42"," =+IF(B42=TRUE,IF(A42=\"\",J42*L42,\"\"),\"\")"]
[null,null,null,null,"Affects cell N49:    =IF(L49=TRUE,+M42,\"\")"]
[]
[null,null,null,"F69"," = =IF(M1=\"INVOICE\",\"THIS INVOICE  IS  ALSO YOUR STATEMENT\",\"Quote/Estimate ONLY\")     Affects Cell Q10"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Last Rev: 2025-04-02    11:15",null,null,"Cell format is:","Positive;Negative;Zero  the semi-colon is the separator"]
[null,null,null,null,null,"i.e:","General; -general;;"]
[null,null,null,null,null,"Accounting where Negative is: Red and bracketed. And Where Zero is blank"]
[null,null,null,null,null,null,"_($* #,##0.00_);[Red]_($* (#,##0.00);_(* \"\"  \"\"??_);_(@_)"]
[null,null,null,null,null,null,123,-123]
[null,null,null,null,null,null,1234,-1234]
[null,null,null,null,null,null,12345,-12345]
[null,null,null,null,null,null,123456,-123456]
[]
[]
[]
[null,null,"Last Rev: 2025-04-15    15:15",null,null,"ReFile"]
[null,null,null,null,null,null,"=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\"))))"]
[]
[null,null,null,null,null,"5-Year","=IF(H19=\"5-Year\",EDATE($N$5,60),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\")))))"]
[]
[]
[null,null,null,null,null,null,"^\\d{5}(-\\d{4})?$","regex patern for zip or zip+4"]
[null,null,null,null,null,null,"Condit Format for Zip","=OR($H$9=\"Zip\",LEN(H9)=0,NOT(OR(AND(ISNUMBER(H9),LEN(H9)=5),AND(ISNUMBER(LEFT(H9,5)+0),MID(H9,6,1)=\"-\",ISNUMBER(RIGHT(H9,4)+0)))))"]
[]
[]
[]
[null,null,null,"Versioning","=\"Rev: \"&Calcs!D1 &\", \" &TEXT(Calcs!F1,\"yyyy-mm-dd  \") &TEXT(Calcs!G1,\"hh:mm\")"]