MyLeague Random Events

[studbucket]

Quote: Originally Posted by marshdaddy

If you or anyone else is interested, I made some personal edits here: https://docs.google.com/spreadsheets...it?usp=sharing Just disregard all my events on the first page. I added some events from the ATD generator that I liked, and maybe a few other things but I can't recall all of them off the top of my head.

So I am copying over your new events from the 'Lookup' tab, but I can't get the generator on the 'Post Trade Deadline' to get those events to show up. It only shows events from the first 36 rows (which I already had there) and I can't figure out how to edit the script to increase the range.



Do you know what I am doing wrong?

[marshdaddy]

Quote: Originally Posted by studbucket

So I am copying over your new events from the 'Lookup' tab, but I can't get the generator on the 'Post Trade Deadline' to get those events to show up. It only shows events from the first 36 rows (which I already had there) and I can't figure out how to edit the script to increase the range. Do you know what I am doing wrong?

To edit what events show up in the generator, click Data at the top of the spreadsheet in the file bar, right under the name of the sheet, and the click Named Ranges. That will pop up with all of the events and what they're pulling from, my guess is you just need to update what range the Post Trade Deadline events are coming from. Let me know if that works.

[NYJaguar]

I'm getting a "This app is blocked" message. Any workarounds?

[marshdaddy]

Quote: Originally Posted by NYJaguar

I'm getting a "This app is blocked" message. Any workarounds?

It could be the computer you’re on. Do you have any restrictions to access Google Drive?

[TheDominator273]

Hey guys, I haven't touched 2k22 but I'll try to check in here if needed for anything, but marshdaddy has made some awesome improvements to the sheet!

[CelticLG]

Quote: Originally Posted by TheDominator273

Hey guys, I haven't touched 2k22 but I'll try to check in here if needed for anything, but marshdaddy has made some awesome improvements to the sheet!

[studbucket]

I had a question about the SuperTeam Me event during free agency:

Superteam Me
2 Free Agents 78+ OVR team up on generated team. (Use Event Low: 1 and Event High: # of Eligible FAs to determine which 2 players team up)

I had this come up this offseason, and ended up scrapping it and re-generating a new event. However, I'd like to be more prepared next time I do this, so I have a few questions.

1. How do you choose the two players? When in the process do you figure out how many FAs are eligible and generate the numbers?
2. Once you get the two players, what if the fit makes no sense?
3. Once you get the two players, what if the team has no cap space, how do you make it work?

[TheDominator273]

Quote: Originally Posted by studbucket

I had a question about the SuperTeam Me event during free agency: Superteam Me 2 Free Agents 78+ OVR team up on generated team. (Use Event Low: 1 and Event High: # of Eligible FAs to determine which 2 players team up) I had this come up this offseason, and ended up scrapping it and re-generating a new event. However, I'd like to be more prepared next time I do this, so I have a few questions. How do you choose the two players? When in the process do you figure out how many FAs are eligible and generate the numbers? Once you get the two players, what if the fit makes no sense? Once you get the two players, what if the team has no cap space, how do you make it work?

So let's say for simplicity sake that there are 10 free agents that fit the criteria of 78+ overall, you would input 1 into Event Low and 10 into Event High and run the generator twice and get numbers 3 and 6. You then go to the list of FAs and count from the top to see the 3rd and 6th guys and those are the two targets.

As with any generated story at any point you run the sheet, if you don't think it fits your league simply generate a new event. However depending on how bad the teams salary cap situation was when getting the SuperTeam Me event, you could also consider some salary dumping trades to get the cap to work, or briefly turn off the cap, offer both players max deals and edit them after if needed as if the players took less money in order to play together.