So yes Gauntlet is measured against general stats and not specific but that's the only one. I probably won't change that as it would add a ton more calculations to the sheet which I think is already straining under it's own weight.
Everything else *should* be based on your current crew stats.
Honor debt is getting a new calculation soon, someone on the GoogleSheets subreddit was helpful in fixing my poor formula.
Yep Honor time calculation now fixed! Still based on 1300 honor per day which obviously is below average for a daily player but I think standard for someone who is logging in and getting dailies plus any from voyages.
I can be corrected if anyone wants to do some complicated mathematics
edit: added a field in the honor tab for users to change their honor levels.
There does seem to be a problem with some of the med crew though. I've noticed that my Mobile Doctor and Q as God both show med as their secondary skill instead of primary. Haven't looked through all of my other crew yet, but med stood out to me as I have so few to begin with.
There does seem to be a problem with some of the med crew though. I've noticed that my Mobile Doctor and Q as God both show med as their secondary skill instead of primary. Haven't looked through all of my other crew yet, but med stood out to me as I have so few to begin with.
@DukeBigglesworth is this on the crew list? Yeah I'd noticed this aswell. Not entirely sure why this is happening but it doesn't effect the lists, just how the skills are presented on the crew list.
I'll look into it when I get time.
Fixed, turns out I was sorting the crew skill data by maximum proficiency stat not core skills. Should show correct order now.
Edit: it still will show secondary/tertriary skills even for those who don't have them. I'm not sure I can fix this one but it doesn't effect anything else of importance so I'll probably leave it.
If I may request something...? A third column on the "Full Voyage Pair Rankings" tab with the overall voyage number would be great. This list kind of favors 2skillers, but I do not...
But... this is AWESOME work, really. Thanks for sharing!
This kind of exists under Top Crew, which sorts all your Voyagers by their total voyage skill. This accounts for all three skills sets.
Hmmm column B + C do, but they are unsorted stat-wise. The other columns only show the main bases and no pairs or totals. But ok, it was just a suggestion. It is your tool.
Oh so would a list of the crew and their voyage stats similar to the L100 Crew chart be more useful. I think I can possibly design that and put it in, shouldn't be too hard (famous last words).
To be honest I do not know what that looks like, I use a different one with this output:
Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
Perhaps worth noting, though I don't know if it needs to be *fixed* per se, is primary/secondary skills are shown by base skill exclusively, rather than say voyage total. For example, Doc Crusher still shows as SCI/MED even though her combined med is far higher. Anyway, just thought it was worth mentioning, thanks again!
Perhaps worth noting, though I don't know if it needs to be *fixed* per se, is primary/secondary skills are shown by base skill exclusively, rather than say voyage total. For example, Doc Crusher still shows as SCI/MED even though her combined med is far higher. Anyway, just thought it was worth mentioning, thanks again!
Odd as she's showing as MED/SCI on my sheet, but I only have her at L70. Are you using the latest sheet @DukeBigglesworth ?
I just updated to 0.14, and still showing the same thing. At level 70, her med base IS higher than sci (if fully fused), but then they switch. My Doc Crusher is 3/4 and level 100, so her sci base is actually almost 100 points higher than med. However, with her huge med proficiency her voyage primary is med.
In which case that sounds like it's working fine. Those combinations on the crew page come from the Base stats and is worked out via their levels. Nothing needs fixing unless there is a major outcry for me to switch it from base totals to voy totals. In any regard for the MED/SCI SCI/MED pairings it won't make any difference.
Doc Crusher is an odd one though I don't know of any other crew who switches primary stats halfway through leveling.
In which case that sounds like it's working fine. Those combinations on the crew page come from the Base stats and is worked out via their levels. Nothing needs fixing unless there is a major outcry for me to switch it from base totals to voy totals. In any regard for the MED/SCI SCI/MED pairings it won't make any difference.
Doc Crusher is an odd one though I don't know of any other crew who switches primary stats halfway through leveling.
There are a few other examples that come to mind where there are skill switches either when leveling or adding stars - The Keeper goes from SCI/MED/COM to MED/SCI/COM, 1701 Sisko‘s primary skill switches from COM to SEC, 007 Bashir goes from MED primary to DIP primary, and Dark Ages McCoy swaps his secondary skill from SEC to DIP. I am sure there are others, too.
I added some honor calculation for myself, now the honor debt outcome looks a little bit less devastating...
Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
I think Aviator Yar is another one that switches skills, can’t think of any more that do switch other than the ones mentioned above. Although another similar case is for example DA McCoy, where proficiencies make what would be their base tertiary skill a voyage secondary skill.
[was on Sabbatical/Hiatus] Currently a trialist at Galaxy SquadronSTAY SAFE and KBO
New feature! Chron Debt, it's like Honor Debt but instead of dissuading one from pulling packs this will make you not want to participate in events! Two sets of data based on with a kit and without.
I've also removed the Personal VScore and VRank as it didn't serve much purpose and removed the top voyagers from Top Crew as this has it's own dedicated sheet.
Enjoy!
I would not say that my chron debt is scarier as a lot of it is farmed already, but still... quite a way to go.
Thanks for the update!
Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
I think Aviator Yar is another one that switches skills, can’t think of any more that do switch other than the ones mentioned above. Although another similar case is for example DA McCoy, where proficiencies make what would be their base tertiary skill a voyage secondary skill.
Only a 3* , but I remember Raquetball Bashir, in this weeks rewards, swaps primary skill from Med to Sci.
Thanks for the update @[10F]CaptainIdol , great work on this! Scary, but great!!
Wow this is really so much more perfomant. Thanks a lot for the great work!
Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
Not sure if it's due to the recent game update, but in case anyone else runs into this I thought I'd share that when I ctrl-a the data on the disruptorbeam site to paste in datacore, it's too much text for my clipboard. I had to search for the end of the text I see at the bottom of datacore's site and ctrl-f to find it, then copy-paste everything after that manually.
Might be a windows 7 clipboard size limitation, just sharing in case others run into this.
Today I recognized that the "Random Backend Data" (or something like this) tab was renamed to "Backend Data" but the M column on "Lists and Pies" still referred to the old tab name which left all cells blank.
Wir, die Mirror Tribbles [MiT] haben freie Plätze zu vergeben. Kein Zwang und kein Stress, dafür aber Spaß, Discord und eine nette, hilfsbereite Gemeinschaft, incl. voll ausgebauter Starbase und täglich 700 ISM.
Voyage pair calculation seems off for (at least) DIP/SEC. Apparently the Voyage Pair Data sheet, columns Q-R-S are referencing the Converted Data sheet, column BC instead of column BL.
I haven't checked other pairs, but it seemed very strange to me that my best DIP/SEC voyage crew would be an crew that only has ENG/SCI...
Edit: Otherwise this sheet is an amazing tool to get some more and better insights in my crew strengths and weaknesses! Thanks a bunch!!
Voyage pair calculation seems off for (at least) DIP/SEC. Apparently the Voyage Pair Data sheet, columns Q-R-S are referencing the Converted Data sheet, column BC instead of column BL.
I haven't checked other pairs, but it seemed very strange to me that my best DIP/SEC voyage crew would be an crew that only has ENG/SCI...
Edit: Otherwise this sheet is an amazing tool to get some more and better insights in my crew strengths and weaknesses! Thanks a bunch!!
I also found MED/CMD voyage crew pairs seems to have the same issue. Mine is only showing crew with CMD, none of which have MED.
I'll make a note of these bugs and have a look soon. I've got a few other little tweaks to work out. Usually it's just me not putting the correct columns in.
Voyage pair calculation seems off for (at least) DIP/SEC. Apparently the Voyage Pair Data sheet, columns Q-R-S are referencing the Converted Data sheet, column BC instead of column BL.
I haven't checked other pairs, but it seemed very strange to me that my best DIP/SEC voyage crew would be an crew that only has ENG/SCI...
Edit: Otherwise this sheet is an amazing tool to get some more and better insights in my crew strengths and weaknesses! Thanks a bunch!!
I also found MED/CMD voyage crew pairs seems to have the same issue. Mine is only showing crew with CMD, none of which have MED.
Can you send me a link to your sheet. Not sure why this one is happening.
I've fixed the DIP/SEC Voyage pairs.
Edit: Actually I found the problem, MED/CMD was looking at the correct scores, but pulling names from the wrong column. SPREADSHEETS!
Today I recognized that the "Random Backend Data" (or something like this) tab was renamed to "Backend Data" but the M column on "Lists and Pies" still referred to the old tab name which left all cells blank.
I've fixed this one recently, loading a fresh version should fix this.
Comments
Everything else *should* be based on your current crew stats.
Honor debt is getting a new calculation soon, someone on the GoogleSheets subreddit was helpful in fixing my poor formula.
I can be corrected if anyone wants to do some complicated mathematics
edit: added a field in the honor tab for users to change their honor levels.
There does seem to be a problem with some of the med crew though. I've noticed that my Mobile Doctor and Q as God both show med as their secondary skill instead of primary. Haven't looked through all of my other crew yet, but med stood out to me as I have so few to begin with.
@DukeBigglesworth is this on the crew list? Yeah I'd noticed this aswell. Not entirely sure why this is happening but it doesn't effect the lists, just how the skills are presented on the crew list.
I'll look into it when I get time.
Edit: it still will show secondary/tertriary skills even for those who don't have them. I'm not sure I can fix this one but it doesn't effect anything else of importance so I'll probably leave it.
This has been added now! Enjoy!
Thank you so much. This is fantastic!
Perhaps worth noting, though I don't know if it needs to be *fixed* per se, is primary/secondary skills are shown by base skill exclusively, rather than say voyage total. For example, Doc Crusher still shows as SCI/MED even though her combined med is far higher. Anyway, just thought it was worth mentioning, thanks again!
Odd as she's showing as MED/SCI on my sheet, but I only have her at L70. Are you using the latest sheet @DukeBigglesworth ?
Doc Crusher is an odd one though I don't know of any other crew who switches primary stats halfway through leveling.
There are a few other examples that come to mind where there are skill switches either when leveling or adding stars - The Keeper goes from SCI/MED/COM to MED/SCI/COM, 1701 Sisko‘s primary skill switches from COM to SEC, 007 Bashir goes from MED primary to DIP primary, and Dark Ages McCoy swaps his secondary skill from SEC to DIP. I am sure there are others, too.
I've also removed the Personal VScore and VRank as it didn't serve much purpose and removed the top voyagers from Top Crew as this has it's own dedicated sheet.
Enjoy!
I would not say that my chron debt is scarier as a lot of it is farmed already, but still... quite a way to go.
Thanks for the update!
Only a 3* , but I remember Raquetball Bashir, in this weeks rewards, swaps primary skill from Med to Sci.
Thanks for the update @[10F]CaptainIdol , great work on this! Scary, but great!!
https://docs.google.com/spreadsheets/d/1_9PhcXuPc99rxtox4Ix19U0J0PS9d0w03MOmmvnvThs/edit?usp=sharing
I sometimes find this happens when the datacore text hasn't loaded properly. Try it again and see if it loads properly.
Might be a windows 7 clipboard size limitation, just sharing in case others run into this.
Thanks.
I haven't checked other pairs, but it seemed very strange to me that my best DIP/SEC voyage crew would be an crew that only has ENG/SCI...
Edit: Otherwise this sheet is an amazing tool to get some more and better insights in my crew strengths and weaknesses! Thanks a bunch!!
I also found MED/CMD voyage crew pairs seems to have the same issue. Mine is only showing crew with CMD, none of which have MED.
Can you send me a link to your sheet. Not sure why this one is happening.
I've fixed the DIP/SEC Voyage pairs.
Edit: Actually I found the problem, MED/CMD was looking at the correct scores, but pulling names from the wrong column. SPREADSHEETS!
I've fixed this one recently, loading a fresh version should fix this.