tjanderson321
|
Creating New Pro Bowl ScriptI create an All Star Team in the leagues I am in twice a season. I like the Pro Bowl Script but it isn't as accurate as I would like it, so I came up with my own formulas some which I took from the Pro Bowl script and I have them entered in an excel spreadsheet. Then I enter the players in our league in the spreadsheet and it gives me a score. Well this takes me several hours to do and that is why I only do it twice a season. I was hoping someone could create a script for me so I can do this quicker. Agents really like it cause it is an unbiased way to choose an all star team. I have tried to change the pro bowl script to how I would like it but it is all greek to me and have failed miserably. So if a script writer could create one for me or change the pro bowl script to my forumulas that would be great. I have posted the formulas below.
Formulas for All Star Team:
QB:
(Passing Yards / 12.5) + (TD's x 3) + (INT's x -2) + (Fumbles x -3) + (QB Rating) = Total; (Total x Passing %) = Final Total
If Passing % is 55% then when you multiply it with the total it would be .55
HB:
(Rushing Yards / 12.5) + (TD's x 3) + (Receptions x 1.5) + (Drops x -1) + (Reception TD's x 4) + (Reception Yards / 12.5) + (Broken Tackles x .5) + (Fumbles Lost x -3) = TOTAL
FB:
(Rushing Yards / 12.5) + (TD's x 3) + (Receptions x 1.5) + (Drops x -1) + (Reception TD's x 4) + (Reception Yards / 12.5) + (Broken Tackles x .5) + (Fumbles Lost x -3) + (Pancakes x 2) = TOTAL
WR:
(Reception Yards / 12.5) + (Reception TD's x 4) + (Receptions x 1) + (Drops x -1.5) + (Fumbles Lost x -3) = TOTAL
TE:
(Reception Yards / 12.5) + (Reception TD's x 4) + (Receptions x 1) + (Drops x -1) + (Pancakes x 2) + (Fumbles Lost x -3) = TOTAL
DE:
(Tackles x 1) + (Sacks x 2.5) + (Hurries x 1) + (TFL x 1.5) + (Forced Fumbles x 3) + (Fumble Recovery x 1) + (Interceptions x 5) + (Pass Deflections x 3) + (Missed Tackles x -2) + (Safety x 3.5) + (Defensive TD's x 10) = TOTAL
DT:
(Tackles x 4) + (Sacks x 5) + (Hurries x 2) + (TFL x 1.5) + (Forced Fumbles x 3) + (Fumble Recovery x 1) + (Interceptions x 5) + (Pass Deflections x 3) + (Missed Tackles x -2) + (Safety x 3.5) + (Defensive TD's x 10) = TOTAL
LB:
(Tackles x 1) + (Sacks x 2.5) + (Hurries x 1) + (TFL x 1.5) + (Forced Fumbles x 3) + (Fumble Recovery x 1) + (Interceptions x 5) + (Pass Deflections x 3) + (Missed Tackles x -2) + (Safety x 3.5) + (Defensive TD's x 10) = TOTAL
CB/FS/SS:
(Tackles x .5) + (Sacks x 2.5) + (Hurries x 1) + (TFL x 2) + (Forced Fumbles x 3) + (Fumble Recovery x 2) + (Interceptions x 5) + (Pass Deflections x 3) + (Missed Tackles x -2) + (Safety x 3.5) + (Defensive TD's x 10) = TOTAL
K:
Field Goals: 50+ makes = 5pts, misses = -1pt
40+ makes = 4pts, misses = -2pts
30+ makes = 3pts, misses = -3pts
20+ makes = 2pts, misses = -4pts
under 20 makes = 1pt, misses = -5pts
XP's: Number of made XP's divided by 2. Missed XP multiply by -5.
Add all points and that is your final total.
|
