Saturday, February 16, 2013

Tallying Totals Tell True Tale

I said it before and I'll say it again:  You know you're addicted to gold making when you're working with spreadsheets and crunching numbers externally.  Is there a cure for us??  Gold Anonymous?

Hi, my name is Profitz and I'm a goldaholic.  *audience chimes in*  Hi Profitz!

What a week it has been.  I've learned a lot on what days seem to be selling the most and what items continue to turn profits over others.  I've also looked a little closer to my search lists within Auctioneer and weeded out any/all craftables in the 'Green Groups' I buy from.  The market on these items seems to be dipping pretty low and not worth the storage space or listing fees in my opinion.  Don't get me wrong here, there is some profit that can be made off of these but not a lot.  Maybe at most, you can double your gold on each purchase if they sell the first time they are listed.  (example:  You buy a pair of gloves for 25 gold and you flip them for 50 gold.  After the AH fees, maybe you walk away with 21-22g in profit?  I like buying at 25gold and flipping for 250-285g sometimes well over 300g.  Either way will work it just might take more time to build up your gold stash.)

Anyways, I created this spreadsheet (thinks back to gold anonymous and sitting in a circle with a bunch of unshaven gnomes, fat elves (I think some of them must be fat no?), hairy humans, and smelly dwarves) which keeps track of my starting gold total at the beginning of the day and where I landed at the end of the day when I close my books (sounds all official...yes I close my books at 11PM each night).  Right now this process is all manual but I do plan on coming up with some customized module for calculating this with enough granularity where I can make some pretty pie charts, bar graphs and even dazzling presentation slides. *arches one eye brow*

Chart # 1 - Daily Total Profits
My total gold sales for this week in closing brought me over the 206,000 marker up from starting at 147,000 at the beginning of the week on Sunday.  The chart shows Sunday thru Saturday (1 - 7).  As you can see in Chart #1 - I've made an average of about 12,338g per day with the lowest gold earning day being Thursday (day 5) (I'm probably thinking because people are tied up with raiding and not leveling alts?)  The highest earning days seem to be Monday, Friday and Saturday.  I'll be tracking this over time to see if this is truly the case as more weeks are calculated.  This was my first week with this spreadsheet.  Does that mean I'm new to the Gold Anonymous club too you ask?  Probably true.  Don't kick me out just yet...

I'm very pleased with how much I've been able to learn over the past several weeks to make this amount of gold.  Albeit, it's not a huge amount compared to some, but this is the most gold I've ever owned folks.  Yes...truly amazing to some of you probably but hey, you have to start somewhere right?  With little to no effort, all of this was made.  This week alone I've brought in close to 90k in one week.  Have I said I'm addicted yet?  ;)

The point of all of this is, that if a new person like me to the gold making underworld can do this, so can all of you.  It does take a little configuration and setup but afterwards, its smooth sailing and just rinse-n-repeat through a typical process.  The rest is just watching the digits increase.

I hope this post finds you all well and counting your coins like kings and queens of Azeroth.

Be well.


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.