Go Back   IceInSpace > Equipment > Equipment Discussions
Register FAQ Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread
  #1  
Old 17-06-2010, 08:45 PM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Takahashi EM200 Polar Alignment Spreadsheet

Hello,

For owners of Tak EM200 Mounts with the Northern Hemisphere Date/Time Reticules in their Polar Alignment ‘Scope, please find attached a copy of a Microsoft Excel (Office Pro 2003) Spreadsheet which converts the Northern Hemisphere Date/Time to the Southern Hemisphere equivalents.

Cheers

Dennis

PS - Although the attached version is currently configured for the year 2010, it is in fact a “perpetual” calculator and I will only change the text from say, 2010 to 2011 for cosmetic presentation purposes, as the calculations are not affected by year changes.
Attached Files
File Type: zip Tak Date Time Converter.zip (8.9 KB, 158 views)
Reply With Quote
  #2  
Old 21-06-2010, 09:32 PM
beren
Registered User

beren is offline
 
Join Date: Oct 2004
Posts: 2,810
Thanks Dennis great aid indeed.....muchas gracias
Reply With Quote
  #3  
Old 11-07-2010, 10:11 PM
RB's Avatar
RB (Andrew)
Moderator

RB is offline
 
Join Date: Aug 2005
Posts: 26,631
Dennis you're a legend !
Thank you so much for this.

I assume it will work for the EM400 as well?
Reply With Quote
  #4  
Old 12-07-2010, 07:15 AM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Hi Andrew

I don’t know anything about the design of the EM400 PAS and reticule, nor how they work, but I do believe that the NJP mount PAS is quite different to the EM200, so not all Tak mounts are the same in terms of the PAS and their polar alignment routines.

At a guess, if the EM400 has the following EM200 features, I suspect it should work:
  • Levelling bubble on the RA casting.
  • An outer Date (1-12) reticule (CW).
  • A concentric inner Time (0-23) reticule (ACW).
  • An etched position for Sigma Octans with a scale from 2000 to 2030
Cheers

Dennis
Reply With Quote
  #5  
Old 19-01-2012, 10:14 PM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Hello

I have just updated the XLS spreadsheet to show 2012 in the explanatory text and attached it to this post as a ZIP file.

Note that when you open the file, it reads the System Time at the time of opening and then displays this value. It does not automatically refresh or update the time in the spreadsheet as the computer clock ticks on.

To update the displayed spreadsheet time to the current system time, you can press F9 and it refreshes the spreadsheet.

Cheers

Dennis
Attached Thumbnails
Click for full-size image (XLS Fields Description.jpg)
172.8 KB62 views
Attached Files
File Type: zip Tak Date Time Converter 2012.zip (28.1 KB, 41 views)

Last edited by Dennis; 20-01-2012 at 06:20 PM. Reason: Added screen capture
Reply With Quote
  #6  
Old 21-08-2013, 01:12 PM
cosmophoton (Luiz)
Registered User

cosmophoton is offline
 
Join Date: Jan 2013
Location: Belo Horizonte
Posts: 90
Thanks Dennis,
Greatly appreciated!
Regards,
Luiz
Reply With Quote
  #7  
Old 21-08-2013, 05:03 PM
gts055 (Mark)
Registered User

gts055 is offline
 
Join Date: Jun 2005
Location: Mornington Peninsula Victoria Australia
Posts: 337
Thankyou, Mark
Reply With Quote
  #8  
Old 24-05-2015, 08:16 PM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Updated to 2015 (for cosmetic reasons only).

The “dynamic” calculations work for any year, even though the “static” as-typed text will show a previous year as the next year rolls over.

Cheers

Dennis
Attached Files
File Type: zip Tak Date Time Converter 2015.zip (30.5 KB, 21 views)
Reply With Quote
  #9  
Old 24-05-2015, 09:25 PM
gts055 (Mark)
Registered User

gts055 is offline
 
Join Date: Jun 2005
Location: Mornington Peninsula Victoria Australia
Posts: 337
Thanks again, Mark
Reply With Quote
  #10  
Old 25-05-2015, 09:24 AM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Quote:
Originally Posted by gts055 View Post
Thanks again, Mark
No worries Mark, the version I posted should work for MS Excel 97 and onwards.

Here is another one where the static Year should update automatically, based on the system date of your operating system, although it will only work in Excel 2010 (and hopefully onwards ).

I guess I’ll find out on 1st Jan 2016 as I haven’t tested it yet!

Cheers

Dennis
Attached Files
File Type: zip Tak Date Time Converter 2015 Auto Year Calc.zip (30.7 KB, 18 views)
Reply With Quote
  #11  
Old 25-05-2015, 10:34 AM
gts055 (Mark)
Registered User

gts055 is offline
 
Join Date: Jun 2005
Location: Mornington Peninsula Victoria Australia
Posts: 337
Hii Dennis, my desktop operating system is Windows XP. I dont use MS Excel, instead I use Open Office Calc version 4.1.1 for spreadsheets. Both versions of your Tak time converter open fine in Open Office Calc. thanks Mark
Reply With Quote
  #12  
Old 25-05-2015, 08:17 PM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Quote:
Originally Posted by gts055 View Post
Hii Dennis, my desktop operating system is Windows XP. I dont use MS Excel, instead I use Open Office Calc version 4.1.1 for spreadsheets. Both versions of your Tak time converter open fine in Open Office Calc. thanks Mark
Thanks for testing the 2 versions and for the feedback Mark – it is good to hear that the spreadsheet is robust enough to be opened and executed in a program other than the original, native MS app.

Cheers

Dennis
Reply With Quote
  #13  
Old 07-01-2016, 10:16 AM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Here’s the 2106 (Leap Year) update. Cosmetic changes only, no impact on functionality.

Saved in MS Excel 2010 Version.

Happy New Year to all the readers and users!

Cheers

Dennis
Reply With Quote
  #14  
Old 07-01-2016, 03:36 PM
gts055 (Mark)
Registered User

gts055 is offline
 
Join Date: Jun 2005
Location: Mornington Peninsula Victoria Australia
Posts: 337
Thanks Dennis, Mark
Reply With Quote
  #15  
Old 23-01-2016, 03:41 PM
beren
Registered User

beren is offline
 
Join Date: Oct 2004
Posts: 2,810
Awesome Dennis thanks a lot
Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time is now 09:32 AM.

Powered by vBulletin Version 3.8.7 | Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Advertisement
Bintel
Advertisement