Name splitter spreadsheet

OldeMusicke

For creating name generator tables, I use an Excel spreadsheet that takes a list of sample names and splits each name into two parts, roughly in the middle. To improve the chances for a pronounceable result, it has the first part end on a vowel and the second part start with a consonant. If it doesn't find a good place to split the name (such as Mia below), it uses \z as the second part (null output in IPP).

Example: If I enter the names Tasha, Otto, Mia, Tenser, Nystul, Bigby, Otiluke, Leomund, Evard, and Rary, it gives me:

Table: Prefix
Ta
O
Mia
Te
Ny
Bi
Oti
Leo
Eva
Ra

Table: Suffix
sha
tto
\z
nser
stul
gby
luke
mund
rd
ry

When you use [@Prefix][@Suffix] to generate a name, it could give you names like these: Tamund, Nyry, Evasha, Ogby, Raluke. In effect, I've used 10 names to create 100 possible names.

It's currently set up to take 1500+ names. If your sample name list is even longer, I suspect you don't really need this name splitter.

I don't mind sharing the spreadsheet here if there's interest. Is that something for the NBOS Online Exchange, or would Excel spreadsheets not be allowed there?

jdale

I do something similar except I split into three parts. The first part includes the first vowel and the consonant immediately after it. The last part includes the last consonant and the vowel before it. And the middle is the rest. I wrote a VB.net app for it. It also downloads the names from a specified URL on behindthenames in order to split them.

Ed_NBOS

I added .xls and .xlsx as allowed extensions for uploads. Let me know if you need any other format.

Ed_NBOS

I made a program years ago that took sample text and split words up into syllables, recording the combination frequency. Thats what I used for some of the name generators in IPP and those used by Astro.