ny92mike Posted September 12, 2019 Share Posted September 12, 2019 Let me ask you guys this. Are the BDL positions the same as irl. I mean I know in the game plans you guys will put say a guard at center for example but are you listing them as such in the database? So the recent issues with players being listed as PS/Inactive is because of the identifier I'm using to match names with spotrac and bdl. They use different ways of listing the names for example spotrac using the importhtml formula pulls the names in to the workbook like this. "Cann A.J. Cann" but in the IR listing use "Alex Smith" and because some players have the same name it makes it difficult to pair each name. To make this a little easier I include the position so it's "Alex Smith - QB" to match these names. Sorry making this a more complicated read/question than it needs to be. What I'm asking is can we use the position that spotrac is using as the bdl position. So if HOU is playing a 34 defense then any players listed as DE would be considered INT any OLB would be listed as Edge. Making these changes to the BDL Position column in the player database would make matching more accurate. 1 Link to comment Share on other sites More sharing options...
Xmad Posted September 13, 2019 Share Posted September 13, 2019 Not a single satanic joke on page 666 I am dissapointed in BDL. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Just now, SwoleXmad said: Not a single satanic joke on page 666 I am dissapointed in BDL. I saw that too. Its past us now...curse you devil. 1 Link to comment Share on other sites More sharing options...
VigilantZombie Posted September 13, 2019 Share Posted September 13, 2019 3 minutes ago, ny92mike said: Let me ask you guys this. Are the BDL positions the same as irl. I mean I know in the game plans you guys will put say a guard at center for example but are you listing them as such in the database? So the recent issues with players being listed as PS/Inactive is because of the identifier I'm using to match names with spotrac and bdl. They use different ways of listing the names for example spotrac using the importhtml formula pulls the names in to the workbook like this. "Cann A.J. Cann" but in the IR listing use "Alex Smith" and because some players have the same name it makes it difficult to pair each name. To make this a little easier I include the position so it's "Alex Smith - QB" to match these names. Sorry making this a more complicated read/question than it needs to be. What I'm asking is can we use the position that spotrac is using as the bdl position. So if HOU is playing a 34 defense then any players listed as DE would be considered INT any OLB would be listed as Edge. Making these changes to the BDL Position column in the player database would make matching more accurate. Like you said, we do what we want with our roster anyway, move people around. So for me as long as people are willing to understand and consider in voting that workbook position is not necessarily indicative of game roster I am of the opinion that you do what makes it easier on you. Link to comment Share on other sites More sharing options...
VigilantZombie Posted September 13, 2019 Share Posted September 13, 2019 36 minutes ago, Counselor said: $450 Actually this could a satanic joke. The question was what was the cost to the receiver? If that isnt a sun-filled suggestion idk what is. 1 Link to comment Share on other sites More sharing options...
Scoundrel Posted September 13, 2019 Share Posted September 13, 2019 So how do we add fellows to the tradeblock? Link to comment Share on other sites More sharing options...
Scoundrel Posted September 13, 2019 Share Posted September 13, 2019 Also @Jlash the depth chart link in the OP is the old depth chart thread playa playa Link to comment Share on other sites More sharing options...
Jlash Posted September 13, 2019 Author Share Posted September 13, 2019 1 minute ago, Counselor said: Also @Jlash the depth chart link in the OP is the old depth chart thread playa playa Done. Thanks dude. 1 Link to comment Share on other sites More sharing options...
Jlash Posted September 13, 2019 Author Share Posted September 13, 2019 2 minutes ago, Counselor said: So how do we add fellows to the tradeblock? Drop down menu on your page. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 1 minute ago, Counselor said: So how do we add fellows to the tradeblock? Go to your team page in master wb. Go to cell range L38 you'll see the trade block builder...use the drop down list in column L to add them and if you want to include how many sandwiches it'll cost type that up in column P. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 However, it looks like something isn't working right with it for some reason. Give me a bit to figure it out. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 fixed. Link to comment Share on other sites More sharing options...
Scoundrel Posted September 13, 2019 Share Posted September 13, 2019 Love the Trade Block Mike. Looking at the list is like going to the grocery store when you are hungry. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Also...I could set it up to sort by position and/or team but using one workbook it wouldn't work out to well as not everyone is going to wanna look at the same positions. But I could build it into the team pages, something to think about. Link to comment Share on other sites More sharing options...
Scoundrel Posted September 13, 2019 Share Posted September 13, 2019 Can see the salary and how many years are left. So much easier. Link to comment Share on other sites More sharing options...
Recommended Posts