Hello all, I'm here today to share with you my Low Land Spread Sheet. I developed the sheets as a way to see each CRs stats prior to the developers making stats visible on profiles. How to Use All you have to do is enter the # of Each Low Land buildings for the appropriate CR#. You can get this for your side by scouting all your warriors, or requesting they tell you their LL Build. For opponents use scouts to find opponents builds and input into SS. What SS will tell you(Colored only) Stats My SS will give you the Attack, Defense, Spy Attack, Spy Defense for each CR. ADT My SS will give you the total ADT for each CR. SDT My SS will give you the total SDT for each CR. Builds for each CR My SS will calculate the Spy Percent of the build. Which we know 100% spy is Pure Spy, 80%-99.9% spy is Hansel, 20.1%-79.9% spy is Hybrid, and 0-20% is Attack. The builds will also be Colored to tell you PS=Black, Yellow=Hansel, Blue=Hybrid, and Green=Attack. Strongest & Weakest My SS also colors the weakest to strongest Atk, Def, Spy Atk, and Spy Def. the Greener it is the higher it is out of all of them, and the Reder it is the lowest it is out of all of them. This is relevant to the CR, it will color the players based on Strongest-Weakest on Team. Tankiest & Leakiest Similar to Strong Weak, my SS will color the builds with the most ADT/SDT in Red, and the builds with the least with Green. This is also relevant to CR, it colors the Highest ADT/SDT on team to the Lowest ADT/SDT on team. Directions on how to use. 1. Scout Opponent. 2.Find/Count Low land buildings 3. Enter # of each low land building into the SS for this player. 4. Repeat these 3 steps for every player on roster. Tips Make sure low lands for each=24 Have someone work top down and another work bottom up to fill ss fast. if you come across a lvl1 put .3 lvl 2 put .6 Excel Download https://drive.google.com/file/d/0B7f46CeofqkWUHc1NHloT3NPNzA/view?usp=sharing or http://tinyurl.com/LLSSDownload Google Sheets go to link then choose to make a copy. original version is protected, but your copy you can edit. https://docs.google.com/spreadsheets/d/12Xlfgm7o8huqZK65aV_n9LhyQeHzt028hQDFPftVDdw/edit?usp=sharing or http://tinyurl.com/ChocolateLLSS
Typing in each building 1 by 1 is a lot of effort, just use one where you copy-paste the scout report from PC and it fills the stats... Not hard to make if you have the stats and building names
I suggest changing build type calculations to be based off build mechanics. Hybrid would 26%-74% spies or 25%-75%. I don't know exactly, but that sets the bar for other builds.
There is one posted in forums already. It builds the roster as you copy and paste the scout messages and you can copy and paste the entire message and it will look only at LL buildings. It only works on Windows OS. People need to remember that you need to pay attention to the total number of LL buildings, if it is more than 24 (25 if you include the castle) then the player has LL buildings on HL.
How would I do this on Android Chocolate? I would like to try out but no pc handy. I love this idea very much !!