Lomn's Shipyard Spreadsheet updated to 1.2

Home of SOLAR STARFIRE, 6th edition, rules based on the upcoming history of the Terran Solar Union.

Moderators: SDS Members, SDS Owner

Forum rules
1. Nothing obscene.
2. No advertising or spamming.
3. No personal information. Mostly aimed at the posting of OTHER people's information.
4. No flame wars. We encourage debate, but it becomes a flame when insults fly and tempers flare.

Try to stick with the forum's topic. Threads that belong to another forum will be moved to that forum.

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Moonsword on Mon 06 Oct 2014 14:33

I haven't noticed that on either Windows 7 or Windows 8.1 running Excel 2013.
Moonsword
Commander
Commander
 
Posts: 135
Joined: Sat 14 Sep 2013 01:07

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Whitecold on Wed 08 Oct 2014 10:24

Attempting to open the spreadsheet with macros enabled gives me an error:
Compile Error, Can't find project or library
and points me to
Function SystemSize(RawHS, SAGen) As Double
Whitecold
Rear Admiral
Rear Admiral
 
Posts: 441
Joined: Fri 19 Sep 2014 15:03

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Wed 08 Oct 2014 15:02

Whitecold wrote:Attempting to open the spreadsheet with macros enabled gives me an error:
Compile Error, Can't find project or library
and points me to
Function SystemSize(RawHS, SAGen) As Double

Odd. I've found the following suggestion on the the MS tech support pages:

Most likely, the application has lost the reference to an object or type library resulting in the above error when using Barcode Macros & Native VBA Functions. The problem may be resolved as follows:

1. Open the application.

2. Press ALT+F11 to switch to the Visual Basic Editor.

3. On the Tools menu, click References.

4. Clear the check box for the type library or object library marked as "Missing:"
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 500
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Whitecold on Thu 09 Oct 2014 09:29

It seems to have solved the issue of the file not starting, but Import and Export don't work. I get now an User-defined type not defined.
I'm under MS office 2011 for mac
Whitecold
Rear Admiral
Rear Admiral
 
Posts: 441
Joined: Fri 19 Sep 2014 15:03

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Thu 09 Oct 2014 10:17

The issue, apparently, is that Office for Mac doesn't support the FileSystemObject calls that Import and Export use to read and write files (that's what's coming up as a "user-defined type", as I'm not otherwise defining any types). I'll start tinkering with some of the code advice for cross-platform file operations.
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 500
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Moonsword on Sun 12 Oct 2014 11:36

I'm getting a price of 443.4 from the spreadsheet on the following design:

Code: Select all
Aswan-class DDf        30 HS / 18 TS
[2] (MNE)×2 Xp (1) (Ic) @×5 Qa×2 (Ic) (Ic) (Ic)  [4/4]
Trg: 1                Def: 0                      Cost: 433.0 / 65.0    SL 1
15 HTK


I got the design from here and my own calculations match the price, so I'm not sure where the difference is coming from.
Moonsword
Commander
Commander
 
Posts: 135
Joined: Sat 14 Sep 2013 01:07

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Sun 12 Oct 2014 13:09

Ah, found it. The 443.4 version is with (AC). (the extra 10.4 MCr is 5% of the 207 MCr hull cost).
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 500
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby olivertheorem on Sun 12 Oct 2014 13:39

Yeah, I had to redo several designs the first couple times I used it as I didn't realize it was set to include (AC) on the default/example design. Not a big difference, but every MCr counts.
olivertheorem
Rear Admiral
Rear Admiral
 
Posts: 294
Joined: Tue 11 Jun 2013 02:41
Location: Austin, TX

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Sun 12 Oct 2014 15:31

That's a good point. I'll see about adding an output line in the cost area that shows the cost of all installed whole-ship systems, which should help people see when they're getting an unexpected cost from a dropdown box somewhere.

(The example unit has (AC) mostly to illustrate the option -- it's got those LRW Twig selections for the same reason)
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 500
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby olivertheorem on Sun 12 Oct 2014 19:02

I figured something like that. I just overlooked it when clearing the LRW twigs.

Would it be possible to add a "reset" button of sorts that blanks everything but (maybe) the engine settings? Random thought.
olivertheorem
Rear Admiral
Rear Admiral
 
Posts: 294
Joined: Tue 11 Jun 2013 02:41
Location: Austin, TX

PreviousNext

Return to Solar Starfire

Who is online

Users browsing this forum: No registered users and 3 guests