Ratting & Loot

[Rubino]

Guys,

I need some people to do a mundane but handy information gathering task.
Can people rat and gather all the loot dropped for an hour or two and then report back:

1) The number of NPC spawns they encounted
2) A summary of the loot (not salvage) they received

Something like:

14th April 2009

NPC's: 25
100mn Afterburner I x 9
800nm Rolled Tungston Plate x 4
Defender Missiles x 600

evemail or forum post is fine.  You don't need to collect all the loot - just record what was found including all wrecks (both large and small).
This is to find out what drops and to determine if we're missing anything that could be reprocessed by the corp efficiently.

Thanks.

[Mangala]

Every Rat drops bloody reppers

[peo]

Frigate   8
Cruiser   12
Battleship   9
   
Large Tungsten Charge   1
ION Blaster cannon   1
100MN Afterburner   4
Praetor   4
Micro EM Hardener   1
Large Ld-Acid Capacitor Battery   1
Large Plutonium Charge   3
Large Thorium Charge   2
800mm reinforced titanium armour plates   1
800mm steel armour plates   1
Large Uranium Charge   2
Cap Booster Charge 400   2
Berserk   3
100MN MWD   2
Large Capacitor Battery   3
Heavy Capacitor Booster   4
50mm Titanium armour plates   2
Small Capacitor booster   1
Hornet   1
Acolyte   1
Hammerhead   5
1MN AB   5
Large F-4a Ld-Sulfate I capacitor charge unit   1
Voltaic Thermal hardener   1
Remote sensor booster   1
Small Nos   3
survey scanner   3
FZ-3 Subversive ECM   1
cargo scanner   1
small energy transfer   3
small shield booster   2
200mm titanium armour plates   1
Shielded Magnetometric backup cluster    1
Magnetic Field stabilizer   1
Tracking computer   1
Med 'Arup' I remote bulvark recontructor   1
Med remote armour repair   2
ship scanner   2
medium shield booster   4
Small uranium charge   1
small iron charge   1
Cap booster charge 800   1
Voltaic EM hardener   1
Large 'accomodation' vestment recontructer    1
Electron blaster   2
Large Iron Charge   2
800mm reinforced steel plates   2
N-Type Thermic Hardener   1
Magnetometric Backup Array   3
Large Remote Armour Repair system   1
Monopropellant I hydrazine boosters   1
ECM - Spatial Destabilizer I   1
Heavy Neutron Blaster I   1
Prototype I Freight Sensors   1
Heavy Neutron Blaster I   1
Remote Sensor Dampener I   1
1600mm reinforced titanium plates   1
Small Brief Capacitor Overcharge I    1
Small Energy Neutralizer I    1
Small Coaxial Regenerative Projector    1
Cargo Scan ECM Burst I    1
ner I   1
Expanded Cargohold I    1
250mm Railgun I    1
Medium Proton Smartbomb I   2
200mm Reinforced Steel Plates I    1
ECCM - Magnetometric I    1
Iridium Charge M    1
Medium Brief Capacitor Overcharge I    1
F-392 Baker Nunn Targeting Scrambler    1
Faint Warp Disruptor I    1
Iron Charge M   1
200mm Reinforced Nanofiber Plates I    1
Medium Armor Repairer I    2
200mm Railgun I   1
Stasis Webifier I   1
Energized Basic Reflective Plating    1
Wasp I   1
250mm Railgun I    1

[Rubino]

Thanks - will take a look at the vast list and see what's best to scoop for reprocessing.

[Rubino]

While I need to plug the above into my query attached are the top 114 items (with an attempt to remove faction items) based on the amount of Zyd it produces pu.

The criteria used:
a) >10 Zyd pu
b) available items only
c) volume <= 50 m3
d) not a faction item

[Rubino]

And for those of you with the Apoc data dump and like playing with SQL queries:

select
  typeName, quantity as "ZydQuantity"
from
  typeActivityMaterials
join
  invTypes
    on invTypes.typeID = typeActivityMaterials.typeID
where
  requiredTypeID = 39
  and quantity > 10
  and activityID=6
  and published = 1
  and volume <= 51
  and (
     (typeName not like '%II%')
    and (typeName not like  '%Sanshas%')
    and (typeName not like  '%Blood%')
    and (typeName not like  '%Modified%')
    and (typeName not like  '%Dread%')
    and (typeName not like  '%Gist%')
    and (typeName not like  '%Pith%')
    and (typeName not like  '%Coreli%') 
    and (typeName not like  '%-Type%') 
    and (typeName not like  '%Domination%')
    and (typeName not like  '%Navy%')
    and (typeName not like  '%Fleet%')
    and (typeName not like  '%Ore%') )
order by
  quantity desc

[Rubino]

ok - filtered by the loot list from Hrod with a little fuzzy matching and removed anything factional/officer.
The spreadsheet includes Zyd, Nocx & Mega