|
Post by Ryukengan on Jul 15, 2017 21:56:37 GMT
Link to Sheet
Hello, today I want to share with you something I've been working on for a while. It is a spreadsheet, where you can type in your character information for theorycrafting.
How to use it: Download a copy of it on your own Google Drive to fill in your information.Things that are missing/I still want to implement:- Class passives
- Battle calculator
If you have any suggestions or find any mistakes, to the things I have currently added, let me know (I know that the MDEF formula seems to be wrong but I am not entirely sure). If you decide to share it with people, please give credit, especially to the other sources.
|
|
|
Post by Zensui_X on Jul 16, 2017 1:29:19 GMT
Dex from equipment is missing? Doesn't it also raises matk a little bit?
Minor stuff, you missed Melee to wind, and Wind Magic...
This is cool mate, hope it develop further
|
|
|
Post by Ryukengan on Jul 16, 2017 2:08:44 GMT
Zensui_X The little dark rectangles on the top right corner of the cells are notes, one of it reads:"Add stats from equip onto these except VIT and INT If you are in a guild add an additional point to every status every 20 guild levels (RD,GR,BL excluded)" Stats from equipment can be treated as normal stats, except for VIT and INT, which is why they are treated seperately. Added Melee to Wind and Wind Magic, thank you for pointing it out! However, these stats are part of the battle simulator that I am still going to implement in the future. So far they don't have any formulas related to them. If someone is good at formulas and has some Iruna-knowledge, they are welcome to make their modifications and share it with me through a Private Message and I will consider implementing it. 1 Hidden AGI added to Job Bonus(Not sure if it's Job Bonus or Mastery) of Bishop (again, tests are required and welcome, EVA and ASPD value across 10 cases were correct for me)
|
|
|
Post by Ryukengan on Jul 17, 2017 19:42:23 GMT
Changelog:
1. Adjusted the ASPD formula, it should be more accurate now! Speculated 5 hidden AGI added to Sniper Job Mastery (completely new info - would be cool if Snipers out there could test it with their characters 280+!) Purple Lines ASPD value changed from presumed 27% (from JP blog) to 30% due to ASPD formula adjustion (again would be cool if people could test it out - I ran 10 cases and all were correct so far).
2. Added a reset function (on the top if you press on Custom, there should be a button to reset your sheet to default values)
Edit: Should I add the Changelog to the Sheet itself, the first post, or keep it here?
|
|
|
Post by Ryukengan on Aug 19, 2017 22:58:18 GMT
Added the presumably correct job mastery bonus for sniper. If you want to help me out use beginner gear and screenshot all your stats/equips/als before a job change and after a job change, or before acquiring a new passive skill and after a new passive skill.
|
|
|
Post by 'AhSaN' on Aug 30, 2017 8:48:24 GMT
Ryukengan Hello, In the Sheet I've seen stuffs like Monk JB Paladin JB...etc What does this JB mean? And, I am using iOS. It seems like it makes me go straight to the docs. I cannot really download it. I have never used Drive or Google Sheets and I dont see any download button. (Or am I blind?). So, my second question is, If I add values online, will it get changed?
|
|
|
Post by Ryukengan on Aug 30, 2017 13:02:31 GMT
'AhSaN' JB means Job Bonus. Many of these values are still experimental and not 100% confirmed, alot of them are also unknown still. Idk how it works on iOS, sorry I can't help you there. But you should be able to simply save it to your own Google Docs and then enter your own values and tinker around with it.
|
|
|
Post by 'AhSaN' on Aug 30, 2017 14:47:15 GMT
'AhSaN' JB means Job Bonus. Many of these values are still experimental and not 100% confirmed, alot of them are also unknown still. Idk how it works on iOS, sorry I can't help you there. But you should be able to simply save it to your own Google Docs and then enter your own values and tinker around with it. Thank you very much ^_^. I'll try downloading a app that can help me download it. Thank you for the information ^_^
|
|
|
Post by Ryukengan on Nov 11, 2017 6:34:11 GMT
So I had the battle simulator and skill simulator almost figured out but I will wait for the balance patch to be released because that will probably change a whole lot about the game.
|
|
|
Post by Zensui_X on Jul 16, 2018 14:41:24 GMT
Still rooting for this...
|
|
|
Post by Ryukengan on Jul 19, 2018 11:24:36 GMT
Zensui_X I have to wait for new formulas to pop up to plug everything in, it will take at the very least a few months before people find them out
|
|