Eve Tools Planetary Interaction Spreadsheet

Posted on  by 

A tool for planning out PI chains in Eve Online. Easier than spreadsheets, I promise.

Posted by5 years ago
Archived

Dear /r/Eve,

  • Planetary Interaction - spreadsheet v0.1. So, armed with with the in game PI information and a tool Eve Planetary Planner, I created this spreadsheet.
  • News — Added sticky on click / click sticky again to unsticky — — I've plans to move this to github and add calculations, hold off on feature request —.
Chart

I'm very proud to present you with the first beta release of RubyPI, a planetary interaction program like EFT or PyFA.

Awesome Features:

  • Create, edit, delete planets like some kind of demigod

  • Force planet laborers to create buildings and links for you

  • Spawn products inside buildings or expedited transfer them with fewer clicks than TQ

  • Set POCO tax rates and import/export products to launchpads with built-in tax calculations

  • See at a glance what each planet is producing

  • Share your PI configurations with your friends on /r/EVE using the YAML import and export

  • Open source

How do I get it?

All the details are at the GitHub project page. Please report any bugs or feature requests there.

Dev Comments:

Let's face it. Planetary Interaction is a good, steady moneymaker, but damn it's painful to set up and maintain. I've been thinking long and hard about this problem and I finally decided that I could contribute best to the community (and work on my Ruby skills) by creating an out-of-game application for building and testing PI layouts.

This release, 0.1.0, is a beta; I've been testing it quietly with my corpmates for a few months. There's a lot more features to come, but I think it's ready for day to day use. While I can't promise it won't melt all your Rifters, I'm fairly confident it will work on whatever OS you prefer.

If anyone has the desire to do testing and bug reporting for OSX, that's the one operating system I don't have reliable access to.

Eve Planetary Interaction Tool

Eve tools planetary interaction spreadsheets

Eve Tools Planetary Interaction Spreadsheets

Can I Throw You Some ISK?

ISK donations can be sent to 'Biterno Sintaph'.

52 comments
ABCDEFGHIJKLMNOPQRSTUV
Don't miss the links to the other sheets! Bottom Line! ↓ ↓ ↓ ( 1. PI Production / 2. Planets / 3. Skills / PI Structures / Step by Step / 4. Error Messages / 5. Official / Schematics) ↓ ↓ ↓
2
PI Spreadsheet short link:http://4WARDeve-pi.notlong.comhttp://pi.4ward-eve.ch/(An EVE Tyrannis PI IGB tool maintained for you by 4WARD Inc.)
4
Extractor Resource R → Basic Industry Facility Product P1Planet Types
PlanetsMaterial Flow:
Aqueous LiquidsWaterB G I O S T
B = Barrentier 1 R (P0) →→ P1Processed Raw Extractor Material => P1 (Processed Material)
6
AutotrophsIndustrial FibersTG = Gas ↓ ╠════ ════╗↓
Base MetalsReactive MetalsB G L P S
I = Icetier 2P2 ←← P1← P1P2 (Refined Commodities) <= P1+P1
8
Carbon CompoundsBiofuelsB O T
L = Lava →╚════════╦════════╦════════╗↓
Complex OrganismsProteins O T
O = Oceanictier 3P3 ←← P2← P2← P2P3 (Specialized Commodities) <= P2+P2+P2
10
Felsic MagmaSiliconL
P = Plasma →╚════════╦════════╦════════╗↓
Heavy MetalsToxic MetalsI L P
S = Stormtier 4P4 ←← P3← P3 ← P3P4 (Advanced Commodities) <= P3+P3+P3 (or P3+P3+P1)
12
Ionic SolutionsElectrolytesG S
T = Temperate
Micro OrganismsBacteriaB I O T
Material Quantities and Sizes:
14
Noble GasOxygenG I S
Input uTypeOutput uSizeCycle TimeStructurePlanetary Materials (Market Group)
Noble MetalsPrecious MetalsB P
Resource R (P0)var0.01m³varEXR Raw MaterialsChanged with v151614
16
Non-CS CrystalsChiral StructuresL P
3000u RProduct P120u0.38m³30min/1800sBasIFProcessed Materials/Consumer Products/Industrial Goods
Planktic ColoniesBiomassI O
2x (40u P1)Product P25u1.50m³60min/3600sAdvIFRefined Commodities
18
Reactive GasOxidizing CompoundG
2 or 3x (10u P2)Product P3 3u 6.00m³60min/3600sAdvIFSpecialized Commodities
Suspended PlasmaPlasmoidsL P S
(40u P1) + 2x (6u P3)Product P41u100.00m³60min/3600sHTPPAdvanced Commodities
20
3000 units20 units per cycle (1800s)or 3x (6u P3)Product P41u100.00m³60min/3600sHTPPAdvanced Commodities
22
Advanced Industry Facility Product P2 ←1. Input Product P12. Input Product P1Planet Types Exclusivity*
Input 1.(P1) + 2.(P1)*The minimum planet(s) you need at least for production.
Example Supercomputers (GS+LP): one G OR S planet PLUS one L OR P planet
Example Nuclear Reactors (T+L+P): one T PLUS one L PLUS one P planet
24
BiocellsBiofuelsPrecious MetalsB(BOT)+(BP)
Construction BlocksReactive MetalsToxic MetalsLP
(BGLPS) + (ILP)
26
Consumer ElectronicsToxic MetalsChiral StructuresLP
(ILP) + (LP)PI Structures:
CoolantElectrolytesWaterGS
(GS) + (BGIOST)CPUPowerStorageAbbr.Costs (ISKs)
28
Enriched UraniumPrecious MetalsToxic MetalsP
(BP) + (ILP)Command Center 0-5varvar500(P)CC
FertilizerBacteriaProteinsOT
(BIOT) + (OT)Extractor200800EXR45,000.00Changed with v151614
30
Gen. Enhanced LivestockProteinsBiomassO
(OT) + (IO)Basic Industry Facility200800BasIF75,000.00
LivestockProteinsBiofuelsOT
(OT) + (BOT)Advanced Industry Facility500700AdvIF250,000.00
32
Mechanical PartsReactive MetalsPrecious MetalsBP
(BGLPS) + (BP)High Tech Production Plant1100400HTPP525,000.00(Barren, Temperate only)
Microfiber ShieldingIndustrial FibersSiliconT+L(T) + (L)Storage Facility5007005000STO250,000.00
34
Miniature ElectronicsChiral StructuresSiliconL
(LP) + (L)Launchpad360070010000LPad900,000.00
NanitesBacteriaReactive MetalsB
(BIOT) + (BGLPS)
36
OxidesOxidizing CompoundOxygenG
(G) + (GIS)
Polyaramids Oxidizing Compound Industrial FibersG+T(G) + (T)Skills (Science):
38
PolytextilesBiofuels Industrial FibersT
(BOT) + (T)Remote Sensing (x1) Int,Mem250,000.00 ISK
Rocket Fuel Plasmoids ElectrolytesS
(LPS) + (GS)The ability to gather and analyze remote sensing data from satellites in orbit around
40
Silicate Glass Oxidizing Compound SiliconG+L(G) + (L) a planet and to produce proper calibrated surveys. Prerequisite - Science 3
Superconductors Plasmoids Water S
(LPS) + (BGIOST)Planetology (x3) Int,Mem1,000,000.00 ISK
42
Supertensile Plastics Oxygen BiomassI(GIS) + (IO)The understanding of planet evolution and the fundamentals of resource extraction. Prerequisite - Remote Sensing 3, Science 4
Synthetic Oil Electrolytes OxygenGS
(GS) + (GIS)Advanced Planetology (x5) Int,Mem7,500,000.00 ISK
44
Test Cultures Bacteria WaterBIOT
(BIOT) + (BGIOST)Advanced understanding of planet evolution and the fundamentals of resource Prerequisite - Planetology 4
Transmitter Plasmoids Chiral StructuresLP
(LPS) + (LP)extraction.
46
Viral AgentBacteria BiomassIO
(BIOT) + (IO)Command Center Upgrades (x4) Cha,Int500,000.00 ISK
Water-Cooled CPU Reactive Metals WaterBGS
(BGLPS) + (BGIOST)Each rank in this skill improves the quality of command facility available to you, in turn
48
5 units per cycle (3600s)40 units40 unitsallowing for a greater number of connected facilities on that planet.
Cannot be trained on Trial Accounts.
50
Interplanetary Consolidation (x4) Cha,Int500,000.00 ISK
Advanced Industry Facility Product P3 ←1. Input Product P22. Input Product P23. Input Product P2Planet Types ExclusivityInput 1.(P2) + 2.(P2) + 3.(P2)For each rank in this skill, you may install a command center on one additional planet, to a maximum of 6 planets. You can have only one command center per planet. Cannot be trained on Trial Accounts.
52
Biotech Research ReportsNanitesLivestockConstruction BlocksB+OT+LP(BIOT+BGLPS) + (OT+BOT) + (BGLPS+ILP)
Camera DronesSilicate GlassRocket FuelG+L(G+L) + (LPS+GS)Command Centers (* one for each type of planet)
54
CondensatesOxidesCoolantG
(G+GIS) + (GS+BGIOST)NameSizePowergridCPUCC Upgrades SkillBase Price
Cryoprotectant SolutionTest CulturesSynthetic OilFertilizerOT+GS(BIOT+BGIOST) + (GS+GIS) + (BIOT+OT)Basic 50 m³6000 MW1675 tf090.000 ISK
56
Data ChipsSupertensile PlasticsMicrofiber ShieldingI+T+L(GIS+IO) + (T+L)Limited 100 m³9000 MW 7057 tf1670.000 ISK
Gel-Matrix BiopasteOxidesBiocellsSuper ConductorsG+B+S(G+GIS) + (BOT+BP) + (LPS+BGIOST)Standard200 m³12000 MW12136 tf21.600.000 ISK
58
Guidance SystemsWater-Cooled CPUTransmitter BGIOST+LP(BGLPS+BGIOST) + (LPS+LP)Improved400 m³15000 MW17215 tf32.800.000 ISK
Hazmat Detection SystemsPolytextilesViral AgentTransmitterT+O+LP(BOT+T) + (BOT+O) + (LPS+LP)Advanced 800 m³17000 MW21315 tf43.700.000 ISK
60
Hermetic MembranesPolyaramidsGen. Enhanced LivestockG+T+IO(G+T) + (OT+IO)Elite1600 m³19000 MW25415 tf56.400.000 ISK
High-Tech TransmittersPolyaramidsTransmitterG+T+LP(G+T) + (LPS+LP)
62
Industrial ExplosivesFertilizerPolytextilesT
(BIOT+OT) + (BOT+T)
NeocomsBiocellsSilicate GlassB+G+L(BOT+BP) + (G+L)
64
Nuclear ReactorsMicrofiber ShieldingEnriched UraniumT+L+P(T+L) + (BP)+(ILP)
Planetary VehiclesSupertensile PlasticsMechanical PartsMiniature ElectronicsI+BP+L(GIS+IO) + (BGLPS+BP) + (LP+L)
66
RoboticsMechanical PartsConsumer ElectronicsP
(BGLPS+BP) + (ILP+LP)
Smartfab UnitsConstruction BlocksMiniature ElectronicsL
(BGLPS+ILP) + (LP+L)
68
SupercomputersWater-Cooled CPUCoolantConsumer ElectronicsGS+LP(BGLPS+BGIOST) + (GS+BGIOST) + (ILP+LP)
Synthetic SynapsesSupertensile PlasticsTest CulturesI(GIS+IO) + (BIOT+BGIOST)
70
Transcranial MicrocontrollerBiocellsNanitesB(BOT+BP) + (BIOT+BGLPS)
Ukomi Super ConductorsSynthetic Oil SuperconductorsS(GS+GIS) + (LPS+BGIOST)
72
VaccinesLivestockViral Agent O
(OT+BOT) + (BIOT+IO)
3 units per cycle (3600s)10 units10 units10 units
74
76
High Tech Production Plant Product P4 ←1. Input Product P3/P12. Input Product P33. Input Product P3/P1 Planet Types ExclusivityInput 1.(P3/P1) + 2.(P3) + 3.(P3/P1)
Broadcast NodeNeocomsData ChipsHigh-Tech TransmittersB+G+L+T+IO(BOT+BP) + (G+L) plus (GIS+IO) + (T+L) plus (G+T) + (LPS+LP)
78
Integrity Response DronesGel-Matrix BiopasteHazmat Detection SystemsPlanetary VehiclesG+B+L+T+O(G+GIS) + (BOT+BP) + (LPS+BGIOST) plus (BOT+T) + (BOT+O) + (LPS+LP) plus (GIS+IO) + (BGLPS+BP) + (LP+L)
Nano-FactoryIndustrial ExplosivesUkomi Super ConductorsReactive MetalsT+ S(BIOT+OT) + (BOT+T) plus (GS+GIS) + (LPS+BGIOST) plus (BIOT) + (BGLPS)
80
Organic Mortar ApplicatorsCondensatesRoboticsBacteriaG+P+BIOT(G+GIS) + (GS+BGIOST) plus (BGLPS+BP) + (ILP+LP) plus (BIOT)
Recursive Computing ModuleSynthetic SynapsesGuidance SystemsTranscranial MicrocontrollersI+B+LP(GIS+IO) + (BIOT+BGIOST) plus (BGLPS+BGIOST) + (LPS+LP) plus (BOT+BP) + (BIOT+BGLPS)
82
Self-Harmonizing Power CoreCamera DronesNuclear ReactorsHermetic MembranesG+L+T+B+IO(G+L) + (LPS+GS) plus (T+L) + (BP)+(ILP) plus (G+T) + (OT+IO)
Sterile ConduitsWaterSmartfab UnitsVaccines L+O(BGIOST) plus (BGLPS+ILP) + (LP+L) plus (OT+BOT) + (BIOT+IO)
84
Wetware MainframeSupercomputersBiotech Research ReportsCryoprotectant Solution G+LP+OT(BGLPS+BGIOST) + (GS+BGIOST) + (ILP+LP) plus (BIOT+BGLPS) + (OT+BOT) + (BGLPS+ILP) plus (BIOT+BGIOST) + (GS+GIS) + (BIOT+OT)
1 unit per cycle (3600s)6 units (or 40 P1 units)6 units6 units (or 40 P1 units)
86
88
PI Spreadsheet short link:http://4WARDeve-pi.notlong.comLast edited: 2010-07-24T18:18Z (by Chromwell)
Any errors or changes? Drop me a note ingame (SiSi or Tranq)! ^^
90
Don't miss the links to the other sheets! Bottom Line! ↓ ↓ ↓ ( 1. PI Production / 2. Planets / 3. Skills / PI Structures / Step by Step / 4. Error Messages / 5. Official / Schematics) ↓ ↓ ↓

Coments are closed