{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["fPM_min","fPM_Variability","Promulgated_Mins","UPL Pooled Template ","UPL Normal","QA_Calcs","Lognormal Template","lognormal distribution 99 %","PetCoke_fPM_New_nonnormal n<3","ERT","667_PartII"],"not_rendered":{"charts":1,"images":32,"macros":1,"external_links":0,"defined_names":35,"comments":1,"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":"fPM_min","index":0,"n_rows":9,"n_cols":25,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Key f_b","Primary Fuel","fPM_Min_lb_per_MWh_Rank","Reason_for_Removal as top ranked unit for fPM new source floor","facility_ID","facility_name","Boiler ID","Unit ID","Unit Type","Boiler Type","MMBtu/hr Capacity","MWe Capacity","Heat Rate (MMBtu/MWh)","Fuel Types","Emission Factor","Final_EF_Units","From","Report_id","Submittal_ID_ERT","MaxOfEF_Changed","Submitted_EF","lb/MMBtu (min)","MaxOf1mg_corrected","Config_heat_rate_MMBtu/MWh","lb/MWh (Min)"]
["4125_9","petroleum coke",1,"Air Pollution Control system does not include a RACT/BACT/LAER flue gas desulfurization system consistent with the requirements for a newly constructed source. FGD systems can increase the loading on fPM control devices. Therefore this source was not considered as representative of a future new source.",4125,"Manitowoc","9","B-09","Fluidized bed firing","Fluidized bed firing",1244,63.37,19.630740097838096,"petroleum coke,  subbituminous,  other--wood charcoal/paper pellets",2.1775267459726166E-4,"lb/MMBtu","ERT","",2095,"",1.0913870094018435E-4,2.1775267459726166E-4,"Corrected",19.630740097838096,{"$f":"V2*X2","v":4.2746461606279554E-3}]
["667_1A","petroleum coke",2,null,667,"Northside Generating Station","1A","1A","Fluidized bed firing","Fluidized bed firing",2764,310,8.9161290322580644,"petroleum coke,  bituminous",5.0000000000000001E-4,"lb/MMBtu","Part II","",null,"",{"$f":"O3","v":5.0000000000000001E-4},{"$f":"U3","v":5.0000000000000001E-4},"",8.9161290322580644,{"$f":"V3*X3","v":4.4580645161290322E-3}]
["667_2A","petroleum coke",3,null,667,"Northside Generating Station","2A","2A","Fluidized bed firing","Fluidized bed firing",2764,310,8.9161290322580644,"petroleum coke,  bituminous",1.3828405440464442E-3,"lb/MMBtu","Part II","N2_2009_PM",null,"",7.5000000000000002E-4,1.3828405440464442E-3,"Corrected",8.9161290322580644,1.2329584721756038E-2]
["10373_CB1302","petroleum coke",4,null,10373,"Hanford","CB1302","1A","Fluidized bed firing","Fluidized bed firing",290,27.06,10.716925351071692,"petroleum coke",3.3759626939209391E-3,"lb/MMBtu","Part II","2008 Emission Compliance and RATA Report\\08015.4c",null,"",3.3759626939209391E-3,3.3759626939209391E-3,"",10.716925351071692,3.6179940178753596E-2]
["50931_BLR1","petroleum coke",5,null,50931,"Yellowstone Energy LP","BLR1","Config1","Fluidized bed firing","Fluidized bed firing",518,30,17.266666666666666,"petroleum coke",4.9845360158715813E-3,"lb/MMBtu","Part II","3/24/08 to 3/26/08 Testing",null,"",null,4.9845360158715813E-3,"",17.266666666666666,8.6066321874049292E-2]
["50931_BLR2","petroleum coke",6,null,50931,"Yellowstone Energy LP","BLR2","Config1","Fluidized bed firing","Fluidized bed firing",518,30,17.266666666666666,"petroleum coke",4.9845360158715813E-3,"lb/MMBtu","Part II","3/24/08 to 3/26/08 Testing",null,"",null,4.9845360158715813E-3,"",17.266666666666666,8.6066321874049292E-2]
["10670_AAB001","petroleum coke",7,null,10670,"AES Deepwater","AAB001","Deepwater","Conventional Boiler","Arch firing",1817.6,158,11.50379746835443,"petroleum coke",9.1010342985295509E-3,"lb/MMBtu","ERT","",2214,"",9.1010342985295509E-3,9.1010342985295509E-3,"",11.50379746835443,0.10469645532283108]
["2878_1","petroleum coke",8,null,2878,"Bay Shore","1","Unit 1","Fluidized bed firing","Fluidized bed firing",1218,151,8.0662251655629138,"petroleum coke",3.5207277313258338E-2,"lb/MMBtu","ERT","",2280,"",3.5207277313258338E-2,3.5207277313258338E-2,"",8.0662251655629138,0.28398982627515668]

{"sheet":"fPM_Variability","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Filter","facility_ID","boiler_id","configuration_id","compound","From","Report_id","Submittal_ID_ERT","lb/MMBtu","Config_heat_rate_MMBtu/MWh","lb/MWh","fPM_Min_lb_per_MWh_Rank","Explanation of Excluded Tests","Explanation of Excluded Sources"]
[{"$f":"C2&\"_\"&D2","v":"4125_9"},{"$f":"VLOOKUP(A2,fPM_min!A:A,1,FALSE)","v":"4125_9"},4125,"9","B-09","Filterable Particulate","ERT","",2095,2.1775267459726166E-4,19.630740097838096,null,{"$f":"VLOOKUP(A2,fPM_min!A:C,3,FALSE)","v":1},null,"Unit does not have RACT/BACT/LAER level FGD Controls"]
["667_1A",{"$f":"VLOOKUP(A3,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","ERT","ERT",1507,{"$f":"VLOOKUP(H3,QA_Calcs!N$212:O$214,2,FALSE)","v":6.8572834795810388E-4},8.9161290322580644,{"$f":"VLOOKUP(H3,QA_Calcs!N$202:O$204,2,FALSE)","v":6.1140424314716111E-3},{"$f":"VLOOKUP(A3,fPM_min!A:C,3,FALSE)","v":2}]
["667_1A",{"$f":"VLOOKUP(A4,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","Part II","N1_2007_PM",null,7.8125596731707314E-4,8.9161290322580644,{"$f":"J4*K4","v":6.9657790118206131E-3},{"$f":"VLOOKUP(A4,fPM_min!A:C,3,FALSE)","v":2},"Firing > 10% Coal"]
["667_1A",{"$f":"VLOOKUP(A5,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","Part II","N1_2009_PM",null,{"$f":"VLOOKUP(H5,QA_Calcs!N$212:O$214,2,FALSE)","v":5.0000000000000001E-4},8.9161290322580644,{"$f":"VLOOKUP(H5,QA_Calcs!N$202:O$204,2,FALSE)","v":4.4580645161290322E-3},{"$f":"VLOOKUP(A5,fPM_min!A:C,3,FALSE)","v":2}]
["667_1A",{"$f":"VLOOKUP(A6,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","Part II","N1_2008_PM",null,{"$f":"VLOOKUP(H6,QA_Calcs!N$212:O$214,2,FALSE)","v":1.0666666666666665E-3},8.9161290322580644,{"$f":"VLOOKUP(H6,QA_Calcs!N$202:O$204,2,FALSE)","v":9.5105376344086015E-3},{"$f":"VLOOKUP(A6,fPM_min!A:C,3,FALSE)","v":2}]
["667_1A",{"$f":"VLOOKUP(A7,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","Part II","N1_2006_PM",null,1.2999999999999999E-3,8.9161290322580644,{"$f":"J7*K7","v":1.1590967741935482E-2},{"$f":"VLOOKUP(A7,fPM_min!A:C,3,FALSE)","v":2},"Firing > 10% Coal"]
["667_1A",{"$f":"VLOOKUP(A8,fPM_min!A:A,1,FALSE)","v":"667_1A"},667,"1A","1A","Filterable Particulate","Part II","N1_2005_PM",null,3.0000000000000005E-3,8.9161290322580644,{"$f":"J8*K8","v":2.6748387096774198E-2},{"$f":"VLOOKUP(A8,fPM_min!A:C,3,FALSE)","v":2},"Firing > 10% Coal"]
["667_2A",{"$f":"VLOOKUP(A9,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","Part II","N2_2009_PM",null,1.3828405440464442E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A9,fPM_min!A:C,3,FALSE)","v":3}]
["667_2A",{"$f":"VLOOKUP(A10,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","ERT","",1909,1.3850375872579716E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A10,fPM_min!A:C,3,FALSE)","v":3}]
["667_2A",{"$f":"VLOOKUP(A11,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","Part II","N2_2008_PM",null,2.8666666666666667E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A11,fPM_min!A:C,3,FALSE)","v":3}]
["667_2A",{"$f":"VLOOKUP(A12,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","Part II","N2_2007_PM",null,3.6000000000000003E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A12,fPM_min!A:C,3,FALSE)","v":3}]
["667_2A",{"$f":"VLOOKUP(A13,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","Part II","N2_2006_PM",null,3.6666666666666666E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A13,fPM_min!A:C,3,FALSE)","v":3}]
["667_2A",{"$f":"VLOOKUP(A14,fPM_min!A:A,1,FALSE)","v":"667_2A"},667,"2A","2A","Filterable Particulate","Part II","N2_2005_PM",null,4.6333333333333331E-3,8.9161290322580644,null,{"$f":"VLOOKUP(A14,fPM_min!A:C,3,FALSE)","v":3}]
["10373_CB1302",{"$f":"VLOOKUP(A15,fPM_min!A:A,1,FALSE)","v":"10373_CB1302"},10373,"CB1302","1A","Filterable Particulate","Part II","2008 Emission Compliance and RATA Report\\08015.4c",null,3.3759626939209391E-3,10.716925351071692,null,{"$f":"VLOOKUP(A15,fPM_min!A:C,3,FALSE)","v":4}]
["10373_CB1302",{"$f":"VLOOKUP(A16,fPM_min!A:A,1,FALSE)","v":"10373_CB1302"},10373,"CB1302","1A","Filterable Particulate","Part II","2005 Emission Compliance and RATA Report\\05015.4c",null,4.1592348351371759E-3,10.716925351071692,null,{"$f":"VLOOKUP(A16,fPM_min!A:C,3,FALSE)","v":4}]
["10373_CB1302",{"$f":"VLOOKUP(A17,fPM_min!A:A,1,FALSE)","v":"10373_CB1302"},10373,"CB1302","1A","Filterable Particulate","ERT","",1260,4.6904447789564993E-3,10.716925351071692,null,{"$f":"VLOOKUP(A17,fPM_min!A:C,3,FALSE)","v":4}]
["10373_CB1302",{"$f":"VLOOKUP(A18,fPM_min!A:A,1,FALSE)","v":"10373_CB1302"},10373,"CB1302","1A","Filterable Particulate","Part II","2007 Emission Compliance and RATA Report\\07015.4c",null,1.0296487202907148E-2,10.716925351071692,null,{"$f":"VLOOKUP(A18,fPM_min!A:C,3,FALSE)","v":4}]
["10373_CB1302",{"$f":"VLOOKUP(A19,fPM_min!A:A,1,FALSE)","v":"10373_CB1302"},10373,"CB1302","1A","Filterable Particulate","Part II","2009 Emission Compliance and RATA Report\\09015.4c",null,1.7306830028209336E-2,10.716925351071692,null,{"$f":"VLOOKUP(A19,fPM_min!A:C,3,FALSE)","v":4}]
["50931_BLR1",{"$f":"VLOOKUP(A20,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","3/24/08 to 3/26/08 Testing",null,4.9845360158715813E-3,17.266666666666666,null,{"$f":"VLOOKUP(A20,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR1",{"$f":"VLOOKUP(A21,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","3/16/09 to 3/18/09 testing",null,5.3476185039250832E-3,17.266666666666666,null,{"$f":"VLOOKUP(A21,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR1",{"$f":"VLOOKUP(A22,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","2/15/06 to 2/16/06 Emission Testing.",null,7.6805221050143049E-3,17.266666666666666,null,{"$f":"VLOOKUP(A22,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR1",{"$f":"VLOOKUP(A23,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","2/5/07 to 2/7/07 Emission Testing",null,1.1671364074110074E-2,17.266666666666666,null,{"$f":"VLOOKUP(A23,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR1",{"$f":"VLOOKUP(A24,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","3/28/2005 Particulate Retest",null,1.4948232402660536E-2,17.266666666666666,null,{"$f":"VLOOKUP(A24,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR1",{"$f":"VLOOKUP(A25,fPM_min!A:A,1,FALSE)","v":"50931_BLR1"},50931,"BLR1","Config1","Filterable Particulate","Part II","2/15/05 to 2/17/05 testing",null,0.10284187984536418,17.266666666666666,null,{"$f":"VLOOKUP(A25,fPM_min!A:C,3,FALSE)","v":5}]
["50931_BLR2",{"$f":"VLOOKUP(A26,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","3/24/08 to 3/26/08 Testing",null,4.9845360158715813E-3,17.266666666666666,null,{"$f":"VLOOKUP(A26,fPM_min!A:C,3,FALSE)","v":6}]
["50931_BLR2",{"$f":"VLOOKUP(A27,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","3/16/09 to 3/18/09 testing",null,5.3476185039250832E-3,17.266666666666666,null,{"$f":"VLOOKUP(A27,fPM_min!A:C,3,FALSE)","v":6}]
["50931_BLR2",{"$f":"VLOOKUP(A28,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","2/15/06 to 2/16/06 Emission Testing.",null,7.6805221050143049E-3,17.266666666666666,null,{"$f":"VLOOKUP(A28,fPM_min!A:C,3,FALSE)","v":6}]
["50931_BLR2",{"$f":"VLOOKUP(A29,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","2/5/07 to 2/7/07 Emission Testing",null,1.1671364074110074E-2,17.266666666666666,null,{"$f":"VLOOKUP(A29,fPM_min!A:C,3,FALSE)","v":6}]
["50931_BLR2",{"$f":"VLOOKUP(A30,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","3/28/2005 Particulate Retest",null,1.4948232402660536E-2,17.266666666666666,null,{"$f":"VLOOKUP(A30,fPM_min!A:C,3,FALSE)","v":6}]
["50931_BLR2",{"$f":"VLOOKUP(A31,fPM_min!A:A,1,FALSE)","v":"50931_BLR2"},50931,"BLR2","Config1","Filterable Particulate","Part II","2/15/05 to 2/17/05 testing",null,0.10284187984536418,17.266666666666666,null,{"$f":"VLOOKUP(A31,fPM_min!A:C,3,FALSE)","v":6}]
["10670_AAB001",{"$f":"VLOOKUP(A32,fPM_min!A:A,1,FALSE)","v":"10670_AAB001"},10670,"AAB001","Deepwater","Filterable Particulate","ERT","",2214,9.1010342985295509E-3,11.50379746835443,null,{"$f":"VLOOKUP(A32,fPM_min!A:C,3,FALSE)","v":7}]
["2878_1",{"$f":"VLOOKUP(A33,fPM_min!A:A,1,FALSE)","v":"2878_1"},2878,"1","Unit 1","Filterable Particulate","ERT","",2280,3.5207277313258338E-2,8.0662251655629138,null,{"$f":"VLOOKUP(A33,fPM_min!A:C,3,FALSE)","v":8}]

{"sheet":"Promulgated_Mins","index":2,"n_rows":10,"n_cols":55,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["key f_b","primary_fuel","ORIS code","Plant Name","physical_state","Unit Number","boiler_id","Unit Type","boiler_type","max_heat_input","MWe_capacity","Boiler_heat_rate","Fuel types","Filterable Particulate - ERT","Filterable Particulate MW - ERT","Filterable Particulate - Part II","Filterable Particulate MW - Part II","Filterable Particulate - min","Filterable Particulate 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,null,"MMBtu/hr","MW","MMBtu/MWh",null,"lb/MMBtu","lb/MW","lb/MMBtu","lb/MW","lb/MMBtu","lb/MW"]
[{"$f":"C3&\"_\"&G3","v":"4125_9"},"petroleum coke",4125,"Manitowoc","WI","B-09","9","Fluidized bed firing","Fluidized bed firing",1244,63.37,19.630740097838096,"petroleum coke,  subbituminous,  other--wood charcoal/paper pellets",1.5153375350893832E-4,2.9747197311838299E-3,null,null,1.5153375350893832E-4,2.9747197311838299E-3,"NOx control","Selective Noncatalytic Reduction",null,"PM control","Fabric Filter, pulse",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
[{"$f":"C4&\"_\"&G4","v":"667_1A"},"petroleum coke",667,"Northside Generating Station","FL","1A","1A","Fluidized bed firing","Fluidized bed firing",2764,310,8.9161290322580644,"petroleum coke,  bituminous",6.8572834795810388E-4,6.1140424314716103E-3,5.0000000000000001E-4,4.4580645161290322E-3,5.0000000000000001E-4,4.4580645161290322E-3,"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","petroleum coke",667,"Northside Generating Station","FL","2A","2A","Fluidized bed firing","Fluidized bed firing",2764,310,8.9161290322580644,"petroleum coke,  bituminous",5.0678544165756853E-4,4.5185643894887721E-3,7.5000000000000002E-4,6.6870967741935487E-3,5.0678544165756853E-4,4.5185643894887721E-3,"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,"",""]
["10373_CB1302","petroleum coke",10373,"Hanford","CA","1A","CB1302","Fluidized bed firing","Fluidized bed firing",290,27.06,10.716925351071692,"petroleum coke",4.6904447789564985E-3,5.026714655940076E-2,3.3759626939209382E-3,3.6179940178753589E-2,3.3759626939209382E-3,3.6179940178753589E-2,"PM control","Fabric Filter, pulse","1991-08-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["50931_BLR2","petroleum coke",50931,"Yellowstone Energy LP","MT","Config1","BLR2","Fluidized bed firing","Fluidized bed firing",518,30,17.266666666666666,"petroleum coke",null,null,4.9845360158715813E-3,8.6066321874049292E-2,4.9845360158715813E-3,8.6066321874049292E-2,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["50931_BLR1","petroleum coke",50931,"Yellowstone Energy LP","MT","Config1","BLR1","Fluidized bed firing","Fluidized bed firing",518,30,17.266666666666666,"petroleum coke",null,null,4.9845360158715813E-3,8.6066321874049292E-2,4.9845360158715813E-3,8.6066321874049292E-2,"PM control","Fabric Filter, pulse","1995-07-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["10670_AAB001","petroleum coke",10670,"AES Deepwater","TX","Deepwater","AAB001","Conventional Boiler","Arch firing",1817.6,158,11.50379746835443,"petroleum coke",7.8928172007009523E-3,9.0797370531607913E-2,null,null,7.8928172007009523E-3,9.0797370531607913E-2,"NOx control","Selective Catalytic Reduction","2007-03-01","PM control","Electrostatic precipitator, cold side, w/o flue gas conditioning",31260,"SO2 control","Wet FGD - Spray Type",31260,"Other control","Wet electrostatic precipitator",31260,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]
["2878_1","petroleum coke",2878,"Bay Shore","OH","Unit 1","1","Fluidized bed firing","Fluidized bed firing",1218,151,8.0662251655629138,"petroleum coke",3.2083227041160248E-2,0.25879053335187535,null,null,3.2083227041160248E-2,0.25879053335187535,"PM control","Fabric Filter, unspecified","2000-12-01","","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"",""]

{"sheet":"UPL Pooled Template ","index":3,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,1,0,11],[37,0,37,3]]}
[null,"Emissions (lb/MW)"]
["Averages","667\nNorthside\n1A"]
[1,4.4580645161290322E-3]
[2,9.5105376344086015E-3]
[3,6.1140424314716111E-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]
["Use for large sample sets and small sample sets that are Normal."]
[]
["Testing Normality","Raw Data"]
["Sample Size",{"$f":"COUNT(B3:L37)","v":3}]
["Kurtosis",{"$f":"KURT(B3:L37)","v":{"$error":"#DIV/0!"}}]
["SE Kurtosis",{"$f":"SQRT((B41^2-1)/((B41-3)*(B41+5)))","v":{"$error":"#DIV/0!"}}]
["Result Kurtosis",{"$f":"IF(ABS(B42/B43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":{"$error":"#DIV/0!"}},null,"Because only 3 test averages have to use different template to test for normality.  "]
["Skewness",{"$f":"SKEW(B3:L37)","v":0.96218434570217326},null,"Used \"PetCoke_fPM_New_nonnormal n<3\" to test for normality.  "]
["SE Skewness",{"$f":"SQRT((6*B41*(B41-1))/((B41-2)*(B41+1)*(B41+3)))","v":1.2247448713915889},null,"Data is normal, proceed using UPL Pooled Template."]
["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":3},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":3}]
[]
[]
[]
[]
[null,{"$f":"B55-1","v":2}]
[]
[]
[]
[]
["This step is for QC only:"]
[]
["means",{"$f":"AVERAGE(B3:B37)","v":6.6942148606697486E-3},{"$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":6.6942148606697486E-3}]
["Mean ="]
[]
[]
[]
["Pooled Variance = ",null,null,{"$f":"VAR(B3:L37)","v":6.6343211884356692E-6}]
[]
[]
[]
[]
[]
["m= number future Averages =",{"$f":"'UPL Normal'!C78","v":1}]
[]
[]
["Term1",{"$f":"1/B55+1/B85","v":1.3333333333333333}]
[]
[]
[]
["Term2",{"$f":"D79*B88","v":8.8457615845808923E-6}]
[]
[]
[]
[]
[]
["Squared root Term2",null,{"$f":"SQRT(B92)","v":2.9741825069388213E-3}]
[]
[]
["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":6.9645567342832733}]
[]
[]
["UPL  POOLED VARIANCE = ",null,null,null,null,{"$f":"B74+H104*C98","v":2.7408077668358025E-2}]

{"sheet":"UPL Normal","index":4,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[47,16,48,16]]}
["Emissions (lb/MW)","fPM"]
[null,667]
["ORIS/Facility/Unit","Northside"]
["Averages","1A"]
[1,4.4580645161290322E-3]
[2,9.5105376344086015E-3]
[3,6.1140424314716111E-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]
[]
["ni = number test Averages =",{"$f":"COUNT(B5:B39)","v":3}]
[]
[]
[]
["Total Number of sources =",null,{"$f":"COUNTA(B2:Q2)","v":1}]
[]
[]
["n =Total # test Averages =",null,{"$f":"SUM(B41:B41)","v":3}]
[]
[]
[]
[]
[null,null,{"$f":"C48-1","v":2}]
[]
[]
[]
[]
["This step is for QC only:"]
[]
["means",{"$f":"AVERAGE(B5:B39)","v":6.6942148606697486E-3}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Distribution of Normal Tests","Distribution of Log Tests"]
[null,null,{"$f":"AVERAGE(B5:B39)","v":6.6942148606697486E-3}]
["UPL Mean =",null,null,null,null,null,"Skewness =",{"$f":"SKEW(B5:GG39)","v":0.96218434570217326},{"$f":"SKEW(M64:Q66)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"SE Skewness",{"$f":"SQRT(6/H74)","v":1.4142135623730951},{"$f":"SQRT(6/I74)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Skewness Test",{"$f":"IF(H68>2*H69,\"non-normal\",\"normal\")","v":"normal"},{"$f":"IF(I68>2*I69,\"non-normal\",\"normal\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Kurtosis =",{"$f":"KURT(B5:GG39)","v":{"$error":"#DIV/0!"}},{"$f":"KURT(M64:Q66)","v":{"$error":"#DIV/0!"}}]
["Pooled Variance = ",null,{"$f":"VAR(B5:H39)","v":6.6343211884356692E-6},null,null,null,"SE Kurtosis",{"$f":"SQRT(24/H74)","v":2.8284271247461903},{"$f":"SQRT(24/I74)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Kurtosis Test",{"$f":"IF(H71>2*H72,\"non-normal\",\"normal\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(I71>2*I72,\"non-normal\",\"normal\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,"Number of test Averages =",{"$f":"COUNT(B5:GG39)","v":3},{"$f":"COUNT(M64:Q66)","v":0},"Result:","Insufficient number of data points for Kurtosis test, because Kurtosis test requires at least 4 data points."]
[]
[]
[]
["m= number future Averages =",null,1]
[]
[]
["Term1",null,{"$f":"1/C48+1/C78","v":1.3333333333333333}]
[]
[]
[]
["Term2",null,{"$f":"C72*C81","v":8.8457615845808923E-6}]
[]
[]
[]
[]
[]
["Squared root Term2",null,{"$f":"SQRT(C85)","v":2.9741825069388213E-3}]
[]
[]
["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":6.9645567342832733}]
[]
[]
["UPL  POOLED VARIANCE = ",null,{"$f":"C67+C97*C91","v":2.7408077668358025E-2},{"$f":"IFERROR(IF(FIND(\"MM\",A$1,1)>0,\"lb/MMBtu\",\"lb/MW\"),\"lb/MW\")","v":"lb/MW"}]
[]
[]
[]
[]
[]
[null,"UPL Value","DO NOT USE THIS SPREADSHEET USE NON NORMAL TEMPLATE"]

{"sheet":"QA_Calcs","index":5,"n_rows":214,"n_cols":100,"rows_kept":214,"cut":false,"hidden":false,"merged":[[8,0,8,4],[8,6,8,18],[8,20,8,26],[8,28,8,36],[8,37,8,44]]}
[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,"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,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,"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/gr",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,"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,"gr/dscf",null,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,"original database export===>"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M17",null,null,null,null,null,null,null,null,null,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,"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","Submited F Factor","Bws (percent)","%O2d","%CO2d","Emission Rate Value","Emission Rate UOM","Emission Rate MDL","Emission Factor Value","Emission Factor UOM","Emission Factor MDL","Fd","Fw","Fc","Calculated conc lb/dscf","19-1\nlb/MMBtu","%diff\n19-1","19-6\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","submittal_id","Compound","RunDate","Method","RunNumber","RunStartTime","RunEndTime","NetTravPts","Mass_TOOL","mass","units","Vmstd","Cd","Vwstd","PercH20","PercCO2","PercO2","Fd","19-1","19-5","Fc","19-6","19-9","Fw","FuelType","lb/mmBtuO2","CountOfComments","AvgOfStackTemp","AvgOfDryGasInlet","AvgOfDryGasOutlet","AvgOfOrificePresDesired","AvgOfOrificePresActual","AvgOfProbeTemp","AvgOfFilterTemp","AvgOfImpingTemp","CountOfNotes","M29 Isokinetic (+/- 10%)","OTM27 includes all fractions?","QA Comment","Questions for EPA",null,"average of runs"]
[null,null,"Yes","A","5_fPM_T1_R1","Northside",667,"1A","Pet Coke",">90","Bituminous","<10","ERT","fPM","M29",{"$f":"BS11","v":7.6516568732352089E-8},"lb/dscf",null,{"$f":"1/ROUND((BN11-BM11)*24,0)*0.00000220462*0.028317*IF(AB11<>\"\",AB11,AL11)*IF(AD11<>\"\",20.9/(20.9-AD11),20.9/(20.9-6))","v":6.9940895342811248E-7},"lb/MMBtu",null,null,null,null,null,null,null,null,{"$f":"BU11","v":"11.00"},{"$f":"BW11","v":4.8},{"$f":"BV11","v":15.6},null,null,null,{"$f":"CF11","v":9.6386048618314656E-4},"lb/MMBtu",null,{"$f":"VLOOKUP($I11,$A$91:$E$98,3,FALSE)","v":9830},null,{"$f":"VLOOKUP($I11,$A$91:$E$98,5,FALSE)","v":1850},null,{"$f":"IF(AD11<>\"\",P11*AL11*20.9/(20.9-AD11),\"no O2 data for run\")","v":9.7640369542580996E-4},{"$f":"(AP11-$AI11)/$AI11","v":1.3013511210874582E-2},{"$f":"IF(AE11<>\"\",P11*AN11*100/AE11,\"no CO2 data for run\")","v":9.0740802663366257E-4},{"$f":"(AR11-$AI11)/$AI11","v":-5.8569119036131191E-2},{"$f":"AI11","v":9.6386048618314656E-4},8.9161290322580644,{"$f":"AT11*AU11","v":8.5939044639039269E-3},"original database export===>","5_fPM_T1_R1",9.6299428557001295E-4,"A",9.6386048618314656E-4,"lb/mmBtuO2","Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-18","Method 29","1","08:30","12:46",48,5.55,5.55,"mg","159.765",7.6516568732352089E-8,"19.74","11.00",15.6,4.8,9695,9.6299428557001295E-4,8.5706491415731153E-4,0,0,0,0,"Override",9.6386048618314656E-4,49,197.72916666666666,94.729166666666671,94.729166666666671,1.4742647774056079,1.5209374999999996,254.54166666666666,252.5,52.9375,0,102.1,null,null,null,null,{"$f":"AVERAGE(AV11:AV13)","v":6.1140424314716111E-3}]
[null,null,"Yes","A","5_fPM_T1_R2","Northside",667,"1A","Pet Coke",">90","Bituminous","<10","ERT","fPM","M29",{"$f":"BS12","v":4.2554929903519457E-8},"lb/dscf",null,{"$f":"1/ROUND((BN12-BM12)*24,0)*0.00000220462*0.028317*IF(AB12<>\"\",AB12,AL12)*IF(AD12<>\"\",20.9/(20.9-AD12),20.9/(20.9-6))","v":7.0373392045461131E-7},"lb/MMBtu",null,null,null,null,null,null,null,null,{"$f":"BU12","v":"10.85"},{"$f":"BW12","v":4.8},{"$f":"BV12","v":15.2},null,null,null,{"$f":"CF12","v":5.3727045484696268E-4},"lb/MMBtu",null,{"$f":"VLOOKUP($I12,$A$91:$E$98,3,FALSE)","v":9830},null,{"$f":"VLOOKUP($I12,$A$91:$E$98,5,FALSE)","v":1850},null,{"$f":"IF(AD12<>\"\",P12*AL12*20.9/(20.9-AD12),\"no O2 data for run\")","v":5.4302998036573683E-4},{"$f":"(AP12-$AI12)/$AI12","v":1.0719974394301482E-2},{"$f":"IF(AE12<>\"\",P12*AN12*100/AE12,\"no CO2 data for run\")","v":5.1793829158888825E-4},{"$f":"(AR12-$AI12)/$AI12","v":-3.5982181941460085E-2},{"$f":"AI12","v":5.3727045484696268E-4},8.9161290322580644,{"$f":"AT12*AU12","v":4.7903727006354995E-3},"original database export===>","5_fPM_T1_R2",5.367876214866596E-4,"A",5.3727045484696268E-4,"lb/mmBtuO2","Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-18","Method 29","2","15:45","19:32",48,3.15,3.15,"mg","163.044",4.2554929903519457E-8,"19.85","10.85",15.2,4.8,9717,5.367876214866596E-4,4.7854616455535702E-4,0,0,0,0,"Override",5.3727045484696268E-4,49,197.10416666666666,102.54166666666667,102.54166666666667,1.5941315176243114,1.6601250000000001,254.66666666666666,254.08333333333334,52.479166666666664,0,100.7]
[null,null,"Yes","A","5_fPM_T1_R3","Northside",667,"1A","Pet Coke",">90","Bituminous","<10","ERT","fPM","M29",4.351466303239568E-8,"lb/dscf",null,{"$f":"1/ROUND((BN13-BM13)*24,0)*0.00000220462*0.028317*IF(AB13<>\"\",AB13,AL13)*IF(AD13<>\"\",20.9/(20.9-AD13),20.9/(20.9-6))","v":6.9570241527638795E-7},"lb/MMBtu",null,null,null,null,null,null,null,null,"10.75",4.7,15.2,null,null,null,5.5605410284420239E-4,"lb/MMBtu",null,9830,null,1850,null,{"$f":"IF(AD13<>\"\",P13*AL13*20.9/(20.9-AD13),\"no O2 data for run\")","v":5.5184919605040712E-4},-7.5620461611330342E-3,5.2961925401271055E-4,-4.7540066148740331E-2,5.5605410284420239E-4,8.9161290322580644,4.9578501298754045E-3,"original database export===>","5_fPM_T1_R3",5.5555438902490635E-4,"A",5.5605410284420239E-4,"lb/mmBtuO2","Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-19","Method 29","3","09:30","13:39",48,3.15,3.15,"mg","159.448",4.351466303239568E-8,"19.21","10.75",15.2,4.7,9896,5.5555438902490635E-4,4.9583229220472892E-4,0,0,0,0,"Override",5.5605410284420239E-4,49,198.8125,100.52083333333333,100.52083333333333,1.496576943409359,1.5532229166666662,254.20833333333334,254.89583333333334,54.354166666666664,0,101.6]
["Hidden Header for Raw Data in columns AW-CT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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===>","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 conc lb/dscf","19-1\nlb/MMBtu","%diff\n19-1","19-6\nlb/MMBtu","%diff\n19-6","emission_factor","emission_factor_units","emission_factor_ND","emission_factor_MDL","run_pollutant_comment","Fuel1","Fuel1%Btu","Fuel2","Fuel2%Btu","QA Comment"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T2_R1","Northside",667,"1A","Pet Coke",77.27,"Bituminous",22.73,"Part II","fPM","M17",{"$f":"BW15","v":2.8599999999999999E-7},"lb/dscf","No",null,null,null,null,null,null,null,null,null,null,{"$f":"BR15","v":9.06},{"$f":"BS15","v":3.6},{"$f":"BT15","v":15.02},{"$f":"CC15","v":10.53},"lb/hr",null,{"$f":"CL15","v":3.0000000000000001E-3},"lb/MMBtu",null,9830,null,1850,null,{"$f":"IF(AD15<>\"\",P15*AL15*20.9/(20.9-AD15),\"no O2 data for run\")","v":3.3964070520231216E-3},{"$f":"(AP15-$AI15)/$AI15","v":0.1321356840077072},3.5226364846870839E-3,{"$f":"(AR15-$AI15)/$AI15","v":0.17421216156236127},{"$f":"AI15","v":3.0000000000000001E-3},8.9161290322580644,{"$f":"AT15*AU15","v":2.6748387096774195E-2},"original database export===>","5_fPM_T2_R1","n/a","C",3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes",{"$f":"A15","v":"Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit."},667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","1","2005-06-14T09:25:00","2005-06-14T11:35:00",297.32,192921,15017.1,9.06,3.6,15.02,222,"Method 17",2.8599999999999999E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.53,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf",null,null,null,null,null,{"$f":"AVERAGE(AV15:AV17)","v":2.6748387096774195E-2}]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T2_R2","Northside",667,"1A","Pet Coke",77.27,"Bituminous",22.73,"Part II","fPM","M17",{"$f":"BW16","v":2.8200000000000001E-7},"lb/dscf","No",null,null,null,null,null,null,null,null,null,null,{"$f":"BR16","v":9.56},3.59,14.99,{"$f":"CC16","v":10.33},"lb/hr",null,{"$f":"CL16","v":3.0000000000000001E-3},"lb/MMBtu",null,9830,null,1850,null,{"$f":"IF(AD16<>\"\",P16*AL16*20.9/(20.9-AD16),\"no O2 data for run\")","v":3.3469701906412479E-3},{"$f":"(AP16-$AI16)/$AI16","v":0.11565673021374928},3.4803202134756511E-3,{"$f":"(AR16-$AI16)/$AI16","v":0.160106737825217},{"$f":"AI16","v":3.0000000000000001E-3},8.9161290322580644,2.6748387096774195E-2,"original database export===>","5_fPM_T2_R2","n/a","C",3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","2","2005-06-14T12:00:00","2005-06-14T14:05:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.33,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T2_R3","Northside",667,"1A","Pet Coke",77.27,"Bituminous",22.73,"Part II","fPM","M17",2.8200000000000001E-7,"lb/dscf","No",null,null,null,null,null,null,null,null,null,null,9.56,3.59,14.99,10.33,"lb/hr",null,3.0000000000000001E-3,"lb/MMBtu",null,9830,null,1850,null,3.3469701906412479E-3,0.11565673021374928,3.4803202134756511E-3,0.160106737825217,3.0000000000000001E-3,8.9161290322580644,2.6748387096774195E-2,"original database export===>","5_fPM_T2_R3","n/a","C",3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","3","2005-06-14T14:20:00","2005-06-14T16:26:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.33,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T3_R1","Northside",667,"1A","Pet Coke",81.78,"Bituminous",18.22,"Part II","fPM","M17",6.9999999999999999E-4,"gr/dscf","No",null,null,{"$f":"1/$A$80","v":1.4285714285714287E-4},"lb/gr",null,null,null,null,null,null,10.119999999999999,4.5999999999999996,15.2,3.99,"lb/hr",null,1.2999999999999999E-3,"lb/MMBtu",null,9830,null,1850,{"$f":"P18*U18","v":1.0000000000000001E-7},{"$f":"IF(AD18<>\"\",AO18*AL18*20.9/(20.9-AD18),\"no O2 data for run\")","v":1.2604110429447857E-3},-3.0453043888626373E-2,{"$f":"IF(AE18<>\"\",AO18*AN18*100/AE18,\"no CO2 data for run\")","v":1.217105263157895E-3},-6.3765182186234573E-2,1.2999999999999999E-3,8.9161290322580644,1.1590967741935482E-2,"original database export===>","5_fPM_T3_R1","n/a","C",1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","1","2006-02-23T08:26:00","2006-02-23T10:31:00",299.55,196803,15152.3,10.119999999999999,4.5999999999999996,15.2,233.3,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.99,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf",null,null,null,null,null,{"$f":"AVERAGE(AV18:AV20)","v":1.1590967741935484E-2}]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T3_R2","Northside",667,"1A","Pet Coke",81.78,"Bituminous",18.22,"Part II","fPM","M17",6.9999999999999999E-4,"gr/dscf","No",null,null,{"$f":"1/$A$80","v":1.4285714285714287E-4},"lb/gr",null,null,null,null,null,null,9.58,4.2,15,3.89,"lb/hr",null,1.2999999999999999E-3,"lb/MMBtu",null,9830,null,1850,{"$f":"P19*U19","v":1.0000000000000001E-7},{"$f":"IF(AD19<>\"\",AO19*AL19*20.9/(20.9-AD19),\"no O2 data for run\")","v":1.2302215568862278E-3},-5.3675725472132445E-2,{"$f":"IF(AE19<>\"\",AO19*AN19*100/AE19,\"no CO2 data for run\")","v":1.2333333333333335E-3},-5.1282051282051141E-2,1.2999999999999999E-3,8.9161290322580644,1.1590967741935482E-2,"original database export===>","5_fPM_T3_R2","n/a","C",1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","2","2006-02-23T10:47:00","2006-02-23T12:53:00",299.55,196803,15152.3,9.58,4.2,15,245,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.89,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T3_R3","Northside",667,"1A","Pet Coke",81.78,"Bituminous",18.22,"Part II","fPM","M17",8.0000000000000004E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,9.39,4.2,15,3.88,"lb/hr",null,1.2999999999999999E-3,"lb/MMBtu",null,9830,null,1850,1.142857142857143E-7,1.4059674935842604E-3,8.1513456603277301E-2,1.4095238095238095E-3,8.4249084249084297E-2,1.2999999999999999E-3,8.9161290322580644,1.1590967741935482E-2,"original database export===>","5_fPM_T3_R3","n/a","C",1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","3","2006-02-23T13:11:00","2006-02-23T15:15:00",299.55,196803,15152.3,9.39,4.2,15,248.8,"Method 17",8.0000000000000004E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.88,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T4_R1","Northside",667,"1A","Pet Coke",83.42,"Bituminous",16.579999999999998,"Part II","fPM","M17",4.0000000000000002E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,9.07,4.5,14.9,1.92,"lb/hr",null,5.9999999999999995E-4,"lb/MMBtu",null,9830,null,1850,5.7142857142857151E-8,7.1584320557491307E-4,0.19307200929152191,7.0949185043144773E-4,0.18248641738574631,5.9999999999999995E-4,8.9161290322580644,5.3496774193548379E-3,"original database export===>","5_fPM_T4_R1","n/a","C",5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","1","2007-02-28T08:48:00","2007-02-28T10:54:00",313.07,204537,14831,9.07,4.5,14.9,230.5,"Method 17",4.0000000000000002E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.92,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf",null,null,null,null,null,{"$f":"AVERAGE(AV21:AV23)","v":5.0524731182795693E-3}]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T4_R2","Northside",667,"1A","Pet Coke",83.42,"Bituminous",16.579999999999998,"Part II","fPM","M17",2.9999999999999997E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,9.3699999999999992,4.5999999999999996,15,1.52,"lb/hr",null,5.0000000000000001E-4,"lb/MMBtu",null,9830,null,1850,4.2857142857142858E-8,5.4017616126205098E-4,8.0352322524101946E-2,5.2857142857142859E-4,5.7142857142857169E-2,5.0000000000000001E-4,8.9161290322580644,4.4580645161290322E-3,"original database export===>","5_fPM_T4_R2","n/a","C",5.0000000000000001E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","2","2007-02-28T11:07:00","2007-02-28T13:12:00",313.07,204537,14831,9.3699999999999992,4.5999999999999996,15,230.8,"Method 17",2.9999999999999997E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.52,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.0000000000000001E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit.",null,"No","Do Not Use","5_fPM_T4_R3","Northside",667,"1A","Pet Coke",83.42,"Bituminous",16.579999999999998,"Part II","fPM","M17",2.9999999999999997E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,9.07,4.5999999999999996,15,1.64,"lb/hr",null,5.9999999999999995E-4,"lb/MMBtu",null,9830,null,1850,4.2857142857142858E-8,5.4017616126205098E-4,-9.9706397896581617E-2,5.2857142857142859E-4,-0.11904761904761893,5.9999999999999995E-4,8.9161290322580644,5.3496774193548379E-3,"original database export===>","5_fPM_T4_R3","n/a","C",5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes",{"$f":"A23","v":"Burned >10% coal during testing. The EPA provided direction on 8/3/2012 to exclude runs where >10 percent coal was fired in a pet coke unit."},667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","3","2007-02-28T13:23:00","2007-02-28T15:36:00",313.07,204537,14831,9.07,4.5999999999999996,15,224.9,"Method 17",2.9999999999999997E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.64,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values.",null,"Yes","C","5_fPM_T5_R1","Northside",667,"1A","Pet Coke",92.06,"Bituminous",7.94,"Part II","fPM","M17",5.0000000000000001E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,10.06,4.53,14.86,3.08,"lb/hr",null,1E-3,"lb/MMBtu",null,9830,null,1850,7.1428571428571437E-8,8.9644384326730095E-4,-0.10355615673269906,8.8925206691020968E-4,-0.11074793308979035,1E-3,8.9161290322580644,8.9161290322580643E-3,"original database export===>","5_fPM_T5_R1","n/a","C",1E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes",{"$f":"A24","v":"Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values."},667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","1","2008-06-10T17:06:00","2008-06-10T19:20:00",299.51,201926,14618,10.06,4.53,14.86,197.7,"Method 17",5.0000000000000001E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.08,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf",null,null,null,null,null,{"$f":"AVERAGE(AV24:AV26)","v":9.5105376344086015E-3}]
["Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values.",null,"Yes","C","5_fPM_T5_R2","Northside",667,"1A","Pet Coke",92.06,"Bituminous",7.94,"Part II","fPM","M17",5.0000000000000001E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,10.37,4.53,14.47,2.8519999999999999,"lb/hr",null,1E-3,"lb/MMBtu",null,9830,null,1850,7.1428571428571437E-8,8.9644384326730095E-4,-0.10355615673269906,9.1321946885181159E-4,-8.6780531148188428E-2,1E-3,8.9161290322580644,8.9161290322580643E-3,"original database export===>","5_fPM_T5_R2","n/a","C",1E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes",{"$f":"A25","v":"Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values."},667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","2","2008-06-11T13:53:00","2008-06-11T16:02:00",299.89,198462,15111.9,10.37,4.53,14.47,203.7,"Method 17",5.0000000000000001E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",2.8519999999999999,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values.",null,"Yes","C","5_fPM_T5_R3","Northside",667,"1A","Pet Coke",92.06,"Bituminous",7.94,"Part II","fPM","M17",6.9999999999999999E-4,"gr/dscf","No",null,null,1.4285714285714287E-4,"lb/gr",null,null,null,null,null,null,11.2,4.53,14.26,3.6360000000000001,"lb/hr",null,1.1999999999999999E-3,"lb/MMBtu",null,9830,null,1850,1.0000000000000001E-7,1.2550213805742215E-3,4.5851150478517996E-2,1.2973352033660592E-3,8.1112669471716067E-2,1.1999999999999999E-3,8.9161290322580644,1.0699354838709676E-2,"original database export===>","5_fPM_T5_R3","n/a","C",1.1999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Facility did not provide f-Factor. For QA Calcs, used f-Factor for Pet Coke = 9830 from 40 CFR Part 75 Appendix F Section 3.3.5, Table 1 \"F and Fc Factors.\"QA calcs were within 10.4% of reported values.",667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","3","2008-06-11T17:14:00","2008-06-11T19:18:00",299.89,198462,15111.9,11.2,4.53,14.26,202.8,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.6360000000000001,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.1999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["Facility did not provide f-Factor. No QA Calcs.",null,"Yes","D","5_fPM_T6_R1","Northside",667,"1A","Pet Coke",90,"Bituminous",10,"Part II","fPM","M17","Not Submitted",null,null,{"$f":"1/ROUND((BN27-BM27)*24,0)*0.00000220462*0.028317*IF(AB27<>\"\",AB27,AL27)*IF(AD27<>\"\",20.9/(20.9-AD27),20.9/(20.9-6))","v":3.9585467429226477E-4},"lb/MMBtu",null,null,null,null,null,null,null,null,11,{"$f":"BS27","v":4.7},15,2.5,"lb/hr",null,8.0000000000000004E-4,"lb/MMBtu",{"$f":"S27","v":3.9585467429226477E-4},9830,null,1850,null,null,null,null,null,{"$f":"IF(AK27>AI27,AK27,AI27)","v":8.0000000000000004E-4},8.9161290322580644,7.132903225806452E-3,"original database export===>","5_fPM_T6_R1","n/a","C",8.0000000000000004E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Facility did not provide f-Factor. No QA Calcs.",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","3","2009-05-05T15:49:00","2009-05-05T17:56:00",299.95999999999998,202348,15031.1,11,4.7,15,197.4,"Method 17",null,"",false,null,null,"",2.5,"pound per hour (lb/hr)",false,null,null,null,null,null,null,8.0000000000000004E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf",null,null,null,null,null,{"$f":"AVERAGE(AV27:AV29)","v":4.4580645161290322E-3}]
["Facility did not provide f-Factor. No QA Calcs.",null,"Yes","D","5_fPM_T6_R2","Northside",667,"1A","Pet Coke",90,"Bituminous",10,"Part II","fPM","M17","Not Submitted",null,null,{"$f":"1/ROUND((BN28-BM28)*24,0)*0.00000220462*0.028317*IF(AB28<>\"\",AB28,AL28)*IF(AD28<>\"\",20.9/(20.9-AD28),20.9/(20.9-6))","v":2.723076740354433E-4},"lb/MMBtu",null,null,null,null,null,null,null,null,11.5,5.2,14.3,1,"lb/hr",null,2.9999999999999997E-4,"lb/MMBtu",{"$f":"S28","v":2.723076740354433E-4},9830,null,1850,null,null,null,null,null,2.9999999999999997E-4,8.9161290322580644,2.674838709677419E-3,"original database export===>","5_fPM_T6_R2","n/a","C",2.9999999999999997E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Facility did not provide f-Factor. No QA Calcs.",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","4","2009-05-07T08:20:00","2009-05-07T10:55:00",299.93,204059,14813,11.5,5.2,14.3,198.3,"Method 17",null,"",false,null,null,"",1,"pound per hour (lb/hr)",false,null,null,null,null,null,null,2.9999999999999997E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,""]
["Facility did not provide f-Factor. No QA Calcs.",null,"Yes","D","5_fPM_T6_R3","Northside",667,"1A","Pet Coke",90,"Bituminous",10,"Part II","fPM","M17","Not Submitted",null,null,{"$f":"1/ROUND((BN29-BM29)*24,0)*0.00000220462*0.028317*IF(AB29<>\"\",AB29,AL29)*IF(AD29<>\"\",20.9/(20.9-AD29),20.9/(20.9-6))","v":2.6888242027399119E-4},"lb/MMBtu",null,null,null,null,null,null,null,null,11.3,5,14.6,1.2,"lb/hr",null,4.0000000000000002E-4,"lb/MMBtu",{"$f":"S29","v":2.6888242027399119E-4},9830,null,1850,null,null,null,null,null,4.0000000000000002E-4,8.9161290322580644,3.566451612903226E-3,"original database export===>","5_fPM_T6_R3","n/a","C",4.0000000000000002E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Facility did not provide f-Factor. No QA Calcs.",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","5","2009-05-07T11:32:00","2009-05-07T14:05:00",299.93,204059,14813,11.3,5,14.6,198.3,"Method 17",null,"",false,null,null,"",1.2,"pound per hour (lb/hr)",false,null,null,null,null,null,null,4.0000000000000002E-4,"pound per million British Thermal Unit (lb/MMBtu)",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,{"$f":"AVERAGE(AI27:AI29)","v":5.0000000000000001E-4},null,null,null,null,null,null,null,null,null,null,null,"5_fPM_T6",4.4580645161290322E-3,"Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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_fPM_T1",6.1140424314716111E-3,"Average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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_fPM_T5",9.5105376344086015E-3,"Average"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.0524731182795693E-3,6.9657790118206131E-3,"N1_2007_PM"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1590967741935482E-2,1.1590967741935482E-2,"N1_2006_PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.6748387096774198E-2,2.6748387096774198E-2,"N1_2005_PM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Conversions"]
[7000,null,"gr=",1,"lb"]
[1,null,"ppm SO2=",1.66E-7,"lb/scf"]
[1,null,"ppm Hg=",{"$f":"D81*A87/A88","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==>",44,44,44,44,44,44,44,44,44,44]
[null,"Test Avgs for UPL","R1","R2","R3","R4","R5","R6","R7","R8","R9","R10",null,null,null,null,null,null,"Variability","Variability","Variability",null,"Variability","Variability","Variability"]
["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","report ID",null,"in UPL sht",null,null,"as submitted ","1mg",null,null,"as submitted ","1mg","report ID"]
["5_fPM_T6",{"$f":"AVERAGE(C202:L202)","v":4.4580645161290322E-3},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&C$200,$E:DU,C$199,FALSE),VLOOKUP($A202,$E:DU,C$199,FALSE))","v":7.132903225806452E-3},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":2.674838709677419E-3},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&E$200,$E$11:$DW$100,E$199,FALSE),\"\")","v":3.566451612903226E-3},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&F$200,$E:AX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&G$200,$E:AY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&H$200,$E:AZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&I$200,$E:BA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&J$200,$E:BB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A202&\"_\"&K$200,$E:BC,K$199,FALSE),\"\")","v":""},null,{"$f":"A202","v":"5_fPM_T6"},"N1_2009_PM",{"$f":"B202","v":4.4580645161290322E-3},4.4580645161290322E-3,2.9999999999999997E-4,4.0000000000000002E-4,4.4580645161290322E-3,7.1783940041600242E-3]
["5_fPM_T1",{"$f":"AVERAGE(C203:L203)","v":6.1140424314716111E-3},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&C$200,$E:DU,C$199,FALSE),VLOOKUP($A203,$E:DU,C$199,FALSE))","v":8.5939044639039269E-3},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":4.7903727006354995E-3},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&E$200,$E$11:$DW$100,E$199,FALSE),\"\")","v":4.9578501298754045E-3},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&F$200,$E:AX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&G$200,$E:AY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&H$200,$E:AZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&I$200,$E:BA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&J$200,$E:BB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A203&\"_\"&K$200,$E:BC,K$199,FALSE),\"\")","v":""},null,{"$f":"A203","v":"5_fPM_T1"},"ERT",{"$f":"B203","v":6.1140424314716111E-3},6.1140424314716111E-3,null,null,6.1140424314716103E-3,6.1140424314716103E-3,null,null,5.0524731182795693E-3,6.9657790118206131E-3,"N1_2007_PM"]
["5_fPM_T5",9.5105376344086015E-3,{"$f":"IFERROR(VLOOKUP($A204&\"_\"&C$200,$E:DU,C$199,FALSE),VLOOKUP($A204,$E:DU,C$199,FALSE))","v":8.9161290322580643E-3},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&D$200,$E:DV,D$199,FALSE),\"\")","v":8.9161290322580643E-3},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&E$200,$E$11:$DW$100,E$199,FALSE),\"\")","v":1.0699354838709676E-2},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&F$200,$E:AX,F$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&G$200,$E:AY,G$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&H$200,$E:AZ,H$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&I$200,$E:BA,I$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&J$200,$E:BB,J$199,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A204&\"_\"&K$200,$E:BC,K$199,FALSE),\"\")","v":""},null,{"$f":"A204","v":"5_fPM_T5"},"N1_2008_PM",{"$f":"B204","v":9.5105376344086015E-3},9.5105376344086015E-3,null,null,9.5105376344085998E-3,9.5105376344085998E-3]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1590967741935482E-2,1.1590967741935482E-2,"N1_2006_PM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6748387096774198E-2,2.6748387096774198E-2,"N1_2005_PM"]
[]
[null,"Column Source==>",42,42,42,42,42,42,42,42,42,42]
[null,"Test Avgs for UPL","R1","R2","R3","R4","R5","R6","R7","R8","R9","R10"]
["Test_IDs","lb/MMBtu","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","lb/MW","Test_IDs","report ID"]
["5_fPM_T6",{"$f":"AVERAGE(C212:L212)","v":5.0000000000000001E-4},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&C$210,$E:DU,C$209,FALSE),\"\")","v":8.0000000000000004E-4},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&D$210,$E:DV,D$209,FALSE),\"\")","v":2.9999999999999997E-4},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&E$210,$E:DW,E$209,FALSE),\"\")","v":4.0000000000000002E-4},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&F$210,$E:DX,F$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&G$210,$E:DY,G$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&H$210,$E:DZ,H$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&I$210,$E:EA,I$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&J$210,$E:EB,J$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&K$210,$E:EC,K$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A212&\"_\"&L$210,$E:ED,L$209,FALSE),\"\")","v":""},{"$f":"A212","v":"5_fPM_T6"},"N1_2009_PM",{"$f":"B212","v":5.0000000000000001E-4}]
["5_fPM_T1",{"$f":"AVERAGE(C213:L213)","v":6.8572834795810388E-4},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&C$210,$E:DU,C$209,FALSE),\"\")","v":9.6386048618314656E-4},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&D$210,$E:DV,D$209,FALSE),\"\")","v":5.3727045484696268E-4},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&E$210,$E:DW,E$209,FALSE),\"\")","v":5.5605410284420239E-4},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&F$210,$E:DX,F$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&G$210,$E:DY,G$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&H$210,$E:DZ,H$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&I$210,$E:EA,I$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&J$210,$E:EB,J$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&K$210,$E:EC,K$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A213&\"_\"&L$210,$E:ED,L$209,FALSE),\"\")","v":""},{"$f":"A213","v":"5_fPM_T1"},"ERT",{"$f":"B213","v":6.8572834795810388E-4}]
["5_fPM_T5",1.0666666666666665E-3,{"$f":"IFERROR(VLOOKUP($A214&\"_\"&C$210,$E:DU,C$209,FALSE),\"\")","v":1E-3},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&D$210,$E:DV,D$209,FALSE),\"\")","v":1E-3},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&E$210,$E:DW,E$209,FALSE),\"\")","v":1.1999999999999999E-3},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&F$210,$E:DX,F$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&G$210,$E:DY,G$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&H$210,$E:DZ,H$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&I$210,$E:EA,I$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&J$210,$E:EB,J$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&K$210,$E:EC,K$209,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A214&\"_\"&L$210,$E:ED,L$209,FALSE),\"\")","v":""},{"$f":"A214","v":"5_fPM_T5"},"N1_2008_PM",{"$f":"B214","v":1.0666666666666665E-3}]

{"sheet":"Lognormal Template","index":6,"n_rows":167,"n_cols":12,"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)"]
["Averages","667\nNorthside\n1A"]
[1,4.4580645161290322E-3]
[2,9.5105376344086015E-3]
[3,6.1140424314716111E-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]
["Use for small sample sets that are Lognormal."]
[]
["Testing Normality","Raw Data","Log Data",null,{"$f":"IF(C41<4,\"There are an insufficient number of data points to use the Kurtosis test.\",IF(C44=\"normal\",IF(C47=\"normal\",\"lognormal\",\"non-normal\"),\"non-normal\"))","v":"There are an insufficient number of data points to use the Kurtosis test."}]
["Sample Size",{"$f":"COUNT(B3:L37)","v":3},{"$f":"COUNT(B51:L85)","v":3},null,{"$f":"IF(E40<>\"normal\",\"Review Shape of Curve'\",\"Data are normal; use standard UPL template for normal data.\")","v":"Review Shape of Curve'"}]
["Kurtosis",{"$f":"KURT(B3:L37)","v":{"$error":"#DIV/0!"}},{"$f":"KURT(B51:L85)","v":{"$error":"#DIV/0!"}},null,"lognormal data"]
["SE Kurtosis",{"$f":"SQRT((B41^2-1)/((B41-3)*(B41+5)))","v":{"$error":"#DIV/0!"}},{"$f":"SQRT((C41^2-1)/((C41-3)*(C41+5)))","v":{"$error":"#DIV/0!"}}]
["Result Kurtosis",{"$f":"IF(ABS(B42/B43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(C42/C43)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":{"$error":"#DIV/0!"}}]
["Skewness",{"$f":"SKEW(B3:L37)","v":0.96218434570217326},{"$f":"SKEW(B51:L85)","v":0.49032574028019044}]
["SE Skewness",{"$f":"SQRT((6*B41*(B41-1))/((B41-2)*(B41+1)*(B41+3)))","v":1.2247448713915889},{"$f":"SQRT((6*C41*(C41-1))/((C41-2)*(C41+1)*(C41+3)))","v":1.2247448713915889}]
["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":-5.4130405721337134},{"$f":"IF(C3>0,LN(C3),\"\")","v":""},"","","","","","","","",""]
[2,{"$f":"IF(B4>0,LN(B4),\"\")","v":-4.6553548704361978},"","","","","","","","","",""]
[3,{"$f":"IF(B5>0,LN(B5),\"\")","v":-5.0971671154866094},"","","","","","","","","",""]
[4,{"$f":"IF(B6>0,LN(B6),\"\")","v":""},"","","","","","","","","",""]
[5,{"$f":"IF(B7>0,LN(B7),\"\")","v":""},"","","","","","","","","",""]
[6,{"$f":"IF(B8>0,LN(B8),\"\")","v":""},"","","","","","","","","",""]
[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":3}]
[]
["Average of Raw Data",null,{"$f":"AVERAGE(B3:L37)","v":6.6942148606697486E-3}]
[]
[]
["3. Calculate ",null,null,{"$f":"AVERAGE(B51:L85)","v":-5.0551875193521738}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"VAR(B51:L85)","v":0.14484362050792191}]
["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.8814271566476464}]
[]
[]
["b- denominator first term",null,null,null,null,{"$f":"C108*(EXP(E102)-1)^2","v":2.4291966635208169E-2}]
[]
[]
[]
[null,null,{"$f":"F114/F117+3*(1-1/C108)","v":242.1140801388741}]
[]
[]
["7. Calculate"]
[null,null,null,null,null,{"$f":"SQRT(EXP(E102)-1)*(EXP(E102)+2)/SQRT(C108)","v":1.2459001357898949}]
[]
[]
["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":6.8550771662757521E-3}]
[]
[]
["b- Calculate",null,null,{"$f":"EXP(2*D92+E102)","v":4.6992082955595199E-5}]
[]
[]
[]
["c- Calculate ",null,null,{"$f":"EXP(E102)-1","v":0.15585880352167525}]
[]
[]
[]
["d-calculate",null,null,null,{"$f":"(E102)/C87+(E102^2)/(2*(C87-1))","v":5.3526125436434695E-2}]
[]
[]
[]
["e- Calculate",null,null,null,null,null,null,{"$f":"SQRT(C108*D149*D153+C108^2*D149*E157)","v":3.1367872020988145E-3}]
[]
[]
[]
["f- Calculate UPL",null,null,{"$f":"D146+(J136/C108)*H161","v":1.7783643778388022E-2},"lb fPM/MW"]
[]
[null,null,null,{"$f":"D165","v":1.7783643778388022E-2}]

{"sheet":"lognormal distribution 99 %","index":7,"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":242.1140801388741},null,{"$f":"'Lognormal Template'!F125","v":1.2459001357898949}]
[]
[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":4740.5139269430947},null,null,null,null,null,null,{"$f":"NORMDIST(B9,0,1,FALSE)","v":1.4867195147342977E-6},null,{"$f":"G9*N9","v":7.0478145650560179E-3},null,null,null,null,null,{"$f":"ABS(P9)","v":7.0478145650560179E-3},null,null,{"$f":"($A$7/2)*V9","v":3.5591463553532893E-4},null,null,null,null,{"$f":"Y9","v":3.5591463553532893E-4},{"$f":"AD9/SUM($Y$9:$Y$108)","v":1.2717162344555783E-5},{"$f":"IF(AE9>0.99,\"x\",\"\")","v":""},9]
[1,{"$f":"$B$9+A10*$A$7","v":-4.899},null,null,null,null,4313.6637801462084,null,null,null,null,null,null,2.4509397556839956E-6,null,1.0572530051414449E-2,null,null,null,null,null,1.0572530051414449E-2,null,null,{"$f":"($A$7)*V10","v":1.0678255351928595E-3},null,null,null,null,{"$f":"Y10+AD9","v":1.4237401707281885E-3},5.0871566043871499E-5,{"$f":"IF(AE10>0.99,\"x\",\"\")","v":""},10]
[2,-4.798,null,null,null,null,3914.8045199427302,null,null,null,null,null,null,3.9995026854766194E-6,null,1.5657271190626956E-2,null,null,null,null,null,1.5657271190626956E-2,null,null,1.5813843902533226E-3,null,null,null,null,3.0051245609815109E-3,1.0737590728780334E-4,"",11]
[3,-4.6970000000000001,null,null,null,null,3542.7429560659994,null,null,null,null,null,null,6.4602468217096111E-6,null,2.2886993922059486E-2,null,null,null,null,null,2.2886993922059486E-2,null,null,2.3115863861280081E-3,null,null,null,null,5.3167109471095189E-3,1.8997104783783809E-4,"",12]
[4,-4.5960000000000001,null,null,null,null,3196.31078055643,null,null,null,null,null,null,1.0329088331249594E-5,null,3.3014976386492707E-2,null,null,null,null,null,3.3014976386492707E-2,null,null,3.3345126150357636E-3,null,null,null,null,8.651223562145283E-3,3.0911629793860213E-4,"",13]
[5,-4.4950000000000001,null,null,null,null,2874.3645677614963,null,null,null,null,null,null,1.6347247339999862E-5,null,4.6987948534528971E-2,null,null,null,null,null,4.6987948534528971E-2,null,null,4.7457828019874266E-3,null,null,null,null,1.339700636413271E-2,4.7868754991619656E-4,"",14]
[6,-4.3940000000000001,null,null,null,null,2575.7857743357331,null,null,null,null,null,null,2.5609260510355175E-5,null,6.5963968913830717E-2,null,null,null,null,null,6.5963968913830717E-2,null,null,6.6623608602969031E-3,null,null,null,null,2.0059367224429612E-2,7.1673992596129428E-4,"",15]
[7,-4.2930000000000001,null,null,null,null,2299.4807392407456,null,null,null,null,null,null,3.97117663248513E-5,null,9.1316441785224814E-2,null,null,null,null,null,9.1316441785224814E-2,null,null,9.2229606203077068E-3,null,null,null,null,2.9282327844737319E-2,1.0462849229785792E-3,"",16]
[8,-4.1920000000000002,null,null,null,null,2044.3806837451989,null,null,null,null,null,null,6.0955252216615318E-5,null,0.12461574020446507,null,null,null,null,null,0.12461574020446507,null,null,1.2586189760650974E-2,null,null,null,null,4.1868517605388289E-2,1.4960012383665035E-3,"",17]
[9,-4.0910000000000002,null,null,null,null,1809.4417114248217,null,null,null,null,null,null,9.2613185614433534E-5,null,0.16757816107868528,null,null,null,null,null,0.16757816107868528,null,null,1.6925394268947215E-2,null,null,null,null,5.8793911874335504E-2,2.1007613835627528E-3,"",18]
[10,-3.99,null,null,null,null,1593.6448081624089,null,null,null,null,null,null,1.3928497646575994E-4,null,0.22197077959968164,null,null,null,null,null,0.22197077959968164,null,null,2.2419048739567848E-2,null,null,null,null,8.1212960613903346E-2,2.9018149339534688E-3,"",19]
[11,-3.8890000000000002,null,null,null,null,1395.9958421478186,null,null,null,null,null,null,2.0735069214939127E-4,null,0.28946070410702257,null,null,null,null,null,0.28946070410702257,null,null,2.9235531114809282E-2,null,null,null,null,0.11044849172871263,3.9464277660645457E-3,"",20]
[12,-3.7879999999999998,null,null,null,null,1215.525563877972,null,null,null,null,null,null,3.0554590364653618E-4,null,0.3713988568205604,null,null,null,null,null,0.3713988568205604,null,null,3.7511284538876602E-2,null,null,null,null,0.14795977626758922,5.286740997399386E-3,"",21]
[13,-3.6869999999999998,null,null,null,null,1051.2896061568567,null,null,null,null,null,null,4.4567390271459394E-4,null,0.46853234165921476,null,null,null,null,null,0.46853234165921476,null,null,4.7321766507580694E-2,null,null,null,null,0.1952815427751699,6.9775919122624531E-3,"",22]
[14,-3.5859999999999999,null,null,null,null,902.36848409552124,null,null,null,null,null,null,6.4346911127639178E-4,null,0.58064624650476993,null,null,null,null,null,0.58064624650476993,null,null,5.8645270896981766E-2,null,null,null,null,0.25392681367215164,9.0730422148767708E-3,"",23]
[15,-3.4849999999999999,null,null,null,null,767.86759511208038,null,null,null,null,null,null,9.196190652258089E-4,null,0.70614568003416123,null,null,null,null,null,0.70614568003416123,null,null,7.132071368345029E-2,null,null,null,null,0.32524752735560192,1.1621397926851946E-2,"",24]
[16,-3.3839999999999999,null,null,null,null,646.91721893171155,null,null,null,null,null,null,1.3009421669529307E-3,null,0.84160188863618424,null,null,null,null,null,0.84160188863618424,null,null,8.5001790752254613E-2,null,null,null,null,0.41024931810785653,1.4658591300337373E-2,"",25]
[17,-3.2829999999999999,null,null,null,null,538.6725175866568,null,null,null,null,null,null,1.8217038523946315E-3,null,0.98130180046672755,null,null,null,null,null,0.98130180046672755,null,null,9.9111481847139485E-2,null,null,null,null,0.50936079995499606,1.8199937114801511E-2,"",26]
[18,-3.1819999999999999,null,null,null,null,442.31353541622207,null,null,null,null,null,null,2.5250345499379808E-3,null,1.1168569588311774,null,null,null,null,null,1.1168569588311774,null,null,0.11280255284194893,null,null,null,null,0.62216335279694501,2.2230477683086187E-2,"",27]
[19,-3.081,null,null,null,null,357.04519906677757,null,null,null,null,null,null,3.4643888734137819E-3,null,1.236943414952753,null,null,null,null,null,1.236943414952753,null,null,0.12493128491022805,null,null,null,null,0.7470946377071731,2.6694389176154354E-2,"",28]
[20,-2.98,null,null,null,null,282.09731749175683,null,null,null,null,null,null,4.7049575269339792E-3,null,1.3272558972607258,null,null,null,null,null,1.3272558972607258,null,null,0.13405284562333331,null,null,null,null,0.88114748333050641,3.148422255285005E-2,"",29]
[21,-2.879,null,null,null,null,216.72458195165791,null,null,null,null,null,null,6.3249127862128329E-3,null,1.3707640794726721,null,null,null,null,null,1.3707640794726721,null,null,0.1384471720267399,null,null,null,null,1.0195946553572464,3.6431069316149076E-2,"",30]
[22,-2.778,null,null,null,null,160.20656601404312,null,null,null,null,null,null,8.416337402369389E-3,null,1.3483525136491517,null,null,null,null,null,1.3483525136491517,null,null,0.13618360387856432,null,null,null,null,1.1557782592358108,4.129703667538815E-2,"",31]
[23,-2.677,null,null,null,null,111.84772555353794,null,null,null,null,null,null,1.1085658498589472E-2,null,1.2399056893304807,null,null,null,null,null,1.2399056893304807,null,null,0.12523047462237857,null,null,null,null,1.2810087338581893,4.5771638496308428E-2,"",32]
[24,-2.5759999999999996,null,null,null,null,70.977398751832439,null,null,null,null,null,null,1.4453386482878732E-2,null,1.0258637757096287,null,null,null,null,null,1.0258637757096287,null,null,0.1036122413466725,null,null,null,null,1.3846209752048617,4.9473800651306785E-2,"",33]
[25,-2.4749999999999996,null,null,null,null,36.949806097680636,null,null,null,null,null,null,1.8652948792269922E-2,null,0.68922284102433984,null,null,null,null,null,0.68922284102433984,null,null,6.9611506943458329E-2,null,null,null,null,1.4542324821483201,5.1961084810098451E-2,"",34]
[26,-2.3739999999999997,null,null,null,null,9.1440503869005028,null,null,null,null,null,null,2.3828414277471986E-2,null,0.21788822079314318,null,null,null,null,null,0.21788822079314318,null,null,2.2006710300107462E-2,null,null,null,null,1.4762391924484275,5.2747405122931704E-2,"",35]
[27,-2.2729999999999997,null,null,null,null,-13.035883277626182,null,null,null,null,null,null,3.0130930809477742E-2,null,-0.39278329707858239,null,null,null,null,null,0.39278329707858239,null,null,3.9671113004936823E-2,null,null,null,null,1.5159103054533642,5.416489104259381E-2,"",36]
[28,-2.1719999999999997,null,null,null,null,-30.161127485953394,null,null,null,null,null,null,3.7713749861696219E-2,null,-1.1374892175519769,null,null,null,null,null,1.1374892175519769,null,null,0.11488641097274967,null,null,null,null,1.6307967164261139,5.8269889808172208E-2,"",37]
[29,-2.0709999999999997,null,null,null,null,-42.777932521071257,null,null,null,null,null,null,4.6725789305731173E-2,null,-1.998832661914361,null,null,null,null,null,1.998832661914361,null,null,0.20188209885335048,null,null,null,null,1.8326788152794644,6.5483325753890362E-2,"",38]
[30,-1.9699999999999998,null,null,null,null,-51.407666358905864,null,null,null,null,null,null,5.7303788919117152E-2,null,-2.9458540618551416,null,null,null,null,null,2.9458540618551416,null,null,0.29753126024736931,null,null,null,null,2.1302100755268336,7.611439557054725E-2,"",39]
[31,-1.8689999999999998,null,null,null,null,-56.546814668319257,null,null,null,null,null,null,6.9563238531014968E-2,null,-3.9335795569413885,null,null,null,null,null,3.9335795569413885,null,null,0.39729153525108024,null,null,null,null,2.527501610777914,9.0309993187111914E-2,"",40]
[32,-1.7679999999999998,null,null,null,null,-58.666980811109539,null,null,null,null,null,null,8.3588399272377337E-2,null,-4.9038790161439234,null,null,null,null,null,4.9038790161439234,null,null,0.4952917806305363,null,null,null,null,3.0227933914084502,0.10800723110127858,"",41]
[33,-1.6669999999999998,null,null,null,null,-58.21488584201083,null,null,null,null,null,null,9.9421883540771347E-2,null,-5.7878336005236992,null,null,null,null,null,5.7878336005236992,null,null,0.58457119365289367,null,null,null,null,3.6073645850613438,0.12889450582785184,"",42]
[34,-1.5659999999999998,null,null,null,null,-55.61236850869318,null,null,null,null,null,null,0.11705439552546529,null,-6.5096721795245021,null,null,null,null,null,6.5096721795245021,null,null,0.65747689013197474,null,null,null,null,4.2648414751933181,0.15238676918202915,"",43]
[35,-1.4649999999999999,null,null,null,null,-51.256385251762701,null,null,null,null,null,null,0.13641534591340351,null,-6.9921575243898832,null,null,null,null,null,6.9921575243898832,null,null,0.70620790996337823,null,null,null,null,4.9710493851566966,0.17762023738854307,"",44]
[36,-1.3639999999999999,null,null,null,null,-45.519010204761507,null,null,null,null,null,null,0.15736512556566029,null,-7.1631047564968666,null,null,null,null,null,7.1631047564968666,null,null,0.72347358040618359,null,null,null,null,5.6945229655628804,0.20347062412575609,"",45]
[37,-1.2629999999999999,null,null,null,null,-38.74743519416765,null,null,null,null,null,null,0.17968983860954071,null,-6.9625203765736225,null,null,null,null,null,6.9625203765736225,null,null,0.70321455803393595,null,null,null,null,6.3977375235968168,0.22859713707210252,"",46]
[38,-1.1619999999999999,null,null,null,null,-31.263969739395275,null,null,null,null,null,null,0.20309924389892503,null,-6.3496886153500522,null,null,null,null,null,6.3496886153500522,null,null,0.64131855015035533,null,null,null,null,7.0390560737471723,0.25151204784718262,"",47]
[39,-1.0609999999999999,null,null,null,null,-23.366041052794472,null,null,null,null,null,null,0.22722852877998642,null,-5.3094311318392533,null,null,null,null,null,5.3094311318392533,null,null,0.53625254431576463,null,null,null,null,7.5753086180629374,0.27067285210432518,"",48]
[40,-0.96,null,null,null,null,-15.326194039651345,null,null,null,null,null,null,0.25164434109811712,null,-3.8567500006499524,null,null,null,null,null,3.8567500006499524,null,null,0.38953175006564522,null,null,null,null,7.9648403681285824,0.28459118534873601,"",49]
[41,-0.85899999999999999,null,null,null,null,-7.3920912981879985,null,null,null,null,null,null,0.27585524287120494,null,-2.039147140387771,null,null,null,null,null,2.039147140387771,null,null,0.20595386117916489,null,null,null,null,8.1707942293077469,0.29195010916529696,"",50]
[42,-0.75800000000000001,null,null,null,null,0.21348688043745523,null,null,null,null,null,null,0.29932643861165642,null,6.3902267611655975E-2,null,null,null,null,null,6.3902267611655975E-2,null,null,6.4541290287772534E-3,null,null,null,null,8.1772483583365236,0.29218072122351763,"",51]
[43,-0.65700000000000003,null,null,null,null,7.2926425121308807,null,null,null,null,null,null,0.32149829672959446,null,2.3445721463079092,null,null,null,null,null,2.3445721463079092,null,null,0.23680178677709884,null,null,null,null,8.414050145113622,0.30064187023301464,"",52]
[44,-0.55600000000000005,null,null,null,null,13.672359919862174,null,null,null,null,null,null,0.34180785297801497,null,4.6733199893507544,null,null,null,null,null,4.6733199893507544,null,null,0.47200531892442621,null,null,null,null,8.8860554640380478,0.31750706112135035,"",53]
[45,-0.45500000000000007,null,null,null,null,19.204505733665219,null,null,null,null,null,null,0.35971219226542389,null,6.9080948588306184,null,null,null,null,null,6.9080948588306184,null,null,0.6977175807418925,null,null,null,null,9.5837730447799405,0.34243716193498941,"",54]
[46,-0.35400000000000009,null,null,null,null,23.765828890637888,null,null,null,null,null,null,0.37471238028421117,null,8.9053503130381966,null,null,null,null,null,8.9053503130381966,null,null,0.89944038161685791,null,null,null,null,10.483213426396798,0.37457500682879791,"",55]
[47,-0.25300000000000011,null,null,null,null,27.257960634942052,null,null,null,null,null,null,0.38637648574037453,null,10.531835038578379,null,null,null,null,null,10.531835038578379,null,null,1.0637153388964162,null,null,null,null,11.546928765293215,0.41258254937560374,"",56]
[48,-0.15199999999999925,null,null,null,null,29.607414517803608,null,null,null,null,null,null,0.39436021613719047,null,11.675986388504421,null,null,null,null,null,11.675986388504421,null,null,1.1792746252389465,null,null,null,null,12.726203390532161,0.45471913315340184,"",57]
[49,-5.0999999999999268E-2,null,null,null,null,30.765586397512372,null,null,null,null,null,null,0.39842379318515947,null,12.257741632062626,null,null,null,null,null,12.257741632062626,null,null,1.2380319048383253,null,null,null,null,13.964235295370486,0.49895516940936468,"",58]
[50,5.0000000000000711E-2,null,null,null,null,30.70875443942225,null,null,null,null,null,null,0.39844391409476398,null,12.235716315818362,null,null,null,null,null,12.235716315818362,null,null,1.2358073478976546,null,null,null,null,15.200042643268141,0.54311172016814746,"",59]
[51,0.15100000000000069,null,null,null,null,29.438079115951087,null,null,null,null,null,null,0.39441996623589087,null,11.610966170962913,null,null,null,null,null,11.610966170962913,null,null,1.1727075832672542,null,null,null,null,16.372750226535395,0.58501365740281608,"",60]
[52,0.25200000000000067,null,null,null,null,26.979603206580766,null,null,null,null,null,null,0.38647405812101859,null,10.426916737742115,null,null,null,null,null,10.426916737742115,null,null,1.0531185905119536,null,null,null,null,17.425868817047348,0.62264256823270214,"",61]
[53,0.35300000000000065,null,null,null,null,23.384251797857132,null,null,null,null,null,null,0.37484486452585164,null,8.7654666972061595,null,null,null,null,null,8.7654666972061595,null,null,0.88531213641782214,null,null,null,null,18.311180953465172,0.6542755977300615,"",62]
[54,0.45400000000000063,null,null,null,null,18.72783228339004,null,null,null,null,null,null,0.3598757186153565,null,6.7396921010928637,null,null,null,null,null,6.7396921010928637,null,null,0.68070890221037927,null,null,null,null,18.991889855675552,0.67859796257401717,"",63]
[55,0.5550000000000006,null,null,null,null,13.111034363853351,null,null,null,null,null,null,0.3419977799876871,null,4.4839446457801238,null,null,null,null,null,4.4839446457801238,null,null,0.45287840922379252,null,null,null,null,19.444768264899345,0.69477973111461278,"",64]
[56,0.65600000000000058,null,null,null,null,6.6594300469849088,null,null,null,null,null,null,0.3217094296581981,null,2.1424014422641822,null,null,null,null,null,2.1424014422641822,null,null,0.21638254566868242,null,null,null,null,19.661150810568028,0.7025112815681589,"",65]
[57,0.75700000000000056,null,null,null,null,-0.476526352413426,null,null,null,null,null,null,0.29955326428828344,null,-0.14274502438483069,null,null,null,null,null,0.14274502438483069,null,null,1.4417247462867901E-2,null,null,null,null,19.675568058030898,0.70302642328541698,"",66]
[58,0.85800000000000054,null,null,null,null,-8.1214982124758226,null,null,null,null,null,null,0.27609216628203237,null,-2.2422820349381034,null,null,null,null,null,2.2422820349381034,null,null,0.22647048552874846,null,null,null,null,19.902038543559645,0.71111842525208957,"",67]
[59,0.95900000000000052,null,null,null,null,-16.075266604272429,null,null,null,null,null,null,0.25188590971741259,null,-4.0491331525671024,null,null,null,null,null,4.0491331525671024,null,null,0.40896244840927737,null,null,null,null,20.311000991968921,0.72573103549618712,"",68]
[60,1.0600000000000005,null,null,null,null,-24.112730291809406,null,null,null,null,null,null,0.22746963245738577,null,-5.4849138970219578,null,null,null,null,null,5.4849138970219578,null,null,0.55397630359921779,null,null,null,null,20.864977295568139,0.74552512622615053,"",69]
[61,1.1610000000000005,null,null,null,null,-31.983905732028916,null,null,null,null,null,null,0.20333528072256271,null,-6.5034564506260821,null,null,null,null,null,6.5034564506260821,null,null,0.65684910151323439,null,null,null,null,21.521826397081373,0.76899495810663876,"",70]
[62,1.2620000000000005,null,null,null,null,-39.413927074809138,null,null,null,null,null,null,0.17991684029544777,null,-7.091229222934861,null,null,null,null,null,7.091229222934861,null,null,0.71621415151642098,null,null,null,null,22.238040548597795,0.7945859586694648,"",71]
[63,1.3630000000000004,null,null,null,null,-46.103046162964219,null,null,null,null,null,null,0.15757983926216645,null,-7.2649106038561415,null,null,null,null,null,7.2649106038561415,null,null,0.73375597098947032,null,null,null,null,22.971796519587265,0.82080374482575791,"",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":-51.726632532244338},null,null,null,null,null,null,{"$f":"NORMDIST(B73,0,1,FALSE)","v":0.1366152725480389},null,{"$f":"G73*N73","v":-7.0666480013848156},null,null,null,null,null,{"$f":"ABS(P73)","v":7.0666480013848156},null,null,0.71373144813986644,null,null,null,null,23.685527967727133,{"$f":"AD73/SUM($Y$9:$Y$108)","v":0.84630603607814614},"",73]
[65,{"$f":"$B$9+A74*$A$7","v":1.5650000000000004},null,null,null,null,-55.935173411335676,null,null,null,null,null,null,0.11723778769442594,null,-6.5577159850490707,null,null,null,null,null,6.5577159850490707,null,null,{"$f":"($A$7)*V74","v":0.66232931448995613},null,null,null,null,{"$f":"Y74+AD73","v":24.347857282217088},0.86997168108669776,{"$f":"IF(AE74>0.99,\"x\",\"\")","v":""},74]
[66,1.6660000000000004,null,null,null,null,-58.35427372186038,null,null,null,null,null,null,9.9587708244748885E-2,null,-5.8113683862468486,null,null,null,null,null,5.8113683862468486,null,null,0.58694820701093176,null,null,null,null,24.934805489228019,0.89094388872063479,"",75]
[67,1.7670000000000003,null,null,null,null,-58.584656078376668,null,null,null,null,null,null,8.3736272412481758E-2,null,-4.9056607205705038,null,null,null,null,null,4.9056607205705038,null,null,0.49547173277762091,null,null,null,null,25.430277222005639,0.90864755649308837,"",76]
[68,1.8680000000000003,null,null,null,null,-56.202160788378698,null,null,null,null,null,null,6.9693338950675629E-2,null,-3.9169162415848477,null,null,null,null,null,3.9169162415848477,null,null,0.39560854040006965,null,null,null,null,25.825885762405708,0.9227830191317441,"",77]
[69,1.9690000000000003,null,null,null,null,-50.757745852296644,null,null,null,null,null,null,5.7416759943091943E-2,null,-2.914345308853787,null,null,null,null,null,2.914345308853787,null,null,0.2943488761942325,null,null,null,null,26.120234638599939,0.93330037939390176,"",78]
[70,2.0700000000000003,null,null,null,null,-41.777486963496756,null,null,null,null,null,null,4.6822635277683121E-2,null,-1.9561320349099698,null,null,null,null,null,1.9561320349099698,null,null,0.19756933552590697,null,null,null,null,26.317803974125844,0.94035971627789894,"",79]
[71,2.1710000000000003,null,null,null,null,-28.76257750828114,null,null,null,null,null,null,3.7795734251856623E-2,null,-1.0871027359014225,null,null,null,null,null,1.0871027359014225,null,null,0.10979737632604368,null,null,null,null,26.427601350451887,0.94428287908249775,"",80]
[72,2.2720000000000002,null,null,null,null,-11.189328565888003,null,null,null,null,null,null,3.0199481210634573E-2,null,-0.33791191778515145,null,null,null,null,null,0.33791191778515145,null,null,3.4129103696300296E-2,null,null,null,null,26.461730454148189,0.94550234383344078,"",81]
[73,2.3730000000000002,null,null,null,null,11.49083109150849,null,null,null,null,null,null,2.3885038190605869E-2,null,0.27445893946248162,null,null,null,null,null,0.27445893946248162,null,null,2.7720352885710644E-2,null,null,null,null,26.489450807033901,0.94649281793228124,"",82]
[74,2.4740000000000002,null,null,null,null,39.851354998798065,null,null,null,null,null,null,1.8699162668593644E-2,null,0.74518696968639753,null,null,null,null,null,0.74518696968639753,null,null,7.5263883938326157E-2,null,null,null,null,26.564714690972227,0.94918206680030226,"",83]
[75,2.5750000000000002,null,null,null,null,74.490578997934534,null,null,null,null,null,null,1.4490659157048438E-2,null,1.0794175906702601,null,null,null,null,null,1.0794175906702601,null,null,0.10902117665769628,null,null,null,null,26.673735867629922,0.95307749526579666,"",84]
[76,2.6760000000000002,null,null,null,null,116.03172123793568,null,null,null,null,null,null,1.1115369005911058E-2,null,1.2897353979506623,null,null,null,null,null,1.2897353979506623,null,null,0.13026327519301689,null,null,null,null,26.803999142822938,0.95773192375163707,"",85]
[77,2.7770000000000001,null,null,null,null,165.12288217488333,null,null,null,null,null,null,8.4397462735252959E-3,null,1.393595229509228,null,null,null,null,null,1.393595229509228,null,null,0.14075311818043204,null,null,null,null,26.944752261003369,0.96276116412471324,"",86]
[78,2.8780000000000001,null,null,null,null,222.43704457192337,null,null,null,null,null,null,6.3431452761899725E-3,null,1.410950488526054,null,null,null,null,null,1.410950488526054,null,null,0.14250599934113145,null,null,null,null,27.087258260344502,0.96785303657881594,"",87]
[79,2.9790000000000001,null,null,null,null,288.67207349926548,null,null,null,null,null,null,4.7189968525847836E-3,null,1.3622426062721571,null,null,null,null,null,1.3622426062721571,null,null,0.13758650323348787,null,null,null,null,27.224844763577991,0.97276913084228533,"",88]
[80,3.08,null,null,null,null,364.55071633418322,null,null,null,null,null,null,3.4750773778549375E-3,null,1.2668419474137325,null,null,null,null,null,1.2668419474137325,null,null,0.12795103668878699,null,null,null,null,27.352795800266779,0.97734094088678691,"",89]
[81,3.1810000000000009,null,null,null,null,450.82060276101583,null,null,null,null,null,null,2.5330807400485967E-3,null,1.1419649860710284,null,null,null,null,null,1.1419649860710284,null,null,0.11533846359317387,null,null,null,null,27.468134263859952,0.9814620919147008,"",90]
[82,3.282,null,null,null,null,548.25424477116201,null,null,null,null,null,null,1.8276934202903908E-3,null,1.0020406758145302,null,null,null,null,null,1.0020406758145302,null,null,0.10120610825726756,null,null,null,null,27.569340372117221,0.98507828068713643,"",91]
[83,3.3830000000000009,null,null,null,null,657.64903666309112,null,null,null,null,null,null,1.305351359820449E-3,null,0.8584630642927743,null,null,null,null,null,0.8584630642927743,null,null,8.6704769493570213E-2,null,null,null,null,27.65604514161079,0.98817632308159575,"",92]
[84,3.484,null,null,null,null,779.82725504232963,null,null,null,null,null,null,9.2282906723667468E-4,null,0.71964725837644949,null,null,null,null,null,0.71964725837644949,null,null,7.268437309602141E-2,null,null,null,null,27.72872951470681,0.99077340361801169,"x",93]
[85,3.5850000000000009,null,null,null,null,915.63605882147465,null,null,null,null,null,null,6.4578041088110192E-4,null,0.5912998302832847,null,null,null,null,null,0.5912998302832847,null,null,5.9721282858611759E-2,null,null,null,null,27.788450797565421,0.99290730083298784,"x",94]
[86,3.6859999999999999,null,null,null,null,1065.9474892201804,null,null,null,null,null,null,4.4731991169886799E-4,null,0.47681953675360111,null,null,null,null,null,0.47681953675360111,null,null,4.8158773212113717E-2,null,null,null,null,27.836609570777533,0.99462805877915073,"x",95]
[87,3.7870000000000008,null,null,null,null,1231.6584697651724,null,null,null,null,null,null,3.0670535307791695E-4,null,0.37775624584073408,null,null,null,null,null,0.37775624584073408,null,null,3.8153380829914145E-2,null,null,null,null,27.874762951607448,0.99599131471066893,"x",96]
[88,3.8879999999999999,null,null,null,null,1413.6908062902321,null,null,null,null,null,null,2.0815854496572918E-4,null,0.29427182126880325,null,null,null,null,null,0.29427182126880325,null,null,2.972145394814913E-2,null,null,null,null,27.904484405555596,0.99705329001945708,"x",97]
[89,3.9890000000000008,null,null,null,null,1612.9911869362149,null,null,null,null,null,null,1.3984176379239904E-4,null,0.22556353256275555,null,null,null,null,null,0.22556353256275555,null,null,2.2781916788838313E-2,null,null,null,null,27.927266322344433,0.99786730918415933,"x",98]
[90,4.09,null,null,null,null,1830.5311821510272,null,null,null,null,null,null,9.2992795718445907E-5,null,0.17022621227801576,null,null,null,null,null,0.17022621227801576,null,null,1.7192847440079595E-2,null,null,null,null,27.944459169784512,0.99848162568095589,"x",99]
[91,4.1910000000000007,null,null,null,null,2067.3072446896554,null,null,null,null,null,null,6.1211282356604617E-5,null,0.12654252747255282,null,null,null,null,null,0.12654252747255282,null,null,1.2780795274727835E-2,null,null,null,null,27.957239965059241,0.99893829543311929,"x",100]
[92,4.2919999999999998,null,null,null,null,2324.3407096141314,null,null,null,null,null,null,3.988259546153366E-5,null,9.2700740236314486E-2,null,null,null,null,null,9.2700740236314486E-2,null,null,9.3627747638677632E-3,null,null,null,null,27.966602739823109,0.99927283612006956,"x",101]
[93,4.3930000000000007,null,null,null,null,2602.6777942935723,null,null,null,null,null,null,2.5722022324537423E-5,null,6.6946136328397091E-2,null,null,null,null,null,6.6946136328397091E-2,null,null,6.7615597691681063E-3,null,null,null,null,27.973364299592276,0.99951443296577824,"x",102]
[94,4.4939999999999998,null,null,null,null,2903.3895984041364,null,null,null,null,null,null,1.6420885402344505E-5,null,4.7676227873753363E-2,null,null,null,null,null,4.7676227873753363E-2,null,null,4.8152990152490896E-3,null,null,null,null,27.978179598607525,0.99968648809698235,"x",103]
[95,4.5950000000000006,null,null,null,null,3227.5721039290675,null,null,null,null,null,null,1.0376664891989014E-5,null,3.3491434137203874E-2,null,null,null,null,null,3.3491434137203874E-2,null,null,3.3826348478575917E-3,null,null,null,null,27.981562233455382,0.99980735279940702,"x",104]
[96,4.6960000000000015,null,null,null,null,3576.346175158661,null,null,null,null,null,null,6.4906587297709424E-6,null,2.3212842522476483E-2,null,null,null,null,null,2.3212842522476483E-2,null,null,2.344497094770125E-3,null,null,null,null,27.983906730550153,{"$f":"AD105/SUM($Y$9:$Y$108)","v":0.99989112387031476},"x",105]
[97,{"$f":"$B$9+A106*$A$7","v":4.7970000000000006},null,null,null,null,3950.8575586902675,null,null,null,null,null,null,4.0187363995916616E-6,null,1.5877455080710427E-2,null,null,null,null,null,1.5877455080710427E-2,null,null,1.6036229631517531E-3,null,null,null,null,27.985510353513305,{"$f":"AD106/SUM($Y$9:$Y$108)","v":0.99994842281653873},"x",106]
[98,{"$f":"$B$9+A107*$A$7","v":4.8980000000000015},null,null,null,null,4352.2768834283306,null,null,null,null,null,null,2.4629751376704828E-6,null,1.0719549756141953E-2,null,null,null,null,null,1.0719549756141953E-2,null,null,1.0826745253703373E-3,null,null,null,null,27.986593028038676,{"$f":"AD107/SUM($Y$9:$Y$108)","v":0.99998710778852584},"x",107]
[99,{"$f":"$B$9+A108*$A$7","v":4.9990000000000006},null,null,null,null,4781.7996605843227,null,null,null,null,null,null,1.4941709802283004E-6,null,7.1448262861106317E-3,null,null,null,null,null,7.1448262861106317E-3,null,null,{"$f":"($A$7/2)*V108","v":3.6081372744858691E-4},null,null,null,null,27.986953841766123,{"$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":1411.4492058366532}]

{"sheet":"PetCoke_fPM_New_nonnormal n<3","index":8,"n_rows":167,"n_cols":12,"rows_kept":167,"cut":false,"hidden":false,"merged":[[153,0,153,7],[158,1,158,2],[159,1,159,6],[163,1,163,3],[0,1,0,11],[40,0,40,4],[43,0,43,4],[149,0,149,9],[151,0,151,7]]}
[null,"Emissions (lb/MW)"]
["Runs","667\nNorthside\n1A"]
[1,4.4580645161290322E-3]
[2,9.5105376344086015E-3]
[3,6.1140424314716111E-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]
[]
["n for each source",{"$f":"COUNT(B3:B37)","v":3},{"$f":"COUNT(C3:C37)","v":0},0,0,0,0,0,0,0,0,0]
["Sample size",{"$f":"SUM(B39:L39)","v":3}]
["If sample size is less than 4 test runs use the kurtosis calculation section below "]
["NOTE: Sample size is the number of test runs used to calculate the average"]
[]
["KURTOSIS CALCULATIONS WHEN TOTAL NUMBER TEST RUNS IS LESS THAN 4"]
["Average",{"$f":"AVERAGE(B3:L37)","v":6.6942148606697486E-3}]
["Standard Deviation",{"$f":"STDEV(B3:L37)","v":2.5757176065003069E-3}]
[1,{"$f":"((B3-$B$45)/($B$46))^4","v":0.56808197703351271}]
[2,{"$f":"((B4-$B$45)/($B$46))^4","v":1.4293438640209744}]
[3,{"$f":"((B5-$B$45)/($B$46))^4","v":2.5741589455132259E-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]
[]
["Testing Normality","Raw Data"]
["Sample Size",{"$f":"COUNT(B3:L37)","v":3}]
["Kurtosis",{"$f":"SUM(B47:L81)/($B$84-1)-3","v":-1.9999999999999998}]
["SE Kurtosis",{"$f":"SQRT(24/B84)","v":2.8284271247461903}]
["Result Kurtosis",{"$f":"IF(ABS(B85/B86)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"}]
["Skewness",{"$f":"SKEW(B3:L37)","v":0.96218434570217326}]
["SE Skewness",{"$f":"SQRT((6*B84*(B84-1))/((B84-2)*(B84+1)*(B84+3)))","v":1.2247448713915889},null,"RESULT"]
["Result Skewness",{"$f":"IF(ABS(B88/B89)>NORMSINV(1-0.05/2),\"non normal\",\"normal\")","v":"normal"},null,{"$f":"IF(AND(B87=\"normal\", B90=\"normal\"),\"normal\", \"non normal\")","v":"normal"}]
[]
[]
["ni = number test runs =",{"$f":"COUNT(B3:B37)","v":3},{"$f":"COUNT(C3:C37)","v":0},0,0,0,0,0,0,0,0]
[]
["Total Number of sources =",{"$f":"COUNTA(B2:L2)","v":1}]
[]
[]
["n =Total # test runs =",{"$f":"COUNT(B3:L37)","v":3}]
[]
[]
[]
[]
[null,{"$f":"B98-1","v":2}]
[]
[]
[]
[]
["This step is for QC only:"]
[]
["means",{"$f":"AVERAGE(B3:B37)","v":6.6942148606697486E-3},{"$f":"AVERAGE(C3:C37)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D3:D37)","v":{"$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":6.6942148606697486E-3}]
["Mean ="]
[]
[]
[]
["Pooled Variance = ",null,null,{"$f":"VAR(B3:L37)","v":6.6343211884356692E-6}]
[]
[]
[]
[]
[]
["m= number future runs =",1]
[]
[]
["Term1",{"$f":"1/B98+1/B128","v":1.3333333333333333}]
[]
[]
[]
["Term2",{"$f":"D122*B131","v":8.8457615845808923E-6}]
[]
[]
[]
[]
[]
["Squared root Term2",null,{"$f":"SQRT(B135)","v":2.9741825069388213E-3}]
[]
[]
["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,B103)","v":6.9645567342832733}]
[]
[]
["Adjustment for non-normality (skewness and kurtosis) for any sample size in particular for small samples "]
[]
["a) n = number of test-runs =",null,null,null,null,null,null,null,null,{"$f":"B98","v":3}]
[]
["b) Calculate u0",null,null,null,null,null,null,null,null,{"$f":"1/(1+$H$147^2/($J$152-1))","v":3.960000000000001E-2}]
[]
[]
[]
[]
[null,"Current Confidence Level is",null,null,0.9748613362060079]
["Conclusion","Confidence Level is not 99%, Go to Recalculate t-stat n<3 tab to fix the Confidence Level"]
[]
[]
[]
[null,"new t-statistic from tab Recalculate t-statistic"]
[]
[]
["Adjusted UPL for skewness and kurtosis for all sample size",null,null,null,{"$f":"B117+C141*E164","v":6.6942148606697486E-3}]

{"sheet":"ERT","index":9,"n_rows":20,"n_cols":49,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Key","RTI Calculated QA\nlb/MMBtu","Run Grade","Submitted Value","Submitted Value UOM","Use ?","Comment","facility_id","configuration_id","submittal_id","Compound","RunDate","Method","RunNumber","RunStartTime","RunEndTime","NetTravPts","Mass_TOOL","mass","units","Vmstd","Cd","Vwstd","PercH20","PercCO2","PercO2","Fd","19-1","19-5","Fc","19-6","19-9","Fw","FuelType","lb/mmBtuO2","CountOfComments","AvgOfStackTemp","AvgOfDryGasInlet","AvgOfDryGasOutlet","AvgOfOrificePresDesired","AvgOfOrificePresActual","AvgOfProbeTemp","AvgOfFilterTemp","AvgOfImpingTemp","CountOfNotes","M29 Isokinetic (+/- 10%)","OTM27 includes all fractions?","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,"DSCF","lb/dscf"]
["5_fPM_T1_R1",{"$f":"AB3","v":9.6299428557001295E-4},"A",{"$f":"AI3","v":9.6386048618314656E-4},{"$f":"$AI$1","v":"lb/mmBtuO2"},"Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-18","Method 29","1","08:30","12:46",48,5.55,5.55,"mg","159.765",{"$f":"S3/$H$9/$H$11/U3","v":7.6516568732352089E-8},"19.74","11.00",15.6,4.8,9695,{"$f":"V3*AA3*20.9/((20.9-Z3))","v":9.6299428557001295E-4},{"$f":"V3*AA3*20.9/((20.9-Z3)/(1-X3/100))","v":8.5706491415731153E-4},0,{"$f":"V3*AD3/Y3","v":0},{"$f":"V3*AD3*(1-X3/100)*100/Y3","v":0},0,"Override",9.6386048618314656E-4,49,197.72916666666666,94.729166666666671,94.729166666666671,1.4742647774056079,1.5209374999999996,254.54166666666666,252.5,52.9375,0,102.1]
["5_fPM_T1_R2",{"$f":"AB4","v":5.367876214866596E-4},"A",{"$f":"AI4","v":5.3727045484696268E-4},{"$f":"$AI$1","v":"lb/mmBtuO2"},"Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-18","Method 29","2","15:45","19:32",48,3.15,3.15,"mg","163.044",{"$f":"S4/$H$9/$H$11/U4","v":4.2554929903519457E-8},"19.85","10.85",15.2,4.8,9717,5.367876214866596E-4,{"$f":"V4*AA4*20.9/((20.9-Z4)/(1-X4/100))","v":4.7854616455535702E-4},0,{"$f":"V4*AD4/Y4","v":0},{"$f":"V4*AD4*(1-X4/100)*100/Y4","v":0},0,"Override",5.3727045484696268E-4,49,197.10416666666666,102.54166666666667,102.54166666666667,1.5941315176243114,1.6601250000000001,254.66666666666666,254.08333333333334,52.479166666666664,0,100.7]
["5_fPM_T1_R3",5.5555438902490635E-4,"A",5.5605410284420239E-4,"lb/mmBtuO2","Yes",null,667,"1A",1507,"Filterable Particulate","2010-05-19","Method 29","3","09:30","13:39",48,3.15,3.15,"mg","159.448",{"$f":"S5/$H$9/$H$11/U5","v":4.351466303239568E-8},"19.21","10.75",15.2,4.7,9896,5.5555438902490635E-4,4.9583229220472892E-4,0,0,0,0,"Override",5.5605410284420239E-4,49,198.8125,100.52083333333333,100.52083333333333,1.496576943409359,1.5532229166666662,254.20833333333334,254.89583333333334,54.354166666666664,0,101.6]
[]
[null,null,"Run 1",{"$f":"D3*B$20","v":8.5939044639039269E-3},"lb/MWh",">90",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Header tab comments",null,null,null,null,null,null,null,null,"Point tab notes"]
[null,null,"Run 2",{"$f":"D4*B$20","v":4.7903727006354995E-3},"lb/MWh",">90",null,"Conversions Used"]
[null,null,"Run 3",4.9578501298754045E-3,"lb/MWh",">90",null,1000,"mg=",1,"g"]
[null,null,"Average",{"$f":"AVERAGE(D7:D9)","v":6.1140424314716111E-3},"lb/MWh",null,null,1000000,"ug=",1,"g"]
[null,null,null,null,null,null,null,454,"g=",1,"lb"]
[]
[]
["Subcategory_ID","5-fPM"]
["Subcategory Desc.","Petcoke"]
["ORIS Code",667]
["Plant Name","Northside"]
["Configuration ID","1A"]
["Boiler ID",""]
["Heat Rate",8.9161290322580644]

{"sheet":"667_PartII","index":10,"n_rows":58,"n_cols":50,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Not a good F-factor estimation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO Fd",null,"No Fc"]
["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 conc lb/dscf","19-1\nlb/MMBtu","%diff\n19-1","19-6\nlb/MMBtu","%diff\n19-6","emission_factor","emission_factor_units","emission_factor_ND","emission_factor_MDL","run_pollutant_comment","Fuel1","Fuel1%Btu","Fuel2","Fuel2%Btu","QA Comment"]
["5_fPM_T2_R1","n/a","C",{"$f":"AO3","v":3.0000000000000001E-3},{"$f":"AP3","v":"pound per million British Thermal Unit (lb/MMBtu)"},"Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","1","2005-06-14T09:25:00","2005-06-14T11:35:00",297.32,192921,15017.1,9.06,3.6,15.02,222,"Method 17",2.8599999999999999E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.53,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf"]
["5_fPM_T2_R2","n/a","C",{"$f":"AO4","v":3.0000000000000001E-3},"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","2","2005-06-14T12:00:00","2005-06-14T14:05:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.33,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf"]
["5_fPM_T2_R3","n/a","C",3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2005_PM","1AStack",5,1,"PM (Filterable)","3","2005-06-14T14:20:00","2005-06-14T16:26:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,"pound per dry standard cubic foot (lb/dscf)",false,null,null,"",10.33,"pound per hour (lb/hr)",false,null,null,null,null,null,null,3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf"]
[null,null,null,{"$f":"D3*B$47","v":2.6748387096774195E-2},"lb/MWh",null,null,667,"1A","N1_2005_PM","1AStack",null,null,"PM (Filterable)","1","2005-06-14T09:25:00","2005-06-14T11:35:00",297.32,192921,15017.1,9.06,3.6,15.02,222,"Method 17",2.8599999999999999E-7,null,false,null,null,null,null,null,null,null,{"$f":"Z3","v":2.8599999999999999E-7},{"$f":"AJ6*$I$57*20.9/(20.9-V6)","v":3.4067724855491332E-3},{"$f":"($AO6-AK6)/$AO6","v":-0.13559082851637771},{"$f":"AJ6*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO6-AM6)/$AO6","v":{"$error":"#DIV/0!"}},3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf","petroleum coke",77.27,"coal - bituminous",22.73,"Run1 conc UOM should be lb/dscf"]
[null,null,null,{"$f":"D4*B$47","v":2.6748387096774195E-2},"lb/MWh",null,null,667,"1A","N1_2005_PM","1AStack",null,null,"PM (Filterable)","2","2005-06-14T12:00:00","2005-06-14T14:05:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,null,false,null,null,null,null,null,null,null,{"$f":"Z4","v":2.8200000000000001E-7},{"$f":"AJ7*$I$57*20.9/(20.9-V7)","v":3.3571847487001739E-3},{"$f":"($AO7-AK7)/$AO7","v":-0.11906158290005796},{"$f":"AJ7*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO7-AM7)/$AO7","v":{"$error":"#DIV/0!"}},3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf","petroleum coke",77.27,"coal - bituminous",22.73]
[null,null,null,2.6748387096774195E-2,"lb/MWh",null,null,667,"1A","N1_2005_PM","1AStack",null,null,"PM (Filterable)","3","2005-06-14T14:20:00","2005-06-14T16:26:00",297.32,192921,15017.7,9.56,3.59,14.99,226,"Method 17",2.8200000000000001E-7,null,false,null,null,null,null,null,null,null,{"$f":"Z5","v":2.8200000000000001E-7},{"$f":"AJ8*$I$57*20.9/(20.9-V8)","v":3.3571847487001739E-3},{"$f":"($AO8-AK8)/$AO8","v":-0.11906158290005796},{"$f":"AJ8*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO8-AM8)/$AO8","v":{"$error":"#DIV/0!"}},3.0000000000000001E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"lb/dscf","petroleum coke",77.27,"coal - bituminous",22.73]
[null,null,"Average",{"$f":"AVERAGE(D6:D8)","v":2.6748387096774195E-2},"lb/MWh"]
["5_fPM_T3_R1","n/a","C",{"$f":"AO10","v":1.2999999999999999E-3},{"$f":"AP10","v":"pound per million British Thermal Unit (lb/MMBtu)"},"Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","1","2006-02-23T08:26:00","2006-02-23T10:31:00",299.55,196803,15152.3,10.119999999999999,4.5999999999999996,15.2,233.3,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.99,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T3_R2","n/a","C",{"$f":"AO11","v":1.2999999999999999E-3},"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","2","2006-02-23T10:47:00","2006-02-23T12:53:00",299.55,196803,15152.3,9.58,4.2,15,245,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.89,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T3_R3","n/a","C",1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2006_PM","1AStack",5,1,"PM (Filterable)","3","2006-02-23T13:11:00","2006-02-23T15:15:00",299.55,196803,15152.3,9.39,4.2,15,248.8,"Method 17",8.0000000000000004E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.88,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
[null,null,null,{"$f":"D10*B$47","v":1.1590967741935482E-2},"lb/MWh",null,null,667,"1A","N1_2006_PM","1AStack",null,null,"PM (Filterable)","1","2006-02-23T08:26:00","2006-02-23T10:31:00",299.55,196803,15152.3,10.119999999999999,4.5999999999999996,15.2,233.3,"Method 17",6.9999999999999999E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z10/$H$47","v":9.9999999999999995E-8},{"$f":"AJ13*$I$57*20.9/(20.9-V13)","v":1.2642576687116565E-3},{"$f":"($AO13-AK13)/$AO13","v":2.7494100991033381E-2},{"$f":"AJ13*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO13-AM13)/$AO13","v":{"$error":"#DIV/0!"}},1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",81.78,"coal - bituminous",18.22]
[null,null,null,{"$f":"D11*B$47","v":1.1590967741935482E-2},"lb/MWh",null,null,667,"1A","N1_2006_PM","1AStack",null,null,"PM (Filterable)","2","2006-02-23T10:47:00","2006-02-23T12:53:00",299.55,196803,15152.3,9.58,4.2,15,245,"Method 17",6.9999999999999999E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z11/$H$47","v":9.9999999999999995E-8},{"$f":"AJ14*$I$57*20.9/(20.9-V14)","v":1.2339760479041916E-3},{"$f":"($AO14-AK14)/$AO14","v":5.0787655458314117E-2},{"$f":"AJ14*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO14-AM14)/$AO14","v":{"$error":"#DIV/0!"}},1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",81.78,"coal - bituminous",18.22]
[null,null,null,1.1590967741935482E-2,"lb/MWh",null,null,667,"1A","N1_2006_PM","1AStack",null,null,"PM (Filterable)","3","2006-02-23T13:11:00","2006-02-23T15:15:00",299.55,196803,15152.3,9.39,4.2,15,248.8,"Method 17",8.0000000000000004E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z12/$H$47","v":1.1428571428571429E-7},{"$f":"AJ15*$I$57*20.9/(20.9-V15)","v":1.4102583404619333E-3},{"$f":"($AO15-AK15)/$AO15","v":-8.4814108047641085E-2},{"$f":"AJ15*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO15-AM15)/$AO15","v":{"$error":"#DIV/0!"}},1.2999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",81.78,"coal - bituminous",18.22]
[null,null,"Average",{"$f":"AVERAGE(D13:D15)","v":1.1590967741935484E-2},"lb/MWh"]
["5_fPM_T4_R1","n/a","C",{"$f":"AO17","v":5.9999999999999995E-4},{"$f":"AP17","v":"pound per million British Thermal Unit (lb/MMBtu)"},"Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","1","2007-02-28T08:48:00","2007-02-28T10:54:00",313.07,204537,14831,9.07,4.5,14.9,230.5,"Method 17",4.0000000000000002E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.92,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T4_R2","n/a","C",{"$f":"AO18","v":5.0000000000000001E-4},"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","2","2007-02-28T11:07:00","2007-02-28T13:12:00",313.07,204537,14831,9.3699999999999992,4.5999999999999996,15,230.8,"Method 17",2.9999999999999997E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.52,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.0000000000000001E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T4_R3","n/a","C",5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2007_PM","1AStack",5,1,"PM (Filterable)","3","2007-02-28T13:23:00","2007-02-28T15:36:00",313.07,204537,14831,9.07,4.5999999999999996,15,224.9,"Method 17",2.9999999999999997E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",1.64,"pound per hour (lb/hr)",false,null,null,null,null,null,null,5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
[null,null,null,{"$f":"D17*B$47","v":5.3496774193548379E-3},"lb/MWh",null,null,667,"1A","N1_2007_PM","1AStack",null,null,"PM (Filterable)","1","2007-02-28T08:48:00","2007-02-28T10:54:00",313.07,204537,14831,9.07,4.5,14.9,230.5,"Method 17",4.0000000000000002E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z17/$H$47","v":5.7142857142857144E-8},{"$f":"AJ20*$I$57*20.9/(20.9-V20)","v":7.1802787456446001E-4},{"$f":"($AO20-AK20)/$AO20","v":-0.19671312427410012},{"$f":"AJ20*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO20-AM20)/$AO20","v":{"$error":"#DIV/0!"}},5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",83.42,"coal - bituminous",16.579999999999998]
[null,null,null,{"$f":"D18*B$47","v":4.4580645161290322E-3},"lb/MWh",null,null,667,"1A","N1_2007_PM","1AStack",null,null,"PM (Filterable)","2","2007-02-28T11:07:00","2007-02-28T13:12:00",313.07,204537,14831,9.3699999999999992,4.5999999999999996,15,230.8,"Method 17",2.9999999999999997E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z18/$H$47","v":4.2857142857142851E-8},{"$f":"AJ21*$I$57*20.9/(20.9-V21)","v":5.4182471516213849E-4},{"$f":"($AO21-AK21)/$AO21","v":-8.3649430324276949E-2},{"$f":"AJ21*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO21-AM21)/$AO21","v":{"$error":"#DIV/0!"}},5.0000000000000001E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",83.42,"coal - bituminous",16.579999999999998]
[null,null,null,5.3496774193548379E-3,"lb/MWh",null,null,667,"1A","N1_2007_PM","1AStack",null,null,"PM (Filterable)","3","2007-02-28T13:23:00","2007-02-28T15:36:00",313.07,204537,14831,9.07,4.5999999999999996,15,224.9,"Method 17",2.9999999999999997E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z19/$H$47","v":4.2857142857142851E-8},{"$f":"AJ22*$I$57*20.9/(20.9-V22)","v":5.4182471516213849E-4},{"$f":"($AO22-AK22)/$AO22","v":9.6958808063102433E-2},{"$f":"AJ22*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO22-AM22)/$AO22","v":{"$error":"#DIV/0!"}},5.9999999999999995E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",83.42,"coal - bituminous",16.579999999999998]
[null,null,"Average",{"$f":"AVERAGE(D20:D22)","v":5.0524731182795693E-3},"lb/MWh"]
["5_fPM_T5_R1","n/a","C",{"$f":"AO24","v":1E-3},{"$f":"AP24","v":"pound per million British Thermal Unit (lb/MMBtu)"},"Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","1","2008-06-10T17:06:00","2008-06-10T19:20:00",299.51,201926,14618,10.06,4.53,14.86,197.7,"Method 17",5.0000000000000001E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.08,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T5_R2","n/a","C",{"$f":"AO25","v":1E-3},"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","2","2008-06-11T13:53:00","2008-06-11T16:02:00",299.89,198462,15111.9,10.37,4.53,14.47,203.7,"Method 17",5.0000000000000001E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",2.8519999999999999,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
["5_fPM_T5_R3","n/a","C",1.1999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2008_PM","1AStack",5,1,"PM (Filterable)","3","2008-06-11T17:14:00","2008-06-11T19:18:00",299.89,198462,15111.9,11.2,4.53,14.26,202.8,"Method 17",6.9999999999999999E-4,"grains per dry standard cubic foot (gr/dscf)",false,null,null,"",3.6360000000000001,"pound per hour (lb/hr)",false,null,null,null,null,null,null,1.1999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf"]
[null,null,null,{"$f":"D24*B$47","v":8.9161290322580643E-3},"lb/MWh",">90",null,667,"1A","N1_2008_PM","1AStack",null,null,"PM (Filterable)","1","2008-06-10T17:06:00","2008-06-10T19:20:00",299.51,201926,14618,10.06,4.53,14.86,197.7,"Method 17",5.0000000000000001E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z24/$H$47","v":7.1428571428571423E-8},{"$f":"AJ27*$I$57*20.9/(20.9-V27)","v":8.991796840911075E-4},{"$f":"($AO27-AK27)/$AO27","v":0.10082031590889252},{"$f":"AJ27*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO27-AM27)/$AO27","v":{"$error":"#DIV/0!"}},1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",92.74,"coal - bituminous",7.26]
[null,null,null,{"$f":"D25*B$47","v":8.9161290322580643E-3},"lb/MWh",">90",null,667,"1A","N1_2008_PM","1AStack",null,null,"PM (Filterable)","2","2008-06-11T13:53:00","2008-06-11T16:02:00",299.89,198462,15111.9,10.37,4.53,14.47,203.7,"Method 17",5.0000000000000001E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z25/$H$47","v":7.1428571428571423E-8},{"$f":"AJ28*$I$57*20.9/(20.9-V28)","v":8.991796840911075E-4},{"$f":"($AO28-AK28)/$AO28","v":0.10082031590889252},{"$f":"AJ28*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO28-AM28)/$AO28","v":{"$error":"#DIV/0!"}},1E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",92.06,"coal - bituminous",7.94]
[null,null,null,1.0699354838709676E-2,"lb/MWh",">90",null,667,"1A","N1_2008_PM","1AStack",null,null,"PM (Filterable)","3","2008-06-11T17:14:00","2008-06-11T19:18:00",299.89,198462,15111.9,11.2,4.53,14.26,202.8,"Method 17",6.9999999999999999E-4,null,false,null,null,null,null,null,null,null,{"$f":"Z26/$H$47","v":9.9999999999999995E-8},{"$f":"AJ29*$I$57*20.9/(20.9-V29)","v":1.2588515577275504E-3},{"$f":"($AO29-AK29)/$AO29","v":-4.9042964772958768E-2},{"$f":"AJ29*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO29-AM29)/$AO29","v":{"$error":"#DIV/0!"}},1.1999999999999999E-3,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/scf","petroleum coke",92.06,"coal - bituminous",7.94]
[null,null,"Average",{"$f":"AVERAGE(D27:D29)","v":9.5105376344086015E-3},"lb/MWh"]
["5_fPM_T6_R1","n/a","C",{"$f":"AO31","v":8.0000000000000004E-4},{"$f":"AP31","v":"pound per million British Thermal Unit (lb/MMBtu)"},"Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","3","2009-05-05T15:49:00","2009-05-05T17:56:00",299.95999999999998,202348,15031.1,11,4.7,15,197.4,"Method 17",null,"",false,null,null,"",2.5,"pound per hour (lb/hr)",false,null,null,null,null,null,null,8.0000000000000004E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf"]
["5_fPM_T6_R2","n/a","C",{"$f":"AO32","v":2.9999999999999997E-4},"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","4","2009-05-07T08:20:00","2009-05-07T10:55:00",299.93,204059,14813,11.5,5.2,14.3,198.3,"Method 17",null,"",false,null,null,"",1,"pound per hour (lb/hr)",false,null,null,null,null,null,null,2.9999999999999997E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,""]
["5_fPM_T6_R3","n/a","C",4.0000000000000002E-4,"pound per million British Thermal Unit (lb/MMBtu)","Yes","Method 19 doesn't provide an F factor for petcoke; RTI was unable to determine a good F factor to calculate lb/MMBtu from conc",667,"1A","N1_2009_PM","1AStack",5,1,"PM (Filterable)","5","2009-05-07T11:32:00","2009-05-07T14:05:00",299.93,204059,14813,11.3,5,14.6,198.3,"Method 17",null,"",false,null,null,"",1.2,"pound per hour (lb/hr)",false,null,null,null,null,null,null,4.0000000000000002E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,""]
[null,null,null,{"$f":"D31*B$47","v":7.132903225806452E-3},"lb/MWh",">90",null,667,"1A","N1_2009_PM","1AStack",null,null,"PM (Filterable)","3","2009-05-05T15:49:00","2009-05-05T17:56:00",299.95999999999998,202348,15031.1,11,4.7,15,197.4,"Method 17",0,null,false,null,null,null,null,null,null,null,null,{"$f":"AJ34*$I$57*20.9/(20.9-V34)","v":0},{"$f":"($AO34-AK34)/$AO34","v":1},{"$f":"AJ34*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO34-AM34)/$AO34","v":{"$error":"#DIV/0!"}},8.0000000000000004E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,"gr/dscf","petroleum coke",90,"coal - bituminous",10]
[null,null,null,{"$f":"D32*B$47","v":2.674838709677419E-3},"lb/MWh",">90",null,667,"1A","N1_2009_PM","1AStack",null,null,"PM (Filterable)","4","2009-05-07T08:20:00","2009-05-07T10:55:00",299.93,204059,14813,11.5,5.2,14.3,198.3,"Method 17",0,null,false,null,null,null,null,null,null,null,null,{"$f":"AJ35*$I$57*20.9/(20.9-V35)","v":0},{"$f":"($AO35-AK35)/$AO35","v":1},{"$f":"AJ35*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO35-AM35)/$AO35","v":{"$error":"#DIV/0!"}},2.9999999999999997E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,null,"petroleum coke",90,"coal - bituminous",10]
[null,null,null,3.566451612903226E-3,"lb/MWh",">90",null,667,"1A","N1_2009_PM","1AStack",null,null,"PM (Filterable)","5","2009-05-07T11:32:00","2009-05-07T14:05:00",299.93,204059,14813,11.3,5,14.6,198.3,"Method 17",0,null,false,null,null,null,null,null,null,null,null,{"$f":"AJ36*$I$57*20.9/(20.9-V36)","v":0},{"$f":"($AO36-AK36)/$AO36","v":1},{"$f":"AJ36*$K$54*100/$I$60","v":{"$error":"#DIV/0!"}},{"$f":"($AO36-AM36)/$AO36","v":{"$error":"#DIV/0!"}},4.0000000000000002E-4,"pound per million British Thermal Unit (lb/MMBtu)",false,null,null,"petroleum coke",90,"coal - bituminous",10]
[null,null,"Average",{"$f":"AVERAGE(D34:D36)","v":4.4580645161290322E-3},"lb/MWh"]
[]
[null,null,null,null,null,null,null,"Data from eICR.  No test report provided."]
[]
["Subcategory_ID","5-fPM",null,null,null,null,null,"Conversions"]
["Subcategory Desc.","Petcoke",null,null,null,null,null,1,"ppm SO2=",1.66E-7,"lb/scf"]
["ORIS Code",667,null,null,null,null,null,1,"ppm Hg=",{"$f":"J42*H49/H50","v":5.1979300655635339E-7},"lb/scf"]
["Plant Name","Northside",null,null,null,null,null,1000,"mg=",1,"g"]
["Configuration ID","1A",null,null,null,null,null,1000000,"ug=",1,"g"]
["Boiler ID","",null,null,null,null,null,454,"g=",1,"lb"]
["Heat Rate",8.9161290322580644,null,null,null,null,null,7000,"gr=",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]