06-14-2010, 12:26 AM | #61 | ||
Join Date: May 2008
Location: CA
|
Re: GURPS Spaceships Design Spreadsheet
Java can parse XML files just fine. It may not have any prebuilt classes for XML parsing, but that doesn't mean much.
Quote:
So, always make ships in 20 systems. If you can fulfill all the requirements for a ship in less, just fill out the rest of the systems with something else - cargo bays work well, since they're free. Quote:
|
||
06-14-2010, 12:56 AM | #62 | |
Join Date: Jul 2005
Location: Jeffersonville, Ind.
|
Re: GURPS Spaceships Design Spreadsheet
Apparently it does in the javax libraries, but I've never used them beyond as a part of Swing. From the way it looks much of what I've learn in the database class is directly applicable. (Heck, I think Java for Dummies even explains it.)
__________________
The user formerly known as ciaran_skye. __________________ Quirks: Doesn't proofread forum posts before clicking "Submit". [-1] Quote:
|
|
06-14-2010, 06:43 AM | #63 |
Join Date: Aug 2004
Location: The ASS of the world, mainly Valencia, Spain (Europe)
|
Re: GURPS Spaceships Design Spreadsheet
While XML is fine and dandy, I personally prefer full fledged databases. SQLite can be used from Java, supports ACID, a big percentage of the SQL standard, and it is fast and small.
|
06-14-2010, 06:52 AM | #64 | ||
Join Date: Jul 2005
Location: Jeffersonville, Ind.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
I would probably use XML with a different extension and, if I can manage it, throw it into a ZIP wrapper if it's worth the effort.
__________________
The user formerly known as ciaran_skye. __________________ Quirks: Doesn't proofread forum posts before clicking "Submit". [-1] Quote:
|
||
06-26-2010, 09:52 PM | #65 | ||
Join Date: Dec 2006
Location: Meifumado
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
Also, I don't know if this is me and my reading comprehension skills or the spreadsheet, but I can't see how the weapon damage values for guns and missiles link to what's in the weapon table on SS1p68, they seem to be lower by a factor of 10 in the spreadsheet. The weapon table shows dDamage, so it's not that. And Lasers list damage type as "burn", when they should have "burn(2)" with the armour divisor. ETA: It's my reading- the errata page says gun/missiles damages have been cut by 1/10- http://www.sjgames.com/errata/gurps/4e/spaceships.html, though it would be nice if the errata page reprinted the whole table with corrections instead of how it's presented now.
__________________
Collaborative Settings: Cyberpunk: Duopoly Nation Space Opera: Behind the King's Eclipse And heaps of forum collabs, 30+ and counting! Last edited by Daigoro; 06-26-2010 at 10:43 PM. |
||
07-28-2010, 05:31 AM | #66 |
Join Date: Oct 2009
|
Re: GURPS Spaceships Design Spreadsheet
Excellent tool, thanks for making it.
One annoying thing: in move, mps is rounded to the nearest whole number, rather than having one decimal point. I've looked around, but most of the necessary cells to fix that are hidden within the sheet, so no such luck. I'd be awesome if you could fix that, or at least give me a hint where to look for a solution. From my experience, it probably stems from a cell formatting issue, but I could very well be wrong. Edit: Footnote numbers do not correspond correctly. Issue occurs in a TL 12^, SM+6, force screened craft. Last edited by Dark_Daemon; 07-28-2010 at 07:00 AM. Reason: another bug |
07-28-2010, 11:44 AM | #67 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Posted version 1.18, hopefully fixing the Footnotes bug and allowing mps to go to three decimals. There were actually several bugs in the footnotes; if you notice any more please let me know.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
07-29-2010, 02:25 AM | #68 |
Join Date: Oct 2009
|
Re: GURPS Spaceships Design Spreadsheet
Any idea on how to easily transfer data from a filled out 1.17 to the empty 1.18? Re-inputing four ship's worth is not appealing.
|
07-31-2010, 11:49 AM | #69 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Unfortunately, there's no easy way of copying the data from one sheet to another. Maybe I'll look into creating a Macro that will handle some of the work, but right now there isn't one.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
07-31-2010, 11:59 AM | #70 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Version 1.19a Posted:
http://gurpsland.no-ip.org/zip/Spaceships119.zip http://gurpsland.no-ip.org/zip/Spaceships119.7z This is a biggie, so I'm considering it a Beta build and posting it separately from v1.18. This update includes: -Full Excel 2007 compatibility (and, presumably, Excel 2003 & 2010) -Preliminary support for Spaceships 7 All the new systems and most of the options from Spaceships 7 are present except for the rules for Smaller Systems. I'm still not sure how exactly I'm implementing those, so they're still on the far back burner. Right now I want to concentrate on fixing any errors in the present systems and ship options, as well as looking over any bugs I may have introduced in adding these systems. I've adjusted the core Macro to fix the compatibility issues with Excel 2007. I still have no idea why the Macro was causing a lockup in Excel 2007 - apparently it was getting stuck in an infinite calculation loop - but I was able to adjust the Macro so that it exists the loop after a single iteration rather than getting stuck in the loop. I also had to create a new Self-Signed Security Certificate for the Macros. This means you will probably be prompted to accept the certificate again. If you want the Macros functionality just say yes.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 07-31-2010 at 12:42 PM. |
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|