Ultimate Spreadsheet!

3 posts

Flag Post
This is a little project of mine I've been working on for a while. There are 2 versions to download and 3 major sheets to view. Sheet 1: Attack Calculator ---------------------------------- This sheet allows you to choose a quantity, unit, upgrade lv, range, buffs, and gear for both the attacker and defender. And it will accurately determine the damage range for both normal and critical hits, as well as how many were killed, assuming full life for the top of the stack. This is nice for determining if an attack of defence buff is worth it. In the 2nd version of of the download does some cool stuff (I'll get in to why 2 versions later). In this version the sheet also does a behind the scenes probability distribution for possible damage rolls on each unit, along with the crit rolls. Then it displays the probability that you will kill X amount of units. For example if you might kill 22-26 units on an attack, you will be able to see the chances of you killing 22,23,24,25, or all 26 units. Sheet 2: Farming ---------------------------------- This is an info sheet that goes farther than the wiki pages I've seen. This not only has the current unit/spell purchases available at each location, and each quest along with rewards, but it also has a list of every normal,daily,and wanted battle along with rewards and every enemy unit that has a chance to show up. If you see a battle and the unit you want to kill is not there but is in my list, then just revisit the location or refresh the page until the battle has that unit. Also, there is a searching feature that allows you to choose from a drop down menu of items, units, and magic. Then highlights where they appear. Also, when choosing crafting materials from the items list, it tells you what drops that item. Sheet 3: Equipment ---------------------------------- This sheet is just for use in the calculations that the attack calculator does, but I left it unhidden because it might be nice to choose a unit on the main page, then go here to see what bonuses each piece of equipment give to that unit, for comparison purposes. The download: ---------------------------------- The folder with the versions are on a shared Google drive folder here. https://docs.google.com/folder/d/0B6gFQwBayD6mNEhwSXMycmRtU0E/edit The preview google attempts with google docs is not very good so best to download and use Excel 2010, I have not tested with other versions of Excel. The 1st version without the extra feature on the damage calculator is KBL.xlsx The 2nd version requires you also download the files in the XNumbers Folder. Keep them together but put them anywhere you like. Then download the 2nd version KBL+.xlsx When you get the security warning click enable content. Then you might get a message saying "This workbook contains one or more links that cannot be updated." CHOOSE "Edit Links" Then select the XN.xlam file and click "Change Source..." Browse to the XN.xlam file that you downloaded from the XNumbers folder and click OK. Excel will think for a bit then your ready to use it. WARNING!!! When using the 2nd version don't try to use any large stacks, because the probability distribution takes exponentially longer. While a stack of 100 might take 30 seconds to a minute. A stack of 500 pilgrims was only at 18% calculated after waiting 20 minutes. If you accidentally enter a large stack and it is thinking forever, wait until one of the periods that it does not say (Not Responding) then quickly press ctrl + shift + break. Warning 2 !!! I'm in a hurry and didn't read over this post. This whole thing might sound line complete gibberish and be filled with spelling and grammar errors and I wouldn't know. I'll be happy to answer any questions though.
 
Flag Post

Oh what the hell!!! How come all my spacing went away? No preview? No edit? This forum kinda sucks

 
Flag Post

A better formated version of this exact post is now in a README.txt in the download area

https://docs.google.com/folder/d/0B6gFQwBayD6mNEhwSXMycmRtU0E/edit