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

General discussions about the games by Egosoft including X-BTF, XT, X², X³: Reunion, X³: Terran Conflict and X³: Albion Prelude.

Moderator: Moderators for English X Forum

pamme
Posts: 2
Joined: Sat, 6. Aug 11, 19:55
x3ap

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
Posts: 309
Joined: Mon, 13. Aug 07, 11:47
x4

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.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

User avatar
TTD
Posts: 11165
Joined: Sun, 6. Jul 08, 10:29
x4

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

Direct link in my sig.

Now includes Steam DLC sector @ 450% sun !

Kwaio
Posts: 10
Joined: Sun, 4. Jan 09, 16:10
x3tc

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.

User avatar
TTD
Posts: 11165
Joined: Sun, 6. Jul 08, 10:29
x4

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
Posts: 29
Joined: Tue, 24. Aug 04, 20:13
x3tc

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
Posts: 309
Joined: Mon, 13. Aug 07, 11:47
x4

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.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

ianrobo75
Posts: 309
Joined: Mon, 13. Aug 07, 11:47
x4

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).
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

Tarthrin
Posts: 29
Joined: Tue, 24. Aug 04, 20:13
x3tc

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.

User avatar
SkullCowboy
Posts: 137
Joined: Mon, 23. Aug 10, 01:37
x3tc

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!
I say we take off and nuke the entire site from orbit. It's the only way to be sure...

User avatar
nponoBegHuk
Posts: 474
Joined: Thu, 6. Mar 08, 19:55
x4

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).
Last edited by nponoBegHuk on Sat, 1. Oct 11, 13:38, edited 1 time in total.
Fast sector selection on the Universe Map | Rock locations for Mobile/OOS mining | Botting for max speed Hyperion | Complete list of ship sources | Capturing smaller ships

My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found

blackfire83
Posts: 595
Joined: Tue, 13. Jul 04, 13:03
x4

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

Isn't it Harmony of Perpetuity?
Count the bodies like sheep to the rhythm of the war drums...

X3:TC - Battlemaster, Master Industrialist

User avatar
nponoBegHuk
Posts: 474
Joined: Thu, 6. Mar 08, 19:55
x4

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

blackfire83 wrote:Isn't it Harmony of Perpetuity?
erm.... yep, thanks, typo corrected ;)
Fast sector selection on the Universe Map | Rock locations for Mobile/OOS mining | Botting for max speed Hyperion | Complete list of ship sources | Capturing smaller ships

My current ship collection:
11 out of 11 *retired* ships found
17 out of 17 *unique* ships found
9 out of 9 *limited* ships found
16 out of 16 *rare* ships found

User avatar
SkullCowboy
Posts: 137
Joined: Mon, 23. Aug 10, 01:37
x3tc

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. :)
I say we take off and nuke the entire site from orbit. It's the only way to be sure...

User avatar
TheRealBix
Posts: 400
Joined: Thu, 2. Jul 09, 14:34
x4

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...

Zippo342
Posts: 410
Joined: Fri, 31. Mar 06, 20:07
x3tc

Post by Zippo342 » Sat, 7. Jan 12, 02:36

On the Open Office version, your coding for player and race ranks does not work. I was able to fix it by putting

Code: Select all

=MATCH(B36;B3:B33;0)
in cell B37 and copying that to D37, as well as using data validation based on a cell range from the above named ranks on B36 and D36. I also did something similar (range was smaller) on the Race Ranks page to fix that as well.

As it sits now you have a drop down menu to select the rank and then you enter the numerical % as you progress through the rank below it.

Just thought that I might help you out with Open Office work here. I do think though that the MATCH function works the same in Excel, though I do not have Excel here to verify.

RustInPieces
Posts: 84
Joined: Mon, 13. Feb 12, 08:22
x4

Post by RustInPieces » Fri, 17. Feb 12, 12:37

I am just starting out in X3, playing humble trader for my first playthrough. I have a couple questions.

1. Is it possible to save a single sheet (or just 2-4) as a seperate spreadsheet? This spreadsheet is massive, and has tons of useful information, but if I just wanted to look at the wares or resources sheet, it takes a minute to load. I am using LibreOffice, if it makes any difference.

2. Is there a way on the wares or resources sheet, to enter my maximum cargo space, and then have it tell me how much I would get for a full cargo hold of each item (assuming buy at minimum and sell at maximum) I don't know how to use spreadsheets or formulas.
I have been using a calculator and doing 3000 (cargo space) / volume of item = # of items I can hold, and then multiplying that by difference cell on the resources sheet. Anyway to make the spreadsheet do that for me?

Thank you for the awesome spreadsheet.

ianrobo75
Posts: 309
Joined: Mon, 13. Aug 07, 11:47
x4

Post by ianrobo75 » Wed, 7. Mar 12, 22:13

All - I'm all spreadsheeted out. I'm currently playing other games until X Rebirth comes along and I've not even tried X3AP.

So,
'TheRealBix' - No plans to create an AP version.
'Zippo342' - If you want to update the spreadsheet for a specific Open Office version and email it to me I'll add it here - message me.
'SkullCowboy' - If I get the above update I'll update the other versions for your correction.
'RustInPieces' - Can't you just delete the sheets you don't want and save as another file name? The full cargo addition sounds easy enough just using the spreadsheet formulas but I guess you are not familiar with them - difficult to explain here. Again I'll take a look if I'm making other updates.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

harvie-smith
Posts: 2
Joined: Sun, 26. Aug 07, 01:04
x3tc

Post by harvie-smith » Thu, 26. Apr 12, 09:36

Seriously, from someone who "over indulged" on adjusting their T/files without making a vanilla backup of them, I thank you from the bottom of my Engine capacitors for taking the time and labour to make this.

It has saved me considerable time and frustration to restore alot of stats back to their correct settings.

MiLkou
Posts: 25
Joined: Wed, 22. Aug 07, 13:16
x4

Post by MiLkou » Wed, 9. May 12, 16:49

Thanks a lot for this great work. Happy to see that you keep it up to date.
X2 : Clear
X3R : Clear
X3TC : Clear
XR : In Progress

Post Reply

Return to “X Trilogy Universe”