Sunrise angle

[Giake]

Hello all,

I found this code on internet after long searching created by Nicholas Hebb and want make animation off a sunrise for solar panels.
I try to positioning the sun from 0° to angle A (when click on But1)
But the sun don’t want listen to me

Do you know how do it?

I made example about what i mean

Thank you to read this!

[MrShorty]

I would not approach this problem using "shapes" like he has. I probably would not even use any VBA at all.

I would use a scatter plot and geometry for this. If needed, I would start with this review of basic trig: http://www.mathsisfun.com/algebra/trigonometry.html Some have suggested that getting the trig right is the hardest part of this sort of thing, especially if it has been a while since you learned these basics in secondary school.

the basic idea is that, given the angle and an assumed length (radius, if you will, I would probably use a value of 1, so that the math will be easier), you can locate the sun on an XY scatter chart using the basic sine and cosine trig ratios. Then simply connect that point to the origin (0,0), and you have your elevation line drawn. The spreadsheet section would look something like:

Please Login or Register  to view this content.

Then select these four cells and insert a scatter chart (with marker and line). You may need to execute a "switch row column" if Excel decides to use the top row for the x data.

To add the "sun" shape as the marker, follow these directions http://www.techrepublic.com/blog/mic...g-excel-chart/

See how far that gets you.

[Giake]

Hello MrShorty,

The problem is that all my code is made in VBA (image example in xls file).

On this moment all is static but will like to make it in animation to have better idea what is happening.
Aniway I will take a look on the links!

Thank you very much

Sunrise.xls