FS22 Crop Yield & Profit Calculator

A simple and lightweight crop yield and profit calculator.

Introduction

---

A simple and lightweight Crop Yield and Profit Calculator[docs.google.com].

Too many people messed around with my sheet and made it unusable for others.
To use the calculator now, you need to make a copy for yourself (logging in is required for this)

How to make a copy
• Open the Calculator[docs.google.com]
  
• Click on FIle in the top left
  
• Click on Make a copy
  
• Click Ok at the bottom right. Changing the name etc. is up to you.
  
  
• Alternative you can click here[docs.google.com] and click on Make a copy.

---

Translations
In the Main sheet, at the bottom right, you can choose your preferred language, via a dropdown list.

Available Languages:

• English
  
• German
  
• French

Crop Yield & Sales

Map and Crop Type

First you need to choose the Map you are playing on or select Custom to enter a own Field Size in Ha.
If you select a Map you need to enter the Field Number for the correct calculation.
Alternative you can select Custom and type your field size* in.
(Remember to use the correct decimal seperator, depends on your language setting.
Default is . for thousand seperator and , for decimal seperator)
Now you need to choose which crop you want to harvest under Crop Type

* A field size list from all 3 default maps are in the second sheet (FieldSizeList)
Those field sizes are taken from the giants editor and are rounded.
The more accurate your field size is, the better are the calculations.
Inaccurate decimal numbers can lead to a yield miscalculation
Example on the map Haut-Beyleron, Field 38.
From the Giants Editor its 1.15 Ha - Total Yield of 20,470.00 L Wheat.
Ingame size is 1.15 Ha - Total Yield of 20,470.00 L Wheat
Measured size is 1.1328 Ha - Total Yield of 20,163.84 L Wheat
Real Size is 1.143475 Ha - Total Yield of 20,353.86 L Wheat
(The real size can be seen in the savegame after sowing a field)

---

Field Work

Here you can select which work you will need to do on your field.
Remember, you dont need to plow or lime every harvest.
On the right side you can see how much impact each step has on your Total Profit.

---

Total Yield and Total Sales

After setting all up, you can now see how much your harvest will Yield

Now change under Difficulty your Economic Difficulty for the correct price table.

Default Difficulties are
• New Farmer = Easy
  
• Farm Manager = Normal
  
• Starting from Scratch = Hard

Under Sell Price you can now choose,
what you would get if you sell it for the selected price.

• Avg. (average) price, defined by the game.
  
• 130% of the average price (good selling value)
  
• 150% of the average price (seems to be the maximum increase)

Right of it you see the Price per 1000 Liter and the Total Sales if you would sell it all to the designated price.

At the bottom of Seed and Spray costs you can see if you still make profit or not.

---

Suggested Work Order

On the right side of the Main Tab you can see a Suggested Work Order to get the full bonus of 200% yield.

Costs and Profit

Here you can see your costs and the total profit.

---

Used

Now you need to check if you used new Lime, did the first fertilizing stage with Oilseed Radish or used Herbicide instead of a Mechanical Weeder for your field.

---

Reused

If you sow Potatoes / Sugercane you can use stored Potatoes / Sugarcane from a another harvest and dont need to spend money on new Seeds.
The table will show the value of the stored Potatoes / Sugarcane if you would sell them for 130% instead.
You should check that before reusing Potatoes / Sugarcane.
Its not worth on all Difficulties.

---

Usage and Costs

Here you can see how much Seeds, Lime, Fertilizer and Herbicide you'll need and how much it costs you.
If you fertilize you need to choose which type of fertilizer you used.
(Solid, Liquid, Slurry, Manure or Digestate)
For Slurry and Manure you'll see, like for Potatoes and Sugarcane, how much money you could make if you would sell it for 130% instead.
For max profit, even on Hard difficulty you can just sell Slurry and Manure for the average price and buy solid or liquid fertilizer from the money.
Digestate cant be sold and is a by-product from using the Biogas plant.

---

Total Costs and Profit

At the bottom you can see you total costs for your field and the total profit.

Changelog and Credits

Remember, as we learn more about this game, this guide get updates and some things will change.

---

Changelog

• 04. Jan. 2022 - v1.61
  
  • added - french translation. (thanks to M4rkham)
  
  
• 01. Jan. 2022 - v1.6
  
  • changed - all field sizes to more accurate values. (thanks to LuckyUnlucky for his work)
  
  
• 27. Dec. 2021 - v1.5
  
  • added - map and field selection for calculation. (thanks to BizzWare for the help)
  
  
• 26. Dec. 2021 - v1.4
  
  • added - calculation and checkbox for the use of oilseed radish (thanks to The Pecker for the suggestion)
  
  
• 21. Dec. 2021 - v1.3
  
  • added - german translation
    
  • added - new sheet with all field sizes for each default map. (Elmcreek, Beyleron and Erlengrat)
  
  
• 14. Dec. 2021 - v1.21
  
  • changed - position with Used and Reused swapped
    
  • changed - Herbicide checkbox into Used and added Lime
  
  
• 12. Dec. 2021 - v1.2
  
  • added - price per liter in Crop Yield and Sales window
    
  • changed - Crop Yield and Sales layout
    
  • changed - Suggested Work Order - First fertilization now before seeding
    
  • changed - changed Seed and Spray costs to Costs and Profit
  
  
• 11. Dec. 2021 - v1.1
  
  • added - costs and profit calculation
    
  • added - changeable sell price
  
  
• 10. Dec. 2021 - v1.0
  
  • added - Crop Yield and Sales calculation
    
  • added - Suggested Work Order
    
  • initial release

---

Credits

• Giants Software[www.giants-software.com] - for making the game.
  
• Farming Simulator Academy[www.farming-simulator.com] - for providing better informations about the game.
  
• TheOldSul - for making yield tests and share those informations on reddit.

This Guide is not only build up on informations from the Internet.
I tested nearly all equipment myself in perfect circumstances.
Heres my Crop Yield Test[docs.google.com] sheet.
Its still in testing and from day to day we learn more about the game mechanics.

[Teax]

No plans right now. FS22 seems for me superior to FS25 right now.

[vanbushi]

Any plans to update for FS25?

[Crawford]

Thank You!

[Teax]

Thank you for the kind words :) As long as you have fun at something, time is relative :)
Have a nice day :)

[Green]

it took me a bit of figuring it out but this works really good! thank you so much for making this, i cant even think about how long this took to make!

[Teax]

yes, feel free to adapt the sheet for other maps and edit it for you own use :)

[ALLHISGLORY1]

can i edit your sheet for a specific map? i want to help people who play the map. if so can i share it with the map creator and give you credit?

[Teax]

i could but that would take too long unfortunately. But google was my friend and always open while creating this spreadsheet. Its not so difficult.

[ALLHISGLORY1]

could you teach me how to make a spreadsheet like this?

[Teax]

You need to copy the link into your browser. Valve doesnt like Google and blocks all docs.google links. Nothing i can do and steam support gives a shit. Sorry for the circumstances