Aurora progress after 36 hours - the spreadsheet is still wrong
If you are interested in my latest rant - I mean blog - then please go here: https://drthod.com/aurora-progress-after-36-hours-i-have-a-melt-down/
Using Myriad numbers for a prediction I get either 12.7 or 16.3 million as likely overall achievement after the event.
Why 2 numbers? Because you get a different value for the progress over the last 12 hours - depending if you trust points gained (higher value) or points needed (lower value).
The higher numbers are what I want to believe, the lower numbers are what more closely follows the progress in Myriad. Both are in the realms of possibility and I haven't spotted a simple spreadsheet error that could explain how one set of numbers erroneously got created from the other.
So until we hear back from Niantic we won't know. I flagged this already yesterday after the 24 hour values got announced but it seems it didn't get any attention.
Comments
Hrmm let me double check the formula. BRB
Bah. Good catch. I updated column D. Stoopid drag and drop error with Google Sheets.
Thanks for correcting it.
I need to be more careful. We have columns with data to see how things trend based on different outcomes (both + and -) and it was using that instead of the live data. Hopefully when we get the new servers we can get improved tools for these things.