War Within Gold Cheat Sheet Update - Prospecting/Milling/Unravelling

[@M3tur3n0x]

it doesnt work unfortunatly by me. just displays #Name? with unknown funktion "wow"

[@amandahayes660]

We've missed you!! Hope everything's good and will see u more often soon.

[@Calaxt01]

How are you getting 21% resourcefulness? I have the same spec layout as you show with the blue tool and 1 piece of blue gear (the one that has resourcefulness) and am only at 17%. Am I missing something?

[@Tripzer0]

Can you add the profit percentages to the Tailoring page? Super helpful! This sheets already made me tons this xpac. Great work!

[@kevind3656]

Do any of the auction house price sources allow you to set to 100 or 1000 quantity so that the spam low prices arent used by spreadsheets?

[@semicollin23]

Unfortunately not. I wish they did

[@bugs4life83]

Hi, in the inscription sheet, cell C8 has a manual value instead formula

[@atherasrennanth2001]

great job brooo thanks

[@Thomaz1123]

The best, ty! :)

[@psychodelicrange6383]

Will you be willing to share how do you make the sheet what is the logic behind it ? Would love to watch that kind of a video even tho it will probably be longer

[@jasonivey5438]

I was hoping to ask a couple questions about the sheet functionality on Discord, but the link says the invite is "invalid". Also, I do not use Google Sheets. So, I exported this as an Excel workbook, and it does not work. When Importing the results from the Shopping list export, it will not populate the fields as you have shown in the video. Keeps telling me that the formulas contain unknown text; what ever that means. I was hoping you might have an easy fix for using this in Excel.

[@semicollin23]

I do not have a simple solution for Excel unfortunately. You would have to do some research to find the functions in Excel that match what the functions I have in google docs is. For example, =XLOOKUP probably doesnt exist in Excel. Also, the google doc has a script to convert values to gold and silver, so that could also be causing issue if you see #NAME anywhere. There are hidden columns the script uses to pull the values from, you could just unhide those columns.

[@gprimeca]

My chair is uncomfortable

[@semicollin23]

same bro

[@josesalamanca5140]

Ty so much

[@Gregatron13]

What prospecting changes?

[@EVAzeroum]

Have the same stats and knowlegeon prospecting but still losing money, i need to do the 2000 crafts to make the profit?

[@EVAzeroum]

Need to get JC tô lvl 100 and have ALL 3 BLUE tools? I only have the 2 that gives resourcefulness

[@Alex-je8ei]

I am confused are we suppose to put our numbers in because craftsim is telling i am still losing profit?

[@tremas3329]

You have to be careful because of the auction house baiters. People putting one of an item in at a much lower price than the rest of that item to get people to post at the lower price so they can buy them out and repost. It's very scummy and can throw any type of calculation like this off by a wide margin. Always double check the prices of the next several entries rather than just the first and manually enter them the price in the calculator if its far off. Likewise Craftsim's numbers can be way off because it isnt getting real time updates, its just a snapshot of the prices from whenever it last updated, and depending on what you are setting its source as, could be minutes or hours old.

[@kukabay1]

Thanks for the video.That's really helpful. Is it possible to add Alchemy/Thaumaturgy to your list? Because this is one of the best profit professions. + profit percentages on every page would be really great.

[@semicollin23]

Thank you! And yeah I am working towards getting thaumaturgy added

[@CreationForce]

Could you just help me out with your spreadsheet please, so for instance im checking disenchanting. It tells me that ill make profit with making my own pioneer's cloth cuffs. However i haven't given it any data to get the current price of them on the auction house, am i missing another area i need to post another shopping list to give it prices

[@semicollin23]

For disenchanting specifically, the sheet doesnt really need to know the current AH value of the cuffs. Its considering how much it would cost to craft the cuffs. Then its considering if you disenchant them, if the value of the disenchant is greater than the cost to craft.

[@tribany3558]

is there a possibility that alchemy makes it on that list?

[@semicollin23]

Yep! Working on Thaumaturgy and a flask character.

[@stevegoodin6457]

Do your profits account for the 5% AH cut?

[@semicollin23]

Yep they do!