Help needed with MT: Referee's Manual Design Sequence

[snrdg082102]

Hello all,

I mentioned in another post that I've been working on an Excel spreadsheet for the design sequence in the MT: Referee's manual and for the 3 part Wet Navy article in Challenge 53, 54, and 60.

Well, I've completed rebuilding the design sequence and tested using Joe Fugate's article "A MT: Starship Design Example" in the Travellers' Digest #13. The spreadsheet appears to work, but I found some eratta that threw off the numbers. However, there is one area I've not got a handle on which is needed for the Technical Readout. How can I create an automated process for determining the UCP Factors for the Turret Weapons on pp. 73 and 74.


Since I haven't figured out how to automate the Turret Weapon UCP Factor, I moved on to the Design Evaluation section (MT: Referee's Manual pp. 84-89). This has led me to another item I can't seem to get a handle on, which is determining the speed for an airframe hull through a thin atmosphere using the information on p. 86. Here are the numbers I have been working with:

2G Maneuver Drive = Top Vacuum Speed 2,120 (kph)
Hull configuration Needle/Wedge Air Frame (AF)
Standard Atmosphere Top Speed for an AF =
Top Vacuum Speed x 90%

2,120 x .9 = 1,908 kph.

Thin atmosphere speed, p. 86 Column 2 second line from the bottom states speed is 1.5 x Standard Atmosphere.

1,908 * 1.5 = 2,862 kph.

How can the thin atmosphere be faster than the speed in a vacuum?

 

[snrdg082102]

Hello all,

I mentioned in another post that I've been working on an Excel spreadsheet for the design sequence in the MT: Referee's manual and for the 3 part Wet Navy article in Challenge 53, 54, and 60.

Well, I've completed rebuilding the design sequence and tested using Joe Fugate's article "A MT: Starship Design Example" in the Travellers' Digest #13. The spreadsheet appears to work, but I found some eratta that threw off the numbers. However, there is one area I've not got a handle on which is needed for the Technical Readout. How can I create an automated process for determining the UCP Factors for the Turret Weapons on pp. 73 and 74.


Since I haven't figured out how to automate the Turret Weapon UCP Factor, I moved on to the Design Evaluation section (MT: Referee's Manual pp. 84-89). This has led me to another item I can't seem to get a handle on, which is determining the speed for an airframe hull through a thin atmosphere using the information on p. 86. Here are the numbers I have been working with:

2G Maneuver Drive = Top Vacuum Speed 2,120 (kph)
Hull configuration Needle/Wedge Air Frame (AF)
Standard Atmosphere Top Speed for an AF =
Top Vacuum Speed x 90%

2,120 x .9 = 1,908 kph.

Thin atmosphere speed, p. 86 Column 2 second line from the bottom states speed is 1.5 x Standard Atmosphere.

1,908 * 1.5 = 2,862 kph.

How can the thin atmosphere be faster than the speed in a vacuum?

 

[snrdg082102]

Hello all,

I mentioned in another post that I've been working on an Excel spreadsheet for the design sequence in the MT: Referee's manual and for the 3 part Wet Navy article in Challenge 53, 54, and 60.

Well, I've completed rebuilding the design sequence and tested using Joe Fugate's article "A MT: Starship Design Example" in the Travellers' Digest #13. The spreadsheet appears to work, but I found some eratta that threw off the numbers. However, there is one area I've not got a handle on which is needed for the Technical Readout. How can I create an automated process for determining the UCP Factors for the Turret Weapons on pp. 73 and 74.


Since I haven't figured out how to automate the Turret Weapon UCP Factor, I moved on to the Design Evaluation section (MT: Referee's Manual pp. 84-89). This has led me to another item I can't seem to get a handle on, which is determining the speed for an airframe hull through a thin atmosphere using the information on p. 86. Here are the numbers I have been working with:

2G Maneuver Drive = Top Vacuum Speed 2,120 (kph)
Hull configuration Needle/Wedge Air Frame (AF)
Standard Atmosphere Top Speed for an AF =
Top Vacuum Speed x 90%

2,120 x .9 = 1,908 kph.

Thin atmosphere speed, p. 86 Column 2 second line from the bottom states speed is 1.5 x Standard Atmosphere.

1,908 * 1.5 = 2,862 kph.

How can the thin atmosphere be faster than the speed in a vacuum?

 

[aramis]

"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.

 

[aramis]

"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.

 

[aramis]

"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.

 

[snrdg082102]

Hello Aramis,

Thank-you for the reply and help to my questions.

Okay speed is an artificial reference point for game purposes. Using the constants to figure the Atmospheric speeds for a Streamlined hull in the book returns a Thin atmosphere speed between the Vacuum and Standard Atmosphere speeds. Which is what I expected. The Airframe hull in a Thin Atmosphere I would expect to be closer to, but not exceeding the Vacuum speed.

I'll give the Lookup function a try and let you know later.

Thank-you again for your assistance.

Originally posted by Aramis:
"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.

 

[snrdg082102]

Hello Aramis,

Thank-you for the reply and help to my questions.

Okay speed is an artificial reference point for game purposes. Using the constants to figure the Atmospheric speeds for a Streamlined hull in the book returns a Thin atmosphere speed between the Vacuum and Standard Atmosphere speeds. Which is what I expected. The Airframe hull in a Thin Atmosphere I would expect to be closer to, but not exceeding the Vacuum speed.

I'll give the Lookup function a try and let you know later.

Thank-you again for your assistance.

Originally posted by Aramis:
"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.

 

[snrdg082102]

Hello Aramis,

Thank-you for the reply and help to my questions.

Okay speed is an artificial reference point for game purposes. Using the constants to figure the Atmospheric speeds for a Streamlined hull in the book returns a Thin atmosphere speed between the Vacuum and Standard Atmosphere speeds. Which is what I expected. The Airframe hull in a Thin Atmosphere I would expect to be closer to, but not exceeding the Vacuum speed.

I'll give the Lookup function a try and let you know later.

Thank-you again for your assistance.

Originally posted by Aramis:
"Vaccum speed" is not actually a speed limit, just an artificial reference point.

Automating UCP's:
depends upon which spreadsheet. However, using appleworks (similar syntax to excell, but not identical):
=LOOKUP(B1,F1..F18,E1..E18)
looks for B1 in range F1...F18, then returns a parallel result from cell offset in the range E1...E18.
by changing the "F" cells to "G" cells, you lookup for a different pattern.

Appleworks, Lotus 123, and Excell all have similar feature and syntax.