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

User avatar
Carlo the Curious
Posts: 16999
Joined: Mon, 5. Mar 07, 22:03
x4

Post by Carlo the Curious » Thu, 22. Jan 09, 16:38

I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP), but it's okay in 2003 (XP) and 2007 (Vista).
Last edited by Carlo the Curious on Thu, 22. Jan 09, 16:57, edited 1 time in total.

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

Post by ianrobo75 » Thu, 22. Jan 09, 16:53

Carlo the Curious wrote:I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP), but it's okay in 2007 (Vista).
excel 2007 has a bigger format limit so will be ok.

Have you tried sorting the filter drop down way, i.e. click on the filter arrow and select sort ascending or descending?

User avatar
Carlo the Curious
Posts: 16999
Joined: Mon, 5. Mar 07, 22:03
x4

Post by Carlo the Curious » Thu, 22. Jan 09, 16:58

You don't get a sort option from auto-filter in 2000 (at least, not the version I have - but it is old and unpatched).

2003 also works okay, btw.

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

Post by ianrobo75 » Thu, 22. Jan 09, 18:50

excel 2000 must have a lower number of formats limit then.

User avatar
Carlo the Curious
Posts: 16999
Joined: Mon, 5. Mar 07, 22:03
x4

Post by Carlo the Curious » Thu, 22. Jan 09, 19:05

Cell styles? It's 4000, apparently, same as 2003 (2007 is 64000). Curious...

User avatar
Shadow_180
Posts: 91
Joined: Wed, 11. Aug 04, 13:26
x3tc

Post by Shadow_180 » Thu, 22. Jan 09, 20:56

Been using this since V1. Kudos for adding the other turret data, must've taken ages!

An idea to improve the results of filtering ships by equipable weapons -
Place dots in the entire column for a ship's weapon, even if it can only equip that weapon in one slot, then hide the dot (format it to white maybe?).

The result is that when using the weapon filters, all of a ship's turret data is kept together instead of rows disappearing.

Example; take the M3 sheet - if you wanted to find ships that can equip Ion Disruptors and used the filter, it would look like the Eclipse, Notus and standard Blastclaw have no turrets. A hidden dot would result in their turret data still being shown.
Alternatively if a ship can only equip a desired weapon in a turret and you used the filter the row with all its statistics would disappear.

I modified an older version of your sheet to do this and the results are pretty good, you should try it out and see what you think.

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

Post by ianrobo75 » Thu, 22. Jan 09, 22:57

ye, that's what I do for the main stats, show the same text in the background colour. I take your point for the guns, similarly for the missiles. I see a version 1.3 coming...

Crapgame
Posts: 130
Joined: Sat, 3. Jan 09, 15:03
x3tc

Post by Crapgame » Fri, 23. Jan 09, 04:47

Carlo the Curious wrote:I get the VBA error (run-time 1004, in Sub CommandButton Selection.Sort) on Excel 2000 (XP)
Yep, that's my problem. Office 2000

Oh well, no sort for me!

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

Post by ianrobo75 » Fri, 23. Jan 09, 11:49

Added the revised filtering, thanks Shadow_180. A fair chance of a few errors here, please message me if you find any filter or data errors.

User avatar
BugMeister
Posts: 13647
Joined: Thu, 15. Jul 04, 04:41
x4

Post by BugMeister » Mon, 26. Jan 09, 23:48

- great to have all that info in one place - excellent! :D :thumb_up:
- the whole universe is running in BETA mode - we're working on it.. beep..!! :D :thumb_up:

Crapgame
Posts: 130
Joined: Sat, 3. Jan 09, 15:03
x3tc

Post by Crapgame » Tue, 27. Jan 09, 00:05

Is anyone using this in Openoffice? If so, I may go back to that since my Excel 2000 isn't what it used to be.

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

Post by ianrobo75 » Sun, 8. Feb 09, 23:01

Crapgame wrote:Is anyone using this in Openoffice? If so, I may go back to that since my Excel 2000 isn't what it used to be.
The data is there in OpenOffice but the sorting doesn't work and the tab colours are missing.

NeverSnake
Posts: 5159
Joined: Thu, 9. Oct 03, 20:44
x3tc

Post by NeverSnake » Sun, 8. Feb 09, 23:24

The M7M turret info is still missing in version 1.3 (they were in pre-1.2 versions).
"There's an old story about the person who wished his computer were as easy to use as his telephone. That wish has come true, since I no longer know how to use my telephone" — Bjarne Stroustrup

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

Post by ianrobo75 » Mon, 9. Feb 09, 22:01

NeverSnake wrote:The M7M turret info is still missing in version 1.3 (they were in pre-1.2 versions).
Looking back at all versions they have all shown blank turret infos but I'll check the info out when I get chance.

User avatar
mad_axeman
Posts: 2928
Joined: Sat, 6. Mar 04, 16:44
x3tc

Post by mad_axeman » Thu, 12. Feb 09, 14:43

I've just tried opening this in Excel 2007 and I get no tabs at the bottom of the file. I'm stuck looking at what I assume is either the first or the last page.

Edit: Scrub that. Just re-opened it and they're there. Odd.

Arrak
Posts: 23
Joined: Fri, 22. Dec 06, 12:31
x3ap

Post by Arrak » Fri, 15. May 09, 17:58

Unless I'm missing something, there is no file to download at the moment.

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

Post by ianrobo75 » Sat, 16. May 09, 23:08

Arrak wrote:Unless I'm missing something, there is no file to download at the moment.
odd how they disappeared, latest restored now.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

Arrak
Posts: 23
Joined: Fri, 22. Dec 06, 12:31
x3ap

Post by Arrak » Thu, 21. May 09, 11:48

This is a fantastic collection of data! Makes looking up information of any kind so much easier. Thanks for creating this compendium.

I'm currently using it in OpenOffice, and the missing sorting etc. does not seem to be that dramatic.

BlackRazor
Posts: 4708
Joined: Tue, 20. Apr 04, 17:39
x4

Post by BlackRazor » Sat, 23. May 09, 13:32

With patch 2.1 getting near I guess (and sincerely hope) you'll update again the spreadsheet, so I'm reporting a few mistakes (mostly typos) found in the derelict ships section:

1) Hilas Joy should be Hila's Joy (missing apostrophe)
2) Duke/s Citidel should be Duke's Citadel
3) Oracoke’s Storm should be Ocracoke’s Storm
4) Thr’s Deprivation should be Tkr’s Deprivation
5) Unknown Sector by Unholy Decent should be Unknown Sector by Unholy Descent
6) The Z coordinate of the Buzzard Hauler in Tkr’s Deprivation is wrong: it says it's 2.0 but it actually is 62.5 (source)

As you see I'm just nitpicking, the only correction that is really needed is the wrong coordinate.

BTW thanks for the spreadsheet, it'b been really useful :thumb_up: :thumb_up:
"For the love of the Fish-Queen!"

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

Post by ianrobo75 » Sun, 24. May 09, 21:54

ye, will do a version 2.1. Nitpicking maybe but nice for things to be correct eh.
Win10 Home 64-bit, Intel i7-9750H @ 2.6GHz. NVidia GeForce RTX 2070 (8 GB). 16 GB ram.

Post Reply

Return to “X Trilogy Universe”