X3TC HQ Production Costs, v1.2

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

X3TC HQ Production Costs, v1.2

Post by Carlo the Curious » Thu, 16. Jul 09, 13:16

v1.2 (X3TC 3.0)

A spreadsheet of the resource requirements for building ships at the PHQ.
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.
Last edited by Carlo the Curious on Tue, 8. Feb 11, 18:53, edited 6 times in total.

User avatar
gunman127
Posts: 1523
Joined: Thu, 29. Dec 05, 20:38
x4

Post by gunman127 » Thu, 16. Jul 09, 13:23

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

Damn Office07...

RoadRunner12
Posts: 297
Joined: Mon, 14. Nov 05, 22:38
x3tc

Post by RoadRunner12 » Thu, 16. Jul 09, 14:44

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... :wink:

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

Post by Carlo the Curious » Thu, 16. Jul 09, 14:47

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.

yelgrun
Posts: 387
Joined: Sun, 25. Nov 07, 06:06
x3tc

Post by yelgrun » Thu, 16. Jul 09, 15:47

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?

Kapakio
Posts: 4442
Joined: Thu, 20. Oct 05, 20:43
x4

Post by Kapakio » Thu, 16. Jul 09, 15:59

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.

Troubleshooter11
Posts: 723
Joined: Sat, 8. Nov 08, 02:51
x4

Post by Troubleshooter11 » Thu, 16. Jul 09, 16:03

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. :?

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

Post by Carlo the Curious » Thu, 16. Jul 09, 18:07

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 :p.

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).

Rednoahl
Posts: 1400
Joined: Sat, 3. Jan 09, 15:48
x4

Post by Rednoahl » Thu, 16. Jul 09, 18:39

Thanks for this carlo, nice one!

yelgrun
Posts: 387
Joined: Sun, 25. Nov 07, 06:06
x3tc

Post by yelgrun » Fri, 17. Jul 09, 04:05

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

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

Post by Carlo the Curious » Sun, 19. Jul 09, 14:47

No.

yelgrun
Posts: 387
Joined: Sun, 25. Nov 07, 06:06
x3tc

Post by yelgrun » Sun, 19. Jul 09, 15:19

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

Lancefighter
Posts: 3144
Joined: Sun, 19. Dec 04, 02:41
x4

Post by Lancefighter » Sun, 19. Jul 09, 20:44

repair and construction require materials and credits.

Reverse engineer just requires time.

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

kurush
Posts: 4320
Joined: Sun, 6. Nov 05, 23:53
x3tc

Post by kurush » Sun, 19. Jul 09, 23:00

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.

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

Post by Carlo the Curious » Mon, 20. Jul 09, 04:25

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.

User avatar
Ecthelion
Posts: 612
Joined: Mon, 15. Dec 03, 20:36
x4

Post by Ecthelion » Wed, 22. Jul 09, 03:12

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.
Windows Windows 7 Release Candidate (64-bit)
Intel Core 2 Duo E8400
ATI HD 4850 1024MB
8GB RAM

-----------------------------------------------------
Pirate Identification Guide

Lancefighter
Posts: 3144
Joined: Sun, 19. Dec 04, 02:41
x4

Post by Lancefighter » Wed, 22. Jul 09, 04:49

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

User avatar
Ecthelion
Posts: 612
Joined: Mon, 15. Dec 03, 20:36
x4

Post by Ecthelion » Wed, 22. Jul 09, 05:01

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.
Windows Windows 7 Release Candidate (64-bit)
Intel Core 2 Duo E8400
ATI HD 4850 1024MB
8GB RAM

-----------------------------------------------------
Pirate Identification Guide

Lancefighter
Posts: 3144
Joined: Sun, 19. Dec 04, 02:41
x4

Post by Lancefighter » Wed, 22. Jul 09, 05:52

:\

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?

User avatar
Ecthelion
Posts: 612
Joined: Mon, 15. Dec 03, 20:36
x4

Post by Ecthelion » Wed, 22. Jul 09, 11:10

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.
Windows Windows 7 Release Candidate (64-bit)
Intel Core 2 Duo E8400
ATI HD 4850 1024MB
8GB RAM

-----------------------------------------------------
Pirate Identification Guide

Post Reply

Return to “X Trilogy Universe”