Results 1 to 4 of 4

Sun path Diagram

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2023
    Location
    Thessaloniki, Greece
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    2

    Sun path Diagram

    Hello guys

    It is my first time i post a thread to this help forum.

    I want to plot the sun's path diagram in a polar coordinates .
    I cannot attach any links ,images and videos to show you the form of this diagram (αs i am new to this forum) but you can search it online.
    In order to plot the sun's path , you need two angles. The solar azimuth angle and the solar altitude angle.
    The azimuth angle takes values in the range (0,360) degrees , measured from north .
    The altitude angle takes values in the range (0,90) degrees . Sun altitude angle 0 degrees indicates sunrise or sunset and 90 degrees indicates that the sun is at the highest point of its orbit (zenith).
    Depending on the latitude, longitude, day of the year and time, these angles change.
    I have created an excel spreadsheet which takes into account the longitude , latitude and day of the year , and gives in two columns the above angles (for the desired day) , based on a time step of 10 minutes (from sunrise to sunset).
    I have attached an excel spreadsheet , which contains tow columns with the aforementioned angles for a specific location and year. It also contains pictures with the form of the diagram i want to plot.
    The are two types of lines in the diagram i want to plot.
    The azimuth lines , which are radial lines starting from the centre of the diagram and ending at its periphery .These lines measure the azimuth angle of the Sun.
    The altitude lines ,which are represented as concentric circular dotted lines that run from the center of the diagram out .These measure the altitude angle of the Sun.
    Can you help me plot this diagram ?

    Thank you
    Billis.
    Attached Files Attached Files
    Last edited by Billis Kyriakidis; 04-09-2023 at 04:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I prompt user to find path in excel and paste that path into my current VBA
    By chrispikekerry in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-20-2022, 02:30 PM
  2. VBA- Copy cells incl. Diagram and update diagram reference
    By Julian91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2018, 07:03 PM
  3. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  4. problem in line diagram- Messy line diagram
    By meus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-16-2014, 12:50 AM
  5. Replies: 1
    Last Post: 11-26-2013, 08:46 PM
  6. How to set GetOpenfile dialog start path to current open files path.
    By Michael Wise in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2010, 02:24 PM
  7. Replies: 7
    Last Post: 10-09-2009, 10:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1