Page 1 of 2
Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 11:59 am
by marius
Hi commanders,
I was trying to use the spreadsheets at [wiki]Oolite_planet_list[/wiki] to get information on all the planets in Oolite. The spreadsheet in the first bullet point under the 'crazy names' subheading (
http://wiki.alioth.net/images/5/5c/Oolite_galaxies.zip) gives this information, but the figures for Productivity and Population are different to those in the game (perhaps the result of changes on the planet over time ???
).
e.g. for Lave, the info in the game agrees with that on the wiki
http://wiki.alioth.net/index.php/Sector1/Lave population is 2.5 billion, productivity 7000 MCr.
But the spreadsheet gives: population 2.9, productivity 8120. Other information is the same, e.g. radius is 4116 Km.
Do I need to change the seeds to get the game values? If so, any idea what to?
Thanks!
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 12:17 pm
by Gimi
First off, welcome to the friendliest Board this side of Riedquat.
I'm not familiar with the origins of that spreadsheet, but there are several OXP's around that change the planet/system data. Famous Planets and the Lave OXP both change Lave, and there are probably more. So, unless you have already done so, remove any OXP's or start the game in strict mode and see if the data in the spreadsheet matches.
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 12:18 pm
by maik
Hi marius, and welcome to the friendliest board this side of Riedquat (after a year of lurking
)!
From what the wiki states, the spread sheet you are referring to implements the generation algorithms. I would expect that there are differences to the algorithm used in Oolite, e.g. from different random number generators.
There are two other Excels linked to from the same page, just above the "crazy names" heading. Have you taken a look at those?
Cheers,
-Maik
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 8:39 pm
by marius
Hi, thanks for the replies.
Maik, yes, I have been using the other spreadsheets as well. One of them contains descriptions of the planets, but not the data on productivity, radius and population. I was trying to combine two spreadsheets to get a complete set of information.
Some good news - I have now discovered that the files used to build the vector maps contain some XML with raw planet data. These give Lave's population at 2.5 billion and productivity at 7000 MCr, as I find in the game and on the wiki, not as in the spreadsheet. I wanted to have the numbers as in a standard game, so I'm going to pull the figures out of the XML files to add to my dataset.
I take your point though, Gimi, about OXPs changing these values, so perhaps it doesn't matter too much. Currently I only have Oolite installed, no OXPs (and Oolite is in a sorry state, unplayable at 4FPS
but that's another story...) and I was checking the information against what F7 shows for different planets.
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 9:49 pm
by maaarcooose
I created a spreadsheet recently for my OOliteInfo utility.
http://theramist.co.uk/files/oolite_gal ... llinfo.xls
Have a look at my util if you havn't done already.
http://www.theramist.co.uk/blog/?page_id=80
!m!
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 9:56 pm
by Eric Walch
marius wrote:Hi, thanks for the replies.
Maik, yes, I have been using the other spreadsheets as well. One of them contains descriptions of the planets, but not the data on productivity, radius and population. I was trying to combine two spreadsheets to get a complete set of information.
When you have the console installed, you can also type in the console:
Code: Select all
for (var i=0; i<256; i++){log(System.infoForSystem(galaxyNumber, i).productivity)}
That will give you a list of all productivities in the current galaxy. You can than just copy and past it to your spreadsheet. For other galaxies info in this way, you need to be in that galaxy.
Re: Using spreadsheet to get planet data
Posted: Fri Nov 04, 2011 11:53 pm
by Fatleaf
marius wrote:Oolite is in a sorry state, unplayable at 4FPS
but that's another story...)
Well that's not good. Is there any way we can help you to resolve the issues?
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 12:06 am
by marius
Thanks maaarcooose, that's the information I needed! Out of curiosity, how did you get the productivity and population figures? Did you use the console (thanks Eric for the suggestion), or reimplement the algorithm? (BTW, I think your spreadsheet should go on the wiki.)
I've seen the screenshot, and it looks good - unfortunately, I doubt I can run your program on my linux machine. I'll confess though, I am using the spreadsheet in a similar little program of my own...
Fatleaf wrote:marius wrote:Oolite is in a sorry state, unplayable at 4FPS
but that's another story...)
Well that's not good. Is there any way we can help you to resolve the issues?
It needs a Linux/Ubuntu guru, I think. My computer suffered in a power cut, and files were damaged (including my oolite save
), so I ended up installing an upgrade to Ubuntu 11.04. I think it's a graphics' driver problem, as Oolite ran well on the earlier version. I must admit, I haven't tried
too hard to fix the problem, but I also don't know where to start. (The posts I have seen suggest changing settings in compiz/openGL, and I've tried those to no effect.) If you have any suggestions, I'ld be glad to hear them!
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 2:27 am
by Fatleaf
marius wrote:It needs a Linux/Ubuntu guru, I think. My computer suffered in a power cut, and files were damaged (including my oolite save
), so I ended up installing an upgrade to Ubuntu 11.04. I think it's a graphics' driver problem, as Oolite ran well on the earlier version. I must admit, I haven't tried
too hard to fix the problem, but I also don't know where to start. (The posts I have seen suggest changing settings in compiz/openGL, and I've tried those to no effect.) If you have any suggestions, I'ld be glad to hear them!
Try posting your issues in this section of the BB (
https://bb.oolite.space/viewforum.php?f=9) There are a few competent individuals around here.
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 7:41 am
by PhantorGorth
I am the author of that spreadsheet. If there are any problems I am quite willing to fix them. I will take a look at the calculations for those columns and fix accordingly.
Regards,
Phantor Gorth
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 8:21 am
by PhantorGorth
I have fixed the spreadsheet. I had fallen for the usual trap of using the Tech Level displayed (which starts at 1) not the true value (which starts at 0). Changing this in Population column fixes that issue and in turn fixes the Productivity at the same time.
Unfortunately since I wrote that spreadsheet in 2009 the Wiki has been updated and now no one is allowed to upload zip or even ods files (only png, gif, jpg, jpeg are allowed) so I can not update it. If the Wiki maintainers can either change that restriction or upload the file from
here for me then I would be very grateful.
Phantor
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 2:20 pm
by marius
PhantorGorth wrote:I have fixed the spreadsheet. I had fallen for the usual trap of using the Tech Level displayed (which starts at 1) not the true value (which starts at 0). Changing this in Population column fixes that issue and in turn fixes the Productivity at the same time.
Unfortunately since I wrote that spreadsheet in 2009 the Wiki has been updated and now no one is allowed to upload zip or even ods files (only png, gif, jpg, jpeg are allowed) so I can not update it. If the Wiki maintainers can either change that restriction or upload the file from
here for me then I would be very grateful.
Phantor
Yes, that does the trick! I edited the formula in column AG to first subtract 1 from the value in AF, and the values now come out right.
Thanks for taking a look.
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 2:55 pm
by PhantorGorth
marius wrote:Yes, that does the trick! I edited the formula in column AG to first subtract 1 from the value in AF, and the values now come out right.
Thanks for taking a look.
No problem. Hopefully one of the Wiki masters will see this thread and get my fixed file uploaded.
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 7:53 pm
by maik
PhantorGorth wrote:No problem. Hopefully one of the Wiki masters will see this thread and get my fixed file uploaded.
While I couldn't upload your file either (being only a minor wizard), I changed the page to link to the dropbox location of its new version. I have PM'ed the archmage asking for further promotion in the wizard ranks but apparently Winston didn't see the need... Might have asked for the wrong privileges, so will try again.
Re: Using spreadsheet to get planet data
Posted: Sun Nov 06, 2011 8:11 pm
by PhantorGorth
Maik,
Thank you for trying but I didn't want my Dropbox account being the source for that document on the wiki. Having my Dropbox account being the the source for stuff on the BB is okay as the bandwidth is likely to be less. Could you please change that back.
Regards,
Phantor