{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["WelcomePage","Welcome Page","Cover","Sample_Page","Instructions","Inventory_Inside HPZ","Inventory_Outside HPZ","Data Descriptions","Dropdown"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":15,"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":"WelcomePage","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":true,"merged":[[18,0,22,3],[18,4,22,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Macros Must be Enabled to Use this Tool"]
[]
[]
[]
[]
["To enable Macros manually, see Microsoft link for help:",null,null,null,"Support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365-files"]

{"sheet":"Welcome Page","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Sorry!  Macros must be enabled to use this workbook!  Please close the file and re-open it with macros enabled!"]

{"sheet":"Cover","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Title","EICD001 - UIC Project Well Data"]
[]
[]
["Version","Author","Description","Date"]
[1,"DMRSP","Draft Version","2022-12-09"]
[2,"Ibukun Ajayi","SB1137 Implementation Team Update","2025-01-14"]

{"sheet":"Sample_Page","index":3,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,0,5,9],[5,10,5,17]]}
["Type of Inventory:","Annual Inventory Report","Form ID:",99999]
["Operator:","CalGEM_DOC"]
["Operator Code:",9999]
["Report Prepared By:","Staff"]
[]
["Well/Facility Information",null,null,null,null,null,null,null,null,null,"Potential Receptor Information"]
["Type of Asset","Well API Number","Well Name","Well Type","Production Facility Type","Facility ID (If not a Well)","Facility Name (If not a Well)","Field Name","Latitude Asset (NAD83)","Longitude Asset (NAD83)","Potential Receptor Type","Address Line 1","City","State","Postal Zip Code","Distance (ft)","Latitude Receptor (NAD83)","Longitude Receptor (NAD83)"]
["Well",321456987,"HPZ - 01","Oil & Gas",null,null,null,"Cymric",35.615115000000003,-119.710275,"1765.9 (a) (1) Not a sensitive receptor - Building","20899 CA-46","Lost Hills","CA",93249,1600,35.615115000000003,-119.710275]
["Well",321456987,"HPZ - 02","Oil & Gas",null,null,null,"Lost Hills",35.615115000000003,-119.710275,"1765.9 (a) (1) Not a sensitive receptor - Park","20899 CA-46","Lost Hills","CA",93249,1600,35.615326000000003,-119.709536]
["Production Facility",null,null,null,"Tanks",12345,null,"Lost Hills",37.154789000000001,-119.710275,"1765.9 (a) (1) Not a sensitive receptor - Building","21109 CA-46","Lost Hills","CA",93249,1500,35.614466999999998,-119.700801]
["Production Facility Aggregate",null,null,null,"Fired pressure vessels or boilers",45659,null,"McKittrick",35.615326000000003,-119.709536,"1765.9 (a) (1) Not a sensitive receptor - Park","21109 CA-46","McKittrick","CA",93687,1500]
["Well",321456987,"HPZ - 03","Oil & Gas",null,null,null,"Midway Sunset",35.615326000000003,-119.709536,"1765.9 (a) (1) Not a sensitive receptor - Others","20899 CA-46","Lost Hills","CA",93249,160,35.615115000000003,-119.710275]
[]
[null,null,null,null,null,null,null,null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Building","21109 CA-46","Lost Hills","CA",93249,1200,35.614466999999998,-119.700801]

{"sheet":"Instructions","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data Element","Instructions","Format / Acceptable Values","Required"]
["Type of Inventory","Captures the type of inventory the user is submitting. \nNotice of Intention should be selected if inventory is submitted in connection with Notice of Intention. * Provide the Form ID\nNew Production Facility  should be selected if inventory is submitted in connection with New production faciility.\nAnnual Inventory  should be selected if inventory is submitted in connection with Annual Inventory Report.","Text. Notice of Intention,  New Production Facility, Annual Inventory Report","Y*"]
["Form ID","Captures the form id if Inventory type submitted is in connection with Notice of Intention","Number","Y"]
["Operator","Name of the Operator submitting inventory data","Text","Y"]
["Operator Code","Operator Code of the operator submitting inventory data","Text","Y"]
["Report Prepared By:","Name of the person who prepared the report","Text","Y"]
["Type of Asset","Captures information of the type of asset. ","Text. Well, Production Facility","Y"]
["Well API Number","API Number  (CA State Code + County Code + WellID). Enter the API number for the Wells. One in each row. \n* No hyphen\n* This is a required field when Facility Type is Well. Otherwise ignored.","Number (10-digit)  e.g. 04xxxxxxxx","Y*"]
["Well Name","This is a required field when Facility Type is a Well. Otherwise ignored.","Text","Y*"]
["Well Type","Captures the type of well at the wellhead.\n This is a required field when Facility Type is a Well. Otherwise ignored. \n*See Data descriptions tab.","Text *See Data descriptions tab.\ne.g. Steamflood, Cyclic Steams, Oil and Gas, etc.","Y*"]
["Production Facility Type","Captures the categorical identification of the type production facility.\n*This is a required field when Facility Type is not a Well. Otherwise ignored.","Text *See Data descriptions tab.\ne.g. Tanks, Gas Treatment Equipment , etc.","Y*"]
["Facility ID (If not a Well)","Captures the unique facility identification that the Division has assigned to the production facility.\n*This is a required field when Facility Type is not a Well. Otherwise ignored.","Number","Y*"]
["Facility Name (If not a Well)","*This is a required field when Facility Type is not  Well. Otherwise ignored.","Text","Y*"]
["Field Name","Captures the Field Name associated with the  oil and gas production that are owned by the Operator.","Text","Y"]
["Latitude Asset (NAD83)","Latitude coordinates for the well or production facility in accordance with 1765.2 (d) ","Decimal. Between 6 and 8 digits to the right of the decimal point ","Y"]
["Longitude Asset (NAD83)","Longitude coordinates for the Well or production facility in accordance with 1765.2 (d) ","Decimal. Between 6 and 8 digits to the right of the decimal point ","Y"]
["Receptor Type","Captures sensitive receptor type as defined in 1765.1 (C ) (1) - (6)\n*See Data descriptions tab.","Text. *See Data descriptions tab.","Y*"]
["Receptor Sub Type",null,null,"Y"]
["Address Line 1","Captures the street number and street name of the sensitive receptor","Text e.g. 123, CalGEM Lane, Unit ##","Y"]
["City","Captures the city of the sensitive receptor","Text","Y"]
["State","Captures the street State of the sensitive receptor. \n*No Abbrevation","Text","Y"]
["Postal Zip Code","Captures the postal zip code of the sensitive receptor","Number (5-digit)  e.g. 9xxxx","Y"]
["Distance (ft)","Measures horizontal distances in feet between the sensitive receptor and Well head or Production facility in accordance with 1765.2 (a) - (c ). \n* No special characters","Numbers. No special characters ","Y*"]
["Latitude Receptor (NAD83)","Latitude coordinates for the sensitive receptor in accordance with 1765.2 (d) ","Decimal. Between 6 and 8 digits to the right of the decimal point ","Y"]
["LongitudeRecepto (NAD83)","Longitude coordinates for the sensitive receptor in accordance with 1765.2 (d) ","Decimal. Between 6 and 8 digits to the right of the decimal point ","Y"]

{"sheet":"Inventory_Inside HPZ","index":5,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,10,5,13],[5,0,5,9]]}
["Type of Inventory:","Annual Inventory Report","Form ID:",12345]
["Operator:","CA Oil Company"]
["Operator Code:",1234567]
["Report Prepared By:","John Doe"]
[]
["Well/Facility Information",null,null,null,null,null,null,null,null,null,"Sensitive Receptor Information"]
["Type of Asset","Well API Number","Well Name","Well Type","Production Facility Type","Facility ID (If not a Well)","Facility Name (If not a Well)","Field Name","Latitude Asset (NAD83)","Longitude Asset (NAD83)","Receptor Type","Distance (ft)","Latitude Receptor (NAD83)","Longitude Receptor (NAD83)"]
["Well",321456987,null,null,null,null,null,"Cymric",35.615115000000003,-119.710275,"1765.1(C ) (1) A residence, including a private home, condominium, apartment, and living quarter.",500,35.615115000000003,-119.710275]
["Production Facility Aggregate",321456987,null,null,"Fired pressure vessels or boilers",null,null,"Midway Sunset",35.615326000000003,-119.709536,"1765.1(C ) (3) A community resource center, including a youth center.",1000,35.615115000000003,-119.710275]
["Production Facility Aggregate",null,null,null,"Fired pressure vessels or boilers"]
["Well",123456789]
["Well"]
[]
[]
[]
[]
[]
[]
[]
["Production Facility"]

{"sheet":"Inventory_Outside HPZ","index":6,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,0,5,9],[5,10,5,17]]}
["Type of Inventory:","Annual Inventory Report","Form ID:"]
["Operator:"]
["Operator Code:"]
["Report Prepared By:"]
[]
["Well/Facility Information",null,null,null,null,null,null,null,null,null,"Potential Receptor Information"]
["Type of Asset","Well API Number","Well Name","Well Type","Production Facility Type","Facility ID (If not a Well)","Facility Name (If not a Well)","Field Name","Latitude Asset (NAD83)","Longitude Asset (NAD83)","Potential Receptor Type","Address Line 1","City","State","Postal Zip Code","Distance (ft)","Latitude Receptor (NAD83)","Longitude Receptor (NAD83)"]
["Well",321456987,"HPZ - 01","Oil & Gas",null,null,null,"Cymric",35.615115000000003,-119.710275,"1765.9 (a) (1) Not a sensitive receptor - Building","20899 CA-46","Lost Hills","CA",93249,1600,35.615115000000003,-119.710275]
["Production Facility",null,null,null,null,null,null,null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Park","20899 CA-46","Lost Hills","CA",93249,1600,35.615326000000003,-119.709536]
["Production Facility Aggregate",null,null,null,null,null,null,null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Building","21109 CA-46","Lost Hills","CA",93249,1500,35.614466999999998,-119.700801]
["Well",321456987]
["Well",321456987,null,null,null,null,null,"Midway Sunset",35.615326000000003,-119.709536,"1765.9 (a) (1) Not a sensitive receptor - Others","20899 CA-46","Lost Hills","CA",93249,160,35.615115000000003,-119.710275]
[null,null,null,null,null,null,null,null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Park","20899 CA-46","Lost Hills","CA",93249,250,35.615326000000003,-119.709536]
[null,null,null,null,null,null,null,null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Building","21109 CA-46","Lost Hills","CA",93249,1200,35.614466999999998,-119.700801]

{"sheet":"Data Descriptions","index":7,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["Sensitive Receptor Definition (1765.1(C ) (1) - (6)"]
["1765.1(C ) (1) A residence, including a private home, condominium, apartment, and living quarter."]
["1765.1(C ) (2) An education resource, including a preschool, school maintaining transitional kindergarten, kindergarten, or any of grades 1 to 12, inclusive, daycare center, park, playground, university, and college. Where a university or college is the only sensitive receptor within 3,200 feet of the operator’s wellheads or production facilities, the university or college is not a sensitive receptor if the operator demonstrates to the Division’s satisfaction that no building with nominal daily occupancy on the university or college campus is located within 3,200 feet of the operator’s wellheads or production facilities."]
["1765.1(C ) (3) A community resource center, including a youth center."]
["1765.1(C ) (4) A health care facility, including a hospital, retirement home, and nursing home."]
["1765.1(C ) (5) Live-in housing, including a long-term care hospital, hospice, prison, detention center, and dormitory."]
["1765.1(C ) (6) Any building housing a business that is open to the public."]
[]
["Well Type"]
["Air Injection"]
["Core Hole"]
["Dry Gas"]
["Dry Hole"]
["Gas"]
["Gas Disposal"]
["Gas Storage"]
["Injection"]
["Liquefied Gas "]
["Multi-Purpose"]
["Observation"]
["Oil & Gas"]
["Pressure Maintenance "]
["Cyclic Steam"]
["Steamflood"]
["Steamflood and Cyclic Steam"]
["Unknown"]
["Water Disposal"]
["Waterflood"]
["Waterflood and Steamflood"]
["Water Source "]
[]
["Production Facility Type"]
["Tanks"]
["Pressure Vessels"]
["Fired pressure vessels or boilers"]
["Compressors"]
["Water Treatment Equipment"]
["Gas Treatment Equipment"]
["Pipelines"]
["Pit or Sumps"]
["Pumps"]
["Flares"]
["Production Safety Systems"]
["Any other Equipment"]
["Production Facility Aggregate"]

{"sheet":"Dropdown","index":8,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Type of Asset",null,null,"Well Type",null,null,null,"Sensititive Receptor Type","Sensitive Receptor Type","Sensitive Receptor SubType"]
["Well",null,null,"Air Injection",null,null,null,"1765.1(C ) (1) A residence, including a private home, condominium, apartment, and living quarter.",null,"Residence","Private Home"]
["Production Facility",null,null,"Core Hole",null,null,null,"1765.1(C ) (2) An education resource, including a preschool, school maintaining transitional kindergarten, kindergarten, or any of grades 1 to 12, inclusive, daycare center, park, playground, university, and college. Where a university or college is the only sensitive receptor within 3,200 feet of the operator’s wellheads or production facilities, the university or college is not a sensitive receptor if the operator demonstrates to the Division’s satisfaction that no building with nominal daily occupancy on the university or college campus is located within 3,200 feet of the operator’s wellheads or production facilities.","Education Resource",null,"Condominium"]
["Production Facility Aggregate",null,null,"Dry Gas",null,null,null,"1765.1(C ) (3) A community resource center, including a youth center.","Community Resource Center",null,"Apartment"]
[null,null,null,"Dry Hole",null,null,null,"1765.1(C ) (4) A health care facility, including a hospital, retirement home, and nursing home.","Health Care Facility",null,"Living Quarter"]
[null,null,null,"Gas",null,null,null,"1765.1(C ) (5) Live-in housing, including a long-term care hospital, hospice, prison, detention center, and dormitory.","Live-in Housing","Education Resource","Preschool"]
[null,null,null,"Gas Disposal",null,null,null,"1765.1(C ) (6) Any building housing a business that is open to the public.","Business Building",null,"Transitional Kindergaten"]
[null,null,null,"Gas Storage",null,null,null,null,null,null,"Kindergaten ","(d) A park is an educational resource for purposes of subdivision (c) if it is an area that is open to the public for outdoor recreation that is at least partially within one-quarter mile of a residence or another education resource. Only the portion of a park that is within one-quarter mile of a residence or another education resource shall be considered a sensitive receptor."]
[null,null,null,"Injection",null,null,null,null,null,null,"Grade 1-12"]
[null,null,null,"Liquefied Gas ",null,null,null,null,null,null,"Daycar Center","If a building is open to the public, then for purposes of subdivision (c) it is either a business that is open to the public or it is a community resource center. A building is open to the public if visitors are regularly permitted on the premises who are not the owner of the building and are not employees, contractors, or service providers of the owner of the building"]
[null,null,null,"Multi-Purpose",null,null,null,"Potential Receptor Type",null,null,"Park"]
[null,null,null,"Observation",null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Building",null,null,"Playground"]
[null,null,null,"Oil & Gas",null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Park",null,null,"University"]
[null,null,null,"Pressure Maintenance ",null,null,null,"1765.9 (a) (1) Not a sensitive receptor - Others",null,null,"College"]
[null,null,null,"Cyclic Steam",null,null,null,null,null,"Community Resource Center","Youth Center"]
[null,null,null,"Steamflood",null,null,null,null,null,null,"Community Resource Center"]
[null,null,null,"Steamflood and Cyclic Steam",null,null,null,null,null,"Health Care Facility","Hospital"]
[null,null,null,"Unknown",null,null,null,null,null,null,"Retirement Home"]
[null,null,null,"Water Disposal",null,null,null,null,null,null,"Nursing Home"]
[null,null,null,"Waterflood",null,null,null,null,null,"Live-in Housing","Long Term Care Hospital"]
[null,null,null,"Waterflood and Steamflood",null,null,null,null,null,null,"Hospice"]
[null,null,null,"Water Source ",null,null,null,null,null,null,"Prison"]
[null,null,null,null,null,null,null,null,null,null,"Detention Center"]
[null,null,null,null,null,null,null,null,null,null,"Dormitory"]
[null,null,null,null,null,null,null,null,null,"Business Building","Business Building"]
[null,null,null,null,null,null,null,null,null,"Park"]
[null,null,null,null,null,null,null,null,null,"Public Building","Public Building"]
[]
[null,null,null,"Type of Inventory"]
["Production Facility Type",null,null,"Notice of Intention"]
["Tanks",null,null,"New Production Facility"]
["Pressure Vessels",null,null,"Annual Inventory Report"]
["Fired pressure vessels or boilers"]
["Compressors"]
["Water Treatment Equipment"]
["Gas Treatment Equipment"]
["Pipelines"]
["Pit or Sumps"]
["Pumps"]
["Flares"]
["Production Safety Systems"]
["Any other Equipment"]
["Production Facility Aggregate"]