Record Viewer

ATI Specialty Alloys & Components, LLC CAO Supporting Calculations Tank Files 4.17.2026.XLSX

TankESP+ Annual

Dilute_H2SO4

Calculation Details

TempCal

SampleCalculation

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
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 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	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	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	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

	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'!B9="N",IF('Calculation Details'!H41=TRUE,'Calculation Details'!E27,D10),IF('Calculation Details'!H41=TRUE,'Calculation Details'!E27,"TB must be entered by user for an insulated tank"))
3	TLA	=IF('Calculation Details'!B9="F",B2,IF('Calculation Details'!B9="P",D13,IF('Calculation Details'!H45=1,D11,D12)))
4	TV	=IF('Calculation Details'!B9="F",B2,IF('Calculation Details'!B9="P",D16,IF('Calculation Details'!H45=1,D14,D15)))
5	ΔTV	=IF('Calculation Details'!B9="F",0,IF('Calculation Details'!B9="P",D19,IF('Calculation Details'!H45=1,D17,D18)))
6	WV	=D20
7	H/D	='Calculation Details'!B12/'Calculation Details'!B11
8
9	H/D Ratio Option	Insulation Condition	Equation	Result
10	N/A	Not insulated	TB = TAA + 0.003 αS I	=SampleCalculation!F11+0.003SampleCalculation!J17SampleCalculation!F13
11	Default	Not insulated	TLA = 0.4 TAA + 0.6 TB + 0.005 α I	=0.4SampleCalculation!F11+0.6B2+0.005SampleCalculation!E16SampleCalculation!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!F11+(0.5+0.8/(4.4B7+3.8))B2+ (0.021SampleCalculation!J20SampleCalculation!F13 + 0.013B7SampleCalculation!J17SampleCalculation!F13)/(4.4B7+3.8)
13	N/A	Partially insulated	TLA = 0.3 TAA + 0.7 TB + 0.005 αR I	=0.3SampleCalculation!F11+0.7B2+0.005SampleCalculation!J20SampleCalculation!F13
14	Default	Not insulated	TV = 0.7 TAA + 0.3 TB + 0.009 α I	=0.7SampleCalculation!F11+0.3B2+0.009SampleCalculation!E16SampleCalculation!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!F11 + 0.8B2 + 0.021SampleCalculation!J20SampleCalculation!F13 + 0.013B7SampleCalculation!J17SampleCalculation!F13) / (2.2*B7 + 1.9)
16	N/A	Partially insulated	TV = 0.6 TAA + 0.4 TB + 0.01 αR I	=0.6SampleCalculation!F11+0.4B2+0.01SampleCalculation!J20SampleCalculation!F13
17	Default	Not insulated	ΔTV = 0.7 (TAX – TAN) + 0.02 α I	=0.7SampleCalculation!F12+0.02SampleCalculation!E16*SampleCalculation!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!F12+(0.042SampleCalculation!J20SampleCalculation!F13+0.026B7SampleCalculation!J17SampleCalculation!F13)/(2.2B7+ 1.9)
19	N/A	Partially insulated	ΔTV = 0.6 ΔTA + 0.02 αR I	=0.6SampleCalculation!F12+0.02SampleCalculation!J20*SampleCalculation!F13
20	N/A	N/A	WV = (MV PVA) / (R TV)	=(SampleCalculation!F31SampleCalculation!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'!B2)	=VLOOKUP(O3,U5:V16,2,FALSE)	=YEAR('Calculation Details'!B2)	='Calculation Details'!B3-'Calculation Details'!B2	days
4				Company:													N	Ag	Av
5				Location:	='Calculation Details'!B1									A	aluminum-colored paint (specular)		0.39	0.49	0.44	1	January
6				Calculations for Tank No.:	='Calculation Details'!B4		=IF('Calculation Details'!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'!E21	psia							F	medium gray paint		0.68	0.74	0.71	6	June
11			Avg Ambient Temp, Taa:			=('Calculation Details'!E18+'Calculation Details'!E19)/2	degrees F							G	black paint		0.97	0.97	0.97	7	July
12			Avg Daily Temp Range, ∆Ta:			='Calculation Details'!E19-'Calculation Details'!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'!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'!B7				shell color:	=VLOOKUP('Calculation Details'!B24,SampleCalculation!$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'!B25="N","New",IF('Calculation Details'!B25="Ag","Aged","Average"))				L	mill finish aluminum (unpainted)		0.1	0.15	0.12	12	December
17			Tank Diameter:		='Calculation Details'!B11	ft			shell alpha:	=IF('Calculation Details'!B25="N",VLOOKUP('Calculation Details'!B24,SampleCalculation!$O$5:$T$16,4,FALSE),IF('Calculation Details'!B25="Ag",VLOOKUP('Calculation Details'!B24,SampleCalculation!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details'!B24,SampleCalculation!$O$5:$T$16,6,FALSE)))
18			Tank Height:		='Calculation Details'!B12	ft			roof color:	=VLOOKUP('Calculation Details'!B26,SampleCalculation!$O$5:$Q$16,2,FALSE)				Check against reported values			Precision:	0.001
19			Maximum Fill Height:			='Calculation Details'!B21	ft		roof condition:	=IF('Calculation Details'!B27="N","New",IF('Calculation Details'!B27="Ag","Aged","Average"))				Average alpha	='Calculation Details'!B28	=IF(ABS(P19-E16)/ABS(E16)>S18,"ERROR","OKAY")		A	column-supported(cone)
20			Minimum Liquid Level:			='Calculation Details'!B20	ft		roof alpha:	=IF('Calculation Details'!B27="N",VLOOKUP('Calculation Details'!B26,SampleCalculation!$O$5:$T$16,4,FALSE),IF('Calculation Details'!B27="Ag",VLOOKUP('Calculation Details'!B26,SampleCalculation!$O$5:$T$16,5,FALSE),VLOOKUP('Calculation Details'!B26,SampleCalculation!$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'!B5,SampleCalculation!S19:T24,2,FALSE)				effective roof height:	=IF('Calculation Details'!B5="A",('Calculation Details'!B13('Calculation Details'!B11/2)/12)/3,IF('Calculation Details'!B5="B",'Calculation Details'!B16/2+(2'Calculation Details'!B16^3)/(3*SampleCalculation!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'!E33="",F23,E18+J22+'Calculation Details'!B15/3+'Calculation Details'!B19-'Calculation Details'!E33)	ft			Average Hvo	='Calculation Details'!B23	=IF(F23<>0,IF(ABS(P23-F23)/ABS(F23)>S18,"ERROR","OKAY"),IF(P23<>F23,"ERROR","OKAY"))
24			Max Vent Setting:			='Calculation Details'!B30	psig							Hvo	='Calculation Details'!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'!B29	psig
26		Service Data:
27			Service (stored liquid):			='Calculation Details'!E5								Tb	='Calculation Details'!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'!E9					Vapor Pressure Constants:
29			Reid VaporPressure:			=IF('Calculation Details'!E8=0,"",'Calculation Details'!E8)	psi	(if specified)			A:	=IF('Calculation Details'!E13=0,"",'Calculation Details'!E13)
30			ASTM Distillation Slope:			=IF('Calculation Details'!H29=0,"",'Calculation Details'!H29)		(if specified)			B:	=IF('Calculation Details'!E14=0,"",'Calculation Details'!E14)
31			Molecular Weight, MV:			='Calculation Details'!E7	lb/lb-mol				C:	=IF('Calculation Details'!E15=0,"",'Calculation Details'!E15)		Tla	='Calculation Details'!E28	=IF(F35<>0,IF(ABS(P31-F35)/ABS(F35)>S18,"ERROR","OKAY"),IF(P31<>F35,"ERROR","OKAY"))
32			Liquid Bulk Temp, Tb:			=TempCal!B2	degrees F
33			Constant Temp Tank?			=IF('Calculation Details'!B9="F","YES","NO")		tank must be insulated for temperature to be constant
34			Liquid Bulk Temp Basis?			=IF('Calculation Details'!H41=FALSE,"calculated from ambient, per AP-42 equation 1-31","given by user")								Wv	='Calculation Details'!E17	=IF(F37<>0,IF(ABS(P34-F37)/ABS(F37)>S18,"ERROR","OKAY"),IF(P34<>F37,"ERROR","OKAY"))
35			Liquid Surface Temp, Tla:			=TempCal!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'!E16,IF(AND(CELL("type",F29)="v",'Calculation Details'!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'!E15)=FALSE,(10^('Calculation Details'!E13-('Calculation Details'!E14/((F35-32)*(5/9)+'Calculation Details'!E15))))/51.7144,EXP('Calculation Details'!E13-('Calculation Details'!E14/(F35+459.67)))))))))	psia		per AP-42 equation 1-24, 1-25, 1-26
37			Stock Vapor Density, WV:			=TempCal!B6	lb/ft3		per AP-42 equation 1-22					Tv	='Calculation Details'!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!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'!H35=-1,"",'Calculation Details'!H35)	degrees F
40			Min Liquid Bulk Temp:			=IF('Calculation Details'!H34=-1,"",'Calculation Details'!H34)	degrees F
41			Heating cycle frequency:			=IF('Calculation Details'!H36=-1,"",'Calculation Details'!H36)	days
42		Operational Data:
43			Throughput:		='Calculation Details'!E35		bbl per	=IF(AND(F44>27,F44<32,DAY('Calculation Details'!B2)=1,DAY('Calculation Details'!B3)=1),"month",IF(OR(F44=365,F44=366),"year","this period"))
44			Days this Period:			='Calculation Details'!B3-'Calculation Details'!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!B5	deg F (deg R); daily temperature range in the vapor space						AP-42 eqn 1-6, 1-7, 1-8			∆TV	='Calculation Details'!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'!H33,IF(AND(CELL("type",F29)="v",'Calculation Details'!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'!E15)=FALSE,(10^('Calculation Details'!E13-('Calculation Details'!E14/((E51-32)*(5/9)+'Calculation Details'!E15))))/51.7144,EXP('Calculation Details'!E13-('Calculation Details'!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'!H32,IF(AND(CELL("type",F29)="v",'Calculation Details'!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'!E15)=FALSE,(10^('Calculation Details'!E13-('Calculation Details'!E14/((E52-32)*(5/9)+'Calculation Details'!E15))))/51.7144,EXP('Calculation Details'!E13-('Calculation Details'!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'!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'!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'!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'!E39	=IF(D65<>0,IF(ABS(P65-D65)/ABS(D65)>S18,"ERROR","OKAY"),IF(P65<>D65,"ERROR","OKAY"))
66			Control Effi=	='Calculation Details'!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'!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'!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!P69+SampleCalculation!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'!H46)	lb per	=H$43		with fugitive				Standing Storage Loss (w ctrl)	='Calculation Details'!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'!H46)	lb per	=H$43		with fugitive				Working Loss (w ctrl)	='Calculation Details'!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'!H46)	lb per	=H$43		with fugitive				Total Emissions (w ctrl)	='Calculation Details'!H25
76						=F72(1-D66'Calculation Details'!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