item per system data

General discussion about anything related to Transcendence.
Post Reply
User avatar
Betelgeuse
Fleet Officer
Fleet Officer
Posts: 1920
Joined: Sun Mar 05, 2006 6:31 am

I did some work with item sim and made an open office spreadsheet with it.

Column D is the average number of that item appearing in that system per game.
Column E is the chance that the system will appear in game.
Column F is the average number of that item you will get from that system per game.
Column H is the sum of averages up to that point for that item. This can be used to find out how many on average of an item you will get. This works best at level changes and at the end of the item.

http://xelerus.de/index.php?s=mod&id=542

any comments or questions or requests on different formats?

edit: I used itemsim to get the base data so it does not include spawned ships and stations and installed devices.
Crying is not a proper retort!
User avatar
Aury
Fleet Admiral
Fleet Admiral
Posts: 5421
Joined: Tue Feb 05, 2008 1:10 am
Location: Somewhere in the Frontier on a Hycrotan station, working on new ships.

so item sim generated that spreadsheet, or did you do it manually?
(shpOrder gPlayership 'barrelRoll)
(plySetGenome gPlayer (list 'Varalyn 'nonBinary))
Homelab Servers: Xeon Silver 4110, 16GB | Via Quadcore C4650, 16GB | Athlon 200GE, 8GB | i7 7800X, 32GB | Threadripper 1950X, 32GB | Atom x5 8350, 4GB | Opteron 8174, 16GB | Xeon E5 2620 v3, 8GB | 2x Xeon Silver 4116, 96GB, 2x 1080ti | i7 8700, 32GB, 6500XT
Workstations & Render machines: Threadripper 3990X, 128GB, 6900XT | Threadripper 2990WX, 32GB, 1080ti | Xeon Platinum 8173M, 48GB, 1070ti | R9 3900X, 16GB, Vega64 | 2x E5 2430L v2, 24GB, 970 | R7 3700X, 32GB, A6000
Gaming Systems: R9 5950X, 32GB, 6700XT
Office Systems: Xeon 5318Y, 256GB, A4000
Misc Systems: R5 3500U, 20GB | R5 2400G, 16GB | i5 7640X, 16GB, Vega56 | E5 2620, 8GB, R5 260 | P4 1.8ghz, 0.75GB, Voodoo 5 5500 | Athlon 64 x2 4400+, 1.5GB, FX 5800 Ultra | Pentium D 3.2ghz, 4GB, 7600gt | Celeron g460, 8GB, 730gt | 2x Athlon FX 74, 8GB, 8800gts 512 | FX 9590, 16GB, R9 295x2 | E350, 8GB | Phenom X4 2.6ghz, 16GB, 8800gt | random core2 duo/atom/i5/i7 laptops
User avatar
Betelgeuse
Fleet Officer
Fleet Officer
Posts: 1920
Joined: Sun Mar 05, 2006 6:31 am

I did it manually.
Crying is not a proper retort!
User avatar
Prophet
Militia Captain
Militia Captain
Posts: 826
Joined: Tue Nov 18, 2008 6:09 pm

I have Microsoft word '07 and can't seem to open your .ods file type.

Can you post the switches used so I can reproduce your results?

If others have the same problem I can upload an alternate file type for use in excel ( .xls)

Some questions:
When running itemsim, is there a way to specify which topology to use? (custom vs. vanilla)
I used itemsim to get the base data so it does not include spawned ships and stations and installed devices.
For clarification, items spawned as loot in wrecks are not accounted for in the tables? Just station inventories?
Coming soon: The Syrtian War adventure mod!
A Turret defense genre mod exploring the worst era in Earth's history.
Can you defend the Earth from the Syrtian invaders?
Stay tuned for updates!
User avatar
Betelgeuse
Fleet Officer
Fleet Officer
Posts: 1920
Joined: Sun Mar 05, 2006 6:31 am

Prophet wrote:I have Microsoft word '07 and can't seem to open your .ods file type.

Can you post the switches used so I can reproduce your results?

If others have the same problem I can upload an alternate file type for use in excel ( .xls)

Some questions:
When running itemsim, is there a way to specify which topology to use? (custom vs. vanilla)
I used itemsim to get the base data so it does not include spawned ships and stations and installed devices.
For clarification, items spawned as loot in wrecks are not accounted for in the tables? Just station inventories?
ods is open office spreadsheet type. I will upload a xls version later.
itemsim only has one switch /count and I used /count:100 but I have sorted and done some calculations with the data
You can only use the non adventure topology. That topology can be modded.
Some loot in wrecks is counted but not the stuff that started as their devices. Ships can and the cap ships often do have other kinds of loot.
Crying is not a proper retort!
User avatar
Betelgeuse
Fleet Officer
Fleet Officer
Posts: 1920
Joined: Sun Mar 05, 2006 6:31 am

Crying is not a proper retort!
User avatar
Prophet
Militia Captain
Militia Captain
Posts: 826
Joined: Tue Nov 18, 2008 6:09 pm

Thanks

Some interesting results for endgame equipment.

The numbers are from column H, representing the total number of that item that have appeared in the game.
  • Weapons
    Fusionfire howitzer 4.6056
    IM90 multitarget blaster 1.4222
    Katana star cannon 6.8864

    Shields
    Jotun deflector 1.60115
    Kaidun shield generator 0.0691
    Lazarus shield generator 0.0737
    Nephren X1 shield generator 0.81195
    plasma shield generator 4.4905
    R9 deflector 1.21835
    Taikon-200 deflector 1.346
    Trenton field generator 1.18205
    Yoroi MX shield generator 3.31775
    Yoroi S500 shield generator 4.50695

    Misc
    Hyperion reactor 0.55075
    inertialess drive 1.6764
    longzhu sphere 11.0761
    transpace jumpdrive 2.0022

    Just for fun
    Iocrym armor 0.05695
    Iocrym Disintigration Gun 0.0208
    Iocrym healer 0.005
    Iocrym plasma torch 0.0025
    Iocrym repeller 0.2308
    Iocrym veil 1.4293
    Light Iocrym armor 0.0291
    neutronium armor 0.0792
Coming soon: The Syrtian War adventure mod!
A Turret defense genre mod exploring the worst era in Earth's history.
Can you defend the Earth from the Syrtian invaders?
Stay tuned for updates!
schilcote
Militia Captain
Militia Captain
Posts: 726
Joined: Sat Feb 02, 2008 7:22 pm

So you can find one and a half inertialess drives in the adverage game?

I've never found any less than a whole object in Transcendence
[schilcote] It doesn't have to be good, it just has to not be "wow is that the only thing you could think of" bad
User avatar
Aury
Fleet Admiral
Fleet Admiral
Posts: 5421
Joined: Tue Feb 05, 2008 1:10 am
Location: Somewhere in the Frontier on a Hycrotan station, working on new ships.

schilcote wrote:So you can find one and a half inertialess drives in the adverage game?

I've never found any less than a whole object in Transcendence
:lol: I remember a bug in sim city 4 where you could get half a crime committed... :lol:
(shpOrder gPlayership 'barrelRoll)
(plySetGenome gPlayer (list 'Varalyn 'nonBinary))
Homelab Servers: Xeon Silver 4110, 16GB | Via Quadcore C4650, 16GB | Athlon 200GE, 8GB | i7 7800X, 32GB | Threadripper 1950X, 32GB | Atom x5 8350, 4GB | Opteron 8174, 16GB | Xeon E5 2620 v3, 8GB | 2x Xeon Silver 4116, 96GB, 2x 1080ti | i7 8700, 32GB, 6500XT
Workstations & Render machines: Threadripper 3990X, 128GB, 6900XT | Threadripper 2990WX, 32GB, 1080ti | Xeon Platinum 8173M, 48GB, 1070ti | R9 3900X, 16GB, Vega64 | 2x E5 2430L v2, 24GB, 970 | R7 3700X, 32GB, A6000
Gaming Systems: R9 5950X, 32GB, 6700XT
Office Systems: Xeon 5318Y, 256GB, A4000
Misc Systems: R5 3500U, 20GB | R5 2400G, 16GB | i5 7640X, 16GB, Vega56 | E5 2620, 8GB, R5 260 | P4 1.8ghz, 0.75GB, Voodoo 5 5500 | Athlon 64 x2 4400+, 1.5GB, FX 5800 Ultra | Pentium D 3.2ghz, 4GB, 7600gt | Celeron g460, 8GB, 730gt | 2x Athlon FX 74, 8GB, 8800gts 512 | FX 9590, 16GB, R9 295x2 | E350, 8GB | Phenom X4 2.6ghz, 16GB, 8800gt | random core2 duo/atom/i5/i7 laptops
User avatar
Song
Fleet Admiral
Fleet Admiral
Posts: 2801
Joined: Mon Aug 17, 2009 4:27 am

Wolfy wrote:
schilcote wrote:So you can find one and a half inertialess drives in the adverage game?

I've never found any less than a whole object in Transcendence
:lol: I remember a bug in sim city 4 where you could get half a crime committed... :lol:
And according to todays newspaper, there are 12.2 sparrows in every garden in New Zealand. Honestly.*

...And if I see 0.2 of a sparrow flying around, rest assured, I'll upload a photograph.

But this table seems pretty useful....







* Yes. That's true. However the important word in that story was "ON AVERAGE". But still, images of 0.2 of a sparrow flitting around immediately filled my head on seeing the story.......

.......I have a twisted mind, it seems.....
Mischievous local moderator. She/Her pronouns.
User avatar
Atarlost
Fleet Admiral
Fleet Admiral
Posts: 2391
Joined: Tue Aug 26, 2008 12:02 am

It's not flying. It's the one sitting on the fencepost where your yard meets four of your neighbors.
User avatar
Song
Fleet Admiral
Fleet Admiral
Posts: 2801
Joined: Mon Aug 17, 2009 4:27 am

Atarlost wrote:It's not flying. It's the one sitting on the fencepost where your yard meets four of your neighbors.
But I live on a street corner.....there's only three neighbours... :shock:
Mischievous local moderator. She/Her pronouns.
Post Reply