Hear, hear, good Battle Mages: Ships from all around Splinterlands are setting sail for Praetoria, to find fame and fortune on its mysterious shores. The Deeds have been sold and surveyed and summoners and monsters are ready to be sent to the Shard Mines, Grain Farms and Research Studies. But what to build where and when with what is the million Dark Energy Crystal question. If there would only be a magical Landsheet to help with your preparations...
Will you be tougher than the toughies and smarter than the smarties - and will you make it square?
I have been working long and hard on pulling together all the magic available to me and with the help of smart goblins, kobolds, dwarves and even some dragons, I have completed the impossible task:
https://docs.google.com/spreadsheets/d/1KV1XqOXWU5s1lWx0jfeGcYfRBEJdLsptTHs2uBiM6iI/edit?usp=sharing
The Ultimate Landsheet
Please enjoy my tool for land, to join the goldrush at the Yukon fields of Praetoria. Enter your cards in the Cards sheets, enter your plots in the Plots sheets and then place your workers in the Worker slots.
You have many dropdowns to select your worksite, plot rarity, terrain type, territory, card splinter, card rarity, card foil and card set.
You can also add your other land assets, like Runis, Totems and Titles.
All the relevant calculations will then be made for you, including:
- BasePP
- FullPP
- Clearing Cost in PP
- Clearing Days
- Time Crystals required to clear plot
- Net Grain production per hour
- Food production per hour
- Research points per hour
- SPS PP
- Fragments % per hour
- Fragments % per day
- Statistics for your total SPS PP
- Statistics for your total Fragment Chance per hour in average
- Statistics for total Grain per hour/day/week/month
- Statistics for total Secret points per hour/day/week/month
- Statistic for your 10k Castle tax (how much does your Castle get from a 10k claim)
- Statistic for your 10k Keep tax (how much does your Keep/Castle get from a 10k claim)
Additionally, I added my entire calculations from my Alpha Production Points and Beta Production Points posts, showing you all total cards that exist in circulation for these two sets, including how many max can ever exist and fill X amount of plots on land and produce Y amount of basePP.
Instructions
There is still quite a few manual entries and adjustments you need to do. You will actually see my own latest settings with my plots and my monsters, to have a sample view.
- Please create a copy of the landsheet
- Familiarize yourself with how the landsheet looks like fully filled to get an idea of what you are actually seeing there. Check out the bottom, where you can switch between four sheets: Plots, Cards, Statistics and Total Cards.
- Delete 99% of the monsters and plots, keep only 1-X rows as a reference and for the dropdowns.
- Add your plots to the plot sheet and cards/monsters to the card sheet (the card sheet is actually optional but I highly suggest using it for better overview). No need to fill out all columns, some are redundant and only for your own entertainment, like Card ID, for example. Pro Tip: Download a CSV file of your cards and plots from Peakmonsters. Copy/paste what you need from there into the landsheet.
- Make use of all the dropdowns in the landsheet. It is easy and fast and nice to look at. Copy/past works for that as well.
- Add your monsters to the Worker 1-5 columns. This is a bit tricks but not much, plus I added a nice note to the top row, which tells you exactly how to do it: You can either just enter the raw PP directly OR link to the actual PP cell, which I highly suggest.
- Select your worker terrain bonus in the W1%-W5% columns. You have the options between 10%, 5%, 0, -5% and -50%. Keep in mind: Terrain bonus is added to basePP and can push you ABOVE the max 100,000 basePP.
Disclaimer
Non of the information in the landsheet is with any guarantee. Please doublecheck the 1.5 Whitepaper for all formulas and calculations.
Feel free to report any errors or suggestions to me on Discord or HIVE. I will try to update the landsheet then.
P.S.
You MUST be logged into a Google account, to get access to all features like dropdowns. It does not show them when you are not. You will miss out in that case.
Edits
- Added Legendary Runi option
- Fixed production boost for Legendary/Epic Occupied/Magic
- Completley revamped the worker terrain bonus and added extra columns with dropdowns
- Updated the "Food /hr" costs (it included the terrain bonus before but that was incorrect
- Updated the "Net Grain /hr) costs (it substracted the food costs before taxes but it is taxes first and then the food costs)
This will help a lot of people with the land and what plans they should make, this is great work :D
Great job - it was great!!!
Realistically, there aren't too many posts out there that truly deserve a 100% upvote. This one actually deserves 5 of them. Great work!
I haven't used it yet but I will be all over it this weekend getting ready for Tuesday. Cheers!
I appreciate that! It was a LOT of work.
Thanks Flauwy. I was just about to wipe my spreadsheet and start again which has a few things missing so I'll give yours a try. Hopefully I'll be able to work it out. 😂
Let me know, if you have any question. You know where to find me. :)
Thank you. I appreciate it.
Are the instructions still the same given you have updated it this afternoon?
Except for point 7. I have deleted the old point 7 in the post and replaced it. What you see no is reflecting the latest changes. The notes inside the Landsheet are also updated. If you already created a copy, go back and check it out.
It is an ongoing process. There might be many changes to this document over time. I will try to keep this post updated or eventually create a new one.
OK. Thanks. Do I need to download a fresh copy or does it automatically update when you update yours?
It is sadly not automatically updating, when you already created a copy or downloaded it. However, it should be easy to update with any changes you already made. I have only changed unlocked columns and created automated pop-up warnings everywhere, where you shouldn't make changes.
Just been playing around with it - deleting caused it to not work, but I'm just overwriting now which is fine.
Helps clarify what my intuition told me - probably NOT worth using TCs to build immediately on Occupied plots to get that 100% SPS bonus, at least NOT compared to say legendary and epics - gonna build slow and pay in grain on those occupieds.
Worth using TCs on all the naturals and at least some of the magics me thinks!
Very useful tool, helps clarify things a lot!!!
Nice job!
Selecting one or several rows, right-clicking and delete row(s) should work without breaking anything. Also moving rows up and downs also works.
Cheers:
Gonna need a lot of grain is what I have learned so far!!!
Thanks a ton! Since I'm way overdue to take a proper look at how things will work, this surely will come in handy!
Very cool! Great work homie!
Thanks for sharing! - @azircon
DOPE! Thanks for the sheet
!PGM
!PIZZA
BUY AND STAKE THE PGM TO SEND A LOT OF TOKENS!
The tokens that the command sends are: 0.1 PGM-0.1 LVL-0.1 THGAMING-0.05 DEC-15 SBT-1 STARBITS-[0.00000001 BTC (SWAP.BTC) only if you have 2500 PGM in stake or more ]
5000 PGM IN STAKE = 2x rewards!
Discord
Support the curation account @ pgm-curator with a delegation 10 HP - 50 HP - 100 HP - 500 HP - 1000 HP
Get potential votes from @ pgm-curator by paying in PGM, here is a guide
I'm a bot, if you want a hand ask @ zottone444
$PIZZA slices delivered:
bitcoinflood tipped flauwy
underlock tipped flauwy
(3/20) @curation-cartel tipped @flauwy
!1UP Good work!
!PGM !PIZZA
BUY AND STAKE THE PGM TO SEND A LOT OF TOKENS!
The tokens that the command sends are: 0.1 PGM-0.1 LVL-0.1 THGAMING-0.05 DEC-15 SBT-1 STARBITS-[0.00000001 BTC (SWAP.BTC) only if you have 2500 PGM in stake or more ]
5000 PGM IN STAKE = 2x rewards!
Discord
Support the curation account @ pgm-curator with a delegation 10 HP - 50 HP - 100 HP - 500 HP - 1000 HP
Get potential votes from @ pgm-curator by paying in PGM, here is a guide
I'm a bot, if you want a hand ask @ zottone444
You have received a 1UP from @underlock!
@monster-curator, @oneup-curator, @leo-curator, @bee-curator, @pimp-curator, @thg-curator, @vyb-curator, @pob-curator, @neoxag-curator
And they will bring !PIZZA 🍕. The @oneup-cartel will soon upvote you with:
Learn more about our delegation service to earn daily rewards. Join the Cartel on Discord.
$WINE
@tipu curate
Upvoted 👌 (Mana: 57/67) Liquid rewards.
LOVE IT!
BEER
Awesome mate! I have one but it's not as good as yours 😀
Impressive, thank you for sharing this!
wow, amazing work, seems to be priceless
I entered all the data but it doesn’t count - maybe I should do something else? Maybe there is a video instruction?
!ALIVE | !BBH | !PGM
BUY AND STAKE THE PGM TO SEND A LOT OF TOKENS!
The tokens that the command sends are: 0.1 PGM-0.1 LVL-0.1 THGAMING-0.05 DEC-15 SBT-1 STARBITS-[0.00000001 BTC (SWAP.BTC) only if you have 2500 PGM in stake or more ]
5000 PGM IN STAKE = 2x rewards!
Discord
Support the curation account @ pgm-curator with a delegation 10 HP - 50 HP - 100 HP - 500 HP - 1000 HP
Get potential votes from @ pgm-curator by paying in PGM, here is a guide
I'm a bot, if you want a hand ask @ zottone444
Your Content Is Awesome so I just sent 1 $BBH(1/20)@flauwy! (Bitcoin Backed Hive) to your account on behalf of @vocup.
You Are Alive so I just staked 0.1 $ALIVE to your account on behalf of @ vocup. (1/20)@flauwy!
The tip has been paid for by the We Are Alive Tribe
through the earnings on @alive.chat, feel free to swing by our daily chat any time you want, plus you can win Hive Power (2x 50 HP) and Alive Power (2x 500 AP) delegations (4 weeks), and Ecency Points (4x 50 EP), in our chat every day.