I am having no fun at all in programming river courses with excel, but then I am not a programmer. I successfully worked out a method of determining the river's path through a seven-hex group. Then I worked out a second river's path, entering the same hex, as obviously river confluences do occur. Now I am working out the circumstance of a river originating in a hex. This is all as dull as it sounds, but it's necessary, so I plod on.
I'm in a position, however, to show a little of my work, so I'm going to do that. But first, I need to discuss a problem with hexes inside of hexes.
They are, to say the least, annoying as hell. The main problem, the one no one talks about, is that you are left with partial hexes around the outside, as shown:
This is all well and good if you're scratching out your world on pen and paper, but if you want to generate the contents of the larger hex, how do you handle those six 1/3rd hexes around the outside? Ignore them? Assume the internal hexes actually account for all the space, because they is a simulation? Or do you accept that what's show above is the equivalent of 9 hexes, instead of 7, and write your programming to suit. If you're going to do that, it would be easier to consider the whole representing 13 parts ... but let me tell you, when you are working out the path of a river, or where things might be place, you would rather work with 7 options rather than 13. Trust me.
I've decided not to recognize those hexes for the moment, with an expectation that I will account for them in the future. In the meantime, I'm going to assign each 'diamond' to the hex immediately counter-clockwise to it, and move ahead from there. I hope the gentle reader can forgive my laziness.
Okay, let's take the seven hexes inside the map I posted of southern Russia last week:
There's clearly not a lot of detail there. I don't propose at the moment to add a lot. Instead, I want to show generally the positioning of just two things: the rivers in hex, and those hexes which would be settled and those that are not, as shown below.
There the reader can see the similarities, the one with the other. Now of course this is drawn by hand, from the data created on the hex generation excel file I've built up so far. I'm not such a programmer that I can concoct images ... I leave that to some bright entity a lot smarter than me. The location of the town of Luka, moreover, has been determined by plotting it in place at approximately the same position that it appears in relation to the figure 2 above. It's position was not generated.
To bring new readers up to date, if they haven't read these posts yet, the white hexes indicate settled lands. The shaded hexes, wild lands. We find we have four different kinds of small hex - apart from the one containing the town, of course: river settled, river wild, highland settled and highland wild. Without having any other kind of information, we can already conjecture the sort of thing these four hex-types ought to contain.
To begin with, the heaviest rural settlement will absolutely be located in the river settled hexes. We can posit that at every point where a river crosses a hex side between two settled hexes, we have a significant settlement - probably not a village, as those have been designated on the map already, but likely a manor house of some kind, occupied by a minor local lord, plus a hamlet of 5-20 houses, along with a mill of some kind. Since a lot of this particular area is wild country, we see there are only two such places.
However, we can alternatively surmise that any settled hex containing a river might have such a settlement, and devise a random chance for that accordingly. We can also suppose that any settled highland hex might have a thorp, a small collection of 3-12 houses, probably without a local lord, but made up of independent cotters or villeins. The existence of the river, then, determines the size of the settlement, and settlements can only occur in settled hexes.
The country around the rivers is undoubtedly planted; the highland hexes, on the other hand, would be covered with herders. If a party moved away from the river, they wouldn't find farms ... unless you also incorporated a chance for the incorporation of natural springs - not large enough to initiate a river, but with a promise for irrigation. The highland hex's available water supply could thus be determined first ... and then if it was there, the chance for a thorp could hinge upon that. Things thus following one after another, and making sense. It also leaves the possibility open that, if the party should control the hex, they could identify those water supplies without thorps, and make haste to move people onto those lands and start them farming.
Now, wild lands with rivers would probably be overgrown areas, with various marshes or soft ground. They may also be canyons, with rocky ground and waterfalls ... that would be determined by the overall elevation of the hex, something I haven't yet incorporated. It stands to reason that a river wild hex suggests the river drops significantly below any settled hexes (the settled hexes around rivers would feature flat country good for crops), but if the river doesn't drop at all, that would indicate swamps.
It also stands to reason that highland wild hexes would be higher than settled highland hexes - the tops of hills, mountains, ridges and so on would be less likely to be settled. Thus, at the upper centre of figure three, where you see a patch of settled high country, the wild country all around would probably be hills and scrub. It helps that I know already that this is on the border between modern day Russia and Ukraine, and that I know any wild highland is simply too dry to sustain herding (but a wild area might also have an untapped spring, and that might prove very important for monsters and the like). And that probably, yes, the wild river valleys would be rocky places unsuitable for farming.
Inserting this information into a hex generation table is a monumental task, but that's the one I have before me. I can see from just the start of it how it promises to better define my world, even those remote areas where nothing on the map or in wikipedia is recorded. If I can tell where the monsters ought to be, and where the people are, and how the lay of the land creates ebb and flow, with patterns, for the manner in which those things group together and clash, I can really feel the life of the world beginning to bubble up from the cracks.
I don't really understand why this hasn't been tackled by some entity with a lot more money and creative firepower than just little ol' me.