Science & Industry

o7,

some day in the past i said to myself to make a BPO collection of every BPO in game on 10/20 (reason: just because). Now i am approaching the 500 BPO mark and i struggle more and more to keep oversight over which BPOs i own and which not (as in which i need to buy next).

Now i am pretty sure there is a way to do this via SDE, spreadsheets and assets API to get two list with one showing my owned BPOs and one showing the existing BPOs which can be compared and automatically removing (or anything similar) the owned from the existing

I just don´t really know much about that stuff. Someone of you can tell me/hint me into a direction on how to do that?

But can it filter the BPOs i own from the BPOs that are existing ingame so i can see which BPOs i still have to buy?

The last time I went through my DVD and BlueRay collection, I found I have at least 4 copies of Ultra Violet.

A friend asked me to sell all his industry assets. I think I sold at least 80 billion ISK or more worth of stuff, before he told me to keep the rest.

Those BPO and BPC haunt me to this day. There was a LOT of them. So many different levels of research. So many duplicates.

I've not found anything to help inventory them to my satisfaction. It is really hard, as most programs can't adequately inventory items in personal hangars, select corporate office hangars, nor select POS hangars. Containers can also be an issue.

I've mostly just avoided looking at them, to avoid an OCD flare-up.

jEveAssets might work...
You could create an List with all existing BPOs in game --> Export to excel or something else
Filter your assets to fully researched BPO --> Export to same excel, different worksheet

Compare both sheets, remove duplicates or VLOOKUP Function... something like that.

It isn't that pretty, but should give you the results you'd like to have

Your BPOs...Are they in Corp hangar or personal hangar?
I have a Google sheet that checks item not listed for sale in the station of my choice.
Just to need to modify the API call and it will do what you need

I think you can filter them...
Category "Blueprint" AND
Name contains "I Blueprint" AND
Name not contains "II Blueprint" AND
"Base Price > 0,00"
or something like that. Should filter all the copies, T2, faction stuff out.

This for example will not show any ships or capital parts (not named like I Blueprint)...
Ships might be a little pain, but as a "long-time" player with some experience sorting T1 from T2 should be easy.
You have to play around with the filters. I have several filtersettings saved so i can switch immediately between Mods, Ships, Rigs, Ammo, etc.

It's a little bit of initial work, though quite useful for the future.


I also made a filter for "Selling vs. Reprocessing". A lot of loot and stuff which is not worth selling can be reprocessed to clean assets a little bit
But that's another story

@Jewel Crown
I tried that all. played around with the filters for half an hour.

Filtering "II" does work.
Filtering "I" to show T1s exclude all ammo, ships.
Filtering ">0,00" still includes nearly all Augmented drones which amusingly have a price attached to it like some storyline BPCs too. (Btw: wtf is an "Amarr Police Frigate" and why is there a blueprint for it?)
I mean it´s doable with filters but i think i will have a list of filters long enough for 3 screens...

That why i initially thought about getting a csv from all the blueprints in game as afaik there are BPOs and BPCs easily to distinguish as they´re somehow marked with 0 and 1 (can remember that from trying to set up a production spreadsheet once). This way it would be way less of a pita.

@Professor Humbert
No it doesn´t show max run.

just returned from a long break, but i used to do something like you are asking about with IPH.

As i have not started up my industrial side yet i am unaware if it will Work or not anymore (still getting back into everything Again)

if i remember correctly it has all stuff you can build and you can mark/sync the BPOs you have into it. so looking at the large list of stuff to build you could clearly see if you had the bpo and how well it was researched.

Again i can not confirm if this still Works or not but that about what i did if memory serves correct.

Since you've already started making your own, i won't modify my aforementioned google sheet.

Instead, would this kind of list help?

BPTypeID    BPTypeName    activity1ProductID    activity1ProducMetaGroupID
681    Clone Grade Beta Blueprint    165    0
682    Clone Grade Gamma Blueprint    166    0
683    Bantam Blueprint    582    0
684    Condor Blueprint    583    0
685    Griffin Blueprint    584    0
686    Osprey Blueprint    620    0
687    Caracal Blueprint    621    0
688    Raven Blueprint    638    0
689    Slasher Blueprint    585    0
690    Probe Blueprint    586    0

You can see from the sheet that the filtering logic behind is:
If a Blueprint can be ME researched (according to CCP DB dump) and its manufacturing product is of none- metaGroupID (i.e. no T2, faction, storyline stuff) then the Blueprint is most likely an Original.

It's not perfect. Things like Ashimmu slips through because the DB dump says Ashimmu blueprint can be copied and researched. Nevertheless, I hope this be a good starting point.

I have made a spreadsheet that does something like this. It's not incredibly robust but it does the following:

1) Creates a sheet with all of the blueprints I own
2) On another sheet, I have a list of all blueprints.
3) The following columns on the BP List: Owned, ME, TE

If I own the blueprint it will say 'yes', it will also grab the ME/TE of the blueprint and display it. I haven't updated it in a while, but it's something that can be updated quite easily. It's a google Spreadsheet using some google code to handle the data stuff. If you're interested I can help you out with it :)