Topic
- Reporting & Data Visualization
Featured Apps
Table of Contents
Finance wants total spend under $65,000. Working backward to that number happens in a spreadsheet nobody else can see.
Budget planning often runs backward.
Finance doesn’t ask “what will we spend”; they set a number, total spend under $65,000, a 12% cut from last quarter, and the job becomes finding which levers get you there.
That’s exactly what Goal Seek is built for: set the target, and it solves for the input. It’s not something a wiki page can do on its own, any more than it can calculate forward.
Confluence’s native tables can hold a budget, but they can’t work backward from a target; no formulas, nothing that solves for an unknown.
So that kind of math ends up happening somewhere else: an Excel file attached to the page, or linked from it, where someone tests numbers by hand until the total lands close enough. The Confluence page holds a stale snapshot of the answer, not the tool that found it.
Excel-like Tables for Confluence puts Goal Seek and Data Table on the page itself.
What this looks like in practice
A 15-person Marketing Ops team is building its Q4 budget ahead of a CFO review.
Finance has set the number: total department spend needs to land under $65,000, down from $75,000 planned. The Ops Manager’s job is finding the cut percentage across variable spend: ad spend, contractor costs, software, that gets there exactly, not approximately.
The working file is Q4_Budget_Model_v14_FINAL.xlsx, attached to a Confluence planning page.
Hitting the target means testing cut percentages by hand (try 12%, check the total, try 14%, check again) until the number is close enough.
Confluence’s native table holds a simplified summary for reference, but it can’t solve for anything; it just displays whatever the spreadsheet last said.
What breaks without a way to solve for the target directly
- Hitting an exact total means testing percentages one at a time in a disconnected spreadsheet, instead of solving for the number directly.
- When Finance moves the target mid-cycle, the Ops Manager starts the trial-and-error over from scratch.
- Showing the CFO several cut levels side by side (what does 10% look like versus 15%) means building a separate calculation for each one by hand.
- A new department lead added mid-cycle can’t see or adjust the model; Confluence access doesn’t help if the real math is in an attachment only certain people have.
- When the CFO asks about a level that wasn’t pre-built, the answer takes a day instead of a minute
Each of these gets worse as the target moves and more stakeholders want to see different levels, which is exactly what happens as a budget cycle matures.
How Excel-like Tables for Confluence fixes this
Excel-like Tables brings Goal Seek and Data Table directly into the Confluence page.
Set the total spend target in Goal Seek, point it at the input you can actually flex. The ad spend cut percentage, say, and it solves for the exact number, instead of you testing values by hand.
When the CFO wants to compare outcomes at several cut levels, a Data Table generates the whole grid in one step: 5%, 10%, 15%, 20%, each with its calculated total right next to it, instead of a separate formula built for every option.
Key capabilities for this scenario:
- Goal Seek → solve backward from a target total to the exact cut percentage needed, no manual trial and error
- Data Table → generate a full grid of outcomes across a range of cut levels in one step
- 450+ Excel-style formulas → the underlying budget math: category totals, rollups, runs the same way it would in Excel
- Excerpt Macro → publish the live result to the leadership review page, staying current as the model changes
- Cell Linking → roll up individual department budget sheets into one consolidated view for Finance
- Version-free real-time collaboration → Ops, Finance, and department leads work from the same live model; No more “v14_FINAL” file names
What changes for your team
The Monday before a budget review used to mean testing cut percentages by hand until the total looked close enough. Now Goal Seek gets to the exact number directly, and when the CFO wants to see it at a different level, the Data Table already has the grid built.
In the review itself, when the CFO asks to see the outcome at 20% instead of 15%, someone points to the row in the Data Table instead of promising a follow-up.
Built for the people running this
Business Analyst / Operations Manager (including Finance/FP&A budget owners) — You’re the one who has to hit a number Finance set, not just report what was spent. Goal Seek gets you there directly instead of by trial and error, in the same place your team already collaborates.
Team Lead / Department Head — You need visibility into your department’s numbers without owning the spreadsheet yourself. With Excel-like Tables, you see the same live model everyone else does — no waiting for someone to export and send you the current version.
Head of PMO / Director of Operations — You’re accountable for one consistent view of budget across departments, not five spreadsheets in five inboxes. Cell Linking and cross-page dashboards give you that rollup without chasing anyone for their latest file.
Want to see it built step by step?
Watch the What-If Analysis walkthrough video for a live look at using Goal Seek and Data Table like this.