![]() You can work with that further based on what you are doing. Now, finally, you should have a list of items, their IDs and their prices. Next go to you main list and (I assume you have a list of materials for each production step or whatever you are planning to do ready) you again use SVYHLEDAT () or your language equivalent to search through your Jita prices tab for price of each item.Įxample here: =SVYHLEDAT($F31 'Market prices (Jita)'!$A$2:$H$66 5 0)įirst is cell with item name, 2nd is your Jita Price list, 3rd is collumn you are searching through, 4th is 0) I assume it works correctly for you and you have the data in a usable format. In a bad one, you'll have to mess with the data format so it acts as a number in you list and possibly replace all '. In good scenario you can move to the next step. You should see collumns with prices and other data you picked.Īt this step you can rename the collums, reorganize them etc. ![]() Using the icon with arrows again, you unpack buy and sell and choose the data you want. Now you should see 3 collumns '', '' and ':id'. Here's what you need to do next: Look at marketstat - there's an icon with 2 arrows. Now you should have a new window opened called 'Editor power query' with 3 collumns called 'marketstat', 'Attribute:version' and 'Attribute:method'. Once you are done, you copy the whole link and paste into the window where it asked you for data source. (again, ID's from ID list or google them)Įnd product should be something like this: You copy that and paste that behind the typeid= in the URL.īehind those IDs you need to add system ID. First parameter is ", ", 2nd is empty and 3rd is a collumn of your item IDs. What you can do is go to your item list, in an empty cell enter function TEXTJOIN(). Now since you have x items, you'll need to input all their IDs into a single URL. On their website you can fine the base formats of the url along with different data requests (system, region.). Go to Data tab in excel > Load data > from other sources > from web. Here some more experienced spreadsheet enthusiasts can provide simpler solution, but here's mine: Next step is getting prices for you items. reaction mats are cyan, intermediate mats light blue, components/minerals brown.) You can expand the list or modify it as you want, just copy the function.Īt this step I recommend preparing you main list to what ever you are doing - collums, quantities, math for profit margins, taxes etc.I HIGHLY RECOMMEND COLOR CODING ITEMS so you know what is what quickly (ex. Now you have your item list and their IDs. First parameter is cell with item name, 2nd is ID Source list, 3rd is collumn and the last is 0. For me the function is called SVYHLEDAT(), in english it's VLOOKUP() I think (someone confirm please). In your item list, you'll look up the ID of each item with functions (or manually if you want). Next step might be different for you as I'm not using english language in Excel. Here I can recommend copying the material info directly from industry tab in game or or. Make a new list with items that you are going to be using in your production. Put that ID data into a new separate list. I'd try fuzzwork or google or someone here might link you one (mine is old). Here's how you can make a simple industry Excel sheet.įirst you'll need an up-to-date list of item IDs. For this reason Serpentis put only their most trusted narco-thugs in charge of this new operation Sarpati himself is said to have handpicked the two Captains and their lieutenants.There's not a whole lot of up to date guides on the internet on how to make your own spreadsheets, especially making it automatic. ![]() Marketing highly valuable Exile and Drop boosters in such a way presents numerous challenges and temptations to all involved. No longer content to base their sales exclusively out of static locations, they have begun to push forward and establish temporary markets wherever demand is highest. To access the Info Matrix container, you need a Data Analyser module.įorever seeking new ways to spread their influence in the illegal booster industry, the Core Runners looked to the famed Thukker Tribe caravans for inspiration. This is a Cosmic Signature chemical lab found in null-sec. Site Details Core Runner Exile Production ![]()
0 Comments
Leave a Reply. |