{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["CellNames","Validation","Parts1-2","Parts3-5","Part6-7"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":125,"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":169,"n_cols":5,"rows_kept":169,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["_010","='Parts3-5'!$C$15:$J$15","","_010","='Parts3-5'!$C$15:$J$15"]
["_020","='Parts3-5'!$C$16:$J$16","","_020","='Parts3-5'!$C$16:$J$16"]
["_CC399","='Parts3-5'!$G$20","","_CC399","='Parts3-5'!$G$20"]
["_CC400","='Parts3-5'!$G$21","","_CC400","='Parts3-5'!$G$21"]
["_CC401","='Parts3-5'!$G$22","","_CC401","='Parts3-5'!$G$22"]
["_CC404","=Part6!$C$14","","_CC404","='Part6-7'!$C$14"]
["_CC405","=Part6!$C$15","","_CC405","='Part6-7'!$C$15"]
["_CC407","=Part6!$C$18","","_CC407","='Part6-7'!$C$18"]
["_CC430","=Part6!$C$34","","_CC430","='Part6-7'!$C$34"]
["_CC431","=Part6!$C$35","","_CC431","='Part6-7'!$C$35"]
["_CC439","=Part6!$C$21","","_CC439","='Part6-7'!$C$21"]
["_CC440","=Part6!$C$22","","_CC440","='Part6-7'!$C$22"]
["_CC441","=Part6!$C$23","","_CC441","='Part6-7'!$C$23"]
["_CN402","=Part6!$E$11","","_CN402","='Part6-7'!$F$11"]
["_CN403","=Part6!$E$13","","_CN403","='Part6-7'!$F$13"]
["_CN404","=Part6!$E$14","","_CN404","='Part6-7'!$F$14"]
["_CN405","=Part6!$E$15","","_CN405","='Part6-7'!$F$15"]
["_CN406","=Part6!$E$16","","_CN406","='Part6-7'!$F$16"]
["_CN407","=Part6!$E$18","","_CN407","='Part6-7'!$F$18"]
["_CN408","=Part6!$E$19","","_CN408","='Part6-7'!$F$19"]
["_CN413","=Part6!$E$31","","_CN413","='Part6-7'!$F$31"]
["_CN420","=Part6!$E$26","","_CN420","='Part6-7'!$F$26"]
["_CN421","=Part6!$E$27","","_CN421","='Part6-7'!$F$27"]
["_CN422","=Part6!$E$28","","_CN422","='Part6-7'!$F$28"]
["_CN423","=Part6!$E$29","","_CN423","='Part6-7'!$F$29"]
["_CN424","=Part6!$E$30","","_CN424","='Part6-7'!$F$30"]
["_CN425","=Part6!$E$32","","_CN425","='Part6-7'!$F$32"]
["_CN426","=Part6!$E$25","","_CN426","='Part6-7'!$F$25"]
["_CN430","=Part6!$E$34","","_CN430","='Part6-7'!$F$34"]
["_CN431","=Part6!$E$35","","_CN431","='Part6-7'!$F$35"]
["_CN432","=Part6!$E$36","","_CN432","='Part6-7'!$F$36"]
["_CN439","=Part6!$E$21","","_CN439","='Part6-7'!$F$21"]
["_CN440","=Part6!$E$22","","_CN440","='Part6-7'!$F$22"]
["_CN441","=Part6!$E$23","","_CN441","='Part6-7'!$F$23"]
["_CS399","='Parts3-5'!$I$20","","_CS399","='Parts3-5'!$I$20"]
["_CS400","='Parts3-5'!$I$21","","_CS400","='Parts3-5'!$I$21"]
["_CS401","='Parts3-5'!$I$22","","_CS401","='Parts3-5'!$I$22"]
["_CS402","=Part6!$D$11","","_CS402","='Part6-7'!$D$11"]
["_CS403","=Part6!$D$13","","_CS403","='Part6-7'!$D$13"]
["_CS404","=Part6!$D$14","","_CS404","='Part6-7'!$D$14"]
["_CS405","=Part6!$D$15","","_CS405","='Part6-7'!$D$15"]
["_CS406","=Part6!$D$16","","_CS406","='Part6-7'!$D$16"]
["_CS407","=Part6!$D$18","","_CS407","='Part6-7'!$D$18"]
["_CS408","=Part6!$D$19","","_CS408","='Part6-7'!$D$19"]
["_CS413","=Part6!$D$31","","_CS413","='Part6-7'!$D$31"]
["_CS420","=Part6!$D$26","","_CS420","='Part6-7'!$D$26"]
["_CS421","=Part6!$D$27","","_CS421","='Part6-7'!$D$27"]
["_CS422","=Part6!$D$28","","_CS422","='Part6-7'!$D$28"]
["_CS423","=Part6!$D$29","","_CS423","='Part6-7'!$D$29"]
["_CS424","=Part6!$D$30","","_CS424","='Part6-7'!$D$30"]
["_CS425","=Part6!$D$32","","_CS425","='Part6-7'!$D$32"]
["_CS426","=Part6!$D$25","","_CS426","='Part6-7'!$D$25"]
["_CS430","=Part6!$D$34","","_CS430","='Part6-7'!$D$34"]
["_CS431","=Part6!$D$35","","_CS431","='Part6-7'!$D$35"]
["_CS432","=Part6!$D$36","","_CS432","='Part6-7'!$D$36"]
["_CS439","=Part6!$D$21","","_CS439","='Part6-7'!$D$21"]
["_CS440","=Part6!$D$22","","_CS440","='Part6-7'!$D$22"]
["_CS441","=Part6!$D$23","","_CS441","='Part6-7'!$D$23"]
["_CS501","='Parts3-5'!$I$23","","_CS501","='Parts3-5'!$I$23"]
["_PCITY","='Parts1-2'!$C$25","","_PCITY","='Parts1-2'!$C$25"]
["_PN021","='Parts7-8'!$D$18","","_PN021","='Part6-7'!$E$47"]
["_PN091","='Parts7-8'!$D$19","","_PN091","='Part6-7'!$E$48"]
["_PN415","='Parts7-8'!$D$11","","_PN415","='Part6-7'!$E$40"]
["_PN435","='Parts7-8'!$D$20","","_PN435","='Part6-7'!$E$49"]
["_PN437","='Parts7-8'!$D$12","","_PN437","='Part6-7'!$E$41"]
["_PN438","='Parts7-8'!$D$15","","_PN438","='Part6-7'!$E$44"]
["_PN635","='Parts7-8'!$D$16","","_PN635","='Part6-7'!$E$45"]
["_PN644","='Parts7-8'!$D$14","","_PN644","='Part6-7'!$E$43"]
["_PN854","='Parts7-8'!$D$17","","_PN854","='Part6-7'!$E$46"]
["_PN931","='Parts7-8'!$D$13","","_PN931","='Part6-7'!$E$42"]
["_PS021","='Parts7-8'!$C$18","","_PS021","='Part6-7'!$C$47"]
["_PS091","='Parts7-8'!$C$19","","_PS091","='Part6-7'!$C$48"]
["_PS415","='Parts7-8'!$C$11","","_PS415","='Part6-7'!$C$40"]
["_PS435","='Parts7-8'!$C$20","","_PS435","='Part6-7'!$C$49"]
["_PS437","='Parts7-8'!$C$12","","_PS437","='Part6-7'!$C$41"]
["_PS438","='Parts7-8'!$C$15","","_PS438","='Part6-7'!$C$44"]
["_PS635","='Parts7-8'!$C$16","","_PS635","='Part6-7'!$C$45"]
["_PS644","='Parts7-8'!$C$14","","_PS644","='Part6-7'!$C$43"]
["_PS854","='Parts7-8'!$C$17","","_PS854","='Part6-7'!$C$46"]
["_PS931","='Parts7-8'!$C$13","","_PS931","='Part6-7'!$C$42"]
["_PSTAT","='Parts1-2'!$L$25","","_PSTAT","='Parts1-2'!$L$25"]
["_PSTRE","='Parts1-2'!$B$24","","_PSTRE","='Parts1-2'!$B$24"]
["_PZIP","='Parts1-2'!$O$25","","_PZIP","='Parts1-2'!$O$25"]
["_PZIP4","='Parts1-2'!$R$25","","_PZIP4","='Parts1-2'!$R$25"]
["_QC113","='Parts3-5'!$K$12","","_QC113","='Parts3-5'!$K$12"]
["_QC114","='Parts3-5'!$K$11","","_QC114","='Parts3-5'!$K$11"]
["_RA010","='Parts3-5'!$K$15","","_RA010","='Parts3-5'!$K$15"]
["_RA020","='Parts3-5'!$K$16","","_RA020","='Parts3-5'!$K$16"]
["_RB010","='Parts3-5'!$G$15","","_RB010","='Parts3-5'!$G$15"]
["_RB020","='Parts3-5'!$G$16","","_RB020","='Parts3-5'!$G$16"]
["_RP010","='Parts3-5'!$C$15","","_RP010","='Parts3-5'!$C$15"]
["_RP020","='Parts3-5'!$C$16","","_RP020","='Parts3-5'!$C$16"]
["_RR010","='Parts3-5'!$H$15","","_RR010","='Parts3-5'!$H$15"]
["_RR020","='Parts3-5'!$H$16","","_RR020","='Parts3-5'!$H$16"]
["_RS010","='Parts3-5'!$E$15","","_RS010","='Parts3-5'!$E$15"]
["_RS020","='Parts3-5'!$E$16","","_RS020","='Parts3-5'!$E$16"]
["_RT010","='Parts3-5'!$I$15","","_RT010","='Parts3-5'!$I$15"]
["_RT020","='Parts3-5'!$I$16","","_RT020","='Parts3-5'!$I$16"]
["_SC050","='Parts7-8'!$D$23","","_SC050","Removed 2011"]
["_SC136","='Parts7-8'!$D$38","","_SC136","Removed 2011"]
["_SC141","='Parts7-8'!$D$29","","_SC141","Removed 2011"]
["_SC142","='Parts7-8'!$D$25","","_SC142","Removed 2011"]
["_SC144","='Parts7-8'!$D$26","","_SC144","Removed 2011"]
["_SC150","='Parts7-8'!$D$36","","_SC150","Removed 2011"]
["_SC152","='Parts7-8'!$D$37","","_SC152","Removed 2011"]
["_SC203","='Parts7-8'!$D$30","","_SC203","Removed 2011"]
["_SC205","='Parts7-8'!$D$31","","_SC205","Removed 2011"]
["_SC207","='Parts7-8'!$D$32","","_SC207","Removed 2011"]
["_SC213","='Parts7-8'!$D$39","","_SC213","Removed 2011"]
["_SC244","='Parts7-8'!$D$34","","_SC244","Removed 2011"]
["_SC246","='Parts7-8'!$D$33","","_SC246","Removed 2011"]
["_SC311","='Parts7-8'!$D$40","","_SC311","Removed 2011"]
["_SC333","='Parts7-8'!$D$48","","_SC333","Removed 2011"]
["_SC445","='Parts7-8'!$D$27","","_SC445","Removed 2011"]
["_SC465","='Parts7-8'!$D$42","","_SC465","Removed 2011"]
["_SC466","='Parts7-8'!$D$43","","_SC466","Removed 2011"]
["_SC467","='Parts7-8'!$D$44","","_SC467","Removed 2011"]
["_SC511","='Parts7-8'!$D$45","","_SC511","Removed 2011"]
["_SC854","='Parts7-8'!$D$46","","_SC854","Removed 2011"]
["_SC931","='Parts7-8'!$D$47","","_SC931","Removed 2011"]
["_SC999","='Parts7-8'!$D$49","","_SC999","Removed 2011"]
["_SW050","='Parts7-8'!$C$23","","_SW050","Removed 2011"]
["_SW136","='Parts7-8'!$C$38","","_SW136","Removed 2011"]
["_SW141","='Parts7-8'!$C$29","","_SW141","Removed 2011"]
["_SW142","='Parts7-8'!$C$25","","_SW142","Removed 2011"]
["_SW144","='Parts7-8'!$C$26","","_SW144","Removed 2011"]
["_SW150","='Parts7-8'!$C$36","","_SW150","Removed 2011"]
["_SW152","='Parts7-8'!$C$37","","_SW152","Removed 2011"]
["_SW203","='Parts7-8'!$C$30","","_SW203","Removed 2011"]
["_SW205","='Parts7-8'!$C$31","","_SW205","Removed 2011"]
["_SW207","='Parts7-8'!$C$32","","_SW207","Removed 2011"]
["_SW213","='Parts7-8'!$C$39","","_SW213","Removed 2011"]
["_SW244","='Parts7-8'!$C$34","","_SW244","Removed 2011"]
["_SW246","='Parts7-8'!$C$33","","_SW246","Removed 2011"]
["_SW311","='Parts7-8'!$C$40","","_SW311","Removed 2011"]
["_SW333","='Parts7-8'!$C$48","","_SW333","Removed 2011"]
["_SW445","='Parts7-8'!$C$27","","_SW445","Removed 2011"]
["_SW465","='Parts7-8'!$C$42","","_SW465","Removed 2011"]
["_SW466","='Parts7-8'!$C$43","","_SW466","Removed 2011"]
["_SW467","='Parts7-8'!$C$44","","_SW467","Removed 2011"]
["_SW511","='Parts7-8'!$C$45","","_SW511","Removed 2011"]
["_SW854","='Parts7-8'!$C$46","","_SW854","Removed 2011"]
["_SW931","='Parts7-8'!$C$47","","_SW931","Removed 2011"]
["_SW999","='Parts7-8'!$C$49","","_SW999","Removed 2011"]
["_UL105","='Parts3-5'!$E$11","","_UL105","='Parts3-5'!$E$11"]
["_UL107","='Parts3-5'!$E$12","","_UL107","='Parts3-5'!$E$12"]
["_UL109","='Parts3-5'!$K$10","","_UL109","='Parts3-5'!$K$10"]
["_VFORM","='Parts1-2'!$A$7","","_VFORM","='Parts1-2'!$A$7"]
["cext","='Parts1-2'!$R$30","","cext","='Parts1-2'!$R$30"]
["city","='Parts1-2'!$C$28","","city","='Parts1-2'!$C$28"]
["contnm","='Parts1-2'!$G$29","","contnm","='Parts1-2'!$G$29"]
["DBA","='Parts1-2'!$H$20","","DBA","='Parts1-2'!$H$20"]
["fax","='Parts1-2'!$G$31","","fax","='Parts1-2'!$G$31"]
["ID","='Parts1-2'!$H$15","","ID","='Parts1-2'!$H$15"]
["IDChngChk","='Parts1-2'!$J$18","","IDChngChk","='Parts1-2'!$J$18"]
["intnet","='Parts1-2'!$G$32","","intnet","='Parts1-2'!$G$32"]
["Name1","='Parts1-2'!$H$19","","Name1","='Parts1-2'!$H$19"]
["Name2","='Parts1-2'!$H$21","","Name2","='Parts1-2'!$H$21"]
["Notes","='Parts1-2'!$A$35","","Notes","='Parts1-2'!$A$35"]
["phone","='Parts1-2'!$G$30","","phone","='Parts1-2'!$G$30"]
["ResubChk","='Parts1-2'!$X$15","","ResubChk","='Parts1-2'!$X$15"]
["state","='Parts1-2'!$L$28","","state","='Parts1-2'!$L$28"]
["STCodes","='Parts1-2'!$AA$1:$AA$54","","STCodes","='Parts1-2'!$AA$1:$AA$54"]
["Street","='Parts1-2'!$B$27","","Street","='Parts1-2'!$B$27"]
["TCN","='Parts1-2'!$L$22","","TCN","='Parts1-2'!$L$22"]
["Version","='Parts1-2'!$Y$6","","Version","='Parts1-2'!$Y$6"]
["zip","='Parts1-2'!$O$28","","zip","='Parts1-2'!$O$28"]
["zip4","='Parts1-2'!$R$28","","zip4","='Parts1-2'!$R$28"]
[null,null,0]

{"sheet":"Validation","index":1,"n_rows":169,"n_cols":4,"rows_kept":169,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Validation/Formula","Error Alert"]
["_010","='Parts3-5'!$C$15:$J$15","-","-"]
["_020","='Parts3-5'!$C$16:$J$16","-","-"]
["_CC399","='Parts3-5'!$G$20","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC400","='Parts3-5'!$G$21","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC401","='Parts3-5'!$G$22","=IF(SUM(G20:H21)=0,\"\",SUM(G20:H21))","-"]
["_CC404","='Part6-7'!$C$14","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC405","='Part6-7'!$C$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC407","='Part6-7'!$C$18","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC430","='Part6-7'!$C$34","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC431","='Part6-7'!$C$35","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC439","='Part6-7'!$C$21","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC440","='Part6-7'!$C$22","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CC441","='Part6-7'!$C$23","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN402","='Part6-7'!$F$11","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN403","='Part6-7'!$F$13","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN404","='Part6-7'!$F$14","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN405","='Part6-7'!$F$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN406","='Part6-7'!$F$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN407","='Part6-7'!$F$18","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN408","='Part6-7'!$F$19","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN413","='Part6-7'!$F$31","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN420","='Part6-7'!$F$26","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN421","='Part6-7'!$F$27","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN422","='Part6-7'!$F$28","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN423","='Part6-7'!$F$29","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN424","='Part6-7'!$F$30","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN425","='Part6-7'!$F$32","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN426","='Part6-7'!$F$25","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN430","='Part6-7'!$F$34","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN431","='Part6-7'!$F$35","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN432","='Part6-7'!$F$36","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN439","='Part6-7'!$F$21","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN440","='Part6-7'!$F$22","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CN441","='Part6-7'!$F$23","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS399","='Parts3-5'!$I$20","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS400","='Parts3-5'!$I$21","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS401","='Parts3-5'!$I$22","=IF(SUM(I20:K21)=0,\"\",SUM(I20:K21))","-"]
["_CS402","='Part6-7'!$D$11","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS403","='Part6-7'!$D$13","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS404","='Part6-7'!$D$14","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS405","='Part6-7'!$D$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS406","='Part6-7'!$D$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS407","='Part6-7'!$D$18","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS408","='Part6-7'!$D$19","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS413","='Part6-7'!$D$31","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS420","='Part6-7'!$D$26","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS421","='Part6-7'!$D$27","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS422","='Part6-7'!$D$28","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS423","='Part6-7'!$D$29","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS424","='Part6-7'!$D$30","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS425","='Part6-7'!$D$32","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS426","='Part6-7'!$D$25","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS430","='Part6-7'!$D$34","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS431","='Part6-7'!$D$35","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS432","='Part6-7'!$D$36","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS439","='Part6-7'!$D$21","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS440","='Part6-7'!$D$22","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS441","='Part6-7'!$D$23","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_CS501","='Parts3-5'!$I$23","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PCITY","='Parts1-2'!$C$25","-","-"]
["_PN021","='Part6-7'!$E$47","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN091","='Part6-7'!$E$48","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN415","='Part6-7'!$E$40","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN435","='Part6-7'!$E$49","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN437","='Part6-7'!$E$41","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN438","='Part6-7'!$E$44","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN635","='Part6-7'!$E$45","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN644","='Part6-7'!$E$43","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN854","='Part6-7'!$E$46","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PN931","='Part6-7'!$E$42","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS021","='Part6-7'!$C$47","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS091","='Part6-7'!$C$48","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS415","='Part6-7'!$C$40","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS435","='Part6-7'!$C$49","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS437","='Part6-7'!$C$41","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS438","='Part6-7'!$C$44","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS635","='Part6-7'!$C$45","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS644","='Part6-7'!$C$43","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS854","='Part6-7'!$C$46","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PS931","='Part6-7'!$C$42","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_PSTAT","='Parts1-2'!$L$25","=STCodes List","Value must be a valid State Code from the drop down"]
["_PSTRE","='Parts1-2'!$B$24","-","-"]
["_PZIP","='Parts1-2'!$O$25","AND(LEN(_PZIP)=5,ISNUMBER(VALUE(_PZIP)))","Enter a valid 5 digit zip code."]
["_PZIP4","='Parts1-2'!$R$25","AND(LEN(_PZIP4)=4,ISNUMBER(VALUE(_PZIP4)))","Enter a valid zip code extention."]
["_QC113","='Parts3-5'!$K$12","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_QC114","='Parts3-5'!$K$11","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RA010","='Parts3-5'!$K$15","=IF(SUM(_010)=0,\"\",SUM(_010))","-"]
["_RA020","='Parts3-5'!$K$16","=IF(SUM(_020)=0,\"\",SUM(_020))","-"]
["_RB010","='Parts3-5'!$G$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RB020","='Parts3-5'!$G$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RP010","='Parts3-5'!$C$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RP020","='Parts3-5'!$C$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RR010","='Parts3-5'!$H$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RR020","='Parts3-5'!$H$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RS010","='Parts3-5'!$E$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RS020","='Parts3-5'!$E$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RT010","='Parts3-5'!$I$15","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_RT020","='Parts3-5'!$I$16","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC050","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC136","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC141","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC142","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC144","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC150","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC152","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC203","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC205","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC207","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC213","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC244","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC246","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC311","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC333","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC445","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC465","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC466","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC467","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC511","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC854","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC931","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SC999","Removed 2011","=IF(SUM(D23:D48)=0,\"\",SUM(D23:D48))","-"]
["_SW050","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW136","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW141","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW142","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW144","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW150","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW152","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW203","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW205","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW207","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW213","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW244","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW246","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW311","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW333","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW445","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW465","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW466","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW467","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW511","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW854","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW931","Removed 2011","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_SW999","Removed 2011","=IF(SUM(C23:C48)=0,\"\",SUM(C23:C48))","-"]
["_UL105","='Parts3-5'!$E$11","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_UL107","='Parts3-5'!$E$12","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_UL109","='Parts3-5'!$K$10","Whole Number: >=0","Value must be a whole number greater than or equal to zero."]
["_VFORM","='Parts1-2'!$A$7","-","-"]
["cext","='Parts1-2'!$R$30","-","-"]
["city","='Parts1-2'!$C$28","-","-"]
["contnm","='Parts1-2'!$G$29","-","-"]
["DBA","='Parts1-2'!$H$20","-","-"]
["fax","='Parts1-2'!$G$31","AND(LEN(fax)=10,ISNUMBER(fax))","Enter a valid 10 digit telephone number."]
["ID","='Parts1-2'!$H$15","Length = 10","Enter a valid ten-digit EIA ID."]
["IDChngChk","='Parts1-2'!$J$18","AND(LEN(IDChngChk)=1,IDChngChk=\"X\")","Enter an \"X\" if any Respondent Identification Data has changed."]
["intnet","='Parts1-2'!$G$32","-","-"]
["Name1","='Parts1-2'!$H$19","-","-"]
["Name2","='Parts1-2'!$H$21","-","-"]
["Notes","='Parts1-2'!$A$35","-","-"]
["phone","='Parts1-2'!$G$30","AND(LEN(phone)=10,ISNUMBER(phone))","Enter a valid 10 digit telephone number."]
["ResubChk","='Parts1-2'!$X$15","AND(LEN(ResubChk)=1,OR(ResubChk=\"X\",ResubChk=\" \"))","Enter \"X\" if this is a resubmission."]
["state","='Parts1-2'!$L$28","=STCodes List","Value must be a valid State Code from the drop down"]
["STCodes","='Parts1-2'!$AA$1:$AA$54","-","-"]
["Street","='Parts1-2'!$B$27","-","-"]
["TCN","='Parts1-2'!$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-2'!$Y$6","-","-"]
["zip","='Parts1-2'!$O$28","AND(LEN(zip)=5,ISNUMBER(VALUE(zip)))","Enter a valid 5 digit zip code."]
["zip4","='Parts1-2'!$R$28","AND(LEN(zip4)=4,ISNUMBER(VALUE(zip4)))","Enter a valid zip code extention."]

{"sheet":"Parts1-2","index":2,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[33,0,33,24],[34,0,54,24],[27,2,27,8],[27,14,27,15],[30,6,30,13],[31,6,31,17],[29,6,29,13],[28,6,28,17],[14,7,14,15],[22,29,22,45],[23,1,23,17],[26,1,26,17],[18,7,18,17],[19,7,19,17],[20,7,20,17],[16,19,17,24],[21,11,21,17],[24,2,24,8],[24,14,24,15],[25,0,25,18],[6,0,6,24],[8,0,8,24],[9,0,11,24],[12,0,12,18],[7,0,7,24],[13,7,13,8],[13,10,13,11],[13,13,13,15]],"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-820",{"$nulls":25},"CN","Canada"]
["ANNUAL REFINERY REPORT",{"$nulls":25},"CO","Colorado "]
["REPORT YEAR 2014",{"$nulls":25},"CT","Connecticut "]
["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. For further information concerning sanctions and data protections see the provision on sanctions and the provision concerning the confidentiality of information in the instructions. Title 18 USC 1001 makes it a criminal offense for any person knowingly and willingly makes to any Agency or Department of the United States any false, fictitious, or fraudulent statements as to any matter within its jurisdiction.",{"$nulls":25},"DE","Delaware "]
[{"$nulls":26},"DC","District of Columbia"]
[{"$nulls":26},"FL","Florida "]
["PART 1.  RESPONDENT IDENTIFICATION DATA",{"$nulls":18},"PART 2.   SUBMISSION/RESUBMISSION INFORMATION",{"$nulls":6},"GA","Georgia "]
[{"$nulls":26},"HI","Hawaii "]
["EIA ID NUMBER:",{"$nulls":18},"If this is a resubmission, enter an \"X\" in the box:",{"$nulls":6},"ID","Idaho "]
[{"$nulls":26},"IL","Illinois "]
["If any Respondent Identification Data has changed since the last report, ",{"$nulls":18},"A completed form must be received by February 15th of the designated report year.",{"$nulls":6},"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 methods:",{"$nulls":6},"KS","Kansas "]
["Doing Business As:",{"$nulls":25},"KY","Kentucky "]
["Site Name:",{"$nulls":18},"Email:",{"$nulls":6},"LA","Louisiana "]
["Terminal Control Number (TCN):",{"$nulls":25},"ME","Maine "]
["Physical Address (e.g., Street Address, Building Number, Floor, Suite):",{"$nulls":18},"Fax:","(202) 586-1076",{"$nulls":5},"MD","Maryland "]
[{"$nulls":26},"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 mailing addresses are the same, only complete the physical address.",{"$nulls":18},"Secure File Transfer:",{"$nulls":6},"MN","Minnesota "]
[{"$nulls":26},"MS","Mississippi "]
["City:",{"$nulls":9},"State:",null,null,"Zip:",null,null,"-",null,null,"Questions?",null,"Call:   202-586-6281",{"$nulls":4},"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":25},"NH","New Hampshire "]
[{"$nulls":26},"NJ","New Jersey "]
["Comments:  Explain any unusual or substantially different aspects of your current year's operations that affect the data reported.  For example, note new processing units, major modifications or retirement of processing units, sale of refinery, etc.  (To separate one comment from another, press ALT+ENTER)",{"$nulls":25},"NM","New Mexico "]
[{"$nulls":26},"NY","New York "]
[{"$nulls":26},"NC","North Carolina "]
[{"$nulls":26},"ND","North Dakota "]
[{"$nulls":26},"OH","Ohio "]
[{"$nulls":26},"OK","Oklahoma "]
[{"$nulls":26},"OR","Oregon "]
[{"$nulls":26},"PA","Pennsylvania "]
[{"$nulls":26},"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 "]

{"sheet":"Parts3-5","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[21,8,21,10],[22,8,22,10],[19,6,19,7],[20,6,20,7],[19,8,19,10],[20,8,20,10],[8,4,8,5],[13,8,13,9],[14,8,14,9],[15,8,15,9],[8,6,8,8],[10,6,10,8],[9,6,9,8],[13,4,13,5],[13,2,13,3],[18,6,18,7],[18,8,18,10],[23,0,23,10],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[22,6,22,7],[21,6,21,7],[3,0,3,10],[5,0,5,10],[14,2,14,3],[15,2,15,3],[10,4,10,5],[11,4,11,5],[14,4,14,5],[7,0,7,10],[12,0,12,10],[11,6,11,8],[9,0,9,2],[9,4,9,5],[4,0,4,10],[18,0,18,4],[17,0,17,10],[16,0,16,10],[10,0,10,2],[8,0,8,2],[11,0,11,2],[15,4,15,5]],"flags":["formulas_cached_only"]}
[{"$nulls":10},"OMB No. 1905-0165"]
[{"$nulls":10},"Expiration Date: x/x/xxxx"]
[{"$nulls":10},"Version No.:xxxx.xx"]
["FORM EIA-820"]
["ANNUAL REFINERY REPORT"]
["REPORT YEAR 2014"]
["EIA ID NUMBER:   ",{"$nulls":9},"RESUBMISSION:        "]
["PART 3. FUEL, ELECTRICITY, AND STEAM PURCHASED & CONSUMED AT THE REFINERY DURING 2013"]
["Item",null,null,"Code","Quantity Used As Fuel or Feedstock",null,"Item",null,null,"Code","Quantity Used\nas Fuel"]
["Natural Gas (million standard cubic feet):",{"$nulls":5},"Coal (thousand short tons)",null,null,109]
["Fuel",null,null,105,null,null,"Purchased Electricity (million kWh)",null,null,114]
["Hydrogen Feedstock",null,null,107,null,null,"Purchased Steam (million pounds)",null,null,113]
["PART 4.  REFINERY RECEIPTS OF CRUDE OIL BY METHOD OF TRANSPORTATION DURING 2013 (Thousand Barrels)"]
["Source","Code","Pipelines",null,"Tankers",null,"Barges","Tank Cars","Trucks",null,"Total1"]
["Domestic","010",{"$nulls":8},""]
["Foreign","020",{"$nulls":8},""]
["1 Total Domestic and Total Foreign Refinery Receipts (Codes 010 and 020) must equal the sum of the comparable refinery receipts on the Form EIA-810, \"Monthly Refinery Report,\" filed for January through December 2013."]
["PART 5.  ATMOSPHERIC CRUDE OIL DISTILLATION CAPACITY AS OF JANUARY 1"]
["Atmospheric Crude Oil Distillation Capacity",{"$nulls":4},"Code","Barrel per Calendar Day2",null,"Barrels per Stream Day"]
["2014:   Operating",{"$nulls":4},399]
["Idle",{"$nulls":4},400]
["Total Operable",{"$nulls":4},401,"",null,""]
["2015:   Operable",{"$nulls":4},501]
["2 Barrels per Calendar Day Operating, Idle and Total Operable Capacity (Codes 399, 400 and 401) must match the comparable capacity numbers reported on the Form EIA-810, \"Monthly Refinery Report,\" filed for January 2014."]

{"sheet":"Part6-7","index":4,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[11,3,11,4],[10,3,10,4],[3,0,3,5],[5,0,5,5],[4,0,4,5],[8,2,9,2],[8,5,9,5],[8,3,9,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[33,3,33,4],[34,3,34,4],[31,3,31,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[37,1,38,1],[40,2,40,3],[42,4,42,5],[39,2,39,3],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[32,3,32,4],[47,2,47,3],[48,2,48,3],[35,3,35,4],[37,2,38,3],[41,4,41,5],[36,0,36,5],[37,4,38,5],[39,4,39,5],[40,4,40,5],[37,0,38,0],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,4,47,5],[48,4,48,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"OMB No. 1905-0165"]
[{"$nulls":5},"Expiration Date: x/x/xxxx"]
[{"$nulls":5},"Version No.:xxxx.xx"]
["FORM EIA-820"]
["ANNUAL REFINERY REPORT"]
["REPORT YEAR 2014"]
["EIA ID NUMBER:   ",{"$nulls":4},"RESUBMISSION:        "]
["PART 6.  DOWNSTREAM CHARGE CAPACITY AS OF JANUARY 1"]
[null,null,"2014\nBarrels per\nCalendar Day","2014\nBarrels per\nStream Day",null,"2015\n Barrels per\nStream  Day"]
["Downstream Charge Capacity","Code"]
["Vacuum Distillation",402]
["Thermal Cracking:"]
["   Visbreaking",403]
["   Fluid Coking (incl. Flexicoking)",404]
["   Delayed Coking",405]
["   Other (incl. Gas Oil)",406]
["Catalytic Cracking:"]
["   Fresh Feed",407]
["   Recycled",408]
["Catalytic Hydrocracking:"]
["    Distillate",439]
["    Gas Oil",440]
["    Residual",441]
["Desulfurization (including Catalytic Hydrotreating):"]
["   Naphtha/Reformer Feed",426]
["   Gasoline",420]
["   Kerosene and Jet",421]
["   Diesel Fuel",422]
["   Other Distillate",423]
["   Residual",424]
["   Heavy Gas Oil",413]
["   Other",425]
["Catalytic Reforming:"]
["   Low Pressure",430]
["   High Pressure",431]
["Fuels Solvent Deasphalting",432]
["PART  7.  PRODUCTION CAPACITY AS OF JANUARY 1 (Barrels per Stream Day, Except Where Noted)"]
["Production Capacity","Code","2014\nBarrels per Stream Day",null,"2015\nBarrels per Stream Day"]
[]
["Alkylates",415]
["Aromatics",437]
["Asphalt and Road Oil",931]
["Isobutane (C4)",644]
["Isopentane (C5), Isohexane (C6)",438]
["Isooctane (C8)",635]
["Lubricants",854]
["Petroleum Coke - Marketable","021"]
["Hydrogen (million cubic ft. per day)","091"]
["Sulfur (short tons per day)",435]