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.
Before commencing with the draw, you must decide on the round and participants.
The process is:
- Choose the round from the dropdown.
- Input the club names into the table.
- Click the Proceed to Draw button.
A green circle and the Proceed to Draw button will only appear when the table is fully populated.
This is where the draw takes place.
The Draw Menu contains a group of Form Controls that determine what happens on the canvas.
Clears the canvas completely.
2. Instant Draw
Runs a complete draw immediately.
3. Shuffle Draw
Similar to Instant Draw, except it recalculates a set number of times based on the Shuffles value. Use the spinner to increase or decrease it in increments of five.
4. Interval Draw
Runs the draw with a pause between each drawn club. The Interval (SS) value decides how many seconds this is. Use the spinner to change it.
Tick the Dynamic Canvas checkbox to make the canvas resize whilst the draw is taking place. This doesn’t affect the other two draw types.
A separate section on the left shows the current ball and the remaining ones to help you keep track.
The following applies to both worksheets.
There are two modes: Admin Mode and Presentation Mode.
Admin Mode has the ribbon, gridlines, formula bar and headings switched on.
Presentation Mode does the opposite. It’s ideal when you’re running a draw in front of people. They won’t even know it’s Excel!
Helper columns assist with the action on the front stage. Unhide them by pressing the + button. This will then change to –, which does the opposite.
As archaic as VBA is, it wouldn’t be possible to do everything you’ve seen without it!
Press Alt + F11 to open the Visual Basic Editor and access the objects and modules.
I didn’t set out to build an FA Cup draw simulator, but it just happened to be the direction I veered towards. If I had built a generic one, it would have been plain, dull and boring. Yes, functionality matters most, but if it’s going to be projected on a wall in a clubhouse, the presentational aspect is important, right?
Don’t consider this a finished product — version 1.00 is just the start. I will listen to your feedback and see what keeps springing up.
Here are a few of my ideas:
- greater personalisation — add the ability to change the colour scheme and logo
- additional draw types, such as group and single elimination
- option to include two clubs for a single ball in cases of not-yet-played matches
If you have any other suggestions, please do leave them in the comments. Likewise, report any bugs if you spot any.
A Windows desktop version of Excel for Microsoft 365 is required for maximum compatibility.