{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["CellNames","Validation","Parts1-2","Part3"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":191,"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":189,"n_cols":2,"rows_kept":189,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["_117","='Parts3-4'!$C$24:$I$24"]
["_117P2","='Parts3-4'!$F$24"]
["_117P3","='Parts3-4'!$G$24"]
["_117P4","='Parts3-4'!$H$24"]
["_117P5","='Parts3-4'!$I$24"]
["_117PA","='Parts3-4'!$C$24"]
["_117PB","='Parts3-4'!$D$24"]
["_117PC","='Parts3-4'!$E$24"]
["_117US","='Parts3-4'!$J$24"]
["_118","='Parts3-4'!$C$22:$I$22"]
["_118P2","='Parts3-4'!$F$22"]
["_118P3","='Parts3-4'!$G$22"]
["_118P4","='Parts3-4'!$H$22"]
["_118P5","='Parts3-4'!$I$22"]
["_118PA","='Parts3-4'!$C$22"]
["_118PB","='Parts3-4'!$D$22"]
["_118PC","='Parts3-4'!$E$22"]
["_118US","='Parts3-4'!$J$22"]
["_125","='Parts3-4'!$C$15:$I$15"]
["_125P2","='Parts3-4'!$F$15"]
["_125P3","='Parts3-4'!$G$15"]
["_125P4","='Parts3-4'!$H$15"]
["_125P5","='Parts3-4'!$I$15"]
["_125PA","='Parts3-4'!$C$15"]
["_125PB","='Parts3-4'!$D$15"]
["_125PC","='Parts3-4'!$E$15"]
["_125US","='Parts3-4'!$J$15"]
["_127","='Parts3-4'!$C$16:$I$16"]
["_127P2","='Parts3-4'!$F$16"]
["_127P3","='Parts3-4'!$G$16"]
["_127P4","='Parts3-4'!$H$16"]
["_127P5","='Parts3-4'!$I$16"]
["_127PA","='Parts3-4'!$C$16"]
["_127PB","='Parts3-4'!$D$16"]
["_127PC","='Parts3-4'!$E$16"]
["_127US","='Parts3-4'!$J$16"]
["_130","='Parts3-4'!$C$20:$I$20"]
["_130P2","='Parts3-4'!$F$20"]
["_130P3","='Parts3-4'!$G$20"]
["_130P4","='Parts3-4'!$H$20"]
["_130P5","='Parts3-4'!$I$20"]
["_130PA","='Parts3-4'!$C$20"]
["_130PB","='Parts3-4'!$D$20"]
["_130PC","='Parts3-4'!$E$20"]
["_130US","='Parts3-4'!$J$20"]
["_138","='Parts3-4'!$C$25:$I$25"]
["_138P2","='Parts3-4'!$F$25"]
["_138P3","='Parts3-4'!$G$25"]
["_138P4","='Parts3-4'!$H$25"]
["_138P5","='Parts3-4'!$I$25"]
["_138PA","='Parts3-4'!$C$25"]
["_138PB","='Parts3-4'!$D$25"]
["_138PC","='Parts3-4'!$E$25"]
["_138US","='Parts3-4'!$J$25"]
["_139","='Parts3-4'!$C$23:$I$23"]
["_139P2","='Parts3-4'!$F$23"]
["_139P3","='Parts3-4'!$G$23"]
["_139P4","='Parts3-4'!$H$23"]
["_139P5","='Parts3-4'!$I$23"]
["_139PA","='Parts3-4'!$C$23"]
["_139PB","='Parts3-4'!$D$23"]
["_139PC","='Parts3-4'!$E$23"]
["_139US","='Parts3-4'!$J$23"]
["_141","='Parts3-4'!$C$13:$I$13"]
["_141P2","='Parts3-4'!$F$13"]
["_141P3","='Parts3-4'!$G$13"]
["_141P4","='Parts3-4'!$H$13"]
["_141P5","='Parts3-4'!$I$13"]
["_141PA","='Parts3-4'!$C$13"]
["_141PB","='Parts3-4'!$D$13"]
["_141PC","='Parts3-4'!$E$13"]
["_141US","='Parts3-4'!$J$13"]
["_149","='Parts3-4'!$C$19:$I$19"]
["_149P2","='Parts3-4'!$F$19"]
["_149P3","='Parts3-4'!$G$19"]
["_149P4","='Parts3-4'!$H$19"]
["_149P5","='Parts3-4'!$I$19"]
["_149PA","='Parts3-4'!$C$19"]
["_149PB","='Parts3-4'!$D$19"]
["_149PC","='Parts3-4'!$E$19"]
["_149US","='Parts3-4'!$J$19"]
["_166","='Parts3-4'!$C$18:$I$18"]
["_166P2","='Parts3-4'!$F$18"]
["_166P3","='Parts3-4'!$G$18"]
["_166P4","='Parts3-4'!$H$18"]
["_166P5","='Parts3-4'!$I$18"]
["_166PA","='Parts3-4'!$C$18"]
["_166PB","='Parts3-4'!$D$18"]
["_166PC","='Parts3-4'!$E$18"]
["_166US","='Parts3-4'!$J$18"]
["_213","='Parts3-4'!$C$26:$I$26"]
["_213P2","='Parts3-4'!$F$26"]
["_213P3","='Parts3-4'!$G$26"]
["_213P4","='Parts3-4'!$H$26"]
["_213P5","='Parts3-4'!$I$26"]
["_213PA","='Parts3-4'!$C$26"]
["_213PB","='Parts3-4'!$D$26"]
["_213PC","='Parts3-4'!$E$26"]
["_213US","='Parts3-4'!$J$26"]
["_242","='Parts3-4'!$C$11:$I$11"]
["_242P2","='Parts3-4'!$F$11"]
["_242P3","='Parts3-4'!$G$11"]
["_242P4","='Parts3-4'!$H$11"]
["_242P5","='Parts3-4'!$I$11"]
["_242PA","='Parts3-4'!$C$11"]
["_242PB","='Parts3-4'!$D$11"]
["_242PC","='Parts3-4'!$E$11"]
["_242US","='Parts3-4'!$J$11"]
["_246","='Parts3-4'!$C$12:$I$12"]
["_246P2","='Parts3-4'!$F$12"]
["_246P3","='Parts3-4'!$G$12"]
["_246P4","='Parts3-4'!$H$12"]
["_246P5","='Parts3-4'!$I$12"]
["_246PA","='Parts3-4'!$C$12"]
["_246PB","='Parts3-4'!$D$12"]
["_246PC","='Parts3-4'!$E$12"]
["_246US","='Parts3-4'!$J$12"]
["_311","='Parts3-4'!$C$27:$I$27"]
["_311P2","='Parts3-4'!$F$27"]
["_311P3","='Parts3-4'!$G$27"]
["_311P4","='Parts3-4'!$H$27"]
["_311P5","='Parts3-4'!$I$27"]
["_311PA","='Parts3-4'!$C$27"]
["_311PB","='Parts3-4'!$D$27"]
["_311PC","='Parts3-4'!$E$27"]
["_311US","='Parts3-4'!$J$27"]
["_465","='Parts3-4'!$C$29:$I$29"]
["_465P2","='Parts3-4'!$F$29"]
["_465P3","='Parts3-4'!$G$29"]
["_465P4","='Parts3-4'!$H$29"]
["_465P5","='Parts3-4'!$I$29"]
["_465PA","='Parts3-4'!$C$29"]
["_465PB","='Parts3-4'!$D$29"]
["_465PC","='Parts3-4'!$E$29"]
["_465US","='Parts3-4'!$J$29"]
["_466","='Parts3-4'!$C$30:$I$30"]
["_466DU","='Parts3-4'!$C$35"]
["_466P2","='Parts3-4'!$F$30"]
["_466P3","='Parts3-4'!$G$30"]
["_466P4","='Parts3-4'!$H$30"]
["_466P5","='Parts3-4'!$I$30"]
["_466PA","='Parts3-4'!$C$30"]
["_466PB","='Parts3-4'!$D$30"]
["_466PC","='Parts3-4'!$E$30"]
["_466US","='Parts3-4'!$J$30"]
["_467","='Parts3-4'!$C$31:$I$31"]
["_467P2","='Parts3-4'!$F$31"]
["_467P3","='Parts3-4'!$G$31"]
["_467P4","='Parts3-4'!$H$31"]
["_467P5","='Parts3-4'!$I$31"]
["_467PA","='Parts3-4'!$C$31"]
["_467PB","='Parts3-4'!$D$31"]
["_467PC","='Parts3-4'!$E$31"]
["_467US","='Parts3-4'!$J$31"]
["_P2","='Parts3-4'!$F$11:$F$31"]
["_P3","='Parts3-4'!$G$11:$G$31"]
["_P4","='Parts3-4'!$H$11:$H$31"]
["_P5","='Parts3-4'!$I$11:$I$31"]
["_PA","='Parts3-4'!$C$11:$C$31"]
["_PB","='Parts3-4'!$D$11:$D$31"]
["_PC","='Parts3-4'!$E$11:$E$31"]
["_PCITY","='Parts1-2'!$C$24"]
["_PSTAT","='Parts1-2'!$L$24"]
["_PSTRE","='Parts1-2'!$F$23"]
["_PZIP","='Parts1-2'!$O$24"]
["_PZIP4","='Parts1-2'!$R$24"]
["_US","='Parts3-4'!$J$11:$J$31"]
["_VFORM","='Parts1-2'!$A$7"]
["cext","='Parts1-2'!$R$29"]
["city","='Parts1-2'!$C$27"]
["contnm","='Parts1-2'!$G$28"]
["Day","='Parts1-2'!$O$14"]
["DBA","='Parts1-2'!$H$21"]
["fax","='Parts1-2'!$G$30"]
["ID","='Parts1-2'!$L$16"]
["IdChngChk","='Parts1-2'!$J$19"]
["intnet","='Parts1-2'!$G$31"]
["Month","='Parts1-2'!$L$14"]
["Name1","='Parts1-2'!$H$20"]
["Notes","='Parts1-2'!$A$34"]
["Phone","='Parts1-2'!$G$29"]
["ResubChk","='Parts1-2'!$X$14"]
["state","='Parts1-2'!$L$27"]
["StCodes","='Parts1-2'!$AA$1:$AA$54"]
["Street","='Parts1-2'!$C$26"]
["Version","='Parts1-2'!$Y$6"]
["Year","='Parts1-2'!$R$14"]
["zip","='Parts1-2'!$O$27"]
["zip4","='Parts1-2'!$R$27"]

{"sheet":"Validation","index":1,"n_rows":190,"n_cols":4,"rows_kept":190,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Validation","Error Alert"]
["_117","='Parts 3-4'!$C$25:$I$25","-","-"]
["_117P2","='Parts 3-4'!$F$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117P3","='Parts 3-4'!$G$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117P4","='Parts 3-4'!$H$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117P5","='Parts 3-4'!$I$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117PA","='Parts 3-4'!$C$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117PB","='Parts 3-4'!$D$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117PC","='Parts 3-4'!$E$25","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_117US","='Parts 3-4'!$J$25","=IF(SUM(_117)=0,\"\",SUM(_117))","-"]
["_118","='Parts 3-4'!$C$23:$I$23","-","-"]
["_118P2","='Parts 3-4'!$F$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118P3","='Parts 3-4'!$G$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118P4","='Parts 3-4'!$H$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118P5","='Parts 3-4'!$I$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118PA","='Parts 3-4'!$C$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118PB","='Parts 3-4'!$D$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118PC","='Parts 3-4'!$E$23","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_118US","='Parts 3-4'!$J$23","=IF(SUM(_118)=0,\"\",SUM(_118))","-"]
["_125","='Parts 3-4'!$C$16:$I$16","-","-"]
["_125P2","='Parts 3-4'!$F$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125P3","='Parts 3-4'!$G$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125P4","='Parts 3-4'!$H$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125P5","='Parts 3-4'!$I$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125PA","='Parts 3-4'!$C$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125PB","='Parts 3-4'!$D$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125PC","='Parts 3-4'!$E$16","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_125US","='Parts 3-4'!$J$16","=IF(SUM(_125)=0,\"\",SUM(_125))","-"]
["_127","='Parts 3-4'!$C$17:$I$17","-","-"]
["_127P2","='Parts 3-4'!$F$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127P3","='Parts 3-4'!$G$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127P4","='Parts 3-4'!$H$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127P5","='Parts 3-4'!$I$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127PA","='Parts 3-4'!$C$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127PB","='Parts 3-4'!$D$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127PC","='Parts 3-4'!$E$17","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_127US","='Parts 3-4'!$J$17","=IF(SUM(_127)=0,\"\",SUM(_127))","-"]
["_130","='Parts 3-4'!$C$21:$I$21","-","-"]
["_130P2","='Parts 3-4'!$F$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130P3","='Parts 3-4'!$G$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130P4","='Parts 3-4'!$H$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130P5","='Parts 3-4'!$I$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130PA","='Parts 3-4'!$C$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130PB","='Parts 3-4'!$D$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130PC","='Parts 3-4'!$E$21","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_130US","='Parts 3-4'!$J$21","=IF(SUM(_130)=0,\"\",SUM(_130))","-"]
["_138","='Parts 3-4'!$C$26:$I$26","-","-"]
["_138P2","='Parts 3-4'!$F$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138P3","='Parts 3-4'!$G$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138P4","='Parts 3-4'!$H$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138P5","='Parts 3-4'!$I$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138PA","='Parts 3-4'!$C$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138PB","='Parts 3-4'!$D$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138PC","='Parts 3-4'!$E$26","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_138US","='Parts 3-4'!$J$26","=IF(SUM(_138)=0,\"\",SUM(_138))","-"]
["_139","='Parts 3-4'!$C$24:$I$24","-","-"]
["_139P2","='Parts 3-4'!$F$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139P3","='Parts 3-4'!$G$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139P4","='Parts 3-4'!$H$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139P5","='Parts 3-4'!$I$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139PA","='Parts 3-4'!$C$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139PB","='Parts 3-4'!$D$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139PC","='Parts 3-4'!$E$24","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_139US","='Parts 3-4'!$J$24","=IF(SUM(_139)=0,\"\",SUM(_139))","-"]
["_141","='Parts 3-4'!$C$14:$I$14","-","-"]
["_141P2","='Parts 3-4'!$F$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141P3","='Parts 3-4'!$G$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141P4","='Parts 3-4'!$H$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141P5","='Parts 3-4'!$I$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141PA","='Parts 3-4'!$C$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141PB","='Parts 3-4'!$D$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141PC","='Parts 3-4'!$E$14","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_141US","='Parts 3-4'!$J$14","=IF(SUM(_141)=0,\"\",SUM(_141))","-"]
["_149","='Parts 3-4'!$C$20:$I$20","-","-"]
["_149P2","='Parts 3-4'!$F$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149P3","='Parts 3-4'!$G$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149P4","='Parts 3-4'!$H$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149P5","='Parts 3-4'!$I$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149PA","='Parts 3-4'!$C$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149PB","='Parts 3-4'!$D$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149PC","='Parts 3-4'!$E$20","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_149US","='Parts 3-4'!$J$20","=IF(SUM(_149)=0,\"\",SUM(_149))","-"]
["_166","='Parts 3-4'!$C$19:$I$19","-","-"]
["_166P2","='Parts 3-4'!$F$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166P3","='Parts 3-4'!$G$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166P4","='Parts 3-4'!$H$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166P5","='Parts 3-4'!$I$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166PA","='Parts 3-4'!$C$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166PB","='Parts 3-4'!$D$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166PC","='Parts 3-4'!$E$19","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_166US","='Parts 3-4'!$J$19","=IF(SUM(_166)=0,\"\",SUM(_166))","-"]
["_213","='Parts 3-4'!$C$27:$I$27","-","-"]
["_213P2","='Parts 3-4'!$F$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213P3","='Parts 3-4'!$G$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213P4","='Parts 3-4'!$H$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213P5","='Parts 3-4'!$I$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213PA","='Parts 3-4'!$C$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213PB","='Parts 3-4'!$D$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213PC","='Parts 3-4'!$E$27","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_213US","='Parts 3-4'!$J$27","=IF(SUM(_213)=0,\"\",SUM(_213))","-"]
["_242","='Parts 3-4'!$C$12:$I$12","-","-"]
["_242P2","='Parts 3-4'!$F$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242P3","='Parts 3-4'!$G$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242P4","='Parts 3-4'!$H$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242P5","='Parts 3-4'!$I$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242PA","='Parts 3-4'!$C$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242PB","='Parts 3-4'!$D$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242PC","='Parts 3-4'!$E$12","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_242US","='Parts 3-4'!$J$12","=IF(SUM(_242)=0,\"\",SUM(_242))","-"]
["_246","='Parts 3-4'!$C$13:$I$13","-","-"]
["_246P2","='Parts 3-4'!$F$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246P3","='Parts 3-4'!$G$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246P4","='Parts 3-4'!$H$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246P5","='Parts 3-4'!$I$13","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_246PA","='Parts 3-4'!$C$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246PB","='Parts 3-4'!$D$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246PC","='Parts 3-4'!$E$13","Whole number: 0 - 10,000,000","Value must be a whole number between 0 and 10,000,000."]
["_246US","='Parts 3-4'!$J$13","=IF(SUM(_246)=0,\"\",SUM(_246))","-"]
["_311","='Parts 3-4'!$C$28:$I$28","-","-"]
["_311P2","='Parts 3-4'!$F$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311P3","='Parts 3-4'!$G$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311P4","='Parts 3-4'!$H$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311P5","='Parts 3-4'!$I$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311PA","='Parts 3-4'!$C$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311PB","='Parts 3-4'!$D$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311PC","='Parts 3-4'!$E$28","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_311US","='Parts 3-4'!$J$28","=IF(SUM(_311)=0,\"\",SUM(_311))","-"]
["_465","='Parts 3-4'!$C$30:$I$30","-","-"]
["_465P2","='Parts 3-4'!$F$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465P3","='Parts 3-4'!$G$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465P4","='Parts 3-4'!$H$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465P5","='Parts 3-4'!$I$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465PA","='Parts 3-4'!$C$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465PB","='Parts 3-4'!$D$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465PC","='Parts 3-4'!$E$30","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_465US","='Parts 3-4'!$J$30","=IF(SUM(_465)=0,\"\",SUM(_465))","-"]
["_466","='Parts 3-4'!$C$31:$I$31","-","-"]
["_466DU","='Parts3-4'!$C$34","Whole number: -100,000 and 100,000","Value must be a whole number between -100,000 and 100,000."]
["_466P2","='Parts 3-4'!$F$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466P3","='Parts 3-4'!$G$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466P4","='Parts 3-4'!$H$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466P5","='Parts 3-4'!$I$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466PA","='Parts 3-4'!$C$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466PB","='Parts 3-4'!$D$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466PC","='Parts 3-4'!$E$31","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_466US","='Parts 3-4'!$C$35","=IF(SUM(_466)=0,\"\",SUM(_466))","-"]
["_467","='Parts 3-4'!$C$32:$I$32","-","-"]
["_467P2","='Parts 3-4'!$F$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467P3","='Parts 3-4'!$G$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467P4","='Parts 3-4'!$H$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467P5","='Parts 3-4'!$I$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467PA","='Parts 3-4'!$C$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467PB","='Parts 3-4'!$D$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467PC","='Parts 3-4'!$E$32","Whole number: 0 - 1,000,000","Value must be a whole number between 0 and 1,000,000."]
["_467US","='Parts 3-4'!$J$32","=IF(SUM(_467)=0,\"\",SUM(_467))","-"]
["_P2","='Parts 3-4'!$F$12:$F$32","-","-"]
["_P3","='Parts 3-4'!$G$12:$G$32","-","-"]
["_P4","='Parts 3-4'!$H$12:$H$32","-","-"]
["_P5","='Parts 3-4'!$I$12:$I$32","-","-"]
["_PA","='Parts 3-4'!$C$12:$C$32","-","-"]
["_PB","='Parts 3-4'!$D$12:$D$32","-","-"]
["_PC","='Parts 3-4'!$E$12:$E$32","-","-"]
["_PCITY","='Parts1-2'!$C$24","-","-"]
["_PSTAT","='Parts1-2'!$L$24","=STCodes List","Value must be a valid State Code from the drop down"]
["_PSTRE","='Parts1-2'!$F$23","-","-"]
["_PZIP","='Parts1-2'!$O$24","AND(LEN(_PZIP)=5,ISNUMBER(VALUE(_PZIP)))","Enter a valid 5 digit zip code."]
["_PZIP4","='Parts 1-2'!$R$24","AND(LEN(_PZIP4)=4,ISNUMBER(VALUE(_PZIP4)))","Enter a valid zip code extention."]
["_US","='Parts 3-4'!$J$12:$J$32","-","-"]
["_VFORM","='Parts 1-2'!$A$7","-","-"]
["cext","='Parts 1-2'!$R$29","-","-"]
["city","='Parts 1-2'!$C$27","-","-"]
["contnm","='Parts 1-2'!$G$28","-","-"]
["Day","='Parts 1-2'!$O$14","Whole number: 1-31","Enter a valid day value; 1 - 31."]
["DBA","='Parts 1-2'!$H$21","-","-"]
["fax","='Parts 1-2'!$G$30","AND(LEN(fax)=10,ISNUMBER(fax))","Enter a valid 10 digit telephone number."]
["ID","='Parts 1-2'!$L$16","Length = 10","Enter a valid ten-digit EIA ID."]
["IdChngChk","='Parts 1-2'!$J$19","AND(LEN(IDChngChk)=1,IDChngChk=\"X\")","Enter an \"X\" if any Respondent Identification Data has changed."]
["intnet","='Parts 1-2'!$G$31","-","-"]
["Month","='Parts 1-2'!$L$14","Whole number: 1-12","Enter a valid month value; 1 - 12."]
["Name1","='Parts 1-2'!$H$20","-","-"]
["Notes","='Parts 1-2'!$A$35","-","-"]
["Phone","='Parts 1-2'!$G$29","AND(LEN(phone)=10,ISNUMBER(phone))","Enter a valid 10 digit telephone number."]
["ResubChk","='Parts 1-2'!$X$14","AND(LEN(ResubChk)=1,OR(ResubChk=\"X\",ResubChk=\" \"))","Enter \"X\" if this is a resubmission."]
["state","='Parts 1-2'!$L$27","=STCodes List","Value must be a valid State Code from the drop down"]
["StCodes","='Parts 1-2'!$AA$1:$AA$54","-","-"]
["Street","='Parts1-2'!$C$26","-","-"]
["Version","='Parts 1-2'!$Y$6","-","-"]
["Year","='Parts 1-2'!$R$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","='Parts 1-2'!$O$27","AND(LEN(zip)=5,ISNUMBER(VALUE(zip)))","Enter a valid 5 digit zip code."]
["zip4","='Parts 1-2'!$R$27","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":[[15,11,15,17],[16,19,17,24],[12,0,12,10],[13,7,13,10],[15,7,15,10],[32,0,32,24],[13,11,13,12],[13,14,13,15],[23,2,23,8],[23,14,23,15],[33,0,53,24],[26,19,27,24],[27,6,27,17],[28,6,28,13],[30,6,30,17],[19,7,19,17],[19,19,19,24],[20,7,20,17],[22,5,22,17],[29,6,29,13],[24,0,24,18],[25,2,25,17],[26,2,26,8],[26,14,26,15],[7,0,7,24],[6,0,6,24],[8,0,10,24],[11,0,11,18],[12,11,12,12],[12,14,12,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-802",{"$nulls":25},"CN","Canada"]
["WEEKLY PRODUCT PIPELINE 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. 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},"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 "]
["Please complete all date fields.",{"$nulls":10},"Mo",null,null,"Day",null,null,"Year",{"$nulls":8},"GA","Georgia "]
["REPORT PERIOD:",{"$nulls":6},false,{"$nulls":11},"If this is a resubmission, enter an \"X\" in the box:",{"$nulls":6},"HI","Hawaii "]
[{"$nulls":26},"ID","Idaho "]
["EIA ID NUMBER:",{"$nulls":6},2,{"$nulls":18},"IL","Illinois "]
[{"$nulls":19},"A completed form must be received by 5 p.m. Eastern Time\non the Monday following the end of the report period.",{"$nulls":6},"IN","Indiana "]
["If any Respondent Identification Data has changed since the last report, ",{"$nulls":25},"IA","Iowa "]
[null,"enter an \"X\" in the box:",{"$nulls":24},"KS","Kansas "]
["Company Name:",{"$nulls":18},"Forms may be submitted using one of the following\nmethods:",{"$nulls":6},"KY","Kentucky "]
["Doing Business As:",{"$nulls":25},"LA","Louisiana "]
["Physical Address of Contact (e.g., Street Address, Building Number, ",{"$nulls":18},"Email:",{"$nulls":6},"ME","Maine "]
["Floor, Suite):",{"$nulls":18},"Fax:","(202) 586-1076",{"$nulls":5},"MD","Maryland "]
[null,"City:",{"$nulls":8},"State:",null,null,"Zip:",null,null,"-",null,null,"Secure File Transfer:",{"$nulls":6},"MA","Massachusetts "]
["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},"MI","Michigan "]
[{"$nulls":19},"Electronic Transmission:",{"$nulls":6},"MN","Minnesota "]
[null,"City:",{"$nulls":8},"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},"MS","Mississippi "]
["Contact Name:",{"$nulls":25},"MO","Missouri "]
["Phone No.:",{"$nulls":14},"Ext:",{"$nulls":10},"MT","Montana "]
["Fax No.:",{"$nulls":25},"NE","Nebraska "]
["Email address:",{"$nulls":18},"Questions?",null,"Call:   202-586-3307",{"$nulls":4},"NV","Nevada "]
[{"$nulls":26},"NH","New Hampshire "]
["Comments: Identify any unusual aspects of your reporting week's operations. (To separate one comment from another, press ALT+ENTER.)",{"$nulls":25},"NJ","New Jersey "]
[{"$nulls":26},"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":"Part3","index":3,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,0,3,9],[4,0,4,9],[6,0,6,9],[7,0,7,9],[8,8,9,8],[8,7,9,7],[31,0,31,9],[8,6,9,6],[8,5,9,5],[8,0,9,0],[8,1,9,1],[8,2,8,4],[8,9,9,9]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"OMB No. 1905-0165"]
[{"$nulls":9},"Expiration Date: x/x/xxxx"]
[{"$nulls":9},"Version No.:xxxx.xx"]
["FORM EIA-802"]
["WEEKLY PRODUCT PIPELINE REPORT"]
["REPORTING PERIOD:     Month:        Day:       Year:  ",null,null,null,"EIA ID NUMBER:   ",{"$nulls":4},"RESUBMISSION:   "]
["Quantities entered below should be the weekly equivalent of those reported monthly to the Energy Information Administration by your\ncompany on Form EIA-812, \"Monthly Product Pipeline Report.\" "]
["PART 3.  PRODUCT PIPELINE STOCKS (Thousand Barrels)"]
["Item Description","Product Code","PADD 1",null,null,"PADD 2","PADD 3","PADD 4","PADD 5","U.S."]
[null,null,"A","B","C"]
["Natural Gas Plant Liquids (NGPL) and Liquefied Refinery Gases (LRG)*:",242,{"$nulls":7},""]
["Propane/Propylene",246,{"$nulls":7},""]
["Fuel Ethanol",141,{"$nulls":7},""]
["Finished Motor Gasoline:"]
["Reformulated, Blended with Fuel Ethanol",125,{"$nulls":7},""]
["Reformulated, Other",127,{"$nulls":7},""]
["Conventional, Blended with Fuel Ethanol:"]
["Ed55 and Lower",166,{"$nulls":7},""]
["Greater than Ed55",149,{"$nulls":7},""]
["Conventional, Other",130,{"$nulls":7},""]
["Motor Gasoline Blending Components:"]
["Reformulated Blendstock for Oxygenate Blending (RBOB)",118,{"$nulls":7},""]
["Conventional Blendstock for Oxygenate Blending (CBOB)",139,{"$nulls":7},""]
["Gasoline Treated as Blendstock (GTAB)",117,{"$nulls":7},""]
["All Other Motor Gasoline Blending Components",138,{"$nulls":7},""]
["Kerosene-Type Jet Fuel",213,{"$nulls":7},""]
["Kerosene",311,{"$nulls":7},""]
["Distillate Fuel Oil:"]
["15 ppm sulfur and under",465,{"$nulls":7},""]
["Greater than 15 ppm to 500 ppm sulfur (incl.)",466,{"$nulls":7},""]
["Greater than 500 ppm sulfur",467,{"$nulls":7},""]
["* Includes ethane/ethylene, propane/propylene, normal butane/butylene, isobutane/isobutylene, and pentanes plus as found on Form EIA-812 as product codes 108, 246, 244, 245 and 220."]