Personal Projects

If it goes into groups, it belongs here

You don’t need to be a school, a hospital, or a procurement team. You just need a list of things and a set of rules about how they should be divided. Fantasy league draft. Board game tournament brackets. Splitting shared expenses across housemates. Organising a book club reading list across months. If you’ve ever stared at a spreadsheet trying to sort things fairly into groups, this is the tool.

Same optimisation engine. No code required. Works on any problem you can put in a CSV.

Start Free Trial — 14 days free, no credit card.

Your problem. Your rules. Your columns.

Balanced Allocate doesn’t know what your data means. It doesn’t need to. You upload a spreadsheet, tell it which columns matter, and set your constraints. The solver treats every problem the same way: distribute items into groups while respecting every rule simultaneously.

The columns can be anything. The groups can be anything. The rules can be anything. If you can describe it as “put these things into these buckets while satisfying these conditions,” the tool handles it.

Five problems you probably didn’t think needed an optimiser

Fantasy sports draft

You and 7 mates are drafting fantasy teams from a pool of 160 players. Each team needs a goalkeeper, defenders, midfielders, and forwards. You want to maximise total rating per team while keeping every team competitive. Upload the player pool, set position quotas and rating balance, and generate 8 fair teams in seconds. Settle the “rigged draft” argument permanently.

Shared house chore rotation

Four housemates, twelve chores, rotating monthly. Nobody wants bins three months in a row. Some chores take longer than others. Upload the chore list with time estimates, set a balance rule on effort hours, and generate a fair quarterly rotation. Export it and stick it on the fridge.

Book club reading schedule

Twenty-four books across twelve months. You want a mix of genres each month, no two books by the same author in the same month, and the longest books spread out so no month is a slog. Upload the book list with genre, author, and page count. Set balance on genre, a keep-apart relationship on author, and a budget on page count per month.

Tournament brackets

Thirty-two players in a round-robin pool stage. Eight pools of four. You need players seeded so the top 8 are spread across pools, club affiliations are separated, and geographic regions are mixed. Upload the player list with seed, club, and region. Balance all three. Done.

Moving day box packing

You’re packing forty-odd items into six boxes. Each box has a weight limit and a size limit. Fragile items need to be spread across boxes so one drop doesn’t destroy everything. Priority items go in the last-loaded box (first out). Upload your item list with weight, size, fragile flag, and priority. Set budgets on weight and size, a quota on fragile, and a preference for priority items. The solver packs your boxes.

How it works

Step 1: Make a spreadsheet

Any CSV or Excel file. One row per item. Columns for whatever matters — ratings, categories, costs, tags, relationships. If you don’t have a spreadsheet yet, build one directly in the app.

Step 2: Set your rules

Budgets cap numeric totals per group. Quotas require counts or percentages. Balance spreads values evenly. Relationships keep items together or apart. Preferences steer items toward specific groups. Maximise and Minimise concentrate values where you want them. Mix and match as many as you need.

Step 3: Run and export

The solver finds the optimal allocation in seconds. Review the results, check the validation, and export as Excel, PDF, or CSV.

The result

Without Balanced Allocate: an hour of shuffling, a result that’s “good enough,” and a nagging feeling you missed something.

With Balanced Allocate: minutes of setup, a provably optimal result, and an audit trail that shows every rule was satisfied. For the things that matter, “good enough” isn’t.

Try it yourself

No sample data for this one — the whole point is that your problem is unique. Upload whatever you’ve got. Download the Balanced Allocate User Guide full examples, walkthroughs, constraints and dataset formats.

Your data stays in your browser session. Nothing is stored on our servers.

Got a list? Got rules? Got groups?

Start Free Trial — 14 days free, no credit card.