How are people loading their blueprints for use in industry?
My ideal plan would be to have something that looks like:
But I’m not sure how to reproduce this using .BLUEPRINT_EXPLOSION(634).
Well, the cells in green I can (for a single item), but it’s the repeating of the product id that I’m stuck. As mentioned, I can do this for a single item but not for multiple. I know the formula can handle arrays but this just bundles all the materials together.
Any advice?
Thanks.
-Bear
Bear,
I am not certain I understand.
You want to make 7 exequrors using Exequror Blueprint?
Add a quantity field then at the end add a column for qty* amounts.
Of course, none of this is taking into account the station’s bonuses, The ME/PE, skill levels, etc etc etc 
No this isn’t about making 7, it’s about repeating the ID (and name, but less bothered by that) for the item whilst listing all the materials.
In my screenshot, the cells in green are, with some intermediate steps, what results when using the .BLUEPRINT_EXPLOSION() function. However, you do not then get the other 6 IDs for the Exequeror (634). I had to add these in to demonstrate my aim.
This way I can sum all the materials across the various items I am building. I know about ME, structure, rig adjustments etc, but this is for now just getting the raw data into a format for later use.
My plan so far has just been manually putting in blueprint values, as I was only using a few, and adding new ones here and there so that wasn’t really much of an issue. However, I’ve just noticed that material requirements had changed for some items and thus realised I need to automate this process.
As an intermediate alternate solution, I have downloaded ‘industryActivityMaterials’ from Fuzzworks SDE. This is what I am trying to recreate using the Excel add-in as even downloading the SDE still relies on manual updates.
