Off Season project

Mod's feel free to move this if it doesn't belong here.

I'm currently working on a rather large project for this off season.
The project includes making a spreadsheet for all of the following.

2013 salary cap information for each team. Assuming I can find enough information each teams salary cap page will include players under contract for 2013, each players cap value, dead money if cut, and an estimate on dead money if traded. The sheet will also contain space for dead money from players to include in the calculations. Final calculation will include an estimate for the league cap, amount of rollover from 2012 to 2013 and provide the total cap. It will then subtract rosterd playes cap value and any dead money the team is carrying and provide a total remaining under cap.
Each sheet will also include depth charts and team needs.
I also intend to give each team 2 numerical rankings that effect how they draft. Each ranking being 1-10. The first ranking indicates their philosophy of drafting best player available or best player that fits need. 1 being always drafting best player available and 10 always best player based on need.
the second number indicates how likely they are to trade up, or down, 1 being aggressive at trading up for players that fit their philosophy, 10 being agressive on trading down if they feel the draft slot is not equal to what they want to draft, 5 being somehwere between the two. Patriots for example would probably be a 1 on the first and 10 on the latter. While Tanny would be a 8 on the first and a 2 on the latter.


Additionally a spread sheet is being made with a draft pick matrix, and space to include documentation on trades.

Another spread sheet is being made with the draft order for each round and will reflect proper pick rotation in the latter rounds (the initial version will be based on estimates for whoever is still in contention when I get to that portion.) A final version will be released after the Superbowl.

Another spreadsheet is being made listing all free agents as well as an estimate on signing costs. (yes highly subjective and theoretical).

another spreadsheet is being made listing probably around 800 draft prospects. The data included there will be a draft rating, a positional rating, and the rating from several different draft resource sites and a final composite rating for each player.

All information will of course be modifiable.

Now, the reason(s) for this post.
First I need recommendation what scouting sites to use rankings from. I'm currently planning on using base rankings from CBSSports.com and Drafttek. Probably the NFL.com site. Kind of iffy on Walterfootball, but probably will include for a reference site as well.

If you know of a good website for salary cap information for 2013, including player breakdowns on cap hit to cut like NYJETSCAP.com does, for each team or any team please let me know.

Assistance on determing the value of free agents on the market would be a plus.

Why am I doing this? I'm a geek, I love digging through numbers and organizing crap. Which is remarkable considering I'm dyslexic (hence my horrible spelling and punctuation). But I also like to run different scenarios of how the off season may play out, including mocking Free Agent signings for teams, trades between teams, and of course the draft.

And of course when completed, and that will depend on my free time over the next couple of weeks, will be made available to anyone who wants to use the tools.

Just to recap
Each teams Salary cap information
Each teams depth Chart
Each teams perceived needs
Draft pick matrix
Draft pick sheet for each round.
complete prospect list, or at least as complete as possible.
Free agent list, along with estimated value (assuming enough feedback)

And, since I'm far from an expert with Spreadsheets if I can find a way to link one sheet to another so when a draft pick is selected it removes them for the other list, but I'm not sure the spreadsheet will let me do that. I'd write a program to do it all but it's been 30 years since I've coded anything and that was in Pascal.

Anyways, if theres any interest in this let me know

 

Hardest part will be tracking down cap information for 32 teams, the rest is pretty much just data entry and a few judgement calls.

Though I think I'm going to put the prospects in a database program rather than a spreadsheet, better sorting flexibility. Probably will use open office.

 

I take that back, hardest part will be judging cap hit for trading players since contract information is vague at best.