squire12 Posted November 5, 2017 Share Posted November 5, 2017 I have a project that I am working on that is looking at the draft capital that GB (and eventually ) the other 31 teams have utilized to build their team. Going to take a little time to compile all the information for each team, but once I get the process streamlined, it should go quicker. Currently have GB and MIN finished. Picked MIN as there was some discussion earlier this season comparing the 2 defenses. I am using the pick value chart on drafttek and using the points for each pick as the "draft capital" for each team with each pick. Will try to remove players that were acquired via FA (that were drafted by a different team). GB Total Offense DEF 8959.5 3611.5 5348 MN Total Offense DEF 8866.8 2910.8 5956 With some time, I can separate things out by starters and bench, but that will take some time. More to come. When I get things further along, I will post the google sheets. Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 Det Total Offense DEF 10375.7 6275 4100.7 CHI Total Offense DEF 9651.5 6119 3532.5 Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 NFC South ATL Total Offense DEF 12475.5 6229.9 6245.6 CAR Total Offense DEF 16726.6 7879.6 8847 NO Total Offense DEF 9369 3303 6066 TB Total Offense DEF 12365.4 7391.2 4974.2 Link to comment Share on other sites More sharing options...
Norm Posted November 5, 2017 Share Posted November 5, 2017 Wow NO surprised me Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 10 minutes ago, NormSizedMidget said: Wow NO surprised me how so? Link to comment Share on other sites More sharing options...
CWood21 Posted November 5, 2017 Share Posted November 5, 2017 Do you have this on a Google Doc or Excel spreadsheet? Link to comment Share on other sites More sharing options...
Norm Posted November 5, 2017 Share Posted November 5, 2017 35 minutes ago, squire12 said: how so? They just seem offensive minded. After I thought about it, sure they've been taking d guys high. Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 1 hour ago, CWood21 said: Do you have this on a Google Doc or Excel spreadsheet? YES Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 1 hour ago, NormSizedMidget said: They just seem offensive minded. After I thought about it, sure they've been taking d guys high. Remember, I am removing FA acquisitions that were high picks from other teams, and not tracking down high picks by team A that has moved onto another team and tabulating that for team A having used the draft capital on that player. It is something that might be doable down the road once the info is all in 1 place and some formulas could be set up. Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 Link to google sheets. NFC teams done https://docs.google.com/spreadsheets/d/1MlybPWPhPW1TWV61YaDqReEmm875g59IERrWvojbJ7A/edit#gid=1306701460 Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 DAL Total Offense DEF 10208 6190.8 4017.2 NYG Total Offense DEF 9272.5 5415.9 3856.6 PHI Total Offense DEF 11439.6 6373.2 5066.4 WAS Total Offense DEF 9593.9 5350.7 4243.2 Link to comment Share on other sites More sharing options...
squire12 Posted November 5, 2017 Author Share Posted November 5, 2017 SEA Total Offense DEF 6042.1 2625.3 3416.8 ARI Total Offense DEF 10160.2 3921.2 6239 LAR Total Offense DEF 12894.8 7968.8 4926 SF Total Offense DEF 10112.1 1815.6 8296.5 Link to comment Share on other sites More sharing options...
incognito_man Posted November 6, 2017 Share Posted November 6, 2017 Did you include picks traded away for players as well? Or just picks that were used? Link to comment Share on other sites More sharing options...
squire12 Posted November 6, 2017 Author Share Posted November 6, 2017 Going by current roster construction. Using this site https://www.rosterresource.com/nfl-depth-charts/ Link to comment Share on other sites More sharing options...
incognito_man Posted November 6, 2017 Share Posted November 6, 2017 2 hours ago, squire12 said: Going by current roster construction. Using this site https://www.rosterresource.com/nfl-depth-charts/ that's why seattle is artificially low I was wondering how that happened. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.