Crafting Shadowland Legendary Items for Profit
-
How can you craft Shadowlands Legendary items for profit? Do you want to
easily see which legendary base item to craft on your tailor,
leatherworker, or ...
2/04/2013
Calculate Days Needed To Reach A Gold Goal
Today's guest post was written by long-time livestream viewer Zackiz.
Almost a year ago when I started to make gold in World of Warcraft as a meta-game I was disorganized. I felt I needed some sort of spreadsheet to keep an overview of my income progress so I threw something fast together and it was a mess.
Over time I changed it and and made it better. The other day it hit me, maybe there are more folks out there who may want it to use something like this. It has helped me keep my aim straight and kept my morale up when times have been tough. It has even given me some motivation to find more ways to push the income up when it was worth it. Read on past the jump for more.
I usually watch Jim’s livestream so I sent it to him. He liked it and asked me to write up some kind of documentation and here it is.
The spreadsheet needs to be either downloaded (for use in Excel or OpenOffice) or copied (for use in Google Drive) from the File menu in order to be edited/used.
The spreadsheet is on Google Drive here: Income Days Numbered.
So, lets get started.
The Base
B1: Fill in your current goal here, in gold. It can be your overall goal or maybe a milestone you want to reach.
B2: Fill in your current total gold amount here.
B3: This is the calculated amount of gold you have left to reach your goal. This is the number used as a base for most of the spreadsheet.
The Meat
What you see next is 4 column-groups, Left-Avg Income. There are at the moment 160 days but this can be extended if you want more by using copy/paste.
The “Left” column represents the number of days left until you reach your goal. The reason I just didn't type “Days Left” is looks and space. You can change it in your copy if you want.
The “Avg Income” column represents the average income you need to earn during the corresponding number of days to reach your goal.
As an example, the red marked area in the picture below represents if your average income per day is 3049g, then it will take you 82 days to reach your goal assuming you keep the same pace.
If you are using TSM (which you should) you can see your average income for the last 7 days, 30 days and all your recorded data. Which of these you should use is up to you. I like to use the 7 days one since that one adapts faster to variations in your income. If you use the 30 days one, you will get a “smoother” number.
As you might have seen by now the 160 days not only split up into 4 column-groups, it also continues down under the first column. This is the same data as the one we have use so far but this is used for the graph on the side, which leads into....
The Graph
This graph is a visual representation of the spreadsheet. It is basically just an additional way of looking at the situation. It shows how harsh the diminishing returns are when you are trying to lessen the number of days you need, in order to reach your goal.
The X-axis is the number of days left and the Y-axis is the average income per day needed to reach you goal. As you can see, the closer in days you get to your goal, the more you need to increase your average income to cut of another day.
And that is basically it. I hope this sheet will help motivating you in your gold-making. It certainly has for me.
//Zackiz
I want to thank Zackiz for taking the time to give us more details on this spreadsheet. It really is an awesome tool.
I was able to plug in my own goal and average daily income. If I stay on track income-wise I could reach my current gold-making goal in about 16 days. Neat!
Like this post? Get even more Power Word: Gold - Purchase our 100-Page Illustrated Gold Guide, subscribe via RSS, subscribe to the Podcast via iTunes or RSS, watch our Livestreams, follow us on Twitter, Circle us on Google+, Like us on Facebook, subscribe via Youtube and join us on reddit.
Subscribe to:
Post Comments
(
Atom
)
Search This Blog
Popular Posts
-
Today I wanted to go over the basics of setting up "Shopping Lists" in the Auctionator addon. Shopping lists are a great way t...
-
With the recent news that Activision Blizzard is buying back a controlling interest from Vivendi it was also made known that the curr...
-
In this video I demonstrate how I utilize the Potion of Treasure Finding to help motivate and focus my skinning sessions. While I'm...
-
In preparation for the launch of Legion I've been working on a project to build the character I'm planning to give my free level ...
-
I decided to have some fun with the exported data you can get from the Resources > Data Export page on WoWuction ( example page ). ...
Featured Post
A Guide to Farming Instances For Mogging Items
Today's guest post was written by Ohnekase from the gold-making blog Meet Ohnekase . You can also follow them on twitter at @WowOhn...
Shop & Support Power Word: Gold
Gold-Making Blog Roll
-
-
How to clean your data for Xpac Pre-Patch Day (BfA version) - **pops into existence again** There's a new expansion, so again here's a list on how to make sure that your game will load without any conflicts of any kin...
-
Hello world! - Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
-
Follow Quin69 at Gamescon - Click the read more to view the livestream on Quin69 at Gamescon Watch live video from Quin69 on www.twitch.tv
-
2015 in absentia - I almost can't believe this is my first post in more than a year. I post glyphs just recently, and it was the first time in three months. So I thought I'...
-
Így indul 2015 - Kedves Book of Gold vásárlók/érdeklődők! A 2015. január 1-től életbe lépő rengeteg törvénymódosítás között szerepelt egy ÁFA-törvény módosítás is. Eszerin...
-
Old school potions are insane - Hey peeps! Quick update here. If you have an alchemist laying around with Potion of treasure finding (Cataclysm recipe) and potion of luck (MOP recipe) t...
-
Name the Podcast: Vote - The finalists have been chosen! Now is the time to vote!! The poll will close right before we record Episode 4! You'll be able to vote 3 separate times 1. ...
-
Late Nite With Stede Goldmaking Podcast - Episode 016 - Twitchie, the Gnome Warlock joins the show as our first Trans-Continental guest. Together with Kathroman and myself, we chat about the news, take reader q...
-
Blog Archive
-
2014
(91)
- December (15)
- November (14)
- October (3)
- August (2)
- July (9)
- June (1)
- April (6)
- March (16)
- February (15)
- January (10)
-
2013
(227)
- December (11)
- November (11)
- October (14)
- September (10)
- August (13)
- July (30)
- June (22)
- May (26)
- April (32)
- March (17)
-
February
(18)
- Speed Up Posting With Common Search Terms
- Hunter vs Pandaria! #017 Kun-Lai Summit
- Where We're Farming We Don't Need Roads
- Undies, A Rifle And My Deepdive Helmet
- Episode 054 - The Power Word: Gold Podcast
- TradeSkillMaster A Go-Go
- The Video You've All Been Waiting For
- How Adding "of the" Can Speed Things Up
- Ready To Have Your Gold-Making Ideas Published?
- Around The Faceless Merry-Go-Round
- Level 83-84 MoP Armor Sales Data and Analysis
- Gold-Making: Now With 50% More Kitty
- Power Word: Gold Turns Two Years Old Today
- Gotta Make This A Quick One Today
- Mind The Gap…In Your Posting Schedule
- Calculate Days Needed To Reach A Gold Goal
- How Much Math Could A Mathchuck Chuck
- Clearing Out The Bank
- January (23)
Pages
Topics
- 77-80
- 83-84
- Addons
- Alchemy
- Analysis
- Arbitrage
- Auctioneering
- Auctions
- Barking
- Battle Pets
- Beta
- Blacksmithing
- Blog
- Blogging
- Breaking
- Community
- Competition
- Crafting
- Cross-faction
- Diversity
- Enchanting
- Engineering
- Expansions
- Farming
- Fishing
- Flipping
- Garrisons
- Gathering
- Gems
- Gold
- Grinding
- Guest
- Guides
- Herbalism
- HowTo
- Inscription
- Jewelcrafting
- Just-In-Time
- Leatherworking
- Leveling
- Livestream
- Market
- Mining
- Mogging
- MoP
- Mounts
- Pets
- Podcasts
- Potential
- Pricing
- Prospecting
- Shuffling
- Skinning
- Speculation
- Stockpiling
- Tailoring
- Theory
- Tips
- Tools
- TradeSkillMaster
- Trends
- Tricks
- Tutorials
- Vendors
- Video
- Warlords of Draenor
I think to utilize the spreadsheet you don't want to just look at the TSM Summary for Sales as it doesn't include purchases. Your daily income will be Sales minus Purchases. ie If I have an average sales of 10k a day and spend 9k a day, the number of days to reach a million is drastically different using the two numbers. Cool little spreadsheet though!
ReplyDelete