A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Male Name | Female Name | Type in this column to randomize new name | How to Use | Click arrow up here | |||
2 | Dukdukkir | Koana | Find where it says "File" and then go to "Make a copy" | Do not edit K2 to Z3 unless you are adding or deleting syllables to a name | ||||
3 | I reccomed you do that first step becuase it's easier, but you can also just keep refreshing the page if you'd prefer | |||||||
4 | If you followed the first step and want to randomize new names, either type or delete in column D | If you are adding more syllables to a name, first look at the numbers in column J | ||||||
5 | To edit names scroll to the right | Find where it says "=RANDBETWEEN(2,3)" and edit the numbers where (2,3) is | ||||||
6 | This will be the amount of syllables that show up | |||||||
7 | If you are adding more thatn 3 syllalbes, you will need more syllables | |||||||
8 | To do this, click on either L2 or L3 depending on if you're editing male or female names | |||||||
9 | Find where it says something like this "=INDEX(K5:K11,RANDBETWEEN(1,COUNTA(K5:K11)),1)" | |||||||
10 | Copy that and paste it into the next column (ex. N is the next column) | |||||||
11 | Then go to the displayed name on the left | |||||||
12 | Change the text to "=if(J2=2,K2&L2,IF(J2=3,K2&L2&M2,K2&L2&M2&N2))" for male, and change all the 2s to 3s for females | |||||||
13 | Note: if you have more than 4 syllables, continue the pattern | |||||||
14 | Ex. for 5 syllables change "K2&L2&M2&N2" to "IF(J2=4,K2&L2&M2,K2&L2&M2&N2&O2)" | |||||||
15 | ||||||||
16 | To add more syllables, types in the syllable columns | |||||||
17 | Remember to include them in both if you want that syllable to occur both in the beginning and the middle | |||||||
18 | Then go to the display name rows, and find something like this "=INDEX(J5:J11,RANDBETWEEN(1,COUNTA(J5:J11)),1)" | |||||||
19 | Change where it says J11 or something similar to J (or whatever column you are in) # of rows you went to | |||||||
20 | Ex. adding a syllable to the male columns would mean I would change the J11 to J12 and the K11 to K12 | |||||||
21 | ||||||||
22 | For any questions or more complex name generators, contact me on Stray Fawn Studio @Pokestardragacraft | |||||||
23 | I'd be happy to either help or just make it for you! | |||||||
24 | ||||||||
25 | ||||||||
26 | ||||||||
27 | ||||||||
28 | ||||||||
29 | ||||||||
30 | ||||||||
31 | ||||||||
32 | ||||||||
33 | ||||||||
34 | ||||||||
35 | ||||||||
36 | ||||||||
37 | ||||||||
38 | ||||||||
39 | ||||||||
40 | ||||||||
41 | ||||||||
42 | ||||||||
43 | ||||||||
44 | ||||||||
45 | ||||||||
46 | ||||||||
47 | ||||||||
48 | ||||||||
49 | ||||||||
50 | ||||||||
51 | ||||||||
52 | ||||||||
53 | ||||||||
54 | ||||||||
55 | ||||||||
56 | ||||||||
57 | ||||||||
58 | ||||||||
59 | ||||||||
60 | ||||||||
61 | ||||||||
62 | ||||||||
63 | ||||||||
64 | ||||||||
65 | ||||||||
66 | ||||||||
67 | ||||||||
68 | ||||||||
69 | ||||||||
70 | ||||||||
71 | ||||||||
72 | ||||||||
73 | ||||||||
74 | ||||||||
75 | ||||||||
76 | ||||||||
77 | ||||||||
78 | ||||||||
79 | ||||||||
80 | ||||||||
81 | ||||||||
82 | ||||||||
83 | ||||||||
84 | ||||||||
85 | ||||||||
86 | ||||||||
87 | ||||||||
88 | ||||||||
89 | ||||||||
90 | ||||||||
91 | ||||||||
92 | ||||||||
93 | ||||||||
94 | ||||||||
95 | ||||||||
96 | ||||||||
97 | ||||||||
98 | ||||||||
99 | ||||||||
100 |