Citizens of the Imperium

Citizens of the Imperium (http://www.travellerrpg.com/CotI/Discuss/index.php)
-   Software Solutions (http://www.travellerrpg.com/CotI/Discuss/forumdisplay.php?f=63)
-   -   Sector Development Spreadsheets (http://www.travellerrpg.com/CotI/Discuss/showthread.php?t=38289)

Graham2001 September 28th, 2017 12:43 PM

Sector Development Spreadsheets
 
I'm currently working on a sector the old fashioned way (Dice & LBB03), and I've got to the world generation part. I was wondering if there is a spreadsheet or software into which I could enter a partial UWP to work out the exact modifiers to be applied to the Tech Level dice roll? It would speed things up a lot.

robject September 28th, 2017 01:22 PM

I betcha Joshua Bell's Travellermap has that. I know he has forms that take entire data sets.

Maybe https://travellermap.com/tools/lintsec.html ?

As a second choice, I have one here:

http://traveller5.net/tools/vilanitools.html

Click on the "UWP and Distance" tab. The UWP Analyzer field will analyze them, one at a time :(


There's no reason my code couldn't split newlines and process many UWPs. I suppose I should do that :/

Graham2001 September 28th, 2017 09:47 PM

Thanks,

That UWP Analyzer tool will speed up generating the trade codes, but, I 'm still looking for something that will speed up working out the DMs to apply to the Tech Level roll. I'm currently using Joshuas Sector Lint tool to make sure I've not made any gross errors.

Ulsyus September 29th, 2017 12:11 PM

If you're doing it in a spreadsheet with each element of the UWP in a separate column, then there's a fast way of working out which worlds in the sector have which trade classifications (TC).

If you apply a Filter to the headers row you can select the values for each of the UWP components that return a particular TC. Then all you have to do is copy the TC into the appropriate cells for the worlds returned, then clear your filters and start on the next TC.

It's likely slower than writing code or a function to do it for you if you're going to do multiple sectors, but with a combo of filtering then copying and pasting codes it does the job pretty quickly.

Let me know if that's not clear and I'll give you an example sheet

robject September 29th, 2017 03:57 PM

Quote:

Originally Posted by Graham2001 (Post 574332)
Thanks,

That UWP Analyzer tool will speed up generating the trade codes, but, I 'm still looking for something that will speed up working out the DMs to apply to the Tech Level roll.

Hey, that's a good idea.

Quote:

Originally Posted by Ulsyus (Post 574362)
If you're doing it in a spreadsheet with each element of the UWP in a separate column, then there's a fast way of working out which worlds in the sector have which trade classifications (TC).

If you apply a Filter to the headers row you can select the values for each of the UWP components that return a particular TC. Then all you have to do is copy the TC into the appropriate cells for the worlds returned, then clear your filters and start on the next TC.

And THAT's a really good idea!

whartung September 29th, 2017 06:30 PM

Seems like it might almost be faster to click on the "roll" button until you get a planet you like.

egor045 September 29th, 2017 07:57 PM

Quote:

Originally Posted by Graham2001 (Post 574318)
I'm currently working on a sector the old fashioned way (Dice & LBB03), and I've got to the world generation part. I was wondering if there is a spreadsheet or software into which I could enter a partial UWP to work out the exact modifiers to be applied to the Tech Level dice roll? It would speed things up a lot.

I've bodged up a spreadsheet (in GDocs, downloaded as Excel) which will calculate the TL DM for a partial UWP. You should be able to retrieve it from Dropbox at the following URL: https://www.dropbox.com/sh/c054p74gx...CbPaIyQJa?dl=0

Type a UWP in the yellow box (UWP tab) or drop a list of UWPs in the yellow boxes (multiple UWPs tab).

Disclaimer: I don't have a copy of Excel to test this, but it works in GDocs and LibreOffice.

ShawnDriscoll September 30th, 2017 03:10 AM

Works in OpenOffice.

Ulsyus September 30th, 2017 12:40 PM

Nice work.

The problem with trying to automate the whole thing is generating the random numbers, which isn't an issue, but then automatically copying the result as a value and not as simply another function that will change with each new cell entry that's made.

Good use of the vlookup, it's effective for DMs, you just need to devote the time and capacity to building the tables, and then combine them with the random number. The latter can be generated in a column or row, depending on how you've oriented it, which you can then hide. I used the RANDBETWEEN function to generate the random number, copied it as a value into the next column, then deleted the function as it'd done it's job.

I used filters as I'm doing rather uncivilized hours and haven't the patience or energy to get to them at 10 at night (as opposed to when I get onto CotI - while I'm eating) but a combo of VLOOKUP and generating random numbers can do the job.

The other thing is that it depends on what sized area you're working on, how much time you have, and how much you want to craft it. If it's just a sub-sector then I reckon we should take our time and generate something that helps drive our scenarios and campaigns in the direction that we want to referee them.


All times are GMT -4. The time now is 09:22 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright (c) 2010-2013, Far Future Enterprises. All Rights Reserved.