How to use The GOLD CHEAT SHEET ;)

Great job, thank you! If i have different stats, what i have to modify?

Can you modify the resourcefulness/multi craft stats? i have 21/23 in blacksmithing and not 19/22

have you looked into doing anything for Thaumaturgy?

problem with exporting prices is the undercutters who put stuff much cheaper and in low numbers to bait tsm users to post low. The actual prices will be higher leading to wrong calculations

Hey mate, what if someone is baiting the price for something, how do we manually change that value to reflect the correct cost of an item? i.e bismuth r3 is 160g but there is 1 on the Ah for 105g.

GREAT SHEET!

im awful at Excel and i was wondering if the next update will have rank 3 alloys info since I am unable to figure out this big brain stuff on my own =D

fantastic sheet. love the export pricing and formulas.

Dude! you're the best!! will you be able to make a tab for engineering, i know it's not af profitalbe as the others, but it would be cool to have it

What a hero! This sheet was already great, but with the import option it's amazing! Any chance of adding a "meta" shopping list/import that will fill all the pages?

Very cool! May give this a try. Just started to get into wow/professions. Very interesting systems.

i am just curious why not use craftsim for this? feels like it does exactly the same.

You could make an app script that gives a menu option to reset the formulas on all the cells. Also does your price list import account for "bait" auctions where people post 1-2 at a less than half price to get other people to post lower so they can snipe?

cooking profits are messed up, probably using wrong column, J instead of L

Hey, awesome work, thank you very much !
Do you have any clue on why the sheet doesn't work with french auctionnator import string ? The number format is the same but i keep getting the "input must be a number" error on the cost and profit cases.
I mean [ 10999500,"Core Alloy Tier 3",70,"",3303 ] and [ 10999500,"Alliage de noyau Niveau 3",70,"",3033 ] are the same

Great work!

It seems the profit column is not updating correctly; function wow is missing. Any ideas on that?

Jus wanted to say you deserve all the awesome things. All. Of. Them!!!

I have no idea what I am doing wrong, but i just tried this with an extra 5% more stats then the sheet mentions and the numbers where not even close even after updating all the prices via auctinator.

I don't get how this is useful without an "enter your knowledge points distribution" section so that it knows that i'm 40/40 gem finding and 20/20 emeralds or whatever. that would impact things mightily.

thx a lot for your help! are you planning on adding ink crafting?

You could always change the formula on the crafts to take the lower of the two values, either AH price or your crafting cost. That way you don't have to edit the formulas each time.

You’ll only use this if you like to make gold! If you hate gold don’t use this

When importing the prices into the sheet, what about the prices of certain items that are being hard undercut, for example the ppl that list 1x bismuth for 5 gold

good update time=GPH

Thank you very much!

Can't believe I'm here so early! Great sheet, thank you!