Agricola Efficiency Spreadsheet
Posted: 23 October 2021, 08:51
I have made an Agricola Efficiency Spreadsheet that you can find here: https://docs.google.com/spreadsheets/d/ ... 5-R6B9IuA/
How it works is that every resource is given a food cost. For example, I have wood valued at 1.5 food. All of these parameters can be changed and the spreadsheet will automatically update. The idea is to approximate the efficiency of various actions and cards within the game according to how valuable the resources are. Some game's resources are worth less because people are injecting resources by their occupations, therefore it's easier to acquire these resources.
In order to handle value which is gained over time (tempo), there is an Interest parameter. I have set this as 10% on my spreadsheet, but you can set it to whatever you want. In a real game scenario, this is changing constantly. For example, when rooms are being built, wood and reed now are much better than wood and reed next round. The interest would be much higher than 10% in this scenario. Cards which gain value over a long period of time are more affected by this interest parameter. For example, Woodcutter can take over 10 rounds to gain all of its value, so a small change in the interest parameter will affect this card more than cards that gain their value over a short period of time.
All of these values are just approximations in various contexts and are not trying to say how good a certain card or action is in a vacuum. Some cards that are actually good appear weaker, and vice-versa. The spreadsheet simply functions as an analytical tool that you can customize and play around with by changing the parameters and creating different scenarios. While it is an approximation and some cards are not completely accurate, it does do a good job of getting a rough idea of how good some cards are in certain contexts compared to others.
If you want to change the values and play with the spreadsheet yourself, make a copy by going to File --> Make a copy.
I hope some of you find it interesting or helpful. Thanks for reading!
How it works is that every resource is given a food cost. For example, I have wood valued at 1.5 food. All of these parameters can be changed and the spreadsheet will automatically update. The idea is to approximate the efficiency of various actions and cards within the game according to how valuable the resources are. Some game's resources are worth less because people are injecting resources by their occupations, therefore it's easier to acquire these resources.
In order to handle value which is gained over time (tempo), there is an Interest parameter. I have set this as 10% on my spreadsheet, but you can set it to whatever you want. In a real game scenario, this is changing constantly. For example, when rooms are being built, wood and reed now are much better than wood and reed next round. The interest would be much higher than 10% in this scenario. Cards which gain value over a long period of time are more affected by this interest parameter. For example, Woodcutter can take over 10 rounds to gain all of its value, so a small change in the interest parameter will affect this card more than cards that gain their value over a short period of time.
All of these values are just approximations in various contexts and are not trying to say how good a certain card or action is in a vacuum. Some cards that are actually good appear weaker, and vice-versa. The spreadsheet simply functions as an analytical tool that you can customize and play around with by changing the parameters and creating different scenarios. While it is an approximation and some cards are not completely accurate, it does do a good job of getting a rough idea of how good some cards are in certain contexts compared to others.
If you want to change the values and play with the spreadsheet yourself, make a copy by going to File --> Make a copy.
I hope some of you find it interesting or helpful. Thanks for reading!