Wanted to offer a scholarship... Topic

https://imgur.com/a/3nk0U
3/23/2018 6:47 PM
Yeah, had that happen a few times. It's a real bummer. For this reason, I always add a little more AP after I do the math.
3/23/2018 7:03 PM
Posted by pallas on 3/23/2018 7:03:00 PM (view original):
Yeah, had that happen a few times. It's a real bummer. For this reason, I always add a little more AP after I do the math.
Me too, I always add 2 AP more than what I calculated was needed to be safe after having the same thing happen early in 3.0.
3/23/2018 9:20 PM
you can use this formula - I keep an excel page open at the corner of my screen just for this - you plug in the points spent, the percentage achieved and it tells you how many more points you need to spend, ASSUMING THE WORST for rounding. It's never failed

=ROUNDUP((B3/(B4-0.5))*(100.5-B4),0)

B3 is the points spent so far, B4 is the percentage achieved
3/24/2018 10:27 AM
do we know whether the stated percentage "open" is rounded or truncated?
3/24/2018 9:57 PM
Posted by deroches on 3/24/2018 10:27:00 AM (view original):
you can use this formula - I keep an excel page open at the corner of my screen just for this - you plug in the points spent, the percentage achieved and it tells you how many more points you need to spend, ASSUMING THE WORST for rounding. It's never failed

=ROUNDUP((B3/(B4-0.5))*(100.5-B4),0)

B3 is the points spent so far, B4 is the percentage achieved
I've also used a mathematically equivalent formula and it has never failed.
4/5/2018 7:33 PM
Posted by metsmax on 3/24/2018 9:57:00 PM (view original):
do we know whether the stated percentage "open" is rounded or truncated?
Rounded
4/5/2018 7:33 PM
Wanted to offer a scholarship... Topic

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2026 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.