[X3APv2.0] Ships / Lasers / Missiles stats Viewer (Excel) [v0.6a 25.02.2012]

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
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

[X3APv2.0] Ships / Lasers / Missiles stats Viewer (Excel) [v0.6a 25.02.2012]

Post by konrad13x »

"X3AP Hangar" version 0.6a

Microsoft Excel based application which allows user to:
- see detailed informations about ships, weapon, missiles and shields,
- switch view between excel worksheet (table format, detailed informations) and application GUI (short info),
- compare up to 5 ships side by side (GUI),
- calculate ship's shields recharge time (GUI)'
- IMPORT function - allows to import stats from AP & TC, vanilla & mods (for now not tested on mods, so it is DISABLED).


Requirements: Microsoft Excel 2003 (or later) with enabled (temporary or permanently) macros.
"Compare" and "Import" buttons can be found in the top screen toolbar in "Add-ins" section (Excel 2007 onwards).


Screenshots:
Excel view
Compare Ships
Lasers
Missiles
Shields

[ external image ]
or website http://xdownloads.co.uk -> "X3:Albion Prelude" -> "Tools" section -> "X3AP Hangar"

Changelog:
v0.6a
- updated to X3 Albion Prelude v 2.0.
v0.5a
- fixed: no ships' variations (Raider...),
- fixed: in "Compare" ships Mosquito Missile appear in lasers' list.
v0.4a
- updated to X3 Albion Prelude v 1.1,
- changed GUI view.

Download site (Forum thread):
[ external image ]


Edit [21st Dec 2015]: replaced outdated x1tp with working xdownloads link and adjusted the download description accordingly. X2-Illuminatus
Last edited by konrad13x on Sat, 25. Feb 12, 04:04, edited 10 times in total.
kc99
Posts: 70
Joined: Mon, 21. Mar 05, 22:46
x3tc

Post by kc99 »

Just tried to open this on my XP machine but get "Compressed (zipped) folder is invalid or corrupt" message. Is it OK?
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

kc99 wrote:Just tried to open this on my XP machine but get "Compressed (zipped) folder is invalid or corrupt" message. Is it OK?
I've just downloaded the file and it's working fine. My suggestion is try to re-download program.
kc99
Posts: 70
Joined: Mon, 21. Mar 05, 22:46
x3tc

Post by kc99 »

Many thanks for the response. I've just tried again - same error. I'll try from a different machine tomorrow.
Cheers
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

kc99 wrote:Many thanks for the response. I've just tried again - same error. I'll try from a different machine tomorrow.
Cheers
I've tried it on PC and laptop with Vista x64 and x32 - both fine.

There is a new version as well, which hopefully will work better for you.
AshToDust
Posts: 166
Joined: Thu, 5. Jan 12, 11:12
x3tc

Post by AshToDust »

ain t working here either. Same error : corrupted zip format
Lanky
Posts: 323
Joined: Wed, 17. Mar 04, 15:13
x3tc

Post by Lanky »

I get the same corruption using WinRAR.
York "Lanky" Rider
Marine, Steve's Psychos
donvito
Posts: 6
Joined: Tue, 8. Feb 05, 09:21
x3tc

Post by donvito »

Same thing here....

Winrar says "corrupt file" when using my PC (windows XP.)

The funny thing is, I then tried dowloading it from an adroid device... (a tablet) and it works fine there.. Of course with the limitations that OS has for complex excel sheet reading... But file opens just fine.
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

I can't recreate your error.
Anyway, I've just re-packed file using 7z instead of winrar.
AshToDust
Posts: 166
Joined: Thu, 5. Jan 12, 11:12
x3tc

Post by AshToDust »

work like a charm now :)

Thx for the good work konrad :)
donvito
Posts: 6
Joined: Tue, 8. Feb 05, 09:21
x3tc

Post by donvito »

Works just fine now.. Thanks for fixing it and for the good job done.
Cheers
VincentTH
Posts: 6636
Joined: Wed, 6. Nov 02, 20:31
x4

Post by VincentTH »

Any chance this got updated for AP1.1?
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

VincentTH wrote:Any chance this got updated for AP1.1?
Done (v0.4a):
- updated to X3 Albion Prelude v 1.1,
- changed GUI view.

Regards.
AshToDust
Posts: 166
Joined: Thu, 5. Jan 12, 11:12
x3tc

Post by AshToDust »

Hi, same issue as we got with the 0.3a. Corrupted archive :)

Can you apply the same process you did for reposting the 0.3a few weeks ago ;)
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

AshToDust wrote:Hi, same issue as we got with the 0.3a. Corrupted archive :)

Can you apply the same process you did for reposting the 0.3a few weeks ago ;)
I'not sure what's going on as I've successfully opened archive on three different computers (Vista,7).

I packed 0.4a file using my overclocked gaming ring - maybe that's part of the problem.

Just repacked archive using laptop.
AshToDust
Posts: 166
Joined: Thu, 5. Jan 12, 11:12
x3tc

Post by AshToDust »

Still not working, just like it was when you put 0.3a online for the first time (corrupted zip error)... what a shame, I m fond of thoose sheets but 0.3a is outdated ^^
User avatar
konrad13x
Posts: 26
Joined: Fri, 19. Jan 07, 19:26
x4

Post by konrad13x »

Packed file again using 7z extension this time - maybe that will help.
AshToDust
Posts: 166
Joined: Thu, 5. Jan 12, 11:12
x3tc

Post by AshToDust »

Annnnnnnnnd.... it s working fine :)

thx for the great job (as last time ^^)
Theutus
Posts: 15
Joined: Sat, 14. Mar 09, 22:27
x3tc

Post by Theutus »

Here's where your DL link took me...

http://i36.photobucket.com/albums/e30/T ... TFlink.png


{Oversize image changed to link - Terre}
Sam_Walken
Posts: 30
Joined: Wed, 21. Dec 05, 20:55
x3tc

Post by Sam_Walken »

I'm using Excel 2007 with macros enabled and I can't figure out how to enable the ship comparison function, and any googling for information just leads back to this topic.

Return to “X Trilogy Universe”