Team workload allocation
Assign indivisible tasks to the person with the lowest projected utilization.
Your starting point
LOCAL · PRIVATESample values are filled in. Change them to make this your own.
A little more clarity
RESULTYour result will appear here.
Run the sample to see how it works.Use this tool
- List unique people and their available hours for one planning period.
- List indivisible tasks and required hours.
- Calculate, then inspect task assignments and each person’s utilization.
Reading your result
Tasks sort longest first. Assignment chooses the lowest utilization after adding that task. Above 100% means the person is over capacity, not that hours were removed.
How this works
Sort longest tasks first; choose the person whose utilization after assignment would be lowest.
Use the units shown beside each field. For monetary amounts, use one currency throughout; calculations do not convert currencies. Results normally display up to two decimal places. Nonzero values below 0.01 use up to six significant digits; values below 0.000001 use scientific notation (for example, 1E-7 means 0.0000001). Rankings use unrounded values, so displayed scores can look equal without being tied. CSV downloads retain numeric precision. Monetary rounding uses half-away-from-zero. Inputs or results beyond supported precision are rejected.
Assumptions & limits
A greedy estimate, not an optimal or skills-aware schedule. Over-capacity assignments remain visible rather than silently dropping work.
CSV inputs support quoted commas, doubled quotation marks and quoted line breaks. Headers are case-sensitive; a maximum of 500 data rows and 200,000 characters applies per table.
Results are planning aids based on the values you enter. Check important decisions and documents before using or sharing them.
