First, I'm quoting the discussion from the Q & A to get things started.
robthorn24 wrote:Timberwolf wrote:Those of you who run offline feds, what is your method of record keeping - spreadsheet, word document, the old school pencil and notebook, etc?
And what records do you keep? All matches? Or just the title/important matches?
I'll be running a couple of my feds offline and am trying to figure out a method of record keeping that works best for me. I'm hoping to get feedback from others. Thanks.
Here's a good video from Lord Worm on his formatting using an Excel spreadsheet, as well as a download link for said spreadsheets.
This is actually a timely question for me, as well. I want to use an Excel Spreadsheet for mine, although I'm going to need to figure out how to calculate the formulas. For mine, I want to create a round robin table of 24 wrestlers and have it calculate a "standings" list, based on what happens in the round robin. It's probably complicated, but there must be a way to do it.
Hopefully someone can answer Rob Thorn's question. Here's my question. I made a simple standings sheet for my shoot fighting fed (pictured below).
My question is - what is the formula for the winning percentage column? I would like for the formula to calculate the winning percentage as follows: Wins divided by (Wins + Losses) rounded to the nearest thousandth. For example, 3 wins and 1 loss would result in a winning percentage of .750. If anyone can help me implement a formula for the percentage column, I would greatly appreciate it.