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.
No problem at all! Thank you for taking the time to make the effort and participate in helping out us STT addicts.
Updated for 'On the Backs of Giants', Phase 1.
At least, I think it is.
If anyone has time to/wants to double-check things, I'd welcome the backup. Please comment here if there are any issues, so that other users can be advised, as I won't be able to check back in for a few hours.
Happy eventing!
Updated for 'On the Backs of Giants', Phase 1.
At least, I think it is.
If anyone has time to/wants to double-check things, I'd welcome the backup. Please comment here if there are any issues, so that other users can be advised, as I won't be able to check back in for a few hours.
Happy eventing!
Sorry for the late reply. I had knee surgery on May 29th and am just now starting to get back into some of my usual routines.
I'd like to welcome a new contributor to the sheets, @Glitterbomb!
Hope you feel 100% soon!
Thanks, @muwoo ! Sorry for the late reply. As you can probably tell, I don't get a chance to check the forums very much with the additional 3-4 hours of physical therapy I have each day. But thank you for the well wishes! I really appreciate them!
I haven't had a chance to study the new features for personalizing the calculations that have been added to the last couple of sheets. I will be reaching out to the other editor(s), to see if I can get those added and to find out how to do it in the future. Meantime, if YOU are a person who can add those features to the sheet, please do.
Updated for 'Storm Warning', Phase 2 along with the new features for personalizing calculations.
Big belated shoutout to the person who introduced the calculations to me btw! Unfortunately, I'm not sure what his handle is in-game, but if you're reading this, please introduce yourself so we can give you credit for the awesome work!
@Glitterbomb Sorry for my late response to your message earlier this week. I've responded with a breakdown for how the calculations are determined, but I've also gone ahead and updated both Phases of this event in the spreadsheet so moving forward, if we just duplicate the sheet, we shouldn't have to mess with the calculations or fields outside of adding/removing rows.
I think I also accidentally stumbled on how to pull data from other tabs in the spreadsheet, so the next step might be to do a webcrawler to be able to get the most recent costs for each of the items and put them into one sheet/tab that all the recipes can draw from. This way, we have the most recent cost data when they change and we reduce the variance that happens when we copy just the values. That said, I don't know how to do any of that yet, so I'll have to do some research on how to create a webcrawler to get all of the information as well as have it update the spreadsheet.
Sorry I haven't been posting the updates to the forum much. The sheet is (mostly) being updated for the galaxy events, but I'm in Asia at the moment and not getting online to post the updates here.
Sorry for the delay in posting the link. I updated the sheet about 12 hours ago, but didn't have time post the link here.
Also, a quick heads up that we're expecting our second daughter to be born any time now, so I may not be able to update the spreadsheet for the next few events until life settles down into a more manageable rhythm. My first daughter was 17 days late though, so I'll keep updating the sheet for as long as I can, but wanted to temper expectations a bit for the next few events.
Sorry for the delay in posting the link. I updated the sheet about 12 hours ago, but didn't have time post the link here.
Also, a quick heads up that we're expecting our second daughter to be born any time now, so I may not be able to update the spreadsheet for the next few events until life settles down into a more manageable rhythm. My first daughter was 17 days late though, so I'll keep updating the sheet for as long as I can, but wanted to temper expectations a bit for the next few events.
Take time for your kids. They are great. Before you know it, they'll be teenagers. That is when you need time away.
Comments
No problem at all! Thank you for taking the time to make the effort and participate in helping out us STT addicts.
Sorry for the late reply. I had knee surgery on May 29th and am just now starting to get back into some of my usual routines.
I'd like to welcome a new contributor to the sheets, @Glitterbomb!
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1664080959
Hope you feel 100% soon!
At least, I think it is.
If anyone has time to/wants to double-check things, I'd welcome the backup. Please comment here if there are any issues, so that other users can be advised, as I won't be able to check back in for a few hours.
Happy eventing!
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=473639846
Thanks, @Glitterbomb !
Also updated for 'On the Backs of Giant's, Phase 2!
Thanks, @muwoo ! Sorry for the late reply. As you can probably tell, I don't get a chance to check the forums very much with the additional 3-4 hours of physical therapy I have each day. But thank you for the well wishes! I really appreciate them!
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=2108538417
I haven't had a chance to study the new features for personalizing the calculations that have been added to the last couple of sheets. I will be reaching out to the other editor(s), to see if I can get those added and to find out how to do it in the future. Meantime, if YOU are a person who can add those features to the sheet, please do.
From your lips to God Q's ears.
Srsly, tho - you're right. Best play for keeps during Phase 1, since the odds say Phase 2 will be more costly.
Big belated shoutout to the person who introduced the calculations to me btw! Unfortunately, I'm not sure what his handle is in-game, but if you're reading this, please introduce yourself so we can give you credit for the awesome work!
@Glitterbomb Sorry for my late response to your message earlier this week. I've responded with a breakdown for how the calculations are determined, but I've also gone ahead and updated both Phases of this event in the spreadsheet so moving forward, if we just duplicate the sheet, we shouldn't have to mess with the calculations or fields outside of adding/removing rows.
I think I also accidentally stumbled on how to pull data from other tabs in the spreadsheet, so the next step might be to do a webcrawler to be able to get the most recent costs for each of the items and put them into one sheet/tab that all the recipes can draw from. This way, we have the most recent cost data when they change and we reduce the variance that happens when we copy just the values. That said, I don't know how to do any of that yet, so I'll have to do some research on how to create a webcrawler to get all of the information as well as have it update the spreadsheet.
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=714876727
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1335415185
🖖
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=313384670
Thanks, @Glitterbomb !
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1073440811
Sorry I haven't been posting the updates to the forum much. The sheet is (mostly) being updated for the galaxy events, but I'm in Asia at the moment and not getting online to post the updates here.
Here is the link for next week's flashback event (The Longest Day) in advance:
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1420602931
Here is the post for the original run of this Event in May 2018. I have not checked the link. 🖖
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=1463148480
Sorry for the delay in posting the link. I updated the sheet about 12 hours ago, but didn't have time post the link here.
Also, a quick heads up that we're expecting our second daughter to be born any time now, so I may not be able to update the spreadsheet for the next few events until life settles down into a more manageable rhythm. My first daughter was 17 days late though, so I'll keep updating the sheet for as long as I can, but wanted to temper expectations a bit for the next few events.
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=384178459
Take time for your kids. They are great. Before you know it, they'll be teenagers. That is when you need time away.
https://docs.google.com/spreadsheets/d/1KiRTr3ri6BQBIdOVgKbckqA2iQu_hgWoIS3pPYLmDog/edit#gid=2066184252