Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2014, 08:23 PM
shanemarkley shanemarkley is offline Shadow Position Windows 7 64bit Shadow Position Office 2010 64bit
Novice
Shadow Position
 
Join Date: Dec 2013
Posts: 29
shanemarkley is on a distinguished road
Default Shadow Position

I am working on creating a spreadsheet that is going to calculate the most ideal position someone should be laying in for the maximum sun exposure based on time, day of the year, time zone and GPS/LAT/LON.

I am working on building a program that ingests these items, and references the Solar Azmuth Angle (which direction the sun is) along with the Solar Zenith Angle (how high the sun is), and spit out a direction (180 through -180), we could show that graphically on a simple 360 dial interface.

Maybe most of the work is done here already, but I am not sure how to incorporate it into a program/Excel document: http://www.nrel.gov/midc/solpos/spa.html.

Below is the basic breakdown I have in a spread sheet. I am using the LAT/LONG of my house @ 12pm today. Just need to figure out what calculations to plug in to figure out where the arrow would be pointing to tell people where to lay their feet. I am thinking along the lines of the time on a clock (e.g 3pm). Not super worried about the adding the elevation part into the equation right now. It would just be a "wish list" item.

Input
LAT 40.8062861


LONG -77.9249305
Time 12:00
Time Zone EST
Elevation ???

Output
Feet
Head

Let me know if you anyone has any thoughts on this.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
change shadow distance cheech1981 Word VBA 2 02-14-2014 06:02 PM
Shadow Position Hyperlink goes to wrong position Stephen0352 Word 6 10-03-2012 04:41 AM
Shadow Position VBA: how can I know the position on a document? tinfanide Excel Programming 3 02-27-2012 03:24 PM
fix position for a segment in a doc tai Word 3 10-20-2011 01:04 PM
Pictures Not Staying In Position BrazzellMarketing Word 3 10-06-2011 06:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft