Hi guys,
I am trying to calculate the area under the curve on my Power-Time graph so that I can determine the energy.
Would anyone have an idea of how I can calculate the area under the curve? The solution would also have to ignore cells with #N/A. Would I also be able to choose a specific time range for this area?
Shown below is a very small sample of my data:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thanks,
David
I am trying to calculate the area under the curve on my Power-Time graph so that I can determine the energy.
Would anyone have an idea of how I can calculate the area under the curve? The solution would also have to ignore cells with #N/A. Would I also be able to choose a specific time range for this area?
Shown below is a very small sample of my data:
Time | Engine Power |
(min) | (kW) |
0.000000 | #N/A |
0.000383 | 4.04 |
0.001017 | 4.12 |
0.001033 | #N/A |
0.001700 | #N/A |
0.001717 | #N/A |
0.002350 | #N/A |
0.002383 | 4.09 |
0.003067 | 4.09 |
0.003083 | #N/A |
0.003917 | #N/A |
0.003933 | #N/A |
0.004433 | 4.13 |
0.004967 | #N/A |
0.004983 | #N/A |
0.005517 | 4.06 |
0.005533 | #N/A |
0.005933 | #N/A |
0.005950 | #N/A |
0.006483 | 4.02 |
0.006967 | #N/A |
0.006983 | #N/A |
0.007433 | 4.09 |
0.007450 | #N/A |
0.007967 | 4.05 |
0.008500 | 4.09 |
0.008933 | #N/A |
0.008950 | #N/A |
0.009417 | #N/A |
0.009433 | #N/A |
0.009917 | 4.05 |
0.009933 | #N/A |
0.010550 | #N/A |
0.010567 | #N/A |
0.011250 | #N/A |
0.011267 | #N/A |
0.01 | #N/A |
0.01 | 4.09 |
0.01 | 4.01 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Thanks,
David