11-27-2010, 06:31 PM | #141 |
Custom User Title
Join Date: Oct 2007
Location: Indianapolis, IN
|
Re: GURPS Spaceships Design Spreadsheet
Can't you use a recap sheet to capture the info in the cells that you want and then print that? You may need to go to the trouble of copying and pasting 'as value' but it should work. Been a while since I opened that up so maybe not.
__________________
Joseph Paul |
11-27-2010, 07:39 PM | #142 | |
Join Date: Jul 2005
Location: Jeffersonville, Ind.
|
Re: GURPS Spaceships Design Spreadsheet
I know so little about Excel that when I've been posed questions about it for a school project I passed them along to another team member at risk of a lower grade for myself. (I'd rather admit ignorance than fake knowledge I don't have, especially when other people involved are knowledgeable.) The last time I took a class in Excel, Excel 97 was a pretty new thing.
__________________
The user formerly known as ciaran_skye. __________________ Quirks: Doesn't proofread forum posts before clicking "Submit". [-1] Quote:
Last edited by panton41; 11-27-2010 at 07:47 PM. |
|
11-27-2010, 08:08 PM | #143 |
Custom User Title
Join Date: Oct 2007
Location: Indianapolis, IN
|
Re: GURPS Spaceships Design Spreadsheet
In Excel you would create a second Worksheet in the same Workbook. Rename it Output or Print Version etc. To automatically get info from the Spaceships Design Spreadsheet you would use this format on the Output Worksheet -'name of first sheet!'cell reference. Cell References are usually in Column/Row format. So - (Spaceships!A1) returns the displayed value in A1 on the Spaceships sheet. This allows you reposition the output data anyway that you want.
Haven't opened OO's spread sheet in a long time but I can't imagine that you can't make such a recap sheet in it. Sorry to be off topic here but I think it would be helpful to people that are trying to get a handle on their output.
__________________
Joseph Paul Last edited by Joseph Paul; 11-28-2010 at 10:49 PM. Reason: Egregious syntax error in Excel instructions |
11-27-2010, 08:37 PM | #144 | ||
Join Date: Jul 2005
Location: Jeffersonville, Ind.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
__________________
The user formerly known as ciaran_skye. __________________ Quirks: Doesn't proofread forum posts before clicking "Submit". [-1] Quote:
|
||
11-27-2010, 09:03 PM | #145 |
Custom User Title
Join Date: Oct 2007
Location: Indianapolis, IN
|
Re: GURPS Spaceships Design Spreadsheet
To each his own - and before I get blasted it looks like it is 'name of sheet!'cell ref. Single quotes not parantheses. Oops.
__________________
Joseph Paul |
11-28-2010, 08:18 PM | #146 | |||||
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
A lot of points to hit here. Hopefully I don't miss anything important. One thing I will note right now is that I'm in school and finals are coming up. I may try to tackle some of this stuff during Christmas Break, but there's no way I can hit it before.
Quote:
Quote:
Quote:
Quote:
Quote:
Actually, creating a separate worksheet for each ship which is a little more printer friendly might not be a bad addition. I'll think about it. As an aside, are you using MSOffice or OpenOffice? The "Hide Unused Rows" checkbox makes the printout a lot cleaner, but relies on the core Macro to hide/unhide the rows.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|||||
11-28-2010, 11:46 PM | #147 | |
Join Date: Jul 2005
Location: Jeffersonville, Ind.
|
Re: GURPS Spaceships Design Spreadsheet
Usually MS Office. The only time I use OOo is on a netbook and the sheet has some problems on such a small screen using it.
__________________
The user formerly known as ciaran_skye. __________________ Quirks: Doesn't proofread forum posts before clicking "Submit". [-1] Quote:
|
|
11-29-2010, 08:23 AM | #148 | ||
Join Date: Oct 2004
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
This would take care of a lot of stuff and add in some flexibility for people (like me, I guess) who might have custom weapons, and actually custom engines. Converting a ship from Vehicles 3rd ed to SS can be a brutal cutting process... making my ships complex to the point of near unmanageably was one of my favorite things about the old system ;) Quote:
That all said, you've done so much that I always feel bad for asking for a feature. |
||
11-29-2010, 11:25 PM | #149 |
Join Date: Dec 2006
Location: Meifumado
|
Re: GURPS Spaceships Design Spreadsheet
Just to let you know, if you're running this on Excel, it's actually fairly easy to add some user-created systems without breaking the program. Just make sure to save your edited version under a different name first, then poke around in the hidden worksheets.
__________________
Collaborative Settings: Cyberpunk: Duopoly Nation Space Opera: Behind the King's Eclipse And heaps of forum collabs, 30+ and counting! |
01-06-2011, 08:26 AM | #150 |
GURPS FAQ Keeper
Join Date: Mar 2006
Location: Kyïv, Ukraine
|
Re: GURPS Spaceships Design Spreadsheet
Some questions:
|
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
Thread Tools | |
Display Modes | |
|
|