About the excel spreadsheet of the world. Here's the explanation of the process starting with the precipitations:
Convert the main data from January and July to an hex code
using a table were each value in mm is tied to a hex value.
Each hex value represent a category
Example:
Attachment 104225
Then, we combine the values, one is red and the other is blue.
Convert these to a green value, one for each category. So far this is almost identical to the already existing tutorial.
Precipitations done for the moment.
Temperature
Same as with precipitations, we take the base data and give them hex values.
Combine both months.
Then convert temperatures to reduce the number of possibilities.
That's it for the temperatures.
Now we need to combine precipitation and temperatures, with an addition.
When that is done, we have the 500 something combinations.
Whit what I've explained in the previous message, we know what output give what climate, we just have to replace the values with the ones in the table and we get something like this once we format it properly
https://en.wikipedia.org/wiki/K%C3%B...h_authors).svg
It is still unfinished but so far it's seems to work. It is slow and I'm using the data at 10m resolution. It would be unthinkable for me to increase the resolution. We most of the time if only gets sluggish if there is missing data in the table as Excel tries to find something that does not exist, in 1 million of cells at the same time. Having good table is crucial. right now, each file has it's own table. I find it easier to work that way but I will have to link them to a master table so if I change the master, all the others will change to.
I haven't done extended test but it looks like changing the data in the categories, such as changing the temperature boundaries, works fine. and it's not too difficult as long as the tables include the new values.
It's harder to add new categories as the links between tables need to be added, but I haven't tried it.
For the moment, I will concentrate on finishing the generation of the climate world map based on the criteria we have settled for and we shall see the results.
One of my goal is to allow the modification and testing of different parameters without having to select a bunch of colours in Gimp/Ps
So this is just a first step.
Later, I will create another version that should be more flexible by including all the possibilities. It's an complete/unsimplified version if we can call it that way. Yet, it fuses the redundant temperature combinations such as Hot/cold and Cold/Hot since they are actually the same thing. Also simplify the tundra and polar climates so we only keep one of each. Lastly, it will only keep on Da and one Dd from the deadly cold winter column since they are either impossible or always wet unless then precipitations gets absurdly low. Even if we divided the precipitations by 2, they would still be humid. I also consider fusing together the tow Dc from the severely cold column but it might be affected if we decide to lower the precipitations.
It uses the same principle but because it doesn't uses precipitations categories (actually, I still need to convert the value to green, but they are all unique) , it is easier to use for the sake of testing and seeing the results (I assume).
The only drawback maybe is that is results in a lot more combinations in the end. Not a problem for Excel as long as all possible results are covered in the tables, but a problem if we want to use that in the tutorial.
With the actual number of categories, I get around 1298 combinations?