Sector Development Spreadsheets

[Graham2001]

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]

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]

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]

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]

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.

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]

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

 

[egor045]

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/c054p74gxhyep4w/AACh-JHPe_73F1uQCbPaIyQJa?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]

Works in OpenOffice.

 

[Ulsyus]

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.