Items of Power - Volume Three

The latest product in PBE Games' Items of Power series is now available. The third volume contains seven new magic items: the Vermin Blade, Steadyhand Ring, Lifehammer, Robe of Elements, Sword of Bees, Magician's Elixir, and the Skull of the Dead.

• Check it out right here

Random Tables II - More Excel

A few days back I posted an ultra-simple example of a random table in Excel. Since I'm making a few tables for another project, I thought I'd do a slightly more complex (and useful) example, and explain how it works. Here's the basic table, which uses a percentile dice roll and has variable ranges for each table entry.

Wilds - Click Your Heels Together Three Times

After debating the wisdom of exploration versus continuing to try combinations in hopes of getting home, the party elects to do a quick scout of the immediate area, keeping the spire in sight. Leaving the hirelings inside with the beasts, Ohwatoo, Dagmarten, and Locky do a quick survey of the immediate area around the tower, while Raúguey, Ingvild, and Durego investigate the various piles of stone they can reach. Rawon, Mordikarr, and Maro spread out a bit and scout out a few hundred yards into the woods.

Random Tables - An Excel Quickie

Someone over on G+ was asking about tools to make random tables for RPGs. I mentioned Excel and the poster said they weren't very good at using the spreadsheet. Since quick and dirty tables are pretty easy with Excel, I thought I'd throw together a quick example, so... here:

This is a very simple table with six entries (A2-A7). A1 is a formula which randomly selects an entry from the table using the INDEX and RANDBETWEEN functions. A8 is a text copy of the function used. Each time you hit the F9 key, RANDBETWEEN recalculates its value, and uses it as an index into the table. Here's what the INDEX function means:

• A2:A7 is the array to work on (that's six rows by one column).
• RANDBETWEEN(1,6) chooses a row value between 1 and 6, inclusive.
• The final 1 parameter chooses the first column.

Points to note:

• The INDEX function takes an array, a row, and a column as parameters. You can get fancier and use RANDBETWEEN for both row and column to create a two-dimensional table.
• The RANDBETWEEN function picks a number from the integer values between and including the given low and high.
• The row and column values in INDEX are values within the given array (A2:A7). The first row/column is always one, and the highest value is equal to the number of rows/columns in the array. Don't use spreadsheet row/column values!
• Using an array reference inline like that leads to unreadable spreadsheets. If we were doing a more complex example, we'd apply a name to the data range, and use that instead.
• What works in Excel generally works in Open Office or Google Drive documents. For example you can see the Drive version right here.

OK, that's it, quick and dirty. There's more complex stuff in this post right here though.

All Over the World...

Last turn the party decided to try and use the pedestal they found in the center of the spire chamber. The discovered the entire contents of the chamber, including themselves of course, had been moved to a different location. Let's see what happens next.

Wilds - The Spire

A few turns have passed in my Labyrinth Lord, Wilds game, and action has been a bit slow, with various real-life vacations slowing the pace a bit. here's a summary of action to date.

PBE Games - Q2 2013

I just realized that I'd carefully extracted last quarter's sales numbers so I could write up a quick report on progress, but I never actually did that. Here's the data (click for larger image):

Q2 2013 Sales

A couple observations based on the above:

• Deadly Blows picked up some sales when Johnn Four at Roleplaying Tips mentioned it in one of his newsletters. So far it's in the lead for best-selling paid product. Note that Deadly Blows is on sale for the duration of the Christmas in July sale on DriveThruRPG.
• Dungeons in Blue - The Master List shows that pretty much everyone will snatch up free products. It 'sold' 283 copies.
• Tome of Names stuff has all come out between 10 and 15 copies sold each, so there seems to be a small but steady demand there.
• Virtual Tabletop maps don't sell much, which is not surprising. They're fun for me though, so I don't mind if they don't make me rich. These products are also included in Christmas in July.

And since you've read this far, let me mention the latest product from PBE Games: Items of Power - Volume One. Each product in this series contains seven unique magic items ready to plug and play in any OSR-style campaign. You can take advantage of this special offer link to receive a 25% discount on Items of Power - Volume One.

Thanks for reading, have a great weekend!