Browse the docs
Mapped against the library
Coverage
How the planned language handles the model families in the More Models library: 741 workbooks across twelve sectors and twenty structuring topics.
868files in More Models
741Excel workbooks
232workbooks scanned, up to two per folder
2,838sheets read for labels and structure
The library covers twelve sectors and twenty structuring topics, from simple training exercises to lender and bid models. Every family below was checked against Rufineer. Where something could not be written cleanly, the language was extended; those rows say v0.5.
By sector
| Family | Seen in the library | What the models do | Rufineer | Since |
|---|---|---|---|---|
| Solar and wind | A. Solar Models (41), B. Wind Models (21), Purchase Evaluate, Solar LCOE | P50 with an uncertainty, degradation, monthly seasonality, inverter replacement, merchant tails, parallel P50/P99 models | pvalue, seasonal, level, under | v0.2–0.4 |
| Hydro | F. Hydro Models (7) | Hydrology by year, tariff tables, flexible debt structuring | tables by year, DSCR profiles, repayment profiles | v0.2 |
| Thermal, IPP and merchant | C. IPP and Thermal (16), K. Commodity and Merchant (5), GE A-Z (16) | Heat rate and its degradation, fuel prices, spark spreads, capacity and energy charges, forced outages, overhauls by running hours, sale at exit | bands, | every N of line, pv_ahead, under | v0.5 |
| Biomass, biogas and waste | G. Biomass (53) | Feedstock tonnes, RIN and LCFS credit prices, plant roll-outs | tables, stages, groups | v0.4 |
| Upstream oil and gas | D. Upstream Oil (33) | Production curves, cost-recovery pools, profit oil by sliding scale or R-factor, royalties, milestone bonuses, hedging, reserve-based lending, abandonment | .available, bands, tiered, event, pv_ahead, | sampled, hedge | v0.5 |
| PPP and infrastructure | D. Infrastructure – PPP (20), Malaysia Toll Road (14), Toll Road and Transport cases | Monthly operations with six-monthly financing, availability payments, value for money, bid tariff at a target IRR, lifecycle reserves, grants, adaptation vs business-as-usual | rulers, seek, under, grants in funding | v0.5 |
| Shipping | L. Shipping (6), Australian Shipping (6), Ocean Rigs | Charter days, dry-dock days by age, charter rates with a lag, tonnage tax, returns in USD and PKR | overlap, | lag, bands, in | v0.5 |
| Portfolios of small assets | E. Consolidating Separate Projects (21): telecom towers, rooftop solar, battery leases, energy efficiency | A project database, one template sheet per asset, include flags, consolidation, holding-company tax | module site[p] for p in … where …, sum(site[*].x) | v0.5 |
| Nuclear and technology LCOE | I. Nuclear, Z. EDF Files (17) | Capital recovery factors, LCOE by technology | level, lcoe, function | v0.4 |
| Corporate and real estate | Interview exams: hotel, private equity, corporate | Monthly P&L and balance sheet, LBO returns | statements, balances | v0.1 (partial) |
By structure
| Family | Seen in the library | What the models do | Rufineer | Since |
|---|---|---|---|---|
| Debt sizing and bidding | C. Section 1, B. Debt Sizing Exercises | Lower of gearing and DSCR, bid price at a target IRR, development fee as a share of cost | min, seek, gross_up | v0.4–0.5 |
| Funding during construction | C. Section 2 (12) | Equity first or pro rata, equity bridge loans, IDC and fee loops, DSRA pre-funding | funding first … then, solve, equity_bridge_loan | v0.4–0.5 |
| Repayment and sculpting | C. Section 3 (16), Sculpting Course (11), Curved Sculpting | Sculpting, changing DSCR, level repayment, balloon, bullet, negative cash flow years | repayment profiles, DSCR series, clamp | v0.5 |
| Multiple debt issues | C. Section 13, Consolidated Debt Issues (6) | Tranches with their own terms, LLCR-based allocation | for t in tranches, pv_ahead | v0.4–0.5 |
| Credit enhancements | C. Section 5 (9) | DSRA, MRA with changing periods, cash sweeps, letters of credit | reserve, when, waterfall | v0.2–0.4 |
| Refinancing and mini-perms | C. Section 9 (7) | Refinancing on a date, sweeps, repricing, balloon take-out | refinance, balloon | v0.5 |
| Cover ratios and credit | C. Section 10 (6), Debt Default and Debt IRR | LLCR, PLCR, default and recovery | pv_ahead | v0.5 |
| Circular references | D. Circular References (109) | Copy-paste macros, VBA functions, parallel models, goal seek, data tables | solve … by paste | function | algebra, under, seek, results | v0.5 |
| Tax equity | F. Tax Equity Structures (63) | Partnership and yield flips, capital accounts, DRO, minimum gain, ITC and PTC, MACRS and bonus, back leverage, sale-leaseback, inverted lease, transferability | split … among, event flip, capital_account, lease | v0.5 |
| Bonds and securitisation | Consolidated Debt Issues, Bond Financing Case, Daily Bond | Notes over a pool of loans, price, yield, WAL, prepayment penalties, servicing fees, daily accrual | bond, portfolio, step day | v0.5 |
| Timing | Timing Issues, Monthly Cash Waterfall, Monthly Accumulation, Actual and Forecast | Mid-period COD, half-year and quarter ends, monthly to annual roll-ups, actuals | .share, rulers, | actuals | v0.4–0.5 |
| Development and risk | C. Section 14 (9), Development Probability, Value for Money | Stage probabilities, simulations, probability-weighted value, public sector comparator | results … weighted, under | v0.5 (Monte Carlo open) |
| Terminal value and options | C. Section 8 | Contract extensions, choosing the best strategy at the end of a PPA | pv_ahead, max across under cases | v0.5 (partial) |
| Working capital and losses | J. NOL Analysis (6), Working Capital | Receivables and payables, losses with expiry and limits | working_capital, tax_losses | v0.2 |
Not covered yet
- Hour-by-hour battery dispatch that chooses when to charge. Rufineer reduces 8,760-hour profiles to monthly or yearly factors; dispatch itself stays outside the model.
- Monte Carlo with thousands of runs.
resultshandles tens of cases; larger runs are an open decision. - Macros that pick the best strategy in each period (real options). Rufineer can compare whole strategies with
under, not re-choose period by period. - Hotel and corporate operating detail (room nights, segments, comparables). The building blocks work, but there is no library support.
A note on method
The library's own Modelling Philosophy deck argues for mathematics over copy-paste macros, key drivers you can see (USD/kW-year, yield, performance ratio, the standard deviation behind P90), few functions, and more checks. Rufineer takes the same line. by algebra and the closed forms in the standard library come first. by function suits a live model. by paste stays the default for FAST lender models.