Hi,
I'm running the Linkworlds adventure for my T20 group. I made the mistake in the first proper session of not working out in advance what cargos, passengers and speculative goods were available for the Grendelsbane crew - so a lot of dice rolling and table-checking later, I decided in future to do all that stuff in between sessions
I also decided to automate...
What I plan on doing is:
a) Come up with an Excel spreadsheet to take care of the starship book-keeping; and
b) Come up with a way of generating random cargos, passengers and trade goods.
The spreadsheet is the easy bit, and before I write it I was just wondering if anyone had already done something similar (no point re-inventing the wheel).
It would basically be a sheet of five data blocks, one per week plus one for 'month end'.
Income would be divided into 'legal' - passengers (single & double occupancy) for high, middle & low passage; the various categories of cargo; speculative goods. And 'illegal' - smuggling profits.
Expenditure would be for fuel, maintenance, annual refit, crew wages, life support, landing fees, and fees (and bribes!) and local taxes.
Am I missing anything?
The 'monthly' part would then subtract the mortgage payment, and a 10% Imperial tax on profit (IMTU).
The random cargo /spec. goods/ passenger bit will be trickier, but one of my players is a perl-script junkie and he reckons he could write an app quite easily.
What we're looking at doing is having a front end that will let you type in either the UWPs of the origin and destination worlds (or, now that I have Gal24 with the T20 Gateway domain, the trade codes), and any Broker, Steward, or Recruiting skills involved and will output randomly generated cargos, spec. goods and passenger lists.
Would there be any interest in this?
If I was to make them available on a website, and apart from including the standard copyright notices, would there be any problem with copyright? (None that I can see with the spreadsheet, but the cargo application would be using the T20 tables as it's source).
Hope this makes some kind of sense!
Anton
I'm running the Linkworlds adventure for my T20 group. I made the mistake in the first proper session of not working out in advance what cargos, passengers and speculative goods were available for the Grendelsbane crew - so a lot of dice rolling and table-checking later, I decided in future to do all that stuff in between sessions

I also decided to automate...
What I plan on doing is:
a) Come up with an Excel spreadsheet to take care of the starship book-keeping; and
b) Come up with a way of generating random cargos, passengers and trade goods.
The spreadsheet is the easy bit, and before I write it I was just wondering if anyone had already done something similar (no point re-inventing the wheel).
It would basically be a sheet of five data blocks, one per week plus one for 'month end'.
Income would be divided into 'legal' - passengers (single & double occupancy) for high, middle & low passage; the various categories of cargo; speculative goods. And 'illegal' - smuggling profits.
Expenditure would be for fuel, maintenance, annual refit, crew wages, life support, landing fees, and fees (and bribes!) and local taxes.
Am I missing anything?
The 'monthly' part would then subtract the mortgage payment, and a 10% Imperial tax on profit (IMTU).
The random cargo /spec. goods/ passenger bit will be trickier, but one of my players is a perl-script junkie and he reckons he could write an app quite easily.
What we're looking at doing is having a front end that will let you type in either the UWPs of the origin and destination worlds (or, now that I have Gal24 with the T20 Gateway domain, the trade codes), and any Broker, Steward, or Recruiting skills involved and will output randomly generated cargos, spec. goods and passenger lists.
Would there be any interest in this?
If I was to make them available on a website, and apart from including the standard copyright notices, would there be any problem with copyright? (None that I can see with the spreadsheet, but the cargo application would be using the T20 tables as it's source).
Hope this makes some kind of sense!

Anton