Calculating Profit Like A Billionaire. Albion Online East .
ฝัง
- เผยแพร่เมื่อ 7 มิ.ย. 2023
- Instant Access to My spreadsheet and other perks like daily best item to craft:
/ goldeniumalbion
Link to my Stream where you can get my sheet free and premium giveaways:
/ goldeniums
Link To my econ discord:
/ discord
Formula to calculate return rate in this video
=(1-100/(100+(total return %*100)))
Simple, understandable and now i gained the useful datas😄
Golde, the excel sheets u r using...do u calculate the exact number of refined mat or crfted products u get .coz that will make the calc more accurate. Or u guys just go with the first time bonus return and then calculate....?
thank you for this useful information
thanks for this, could you also please make one for refining? thankyou
at 9min onwards for a little bit you explain how to show what someone would make after tax on a sell order of 24999 silver, the inputs you place under that for with premium on and off give massive numbers way above the sell order? (multiplying cell f5 against either against 935 or 915) im trying to understand why this is? is there a missing decimal point to make it make sense? how could you setup a sell order of 24999 and then in the cell just below that after calculation factoring premium showing 23 374 065? or do you put a decimal point in there yourself? sry for this Q but when it comes to even basic maths and excel use I have no clue what im doing.
can you do refining?
How long did it take to make your spreadsheet
THANKS A LOT I, i suck at maths so this helps way hugeee. i have been playing albion for years and was always having problem with crafting profits xddd
6:06 why are you findind the opossite (1 - X ) of the total (100%) divided by the bonus (133%) ?
what if it is a weapon which as 2 types of materials, how do I calculate return rate?
Please make one for refining!
Is great to see someone else able to count. How can i contact you privately?
hey can you share reaymate sheet link? please in we just change prices that's it
can u link ur spreadsheet?
does having premium benefit you when doing this activity and at which points?
Yes for 2 things:
- If you use focus (10k each day with premium) you get a bigger return rate --> less costs --> especially nicer the more spec you have, because then it costs less focus per time
- Selling with premium has half the tax (4% instead of 8%), you do always have 2,5% setup fee also for both prem/non-prem.
Nice Goldenium, a how-to-profit with actually showing how to calculate using a spreadsheet with real market prices 0.935
- For non-premium sadly it is even 8% tax, so for sell orders it is 10,5% --> 0.895 x.x
- 1 VERY important thing to be accurate: You did not add station fee in cost price yet, so it is even a bigger loss
ty for the simple frofit % calculation. I did add the station fee in cost at the end of the video.
im not sure how you have made a private comment to me but thank you fo the assistance regarding understanding the sell order tax cell I have changed them following your recommendation. also do you know how I can change this demo in the video to make a tab for 2handed relic item weapons? (ive so far copy paseted a the same formula over to try make a new coloumn for 2h weapons but im not sure how to change the price of material factoring in % saved from resource rate (the cell with the =(B63-(B63*K61)) formula
@@crashsitetv7579
B63 should be the price of all the resources excluding the relic. So if you have for example planks total of 5k and cloth total of 3k (saying some random numbers here) --> It should be 8k as a value there.
K61 should be the return rate % --> for example if the return rate is 24,8% then either the K61 cell is "24.8%" OR "0.248" (the point being the decimal)
Then it should be = (B63 - (B63 * K61) ) + relic price
Does this answer your question?
What's the cost price? Buy order price? Or sell order price plus tax?
See, the main issue is none of us calculate the second time 24% return rate, that will add the exact amount however that wont keep the equation in a simple linear stage...btw i love making albion formulas, and i have some of my own.....love to talk in game.
Whenever I watch these videos people are always saying, “I’ll transport resources to X” but never adding transport costs to crafting with bonuses. On top of that many videos like this also don’t show the crafting tax for using royal city crafting stations, which I think even if you own the station in BW, LH, ML, FS, you pay a tax. If your going to cite economy principles to calculate profit than you should list relevant costs.
Transport is free, just run there yourself. If you don't wanna do that then it's your issue to fix or calculate.
I his calculator it filters out crafting tax, that's why he uses it. And if you don't have the sheet, again, calculate it yourself. Not his issue ❤
i explained the tax for using royal city crafting stations. so i think you might have just not watch me explain it
and also transporting is free if u just get yourself a transport mount
for refining pleas, thanks in advance!
i love u man fr ( no homo )
Can you share your google sheet ? :D
sir please tell what you explained here 9:10 i dont understand
same, dont know why he multiplied that.
33% is return rate so the production cost rate should be 67% of mats.. 36800 x 0.67 = 24656 + 3850(arti) = 28506 + market tax.. i havent played albion in like months but this was how i calculate things.. is this calculation wrong?.
The 33% was the local production bonus which is not the return rate.
It is a bit confusing for sure, but you should calculate with the returnrate as he showed of 24,8% for these.
It is wrong
With 800 crafting specs I can craft so much each day, how am I suppose to sell them though 😢
Sell some on all cities, the rest go black market
google sheets>>>
you should just go be an accountant at this point lol
What about the usage fees?
=((item value of craft*0.1125)*usage fee)/100
You lost me at hello
Refining pls