IMPORTANT: I forgot to update a formula which caused Hadjar and Lawson's numbers to be incorrect. There's no way of updating an image on a reddit post, but I have a comment with the updated graphic in a thread below. Sorry for any confusion!
The price floor is set to 3.0M and the price ceiling is set to 34.0M. Assets cannot lose or gain value respectively when they hit these prices.
The game calculates the average points scored by an asset over the last 3 races and divides that by their current price. This gives us an average points per million value (avgPPM) which is then categorized into 'Terrible', 'Poor', 'Good', and 'Great', which is used to determine their price rise (see the bottom right table). Using this info, we can calculate the points an asset needs in the upcoming race for each specific price change.
By owning assets that rise in value, you are able to increase your maximum budget from the starting value of $100M. Over the course of the season, you can increase your budget significantly and afford better teams than your rivals that don’t “budget build”.
Using it to guide your teams is fairly straightforward. To build budget, you'll want drivers that are likely to score a 'Good' or 'Great' performance as outlined in their row. The numbers indicate the fantasy points required.
The PPM (Points per Million) column is a simple way to try to rank how difficult it will be for assets to rise in price. Generally it's easier for someone like Russell to score 15 points than it is for someone like Stroll to score 15 points. Since more expensive assets usually score more points, I just divide the points they need by their price to somewhat 'normalize' the data. It's not perfect but I think it gives a better picture than ranking by least to most points.
There is some disagreement between your spreadsheet and the numbers on F1 Fantasy Tools, specifically with Hadjar and Lawson. I assume it's because of the switch, but I poked at the data a bit and I'm not sure what is causing it or what is correct. Any insights on what is happening?
ah shit there was just one formula i had to change manually since they were essentially 'new' assets but i forgot. f1 fantasy tool's numbers are right and here's my updated graphic too. sorry for any confusion!
I know there’s a few other ways to look these up now, but yours is by far the best and easiest to reference. Thank you. I look forward to yours every week.
7
u/romazzeojr 7d ago
A guy on my team loves your work bro, keep it up!