Setting up PI

Good day all,

Need some advice here.

I have 3 chars that can run 5 planets each. I need a supply chain to produce one of the below P4’s.
I’m looking for someone experienced in this to give me an exact setup I can use to properly streamline this.

I’ve seen a few tools online, but nothing that will show me exactly what to do with each planet/character.

I’ve avoided P4 as long as possible. :slight_smile: But our corp has a need and it’s time to get on the wagon…

Broadcast Node
Organic Mortar Applicator
Wetware Mainframe
Recursive Computing Module
Integrity Response Drones

sample T4 chain.

do your math.

PS: with 3x3 alts * 5 Planets i managed to build T4 by myself. with only 3 alts noway. Only with buy stuff.

some crazy excel sheets (multilanguage ftw) :stuck_out_tongue_winking_eye:

EveSDE SQL Query to get material sum

declare @TypeName as nvarchar(200) = 'Wetware Mainframe';

with MaterialList AS
(
SELECT map.typeID as TopTypeID, map.quantity as QuantityOut, map1.typeID, map1.schematicID, map1.quantity as QuantityIn, map.isInput, 1 AS MaterialLevel
FROM 
planetSchematicsTypeMap map
INNER JOIN planetSchematicsTypeMap map1 ON map.schematicID = map1.schematicID AND map1.isInput = 1
WHERE 
map.typeID = 2876 and map.isInput = 0
--2876
UNION ALL


SELECT smap.typeID as TopTypeID, smap.quantity as QuantityOut, smap1.typeID, smap1.schematicID, ml.QuantityIn / smap.quantity * smap1.quantity as QuantityIn, smap.isInput, ml.MaterialLevel +1 AS MaterialLevel
FROM 
planetSchematicsTypeMap smap
INNER JOIN MaterialList ml ON smap.typeID = ml.typeID AND smap.isInput = 0
INNER JOIN planetSchematicsTypeMap smap1 ON smap.schematicID = smap1.schematicID AND smap1.isInput = 1
)

select ml.typeID, t.typeName as ItemIn, sum(ml.QuantityIn) as QuantityIn, sum(ml.QuantityIn) / 24000 as Scale

from MaterialList ml 
LEFT JOIN invTypes t ON ml.typeID = t.typeID

where ml.MaterialLevel = 4
group by ml.typeID, t.typeName
order by ItemIn

GO

#material chain
declare @TypeName as nvarchar(200) = 'Wetware Mainframe';


with MaterialList AS
(
SELECT map.typeID as TypeIDOut, map.quantity as QuantityOut, map.quantity as ProductionQuantity, map1.typeID TypeIDIn, map1.schematicID, map1.quantity as QuantityIn, map.isInput, 1 AS MaterialLevel
, ROW_NUMBER() OVER (
	ORDER BY map1.typeID
   ) RowNr
FROM 
planetSchematicsTypeMap map
INNER JOIN planetSchematicsTypeMap map1 ON map.schematicID = map1.schematicID AND map1.isInput = 1
WHERE 
map.typeID = 2876 and map.isInput = 0
--2876
UNION ALL


SELECT smap.typeID as TypeIDOut, ml.QuantityIn as QuantityOut, smap.quantity as ProductionQuantity, smap1.typeID TypeIDIn, smap1.schematicID, ml.QuantityIn / smap.quantity * smap1.quantity as QuantityIn, smap.isInput, ml.MaterialLevel +1 AS MaterialLevel
, 10 * ml.RowNr + ROW_NUMBER() OVER (
	ORDER BY MaterialLevel, smap1.typeID
   ) RowNr

FROM 
planetSchematicsTypeMap smap
INNER JOIN MaterialList ml ON smap.typeID = ml.TypeIDIn AND smap.isInput = 0
INNER JOIN planetSchematicsTypeMap smap1 ON smap.schematicID = smap1.schematicID AND smap1.isInput = 1
)

select t2.typeName as ItemOut, ml.*, t.typeName as ItemIn from MaterialList 
ml 
LEFT JOIN invTypes t ON ml.TypeIDIn = t.typeID
LEFT JOIN invTypes t2 ON ml.TypeIDOut = t2.typeID

order by ml.MaterialLevel, ItemOut, ml.TypeIDIn


GO

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.