Do Not Airlock Checklist Thread 4
cmdrworf
✭✭✭✭✭
About the Do Not Airlock Checklist
The 'Do Not Airlock Checklist' is a Google Sheet that was originally created by TheAlchemyst. It was then added onto by several other people, the latest of which is yours truly and @mr_sparky . I have made some modifications and updates since that I hope will be of some use, and regularly add the new crew that keeps appearing in the game for some reason.
This thread follows on from three earlier threads on the previous forums. It is therefore numbered four.
Great. So what does it actually do?
The 'Do Not Airlock Checklist' can help you determine what crew you still need (or don't) in planning your crew, help you with tricky Beholds, or help you with a shortage of crew slots by telling you what crew you can murder by pushing them out of an airlock into space. You monster.
The sheet takes into account mission requirements, the crew with the highest minimum and maximum stats, cadet challenges, collections, voyages, and usefulness in the Gauntlet. Every time you mark a crew member as Active, the sheet removes the requirements that he or she meets from all other crew, gradually whittling down the usefulness of crew that you do not yet have.
Why did you have me airlock this crew that I now need?! (or: the Big Fat Disclaimer)
● The sheet uses the stats of all crew at level 100 and fully equipped (they do not need to be fully fused). Recommendations will be incorrect if you mark crew that you are still leveling and equipping as Active.
● The sheet does not take into account how difficult characters are to equip.
● The sheet does not take events or the Arena into account and how useful a character may be for that.
● Changes may (and do) occur to the game at any time, which may invalidate the recommendations that the sheet gives.
● Always use your own judgement and the Big Book of Behold Advice before airlocking any crew.
Most Current Version: (12/13 Version 6.46)
https://docs.google.com/spreadsheets/d/1YPXGRuSA_iwW5AG5zUvBt1q6gVGy2-vZlZZCiZF9968/edit?usp=sharing
Conversion Helper
To help you more easily move your data from an older version 2.x to the new version 3.x, a conversion sheet is available: Do Not Airlock Conversion Sheet
How JiveDutch upgrades his sheet
Note that as of version 3.50, a semi-automated fill-in process is also available. See the Introduction tab in the sheet for more details.
The 'Do Not Airlock Checklist' is a Google Sheet that was originally created by TheAlchemyst. It was then added onto by several other people, the latest of which is yours truly and @mr_sparky . I have made some modifications and updates since that I hope will be of some use, and regularly add the new crew that keeps appearing in the game for some reason.
This thread follows on from three earlier threads on the previous forums. It is therefore numbered four.
Great. So what does it actually do?
The 'Do Not Airlock Checklist' can help you determine what crew you still need (or don't) in planning your crew, help you with tricky Beholds, or help you with a shortage of crew slots by telling you what crew you can murder by pushing them out of an airlock into space. You monster.
The sheet takes into account mission requirements, the crew with the highest minimum and maximum stats, cadet challenges, collections, voyages, and usefulness in the Gauntlet. Every time you mark a crew member as Active, the sheet removes the requirements that he or she meets from all other crew, gradually whittling down the usefulness of crew that you do not yet have.
Why did you have me airlock this crew that I now need?! (or: the Big Fat Disclaimer)
● The sheet uses the stats of all crew at level 100 and fully equipped (they do not need to be fully fused). Recommendations will be incorrect if you mark crew that you are still leveling and equipping as Active.
● The sheet does not take into account how difficult characters are to equip.
● The sheet does not take events or the Arena into account and how useful a character may be for that.
● Changes may (and do) occur to the game at any time, which may invalidate the recommendations that the sheet gives.
● Always use your own judgement and the Big Book of Behold Advice before airlocking any crew.
Most Current Version: (12/13 Version 6.46)
https://docs.google.com/spreadsheets/d/1YPXGRuSA_iwW5AG5zUvBt1q6gVGy2-vZlZZCiZF9968/edit?usp=sharing
Conversion Helper
To help you more easily move your data from an older version 2.x to the new version 3.x, a conversion sheet is available: Do Not Airlock Conversion Sheet
How JiveDutch upgrades his sheet
Note that as of version 3.50, a semi-automated fill-in process is also available. See the Introduction tab in the sheet for more details.
Sir, I protest! I am NOT a merry man!
17
Comments
Thanks.
Steps for quick transferring of settings & notes between sheet versions , this order should provide the fastest calculation order time
2.1 Missions Tab, multi-select and copy the Victorious Factions, and Ctrl-Shift-V (values only) over to the new sheet and display the proper checkboxes.
2.2 Multi Select + spacebar makes quick work of all the missions ... otherwise paste values only is your friend again.
3.1 Settings Tab, multi-select 3x crew, space bar to turn these calculations off
3.2 Change minimum crew rarity settings for event and voyages settings ( i set to 4 )
3.3 Copy the Starbase and Collection percentages (Ctrl+C), and Ctrl+Shift+V to paste them over as "Values Only"
4.1 Crew Tab , unfilter all collumns to default view, sort by name A-Z, then Version Z-A on both sheets,
4.2 multi-select Notes cells, and Ctrl+Shift+V to the new sheet. (i always check if the top and bottom notes align .. manual changes are required when crew names change and alter positions)
5. re-apply your filter preferences and you are ready to go ....
The following extra steps are used when you alter the sheet for manual Active/Fusion tracking.
4.3 multi-select Active/Keep/Notes cells, and Ctrl+Shift+V to the new sheet. (i always check if the top and bottom notes align .. manual changes are required when crew names change and alter positions)
4.4 multi-select all cells in Row B ( Fusion #) and paste them over ...
"Added New Crew: Lt. Ilia, Arjin, Age of Sail Worf
Updated stats to auto calculate the 2*3*4* stats on 5* crew, and 2*3* stats on 4* crew and 2* on 3* crew"
@Burrakooka Thank you. Stealth fixed on the published and my master.
Just for reference I want to put up @Leshy 's guide to update crew manually here too - I have two sheets for my SSR and Vip0 accounts, and copying over everything in settings, missions for vip0, notes etc. has always a bit tedious.
Now I copy new crew from @cmdrworf 's sheet into the stats sheet and insert a line in the crew sheet where I copy the line above. Works fine so far for me
@/SSR/ Tichy One more thing on this. On the stats sheet there are formulas in the 2*, 3*, 4* stat coulumns for 5* crew, 2*, 3* for 4* crew, and 2* for 3 * crew that need to be copied from another crew with the same rarity so all of the * level stats update as well.
Well I assumed since I'm copying the stats line of your new sheet (let's say line 29 for AoS Worf) the formulas are in there already?
Just checked, the columns F..H contain a formula but no result. It seems I should migrate to the latest sheet and do manual updates from there.
Otherwise yes, you could copy paste from my posted sheet for all the formulas.
It doesn't include the completed missions, but it does include the episodes' completed stars and total stars. So at least if for one episode the completed stars is equal to the total stars you can count all missions in that episode complete.
However, that information cannot be exported in the CSV; a CSV by definition includes a single set of data (a single table). You need a more complex file format (such as an excel file with multiple sheets) to export multiple sets of data; that would be too difficult to import in Google Sheets though.
You can update the import tab manually.
I do have an issue - My Twilight T'Pol is lvl 100 1/5*. On the import sheet it shows that but she doesn't show on the crew sheet
Twilight T'Pol TRUE T'Pol 5 1 100
Any clue
EDIT:
Its that naggy ' So the hypertext link has the squirrely ' but its supposed to be the straight '
Not sure how to fix that on my sheet.
Edit2:
I fixed on my end by unhiding the Stats sheet and addressing that apostrophe there. It fixed the sheet for me.
Currently running a manually updated sheet and a imported one to see differences.
I've corrected it on my own sheet, but I thought I'd point it out here as well for everyone else.
Hi @DeeMentia! This is a side-effect of the import functionality added by Leshy just before they stopped maintaining the sheet. We're currently working on implementing some changes so that people can choose if non-FE people should be counted as active or not.
I've fixed both of these points in the Dev version of the checklist. They should be taken into account with the new version that @cmdrworf will release this week containing the new crew that'll be added for the next event and Tuesday packs.
Fixed in 3.53 which will be published this week. Thanks @DeeMentia And your quite welcome, but also I also need to thank @SpukkZ as he's working with me on this.
@Burrakooka Gary Seven is fixed. will be in 3.53 this week.
Hey @cmdrworf , bug report on 3.53 is that after import the only crew showing as either need or active is Dark Ages McCoy. All others are showing as Space.
Worth looking into for when the new crew are added for the final part of this mega?
I think the problem is, on the hidden Stats tab, a lot of formulas aren't "copied down"...from AX5 to BI, and BJ5 to NY. If you know what I'm talking about, you can just copy all the formulas to the bottom of the tab and that looks like it fixes the problem.
Otherwise, you should probably stick to 3.52 until there's a fix.
I've been using this for a long time and this is the first time I've really looked at all the formulas involved. WOW! THANK YOU for all the work! This is one *really* impressive spreadsheet!
Here the sheet 3.53 dont calculate anything.
I have 'dark ages' mc coy in "Need" and all other in "space" even frozen crew. This first line is ok with all columns correct. No "Active", no "Frozen" and no "Space/Freeze" in other lines.
Columns b and e are filled correctly but nothing in skills, recommandation and reason.
It looks like the first line was calculated and then anything else.
Just made a copy and import.
Same imported sheet works in 3.50 outside Twilight T'Pol.
Edit : just read the whole thread and the problem is known so. Where can I find 3.52 ?
I've published a new version of 3.53 that fixes this. As @mr_sparky noted, something went wrong with the release and the formulas weren't copied to all crew.
You can access the new version at https://docs.google.com/spreadsheets/d/1g2IIPOBWC3cUkN9d9NXe_usozYxJqOGW-xI_8ZvqVxs/edit?usp=sharing
I can't update the main post myself, so we need to wait for @cmdrworf for that.