Excel questions

[Nellisir]

Try this:

Works beautifully.

 

[Nellisir]

Thanee's RAND is better than RANDBETWEEN because many machines haven't downloaded the component necessary for the latter to work.

I'm having trouble with the RAND formula (RANDBETWEEN didn't work). RAND works, but the result hasn't been usable in a subsequent formula. IE, if RAND generates the number of creatures, the EL formula above, which uses that result, returns an error. Either I'm doing something wrong, or I need to "push" the result to another box (I tried "pulling" it, but that didn't work).

This is a little more complicated, at least for someone with my preparation. I'd need a little more detail to propose a solution, if no-one else hasn't already done so. I would suggest putting the behind the scenes stuff in a separate sheet so that you don't have to hide rows or columns.

I think that's what I'll do. This is only the second time I've used Excel for more than a few minutes, so it was initially easier to keep things on one sheet. As I add more stuff, moving the mundane stuff to another sheet makes more sense.

I might start another thread tonight, outlining ideas and seeing what people come up with for ways to accomplish them. Ultimately, it'd be neat to be able to enter an EL level, climate, and terrain, and have it return a random encounter complete with treasure (but not creature stats. I'm not that insane. I just want customizable random encounter charts for my homebrew.) or a random encounter chart centered on that EL.