Guild Wars Forums - GW Guru
 
 

Go Back   Guild Wars Forums - GW Guru > The Inner Circle > Community Works

Notices

Reply
 
Thread Tools Display Modes
Old Jul 20, 2011, 08:33 AM // 08:33   #1
Pre-Searing Cadet
 
Join Date: Jul 2011
Guild: CoP
Profession: D/Mo
Advertisement

Disable Ads
Default Un-official Material and Armor spreadsheet FINAL

Hi guys,

I've made this spreadsheet and I wanted to share it with you all

What is it?
A sheet to easily calculate materials cost, cost of armors (nice for filling spots in HoM) for all professions and cost of making artisan crafts.
Every price is based on an evaluation of prices in the current market, so they can be off but will usually give an idea of the price give or take.

What do I do?
Download the version you want, the normal sheet (NPA) isn't that big (515 kb) but will not have pictures of every armor like the other (PA) which is bigger (270 mb).
Open the sheet and jump into the profession you would like to view the prices of, or open up the Materials pane to look at the different material prices or artisan craft prices.

How do I update the material prices?
The sheet will automatically update every time you open it (you might have to accept the connection every time, unless you change your preferences) with the prices of every material. I will try to make updates to the prices every week or so, but you can still enter your own prices if you want, these will reset upon re-opening the sheet though.

Updates to the material prices does not require you to download again.

I found an error!
Great! I don't like errors! Send me a mail or contact me in-game. Character names is in the sheet in 'about' pane, and will be updated if I create new alts (yes, also automaticaly!).

New versions?
If I release a new version, it will say so in the 'changelog' pane, as well as in the 'about'. The version will then no longer match the downloaded sheet (look at the file name at the top of excel to see if the versions are the same)

If there is a new version, it is because something new have been added or some bug have been fixed, and a new download will be required.

I have comments or ideas!
Great! Let me hear them, send me a mail or contact me in-game. Character names is in the sheet in 'about' pane, and will be updated if I create new alts (yes, also automaticaly!).

REQUIRES A PROGRAM THAT CAN VIEW EXCEL 2007 PROJECTS
Updated 18-07-2011

Un-official Material and Armor spreadsheet NP - No Armor Pictures - 515 KB (for low connections)
Un-official Material and Armor spreadsheet No Pictures - Auto update

Un-official Material and Armor spreadsheet P - Armor Pictures - 270 MB (for high connections)
Un-official Material and Armor spreadsheet Pictures - Auto update

Enjoy

Kahled Quazim
Kahled Quazim is offline   Reply With Quote
Old Jul 20, 2011, 09:52 AM // 09:52   #2
Furnace Stoker
 
Mordiego's Avatar
 
Join Date: Sep 2007
Location: Poznań, UTC+1
Guild: We Are From Poland [Pol]
Profession: N/A
Default

Quote:
Originally Posted by Kahled Quazim View Post
... The sheet will automatically update every time you open it (you might have to accept the connection every time...
NTY, sounds too suspicious IMO
Mordiego is offline   Reply With Quote
Old Jul 20, 2011, 11:58 AM // 11:58   #3
Desert Nomad
 
Lord Dagon's Avatar
 
Join Date: Jul 2009
Location: Inside the Oblivion Gate
Guild: The Imperial Guards of Istan[TIGE]
Profession: E/Me
Default

i agree with Mordiego.. it sounds really pretty shady. I think i'll stick to calcing out armor cost the safe old fashion way
Lord Dagon is offline   Reply With Quote
Old Jul 20, 2011, 12:38 PM // 12:38   #4
Desert Nomad
 
Bristlebane's Avatar
 
Join Date: Jan 2008
Profession: Mo/
Default

Although it's healthy to be a bit sceptical in cases like this,
I double checked the excel files and can say that they appear genuine.
They don't contain macros, they only contain a data connection to a csv file.
In other words it's Excel that updates it automatically, not some macro with some hidden agendas. It's safe to say it won't harm your computer in anyway.

It will overwrite the data in the spreadsheet though.

For those still sceptical, Excel will block any connection by default and you could just edit some fields manually if you prefer. Just know those fields will be overwritten if you ever decide to allow connection.

On a more personal note,
thanks for sharing but personally I won't use it as I could just do this manually. It relies on you updating it unless you have a 24/7 bot that updates the csv files from ingame.

Last edited by Bristlebane; Jul 20, 2011 at 12:42 PM // 12:42..
Bristlebane is offline   Reply With Quote
Old Jul 20, 2011, 12:55 PM // 12:55   #5
Pre-Searing Cadet
 
Join Date: Jul 2011
Guild: CoP
Profession: D/Mo
Default

Thanks for your comments. I can assure you, there is nothing dodgy about this!
I find it useful, my alliance finds it useful, and someone here might as well

@Bristlebane
Since is a reference, and you can change the numbers in the different materials, it should be just as valid as doing it manually.

As the prices change all the time, and yes I don't have 24/7 to update, the prices will be a bit off, but usually they are kept within the frame.

Also, using it to gain some kind of insight as to what armor to go for first, and where to get it is never a waste of 515kb download time
Kahled Quazim is offline   Reply With Quote
Reply

Share This Forum!  
 
 
           

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:41 PM // 13:41.


Powered by: vBulletin
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd.
jQuery(document).ready(checkAds()); function checkAds(){if (document.getElementById('adsense')!=undefined){document.write("_gaq.push(['_trackEvent', 'Adblock', 'Unblocked', 'false',,true]);");}else{document.write("