| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Resources | ||||||
2 | My MMOMinion post | http://www.mmominion.com/thread-20707.html | |||||
3 | My Original (view only) Sheet | https://docs.google.com/spreadsheets/d/1AaVl5H7vpLB5EvRuFhkchCKsStc364PBpW748z7IFeY/edit | |||||
4 | FFXIV Crafting - Crafting as a Service | http://www.ffxivcrafting.com/ | |||||
5 | FFXIV Crafting Optimizer | http://ffxiv-beta.lokyst.net/index.html#/ | |||||
6 | [Web] Simple macro to profile (Crafting) | http://www.mmominion.com/thread-17104.html | http://midnightsushi.net/apps/mtp/ | (site seems to be down) | |||
7 | Regarding DotH profile creators | http://www.mmominion.com/thread-20538.html# | |||||
8 | Genetic's Craft Leveling and Gil Guide | http://www.mmominion.com/thread-18603.html | |||||
9 | Garland Tools | https://www.garlandtools.org/db/ | |||||
10 | |||||||
11 | Instructions: | ||||||
12 | 1. Copy this sheet so you have your own version | ||||||
13 | ---- My version will be shared but on view only mode. | ||||||
14 | ---- 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. | ||||||
15 | ---- 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) | ||||||
16 | 2. Go to http://ffxiv-beta.lokyst.net/index.html#/simulator and simulate your rotation | ||||||
17 | 3. Go to the your copy/version of the Google Sheet | ||||||
18 | 4. Go to the "Input Macros" tab | ||||||
19 | ---- Paste your "Cross-class Action Setup Macro" in Column A and your "Skill Macro" in Column B | ||||||
20 | ---- "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 | ||||||
21 | ---- Column C should tell you is there is a skill missing in my Skill Database | ||||||
22 | -------- If yes, Go to the "Skill Database" tab-------- Check column I and that all skills there are crossed (otherwise read instructions on adding a skill or flag/post here) | ||||||
23 | 5. Go to the "End Result" tab | ||||||
24 | --- go to File > Download as > Tab-separated values (.tsv, current sheet) > name file to whateveryouwantittobe.lua > Select "Save Type as" all files > Save | ||||||
25 | --- 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 | ||||||
26 | 6. Make sure lua file in the skill profile folder | ||||||
27 | ---- (C:\MINIONAPP\Bots\FFXIVMinion64\LuaMods\ffxivminion\SkillManagerProfiles) | ||||||
28 | 7. Reload Lua if the bot is running | ||||||
29 | 8. Set up your crafting profile and select the skill profile you downloaded | ||||||
30 | |||||||
31 | Instructions: Alternate Download Method | ||||||
32 | a. Copy/Paste your own Google sheet ID (URL): | 1AaVl5H7vpLB5EvRuFhkchCKsStc364PBpW748z7IFeY | <---- Do this once only, it is part of URL (replace mine with yours) | ||||
33 | b. Copy/Paste "End Result" gid# number (URL): | 1489160414 | <---- Do this once only, go to the "End Result" tab (replace mine with yours) | ||||
34 | -- Click the cell below and then the link, this will start the download process. | ||||||
35 | -- Click on "Save Type as" and select "All Files" | ||||||
36 | -- rename file to "whateveryouwantittobe.lua" | ||||||
37 | Click Here to Download | <---- There is a download "button" also on the "Input Macro Tab" | |||||
38 | |||||||
39 | Future Roadmap: | ||||||
40 | - Add all crafting name, skill level, skill ID, skill class type | ||||||
41 | - Ability to download and rename your file easier (possibly through Google Apps Script) | ||||||
42 | |||||||
43 | Feedback/Bugs | ||||||
44 | - Please post a detailed description of what you were doing and what went wrong (will be hard to replicate issue otherwise) | ||||||
45 | - For any missing/incorrect skill information please post which is wrong and what needs to be changed/added. | ||||||
46 | |||||||
47 | Update 1 - May-12-2018: 2.0.1 | ||||||
48 | - Clarified instructions for Copy and Download. | ||||||
49 | - Clarified why rotation output may not work (missing skills in skill database) | ||||||
50 | - 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) | ||||||
51 | |||||||
52 | Update 2 - May-13-2018: 2.0.2 | ||||||
53 | - Fixed issue where cross class skills with " ' " characters would break code and output empty rotation | ||||||
54 | - Added most every skill... I think... (except specialist skills to database) | ||||||
55 | |||||||
56 | Update 3 - May-16-2018: 2.0.3 | ||||||
57 | - 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) | ||||||
58 | |||||||
59 | Update 4 - May-19-2018: 2.0.4 | ||||||
60 | - Corrected some skills in database with wrong type set that would break cross-skill trigger and entire skill profile | ||||||
61 | |||||||
62 | Update 5 - May-20-2018: 2.0.5 (Make sure to delete any previous version you have and copy this version again) | ||||||
63 | - Added "button" for easier download | ||||||
64 | ---- IMPORTNANT: Please follow instructions steps if you want to use "link button" to download file. ---- | ||||||
65 | - You will need to replace the file ID and sheet ID in the instruction tab for your own sheet to download properly. | ||||||
66 | - Make sure to change your Google Sheet sharing settings to "Anyone who has the link can view" | ||||||
67 | - 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) | ||||||
68 | - If you do not want to do this simply ignore "link button" and follow original download steps. | ||||||