Reconcile a Summary and Chart to the Source
Build an event-level summary and inspect the data behind a proposed chart rather than trusting the visual alone.
Today's Goals
- Reconcile event totals to the eight-row source.
- Choose a chart whose labels and units match the question.
- Check the generated chart data tab and refresh limits.
Plain-Language Walkthrough
A summary is a second view, not a new source
The desk now has a reviewed formula, but a report can still mislead by moving numbers into an attractive layout without reconciling them. Build three event rows. Garden Walk has two confirmed seats, no recorded receipts, and USD 40 planned costs. Repair Cafe has four seats, no receipts, and USD 75 costs. Night Market has four seats, USD 20 receipts, and USD 135 costs from the permit and lighting lines. Column totals must be ten seats, USD 20 receipts, and USD 250 costs. The illustrative funding gap is USD 230. These checks use independent paths: sum source rows into each event, then sum events back to source totals.
The distinction between recorded receipts and planned costs is semantic as well as numerical. PaidUSD records cash attached to the fictional registrations. PlannedUSD is a budget intention, not an expense already paid. Subtracting them yields a planning gap under this exercise's narrow assumptions; it does not measure profit, cash balance, or future turnout. A chart title or executive sentence that calls the difference “loss” would change the claim. Write units into column headers and chart labels so the reader cannot confuse places with dollars.
Interview questions
What reconciliation proves an event summary matches the source?哪些对账能证明活动汇总与源表一致?
Common in ChinaCommon overseasBasic#gemini-sheets#spreadsheet-review🔒 Unlock this chapter to see the answer keys.
Why inspect the data behind a Gemini-generated chart?为什么要检查 Gemini 生成图表背后的数据?
Common in ChinaCommon overseasIntermediate#gemini-sheets#spreadsheet-review🔒 Unlock this chapter to see the answer keys.
How should seats, receipts, and costs be visualized without misleading readers?怎样呈现名额、收入和支出才不会误导?
Common in ChinaCommon overseasDeep dive#gemini-sheets#spreadsheet-review🔒 Unlock this chapter to see the answer keys.
