Micro-upgrade calculator

[Akame 4,578]

I'll work on an offline version with excel for now while i cant find 15 sensible people for my rankup

[Akame 4,578]

I have found very minor, yes very minor errors on the wiki, on the micro-upgrades section of at least the summations of the m0 and m1 speedups in single type modules with an error of 1 crystals, of course it feels negligible, but i don't think even such an error should have been on the wiki, http://en.tankiwiki.com/Micro-upgrades_of_%22Single%22_Modules , http://prntscr.com/eafdll, does not add up of.

[KILL_BILL_CHAUHAN 2,505]

I have found very minor, yes very minor errors on the wiki, on the micro-upgrades section of at least the summations of the m0 and m1 speedups in single type modules with an error of 1 crystals, of course it feels negligible, but i don't think even such an error should have been on the wiki, http://en.tankiwiki.com/Micro-upgrades_of_%22Single%22_Modules , http://prntscr.com/eafdll, does not add up of.

:D really?

[Akame 4,578]

:D really?

yup, u could see for yourself

[KILL_BILL_CHAUHAN 2,505]

yup, u could see for yourself

no I believe you :)

[Akame 4,578]

 

https://1drv.ms/x/s!Ara6P4_whkZHiCxzEw1h5DvmYNsz

Onedrive link

 

My first MU calculator with limited functionality for now, excel is needed to open the file unfortunately since excel online doesn't support it's features.

Currently can only calculate MU's and SU's for M3 Turrets, M3 Hulls and all modifications of Single, Double and Triple type modules.

 

Answer is given in decimals, forgot to get it rounded, but its good enough to provide a rough estimate.

 

As usual with any file you download there may be a security prompt, not forcing anyone to test it out, but it's there, if anyone does, let me know how it feels so far.

[Enforcer 627]

Great man :)

 

This is useful

[r_GaIaxy2 8,611]

Awesome job. They are well laid out, function beautifully and definitely help us all out :P

If you wanted to, you can set the sheets to view only and get them to copy it to their drive. That way every user has their own personal copy, but it is up to you

 

 

 

 

[Levissio 180]

Also Levissio to solve your problem with sharing the Google Docs just tell everyone to make a new copy for themselves for convenience, and this way we can all use the calculator without conflict.

That was my other option besides creating multiple links. However, ditched the idea because not everyone can (or wants) to download, also users would have to download it again every time I made some changes.

 

My first MU calculator with limited functionality for now, excel is needed to open the file 

Nice to see other examples of this as well  :)

 

Some time ago I actually started to create an Excel version of this, and it's ~90% ready. Only lacks few formulas and "some" visual touch (see the spoiler). Unfortunately I don't see I would finish this any time soon since my studies and other things are taking most of my time now.

 

 

 

 

If you're interested to see the 'filter' tab:

 

 

 

 

 

 

 

Awesome job. They are well laid out, function beautifully and definitely help us all out :P

If you wanted to, you can set the sheets to view only and get them to copy it to their drive. That way every user has their own personal copy, but it is up to you

Thanks :) Though, I think there is no need to set it to view only since everyone with Google account can already download it if they want.

[Levissio 180]

6 Mar 2017 edit:

 

Made some visual changes to the site (using Bootstrap) as well as created something fancy called "Step calculator".

 

Okay, maybe not so fancy but it's similar to 'Calculator 2' in my spreadsheet. Basically it allows you to calculate how many steps you could upgrade your equipment with x amount of crystals.

 

>> MU price calculator <<

 

>> Step calculator <<

 

If you're using the newest version of your browser and you have JavaScript enabled, it should look like the screens below  :) (if not, you're free to use my spreadsheets or the old version of this site which is linked somewhere deep in the spoilers)

 

Screen from MU price calculator:

 

 

 

 

 

Screen from step calculator:

 

 

 

 

 

 

Old message in spoilers below..

 

 

I think now, couple days prior to MU sales, it would be a good time to release web version of this calculator. It's just a test version and not as versatile as my Google sheet versions are.

 

However once again I must say, I am not by any means a professional with this kind of stuff, and worked this as a hobby 'every now and then'. That being said, in your browser it might not visually look the way I want it to look like (see the spoiler), though should function properly no matter the browser as long as JavaScript enabled. 

 

 

 

Note: step table and "INFO" can't be opened if JavaScript isn't enabled, but the calculator itself works.

 

 

 

 

 

So, please try it out and comment it if you wish.  :)

 

> MU Calculator <

 

 

 

Edited March 6, 2017 by Levissio

[AbsoluteZero 3,729]

I've made a working copy of this in AutoHotKey because I have too much spare time. B)

Not tested it fully yet but I think it works okay.

 

It grabs all of it's information from wiki then stores the tables locally. Includes an option to check for updates or use local tables. As long as the formatting style is preserved on the wiki pages, adding a new turret, hull to them or even a quad module, should be detected without the need to alter the script.

 

I'm not a programmer or anything and I bet there are more efficient ways to do what I've done.

There is still a little tweaking to do on the script but if anyone is interested, I'll make the text file available once I'm happy with it in a wee while.

[Levissio 180]

because I have too much spare time. 

:D

 

I love to see that others are creating these kind of things as well. It also gives users the option to use multiple sources to make sure results are alike. Have you tested at all do you get same results when using my sheets (or the site)?

 

One of the problems in my calculators are the part where I have to manually check and update the tables. Gladly prices are not changed so often though.

[AbsoluteZero 3,729]

One of the problems in my calculators are the part where I have to manually check and update the tables. Gladly prices are not changed so often though.

I have checked it with your spreadsheets and the results are nearly always the same but sometimes out here and there by a crystal or two due to rounding. I haven't checked how you did it but I applied the sales percentages on mu's or speedups at the end of each step. I also haven't yet checked to see if ahk rounds up or down at those points.

 

I haven't manually checked anything but one or two snags did crop up because of slight inconsistencies in the translation from RU to EN but @Galaxy promptly sorted those for me in a flash.

 

The general method I chose was to download the html from each url and because everything is so uniformly consistent on each page, I could just use a subroutine to sequentially read, match and extract the information needed (used regexmatch) to make simple text based tables which I then stored as .ini files in a local folder. There is a checkbox option to check the modified date of each item's page before doing any calculation and if the date on the page differs from the one stored locally, it will refresh the local table. Doing that adds a couple of seconds to each new item change so unchecking it makes the process a whole lot faster and the result is spat out as soon as the calculate button is pressed.

 

One of the parts that was a bit tricky was the steps 0-50 which is actually 51 steps. So if a player selects steps 1 to 10, he's actually already bought the first step 0 and in theory we only go to step 49 when adding the numbers. ie, going from 49-50 should just add 49's numbers. I was tempted to discard the zero but I kept it.

 

A large percentage of the script was dedicated to displaying and controlling the gui, graphical user interface - changing what steps are available in a drop down box for instance or disabling/enabling controls to minimise the chance of errors resulting from user input.

 

I'll tweak it further this week if I'm not too tired after work and hopefully have a text file available next weekend.

[fluctuation123 3,435]

^ interesting! you did the coding in which language? i am thinking about python...

 

also on a similar note, i tried to calculate the same. so i looked at those datasets for

some time, and found that they increase almost uniformly, except some minor differences.

and so you can sum them up using as a arithmetic progression series. i did that,

and found the crystal values within few percent error. this was fun :)

 

@ levissio: thank you! i shifted from the above described method to google sheet one

few weeks back. but now this is super-easy! kudos!

Edited March 6, 2017 by fluctuation123

[AbsoluteZero 3,729]

^ interesting! you did the coding in which language? i am thinking about python...

Hi - thanks, I'm not sure what language this is. I played around with autohotkey a year or two ago to help me with a shortcut and progressed from there. I read the online manual when I get stuck, which is like most of the time. I don't pretend to know the half of it as I can only grasp the fundamentals but I do know enough to carry out basic tasks. I write it all in notepad. As for other languages, I know nada I'm afraid.

[fluctuation123 3,435]

oh, didn't know about this one. seems nice. i know c++ and python, but not this one.

 

here is python. it is very widely used nowadays. https://en.wikipedia.org/wiki/Python_(programming_language)

[AbsoluteZero 3,729]

I've not had much time to tweak it or test it fully but I think it works okay.
 
Here is a download link 3rdApril2017 to ahk script in text form.
Please don't criticise my ahk skills. I have to read the manual to do these things :lol:
Hope someone can make use of it or make it even better.
 

Edited May 30, 2017 by AbsoluteZero

[Akame 4,578]

I've not had much time to tweak it or test it fully but I think it works okay.

 

Here is a download link to ahk script in text form.

Please don't criticise my ahk skills. I have to read the manual to do these things :lol:

Hope someone can make use of it or make it even better.

 

looks sweet :), i wonder if the balance would go negative :o, and omg that excluding last speedup a great feature too!

Edited March 11, 2017 by Akame

[AbsoluteZero 3,729]

i wonder if the balance would go negative :o

Yep, it can. The negative balance is the number of crystals you would need to make up in order to realise the selection.

Edited March 11, 2017 by AbsoluteZero

[bc200214_777 582]

Just wondering, will you be able to incorporate the recent patch updates (m0 and m1 MU's = 10 steps instead of 50) into the MU calculator soon? :P I hope I don't sound greedy and it's as if I'm demanding you to make an updated calculator :D

[Levissio 180]

Just wondering, will you be able to incorporate the recent patch updates (m0 and m1 MU's = 10 steps instead of 50) into the MU calculator soon? :P I hope I don't sound greedy and it's as if I'm demanding you to make an updated calculator :D

Yea, I'll try to update them asap, probably within this week :)

[Heles 9,220]

:o Good Job 

[Fragrance 1,294]

Nice, next time I should consult with you before upgrading or buying something :p

[Maf 32,300]

Pinned for April Fools day discounts

[5HADOW 249]

How much would it cost to Micro-upgrade Thunder M2 from 0/10 to 10/10 with 25% off upgrades and speed-ups?