Forum Settings
       
Reply To Thread

Gathering Counter/Fatigue TrackerFollow

#1 Sep 18 2011 at 2:59 PM Rating: Excellent
*
109 posts
Been working on an excel spreadsheet/program to keep track of your successful gathers and how they affect your fatigue buildup. The program allows you to tally up your successes and it keeps track of how long since you've started gathering, allowing for both a raw total and a total that is corrected for fatigue regeneration (currently 10 gathers per hour).
The program can only work while you are in windowed mode or if you have some secondary machine that can run a set of Visual Basic excel macros as you have to manually input the successes either with the shortcut or clicking the appropriate button, this is not a bot, merely a way to keep track of your gathering session.
It's in .xlsm format and was created with Excel 2007, so it should work fine with 2010 but I don't know about backwards compatibility. It's also completely unlocked and only starts manually, so feel free to peruse the code.
Instructions: 
-Open the file in Excel 
-If you haven't enabled the developer tab, do so 
-Enable macros 
-On your first successful gather, hit "Start Gathering", it will add a success to the counter, record the start time and start the timer 
-On each additional success, you can click "Add Success" or use the shortcut "ctrl + g", it will increment the "Successful Gathers" cell 
      -The "Corrected Gathers" cell represents your total successes minus the amount of fatigue regeneration that has occurred since you began 
       (it subtracts 10 for each hour that passes from the beginning of your session) 
-When you are finished using the counter, either click "Stop Gathering" or let the program run until the fatigue resets completely (i.e. overnight) 
       -Clicking "Stop Gathering" will auto-save your start time and total gathers to the first available slot 
            -After stopping, save the file, when you re-open hit "Restart Clock" to start the timer without resetting your start time (use the save 
            slot info in case your time or gathering count are reset) 
-If the program runs until fatigue is reset, click "Stop Gathering" to stop the timer, then "Clear Data" to erase the total time and gather cells  
       -You'll also want to clear the save slot data that you no longer need, once all three slots are filled it will not save again

That's all there is to it, after you erase the data you are back to square one. The counter can count across months and shouldn't require a large system resource drain, mileage on that may vary of course. Also, if someone would like to take this and turn it into a Windows Gadget (or Keyboard LCD app if possible) feel free to do so, I don't know how to code either of those though so that'll be up to you, I'll be happy to help however I can.

Link:https://rapidshare.com/files/1691704277/Gathering.xlsm

Note: This counter operates on the assumption that the gathering fatigue timer in game begins when you first pull something in from a gather, if that is later found to not be the case I'll work on modifying it then.
Edited, Sep 18th 2011 5:00pm by LemmingKingXXX

Edited, Sep 18th 2011 5:04pm by LemmingKingXXX
____________________________
FFXIV Signature
Kashius wrote:
Things WoW did not invent:
...
- Fun
#2 Sep 21 2011 at 8:12 AM Rating: Good
***
1,062 posts
Cool, I will definitely check it out.

Sidenote: Its funny how anyone who doesn't gather thinks fatigue is completely gone because it was removed for DoW/M - I have gotten into so many arguments with people in my LS because I'll be mining and CLINK 'You have damaged a zinc ore'.

Me: I just hit fatigue :(
LS: There is no fatigue anymore
Me: Item fatigue I mean
LS: Fatigue was removed
Me: Gathering fatigue, as in I'm getting damaged items
LS: You just don't know how to mine LOL LOL
Me: @%^@^(@)^

*sigh*
____________________________
Wada: "There may be some areas of testing that were lacking or too rigid."
#3 Sep 21 2011 at 11:57 AM Rating: Excellent
*
109 posts
I actually just had a reason to go beyond the 150 success wall last night to try and gain a rank I was close to, holy crap it was excruciating, from my eyeball calculations it appeared to me that my gather success rate immediately dropped to around half of what it was before I hit the wall (I was getting about 70 successes per hour before, and it dropped to 35 per hour after the wall), I really don't think it's worth trying to go beyond the wall at grade 5 spots (maybe that'll change when I'm 50) as you can still make it to complete 250 fatigue but it'll take a lot longer to cap out
____________________________
FFXIV Signature
Kashius wrote:
Things WoW did not invent:
...
- Fun
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 10 All times are in CDT
Anonymous Guests (10)