The following blog post is both a monstrosity and a possible work of genius–well, if you are mad man that is. Perhaps my madness will benefit other FarmVille players–irrationally addicted ones and casual rationals alike.
First off, I want to begin by saying that I am NOT a mathematician, I am not a statistician, I am not and accountant or a finance planner, or any other profession of number-crunching aficionados. I am an artist and a writer–but I have the luxury of also having been trained in logical processes and coding and have been a life-ling gamer conditioned to find patterns when anything metric-based pops up in a game.
My natural tendencies gravitate towards an intuitive path on “best reward” pretty rapidly. Once I begin becoming aware of it, more than I’m aware of wasting my time playing a redundant game for a few weeks, then something in me brain tips over and I start a spreadsheet. I do this to once and for all find an ultimate answer to all the metrics swarming in my head.
With Farmville, there are loads of things to distract you in your day (when you should be working… or sleeping). Some people like a quick rise to power, level fast and open up new things along the way. Others take it more casually and plant day crops so that the game has limited demands on their real life (I should take a hint). You can chase XP… or you can chase financial profit.
I am not going to get into tree and animal harvesting or gift exchange and the benefits of those as well with this crunchathon. My main focus here was to find an “X-SCORE”: An ultimate rating score for each seed’s “value”. And yes, the “X” is also representative of yours truly: XEI… because, well, because it’s MY darn score system!
Alrighty, lets get into some of the foundations for the ultimate equation I’ll present you with. Lucky for you there’ll also be an image with the results for your referral. If new crops come out though you can continue this work on your own–I’d just appreciate a link back here if you build on this any further. Think of it as a Creative Commons License (By Attribution)!
VARIABLES
Seed Cost = Base Cost of Seed
Harvest Time = Required Hours to Harvest
FarmVille Day = 23 Hours = 1380 Minutes
XP = XP Gained per Seed Planting
Plow Cost = Cost to Ploy Soil = 15 Coins
Plant Cost = Cost of Seed + Plow Cost
Sell Price = Seed’s Gross Price
Profit = Seed Sell Price – Plant Cost
VARIABLES WORTH DISCUSSING
The following stuff is when my brain started going to some pretty complicated places–at least for me initially. Places I was aware of but ignored because I just assumed it all floated in a pretty irregular and unpredictable variable that can’t be given a constant metric to. That variable is called LIFE people. It gets in the way and throws these kind of breakdowns right of. But that’s not saying you can’t create a metric value for each seed.
What needs to happen first is a common unit of measurement needs to be reached. Seeing as a FarmVille “day” actually comes to 23 hours, it’s pretty simple to turn every crops into an “hourly profit” variable:
Profit Per Hour = Profit / FarmVille Day = Profit / 23
Next thing to consider is theoretically how many times the crop can get cycled through the day… “theoretically” is important to state here as this variable will absolutely be impossible to achieve in the game. Each cycle requires time which I’ll detail below, but for now all I want is a non-hindered-by-real-time variable:
Possible Rotations = Harvest Time / FarmVille Day
This brings us to a non-constant variable because it has to do with how large a user’s farm area is. I’ve called each plotting area square a “unit”. I then created a variable to capture roughly the amount of time it takes for the process of each action to take effect in real time. I’ve found that each process takes about 1 second; so a total of 3 seconds per unit is required to complete one cycle. The “rotation buffer” then is a variable that takes into account this lost time and turns it into a minutes variable:
Plot Area = Max Units Farmed
Action Process = Harvest, Plow, Seed = 1 Second per Process = 3
Rotation Buffer = (Action Process x Plot Area) / 60 Minutes
= Approx. 12.5 Minutes for 250 Units
= Approx. 25 Minutes for 500 Units
Now that the handicap time is resolved, I wanted to correct the “theoretical” possible rotation cycle. I’ve subtracted the buffer from the possible rotation cycle in order to output a “more theoretical” daily rotation cycle. Again, these things can always get delayed for whatever other reasons, like FarmVille going out of synch (annoying), or you start harvesting animals or trees between the processes, or you close your browser by accident, etc, etc. BUT this is closer and I wanted to at least capture it, even roughly, just to put my mind at peace. The following then also accounts for the new daily profit and hourly profit:
Buffered Rotation Cycle = Possible Rotations x Rotation Buffer
Remedied Rotation = (FarmVille Day Minutes – Buffered Rotation Cycle) / 60 Minutes
Altered Rotation = Remedied Rotation / Harvest Time
Altered Profit Per Day = Units Farmed x Profit Per Hour x Altered Rotation
Altered Profit Per Hour = Profit Per Day / FarmVille Day
BRINGING THE VARIABLES TOGETHER
This last part is where I attempt to condense the variables down further into a ONE scalable variable that can represent the “ultimate value” to each crop. This is not quite the “X-Score” that I’m aiming for (that will come later), but this is the closest to being the most relevant for a FarmVillian to plan their strategies around. My method involved converting financial profit into an XP value. This uses the foundation that you can buy things and generally speaking you gain 1% of the purchase price as an XP bonus. This is incorrect with items under 500 coins as the lowest XP reward seems to be 5 XP. But in general this is the model for that:
Profit XP = Altered Profit Per Day / 100
XP Profit Total Per Day = (XP x Altered Rotations x Plot Area) + Profit XP
THE X-SCORE: THE ULTIMATE FARMVILLE CROP VALUE CHART
Finally, what I was hoping to achieve with all this madness: Some sort of crop score that accounted for as many variables as possible. This would ultimately place all other aspects of the crop aside–XP gain, harvest time, gross profit–none of it would matter, because here you’d have ONE score that would indicate OVERALL where the crop was placed against all other crops.
The factor that still remains mostly random and erratic is crop mastery. There are three variables left to place not this whole uber-equation:
- How many times you have to harvest a crop to get Mastery of it
- How much XP each Premium Crop outputs
- What the percentage of return is for how many crops become Premium crops
Thankfully the first of the missing variables can be found collected already on many sites and forums. There is a definite number of times each crop requires to be harvested. This alters the long-term value of a crop’s importance.
Additionally, the amount of XP a Premium Crop outputs can also already be found in numerous places online (if you dig them up… ha… pun not intended). It’s also not as easy as assuming longer crops have larger payouts. Thankfully I found a Google spreadsheet that collected all the appropriate variables that include not only the Premium Crop bonus XP, but also the approximate percentage potential.
Speadsheet: http://spreadsheets.google.com/pub?key=t8oPV_Ww0uWQjyBaZxM2kaw&gid=0
So far I’ve returned a result of approximately 40% on Blueberries which is agreeable with the spreadsheet’s breakdown. It is missing Morning Glory, but thankfully this was the second crop I mastered and collected data on my own and so far it’s outputting a whopping 60% Premium Crop wield. On TOP of that, the Morning Glory returned a +6% bonus per Premium Crop harvested. I’m assuming these numbers will be getting updated as new data gets collected, but for now we’ll use the current percentages.
We can add three Basic Variable to the chart:
Crop Mastery Total = Total Required Harvests to Complete
Mastery Bonus XP = Bonus Premium Crop XP
Mastery % Output = Average % to be Premium Crop
With this data we can add another variable to the XP Profit Total per Day that will increase it’s value and give a better representation of the crops overall “X-Score”! Here’s the equation breakdown:
Potential Premium Crops = Plot Area x Mastery % Output
Premium Profit = Potential Premium Crops x Mastery Bonus XP
Premium Profit Per Day = Premium Profit x Altered Rotations
Master Profit Per Day = Premium Profit Per Day + XP Profit Total Per Day
Almost there! Next I had to get a variable out of the length of time it’d take to even get the benefits of the bonus XP from Premium hauls. I resolved figuring out how many days it would take to complete the Mastery cycle:
Days to Master = Crop Mastery Total / (Plot Area x Altered Rotations)
To get the X-Score of the crop I had to create another “benchmark” of time; I decided on 30 days. This gives a range that can be checked against the benefits of focusing on other crops. With that benchmark I was able to get a total profit value by adding the total profits from pre-Mastery and post-Mastery values. The X-Score I decided would be the resulting total. For a smaller number, divide by 100 (really doesn’t matter 
).
Post Mastery = (30 – Days to Master)
First 30 Day Profit = (XP Profit Per Day x Days to Master) + (Master Profit Per Day x Post Mastery)
X-Score = 30 Day Profit / 100
Huff… huff… huff… ok, I hope you all got all that! Enjoy the FINAL RESULTS!
QUICK CONCLUSIONS
For those who don’t care to filter through the Hows and Why and number crunches–that for the most part are just values with no absolute reflection on the reality of playing through it with human tendencies and life distractions, etc. Like it was stated earlier though, that’s not the point: The point is to just get a value that all crops can compare against in order to get an informed and near-omniscient overview (ha… omniscient indeed…) of how to power-play FarmVille.
The results on almost all levels push the berries up to the top tier (except Cranberries). Black Berries seem to be only slightly better than Blueberries, and after 30 days it still won’t make much of a difference. You can sell a Golden Lawn Gnome to pair up the values after 30 days! My suggestion is PICK ONE and forget the other.
If Super Pumpkins ever come back–concentrate on them and ONLY them. This is when I stated playing about a month ago. I flew past all my Neighbours because I gravitated towards the obvious unchallengeable crop and was proven correct with this breakdown.
The only thing that will absolutely destroy Super Pumpkins by more than THREE times after 30 days is the Super Berry. I wasn’t around for this crop so I don’t know much about it–but if it comes back… I better turn into a robot and catch those 2 hour rotation cycles!
Have fun everyone, and remember, seriously: It’s just a game . Get farming!
JUST FOR FUN: Here is the uber-equation
XP = XP
HT = Harvest Time
PA = Plot Area
PR = Crop Profit
CM = Crop Mastery
23 = FarmVille Day
1380 = FarmVille Day Minutes
((((XP+1)*(((1380-((23/HT)*((3*PA)/60)))/60)/HT)*PA)+
((((1380-((23/HT)*((3*PA)/60)))/60)/HT)*PA*CP)/100)*((CM/(PA*P55)))+
((((PA*L55)*(((1380-(I55*((3*PA)/60)))/60)/HT))*
(((1380-(I55*((3*PA)/60)))/60)/HT))+
(((XP+1)*(((1380-((23/HT)*((3*PA)/60)))/60)/HT)*PA)+
((((1380-((23/HT)*((3*PA)/60)))/60)/HT)*PA*CP)/100))*
(30-(CM/(PA*(((1380-((23/HT)*((3*PA)/60)))/60)/HT)))))
DOWNLOAD MASTER CHART PDF
Best Hourly Profit
Best Overall Profit + XP
X-Animals Tshirt Design on Threadless
