ny92mike Posted November 4, 2021 Share Posted November 4, 2021 I guess the roster values for 2022 and 2023 could be estimates, basically just trying to provide the team page with a value that they need to have. This isn't really needed until the off season, by that time the values are correct. Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 Just now, SirA1 said: No you saw it though. I have had it for over 10 years. All manual baby! That's right...I recall getting a headache that day...haha. Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 3 minutes ago, SirA1 said: The picks order and values are accurate. I am just saying that the teams are in alphabetical order not pick order. The closest thing to a draft order is the Standings. But that is for the first 16 picks only. I have to manually create the draft order once the season ends because of the later rounds. I see what you mean now... it only took me 20 minutes. I'll delete the future years. 2 Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 @SirA1 Give the sample team sheet a look over and if it works for you I'll update all the team sheets. https://docs.google.com/spreadsheets/d/1HAj07vCoa_nY2M49a5Te1Qpk-H06AuoQQp6MsAUUIRs/edit#gid=32441151 Link to comment Share on other sites More sharing options...
SirA1 Posted November 4, 2021 Share Posted November 4, 2021 2 minutes ago, ny92mike said: @SirA1 Give the sample team sheet a look over and if it works for you I'll update all the team sheets. https://docs.google.com/spreadsheets/d/1HAj07vCoa_nY2M49a5Te1Qpk-H06AuoQQp6MsAUUIRs/edit#gid=32441151 It's fine. I agree that you can remove a ton of the rows in the Trade block. 1 Link to comment Share on other sites More sharing options...
MD4L Posted November 4, 2021 Share Posted November 4, 2021 We ******* suck. that is all. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 27 minutes ago, SirA1 said: It's fine. I agree that you can remove a ton of the rows in the Trade block. Talking about the league trade block sheet? https://docs.google.com/spreadsheets/d/1HAj07vCoa_nY2M49a5Te1Qpk-H06AuoQQp6MsAUUIRs/edit#gid=1479741804 Link to comment Share on other sites More sharing options...
SirA1 Posted November 4, 2021 Share Posted November 4, 2021 5 minutes ago, ny92mike said: Talking about the league trade block sheet? https://docs.google.com/spreadsheets/d/1HAj07vCoa_nY2M49a5Te1Qpk-H06AuoQQp6MsAUUIRs/edit#gid=1479741804 No the individual team ones. There are like 30 spots which almost half a team. Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 1 minute ago, SirA1 said: No the individual team ones. There are like 30 spots which almost half a team. Gotcha...how many rows do you want? Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 5 minutes ago, ny92mike said: Gotcha...how many rows do you want? Reduced to 10 Link to comment Share on other sites More sharing options...
VigilantZombie Posted November 4, 2021 Share Posted November 4, 2021 Can someone please tag me in any game if there is any that I did not yet vote on Please and thank you Link to comment Share on other sites More sharing options...
Scoundrel Posted November 4, 2021 Share Posted November 4, 2021 Think I voted in all comments will come later have something going on Link to comment Share on other sites More sharing options...
ny92mike Posted November 4, 2021 Share Posted November 4, 2021 @RedGold Alright so I whipped up something that might work for what you suggested for making trade proposals. Check out the sheet, "Copy of Anchorage Trappers". https://docs.google.com/spreadsheets/d/1HAj07vCoa_nY2M49a5Te1Qpk-H06AuoQQp6MsAUUIRs/edit#gid=32441151 I set this up below the Trade Block section. Cell range M65 How it works Select the team you want to trade with Cell N68 Select up to three players using the drop down list. Cell Range N70:N72 Select up to 3 draft picks, using drop down list. First select the draft year, you want to include in the proposal. Cell Range M75:M77 Then select the draft pick. Cell Range N75:N77 Do basically the same with YOUR TEAM section. Finding out if a different team has made you a trade offer A quick reference flag is set up at the top of the team page. Cell I11 The list of team names is populated in cell range N90:N105. I haven't set it up yet but I'd like to create a hyperlink to the team name that directs you to the team page. So that you can easily see the details of the trade proposal. FYI, Because I only have the one sheet set up for this, it might be difficult to get the full picture of how it would look in action. Link to comment Share on other sites More sharing options...
VigilantZombie Posted November 4, 2021 Share Posted November 4, 2021 The next couple of weeks will be very interesting. 2 of the top 5 ranked teams lost this week with 3 teams below them winning. Link to comment Share on other sites More sharing options...
WFLukic Posted November 4, 2021 Share Posted November 4, 2021 4 game road trip to end the season. Dang. Link to comment Share on other sites More sharing options...
Recommended Posts