View unanswered posts | View active topics It is currently Thu Oct 17, 2019 4:42 pm



Post new topic Reply to topic  [ 11 posts ] 
 planetary spreadsheets OCD 
Author Message
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post planetary spreadsheets OCD
had this in mind for awhile, but finally got around to getting it done. i took my planet tab of my tracking spreadsheet and sorted all the non.invincible arti planets by production, then took a look to see where any gaps were for specific planet artifacts.

here's a listing of a variety of artifacts (extractable or readily available via abilities, LMs, badges, NPCs, base raids or ct.lab), with the highest arti per hour planet that does NOT have that artifact, sorted in descending aph. it might be interesting to see the differing priorities of players as they build out their planets, so feel free to post your own follow-up.
Code:
aph   arti
2952   BPA3
2837   ADU2
2837   SCPC
2837   EPV
2600   BNX2
2454   GEP
2192   LDP
1799   SRD3
1748   PST
1711   con.pillar (max passive attack)
1651   TMC
1521   ESD
1445   CRED
1376   QAC2
1310   LDP
1294   QAC
983   HLS
976   SOB
911   IFGs / Mcharger (cloak 3856)
850   CGO
788   IPH
680   HDS
680   grav.amps (max passive attack)
641   SCC
492   bainar
485   PHTV
459   CRA2
0   PCV
0   ISO2
0   HYG
0   TPP

obviously, my HDS figure will be much higher than most players given the amount of raiding that i do. 0 aph means every arti production planet has that arti (ISO2 excludes 2 planets invaded in the past week that are waiting on a temporal.flux). i only got a few bane arsenals the first year they came out, but got quite a few lined up this year. upgrading them has been made quite a bit faster with the jam attenuator supplementing the silent takeover ability, along with faster 16H invasions (until i maxed out the Porowyn and had to drop back down to 20H invasions). QAC2s are the 100% upgraded, while the QACs are the ones i extract from planet invasions.

is there a regular arti that i didn't include that you think should be on every arti planet ?

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Last edited by senatorhung on Tue Apr 16, 2019 1:10 pm, edited 1 time in total.



Tue Feb 12, 2019 10:35 am
Profile WWW

Joined: Fri Jul 09, 2010 2:23 pm
Posts: 156
Post Re: planet spreadsheets OCD
I want to be impressed and maybe pick up a few planet building ideas, but I don't understand your TLAs. I thought I could figure out the ones next to the APH (but I was wrong) and have no idea what the ones below that mean. Thanks!

_________________
Image


Sun Mar 10, 2019 3:29 am
Profile
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planet spreadsheets OCD
xencindy wrote:
I want to be impressed and maybe pick up a few planet building ideas, but I don't understand your TLAs. I thought I could figure out the ones next to the APH (but I was wrong) and have no idea what the ones below that mean. Thanks!

most of the artis listed give either %arti production or at least 2:1 arti per space or better. i skipped ultra.limited stuff like arcrift towers and also excluded GP artis.

anyone who tracks their planet structures on a spreadsheet (hence the topic title) should be able to figure out the TLA.

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Sun Mar 10, 2019 5:05 am
Profile WWW

Joined: Mon Jun 29, 2015 12:14 am
Posts: 10
Post Re: planet spreadsheets OCD
senatorhung wrote:
xencindy wrote:
I want to be impressed and maybe pick up a few planet building ideas, but I don't understand your TLAs. I thought I could figure out the ones next to the APH (but I was wrong) and have no idea what the ones below that mean. Thanks!

most of the artis listed give either %arti production or at least 2:1 arti per space or better. i skipped ultra.limited stuff like arcrift towers and also excluded GP artis.

anyone who tracks their planet structures on a spreadsheet (hence the topic title) should be able to figure out the TLA.


Some of the TLAs were a lil hard to figure out as they are not all created the same way, my guess was that SCPC is Scruuge Cargo Pad, CRED Corrupted Edifice and HLS Hyperluminal Satellite(only 1/1)? Also LDP (litheor deep probe) is listed twice.

Missing are Litheor Tranmutatic Locator, Galactic Concord Station 2 (9 months calm required I know), Ring of Ascendance, Active Tenebris Relic, Ryelis Analyzer, (Auric) Lepus Bio-Nest, Adaptive Spire, the 2 Vorean and RWF(3/2).

Would be nice to make the template excel sheet available (could be added to the wiki if possible) :)


Sun Mar 10, 2019 11:21 pm
Profile
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planet spreadsheets OCD
Annihilator wrote:
senatorhung wrote:
xencindy wrote:
I want to be impressed and maybe pick up a few planet building ideas, but I don't understand your TLAs. I thought I could figure out the ones next to the APH (but I was wrong) and have no idea what the ones below that mean. Thanks!

most of the artis listed give either %arti production or at least 2:1 arti per space or better. i skipped ultra.limited stuff like arcrift towers and also excluded GP artis.

anyone who tracks their planet structures on a spreadsheet (hence the topic title) should be able to figure out the TLA.


Some of the TLAs were a lil hard to figure out as they are not all created the same way, my guess was that SCPC is Scruuge Cargo Pad, CRED Corrupted Edifice and HLS Hyperluminal Satellite(only 1/1)? Also LDP (litheor deep probe) is listed twice.

you were correct with all 3 of those TLAs. i provided a full listing of my TLAs to the discord channel, but couldn't share the image from their cdn to this forum.

Annihilator wrote:
Missing are Litheor Tranmutatic Locator, Galactic Concord Station 2 (9 months calm required I know), Ring of Ascendance, Active Tenebris Relic, Ryelis Analyzer, (Auric) Lepus Bio-Nest, Adaptive Spire, the 2 Vorean and RWF(3/2).

Would be nice to make the template excel sheet available (could be added to the wiki if possible) :)


HLS was included as 1:1 arti because it also have cloak benefit (but was also the most current seasonal when i posted). not sure what the 2d LDP was - maybe that was the ROA. ADA is only 2:1 arti on specific planets so i left that off, but i can include it in future. i stockpile my VOH and VBLs for now .. my biologist run won't be until the fall, so the only ones i have on planets are ones that are already 2:1 placed by original owners. RWFs i can include in future lists.

i only have 38 bio.nests on planets, but like TSMs .. i replace the ones on the best planets until they are maximized. i only have 24 ATRs and 36 RYAs, so those are on less than 10% of my arti production planets - but they are also non.extractable. i only have 32 GEPs but those ARE extractable, and i only have 35 BPAs installed, but i still have a dozen more in cargo. so maybe an idiosyncratic list, but i can be more inclusive in the future. the first post was just a trial balloon to see if anyone would post their info.

as for sharing the spreadsheet that i have, i have a whole mess more info / conditional formatting on mine. it has been shared on our legion's fb page, and a few people have skimmed it, but no one has done a deep dive thru it as far as i know.

for my 'standard' planet build, i include the following columns:
PCV ABW ARCO ADU ADU ISO2 HLS CRA CRED BNX BNX HYG BAN TPP GCS HSS HDC BKA

then i have a notes column where i manually enter in stuff not included in any other column

columns for additional effects:
rings - ALL production +20% large moons - space +20% galactic trade hub - ALL production +10% until xx ultra-pure deposits - mining production +20% until xx litheor transmutative locator - arti production +6% prismoda ambassador - ALL production +6% intraphasic hoveroid - ALL production +5% cognizant omniforge - ALL production +5% alarri signalling drone (4 days) - ALL production +10% until xx b'elna's altar - ALL production +3% t.o. terrafounder - ALL production +5%

which share columns with:
ruins - arti production +20% small moons - space +10% ancient relics - arti production +10% until xx pure deposits - mining production +10% until xx lutuma command codes +14% until xx essence of the arbilon - ALL production +7% perpetual hyperturbine - arti production +5% uldri power node - arti production +5% litheor crystal focus (2 days) - ALL production +10% until xx ring of ascendance - ALL production +3%, arti +1, mining +3, research +2, pop +3000, defense +30%, attack +30% shrine of b'elna - arti production +2% improved invasion (2 days) - production +50% until xx trade outpost intelligence - ALL production +4% ardyne gateway link - ALL production +6%

columns for additional effects:
aerlen patronage - ALL production +6% chuhn trading forum - ALL production +5% uldri crystal field - ALL production +5% (requires UAC) nsx crate diamond - defense +10% raix bunker - defense boost from pop lush biosphere - population +200%

which alternate columns with:
archotage power grid - ALL production +1% t5 field analysis - ALL production +1% diversionary tactics - defense +35% subterranean caverns - defense +30% reactive barrier - immune to enemy artifacts and abilities

then additional structures:
SHT LBN VOH VBL SBB CHPT QHM TFD ATM LDP PST PST GEP BPB GMT TMC ADA SKS ATR BPA ATC QAC QAC SRD SCCA SCPC STV CSR MTJ LCT ERF AGR PLE2 XIN TRIN VFC RYA RLP THQ NSF CHR DAB BLP RSI SSP KSG XC1 GLI GLT GLE GLO FJL ORS ASL MSM ELS TPC SULC XTI CHS AMD WFP ESD SLB EPV CTH9 GKT ARW MST RDA TAR

SHT - follows on from the last columns of defense
LBN thru PST - pop structures
TFD thru STV - arti structures
QAC thru GLI - cloak structures
GLI thru GLO - prismatic officials
FJL thru CTH9 - mining structures
GKT thru TAR - storage structures

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Last edited by senatorhung on Mon Mar 11, 2019 4:49 pm, edited 4 times in total.



Mon Mar 11, 2019 1:13 am
Profile WWW
User avatar

Joined: Thu Oct 27, 2016 2:52 pm
Posts: 288
Post Re: planet spreadsheets OCD
I think that acronyms are causing more problems than they were meant to solve.

There's a concept in programming that if your code should always be as clear as possible. If clarity can be gained from using a simple operation or structure (i.e. multiple operations over lines as opposed to a one-liner) over more complex ones then it should be used. I feel the same applies here.


Mon Mar 11, 2019 1:24 am
Profile
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planet spreadsheets OCD
Guide wrote:
I think that acronyms are causing more problems than they were meant to solve.

There's a concept in programming that if your code should always be as clear as possible. If clarity can be gained from using a simple operation or structure (i.e. multiple operations over lines as opposed to a one-liner) over more complex ones then it should be used. I feel the same applies here.

the acronyms i listed are the ones that i use on my spreadsheet. i am assuming that anyone else who is as OCD about planet building has also created acronyms for their own spreadsheets, which are likely different than mine, but just as unintelligible to others. unlike code, they are not generally meant to be shared, hence clarity to others is not an initial consideration.

this is what i shared on the discord channel:
(image post failed, so just copy pasting from planet structures tab - diff from planet tracking tab)

Code:
acronym   building
   
AEC   A.I. emotion core
ATR   active tenebris relic
ADA   adaptive spire
ADA   adaptive spire (arti)
ADU   adumbrate station
ADU2   adumbrate station upgrade
ARTR   aerlen rescue transport
ARTRA   aerlen rescue transport (aerlen)
AFD2   affection disseminator 2.0
AFD3   affection disseminator 3.0
AFD4   affection disseminator 4.0
AGI   akulan gas ingestor
ACTO   alarri comm tower
ACT2   alarri comm tower 2
ACT3   alarri comm tower 3
ACTU   alarri compound turret
ASD   alarri signaling drone
AGR   anti-grav repulsor
AMD   antimatter drill
ARB   anti-resistance base
ASC   archaic stasis cells
ATM   archotage transmitter
ATMA   archotage transmitter (archotage)
ARCT   arcrift tower
ATC   arydne transfer conduit
ATC2   arydne transfer conduit (gateway)
ARCO   argent consulate
ARW   artifact warehouse
ASL   assimilation locus
ASL4   assimilation locus 2
ASL8   assimilation locus 2 upgrade (100%)
ASLU   assimilation locus upgrade (100%)
ABW   astrobiology ward
ALBN   auric lepus bio-nest
ALBN3   auric lepus bio-nest 3
ALD   auric lepus drone
ALD2   auric lepus drone 2
ALD3   auric lepus drone 3
ALD4   auric lepus drone 4
ALD5   auric lepus drone 5
ALD6   auric lepus drone 6
ALD7   auric lepus drone 7
ALD8   auric lepus drone 8
BANA1   bainar access a-node - basic
BANA2   bainar access a-node - advanced
BANA3   bainar access a-node - prime
BANM1   bainar access m-node - basic
BANM2   bainar access m-node - advanced
BANM3   bainar access m-node - prime
BANR1   bainar access r-node - basic
BANR2   bainar access r-node - advanced
BANR3   bainar access r-node - prime
BANX1   bainar access x-node
BNG2   bane generator 2
BNG3   bane generator 3
BNG4   bane generator 4
BNG5   bane generator 5
BNG6   bane generator 6
BNG7   bane generator 7
BNG8   bane generator 8
BPB   bane psybeacon
BPB2   bane psybeacon 2
BPB3   bane psybeacon 3
BPB4   bane psybeacon 4
BPA   bane psyshade arsenal
BPA2   bane psyshade arsenal 2
BPA3   bane psyshade arsenal 3
BNX2   barrier hypernexus
BNX   barrier nexus
BLA   b'elna's altar
BLAS   b'elna's altar (shrine)
BGL   bioship gene lab
BGLA   bioship gene lab (arti)
BLP   bioship landing platform
BKA   bralkir altar
CCB   captured crimson base
CTH2   captured t.o. harvester II
CTH3   captured t.o. harvester III
CTH4   captured t.o. harvester IV
CTH5   captured t.o. harvester V
CTH5A   captured t.o. harvester V (archotage)
CTH6   captured t.o. harvester VI
CTH6A   captured t.o. harvester VI (archotage)
CTH7   captured t.o. harvester VII
CTH7A   captured t.o. harvester VII (archotage)
CTH8   captured t.o. harvester VIII
CTH8A   captured t.o. harvester VIII (archotage)
CTH9   captured t.o. harvester IX
CTH9A   captured t.o. harvester IX (archotage)
CFC   cerulean flow converter
CHY   cerulean hyperstation
CHR   chron shifter
CEC   chuhn exo-logistics center
CSY   chuhn scrapyard
CSD   chuhn scrap depot
CHP   chuhn trading post
CHPT   chuhn trading post (trading)
CLC   cloning center
CGO   cognizant omniforge
CHS   convoy heat seeker
CRED   corrupted edifice
COB   council base
CIN   counter-intelligence nexus
CPL   crimson phase launcher
CRA   crimson rift aperture
CRA2   crimson rift aperture (2rift)
CSR   cross-signal restrainer
DAB   dark anti-beacon
DCA   dark command alcove
DNB   dark null beacon
DPS   dark pylon shifter
DNT   darmos nerve turret
DMD   dm79 datacenter
DMD2   dm79 datacenter (non-gas)
DOW   domain walker
DTR   dormant tenebris relic
DKD   drannik databank
EHP   elios heliacal plant
EHP2   elios heliacal plant 2
EPV   elios powervault
EPPV   elios phoenix powervault
ESD   elios solar drill
ESD2   elios solar drill 2
ESDH   elios solar drill (heliacal)
ESDH2   elios solar drill (heliacal) 2
ERF   ergosphere filter
EXB   exotic barrier
EXL   exotic lab
EXT   exotic turret
ELS   extracted lithovoric stem
FJL   fornax jewel
FJL2   fornax jewel (moons / rings)
GCS   galactic concord station
GCS2   galactic concord station II
GEP   galakis entry port
GKT   galakis transport
GLE   galaxy elitists
GLI   galaxy inquisitors
GLO   galaxy overseers
GLT   galaxy technocrats
GCH   gauss chain
GCH2   gauss chain (10+ met/dyson/ecu)
GMT   genome modifier tubes
GUM   guarded memorial
HOT   hall of torment
HOET   hall of extreme torment
HOUT   hall of unrelenting torment
HDC   heist dispatch center
HDS   heist dispatch station
HTB   human training barracks
HYG   hypergate
HLS   hyperluminal satellite
HPS   hypernexus power shunt
HSS   hypersensor satellite
INC   interrogation center
INS   interrogation stronghold
IPH   intraphasic hoveroid
ISO   isolation bureau
ISO2   isolation bureau (doubled)
KSG   klorvis shroud generator
KTG   klorvis troop gateway
KP1   krow probe type 1
KP2   krow probe type 2
KP3   krow probe type 3
LZD   lazuli darkmines
LZDC   lazuli darkmines cluster
LZP   lazuli pylon
LZS   lazuli shipyard
LPG   lepus gateway
LCG   lepus chromatic gateway
LBMG   lepus bio-mech gateway
LBMH   lepus bio-mech hypergate
LC34G   lepus C-34 gateway
LC34H   lepus C-34 hypergate
LBN   lepus bio-nest
LBN2   lepus bio-nest 2
LD1   lepus drone
LD2   lepus drone 2.0
LD3   lepus drone 3.0
LD4   lepus drone 4.0
LD5   lepus drone 5.0
LD6   lepus drone 6.0
LD7   lepus drone 7.0
LD8   lepus drone 8.0
LGH   lepus growth hatchery
LPH   lepus hatchery
LCT   litheor core tunnel
LCT2   litheor core tunnel 2
LDP   litheor deep-phase probe
LTL   litheor transmutative locator
LUC   luring cynosure
LUCI   luring cynosure (invasion effect)
LCM   lutuma command module
MO2   M.O.T.H.E.R. 2.0
MTJ   meta-tuned jammer
MTJC   meta-tuned jammer (cloak)
MST   mineral storage tower
MGP   modified grid pylon
MPI   morphogenic inhibitor
MSM   mylarai stripcore mine
NCC   nexus command center
NSF   nexus spy fortress
NXD   nsx crate diamond
NXT   nsx tracking matrix
NXT2   nsx tracking matrix 2
NXT3   nsx tracking matrix 3
OMC   omnibase chassis
OSG   omnistream gateway
BNX3   orbisbarrier hypernexus
ORS   orbital stabilizer
ORST   orbital stabilizer (transfused)
ORM   orion menagerie
OEC   oruas eye chamber
OPD   oruas predictive disjector
OCD   oruas predictive disjector (corrupted)
PST   perimeter station
PSTA   perimeter station (archotage)
PSN   permafrost sub-network
PHT   perpetual hyperturbine
PHT2   perpetual hyperturbine II
PHT3   perpetual hyperturbine III
PHT4   perpetual hyperturbine IV
PHT5   perpetual hyperturbine V
PHC   phase cutter chassis
PLE   polaron emitter
PLE2   polaron emitter (moon/rings)
PCV   polychoron vault
PBJ   prejor beacon jammer
PSB   prejoran slave barrier
PRC   processing core chassis
QDS   q-pedd docking station
QPP   q-pedd probe
QSS   q-pedd science station
QSS2   q-pedd science station 2.0
QSS3   q-pedd science station 3.0
QSS4   q-pedd science station 4.0
QSS5   q-pedd science station 5.0
QSS6   q-pedd science station 6.0
QSS7   q-pedd science station 7.0
QSS8   q-pedd science station 8.0
QAC   quantum accelerator
QAC1   quantum accelerator 50%
QAC2   quantum accelerator 100%
QHM   quantum hydro-meliorator
QHM2   quantum hydro-meliorator 2
QHM3   quantum hydro-meliorator 3
RXB   raix bunker
RXB2   raix bunker (transformed)
RXR   raix refinery
RXR2   raix refinery (transformed)
RRB   raix refinery (w bunker)
RRB2   raix refinery (w bunker transformed)
RFL   refining lab chassis
RTW   relay tower chassis
RDA   research data archive
RSI   resonance inhibitor
RWF   rikthar's war forge
RWFA   rikthar's war forge (arti)
ROA   ring of ascendance
RLP   roathir listening post
RDU   rsl data uplink
RYA   ryelis analyzer
SHQ   sarkonis headquarters
SHQA   sarkonis headquarters (archotage)
SKO   sarkonis omnipod
SKO2   sarkonis omnipod (upgraded)
SCC   scruuge calibration chamber
SCCA   scruuge calibration chamber A
SCP   scruuge cargo pad
SCPC   scruuge cargo pad (calib)
SVAT   scruuge growth vats
SVAT2   scruuge growth vats (SHV7+)
SHV   scruuge hoarding vault
SHV2   scruuge hoarding vault II
SHV3   scruuge hoarding vault III
SHV4   scruuge hoarding vault IV
SHV5   scruuge hoarding vault V
SHV6   scruuge hoarding vault VI
SHV7   scruuge hoarding vault VII
SHV8   scruuge hoarding vault VIII
SHT   scruuge hovertank
SKS   scruuge keystone
SKS2   scruuge keystone II
SLB   scruuge lab
SRD   scruuge resupply depot
SRD2   scruuge resupply depot II
SRD3   scruuge resupply depot III
SGN   sha'din grid network
SHN   sha'din hypergrid network
SPN   sha'din hyperport network
SHU   sha'jha uplink
SOB   shrine of b'elna
SSP   siladon suppressor
SXS   sillixx starport
SGV   silthion gas vesicle
STV   silthion t-plasma vesicle
STV2   silthion t-plasma vesicle II
SOP   soldier outpost
SPE   space elevator chassis
SPU   spy uplink chassis
STM   statue of the magnus
SGP   strazi genolink probe
SLAM   strazi link anchor (mining)
SLAC   strazi link anchor (cloak)
SLAR   strazi link anchor (research)
SBB   stryll bioresearch bay
SBB4   stryll bioresearch bay (bio)
STA   sub-tachyonic axis
STA2   sub-tachyonic axis (no effects)
SULC   sulcation portal
STL   symbiont test lab
TGB   t.o. grid barrier
THV   t.o. harvest vault
THV2   t.o. harvest vault II
THV3   t.o. harvest vault III
THV4   t.o. harvest vault IV
THV4A   t.o. harvest vault IV (archotage)
THV5   t.o. harvest vault V
THV5A   t.o. harvest vault V (archotage)
THV6   t.o. harvest vault VI
THV6A   t.o. harvest vault VI (archotage)
THV7   t.o. harvest vault VII
THV7A   t.o. harvest vault VII (archotage)
THV8   t.o. harvest vault VIII
THV8A   t.o. harvest vault VIII (archotage)
TMC   t.o. manufacturing core
TOO   t.o. omnispanner
TFD   t.o. terrafounder
TFDA   t.o. terrafounder (archotage)
TAR   taltherian archives
TBR   tej-brask refueling depot
TBRT   tej-brask refueling depot (transformed)
THQ   tejiar ally hq
THQS   tejiar ally hq (scanned)
TOR   temple of reflection
TSIC   terran stryll interrogation cell
TSIC2   terran stryll interrogation cell (stryll)
TRV   throne of the revered
TRV2   throne of the revered mk2
TRV3   throne of the revered mk3
TRV4   throne of the revered mk4
TPP   toxic processing plant
TCR   trellith comm relay
TSM   triangulum sparkmatter
TSM1   triangulum sparkmatter 1
TSM2   triangulum sparkmatter 2
TRIN   tri-occular inhibitor
TPC   tri-phase cutter
UAC   uldri anomaly crystal
UAC2   uldri anomaly crystal scan
UCF   uldri crystal field
UPN   uldri power node
URC   uldri recovery capsule
URC2   uldri recovery capsule 2
URC3   uldri recovery capsule 3
URC4   uldri recovery capsule 4
USF   uldri spacial folder
USM   uldri spacial marker
USM2   uldri spacial marker 2
USM3   uldri spacial marker 3
VHO   vaash holomatrix
VOT   vault of terra
VCS   vearon casino
VFC   ventar field collapser
VBC   void barrier chassis
VHS   volcanic heat seeker
VTL   vollir transgenic lock
VBL   vorean biostasis lab
VBL2   vorean biostasis lab (biologist)
VOH   vorean habitat
VOH2   vorean habitat (biologist)
WFP   war foundry plant
WGT   warp gate chassis
XIN   xathe inhibitor
XC1   xc1 transport probe
XSR   xecti signal repeator
XTO   xectiphage tower
XPT   x-pulse tower
XRP   xrp warp inhibitor
XTI   xts-10 injector
XTS   xts-9 silo
ZAN   zolazin analyzer
ZVT   zolazin void tower

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Last edited by senatorhung on Mon Mar 11, 2019 1:51 am, edited 4 times in total.



Mon Mar 11, 2019 1:33 am
Profile WWW
User avatar

Joined: Thu Oct 27, 2016 2:52 pm
Posts: 288
Post Re: planet spreadsheets OCD
That image is compressed beyond readability.


Mon Mar 11, 2019 1:43 am
Profile
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planet spreadsheets OCD
Guide wrote:
That image is compressed beyond readability.

yeah i noticed .. i'm not a masochist lol.

the post on discord was much clearer and had the structures colour-coded by type of benefit. anyone with access to that discord channel can try this link in their browser:
https://cdn.discordapp.com/attachments/ ... nknown.png

i just edited the previous post to just include a columnar copy paste instead.

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Mon Mar 11, 2019 1:48 am
Profile WWW
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planetary spreadsheets OCD
alright, arti per hour really blew for updating purposes. so i thought about going with plain quantities with % of planets instead. however, then i had to distinguish between types of planets. that took a bit more rumination. we'll see if this is more feasible to update occasionally.

Code:
TOTAL PLANETS      511         
Str/E   Q   %prod         notes
PCV   510   99.8%   polychoron vault      prismatic excluded
ISO2   504   98.6%   isolation bureau      
ABW   483   94.5%   astrobiology ward      
ADU   479   93.7%   adumbrate station      2 set
HYG   479   93.7%   hypergate       
TPP   467   91.4%   toxic processing plant      
CTH9   290   56.8%   captured t.o. harvester IX      
PLE   285   55.8%   polaron emitter      
DAB   277   54.2%   dark anti-beacon      
BLP   137   26.8%   bioship landing platform      
RSI   132   25.8%   resonance inhibitor      2 set
ERF   126   24.7%   ergosphere filter      
MTJ   106   20.7%   meta-tuned jammer      
GKT   67   13.1%   galakis transport      
LCT   62   12.1%   litheor core tunnel      
THQ   37   7.2%   tejiar ally hq      
CSR   28   5.5%   cross-signal restrainer      
TBR   20   3.9%   tej-brask refueling center      

ARTI PRODUCTION PLANETS      397         
Str/E   Q   %prod         notes
HSS   369   92.9%   hypersensor satellite      
PHTV   305   76.8%   perpetual hypertubine V      
CRA2   303   76.3%   crimson rift aperture (2 rifts)      
ARCO   221   55.7%   argent consulate      
SOB   207   52.1%   shrine of b'elna      
CGO   183   46.1%   cognizant omniforge      
HLS   168   42.3%   hyperluminal sensor      
QHM   166   41.8%   quantum hydro-meliorator      
STV   166   41.8%   silthion t-plasma vesicle      
ATM   156   39.3%   archotage transmitter      
PST   155   39.0%   perimeter station      2 set
ADA   144   36.3%   adaptive spire       2 set
SHT   122   30.7%   scruuge hovertank      
QAC   122   30.7%   quantum accelerator (any)       2 set
CRED   110   27.7%   corrupted edifice      
QAC2   104   26.2%   quantum acclerator (100%)       2 set
ROA   69   17.4%   ring of ascendence      
ADU2   54   13.6%   adumbrate station upgraded       2 set
SRD3   54   13.6%   scruuge resupply depot III      
LBN   48   12.1%   lepus bio-nest      
LTL   39   9.8%   litheor transmutative locator      
RYA   39   9.8%   ryelis analyser      
ACT   39   9.8%   alarri comm tower      
BPA   38   9.6%   bane psyshade arsenal      
BNX3   37.5   9.4%   orbisbarrier hypernexus       2 set
SKS   35   8.8%   scruuge keystone      
XC1   35   8.8%   xc1 transport probe      
GEP   32   8.1%   galakis entry port      
RXB   29   7.3%   raix bunker      
XIN   29   7.3%   xathe inhibitor      
VFC   29   7.3%   ventar field collapser      
OCD   29   7.3%   oruas corrupted disjector      
UCF   28   7.1%   uldri crystal field      
DIV   27   6.8%   diversionary tactics
ATR   26   6.5%   active tenebris relic
UPN   24   6.0%   uldri power node
AGR   21   5.3%   anti-grav repulsor
GMT   20   5.0%   genome modifier tubes
RLP   19   4.8%   roathir listening post
OEC   17   4.3%   oruas eye chamber
T5A   16   4.0%   t5 field analysis
CHTF   15   3.8%   chuhn trading forum
ESA   12   3.0%   essense of the arbilon
SBB   11   2.8%   stryll bioresearch bay (biologist)
AGL   10   2.5%   ardyne gateway link
VBL2   10   2.5%   vorean biostasis lab (biologist)
ATC   10   2.5%   ardyne transfer conduit
VOH2   7   1.8%   vorean habitat (biologist)
APT   4   1.0%   aerlen patronage

MINING PRODUCTION PLANETS      61         
Str/E   Q   %prod         notes
MSM   61   100.0%   mylarai stripcore mine      
ELS   61   100.0%   extracted lithovore stem      
TPC   61   100.0%   tri-phase cutter (2 set)      
SULC   61   100.0%   sulcation portal      
XTI   45   73.8%   xts-9 injector      
CHS   42   68.9%   convoy heat seeker      
XTS   9   14.8%   xts-9 silo      

STORAGE PLANETS      53         
Str/E   Q   %prod         notes
NSF   53   100.0%   nexus spy fortress      
CHR   53   100.0%   chron shifter       2 set
ARW   53   100.0%   artifact warehouse       5 set
MST   53   100.0%   mineral storage tower       5 set
RDA   53   100.0%   research data archive      5 set
TAR   53   100.0%   taltherian archive       2 set
KSG   52   98.1%   klorvis shroud generator       2 set
SSP   50   94.3%   siladon suppressor      

ARTI AND MINING PLANETS      458         
Str/E   Q   %prod         notes
bainar   445   97.2%   bainar structure      
GCS   422   92.1%   galactic concord station      
HDS   418   91.3%   heist dispatch station      
BNX   409.5   89.4%   barrier nexus or hypernexus       2 set
NXD   293   64.0%   nsx crate: diamond      
BKA   244   53.3%   bralkir altar      
SCC   234   51.1%   scruuge calibration chamber      
TMC   219   47.8%   t.o. manufacturing core      
ESD   219   47.8%   elios solar drill      
IPH   193   42.1%   intraphasic hoveroid      
LDP   189.5   41.4%   litheor deep-phase probes      2 set
BPB   160   34.9%   bane psybeacon      
EPV   145   31.7%   elios powervault      
ORS   115   25.1%   orbital stabilizer      
TFD   105   22.9%   t.o. terrafounder      
AMD   80   17.5%   antimatter drill      
SCPC   70   15.3%   scruuge cargo pad (SCC)      
ASL   65   14.2%   assimilation locus      
FJL   61   13.3%   fornax jewel      
TOI   55   12.0%   trade outpost intelligence      
TRIN   33   7.2%   tri-occular inhibitor      
WFP   30   6.6%   war foundry plant      

PRISMODA OFFICIAL PLANETS      205         
Str/E   Q   %prod         notes
PRAM   15   7.3%   prismoda ambassador      


minimum aph on non.project arti planets: 384
minimum mph on non.project mining planets: 1024
minimum cloak on storage planets b4 legion bonus: 13105

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Tue Apr 16, 2019 1:09 pm
Profile WWW
User avatar

Joined: Sat Oct 15, 2011 5:09 am
Posts: 3304
Post Re: planetary spreadsheets OCD
i snagged my data from 15jan to do a 3.month comparison:

Image

so that gives an idea of which structures had the most change in the 3.month period.

_________________
Rank 2734 Mylarai Explorer 100% DCR r385-r2200 GL Marauder #26
_____________Image
PvP leaderboards: 61353 raids: #1; 61683 hacks: #1; 32649 kills: #2;


Sun Apr 21, 2019 4:27 am
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 


Who is online

Users browsing this forum: Google [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to: