{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["WQC Fee Calc","Variables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":20,"comments":0,"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":"WQC Fee Calc","index":0,"n_rows":139,"n_cols":11,"rows_kept":139,"cut":false,"hidden":false,"merged":[[52,8,52,9],[44,9,44,10],[57,9,58,9],[53,10,54,10],[57,10,58,10],[55,8,56,9],[55,10,56,10],[45,9,48,10],[9,5,10,5],[29,10,31,10],[34,10,36,10],[16,9,16,10],[9,9,10,9],[9,7,10,7],[17,8,19,8],[17,10,19,10],[24,8,26,8],[24,10,26,10],[20,1,20,10],[12,1,14,4],[1,1,2,10],[9,8,10,8],[9,10,10,10],[21,8,22,8],[21,10,22,10],[12,8,14,8],[12,9,14,9],[12,10,14,10],[17,9,19,9],[7,1,7,10],[6,1,6,10],[8,1,9,4],[9,6,10,6],[17,1,19,4],[5,1,5,10],[4,1,4,10],[138,1,149,10],[68,1,107,10],[25,4,25,6],[30,1,30,6],[109,1,111,10],[34,8,36,8],[61,1,66,10],[136,1,136,10],[126,1,134,10],[113,1,124,10],[29,8,31,8],[39,8,41,8],[39,10,41,10],[35,4,35,6],[40,1,40,6],[53,8,54,9],[47,1,47,6],[46,1,46,6],[45,1,45,6],[48,1,48,6],[24,11,26,12]]}
[]
[null,"FY 18/19 Water Quality Certification Dredge and Fill Application Fee Calculator"]
[]
[]
[null,"Scroll down to see instructions below and use this calculator to estimate Water Quality Certification application fees\n          \n"]
[null,"This calculator is publicly available for informational purposes only for applications received on or after November 5, 2018. Applicants may use the calculator to generate estimates for project budgeting. The State Water Board does not guarantee the accuracy of estimates generated by the calculator. The final fee amount will be determined by Water Boards staff in accordance with California Code of Regulations, Title 23, section 2200(a)(3). The State Water Board reserves the right to modify the calculator at any time. Click here for a link to the current regulations.    \n\n"]
[null,"Important note for federal dischargers: This calculator may not be applicable to federal dischargers."]
[null,"    Please contact the State Water Board WQC manager with any questions"]
[null,"\nCombination Project: Check box for combination deep water dredging and fill projects; which are subject to both Category A and B fees.",null,null,null,null,false]
[null,null,null,null,null,null,"Discharge \nSize\n","Rounded \nDischarge \nSize\n","Application \nFee","Category A Project Fee Due prior to certification; \ndo not submit with application","Annual \nFee"]
[]
[null,"Category A Fill & Excavation Discharges (Fee Code 84)"]
[null,"Discharge Area Acres x $14,489",null,null,null,null,null,null,{"$f":"IF(AND(G9=TRUE,OR(G14=\"\",G19=\"\")),\"Enter Category A and B discharge quantities or uncheck 'Combination Project' box\",IF(OR(H48=TRUE,H49=TRUE,AND(G14=\"\",G19=\"\")),0,IF(AND(G9=TRUE,G14<>\"\",G19<>\"\"),1638,IF(AND(G9<>TRUE,G19<>\"\",G14<>\"\"),\"Delete dredge volume or check 'Combination Project' box\",IF(G14=\"\",0,1638)))))","v":0},{"$f":"IF(AND(G9=TRUE,OR(G14=\"\",G19=\"\")),\"Enter Category A and B discharge quantities or uncheck 'Combination Project' box\",IF(AND(G19<>\"\",G14<>\"\",G9<>TRUE),\"-\",IF(H14*14489<1638,0,IF(H14*14489>1638,IF(H14*14489>142100,140462,H14*14489-1638)))))","v":0},{"$f":"IF(G9=TRUE,\"-\",IF(AND(G19<>\"\",G14<>\"\",G9<>TRUE),\"Delete dredge volume or check 'Combination Project' box\",IF(G14=\"\",0,IF(J13=140462,\"-\",1638))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ROUND(G14,2)<0,0,(ROUND(G14,2)))","v":0}]
[null,null,null,null,null,null,null,"Rounded to two \ndecimal places"]
[]
[null,"Category B* Dredging Discharges (Fee Code 86)",null,null,null,null,null,null,null,"Expected annual fee"]
[null,"Expected Annual Dredge \nQuantity Cubic Yards x $0.358",null,null,null,null,null,null,{"$f":"IF(AND(G9=TRUE,OR(G14=\"\",G19=\"\")),\"Enter Category A and B discharge quantities or uncheck 'Combination Project' box\",IF(OR(H48=TRUE,H49=TRUE,AND(G14=\"\",G19=\"\")),0,IF(AND(G9=TRUE,G19>0),\"-\",IF(AND(G19<>\"\",G14<>\"\",G9<>TRUE),\"Delete discharge area or check 'Combination Project' box\",IF(G19=\"\",0,1638)))))","v":0},"-",{"$f":"IF(AND(G9=TRUE,OR(G14=\"\",G19=\"\")),\"Enter Category A and B discharge quantities or uncheck 'Combination Project' box\",IF(AND(G19<>\"\",G14<>\"\",G9<>TRUE),\"Delete dredge volume or check 'Combination Project' box\",IF(G19=\"\",0,IF(AND(G9=TRUE,H19<>\"\",J13=140462),0,IF(AND(G9=TRUE,H19<>\"\",(1638+J13>142100)),(142100-J13)-1638,IF(H19*0.358<1638,1638,IF(H19*0.358+1638+J13>140462,142100-J13-1638,H19*0.358)))))))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ROUND(G19,0)<0,0,(ROUND(G19,0)))","v":0}]
[null,null,null,null,null,null,null,"Rounded to \nwhole number"]
[null,"*Category B Projects are billed annually and based on the quantity of material dredged during the previous fiscal year"]
[null,null,null,null,null,null,null,null,"Application \nFee",null,"Annual \nFee"]
[null,"Flat Fee Categories - Check ONE applicable box "]
[null,"Category C (Fee Code 85)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(H26=TRUE,OR(H31=TRUE,H36=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H26=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H26=TRUE,1638,0)))","v":0},null,{"$f":"IF(AND(H26=TRUE,OR(H31=TRUE,H36=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H26=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H26=TRUE,819,0)))","v":0}]
[null,null,null,null,"Sand Mining Dredging Discharges",null,null,false]
[]
[]
[null,"Category D (Fee Code 85)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(H31=TRUE,OR(H26=TRUE,H36=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H31=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H31=TRUE,437,0)))","v":0},null,{"$f":"IF(AND(H31=TRUE,OR(H26=TRUE,H36=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H31=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H31=TRUE,218,0)))","v":0}]
[null,"Ecological Restoration and Enhancement Projects",null,null,null,null,null,false,null,"-"]
[]
[]
[null,"Category E (Fee Code 87)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(H36=TRUE,OR(H31=TRUE,H26=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H36=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H36=TRUE,1638,0)))","v":0},null,{"$f":"IF(AND(H36=TRUE,OR(H31=TRUE,H26=TRUE,H41=TRUE)),\"Check only one flat fee category\",IF(AND(H36=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H36=TRUE,218,0)))","v":0}]
[null,null,null,null,"Low Impact Discharges",null,null,false,null,"-"]
[]
[]
[null,"Category F (Fee Code 85)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(H41=TRUE,OR(H31=TRUE,H36=TRUE,H26=TRUE)),\"Check only one flat fee category\",IF(AND(H41=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H41=TRUE,1638,0)))","v":0},null,{"$f":"IF(AND(H41=TRUE,OR(H31=TRUE,H36=TRUE,H26=TRUE)),\"Check only one flat fee category\",IF(AND(H41=TRUE,OR(G14>0,G19>0)),\"Delete discharge to select flat fee\",IF(H41=TRUE,218,0)))","v":0}]
[null,"Emergency Projects authorized by a General Order",null,null,null,null,null,false,null,"-"]
[]
[]
[null,"Amended Orders - Check applicable box"]
[null,"Step 5 below "]
[null,"(1) All Category (D) Ecological and Restoration and Enhancement Projects, regardless of amendment type.",null,null,null,null,null,false,{"$f":"IF(AND(H46=TRUE,OR(H26=TRUE,H31=TRUE,H36=TRUE,H41=TRUE)),\"Check only one category\",IF(AND(H46=TRUE,OR(H47=TRUE,H48=TRUE,H49=TRUE)),\"Check only one sub-category\",IF(H46=TRUE,\"No fee required\",\"\")))","v":""},"Annual fee applicable per \ndischarge category above."]
[null,"(2) Administrative amendments including, but not limited to, ownership changes, typographic edits, or time extensions that do not result in a temporal loss of resource function.  Amendments in this category require no technical analysis or additional compensatory mitigation.",null,null,null,null,null,false,{"$f":"IF(AND(H47=TRUE,OR(H26=TRUE,H31=TRUE,H36=TRUE,H41=TRUE)),\"Check only one category\",IF(AND(H47=TRUE,OR(H46=TRUE, H48=TRUE,H49=TRUE)),\"Check only one sub-category\",IF(H47=TRUE,\"No fee required\",\"\")))","v":""}]
[null,"(3)   Amendment results in change(s) in impact character, location, or volume of the discharge; or a time extension that results in temporal loss of resource function, according to the following criteria: \n\n     -Amendment increases the active certification's impact quantity by less than 50 percent, and \n\n-Amendment does not require a change to the mitigated aquatic resource type.",null,null,null,null,null,false,{"$f":"IF(AND(H48=TRUE,OR(H47=TRUE,H46=TRUE,H49=TRUE)),\"Check only one sub-category\",IF(H48=TRUE,\"See step 4 instructions below\",\"\"))","v":""}]
[null,"(4)   Amendment requires a supplemental CEQA analysis, or\n\n Amendment results in change(s) in impact character, location, or\n volume of the discharge, or a time extension that results in a temporal loss  of resource function, according to the following criteria: \n\n           -Amendment increases the active certification's impact quantity by more than 50 percent, or \n\n-Amendment requires a change to the mitigated aquatic resource type. ",null,null,null,null,null,false,{"$f":"IF(AND(H49=TRUE,OR(H47=TRUE,H46=TRUE,H48=TRUE)),\"Check only one sub-category\",IF(H49=TRUE,\"See step 4 instructions below\",\"\"))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,"Total Fees"]
[null,null,null,null,null,null,null,null,"Application Fee \nDue with application",null,{"$f":"IF(G9=TRUE,I13,IF(ISNUMBER(I13+I18+I25+I30+I35+I40),SUM(I13+I18+I25+I30+I35+I40),0))","v":0}]
[null,null,null,null,null,null,null,null,"Project Fee (Category A Only) \nDue prior to certification",null,{"$f":"SUM(J13)","v":0}]
[]
[null,null,null,null,null,null,null,null,"  Certification Total\nSum of Application and Project Fees",null,{"$f":"IF(ISNUMBER(K53),SUM(K54+K53),\"-\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Annual Fee\nInvoiced annually\n",{"$f":"IF(G9=TRUE,K18,SUM(K13:K42))","v":0}]
[]
[]
[]
[null,"General instructions \n\nTerms defining the measurement of a \"discharge\":\n\n     Discharge of \"dredged material\" is measured by the volume of material removed in deep water dredging activities;\n     Discharge of \"fill material\" is measured by the physical area of placement of fill material into a waterbody; \n     Discharge of \"excavation material\" is measured by the physical area within a waterbody where earth-moving activities occur. \n\nGenerally, fees are determined by the size or volume of discharge to a water body.  Fees for fill and/or excavation projects are based on discharge area in acres.  Fees for deep water dredging  are based on the volume of dredged material removed in cubic yards.  For further explanation, see (A) and (B) below.  However, your project may qualify for a flat fee category.  If so, the project fee will be based on the fee for that category instead of size or volume (see (C) through (G) below).  Amended orders may or may not be subject to fees depending on the complexity of analysis required. Follow the steps below to determine the fee associated with your project. Please contact Water Boards staff with further questions regarding how to use the calculator, click here for a link to the staff directory. "]
[]
[]
[]
[]
[]
[]
[null,"Step 1 Determine the Fee Category for your project:\n\nFee Based on Fill or Excavation Discharge Size Within the Waterbody\n\n(A) Do your project activities add fill material (soil, rocks, concrete, culverts(s), pier pilings, etc.) or excavate soil or other materials within a waterbody?\nFill refers to replacing any portion of a water with dry land, or to changing the bottom elevation or grade of any portion of a water. Fill material includes rock, sand, clay, plastics, construction debris, wood chips, overburden from mining, or other construction activities, and materials used to create any structure or infrastructure within waters (culverts, pilings, etc.). \n\nExcavation refers to removing sediment or soil in shallow waters or under no-flow conditions where impacts to beneficial uses are best described by the area of the excavation. It typically is done for purposes other than navigation. Examples include earth-moving work such as trenching for utility lines; channel reconstruction; embankment construction; removing sediment to increase channel capacity; and other flood control and drainage maintenance activities (e.g. debris removal, vegetation management and removal, detention basin maintenance and erosion control of slopes along open channels and other drainage facilities).\n\nFees Based on Discharge of Dredged Material\n\n(B) Is your project deep water dredging? (except Sand Mining - see (C) below) \nDredging generally refers to removing sediment in deeper water to increase depth and typically occur to facilitate navigation. The impacts to beneficial uses are best described by the volume of the discharge removed. For fee purposes, this category also includes aggregate extraction within stream channels where the substrate is composed of course sediment (e.g., gravel) and is replenished by normal winter flows (e.g., point bars), where natural flood disturbance precludes establishment of significant riparian vegetation, and where extraction timing, location and volume will not cause changes in channel structure (except as required by regulatory agencies for habitat improvement) or impair the ability of the channel to support beneficial uses. Dredge volumes are expressed in cubic yards.         \n                                                   \nFee Based on Flat Fee Categories\n\nDoes your project qualify for one of the following flat fee categories? To qualify for a flat fee category, the entirety of all project activities must be included within a single flat fee category, i.e., the project cannot include other components involving activities not included within the flat fee category.\n\n(C) Sand Mining Dredging Discharges\nAggregate extraction in marine waters where source material is free of pollutants and the dredging operation will not violate any basin plan provisions.\n\n(D) Ecological Restoration and Enhancement Projects\nProjects undertaken for the primary purpose of restoring or enhancing the beneficial uses of water. This schedule does not apply to projects required under a regulatory mandate or to projects that are not primarily intended for ecological restoration or enhancement (e.g., land development). This category does not include mitigation banking, or in-lieu fee programs, or projects implemented in response to an enforcement action.\n\n(E) Low Impact Discharges\nProjects may be classified as low impact discharges if they meet all of the following criteria:\n1. The discharge size is less than all of the following: (a) for fill, 0.1 acre, AND 300 linear feet, and (b) for dredging, 25 cubic yards.\n2. The discharger demonstrates that: (a) all practicable measures will be taken to avoid impacts; (b) where unavoidable temporary impacts take place, waters and vegetation will be restored to pre-project conditions as quickly as practicable; and (c) where unavoidable permanent impacts take place, there will be no net loss of wetland, riparian area, or headwater functions, including onsite habitat, habitat connectivity, floodwater retention, and pollutant removal.\n3. The discharge will not do any of the following: (a) directly or indirectly destabilize a bed of a receiving water; (b) contribute to significant cumulative effects; (c) cause pollution, contamination, or nuisance; (d) adversely affect candidate, threatened, or endangered species; (e) degrade water quality or beneficial uses; (f) be toxic; or (g) include “hazardous” or “designated” material.\n\n(G) Emergency Projects Authorized by a Water Board General Order\nRGP 8 Corps' Sacramento District\nRGP 5 Corps' San Francisco District\nRGP 63 Corps' Los Angeles District\n\nAmended Orders (go to Step 4)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 2 \n\nIf you have determined that your project qualifies for a flat fee category (C through G) check the applicable box to calculate fees."]
[]
[]
[]
[null,"Step 3\n\nA. Is your project a fill/excavation project? \n\nIf your project is a fill/excavation project, calculate your fee based on the size of the discharge area in acres. For projects with multiple impact sites, sum the individual discharge quantities and enter the total in the calculator. For projects impacting multiple water features sum discharge quantities for all features.  In addition, fees are based on the sum of both permanent and temporary impacts.  The size of the discharge area shall be rounded to two decimal places (0.01 acre = 436 square feet). Category A discharges are subject to the sum of the Application fee and Project fee; the Application fee is due at the time of application and the project fee is due prior to issuance of the certification; additional annual fees are assessed from the date of certification until project completion. \n\nB. Is your project a dredging project?  Your dredging fee will be based on the actual amount of material dredged from the waterbody.  Therefore, annual active discharge invoices are sent for the previous fiscal year's dredging amount. Invoice amounts will be based on the fee schedule current for that fiscal year. Please submit your application fee amount as shown in the calculator above.  You may estimate your upcoming annual active discharge fee using the current fee calculator.  However, this will only be an estimate because fees are subject to change annually as approved by the State Water Board.\n\nCombination fill/excavation and dredging Projects (A and B)\nDoes your dredging project also include a discharge of fill material? These projects typically include dredging material from one part of a waterbody and depositing the dredged material into a different location in the waterbody. These projects are subject to both Category A and Category B fees.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4\n\nAre you requesting an amendment to a previously issued water quality certification or WDR? Fees for amended orders are based on the increased quantity of discharge and the level of technical analysis required evaluate project changes, therefore Water Board staff will determine which category your amendment is subject. Water Board staff will determine the fee for amendments based on the fee schedule and will request the applicant to submit the appropriate fee.\n\nFees based on amendments are categorized as follows:\n\n(1) All Category (D) Ecological and Restoration and Enhancement Projects, regardless of amendment type. No fee required\n\n(2) Administrative amendments including, but not limited to, ownership changes, typographic edits, or time extensions that do not result in a temporal loss of resource function.  Amendments in this category require no technical analysis or additional compensatory mitigation. No fee required\n\n(3)   Amendment results in change(s) in impact character, location, or volume of the discharge; or a time extension that results in temporal loss of resource function, according to the following criteria: \n\n-Amendment increases the active certification's impact quantity by less than 50 percent, and \n-Amendment does not require a change to the mitigated aquatic resource type.\n\nAdditional standard fee assessed per increased amount of discharge(s). The minimum fee is $1,638. For category A or B projects, enter discharge quantities for increased impacts quantities. For flat fee categories, select the appropriate category.\n\n(4)   Amendment requires a supplemental CEQA analysis, or Amendment results in change(s) in impact character, location, or volume of the discharge, or a time extension that results in a temporal loss  of resource function, according to the following criteria: \n\n-Amendment increases the active certification's impact quantity by more than 50 percent, or \n-Amendment requires a change to the mitigated aquatic resource type. \n\nAdditional standard fee assessed per increased amount of discharge(s). The minimum fee is $1,638. For category A or B projects, enter discharge quantities for all project impacts, including quantities previously certified. For flat fee categories, select the appropriate category.\n\nDischargers that have met the project fee cap will be assessed the minimum fee for each amendment of previously-issued WDR or water quality certification.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 5\n\nSee Total Fees for a breakdown of fees owed.\n\n\n\n"]
[]
[null,"Step 6 \n\nFee Types & Due Dates\n\nProjects are subject to fees at three separate times throughout the life of a project:\n\n1) Application Fee: Amount due with the initial application.\n\n2) Project Fee: Amount due prior to certification (applies to Category A only). \n\n3) The Annual Fee amount is invoiced annually: All projects are subject to an Annual Fee each fiscal year or portion of a fiscal year that the certification is active (from the effective date of the order until the regional board or state board issues a Notice of Project Complete Letter to the discharger). The Water Boards fiscal year begins on July 1 and ends on June 30. Dischargers will be invoiced their first Annual Fee beginning in November/December of the year following the Effective Date of certification. Dischargers will be invoiced for an Annual Fee each year until the project is completed. The annual fee for category (B) dredging discharges will be invoiced after the annual dredge volume has been determined. \n\n"]

{"sheet":"Variables","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["_Example",false]
["_Shading",false]
["_Series","OfficeReady 3.0"]
["_Look",1]