Guild Wars 2

Synopses

We all know the story behind legendary weapons. We’re aware of how difficult and challenging they are, and just how many materials and steps are required to make them. So, what if it was easier? What if you could just plug in what you have, and see what you have left to collect?

I’ve created an Excel calculator that does just that. Currently, it just works for Sunrise, but I intend to expand to every single legendary very soon, after collecting some feedback from all of you.

What This Calculator Does

• Provides a detailed list of the ingredients and recipes for every legendary weapon component and sub-component
• Provides an interface for inputting your current resource pool to calculate remaining resources
• Provides individual and total costs, separated into various currencies
• Provides accurate, up-to-date costs of each item, updated on spreadsheet load (not available in Feedback Version)

How This Calculator Works

It couldn’t be simpler. You’ll see several columns. In the Number Owned (WHITE) column, just enter the number of resources you currently own; the calculator will do the rest! All your information will be available in the right-most collumn.

Planned Updates

• Implement live updating prices, powered by www.GW2Spidy.com
• Add every legendary as a separate sheet on the same file
• Add a cover sheet with a quick reference of legendary costs for side-by-side comparisons
• Add a “percent complete” tab (NOTE: Inaccurate due to quantities and ease of item obtainment; how should I weight each item?)
• Hide unnecessary columns from view to simplify the calculator.

What I Need From You

• Feedback – Tell me what features you like and hate, what should be reorganized, and if anything should be moved around.
• Ideas – Any new features you would like to see added?
• Support – Any words of encouragement to keep me going. I initially planned this as a paid tool for fan sites, but I’ve decided to go public with this knowledge. Show me I did the right thing with an encouraging post!

Download Link
Currently I am only able to provide a Microsoft Excel spreadsheet file. In future versions I plan to make this more universally accessible for those of you on macs or without the software. This file CAN be opened in Google Docs, although it cannot be edited there.

http://www.filefactory.com/file/5hw10u1eql4f/n/SunriseCalculatorBETA_2_xlsx

Donations

Donations are by no means necessary. I am providing this service free of charge to better support the Guild Wars 2 community at large. If you would like to donate some gold to show your support, it would be greatly appreciated. You can send me a mail at

Theta Zero.9023

Any amount is welcome, and I appreciate all your support. Here’s to getting our legendary weapons together!

UPDATES
10/11/2012 – Duplicate post made in the Crafting Forums due to lack of responses here.
10/10/2012 – New Download Host selected temporarily, until I can figure out how to enable downloads directly from Google Docs.

101 views and no posts….Am I doing something wrong? These forums seem dead compared to the ones Im used to

No offense intended as you clearly are just trying to help the community but as long as you have a list of things you need, its not that big of a deal to just keep track of what you have left to do.

If you implement up to date pricing so that you dont have to calculate your remaining cost that is one thing, but right now its just a glorified list.