Welcome to the new Majestic Twelve Games Forum!

2008-02-20 02:56:45

Cepheus wrote:

Thanks those were the guestimates I was using as well.... and for assault I was guessing 80 Transport and 40 Cargo, while You get 1 Military Supply point per 100 SU of Cargo, so 1000 Cargo = Supply (1) Sound right to you?
Obviously cargo has to designated for each individual use so for instance if you had a ship that was Cargo 300 Hospital 100 It would be Supply (1), Hospital Ship, not Supply (3) Hospital Ship

I can see that lumping cargo together is going to cause some problems. Therefore I have split Cargo into Cargo, Cargo (Medical) and Cargo (Military) in Shipyard 3.1.
Requirement for supply is that the ship is a Military Supply ship, Hyperdrive + 10 x Military cargo Bays (= Cargo (Military) 1000). See VBAM:SE 2.7.2.2
1 x Supply per 1000 Cargo (Military).
Assault requires Vehicles 100 and Troops 80. It is also stated that the ship should be Atmosphere capable in VBAM Stars Divided.

Paul

2008-02-18 04:52:52

Cepheus wrote:

:shock:
That is where I thought it was but I need an engineering degree to figure out the excel sheet
Can you just give me the formula you used to create scout(1) Scout(2), command and hospital to start with?

HI,
Same as in VBAM Starmada Ed.

Scout 1= EWS x1, Science x100 (same as 10 labs), LRSx1
Scout 2= EWS x1, Science x200 (same as 20 labs), LRS x2

Command= Command Centre in equipment

Hospital= Cargo x200, Hospital x100 (same as 10 Medical Bays.)

See Starmada X conversion in Starmada AE core rules.

New version 3.0 being posted in a few minutes.
Also a How to pdf which might help.

Paul

2008-02-18 04:49:07

jskinny wrote:

Oldngrey,
I've been playing round with the Shipyard for Admiralty ISS Ed all
evening and I've been getting two strange errors. The first are
numbers reading as text which I've been able to correct. The second,
on the template, is an #N/A which is telling me there is "value not
avavailable error". Any ideas on a fix?
Thanks

Some numbers read as text for a reason, they are. Strange things spreadsheets, sometimes they do not like numbers as numbers.
Where do you get the #N/A and is it after entering something?
There are some error signs that I cannot duplicate due to the number of different excel spreadsheet types. The latest seems to play havok with the shipyard.
Paul

2008-02-18 04:42:00

jimbeau wrote:

When I enter a number into the # arcs for the weapons it says
The value to enter must be between 0 and =$AB$29
Mac OS X Excel 2004 for Mac version 11.3.7 (070724)
Sheet Version 2.6
Also, the Drake Notation is not correct, it should read
10/20/30, 1/2+/1/3
Piercing
Finally, maybe there could be a manual written on how to use this, I am still baffled by it.

I do not know how but I just tried and got an invalid entry putting in a number??? Change the green ARC cells to text format.
Did not pick that up as AE only has letter ARCs.
I have changed the Drake notation.
OK something of a manual now on Yahoo, best I could do in a few hours.

New version shipyard in a few minutes.
Combo drop downs fixed.

Paul

2008-02-17 00:23:24

The Yahoo group is mj12games.
The Shipyard AE can be found at:-
http://games.groups.yahoo.com/group/mj12games/files/Shipyard%20for%20Starmada%20AE/

Paul

2008-02-15 23:12:59

Just a note. v2.6 posted. Few minor changes. see notes on fighters & shuttles.
That should be it until the next AE addition.
Paul

2008-02-15 18:44:44

The base calcs (as were the Starmada X version) in the shipyard came from the VBAM Starmada edition.

The fighters sheet became the small craft sheet.
I have put the basic VBAM specific fighters, bombers and shuttlecraft on this. The jump capable are now Independent (FTL).

Starmada fighters convert to VBAM flights on SU cost. If you use Atmospheric fighters add this to the traits list for the correct costing.
Will probably add this change along with Shadow to v2.6. The stats are there, just need adding to the traits.

Hope this helps

Paul

2008-02-14 22:56:30

Check out the shipyard AE. Has VBAM stats included. Should do until something "official" is decided on. Much the same as the Starmada X VBAM conversion.
I have left in some VBAM specific items just for the conversion.

Latest version on Yahoo group is 2.5
Paul

2008-02-07 02:25:34

cricket wrote:

OldnGrey wrote:
Oh No! Have you been got at by Ga**s Works**p?
Will it mean a Starmada Dwarf each month?
Is it a ploy to sell the rules in bits?
Sheesh... Don't publish anything, they complain there's no support.
Publish many things, they complain the rules are being sold in bits.
Can't win.

Wot? Complain? Nah, just a horrible thought. Seen SFB become an overblown (mainly because if you do this i'll do that etc. etc. etc.) lawyer's paradise. And I am sure that life was much simpler when GW was just Citadel miniatures. In those days you even got a prezzie if you bought so many figures a year (still got my Citadel mug!)

Of course you did not have to mention another supplement with the ink not dry yet on the last.

Paul

2008-02-05 12:06:04

[quote="cricket
If, however, it's just a question of "feel", then there are other options for fighters -- one of which you will see in an upcoming supplement...

Oh No! Have you been got at by Ga**s Works**p?
Will it mean a Starmada Dwarf each month?
Is it a ploy to sell the rules in bits?
Will Batman and Robin be dashed to death?
Tune in next week, same time same channel!

2008-02-03 18:09:14

The Shipyard can be found at:
http://games.groups.yahoo.com/group/mj12games/files/Shipyard%20for%20Starmada%20AE/

Latest version 2.4

Paul

2008-02-03 03:20:57

I just tested both the Shipbuilder and the Shipyard.

It is possible to cut and paste all of the text in one go by selecting all of the text cells at the same time.
ie
Type: Her Maj's Space Sphere Bedford, Cavor Class, Imperial England Space Ball (9)
Hull: 1
Engines: [TL0] 2
Weapons
Battery X: Elephant Gun (K) TL0 [1/2/3, 5+, ROF:1 IMP:1 DMG:1, Non–Piercing ] Ammo:(4)
ABCDEF
Special Equipment
Armor Plating Cargo (10) :
Weapons :1[X], 2[X], 3[X], 4[X], 5[X], 6[X]

OK, I left some space to tidy up the text On the Shipyard sheet before printing or transferring as a block of text. However, this was all cut and pasted into notepad in one go.

Putting it all into one cell is thankfully not needed. It would be a hell of a job to sort out if changes were needed.

Paul

2008-02-03 00:36:25

The shipyard has had a sheet for fighters for quite a while.
Since AE has included Seekers/Strikers/Boarding Pods etc.
Also on mj12 Yahoo group.

2008-02-03 00:31:49

Had to laugh at that vision.

Have done a bit of a re-write to the Small Craft sheet, VBAM customized flights off the peg. I wanted shuttles so these are a choice also.
VBAM stats for Starmada type fighters depend on SU cost/resulting weight class.
Changes made as some things like speed are already factored into the SU without making a Fast/Slow choice.

Version 2.4 posted

2008-01-27 14:08:13

Hi Steven,
The Tech Range is On the Tables sheet cell C1.
To stay within the rules, this number should not be less than the tech levels used in the ship design. This should be decided Before designing the ship.
Other than that change the ship design?

Paul

2008-01-26 02:58:15

Hi lamont,
Template cell AI6 should not be used now, my mistake, Screens should now be entered in Template G9 as the actual number required.
By making this change I should have changed Template cell AM7 to:
=+IF($G$8="KEB";$AI$7/3;$AI$7)

Hi Steven,
The mj12games ship designer has the Tech Range set at 2 (This is above the cells for Tech levels). This means that the Max Tech levels are +2 to -2. When you entered the +3 tech levels you multiplied the SU required by 0.35 instead of the rules max of 0.5 (If you highlight the cells to the right of the tech levels and change the ink colour you will be able to see this.)
You have to choose the tech range that you will be using first (core rules page 42.)
I had the Shipyard set at a tech range of 5 to give everyone an even playing field but I have enabled this to be changed should a group want to design ships with a different range.

Thanks for the feed back. version 2.3 should clear up this glitch.
Paul

2008-01-25 22:35:59

If you use the Ammo option you may wish to enter the following so that it is on par with the Shipbuilder. To save you downloading yet another version.
Enter these on Version 2.2 Template sheet.

Cell AR8:
=IF($E$20="Yes";ROUNDUP((ROUNDUP($AN$8*$AP$8;0)*$AM$8*($M$20+$AU$91))/(10*$AU$91);0);(ROUNDUP($AN$8*$AP$8;0)*$AM8))
Cell AR9:
=IF($E$28="Yes";ROUNDUP((ROUNDUP($AN$9*$AP$9;0)*$AM$9*($M$28+$AU$92))/(10*$AU$92);0);(ROUNDUP($AN$9*$AP$9;0)*$AM$9))
Cell AR10:
=IF($E$36="Yes";ROUNDUP((ROUNDUP($AN$10*$AP$10;0)*$AM$10*($M$36+$AU$93))/(10*$AU$93);0);(ROUNDUP($AN$10*$AP$10;0)*$AM$10))
Cell AR11:
=IF($E$44="Yes";ROUNDUP((ROUNDUP($AN$11*$AP$11;0)*$AM$11*($M$44+$AU$94))/(10*$AU$94);0);(ROUNDUP($AN$11*$AP$11;0)*$AM$11))
Cell AR12:
=IF($E$52="Yes";ROUNDUP((ROUNDUP($AN$12*$AP$12;0)*$AM$12*($M$52+$AU$95))/(10*$AU$95);0);(ROUNDUP($AN$12*$AP$12;0)*$AM$12))

Version 2.3 will have these entered.
Paul

2008-01-25 22:28:42

Yup, Thanks

2008-01-25 00:54:29

Ok Ta.

Could you please give some idea of the thought behind Ammo?

Perhaps if the weapons were treated as launchers instead of individual weapons?

Maybe one calc for the shots based on the basic SU (number x a percentage?) x Another for the number of launchers and arcs?

Just a thought.

Paul

2008-01-24 23:01:58

edplancer wrote:

The weapon SU calculations seem to very messed up. :?
It seems like the only battery that is correctly figuring SUs is the X battery. I don't think it's me this time The X Battery seems to be doing everything as it should when double checked with a calculator, but the other batteres are giving me yuck.
Erik

Where exactly are you getting yuck? Please give shipyard version, sheet and cell. And why? Are you using Ammo?

Hi lamont,
There may be a small difference due to the way that Shipbuilder calculates the weapon Orat. as well as Roundups. Should not be very much though.

Thanks to all for the feed back.
Please note version 2.2 posted now.
Updated with Core revision 1.0

2008-01-24 22:12:00

[quote="cricket

The Ammo/Battery calculations (ie cell J19) appear to differ from the ISS rules.

Yeah, that should not have been included. There is a problem with the current ammo calculation -- essentially, the number of weapons does not affect the final SU cost, only the amount of ammo.

However, the "fix" has not yet been finalized...

I did notice that.

Have you noticed that when you divide the SU by the Tech mod for the ORAT ie cell G20. This is using a SU which has been Rounded up instead of the basic total SU?

Paul

2008-01-24 21:56:49

Aaaargh!

2008-01-24 06:00:05

Hi Dan,
Just been looking at your Shipbuilder 2.1
Did you forget to change Increased Damage to Increased Impact?
Area Effect, Double Range Mods and Piercing have slightly different mods to the rules.
The Ammo/Battery calculations (ie cell J19) appear to differ from the ISS rules.
You appear to have Battery SU x (No. of weapons + Ammo) / 10 x No. of weapons.
Instead of Battery SU x Ammo / 5 x No. of weapons.

Paul

2008-01-24 05:18:52

Hi Steve
Been number crunching using Shipbuilder 2.1.
The only way it seems that you can come to your numbers is if you left the Tech Range at 2, thereby getting around the Max TL mod of 0.5.
By not changing the range to the maximum levels that you used (3) you got a mod of 0.35 for engines and weapons.
This makes a fair difference!

The shipyard has always been set at a +-5 range. I may make this variable as in the Shipbuilder but as you can see, If people use different Tech Ranges the ship construction will not be consistant.

Paul

2008-01-23 23:01:09

Hi Steven,
I think you may need to look at your design again.
Engines 8 x Engine factor 575 takes up 4,600 SU!
However I have put your ship in the template of the latest version of the shipyard so that you can see the calculations and how they have been entered.

Hi Erik,
Some part of that may have been due to Starmada X calcs I missed.
With the calculations in ISS page12 the total SU depends on the number of Shots and the basic SU. No matter how many weapons there are in the battery you still only get x number of shots.

Sorry everyone, I made an Oops. Left in some old calcs which messed up the weapon SU figures. Corrected now in Version 2.1 of the shipyard.

Paul

Welcome to the new Majestic Twelve Games Forum!

Search options (Page 27 of 32)

Posts found: 651 to 675 of 786

651 Reply by OldnGrey 2008-02-20 02:56:45

Re: Vbam/Campaigns (16 replies, posted in Starmada)

652 Reply by OldnGrey 2008-02-18 04:52:52

Re: Vbam/Campaigns (16 replies, posted in Starmada)

653 Reply by OldnGrey 2008-02-18 04:49:07

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

654 Reply by OldnGrey 2008-02-18 04:42:00

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

655 Reply by OldnGrey 2008-02-17 00:23:24

Re: Vbam/Campaigns (16 replies, posted in Starmada)

656 Reply by OldnGrey 2008-02-15 23:12:59

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

657 Reply by OldnGrey 2008-02-15 18:44:44

Re: Vbam/Campaigns (16 replies, posted in Starmada)

658 Reply by OldnGrey 2008-02-14 22:56:30

Re: Vbam/Campaigns (16 replies, posted in Starmada)

659 Reply by OldnGrey 2008-02-07 02:25:34

Re: Aegis Systems (27 replies, posted in Starmada)

660 Reply by OldnGrey 2008-02-05 12:06:04

Re: Aegis Systems (27 replies, posted in Starmada)

661 Reply by OldnGrey 2008-02-03 18:09:14

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

662 Reply by OldnGrey 2008-02-03 03:20:57

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

663 Reply by OldnGrey 2008-02-03 00:36:25

Re: Starmada AE questions (7 replies, posted in Starmada)

664 Reply by OldnGrey 2008-02-03 00:31:49

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

665 Reply by OldnGrey 2008-01-27 14:08:13

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

666 Reply by OldnGrey 2008-01-26 02:58:15

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

667 Reply by OldnGrey 2008-01-25 22:35:59

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

668 Reply by OldnGrey 2008-01-25 22:28:42

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

669 Reply by OldnGrey 2008-01-25 00:54:29

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

670 Reply by OldnGrey 2008-01-24 23:01:58

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

671 Reply by OldnGrey 2008-01-24 22:12:00

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

672 Reply by OldnGrey 2008-01-24 21:56:49

Re: Admiralty Revisions Summary (5 replies, posted in Starmada)

673 Reply by OldnGrey 2008-01-24 06:00:05

Re: Starmada:Admiralty Shipbuilder (166 replies, posted in Starmada)

674 Reply by OldnGrey 2008-01-24 05:18:52

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

675 Reply by OldnGrey 2008-01-23 23:01:09

Re: Shipyard for Admiralty ISS Ed (46 replies, posted in Starmada)

Posts found: 651 to 675 of 786