Guild Wars Forums - GW Guru
 
 

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

Notices

Reply
 
Thread Tools Display Modes
Old Mar 07, 2008, 08:28 PM // 20:28   #1
Krytan Explorer
 
deadman_uk's Avatar
 
Join Date: Feb 2007
Location: United Kingdom
Guild: KOD
Profession: Mo/E
Advertisement

Disable Ads
Thumbs up Guild Wars Material Spreadsheet (Speeding up the material selling process)

Hi,

I do a lot of PVE so I often get salvage items which I salvage for common and rare materials. These materials build up in my storage over time until eventually I have more than the material tab can hold (250), because of this, I have to use precious storage space, storing hundreds of materials.

When I can be bothered, I advertise that I have materials for sale and people PM me asking things like "How much would it cost for 210 Tanned Hide Squares, 50 Iron Ingots and 27 Bolts of Silk?". I first have to see how much the rare and common Material Traders sell these materials for (so I can offer the customer a fair price. Then I have to minimize Guild Wars and use the Windows calculator to work out how much all this will cost the customer. I hated this process because it wastes not only my time, but the customers time too. I designed a small, simple spreadsheet to aid me in selling materials, It does most of the work for me.

Guild Wars Material Sheet

Guild Wars Material Sheet (If you don't have the latest version of Microsoft Excel)

I don't know if anyone cares, but it's useful to me so I thought I would share it with you all.
deadman_uk is offline   Reply With Quote
Old Mar 07, 2008, 10:19 PM // 22:19   #2
Community Works Moderator
 
thunderai's Avatar
 
Join Date: Jan 2007
Location: USA
Guild: Centre of the Aerodrome
Profession: R/Mo
Default

Not sure how I would use this tool, but someone may find it useful.
__________________
Vist my user page at the offical wiki!
thunderai is offline   Reply With Quote
Old Mar 07, 2008, 10:33 PM // 22:33   #3
Forge Runner
 
jonnieboi05's Avatar
 
Join Date: Mar 2006
Location: Mableton, Georgia
Guild: Guild Ancestors Reunited [ギルド]
Default

well tbh i don't bother with materials. once i hit a stack of something i merc it (not vend, MERC). pennies and dimes are of no consequence to me and i'd rather go after the bigger sells. anyways, if you have it, use a cell phone calculator. it'll take you at most 10 seconds to access it and get the price.
jonnieboi05 is offline   Reply With Quote
Old Mar 07, 2008, 10:37 PM // 22:37   #4
Krytan Explorer
 
deadman_uk's Avatar
 
Join Date: Feb 2007
Location: United Kingdom
Guild: KOD
Profession: Mo/E
Default

Quote:
Originally Posted by JonnieBoi05
well tbh i don't bother with materials. once i hit a stack of something i merc it (not vend, MERC). pennies and dimes are of no consequence to me and i'd rather go after the bigger sells. anyways, if you have it, use a cell phone calculator. it'll take you at most 10 seconds to access it and get the price.
But if you have a person who wants to buy multiple materials from you, you have to manually add the prices up with a calculator, remember the prices for each material, then add all those up to come to a total. Also you have to visit the material trader and do calculations there too.

I don't know about anyone else, but this spreadsheet saves me alot of time.
deadman_uk 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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selling Mods, Insc. And Material For Cheap xerios Sell 2 Aug 10, 2007 12:14 PM // 12:14
The Shadow Sardelac Sanitarium 11 Feb 05, 2007 03:00 AM // 03:00
Material / Rare Material Trader Issue Mike Legend Sardelac Sanitarium 5 Aug 25, 2005 04:05 PM // 16:05
Ba Ne Sardelac Sanitarium 0 Jul 13, 2005 02:32 AM // 02:32
{Selling}Rare Bow, Axe, Material XBloodHoundX Sell 39 Jun 25, 2005 11:45 AM // 11:45


All times are GMT. The time now is 03:24 PM // 15:24.


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("