ny92mike Posted December 10, 2017 Author Share Posted December 10, 2017 I'm working on the private trade block / draft board doc and could use your opinions on the layout, if you can think of anything you'd like added, etc. I'm at that point of making copies of this for each team and trying to add something later would be a ton of work. Other linked sheets aren't set up yet and can't be until a copy is made for each team but please give this a look over and use the drop down list. post any feedback and / or suggestions here. I need to get this done soon so that I can move to the next of many projects. https://docs.google.com/spreadsheets/d/1R2MPasCnZohz88xmHfSoIjiSMnUI_O4bcuppMitwl4Y/edit?usp=sharing Thanks On another note, any veterans of the mock interested in helping me manage it this year, once it starts please message me. I could use the help as jrry32 isn't able to commish this year. Link to comment Share on other sites More sharing options...
squire12 Posted December 11, 2017 Share Posted December 11, 2017 On 12/10/2017 at 12:42 PM, ny92jefferis said: I'm working on the private trade block / draft board doc and could use your opinions on the layout, if you can think of anything you'd like added, etc. I'm at that point of making copies of this for each team and trying to add something later would be a ton of work. Other linked sheets aren't set up yet and can't be until a copy is made for each team but please give this a look over and use the drop down list. post any feedback and / or suggestions here. I need to get this done soon so that I can move to the next of many projects. https://docs.google.com/spreadsheets/d/1R2MPasCnZohz88xmHfSoIjiSMnUI_O4bcuppMitwl4Y/edit?usp=sharing Thanks On another note, any veterans of the mock interested in helping me manage it this year, once it starts please message me. I could use the help as jrry32 isn't able to commish this year. I like the trade up or down for the draft picks. Makes it easier to see what picks are available for teams looking to move up/down. Assuming that it will be linked to the big board it will work well. As for the bottom part with players on the trade block: I like the information that it carries on contract and length/cap hit, etc. Might be an me only issue, but I would love the notes aspect on the left so I do not have to scroll over to see that info. Having things fit on a screen without having to scroll is nice and makes things more usable. Not sure if that is just something with the test aspect of this or not. Side Note....what are you going to do with a NYG top 5 draft pick?? Link to comment Share on other sites More sharing options...
ny92mike Posted December 11, 2017 Author Share Posted December 11, 2017 2 hours ago, squire12 said: I like the trade up or down for the draft picks. Makes it easier to see what picks are available for teams looking to move up/down. Assuming that it will be linked to the big board it will work well. As for the bottom part with players on the trade block: I like the information that it carries on contract and length/cap hit, etc. Might be an me only issue, but I would love the notes aspect on the left so I do not have to scroll over to see that info. Having things fit on a screen without having to scroll is nice and makes things more usable. Not sure if that is just something with the test aspect of this or not. Side Note....what are you going to do with a NYG top 5 draft pick?? Quick question are you able to zoom out of the doc? For me the option is in the upper left side of the ribbon. I'll see what I can do to move the notes column over, the scrolling does suck. I use my desktop to work on this project and it has a bigger screen, so when i'm on the laptop, I reduce the workbook to 75% so that it displays everything, font is a little smaller but it works. Thanks for the feedback, let me know if you think of anything else. edit: The Giants have had one disappointing season to say the least. As for the first pick, I've got a couple different directions but will hold off should another Giants fan want to get involved. Link to comment Share on other sites More sharing options...
EaglesPeteC Posted December 12, 2017 Share Posted December 12, 2017 Now that the Eagles Super Bowl chances have been brutally ripped to shreds.......what did i miss? Link to comment Share on other sites More sharing options...
squire12 Posted December 12, 2017 Share Posted December 12, 2017 3 minutes ago, EaglesPeteC said: Now that the Eagles Super Bowl chances have been brutally ripped to shreds.......what did i miss? No need to be so melodramatic Link to comment Share on other sites More sharing options...
EaglesPeteC Posted December 12, 2017 Share Posted December 12, 2017 11 minutes ago, squire12 said: No need to be so melodramatic Whose being melodramatic? Link to comment Share on other sites More sharing options...
ny92mike Posted December 12, 2017 Author Share Posted December 12, 2017 3 hours ago, EaglesPeteC said: Now that the Eagles Super Bowl chances have been brutally ripped to shreds.......what did i miss? Yeah man that really sucks. Heart breaking, wentz was having such a great season too. Link to comment Share on other sites More sharing options...
ny92mike Posted December 13, 2017 Author Share Posted December 13, 2017 On 12/11/2017 at 3:43 PM, squire12 said: I like the trade up or down for the draft picks. Makes it easier to see what picks are available for teams looking to move up/down. Assuming that it will be linked to the big board it will work well. As for the bottom part with players on the trade block: I like the information that it carries on contract and length/cap hit, etc. Might be an me only issue, but I would love the notes aspect on the left so I do not have to scroll over to see that info. Having things fit on a screen without having to scroll is nice and makes things more usable. Not sure if that is just something with the test aspect of this or not. Side Note....what are you going to do with a NYG top 5 draft pick?? Fixed the scrolling issue by moving the notes column (way harder than it sounds) to the far left. Link to comment Share on other sites More sharing options...
ny92mike Posted December 13, 2017 Author Share Posted December 13, 2017 Would you guys prefer to keep track of your rosters / depth charts within a forum thread? The doc we've used in the past was used by some of you while most posted in the forum in hopes of getting feedback. Link to comment Share on other sites More sharing options...
squire12 Posted December 13, 2017 Share Posted December 13, 2017 1 minute ago, ny92jefferis said: Would you guys prefer to keep track of your rosters / depth charts within a forum thread? The doc we've used in the past was used by some of you while most posted in the forum in hopes of getting feedback. I think with the new site, copying things from the workbooks to the forum to paste depth charts and other info is much smoother. I like the forum aspect of posting depth charts. Maybe nice to have a collection for considering awards for different aspects. Thanks for moving the notes column. Link to comment Share on other sites More sharing options...
ny92mike Posted December 14, 2017 Author Share Posted December 14, 2017 You guys good with using these projected Tag Values? Projected 2018 Tag Values by Position Position Pos. Exclusive Non-exclusive Transition Cornerback CB $15,114,828 $13,637,566 $13,234,844 Defensive End 34DE $18,445,988 $15,801,998 $15,234,906 Defensive End 43DE $18,445,988 $15,801,998 $15,234,906 Defensive Tackle 34DT $14,992,003 $12,575,401 $11,842,725 Defensive Tackle 43DT $14,992,003 $12,575,401 $11,842,725 Kicker K $5,360,261 $4,489,852 $4,622,911 Kicker P $5,360,261 $4,489,852 $4,622,911 Linebacker 34OLB $15,774,528 $13,820,706 $11,948,860 Linebacker 43OLB $15,774,528 $13,820,706 $11,948,860 Linebacker ILB $15,774,528 $13,820,706 $11,948,860 Offensive Lineman C $15,273,678 $13,569,536 $13,291,699 Offensive Lineman LG $15,273,678 $13,569,536 $13,291,699 Offensive Lineman LS $15,273,678 $13,569,536 $13,291,699 Offensive Lineman LT $15,273,678 $13,569,536 $13,291,699 Offensive Lineman RG $15,273,678 $13,569,536 $13,291,699 Offensive Lineman RT $15,273,678 $13,569,536 $13,291,699 Quarterback QB $22,957,997 $19,926,999 $21,007,219 Running Back FB $13,140,113 $11,508,023 $9,895,089 Running Back RB $13,140,113 $11,508,023 $9,895,089 Safety S $11,885,235 $10,327,647 $10,243,618 Tight End TE $10,925,786 $9,041,157 $9,035,332 Wide Receiver WR $17,010,728 $14,485,346 $15,389,499 This is what we used last year. 2017 Tag Values Used in Last Mock Position Pos. FRANCHISE TRANSITION Defensive End 34DE $14,656,200 $12,483,133 Defensive Tackle 34DT $15,150,000 $12,520,000 Linebacker 34OLB $16,272,665 $13,096,482 Defensive End 43DE $14,656,200 $12,483,133 Defensive Tackle 43DT $15,150,000 $12,520,000 Linebacker 43OLB $16,272,665 $13,096,482 Offensive Lineman C $10,604,400 $8,938,433 Cornerback CB $15,688,060 $13,952,630 Running Back FB $9,825,000 $7,879,190 Linebacker ILB $16,272,665 $13,096,482 Kicker K $4,307,000 $3,834,917 Offensive Lineman LG $10,379,200 $9,043,367 Offensive Lineman LS $1,142,600 $1,065,300 Offensive Lineman LT $13,940,000 $12,534,767 Kicker P $3,931,600 $3,412,800 Quarterback QB $23,825,000 $21,959,100 Running Back RB $9,825,000 $7,879,190 Offensive Lineman RG $10,379,200 $9,043,367 Offensive Lineman RT $13,940,000 $12,534,767 Safety S $10,455,958 $9,187,024 Tight End TE $9,982,400 $8,509,950 Wide Receiver WR $15,069,090 $13,757,878 btw, I love this new forum, makes it so easy copy and pasting info from the workbooks. Link to comment Share on other sites More sharing options...
squire12 Posted December 14, 2017 Share Posted December 14, 2017 As long as those numbers are close to what the NFL numbers will be, they will work for me. Agreed on the copy and pasting into the new forum. Link to comment Share on other sites More sharing options...
ny92mike Posted December 17, 2017 Author Share Posted December 17, 2017 Can someone refresh my memory? If releasing a player that has guaranteed base attached to their contract in year 2019, are those monies pushed to the current year of the contract? Or, is that money pushed to the following years "dead money"? I know that all prorated monies are pushed to the current year if released or traded but can't recall if it's the same for guar. base. Link to comment Share on other sites More sharing options...
EaglesPeteC Posted December 18, 2017 Share Posted December 18, 2017 4 hours ago, ny92jefferis said: Can someone refresh my memory? If releasing a player that has guaranteed base attached to their contract in year 2019, are those monies pushed to the current year of the contract? Or, is that money pushed to the following years "dead money"? I know that all prorated monies are pushed to the current year if released or traded but can't recall if it's the same for guar. base. Yes all guarentees get pushed up if released not traded though because new team takes that on Link to comment Share on other sites More sharing options...
ny92mike Posted December 18, 2017 Author Share Posted December 18, 2017 15 hours ago, EaglesPeteC said: Yes all guarentees get pushed up if released not traded though because new team takes that on Dang...back to the drawing board. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.