tag:blogger.com,1999:blog-4353391426294254427.post1760205935615037661..comments2024-03-29T07:44:02.365-04:00Comments on Dreams in the Lich House: Using VLOOKUP to Generate Game Content in ExcelJohnhttp://www.blogger.com/profile/18031181424520125213noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-4353391426294254427.post-87549871119459851922014-04-24T23:04:17.896-04:002014-04-24T23:04:17.896-04:00The DropBox link worked perfectly, thanks!The DropBox link worked perfectly, thanks!Crawenhttps://www.blogger.com/profile/09311158169488921312noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-27956896677800503122014-04-24T10:30:32.771-04:002014-04-24T10:30:32.771-04:00I just added a DropBox link to the bottom of the a...I just added a DropBox link to the bottom of the article - let's see if that works for you guys. If so, maybe I'll post more stuff from time to time.Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-30572026572335152292014-04-24T10:03:13.796-04:002014-04-24T10:03:13.796-04:00Sounds like it would also make it much easier to c...Sounds like it would also make it much easier to consolidate tables from a number of different sources, without worrying about how big they are. And yes, I think Dropbox or GoogleDocs should work well.Crawenhttps://www.blogger.com/profile/09311158169488921312noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-54788085804133986072014-04-24T06:44:04.163-04:002014-04-24T06:44:04.163-04:00Sure; or GoogleDocs.
And yeah, it's a great po...Sure; or GoogleDocs.<br />And yeah, it's a great post, kind of make me want to use more automated generators during preparation.Ynas Midgardhttps://www.blogger.com/profile/14972628887096890642noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-52239053323268630172014-04-24T00:24:33.490-04:002014-04-24T00:24:33.490-04:00Serendipity! Thanks for putting these posts togeth...Serendipity! Thanks for putting these posts together - it just so happens that I've been making a lot of spreadsheets for generating AD&D stuff - this is very helpful!gdbackushttps://www.blogger.com/profile/09245941451462450346noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-76562100400507446992014-04-23T21:34:59.495-04:002014-04-23T21:34:59.495-04:00Beautiful! Thank you!Beautiful! Thank you!faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-72483161022916997652014-04-23T19:21:34.718-04:002014-04-23T19:21:34.718-04:00I wouldn't mind posting the sample file with t...I wouldn't mind posting the sample file with the formulas, I think Roger asked something similar on the other post. However, I've never done any file sharing via blog - what works? A link to a public drop box, for instance?Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-89053207223245671832014-04-23T13:55:29.246-04:002014-04-23T13:55:29.246-04:00Actually, it's not that hard. Say I have a tab...Actually, it's not that hard. Say I have a table (using the Named Range "OrcArmour") that determines armour for orcs by rolling 1d10. 1-3=none, 4-6=leather, 7-9=chain, 10=plate. <br /><br />The table has 2 columns (which I'll show here separated by a - since I can't put in a proper table:<br />1 - none<br />4 - leather<br />7 - chain<br />10 - plate<br /><br />I could put a header row above it on my Data page, as long as I didn't include it in the named range.<br /><br />My vlookup cell will contain this:<br /><br />=VLOOKUP(RANDBETWEEN(1,10),OrcArmour,2,TRUE)<br /><br />The random number generator is obvious. OrcArmour tells it which named range to look at, 2 tells it which column to find the result in, and TRUE means that if the random number rolled is not one of the ones in column 1, it will use the nearest lower number that there is. (Search for 'range_lookup' in the excel help for an actual explanation; I figured this out for myself this by messing around with an excel character sheet for Legend that someone had made, and so I learned how to do it without understanding the actual syntax).Alea iactanda esthttps://www.blogger.com/profile/17951704235056042923noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-66339031063902578202014-04-23T10:08:33.502-04:002014-04-23T10:08:33.502-04:00Thank you for posting this! Just yesterday, and to...Thank you for posting this! Just yesterday, and totally by coincidence I created a list of random names and almost 400 medieval nicknames in Excel, so this is perfect timing. Would you consider posting any of the Excel files that you use?Crawenhttps://www.blogger.com/profile/09311158169488921312noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-55574747861538381212014-04-23T08:54:50.845-04:002014-04-23T08:54:50.845-04:00Ha, I was afraid of that. Ah, well.Ha, I was afraid of that. Ah, well.faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-21061086462673701432014-04-23T06:59:39.869-04:002014-04-23T06:59:39.869-04:00I just use the brute force approach of making a ta...I just use the brute force approach of making a table with 100 rows, and if one value appears 01 - 03, then I copy it to rows 1, 2, 3 so it's weighted appropriately. You lose efficiency for simplicity.Johnhttps://www.blogger.com/profile/18031181424520125213noreply@blogger.comtag:blogger.com,1999:blog-4353391426294254427.post-59734657807234767672014-04-23T03:22:34.286-04:002014-04-23T03:22:34.286-04:00Is there an easy way to do d% weighted tables? For...Is there an easy way to do d% weighted tables? For example, if the first result is 01-03, the second is 04-05, the third 06-11, the fourth 12-15, and so on.faoladhhttps://www.blogger.com/profile/03691952430041394614noreply@blogger.com