{"text_format":"3","workbook":"xlsx","n_sheets":26,"sheets":["FY22 BID Awards","001-Alum Sulfate  blnkt","002-25%Caustic Soda-Bulk blnkt","003-CedarClear -PAC blnkt","004-CedarFloc Polymer blnkt","005-Hydrated Lime blnkt","006-Hyper-Ion 9810 blnkt","007-IC 348 blnkt","008-IC 7284 blnkt","009-IC 7268SP6 blnkt","010-Liq Chlorine-150lbcyl-blnkt","011-Liq Chlorine-1toncyl-blnkt","012-Liq Lime-blnkt","013-Phosphate, Liq -blnkt","014-Magnifloc-blnkt","015-Pot Permanganate-blnkt","016-Soda Ash-blnkt","017-Sodium Chlorite-blnkt ","018-Sodium Permanganate-blnkt","019-Sod Silico Flouride-blnkt ","020-Caustic Soda 25%-Totes","021-Hyper-Ion 9810-Bulk blnkt","022-Nuchar Carbon-blnkt","023-Sodium Hypochlorite-blnkt","ACH-blnkt","Praestol A3040LTR-blnkt "],"not_rendered":{"images":1,"external_links":1,"defined_names":35},"read":"whole","date_system":"1900"}

{"sheet":"FY22 BID Awards","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7]]}
["         CITY OF GRIFFIN               "]
["RECOMMENDED AWARDS FOR FY22-FY23 WATER TREATMENT CHEMICALS"]
["ITB - 21-009"]
[]
["CHEMICALS: Description","Amount","UOM","Unit $","PO Total","PO","Company","FY22"]
["Caustic Soda (25%) -Totes",{"v":106000,"d":"106,000"},"wet lbs",{"$f":"'[1]Chemical Worksheet'!D4","v":0.12},{"$f":"B6*D6","v":{"v":12720,"d":"$12,720.00"}},null,{"$f":"'[1]Chemical Worksheet'!D2","v":"Brenntag"}]
["Caustic Soda (25%) -Bulk",{"v":775000,"d":"775,000"},"wet lbs",{"$f":"'[1]Chemical Worksheet'!P5","v":0.0686},{"$f":"B7*D7","v":{"v":53164.99999999999,"d":"$53,165.00"}},null,{"$f":"'[1]Chemical Worksheet'!P2","v":"Univar"}]
["Chemical Hydrated Lime 400",{"v":155000,"d":"155,000"},"dry lbs",{"$f":"'[1]Chemical Worksheet'!D6","v":0.233},{"v":36115,"d":"$36,115.00"},null,{"$f":"'[1]Chemical Worksheet'!D2","v":"Brenntag"}]
["Hyper-Ion 9810 -Totes (NO SUBS)",{"v":120000,"d":"120,000"},"wet lbs",0.45,{"v":54000,"d":"$54,000.00"},null,"Industrial","Sole Source"]
["Hyper-Ion 9810-Bulk (NO SUBS)",{"v":130000,"d":"130,000"},"wet lbs",0.27,{"v":35100,"d":"$35,100.00"},null,"Industrial","Sole Source"]
["IC-348 Polymer (NO SUBS)",{"v":6000,"d":"6,000"},"wet lbs",0.95,{"v":5700,"d":"$5,700.00"},null,"Industrial","RENEWAL"]
["IC-7268SP6 (NO SUBS)",{"v":19000,"d":"19,000"},"wet lbs",{"v":1.4,"d":"1.40"},{"v":26600,"d":"$26,600.00"},null,"Industrial","RENEWAL"]
["IC-7284 (NO SUBS)",{"v":2000,"d":"2,000"},"wet lbs",{"v":1.4,"d":"1.40"},{"v":2800,"d":"$2,800.00"},null,"Industrial","RENEWAL"]
["Liquid Chlorine (150-lb cyl)",8,"cyl",{"$f":"'[1]Chemical Worksheet'!D7","v":{"v":84.3,"d":"84.30"}},{"v":674.4,"d":"$674.40"},null,{"$f":"'[1]Chemical Worksheet'!D2","v":"Brenntag"}]
["Liquid Chlorine (1 Ton cyl)",28,"cyl",{"$f":"'[1]Chemical Worksheet'!D8","v":{"v":684,"d":"684.00"}},{"v":19152,"d":"$19,152.00"},null,{"$f":"'[1]Chemical Worksheet'!D2","v":"Brenntag"}]
["Liquid Lime (Burnett Lime Company *No Substitutions)",{"v":300000,"d":"300,000"},"wet lbs",0.057,{"v":17100,"d":"$17,100.00"},null,"Burnett Lime","RENEWAL"]
["Liquid Phosphate -Aquadene SK7870",{"v":65000,"d":"65,000"},"wet lbs",{"$f":"'[1]Chemical Worksheet'!F9","v":0.495},{"v":32175,"d":"$32,175.00"},null,{"$f":"'[1]Chemical Worksheet'!F2","v":"Carus Corp"}]
["Magnifloc LT7989 Flocculent",{"v":20000,"d":"20,000"},"wet lbs",{"$f":"'[1]Chemical Worksheet'!O10","v":1.045},{"v":20900,"d":"$20,900.00"},null,{"$f":"'[1]Chemical Worksheet'!O2","v":"Sterling Water"}]
["Aluminum Sulfate Solution",{"v":560000,"d":"560,000"},"wet lbs",{"$f":"'[1]Chemical Worksheet'!H11","v":0.0658},{"v":36848,"d":"$36,848.00"},null,{"$f":"'[1]Chemical Worksheet'!H2","v":"Chemtrade"}]
["Nuchar Carbon",{"v":11100,"d":"11,100"},"dry lbs",{"$f":"'[1]Chemical Worksheet'!G12","v":0.91},{"v":10101,"d":"$10,101.00"},null,{"$f":"'[1]Chemical Worksheet'!G2","v":"Chemrite"}]
["Poly Aluminum Chloride- CedarCLEAR 757 (NO SUBS)",{"v":956250,"d":"956,250"},"wet lbs",0.225,{"v":215156.25,"d":"$215,156.25"},null,"CedarCHEM","RENEWAL"]
["Polymer-CedarFLOC 510         (NO SUBS)",{"v":1250,"d":"1,250"},"dry lbs",2.75,{"v":3437.5,"d":"$3,437.50"},null,"CedarCHEM","RENEWAL"]
["Potassium Permanganate",{"v":6000,"d":"6,000"},"dry lbs",{"$f":"'[1]Chemical Worksheet'!G13","v":1.617},{"v":9702,"d":"$9,702.00"},null,{"$f":"'[1]Chemical Worksheet'!G2","v":"Chemrite"}]
["Soda Ash (50 lb bags)",{"v":30000,"d":"30,000"},"dry lbs",{"$f":"'[1]Chemical Worksheet'!I14","v":0.275},{"v":8250,"d":"$8,250.00"},null,{"$f":"'[1]Chemical Worksheet'!I2","v":"Colonial"}]
["Sodium Chlorite (25%) - Bulk",{"v":100000,"d":"100,000"},"wet lbs",0.539,{"v":53900,"d":"$53,900.00"},null,"ERCOPure","RENEWAL"]
["Sodium Fluorosilicate",{"v":42500,"d":"42,500"},"dry lbs",0.75,{"v":31875,"d":"$31,875.00"},null,"Industrial","Sole Source"]
["Sodium Hypochlorite (10-15% solution)",{"v":75000,"d":"75,000"},"gal",{"$f":"'[1]Chemical Worksheet'!J16","v":0.808},{"v":60600.00000000001,"d":"$60,600.00"},null,{"$f":"'[1]Chemical Worksheet'!J2","v":"DPC Enterprises"}]
["Sodium Permanganate 20%",{"v":3250,"d":"3,250"},"gal",{"$f":"'[1]Chemical Worksheet'!G17","v":9.099},{"v":29571.75,"d":"$29,571.75"},null,{"$f":"'[1]Chemical Worksheet'!G2","v":"Chemrite"}]
[]
[{"$nulls":6},"TOTAL",{"$f":"SUM(E6:E28)","v":{"v":775642.9,"d":"$775,642.90"}}]

{"sheet":"001-Alum Sulfate  blnkt","index":1,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,10,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Chemtrade Chemicals",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["90 East Halsey Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Parsippany, NJ  07054",{"$nulls":10},"Deliver to:"]
["cssorders@chemtradelogistics.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-631-8050",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null," Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-233-2974",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":25},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":560000,"d":"560,000"},null,"lbs",null,{"v":0.0658,"d":"0.066"},null,{"v":36848,"d":"36,848.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Aluminum Sulfate, Liquid ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[" delivered bulk",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[" ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":36848,"d":"36,848.00"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"002-25%Caustic Soda-Bulk blnkt","index":2,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Univar USA, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["8201 S 212th St",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Kent, WA 98032",{"$nulls":10},"Deliver to:"]
[{"$nulls":13},"City of Griffin"]
["Ph:","800-531-7106",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- (plant receiving shipmt)\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Ibn Shakir"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["(July 2021 - June 2022)",{"$nulls":9},"505","-","4333","-","53","-","1120","-","0000",775000,null,"lbs",null,{"v":0.0686,"d":"0.069"},null,{"v":53164.99999999999,"d":"53,165.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Caustic Soda (25%)-Bulk",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":53164.99999999999,"d":"53,165.00"}}]
["Ibn Shakir- 678-692-0408 x687"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY21"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"003-CedarClear -PAC blnkt","index":3,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["CedarChem",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["105 Plantation Ave",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Cedartown, GA  30125",{"$nulls":10},"Deliver to:"]
["adrienne.hess@cedarchem.com; heather.weeks@cedarchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-748-3863",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- (plant receiving shipmt)\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flat Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0407",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":956250,"d":"956,250"},null,"lbs",null,0.225,null,{"v":215156.25,"d":"215,156.25"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Poly Aluminum Chloride",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["CedarCLEAR 757 (no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":215156.25,"d":"215,156.25"}}]
["Mike Melton - 678-692-0407"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[" ",null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"004-CedarFloc Polymer blnkt","index":4,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["CedarChem",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["105 Plantation Ave",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Cedartown, GA  30125",{"$nulls":10},"Deliver to:"]
["adrienne.hess@cedarchem.com; heather.weeks@cedarchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-748-3863",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- (plant receiving shipmt)\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flat Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0407",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":1250,"d":"1,250"},null,"lbs",null,{"v":2.75,"d":"2.750"},null,{"v":3437.5,"d":"3,437.50"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["CedarFLOC 510 Polymer",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":3437.5,"d":"3,437.50"}}]
["Mike Melton - 678-692-0407"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[" ",null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"005-Hydrated Lime blnkt","index":5,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Brenntag Mid-South Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["3200 Moon Station Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Kennesaw, GA 30144",{"$nulls":10},"Deliver to:"]
["baustin@brenntag.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-377-9518",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-233-2974",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":155000,"d":"155,000"},null,"dry lbs",null,{"v":0.233,"d":"0.2330"},null,{"v":36115,"d":"36,115.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Chemical Hydrated Lime",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["50 lb bags",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":36115,"d":"36,115.00"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"006-Hyper-Ion 9810 blnkt","index":6,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Potato Creek"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"1150 County Line Rd"]
[{"$nulls":13},"Griffin, GA  30224"]
[]
[{"$nulls":11},"ATTN: ",null,"Robert Clark"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-229-6609",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4332","-","53","-","1120","-","0000",{"v":120000,"d":"120,000"},null,"lbs",null,{"v":0.45,"d":"0.4500"},null,{"v":54000,"d":"54,000.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Hyper-Ion 9810-Totes",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":54000,"d":"54,000.00"}}]
["Robert Clark- 770-229-6609 x491"]
["Send invoices to agolden@cityofgriffin.com"]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"007-IC 348 blnkt","index":7,"n_rows":51,"n_cols":34,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Potato Creek"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"1150 County Line Rd"]
[{"$nulls":13},"Griffin, GA  30224"]
[]
[{"$nulls":11},"ATTN: ",null,"Robert Clark"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-229-6609",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4332","-","53","-","1120","-","0000",{"v":6000,"d":"6,000"},null,"lbs",null,{"v":0.95,"d":"0.9500"},null,{"v":5700,"d":"5,700.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["IC 348",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":15}," "]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":5700,"d":"5,700.00"}}]
["Robert Clark- 770-229-6609 x491"]
["Send invoices to agolden@cityofgriffin.com"]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"008-IC 7284 blnkt","index":8,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Potato Creek"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"1150 County Line Rd"]
[{"$nulls":13},"Griffin, GA  30224"]
[]
[{"$nulls":11},"ATTN: ",null,"Robert Clark"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-229-6609",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4332","-","53","-","1120","-","0000",{"v":2000,"d":"2,000"},null,"lbs",null,{"v":1.4,"d":"1.4000"},null,{"v":2800,"d":"2,800.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["IC 7284",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":2800,"d":"2,800.00"}}]
["Robert Clark- 770-229-6609 x491"]
["Send invoices to agolden@cityofgriffin.com"]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"009-IC 7268SP6 blnkt","index":9,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Ibn Shakir / Robert Clark"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0408",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4333","-","53","-","1120","-","0000",{"v":12000,"d":"12,000"},null,"lbs",null,{"v":1.4,"d":"1.4000"},null,{"v":16800,"d":"16,800.00"}]
["(July 2021 - June 2022)",{"$nulls":9},"505","-","4332","-","53","-","1120","-","0000",{"v":7000,"d":"7,000"},null,"lbs",null,{"v":1.4,"d":"1.4000"},null,{"v":9800,"d":"9,800.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["IC 7268SP6",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
["VENDORS:  DUE TO MULTIPLE LOCATIONS, ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["PLEASE CONFIRM DELIVERY LOCATION ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["WITH EACH REQUEST IF NEEDED",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":26600,"d":"26,600.00"}}]
["Ibn Shakir- 678-692-0408 x687 / Robert Clark- 770-229-6609 x491"]
["Send invoices to agolden@cityofgriffin.com"]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"010-Liq Chlorine-150lbcyl-blnkt","index":10,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Brenntag Mid-South Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["3200 Moon Station Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Kennesaw, GA 30144",{"$nulls":10},"Deliver to:"]
["baustin@brenntag.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-377-9518",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-233-2974",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",8,null,"cyl",null,{"v":84.3,"d":"84.300"},null,{"v":674.4,"d":"674.40"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Liquid Chlorine ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["150 lb cylinders",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":674.4,"d":"674.40"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"011-Liq Chlorine-1toncyl-blnkt","index":11,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,10,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Brenntag Mid-South Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["3200 Moon Station Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Kennesaw, GA 30144",{"$nulls":10},"Deliver to:"]
["baustin@brenntag.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-377-9518",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":25},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",28,null,"cyl",null,{"v":684,"d":"684.000"},null,{"v":19152,"d":"19,152.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Liquid Chlorine ",{"$nulls":10},"-",null,"-",null,"-",null,"-",null,{"$f":"SUM($T$24*V29)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["1 ton cylinders",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":19152,"d":"19,152.00"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"012-Liq Lime-blnkt","index":12,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Burnett Lime Company",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["7095 HWY 11",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Campobello, SC 29322",{"$nulls":10},"Deliver to:"]
["hburnett@burnett-inc.com",{"$nulls":12},"City of Griffin"]
["Ph:","864-592-1658",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flat Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0407",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":300000,"d":"300,000"},null,"lbs",null,{"v":0.057,"d":"0.0570"},null,{"v":17100,"d":"17,100.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Liquid Lime-bulk",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":17100,"d":"17,100.00"}}]
["Mike Melton - 678-692-0407"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"013-Phosphate, Liq -blnkt","index":13,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,10,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Carus Corporation",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["315 Fifth St",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Peru, IL  61354",{"$nulls":10},"Deliver to:"]
["orders@caruscorporation.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-435-6856",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet   /  Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":10},"Total quantity:",{"$nulls":8},{"v":65000,"d":"65,000"},null,"wet lbs",{"$nulls":3},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":44000,"d":"44,000"},null,"wet lbs",null,0.495,null,{"v":21780,"d":"21,780.00"}]
["(July 2021 - June 2022)",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":21000,"d":"21,000"},null,"wet lbs",null,0.495,null,{"v":10395,"d":"10,395.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Liquid Phosphate",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["CARUS 8500",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
["VENDORS:  DUE TO MULTIPLE LOCATIONS, ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["PLEASE CONFIRM DELIVERY LOCATION ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["WITH EACH REQUEST IF NEEDED",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":32175,"d":"32,175.00"}}]
["Martha Drolet  - 770-233-2974  x647;        Mike Melton - 678-692-0407 x623"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"014-Magnifloc-blnkt","index":14,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Sterling Water Technologies",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["902 S High St",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Columbia, TN  38401",{"$nulls":10},"Deliver to:"]
["sales@sterlingwatertech.com",{"$nulls":12},"City of Griffin"]
["Ph:","931-540-1334",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":20000,"d":"20,000"},null,"wet lbs",null,{"v":1.045,"d":"1.0450"},null,{"v":20900,"d":"20,900.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Magnafloc LT7989 (no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["55 gal drums ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":20900,"d":"20,900.00"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"015-Pot Permanganate-blnkt","index":15,"n_rows":51,"n_cols":35,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Chemrite",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["5202 Belle Wood Court, Ste 104",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Buford, GA  30518",{"$nulls":10},"Deliver to:"]
["anne@chemrite.com / sales@chemrite.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-271-5576",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flat Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0407",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}},{"$nulls":8},{"$f":"SUM(T24*X25)","v":0}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":6000,"d":"6,000.00"},null,"lbs",null,{"v":1.617,"d":"1.6170"},null,{"$f":"SUM(T25*X25)","v":{"v":9702,"d":"9,702.00"}},{"$nulls":5},{"$f":"SUM(T24*0.72)","v":{"v":0,"d":"0.000"}}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(T26*X26)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"SUM(T24*0.26)","v":{"v":0,"d":"0.000"}}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T26*0.02)","v":{"v":0,"d":"0.000"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Potassium Permanganate",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["55-lb containers",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T25/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF30)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T26/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF31)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T27/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF32)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X35*T35)","v":{"v":0,"d":"0.00"}}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z25:AB36)","v":{"v":9702,"d":"9,702.00"}}]
["Mike Melton - 678-692-0407 x623"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"016-Soda Ash-blnkt","index":16,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Colonial Chemical Solutions, Inc",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["101 N Lathrop Ave",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Savannah, GA 31415",{"$nulls":10},"Deliver to:"]
["tbutler@colonialchemicals.com; ccsatlanta@colonialchemicals.com",{"$nulls":12},"City of Griffin"]
["Ph:","888-502-0318",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-233-2974",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":30000,"d":"30,000"},null,"lbs",null,{"v":0.275,"d":"0.2750"},null,{"v":8250,"d":"8,250.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Soda Ash (50-lb bags)",{"$nulls":10},"-",null,"-",null,"-",null,"-",null,{"$f":"SUM($T$24*V29)","v":0},{"$nulls":5},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":8250,"d":"8,250.00"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"017-Sodium Chlorite-blnkt ","index":17,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,10,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["International Dioxide, Inc. (ERCOPure)",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["40 Whitecap Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["North Kingstown, RI 02852",{"$nulls":10},"Deliver to:"]
["IDI.CS@ercoworldwide.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-477-6071",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":25},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":100000,"d":"100,000"},null,"wet lbs",null,0.539,null,{"v":53900,"d":"53,900.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Sodium Chlorite 25%",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":53900,"d":"53,900.00"}}]
["Martha Drolet  - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"018-Sodium Permanganate-blnkt","index":18,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Chemrite",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["5202 Belle Wood Court, Ste 104",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Buford, GA  30518",{"$nulls":10},"Deliver to:"]
["anne@chemrite.com / sales@chemrite.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-271-5576",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Harry Simmons Plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"229 N Expressway"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"770-233-2974",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":3250,"d":"3,250"},null,"gal",null,{"v":9.099,"d":"9.0990"},null,{"v":29571.75,"d":"29,571.75"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Sodium Permanganate 20%",{"$nulls":10},"-",null,"-",null,"-",null,"-",null,{"$f":"SUM($T$24*V29)","v":0},{"$nulls":5},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":29571.75,"d":"29,571.75"}}]
["Martha Drolet - 770-233-2974  x647"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"019-Sod Silico Flouride-blnkt ","index":19,"n_rows":51,"n_cols":29,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,10,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet  /  Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":10},"Total quantity:",{"$nulls":8},{"v":42500,"d":"42,500"},null,"lbs",{"$nulls":3},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":20000,"d":"20,000"},null,"lbs",null,{"v":0.75,"d":"0.7500"},null,{"v":15000,"d":"15,000.00"},null,null,{"v":0.5,"d":"0.50"}]
["(July 2021 - June 2022)",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":22500,"d":"22,500"},null,"lbs",null,{"v":0.75,"d":"0.7500"},null,{"v":16875,"d":"16,875.00"},null,null,{"v":0.5,"d":"0.50"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Sodium Silico Flouride",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["50-lb bags",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
["VENDORS:  DUE TO MULTIPLE LOCATIONS, ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["PLEASE CONFIRM DELIVERY LOCATION ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["WITH EACH REQUEST IF NEEDED",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":31875,"d":"31,875.00"}}]
["Martha Drolet - 770-233-2974  x647;    Mike Melton - 678-692-0407  x623"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"020-Caustic Soda 25%-Totes","index":20,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Brenntag Mid-South Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["3200 Moon Station Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Kennesaw, GA 30144",{"$nulls":10},"Deliver to:"]
["baustin@brenntag.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-377-9518",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Cabin Creek WPCP"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"1140 N Hill Street"]
[{"$nulls":13},"Griffin, GA  30224"]
[]
[{"$nulls":11},"ATTN: ",null,"Ibn Shakir"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0408",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4333","-","53","-","1120","-","0000",{"v":106000,"d":"106,000"},null,"wet lbs",null,{"v":0.12,"d":"0.1200"},null,{"v":12720,"d":"12,720.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["25% Caustic Soda",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["Totes",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":12720,"d":"12,720.00"}}]
["Ibn Shakir 678-692-0408"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"021-Hyper-Ion 9810-Bulk blnkt","index":21,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Industrial Chemical, Inc.",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["2042 Montreat Drive",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Vestavia, AL 35216",{"$nulls":10},"Deliver to:"]
["orders@industrialchem.com; dianekalina@industrialchem.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-476-2042",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Cabin Creek WPCP"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"1140 N Hill Street"]
[{"$nulls":13},"Griffin, GA  30224"]
[]
[{"$nulls":11},"ATTN: ",null,"Ibn Shakir"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0408",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4332","-","53","-","1120","-","0000",{"v":130000,"d":"130,000"},null,"lbs",null,{"v":0.27,"d":"0.2700"},null,{"v":35100,"d":"35,100.00"}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Hyper-Ion 9810-Bulk",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":35100,"d":"35,100.00"}}]
["Ibn Shakir 678-692-0408"]
["Send invoices to agolden@cityofgriffin.com"]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"022-Nuchar Carbon-blnkt","index":22,"n_rows":51,"n_cols":28,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["Chemrite",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["5202 Belle Wood Court, Ste 104",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Buford, GA  30518",{"$nulls":10},"Deliver to:"]
["anne@chemrite.com / sales@chemrite.com",{"$nulls":12},"City of Griffin"]
["Ph:","770-271-5576",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: appropriate water or wastewater plant"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"confirm location at time of order"]
[{"$nulls":13},"Griffin, GA  30223 "]
[]
[{"$nulls":11},"ATTN: ",null,"Martha Drolet  /  Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4431","-","53","-","1120","-","0000",{"v":3600,"d":"3,600"},null,"lbs",null,{"v":0.91,"d":"0.910"},null,{"v":3276,"d":"3,276.00"}]
["(July 2021 - June 2022)",{"$nulls":9},"505","-","4432","-","53","-","1120","-","000",{"v":7500,"d":"7,500"},null,"lbs",null,{"v":0.91,"d":"0.910"},null,{"v":6825,"d":"6,825.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Nuchar Carbon",{"$nulls":10},"-",null,"-",null,"-",null,"-",null,{"$f":"SUM($T$24*V29)","v":0},{"$nulls":5},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":{"v":10101,"d":"10,101.00"}}]
["Martha Drolet - 770-233-2974  x647;    Mike Melton - 678-692-0407  x623"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"023-Sodium Hypochlorite-blnkt","index":23,"n_rows":51,"n_cols":35,"rows_kept":51,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: ","2021-07-01"]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix."]
[{"$nulls":25},"Bid/Quote No.","21-009"]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["DPC Enterprises",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["P.O. Box 11447",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Chickasaw, AL 36671",{"$nulls":10},"Deliver to:"]
["tmoore@dxgroup.com; jskipper@dxgroup.com",{"$nulls":12},"City of Griffin"]
["Ph:","866-344-2781",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flat Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",null,"678-692-0407",{"$nulls":7},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}},{"$nulls":8},{"$f":"SUM(T24*X25)","v":0}]
["Water Treatment Chemicals for FY 2022",{"$nulls":9},"505","-","4432","-","53","-","1120","-","0000",{"v":75000,"d":"75,000"},null,"gallon",null,{"v":0.808,"d":"0.8080"},null,{"$f":"SUM(T25*X25)","v":{"v":60600.00000000001,"d":"60,600.00"}},{"$nulls":5},{"$f":"SUM(T24*0.72)","v":{"v":0,"d":"0.000"}}]
["(July 2021 - June 2022)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(T26*X26)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"SUM(T24*0.26)","v":{"v":0,"d":"0.000"}}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T26*0.02)","v":{"v":0,"d":"0.000"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["10-15% Sodium Hypochlorite-Bulk",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T25/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF30)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T26/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF31)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":5},{"$f":"SUM(T27/T24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T24*AF32)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X35*T35)","v":{"v":0,"d":"0.00"}}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z25:AB36)","v":{"v":60600.00000000001,"d":"60,600.00"}}]
["Mike Melton - 678-692-0407 x623"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:",{"$nulls":4},"Water/Wastewater FY22"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":"21-009"},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"ACH-blnkt","index":24,"n_rows":51,"n_cols":28,"rows_kept":51,"hidden":true,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: "]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix.",4432]
[{"$nulls":25},"Bid/Quote No."]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["General Chemical",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["90 East Halsey Rd",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["Parsippany, NJ  07054",{"$nulls":10},"Deliver to:"]
["bids@genchemcorp.com",{"$nulls":12},"City of Griffin"]
["Ph:","800-631-8050",{"$nulls":4},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\n\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flart Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Ernest Cousson / Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2015",{"$nulls":9},"505","-","4432","-","20","-","1120","-","0000",9,null,"loads",{"$nulls":3},{"v":0,"d":"0.00"}]
["(July 2014 - June 2015)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":3},"load=",{"$nulls":3},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":3},"4500 lbs",{"$nulls":3},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Polyaluminum Hydroxychlorosulfate ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(ACH)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
["VENDORS:  DUE TO MULTIPLE LOCATIONS, ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["PLEASE CONFIRM DELIVERY LOCATION ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["WITH EACH REQUEST ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":0}]
["Ernest Cousson/Mike Melton - 678-692-0407"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":0},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]

{"sheet":"Praestol A3040LTR-blnkt ","index":25,"n_rows":51,"n_cols":28,"rows_kept":51,"hidden":true,"merged":[[1,9,1,20],[2,9,2,20],[3,9,3,20],[3,26,3,27],[4,9,4,20],[4,26,4,27],[5,10,5,19],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[10,0,10,10],[10,12,10,26],[11,0,11,10],[11,13,11,25],[12,0,12,10],[13,0,13,10],[13,13,13,26],[14,1,14,5],[14,7,14,10],[14,13,14,26],[15,0,18,4],[15,5,18,10],[15,13,15,26],[16,13,16,26],[17,13,17,26],[18,11,18,12],[18,13,18,25],[19,0,19,10],[19,11,19,12],[19,13,19,19],[19,22,19,25],[20,0,20,27],[21,0,21,23],[21,24,21,25],[22,0,22,9],[22,10,22,18],[22,21,22,22],[22,23,22,24],[22,25,22,27],[23,0,23,9],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,27],[24,0,24,9],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,27],[25,0,25,9],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,27],[26,0,26,9],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,27],[27,0,27,9],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,27],[28,0,28,9],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,27],[29,0,29,9],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,27],[30,0,30,9],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,27],[31,0,31,9],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,27],[32,0,32,9],[32,19,32,20],[32,21,32,22],[32,23,32,24],[32,25,32,27],[33,0,33,9],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,27],[34,0,34,9],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,27],[35,5,35,9],[35,19,35,20],[35,21,35,22],[35,23,35,24],[35,25,35,27],[36,0,36,4],[36,5,36,9],[36,19,36,20],[36,21,36,22],[36,23,36,24],[36,25,36,27],[37,0,37,2],[37,3,37,20],[37,21,37,23],[37,24,37,27],[38,0,38,27],[39,0,39,27],[40,0,40,4],[40,23,40,24],[40,25,40,27],[41,0,41,4],[41,5,42,15],[41,16,42,27],[42,0,42,1],[43,0,43,1],[44,0,44,1],[44,2,44,4],[44,5,45,15],[44,16,45,27],[45,0,45,1],[45,2,45,4],[46,0,46,4],[47,0,47,1],[47,2,47,4],[47,5,48,15],[47,16,48,27],[48,0,48,4],[49,0,49,1],[49,2,49,4],[50,0,50,1],[50,2,50,4]]}
[]
[{"$nulls":9},"City of Griffin, Georgia"]
[{"$nulls":9},"100 S Hill Street"]
[{"$nulls":9},"P O Box T",{"$nulls":15},"DATE: "]
[{"$nulls":9},"Griffin, Georgia 30224"]
[{"$nulls":10},"(770) 229-6400",{"$nulls":14},"Purchase Order No."]
[{"$nulls":25},"suffix.",4432]
[{"$nulls":25},"Bid/Quote No."]
[{"$nulls":25},"Vendor No."]
["Vendor Name & Address"]
["company",{"$nulls":11},"Per Georgia State Code 48.8, the City of Griffin is tax exempt for sale and use"]
["attn / company",{"$nulls":12},"taxes. Georgia Sales & Use Tax Exemption No.  20006246313"]
["address",{"$nulls":10},"Deliver to:"]
[{"$nulls":13},"City of Griffin"]
["Ph:",{"$nulls":5},"Fax:",{"$nulls":6},"Dept: Still Branch"]
["Freight is FOB Destination\n\nDeliveries are accepted\nbetween the hours of \n8:00 a.m. and 4 p.m.",{"$nulls":4},"Mail all invoices* to:\nCity of Griffin\nAttn- Accounts Payable\nP O Box T\nGriffin, GA  30224",{"$nulls":7},"2045 Flart Shoals Rd"]
[{"$nulls":13},"Concord, GA  30206"]
[]
[{"$nulls":11},"ATTN: ",null,"Ernest Cousson / Mike Melton"]
["*Terms: Net 30 unless otherwise specified on PO",{"$nulls":10},"Phone: ",{"$nulls":9},"Fax:"]
["- - ANY CHANGE ORDERS TO ANY PO OR WORK ORDERS MUST BE AUTHORIZED IN WRITING AND APPROVED.  ALL INVOICES SUBMITTED FOR PAYMENT MUST REFERENCE A VALID PURCHASE ORDER NUMBER. - - "]
["- VENDORS MUST HAVE A CURRENT E-VERIFY AFFADAVIT ON FILE PRIOR TO PO PROCESSING -",{"$nulls":23},"On File?",null,"Y/N","Y"]
["Description",{"$nulls":9},"Account Number",{"$nulls":8},"Quantity",null,"UOM",null,"Unit Price",null,"Extended Totals"]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X24*T24)","v":{"v":0,"d":"0.00"}}]
["Water Treatment Chemicals for FY 2015",{"$nulls":9},"505","-","4432","-","20","-","1120","-","0000",6,null,"drums",{"$nulls":3},{"v":0,"d":"0.00"}]
["(July 2014 - June 2015)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":3},"drum=",{"$nulls":3},{"v":0,"d":"0.00"}]
["CHEMICALS:  BLANKET PO",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":3},"400lbs",{"$nulls":3},{"$f":"SUM(X27*T27)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X28*T28)","v":{"v":0,"d":"0.00"}}]
["Praeston A3040LTR",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X29*T29)","v":{"v":0,"d":"0.00"}}]
["(no substitutions)",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X30*T30)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"$f":"SUM(X31*T31)","v":{"v":0,"d":"0.00"}}]
["VENDORS:  DUE TO MULTIPLE LOCATIONS, ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["PLEASE CONFIRM DELIVERY LOCATION ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["WITH EACH REQUEST ",{"$nulls":10},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
[{"$nulls":11},"-",null,"-",null,"-",null,"-",{"$nulls":7},{"v":0,"d":"0.00"}]
["CAPITAL PROJECT #:",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
[" DISTRIBUTION  &  $$",{"$nulls":10},"-",null,"-",null,"-",null,"-"]
["COMMENTS: ",{"$nulls":20},"Totals: $",null,null,{"$f":"SUM(Z19:AB37)","v":0}]
["Ernest Cousson/Mike Melton - 678-692-0407"]
[]
[" COG  USE  ONLY  ",{"$nulls":11},"  COG  USE  ONLY   "]
["Pricing method:"]
[null,null,"Verbal / Phone"]
[null,null,"Email/Mail/Fax",{"$nulls":3},"Dept / Requestor / Date",{"$nulls":12},"Purchasing / Date"]
[{"$f":"AA8","v":0},null,"Bid / RFP #"]
[null,null,"E-Verify Affidavit"]
["Vendor emailed copy?",{"$nulls":5},"Department Mgr / Date",{"$nulls":12},"Finance Director / Date"]
[null,null,"Vendor Notified"]
["Invoice apprvd/attchd?"]
[null,null,"PMT Approval",{"$nulls":3},"City Manager / Date",{"$nulls":12},"BOARD / Date"]
[null,null,"Inv Attached"]