Hi,

I need the necessary data to do the following:

I am trying to create a drop down menu to do the following:

 

Select Country

Select State (for the country above)

Select City (for the state above)

Or by zip code if USA

Select Date

Then it will show me the exact HH:MM of Sunset for that location for that day.

 

Based on my research, the following variables are needed to do so:

 

Latitude  North, South

Longitude  East, West

Time Zone GMT

Daylight Savings Time = None

 

Basically, I need to have the necessary data and exact formula that I
can use to generate the HH:MM or sunset time only for a giving date
(sunrise time not needed)

 

User Input is only country/State/City or by zip code in case of USA

 

Please let me know if you can help me with the data and (excel style)
formula to calculate the HH:MM.

 

csv file, xls etc are all fine.

 

related sites I found:

1. (they do the exact concept that I need, but they add extra 18
minutes to the astronomical sunset time for religious reasons, would
need exactly their data and formula)

http://www.chabad.org/calendar/location.asp?AID=6226&c=86

2. same here:

http://www.candlelightingtimes.org/cgi-bin/calendar?header=y&day=0&Save=city#long

3. am not sure if they provide the formula that I need here or not (if
they do, I need it to be like excel style formula, or at least know
where to plug in the data)

http://www.phys.uu.nl/~strous/AA/en/reken/zonpositie.html

 

4. same as point 1 and 2, but non-religious.

http://aa.usno.navy.mil/data/docs/RS_OneYear.html

 

Thanks.

---

Clarification of Question by forexman-ga on 25 Mar 2006 21:35 PST

I already found the formula for that equation. however will still be
interested in data excel sheets of location and associate cordinates.
please contact me.

---

Clarification of Question by forexman-ga on 25 Mar 2006 22:37 PST

also found all the data i need. was that easy and all data for free,
just didnt have the time to search. dont understand why nobody wanted
to answer this question. will close this question. thanks.