# 1 Airport Deicing Costing Database Dictionary

The database cost model calculates volume of water impacted by ADF, and costs associat ed 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 da tabase cost model estimates costs to e ither increase the captu re efficiency of

the existing system or replace the ex isting 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 th e annual volume of ADF applie d, 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 percen tage 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-way s, 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 in dicated 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 da ta, 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 ga te and apron areas, centralized deici ng 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 AD F contaminated stormwater :

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

(inches)]/12)+([TotalTaxiw ayArea]*[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 destin ation method is POTW or SFW and Volume is

valid (not -555 or -999).

SOFPDays = Airport-specific valueTable 1. Tables in the Airport Deicing Costing DatabaseTable NameTable ContentsTable Data SourceADF Usage for Loads ADF Usage for each airport Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Airline ADF Usage Data\Airline Usage Data.mdbAirport Land UsePercentagePercentage of area used for operations at airport. Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Airport LandUse\ NFDCRunway_Data.mdbAirport Percent Capture Existing percent capture for each airport Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Loads Database\Airport Deicing Loads.mdbAirport ID Master list of airports with ID, state, code(153) Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Airport LandUse\ NFDCRunway_Data.mdbAirport_Ranked Total departures, survey weight, and SOFP daysfor each airportLinks to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Airline ADF Usage Data\Airline Usage Data.mdbDeicing_Precip Precipitation during deicing months, by airport. Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Precipitation Data\Precip_Data.mdbfactors Value of all of the various factors used in theflow & cost calculation queries (see Table 3 forvalues).P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Costs\Costing Database\Costing Memos\ Flow CalcsWorkbook_AUG3_MJB.xlsNFDC Data Detailed data on airports. Primarily used to mapto NfdcRunways table.Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Airport Land Use\NFDCRunway_Data.mdbNfdcRunways Detailed data on runways by airport, e.g., runwaylength, width.Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Airport Land Use\NFDCRunway_Data.mdboptions Lists cost options with number, % capturethreshold, associated technology, and associatedtechnology query nameCreated for optionsQ1-11b Responses from survey production database =number of deicing outfalls.Links to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ11d_f-12_15a Response from survey production database =Does facility have SWPPPLinks to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbTable 1 (Continued). Tables in the Airport Deicing Costing Database4Table NameTable ContentsTable Data SourceQ11e Responses from survey production database Links to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ20-23 Responses from survey production database =average of days of deicing per year for last 3years.Links to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ32_34-35 Responses from survey production database =discharge of deicing stormwaterLinks to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ33 Responses from survey production database =methods used to discharge deicing stormwaterLinks to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ36 Responses from survey production database =annual average volume of deicing stormwaterstreamLinks to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbQ49 Responses from survey production database =O&M costs.Links to P:\Airport Deicing\SurveyDatabase\Airport\DENTRY\DATABASE\Prod.mdbTop Airports Lists Ids for top 55 airports. Links to P:\Airport Deicing\Preliminary Cost_LoadingsInfo\Loads\Flows\Airport LandUse\ NFDCRunway_Data.mdbTable 2. Queries in the Airport Deicing Costing DatabaseCalculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation determinesthe runway area for eachrunway at the airport usingpublished length and widthdata.01 - Step 1a Calc RunwayAreaCalculates runway areaRunwayArea = [RunwayLength]*[RunwayWidth]TABLE: Airport_IDTABLE: NFDC DataTABLE: NfdcRunwaysThis calculation sums thetotal runway area for eachairport02 - Step 1b Calc TotalRunway AreaSums runway area by airport .∑(RunwayArea)QUERY: 01 - Step 1a CalcRunway AreaThis calculation uses therelationship betweentaxiway area, gate/apronarea and grass area torunway area. Therelationship was developedbased on a Google Earthsurvey of 6 large airportsthat perform deicingoperations.03 - Step 2 Calc Other TotalAreasCalculates total taxiway area,total paved apron gate area, andtotal grass area.TotalTaxiwayArea =[TotalRunwayArea]*[TatoR]TotalPavedApronGateArea =[TotalRunwayArea]*[PAtoR]TotalGrassArea =[TotalRunwayArea]*[GAtoR]TABLE: factorsQUERY: 02 - Step 1b Calc TotalRunway AreaThis calculation uses thetotal area reported in theAirport Survey to estimatetotal area with the potentialto have aircraft deicingfluid.04 - Step 3 Total AreaReportedCalculates total area reported insurvey.TotalAreaReported =Sum(IIf([Catchment]=-555,0,IIf([Catchment]=-999,0,[Catchment]*[ACperSF])))TABLE: factorsTABLE: Q11eThis calculation determinesthe volume of ADFimpacted stormwater that iscurrently being dischargedto a POTW for eitheraerobic or anaerobictreatment. Data is derivedfrom the Airport Survey.05 - Step 4 Calc Q36 POTWVolumeSums POTW volumes reportedin survey.POTWVolume -Sum(IIf([DestMeth]<>'POTW',0,IIf(Q36.Volume=-999 OrQ36.Volume=-555,0,Q36.Volume)))TABLE: Q36Table 2 (Continued). Queries in theAirport Deicing Costing Database6Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation determinesthe volume of water that isbeing sent off-site forrecycle/recovery or someother method of disposal,other than POTW.06 - Step 5 Calc Q36 OtherDest Method VolumeSums non-POTW volumesreported in survey.OtherVolume =Sum(IIf([DestMeth]='POTW' Or[DestMeth]='SFW',0,IIf(Q36.Volume=-999 Or Q36.Volume=-555,0,Q36.Volume)))TABLE: Q36This calculation estimatesthe total volume of ADFimpacted storm water usingthe relationship betweentotal runway area, therelationship betweentaxiway, apron/gate, andgrass areas, annualprecipitation data, andrunoff coefficients.07 - Step 6 Est Total VolADF StormwaterEstimates total volume of ADFcontaminated stormwaterTotalVolADF =(([TotalRunwayArea]*[PARC]*[Precip During Deicing Months(in)]/12)+([TotalTaxiwayArea]*[PARC]*[ Precip During DeicingMonths (in)]/12)+([TotalPavedApronGateArea]*[PARC]*[ Precip DuringDeicing Months (in)]/12)+([TotalGrassArea]* [UPARC]*[Precip During Deicing Months(in)]/12))* [GALperSF]TABLE: Airport IDTABLE: Decing_PrecipTABLE: factorsQUERY: 02 - Step 1b Calc TotalRunway AreaQUERY: 03 - Step 2 Calc OtherTotal AreasThis calculation estimatesthe total volume of ADFimpacted stormwater basedon the total drainage areareported in the AirportSurvey, precipitation dataand runoff coefficients.08 - Step 7 Est Total VolADF Stormwater EntireAirportEstimates total volume of ADFcontaminated stormwater forentire airportTotalVolADFAirport =[TotalAreaReported]*[ACperSF]*(([PARC]+[UPARC])/2)*([Precip During Deicing Months(in)]/12)*[GALperSF]TABLE: Airport IDTABLE: Decing_PrecipTABLE: factorsQUERY: 04 - Step 3 Total AreaReportedTable 2 (Continued). Queries in theAirport Deicing Costing Database7Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation determinesthe total volume of ADFimpacted stormwaterleaving the airport based onthe areas most likely tocontain high concentrationsof fluid (i.e, gates/aprons,taxiways, runways). Thecalculation subtracts ADFimpacted stormwater that isbeing discharged to either aPOTW or being recycledoff-site.09 - Step 8 Calc Total VolADF ReleasedCalculates potential volume ofwater released to surface waterwith potential ADFcontamination from runways,taxiways and gates.CalcVolADFAirport =[TotalVolADFAirport]-[POTWVolume]-[OtherVolume]-([OtherVolume]/[SOFPDays])TABLE: Airport IDTABLE: Airport SOFP Days &DeparturesQUERY: 05 - Step 4 Calc Q36POTW VolumeQUERY: 06 - Step 5 Calc Q36Other Dest Method VolumeQUERY: 07 - Step 6 Est TotalVol ADF StormwaterThis calculation determinesthe total volume of ADFimpacted stormwaterleaving the airport based thedrainage area in the survey.The calculation subtractsADF impacted stormwaterthat is being discharged toeither a POTW or beingrecycled off-site.10 - Step 9 Calc Total VolADF Released EntireAirportCalculates potential volume ofwater released to surface waterwith potential ADFcontamination from entireairportCalcVolADFAirport =[TotalVolADFAirport]-[POTWVolume]-[OtherVolume]-([OtherVolume]/[SOFPDays])TABLE: Airport IDTABLE: Airport SOFP Days &DeparturesQUERY: 05 - Step 4 Calc Q36POTW VolumeQUERY: 06 - Step 5 Calc Q36Other Dest Method VolumeQUERY: 08 - Step 7 Est TotalVol ADF Stormwater EntireAirportThis calculation sums theamount of fuel used at eachairport.Airport ADF Usage Calculates the amount of fuelused.TotalPG/EG =Sum([TYPE1(gallons)]+[TYPE4(gallons)])TABLE: ADF Usage for LoadsTable 2 (Continued). Queries in theAirport Deicing Costing Database8Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation estimatesthe number of days eachairport performs deicingeach year based on theprevious 3 years of datareported in the AirportSurvey.Average Deicing Days Averages the number of deicingdays reported for the last threeyears 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TABLE: Q20-23Table 2 (Continued). Queries in theAirport Deicing Costing Database9Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation determinesthe installed capital cost andthe annual operating andmaintenance cost for ananaerobic fluid bed reactorto treat ADF contaminatedrunoff. The calculation usesthe annual amount ofdeicing fluid applied and theestimated capture efficiencyof the selected technology(i.e., 20% capture for GRVs,40% for block and pump) todetermine the amount offluid that will be treated.Using the amount of deicingCOD for deicing fluid, theand the number of monthsdeicing occurs at eachairport, the model estimatesthe COD loading to the AFBand the AFB cost factor todetermine the installedcosts. Cost factors are basedon the updated AFB CostMemo (Aug 2010).Cost - AFB Costs Calculates capital and annualO&M costs associated withanaerobic 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,101AFB_BlockPumpCapCost =[TotalPG/EG]* [ADF_COD]*([CSCE_BlockPump]/100)*(1/([CountDeicingMonths]*30))*[[TotalPG/EG]* [ADF_COD]*([CSCE_BlockPump]/100)*(1/([CountDeicingMonths]*30)]-0.6279* 275,101AFB_GRVAnnCost =[TotalPG/EG]*([CSCE_GRV]/100)* [AFB_AnnCostFactor]+[AFBComplianceCost]+[AFB_LandCost]TABLE: Airport IDTABLE: factorsQUERY: Airport ADF UsageQUERY: Average Deicing DaysChange AFB_LandSqftCost to justLandSqftCost since we will use itboth for AFB module and the StorageTank moduleWhere [TotalPG/EG]*[ADF_COD]*([CSCE_GRV]/100)*(1/([CountDeicingMonths]*30)) isequal to the Avg. COD Loading. SeeM. Briggs AFB memo for theequations if needed.Table 2 (Continued). Queries in theAirport Deicing Costing Database10Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesCost - 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 above)Table 2 (Continued). Queries in theAirport Deicing Costing Database11Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesThis calculation determinesboth the capital andoperating costs for a blockand pump collection system.Costs include GRVs plus thesewer balloons, diversionvalves and temporarystorage (frac tanks) formaterial removed fromblocked storm drains. Costsfor each airport toimplement block and pumpare dependant on thenumber of deicing outfallsreported in the Airportsurvey.Cost - BlockPump Costs Calculates capital and annualO&M costs associated with ablock & pump collection system.BlockPumpCapCost =[BlockPumpCapCostFactor]*[NumDeice]BlockPumpAnnCost =[BlockPumpAnnCostFactor]*[NumDeice]TABLE: factorsTABLE: Q1-11bCost - GRV Costs Calculates capital and annualO&M costs associated withGRVs.NumGRV=IIf([Hub]="L",3,2)GRVCapCost =[GRVCapCostFactor]*[NumGRV]GRVAnnCost =[GRVAnnCostFactor]*[NumGRV] * 1.2TABLE: Airport IDTABLE: Airport SurveySitesTABLE: Q1-11bTABLE: factorsWhere the 1.2 factor for annual costsaccounts for drain covers and labor toinstall them as needed.Table 2 (Continued). Queries in theAirport Deicing Costing Database12Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesCost - Minimal Deicing Calculates annual O&M costsfor airports with minimaldeicing operations.MinDeicingCapCost = 0MinDeicingAnnCost =IIf([MinDeicing]=0,0,([TotalPG/EG]*[MinimalDeicingCostFactor]*[AirplaneRunoffFactor]*[MinimalDeicingCaptureEfficiency])+([VacuumTruckCostFactor]*IIf([SOFPDays]<1,1,[SOFPDays])))TABLE: Airport IDTABLE: Airport SOFP Days andDeparturesTABLE: factorsQUERY: Airport ADF UsageQUERY: Facility MinimalDeicing Step 2This calculation estimatesthe capital cost for an airportto assess operations fordesign of the proper systemand develop an operationsplan for winter training onthe system.Cost - Winter OperationsPlanEstimates capital costs todevelop an operations plan forwinter training.GRV_WinterOpsCost:[EngineerHourlyCost]*IIf([Hub]="L",200,120)BlockPump_WinterOpsCost:[EngineerHourlyCost]*IIf([Hub]="L",400,240)TABLE: Airport IDTABLE: Airport SurveySitesTABLE: factorsThis calculation estimatescosts for an airport tocontract haul additionalADF stormwater to anoffsite glycol recoveryfacility. This equationapplied to those airports thatare currently contracthauling offsite for glycolrecovery and assumes theairport would continue to dothe same even if required tocollect additional ADFstormwater to achieve 40%capture.Costs - Offsite GlycolRecovery CostsCalculates incremental annualcosts for an airport to contracthaul additional ADF collected ifreplace GRV with block andpump.OffsiteGlycol_GRVAnnCost =[TotalPG/EG]* ([CSCE_GRV] –[Airport Percent Capture])*[OffsiteGlycolAnnCostFactor]OffsiteGlycol_BlockPumpAnnCost = [TotalPG/EG]*([CSCE_BlockPump] – [AirportPercent Capture])*[OffsiteGlycolAnnCostFactor]TABLE: factorsTABLE: Airport Percent CaptureQUERY: Airport ADF UsageQUERY: Facility OffGlycolOffsite glycol ann cost factor shouldbe 4.88Table 2 (Continued). Queries in theAirport Deicing Costing Database13Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesCalculates the capital andO&M costs for additionalstormwater piping. Assume10,000 ft of additionalpiping is required.Cost - Piping Costs Calculates the capital and O&Mcosts for additional stormwaterpiping from collection points toAFB or POTW discharge.PipingCapCost:PipingCapCostFactorPipingAnnCost:PipingAnnCostFactorTABLE: Airport IDTABLE: factorsCalculates annual O&Mcosts associated with POTWdisposal for collected ADFstormwater.Cost - POTW Annual Costs Calculates annual O&M costsassociated with POTW disposalfor 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]TABLE: Airport IDTABLE: factorsQUERY: Airport ADF UsageQUERY: Average Deicing DaysCalculates the capital andO&M costs for storage tankused for concentrated ADFstormwater collected fromGRVs and block and pumpsystems.Cost - Storage Tank Costs Calculates the capital and O&Mcosts for storage tank used forconcentrated ADF stormwatercollected from GRVs and blockand pump systems.TankCapCost:[TotalPG/EG]*[Storage_GalFactor]*[Storage_CapCostFactor]TankAnnCost: TankAnnCost =([TotalPG/EG]*[Storage_AnnCostFactor])+(1.2*[TotalPg/EG]*([Storage_GalFactor]*[SqftPerGal])*[LandSqftCost])TABLE: Airport IDTABLE: factorsQUERY: Airport ADF UsageFacility BlockPump Step 1 Lists unique list of airport IDsthat have a block and pumpsystem in place (based onresponse to Q33).[Block]=TrueTABLE: Q33Table 2 (Continued). Queries in theAirport Deicing Costing Database14Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesFacility BlockPump Step 2 Lists all airport IDs with anindicator of whether or notairport has a block and pumpsystem in place.HaveBlockPump =IIf(IsNull([Facility BlockPumpStep 1].[AirportID]),0,-1)TABLE: Airport IDQUERY: Facility BlockPumpStep 1Facility GRV Step 1 Lists unique list of airport IDsthat have a GRV system in place(based on response to Q33).[GlycolRec]=TrueTABLE: Q33Facility GRV Step 2 Lists all airport IDs with anindicator of whether or notairport has a GRV system inplace.HaveGRV = IIf(IsNull([FacilityGRV Step 1].[AirportID]),0,-1)TABLE: Airport IDQUERY: Facility GRV Step 1Facility Minimal Deicing Lists of airport IDs for smallairports that arecosted for doing"minimal deicing"[TotalPG/EG]<>0[CountDeicingMonths]=0[Q36.DestMeth]='SFW'[Q36.Volume]<>0[PercentCapture]<100TABLE: Airport IDTABLE: Airport Percent CaptureTABLE: Q36QUERY: Airport ADF UsageQUERY: Average Deicing DaysFacility Minimal Deicing 2 MinDeicing = IIf(IsNull([FacilityMinimal Deicing].[AirportID]),0,-1)TABLE: Airport IDQUERY: Facility MinimalDeicingFacility OffGlycol Lists airport IDs that performcontract hauling (based onresponse to Q36)[DestMeth]='OFFGLYCOL'TABLE: Q36TABLE: Airport IDFacility Tanks Step 1 Lists unique list of airport IDsthat have storage tanks (basedon response to Q33).[Tank]=TrueTABLE: Q33Facility Tanks Step 2 Lists all airport IDs with anindicator of whether or notairport has tanks in place.HaveTanks = IIf(IsNull([FacilityTanks Step 1].[AirportID]),0,-1)TABLE: Airport IDQUERY: Facility Tanks Step 1Table 2 (Continued). Queries in theAirport Deicing Costing Database15Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesFacility Zero Cost List of airport IDs that shouldnot be costed.(SOFPDays=0 andCountDeicingMonths<>0 andTotalPG/EG=0) ORTotalPG/EG=0TABLE: Airport SOFP Days andDeparturesQUERY: Airport ADF UsageQUERY: Average Deicing DaysOption Costs - append XXto output tableSeries of queries used to createcosting output.The option cost queries listed below use the various calculations toestimate costs for airports that have no collection or treatment in place. The queries calculate costs for allcollection (GRVs, block and pump, and deicing pads with a holding tank and piping) and all control options (anaerobic fluid beds, UF/RO, evaporation,off-site transfer toPOTW 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 associated technology). Ex =Option1aCapCost = IIf([HaveGRV]=-1 and [PercentCapture]>0,[Option1aCapCost_calc]*([option_threshold]/[PercentCapture]),[Option1aCapCost_calc])Because this methodology is the same for each option,it is not repeated below in order to save space.Option Costs - Option 1AirportsProvides a list of airports to becosted under Option 1.[PercentCapture]< 20 and[AirportID] Not In Facility[Facility OffGlycol]special_cost: IIf(IsNull([FacilityMinimal Deicing].[Airport ID]),IIf(IsNull([Facility ZeroCost].[Airport ID]),Null,"zero"),"min")HaveOffGlycol:IIf(IsNull([FacilityOffGlycol].AirportID),0,-1)TABLE: Airport Percent CaptureQUERY: Airport ADF UsageQUERY: Facility MinimalDeicingQUERY: Facility OffGlycolQUERY: Facility Zero CostTable 2 (Continued). Queries in theAirport Deicing Costing Database16Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesOption Costs - Option 1a Estimates capital costs forairports to purchase GRVs, acollection tank, piping and ananaerobic fluid bed treatmentsystem; andEstimates annual operating costsfor airports to operate GRVs, acollection tank, and an anaerobicfluid bed treatment system.Costs for airports designatedas "zero cost" are set to 0.Costs for airports designatedas "min" are set to theminimal deicing cost.Remaining airports are costedas shown.Option1aCapCost_calc =[GRVCapCost]+[TankCapCost]+[PipingCapCost]+[AFB_GRVCapCost]+[GRV_WinterOpsPlanCost]Option1aAnnCost_calc =[GRVAnnCost]+[TankAnnCost]+[AFB_GRVAnnCost]+[PipingAnnCost]QUERY: Option Costs - Option1 AirportsQUERY: Cost - AFB CostsQUERY: Cost - GRV CostsQUERY: Cost - MinimalDeicingQUERY: Costs - Piping CostsQURY: Cost - Storage TankCostsQUERY: Cost - WinterOperations PlanQUERY: Facility GRV Step 2Table 2 (Continued). Queries in theAirport Deicing Costing Database17Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesOption Costs - Option 1b Estimates capital costs forairports to purchase GRVs, acollection tank and piping.Estimates O&M costs forairports with GRVs to sendwastewater to POTW.Costs for airports designatedas "zero cost" are set to 0.Costs for airports designatedas "min" are set to theminimal deicing cost.Remaining airports are costedas shown.Option1bCapCost_calc:[GRV_CapCost]+[TankCapCost] +[PipingCapCost]+[GRV_WinterOpsPlanCost]Option1bAnnCost_calc:[GRV_AnnCost]+[TankAnnCost]+[PipingAnnCost]+[POTW_GRVAnnCost]QUERY: Option Costs - Option1 AirportsQUERY: Cost - GRV CostsQUERY: Cost - MinimalDeicingQUERY: Costs - Piping CostsQUERY: Costs - POTW AnnualCostsQURY: Cost - Storage TankCostsQUERY: Cost - WinterOperations PlanQUERY: Facility GRV Step 2Option Costs - Option 2AirportsProvides a list of airports to becosted under Option 2.[PercentCapture]<40 and[AirportID] Not In [FacilityOffGlycol]Special_cost: IIf(IsNull([FacilityMinimal Deicing].[AirportID]),IIf(IsNull([Facility ZeroCost].[AirportID]),Null"zero"),"min")HaveOffGlycol:IIf(IsNull([FacilityOffGlycol].AirportID),0,-1)TABLE: Airport Percent CaptureQUERY: Facility OffGlycolQUERY: Facility Zero CostQUERY: Facility MinimalDeicingQUERY: Airport ADF UsageTable 2 (Continued). Queries in theAirport Deicing Costing Database18Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesOption Costs - Option 2a Estimates costs for airports toinstall and operate block andpump, a collection tank, pipingand an anaerobic fluid bedtreatment system.Costs for airports designatedas "zero cost" are set to 0.Costs for airports designatedas "min" are set to theminimal deicing cost.Remaining airports are costedas shown.Option2aCapCost_calc =[BlockPumpCapCost]+[TankCapCost] + [PipingCost]+[AFB_BlockPumpCapCost]+[BlockPump_WinterOpsPlanCost]Option2aAnnCost_calc =[BlockPumpAnnCost]+[TankAnnCost]+[AFB_BlockPumpAnnCost]+[PipingAnnCost]TABLE: Airport SOFP Days andDeparturesQUERY: Option Costs - Option2 AirportsQUERY: Cost - AFB CostsQUERY: Cost - BlockPumpCostsQUERY: Cost - Piping CostsQUERY: Cost - Storage TankCostsQUERY: Cost - WinterOperations PlanQUERY: Facility BlockPumpStep 2QUERY: Airport ADF UsageQUERY: Cost Minimal DeicingOption Costs - Option2b Estimates capital costs forairports to install and operateblock and pump, a collectiontank and piping.Estimates O&M costs forairports with block and pump tosend wastewater to POTW.Costs for airports designatedas "zero cost" are set to 0.Costs for airports designatedas "min" are set to theminimal deicing cost.Remaining airports are costedas shown.Option2bCapCost_calc:[BlockPumpCapCost]+[TankCapCost] +[PipingCapCost]+[BlockPump_WinterOpsPlanCost]Option2bAnnCost_calc:[BlockPumpAnnCost]+[TankAnnCost]+[PipingAnnCost]+[POTW_BlockPumpAnnCost]QUERY: Option Costs - Option1 AirportsQUERY: Cost - BlockPumpCostsQUERY: Cost - MinimalDeicingQUERY: Costs - Piping CostsQUERY: Costs - POTW AnnualCostsQURY: Cost - Storage TankCostsQUERY: Cost - WinterOperations PlanQUERY: Facility BlockPumpStep 2QUERY: Airport ADF UsageQUERY: Facility GRV Step 2Table 2 (Continued). Queries in theAirport Deicing Costing Database19Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data SourcesOption Costs - Output AnnCost CrosstabGenerates a crosstab of annualoperating costs. Used to createoutput.Option Costs - Output CapCost CrosstabGenerates a crosstab of capitalcosts. Used to create output.output_flowcalcs Used for internal QC, presentsall flow values calculated bynumbered flow queries (seeabove). Output emulates 'AllFlow Calculation' sheet in FlowCalcs Workbook_AUG3_MJB.xls.Othervolume_gpd =[OtherVolume]*[SOFP Days]TABLE: Airport IDTABLE: Airport Total ADFUsageTABLE: Deicing_PrecipTABLE: factorsQUERY: 01 - Step 1a CalcRunway AreaQUERY: 02 - Step 1b Calc TotalRunway AreaQUERY: 03 - Step 2 Calc OtherTotal AreasQUERY: 04 - Step 3 Total AreaReportedQUERY: 05 - Step 4 Calc Q36POTW VolumeQUERY: 06 - Step 5 Calc Q36Other Dest Method VolumeQUERY: 07 - Step 6 Est TotalVol ADF StormwaterQUERY: 08 - Step 7 Est TotalVol ADF Stormwater EntireAirportQUERY: 09 - Step 8 Calc TotalVol ADF ReleasedQUERY: 10 - Step 9 Calc TotalVol ADF Released EntireAirportTable 2 (Continued). Queries in theAirport Deicing Costing Database20Calculation DescriptionQuery NameQuery FunctionQuery CalculationsQuery Data Sourcesoutput_treatment_technologiesUsed for internal QC, presentsall treatment technology costscalculated costing queries (seeabove).NATABLE: Airport IDQUERY: Cost - AFB CostsQUERY: Cost - BlockPumpCostsQUERY: Cost - Deicing PadCostsQUERY: Cost - Evap Costs(Scen 1)QUERY: Cost - Evap Costs(Scen 2)QUERY: Cost - Pond and PipingCostsQUERY: Cost - UFRO Costs(Scen 1)QUERY: Cost - UFRO Costs(Scen 2)Table 3. Factors Used in the Airport Deicing Costing DatabaseFactor CodeFactor DescriptionFactor ValueUsed Inacre/sf Acres per square feet 43,560 04 - Step 3 Total Area Reported08 - Step 7 Est Total Vol ADF StormwaterEntire AirportCost - Pond and Piping CostsOption Costs - All Airport Flow ScenarioAFB_LandSqFt Amount of Land for an AFB. 2.4 acres times43,560 sq. ft. per acre = 104,544 sq. ft104,544 Cost - AFB CostsADF_BlockPump Percent ADF from block & pump systems, usedto calculate POTW treatment by anaerobicdigestion from block & pump systems.10 Cost - AFB CostsCost - POTW Anaerobic Treatment CostsADF_COD ADF/COD conversion factor 14.28 Cost - AFB CostsOption Costs - All Airport Flow ScenarioAFB_ComplianceCost/Sample Cost per sample for compliance monitoring 22 Costs - AFB CostsAFB_ComplianceCostSampleHrs Numberof sample hours for compliancemonitoring130 Costs - AFB CostsAFB_POTWAnnCostFactor Cost factorused to calculate POTW treatmentby anaerobic digestion from block & pump anddeicing pads.0.08 Cost - AFB CostsAFBAnnCostFactor Cost factor usedto calculate annual O&M costsfor anaerobic fluid bed treatment system4.9 Cost - AFB CostsOption Costs - All Airport Flow ScenarioAirplaneRunoffFactor Cost factor used to represent the amount ofdeicing materials that drips off an airplane ontothe pad for collection.0.8 Cost - Minimal DeicingBlockPumpAnnCostFactor Cost factor used to calculate annual O&M costsfor block & pump collection system260,000 Cost - BlockPump CostsBlockPumpCapCostFactor Cost factor used to calculate capital costs forblock & pump collection system263,400 Cost - AFB CostsCost - BlockPump CostsCost - Evap CostsCostForCODRemoval -0.6279 Cost - AFB CostsTable 3 (Continued). Factors Used in the Airport Deicing Costing Database22Factor CodeFactor DescriptionFactor ValueUsed InCostForCODRemoval2 275,101 Cost - AFB CostsCSCE_BlockPump Collection systemcapture efficiency, when usedin conjunction with block & pump collectionsystem40 Cost - AFB CostsCost - Evap CostsCost - Offsite Glycol RecoveryCost - POTW Anaerobic Treatment CostsCost - POTW Annual CostsCost - UFRO CostsCSCE_GRV Collection system capture efficiency, when usedin conjunction with GRV system20 Cost - AFB CostsCost - Evap CostsCost - Offsite Glycol RecoveryCost - POTW Annual CostsCost - UFRO CostsdaysSampled/week Days sampled per week 5 Cost - AFB CostsEngineerHourlyCost 100gal/sf Square feet to gallons conversion factor7.48 07 - Step 6 Est Total Vol ADF Stormwater08 - Step 7 Est Total Vol ADF StormwaterEntire AirportGrassyAreaToRunway Grassy area to runway conversion factor 2.356928 03 - Step 2 Calc Other Total AreasGRVAnnCostFactor Cost factor usedto calculate annual O&M costsfor GRV system56,986 Cost - GRV CostsGRVCapCostFactor Cost factor usedto calculate capital costs forGRV system344,238 Cost - GRV CostsLandSqftCost 1MinimalDeicingCaptureEfficiency Capture efficiency value used to calculate costsfor airports with minimal deicing operations.0.2 Cost - Minimal DeicingMinimalDeicingCostFactor Cost factor used to calculate costs for airportswith minimal deicing operations.1.83 Cost - Minimal DeicingTable 3 (Continued). Factors Used in the Airport Deicing Costing Database23Factor CodeFactor DescriptionFactor ValueUsed InMonitoringLabor/hr Assumed labor cost per hour for monitoring 33 Cost – AFB CostsOffsiteGlycolAnnCostFactor Cost factorused to calculate annual costs foroff-site recycle and recovery of spent ADF.Costs include both hauling and treatment.4.88 Cost - Offsite Glycol RecoveryPavedApronToRunway Paved apron to runway conversion factor 1.794712 03 - Step 2 Calc Other Total AreasPavedAreaRunoffCoeff Paved area runoff coefficient 0.98 07 - Step6 Est Total Vol ADF Stormwater08 - Step 7 Est Total Vol ADF StormwaterEntire AirportPipingCapCostFactor Cost factor used to calculate capital costs forstormwater piping.1,141,000 Cost - Piping CostsPipingAnnCostFactor5,400 Cost - Piping CostsPOTW_glycol Cost factor usedto calculate annual O&M costsfor medium-concentration equalization pondsystem with POTW discharge0.5 Cost - POTW Annual CostsPOTWAnnCostFactor Cost factor usedto calculate annual O&M costsfor medium-concentration equalization pondsystem with POTW discharge0.01 Cost - POTW Annual CostsStorage_AnnCostFactor 0.27Storage_CapCostFactor 1.67Storage_GalFactor 13.1Storage_LandSqftTankAllFlowAnnCostFactor Cost factor used to calculate annual O&M costsfor collection.0.07 Option Costs - All Airport Flow ScenarioTankCapCostFactor Cost factor used to calculate capital costs forstorage tanks used for ADF stormwatercollected from pad and block & pump systems.1.67 Cost - Storage Tank CostsOption Costs - All Airport Flow ScenarioTable 3 (Continued). Factors Used in the Airport Deicing Costing Database24Factor CodeFactor DescriptionFactor ValueUsed InTaxiToRunway Taxi to runway conversion factor 1.399511 03 - Step 2 Calc Other Total AreasUnpavedAreaRunoffCoeff Unpaved area runoff coefficient 0.8 07 - Step 6 Est Total Vol ADF Stormwater08 - Step 7 Est Total Vol ADF StormwaterEntire AirportVacuumTruckCostFactor Cost per day to vacuum spent ADF fromconcrete areas and contract haul and dispose ofthe spent ADF at a recycle facility.1,100 Cost - Minimal Deicingweeks/year Weeks per year 26 Cost - AFB Costs