MyLeague Random Events

[EatableclownV]

Quote: Originally Posted by TheDominator273

Those are some great adds! I'll get them added to the base sheet, and get something set up to generate the number within a range for things. That is a great call to make things even more dynamic. What I think I'll do is have the range listed in the result, then have another macro to run a random number between two cells that will be editable so you can input the ranges you get in your event result.

Love the idea and the sheet. Totally agree with the declines being a thing as well, that was the first edit I was going to make.Can't wait to try it out on my Pistons Franchise.

Keep up the good work

Sent from my LYA-L29 using Operation Sports mobile app

[pimpinpidgeon8]

So we could use it as well as in game injuries and what not?

Sent from my SM-A205U using Tapatalk

[TheDominator273]

Quote: Originally Posted by pimpinpidgeon8

So we could use it as well as in game injuries and what not? Sent from my SM-A205U using Tapatalk

Correct. I run the sheet around 10 times after hitting advance to next season, and plan to run it around 5 times at the All Star break.

I'll have an updated sheet later tonight that will have the added storylines above as well as ranges for the storyline effects.

[pimpinpidgeon8]

Quote: Originally Posted by TheDominator273

Correct. I run the sheet around 10 times after hitting advance to next season, and plan to run it around 5 times at the All Star break. I'll have an updated sheet later tonight that will have the added storylines above as well as ranges for the storyline effects.

So you come up with 10 scenarios per tip off of each season and then 5 more at all star break?

Do you put all 10 into motion immediately at the start of the season?

Sent from my SM-A205U using Tapatalk

[EccentricMeat]

Quote: Originally Posted by pimpinpidgeon8

So you come up with 10 scenarios per tip off of each season and then 5 more at all star break? Do you put all 10 into motion immediately at the start of the season? Sent from my SM-A205U using Tapatalk

It's really up to you! I think what I'm going to do is run a few custom random-number-generators for things like how much to increase/decrease stats, how long into the season to wait before implementing the changes, whether to make those changes permanent or have them revert back to default after X amount of games, etc.

This thread really helped re-invigorate the game for me. Thanks OP!

[EatableclownV]

Quote: Originally Posted by EccentricMeat

It's really up to you! I think what I'm going to do is run a few custom random-number-generators for things like how much to increase/decrease stats, how long into the season to wait before implementing the changes, whether to make those changes permanent or have them revert back to default after X amount of games, etc. This thread really helped re-invigorate the game for me. Thanks OP!

Same, I'm going to run it a few times to start the year and maybe a few times each month. This along with the bits already in 2k should really make my second season an absolute roller-coaster ride.

Sent from my LYA-L29 using Operation Sports mobile app

[pimpinpidgeon8]

Will this work on a galaxy phone? I don't have a laptop and just use my smartphone for everything.

Sent from my SM-A205U using Tapatalk

[TheDominator273]

Quote: Originally Posted by pimpinpidgeon8

Will this work on a galaxy phone? I don't have a laptop and just use my smartphone for everything. Sent from my SM-A205U using Tapatalk

Unfortunately the macros don't run on the mobile version of Google Sheets. I will look into a way to make a mobile version of the sheet though for those that don't have a computer.

I have updated the OP to include a link v2.0 of the spreadsheet which now looks like this.



This updated version contains new stories, as well as the ability to enter the lower and upper limits for rating increases/decreases paired with a separate RUN button used to then generate a random number between those limits.

The tutorial listed above is still how to use the sheet, the only change is when you are going to edit the player you can now run a separate function to determine how much a player's ratings increase or decrease which adds additional dynamics to the storylines as there are now far more options available to happen.

As always if you have any additional storylines you would like added let me know and I will add them! The more variety we can add to the sheet the more varied and unpredictable your MyLeague can be!