ATTN Frostmarrow: My Excel Hero!!

[Angelsboi]

Ok. I want to make a random encounter generator where i can place my own monsters and have them randomly generated.

Also, there is a article in a dragon magazine (when 3e first came out - Issue with warriors) that has a random adventure table. How would i go about doing this. i know NOTHING about Excel so if anyone can help me, id be greatful.

 

[Frostmarrow]

Hi Angelsboi. I volunteered to help you yesterday but you weren't around. Today I don't have access to Excel. *sigh* However, if you don't receive any help from someone else I'll mail you a model tomorow (in 14 hours).

I'll be sure to add a randomizer and a listpicker.

Meanwhile, type this into a cell. Then press F9. Repeatedly.

=INT(RAND()*6)+1

A d6!

 

[Angelsboi]

Yes id like your help. the Dragon issue is Issue Number 275 and im looking for a random generator where i can put in the ammount of monsters i would like to use and then choose the terrain type and let it come up with a random encounter

 

[Frostmarrow]

I have that issue here. What if I make a small model of that table and post it on the web, then you can download it and expand? I'll throw in some notes to help you on your way.

I'll get back to you on the address.

 

[Angelsboi]

That would be great. Not to mention if you could do a monster one too with some notes.

 

[Frostmarrow]

We have different language versions. This can spell trouble. Anyway let's give it a try. First download angelsboi.xls (Right click and pick save as...) This will give you a handle on things. When you think you know what you are doing download character.xls. It has no monsters though but will show you stuff. (I made character before d20 was released while we were waiting so it might not be true to the rules, ok?)

Angelsboi

Character

We'll continue this tomorrow.

 

[Angelsboi]

Ok i will reply to this in the morning and see if i understand

 

[Angelsboi]

Bumping for Frostmarrow

 

[Angelsboi]

frostmarrow are you out there?

I emailed you yesterday with my Excel that i did and was curious how it was. Can you post some more advice i need on here?

Also .. There is Kaptain Kantrips Cimigraphic thingy where you have to roll a d100 to determine what you get. How would i do that in Excel?

Its getting easier =)

 

[Angelsboi]

Will someone who is good at Excel please email me and help me with this? Im stuck on how do get it to roll 1d3+1 and then produce that many obstacles from the list.

example: it randomly generates a 2 so 2 obstacles will be listed. if it generated 4, 4 obstacles would be displayed.

HELP!!??