ALLOY CRAFTING is MONEY | The War Within Gold Guide

[@Barrikz]

THIS GUY IS THE GOAT JUST DOING THIS FOR THE PEOPLE NO PAID GOLD GUIDE THANK GOD your awesome man thank you

[@Goldzen_tv]

Great video Brezbrez your spreadsheet game is top notch, bit of a shame that Auctionator cannot automatically calculate the avg price based on 10000 items which would be nice. I can definately see the author tweaking it to suit us better than TSM live price data is better in general especially when making decisions. Keep up the good work - Might be worth to mention that the true end game of crafting is at what price you purchase the materials and timing right now its low so crafting now to sell at a later date would be advantageous.

[@vollernte]

Huge Document. I already made good Gold with Alloys but was to lazy to do my Doc. Youre Nuts! TY

[@brittca]

Absolutely brilliant content. Thank you!!

[@OfHellsDesigngaming]

Glad to see the updates to the sheet and feature request. Looking forward to future updates. Only thing I would mention is a suggestion to tell people to use the cells down below where you pasted in the price data. Its formatted with GGGSSCC so as long as they remember to apply the price appropriately it will be better than changing the cell and losing the expressions you provided. Good call on using the notes to supply the original formula though.

[@semicollin23]

Thanks! The only downside to having people use the cells down below for the price override, is those also have formula's to pull the data from the auctionator export.

[@OfHellsDesigngaming]

@@semicollin23 I have been editing the prices the way I mentioned and its not affected the formula at all where you initially paste into the cell. It seems to retain what is pasted below that initial box and allow for editing which in turn updates the cells above.

[@spudink13]

With so many bait prices, I have to overwrite the formula a lot with hard numbers. When I paste the auctionator data again in the future, it obviously keeps my old inputted numbers. Would be useful to have a cell somewhere to temporarily use a price for something when filled, so that it keeps the formula preserved when pasting. Thaumaturgy would also be a great addition to this sheet. Lots of money to be made there. Keep up the good work!

[@acepalomino4718]

On one of his other videos he shows how to easily reset it so when you paste again it will update automatically instead of needing to do it manually again

[@joaquinbarrionuevo4122]

Thank you for all your hard work! Loved the video

[@EVAzeroum]

nice video! did you plan to make an alchemy cheat sheet?

[@UnluckyCharmz87]

Love the addition of the ROI column! I tried to add a couple things to one of the sheets and I have a whole new appreciation for how much work is going into this sheet. Thank you for your hard work! Is it possible to color code the cells we have manually overridden so we know which ones need changed back?

[@NalrufZ]

Perfect as always!

[@neinnein7112]

Hey, I tried using the Jewelcrafting section but when I complete the crafting with prospecting it says I should get somewhere at 30k gold but I end up barely making 8k gold. I have all the stats and 20% resourcefullnes except the bag but that shouldn't matter for prospecting right?

[@balloonredd]

the sheet is weird. i did what you did in the vid. it tells me to buy r1 bismuth but buying 10 bismuth is 160 g while the alloy is selling for less than 130 g. yet the sheet still tells me i will make profit

[@hj0ranger]

You should overwrite the input cell from the exported shopping list, not the cell in the pricing list. This way, you won’t need to copy and paste the formula.

[@j_orpz]

Noooo you're gonna kill my market lol! Your sheet is much nicer than mine - thanks for the hard work as always

[@qstrql_sg]

it's already crashing gg

[@semicollin23]

It may crash immediately, but itll recover eventually

[@qstrql_sg]

@@semicollin23 tbf it was crashing before your vid on EU and it's still going down but yeah

[@McPock2]

Request for getting Engineering added. Appreciate you! - subbed and liked, keep it up

[@semicollin23]

Part crafting in Eng?

[@doomnotron]

Amazing i can't believe i specter right for once.

[@juggernot540]

awesome work can you add gilded vial to the JC

[@user-ws9di5kp9h]

Might as well manually enter prices into the sheet.

[@belamri3709]

thanks for the video but your discord link invalid

[@PresidentGates]

Idk if this spreadsheet is no longer working but when i paste all the values in it just gives me #NAME? in 3 of the catagories. anyone else having this issue?

[@semicollin23]

Restart your internet browser, that should fix the issue

[@qstrql_sg]

you have written "21% ressourcefulness and 23% multicraft" is it hardcoded like trhat in your google sheet? in game it's closer to 20% and 22% but it rounds up and also do you account for AH cut in the sheet directly ?

[@semicollin23]

Hey good question. The actual numbers are based off real crafting. So the profit isnt inflated like if you actually crafted with 21% resource and 23% multi. I just put in that section what everyones percent's will say unless you mouse over it.

[@qstrql_sg]

@@semicollin23 okay great ! thanks

[@harvey-rc9ef]

hey bro, I need any permission to edit Excel?

[@semicollin23]

You need to go to file > make a copy to have a local editable version of the sheet.

[@chriss6356]

The price lookup is useless for ore because of AH baiting bots posting at half price

[@freddycuevas5743]

I don't see the sheet taking in consideration the AH cut.

[@semicollin23]

It does. On the alloy sheet specifically, its accounted for in column J, which is a hidden column

[@freddycuevas5743]

@@semicollin23 it shouldn't be hidden for the video propuso, since you are explain all the thing you are taking in consideration for the calculations.

[@jaysonhaptonstall8302]

What's the addon that says knowledge x out of y?

[@Vestedd]

WeeklyKnowledge

[@donkusti]

your prices what it showed was from snipers. not real prices.

[@SamMathewsOfficial]

He mentions that a few times.

[@j_orpz]

@@donkusti just update the spreadsheet lol

[@kyostihedman9650]

this is scam u cant profit blacksmitting

[@undeadtrix8211]

FFS keep ur hands down dude so distracting lol, icant even here u talk i just hear ur hands screaming

[@Calaxt01]

Nah, it's fine.

[@prytosan]

I have BS ...maxed spec ....+40 skil. OFC im doing rank 2 from rank 1.... BUT ...its totaly not profitable on HI-POP EU serv ////. Maybe with own mats ..... :(

[@prytosan]

@fustasj8940 serwer for alloys ??? 🤣🤣🤣🤣🤣🤣

[@johnnyringo2695]

yeah high pop its not, mats cost more in AH, better to mine and sell