Compare a supplies plan

Fictional data / JPY, excluding tax

Compare quantities, unit prices, amounts and baselines in two groups. Repeated group labels keep the table readable without merged cells.

Two groups, subtotals and grand total
GroupItemQtyUnit (JPY)Amount (JPY)Baseline (JPY)Delta (JPY)
ACards2010020002200-200
AFolders1030030002800200
ALabels520010001200-200
ASubtotal60006200-200
BPaper1050050004500500
BPens2015030003200-200
BClips10100100010000
BSubtotal90008700300
A+BTotal1500014900100

Read the figures

  1. Amount = quantity × unit price. Delta = amount − baseline.
  2. Subtotal A: JPY 6,000. Subtotal B: JPY 9,000. Total: JPY 15,000.
  3. Baseline total: JPY 14,900. Overall delta: +JPY 100.

Note: the CSV stores precomputed values. This is not an automatic spreadsheet aggregation feature. All groups and amounts are fictional.