Thanks for your help Mark.
In your example you are describing what I am trying to do; however, the value of Y does not need to be an integer.
Basically my main equation is Y = (280.46646 + (X * 36) + (X * (0.0003032^2)))
and if this gave us a result of Y=645.783; I would want to use the...
So than is this:
Y = (280.46646 + (X * 36) + (X * (0.0003032^2)))
- (⌊(280.46646 + (X * 36) + (X * (0.0003032^2))) / 360⌋ * 360)
the same as writing this...
Y = (280.46646 + (X * 36) + (X * (0.0003032^2))) (mod 360)
Any idea what the typical method would be in a scientific...
So I took a stab at it. I think that the two vertical bars around a variable or expression means the floor integer. Is this correct?
Z = 280.4+X*(36000.7 + X*0.0003032)
= z - (|z/360| * 360)
or all in one equation:
= z - (|(280.4+X*(36000.7 + X*0.0003032))/360| * 360)
Hi,
I'm trying to write out a set of equations I was using in an excel worksheet and am unsure how to represent a modulo function.
For example, is there a proper way to write out the following excel formula in mathematical terms?
=MOD(280.4+X*(36000.7 + X*0.0003032),360) *Where X...
Hello!
I have a difficult problem I have been working with recently. I have been trying to model the ever changing position of a solar PV array system. The system is a single axis tracker and orientates itself to have the smallest angle of incidence(AOI) to the suns beam as possible (the best...
Quinzio. I have downloaded a copy of Visual Basic Express 2010. I open a new Windows Fourms application and copy and paste your code but I can't seem to get it to work. Any ideas what I might be doing wrong?
Thanks again for all your help!
Hey!
Well I can't thank you enough for all of your help Quinzio. I am currently downloading visual basic (well XP SP3 first). I can't wait to try out the code!
This was a very good learning experience. I will let you know when I actually finish my excel sheet model and will post it if you are...
Sorry Tim,
I just realized when I uploaded, the file size was shrunk way too much. Let me see if I can ZIP the original and attach it. The only other way would be to go to:
http://www.numberempire.com/derivatives.php
and copy and paste the following into the form...
Tim,
I may require a little more guidance if you don't mind. I have a slightly different equation than I had in the previous posts as my initial equation was not correct. I have determined that...
So I was able to calculate azimuth from knowing the modules tilt angle with respect to the ground. I can't seem to be able to calculate the modules tilt angle from the azimuth though.
I think this is because I require information about both the gradient and the degrees of rotation about the...
Here is a copy of my excel sheet that shows my results and how I calculated them. If anyone is interested. I had to delete some of the bottom rows in order to shrink the file size to 100kb. You can just copy (drag and drop) the formulas down the sheet to get to 90 degrees. If you need help with...
Hey Quinzio,
Thank you for the help. I don't know if I did the best job explaining how my solar array operates; however, I noticed that the 51.4 degrees you calculated was awful close to my 51 (even though we were trying to calculate different things). I was able to use your azimuth formula...
Ok a bit of an update. I have been able to calculate the tilt and azimuth; however I had to use an angle I measured using Google Sketch-up. I'm hoping someone might be able to tell me where I can get this angle from. Anyways here is what I did step by step:
x-axis: North to South through array...
Thanks for the replies Quinzio and Stephen. This is indeed a lot to think about; however, I have all day! :)
I do have a real solar array set up with this kind of tracking system (single axis). My goal is to model PV array production for any clear sky day of the year. I also have been using...
Stephen,
You stated that I:
"The order of multiplication that use used implies that you first changed the location of the existing x,y and z axis by rotating that system about the y-axis.
Then you rotated the system again about the x-axis. However since this rotation is done after the first...