{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Treatment Plants","Hydraulic Graph","Organic Graph"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Hydraulic Graph","index":2,"reason":"not_a_worksheet"},{"sheet":"Organic Graph","index":3,"reason":"not_a_worksheet"}],"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":"Instructions","index":0,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[38,1,42,9],[30,2,34,9],[35,1,37,9],[17,2,24,9],[43,1,44,9],[1,1,1,9],[25,2,26,9],[27,2,27,9],[28,2,29,9],[13,1,13,9],[3,1,11,9],[14,2,16,9]]}
[]
[null,"Instructions for Using DEP Chapter 94 Spreadsheet"]
[]
[null,"This spreadsheet has been developed by the Pennsylvania Department of Environmental Protection (PADEP) to provide consistency in the presentation of existing and projected hydraulic and organic loads for treatment plants for annual municipal wasteload management (Chapter 94) reports due March 31 annually.  The spreadsheet contains one data entry worksheet named \"Treatment Plants.\"  The \"Hydraulic Graph\" and \"Organic Graph\" worksheets are developed automatically from the data into the \"Treatment Plants\" worksheet.  Cells with green borders are those where data are requested.  All other cells are locked.  Questions on the use of this spreadsheet should be directed to PADEP's Bureau of Point and Non-Point Source Management at 717-787-8184.  Note - You must enable Macros to use this spreadsheet.  This spreadsheet has been tested using Excel versions 2007 and 2010."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Treatment Plants Worksheet"]
[null,1,"Enter the Facility Name and Permit No.  Select the Reporting Year from the drop-down menu.  The \"Persons/EDU\" field is used to estimate per capita hydraulic and organic contributions; by default the value is 3.5 but may be modified."]
[]
[]
[null,2,"Enter the Existing Hydraulic Design Capacity, in MGD, and the Existing Organic Design Capacity, in lbs BOD5/day, from the WQM permit for the treatment plant as of December 31 of the Reporting Year.  If an upgrade is planned that would increase the hydraulic design capacity and/or organic design capacity in the next 5 years, select \"YES\" from the drop-down menu(s) and select the Year of the planned upgrade from the menu.  Then enter the Future Hydraulic Design Capacity, in MGD, and/or Future Organic Design Capacity, in lbs BOD5/day.  If an upgrade is not planned in the next 5 years, all fields in this section may remain blank except Existing Hydraulic/Organic Design Capacity."]
[]
[]
[]
[]
[]
[]
[]
[null,3,"Record the Monthly Average Flows (MGD) and Monthly Average (Influent) BOD5 Loads (lbs/day) for the past 5 years in the tables provided."]
[]
[null,4,"Enter the existing equivalent dwelling units (EDUs) for each of the past 5 years."]
[null,5,"Enter additional EDUs that are planned for connection to the treatment plant over the next 5 years."]
[]
[null,6,"For \"New EDU Flow\" and \"New EDU Load,\" the user may accept the calculated values or overwrite them with other projected Flow/EDU and/or Load/EDU data.  The default calculation is the average Flow/EDU and Load/EDU values for the past 5 years.  If the cells for Existing EDUs are left blank, the calculation assumes 350 GPD/EDU x No. EDUs for New EDU Flow and 0.584 lbs/day/EDU x No. EDUs for New EDU Load."]
[]
[]
[]
[]
[null,"Upon entry of data in all green bordered cells, calculations are made and existing (\"Exist.\") and projected (\"Proj.\") overload conditions are determined (\"YES\" or \"NO\").  The worksheets named \"Hydraulic Graph\" and \"Organic Graph\" are populated in accordance with the data entered."]
[]
[]
[null,"Optionally users may enter total monthly precipitation data at the bottom of the Treatment Plants worksheet to chart precipitation along with hydraulic loads.  By default the precipitation data are not shown on the Hydraulic Graph; to enable the data on the graph click the \"YES\" button above the precipitation data entry table.  You may click on the \"NO\" button at any time to hide precipitation data."]
[]
[]
[]
[]
[null,"Mouse over cells with red corners     to view comments and explanations on how calculations are performed."]

{"sheet":"Treatment Plants","index":1,"n_rows":117,"n_cols":76,"rows_kept":117,"cut":false,"hidden":false,"merged":[[1,43,1,47],[1,49,1,52],[25,21,25,24],[25,25,25,27],[25,28,25,30],[10,21,11,24],[10,25,10,39],[11,25,11,27],[3,1,3,39],[9,1,9,39],[4,28,4,32],[12,21,12,24],[12,25,12,27],[12,28,12,30],[12,31,12,33],[12,34,12,36],[12,37,12,39],[14,25,14,27],[14,28,14,30],[4,24,4,27],[2,33,2,36],[25,1,25,4],[15,1,15,4],[12,11,12,13],[10,1,11,4],[22,5,22,7],[22,8,22,10],[22,11,22,13],[22,14,22,16],[21,11,21,13],[21,14,21,16],[20,8,20,10],[20,11,20,13],[12,8,12,10],[16,1,16,4],[12,5,12,7],[14,1,14,4],[17,11,17,13],[17,14,17,16],[31,1,31,4],[31,5,31,7],[31,8,31,10],[31,11,31,13],[31,14,31,16],[31,17,31,19],[18,14,18,16],[19,11,19,13],[19,14,19,16],[22,1,22,4],[23,1,23,4],[26,1,26,4],[27,1,27,4],[26,11,26,13],[26,14,26,16],[26,17,26,19],[25,5,25,7],[18,17,18,19],[19,17,19,19],[20,17,20,19],[21,17,21,19],[29,17,29,19],[27,11,27,13],[27,14,27,16],[4,5,4,19],[14,5,14,7],[16,5,16,7],[16,8,16,10],[10,5,10,19],[11,17,11,19],[12,17,12,19],[13,17,13,19],[14,17,14,19],[15,17,15,19],[16,17,16,19],[7,13,7,14],[8,15,8,20],[27,17,27,19],[28,11,28,13],[28,14,28,16],[28,17,28,19],[17,8,17,10],[16,11,16,13],[23,17,23,19],[25,8,25,10],[25,11,25,13],[25,14,25,16],[25,17,25,19],[27,8,27,10],[28,8,28,10],[23,8,23,10],[23,11,23,13],[23,14,23,16],[17,17,17,19],[22,17,22,19],[21,8,21,10],[20,14,20,16],[18,8,18,10],[29,5,29,7],[29,8,29,10],[26,8,26,10],[11,14,11,16],[29,14,29,16],[18,11,18,13],[16,14,16,16],[26,5,26,7],[27,5,27,7],[28,5,28,7],[23,5,23,7],[21,5,21,7],[12,14,12,16],[13,5,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,16],[20,5,20,7],[18,5,18,7],[15,14,15,16],[17,5,17,7],[11,28,11,30],[11,31,11,33],[11,34,11,36],[11,37,11,39],[28,1,28,4],[29,1,29,4],[35,1,35,4],[14,8,14,10],[20,1,20,4],[21,1,21,4],[13,1,13,4],[32,1,32,19],[33,1,34,4],[19,1,19,4],[19,5,19,7],[19,8,19,10],[29,11,29,13],[14,11,14,13],[14,14,14,16],[15,5,15,7],[17,1,17,4],[18,1,18,4],[15,8,15,10],[15,11,15,13],[14,21,14,24],[14,31,14,33],[14,34,14,36],[14,37,14,39],[1,56,1,59],[57,1,57,39],[35,5,35,7],[35,8,35,10],[35,11,35,13],[35,14,35,16],[35,17,35,19],[36,5,36,7],[36,8,36,10],[36,11,36,13],[36,14,36,16],[36,17,36,19],[37,11,37,13],[37,14,37,16],[37,17,37,19],[36,1,36,4],[12,1,12,4],[11,5,11,7],[11,8,11,10],[11,11,11,13],[16,31,16,33],[16,34,16,36],[16,37,16,39],[15,21,15,24],[15,25,15,27],[15,28,15,30],[15,31,15,33],[15,34,15,36],[15,37,15,39],[20,31,20,33],[20,34,20,36],[20,37,20,39],[13,21,13,24],[13,25,13,27],[13,28,13,30],[13,31,13,33],[13,34,13,36],[13,37,13,39],[18,21,18,24],[18,25,18,27],[18,28,18,30],[18,31,18,33],[18,34,18,36],[18,37,18,39],[17,21,17,24],[17,25,17,27],[17,28,17,30],[17,31,17,33],[17,34,17,36],[17,37,17,39],[16,21,16,24],[16,25,16,27],[16,28,16,30],[19,21,19,24],[19,25,19,27],[19,28,19,30],[19,31,19,33],[19,34,19,36],[19,37,19,39],[25,31,25,33],[25,34,25,36],[25,37,25,39],[22,21,22,24],[22,25,22,27],[22,28,22,30],[22,31,22,33],[22,34,22,36],[22,37,22,39],[21,21,21,24],[21,25,21,27],[21,28,21,30],[21,31,21,33],[21,34,21,36],[21,37,21,39],[20,21,20,24],[20,25,20,27],[20,28,20,30],[26,21,26,24],[26,25,26,27],[26,28,26,30],[26,31,26,33],[26,34,26,36],[26,37,26,39],[23,21,23,24],[23,25,23,27],[23,28,23,30],[23,31,23,33],[23,34,23,36],[23,37,23,39],[24,34,24,36],[24,37,24,39],[29,21,29,24],[29,25,29,27],[29,28,29,30],[29,31,29,33],[29,34,29,36],[29,37,29,39],[28,21,28,24],[28,25,28,27],[28,28,28,30],[28,31,28,33],[28,34,28,36],[28,37,28,39],[37,1,37,4],[27,21,27,24],[27,25,27,27],[27,28,27,30],[27,31,27,33],[27,34,27,36],[27,37,27,39],[39,5,39,7],[39,8,39,10],[39,11,39,13],[39,14,39,16],[39,17,39,19],[31,21,31,24],[31,25,31,27],[31,28,31,30],[31,31,31,33],[31,34,31,36],[31,37,31,39],[37,21,37,24],[37,25,37,27],[37,28,37,30],[37,31,37,33],[37,34,37,36],[37,37,37,39],[38,31,38,33],[38,34,38,36],[38,37,38,39],[36,21,36,24],[37,5,37,7],[37,8,37,10],[38,8,38,10],[38,11,38,13],[38,5,38,7],[33,25,33,39],[34,25,34,27],[34,28,34,30],[34,31,34,33],[34,34,34,36],[34,37,34,39],[33,5,33,19],[34,5,34,7],[34,8,34,10],[34,11,34,13],[34,14,34,16],[34,17,34,19],[0,1,0,39],[0,40,57,40],[0,0,57,0],[2,37,2,39],[5,1,5,39],[4,1,4,4],[8,30,8,32],[12,20,23,20],[62,37,62,38],[60,25,60,38],[39,21,39,24],[39,25,39,27],[39,28,39,30],[39,31,39,33],[39,34,39,36],[39,37,39,39],[38,21,38,24],[38,25,38,27],[38,28,38,30],[8,21,8,29],[8,33,8,36],[7,10,7,12],[7,1,7,9],[6,15,6,20],[7,21,7,29],[7,30,7,32],[6,30,6,32],[7,17,7,19],[7,15,7,16],[6,21,6,29],[6,33,6,36],[7,35,7,36],[78,31,78,32],[38,14,38,16],[8,13,8,14],[52,17,52,19],[53,17,53,19],[54,17,54,19],[55,17,55,19],[42,1,42,39],[50,17,50,19],[51,17,51,19],[56,11,56,13],[45,14,45,16],[46,14,46,16],[38,17,38,19],[32,21,32,39],[33,21,34,24],[78,37,78,38],[75,31,75,32],[75,37,75,38],[76,31,76,32],[76,37,76,38],[77,31,77,32],[77,37,77,38],[69,31,69,32],[69,37,69,38],[70,25,70,38],[72,37,72,38],[73,37,73,38],[74,31,74,32],[74,37,74,38],[64,37,64,38],[67,31,67,32],[67,37,67,38],[68,31,68,32],[68,37,68,38],[66,31,66,32],[66,37,66,38],[65,37,65,38],[56,1,56,4],[56,8,56,10],[56,5,56,7],[65,31,65,32],[63,37,63,38],[64,31,64,32],[56,17,56,19],[43,20,56,39],[54,14,54,16],[55,14,55,16],[56,14,56,16],[45,17,45,19],[46,17,46,19],[47,17,47,19],[48,17,48,19],[49,17,49,19],[43,1,44,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[43,5,43,19],[44,5,44,7],[44,8,44,10],[44,11,44,13],[44,14,44,16],[44,17,44,19],[45,5,45,7],[46,5,46,7],[47,5,47,7],[45,11,45,13],[46,11,46,13],[47,11,47,13],[47,14,47,16],[45,8,45,10],[46,8,46,10],[47,8,47,10],[48,8,48,10],[49,8,49,10],[55,11,55,13],[52,8,52,10],[53,8,53,10],[54,8,54,10],[55,8,55,10],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[55,5,55,7],[50,8,50,10],[51,8,51,10],[54,5,54,7],[54,11,54,13],[48,5,48,7],[49,5,49,7],[50,5,50,7],[51,5,51,7],[52,5,52,7],[53,5,53,7],[52,14,52,16],[53,14,53,16],[50,11,50,13],[51,11,51,13],[52,11,52,13],[53,11,53,13],[48,11,48,13],[49,11,49,13],[48,14,48,16],[49,14,49,16],[50,14,50,16],[41,2,41,12],[51,14,51,16],[40,1,40,39],[24,5,24,7],[24,8,24,10],[24,11,24,13],[24,14,24,16],[24,17,24,19],[24,25,24,27],[24,28,24,30],[24,31,24,33],[36,25,36,27],[36,28,36,30],[36,31,36,33],[36,34,36,36],[36,37,36,39],[35,21,35,24],[35,25,35,27],[35,28,35,30],[35,31,35,33],[35,34,35,36],[35,37,35,39],[39,1,39,4],[38,1,38,4],[1,32,1,39],[4,37,4,39],[4,33,4,36],[1,1,1,31],[2,1,2,31],[32,43,32,47],[30,1,30,4],[30,21,30,24],[30,5,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,16],[30,17,30,19],[30,25,30,27],[30,28,30,30],[30,31,30,33],[30,34,30,36],[30,37,30,39],[7,37,7,39],[6,13,6,14],[6,1,6,9],[8,1,8,9],[6,10,6,12],[8,10,8,12]]}
[]
[null,"PADEP Chapter 94 Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years",null,"3-Month Consecutive Max Avg Flows",null,null,null,null,null,"No. Decimal Places in Flow Data",null,null,null,null,null,null,"No. Decimal Places in BOD5 Data",null,null,null,null,null,"Graph Title",null,null,null,null,null,"Month/Year","Avg Flow","Hydr Design","Max 3-Mo","Avg Load","Org Design","Max Load","Precip"]
[null,"Sewage Treatment Plants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reporting Year:",null,null,null,null,null,null,null,2012,"YES",{"$f":"F12","v":""},{"$f":"I12","v":""},{"$f":"L12","v":""},{"$f":"O12","v":""},{"$f":"R12","v":""},null,{"$f":"$F$12","v":""},{"$f":"$I$12","v":""},{"$f":"$L$12","v":""},{"$f":"$O$12","v":""},{"$f":"$R$12","v":""},null,null,{"$f":"$F$12","v":""},{"$f":"$I$12","v":""},{"$f":"$L$12","v":""},{"$f":"$O$12","v":""},{"$f":"$R$12","v":""},null,{"$f":"IF(AND(Facility_Name<>\"\",Permit_No<>\"\"),CONCATENATE(Facility_Name,\", \",Permit_No),\"\")","v":""},null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$F$12)","v":"Jan "},{"$f":"F13","v":0},{"$f":"IF($K$7<>\"\",$K$7,\"\")","v":""},null,{"$f":"Z13","v":0},{"$f":"$AE$7","v":0},null,{"$f":"F46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,"NO",null,{"$f":"IF(((F23+F24+I13)/3)<>0,ROUND(((F23+F24+I13)/3),AY17),\"\")","v":""},{"$f":"IF(((I23+I24+L13)/3)<>0,ROUND(((I23+I24+L13)/3),AZ17),\"\")","v":""},{"$f":"IF(((L23+L24+O13)/3)<>0,ROUND(((L23+L24+O13)/3),BA17),\"\")","v":""},{"$f":"IF(((O23+O24+R13)/3)<>0,ROUND(((O23+O24+R13)/3),BB17),\"\")","v":""},null,{"$f":"IF(ISERR(FIND(\".\",F13)),0,LEN(MID(F13,FIND(\".\",F13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",I13)),0,LEN(MID(I13,FIND(\".\",I13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",L13)),0,LEN(MID(L13,FIND(\".\",L13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",O13)),0,LEN(MID(O13,FIND(\".\",O13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",R13)),0,LEN(MID(R13,FIND(\".\",R13)+1,15)))","v":0},null,null,{"$f":"IF(ISERR(FIND(\".\",Z13)),0,LEN(MID(Z13,FIND(\".\",Z13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",AC13)),0,LEN(MID(AC13,FIND(\".\",AC13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",AF13)),0,LEN(MID(AF13,FIND(\".\",AF13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",AI13)),0,LEN(MID(AI13,FIND(\".\",AI13)+1,15)))","v":0},{"$f":"IF(ISERR(FIND(\".\",AL13)),0,LEN(MID(AL13,FIND(\".\",AL13)+1,15)))","v":0},null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$F$12)","v":"Feb "},0,"",null,0,0,null,0]
[null,"Facility Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permit No.:",null,null,null,null,null,null,null,null,null,null,null,"Persons/EDU:",null,null,null,3.5,null,null,null,2014,null,null,{"$f":"IF(((F24+I13+I14)/3)<>0,ROUND(((F24+I13+I14)/3),AY17),\"\")","v":""},{"$f":"IF(((I24+L13+L14)/3)<>0,ROUND(((I24+L13+L14)/3),AZ17),\"\")","v":""},{"$f":"IF(((L24+O13+O14)/3)<>0,ROUND(((L24+O13+O14)/3),BA17),\"\")","v":""},{"$f":"IF(((O24+R13+R14)/3)<>0,ROUND(((O24+R13+R14)/3),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$F$12)","v":"Mar "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,null,{"$f":"IF(SUM(F13:F15)<>0,ROUND(AVERAGE(F13:F15),AX17),\"\")","v":""},{"$f":"IF(SUM(I13:I15)<>0,ROUND(AVERAGE(I13:I15),AY17),\"\")","v":""},{"$f":"IF(SUM(L13:L15)<>0,ROUND(AVERAGE(L13:L15),AZ17),\"\")","v":""},{"$f":"IF(SUM(O13:O15)<>0,ROUND(AVERAGE(O13:O15),BA17),\"\")","v":""},{"$f":"IF(SUM(R13:R15)<>0,ROUND(AVERAGE(R13:R15),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$F$12)","v":"Apr "},0,"",null,0,0,null,0]
[null,"Existing Hydraulic Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,"MGD",null,null,null,null,null,null,null,"Existing Organic Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,"lbs BOD5/day",null,null,null,null,null,null,null,2016,null,{"$f":"IF(SUM(F14:F16)<>0,ROUND(AVERAGE(F14:F16),AX17),\"\")","v":""},{"$f":"IF(SUM(I14:I16)<>0,ROUND(AVERAGE(I14:I16),AY17),\"\")","v":""},{"$f":"IF(SUM(L14:L16)<>0,ROUND(AVERAGE(L14:L16),AZ17),\"\")","v":""},{"$f":"IF(SUM(O14:O16)<>0,ROUND(AVERAGE(O14:O16),BA17),\"\")","v":""},{"$f":"IF(SUM(R14:R16)<>0,ROUND(AVERAGE(R14:R16),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$F$12)","v":"May "},0,"",null,0,0,null,0]
[null,"Upgrade Planned in Next 5 Years?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year:",null,null,null,null,null,"Upgrade Planned in Next 5 Years?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year:",null,null,null,null,null,2017,null,{"$f":"IF(SUM(F15:F17)<>0,ROUND(AVERAGE(F15:F17),AX17),\"\")","v":""},{"$f":"IF(SUM(I15:I17)<>0,ROUND(AVERAGE(I15:I17),AY17),\"\")","v":""},{"$f":"IF(SUM(L15:L17)<>0,ROUND(AVERAGE(L15:L17),AZ17),\"\")","v":""},{"$f":"IF(SUM(O15:O17)<>0,ROUND(AVERAGE(O15:O17),BA17),\"\")","v":""},{"$f":"IF(SUM(R15:R17)<>0,ROUND(AVERAGE(R15:R17),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$F$12)","v":"Jun "},0,"",null,0,0,null,0]
[null,"Future Hydraulic Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,"MGD",null,null,null,null,null,null,null,"Future Organic Design Capacity:",null,null,null,null,null,null,null,null,null,null,null,"lbs BOD5/day",null,null,null,null,null,null,null,2018,null,{"$f":"IF(SUM(F16:F18)<>0,ROUND(AVERAGE(F16:F18),AX17),\"\")","v":""},{"$f":"IF(SUM(I16:I18)<>0,ROUND(AVERAGE(I16:I18),AY17),\"\")","v":""},{"$f":"IF(SUM(L16:L18)<>0,ROUND(AVERAGE(L16:L18),AZ17),\"\")","v":""},{"$f":"IF(SUM(O16:O18)<>0,ROUND(AVERAGE(O16:O18),BA17),\"\")","v":""},{"$f":"IF(SUM(R16:R18)<>0,ROUND(AVERAGE(R16:R18),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$F$12)","v":"Jul "},0,"",{"$f":"F27","v":""},0,0,{"$f":"Z27","v":""},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,{"$f":"IF(SUM(F17:F19)<>0,ROUND(AVERAGE(F17:F19),AX17),\"\")","v":""},{"$f":"IF(SUM(I17:I19)<>0,ROUND(AVERAGE(I17:I19),AY17),\"\")","v":""},{"$f":"IF(SUM(L17:L19)<>0,ROUND(AVERAGE(L17:L19),AZ17),\"\")","v":""},{"$f":"IF(SUM(O17:O19)<>0,ROUND(AVERAGE(O17:O19),BA17),\"\")","v":""},{"$f":"IF(SUM(R17:R19)<>0,ROUND(AVERAGE(R17:R19),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$F$12)","v":"Aug "},0,"",null,0,0,null,0]
[null,"Month",null,null,null,"Monthly Average Flows for Past Five Years (MGD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month",null,null,null,"Monthly Average BOD5 Loads for Past Five Years (lbs/day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,{"$f":"IF(SUM(F18:F20)<>0,ROUND(AVERAGE(F18:F20),AX17),\"\")","v":""},{"$f":"IF(SUM(I18:I20)<>0,ROUND(AVERAGE(I18:I20),AY17),\"\")","v":""},{"$f":"IF(SUM(L18:L20)<>0,ROUND(AVERAGE(L18:L20),AZ17),\"\")","v":""},{"$f":"IF(SUM(O18:O20)<>0,ROUND(AVERAGE(O18:O20),BA17),\"\")","v":""},{"$f":"IF(SUM(R18:R20)<>0,ROUND(AVERAGE(R18:R20),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$F$12)","v":"Sep "},0,"",null,0,0,null,0]
[null,null,null,null,null,{"$f":"IF(Reporting_Year<>\"\",R12-4,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R12-3,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R12-2,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R12-1,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Reporting_Year<>\"\",AL12-4,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",AL12-3,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",AL12-2,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",AL12-1,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year,\"\")","v":""},null,null,null,2021,null,{"$f":"IF(SUM(F19:F21)<>0,ROUND(AVERAGE(F19:F21),AX17),\"\")","v":""},{"$f":"IF(SUM(I19:I21)<>0,ROUND(AVERAGE(I19:I21),AY17),\"\")","v":""},{"$f":"IF(SUM(L19:L21)<>0,ROUND(AVERAGE(L19:L21),AZ17),\"\")","v":""},{"$f":"IF(SUM(O19:O21)<>0,ROUND(AVERAGE(O19:O21),BA17),\"\")","v":""},{"$f":"IF(SUM(R19:R21)<>0,ROUND(AVERAGE(R19:R21),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$F$12)","v":"Oct "},0,"",null,0,0,null,0]
[null,"January",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F20:F22)<>0,ROUND(AVERAGE(F20:F22),AX17),\"\")","v":""},{"$f":"IF(SUM(I20:I22)<>0,ROUND(AVERAGE(I20:I22),AY17),\"\")","v":""},{"$f":"IF(SUM(L20:L22)<>0,ROUND(AVERAGE(L20:L22),AZ17),\"\")","v":""},{"$f":"IF(SUM(O20:O22)<>0,ROUND(AVERAGE(O20:O22),BA17),\"\")","v":""},{"$f":"IF(SUM(R20:R22)<>0,ROUND(AVERAGE(R20:R22),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$F$12)","v":"Nov "},0,"",null,0,0,null,0]
[null,"February",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F21:F23)<>0,ROUND(AVERAGE(F21:F23),AX17),\"\")","v":""},{"$f":"IF(SUM(I21:I23)<>0,ROUND(AVERAGE(I21:I23),AY17),\"\")","v":""},{"$f":"IF(SUM(L21:L23)<>0,ROUND(AVERAGE(L21:L23),AZ17),\"\")","v":""},{"$f":"IF(SUM(O21:O23)<>0,ROUND(AVERAGE(O21:O23),BA17),\"\")","v":""},{"$f":"IF(SUM(R21:R23)<>0,ROUND(AVERAGE(R21:R23),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$F$12)","v":"Dec "},0,"",null,0,0,null,0]
[null,"March",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F22:F24)<>0,ROUND(AVERAGE(F22:F24),AX17),\"\")","v":""},{"$f":"IF(SUM(I22:I24)<>0,ROUND(AVERAGE(I22:I24),AY17),\"\")","v":""},{"$f":"IF(SUM(L22:L24)<>0,ROUND(AVERAGE(L22:L24),AZ17),\"\")","v":""},{"$f":"IF(SUM(O22:O24)<>0,ROUND(AVERAGE(O22:O24),BA17),\"\")","v":""},{"$f":"IF(SUM(R22:R24)<>0,ROUND(AVERAGE(R22:R24),BB17),\"\")","v":""},null,0,0,0,0,0,null,null,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$I$12)","v":"Jan "},{"$f":"I13","v":0},"",null,{"$f":"AC13","v":0},0,null,{"$f":"I46","v":0}]
[null,"April",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$I$12)","v":"Feb "},0,"",null,0,0,null,0]
[null,"May",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AR4:AR15)<>0,ROUND(MAX(AR4:AR15),AX17),\"\")","v":""},{"$f":"IF(SUM(AS4:AS15)<>0,ROUND(MAX(AS4:AS15),AY17),\"\")","v":""},{"$f":"IF(SUM(AT4:AT15)<>0,ROUND(MAX(AT4:AT15),AZ17),\"\")","v":""},{"$f":"IF(SUM(AU4:AU15)<>0,ROUND(MAX(AU4:AU15),BA17),\"\")","v":""},{"$f":"IF(SUM(AV4:AV15)<>0,ROUND(MAX(AV4:AV15),BB17),\"\")","v":""},null,{"$f":"MAX(AX4:AX15)","v":0},{"$f":"MAX(AY4:AY15)","v":0},{"$f":"MAX(AZ4:AZ15)","v":0},{"$f":"MAX(BA4:BA15)","v":0},{"$f":"MAX(BB4:BB15)","v":0},{"$f":"MAX(AX17:BB17)","v":0},null,{"$f":"MAX(BE4:BE15)","v":0},{"$f":"MAX(BF4:BF15)","v":0},{"$f":"MAX(BG4:BG15)","v":0},{"$f":"MAX(BH4:BH15)","v":0},{"$f":"MAX(BI4:BI15)","v":0},{"$f":"MAX(BE17:BI17)","v":0},null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$I$12)","v":"Mar "},0,"",null,0,0,null,0]
[null,"June",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$I$12)","v":"Apr "},0,"",null,0,0,null,0]
[null,"July",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Months:","Max Months:","Max Months:","Max Months:","Max Months:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$I$12)","v":"May "},0,"",null,0,0,null,0]
[null,"August",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($AS$48=\"Y\",AND(AR45=\"Y\",AR46=\"Y\",AS35=\"Y\")),\"Nov, Dec, Jan\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AS45=\"Y\",AS46=\"Y\",AT35=\"Y\")),\"Nov, Dec, Jan\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AT45=\"Y\",AT46=\"Y\",AU35=\"Y\")),\"Nov, Dec, Jan\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AU45=\"Y\",AU46=\"Y\",AV35=\"Y\")),\"Nov, Dec, Jan\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$I$12)","v":"Jun "},0,"",null,0,0,null,0]
[null,"September",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($AS$48=\"Y\",AND(AR46=\"Y\",AS35=\"Y\",AS36=\"Y\")),\"Dec, Jan, Feb\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AS46=\"Y\",AT35=\"Y\",AT36=\"Y\")),\"Dec, Jan, Feb\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AT46=\"Y\",AU35=\"Y\",AU36=\"Y\")),\"Dec, Jan, Feb\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AU46=\"Y\",AV35=\"Y\",AV36=\"Y\")),\"Dec, Jan, Feb\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$I$12)","v":"Jul "},0,"",{"$f":"I27","v":""},0,0,{"$f":"AC27","v":""},0]
[null,"October",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR35=\"Y\",AR36=\"Y\",AR37=\"Y\")),\"Jan, Feb, Mar\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS35=\"Y\",AS36=\"Y\",AS37=\"Y\")),\"Jan, Feb, Mar\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT35=\"Y\",AT36=\"Y\",AT37=\"Y\")),\"Jan, Feb, Mar\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU35=\"Y\",AU36=\"Y\",AU37=\"Y\")),\"Jan, Feb, Mar\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV35=\"Y\",AV36=\"Y\",AV37=\"Y\")),\"Jan, Feb, Mar\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$I$12)","v":"Aug "},0,"",null,0,0,null,0]
[null,"November",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR36=\"Y\",AR37=\"Y\",AR38=\"Y\")),\"Feb, Mar, Apr\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS36=\"Y\",AS37=\"Y\",AS38=\"Y\")),\"Feb, Mar, Apr\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT36=\"Y\",AT37=\"Y\",AT38=\"Y\")),\"Feb, Mar, Apr\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU36=\"Y\",AU37=\"Y\",AU38=\"Y\")),\"Feb, Mar, Apr\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV36=\"Y\",AV37=\"Y\",AV38=\"Y\")),\"Feb, Mar, Apr\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$I$12)","v":"Sep "},0,"",null,0,0,null,0]
[null,"December",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR37=\"Y\",AR38=\"Y\",AR39=\"Y\")),\"Mar, Apr, May\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS37=\"Y\",AS38=\"Y\",AS39=\"Y\")),\"Mar, Apr, May\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT37=\"Y\",AT38=\"Y\",AT39=\"Y\")),\"Mar, Apr, May\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU37=\"Y\",AU38=\"Y\",AU39=\"Y\")),\"Mar, Apr, May\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV37=\"Y\",AV38=\"Y\",AV39=\"Y\")),\"Mar, Apr, May\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$I$12)","v":"Oct "},0,"",null,0,0,null,0]
[null,null,null,null,null,{"$f":"COUNTA((F13:F24))","v":0},null,null,{"$f":"COUNTA((I13:I24))","v":0},null,null,{"$f":"COUNTA((L13:L24))","v":0},null,null,{"$f":"COUNTA((O13:O24))","v":0},null,null,{"$f":"COUNTA((R13:R24))","v":0},null,null,null,null,null,null,null,{"$f":"COUNTA((Z13:Z24))","v":0},null,null,{"$f":"COUNTA((AC13:AC24))","v":0},null,null,{"$f":"COUNTA((AF13:AF24))","v":0},null,null,{"$f":"COUNTA((AI13:AI24))","v":0},null,null,{"$f":"COUNTA((AL13:AL24))","v":0},null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR38=\"Y\",AR39=\"Y\",AR40=\"Y\")),\"Apr, May, Jun\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS38=\"Y\",AS39=\"Y\",AS40=\"Y\")),\"Apr, May, Jun\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT38=\"Y\",AT39=\"Y\",AT40=\"Y\")),\"Apr, May, Jun\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU38=\"Y\",AU39=\"Y\",AU40=\"Y\")),\"Apr, May, Jun\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV38=\"Y\",AV39=\"Y\",AV40=\"Y\")),\"Apr, May, Jun\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$I$12)","v":"Nov "},0,"",null,0,0,null,0]
[null,"Annual Avg",null,null,null,{"$f":"IF(SUM(F13:F24)>0,ROUND(AVERAGE(F13:F24),AX17),\"\")","v":""},null,null,{"$f":"IF(SUM(I13:I24)>0,ROUND(AVERAGE(I13:I24),AY17),\"\")","v":""},null,null,{"$f":"IF(SUM(L13:L24)>0,ROUND(AVERAGE(L13:L24),AZ17),\"\")","v":""},null,null,{"$f":"IF(SUM(O13:O24)>0,ROUND(AVERAGE(O13:O24),BA17),\"\")","v":""},null,null,{"$f":"IF(SUM(R13:R24)>0,ROUND(AVERAGE(R13:R24),BB17),\"\")","v":""},null,null,null,"Annual Avg",null,null,null,{"$f":"IF(SUM(Z13:Z24)>0,AVERAGE(Z13:Z24),\"\")","v":""},null,null,{"$f":"IF(SUM(AC13:AC24)>0,AVERAGE(AC13:AC24),\"\")","v":""},null,null,{"$f":"IF(SUM(AF13:AF24)>0,AVERAGE(AF13:AF24),\"\")","v":""},null,null,{"$f":"IF(SUM(AI13:AI24)>0,AVERAGE(AI13:AI24),\"\")","v":""},null,null,{"$f":"IF(SUM(AL13:AL24)>0,AVERAGE(AL13:AL24),\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR39=\"Y\",AR40=\"Y\",AR41=\"Y\")),\"May, Jun, Jul\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS39=\"Y\",AS40=\"Y\",AS41=\"Y\")),\"May, Jun, Jul\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT39=\"Y\",AT40=\"Y\",AT41=\"Y\")),\"May, Jun, Jul\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU39=\"Y\",AU40=\"Y\",AU41=\"Y\")),\"May, Jun, Jul\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV39=\"Y\",AV40=\"Y\",AV41=\"Y\")),\"May, Jun, Jul\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$I$12)","v":"Dec "},0,"",null,0,0,null,0]
[null,"Max 3-Mo Avg",null,null,null,{"$f":"IF(F25=12,IF(SUM(F13:F24)<>0,IF(AR17<>\"\",AR17,\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(I25=12,IF(SUM(I13:I24)<>0,IF(AS17<>\"\",AS17,\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(L25=12,IF(SUM(L13:L24)<>0,IF(AT17<>\"\",AT17,\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(O25=12,IF(SUM(O13:O24)<>0,IF(AU17<>\"\",AU17,\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(SUM(R13:R24)<>0,IF(AV17<>\"\",AV17,\"\"),\"\"),\"\")","v":""},null,null,null,"Max Mo Avg",null,null,null,{"$f":"IF(Z25=12,IF(Z26<>\"\",MAX(Z13:Z24),\"\"),\"\")","v":""},null,null,{"$f":"IF(AC25=12,IF(AC26<>\"\",MAX(AC13:AC24),\"\"),\"\")","v":""},null,null,{"$f":"IF(AF25=12,IF(AF26<>\"\",MAX(AF13:AF24),\"\"),\"\")","v":""},null,null,{"$f":"IF(AI25=12,IF(AI26<>\"\",MAX(AI13:AI24),\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(AL26<>\"\",MAX(AL13:AL24),\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR40=\"Y\",AR41=\"Y\",AR42=\"Y\")),\"Jun, Jul, Aug\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS40=\"Y\",AS41=\"Y\",AS42=\"Y\")),\"Jun, Jul, Aug\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT40=\"Y\",AT41=\"Y\",AT42=\"Y\")),\"Jun, Jul, Aug\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU40=\"Y\",AU41=\"Y\",AU42=\"Y\")),\"Jun, Jul, Aug\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV40=\"Y\",AV41=\"Y\",AV42=\"Y\")),\"Jun, Jul, Aug\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$L$12)","v":"Jan "},{"$f":"L13","v":0},"",null,{"$f":"AF13","v":0},0,null,{"$f":"L46","v":0}]
[null,"Max : Avg Ratio",null,null,null,{"$f":"IF(AND(F27<>\"\",F26<>\"\"),F27/F26,\"\")","v":""},"  ",null,{"$f":"IF(AND(I27<>\"\",I26<>\"\"),I27/I26,\"\")","v":""},"  ",null,{"$f":"IF(AND(L27<>\"\",L26<>\"\"),L27/L26,\"\")","v":""},"  ",null,{"$f":"IF(AND(O27<>\"\",O26<>\"\"),O27/O26,\"\")","v":""},"  ",null,{"$f":"IF(AND(R27<>\"\",R26<>\"\"),R27/R26,\"\")","v":""},"  ",null,null,"Max : Avg Ratio",null,null,null,{"$f":"IF(AND(Z27<>\"\",Z26<>\"\"),Z27/Z26,\"\")","v":""},"  ",null,{"$f":"IF(AND(AC27<>\"\",AC26<>\"\"),AC27/AC26,\"\")","v":""},"  ",null,{"$f":"IF(AND(AF27<>\"\",AF26<>\"\"),AF27/AF26,\"\")","v":""},"  ",null,{"$f":"IF(AND(AI27<>\"\",AI26<>\"\"),AI27/AI26,\"\")","v":""},"  ",null,{"$f":"IF(AND(AL27<>\"\",AL26<>\"\"),AL27/AL26,\"\")","v":""},"  ",null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR41=\"Y\",AR42=\"Y\",AR43=\"Y\")),\"Jul, Aug, Sep\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS41=\"Y\",AS42=\"Y\",AS43=\"Y\")),\"Jul, Aug, Sep\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT41=\"Y\",AT42=\"Y\",AT43=\"Y\")),\"Jul, Aug, Sep\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU41=\"Y\",AU42=\"Y\",AU43=\"Y\")),\"Jul, Aug, Sep\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV41=\"Y\",AV42=\"Y\",AV43=\"Y\")),\"Jul, Aug, Sep\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$L$12)","v":"Feb "},0,"",null,0,0,null,0]
[null,"Existing EDUs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing EDUs",null,null,null,{"$f":"IF(F29<>\"\",F29,\"\")","v":""}," ",null,{"$f":"IF(I29<>\"\",I29,\"\")","v":""}," ",null,{"$f":"IF(L29<>\"\",L29,\"\")","v":""}," ",null,{"$f":"IF(O29<>\"\",O29,\"\")","v":""}," ",null,{"$f":"IF(R29<>\"\",R29,\"\")","v":""}," ",null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR42=\"Y\",AR43=\"Y\",AR44=\"Y\")),\"Aug, Sep, Oct\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS42=\"Y\",AS43=\"Y\",AS44=\"Y\")),\"Aug, Sep, Oct\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT42=\"Y\",AT43=\"Y\",AT44=\"Y\")),\"Aug, Sep, Oct\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU42=\"Y\",AU43=\"Y\",AU44=\"Y\")),\"Aug, Sep, Oct\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV42=\"Y\",AV43=\"Y\",AV44=\"Y\")),\"Aug, Sep, Oct\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$L$12)","v":"Mar "},0,"",null,0,0,null,0]
[null,"Flow/EDU (GPD)",null,null,null,{"$f":"IF(AND(F26<>\"\",F29<>\"\"),(F26/F29)*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(I26<>\"\",I29<>\"\"),(I26/I29)*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(L26<>\"\",L29<>\"\"),(L26/L29)*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(O26<>\"\",O29<>\"\"),(O26/O29)*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(R26<>\"\",R29<>\"\"),(R26/R29)*1000000,\"\")","v":""}," ",null,null,"Load/EDU",null,null,null,{"$f":"IF(AND(Z26<>\"\",Z29<>\"\"),(Z26/Z29),\"\")","v":""}," ",null,{"$f":"IF(AND(AC26<>\"\",AC29<>\"\"),(AC26/AC29),\"\")","v":""}," ",null,{"$f":"IF(AND(AF26<>\"\",AF29<>\"\"),(AF26/AF29),\"\")","v":""}," ",null,{"$f":"IF(AND(AI26<>\"\",AI29<>\"\"),(AI26/AI29),\"\")","v":""}," ",null,{"$f":"IF(AND(AL26<>\"\",AL29<>\"\"),(AL26/AL29),\"\")","v":""}," ",null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR43=\"Y\",AR44=\"Y\",AR45=\"Y\")),\"Sep, Oct, Nov\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS43=\"Y\",AS44=\"Y\",AS45=\"Y\")),\"Sep, Oct, Nov\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT43=\"Y\",AT44=\"Y\",AT45=\"Y\")),\"Sep, Oct, Nov\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU43=\"Y\",AU44=\"Y\",AU45=\"Y\")),\"Sep, Oct, Nov\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV43=\"Y\",AV44=\"Y\",AV45=\"Y\")),\"Sep, Oct, Nov\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$L$12)","v":"Apr "},0,"",null,0,0,null,0]
[null,"Flow/Capita (GPD)",null,null,null,{"$f":"IF(AND(F26<>\"\",F29<>\"\",$AL$5<>\"\"),(F26/(F29*$AL$5))*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(I26<>\"\",I29<>\"\",$AL$5<>\"\"),(I26/(I29*$AL$5))*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(L26<>\"\",L29<>\"\",$AL$5<>\"\"),(L26/(L29*$AL$5))*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(O26<>\"\",O29<>\"\",$AL$5<>\"\"),(O26/(O29*$AL$5))*1000000,\"\")","v":""}," ",null,{"$f":"IF(AND(R26<>\"\",R29<>\"\",$AL$5<>\"\"),(R26/(R29*$AL$5))*1000000,\"\")","v":""}," ",null,null,"Load/Capita",null,null,null,{"$f":"IF(AND(Z26<>\"\",Z29<>\"\",$AL$5<>\"\"),(Z26/(Z29*$AL$5)),\"\")","v":""}," ",null,{"$f":"IF(AND(AC26<>\"\",AC29<>\"\",$AL$5<>\"\"),(AC26/(AC29*$AL$5)),\"\")","v":""}," ",null,{"$f":"IF(AND(AF26<>\"\",AF29<>\"\",$AL$5<>\"\"),(AF26/(AF29*$AL$5)),\"\")","v":""}," ",null,{"$f":"IF(AND(AI26<>\"\",AI29<>\"\",$AL$5<>\"\"),(AI26/(AI29*$AL$5)),\"\")","v":""}," ",null,{"$f":"IF(AND(AL26<>\"\",AL29<>\"\",$AL$5<>\"\"),(AL26/(AL29*$AL$5)),\"\")","v":""}," ",null,null,null,null,{"$f":"IF(AND(AR48=\"Y\",AND(AR44=\"Y\",AR45=\"Y\",AR46=\"Y\")),\"Oct, Nov, Dec\",\"\")","v":""},{"$f":"IF(AND($AS$48=\"Y\",AND(AS44=\"Y\",AS45=\"Y\",AS46=\"Y\")),\"Oct, Nov, Dec\",\"\")","v":""},{"$f":"IF(AND($AT$48=\"Y\",AND(AT44=\"Y\",AT45=\"Y\",AT46=\"Y\")),\"Oct, Nov, Dec\",\"\")","v":""},{"$f":"IF(AND($AU$48=\"Y\",AND(AU44=\"Y\",AU45=\"Y\",AU46=\"Y\")),\"Oct, Nov, Dec\",\"\")","v":""},{"$f":"IF(AND($AV$48=\"Y\",AND(AV44=\"Y\",AV45=\"Y\",AV46=\"Y\")),\"Oct, Nov, Dec\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$L$12)","v":"May "},0,"",null,0,0,null,0]
[null,"Exist. Overload?",null,null,null,{"$f":"IF(F25=12,IF(AND(F27<>\"\",$K$7<>\"\"),IF($AR$48=\"Y\",\"YES\",\"NO\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(I25=12,IF(AND(I27<>\"\",$K$7<>\"\"),IF($AS$48=\"Y\",\"YES\",\"NO\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(L25=12,IF(AND(L27<>\"\",$K$7<>\"\"),IF($AT$48=\"Y\",\"YES\",\"NO\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(O25=12,IF(AND(O27<>\"\",$K$7<>\"\"),IF($AU$48=\"Y\",\"YES\",\"NO\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(AND(R27<>\"\",$K$7<>\"\"),IF($AV$48=\"Y\",\"YES\",\"NO\"),\"\"),\"\")","v":""},null,null,null,"Exist. Overload?",null,null,null,{"$f":"IF(Z25=12,IF(SUM(Z13:Z24)<>0,IF(AND(Z27<>0,$AE$7<>0),IF(Z27>$AE$7,\"YES\",\"NO\"),\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(AC25=12,IF(SUM(AC13:AC24)<>0,IF(AND(AC27<>0,$AE$7<>0),IF(AC27>$AE$7,\"YES\",\"NO\"),\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(AF25=12,IF(SUM(AF13:AF24)<>0,IF(AND(AF27<>0,$AE$7<>0),IF(AF27>$AE$7,\"YES\",\"NO\"),\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(AI25=12,IF(SUM(AI13:AI24)<>0,IF(AND(AI27<>0,$AE$7<>0),IF(AI27>$AE$7,\"YES\",\"NO\"),\"\"),\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(SUM(AL13:AL24)<>0,IF(AND(AL27<>0,$AE$7<>0),IF(AL27>$AE$7,\"YES\",\"NO\"),\"\"),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$L$12)","v":"Jun "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Overload: 3 Consecutive Months > Hydraulic Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$L$12)","v":"Jul "},0,"",{"$f":"L27","v":""},0,0,{"$f":"AF27","v":""},0]
[null,null,null,null,null,"Projected Flows for Next Five Years (MGD)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected BOD5 Loads for Next Five Years (lbs/day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR3","v":""},{"$f":"AS3","v":""},{"$f":"AT3","v":""},{"$f":"AU3","v":""},{"$f":"AV3","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$L$12)","v":"Aug "},0,"",null,0,0,null,0]
[null,null,null,null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+1,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+2,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+3,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+4,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+5,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+1,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+2,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+3,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+4,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year+5,\"\")","v":""},null,null,null,null,"Jan",{"$f":"IF(F13<>\"\",IF(F13>$K$7,\"Y\",\"\"),\"\")","v":""},{"$f":"IF(I13<>\"\",IF(I13>$K$7,\"Y\",\"\"),\"\")","v":""},{"$f":"IF(L13<>\"\",IF(L13>$K$7,\"Y\",\"\"),\"\")","v":""},{"$f":"IF(O13<>\"\",IF(O13>$K$7,\"Y\",\"\"),\"\")","v":""},{"$f":"IF(R13<>\"\",IF(R13>$K$7,\"Y\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$L$12)","v":"Sep "},0,{"$f":"IF($K$7<>\"\",$K$7,\"\")","v":""},null,0,{"$f":"$AE$7","v":0},null,0]
[null,"New EDUs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New EDUs",null,null,null,{"$f":"IF(F36<>\"\",F36,\"\")","v":""},null,null,{"$f":"IF(I36<>\"\",I36,\"\")","v":""},null,null,{"$f":"IF(L36<>\"\",L36,\"\")","v":""},null,null,{"$f":"IF(O36<>\"\",O36,\"\")","v":""},null,null,{"$f":"IF(R36<>\"\",R36,\"\")","v":""},null,null,null,null,"Feb","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$L$12)","v":"Oct "},0,"",null,0,0,null,0]
[null,"New EDU Flow",null,null,null,{"$f":"IF(F36<>\"\",IF(F36<>0,IF(SUM($F$30:$R$30)<>0,ROUND(((F36*AVERAGE($F$30:$R$30))/1000000),4),0.00035*F36),0),\"\")","v":""},null,null,{"$f":"IF(I36<>\"\",IF(I36<>0,IF(SUM($F$30:$R$30)<>0,ROUND(((I36*AVERAGE($F$30:$R$30))/1000000),4),0.00035*I36),0),\"\")","v":""},null,null,{"$f":"IF(L36<>\"\",IF(L36<>0,IF(SUM($F$30:$R$30)<>0,ROUND(((L36*AVERAGE($F$30:$R$30))/1000000),4),0.00035*L36),0),\"\")","v":""},null,null,{"$f":"IF(O36<>\"\",IF(O36<>0,IF(SUM($F$30:$R$30)<>0,ROUND(((O36*AVERAGE($F$30:$R$30))/1000000),4),0.00035*O36),0),\"\")","v":""},null,null,{"$f":"IF(R36<>\"\",IF(R36<>0,IF(SUM($F$30:$R$30)<>0,ROUND(((R36*AVERAGE($F$30:$R$30))/1000000),4),0.00035*R36),0),\"\")","v":""},null,null,null,"New EDU Load",null,null,null,{"$f":"IF(Z36<>\"\",IF(Z36<>0,IF(SUM($Z$30:$AL$30)<>0,ROUND(Z36*AVERAGE($Z$30:$AL$30),4),Z36*0.584),0),\"\")","v":""},null,null,{"$f":"IF(AC36<>\"\",IF(AC36<>0,IF(SUM($Z$30:$AL$30)<>0,ROUND(AC36*AVERAGE($Z$30:$AL$30),4),AC36*0.584),0),\"\")","v":""},null,null,{"$f":"IF(AF36<>\"\",IF(AF36<>0,IF(SUM($Z$30:$AL$30)<>0,ROUND(AF36*AVERAGE($Z$30:$AL$30),4),AF36*0.584),0),\"\")","v":""},null,null,{"$f":"IF(AI36<>\"\",IF(AI36<>0,IF(SUM($Z$30:$AL$30)<>0,ROUND(AI36*AVERAGE($Z$30:$AL$30),4),AI36*0.584),0),\"\")","v":""},null,null,{"$f":"IF(AL36<>\"\",IF(AL36<>0,IF(SUM($Z$30:$AL$30)<>0,ROUND(AL36*AVERAGE($Z$30:$AL$30),4),AL36*0.584),0),\"\")","v":""},null,null,null,null,"Mar","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$L$12)","v":"Nov "},0,"",null,0,0,null,0]
[null,"Proj. Annual Avg",null,null,null,{"$f":"IF(AND(SUM(F26:R26)<>\"\",R26<>\"\"),ROUND((IF(F61=\"None\",AVERAGE(F26:R26),R26)+IF(F37<>\"\",F37,0)),BC17),\"\")","v":""},null,null,{"$f":"IF(AND(F38<>\"\",I37<>\"\"),F38+I37,\"\")","v":""},null,null,{"$f":"IF(AND(I38<>\"\",L37<>\"\"),I38+L37,\"\")","v":""},null,null,{"$f":"IF(AND(L38<>\"\",O37<>\"\"),L38+O37,\"\")","v":""},null,null,{"$f":"IF(AND(O38<>\"\",R37<>\"\"),O38+R37,\"\")","v":""},null,null,null,"Proj. Annual Avg",null,null,null,{"$f":"IF(AND(SUM(Z26:AL26)<>\"\",Z37<>\"\"),IF(F62=\"None\",AVERAGE(Z26:AL26),AL26)+Z37,\"\")","v":""},null,null,{"$f":"IF(AND(Z38<>\"\",AC37<>\"\"),Z38+AC37,\"\")","v":""},null,null,{"$f":"IF(AND(AC38<>\"\",AF37<>\"\"),AC38+AF37,\"\")","v":""},null,null,{"$f":"IF(AND(AF38<>\"\",AI37<>\"\"),AF38+AI37,\"\")","v":""},null,null,{"$f":"IF(AND(AI38<>\"\",AL37<>\"\"),AI38+AL37,\"\")","v":""},null,null,null,null,"Apr","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$L$12)","v":"Dec "},0,"",null,0,0,null,0]
[null,"Proj. Max 3-Mo Avg",null,null,null,{"$f":"IF(F38<>\"\",IF(SUM($F$28:$R$28)<>0,ROUND((AVERAGE($F$28:$R28)*F38),BC17),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(I38<>\"\",ROUND((AVERAGE($F$28:$R28)*I38),BC17),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(L38<>\"\",ROUND((AVERAGE($F$28:$R28)*L38),BC17),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(O38<>\"\",ROUND((AVERAGE($F$28:$R28)*O38),BC17),\"\"),\"\")","v":""},null,null,{"$f":"IF(R25=12,IF(R38<>\"\",ROUND((AVERAGE($F$28:$R28)*R38),BC17),\"\"),\"\")","v":""},null,null,null,"Proj. Max Avg",null,null,null,{"$f":"IF(Z38<>\"\",IF(SUM($Z$28:$AL$28)<>0,AVERAGE($Z$28:$AL28)*Z38,\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(AC38<>\"\",AVERAGE($Z$28:$AL28)*AC38,\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(AF38<>\"\",AVERAGE($Z$28:$AL28)*AF38,\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(AI38<>\"\",AVERAGE($Z$28:$AL28)*AI38,\"\"),\"\")","v":""},null,null,{"$f":"IF(AL25=12,IF(AL38<>\"\",AVERAGE($Z$28:$AL28)*AL38,\"\"),\"\")","v":""},null,null,null,null,"May","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$O$12)","v":"Jan "},{"$f":"O13","v":0},"",null,{"$f":"AI13","v":0},0,null,{"$f":"O46","v":0}]
[null,"Proj. Overload?",null,null,null,{"$f":"IF(AND(F39<>\"\",$K$7<>\"\"),IF(F39>AL65,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(I39<>\"\",$K$7<>\"\"),IF(I39>AL66,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(L39<>\"\",$K$7<>\"\"),IF(L39>AL67,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(O39<>\"\",$K$7<>\"\"),IF(O39>AL68,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(R39<>\"\",$K$7<>\"\"),IF(R39>AL69,\"YES\",\"NO\"),\"\")","v":""},null,null,null,"Proj. Overload?",null,null,null,{"$f":"IF(AND(Z39<>\"\",$AE$7<>\"\"),IF(Z39>AL75,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(AC39<>\"\",$AE$7<>\"\"),IF(AC39>AL76,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(AF39<>\"\",$AE$7<>\"\"),IF(AF39>AL77,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(AI39<>\"\",$AE$7<>\"\"),IF(AI39>AL78,\"YES\",\"NO\"),\"\")","v":""},null,null,{"$f":"IF(AND(AL39<>\"\",$AE$7<>\"\"),IF(AL39>AL79,\"YES\",\"NO\"),\"\")","v":""},null,null,null,null,"Jun","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$O$12)","v":"Feb "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jul","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$O$12)","v":"Mar "},0,"",null,0,0,null,0]
[null,null,"Show Precipitation Data on Hydraulic Graph?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aug","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$O$12)","v":"Apr "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sep","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$O$12)","v":"May "},0,"",null,0,0,null,0]
[null,"Month",null,null,null,"Total Monthly Precipitation for Past Five Years (Inches)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oct","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$O$12)","v":"Jun "},0,"",null,0,0,null,0]
[null,null,null,null,null,{"$f":"IF(Reporting_Year<>\"\",R45-4,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R45-3,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R45-2,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",R45-1,\"\")","v":""},null,null,{"$f":"IF(Reporting_Year<>\"\",Reporting_Year,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nov","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$O$12)","v":"Jul "},0,"",{"$f":"O27","v":""},0,0,{"$f":"AI27","v":""},0]
[null,"January",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dec","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$O$12)","v":"Aug "},0,"",null,0,0,null,0]
[null,"February",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overload?","Overload?","Overload?","Overload?","Overload?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$O$12)","v":"Sep "},0,"",null,0,0,null,0]
[null,"March",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(AR35=\"Y\",AR36=\"Y\",AR37=\"Y\"),AND(AR36=\"Y\",AR37=\"Y\",AR38=\"Y\"),AND(AR37=\"Y\",AR38=\"Y\",AR39=\"Y\"),AND(AR38=\"Y\",AR39=\"Y\",AR40=\"Y\"),AND(AR39=\"Y\",AR40=\"Y\",AR41=\"Y\"),AND(AR40=\"Y\",AR41=\"Y\",AR42=\"Y\"),AND(AR41=\"Y\",AR42=\"Y\",AR43=\"Y\"),AND(AR42=\"Y\",AR43=\"Y\",AR44=\"Y\"),AND(AR43=\"Y\",AR44=\"Y\",AR45=\"Y\"),AND(AR44=\"Y\",AR45=\"Y\",AR46=\"Y\")),\"Y\",\"\")","v":""},{"$f":"IF(OR(AND(AR45=\"Y\",AR46=\"Y\",AS35=\"Y\"),AND(AR46=\"Y\",AS35=\"Y\",AS36=\"Y\"),AND(AS35=\"Y\",AS36=\"Y\",AS37=\"Y\"),AND(AS36=\"Y\",AS37=\"Y\",AS38=\"Y\"),AND(AS37=\"Y\",AS38=\"Y\",AS39=\"Y\"),AND(AS38=\"Y\",AS39=\"Y\",AS40=\"Y\"),AND(AS39=\"Y\",AS40=\"Y\",AS41=\"Y\"),AND(AS40=\"Y\",AS41=\"Y\",AS42=\"Y\"),AND(AS41=\"Y\",AS42=\"Y\",AS43=\"Y\"),AND(AS42=\"Y\",AS43=\"Y\",AS44=\"Y\"),AND(AS43=\"Y\",AS44=\"Y\",AS45=\"Y\"),AND(AS44=\"Y\",AS45=\"Y\",AS46=\"Y\")),\"Y\",\"\")","v":""},{"$f":"IF(OR(AND(AS45=\"Y\",AS46=\"Y\",AT35=\"Y\"),AND(AS46=\"Y\",AT35=\"Y\",AT36=\"Y\"),AND(AT35=\"Y\",AT36=\"Y\",AT37=\"Y\"),AND(AT36=\"Y\",AT37=\"Y\",AT38=\"Y\"),AND(AT37=\"Y\",AT38=\"Y\",AT39=\"Y\"),AND(AT38=\"Y\",AT39=\"Y\",AT40=\"Y\"),AND(AT39=\"Y\",AT40=\"Y\",AT41=\"Y\"),AND(AT40=\"Y\",AT41=\"Y\",AT42=\"Y\"),AND(AT41=\"Y\",AT42=\"Y\",AT43=\"Y\"),AND(AT42=\"Y\",AT43=\"Y\",AT44=\"Y\"),AND(AT43=\"Y\",AT44=\"Y\",AT45=\"Y\"),AND(AT44=\"Y\",AT45=\"Y\",AT46=\"Y\")),\"Y\",\"\")","v":""},{"$f":"IF(OR(AND(AT45=\"Y\",AT46=\"Y\",AU35=\"Y\"),AND(AT46=\"Y\",AU35=\"Y\",AU36=\"Y\"),AND(AU35=\"Y\",AU36=\"Y\",AU37=\"Y\"),AND(AU36=\"Y\",AU37=\"Y\",AU38=\"Y\"),AND(AU37=\"Y\",AU38=\"Y\",AU39=\"Y\"),AND(AU38=\"Y\",AU39=\"Y\",AU40=\"Y\"),AND(AU39=\"Y\",AU40=\"Y\",AU41=\"Y\"),AND(AU40=\"Y\",AU41=\"Y\",AU42=\"Y\"),AND(AU41=\"Y\",AU42=\"Y\",AU43=\"Y\"),AND(AU42=\"Y\",AU43=\"Y\",AU44=\"Y\"),AND(AU43=\"Y\",AU44=\"Y\",AU45=\"Y\"),AND(AU44=\"Y\",AU45=\"Y\",AU46=\"Y\")),\"Y\",\"\")","v":""},{"$f":"IF(OR(AND(AU45=\"Y\",AU46=\"Y\",AV35=\"Y\"),AND(AU46=\"Y\",AV35=\"Y\",AV36=\"Y\"),AND(AV35=\"Y\",AV36=\"Y\",AV37=\"Y\"),AND(AV36=\"Y\",AV37=\"Y\",AV38=\"Y\"),AND(AV37=\"Y\",AV38=\"Y\",AV39=\"Y\"),AND(AV38=\"Y\",AV39=\"Y\",AV40=\"Y\"),AND(AV39=\"Y\",AV40=\"Y\",AV41=\"Y\"),AND(AV40=\"Y\",AV41=\"Y\",AV42=\"Y\"),AND(AV41=\"Y\",AV42=\"Y\",AV43=\"Y\"),AND(AV42=\"Y\",AV43=\"Y\",AV44=\"Y\"),AND(AV43=\"Y\",AV44=\"Y\",AV45=\"Y\"),AND(AV44=\"Y\",AV45=\"Y\",AV46=\"Y\")),\"Y\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$O$12)","v":"Oct "},0,"",null,0,0,null,0]
[null,"April",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$O$12)","v":"Nov "},0,"",null,0,0,null,0]
[null,"May",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$O$12)","v":"Dec "},0,"",null,0,0,null,0]
[null,"June",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$R$12)","v":"Jan "},{"$f":"R13","v":0},"",null,{"$f":"AL13","v":0},0,null,{"$f":"R46","v":0}]
[null,"July",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$R$12)","v":"Feb "},0,"",null,0,0,null,0]
[null,"August",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$R$12)","v":"Mar "},0,"",null,0,0,null,0]
[null,"September",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$R$12)","v":"Apr "},0,"",null,0,0,null,0]
[null,"October",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$R$12)","v":"May "},0,"",null,0,0,null,0]
[null,"November",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$R$12)","v":"Jun "},0,"",null,0,0,null,0]
[null,"December",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$R$12)","v":"Jul "},0,"",{"$f":"R27","v":""},0,0,{"$f":"AL27","v":""},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$R$12)","v":"Aug "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$R$12)","v":"Sep "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$R$12)","v":"Oct "},0,"",null,0,0,null,0]
[null,"Hydraulic Trend:",null,null,null,{"$f":"IF(AND(R26>P26,P26>M26,M26>J26,J26>F26),\"Upward\",\"None\")","v":"None"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for Projected Hydraulic Overload:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$R$12)","v":"Nov "},0,"",null,0,0,null,0]
[null,"Organic Trend: ",null,null,null,{"$f":"IF(AND(AL26>AI26,AI26>AF26,AF26>AC26,AC26>Z26),\"Upward\",\"None\")","v":"None"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$R$12)","v":"Dec "},0,"",null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Upgrade Year > Reporting Year?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Hydr_UpgradeYear>Reporting_Year,\"YES\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$F$35)","v":"Jan "},null,{"$f":"IF($AL$65<>\"\",$AL$65,\"\")","v":0},null,null,{"$f":"$AL$75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Upgrade Year <= 5 Years from Reporting Year?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL63=\"YES\",IF((Reporting_Year+5)>=Hydr_UpgradeYear,\"YES\",\"\"),\"\")","v":""},null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$F$35)","v":"Feb "},null,{"$f":"IF($AL$65<>\"\",$AL$65,\"\")","v":0},null,null,{"$f":"$AL$75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+1","v":1},null,null,null,null,null,{"$f":"IF(AND(AL63=\"YES\",AL64=\"YES\"),IF(Hydr_UpgradeYear=(Reporting_Year+1),K9,K7),K7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$F$35)","v":"Mar "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+2","v":2},null,null,null,null,null,{"$f":"IF(AND($AL$63=\"YES\",$AL$64=\"YES\"),IF(OR(Hydr_UpgradeYear=(Reporting_Year+2),K9=AL65),$K$9,$K$7),$K$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$F$35)","v":"Apr "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+3","v":3},null,null,null,null,null,{"$f":"IF(AND($AL$63=\"YES\",$AL$64=\"YES\"),IF(OR(Hydr_UpgradeYear=(Reporting_Year+3),K9=AL66),$K$9,$K$7),$K$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$F$35)","v":"May "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+4","v":4},null,null,null,null,null,{"$f":"IF(AND($AL$63=\"YES\",$AL$64=\"YES\"),IF(OR(Hydr_UpgradeYear=(Reporting_Year+4),K9=AL67),$K$9,$K$7),$K$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$F$35)","v":"Jun "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+5","v":5},null,null,null,null,null,{"$f":"IF(AND($AL$63=\"YES\",$AL$64=\"YES\"),IF(OR(Hydr_UpgradeYear=(Reporting_Year+5),K9=AL68),$K$9,$K$7),$K$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$F$35)","v":"Jul "},{"$f":"F38","v":""},0,{"$f":"F39","v":""},{"$f":"Z38","v":""},0,{"$f":"Z39","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$F$35)","v":"Aug "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for Projected Organic Overload:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$F$35)","v":"Sep "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$F$35)","v":"Oct "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Upgrade Year > Reporting Year?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Org_UpgradeYear>Reporting_Year,\"YES\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$F$35)","v":"Nov "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is Upgrade Year <= 5 Years from Reporting Year?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL73=\"YES\",IF((Reporting_Year+5)>=Org_UpgradeYear,\"YES\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$F$35)","v":"Dec "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+1","v":1},null,null,null,null,null,{"$f":"IF(AND($AL$73=\"YES\",$AL$74=\"YES\"),IF(Org_UpgradeYear=(Reporting_Year+1),$AE$9,$AE$7),$AE$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$I$35)","v":"Jan "},null,{"$f":"IF($AL$66<>\"\",$AL$66,\"\")","v":0},null,null,{"$f":"$AL$76","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+2","v":2},null,null,null,null,null,{"$f":"IF(AND($AL$73=\"YES\",$AL$74=\"YES\"),IF(OR(Org_UpgradeYear=(Reporting_Year+2),AE9=AL75),$AE$9,$AE$7),$AE$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$I$35)","v":"Feb "},null,{"$f":"IF($AL$66<>\"\",$AL$66,\"\")","v":0},null,null,{"$f":"$AL$76","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+3","v":3},null,null,null,null,null,{"$f":"IF(AND($AL$73=\"YES\",$AL$74=\"YES\"),IF(OR(Org_UpgradeYear=(Reporting_Year+3),AE9=AL76),$AE$9,$AE$7),$AE$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$I$35)","v":"Mar "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+4","v":4},null,null,null,null,null,{"$f":"IF(AND($AL$73=\"YES\",$AL$74=\"YES\"),IF(OR(Org_UpgradeYear=(Reporting_Year+4),AE9=AL77),$AE$9,$AE$7),$AE$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$I$35)","v":"Apr "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number to compare for:",null,null,null,null,null,{"$f":"Reporting_Year+5","v":5},null,null,null,null,null,{"$f":"IF(AND($AL$73=\"YES\",$AL$74=\"YES\"),IF(OR(Org_UpgradeYear=(Reporting_Year+5),AE9=AL78),$AE$9,$AE$7),$AE$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$I$35)","v":"May "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$I$35)","v":"Jun "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$I$35)","v":"Jul "},{"$f":"I38","v":""},0,{"$f":"I39","v":""},{"$f":"AC38","v":""},0,{"$f":"AC39","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$I$35)","v":"Aug "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$I$35)","v":"Sep "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$I$35)","v":"Oct "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$I$35)","v":"Nov "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$I$35)","v":"Dec "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$L$35)","v":"Jan "},null,{"$f":"IF($AL$67<>\"\",$AL$67,\"\")","v":0},null,null,{"$f":"$AL$77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$L$35)","v":"Feb "},null,{"$f":"IF($AL$67<>\"\",$AL$67,\"\")","v":0},null,null,{"$f":"$AL$77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$L$35)","v":"Mar "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$L$35)","v":"Apr "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$L$35)","v":"May "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$L$35)","v":"Jun "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$L$35)","v":"Jul "},{"$f":"L38","v":""},0,{"$f":"L39","v":""},{"$f":"AF38","v":""},0,{"$f":"AF39","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$L$35)","v":"Aug "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$L$35)","v":"Sep "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$L$35)","v":"Oct "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$L$35)","v":"Nov "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$L$35)","v":"Dec "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$O$35)","v":"Jan "},null,{"$f":"IF($AL$68<>\"\",$AL$68,\"\")","v":0},null,null,{"$f":"$AL$78","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$O$35)","v":"Feb "},null,{"$f":"IF($AL$68<>\"\",$AL$68,\"\")","v":0},null,null,{"$f":"$AL$78","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$O$35)","v":"Mar "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$O$35)","v":"Apr "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$O$35)","v":"May "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$O$35)","v":"Jun "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$O$35)","v":"Jul "},{"$f":"O38","v":""},0,{"$f":"O39","v":""},{"$f":"AI38","v":""},0,{"$f":"AI39","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Aug \",$O$35)","v":"Aug "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Sep \",$O$35)","v":"Sep "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Oct \",$O$35)","v":"Oct "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Nov \",$O$35)","v":"Nov "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Dec \",$O$35)","v":"Dec "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jan \",$R$35)","v":"Jan "},null,{"$f":"IF($AL$69<>\"\",$AL$69,\"\")","v":0},null,null,{"$f":"$AL$79","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Feb \",$R$35)","v":"Feb "},null,{"$f":"IF($AL$69<>\"\",$AL$69,\"\")","v":0},null,null,{"$f":"$AL$79","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Mar \",$R$35)","v":"Mar "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Apr \",$R$35)","v":"Apr "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"May \",$R$35)","v":"May "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jun \",$R$35)","v":"Jun "},null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Jul \",$R$35)","v":"Jul "},{"$f":"R38","v":""},0,{"$f":"R39","v":""},{"$f":"AL38","v":""},0,{"$f":"AL39","v":""}]