Reviewable row calculations
The analysis can prepare common totals, averages, counts, and grouped results from the selected data for reconciliation.
Prepare calculations, summaries, and explanations from selected spreadsheet data for review.
Spreadsheet analysis works from a selected workbook or delimited data file to calculate, group, compare, and explain the requested information. The workbook remains the source behind the result, and generated output can be reviewed before it is saved.
The analysis can prepare common totals, averages, counts, and grouped results from the selected data for reconciliation.
The result can explain what changed, what is unusual, and which rows drive the answer.
When requested, a reviewable workbook or table can carry the result into the document workflow.
Confirm sheets, headers, date ranges, units, and any excluded rows.
State the measure, grouping, comparison, and expected output.
Check totals and significant rows against the source before distribution.
Prepare calculations and summaries from the selected workbook, then reconcile the result.