Table Complete
Tables are the best thing in the world. With then you can create a very powerful tracking and reporting tool as outlined in this page.
Last updated: Tue 18-Aug-2026 afternoon
Executive Summary
Many of the projects that you track can be broken into two dimensions.
- Steps to build widgets.
- Phases of multiple projects.
By taking these two dimensions and putting them into a table you get
- Clear identification of the two dimensions.
- Clear status in each cell of (Dimension 01) x (Dimension 02).
- Clear heatmap to track progress.
- Adding percentage done in each cell gives you clear percentage done for each row and each column.
This page tells you how to accomplish the above and more.
Vision
You have a project to track to completion.
It can be broken into two dimensions of the project.
- Can be any dimensions - for example, widgets to make and the steps to make them.
- Each dimension can be broken into the effort for each widget, step, whatever.
You want to track how complete you are.
- How complete is each item in dimension one.
- How complete is each item in dimension two.
- How complete is the project overall.
Note that depending on the tools that you are using for your project management some of what this tool gives you may already be there. However, often existing tools may have difficulty:
- Communicating the exact dimensions that the stakeholders care about.
- Produce a heatmap that the stakeholders care about.
- Focusing the conversation where you want it focused.
As with any tool, pick the one(s) that provide the value that is needed.
Gathering Data
Before we build our table we will need to gather some data.
Dimensions
What are the two dimensions that we want to track?
Some examples are
- Widgets and Steps - let’s pick this one for the example
- Web Pages and Documents
- Watches and Steps to Purchase
- etc.
For each dimension you need to determine how many items there are.
- So, for the widgets this may be simple - we are going to build five widgets
- For the steps, it may be more complex.
- Some widgets have more steps than others.
- If so, see if you can consolidate and/or generalize the steps.
- If not, then just do the union of steps - say that four of the widgets have four steps but one has six steps.
- So, lets move forward to build five widgets with each taking six steps (knowing that for four of the five widgets one of the steps is n/a).
Size
Now we need to decide on the size of each widget and of each step. Think of size as a percentage as this is easier. It can work with other units but for now let’s assume percentage.
So, let’s look at dimension 01 Widgets.
The question to ask yourself is how big is each widget in a percentage basis.
You will have one of the following:
- You Know
- You know how big each item is compare to the others and can therefore easily assign the percentage size.
- You Know Relatively
- You can say that the first item is 10 points big.
- Then assign points to each of the remaining items.
- Then divide to get percentages.
- You Have to Guess
- You have no idea so you can guess.
- This is ok.
- You Cannot Guess
- It is so complex that you cannot guess.
- Fine - just make them all the same.
Recap where we are now
- We have the two dimensions.
- We have the number of items in each dimension - five widgets with six steps each.
- We have the size of each item in each dimension.
We can now construct the table (tables rule!!).
The Table
Construct the following table. Likely in excel but any way that you want to manage the table is fine.
Step 01: The Base Table
| Widget 01 | Widget 02 | Widget 03 | Widget 04 | Widget 05 | |||
|---|---|---|---|---|---|---|---|
| 20% | 20% | 20% | 20% | 20% | |||
| 01 | Step 01 | 10% | |||||
| 02 | Step 02 | 20% | |||||
| 03 | Step 03 | 15% | |||||
| 04 | Step 04 | 30% | |||||
| 05 | Step 05 | 10% | |||||
| 06 | Step 06 | 25% |
So, let’s look at the above table and appreciate what it shows us
- A column for each widget that we have to build.
- A row for each step that we will have to take to build each widget.
- We know that for four widgets they will not have one of the steps - so we can put in “n/a” into those cells.
- Each widget and each step has a percentage of the overall size associated with it.
- We now have a plan. See Status Reports for more details on plans and how to use them.
Step 02: The Heatmap
| Widget 01 | Widget 02 | Widget 03 | Widget 04 | Widget 05 | |||
|---|---|---|---|---|---|---|---|
| 20% | 20% | 20% | 20% | 20% | |||
| 01 | Step 01 | 10% | DONE | DONE | DONE | DONE | |
| 02 | Step 02 | 20% | DONE | DONE | |||
| 03 | Step 03 | 15% | n/a | n/a | n/a | n/a | |
| 04 | Step 04 | 30% | DONE | DONE | |||
| 05 | Step 05 | 10% | DONE | ||||
| 06 | Step 06 | 25% |
So, let’s look at the above table and appreciate what it shows us
- We can then fill into each cell “DONE” when we have completed that step for that widget.
- We may expect that the DONE’s will be filled in from top down and for most cases they might be. But they do not have to be.
- And we now have the first level heatmap of your plan and status against the plan.
Step 03: A Better Heatmap
| Widget 01 | Widget 02 | Widget 03 | Widget 04 | Widget 05 | |||
|---|---|---|---|---|---|---|---|
| 20% | 20% | 20% | 20% | 20% | |||
| 01 | Step 01 | 10% | 100% | 100% | 100% | 100% | |
| 02 | Step 02 | 20% | 50% | 10% | 100% | 100% | |
| 03 | Step 03 | 15% | n/a | n/a | n/a | n/a | |
| 04 | Step 04 | 30% | 100% | 100% | 90% | ||
| 05 | Step 05 | 10% | 100% | 50% | |||
| 06 | Step 06 | 25% | 50% |
We can improve the heatmap a little by filling in the cells with something more than just DONE.
Fill in the percentage done in each cell.
If you cannot determine what the percentage done really is you can use the following:
- 0%: Has not started
- 10%: Started
- 50% Half way done
- 90%: Mostly done
- 100%: Done
Note that if you can have the actual percentage done this is better. But if not, then the above rough percentages are good enough.
If you are using Excel (or similar) you can then conditionally code the table cells based on the percentage done giving you a more visual heatmap.
Step 04: Column and Row Totals
| Widget 01 | Widget 02 | Widget 03 | Widget 04 | Widget 05 | Totals | |||
|---|---|---|---|---|---|---|---|---|
| 20% | 20% | 20% | 20% | 20% | ||||
| 01 | Step 01 | 10% | 100% | 100% | 100% | 100% | 80% | |
| 02 | Step 02 | 20% | 50% | 10% | 100% | 100% | 52% | |
| 03 | Step 03 | 15% | 100% | 100% | 100% | 100% | 80% | |
| 04 | Step 04 | 30% | 100% | 100% | 90% | 58% | ||
| 05 | Step 05 | 10% | 100% | 50% | 30% | |||
| 06 | Step 06 | 25% | 50% | 10% | ||||
| Totals | 65% | 27% | 98% | 77% | - | 53% |
You can now add a row at the bottom and a column to the right side with the following.
- I’d recommend doing this now in Excel (or equivalent) to follow along with the rest of this page.
Note that in the table above we changed the “n/a” to “100%” done.
- This is to allow Excel to properly calculate the percentage done in the below analysis.
- You can colour code the former “n/a” cells in some manner to indicate that the 100% does not mean work actually done but work not needed (if this is important to you).
Bottom Row
- Each cell in the bottom row should be the dot product (SUMPRODUCT in Excel) of the following columns
- The percentages column for each row (10%, 20%, 15%, 30%, 10%, 25% in the example above).
- The column in that cell - so Widget 01, Widget 02, etc.
- This bottom row then has total percentage done for each column.
- So you now know the percentage done for each Widget.
Right Column
- Similar to above, each cell of the right column will contain the dot product (SUMPRODUCT in Excel) of the following rows
- The percentages row for each column (20%, 20%, 20%, 20%, 20%, 20% in the example above).
- The row in that cell - so Step 01, Step 02, etc.
- This right column then has total percentage done for each row.
- So you now know the percentage done for each Step.
So you can now answer the following questions
- How much percentage done is each Widget?
- How much percentage done is each Step?
You can add two more dot products (SUMPRODUCT in Excel) that will calculate the same thing.
- First Option
- The percentages column for each row (10%, 20%, 15%, 30%, 10%, 25% in the example above).
- The new right column.
- Second Option
- The percentages row for each column (20%, 20%, 20%, 20%, 20%, 20% in the example above).
- The new bottom row.
You now have a very crisp method of communicating:
- How done is each cell.
- How done is each column (i.e. Widget).
- How done is each row (i.e. Step).
See Status Reports for more details on plans and how to use them.
- We can answer Where Are We Today.
Step 05: Burn Up
So let’s say that you have the table with the bottom row and right column but have not as yet started the work.
The first question you should ask yourself is what is the plan to complete this work?
- How many weeks (or the appropriate time frame) will it take to complete?
- What percentage done will be accomplished each week?
Let’s assume that you decide:
- 10 weeks
- 10% most weeks but some weeks more and some weeks less as there is reality into the plan based on holidays, vacations, or other impactful things.
This means that you can create a plan for the work to be done.
- That plan is a simple burn up chart.
| Week | Plan | Actual |
|---|---|---|
| Week 01 | 5% | 2% |
| Week 02 | 10% | 8% |
| Week 03 | 15% | 15% |
| Week 04 | 30% | 32% |
| Week 05 | 40% | 35% |
| Week 06 | 50% | 55% |
| Week 07 | 60% | 53% |
| Week 08 | 80% | |
| Week 09 | 90% | |
| Week 10 | 100% |
Each week you fill in the cells of the Table Complete plan and see what the total work completed is and add this to your burn up chart to show the actuals.
- You now have a Burn Up chart with the plan and the actual.
- You can see of you are ahead, on-track or behind schedule just by looking at the two curves in the Burn Up chart.
- You can then create a status reports to report on the status of your project.
Here is a sample Burn Up chart.
---
config:
theme: dark
---
xychart-beta
title "Burn Up Chart"
x-axis [Week01, Week02, Week03, Week04, Week05, Week06, Week07, Week08, Week09, Week10]
y-axis "Percentage Done" 0 --> 100
line [5, 10, 15, 30, 40, 50, 60, 80, 90, 100]
line [2, 8, 15, 32, 35, 55, 53]
Key Takeaways
The tracking is simple: For Widget XX, how much of Step YY is done.
- A simple question.
- Ease to determine.
- Easy to fill in.
- Easy to track.
The clarity to those working on the project is high.
- It is very easy to see what work we are doing and tracking.
Size growth is trackable.
- If last week we thought that a cell was 90% done.
- But this week we realize that it is only 40% done.
- Just change the 90% to 40%.
- All the other numbers will update.
- You will get the new status.
Progress against the plan is easy to see in the Burn Up chart.
Appendix
Version History
| Date | Notes | |
|---|---|---|
| 01 | Mon 10-Aug-2026 | Initial version |
| 02 | Sun 16-Aug-2026 | Added more tables to aid in the description. |
| 03 | Tue 18-Aug-2026 | Added inline burn up chart. |