Built for
Refinery analysts, physical traders, and energy-risk teams
Private test release · Marketplace submission not yet started
Refinery margin workbook
Build a live crack-spread model without rebuilding the spreadsheet every morning
Generate a 3-2-1 and 2-1-1 refinery-margin workbook with source-timestamped WTI, gasoline, and distillate inputs, thirty-day component history, and 25 sensitivity cases.
The problem
Crack-spread models become fragile when market inputs, unit conversion, history, and scenario assumptions live in separate files.
Activated outcome
One auditable workbook that keeps the 42-gallon conversion and benchmark math visible.
One action, a finished workbook
- 1Configure an OilPriceAPI key for the current spreadsheet.
- 2Build a workbook from WTI, gasoline, and heating-oil source values.
- 3Review benchmark margins, component history, and crude/product sensitivity.
Generated sheets
Crack Model
Market Data
History
Sensitivity
The beta package requests access only to the current spreadsheet, its add-on UI, and outbound HTTPS requests to OilPriceAPI.
A funnel we can measure
- Marketplace listing views and installs
- Successful crack-spread workbook activations
- Campaign-attributed API signups and paid conversions
Successful data requests carry only a product/version header and reviewed market identifiers. Spreadsheet contents, formulas, cells, Google account identity, and API keys are not sent for analytics.
Release status
This product has a validated release package. Public installation is not yet available. It will receive a separate Apps Script project, Cloud project, OAuth review, screenshots, and Marketplace listing before public release.
Join through an attributed API signup