I have (but don't use) STT100 spreadsheet.
I use the Do not airlock spread sheet.
I have my own crew manifest spreadsheet.
I have a spread sheet for events, VP, my rankings, and miscellaneous data.
I also have my own voyage calculator spreadsheet, which calculates voyage length, AM refill costs etc. It is unfinished as I have not finished the crew and ship selectors.
I mostly use spreadsheets for event planning. Especially when we still don't get Galen on a PIcard search etc, I use the WIki + my roster to create the roster for the event and determine leveling priorities.
There are other things I keep track of like order I immortalized but that's more of just a list than data that I sort through.
Yep, cool little google sheet - it's really just a chart (no math functions built in) but I spent ages giving it all pretty colours for crew rarity with different shades to show how fused they are, so it looks sweet.
Lately I've added a column (in icy blue) to flag anyone I've decided to freeze when they're done (so I don't have to remember by myself) and been building a separate little table of event crew each week with their bonus-adjusted stats, so I can see who best to work on in the days leading up. That's actually been kind of helpful. But mainly it's the pretty colours.
I keep the top six crew for each core skill and top voyage skill (since they don't calculate that for you). Since I'm not dropping cash for more crew slots, it helps keep my team tight.
Also, I'm a stats nerd, so spreadsheets lead to victory, AND VICTORY IS LIFE!!!!!!
My 8-Point STT Strategy:
1. Voyage.
2. Have fun. If something isn't fun, don't do it.
3. Only pursue characters I care about.
4. Contribute to the fleet.
5. No more spending beyond monthly cards.
6. Have fun.
7. Voyage.
8. Have fun!
Eh, it's just a game, why would I use a work tool to help me play?
Playing already feels like a simulation of a job in logistics. Spreadsheets can be useful, but in general a terrible format to do anything with.
Not that there aren't some well thought out spreadsheets offered by the community, I just don't think the effort of maintaining them offers enough of a return in game results.
Eh, it's just a game, why would I use a work tool to help me play?
there is a problem with a game if a spreadsheet is of any use. That means that it has either become WORK or it has become predictable. That should be an alarm for a game designer
there is a problem with a game if a spreadsheet is of any use. That means that it has either become WORK or it has become predictable. That should be an alarm for a game designer
I have to disagree with this one. If a game doesn't need a spreadsheet it doesn't have enough depth or options. Spreadsheets help manage choices and tradeoffs, if these aren't pressent and/or sufficiently difficult to disentangle, why play at all? (Of course each to their own, but I need that level of depth)
When I started, I used my spreadsheet for functional purposes (i.e., identifying who could do what and what I needed). I've gotten away from that as my crew grew past the point where I needed to consult to see who might be able to squeak by a node if they had the right bonus trait.
These days, I use it more for tracking some of the more novel things that intrigue me, like event history and which main cast characters have been in events, etc. You know; all the minutiae I bandy about in these threads. (Didn't think I pull all that stuff together from the Wiki every time I do a deep dive into these things, didja?)
I maintain one for my crew roster (link in sig), but that's it. I started it to help me keep track of crew for when beholds came up, because at the time beholds did not include fuse information. So if you didn't have this information in your head or written down, you ran the risk of choosing someone you already had FF.
It's not necessary for that purpose anymore, but I still maintain it anyway as my crew changes. It just lists name, fusion status, and level. Having it in a google spreadsheet and linking it in my signature makes it a handy reference when relevant crew discussions come up.
Yeah ... I created one very early on to just keep track of my crew because ... well ... I might be one of the few players who actually don't know much about Star Trek at all so the names and faces are all fairly unfamiliar ... anyway, it helped me get familiar with my crew etc. (back in the day DB was really, really poor for crew management ... it has gotten better over time).
I've expanded it and adapted it over time ... now I mainly use it to help me sort out event crew, I track how well I do in an event etc.
The other main thing I use it for now is keeping track of all the crew I haven't started levelling yet.
Oh ... I used to use it to track the nodes I needed to clear and the crew I needed to level (or pull) for that ... but thankfully I only need to clear 3 more nodes because keeping track of all the new crew coming out is a little nuts.
Anyway, I really like using spreadsheets and I use them on a daily basis for my work, so it was self-explanatory that I'd set one up.
Comments
Thats how we roll...or fly
I have (but don't use) STT100 spreadsheet.
I use the Do not airlock spread sheet.
I have my own crew manifest spreadsheet.
I have a spread sheet for events, VP, my rankings, and miscellaneous data.
I also have my own voyage calculator spreadsheet, which calculates voyage length, AM refill costs etc. It is unfinished as I have not finished the crew and ship selectors.
There are other things I keep track of like order I immortalized but that's more of just a list than data that I sort through.
Lately I've added a column (in icy blue) to flag anyone I've decided to freeze when they're done (so I don't have to remember by myself) and been building a separate little table of event crew each week with their bonus-adjusted stats, so I can see who best to work on in the days leading up. That's actually been kind of helpful. But mainly it's the pretty colours.
SSR Noob
Spoiler of spoils
Also, I'm a stats nerd, so spreadsheets lead to victory, AND VICTORY IS LIFE!!!!!!
1. Voyage.
2. Have fun. If something isn't fun, don't do it.
3. Only pursue characters I care about.
4. Contribute to the fleet.
5. No more spending beyond monthly cards.
6. Have fun.
7. Voyage.
8. Have fun!
Not that there aren't some well thought out spreadsheets offered by the community, I just don't think the effort of maintaining them offers enough of a return in game results.
However I would create my own spreadsheet if the game had an export option to export crew details to a text file (please, pretty please!)
I have to disagree with this one. If a game doesn't need a spreadsheet it doesn't have enough depth or options. Spreadsheets help manage choices and tradeoffs, if these aren't pressent and/or sufficiently difficult to disentangle, why play at all? (Of course each to their own, but I need that level of depth)
These days, I use it more for tracking some of the more novel things that intrigue me, like event history and which main cast characters have been in events, etc. You know; all the minutiae I bandy about in these threads. (Didn't think I pull all that stuff together from the Wiki every time I do a deep dive into these things, didja?)
It's not necessary for that purpose anymore, but I still maintain it anyway as my crew changes. It just lists name, fusion status, and level. Having it in a google spreadsheet and linking it in my signature makes it a handy reference when relevant crew discussions come up.
I've expanded it and adapted it over time ... now I mainly use it to help me sort out event crew, I track how well I do in an event etc.
The other main thing I use it for now is keeping track of all the crew I haven't started levelling yet.
Oh ... I used to use it to track the nodes I needed to clear and the crew I needed to level (or pull) for that ... but thankfully I only need to clear 3 more nodes because keeping track of all the new crew coming out is a little nuts.
Anyway, I really like using spreadsheets and I use them on a daily basis for my work, so it was self-explanatory that I'd set one up.