| View previous topic :: View next topic |
| Author |
Message |
Rerun941
Commander
Joined: 27 Jul 2004
Posts: 459
Location: San Antonio, TX
|
 Posted: Wed Mar 30, 2011 3:59 pm Post subject: Starship, Vehicle, Weapon Spreadsheet |
 |
|
I'm in the process of taking Gry's statbooks and putting them into spreadsheet format.
I dunno if other folks have spent hours like I have searching/paging thru the PDFs looking for stuff. But I'm taking the stat blocks and parsing them in a spreadsheet (aka the poor man's database) and making it so you can sort/filter by the different stats.
Would anyone be interested in this when I'm done?
_________________
Han - "How're we doin'?"
Luke - "Same as always."
Han - "That bad, huh?" |
|
| Back to top |
|
 |
Esoomian
High Admiral
Joined: 29 Oct 2003
Posts: 6207
Location: Auckland, New Zealand
|
| Posted: Wed Mar 30, 2011 4:20 pm Post subject: |
|
|
Yes I would.
_________________
Don't waste money on expensive binoculars.
Simply stand closer to the object you wish to view. |
|
| Back to top |
|
|
TyCaine
Captain
Joined: 16 Oct 2009
Posts: 515
Location: Florida, US
|
| Posted: Wed Mar 30, 2011 4:44 pm Post subject: |
|
|
Can I hear a 'hell yeah'?
Would appreciate that very much, love Gry's sourcebook, but something that can be filtered would be great!
T.C. |
|
| Back to top |
|
|
Bren
Vice Admiral
Joined: 19 Aug 2010
Posts: 3868
Location: Maryland, USA
|
| Posted: Wed Mar 30, 2011 4:52 pm Post subject: |
|
|
| Count me third. |
|
| Back to top |
|
|
CRMcNeill
Director of Engineering
Joined: 05 Apr 2010
Posts: 16320
Location: Redding System, California Sector, on the I-5 Hyperspace Route.
|
| Posted: Wed Mar 30, 2011 4:55 pm Post subject: |
|
|
Yes, please.
_________________
"No set of rules can cover every situation. It's expected that you will make up new rules to suit the needs of your game." - The Star Wars Roleplaying Game, 2R&E, pg. 69, WEG, 1996.
The CRMcNeill Stat/Rule Index
|
|
| Back to top |
|
|
vong
Jedi
Joined: 30 Aug 2006
Posts: 6699
Location: Ottawa, Canada
|
| Posted: Wed Mar 30, 2011 5:40 pm Post subject: |
|
|
i will be doign that with my website 
but can use your help getting it into my website!
i was waiting to do this until gry came out with his next version though.
_________________
The Vong have Arrived
PM me if you want user created content uploaded to my site: http://databank.yvong.com/index.php |
|
| Back to top |
|
|
Whill
Dark Lord of the Jedi (Owner/Admin)
Joined: 14 Apr 2008
Posts: 10438
Location: Columbus, Ohio, USA, Earth, The Solar System, The Milky Way Galaxy
|
|
| Back to top |
|
|
Rerun941
Commander
Joined: 27 Jul 2004
Posts: 459
Location: San Antonio, TX
|
| Posted: Thu Mar 31, 2011 9:39 am Post subject: |
|
|
I'm up to the ARC-170... here's a link to the draft:
https://spreadsheets.google.com/ccc?key=0AgRbB64B-3uCdDdJeDN0cDJpeWlPbEpBWkZtVWlMakE&hl=en&authkey=CJCaurMI
Some notes:
The name is the name EXACTLY as it appears in Gry's statbook so the spreadsheet and the statbook can be easily cross-referenced.
Type will be the rough categories as laid out in Gry's statbook (e.g: Starfighter, Freighter, Bulk Freighter, Shuttle, Yacht, etc.)
There are some stats which have had inconsistent values, and I've done what I can to "normalize" those values for better sorting/filtering. (e.g. Corellian Engineering vs. Corellian Engineering Corp, I picked one and went with it.)
I haven't quite figured out how to list the sensors or weapons and retain any degree of sorting/filtering.
Any feedback is appreciated.
_________________
Han - "How're we doin'?"
Luke - "Same as always."
Han - "That bad, huh?" |
|
| Back to top |
|
|
Ankhanu
Vice Admiral
Joined: 13 Oct 2006
Posts: 3089
Location: Nova Scotia, Canada
|
| Posted: Thu Mar 31, 2011 10:42 am Post subject: Re: Starship, Vehicle, Weapon Spreadsheet |
|
|
| Rerun941 wrote: | I'm in the process of taking Gry's statbooks and putting them into spreadsheet format.
I dunno if other folks have spent hours like I have searching/paging thru the PDFs looking for stuff. But I'm taking the stat blocks and parsing them in a spreadsheet (aka the poor man's database) and making it so you can sort/filter by the different stats.
Would anyone be interested in this when I'm done? |
Sure.
If I still had the HDDs I'd built mine on way back in the day (and if those file formats were supported by modern apps), I'd pass them on. Alas, they've been lost to hardware fatigue and a lack of backups, or backups that last longer than a 3.5" floppy
_________________
Hotaru no Hishou; a messageboard about games, friends and nothing at all.
Donate to Ankhanu Press |
|
| Back to top |
|
|
Ankhanu
Vice Admiral
Joined: 13 Oct 2006
Posts: 3089
Location: Nova Scotia, Canada
|
| Posted: Thu Mar 31, 2011 10:45 am Post subject: |
|
|
| Rerun941 wrote: | I'm up to the ARC-170... here's a link to the draft:
https://spreadsheets.google.com/ccc?key=0AgRbB64B-3uCdDdJeDN0cDJpeWlPbEpBWkZtVWlMakE&hl=en&authkey=CJCaurMI
Some notes:
The name is the name EXACTLY as it appears in Gry's statbook so the spreadsheet and the statbook can be easily cross-referenced.
Type will be the rough categories as laid out in Gry's statbook (e.g: Starfighter, Freighter, Bulk Freighter, Shuttle, Yacht, etc.)
There are some stats which have had inconsistent values, and I've done what I can to "normalize" those values for better sorting/filtering. (e.g. Corellian Engineering vs. Corellian Engineering Corp, I picked one and went with it.)
I haven't quite figured out how to list the sensors or weapons and retain any degree of sorting/filtering.
Any feedback is appreciated. |
Good idea.
Really, depending on how you set up your spreadsheet, it could easily be imported into a database.
I'd say for sensors, just list them in separate columns for each mode, C1 - range, C2 - die code. That way you can sort based on each sensor mode for either range or bonus.
_________________
Hotaru no Hishou; a messageboard about games, friends and nothing at all.
Donate to Ankhanu Press |
|
| Back to top |
|
|
Rerun941
Commander
Joined: 27 Jul 2004
Posts: 459
Location: San Antonio, TX
|
| Posted: Thu Mar 31, 2011 3:17 pm Post subject: |
|
|
| Ankhanu wrote: | Good idea.
Really, depending on how you set up your spreadsheet, it could easily be imported into a database.
I'd say for sensors, just list them in separate columns for each mode, C1 - range, C2 - die code. That way you can sort based on each sensor mode for either range or bonus. |
New version posted:
https://spreadsheets.google.com/ccc?key=0AgRbB64B-3uCdC1FQjY3Sm1EdnhQc1JmZkM0X3lwelE&hl=en&authkey=CPiAnbUM#gid=0
I've included your suggestion for Sensors and worked up the Weapons block. It's starting to scroll out to the right a bit far, though.
_________________
Han - "How're we doin'?"
Luke - "Same as always."
Han - "That bad, huh?" |
|
| Back to top |
|
|
Whill
Dark Lord of the Jedi (Owner/Admin)
Joined: 14 Apr 2008
Posts: 10438
Location: Columbus, Ohio, USA, Earth, The Solar System, The Milky Way Galaxy
|
|
| Back to top |
|
|
Azai
Lieutenant Commander
Joined: 05 Jul 2010
Posts: 248
|
| Posted: Tue Apr 05, 2011 7:00 pm Post subject: |
|
|
This make actually kinda be against what the spreadsheet is trying to accomplish.
But maybe to reduce the scroll the spreadsheet is broken up into Eras?
Or maybe large Affiliations(Rebel, Empire) |
|
| Back to top |
|
|
Rerun941
Commander
Joined: 27 Jul 2004
Posts: 459
Location: San Antonio, TX
|
| Posted: Wed Apr 06, 2011 1:10 pm Post subject: |
|
|
112 Starships so far... I'm up to page 54 in the statbook, Alliance Starfighters
https://spreadsheets.google.com/ccc?key=0AgRbB64B-3uCdGREWmpnWDRxTjEwbVQyUHVQOXNmSVE&hl=en&authkey=CMqagOgJ#gid=0
As for limiting the list, I think I'll leave that to the individual. My default list will be the Master list and then folks can filter and save as separate sheets in the workbook. (Believe me, I will be doing that with my own personal copy.)
Once I get done with the Starships, I'll tackle Vehicles and Weapons.
_________________
Han - "How're we doin'?"
Luke - "Same as always."
Han - "That bad, huh?" |
|
| Back to top |
|
|
Whill
Dark Lord of the Jedi (Owner/Admin)
Joined: 14 Apr 2008
Posts: 10438
Location: Columbus, Ohio, USA, Earth, The Solar System, The Milky Way Galaxy
|
|
| Back to top |
|
|
|
