EnglishGermanFrenchRussianItalianSpanish
Log inRegister
 
X3TC Stats and Resources Compendium V3.3.1 (28/09/2011) - links live again
Post new topic Reply to topic Goto page Previous  1, 2, 3 ... 12, 13, 14, 15  Next
View previous topic :: View next topic
Author Message
Zippo342





Joined: 31 Mar 2006
Posts: 345 on topic

Thank you for registering your game
PostPosted: Sat, 7. Jan 12, 03:36    Post subject: Reply with quote Print

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

Code:
=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.

Back to top
View user's profile Send private message
RustInPieces



MEDALMEDAL

Joined: 13 Feb 2012
Posts: 83 on topic

Thank you for registering your game
PostPosted: Fri, 17. Feb 12, 13:37    Post subject: Reply with quote Print

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.

Back to top
View user's profile Send private message
ianrobo75





Joined: 13 Aug 2007
Posts: 289 on topic

Thank you for registering your game
PostPosted: Wed, 7. Mar 12, 23:13    Post subject: Reply with quote Print

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.


_________________
Win7 Pro SP1 64-bit, Intel i7-3740QM @ 2.7GHz. NVidia Quadro K4000M (4 GB). 16 GB ram.
Back to top
View user's profile Send private message
harvie-smith





Joined: 26 Aug 2007
Posts: 2 on topic

Thank you for registering your game
PostPosted: Thu, 26. Apr 12, 09:36    Post subject: Reply with quote Print

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.

Back to top
View user's profile Send private message
MiLkou



MEDALMEDALMEDAL

Joined: 22 Aug 2007
Posts: 25 on topic

Thank you for registering your game
PostPosted: Wed, 9. May 12, 16:49    Post subject: Reply with quote Print

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
Back to top
View user's profile Send private message
Sovereign01





Joined: 25 May 2005
Posts: 1439 on topic

Thank you for registering your game
PostPosted: Sun, 5. Aug 12, 03:08    Post subject: Reply with quote Print

Shame there's no AP version (at least for ships & weapons)- while I remember, there's a spelling mistake, in Terran Ranks you missed an L in Local Councilor.

It's when I play AP and realise how much I've come to rely on this for TC that I'm reminded how awesome this is.


_________________
In The Threat, the Odysseus was the ship of choice.

In Terran Conflict, it was my Skirnirs that brought the destruction.

In AP, it was my fleet that greeted the Xenon!
Back to top
View user's profile Send private message
The s0rc3r





Joined: 29 Dec 2006



PostPosted: Sun, 12. Aug 12, 02:48    Post subject: Reply with quote Print

I release a DB-relational of RAW data :
https://rapidshare.com/files/3926235...B-12.08.12.zip

Back to top
View user's profile Send private message
TheRealBix



MEDALMEDALMEDAL

Joined: 02 Jul 2009
Posts: 399 on topic

Thank you for registering your game
PostPosted: Sun, 12. Aug 12, 02:53    Post subject: Reply with quote Print

Your link doesn't work Oops


_________________
Aidez les chatons
My mods : ButterRanges, ButterRewards, ButterMissions, No Music In Highways, TAF!
Back to top
View user's profile Send private message
The s0rc3r





Joined: 29 Dec 2006



PostPosted: Sun, 12. Aug 12, 13:12    Post subject: Reply with quote Print

:/ oups, bad copy/paste
https://rapidshare.com/files/39262353/X3TC-GenericDB-12.08.12.zip

PS: file format is LibreOffice Base. asc file is a GPG signature
sry

Back to top
View user's profile Send private message
The s0rc3r





Joined: 29 Dec 2006



PostPosted: Sat, 18. Aug 12, 17:38    Post subject: Reply with quote Print

https://rapidshare.com/files/717796787/X3TC-GenericDB-12.08.15.zip
Update: Adding french trads and better missile description

Back to top
View user's profile Send private message
Eddis





Joined: 05 Aug 2009

Location: Tokyo, Japan

PostPosted: Mon, 7. Jan 13, 07:29    Post subject: Reply with quote Print

Hello!

It appears that all the links for the compendium on the OP are down/dead.

Can someone please post a working link?

Back to top
View user's profile Send private message
Carlo the Curious





Joined: 05 Mar 2007
Posts: 15622 on topic
Location: London, UK
Thank you for registering your game
PostPosted: Mon, 7. Jan 13, 13:21    Post subject: Reply with quote Print

The OP links work for me.

Back to top
View user's profile Send private message Visit poster's website
Pikho_001





Joined: 12 Jan 2013
Posts: 2 on topic

Thank you for registering your game
PostPosted: Sat, 12. Jan 13, 17:59    Post subject: Reply with quote Print

Hello.

Is there any chance anyone could reupload the links?

Thanks

Back to top
View user's profile Send private message
Alan Phipps
Moderator (English)
Moderator (English)

MEDALMEDALMEDAL

Joined: 16 Apr 2004
Posts: 17965 on topic
Location: Stonehenge, UK
Thank you for registering your game
PostPosted: Sat, 12. Jan 13, 18:09    Post subject: Reply with quote Print

As Carlo said, all 3 links appear to be working with 100-300 downloads over the last 2 weeks. Check that your Firewall/AV is not blocking it as a rarely used site, or to avoid adware, or some such reason.


_________________
A dog has a master; a cat has domestic staff.
Back to top
View user's profile Send private message
Pikho_001





Joined: 12 Jan 2013
Posts: 2 on topic

Thank you for registering your game
PostPosted: Sat, 12. Jan 13, 18:53    Post subject: Reply with quote Print

Thanks for your reply, Alan Phipps.

I've already managed to get the file. The problem was that users from my country are not allowed to download files from filefront.

Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic Reply to topic Goto page Previous  1, 2, 3 ... 12, 13, 14, 15  Next
 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Control Panel
Login Data
The time now is Mon, 24. Sep 18, 18:57

All times are GMT + 2 Hours

[ Disclaimer / Impressum ] | [ Privacy Policy / Datenschutz ]

Board Security

Copyright © EGOSOFT 1989-2018
Powered by phpBB © 2001, 2005 phpBB Group
Template created by Avatar & BurnIt!
Debug: page generation = 0.22518 seconds, sql queries = 29