Find Y, with X variable with set of data that forms bell curve.

friendoftheearth68

New Member
Joined
Dec 11, 2015
Messages
1
Hello All!

I'm creating a PV system design tool (for my own use, but I'd will post it open source afterward for folks to use).

Here is a portion of the data I'm working with:

TABLE 2: Minimum Radiation













Feb


Mar

Jan








RankAngleSolar Radiation
RankAngleSR
RankAngleSR
101.95
102.07
103.37
2222.62
2222.43
2233.78
3372.92
3372.55
4383.84
4523.06
5522.54
5533.71
6902.69
6902.01
6902.67
5573.07
4442.56
3343.84











101.95
102.07
103.37
2222.62
2222.43
2233.78
3372.92
3372.55
3343.84
4523.06
4442.56
4383.84
5573.07
5522.54
5533.71
6902.69
6902.01
6902.67

<tbody>
</tbody>


The "Angle" is the angle of the solar panel from the horizontal plain, facing in the direction of the equator, and the "Solar Radiation" numbers are (in very crude terms) how many hours/day I can expect my modules to produce power. (So for example, if I had a 1.5 kWh array set at a 52 degree angle, I can expect to produce about 4.59 kWh/day on average in January at that site.)

What I would like to be able to do is to enter an angle and receive an accurate prediction of what the solar radiation number would be. (BTW, notice the peak--or optimum angle--changes from month to month.)

If I could do this with a formula, it would make everything soooo much easier.

---

I should add that TREND and FORECAST don't seem to work because they are linear (? i think).
 
Last edited:

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,095,717
Messages
5,446,116
Members
405,381
Latest member
James W

This Week's Hot Topics

Top