G Guest Oct 5, 2007 #1 Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL? Thanks.
J joeu2004 Oct 6, 2007 #3 Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL? Click to expand... I know nothing about Nash-Sutcliffe. But based on the Wikipedia entry [1], I think the following might work (untested): =1 - sumproduct((A1:A12 - B1:B12)^2) / sumproduct((A1:A12 - C1)^2) where C1 is: =average(A1:A12) and A1:A12 contains the observed discharges Qo, and B1:B12 contains the modeled discharges Qm. HTH. Endnotes: [1] http://en.wikipedia.org/wiki/Nash-Sutcliffe_efficiency_coefficient
Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL? Click to expand... I know nothing about Nash-Sutcliffe. But based on the Wikipedia entry [1], I think the following might work (untested): =1 - sumproduct((A1:A12 - B1:B12)^2) / sumproduct((A1:A12 - C1)^2) where C1 is: =average(A1:A12) and A1:A12 contains the observed discharges Qo, and B1:B12 contains the modeled discharges Qm. HTH. Endnotes: [1] http://en.wikipedia.org/wiki/Nash-Sutcliffe_efficiency_coefficient
S sac_82 Joined Mar 28, 2013 Messages 1 Reaction score 0 Mar 28, 2013 #4 yes correct. that EXCEL formaula works perfectly. Thanks
