DQ

Sheet to Dashboard

The same eight rows, read two ways

Fictional data
Try this Change any number on the left. Every figure, bar and label on the right recomputes as you type. Nothing here is hardcoded.
1You edit this
Branch Region Target Actual Staff
Three things worth trying
  1. Set Highland's actual to 500,000. It moves from last place to first in Branch status, and its bar turns green.
  2. Type a new name into any Region cell. A fresh region appears in the rollup on the right.
  3. Delete a few rows, then press Reset data to bring the original eight back.

Nothing is saved. Refresh the page and it returns to the numbers you see now.

2This updates as you type nothing here is typed by hand
Total actual
0
against target
Attainment
0%
of combined target
Per head
0
across all staff
On target
0
branches
Actual against target
Bar length is actual. The dark line is that branch's target.
Branch status
Sorted by how far each branch sits from its own target.
By region
Rolled up from the rows on the left, live.
Fictional data. Every number on the right is computed from the table on the left. Sheet_to_Dashboard_Demo.html