I love these spreadsheets for astronomical purpose. I have done a few myself.
This one includes loads of calculations, which is a nice thing. Nevertheless, with such amout of information, errors may appear and it is the case.
For instance, you have to be careful with the star magnitudes sheet. The author claims that there are 2.5x more stars as we move to a higher magnitude (dimmer stars). This is not correct. Stars are aproximately 2.5x "dimmer" with each extra magnitude, but their actual number is not related to that fact. For example, moving from magnitude 1 to 2, you actually get 4.2x more visible stars from earth.
Another example: In the scope sheet, "area vs 8''" is the correct formula only if you do not modify the first scope (which is an 8''), but 8 is a blue cell, so it is supposed to be modified by the user!
An exhaustive review of the calculations presented would be advisable before giving an intensive use to this spreadsheet.
|
