The only place that Hill Herb can be purchased for a reasonable price is in barbarian cities. It's almost worth creating a spreadsheet just for individual cities. There's actually an extra nuance to the seasons as well: early season and late season prices are also different. You need to collect data on a seasonal basis, so a new spreadsheet for each season. The least nuanced, yet still useful form of what I'm about to discuss is a generalized list of all prices encountered and distilled. (food, clothes, whatever.) By taking the calculated "likely profitable price" and dividing it by weight, I can actually determine which items are in fact the most valuable. You’ll also want to make a table that combines all those prices for averages across all seasons and towns.īy taking the average price for a buy order and subtracting one standard deviation, I come up with a number that is a reliably profitable price for the item. At most, make 8 spreadsheets, two for each season with one detailing “royal cities” and one detailing “towns and villages” for each season. You’ll want to create at least 4 spreadsheets, one for each season. At the very least, an unorganized table will give you basic buy/sell values and an average so you can make a profit. There are definitely patterns and a method to the madness.
I know that it looks sloppy and complicated, buy it's really, really useful. Recommended PriceĞxcel: =SUM(Average - Standard Deviation)Ğxcel: =SUM(Average + Standard Deviation) Standard DeviationĞxcel: =STDEV(first: last) for both buy and sell Max ProfitĞxcel: =SUM(maxprice sell-minprice buy) Min PriceĞxcel: =MIN(first:last) (for buy and sell) (line to indicate end of data)-Īverage Price in Excel, type =AVERAGE(first data cell:last data cell) using data from “buy,” repeat in next column using data from “sell”
This creates a table that looks kinda like this: This value tells you most accurately, late-game, what items are the best to trade. A "recommended" price generated by subtracting a standard deviation from the average buy price and adding a standard deviation to the average sell price. DATA! Prices (buy and sell) collected from every town you visit, every time, even if you think prices are bad! City (Some cities are "royal Cities" which tend to have prices on extreme high or low ends, some "normal" cities provide certain goods at very low prices)
Season (IMPORTANT! Seasons dramatically impact the price of goods!) This gives me data that I can use to extrapolate a number of useful values. In order to deal with the system as it stands, I've drawn up a spreadsheet that contains data from observed values that I see in cities for all goods, regardless of whether I buy them or not, I write them in the spreadsheet. I was going to post this as a guide/walkthrough but I haven't gotten all that far in teh game myself, I've just developed this technique to understand the economic system that is in place. WARNING: CONTAINS STATISTICS AND MATH-THINGSĪllright, well, actually I have some insight into the problems people are having with the "unpredictable" trading system.
0 kommentar(er)
