Office add-ins
Your models and reports, now live.
The same numbers you see in Singlepane, flowing into Excel, PowerPoint and Word. Build your models and owner reports once, then refresh them instead of rebuilding them.
=SP.FINANCIALS($B4,"Total Revenue - 100","AugYTD",2026,"Actual")| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Harbor Point Resort | Code | Actual | Budget | Var |
| 2 | Aug YTD 2026 | HBV | $000s | $000s | |
| 3 | |||||
| 4 | Total Revenue - 100 | HBV | 11,910 | 11,624 | 2.5% |
| 5 | Rooms Revenue - 110 | HBV | 8,214 | 7,980 | 2.9% |
| 6 | F&B Revenue - 200 | HBV | 2,871 | 2,902 | -1.1% |
| 7 | GOP - 500 | HBV | 4,362 | 4,410 | -1.1% |
| 8 | EBITDA - 600 | HBV | 3,118 | 3,205 | -2.7% |
Singlepane for Excel
Infinitely customizable reports and models on live data
Whether you are a power user who wants to unleash the full power of Excel or you are automating an existing corporate report, the add-in puts every hotel, account, period and version one formula away.
SP.FINANCIALSAny GL account from P&Ls, budgets, forecasts and pro formas. Months, quarters, YTD, balance of year and trailing twelve.
ReferenceSP.FINANCIALS_AGGThe same, aggregated across a list of hotels or a nested SP.FILTER.
ReferenceSP.STROccupancy, ADR, RevPAR, indexes and ranks for the subject, comp sets or market scale, by day, week, month or trailing period.
ReferenceSP.OTBOn-the-books and pace data, daily or monthly, this year or same time last year, by segment.
ReferenceSP.FILTERA list of property codes from up to five filters: ownership, brand, operator, market, fund, lender and more.
ReferencePlus a My Properties tab, a USALI reference tab and MFA sign-in, created for you on login.
All Excel guidesSinglepane for Office
Drop a tag into the deck. Refresh. Done.
Type placeholder tags like <<Total Revenue>> into PowerPoint or Word, connect each tag to a Singlepane query, and refresh every number in one click. Monthly owner reports, lender updates and board decks stop being a copy-and-paste exercise.
- Global variables. Set Month, Year or Hotel Code once. Next month, change one value and refresh.
- Financials, STR, OTB and rates queries, plus computed variables for variances and percentages.
- Finalize when you are ready to send a static copy.
Deterministic
The same tag or formula returns the same number every time.
Refreshable
Rebuild nothing. Change the month, click refresh.
Auditable
Every figure traces to a Singlepane account and period.
Claude skills for Office
Describe the model or report you want. Claude builds it wired to live tags and formulas.
Skills teach Claude how the add-ins work. Ask for a twelve-month variance model or a monthly owner deck and get a workbook or presentation built on SP functions and Office tags, ready to refresh.
See your portfolio on one single pane of glass
Book a live demo with our team. We will walk through the platform using the questions your asset managers are asking today.