Тёмный

Calculating Profit Like A Billionaire. Albion Online East . 

Goldenium
Подписаться 4,7 тыс.
Просмотров 20 тыс.
50% 1

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)))

Опубликовано:

 

7 июн 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 41   
@lastsurvival_gaming
@lastsurvival_gaming Год назад
Simple, understandable and now i gained the useful datas😄
@muhamadrasyid11
@muhamadrasyid11 Год назад
thank you for this useful information
@i7i7i7fl
@i7i7i7fl Год назад
thanks for this, could you also please make one for refining? thankyou
@user-sy9dr3zv1y
@user-sy9dr3zv1y Год назад
can you do refining?
@Junkd0gAO
@Junkd0gAO Месяц назад
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
@justsaying1720
@justsaying1720 10 месяцев назад
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....?
@blankkhan6661
@blankkhan6661 Год назад
How long did it take to make your spreadsheet
@crashsitetv7579
@crashsitetv7579 Год назад
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.
@antonioandre23
@antonioandre23 5 месяцев назад
6:06 why are you findind the opossite (1 - X ) of the total (100%) divided by the bonus (133%) ?
@reallynotallen3605
@reallynotallen3605 Год назад
Please make one for refining!
@antonioandre23
@antonioandre23 5 месяцев назад
what if it is a weapon which as 2 types of materials, how do I calculate return rate?
@veertje135711
@veertje135711 Год назад
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
@goldenium
@goldenium Год назад
ty for the simple frofit % calculation. I did add the station fee in cost at the end of the video.
@crashsitetv7579
@crashsitetv7579 Год назад
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
@veertje135711
@veertje135711 Год назад
@@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?
@invisibl3854
@invisibl3854 11 месяцев назад
What's the cost price? Buy order price? Or sell order price plus tax?
@justsaying1720
@justsaying1720 10 месяцев назад
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.
@wathafaaaak
@wathafaaaak Год назад
hey can you share reaymate sheet link? please in we just change prices that's it
@ToBeFashion123
@ToBeFashion123 Год назад
Is great to see someone else able to count. How can i contact you privately?
@psoren423
@psoren423 5 месяцев назад
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.
@Minsii.
@Minsii. 5 месяцев назад
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 ❤
@goldenium
@goldenium 3 месяца назад
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
@qwitek6738
@qwitek6738 Год назад
can u link ur spreadsheet?
@farmboi9690
@farmboi9690 Год назад
i love u man fr ( no homo )
@aleksandartonev8472
@aleksandartonev8472 Год назад
does having premium benefit you when doing this activity and at which points?
@veertje135711
@veertje135711 Год назад
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.
@LusKereN80
@LusKereN80 Год назад
Can you share your google sheet ? :D
@The-Me
@The-Me Год назад
google sheets>>>
@zunou5545
@zunou5545 Год назад
for refining pleas, thanks in advance!
@Malicious_Pk
@Malicious_Pk Год назад
sir please tell what you explained here 9:10 i dont understand
@kuysneil22
@kuysneil22 5 месяцев назад
same, dont know why he multiplied that.
@chuckmeister6240
@chuckmeister6240 Год назад
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?.
@veertje135711
@veertje135711 Год назад
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.
@Lilwillg
@Lilwillg 3 месяца назад
You lost me at hello
@daryljaymayo8359
@daryljaymayo8359 22 дня назад
What about the usage fees?
@qwerdasfuhgeo6248
@qwerdasfuhgeo6248 2 дня назад
=((item value of craft*0.1125)*usage fee)/100
@indragaming7799
@indragaming7799 Год назад
you should just go be an accountant at this point lol
@golfer4039
@golfer4039 Год назад
With 800 crafting specs I can craft so much each day, how am I suppose to sell them though 😢
@ollala4552
@ollala4552 Год назад
Sell some on all cities, the rest go black market
@carlotagle1550
@carlotagle1550 7 месяцев назад
Refining pls
Далее
ALL Silver Methods Revealed - Albion Online East
49:13
Make MILLIONS Refining Hide to Leather! | Albion Online
21:40
How to make money in Solo dungeons
10:03
Просмотров 49 тыс.
Billionaire Hideout Crafting #1 . Albion Online East
10:51