Thread Rating:
  • 3 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Macro to Crafting Skill Profiles - Google Sheet
#1
Hello All,

Originally I was using the following tool/site to create my crafting skill profiles:
- [Web] Simple macro to profile (Crafting)

Sadly the site seems to be down and as such I had to create my skill profiles directly in MMOMinion...
Being lazy, I found this unacceptable.

As such, during this time, I decided to make my own little tool using Google Sheets.
All formulas are working and it's ready if anyone is interested in it also.

Basically this Sheet will use the Macros create by "FFXIV Crafting Optimizer" and allow you to convert them to a MMOMinion lua file.
It's going to be "dumb" skill profiles but this will allow people to create those profiles much faster.

Please be aware that my crafting classes are only at 60. As such my skill database in the sheet is still missing skills.
I'll add them as I go or if anyone posts missing skills that they need added.
Though, each time I do so you would need to copy my sheet again to get an updated version.
- Just in case that people don't feel like telling me what is missing, I have added instructions on how to check if any are missing and how to add them in the "Skill database" tab

All I need now is to add the following to the sheet database:
- Skill Name, Skill Level, Skill Number, Skill Class Type

If anyone has the entire skill list with any of the above info for Crafters it would be much appreciated.

Basically, here is how it works.
  • Go to the Cross Class and Crafting Skill Rotation Google Sheet and copy it so you have your own version
    ---- My version will be shared but on view only mode.
    ---- Can't have everyone use the same sheet as this means 2 persons may be editing it at the same time. You could end up basically having someone else rotation accidentally.
    ---- go to "File > Make a Copy > Save copy to your Google Drive (recommend renaming it with the date of the copy, this way you know when you copied from the original, in case I update mine)
  • Go to http://ffxiv-beta.lokyst.net/index.html#/simulator and simulate your rotation
  • Go to the your copy/version of the Google Sheet
  • Go to the "Input Macros" tab
    ---- Paste your "Cross-class Action Setup Macro" in Column A and your "Skill Macro" in Column B
    -------- Make sure to copy entire macro including the /echo line otherwise it breaks formulas---- "Skill Macro" formula calculates up to 28 skills in your rotation. If more is needed let me know and I can eventually add extra lines to the formula---- Column C should tell you is there is a skill missing in my Skill Database-------- If yes, Go to the "Skill Database" tab-------- Check column I and that all skills there are crossed and not tagged with "missing" (otherwise read instructions on adding a skill or flag/post here)
  • Go to the "End Result" tab
    --- go to File > Download as > Tab-separated values (.tsv, current sheet) > name file to whateveryouwantittobe.lua > Select "Save Type as" all files > Save
    --- you can also do File > Download as > Tab-separated values (.tsv, current sheet) > save > find downloaded file in your computer and rename it manually to whateveryouwantittobe.lua
  • Make sure lua file in the skill profile folder
    ---- (C:\MINIONAPP\Bots\FFXIVMinion64\LuaMods\ffxivminion\SkillManagerProfiles)
  • Reload Lua if the bot is running
  • Set up your crafting profile and select the skill profile you downloaded
Instructions for Alternate Download Method (see "Instructions" tab in Google Sheet)
  • Copy/Paste your own Google sheet ID (URL): it is part of the URL, just replace my sheet ID by yours <---- This only needs to be done once 
  • Copy/Paste "End Result" gid# number (URL): Go to your "End Result tab" and get your own tab ID, just replace my tab ID by yours <---- This only needs to be done once 
    -- Click the cell below and then the link, this will start the download process. -- Click on "Save Type as" and select "All Files" -- rename file to "whateveryouwantittobe.lua" 

Downloads and Links:
Cross Class and Crafting Skill Rotation Google Sheet
FFXIV Crafting Optimizer

Future roadmap:
- Add all crafting name, skill level, skill ID, skill class type
- Ability to download and rename your file easier (possibly through Google Apps Script)

Feedback/Bugs
- Please post a detailed description of what you were doing and what went wrong (will be hard to replicate issue otherwise)
- For any missing/incorrect skill information please post which is wrong and what needs to be changed/added.


Update 1 - May-12-2018:
- Clarified instructions for Copy and Download.
- Clarified why rotation output may not work (missing skills in skill database)
- Added in sheet way to check if skill database includes all skills being used in rotation (with instructions on how to fix and how to flag it to me if you feel like improving original version for everyone)

Update 2 - May-13-2018: 
- Fixed issue where cross class skills with " ' " characters would break code and output empty rotation
- Added a whole bunch if not most every skill to database... I think... (except specialist skills)
- Added version number to Sheet title for better tracking if you have the latest version

Update 3 - May-16-2018: v2.0.3 [i][b](Make sure to delete any previous version you have and copy this version again)[/b][/i]
- Fixed issue where "Name of" and "Brand of" skills where breaking entire lua.  (skill type was set as "9" instead "1" in skill database type)

Update 4 - May-19-2018: 2.0.4
- Corrected some skills in database with wrong type set that would break cross-skill trigger and entire skill profile

Update 5 - May-20-2018: 2.0.5  (Make sure to delete any previous version you have and copy this version again)
- Added "button" for easier download
---- IMPORTNANT: Please follow instructions steps if you want to use "link button" to download file. ----
- You will need to replace the file ID and sheet ID in the instruction tab for your own sheet to download properly.
- Make sure to change your Google Sheet sharing settings to "Anyone who has the link can view"
- You will still need to select "Save Type as" "All files" and rename file manually but should help with mistakes (like being on the wrong tab when saving)
- If you do not want to do this simply ignore "link button" and follow original download steps.

Thanks
 


Messages In This Thread
Macro to Crafting Skill Profiles - Google Sheet - by Colaveare - 05-10-2018, 03:21 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)

We help you win the game.

FFXIV Bot and More.

 

Products