Merroc's Asteroid List (TC 1.4)

[Merroc]

**support dropped & link removed, 3 August 2011**

Im back with a new list of asteroids, this time for TC 1.4.

There are two versions this time, both are made in Office 2007, one is in the new .xlsx style MS invented for some reason. Doesnt work in anything proir to Office 07 (doesnt work in OpenOffice3 either, it crashed).
Then there is the .xls version, which has compatibilty issues (see the sheet inside the document), resulting in reduced functionality (the list is still there, the pivot tables most likely wont work). This one can be opened in OpenOffice 3, but again here the pivot tables dont work. The .xls also has the annoyance that it thinks there is a macro, but i deleted it... So dont worry its not there .



Enjoy.

[PabloRSA]

With a search of silicon at 60+ yeild reveals results of.

Argon Antigone Memorial Silicon Wafers 61 13254 -1135 17569
Argon Antigone Memorial Silicon Wafers 61 13254 -1135 17569
Terran Asteroid Belt Silicon Wafers 70 -4260 3833 -52787
Terran Asteroid Belt Silicon Wafers 64 -52037 9520 -10576
Split Cho's Defeat Silicon Wafers 70 20206 -10499 11091
Split Cho's Defeat Silicon Wafers 70 20206 -10499 11091

You may see that some of them are repeated.

All in all excellent work and its one of them things i have been waiting for.

Thanks


Edit
. . . . .
Better mention that im using excel 2007

[Geggo]

Same duplicates exist in other asteroid lists aswell.

[Merroc]

Weird indeed... Cant be my fault, i just used the SE to get an array of all asteroids in the sector, im not looping through it twice... So im guessing there are actually two, mostly because its fairly random...

[Geggo]

If there are 2 roids listed in the exact same coords there is only one roid in reality. Duplicates are not even shown when mapping/scanning even if you never been in that sector.

[Carlo the Curious]

Should be easy enough to check the map file.

[Wolf-R1]

There are some duplicate asteroids but not because of an error in your file. Simply put there are duplicate asteroids in the X3TC universe. I experienced that the hard way in Tears of Greed. Two Silicon asteroids at x-8400 y-2311 z18698. You only see one 'roid but there are two there. When you plant a silicon mine on the first one you hear the "bump" sound and the mine starts losing shields. The only way I found around this was with the Complex Cleaner mod that took the mines and added them to the mega complex.

[X-Warrior B AS]

Split Cho's Defeat Silicon Wafers 70 20206 -10499 11091
Split Cho's Defeat Silicon Wafers 70 20206 -10499 11091

I can confirm that there are actually two of them out there in Cho's Defeat, close together. They are seperate in my game. Just found them last Saturday

[TBV]

Excellent! Thanks very much Merroc.

[Geggo]

Hmm, so if there really is 2 asteroids in the same space then one should blow up when you go IS right?

Then if you plant a mine on the asteroid and tow it away and wait for couple of days the other one should spawn back or are they considered the same.

[Wolf-R1]

You'd think it would explode but no dice. Furthermore you cannot move a station once you place an asteroid on it as the other asteroid is inside the station model. Thus you are screwed.

[Merroc]

Mobile mine one, build station, tow, wait for other to respawn?

At any rate, now we know which one they are . Better be careful .

[Merroc]

Ive just reuploaded them with a 2nd map sheet showing the totals of the sector (as opposed to the average).

[jlehtone]

I can confirm that there are actually two of them out there in Cho's Defeat, close together. They are seperate in my game. Just found them last Saturday

This reminds me of X3R. There were some Asteroids added by a patch. Triples, always triples. Like 3x64 Sil in the second Unk below southern Paranidia. And they seemed to have a bit random co-ordinates in some people's games (quite sure there was a thread about that couple years ago ...).

Thus, the logical guess is that Dev has placed two/three objects to same coordinates with expectation that the "avoid collision" engine creates them a bit apart, creating minor randomness in your game. But then the rocks have spawned happily at identical coordinates for several users. Never trust the computer.

[ianrobo75]

Merroc, Any plans to update this for V2.1.

I'm looking to add it to my stats and resources excel sheet (http://forum.egosoft.com/viewtopic.php? ... sc&start=0) since a couple of people have requested it now.

Alternatively do you run a script to get the source data? If so which one?

[EgoGimb]

Im back with a new list of asteroids, this time for TC 1.4.

There are two versions this time, both are made in Office 2007, one is in the new .xlsx style MS invented for some reason. Doesnt work in anything proir to Office 07 (doesnt work in OpenOffice3 either, it crashed).
Then there is the .xls version, which has compatibilty issues (see the sheet inside the document), resulting in reduced functionality (the list is still there, the pivot tables most likely wont work). This one can be opened in OpenOffice 3, but again here the pivot tables dont work. The .xls also has the annoyance that it thinks there is a macro, but i deleted it... So dont worry its not there .

The .XLS version 122kb
The .XLSX version 269kb

Enjoy.

how do you view the XLS or the XLSX files?

[TTD]

At the risk of getting an old thread locked...

Download the file.
un-archive it with 7zip(for example)
open the file.
It should then open into OpenOffice or Xcalc or what ever your preferred office software is.