Guild Wars 2

I like making spreadsheets, so I’ve amassed quite a few of GW2-related sheets over the past several months. I’ve been converting them to Google Sheets so I can share them with the community.

I wasn’t sure whether I should make individual threads for each sheet, so here’s all of them in one post.

Cloth/Leather Salvaging Calculator

Back when I was salvaging cloth items for ascended crafting and luck, I used this sheet to let me know what prices I should be buying blue armor items for.

Asset Inventory Tracker

When I was trying to flip things months ago, I threw together this basic inventory tracker so I could remember what items I had ordered and what prices I planned to sell things for.

Insert new rows and copy/paste rows for new entries, and drag rows between sections to bring some order to your transactions.

Luck Calculator

This spreadsheet gives you information about the Luck grind from 0% (or wherever you’re at) to 300%. How much luck you accumulate per day, how long until your next level, how many blues/greens/ectos you would need to get to 300%, how many hours you’ll be clicking, all that fun stuff.

GW2Spidy library for Google Sheets

All these spreadsheets use this library to fetch information from GW2Spidy. If you want to use it in your own spreadsheets, it’s available too.

Ascended Crafting Tracker/Calculator

I already posted about this one in the Crafting forum, so go check it out over there.

Dungeon Skins Checklist

Not BLTP-related, so I posted this one in the dungeon forum, go check it out there.

If you have any questions, ideas, or whatever, let me know. I’ll have a few more up probably in the next day or two. Have fun with all the numbers!

Thank you. I am just starting to explore ascended crafting so your spreadsheet will be very helpful.

Thank you very much for the luck essence calculator, very usefull !

Master SK is far cheaper than Mystic SK
your calculate seems to ignore the cost of Mystic Forge Stones. For 516 stones at today’s gold → gem price, that’s another 23,220 gems = 2,800 gold. So instead of 45g8s56c it’s 2845g8s56c
on the other hand, 42,955 salvages with Mystic SK costs:
42,955 / 25 = 1718.2 × 15s36c = 263g91s55c
that’s 2581g cheaper: 1/10.8 as much
sure; you could get a few stones for ‘free’ through AP chests, and those would of course yield cheaper kits. But it would take around 45,000 AP to get that many stones.

Aside from that recommendation; great spreadsheets!

Mystic.5934:

Master SK is far cheaper than Mystic SK
your calculate seems to ignore the cost of Mystic Forge Stones. For 516 stones at today’s gold -> gem price, that’s another 23,220 gems = 2,800 gold. So instead of 45g8s56c it’s 2845g8s56c
on the other hand, 42,955 salvages with Mystic SK costs:
42,955 / 25 = 1718.2 × 15s36c = 263g91s55c
that’s 2581g cheaper: 1/10.8 as much
sure; you could get a few stones for ‘free’ through AP chests, and those would of course yield cheaper kits. But it would take around 45,000 AP to get that many stones.

Aside from that recommendation; great spreadsheets!

If you have over a 100 mystic forge stones what would be an alternate and consistent way to use them?

Mystic.5934:

Master SK is far cheaper than Mystic SK
your calculate seems to ignore the cost of Mystic Forge Stones.

The cell comment on A24 does say “Mystic Forge Stones not included.”

My GW2Spidy library doesn’t support fetching the gem prices yet, or I would have included the gold->gem cost for mystic forge stones. I added the cash->gem price in the meantime.

When I was looking at the spreadsheet last night, I noticed I forgot that Mystic salvage kits cost 3 stones again (I always forget that for some reason) and fixed it. While before I figured it was totally feasible to get 150+ stones for free and just use mystic kits, It didn’t really occur to me to update it after fixing the error made it go over 500, so I added an entry for Master Salvage Kits just now.

http://www.gw2spidy.com/api/v0.9/json/gem-price
example output:
{"result":{"gem_to_gold":84200,"gold_to_gem":116600}}

or: http://www.gw2spidy.com/api/v0.9/csv/gem-price
example output:
gem_to_gold,gold_to_gem
84200,116600

;)

Mystic.5934:

http://www.gw2spidy.com/api/v0.9/json/gem-price

Yes, I know. What I mean is my GW2Spidy library for Google Sheets only supports fetching item data from the item data facility at the moment. Gem information is “Coming Soon™”

Since my Luck spreadsheet seems to be popular, I’ve added a bunch of new information to it.

Could someone explain to me how to use the salvage calculator? I’m not sure what does the whole one, armor,chest columns mean.

Also, which salvage kit should I be using?

Thank You

I uploaded a couple more sheets to sate my hunger for numbers!

My Asset Tracker and the Dungeon Skins Checklist are now up! Check the first post for more details.

I’m working on a couple more, but I need to do some more research to work out some bugs, so I’ll probably have them up in another couple days.

Rumrum.1704:

Could someone explain to me how to use the salvage calculator? I’m not sure what does the whole one, armor,chest columns mean.

Also, which salvage kit should I be using?

Hover over cells with little triangles in the upper-right corner to see notes that explain what things do.

Salvage Calculator:

• I added some extra, more-specific notes to clarify possible confusion about the difference between “Armor” and “Chest”.
• The default salvage kit has been set to 3.52, which is equivalent to the Basic Salvage Kit.