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.
I should've thanked you earlier, but I simply forgot it because of all the gold I was making!
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.
Seems like something changed with how that page works though. See: http://consortium.stormspire.net/off...html#post43708
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"
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.
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?
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.
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 126.96.36.199. Step Guide on how to do this for dummies ?