Free Handy Tools

Group Project Workload Split

Separated by commas. Two people with the same name are numbered rather than merged.

Piece of workWeightDoing it

Gap between the most and least loaded

31.8 pts

Amara is carrying the most and Ben the least, measured against an equal share of 25%.

  • Amara10 of 22 · 45.5% · +20.5 pts on an equal share
  • Ben3 of 22 · 13.6% · −11.4 pts on an equal share
  • Chi4 of 22 · 18.2% · −6.8 pts on an equal share
  • Dev5 of 22 · 22.7% · −2.3 pts on an equal share
An even split would be5.5 each
People sharing it4
Weight nobody has taken0

A weight is whatever scale the group agrees on — hours, a one to five for effort, pages, anything used consistently. The tool never invents one, because there is no general answer to how a slide deck compares with a literature review, and any number put here by a stranger would be a guess dressed as a standard. What it does is turn the group’s own numbers into the one sentence nobody wants to say first: this person is carrying more than a quarter of it.

Headcount is the wrong denominator

Four people, four jobs, everyone happy — until you notice that one of those jobs is the analysis and another is booking a room. Dividing a project by the number of people in it only produces a fair split when the pieces are the same size, and they almost never are. Every group knows this within a fortnight, and the thing that makes it hard to raise is not the unfairness but the absence of a number to point at. This tool exists to produce that number.

Four names and six jobs

Suppose the literature review is weighted 5, the survey design 3, data collection 4, analysis 5, the slide deck 2 and presenting it 3. Amara has taken the review and the analysis, Ben the survey design, Chi the data collection, and Dev the deck plus the presentation. Twenty-two points of work are on the board, so an even split would be 5.5 points each.

Amara is holding 10 of the 22, which is 45.5 per cent against an equal share of 25 — a little over twenty percentage points more than her quarter. Ben holds 13.6 per cent, and the gap between the heaviest and the lightest load is 31.8 points. Nobody in that group needed a tool to sense the imbalance, but the sentence "Amara is carrying nearly half of this" is a great deal easier to say out loud than the feeling that preceded it.

The output is the imbalance, not the allocation

This is not a scheduler and it will not tell you who should do what. The group already knows who is doing what; what it lacks is a shared view of what that adds up to. So every row shows the same three things: the weight one person is carrying, that weight as a percentage of the work handed out, and the distance in percentage points between their share and an even one. The headline figure is the spread between the busiest and the least busy member.

A person with nothing against their name is called out separately, because a zero row is easy to skim past and is usually the most important line on the page. Sometimes it means the list is incomplete. Sometimes it means the split is.

Why unclaimed work stays out of the shares

Jobs nobody has taken are counted and reported, but they are deliberately excluded from everybody’s percentage. Spreading them evenly across the group would improve every single share at once and make the split look more balanced precisely because work is going undone, which is the opposite of what a fairness check should do. Keeping them separate means the shares describe reality — who is doing what right now — while the unclaimed total sits beside them as a question the group still has to answer.

The weights are yours

Nothing here ranks a literature review against a slide deck. That comparison has no general answer, depends entirely on the module and the people, and any figure supplied by a stranger would be a guess wearing the costume of a standard. Use whatever scale the group can agree on and apply it consistently: estimated hours, a one-to-five for effort, pages, slides, or interviews to run.

Agreeing the weights is also the useful part of the exercise. Most group disputes are not really about who did more; they are about two people holding silently different beliefs about what a job was worth. Arguing about the numbers before the work starts is far cheaper than arguing about them the night before submission.

Setting the weights, and using the result

What scale should we use for the weights?

Estimated hours are the easiest to agree on because everybody understands the unit. Where a job is unpredictable rather than long, a one-to-five effort rating works, provided the whole group rates every job on the same scale.

Two of us have the same first name. Does that break it?

No. Repeated names are numbered automatically, so two people called Sam appear as separate rows rather than being silently merged into one, and each keeps their own tasks and their own share.

Should an even split always be the goal?

Not necessarily. Groups reasonably agree that someone taking a lighter load this time carries more on the next assignment, or that a member with a job or caring responsibilities does less. The value is in the imbalance being visible and agreed rather than assumed.

Can I use this as evidence with a tutor?

It is a summary of numbers your group typed, so it carries exactly the authority the group gives it. Agreeing the weights together, at the start, makes it far more persuasive than a table assembled afterwards by whoever felt hardest done by.