Sorry, I believe the spreadsheet has been kindly updated by @Liuxuande007 while I was away on vacation, but I never posted the updated links in this thread.
Thanks @Major Zushie , @DavideBooks , @Automaton_2000 and everyone else who's expressed their thanks since I've been doing this! I'm really glad that it's a useful resource for some people!
And a big thanks to @Liuxuande007 for being so on top of adding sheets to the new events. Sometimes I log in to update the sheets, and the new event has already been entered! Oh, and if anyone has noticed that the builds are now ranked from cheapest to most expensive, that was also his idea.
Oops! Sorry to post this so late. I finished the spreadsheet earlier this afternoon but then had to take my daughter out to play and forgot to update the post.
Another big thanks on cultivating this guide. This last event was rough since I spent too long leveling crew and not gathering chronos. I just barely managed to pull through.
I hate to think what would happen if I were wasting my resources on inefficient missions.
Thank you. It seems I've been skipping the wrong missions for the past 300K VP. Probably lost a couple thousand chronitons. Oh, well. The way I figure is that I had the time on day one and won't have it on Easter. I'll get 350K VP and have enough super rares for a bit more than 200K additional VP. That should be enough.
Hello! This is the most amazing resource. Kudos and deep appreciation to the creator and those who've jumped in to assist in maintaining it.
I am wondering if anyone is working on a sheet for this week's coming Galaxy? If I'm not mistaken, it being a repeat means that all the mission info is already on the wiki, right?
Hello! This is the most amazing resource. Kudos and deep appreciation to the creator and those who've jumped in to assist in maintaining it.
I am wondering if anyone is working on a sheet for this week's coming Galaxy? If I'm not mistaken, it being a repeat means that all the mission info is already on the wiki, right?
Assuming DB didn’t tweak any supply missions to account for SO Spock, yes they should be the same. ThaiGQ will know for sure.
I made my own variant of this sheet that'll allow you to set up the missions yourself with the build components and customize it to ignore items you've got a high volume of, and also adjust on the fly once you run out of a component so the chron cost increases for you, and may mean another build becomes cheaper.
Note that I've manually created the list of components in the second worksheet and it still occasionally needs new items added, though most common galaxy items are on there.
I made my own variant of this sheet that'll allow you to set up the missions yourself with the build components and customize it to ignore items you've got a high volume of, and also adjust on the fly once you run out of a component so the chron cost increases for you, and may mean another build becomes cheaper.
Note that I've manually created the list of components in the second worksheet and it still occasionally needs new items added, though most common galaxy items are on there.
The total chron cost does not add up to the row totals on the mission Tracking the Design. Should be 91.1.
Thank you for finding this error, and I'm sorry I wasn't able to make the correction until now. After figuring out what caused the computational error, I checked all the other missions and found two other errors. All have been corrected now.
Apologies for the mistakes. I am new to working on this sheet, and I didn't think to double-check that all the new values were being included in the final sums. The good news is, I now know how to check for and correct that problem.
Comments
Sorry, I believe the spreadsheet has been kindly updated by @Liuxuande007 while I was away on vacation, but I never posted the updated links in this thread.
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=0
And a big thanks to @Liuxuande007 for being so on top of adding sheets to the new events. Sometimes I log in to update the sheets, and the new event has already been entered! Oh, and if anyone has noticed that the builds are now ranked from cheapest to most expensive, that was also his idea.
With that said:
Updated for 'From the Ashes' Phase 2:
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=219682233
Updated for 'Temporal Misalignment' Phase 2:
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1335415185
I hate to think what would happen if I were wasting my resources on inefficient missions.
@RodenberryPie Wow, that was close! Glad you were able to get the 5*!
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1557437253
Keep up the good work on the spreadsheet.
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=572675810
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=2066184252
You are my hero.
I am wondering if anyone is working on a sheet for this week's coming Galaxy? If I'm not mistaken, it being a repeat means that all the mission info is already on the wiki, right?
Assuming DB didn’t tweak any supply missions to account for SO Spock, yes they should be the same. ThaiGQ will know for sure.
Note that I've manually created the list of components in the second worksheet and it still occasionally needs new items added, though most common galaxy items are on there.
make a copy to your own google sheets to modify it, some basic instructions are at the beginning.
https://docs.google.com/spreadsheets/d/1Xp2s02-2f5vniWtbz95XjWDIyA2Vm_K2vXFB8PCXvW0/edit?usp=sharing
I hope the author does not mind me sharing in his thread. I'm no excel expert but find this sheet is fairly easy to update for a new event myself.
That is an amazing sheet. I'm not sure if I can work with it in my phone, but it might just be worth getting my computer out.
Evidently, I'm too new on the forum to post links, but the old ones should work... right?
Please let me know if there are any issues with the information.
Yay! Thanks.
Thank you for finding this error, and I'm sorry I wasn't able to make the correction until now. After figuring out what caused the computational error, I checked all the other missions and found two other errors. All have been corrected now.
Apologies for the mistakes. I am new to working on this sheet, and I didn't think to double-check that all the new values were being included in the final sums.