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

[friendoftheearth68]

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="width: 960"]
<tbody>[TR]
[TD="colspan: 3"]TABLE 2: Minimum Radiation
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Feb[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Mar[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]Jan[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Rank[/TD]
[TD]Angle[/TD]
[TD]Solar Radiation[/TD]
[TD]
[/TD]
[TD]Rank[/TD]
[TD]Angle[/TD]
[TD]SR[/TD]
[TD]
[/TD]
[TD]Rank[/TD]
[TD]Angle[/TD]
[TD]SR[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.95[/TD]
[TD]
[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.07[/TD]
[TD]
[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.37[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2.62[/TD]
[TD]
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2.43[/TD]
[TD]
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]3.78[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]2.92[/TD]
[TD]
[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]2.55[/TD]
[TD]
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]3.84[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]3.06[/TD]
[TD]
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]2.54[/TD]
[TD]
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]3.71[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.69[/TD]
[TD]
[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.01[/TD]
[TD]
[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.67[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]3.07[/TD]
[TD]
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]2.56[/TD]
[TD]
[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]3.84[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1.95[/TD]
[TD]
[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.07[/TD]
[TD]
[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3.37[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2.62[/TD]
[TD]
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]2.43[/TD]
[TD]
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]3.78[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]2.92[/TD]
[TD]
[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]2.55[/TD]
[TD]
[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]3.84[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]3.06[/TD]
[TD]
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]2.56[/TD]
[TD]
[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]3.84[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]3.07[/TD]
[TD]
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]2.54[/TD]
[TD]
[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]3.71[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.69[/TD]
[TD]
[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.01[/TD]
[TD]
[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]2.67[/TD]
[/TR]
</tbody>[/TABLE]


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).