*SPOILER*Excel sheet with all the asteroids in the game (X³) updated for 2.0.x

[Merroc]

**UPDATED FOR 2.0.x**

Well, well.. Logaan's script proved to withstand the test of time and the test of a new game . Hence a somewhat faster creation of a nice big informative sheet. The one that contains all asteroids!! (and their locations).

I made some improvements as opposed to the X2 one (the one you non-dutchies will like is the total vanishment of the Dutch ).

Now there are two pivot tables, one per type, the other per yield.

New in 1.4.03: A map of the universe with the average yield per asteroid type. (sum of all yields divided by the number of asteroids). To give an indication where you can find the best asteroids.

Be sure to check it out if you dont mind a *cough*small*cought* spoiler .

here it is (zip 145kb). Happy mobile mining!!

Note: the former versions are still on the server, find them in the parent directory of the file above.

[Samata]

Well done Merroc!

[SoothSayer]

Thanks to all. This is awesome. Now if only there was a new universe map...

I'm willing to bet someone is working on that as we type.

Thanks again. rclloyd <----off to setup some mining.

RL

[Jaagiis]

Here you go rc: http://deman.co.uk/images/x3sectors-eng.jpg

[SoothSayer]

Jaagiis <---diamond in the rough. You're da man. Thank you!

RL

PS - and thx to Drow for creating...

[willbevan]

<3 it

n1 sir

[Rakeris]

Great job! This saves me a lot of time of scanning all the roids in the universe!!

[Merroc]

Updated to match 1.3
(and added useless info and credits)
See original post

[Skillers]

This is a great spreadsheet. Saves a lot of time.

[Githyanki]

Do yields affect mine's, or only mobile mining?

[Skillers]

Higher yeilds are better for mines. Think it decreases production time.

[Merroc]

Do yields affect mine's, or only mobile mining?

If you look at the Complete sheet, you will notice that every asteroid with a yield of 25 or more hae a yellowish background, while everything less has a grey background. This is done to easily spot which asteroids are good to put a mine on, because a station requiring ore or silicon use the production of 1 25 yield (ok, some claim its 26) mine.

[jlehtone]

Do yields affect mine's, or only mobile mining?

If you look at the Complete sheet, you will notice that every asteroid with a yield of 25 or more hae a yellowish background, while everything less has a grey background. This is done to easily spot which asteroids are good to put a mine on, because a station requiring ore or silicon use the production of 1 25 yield (ok, some claim its 26) mine.

For Ore, 25 is exactly sufficient, and for Silicon 25 is actually more than sufficient. More yield (and more crystal fabs) would be needed per SPP if there would be more than 100% sunlight anywhere.

See this for mine production math.

The point is, it is not a waste to build mines on low-yield asteroids. One such Mine L will not be able to support 5 weapon factories, as a mine on 25-yield would, but will support some, and a group of such mines will do the job. It just ain't integer addition, as the rest for complex matching is.


But a Q for mobile mining, how about all the smaller non-buildable roids added by 1.3?

[Merroc]

But a Q for mobile mining, how about all the smaller non-buildable roids added by 1.3?

To be honest, i have no idea. I knew there was a change in the asteroids, so i just reran the script and modified what i got from it. I have in no way checked ingame to see the situation. But since the script was pretty accurate in X² and X³ (pre 1.3), i may assume its no different now...
Then again, it only returned two subtypes, while I know there are more (since you can break them up and all). That leads me to believe that the smaller ones arent in the list. But on the other hand, i have no idea whether the smaller ones are actually in the game, prior for some player to bust the bigger ones up...

Im sure someone can check this and report back here. Since I probably dont have time for that (nor have i played X³ in quite some while...)

If there are some errors, im all to happy to try and modify the script in such a way, that i contains the little ones too (if that can be done).

[moggy2]

the 'other' 'roids are debris. At the moment the script editor cannot see them at all, I'm not even sure they're the same in each game.

[RBBOT]

This is a great help. On minor request - it would be useful to have an extra column on the "complete" sheet to indicate it a sector was "core" or "border".

[frymaster]

further to this, having sector x/y coords on the "complete" bit would be good, especially for "unkown sector"s

[DrVince]

How does the coordonates work? I know a sector goes from average -225,-225,-225 to 225,225,225. How does it relates to the huge numbers in the list?

[Merroc]

Sorry that i havent paid attention to this topic for the past 8 months. I was just looking to see why so many people are still downloading this file, while its included in the Complex Calculator too, and that one is a smaller download (because i didnt bother to zip this one). I was looking to disable the link and ask everyone to download the Complex Calculator.
However, first i would like to know why so many people are still downloading this file, is it because nobody stores it on their pc?

As for RBBOT and frymaster. I will look into it as soon as i look into the Complex Calculator again.

DrVince, the coordinates you see are in meters (e.g. 19057 in the list would be roughly 19km in the X3 ingame coordinates)

PS dont think i want to disable this link because i dont have enough bandwidth. Its just odd in my eyes. But I'll see what you guys have to say. Input please

[apricotslice]

PS dont think i want to disable this link because i dont have enough bandwidth. Its just odd in my eyes. But I'll see what you guys have to say. Input please

If you need an alternate download site, there is a recent thread offering to host files, with several different offerer's in it. The OP said he did not have bandwidth issues, hence the offer.