 |
View previous topic :: View next topic |
|
|
|
|
|
Author |
Message |
|
|
|
|
|
Merroc
Joined: 16 Feb 2004
Posts: 3049 on topic
Location: Netherlands
 |
 Posted: Sat, 5. Nov 05, 00:42 Post subject: *SPOILER*Excel sheet with all the asteroids in the game (X³) updated for 2.0.x |
   |
|
**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.
_________________
Complex Calculations V3.0
Merroc's Asteroid List (TC 1.4)
Note: I swtiched provider, if a link in my post appears broken and links to www.xs4all.nl/... please contact me via PM.
Ill be back! - oh wait, i am back .
Last edited by Merroc on Sat, 23. Feb 08, 00:37; edited 4 times in total |
|
|
|
|
|
|
Back to top |
|
|
|
 |
|
|
|
|
|
Samata
 
Joined: 08 Apr 2004
Posts: 147 on topic
|
| Posted: Sat, 5. Nov 05, 01:11 Post subject: |
|
|
Well done Merroc!
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
SoothSayer
Joined: 27 Sep 2004
Posts: 165 on topic
Location: US-Lone Star State
|
| Posted: Sat, 5. Nov 05, 01:18 Post subject: |
|
|
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
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Jaagiis
Joined: 28 Oct 2005
Posts: 16 on topic
Location: UK
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
SoothSayer
Joined: 27 Sep 2004
Posts: 165 on topic
Location: US-Lone Star State
|
| Posted: Sat, 5. Nov 05, 01:45 Post subject: |
|
|
Jaagiis <---diamond in the rough. You're da man. Thank you!
RL
PS - and thx to Drow for creating...
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
willbevan
Joined: 09 Dec 2003
Posts: 143 on topic
|
| Posted: Fri, 25. Nov 05, 21:57 Post subject: |
|
|
<3 it
n1 sir
_________________
<3 my mamouth |
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Rakeris
Joined: 31 Dec 2003
Posts: 324 on topic
Location: Illinois, USA
|
| Posted: Sat, 31. Dec 05, 04:44 Post subject: |
|
|
Great job! This saves me a lot of time of scanning all the roids in the universe!!
_________________
If it moves shoot it, if it doesn't pick it up. |
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Merroc
Joined: 16 Feb 2004
Posts: 3049 on topic
Location: Netherlands
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Skillers
Joined: 24 Apr 2005
Posts: 537 on topic
Location: Omicron Lyrae
|
| Posted: Sat, 31. Dec 05, 18:12 Post subject: |
|
|
This is a great spreadsheet. Saves a lot of time.
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Githyanki
Joined: 13 Nov 2005
Posts: 46 on topic
|
| Posted: Sat, 31. Dec 05, 18:12 Post subject: |
|
|
Do yields affect mine's, or only mobile mining?
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Skillers
Joined: 24 Apr 2005
Posts: 537 on topic
Location: Omicron Lyrae
|
| Posted: Sat, 31. Dec 05, 18:13 Post subject: |
|
|
Higher yeilds are better for mines. Think it decreases production time.
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Merroc
Joined: 16 Feb 2004
Posts: 3049 on topic
Location: Netherlands
|
| Posted: Sat, 31. Dec 05, 18:17 Post subject: |
|
|
| Githyanki wrote: |
| 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.
_________________
Complex Calculations V3.0
Merroc's Asteroid List (TC 1.4)
Note: I swtiched provider, if a link in my post appears broken and links to www.xs4all.nl/... please contact me via PM.
Ill be back! - oh wait, i am back . |
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
jlehtone
Moderator
Joined: 23 Apr 2005
Posts: 14599 on topic
Location: GalNet BBS
|
| Posted: Sat, 31. Dec 05, 22:50 Post subject: |
|
|
| Merroc wrote: |
| Githyanki wrote: |
| 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?
_________________
X3R 2.5 + BP 3.1.07; Goner Pancake Protector X
Insanity included at no extra charge.
There is no Box. I am the sand. |
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
Merroc
Joined: 16 Feb 2004
Posts: 3049 on topic
Location: Netherlands
|
| Posted: Sat, 31. Dec 05, 23:36 Post subject: |
|
|
| jlehtone wrote: |
| 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).
_________________
Complex Calculations V3.0
Merroc's Asteroid List (TC 1.4)
Note: I swtiched provider, if a link in my post appears broken and links to www.xs4all.nl/... please contact me via PM.
Ill be back! - oh wait, i am back . |
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
moggy2
Joined: 06 Nov 2002
Posts: 4586 on topic
Location: Montréal
|
|
|
|
|
|
|
Back to top |
|
|
|
|
|
|
|
|
|
|
|
Template created by Avatar & BurnIt!
Search