• Registered: 2008-01-01
  • Posts: 16

Re: Shipyard for Admiralty Ed.

silly me-

just record a macro that copies the Starmada sheet as a picture, opens a new sheet, and pastes it, as a picture, in the first cell of the new sheet- can even get the macro to name the new sheet from a cell in the Starmada sheet i bet-

lamont

  • Registered: 2007-12-28
  • Posts: 30

Re: Shipyard for Admiralty Ed.

Why I like this tool is that it allows to predefine some waapons or designs (figthers, seekers, etc.) and define factions with their technical levels and so on,

so that when you are creating your own setting or making a conversion of an existing one, you just create necessary weapons and small vessels, and then use them in your spaceships.

I like the idea of integration with VBAM, but I don't use this (yet).

  • Registered: 2005-06-08
  • Posts: 760

Re: Shipyard for Admiralty Ed.

lamont wrote:

with regard to the text vs numerical format issue-

when opened, v1.5 (and earlier) has three weapons built in the Nation sheet; all of the stats for the weapons show normal (no green triangle in upper left corner) and SU calcs are fine--

if I change a number in the ACC column on this sheet (by validation on your dropdown list), a green triangle shows and the cell indicator says it is formatted as text or the number has an apostrophe in front of it-

when I trace the ACC input list to the TO HIT table on the Tables sheet, I find that numbers 1-6 are also marked with green triangles and indicated as TExt formatted (cells B20-B25 on this sheet)- this of course messes up the numerical calculations of SU on the Nations sheet; when I reformat those cells to numerical and reenter the numbers, the green triangles go away everywhere and SU calcs are fine on the NAtion sheet-

I suspect this is just a quirk of Excel 2007 opening your version of the sheet, but others may encounter this if they use Office 2007 as well

I have seen other oddities- I use Visual Basic to display the fire arc images in the battery regions of the Starmada sheet- in Excel 2003, the images would displace up or down a bit in a regular way that depended only on sequence in a given battery- regardless of what I told the system to do in the subroutine; when I upgraded to Office 2007, all images went right where they were supposed to-

lamont                                       
[/img]

Ah, that explains it. Open Office Calc is more forgiving it seems. Little green triangles? Do not get them, although there are some times when text/numerical differences do muck things up.

Talk about not seeing the wood for the trees! I started updating the shipyard to learn about spreadsheets. It must be a couple of years now and it never came to mind to copy the Starmada diagram and paste it on a new sheet as a bitmap!
It does work with Open Office and is easier, Thanks.
And thanks for your solution with regards Excel 2007.

Paul

  • Registered: 2005-06-08
  • Posts: 760

Re: Shipyard for Admiralty Ed.

Tech level option now on everything as per page 42. (except Carrier and launch tubes, Tech level option is on small craft sheet)
Sorry, I thought that this might have been an error.
V1.6 posted soon.