Updated ISO calculator

Options
CprlHicks
CprlHicks Posts: 5
edited December 2016 in MPQ Tips and Guides
Hey gang, after much searching I couldn't find an updated ISO calculator based on the new (lower) ISO costs for 3 and 4 star characters. So I updated the old calculator by Shaiko.

It's available at the link below as "view only". To edit the values you should be able to "make a copy" (under the file menu) to your own google drive, or "download" to excel or something if you don't have a google account.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

I've tested it for accuracy with a few of my 3 and 4 star characters and it seems to be working, but I'd love to hear if anything is off or doesn't seem to be working, I'm an English major after all.

If all seems to be good, I'd love to get this added to some of the stickied faq's and guides -- the ones I tried all seemed to be out of date. Or if I missed one that's working I'd love to hear about that too. Enjoy and happy ISO hunting! iso8.png

edit: New link, added 5* -- The 5* costs are close but not 100% accurate, which I think may be due to the tables on the wiki being inaccurate. If anyone knowns where I can find accurate tables/costs would be much appreciated.

Comments

  • mckauhu
    mckauhu Posts: 740 Critical Contributor
    Options
    It's working nicely thanks!
  • Chipster22
    Chipster22 Posts: 297 Mover and Shaker
    Options
    I think this link may have the most accurate tables:

    https://docs.google.com/spreadsheets/d/19WTGnjZWctTwzHeF44XAR7ULkfKcHQOfufmG4z_OHR8/edit#gid=1324351701
  • tobismaul
    tobismaul Posts: 11 Just Dropped In
    Options
    Chipster22 wrote:
    I think this link may have the most accurate tables:

    https://docs.google.com/spreadsheets/d/19WTGnjZWctTwzHeF44XAR7ULkfKcHQOfufmG4z_OHR8/edit#gid=1324351701

    With the new changes to the level up button I've been working on an ISO calculator for my alliance. The ones that are currently available seem to be slightly off with the 4* data.

    The above table has the 4* requirement from 70 at 365,896. In game the requirement from 70 is 365,821. Small discrepcy of 75 iso, and not a deal breaker but is bugging me for some reason.

    I just maxed out a 4* so my iso reserves are a little low. I wish I had waited and could have manually verified the data on my own.

    Just thought I would reach out and see if anyone knows where the discrepancy is?
  • bob554
    bob554 Posts: 169 Tile Toppler
    Options
    this. This is my new favourite thing (especially with the changes to the level up button!)
  • Vhailorx
    Vhailorx Posts: 6,085 Chairperson of the Boards
    Options
    Sticky please!
  • Chipster22
    Chipster22 Posts: 297 Mover and Shaker
    Options
    The 2* data seemed to be a little off as well, so I tracked the actual amounts a couple months ago. Below is what I came up with.
    15 0 0
    16 62 62
    17 155 217
    18 156 373
    19 162 535
    20 183 718
    21 200 918
    22 212 1,130
    23 248 1,378
    24 260 1,638
    25 277 1,915
    26 303 2,218
    27 317 2,535
    28 343 2,878
    29 360 3,238
    30 372 3,610
    31 408 4,018
    32 420 4,438
    33 437 4,875
    34 464 5,339
    35 476 5,815
    36 502 6,317
    37 521 6,838
    38 532 7,370
    39 568 7,938
    40 580 8,518
    41 597 9,115
    42 624 9,739
    43 636 10,375
    44 662 11,037
    45 681 11,718
    46 692 12,410
    47 728 13,138
    48 740 13,878
    49 757 14,635
    50 784 15,419
    51 796 16,215
    52 822 17,037
    53 841 17,878
    54 852 18,730
    55 888 19,618
    56 900 20,518
    57 917 21,435
    58 944 22,379
    59 956 23,335
    60 982 24,317
    61 1001 25,318
    62 1012 26,330
    63 1048 27,378
    64 1060 28,438
    65 1077 29,515
    66 1103 30,618
    67 1117 31,735
    68 1143 32,878
    69 1160 34,038
    70 1172 35,210
    71 1208 36,418
    72 1220 37,638
    73 1237 38,875
    74 1263 40,138
    75 1277 41,415
    76 1303 42,718
    77 1320 44,038
    78 1332 45,370
    79 1368 46,738
    80 1380 48,118
    81 1397 49,515
    82 1423 50,938
    83 1437 52,375
    84 1463 53,838
    85 1480 55,318
    86 1492 56,810
    87 1528 58,338
    88 1540 59,878
    89 1557 61,435
    90 1583 63,018
    91 1597 64,615
    92 1623 66,238
    93 1640 67,878
    94 1652 69,530

Categories