Maintenance for the week of January 6:
• PC/Mac: No maintenance – January 6
• NA megaservers for maintenance – January 8, 4:00AM EST (9:00 UTC) - 8:00AM EST (13:00 UTC)
• EU megaservers for maintenance – January 8, 9:00 UTC (4:00AM EST) - 13:00 UTC (8:00AM EST)
• PC/Mac: No maintenance – January 6
• NA megaservers for maintenance – January 8, 4:00AM EST (9:00 UTC) - 8:00AM EST (13:00 UTC)
• EU megaservers for maintenance – January 8, 9:00 UTC (4:00AM EST) - 13:00 UTC (8:00AM EST)
Rotation planner
incognito_8
✭✭
Hey all,
as most people, I am using add-ons like action duration timer or similar to practice parsing, because even being just a casual player who can’t afford hours of game play on a daily basis, I would still like to have a competitive dps for occasional no hm veteran trials.
I like more static, easy-to-remember rotations, with skills sorted to be pressed in a row, like central skill-1-2-3, central skill-barswap-1-2-3 (by central skill I mean skills such as blast bones/prey/spectral bow/shalks etc).
What I thought would be useful, is to have an option to pause the parse in the middle of it, to better figure out what skills to proc next, to sort them on a bar in a more suitable way for me and maybe to be able to test it off the game.
For that purpose, I made a small macro enabled excel sheet to test rotation while being able to check skill expiration timers and not being under pressure of seconds passing by. It also records rotation sequence, and in a way mimics parsing, cause weaving light attacks are imitated with double mouse clicks after skills being fired.
Just thought to share it here and maybe someone else could have some use for it as well.
excelerator.gq/wp-content/uploads/2021/04/rotation_planner.zip
Edited by incognito_8 on April 21, 2021 6:07AM as most people, I am using add-ons like action duration timer or similar to practice parsing, because even being just a casual player who can’t afford hours of game play on a daily basis, I would still like to have a competitive dps for occasional no hm veteran trials.
I like more static, easy-to-remember rotations, with skills sorted to be pressed in a row, like central skill-1-2-3, central skill-barswap-1-2-3 (by central skill I mean skills such as blast bones/prey/spectral bow/shalks etc).
What I thought would be useful, is to have an option to pause the parse in the middle of it, to better figure out what skills to proc next, to sort them on a bar in a more suitable way for me and maybe to be able to test it off the game.
For that purpose, I made a small macro enabled excel sheet to test rotation while being able to check skill expiration timers and not being under pressure of seconds passing by. It also records rotation sequence, and in a way mimics parsing, cause weaving light attacks are imitated with double mouse clicks after skills being fired.
Just thought to share it here and maybe someone else could have some use for it as well.
excelerator.gq/wp-content/uploads/2021/04/rotation_planner.zip
GM in Noble Guardians.
2
-
Mariusghost84✭✭✭✭✭Will def check this out when I have the time. Thanks for sharing. Will give feedback later.0 -
incognito_8✭✭Yes, it's just an excel macro, it doesn't have anything to do with online game, it is not an add on and I can't code either. It only helps watcnihg dot timers while you press skill numbers in excel and gives you more time to plan your next move. It surely can't be against rules.GM in Noble Guardians.1
-
zvavi✭✭✭✭✭
✭✭✭✭✭Uh apologies, when in gaming someone says macro it is usually when you press one button and it does sequence of actions for you.1 -
WrathOfInnos✭✭✭✭✭
✭✭✭✭✭Looks like a good tool. I’ve done similar things in the past, but never to this level. I agree that skill decisions are better when planned out beforehand, not dynamically in a trial. And technically even dynamic rotations are just long, static ones that nobody has bothered to map out.
One thing to watch out for is opportunities to recast a skill early. Methods like this can have a hard time seeing these, but rotations can benefit greatly from it. Such as Warden casting Winter’s Revenge before 12s to align with their other DoT times and fit well with the Deep Fissure rhythm. One of the best Necro rotations casts Orb and Wall on 9s (not 10) and several of the simple static ones choose to do Mystic Siphon every 10s (not 12) for simplicity and to ensure Siphon and Boneyard don’t steal each other’s corpses.1 -
Mariusghost84✭✭✭✭✭I finally got the time to take a look and i must say this looks amazing. I have no idea what so ever on how to use this however. Would it be possible for you to create a youtube video perhaps and show us? Or maybe explain in text?
Looks like a lot of effort on your side, huge props for sharing this! Now if we can only learn to use this, it would kinda open up a new world of theorycrafting when it comes to rotation.
Amazing!0 -
incognito_8✭✭First of all thank you all for finding the time to take a look.
I found a small mistake when I first uploaded it, 1 auxiliary sheet was missing, so i fixed it and replaced it yesterday, now selecting skill lines and appropriate skills under front/back bar should work.
What i had in mind for this workbook is to:
- use the worksheet in an interactive manner, sheet does the work for you
- select skills and watch counter go down on DOTs to optimize when to refresh them
- plan rotation steadily, as no GCD timer is there for pressure
- go back in time by erasing few steps if you want to change your cast skill choice
- get rotation log (statistics) in steps
- select a central skill to track for (e.g. watch if you cast blastbones every 3rd or even more in a cycle)
- easy to reset
- copy sheet to select another class and save it to not have to hassle by selecting everything from scratch
For your question on how to use it, there are instructions in the sheet if you click on a spoiler button 'Instructions'.
What to do:
- enable the macro if it prompts you at start
- only blue and crimson button matter (buttons in the middle of the sheet)
- at the beginning press once on the blue button (this is where you will type numbers 1-6, aka skill keys)
- double click mouse on crimson button (no need to select any other cell afterwards, stay on crimson)
- repeat: type skill number-double click, skill number-double click etc.
- press the button in middle named 'Front bar' Back bar' to swap bars respectively.
- on the left side you will have a log of the skills you weaved.
There is also on the left side button to track skill if you want to check your main skill (aka blast bones) or maybe if you are doing force pulse twice for asylum destro, idk.
Blue button is there for macro to check what skill you have been selecting, to log it on the left.
Crimson button logs total double clicks, aka LA weaving (behaves like enter key).
I hoped to have designed it in a familiar manner to let everyone just LA-pressskillnumber weave as they would in game, except you need to double click for LA to fire.GM in Noble Guardians.0
