open All Channels
seplocked Science and Industry
blankseplocked Materials used for all BPO on excel sheet
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

awerwer
Posted - 2010.08.13 08:56:00 - [1]
 

Is there a website that has info for the material it needs for all BPO and any other manufacturing/research jobs? I know that EveHQ has a way of checking this info but it's only one at a time and not easily extracted on Excel. I need all BPO data all in excel all at once. Hopefully this data is avaialable.

Sepi
Wiyrkomi Supplies LTD
Posted - 2010.08.13 11:06:00 - [2]
 

i think your going to have a problem, given that there are 100s, if not 1000s of BPO's in game, then each bpo will not have a 'definative' material amount,

Just take 1 BPO say Megathron it could have over 10,000 varients of minerals required depending on ME level.

Hwoever if all you want is the base meterial before any research then im sure the EVE Dump would have that, check in the science 'n' indi forum, someone in there is more likely to know where it is

Kryss Stevenson
Caldari
Red Stallion Mercantile and Manufacturing
Posted - 2010.08.13 11:59:00 - [3]
 

You might want to check in the Blueprint Browser tab in EVEMON. It looks like they have most if not all of the blueprints and you can change the ME value to what you want.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2010.08.13 12:03:00 - [4]
 

You should ask your question in the Tech Lab forum. I'm pretty sure it has been asked there before and you might be able to find the relevant topic via eve-search.com.

Regis Nex
Posted - 2010.08.13 12:11:00 - [5]
 

When all else fail.

EVE-MEEP

SencneS
Rebellion Against Big Irreversible Dinks
Posted - 2010.08.13 14:10:00 - [6]
 

There is this website..

You can get the data two different ways..

1) Look at each BPO and mark down the items it needs. example
2) Look at each item and see if it's used in any BPOs. example

Both ways are time consuming :)

sdfdfgertertw
Posted - 2010.08.13 16:13:00 - [7]
 

Edited by: sdfdfgertertw on 13/08/2010 16:13:21
Well yes, exactly time consuming. That's why I needed it ALL on an excel spreadsheet. :) I'm not looking to check one at a time. I need them all on a spreadsheet so I can do a vlookup and see how much each would cost me based on current market values. And yes, I only need base values. I can change the ME values easily on excel after that.

SencneS
Rebellion Against Big Irreversible Dinks
Posted - 2010.08.13 16:27:00 - [8]
 

Originally by: sdfdfgertertw
Well yes, exactly time consuming. That's why I needed it ALL on an excel spreadsheet. :) I'm not looking to check one at a time. I need them all on a spreadsheet so I can do a vlookup and see how much each would cost me based on current market values. And yes, I only need base values. I can change the ME values easily on excel after that.


Pay me 1 Billion ISK and I'll do, you'll have the EXCEL next week some time.

Tekota
The Freighter Factory
Posted - 2010.08.13 17:21:00 - [9]
 

Akita had a very nice sheet for T1 (and T2 too? can't remember) at http://www.eveonline.com/ingameboard.asp?a=topic&threadID=993762

It might be a tad out of date now, not sure but it's definitely still accurate for a bunch load of T1.

Lucyna
Interstellar Killer Bee Enterprises
Posted - 2010.08.13 18:13:00 - [10]
 

Originally by: SencneS


Pay me 1 Billion ISK and I'll do, you'll have the EXCEL next week some time.

I'll do it for 900M.

Let the bidding war begin Laughing

sdfdfgertertw
Posted - 2010.08.13 19:21:00 - [11]
 

Originally by: Tekota
Akita had a very nice sheet for T1 (and T2 too? can't remember) at http://www.eveonline.com/ingameboard.asp?a=topic&threadID=993762

It might be a tad out of date now, not sure but it's definitely still accurate for a bunch load of T1.


uh, i dont think this has everything on excel does it? i see a program that calculates stuff, but no material costs on excel. i dont need a program to calculate anything. i just need one excel sheet that has all info for costs. thats it.

Tekota
The Freighter Factory
Posted - 2010.08.13 19:43:00 - [12]
 

Oooh I see what you're getting at, misinterpreted first time.

Best I can offer is my current T1 basket based on the 10 lines I was running a week or so back. Whether this is anything like approaching the basket across all T1 blueprints I couldn't say but I guess better than a basket of one line alone.

Iso: 1.06%
Meg: 0.03%
Mex: 4.87%
Noc: 0.23%
Pye: 18.75%
Tri: 74.97%
Zyd: 0.08%

Note that the above is a units used basket percentages spread across 10 lines - not a price basket.

SencneS
Rebellion Against Big Irreversible Dinks
Posted - 2010.08.13 20:21:00 - [13]
 

Originally by: Lucyna
Originally by: SencneS


Pay me 1 Billion ISK and I'll do, you'll have the EXCEL next week some time.

I'll do it for 900M.

Let the bidding war begin Laughing


It's all yours :) But don't sell yourself so cheap, this guy can easily do the same thing. What he wants will take a lot of time. His Laziness has to cost him, I'd change that to 999,999,999.99 ISK. It's no small task :)

sdfdfgertertw
Posted - 2010.08.13 21:09:00 - [14]
 

Originally by: SencneS
Originally by: Lucyna
Originally by: SencneS
quote]

It's all yours :) But don't sell yourself so cheap, this guy can easily do the same thing. What he wants will take a lot of time. His Laziness has to cost him, I'd change that to 999,999,999.99 ISK. It's no small task :)


It's not about being lazy or small or big tasks. It's the fact that eve has been around for years now and there has to be someone who has already wanted this information so I'm sure it can be found somewhere. why reinvent the wheel twice.

sdfdfgertertw
Posted - 2010.08.13 21:11:00 - [15]
 

Originally by: Tekota
Oooh I see what you're getting at, misinterpreted first time.

Best I can offer is my current T1 basket based on the 10 lines I was running a week or so back. Whether this is anything like approaching the basket across all T1 blueprints I couldn't say but I guess better than a basket of one line alone.

Iso: 1.06%
Meg: 0.03%
Mex: 4.87%
Noc: 0.23%
Pye: 18.75%
Tri: 74.97%
Zyd: 0.08%

Note that the above is a units used basket percentages spread across 10 lines - not a price basket.


I have no idea what this is. I basically need the material cost of say Ferox Blueprint for example. That will have certain amount of tri required, zyd, pye, noc. etc. But I need this in excel form. There is a way for me to do it, but it would take awhile. Just thought there would be this info already somewhere so I don't have to reinvent wheelie twice.

Estel Arador
Posted - 2010.08.14 00:35:00 - [16]
 

Originally by: sdfdfgertertw
I basically need the material cost of say Ferox Blueprint for example. That will have certain amount of tri required, zyd, pye, noc. etc. But I need this in excel form. There is a way for me to do it, but it would take awhile. Just thought there would be this info already somewhere so I don't have to reinvent wheelie twice.

Akita T's sheet (linked to above) has exactly that information, and it's even in legible form (not just item IDs, but also item descriptions). If your spreadsheet-fu is up to par, you should be able to take that information and put it in whatever form you like.

In my view/experience spreadsheets are very personal, formed to fit the creator's needs and follow the creator's thoughts. I've made my own spreadsheet which does exactly what I want, how I want. It essentially does the same thing Akita T's sheet does, only in a slightly different way (my way). I would never give, share or sell my spreadsheet to anyone.
I can't speak for anyone else, but given the overwhelming response to your request, you might conclude that others feel the same way.


Hari Markkus
Deep Core Mining Inc.
Posted - 2010.08.14 00:49:00 - [17]
 

Originally by: Sepi
i think your going to have a problem, given that there are 100s, if not 1000s of BPO's in game, then each bpo will not have a 'definative' material amount

You just take that into account in the spreadsheet. You start with an unresearched BP and specify the ME/PE and it is just sums to work out the actual material requirements.

It has been done several times before, its just a pity the search on these forums is so bad. If only there was a way of searching all public websites...

sentinel22uk
Super Batungwaa Ninja Warriors
Posted - 2010.08.14 02:46:00 - [18]
 

www.battleclinic.com and download EVEHQ, it has a bpo calculator with market price updates.

Mail me in game if you need help.

CCP Applebabe

Posted - 2010.08.16 05:31:00 - [19]
 

Moved from Market Discussions.

Lutz Major
Posted - 2010.08.16 07:39:00 - [20]
 

As you don't give up on finding an excel sheet with a complete material list, I'll try to enlighten your knowledge:

There are over 2600 blueprints (including T1, T2, T3, LP and COSMOS prints) in EVE. To build these, you need about 950 different components.

Nobody wants to cypher through this amount of data! Really! The human mind cannot handle so much information with efficiency use. Even Excel 2003 will not co-operate because of its limitation for 256 columns.

To have a long story short: There is a reason why web pages or any other tool will only show 'some' data.


But I think, I know what you want: You are not interested in the material list per se, you want to enter prices and see the most profitable item to build. Good idea, but nobody will share his success. Another competitor means smaller margins. Here a tip: learn how to program and do it yourself .... or send me 1 billion ISK and you can have such a spreadsheet within 24 hours Very Happy

Tonto Auri
Vhero' Multipurpose Corp
Posted - 2010.08.16 13:54:00 - [21]
 

What about EVE Master Sheet?

Sidrat Flush
Caldari
Eve Industrial Corp
Posted - 2010.08.17 00:32:00 - [22]
 

What about Eve Industrial Organiser.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only