ny92mike Posted January 23, 2023 Share Posted January 23, 2023 43 minutes ago, EaglesPeteC said: My euphoric joy can balance out the sadness don't you worry God damn Pete, your team beat the brakes off of the Giants. We didn't have an answer to anything that night. Oddly, I'm not too sad about it, I think simply because we probably shouldn't have even been in it this year with having so many missing pieces. Just glad that we appear to have a front office and coaching staff that is pointing us in the right direction again. Congrats to Philly, better team won. Up to you guys now to represent the East, good luck. Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 1 hour ago, ny92mike said: @Deadpulse @MikeT14 @mountainpd @jch1911 @MaximusGluteus @Daniel Okay, I'm sure there are going to be some issues from spelling mistakes, wrong year and formula errors. Just too much for me to catch it all, so when testing please note anything you find regardless how small. https://docs.google.com/spreadsheets/d/19qsZajuOPDaGqCt2mVkApR40dVpsP5XZdpVyiOo_rV0/edit?usp=sharing Things I'm still working on is the waiver wire, trade block info and the draft. Any questions let me know. Thanks again guys. I checked your math on the NPV formulas on the FA bidding spreadsheet and it appears to be correct. Good idea to move Year 1 out of the NPV calculation so it isn't discounted since it is usually paid up front (and I think most spreadsheets have a problem recognizing period zero). Same with the signing bonus. Your discount rate at 10% is also much more realistic than some of the really high rates you had in the past. Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 1 hour ago, ny92mike said: @Deadpulse @MikeT14 @mountainpd @jch1911 @MaximusGluteus @Daniel Okay, I'm sure there are going to be some issues from spelling mistakes, wrong year and formula errors. Just too much for me to catch it all, so when testing please note anything you find regardless how small. https://docs.google.com/spreadsheets/d/19qsZajuOPDaGqCt2mVkApR40dVpsP5XZdpVyiOo_rV0/edit?usp=sharing Things I'm still working on is the waiver wire, trade block info and the draft. Any questions let me know. Thanks again guys. 1) Team layout page is clear and concise. It's good the players are in positional order with counts. 2) Tag and tender seems good. Formulas following. EFRA simple and solid. 3) I don't know if it's saving or not. I plugged in DeAnre Carter to sign. It's claiming I am failing the vet min per year. Not sure why. Is that based on base salary is the minimum? Doesn;t include bonus? FA BIDDING ROUND 01 FA Bid Slot #2 - UFA/Resign FA Bid # 2 New York Giants Contract Terms Bid Type UFA Length of Contract: 5 Contract Validation Criteria Position in Drop Down List WR APY Amount: $1,313,000 Valid Contract Type PASS Select Player from drop down list Yearly proration: $200,000 Required Contract Length PASS 1957 - DeAndre Carter - WR | GRD:0.0% - APY: $1,165,000 / CL:5 Total Contract Amount $6,565,000 Vet. Min Per year FAIL Select Contract Length: 5 Subsequent Yr % Rate PASS Enter Total Signing Bonus Amount: $1,000,000 Contract Structure Fails Validation Average Per Year (APY) PASS DeAndre Carter's Contract Demands 1957 Signing Bonus Amount PASS Contract Length: 5 Year ACQ'D Status Pos. Sort Player Identifier Prev. Team ID # Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Non-Prorated Cap Number Average Per Year (APY) $1,165,000 Player Name Age Subsequent 30% Rule Base Salary Values Signing Bonus: $485,000 1 2023 UFA ACT E 1957 - DeAndre Carter - WR LAC 1957 DeAndre Carter WR 30 7 0.0% $1,165,000 $1,000,000 $200,000 $1,200,000 Valid Low Value High Value Low High Negotiating w/ Other Team(s) 0 2 2024 UFA ACT E 1957 - DeAndre Carter - WR LAC 1957 DeAndre Carter WR 30 8 0.0% $1,210,000 $1,010,000 $200,000 $1,210,000 TRUE $840,000 $1,560,000 $640,000 $1,360,000 Contract Structure Appraisal Calculation 3 2025 UFA ACT E 1957 - DeAndre Carter - WR LAC 1957 DeAndre Carter WR 30 9 0.0% $1,255,000 $1,055,000 $200,000 $1,255,000 TRUE $847,000 $1,573,000 $647,000 $1,373,000 Base Salary NPV % Rate 10.00% 4 2026 UFA ACT E 1957 - DeAndre Carter - WR LAC 1957 DeAndre Carter WR 30 10 0.0% $1,300,000 $1,100,000 $200,000 $1,300,000 TRUE $878,500 $1,631,500 $678,500 $1,431,500 Base Salary NPV $4,572,748 5 2027 UFA ACT E 1957 - DeAndre Carter - WR LAC 1957 DeAndre Carter WR 30 11 0.0% $1,345,000 $1,400,000 $200,000 $1,600,000 TRUE $910,000 $1,690,000 $710,000 $1,490,000 Signing Bonus - NPV $1,000,000 6 2028 $0 $0 Resign Discount %. 0.00% 7 2029 $0 $0 Adj. Contract Offer Amount: $5,572,748 Avg. $1,113,000 $200,000 $1,313,000 Total $5,565,000 $1,000,000 0 $6,565,000 lol nevermind someone is messing with it now too. Formula says based off of base. I see it now. Ignore this. 1 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 FA BIDDING ROUND 01 FA Bid # 4 Bid Type UFA Position in Drop Down List RG Select Player from drop down list 1948 - Will Hernandez - RG | GRD:77.3% - APY: $5,850,832 / CL:3 Select Contract Length: 3 Enter Total Signing Bonus Amount: Will Hernandez's Contract Demands 1948 Contract Length: 3 Average Per Year (APY) $5,850,832 Signing Bonus: 645000 Negotiating w/ Other Team(s) 0 Contract Structure Appraisal Calculation Base Salary NPV % Rate 10.00% Base Salary NPV $0 Signing Bonus - NPV $600,000 Resign Discount %. 0.00% Adj. Contract Offer Amount: $600,000 Small formatting issue under signing bonus. Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 If a player is demanding 3 years, but we plug in two years and everything passes, how is that working this year? (see Will Hernandez example) FA BIDDING ROUND 01 FA Bid Slot #4 - UFA/Resign FA Bid # 4 New York Giants Contract Terms Bid Type UFA Length of Contract: 2 Contract Validation Criteria Position in Drop Down List RG APY Amount: $5,980,000 Valid Contract Type PASS Select Player from drop down list Yearly proration: $200,000 Required Contract Length PASS 1948 - Will Hernandez - RG | GRD:77.3% - APY: $5,850,832 / CL:3 Total Contract Amount $11,960,000 Vet. Min Per year PASS Select Contract Length: 2 Subsequent Yr % Rate PASS Enter Total Signing Bonus Amount: $500,000 Contract Structure Passes Validation Average Per Year (APY) PASS Will Hernandez's Contract Demands 1948 Signing Bonus Amount PASS Contract Length: 3 Year ACQ'D Status Pos. Sort Player Identifier Prev. Team ID # Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Non-Prorated Cap Number Average Per Year (APY) $5,850,832 Player Name Subsequent 30% Rule Base Salary Values Signing Bonus: 430000 1 2023 UFA ACT I 1948 - Will Hernandez - RG ARI 1948 Will Hernandez RG 28 5 77.3% $1,080,000 $5,000,000 $200,000 $5,200,000 Valid Low Value High Value Low High Negotiating w/ Other Team(s) 0 2 2024 UFA ACT I 1948 - Will Hernandez - RG ARI 1948 Will Hernandez RG 28 6 77.3% $1,125,000 $6,560,000 $200,000 $6,760,000 TRUE $3,640,000 $6,760,000 $3,440,000 $6,560,000 Contract Structure Appraisal Calculation 3 2025 $0 $0 Base Salary NPV % Rate 10.00% 4 2026 $0 $0 Base Salary NPV $10,963,636 5 2027 $0 $0 Signing Bonus - NPV $400,000 6 2028 $0 $0 Resign Discount %. 0.00% 7 2029 $0 $0 Adj. Contract Offer Amount: $11,363,636 Avg. $5,780,000 $200,000 $5,980,000 Total $11,560,000 $400,000 0 $11,960,000 Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 (edited) 7 minutes ago, MikeT14 said: Is that based on base salary is the minimum? Doesn;t include bonus? It failed it on base salary alone so this is a good question. Edited January 23, 2023 by MKnight82 Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 8 minutes ago, MikeT14 said: lol nevermind someone is messing with it now too. That was me. 1 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 This is looking good Mike. Trade Block is updated nicely. 1 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 2 minutes ago, MKnight82 said: It failed it on base salary alone so this is a good question. In my head APY is reached from everything right? Base + Bonus + roster + whatever Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 Just now, MikeT14 said: In my head APY is reached from everything right? Base + Bonus + roster + whatever Mike's NPV formula which compares to APY includes the base + bonuses yes. Idk whether the league min rules apply to only base salary or not, which is maybe why he has the formula set that way. 2 Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 @MikeT14 after doing some reading online I think the formula is correct. Only base salary applies when determining minimum veteran salary. 2 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted January 23, 2023 Share Posted January 23, 2023 13 minutes ago, MKnight82 said: @MikeT14 after doing some reading online I think the formula is correct. Only base salary applies when determining minimum veteran salary. I was reading up on it too. Agreed. 1 Quote Link to comment Share on other sites More sharing options...
EaglesPeteC Posted January 23, 2023 Share Posted January 23, 2023 1 hour ago, ny92mike said: God damn Pete, your team beat the brakes off of the Giants. We didn't have an answer to anything that night. Oddly, I'm not too sad about it, I think simply because we probably shouldn't have even been in it this year with having so many missing pieces. Just glad that we appear to have a front office and coaching staff that is pointing us in the right direction again. Congrats to Philly, better team won. Up to you guys now to represent the East, good luck. Thanks lol. That game was a party in our house. Hopefully we can keep the party going. Both the Giants and Eagles outperformed preseason expectations. No way I thought we were a number 1 seed and legit SB contender this year. I am glad it is abundantly clear that we have our QBOTF Quote Link to comment Share on other sites More sharing options...
MKnight82 Posted January 23, 2023 Share Posted January 23, 2023 4 minutes ago, EaglesPeteC said: Thanks lol. That game was a party in our house. Hopefully we can keep the party going. Both the Giants and Eagles outperformed preseason expectations. No way I thought we were a number 1 seed and legit SB contender this year. I am glad it is abundantly clear that we have our QBOTF You guys beat up on a pretty week NFC this year IMO. Quote Link to comment Share on other sites More sharing options...
EaglesPeteC Posted January 23, 2023 Share Posted January 23, 2023 1 minute ago, MKnight82 said: You guys beat up on a pretty week NFC this year IMO. Listen, can't penalize us because the rest of you can't get your **** together lol Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.