{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Filter Assessment Report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Filter Assessment Report","index":0,"n_rows":485,"n_cols":29,"rows_kept":485,"cut":false,"hidden":false,"merged":[[7,2,7,3],[7,6,7,7],[7,10,7,11],[9,6,9,8],[99,2,99,3],[99,6,99,7],[99,10,99,11],[414,10,415,12],[415,2,415,7],[344,3,344,8],[9,10,9,11],[334,1,334,11],[335,1,335,11],[336,1,336,11],[338,10,339,12],[339,2,339,7],[182,2,182,3],[182,6,182,7],[182,10,182,11],[265,2,265,3],[265,6,265,7],[265,10,265,11],[342,2,342,3],[342,6,342,7],[223,8,223,9],[220,1,220,2],[221,1,221,2],[221,3,221,4],[421,1,421,11],[482,2,482,7],[482,10,482,11],[419,4,419,8],[417,2,417,3],[417,6,417,7],[417,10,417,11],[346,1,346,11],[407,2,407,7],[407,10,407,11],[410,1,410,11],[411,1,411,11],[412,1,412,11],[220,5,220,6],[220,8,220,9],[220,3,220,4],[330,2,330,7],[330,10,330,11],[258,1,258,11],[254,10,254,11],[18,3,18,6],[21,3,21,4],[19,5,19,6],[20,5,20,6],[342,10,342,11],[261,10,262,12],[95,10,96,12],[178,10,179,12],[174,1,174,11],[175,1,175,11],[176,1,176,11],[167,1,167,2],[171,10,171,11],[225,1,225,2],[225,3,225,4],[225,5,225,6],[225,8,225,9],[224,5,224,6],[224,8,224,9],[223,1,223,2],[224,1,224,2],[224,3,224,4],[223,3,223,4],[223,5,223,6],[215,8,215,9],[214,1,214,2],[214,3,214,4],[44,5,44,6],[43,7,43,8],[44,7,44,8],[5,2,5,7],[58,7,58,8],[59,7,59,8],[31,1,31,2],[32,1,32,2],[36,1,36,2],[35,3,35,4],[29,1,29,2],[35,5,35,6],[36,5,36,6],[39,5,39,6],[18,1,18,2],[19,3,19,4],[20,3,20,4],[27,1,27,2],[22,3,22,4],[22,1,22,2],[163,1,163,2],[154,1,154,2],[155,1,155,2],[156,1,156,2],[157,1,157,2],[160,1,160,2],[161,1,161,2],[162,1,162,2],[168,1,168,2],[158,1,158,2],[164,1,164,2],[123,3,123,4],[126,3,126,4],[211,8,211,9],[205,8,205,9],[204,1,204,2],[204,3,204,4],[204,5,204,6],[23,3,23,4],[221,5,221,6],[221,8,221,9],[171,2,171,7],[217,1,217,2],[217,3,217,4],[217,5,217,6],[217,8,217,9],[218,1,218,2],[218,3,218,4],[218,5,218,6],[218,8,218,9],[219,1,219,2],[219,3,219,4],[219,5,219,6],[219,8,219,9],[214,5,214,6],[104,5,104,6],[103,5,103,6],[103,7,103,8],[104,7,104,8],[101,5,101,8],[85,3,85,7],[145,5,145,8],[132,7,132,8],[135,1,142,11],[133,7,133,8],[129,7,129,8],[123,1,123,2],[131,3,131,4],[132,3,132,4],[124,3,124,4],[130,1,130,2],[129,1,129,2],[128,3,128,4],[128,1,128,2],[124,1,124,2],[125,1,125,2],[127,1,127,2],[129,3,129,4],[127,3,127,4],[88,1,88,11],[93,1,93,11],[85,10,85,11],[104,1,104,2],[87,1,87,11],[84,3,84,7],[44,3,44,4],[44,1,44,2],[153,1,153,2],[114,1,114,2],[112,1,112,2],[148,1,148,2],[131,1,131,2],[132,1,132,2],[151,1,151,2],[104,3,104,4],[103,1,103,2],[46,1,53,11],[122,1,122,2],[147,1,147,2],[121,1,121,2],[122,3,122,4],[121,3,121,4],[150,1,150,2],[119,3,119,4],[91,1,91,11],[66,1,66,2],[67,7,67,8],[67,5,67,6],[61,7,61,8],[66,3,66,4],[67,3,67,4],[68,3,68,4],[82,2,82,11],[76,1,76,2],[71,1,71,2],[66,5,66,6],[108,1,108,2],[109,1,109,2],[106,1,106,3],[67,1,67,2],[103,3,103,4],[107,1,107,2],[110,1,110,2],[111,1,111,2],[73,1,73,2],[70,5,76,11],[96,2,96,7],[25,1,25,2],[24,1,24,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[27,3,27,5],[0,1,0,11],[1,1,1,11],[2,1,2,11],[16,1,16,2],[15,3,15,4],[16,3,16,4],[15,5,15,6],[16,5,16,6],[11,5,11,8],[13,9,13,10],[15,8,15,9],[13,1,13,2],[16,8,16,9],[13,3,13,5],[13,7,13,8],[9,2,9,3],[23,1,23,2],[4,10,5,12],[33,5,33,7],[41,5,41,6],[58,5,58,6],[60,5,60,6],[60,7,60,8],[61,5,61,6],[36,3,36,4],[33,1,33,2],[39,3,39,4],[37,3,37,4],[56,5,56,8],[33,8,33,9],[42,9,42,10],[44,9,44,10],[39,1,39,2],[38,1,38,2],[38,3,38,4],[41,3,41,4],[59,3,59,4],[42,7,42,8],[42,5,42,6],[38,8,38,9],[37,1,37,2],[41,9,41,10],[199,3,199,4],[200,8,200,9],[202,5,202,6],[202,8,202,9],[197,5,197,8],[201,1,201,2],[201,3,201,4],[201,5,201,6],[201,8,201,9],[199,8,199,9],[200,1,200,2],[200,3,200,4],[200,5,200,6],[199,5,199,6],[29,3,29,4],[35,8,35,9],[36,8,36,9],[39,8,39,9],[28,3,28,4],[19,7,19,8],[20,7,20,8],[21,5,21,6],[31,8,31,10],[29,5,29,6],[29,8,29,9],[31,5,31,7],[22,5,22,6],[21,7,21,8],[22,7,22,8],[23,7,23,8],[23,5,23,6],[24,3,24,4],[25,3,25,4],[37,5,37,6],[38,5,38,6],[37,8,37,9],[28,8,28,9],[28,5,28,6],[120,1,120,2],[60,3,60,4],[68,5,68,6],[262,2,262,7],[254,2,254,7],[269,1,269,11],[257,1,257,11],[203,3,203,4],[208,8,208,9],[209,1,209,2],[207,1,207,2],[207,3,207,4],[209,8,209,9],[210,3,210,4],[267,5,267,8],[203,1,203,2],[204,8,204,9],[205,5,205,6],[203,5,203,6],[203,8,203,9],[215,5,215,6],[216,8,216,9],[222,1,222,2],[222,3,222,4],[113,1,113,2],[79,2,80,10],[58,3,58,4],[58,1,58,2],[59,1,59,2],[61,3,61,4],[66,7,66,8],[41,7,41,8],[59,5,59,6],[43,5,43,6],[43,9,43,10],[63,1,63,2],[64,1,64,2],[60,1,60,2],[61,1,61,2],[74,1,74,2],[70,1,70,2],[72,1,72,2],[75,1,75,2],[68,7,68,8],[68,1,68,2],[84,1,84,2],[85,1,85,2],[92,1,92,11],[121,7,121,8],[106,5,114,11],[122,7,122,8],[123,7,123,8],[117,5,117,8],[128,7,128,8],[130,7,130,8],[131,7,131,8],[126,7,126,8],[127,7,127,8],[124,7,124,8],[125,7,125,8],[120,7,120,8],[208,1,208,2],[208,3,208,4],[205,1,205,2],[205,3,205,4],[208,5,208,6],[215,3,215,4],[149,1,149,2],[126,1,126,2],[147,5,168,11],[186,5,194,11],[179,2,179,7],[184,5,184,8],[186,1,186,2],[187,1,187,2],[188,1,188,2],[189,1,189,2],[215,1,215,2],[190,1,190,2],[191,1,191,2],[192,1,192,2],[193,1,193,2],[202,1,202,2],[202,3,202,4],[194,1,194,2],[239,1,239,2],[247,10,248,11],[240,1,240,2],[213,8,213,9],[209,3,209,4],[209,5,209,6],[244,5,244,8],[246,1,251,9],[235,5,241,11],[246,10,246,11],[249,10,250,11],[251,10,251,11],[235,1,235,2],[241,1,241,2],[229,1,229,2],[230,1,230,2],[227,5,230,11],[216,1,216,2],[216,3,216,4],[216,5,216,6],[210,1,210,2],[222,5,222,6],[222,8,222,9],[214,8,214,9],[63,5,63,6],[64,5,64,6],[63,3,63,4],[64,3,64,4],[63,7,63,8],[64,7,64,8],[259,1,259,11],[227,1,227,2],[228,1,228,2],[210,5,210,6],[213,3,213,4],[213,5,213,6],[210,8,210,9],[207,8,207,9],[206,1,206,2],[206,3,206,4],[206,5,206,6],[206,8,206,9],[207,5,207,6],[211,1,211,2],[211,3,211,4],[211,5,211,6],[233,5,233,8],[238,1,238,2]]}
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  "]
[null,"SYSTEM NAME:",null,null,null,null,null,null,null,"OR NUMBER:  "]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",null,null,null,"PLANT ID No.:",null,null,null,"NUMBER:  ",null,null,null,null,null,null,null,"FILTER TYPE",null,null,"OPERATING MODE",null,null,null,"MEDIA TYPE",null,null,"MEDIA MATERIAL"]
[]
[null,"FIRST EVENT: ",null,null,null,"SECOND EVENT:",null,null,null,"THIRD EVENT:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gravity",null,null,"Constant Rate/Constant Level",null,null,null,"Multiple Media",null,null,"Anthracite"]
[null,null,null,null,null,"DESIGN SPECIFICATIONS",null,null,null,null,null,null,null,null,null,null,null,"Pressure",null,null,"Constant Rate/Variable Level",null,null,null,"Dual Media",null,null,"Sand"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permutit",null,null,"Declining Rate",null,null,null,"Rapid Sand",null,null,"Garnet"]
[null," FILTER TYPE",null,null,null,null,null,"  OPERATING MODE",null,null,null,null,null,null,null,null,null,"Other",null,null,"Other",null,null,null,"Deep-bed Mono Media",null,null,"GAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Other"]
[null,null,null,"Diameter (ft)",null,"Length (ft)",null,"Width (ft)","Surface Area (ft2)",null,"Freeboard (ft)","Max Head Loss (ft)",null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",null,null,"Unknown"]
[null," MEDIA BED DIMENSIONS",null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(D17),ISBLANK(F17),ISBLANK(H17)),\"\",IF(AND(D17>0,ISBLANK(F17),ISBLANK(H17)),3.1417*(D17/2)^2,IF(AND(D17=0,F17>0,H17>0),F17*H17,\"ERROR\")))","v":""}]
[]
[null," MEDIA TYPE"]
[null," MEDIA SPECS",null,"Material",null,"Depth (inches)",null,"Min. Size (mm)",null,"Max. Size (mm)","UC","Specific Gravity"]
[null,"    Layer 1 Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNDERDRAIN TYPE",null,null,"SUPPLEMENTAL BW FACILITIES",null,null,null,"FILTER LOADING RATE (REG)",null,null,"YES/NO LIST"]
[null,"    Layer 2 Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perforated Pipe",null,null,"None",null,null,null,"Is it 6.5?",{"$f":"IF(D14=\"\",\"\",IF(AND(D14=R11,J14=U13,OR(D19=Y11,D19=Y12,D19=Y14)),\"Yes\",\"No\"))","v":""},null,"Yes"]
[null,"    Layer 3 Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perforated Plate",null,null,"Surface Wash",null,null,null,"Is it 5?",{"$f":"IF(D14=\"\",\"\",IF(AND(D14=R11,OR(J14=U11,J14=U12),OR(D19=Y11,D19=Y12,D19=Y14)),\"Yes\",\"No\"))","v":""},null,"No"]
[null,"    Layer 4 Material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheeler",null,null,"Subsurface Wash",null,null,null,"Is it 2.5?",{"$f":"IF(D14=\"\",\"\",IF(AND(D14=R11,J14=U13,D19=Y13),\"Yes\",\"No\"))","v":""}]
[null," TOTAL DEPTH  (inches)",null,{"$f":"IF(D21=\"Unknown\",\"Unknown\",IF(SUM(F21:G24)=0,\"\",SUM(F21:G24)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Type-S with gravel",null,null,"Air Scour",null,null,null,"Is it 2?",{"$f":"IF(D14=\"\",\"\",\n      IF(OR(D14=R12,\n             D14=R13,\n             AND(D14=R11,\n                   J14=Y13,\n                   OR(J14=U11,J14=U12))),\n                   \"Yes\",\"No\"))","v":""}]
[null," L/D RATIO",null,{"$f":"IF(D25=\"Unknown\",\"Unknown\",IF(ISTEXT(D25),\"\",D25^2*25.4/((H21+J21)/2*F21+(H22+J22)/2*F22+(H23+J23)/2*F23+(H24+J24)/2*F24)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Leopold IMS Cap",null,null,"Air Scour (retrofit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Other"]
[null," UNDERDRAIN TYPE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown"]
[null,null,null,"No. of Grades",null,"Min. Size   (in)",null,"Max. Size   (in)","Total Depth   (in)"]
[null," SUPPORT GRAVEL"]
[]
[null," TROUGHS",null,null,null,"   SUPPL. BACKWASH",null,null,null,null,null,null,null,null,null,null,null,"BW W ATER SOURCE",null,null,"CONTROLLER",null,null,"METER",null,"LOHG"]
[null,"    Number.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filter Effluent",null,null,"None",null,null,"None",null,"None"]
[null,"    Separation   (inches)",null,null,null,"   FILTER-TO-WASTE",null,null,null,null,null,null,null,null,null,null,null,"Filters & Pump",null,null,"Fix. weir Splitter",null,null,"Proportional",null,"Differential Gauge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dedicated BW Pump",null,null,"Var. weir Splitter",null,null,"Venturi",null,"Two Gauges"]
[null,null,null,"Regulatory Std",null,"Design",null,"Typical","During Backwash",null,"Maximum","App'd Exception",null,null,null,null,null,"Service Pumps",null,null,"Man. Telescoping",null,null,"Orifice",null,"Water Lvl Indicator"]
[null," FILTER FLOW RATE  (gpm)",null,{"$f":"IF(D14=\"\",\"\",IF(D38=\"Other\",\"Unspecified\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",D38*I17)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Elevated BW Tank",null,null,"Man. Butterfly",null,null,"Ultrasonic",null,"Other"]
[null," LOADING RATE  (gpm/ft2)",null,{"$f":"IF(D14=\"\",\"\",IF(Z22=\"Yes\",6.5,IF(Z23=\"Yes\",5,IF(Z24=\"Yes\",2.5,IF(Z25=\"Yes\",2,\"Other\")))))","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(F37=\"\",\"Filter Flow Rate = ?\",F37/I17)))","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(H37=\"\",\"Filter Flow Rate = ?\",H37/I17)))","v":""},{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(I37=\"\",\"Filter Flow Rate = ?\",I37/I17)))","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(K37=\"\",\"Filter Flow Rate = ?\",K37/I17)))","v":""},{"$f":"IF(OR(D14=\"\",L37=\"\"),\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(L37=\"\",\"Filter Flow Rate = ?\",L37/I17)))","v":""},null,null,null,null,null,"Distribution",null,null,"Mechanical ROFC",null,null,"Propeller"]
[null," BW FLOW RATE  (gpm)",null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",ROUND(I17*12.5,0)&\" - \"&ROUND(I17*21.8,0)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Mot. Valve (Auto.)",null,null,"Nunating Disk"]
[null," BW LOADING RATE  (gpm/ft2)",null,{"$f":"IF(D14=\"\",\"\",\"12.5 - 21.8\")","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(F39=\"unknown\", \"Unknown\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(F39=\"\",\"Backwash Rate = ?\",F39/I17))))","v":""},null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(H39=\"\",\"Backwash Rate = ?\",H39/I17)))","v":""},null,null,{"$f":"IF(D14=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\",IF(K39=\"\",\"Backwash Rate = ?\",K39/I17)))","v":""},null,null,null,null,null,null,null,null,null,"Vacuum Pipe",null,null,"Paddle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orifice Plate",null,null,"V-notch weir"]
[null,null,null,"Source",null,"Controller",null,"Meter",null,"Turbidimeter",null,"LOHG",null,null,null,null,null,null,null,null,"Head Control Box",null,null,"Flat Weir"]
[null," FILTER INFLUENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Parshall Flume"]
[null," FILTER EFFLUENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null," BACKWASH WATER"]
[]
[null,"ADDITIONAL REMARKS:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLOW METER CAL.",null,null,"TURBIDIMETER CAL.",null,null,"ROFC CAL.",null,"CALIBRATION FREQUENCY",null,null,"SOPs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",null,null,"Formazin",null,null,"Unknown",null,"Less than Annual",null,null,"Complete "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weirs",null,null,"Stabilzed formazin",null,null,"Ultrasonic",null,"Annual",null,null,"Partial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flume",null,null,"Polymer beads",null,null,"Time & Volume",null,"Semi-annual",null,null,"Out-of-date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ultrasonic",null,null,"Gel",null,null,"Other",null,"Quarterly",null,null,"None"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time & Volume",null,null,"Comparison",null,null,null,null,"Monthly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,"Proprietary device",null,null,null,null,"Weekly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,null,null,null,"Daily"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"More than daily"]
[null,null,null,null,null,"OPERATING PROCEDURES"]
[]
[null," CALIBRATION",null,"Flow Meter",null,"Backwash Meter",null,"Mech. ROFC",null,"NTU (Primary)","NTU (Secondary)"]
[null,"    Method"]
[null,"    Frequency"]
[null,"    Date of Last"]
[]
[null,"DATA CONSISTENCY",null,"Frequency and Span",null,"Date and Time",null,"NTU Meter Display",null,"SCADA Display","Data Recorder","Grab Sample"]
[null,"    Test Data"]
[]
[null," BACKWASH",null,"Turbidity  (NTU)",null,"LOH  (ft)",null,"Run Time  (hr)",null,"Run Volume  (gal)","Filtration Rate"]
[null,"    Criteria"]
[null,"    Monitoring Interval "]
[]
[null," WRITTEN SOPs",null,null,null,"ADDITIONAL REMARKS:"]
[null,"    Plant Start-up"]
[null,"    Filter Start-up"]
[null,"    Plant Shutdown"]
[null,"    Filter Shutdown"]
[null,"    Filter Backwash"]
[null,"    Filter Inspection"]
[]
[]
[null,null,"I certify that I am familiar with the information contained in this report and that, to the best of my knowledge, the information is true, complete, and accurate."]
[]
[null,"Operator's"]
[null,"Signature:"]
[]
[null,"Operator's Name (printed):"]
[null,"Certificate No. and Class:",null,null,null,null,null,null,null,"     Date:"]
[]
[null,"Submit Report to TCEQ/Water Supply Division/Public Drinking Water Section(MC-155), ATTN: Monthly Reports, P.O. Box 13087, Austin, TX 78711-3087"]
[null,"The report is due the 10th of the following month"]
[]
[null,"TCEQ - 10277 (Rev. 02-15-17)",null,null,null,null,null,"PAGE 1  ",null,null,null,null,"Filter Assessment Report",null,null,"FARv7","2017-02-15"]
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""}]
[null,"SYSTEM NAME:",{"$f":"IF($C$6=\"\",\"\",$C$6)","v":""},null,null,null,null,null,null,"OR NUMBER:  "]
[]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",{"$f":"IF($C$8=\"\",\"\",$C$8)","v":""},null,null,"PLANT ID No.:",{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,"NUMBER:  ",{"$f":"IF($K$8=\"\",\"\",$K$8)","v":""}]
[]
[null,null,null,null,null,"CURRENT CONDITIONS"]
[]
[null," DATE",null," TIME",null,"TURBIDITY (NTU)",null,"LOH (ft)",null,"FLOW RATE (gpm)","RUN TIME (hr)","RUN VOLUME (gal)"]
[]
[]
[null," PHYSICAL CONDITION",null,null,null,"ADDITIONAL REMARKS:",null,null,null,null,null,null,null,null,null,null,null,"CONDITION OF FILTER",null,null,"CONDITION OF APPERTENANCES",null,null,null,"FLOC/MUDBALL DISTRIBUTION"]
[null,"    Walls",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excellent",null,null,"Fully Operational",null,null,null,"Uniform"]
[null,"    Troughs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Good",null,null,"Slight Malfunction",null,null,null,"Localized"]
[null,"    Suppl. Backwash",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Damage",null,null,"Moderate Malfunct",null,null,null,"Other"]
[null,"    Flow Meter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moderate Damage",null,null,"Severe Malfunction"]
[null,"    ROFC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Severe Damage",null,null,"Other"]
[null,"    Flow Control Valve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"    Turbidimeter"]
[null,"    LOHG"]
[]
[]
[null,null,null,null,null,"MEDIA SURFACE CONDITIONS",null,null,null,null,null,null,null,null,null,null,null,"TROUGH LEVELNESS",null,null,"FLOODING",null,"SUPPL. EFFECTIVENESS",null,null,"JETTING",null,"BBW DISTRIBUTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level",null,null,"None",null,"Excellent",null,null,"Slight",null,"Even/Uniform"]
[null,null,null,"Before BW",null,"After BW",null,null,null,"Before BW","After BW",null,null,null,null,null,null,"Slighly Unlevel",null,null,"Slight",null,"Adequate",null,null,"Moderate",null,"Uneven"]
[null," MOUNDS",null,null,null,null,null,"RETRACTION",null,null,null,null,null,null,null,null,null,"Moder. Unlevel",null,null,"Moderate",null,"Poor",null,null,"Severe",null,"Inadequate"]
[null,"    Number",null,null,null,null,null,"    Number",null,null,null,null,null,null,null,null,null,"Severely Unlevel",null,null,"Severe",null,"Ineffective",null,null,null,null,"Other"]
[null,"    Length  (inches)",null,null,null,null,null,"    Length  (inches)",null,null,null,null,null,null,null,null,null,null,null,null,"Complete"]
[null,"    Width  (inches)",null,null,null,null,null,"    Width  (inches)"]
[null,"    Height  (inches)",null,null,null,null,null,"    Depth  (inches)"]
[null," DEPRESSIONS",null,null,null,null,null,"CRACKS"]
[null,"    Number",null,null,null,null,null,"    Number"]
[null,"    Length  (inches)",null,null,null,null,null,"    Length  (inches)"]
[null,"    Width  (inches)",null,null,null,null,null,"    Width  (inches)"]
[null,"    Depth  (inches)",null,null,null,null,null,"    Depth  (inches)"]
[null," ACCUMULATED FLOC",null,null,null,null,null," MUDBALLS"]
[null,"    Thickness  (inches)",null,null,null,null,null,"    No.  per ft2"]
[null,"    Distribution",null,null,null,null,null,"    Size  (inches)"]
[null,null,null,null,null,null,null,"    Distribution"]
[]
[null,"ADDITIONAL REMARKS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BACKWASH CONDITIONS"]
[]
[null," BW FLOW RATE   (gpm)",null,null,null,"ADDITIONAL REMARKS: "]
[null," RISE RATE  (inches/minute)",null,{"$f":"IF(D148=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface area = ?\",(D148/7.48)/I17*12))","v":""}]
[null," LOADING RATE  (gpm/ft2)",null,{"$f":"IF(D148=\"\",\"\",IF(OR(I17=\"\",I17=\"ERROR\"),\"Surface Area = ?\", D148/I17))","v":""}]
[null," DURATION   (minutes)"]
[null," TOTAL VOLUME   (gallons)"]
[]
[null," TROUGHS"]
[null,"    Levelness"]
[null,"    Flooding"]
[null," SUPPL. BACKWASH"]
[null,"    Duration   (minutes)"]
[null,"    Effectiveness"]
[]
[null," JETTING"]
[null,"    No. of Sites"]
[null,"    Severity"]
[null," BW WATER DISTRIBUTION"]
[null," SPENT BWW TURBIDITY"]
[]
[null," EXPANSION  (inches)"]
[null," EXPANSION  (percent)",null,{"$f":"IF(D167=\"\",\"\",IF(D191=\"\",\"Avg. Depth = ?\",D167/D191*100))","v":""}]
[null," YIELD   (percent)",null,{"$f":"IF(D152=\"\",\"\",IF(L105=\"\",\"Run Volume = ?\",IF(L105=\"Unknown\", \"Unknown\",(1-D152/L105))))","v":""}]
[]
[]
[null,"Submitted by: ",null,null,null,null,null,null,null,"     Date:",{"$f":"IF($K$86=\"\",\"\",$K$86)","v":""}]
[]
[null,{"$f":"$B$91","v":"TCEQ - 10277 (Rev. 02-15-17)"},null,null,null,null,null,"PAGE 2   ",null,null,null,null,"Filter Assessment Report"]
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""}]
[null,"SYSTEM NAME:",{"$f":"IF($C$6=\"\",\"\",$C$6)","v":""},null,null,null,null,null,null,"OR NUMBER:  "]
[]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",{"$f":"IF($C$8=\"\",\"\",$C$8)","v":""},null,null,"PLANT ID No.:",{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,"NUMBER:  ",{"$f":"IF($K$8=\"\",\"\",$K$8)","v":""}]
[]
[null,null,null,null,null,"FILTER PROBE"]
[]
[null," NUMBER OF SITES",null,null,null,"ADDITIONAL REMARKS: "]
[null," MEDIA"]
[null,"    Max. Thickness   (inches)"]
[null,"    Min. Thickness   (inches)"]
[null,"    Typ. Thickness   (inches)"]
[null,"SUPPORT MATERIAL"]
[null,"    Max. Elevation"]
[null,"    Min. Elevation"]
[null,"    Typ. Elevation"]
[]
[]
[null,null,null,null,null,"FILTER EXCAVATION"]
[]
[null,null,null,"REFERENCE",null,"SITE 2",null,"SITE 3","SITE 4",null,"SITE 5","SITE 6",null,null,null,null,null,"SITE CONDITION",null,null,"MUDBALLS",null,"SHARPNESS",null,"ENCRUSTATION",null,"UNIFORMITY"]
[null,"SITE CHARACTERISTIC",null,"Normal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal",null,null,"None",null,"Excellent",null,"None",null,"Good"]
[null," LAYER 1   (Top Layer)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Media Mound",null,null,"Few",null,"Good",null,"Slight",null,"Marginal"]
[null," INTERFACE 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Media Depression",null,null,"Several",null,"Worn",null,"Moderate",null,"Poor"]
[null," LAYER 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crack",null,null,"Many",null,null,null,"Heavy",null,"Other"]
[null," INTERFACE 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retraction"]
[null," LAYER 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Floc. Accumul."]
[null," INTERFACE 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gravel Mound"]
[null," LAYER 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gravel Depression"]
[null," MUDBALLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poor Suppl. BW"]
[null,"    Max. Size   (inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jetting"]
[null,"    Min. Size   (inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poor BW Distr."]
[null,"    Max. Depth   (inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,"SITE 7",null,"SITE 8",null,"SITE 9","SITE 10",null,"SITE 11","SITE 12"]
[null,"SITE CHARACTERISTIC"]
[null," LAYER 1   (Top Layer)"]
[null," INTERFACE 1"]
[null," LAYER 2"]
[null," INTERFACE 2"]
[null," LAYER 3"]
[null," INTERFACE 3"]
[null," LAYER 4"]
[null," MUDBALLS"]
[null,"    Max. Size   (inches)"]
[null,"    Min. Size   (inches)"]
[null,"    Max. Depth   (inches)"]
[]
[null," MEDIA CONDITION",null,null,null,"ADDITIONAL REMARKS: "]
[null,"    Sharpness"]
[null,"    Encrustation"]
[null,"    Uniformity"]
[]
[]
[null,null,null,null,null,"ADDITIONAL STUDIES"]
[]
[null," FILTER PROFILE ATTACHED?",null,null,null,"ADDITIONAL REMARKS:"]
[null,"Note: A Filter Profile must be attached to this report."]
[]
[null," PERCENT MUDBALLS"]
[null,"    Media Volume  (ml)"]
[null,"    Mudball Volume  (ml)"]
[null,"    % Mudballs",null,{"$f":"IF(AND(ISBLANK(D240),ISBLANK(D241)),\"\",IF(AND(D240<>0,ISBLANK(D241)),\"Mudball Vol. = ?\",IF(AND(ISBLANK(D240),D241<>0),\"Media Vol. = ?\",D241/(D240+D241))))","v":""}]
[]
[]
[null,null,null,null,null,"CONCLUSIONS"]
[]
[null,"CONCLUSIONS:",null,null,null,null,null,null,null,null,"CORRECTIVE ACTION PLAN ATTACHED?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WOULD YOU LIKE SOME TECHNICAL ASSISTANCE FROM THE TCEQ?"]
[]
[]
[]
[]
[null,"Submitted by: ",null,null,null,null,null,null,null,"     Date:",{"$f":"IF($K$86=\"\",\"\",$K$86)","v":""}]
[]
[null,{"$f":"$B$91","v":"TCEQ - 10277 (Rev. 02-15-17)"},null,null,null,null,null,"PAGE 3   ",null,null,null,null,"Filter Assessment Report"]
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""}]
[null,"SYSTEM NAME:",{"$f":"IF($C$6=\"\",\"\",$C$6)","v":""},null,null,null,null,null,null,"OR NUMBER:  "]
[]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",{"$f":"IF($C$8=\"\",\"\",$C$8)","v":""},null,null,"PLANT ID No.:",{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,"NUMBER:  ",{"$f":"IF($K$8=\"\",\"\",$K$8)","v":""}]
[]
[null,null,null,null,null,"FILTER SCHEMATIC"]
[]
[null,"PREPARE A SIMPLE FILTER SCHEMATIC SHOWING THE LOCATION OF BACKWASH WATER TROUGHS, OBSERVED ANOMOLIES, AND EXCAVATION SITES."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Submitted by: ",null,null,null,null,null,null,null,"     Date:",{"$f":"IF($K$86=\"\",\"\",$K$86)","v":""}]
[]
[null,{"$f":"$B$91","v":"TCEQ - 10277 (Rev. 02-15-17)"},null,null,null,null,null,"PAGE 4   ",null,null,null,null,"Filter Assessment Report"]
[]
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""}]
[null,"SYSTEM NAME:",{"$f":"IF($C$6=\"\",\"\",$C$6)","v":""},null,null,null,null,null,null,"OR NUMBER:  "]
[]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",{"$f":"IF($C$8=\"\",\"\",$C$8)","v":""},null,null,"PLANT ID No.:",{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,"NUMBER:  ",{"$f":"IF($K$8=\"\",\"\",$K$8)","v":""}]
[]
[null,null,null,"NARRATIVE DESCRIPTION OF FILTER PROFILE"]
[]
[null,"DESCRIBE THE FILTER PROFILE, INCLUDING THE CAUSE OF ANY TURBIDITY SPIKES GREATER THAN 0.1 NTU AND ANY INTERRUPTION IN THE DATA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Submitted by: ",null,null,null,null,null,null,null,"     Date:",{"$f":"IF($K$86=\"\",\"\",$K$86)","v":""}]
[]
[null,{"$f":"$B$91","v":"TCEQ - 10277 (Rev. 02-15-17)"},null,null,null,null,null,"PAGE 5   ",null,null,null,null,"Filter Assessment Report"]
[null,"FILTER ASSESSMENT REPORT FOR INDIVIDUAL FILTERS"]
[null,"FOR PUBLIC WATER SYSTEMS THAT ARE USING SURFACE WATER SOURCES OR GROUND WATER SOURCES UNDER"]
[null,"THE INFLUENCE OF SURFACE WATER THAT ARE REQUIRED TO CONDUCT AN INDIVIDUAL FILTER ASSSESSMENT"]
[]
[null,"PUBLIC WATER",null,null,null,null,null,null,null,"PLANT NAME  ",{"$f":"IF($K$5=\"\",\"\",$K$5)","v":""}]
[null,"SYSTEM NAME:",{"$f":"IF($C$6=\"\",\"\",$C$6)","v":""},null,null,null,null,null,null,"OR NUMBER:  "]
[null,null,null,null,null,null,null,null,null,"FILTER"]
[null,"PWS ID No.:",{"$f":"IF($C$8=\"\",\"\",$C$8)","v":""},null,null,"PLANT ID No.:",{"$f":"IF($G$8=\"\",\"\",$G$8)","v":""},null,null,"NUMBER:  ",{"$f":"IF($K$8=\"\",\"\",$K$8)","v":""}]
[]
[null,null,null,null,"CORRECTIVE ACTION PLAN (OPTIONAL)"]
[]
[null,"DESCRIBE THE CORRECTIVE ACTIONS THE SYSTEM WILL TAKE, INCLUDING THE PROPOSED COMPLETION DATA FOR EACH CORRECTIVE ACTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Submitted by: ",null,null,null,null,null,null,null,"     Date:",{"$f":"IF($K$86=\"\",\"\",$K$86)","v":""}]
[]
[null,{"$f":"$B$91","v":"TCEQ - 10277 (Rev. 02-15-17)"},null,null,null,null,null,"PAGE 6   ",null,null,null,null,"Filter Assessment Report"]