GeoffW1
10-08-2008, 01:10 PM
Hi,
I am making up an observation log for myself, for observation of multiple stars, in the form of a spreadsheet adapted from this listing
http://astronomy.eaglecreekobservatory.org/doubles/
I don't know yet whether some of this data will need updating, but possibly.
One of the features of my log I am developing is an observation difficulty rating. This is so dependent on location and telescope of course that my early efforts have proved misleading. However I want to grade my successes!
The rating is in the form of
IF Separation > some value AND Mag1 < some value AND Mag2 < some value THEN "easy"
OTHERWISE IF Separation > some value AND Mag1 < some value AND Mag2 < some value THEN "moderate"
OTHERWISE "hard"
The Excel formula is actually =IF(AND(D2>10,F2<6,G2<6),"easy",(IF(AND(D2>5,F2<8,G2<8),"moderate","hard")))
I've been using a 300mm dob from a Sydney backyard, with a Astronomik CLS filter (not that the filter seems to matter). The question here is, what values for separation and magnitude would you use ?
Cheers
I am making up an observation log for myself, for observation of multiple stars, in the form of a spreadsheet adapted from this listing
http://astronomy.eaglecreekobservatory.org/doubles/
I don't know yet whether some of this data will need updating, but possibly.
One of the features of my log I am developing is an observation difficulty rating. This is so dependent on location and telescope of course that my early efforts have proved misleading. However I want to grade my successes!
The rating is in the form of
IF Separation > some value AND Mag1 < some value AND Mag2 < some value THEN "easy"
OTHERWISE IF Separation > some value AND Mag1 < some value AND Mag2 < some value THEN "moderate"
OTHERWISE "hard"
The Excel formula is actually =IF(AND(D2>10,F2<6,G2<6),"easy",(IF(AND(D2>5,F2<8,G2<8),"moderate","hard")))
I've been using a 300mm dob from a Sydney backyard, with a Astronomik CLS filter (not that the filter seems to matter). The question here is, what values for separation and magnitude would you use ?
Cheers