• Close
    • > > > > Macro to Crafting Skill Profiles - Google Sheet >


    Thread Closed 
    Thread Rating:
    • 3 Vote(s) - 4 Average
    • 1
    • 2
    • 3
    • 4
    • 5
    Macro to Crafting Skill Profiles - Google Sheet
    dolsi00 Offline
    Junior Member
    **
    Posts: 7
    Threads: 1
    Joined: Mar 2016
    #11
    05-17-2018, 07:53 AM
    "Skill Macro" formula calculates up to 40 skills in your rotation. 　pls
    Find
    Colaveare Offline
    Junior Member
    **
    Posts: 9
    Threads: 1
    Joined: Feb 2018
    #12
    05-18-2018, 01:34 AM
    Not a problem. I'll go from 28 to 40 total skills but may take me a few days to do.

    Will do.
    Find
    dolsi00 Offline
    Junior Member
    **
    Posts: 7
    Threads: 1
    Joined: Mar 2016
    #13
    05-18-2018, 10:59 AM
    (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！！！！
    Find
    Rurouni Offline
    Subscriber
    Posts: 31
    Threads: 8
    Joined: Aug 2017
    #14
    05-19-2018, 03:25 AM (This post was last modified: 05-19-2018, 03:26 AM by Rurouni.)
    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 !
    Find
    Rurouni Offline
    Subscriber
    Posts: 31
    Threads: 8
    Joined: Aug 2017
    #15
    05-19-2018, 05:12 AM (This post was last modified: 05-19-2018, 05:14 AM by Rurouni.)
    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?
    Find
    Colaveare Offline
    Junior Member
    **
    Posts: 9
    Threads: 1
    Joined: Feb 2018
    #16
    05-20-2018, 05:21 AM
    @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.
    Find
    Rurouni Offline
    Subscriber
    Posts: 31
    Threads: 8
    Joined: Aug 2017
    #17
    05-20-2018, 07:11 AM
    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.
    Find
    secretclean Offline
    Junior Member
    **
    Posts: 42
    Threads: 6
    Joined: Apr 2017
    #18
    06-05-2018, 04:21 AM
    Is it possible to set these up and then share the lua to make it afkable for people starting at level 1?
    Find
    tenaciel Offline
    Junior Member
    **
    Posts: 7
    Threads: 3
    Joined: Jun 2016
    #19
    06-24-2018, 05:05 PM
    Where are you finding whether a skill is type 1 or type 9?
    Find
    rsilva712 Offline
    Subscriber
    Posts: 734
    Threads: 18
    Joined: Feb 2014
    #20
    06-29-2018, 07:49 AM
    (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-po...#pid168880
    Find
     
    Thread Closed 


    Forum Jump:


    Users browsing this thread: 4 Guest(s)

    We help you win the game.

    FFXIV Bot and More.

     

    Products

    Here To Help

    Information