tag:blogger.com,1999:blog-8370619227360997359.post6442738667827823788..comments2024-02-26T02:20:51.185-08:00Comments on Carjacked Seraphim: Filling Those HexesJimhttp://www.blogger.com/profile/18158916950442942918noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-8370619227360997359.post-74828774395856754672011-05-19T01:21:43.699-07:002011-05-19T01:21:43.699-07:00I'm already seeing a next generation for this ...I'm already seeing a next generation for this where you specify a dominant terrain type and it rattles off the terrain and appropriate encounters as well ...Roger G-Shttps://www.blogger.com/profile/08594440701279968693noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-88441945755495371782011-05-11T19:40:20.432-07:002011-05-11T19:40:20.432-07:00@Bob -- Thanks for doing that and thanks for shari...@Bob -- Thanks for doing that and thanks for sharing!Jimhttps://www.blogger.com/profile/18158916950442942918noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-88900327915334157282011-05-11T14:30:34.181-07:002011-05-11T14:30:34.181-07:00I put the chart lookup into the Excel sheet. It do...I put the chart lookup into the Excel sheet. It doesn't change the colors, but it will do the lookup and populate the fields. I moved the parenthetical stuff into a third column on the table to make the sheet easier to read once generated. You can get the Excel 2007 version <a href="http://www.rpgfiles.org/users/spectresghost/Wilderness_Hex_Calculator.xlsx" rel="nofollow">here</a> and the Excel 97-2003 version <a href="http://www.rpgfiles.org/users/spectresghost/Wilderness_Hex_Calculator.xls" rel="nofollow">here</a>.<br /><br />As far as populating the cells with the results of subtables, the only reliable way to do it is with VB. I always ran into too many errors when I tried doing it with nested calculations in the sheet.Robert Morrishttps://www.blogger.com/profile/03345468894311108269noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-19401332243909745102011-05-11T06:55:46.542-07:002011-05-11T06:55:46.542-07:00Very cool! Thanks!Very cool! Thanks!Christopherhttps://www.blogger.com/profile/16988517412357391012noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-91638707457990658972011-05-11T06:50:22.362-07:002011-05-11T06:50:22.362-07:00(BTW, I'm just busting your chops... I know wh...(BTW, I'm just busting your chops... I know why and it's cool. I have a prototype test case with Kellri's village/town tables anyway, just tossing it together right now.)Michael S/Chgowizhttps://www.blogger.com/profile/02052820400496340137noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-50479069539776188982011-05-11T06:49:42.708-07:002011-05-11T06:49:42.708-07:00@Jim - the consensus from reading various Excel/VB...@Jim - the consensus from reading various Excel/VBasic forums is that we'll have to do this via VBasic. <br /><br />You know, if your PDF didn't paste sanskrit when I do a copy, this would be much easier to create test cases. :PMichael S/Chgowizhttps://www.blogger.com/profile/02052820400496340137noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-3486369932815496982011-05-10T21:01:05.704-07:002011-05-10T21:01:05.704-07:00@Everyone -- thanks for the comments. I agree wit...@Everyone -- thanks for the comments. I agree with ChicagoWiz -- the next step is a bear... It might be easy to build an hlookup off the vlookup; kinda looking up on a matrix; down then over... dunno... just a thoughtJimhttps://www.blogger.com/profile/18158916950442942918noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-42443100378497089082011-05-10T20:09:26.192-07:002011-05-10T20:09:26.192-07:00I have a ridiculously large spreadsheet for just t...I have a ridiculously large spreadsheet for just that - I need to put it out there for community use at some point. Good on you for actually doing it.John Matthew Staterhttps://www.blogger.com/profile/02310914386482078369noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-19460983108098156732011-05-10T18:57:54.824-07:002011-05-10T18:57:54.824-07:00My spreadsheet does very similar, but I'm taki...My spreadsheet does very similar, but I'm taking it the next step to populate the hexes with the results from those tables. That's a bit harder as it's a num-of-hexes*n-number-of-following rows which Excel doesn't do so well. Thanks for hacking this up, at least I know I'm not crazy for trying.Michael S/Chgowizhttps://www.blogger.com/profile/02052820400496340137noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-42740497072736507462011-05-10T17:43:53.280-07:002011-05-10T17:43:53.280-07:00I'll see what I can do to make it work in Exce...I'll see what I can do to make it work in Excel in a bit. Thanks for getting this together.Robert Morrishttps://www.blogger.com/profile/03345468894311108269noreply@blogger.comtag:blogger.com,1999:blog-8370619227360997359.post-11591454059899708552011-05-10T17:24:24.659-07:002011-05-10T17:24:24.659-07:00Cool. Thanks, Jim!Cool. Thanks, Jim!Treyhttps://www.blogger.com/profile/04647628467658839351noreply@blogger.com