{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","precipitation_data","evapotranspiration_data"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,8],[1,9,1,10],[2,7,2,10],[3,1,3,9],[4,1,4,9],[3,10,4,10],[5,1,5,7],[5,8,5,10],[6,1,6,10],[7,1,7,10],[8,1,8,8],[8,9,8,10],[9,1,9,6],[9,7,9,10],[10,1,10,6],[10,7,10,10],[11,1,11,8],[11,9,11,10],[17,1,17,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[12,7,20,10],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6]]}
[]
[null,"Instruction on how to use the excel sheet to calculate some validation metrics"]
[]
[null,"1.      Fill the name, latitude and longitude of the gauging station in cells B1 to B3"]
[null,"2.      Prepare the monthly data (precipitation and evapotranspiration) from gauging stations"]
[null,"3.      Extract monthly WaPOR data for the location of the gauging station"]
[null,"4.      Put the data for each variable on the respective sheet. Precipitation data on the precipitation_data"]
[null," worksheet and evapotranspiration data on the evapotranspiration_data worksheet"]
[null,"5.      Make sure the date should be in column A starting from the 6th row (cell A6)"]
[null,"6.      The gauge data on column B starting from 6th row (cell B6)"]
[null,"7.      The RS data on column C starting from 6th row (cell C6)"]
[null,"8.      The evaluation metrics and the figures update automatically when the data changes"]
[null,"9.      Macro should be enabled for the metrics to be calculated"]
[null,"10.   The following metrics are metrics calculated"]
[null,"a.        Pearson’s correlation coefficient (CC)"]
[null,"b.       Coefficient of determination (R2)"]
[null,"c.        Nash-Sutcliffe Efficiency (NSE)"]
[null,"d.       Kling-Gupta Efficiency (KGE)"]
[null,"e.       Bias"]
[null,"f.         Root mean square error (RMSE)"]
[null,"g.        Mean Absolute error (MAE)"]

{"sheet":"precipitation_data","index":1,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Station_name","Addis Ababa"]
["Latitude",9.0190000000000001]
["Longitude",38.747]
["unit ","mm/month",null,null,"Number of data points",{"$f":"COUNTA(B6:INDEX(B:B,LOOKUP(2,1/(B:B<>\"\"),ROW(B:B))))","v":48}]
["Date","Station_data","RS_data",null,"Evaluation metrics"]
["2011-01-01",14.1,20.299804999999999,null,"Pearson’s correlation coefficient (CC)",{"$f":"ROUND(PEARSON(B6:B53,C6:C53),2)","v":0.93}]
["2011-02-01",13.1,12.599608999999999,null,"Coefficient of determination (R2)",{"$f":"ROUND(PEARSON(B6:B53,C6:C53)^2,2)","v":0.87}]
["2011-03-01",44.3,58.799804999999999,null,"Nash-Sutcliffe Efficiency (NSE)",{"$f":"ROUND(fit_NSE(B6:B53,C6:C53),2)","v":0.87}]
["2011-04-01",22.8,94.200194999999994,null,"Kling-Gupta Efficiency (KGE)",{"$f":"ROUND(fit_KGE(B6:B53,C6:C53),2)","v":0.9}]
["2011-05-01",66.099999999999994,47.799804999999999,null,"Bias",{"$f":"ROUND(fit_mbe(B6:B53,C6:C53),2)","v":-1.89}]
["2011-06-01",182,141.40038999999999,null,"Root mean square error (RMSE)",{"$f":"ROUND(fit_rmse(B6:B53,C6:C53),2)","v":38.229999999999997}]
["2011-07-01",180.9,305.90039999999999,null,"Mean Absolute error (MAE)",{"$f":"ROUND(fit_mae(B6:B53,C6:C53),2)","v":26.42}]
["2011-08-01",340.8,336]
["2011-09-01",146,201.09961000000001]
["2011-10-01",0,13.200195000000001]
["2011-11-01",42.3,11.599608999999999]
["2011-12-01",0,7.4003905999999997]
["2012-01-01",0,12.799804999999999]
["2012-02-01",0,7]
["2012-03-01",15.8,51.400390000000002]
["2012-04-01",71.400000000000006,110.09961]
["2012-05-01",50.2,26.5]
["2012-06-01",69.400000000000006,81]
["2012-07-01",324.2,287.40039999999999]
["2012-08-01",298,296.5]
["2012-09-01",215.5,189.2002]
["2012-10-01",2.2999999999999998,16.5]
["2012-11-01",0,6]
["2012-12-01",9.8000000000000007,17.400390000000002]
["2013-01-01",4.4000000000000004,11.799804999999999]
["2013-02-01",0,7.5]
["2013-03-01",46.9,43.900390000000002]
["2013-04-01",92.3,93.200194999999994]
["2013-05-01",85,38.099609999999998]
["2013-06-01",153.19999999999999,110.79980500000001]
["2013-07-01",227.6,287.2002]
["2013-08-01",353.2,276.09960000000001]
["2013-09-01",196.3,158.2998]
["2013-10-01",58.4,65.400390000000002]
["2013-11-01",22.3,9.7998049999999992]
["2013-12-01",0,6.4003905999999997]
["2014-01-01",1.7,12.299804999999999]
["2014-02-01",47.4,23.400390000000002]
["2014-03-01",61.5,49.200195000000001]
["2014-04-01",21.6,49.799804999999999]
["2014-05-01",93,46.099609999999998]
["2014-06-01",66.7,48.799804999999999]
["2014-07-01",218.5,192.2998]
["2014-08-01",259.5,237.2998]
["2014-09-01",263.7,138.59961000000001]
["2014-10-01",15.2,38.299804999999999]
["2014-11-01",1.7,0]
["2014-12-01",0,11.700195000000001]

{"sheet":"evapotranspiration_data","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Station_name","Addis Ababa"]
["Latitude",9.0190000000000001]
["Longitude",38.747]
["unit ","mm/month",null,null,"Number of data points",{"$f":"COUNTA(B6:INDEX(B:B,LOOKUP(2,1/(B:B<>\"\"),ROW(B:B))))","v":48}]
["Date","Station_data","RS_data",null,"Evaluation metrics"]
["2011-01-01",14.1,20.299804999999999,null,"Pearson’s correlation coefficient (CC)",{"$f":"ROUND(PEARSON(B6:B53,C6:C53),2)","v":0.93}]
["2011-02-01",13.1,12.599608999999999,null,"Coefficient of determination (R2)",{"$f":"ROUND(PEARSON(B6:B53,C6:C53)^2,2)","v":0.87}]
["2011-03-01",44.3,58.799804999999999,null,"Nash-Sutcliffe Efficiency (NSE)",{"$f":"ROUND(fit_NSE(B6:B53,C6:C53),2)","v":0.87}]
["2011-04-01",22.8,94.200194999999994,null,"Kling-Gupta Efficiency (KGE)",{"$f":"ROUND(fit_KGE(B6:B53,C6:C53),2)","v":0.9}]
["2011-05-01",66.099999999999994,47.799804999999999,null,"Bias",{"$f":"ROUND(fit_mbe(B6:B53,C6:C53),2)","v":-1.89}]
["2011-06-01",182,141.40038999999999,null,"Root mean square error (RMSE)",{"$f":"ROUND(fit_rmse(B6:B53,C6:C53),2)","v":38.229999999999997}]
["2011-07-01",180.9,305.90039999999999,null,"Mean Absolute error (MAE)",{"$f":"ROUND(fit_mae(B6:B53,C6:C53),2)","v":26.42}]
["2011-08-01",340.8,336]
["2011-09-01",146,201.09961000000001]
["2011-10-01",0,13.200195000000001]
["2011-11-01",42.3,11.599608999999999]
["2011-12-01",0,7.4003905999999997]
["2012-01-01",0,12.799804999999999]
["2012-02-01",0,7]
["2012-03-01",15.8,51.400390000000002]
["2012-04-01",71.400000000000006,110.09961]
["2012-05-01",50.2,26.5]
["2012-06-01",69.400000000000006,81]
["2012-07-01",324.2,287.40039999999999]
["2012-08-01",298,296.5]
["2012-09-01",215.5,189.2002]
["2012-10-01",2.2999999999999998,16.5]
["2012-11-01",0,6]
["2012-12-01",9.8000000000000007,17.400390000000002]
["2013-01-01",4.4000000000000004,11.799804999999999]
["2013-02-01",0,7.5]
["2013-03-01",46.9,43.900390000000002]
["2013-04-01",92.3,93.200194999999994]
["2013-05-01",85,38.099609999999998]
["2013-06-01",153.19999999999999,110.79980500000001]
["2013-07-01",227.6,287.2002]
["2013-08-01",353.2,276.09960000000001]
["2013-09-01",196.3,158.2998]
["2013-10-01",58.4,65.400390000000002]
["2013-11-01",22.3,9.7998049999999992]
["2013-12-01",0,6.4003905999999997]
["2014-01-01",1.7,12.299804999999999]
["2014-02-01",47.4,23.400390000000002]
["2014-03-01",61.5,49.200195000000001]
["2014-04-01",21.6,49.799804999999999]
["2014-05-01",93,46.099609999999998]
["2014-06-01",66.7,48.799804999999999]
["2014-07-01",218.5,192.2998]
["2014-08-01",259.5,237.2998]
["2014-09-01",263.7,138.59961000000001]
["2014-10-01",15.2,38.299804999999999]
["2014-11-01",1.7,0]
["2014-12-01",0,11.700195000000001]