Register
Page 2 of 3 First 123 Last
Results 11 to 20 of 30
  1. #11
    Sterling's Avatar
    Posts
    3,855
    Reputation
    377
    Blog Entries
    1
    Tagged in
    2131 Posts
    Add to this user's reputation
    Quote Originally Posted by Acry View Post
    Doesn't work for me in Excel 2007. I just get #REF for every box after importing into the tuj tab(tried 3x in cell 1 to make sure)

    Transmutation quest was changed to Truegold and some other stuff as well.
    That's weird, seems to be working fine for me. I uploaded it again, see if anything changes.
    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.

  2. #12
    Thanks a lot for this! A lot of hard work and it is appreciated. Can I ask why I am not seeing Engineering on this? I am just trying to understand what are the limitation that engineering might have.

    Thanks!

  3. #13
    Sterling's Avatar
    Posts
    3,855
    Reputation
    377
    Blog Entries
    1
    Tagged in
    2131 Posts
    Add to this user's reputation
    Quote Originally Posted by farquaon View Post
    Thanks a lot for this! A lot of hard work and it is appreciated. Can I ask why I am not seeing Engineering on this? I am just trying to understand what are the limitation that engineering might have.

    Thanks!
    As per Namssob's experience, Engineering (and other professions missing from the spreadsheet) is not worth it. Partly due to lack of sales, and partly due to the complicated nature of leveling.
    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.

  4. #14
    Acry's Avatar
    Posts
    1,327
    Reputation
    67
    Blog Entries
    3
    Tagged in
    618 Posts
    Add to this user's reputation
    Works now, thanks

    Also, not sure if you missed what I said but Alchemy Spec was changed to Truegold + some other stuff in 4.3
    It is is no longer
    Accounts for 4 Primal Mights and Recipe: Transmute Primal Might

  5. #15
    Namssob's Avatar
    Posts
    1,485
    Reputation
    123
    Blog Entries
    1
    Tagged in
    454 Posts
    Add to this user's reputation
    OK, just got my laptop back, rebuilt, with Windows 7, so I should have more time (and the right tools) to take a closer look at this. But I do like what I see!
    How To: Create And Sell Profession Kits ---- MoP Shuffle Flowchart ---- Article: A Case For Dual Gathering
    "Never underestimate the sheer amount of derp the majority of WOW's playerbase possesses." -- Belrandir
    "They could have offered me free ERPing in Goldshire with real women over Skype for the next year and I would have passed." -- Zerohour
    "Scissors are OP. Rock is fine." --Paper

  6. #16
    While I am unsure whether this has been mentioned in the original Namssob thread, I was wondering what the impact would be of preprocessing the kits. I feel that, especially the tailoring kit, will be a lot easier to digest if all the raw cloth has been turned into bolts. I realize that making bolts accounts for skillups with every new material type, but one could compensate for this with additional mats. 333 slots for materials is crazy and would take up more than 3 guild tabs by itself.

    This is mainly speculative on my side, as this SUPER helpful spreadsheet (thanks, by the way) shows me that a tailoring kit wouldn't be smart at the moment because of high material costs.


    Another concern I have is that people will not want to add a character to a guild for this. I thought that mailing the items to a character, in the correct order, with an overview of what they would have to make, could be an alternative, but I believe that players would have a hard time trusting you enough to pay up front for this. C.O.D. is an option, but you would have to calculate the value of the parts that you're sending, so that the buyer doesn't simply pay for the parts that are C.O.D.'ed at a too low value after taking the mean of the total.

    All in all, food for thought, and something I am considering starting once I get my second account going (10 character minimum to a server, sheez)

    EDIT: got a brainwave on the throne; what about cooking and first aid?
    Last edited by Cerice; February 2nd, 2012 at 02:56 PM.

  7. #17
    This is fantastic! Just one question, it is possible to add enchanting in the worksheet?

  8. #18
    Zimmah's Avatar
    Posts
    13
    Reputation
    0
    Tagged in
    10 Posts
    Add to this user's reputation
    I'm using it with google docs atm because i don't have MS office installed on my computer yet. (will do that ASAP) so i have to input everyting manually for now.

    so far, i have a few small points of critic.

    1) 2 adamantite ores are needed to smelt 1 bar. therefore, in the kit prices tab, field C40 should read: "=IF(D40>(D41*2);0;10)" and field C41 should read =20-(C40*2) to account for the double ores needed.

    2) the spreadsheet suggests to buy fractions of items sometimes, would be cleaner to make and IF, ELSE statement to round up for the single cheapest while rounding down for the second and third cheapest. For example =IF(D32>SMALL($D$32:$D$37,1),IF(D32>SMALL($D$32:$D$37,3),0,ROUNDDOWN(55/3)),ROUNDUP(55/3)) for cell C32

    3) at row 51 on the kit prices tab, row 50 is repeated.
    Don't shoot the messenger.

  9. #19
    Kaspyn's Avatar
    Posts
    155
    Reputation
    3
    Blog Entries
    2
    Tagged in
    43 Posts
    Add to this user's reputation
    I can't get this to work with Office 2010. I have just copied my data over from the Shuffling Sheet, and nothing but #REF throughout. Any ideas how to fix this?
    Don't forget to rep the folks who've helped you out by clicking on the "add reputation" button!


  10. #20
    Valdron's Avatar
    Posts
    859
    Reputation
    135
    Tagged in
    292 Posts
    Add to this user's reputation
    Quote Originally Posted by Kaspyn View Post
    I can't get this to work with Office 2010. I have just copied my data over from the Shuffling Sheet, and nothing but #REF throughout. Any ideas how to fix this?
    What do you mean by you copied it from the shuffling sheet? Are you referring to copy/pasting?

 

 

Similar Threads

  1. Profitable Leveling Guide: Blacksmithing 1-525
    By Sterling in forum Outdated Guides Archive
    Replies: 16
    Last Post: September 5th, 2012, 04:58 PM
  2. Profitable Leveling Guide: Blacksmithing 1-525
    By Sterling in forum Archive (Professions)
    Replies: 0
    Last Post: January 31st, 2011, 09:47 PM
  3. Consortium Profession Leveling Guides: Enchanting 1-425
    By Sterling in forum Outdated Guides Archive
    Replies: 13
    Last Post: November 8th, 2010, 08:51 PM