Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.

On Wed, 7 Sep 2005 10:10:07 -0700, "Peter Barrett"
wrote:

Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.


Try

http://www.ecy.wa.gov/programs/eap/models/

The 6th item down is an Excel Sunrise/Sunset calculator.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Richard

That is indeed very helpful.

I am now trying to figure out if (and how) it is possible to use the
functions created in the spreadsheet on the website in my own spreadsheet so
that I can generate sunrise and sunset times for specific locations on
specific days. Any advice?

PS - if you happen to be interested in these things, I also came across a
useful program at http://www.fv01.dial.pipex.com/world.htm?suntimes.shtml

All the best.

Peter

"Richard Buttrey" wrote:

On Wed, 7 Sep 2005 10:10:07 -0700, "Peter Barrett"
wrote:

Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.


Try

http://www.ecy.wa.gov/programs/eap/models/

The 6th item down is an Excel Sunrise/Sunset calculator.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

On Fri, 9 Sep 2005 01:25:28 -0700, "Peter Barrett"
wrote:

Richard

That is indeed very helpful.

I am now trying to figure out if (and how) it is possible to use the
functions created in the spreadsheet on the website in my own spreadsheet so
that I can generate sunrise and sunset times for specific locations on
specific days. Any advice?


I suppose it depends on how detailed your spreadsheet is. If it was
reasonably straightforward I'd be inclined to take the entire
workbook from the site, (subject to any copyright notices and
accreditation requirements), and re-build your particular application
on top of it as a sort of front end.

If you've got specific locations that you use all the time, then you
could have a table of those locations, and link them to a drop down
ListBox in a new menu. When a choice is made from the menu, you could
get the macro to update the pre-existing cells of the sunrise/sunset
workbook. Ditto with selecting particular days or any other
parameters.


If you don't want to do that, then you could study the functions in
the workbook, pick out all the ones that are applicable and re-create
them in yiour current workbook.

I suspect on balance that you might find the first approach easier.

PS - if you happen to be interested in these things, I also came across a
useful program at http://www.fv01.dial.pipex.com/world.htm?suntimes.shtml

Thanks, I'll have a look shortly,

Regards


All the best.

Peter

"Richard Buttrey" wrote:

On Wed, 7 Sep 2005 10:10:07 -0700, "Peter Barrett"
wrote:

Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.


Try

http://www.ecy.wa.gov/programs/eap/models/

The 6th item down is an Excel Sunrise/Sunset calculator.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

"Peter Barrett" wrote in message
...
Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's
latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and
spend
ages formatting it.

Take a look at
http://personal.inet.fi/cool/jjlammi/stuff.html

Markus

Richard

Came to a similar conclusion about using the sunrise spreadsheet as a front
end to my spreadsheet.

Thanks for your ideas.

Peter

"Richard Buttrey" wrote:

On Fri, 9 Sep 2005 01:25:28 -0700, "Peter Barrett"
wrote:

Richard

That is indeed very helpful.

I am now trying to figure out if (and how) it is possible to use the
functions created in the spreadsheet on the website in my own spreadsheet so
that I can generate sunrise and sunset times for specific locations on
specific days. Any advice?


I suppose it depends on how detailed your spreadsheet is. If it was
reasonably straightforward I'd be inclined to take the entire
workbook from the site, (subject to any copyright notices and
accreditation requirements), and re-build your particular application
on top of it as a sort of front end.

If you've got specific locations that you use all the time, then you
could have a table of those locations, and link them to a drop down
ListBox in a new menu. When a choice is made from the menu, you could
get the macro to update the pre-existing cells of the sunrise/sunset
workbook. Ditto with selecting particular days or any other
parameters.


If you don't want to do that, then you could study the functions in
the workbook, pick out all the ones that are applicable and re-create
them in yiour current workbook.

I suspect on balance that you might find the first approach easier.

PS - if you happen to be interested in these things, I also came across a
useful program at http://www.fv01.dial.pipex.com/world.htm?suntimes.shtml

Thanks, I'll have a look shortly,

Regards


All the best.

Peter

"Richard Buttrey" wrote:

On Wed, 7 Sep 2005 10:10:07 -0700, "Peter Barrett"
wrote:

Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.


Try

http://www.ecy.wa.gov/programs/eap/models/

The 6th item down is an Excel Sunrise/Sunset calculator.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Markus

Thanks for responding.

I'll have a look at this site when I return home in a few days time.

All the best.

Peter

"Markus L" wrote:

"Peter Barrett" wrote in message
...
Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's
latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and
spend
ages formatting it.

Take a look at
http://personal.inet.fi/cool/jjlammi/stuff.html

Markus