|
|
Post by 'AhSaN' on Apr 15, 2018 16:56:05 GMT
How this calculator works?i tried both links but i can not change anything let alone calculate You need to first download that ".xls" file. Then use a Office program to open up. For windows, I use Microsoft Excel. For Android, You can use Polaris office or OfficeSuite to open this program if you don't have any app to open it. By the way, you can't modify something straight from the Drive. (Or can you?). You need to download that first. |
|
|
|
Post by jala on Apr 18, 2018 14:01:25 GMT
How this calculator works?i tried both links but i can not change anything let alone calculate You need to first download that ".xls" file. Then use a Office program to open up. For windows, I use Microsoft Excel. For Android, You can use Polaris office or OfficeSuite to open this program if you don't have any app to open it. By the way, you can't modify something straight from the Drive. (Or can you?). You need to download that first. Thanks a lot.Actually i had opened it with Polaris office and couldnt use this calculator i will try in comp.Since u could open it it should work for me too.thanks again  |
|
|
|
Post by arvatra on Nov 27, 2018 9:56:08 GMT
Please update the exp chart. Ty
|
|
|
|
Post by sumails on Dec 16, 2019 18:53:05 GMT
are there gonna be updates for lv 370-400 or something
|
|
Niu
Member
last played in 2020
|
Post by Niu on Jan 7, 2020 12:36:22 GMT
For future reference: total available EXP from MQ is 24 512 765 230. On a new character with low or no boost this gets you to Lv315 according to the calculator.
Here's a chart of mission names and EXP amounts starting from where the calculator cuts off at the beginning of ep5. |
|
Niu
Member
last played in 2020
|
Post by Niu on Jan 28, 2020 22:24:59 GMT
So I found out there's a "new" exp chart added in 2018 to jp wiki. I can't say if this is more accurate up to 200 than the old YWboy chart, some values look... odd. However, it has numbers up to Lv415.
It's interesting so I want to copy it here too. Because the exp values in source are for gaining the corresponding level, I edited it to match our old chart, the exp value is for gaining the next level. Chart image below
|
|
Niu
Member
last played in 2020
|
Post by Niu on Jan 29, 2020 0:33:46 GMT
I have updated the calculator with new MQ!! (as Dark§tØrm said ITT that others can continue updating it)
All calculations should work as usual, but I broke the exp bar because my formatting is barely passable, I'm sorry <-< I might try to update the levels too up to 4?? if anyone wants but I can't promise it's going to be accurate.
edit: this link is outdated look at latest post
|
|
x2nd
Member
Discord killer#0507. https://m.youtube.com/channel/UC4F8nJipoD9O5S7otkANkug/feed
|
Post by x2nd on Jan 29, 2020 1:39:25 GMT
I have updated the calculator with new MQ!! (as Dark§tØrm said ITT that others can continue updating it)
All calculations should work as usual, but I broke the exp bar because my formatting is barely passable, I'm sorry <-< I might try to update the levels too up to 4?? if anyone wants but I can't promise it's going to be accurate.
 Dang my head hurts trying to think t formula of these array of number lol Hoping that can predict with t formula for any given level |
|
Niu
Member
last played in 2020
|
Post by Niu on Jan 29, 2020 12:00:15 GMT
Added levels 371-415!!
Based on the new numbers I found from jp wiki, feel free to play around with it and see if it's accurate. The formula is different than the original and I'll tweak it if there's more data. Let me know if I broke something (other than the exp bar)
New part of the chart as a png:
edit: MQ up to date as of 26/02/20 edit: this link is outdated look at latest post
|
|
Niu
Member
last played in 2020
|
Post by Niu on Mar 2, 2020 23:55:50 GMT
Update: - Fixed the formatting & broken exp bar, now it looks the way it's supposed to at least in Excel
- Added estimation of level after completing remaining MQ and SQ (works up to lv.414)
edit: MQ is up to date as of 25/03/20
|
|
|
|
Post by syzygy on Apr 15, 2020 20:57:59 GMT
there is a bug in required time to goal level estimator. It shows one hour extra if time required has minute part > 30.
CK38 should be
'FLOOR(((CK36*CK37)/60)/60,1)&" [h] "&ROUND(((((CK36*CK37)/60)/60)-TRUNC(((CK36*CK37)/60/60),0))*60,0)&" [m]"'
and not
'ROUND(((CK36*CK37)/60)/60,0)&" [h] "&ROUND(((((CK36*CK37)/60)/60)-TRUNC(((CK36*CK37)/60/60),0))*60,0)&" [m]"'
The same bug is present in time to level up estimator
|
|
Niu
Member
last played in 2020
|
Post by Niu on Apr 16, 2020 8:10:12 GMT
there is a bug in required time to goal level estimator. It shows one hour extra if time required has minute part > 30. CK38 should be 'FLOOR(((CK36*CK37)/60)/60,1)&" [h] "&ROUND(((((CK36*CK37)/60)/60)-TRUNC(((CK36*CK37)/60/60),0))*60,0)&" [m]"' and not 'ROUND(((CK36*CK37)/60)/60,0)&" [h] "&ROUND(((((CK36*CK37)/60)/60)-TRUNC(((CK36*CK37)/60/60),0))*60,0)&" [m]"' The same bug is present in time to level up estimator True, thank you! ^^ I've fixed it in the latest version (same link as previous, this one) edit: read the post below!
|
|
Niu
Member
last played in 2020
|
Post by Niu on Jul 21, 2024 19:43:03 GMT
Posting again because I got an email request for access to the sheet. Because ProBoards links have started redirecting oddly (or maybe they always did and I'm only now seeing the problem), I'm reposting the full link to the last version of the calculator edited by me back in 2020: Instructions for use: Copy and paste the link to a new tab (just clicking on the link might take you to tracker/ad hell or simply not work). Everyone with the link should be able to view and download the file. Download it to your machine in original .xlsx format and edit cell values locally. I am no longer updating this for the foreseeable future but if anyone has issues (the link stops working) just DM me or reply to this post and I'll try to help.
side note: Time flies, cheers for anyone still interested enough to read this post ^^
|
|
