{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inventory Sheet","Cover","Instructions","Sample Inventory","Inventory","Data Descriptions","Dropdown","CodeValidation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":21,"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":"Inventory Sheet","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Macros Must be Enabled to Use this Tool"]

{"sheet":"Cover","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["Version","Author","Description","Date"]
[1,"DMRSP","Draft Version","2022-12-09"]
[1.1000000000000001,"Programs I","Draft Version: Included validation options.","2022-12-27"]
[1.2,"Programs I","Draft Version: Included validation options + Legal Edits","2022-12-28"]
[1.3,"Programs I","Draft Version: Included more validation Macro Enabling","2023-01-06"]

{"sheet":"Instructions","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"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 Steam, 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 name of oil or gas field associated with the location of the wellhead or the production facility. ","Text.","Y"]
["Latitude Asset (NAD83)","Latitude coordinates for the well or production facility in accordance with California Code of Regulations, title 14, section 1765.2, subdivision (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 California Code of Regulations, title 14, section 1765.2, subdivision (d).","Decimal. Between 6 and 8 digits to the right of the decimal point.","Y"]
["Receptor Type","Captures sensitive receptor type as defined in California Code of Regulations, title 14, section 1765.1, subdivisions (c )-(e).\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 State of the sensitive receptor. \n*No Abbrevation.","Text. E.g., California ","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 California Code of Regulations, title 14, section 1765.2, subdivisions (a)-(c). \n* No special characters.","Numbers. No special characters.","Y*"]
["Latitude Receptor (NAD83)","Latitude coordinates for the sensitive receptor in accordance with California Code of Regulations, title 14, section 1765.2, subdivision (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 California Code of Regulations, title 14, section 1765.2, subdivision (d). ","Decimal. Between 6 and 8 digits to the right of the decimal point.","Y"]

{"sheet":"Sample Inventory","index":3,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":true,"merged":[[4,0,4,9],[4,10,4,18]]}
["Type of Inventory","Notice of Intention","Form ID:",123456]
["Operator:","CA Oil Company"]
["Operator Code:",1234567]
["Report Prepared By:","John Smith"]
["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","Receptor Sub Type","Address Line 1","City","State","Postal Zip Code","Distance (ft)","Latitude Receptor (NAD83)","Longitude Receptor (NAD83)"]
["Well","0402988449","NOI Well 1","Oil & Gas",null,null,null,"Lost Hills",35.612301000000002,-119.70895400000001,"1765.1(C ) (2)","College","20899 CA-46","Lost Hills","CA",93249,300,35.615115000000003,-119.710275]
["Well","0402988449","NOI Well 1","Oil & Gas",null,null,null,"Lost Hills",35.612301000000002,-119.70895400000001,"1765.1(C ) (6)","Business Building","20899 CA-46","Lost Hills","CA",93249,300,35.615326000000003,-119.709536]
["Well","0402988449","NOI Well 1","Oil & Gas",null,null,null,"Lost Hills",35.612301000000002,-119.70895400000001,"1765.1(C ) (2)","Grade 1-12","21109 CA-46","Lost Hills","CA",93249,800,35.614466999999998,-119.700801]
["Production Facility",null,null,null,"Tanks",123451,"Tank 451","Lost Hills",35.604736000000003,-119.705061,"1765.1(C ) (2)","College","20899 CA-46","Lost Hills","CA",93249,1600,35.615115000000003,-119.710275]
["Production Facility",null,null,null,"Tanks",123451,"Tank 451","Lost Hills",35.604736000000003,-119.705061,"1765.1(C ) (6)","Business Building","20899 CA-46","Lost Hills","CA",93249,1600,35.615326000000003,-119.709536]
["Production Facility",null,null,null,"Tanks",123451,"Tank 451","Lost Hills",35.604736000000003,-119.705061,"1765.1(C ) (2)","Grade 1-12","21109 CA-46","Lost Hills","CA",93249,1500,35.614466999999998,-119.700801]
["Production Facility",null,null,null,"Pipelines",154321,"Pipeline 21","Lost Hills",35.614687000000004,-119.711646,"1765.1(C ) (2)","College","20899 CA-46","Lost Hills","CA",93249,160,35.615115000000003,-119.710275]
["Production Facility",null,null,null,"Pipelines",154321,"Pipeline 21","Lost Hills",35.614687000000004,-119.711646,"1765.1(C ) (6)","Business Building","20899 CA-46","Lost Hills","CA",93249,250,35.615326000000003,-119.709536]
["Production Facility",null,null,null,"Pipelines",154321,"Pipeline 21","Lost Hills",35.614687000000004,-119.711646,"1765.1(C ) (2)","Grade 1-12","21109 CA-46","Lost Hills","CA",93249,1200,35.614466999999998,-119.700801]

{"sheet":"Inventory","index":4,"n_rows":7,"n_cols":19,"rows_kept":7,"cut":false,"hidden":true,"merged":[[4,10,4,18],[4,0,4,9]]}
["Type of Inventory","Notice of Intention","Form ID:",123456]
["Operator:","CA Oil Company"]
["Operator Code:",1234567]
["Report Prepared By:","John Smith"]
["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","Receptor Sub Type","Address Line 1","City","State","Postal Zip Code","Distance (ft)","Latitude Receptor (NAD83)","Longitude Receptor (NAD83)"]
["Production Facility","0402988449","NOI Well 1","Oil & Gas",null,null,null,"Lost Hills",35.612301000000002,-119.70895400000001,"1765.1(C ) (1)","Private Home","20899 CA-46","Lost Hills","CA",93249,300,35.615115000000003,-119.710275]

{"sheet":"Data Descriptions","index":5,"n_rows":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
["Sensitive Receptor Definition (Cal. Code Regs., tit. 14, § 1765.1, subds. (c)-(e))"]
["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."]
["1765.1(d)  A park is an education 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."]
["1765.1(e)  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."]
[]
["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"]

{"sheet":"Dropdown","index":6,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Type of Asset",null,null,"Well Type",null,null,null,"PRC Section","PRC Description","Sensitive Receptor Type","PRC Section","Sensitive Receptor SubType"]
["Production Facility",null,null,"Air Injection",null,null,null,"1765.1(C ) (1)","A residence, including a private home, condominium, apartment, and living quarter.",null,"1765.1(C ) (1)","Residence","Private Home"]
["Well",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,null,"Condominium"]
[null,null,null,"Dry Gas",null,null,null,"1765.1(C ) (3)","A community resource center, including a youth center.","Community Resource Center",null,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,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","1765.1(C ) (2)","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,null,"Transitional Kindergaten"]
[null,null,null,"Gas Storage",null,null,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,null,null,"Grade 1-12"]
[null,null,null,"Liquefied Gas ",null,null,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,null,null,null,null,null,"Park"]
[null,null,null,"Observation",null,null,null,null,null,null,null,null,"Playground"]
[null,null,null,"Oil & Gas",null,null,null,null,null,null,null,null,"University"]
[null,null,null,"Pressure Maintenance ",null,null,null,null,null,null,null,null,"College"]
[null,null,null,"Cyclic Steam",null,null,null,null,null,null,"1765.1(C ) (3)","Community Resource Center","Youth Center"]
[null,null,null,"Steamflood",null,null,null,null,null,null,null,null,"Community Resource Center"]
[null,null,null,"Steamflood and Cyclic Steam",null,null,null,null,null,null,"1765.1(C ) (4)","Health Care Facility","Hospital"]
[null,null,null,"Unknown",null,null,null,null,null,null,null,null,"Retirement Home"]
[null,null,null,"Water Disposal",null,null,null,null,null,null,null,null,"Nursing Home"]
[null,null,null,"Waterflood",null,null,null,null,null,null,"1765.1(C ) (5)","Live-in Housing","Long Term Care Hospital"]
[null,null,null,"Waterflood and Steamflood",null,null,null,null,null,null,null,null,"Hospice"]
[null,null,null,"Water Source ",null,null,null,null,null,null,null,null,"Prison"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Detention Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Dormitory"]
[null,null,null,null,null,null,null,null,null,null,"1765.1(C ) (6)","Business Building","Business Building"]
[null,null,null,null,null,null,null,null,null,null,null,"Park","Park"]
[null,null,null,null,null,null,null,null,null,null,null,"Public Building","Public Building"]
[]
[null,null,null,"Type of Inventory"]
[null,null,null,"Notice of Intention"]
[null,null,null,"New Production Facility"]
[null,null,null,"Annual Inventory Report"]

{"sheet":"CodeValidation","index":7,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["PRC Section","Sensitive Receptor Type","Sensitive Receptor SubType","Count","Fill",null,"PRC Section",null,"Well Type",null,"Type of Asset",null,"Production Facility Type"]
["1765.1(C ) (1)","Residence","Private Home",null,{"$f":"IF(A2=\"\",E1,A2)","v":"1765.1(C ) (1)"},null,"1765.1(C ) (1)",null,"Not Applicable",null,"Production Facility",null,"Not Applicable"]
[null,null,"Condominium",null,{"$f":"IF(A3=\"\",E2,A3)","v":"1765.1(C ) (1)"},null,"1765.1(C ) (2)",null,"Air Injection",null,"Well",null,"Tanks"]
[null,null,"Apartment",null,"1765.1(C ) (1)",null,"1765.1(C ) (3)",null,"Core Hole",null,null,null,"Pressure Vessels"]
[null,null,"Living Quarter",null,"1765.1(C ) (1)",null,"1765.1(C ) (4)",null,"Dry Gas",null,null,null,"Fired pressure vessels or boilers"]
["1765.1(C ) (2)","Education Resource","Preschool",null,"1765.1(C ) (2)",null,"1765.1(C ) (5)",null,"Dry Hole",null,null,null,"Compressors"]
[null,null,"Transitional Kindergaten",null,"1765.1(C ) (2)",null,"1765.1(C ) (6)",null,"Gas",null,null,null,"Water Treatment Equipment"]
[null,null,"Kindergaten ",null,"1765.1(C ) (2)",null,null,null,"Gas Disposal",null,null,null,"Gas Treatment Equipment"]
[null,null,"Grade 1-12",null,"1765.1(C ) (2)",null,null,null,"Gas Storage",null,null,null,"Pipelines"]
[null,null,"Daycar Center",null,"1765.1(C ) (2)",null,null,null,"Injection",null,null,null,"Pit or Sumps"]
[null,null,"Park",null,"1765.1(C ) (2)",null,null,null,"Liquefied Gas ",null,null,null,"Pumps"]
[null,null,"Playground",null,"1765.1(C ) (2)",null,null,null,"Multi-Purpose",null,null,null,"Flares"]
[null,null,"University",null,"1765.1(C ) (2)",null,null,null,"Observation",null,null,null,"Production Safety Systems"]
[null,null,"College",null,"1765.1(C ) (2)",null,null,null,"Oil & Gas",null,null,null,"Any other Equipment"]
["1765.1(C ) (3)","Community Resource Center","Youth Center",null,"1765.1(C ) (3)",null,null,null,"Pressure Maintenance "]
[null,null,"Community Resource Center",null,"1765.1(C ) (3)",null,null,null,"Cyclic Steam"]
["1765.1(C ) (4)","Health Care Facility","Hospital",null,"1765.1(C ) (4)",null,null,null,"Steamflood"]
[null,null,"Retirement Home",null,"1765.1(C ) (4)",null,null,null,"Steamflood and Cyclic Steam"]
[null,null,"Nursing Home",null,"1765.1(C ) (4)",null,null,null,"Unknown"]
["1765.1(C ) (5)","Live-in Housing","Long Term Care Hospital",null,"1765.1(C ) (5)",null,null,null,"Water Disposal"]
[null,null,"Hospice",null,"1765.1(C ) (5)",null,null,null,"Waterflood"]
[null,null,"Prison",null,"1765.1(C ) (5)",null,null,null,"Waterflood and Steamflood"]
[null,null,"Detention Center",null,"1765.1(C ) (5)",null,null,null,"Water Source "]
[null,null,"Dormitory",null,"1765.1(C ) (5)"]
["1765.1(C ) (6)","Business Building","Business Building",null,"1765.1(C ) (6)"]
[null,"Park","Park",null,"1765.1(C ) (6)"]
[null,"Public Building","Public Building",null,"1765.1(C ) (6)"]