bcb1213 Posted January 3, 2023 Share Posted January 3, 2023 I believe it's Defense Skill Ol/qb 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 13 hours ago, Scoundrel said: @ny92mike some of those ages are wrong by the way. Is it the age they turn in 2023? Because Burrow just turned 26 on December 10th but it lists him at 27 in the book. Obviously this isn’t a huge issue the age of the players but just wondering. Good point, I'm thinking just remove the added year to their age that I added would work. So the only increase I add is to their years of experience. Quote Link to comment Share on other sites More sharing options...
RedGold Posted January 3, 2023 Share Posted January 3, 2023 19 hours ago, ny92mike said: Noted for things to fix. Also, believe I can change it back to zero without it messing anything up. Did you figure out how to add players to database? Also, I may hit you up to help with getting age and experience set for the ones that are missing. Formula caught the bulk of them. Yes sir, sorry last night was a cluster. Adding players is simple, Pretty much the same as last years. Just columns C,D, G-J. Everything else auto populates if the name matches spotrac Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 1 minute ago, RedGold said: Yes sir, sorry last night was a cluster. Adding players is simple, Pretty much the same as last years. Just columns C,D, G-J. Everything else auto populates if the name matches spotrac Cool...I'd add if the name doesn't match to use the drop down in the spotrac column as the spelling or position might be different. I tried to keep it close to what we already had. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 I'll work on it some more today. 1 Quote Link to comment Share on other sites More sharing options...
RedGold Posted January 3, 2023 Share Posted January 3, 2023 15 minutes ago, ny92mike said: Cool...I'd add if the name doesn't match to use the drop down in the spotrac column as the spelling or position might be different. I tried to keep it close to what we already had. Noice, I didn’t even know that drop-down in the spotrac column existed. I’m gonna guess there’s no way to alphabetize that? It’s not a huge deal if it’s a ton of work. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 1 minute ago, RedGold said: Noice, I didn’t even know that drop-down in the spotrac column existed. I’m gonna guess there’s no way to alphabetize that? It’s not a huge deal if it’s a ton of work. Unfortunately not. The list for the drop down is collected from the data in the spotrac rosters, FA, IR, and Suspended list. What I do is just start typing the players last name or first name or part of the name in the drop down cell and it will start filtering the list as you type. Clicking the carrot to pull the list would be a nightmare to find. Try that and let me know if that helps. 1 Quote Link to comment Share on other sites More sharing options...
VigilantZombie Posted January 3, 2023 Share Posted January 3, 2023 Happy New Year everyone. Hope your families are doing well and hope you are all safe with all the snow storms that have hit the country. 4 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 @RedGold @Scoundrel posted the draft order for me and I'm working on getting that added, but he mentioned showing who owned that original pick but I don't remember seeing that in the 2022 workbook. Could you point me to that. Thanks. 1 Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 3, 2023 Share Posted January 3, 2023 2 minutes ago, ny92mike said: @RedGold @Scoundrel posted the draft order for me and I'm working on getting that added, but he mentioned showing who owned that original pick but I don't remember seeing that in the 2022 workbook. Could you point me to that. Thanks. I’ll send you the picture on Discord in the league chat Quote Link to comment Share on other sites More sharing options...
RedGold Posted January 3, 2023 Share Posted January 3, 2023 2 minutes ago, ny92mike said: @RedGold @Scoundrel posted the draft order for me and I'm working on getting that added, but he mentioned showing who owned that original pick but I don't remember seeing that in the 2022 workbook. Could you point me to that. Thanks. It's Column J for 2023. In the Draft Order worksheet. Draft Order / Pick / Draft Pick / Owner / Value Draft Pick would be the original Owner of the Pick. Draft Order Pick Draft Pick Owner Cap Value 1 1.1 1st - Anchorage Anchorage Trappers $6,500 2 1.2 1st - Berlin Berlin Blitzkrieg $6,250 3 1.3 1st - Camden Ivory Coast Black Rhinos $6,005 4 1.4 1st - Lancaster Raleigh Firebirds $5,755 5 1.5 1st - Cuba Cuba Smugglers $5,510 6 1.6 1st - Gotham Gotham Gashslayers $5,260 Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted January 3, 2023 Share Posted January 3, 2023 Just now, RedGold said: It's Column J for 2023. In the Draft Order worksheet. Draft Order / Pick / Draft Pick / Owner / Value Draft Pick would be the original Owner of the Pick. Draft Order Pick Draft Pick Owner Cap Value 1 1.1 1st - Anchorage Anchorage Trappers $6,500 2 1.2 1st - Berlin Berlin Blitzkrieg $6,250 3 1.3 1st - Camden Ivory Coast Black Rhinos $6,005 4 1.4 1st - Lancaster Raleigh Firebirds $5,755 5 1.5 1st - Cuba Cuba Smugglers $5,510 6 1.6 1st - Gotham Gotham Gashslayers $5,260 Or RG can just do it here lol Quote Link to comment Share on other sites More sharing options...
RedGold Posted January 3, 2023 Share Posted January 3, 2023 3 minutes ago, Scoundrel said: Or RG can just do it here lol 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 19 minutes ago, RedGold said: It's Column J for 2023. In the Draft Order worksheet. Draft Order / Pick / Draft Pick / Owner / Value Draft Pick would be the original Owner of the Pick. Draft Order Pick Draft Pick Owner Cap Value 1 1.1 1st - Anchorage Anchorage Trappers $6,500 2 1.2 1st - Berlin Berlin Blitzkrieg $6,250 3 1.3 1st - Camden Ivory Coast Black Rhinos $6,005 4 1.4 1st - Lancaster Raleigh Firebirds $5,755 5 1.5 1st - Cuba Cuba Smugglers $5,510 6 1.6 1st - Gotham Gotham Gashslayers $5,260 Oh damn...I was reading this completely wrong. I thought it was odd that the Draft Pick and Owner columns was redundant. I'll need to go back and remove the formulas in draft pick column. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 3, 2023 Share Posted January 3, 2023 @RedGold Can you jump on the chat in the workbook. Just want to make sure I'm doing this correctly. 1 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.