Thank you for sharing this.
I might have done something wrong but didn’t get the correct answer.
We’ve had 65 reviews. Our rating shows as 4.95. All the categories show as 5.0 except value is shown at 4.9. So I entered 65 reviews and one lost star, and your spreadsheet shows 5.0, but the reality is 4.95.
To get to the 4.95 rating I need to enter 18 lost stars. So did we really lose 18? How would I know how many stars I lost without going back and checking every rating?
What am I doing wrong, here?