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

[Zippo342]

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]

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]

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.

[harvie-smith]

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]

Thanks a lot for this great work. Happy to see that you keep it up to date.

[Sovereign01]

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.

[The s0rc3r]

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

[TheRealBix]

Your link doesn't work

[The s0rc3r]

:/ oups, bad copy/paste
https://rapidshare.com/files/39262353/X ... .08.12.zip

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

[The s0rc3r]

https://rapidshare.com/files/717796787/ ... .08.15.zip
Update: Adding french trads and better missile description

[Eddis]

Hello!

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

Can someone please post a working link?

[Carlo the Curious]

The OP links work for me.

[Pikho_001]

Hello.

Is there any chance anyone could reupload the links?

Thanks

[Alan Phipps]

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.

[Pikho_001]

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.

[pref]

The problem was that users from my country are not allowed to download files from filefront.

Same here... where did you get the file?

[Geek]

Can not get these files too.

Edit : I got them using a proxy. These country restrictions are really dumb.

[galthar]

Could someone check or repair links for that files?

[Morkonan]

Could someone check or repair links for that files?

The file links are fine. It may be that you're having the same problem as another poster, a few posts up in the thread. You may be being blocked from downloading from Gamefront by your country's regulations or your internet provider.

[galthar]

Well yes I read about that, maybe that is true... but knowing that doesnt solve my/our problem. If someone could upload it somewhere else it would be nice. There are so many free upload sites, clouds etc.