Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: Demonides
« on: August 17, 2020, 11:20:10 AM »

Quote from: skoormit on August 17, 2020, 09:14:54 AM
Quote from: Demonides on August 17, 2020, 08:55:08 AM
Any chance to transfer this shet to google docs ?. Some people don't have microsoft exel.

Sure. Here it is.
I just imported it and spot checked it. I have not thoroughly tested it.
I wouldn't be surprised if some features are missing, but I expect the formulas should all be working.
Big THX
Posted by: skoormit
« on: August 17, 2020, 09:14:54 AM »

Quote from: Demonides on August 17, 2020, 08:55:08 AM
Any chance to transfer this shet to google docs ?. Some people don't have microsoft exel.

Sure. Here it is.
I just imported it and spot checked it. I have not thoroughly tested it.
I wouldn't be surprised if some features are missing, but I expect the formulas should all be working.
Posted by: Demonides
« on: August 17, 2020, 08:55:08 AM »

Any chance to transfer this shet to google docs ?. Some people don't have microsoft exel.
Posted by: skoormit
« on: August 17, 2020, 08:30:06 AM »

Quote from: db48x on August 16, 2020, 04:31:18 PM
Also, I'm sure there's a way to hook a spreadsheet directly to an sql database. I've never done it before, but I'm thinking about looking in to it.

It's a Sqlite database, which is a little bit harder to set up a connection to than a SQL Server database.
You need an appropriate ODBC driver (here's a free one that I use), and you need to use that driver to create an ODBC data source on your system, and then point Excel to that data source.
Posted by: Froggiest1982
« on: August 16, 2020, 09:57:16 PM »

Quote from: skoormit on August 16, 2020, 09:32:59 PM
Quote from: froggiest1982 on August 16, 2020, 08:44:19 PM

Earth:
starting
atm pressure 1.000
GH factor 1.100
Albedo factor 1.023
Base Temperature (Kelvin) 255.000
Surface Temperature (Kelvin) 287.002* displayed
This supposed to be 286.951
...

The values you see in the UI are rounded from the actual values in the database.
Earth's albedo is 1.02318.
With that value, the expected surface temp is 287.00199, which rounds to 287.002.

I see the problem is that I guess you can see the real full Albedo only in the database then. Thanks
Posted by: skoormit
« on: August 16, 2020, 09:32:59 PM »

Quote from: froggiest1982 on August 16, 2020, 08:44:19 PM

Earth:
starting
atm pressure 1.000
GH factor 1.100
Albedo factor 1.023
Base Temperature (Kelvin) 255.000
Surface Temperature (Kelvin) 287.002* displayed
This supposed to be 286.951
...

The values you see in the UI are rounded from the actual values in the database.
Earth's albedo is 1.02318.
With that value, the expected surface temp is 287.00199, which rounds to 287.002.
Posted by: Froggiest1982
« on: August 16, 2020, 08:44:19 PM »

Quote from: skoormit on August 16, 2020, 09:12:03 AM
Quote from: froggiest1982 on August 16, 2020, 03:15:26 AM
Quote from: skoormit on August 15, 2020, 09:42:42 PM
Quote from: froggiest1982 on August 15, 2020, 09:29:22 PM
Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, it does work, now I am trying to figure how much water evaporates once ice melts ;D

it should be the resulting atm *20 - current hydrosphere based on the post, however all simulation I am running have somehow returned different figures.

We know that 0.5 atm of vapor = 20 hydro extent.
So the ratio of vapor atm to hydro is 1:40.
Multiply your equalization vapor atm by 40, and that should be how much hydro was turned into vapor.

Thanks, I still believe something is wrong . The general calc for temperature on surface (base*albedo*gh factor) does also return different values than the one that should be after terraforming a planet.

Post some specifics, if you can. I'll take a closer look.

without going too far, just start a new game and look at Earth, then we terraform Luna (it's perfect because all settings are standard and either 0 or 1) and look at Mars.

Earth:
starting
atm pressure 1.000
GH factor 1.100
Albedo factor 1.023
Base Temperature (Kelvin) 255.000
Surface Temperature (Kelvin) 287.002* displayed
This supposed to be 286.951

Luna:
starting
atm pressure 0.000
GH factor 1.000
Albedo factor 1.000
Base Temperature (Kelvin) 255.000
Surface Temperature (Kelvin) 255.000

Goal
atm pressure 0.335
GH factor 1.051
Albedo factor 1.000
Base Temperature (Kelvin) 255.000
Surface Temperature (Kelvin) 268.112* displayed
*This supposed to be 268.005
Added 0.1 Oxy, 0.0179 Aestusium, 0.2173 Nitrogen

Mars:
starting
atm pressure 0.010
GH factor 1.007
Albedo factor 1.020
Base Temperature (Kelvin) 206.561
Surface Temperature (Kelvin) 212.112* displayed
this already supposed to be  212.167

Goal
atm pressure 0.334
GH factor 1.233
Albedo factor 1.035
Base Temperature (Kelvin) 206.561
Surface Temperature (Kelvin) 263.684* displayed
*This supposed to be 263.604
Remove Carbon Dioxide, Added 0.1 Oxy, added 0.2 Aestusium, adjusted to 0.0336 Nitrogen, adjusted to 20 Hydro
Posted by: db48x
« on: August 16, 2020, 04:31:18 PM »

Here's my version with my modifications, in case anyone wants to build on them. In addition to what I've mentioned before, I moved the race data to it's own sheet, and changed the mineral score to take quantity into account as well as accessibility. I also pasted all the formulas down to row 9999, just because a few thousand planets had fallen off the end of the spreadsheet when I first started and I didn't want to have to expand it too often. If I knew of a way to make _all_ rows on that sheet have the same formulas and formatting, I'd use that instead.

Also, I'm sure there's a way to hook a spreadsheet directly to an sql database. I've never done it before, but I'm thinking about looking in to it.
Posted by: skoormit
« on: August 16, 2020, 09:12:03 AM »

Quote from: froggiest1982 on August 16, 2020, 03:15:26 AM
Quote from: skoormit on August 15, 2020, 09:42:42 PM
Quote from: froggiest1982 on August 15, 2020, 09:29:22 PM
Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, it does work, now I am trying to figure how much water evaporates once ice melts ;D

it should be the resulting atm *20 - current hydrosphere based on the post, however all simulation I am running have somehow returned different figures.

We know that 0.5 atm of vapor = 20 hydro extent.
So the ratio of vapor atm to hydro is 1:40.
Multiply your equalization vapor atm by 40, and that should be how much hydro was turned into vapor.

Thanks, I still believe something is wrong . The general calc for temperature on surface (base*albedo*gh factor) does also return different values than the one that should be after terraforming a planet.

Post some specifics, if you can. I'll take a closer look.
Posted by: Froggiest1982
« on: August 16, 2020, 03:15:26 AM »

Quote from: skoormit on August 15, 2020, 09:42:42 PM
Quote from: froggiest1982 on August 15, 2020, 09:29:22 PM
Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, it does work, now I am trying to figure how much water evaporates once ice melts ;D

it should be the resulting atm *20 - current hydrosphere based on the post, however all simulation I am running have somehow returned different figures.

We know that 0.5 atm of vapor = 20 hydro extent.
So the ratio of vapor atm to hydro is 1:40.
Multiply your equalization vapor atm by 40, and that should be how much hydro was turned into vapor.

Thanks, I still believe something is wrong . The general calc for temperature on surface (base*albedo*gh factor) does also return different values than the one that should be after terraforming a planet.
Posted by: skoormit
« on: August 15, 2020, 09:42:42 PM »

Quote from: froggiest1982 on August 15, 2020, 09:29:22 PM
Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, it does work, now I am trying to figure how much water evaporates once ice melts ;D

it should be the resulting atm *20 - current hydrosphere based on the post, however all simulation I am running have somehow returned different figures.

We know that 0.5 atm of vapor = 20 hydro extent.
So the ratio of vapor atm to hydro is 1:40.
Multiply your equalization vapor atm by 40, and that should be how much hydro was turned into vapor.
Posted by: Froggiest1982
« on: August 15, 2020, 09:29:22 PM »

Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, it does work, now I am trying to figure how much water evaporates once ice melts ;D

it should be the resulting atm *20 - current hydrosphere based on the post, however all simulation I am running have somehow returned different figures.
Posted by: Froggiest1982
« on: August 14, 2020, 03:22:10 PM »

Quote from: skoormit on August 14, 2020, 08:07:43 AM
Quote from: froggiest1982 on August 14, 2020, 08:04:02 AM
Does anybody know how much water vapour we get into the atmosphere one the ice melts?

It should be the equalization pressure for the current total ATM and hydro extent.
From Steve's post:
Code: [Select]
Atmospheric Pressure * (Hydro Extent / 100) * 0.01 atm

Thanks, I'll run a couple of tests
Posted by: db48x
« on: August 14, 2020, 10:57:18 AM »

Quote from: skoormit on August 14, 2020, 10:03:31 AM
Quote from: db48x on August 14, 2020, 08:57:56 AM
Hmm, I see that Earth and Minerva have different ParentBodyIDs; Sol has 0 and Minerva has 3234.

Here's the fix:

Immediately after these lines:
…
Let me know if anything still (or anything else) seems amiss.

Yea, that did the trick:

Code: [Select]
SOL|SOL-A1|4.88|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|2|0.38|0.0|Y|409.853449623052|1.7|0|0|0|0|0
SOL|Sa Mines|12.104|0|0|0|0|11883.3558456979|13462.1937193773|0|0|22150.4044423818|0|32938.9783726841|0|0|0|0|0.1|1.0|0|0|0.8|0|0.7|2.6|2.6|2.6|2.6|0.25|68.5515765344433|2|0.
91|0.0||299.896247619238|1.0|0|0|0|89.745|3.255
SOL|Earth|12.756|11.2671006080972|12.5101746805206|18.9365619478989|0|0|80.728888913854|0|122.963028564712|0|0|0|0.21|0.21|0.24|0|0|0.51|0|0.62|0|0|0|0|0.62|1.79|1.79|0.0|0.2
03691917478566|2|1.0|0.697191653829571||255.0|1.02318|0.2|0|0|0|0.8
SOL|SOL-A3M1|3.474|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.0|10|0.1654|0.0|M|255.0|1.0|0|0|0|0|0
SOL|Mars|6.8|12629.2748993437|11324.7498165573|1997.53453245819|0|0|0|249.080349015484|0|0|0|0|0.6|0.1|0.8|0|0|0|0.9|0|0|0|0|1.5|2.4|2.4|2.4|0.0|27.505164680161|2|0.38|0.3333
80233670666||206.560700121407|1.03499048288813|0.100283125441885|0.369781450755004|0|0.000343087138326176|0.000258
Thanks!

Also, I made one other tweak that I forgot to mention. Real Stars universes frequently have star names from catalogs like HH Andromedea, or NN 3849. Therefore I changed the query so that the system and body names are abbreviated using substr(replace(sys.Name,' ',''),1,5). This skips the spaces and makes them a little longer, but they don't take too much extra space.
Posted by: skoormit
« on: August 14, 2020, 10:33:33 AM »

Quote from: Zincat on August 14, 2020, 09:40:54 AM
You should really post this in the utilies subforum skoormit XD

Good idea.
Done.