ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 31 minutes ago, TedLavie said: @ny92mike just one thing I wish that could change on the workbooks (not sure how feasible it is): When I have someone (say a LB) listed on my block in line X (let's say line 68), and suddenly I add (trade or FA or draft) a player that will be inserted above (say a QB in line 20), then the trade block listing doesn't follow the player originally listed, but stays on line X. In this instance I had Funchess listed on my trade block. Suddenly the TEs I just drafted were added to my roster. And the trade block annotation went to Ian Thomas. If you know a better workaround for this please let me know. Because the data is linked to the master workbook I haven't figured a way to solve this issue with the data being on the same page. I did however set it up so that you can create a trade block on a new sheet, that won't give you these issues. The process is still pretty easy just using the drop down list to select the player name in the sheet titled "TRADE BLOCK" using columns C & D you can type what you are in search of, ISO in C and use the drop down in column D, the other cells will populate if the player is still listed on your roster, if not they'll remain blank. (columns E thru U). It's about the best solution I've been able to come up with so again if you've got something better let me know. Quote Link to comment Share on other sites More sharing options...
squire12 Posted July 23, 2019 Share Posted July 23, 2019 is there a list of what position groups teams have drafted? I honestly do not know what position groups I have and have not drafted thus far. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 1 minute ago, squire12 said: is there a list of what position groups teams have drafted? I honestly do not know what position groups I have and have not drafted thus far. TCMD Team QB RB/FB TE WR OT INT OL EDGE INT DL ILB/LB SAFETY CB ST Cleveland Spiders MIA - QB TEN - RB/FB CHI - TE BAL - OT LAC - EDGE ARI - INT DL BUF - ILB/LB BUF - SAFETY BAL - CB San Francisco 49ers TB - WR BUF - OT BAL - INT OL BAL - EDGE ATL - INT DL TEN - SAFETY JAC - CB New York Jets LAC - QB IND - RB/FB ATL - TE ARI - WR ATL - OT CHI - INT OL CHI - EDGE LAC - CB LA - ST New York MadHatters CIN - RB/FB CIN - TE SEA - WR LA - OT TB - INT OL OAK - EDGE LA - INT DL OAK - SAFETY MIA - CB Denver Broncos IND - QB TEN - TE HOU - WR CHI - OT ATL - INT OL TEN - INT DL TB - ILB/LB IND - SAFETY LA - CB Washington Redskins CIN - QB ATL - RB/FB JAC - WR CIN - OT LAC - INT DL ARI - ILB/LB OAK - CB Green Bay Packers SEA - RB/FB IND - TE LAC - WR LAC - INT OL CHI - INT DL CHI - ILB/LB TB - SAFETY SEA - CB Detroit Lions LA - QB JAC - RB/FB LA - WR MIA - OT OAK - INT OL CIN - EDGE ATL - SAFETY TEN - CB Carolina Panthers HOU - QB LA - TE IND - WR SEA - OT TEN - INT OL JAC - EDGE MIA - INT DL ARI - SAFETY CHI - CB Minnesota Vikings ATL - QB LAC - RB/FB MIA - WR TEN - OT JAC - INT OL TB - INT DL LA - ILB/LB BAL - SAFETY Philadelphia Eagles LA - RB/FB OAK - WR JAC - OT CIN - INT OL TB - EDGE SEA - INT DL SEA - ILB/LB MIA - SAFETY BUF - CB New Orleans Saints BAL - QB BAL - RB/FB BAL - TE CHI - WR IND - INT OL BAL - INT DL ATL - ILB/LB LA - SAFETY HOU - CB Dallas Cowboys ARI - QB ATL - WR LAC - OT LA - EDGE HOU - INT DL CIN - ILB/LB SEA - SAFETY ARI - CB Steel City Renegades BUF - RB/FB LAC - TE TEN - WR BUF - INT OL HOU - EDGE CIN - INT DL TEN - ILB/LB CHI - SAFETY TB - CB Kansas City Chiefs CHI - RB/FB HOU - TE HOU - OT SEA - EDGE BUF - INT DL IND - ILB/LB LAC - SAFETY CIN - CB New England Patriots SEA - QB ARI - RB/FB TB - TE CIN - WR ARI - EDGE OAK - INT DL JAC - ILB/LB ATL - CB You can find this information in the Draft Order sheet. https://docs.google.com/spreadsheets/d/1i7-Zj2IKx5Q9OU1XUG3_8_ay_srpc8xwIsXV1RWhMpk/edit#gid=2090516226 1 Quote Link to comment Share on other sites More sharing options...
VigilantZombie Posted July 23, 2019 Share Posted July 23, 2019 1 minute ago, squire12 said: is there a list of what position groups teams have drafted? I honestly do not know what position groups I have and have not drafted thus far. One way to look is 2nd to last page of discussion has a list that was available at my last pick last night. And If you look at your roster, it says the team the player is on next to them. So you can figure out which position group you have drafted. Quote Link to comment Share on other sites More sharing options...
VigilantZombie Posted July 23, 2019 Share Posted July 23, 2019 Nice pick @samsel23 Quote Link to comment Share on other sites More sharing options...
VigilantZombie Posted July 23, 2019 Share Posted July 23, 2019 Hey guys, so mike needs feedback on the workbooks, the draft process, everything. He needs to know what we like, what we dont, what we might think could be improved or what not. I mean after all, that's the whole point of this test run. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 3 minutes ago, wwhickok said: One way to look is 2nd to last page of discussion has a list that was available at my last pick last night. And If you look at your roster, it says the team the player is on next to them. So you can figure out which position group you have drafted. Right....the Team Roster Info sheet in each one of our private workbooks cell range A28 thru C40 list the amounts spent on positions you drafted, zero dollars spent is a good way to tell if you drafted that position yet or not. Example: Position Group Cap Hit # of Players QB $0 0 RB/FB $2,553,864 3 TE $7,084,478 2 WR $10,169,480 6 OT $26,302,192 5 INT OL $21,895,000 3 EDGE $3,611,410 5 INT DL $20,044,660 6 ILB/LB $0 0 SAFETY $14,136,373 4 CB $22,704,404 7 ST $0 0 Total Pos. Group $128,501,861 41 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 3 minutes ago, wwhickok said: Hey guys, so mike needs feedback on the workbooks, the draft process, everything. He needs to know what we like, what we dont, what we might think could be improved or what not. I mean after all, that's the whole point of this test run. What he said. I know that my workbooks are so amazing that we don't need a discussion on just how amazing they are...haha. But it would be nice if you guys just let me know if we wanted to run the free agency or a portion of it for testing purposes. I've added a feature that will let you know how many bids are placed on the player and if you're bid is within the top 5 highest ranked or not. Keeping me in the dark sucks just so you guys know that. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 1 hour ago, EaglesPeteC said: I think for the real thing when we draft a position group, we should list who we actually want from that group to save us the hassle of cutting and you all the hassle of adding players and the just removing them The nice thing is adding them takes a second...the way this is set up it pulls them all in the moment I type in the overall pick number....Really easy stuff. The nightmare will be deleting them all from the rosters. I'd rather have it easy adding to be honest. If we phased the cut process out just for this initial roster building process, I could set it up so that what you label as cuts could be linked over so that we could essentially batch file cuts. Or better yet maybe something like the Trade Block sheet where you punch in the name there and it's linked back and once we get a big enough group of cuts we just run a formula to list them as UFA. Either way, I think we can get a solution to this issue for the real. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 23, 2019 Author Share Posted July 23, 2019 There goes the last QB group that I had my eye on. Quote Link to comment Share on other sites More sharing options...
bcb1213 Posted July 24, 2019 Share Posted July 24, 2019 3 hours ago, ny92mike said: TCMD Team QB RB/FB TE WR OT INT OL EDGE INT DL ILB/LB SAFETY CB ST Cleveland Spiders MIA - QB TEN - RB/FB CHI - TE BAL - OT LAC - EDGE ARI - INT DL BUF - ILB/LB BUF - SAFETY BAL - CB San Francisco 49ers TB - WR BUF - OT BAL - INT OL BAL - EDGE ATL - INT DL TEN - SAFETY JAC - CB New York Jets LAC - QB IND - RB/FB ATL - TE ARI - WR ATL - OT CHI - INT OL CHI - EDGE LAC - CB LA - ST New York MadHatters CIN - RB/FB CIN - TE SEA - WR LA - OT TB - INT OL OAK - EDGE LA - INT DL OAK - SAFETY MIA - CB Denver Broncos IND - QB TEN - TE HOU - WR CHI - OT ATL - INT OL TEN - INT DL TB - ILB/LB IND - SAFETY LA - CB Washington Redskins CIN - QB ATL - RB/FB JAC - WR CIN - OT LAC - INT DL ARI - ILB/LB OAK - CB Green Bay Packers SEA - RB/FB IND - TE LAC - WR LAC - INT OL CHI - INT DL CHI - ILB/LB TB - SAFETY SEA - CB Detroit Lions LA - QB JAC - RB/FB LA - WR MIA - OT OAK - INT OL CIN - EDGE ATL - SAFETY TEN - CB Carolina Panthers HOU - QB LA - TE IND - WR SEA - OT TEN - INT OL JAC - EDGE MIA - INT DL ARI - SAFETY CHI - CB Minnesota Vikings ATL - QB LAC - RB/FB MIA - WR TEN - OT JAC - INT OL TB - INT DL LA - ILB/LB BAL - SAFETY Philadelphia Eagles LA - RB/FB OAK - WR JAC - OT CIN - INT OL TB - EDGE SEA - INT DL SEA - ILB/LB MIA - SAFETY BUF - CB New Orleans Saints BAL - QB BAL - RB/FB BAL - TE CHI - WR IND - INT OL BAL - INT DL ATL - ILB/LB LA - SAFETY HOU - CB Dallas Cowboys ARI - QB ATL - WR LAC - OT LA - EDGE HOU - INT DL CIN - ILB/LB SEA - SAFETY ARI - CB Steel City Renegades BUF - RB/FB LAC - TE TEN - WR BUF - INT OL HOU - EDGE CIN - INT DL TEN - ILB/LB CHI - SAFETY TB - CB Kansas City Chiefs CHI - RB/FB HOU - TE HOU - OT SEA - EDGE BUF - INT DL IND - ILB/LB LAC - SAFETY CIN - CB New England Patriots SEA - QB ARI - RB/FB TB - TE CIN - WR ARI - EDGE OAK - INT DL JAC - ILB/LB ATL - CB You can find this information in the Draft Order sheet. https://docs.google.com/spreadsheets/d/1i7-Zj2IKx5Q9OU1XUG3_8_ay_srpc8xwIsXV1RWhMpk/edit#gid=2090516226 May want to look at this again. I'm 95 percent sure I'm the only one who hasn't taken a safety group yet. By the way if anyone wants tashaun Gipson or Justin Rei, Let me know lol Quote Link to comment Share on other sites More sharing options...
Scoundrel Posted July 24, 2019 Share Posted July 24, 2019 Best value so far with that Hou ILB pick 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 24, 2019 Author Share Posted July 24, 2019 9 minutes ago, bcb1213 said: May want to look at this again. I'm 95 percent sure I'm the only one who hasn't taken a safety group yet. By the way if anyone wants tashaun Gipson or Justin Rei, Let me know lol Kinda weird that I'm only seeing one safety left and we still have like 3 teams without a safety. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 24, 2019 Author Share Posted July 24, 2019 3 minutes ago, Counselor said: Best value so far with that Hou ILB pick yup...was on my big board last round and would have been my pick in the morning. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 24, 2019 Author Share Posted July 24, 2019 Yeah man something isn't right, it's showing SF with 4 safety positions. 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.