RuskieTitan Posted September 11, 2019 Share Posted September 11, 2019 Just now, SwoleXmad said: Spoctrac isn't always 100% accurate. But Spoctrac shows him with the Titans? Link to comment Share on other sites More sharing options...
Scoundrel Posted September 11, 2019 Share Posted September 11, 2019 I should have skipped on a gameplan so I could be first in the waiver claim. Shame 1 Link to comment Share on other sites More sharing options...
Xmad Posted September 11, 2019 Share Posted September 11, 2019 17 minutes ago, RuskieTitan said: But Spoctrac shows him with the Titans? Should've said the spreadsheet's interpretation of spoctrac isn't 100% accurate. Like how Kawann short on my roster is listed as PS/inactive. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted September 11, 2019 Share Posted September 11, 2019 (edited) 58 minutes ago, RuskieTitan said: Curious as to why Dennis Kelly is listed as PS/Inactive when he was the Titans starting LT last week and the next 3 weeks... Trying to get spotrac name and position listing matched up to name and positioning in bdl terms isn't easy, players change positions in real life or just get listed as "T" or "OT" where bdl might have them listed as LT or RT as just an example. We can fix this stuff but we just need to get a list generated. EDIT: Well after looking at this the link I use to pull spotrac rosters is the contracts, which oddly doesn't have his name listed. https://www.spotrac.com/nfl/tennessee-titans/contracts/ Yet the salary cap sheet does list his name. https://www.spotrac.com/nfl/tennessee-titans/cap/ I'd need to make some major changes to the formulas not only on that sheet but most likely a few others. Might be easier to push out another updated version of this workbook. I'll look into what it would take to fix this stuff. Edited September 11, 2019 by ny92mike 2 Link to comment Share on other sites More sharing options...
ny92mike Posted September 11, 2019 Share Posted September 11, 2019 @RuskieTitan fyi I made an edit to that last post. Link to comment Share on other sites More sharing options...
ny92mike Posted September 11, 2019 Share Posted September 11, 2019 (edited) @TedLavie @SirA1 Hey guys, @RuskieTitan pointed out that there are several players assigned the label of PS/Inactive when they are in fact active. I was able to find the reason why, and it's because I'm using the spotrac link to a roster listing (contracts) that isn't actually giving the full roster list, not sure exactly why that is but switching the spotrac link to the salary (cap) listing is giving a larger list of names. So I've created a new workbook calling it version 2 to fix this issue. While I'm at it I'm going to eliminate the sheet33, that was a horrible idea anyway but it was my first attempt at ever linking 32 rosters into a workbook. I've gotten better since then and there is a much easier way to do this and will be easy to correct and see when there is an actual issue, so we can see it and fix as they happen. Anyway, I figured I'd ask if there is anything additional that you think needs addressing within the workbook. Or if any of you guys that don't mess with the workbook on a daily basis would like us to try to work in let us know. For example, I'd like to see my list of available draft picks (2020) in my team sheet, so I don't have to run and look at that stuff in another sheet. Also makes it easier for someone looking to trade and could prevent less mistakes when posting trades in the forum thread. A better example would be including a "Trade Block" sheet. You guys seem to have liked the Shark Tank set up, and this is right up there with it, in my opinion. How it works is you either enter the player info you are putting on the block and for possibly what you're looking for in return or better yet using the main workbook itself, might be kinda cool to be able to edit some things within the workbook besides just looking at it. Anyway, once you enter the information in, you'd be able to view them all in one sheet, showing which players are on the block and for possibly what they are looking for in trade. Now is the time to let me know, I'll be working on this for the next few days. Anyway, just some ideas that I think would be cool to see but I won't include that type of stuff without your "OK" but I do plan to make those changes because of the known issue with the spotrac linking not providing the full list of names and the whole sheet33 mess that it is...ha. Building a workbook and using it are completely two different things, Since getting back in this as co-GM for Singapore I'm actually using the workbook and there are things I'd change simply for navigation ease, seeing what I want to see on a single page so please if you have things you'd change about it tell me. VOTE SINGAPORE Edited September 11, 2019 by ny92mike 2 Link to comment Share on other sites More sharing options...
TedLavie Posted September 11, 2019 Share Posted September 11, 2019 @SirA1 @WhickerI think we ended up extending voting deadlines in owner meeting. Did you take that into account? Link to comment Share on other sites More sharing options...
SirA1 Posted September 11, 2019 Share Posted September 11, 2019 I did. All of my threads end just after Midnight EST tonight. You can edit the poll times after the fact as well. 2 Link to comment Share on other sites More sharing options...
Scoundrel Posted September 11, 2019 Share Posted September 11, 2019 I would like to add a proposition to the next owners meeting. Any team that does not send in a gameplan goes to the end of the waiver order that week. 6 Link to comment Share on other sites More sharing options...
SirA1 Posted September 11, 2019 Share Posted September 11, 2019 We really need to hard codify the official penalties for not voting etc again. Link to comment Share on other sites More sharing options...
Jlash Posted September 11, 2019 Author Share Posted September 11, 2019 8 minutes ago, SirA1 said: We really need to hard codify the official penalties for not voting etc again. Everyone still has 12 hours no? Link to comment Share on other sites More sharing options...
PR Posted September 11, 2019 Share Posted September 11, 2019 Yeah half of the votes end at noon though. Link to comment Share on other sites More sharing options...
Jlash Posted September 11, 2019 Author Share Posted September 11, 2019 1 minute ago, PR said: Yeah half of the votes end at noon though. Oh. I can't be held accountable for that then. Link to comment Share on other sites More sharing options...
Whicker Posted September 11, 2019 Share Posted September 11, 2019 3 minutes ago, PR said: Yeah half of the votes end at noon though. It has been changed Link to comment Share on other sites More sharing options...
bcb1213 Posted September 11, 2019 Share Posted September 11, 2019 For newbies. This is how much the waivers cost Weeks 1-8 $450 Week 9 $400 Week 10 $350 Week 11 $300 Week 12 $250 Week 13 $200 Week 14 $150 Week 15-16 $100 If you want to pick up two guys. You need to tell me which of your guys hit IR to make that happen Link to comment Share on other sites More sharing options...
Recommended Posts