|
metadata
**Version 7.1
For Anti-Idle: 1.825**
[Download](https://www45.zippyshare.com/v/wHuOuqV8/file.html)
Hey, I’ve been slowly working on this for the past ~~month~~ ~~year~~ years. It’s a complete remake of my old stats calculator. Now it is actually humane to use.
* * *
**Requirements:**
- Depends on Excel to work.
- Your machine must be able to use ActiveX controls.
- You must accept editing, use of macros and etc.
* * *
**Table of contents:**
[How to use](http://www.kongregate.com/forums/60-anti-idle-the-game/topics/422779-excel-battle-arena-stats-calculator-reborn-now-parses-everything-from-full-character-code-version-1-8#posts-8311327)
[Changelog](http://www.kongregate.com/forums/60-anti-idle-the-game/topics/422779-excel-battle-arena-stats-calculator-reborn-now-parses-everything-from-full-character-code-version-1-8#posts-8311330)
* * *
**Known issues:**
Some secondary sheets like cyborg sheet are outdated.
I noticed the spreadsheet can sometimes show 1 unit more of, for example, mp/hp or their regens. Not sure why, I am positive the formula and the rounding are as in the code.
If you can’t activate the IA, item, etc drop downs, it’s not mine, but Microsoft’s bug.
[Here’s how to fix it.](http://i.imgur.com/ojKTVWL.png)
[If that doesn’t work check the other solutions here.](http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled)
* * *
**Thanks to:**
- memphis404 — fixed ascension xp sheet, help with formulas.
- Uroogla — help with formulas.
- crazye97 — help with formulas.
- sapph — skill code parser example.
- Toa\_of\_Pi — zone statistics sheet format.
- Atalyn27 — zone statistics sheet format.
- bunny75 — help with IA list for the old stats calculator.
- darkmarty — chip hunting guide and feedback, testing, ideas.
- dwakeling — feedback, testing, ideas.
- phantomwolf13 — feedback, testing, ideas.
|
|
|
metadata
**How to use:**
Images presented here can be a bit outdated.
Take the full character code from ingame.

Paste it in ‘Full character code’ sheet (paste as keep text only).

Press the master load button.

This is the color coding in the spreadsheet.

Go to ‘Configuration’ sheet, input general settings at the top.

Scroll down a bit to the IA section, choose the chip amount. For now only end game IAs are in the auto load list. For other IAs you will have to use manual entry.

Go to ‘Results’ sheet. Desired stats can be changed around via input fields around the workbook, mostly in Configuration sheet.
[Image of results](https://www.dropbox.com/s/0lpmzudzxklirgt/Results.png?dl=0)
For future use there are these buttons at the top of ‘Configuration’ sheet. Those will save and load inputs for BA sheets.

Also, starting from version 6.0, you will find fields for the status bar tracker at the top of 'Configuration'. Format them as you wish to avoid sheet switching without the use of watch window. Values are refreshed every second.


This can be disabled with a checkbox below the input table.
**List of sheets:**
- [Configuration](http://i.imgur.com/QN98CsW.png) — this is the place where you change your base stats, skills and so on. Includes a skill code reader/generator.
- [Results](https://www.dropbox.com/s/0lpmzudzxklirgt/Results.png?dl=0) — BA stat results and some other stuff.
- [Full character code](http://i.imgur.com/8cM76R3.png) — my favorite sheet, this will pull out everything from your character stats.
- [ Item speed optimization](http://i.imgur.com/1QN4bAA.png) — you can generate a SP used for DH — DH graph here. You choose the generation range from 0 to 250 item speed%, optimal skill levels for every step are put into a nearby table. The goal is to gain insight into how much SP various amounts of speed rocks on armor save.
- [Zones](http://i.imgur.com/hg3fNM2.png) — spawn, rare, epic and ally rates for zones. Also includes a chip calculator, but just for u1 so far, I'm satisfied with just knowing the required drop rate.
- [Items](http://i.imgur.com/ceg6jMJ.png) — list of all items in game and their rank, unobtainium, locked and grey bonus values.
- [Buffs](http://i.imgur.com/rsXKAd0.png) — list of all consumeable buffs in game and their effects.
- [IAs](http://i.imgur.com/CG1Twiv.png) — supposed to be a list of all IAs, I lost my will after adding endgame IAs (help with parsing from code in this format would be appreciated). This show their bonuses at 0 chips and their ULTRA bonuses.
- [Bonus](http://i.imgur.com/Uo1ON0x.png) — list of all colored bonuses in game and their powers per step.
- [Sets](http://i.imgur.com/K6ZQrnc.png) — list of all sets in game and their effects. Calculates your current set bonuses from the selected items in 'Configuration' sheet.
- [Rings](http://i.imgur.com/isAFqbF.png) — list of all rings in game and their effects.
Starting from version 6.0, this workbook now contains a few of my other spreadhseets, unrelated to BA.
- [Cyborg](http://i.imgur.com/3dsaKoY.png) — this can be used to figure out your progress to 200 after current level xp and EXPILLS. Combine it with phantom's cyborg spreadsheet and you can get a rough time estimate. Also includes performance calculations.
- [Ascension xp](http://i.imgur.com/pxQR81r.png) — shows your progress to a set ascension goal as well as breakdowns of xp types you did and have remaning. By desing this always calculates for 9k1, but I'm aware this could be inaccurate pre-penalty, so in that case just change Q9002 to Q9001 around here. Later on, the inaccuracy becomes infitismally small compared to the totals.
- [Progress bar](http://i.imgur.com/dhVsFKa.png) — figuring out bars per second.
- [Modules](http://i.imgur.com/6kEFFAs.png) — list of all modules, their effects and costs. Maybe will include a toggle for the new 0.9x penalty in the future.
Last, but not least.
- [Credits](http://i.imgur.com/cdfeD67.png) — shoutouts to all those who helped with this project.
|
|
|
metadata
**Changelog:**
- 7.1 — Fixed character code parser to extract skill code correctly.
- 7.0 — Updated for anti-idle 1.825. Fixed a few bugs.
- 6.7 — Updated for anti-idle 1.807.
- 6.6 — Updated for anti-idle 1.802.
- 6.5 — Added an option to calculate GIGA mode CHAOS accuracy and evasion. Corrected collection point cap to 5000.
- 6.4 — Updated for anti-idle 1.799.
- 6.3 — Added lantern set and the ability to disable status bar tracking. Fixed crimson and choco set detection checking wrong fields.
- 6.2 — Added apocalypse (worst moon gem) set.
- 6.1 — Updated for anti-idle 1.792.
- 6.0 — Updated for anti-idle 1.791. Added features: chip calculator, ability to track desired values with the status bar. Merged spreadhsheets: cyborg, ascension, progress bar, module calculators.
- 5.5 — Added choco set.
- 5.4 — Added collection points.
- 5.3 — Mostly updated for anti-idle 1.769. Character code parser now works again.
- 5.2 — Fixed bow slow bonus being always applied, added missing ultimate set 6 piece spawn bonus.
- 5.1 — Updated mana power multiplier, added Festive set, fixed DOOM set not counting items, fixed 20% slow not being added to weapons, whose name starts with the word Bow.
- 5.0 — Updated for anti-idle 1.742. IA status is now parsed from code. Fixed parser reading base stats, IA and weapon HP% incorrectly. Added air bubble buff, missing CP items and attendance medal to item database. Updated Zones sheet.
- 4.41 — Corrected character parser for anti-idle 1.733.
- 4.4 — Corrected hit and dodge chance to cap at 90 before blind. Cursed fields are corrected too.
- 4.3 — Corrected ED monster stat scaling.
- 4.2 — Corrected monster magnet’s spawn rate, ensured 1337.
- 4.11 — Removed hp regen cap indicator.
- 4.1 — Fixed DS and DrS items with floor tags not triggering set bonuses.
- 4.01 — Zones sheet correction.
- 4.0 — Updated for anti-idle 1.722. Attendance medal, possibility for spirit items and their effect on max mana, and 4x drop rate event added. Added fields to calculate CHAOS and Endless dungeon evasion, accuracy. Added a field for base AP / EA ratio. Fixed Crystal armor being unselectable and pre level 100 damage calculations.
- 3.0 — Crit chance rounding corrected, knockback ring text clipping fixed, damage calculations now account for the chance to crit, speed optimizers don’t do errors anymore (was a problem with logic in the DH not rounding pass).
- 2.91 — Forgot to apply version 2.9 changes to some fields.
- 2.9 — User can now choose rage fill up % for speed optimizer and grapher.
- 2.8 — Fixed hp and mp regen roundings. Corrected hp regen for stealth buff.
- 2.7 — Speed calculations corrected further at the cost of script speed, grapher now generates time taken to run.
- 2.6 — Speed calculations made more optimal, speed grapher can now generate user defined ranges, grants more information and detects manual errors.
- 2.51 — Fixed rounding for the Dexterity Enhancement skill.
- 2.5 — Updated the Zones sheet.
- 2.4 — Added an accuracy and evasion calculator, added Triangoop to auto load list, corrected slow debuff.
- 2.3 — Fixed damage estimate calculations and expanded it to include coup de grace and status abilities.
- 2.22 — Cosmetic fix.
- 2.21 — Cosmetic fix.
- 2.2 — Updated for anti-idle 1.688, fixed skill limit parser, added blind debuff effect on your dodge and hit chance, weaken and slow debuffs.
- 2.1 — Speed optimizer simplified for user input. Speed optimizer and grapher made faster, and debugged. Can now see speed grapher progress in excel status bar.
- 2.0 — Can now parse maximum skill levels from a character code and impose limits based on that for skill selections and speed optimizers, item speed grapher. Automate AP|EA button fixed.
- 1.9 — Added a SP Used for Max DH = f (Item Speed) grapher.
- 1.8 — Can now toggle Crit part off. Useful to make the number smaller, if you are ignoring it.
- 1.7 — Only kept Crit\*Mana\*Damage field, so the product fits into cells and I don’t have to scroll right.
- 1.6 — Can now calculate Mana power mult or crit damage \* damage. Both of them at the same time too.
- 1.5 — Can now calculate damage in DP, MBR and SC.
- 1.4 — Added two fields calculating stat sheet damage \* non-boss and boss damage. Grey damage bonuses are accounted for and corrected.
- 1.3 — Can now blind your accuracy and evasion, FGM wand grey bonus added, skill code now correctly generates with null skill values, a few cosmetic changes.
- 1.2 — Effect 5 of a potion now benefits from buff effect.
- 1.1 — Character parser can now accept all system separators.
- 1.0 — Initial release.
|
|
|
metadata
|
|
|
metadata
This is AWESOME! Looking forward to test it :)
|
|
|
metadata
|
|
|
metadata
useless cuz not on google spreadsheets.
|
|
|
metadata
As far as I know, google spreadsheets let multiple people access to the same spreadsheet at the same time. Now use your amazing brain power and figure out, if that would be a good idea for something like this.
Also, I’m using ActiveX controls, which apparently don’t work well with anything other than Windows, so I clearly don’t give two excrements about everyone and their mother being able to use it.
|
|
|
metadata
Bug report, level and other numbers are parsed incorrectly if system uses coma as decimal point. For instance 9,000 is parsed as 9 instead of 9000.
|
|
|
metadata
Looks it’s because the game itself uses , as a thousands separator in the load code, so it changes to a decimal when parsed, if you use , for that.
I’ll try fixing it soon.
|
|
|
metadata
> *Originally posted by **[emperor\_orionii](/forums/60/topics/422779?page=1#posts-8315531):***
>
> Bug report, level and other numbers are parsed incorrectly if system uses coma as decimal point. For instance 9,000 is parsed as 9 instead of 9000.
Sounds like a problem with your system.
No normal person uses a comma as a decimal point, that’s why it’s called a comma and not a decimal point.
|
|
|
metadata
I just removed all the commas in the numbers the character codes gives, so now it works with both separators.
Thanks for the report.
|
|
|
metadata
> *Originally posted by **[ezpzgg](/forums/60/topics/422779?page=1#posts-8315825):***
> > *Originally posted by **[emperor\_orionii](/forums/60/topics/422779?page=1#posts-8315531):***
> >
> > Bug report, level and other numbers are parsed incorrectly if system uses coma as decimal point. For instance 9,000 is parsed as 9 instead of 9000.
>
> Sounds like a problem with your system.
>
> No normal person uses a comma as a decimal point, that’s why it’s called a comma and not a decimal point.
Many people use numbers like 4.765,32
|
|
|
metadata
No normal English-speaking North American, but [many people in the world do](http://en.wikipedia.org/wiki/Decimal_separator).
|
|
|
metadata
it’s good that america has so many inhabitants … not
|
|
|
metadata
Relax every body :). Some people have to realize that there are different cultures outside USA. Before USA products crossed the Atlantic, my country was heavily influenced by Germany so that’s where we got decimal comma from. Oh and I seen some guy in my country have published orthography where thousands and millions are separated with different symbols aaaaand one of those symbols is same as decimal point. Good thing nobody adopted that.
Any way, numbers in question are integers so some kind of replace(“,”; "") should do the trick :).
|
|
|
metadata
|
|
|
metadata
what do you input in Loot Day in General Settings bit of the spreadsheet? whatever I input in, my drop rate ends a ridicolously large number (like 12 million or so) I have Windows 7 Ultimate 64-bit, MS Excel 2007, am I doing something wrong or what?
|
|
|
metadata
Uh it’s a list with 1;1.5;2;3. Where 1 is no loot day. Wow 12 million.. can you upload a whole spreadsheet where that is happening?
Or just a pastebin of your character stats with that happening, I guess.
|
|
|
metadata
> *Originally posted by **[TheJoseph666](/forums/60/topics/422779?page=1#posts-8316848):***
>
> what do you input in Loot Day in General Settings bit of the spreadsheet? whatever I input in, my drop rate ends a ridicolously large number (like 12 million or so) I have Windows 7 Ultimate 64-bit, MS Excel 2007, am I doing something wrong or what?
Just rule out clash with regional settings, what exactly did you input (commas and periods matter)?
|
|
|
metadata
oh, so I have to use commas… whenever I try to put it with periods (like 1.5) it gives me a date instead (in this case May, 1st) I thought you were supposed to input a date of the loot day instead of the value T\_T, thanks guys
|
|
|
metadata
That’s strange. The values in that cell are restricted to only accept this, where the 1.5 can also be 1,5 depending on your settings.

Using a decimal separator for one and a half gives me an error.
|
|
|
metadata
> *Originally posted by **[crazye97](/forums/60/topics/422779?page=1#posts-8316027):***
>
> No normal English-speaking North American, but [many people in the world do](http://en.wikipedia.org/wiki/Decimal_separator).
Well then they should change and conform to proper standards.
|
|
|
metadata
> *Originally posted by **[ezpzgg](/forums/60/topics/422779?page=1#posts-8320688):***
> > *Originally posted by **[crazye97](/forums/60/topics/422779?page=1#posts-8316027):***
> >
> > No normal English-speaking North American, but [many people in the world do](http://en.wikipedia.org/wiki/Decimal_separator).
>
> Well then they should change and conform to proper standards.
“proper standards?”
|
|
|
metadata
> *Originally posted by **[ezpzgg](/forums/60/topics/422779?page=1#posts-8320688):***
> > *Originally posted by **[crazye97](/forums/60/topics/422779?page=1#posts-8316027):***
> >
> > No normal English-speaking North American, but [many people in the world do](http://en.wikipedia.org/wiki/Decimal_separator).
>
> Well then they should change and conform to proper standards.
“Proper standards”? Okay, let’s go back to the old way then, with the weird markings and such. And really, “proper” would be everyone just using a space.
|