Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Page 1 of 3 123 Last
Results 1 to 10 of 23
  1. #1
    EU-Ambossar
    Entrepreneur
    Lardo's Avatar
    Posts
    24
    Reputation
    2
    Tagged in
    5 Posts
    Add to this user's reputation

    Lightbulb "ASMoPS" - A Simple Mist of Pandaria Spreadsheet

    Hi everyone

    I like to share my new spreadsheet. Most likely I will try to keep it updated through this expansion.

    What can you expect?

    • - Crafting Profit Analysis
    • - Groceries Profit Analysis
    • - Enchanting Mats Profit Analysis
    • - Darkmoon Cards Profit Analysis
    • - Once setup is done you just have to click "data refresh" for an up to date AH input


    What do you need?

    • - A TUJ Account
    • - Microsoft Excel
    • - A little bit experience


    Attached you will find the spreadsheet and a few "how to setup" screenshots. Hope you like it.

    Have a nice day.

    C u, Lardo

    Update 01/02/2013 v2
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Lardo; February 1st, 2013 at 05:30 AM.

  2. #2
    EU-Draenor(H)
    Entrepreneur
    Jonsbak's Avatar
    Posts
    15
    Reputation
    0
    Tagged in
    4 Posts
    Add to this user's reputation
    Great spreadsheet, worked for me. Even though my Excel is not a fan of importing data. I like the tab setup and how you look at the things. There's just one question in my mind: when you talk about the cost of a bundle of groceries witht the herbs. How many are we talking? I tried to calculate it and I was around 225 GTL.

    Anyways, great spreadsheet + rep.

  3. #3
    EU-Ambossar
    Entrepreneur
    Lardo's Avatar
    Posts
    24
    Reputation
    2
    Tagged in
    5 Posts
    Add to this user's reputation
    Quote Originally Posted by Jonsbak View Post
    Great spreadsheet, worked for me. Even though my Excel is not a fan of importing data. I like the tab setup and how you look at the things. There's just one question in my mind: when you talk about the cost of a bundle of groceries witht the herbs. How many are we talking? I tried to calculate it and I was around 225 GTL.

    Anyways, great spreadsheet + rep.
    Heya. Thank you.
    Maybe I do not understand the question right but I will try to give an answer. Calculation is pretty much like "column G x column B".

  4. #4
    US-Azshara(H&A)
    Ethereal Contributor
    jimmyolsenblues's Avatar
    Posts
    1,378
    Reputation
    31
    Tagged in
    473 Posts
    Add to this user's reputation
    I hate to complain. Please could you add screen shots in english. Thank you.
    @jimmyolsenblues on twitter https://twitter.com/#!/jimmyolsenblues

  5. #5
    EU-Ambossar
    Entrepreneur
    Lardo's Avatar
    Posts
    24
    Reputation
    2
    Tagged in
    5 Posts
    Add to this user's reputation
    Quote Originally Posted by jimmyolsenblues View Post
    I hate to complain. Please could you add screen shots in english. Thank you.
    Hmm I will give it a try. But therefor I need to get my hands on an English excel.

  6. #6
    US-Dreadmaul(H)
    Ethereal Contributor
    j311yf1sh's Avatar
    Posts
    196
    Reputation
    34
    Tagged in
    78 Posts
    Add to this user's reputation
    + rep, great looking spreadsheet.

    how ever, you uploaded it with your auction data installed which makes it a little hard to import my own.
    <J311yf1sh> im gonna stare really hard at it and hope it works
    <J311yf1sh> thats how you program correct?
    Enchanting Shuffler addon - Creator of the enchanting shuffler addon
    Twitter - my twitter
    Blog - my Blog
    Please give reputation and feedback if i have helped you by clicking the star at the bottom left of this post.

  7. #7
    EU-Ambossar
    Entrepreneur
    Lardo's Avatar
    Posts
    24
    Reputation
    2
    Tagged in
    5 Posts
    Add to this user's reputation
    Quote Originally Posted by j311yf1sh View Post
    + rep, great looking spreadsheet.

    how ever, you uploaded it with your auction data installed which makes it a little hard to import my own.
    Thank you. Is it not possible to delete the "data"? It should be possible to delete the whole sheet and import your data through your own TUJ-Webquery.

  8. #8
    US-Azshara(H&A)
    Ethereal Contributor
    jimmyolsenblues's Avatar
    Posts
    1,378
    Reputation
    31
    Tagged in
    473 Posts
    Add to this user's reputation
    Also there is a password to unprotect sheet , is that on purpose?
    @jimmyolsenblues on twitter https://twitter.com/#!/jimmyolsenblues

  9. #9
    EU-Ambossar
    Entrepreneur
    Lardo's Avatar
    Posts
    24
    Reputation
    2
    Tagged in
    5 Posts
    Add to this user's reputation
    Quote Originally Posted by jimmyolsenblues View Post
    Also there is a password to unprotect sheet , is that on purpose?
    yes it is. atm you can only edit the yellow marked cells.
    however there will be a unprotected version available as soon as I think there is a need for it.

  10. #10
    Entrepreneur
    FallNAngel's Avatar
    Posts
    30
    Reputation
    1
    Tagged in
    10 Posts
    Add to this user's reputation
    Looking at least at the 'Crafting' tab, the crafting costs are noticeably off at least for Alchemy. You're using the Crystal Vial auction house price when it's a vendor material. Because the Vial has a market price of 21g, it's throwing the potion pricing off.

    I'd fix it on my excel sheet but... yeah...

 

 
Page 1 of 3 123 Last

Similar Threads

  1. [General] Cross Realm AH and "power seller" Faid gets noticed on Legendary
    By Chicky in forum Auction House Discussion
    Replies: 33
    Last Post: October 18th, 2012, 04:32 PM
  2. Mist Of Pandaria Pre-Emptive Strike
    By HasNoHeart in forum General Discussion
    Replies: 32
    Last Post: April 24th, 2012, 11:47 AM
  3. Bug Question: "Per Auction" and "Post Cap" not functioning correctly
    By kyledgebhart in forum Official TradeSkillMaster Forum
    Replies: 1
    Last Post: December 26th, 2011, 09:10 PM
  4. Replies: 9
    Last Post: July 27th, 2011, 03:23 PM
  5. Suggestion: "Save Setting" button near new "show sales" checkbox.
    By fluxdada in forum Official Forum of The Undermine Journal
    Replies: 1
    Last Post: June 13th, 2011, 02:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •