ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Just now, Counselor said: Love the Trade Block Mike. Looking at the list is like going to the grocery store when you are hungry. haha...thanks man...It's pretty basic but not having your own personal workbook limits things to group settings. Link to comment Share on other sites More sharing options...
Whicker Posted September 13, 2019 Share Posted September 13, 2019 19 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. I would prefer proper Edge and Int statuses, yes Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Just now, Whicker said: I would prefer proper Edge and Int statuses, yes So what spotrac list them as right? Link to comment Share on other sites More sharing options...
Whicker Posted September 13, 2019 Share Posted September 13, 2019 1 minute ago, ny92mike said: So what spotrac list them as right? I mean my ultimate preference is for them to be listed how I see them but I guess Spotrac is a reasonable compromise Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 @Counselor you see a need to show the co-Owner's name in the League Trade Block. Now let's talk about a depth chart within this workbook. Any interest in that? Link to comment Share on other sites More sharing options...
Scoundrel Posted September 13, 2019 Share Posted September 13, 2019 Just now, ny92mike said: @Counselor you see a need to show the co-Owner's name in the League Trade Block. Now let's talk about a depth chart within this workbook. Any interest in that? No. The owner can let the co owner know about any trade offers. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Just now, Whicker said: I mean my ultimate preference is for them to be listed how I see them but I guess Spotrac is a reasonable compromise I'm good either way, having it set up to where BDL position differ from spotrac requires a new column be added. In the past, did the managers of the workbook change positions upon request? Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 2 minutes ago, Counselor said: No. The owner can let the co owner know about any trade offers. Thats kinda what I thought but wanted to ask the trade expert. 1 Link to comment Share on other sites More sharing options...
Whicker Posted September 13, 2019 Share Posted September 13, 2019 2 minutes ago, ny92mike said: I'm good either way, having it set up to where BDL position differ from spotrac requires a new column be added. In the past, did the managers of the workbook change positions upon request? Yeah I think it was by request or done during the acquisition. I think it should be listed at the BDL owner’s discretion before Spotrac but it’s not worth the fight most likely. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 1 minute ago, Whicker said: Yeah I think it was by request or done during the acquisition. I think it should be listed at the BDL owner’s discretion before Spotrac but it’s not worth the fight most likely. Like I said man, I'm fine either way. @TedLavie or @SirA1 might have something else to say about it. For me it's just a matter of adding a new column that has the spotrac position title so that the player is matched correctly to the imported data. I'd likely need to change some of the filter formulas due to adding a column but it wouldn't require a whole new workbook, could all be done using the current version. Link to comment Share on other sites More sharing options...
Xmad Posted September 13, 2019 Share Posted September 13, 2019 32 minutes ago, ny92mike said: @Counselor you see a need to show the co-Owner's name in the League Trade Block. Now let's talk about a depth chart within this workbook. ny interest in that? A No if only because I never update it and I don't want you to waste your time in a feature few will use. Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 Gonna be working in the workbook, so if things get a little crazy looking it'll return to normal soon. I see only one person in there and figure now is the best time to do this. Link to comment Share on other sites More sharing options...
bcb1213 Posted September 13, 2019 Share Posted September 13, 2019 2 hours ago, ny92mike said: Like I said man, I'm fine either way. @TedLavie or @SirA1 might have something else to say about it. For me it's just a matter of adding a new column that has the spotrac position title so that the player is matched correctly to the imported data. I'd likely need to change some of the filter formulas due to adding a column but it wouldn't require a whole new workbook, could all be done using the current version. Can you just make it a hidden column? Then literally no one will see it anyhow 1 Link to comment Share on other sites More sharing options...
ny92mike Posted September 13, 2019 Share Posted September 13, 2019 17 minutes ago, bcb1213 said: Can you just make it a hidden column? Then literally no one will see it anyhow You talking about the column I talked about adding? Link to comment Share on other sites More sharing options...
bcb1213 Posted September 13, 2019 Share Posted September 13, 2019 7 minutes ago, ny92mike said: You talking about the column I talked about adding? Nods Link to comment Share on other sites More sharing options...
Recommended Posts