egosoft.com

v1.2 (X3TC 3.0)

A spreadsheet of the resource requirements for building ships at the PHQ.

• Excel
• PDF (1.0 version)

I originally created it just for my own information, but it may be useful to others.

It includes every maintype 7 (SSTYPE_SHIP) - so some are not actually obtainable in vanilla.

Some of the values may not be exact (they're mainly derived from the RelVal), but it should be close enough for most.

Race, ship name, class and RelVal were exported via a script, the ClassVal and factors are from the hq.xml file, and the multiplier constants are educated guesses (originally derived by Dave Toome).


EDIT:

• 08Feb11 - v1.2 - update for 3.0.
• 29Jul09 - v1.1 - added costs per hour.
• 16JJul09 - Added PDF version, courtesy of amtct.

Very handy, but could you re upload in a XLS instead of XLSX format.

Damn Office07...

The converter to read the new XML format docs within Office 2003 is about 20mb from Microsoft, and it's free. Excel will even offer to auto download it when you open an office 2007 document. Not exactly a pain to get around...

I did check it on my work laptop (Excel 2003) and it was fine - I guess our IT bods have already installed the converter.

Added it to the zip anyway.

Do I have to put credits in HQ? Or does that amount of credits stated for how much resources requirements per ships are worth or HQ actually consume credits? I thought HQ belongs to player. Is this some sort of taxes?

Even if the factories should be highly automatized in the X-Universe, there's always the need of workers and they have to get paid.

vbruzual wrote:Even if the factories should be highly automatized in the X-Universe, there's always the need of workers and they have to get paid.

Yet other player stations dont require credits for production. Even though there are people working on board.

yelgrun wrote:Do I have to put credits in HQ? Or does that amount of credits stated for how much resources requirements per ships are worth or HQ actually consume credits? I thought HQ belongs to player. Is this some sort of taxes?

Credits is one of the resources. Maybe they use them to decorate the captain's stateroom - all that rare art, you know .

The end column lists the total cost if you bought the wares as well (at average, but you can fiddle the prices on the Constants sheet if you want - e.g. to zero if you have a self-sufficient supply complex).

Thanks for this carlo, nice one!

If I need to recycle a ship using HQ, will I also get credits among other resources out of it?

No.

of course, I'm surprised. Putting credits in for producing ships only right? or for both RE, producing ships, even to recycle?

repair and construction require materials and credits.

Reverse engineer just requires time.

recycle provides you with materials, for a shorter amount of time.

Troubleshooter11 wrote: Yet other player stations dont require credits for production. Even though there are people working on board.

Their salaries are factored in the product price.
I noticed that Ranger is 1cr/ship. That would be awesome but now Ranger for some reason cannot dock on any carrier (may be with the exception of Aran). Otherwise Rangers would make handy freight drones. I wonder if it is a bug?
I have one Ranger waiting to get R/Ed.

kurush wrote:I noticed that Ranger is 1cr/ship. That would be awesome but now Ranger for some reason cannot dock on any carrier (may be with the exception of Aran). Otherwise Rangers would make handy freight drones. I wonder if it is a bug?
I have one Ranger waiting to get R/Ed.

I noticed that too, but I got the same thing from scripting in the blueprints.

I'd be interested to hear if you get similar results when it's finished REing.

That's a handy spreadsheet, Carlo. It works fine on my office computer (where I have Excel 2007 installed), but neither the XLS nor the XLSX version work correctly on my home computer in OpenOffice 3.1. The credits show up, but the rest of the resources all come up with a value of 0. It seems like OpenOffice isn't able to find the lookup values, or it's pulling the wrong ones.

I don't expect you to fix this (Excel is the standard, after all), but I thought I'd mention it for any other OpenOffice users that might be having problems.

try uploading it to google docs, and then downloading it as an .ods ?

Lancefighter wrote:try uploading it to google docs, and then downloading it as an .ods ?

I already tried converting it to an ODS from Excel 07, but that resulted in long formula-looking text in all the resource cells (probably a result of a faulty conversion).

EDIT: I just tried converting in Google Docs, and that fixed the resources, but messed up the times. I noticed that the second tab ("Averages") shows a bunch of divide by zero errors in Google Docs.

:\

Install excel on your other computer too?

does it work while uploaded to google docs?

What if you.. remote desktopped into your excel computer, copied the cells that dont work (and their formulas), and then pasted it into your open office spreadsheet?

Lancefighter wrote::\

Install excel on your other computer too?

does it work while uploaded to google docs?

What if you.. remote desktopped into your excel computer, copied the cells that dont work (and their formulas), and then pasted it into your open office spreadsheet?

If I had a copy of Excel to use at home, I wouldn't need to use OpenOffice.

As soon as I upload it to Google Docs, it messes up the hours. The conversion to ODS is identical to what's in Google Docs.

I was already planning on copying the values from the first sheet into a new spreadsheet, then opening that file in OpenOffice. I think that's the only option left at this point.