{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Min_Tests","Variability","QA_Calcs","UPL Normal","UPL Pooled Template ","Lognormal Template","lognormal distribution 99 %","10373","ETTS_Other","10373_1a_ERT_Data","Promulgated Min Data"],"not_rendered":{"charts":1,"images":31,"macros":1,"external_links":0,"defined_names":32,"comments":2,"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":"Min_Tests","index":0,"n_rows":11,"n_cols":60,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Rank","primary_fuel","ORIS code","Plant Name","Unit Number","boiler_id","Unit Type","boiler_type","MWe_capacity","max_heat_input","Unit_heat_rate","Fuel types","fuel","Sulfur Dioxide - CEMS","Sulfur Dioxide MW - CEMS","Sulfur Dioxide - ERT","Sulfur Dioxide MW - ERT","Sulfur Dioxide - ETTS","Sulfur Dioxide MW - ETTS","Sulfur Dioxide - Part II","Sulfur Dioxide MW - Part II","Sulfur Dioxide - min","Sulfur Dioxide lb/MWh - min","control_group_1","control_type_1","install_date_1","control_group_2","control_type_2","install_date_2","control_group_3","control_type_3","install_date_3","control_group_4","control_type_4","install_date_4","control_group_5","control_type_5","install_date_5","control_group_6","control_type_6","install_date_6","control_group_7","control_type_7","install_date_7","control_group_8","control_type_8","install_date_8","control_group_9","control_type_9","install_date_9","control_group_10","control_type_10","install_date_10","control_group_11","control_type_11","install_date_11","control_group_12","control_type_12","install_date_12"]
[{"$f":"D2&\"_\"&G2","v":"10373_CB1302"},1,"petroleum coke",10373,"Hanford","1A","CB1302","Fluidized bed firing","Fluidized bed firing",27.06,290,10.716925351071692,"petroleum coke","petroleum coke",5.8933333333333331E-2,0.63158413402315838,null,null,{"$f":"T2/L2","v":5.7643065467499997E-2},{"$f":"Variability!I7","v":0.61775642962213595},2.295556589420554E-2,0.24601308607980807,{"$f":"Variability!G2","v":2.295556589420554E-2},0.24601308607980807,"PM control","Fabric Filter, pulse","1991-08-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["50931_BLR1",2,"petroleum coke",50931,"Yellowstone Energy LP","Config1","BLR1","Fluidized bed firing","Fluidized bed firing",30,518,17.266666666666666,"petroleum coke","petroleum coke",null,null,null,null,2.9299999999999996E-2,0.50591333333333321,0.39234199070264647,6.7744383727990289,2.9299999999999996E-2,0.50591333333333321,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["50931_BLR2",3,"petroleum coke",50931,"Yellowstone Energy LP","Config1","BLR2","Fluidized bed firing","Fluidized bed firing",30,518,17.266666666666666,"petroleum coke","petroleum coke",null,null,null,null,2.9299999999999996E-2,0.50591333333333321,0.39234199070264647,6.7744383727990289,2.9299999999999996E-2,0.50591333333333321,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["667_1A",4,"petroleum coke",667,"Northside Generating Station","1A","1A","Fluidized bed firing","Fluidized bed firing",310,2764,8.9161290322580644,"petroleum coke,  bituminous","petroleum coke,  bituminous",0.15213333333333329,1.3564404301075264,0.15143911649186662,1.350250703172643,null,null,null,null,0.15143911649186662,1.350250703172643,"NOx control","Selective Noncatalytic Reduction","2002-05-01","SO2 control","Dry FGD - Spray Dryer","2002-05-01","PM control","Fabric Filter, pulse","2002-05-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["667_2A",5,"petroleum coke",667,"Northside Generating Station","2A","2A","Fluidized bed firing","Fluidized bed firing",310,2764,8.9161290322580644,"petroleum coke,  bituminous","petroleum coke,  bituminous",0.1724,1.5371406451612903,0.17129887129394852,1.527322839537012,null,null,null,null,0.17129887129394852,1.527322839537012,"NOx control","Selective Noncatalytic Reduction","2002-02-01","SO2 control","Dry FGD - Spray Dryer","2002-02-01","PM control","Fabric Filter, pulse","2002-02-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["2878_1",6,"petroleum coke",2878,"Bay Shore","Unit 1","1","Fluidized bed firing","Fluidized bed firing",151,1218,8.0662251655629138,"petroleum coke","petroleum coke",null,null,0.37722146674132168,3.0427532880194028,null,null,null,null,0.37722146674132168,3.0427532880194028,"PM control","Fabric Filter, unspecified","2000-12-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["4125_9",7,"petroleum coke",4125,"Manitowoc","B-09","9","Fluidized bed firing","Fluidized bed firing",63.37,1244,19.630740097838096,"petroleum coke,  subbituminous,  other--wood charcoal/paper pellets","petroleum coke,  subbituminous,  other--wood charcoal/paper pellets",null,null,0.27242932742659298,5.3479893217402825,null,null,null,null,0.27242932742659298,5.3479893217402825,"NOx control","Selective Noncatalytic Reduction",null,"PM control","Fabric Filter, pulse",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["10670_AAB001",8,"petroleum coke",10670,"AES Deepwater","Deepwater","AAB001","Conventional Boiler","Arch firing",158,1817.6,11.50379746835443,"petroleum coke","petroleum coke",0.60478260869565215,6.9572966428178304,null,null,null,null,null,null,0.60478260869565215,6.9572966428178304,"NOx control","Selective Catalytic Reduction","2007-03-01","PM control","Electrostatic precipitator, cold side, w/o flue gas conditioning","1985-08-01","SO2 control","Wet FGD - Spray Type","1985-08-01","Other control","Wet electrostatic precipitator","1985-08-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["6190_3-1",9,"petroleum coke",6190,"Rodemacher","003-1","3-1","Fluidized bed firing","Fluidized bed firing",351.9,2807.9,7.9792554703040643,"petroleum coke","petroleum coke",null,null,null,null,null,null,null,null,null,"No ICR Data","NOx control","Selective Noncatalytic Reduction",null,"PM control","Single cyclone",null,"SO2 control","Dry FGD - Circulating Dry Scrubber",null,"PM control","Fabric Filter, pulse",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["6190_3-2",10,"petroleum coke",6190,"Rodemacher","003-2","3-2","Fluidized bed firing","Fluidized bed firing",351.9,2807.9,7.9792554703040643,"petroleum coke","petroleum coke",null,null,null,null,null,null,null,null,null,"No ICR Data","NOx control","Selective Noncatalytic Reduction",null,"PM control","Single cyclone",null,"SO2 control","Dry FGD - Circulating Dry Scrubber",null,"PM control","Fabric Filter, pulse",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]

{"sheet":"Variability","index":1,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Key f_b","Facility Name","facility_id","boiler_id","configuration_id","compound","Final_EF","Final_EF_Units","Final_Output_EF","Final_Output_EF_Units","From","BDL","Report_id","Rank"]
[{"$f":"C2&\"_\"&D2","v":"10373_CB1302"},{"$f":"VLOOKUP(A2,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",2.295556589420554E-2,"lb/MMBtu",0.26779590266733283,"lb/MW","Part II","No","2007 Emission Compliance and RATA Report\\07015.4c",{"$f":"+VLOOKUP(C2&\"_\"&D2,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A3,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",2.7375369458128081E-2,"lb/MMBtu",0.28810722335831401,"lb/MW","Part II","No","2006 Emission Compliance and RATA Report\\06015.4c",{"$f":"+VLOOKUP(C3&\"_\"&D3,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A4,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",3.1932527713163433E-2,"lb/MMBtu",0.3019434585941167,"lb/MW","Part II","No","2008 Emission Compliance and RATA Report\\08015.4c",{"$f":"+VLOOKUP(C4&\"_\"&D4,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A5,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",3.3980920009309426E-2,"lb/MMBtu",0.36485402570074643,"lb/MW","Part II","No","2005 Emission Compliance and RATA Report\\05015.4c",{"$f":"+VLOOKUP(C5&\"_\"&D5,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A6,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",5.7643065467499997E-2,"lb/MMBtu",0.55617576120270706,"lb/MW","ETTS","No","",{"$f":"+VLOOKUP(C6&\"_\"&D6,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A7,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",5.8314131255711318E-2,"lb/MMBtu",0.61775642962213595,"lb/MW","Part II","No","2009 Emission Compliance and RATA Report\\09015.4c",{"$f":"+VLOOKUP(C7&\"_\"&D7,Min_Tests!A:B,2,FALSE)","v":1}]
["10373_CB1302",{"$f":"VLOOKUP(A8,Min_Tests!A:E,5,FALSE)","v":"Hanford"},10373,"CB1302","1A","Sulfur Dioxide",5.8933333333333331E-2,"lb/MMBtu",0.63158413402315838,"lb/MW","CEMS","No","",{"$f":"+VLOOKUP(C8&\"_\"&D8,Min_Tests!A:B,2,FALSE)","v":1},null,null,null,null,null,null,"emission_value_lb/MMBtu"]
["50931_BLR1",{"$f":"VLOOKUP(A9,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",2.9299999999999996E-2,"lb/MMBtu",0.50591333333333321,"lb/MW","ETTS","No","",{"$f":"+VLOOKUP(C9&\"_\"&D9,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,5.8999999999999997E-2,{"$f":"U9*10.72","v":0.63248000000000004}]
["50931_BLR1",{"$f":"VLOOKUP(A10,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",0.39234199070264647,"lb/MMBtu",6.7744383727990289,"lb/MW","Part II","No","3/24/08 to 3/26/08 Testing",{"$f":"+VLOOKUP(C10&\"_\"&D10,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,0.06,{"$f":"U10*10.72","v":0.64319999999999999}]
["50931_BLR1",{"$f":"VLOOKUP(A11,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",0.39388384215970418,"lb/MMBtu",6.8010610079575589,"lb/MW","Part II","No","2/5/07 to 2/7/07 Emission Testing",{"$f":"+VLOOKUP(C11&\"_\"&D11,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["50931_BLR1",{"$f":"VLOOKUP(A12,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",0.45464347326049448,"lb/MMBtu",7.8501773049645376,"lb/MW","Part II","No","3/16/09 to 3/18/09 testing",{"$f":"+VLOOKUP(C12&\"_\"&D12,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,6.0999999999999999E-2,0.65392000000000006]
["50931_BLR1",{"$f":"VLOOKUP(A13,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",0.46053369778953396,"lb/MMBtu",7.9518818484992861,"lb/MW","Part II","No","2/15/05 to 2/17/05 testing",{"$f":"+VLOOKUP(C13&\"_\"&D13,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,0.06,0.64319999999999999]
["50931_BLR1",{"$f":"VLOOKUP(A14,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR1","Config1","Sulfur Dioxide",0.49981839277032436,"lb/MMBtu",8.6301975818342669,"lb/MW","Part II","No","2/15/06 to 2/16/06 Emission Testing.",{"$f":"+VLOOKUP(C14&\"_\"&D14,Min_Tests!A:B,2,FALSE)","v":2},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["50931_BLR2",{"$f":"VLOOKUP(A15,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",2.9299999999999996E-2,"lb/MMBtu",0.50591333333333321,"lb/MW","ETTS","No","",{"$f":"+VLOOKUP(C15&\"_\"&D15,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["50931_BLR2",{"$f":"VLOOKUP(A16,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",0.39234199070264647,"lb/MMBtu",6.7744383727990289,"lb/MW","Part II","No","3/24/08 to 3/26/08 Testing",{"$f":"+VLOOKUP(C16&\"_\"&D16,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,0.06,0.64319999999999999]
["50931_BLR2",{"$f":"VLOOKUP(A17,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",0.39388384215970418,"lb/MMBtu",6.8010610079575589,"lb/MW","Part II","No","2/5/07 to 2/7/07 Emission Testing",{"$f":"+VLOOKUP(C17&\"_\"&D17,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,0.06,0.64319999999999999]
["50931_BLR2",{"$f":"VLOOKUP(A18,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",0.45464347326049448,"lb/MMBtu",7.8501773049645376,"lb/MW","Part II","No","3/16/09 to 3/18/09 testing",{"$f":"+VLOOKUP(C18&\"_\"&D18,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["50931_BLR2",{"$f":"VLOOKUP(A19,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",0.46053369778953396,"lb/MMBtu",7.9518818484992861,"lb/MW","Part II","No","2/15/05 to 2/17/05 testing",{"$f":"+VLOOKUP(C19&\"_\"&D19,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["50931_BLR2",{"$f":"VLOOKUP(A20,Min_Tests!A:E,5,FALSE)","v":"Yellowstone Energy LP"},50931,"BLR2","Config1","Sulfur Dioxide",0.49981839277032436,"lb/MMBtu",8.6301975818342669,"lb/MW","Part II","No","2/15/06 to 2/16/06 Emission Testing.",{"$f":"+VLOOKUP(C20&\"_\"&D20,Min_Tests!A:B,2,FALSE)","v":3},null,null,null,null,null,null,0.06,0.64319999999999999]
["667_1A",{"$f":"VLOOKUP(A21,Min_Tests!A:E,5,FALSE)","v":"Northside Generating Station"},667,"1A","1A","Sulfur Dioxide",0.15143911649186662,"lb/MMBtu",1.350250703172643,"lb/MW","ERT","No","",{"$f":"+VLOOKUP(C21&\"_\"&D21,Min_Tests!A:B,2,FALSE)","v":4},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["667_1A",{"$f":"VLOOKUP(A22,Min_Tests!A:E,5,FALSE)","v":"Northside Generating Station"},667,"1A","1A","Sulfur Dioxide",0.15213333333333329,"lb/MMBtu",1.3564404301075264,"lb/MW","CEMS","No","",{"$f":"+VLOOKUP(C22&\"_\"&D22,Min_Tests!A:B,2,FALSE)","v":4},null,null,null,null,null,null,0.06,0.64319999999999999]
["667_2A",{"$f":"VLOOKUP(A23,Min_Tests!A:E,5,FALSE)","v":"Northside Generating Station"},667,"2A","2A","Sulfur Dioxide",0.17129887129394852,"lb/MMBtu",1.527322839537012,"lb/MW","ERT","No","",{"$f":"+VLOOKUP(C23&\"_\"&D23,Min_Tests!A:B,2,FALSE)","v":5},null,null,null,null,null,null,5.8000000000000003E-2,0.62176000000000009]
["667_2A",{"$f":"VLOOKUP(A24,Min_Tests!A:E,5,FALSE)","v":"Northside Generating Station"},667,"2A","2A","Sulfur Dioxide",0.1724,"lb/MMBtu",1.5371406451612903,"lb/MW","CEMS","No","",{"$f":"+VLOOKUP(C24&\"_\"&D24,Min_Tests!A:B,2,FALSE)","v":5},null,null,null,null,null,null,5.6000000000000001E-2,0.60032000000000008]
["2878_1",{"$f":"VLOOKUP(A25,Min_Tests!A:E,5,FALSE)","v":"Bay Shore"},2878,"1","Unit 1","Sulfur Dioxide",0.37722146674132168,"lb/MMBtu",3.0427532880194028,"lb/MW","ERT","No","",{"$f":"+VLOOKUP(C25&\"_\"&D25,Min_Tests!A:B,2,FALSE)","v":6},null,null,null,null,null,null,0.06,0.64319999999999999]
["4125_9",{"$f":"VLOOKUP(A26,Min_Tests!A:E,5,FALSE)","v":"Manitowoc"},4125,"9","B-09","Sulfur Dioxide",0.27242932742659298,"lb/MMBtu",5.3479893217402825,"lb/MW","ERT","No","",{"$f":"+VLOOKUP(C26&\"_\"&D26,Min_Tests!A:B,2,FALSE)","v":7},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
["10670_AAB001",{"$f":"VLOOKUP(A27,Min_Tests!A:E,5,FALSE)","v":"AES Deepwater"},10670,"AAB001","Deepwater","Sulfur Dioxide",0.60478260869565215,"lb/MMBtu",6.9572966428178304,"lb/MW","CEMS","No","",{"$f":"+VLOOKUP(C27&\"_\"&D27,Min_Tests!A:B,2,FALSE)","v":8},null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,0.64319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,0.64319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,0.64319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.7000000000000002E-2,0.61104000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,0.64319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5E-2,0.58960000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,0.64319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8999999999999997E-2,0.63248000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8000000000000003E-2,0.62176000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3999999999999999E-2,0.57888000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(U9:U38)","v":5.8933333333333331E-2},0.63176533333333329]

{"sheet":"QA_Calcs","index":2,"n_rows":217,"n_cols":115,"rows_kept":217,"cut":false,"hidden":false,"merged":[[26,84,26,87],[26,88,26,91],[8,0,8,4],[8,6,8,18],[8,20,8,26],[8,28,8,36],[8,38,8,45],[26,80,26,83]]}
[null,null,null,null,null,null,null,null,"Anthracite",null,"Anthracite",null,null,"fPM","30B",null,"μg/dscm","No",null,"μg/dscm",{"$f":"1/453592370","v":2.2046226218487758E-9},"lbs/μg",2.8316846592000001E-2,null,null,null,"cm/cf",null,null,null,null,null,"lb/hr",null,null,"lb/MMBtu",null,null,null,null,null,null,null,"Round to",null,null,null,"From ",null,"original database export===>"]
[null,null,null,null,null,null,null,null,"Bituminous",null,"Bituminous",null,null,"Se","M5",null,"lb/dscf","Yes",null,"ppm",{"$f":"U1/1000","v":2.2046226218487757E-12},"lb/mg",null,null,null,null,null,null,null,null,null,null,null,null,null,"lb/MWh",null,null,null,null,null,null,null,"Same ",null,null,null,"Min ",null,"original database export===>"]
[null,null,null,null,null,null,null,null,"Lignite",null,"Lignite",null,null,"Pb","M5B",null,"ppm",null,null,null,null,"lb/scf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sig Figs ",null,null,null,"Test",null,"original database export===>"]
[null,null,null,null,null,null,null,null,"Oil",null,"Oil",null,null,"Hg","M29",null,"ppm @ 3% O2",null,null,null,null,"(lb/scf)/(ppm SO2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"as Submitted",null,null,null,"Sheet",null,"original database export===>"]
[null,null,null,null,null,null,null,null,"Pet Coke",null,"Pet Coke",null,null,"HCl","OTM27",null,"ppm @ 7% O2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prior to ",null,null,null,null,null,"original database export===>"]
[null,null,null,null,null,null,null,null,"Subbituminous",null,"Sub Bituminous",null,null,"SO2","26A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calc % Diff.",null,null,null,null,null,"original database export===>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M6C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"original database export===>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCAQMD 6.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"original database export===>"]
["RTI",null,null,null,null,null,"As Submitted",null,null,null,null,null,null,null,null,null,null,null,null,null,"RTI-QA",null,null,null,null,null,null,null,"As Submitted",null,null,null,null,null,null,null,null,null,"RTI-QA",null,null,null,null,null,null,null,"Final for UPL",null,"Final for UPL","original database export===>"]
["Comments",null,"Use Run in UPL Calc?","Grade","Key","Facility_Name","Facility_ID","Boiler_ID","Fuel1 Used","Fuel1 Fraction","Fuel2 Used","Fuel2 Fraction","\"Fuel Used/Fraction\" Data Source","Pollutant","Reference Method","Concentration","Concentration UOM","Non-Detect?","MDL","MDL UOM","HAP Conversion Value to lbs","HAP Conversion UOM","Volume Conversion Value to cubic feet","Reserve","Reserve","Reserve","Volume Conversion UOM","Submitted F Factor","Bws (percent)","%O2d","%CO2d","Emission Rate Value","Emission Rate UOM","Emission Rate MDL","Emission Factor Value","Emission Factor UOM","MWg During Test",null,"Fd","Fw","Fc","Calculated conc lb/dscf","19-1\nlb/MMBtu","%diff\n19-1","19-6 (CO2)\nlb/MMBtu","%diff\n19-6","lb/MMBtu Value Used for UPL Calcs","Unit Heat Rate (MMBtu/MWh)","lb/MWh Value Used in UPL Calcs","original database export===>","Key","RTI Calculated QA\nlb/MMBtu","Run Grade","Submitted Value","Submitted Value UOM","Use ?","Comment","facility_id","configuration_id","report_id","sampling_port_id","order","pollutant_id","pollutant_name","run_id","start_datetime","end_datetime","unit_load","fuel_flow_rate","fuel_heating_value","fg_moisture_content","fg_oxygen_content","fg_CO2_content","fg_temperature","test_method","conc","conc_units","conc_ND","conc_MDL","conc2","conc2_units","emission_rate","emission_rate_units","emission_rate_ND","emission_rate_MDL","Calculated lb/MWh at Prom","Boiler Heat Rate (lb/MMBtu)/MWh","Calculated lb/MMBtu at Prom","Calculated conc lb/dscf","19-1\nlb/MMBtu","%diff","19-6\nlb/MMBtu","%diff","emission_factor","emission_factor_units","emission_factor_ND","emission_factor_MDL","run_pollutant_comment","Fuel1","Fuel1%Btu","Fuel2","Fuel2%Btu","QA Comment",null,null,null,null,null,null,null,null,null,null,null,"average of runs"]
[null,null,"Yes","A","5_SO2_T2_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.1",{"$f":"BX11","v":17.68},"ppm @ 3% O2","No",null,null,{"$f":"$D$87","v":1.66E-7},"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,{"$f":"BS11","v":0},{"$f":"BT11","v":4.58},{"$f":"BU11","v":14.6},{"$f":"CD11","v":9.91},"lb/hr",null,{"$f":"AF11/AK11","v":0.35905797101449272},"lb/MWh",{"$f":"BP11","v":27.6},null,{"$f":"VLOOKUP(I11,$A$88:$E$104,3,FALSE)","v":9830},null,{"$f":"VLOOKUP(I11,$A$87:$E$104,5,FALSE)","v":1850},{"$f":"P11*U11","v":2.9348799999999999E-6},{"$f":"IF(AD11<>\"\",AP11*AB11*20.9/(20.9-3),\"no O2 data for run\")","v":3.3733018840670391E-2},{"$f":"(AW11-$AI11)/$AI11","v":6.8408835496028345E-3},null,null,{"$f":"AQ11","v":3.3733018840670391E-2},10.716925351071692,{"$f":"AU11*AV11","v":0.36151424478175953},"original database export===>","5_SO2_T2_R1",3.378784698994413E-2,"A",9.91,"pound per hour (lb/hr)","Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2005-12-08T17:33:00","2005-12-08T18:33:00",27.6,20892,13664,null,4.58,14.6,295.39999999999998,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.68,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",9.91,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW11:AW13)","v":0.36485402570074643}]
[null,null,"Yes","A","5_SO2_T2_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.2",{"$f":"BX12","v":18},"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,{"$f":"BS12","v":0},4.57,14.72,{"$f":"CD12","v":10.130000000000001},"lb/hr",null,{"$f":"AF12/AK12","v":0.36702898550724639},"lb/MWh",{"$f":"BP12","v":27.6},null,{"$f":"VLOOKUP(I12,$A$88:$E$104,3,FALSE)","v":9830},null,{"$f":"VLOOKUP(I12,$A$87:$E$104,5,FALSE)","v":1850},2.988E-6,{"$f":"IF(AD12<>\"\",AP12*AB12*20.9/(20.9-3),\"no O2 data for run\")","v":3.4343571217877102E-2},{"$f":"(AW12-$AI12)/$AI12","v":2.8022405983424165E-3},null,null,{"$f":"AQ12","v":3.4343571217877102E-2},10.716925351071692,{"$f":"AU12*AV12","v":0.36805748903120322},"original database export===>","5_SO2_T2_R2",3.4399391731843573E-2,"A",10.130000000000001,"pound per hour (lb/hr)","Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2005-12-08T18:52:00","2005-12-08T19:52:00",27.6,20832,13664,null,4.57,14.72,295.5,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",18,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.130000000000001,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","A","5_SO2_T2_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.3",17.850000000000001,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,0,4.41,14.78,10.15,"lb/hr",null,0.36642599277978344,"lb/MWh",27.7,null,9830,null,1850,2.9631000000000005E-6,3.4057374791061461E-2,-3.9179793977380311E-3,null,null,3.4057374791061461E-2,10.716925351071692,0.36499034328927654,"original database export===>","5_SO2_T2_R3",3.4112730134078222E-2,"A",10.15,"pound per hour (lb/hr)","Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2005-12-08T20:09:00","2005-12-08T21:09:00",27.7,20892,13664,null,4.41,14.78,295.5,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.850000000000001,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.15,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","A","5_SO2_T3_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.4",15.2,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,9.24,5.13,14.35,9.11,"lb/hr",null,0.31742160278745646,"lb/MWh",28.7,null,9830,null,1850,2.5231999999999998E-6,2.9001237917318432E-2,-2.084767035631159E-2,null,null,2.9001237917318432E-2,10.716925351071692,0.31080410184857149,"original database export===>","5_SO2_T3_R1",2.904837524022346E-2,"A",9.11,"pound per hour (lb/hr)","Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2006-12-19T14:05:00","2006-12-19T15:11:00",28.7,21660,14145,9.24,5.13,14.35,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",9.11,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW14:AW16)","v":0.28810722335831401}]
[null,null,"Yes","A","5_SO2_T3_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.5",13.91,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,9.1159999999999997,5.22,14.35,8.3000000000000007,"lb/hr",null,0.28919860627177701,"lb/MWh",28.7,null,9830,null,1850,2.3090600000000002E-6,2.6539948646703913E-2,-1.650062517690868E-2,null,null,2.6539948646703913E-2,10.716925351071692,0.28442664846800203,"original database export===>","5_SO2_T3_R2",2.6583085499441345E-2,"A",8.3000000000000007,"pound per hour (lb/hr)","Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2006-12-19T15:23:00","2006-12-19T16:23:00",28.7,21665,14145,9.1159999999999997,5.22,14.35,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.91,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",8.3000000000000007,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","A","5_SO2_T3_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.6",13.16,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,8.92,5.26,14.26,7.85,"lb/hr",null,0.27351916376306618,"lb/MWh",28.7,null,9830,null,1850,2.18456E-6,2.5108966512625699E-2,-1.6189885724181244E-2,null,null,2.5108966512625699E-2,10.716925351071692,0.26909091975836852,"original database export===>","5_SO2_T3_R3",2.5149777510614525E-2,"A",7.85,"pound per hour (lb/hr)","Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2006-12-19T16:34:00","2006-12-19T17:34:00",28.7,21666,14145,8.92,5.26,14.26,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.16,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",7.85,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T4_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.7",12.87,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,7.556,5.2,14.25,6.82,"lb/hr",null,0.24270462633451956,"lb/MWh",28.1,null,9830,null,1850,2.1364200000000001E-6,2.4555653420782125E-2,8.4285489863697924E-2,null,null,2.4555653420782125E-2,10.716925351071692,0.2631611046573103,"original database export===>","5_SO2_T4_R1",2.459556508826816E-2,"B",6.82,"pound per hour (lb/hr)","Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","7","2007-11-27T13:01:00","2007-11-27T14:05:00",28.1,21076,14211,7.556,5.2,14.25,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.87,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",6.82,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW17:AW19)","v":0.26779590266733283}]
[null,null,"Yes","B","5_SO2_T4_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.8",12.17,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,7.61,5.21,13.93,6.4160000000000004,"lb/hr",null,0.22751773049645391,"lb/MWh",28.2,null,9830,null,1850,2.0202199999999999E-6,2.3220070095642458E-2,9.3751055439307424E-2,null,null,2.3220070095642458E-2,10.716925351071692,0.24884775786165236,"original database export===>","5_SO2_T4_R2",2.3257810965363127E-2,"B",6.4160000000000004,"pound per hour (lb/hr)","Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","8","2007-11-27T14:20:00","2007-11-27T15:20:00",28.2,21086,14211,7.61,5.21,13.93,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.17,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",6.4160000000000004,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T4_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.9",14.25,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,7.26,5.09,13.93,7.6059999999999999,"lb/hr",null,0.26781690140845071,"lb/MWh",28.4,null,9830,null,1850,2.3655000000000001E-6,2.7188660547486036E-2,8.7977808535132429E-2,null,null,2.7188660547486036E-2,10.716925351071692,0.29137884548303583,"original database export===>","5_SO2_T4_R3",2.7232851787709497E-2,"B",7.6059999999999999,"pound per hour (lb/hr)","Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","9","2007-11-27T15:33:00","2007-11-27T16:33:00",28.4,21240,14211,7.26,5.09,13.93,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",14.25,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",7.6059999999999999,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T5_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.10",12.8,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,10.71,3.87,15.33,8.43,"lb/hr",null,0.29683098591549295,"lb/MWh",28.4,null,9830,null,1850,2.1248E-6,2.4422095088268158E-2,-0.11825320671791888,null,null,2.4422095088268158E-2,10.716925351071692,0.2617297699777445,"original database export===>","5_SO2_T5_R1",2.4461789675977653E-2,"A",8.43,"pound per hour (lb/hr)","Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2008-11-20T09:05:00","2008-11-20T10:05:00",28.4,20241,13690,10.71,3.87,15.33,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.8,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",8.43,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW20:AW22)","v":0.3019434585941167}]
[null,null,"Yes","B","5_SO2_T5_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.11",16.100000000000001,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,10.63,3.67,15.54,10.73,"lb/hr",null,0.37649122807017543,"lb/MWh",28.5,null,9830,null,1850,2.6726000000000005E-6,3.0718416478212295E-2,-0.12559190824289332,null,null,3.0718416478212295E-2,10.716925351071692,0.32920697630013174,"original database export===>","5_SO2_T5_R2",3.0768344826815643E-2,"B",10.73,"pound per hour (lb/hr)","Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2008-01-20T10:19:00","2008-01-20T11:19:00",28.5,20391,13690,10.63,3.67,15.54,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",16.100000000000001,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.73,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T5_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.12",15.4,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,11,3.9,15.22,10.07,"lb/hr",null,0.35333333333333333,"lb/MWh",28.5,null,9830,null,1850,2.5564000000000002E-6,2.9382833153072632E-2,-0.10879161460997964,null,null,2.9382833153072632E-2,10.716925351071692,0.31489362950447386,"original database export===>","5_SO2_T5_R3",2.943059070391062E-2,"A",10.07,"pound per hour (lb/hr)","Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2008-01-20T11:28:00","2008-01-20T12:28:00",28.5,20295,13690,11,3.9,15.22,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.4,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.07,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T6_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.13",29.2,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,11.4,4.3,14.95,18.43,"lb/hr",null,0.67757352941176474,"lb/MWh",27.2,null,9830,null,1850,4.8471999999999999E-6,5.5712904420111731E-2,-0.11880997139885824,null,null,5.5712904420111731E-2,10.716925351071692,0.59707103776172954,"original database export===>","5_SO2_T6_R1",5.5803457698324017E-2,"A",18.43,"pound per hour (lb/hr)","Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2009-12-10T08:04:00","2009-12-10T09:04:00",27.2,20094,13970,11.4,4.3,14.95,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",29.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",18.43,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AW23:AW25)","v":0.55617576120270706}]
[null,null,"Yes","B","5_SO2_T6_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.14",26.2,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,11.32,4.04,15.28,16.7,"lb/hr",null,0.59219858156028371,"lb/MWh",28.2,null,9830,null,1850,4.3491999999999998E-6,4.9988975883798879E-2,-9.5357301411130621E-2,null,null,4.9988975883798879E-2,10.716925351071692,0.53572812292319572,"original database export===>","5_SO2_T6_R2",5.0070225743016762E-2,"A",16.7,"pound per hour (lb/hr)","Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2009-12-10T09:21:00","2009-12-10T10:21:00",28.2,20386,13970,11.32,4.04,15.28,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",16.7,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,"Yes","B","5_SO2_T6_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"Part II","SO2","SCAQMD 6.15",26.2,"ppm @ 3% O2","No",null,null,1.66E-7,"(lb/scf)/(ppm SO2)",null,null,null,null,null,9844,12.26,4.1100000000000003,15.17,16.7,"lb/hr",null,0.60507246376811585,"lb/MWh",27.6,null,9830,null,1850,4.3491999999999998E-6,4.9988975883798879E-2,-0.114605018402383,null,null,4.9988975883798879E-2,10.716925351071692,0.53572812292319572,"original database export===>","5_SO2_T6_R3",5.0070225743016762E-2,"A",16.7,"pound per hour (lb/hr)","Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2009-02-10T10:37:00","2009-02-10T11:37:00",27.6,20112,13970,12.26,4.1100000000000003,15.17,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",16.7,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,"Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,null,null,"Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,null,"Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,null,null,null,null,"Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,null,null,null,"Row for Part III Data Heading from Raw Part III Data Export to Excel",null,null,null,null,null,null,null,null,"original database export===>","Key","RTI Calculated QA\nlb/MMBtu","Run Grade","Submitted Value","Submitted Value UOM","Use ?","Comment","facility_id","configuration_id","submittal_id","pollutant","run_number","start_date","end_date","measured_value_ppm","measured_value_NO","measured_value_NO2","measured_TDS","measured_TSS","basis","test_method","data_flag","method_comments","emission_rate","emission_rate_ppmdv","steam_output","heat_input","fg_moisture_content","fg_CO2_content","fg_oxygen_content","19-1","19-5","19-6","19-9","19-1","19-5","19-6","19-9","19-1","19-5","19-6","19-9","fg_flow_rate","fg_temperature","fuel1_input_rate","fuel1_type","fuel1_rate_units","fuel1_method","fuel2_input_rate","fuel2_type","fuel2_rate_units","fuel2_method","fuel3_input_rate","fuel3_type","fuel3_rate_units","fuel3_method","fuel4_input_rate","fuel4_type","fuel4_rate_units","fuel4_method","other_information","exclude_data","QA Comment","Questions for EPA"]
[null,null,null,null,null,"Hanford",null,"1A","Pet Coke",null,null,null,null,null,"SCAQMD 6.17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.716925351071692,null,"original database export===>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"using ppmdv; column R",null,null,null,"using ppm ; column H",null,null,null,"using ppm ; column H"]
[null,null,"Yes","A","5_SO2_T1_R1","Hanford",10373,"1A","Pet Coke",100,null,null,"ETTS Other ","SO2",null,{"$f":"BM28","v":"29.61"},"ppm",null,null,null,1.66E-7,"lb/scf",null,null,null,null,null,9844,{"$f":"BZ28","v":"13.1"},{"$f":"CB28","v":"3.8"},{"$f":"CA28","v":"15.5"},null,null,null,{"$f":"BV28","v":5.9586603969999999E-2},"lb/MMBtu",null,null,{"$f":"VLOOKUP(I28,$A$88:$E$104,3,FALSE)","v":9830},null,1850,{"$f":"P28*U28","v":4.9152599999999999E-6},{"$f":"IF(AD28<>\"\",AP28*AB28*20.9/(20.9-AD28),\"no O2 data for run\")","v":5.9138223760000004E-2},{"$f":"(AQ28-$AI28)/$AI28","v":-7.5248492131845656E-3},{"$f":"IF(AE28<>\"\",AP28*AO28*100/AE28,\"no CO2 data for run\")","v":5.8666006451612907E-2},{"$f":"(AS28-$AI28)/$AI28","v":-1.5449739657097837E-2},{"$f":"AI28","v":5.9586603969999999E-2},10.716925351071692,{"$f":"AU28*AV28","v":0.63858518667036213},"original database export===>","5_SO2_T1_R1",5.9216989284444452E-2,"A",5.9586603969999999E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","1","2010-05-18","2010-05-18","29.61","","","","","Dry","","","Plant Monitor",5.9586603969999999E-2,"24.25","218.82","277","13.1","15.5","3.8",4.8497534283950615E-2,4.2144357292753079E-2,4.9604548387096777E-2,4.31063525483871E-2,5.9054118200000005E-2,5.1318028715799997E-2,5.8666006451612907E-2,{"$error":"#VALUE!"},5.9216989284444452E-2,5.1459563688182219E-2,6.0568687741935481E-2,5.2634189647741934E-2,"68553","343","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false,null,null,{"$f":"AVERAGE(AW28:AW31)","v":0.61775642962213595}]
[null,null,"Yes","A","5_SO2_T1_R2","Hanford",10373,"1A","Pet Coke",100,null,null,"ETTS Other ","SO2",null,{"$f":"BM29","v":"29.38"},"ppm",null,null,null,1.66E-7,"lb/scf",null,null,null,null,null,9844,{"$f":"BZ29","v":"12.2"},{"$f":"CB29","v":"3.8"},{"$f":"CA29","v":"15.9"},null,null,null,{"$f":"BV29","v":5.9106435633999997E-2},"lb/MMBtu",null,null,9830,null,1850,4.8770799999999997E-6,{"$f":"IF(AD29<>\"\",AP29*AB29*20.9/(20.9-AD29),\"no O2 data for run\")","v":5.8678858968888893E-2},{"$f":"(AQ29-$AI29)/$AI29","v":-7.2340120077406195E-3},5.6745899371069178E-2,-3.9937043024346405E-2,{"$f":"AI29","v":5.9106435633999997E-2},10.716925351071692,0.63343925845750182,"original database export===>","5_SO2_T1_R2",5.8757012670617288E-2,"A",5.9106435633999997E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","2","2010-05-19","2010-05-19","29.38","","","","","Dry","","","Plant Monitor",5.9106435633999997E-2,"24.05","223.54","279.1","12.2","15.9","3.8",4.8794777777777776E-6,4.2229652956143213E-2,4.7957817610062889E-2,4.2106963861635219E-2,5.859540671111111E-2,5.1446767092355558E-2,5.6745899371069178E-2,{"$error":"#VALUE!"},5.8757012670617288E-2,5.1588657124801977E-2,5.8586306918238996E-2,5.143877747421384E-2,"66623","341","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
[null,null,"Yes","A","5_SO2_T1_R3","Hanford",10373,"1A","Pet Coke",100,null,null,"ETTS Other ","SO2",null,"28.7","ppm",null,null,null,1.66E-7,"lb/scf",null,null,null,null,null,9844,"12","3.9","15.8",null,null,null,5.7757391262000003E-2,"lb/MMBtu",null,null,9830,null,1850,4.7642000000000001E-6,5.7657917783529411E-2,-1.722264047892313E-3,5.5783354430379746E-2,-3.4178081601116642E-2,5.7757391262000003E-2,10.716925351071692,0.61898165062749444,"original database export===>","5_SO2_T1_R3",5.773471170535948E-2,"A",5.7757391262000003E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","3","2010-05-20","2010-05-20","28.7","","","","","Dry","","","Plant Monitor",5.7757391262000003E-2,"23.5","221.24","275","12","15.8","3.9",4.7959352941176474E-6,4.1601179026718962E-2,4.71576582278481E-2,4.149873924050633E-2,5.7575917494117647E-2,5.0666807394823536E-2,5.5783354430379746E-2,{"$error":"#VALUE!"},5.773471170535948E-2,5.0806546300716349E-2,5.7592544303797462E-2,5.0681438987341766E-2,"67896","344","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
[null,null,"Yes","A","5_SO2_T1_R4","Hanford",10373,"1A","Pet Coke",100,null,null,"ETTS Other ","SO2",null,"26.9","ppm",null,null,null,1.66E-7,"lb/scf",null,null,null,null,null,9844,"11.7","3.9","15.7",null,null,null,5.4121831003999997E-2,"lb/MMBtu",null,null,9830,null,1850,4.4653999999999996E-6,5.4041741755294109E-2,-1.479795624430528E-3,5.2617770700636939E-2,-2.7790270126890153E-2,5.4121831003999997E-2,10.716925351071692,0.58001962273318552,"original database export===>","5_SO2_T1_R4",5.4113719333594767E-2,"A",5.4121831003999997E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","4","2010-05-21","2010-05-21","26.9","","","","","Dry","","","Plant Monitor",5.4121831003999997E-2,"22.02","220.29","273.6","11.7","15.7","3.9",4.4938934117647058E-6,3.9114080299548076E-2,4.4469179617834399E-2,3.9266285602547774E-2,5.3964884341176467E-2,4.7650992873258823E-2,5.2617770700636939E-2,{"$error":"#VALUE!"},5.4113719333594767E-2,4.7782414171564182E-2,5.432429299363057E-2,4.7968350713375796E-2,"68376","343","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T4",0.26741504705606278]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T3",0.2876974812690194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T5",0.30151403880334898]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T2",0.36433513537569456]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T6",0.55538477576418221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5_SO2_T1",0.61775642962213595]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Conversions"]
[1,null,"ppm SO2=",1.66E-7,"lb/scf"]
[1,null,"ppm Hg=",{"$f":"D87*A93/A94","v":5.1979300655635339E-7},"lb/scf"]
[1000,null,"mg=",1,"g"]
[1000000,null,"ug=",1,"g"]
[454,null,"g=",1,"lb"]
[1,null,"m^3=",35.314500000000002,"ft^3"]
[200.59,null,"Hg molecular weight"]
[64.06,null,"SO2 molecular weight"]
[]
["Table 19-2",null,"Fd","Fw","Fc"]
["Fuel Type",null,"dscf/MMBtu","wscf/MMBtu","scf/MMBtu"]
["Coal"]
["Anthracite",null,10100,10540,1970]
["Bituminous",null,9780,10640,1800]
["Lignite",null,9860,11950,1910]
["Oil",null,9190,10320,1420]
["Subbituminous",null,9820,null,1840]
["Pet Coke",null,9830,null,1850]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47]
[]
[null,"Column Source==>",45,45,45,45,45,45,45,45,45,44]
[null,"Test Avgs for UPL","R1","R2","R3","R4","R5","R6","R7","R8","R9","R10"]
["Test_IDs","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","Test_IDs"]
["5_SO2_T4",{"$f":"AVERAGE(C202:L202)","v":0.26779590266733283},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.2631611046573103},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.24884775786165236},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.29137884548303583},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!&\"_\"&J$200,$E:BB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!&\"_\"&K$200,$E:BC,K$199,FALSE),\"\")","v":""},null,{"$f":"A202","v":"5_SO2_T4"}]
["5_SO2_T3",0.28810722335831401,{"$f":"IFERROR(VLOOKUP($A203&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.31080410184857149},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.28442664846800203},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.26909091975836852},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!&\"_\"&J$200,$E:BB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(#REF!&\"_\"&K$200,$E:BC,K$199,FALSE),\"\")","v":""},null,"5_SO2_T3"]
["5_SO2_T5",0.3019434585941167,{"$f":"IFERROR(VLOOKUP($A204&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.2617297699777445},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.32920697630013174},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.31489362950447386},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},null,null,null,"5_SO2_T5"]
["5_SO2_T2",0.36485402570074643,{"$f":"IFERROR(VLOOKUP($A205&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.36151424478175953},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.36805748903120322},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.36499034328927654},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&J$200,$E:EB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A205&\"_\"&K$200,$E:EC,K$199,FALSE),\"\")","v":""},null,"5_SO2_T2"]
["5_SO2_T6",0.55617576120270706,{"$f":"IFERROR(VLOOKUP($A206&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.59707103776172954},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.53572812292319572},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.53572812292319572},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A206&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},null,null,null,"5_SO2_T6"]
["5_SO2_T1",0.61775642962213595,{"$f":"IFERROR(VLOOKUP($A207&\"_\"&C$200,$E:DU,C$199,FALSE),\"\")","v":0.63858518667036213},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":0.63343925845750182},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&E$200,$E:DW,E$199,FALSE),\"\")","v":0.61898165062749444},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&F$200,$E:DX,F$199,FALSE),\"\")","v":0.58001962273318552},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&G$200,$E:DY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&H$200,$E:DZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A207&\"_\"&I$200,$E:EA,I$199,FALSE),\"\")","v":""},null,null,null,"5_SO2_T1"]
[]
[null,null,31,31,31,31,31,31,31,31,31]
[]
["Using Actual O2"]
["5_SO2_T4",{"$f":"AVERAGE(C212:L212)","v":0.24270462633451956},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&C$200,$E:DU,C$209,FALSE),\"\")","v":0.24270462633451956},null,null,{"$f":"IFERROR(VLOOKUP($A212&\"_\"&F$200,$E:DX,F$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&G$200,$E:DY,G$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&H$200,$E:DZ,H$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&I$200,$E:EA,I$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&J$200,$E:EB,J$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&K$200,$E:EC,K$209,FALSE)*$AV$11,\"\")","v":""},null,{"$f":"A212","v":"5_SO2_T4"}]
["5_SO2_T3"]
["5_SO2_T5"]
["5_SO2_T2"]
["5_SO2_T6"]
["5_SO2_T1"]

{"sheet":"UPL Normal","index":3,"n_rows":108,"n_cols":6,"rows_kept":108,"cut":false,"hidden":false,"merged":[[47,16,48,16]]}
["Emissions (lb/MW)","SO2"]
[null,10373]
["ORIS/Facility/Unit","Hanford"]
["Averages","1A"]
[1,0.26779590266733283]
[2,0.28810722335831401]
[3,0.3019434585941167]
[4,0.36485402570074643]
[5,0.55617576120270706]
[6,0.61775642962213595]
["CEMS Value omitted; dissimilar data."]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[]
["ni = number test Averages =",{"$f":"COUNT(B5:B39)","v":6}]
[]
[]
[]
["Total Number of sources =",null,{"$f":"COUNTA(B2:Q2)","v":1}]
[]
[]
["n =Total # test Averages =",null,{"$f":"SUM(B41:B41)","v":6}]
[]
[]
[]
[]
[null,null,{"$f":"C48-1","v":5}]
[]
[]
[]
[]
["This step is for QC only:"]
[]
["means",{"$f":"AVERAGE(B5:B39)","v":0.39943880019089217}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"AVERAGE(B5:B39)","v":0.39943880019089217}]
["UPL Mean ="]
[]
[]
[]
["Pooled Variance = ",null,{"$f":"VAR(B5:H39)","v":2.2531016599145935E-2}]
[]
[]
[]
[]
[]
["m= number future Averages =",null,1]
[]
[]
["Term1",null,{"$f":"1/C48+1/C78","v":1.1666666666666667}]
[]
[]
[]
["Term2",null,{"$f":"C72*C81","v":2.6286186032336924E-2}]
[]
[]
[]
[]
[]
["Squared root Term2",null,{"$f":"SQRT(C85)","v":0.16213015152135313}]
[]
[]
["NOTE: the pvalue for the t-statistic is calculated as: 2*alpha, where 1-alpha is desired confidence, so if 99% confidence is desired then alpha=0.01 and 2*alpha=2*(0.01)"]
[]
[]
["t-statistic","= quantile t-distribution with df degrees of freedom at .99 confidence level =",{"$f":"TINV(2*0.01,C53)","v":3.3649299989072183}]
[]
[]
["UPL  POOLED VARIANCE = ",null,{"$f":"C67+C97*C91","v":0.94499541077246607},{"$f":"IFERROR(IF(FIND(\"MM\",A$1,1)>0,\"lb/MMBtu\",\"lb/MW\"),\"lb/MW\")","v":"lb/MW"},{"$f":"C100*1000","v":944.99541077246602},"lb/GWhr"]
[]
[]
[]
[]
[null,"Normal UPL",{"$f":"'UPL Pooled Template '!F107","v":0.94499541077246607},"lb/MW"]
[null,"Lognormal UPL",{"$f":"'Lognormal Template'!D165","v":0.96092513845853866},"lb/MW"]
[]
[null,"Final UPL",{"$f":"C106","v":0.96092513845853866},"lb/MW"]

{"sheet":"UPL Pooled Template ","index":4,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,1,0,11],[37,0,37,3]]}
[{"$f":"'UPL Normal'!B1","v":"SO2"},"Emissions (lb/MW)"]
["Averages","10373\nHanford\n1A"]
[1,0.26779590266733283]
[2,0.28810722335831401]
[3,0.3019434585941167]
[4,0.36485402570074643]
[5,0.55617576120270706]
[6,0.61775642962213595]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
["Use for large sample sets and small sample sets that are Normal."]
[]
["Testing Normality","Raw Data"]
["Sample Size",{"$f":"COUNT(B3:L37)","v":6}]
["Kurtosis",{"$f":"KURT(B3:L37)","v":-1.5327857536884624}]
["SE Kurtosis",{"$f":"SQRT((B41^2-1)/((B41-3)*(B41+5)))","v":1.0298573010888745}]
["Result Kurtosis",{"$f":"IF(ABS(B42/B43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"}]
["Skewness",{"$f":"SKEW(B3:L37)","v":0.85393927260844571}]
["SE Skewness",{"$f":"SQRT((6*B41*(B41-1))/((B41-2)*(B41+1)*(B41+3)))","v":0.84515425472851657}]
["Result Skewness",{"$f":"IF(ABS(B45/B46)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"}]
[]
[]
["ni = number test Averages =",{"$f":"COUNT(B3:B37)","v":6},0,0,0,0,0,0,0,0,0,0]
[]
["Total Number of sources =",{"$f":"COUNTA(B2:L2)","v":1}]
[]
[]
["n =Total # test Averages =",{"$f":"SUM(B50:L50)","v":6}]
[]
[]
[]
[]
[null,{"$f":"B55-1","v":5}]
[]
[]
[]
[]
["This step is for QC only:"]
[]
["means",{"$f":"AVERAGE(B3:B37)","v":0.39943880019089217},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"AVERAGE(B3:L37)","v":0.39943880019089217}]
["Mean ="]
[]
[]
[]
["Pooled Variance = ",null,null,{"$f":"VAR(B3:L37)","v":2.2531016599145935E-2}]
[]
[]
[]
[]
[]
["m= number future Averages =",{"$f":"'UPL Normal'!C78","v":1}]
[]
[]
["Term1",{"$f":"1/B55+1/B85","v":1.1666666666666667}]
[]
[]
[]
["Term2",{"$f":"D79*B88","v":2.6286186032336924E-2}]
[]
[]
[]
[]
[]
["Squared root Term2",null,{"$f":"SQRT(B92)","v":0.16213015152135313}]
[]
[]
["NOTE: the pvalue for the t-statistic is calculated as: 2*alpha, where 1-alpha is desired confidence, so if 99% confidence is desired then alpha=0.01 and 2*alpha=2*(0.01)"]
[]
[]
["t-statistic","= quantile t-distribution with df degrees of freedom at .99 confidence level =",null,null,null,null,null,{"$f":"TINV(2*0.01,B60)","v":3.3649299989072183}]
[]
[]
["UPL  POOLED VARIANCE = ",null,null,null,null,{"$f":"B74+H104*C98","v":0.94499541077246607}]

{"sheet":"Lognormal Template","index":5,"n_rows":167,"n_cols":13,"rows_kept":167,"cut":false,"hidden":false,"merged":[[127,0,127,3],[132,0,132,8],[133,0,133,4],[135,0,135,8],[137,0,137,2],[116,0,116,2],[0,1,0,11],[37,0,37,3],[48,1,48,11],[86,0,86,1],[113,0,113,2]]}
[null,"Emissions (lb/MW)"]
[{"$f":"'UPL Pooled Template '!A1","v":"SO2"},"10373\nHanford\n1A",null,null,null,null,null,null,null,null,null,null,"Outliers Removed"]
[1,0.26779590266733283]
[2,0.28810722335831401]
[3,0.3019434585941167]
[4,0.36485402570074643]
[5,0.55617576120270706]
[6,0.61775642962213595]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
["Use for small sample sets that are Lognormal."]
[]
["Testing Normality","Raw Data","Log Data"]
["Sample Size",{"$f":"COUNT(B3:L37)","v":6},{"$f":"COUNT(B51:L85)","v":6}]
["Kurtosis",{"$f":"KURT(B3:L37)","v":-1.5327857536884624},{"$f":"KURT(B51:L85)","v":-1.7978697024773336}]
["SE Kurtosis",{"$f":"SQRT((B41^2-1)/((B41-3)*(B41+5)))","v":1.0298573010888745},{"$f":"SQRT((C41^2-1)/((C41-3)*(C41+5)))","v":1.0298573010888745}]
["Result Kurtosis",{"$f":"IF(ABS(B42/B43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"},{"$f":"IF(ABS(C42/C43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"}]
["Skewness",{"$f":"SKEW(B3:L37)","v":0.85393927260844571},{"$f":"SKEW(B51:L85)","v":0.68594191014079031}]
["SE Skewness",{"$f":"SQRT((6*B41*(B41-1))/((B41-2)*(B41+1)*(B41+3)))","v":0.84515425472851657},{"$f":"SQRT((6*C41*(C41-1))/((C41-2)*(C41+1)*(C41+3)))","v":0.84515425472851657}]
["Result Skewness",{"$f":"IF(ABS(B45/B46)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"},{"$f":"IF(ABS(C45/C46)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"}]
[]
[null,"1. Take LN( ) of Raw Data"]
["Averages"]
[1,{"$f":"IF(B3>0,LN(B3),\"\")","v":-1.317530145814729},{"$f":"IF(C3>0,LN(C3),\"\")","v":""},"","","","","","","","",""]
[2,{"$f":"IF(B4>0,LN(B4),\"\")","v":-1.2444225648063989},"","","","","","","","","",""]
[3,{"$f":"IF(B5>0,LN(B5),\"\")","v":-1.1975155023340074},"","","","","","","","","",""]
[4,{"$f":"IF(B6>0,LN(B6),\"\")","v":-1.0082579349798073},"","","","","","","","","",""]
[5,{"$f":"IF(B7>0,LN(B7),\"\")","v":-0.58667091741503596},"","","","","","","","","",""]
[6,{"$f":"IF(B8>0,LN(B8),\"\")","v":-0.48166102603785949},"","","","","","","","","",""]
[7,{"$f":"IF(B9>0,LN(B9),\"\")","v":""},"","","","","","","","","",""]
[8,{"$f":"IF(B10>0,LN(B10),\"\")","v":""},"","","","","","","","","",""]
[9,{"$f":"IF(B11>0,LN(B11),\"\")","v":""},"","","","","","","","","",""]
[10,{"$f":"IF(B12>0,LN(B12),\"\")","v":""},"","","","","","","","","",""]
[11,{"$f":"IF(B13>0,LN(B13),\"\")","v":""},"","","","","","","","","",""]
[12,{"$f":"IF(B14>0,LN(B14),\"\")","v":""},"","","","","","","","","",""]
[13,{"$f":"IF(B15>0,LN(B15),\"\")","v":""},"","","","","","","","","",""]
[14,{"$f":"IF(B16>0,LN(B16),\"\")","v":""},"","","","","","","","","",""]
[15,{"$f":"IF(B17>0,LN(B17),\"\")","v":""},"","","","","","","","","",""]
[16,{"$f":"IF(B18>0,LN(B18),\"\")","v":""},"","","","","","","","","",""]
[17,{"$f":"IF(B19>0,LN(B19),\"\")","v":""},"","","","","","","","","",""]
[18,{"$f":"IF(B20>0,LN(B20),\"\")","v":""},"","","","","","","","","",""]
[19,{"$f":"IF(B21>0,LN(B21),\"\")","v":""},"","","","","","","","","",""]
[20,{"$f":"IF(B22>0,LN(B22),\"\")","v":""},"","","","","","","","","",""]
[21,{"$f":"IF(B23>0,LN(B23),\"\")","v":""},"","","","","","","","","",""]
[22,{"$f":"IF(B24>0,LN(B24),\"\")","v":""},"","","","","","","","","",""]
[23,{"$f":"IF(B25>0,LN(B25),\"\")","v":""},"","","","","","","","","",""]
[24,{"$f":"IF(B26>0,LN(B26),\"\")","v":""},"","","","","","","","","",""]
[25,{"$f":"IF(B27>0,LN(B27),\"\")","v":""},"","","","","","","","","",""]
[26,{"$f":"IF(B28>0,LN(B28),\"\")","v":""},"","","","","","","","","",""]
[27,{"$f":"IF(B29>0,LN(B29),\"\")","v":""},"","","","","","","","","",""]
[28,{"$f":"IF(B30>0,LN(B30),\"\")","v":""},"","","","","","","","","",""]
[29,{"$f":"IF(B31>0,LN(B31),\"\")","v":""},"","","","","","","","","",""]
[30,{"$f":"IF(B32>0,LN(B32),\"\")","v":""},"","","","","","","","","",""]
[31,{"$f":"IF(B33>0,LN(B33),\"\")","v":""},"","","","","","","","","",""]
[32,{"$f":"IF(B34>0,LN(B34),\"\")","v":""},"","","","","","","","","",""]
[33,{"$f":"IF(B35>0,LN(B35),\"\")","v":""},"","","","","","","","","",""]
[34,{"$f":"IF(B36>0,LN(B36),\"\")","v":""},"","","","","","","","","",""]
[35,{"$f":"IF(B37>0,LN(B37),\"\")","v":""},"","","","","","","","","",""]
[]
["2. Calculate sample size, n=",null,{"$f":"COUNT(B51:L85)","v":6}]
[]
["Average of Raw Data",null,{"$f":"AVERAGE(B3:L37)","v":0.39943880019089217}]
[]
[]
["3. Calculate ",null,null,{"$f":"AVERAGE(B51:L85)","v":-0.97267634856463969}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"VAR(B51:L85)","v":0.12693701634242682}]
["4. Calculate"]
[]
[]
[]
[]
["5. m",null,{"$f":"'UPL Normal'!C78","v":1}]
[]
["6. Calculate"]
[]
[]
[]
["a- Numerator first term",null,null,null,null,{"$f":"EXP(4*E102)+2*EXP(3*E102)+3*EXP(2*E102)-3","v":5.4555156603485209}]
[]
[]
["b- denominator first term",null,null,null,null,{"$f":"C108*(EXP(E102)-1)^2","v":1.8318406350856735E-2}]
[]
[]
[]
[null,null,{"$f":"F114/F117+3*(1-1/C108)","v":297.81606302741346}]
[]
[]
["7. Calculate"]
[null,null,null,null,null,{"$f":"SQRT(EXP(E102)-1)*(EXP(E102)+2)/SQRT(C108)","v":1.1534727209421229}]
[]
[]
["8. Go to tab distribution for 99 percentile \"lognormal distribution 99%\""]
[]
["9. substitue the values of ",null,null,null,"in cell D7 and F7 respectively"]
[]
[]
["10. In column AE indentify the value that is the smallest value that is larger than 0.99, note what row number this is.",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"x\",'lognormal distribution 99 %'!AF:AL,2,FALSE)","v":93},"is the Row number in Column AE with the first value > 0.99."]
[]
[]
["11. In column B, go down to the row number from Step 10. above, and copy the z value.",null,null,null,null,null,null,null,null,{"$f":"INDIRECT(\"'lognormal distribution 99 %'!B\" & J133)","v":3.484},"z value from \"lognormal distribution 99%\""]
[]
["12. calculate the UPL using the formula "]
[]
[]
[]
[]
[]
[]
[]
["a- Calculate ",null,null,{"$f":"EXP(D92+E102/2)","v":0.40284321379330318}]
[]
[]
["b- Calculate",null,null,{"$f":"EXP(2*D92+E102)","v":0.16228265489931695}]
[]
[]
[]
["c- Calculate ",null,null,{"$f":"EXP(E102)-1","v":0.13534550731685457}]
[]
[]
[]
["d-calculate",null,null,null,{"$f":"(E102)/C87+(E102^2)/(2*(C87-1))","v":2.2767470002196224E-2}]
[]
[]
[]
["e- Calculate",null,null,null,null,null,null,{"$f":"SQRT(C108*D149*D153+C108^2*D149*E157)","v":0.16018424932986092}]
[]
[]
[]
["f- Calculate UPL",null,null,{"$f":"D146+(J136/C108)*H161","v":0.96092513845853866},"lb/MW"]
[]
[null,null,null,{"$f":"D165","v":0.96092513845853866}]

{"sheet":"lognormal distribution 99 %","index":6,"n_rows":110,"n_cols":33,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"distribution of Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"distribution"]
["∆z","z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Absolute values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumulative","normalization"]
[0.10100000000000001,null,null,{"$f":"'Lognormal Template'!C121","v":297.81606302741346},null,{"$f":"'Lognormal Template'!F125","v":1.1534727209421229}]
[]
[null,-5,"=f(a)",null,null,null,{"$f":"(1-($F$7/6)*(3*B9-B9^3)+(($D$7-3)*(3-6*B9^2+B9^4))/24)","v":5851.6062554120454},null,null,null,null,null,null,{"$f":"NORMDIST(B9,0,1,FALSE)","v":1.4867195147342977E-6},null,{"$f":"G9*N9","v":8.6996972124623768E-3},null,null,null,null,null,{"$f":"ABS(P9)","v":8.6996972124623768E-3},null,null,{"$f":"($A$7/2)*V9","v":4.3933470922935005E-4},null,null,null,null,{"$f":"Y9","v":4.3933470922935005E-4},{"$f":"AD9/SUM($Y$9:$Y$108)","v":1.2744842509377254E-5},{"$f":"IF(AE9>0.99,\"x\",\"\")","v":""},9]
[1,{"$f":"$B$9+A10*$A$7","v":-4.899},null,null,null,null,5324.8666351047841,null,null,null,null,null,null,2.4509397556839956E-6,null,1.305092732969358E-2,null,null,null,null,null,1.305092732969358E-2,null,null,{"$f":"($A$7)*V10","v":1.3181436602990517E-3},null,null,null,null,{"$f":"Y10+AD9","v":1.7574783695284016E-3},5.0983417796802278E-5,{"$f":"IF(AE10>0.99,\"x\",\"\")","v":""},10]
[2,-4.798,null,null,null,null,4832.657543725385,null,null,null,null,null,null,3.9995026854766194E-6,null,1.932822682411852E-2,null,null,null,null,null,1.932822682411852E-2,null,null,1.9521509092359707E-3,null,null,null,null,3.7096292787643726E-3,1.0761417191225231E-4,"",11]
[3,-4.6970000000000001,null,null,null,null,4373.5074412917866,null,null,null,null,null,null,6.4602468217096111E-6,null,2.8253937547328599E-2,null,null,null,null,null,2.8253937547328599E-2,null,null,2.8536476922801889E-3,null,null,null,null,6.5632769710445614E-3,1.9039681951857346E-4,"",12]
[4,-4.5960000000000001,null,null,null,null,3945.9754664996694,null,null,null,null,null,null,1.0329088331249594E-5,null,4.0758329146418908E-2,null,null,null,null,null,4.0758329146418908E-2,null,null,4.11659124378831E-3,null,null,null,null,1.0679868214832872E-2,3.0981671959793297E-4,"",13]
[5,-4.4950000000000001,null,null,null,null,3548.6514367224599,null,null,null,null,null,null,1.6347247339999862E-5,null,5.8010682759547925E-2,null,null,null,null,null,5.8010682759547925E-2,null,null,5.8590789587143408E-3,null,null,null,null,1.6538947173547213E-2,4.7978516736707581E-4,"",14]
[6,-4.3940000000000001,null,null,null,null,3180.1558480113131,null,null,null,null,null,null,2.5609260510355175E-5,null,8.1441439575251198E-2,null,null,null,null,null,8.1441439575251198E-2,null,null,8.2255853971003722E-3,null,null,null,null,2.4764532570647584E-2,7.1840458038219962E-4,"",15]
[7,-4.2930000000000001,null,null,null,null,2839.1398750951362,null,null,null,null,null,null,3.97117663248513E-5,null,0.11274725928334556,null,null,null,null,null,0.11274725928334556,null,null,1.1387473187617903E-2,null,null,null,null,3.6152005758265486E-2,1.0487485056562256E-3,"",16]
[8,-4.1920000000000002,null,null,null,null,2524.2853713805675,null,null,null,null,null,null,6.0955252216615318E-5,null,0.15386845147921496,null,null,null,null,null,0.15386845147921496,null,null,1.5540713599400712E-2,null,null,null,null,5.16927193576662E-2,1.4995755019004541E-3,"",17]
[9,-4.0910000000000002,null,null,null,null,2234.3048689519865,null,null,null,null,null,null,9.2613185614433534E-5,null,0.20692609154748293,null,null,null,null,null,0.20692609154748293,null,null,2.0899535246295776E-2,null,null,null,null,7.2592254603961973E-2,2.1058587743977507E-3,"",18]
[10,-3.99,null,null,null,null,1967.9415785715146,null,null,null,null,null,null,1.3928497646575994E-4,null,0.27410469645732388,null,null,null,null,null,0.27410469645732388,null,null,2.7684574342189714E-2,null,null,null,null,0.10027682894615168,2.908972055725496E-3,"",19]
[11,-3.8890000000000002,null,null,null,null,1723.9693896790141,null,null,null,null,null,null,2.0735069214939127E-4,null,0.35746624619430717,null,null,null,null,null,0.35746624619430717,null,null,3.6104090865625028E-2,null,null,null,null,0.13638091981177672,3.9563305784194661E-3,"",20]
[12,-3.7879999999999998,null,null,null,null,1501.1928703920828,null,null,null,null,null,null,3.0554590364653618E-4,null,0.45868333213168638,null,null,null,null,null,0.45868333213168638,null,null,4.6327016545300324E-2,null,null,null,null,0.18270793635707705,5.3002501854882058E-3,"",21]
[13,-3.6869999999999998,null,null,null,null,1298.4472675060645,null,null,null,null,null,null,4.4567390271459394E-4,null,0.57868406117852811,null,null,null,null,null,0.57868406117852811,null,null,5.8447090179031345E-2,null,null,null,null,0.2411550265361084,6.9957660275435122E-3,"",22]
[14,-3.5859999999999999,null,null,null,null,1114.5985064940371,null,null,null,null,null,null,6.4346911127639178E-4,null,0.71720971040371162,null,null,null,null,null,0.71720971040371162,null,null,7.2438180750774878E-2,null,null,null,null,0.31359320728688328,9.0971552097318803E-3,"",23]
[15,-3.4849999999999999,null,null,null,null,948.54319150682147,null,null,null,null,null,null,9.196190652258089E-4,null,0.87229840309980855,null,null,null,null,null,0.87229840309980855,null,null,8.8102138713080674E-2,null,null,null,null,0.40169534599996393,1.1652946634923717E-2,"",24]
[16,-3.3839999999999999,null,null,null,null,799.20860537297733,null,null,null,null,null,null,1.3009421669529307E-3,null,1.0397241749213508,null,null,null,null,null,1.0397241749213508,null,null,0.10501214166705644,null,null,null,null,0.50670748766702034,1.469928733827199E-2,"",25]
[17,-3.2829999999999999,null,null,null,null,665.55270959880477,null,null,null,null,null,null,1.8217038523946315E-3,null,1.2124399350478281,null,null,null,null,null,1.2124399350478281,null,null,0.12245643343983065,null,null,null,null,0.62916392110685093,1.8251676725371244E-2,"",26]
[18,-3.1819999999999999,null,null,null,null,546.56414436834314,null,null,null,null,null,null,2.5250345499379808E-3,null,1.380093348287357,null,null,null,null,null,1.380093348287357,null,null,0.13938942817702307,null,null,null,null,0.76855334928387398,2.2295282368787205E-2,"",27]
[19,-3.081,null,null,null,null,441.26222854337277,null,null,null,null,null,null,3.4643888734137819E-3,null,1.52870395482343,null,null,null,null,null,1.52870395482343,null,null,0.15439909943716645,null,null,null,null,0.92295244872104043,2.6774309781322232E-2,"",28]
[20,-2.98,null,null,null,null,348.69695966341231,null,null,null,null,null,null,4.7049575269339792E-3,null,1.6406043849873659,null,null,null,null,null,1.6406043849873659,null,null,0.16570104288372398,null,null,null,null,1.0886534916047643,3.1581199951454836E-2,"",29]
[21,-2.879,null,null,null,null,267.9490139457215,null,null,null,null,null,null,6.3249127862128329E-3,null,1.6947541443584146,null,null,null,null,null,1.6947541443584146,null,null,0.1711701685801999,null,null,null,null,1.2598236601849642,3.6546746253691913E-2,"",30]
[22,-2.778,null,null,null,null,198.12974628529989,null,null,null,null,null,null,8.416337402369389E-3,null,1.667526794182927,null,null,null,null,null,1.667526794182927,null,null,0.16842020621247564,null,null,null,null,1.4282438663974397,4.1432517758839008E-2,"",31]
[23,-2.677,null,null,null,null,138.38119025488606,null,null,null,null,null,null,1.1085658498589472E-2,null,1.5340466177940042,null,null,null,null,null,1.5340466177940042,null,null,0.15493870839719442,null,null,null,null,1.5831825747946342,4.592719891114859E-2,"",32]
[24,-2.5759999999999996,null,null,null,null,87.876058104959213,null,null,null,null,null,null,1.4453386482878732E-2,null,1.2701066303828836,null,null,null,null,null,1.2701066303828836,null,null,0.12828076966867125,null,null,null,null,1.7114633444633054,4.9648548879779049E-2,"",33]
[25,-2.4749999999999996,null,null,null,null,45.817740763738279,null,null,null,null,null,null,1.8652948792269922E-2,null,0.85463597224350829,null,null,null,null,null,0.85463597224350829,null,null,8.6318233196594346E-2,null,null,null,null,1.7977815776598998,5.2152590251124446E-2,"",34]
[26,-2.3739999999999997,null,null,null,null,11.440307837182031,null,null,null,null,null,null,2.3828414277471986E-2,null,0.27260439460618296,null,null,null,null,null,0.27260439460618296,null,null,2.7533043855224482E-2,null,null,null,null,1.8253146215151244,5.2951307721806756E-2,"",35]
[27,-2.2729999999999997,null,null,null,null,-15.991492391011072,null,null,null,null,null,null,3.0130930809477742E-2,null,-0.48183855077384435,null,null,null,null,null,0.48183855077384435,null,null,4.8665693628158285E-2,null,null,null,null,1.8739803151432826,5.436307098082277E-2,"",36]
[28,-2.1719999999999997,null,null,null,null,-37.182232959402434,null,null,null,null,null,null,3.7713749861696219E-2,null,-1.4022814331302202,null,null,null,null,null,1.4022814331302202,null,null,0.14163042474615226,null,null,null,null,2.0156107398894347,5.8471686621713564E-2,"",37]
[29,-2.0709999999999997,null,null,null,null,-52.805808228813767,null,null,null,null,null,null,4.6725789305731173E-2,null,-2.4673930694183976,null,null,null,null,null,2.4673930694183976,null,null,0.24920670001125816,null,null,null,null,2.2648174399006931,6.5701026979311086E-2,"",38]
[30,-1.9699999999999998,null,null,null,null,-63.505433882326841,null,null,null,null,null,null,5.7303788919117152E-2,null,-3.6391019784098075,null,null,null,null,null,3.6391019784098075,null,null,0.36754929981939061,null,null,null,null,2.6323667397200836,7.6363416820639546E-2,"",39]
[31,-1.8689999999999998,null,null,null,null,-69.893646925283505,null,null,null,null,null,null,6.9563238531014968E-2,null,-4.8620284328660377,null,null,null,null,null,4.8620284328660377,null,null,0.49106487171946983,null,null,null,null,3.1234316114395533,9.0608921035251866E-2,"",40]
[32,-1.7679999999999998,null,null,null,null,-72.552305685285802,null,null,null,null,null,null,8.3588399272377337E-2,null,-6.0645310957532415,null,null,null,null,null,6.0645310957532415,null,null,0.61251764067107739,null,null,null,null,3.7359492521106308,0.1083776989182052,"",41]
[33,-1.6669999999999998,null,null,null,null,-72.032589812195923,null,null,null,null,null,null,9.9421883540771347E-2,null,-7.1616157554482953,null,null,null,null,null,7.1616157554482953,null,null,0.72332319130027789,null,null,null,null,4.4592724434109083,0.12936088090415135,"",42]
[34,-1.5659999999999998,null,null,null,null,-68.85500027813606,null,null,null,null,null,null,0.11705439552546529,null,-8.0597804364629599,null,null,null,null,null,8.0597804364629599,null,null,0.81403782408275904,null,null,null,null,5.2733102674936676,0.15297564123758742,"",43]
[35,-1.4649999999999999,null,null,null,null,-63.509359377488678,null,null,null,null,null,null,0.13641534591340351,null,-8.6636512282187752,null,null,null,null,null,8.6636512282187752,null,null,0.87502877405009638,null,null,null,null,6.148339041543764,0.17835971329509492,"",44]
[36,-1.3639999999999999,null,null,null,null,-56.454810726896312,null,null,null,null,null,null,0.15736512556566029,null,-8.8840183788236242,null,null,null,null,null,8.8840183788236242,null,null,0.89728585626118607,null,null,null,null,7.0456248978049505,0.20438945026716424,"",45]
[37,-1.2629999999999999,null,null,null,null,-48.11981926526154,null,null,null,null,null,null,0.17968983860954071,null,-8.6466425576951149,null,null,null,null,null,8.6466425576951149,null,null,0.87331089832720665,null,null,null,null,7.9189357961321569,0.22972368775645083,"",46]
[38,-1.1619999999999999,null,null,null,null,-38.902171253747213,null,null,null,null,null,null,0.20309924389892503,null,-7.9010015676625551,null,null,null,null,null,7.9010015676625551,null,null,0.79800115833391816,null,null,null,null,8.7169369544660746,0.25287323381236476,"",47]
[39,-1.0609999999999999,null,null,null,null,-29.168974275776197,null,null,null,null,null,null,0.22722852877998642,null,-6.6280231107058949,null,null,null,null,null,6.6280231107058949,null,null,0.66943033418129538,null,null,null,null,9.3863672886473708,0.27229301558901126,"",48]
[40,-0.96,null,null,null,null,-19.256657237031536,null,null,null,null,null,null,0.25164434109811712,null,-4.8458288221650898,null,null,null,null,null,4.8458288221650898,null,null,0.48942871103867408,null,null,null,null,9.8757959996860443,0.28649105574089706,"",49]
[41,-0.85899999999999999,null,null,null,null,-9.4709703654563775,null,null,null,null,null,null,0.27585524287120494,null,-2.6126168303889536,null,null,null,null,null,2.6126168303889536,null,null,0.26387429986928435,null,null,null,null,10.139670299555329,0.29414589457665719,"",50]
[42,-0.75800000000000001,null,null,null,null,-8.6985211253993056E-2,null,null,null,null,null,null,0.29932643861165642,null,-2.6036973496540317E-2,null,null,null,null,null,2.6036973496540317E-2,null,null,2.6297343231505722E-3,null,null,null,null,10.142300033878479,0.29422218162861546,"",51]
[43,-0.65700000000000003,null,null,null,null,8.6509053531121776,null,null,null,null,null,null,0.32149829672959446,null,2.7812513361944959,null,null,null,null,null,2.7812513361944959,null,null,0.28090638495564413,null,null,null,null,10.423206418834123,0.30237111127366484,"",52]
[44,-0.55600000000000005,null,null,null,null,16.528987132918619,null,null,null,null,null,null,0.34180785297801497,null,5.6497376038041489,null,null,null,null,null,5.6497376038041489,null,null,0.57062349798421907,null,null,null,null,10.993829916818342,0.31892456462297047,"",53]
[45,-0.45500000000000007,null,null,null,null,23.364224611181672,null,null,null,null,null,null,0.35971219226542389,null,8.4043964554699304,null,null,null,null,null,8.4043964554699304,null,null,0.848844042002463,null,null,null,null,11.842673958820805,0.34354903294536066,"",54]
[46,-0.35400000000000009,null,null,null,null,29.004260948657542,null,null,null,null,null,null,0.37471238028421117,null,10.86825565845586,null,null,null,null,null,10.86825565845586,null,null,1.0976938215040419,null,null,null,null,12.940367780324847,0.37539248757048149,"",55]
[47,-0.25300000000000011,null,null,null,null,33.327417983842324,null,null,null,null,null,null,0.38637648574037453,null,12.876930639397555,null,null,null,null,null,12.876930639397555,null,null,1.3005699945791531,null,null,null,null,14.240937774903999,0.4131212611117494,"",56]
[48,-0.15199999999999925,null,null,null,null,36.242696232971994,null,null,null,null,null,null,0.39436021613719047,null,14.292677519829374,null,null,null,null,null,14.292677519829374,null,null,1.4435604295027669,null,null,null,null,15.684498204406767,0.45499810339232888,"",57]
[49,-5.0999999999999268E-2,null,null,null,null,37.689774890022335,null,null,null,null,null,null,0.39842379318515947,null,15.016503075977475,null,null,null,null,null,15.016503075977475,null,null,1.5166668106737251,null,null,null,null,17.201165015080491,0.49899571895778894,"",58]
[50,5.0000000000000711E-2,null,null,null,null,37.639011826709087,null,null,null,null,null,null,0.39844391409476398,null,14.997035194893082,null,null,null,null,null,14.997035194893082,null,null,1.5147005546842014,null,null,null,null,18.715865569764691,0.54293629458901849,"",59]
[51,0.15100000000000069,null,null,null,null,36.091443592487842,null,null,null,null,null,null,0.39441996623589087,null,14.235185963153615,null,null,null,null,null,14.235185963153615,null,null,1.4377537822785151,null,null,null,null,20.153619352043208,0.58464468943572601,"",60]
[52,0.25200000000000067,null,null,null,null,33.078785414554048,null,null,null,null,null,null,0.38647405812101859,null,12.784092436877064,null,null,null,null,null,12.784092436877064,null,null,1.2911933361245835,null,null,null,null,21.44481268816779,0.62210145160899311,"",61]
[53,0.35300000000000065,null,null,null,null,28.663431197843039,null,null,null,null,null,null,0.37484486452585164,null,10.744339984201543,null,null,null,null,null,10.744339984201543,null,null,1.0851783384043561,null,null,null,null,22.529991026572148,0.65358183940218972,"",62]
[54,0.45400000000000063,null,null,null,null,22.938453525030006,null,null,null,null,null,null,0.3598757186153565,null,8.2549924462451312,null,null,null,null,null,8.2549924462451312,null,null,0.83375423707075835,null,null,null,null,23.363745263642905,0.67776856132459895,"",63]
[55,0.5550000000000006,null,null,null,null,16.027603656530051,null,null,null,null,null,null,0.3419977799876871,null,5.4814048690558135,null,null,null,null,null,5.4814048690558135,null,null,0.55362189177463716,null,null,null,null,23.917367155417541,0.69382880803897318,"",64]
[56,0.65600000000000058,null,null,null,null,8.0853115304981102,null,null,null,null,null,null,0.3217094296581981,null,2.6011209610853996,null,null,null,null,null,2.6011209610853996,null,null,0.26271321706962536,null,null,null,null,24.180080372487165,0.70144996454299136,"",65]
[57,0.75700000000000056,null,null,null,null,-0.70331423717097774,null,null,null,null,null,null,0.29955326428828344,null,-0.21068007556499035,null,null,null,null,null,0.21068007556499035,null,null,2.1278687632064027E-2,null,null,null,null,24.201359060119231,0.70206724680405519,"",66]
[58,0.85800000000000054,null,null,null,null,-10.122486352842527,null,null,null,null,null,null,0.27609216628203237,null,-2.7947391853166024,null,null,null,null,null,2.7947391853166024,null,null,0.28226865771697685,null,null,null,null,24.483627717836207,0.71025569518375775,"",67]
[59,0.95900000000000052,null,null,null,null,-19.92573884514195,null,null,null,null,null,null,0.25188590971741259,null,-5.0190128558001659,null,null,null,null,null,5.0190128558001659,null,null,0.50692029843581676,null,null,null,null,24.990548016272022,0.72496115603774702,"",68]
[60,1.0600000000000005,null,null,null,null,-29.835927064954809,null,null,null,null,null,null,0.22746963245738577,null,-6.7867673634906396,null,null,null,null,null,6.7867673634906396,null,null,0.6854635037125546,null,null,null,null,25.676011519984577,0.74484605066869192,"",69]
[61,1.1610000000000005,null,null,null,null,-39.545227685426767,null,null,null,null,null,null,0.20333528072256271,null,-8.040939972653911,null,null,null,null,null,8.040939972653911,null,null,0.81213493723804508,null,null,null,null,26.488146457222623,0.76840560936966062,"",70]
[62,1.2620000000000005,null,null,null,null,-48.715138701963653,null,null,null,null,null,null,0.17991684029544777,null,-8.7646738298117821,null,null,null,null,null,8.7646738298117821,null,null,0.88523205681099004,null,null,null,null,27.373378514033615,0.79408567268197783,"",71]
[63,1.3630000000000004,null,null,null,null,-56.976479432231379,null,null,null,null,null,null,0.15757983926216645,null,-8.9783444706551538,null,null,null,null,null,8.9783444706551538,null,null,0.90681279153617056,null,null,null,null,28.280191305569787,0.82039178046456129,"",72]
[64,1.4640000000000004,null,null,null,null,{"$f":"(1-($F$7/6)*(3*B73-B73^3)+(($D$7-3)*(3-6*B73^2+B73^4))/24)","v":-63.929390516156019},null,null,null,null,null,null,{"$f":"NORMDIST(B73,0,1,FALSE)","v":0.1366152725480389},null,{"$f":"G73*N73","v":-8.7337311091946681},null,null,null,null,null,{"$f":"ABS(P73)","v":8.7337311091946681},null,null,0.88210684202866152,null,null,null,null,29.162298147598449,{"$f":"AD73/SUM($Y$9:$Y$108)","v":0.84598118312710058},"",73]
[65,{"$f":"$B$9+A74*$A$7","v":1.5650000000000004},null,null,null,null,-69.143333915923719,null,null,null,null,null,null,0.11723778769442594,null,-8.1062115021198657,null,null,null,null,null,8.1062115021198657,null,null,{"$f":"($A$7)*V74","v":0.81872736171410654},null,null,null,null,{"$f":"Y74+AD73","v":29.981025509312555},0.86973198419963083,{"$f":"IF(AE74>0.99,\"x\",\"\")","v":""},74]
[66,1.6660000000000004,null,null,null,null,-72.157092915980812,null,null,null,null,null,null,9.9587708244748885E-2,null,-7.1859595171059336,null,null,null,null,null,7.1859595171059336,null,null,0.72578191122769931,null,null,null,null,30.706807420540255,0.89078649221011219,"",75]
[67,1.7670000000000003,null,null,null,null,-72.478772123033735,null,null,null,null,null,null,8.3736272412481758E-2,null,-6.0691022066165417,null,null,null,null,null,6.0691022066165417,null,null,0.61297932286827073,null,null,null,null,31.319786743408525,0.90856866322310736,"",76]
[68,1.8680000000000003,null,null,null,null,-69.585797466049058,null,null,null,null,null,null,6.9693338950675629E-2,null,-4.8496665689544223,null,null,null,null,null,4.8496665689544223,null,null,0.48981632346439669,null,null,null,null,31.809603066872921,0.92277794778436206,"",77]
[69,1.9690000000000003,null,null,null,null,-62.924916196253442,null,null,null,null,null,null,5.7416759943091943E-2,null,-3.6129448076794621,null,null,null,null,null,3.6129448076794621,null,null,0.36490742557562572,null,null,null,null,32.174510492448547,0.93336369840174804,"",78]
[70,2.0700000000000003,null,null,null,null,-51.91219688713376,null,null,null,null,null,null,4.6822635277683121E-2,null,-2.4306658613095409,null,null,null,null,null,2.4306658613095409,null,null,0.24549725199226363,null,null,null,null,32.420007744440809,0.94048542984567296,"",79]
[71,2.1710000000000003,null,null,null,null,-35.933029434436875,null,null,null,null,null,null,3.7795734251856623E-2,null,-1.358115231368118,null,null,null,null,null,1.358115231368118,null,null,0.13716963836817991,null,null,null,null,32.557177382808987,0.94446464068730496,"",80]
[72,2.2720000000000002,null,null,null,null,-14.342125056169852,null,null,null,null,null,null,3.0199481210634573E-2,null,-0.43312473615437275,null,null,null,null,null,0.43312473615437275,null,null,4.3745598351591648E-2,null,null,null,null,32.600922981160579,0.94573367486502213,"",81]
[73,2.3730000000000002,null,null,null,null,13.536483707400141,null,null,null,null,null,null,2.3885038190605869E-2,null,0.3233194303177665,null,null,null,null,null,0.3233194303177665,null,null,3.2655262462094416E-2,null,null,null,null,32.633578243622672,0.94668098489639163,"",82]
[74,2.4740000000000002,null,null,null,null,48.409442993745692,null,null,null,null,null,null,1.8699162668593644E-2,null,0.90521604923606158,null,null,null,null,null,0.90521604923606158,null,null,9.1426820972842229E-2,null,null,null,null,32.725005064595514,0.94933322340601412,"",83]
[75,2.5750000000000002,null,null,null,null,91.014077618079384,null,null,null,null,null,null,1.4490659157048438E-2,null,1.3188539772567394,null,null,null,null,null,1.3188539772567394,null,null,0.13320425170293068,null,null,null,null,32.858209316298442,0.95319740070379966,"",84]
[76,2.6760000000000002,null,null,null,null,142.11839107335362,null,null,null,null,null,null,1.1115369005911058E-2,null,1.5796983593067015,null,null,null,null,null,1.5796983593067015,null,null,0.15954953428997687,null,null,null,null,33.017758850588422,0.95782583921378484,"",85]
[77,2.7770000000000001,null,null,null,null,202.5210655302607,null,null,null,null,null,null,8.4397462735252959E-3,null,1.70922640811939,null,null,null,null,null,1.70922640811939,null,null,0.17263186722005841,null,null,null,null,33.190390717808484,0.96283378853715795,"",86]
[78,2.8780000000000001,null,null,null,null,273.05146183723303,null,null,null,null,null,null,6.3431452761899725E-3,null,1.7320050903096114,null,null,null,null,null,1.7320050903096114,null,null,0.17493251412127075,null,null,null,null,33.365323231929757,0.96790847827919047,"",87]
[79,2.9790000000000001,null,null,null,null,354.56961952044236,null,null,null,null,null,null,4.7189968525847836E-3,null,1.6732129185391518,null,null,null,null,null,1.6732129185391518,null,null,0.16899450477245434,null,null,null,null,33.534317736702214,0.97281090984908225,"",88]
[80,3.08,null,null,null,null,447.96625678380047,null,null,null,null,null,null,3.4750773778549375E-3,null,1.5567174049917409,null,null,null,null,null,1.5567174049917409,null,null,0.15722845790416584,null,null,null,null,33.691546194606381,0.97737201529302919,"",89]
[81,3.1810000000000009,null,null,null,null,554.16277050896099,null,null,null,null,null,null,2.5330807400485967E-3,null,1.4037390408282195,null,null,null,null,null,1.4037390408282195,null,null,0.14177764312365018,null,null,null,null,33.833323837730035,0.98148490165279634,"",90]
[82,3.282,null,null,null,null,674.11123625531161,null,null,null,null,null,null,1.8276934202903908E-3,null,1.2320686710476543,null,null,null,null,null,1.2320686710476543,null,null,0.12443893577581309,null,null,null,null,33.957762773505848,0.98509480227111812,"",91]
[83,3.3830000000000009,null,null,null,null,808.79440825998847,null,null,null,null,null,null,1.305351359820449E-3,null,1.0557608806373513,null,null,null,null,null,1.0557608806373513,null,null,0.10663184894437248,null,null,null,null,34.064394622450223,0.98818812973359804,"",92]
[84,3.484,null,null,null,null,959.22571943785897,null,null,null,null,null,null,9.2282906723667468E-4,null,0.88520137593826764,null,null,null,null,null,0.88520137593826764,null,null,8.9405338969765033E-2,null,null,null,null,34.153799961419985,0.99078172623469363,"x",93]
[85,3.5850000000000009,null,null,null,null,1126.4492813815384,null,null,null,null,null,null,6.4578041088110192E-4,null,0.72743887976729182,null,null,null,null,null,0.72743887976729182,null,null,7.3471326856496474E-2,null,null,null,null,34.227271288276484,0.99291308638009079,"x",94]
[86,3.6859999999999999,null,null,null,null,1311.5398843613732,null,null,null,null,null,null,4.4731991169886799E-4,null,0.58667790526207297,null,null,null,null,null,0.58667790526207297,null,null,5.9254468431469372E-2,null,null,null,null,34.286525756707952,0.99463202379220783,"x",95]
[87,3.7870000000000008,null,null,null,null,1515.6029973254597,null,null,null,null,null,null,3.0670535307791695E-4,null,0.46484355242065434,null,null,null,null,null,0.46484355242065434,null,null,4.6949198794486093E-2,null,null,null,null,34.333474955502439,0.99599399254179011,"x",96]
[88,3.8879999999999999,null,null,null,null,1739.7747678996229,null,null,null,null,null,null,2.0815854496572918E-4,null,0.36214898425407471,null,null,null,null,null,0.36214898425407471,null,null,3.6577047409661549E-2,null,null,null,null,34.370052002912104,0.99705507125672233,"x",97]
[89,3.9890000000000008,null,null,null,null,1985.222022387441,null,null,null,null,null,null,1.3984176379239904E-4,null,0.27761694913017326,null,null,null,null,null,0.27761694913017326,null,null,2.80393118621475E-2,null,null,null,null,34.398091314774248,0.99786847526566391,"x",98]
[90,4.09,null,null,null,null,2253.1422657702155,null,null,null,null,null,null,9.2992795718445907E-5,null,0.20952599844536601,null,null,null,null,null,0.20952599844536601,null,null,2.1162125842981969E-2,null,null,null,null,34.419253440617233,0.99848237613751989,"x",99]
[91,4.1910000000000007,null,null,null,null,2544.7636817070074,null,null,null,null,null,null,6.1211282356604617E-5,null,0.15576824825180036,null,null,null,null,null,0.15576824825180036,null,null,1.5732593073431837E-2,null,null,null,null,34.434986033690663,0.99893876944488391,"x",100]
[92,4.2919999999999998,null,null,null,null,2861.3451325345955,null,null,null,null,null,null,3.988259546153366E-5,null,0.11411787039670568,null,null,null,null,null,0.11411787039670568,null,null,1.1525904910067275E-2,null,null,null,null,34.446511938600729,0.99927312919331923,"x",101]
[93,4.3930000000000007,null,null,null,null,3204.176159267523,null,null,null,null,null,null,2.5722022324537423E-5,null,8.2417890700429805E-2,null,null,null,null,null,8.2417890700429805E-2,null,null,8.3242069607434108E-3,null,null,null,null,34.454836145561472,0.99951460956011351,"x",102]
[94,4.4939999999999998,null,null,null,null,3574.5769815980466,null,null,null,null,null,null,1.6420885402344505E-5,null,5.8697718976680045E-2,null,null,null,null,null,5.8697718976680045E-2,null,null,5.9284696166446845E-3,null,null,null,null,34.460764615178114,0.99968659099021318,"x",103]
[95,4.5950000000000006,null,null,null,null,3973.8984978961885,null,null,null,null,null,null,1.0376664891989014E-5,null,4.1235813027447256E-2,null,null,null,null,null,4.1235813027447256E-2,null,null,4.1648171157721734E-3,null,null,null,null,34.464929432293886,0.99980740989458339,"x",104]
[96,4.6960000000000015,null,null,null,null,4403.5222852096958,null,null,null,null,null,null,6.4906587297709424E-6,null,2.8581760362237203E-2,null,null,null,null,null,2.8581760362237203E-2,null,null,2.8867577965859576E-3,null,null,null,null,34.467816190090474,{"$f":"AD105/SUM($Y$9:$Y$108)","v":0.99989115304691656},"x",105]
[97,{"$f":"$B$9+A106*$A$7","v":4.7970000000000006},null,null,null,null,4864.860599264045,null,null,null,null,null,null,4.0187363995916616E-6,null,1.955059236920172E-2,null,null,null,null,null,1.955059236920172E-2,null,null,1.9746098292893737E-3,null,null,null,null,34.469790799919764,{"$f":"AD106/SUM($Y$9:$Y$108)","v":0.99994843532114408},"x",106]
[98,{"$f":"$B$9+A107*$A$7","v":4.8980000000000015},null,null,null,null,5359.3563744624898,null,null,null,null,null,null,2.4629751376704828E-6,null,1.319996150421693E-2,null,null,null,null,null,1.319996150421693E-2,null,null,1.33319611192591E-3,null,null,null,null,34.471123996031693,{"$f":"AD107/SUM($Y$9:$Y$108)","v":0.99998711055923406},"x",107]
[99,{"$f":"$B$9+A108*$A$7","v":4.9990000000000006},null,null,null,null,5888.4832238859735,null,null,null,null,null,null,1.4941709802283004E-6,null,8.7984007506916075E-3,null,null,null,null,null,8.7984007506916075E-3,null,null,{"$f":"($A$7/2)*V108","v":4.4431923790992623E-4},null,null,null,null,34.4715683152696,{"$f":"AD108/SUM($Y$9:$Y$108)","v":1},"x",108]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($AD$9:$AD$108)","v":1738.9352181297663}]

{"sheet":"10373","index":7,"n_rows":54,"n_cols":53,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Key","RTI Calculated QA\nlb/MMBtu","Run Grade","Submitted Value","Submitted Value UOM","Use ?","Comment","facility_id","configuration_id","report_id","sampling_port_id","order","pollutant_id","pollutant_name","run_id","start_datetime","end_datetime","unit_load","fuel_flow_rate","fuel_heating_value","fg_moisture_content","fg_oxygen_content","fg_CO2_content","fg_temperature","test_method","conc","conc_units","conc_ND","conc_MDL","conc2","conc2_units","emission_rate","emission_rate_units","emission_rate_ND","emission_rate_MDL","Calculated lb/MWh at Prom","Boiler Heat Rate (lb/MMBtu)/MWh","Calculated lb/MMBtu at Prom","Calculated conc lb/dscf","19-1\nlb/MMBtu","%diff","19-6\nlb/MMBtu","%diff","emission_factor","emission_factor_units","emission_factor_ND","emission_factor_MDL","run_pollutant_comment","Fuel1","Fuel1%Btu","Fuel2","Fuel2%Btu","QA Comment"]
["5_SO2_T2_R1",{"$f":"AN5","v":3.378784698994413E-2},"A",{"$f":"AF2","v":9.91},{"$f":"AG2","v":"pound per hour (lb/hr)"},"Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2005-12-08T17:33:00","2005-12-08T18:33:00",27.6,20892,13664,null,4.58,14.6,295.39999999999998,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.68,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",9.91,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T2_R2",{"$f":"AN6","v":3.4399391731843573E-2},"A",{"$f":"AF3","v":10.130000000000001},"pound per hour (lb/hr)","Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2005-12-08T18:52:00","2005-12-08T19:52:00",27.6,20832,13664,null,4.57,14.72,295.5,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",18,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.130000000000001,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T2_R3",3.4112730134078222E-2,"A",10.15,"pound per hour (lb/hr)","Yes",null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2005-12-08T20:09:00","2005-12-08T21:09:00",27.7,20892,13664,null,4.41,14.78,295.5,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.850000000000001,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.15,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,null,null,null,null,null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","4","2005-12-08T17:33:00","2005-12-08T18:33:00",27.6,20892,13664,"ND",4.58,14.6,295.39999999999998,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.68,null,false,null,null,null,null,null,null,null,{"$f":"AF2/R2","v":0.35905797101449272},10.716925351071692,{"$f":"AJ5/AK5","v":3.3503823088455766E-2},{"$f":"Z2*$J$39","v":2.9348799999999999E-6},{"$f":"AM5*$I$53*20.9/(20.9-3)","v":3.378784698994413E-2},{"$f":"(AL5-AN5)/AL5","v":-8.4773579641491438E-3},{"$f":"AM5*$K$53*100/W2","v":3.8394663013698628E-2},{"$f":"(AL5-AP5)/AL5","v":-0.14597856227721287},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2)","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","5","2005-12-08T18:52:00","2005-12-08T19:52:00",27.6,20832,13664,"ND",4.57,14.72,295.5,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",18,null,false,null,null,null,null,null,null,null,{"$f":"AF3/R3","v":0.36702898550724639},10.716925351071692,{"$f":"AJ6/AK6","v":3.4247601199400304E-2},{"$f":"Z3*$J$39","v":2.988E-6},{"$f":"AM6*$I$53*20.9/(20.9-3)","v":3.4399391731843573E-2},{"$f":"(AL6-AN6)/AL6","v":-4.4321507821670977E-3},{"$f":"AM6*$K$53*100/W3","v":3.8770923913043473E-2},{"$f":"(AL6-AP6)/AL6","v":-0.13207706686687226},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2005 Emission Compliance and RATA Report\\05015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","6","2005-12-08T20:09:00","2005-12-08T21:09:00",27.7,20892,13664,"ND",4.41,14.78,295.5,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",17.850000000000001,null,false,null,null,null,null,null,null,null,{"$f":"AF4/R4","v":0.36642599277978344},10.716925351071692,{"$f":"AJ7/AK7","v":3.4191335740072208E-2},{"$f":"Z4*$J$39","v":2.9631000000000005E-6},{"$f":"AM7*$I$53*20.9/(20.9-3)","v":3.4112730134078222E-2},{"$f":"(AL7-AN7)/AL7","v":2.2989919607574998E-3},{"$f":"AM7*$K$53*100/W4","v":3.8291752368064959E-2},{"$f":"(AL7-AP7)/AL7","v":-0.11992560510547902},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages",null,{"$f":"AVERAGE(AL5:AL7)","v":3.3980920009309433E-2}]
["5_SO2_T3_R1",{"$f":"AN12","v":2.904837524022346E-2},"A",{"$f":"AF9","v":9.11},{"$f":"AG9","v":"pound per hour (lb/hr)"},"Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2006-12-19T14:05:00","2006-12-19T15:11:00",28.7,21660,14145,9.24,5.13,14.35,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",9.11,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T3_R2",{"$f":"AN13","v":2.6583085499441345E-2},"A",{"$f":"AF10","v":8.3000000000000007},"pound per hour (lb/hr)","Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2006-12-19T15:23:00","2006-12-19T16:23:00",28.7,21665,14145,9.1159999999999997,5.22,14.35,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.91,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",8.3000000000000007,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T3_R3",2.5149777510614525E-2,"A",7.85,"pound per hour (lb/hr)","Yes",null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2006-12-19T16:34:00","2006-12-19T17:34:00",28.7,21666,14145,8.92,5.26,14.26,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.16,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",7.85,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,null,null,null,null,null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","4","2006-12-19T14:05:00","2006-12-19T15:11:00",28.7,21660,14145,9.24,5.13,14.35,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.2,null,false,null,null,null,null,null,null,null,{"$f":"AF9/R9","v":0.31742160278745646},10.716925351071692,{"$f":"AJ12/AK12","v":2.9618719211822662E-2},{"$f":"Z9*$J$39","v":2.5231999999999998E-6},{"$f":"AM12*$I$53*20.9/(20.9-3)","v":2.904837524022346E-2},{"$f":"(AL12-AN12)/AL12","v":1.9256199686431472E-2},{"$f":"AM12*$K$53*100/W9","v":3.358405574912892E-2},{"$f":"(AL12-AP12)/AL12","v":-0.13387940609273366},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","5","2006-12-19T15:23:00","2006-12-19T16:23:00",28.7,21665,14145,9.1159999999999997,5.22,14.35,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.91,null,false,null,null,null,null,null,null,null,{"$f":"AF10/R10","v":0.28919860627177701},10.716925351071692,{"$f":"AJ13/AK13","v":2.6985221674876849E-2},{"$f":"Z10*$J$39","v":2.3090600000000002E-6},{"$f":"AM13*$I$53*20.9/(20.9-3)","v":2.6583085499441345E-2},{"$f":"(AL13-AN13)/AL13","v":1.490208901303528E-2},{"$f":"AM13*$K$53*100/W10","v":3.0733829965156799E-2},{"$f":"(AL13-AP13)/AL13","v":-0.13891337767923143},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2006 Emission Compliance and RATA Report\\06015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","6","2006-12-19T16:34:00","2006-12-19T17:34:00",28.7,21666,14145,8.92,5.26,14.26,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",13.16,null,false,null,null,null,null,null,null,null,{"$f":"AF11/R11","v":0.27351916376306618},10.716925351071692,{"$f":"AJ14/AK14","v":2.5522167487684728E-2},{"$f":"Z11*$J$39","v":2.18456E-6},{"$f":"AM14*$I$53*20.9/(20.9-3)","v":2.5149777510614525E-2},{"$f":"(AL14-AN14)/AL14","v":1.4590844498214874E-2},{"$f":"AM14*$K$53*100/W11","v":2.9260235624123422E-2},{"$f":"(AL14-AP14)/AL14","v":-0.14646358457769831},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages",null,{"$f":"AVERAGE(AL12:AL14)","v":2.7375369458128077E-2}]
["5_SO2_T4_R1",{"$f":"AN19","v":2.459556508826816E-2},"B",{"$f":"AF16","v":6.82},{"$f":"AG16","v":"pound per hour (lb/hr)"},"Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","7","2007-11-27T13:01:00","2007-11-27T14:05:00",28.1,21076,14211,7.556,5.2,14.25,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.87,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",6.82,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T4_R2",{"$f":"AN20","v":2.3257810965363127E-2},"B",{"$f":"AF17","v":6.4160000000000004},"pound per hour (lb/hr)","Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","8","2007-11-27T14:20:00","2007-11-27T15:20:00",28.2,21086,14211,7.61,5.21,13.93,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.17,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",6.4160000000000004,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T4_R3",2.7232851787709497E-2,"B",7.6059999999999999,"pound per hour (lb/hr)","Yes",null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","9","2007-11-27T15:33:00","2007-11-27T16:33:00",28.4,21240,14211,7.26,5.09,13.93,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",14.25,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",7.6059999999999999,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,null,null,null,null,null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","7","2007-11-27T13:01:00","2007-11-27T14:05:00",28.1,21076,14211,7.556,5.2,14.25,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.87,null,false,null,null,null,null,null,null,null,{"$f":"AF16/R16","v":0.24270462633451956},10.716925351071692,{"$f":"AJ19/AK19","v":2.2646852374524479E-2},{"$f":"Z16*$J$39","v":2.1364200000000001E-6},{"$f":"AM19*$I$53*20.9/(20.9-3)","v":2.459556508826816E-2},{"$f":"(AL19-AN19)/AL19","v":-8.6047839298665357E-2},{"$f":"AM19*$K$53*100/W16","v":2.8635524210526318E-2},{"$f":"(AL19-AP19)/AL19","v":-0.26443727088266428},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","8","2007-11-27T14:20:00","2007-11-27T15:20:00",28.2,21086,14211,7.61,5.21,13.93,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.17,null,false,null,null,null,null,null,null,null,{"$f":"AF17/R17","v":0.22751773049645391},10.716925351071692,{"$f":"AJ20/AK20","v":2.122975788701394E-2},{"$f":"Z17*$J$39","v":2.0202199999999999E-6},{"$f":"AM20*$I$53*20.9/(20.9-3)","v":2.3257810965363127E-2},{"$f":"(AL20-AN20)/AL20","v":-9.5528789783784082E-2},{"$f":"AM20*$K$53*100/W17","v":2.7700073223259153E-2},{"$f":"(AL20-AP20)/AL20","v":-0.30477574782909084},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2007 Emission Compliance and RATA Report\\07015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","9","2007-11-27T15:33:00","2007-11-27T16:33:00",28.4,21240,14211,7.26,5.09,13.93,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",14.25,null,false,null,null,null,null,null,null,null,{"$f":"AF18/R18","v":0.26781690140845071},10.716925351071692,{"$f":"AJ21/AK21","v":2.4990087421078194E-2},{"$f":"Z18*$J$39","v":2.3655000000000001E-6},{"$f":"AM21*$I$53*20.9/(20.9-3)","v":2.7232851787709497E-2},{"$f":"(AL21-AN21)/AL21","v":-8.9746159300732015E-2},{"$f":"AM21*$K$53*100/W18","v":3.2434350323043787E-2},{"$f":"(AL21-AP21)/AL21","v":-0.29788862986075981},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages",null,{"$f":"AVERAGE(AL19:AL21)","v":2.2955565894205537E-2}]
["5_SO2_T5_R1",{"$f":"AN26","v":2.4461789675977653E-2},"A",{"$f":"AF23","v":8.43},{"$f":"AG23","v":"pound per hour (lb/hr)"},"Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2008-11-20T09:05:00","2008-11-20T10:05:00",28.4,20241,13690,10.71,3.87,15.33,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.8,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",8.43,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T5_R2",{"$f":"AN27","v":3.0768344826815643E-2},"B",{"$f":"AF24","v":10.73},"pound per hour (lb/hr)","Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2008-01-20T10:19:00","2008-01-20T11:19:00",28.5,20391,13690,10.63,3.67,15.54,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",16.100000000000001,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.73,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T5_R3",2.943059070391062E-2,"A",10.07,"pound per hour (lb/hr)","Yes",null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2008-01-20T11:28:00","2008-01-20T12:28:00",28.5,20295,13690,11,3.9,15.22,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.4,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",10.07,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,null,null,null,null,null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","4","2008-11-20T09:05:00","2008-11-20T10:05:00",28.4,20241,13690,10.71,3.87,15.33,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",12.8,null,false,null,null,null,null,null,null,null,{"$f":"AF23/R23","v":0.29683098591549295},10.716925351071692,{"$f":"AJ26/AK26","v":2.7697401651287031E-2},{"$f":"Z23*$J$39","v":2.1248E-6},{"$f":"AM26*$I$53*20.9/(20.9-3)","v":2.4461789675977653E-2},{"$f":"(AL26-AN26)/AL26","v":0.11682005467682657},{"$f":"AM26*$K$53*100/W23","v":2.6473372472276581E-2},{"$f":"(AL26-AP26)/AL26","v":4.4192924463496472E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","5","2008-01-20T10:19:00","2008-01-20T11:19:00",28.5,20391,13690,10.63,3.67,15.54,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",16.100000000000001,null,false,null,null,null,null,null,null,null,{"$f":"AF24/R24","v":0.37649122807017543},10.716925351071692,{"$f":"AJ27/AK27","v":3.5130526315789473E-2},{"$f":"Z24*$J$39","v":2.6726000000000005E-6},{"$f":"AM27*$I$53*20.9/(20.9-3)","v":3.0768344826815643E-2},{"$f":"(AL27-AN27)/AL27","v":0.12417068420102889},{"$f":"AM27*$K$53*100/W24","v":3.2848558558558567E-2},{"$f":"(AL27-AP27)/AL27","v":6.4956833743913242E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2008 Emission Compliance and RATA Report\\08015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","6","2008-01-20T11:28:00","2008-01-20T12:28:00",28.5,20295,13690,11,3.9,15.22,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",15.4,null,false,null,null,null,null,null,null,null,{"$f":"AF25/R25","v":0.35333333333333333},10.716925351071692,{"$f":"AJ28/AK28","v":3.2969655172413792E-2},{"$f":"Z25*$J$39","v":2.5564000000000002E-6},{"$f":"AM28*$I$53*20.9/(20.9-3)","v":2.943059070391062E-2},{"$f":"(AL28-AN28)/AL28","v":0.10734308411767558},{"$f":"AM28*$K$53*100/W25","v":3.2080972404730616E-2},{"$f":"(AL28-AP28)/AL28","v":2.6954566647295421E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages",null,{"$f":"AVERAGE(AL26:AL28)","v":3.1932527713163433E-2}]
["5_SO2_T6_R1",{"$f":"AN33","v":5.5803457698324017E-2},"A",{"$f":"AF30","v":18.43},{"$f":"AG30","v":"pound per hour (lb/hr)"},"Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","4","2009-12-10T08:04:00","2009-12-10T09:04:00",27.2,20094,13970,11.4,4.3,14.95,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",29.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",18.43,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T6_R2",{"$f":"AN34","v":5.0070225743016762E-2},"A",{"$f":"AF31","v":16.7},"pound per hour (lb/hr)","Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","5","2009-12-10T09:21:00","2009-12-10T10:21:00",28.2,20386,13970,11.32,4.04,15.28,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",16.7,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
["5_SO2_T6_R3",5.0070225743016762E-2,"A",16.7,"pound per hour (lb/hr)","Yes",null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",3,6,"Sulfur Dioxide (SO2)","6","2009-02-10T10:37:00","2009-02-10T11:37:00",27.6,20112,13970,12.26,4.1100000000000003,15.17,null,"EPA 7E\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,"parts per million by volume (dry) (ppmvd @ 3% O2)",false,null,null,"",16.7,"pound per hour (lb/hr)",false,null,null,null,null,null,null,null,null,null,null,"",false,null,""]
[null,null,null,null,null,null,null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","4","2009-12-10T08:04:00","2009-12-10T09:04:00",27.2,20094,13970,11.4,4.3,14.95,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",29.2,null,false,null,null,null,null,null,null,null,{"$f":"AF30/R30","v":0.67757352941176474},10.716925351071692,{"$f":"AJ33/AK33","v":6.3224619675456395E-2},{"$f":"Z30*$J$39","v":4.8471999999999999E-6},{"$f":"AM33*$I$53*20.9/(20.9-3)","v":5.5803457698324017E-2},{"$f":"(AL33-AN33)/AL33","v":0.1173777242983282},{"$f":"AM33*$K$53*100/W30","v":6.1927438127090305E-2},{"$f":"(AL33-AP33)/AL33","v":2.0517032052146167E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","5","2009-12-10T09:21:00","2009-12-10T10:21:00",28.2,20386,13970,11.32,4.04,15.28,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,null,false,null,null,null,null,null,null,null,{"$f":"AF31/R31","v":0.59219858156028371},10.716925351071692,{"$f":"AJ34/AK34","v":5.5258253851797508E-2},{"$f":"Z31*$J$39","v":4.3491999999999998E-6},{"$f":"AM34*$I$53*20.9/(20.9-3)","v":5.0070225743016762E-2},{"$f":"(AL34-AN34)/AL34","v":9.3886935383355102E-2},{"$f":"AM34*$K$53*100/W31","v":5.4364999999999997E-2},{"$f":"(AL34-AP34)/AL34","v":1.6165075613739362E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,10373,"1A","2009 Emission Compliance and RATA Report\\09015.4c","Stack",null,null,"Sulfur Dioxide (SO2)","6","2009-02-10T10:37:00","2009-02-10T11:37:00",27.6,20112,13970,12.26,4.1100000000000003,15.17,null,"EPA 7E\r\nCalifornia South Coast AQMD 6.1 (non-isokinetic) for SOx",26.2,null,false,null,null,null,null,null,null,null,{"$f":"AF32/R32","v":0.60507246376811585},10.716925351071692,{"$f":"AJ35/AK35","v":5.6459520239880052E-2},{"$f":"Z32*$J$39","v":4.3491999999999998E-6},{"$f":"AM35*$I$53*20.9/(20.9-3)","v":5.0070225743016762E-2},{"$f":"(AL35-AN35)/AL35","v":0.11316593675817718},{"$f":"AM35*$K$53*100/W32","v":5.4759208965062617E-2},{"$f":"(AL35-AP35)/AL35","v":3.0115581350909616E-2},null,null,null,null,"parts per million by volume (dry) (ppmvd @ 3% O2).","petroleum coke",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Averages from Prom",null,null,"Averages",null,{"$f":"AVERAGE(AL33:AL35)","v":5.8314131255711311E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2646852374524466E-2]
[null,null,null,null,null,null,null,"Conversions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1229757887013926E-2]
[null,null,null,null,null,null,null,1,"ppm SO2=",1.66E-7,"lb/scf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4990087421078177E-2]
[null,null,null,null,null,null,null,1,"ppm Hg=",{"$f":"J39*H45/H46","v":5.1979300655635339E-7},"lb/scf"]
[null,null,null,null,null,null,null,1000,"mg=",1,"g"]
[null,null,null,null,null,null,null,1000000,"ug=",1,"g"]
[null,null,null,null,null,null,null,454,"g=",1,"lb"]
[null,null,null,null,null,null,null,1,"m^3=",35.314500000000002,"ft^3"]
[null,null,null,null,null,null,null,200.59,"Hg molecular weight"]
[null,null,null,null,null,null,null,64.06,"SO2 molecular weight"]
[]
[null,null,null,null,null,null,null,"Table 19-2","Fd","Fw","Fc"]
[null,null,null,null,null,null,null,"Fuel Type","dscf/MMBtu","wscf/MMBtu","scf/MMBtu"]
[null,null,null,null,null,null,null,"Coal"]
[null,null,null,null,null,null,null,"Anthracite",10100,10540,1970]
[null,null,null,null,null,null,null,"Bituminous",9780,40640,1800]
[null,null,null,null,null,null,null,"Lignite",9860,11950,1910]
[null,null,null,null,null,null,null,"Oil",9190,10320,1420]

{"sheet":"ETTS_Other","index":8,"n_rows":22,"n_cols":64,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,30,2,33],[2,34,2,37],[2,38,2,41]]}
[null,null,null,null,null,null,null,"facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","RTI Calculation","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility","facility"]
["Key","RTI Calculated QA\nlb/MMBtu","Run Grade","Submitted Value","Submitted Value UOM","Use ?","Comment","facility_id","configuration_id","submittal_id","pollutant","run_number","start_date","end_date","measured_value_ppm","measured_value_NO","measured_value_NO2","measured_TDS","measured_TSS","basis","test_method","data_flag","method_comments","emission_rate","emission_rate_ppmdv","steam_output","heat_input","fg_moisture_content","fg_CO2_content","fg_oxygen_content","19-1","19-5","19-6","19-9","19-1","19-5","19-6","19-9","19-1","19-5","19-6","19-9","fg_flow_rate","fg_temperature","fuel1_input_rate","fuel1_type","fuel1_rate_units","fuel1_method","fuel2_input_rate","fuel2_type","fuel2_rate_units","fuel2_method","fuel3_input_rate","fuel3_type","fuel3_rate_units","fuel3_method","fuel4_input_rate","fuel4_type","fuel4_rate_units","fuel4_method","other_information","exclude_data","QA Comment","Questions for EPA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"using ppmdv; column R",null,null,null,"using ppm ; column H",null,null,null,"using ppm ; column H"]
["5_SO2_T1_R1",{"$f":"AM4","v":"O4*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD4)"},"A",{"$f":"X4","v":5.9586603969999999E-2},"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","1","2010-05-18","2010-05-18","29.61","","","","","Dry","","","Plant Monitor",5.9586603969999999E-2,"24.25","218.82","277","13.1","15.5","3.8","Y4*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD4)","Y4*$J$11*20.9/((20.9-AD4)/(1-AB4/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"Y4*$J$11*$K$18*100/AC4","v":4.9604548387096777E-2},{"$f":"Y4*$J$11*$K$18*100/AC4*(1-AB4/100)","v":4.31063525483871E-2},{"$f":"O4*$J$11*$I$19*20.9/(20.9-AD4)","v":5.9054118200000005E-2},{"$f":"O4*$J$11*20.9/((20.9-AD4)/(1-AB4/100))*$I$19","v":5.1318028715799997E-2},{"$f":"O4*$J$11*$K$19*100/AC4","v":5.8666006451612907E-2},{"$f":"K4*$J$11*$K$18*100/Y4*(1-X4/100)","v":{"$error":"#VALUE!"}},"O4*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD4)","O4*$J$11*20.9/((20.9-AD4)/(1-AB4/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"O4*$J$11*$K$18*100/AC4","v":6.0568687741935481E-2},{"$f":"O4*$J$11*$K$18*100/AC4*(1-AB4/100)","v":5.2634189647741934E-2},"68553","343","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
["5_SO2_T1_R2",{"$f":"AM5","v":"=O5*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD5)"},"A",{"$f":"X5","v":5.9106435633999997E-2},"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","2","2010-05-19","2010-05-19","29.38","","","","","Dry","","","Plant Monitor",5.9106435633999997E-2,"24.05","223.54","279.1","12.2","15.9","3.8",{"$f":"Y5*$J$11*20.9/(20.9-AD5)","v":4.8794777777777776E-6},"Y5*$J$11*20.9/((20.9-AD5)/(1-AB5/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"Y5*$J$11*$K$18*100/AC5","v":4.7957817610062889E-2},{"$f":"Y5*$J$11*$K$18*100/AC5*(1-AB5/100)","v":4.2106963861635219E-2},{"$f":"O5*$J$11*$I$19*20.9/(20.9-AD5)","v":5.859540671111111E-2},{"$f":"O5*$J$11*20.9/((20.9-AD5)/(1-AB5/100))*$I$19","v":5.1446767092355558E-2},{"$f":"O5*$J$11*$K$19*100/AC5","v":5.6745899371069178E-2},{"$f":"K5*$J$11*$K$18*100/Y5*(1-X5/100)","v":{"$error":"#VALUE!"}},"=O5*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD5)","O5*$J$11*20.9/((20.9-AD5)/(1-AB5/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"O5*$J$11*$K$18*100/AC5","v":5.8586306918238996E-2},{"$f":"O5*$J$11*$K$18*100/AC5*(1-AB5/100)","v":5.143877747421384E-2},"66623","341","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
["5_SO2_T1_R3","O6*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD6)","A",5.7757391262000003E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","3","2010-05-20","2010-05-20","28.7","","","","","Dry","","","Plant Monitor",5.7757391262000003E-2,"23.5","221.24","275","12","15.8","3.9",{"$f":"Y6*$J$11*20.9/(20.9-AD6)","v":4.7959352941176474E-6},"Y6*$J$11*20.9/((20.9-AD6)/(1-AB6/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"Y6*$J$11*$K$18*100/AC6","v":4.71576582278481E-2},{"$f":"Y6*$J$11*$K$18*100/AC6*(1-AB6/100)","v":4.149873924050633E-2},5.7575917494117647E-2,5.0666807394823536E-2,5.5783354430379746E-2,{"$error":"#VALUE!"},"O6*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD6)","=O6*$J$11*20.9/((20.9-AD6)/(1-AB6/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",5.7592544303797462E-2,5.0681438987341766E-2,"67896","344","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
["5_SO2_T1_R4","O7*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD7)","A",5.4121831003999997E-2,"lb/MMBtu","Yes",null,10373,"1A",1265,"SO2","4","2010-05-21","2010-05-21","26.9","","","","","Dry","","","Plant Monitor",5.4121831003999997E-2,"22.02","220.29","273.6","11.7","15.7","3.9",{"$f":"Y7*$J$11*20.9/(20.9-AD7)","v":4.4938934117647058E-6},"Y7*$J$11*20.9/((20.9-AD7)/(1-AB7/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",{"$f":"Y7*$J$11*$K$18*100/AC7","v":4.4469179617834399E-2},{"$f":"Y7*$J$11*$K$18*100/AC7*(1-AB7/100)","v":3.9266285602547774E-2},5.3964884341176467E-2,4.7650992873258823E-2,5.2617770700636939E-2,{"$error":"#VALUE!"},"O7*$J$11*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11*20.9/(20.9-AD7)","=O7*$J$11*20.9/((20.9-AD7)/(1-AB7/100))*'\\\\rtifile02.rcc_nt.rti.org\\ehe\\Projects\\0213199-EPA_SPPD_(Base)\\0213199.000.002-EGU_MACT\\Data_and_Tools\\New_Floors\\Deliverable_Files\\Data_Workbooks\\[DRAFT_Runs_QA_Top9.xlsm]10373_1A_ERT_Data'!$AP$11",5.432429299363057E-2,4.7968350713375796E-2,"68376","343","NA","petroleum coke","MMBtu/hr","F-Factor","","","","","","","","","","","","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Fd from ERT used","*Fd from ERT used","*Fc for lignite used","*Fc for lignite used","*Fd from ERT used","*Fd from ERT used","*Fc for lignite used","*Fc for lignite used","*Fd from ERT used","*Fd from ERT used","*Fc for lignite used","*Fc for lignite used"]
[]
[null,null,null,null,null,null,null,"Conversions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X4/O4/$J$11/20.9*(20.9-AD4)","v":9918.6362421223985}]
[null,null,null,null,null,null,null,1,"ppm SO2",1.66E-7,"lb/scf"]
[]
[null,null,null,null,null,null,null,"Table 19-2","Fd","Fw","Fc"]
[null,null,null,null,null,null,null,"Fuel Type","dscf/MMBtu","wscf/MMBtu","scf/MMBtu"]
[null,null,null,null,null,null,null,"Coal"]
[null,null,null,null,null,null,null,"Anthracite",10100,10540,1970]
[null,null,null,null,null,null,null,"Bituminous",9780,40640,1800]
[null,null,null,null,null,null,null,"Lignite",9860,11950,1910]
[null,null,null,null,null,null,null,"Petcoke",9830,null,1850]
[null,null,null,null,null,null,null,"Oil",9190,10320,1420]
[]
[null,null,null,null,null,null,null,"*petcoke F factor for this unit was taken from other ERT provided tests"]

{"sheet":"10373_1a_ERT_Data","index":9,"n_rows":11,"n_cols":46,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["submittal_id","Location","RunDate","Method","RunNumber","RunStartTime","RunEndTime","NetTravPts","NetRunTime","Dn","Cp","Y","Pb","DeltaH","Vm","tm","Vmstd","Vlc","Vwstd","PercH20","PercH20sat","Mfd","PercCO2","PercO2","PercCOplusN2","Fo","Md","Ms","Pg","Ps","ts","DeltaPavg","Vs","Dstk","Dwdth","Dlngth","As","Qsd","Qaw","PercI","PercEA","Fd","Fc","Fw","MMBtuHr","FuelType"]
[1260,"Baghouse outlet","2010-05-18","Method 23","1","17:30","01:30",24,480,0.17499999999999999,0.84,0.96699999999999997,30.18,"1.25","316.512","100.13","291.904",936.7,"44.09","13.12","100.00",0.86880000000000002,15.5,3.8,80.7,"1.10","30.63","28.97",1.9,"30.32","343.42","2.218","102.28",59.5,0,0,"19.309","68,561.5","118,495.5","102.5","21.7",9827,0,0,"342.499884363119","Override"]
[1260,"Baghouse outlet","2010-05-19","Method 23","2","16:20","00:20",24,480,0.17499999999999999,0.84,0.96699999999999997,30.22,"1.32","317.595","91.46","297.951",941.3,"44.31","12.95","100.00",0.87050000000000005,16,3.7,80.3,"1.08","30.71","29.06",1.9,"30.36","339.63","2.350","104.80",59.5,0,0,"19.309","70,815.1","121,415.0","101.3","21.1",9768,0,0,"357.975770899216","Override"]
[1260,"Baghouse outlet","2010-05-20","Method 23","3","16:20","00:20",24,480,0.17499999999999999,0.84,0.96699999999999997,29.9,"1.28","315.328","76.58","300.790",920.8,"43.34","12.59","100.00",0.87409999999999999,15.7,4,80.3,"1.08","30.67","29.07",1.9,"30.04","343.83","2.357","105.78",59.5,0,0,"19.309","70,645.4","122,550.4","102.5","23.3",9930,0,0,"345.1646482314","Override"]
[1260,"Baghouse outlet","2010-05-21","Method 29","1","12:20","16:20",24,240,0.17499999999999999,0.84,0.96699999999999997,29.92,"1.21","150.560","75.92","143.866",428.8,"20.18","12.30","100.00",0.877,15.8,3.8,80.400000000000006,"1.08","30.68","29.12",1.9,"30.06","348.38","2.259","103.72",59.5,0,0,"19.309","69,154.3","120,163.8","100.2","21.8",9856,0,0,"344.444749852421","Override"]
[1260,"Baghouse outlet","2010-05-21","Method 29","2","16:50","20:50",24,240,0.17499999999999999,0.84,0.96699999999999997,29.9,"1.25","151.526","82.71","142.897",413,"19.44","11.98","100.00",0.88019999999999998,15.8,3.8,80.400000000000006,"1.08","30.68","29.16",1.9,"30.04","338.54","2.265","103.19",59.5,0,0,"19.309","69,856.3","119,549.7","98.5","21.8",9861,0,0,"347.764858810189","Override"]
[1260,"Baghouse outlet","2010-05-21","Method 29","3","21:20","01:20",24,240,0.17499999999999999,0.84,0.96699999999999997,29.9,"1.20","149.318","61.35","146.566",415,"19.53","11.76","100.00",0.88239999999999996,16,3.8,80.2,"1.07","30.71","29.22",1.9,"30.04","337.92","2.224","102.11",59.5,0,0,"19.309","69,351.8","118,298.5","101.8","21.9",9838,0,0,"346.060470531705","Override"]
[1260,"Baghouse outlet","2010-05-20","OTM - 27/28","1","18:26","00:26",24,360,0.13600000000000001,0.84,0.97699999999999998,30.06,"0.44","130.663","87.79","123.755",364.9,"17.18","12.19","100.00",0.87809999999999999,15.7,4,80.3,"1.08","30.67","29.13",1.9,"30.20","347.63","1.960","96.33",59.5,0,0,"19.309","64,667.1","111,602.2","101.7","23.3",9930,0,0,"315.955417106347","Override"]
[1260,"Baghouse outlet","2010-05-21","OTM - 27/28","2","14:16","20:16",24,360,0.13600000000000001,0.84,0.97699999999999998,29.92,"0.44","130.594","76.46","125.714",333.5,"15.70","11.10","100.00",0.88900000000000001,15.6,4.0999999999999996,80.300000000000011,"1.08","30.66","29.25",1.9,"30.06","340.54","2.103","99.37",59.5,0,0,"19.309","67,818.2","115,124.1","98.6","24.0",9852,0,0,"331.998484751354","Override"]
[1260,"Baghouse outlet","2010-05-21","OTM - 27/28","3","21:04","03:04",24,360,0.13600000000000001,0.84,0.97699999999999998,29.9,"0.44","128.921","79.58","123.304",329.1,"15.49","11.16","100.00",0.88839999999999997,15.6,4.0999999999999996,80.300000000000011,"1.08","30.66","29.25",1.9,"30.04","349.29","1.998","97.42",59.5,0,0,"19.309","65,680.4","112,865.0","99.8","24.0",9852,0,0,"321.53305864595","Override"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AP2:AP10)","v":9857.1111111111113}]

{"sheet":"Promulgated Min Data","index":10,"n_rows":10,"n_cols":58,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["primary_fuel","ORIS code","Plant Name","physical_state","Unit Number","boiler_id","Unit Type","boiler_type","MWe_capacity","max_heat_input","Boiler_heat_rate","Fuel types","Sulfur Dioxide - CEMS","Sulfur Dioxide MW - CEMS","Sulfur Dioxide - ERT","Sulfur Dioxide MW - ERT","Sulfur Dioxide - ETTS","Sulfur Dioxide MW - ETTS","Sulfur Dioxide - Part II","Sulfur Dioxide MW - Part II","Sulfur Dioxide - min","Sulfur Dioxide MW - min","control_group_1","control_type_1","install_date_1","control_group_2","control_type_2","install_date_2","control_group_3","control_type_3","install_date_3","control_group_4","control_type_4","install_date_4","control_group_5","control_type_5","install_date_5","control_group_6","control_type_6","install_date_6","control_group_7","control_type_7","install_date_7","control_group_8","control_type_8","install_date_8","control_group_9","control_type_9","install_date_9","control_group_10","control_type_10","install_date_10","control_group_11","control_type_11","install_date_11","control_group_12","control_type_12","install_date_12"]
[null,null,null,null,null,null,null,null,"MW","MMBtu/hr","Mmbtu/MWh",null,"lb/MMBtu","lb/MW","lb/MMBtu","lb/MW","lb/MMBtu","lb/MW","lb/MMBtu","lb/MW","lb/MMBtu","lb/MW"]
["petroleum coke",667,"Northside Generating Station","FL","1A","1A","Fluidized bed firing","Fluidized bed firing",310,2764,8.9161290322580644,"petroleum coke,  bituminous",5.8933333333333331E-2,0.63158413402315838,null,null,5.7643065467499997E-2,0.61775642962213595,2.295556589420554E-2,0.24601308607980807,2.295556589420554E-2,0.24601308607980807,"PM control","Fabric Filter, pulse","1991-08-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",667,"Northside Generating Station","FL","2A","2A","Fluidized bed firing","Fluidized bed firing",310,2764,8.9161290322580644,"petroleum coke,  bituminous",null,null,null,null,2.9299999999999996E-2,0.50591333333333321,0.39234199070264647,6.7744383727990289,2.9299999999999996E-2,0.50591333333333321,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",2878,"Bay Shore","OH","Unit 1","1","Fluidized bed firing","Fluidized bed firing",151,1218,8.0662251655629138,"petroleum coke",null,null,null,null,2.9299999999999996E-2,0.50591333333333321,0.39234199070264647,6.7744383727990289,2.9299999999999996E-2,0.50591333333333321,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",4125,"Manitowoc","WI","B-09","9","Fluidized bed firing","Fluidized bed firing",63.37,1244,19.630740097838096,"petroleum coke,  subbituminous,  other--wood charcoal/paper pellets",0.15213333333333329,1.3564404301075264,0.15143911649186662,1.350250703172643,null,null,null,null,0.15143911649186662,1.350250703172643,"NOx control","Selective Noncatalytic Reduction","2002-05-01","SO2 control","Dry FGD - Spray Dryer","2002-05-01","PM control","Fabric Filter, pulse","2002-05-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",10373,"Hanford","CA","1A","CB1302","Fluidized bed firing","Fluidized bed firing",27.06,290,10.716925351071692,"petroleum coke",0.1724,1.5371406451612903,0.17129887129394852,1.527322839537012,null,null,null,null,0.17129887129394852,1.527322839537012,"NOx control","Selective Noncatalytic Reduction","2002-02-01","SO2 control","Dry FGD - Spray Dryer","2002-02-01","PM control","Fabric Filter, pulse","2002-02-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",10670,"AES Deepwater","TX","Deepwater","AAB001","Conventional Boiler","Arch firing",158,1817.6,11.50379746835443,"petroleum coke",null,null,0.37722146674132168,3.0427532880194028,null,null,null,null,0.37722146674132168,3.0427532880194028,"PM control","Fabric Filter, unspecified","2000-12-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",50931,"Yellowstone Energy LP","MT","Config1","BLR1","Fluidized bed firing","Fluidized bed firing",30,518,17.266666666666666,"petroleum coke",null,null,0.27242932742659298,5.3479893217402825,null,null,null,null,0.27242932742659298,5.3479893217402825,"NOx control","Selective Noncatalytic Reduction",null,"PM control","Fabric Filter, pulse",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["petroleum coke",50931,"Yellowstone Energy LP","MT","Config1","BLR2","Fluidized bed firing","Fluidized bed firing",30,518,17.266666666666666,"petroleum coke",0.60478260869565215,6.9572966428178304,null,null,null,null,null,null,0.60478260869565215,6.9572966428178304,"NOx control","Selective Catalytic Reduction","2007-03-01","PM control","Electrostatic precipitator, cold side, w/o flue gas conditioning","1985-08-01","SO2 control","Wet FGD - Spray Type","1985-08-01","Other control","Wet electrostatic precipitator","1985-08-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]