I'm learning about solar PV following this paper ((PDF) Building-integrated photovoltaic and thermal applications in a subtropical hotel building) and trying to translate the equations for "Electrical performance of PV module" into Excel. I've inserted the constants into cells and tried to calculate Equations 1-6 but having trouble trying to translate Eq. 4 (I'm not sure if the other equations have been translated correctly as it involves using natural logs and exponents which I haven't used in Excel before. Any advice would be greatly appreciated.
| PV_model_v2.xlsm | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
| 1 | Electric charge on an electron (C) | Boltzmann Constant (J/K mol) | Reference temperature (K) | Voltage at maximum power point at reference values (V) | Open circuit voltage at reference values (V) | Number of series connected cells | Short circuit current at reference values (A) | Current at maximum power point (A) | Cell temperature (K) | Empirical constant relating to the impact of cell temperature on output | Number of parallel connected cells | Total annual Solar insolation (W/m2) | Reference insolation (W/m2) | Number of panels in surface | ||
| 2 | e | k | Tref | Vmp | Voc | n | Isc | Imp | Tc | Ct | m | Q | Qref | N | ||
| 3 | 1.60E-19 | 1.38E-23 | 298 | 12 | 21.6 | 16 | 6.13 | 5.78 | 298 | 10 | 16 | 1222468 | 1000 | 1 | ||
| 4 | ||||||||||||||||
| 5 | ||||||||||||||||
| 6 | Eq. 1 | Eq. 2 | Eq. 3 | Eq. 4 | Eq. 5 | Eq. 6 | ||||||||||
| 7 | diode factor | diode current (A) | Light generated current (A) | Voltage at the knee of I–V curve | Panel power output (kWh/m2) | Electricity generating efficiency (%) | ||||||||||
| 8 | DF | Io | IL | Vmpp | P | Ne | ||||||||||
| 9 | 10.87 | 0.00 | 468.36 | 0.00 | 0.00 | |||||||||||
Sheet1 | ||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A9 | A9 | =(A3/(B3*C3))*((D3-E3)/D3)*(1/LN((G3-H3)/G3)) |
| B9 | B9 | =(2^((I3-C3)/J3))*(G3/K3)*(1/((1-EXP(A3^(E3/F3))/(B3*C3*A9)))) |
| C9 | C9 | =(L3/M3)*(G3/K3) |
| E9 | E9 | =((D9*C9)-(D9*B9)*EXP(((A3*D9)/(B3*I3*A9))-1))*F3*K3*N3 |
| F9 | F9 | =(E9/L3)*100 |
