Excel Ship Designer v2024.12.25b

[tytalan]

Oh wait! What's this? Another example of Mongoose spreading the ship construction rules over a million books. How are future authors supposed to write official material for Traveller or for the OTU if the rules for said construction is spread over a million different books? Mongoose is setting themselves up for a serious quality control problem due to sloppy organization (Edit: Perhaps lack of sufficient oversight is a more appropriate term) of the published materials.

It is simple guys... If it is a ship construction rule, it goes in High Guard. If it is a vehicle construction rule, it goes in VH, etc.

Have you ever played a RPG. Adding things in splat book is one of the things that keep them selling which in turn keep the company in business to make products. This is a no brainer and only a few people here seem to not understand. I don’t see pathfinder players complaining that not all the character feats are in the players core.

 

[tytalan]

I did hit a snag today I was fixing the ECITS’s from the Drinax Companion and I ran smack into needing a maneuver drive for a larger tonnage than the ship itself. This would also be a problem with battle raiders

 

[Arkathan]

Have you ever played a RPG. Adding things in splat book is one of the things that keep them selling which in turn keep the company in business to make products. This is a no brainer and only a few people here seem to not understand. I don’t see pathfinder players complaining that not all the character feats are in the players core.

Oh, I don't complain about it, I just don't allow any classes/races/feats that aren't in the books I have. Problem solved. Plus, we use 1e, and wait until the PDF's are on sale (even though regular price is often $10) or in Humble Bundle. While PDF's are pure profit after the credit card's take their cut, they are not getting much out of us.

 

[Condottiere]

It's sixty tonnes for two plus one till hundred kilotonnes.

So, forty tonnes is smallified.

 

[Terry Mixon]

I did hit a snag today I was fixing the ECITS’s from the Drinax Companion and I ran smack into needing a maneuver drive for a larger tonnage than the ship itself. This would also be a problem with battle raiders

The spreadsheet can handle that with the adjusted tonnage section. I used it when making the million-ton Warmonger Battle Tender. It is made to run with an adjusted tonnage of 1,800,000 tons and the calculations work perfectly.

 

[Arkathan]

I did hit a snag today I was fixing the ECITS’s from the Drinax Companion and I ran smack into needing a maneuver drive for a larger tonnage than the ship itself. This would also be a problem with battle raiders

The drive tab has a chart, scroll far right that gives max tonnage for a given performance.
The box to the right in the regular view lets you enter an alternate tonnage.
A toggle field lets you calculate your engines based on that tonnage instead of the ship's.

If it is a different issue, can you post a screen shot?

 

[tytalan]

Oh, I don't complain about it, I just don't allow any classes/races/feats that aren't in the books I have. Problem solved. Plus, we use 1e, and wait until the PDF's are on sale (even though regular price is often $10) or in Humble Bundle. While PDF's are pure profit after the credit card's take their cut, they are not getting much out of us.

And I wasn’t replying to you was I. And PDF are not pure profit you has all the same cost associated with the product except the actual print run and shipping

 

[tytalan]

The drive tab has a chart, scroll far right that gives max tonnage for a given performance.
The box to the right in the regular view lets you enter an alternate tonnage.
A toggle field lets you calculate your engines based on that tonnage instead of the ship's.

If it is a different issue, can you post a screen shot?

Thank you I didn’t know that

 

[Arkathan]

And I wasn’t replying to you was I. And PDF are not pure profit you has all the same cost associated with the product except the actual print run and shipping

You invoked Pathfinder players. I provided an example of a Pathfinder player.
When you are talking about an old edition, those costs have already been paid for. The store is being paid for to sell 2e now, so selling 1e is gravy that costs next to nothing.

Thank you I didn’t know that

You're welcome. Check Terry Mixon's post too, he appended a screenshot in case you need it.

 

[tytalan]

You invoked Pathfinder players. I provided an example of a Pathfinder player.
When you are talking about an old edition, those costs have already been paid for. The store is being paid for to sell 2e now, so selling 1e is gravy that costs next to nothing.

I was using PF as an example. There are a few people that keep bitching if mongoose posts any construction rules outside of high guard. Their complaints actually show how little they understand how the gaming industry business works. Which is why I responded to the person i did.

Yes you are entirely right once that production costs are paid PDF are largely pure profit tho that depends a lot on where they are sold. For example Drivethrurpg takes a fairly large % of the sale depending on the company they are dealing with. Unfortunately residual sales are notoriously low in quality and are often driven by new product. In fact the entire industry is driven by new products primarily those with new rules, which is why pure fluff splat books almost always lose money. Which is one of the main reasons you get new rules in new books that and new ideals and concepts. It also why those new rules are not folded into the existing books PDF it removes some of the reasons customers buy the new books.

MasterGwydion and a few others don’t seem to be able to grasp this basic business concept.

And Arkathan I’m not going after you I’m very appreciative of the work you do.

 

[Arkathan]

... For example Drivethrurpg takes a fairly large % of the sale depending on the company they are dealing with. ...

When I buy PF, I only go through Paizo or Humble Bundle... that way I either KNOW they are getting the money or I have at least an illusion that it is going to charity.

 

[Arkathan]

NEW VERSION: 2024.11.18

Fixed the issue with large vehicle bays having the same entry in both slots, thus not having an Hazardous rated version.
Aux Cons can be designated as SCC's.
Designating an an Aux Con as a SCC in a module now deactivates error notification.
Thanks again to Terry Mixon, for adding more craft to the list.

 

[tytalan]

When I buy PF, I only go through Paizo or Humble Bundle... that way I either KNOW they are getting the money or I have at least an illusion that it is going to charity.

I don't have that issue since my local store will not order Traveller books for me, I order direct and get the PDF free. shoot I have trouble getting them to order my PF2 books and PF2 is one of the top three TTRPGs

 

[Arkathan]

I don't have that issue since my local store will not order Traveller books for me, I order direct and get the PDF free. shoot I have trouble getting them to order my PF2 books and PF2 is one of the top three TTRPGs

That sucks. Our Brick and Mortar stores closed a while ago. Even our big one an hour away closed last year. (SciFi City in Orlando)

 

[Terry Mixon]

When adding miscellaneous crew, they are not counted on the crew tab. Nor are they counted on the staterooms tab. Marines get added correctly no matter which crewing category is used, and these need to be sone so in a similar manner.

Looks like Marines in the active column just add what is in the custom column. When I change that for the miscellaneous crew it fixes the issue. That and coloring the entry point orange like the Maines and backfilling the numbers in the Commercial and Military columns.

You might even want to have a second miscilanious crew row. I was looking at adding refinery workers and mining boat crews on the same ship. They would have different pay scales.

 

[Arkathan]

When adding miscellaneous crew, they are not counted on the crew tab. Nor are they counted on the staterooms tab. Marines get added correctly no matter which crewing category is used, and these need to be sone so in a similar manner.

Looks like Marines in the active column just add what is in the custom column. When I change that for the miscellaneous crew it fixes the issue. That and coloring the entry point orange like the Maines and backfilling the numbers in the Commercial and Military columns.

You might even want to have a second miscilanious crew row. I was looking at adding refinery workers and mining boat crews on the same ship. They would have different pay scales.

Increasing Misc to 5 rows. Just going in now to get the Record Sheet to see it.
Boat pilots: in the pilot row, # ship's boats adds pilots. Average level changes the computed total pay. So if you have a 3, a 2, and 3 1's, the avg would be 1.6, and that would be multiplied times base salary and number of pilots.
Your refinery workers should report under General Crew, so I'm going to add a toggle to syphon workers from there into Misc.

 

[Terry Mixon]

Increasing Misc to 5 rows. Just going in now to get the Record Sheet to see it.
Boat pilots: in the pilot row, # ship's boats adds pilots. Average level changes the computed total pay. So if you have a 3, a 2, and 3 1's, the avg would be 1.6, and that would be multiplied times base salary and number of pilots.
Your refinery workers should report under General Crew, so I'm going to add a toggle to syphon workers from there into Misc.

Thanks. In this case, the two-person crew on the mining craft was a pilot and an engineer. The pilot I could do like you said, but not the engineer. That's what I get for being weird.

I have a big ship with a refinery, and it hosts several 4-ton prospecting ships. Getting it all combined into one sheet is where I got into trouble. I really should have had a full commercial crew, but for a week two people should be enough.

 

[Arkathan]

Actually, there is a spot for tons of small craft drive, although that would not get you 1 engineer per small craft.
ANYWAY, Here you go:

New Version: 2024.11.18a

Expanded utility of Miscellaneous crew and allowed for better definition of certain General Crew members with toggles to subtract Misc categories from General Crew so they don't overlap.

 

[Terry Mixon]

Actually, there is a spot for tons of small craft drive, although that would not get you 1 engineer per small craft.
ANYWAY, Here you go:

New Version: 2024.11.18a

Expanded utility of Miscellaneous crew and allowed for better definition of certain General Crew members with toggles to subtract Misc categories from General Crew so they don't overlap.

Thanks. If I'd had a medic like it called for, that would have been a better example, I suspect.

 

[Terry Mixon]

On 9b - Optional, I'm paying a cool MCr for a research scoop whether I like it or not.

Also, the selected crew count isn't reflected on the summary page.