Cup Draw Simulator — Excel Edition

Andrew Moss
4 min readMay 13, 2022

Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup.

I’ve built the virtual equivalent in Excel. Of course, it cannot replicate the experience of picking balls out of a bag, pot or capsule, but it’s the next best thing!

I’m giving you free and unfettered access to the workbook so you can run your own draws and customise it as you require. That’s right, you can view and edit all the formulas and VBA code!

Let’s have a dekko at the workbook.

Worksheets

Setup

Before commencing with the draw, you must decide on the round and participants.

The process is:

  1. Choose the round from the dropdown.
  2. Input the club names into the table.
  3. Click the Proceed to Draw button.

A green circle and the Proceed to Draw button will only appear when the table is fully populated.

Draw

This is where the draw takes place.

The Draw Menu contains a group of Form Controls that determine what happens on the canvas.

1. Reset

Clears the canvas completely.

2. Instant Draw

Runs a complete draw immediately.

3. Shuffle Draw

--

--