Yeah I noticed the values were way off too but it was expected there would be some error. I was going to resubmit. Do you think the older values will affect receiving the certificate?
I didn't check the calculations, I just accepted them. I too wondered about the amount of error, but then Jack had said our calcs might be way off, so that's what i submitted to him. I don't intend to re-submit with the more accurate data.
"Solar System Ambassador" for South Hampton Roads, Virginia
Back Bay Amateur Astronomers (BBAA)
Thank you for your excellent work in putting the spreadsheet together. And thank you Jeff for helping to wring out straight.
The spreadsheet was a significant effort and GREATLY appreciated by us all.
I am glad we were able to work through the growing pains.
I learned how to combine images without loss of data, logically OR’ing them so the stacking did not remove faint bits of data, i.e. The dot of Mercury as it traversed the son.
I re-learned more about “why” trig calculations “work” than I care to admit, as I am NOT a math-head. I probably could have called Jeff and, he would have found out how little I remembered from school, saved me a couple of days re-learning basic trig.
I just could not let go that the calculations were so far off, after the Venus transit calculations were surprisingly close. Order is everything, even in a spreadsheet!
Again Thank You Jim and Jeff.
From: Jim Tallman <jctallman@...>
Date: Wednesday, May 25, 2016 at 4:19 PM
To: Jim Tallman <jctallman@...>
Subject: Corrected Mercury Transit Forms
Just wanted to let you know that Chuck figured out why the calculations were coming up so far off. Seems I did the SIN and TAN a bit backwards in Excel. Attached is a corrected sheet, and it works well. He also provided a new photo that is easier to measure.
Well at least we will be ready for the next transit. Sort of hard to figure out all of the excel formulas on the fly.