How many land cards can I get in allocation and how many resources do I need?
The above question got me making a little tool to try to help figure that out over a few accounts. I figured setting up a spreadsheet with all the calculations would be much quicker than manually doing it for multiple accounts.
The official splinterlands announcement about land cards can be found here
At first, I reached out to @beaker007 to see how much of what I was going to do he already planned to do or had.
His site https://land.spl-stats.com/ is crucial to figuring this out. It has all the useful information we need
If you just want to find out how many cards you can get in the allocation phase, the easiest way to do it is on the player overview page on Beaker's site and scroll down
Here is the spreadsheet I have made to help with this.
There are 2 tabs, one has print run information
The other is where you can input your information to find out your allocations etc.
Below, I will show you how to find all the relevant information. All the grey fields are the ones where you should update information.
Beaker has the total base PP in the regional overview, This goes in cell C2 if it has changed, I will try keep it updated
He also has each player's base PP, which can be found in player efficiency. Type in the account name you want at the top and find the "Base PP" value, this goes in the C column for each account you want to calculate for
If you scroll across to Column Q you should see a section that tells you how many CC of each and how many max copies you might get.
Then, from column AD onwards, it goes into details about how many of each resource you require.
If you want to input how many of each resource you have, to see how you are going, follow the steps.
First, go to player overview on Beakers site.
I have been using rough numbers, so I have been using the total Grain and LP totals. The numbers go in the corresponding columns from D to P. There are spots for Grain, Wood, Stone, Iron and Aura. If you just want to use your liquid resources, then just use the total number.
Once you have entered all the data go to column Y. This will tell you in a % how much of each resource you have to craft your full allocation
I hope this is a useful tool for helping plan out what you are going to do during the allocation phase.
Feel free to drop any questions below or any additions you'd love to see. There are a couple of extra features I was thinking of adding but well see how we go time wise.
So, what is your plan for the allocation phase? Will you get everything you can? I know I sure am planning too!
Great work @keeegs... a lot of afford goes into getting the plan together for the release 😁