Very helpful, thanks. A companion video on the most efficient way of getting your estate/stronghold to the point where you can produce some of the most commonly profitable items would be great.
Some functions in this spreadsheet are very wrong. I put in the exact values and it tells me that I should make 7 gold profit on scarecrows, when I actually make pretty much none at all. Relevant values are: Green Mushrooms 10g per 10 (need 15), Blue Mushrooms 15g per 10 (need 3), Timber which is cheap so whatever. Mushrooms cost ~19g, Scarecrows worth ~20g. Spreadsheet says ~7g profit. Please tell what went wrong Don.
Don I have one question, for example White flower price are 39 golds per 100 units, but Blue flower are 6 per 10 units. When I put in the sheet do I I put White flower at 39 golds (per 100) or 3.9 golds (per 10 like others)?
Is there any way we could get a version of this that gives out profits in gold instead of in dollars? I'm kind of confused about the dollar ammounts anyway since the price of gold in crystals (and therefore the price of all items) is variable.
This is great. I had not found ANYone talking about those map chests. Then I found this channel and it's everything I wanted! Did the Eve and POE thing for all the market stuff back in the day so this really works for me. Thanks :)
A couple of us in my guild made a spreadsheet, one rudimentary and another like yours. Yours is comprehensive and nicely laid out so I think we're gonna adopt it. So thank you very much for this spreadsheet, liked and subscribed!
Since you seem to be thoroughly enjoying your time playing this game i am going to give this game a fair chance. good job on this tool and keep it up Don
Holy shit why didnt I see this before. I was calculating here and there and soooo much. Thank you SO much for the spreadsheet, a subscribe is the least I can give you back!
Well my man you got another follower. You advice is concise! I let me say have a lot to do w2ith 2012 PoE and this game. Thank you for your wisdom! Trust me I do not compliment easily. You know your stuff!!!
Hi Don! Thanks for sharing your effort! I really like your Excel sheet, but was wondering why the splendig flare was so much more viable than a normal flare till i looked up the formulas you have been using. I think in cell AH48 you forgot to put in the "3" for the amount of flares required to craft the splendid flare. It is crazy to see the influence your excel has on the market, because all other item prices are based around the profit you have calculated with your excel, but the splendid flares are way of the chart undercutting the "real" cost by almost 10g a piece, which is closer to the fake profit calculated by your excel :D
because of this guide, i end up spending more time trading in market generate gold , rather than playing the actual game. it's fascinating how people enjoy the game differently.
how do I find the Stronghold stats like Perfection chance and such? Awesome tool ty for sharing :) Was on your stream the other day too, been watching since poe and am glad that you're playing LA, your videos been helping a ton!
One thing, I don't recall the fix for it on excel, but if two values are both in 8th place for example, because of how VLOOKUP works it will grab that name twice for 8 and 9 instead of grabbing the 'equal' 9th place.
I know this is a week old, but they're getting closer to 4k now, But they seem to be matching the gem/gold ratio. Gems are skyrocketing lately for what ever reason, f2p players fault for not waiting 20 minutes to buy crystals 😂
sick guide and ty for the spreadsheet, but where do you find mushrooms? i'm looking all over from starting areas to t2 maps and even if i find some they respawn as flowers.
Currently certain crafts are untradable such as green and blue recovery potions, is this a further unlock with the stronghold or is this a western change?
Is there something down the line that causes rapport with Thirian and Azena to do something to impact the stronghold profitability or am I overlooking something?
Great sheet! Would it be possible to add cooking recipes? I expanded the sheet and noticed there are only 5 columns for ingredients, so it would be great if those could be the actual max number of 10 (if there are actually any recipes that require that much), as cooking requires 6+ often times.
Bad news is I am now sitting on 70 gold down from 2000. Good news is I now have a life supply of flash grenades that came back after a day in the market! :) EDIT: yeah probably shouldn't have skipped 3:11 - 3:14 part
The real G.O.A.T. Thanks, really useful.. i like to flip stuff in other mmos.. can you recommend 'most used' mat/consumables that might be good for this.. or where I can find? You mentioned a couple, sure there are more
i think the spreadsheet might be off for the splendid flare? it says im making 19 gold for selling them at around 35 gold, but i did the math and to buy everything i need for 40 in the market it costs 1961 gold and to sell 40 at 35 gold is only 1400, am i missing something?
@@DonTheCrown Nice thanks for the info bro my stronghold is level 40 imma start doing this from now on! what do you usually craft and sell ? do you always sell top 1 and 2 ?
Great spreadsheet! Was wondering if you can make a spreadsheet of all the currency exchanges as well for royal and blue crystals as well to see what's the most value on the ah and mari shop thanks! my maths aint too great
without downloading the spreadsheet, it is a table that he is using to index off of for some of the other calculations. He briefly explains it in the video.
good question, some things are easier/faster to gather but don't generate a ton of gold when crafting (excavation is really fast to burn through energy but has limited crafting options) somewhat the best to farm the most expensive stuff and then craft with the cheapest
really nice utility. i updated all prices from market. and i have almost few profitable items... why is that? is the market clogged or my stronghold is low?
Thanks man! I just started and was wondering how to get gold, i just farmed the mats and try crafting something to sell, but with this i can start an EMPIRE! no... maybe not, but maybe i can get my aura :P
Very helpful, thanks. A companion video on the most efficient way of getting your estate/stronghold to the point where you can produce some of the most commonly profitable items would be great.
Some functions in this spreadsheet are very wrong. I put in the exact values and it tells me that I should make 7 gold profit on scarecrows, when I actually make pretty much none at all.
Relevant values are: Green Mushrooms 10g per 10 (need 15), Blue Mushrooms 15g per 10 (need 3), Timber which is cheap so whatever. Mushrooms cost ~19g, Scarecrows worth ~20g. Spreadsheet says ~7g profit. Please tell what went wrong Don.
@@FiFiFilth Might it be that you get multiple (x3) scarecrows, when you craft it, not just one
Hope this tool helps everyone as much as it helped me! Really looking forward to western launch.
Yes this tool does include the auction house fee.
I had like 10 spreadsheets for BDO lifeskills, this is awesome
Don I have one question, for example White flower price are 39 golds per 100 units, but Blue flower are 6 per 10 units.
When I put in the sheet do I I put White flower at 39 golds (per 100) or 3.9 golds (per 10 like others)?
Gonna test it. But I'm quite sceptical cuz it won't take in consideration sales Volume.
Is there any way we could get a version of this that gives out profits in gold instead of in dollars?
I'm kind of confused about the dollar ammounts anyway since the price of gold in crystals (and therefore the price of all items) is variable.
Wow! Thank you so much for this!!! Amazing. You have my sub.
I’ve been looking for a spreadsheet just like this for a while now. Thanks for making it publicly accessible!
No problem!
This is great. I had not found ANYone talking about those map chests. Then I found this channel and it's everything I wanted! Did the Eve and POE thing for all the market stuff back in the day so this really works for me. Thanks :)
Epic, was really looking forward to this from your stream.
I appreciate you bud.
Hope it servers you well!
A couple of us in my guild made a spreadsheet, one rudimentary and another like yours. Yours is comprehensive and nicely laid out so I think we're gonna adopt it. So thank you very much for this spreadsheet, liked and subscribed!
Since you seem to be thoroughly enjoying your time playing this game i am going to give this game a fair chance.
good job on this tool and keep it up Don
Hope you enjoy it! I've been having a blast and I hope you will too!
Instantly subscribed when i saw the spreadsheet 😍 great content! thanks for sharing
Really appreciate the amount of work that went into this spreadsheet. Your content are always so insight, Don!
ohhhhh beautiful spreadsheet DonTheCrown! Thank you so much!
Calm steady voice with good solid info, new sub here!
Can't wait to see more Lost Ark content from you, Don :D
thanks its coming!
Holy shit why didnt I see this before. I was calculating here and there and soooo much. Thank you SO much for the spreadsheet, a subscribe is the least I can give you back!
Thanks for this sheet! Amazing job you did for us all!
Great tool! thank you!
Subscribed! This is just amazing, new player here, this is very helpful. Thank you for what you are doing this for the community ☺️
Well my man you got another follower. You advice is concise! I let me say have a lot to do w2ith 2012 PoE and this game. Thank you for your wisdom! Trust me I do not compliment easily. You know your stuff!!!
Another nice easy to understand video with a bonus tool for free we can use! Super and Thank you Don
The sad thing is that on my server, currently everything is crafted at a loss
I don't have use for this right now but I will save this video for when I need it, thanks!
Hi Don!
Thanks for sharing your effort! I really like your Excel sheet, but was wondering why the splendig flare was so much more viable than a normal flare till i looked up the formulas you have been using.
I think in cell AH48 you forgot to put in the "3" for the amount of flares required to craft the splendid flare.
It is crazy to see the influence your excel has on the market, because all other item prices are based around the profit you have calculated with your excel, but the splendid flares are way of the chart undercutting the "real" cost by almost 10g a piece, which is closer to the fake profit calculated by your excel :D
Please keep making this content it will help people like me starting from zero.
ty Don Senpay
because of this guide, i end up spending more time trading in market generate gold , rather than playing the actual game. it's fascinating how people enjoy the game differently.
I was just wondering if anyone has made a sheet of these, thanks for saving my nerdass time :D
amazing tool, thank you for sharing :D i loled at "what every path of exile player does"
ty very much for the help man.
big thanks. liked. commented. subscribed.
thanks a lot for sharing this!
You had me at spreadsheet
I was distracted by the whole Windows Update needs restart notification in your taskbar
Nice one man, glad to see you over in lost ark too
only level 30 but I've made over 1k gold flipping dark grenades because of this tool. few other items mixed in when the profit goes up. Thanks!
You should be one of the contract characters: "ministry of finance"
I could totally code this If I was a game developer, look at the rates, unlocks, prices and simples suggest the crafts
HAHA I love your giant spreadsheet instincts!
Thanks for the tutorial and the share! Subbed.
how do I find the Stronghold stats like Perfection chance and such? Awesome tool ty for sharing :) Was on your stream the other day too, been watching since poe and am glad that you're playing LA, your videos been helping a ton!
will you add the cooking items (meals) in the future?
Thanks a lot mate, really appreciated!
Wow man this is incredible thank you!
So many thanks for all the work.
It takes a lot to get me to sub, but spreadsheets will do it!
One thing, I don't recall the fix for it on excel, but if two values are both in 8th place for example, because of how VLOOKUP works it will grab that name twice for 8 and 9 instead of grabbing the 'equal' 9th place.
This is incredibly helpful, sadly my servers economy is just messed up and its all negative to craft
thats EVERY server, eventually things will pop out
@@DonTheCrown any idea what’s causing the plummet?
@@bigpiipe3206 servers are brand new..
Interesting. I will have to check this out. I have not really tried to make any gold yet.
Don i love your lost ark video they make everything simple
what is the skin you are using ? i havent seen a white like that
Great video! Thanks for the tool! Also is that one of the monster hunter village/town themes that I hear in the background? Sounds so familiar lol
its Lost Ark OST
done the same thing love the economy in games, also bought about 50 cat pet boxes @800 already started selling @1500
I know this is a week old, but they're getting closer to 4k now, But they seem to be matching the gem/gold ratio. Gems are skyrocketing lately for what ever reason, f2p players fault for not waiting 20 minutes to buy crystals 😂
@@petercottantail7850 its bots mate the economy is fucked gg amazon
Thanks for the tool, I tried it, and right now, I would loose money on everything, so I guess I need to wait until the prices get higher
Good Man! Thank you
Thanks a lot for this!
you sir, you just got yourself a new sub
Very cool, thanks :)
sick guide and ty for the spreadsheet, but where do you find mushrooms? i'm looking all over from starting areas to t2 maps and even if i find some they respawn as flowers.
random spawn in herb spots
How did you learn how to make such a sheet? Looks so complicated to make. Thanks!
In the sheet that you have shared with us, what's up with Column B (Cost), what currency is that? Silver? Gold?
Currently certain crafts are untradable such as green and blue recovery potions, is this a further unlock with the stronghold or is this a western change?
would like to know
Seems like a nice tool, thx!
Thanks for this!
Is there something down the line that causes rapport with Thirian and Azena to do something to impact the stronghold profitability or am I overlooking something?
Great sheet! Would it be possible to add cooking recipes? I expanded the sheet and noticed there are only 5 columns for ingredients, so it would be great if those could be the actual max number of 10 (if there are actually any recipes that require that much), as cooking requires 6+ often times.
I wanted to do the same thing I tried to add it myself but I'm not sure if the formula will work properly for them.
How do u get that tuxedo outfit that u are wearing? :o)
great content all around
skin in the Russian client
Bad news is I am now sitting on 70 gold down from 2000. Good news is I now have a life supply of flash grenades that came back after a day in the market! :)
EDIT: yeah probably shouldn't have skipped 3:11 - 3:14 part
yeah... i made a similar mistake in RU, dont go too ham on one market til you feel it out, also figure out what people actually buy
the values don't add up, it takes gold to craft item is that being taken into consideration?
Thank you so much!
The real G.O.A.T. Thanks, really useful.. i like to flip stuff in other mmos.. can you recommend 'most used' mat/consumables that might be good for this.. or where I can find? You mentioned a couple, sure there are more
not sure til the servers really start popping off
many thanks for the video and the exel just great great job. all the best for you.
i think the spreadsheet might be off for the splendid flare? it says im making 19 gold for selling them at around 35 gold, but i did the math and to buy everything i need for 40 in the market it costs 1961 gold and to sell 40 at 35 gold is only 1400, am i missing something?
What server are you going to be on Don?
Ladon na east
What does the dolar sign means on the spreadsheet? Shouldnt the profit be in gold?
I am a big fan of this, but i dont really know what "green potion" Or "blue potion" or "E purple potion" is. Could you clarify these a little more?
Two Words.....Thank you
Are you buying the materials? Or tradeskilling it all? If you are farming the materials, perhaps a good video on best places to farm that you prefer?
Hey Don, I think your formula for Electric Grenades is missing the [Ore - White] ingredient
Thanks Don
i saw that spreadsheet and think *of course* xD
Does this take into account that when selling green potions, AH takes 1/3 of the sale price? it sells for 3g and it costs 1g to put it up
Legend, thanks
With the mushrooms at this price, wouldn't it be better just selling them off right away? Great video and dedication btw!
What's with the blue healing potions being untradable?
I can't even give them to alts if I pick them up with the wrong character. So dumb.
do you buy the resources in the market and craft them ? or do you go gather them up everyday then craft??
this sheet assumes you buy the resources and yes i buy stuff
@@DonTheCrown Nice thanks for the info bro my stronghold is level 40 imma start doing this from now on! what do you usually craft and sell ? do you always sell top 1 and 2 ?
wow thx so much for sharing
Gold = blue gems = gear mats, also engravings so I hope this works.
Great spreadsheet! Was wondering if you can make a spreadsheet of all the currency exchanges as well for royal and blue crystals as well to see what's the most value on the ah and mari shop thanks! my maths aint too great
You the man bro!!!
Thank you!
What are the items in the gray section at the bottom?
without downloading the spreadsheet, it is a table that he is using to index off of for some of the other calculations. He briefly explains it in the video.
@@dannyberry8725 I realize now I was unclear, I was refering to the tier 2 and above crafting recipes that I was not familiar with at the time.
simple oreha is pretty good simple crafting if you fish
Don, u buy the materials from AH or u farm? ty
this sheet is all about buying them
@@DonTheCrown ooh gotcha bro!! ty
would you be willing to upgrade this tool so it can include excavation crafts like the maps
But where is the crafting cost on the chart? Does it take that into the formula ???
its in there and hidden
cheers
Golden yt channel
Is there any reason for just selling the materials directly to the market or is it always better to use it to craft and then sell to the market?
good question, some things are easier/faster to gather but don't generate a ton of gold when crafting (excavation is really fast to burn through energy but has limited crafting options)
somewhat the best to farm the most expensive stuff and then craft with the cheapest
All the stuff I can make is bound at the moment. How would I go about making items and potions that are not bound to me?
can u do a vid on what ur goals are on release? I wondering if im missing out on something big
i wanna be the very best xD but nah you can make some nice passive income from estate and level it up a lot at the same time
really nice utility. i updated all prices from market. and i have almost few profitable items... why is that? is the market clogged or my stronghold is low?
low demand for consumes atm
Why does it have dollar signs? Are they meant to signify gold? Or am I missing something?
Yup gold, limits of Google sheets formatting
Thanks man! I just started and was wondering how to get gold, i just farmed the mats and try crafting something to sell, but with this i can start an EMPIRE! no... maybe not, but maybe i can get my aura :P