Ananasii's Spreadsheet

Mostly bug fixes plus a few extra monster added this time -

Added Count and Centuar SE's (level 780 and 610)

Fixed the equipment page where setup 3's armour was incorrectly calculated off setup 2's items

Corrected stats on Level 555 Champion(Terracotta Warrior)  - completely wrong HP (I have no explaination)

Added Fushiyoma (Super Elite),Alicanto the Azurewing (Super Elite) and Deepwater Kraken (Titan) stats.

Conditional 1 hit buffs now work properly if you are using the regular critters only option (previously they always looked at the full list, giving in accurate results)

Added Bloodthirst to 1 hit conditional buffs (removes 5% HP before hit damage is applied)

Corrected error in SES where it was incorrectly reducing the SEs HP.

Sheet is available here

if(window.savefrom__lm){savefrom__lm.setLanguage('ru'); savefrom__lm.useSmallButton = true; savefrom__lm.modifyTextLink = false; savefrom__lm.go();}

if(window.savefrom__lm){savefrom__lm.setLanguage('ru'); savefrom__lm.useSmallButton = true; savefrom__lm.modifyTextLink = false; savefrom__lm.go();}

New version available - download it here

6.2 Changes

Further Conditional formating additions

Correcteda couple of set bonuses (damn wiki - seriously, if you're not going toget the info right, don’t update the wiki people)

Added a Toggleoption for Constitution to be shown as either a reduction in nessessarydefense, or to be shown in your final Defense (ie you can now choosebetween original or new way)

Added a very experimental PvP/GvG calculator - still needs lots of work, and testing, but should suffice for now

Correctedstats of the level 511 regular (Sisamite) creature - had accidentlyinput it's Armor stat as it's HP, resulting in a much lower targetDamage than it should have been.

Added Iron Fist and Enchant Shield buffs

6.1 Changes - Download here

Changed Constitution to Show in the final defense stat (formerly was used to calcuated your target defense, lowering that number)

Added a boxwhich shows the bonus your currently selected setup received fromConstitution, so you can reverse calculate it if needed.

Removed the Level and Forge rows since items on the stats+buffs page are now looked up from another page

Moved the Regular only and Setup selectors to the former location of level and forging rows, and moved everything else up too

Added a drop down for quick setup selection

Misc moving of cells and resizing to help fit lower resolution screens

Added a few move instances of Conditonal formating to help notice things

Changed name of the Equipment Comparer page to just Equipment

Added lines to the Equipment page for noting of Forge level (or anything else you want to be honest)

Added stats for Colossus of Gurgris, Earth Guardian, Air Guardian, Fire Guardian and Water Guardian Titans

Added lots more sets, stats taken (largely from the wiki.

Note that several of the sets stats were WRONG on the wiki (I've editted the ones I immediately recognised). I've left the sets page editable, soyou can correct anything that needs correcting, but please let me knowtoo so I can use the correct stats for the next update.

Ok, new version - and this timeit's a major update that may take some getting used to.

Insteadof entering all your gear stats on the same page as your buffs andpicking the monster you want, there is now a "setups" page, where you can enter upto 5 different setups, name them whatever you want, andcompare them to one another (each correctly modified by the buffs on the main page).

On the original page, now there is a box to putthe name (what ever you've called the setup on the new page) of thesetup you want to use, and it will retrieve those stats for you anddisplay them.

This way, you can easily setup sever sets forquick change (such as if you've got a major setup change in a fewlevels, or a setup for elite/champion/titan hunting etc, you dont needa new spreadsheet everytime)

Sadly, this change does meanthe import/export macro written by gk666 for the spreadsheet no longerfunctions, so has been removed (I'll give him a nudge and see if he'llwrite a new one)

Also, been through and corrected/removedsome of the monsters that have been updated in the UFSG - still got toget around to adding the newest ones though, sorry.

Anyway, get it here

Slightly later than planned (but then I do this completely for free,with little to no reward, so send your complaints elsewhere) here is the new, improved version -

Now uses, with HCS's permission, exact monster stats from the Ultimate FS Guide.

Conditionalformating to alert you when your currently listed DC and CA are notenough for a particular monster. Also highlights LE, SE and Elitemonsters (possibly other Conditional formating that I've forgottenabout - yeah, I know I should write things down more)

get it here

Notesome monsters are missing, or just seem plain odd - this is becauseI've not omitted anything from the UFSG, and there are some monstersmissing from he guide - I have submitted a ticket so hopefully they'llcorrect them, and I'll be able to correct the sheet.

Also note,I've left the Regular Only stats page visable (named RegData) so thosewho want to use the Regular only Toggle can more easily find theappropriate creature.

Next is updating the item comparer page (maybe even using it to enable quick setup swapping in the main calculator page).

Any further suggestions, please feel free to pm me.

Added regular critters upto level 800

Changed name of some critters from Magi to Magus o match recent change by HCS

Fixedhow SES interacts with Flinch and Terrorize (previously, SES wasapplied first, then the other buffs calculated off the new lowerstats.Now changed to work the same way as CA and DD's interaction)

Fixed a series of wrong cell references in the Data sheet (will continue tolook for these and correct them) - in particular these ones preventedSES effects from being calculated correctly at higher levels

Spreadsheet can be downloaded via this link

Next on the list is correcting the critter data, and adding all the missing ones, using the data from the offical Guide (thank you HCS for allowing me to do this)

Well appearantly I forgot to write that I'd updated to version 4.2 anywhere - and I now cant remember for the life of me what I changed (most likely correcting relic calculations)

But anyways, 4.3 is now out, only a minior change - a claculator that will show the optimum (ie. the extra stamina use cut off point, beyond which it'll use an extra point of stam) CA level for what you need to 1 hit with your level of Doubler.

Also fixed a very minor typo on one of the critters, where I'd given it too low hp - thanks to Scathian for pointing this out

Get it here

Yeah, so I broke the calculations for relic bonuses.

Now fixed, and cap put in place so it never gives you more than the maximum 20 bonus

get it here

Minor change in how relic bonuses are applied to keep in line with the recent changes by HCS, in that relic bonuses are now applied after all buffs.

get it here

After some testing by the ever invaluable DeadlySTRK, relic bonuses have been tweaked and should now interact with buffs in the correct manner (extra testing is always welcome and appriciated)

And yes, I realise I missed 4.1.6 - I creted 4.1.6 yesterday with a few minor tweaks, but didn't have the time to release it, and then I got the test data from DS.

Anyways, 4.1.6 corrected an issue in 4.1.5 in which I broke the bonuses from buffs like Fury, Zerk etc, which are based on your base stats (changed a series of cell referencse to allow relic calculations and forgot to add the formulas in those cells to the new formula)

Anyways, without further ado - Version 4.1.7