Record Viewer

ATI Specialty Alloys & Components, LLC CAO AQ520 Supporting Considerations- Tank Files 7.9.2026.XLSX

TankESP+ Annual

HCl Storage Tank 1

Calculation Details HCL T1

TempCal HCL T1

SampleCalculation HCL T1

HCl Storage Tank 2

Calculation Details HCL T2

TempCal HCL T2

SampleCalculation HCL T2

Ammonia Recovery HCl

Calculation Details AR HCl

TempCal AR HCl

SampleCalculation AR HCl

Dilute H2SO4

Calculation Details D H2SO4

TempCal D H2SO4

SampleCalculation D-H2SO4

Ammonia Recovery Feed Mix

Calculation Details AR_feed_mix

TempCal AR_feed_mix

SampleCalculation AR_feed_mix

Ammonia recovery feed storage

Calculation Details AR_storage

TempCal AR_storage

SampleCalculation AR_storage

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1		TankSummaries_ATI-Mill for 2026 Annual
2		Site: ATI Millersburg
3		Equations for this site: After 2020 AP-42 revisions H/D ratio: calculated (for Tanks Module)
4																							Speciated Total Emissions components in the "ATI-Mill" set (lbs)
5	Tank TESU	Tank ID	Tank Diameter (ft)	Tank Type	Product	RVP	Throughput in gal.	Bulk Liquid Temperature (degF)	Liquid Surface Temperature (degF)	Avg. TVP (psia)	Includes a landing loss?	Initial fill?	Includes a tank cleaning?	Number of Days	Estimated standing losses (lbs)	Estimated working losses (lbs)	Routine Emissions (lbs)	Non Routine Emissions (lbs)	Total estimated emissions (lbs)	Ammonia in 28.0% wt% Aq Solution	Ammonia in 4.0% wt% Aq Solution	HCl 36.0% wt% in Aq Solution	Sulfuric Acid Mist above 20.0% wt% Aq H2SO4	Sulfuric Acid Mist above 93.0% wt% Aq H2SO4	Sulfur Trioxide above 20.0% wt% Aq H2SO4	Sulfur Trioxide above 93.0% wt% Aq H2SO4
6	S31_T1	AR Feed Mix_T1	7	FRT (no floating roof)	Ammonia_4		0	54.3120613219178	55.1254152796804	0.524535770932851	N	N	N	365	4.75198592124757	0	4.75198592124757	0	2.81038725706847	0	2.81038725706847	0	0	0	0	0
7	S36_T1	AR Feed Storage_T1	12	FRT (no floating roof)	Ammonia_4		0	54.3120613219178	55.0434782483595	0.523201749804905	N	N	N	365	29.7567845840158	0	29.7567845840158	0	17.6026243401031	0	17.6026243401031	0	0	0	0	0
8	S33_T1	AR HCl Storage_T1	12	FRT (no floating roof)	Hydrochloric_36		0	54.3120613219178	55.1557555994821	1.36664692775805	N	N	N	365	126.676850874298	0	126.676850874298	0	124.50586156619	0	0	124.50586156619	0	0	0	0
9	S21_D	H2SO4_T1	8	FRT (no floating roof)	Sulfuric_20		5196000	54.3120613219178	55.1053515198115	0.22632784940763	N	N	N	365	3.17148726015437	94.1994546120775	97.3709418722319	0	0	0	0	0	6.00976851795893E-15	0	1.25953453693683E-22	0
10	S23_T1	HCl_T1	14	FRT (no floating roof)	Hydrochloric_36		0	54.3120613219178	54.9937658142771	1.35891489450786	N	N	N	365	290.72995208585	0	290.72995208585	0	285.751102983548	0	0	285.751102983548	0	0	0	0
11	S23_T2	HCl_T2	14	FRT (no floating roof)	Hydrochloric_36		0	54.3120613219178	54.9937658142771	1.35891489450786	N	N	N	365	290.72995208585	0	290.72995208585	0	285.751102983548	0	0	285.751102983548	0	0	0	0

	A
1

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	0
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	HCl_T1	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Hydrochloric_36	Sa	0
6	Floating roof type	E	Liquid density (Wl)	9.46066656932175	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	35.8320614986394	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	HCl_36
11	Eff Diameter	14	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	30	Effective Antoines B for liquid		Product	Hydrochloric_36
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	0
15	Height of cone down bottom	0	Antoines C		Average TVP	1.35891489450786
16	Height of roof	1.87564434701786	True vapor pressure (TVP)	1.35891489450786	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.00880491961947303	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	290.72995208585
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	0
21	Max liquid level	29	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	28	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	15.9602663743869	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	290.72995208585
25	Shell Condition	Av	Is initial fill	False	Summary total losses	285.751102983548
26	Roof Finish (color)	K	Stock ID	Hydrochloric_36	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	54.9937658142771	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	21.1100942755703	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	1.127357474343
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	1.63186559481729
34	Tank build date		Throughput	0	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	0	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	0	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	1	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	15.9602663743869	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	2.14285714285714
43	Slotted pole EF		Volume of vapor space	2456.8921239644	Vapor Space Temperature	55.6754703066363
44	Unslotted pole EF		Ke	0.0791448202914375	Vapor Space Temperature Range	21.1100942755703
45	Deck fitting EF		Ks	0.465224878587696	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	290.72995208585

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details HCL T1'!B9="N",IF('Calculation Details HCL T1'!H41=TRUE,'Calculation Details HCL T1'!E27,D10),IF('Calculation Details HCL T1'!H41=TRUE,'Calculation Details HCL T1'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details HCL T1'!B9="F",B2,IF('Calculation Details HCL T1'!B9="P",D13,IF('Calculation Details HCL T1'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details HCL T1'!B9="F",B2,IF('Calculation Details HCL T1'!B9="P",D16,IF('Calculation Details HCL T1'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details HCL T1'!B9="F",0,IF('Calculation Details HCL T1'!B9="P",D19,IF('Calculation Details HCL T1'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details HCL T1'!B12/'Calculation Details HCL T1'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation HCL T1'!F11+0.003'SampleCalculation HCL T1'!J17'SampleCalculation HCL T1'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation HCL T1'!F11+0.6B2+0.005'SampleCalculation HCL T1'!E16'SampleCalculation HCL T1'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation HCL T1'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation HCL T1'!J20'SampleCalculation HCL T1'!F13 + 0.013B7'SampleCalculation HCL T1'!J17'SampleCalculation HCL T1'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation HCL T1'!F11+0.7B2+0.005'SampleCalculation HCL T1'!J20'SampleCalculation HCL T1'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation HCL T1'!F11+0.3B2+0.009'SampleCalculation HCL T1'!E16'SampleCalculation HCL T1'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation HCL T1'!F11 + 0.8B2 + 0.021'SampleCalculation HCL T1'!J20'SampleCalculation HCL T1'!F13 + 0.013B7'SampleCalculation HCL T1'!J17'SampleCalculation HCL T1'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation HCL T1'!F11+0.4B2+0.01'SampleCalculation HCL T1'!J20'SampleCalculation HCL T1'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation HCL T1'!F12+0.02'SampleCalculation HCL T1'!E16*'SampleCalculation HCL T1'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation HCL T1'!F12+(0.042'SampleCalculation HCL T1'!J20'SampleCalculation HCL T1'!F13+0.026B7'SampleCalculation HCL T1'!J17'SampleCalculation HCL T1'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation HCL T1'!F12+0.02'SampleCalculation HCL T1'!J20*'SampleCalculation HCL T1'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation HCL T1'!F31'SampleCalculation HCL T1'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details HCL T1'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details HCL T1'!B2)	='Calculation Details HCL T1'!B3-'Calculation Details HCL T1'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details HCL T1'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details HCL T1'!B4		=IF('Calculation Details HCL T1'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details HCL T1'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details HCL T1'!E18+'Calculation Details HCL T1'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details HCL T1'!E19-'Calculation Details HCL T1'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details HCL T1'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details HCL T1'!B7				shell color:	=VLOOKUP('Calculation Details HCL T1'!B24,'SampleCalculation HCL T1'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details HCL T1'!B25="N","New",IF('Calculation Details HCL T1'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details HCL T1'!B11	ft			shell alpha:	=IF('Calculation Details HCL T1'!B25="N",VLOOKUP('Calculation Details HCL T1'!B24,'SampleCalculation HCL T1'!$O$5:$T$16,4,FALSE),IF('Calculation Details HCL T1'!B25="Ag",VLOOKUP('Calculation Details HCL T1'!B24,'SampleCalculation HCL T1'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details HCL T1'!B24,'SampleCalculation HCL T1'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details HCL T1'!B12	ft			roof color:	=VLOOKUP('Calculation Details HCL T1'!B26,'SampleCalculation HCL T1'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details HCL T1'!B21	ft		roof condition:	=IF('Calculation Details HCL T1'!B27="N","New",IF('Calculation Details HCL T1'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details HCL T1'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details HCL T1'!B20	ft		roof alpha:	=IF('Calculation Details HCL T1'!B27="N",VLOOKUP('Calculation Details HCL T1'!B26,'SampleCalculation HCL T1'!$O$5:$T$16,4,FALSE),IF('Calculation Details HCL T1'!B27="Ag",VLOOKUP('Calculation Details HCL T1'!B26,'SampleCalculation HCL T1'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details HCL T1'!B26,'SampleCalculation HCL T1'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details HCL T1'!B5,'SampleCalculation HCL T1'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details HCL T1'!B5="A",('Calculation Details HCL T1'!B13('Calculation Details HCL T1'!B11/2)/12)/3,IF('Calculation Details HCL T1'!B5="B",'Calculation Details HCL T1'!B16/2+(2'Calculation Details HCL T1'!B16^3)/(3*'SampleCalculation HCL T1'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details HCL T1'!E33="",F23,E18+J22+'Calculation Details HCL T1'!B15/3+'Calculation Details HCL T1'!B19-'Calculation Details HCL T1'!E33)	ft			Average Hvo	='Calculation Details HCL T1'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details HCL T1'!B30	psig							Hvo	='Calculation Details HCL T1'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details HCL T1'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details HCL T1'!E5								Tb	='Calculation Details HCL T1'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details HCL T1'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details HCL T1'!E8=0,"",'Calculation Details HCL T1'!E8)	psi	(if specified)			A:	=IF('Calculation Details HCL T1'!E13=0,"",'Calculation Details HCL T1'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details HCL T1'!H29=0,"",'Calculation Details HCL T1'!H29)		(if specified)			B:	=IF('Calculation Details HCL T1'!E14=0,"",'Calculation Details HCL T1'!E14)
31			Molecular Weight, MV:			='Calculation Details HCL T1'!E7	lb/lb-mol				C:	=IF('Calculation Details HCL T1'!E15=0,"",'Calculation Details HCL T1'!E15)		Tla	='Calculation Details HCL T1'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal HCL T1'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details HCL T1'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details HCL T1'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details HCL T1'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal HCL T1'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T1'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T1'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details HCL T1'!E15)=FALSE,(10^('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/((F35-32)*(5/9)+'Calculation Details HCL T1'!E15))))/51.7144,EXP('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal HCL T1'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details HCL T1'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal HCL T1'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details HCL T1'!H35=-1,"",'Calculation Details HCL T1'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details HCL T1'!H34=-1,"",'Calculation Details HCL T1'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details HCL T1'!H36=-1,"",'Calculation Details HCL T1'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details HCL T1'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details HCL T1'!B2)=1,DAY('Calculation Details HCL T1'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details HCL T1'!B3-'Calculation Details HCL T1'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal HCL T1'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details HCL T1'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T1'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T1'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details HCL T1'!E15)=FALSE,(10^('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/((E51-32)*(5/9)+'Calculation Details HCL T1'!E15))))/51.7144,EXP('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T1'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T1'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details HCL T1'!E15)=FALSE,(10^('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/((E52-32)*(5/9)+'Calculation Details HCL T1'!E15))))/51.7144,EXP('Calculation Details HCL T1'!E13-('Calculation Details HCL T1'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details HCL T1'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details HCL T1'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details HCL T1'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details HCL T1'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details HCL T1'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details HCL T1'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details HCL T1'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation HCL T1'!P69+'SampleCalculation HCL T1'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details HCL T1'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details HCL T1'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details HCL T1'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details HCL T1'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details HCL T1'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details HCL T1'!H25	=IF(F75<>0,IF(ABS(P75-F75)/ABS(F75)>$S$18,"ERROR","OKAY"),IF(P75<>F75,"ERROR","OKAY"))
76						=F72(1-D66'Calculation Details HCL T1'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A
1

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	0
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	HCl_T2	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Hydrochloric_36	Sa	0
6	Floating roof type	E	Liquid density (Wl)	9.46066656932175	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	35.8320614986394	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	HCl_36
11	Eff Diameter	14	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	30	Effective Antoines B for liquid		Product	Hydrochloric_36
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	0
15	Height of cone down bottom	0	Antoines C		Average TVP	1.35891489450786
16	Height of roof	1.87564434701786	True vapor pressure (TVP)	1.35891489450786	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.00880491961947303	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	290.72995208585
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	0
21	Max liquid level	29	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	28	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	15.9602663743869	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	290.72995208585
25	Shell Condition	Av	Is initial fill	False	Summary total losses	285.751102983548
26	Roof Finish (color)	K	Stock ID	Hydrochloric_36	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	54.9937658142771	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	21.1100942755703	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	1.127357474343
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	1.63186559481729
34	Tank build date		Throughput	0	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	0	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	0	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	1	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	15.9602663743869	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	2.14285714285714
43	Slotted pole EF		Volume of vapor space	2456.8921239644	Vapor Space Temperature	55.6754703066363
44	Unslotted pole EF		Ke	0.0791448202914375	Vapor Space Temperature Range	21.1100942755703
45	Deck fitting EF		Ks	0.465224878587696	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	290.72995208585

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details HCL T2'!B9="N",IF('Calculation Details HCL T2'!H41=TRUE,'Calculation Details HCL T2'!E27,D10),IF('Calculation Details HCL T2'!H41=TRUE,'Calculation Details HCL T2'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details HCL T2'!B9="F",B2,IF('Calculation Details HCL T2'!B9="P",D13,IF('Calculation Details HCL T2'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details HCL T2'!B9="F",B2,IF('Calculation Details HCL T2'!B9="P",D16,IF('Calculation Details HCL T2'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details HCL T2'!B9="F",0,IF('Calculation Details HCL T2'!B9="P",D19,IF('Calculation Details HCL T2'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details HCL T2'!B12/'Calculation Details HCL T2'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation HCL T2'!F11+0.003'SampleCalculation HCL T2'!J17'SampleCalculation HCL T2'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation HCL T2'!F11+0.6B2+0.005'SampleCalculation HCL T2'!E16'SampleCalculation HCL T2'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation HCL T2'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation HCL T2'!J20'SampleCalculation HCL T2'!F13 + 0.013B7'SampleCalculation HCL T2'!J17'SampleCalculation HCL T2'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation HCL T2'!F11+0.7B2+0.005'SampleCalculation HCL T2'!J20'SampleCalculation HCL T2'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation HCL T2'!F11+0.3B2+0.009'SampleCalculation HCL T2'!E16'SampleCalculation HCL T2'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation HCL T2'!F11 + 0.8B2 + 0.021'SampleCalculation HCL T2'!J20'SampleCalculation HCL T2'!F13 + 0.013B7'SampleCalculation HCL T2'!J17'SampleCalculation HCL T2'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation HCL T2'!F11+0.4B2+0.01'SampleCalculation HCL T2'!J20'SampleCalculation HCL T2'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation HCL T2'!F12+0.02'SampleCalculation HCL T2'!E16*'SampleCalculation HCL T2'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation HCL T2'!F12+(0.042'SampleCalculation HCL T2'!J20'SampleCalculation HCL T2'!F13+0.026B7'SampleCalculation HCL T2'!J17'SampleCalculation HCL T2'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation HCL T2'!F12+0.02'SampleCalculation HCL T2'!J20*'SampleCalculation HCL T2'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation HCL T2'!F31'SampleCalculation HCL T2'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details HCL T2'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details HCL T2'!B2)	='Calculation Details HCL T2'!B3-'Calculation Details HCL T2'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details HCL T2'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details HCL T2'!B4		=IF('Calculation Details HCL T2'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details HCL T2'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details HCL T2'!E18+'Calculation Details HCL T2'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details HCL T2'!E19-'Calculation Details HCL T2'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details HCL T2'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details HCL T2'!B7				shell color:	=VLOOKUP('Calculation Details HCL T2'!B24,'SampleCalculation HCL T2'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details HCL T2'!B25="N","New",IF('Calculation Details HCL T2'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details HCL T2'!B11	ft			shell alpha:	=IF('Calculation Details HCL T2'!B25="N",VLOOKUP('Calculation Details HCL T2'!B24,'SampleCalculation HCL T2'!$O$5:$T$16,4,FALSE),IF('Calculation Details HCL T2'!B25="Ag",VLOOKUP('Calculation Details HCL T2'!B24,'SampleCalculation HCL T2'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details HCL T2'!B24,'SampleCalculation HCL T2'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details HCL T2'!B12	ft			roof color:	=VLOOKUP('Calculation Details HCL T2'!B26,'SampleCalculation HCL T2'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details HCL T2'!B21	ft		roof condition:	=IF('Calculation Details HCL T2'!B27="N","New",IF('Calculation Details HCL T2'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details HCL T2'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details HCL T2'!B20	ft		roof alpha:	=IF('Calculation Details HCL T2'!B27="N",VLOOKUP('Calculation Details HCL T2'!B26,'SampleCalculation HCL T2'!$O$5:$T$16,4,FALSE),IF('Calculation Details HCL T2'!B27="Ag",VLOOKUP('Calculation Details HCL T2'!B26,'SampleCalculation HCL T2'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details HCL T2'!B26,'SampleCalculation HCL T2'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details HCL T2'!B5,'SampleCalculation HCL T2'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details HCL T2'!B5="A",('Calculation Details HCL T2'!B13('Calculation Details HCL T2'!B11/2)/12)/3,IF('Calculation Details HCL T2'!B5="B",'Calculation Details HCL T2'!B16/2+(2'Calculation Details HCL T2'!B16^3)/(3*'SampleCalculation HCL T2'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details HCL T2'!E33="",F23,E18+J22+'Calculation Details HCL T2'!B15/3+'Calculation Details HCL T2'!B19-'Calculation Details HCL T2'!E33)	ft			Average Hvo	='Calculation Details HCL T2'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details HCL T2'!B30	psig							Hvo	='Calculation Details HCL T2'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details HCL T2'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details HCL T2'!E5								Tb	='Calculation Details HCL T2'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details HCL T2'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details HCL T2'!E8=0,"",'Calculation Details HCL T2'!E8)	psi	(if specified)			A:	=IF('Calculation Details HCL T2'!E13=0,"",'Calculation Details HCL T2'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details HCL T2'!H29=0,"",'Calculation Details HCL T2'!H29)		(if specified)			B:	=IF('Calculation Details HCL T2'!E14=0,"",'Calculation Details HCL T2'!E14)
31			Molecular Weight, MV:			='Calculation Details HCL T2'!E7	lb/lb-mol				C:	=IF('Calculation Details HCL T2'!E15=0,"",'Calculation Details HCL T2'!E15)		Tla	='Calculation Details HCL T2'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal HCL T2'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details HCL T2'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details HCL T2'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details HCL T2'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal HCL T2'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T2'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T2'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details HCL T2'!E15)=FALSE,(10^('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/((F35-32)*(5/9)+'Calculation Details HCL T2'!E15))))/51.7144,EXP('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal HCL T2'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details HCL T2'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal HCL T2'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details HCL T2'!H35=-1,"",'Calculation Details HCL T2'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details HCL T2'!H34=-1,"",'Calculation Details HCL T2'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details HCL T2'!H36=-1,"",'Calculation Details HCL T2'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details HCL T2'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details HCL T2'!B2)=1,DAY('Calculation Details HCL T2'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details HCL T2'!B3-'Calculation Details HCL T2'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal HCL T2'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details HCL T2'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T2'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T2'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details HCL T2'!E15)=FALSE,(10^('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/((E51-32)*(5/9)+'Calculation Details HCL T2'!E15))))/51.7144,EXP('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details HCL T2'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details HCL T2'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details HCL T2'!E15)=FALSE,(10^('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/((E52-32)*(5/9)+'Calculation Details HCL T2'!E15))))/51.7144,EXP('Calculation Details HCL T2'!E13-('Calculation Details HCL T2'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details HCL T2'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details HCL T2'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details HCL T2'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details HCL T2'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details HCL T2'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details HCL T2'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details HCL T2'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation HCL T2'!P69+'SampleCalculation HCL T2'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details HCL T2'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details HCL T2'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details HCL T2'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details HCL T2'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details HCL T2'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details HCL T2'!H25	=IF(F75<>0,IF(ABS(P75-F75)/ABS(F75)>$S$18,"ERROR","OKAY"),IF(P75<>F75,"ERROR","OKAY"))
76						=F72(1-D66'Calculation Details HCL T2'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A
1

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	0
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	AR HCl Storage_T1	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Hydrochloric_36	Sa	0
6	Floating roof type	E	Liquid density (Wl)	9.46066656932175	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	35.8316048616476	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	HCl_36
11	Eff Diameter	12	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	12	Effective Antoines B for liquid		Product	Hydrochloric_36
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	0
15	Height of cone down bottom	0	Antoines C		Average TVP	1.36664692775805
16	Height of roof	1.60769515458674	True vapor pressure (TVP)	1.36664692775805	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.00884934224795296	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	126.676850874298
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	0
21	Max liquid level	11	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	10	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	6.82308546376021	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	126.676850874298
25	Shell Condition	Av	Is initial fill	False	Summary total losses	124.50586156619
26	Roof Finish (color)	K	Stock ID	Hydrochloric_36	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	55.1557555994821	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	20.2069266087538	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	1.14308847168932
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	1.62829451773905
34	Tank build date		Throughput	0	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	0	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	0	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	1	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	6.82308546376021	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	1
43	Slotted pole EF		Volume of vapor space	771.672786039518	Vapor Space Temperature	55.9994498770465
44	Unslotted pole EF		Ke	0.0759403066000291	Vapor Space Temperature Range	20.2069266087538
45	Deck fitting EF		Ks	0.6692492165382	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	126.676850874298

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details AR HCl'!B9="N",IF('Calculation Details AR HCl'!H41=TRUE,'Calculation Details AR HCl'!E27,D10),IF('Calculation Details AR HCl'!H41=TRUE,'Calculation Details AR HCl'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details AR HCl'!B9="F",B2,IF('Calculation Details AR HCl'!B9="P",D13,IF('Calculation Details AR HCl'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details AR HCl'!B9="F",B2,IF('Calculation Details AR HCl'!B9="P",D16,IF('Calculation Details AR HCl'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details AR HCl'!B9="F",0,IF('Calculation Details AR HCl'!B9="P",D19,IF('Calculation Details AR HCl'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details AR HCl'!B12/'Calculation Details AR HCl'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation AR HCl'!F11+0.003'SampleCalculation AR HCl'!J17'SampleCalculation AR HCl'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation AR HCl'!F11+0.6B2+0.005'SampleCalculation AR HCl'!E16'SampleCalculation AR HCl'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation AR HCl'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation AR HCl'!J20'SampleCalculation AR HCl'!F13 + 0.013B7'SampleCalculation AR HCl'!J17'SampleCalculation AR HCl'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation AR HCl'!F11+0.7B2+0.005'SampleCalculation AR HCl'!J20'SampleCalculation AR HCl'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation AR HCl'!F11+0.3B2+0.009'SampleCalculation AR HCl'!E16'SampleCalculation AR HCl'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation AR HCl'!F11 + 0.8B2 + 0.021'SampleCalculation AR HCl'!J20'SampleCalculation AR HCl'!F13 + 0.013B7'SampleCalculation AR HCl'!J17'SampleCalculation AR HCl'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation AR HCl'!F11+0.4B2+0.01'SampleCalculation AR HCl'!J20'SampleCalculation AR HCl'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation AR HCl'!F12+0.02'SampleCalculation AR HCl'!E16*'SampleCalculation AR HCl'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation AR HCl'!F12+(0.042'SampleCalculation AR HCl'!J20'SampleCalculation AR HCl'!F13+0.026B7'SampleCalculation AR HCl'!J17'SampleCalculation AR HCl'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation AR HCl'!F12+0.02'SampleCalculation AR HCl'!J20*'SampleCalculation AR HCl'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation AR HCl'!F31'SampleCalculation AR HCl'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details AR HCl'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details AR HCl'!B2)	='Calculation Details AR HCl'!B3-'Calculation Details AR HCl'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details AR HCl'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details AR HCl'!B4		=IF('Calculation Details AR HCl'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details AR HCl'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details AR HCl'!E18+'Calculation Details AR HCl'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details AR HCl'!E19-'Calculation Details AR HCl'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details AR HCl'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details AR HCl'!B7				shell color:	=VLOOKUP('Calculation Details AR HCl'!B24,'SampleCalculation AR HCl'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details AR HCl'!B25="N","New",IF('Calculation Details AR HCl'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details AR HCl'!B11	ft			shell alpha:	=IF('Calculation Details AR HCl'!B25="N",VLOOKUP('Calculation Details AR HCl'!B24,'SampleCalculation AR HCl'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR HCl'!B25="Ag",VLOOKUP('Calculation Details AR HCl'!B24,'SampleCalculation AR HCl'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR HCl'!B24,'SampleCalculation AR HCl'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details AR HCl'!B12	ft			roof color:	=VLOOKUP('Calculation Details AR HCl'!B26,'SampleCalculation AR HCl'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details AR HCl'!B21	ft		roof condition:	=IF('Calculation Details AR HCl'!B27="N","New",IF('Calculation Details AR HCl'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details AR HCl'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details AR HCl'!B20	ft		roof alpha:	=IF('Calculation Details AR HCl'!B27="N",VLOOKUP('Calculation Details AR HCl'!B26,'SampleCalculation AR HCl'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR HCl'!B27="Ag",VLOOKUP('Calculation Details AR HCl'!B26,'SampleCalculation AR HCl'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR HCl'!B26,'SampleCalculation AR HCl'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details AR HCl'!B5,'SampleCalculation AR HCl'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details AR HCl'!B5="A",('Calculation Details AR HCl'!B13('Calculation Details AR HCl'!B11/2)/12)/3,IF('Calculation Details AR HCl'!B5="B",'Calculation Details AR HCl'!B16/2+(2'Calculation Details AR HCl'!B16^3)/(3*'SampleCalculation AR HCl'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details AR HCl'!E33="",F23,E18+J22+'Calculation Details AR HCl'!B15/3+'Calculation Details AR HCl'!B19-'Calculation Details AR HCl'!E33)	ft			Average Hvo	='Calculation Details AR HCl'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details AR HCl'!B30	psig							Hvo	='Calculation Details AR HCl'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details AR HCl'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details AR HCl'!E5								Tb	='Calculation Details AR HCl'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details AR HCl'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details AR HCl'!E8=0,"",'Calculation Details AR HCl'!E8)	psi	(if specified)			A:	=IF('Calculation Details AR HCl'!E13=0,"",'Calculation Details AR HCl'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details AR HCl'!H29=0,"",'Calculation Details AR HCl'!H29)		(if specified)			B:	=IF('Calculation Details AR HCl'!E14=0,"",'Calculation Details AR HCl'!E14)
31			Molecular Weight, MV:			='Calculation Details AR HCl'!E7	lb/lb-mol				C:	=IF('Calculation Details AR HCl'!E15=0,"",'Calculation Details AR HCl'!E15)		Tla	='Calculation Details AR HCl'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal AR HCl'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details AR HCl'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details AR HCl'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details AR HCl'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal AR HCl'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR HCl'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details AR HCl'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details AR HCl'!E15)=FALSE,(10^('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/((F35-32)*(5/9)+'Calculation Details AR HCl'!E15))))/51.7144,EXP('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal AR HCl'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details AR HCl'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal AR HCl'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details AR HCl'!H35=-1,"",'Calculation Details AR HCl'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details AR HCl'!H34=-1,"",'Calculation Details AR HCl'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details AR HCl'!H36=-1,"",'Calculation Details AR HCl'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details AR HCl'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details AR HCl'!B2)=1,DAY('Calculation Details AR HCl'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details AR HCl'!B3-'Calculation Details AR HCl'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal AR HCl'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details AR HCl'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR HCl'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details AR HCl'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details AR HCl'!E15)=FALSE,(10^('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/((E51-32)*(5/9)+'Calculation Details AR HCl'!E15))))/51.7144,EXP('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR HCl'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details AR HCl'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details AR HCl'!E15)=FALSE,(10^('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/((E52-32)*(5/9)+'Calculation Details AR HCl'!E15))))/51.7144,EXP('Calculation Details AR HCl'!E13-('Calculation Details AR HCl'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details AR HCl'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details AR HCl'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details AR HCl'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details AR HCl'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details AR HCl'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details AR HCl'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details AR HCl'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation AR HCl'!P69+'SampleCalculation AR HCl'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details AR HCl'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details AR HCl'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details AR HCl'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details AR HCl'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details AR HCl'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details AR HCl'!H25	=IF(F75<>0,IF(ABS(P75-F75)/ABS(F75)>$S$18,"ERROR","OKAY"),IF(P75<>F75,"ERROR","OKAY"))
76						=F72(1-D66'Calculation Details AR HCl'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A
1	H

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	94.1994546120775
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	H2SO4_T1	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Sulfuric_20	Sa	0
6	Floating roof type	E	Liquid density (Wl)	9.42	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	18.0153	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	H2SO4_20
11	Eff Diameter	8	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	10	Effective Antoines B for liquid		Product	Sulfuric_20
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	5196000
15	Height of cone down bottom	0	Antoines C		Average TVP	0.22632784940763
16	Height of roof	1.07179676972449	True vapor pressure (TVP)	0.22632784940763	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.000736975085156067	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	3.17148726015437
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	94.1994546120775
21	Max liquid level	9	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	8	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	5.54872364250681	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	97.3709418722319
25	Shell Condition	Av	Is initial fill	False	Summary total losses	0
26	Roof Finish (color)	K	Stock ID	Sulfuric_20	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	55.1053515198115	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	20.4879525695979	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	0.191153377435804
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	0.267084461323081
34	Tank build date		Throughput	5196000	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	123714.285714286	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	1727.15938961719	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	0.184036227449733	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	5.54872364250681	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	1.25
43	Slotted pole EF		Volume of vapor space	278.90927091359	Vapor Space Temperature	55.8986417177051
44	Unslotted pole EF		Ke	0.0450857445391869	Vapor Space Temperature Range	20.4879525695979
45	Deck fitting EF		Ks	0.937594615149749	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	3.17148726015437

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details D H2SO4'!B9="N",IF('Calculation Details D H2SO4'!H41=TRUE,'Calculation Details D H2SO4'!E27,D10),IF('Calculation Details D H2SO4'!H41=TRUE,'Calculation Details D H2SO4'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details D H2SO4'!B9="F",B2,IF('Calculation Details D H2SO4'!B9="P",D13,IF('Calculation Details D H2SO4'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details D H2SO4'!B9="F",B2,IF('Calculation Details D H2SO4'!B9="P",D16,IF('Calculation Details D H2SO4'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details D H2SO4'!B9="F",0,IF('Calculation Details D H2SO4'!B9="P",D19,IF('Calculation Details D H2SO4'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details D H2SO4'!B12/'Calculation Details D H2SO4'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation D-H2SO4'!F11+0.003'SampleCalculation D-H2SO4'!J17'SampleCalculation D-H2SO4'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation D-H2SO4'!F11+0.6B2+0.005'SampleCalculation D-H2SO4'!E16'SampleCalculation D-H2SO4'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation D-H2SO4'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation D-H2SO4'!J20'SampleCalculation D-H2SO4'!F13 + 0.013B7'SampleCalculation D-H2SO4'!J17'SampleCalculation D-H2SO4'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation D-H2SO4'!F11+0.7B2+0.005'SampleCalculation D-H2SO4'!J20'SampleCalculation D-H2SO4'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation D-H2SO4'!F11+0.3B2+0.009'SampleCalculation D-H2SO4'!E16'SampleCalculation D-H2SO4'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation D-H2SO4'!F11 + 0.8B2 + 0.021'SampleCalculation D-H2SO4'!J20'SampleCalculation D-H2SO4'!F13 + 0.013B7'SampleCalculation D-H2SO4'!J17'SampleCalculation D-H2SO4'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation D-H2SO4'!F11+0.4B2+0.01'SampleCalculation D-H2SO4'!J20'SampleCalculation D-H2SO4'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation D-H2SO4'!F12+0.02'SampleCalculation D-H2SO4'!E16*'SampleCalculation D-H2SO4'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation D-H2SO4'!F12+(0.042'SampleCalculation D-H2SO4'!J20'SampleCalculation D-H2SO4'!F13+0.026B7'SampleCalculation D-H2SO4'!J17'SampleCalculation D-H2SO4'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation D-H2SO4'!F12+0.02'SampleCalculation D-H2SO4'!J20*'SampleCalculation D-H2SO4'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation D-H2SO4'!F31'SampleCalculation D-H2SO4'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details D H2SO4'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details D H2SO4'!B2)	='Calculation Details D H2SO4'!B3-'Calculation Details D H2SO4'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details D H2SO4'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details D H2SO4'!B4		=IF('Calculation Details D H2SO4'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details D H2SO4'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details D H2SO4'!E18+'Calculation Details D H2SO4'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details D H2SO4'!E19-'Calculation Details D H2SO4'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details D H2SO4'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details D H2SO4'!B7				shell color:	=VLOOKUP('Calculation Details D H2SO4'!B24,'SampleCalculation D-H2SO4'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details D H2SO4'!B25="N","New",IF('Calculation Details D H2SO4'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details D H2SO4'!B11	ft			shell alpha:	=IF('Calculation Details D H2SO4'!B25="N",VLOOKUP('Calculation Details D H2SO4'!B24,'SampleCalculation D-H2SO4'!$O$5:$T$16,4,FALSE),IF('Calculation Details D H2SO4'!B25="Ag",VLOOKUP('Calculation Details D H2SO4'!B24,'SampleCalculation D-H2SO4'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details D H2SO4'!B24,'SampleCalculation D-H2SO4'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details D H2SO4'!B12	ft			roof color:	=VLOOKUP('Calculation Details D H2SO4'!B26,'SampleCalculation D-H2SO4'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details D H2SO4'!B21	ft		roof condition:	=IF('Calculation Details D H2SO4'!B27="N","New",IF('Calculation Details D H2SO4'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details D H2SO4'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details D H2SO4'!B20	ft		roof alpha:	=IF('Calculation Details D H2SO4'!B27="N",VLOOKUP('Calculation Details D H2SO4'!B26,'SampleCalculation D-H2SO4'!$O$5:$T$16,4,FALSE),IF('Calculation Details D H2SO4'!B27="Ag",VLOOKUP('Calculation Details D H2SO4'!B26,'SampleCalculation D-H2SO4'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details D H2SO4'!B26,'SampleCalculation D-H2SO4'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details D H2SO4'!B5,'SampleCalculation D-H2SO4'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details D H2SO4'!B5="A",('Calculation Details D H2SO4'!B13('Calculation Details D H2SO4'!B11/2)/12)/3,IF('Calculation Details D H2SO4'!B5="B",'Calculation Details D H2SO4'!B16/2+(2'Calculation Details D H2SO4'!B16^3)/(3*'SampleCalculation D-H2SO4'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details D H2SO4'!E33="",F23,E18+J22+'Calculation Details D H2SO4'!B15/3+'Calculation Details D H2SO4'!B19-'Calculation Details D H2SO4'!E33)	ft			Average Hvo	='Calculation Details D H2SO4'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details D H2SO4'!B30	psig							Hvo	='Calculation Details D H2SO4'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details D H2SO4'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details D H2SO4'!E5								Tb	='Calculation Details D H2SO4'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details D H2SO4'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details D H2SO4'!E8=0,"",'Calculation Details D H2SO4'!E8)	psi	(if specified)			A:	=IF('Calculation Details D H2SO4'!E13=0,"",'Calculation Details D H2SO4'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details D H2SO4'!H29=0,"",'Calculation Details D H2SO4'!H29)		(if specified)			B:	=IF('Calculation Details D H2SO4'!E14=0,"",'Calculation Details D H2SO4'!E14)
31			Molecular Weight, MV:			='Calculation Details D H2SO4'!E7	lb/lb-mol				C:	=IF('Calculation Details D H2SO4'!E15=0,"",'Calculation Details D H2SO4'!E15)		Tla	='Calculation Details D H2SO4'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal D H2SO4'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details D H2SO4'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details D H2SO4'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details D H2SO4'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal D H2SO4'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details D H2SO4'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details D H2SO4'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details D H2SO4'!E15)=FALSE,(10^('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/((F35-32)*(5/9)+'Calculation Details D H2SO4'!E15))))/51.7144,EXP('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal D H2SO4'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details D H2SO4'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal D H2SO4'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details D H2SO4'!H35=-1,"",'Calculation Details D H2SO4'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details D H2SO4'!H34=-1,"",'Calculation Details D H2SO4'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details D H2SO4'!H36=-1,"",'Calculation Details D H2SO4'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details D H2SO4'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details D H2SO4'!B2)=1,DAY('Calculation Details D H2SO4'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details D H2SO4'!B3-'Calculation Details D H2SO4'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal D H2SO4'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details D H2SO4'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details D H2SO4'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details D H2SO4'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details D H2SO4'!E15)=FALSE,(10^('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/((E51-32)*(5/9)+'Calculation Details D H2SO4'!E15))))/51.7144,EXP('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details D H2SO4'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details D H2SO4'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details D H2SO4'!E15)=FALSE,(10^('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/((E52-32)*(5/9)+'Calculation Details D H2SO4'!E15))))/51.7144,EXP('Calculation Details D H2SO4'!E13-('Calculation Details D H2SO4'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details D H2SO4'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details D H2SO4'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details D H2SO4'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details D H2SO4'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details D H2SO4'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details D H2SO4'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details D H2SO4'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation D-H2SO4'!P69+'SampleCalculation D-H2SO4'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details D H2SO4'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details D H2SO4'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details D H2SO4'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details D H2SO4'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details D H2SO4'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details D H2SO4'!H25
76						=F72(1-D66'Calculation Details D H2SO4'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A
1

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	0
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	AR Feed Mix_T1	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Ammonia_4	Sa	0
6	Floating roof type	E	Liquid density (Wl)	8.21854368932039	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	17.4196323744772	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	NH3_4
11	Eff Diameter	7	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	8	Effective Antoines B for liquid		Product	Ammonia_4
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	0
15	Height of cone down bottom	0	Antoines C		Average TVP	0.524535770932851
16	Height of roof	0.93782217350893	True vapor pressure (TVP)	0.524535770932851	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.00165140504079297	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	4.75198592124757
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	0
21	Max liquid level	7	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	6	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	4.48013318719346	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	4.75198592124757
25	Shell Condition	Av	Is initial fill	False	Summary total losses	2.81038725706847
26	Roof Finish (color)	K	Stock ID	Ammonia_4	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	55.1254152796804	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	20.3760878667376	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	0.447103572804186
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	0.613634673692497
34	Tank build date		Throughput	0	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	0	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	0	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	1	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	4.48013318719346	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	1.14285714285714
43	Slotted pole EF		Volume of vapor space	172.415730472887	Vapor Space Temperature	55.9387692374429
44	Unslotted pole EF		Ke	0.0514197967949108	Vapor Space Temperature Range	20.3760878667376
45	Deck fitting EF		Ks	0.889245000995272	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	4.75198592124757

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details AR_feed_mix'!B9="N",IF('Calculation Details AR_feed_mix'!H41=TRUE,'Calculation Details AR_feed_mix'!E27,D10),IF('Calculation Details AR_feed_mix'!H41=TRUE,'Calculation Details AR_feed_mix'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details AR_feed_mix'!B9="F",B2,IF('Calculation Details AR_feed_mix'!B9="P",D13,IF('Calculation Details AR_feed_mix'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details AR_feed_mix'!B9="F",B2,IF('Calculation Details AR_feed_mix'!B9="P",D16,IF('Calculation Details AR_feed_mix'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details AR_feed_mix'!B9="F",0,IF('Calculation Details AR_feed_mix'!B9="P",D19,IF('Calculation Details AR_feed_mix'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details AR_feed_mix'!B12/'Calculation Details AR_feed_mix'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation AR_feed_mix'!F11+0.003'SampleCalculation AR_feed_mix'!J17'SampleCalculation AR_feed_mix'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation AR_feed_mix'!F11+0.6B2+0.005'SampleCalculation AR_feed_mix'!E16'SampleCalculation AR_feed_mix'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation AR_feed_mix'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation AR_feed_mix'!J20'SampleCalculation AR_feed_mix'!F13 + 0.013B7'SampleCalculation AR_feed_mix'!J17'SampleCalculation AR_feed_mix'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation AR_feed_mix'!F11+0.7B2+0.005'SampleCalculation AR_feed_mix'!J20'SampleCalculation AR_feed_mix'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation AR_feed_mix'!F11+0.3B2+0.009'SampleCalculation AR_feed_mix'!E16'SampleCalculation AR_feed_mix'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation AR_feed_mix'!F11 + 0.8B2 + 0.021'SampleCalculation AR_feed_mix'!J20'SampleCalculation AR_feed_mix'!F13 + 0.013B7'SampleCalculation AR_feed_mix'!J17'SampleCalculation AR_feed_mix'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation AR_feed_mix'!F11+0.4B2+0.01'SampleCalculation AR_feed_mix'!J20'SampleCalculation AR_feed_mix'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation AR_feed_mix'!F12+0.02'SampleCalculation AR_feed_mix'!E16*'SampleCalculation AR_feed_mix'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation AR_feed_mix'!F12+(0.042'SampleCalculation AR_feed_mix'!J20'SampleCalculation AR_feed_mix'!F13+0.026B7'SampleCalculation AR_feed_mix'!J17'SampleCalculation AR_feed_mix'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation AR_feed_mix'!F12+0.02'SampleCalculation AR_feed_mix'!J20*'SampleCalculation AR_feed_mix'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation AR_feed_mix'!F31'SampleCalculation AR_feed_mix'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details AR_feed_mix'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details AR_feed_mix'!B2)	='Calculation Details AR_feed_mix'!B3-'Calculation Details AR_feed_mix'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details AR_feed_mix'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details AR_feed_mix'!B4		=IF('Calculation Details AR_feed_mix'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details AR_feed_mix'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details AR_feed_mix'!E18+'Calculation Details AR_feed_mix'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details AR_feed_mix'!E19-'Calculation Details AR_feed_mix'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details AR_feed_mix'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details AR_feed_mix'!B7				shell color:	=VLOOKUP('Calculation Details AR_feed_mix'!B24,'SampleCalculation AR_feed_mix'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details AR_feed_mix'!B25="N","New",IF('Calculation Details AR_feed_mix'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details AR_feed_mix'!B11	ft			shell alpha:	=IF('Calculation Details AR_feed_mix'!B25="N",VLOOKUP('Calculation Details AR_feed_mix'!B24,'SampleCalculation AR_feed_mix'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR_feed_mix'!B25="Ag",VLOOKUP('Calculation Details AR_feed_mix'!B24,'SampleCalculation AR_feed_mix'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR_feed_mix'!B24,'SampleCalculation AR_feed_mix'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details AR_feed_mix'!B12	ft			roof color:	=VLOOKUP('Calculation Details AR_feed_mix'!B26,'SampleCalculation AR_feed_mix'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details AR_feed_mix'!B21	ft		roof condition:	=IF('Calculation Details AR_feed_mix'!B27="N","New",IF('Calculation Details AR_feed_mix'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details AR_feed_mix'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details AR_feed_mix'!B20	ft		roof alpha:	=IF('Calculation Details AR_feed_mix'!B27="N",VLOOKUP('Calculation Details AR_feed_mix'!B26,'SampleCalculation AR_feed_mix'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR_feed_mix'!B27="Ag",VLOOKUP('Calculation Details AR_feed_mix'!B26,'SampleCalculation AR_feed_mix'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR_feed_mix'!B26,'SampleCalculation AR_feed_mix'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details AR_feed_mix'!B5,'SampleCalculation AR_feed_mix'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details AR_feed_mix'!B5="A",('Calculation Details AR_feed_mix'!B13('Calculation Details AR_feed_mix'!B11/2)/12)/3,IF('Calculation Details AR_feed_mix'!B5="B",'Calculation Details AR_feed_mix'!B16/2+(2'Calculation Details AR_feed_mix'!B16^3)/(3*'SampleCalculation AR_feed_mix'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details AR_feed_mix'!E33="",F23,E18+J22+'Calculation Details AR_feed_mix'!B15/3+'Calculation Details AR_feed_mix'!B19-'Calculation Details AR_feed_mix'!E33)	ft			Average Hvo	='Calculation Details AR_feed_mix'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details AR_feed_mix'!B30	psig							Hvo	='Calculation Details AR_feed_mix'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details AR_feed_mix'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details AR_feed_mix'!E5								Tb	='Calculation Details AR_feed_mix'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details AR_feed_mix'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details AR_feed_mix'!E8=0,"",'Calculation Details AR_feed_mix'!E8)	psi	(if specified)			A:	=IF('Calculation Details AR_feed_mix'!E13=0,"",'Calculation Details AR_feed_mix'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details AR_feed_mix'!H29=0,"",'Calculation Details AR_feed_mix'!H29)		(if specified)			B:	=IF('Calculation Details AR_feed_mix'!E14=0,"",'Calculation Details AR_feed_mix'!E14)
31			Molecular Weight, MV:			='Calculation Details AR_feed_mix'!E7	lb/lb-mol				C:	=IF('Calculation Details AR_feed_mix'!E15=0,"",'Calculation Details AR_feed_mix'!E15)		Tla	='Calculation Details AR_feed_mix'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal AR_feed_mix'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details AR_feed_mix'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details AR_feed_mix'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details AR_feed_mix'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal AR_feed_mix'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_feed_mix'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details AR_feed_mix'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details AR_feed_mix'!E15)=FALSE,(10^('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/((F35-32)*(5/9)+'Calculation Details AR_feed_mix'!E15))))/51.7144,EXP('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal AR_feed_mix'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details AR_feed_mix'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal AR_feed_mix'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details AR_feed_mix'!H35=-1,"",'Calculation Details AR_feed_mix'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details AR_feed_mix'!H34=-1,"",'Calculation Details AR_feed_mix'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details AR_feed_mix'!H36=-1,"",'Calculation Details AR_feed_mix'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details AR_feed_mix'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details AR_feed_mix'!B2)=1,DAY('Calculation Details AR_feed_mix'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details AR_feed_mix'!B3-'Calculation Details AR_feed_mix'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal AR_feed_mix'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details AR_feed_mix'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_feed_mix'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details AR_feed_mix'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details AR_feed_mix'!E15)=FALSE,(10^('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/((E51-32)*(5/9)+'Calculation Details AR_feed_mix'!E15))))/51.7144,EXP('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_feed_mix'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details AR_feed_mix'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details AR_feed_mix'!E15)=FALSE,(10^('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/((E52-32)*(5/9)+'Calculation Details AR_feed_mix'!E15))))/51.7144,EXP('Calculation Details AR_feed_mix'!E13-('Calculation Details AR_feed_mix'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details AR_feed_mix'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details AR_feed_mix'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details AR_feed_mix'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details AR_feed_mix'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details AR_feed_mix'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details AR_feed_mix'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details AR_feed_mix'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation AR_feed_mix'!P69+'SampleCalculation AR_feed_mix'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details AR_feed_mix'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details AR_feed_mix'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details AR_feed_mix'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details AR_feed_mix'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details AR_feed_mix'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details AR_feed_mix'!H25
76						=F72(1-D66'Calculation Details AR_feed_mix'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A	B	C	D	E	F	G
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

	A	B	D	E	G	H
1	Site	ATI Millersburg	Panel width		Working loss	0
2	Start date	01/01/2026 00:00:00	Panel length		Loss from incoming vapors	0
3	End date	01/01/2027 00:00:00	Stock is active	True	Loss from resident vapors	0
4	Tank ID	AR Feed Storage_T1	Stock is crude	False	Cleaning loss	0
5	Fixed roof type	B	Stock description	Ammonia_4	Sa	0
6	Floating roof type	E	Liquid density (Wl)	8.21854368932039	Resident loss limit
7	Tank type	FixedRoof	Molecular weight of vapor (Mv)	17.4194992105902	Vapor control eff	0
8	Is closed	False	Reid vapor pressure (RVP)	0	Vapor control eff for Refill or Initial Purge	0
9	Insulate Condition	N	Liquid Kp	1	Comments
10	Has floating roof	False	Liquid Kc	1	Stock Abbreviation	NH3_4
11	Eff Diameter	12	Liquid clingage fctr	0.0015	Summary Tank type	FRT (no floating roof)
12	Eff Height	20	Effective Antoines B for liquid		Product	Ammonia_4
13	Cone roof slope	0.75	Antoines A		RVP
14	Cone bottom slope	0	Antoines B		Throughput in gallons	0
15	Height of cone down bottom	0	Antoines C		Average TVP	0.523201749804905
16	Height of roof	1.60769515458674	True vapor pressure (TVP)	0.523201749804905	Number of days	365
17	Sump diameter	0	Vapor density (Wv)	0.00164771621464832	Number of days cleaning	0
18	Sump height	0	Min temperature	43.8557260273973	Summary Refill or Initial Purge losses	0
19	Eff sump height	0	Max temperature	63.046	Summary standing losses	29.7567845840158
20	Min liquid level	1	Solar insolation	1148.2644109589	Summary working losses	0
21	Max liquid level	19	Atmospheric pressure	14.591024	Summary cleaning losses	0
22	Net working height	18	Avg wind speed	6.48605479452055	Summary vapor control eff	0
23	Avg height of vapor space	10.8230854637602	Service type	Normal	Summary non-routine losses	0
24	Shell Finish (color)	K	Is non-routine	False	Summary routine losses	29.7567845840158
25	Shell Condition	Av	Is initial fill	False	Summary total losses	17.6026243401031
26	Roof Finish (color)	K	Stock ID	Ammonia_4	Is FRL	False
27	Roof Condition	Av	Bulk liquid temperature	54.3120613219178	Is cleaning	False
28	Avg alpha	0.25	Liquid surface temperature	55.0434782483595	Is vapor control device used	False
29	Min vent relief pressure	0	Low-volume liquid temperature	53.4508630136986	Distillation slope (S)
30	Max vent relief pressure	0	Delta Tv	20.8329245574604	Maximum fill rate
31	Vent pressure range	0	Height of substance		Meteorological Location	Salem,OR
32	Number of columns		Height of substance ref pt	NOT GIVEN	Minimum Temp TVP	0.444336565678572
33	Eff column diameter		Eff height of liquid heel		Maximum Temp TVP	0.614239426096848
34	Tank build date		Throughput	0	Minimum Heated Temperature
35	Tank assoc src category		Throughput in barrels	0	Maximum Heated Temperature
36	Eff wind speed		Throughput unit	gallons	Number of Heating Cycle Days
37	Floating roof Kd		Number of turnovers	0	Custom Fitting 1 Type
38	Floating roof Sd		TankOps Kn	1	Custom Fitting 1 EF
39	Floating roof Kr		TankOps Kb	1	Custom Fitting 2 Type
40	Rim seal Type	N/A	Nominal op pressure	0	Custom Fitting 2 EF
41	Rim seal EF		Height of vapor space	10.8230854637602	UserProvidedTemperature	False
42	Seam EF		Height of deck support legs	0	H/D Ratio	1.66666666666667
43	Slotted pole EF		Volume of vapor space	1224.06212815645	Vapor Space Temperature	55.7748951748011
44	Unslotted pole EF		Ke	0.0525522092007811	Vapor Space Temperature Range	20.8329245574604
45	Deck fitting EF		Ks	0.769159276227993	H/D Ratio Option	2
46	Floating roof EF		PMvKc	0	Capture Efficiency
47	Slotted pole qty		FRL loss	0	Calculation Template	CalculationSteps_Post2019AP42_FixedRoofTank_Routine&ChangeOfService.xlsx
48	Unslotted pole qty		FRL limit	0
49	Kf per slotted pole		Floating roof standing storage loss fctr
50	Kf per unslotted pole		Standing loss	29.7567845840158

	A	B	C	D
1	Variable	Result
2	TB	=IF('Calculation Details AR_storage'!B9="N",IF('Calculation Details AR_storage'!H41=TRUE,'Calculation Details AR_storage'!E27,D10),IF('Calculation Details AR_storage'!H41=TRUE,'Calculation Details AR_storage'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details AR_storage'!B9="F",B2,IF('Calculation Details AR_storage'!B9="P",D13,IF('Calculation Details AR_storage'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details AR_storage'!B9="F",B2,IF('Calculation Details AR_storage'!B9="P",D16,IF('Calculation Details AR_storage'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details AR_storage'!B9="F",0,IF('Calculation Details AR_storage'!B9="P",D19,IF('Calculation Details AR_storage'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details AR_storage'!B12/'Calculation Details AR_storage'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	='SampleCalculation AR_storage'!F11+0.003'SampleCalculation AR_storage'!J17'SampleCalculation AR_storage'!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4'SampleCalculation AR_storage'!F11+0.6B2+0.005'SampleCalculation AR_storage'!E16'SampleCalculation AR_storage'!F13
12	Calculated	Not insulated	TLA = [0.5 – 0.8 / (4.4 Hs/D + 3.8)] TAA + [0.5 + 0.8 / (4.4 Hs/D + 3.8)] TB + [0.021 αRI + 0.013 (Hs/D) αSI] / (4.4 Hs/D + 3.8)	=(0.5-0.8/(4.4 B7+3.8))'SampleCalculation AR_storage'!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021'SampleCalculation AR_storage'!J20'SampleCalculation AR_storage'!F13 + 0.013B7'SampleCalculation AR_storage'!J17'SampleCalculation AR_storage'!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3'SampleCalculation AR_storage'!F11+0.7B2+0.005'SampleCalculation AR_storage'!J20'SampleCalculation AR_storage'!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7'SampleCalculation AR_storage'!F11+0.3B2+0.009'SampleCalculation AR_storage'!E16'SampleCalculation AR_storage'!F13
15	Calculated	Not insulated	TV = [(2.2 Hs/D + 1.1) TAA + 0.8 TB + 0.021 αRI + 0.013 (Hs/D) αSI] / [2.2 Hs/D + 1.9]	=((2.2B7 + 1.1)'SampleCalculation AR_storage'!F11 + 0.8B2 + 0.021'SampleCalculation AR_storage'!J20'SampleCalculation AR_storage'!F13 + 0.013B7'SampleCalculation AR_storage'!J17'SampleCalculation AR_storage'!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6'SampleCalculation AR_storage'!F11+0.4B2+0.01'SampleCalculation AR_storage'!J20'SampleCalculation AR_storage'!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7'SampleCalculation AR_storage'!F12+0.02'SampleCalculation AR_storage'!E16*'SampleCalculation AR_storage'!F13
18	Calculated	Not insulated	ΔTV = [1 – 0.8 / (2.2 Hs/D + 1.9)] (TAX – TAN) + [0.042 αRI + 0.026 (Hs/D) αSI] / (2.2 Hs/D + 1.9)	=(1-0.8/(2.2B7+1.9))'SampleCalculation AR_storage'!F12+(0.042'SampleCalculation AR_storage'!J20'SampleCalculation AR_storage'!F13+0.026B7'SampleCalculation AR_storage'!J17'SampleCalculation AR_storage'!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6'SampleCalculation AR_storage'!F12+0.02'SampleCalculation AR_storage'!J20*'SampleCalculation AR_storage'!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=('SampleCalculation AR_storage'!F31'SampleCalculation AR_storage'!F36)/(10.731(B4+459.67))
21
22

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V
1	Sample Calculation of Estimated Emissions - Fixed-Roof Tanks												page 1 of 1	Not intended for tanks that have a change
2	The emissions estimates calculated below are based on EPA's AP-42 Chapter 7.1 (Post 2018) emission factors and equations,													of service during the period in question.
3														=MONTH('Calculation Details AR_storage'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details AR_storage'!B2)	='Calculation Details AR_storage'!B3-'Calculation Details AR_storage'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details AR_storage'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details AR_storage'!B4		=IF('Calculation Details AR_storage'!B6<>"E","Wrong template - this is not a fixed-roof tank!","")							B	aluminum-colored paint (diffuse)		0.6	0.68	0.64	2	February
7								Emission estimates per EPA's AP-42 Chapter 7.1 (Post 2018), for:	=IF(H43="month",P3,IF(H43="year","annual",H43))					C	beige/cream-colored paint		0.35	0.49	0.42	3	March
8									=Q3					D	brown paint		0.58	0.67	0.62	4	April
9		Meteorological Data:												E	light gray paint		0.54	0.63	0.58	5	May
10			Avg Atmos Pressure, Pa:			='Calculation Details AR_storage'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details AR_storage'!E18+'Calculation Details AR_storage'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details AR_storage'!E19-'Calculation Details AR_storage'!E18	degrees F							H	red primer or dark green paint		0.89	0.91	0.9	8	August
13			Avg Daily Solar Insolation, I:			='Calculation Details AR_storage'!E20	Btu / ft2 day							I	rust (unpainted iron oxide)		0.38	0.5	0.44	9	September
14		Tank Data:												J	tan paint		0.43	0.55	0.49	10	October
15			Tank Type:		='Calculation Details AR_storage'!B7				shell color:	=VLOOKUP('Calculation Details AR_storage'!B24,'SampleCalculation AR_storage'!$O$5:$Q$16,2,FALSE)				K	white paint		0.17	0.34	0.25	11	November
16			Average alpha:		=(J17+J20)/2				shell condition:	=IF('Calculation Details AR_storage'!B25="N","New",IF('Calculation Details AR_storage'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details AR_storage'!B11	ft			shell alpha:	=IF('Calculation Details AR_storage'!B25="N",VLOOKUP('Calculation Details AR_storage'!B24,'SampleCalculation AR_storage'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR_storage'!B25="Ag",VLOOKUP('Calculation Details AR_storage'!B24,'SampleCalculation AR_storage'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR_storage'!B24,'SampleCalculation AR_storage'!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details AR_storage'!B12	ft			roof color:	=VLOOKUP('Calculation Details AR_storage'!B26,'SampleCalculation AR_storage'!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details AR_storage'!B21	ft		roof condition:	=IF('Calculation Details AR_storage'!B27="N","New",IF('Calculation Details AR_storage'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details AR_storage'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details AR_storage'!B20	ft		roof alpha:	=IF('Calculation Details AR_storage'!B27="N",VLOOKUP('Calculation Details AR_storage'!B26,'SampleCalculation AR_storage'!$O$5:$T$16,4,FALSE),IF('Calculation Details AR_storage'!B27="Ag",VLOOKUP('Calculation Details AR_storage'!B26,'SampleCalculation AR_storage'!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details AR_storage'!B26,'SampleCalculation AR_storage'!$O$5:$T$16,6,FALSE)))								B	self-supporting (dome)
21			Net Working Height:			=F19-F20	ft											C	no fixed roof (open top)
22			Fixed Roof Type:		=VLOOKUP('Calculation Details AR_storage'!B5,'SampleCalculation AR_storage'!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details AR_storage'!B5="A",('Calculation Details AR_storage'!B13('Calculation Details AR_storage'!B11/2)/12)/3,IF('Calculation Details AR_storage'!B5="B",'Calculation Details AR_storage'!B16/2+(2'Calculation Details AR_storage'!B16^3)/(3*'SampleCalculation AR_storage'!E17^2),0))	ft							D	horizontal tank
23			Average outage, HVO:			=IF(AND(ISBLANK(E$6),G$6<>""),"",E18-F19 +F21/2+J22)	ft		Hvo:	=IF('Calculation Details AR_storage'!E33="",F23,E18+J22+'Calculation Details AR_storage'!B15/3+'Calculation Details AR_storage'!B19-'Calculation Details AR_storage'!E33)	ft			Average Hvo	='Calculation Details AR_storage'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details AR_storage'!B30	psig							Hvo	='Calculation Details AR_storage'!E41	=IF(J23<>0,IF(ABS(P24-J23)/ABS(J23)>$S$18,"ERROR","OKAY"),IF(P24<>J23,"ERROR","OKAY"))
25			Min Vent Setting:			='Calculation Details AR_storage'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details AR_storage'!E5								Tb	='Calculation Details AR_storage'!E27	=IF(F32<>0,IF(ABS(P27-F32)/ABS(F32)>$S$18,"ERROR","OKAY"),IF(P27<>F32,"ERROR","OKAY"))
28			Product Factor, KP:			='Calculation Details AR_storage'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details AR_storage'!E8=0,"",'Calculation Details AR_storage'!E8)	psi	(if specified)			A:	=IF('Calculation Details AR_storage'!E13=0,"",'Calculation Details AR_storage'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details AR_storage'!H29=0,"",'Calculation Details AR_storage'!H29)		(if specified)			B:	=IF('Calculation Details AR_storage'!E14=0,"",'Calculation Details AR_storage'!E14)
31			Molecular Weight, MV:			='Calculation Details AR_storage'!E7	lb/lb-mol				C:	=IF('Calculation Details AR_storage'!E15=0,"",'Calculation Details AR_storage'!E15)		Tla	='Calculation Details AR_storage'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			='TempCal AR_storage'!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details AR_storage'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details AR_storage'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details AR_storage'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			='TempCal AR_storage'!B3	degrees F		=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-27, 1-28, 1-29")
36			True Vapor Pressure, P:			=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_storage'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details AR_storage'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(F35+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(F35+459.67)),IF(ISBLANK('Calculation Details AR_storage'!E15)=FALSE,(10^('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/((F35-32)*(5/9)+'Calculation Details AR_storage'!E15))))/51.7144,EXP('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			='TempCal AR_storage'!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details AR_storage'!H43	=IF(G38<>0,IF(ABS(P37-G38)/ABS(G38)>S18,"ERROR","OKAY"),IF(P37<>G38,"ERROR","OKAY"))
38		Heating Cycles:		Vapor Space Temp., Tv:			='TempCal AR_storage'!B4	degree F	=IF(F33="YES","same as bulk temp, for fully insulated tank","per AP-42 equation 1-32, 1-33, 1-34")
39			Max Liquid Bulk Temp:			=IF('Calculation Details AR_storage'!H35=-1,"",'Calculation Details AR_storage'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details AR_storage'!H34=-1,"",'Calculation Details AR_storage'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details AR_storage'!H36=-1,"",'Calculation Details AR_storage'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details AR_storage'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details AR_storage'!B2)=1,DAY('Calculation Details AR_storage'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details AR_storage'!B3-'Calculation Details AR_storage'!B2	days
45			Turnover Rate:			=(365/F44)E43/((F21PI()*E17^2/4)/5.614)	turnovers per year
46			Turnover Factor, KN:			=IF(F45<36,1,(180+F45)/(6*F45))
47		Calculated Values:
48			Vapor Space Expansion Factor, KE = {∆TV / (T + 459.67)} + {(∆PV - ∆PB) / (PA - P)}								AP-42 eqn 1-5				check against reported values
49			where:
50			∆TV =	='TempCal AR_storage'!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details AR_storage'!H44	=IF(D50<>0,IF(ABS(P50-D50)/ABS(D50)>S18,"ERROR","OKAY"),IF(P50<>D50,"ERROR","OKAY"))
51				Tlx =	=IF(F33="Yes",F35,F35+0.25*D50)	deg F	Pvx =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_storage'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details AR_storage'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E51+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E51+459.67)),IF(ISBLANK('Calculation Details AR_storage'!E15)=FALSE,(10^('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/((E51-32)*(5/9)+'Calculation Details AR_storage'!E15))))/51.7144,EXP('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/(E51+459.67)))))))))	psia
52				Tln =	=IF(F33="Yes",F35,F35-0.25*D50)	deg F	Pvn =	=IF(AND(NOT(ISBLANK(E6)),G6=""),IF(AND(F29="",L29=""),'Calculation Details AR_storage'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details AR_storage'!E4=TRUE),EXP((12.82-0.9672LN(F29))-(7261-1216LN(F29))/(E52+459.67)),IF(AND(CELL("type",F29)="v",NOT(CELL("type",F30)="v")),"need S",IF(CELL("type",F29)="v",EXP((15.64-1.854(F30)^0.5-(0.8742-0.328(F30)^0.5)LN(F29))-(8742-1042(F30)^0.5-(1049-179.4(F30)^0.5)LN(F29))/(E52+459.67)),IF(ISBLANK('Calculation Details AR_storage'!E15)=FALSE,(10^('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/((E52-32)*(5/9)+'Calculation Details AR_storage'!E15))))/51.7144,EXP('Calculation Details AR_storage'!E13-('Calculation Details AR_storage'!E14/(E52+459.67)))))))))	psia
53			∆PV =	=IF(AND(NOT(ISBLANK(E6)),G6=""),H51-H52,"")	psia	=IF(F33="YES","assume ∆TV, ∆PV equal 0 for a constant temperature tank","")
54			∆PB =	=F24-F25	psi; vent setting range
55			KE =	=MAX(D50/(F35+459.67)+(D53-D54)/(F10-F36),0)										KE	='Calculation Details AR_storage'!E44	=IF(D55<>0,IF(ABS(P55-D55)/ABS(D55)>S18,"ERROR","OKAY"),IF(P55>0,"ERROR","OKAY"))
56			Vented Vapor Saturation Factor, KS = 1 / (1+ 0.053 P HVO)								AP-42 eqn 1-21
57			KS =	=1/(1+0.053F36J23)										KS	='Calculation Details AR_storage'!E45	=IF(D57<>0,IF(ABS(P57-D57)/ABS(D57)>S18,"ERROR","OKAY"),IF(P57<>D57,"ERROR","OKAY"))
58			Vent Setting Correction Factor, KB:
59			KB =	1; except when:
60				KN [(PBP + PA) / (PI + PA)] > 1							AP-42 eqn 1-40
61			KB =	[(PI + PA)/KN - P] / [PBP + PA - P]							AP-42 eqn 1-41
62				where:
63				PBP =	=F24	psig; vent pressure setting
64				PI =	='Calculation Details AR_storage'!E40	psig; initial gauge pressure (nominal operating pressure)
65			KB =	=IF(AND(ABS(E63)>0.03,F46*(E63+F10)/(E64+F10)>1),((E64+F10)/F46-F36)/(E63+F10-F36),1)										KB	='Calculation Details AR_storage'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details AR_storage'!H7
67
68		Emissions Estimate for:				=I7	=I8								check against reported values
69			Standing Storage Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",J23PI()E17^2/4D55D57F44F37)	lb per	=H$43			AP-42 eqn 1-4			Standing Storage Loss	='Calculation Details AR_storage'!E50	=IF(F69<>0,IF(ABS(P69-F69)/ABS(F69)>S18,"ERROR","OKAY"),IF(P69<>F69,"ERROR","OKAY"))
70			Working Loss:			=IF(OR(ISBLANK(E6),G6<>""),"",F45(F44/365)F21(PI()E17^2/4)F46F28F37D65)	lb per	=H$43			AP-42 eqn 1-35			Working Loss	='Calculation Details AR_storage'!H1	=IF(F70<>0,IF(ABS(P70-F70)/ABS(F70)>S18,"ERROR","OKAY"),IF(P70<>F70,"ERROR","OKAY"))
71			Total Emissions (w/o heating cycle loss):			=F69+F70	lb per	=H$43			AP-42 eqn 1-1			Total Emissions	='SampleCalculation AR_storage'!P69+'SampleCalculation AR_storage'!P70	=IF(F71<>0,IF(ABS(P71-F71)/ABS(F71)>$S$18,"ERROR","OKAY"),IF(P71<>F71,"ERROR","OKAY"))
72						=F71/2000	tons per	=H$43
73		Standing Storage Loss(with control):				=F69(1-D66'Calculation Details AR_storage'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details AR_storage'!H19	=IF(F73<>0,IF(ABS(P73-F73)/ABS(F73)>$S$18,"ERROR","OKAY"),IF(P73<>F73,"ERROR","OKAY"))
74			Working Loss(with control):			=F70(1-D66'Calculation Details AR_storage'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details AR_storage'!H20	=IF(F74<>0,IF(ABS(P74-F74)/ABS(F74)>$S$18,"ERROR","OKAY"),IF(P74<>F74,"ERROR","OKAY"))
75				Total Emissions(with control):		=F71(1-D66'Calculation Details AR_storage'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details AR_storage'!H25
76						=F72(1-D66'Calculation Details AR_storage'!H46)	tons per	=H$43		with fugitive
77
78
79
80
81
82

	A	B	C	D	E	F	G
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

	A	B	C	D	E	F	G
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

	A	B	C	D	E	F	G
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