+- MMOMinion (https://www.mmominion.com)
+-- Forum: FFXIVMinion (https://www.mmominion.com/forumdisplay.php?fid=87)
+--- Forum: [DOWNLOADS] Addons, Lua Modules, Navigation Meshes.. (https://www.mmominion.com/forumdisplay.php?fid=90)
+---- Forum: Tools / Apps / Programs for FFXIVMinion (https://www.mmominion.com/forumdisplay.php?fid=101)
+---- Thread: Macro to Crafting Skill Profiles - Google Sheet (/showthread.php?tid=20707)
RE: Macro to Crafting Skill Profiles - Google Sheet - dolsi00 - 05-17-2018
"Skill Macro" formula calculates up to 40 skills in your rotation. pls
RE: Macro to Crafting Skill Profiles - Google Sheet - Colaveare - 05-18-2018
Not a problem. I'll go from 28 to 40 total skills but may take me a few days to do.
Will do.
RE: Macro to Crafting Skill Profiles - Google Sheet - dolsi00 - 05-18-2018
(05-18-2018, 01:34 AM)Colaveare Wrote: Not a problem. I'll go from 28 to 40 total skills but may take me a few days to do.
Will do.
Thank you！！！！
RE: Macro to Crafting Skill Profiles - Google Sheet - Rurouni - 05-19-2018
i think your google sheet doesnt like me lol...
still cant seem to get it to work even after putting the last line in the macro..
EDIT - working fine !!! Thank you !
RE: Macro to Crafting Skill Profiles - Google Sheet - Rurouni - 05-19-2018
The google doc works flawlessly! Now I don't have to manually input every skill...a bit time consuming when you have like 20-30 long skill rotations!
Any way you could make it like the original website where we just paste in the macro, then just name it to whatever we want and click download?
RE: Macro to Crafting Skill Profiles - Google Sheet - Colaveare - 05-20-2018
@Rurouni
I don't think I'll be able to replicate the website experience from the previous tool.
Due to Google Sheet/Google Scripts limitations any script I create for my Sheet would not replicate on copies.
The major benefit though is that since everyone has their own version it won't go offline.
Plus anyone with a bit of knowledge will be able to update them if necessary (tried to make them as simple as possible formula wise)
Though, found a possible midway option.
This will create the proper string to trigger the download.
---- This should help against mistake (I kept accidentally downloading the "Input Macro" tab instead of the "End Result" tab
Basically, I added a cell that will work as a link/URL that triggers a download function.
You will need to copy YOUR own sheet ID and the "End Result" tab ID in the "Instruction" tab
Added updates in original post.
RE: Macro to Crafting Skill Profiles - Google Sheet - Rurouni - 05-20-2018
Thanks for your hard work ! Can an admin please pin this thread? It is a very helpful tool for anyone who doesnt understand how to use the crafting mod of the bot.
RE: Macro to Crafting Skill Profiles - Google Sheet - secretclean - 06-05-2018
Is it possible to set these up and then share the lua to make it afkable for people starting at level 1?
RE: Macro to Crafting Skill Profiles - Google Sheet - tenaciel - 06-24-2018
Where are you finding whether a skill is type 1 or type 9?
RE: Macro to Crafting Skill Profiles - Google Sheet - rsilva712 - 06-29-2018
(06-24-2018, 05:05 PM)tenaciel Wrote: Where are you finding whether a skill is type 1 or type 9?
I explained it here to someone else:
http://www.mmominion.com/thread-20744-post-168880.html#pid168880