Extra sections
Microsoft Excel & Sustainability Consulting
Microsoft Excel Services
Plan
Improve
Future-proof
Workbook scoping: Get help with forming a strategy to turn your data to the results you need
Workbook audits: Find errors and optimize sheets, formulas, tables, charts, and macros
Power Query setup:
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query






Services
Microsoft Excel
Custom eco-design tools
Experienced in developing product footprint and LCA tools.
Sustainability
Dashboards & Models
Workbook troubleshooting and audits
Find errors and optimize sheets, formulas, tables, charts, and macros
Power Query implementation
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query
One-on-one skill training
Learn and practice Excel skills with support from an experienced Excel user
Workbook scoping and architecture
Plan your data and calculations in advance - Measure twice, cut once!
Life cycle assessment
Specializing in LCAs of buildings.
Visualizations and dashboards
See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.
Scenario analysis
Explore how key parameters change your models and analysis.
Uncertainty analysis
Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.
Custom models
Reach out if you would like assistance with developing custom simulations and models.
Building energy modeling
Estimate the energy consumption of your building using EnergyPlus simulations.
Services
Provide a general summary of the services you provide, highlighting key features and benefits for potential clients.
Microsoft Excel
Custom eco-design tools
Experienced in developing product footprint and LCA tools.
Sustainability
Dashboards and Models
Worksheet audits
Troubleshoot and optimize sheets, formulas, tables, charts, and macros.
Power Query
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query.
One-on-one skill training
Learn and practice Excel skills with support from an experienced Excel user.
Worksheet scoping and architecture
Plan your data and calculations in advance - Measure twice, cut once!
Life cycle assessment
Specializing in LCAs of buildings.
Visualizations and dashboards
See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.
Scenario analysis
Explore how key parameters change your models and analysis.
Uncertainty analysis
Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.
Custom models
Reach out if you would like assistance with developing custom simulations and models.
Building energy modeling
Estimate the energy consumption of your building using EnergyPlus simulations.
Dashboards and Models
Hester Analytics has experience with applying genetic algorithms to identify low-cost, low-impact building designs. Reach out to discuss other applications.
Genetic algorithms
Microsoft Excel


Workbook audits
Workbook scoping and architecture
Troubleshoot and optimize sheets, formulas, tables, charts, and macros.
Power Query
Learn and practice Excel skills with support from an experienced Excel user.
Plan your data and calculations in advance - Measure twice, cut once!
One-on-one skill training
Save time and effort with recurring reporting by implementing repeatable data flows in Power Query.
Sustainability


Custom eco-design tools
Life cycle assessments
Product footprint and LCA audits
TEXT
Specializing in LCAs of buildings.
Dashboards and Models


Explore how key parameters change your models and analysis.
Visualizations and dashboards
Scenario analysis
See the big picture of your business or product with custom dashboards in Excel, Power BI, or Tableau.
Uncertainty analysis
Hester Analytics has experience with applying genetic algorithms to identify low-cost, low-impact building designs. Reach out to discuss other applications.
Genetic algorithms
Measure the uncertainty in your model and identify ways to reduce uncertainty through Monte Carlo simulation and related statistical methods.

