I made an e-fed tracking spreadsheet and want to share it
Apr 10, 2019 16:25:41 GMT
MordecaiXLII likes this
Post by dnmt on Apr 10, 2019 16:25:41 GMT
So I've created a Google Sheet that I am going to use to run my NJPW e-fed instead of Fire Promoter.
Here is the file. And here's how it works:
Go to File > Make a Copy and save it. This way you can edit your own copy as this link is view-only.
I've put a simple test match in there so you can see how things work. Hopefully this makes it easier to manage your e-fed if you are not using Fire Promoter, or as a way to supplement what you do in Fire Promoter anyway. Let me know if you have any questions!
Here is the file. And here's how it works:
Go to File > Make a Copy and save it. This way you can edit your own copy as this link is view-only.
- Roster - This sheet is where you track your roster. Type the exact name of each wrestler on your roster in this field, as well as their stable if applicable and weight class. The Match, Win/Loss/Draw, Win % and Average Match Rating fields are all formulas that pull data from the Match Tracker.
- Show - This sheet is just for record keeping purposes and doesn't affect any formulas anywhere else. I also copied the format of this page from another e-fed spreadsheet I found a while ago. Please let me know if this is your format and I will give you credit as I totally forgot where I found it. Use this sheet to fill in your cards in advance and the match results. There is one formula that calculates a total show rating that is just an average of all the match ratings.
- Results - This sheet is also for record keeping. Just copy and paste the values from the Show sheet into here and you can scroll down to view a record of your shows.
- Match Tracker - This sheet is used to generate all of the stats on the Roster sheet. As long as all of your wrestlers' names are typed the exact same way on both the Roster and Match Tracker, the Roster sheet will update and reflect the stats you put in the tracker. So you'd fill out the Show sheet, fill in the Tracker, and then clear out the Show sheet once you've pasted it into Results while keeping everything in the Match Tracker so your stats stay updated. Please note, I have not really figured a way to do multi-man or Battle Royal matches here. For the time being, just put the winner in the Blue Corner and the losers in the Red Corner slots as that will calculate the wins/losses in the most accurate way possible.
- Championships - Just a sheet to track titles. I might try to integrate some more data from the Tracker into this sheet but for now this is just a spot to track who your champions are.
- Settings - Just a reference to make sure you have your sim settings consistent.
I've put a simple test match in there so you can see how things work. Hopefully this makes it easier to manage your e-fed if you are not using Fire Promoter, or as a way to supplement what you do in Fire Promoter anyway. Let me know if you have any questions!