Muad'Dave's FBB Combo Tool
MuadDave
✭✭✭
Hey everyone, I've put together a Fleet Boss Battles combo node crew finder. I know others have created similar tools, but take a look and use it if you find it helpful.
Current version: 1.2 (2022 September 6)
With the release of the Datacore FBB tools, I'm retiring this project.
Muad'Dave's FBB Combo Tool
Current version: 1.2 (2022 September 6)
With the release of the Datacore FBB tools, I'm retiring this project.
Muad'Dave's FBB Combo Tool
2
Comments
I had an issue in one of my sheets that I needed to solve that overlapped with what could help yours, so I did a bit of testing and work. See my edits here. Let me know if you have any questions. This will auto populate everything from now on and do a bit extra. Traits are generated in sheet 8, displayed in sheet 9, and have some stats about traits for fun. Data validation for options was expanded, so as traits are added they will appear and be in your drop down boxes. The # of matches for a combo is in both the settings sheet as you enter it and in the checklist sheet, giving the user indication of how many possible matches there are in real time. Also, I added a "Duplicate detector" in sheet 2, so when you put in the traits on the board it will show the number of duplicates on the list. If the # of duplicates exceeds 0, it sets the cell to format to red. I'm not sure how your sheet is handling duplicates, so I assumed it would be nice to have that flagged and instruction to not delete both, just the given initially. Tested those things and it seems to work okay.
After that, the "tried" checkbox seems to only set the crew name to strike through font via a conditional formatting rule. Could you make some columns in tab 8 for if the crew has been tried for each node and then lookup if the trait is in the in the same row as any crew with the tried flag and remove it from the pool for that node if so? That would probably require you to make separate lists of traits for each node to track. I'd say it's possible, but not straight forward.
Nice work. Hope some of that helps.
JB
Thank you! I'm integrating your content now.
We used a copy of it last night and it definitely helped and was when i had a solution, it was correct.
I set the permissions to where anyone with the link could edit and then posted the link in our fleet discord. We will use it today for our "boss raid". I've got one more quick addition I may make and will PM you.
The "tried" functionality is the biggest gap that would make this even better.
Or if not check them off automatically, let the user know that the crew member or their trait array appear multiple places so they can manually check off the appropriate crew?
Thanks for this tool, by the way. My fleet is just starting to use it and I think it'll really help us get through tougher difficulties faster.
theres so much to improve to make it better.
it seems it was done at the beggining of bb. and it focus more in crew than traits.
example federation + ????
pool: human, starfleet
spreadsheet throw back 322 crew that fulfill fed+human or fed+starfleet
i need the pool of all the ones that have the 2 option and then if not the list that fill one or the other like in separate list or something.
worst case scenario i need to test 2 crews, best case 1.
(I dont know anything of how to make a spreadsheet, is it posible to return the crew list with that order, amount of matching traits)
instead of the list of crew that fulfill a node, a list like this for node 1
human, starfleet. human. starfleet
- crew1. -crew1. crew1
- crew2. -crew n. crew2
- crew n. crew n
again thanks for sharing this and hope you can do the 1.2 version with more features, cheers!
I recommend simply deleting the traits used from the input screen.
I've been on vacation and unable to update, but I have an idea about returning a list of "most useful" crew. Do we know that combos trigger when I have "one human crew and another starfleet crew" instead of "one crew with both human and starfleet"? That is contrary to my understanding of how it works, but I could be wrong!
Here are the changes in this version:
- Various of JimBerlin's updates, one big one being the use of tabs to split out Nodes instead of Difficulties.
- Make it so you can just type the first characters of the trait then hit enter.
- Order crew by traits, so that crew with duplicate traits are next to each other and easier to see as a group.
- Show the number of unique trait groups under the number of crew matches. This uses a simple method that counts Federation+Starfleet as different from just Starfleet.
- Fixed some of the trait spellings (eg. Padronian vs. Pandronian or Kraylor vs. Kraylon and missing traits like Tandaran).
- Fixed trait matching so that Klingon or Cardassian doesn't match Klingon-Cardassian Alliance.
- Fixed issue with trait's listed for node 5 (was including the known trait).
- Fixed issue with crew members being included that only match 1 trait, when 2 are required and when there are duplicate possible traits.
https://docs.google.com/spreadsheets/d/1tKULIp30Krv6wY_s5oj3b6CCkGrFIUpYFZ2xvYoaUrg/edit#gid=1942976