nash coefficient

[Narjes Chaabane Ben Salah]

Does anyone know an easy way to calculate Nash−Sutcliffe efficiency, rmse and pbias in

EXCEL?

Thanks

[Jim Almendinger]

You can paste this excel-vba code (attached) into a module in your spreadsheet and use the user-defined functions for these measures.  In all cases (I think) the functions require you to choose a range of observed values and a range of modeled values. 

I don't have RMSE, but it's the numerator in the RSR function, so you could copy the code and modify it pretty easily to make your own RMSE function. 

I'm sure these functions could be improved -- I only learn enough VBA bit by bit, as needed. 

-- Jim

---

From: "Narjes Chaabane Ben Salah" <narjes....@gmail.com>
To: swat...@googlegroups.com
Sent: Wednesday, July 30, 2014 5:47:41 AM
Subject: [SWAT-user:4916] nash coefficient

Does anyone know an easy way to calculate Nash−Sutcliffe efficiency, rmse and pbias in

EXCEL?

Thanks

--
You received this message because you are subscribed to the Google Groups "SWAT-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to swatuser+u...@googlegroups.com.
To post to this group, send email to swat...@googlegroups.com.
Visit this group at http://groups.google.com/group/swatuser.
For more options, visit https://groups.google.com/d/optout.

---

Spam
Not spam
Forget previous vote

--

Dr. James E. Almendinger
St. Croix Watershed Research Station
Science Museum of Minnesota
16910 152nd St N
Marine on St. Croix, MN  55047
tel: 651-433-5953 ext 19