egosoft.com

Contents:
1. Introduction
2. Download link
3. FAQ
4. Version Information
5. Contact Info.

------------------------------------------------------------------------------------

1. Introduction
I know that sometimes it can take a while to work out how much you need to equip ships or set up factory loops, and I find I usually have to resort to guesswork.

So, to try to help this, I've put all the data into an Excel Spreadsheet to make it simpler. All that is needed is for you to type in how many of each ship/station/weapon/piece of equipment that you want, and the table will give you the total amount that it will come to.

-----------------------------------------------------------------------------------

2. Link
To download this table click here. And please provide feedback of what I can do to improve it.

-------------------------------------------------------------------------------------

3. FAQ

Q. Wheres the Equipment and Station Stuff?
A. Try the labled tabs at the bottom.

Q. Can't you have thousand separators to make the credit totals easier to read?
A. If you like you can add them in yourself:

khanis wrote:making the money amount have commas is easy people. Just highlight all the total column items dealing with money and Format Cells to Currency. Highlight, right click, format cells, select currency, click OK.

All versions other than version 1.0 have this fixed.

Q. [Name] hasn't been included. Can you add it?
A. See the Readme, if it isn't already listed as planned, then PM me and if its a good idea, and I can do it, I will add it.

Q. [Name] doesn't work/ isn't correct.
A. I'm not infallible, if theres something wrong then PM me and I'll correct it.

Q. How do I use the upgrade part?
A. All the upgrade values are at their max, so no fiddling with percentages or anything, simply type the number of ships in the appropriate column and select 'yes' from the appropriate drop-down box.

Q. Its read-only, I want to remove that.
A. Right click on the icon, and remove the tick from the read-only box, this should get rid of it. (This has been removed, and is only active in the first few downloaded tables of version 1.2)

Q. I don't like the colour, how do I get rid of it?
A. There should be a grey button above the '1' row label and left of the 'A' column label. Right click this, click 'format cells', 'patterns' and under cell shading select 'No colour'.

Q. I don't like the borders, how do I get rid of them?
A. Same as above, only after clicking 'format cells' click 'border' and select (under presets) 'None'.

Q. I can't read it, how do you make it bigger like in the previous version?
A. Its not actually resized, just zoomed out slightly. There should be a box in your 'standard' toolbar which has a percentage in (should be 75%), just change this to zoom in and out. If you can't see the box click on the arrow which reveals the rest of your options on the standard toolbar (it should be to the right of the ? in a speech bubble, the 'help' button). This should bring up a few more options including a button which says 'add or remove buttons', click this and then 'standard'. Then simply select the zoom option, it should add a zoom box.

------------------------------------------------------------------------------------

4. Version Information
Version 1.2 –
Information on engine upgrades, rudder upgrades and cargo hold upgrades. Also some formatting changes to try to help user-friendliness.

Version 1.1-
Added Product and Resource lists for factories.

Version 1.01-
Thousand commas added in, I can’t believe I forgot them.

Version 1.0 -
All basic tables believed to be completed, lists of all buyable ships, stations and weapons. Calculations believed to be correct.

Planned for next version:
Lists of additional equipment required for a basic set up per ship for ease of calculating.

-------------------------------------------------------------------------------------

5. Contact Info.
Any problems, don't hesitate to contact me. Preferably via my G-mail address:
cjmyo1@gmail.com
However you can also use my hotmail address (mentioned in the Readme):
cmyo996@hotmail.com

-------------------------------------------------------------------------------------

Great thanks to Rushyo for having hosted it for me.

Super WOOOT. Thats so swish.

Dont suppose you can add comma's aswell. I cant see the million mark.

Edit: Didnt see the other pages. Thats a Mega WOOOT all round then.

Edited Out - erroneous information

The stations and equipment are already in there, on different pages (look at bottom, there should be tabs to change page).

As for the commas between thousands . That was an almost unforgivably stupid thing for me to leave out. I'll put them in right now, and the new version should be up by tomorrow.

Man this rocks a mod should make this a sticky or put it in the guide, this is very useful



Cheers cant wait for the next version

Bonners wrote:All of which is fine and splendid and well done for the hard work... except that the prices fluctuate according to your Rankings with the Race from which you are proposing to purchase...

Thats not true. Only the price of renting a TL. Im sorry hireing.

Nice one, very handy
Ill add it to http://logaans-site.co.uk/x2 in just mo

)I kno this would be an extremly long and tedious task but having CargoBay Extension, Engine Tuneings and Rudder Optimization for each ship would be a good thing.

To help with taht im sure if you taught (or tehy taught themselfs) how to implement it all (i think i have the hang of it when i accerdently deleted a bitof teh codeing and couldnt be bothered to load up a new doc )

Im sure including myslef we woudl help you in that task (I will once i got X2 and money to try this out )

Dun suppose you could pm me when you have the new version on the forum? i might miss it with school an all

Thx for a great thing and like i said should be stickied

Thanks for all the compliments. If you get any ideas (other than those outlined in the readme for future implementation) for it, don't hesitate to suggest them.

BTW:

I kno this would be an extremly long and tedious task but having CargoBay Extension, Engine Tuneings and Rudder Optimization for each ship would be a good thing.

Thats already planned for a future version (see the readme) but for which one, I cannot say (it'll take a while to sort out).

Dun suppose you could pm me when you have the new version on the forum? i might miss it with school an all

Yeah, sure. If anyone else wants me to PM when then next version is ready then just ask.

Mea Culpa!

I shall remove my erroneous posting and leave others to edit out their replies to tidy this excellent thread.

Sorry

Oh yeah i just had a proper look at the readme

Note: if you need help with it, want to offer a suggestion, tell me of incorrect data or something like that and you can't seem to contact me, try the UNCC boards at www.rushyo.com/uncc as I check there pretty much every day.

making the money amount have commas is easy people. Just highlight all the total column items dealing with money and Format Cells to Currency. Highlight, right click, format cells, select currency, click OK.

Hehe i just found out that if you bought 1 of everything in that table apart from M and S class ships (L's only) it will cost you a total of:

1,634,047,421

Thats ALOT of credits



EDIT: Also there is a total of 45 diff ships, 151 Factories and 81 Weapons and Equipment buyable in this table

khanis wrote:making the money amount have commas is easy people. Just highlight all the total column items dealing with money and Format Cells to Currency. Highlight, right click, format cells, select currency, click OK.

Yeah, it is easy, but I've made the change anyway so that people don't have to do it (dunno when the new dl will be up though).

Myo wrote:

I kno this would be an extremly long and tedious task but having CargoBay Extension, Engine Tuneings and Rudder Optimization for each ship would be a good thing.

Thats already planned for a future version (see the readme) but for which one, I cannot say (it'll take a while to sort out).

I've nearly finished doing this, all I have left to do is input ship data. I haven't seen this spreadsheet yet but I suspect we can amalgamate our work without too many dificulties. If you want to go into partnership then send me a PM or an e-mail.

Excellent piece of work. Thanks for sharing!

Made the first post nice and neat with a little FAQ I can add to if any problems develop.

Anyway, the main reason I'm posting is that I've not checked this thread in a while, and I missed Rapier's post. That sounds like a great idea, can you please PM me some info on what you've done so far and we should be able to work something out?

Impressive...

FACTS are setting up their own guide and it is almost complete. Do I have your permission to add this to the FACTS database?


Jack Dunners

Right, the download for the 1.01 version has been sorted
(he didn't receive the file strangely, stupid hotmail).

And you are very welcome to add this to your database.