{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["CellNames","Validation","Parts1-3"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":61,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"CellNames","index":0,"n_rows":59,"n_cols":2,"rows_kept":59,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["_BS220","='Parts1-3'!$P$40"]
["_BS243","='Parts1-3'!$P$36"]
["_BS247","='Parts1-3'!$P$39"]
["_BS248","='Parts1-3'!$P$37"]
["_BS249","='Parts1-3'!$P$38"]
["_ES220","='Parts1-3'!$X$40"]
["_ES243","='Parts1-3'!$X$36"]
["_ES247","='Parts1-3'!$X$39"]
["_ES248","='Parts1-3'!$X$37"]
["_ES249","='Parts1-3'!$X$38"]
["_GP220","='Parts1-3'!$U$40"]
["_GP243","='Parts1-3'!$U$36"]
["_GP247","='Parts1-3'!$U$39"]
["_GP248","='Parts1-3'!$U$37"]
["_GP249","='Parts1-3'!$U$38"]
["_GR220","='Parts1-3'!$S$40"]
["_GR243","='Parts1-3'!$S$36"]
["_GR247","='Parts1-3'!$S$39"]
["_GR248","='Parts1-3'!$S$37"]
["_GR249","='Parts1-3'!$S$38"]
["_IN249","='Parts1-3'!$T$38"]
["_PCITY","='Parts1-3'!$C$25"]
["_PSTAT","='Parts1-3'!$L$25"]
["_PSTRE","='Parts1-3'!$B$24"]
["_PZIP","='Parts1-3'!$O$25"]
["_PZIP4","='Parts1-3'!$R$25"]
["_SH220","='Parts1-3'!$V$40"]
["_SH243","='Parts1-3'!$V$36"]
["_SH247","='Parts1-3'!$V$39"]
["_SH248","='Parts1-3'!$V$37"]
["_SH249","='Parts1-3'!$V$38"]
["_UL220","='Parts1-3'!$W$40"]
["_UL243","='Parts1-3'!$W$36"]
["_UL247","='Parts1-3'!$W$39"]
["_UL248","='Parts1-3'!$W$37"]
["_UL249","='Parts1-3'!$W$38"]
["_VFORM","='Parts1-3'!$A$7"]
["cext","='Parts1-3'!$R$30"]
["city","='Parts1-3'!$C$28"]
["contnm","='Parts1-3'!$G$29"]
["DBA","='Parts1-3'!$H$20"]
["fax","='Parts1-3'!$G$31"]
["ID","='Parts1-3'!$H$16"]
["IDChngChk","='Parts1-3'!$J$18"]
["intnet","='Parts1-3'!$G$32"]
["Month","='Parts1-3'!$K$14"]
["Name1","='Parts1-3'!$H$19"]
["Name2","='Parts1-3'!$H$21"]
["Notes","='Parts1-3'!$A$43"]
["phone","='Parts1-3'!$G$30"]
["ResubChk","='Parts1-3'!$X$14"]
["state","='Parts1-3'!$L$28"]
["STCodes","='Parts1-3'!$AA$1:$AA$54"]
["Street","='Parts1-3'!$B$27"]
["TCN","='Parts1-3'!$L$22"]
["Version","='Parts1-3'!$Y$6"]
["Year","='Parts1-3'!$O$14"]
["zip","='Parts1-3'!$O$28"]
["zip4","='Parts1-3'!$R$28"]

{"sheet":"Validation","index":1,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Validation/Formula","Error Alert"]
["_BS220","='Parts1-3'!$P$40","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_BS243","='Parts1-3'!$P$36","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_BS247","='Parts1-3'!$P$39","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_BS248","='Parts1-3'!$P$37","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_BS249","='Parts1-3'!$P$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_ES220","='Parts1-3'!$X$40","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_ES243","='Parts1-3'!$X$36","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_ES247","='Parts1-3'!$X$39","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_ES248","='Parts1-3'!$X$37","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_ES249","='Parts1-3'!$X$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GP220","='Parts1-3'!$U$40","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GP243","='Parts1-3'!$U$36","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GP247","='Parts1-3'!$U$39","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GP248","='Parts1-3'!$U$37","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GP249","='Parts1-3'!$U$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GR220","='Parts1-3'!$S$40","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GR243","='Parts1-3'!$S$36","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GR247","='Parts1-3'!$S$39","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GR248","='Parts1-3'!$S$37","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_GR249","='Parts1-3'!$S$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_IN249","='Parts1-3'!$T$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_PCITY","='Parts1-3'!$C$25","-","-"]
["_PSTAT","='Parts1-3'!$L$25","=STCodes List","Value must be a valid State Code from the drop down"]
["_PSTRE","='Parts1-3'!$B$24","-","-"]
["_PZIP","='Parts1-3'!$O$25","AND(LEN(_PZIP)=5,ISNUMBER(VALUE(_PZIP)))","Enter a valid 5 digit zip code."]
["_PZIP4","='Parts1-3'!$R$25","AND(LEN(_PZIP4)=4,ISNUMBER(VALUE(_PZIP4)))","Enter a valid zip code extention."]
["_SH220","='Parts1-3'!$V$40","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_SH243","='Parts1-3'!$V$36","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_SH247","='Parts1-3'!$V$39","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_SH248","='Parts1-3'!$V$37","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_SH249","='Parts1-3'!$V$38","Whole number: 0 - 100,000","Entry must be numeric and between 0 and 100,000."]
["_UL220","='Parts1-3'!$W$40","Whole number: -100,000 and 100,000","Entry must be numeric and between -100,000 and 100,000."]
["_UL243","='Parts1-3'!$W$36","Whole number: -100,000 and 100,000","Entry must be numeric and between -100,000 and 100,000."]
["_UL247","='Parts1-3'!$W$39","Whole number: -100,000 and 100,000","Entry must be numeric and between -100,000 and 100,000."]
["_UL248","='Parts1-3'!$W$37","Whole number: -100,000 and 100,000","Entry must be numeric and between -100,000 and 100,000."]
["_UL249","='Parts1-3'!$W$38","Whole number: -100,000 and 100,000","Entry must be numeric and between -100,000 and 100,000."]
["_VFORM","='Parts1-3'!$A$7","-","-"]
["cext","='Parts1-3'!$R$30","-","-"]
["city","='Parts1-3'!$C$28","-","-"]
["contnm","='Parts1-3'!$G$29","-","-"]
["DBA","='Parts1-3'!$H$20","-","-"]
["fax","='Parts1-3'!$G$31","AND(LEN(fax)=10,ISNUMBER(fax))","Enter a valid 10 digit telephone number."]
["ID","='Parts1-3'!$H$16","Length = 10","Enter a valid ten-digit EIA ID."]
["IDChngChk","='Parts1-3'!$J$18","AND(LEN(IDChngChk)=1,IDChngChk=\"X\")","Enter an \"X\" if any Respondent Identification Data has changed."]
["intnet","='Parts1-3'!$G$32","-","-"]
["Month","='Parts1-3'!$K$14","Whole number: 1-12","Enter a valid month value; 1 - 12."]
["Name1","='Parts1-3'!$H$19","-","-"]
["Name2","='Parts1-3'!$H$21","-","-"]
["Notes","='Parts1-3'!$A$43","-","-"]
["phone","='Parts1-3'!$G$30","AND(LEN(phone)=10,ISNUMBER(phone))","Enter a valid 10 digit telephone number."]
["ResubChk","='Parts1-3'!$X$14","AND(LEN(ResubChk)=1,OR(ResubChk=\"X\",ResubChk=\" \"))","Enter \"X\" if this is a resubmission."]
["state","='Parts1-3'!$L$28","=STCodes List","Value must be a valid State Code from the drop down"]
["STCodes","='Parts1-3'!$AA$1:$AA$54","-","-"]
["Street","='Parts1-3'!$B$27","-","-"]
["TCN","='Parts1-3'!$L$22","=AND(LEN(TCN)=12,LEFT(TCN,1)=\"T\",MID(TCN,2,1)=\"-\",ISNUMBER(VALUE(MID(TCN,3,2))),MID(TCN,5,1)=\"-\",ISERR(VALUE((MID(TCN,6,2)))),MID(TCN,8,1)=\"-\",ISNUMBER(VALUE(MID(TCN,9,4))))","Value must be entered in the format:\n         T-xx-aa-xxxx,\nwhere the first character is a T,\n          x is numeric, and\n          a is alphabetic."]
["Version","='Parts1-3'!$Y$6","-","-"]
["Year","='Parts1-3'!$O$14","AND(ISNUMBER(Year),Year>2009,LEN(Year)=4)","Enter a valid four-digit year; 2010 or later.  \n\nPlease secure a 2009 form from the EIA website to provide submissions and resubmissions for 2009."]
["zip","='Parts1-3'!$O$28","AND(LEN(zip)=5,ISNUMBER(VALUE(zip)))","Enter a valid 5 digit zip code."]
["zip4","='Parts1-3'!$R$28","AND(LEN(zip4)=4,ISNUMBER(VALUE(zip4)))","Enter a valid zip code extention."]

{"sheet":"Parts1-3","index":2,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[21,11,21,17],[24,2,24,8],[24,14,24,15],[25,0,25,18],[37,23,37,24],[24,29,24,45],[24,20,24,24],[23,1,23,17],[27,2,27,8],[27,14,27,15],[36,15,36,17],[35,15,35,17],[35,23,35,24],[36,12,36,14],[15,7,15,14],[18,19,19,24],[20,21,20,22],[36,23,36,24],[21,20,21,22],[19,7,19,17],[20,7,20,17],[34,0,34,11],[29,6,29,13],[18,7,18,17],[42,0,48,24],[41,0,41,24],[26,1,26,17],[33,0,33,24],[27,19,29,24],[30,6,30,13],[31,6,31,17],[34,23,34,24],[34,12,34,14],[34,15,34,17],[6,0,6,24],[7,0,7,24],[15,19,16,24],[8,0,10,24],[11,0,11,18],[12,10,12,11],[12,13,12,15],[12,7,12,8],[13,7,13,9],[13,14,13,15],[39,12,39,14],[28,6,28,17],[39,15,39,17],[35,12,35,14],[35,0,35,11],[36,0,36,11],[39,23,39,24],[38,15,38,17],[38,23,38,24],[37,15,37,17],[38,12,38,14],[39,0,39,11],[38,0,38,11],[37,0,37,11],[37,12,37,14]],"flags":["formulas_cached_only"]}
[{"$nulls":27},"State "]
[{"$nulls":26},"AL","Alabama "]
[{"$nulls":26},"AK","Alaska "]
[{"$nulls":24},"OMB No. 1905-0165",null,"AZ","Arizona "]
[{"$nulls":24},"Expiration Date: x/x/xxxx",null,"AR","Arkansas "]
[{"$nulls":24},"Version No.:xxxx.xx",null,"CA","California "]
["FORM EIA-816",{"$nulls":25},"CN","Canada"]
["MONTHLY NATURAL GAS LIQUIDS REPORT",{"$nulls":25},"CO","Colorado "]
["This report is mandatory under the Federal Energy Administration Act of 1974 (Public Law 93-275).  Failure to comply may result in criminal fines, civil penalties and other sanctions as provided by law.  Title 18 USC 1001 makes it a criminal offense for any person knowingly and willingly to make to any Agency or Department of the United States any false, fictitious, or fraudulent statements as to any matter within its jurisdiction.  See Instructions for further details on the sanctions and the provisions concerning the confidentiality of information submitted on this form.",{"$nulls":25},"CT","Connecticut "]
[{"$nulls":26},"DE","Delaware "]
[{"$nulls":26},"DC","District of Columbia"]
["PART 1.  RESPONDENT IDENTIFICATION DATA",{"$nulls":18},"PART 2.   SUBMISSION/RESUBMISSION INFORMATION",{"$nulls":6},"FL","Florida "]
[{"$nulls":26},"GA","Georgia "]
["REPORT PERIOD:",{"$nulls":6},"Month",{"$nulls":4},"Year",{"$nulls":6},"If this is a resubmission, enter an \"X\" in the box:",{"$nulls":6},"HI","Hawaii "]
[{"$nulls":26},"ID","Idaho "]
["EIA ID NUMBER:",{"$nulls":18},"A completed form must be received by the 20th calendar day following the end of the report month.",{"$nulls":6},"IL","Illinois "]
["If any Respondent Identification Data has changed since the last report, ",{"$nulls":25},"IN","Indiana "]
[null,"enter an \"X\" in the box:",{"$nulls":24},"IA","Iowa "]
["Company Name:",{"$nulls":18},"Forms may be submitted using one of the following\nmethods:",{"$nulls":6},"KS","Kansas "]
["Doing Business As:",{"$nulls":25},"KY","Kentucky "]
["Site Name:",{"$nulls":25},"LA","Louisiana "]
["Terminal Control Number (TCN):",{"$nulls":18},"Email:",{"$nulls":6},"ME","Maine "]
["Physical Address (e.g., Street Address, Building Number, Floor, Suite):",{"$nulls":18},"Fax:","(202) 586-1076",{"$nulls":5},"MD","Maryland "]
[{"$nulls":19},"Secure File Transfer:",{"$nulls":6},"MA","Massachusetts "]
["City:",{"$nulls":9},"State:",null,null,"Zip:",null,null,"-",{"$nulls":9},"MI","Michigan "]
["Mailing Address of Contact (e.g., PO Box, RR):  If the physical and \nmailing addresses are the same, only complete the physical address.",{"$nulls":25},"MN","Minnesota "]
[{"$nulls":19},"Electronic Transmission:",{"$nulls":6},"MS","Mississippi "]
["City:",{"$nulls":9},"State:",null,null,"Zip:",null,null,"-",null,null,"For the PC Electronic Data Reporting Option (PEDRO) software, call (202) 586-9659.  \n(See Form instructions, pg 1)",{"$nulls":6},"MO","Missouri "]
["Contact Name:",{"$nulls":25},"MT","Montana "]
["Phone No.:",{"$nulls":14},"Ext:",{"$nulls":10},"NE","Nebraska "]
["Fax No.:",{"$nulls":25},"NV","Nevada "]
["Email address:",{"$nulls":18},"Questions?",null,"Call:   202-586-2992",{"$nulls":4},"NH","New Hampshire "]
[{"$nulls":26},"NJ","New Jersey "]
["PART 3.  NATURAL GAS LIQUIDS ACTIVITY (Thousand Barrels)",{"$nulls":25},"NM","New Mexico "]
["Item Description",{"$nulls":11},"Product Code",null,null,"Stocks Beginning of Month",null,null,"Receipts During\nMonth","Inputs\nDuring\nMonth","Production During\nMonth","Shipments During\nMonth","Plant Fuel Use &\nLosses","Stocks\n End \nof Month",null,null,"NY","New York "]
["Ethane",{"$nulls":11},243,{"$nulls":13},"NC","North Carolina "]
["Propane",{"$nulls":11},248,{"$nulls":13},"ND","North Dakota "]
["Normal Butane",{"$nulls":11},249,{"$nulls":13},"OH","Ohio "]
["Isobutane",{"$nulls":11},247,{"$nulls":13},"OK","Oklahoma "]
["Pentanes Plus",{"$nulls":11},220,{"$nulls":13},"OR","Oregon "]
[{"$nulls":26},"PA","Pennsylvania "]
["Comments: Identify any unusual aspects of your reporting month's operations. (To separate one comment from another, press ALT+ENTER.)",{"$nulls":25},"PR","Puerto Rico"]
[{"$nulls":26},"RI","Rhode Island "]
[{"$nulls":26},"SC","South Carolina "]
[{"$nulls":26},"SD","South Dakota "]
[{"$nulls":26},"TN","Tennessee "]
[{"$nulls":26},"TX","Texas "]
[{"$nulls":26},"UT","Utah "]
[{"$nulls":26},"VT","Vermont "]
[{"$nulls":26},"VA","Virginia "]
[{"$nulls":26},"WA","Washington "]
[{"$nulls":26},"WV","West Virginia "]
[{"$nulls":26},"WI","Wisconsin "]
[{"$nulls":26},"WY","Wyoming "]