Fitting net photosynthetic light-response curves with Microsoft Excel - a critical look at the models

Abstract

In this study, we presented the most commonly employed net photosynthetic light-response curves (P N/I curves) fitted by the Solver function of Microsoft Excel. Excel is attractive not only due to its wide availability as a part of the Microsoft Office suite but also due to the increased level of familiarity of undergraduate students with this tool as opposed to other statistical packages. In this study, we explored the use of Excel as a didactic tool which was built upon a previously published paper presenting an Excel Solver tool for calculation of a net photosynthetic/chloroplastic CO2-response curve. Using the Excel spreadsheets accompanying this paper, researchers and students can quickly and easily choose the best fitted P N/I curve, selecting it by the minimal value of the sum of the squares of the errors. We also criticized the misuse of the asymptotic estimate of the maximum gross photosynthetic rate, the light saturation point estimated at a specific percentile of maximum net photosynthetic rate, and the quantum yield at zero photosynthetic photon flux density and we proposed the replacement of these variables by others more directly linked to plant ecophysiology.