Brian W Zelt

PhD, PEng

AERtools

application software

TRAINING

We are designing new training videos for AERflare-incin and ABflare.  We are working preview and subscription services to host the videos.

 

 

AERtools is a collection of spreadsheet and application programs created for air quality professionals for the calculation of source parameters and ground level concentrations.  The tools were created based upon state-of-the-art engineering considerations of thermodynamics, energy balance, mass balance and practical application of these principles for use with current air dispersion models and methods.

 

AERflare-incin

AERflare-incin is the current evolution of ERCBflare and ERCBincin tools.  This tool functions as a stand-alone MS Excel spreadsheet server and database.  The tool accepts user inputs and generates air dispersion modelling source inputs for the U.S. EPA AERMOD dispersion model and steady state source parameters for the CALPUFF air dispersion model.   AERflare-incin can be used to create AERMOD ready input files or can be used as a server to run AERMOD in screening or refined modes and interpret the predictions for Alberta regulatory ambient air quality compliance and well test flaring/incineration applications.  The goal in developing AERflare-incin was to ensure a consistent content, required contents and quality of air quality modelling, reports and applications to AER (Alberta Energy Regulator)  and AEP (Alberta Environment and Parks).

ABflare

ABflare was developed as a sister tool to AERflare-incin.  Whereas AERflare-incin was developed for screening and refined air dispersion modelling for AERMOD, ABflare was developed for refined dispersion modelling for time-varying source parameters of flare sources for the CALPUFF model.  As a part of the ABflare model development, the CALPUFF model was extended to extend the source types from point, line, volume and area sources to include a flare source.  The flare source in CALPUFF is a time-varying (arbitrary input) file allowing the time variation of height, diameter, velocity, temperature and location of the (effective) point source.  The ABflare tool is used to create the time-varying input file as well as act as a server to assist the creation of CALPUFF input files and assessment of output from this type air quality analysis.  The ABflare tool can be used to create CALPUFF and AERMOD input files.

FILES

AERflare-incin v2.10.180309

This version of AERflare addresses several updates including reports from virus protection software of potential malicious activity.

Some of the features may still contain bugs and we appreciate hearing about all suspected bugs, odd behaviour or suggested improvements and features.

 

 

spreadsheet only

 

AERflare.v210.180319.xlsm (updated 2018-Mar-19)

  • Corrected improper read of run flags.  The default setting of the run flags all blank or all set was not read correctly, and a run with all blank was returned without running any met conditions.
  • BETA: Added processing of EPA, British Columbia and Ontario flaring source pseudo-parameters.  The methods are selectable using the iSTART page and the mpseudo setting.
  • Updated the RBC criteria to 99.9087% from 99.9% to better match the 8760 hours.  The 99.9087% is equivalent to the 9th highest.
  • Updated the land classification processing to change from point sample methodology to the more precise land use area calculation methodology.  This changes the processing from point-wise sub-sampling of a grid cell N-times to determine the average LCC codes; and instead, determines the polygon area of each LCC type within a cell.
  • Added optimized sorting algorithm to speed up post-processing and meteorological processing
  • Corrected bad write of data to parallel assessment on oAERSCREEN with zeroes.  This corrects a false warning message of apparent minimum data requirement on the oSUMMARY page

AERflare.v210.180216.xlsm (updated 2018-Feb-16)

  • Corrected bad warning message regarding inputs not matching outputs.

AERflare-incin.v210.180215.xlsm (updated 2018-Feb-15)

  • Corrected bad write of data to parallel assessment on oAERSCREEN with zeroes.  This corrects a false warning message of apparent minimum data requires on the oSUMMARY page

AERflare-incin.v210.180209.xlsm (updated 2018-Feb-09)

  • Corrected/adjusted warnings and messages on the iSOURCE and oSUMMARY page to match the change in output method (text YES/NO/PASS/FAIL vs radio buttons). Several messages adjacent to PASS/FAIL results on oSUMMARY were not displayed appropriately resulting from previous changes in buttons and may have caused some confusion. Sorry.  Added highlights for faster review of issues that may require further documentation for applications.
  • Added the display of potential issues raised on oSUMMARY to general red flags
  • Added default notes to the iNOTES page.
  • Added Run flags and source orientation to the recalculation required lists on oAERSCREEN
  • Set the axis divisions to auto on the figure on oBLOWDOWN so that the figure adjusts to all sorts of inputs
  • For permits, added a new figure page to display the AER_FIGURE4 flow chart with decision points from the entries.
  • Corrected UTM zone bug when entering Geographical coordinates on iSOURCE page then making calculations on iTERRAIN or iUSERTER pages
  • Changed coding avoid false-positives of malicious or suspicious activity during virus scanning when sending by eMail to AER.  Removed dead code. Changed coding practice of saving settings to registry to a method that saves settings to a file on windows temp folder.  A file “AERTOOLS_Settings_AERflare.ini” is created to save inter-session settings such ViewTechnicalPages, iBin Settings, etc.  Each time you open a spreadsheet, it will check if the INI file exists, and if so, it will refresh the settings in the workbook being loaded.  If the INI file does not exist, then the workbook will create the file as required to save your settings.
  • Changed the name of the oCALCULATIONS page to oCALCFLARE.
  • Added warning flags to the top of oBLOWDOWN page
  • Corrected auto-scaling issues on oBLOWDOWN figure 1
  • (Beta Testing) Unlocked the ONT MOE variable radiation heat loss method (see mvarrad on iSTART) which uses the Ont. MOE method to adjust heat loss as a function of flared gas molar mass.
  • (Beta Testing) Unlocked the oFOLIAGE processing page.  This page is used for analyzing SO2 damage to foliage as part of MOE BC assessments.  This page works with saved data and is a post-processing option.
  • Added orange shading (warning) to fields on oSUMMARY page.  Highlighted the Number of potential issues raised and number of non-default settings (top right of page) for reviewers.
  • Corrected incorrectly dimensioned matrix when loading sources.csv and creating a receptor grid.
  • Corrected mismatched receptor grid when loading sources.csv file.
  • Adjusted entry of HEATER/BOILER efficiency entry; entered on iSOURCE page.  Stack losses for heaters and boilers may be calculated on iENGINE page but is manually entered on the iSOURCE page
  • Added POINT, POINTCAP, POINTHOR stack types to iSOURCE input page for incinerators, boilers, heaters, engines
  • Adjusted Engine energy balance exhaust calculations.  Calculations now use the engine specs as a starting point for heat loss at end of engine (may include muffler) and then adds 15% heat loss through stack.

AERflare-incin.v209.170915.zip (updated 2017-Sep-15)

  • Corrects external link error “personal.xlam”

AERflare-incin.v209.170914.zip (updated 2017-Sep-14) -- archived

  • Corrects output for H2S for RBC and Climit; which always returned 100th value.  This bug was introduced as part of the 170801 version.
  • minor cosmetic fixes

AERflare-incin.v209.170802.zip (updated 2017-Aug-02) -- archived

  • Corrects 'Function not available to you' message when selecting Permit/Application or Flare/Incinerator on the iSTART page

AERflare-incin.v209.170801.zip (updated 2017-Aug-02) -- archived

  • Corrected broken link

AERflare-incin.v209.170801.zip (updated 2017-Aug-01) -- archived

  • Corrected issue relating to the appearance of a virus (there wasn't a virus)
  • Added option for batch mode operation to export the plottable data results from oAERSCREEN page
  • Added processing to the oPROCESSING page to 'Add' a secondary modelling results to the the flaring.  When modelling flares, the control setting NOSTD must be used when using the pseudo-parameters.  For other sources NOSTD should not be used.  Therefore, flares must be modelled separately from other sources.  In Alberta, non-routine, upset and emergency flares are not modelled with other cumulative emissions.  For routine flaring, flare emissions should be included with other emissions.  If the dispersion modelling uses the same receptor grid, the output POSTFILE data time series can be added.  The 'Add' switch allows the user to specify a POSTFILE output results for other sources which is added during run-time processing to form a cumulative concentration.
  • Updated oMODELLING page to list real-source parameters and pseudo-source parameters.  Added emission factors and emission rates of non-sour components.
  • AERflare-incin now uses the newer format GeoTIFF for DEM rather than the older CDEM (no longer supported).  The iBIN page is updated with the link to the new downloads.  The GeoTIFF files are larger but processing them is a little bit faster.
  • Bug fixes for Emissions Factors
  • Bug fixes for Engine/Boiler/Heater calculations
  • Updated code for downloading from the internet
  • Added BC MOE foliage damage post-processing calculations
  • Added Ont. MOE methodology for variable heat radiation losses with changes in flared gas MW.
  • Added daily 1h maximum calculation as an alternative to maximum hourly average concentration.
  • Added 24h and annual average calculations
  • Added high-pressure fuel flare-assist.  This flare-assist adds fuel additional fuel at high co-flowing momentum
  • Updated the flare air-assist calculation to account for air required.  Thus air-assist is assumed to replace stoichiometric air until satisfied.  Air-assist greater than stoichiometric will then degrade combustion.
  • revised presentation of oSUMMARY to avoid broken links issues.
  • Small bug fixes

AERflare-incin.v206.161101a.zip (updated 2017-Jan-15)

  • Corrects 64bit declaration

AERflare-incin.v206.161101.zip (updated 2016-Nov-01)

  • Corrected broken links on oSUMMARY page

AERflare-incin.v206.161028.zip (updated 2016-Oct-28)

  • Corrected printout on iTERRAIN, where Row 80 of the page could be over-written if the contour interval was low.
  • Corrected printout on iTERRAIN of xyz-distance, where the start index in the contour data array could be calculated incorrectly depending upon the final contour interval
  • Corrected iBATCH save of DEM_OUT (rows 56-80, exclusive of flare 0,0), instead of (rows 55-79, inclusive of flare 0,0).

 

AERflare-incin.v206.161027.zip (updated 2016-Oct-27)

  • Windows 10 Update KB3199209 leads to crash of Excel when AERflare-incin is loaded.

 

AERflare-incin.v206.160922.zip (updated 2016-Sep-22)

  • Corrected missing calculation for Qmin flammability check for air assisted flaring.
  • Corrected bug affecting selection of Incinerator source type dropdown and creating an error message “cannot write to protected area”.
  • conditional formatting corrections

 

 

 

package includes spreadsheet, examples, met files

 

AERflare-incin-Metfiles (v4).zip (updated 2017-Aug-05)

  • This zip contains the screening met files that update the MAKEMET to AERSCREEN and AERMOD v16216

AERflare-incin-Metfiles (v3).zip (updated 2016-Jun-02)

  • This zip contains the screening met files required to run AERflare-incin in screening mode.

 

AERflare-incin.v206.161027.package.zip  (updated 2016-Oct-27)

 

AERflare-incin Documentation

The AERflare-incin user manual is being revised

AERflare User_manual.pdf  (2014, Updates pending)

What's New (2018-Mar-16)

ABflare v1.03

ABflare has been updated to v1.03.  This version includes an optimized methodology for determining the average LCC for each grid cell using the area of each polygon within a grid cell.  See What's New below.

 

ABflare.v103.180315.zip (updated 2018-Mar-15)

  • Optimized the land classification processing to use the area of the LCC polygons within each grid cell rather than point sampling.  This removes concern regarding resolution of point sampling and now provides a true average LCC for each grid cell.  Additional optimizations reduce computation times especially for large domains. .

ABflare.v103.180209.zip (updated 2018-Feb-09)

  • Changed coding avoid false-positives of malicious or suspicious activity during virus scanning when sending by eMail to AER.  Removed dead code. Changed coding practice of saving settings to registry to a method that saves settings to a file on windows temp folder.  A file “AERTOOLS_Settings_ABflare.ini” is created to save inter-session settings such ViewTechnicalPages, iBin Settings, etc.  Each time you open a spreadsheet, it will check if the INI file exists, and if so, it will refresh the settings in the workbook being loaded.  If the INI file does not exist, then the workbook will create the file as required to save your settings.
  • Updated worksheet names as per AERflare: oCALCFLARE, oBLOWDOWN
  • Small bug fixes

ABflare.v103.170609.zip  (updated 2017-Jun-09)

  • Bug corrections and updates throughout
  • Added DoForEach list processing throughout in user interface to assist in multi-year processing
  • Added Domain coordinates to iCOMMON page
  • Added map of MM5 coordinates and automatic Coordinates selection to STEP0A CALMET page.  Includes user editable coordinates for extraction.
  • Added auto-extraction of MM5
  • Updated the Create User Receptor file to match AERflare.  Includes read DEM, read user xy receptor list, read user XYZ dem file, read user fenceline file, fill fence line, read sources list (to ensure higher resolution receptors are selected with 500m of all sources).
  • Added checks on Step1-Metseries to ensure extraction elevations are the same as stack heights on the Step2-ABflare page
  • Updated GetFromAERflare processing
  • Updated CALMET and CALPUFF default file and settings to match current CALPUFF release
  • Updated the ABflare combustion calculations to match changes in AERflare including flare assist and equations of state updates

ABflare.v102.160913.zip (updated 2016-Sep-13) -- archived

ABflare Documentation

The ABflare user guide has been update to include the latest features 2017, v1.03

ABflare User Guide.pdf  (2017-Jun-09)

What's New (2018-Feb-09)

AERtools Support Forum & Discussions

Please check out the AERtools support forum and discussions page. Much can be learned by sharing your concerns or solutions.

 

AERtools Forum

(The forum has been replaced with blog list of FAQ)

click here for AERflare FAQ

click here for ABflare FAQ

 

click here to eMail ZPSi about a bug

 

click here to subscribe to the AERtools mailing list

ZELT Professional Services Inc.