Joined
·
623 Posts
FITD Management for Starters
The Management in a FITD Tournament can be a difficult task, so here there are the steps I follow as a manager.
The attached files are Excel Files (.xlsx), I use them on a Microsoft Windows computer.
32 players draw (new file): https://1drv.ms/x/s!ArlMgkfDfofvgSZUJviTSevZt4EA
32 players draw (old file): https://1drv.ms/x/s!ArlMgkfDfofvgSH6L9uJqmKC6Q2G
64 players draw: https://1drv.ms/x/s!ArlMgkfDfofvgSyS8TapHb_-gxNu
128 players draw: https://1drv.ms/x/s!ArlMgkfDfofvgSR0E_VVFYdoGQjk
The files have 4 tabs:
01 MTF Participants
02 Start
03 Results
04 Sorted Results
The process of FITD Management has 8 steps.
-------------------------------------------------------------
Step 1: Fill the 01 MTF Participants Tab
Process: Slow
You have to Type the name of each MTF Participant in the Row 2, and paste the predictions from row 9 to 44, starting from column C, then column F, etc.

Empty Template

Template Filled with MTF Participants and predictions
-------------------------------------------------------------
Step 2: Fill the 02 Start Tab
Process: Fast
You have to Type the Main Draw of the tournament in the A Column of the tab. This Draw has to be the Final Draw, with all the Qualifiers, Lucky Losers, etc.

Empty template

Template with filled draw (some numbers and names appear automatically)
-------------------------------------------------------------
Step 3: Look the 03 Results Tab
Process: Very Fast
You have to look at the 03 Results Tab, where there should be the name of every MTF participant. Here you can check how many participants are in the tournament.

Bottom of the 03 Results Tab. There are 51 MTF Participants.
-------------------------------------------------------------
Step 4: Back to the 01 MTF Participants Tab, and correct entries.
Process: Slow
In this step you have to correct manually some entries.
To know what entry has to be corrected, in the cell to the left it will show #N/A. If it doesn't have to be corrected, the cell to the left will show OK.

Start of the process.

This MTF Participant has an "OK", there is nothing to correct in his predictions.
Some entries will have "Qualifier" or "Q", you have to type the name of that particular player.

This MTF participant has ERROR to the left of his name, there are things to correct.
A cell says #N/A, the cell to the right has to be corrected.
The "Qualifier" cell has to be corrected with the name of the tennis player.
Some entries will have the name of a player with a mistake, you have to manually type the correct name.

The name of the player has 'zc', it has to be corrected to 'cz'
Some entries look like there are correct, but there is an invisible space after the name. You have to manually delete that space to get the correct name.

There is an invisible space in the cell, after the name of the player; it has to be deleted.
Some entries have a correct name, without a space after the name, but the player has withdrawn from the tournament, and replaced by a Lucky Loser. You have to manually type the name of the Lucky Loser player.

Harrison withdrew before the star of the tournament, so the pick has to be replaced with the name of the Lucky Loser. The same situation happened with Pella, in the pick of the other MTF Participant.
In the A1 cell, the number will show how many participants have their picks fully corrected. When the number in the A1 cell is equal to the number of MTF participants (seen in step 3), the Step 4 will be finished.

Before the corrections, there is a "49" (49 MTF participants have the "OK" sign left to their names)

After the corrections, there is a "51", which is the correct quantity of MTF participants in this tournament.
-------------------------------------------------------------
Step 5: Screen caption of 02 Start Tab
Process: Fast
You have to make a Screen Caption of the 02 Start Tab, and post it on the MTF thread.

Screen caption of 02 Start Tab
-------------------------------------------------------------
Step 6: Back to 01 MTF Participants Tab, and fill the tennis results.
Process: Fast.
In column A, you have to type the name of the winners of the tennis matches.
When a player receives a Bye, you have to write the name of the player, followed by a "(Bye)", in the same cell. This prevents giving point to the picks of these players.

The column A (left) has the winners of R1. The players who received a Bye have a "(Bye)" written in the cell.
-------------------------------------------------------------
Step 7: Copy the table of 03 Results Tab, and paste as values to 04 Sorted Result Tab
Process: Medium
When you complete the Step 6 for each round, the results in the 03 Results tab will update automatically.
The 03 Results Tab have cells with complicated formulas, so this tab has not to be modified. Instead, you have to select the table with the results, copy it, and paste as only values in the 04 Sorted Result Tab. Pasting as values makes each cell as simple names and numbers, without the complicated formulas. Now, you can sort the pasted table from maximum to minimum Total points, changing colors, etc.

03 Results Tab. Note the complicated formula of a cell (Spanish version)

04 Sorted Results Tab. Here the results can be sorted from maximum to minimum, and add some colors. To be correctly sorted, the total points column should be copied to a column to the right of the winner pick column, and sorting selecting this copied column.
-------------------------------------------------------------
Step 8: Screen caption to 04 Sorted Results Tab.
Process: Fast
You have to make a screen caption of the sorted results, and put it on the MTF thread.
When each round of the tournament is completed, you have to repeat steps 6, 7 and 8.
-------------------------------------------------------------
This set of 8 steps is the process that I find easy to follow, and that I have used in the few managements I have participated. I'm sure other FITD Manager use different Excel Files, with a different process and different steps, but I hope this one may be helpful, at least for new managers without previous experience.