Wednesday, November 3, 2021


Angels are etheric beings aligned with the axiomatic force of LAW. All angels hail from the Empyrean, which is a celestial demiplane that looks kind of like a birds-eye view of an infinite-petaled rose. When angels are not extant on earth or wandering the astral plane, their essence resides in the Empyrean along with the souls of lawful beings, though a small population live in the milk-white cities of the moon to oversee the lunar purgatory of the recently deceased.

According to the church, angels were created in order to interpret and propagate the emanations of Law from its hyperuronic realm to the prime material plane. Cosmic Law originates from a place of utter ideals, which emanate forth to the lower planes through various means (one of which being the religious practices of lawful mortals). Law stands in polar opposition to Chaos, which subsumes reality as opposed to emanating forth into it. Law vs. Chaos is not so much a conflict of "good" vs. "evil" as it is Apolaynian vs. Dionysian ideals, or preservation vs. transformation.

Angels operate on an entirely separate level of consciousness than mortals. When an angel conceives of a subject, everything there is to know about it springs into their mind. However, they never use the full breadth of information at their disposal to plan or strategize beyond what is necessary for the very next step. Not because they are incapable of doing so, but because it is wholly against their nature—scheming is for mortals and demons. Angels know no urge or impulse; each moment is evaluated with all available information, and each decision is made based off of what course of action will bring them closest to finishing their task, as ordained by the cosmic forces of Law. Angels are not infallible, yet when one falls they do so after having evaluated all courses of action with all available information. Thus, every angel who has ever fallen has done so willingly and with no regrets. Both angels and demons are spiritually oriented toward their respective alignment, but are still creatures that think and feel, that have personalities and the capacity to develop views and opinions. Fallen angels are also known as devils, and ascended demons are known as archons. 

Most angels never consider whether or not they have free will. They see themselves as agents who from their inception were set on a track that spans eternally into the future. No angel claims to dream, but some have before. They dream of the after the utter end, beyond the conflict of cosmic forces, beyond when the last order of Law has been enacted, beyond the collapsing of the planes, beyond the death of all known and unknown things.

Every angel has the following features: Flight, resistance to spells like charm and sleep, invulnerability to mundane weapons, the ability to produce light (maximum radius equal to 10' x Type number), infravision, and magic resistance (Base 50%, increasing 5% with each type). Angels can speak and read every language (though only when the situation demands), are immune to disease and poison, and can detect invisible creatures.

Type I: Cherubim

It is more accurate to describe the cherubim as quasi-angels, but they’re often grouped with the rest of them. A cherub on its own is a single particle of angelic essence. A set amount of cherubim exist on the earth at any given time, in higher concentrations in areas oriented toward Law and nearly nonexistent in areas of Chaos. Cherubim in heavy concentrations can manifest as beams of light, spontaneous inspiration, bouts of virtuous fervor, or cryptic patterns encoded in the natural world. 

Cherub particles can form a sort of ontolo-molecular bond with eachother, which creates a chain reaction that eventually forms a (celestial) sphere-shaped entity that is the common conception of a cherub: what appears to be a human toddler enveloped in a bubble of light. Once these entities are formed, they can think and speak for themselves just as any other angel. For all intents and purposes beyond those of exclusive concern to the more esoteric sects of the church, these sphere-creatures are what most people mean when they speak of cherubs. Cherubim can only maintain their collective form for brief periods of time.

Frantisek Kupka

HD: 1 AC: 3 Move: 140’ (flying) Morale: 9 Attack: Ray of light, 1 point of damage and hit creature must save vs. spells or lose the will to fight. 

Cherubs remain for 1d6 rounds after they are first encountered. If a lawful cleric is in the party, the cherub will offer to grant a blessing in exchange for a suitable prayer. When the cleric prays to the cherub it will make a reaction roll, with a result of 9 or higher signifying that the blessing will be granted. The roll gets a +1 bonus for every other lawful PC that prays. Offerings like coins or wine will also grant appropriate bonuses. Only one roll is made per party.

Cherub boons

  1. Fortune. The next treasure or coin horde the party acquires will be 10% more valuable (a 100 gp gemstone becomes a 110 gp gemstone, or a chest of 2000 cp instead would contain 2200 cp).

  2. Allyship. The cherub will manifest and fight alongside the PCs the next time they are in combat.

  3. Healing. Each party member restores 1d4+1 hit points. 

  4. Insight. The cleric can ask the cherub a single question about their current situation or the immediate surroundings, to which the cherub will offer an answer in the form of a cryptic clue. The more specific the question, the more definite the clue. 

  5. Comradery. The PCs' followers get +1 to their morale and loyalty scores.

  6. Guardian Angel. The next time a PC would be reduced to 0 hit points or fails a save that would result in their death, they miraculously avoid the danger.

Type II: Malakim

Malakim serve as the messengers and general-purpose task executors of the Empyrean. They are often charged to convey mystical truths of Law, guard forbidden areas, ensure that cosmic duties are fulfilled, and offer guidance and direction in matters of the church. They don’t have a consistent form when manifesting in the prime material plane, instead adopting whatever appearance is best suited for the task—or at least, whatever appearance is best suited according to the inscrutable reasoning of angels. Usually they take the shape of shimmering humanoids, birds (typically swans or doves), floating flames, or talking statues.

HD: 4 AC: 3 Move: 140’ Morale: 9 Attack: 1d6 (touch, treat target’s AC as unarmored)

Malakim occasionally manifest with swords, but usually fight unarmed or with natural weapons appropriate to their form. The mechanics don’t change—a single touch can dislocate a joint, raise a bruise, or cause a muscle to spasm. Likewise, their touch can reverse all previous damage they caused an opponent. Malakim don’t typically fight to kill mortals, instead only engaging in combat if they would otherwise be prevented from fulfilling their duty. 

Typical tasks of the Malakim

  1. Accompany pilgrims through the Valley of Woe.

  2. Protect the sacred texts hidden in an abandoned monastery.

  3. Guard the entrance of a terrible dungeon to prevent mortals from meeting their doom.

  4. Enlist “improbably destined” individuals for sacred missions when the usual heroes are occupied.

  5. Protect a poor (though loose with its offerings) village from monsters and evil spirits.

  6. Manifest in a great cathedral to help punctuate a particularly resonant sermon.


Type III: Seraphim

Angels of force, whose name means burning; seraphim are the primary warriors of the angelarchy. While the forces of Law and Chaos are currently locked in a cold war–style stalemate, seraphim are the elite units who get dispatched for special commando missions in the many cosmic proxy-wars such as the one happening on earth. They will only ever manifest in the prime material plane when necessary to carry out their mission or when they are petitioned to combat a direct threat to the church. A seraph’s body is completely covered in platinum armor intricately etched with sacred geometry, save for their blazing wings and head, which glow white-hot and are hard to look at. They sing a particular song in battle, which to mortal ears sounds like a thousand people all running their fingers around the mouths of wine glasses in a train tunnel with perfect acoustics.

Volkan Baga

HD: 8 AC: -1 Move: 240’ Morale: 12 Attack: Weapon (see below) x 2 and Wing Bursts or Brazen Exultation 

Wing Bursts: Every creature in a 20’ radius must save vs. breath weapon or take 1d6 damage as the Seraph’s wings release bolts of fiery energy that rain down around them.

Brazen Exultation: The seraph brings their song to a sublime crescendo, which releases the pure celestial energy sealed within their body. The effect functions as a fireball spell cast by an 8th-level MU centered on the seraph with a radius of 60'. The seraph can do this once per day, only in a moment of desperation. 

Seraph weapons

  1. Lightning sword +2. 1d8+2 damage. Bolts of lightning leap from the blade on a successful attack, causing enemies within 10’ of the target to save vs. spells or take 1d6 damage. Once per week, the sword can be raised toward the heavens to call forth a bolt of lightning anywhere within 240’, dealing 6d6 points of damage to creatures within 20’ of the bolt, save vs. spells for half. 

  2. Flaming lance +1. 1d10 damage, range 20’. Once per turn, the wielder can forgo attacking for one round to charge the lance. The next round, the lance can release a 60’ jet of flame that deals 3d8 damage to everything in its path, save vs. spells for half. 

  3. Radiant javelin +1. 1d6+1 damage, range 40’/80’/120’. Turns into a beam of light when thrown, returning to the thrower once it meets its destination (so functionally instantaneously). Can be thrown by either hand with equal ease. 

  4. Holy fists. 1d6 damage/2d6 against chaotic creatures. Angels are really fucking strong, to the extent that weapons can be unnecessary. Hit creatures get knocked back 10’ unless the attacker wishes otherwise. 

In the event that a PC acquires a Seraph’s weapon, one of several things may happen. If the weapon was stolen, it turns to lead. If the weapon was won from the defeated seraph, it persists for one hour until it fades away. If the weapon was gifted to the PC to complete a task an angel is otherwise unable to do, it lasts until the PC completes their task, strays from their mission, or dies. If holy fists are granted, the PC gets glowy hands that shine when they form a fist. 

Type IV: Principalities

Principalities are understood to be the celestial bureaucrats of the angelarchy, as well as arbiters of cosmic law, executors of justice, scribes to the whims of fate, and keepers of sacred knowledge. Principalities appear as pale statue-like beings with blank eyes and elaborate flowing robes. They always manifest together in a prime-numbered group standing atop a golden cloud, waving banners, playing musical instruments, and writing in their books and scrolls. 

HD: 10 AC: 3 Move: 180’ Morale: 8 Attack: Pearlescent bow +1 (1d6) x 4

Non-lawful creatures struck by a principality's arrow must save vs. spells or their alignment becomes lawful for the next hour. This effect doesn’t work on demons, undead, or unaligned creatures. 

A group of principalities always acts as one creature. If a third of their HP is depleted, they get three attacks per round. When two thirds of their HP is lost, the number of attacks drops to two. Principalities make a morale check each time they lose a third of their ranks. In place of an attack, a principality can do one of the following:

  • Horn. Calls forth a random angel of type I-IV (roll for type) (50% chance of success). This can be done twice per day. 

  • Drum. The next attack against the principality is automatically deflected. Magic missiles and area-of-effect spells are unaffected.

  • Harp. The principality heals 1d8 hp. It cannot be brought above the nearest 1/3rd hp threshold. 

  • Scroll. The principality reads a holy commandment from a scroll. Target lawful creature within earshot must save vs. wands or obey the command. Principalities issue simple, direct commands and never command the target to harm themselves. Typically, the target is commanded to subdue their allies and prevent them from fighting further.

  • Book. The principality drafts an esoteric record in their tome. Target creature must save vs. wands or is unable to repeat the same action for the next 1d4 rounds. 

Type V: Galgalim

Galgalim are the Cthulhoid “biblically accurate” angels that everyone gets so hyped about. Burning wheels within wheels, countless wobbling eyes, wings that unfold in Escher-like patterns. The turning of their wheels and the chanting of their many mouths causes the ascended principle of cosmic Law to emanate throughout the universe. They bare a terrible significance in the workings of the planar cosmos, and their duties are so utterly incomprehensible to mortal minds they can only be approximated through direct revelation. Still, they are recognized and revered by the earthly forces of Law, and are honored as patrons to many churches and institutions. Whole libraries can be filled with the countless musty tomes of dense scripture devoted to recording and explaining the importance of their deeds, all of which are written in intricate word squares and ideograms that are characteristic of the weirder Lawful doctrinal texts. Galgalim serve as the symbolic counterpart to the ancient chaos demons that turn mortal men insane merely by being made aware of their existence. 


HD: 12 AC: 0 Move: 300’ (teleport) Morale: 10 Attack: 1d10 x 3 (in a manner that is most thematically appropriate, i.e. laser beams, columns of flame, locust plagues, etc.) 

A galgal can call forth another angel of types I-IV twice per day. Once per day, it can cure any disease, neutralize any poison, remove any curse, restore a lost or crippled limb, or reverse any mutation or similar affliction. It can issue Quests (as per the spell) as many times as it wishes, with unwilling lawful creatures saving at a -4 penalty. The quests they give are arduous and require great sacrifice, such as destroying the hand of Vecna by affixing it to your arm and then dousing it in the stygian river of the Underworld. 

Example Galgalim

  1. Omael, The Revealer of the Mystic Secret

  2. Nithael, The Keeper of the 12 keys

  3. Urzophon, The Throne of Prophecy

  4. Lecabel, The Herald of the Truth

  5. Iezalel, The Engraver of the Flame

  6. Loviah, Who Waits upon the Rock

  7. Achaiah, The Singer of the Song of Songs

  8. Elemiah, The Speaking Gate

Type VI: Hayyoth

Big, monstrous angelic kaiju. They are only sent to earth to usher in the end of one age and the beginning of a new one. Usually, if you see one it means that something has gone very, very wrong. 

A hayyoth can only manifest in the prime material plane in an undeveloped fetal form. The longer it spends in the prime material, the stronger it grows. Its power grows fourfold over the first 44 days, and then another fourfol after the subsequent 44 weeks. This continues after 44 months, 44 years, 444 years, 4444 years, and so on. 

If a hayyoth were to be sent to the world to enact an end-times scenario on only a specific part of the world, it would first rest in orbit for about half a decade (the ore it need destroy, the longer it rests; 44 weeks for a city, 44 years for most of the world, 444 years or longer for greater cosmic threats). Once 44 months, 44 weeks, and 44 days have passed, it will awaken at once (resting no longer than it needs to), shake the crystal concretions from its exoskeleton, and then thrust itself toward the earth. The impact alone would be big enough to impact the global climate for years to come. But before anyone has time to worry about that, it begins its rampage. 

There is a single Hayyoth that exists on earth. It was, presumably, the last one to come here, but for whatever reason it never returned to the Empyrean. It lies in the north pole, completely submerged under the ice. It is uncertain whether it is dead or just lying dormant. 

HD: 1 (fetal form)/4/16/64/etc. AC: -2 Move: 150’ Attack: talons (3d10) x 4 and lightning (8d8) or Light of Judgement.

Lightning: bolts of energy constantly stream from the hayyoth’s body and rain down on the surrounding landscape. Each dice of damage for lightning can be applied to any target within 500’ before being rolled. No more than three dice can be applied to the same target. The target gets a save vs. breath for half damage.

Light of Judgement: The hayyoth spends a round focusing its energy, and then the next round releases it in a single, massive beam attack. Deals damage equal to its current HP (save vs. breath for half) in a line 10’ wide and one mile long. The hayyoth must then spend a round resting. Can be used once per hour. 

Regeneration: The hayyoth regenerates 1d6 HP each round as long as it has an unobstructed view of the heavens. 

Death: upon reaching 0 hp, the Hayyoth explodes into a massive pillar of energy that extends to the sky and obliterates everything within a half-mile radius. It leaves nothing behind save for 1d10 of its diamond eyes in smoldering impact craters. Each is the size of a boulder and worth 1d10x10,000 sp.

After a hayyoth touches down on earth and begins its rampage, a Biblical plague forewarns its coming in the surrounding regions. For a week or so leading up to its arrival, the local area will experience some end-of-days style catastrophes. You can borrow a plague straight from the good book, but here are some other ideas for Old Testament–style precipitation:

  • Gore

  • Skulls

  • Dust

  • Serpents

  • Bile

  • Daggers 

Type VII: Archangels

Chief among the angels, rulers of the Empyrean, and speakers of the Law. Archangels, along with significant martyrs, saints, and prophets, can be considered minor deities in their own right. Archangels command the armies of Law in the eternal war against Chaos, though they are rarely at the forefront of the campaign. It is by the will of the archangels that the Empyrean exists, and if they were to be slain all angelkind and the souls of lawful creatures would be cast across the cosmos. It is only at the end of days, when the war has reached its culmination and the forces of Law and Chaos are gathered for the final battle, will the archangels rise from their thrones, raise their swords, and lead the remaining angels in the last cosmic conflict. So it is ordained. 

Stat archangels however you would a lesser deity or godling. If you’re of the sort that feels like gods should transcend the need for stats, so be it. Otherwise, you can lift something cool from Deities and Demigods and call it a day. 

Saturday, July 31, 2021

Powerblogging through my disparate thoughts on an alignment-focused campaign

Two of the six players in my game quit their jobs and have embarked on a cross-country road trip with their girlfriends having what I hope is the time of their lives, flying rugged and free through the veins of America. Another player just moved and is stoically attempting to return his life to a comfortable equilibrium. A fourth is also unemployed and devoting the brunt of his time + spiritual/mental energies toward a creative endeavor while also, somehow, looking for a job. All of this is to say: the Last Planet campaign, which I have written briefly about before, is on hold. That’s fine. These things happen. Since we’re all friends, we’ll inevitably start playing D&D again eventually. 

But now that the campaign is on hold, my creative drive is left to drift and wander on its own without a weekly game around to orient it. I’m sure plenty of other people have experienced this—when not preparing for and running a regular campaign, all those old unused ideas start to come out and roam around your mental landscape, while simultaneously your significantly more receptive to any new idea you come across because you don’t need to expend the mental energy thinking about how you can implement it into your game.

What this means for me is that the kernel of a new campaign is beginning to form in my mind. I’ve had a bunch of different ideas and things I wanted to try that I haven’t been able to yet. And now I’ve reached the point where I might actually have something here, and it’s time to set the ideas down on the page. 

Ahn Doo Jin

The campaign is based around the premise that alignment is the most important factor in the game.

What would this look like? Well, I could see this as meaning that religion would have to be a pretty big deal. The way alignment makes the most amount of sense in my head is as some sort of large cosmic-scale conflict between law and chaos, which manifests itself in the material plane spiritually just as much as physically. 

Societies would be much more oriented toward their specific alignments, though not in the Law=authoritarian, Chaos=libertarian sort of way. In the original framework for alignment presented by Poul Anderson in Three Hearts and Three Lions, the Nazis were said to be agents of Chaos. This would suggest that chaotic societies are organized around strength and power, but that could also include like insular group power, so that anarchistic communes would also be chaotic. Whereas lawful societies would be more diffusely organized around monarchy, aristocracy, bureaucracy, (democracy?), and both would also have a strong religious authority, for reasons stated above. 

I have a lot of thoughts about alignment. I think that the classic Law/Neutrality/Chaos scheme is more interesting than the nine-point AD&D version because in my mind Law and Chaos are more interesting concepts to throw cosmology at than good and evil. Once Good and Evil are introduced into the alignment scale, they sort of take precedence over law and chaos because they’re easier concepts to grasp onto, and most characters end up being some flavor of good or neutral unless they want to be edgy and contrarian. But good and evil have been done to death already, and planning a setting where good and evil are axiomatic truths where some people (or species, actions, etc.) are inherently good while others are inherently evil is a whole can of worms I don’t care to get into.  

That doesn’t mean I don’t think good and evil should not exist in the setting, only that they ought to exist like they do in the real world, where good and evil are mostly just descriptive terms that are shorthand for much more complicated and nuanced behaviors. No evil person considers themselves as such, only that other people are evil. 

I’m also really not interested in the sort of both-sides-kind-of-suck Moorcockian view of Law/Chaos, since it leads to the lame kind of “moral grayness” where players have to choose between two equally bad outcomes or, if available, go for the third-way balance/neutrality/moderation option that is clearly better than the other two. 

The best way I can think of to thread this needle between 1) Law and Chaos being more than stand-ins for good and evil while also 2) not being essentially equivalent to one another is to have alignment represent beliefs and values, like opposing religions or governing principles. Sort of like how Gygax originally intended it. 

My vision for the campaign is for it to adhere sort of close to the original concept of D&D’s classic implied setting, since I’ve been doing pretty much the opposite of that for quite some time. It’s going to be a points-of-light sort of deal, where human civilization is mostly oriented toward law but actual settlements are few and far between and the wilderness is chaotic (though not completely Chaotic) and dangerous. While civilization itself is lawful, humans are just as predisposed to law as they are to chaos, which means that some human settlements will also be chaotic. Monsters, too, would be primarily chaotic, but not inherently; they might just be more predisposed to catching the chaotic wavelengths that flow through the universe. 

That gives us Law as the side of humans and human societies, barring a few exceptions, and chaos is the side of monsters and humanoids, once again barring a few exceptions, and the wilderness as a sort of neutral but dangerous middle ground. This is good—I want elementals and nature spirits and stuff to be neutral. Demihumans are also neutral, as they are uninvolved in the cosmic conflict between Law and Chaos, but they can take sides if they like. 

So so far Law and Chaos represent differing governing ideologies that aren’t really that different in the first place, they’re both expansionist and also spiritually opposed to one another. It’s more of just a justification for me to allow for orcs to be antagonistic to players without being inherently evil or neutral enough to be like “haha gotcha, bet you feel like an asshole now” when it is revealed that they’re just trying to live their lives when the PCs came along and killed them. Sometimes It’s good to have the players feel justified in their actions.

Why are lawful and chaotic people/societies opposed to one another? The cosmic conflict. The “point” of the campaign is that Law and Chaos are vast, opposing forces and our planet is just a little proxy war in the midst of a much larger struggle.

Making this all manifest in the game would actually be pretty easy: everyone the players come across would have their goals and motives oriented toward their alignment. Circumstances players confront would be contingent on what they have written down on the alignment slot on their character sheet. Gods and demons would be prominent forces in the campaign world. Otherwise, it will still be D&D as normal.

Following the very useful and not-at-all ill-considered advice in the F*fth Edition DMG, I made a whole cosmology for the campaign before doing anything else. Why? That’s a good question. Anyway, it’s based around gnosticism and Qabalah and the Blakean mythopoeia and other high-minded and pretentious things I’ll get into in a later blog post.

Monday, July 19, 2021

Goblin Kings

"In the goblin lair lives a goblin king," reads the goblin entry in the Moldvay monster section. I like the phrase; it's got a pleasant meter to it that lends some appropriate fairy-tale whimsy.

Goblin kings are, per the rules, 3 HD creatures (with 15 hp) that get a +1 damage bonus and a 2d6 squad of 2 HD goblin bodyguards. Tolkien already did the generic "goblin, but bigger" goblin king in the distant 1900s, which was charming at the time but passé in the current era. It has been done before; we should be emboldened to leave that sinkhole of creativity and journey forth into realms of stranger possibility. Here are some alternative "kings:" 

  1. A huge, tumorous maggot. The goblins prevented it from pupating, and instead feed it non-stop in long ant-like assembly line so that it just grows, and grows, and grows.
  2. A David-Bowie-looking elf with a magic crystal ball. He likes mischief and singing songs about being mean (or something, I don’t know, I've never seen the movie).
  3. An unsettling avian puppet effigy. Made of wood, feathers, and guano. It's piloted like a mech by a team of goblins, who inexplicably work in such perfect sync that the effigy seems alive. If any of the pilots die, other goblins will hurriedly climb into the wood frame skeleton and take their place. 
  4. A giant goblin toddler, about the size of a full-grown cow. It’s all the goblins can do to keep him fed and entertained, for they fear nothing more than his tantrums.
  5. An ancient corpse desiccated beyond recognition. Its limbs are long and bone-thin, and its face is just blue-black skin stretched over an eyeless skull. It’s shamanic bodyguards claim to be the interpreters of its strange decrees, which are delivered in the low groans that occasionally escape its mouth.
  6. A captured, half-crazed adventurer. One night he was just getting settled into his bedroll, but the next thing he knows he’s chained to the throne somewhere deep in the goblin warrens. The goblins worship yet always humorously misinterpret his commands. Many failed escape attempts have left him frazzled and desperate.
  7. A tall, beautiful, exquisitely muscled paragon of goblinhood. Unfortunately, not much more intelligent than a typical goblin.
  8. A haggard wizard who fancied at one time that he should vat-grow his own horde of goblins. He realized only too late, of course, that goblins are much more trouble than they’re worth, but he just can't seem to get rid of them. Spells known: Charm person (goblin), Ventriloquism, Mirror Image.
  9. A grim, sinister warrior covered in terrifying armor. He calls himself “The Overlord.” He's got all the trappings of your generic grimdork villain: glowing eyes, booming voice, preternatural hatred of insolence. The goblins are scared out of their mind by him but he’s no tougher than a 3HD fighter.
  10. Looks like a goblin, sounds like a goblin, acts like a goblin, but... it’s definitely not a goblin. Whatever it is, it looks to be wearing an ill-fitting goblin suit: The skin sits too slack in some areas and too tight in others, weird bits of hair peek out from frayed seams, and the face doesn’t move as much as it should when it speaks. Very conspicuous to anyone who sees it, but the goblins have no idea it isn’t one of them.

Tuesday, May 25, 2021

Stock Thousands of Unique* Hexes Instantly** With Google Sheets

If you’re experienced with Excel or Google Sheets, this will be painfully obviously endearingly quaint. If you aren’t, you’re in luck, for I have delved the hoary depths of the Google search function and consorted with the occulted knowledge of YouTube tutorial makers to gain the understanding necessary to formulate this rather simple and straightforward method of stocking hexes. All so you don’t have to. 

Humble preamble: This method isn’t meant to replace the more considered planning and preparation that goes into creating a hexcrawl campaign. It’s just meant to make the whole endeavor a little easier. 

The method involves coming up with a list of items you want to stock your hexes with (settlements, lairs, all that good stuff) and then randomly assigning them to the hexes. It’s the same principle as rolling on a random table for each hex, but the benefit of using a cold soulless machine over the tactile analog pleasure of dice and paper is that you can play around with a much bigger list of items and the whole process goes a lot faster. Score one for the robot uprising. 

Step one: open a fresh Google Sheet. This might work on Excel but I don’t know; I can’t try it because the Office plan I didn’t know I had has expired and now I have this shitty little icon sitting on my computer that I keep forgetting to get rid of. Anyway, in Column A write out your list of hex numbers. If you separate hex rows and columns with a period, adjust the decimal place one to the left or else every hex column that ends with zero will be cut off. Frustrating, but we persist.

I forgot to move the decimal place over in my example images. C'est la vie.

Step two: In column E, make a big list of all the things you want on your hex map. Don't be too specific—this is the random table that the formula is going to be rolling on, so you should account for the possibility that each result could appear many times. That being said, I find it helpful to include multiple versions of the same thing to get one level of detail deeper. This also helps for weighting the table, which I will get into more later. 

So for instance, instead of just having "ruins" four times on the list, I included four different types of ruins: Lizardman, Giant, Cyclopean, and Weird (the useful catch-all for any type of ruin I want to include that isn’t covered by the other categories).

Do this with fortresses, settlements, castles, temples, towers, dungeons, monster lairs, and/or whatever else you want your players to come across over the course of their wondrous adventures. Add in the basic stuff, add in setting-specific stuff, maybe even add in things you don’t have a clear idea of yet and so you can come up with the details later. Consider including placeholder entries like "Special" so you can add in more elaborate and boutique stuff later, if that suits your fancy. 

All told, I ended up making 60 different hex items. In order for the below formula to work, you will need 60 items as well.

Step three: Click on the first cell in column B, and then paste this into the formula bar (next to the fx symbol):


Edit: try =INDEX($E$1:$E$120;RANDBETWEEN(1;120)) if the above formula doesn't work


(If you're not using 60 items, your numbers may need to change)

After that, select the cell, click on the little blue box in the bottom right corner, and drag it down to fill in the rest of the cells in column B.

INDEX returns the contents of other cells, and RANDBETWEEN chooses a random number between two parameters. In this case, the formula is choosing a random cell in column E between 1 and 120 and displaying the result in the cells of column B. 

Make sure you include the dollar signs or else the function scale will shift up one with every cell, meaning it would go from E1:E120 to E2:E121 and so on. Obviously since you’re copy/pasting this isn’t a concern but this took me way too long to figure out and I want to put it here to make sure NO ONE gets confused by this EVER AGAIN. 

Notice the range goes to 120 when I only have 60 hex items. I want some hexes to be empty, so that the map isn’t too cluttered and so I can fill in more stuff later if need be. A matter of personal preference.

Because of the inscrutable workings of Google Sheets every time you update the spreadsheet, all the cells produced by the formula will change. There's probably some way to prevent this but what I do is just copy all the cells and then in a new sheet go Paste special -> Paste values only.

Repeat step three in column C if you want the option for more items per hex, which you should, because one thing per hex can get BORING. 

Play around with the numbers and proportions. If you want a sparser, more terra incognita hexcrawl, expand the function ranges to make more empty hexes and have a low number of settlements compared to everything else.  

Don’t take weighing the table too seriously, unless you’re really into ensuring there is a realistic proportion of castles to settlements or whatever. If you have way more ideas for temples than you do fortresses but you want roughly the same number to be on the map, just condense multiple ideas into the same cell. 

This tool is just a jumping off point—play around with it until it spits out something you can work with and then go from there. 

Next steps: Adjust, reflavor, and season to taste. 

Look at your hex map and your list of semistocked hexes. Get a feel for the ecosystem, what the dialogue between the points of interest and the natural geography may be. Why might things be located where they are. 

Take Hex 25.19 in the example image. Within it is both a wizard's tower and a mutant's lair. Perhaps the mutant was the victim of the wizard's foul experimenting, but he escaped the tower and now plots his revenge. Or maybe the wizard and the mutant our allies, and the mutant has agreed to defend the wizard's tower in exchange for magical boons.  

This is where you do that DM thing where you iterate on idea fragments until they are fleshed out to your liking. Knowing just the content of a hex, its terrain type, and the nearby locations should develop in you a strong enough creative foundation that can you expand on easily, or even spontaneously at the table if need be. 

The same principle of dungeon stocking applies to working out your hex map: you’re obviously allowed to change results if you feel like it would make a better campaign, but also let the weird idiosyncrasies fuel your imagination. Why are there five castles in this tiny stretch of jungle? What the hell is a haunted mansion doing in the middle of a desert? You tell me. Figuring this stuff out and coming upon these “discoveries” is one of the real joys of being a DM, I-M-O.

And that’s just about all there is to it. 

*some work will be required to distinguish hexes stocked with the same contents

**"instantly" does not include the time it takes to set up the material required for the method to function.