Trade Wars
19Jan/126

Level 400 Biochem – Now What?

If you haven't yet visited the crew skill trainer head over there and pick up all non-purple schematics. If you want to save some coin you can go for the top level schematics only which are the ones that require skill 380 and above. Unless you have a specific use for a Rakata schematic they are just a waste of money.

Now you need to study the market. This part of the process is by far the most time-consuming at the moment. Without add-ons or other tools to help you gather the data you need, you basically have to resort to pen and paper. On the surface this doesn't look to difficult, but then you realize that one green implant can turn into 3 blue implants and those 3 blue can turn into 14 purple, then it can be quite a task to keep track of up to 10 different green implants and their improved versions.

In order to keep track of the prices of mats and items I created a spreadsheet to hold some of the data needed. Let me go through how it works.

First you need to fill in the market value of the different crafting materials on the Materials sheet. The vendor mats are fixed on all servers so they are pre-filled. At the moment only Grade 5 & 6 materials are implemented in the sheet so don't bother with any of the others.

On the other sheets you fill in the market value (price) of the items on the GTN. In the example below you can see the data for the top level Reaction implant. The ones not filled are situations where there is no items posted on the GTN. This is obviously an opportunity if there is a demand for the item. I will cover which prefixes are most likely to be in demand and which ones to stay away from in a later post.

Another feature of the spreadsheet is being able to add your own schematics without having to deal with formulas and calculations. On the Adrenals & Stims sheet there is a custom section where any schematic can be added. The only restriction is the schematic can only use grade 5 or 6 materials. Just put in the amount of materials used by the schematic in grid to the right and the market value and you will know if there is a profit to be made from crafting the item.

Feel free to leave suggestions or feedback to the file in the comments below. You can also email me. My email is in the file as well.

Comments (6) Trackbacks (0)
  1. Nice lay out the only thing yours does not have that mine does is current mats in bank and how many i have on the market and how many i have in the bank (implants)

  2. This is great, thanks! I will be using it quite a bit when I get home. I have requests from friends for modifications to be used for other crew skills, but I think they’ll be able to do that. If they do, I’ll try and get them to send you a copy.

    Also, I may be reading it wrong (or not enough), but is there a way to factor in materials cost from just sending out your companions to get the mats?

    • I have not done that yet. I have not been able to find enough data to lay any statistical foundation for those calculations. I have seen people log their mission cost and yield but much more data is needed for it to be accurate.

  3. The spreadsheet is great! I wish I had something like this for Cybertech.

    Any chance you’ll be making spreadsheets for other crafts?

    You know, if you turned this into an iPhone app, you’d make a killing.

    • I aim to make something similar for all the crew skills as I progress through them. The problem right now is that the item databases out there right now does not contain much info on crafted items and schematics learned from reverse engineering. Most of the info you need has to be gathered the hard way.
      Even though I am a software developer I don’t have any experience developing for the iOS platform. It is something I will look into even though I don’t know where to start – for instance what SDKs do I need for that and will I need an iOS platform to test and debug the software?

  4. This is great, I don’t have Biochem but I like the idea. Could I take your spreadsheet and attempt to modify it for cybertech for my own personal use?


Leave a comment

No trackbacks yet.