•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do i control the randomization of the values? (For mapmaking)
Our take
Creating a fantasy map in Excel can be an exciting endeavor, especially when it comes to generating realistic elevation values. While using the RAND() function offers randomness, it often leads to scattered values that don't effectively resemble cohesive landmasses. To control the randomization and encourage clustering, consider employing methods like Perlin noise or adjusting your random values with constraints that promote geographical continuity.
So i want to create a map in Excel, like an actual fantasy map. The values in the cell are the elevation. Then based on the elevation values, the color changes with conditional formatting.
I know I could manually input the values yes but I want to automatically generate them while still keeping a semblance of landmasses.
Right now I'm using the RAND() to randomize the values but as you can see the values are all over the place (see image below). How do I control the values randomization so that <0.1 (water) will group together and >0.1 (land) will not be isolated?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#cloud-based spreadsheet applications#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#mapmaking#Excel#randomization#elevation#conditional formatting#RAND()#landmasses#automatically generate#values randomization#values#water#land