These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
12Next page
 

looking for resource to find blueprints only using low-end minerals
Author
Previous Topic Next Topic
Elijah Sokarad
Slate Group
#1 - 2013-05-28 22:35:05 UTC
I have looked at numerous production calculators and couldn't find quite what I'm seeking.

Anybody know of a website that allows one to filter out blueprints that don't require high-end minerals like megacyte and zydrine, for example. Basically, looking for blueprints a beginner could make with high-sec ores. Thanks for any help.
Mari Hata
Main Street Crafts and Goods
#2 - 2013-05-28 23:12:21 UTC
Apart from T1 ammo, you mean?

(The mining of free minerals is strong with this one...)

♫ ♪ ♪
Elijah Sokarad
Slate Group
#3 - 2013-05-29 00:23:25 UTC
Assumptions wrong you make....

I understand the opportunity cost of mining my own minerals, so I don't much do that. I simply find myself with an excess of high sec minerals from reprocessing junk modules and don't want to slog through a bunch of individual blueprints trying to find one I can make with the excess.
RubyPorto
RubysRhymes
#4 - 2013-05-29 00:46:28 UTC
Mari's point is that you're better off finding what BPOs are most profitable, and selling low end minerals to purchase the high end minerals you need.


That said, I'm sure an appropriate query to the data dump would help you find the information you're looking for.

"It's easy to speak for the silent majority. They rarely object to what you put into their mouths." -Abrazzar "the risk of having your day ruined by other people is the cornerstone with which EVE was built" -CCP Solomon
Lfod Shi
Lfod's Ratting and Salvage
#5 - 2013-05-29 01:55:56 UTC
Ammo. Also people always need more.

♪ They'll always be bloodclaws to me ♫
Adunh Slavy
#6 - 2013-05-29 04:15:29 UTC
passive targeters, trit only, I think

Necessity is the plea for every infringement of human freedom. It is the argument of tyrants; it is the creed of slaves.  - William Pitt
Mari Hata
Main Street Crafts and Goods
#7 - 2013-05-29 07:05:47 UTC
Or shuttles. Lots of shuttles too.

♫ ♪ ♪
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2013-05-29 08:00:32 UTC
Right now, I don't believe there are any sites that do that. In part because it's a trifle more complex than you might think, due to the way the materials are stored.

I'll have a poke at it when I get into the office (work? what's that?) and see about creating a spreadsheet.

Just Trit, Pye, Iso, Mex and Nocx, right?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Elijah Sokarad
Slate Group
#9 - 2013-05-29 09:46:36 UTC
Those materials are what I had in mind.

Please don't go to too much trouble on my account, though - I was just hoping that a resource already existed.
Lyza Kimbo
Native Freshfood
Minmatar Republic
#10 - 2013-05-29 17:05:03 UTC
Core scanner probes. Combat scanner probes take fancy stuff, but core probes are easy to make.

Then if you do some missions for Sisters of Eve, you can use the LP to swap the probes you made for Sisters probes and sell those.

The real money, however, is in the Sisters probe launchers.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2013-05-29 17:41:40 UTC  |  Edited by: Steve Ronuken
I could have sworn I'd posted this earlier.

http://www.fuzzwork.co.uk/resources/lowonly.txt

Typeid, item that can be made only with low end minerals.

select typeid,typename from invTypes,invBlueprintTypes where invTypes.typeid not in (select distinct typeid from invTypeMaterials where materialtypeid not in (34,35,36,37,38)) and invTypes.typeid=invBlueprintTypes.producttypeid and published=1 and invBlueprintTypes.blueprinttypeid not in (select distinct ramTypeRequirements.typeid from ramTypeRequirements,invTypes,invGroups where activityid=1 and requiredTypeid=invTypes.typeid and invTypes.groupid=invGroups.groupid and invGroups.categoryid!=16);



Edit: Don't use this query. It's paying no attention to the published state of the blueprint. Use the query further down, which also corrects an issue with extra materials. Smile

Huttan Funaila was right to mail me about it Smile I'd already fixed it, by the time I saw the mail, but he was still right about it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Huttan Funaila
Caldari Provisions
Caldari State
#12 - 2013-05-29 18:33:04 UTC
Here is a query that may produce what you are looking for:
Quote:
SELECT t.typeID, t.typeName, g.groupName
, tritanium = ISNULL(mt.quantity,0)
, pyerite = ISNULL(mp.quantity,0)
, mexallon = ISNULL(mx.quantity,0)
, isogen = ISNULL(mi.quantity,0)
, nocxium = ISNULL(mn.quantity,0)
, zydrine = ISNULL(mz.quantity,0)
, megacyte = ISNULL(mg.quantity,0)
FROM invTypes AS t
INNER JOIN invGroups AS g ON t.groupID = g.groupID
INNER JOIN invCategories AS c ON c.categoryID = g.categoryID
INNER JOIN invBlueprintTypes AS b ON b.productTypeID = t.typeID
LEFT JOIN invMetaTypes AS IMT ON IMT.typeID = t.typeID
LEFT JOIN invTypeMaterials AS mt ON mt.typeID = t.typeID and mt.materialTypeID = 34 -- 34 = Tritanium
LEFT JOIN invTypeMaterials AS mp ON mp.typeID = t.typeID and mp.materialTypeID = 35
LEFT JOIN invTypeMaterials AS mx ON mx.typeID = t.typeID and mx.materialTypeID = 36
LEFT JOIN invTypeMaterials AS mi ON mi.typeID = t.typeID and mi.materialTypeID = 37
LEFT JOIN invTypeMaterials AS mn ON mn.typeID = t.typeID and mn.materialTypeID = 38
LEFT JOIN invTypeMaterials AS mz ON mz.typeID = t.typeID and mz.materialTypeID = 39
LEFT JOIN invTypeMaterials AS mg ON mg.typeID = t.typeID and mg.materialTypeID = 40
WHERE b.techLevel = 1 -- Exclude T2 blueprints.
AND t.published = 1 -- You'd be surprised what is in the database and not-published. Or not.
AND mg.quantity IS NULL -- Consumes no zydrine.
AND mz.quantity IS NULL -- Consumes no megacyte
AND c.categoryID <> 25 -- Exclude ore compression blueprints
AND IMT.metaGroupID IS NULL -- Exclude meta items
AND (ISNULL(mt.quantity,0)+ ISNULL(mp.quantity,0)+ ISNULL(mx.quantity,0)+ISNULL(mi.quantity,0)+ISNULL(mn.quantity,0))>0

The results includes a few things that you can only refine (civilian stasis web, for example) or things you will never ever see a blueprint for (for example: Utu).

I don't think it includes extra materials.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#13 - 2013-05-29 18:51:57 UTC  |  Edited by: Steve Ronuken
I've just updated the output file, to restrict it to blueprints which are marked as published.

select invTypes.typeid,invTypes.typename from invTypes,invBlueprintTypes,invTypes it2 where invTypes.typeid not in (select distinct typeid from invTypeMaterials where materialtypeid not in (34,35,36,37,38)) and invTypes.typeid=invBlueprintTypes.producttypeid and invBlueprintTypes.blueprinttypeid not in (select distinct ramTypeRequirements.typeid from ramTypeRequirements,invTypes,invGroups where activityid=1 and requiredTypeid=invTypes.typeid and invTypes.groupid=invGroups.groupid and invGroups.categoryid!=16 and requiredTypeid not in (34,35,36,37,38)) and invBlueprintTypes.blueprinttypeid=it2.typeid and it2.published=1

It knocks out around 90 items. (including the Utu Blink )

It pays attention to extra materials, but removes any blueprints which contain anything other than the low-end materials (14 blueprints have only the low ends in their extra materials. like the freight containers)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Termy Rockling
Sebiestor Tribe
Minmatar Republic
#14 - 2013-05-30 01:11:14 UTC
Even if you mine hisec minerals you really really should make PROFITABLE items, not just items which use only hisec minerals. The amounts you need the low and null minerals are really small, so just buy them.
Also browse the forum on guides about industry in general, thats if you want to actually make isk.
Elijah Sokarad
Slate Group
#15 - 2013-05-30 09:51:39 UTC
Thank you to all who contributed to this discussion, particularly Steve.

Always interesting discussions to be had on the Eve forums, no matter where one stands on the particular questions involved.
Tinu Moorhsum
Random Events
#16 - 2013-05-30 11:30:31 UTC
Elijah Sokarad wrote:
Assumptions wrong you make....

I understand the opportunity cost of mining my own minerals, so I don't much do that. I simply find myself with an excess of high sec minerals from reprocessing junk modules and don't want to slog through a bunch of individual blueprints trying to find one I can make with the excess.


Why don't you just sell your access and use that money to buy other minerals that you need? You might find you'll make more money doing this too because you'll be able to build what is in demand instead of building what you have stuff for.



Bugsy VanHalen
Society of lost Souls
#17 - 2013-05-30 13:54:56 UTC
Lyza Kimbo wrote:
Core scanner probes. Combat scanner probes take fancy stuff, but core probes are easy to make.

Then if you do some missions for Sisters of Eve, you can use the LP to swap the probes you made for Sisters probes and sell those.

The real money, however, is in the Sisters probe launchers.

Not any more.

With Exploration being dumbed down id odyssey sisters launchers will no longer have a big advantage. An unbonused ship with meta 0 launchers and decent skills can find anything quite easily. Dedicated scanning ships with faction equipment will no longer be needed, and offer little advantage to those who already have them..
Haulie Berry
#18 - 2013-05-30 14:53:35 UTC  |  Edited by: Haulie Berry
Bugsy VanHalen wrote:
Lyza Kimbo wrote:
Core scanner probes. Combat scanner probes take fancy stuff, but core probes are easy to make.

Then if you do some missions for Sisters of Eve, you can use the LP to swap the probes you made for Sisters probes and sell those.

The real money, however, is in the Sisters probe launchers.

Not any more.

With Exploration being dumbed down id odyssey sisters launchers will no longer have a big advantage. An unbonused ship with meta 0 launchers and decent skills can find anything quite easily. Dedicated scanning ships with faction equipment will no longer be needed, and offer little advantage to those who already have them..


I keep seeing people say **** like this, as if it is somehow a departure from the status quo on TQ.

The scanning math in Odyssey is very nearly identical to what we have on TQ. The bulk of the changes are in the UI, and there is a very very slight increase in scanning power contributed by skill, resulting from 1.25^2 being > 1.5 (about a 4% increase).

An unbonused ship with meta 0 launchers and decent skills can already find most signatures quite easily on TQ, and excepting that 4% increase, this is not changing in Odyssey.

There are new modules that offer other ways to boost your scanning power, but given the choice between sacrificing a mid slot and using some faction probes/launchers, there's very, VERY little reason to use the new modules except on dedicated scanning ships (most likely combat scanners - not PvE ones).

There is one change that will have an adverse effect on the probe market, and that's the auto-recall of probes when their duration expires or when the pilot leaves the system. Probes will almost never be accidentally lost anymore, which will reduce demand somewhat.

Given that the math isn't changing in any appreciable way, though, if you're currently using faction launchers and probes for the extra strength they provide, there's basically no reason to quit doing that. You already don't NEED to do it, and it will still allow you to scan down sigs faster and from a larger probe radius.
Skorpynekomimi
#19 - 2013-05-30 20:46:28 UTC
Why not just buy high-end minerals off the market?

Of course, then you'd be actually an industrialist and not just making things on the side. And you'll end up with that as your major profession rather than what generates the low-ends you've got.
So then your main profession is just subsidising the industry, and you're no longer a mission runner or an explorer.

Economic PVP
Frostys Virpio
State War Academy
Caldari State
#20 - 2013-05-31 17:23:14 UTC
Can make all L and XL ammo except missile. Clear bias against missile user...

:D
12Next page