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.

Lomn's Shipyard Spreadsheet updated to 1.2

Postby Cralis on Wed 23 Jul 2014 01:34

Lomn has updated his Solar Shipyard Spreadsheet to version 1.2

Changelog for Solar Shipyard v1.2

Bug fixes from SSY v1.1:
* various cost / HS errors in system list corrected.
* non-ship systems now report as an error if in the component string
* shield and armor layering now report as errors
* (AC) and (AD) now report errors if tied to the wrong engine types
* PDC/AF spurious shield errors corrected
* PDCs no longer require Q
* Z now reports an error if placed internally
* Xc now correctly limits SP generation on undersized hulls
* %Hull-sized systems (i.e. J'Rill) now supported.
* Empty HS now require Q
* (Wj) costs now doubled for transit carriers

Feature enhancements from SSY v1.1:
* added support for facilities in units. Use codes found in AppAA.FAC.
* added field for Networked Multiplex as a unit upgrade
* added field for noting Lnk level available to unit
* added support for A.02 / S.02 armor/shield type mixing optional rules
* added support for multiplication symbol as quantity separator (improved readability)
* added support for spacing between systems in the component string (improved readability)
* Output Sheet and export file unit stat blocks more closely match the example from the rules

You can get it in the downloads section, or click http://www.starfiredesign.com/starfire/ ... .php?id=72
Image
User avatar
Cralis
SDS Member
SDS Member
 
Posts: 10197
Joined: Tue 30 Jun 2009 19:27
Location: Oregon, USA

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Wed 23 Jul 2014 07:30

Particularly, I'm pleased with that last bullet, which brings the auto-generated Control Sheet nearly in line with the examples in A4, as illustrated below.

Shipyard v1.1:
Code: Select all
Example-class CAtb
[2] S1x7A1x6ZaMgtQax3Rbx2Mgx2(Ibx2)Rbx2(Ibx2)(Bsa)YaRbx2Da(Ibx2)HQbRbx2Dax2Rbx2(Ibx2)Fa [4/2]
Cost: 1524.1 / 228.7     HS: 67 / TS: 56     63 HTK

Shipyard v1.2:
Code: Select all
Example-class CAtb    (AC) (AM2) (Wja) 10-(XOb)      67 HS / 56 TS
[2] S1×7 A1×6 Za Mgt Qa×3 Rb×2 Mg×2 (Ib×2) Rb×2 (Ib×2) (Bsa) Ya Rb×2 Da (Ib×2) H Qb Rb×2 Da×2 Rb×2 (Ib×2) Fa  [4/2]
Trg: 1     Def: 0     Cost: 1524.1 / 228.7
63 HTK (Thick)     S×7 A×6 D×3      SRW×1 LRW×10 (234 MSP)
Same unit - that's a 1.2 import of the 1.1 export with no further changes, except now all the data is there :!:
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 501
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Xveers on Wed 23 Jul 2014 18:14

Praise be to Lomn!

Hrm.

That sounds a lot better the more I say it...

Ready the cannon for the canonization ceremony!
Xveers
Vice Admiral
Vice Admiral
 
Posts: 725
Joined: Wed 15 Jul 2009 02:26
Location: New Westminster, BC, Canada

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Moonsword on Sun 28 Sep 2014 12:30

I'm seeing an import error with version 1.2 on Windows 8.1 using Excel 2013:

Run-time error '1004':

The cell or chart you're attempting to change is on a protected sheet.

To make changes, click Unprotect Sheet in the Review tab (you might need a password).


The same computer has no issues importing with version 1.1.

Code: Select all
FT0-H-class FT0
Generated by Solar Shipyard v1.2
________________________________
FT0-H-class FT0    (AC)      7 HS / 5 TS
[2] Hb H×3 (Ica) Qa  [4/4]
Trg: 1     Def: 0     Cost: 38.3 / 2.9
3 HTK         
---------------------------------
Class Name: FT0-H
Fleet Name: Generic
Hull Symbol: FT0
Hull Speed Modification: Normal
Hull Generation Modification: Alpha
Hull Strength Modification: None
Hull Atmospheric Capability: (AC)
---------------------------------
Primary Engine Type: Ic
Primary Engine Generation: a
Advanced Maneuvering Modification:
Warp Jump Modification:
Secondary Engine In Use: No
Secondary Engine Type: Ic
Secondary Engine Generation: a
Intrinsic Sensor Capability: ssSL0
Network Multi-Targeting:
Linked Weapon Targeting:
---------------------------------
XO Rack Generation: (XOa)
XO Rack Quantity: 0
XOL Rack Generation: (XOLa)
XOL Rack Quantity: 0
---------------------------------
LRW Twig - HAWK:
LRW Twig - EM:
LRW Twig - Booster:
LRW Twig - HARM:
LRW Twig - Laser Warhead: Yes
LRW Twig - Multiple Warhead: No
LRW Twig - Anti-Fighter Warhead:
---------------------------------
Use System Size Rounding: Yes
Max S/A Gen Developed: 1
Sort by Order Column: Yes
Max # of Systems before Condensing: 1
System Multiple Character: ×
Expanded System Listing: Yes
S/A Type Mixing: No
Display Maintenance Alert: No
Allow Mil Sys on FT Colliers:
---------------------------------
System List: SysCode xQty / Order
S x / -2
A x / -1
Za x / 0
Qa x1 / 500
Ica x1 / 490
Ica x0 / 480
Ica x0 / 470
Ica x0 / 460
Hb x1 / 10
H x3 / 20
---------------------------------
Exported Sunday, September 28, 2014
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 28 Sep 2014 13:23

Easiest way to fix/diagnose is to disable cell protection (review tab) and then re-import.

If everything is in the right place, the fault is in the protection ranges.
If a parameter (most likely something like S/A generation) is in the wrong place, the bug is in my import code.

I'll take a better look once I'm done moonlighting as a pastor's wife today.
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 501
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Sun 28 Sep 2014 14:21

Blarg. So, here's what's going on. I've got a work-in-progress setting based on rules conversations elsewhere and possible future functionality, but I disable it for the public release (since, at this point, it's just a house rule) -- but I leave it active in the code so that I can easily flip it on if it goes live in the next release. That's the mystery parameter that's breaking.

So, to fix it, you can just go to the Review tab and select "Unprotect Sheet", which will allow the import macro to write blank data to the correct space (which is the empty line under "Show Maintenance Alert" in the Settings box).

To do a full fix, do the above, then select "Allow Users to Edit Ranges" on that same review tab. Scroll through the list to "UserShipyardSettings" ($R$56:$R$61) and hit Modify, change "Refers to cells:" from "=$R$56:$R$61" to "=$R$56:$R$62" (you'll notice that the cell under the "Show Maintenance Alert" selection is now in that selection box). Hit OK, then OK again, then you can hit Protect Sheet so that you can't accidentally mess with other things.

Or just run with Protect Sheet off and don't delete the data output lines.
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 501
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Moonsword on Mon 29 Sep 2014 15:28

That did it, thanks!
Moonsword
Commander
Commander
 
Posts: 135
Joined: Sat 14 Sep 2013 01:07

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby olivertheorem on Fri 03 Oct 2014 19:21

Finally got a chance to try this out. Great work, Lomn!

I was wondering, though, how much work it would be to add a couple fields to account for racial bonuses/penalties that impact construction and/or maintenance costs. Could default to 0% and have a drop-down with the possibilities from section K. Just a thought.

Edit: I was running it in OpenOffice 3.3 (which might not technically be supported I think), and whenever I tried to shrink the window the program would crash. Wasn't such a big deal, really, but just seemed weird.
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 Fri 03 Oct 2014 20:53

Maintenance is simple, because that's a true value adjustment. Construction is tougher because it affects the price paid for the unit but not its list cost (thus maintenance isn't discounted), plus a couple of other cascading effects. So it's backend tracking and proper situational usage of an extra cost value, plus a non-confusing front-end presentation of the extra cost value.
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 501
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Re: Lomn's Shipyard Spreadsheet updated to 1.2

Postby Lomn on Mon 06 Oct 2014 12:11

So, a question on usability: is anyone finding that some data cells don't have a dropdown menu available? In particular, something like the XO rack generation or the Advanced Maneuvering box?

I've got one computer that strips out a certain class of dropdowns when I give it a file to test, and to date, I've been assuming that it's just a quirk of that particular computer. But if my assumption is wrong, and it's a flaw that other people are seeing, I can sacrifice some design elegance for usability.

Technical info, for the interested and/or bored: dropdowns like XO or (AM) have their list of acceptable values defined by a link to the hidden table that lists all of the systems; that link is being deleted when I port the file to the particular computer. Other dropdowns, like many of the "Yes/No" boxes, are defined as a static list of values; these are retained. So I can just type all of the acceptable XO racks in as a static list and the XO dropdown will always be there, but then I have to maintain that list as well as the system table.
User avatar
Lomn
Vice Admiral
Vice Admiral
 
Posts: 501
Joined: Tue 30 Oct 2012 08:19
Location: MSFC, Alabama

Next

Return to Solar Starfire

Who is online

Users browsing this forum: No registered users and 6 guests