1

Airport Deicing Costing Database Dictionary 

The database cost model calculates volume of water impacted by ADF, and costs associated with both collection and 

treatment of the water. Detailed table and query information for the costing database is provided in Tables 1 and 2. 

Descriptions and values of factors used throughout the database are provided in Table 3. Inputs into the database 

compare the current ADF percent capture by airport and, if the percent capture is not sufficient to achieve the 

targeted capture efficiency, then the database cost model estimates costs to either increase the capture efficiency of 

the existing system or replace the existing system with a new system (e.g., replace block and pump capture with 

centralized deicing pads). 

Using the information on the target percent capture and the annual volume of ADF applied, the model estimates the 

annual volume of ADF impacted stormwater that must be treated on-site by the selected technology or transferred 

off-site for recycle/recovery or POTW treatment. The basic equation to determine the volume of ADF stormwater is 

shown below = 

ADF Impacted Stormwater (gal/yr) = Volume ADF Applied (gal/yr) x Capture % x 1/(% ADF in Stormwater) 

The volume of ADF applied is determined from the survey on an airport specific basis. The percent capture is 

dependant on the type of collection system. For GRVs only, capture is expected to be 20%. For block and pump in 

conjunction with GRVs collection efficiency is expected to be 40%. The percentage of ADF in stormwater has been 

determined from survey provided data. The data indicates that when airports focus on collecting spent ADF from 

application areas, the glycol concentration is approximately 10%. 

The database cost model also calculates the volume of stormwater with potential ADF contamination for a number 

of areas around the airport, including paved areas (gates, aprons, taxi-ways, runways, deicing pads, etc) and grass 

areas, and entire drainage areas. The concentration of ADF in stormwater collected from these areas is expected to 

be significantly less than 10% as indicated for the control areas. These areas are expected to have ADF 

concentrations less than 0.5% (i.e., medium strength stormwater). Flow data from these volume estimates is used to 

size and cost containment equipment such as tanks and ponds. Tanks and ponds are used for temporary storage 

prior to on-site treatment, off-site recycle and recovery, or off-site treatment at a POTW. 

The equation below shows the approach for calculating the volume of “medium strength” ADF impacted stormwater 

that may require collection and treatment. In general, the model estimates the total volume of ADF impacted 

stormwater, and subtracts the volume currently being discharged to a POTW for treatment, or to on-site containment 

and treatment systems. The volume of ADF contaminated stormwater being sent to a POTW or to on-site 

containment and treatment systems was determined from the Airport survey information. 

CalcVolADF (Col R) = [TotalVolADF]-[POTWVolume]-[OtherVolume]-([OtherVolume]/[SOFPDays]) 

The total volume of ADF contaminated stormwater [TotalVolADF] was calculated by two methods. The first 

method used the drainage areas reported in the Airport survey, precipitation data, and runoff coefficients for paved 

[PARC] and unpaved [UPARC] to estimate total volume of stormwater. The second method uses the precipitation 

information and runoff coefficients, but estimates the area where ADF contamination is likely to occur using a 

relationship between runway area the gate and apron areas, centralized deicing pads, runways and taxi-ways. For 

the first method which estimates the total volume of ADF contaminated stormwater [TotalVolADF] based on the 

ADF total drainage area from the survey, the following equation is used = 

TotalVolADFAirport = [TotalAreaReported]*(([PARC]+[UPARC])/2)*([ Precip During Deicing 

Months (in)]/12)* [GALperSF] 

For the second method using the relationship to runway area, the model uses the following equation to calculate the 

total volume [TotalVolADF] of ADF contaminated stormwater : 
2

TotalVolADF (Col M) = (([TotalRunwayArea]*[PARC]*[Total Precip During Deicing Months 

(inches)]/12)+([TotalTaxiwayArea]*[PARC]*[Total Precip During Deicing Months 

(inches)]/12)+([TotalPavedApronGateArea]*[PARC]*[Total Precip During Deicing Months 

(inches)]/12)+([TotalGrassArea]*[UPARC]*[Total Precip During Deicing Months 

(inches)]/12))*[GALperSF] 

For both methods above, the following equation are used to estimate the volumes of stormwater being discharged to 

the POTW and the volume of stormwater being discharged to other destinations such as on-site treatment. 

POTWVolume (Col O) = Sum(IIf([DestMeth]<>'POTW',0,IIf(Q36.Volume=-999 Or Q36.Volume=-

555,0,Q36.Volume))) 

 -- Sums Volume by Airport for those where destination method is not POTW and Volume is valid 

(not -555 or -999). 

OtherVolume (Col P) = Sum(IIf([DestMeth]='POTW' Or [DestMeth]='SFW',0,IIf(Q36.Volume=-999 

Or Q36.Volume=-555,0,Q36.Volume))) 

-- Sums Volume by Airport for those where destination method is POTW or SFW and Volume is 

valid (not -555 or -999).

SOFPDays = Airport-specific value 
Table 1. Tables in the Airport Deicing Costing Database 

Table Name Table Contents Table Data Source 

ADF Usage for Loads ADF Usage for each airport Links to P:\Airport Deicing\Preliminary Cos

Info\Airline ADF Usage Data\Airline Usage 

Airport Land Use Percentage 

Percentage of area used for operations at airport. Links to P:\Airport Deicing\Preliminary Cos

Info\Loads\Flows\Airport Land Use\ NFDC

Airport Percent Capture Existing percent capture for each airport Links to P:\Airport Deicing\Preliminary Cos

Info\Loads\Loads Database\Airport Deicing 

Airport ID Master list of airports with ID, state, code (153) Links to P:\Airport Deicing\Preliminary Cos

Info\Loads\Flows\Airport Land Use\ NFDC

Airport_Ranked Total departures, survey weight, and SOFP days 

for each airport 

Links to P:\Airport Deicing\Preliminary CosInfo\Airline ADF Usage Data\Airline Usage 

Deicing_Precip Precipitation during deicing months, by airport. Links to P:\Airport Deicing\Preliminary Cos

Info\Loads\Flows\Precipitation Data\ Precip

factors Value of all of the various factors used in the 

flow & cost calculation queries (see Table 3 for values). 

P:\Airport Deicing\Preliminary Cost_LoadinInfo\Costs\Costing Database\Costing MemoWorkbook_AUG3_MJB.xls 

NFDC Data Detailed data on airports. Primarily used to map 

to NfdcRunways table. 

Links to P:\Airport Deicing\Preliminary CosInfo\Loads\Flows\Airport Land Use\

NFDCRunway_Data.mdb 

NfdcRunways Detailed data on runways by airport, e.g., runway 

length, width. 

Links to P:\Airport Deicing\Preliminary CosInfo\Loads\Flows\Airport Land Use\

NFDCRunway_Data.mdb 

options Lists cost options with number, % capture 

threshold, associated technology, and associated technology query name 

Created for options 

Q1-11b Responses from survey production database = 

number of deicing outfalls. 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Q11d_f-12_15a Response from survey production database = 

Does facility have SWPPP 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P
Table 1 (Continued). Tables in the Airport Deicing Costing Database 

Table Name Table Contents Table Data Source 

Q11e Responses from survey production database Links to P:\Airport Deicing\Survey 

Database\Airport\DENTRY\DATABASE\P

Q20-23 Responses from survey production database = 

average of days of deicing per year for last 3 years. 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Q32_34-35 Responses from survey production database = 

discharge of deicing stormwater 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Q33 Responses from survey production database = 

methods used to discharge deicing stormwater 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Q36 Responses from survey production database = 

annual average volume of deicing stormwater stream 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Q49 Responses from survey production database = 

O&M costs. 

Links to P:\Airport Deicing\Survey Database\Airport\DENTRY\DATABASE\P

Top Airports Lists Ids for top 55 airports. Links to P:\Airport Deicing\Preliminary Cos

Info\Loads\Flows\Airport Land Use\ NFDC
Table 2. Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation determines the runway area for each runway at the airport using published length and width data. 

01 - Step 1a Calc Runway Area 

Calculates runway area RunwayArea = [RunwayLength]* 

[RunwayWidth] 

 T T T

This calculation sums the total runway area for each airport 

02 - Step 1b Calc Total Runway Area 

Sums runway area by airport . 

∑ (RunwayArea)  Q

R

This calculation uses the relationship between taxiway area, gate/apron area and grass area to runway area. The relationship was developed based on a Google Earth survey of 6 large airports that perform deicing operations. 

03 - Step 2 Calc Other Total Areas 

Calculates total taxiway area, total paved apron gate area, and total grass area. 

TotalTaxiwayArea = [TotalRunwayArea]*[TatoR] TotalPavedApronGateArea = [TotalRunwayArea]*[PAtoR] TotalGrassArea = [TotalRunwayArea]*[GAtoR] 

 T Q

R

This calculation uses the total area reported in the Airport Survey to estimate total area with the potential to have aircraft deicing fluid. 

04 - Step 3 Total Area Reported 

Calculates total area reported in survey. 

TotalAreaReported = Sum(IIf([Catchment]=-555,0,IIf([Catchment]=-999,0,[Catchment]*[ACperSF]))) 

 T T

This calculation determines the volume of ADF impacted stormwater that is currently being discharged to a POTW for either aerobic or anaerobic treatment. Data is derived from the Airport Survey. 

05 - Step 4 Calc Q36 POTW Volume 

Sums POTW volumes reported in survey. 

POTWVolume - Sum(IIf([DestMeth]<>'POTW',0,IIf(Q36.Volume=-999 Or Q36.Volume=-555,0,Q36.Volume))) 

 T
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation determines the volume of water that is being sent off-site for recycle/recovery or some other method of disposal, other than POTW. 

06 - Step 5 Calc Q36 Other Dest Method Volume 

Sums non-POTW volumes reported in survey. 

OtherVolume = Sum(IIf([DestMeth]='POTW' Or [DestMeth]='SFW',0,IIf(Q36.Volume=-999 Or Q36.Volume=-555,0,Q36.Volume))) 

 T

This calculation estimates the total volume of ADF impacted storm water using the relationship between total runway area, the relationship between taxiway, apron/gate, and grass areas, annual precipitation data, and runoff coefficients. 

07 - Step 6 Est Total Vol ADF Stormwater 

Estimates total volume of ADFcontaminated stormwater TotalVolADF = (([TotalRunwayArea]*[PARC]* 

[Precip During Deicing Months (in)]/12)+([TotalTaxiwayArea]*[PARC]*[ Precip During Deicing Months (in)]/12)+ ([TotalPavedApronGateArea]* [PARC]*[ Precip During Deicing Months (in)]/12)+ ([TotalGrassArea]* [UPARC]* [Precip During Deicing Months (in)]/12))* [GALperSF] 

 T T T Q

R

 Q

T

This calculation estimates the total volume of ADF impacted stormwater based on the total drainage area reported in the Airport Survey, precipitation data and runoff coefficients. 

08 - Step 7 Est Total Vol ADF Stormwater Entire Airport 

Estimates total volume of ADFcontaminated stormwater for entire airport 

TotalVolADFAirport = [TotalAreaReported]*[ACperSF]*(([PARC]+[UPARC])/2)*([ Precip During Deicing Months (in)]/12)*[GALperSF] 

 T T T Q

R
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation determines the total volume of ADF impacted stormwater leaving the airport based on the areas most likely to contain high concentrations of fluid (i.e, gates/aprons, taxiways, runways). The calculation subtracts ADF impacted stormwater that is being discharged to either a POTW or being recycled off-site. 

09 - Step 8 Calc Total Vol ADF Released 

Calculates potential volume of water released to surface water with potential ADF contamination from runways, taxiways and gates. 

CalcVolADFAirport = [TotalVolADFAirport]-[POTWVolume]-[OtherVolume]-([OtherVolume]/[SOFPDays]) 

 T T

D

 Q

P

 Q

O

 Q

V

This calculation determines the total volume of ADF impacted stormwater leaving the airport based the drainage area in the survey. The calculation subtracts ADF impacted stormwater that is being discharged to either a POTW or being recycled off-site. 

10 - Step 9 Calc Total Vol ADF Released Entire Airport 

Calculates potential volume of water released to surface water with potential ADF contamination from entire airport 

CalcVolADFAirport = [TotalVolADFAirport]-[POTWVolume]-[OtherVolume]-([OtherVolume]/[SOFPDays]) 

 T T

D

 Q

P

 Q

O

 Q

VA

This calculation sums the amount of fuel used at each airport. 

Airport ADF Usage Calculates the amount of fuel 

used. 

TotalPG/EG = Sum([TYPE1(gallons)]+ [TYPE4(gallons)]) 

 T
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation estimates the number of days each airport performs deicing each year based on the previous 3 years of data reported in the Airport Survey. 

Average Deicing Days Averages the number of deicing 

days reported for the last three years for each airport. 

CountDeicingMonths = IIf([Jan]=True,1,0)+IIf([Feb]=True,1,0)+IIf([Mar]=True,1,0)+IIf([Apr]=True,1,0)+IIf([May]=True,1,0)+IIf([Jun]=True,1,0)+IIf([Jul]=True,1,0)+IIf([Aug]=True,1,0)+IIf([Sep]=True,1,0)+IIf([Oct]=True,1,0)+IIf([Nov]=True,1,0)+IIf([Dec]=True,1,0) AvgDeiceDays: [CountDeicingMonths]*30 

 T
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation determines the installed capital cost and the annual operating and maintenance cost for an anaerobic fluid bed reactor to treat ADF contaminated runoff. The calculation uses the annual amount of deicing fluid applied and the estimated capture efficiency of the selected technology (i.e., 20% capture for GRVs, 40% for block and pump) to determine the amount of fluid that will be treated. Using the amount of deicing COD for deicing fluid, the and the number of months deicing occurs at each airport, the model estimates the COD loading to the AFB and the AFB cost factor to determine the installed costs. Cost factors are based on the updated AFB Cost Memo (Aug 2010). 

Cost - AFB Costs Calculates capital and annual 

O&M costs associated with anaerobic fluid bed treatment. 

AFB_LandCost: [AFB_LandSqft]* [LandSqftCost] AFBComplianceCost = ([days/week]*[weeks/year]* [AFB_ComplianceCost/Sample])+([AFB_ComplianceCostSampleHrs]*[MonitoringLabor/hr]) AFB_GRVCapCost = [TotalPG/EG]*[ADF_COD]* ([CSCE_GRV]/100)* (1/([CountDeicingMonths]*30))*[ [TotalPG/EG]*[ADF_COD]* ([CSCE_GRV]/100)* (1/([CountDeicingMonths]*30)]-

0.6279 * 275,101 

AFB_BlockPumpCapCost = [TotalPG/EG]* [ADF_COD]* ([CSCE_BlockPump]/100)* (1/([CountDeicingMonths]*30))* [[TotalPG/EG]* [ADF_COD]* ([CSCE_BlockPump]/100)* (1/([CountDeicingMonths]*30)]-

0.6279 * 275,101 

AFB_GRVAnnCost = [TotalPG/EG]*([CSCE_GRV]/100)* [AFB_AnnCostFactor]+ [AFBComplianceCost]+ [AFB_LandCost] 

 T T Q Q

ChanLandboth Tank Whe([CS(1/([CequaM. Bequa
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Cost - AFB Costs (con't) AFB_BlockPumpAnnCost = 

[TotalPG/EG]* ([CSCE_BlockPump]/100)* [AFB_AnnCostFactor]+ [AFBComplianceCost]+ [AFB_LandCost] AFB_BlockPump_POTWAnnCost = [AFB_POTWAnnCostFactor]* [TotalPG/EG]* ([CSCE_BlockPump]/100)* (1/[ADF_BlockPump])+ [AFBComplianceCost] ADF_operating_days: Iff(IsNull([ADF_avg_operating_days]),IIf([CountDeicingMonth]=0,0,[CountDeicingMonths]*30),[ADF_avg_operating_days]) 

(see 
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

This calculation determines both the capital and operating costs for a block and pump collection system. Costs include GRVs plus the sewer balloons, diversion valves and temporary storage (frac tanks) for material removed from blocked storm drains. Costs for each airport to implement block and pump are dependant on the number of deicing outfalls reported in the Airport survey. 

Cost - BlockPump Costs Calculates capital and annual 

O&M costs associated with a block & pump collection system. 

BlockPumpCapCost = [BlockPumpCapCostFactor]* [NumDeice] BlockPumpAnnCost = [BlockPumpAnnCostFactor]* [NumDeice] 

 T T

 Cost - GRV Costs Calculates capital and annual 

O&M costs associated with GRVs. 

NumGRV=IIf([Hub]="L",3,2) GRVCapCost = [GRVCapCostFactor]* [NumGRV] GRVAnnCost = [GRVAnnCostFactor]* [NumGRV] * 1.2 

 T T T T

Wheaccouinsta
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Cost - Minimal Deicing Calculates annual O&M costs 

for airports with minimal deicing operations. 

MinDeicingCapCost = 0 MinDeicingAnnCost = IIf([MinDeicing]=0,0,([TotalPG/EG]*[MinimalDeicingCostFactor]*[AirplaneRunoffFactor]*[MinimalDeicingCaptureEfficiency])+([VacuumTruckCostFactor]*IIf([SOFPDays]<1,1,[SOFPDays]))) 

 T T

D

 T Q Q

D

This calculation estimates the capital cost for an airport to assess operations for design of the proper system and develop an operations plan for winter training on the system. 

Cost - Winter Operations Plan 

Estimates capital costs to develop an operations plan for winter training. 

GRV_WinterOpsCost: [EngineerHourlyCost]*IIf([Hub]="L",200,120) BlockPump_WinterOpsCost: [EngineerHourlyCost]*IIf([Hub]="L",400,240) 

 T T T

This calculation estimates costs for an airport to contract haul additional ADF stormwater to an offsite glycol recovery facility. This equation applied to those airports that are currently contract hauling offsite for glycol recovery and assumes the airport would continue to do the same even if required to collect additional ADF stormwater to achieve 40% capture. 

Costs - Offsite Glycol Recovery Costs 

Calculates incremental annual costs for an airport to contract haul additional ADF collected if replace GRV with block and pump. 

OffsiteGlycol_GRVAnnCost = [TotalPG/EG]* ([CSCE_GRV] – [Airport Percent Capture])* [OffsiteGlycolAnnCostFactor] OffsiteGlycol_BlockPumpAnn Cost = [TotalPG/EG]* ([CSCE_BlockPump] – [Airport Percent Capture])* [OffsiteGlycolAnnCostFactor] 

 T T Q Q

Offsibe 4.
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

Calculates the capital and O&M costs for additional stormwater piping. Assume 10,000 ft of additional piping is required. 

Cost - Piping Costs Calculates the capital and O&M 

costs for additional stormwater piping from collection points to AFB or POTW discharge. 

PipingCapCost: PipingCapCostFactor PipingAnnCost: PipingAnnCostFactor 

 T T

Calculates annual O&M costs associated with POTW disposal for collected ADF stormwater. 

Cost - POTW Annual Costs Calculates annual O&M costs 

associated with POTW disposal for collected ADF stormwater. 

POTW_GRVAnnCost = [TotalPG/EG]* ([CSCE_GRV]/100)* (1/([POTW_glycol]/100))* [POTWAnnCostFactor] POTW_BlockPumpAnnCost = [TotalPG/EG]* ([CSCE_BlockPump]/100)* (1/([POTW_glycol]/100))* [POTWAnnCostFactor] 

 T T Q Q

Calculates the capital and O&M costs for storage tank used for concentrated ADF stormwater collected from GRVs and block and pump systems. 

Cost - Storage Tank Costs Calculates the capital and O&M 

costs for storage tank used for concentrated ADF stormwater collected from GRVs and block and pump systems. 

TankCapCost: [TotalPG/EG]*[Storage_GalFactor]*[Storage_CapCostFactor] TankAnnCost: TankAnnCost = ([TotalPG/EG]*[Storage_AnnCostFactor])+(1.2*[TotalPg/EG]*([Storage_GalFactor]*[SqftPerGal])*[LandSqftCost]) 

 T T Q

 Facility BlockPump Step 1 Lists unique list of airport IDs 

that have a block and pump system in place (based on response to Q33). 

[Block]=True  T
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Facility BlockPump Step 2 Lists all airport IDs with an 

indicator of whether or not airport has a block and pump system in place. 

HaveBlockPump = IIf(IsNull([Facility BlockPump Step 1].[AirportID]),0,-1) 

 T Q

 Facility GRV Step 1 Lists unique list of airport IDs 

that have a GRV system in place (based on response to Q33). 

[GlycolRec]=True  T

 Facility GRV Step 2 Lists all airport IDs with an 

indicator of whether or not airport has a GRV system in place. 

HaveGRV = IIf(IsNull([Facility GRV Step 1].[AirportID]),0,-1) 

 T Q

 Facility Minimal Deicing Lists of airport IDs for small 

airports that are costed for doing "minimal deicing" 

[TotalPG/EG]<>0 [CountDeicingMonths]=0 [Q36.DestMeth]='SFW' [Q36.Volume]<>0 [PercentCapture]<100 

 T T T Q Q

 Facility Minimal Deicing 2 MinDeicing = IIf(IsNull([Facility 

Minimal Deicing].[Airport ID]),0,-1) 

 T Q

D

 Facility OffGlycol Lists airport IDs that perform 

contract hauling (based on response to Q36) 

[DestMeth]='OFFGLYCOL'  T

 T

 Facility Tanks Step 1 Lists unique list of airport IDs 

that have storage tanks (based on response to Q33). 

[Tank]=True  T

 Facility Tanks Step 2 Lists all airport IDs with an 

indicator of whether or not airport has tanks in place. 

HaveTanks = IIf(IsNull([Facility Tanks Step 1].[AirportID]),0,-1) 

 T Q
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Facility Zero Cost List of airport IDs that should 

not be costed. 

(SOFPDays=0 and CountDeicingMonths<>0 and TotalPG/EG=0) OR TotalPG/EG=0 

 T

D

 Q Q

 Option Costs - append XX 

to output table 

Series of queries used to create costing output. 

The option cost queries listed below use the various calculations to estimate costs for airports that have no collection or treatment in place. Thcollection (GRVs, block and pump, and deicing pads with a holding tank and piping) and all control options (anaerobic fluid beds, UF/RO, evPOTW for anaerobic treatment, off-site discharge to POTW for aerobic treatment, contract haul to an off-site recycle facility).Note that each calculated cost is scaled according to airport's existing technologies (within an option, airport is scaled if already using associaOption1aCapCost = IIf([HaveGRV]=-1 and [PercentCapture]>0,[Option1aCapCost_calc]*([option_threshold]/[PercentCapture]),[Option1aCBecause this methodology is the same for each option, it is not repeated below in order to save space. Option Costs - Option 1 

Airports 

Provides a list of airports to be costed under Option 1. 

[PercentCapture]< 20 and [AirportID] Not In Facility [Facility OffGlycol] special_cost: IIf(IsNull([Facility Minimal Deicing].[Airport ID]), IIf(IsNull([Facility Zero Cost].[Airport ID]), Null,"zero"),"min") HaveOffGlycol: IIf(IsNull([Facility OffGlycol].AirportID),0,-1) 

 T Q Q

D

 Q Q
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Option Costs - Option 1a Estimates capital costs for 

airports to purchase GRVs, a collection tank, piping and an anaerobic fluid bed treatment system; and Estimates annual operating costs for airports to operate GRVs, a collection tank, and an anaerobic fluid bed treatment system. Costs for airports designated as "zero cost" are set to 0. Costs for airports designated as "min" are set to the minimal deicing cost. Remaining airports are costed as shown. 

Option1aCapCost_calc = [GRVCapCost]+[TankCapCost]+[PipingCapCost]+[AFB_GRVCapCost]+[GRV_WinterOpsPlanCost] Option1aAnnCost_calc = [GRVAnnCost]+[TankAnnCost]+[AFB_GRVAnnCost]+ [PipingAnnCost] 

 Q Q Q Q

D

 Q Q

C

 Q

O

 Q
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Option Costs - Option 1b Estimates capital costs for 

airports to purchase GRVs, a collection tank and piping. Estimates O&M costs for airports with GRVs to send wastewater to POTW. Costs for airports designated as "zero cost" are set to 0. Costs for airports designated as "min" are set to the minimal deicing cost. Remaining airports are costed as shown. 

Option1bCapCost_calc: [GRV_CapCost]+ [TankCapCost] + [PipingCapCost]+ [GRV_WinterOpsPlanCost] Option1bAnnCost_calc: [GRV_AnnCost]+[TankAnnCost]+[PipingAnnCost]+ [POTW_GRVAnnCost] 

 Q Q Q

D

 Q Q

C

 Q

C

 Q

O

 Q

 Option Costs - Option 2 

Airports 

Provides a list of airports to be costed under Option 2. 

[PercentCapture]<40 and [AirportID] Not In [Facility OffGlycol] Special_cost: IIf(IsNull([Facility Minimal Deicing].[Airport ID]),IIf(IsNull([Facility Zero Cost].[Airport ID]),Null"zero"),"min") HaveOffGlycol: IIf(IsNull([Facility OffGlycol].AirportID),0,-1) 

 T Q Q Q

D

 Q
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Option Costs - Option 2a Estimates costs for airports to 

install and operate block and pump, a collection tank, piping and an anaerobic fluid bed treatment system. Costs for airports designated as "zero cost" are set to 0. Costs for airports designated as "min" are set to the minimal deicing cost. Remaining airports are costed as shown. 

Option2aCapCost_calc = [BlockPumpCapCost]+ [TankCapCost] + [PipingCost]+ [AFB_BlockPumpCapCost]+ [BlockPump_WinterOpsPlanCost] Option2aAnnCost_calc = [BlockPumpAnnCost]+ [TankAnnCost]+ [AFB_BlockPumpAnnCost]+ [PipingAnnCost] 

 T

D

 Q

2 

 Q Q

C

 Q Q

C

 Q

O

 Q Q Q

 Option Costs - Option2b Estimates capital costs for 

airports to install and operate block and pump, a collection tank and piping. Estimates O&M costs for airports with block and pump to send wastewater to POTW. Costs for airports designated as "zero cost" are set to 0. Costs for airports designated as "min" are set to the minimal deicing cost. Remaining airports are costed as shown. 

Option2bCapCost_calc: [BlockPumpCapCost]+ [TankCapCost] + [PipingCapCost]+ [BlockPump_WinterOpsPlanCost] Option2bAnnCost_calc: [BlockPumpAnnCost]+[TankAnnCost]+[PipingAnnCost]+ [POTW_BlockPumpAnnCost] 

 Q Q

C

 Q

D

 Q Q

C

 Q

C

 Q

O

 Q Q Q
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 Option Costs - Output Ann 

Cost Crosstab 

Generates a crosstab of annual operating costs. Used to create output. 

 Option Costs - Output Cap 

Cost Crosstab 

Generates a crosstab of capital costs. Used to create output. 

 output_flowcalcs Used for internal QC, presents 

all flow values calculated by numbered flow queries (see above). Output emulates 'All Flow Calculation' sheet in Flow Calcs Workbook_AUG3_MJB .xls. 

Othervolume_gpd = [OtherVolume]* [SOFP Days] 

 T T

U

 T T Q

R

 Q

R

 Q

T

 Q

R

 Q

P

 Q

O

 Q

V

 Q

VA

 Q

V

 Q

VA
Table 2 (Continued). Queries in the Airport Deicing Costing Database 

Calculation Description Query Name Query Function Query Calculations 

 output_treatment_ 

technologies 

Used for internal QC, presents all treatment technology costs calculated costing queries (see above). 

NA  T

 Q Q

C

 Q

C

 Q

(

 Q ( Q

C

 Q

(

 Q

(
Table 3. Factors Used in the Airport Deicing Costing Database 

Factor Code Factor Description Factor Value Useacre/sf Acres per square feet 43,560 04 - Step 3 Total Are

08 - Step 7 Est Total Entire Airport Cost - Pond and PipinOption Costs - All Ai

AFB_LandSqFt Amount of Land for an AFB. 2.4 acres times 

43,560 sq. ft. per acre = 104,544 sq. ft 

104,544 Cost - AFB Costs 

ADF_BlockPump Percent ADF from block & pump systems, used 

to calculate POTW treatment by anaerobic digestion from block & pump systems. 

10 Cost - AFB Costs 

Cost - POTW Anaero

ADF_COD ADF/COD conversion factor 14.28 Cost - AFB Costs 

Option Costs - All Ai

AFB_ComplianceCost/Sample Cost per sample for compliance monitoring 22 Costs - AFB Costs AFB_ComplianceCostSampleHrs Number of sample hours for compliance 

monitoring 

130 Costs - AFB Costs 

AFB_POTWAnnCostFactor Cost factor used to calculate POTW treatment 

by anaerobic digestion from block & pump and deicing pads. 

0.08 Cost - AFB Costs 

AFBAnnCostFactor Cost factor used to calculate annual O&M costs 

for anaerobic fluid bed treatment system 

4.9 Cost - AFB Costs 

Option Costs - All Ai

AirplaneRunoffFactor Cost factor used to represent the amount of 

deicing materials that drips off an airplane onto the pad for collection. 

0.8 Cost - Minimal Deici

BlockPumpAnnCostFactor Cost factor used to calculate annual O&M costs 

for block & pump collection system 

260,000 Cost - BlockPump Co

BlockPumpCapCostFactor Cost factor used to calculate capital costs for 

block & pump collection system 

263,400 Cost - AFB Costs 

Cost - BlockPump CoCost - Evap Costs 

CostForCODRemoval -0.6279 Cost - AFB Costs 
Table 3 (Continued). Factors Used in the Airport Deicing Costing Database 

Factor Code Factor Description Factor Value UseCostForCODRemoval2 275,101 Cost - AFB Costs CSCE_BlockPump Collection system capture efficiency, when used 

in conjunction with block & pump collection system 

40 Cost - AFB Costs 

Cost - Evap Costs Cost - Offsite Glycol Cost - POTW AnaeroCost - POTW AnnuaCost - UFRO Costs 

CSCE_GRV Collection system capture efficiency, when used 

in conjunction with GRV system 

20 Cost - AFB Costs 

Cost - Evap Costs Cost - Offsite Glycol Cost - POTW AnnuaCost - UFRO Costs 

daysSampled/week Days sampled per week 5 Cost - AFB Costs EngineerHourlyCost 100 gal/sf Square feet to gallons conversion factor 7.48 07 - Step 6 Est Total 

08 - Step 7 Est Total Entire Airport 

GrassyAreaToRunway Grassy area to runway conversion factor 2.356928 03 - Step 2 Calc OtheGRVAnnCostFactor Cost factor used to calculate annual O&M costs 

for GRV system 

56,986 Cost - GRV Costs 

GRVCapCostFactor Cost factor used to calculate capital costs for 

GRV system 

344,238 Cost - GRV Costs 

LandSqftCost 1 MinimalDeicingCaptureEfficiency Capture efficiency value used to calculate costs 

for airports with minimal deicing operations. 

0.2 Cost - Minimal Deici

MinimalDeicingCostFactor Cost factor used to calculate costs for airports 

with minimal deicing operations. 

1.83 Cost - Minimal Deici
Table 3 (Continued). Factors Used in the Airport Deicing Costing Database 

Factor Code Factor Description Factor Value UseMonitoringLabor/hr Assumed labor cost per hour for monitoring 33 Cost – AFB Costs OffsiteGlycolAnnCostFactor Cost factor used to calculate annual costs for 

off-site recycle and recovery of spent ADF. Costs include both hauling and treatment. 

4.88 Cost - Offsite Glycol 

PavedApronToRunway Paved apron to runway conversion factor 1.794712 03 - Step 2 Calc OthePavedAreaRunoffCoeff Paved area runoff coefficient 0.98 07 - Step 6 Est Total 

08 - Step 7 Est Total Entire Airport 

PipingCapCostFactor Cost factor used to calculate capital costs for 

stormwater piping. 

1,141,000 Cost - Piping Costs 

PipingAnnCostFactor 5,400 Cost - Piping Costs POTW_glycol Cost factor used to calculate annual O&M costs 

for medium-concentration equalization pond system with POTW discharge 

0.5 Cost - POTW Annua

POTWAnnCostFactor Cost factor used to calculate annual O&M costs 

for medium-concentration equalization pond system with POTW discharge 

0.01 Cost - POTW Annua

Storage_AnnCostFactor 0.27 Storage_CapCostFactor 1.67 Storage_GalFactor 13.1 Storage_LandSqft TankAllFlowAnnCostFactor Cost factor used to calculate annual O&M costs 

for collection. 

0.07 Option Costs - All Ai

TankCapCostFactor Cost factor used to calculate capital costs for 

storage tanks used for ADF stormwater collected from pad and block & pump systems. 

1.67 Cost - Storage Tank C

Option Costs - All Ai
Table 3 (Continued). Factors Used in the Airport Deicing Costing Database 

Factor Code Factor Description Factor Value UseTaxiToRunway Taxi to runway conversion factor 1.399511 03 - Step 2 Calc OtheUnpavedAreaRunoffCoeff Unpaved area runoff coefficient 0.8 07 - Step 6 Est Total 

08 - Step 7 Est Total Entire Airport 

VacuumTruckCostFactor Cost per day to vacuum spent ADF from 

concrete areas and contract haul and dispose of the spent ADF at a recycle facility. 

1,100 Cost - Minimal Deici

weeks/year Weeks per year 26 Cost - AFB Costs