Terry Mixon
Emperor Mongoose
The players buy a ship on the cheap and discover it is made for dolphins. Hope they brought scuba gear.
Excel Ship Designer v2025.01.22a
- Thread starter Arkathan
- Start date
Prodromoi
Banded Mongoose
I've been transferring another design and found a couple more issues (sorry!).
Tab 9b-Optional. Typo in cells T74,T75,T76,T77
Should read "Personnel Excursion Bay"
The summary tab is not pulling info regarding Training Facilities (tab 9b-Optional, line 27) through correctly. The screenshot shows the data from the 'standard' Type-M Liner; input 2 in cell C27 (for training equipment sufficient for two people) and calculates the tonnage and cost correctly.
However I believe cell K27 is incorrect; HG2022 p63 covers the training facilities, and there is no power requirement mentioned. (Unlike the original edition - looks like something that has been changed).
Finally, per the screenshot, the summary tab shows "Training Facility: 0 person group cap". Surely this should say something like "2 person capacity"?
Tab 9b-Optional. Typo in cells T74,T75,T76,T77
Should read "Personnel Excursion Bay"
The summary tab is not pulling info regarding Training Facilities (tab 9b-Optional, line 27) through correctly. The screenshot shows the data from the 'standard' Type-M Liner; input 2 in cell C27 (for training equipment sufficient for two people) and calculates the tonnage and cost correctly.
However I believe cell K27 is incorrect; HG2022 p63 covers the training facilities, and there is no power requirement mentioned. (Unlike the original edition - looks like something that has been changed).
Finally, per the screenshot, the summary tab shows "Training Facility: 0 person group cap". Surely this should say something like "2 person capacity"?
Attachments
Arkathan
Emperor Mongoose
Thanks, for finding stuff, Prodromoi.
I refuse to put out another fix until 2025.
Fortunately, it is already 2025 somewhere.
Might as well get it out before the alcohol starts flowing. (kidding, I gave up on drinking about the same time it became legal for me to drink)
Happy New Year!
NEW VERSION: 2025.01.01
Updated the way Multi-Environmental Spaces report
Fixed more spelling errors
The summary for training was off by one field. Fixed
Added user-defined descriptors for labs, studios and training facilities. (not suitable for more than one or two examples - need to use fluff text for more)
I refuse to put out another fix until 2025.
Fortunately, it is already 2025 somewhere.
Might as well get it out before the alcohol starts flowing. (kidding, I gave up on drinking about the same time it became legal for me to drink)
Happy New Year!
NEW VERSION: 2025.01.01
Updated the way Multi-Environmental Spaces report
Fixed more spelling errors
The summary for training was off by one field. Fixed
Added user-defined descriptors for labs, studios and training facilities. (not suitable for more than one or two examples - need to use fluff text for more)
Last edited:
Prodromoi
Banded Mongoose
Please promise you won't work on it again tonight, but enjoy the new year instead! (It's about three and a half hours to go here.)
I've found an issue on the update.
On tab 11-Staterooms, looks like you have not extended the calculation cells to account for the newly-added Multi-environment lines.
Once I transferred a design and found a 29dTon discrepancy in the overall tonnage. Double and triple-checked the data I'd transferred in case I missed anything, but I had not. Cell H3 on tab 11-Staterooms was the discrepency.
As follows:
H3=S26
In turn, S26=SUM(H15:H56) but that should be S26=SUM(H15:H71) to account for the inserted lines regarding Multi-Environment.
I've found an issue on the update.
On tab 11-Staterooms, looks like you have not extended the calculation cells to account for the newly-added Multi-environment lines.
Once I transferred a design and found a 29dTon discrepancy in the overall tonnage. Double and triple-checked the data I'd transferred in case I missed anything, but I had not. Cell H3 on tab 11-Staterooms was the discrepency.
As follows:
H3=S26
In turn, S26=SUM(H15:H56) but that should be S26=SUM(H15:H71) to account for the inserted lines regarding Multi-Environment.
Arkathan
Emperor Mongoose
Doing updates while on cold meds is no excuse...
but I don't want to admit to senility yet.
Edit: Weird. The tonnage column was affected but the cost and power were not.
Not used to how this updated Office works, while trying to use only really old commands to keep this cross-compatible.
but I don't want to admit to senility yet.
Edit: Weird. The tonnage column was affected but the cost and power were not.
Not used to how this updated Office works, while trying to use only really old commands to keep this cross-compatible.
Last edited:
AndrewW
Emperor Mongoose
Admit nothing, they can't prove a thing.
Prodromoi
Banded Mongoose
Looks like I've stumbled across another issue I'm afraid.
Testing a design, adding a Grav Screen (line 29, tab 8b-Screens), it populates correctly on that tab but does not get pulled through correctly onto the summary tab.
The screen is added to the 'top' part of the ship summary, listing the item, tonnage and cost correctly (between 'weapons' and 'craft'). However it does not add a 'screens' section to the lower part of the summary, so the tally of power requirements is short.
As a further test I tried adding a Deflector Screen (line 9 on the same tab), and this one is correctly pulled into the Summary tab's power section. (But the Grav screen in the same test was still absent)
Testing a design, adding a Grav Screen (line 29, tab 8b-Screens), it populates correctly on that tab but does not get pulled through correctly onto the summary tab.
The screen is added to the 'top' part of the ship summary, listing the item, tonnage and cost correctly (between 'weapons' and 'craft'). However it does not add a 'screens' section to the lower part of the summary, so the tally of power requirements is short.
As a further test I tried adding a Deflector Screen (line 9 on the same tab), and this one is correctly pulled into the Summary tab's power section. (But the Grav screen in the same test was still absent)
Attachments
Arkathan
Emperor Mongoose
The power distribution graph on the Power Tab was the fault. Fixed.
Here is a temporary link to the fix (no telling how long Discord will keep it open) or it will be in the next update.
Ship Designer
Here is a temporary link to the fix (no telling how long Discord will keep it open) or it will be in the next update.
Ship Designer
Prodromoi
Banded Mongoose
Thank you.
I also ended up doing a fair bit of head-scratching over interpretations of the wording in HG (both versions) as there are some ambiguities.
Does the Grav Screen need a dedicated gunner. The section about crew says one gunner per screen (commercial) or 2 per screen (military). But the grav screen isn't in the screens section, but is in the customisation section and reads more like an add-on 'scrambler' sort of thing than a 'real' defensive screen. So it's hard to know the intent there.
The other thing was about the "x crew per tonnage" calculations (page 23, HG2020). Medics and mechanics for example, say "1 crew per" (and it's related to crew & passengers, or tonnage, respectively). I cannot see anywhere that the calculation is "or part thereof". So a mechanic (1 per 1000 tons, for a commercial ship) isn't required until you get to a 1,000 dTon ship. Several designs (I have not checked every single one!) in High Guard and other books seem to adhere to this.
On the crew tab (and summary sheet) the crew figures seem to adhere to the "or part thereof" interpretation. (i.e. rounding up, not rounding down). Is there some option here that I've missed? (For example, the venerable Type-R, page 189 of HG2022 does have a medic listed, but not a mechanic, which clearly means it's breaking the rule in one way, or another!)
I also ended up doing a fair bit of head-scratching over interpretations of the wording in HG (both versions) as there are some ambiguities.
Does the Grav Screen need a dedicated gunner. The section about crew says one gunner per screen (commercial) or 2 per screen (military). But the grav screen isn't in the screens section, but is in the customisation section and reads more like an add-on 'scrambler' sort of thing than a 'real' defensive screen. So it's hard to know the intent there.
The other thing was about the "x crew per tonnage" calculations (page 23, HG2020). Medics and mechanics for example, say "1 crew per" (and it's related to crew & passengers, or tonnage, respectively). I cannot see anywhere that the calculation is "or part thereof". So a mechanic (1 per 1000 tons, for a commercial ship) isn't required until you get to a 1,000 dTon ship. Several designs (I have not checked every single one!) in High Guard and other books seem to adhere to this.
On the crew tab (and summary sheet) the crew figures seem to adhere to the "or part thereof" interpretation. (i.e. rounding up, not rounding down). Is there some option here that I've missed? (For example, the venerable Type-R, page 189 of HG2022 does have a medic listed, but not a mechanic, which clearly means it's breaking the rule in one way, or another!)
Arkathan
Emperor Mongoose
The Custom column and selection lets you see the recommendations for Commercial and Military and then tell them both to sod off.
Scouts in the lore often fly with just the one scout, so there is precedent.
Lots of old designs fail to conform to current crew rules. So unless the calculations are just wrong, the answer is custom crew.
Scouts in the lore often fly with just the one scout, so there is precedent.
Lots of old designs fail to conform to current crew rules. So unless the calculations are just wrong, the answer is custom crew.
Prodromoi
Banded Mongoose
Agreed, and I have been using the custom column (thank you). And yes, there are plenty of designs which are borked in one way or another!
Arkathan
Emperor Mongoose
All this talk of the Sword World's Integrated Munitions System in the would a trader use missiles thread has reminded me that I never integrated the Integrated Munitions system.
Integrating it reminded me WHY.
In any case, if you want a preview before the next update, here it is... until Discord eats it.
Ship Designer
Integrating it reminded me WHY.
In any case, if you want a preview before the next update, here it is... until Discord eats it.
Ship Designer
Prodromoi
Banded Mongoose
On tab 11-Staterooms, cell C20 is the input cell for "Common area". The data validation is set to permit any positive number, including decimals. But the formatting on the cell is for "no decimal places". This means that if one puts in a common area figure of something-and-a-half dTons (the Type-R from High Guard 2022 is an example) it registers the half-ton correctly, but rounds up the displayed figure.
In this example, input of 5.5 dTons is calculated correctly, but shown incorrectly on tab 11, and on the summary tab as "6 tons". I have simply changed the formatting of C20 to "general" and it then displays correctly.
In this example, input of 5.5 dTons is calculated correctly, but shown incorrectly on tab 11, and on the summary tab as "6 tons". I have simply changed the formatting of C20 to "general" and it then displays correctly.
