{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input","Data","Drainage","Vegetation","Irrigation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Input","index":0,"n_rows":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":false,"merged":[[20,0,22,2],[10,0,11,2],[10,3,11,5],[10,6,10,10],[11,6,11,10],[20,3,22,5],[20,6,20,10],[17,6,17,10],[18,6,18,10],[17,3,19,5],[12,0,19,2],[12,3,16,5],[22,6,22,10],[19,6,19,10],[21,6,21,10],[12,6,12,10],[13,6,13,10],[14,6,14,10],[15,6,15,10],[16,6,16,10],[4,0,7,2],[4,6,4,10],[5,6,5,10],[6,6,6,10],[4,3,6,5],[7,3,7,5],[7,6,7,10],[23,0,23,2],[24,3,26,5],[24,0,28,2],[27,3,27,5],[27,6,27,10],[28,6,28,10],[28,3,28,5],[24,6,24,10],[23,6,23,10],[23,3,23,5],[25,6,25,10],[26,6,26,10],[30,6,30,10],[29,0,38,2],[29,3,38,5],[29,6,29,10],[32,6,32,10],[33,6,33,10],[34,6,34,10],[36,6,36,10],[35,6,35,10],[31,6,31,10],[37,6,37,10],[38,6,38,10],[39,3,48,5],[39,6,39,10],[40,6,40,10],[41,6,41,10],[42,6,42,10],[43,6,43,10],[44,6,44,10],[45,6,45,10],[46,6,46,10],[47,6,47,10],[48,6,48,10],[49,3,58,5],[49,6,49,10],[50,6,50,10],[51,6,51,10],[52,6,52,10],[53,6,53,10],[54,6,54,10],[55,6,55,10],[56,6,56,10],[57,6,57,10],[58,6,58,10],[59,3,68,5],[59,6,59,10],[60,6,60,10],[61,6,61,10],[62,6,62,10],[63,6,63,10],[64,6,64,10],[65,6,65,10],[66,6,66,10],[67,6,67,10],[68,6,68,10]]}
[]
["IHMORS INPUT PARAMETERS"]
[null,"Project name:"]
[]
["GENERAL PROPERTIES FOR ALL CATCHMENT",null,null,"Temporal Information",null,null,"Meteorological data's time interval",null,null,null,null,"Dt","[h]"]
[null,null,null,null,null,null,"Modeling timeline (<Dt)",null,null,null,null,"dt","[h]"]
[null,null,null,null,null,null,"Time interval between events",null,null,null,null,"ts","[h]"]
[null,null,null,"Spatial Information",null,null,"Number of subarea",null,null,null,null,"nS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Put only the neccesary information for each subarea: ",1,2,3,4,5,6,7]
["LAND USE",null,null,"Decision parameters                       (1 yes, 0 no)",null,null,"Is the subarea waterproof?",null,null,null,null,"dw","--"]
[null,null,null,null,null,null,"Is there or will be there some kind of vegetation?",null,null,null,null,"dv","--"]
["OUTFLOW                        PARAMETERS",null,null,"Surface Hydrograph",null,null,"Slope",null,null,null,null,"s","[m/m]"]
[null,null,null,null,null,null,"Width",null,null,null,null,"w","[m]"]
[null,null,null,null,null,null,"Area",null,null,null,null,"A","[m2]"]
[null,null,null,null,null,null,"Manning's coefficient",null,null,null,null,"n","--"]
[null,null,null,null,null,null,"Surface storage depth",null,null,null,null,"D","[mm]"]
[null,null,null,"Subsurface Hydrograph",null,null,"Lag time",null,null,null,null,"τ","[h]"]
[null,null,null,null,null,null,"Linear reservoir parameter",null,null,null,null,"κ","--"]
[null,null,null,null,null,null,"Subsurface drainage factor for the last layer",null,null,null,null,"subfact","--"]
["IRRIGATION",null,null,"Irrigation                                                      (1 yes, 0 no)",null,null,"Is the subarea irrigated?",null,null,null,null,"di","--"]
[null,null,null,null,null,null,"The irrigation is furrow?",null,null,null,null,"dif"]
[null,null,null,null,null,null,"There is an irrigation plan?",null,null,null,null,"dip"]
["VEGETATION PROPERTIES",null,null,"Evapotranspiration/Interception",null,null,"Vegetation type",null,null,null,null,"v","--"]
["SOIL PROPERTIES",null,null,"Evaporation",null,null,"Readily evaporated water",null,null,null,null,"dREW","[mm]"]
[null,null,null,null,null,null,"Maximum crop coefficient",null,null,null,null,"Kcmax","--"]
[null,null,null,null,null,null,"Adjustment coefficient of 2nd evaporation stage",null,null,null,null,"β","--"]
[null,null,null,"Infiltration",null,null,"Initial cumulative infiltration",null,null,null,null,"F0","[mm]"]
[null,null,null,"Subsurface flow",null,null,"Number of layers of each subcatchment",null,null,null,null,"nL","--"]
["LAYERED VERTICAL SUBSURFACE FLOW",null,null,"LAYER 1",null,null,"Layer depth",null,null,null,null,"d","[m]"]
[null,null,null,null,null,null,"Initial soil water content",null,null,null,null,"θi","[m3m-3]"]
[null,null,null,null,null,null,"Residual soil water content",null,null,null,null,"θr","[m3m-3]"]
[null,null,null,null,null,null,"Saturated soil water content (Porosity)",null,null,null,null,"θs","[m3m-3]"]
[null,null,null,null,null,null,"Curve shape parameter",null,null,null,null,"nc","--"]
[null,null,null,null,null,null,"Empirical pore tortuosity",null,null,null,null,"L","--"]
[null,null,null,null,null,null,"Saturated hydraulic conductivity",null,null,null,null,"Ks","[mm/h]"]
[null,null,null,null,null,null,"Bubbling pressure",null,null,null,null,"ψb","[mm]"]
[null,null,null,null,null,null,"Wilting point",null,null,null,null,"θWP","[m3m-3]"]
[null,null,null,null,null,null,"Field capacity",null,null,null,null,"θFC","[m3m-3]"]
[null,null,null,"LAYER 2",null,null,"Layer depth",null,null,null,null,"d","[m]"]
[null,null,null,null,null,null,"Initial soil water content",null,null,null,null,"θi","[m3m-3]"]
[null,null,null,null,null,null,"Residual soil water content",null,null,null,null,"θr","[m3m-3]"]
[null,null,null,null,null,null,"Saturated soil water content (Porosity)",null,null,null,null,"θs","--"]
[null,null,null,null,null,null,"Curve shape parameter",null,null,null,null,"n","--"]
[null,null,null,null,null,null,"Empirical pore tortuosity",null,null,null,null,"L","--"]
[null,null,null,null,null,null,"Saturated hydraulic conductivity",null,null,null,null,"Ks","[mm/h]"]
[null,null,null,null,null,null,"Bubbling pressure",null,null,null,null,"ψb","[mm]"]
[null,null,null,null,null,null,"Wilting point",null,null,null,null,"θWP","[m3m-3]"]
[null,null,null,null,null,null,"Field capacity",null,null,null,null,"θFC","[m3m-3]"]
[null,null,null,"LAYER 3",null,null,"Layer depth",null,null,null,null,"d","[m]"]
[null,null,null,null,null,null,"Initial soil water content",null,null,null,null,"θi","[m3m-3]"]
[null,null,null,null,null,null,"Residual soil water content",null,null,null,null,"θr","[m3m-3]"]
[null,null,null,null,null,null,"Saturated soil water content (Porosity)",null,null,null,null,"θs","--"]
[null,null,null,null,null,null,"Curve shape parameter",null,null,null,null,"n","--"]
[null,null,null,null,null,null,"Empirical pore tortuosity",null,null,null,null,"L","--"]
[null,null,null,null,null,null,"Saturated hydraulic conductivity",null,null,null,null,"Ks","[mm/h]"]
[null,null,null,null,null,null,"Bubbling pressure",null,null,null,null,"ψb","[mm]"]
[null,null,null,null,null,null,"Wilting point",null,null,null,null,"θWP","[m3m-3]"]
[null,null,null,null,null,null,"Field capacity",null,null,null,null,"θFC","[m3m-3]"]
[null,null,null,"LAYER 4",null,null,"Layer depth",null,null,null,null,"d","[m]"]
[null,null,null,null,null,null,"Initial soil water content",null,null,null,null,"θi","[m3m-3]"]
[null,null,null,null,null,null,"Residual soil water content",null,null,null,null,"θr","[m3m-3]"]
[null,null,null,null,null,null,"Saturated soil water content (Porosity)",null,null,null,null,"θs","--"]
[null,null,null,null,null,null,"Curve shape parameter",null,null,null,null,"n","--"]
[null,null,null,null,null,null,"Empirical pore tortuosity",null,null,null,null,"L","--"]
[null,null,null,null,null,null,"Saturated hydraulic conductivity",null,null,null,null,"Ks","[mm/h]"]
[null,null,null,null,null,null,"Bubbling pressure",null,null,null,null,"ψb","[mm]"]
[null,null,null,null,null,null,"Wilting point",null,null,null,null,"θWP","[m3m-3]"]
[null,null,null,null,null,null,"Field capacity",null,null,null,null,"θFC","[m3m-3]"]

{"sheet":"Data","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["YYYY","MM","DD","HH","MM","P","Rn","T","RH","u","d"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Symbology"]
[null,null,null,null,null,null,null,null,null,null,null,null,"P","[mm]","Precipitation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rn","[MJm-2h-1]","Net Solar Radiation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"T","[°C]","Temperature"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RH","[--]","Relative Humidity"]
[null,null,null,null,null,null,null,null,null,null,null,null,"u","[ms-1]","Wind speed at 2 meters"]
[null,null,null,null,null,null,null,null,null,null,null,null,"d","[--]","1 if is day and 0 if is night"]

{"sheet":"Drainage","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Runoff percentage to downstream subareas or drainage system (street)"]
[null,"The subareas must be sorted downstream"]
[]
[]
[null,"FROM / TO","DRAINAGE SYSTEM",1]
[null,1]

{"sheet":"Vegetation","index":3,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":true,"merged":[[5,12,5,14],[5,15,6,15],[5,16,6,16],[6,0,7,0],[5,9,5,11],[5,5,5,8],[6,1,6,4]]}
[]
["Vegetation properties"]
[]
[]
[]
[null,null,null,null,null,"PERIOD [days]",null,null,null,"CROP COEFFICIENT",null,null,"VEGETATION COVERAGE [%]",null,null,"MAXIMUM WATER STORED [mm]","LEAF AREA INDEX"]
["Name","Harvest date",null,null,null,"Initial","Development","Mid season","Late season","Initial","Mid season","End","Initial","Mid Season","End"]
[null,"YYYY","MM","DD","HH","pini","pdev","pmid","plate","Kc ini","Kc mid","Kc end","Vc ini","Vc mid","Vc end","S","k"]

{"sheet":"Irrigation","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":true,"merged":[[10,1,10,2],[11,1,11,3]]}
[]
["Irrigation plans"]
[]
[null,"Exists three types of irrigation"]
[null,"P1","Fixed plan as an irrigation depth vs time table"]
[null,"P2","Fixed plan conditioned to soil moisture content at field capacity"]
[null,"P3","Fixed plan defined as a certain fraction of the previous 24 hours of evapotranspiration"]
[]
[]
[]
[null,"Irrigation type",null,1]
[null,"Daily Irrigation Frequency",null,null,null,null,null,"Month","Hour","Fraction"]
[null,1,"January",null,null,null,null,1]
[null,2,"February",null,null,null,null,2]
[null,3,"March",null,null,null,null,3]
[null,4,"April",null,null,null,null,4]
[null,5,"May",null,null,null,null,5]
[null,6,"June",null,null,null,null,6]
[null,7,"July",null,null,null,null,7]
[null,8,"August",null,null,null,null,8]
[null,9,"September",null,null,null,null,9]
[null,10,"October",null,null,null,null,10]
[null,11,"November",null,null,null,null,11]
[null,12,"December",null,null,null,null,12]