AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
It does this by searching a helper table (RRR) and fetching the correct %RRR for the city that you selected in Variables. This weird looking thing with RRR in the middle is basically finding the correct resource return rate to apply. The number required is actually calculated using another helper table: all the recipes are stored in two tables: "consumables" and "wearables". 5.1) and then multiples it by the number required. PL) and pulls the price from a specific column (e.g. Basically, this formula looks up a material (e.g. 'mats-ref' is a helper table that puts information from the general 'mats' into a searchable tier-based table. T9: SUM OF MARKET VALUES OF COMPONENTS (excluding relics) = Q9+( T9-(T9* VLOOKUP(D9,RRR!$A:$L,MATCH($Z$2,RRR!$1:$1,),FALSE)))+ U9ĪA2: Crafting tax (pulled from Taxes tab, using a helper table for ease) Can you type out the formula for that?Īll the formula are visible in the spreadsheet, but to break it down. How did you calculate the crafting in the spreadsheet. At present, please use use Filter rather than Sort. "The sort function doesn't work" : this is a bizarre, multi-faceted issue which is due to issues with how Excel handles a number of functions. It is in Excel because Sheets didn't work long-term.Ĥ. It broke Sheets rather spectacularly and caused many issues. "It doesn't work when I load it in Sheets" : this spreadsheet used to be a Google Sheets spreadsheet. Using a cracked version of Excel may cause problems, and I have no intention to fix those.ģ. It won't work in any version before that due to features added to Excel after that point. It should work in any version after 2016's updates. "It doesn't work in my version of Excel" : the spreadsheet was made in Build 12730.20250. "The prices are wrong" : petition SBI for a real API and I can fix this problem.Ģ. This is a link to my current spreadsheet versionġ. (4a) If using "Manual", check prices on "mats" and "relics". Select the towns that you are using for each crafting station. Change these taxes to the correct numbers. (2) Press this button: Data > Refresh All (1) Load the spreadsheet in an up-to-date version of Excel. You can contact them in the "Albion Online Fansites" discord. He extracts all of their information, parses it to a json file, and I take this json and use it to provide information for each of the royal cities. My spreadsheet also utilises jsons created by a guy named Rotab to minimise load on ADP's servers. They have real-world costs which can't be removed, and without your help they will need to close the servers for their own financial stability.Ģ) Install the ADP client found on their website, so that market prices can be kept up to date in more places, for more items, making sure that you have access to the latest information on everything you want to see. If you want to see tools like this one - and all other 3rd party tools for Albion - survive, then you should do two things:ġ) Donate real-world money to the guys running it by using the donate button on their website. The tool is based on the Albion Online Data Project (ADP): /ĪDP currently makes a significant loss and the people that run the server no longer play the game. I hope you enjoy this (free!) tool, and that you find it useful. The README should explain how to use it, but if there are any questions, you can contact me using the details provided in the download, or by going to the Albion Online Economy Discord and asking in #mediaboy-spreadsheet. It chews through all the data from the Albion Online Data Project, and spits out the projected profits for every item in the game (disclaimer: WIP), allowing you to focus on items that make you money. This spreadsheet is supposed to make it easy for people to see what to craft and where to craft it, and hopefully encourage more people to get into gathering, crafting and trading: all areas that I use to make money myself, and areas which I hope everyone else will also be able to use.įunctionally, my spreadsheet is a glorified calculator. One of the major complaints from all the new players in my newbie-friendly guild was that they had no idea what items to make, and that everything they made lost money. Each of these items offers opportunities for crafters to make a profit. Albion Online does not have a complicated economy, but it does have thousands of items which can be created by players.
0 Comments
Read More
Leave a Reply. |