Category Archives: Spreadsheet

Tuesday Toot!! | Can’t Remember the Name But the Fangs look Familiar

Tuesday TootG+ is closing closed. When it was alive things happened. Things unexpected. Great things. Whilst my creative output is only modest, I thought I’d hold something up into the living light, something that came about purely because G+ existed … This is a toot to G+.

Background:
This is a video demo of a monster spotting (recognising) widget:


The idea is that maybe a PC knows something about the monster they have just encountered. This information might be useful. The idea is to give PCs like a low level magicuser something useful to do.

This Widget was put up on G+ and automates the process I submitted to ‘& Magazine’.

Screen capture:

CRTNBTFLF

& Magazine
This widget is based on ‘& magazine’ issued 12; pages 35-39;  “Can’t remember the name, but the fangs look familiar”. Link: http://www.and-mag.com/wp-content/uploads/2015/09/and-mag-i12.pdf

Widget
The Excel widget can be found here: xls Download

FYI – Table of the mistakenly known things:
For the hell of it, below is the full list of mistakenly known things:

1 has acid attack
2 is an stral creature
3 blood cures wounds
4 body parts are useful (e.g. make armour or weapon)
5 breaths water
6 cannot cross a chalk circle
7 cannot cross running water
8 cannot lie
9 causes rotting flesh
10 charms at will
11 climbs walls
12 has cold attack
13 is controlled by speaking its true name
14 can curse
15 is delicious to eat
16 can dodge missile weapons
17 drinks blood
18 eats brains
19 has ESP
20 is an ethereal creature
21 explodes if killed
22 fears its own reflection
23 has a fire attack
24 can grant wishes
25 has been cursed
26 has no reflection
27 has weak spot (e.g. Soft underbelly)
28 hates holy symbols/can be turned
29 hides in shadows
30 can drain HPs
31 is hurt by acid
32 is hurt by blunt weapons
33 is hurt by cold
34 is hurt by fire
35 is hurt by holy water
36 is hurt by light
37 is hurt by lightning
38 is hurt by silver
39 is hurt by water
40 is immune to acid
41 is immune to charm type spells
42 is immune to fire
43 is immune to good-based magic
44 is immune to lightening
45 is immune to magic
46 is immune to magic weapons
47 is immune to missile weapons
48 is immune to non-magic weapons
49 is immune to cold
50 is immune to evil-based magic
51 is immune to holding type spells
52 is immune to wands
53 has infravision
54 is a prankster
55 brings bad luck is killed
56 has level draining
57 can levitate
58 has lightning attack
59 likes alcohol
60 likes to play riddles
61 loves gems
62 loves gold
63 is a lycanthrope
64 is magic casting
65 has magic resistance
66 is a master pickpocket/thief
67 is a messenger of a god
68 can mimic voices
69 is a mind reader
70 must give safe passage if asked
71 is only hit by magic weapons
72 is only hit by strong magic weapons
73 is never asleep
74 is never surprised
75 is not harmed by bladed weapons
76 is not harmed by blunt weapons
77 can only be finally kill with a Wish
78 can only attack if attacked
79 is only hurt in the ethereal/astral plane
80 can only see moving objects
81 has a petrification attack
82 is poisonous
83 is prone to bickering
84 is psionic
85 can regenerate HPs
86 has a secret attack
87 can sense an enemy
88 can shape shift
89 shuns light
90 can spot illusions
91 has telekinesis
92 can teleport
93 has troll-like regeneration
94 has ultra vision
95 is undead
96 has parts useful as spell components
97 has very good hearing
98 has a very good sense of smell
99 is very vulnerable to magic
100 has weak limb joints

– – –

InHotS the cover imageMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural High Seas ‘Hex Crawl’ – In the Heart of the Sea.

 

Simple Excel Mapper update | Icons added

Tuesday TootG+ is closing closed. When it was alive things happened. Things unexpected. Great things. Whilst my creative output is only modest, I thought I’d hold something up into the living light, something that came about purely because G+ existed … This is a toot to G+.Simple dungeon mapper

This is a throwback and an update. This is a simple mapper I made using Excel and its ‘conditional formatting’ option. It’s basic but free.

I’ve updated this mapper to include a few icons. It’s a thing I’ve been meaning to do for a while.

Original Video Demo

This video keeps chugging on YouTube, it consistently gets 10 to 20 hits a day.

Update: Icons added

Basically, any image can be placed on the map, so I incorporated some CC ones, made them small to use as icons:

icons 2      icons 1

These icons allow a greater deal of customisation. Feel free to use your own.

Download:

xls XLS Mapper

Screen Capture:

Mapper 101

– – –

InHotS the cover imageMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural High Seas ‘Hex Crawl’ – In the Heart of the Sea.

 

 

Isometric map template in Excel

Using Excel to make an isometric map template.

Demo Video:
This pretty much says all you need to know:

Screen Capture:

CS Isometric paper in Exel.png

Template:
You can download the xls Excel Template here.

Another kind of 3D looking map in Excel:
In a previous blog post I showed how to makes 3D looking maps like this, and which is powered by a handy macro:

Google Sheets:
I think this should work in Google Sheets, and when I get a moment, I’ll make a template.

– – –

InHotS the cover imageMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural High Seas ‘Hex Crawl’ – In the Heart of the Sea.

 

 

Tomb of the Serpent Kings | Spreadsheet Adventure Module Adaptation

I’ve made a Spreadsheet Adventure Module (SAM) of Skerples and company’s great learning/beginner adventure: Tomb of the Serpent Kings (xls  download)

Video demo:

Screenshot:TotSK screen capture.png

Original work: Written by SKERPLES (coinsandscrolls.blogspot.com); Art by SCRAP PRINCESS (monstermanualsewnfrompants.blogspot.com); Map by JANON; Layout by DAVID SHUGARS (the3d6.com)

Skerples et al’s original work (shared under a Creative Commons license) can be found here: Link

Description:  People keep asking for “beginner” dungeons. Everyone can name “classic” dungeons – Tomb of Horrors, Barrier Peaks, The Temple of Elemental Evil, etc. – but in order for those adventures to make sense, there needs to be some sort of introduction.

It’s like all the adventures we have are Bach concertos. People keep writing amazing works of staggering genius, but someone needs to write a book on how to play the piano.  I had the same questions, and since I couldn’t find anything satisfactory, I decided to write the kind of dungeon I would have loved to find. I wanted to write the best basic old-school dungeon for new players that I could, and I also wanted to show the design process. And since people keep refereng to it, I figured I’d put up a fancy print version.

Tomb of the Serpent Kings is designed to be easy to adapt to your system of choice to create an old-school dungeon-crawling tomb-robbing experience.

Spreadsheet Adventure Modules (SAMs)

If you don’t know what SAMs are about – then please see the video which explains the ‘Big Idea‘ behind using Excel to present module information in a super compact fashion. There is also a 5 minute How-to-Guide video which shows you all you need to know to get started.

More SAMS

For more SAMs here: Link

– – –

InHotS the cover imageMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural High Seas ‘Hex Crawl’ – In the Heart of the Sea.

 

Tuesday Toot!! | Cave System Map Generator in Excel

Tuesday TootG+ is closing closed. When it was alive things happened. Things unexpected. Great things. Whilst my creative output is only modest, I thought I’d hold something up into the living light, something that came about purely because G+ existed … This is a toot to G+.

Background:

One level

Random cave system

I toyed with this idea but never really finished/refined it. This Excel cave system generator basically uses the bones of my random hex wilderness generator engine to make a randomly generated cave system. Like its parent file, there are some global and regional controls to vary the outcome of the cave system. But, overall, as a proof of concept, I simply tweaked a few settings to see if it could be done. I did consider stacking layers of these and interconnecting them to make a wider cave system, but …

I suppose if there is any kind of demand for a finished/refined version of this, I guess I could figure out where I was up to and finish/upgrade it. Let me know?! That said, if all you want is to generate a simple random cave system on a broadly hexagonal-like layout, it does work.

Three depths

Colours indicate depth

I also made a multi-coloured version of the cave generator. The colours are intended to represent different depths, eventually leading down to water.

These cave generators could be used to make an individual cave system, or to make a ‘global’ map for a wider ‘Underdark’ domain, i.e. ‘Veins of the Earth’ style.

If you want to mess around with the ‘work not currently in progress‘ Excel file, it can be downloaded here:  Link

 

Veins of the Earth Cave Generator 101Some ‘Veins of the Earth’ based Excel widgets (actually finished) can also be found here: Blog link

 

– – –

InHotS the cover imageMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural High Seas ‘Hex Crawl’ – In the Heart of the Sea.

Tuesday Toot!! | VotE Cave Generator

Tuesday TootG+ is closing. When it was alive things happened. Things unexpected. Great things. Whilst my creative output is only modest, I thought I’d hold something up into the living light, something that came about purely because G+ existed … This is a toot to G+.

Over the last two or so years, I’ve discovered how versatile Microsoft Excel can be at making game content. Here is an Excel widget I made and posted on G+. The widget is a Cave Generator for Patrick’s Stuart’s Veins of the Earth:

Veins of the Earth Cave Generator 101
xls Download  YT To do

You can run this as a standalone Cave Generator, or it can be used to check you are using Patrick’s dice method ‘correctly’ before game night!

Related, and if of interest, here’s an Excel adaptation of Skerples. ‘Veins Crawl’ (for Vein’s of the Earth), which is presented as a single sheet in Excel:

Veins Crawl 101      Veins Crawl 102
xls Download  YT Demo Video

:: Some other interesting RPG things Excel can do ::
Excel can be used to present module information in super compact fashion (How-to-Guide); used as a simple dungeon mapping program (Video Demo); and to make a surprisingly flexible Hex crawler (Video Demo). 

:: Google Sheets ::
Sadly, Google Sheets does not have the same level of functionality as Excel (I wish it did). 

– – –

c AntMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural adventure ‘Carapace‘ about a giant ant colony.

James V West Gexit
“Once more unto the breach, dear friends, once more”
Fight on dear Gexit
(drawing by James V West

The Sky-Blind Spire | Spreadsheet Adventure Module Adaptation

I’ve made a Spreadsheet Adventure Module (SAM) of Michael Prescott’s great little problem solving adventure: The Sky-Blind Spirexls  download YT Demo

Screen shots of the SAM:

:: Credits page: sbs 1

:: Screenshot 1sbs 2 pop

:: Screenshot 2 sbs 3 pop

Original work by Michael Prescott

Michael’s original work (shared under a Creative Commons license) can be found here: Link

Description: Titardinal’s Spire is an ordinary-seeming stone tower at the edge of a large, live-giving lake. Few borderlands towers are so well placed, and it has changed hands many times. Unfortunately, Titardinal wove magic into every brick of his tower, making it a difficult place to hold onto for long. But the wizard’s loftiest ambition was never achieved—perhaps you will claim it!

Michael’s Patron is here: Link

Spreadsheet Adventure Modules (SAMs)

If you don’t know what SAMs are about – then please see the video which explains the ‘Big Idea‘ behind using Excel to present module information in a super compact fashion. There is also a 5 minute How-to-Guide video which shows you all you need to know to get started.

More SAMS

For more SAMs here: Link

– – –

c AntMe on DriveThruDriveThru; at the moment I’m mainly pimping my procedural adventure ‘Carapace‘ about a giant ant colony.