X3TC Stats and Resources Compendium V3.3.1 (28/09/2011) - links live again

TTD · Post by **TTD** » Wed, 15. Jun 11, 15:42

If you read up on the lore , the Xenon are "descendants" of the terraformers which were sent ahead to prepare the x- universe for Terran habitation .

A part of the program , involving replication was bugged and caused a virus that set most of the Xenon against all life forms , even turning against Earth . Thus the reason why the first EarthGate was destroyed .
However , there were two of the CPU ships which were not fully effected . One of them you find in one of the Terran/Aldrin Plots .
These two ships are the initial basis for the ANH plot....you have to get them to communicate with each other to make them safe again .

Edited a spelling mistake 30/6/11

nponoBegHuk · Post by **nponoBegHuk** » Thu, 30. Jun 11, 20:28

While working on one of my scripts, I stumbled upon this list of ship denominations in TShips file, in which #deca is SS_SH_TERRAFORMER1. The rest of the #deca.xxx fighters share the same signature, while Springblossom and Spitfyre are denominated as LOST. The rest of the terrans are just USC.

TTD · Post by **TTD** » Thu, 30. Jun 11, 21:18

SpringBlossom and Spitfyre belong to the "lost" colonies of Aldrin.
The Terran (Aldrin Mission) reunites Aldrin with the Sol system .
The next Aldrin (expansion) mission has some more useful rewards.

Thus "lost" as opposed to USC for Aldrin ships.

The point about #deca and it's sister ship etc. , I outlined above.

Oh , and thanks for the link.

ianrobo75 · Post by **ianrobo75** » Thu, 14. Jul 11, 12:48

Sovereign01 wrote:Spotted a mistake that's been there a while- the Boron Thresher's mounts are swapped for the back and right turrets

Fixed in this version.

cobra mk2 wrote:Will there be any chance in a future update of having the S, M and L prices of each ship instead of just the max (L) price?

I'm afraid I have very little inclination left to update the spreadsheet further, especially to work out what upgrades apply to what ship type and add the value to the price of the ship. Maybe someone else is willing.

Main addition in this version is the ship filtering columns based on nponoBegHuk's 'Complete list of ship sources' page & spreadsheet as well as adding the max prices for all ships.

We'll, baring some minor corrections that's it on this spreadsheet for me, thanks for all the posts of thanks along the way. Maybe I'll get interested in a new spreadsheet when we are are all getting born again!.

Poppa7563 · Post by **Poppa7563** » Tue, 19. Jul 11, 22:50

Thanks .

pamme · Post by **pamme** » Sat, 6. Aug 11, 20:20

Thanks for the great resource. Can't believe I didn't find this sooner, would've been so helpful.

One question though, is there a list of "Suns" or solar yield per sector? I haven't been able to find it in either of the files yet (excel 2003 version).

ianrobo75 · Post by **ianrobo75** » Thu, 11. Aug 11, 11:46

pamme wrote:...is there a list of "Suns" or solar yield per sector?

There isn't a list in the spreadsheet.

I would use Xadrian for this: http://forum.egosoft.com/viewtopic.php?t=239659

When you start Xadrian. click to select a sector, select the view mode as 'suns' and you will have a map of the sun percentages.

TTD · Post by **TTD** » Thu, 11. Aug 11, 19:54

Direct link in my sig.

Now includes Steam DLC sector @ 450% sun !

Kwaio · Post by **Kwaio** » Thu, 18. Aug 11, 11:42

Thanks for this tool, never found anything that usefull

Only thing missing : Sun coverage of sectors on the map.

TTD · Post by **TTD** » Thu, 18. Aug 11, 20:43

Kwaio wrote:Thanks for this tool, never found anything that usefull

Only thing missing : Sun coverage of sectors on the map.

Click on select sector.

You get a map.

Top right hand selection box "View Mode"

Select "suns"

The map is then color-coded to show %age of sun.

Put cursor over any sector that looks interesting

It will tell you basic sector information

Name
grid reference
Race ownership
Sun %age
Silicon yield per roid
Ore yield per roid.

There are other options there too , such as showing which sectors have the most silicon , if you select silicon instead of suns

Tarthrin · Post by **Tarthrin** » Thu, 22. Sep 11, 21:41

I can't seem to get the columns to sort properly.

I can sort ships by "Race" but it won't let me sort by "Speed" or "Cargo"

I am using excel 2007 and have macros enabled. Am I missing something?

ianrobo75 · Post by **ianrobo75** » Fri, 23. Sep 11, 01:58

maybe the VBA behind the buttons is wrong, I'll check when I get home.

Edit: Oops, recent additions have mucked up the sort code. I'll fix and update.

ianrobo75 · Post by **ianrobo75** » Wed, 28. Sep 11, 11:51

Tarthrin wrote:I can't seem to get the columns to sort properly.

I can sort ships by "Race" but it won't let me sort by "Speed" or "Cargo"

I am using excel 2007 and have macros enabled. Am I missing something?

Yes I broke the VBA code in V3.3 so those sort buttons didn't work.
Fixed in this version (3.3.1).

Tarthrin · Post by **Tarthrin** » Wed, 28. Sep 11, 13:42

Yay.

I tried out the new version and it seems to have fixed the issues I was seeing.

Thanks for the awesome spreadsheet.

SkullCowboy · Post by **SkullCowboy** » Wed, 28. Sep 11, 15:39

Just wanted to say thanks for this. I keep it open whenever I am playing so I can alt-tab to look things up. Great resource!

nponoBegHuk · Post by **nponoBegHuk** » Sat, 1. Oct 11, 02:21

Shall you decide to include DLC Harmony of Perpetuity sector to your map, the shortcuts are W^^^ or EEE^ (among others, less useful ones).

blackfire83 · Post by **blackfire83** » Sat, 1. Oct 11, 03:38

Isn't it Harmony of Perpetuity?

nponoBegHuk · Post by **nponoBegHuk** » Sat, 1. Oct 11, 13:38

blackfire83 wrote:Isn't it Harmony of Perpetuity?

erm.... yep, thanks, typo corrected

SkullCowboy · Post by **SkullCowboy** » Fri, 14. Oct 11, 23:03

Small nit pick on the Spectre missile. Range is listed as 5.7km but it's really 24.7. I understand that there was a bug before, but it really does work at 24.7. Favorite weapon in my Springy.

TheRealBix · Post by **TheRealBix** » Wed, 21. Dec 11, 22:27

Should be great if an AP section was created !
I'm already updating my file but it will take an eternity ! I don't know how you did...