Mattanite's Draft Class Strength Generator

[Mattanite]

Quote: Originally Posted by JWDixon120

For those who may encounter Macro's being blocked for security issues, the fix is this:

Thanks for this. I don't know of a break function for the Rand formula in excel (calc once then stop) so had to put these in. Having the buttons made it feel a lot more drumroll, haha.

Sent from my H3113 using Tapatalk

[JWDixon120]

Quote: Originally Posted by Mattanite

Thanks for this. I don't know of a break function for the Rand formula in excel (calc once then stop) so had to put these in. Having the buttons made it feel a lot more drumroll, haha. Sent from my H3113 using Tapatalk

Macros are definitely the way to go! Functions a lot cleaner IMO


-Franchise Fidelity to Reality Roster out Now!
-Creator of JWDixon’s Franchise Spreadsheet
-More coming soon!

[Mattanite]

Worth noting - for shorter duration online leagues (say 5 seasons on 3 day advances), my recommendation was to use normal until the final two drafts where you'd then increase to strong, then very strong, for all positions. This was to counter draft pick decay due to fewer remaining seasons left and to avoid increasing xp sliders instead.

Sent from my H3113 using Tapatalk

[Nadz]

I can’t seem to find a way to make it work on iPhone or iPad as the iOS excel can’t run the macros…

Can somebody just run one sim up and post a screenshot so I can use it?

[Mattanite]

Quote: Originally Posted by Nadz

I can’t seem to find a way to make it work on iPhone or iPad as the iOS excel can’t run the macros… Can somebody just run one sim up and post a screenshot so I can use it?

You'll only get 4 seasons of draft classes as the other 26 are hidden or behind fog of war.

Sent from my H3113 using Tapatalk

[Instant C1a55ic]

Ok, I have ADHD and this doesn't make sense to my simple mind lol

Anyone have a visual way to show me how this works?

Sent from my SM-F916U using Operation Sports mobile app

[Mattanite]

Quote: Originally Posted by Instant C1a55ic

Ok, I have ADHD and this doesn't make sense to my simple mind lol Anyone have a visual way to show me how this works? Sent from my SM-F916U using Operation Sports mobile app

There's an image and an explanation but a tldr of the order would be.

Push generate button in preseason.
Enter draft class strength in settings.
Draft in offseason.
Press advance in preseason.
Enter draft class strength in settings.
Draft in offseason.
Repeat.

If you don't like it, press generate again. If you advance too far you can reset to beginning but keep same data.


Sent from my H3113 using Tapatalk

[Instant C1a55ic]

Thanks, but do I just change the xp slider info since I'll be using a custom set, then just hit generate?



Sent from my SM-F916U using Operation Sports mobile app