Epertyufi

I have been thinking about making such a thread for a while now and I am glad that I'm not the only one

I would be very much interested in doing these raids. I have yet to finish the Vale Guardian Raid but I know the mechanics although I have little experience with the last phase as most of the time my team wiped before we reached it (I've only done full PUG raids so far). I have a full zerker tempest (mostly used d/f, now in the process of getting more familiar with d/wh for better seeker control) which I can bring and have experience with. I was also thinking about trying out a druid but thats something for the future (though if it turns out we are lacking healers and have too many ppl rolling dps than I would gladly spend more time on leveling my druid up :] )

Well never you mind all that. Silver just sent me a link to this site: http://jfnaud.github.io/Guild-Wars-2-Gold-per-hour/

It turns out I didn't do my research properly and someone already made a much better version of this *sadbuthappybutsadface*

Anyways I'm gonna leave mine here so people who are interested in this stuff can check it out.

Heyho all!

First of all I would like to thank Silver for the effort he put into his spreadsheet \o/ It inspired me to create one of my own for tracking loot over a period of time. The idea came when I was opening up my ~100 bags after a few runs at Silverwastes. What I usually do is open bags - salvage some - mystic toliet forge some others for rares (salvage for ectos) - inv gets full - deposit mats - repeat. This of course means that after spending my whole day opening bags I actually have no idea how much gold I have effectively made which makes me sad. So sad in fact that I had to look into the GW2 API, Excel, and VBA of which the last two I could really do without. So I have created this spreadsheet and I hope that others can also find it useful for comparing farming methods or just keeping track of their income or for whatever other reasons.

What my spreadsheet does:

• Upon starting a session it asks GW for your inventory info. It asks for your material storage to be precise. I do not include other inv items because I either salvage items or if I can sell them on TP for more than what it would salvage to then I sell it immediately to clear up space. However if you find that you would like to keep track of other items too, please let me know.
• Upon ending a session it asks for this information again. From the two it calculates what items you have acquired during the session and asks GW for their current price on TP (both instant sell price and the lowest listing price are included).

How to use it:

• First of all, you need to make an API key on the Guild Wars website. The spreadsheet needs it to be able to ask for account related stuff. To make one simply go to https://account.arena.net/applications then click 'New key'. A list of checkboxes will appear from which you should check 'inventories' (you can also check 'wallet' as I'm planning on including different currencies too). 
• Clicking the 'Create API Key button' will give you your key which looks something like this: xxxxxxxxx-xxxx-xxxxx-xxxxx-xxxxxxxxxxxxxxxxxxxx-xxxx-xxxxx-xxxxx-xxxxxxxxxxxx
• Copy this key and in the spreadsheet paste it in cell 'E1' right next to where it says 'Acces token:' 
• To make a snapshot of your inventory and start the session click the 'Start Session' button.
• When you are finished click 'End Session'. Now a script will check what items you've acquired and ask for their price from GW. This might take a while so be patient.
• NOTE: the inventory info seems to be only updated every 10-15 mins. This is a limitation of the Guild Wars API and there is nothing I can do about it :[ Keeping this in mind it is probably best to click 'End Session' 10-15 mins after actually finishing your farming. Although:
• NOTE2: withdrawing stuff from TP is also counted so you should refrain from doing so until you have clicked 'End Session' to avoid seeing false information. I believe this is not that much of a nuisance but if you find this annoying feel free to message me about it and I might do something about it (though I might not, be warned )
• If you'd like you can refresh the prices by clicking the 'Refresh prices' button (takes a while).

As I mentioned above I am planning on including wallet information so you can keep track of your currencies in the same way, but right now I couldn't get it working  Any suggestions for additional functionalites are welcome (and might be included though might not ). Also feel free to message me if you have any questions about the spreadsheet either here on the Open Community website or in-game (Epertyufi) and I will answer you as soon as whatever. Also feel free to use and edit the scripts, but be warned: the code could be cleaner... a lot cleaner...  (i might clean up it later... though... you know.. :] )

You can download the spreadsheet here: https://drive.google.com/file/d/0B5llVcwBeTzBTXZFZ2YyX2oyRUE/view?usp=sharing

(this explanation turned out to be longer than I expected, but I'm still not sure if it should be in a seperate thread or not so I'll just leave this here for now)