Advanced Excel & VBA — Engineering Calculations and DashboardsGabe Upton
I build Excel workbooks that engineering and operations teams can trust — protected formulas, validated inputs, VBA automation, and dashboards that update themselves.
Not formatted tables. These are calculation engines with named ranges, error handling, input wizards, and documentation. Built by a chemical engineer who has done this work in midstream oil and gas operations.
What I deliver: engineering calculators (process, pipeline, mechanical, safety), financial models, regulatory compliance tools, reporting workbooks with one-click PDF generation, and data processing macros that replace hours of manual work.
My track record: built 130+ engineering calculators across 13 disciplines, automated emissions calculations that cut facility reporting from 3 days to 5 minutes, and rebuilt a company's PSV/DEI reporting workbook with Peng-Robinson EOS calculations and VBA automation.
If your team is copying data between spreadsheets, running manual calculations, or waiting on consultants for routine reporting — I'll build a tool that handles it.
FAQs
Yes. Send it over and I'll assess what needs to be rebuilt vs improved. Often I can keep the structure and add protection, validation, and automation on top.
Yes — EPA Subpart W, OOOOa/b/c, fugitive emissions, combustion, and more. I know the methodologies, not just the formatting.
That's the goal. Every workbook includes an instructions sheet, input validation with error messages, and protected formulas so users can't accidentally break anything. Premium tier includes a video walkthrough.
Contact for pricing
Duration1 week
Tags
Excel VBA
Microsoft Excel
Service provided by
Gabe Upton San Antonio, USA
Advanced Excel & VBA — Engineering Calculations and DashboardsGabe Upton
Contact for pricing
Duration1 week
Tags
Excel VBA
Microsoft Excel
I build Excel workbooks that engineering and operations teams can trust — protected formulas, validated inputs, VBA automation, and dashboards that update themselves.
Not formatted tables. These are calculation engines with named ranges, error handling, input wizards, and documentation. Built by a chemical engineer who has done this work in midstream oil and gas operations.
What I deliver: engineering calculators (process, pipeline, mechanical, safety), financial models, regulatory compliance tools, reporting workbooks with one-click PDF generation, and data processing macros that replace hours of manual work.
My track record: built 130+ engineering calculators across 13 disciplines, automated emissions calculations that cut facility reporting from 3 days to 5 minutes, and rebuilt a company's PSV/DEI reporting workbook with Peng-Robinson EOS calculations and VBA automation.
If your team is copying data between spreadsheets, running manual calculations, or waiting on consultants for routine reporting — I'll build a tool that handles it.
FAQs
Yes. Send it over and I'll assess what needs to be rebuilt vs improved. Often I can keep the structure and add protection, validation, and automation on top.
Yes — EPA Subpart W, OOOOa/b/c, fugitive emissions, combustion, and more. I know the methodologies, not just the formatting.
That's the goal. Every workbook includes an instructions sheet, input validation with error messages, and protected formulas so users can't accidentally break anything. Premium tier includes a video walkthrough.
Contact for pricing