Rookie Bonuses?

[Royal Hawaiian Opihi]

Anyone interested in tackling the rookie bonuses for this year?

[A Zombie Pirate I Be]

I can take a stab at it. I am writing a s/s to help calculate. Just need to do a little testing to be sure I got it right.

Quick assumption... The player's ranking is taken directly from the MFL Site's "Top Player" list, correct?

When do you need them?

[Royal Hawaiian Opihi]

Yes... go to our league webpage, and look at the TOP PLAYERS for last year's stats.
Thanks. No rush on this. By the end of this month, probably... so we can get things set for the hard cap period.
Thanks!

[A Zombie Pirate I Be]

Sounds good.
I already have a s/s mostly done. Should have the numbers by EOW next week. Probably sooner.

Any excuse to write a s/s - my wife thinks I'm nuts...

[Royal Hawaiian Opihi]

excellent. thanks.
my wife is the spreadsheet guru. I can barely use them.

[wchmego]

Question, do we go by weeks 1-14 or weeks 1-17?

[Royal Hawaiian Opihi]

Great question. I believe just weeks 1-14... since that's our regular season.
But I checked the rules and there's nothing that clarifies it.
Hmmm...

[Royal Hawaiian Opihi]

Burt says he's always calculated them via the entire regular NFL season.
So, I guess we go with that.

[A Zombie Pirate I Be]

Owner Name Pos Team 2020 Yrs / 2020 Salary / Drft Rnd / Pos Rank / Rookie Bonus /2021 Salary

Burners David Montgomery RB CHI 4 $678 1 4 $450 $1,196
Burners D.J. Moore WR CAR 3 $627 1 23 $100 $790
Burners Jonnu Smith TE TEN 2 $133 4 10 $ 13 $160
Chickens Jonathan Taylor RB IND 5 $500 1 5 $450 $1,000
Chickens Justin Jefferson WR MIN 4 $270 1 7 $350 $647
Freedom Lamar Jackson QB BAL 3 $751 1 10 $ 75 $902
Freedom Ronald Jones RB TBB 2 $545 1 15 $250 $850
Freedom J.K. Dobbins RB BAL 5 $460 1 23 $150 $656
Opihi Nick Chubb RB CLE 3 $1,089 1 11 $250 $1,448
Opihi D'Andre Swift RB DET 5 $440 1 22 $150 $634
Pirates Josh Jacobs RB LVR 4 $750 1 8 $300 $1,125
Pirates James Conner RB PIT 2 $660 2 24 $113 $839
Pirates DK Metcalf WR SEA 4 $411 1 6 $350 $803
Pirates Terry McLaurin WR WAS 4 $182 2 21 $ 75 $276
Pirates CeeDee Lamb WR DAL 5 $300 1 25 $100 $430
Predators Deshaun Watson QB HOU 2 $504 2 3 $225 $780
Predators Josh Allen QB BUF 3 $232 3 1 $200 $456
Predators Calvin Ridley WR ATL 3 $610 1 4 $450 $1,121
Predators A.J. Brown WR TEN 4 $376 2 12 $225 $639
Ramsters Kyler Murray QB ARI 4 $485 1 2 $350 $884
Ramsters Cooper Kupp WR LAR 2 $665 2 27 $ 50 $782
Ramsters Curtis Samuel WR CAR 2 $247 2 20 $150 $422
Ramsters Brandon Aiyuk WR SFO 5 $200 2 33 $ 20 $240
Ramsters Diontae Johnson WR PIT 4 $198 2 22 $ 75 $293
Roosters C Edwards-Helaire RB KCC 5 $480 1 18 $200 $728
Roosters Antonio Gibson RB WAS 5 $340 2 14 $188 $562
Roosters Marquise Brown WR BAL 4 $264 1 36 $ 25 $316
Roosters Mark Andrews TE BAL 3 $196 3 6 $ 50 $266
Roosters Mike Gesicki TE MIA 3 $159 2 7 $ 75 $250
Scorpions Chase Claypool WR PIT 5 $110 3 18 $100 $221
Scorpions Noah Fant TE DEN 4 $110 2 12 $ 38 $159
Swords Miles Sanders RB PHI 4 $722 1 21 $150 $945
Wolverines Justin Herbert QB LAC 5 $240 2 8 $ 75 $339
Wolverines Dalvin Cook RB MIN 2 $1,089 1 2 $450 $1,648
Wolverines Tee Higgins WR CIN 5 $210 2 28 $ 50 $281
Wolverines T.J. Hockenson TE DET 4 $220 1 4 $150 $392

[A Zombie Pirate I Be]

OK. I think I got these right. I wrote a s/s to somewhat automate the process. I ran a few tests on the s/s and the numbers looked good on the players I reviewed.
Next year the process should take about 15 minutes to get the bonuses all calculated..

The headers on the above post are not aligned correctly. Still learning how to format in this tool :-) However, the Player Name is Bold and the rookie bonus is in Red Bold

If there are any issues or if I got something wrong, let me know...

[Preds]

Dave, thanks for doing the legwork on this, however, your 2021 salaries are off. The 10% annual increase is only on the BASE salary, not the rookie bonus.

For example - Josh Allen base salary in 2020 was 232 x 10 % increase (23) for a sum-total of 255 + 200 rookie bonus for being the #1 QB overall as a 3rd rd pick, for a total 2021 salary of 455.

Another example - Calvin Ridley would be 610 x 10% increase (61) for a sum-total of 671 +450 for finishing as the #3 WR as a 1st rd pick, for a total 2021 salary of 1121.

It looks like you calculated this on a spreadsheet, thus it's a pretty easy fix, just change your formula to do the 10% increase on the base salary only and then add the bonus and it should all be correct.

[A Zombie Pirate I Be]

S/S is updated with the fix for the total new salary. ((OldSalary*1.1) + Rookiebonus).

[predator06]

So, if you don't have anyone on here...you suck at drafting? I need to fire my GM

[Liquid Swords]

Awesome, Dave! Thanks!

And yes, they've always been based on weeks 1-17.

[Royal Hawaiian Opihi]

Thanks so much, Dave! And nice catch on the base salary, Mike. Thanks.

[A Zombie Pirate I Be]

Sorry about the salaries.

I thought I noticed that the rookie bonus was included last year. I guess I should have read the rules.

If needed, I can repost the list with the corrected salaries.

[Preds]

Originally Posted by A Zombie Pirate I Be

Sorry about the salaries.

I thought I noticed that the rookie bonus was included last year. I guess I should have read the rules.

If needed, I can repost the list with the corrected salaries.

Dave,

Just edit the post with the bonuses with the corrected data.

[Burt the Butcher]

Originally Posted by A Zombie Pirate I Be

Sorry about the salaries.

I thought I noticed that the rookie bonus was included last year. I guess I should have read the rules.

If needed, I can repost the list with the corrected salaries.

I can't speak for who is going to do this, but the salary total here is not taken into account when creating new MFL site - just the total bonus, and whether the salary maxing out before full bonus is applied. So my suggestion, just verify if any player maxes out before full salary is applied, and adjust those bonuses.

[Preds]

Originally Posted by predator06

So, if you don't have anyone on here...you suck at drafting? I need to fire my GM

In recent drafts yeah! Though in fairness I believe you've traded many of your 1sts away AND have been drafting late.

That said, you had a couple nice rookies a few years ago that maxed out due to stellar production that brought you a championship!

[A Zombie Pirate I Be]

Originally Posted by Burt the Butcher

I can't speak for who is going to do this, but the salary total here is not taken into account when creating new MFL site - just the total bonus, and whether the salary maxing out before full bonus is applied. So my suggestion, just verify if any player maxes out before full salary is applied, and adjust those bonuses.

I watched the max salaries and didn't notice any player's maxing on salary. So should be good.
I assume everyone keeps tabs on thier own players, so any errors will be reported.

[Liquid Swords]

Creating new app and the 2021 values listed above are incorrect. Guessing it wasn't updated with proper calculation.

[A Zombie Pirate I Be]

Originally Posted by Liquid Swords

Creating new app and the 2021 values listed above are incorrect. Guessing it wasn't updated with proper calculation.

No. Per note above, it was indicated that it was unnecessary. I will update later today. I have the new numbers, so will be fairly easy... Will be after 4:30 (MT)

[Preds]

Originally Posted by A Zombie Pirate I Be

No. Per note above, it was indicated that it was unnecessary. I will update later today. I have the new numbers, so will be fairly easy... Will be after 4:30 (MT)

Maybe you misunderstood, I think I said to just edit the original post with the correct info, rather than a new post with the corrected info.

[A Zombie Pirate I Be]

No worries... I will update later today.
Might be able to do it a little earlier. I just had a meeting cancelled and depending on how busy things are I might be able to sneak away for a few...

[Liquid Swords]

Originally Posted by A Zombie Pirate I Be

No worries... I will update later today.
Might be able to do it a little earlier. I just had a meeting cancelled and depending on how busy things are I might be able to sneak away for a few...

No rush. It's more for historical purposes here. I don't need it for the app updates...the bonus is all i need for app which is correct above.

[A Zombie Pirate I Be]

Salaries should be corrected.
Note: I use 'roundup' in my formula - so depending on what you use, there might be rounding differences...
Let me know if you see any issues - discrepancies

[Royal Hawaiian Opihi]

Thanks, guys! Appreciate the diligence.

[A Zombie Pirate I Be]

If I can be trusted to get it right next year, my s/s is ready.
Should be a quick process.
A few copy/pastes, a couple of tweaks to some player names to match MLF, a few random verifications, and I'm there.

[Scorpions]

just slight differences, we use round off, so if its .5 or higher it rounds, if its .4 or lower round down. so far roster app is correct.