Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 5 minutes ago, LAOJoe said: Sort by 2022 under your cap. No that wasn’t the issue. My whole defense was missing. It’s all fine now. Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 Okay so @ny92mike this should be the order... So the three way record between Raleigh, Singapore and Hungary will result in alternating slots between the three. The same record between Seoul and Gotham will do the same (Seoul 2nd in all odd rounds and Gotham 2nd in all even rounds). There were no same records eliminated in any round of the playoffs so should be no alternating draft slots with the playoff teams. There is no rotation of PFA other than the snake order for round 2. 1.1 Berlin 1.2 Seoul 1.3 Gotham 1.4 Raleigh 1.5 Singapore (Owned by Anchorage) 1.6 Hungary 1.7 Greenland 1.8 Lancaster (Owned by Raleigh) 1.9 Cuba 1.10 New Orleans 1.11 Death Valley (Owned by Gotham) 1.12 Camden (Owned by Ivory Coast) 1.13 Ivory Coast (Owned by Berlin) 1.14 Cancun 1.15 Rome 1.16 Anchorage 2.1 Berlin 2.2 Gotham 2.3 Seoul 2.4 Singapore (Owned by Gotham) 2.5 Hungary 2.6 Raleigh 2.7 Greenland 2.8 Lancaster (Owned by Anchorage) 2.9 Cuba 2.10 New Orleans (Owned by Gotham) 2.11 Death Valley (Owned by Lancaster) 2.12 Camden (Owned by Anchorage) 2.13 Ivory Coast (Owned by Berlin) 2.14 Cancun 2.15 Rome 2.16 Anchorage 3.1 Berlin 3.2 Seoul 3.3 Gotham 3.4 Hungary 3.5 Raleigh (Owned by Lancaster) 3.6 Singapore (Owned by Gotham) 3.7 Greenland 3.8 Lancaster 3.9 Cuba 3.10 New Orleans 3.11 Death Valley (Owned by Berlin) 3.12 Camden (Owned by Singapore) 3.13 Ivory Coast (Owned by Seoul) 3.14 Cancun 3.15 Rome 3.16 Anchorage (Owned by Seoul) 4.1 Berlin (Owned by Greenland) 4.2 Gotham 4.3 Seoul 4.4 Raleigh 4.5 Singapore (Owned by Ivory Coast) 4.6 Hungary 4.7 Greenland 4.8 Lancaster 4.9 Cuba 4.10 New Orleans 4.11 Death Valley (Owned by Seoul) 4.12 Camden (Owned by Seoul) 4.13 Ivory Coast 4.14 Cancun 4.15 Rome 4.16 Anchorage (Owned by Gotham) 5.1 Berlin 5.2 Seoul 5.3 Gotham (Owned by New Orleans) 5.4 Singapore (Owned by Cancun) 5.5 Hungary 5.6 Raleigh (Owned by Cancun) 5.7 Greenland 5.8 Lancaster 5.9 Cuba 5.10 New Orleans (Owned by Lancaster) 5.11 Death Valley (Owned by New Orleans) 5.12 Camden (Owned by Rome) 5.13 Ivory Coast (Owned by Singapore) 5.14 Cancun (Owned by Berlin) 5.15 Rome 5.16 Anchorage (Owned by Berlin) 6.1 Berlin (Owned by Cuba) 6.2 Gotham 6.3 Seoul (Owned by Hungary) 6.4 Hungary (Owned by Seoul) 6.5 Raleigh (Owned by Seoul) 6.6 Singapore 6.7 Greenland (Owned by Seoul) 6.8 Lancaster (Owned by Singapore) 6.9 Cuba 6.10 New Orleans (Owned by Lancaster) 6.11 Death Valley (Owned by Camden) 6.12 Camden (Owned by Cancun) 6.13 Ivory Coast 6.14 Cancun (Owned by Seoul) 6.15 Rome 6.16 Anchorage (Owned by Berlin) 7.1 Berlin 7.2 Seoul 7.3 Gotham (Owned by Seoul) 7.4 Raleigh 7.5 Singapore (Owned by Ivory Coast) 7.6 Hungary 7.7 Greenland (Owned by Camden) 7.8 Lancaster (Owned by Berlin) 7.9 Cuba 7.10 New Orleans (Owned by Seoul) 7.11 Death Valley (Owned by Ivory Coast) 7.12 Camden (Owned by Death Valley) 7.13 Ivory Coast 7.14 Cancun (Owned by Singapore) 7.15 Rome 7.16 Anchorage (Owned by Camden) PFA 1.1 Berlin PFA 1.2 Seoul PFA 1.3 Gotham PFA 1.4 Raleigh PFA 1.5 Singapore PFA 1.6 Hungary PFA 1.7 Greenland PFA 1.8 Lancaster PFA 1.9 Cuba PFA 1.10 New Orleans PFA 1.11 Death Valley PFA 1.12 Camden PFA 1.13 Ivory Coast PFA 1.14 Cancun PFA 1.15 Rome PFA 1.16 Anchorage PFA 2.1 Anchorage PFA 2.2 Rome PFA 2.3 Cancun PFA 2.4 Ivory Coast PFA 2.5 Camden PFA 2.6 Death Valley PFA 2.7 New Orleans PFA 2.8 Cuba PFA 2.9 Lancaster PFA 2.10 Greenland PFA 2.11 Hungary PFA 2.12 Singapore PFA 2.13 Raleigh PFA 2.14 Gotham PFA 2.15 Seoul PFA 2.16 Berlin Quote Link to comment Share on other sites More sharing options...
Jlash Posted January 2, 2023 Author Share Posted January 2, 2023 oooooooo I get the last pick in the draft!?! 1 Quote Link to comment Share on other sites More sharing options...
bcb1213 Posted January 2, 2023 Share Posted January 2, 2023 I think frogs and I are the only ones who own all our original picks 1 Quote Link to comment Share on other sites More sharing options...
RuskieTitan Posted January 2, 2023 Share Posted January 2, 2023 6 hours ago, Scoundrel said: Okay so @ny92mike this should be the order... So the three way record between Raleigh, Singapore and Hungary will result in alternating slots between the three. The same record between Seoul and Gotham will do the same (Seoul 2nd in all odd rounds and Gotham 2nd in all even rounds). There were no same records eliminated in any round of the playoffs so should be no alternating draft slots with the playoff teams. There is no rotation of PFA other than the snake order for round 2. 1.1 Berlin 1.2 Seoul 1.3 Gotham 1.4 Raleigh 1.5 Singapore (Owned by Anchorage) 1.6 Hungary 1.7 Greenland 1.8 Lancaster (Owned by Raleigh) 1.9 Cuba 1.10 New Orleans 1.11 Death Valley (Owned by Gotham) 1.12 Camden (Owned by Ivory Coast) 1.13 Ivory Coast (Owned by Berlin) 1.14 Cancun 1.15 Rome 1.16 Anchorage 2.1 Berlin 2.2 Gotham 2.3 Seoul 2.4 Singapore (Owned by Gotham) 2.5 Hungary 2.6 Raleigh 2.7 Greenland 2.8 Lancaster (Owned by Anchorage) 2.9 Cuba 2.10 New Orleans (Owned by Gotham) 2.11 Death Valley (Owned by Lancaster) 2.12 Camden (Owned by Anchorage) 2.13 Ivory Coast (Owned by Berlin) 2.14 Cancun 2.15 Rome 2.16 Anchorage 3.1 Berlin 3.2 Seoul 3.3 Gotham 3.4 Hungary 3.5 Raleigh (Owned by Lancaster) 3.6 Singapore (Owned by Gotham) 3.7 Greenland 3.8 Lancaster 3.9 Cuba 3.10 New Orleans 3.11 Death Valley (Owned by Berlin) 3.12 Camden (Owned by Singapore) 3.13 Ivory Coast (Owned by Seoul) 3.14 Cancun 3.15 Rome 3.16 Anchorage (Owned by Seoul) 4.1 Berlin (Owned by Greenland) 4.2 Gotham 4.3 Seoul 4.4 Raleigh 4.5 Singapore (Owned by Ivory Coast) 4.6 Hungary 4.7 Greenland 4.8 Lancaster 4.9 Cuba 4.10 New Orleans 4.11 Death Valley (Owned by Seoul) 4.12 Camden (Owned by Seoul) 4.13 Ivory Coast 4.14 Cancun 4.15 Rome 4.16 Anchorage (Owned by Gotham) 5.1 Berlin 5.2 Seoul 5.3 Gotham (Owned by New Orleans) 5.4 Singapore (Owned by Cancun) 5.5 Hungary 5.6 Raleigh (Owned by Cancun) 5.7 Greenland 5.8 Lancaster 5.9 Cuba 5.10 New Orleans (Owned by Lancaster) 5.11 Death Valley (Owned by New Orleans) 5.12 Camden (Owned by Rome) 5.13 Ivory Coast (Owned by Singapore) 5.14 Cancun (Owned by Berlin) 5.15 Rome 5.16 Anchorage (Owned by Berlin) 6.1 Berlin (Owned by Cuba) 6.2 Gotham 6.3 Seoul (Owned by Hungary) 6.4 Hungary (Owned by Seoul) 6.5 Raleigh (Owned by Seoul) 6.6 Singapore 6.7 Greenland (Owned by Seoul) 6.8 Lancaster (Owned by Singapore) 6.9 Cuba 6.10 New Orleans (Owned by Lancaster) 6.11 Death Valley (Owned by Camden) 6.12 Camden (Owned by Cancun) 6.13 Ivory Coast 6.14 Cancun (Owned by Seoul) 6.15 Rome 6.16 Anchorage (Owned by Berlin) 7.1 Berlin 7.2 Seoul 7.3 Gotham (Owned by Seoul) 7.4 Raleigh 7.5 Singapore (Owned by Ivory Coast) 7.6 Hungary 7.7 Greenland (Owned by Camden) 7.8 Lancaster (Owned by Berlin) 7.9 Cuba 7.10 New Orleans (Owned by Seoul) 7.11 Death Valley (Owned by Ivory Coast) 7.12 Camden (Owned by Death Valley) 7.13 Ivory Coast 7.14 Cancun (Owned by Singapore) 7.15 Rome 7.16 Anchorage (Owned by Camden) PFA 1.1 Berlin PFA 1.2 Seoul PFA 1.3 Gotham PFA 1.4 Raleigh PFA 1.5 Singapore PFA 1.6 Hungary PFA 1.7 Greenland PFA 1.8 Lancaster PFA 1.9 Cuba PFA 1.10 New Orleans PFA 1.11 Death Valley PFA 1.12 Camden PFA 1.13 Ivory Coast PFA 1.14 Cancun PFA 1.15 Rome PFA 1.16 Anchorage PFA 2.1 Anchorage PFA 2.2 Rome PFA 2.3 Cancun PFA 2.4 Ivory Coast PFA 2.5 Camden PFA 2.6 Death Valley PFA 2.7 New Orleans PFA 2.8 Cuba PFA 2.9 Lancaster PFA 2.10 Greenland PFA 2.11 Hungary PFA 2.12 Singapore PFA 2.13 Raleigh PFA 2.14 Gotham PFA 2.15 Seoul PFA 2.16 Berlin I liked the version where I have pick #3 more. 2 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 2, 2023 Share Posted January 2, 2023 @bcb1213 @RedGold @Jlash @SirA1 Are there any other members that need editing rights to workbook? Sorry can't recall who managed the waiver wire but if you plan on continuing to manage this again, I can create a sheet to help you track it if you like. If so, please PM me your email address. @RedGold you mentioned testing the workbook for errors. You still up for that? Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 3 hours ago, RuskieTitan said: I liked the version where I have pick #3 more. The one where I have pick #1? Me too Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 4 hours ago, Jlash said: oooooooo I get the last pick in the draft!?! You’re welcome 1 Quote Link to comment Share on other sites More sharing options...
RedGold Posted January 2, 2023 Share Posted January 2, 2023 @ny92mike I can test it out if it’s this afternoon Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 11 minutes ago, RedGold said: @ny92mike I can test it out if it’s this afternoon I thought I was getting a mock draft... Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 2, 2023 Share Posted January 2, 2023 19 minutes ago, RedGold said: @ny92mike I can test it out if it’s this afternoon Thanks man. Okay here is the link. I used your gmail to get you editing rights. https://docs.google.com/spreadsheets/d/1i0T3ZhKpByt4mPxZLNjIqso48KgMi2kLbNc4jOfXDX8/edit?usp=sharing I'll work on getting you an explanation of how the player database works with the spotrac data. If you have any questions or concerns, keep me posted. I still need to finish dressing it up and I only have the one team page, so when you get finished testing it out let me know and I'll add the rest of them. Thanks man. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 2, 2023 Share Posted January 2, 2023 @Scoundrel @Pickle Rick @Ragnarok @Jlash @Blue @MWil23 @MD4L @RTTRUTH @LAOJoe @Daniel @Whicker @PR @RuskieTitan @ny92mike @rackcs @EaglesPeteC @bcb1213 @RedGold @SirA1 @Malfatron Alright guys, take a look at the workbook and let me know if you'd like anything added or have issue with the layout/design. I'm still working on getting the player database updated, fyi. https://docs.google.com/spreadsheets/d/1i0T3ZhKpByt4mPxZLNjIqso48KgMi2kLbNc4jOfXDX8/edit?usp=sharing Thanks 2 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 2, 2023 Share Posted January 2, 2023 35 minutes ago, RedGold said: @ny92mike I can test it out if it’s this afternoon Post any issues you find when going through it. Quote Link to comment Share on other sites More sharing options...
Whicker Posted January 2, 2023 Share Posted January 2, 2023 9 minutes ago, ny92mike said: @Scoundrel @Pickle Rick @Ragnarok @Jlash @Blue @MWil23 @MD4L @RTTRUTH @LAOJoe @Daniel @Whicker @PR @RuskieTitan @ny92mike @rackcs @EaglesPeteC @bcb1213 @RedGold @SirA1 @Malfatron Alright guys, take a look at the workbook and let me know if you'd like anything added or have issue with the layout/design. I'm still working on getting the player database updated, fyi. https://docs.google.com/spreadsheets/d/1i0T3ZhKpByt4mPxZLNjIqso48KgMi2kLbNc4jOfXDX8/edit?usp=sharing Thanks I haven’t looked but I don’t need to because I’m that sure it’s great. Thanks for everything Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 2, 2023 Share Posted January 2, 2023 13 minutes ago, ny92mike said: Post any issues you find when going through it. The draft order is wrong. You have the 2022 draft order as the 2023 draft order Quote Link to comment Share on other sites More sharing options...
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.