@Rurouni
Thank you very much for the feedback, I'll definitely need to clarify the steps as they can indeed lead to confusion.
1.) What I initially meant was to you need make your own copy of the sheet and not download it as an Excel file
Basically there are some formulas there that only work on Google Sheets and does not get translated to Excel.
2.) I'll clarify the instructions so that it states to "Make a Copy" of the file is clearer.
What happens is that if 2 people are editing the same file (mine) live they would be changing the output in real time.
You could end up basically having someone else's rotation accidentally.
Instead you need to create a Google Sheet copy/duplicate so you are the only one with access to that one.
- You need to go to File > "Make a Copy
This will duplicate the original file into another Google Sheet file that you own (this means you have to have a Google account though)
Then you would use your own file to make your rotations.
This way, if anything ever happens and mine goes down people could still use their copy and if they are good with sheets even take over the project.
2.) When you have your copy you should be able to see the " Download as > tab-seperated" option as this is a Google sheet feature.
I'll clarify the steps there also.
3.) Also, even if the file gets downloaded as a .tsv file you can simply rename it after it is downloaded to "whateveryouwant.lua" manually
- though, I am trying to see if there is a way to have it save straight as .lua
4.) As, to see if there is an error in the formulas output you would kinda need to look at the end result and check manually...
Which is a pain if you don't know what to check for. This step was just as a fail safe but to be honest you can ignore it as the formulas process pretty fast.
5.) Now, if for some reason after all of this rotation is not working, the reason could be because there is a skill in your rotation that is not yet added to the "Skill Database" tab
Basically all my crafting classes are at 60 so I haven't yet added 60+ skills and the specialist skills. And, I believe that there is still some 60- skills missing in my list... sigh.
I'll be working on those and adding them soon.
Though when that is done, you would need to "copy" my file again as the changes will only take place there.
Meanwhile, I'll also edit the Bug section to request people to simply past their cross skill and rotation from http://ffxiv-beta.lokyst.net/index.html#/simulator in a reply so I can check if missing a skill in my database.
I'll edit in the following minutes my main post.
Thanks again for the feedback!!!
Thank you very much for the feedback, I'll definitely need to clarify the steps as they can indeed lead to confusion.
1.) What I initially meant was to you need make your own copy of the sheet and not download it as an Excel file
Basically there are some formulas there that only work on Google Sheets and does not get translated to Excel.
2.) I'll clarify the instructions so that it states to "Make a Copy" of the file is clearer.
What happens is that if 2 people are editing the same file (mine) live they would be changing the output in real time.
You could end up basically having someone else's rotation accidentally.
Instead you need to create a Google Sheet copy/duplicate so you are the only one with access to that one.
- You need to go to File > "Make a Copy
This will duplicate the original file into another Google Sheet file that you own (this means you have to have a Google account though)
Then you would use your own file to make your rotations.
This way, if anything ever happens and mine goes down people could still use their copy and if they are good with sheets even take over the project.
2.) When you have your copy you should be able to see the " Download as > tab-seperated" option as this is a Google sheet feature.
I'll clarify the steps there also.
3.) Also, even if the file gets downloaded as a .tsv file you can simply rename it after it is downloaded to "whateveryouwant.lua" manually
- though, I am trying to see if there is a way to have it save straight as .lua
4.) As, to see if there is an error in the formulas output you would kinda need to look at the end result and check manually...
Which is a pain if you don't know what to check for. This step was just as a fail safe but to be honest you can ignore it as the formulas process pretty fast.
5.) Now, if for some reason after all of this rotation is not working, the reason could be because there is a skill in your rotation that is not yet added to the "Skill Database" tab
Basically all my crafting classes are at 60 so I haven't yet added 60+ skills and the specialist skills. And, I believe that there is still some 60- skills missing in my list... sigh.
I'll be working on those and adding them soon.
Though when that is done, you would need to "copy" my file again as the changes will only take place there.
Meanwhile, I'll also edit the Bug section to request people to simply past their cross skill and rotation from http://ffxiv-beta.lokyst.net/index.html#/simulator in a reply so I can check if missing a skill in my database.
I'll edit in the following minutes my main post.
Thanks again for the feedback!!!