Register
Page 23 of 39 First ... 13212223242533 ... Last
Results 221 to 230 of 382
  1. #221
    Quote Originally Posted by Keldara View Post
    Just replace the VLOOKUP stuff and replace it with your gold value. That's what I do. I do also keep the original VLOOKUP data in the margin/nearby so I can keep an eye on that as well.
    Thanks alot , thought that would mess up the math

  2. #222
    Thanks so much for this amazing time saver! I do have one small question though. The shuffler only gives me recommendations for uncommon gems/ench and herbs. Is it supposed to leave Rare/Ore/Misc blank as far as recommendations go? Just want to make sure I don't make any simple mistakes.
    Last edited by DeftlyMoving; December 11th, 2011 at 05:39 PM.

  3. #223
    harleqin's Avatar
    Posts
    33
    Reputation
    0
    Tagged in
    2 Posts
    Add to this user's reputation
    I should've thanked you earlier, but I simply forgot it because of all the gold I was making!

    +rep

  4. #224
    id rather be stapled as dumb and get this sheet to work than be silent and not getting it to work, as said befor im having great trubble importing the Undermines XML to the sheat, ive read something a post about deleting a US / EU coloum, so my questions follow

    1, the EU / US column to be deleted, is it in the sheet or the XML file? if the answer is the last how do i open and modify a XML file?
    2, is there anyone that might want to take some time and get in contact with me to help me out?
    or perhaps a Guide on Xml usage and importing / exporting data.
    would be most greatfull // Thanks in advance, Exeon
    Last edited by Exeon; December 11th, 2011 at 10:21 PM.

  5. #225
    Sapu94's Avatar
    Posts
    7,045
    Reputation
    343
    Blog Entries
    25
    Tagged in
    1916 Posts
    Add to this user's reputation
    Quote Originally Posted by turbare View Post
    Whenever I try to import removed using the "from Web" option, it prompts me to save/open the XML file instead of adding it to the excel.
    I'm trying to configure it to auto sync with TUJ, on Office2010.

    Am I getting something wrong?
    First of all, you shouldn't share your API link if you don't want other people using up your 10 daily downloads

    Seems like something changed with how that page works though. See: http://consortium.stormspire.net/off...html#post43708


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street."

  6. #226
    Ive erm, found a typo on the spreadsheet. Under the transmute inferno ruby, its got carlelian instead of carnelian. Excellent spreadsheet though, having a play around with it now, having only just got the full copy of excel
    The Shaman Formerly Known As "Shamacazzy"
    Blog

  7. #227
    Sterling's Avatar
    Posts
    3,820
    Reputation
    373
    Blog Entries
    1
    Tagged in
    2111 Posts
    Add to this user's reputation
    Quote Originally Posted by Exeon View Post
    id rather be stapled as dumb and get this sheet to work than be silent and not getting it to work, as said befor im having great trubble importing the Undermines XML to the sheat, ive read something a post about deleting a US / EU coloum, so my questions follow

    1, the EU / US column to be deleted, is it in the sheet or the XML file? if the answer is the last how do i open and modify a XML file?
    2, is there anyone that might want to take some time and get in contact with me to help me out?
    or perhaps a Guide on Xml usage and importing / exporting data.
    would be most greatfull // Thanks in advance, Exeon
    What version of excel are you using? No need to delete columns anymore, that was a temporary fix required after a patch.

    It's best to keep your troubleshooting within the public forum so that other people may fix their problems in the future.
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Legion Mastery Series: Sniper | Cross-Faction Trading | Cooking | Blacksmithing, Leatherworking, Tailoring Master
    Old World: Smelting | Garrisons Part 1 - Buildings | Garrisons Part 2 - Followers | Profitable Alchemy Crafts
    Archived: Enchanting | Jewelcrafting | Toy Box Guide | Blacksmithing Transmog Guide
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  8. #228
    Corndude's Avatar
    Posts
    40
    Reputation
    0
    Tagged in
    13 Posts
    Add to this user's reputation
    I've been using the spreadsheet with great success so far. But now i have billions of dust but not enough celestial essences to make anything of them.

    So what do you guys do here? Buy essences from ah?

    Which scrolls do you craft in general?
    On my server
    Gloves - mastery
    Boots - tempo
    chest - +15
    sell pretty good, what else can you recommend?

  9. #229
    ive managed to work it out, dident see the tabs.
    i thank you for a great gold making tool
    Last edited by Exeon; December 15th, 2011 at 03:53 AM.

  10. #230
    dernir's Avatar
    Posts
    12
    Reputation
    0
    Tagged in
    5 Posts
    Add to this user's reputation
    Basic Instructions

    1. You can fill out the beige boxes with your server prices manually, or have it imported automatically. To have it done automatically, go to The Undermine Journal and create an account. The site uses OpenID, so don't worry about getting hacked or whatever.
    No Problems there

    2. Click on your server, and under "Site" click "XML API". Scroll to the bottom where it says "Market Data XML". Paste this address into your browser and download the XML file to your desktop.
    Again No problems

    3. Switch back to the spreadsheet and go under the "TUJ data" tab. With the top left cell selected, go under "Data" -> "Import XML". Select the file you saved on your desktop. This step will differ based on the version of excel you are using. All of the pricing should now be filled in.

    Here things get hairy
    I'm using Excel 2007. Cannot find the "TUJ Data" tab in the spreadsheet. And im not 100% sure what is being referred to.
    If I import ( not knowing wich part / column of the spreadsheet shouold be selected it turns everything upside down & makes a big mess of things.
    Any chance I could get a 1.2.3.4. Step Guide on how to do this for dummies ?