pozzum Posted October 17, 2015 Posted October 17, 2015 (edited) It allows for up to 300 roster members competing in up to 999 Matches. Also allows tracking 6 shows with Major, Minor, Tag, & Diva's Titles each. I've added in a Tag Team Table to help with the managing of tag teams, and a royal rumble page to generate stats from a royal rumble.Pre-Filled File:https://drive.google.com/open?id=0B1th8UfbFeobYTlWS1QtbmJpRmsEmpty File:https://drive.google.com/open?id=0B1th8UfbFeobTTEyVW9laG5ia1EIf you have any questions please let me know and I'll try to answer them.Also I am open to making changes or improvements so if anyone have ideas please let me know for future releases.Change Log: New features added in v1.3:Starting ELO Now Calculated from Overall Stats (Overall x 20 - 200 Default set to 85 for new stars)All Pre release information used to get starting overalls for Stars in the Base GameAdjusted Names to match those in the Pre-release VersionCreated a filled and Empty Version with the filled version matching the Pre-Release InformationUnlocked Roster Sheet to Allow Sorting within Each BrandMinor Bug FixesNew features added in v1.2:Inactive superstars will now have the roster highlighted blackAdded matches to the elo sheet where you can add in match counts from previous sheetsFree agents well now auto fill with the 50 highest ranked stars based on elo.New features added in v1.1:1 month improvement tracking3 month improvement trackingNote how many matches you have per showMinor bug fixes Edited October 24, 2015 by pozzum Added V1.3 Quote
EVOFIT Posted October 18, 2015 Posted October 18, 2015 Thanks for this will give it a try when I get the game.One question if I move a superstar from one show to another this shouldn't effect anything as long as I dont remove formulas wen I do it? 1 Quote
pozzum Posted October 18, 2015 Author Posted October 18, 2015 Thanks for this will give it a try when I get the game.One question if I move a superstar from one show to another this shouldn't effect anything as long as I dont remove formulas wen I do it?Him changing to another roster won't effect his rankings or history. I've also Locked out most of the formulas, just try not to cut and paste unless you are just going to paste as a value. ( normal cut and paste messes with formulas way too much) Quote
EVOFIT Posted October 18, 2015 Posted October 18, 2015 That's what I thought. Had another thought, would be cool to add another tab as a title tracker. So you csn keep track of who had held what title's & how many times? Quote
pozzum Posted October 24, 2015 Author Posted October 24, 2015 Pre-Filled File:https://drive.google.com/open?id=0B1th8UfbFeobYTlWS1QtbmJpRmsEmpty File:https://drive.google.com/open?id=0B1th8UfbFeobTTEyVW9laG5ia1ENew features added in v1.3:Starting ELO Now Calculated from Overall Stats (Overall x 20 - 200 Default set to 85 for new stars)All Pre release information used to get starting overalls for Stars in the Base GameAdjusted Names to match those in the Pre-release VersionCreated a filled and Empty Version with the filled version matching the Pre-Release InformationUnlocked Roster Sheet to Allow Sorting within Each BrandMinor Bug Fixes Quote
the King Lives Posted October 24, 2015 Posted October 24, 2015 okay so the last time i used this i think either svr 11 or wwe12 came out so i am somewhat new to this (obviously not excel) so is this just for current roster people or can it be used for caws legends etc. The one i used back then was moreso for the current roster only. Quote
pozzum Posted October 24, 2015 Author Posted October 24, 2015 okay so the last time i used this i think either svr 11 or wwe12 came out so i am somewhat new to this (obviously not excel) so is this just for current roster people or can it be used for caws legends etc. The one i used back then was moreso for the current roster only.If you are adding a caw simply type their name into the base sheet and the stats will be generated. You can go to the ELO sheet and set what you want their starting rank to be as well.If you don't want to use any of the stars you can simply delete their name When you first setup the sheet and then they will be removed from it. Just try to replace everyone that you delete so there isn't any blank spaces. (This is a current flaw in the sheet I might try to fix at some point) Quote
the King Lives Posted October 24, 2015 Posted October 24, 2015 okay so the last time i used this i think either svr 11 or wwe12 came out so i am somewhat new to this (obviously not excel) so is this just for current roster people or can it be used for caws legends etc. The one i used back then was moreso for the current roster only.If you are adding a caw simply type their name into the base sheet and the stats will be generated. You can go to the ELO sheet and set what you want their starting rank to be as well.If you don't want to use any of the stars you can simply delete their name When you first setup the sheet and then they will be removed from it. Just try to replace everyone that you delete so there isn't any blank spaces. (This is a current flaw in the sheet I might try to fix at some point) oh okay cool thanks lol Quote
d12345 Posted December 11, 2015 Posted December 11, 2015 Thanks Pozzum. Using this now for 2k16 Universe (cause in game stat tracking and rivalries are completely broken).I added a title history and rivalry tracker tab to your excel for me. Quote
pizzo Posted September 9, 2016 Posted September 9, 2016 adding a superstar is locked, i can't add any of my caws...i can edit shows and who is on shows but the count tab is locked...any help please? Quote
.png.d0e72cc2fb3a2265f1126da0cae79e00.png)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.