{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["FY19 Chemicals to be Bid ","FY17 Chemicals to be Bid v2","FY17 Chemicals to be Bid (2)","FY17 Tally -Final","Submitters"],"not_rendered":{"images":1,"defined_names":22,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"FY19 Chemicals to be Bid ","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[6,0,6,6],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6],[20,0,21,0],[21,3,21,4],[21,5,21,6],[22,0,23,0],[23,3,23,4],[23,5,23,6],[24,0,25,0],[25,3,25,4],[25,5,25,6],[26,0,27,0],[27,3,27,4],[27,5,27,6],[28,0,29,0],[29,3,29,4],[29,5,29,6],[30,0,31,0],[31,3,31,4],[31,5,31,6],[32,0,33,0],[33,3,33,4],[33,5,33,6],[34,0,35,0],[35,3,35,4],[35,5,35,6],[36,0,37,0],[37,3,37,4],[37,5,37,6],[38,0,39,0],[39,3,39,4],[39,5,39,6],[40,0,41,0],[41,3,41,4],[41,5,41,6],[42,0,43,0],[43,3,43,4],[43,5,43,6],[45,3,45,4],[45,5,45,6],[46,0,47,0],[47,3,47,4],[47,5,47,6],[48,0,48,6],[49,4,49,6],[53,0,53,6],[54,0,54,6],[55,0,55,6],[56,0,56,6],[57,2,57,6],[58,2,58,6],[59,2,59,6],[60,2,60,6],[60,7,60,10],[61,2,61,6],[62,2,62,6],[63,2,63,6]]}
[]
["BID #21-009"]
["FY22-FY23 WATER TREATMENT CHEMICALS"]
["PRICING SUBMITTALS"]
[]
[]
["Submitted by: "]
[null,"Name of Company:"]
[null,"Mailing Address:"]
[null,"City/State/Zip: "]
[null,"Phone (including area code):"]
[null,"Name & e-mail if respondent: "]
[null,"Ordering contact if same for all orders (name/phone/email): "]
[]
["Submittal Deadline: "]
["Tuesday, April 5, 2021 at 2:00 P.M. "]
[]
[]
[]
[null,"CITY OF GRIFFIN\nCHEMICAL/Plant Notes","DESCRIPTION","Apprx Annual Qty","UOM for price","UNIT PRICE (0.000000)","TOTAL"]
["1)"," Caustic Soda (25%) -totes\n","delivered 250-300 Gal Totes. Price in lbs.",{"v":106000,"d":"106,000"},"wet lbs",".",{"$f":"IF(F21=\".\",0,IF(F21=0,\"No Bid\",IF(F21>0,SUM(D21*F21))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:",null,"470-497-3385; ishakir@cityofgriffin.com"]
["2)"," Caustic Soda (25%) -bulk\nspecial note included","Bulk. Price in lbs.",{"v":775000,"d":"775,000"},"wet lbs",".",{"$f":"IF(F23=\".\",0,IF(F23=0,\"No Bid\",IF(F23>0,SUM(D23*F23))))","v":0}]
[null,"Delivers to plant 4","See notes for plant 4","Contact phone & email:",null,"770-229-6609; rclark@cityofgriffin.com"]
["3)","Chemical Hydrated Lime 400  (50 lb bags)","dry weight; 50-lb bags   (Note: Pallets to fit electric pallet jack 3-3/4 clearance). Price in dry lbs.",{"v":155000,"d":"155,000"},"dry lbs",".",{"$f":"IF(F25=\".\",0,IF(F25=0,\"No Bid\",IF(F25>0,SUM(D25*F25))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["4)","Liquid Chlorine (150-lb cyl) ","150 lb cylinders. Price in cylinders.",8,"cyl",".",{"$f":"IF(F27=\".\",0,IF(F27=0,\"No Bid\",IF(F27>0,SUM(D27*F27))))","v":0}]
[null,"Delivers to plant 1 & 7","See notes for plant 1 & 7","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["5)","Liquid Chlorine (1 Ton cyl) ","1 ton cylinders. Price in cylinders.",28,"cyl",".",{"$f":"IF(F29=\".\",0,IF(F29=0,\"No Bid\",IF(F29>0,SUM(D29*F29))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["6)","Liquid Phosphate -Aquadene SK7870","275 gallons per tote. Price in wet lbs.",{"v":65000,"d":"65,000"},"wet lbs",".",{"$f":"IF(F31=\".\",0,IF(F31=0,\"No Bid\",IF(F31>0,SUM(D31*F31))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1,2","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com                      678-692-0407; mmelton@cityofgriffin.com"]
["7)","Magnifloc LT7989 Flocculent ","liquid polymer; delivered in 55 gal drums. Price in wet lbs.",{"v":20000,"d":"20,000"},"wet lbs",".",{"$f":"IF(F33=\".\",0,IF(F33=0,\"No Bid\",IF(F33>0,SUM(D33*F33))))","v":0}]
[null,"Delivers to plant 1 ","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["8)","Aluminum Sulfate Solution","Bulk. Price in wet lbs.",{"v":560000,"d":"560,000"},"wet lbs",".",{"$f":"IF(F35=\".\",0,IF(F35=0,\"No Bid\",IF(F35>0,SUM(D35*F35))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["9)","Nuchar Carbon","dry weight; 45-lb bags; pallets must fit electric pallet jack with 3¾ clearance. Price in dry lbs.",{"v":11100,"d":"11,100"},"dry lbs",".",{"$f":"IF(F37=\".\",0,IF(F37=0,\"No Bid\",IF(F37>0,SUM(D37*F37))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com                      678-692-0407; mmelton@cityofgriffin.com"]
["10)","Potassium Permanganate","dry weight; ordered by pallets; delivered in 55 lb containers. Price in lbs.",{"v":6000,"d":"6,000"},"dry lbs",".",{"$f":"IF(F39=\".\",0,IF(F39=0,\"No Bid\",IF(F39>0,SUM(D39*F39))))","v":0}]
[null,"Delivers to plant 2","See notes for plant 2","Contact phone & email:",null,"678-692-0407; mmelton@cityofgriffin.com"]
["11)"," Soda Ash (50lb bags)","delivered in 50-lb bags. Price in lbs.",{"v":30000,"d":"30,000"},"lbs",".",{"$f":"IF(F41=\".\",0,IF(F41=0,\"No Bid\",IF(F41>0,SUM(D41*F41))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["12)"," Sodium Chlorite – 25% ","BULK - domestic liquid; delivered in 4500 gal loads . Price in wet lbs.",{"v":100000,"d":"100,000"},"wet lbs",".",{"$f":"IF(F43=\".\",0,IF(F43=0,\"No Bid\",IF(F43>0,SUM(D43*F43))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["13)"," Sodium Hypochlorite (10-15% solution)","10-15% solution. Price in gallons.  ",{"v":75000,"d":"75,000"},"gal",".",{"$f":"IF(F45=\".\",0,IF(F45=0,\"No Bid\",IF(F45>0,SUM(D45*F45))))","v":0}]
[null,"Delivers to plant 2","See notes for plant 2","Contact phone & email:",null,"678-692-0407; mmelton@cityofgriffin.com"]
["14)"," Sodium Permanganate 20%","delivered in 275 gallon totes. Options listed in notes. Price in gallons.",{"v":3250,"d":"3,250"},"gal",".",{"$f":"IF(F47=\".\",0,IF(F47=0,\"No Bid\",IF(F47>0,SUM(D47*F47))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:",null,"770-233-2974; mdrolet@cityofgriffin.com"]
["All Chemicals are to be FOB Griffin, GA with NO fuel adjustment cost. All Chemicals are to be NSF 60 Approved and the CAS Registry Number must be provided.                                                        Complete individual contact info if different from below."]
[null,"Prices submitted (#)",null,"Order contact (email & phone)"]
[]
[null,"Company Name:",{"$nulls":3},"Date Price Submitted: "]
[]
["City of Griffin - Delivery Location addresses and delivery times: "]
["         1                                2                                3                                  4                                5                                6                                   7                                   "]
["Harry Simmons               Still Branch Reservoir            Cabin Creek                         Potato Creek                        Shoal Creek                       Flint River Pump Sta                    Sun City                  \n229 N. Expressway         2045 Flat Shoals Rd              1140 N Hill Street                1150 County Line Rd          2940 W Ellis Rd                 1010 Salem Road                        1196 Jordan Hill Rd                 \nGriffin, GA  30223            Concord, GA  30206             Griffin, GA  30224               Griffin, GA  30224               Griffin, GA  30224             Griffin, GA  30224                        Griffin, GA  30223              "]
["8A - 2P deliveries     |         8A - 2P deliveries       |        10A- 2P deliveries      |    8A - 2P deliveries       |      8A - 2P deliveries      |  Contact 24hr in adv to schedule    |      8A - 2P deliveries      "]
["**","  GENERAL  Considerations: ","-  Make sure you meet the plant specific delivery considerations for the chemicals singled out below.\n-  Any specific questions are to be submitted; they will be answered by the specific plant and you will receive an email response.  Any questions of significance will be compiled into an addendum.\n-  Invoices are to be sent to the ordering plant."]
[null,"Special Considerations for\n Plant 1: ","-  Chlorine, 1-ton cyl:  must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames).\n-  Chlorite:  must be delivered by tanker pumper with rear discharge able to pump 25 ft.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit electric pallet jack with 3 ¾ clearance\n-  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance."]
[null,"Special Considerations for\n Plant 2: ","-  General:  lift arm cross bar on boom raises to height of 10'10\" from ground (7' from dock)\n-  General:  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance. \n-  Sodium Hypochlorite: Facility will only provide hookup just inside storage room door- vendor is responsible for providing means of off loading chemical.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit pallet jack with 3 ¾ clearance"]
[null,"Special Considerations for\n Plants 3, 4 and 5: ","-  General:  low boom; very sharp turn to dock\n-  General: deliveries need to be by vehicles ≤ 40 feet. This may be by enclosed truck, standard box trailer with lift gate\n-  Bulk Caustic Soda (25%): Vendor to deliver in 4,000 gallon loads. Vendor will be responsible to transfer into bulk storage tank via their pump and transfer equipment."]
[null,"Special Considerations for\n Plant 6: ","\n- Sodium Permanganate: various options available for delivery to plant 6. OPTION 1:  vendor to pump 275 gallons or less of liquid sodium permanganate from their truck with   their own transfer pump and delivery system to the holding storage tank inside the chemical fee room.  OPTION 2:  vendor to supply and install 2-200 gallon tanks and be able to deliver 330 gallons or less of liquid sodium permanganate.  Vendor should be albe to transfer product from their truck into the tanks with their pump and transfer equipment."]
[null,"Special Considerations for\n Plant 7: ","- Chlorine, 150-lb cylinders:  delivery of these cylinders will be coordinated through the Harry Simmons WTP but be delivered to the Sun City Chlorine Booster Pump Station.  We try to schedule the delivery of the tanks with the delivery for Plant 3 (Cabin Creek).  Lift gate is needed for delivery."]
["*","  Special Note: ","-  Sodium Hypochlorite (10-15% solution) is still under consideration and there is no guarantee that it will be used. The quantity listed is an estimated quantity that may be needed if the City converts to a bleach system for disinfection purposes at Still Branch."]

{"sheet":"FY17 Chemicals to be Bid v2","index":1,"n_rows":76,"n_cols":7,"rows_kept":76,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[4,0,4,6],[5,0,5,6],[6,0,6,6],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[18,0,19,0],[19,3,19,4],[19,5,19,6],[20,0,21,0],[21,3,21,4],[21,5,21,6],[22,0,23,0],[23,3,23,4],[23,5,23,6],[24,0,25,0],[25,3,25,4],[25,5,25,6],[26,0,27,0],[27,3,27,4],[27,5,27,6],[28,0,29,0],[29,3,29,4],[29,5,29,6],[30,0,31,0],[31,3,31,4],[31,5,31,6],[32,0,33,0],[33,3,33,4],[33,5,33,6],[34,0,35,0],[35,3,35,4],[35,5,35,6],[36,0,37,0],[37,3,37,4],[37,5,37,6],[38,0,39,0],[39,3,39,4],[39,5,39,6],[40,0,41,0],[41,3,41,4],[41,5,41,6],[42,0,43,0],[43,3,43,4],[43,5,43,6],[44,0,45,0],[45,3,45,4],[45,5,45,6],[46,0,47,0],[47,3,47,4],[47,5,47,6],[48,0,49,0],[49,3,49,4],[49,5,49,6],[50,0,51,0],[51,3,51,4],[51,5,51,6],[52,0,53,0],[53,3,53,4],[53,5,53,6],[54,0,55,0],[55,3,55,4],[55,5,55,6],[56,0,58,0],[57,3,57,4],[57,5,57,6],[58,2,58,6],[59,0,59,6],[60,4,60,6],[65,0,65,6],[66,0,66,6],[67,0,67,6],[68,0,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[72,7,72,10],[73,2,73,6],[74,2,74,6],[75,2,75,6]]}
[]
["BID #17-013"]
["FY18 WATER TREATMENT CHEMICALS"]
["PRICING SUBMITTALS"]
[]
[]
["Submitted by: "]
[null,"Name of Company:"]
[null,"Mailing Address:"]
[null,"City/State/Zip: "]
[null,"Phone (including area code):"]
[null,"Name & e-mail if respondent: "]
[null,"Ordering contact if same for all orders (name/phone/email): "]
[]
["Submittal Deadline: "]
["Wednesday, April 12, 2017 at 10:00 A.M. "]
[]
[null,"CITY OF GRIFFIN\nCHEMICAL/Plant Notes","DESCRIPTION","Apprx Annual Qty","UOM for price","UNIT PRICE (0.000000)","TOTAL"]
["1)","Aluminum Sulfate-liquid (8.3%)","Bulk - delivered in 45,000 lb loads. Price in dry lbs.",{"v":1390000,"d":"1,390,000"},"dry lbs",".",{"$f":"IF(F19=\".\",0,IF(F19=0,\"No Bid\",IF(F19>0,SUM(D19*F19))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["2)"," Caustic Soda (50%)","delivered in 55 gallon drums @ 700 lbs ea. (305 drums)  Price in gallons.",{"v":16775,"d":"16,775"},"gal",".",{"$f":"IF(F21=\".\",0,IF(F21=0,\"No Bid\",IF(F21>0,SUM(D21*F21))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["3)"," Caustic Soda (25%) -regular\n","delivered 55 gallon drums @ 700 lbs ea. (30 drums) Price in gallons.",{"v":1650,"d":"1,650"},"gal",".",{"$f":"IF(F23=\".\",0,IF(F23=0,\"No Bid\",IF(F23>0,SUM(D23*F23))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["4)"," Caustic Soda (25%) -bulk\nspecial note included","Bulk. Price in gallons.",{"v":16000,"d":"16,000"},"gal",".",{"$f":"IF(F25=\".\",0,IF(F25=0,\"No Bid\",IF(F25>0,SUM(D25*F25))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["5)","CedarCLEAR 757- Poly Aluminum Chloride - NO Substitutions","Bulk-No substitutions. Deliver in 4,500 gal loads. Price in wet lbs.",{"v":766000,"d":"766,000"},"wet lbs",".",{"$f":"IF(F27=\".\",0,IF(F27=0,\"No Bid\",IF(F27>0,SUM(D27*F27))))","v":0}]
[null,"Delivers to plant 2","See notes for plant 2","Contact phone & email:"]
["7)","Chemical Hydrated Lime 400  (50 lb bags)","dry weight; 50-lb bags   (Note: Pallets to fit electric pallet jack 3-3/4 clearance). Price in dry lbs.",{"v":190000,"d":"190,000"},"dry lbs",".",{"$f":"IF(F29=\".\",0,IF(F29=0,\"No Bid\",IF(F29>0,SUM(D29*F29))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["8)","Liquid Chlorine (150-lb cyl) ","150 lb cylinders. Price in cylinders.",54,"cyl",".",{"$f":"IF(F31=\".\",0,IF(F31=0,\"No Bid\",IF(F31>0,SUM(D31*F31))))","v":0}]
[null,"Delivers to plant 1,3","See notes for plant 1,3,7","Contact phone & email:"]
["9)","Liquid Chlorine (1-ton cyl)","1 ton cylinders. Price in cylinders.",65,"cyl",".",{"$f":"IF(F33=\".\",0,IF(F33=0,\"No Bid\",IF(F33>0,SUM(D33*F33))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["11)","Liquid Phosphate -Aquadene SK7870","275 gallons per tote. Price in wet lbs.",{"v":75000,"d":"75,000"},"wet lbs",".",{"$f":"IF(F35=\".\",0,IF(F35=0,\"No Bid\",IF(F35>0,SUM(D35*F35))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1,2","Contact phone & email:"]
["12)","Magnifloc LT7989 Flocculent \n-no substitutions","liquid polymer; NO substitutions; delivered in 55 gal drums. Price in wet lbs.",{"v":25000,"d":"25,000"},"wet lbs",".",{"$f":"IF(F37=\".\",0,IF(F37=0,\"No Bid\",IF(F37>0,SUM(D37*F37))))","v":0}]
[null,"Delivers to plant 1 ","See notes for plant 1","Contact phone & email:"]
["13)","Methanol","delivered in 350-gal totes",{"v":2800,"d":"2,800"},"gal",".",{"$f":"IF(F39=\".\",0,IF(F39=0,\"No Bid\",IF(F39>0,SUM(D39*F39))))","v":0}]
[null,"Delivers to plants 4","See notes for plants 4","Contact phone & email:"]
["14)","Nuchar Carbon","dry weight; 45-lb bags; pallets must fit electric pallet jack with 3¾ clearance. Price in dry lbs.",{"v":10500,"d":"10,500"},"dry lbs",".",{"$f":"IF(F41=\".\",0,IF(F41=0,\"No Bid\",IF(F41>0,SUM(D41*F41))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["15)","PAX-18 Polymer -NO substitutions","dry weight; delivered in 350-gal totes. Price in gal.",{"v":15050,"d":"15,050"},"gal",".",{"$f":"IF(F43=\".\",0,IF(F43=0,\"No Bid\",IF(F43>0,SUM(D43*F43))))","v":0}]
[null,"Delivers to plants 4","See notes for plants 4","Contact phone & email:"]
["16)","Potassium Permanganate","dry weight; ordered by pallets; delivered in 55 lb containers. Price in lbs.",{"v":13900,"d":"13,900"},"dry lbs",".",{"$f":"IF(F45=\".\",0,IF(F45=0,\"No Bid\",IF(F45>0,SUM(D45*F45))))","v":0}]
[null,"Delivers to plants 2,4,5*","See notes for plants 2,4,5","Contact phone & email:"]
["17)"," Soda Ash (50lb bags)","delivered in 50-lb bags. Price in lbs.",{"v":22500,"d":"22,500"},"lbs",".",{"$f":"IF(F47=\".\",0,IF(F47=0,\"No Bid\",IF(F47>0,SUM(D47*F47))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["18)"," Sodium Bi-Sulfite 43%","delivered in 55-gal drums-610 lbs",{"v":52000,"d":"52,000"},"wet lbs",".",{"$f":"IF(F49=\".\",0,IF(F49=0,\"No Bid\",IF(F49>0,SUM(D49*F49))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["19)"," Sodium Chlorite – 25% ","BULK - domestic liquid; delivered in 4500 gal loads . Price in wet lbs.",{"v":263000,"d":"263,000"},"wet lbs",".",{"$f":"IF(F51=\".\",0,IF(F51=0,\"No Bid\",IF(F51>0,SUM(D51*F51))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["20)"," *Sodium Hypochlorite (10-15% solution)","10-15% solution. Price in gallons.  ",{"v":15000,"d":"15,000"},"gal",".",{"$f":"IF(F53=\".\",0,IF(F53=0,\"No Bid\",IF(F53>0,SUM(D53*F53))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["21)"," Sodium Permanganate 20%","delivered in 275 gallon totes. Options listed in notes. Price in gallons.",{"v":3850,"d":"3,850"},"gal",".",{"$f":"IF(F55=\".\",0,IF(F55=0,\"No Bid\",IF(F55>0,SUM(D55*F55))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 6","Contact phone & email:"]
["22)"," Sodium Silico Fluoride ","delivered in 50-lb bags. Price in dry lbs.",{"v":46000,"d":"46,000"},"dry lbs",".",{"$f":"IF(F57=\".\",0,IF(F57=0,\"No Bid\",IF(F57>0,SUM(D57*F57))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
[null,"State Orgin of Manufacture:"]
["All Chemicals are to be FOB Griffin, GA with NO fuel adjustment cost. All Chemicals are to be NF 60 Approved and the CAS Registry Number must be provided.                                             Complete individual contact info if different from below."]
[null,"Prices submitted (#)",null,"Order contact (email & phone)"]
[]
[null,"Company Name:",{"$nulls":3},"Date Price Submitted: "]
[]
[]
["City of Griffin - Delivery Location addresses and delivery times: "]
["         1                                2                               3                             4                               5                             6                                     7"]
["Harry Simmons            Still Branch Reservoir            Cabin Creek                     Potato Creek                       Shoal Creek               Flint River Pump Station            Sun City Chlorine Booster           \n229 N. Expressway        2045 Flat Shoals Rd            1140 N Hill Street           1150 County Line Rd           2940 W Ellis Rd                1010 Salem Road                        1196 Jordan Hill Road\nGriffin, GA  30223          Concord, GA  30206           Griffin, GA  30224             Griffin, GA  30224            Griffin, GA  30224              Griffin, GA  30224                       Griffin, GA  30223"]
["8A - 2P deliveries     |     8A - 2P deliveries       |     10A- 2P deliveries      |    8A - 2P deliveries       |      8A - 2P deliveries     |  Contact 24hr in adv to schedule    |      8A - 2P deliveries       "]
["**","  GENERAL  Considerations: ","-  Make sure you meet the plant specific delivery considerations for the chemicals singled out below.\n-  Any specific questions are to be submitted; they will be answered by the specific plant and you will receive an \n   email response.  Any questions of significance will be compiled into an addendum.\n-  Invoices are to be sent to the ordering plant."]
[null,"Special Considerations for\n Plant 1: ","-  Chlorine, 1-ton cyl:  must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames).\n-  Chlorite:  must be delivered by tanker pumper with rear discharge able to pump 25 ft.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit electric pallet jack with 3 ¾ clearance\n-  Sodium Permanganate: OPTION 1:  vendor to pump 275 gallons or less of liquid sodium permanganate from their truck with   their own transfer pump and delivery system to the holding storage tank inside the chemical fee room.  OPTION 2:  vendor to supply and install 2-200 gallon tanks and be able to deliver 330 gallons or less of liquid sodium permanganate.  Vendor should be albe to transfer product from their truck into the tanks with their pump and transfer equipment.\n-  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance."]
[null,"Special Considerations for\n Plant 2: ","-  General:  lift arm cross bar on boom raises to height of 10'10\" from ground (7' from dock)\n-  General:  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance. \n-  Chlorine: 1-ton cyl:  must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames).\n-  Sodium Hypochlorite: Facility will only provide outside hookup - vendor is responsible for providing means of off loading chemical.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit electric pallet jack with 3 ¾ clearance"]
[null,"Special Considerations for\n Plants 3, 4 and 5: ","-  General:  low boom; very sharp turn to dock\n-  General: deliveries need to be by vehicles ≤ 40 feet. This may be by enclosed truck, standard box trailer with lift gate or by flatbeds.\n-  Bulk Caustic Soda (25%): Vendor to deliver in 4,000 gallon loads. Vendor will be responsible to transfer into bulk storage tank via their pump and transfer equipment.\n-  Methanol: Vendor will be responsible for off loading and placement of 350 gallon totes.  Vendor will also be required to load empty totes and remove from site.  \n-  PAX-18 Polymer: Vendor will be responsible for off loading and placement of 350 gallon totes.  Vendor will also be required to load empty totes and remove from site.  "]
[null,"Special Considerations for\n Plant 6: ","- Must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames). \n-  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance. \n- Sodium Permanganate: various options available for delivery to plant 6."]
[null,"Special Considerations for\n Plant 7: ","- Chlorine, 150-lb cylinders:  delivery of these cylinders will be coordinated through the Harry Simmons WTP but be delivered to the Sun City Chlorine Booster Pump Station.  We try to schedule the delivery of the tanks with the delivery for Plant 3 (Cabin Creek).  Lift gate is needed for delivery."]
["*","  Special Note: ","-  Sodium Hypochlorite (10-15% solution) is still under consideration and there is no guarantee that it will be used. The quantity listed is an estimated quantity that may be needed if the City converts to a bleach system for disinfection purposes at Still Branch."]

{"sheet":"FY17 Chemicals to be Bid (2)","index":2,"n_rows":76,"n_cols":9,"rows_kept":76,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,0,13,7],[14,0,14,7],[15,0,15,7],[16,0,16,7],[18,0,19,0],[19,3,19,4],[19,5,19,7],[20,0,21,0],[21,3,21,4],[21,5,21,7],[22,0,23,0],[23,3,23,4],[23,5,23,7],[24,0,25,0],[25,3,25,4],[25,5,25,7],[26,0,27,0],[27,3,27,4],[27,5,27,7],[28,0,29,0],[29,3,29,4],[29,5,29,7],[30,0,31,0],[31,3,31,4],[31,5,31,7],[32,0,33,0],[33,3,33,4],[33,5,33,7],[34,0,35,0],[35,3,35,4],[35,5,35,7],[36,0,37,0],[37,3,37,4],[37,5,37,7],[38,0,39,0],[39,3,39,4],[39,5,39,7],[40,0,41,0],[41,3,41,4],[41,5,41,7],[42,0,43,0],[43,3,43,4],[43,5,43,7],[44,0,45,0],[45,3,45,4],[45,5,45,7],[46,0,47,0],[47,3,47,4],[47,5,47,7],[48,0,49,0],[49,3,49,4],[49,5,49,7],[50,0,51,0],[51,3,51,4],[51,5,51,7],[52,0,53,0],[53,3,53,4],[53,5,53,7],[54,0,55,0],[55,3,55,4],[55,5,55,7],[56,0,58,0],[57,3,57,4],[57,5,57,7],[58,2,58,7],[59,0,59,7],[60,4,60,7],[65,0,65,7],[66,0,66,7],[67,0,67,7],[68,0,68,7],[69,2,69,7],[70,2,70,7],[71,2,71,7],[72,2,72,7],[72,8,72,12],[73,2,73,7],[74,2,74,7],[75,2,75,7]]}
[]
["BID #17-013"]
["FY18 WATER TREATMENT CHEMICALS"]
["PRICING SUBMITTALS"]
[]
[]
["Submitted by: "]
[null,"Name of Company:"]
[null,"Mailing Address:"]
[null,"City/State/Zip: "]
[null,"Phone (including area code):"]
[null,"Name & e-mail if respondent: "]
[null,"Ordering contact if same for all orders (name/phone/email): "]
[]
["Submittal Deadline: "]
["XXXXday, XXXXX, 2017 at 2:00 P.M. "]
[]
[null,"CITY OF GRIFFIN\nCHEMICAL/Plant Notes","DESCRIPTION","Apprx Annual Qty","UOM for price","Size & Wt of drums","UNIT PRICE (0.000000)","TOTAL"]
["1)","Aluminum Sulfate-liquid (8.3%)","Bulk - delivered in 45,000 lb loads. Price in dry lbs.",{"v":1390000,"d":"1,390,000"},"dry lbs",null,".",{"$f":"IF(G19=\".\",0,IF(G19=0,\"No Bid\",IF(G19>0,SUM(D19*G19))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["2)"," Caustic Soda (50%)","delivered 55 gallon drums @ 700 lbs ea. Price in gallons.",305,"gal",null,".",{"$f":"IF(G21=\".\",0,IF(G21=0,\"No Bid\",IF(G21>0,SUM(D21*G21))))","v":0},"is that drums or gal"]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["3)"," Caustic Soda (25%) -regular\n","delivered 55 gallon drums @ 700 lbs ea. Price in gallons.",30,"gal",null,".",{"$f":"IF(G23=\".\",0,IF(G23=0,\"No Bid\",IF(G23>0,SUM(D23*G23))))","v":0},"is that drums or gal"]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["4)"," Caustic Soda (25%) -bulk\nspecial note included","Bulk. Price in gallons.",{"v":16000,"d":"16,000"},"gal",null,".",{"$f":"IF(G25=\".\",0,IF(G25=0,\"No Bid\",IF(G25>0,SUM(D25*G25))))","v":0}]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["5)","CedarCLEAR 757- Poly Aluminum Chloride - NO Substitutions","Bulk-No substitutions. Deliver in 4,500 gal loads. Price in wet lbs.",{"v":766000,"d":"766,000"},"wet lbs",null,".",{"$f":"IF(G27=\".\",0,IF(G27=0,\"No Bid\",IF(G27>0,SUM(D27*G27))))","v":0},"CK - wet lbs ? 4500 gal loads?"]
[null,"Delivers to plant 2","See notes for plant 2","Contact phone & email:"]
["7)","Chemical Hydrated Lime 400  (50 lb bags)","dry weight; 50-lb bags   (Note: Pallets to fit electric pallet jack 3-3/4 clearance). Price in dry lbs.",{"v":190000,"d":"190,000"},"dry lbs",null,".",{"$f":"IF(G29=\".\",0,IF(G29=0,\"No Bid\",IF(G29>0,SUM(D29*G29))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["8)","Liquid Chlorine (150-lb cyl) ","150 lb cylinders. Price in cylinders.",54,"cyl",null,".",{"$f":"IF(G31=\".\",0,IF(G31=0,\"No Bid\",IF(G31>0,SUM(D31*G31))))","v":0}]
[null,"Delivers to plant 1,3","See notes for plant 1,3","Contact phone & email:"]
["9)","Liquid Chlorine (1-ton cyl)","1 ton cylinders. Price in cylinders.",65,"cyl",null,".",{"$f":"IF(G33=\".\",0,IF(G33=0,\"No Bid\",IF(G33>0,SUM(D33*G33))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["11)","Liquid Phosphate -Aquadene SK7870","275 gallons per tote. Price in wet lbs.",{"v":75000,"d":"75,000"},"wet lbs",null,".",{"$f":"IF(G35=\".\",0,IF(G35=0,\"No Bid\",IF(G35>0,SUM(D35*G35))))","v":0},"CK- wet lbs? had note of Carus 8500; do I need to put that in name? "]
[null,"Delivers to plants 1,2","See notes for plants 1,2","Contact phone & email:"]
["12)","Magnifloc LT7989 Flocculent \n-no substitutions","liquid polymer; NO substitutions; delivered in 55 gal drums. Price in wet lbs.",{"v":25000,"d":"25,000"},"wet lbs",null,".",{"$f":"IF(G37=\".\",0,IF(G37=0,\"No Bid\",IF(G37>0,SUM(D37*G37))))","v":0}]
[null,"Delivers to plant 1 ","See notes for plant 1","Contact phone & email:"]
["13)","Methanol","delivered in 350-gal totes",{"v":3000,"d":"3,000"},"gal",null,".",{"$f":"IF(G39=\".\",0,IF(G39=0,\"No Bid\",IF(G39>0,SUM(D39*G39))))","v":0},"gallons or totes? should this be divisible?"]
[null,"Delivers to plants 4","See notes for plants 4","Contact phone & email:"]
["14)","Nuchar Carbon","dry weight; 45-lb bags; pallets must fit electric pallet jack with 3¾ clearance. Price in dry lbs.",{"v":10500,"d":"10,500"},"dry lbs",null,".",{"$f":"IF(G41=\".\",0,IF(G41=0,\"No Bid\",IF(G41>0,SUM(D41*G41))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["15)","PAX-18 Polymer -NO substitutions","dry weight; delivered in 350-gal totes. Price in gal.",{"v":15000,"d":"15,000"},"gal",null,".",{"$f":"IF(G43=\".\",0,IF(G43=0,\"No Bid\",IF(G43>0,SUM(D43*G43))))","v":0},"gallons or totes? should this be divisible?"]
[null,"Delivers to plants 4","See notes for plants 4","Contact phone & email:"]
["16)","Potassium Permanganate","dry weight; ordered by pallets; delivered in 55 lb containers. Price in lbs.",{"v":13900,"d":"13,900"},"dry lbs",null,".",{"$f":"IF(G45=\".\",0,IF(G45=0,\"No Bid\",IF(G45>0,SUM(D45*G45))))","v":0}]
[null,"Delivers to plants 2,4,5*","See notes for plants 2,4,5","Contact phone & email:"]
["17)"," Soda Ash (50lb bags)","delivered in 50-lb bags. Price in lbs.",{"v":22500,"d":"22,500"},"lbs",null,".",{"$f":"IF(G47=\".\",0,IF(G47=0,\"No Bid\",IF(G47>0,SUM(D47*G47))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["18)"," Sodium Bi-Sulfite 43%","delivered in 55-gal drums-610 lbs",{"v":52000,"d":"52,000"},"wet lbs",null,".",{"$f":"IF(G49=\".\",0,IF(G49=0,\"No Bid\",IF(G49>0,SUM(D49*G49))))","v":0},"CK- wet lbs?"]
[null,"Delivers to plant 3","See notes for plant 3","Contact phone & email:"]
["19)"," Sodium Chlorite – 25% ","BULK - domestic liquid; delivered in 4500 gal loads . Price in wet lbs.",{"v":263000,"d":"263,000"},null,null,".",{"$f":"IF(G51=\".\",0,IF(G51=0,\"No Bid\",IF(G51>0,SUM(D51*G51))))","v":0},"gal or lbs?"]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
["20)"," *Sodium Hypochlorite (10-15% solution)","10-15% solution. Price in gallons.  ",{"v":15000,"d":"15,000"},"gal",null,".",{"$f":"IF(G53=\".\",0,IF(G53=0,\"No Bid\",IF(G53>0,SUM(D53*G53))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["21)"," Sodium Permanganate 20%","delivered in 275 gallon totes. Options listed in notes. Price in gallons.",{"v":3750,"d":"3,750"},"gal",null,".",{"$f":"IF(G55=\".\",0,IF(G55=0,\"No Bid\",IF(G55>0,SUM(D55*G55))))","v":0}]
[null,"Delivers to plant 1","See notes for plant 1","Contact phone & email:"]
["22)"," Sodium Silico Fluoride ","delivered in 50-lb bags. Price in dry lbs.",{"v":46000,"d":"46,000"},"dry lbs",null,".",{"$f":"IF(G57=\".\",0,IF(G57=0,\"No Bid\",IF(G57>0,SUM(D57*G57))))","v":0}]
[null,"Delivers to plants 1,2","See notes for plants 1, 2","Contact phone & email:"]
[null,"State Orgin of Manufacture:"]
["All Chemicals are to be FOB Griffin, GA with NO fuel adjustment cost. All Chemicals are to be NF 60 Approved and the CAS Registry Number must be provided.   "]
[null,"Prices submitted (#)",null,"Order contact (email & phone)"]
[]
[null,"Company Name:",{"$nulls":4},"Date Price Submitted: "]
[]
[]
["City of Griffin - Delivery Location addresses and delivery times: "]
["         1                                2                               3                             4                               5                             6                                     7"]
["Harry Simmons            Still Branch Reservoir            Cabin Creek                     Potato Creek                       Shoal Creek               Flint River Pump Station            Sun City Chlorine Booster           \n229 N. Expressway        2045 Flat Shoals Rd            1140 N Hill Street           1150 County Line Rd           2940 W Ellis Rd                1010 Salem Road                        1196 Jordan Hill Road\nGriffin, GA  30223          Concord, GA  30206           Griffin, GA  30224             Griffin, GA  30224            Griffin, GA  30224              Griffin, GA  30224                       Griffin, GA  30223",{"$nulls":7},"do we need to have location 6 & 7?"]
["8A - 2P deliveries     |     8A - 2P deliveries       |     10A- 2P deliveries      |    8A - 2P deliveries       |      8A - 2P deliveries     |  Contact 24hr in adv to schedule    |      8A - 2P deliveries       "]
["**","  GENERAL  Considerations: ","-  Make sure you meet the plant specific delivery considerations for the chemicals singled out below.\n-  Any specific questions are to be submitted; they will be answered by the specific plant and you will receive an \n   email response.  Any questions of significance will be compiled into an addendum.\n-  Invoices are to be sent to the ordering plant."]
[null,"Special Considerations for\n Plant 1: ","-  Chlorine, 1-ton cyl:  must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames).\n-  Chlorite:  must be delivered by tanker pumper with rear discharge able to pump 25 ft.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit electric pallet jack with 3 ¾ clearance\n-  Sodium Permanganate: OPTION 1:  vendor to pump 275 gallons or less of liquid sodium permanganate from their truck with   their own transfer pump and delivery system to the holding storage tank inside the chemical fee room.  OPTION 2:  vendor to supply and install 2-200 gallon tanks and be able to deliver 330 gallons or less of liquid sodium permanganate.  Vendor should be albe to transfer product from their truck into the tanks with their pump and transfer equipment.\n-  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance."]
[null,"Special Considerations for\n Plant 2: ","-  General:  lift arm cross bar on boom raises to height of 10'10\" from ground (7' from dock)\n-  General:  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance. \n-  Chlorine: 1-ton cyl:  must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames).\n-  Sodium Hypochlorite: Facility will only provide outside hookup - vendor is responsible for providing means of off loading chemical.\n-  Liquid Phosphate: Valve has to accept 2” Cam Lock Connector; has to fit electric pallet jack with 3 ¾ clearance"]
[null,"Special Considerations for\n Plants 3, 4 and 5: ","-  General:  low boom; very sharp turn to dock\n-  General: deliveries need to be by vehicles ≤ 40 feet. This may be by enclosed truck, standard box trailer with lift gate or by flatbeds.\n-  Bulk Caustic Soda (25%): Vendor to deliver in 4,000 gallon loads. Vendor will be responsible to transfer into bulk storage tank via their pump and transfer equipment.\n-  Methanol: Vendor will be responsible for off loading and placement of 350 gallon totes.  Vendor will also be required to load empty totes and remove from site.  \n-  PAX-18 Polymer: Vendor will be responsible for off loading and placement of 350 gallon totes.  Vendor will also be required to load empty totes and remove from site.  ",{"$nulls":5},"do we need to separate these out? \nSpecifics all go to Potato Creek, but \nWhere do the 2 'generals' go?"]
[null,"Special Considerations for\n Plant 6: ","- Must be delivered by short (≤ 30 feet) flat bed trailer with fifth wheel and lift gate. (no B-frames). \n-  All pallet deliveries must fit existing pallet jack with 3 3/4 clearance. ",{"$nulls":5},"still need??"]
[null,"Special Considerations for\n Plant 7: ","- Chlorine, 150-lb cylinders:  delivery of these cylinders will be coordinated through the Harry Simmons WTP but be delivered to the Sun City Chlorine Booster Pump Station.  We try to schedule the delivery of the tanks with the delivery for Plant 3 (Cabin Creek).  Lift gate is needed for delivery.",{"$nulls":5},"still need??"]
["*","  Special Note: ","-  Sodium Hypochlorite (10-15% solution) is still under consideration and there is no guarantee that it will be used. The quantity listed is an estimated quantity that may be needed if the City converts to a bleach system for disinfection purposes at Still Branch."]

{"sheet":"FY17 Tally -Final","index":3,"n_rows":52,"n_cols":27,"rows_kept":52,"hidden":true,"merged":[[1,13,1,15],[1,24,1,25],[2,13,2,15],[3,13,3,15],[6,1,6,3],[7,0,8,0],[7,1,8,1],[7,2,8,2],[9,0,10,0],[9,1,10,1],[9,2,10,2],[11,0,12,0],[11,1,12,1],[11,2,12,2],[13,0,14,0],[13,1,14,1],[13,2,14,2],[15,0,16,0],[15,1,16,1],[15,2,16,2],[17,0,18,0],[17,1,18,1],[17,2,18,2],[19,0,20,0],[19,1,20,1],[19,2,20,2],[21,0,22,0],[21,1,22,1],[21,2,22,2],[23,0,24,0],[23,1,24,1],[23,2,24,2],[25,0,26,0],[25,1,26,1],[25,2,26,2],[27,0,28,0],[27,1,28,1],[27,2,28,2],[29,0,30,0],[29,1,30,1],[29,2,30,2],[31,0,32,0],[31,1,32,1],[31,2,32,2],[33,0,34,0],[33,1,34,1],[33,2,34,2],[35,0,36,0],[35,1,36,1],[35,2,36,2],[37,0,38,0],[37,1,38,1],[37,2,38,2],[39,0,40,0],[39,1,40,1],[39,2,40,2],[41,0,42,0],[41,1,42,1],[41,2,42,2],[43,0,44,0],[43,1,44,1],[43,2,44,2],[45,0,46,0],[45,1,46,1],[45,2,46,2],[47,0,48,0],[47,1,48,1],[47,2,48,2],[49,0,50,0],[49,1,50,1],[49,2,50,2]]}
[]
[{"$nulls":3},"CITY OF GRIFFIN",{"$nulls":8},"BID NUMBER:","17-013",{"$nulls":9},"last confirmed:"]
[{"$nulls":12},"BID TITLE:",{"$nulls":4},"low bid"]
[{"$nulls":3},"BID TALLY",{"$nulls":8},"BID OPEN DATE: "]
[]
[null,"Description","Qty. tons","UOM","Affinity Chemical","Allied Universal","American Development","Brenn-tag","Burnett Lime","Carus Chemical","CedarChem","Chemrite","Chemtrade","Dycho","Evoqua Water Tech (Siemens)","F2 Industries","GEO Specialty","Industrial Chemical","International Dioxide","Lhoist NA","Marubeni Specialty","Polydyne, Inc","Shannon Chemicals","Southwest Engineers","Sterling Water","Thatcher","Univar"]
[null,"# of bids submitted",null,null,"1 bid"]
[1,"Aluminum Sulfate, Liquid (8.3% )\nbulk-delivered in 45,000 lb loads",{"v":1390000,"d":"1,390,000"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F8*$C$8)","v":0},{"$f":"SUM(G8*$C$8)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AA8*$C$34)","v":0}]
[2,"Caustic Soda (50%)\nconverted to gallons)",305,"gallon"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F10*$C$10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,"Caustic Soda (25%)\nregular",30,"gallon"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F12*$C$10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"Caustic Soda (25%) bulk\n(converted to gal)",{"v":16000,"d":"16,000"},"gallon"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F14*$C$14)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,"CedarCLEAR 757 Poly Aluminum Chloride -NO substitutions",{"v":766000,"d":"766,000"},"wet lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F16*$C$16)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(K16*$C$16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L16*$C$16)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[6,"CedarFLOC 510 Polymer (NO substitution) -RENEWAL",500,"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F18*$C$18)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(K18*$C$18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L18*$C$18)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[7,"Chemical Hydrated Lime 400  ",{"v":190000,"d":"190,000"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F20*$C$20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[8,"Liquid Chlorine (150-lb cyl) ",54,"150-lb cyl"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F22*$C$22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[9,"Liquid Chlorine (1-ton cyl)",65,"1 ton cyl"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F24*$C$24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[10,"Liquid Lime\nRENEWAL",{"v":315000,"d":"315,000"},"wet lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F26*$C$26)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(I26*$C$26)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J26*$C$26)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[11,"Liquid Phoshate -Aquadene SK7870",{"v":75000,"d":"75,000"},"wet lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F28*$C$28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[12,"Magnifloc LT7989 Flocculent \n-NO substitutions",{"v":25000,"d":"25,000"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F30*$C$30)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[13,"Methanol",{"v":3000,"d":"3,000"},"gallons"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F32*$C$32)","v":0},{"$f":"SUM(G32*$C$32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,"Nuchar Carbon  ",{"v":10500,"d":"10,500"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F34*$C$34)","v":0},0,0,0,0,0,{"$f":"SUM(L34*$C$34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"PAX-18 Polymer -NO substitutions",{"v":15000,"d":"15,000"},"gallons"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F36*$C$36)","v":0},{"$f":"SUM(G36*$C$36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[16,"Potassium Permanganate",{"v":13900,"d":"13,900"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F38*$C$38)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[17,"Soda Ash (50lb bags)",{"v":22500,"d":"22,500"},"gallons"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F40*$C$40)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[18,"Sodium Bi-Sulfite (43%)\n",{"v":52000,"d":"52,000"},"wet lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F42*$C$42)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R42*$C$42)","v":0},{"$f":"SUM(S42*$C$42)","v":0},0,0,0,0,0,0,0,0]
[19,"Sodium Chlorite (25%)",{"v":263000,"d":"263,000"},"wet lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F44*$C$44)","v":0},0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[20,"Sodium Hypochlorite (10-15% solution)",{"v":15000,"d":"15,000"},"gal"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F46*$C$46)","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[21,"Sodium Permanganate 20%",{"v":3750,"d":"3,750"},"gal"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F48*$C$48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[22,"Sodium Silico Fluoride ",{"v":46000,"d":"46,000"},"dry lb"]
[{"$nulls":3},"TOTAL:",null,{"$f":"SUM(F50*$C$50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"AWARDED:"]

{"sheet":"Submitters","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"hidden":true}
[]
[null,"2016 water chemical submitters"]
[null,"lisad@allieduniversal.com'; 'jamie@adc-chem.com'; 'djakulski@brenntag.com'; Hugh Burnett (hburnett@burnett-inc.com); 'orders@caruscorporation.com'; Carus Phosphates 2 <bids@caruscorporation.com>; 'christa.zuker@cedarchem.com'; 'aaron@chemrite.com'; 'cssorders@chemtradelogistics.com'; 'info@dycho.com'; 'municipalserices@evoqua.com'; 'melissa@f2ind.com'; 'kimberly@f2ind.com'; 'GEObiddesk@geosc.com'; 'jane.b@industrialchem.com'; 'thomas.dwyer@chemours.com'; 'lna.salesbid@lhoist.com'; 'hill-a@marubeni-usa.com'; 'dcflynn@shannonchem.com'; 'mailswe@southwestengineers.com'; 'sales@sterlingwatertech.com'; 'craig.thatcher@tchem.com'; 'Linda Campbell' <Linda.Campbell@univarusa.com>"]