tag:blogger.com,1999:blog-4353391426294254427.post2288067621505318564..comments2024-03-25T22:48:31.750-04:00Comments on Dreams in the Lich House: Happy New Year, GreyhawkJohnhttp://www.blogger.com/profile/18031181424520125213noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-4353391426294254427.post-25748059724148874692012-04-14T18:49:02.279-04:002012-04-14T18:49:02.279-04:00This is awesome! I'm going to give it a shot a...This is awesome! I'm going to give it a shot and hope that the Excel you shared in the comments gets me there; my Excel knowledge is good but not great.Martin Ralyahttp://www.gnomestew.comnoreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-50822503268365393052011-09-02T03:47:36.319-04:002011-09-02T03:47:36.319-04:00Actually, never mind. I think I know what to do. T...Actually, never mind. I think I know what to do. The advantage of having more sheets helps out a lot.<br /><br />Is there a way to make it so that I don't have to type in every box, when there are so many similar boxes? For instance, it's the same set of calculations for day 10 as it is for day 110, but do I have to manually enter the formulas in each line?faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-85141087517026262672011-09-02T02:57:39.544-04:002011-09-02T02:57:39.544-04:00Would you be willing to make your spreadsheet avai...Would you be willing to make your spreadsheet available to us as an example? Some of the things you've done are things that I am not sure how to do, and I'd like to see exactly how you have them set up.faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-91856528354042006692011-09-01T19:04:19.122-04:002011-09-01T19:04:19.122-04:00In short, with multiple LESS THAN AND GREATER THAN...In short, with multiple LESS THAN AND GREATER THAN statements it just didn't want to work (even with ands), despite a bit of research, so I simply shorted the temps to RANDBETWEEN the temp gauges.<br /><br />Either way I have it worked out now. Thanks for all that.Silentjudashttps://www.blogger.com/profile/02247528343114130690noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-43562332702460622682011-09-01T18:15:33.626-04:002011-09-01T18:15:33.626-04:00I suppose that there is an AND function in Excel w...I suppose that there is an AND function in Excel which would allow you to do four or more values. I see that there is one in OpenOffice.org's Calc.faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-85663924950667758612011-09-01T16:28:01.523-04:002011-09-01T16:28:01.523-04:00Whoops - I posted a response to the one you nuked,...Whoops - I posted a response to the one you nuked, SilentJudas - guess that means you got it?Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-79573104674215001942011-09-01T16:27:06.108-04:002011-09-01T16:27:06.108-04:00Here's how you break that down with one of the...Here's how you break that down with one of these IF statements.<br /><br />There are 3 outcomes to the roll - less than 5 = A, greater than 50 = B, and the condition you want, which is everything else (things that fall between 5 and 50 = C).<br /><br />Here's how you check for C with one of these. Let's say X is your random result.<br /><br />=IF(X<5,A,(IF(X>50,B,C)))<br /><br />Reading right to left, it says if X is less than 5, use result A; if X is greater than 50, use result B; everything else is C. Voila.Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-62363188945496295192011-09-01T16:15:24.343-04:002011-09-01T16:15:24.343-04:00This comment has been removed by the author.Silentjudashttps://www.blogger.com/profile/02247528343114130690noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-14534653532646224512011-09-01T15:42:50.573-04:002011-09-01T15:42:50.573-04:00Ah, ok I understand now. I had no clue how to prod...Ah, ok I understand now. I had no clue how to produce a random "roll" in excel.<br /><br />And the rest helps clear that all up. Thanks!<br />Can't wait to put this together. Add some extra flavor and usefulness for my campaign.Silentjudashttps://www.blogger.com/profile/02247528343114130690noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-59831466647821927412011-09-01T15:29:40.202-04:002011-09-01T15:29:40.202-04:00Ah, I hear ya. You do need to be able to put some...Ah, I hear ya. You do need to be able to put some formulas in excel - here are some samples that can get you started.<br /><br />This is a simple function for generating a random number between 1 and 100 (a percentile roll):<br /><br />=RANDBETWEEN(1,100)<br /><br />Then I just us a lot of IF statements (and nested IFs).<br />For instance, this one checks a random roll (in cell A9) against the temperature formula to determine if a given day is 32, 40 or 50°.<br /><br />=IF(A9<6,32,(IF(A9>94,50,40)))<br /><br />A9 is the random result.<br />A9<6 represents a roll of 1-5 = 32°.<br />A9>94 represents a roll of 95-100 = 50°.<br />and everything else ends up at 40°.<br /><br />Below is what a longer series of nested IFs looks like to generate the type of precipitation (if the precipitation % chance came out "Yes").<br /><br />=IF(E9="yes",RANDBETWEEN(1,6),0)<br /><br />=IF(F9=1,"mist",IF(F9=2,"drizzle",IF(F9=3,"steady",IF(F9=4,"strong",IF(F9=5,"pounding",IF(F9=6,"downpour","no rain"))))))<br /><br />I have a series of columns that generate the random numbers and apply formulas from the article, and then just concatenate the results into a single column for easy pasting into the actual calendar worksheet.<br /><br />Hope that helps a little! I'm no programmer, but you can get a lot done in excel with some basic formulas.<br /><br />That article is definitely asking for a talented web programmer to build a simple weather generation program!Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-34876456912555729262011-09-01T14:59:46.368-04:002011-09-01T14:59:46.368-04:00Ok I'm looking at 137 now and I have to ask......Ok I'm looking at 137 now and I have to ask...how did you translate any of this to Excel??? Maybe I'm missing something....Silentjudashttps://www.blogger.com/profile/02247528343114130690noreply@blogger.com