{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover Sheet","Application_Checklist","WB Review Checklist","Acronyms","Data Checklist","Microsoft Project Dates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":22,"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":"Cover Sheet","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[[3,0,3,1],[0,0,0,5]]}
["UIC Application & Checklist "]
[]
[]
["Project  Category:",null,{"$f":"IF(ISTEXT(Application_Checklist!G13),Application_Checklist!G13,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,"Project Type:",{"$f":"IF(ISTEXT(Application_Checklist!G14),Application_Checklist!G14,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E15","v":"Number of Wells:"},{"$f":"IF(ISTEXT(Application_Checklist!G15),Application_Checklist!G15,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E16","v":"Operator: "},{"$f":"IF(ISTEXT(Application_Checklist!G16),Application_Checklist!G16,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E17","v":"Project No.: "},{"$f":"IF(ISTEXT(Application_Checklist!G17),Application_Checklist!G17,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E18","v":"Field Name: "},{"$f":"IF(ISTEXT(Application_Checklist!G18),Application_Checklist!G18,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISTEXT(Application_Checklist!#REF!),Application_Checklist!#REF!,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E21","v":"DOGGR Reviewing Engineer:"},{"$f":"IF(ISTEXT(Application_Checklist!G21),Application_Checklist!G21,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[null,{"$f":"Application_Checklist!E22","v":"Date Project Submitted:"},{"$f":"IF(ISTEXT(Application_Checklist!G22),Application_Checklist!G22,\"Application Checklist not yet filled out\")","v":"Application Checklist not yet filled out"}]
[]
[null,"Date PDF generated:",{"$f":"TODAY()","v":"2022-02-03"}]

{"sheet":"Application_Checklist","index":1,"n_rows":61,"n_cols":9,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"UNDERGROUND INJECTION CONTROL (UIC)"]
[null,null,null,"GEOLOGIC ENERGY MANAGEMENT DIVISION"]
[null,null,null,"PROJECT INFORMATION CHECKLIST"]
[null,null,null,"The purpose of this document is to streamline CalGEM and Water Boards review"]
[null,null,null," (APRIL 8, 2020 VERSION)"]
["The tables below summarize in checklist form the shared understanding of the Division and the Water Boards regarding the anticipated typical content and format of the project information to be "]
["forwarded from the Division to the Water Boards in connection with review of underground injection projects, as described in the Section IV.B. of the Revised Memorandum of Agreement, signed July 2018. "]
[]
["Note that this checklist does not necessarily identify all information an operator must provide to the Division in connection with an approval and ongoing operation of an underground injection project.\n"]
["The requirements for approval and operation of underground injection projects are governed by applicable statutes and regulations. This checklist is not a substitute for those requirements."]
[]
[null,null,null,null,"Project Category (Project by Project,  Periodic Review, New Project, Expansion, Modified Project): "]
[null,null,null,null,"Project Type (Water Disposal, Gas Disposal, Water Flood, Cyclic Steam, Steam Flood):"]
[null,null,null,null,"Number of Wells:"]
[null,null,null,null,"Operator: "]
[null,null,null,null,"Project No.: "]
[null,null,null,null,"Field Name: "]
[null,null,null,null,"Direct Injection Zone(s):"]
[null,null,null,null,"Indirect Migration Injection Zone(s):"]
[null,null,null,null,"DOGGR Reviewing Engineer:"]
[null,null,null,null,"Date Project Submitted:"]
[]
[]
[]
["Unless otherwise indicated, all authority references in the tables below are to sections within California Code of Regulations, title 14. "]
[]
[null,null,null,"Reference\n Authority","Complete","Location in the Data Package","Operator Notes Supporting / Clarifying Data Presented","Reviewed","CalGEM Notes"]
[]
[" Data Format","DF(1)","All data supporting the underground injection project are in a digital format.   \n\nThe Division and the Water Boards recognize that converting the Division's existing project files to a digital format is an ongoing process. The Division will work with the Water Boards to determine the most appropriate format for the data on a case-by-case basis.","1724.7(c) ",false,null,null,false,"\n\n\n\n\n\n\n\n\n\n\n\n"]
[null,"DF(2)","All maps, diagrams, and exhibits are clearly and appropriately labeled, such as to title, scale, and purpose, and clearly identify wells, boundaries, zones, contacts, and other relevant data. ","1724.7(c) ",false,null,null,false]
[]
["Cover Page","CP(1)","A cover page including a statement that appropriate licensed professionals, whose signatures and stamps appear at the bottom of the page, are responsible for all data, interpretations, and calculations, if any, subject to the requirements of Business and Professions Code sections 6735, 7835, and 7835.1.  If the operator determines that the submission does not include data, interpretations, or calculations subject to the requirements of Business and Professions Code sections 6735, 7835, and 7835.1, the cover page must so indicate, and must provide the name(s) and signature(s) of the individual(s) responsible for preparing the submission.","1724.7(d)",false,null,null,false]
[]
[null,"ES(1)","A description of how the area of review was determined, including calculations, variables, citations, and assumptions. \n\nThe Division and Water Boards agree the AOR determination should include injection and production impacts of offset projects that could potentially interact with the proposed project, with due consideration for the geology, engineering aspects, and the nature of injected fluids.\n\nThe Division may use the rates, pressures, and volumes included in the calculations as conditions of the Project Approval Letter.  For water disposal projects, a determination of the current injectate front and pressure front also may be an important part of the area of review determination. ","1724.7(a)(1)(A) ",false,null,null,false]
["Engineering Study","ES(2)","A map of the area of review showing the location of the following: \n   (1) All wells within and adjacent to the boundary of the area of review; \n   (2) All water supply wells that are within the area of review and identified in public records or otherwise known to the operator;\n   (3) Any underground disposal horizons, mining, and other subsurface industrial activities not associated with oil and gas production within the area of review, to the extent such information is publicly available or otherwise known to the operator; and \n   (4) Traces of the geologic cross sections provided as part of the Geologic Study.\n\nThe historical term 'project area' may be shown as the map view projection of the injection zone defined in 1720.1(g). The 'project area' can include a single area of review (AOR), multiple AORs, or any overlapping cumulative effects of the AORs.\n\n","1724.7(a)(1)(B)\n1724.8",false,null,null,false]
[null,"ES(3)","A compendium of the following information:\n   (1) For all wells depicted in the map of the area of review (including water supply wells to the extent information is known or publicly available), the API numbers, or other identifying information for wells that do not have API numbers, and the wellbore paths, total depths, and depths of completion interval(s) of the wells;\n   (2) The type and status of water supply wells depicted in the map of the area of review; and\n   (3) All the casing diagram data specified in Section 1724.7.1, provided in the form of graphical casing diagrams or flat-file data sets, for all wells that are within the area of review and that are completed in or penetrating the injection zone for the underground injection project or a deeper zone, including directionally drilled wells that intersect the area of review in the injection zone or a deeper zone.\n","1724.7(a)(1)(C) \n1724.7.1\n1724.8",false,null,null,false]
[null,"ES(4)","The planned well-drilling and plugging-and-abandonment program to complete the project, including a flood-pattern map, if applicable, showing all injection, production, and plugged and abandoned wells, and unit boundaries.\n\nThe Division recognizes plans are subject to change during the course of a project review.  It is the operator's responsibility to update project data accordingly prior to approval.\n","1724.7(a)(1)(D)\n1724.8",false,null,null,false]
[]
[null,"GS(1)","Geologic information describing the reservoir characteristics of the injection zone, such as porosity, permeability, average thickness, areal extent, fracture gradient, original and present temperature and pressure, and original and residual oil, gas, and water saturations. The scope of the geologic characterization shall encompass the caprock and sealing mechanisms, the injection zone including the vertical interval above and below the approved injection zone, and the areas where potential migration of fluid or entrapment of migrated fluid could occur. \n\nThe Division and Water Boards agree all supporting data shall be the most current, accurate and relevant.  All data sources shall be cited.  ","1724.7(a)(2)(A)",false,null,null,false]
[null,"GS(2)","Reservoir fluid data for the injection zone, such as oil gravity and viscosity, water quality, presence and concentration of non-hydrocarbon components in the associated gas (such as hydrogen sulfide) and specific gravity of gas. Liquid analysis of the reservoir fluid shall be performed in accordance with Section 1724.7.2. \n\nThe Division and Water Boards agree supporting documentation for formation fluid TDS determination should be included and from actual samples when available. Supporting documents may include, but are not limited to, historic data, properly documented log derivations, and when available, submission of LAS logs and all constants used for verification.","1724.7(a)(2)(B)\n1724.7.2\n",false,null,null,false]
["Geologic Study","GS(3)","Structural contour map drawn on a geologic marker at or near the top and base of each injection zone in area of review, indicating faults and any lateral containment features. If faults are identified, there must also be analysis addressing whether or not the faults are capable of confining fluid to the approved injection zone and any geologic features that could result in the migration of fluid out of the approved injection zone. \n\nIf a GIS shapefile is submitted, layers with labeled wellbore paths of all existing and proposed wells in the map area would lead to a more comprehensive understanding of the system.","1724.7(a)(2)(C)",false,null,null,false]
[null,"GS(4)","Isopach map of each injection zone or subzone in the area of review.","1724.7(a)(2)(D)",false,null,null,false]
[null,"GS(5)","At least two geologic cross sections in the area of review through at least three wells, including one injection well.  As near as possible, one of the geologic cross sections shall be along strike and the other shall be perpendicular to strike. The cross section shall extend from the base of the deepest production or injection zone to surface and indicate the location of the approved injection zone, the base of freshwater, and the base of the USDW.","1724.7(a)(2)(E) ",false,null,null,false]
[null,"GS(6)","Representative electric log to a depth below the deepest producing or injection zone, whichever is deeper, identifying all geologic units, formations, USDWs, freshwater aquifers, and oil or gas zones. The electric log shall identify the API number of the well that was logged.","1724.7(a)(2)(F)",false,null,null,false]
[]
[null,"IP(1)","A statement of primary purpose of the project.","1724.7(a)(3)(A)",false,null,null,false]
[null,"IP(2)","A map showing injection facilities related to the project, and piping and instrumentation diagram(s) for the injection facilities.\n\n","1724.7(a)(3)(B)",false,null,null,false]
[null,"IP(3)","A statement of the anticipated project duration, anticipated daily rate of injection (by well), and anticipated cumulative net volume of fluid to be injected.\n\nThe Division and Water Boards anticipate this data to be based on maximum values.","1724.7(a)(3)(C) ",false,null,null,false]
[null,"IP(4)","Identification of all wells that are part of the project, including injection wells, affected production wells, water source wells, observation or other wells and any planned wells to the extent known. The depths of water source wells shall also be provided.","1724.7(a)(3)(D)",false,null,null,false]
["Injection Plan","IP(5)","Monitoring system, including methods or standard operating procedures to be utilized by the operator to ensure that no damage is occurring and that the injection fluid is confined to the approved injection zone. In the event the Division or the Water Boards require groundwater monitoring in relation to the underground injection project, or as a condition of project approval,  the operator shall consult with the State Water Resources Control Board or the Regional Water Quality Control Board and provide the Division with documentation and the results of such consultation.","1724.7(a)(3)(E) ",false,null,null,false]
[null,"IP(6)","A description of the method of injection, including such information as injection string configuration and bottom-hole assembly.","1724.7(a)(3)(F)",false,null,null,false]
[null,"IP(7)","A list of the cathodic protection or other corrosion prevention measures employed for plant, lines, and wells, if such measures are warranted.","1724.7(a)(3)(G)",false,null,null,false]
[null,"IP(8)","Identification of the source(s) of the injection fluid and analyses of the injection fluid in accordance with Section 1724.7.2.\n\n","1724.7(a)(3)(H)\n1724.7.2\nNTO- Guidelines for Collection of Oilfield Water Quality Data",false,null,null,false]
[]
["Other Standard  Information","OI(1)","All data supporting the determination of the maximum allowable surface injection pressure for each injection well in the underground injection project, as described in Section 1724.10.3, including all calculations, variables, citations and assumptions.","1724.7.(a)(4)\n1724.10.3",false,null,null,false]
[null,"OI(2)","Copies of letters of notification sent to offset operators by the operator of the underground injection project.","1724.7(a)(5)",false,null,null,false]
[]
[null,"SI(1)","Any other data that, in the judgement of the Division, are pertinent and necessary for the proper evaluation of the underground injection project. Examples of such data are: isochore maps, isogor maps, water-oil ratio maps, isobar maps, three-dimensional geologic models, reservoir simulation results, isopach maps of the confining layers, equipment diagrams, and safety programs.","1724.7(a)(6)",false,null,null,false]
[null,"SI(2)","Any alternative data accepted by Division in lieu of the default regulatory requirements for project data, as described in Section 1724.7(e).","1724.7(e)",false,null,null,false]
["Situational  Information","SI(3)","For an underground injection project that includes an injection well with open perforations located within 500 linear feet of the screen or perforations of a water supply well (or a project otherwise required to provide this information as determined by the Division), all of the following information, updated yearly:\n   (1) A water treatment process flow diagram depicting all physical and chemical treatment processes applied to the injection fluid, from its source to the injection well;    \n   (2) The safety data sheet for each chemical additive emplaced in injection wells within the underground injection project, and for each chemical added to the fluid to be injected from the time the fluid is first obtained to the time it is injected;    \n   (3) The project-aggregate volume or weight of each additive reported; and    \n   (4) A brief description of the intended purpose of each additive reported.","1724.10(e) ",false,null,null,false]

{"sheet":"WB Review Checklist","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"UNDERGROUND INJECTION CONTROL (UIC)"]
[null,null,null,"WATER BOARDS PROJECT INFORMATION CHECKLIST"]
[null,null,null,"The purpose of this document is to streamline CalGEM and Water Boards review"]
[null,null,null," (APRIL 8, 2020 VERSION)"]
["The table below summarizes in checklist form the supplemental information required in addition to that listed in the Application checklist that the Water Boards need for review of underground injection projects. "]
[]
["The information requested below is made in lieu of requiring operators to file a report of discharge under California Water Code section 13260 and is consistent with authority provided in"]
[" Water Code sections 13260, 13267, and 13267.5."]
[]
[null,null,"To help expedite the Water Board's review, please identify the exact WellStar location of the data indicated below.","Complete","Location in the Data Package","Operator Notes Supporting / Clarifying Data Presented","Reviewed","Water Board Notes"]
[null,"W-CP","For ALL project reviews, the application must include a statement and supporting rationale demonstrating that injected Class II fluids have not (for ongoing projects) and will not (for any project) migrate beyond the boundaries of the exempt aquifer or into a underground source of drinking water (USDW). Any evaluation of past, or anticipated future, migration of injected fluids involving geologic or engineering interpretation must be conducted by, or under the direct supervision of, a state-registered professional geologist or professional engineer and signed and stamped by a registered professional to the extent required by California Business and Professions Code sections 6735, 7835, and 7835.1. ",false,null,null,false]
[null,"W-ES(1)","Provide the rationale for determining the area of review (AOR) with supporting calculations; including the assumptions associated with the calculations. A range of values used to determine average porosity, permeability, and thickness (net and gross) will be provided with the supporting data. The anticipated project duration, anticipated daily rate of injection (by well), and anticipated cumulative net volume of fluid to be injected will be provided.",false,null,null,false]
[null,"W-ES(2)","For all projects, AOR calculations must use an accurate representation of all the relevant parameters from within the project area, including the static pressures or current temperatures of the injection zone(s) and USDW(s) within the AOR. If a range of values for the input parameters is provided, then multiple AORs need to be calculated to provide the most conservative estimate of the distance injected fluids may migrate. This procedure will provide assurance that, if proposed, an AOR of one quarter-mile fixed radius is adequate. The analysis shall consider the heterogeneity of the reservoir.  Operator must declare if the formations are homogeneous or heterogeneous.\n\nA ZEI calculation may meet the regulatory requirements of AOR calculation. ",false,null,null,false]
[null,"W-ES(3)","Provide an evaluation of any potential increase in reservoir pressure and fluid migration due to either overlapping ZEIs, neighboring injection projects, or other relevant inputs into the system (i.e. faults, facies changes and stratigraphic pinchouts that may act as flow barriers). \n\nIf the change in reservoir pressure due to injections will be reduced by production wells, the Operator will submit calculations that show how the change in reservoir pressure will be offset by the production wells. Injection and production wells used in this evaluation should be identified on the application maps/figures.",false,null,null,false]
[null,"W-ES(4)","The map of the AOR provided to will also include the following: (1) for all wells; include surface and bottom hole locations and labels that display their well type and status (e.g. active steamflood injector);  (2) all faults within the Project Area, and (3) all wells that have been identified as potential conduits to a USDW.  ",false,null,null,false]
[null,"W-ES(5)","Well construction diagrams for all wells and boreholes within the AOR need to be provided. Each diagram will identify the depth and perforated interval of the well and borehole, cement plugs, casing damage, key geologic markers (e.g. injection zone), BFW, and USDW. Each well and borehole diagram should depict the entire history (e.g. sidetracks, redrills, and other mechanical changes).",false,null,null,false]
[null,"W-ES(6)","Provide a water well survey. Water well locations within one mile of the project area shall be presented on a map and listed in an accompanying table.  The water well survey should utilize the following data sources (at a minimum): Department of Water Resources (DWR) well completion reports and GeoTracker Groundwater Ambient Monitoring and Assessment (GAMA) information system. The following information will be included in the table: location information, type (municipal, domestic, irrigation, industrial, stock), status (active, idle, abandoned, destroyed), owner, well completion depth and zone name, and depths for all screened intervals. On a case-by-case basis, an expanded water well survey may be necessary based upon potential risk to beneficial use water outside the limits of the AOR. For those well completion reports that do not provide the latitude and longitude coordinates, the Operator should attempt to determine its location by a field survey. ",false,null,null,false]
["Water Boards ","W-GS(1)","All supporting maps (e.g. structural contour map) need to include the AOR and Project Area, existing exemption boundaries, faults (with displacement information), lines of cross-section, a scale, an explanation describing what the symbols and colors used represent, north arrow, and identify the name of formation or unit mapped. Also, structural contour and isopach maps of the upper and lower \"confining\" units need to be provided. Representative permeability and porosity values, if available, of the \"confining\" units should be labeled on these maps. The cross sections need to include the AOR(s), the proposed injection zone, confining units, the formation or units penetrated by injection wells with associated API numbers, water supply wells, locations of the base of fresh water (BFW) and USDW, deviated wells within the line of section (i.e. wells near the cross-section trace), and an explanation describing what colors and symbols mean. ",false,null,null,false]
[null,"W-GS(2)","The type log provided will include labeled geophysical curves and a vertical scale. The method and data used to determine the base of USDW should be included in the application.",false,null,null,false]
[null,"W-GS(3)","Provide representative water quality data (collected within the past 5 years) of the injection zone from well(s) located within the AOR. The injection zone groundwater analysis should be representative of the reservoir groundwater in its native condition. The groundwater analyzed shall be either sampled from the injection zone itself prior to commencement of any injection into the reservoir or sampled from an analogous reservoir that has not already received injection fluid. The representative sample shall be recovered after all completion and drilling fluid has been circulated from the wellbore. Any proposed groundwater sampling and analysis proposed for new or modified projects must follow the most recent version of the Notice to Operators – Guidelines for Collection of Oilfield Water Quality Data.",false,null,null,false]
[null,"W-GS(4)","If the injection zone is not an exempted aquifer, then a non-USDW determination shall be made using recent (collected within the past 5 years) water quality samples of the injection zone groundwater within the Project Area. If no wells exist within the Project Area, then total dissolved solids (TDS) well log calculations can be used provided that: 1) The accuracy (i.e. percent error) of the computed result is validated with a water quality sample of the same injection zone groundwater within 1 mile of the project area; and 2) The method, calculations, and assumptions used in the TDS analysis are provided.   \n\nIf the Operator determines through water quality sampling or TDS calculations that the injection zone and/or overlying formations are non-USDWs, the lateral and vertical extent of this determination shall be defined on the application maps and cross sections.",false,null,null,false]
[null,"W-GS(5)","Any groundwater quality data or well log analysis that will be used to justify the injection of fluids (e.g., showing that TDS concentrations within the proposed injection zone are greater than 10,000 milligrams per liter) must be accompanied by a written statement or report, prepared by a state-registered professional geologist or professional engineer, indicating the degree to which the water quality data is representative of the injectate fluid or native formation groundwater and provide justification for that conclusion.  ",false,null,null,false]
[null,"W-IP(1)","Provide a map that shows the location of any pretreatment facilities, location of proposed injection wells and any other injection wells plumbed to the facility.  ",false,null,null,false]
[null,"W-IP(2)","Provide information including the type of treatment and plan for the disposal of reject water.",false,null,null,false]
[null,"W-IP(3)","Provide representative water quality data of the injectate; collected within the past year. The source of the injectate fluids should be identified including zone/formation and approximate volume percentages. The injection liquid to be analyzed shall be sampled after all additives (if any) are added to the liquid and after all treatment or separation processes (if any), to ensure that it is representative of the liquid actually injected. Sampling protocol for existing projects (project by project) should be provided. Any proposed water sampling and analysis proposed for new or modified projects should follow the most recent Notice to Operators regarding Guidelines for Collection of Oilfield Water Quality Data.",false,null,null,false]
[null,"W-IP(4)","The Aquifer Exemption (AE) conditions as outlined in State Water Board’s final concurrence letters need to be addressed in the Operator's application and incorporated into the Project Approval Letters, if appropriate. Such AE conditions may include monitoring that is different than the monitoring requested at the UIC project level. Requested “groundwater monitoring” includes but is not limited to the following: water quality monitoring (e.g. of the injectate and/or groundwater within the newly exempted zone/area), temperature monitoring, and/or pressure monitoring.\n\nFor those projects with potential conduits into a USDW, a proposed monitoring plan to confirm the pressure front calculations used in determining the change in pressure near problem wells or faults shall be provided.  ",false,null,null,false]
[null,"W-SI","Using recent (measured within the past 2 years) idle well fluid level data for all idle wells within the AOR,  provide a map showing the apparent groundwater flow direction(s) within the injection zone. The supporting data (e.g. acoustic water level surveys) used to create the maps shall be provided.",false,null,null,false]

{"sheet":"Acronyms","index":3,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Acronyms"]
[]
["AE","Aquifer Exemption"]
["AOR","Area of review"]
["BFW","Base of fresh water"]
["CCR","California Code of Regulations"]
["CP","Cover Page"]
["DF","Data Format"]
["DWR","Department of Water Resources"]
["ES","Engineering Study"]
["GAMA","Groundwater Ambient Monitoring and Assessment Program"]
["GIS","Geographic Information System"]
["GS","Geological Study"]
["IP","Injection Plan"]
["LAS","Log ASCII Standard"]
["OI","Other Standard Information"]
["SI","Situational Information"]
["TDS","Total Dissolved Solids"]
["UIC","Underground Injection Control"]
["USDW","Underground Source of Drinking Water"]
["WellSTAR","Well State Tracking and Reporting"]
["ZEI","Zone of Endangering Influence"]

{"sheet":"Data Checklist","index":4,"n_rows":190,"n_cols":14,"rows_kept":190,"cut":false,"hidden":true,"merged":[[184,1,188,12],[189,1,189,12],[50,1,51,12],[99,1,100,12],[72,6,73,6],[71,13,73,13],[73,7,73,12],[170,1,171,12],[143,0,144,12],[168,1,169,12],[146,1,148,12],[149,1,151,12],[152,1,154,12],[155,1,157,12],[158,1,160,12],[161,1,166,12],[173,1,173,12],[175,1,175,12],[177,1,183,12],[132,13,133,13],[132,6,133,6],[132,1,133,5],[122,0,141,0],[78,7,82,12],[111,13,113,13],[114,13,115,13],[83,1,90,5],[83,7,90,12],[74,0,97,0],[118,1,120,5],[116,1,117,5],[116,7,117,12],[116,13,117,13],[116,6,117,6],[118,6,120,6],[118,13,120,13],[101,1,102,5],[101,6,102,6],[101,7,102,12],[101,13,102,13],[118,7,120,12],[78,13,82,13],[132,7,133,12],[91,6,93,6],[74,7,77,12],[124,1,127,5],[124,6,127,6],[124,7,127,12],[122,7,123,12],[122,6,123,6],[122,1,123,5],[78,6,82,6],[134,7,141,12],[142,7,142,12],[103,6,105,6],[103,7,105,12],[134,6,141,6],[134,1,141,5],[98,7,98,12],[121,7,121,12],[63,6,65,6],[63,1,65,5],[63,7,65,12],[106,1,108,5],[106,6,108,6],[106,7,108,12],[128,1,131,5],[128,7,131,12],[128,6,131,6],[111,1,113,5],[111,6,113,6],[111,7,113,12],[103,1,105,5],[109,1,110,5],[114,6,115,6],[91,1,93,5],[66,7,69,12],[24,0,24,5],[20,0,22,12],[25,0,26,12],[50,0,69,0],[33,1,35,5],[55,7,58,12],[44,7,46,12],[44,6,46,6],[47,1,48,5],[28,6,29,6],[52,1,54,5],[33,6,35,6],[33,7,35,12],[36,7,39,12],[59,1,62,5],[55,6,58,6],[55,1,58,5],[59,7,62,12],[59,6,62,6],[66,6,69,6],[66,1,69,5],[30,0,31,5],[47,7,48,12],[18,0,18,12],[14,0,14,1],[8,0,8,1],[9,0,9,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[2,0,4,12],[52,7,54,12],[52,6,54,6],[40,1,43,5],[40,6,43,6],[36,6,39,6],[36,1,39,5],[40,7,43,12],[44,1,46,5],[29,7,29,12],[33,0,48,0],[47,6,48,6],[30,6,31,6],[30,7,31,12],[14,2,14,3],[134,13,141,13],[114,7,115,12],[114,1,115,5],[99,0,120,0],[74,1,77,5],[74,6,77,6],[94,1,97,5],[94,6,97,6],[109,7,110,12],[91,7,93,12],[94,7,97,12],[109,6,110,6],[78,1,82,5],[122,13,123,13],[124,13,127,13],[128,13,131,13],[91,13,93,13],[94,13,97,13],[103,13,105,13],[106,13,108,13],[109,13,110,13],[74,13,77,13],[83,6,90,6],[83,13,90,13],[27,13,29,13],[33,13,35,13],[36,13,39,13],[40,13,43,13],[44,13,46,13],[55,13,58,13],[59,13,62,13],[63,13,65,13],[66,13,69,13],[52,13,54,13],[47,13,48,13],[30,13,31,13]]}
[]
[]
["UNDERGROUND INJECTION CONTROL (UIC) \nPROJECT DATA REQUIREMENTS CHECKLIST"]
[]
[]
[]
[]
[]
["Project Type:",null,{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
["Operator:",null,{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Project Name:",{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
["Project No.:",null,{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
["Field Name:",null,{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
["Zone:",null,{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
["Reviewing Engineer:"]
[null,"Date:",{"$f":"IF(#REF!=\"\",\"Summary tab not yet populated\",#REF!)","v":{"$error":"#REF!"}}]
[]
[]
["All data shall be submitted in a Division approved electronic format."]
[]
["Electronic submission of all subsurface mappable data (structure, isopachous, and AOR) shall be submitted as a PDF and/or the corresponding geospatial shapefile(s) and grids that can be plotted using GIS, to show the Area of Review (AOR) or Project Area determined. The polygons should clearly show the expected path of injectate, for life of the project."]
[]
[]
[]
["Project Data Requirements "]
["The Safe Drinking Water Act (SDWA), California Code of Regulations (CCR) Section 1724.7, and Public Resources Code (PRC) 3131 require that the following data be filed with the district deputy, where applicable:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"District \nReviewed"]
[null,null,null,null,null,null,"\nComplete"]
[null,null,null,null,null,null,null,"Description of Location in the Data Package"]
["PS(1) Statement of primary purpose of the project.",null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[" Formation fluid quality determination & \nArea of Review (AOR). ","FA(1) For ACTIVE water disposal projects, determine current injectate front and pressure front to verify the AOR.1a",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"FA(2) For compliance with SDWA, if injection zone is less than 10,000 TDS (USDW) and project area is within an exempt aquifer then, determine the Area of Review (AOR) for predicted project life.1a ",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"FA(3) For compliance with SDWA, if injection zone is less than 10,000 TDS (USDW) and project area is NOT entirely within an exempt aquifer then, submit a shut-in plan for wells outside exempt aquifer and/or submit an aquifer exemption expansion application. 1b",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"FA(4) If injection zone is greater than 10,000 TDS (non-USDW) then, determine AOR for predicted project life.1a",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"FA(5) Submit calculation method with constants used for determining AOR. 1,1a",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
["Geologic Study and Zonal Confinement","All maps, diagrams and exhibits required should be clearly labeled as to scale and purpose and shall clearly identify wells, boundaries, zones, contacts, and other relevant data that extend beyond the project area to ensure adequate review of the AOR."]
[]
[null,"GC(1) Geologic overview of the formation including discussion on vertical (top & bottom seals) and lateral confinement.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"GC(2) Structural contour map drawn on a geologic marker at or near the top of each injection zone in the project area as defined by the AOR. The map should show the wellbore paths of all existing and proposed wells in the map area with legible labels. 2",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"GC(3) Isopach map of each injection zone or subzone in the project area as defined by the AOR. The map should show the wellbore paths of all existing and proposed wells in the map area with legible labels.2",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"GC(4) At least two geologic cross sections, as appropriate, through at least one injection well in the project area as defined by the AOR. 2",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"GC(5) Representative electric log (type log) to a depth below the deepest producing zone identifying all geologic units, formations, freshwater aquifers, USDW(s), and oil and gas zones submitted as a PDF.2,3",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"District \nReviewed"]
[null,null,null,null,null,null,"\nComplete"]
[null,null,null,null,null,null,null,"Description of Location in the Data Package"]
["Engineering Study","ES(1) Reservoir characteristics of each injection zone, such as porosity, permeability, average thickness, areal extent, fracture gradient, original and present temperature and pressure, and original and residual oil, gas, and water saturations.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"ES(2) Reservoir fluid data for each injection zone, such as oil gravity and viscosity, liquid quality, and specific gravity of gas. Formation fluid TDS determination should be from actual samples when available or log derivations may be accepted with submission of LAS logs and all constants used for verification.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[]
[null,"ES(3) Wellbore construction data for all wells that penetrate the injection zone and Division permitted water-source wells (that will be used in conjunction with the project) within the project area as defined by the AOR. Include all casing strings/liners with perforated intervals, cement plugs, actual or calculated cement fill behind casing, casing damage/holes (squeezed & unsqueezed), and geologic markers including, but not limited to: injection zone depth(s) freshwater depth(s), and USDW(s). Wellbore construction data shall be submitted in a digital format as designated by the State Oil & Gas Supervisor. 4",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[null,"ES(4) Plugging and/or abandonment program to remediate problem wells that penetrate the injection zone.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"ES(5) A planned well-drilling program including a flood-pattern map showing all injection, production, plugged and abandoned wells, unit boundaries, and Division permitted water-source wells that will be used in conjunction with the project.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[]
["Injection Plan","Electronic submission of the injection plan shall be submitted as a PDF and/or the corresponding geospatial shapefile(s) and grids that can be plotted using GIS, to show the Area of Review (AOR) determined."]
[]
[null,"IP(1) A map showing injection facilities. 5",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"IP(2) Maximum anticipated surface injection pressure (pump pressure) and daily rate of injection, by well.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"IP(3) Monitoring system or method to be utilized to ensure that no damage is occurring and that the injection fluid is confined to the intended zone or zones of injection.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"IP(4) Method of injection.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"IP(5) List of proposed cathodic protection measures for plant, lines, and wells, if such measures are warranted.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,"IP(6) Treatment of fluid injected. 6",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"IP(7) Project Duration",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"IP(8) Source and analysis of the injection fluid to ensure injectate will not affect the quality of water that is, or may reasonably be, used for any beneficial use. 7",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
["Miscellaneous\nRequirements","MR(1) Copies of letters of notification sent to offset operators.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"MR(2) Survey of all water wells within 1 mile of the project area as defined by the AOR with construction details to ensure the injection zone is not being used for beneficial use submitted as a PDF and spreadsheet.8",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"MR(3) Other data as required for large, unusual, or hazardous projects, for unusual or complex structures, or for critical wells. (Examples of such data are: isochore maps, water-oil ratio maps, isobar maps, equipment diagrams, and safety programs.)",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[null,"MR(4) All recent fluid levels from idle wells located within the AOR. 9\n",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,"MR(5) A cover page including a statement that a licensed professional, whose signature and stamp appears at the bottom of the page, is responsible for all data, interpretations, and calculations, if any, subject to the requirements of Business and Professions Code sections 6735, 7835, and 7835.1. If the operator determines that the submission does not include data, interpretations, or calculations subject to the requirements of Business and Professions Code sections 6735, 7835, and 7835.1, the cover page must so indicate, and must provide the name(s) and signature(s) of the individual(s) responsible for preparing the submission.",null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
["To help expedite the Water Board's review and to memorialize DOGGR’s analysis in a reference document, please identify the location of the data identified below."]
[]
[]
["1.","Evaluation of the area of review (AOR), Project Area, and supporting calculations and assumptions and cumulative injection volumes for all water disposal wells that have historically injected into the injection zone within the AOR."]
[]
[]
["1a.","For ALL project review (i.e., including ongoing projects, new projects, and expansions of existing project) provide an estimate regarding the anticipated distance and direction of migration of any Class II fluids to be injected during the remaining life of the project."]
[]
[]
[null,"The application must include a statement and supporting rationale demonstrating that injected Class II fluids have not (for ongoing projects) and will not (for any project) migrate beyond the boundaries of the exempt aquifer or into a non-USDW."]
[]
[]
[null,"Any evaluation of past, or anticipated future, migration of injectate fluids involving interpretation of geologic or engineering information must be conducted by, or under the direct supervision of, a state-registered professional geologist or professional engineer."]
[]
[]
["1b.","Immediately notify the operator of any changes to the existing project status or new project/project expansion review schedule resulting from these findings (potentially including termination of existing project, temporary suspension of the current project review activities, etc.)."]
[]
[]
["2.","Supporting maps, cross sections, well logs, calculations, and references to find more detailed information. The maps should show the AOR and Project Area, existing exemption boundaries, faults (with displacement information), lines of cross-section, a scale, north arrow and identify the name of formation or unit mapped. Also, structural contour and isopach maps of upper and lower \"confining\" units.\" Representative permeability and porosity values, if available, of the \"confining\" units should be labeled on these maps. The cross-sections should also show AOR(s), the proposed injection zone, confining units, the formation or units penetrated by injection with associated API numbers, water supply wells, locations of the BFW and USDW, and deviated wells within the line of section (i.e. wells near the cross-section trace)."]
[]
[]
[]
[]
[]
[]
["3.","The type log should also include the well's API number, the BFW, all formation names, key e-log markers, labeled geophysical curves and a vertical scale."]
[]
["4.","Identification of location and depth of all wells and bore holes. Each well and bore hole diagram should depict the entire history (e.g. sidetracks, redrills, and other mechanical changes)."]
[]
[]
["5.","The map should show the location of any pretreatment facilities, location of proposed injection wells and any other injection wells plumbed to the facility."]
[]
["6.","Information to include type of treatment and plan for the disposal of reject water."]
[]
["7.","Data on water quality of injection zone collected from wells located within the AOR and injectate. The source of the injectate fluids should be identified including zone/formation and approximate volume percentages. Sampling protocol for existing projects (PxP) should be provided. Any proposed water sampling and analysis proposed for new or expanded projects should follow the updated Notice to Operators (NTO, 2018). Footnote 8b = Any water quality data that will be used to justify the injection of fluids (e.g., showing that TDS concentrations within the propose injection zone are greater than 10,000 mg/L) must be accompanied by a written statement or report, prepared by a state-registered professional geologist or professional engineer, indicating the degree to which the water quality data is representative of the injectate fluid or native formation waters and providing justification for that conclusion."]
[]
[]
[]
[]
[]
[]
["8.","Water well survey. Water supply well locations within the project area should be presented on a map and displayed in a spreadsheet. The water supply well survey should utilize the following data sources (at a minimum): DWR well completion reports and GeoTracker Groundwater Ambient Monitoring and Assessment (GAMA) information system. The following information should be included in the spreadsheet: location information, type (municipal, domestic, irrigation, industrial, stock), status (active, idle, abandoned, destroyed), owner, well completion depth and zone name, top screen, bottom screen."]
[]
[]
[]
[]
["9.","These data are necessary in order to calculate hydraulic gradients and groundwater flow directions."]

{"sheet":"Microsoft Project Dates","index":5,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Begin","End","Duration"]
[null,"Project Analysis",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",C3+#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D3=\"\",IF(C3=\"\",\"\",\">\"&TODAY()-C3),IF(D3=C3,1,D3-C3))","v":{"$error":"#REF!"}}]
[null,"Data Gap Analysis",{"$f":"IF(#REF!=\"\",\"\",'Microsoft Project Dates'!C3+#REF!-1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",C4+#REF!-1)","v":{"$error":"#REF!"}},{"$f":"IF(D4=\"\",IF(C4=\"\",\"\",\">\"&TODAY()-C4),IF(D4=C4,1,D4-C4))","v":{"$error":"#REF!"}}]
[null,"Finished Review of Data Completeness","N/A",{"$f":"IF(D4=\"\",\"\",D4)","v":{"$error":"#REF!"}},"N/A"]
[null,"Obtain Missing Data from Operator",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C6)","v":{"$error":"#REF!"}},{"$f":"IF(D6=\"\",IF(C6=\"\",\"\",\">\"&TODAY()-C6),IF(D6=C6,1,D6-C6))","v":{"$error":"#REF!"}}]
[null,"Digitize Data for Electronic Project File",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+C7)","v":{"$error":"#REF!"}},{"$f":"IF(D7=\"\",IF(C7=\"\",\"\",\">\"&TODAY()-C7),IF(D7=C7,1,D7-C7))","v":{"$error":"#REF!"}}]
[null,"Electronic File is complete","N/A",{"$f":"IF(D7=\"\",\"\",D7)","v":{"$error":"#REF!"}},"N/A"]
[null,"Quality Review of Project Data",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",C3+#REF!+#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(D9=\"\",IF(C9=\"\",\"\",\">\"&TODAY()-C9),IF(D9=C9,1,D9-C9))","v":{"$error":"#REF!"}}]
[null,"Obtain Additional data?",{"$f":"IF(#REF!=\"\",\"\",#REF!+C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+C10)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Evaluate ZEI",{"$f":"IF(#REF!=\"\",\"\",#REF!+C3)","v":{"$error":"#REF!"}},{"$f":"IF(C11=\"\",\"\",C11+1)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Data is Sufficient","N/A",{"$f":"IF(D9=\"\",\"\",D9)","v":{"$error":"#REF!"}},"N/A"]
[null,"Check to see if the Reservoir requires an exemption",{"$f":"IF(C4=\"\",\"\",C4)","v":{"$error":"#REF!"}},{"$f":"IF(C13=\"\",\"\",C13)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Secure an exemption",{"$f":"IF(C13=\"\",\"\",C13)","v":{"$error":"#REF!"}}]
[null,"No exemption needed","N/A",{"$f":"IF(C13=\"\",\"\",C13)","v":{"$error":"#REF!"}},"N/A"]
[null,"Move to Review Stage","N/A",{"$f":"IF(C9=\"\",\"\",C9)","v":{"$error":"#REF!"}},"N/A"]
[null,"Technical Review",{"$f":"IF(C9=\"\",\"\",C9)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+#REF!+C3)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Geologic Review",{"$f":"IF(C9=\"\",\"\",C9)","v":{"$error":"#REF!"}},{"$f":"IF(D17=\"\",\"\",D17)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Operational Review",{"$f":"IF(C9=\"\",\"\",C9)","v":{"$error":"#REF!"}},{"$f":"IF(D17=\"\",\"\",D17)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Reservoir Review",{"$f":"IF(C21=\"\",\"\",C21)","v":{"$error":"#REF!"}},{"$f":"IF(D23=\"\",\"\",D23)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"ZEI Evaluation",{"$f":"IF(C11=\"\",\"\",C11)","v":{"$error":"#REF!"}},{"$f":"IF(D11=\"\",\"\",D11)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"AOR Evaluation",{"$f":"IF(#REF!=\"\",\"\",+C3+#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+#REF!+C3)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Define Operational Plan & draft PAL",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C23)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Project Review Completed","N/A",{"$f":"IF(D23=\"\",\"\",D23)","v":{"$error":"#REF!"}},"N/A"]
[null,"Review by HQ",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+C25)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Additional District Review",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C26)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Division Approves the PAL Language","N/A",{"$f":"IF(D26=\"\",\"\",D26)","v":{"$error":"#REF!"}},"N/A"]
[null,"Water Board Review",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C28)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Public Review",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},{"$f":"IF(C29=\"\",\"\",C29+15)","v":{"$error":"#REF!"}},{"$f":"IF(D29=\"\",IF(C29=\"\",\"\",\">\"&TODAY()-C29),IF(D29=C29,1,D29-C29))","v":{"$error":"#REF!"}}]
[null,"Received Water Board Concurrence","N/A",{"$f":"IF(#REF!=\"\",\"\",#REF!+#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},"N/A"]
[null,"Finalize & Issue PAL","N/A",{"$f":"IF(#REF!=\"\",\"\",#REF!+'Microsoft Project Dates'!C3)","v":{"$error":"#REF!"}},"N/A"]