I've been replaying DAO and shamelessly abusing the crafting system this time around. Namely, I've been making and selling Potent Lyrium Potions. I finally got tired of trying to guesstimate the number of ingredients to purchase for each potion based on the amount of gold available so I created a simple spreadsheet. I thought I would share. Here's a link to download:
https://drive.google...dit?usp=sharing
Here's a pic to see what you are getting:
Neat. It doesn't quite match the practicalities, though. I.e. you go the the Circle and buy several hundred lyrium even though after that you've only got 20 gold left, or 50 or whatever (depending on your patience). Then you go to the pub in Denerim, buy as many of the remaining ingredients as you can, brew, and sell. Rinse and repeat.
Not sure what you mean. Here's what happens, say you have 100 gold. You fill that amount into the spreadsheet. Then, you put in that you are going to buy, say, 300 lyurim dust. The spreadsheet will automatically calculate how much of the rest of the ingredients that you need purchase and whether or not you have enough money to make the entire purchase (lyrium dust plus all the other ingredients). If you come up short, then you drop the amount of lyrium dust to be purchased down to, say, 200 and, again, it will let you know whether or not you have enough money. So, you purchase your 200 lyrium dust, go and purchase the rest of your ingredients based on the quantities calculated for you, make the potions, sell and repeat.
Okay: let's assume I want to brew a bit of spending money by selling 250 Potent Lyrium Potions. How much money should I have in my pocket when I hike towards the Circle, so that I can avoid having to make more than one trip?
It's a lot easier to use the unlimited money glitch.
In that case, you would leave the starting gold cell blank and just fill in that you need to buy 1000 lyrium dust (as it takes 4 lyrium dust to make one potion). The Remaining Gold cell would tell you that you need 258 gold to make your purchase.
Well, it was a trick question. The answer is '24 gold for the 1000 lyrium, plus whatever you feel you need as seed money for brewing'. I'd leave at least twenty gold for the latter, but that's just me. So you buy the lyrium, rush to the pub. From your 20 remaining gold, you buy a full stack of flasks and small quantities of concentrator/distillator. You brew potions. You sell them. You use the resulting money to buy more concentrator and distillator. You brew and sell again. After a couple of rounds you can buy the ingredients in whole stacks, which makes the thing a bit easier. Rinse and repeat until all the lyrium has been converted to money.
Not sure how it was a trick question. The spreadsheet breaks down how much you need for each ingredient as well as telling you how much you need for all the ingredients. I used the method you mentioned and tired of it as I was trying to build a lot of gold quickly. I needed to know exactly how much potion I could create with the amount of gold I had to minimize trips. The spreadsheet gives me that information with only entering two numbers. At any rate, there's no need for you to use it if it doesn't fit your play style.
ETA: NVM
Guest_starlitegirlx_*
I just use the AIS emporium mod and get it all for free. You dudes make it a lot of work.
I needed to know exactly how much potion I could create with the amount of gold I had to minimize trips. The spreadsheet gives me that information with only entering two numbers.
Don't talk down to me, k? Obviously, we're at an impasse. You want to slowly build up your gold while switching back and forth between brewing and buying ingredients. I prefer to buy what I need up front and be done with it. Once again, don't like it, don't use it but I'm done with the back and forth.
ETA: Darth doesn't want to let this go and contacted me privately. Here is the message:
Hello Maia!
My second question was meant to give you an opportunity to save face, i.e. by giving a sensible answer that avoids the fallacy underlying your answer to my first question.
That may well turn into an opportunity to lose face now, unless you do commit to an answer after all (in which case the outcome would depend on that answer).
Here is my reply:
Actually, your second question borders on harassment as does this message. I don't need to 'save face' as I've already acknowledged your point but don't see that it has any bearing on the OP due to our differences in play style. At any rate, I really don't know or care what your problem is regarding this issue. I'll post this message and my response to the thread as bullying shouldn't be hidden behind private messages. Don't contact me again.
/end reply
Try to share something nice and this is the nonsense you get.
@ maia0407
The idea of measuring the amount of bought ingredients by looking at the remaining gold is brilliant, and that alone should make a visit of this topic more than worth it for many people.
The rest is not quite as brilliant, especially the decision to add noise to this thread by publishing a private message, instead of simply replying in private and/or reporting it to a moderator.
For the 200 gold thing: after entering the amount of gold, the spreadsheet sits there waiting for the user to calculate the amount of lyrium in their head, or to arrive at some number by trial and error (taking care to keep the number a multiple of 4). I eased that pain by entering the formula "=4*FLOOR(C3/(4*C5+2*C6+2*C7+C8);1)"; for dealing with sets of whole stacks the last FLOOR() parameter can be changed to 99 or pulled from some input field.
Thereupon the spreadsheet proposes to buy 772 lyrium etc. but the exact numbers don't matter because the "Gold Tally" serves as a convenient guide when buying. Profit for the trip: 42.267 gold (21% ROI).
Alternatively, you could just buy lyrium in multiples of four stacks (9.50 gold per quadruple stack, i.e. roughly 10 gold) until the remaining gold drops below 102.07 which is 92.57 + 9.50. That would be 11 quadruple stacks in our example, for a profit of 238.49 gold (119% ROI). Or you could stop earlier, once the number of quadruple stacks times 21.68 gold exceeds the profit that you need.
92.57 is the cost of 99 full sets of the 'pub' ingredients, for minimum hassle and zero math effort. A reasonably convenient value for the less well-off is 46.83 gold (for a buy-stop when gold drops below 46.83 + 9.50 = 56.33). This still allows to buy the pub ingredients in stacks of 99, with flasks being bought only every other round, for at most four rounds before switching to full mode.
For example, if you only have 100 gold to your name then you could buy 384 lyrium as per the spreadsheet, for a profit of some 21 gold for the trip. Or you could buy 5 stacks of lyrium according to the half-set rule (stop below 56.33), for a profit of some 108 gold.
The buy-stop numbers work in either direction, Circle to pub and pub to Circle. When you're at the quartermaster's, the expected profit is a bit more than twice the difference between your gold and the magic buy-stop number.
This maximises the profit per roundtrip and minimises the number of required trips for making a given amount of gold. It completely avoids overbuy and the need to do non-trivial math in one's head or on a spreadsheet.
Neat. It doesn't quite match the practicalities, though. I.e. you go the the Circle and buy several hundred lyrium even though after that you've only got 20 gold left, or 50 or whatever (depending on your patience). Then you go to the pub in Denerim, buy as many of the remaining ingredients as you can, brew, and sell. Rinse and repeat.
This is the method I have followed in the past.
Also, this thread is surprisingly amusing.
Pro Tip: Whatever you do, just don't forget your herbalist in camp. I usually do. It's not exactly a nice feeling when you finally realize it after buying the reagents in the Gnawed Noble Tavern.
lol, I've done this too many times to count!
@ maia0407
The idea of measuring the amount of bought ingredients by looking at the remaining gold is brilliant, and that alone should make a visit of this topic more than worth it for many people.
The rest is not quite as brilliant, especially the decision to add noise to this thread by publishing a private message, instead of simply replying in private and/or reporting it to a moderator.
For the 200 gold thing: after entering the amount of gold, the spreadsheet sits there waiting for the user to calculate the amount of lyrium in their head, or to arrive at some number by trial and error (taking care to keep the number a multiple of 4). I eased that pain by entering the formula "=4*FLOOR(C3/(4*C5+2*C6+2*C7+C8);1)"; for dealing with sets of whole stacks the last FLOOR() parameter can be changed to 99 or pulled from some input field.
Thereupon the spreadsheet proposes to buy 772 lyrium etc. but the exact numbers don't matter because the "Gold Tally" serves as a convenient guide when buying. Profit for the trip: 42.267 gold (21% ROI).
Alternatively, you could just buy lyrium in multiples of four stacks (9.50 gold per quadruple stack, i.e. roughly 10 gold) until the remaining gold drops below 102.07 which is 92.57 + 9.50. That would be 11 quadruple stacks in our example, for a profit of 238.49 gold (119% ROI). Or you could stop earlier, once the number of quadruple stacks times 21.68 gold exceeds the profit that you need.
92.57 is the cost of 99 full sets of the 'pub' ingredients, for minimum hassle and zero math effort. A reasonably convenient value for the less well-off is 46.83 gold (for a buy-stop when gold drops below 46.83 + 9.50 = 56.33). This still allows to buy the pub ingredients in stacks of 99, with flasks being bought only every other round, for at most four rounds before switching to full mode.
For example, if you only have 100 gold to your name then you could buy 384 lyrium as per the spreadsheet, for a profit of some 21 gold for the trip. Or you could buy 5 stacks of lyrium according to the half-set rule (stop below 56.33), for a profit of some 108 gold.
The buy-stop numbers work in either direction, Circle to pub and pub to Circle. When you're at the quartermaster's, the expected profit is a bit more than twice the difference between your gold and the magic buy-stop number.
This maximises the profit per roundtrip and minimises the number of required trips for making a given amount of gold. It completely avoids overbuy and the need to do non-trivial math in one's head or on a spreadsheet.
Don't just blather on about it, share your work. I still think you are insufferable but now I'm curious about your formulas and need to actually see them set up in a spreadsheet to know what you are talking about.
@maia0407 - The basic idea is that the more lyrium dust you take with you to the tavern, the longer you can keep crafting potions before needing to make the return trip. Hence more profit per trip.
The question however is how much potions you want to brew before selling the first time.
The drawback of what you proposed is that you'll run out of lyrium dust much much earlier.
In short, it means the larger the percentage of initial fund invested in lyrium dust, the greater is the amount of profit per trip. Same thing for the return trip, but with reagents. The catch is increased number of buy-sell routine. But there can be a comfortable balance, which is what DarthGizka mentioned. There isn't exactly any need for formulae or spreadsheets or such.
Hope this helps.
Thanks, I understand all that. I just like spreadsheets and want to see his formulas at work in a sheet.
ETA: I guess, I just don't mind making the trips if it means I don't have to switch between the menus as often while crafting. Preferences, really.
Nice spreadsheet. When I tried crafting potions for profit instead of using glitches I had to use my head, but I made up to 1000 gold when I was done with the whole thing.
Retour en haut