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)
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