{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Description","Rainfall_Profile","ARF","Summary","CN","TC","Peakflow","Flood_Hydrogrpah"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Flood_Hydrogrpah","index":7,"reason":"not_a_worksheet"}],"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":"Description","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,3,9,13],[10,3,10,13],[3,2,3,13],[4,2,4,13],[5,2,5,13],[6,2,6,13],[8,3,8,13]]}
[]
[null,"Description of Tools and Processes"]
[]
[null,0,"Tool Structure: The tool is provided in  5 wroksheets for calculating Curve Number (CN), Time of Concentration (Tc), Peak flood (Qp) and display hydrogrpahs and the results is provided in Summary Sheet"]
[null,1,"Curve Numbwer (CN): Calculation of  CN for average Antecedent Moisture Condition (AMC II) Land use/land cover (LULC). Exhaustive LULC types are included to enable selection. The LULC types in the list may not exactly match with the LULC  types of the catchment. Hence, care should be taken to select comparable LULC types"]
[null,null,"Select the LULC data from drop-down menu. The #N/A in Columns F&G indicates that there is no such combination of the LULC (Column B), Treatment type (Column C) and Hydrologic condition (Column D) and revise your selection. The  proportion of area covered by each LULC should be etered from keyboard. Options are provided in Peakflow Sheet to select AMC II or AMC III."]
[null,2,"Time of concentration (Tc): As explained in SSIGL 3, option is provided to enable consider or ignore Tc for overland flow (Kerby method).  Note that considering overland flow will increase time of TC and hence reduce peak flood."]
[null,3,"Peak flow (Qp)"]
[null,null,"a","The tool considers two cases for cartchmenrt size. Hydrograph  is included for catchment area of  up to 10 sq.km while ordinates of composite hydrographs are included for for catchemnts areas above the indicated area. "]
[null,null,"b","Rainfall profile: Two options are provided. Rainfall profile can be entered from keyboard if data is availanble. If not, Type II rainfall distribution is provided in a chart (rainfall profile sheet) and data can be read from the chart corresponding to the excess rainfall duration and entered in the appropriate column. Alternatively, a formula developed from the chart cand be used.  "]
[null,null,"c","Area reduction factor (ARF):  Similalry, if data is avalibale, that will be the first option, if not ARF can be selected from the ARF Table (ARF sheet) and entered in the appropriate column. The send option is to use an empirical formula. "]
[null,4,"Hydrograph: Flood hydrograph is displayed for catchemnt area above 10 km2"]
[null,5,"Data Entry: Yellow-shaded cells are for data entry from keyboard"]
[null,6,"Selection: Green-shaded cells are for data selection from drop-down menu"]
[null,7,"Other colors are for calculalions"]
[]
[null,null,"Contact for More Info and Comments ",null,null,null,null,null,null,"GIRDC, 2018"]
[null,null,"NB: Do not Erase linked Formulas",null,null,null,null,null,null,"Addis Ababa, Ethiopia"]

{"sheet":"Rainfall_Profile","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["NB: Rainfall distribution, type II"]
[]
[null,"Time (hr)","Rainfall profile"]
[null,{"$f":"5/60","v":8.3333333333333329E-2},10.849055812149587]
[null,{"$f":"10/60","v":0.16666666666666666},20.656395269892254]
[null,{"$f":"15/60","v":0.25},26.393321084514671]
[null,{"$f":"25/60","v":0.41666666666666669},33.620992835179678]
[null,{"$f":"30/60","v":0.5},38.200660542257339]
[null,{"$f":"60/60","v":1},46.008000000000003]
[null,{"$f":"120/60","v":2},53.815339457742667]
[null,{"$f":"180/60","v":3},60.552265272365091]
[null,{"$f":"240/60","v":4},66.622678915485338]
[null,5,69.779937023030087]
[null,6,72.359604730107748]
[null,7,74.54068269898363]
[null,8,77.430018373227995]
[null,9,79.096530544730172]
[null,10,80.587276480772758]
[null,11,82.935820214824147]
[null,12,84.1]
[null,15,89.05]
[null,18,93.24]
[null,{"$f":"1440/60","v":24},100]

{"sheet":"ARF","index":2,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,2,14]]}
[]
["NB: Areal to point rainfall ratio (%) - Area Reduction Factor ARF"]
[null,"Area","Duration (hr)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duration hours"]
[null,"(km2)",0.5,1,2,3,4,5,6,9,12,15,18,21,24,null,null,"Goli SSIP, km2",1,2,3,4,5,6]
[null,25,88,78,82,85,87,88,88,91,92,93,93,94,94,null,null,27.17,{"$f":"$R$5*D5/$B$5","v":84.770400000000009},{"$f":"$R$5*E5/$B$5","v":89.117599999999996},92.378000000000014,94.551599999999993,95.638400000000004,95.638400000000004]
[null,50,61,71,78,82,84,85,87,89,90,91,92,92,93]
[null,75,57,67,75,79,82,84,83,87,89,90,91,91,92,null,null,null,":. One can calculate with respect to study area size"]
[null,100,54,65,73,78,80,82,83,86,88,89,90,91,91]
[null,125,52,63,72,76,79,81,82,85,87,88,89,90,91]
[null,150,50,61,70,75,78,80,81,84,86,88,89,89,90]
[null,175,48,59,69,74,77,79,81,84,86,87,88,89,90]
[null,200,46,58,68,73,76,78,80,83,85,87,88,88,89]
[null,225,45,57,57,72,75,77,72,82,85,86,87,88,89]
[null,250,44,55,66,71,74,77,78,82,84,86,87,88,88]
[null,275,42,54,65,70,74,76,78,81,84,85,86,87,88]
[null,300,41,53,54,70,73,75,77,81,83,85,86,87,88]
[null,325,40,53,63,58,72,73,77,80,83,84,86,87,87]
[null,350,38,52,63,68,72,74,76,80,82,84,85,86,87]
[null,375,39,51,62,68,71,74,78,80,82,84,85,86,87]
[null,400,38,50,61,67,71,73,75,79,82,83,85,86,87]
[null,425,37,50,61,67,70,73,75,79,81,83,84,85,86]
[null,450,36,49,60,66,70,72,74,79,81,83,84,85,86]
[null,475,36,48,60,66,69,72,74,78,81,83,84,85,86]
[null,500,35,48,59,66,69,72,74,78,80,82,84,85,86]
[null,525,34,47,59,65,68,71,73,78,80,82,83,85,85]
[null,550,34,47,58,64,68,71,73,77,80,82,83,84,85]
[null,575,33,46,58,64,68,71,73,77,80,82,83,84,85]
[null,600,33,45,57,63,67,71,72,77,79,81,83,84,85]
[null,625,32,45,57,63,67,70,72,76,79,81,83,84,85]
[null,650,32,45,56,63,67,70,72,76,79,81,82,84,84]
[null,675,31,44,56,62,66,69,71,76,79,81,82,83,84]
[null,700,31,44,56,62,66,69,71,76,78,80,82,83,84]
[null,725,31,43,55,62,66,69,71,75,78,80,82,83,84]
[null,750,30,43,55,61,65,68,71,75,78,80,82,83,84]

{"sheet":"Summary","index":3,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["NB: Design Flood Analysis"]
[null,"Date: ",{"$f":"TODAY()","v":"2018-12-06"}]
[null,"Analysis Made By: "]
[null,"Parameter Description","Value"]
[null,"Name of Project","Goli SSIP"]
[null,"Region","Oromia"]
[null,"Zone","West Shoa"]
[null,"Woreda","Ejere (Addis Alem)"]
[null,"Kebele","-"]
[null,"Name of Catchment","Goli watershed"]
[null,"Name of river (if different from cartchment)"]
[null,"Catchment area (sq.km)",{"$f":"Peakflow!C11","v":27.17}]
[null,"Length of rivwr/stream (km)",{"$f":"MAX(TC!C5:C19)","v":12.17}]
[null,"Maximum elevation of the river/stream (m)",{"$f":"MAX(TC!D5:D19)","v":2521}]
[null,"Minimum elevation of the river/stream (m)",{"$f":"MIN(TC!D5:D19)","v":2133}]
[null,"Average slope of the river/stream (%)",{"$f":"(C15-C16)/C14/10","v":3.188167625308135}]
[null,"Design return period (years)",{"$f":"Peakflow!C9","v":50}]
[null,"24-hr maximum point rainfall",{"$f":"Peakflow!C10","v":192.13}]
[null,"Time of concentration (hr)",{"$f":"Peakflow!C12","v":3.928277900193363}]
[null,"Unit rainfall duration (hr)",{"$f":"Peakflow!C13","v":1}]
[null,"Curve Number for AMC II",{"$f":"Peakflow!C17","v":0.82001539171788251}]
[null,"Areal Rainfall (mm)",{"$f":"Peakflow!C21","v":20.934732235982754}]
[null,"Curve Number for AMC II",{"$f":"Peakflow!C19","v":51.3}]
[null,"Maximum retention potential (mm)",{"$f":"Peakflow!C20","v":241.12670565302147}]
[null,"Runoff (mm)",{"$f":"Peakflow!C21","v":20.934732235982754}]
[null,"Peak flow rate per mm of runoff (cms/mm)",{"$f":"Peakflow!C22","v":1.9780979318542946}]
[null,"Peak flood (cms)",{"$f":"Peakflow!C23","v":32.300000000000004}]

{"sheet":"CN","index":4,"n_rows":90,"n_cols":28,"rows_kept":90,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,19,6,19],[5,5,6,5],[5,6,6,6],[5,13,5,16],[5,7,6,7]]}
[]
["NB: CN Computation"]
[null,null,"Enter Data Manually in Yellow Cells"]
[null,null,"Select Data from Drop-Down Menu in Green Cells"]
[]
[null,"Soils Group","Land use","Treatment","Hydrologic Condition","Area proportion (Decimal or %)","CNp","Weighted CNw",null,null,null,null,null,"Hydrologic soil group",null,null,null,null,null,"LUTI","Land cover","Treatment","Infiltration","Combined","A","B","C","D"]
[null,null,null,null,null,null,null,null,null,"Cover Type","Treatment**","Hydrologic Condition",null,"A","B","C","D",null,"Drow-down menu",null,"Fallow",null,null,{"$f":"IF(U7=\"\",U$7&V7&W7,U7&V7&W7)","v":"Fallow"},77,86,91,94]
[null,"A","Farms building and lanes",null,null,30,{"$f":"IF(T8=\"\",0,VLOOKUP(T8,M$8:Q$90,2,FALSE))","v":59},{"$f":"IF(F8>1,F8*G8/100,F8*G8)","v":17.7},null,"Fallow","Bare soil","Poor",{"$f":"IF(J8=\"\",J$8&K8&L8,J8&K8&L8)","v":"FallowBare soilPoor"},77,86,91,94,null,"Fallow",{"$f":"C8&D8&E8","v":"Farms building and lanes"},"Wasteland","Straight row",null,{"$f":"IF(U8=\"\",U$7&V8&W8,U8&V8&W8)","v":"WastelandStraight row"},77,86,91,94]
[null,null,"Brush weed grass",null,null,70,48,{"$f":"IF(F9>1,F9*G9/100,F9*G9)","v":33.6},null,null,"CR","Poor",{"$f":"IF(J9=\"\",J$8&K9&L9,J9&K9&L9)","v":"FallowCRPoor"},76,85,90,93,null,"Row crops",{"$f":"C9&D9&E9","v":"Brush weed grass"},"Row crops","Straight row","Poor",{"$f":"IF(U9=\"\",U$9&V9&W9,U9&V9&W9)","v":"Row cropsStraight rowPoor"},72,81,88,91]
[null,null,null,null,null,null,{"$f":"IF(T10=\"\",0,VLOOKUP(T10,M$8:Q$90,2,FALSE))","v":0},{"$f":"IF(F10>1,F10*G10/100,F10*G10)","v":0},null,null,"CR","Good",{"$f":"IF(J10=\"\",J$8&K10&L10,J10&K10&L10)","v":"FallowCRGood"},74,83,88,90,null,"Small Grain",{"$f":"C10&D10&E10","v":""},null,"Straight row","Good","Row cropsStraight rowGood",67,78,85,89]
[null,null,null,null,null,null,{"$f":"IF(T11=\"\",0,VLOOKUP(T11,M$8:Q$90,2,FALSE))","v":0},0,null,"Row crops","SR","Poor",{"$f":"IF(J11=\"\",J$11&K11&L11,J11&K11&L11)","v":"Row cropsSRPoor"},72,81,88,91,null,"Meadow",{"$f":"C11&D11&E11","v":""},null,"Contoured","Poor","Row cropsContouredPoor",70,79,84,88]
[null,"Sub Total",null,null,null,{"$f":"SUM(F8:F11)","v":100},null,{"$f":"SUMPRODUCT(H8:H11)","v":51.3},null,null,"SR","Good",{"$f":"IF(J12=\"\",J$11&K12&L12,J12&K12&L12)","v":"Row cropsSRGood"},67,78,85,89,null,"Pasture-grass",null,null,"Contoured","Good","Row cropsContouredGood",65,75,82,86]
[null,"B",null,null,null,null,{"$f":"IF(T13=\"\",0,VLOOKUP(T13,M$8:Q$90,3,FALSE))","v":0},0,null,null,"SR+CR","Poor","Row cropsSR+CRPoor",71,80,87,90,null,"Brush weed grass",{"$f":"C13&D13&E13","v":""},null,"Contoured and treated","Poor","Row cropsContoured and treatedPoor",66,74,80,82]
[null,null,null,null,null,null,{"$f":"IF(T14=\"\",0,VLOOKUP(T14,M$8:Q$90,3,FALSE))","v":0},0,null,null,"SR+CR","Good","Row cropsSR+CRGood",64,75,82,85,null,"Woods-grass",{"$f":"C14&D14&E14","v":""},null,"Contoured and treated","Good","Row cropsContoured and treatedGood",62,71,78,81]
[null,null,null,null,null,null,{"$f":"IF(T15=\"\",0,VLOOKUP(T15,M$8:Q$90,3,FALSE))","v":0},0,null,null,"C","Poor","Row cropsCPoor",70,79,84,88,null,"Woodland",{"$f":"C15&D15&E15","v":""},"Small Grains","Straight row","Poor",{"$f":"IF(U15=\"\",U$15&V15&W15,U15&V15&W15)","v":"Small GrainsStraight rowPoor"},65,76,84,88]
[null,null,null,null,null,null,{"$f":"IF(T16=\"\",0,VLOOKUP(T16,M$8:Q$90,3,FALSE))","v":0},0,null,null,"C","Good","Row cropsCGood",65,75,82,86,null,"Farms building and lanes",{"$f":"C16&D16&E16","v":""},null,"Straight row","Good","`",63,75,83,87]
[null,"Sub Total",null,null,null,{"$f":"SUM(F13:F16)","v":0},null,{"$f":"SUM(H13:H16)","v":0},null,null,"C+CR","Poor","Row cropsC+CRPoor",69,78,83,87,null,"Mix grass weeds and brush",null,null,"Countered","Poor",{"$f":"IF(U17=\"\",U$15&V17&W17,U17&V17&W17)","v":"Small GrainsCounteredPoor"},63,74,82,85]
[null,"C",null,null,null,null,{"$f":"IF(T18=\"\",0,VLOOKUP(T18,M$8:Q$90,4,FALSE))","v":0},0,null,null,"C+CR","Good","Row cropsC+CRGood",64,74,81,85,null,"Mount brush-small trees",{"$f":"C18&D18&E18","v":""},null,"Countered","Good",{"$f":"IF(U18=\"\",U$15&V18&W18,U18&V18&W18)","v":"Small GrainsCounteredGood"},61,73,81,84]
[null,null,null,null,null,null,{"$f":"IF(T19=\"\",0,VLOOKUP(T19,M$8:Q$90,4,FALSE))","v":0},0,null,null,"C & T","Poor","Row cropsC & TPoor",66,74,80,82,null,"Small trees grass",{"$f":"C19&D19&E19","v":""},null,"Contoured and treated","Poor",{"$f":"IF(U19=\"\",U$15&V19&W19,U19&V19&W19)","v":"Small GrainsContoured and treatedPoor"},61,72,79,82]
[null,null,null,null,null,null,{"$f":"IF(T20=\"\",0,VLOOKUP(T20,M$8:Q$90,4,FALSE))","v":0},0,null,null,"C&T","Good","Row cropsC&TGood",62,71,78,81,null,"Brush-grass understory",{"$f":"C20&D20&E20","v":""},null,"Contoured and treated","Good",{"$f":"IF(U20=\"\",U$15&V20&W20,U20&V20&W20)","v":"Small GrainsContoured and treatedGood"},59,70,78,81]
[null,null,null,null,null,null,{"$f":"IF(T21=\"\",0,VLOOKUP(T21,M$8:Q$90,4,FALSE))","v":0},0,null,null,"C & T+CR","Poor","Row cropsC & T+CRPoor",65,73,79,81,null,"Desert shrub brush",{"$f":"C21&D21&E21","v":""},"Pasture",null,"Poor",{"$f":"IF(U21=\"\",U$21&V21&W21,U21&V21&W21)","v":"PasturePoor"},68,79,86,89]
[null,"Sub Total",null,null,null,{"$f":"SUM(F18:F21)","v":0},null,{"$f":"SUM(H18:H21)","v":0},null,null,"C & T+CR","Good","Row cropsC & T+CRGood",61,70,77,80,null,"Open space ",null,null,null,"Fair","PastureFair",49,69,79,84]
[null,"D",null,null,null,null,{"$f":"IF(T23=\"\",0,VLOOKUP(T23,M$8:Q$90,5,FALSE))","v":0},0,null,"Small Grain","SR","Poor",{"$f":"IF(J23=\"\",J$23&K23&L23,J23&K23&L23)","v":"Small GrainSRPoor"},65,76,84,88,null,"Impervious areas",{"$f":"C23&D23&E23","v":""},null,null,"Good","PastureGood",39,61,74,80]
[null,null,null,null,null,null,{"$f":"IF(T24=\"\",0,VLOOKUP(T24,M$8:Q$90,5,FALSE))","v":0},0,null,null,"SR","Good",{"$f":"IF(J24=\"\",J$23&K24&L24,J24&K24&L24)","v":"Small GrainSRGood"},63,75,83,87,null,"Natural desert cover",{"$f":"C24&D24&E24","v":""},null,"Contoured","Poor","PastureContouredPoor",47,67,81,88]
[null,null,null,null,null,null,{"$f":"IF(T25=\"\",0,VLOOKUP(T25,M$8:Q$90,5,FALSE))","v":0},0,null,null,"SR+CR","Poor","Small GrainSR+CRPoor",64,75,83,86,null,"Commercial & business-85",{"$f":"C25&D25&E25","v":""},null,"Contoured","Fair","PastureContouredFair",25,59,75,83]
[null,null,null,null,null,null,{"$f":"IF(T26=\"\",0,VLOOKUP(T26,M$8:Q$90,5,FALSE))","v":0},0,null,null,"SR+CR","Good","Small GrainSR+CRGood",60,72,80,84,null,"Industrial-72",{"$f":"C26&D26&E26","v":""},null,"Contoured","Good","PastureContouredGood",6,35,70,79]
[null,"Sub Total",null,null,null,{"$f":"SUM(F23:F26)","v":0},null,{"$f":"SUM(H23:H26)","v":0},null,null,"C","Poor","Small GrainCPoor",63,74,82,85,null,"0.05 ha-65",null,"Meadow",null,null,"Meadow",30,58,71,78]
[null,"Total",null,null,null,{"$f":"SUM(F12,F17,F22,F27)","v":100},null,{"$f":"H12+H17+H22+H27","v":51.3},null,null,"C","Good","Small GrainCGood",61,73,81,84,null,"0.1 ha-38",null,"Woodland",null,"Poor",{"$f":"IF(U28=\"\",U$28&V28&W28,U28&V28&W28)","v":"WoodlandPoor"},45,66,77,83]
[null,null,null,null,null,{"$f":"IF(OR(F28=0,F28=100),\"\",IF(F28<>100,\"Area proportions should be 100%\"))","v":""},null,null,null,null,"C+CR","Poor","Small GrainC+CRPoor",62,73,81,84,null,"0.135 ha-30",null,null,null,"Fair",{"$f":"IF(U29=\"\",U$28&V29&W29,U29&V29&W29)","v":"WoodlandFair"},36,60,73,79]
[null,null,null,null,null,null,null,null,null,null,"C+CR","Good","Small GrainC+CRGood",60,72,80,83,null,"0.2 ha-25",null,null,null,"Good",{"$f":"IF(U30=\"\",U$28&V30&W30,U30&V30&W30)","v":"WoodlandGood"},25,55,70,77]
[null,null,null,null,null,null,null,null,null,null,"C&T","Poor","Small GrainC&TPoor",61,72,79,82,null,"0.4 ha-20",null,"Farmsteads",null,null,{"$f":"IF(U31=\"\",U$28&V31&W31,U31&V31&W31)","v":"Farmsteads"},59,74,82,86]
[null,null,null,null,null,null,null,null,null,null,"C&T","Good","Small GrainC&TGood",59,70,78,81,null,"0.8 ha-12",null,"Roads",null,null,{"$f":"IF(U32=\"\",U$28&V32&W32,U32&V32&W32)","v":"Roads"},72,82,87,89]
[null,null,null,null,null,null,null,null,null,null,"C&T+CR","Poor","Small GrainC&T+CRPoor",60,71,78,81,null,"Developing urban areas",null,"SR - Straight row    C  - Contoured     T - Treated"]
[null,null,null,null,null,null,null,null,null,null,"C&T+CR","Good","Small GrainC&T+CRGood",58,69,77,80,null,"Newly graded areas"]
[null,null,null,null,null,null,null,null,null,null,"Close-Seeded SR or broadcst","Poor","Small GrainClose-Seeded SR or broadcstPoor",66,77,85,89]
[null,null,null,null,null,null,null,null,null,null,"Close-Seeded SR or broadcst","Good","Small GrainClose-Seeded SR or broadcstGood",58,72,81,85]
[null,null,null,null,null,null,null,null,null,null,"Legumes or C","Poor","Small GrainLegumes or CPoor",64,75,83,85]
[null,null,null,null,null,null,null,null,null,null,"Rotation","Good","Small GrainRotationGood",55,69,78,83]
[null,null,null,null,null,null,null,null,null,"Meadow","C & T","Poor",{"$f":"IF(J39=\"\",J$39&K39&L39,J39&K39&L39)","v":"MeadowC & TPoor"},63,73,80,83]
[null,null,null,null,null,null,null,null,null,null,"C & T","Good",{"$f":"IF(J40=\"\",J$39&K40&L40,J40&K40&L40)","v":"MeadowC & TGood"},51,67,76,80]
[null,null,null,null,null,null,null,null,null,null,"Continuous",null,null,35,59,72,79]
[null,null,null,null,null,null,null,null,null,"Pasture-grass",null,"Poor",{"$f":"IF(J42=\"\",J$42&K42&L42,J42&K42&L42)","v":"Pasture-grassPoor"},68,79,86,89]
[null,null,null,null,null,null,null,null,null,null,null,"Fair","Pasture-grassFair",49,69,79,84]
[null,null,null,null,null,null,null,null,null,null,null,"Good","Pasture-grassGood",39,61,74,80]
[null,null,null,null,null,null,null,null,null,"Brush-weed-grass",null,"Poor","Brush-weed-grassPoor",48,67,77,83]
[null,null,null,null,null,null,null,null,null,null,null,"Fair","Pasture-grassFair",35,56,70,77]
[null,null,null,null,null,null,null,null,null,null,null,"Good","Pasture-grassGood",304,48,65,73]
[null,null,null,null,null,null,null,null,null,"Woods-grass",null,"Poor",{"$f":"IF(J48=\"\",J$48&K48&L48,J48&K48&L48)","v":"Woods-grassPoor"},57,73,82,86]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J49=\"\",J$48&K49&L49,J49&K49&L49)","v":"Woods-grassFair"},43,65,76,82]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J50=\"\",J$48&K50&L50,J50&K50&L50)","v":"Woods-grassGood"},32,58,72,79]
[null,null,null,null,null,null,null,null,null,"Woods",null,"Poor",{"$f":"IF(J51=\"\",J$51&K51&L51,J51&K51&L51)","v":"WoodsPoor"},45,66,77,83]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J52=\"\",J$51&K52&L52,J52&K52&L52)","v":"WoodsFair"},36,60,73,79]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J53=\"\",J$51&K53&L53,J53&K53&L53)","v":"WoodsGood"},25,55,70,77]
[null,null,null,null,null,null,null,null,null,"Farms building and lanes",null,null,{"$f":"IF(J54=\"\",J$42&K54&L54,J54&K54&L54)","v":"Farms building and lanes"},59,74,82,86]
[null,null,null,null,null,null,null,null,null,"Mix grass weeds brush",null,"Poor",{"$f":"IF(J55=\"\",J$55&K55&L55,J55&K55&L55)","v":"Mix grass weeds brushPoor"},null,80,87,93]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J56=\"\",J$55&K56&L56,J56&K56&L56)","v":"Mix grass weeds brushFair"},null,71,81,89]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J57=\"\",J$55&K57&L57,J57&K57&L57)","v":"Mix grass weeds brushGood"},null,62,74,85]
[null,null,null,null,null,null,null,null,null,"Mount brush-small trees",null,"Poor",{"$f":"IF(J58=\"\",J$58&K58&L58,J58&K58&L58)","v":"Mount brush-small treesPoor"},null,66,74,79]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J59=\"\",J$58&K59&L59,J59&K59&L59)","v":"Mount brush-small treesFair"},null,48,57,63]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J60=\"\",J$58&K60&L60,J60&K60&L60)","v":"Mount brush-small treesGood"},null,30,41,48]
[null,null,null,null,null,null,null,null,null,"Small trees,grass",null,"Poor",{"$f":"IF(J61=\"\",J$61&K61&L61,J61&K61&L61)","v":"Small trees,grassPoor"},null,75,85,89]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J62=\"\",J$61&K62&L62,J62&K62&L62)","v":"Small trees,grassFair"},null,58,73,80]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J63=\"\",J$61&K63&L63,J63&K63&L63)","v":"Small trees,grassGood"},null,41,61,71]
[null,null,null,null,null,null,null,null,null,"Brush-grass understory",null,"Poor",{"$f":"IF(J64=\"\",J$64&K64&L64,J64&K64&L64)","v":"Brush-grass understoryPoor"},63,67,80,85]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J65=\"\",J$64&K65&L65,J65&K65&L65)","v":"Brush-grass understoryFair"},55,51,63,70]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J66=\"\",J$64&K66&L66,J66&K66&L66)","v":"Brush-grass understoryGood"},49,35,47,55]
[null,null,null,null,null,null,null,null,null,"Desert shrub brush",null,"Poor",{"$f":"IF(J67=\"\",J$67&K67&L67,J67&K67&L67)","v":"Desert shrub brushPoor"},null,77,85,88]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J68=\"\",J$67&K68&L68,J68&K68&L68)","v":"Desert shrub brushFair"},null,72,81,86]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J69=\"\",J$67&K69&L69,J69&K69&L69)","v":"Desert shrub brushGood"},null,68,79,84]
[null,null,null,null,null,null,null,null,null,"Open space ",null,"Poor",{"$f":"IF(J70=\"\",J$70&K70&L70,J70&K70&L70)","v":"Open space Poor"},68,79,86,89]
[null,null,null,null,null,null,null,null,null,null,null,"Fair",{"$f":"IF(J71=\"\",J$70&K71&L71,J71&K71&L71)","v":"Open space Fair"},49,69,79,84]
[null,null,null,null,null,null,null,null,null,null,null,"Good",{"$f":"IF(J72=\"\",J$70&K72&L72,J72&K72&L72)","v":"Open space Good"},39,61,74,80]
[null,null,null,null,null,null,null,null,null,"Impervious areas",null,null,{"$f":"IF(J73=\"\",J$42&K73&L73,J73&K73&L73)","v":"Impervious areas"},98,98,98,98]
[null,null,null,null,null,null,null,null,null,"Streets and roads",null,null,{"$f":"IF(J74=\"\",J$74&K74&L74,J74&K74&L74)","v":"Streets and roads"}]
[null,null,null,null,null,null,null,null,null,null,null,"Paved-curb and storm",{"$f":"IF(J75=\"\",J$74&K75&L75,J75&K75&L75)","v":"Streets and roadsPaved-curb and storm"},98,98,98,98]
[null,null,null,null,null,null,null,null,null,null,null,"Paved- open ditches",{"$f":"IF(J76=\"\",J$74&K76&L76,J76&K76&L76)","v":"Streets and roadsPaved- open ditches"},83,89,92,93]
[null,null,null,null,null,null,null,null,null,null,null,"Gravel",{"$f":"IF(J77=\"\",J$74&K77&L77,J77&K77&L77)","v":"Streets and roadsGravel"},76,85,89,91]
[null,null,null,null,null,null,null,null,null,null,null,"Dirt",{"$f":"IF(J78=\"\",J$74&K78&L78,J78&K78&L78)","v":"Streets and roadsDirt"},72,82,87,89]
[null,null,null,null,null,null,null,null,null,"Natural desert cover",null,null,{"$f":"IF(J79=\"\",J$79&K79&L79,J79&K79&L79)","v":"Natural desert cover"},63,77,85,88]
[null,null,null,null,null,null,null,null,null,"Commercial & business-85",null,null,{"$f":"IF(J80=\"\",J$80&K80&L80,J80&K80&L80)","v":"Commercial & business-85"},89,92,94,95]
[null,null,null,null,null,null,null,null,null,"Industrial-72",null,null,{"$f":"IF(J81=\"\",J$81&K81&L81,J81&K81&L81)","v":"Industrial-72"},81,88,91,93]
[null,null,null,null,null,null,null,null,null,"Residential districts by average lot size:"]
[null,null,null,null,null,null,null,null,null,"0.05 ha-65",null,null,{"$f":"J83&K83&L83","v":"0.05 ha-65"},77,85,90,92]
[null,null,null,null,null,null,null,null,null,"0.1 ha-38",null,null,{"$f":"J84&K84&L84","v":"0.1 ha-38"},61,75,83,87]
[null,null,null,null,null,null,null,null,null,"0.135 ha-30",null,null,"0.135 ha-30",57,72,81,86]
[null,null,null,null,null,null,null,null,null,"0.2 ha-25",null,null,"0.2 ha-25",54,70,80,85]
[null,null,null,null,null,null,null,null,null,"0.4 ha-20",null,null,"0.4 ha-20",51,68,79,84]
[null,null,null,null,null,null,null,null,null,"0.8 ha-12",null,null,"0.8 ha-12",46,65,77,82]
[null,null,null,null,null,null,null,null,null,"Developing urban areas",null,null,"Developing urban areas"]
[null,null,null,null,null,null,null,null,null,"Newly graded areas",null,null,"Newly graded areas",77,86,91,94]

{"sheet":"TC","index":5,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,12,4,12],[2,9,3,10],[19,1,19,6]]}
[]
["NB: Time of Concentration or flow runtime computation"]
[null,"Insert Data in Yellow Cells Only (start from lowest to highest elevation)",null,null,null,null,null,null,null,"Consider overland and channel flows separatley for calculating Tc ?",null,null,"If \"Yes\", Enter area propoertion for  each land use type in the next Table","Kerby Retardance coefficient (N)"]
[null,"No. Reach","Distance from watershed divide(km)","Elevation (m)","Slope","Tc (channel)","Tc (overland)","Tc (hrs)",null,null,null,null,null,"Generalized land use description","Area proportion (decimal or %)","Retardance coefficient (N)"]
[null,1,null,2521,null,null,null,{"$f":"SUM(F5:G5)","v":0},null,null,null,null,null,"Pavement",0,0.02]
[null,{"$f":"B5+1","v":2},12.17,2133,{"$f":"IF(C6=0,\"\",(D5-D6)/(1000*(C6-C5)))","v":3.1881676253081345E-2},{"$f":"IF(C6>0,0.066*(C6-C5)^0.77/E6^0.385,\"\")","v":1.7035478590788034},{"$f":"IF(AND(C6>0,M$7>0),0.604*(M$7*(C6-C5))^0.467*E6^-0.235,0)","v":2.6347300411145596},{"$f":"SUM(F6:G6)","v":4.3382779001933631},null,null,null,null,"Weighted N","Deciduous forest ",null,0.6]
[null,{"$f":"B6+1","v":3},null,null,{"$f":"IF(C7=0,\"\",(D6-D7)/(1000*(C7-C6)))","v":""},{"$f":"IF(C7>0,0.066*(C7-C6)^0.77/E7^0.385,\"\")","v":""},0,{"$f":"SUM(F7:G7)","v":0},null,null,null,null,{"$f":"IF(O5:O11<1,SUMPRODUCT(O5:O11,P5:P11),SUMPRODUCT(O5:O11,P5:P11)/100)","v":0.33999999999999997},"Poor grass, cultivated row crops or moderately rough packed surfaces ",0.3,0.2]
[null,4,null,null,"","",0,{"$f":"SUM(F8:G8)","v":0},null,null,null,null,null,"Smooth, bare, packed soil",null,0.1]
[null,5,null,null,"","",0,0,null,null,null,null,null,"Pasture, average grass ",0.7,0.4]
[null,6,null,null,"","",0,0,null,null,null,null,null,"Dense grass, coniferous forest or deciduous forest with deep litter ",null,0.8]
[null,7,null,null,"","",0,0,null,null,null,null,null,"Dense grass, coniferous forest or deciduous forest with deep litter ",null,0.8]
[null,8,null,null,"","",0,0]
[null,9,null,null,"","",0,0]
[null,10,null,null,"","",0,0]
[null,11,null,null,"","",0,0]
[null,12,null,null,"","",0,0]
[null,13,null,null,"","",0,0]
[null,14,null,null,"","",0,0]
[null,15,null,null,"","",0,0]
[null,"Total ",null,null,null,null,null,{"$f":"SUM(H6:H19)-0.41","v":3.928277900193363}]
[null,null,null,null,null," If TC known, enter it here.",null,{"$f":"H20","v":3.928277900193363}]

{"sheet":"Peakflow","index":6,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,24,7,25],[7,16,8,16],[7,17,8,17],[6,7,8,7],[6,12,7,13],[6,14,7,15],[6,18,6,19],[6,16,6,17],[6,20,8,20],[6,21,8,21],[6,22,8,22],[6,23,8,23],[7,11,8,11],[7,10,8,10],[6,10,6,11],[6,8,6,9],[7,8,8,8],[7,9,8,9],[3,6,4,6],[3,11,4,12]]}
[]
[null,null,"NB: Enter Data in Yellow cells Only"]
[]
[null,null,null,null,null,null,{"$f":"IF(H4=1,\"Enter Rainfall Profile\",\" \")","v":"Enter Rainfall Profile"},1,null,1,null,{"$f":"IF(J4=1,\"Enter Area Reduction Factor (ARF)\",\" \")","v":"Enter Area Reduction Factor (ARF)"}]
[]
[null,"Composite Hydrograph using SCS-Curve Number Method"]
[null,"Description","Value","Unit",null,null,null,"Time (hr)","Rainfall Profile",null,"ARF",null,"Rainfall Profile",null,"Numbering and ordering",null,"Rainfall",null,"Runoff (mm)",null," Peak flow (m3/s)","Time of begging (hr)","Time to Peak (hr)","Time to end (hr)","Rising and Recession Slopes"]
[null,"Name of Project","Goli SSIP",null,null,1,null,null,"From keyboard","Formula*","From Keyboard","Formula**",null,null,null,null,"Rearranged incremental ","Cumulative rainfall "]
[null,"Return period",50,"years",null,null,null,null,null,null,null,null,"Cumulative","Incremental","Initial Order","Rearranged order",null,null,"Cumulative","Incremental",null,null,null,null,"Su","Sf"]
[null,"24-hr maximum point rainfall",192.13,"mm",null,null,null,{"$f":"C13","v":1},46.008000000000003,{"$f":"14.149*LN(H10)+46.008","v":46.008000000000003},84.770400000000009,{"$f":"100*(1.04-0.08*LN(C$11))*H10^(0.02*C$11^0.28)","v":77.583092612493957},{"$f":"IF(AND(H$4=1,J$4=1),I10*K10,IF(AND(H$4=1,J$4=2),I10*L10,IF(AND(H$4=2,J$4=1),I10*L10,IF(AND(H$4=2,J$4=2),J10*L10))))*C$10/10000","v":74.932939528761608},{"$f":"M10","v":74.932939528761608},{"$f":"RANK(N10,N$10:N$15)","v":1},{"$f":"O14","v":5},{"$f":"INDEX(N$10:N$15,MATCH(P10,O$10:O$15,0))","v":7.1925910001049118},{"$f":"N15","v":4.7401409058987269},{"$f":"IF(R10-0.2*(25400/C$19-254)>0,(R10-0.2*(25400/C$19-254))^2/(R10+0.8*(25400/C$19-254)),0)","v":0},{"$f":"S10","v":0},{"$f":"C$22*T10","v":0},0,{"$f":"C$14","v":2.8569667401160177},{"$f":"C$16","v":7.6281011961097667},{"$f":"$U10/W$10","v":0},{"$f":"$U10/(X$10-W$10)","v":0}]
[null,"Catchment area ",27.17,"km2",null,null,null,{"$f":"H10+C$13","v":2},53.815339457742667,{"$f":"14.149*LN(H11)+46.008","v":55.815339457742667},89.117599999999996,{"$f":"100*(1.04-0.08*LN(C$11))*H11^(0.02*C$11^0.28)","v":80.342261111397633},{"$f":"IF(AND(H$4=1,J$4=1),I11*K11,IF(AND(H$4=1,J$4=2),I11*L11,IF(AND(H$4=2,J$4=1),I11*L11,IF(AND(H$4=2,J$4=2),J11*L11))))*C$10/10000","v":92.143509417302653},{"$f":"M11-M10","v":17.210569888541045},2,{"$f":"O13","v":4},13.556380135608691,{"$f":"R10+Q11","v":18.296521041507418},0,{"$f":"S11-S10","v":0},0,{"$f":"V10+C$13","v":1},{"$f":"W10+C$13","v":3.8569667401160177},{"$f":"X10+C$13","v":8.6281011961097676},0,0]
[null,"Time of concentration",{"$f":"IF(TC!H21=\"\",TC!H20,TC!H21)","v":3.928277900193363},"hrs",null,null,null,{"$f":"H11+C$13","v":3},60.552265272365091,61.552265272365091,92.378000000000014,{"$f":"100*(1.04-0.08*LN(C$11))*H12^(0.02*C$11^0.28)","v":82.001539171788252},107.47170356064372,{"$f":"M12-M11","v":15.328194143341065},3,{"$f":"O10","v":1},74.932939528761608,{"$f":"R11+Q12","v":93.229460570269026},7.0784780559156157,{"$f":"S12-S11","v":7.0784780559156157},14.001922803082687,{"$f":"V11+C$13","v":2},{"$f":"W11+C$13","v":4.8569667401160181},{"$f":"X11+C$13","v":9.6281011961097676},4.9009750818849529,2.9347156178951814]
[null,"Unit rainfall duration",{"$f":"IF(C12<=3,IF(C12/6-MROUND(C12/6,0.05)<0.25,CEILING(C12/6,0.05),MROUND(C12/6,0.05)),1)","v":1},"hrs",null,null,null,{"$f":"H12+C$13","v":4},66.622678915485338,65.622678915485338,94.551599999999993,83.199556799473413,121.02808369625241,{"$f":"M13-M12","v":13.556380135608691},4,{"$f":"O12","v":3},15.328194143341065,{"$f":"R12+Q13","v":108.55765471361009},12.074570107415552,{"$f":"S13-S12","v":4.9960920514999358},9.8827593544257031,{"$f":"V12+C$13","v":3},{"$f":"W12+C$13","v":5.8569667401160181},{"$f":"X12+C$13","v":10.628101196109768},3.4591790011613424,2.0713646713540976]
[null,"Time to Peak",{"$f":"0.6*C12+C13/2","v":2.8569667401160177},"hrs",null,null,null,{"$f":"H13+C$13","v":5},69.779937023030087,68.779937023030087,95.638400000000004,84.140851651347973,128.22067469635732,{"$f":"M14-M13","v":7.1925910001049118},5,{"$f":"O11","v":2},17.210569888541045,{"$f":"R13+Q14","v":125.76822460215114},18.868756173440332,{"$f":"S14-S13","v":6.7941860660247801},13.439565405836884,{"$f":"V13+C$13","v":4},{"$f":"W13+C$13","v":6.8569667401160181},{"$f":"X13+C$13","v":11.628101196109768},4.7041378596136969,2.8168490177327525]
[null,"Recession Time ",{"$f":"1.67*C14","v":4.7711344559937494},"hrs",null,null,null,{"$f":"H14+C$13","v":6},72.359604730107748,71.359604730107748,95.638400000000004,84.917845497375197,132.96081560225605,{"$f":"M15-M14","v":4.7401409058987269},6,{"$f":"O15","v":6},4.7401409058987269,{"$f":"R14+Q15","v":130.50836550804985},20.934732235982754,{"$f":"S15-S14","v":2.0659760625424219},4.0867029765756433,{"$f":"V14+C$13","v":5},{"$f":"W14+C$13","v":7.8569667401160181},{"$f":"X14+C$13","v":12.628101196109768},1.4304342151388461,0.85654743421487789]
[null,"Base Time",{"$f":"2.67*C14","v":7.6281011961097667},"hrs",null,null,null,null,"* See rainfall profile sheet",null,null,"**http://www.scielo.org.za/scielo.php?script=sci_serial&pid=1021-2019"]
[null,"Average Area Reduction Factor (ARF)",{"$f":"(1.04-0.08*LN(C$11))*H12^(0.02*C$11^0.28)","v":0.82001539171788251},"dec"]
[null,"Areal Rainfall",{"$f":"C10*C17","v":157.54955721075677},"mm",null,null,null,null,"Hydrograph Ordinates"]
[null,{"$f":"IF(F8=1,\"Curve Number (AMC II)\",\"Curve Number (AMC III)\")","v":"Curve Number (AMC II)"},{"$f":"IF(F8=1,CN!H28,CN!H28/(0.43+0.0057*CN!H28))","v":51.3},null,null,null,null,"Time (hr)","UH","Q1","Q2","Q3","Q4","Q5","Q6","Qt"]
[null,"Maximum retention potential (S)",{"$f":"254*(100/C19-1)","v":241.12670565302147},"mm",null,null,null,0,0,0,null,null,null,null,null,{"$f":"SUM(J20:O20)","v":0}]
[null,"Runoff ",{"$f":"IF(C11<10,(C18-0.2*C20)^2/(C18*0.8*C20),S15)","v":20.934732235982754},"mm",null,null,null,{"$f":"IF(OR(H20+C$13=C$14,AND(H20<C$14,H20+C$13>C$14)),C$14,IF(OR(H20+C$13=C$16,AND(H20<C$16,H20+C$13>C$16)),C$16,H20+C$13))","v":1},{"$f":" IF(H21<=$W$10,$C$22/$W$10*H21, IF(H21<X$10, $C$22-$C$22/($X$10-$W$10)*(H21-$W$10),0))","v":0.69237695492876705},{"$f":"T$10*I21","v":0},0,null,null,null,null,{"$f":"SUM(J21:O21)","v":0}]
[null,"Peak flow rate per mm of runoff",{"$f":"0.208*C11/C14","v":1.9780979318542946},"m3/sec/mm",null,null,null,{"$f":"IF(OR(H21+C$13=C$14,AND(H21<C$14,H21+C$13>C$14)),C$14,IF(OR(H21+C$13=C$16,AND(H21<C$16,H21+C$13>C$16)),C$16,H21+C$13))","v":2},1.3847539098575341,0,{"$f":"T$11*I21","v":0},0,null,null,null,0]
[null,"Peak flood (Qp)",{"$f":"IF(C11<10,ROUNDUP(0.208*C11*C21/C14,1),ROUNDUP(MAX(P20:P38),1))","v":32.300000000000004},"m3/s",null,null,null,2.8569667401160177,1.9780979318542946,0,0,{"$f":"T$12*I21","v":4.9009750818849529},0,null,null,4.9009750818849529]
[null,null,null,null,null,null,null,3.8569667401160177,1.563500952855033,0,0,9.8019501637699058,{"$f":"T$13*I21","v":3.4591790011613424},0,null,13.261129164931248]
[null,null,null,null,null,null,null,{"$f":"IF(OR(H24+C$13=C$14,AND(H24<C$14,H24+C$13>C$14)),C$14,IF(OR(H24+C$13=C$16,AND(H24<C$16,H24+C$13>C$16)),C$16,H24+C$13))","v":4.8569667401160181},1.1489039738557709,0,0,14.001922803082687,6.9183580023226847,{"$f":"T$14*I21","v":4.704137859613696},0,25.624418665019068]
[null,null,null,null,null,null,null,5.8569667401160181,0.7343069948565093,0,0,11.067207185187506,9.8827593544257031,9.408275719227392,{"$f":"T$15*I21","v":1.4304342151388461},31.788676473979443]
[null,null,null,null,null,null,null,6.8569667401160181,0.31971001585724768,0,0,8.1324915672923233,7.8113946830716063,13.439565405836884,2.8608684302776921,32.244320086478503]
[null,null,null,null,null,null,null,7.6281011961097667,0,0,0,5.1977759493971423,5.7400300117175069,10.622716388104132,4.0867029765756433,25.647225325794423]
[null,null,null,null,null,null,null,8.6281011961097676,0,0,0,2.2630603315019613,3.6686653403634102,7.8058673703713772,3.230155542360766,16.967748584597516]
[null,null,null,null,null,null,null,9.6281011961097676,0,0,0,0,1.5973006690093137,4.9890183526386256,2.3736081081458873,8.9599271297938259]
[null,null,null,null,null,null,null,10.628101196109768,0,0,0,0,0,2.1721693349058735,1.5170606739310095,3.689230008836883]
[null,null,null,null,null,null,null,11.628101196109768,0,0,0,0,0,0,0.66051323971613185,0.66051323971613185]
[null,null,null,null,null,null,null,12.628101196109768,{"$f":" IF(H33<=$W$10,$C$22/$W$10*H33, IF(H33<X$10, $C$22-$C$22/($X$10-$W$10)*(H33-$W$10),0))","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,13.628101196109768,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,14.628101196109768,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,15.628101196109768,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,16.628101196109768,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF(OR(H37+C$13=C$14,AND(H37<C$14,H37+C$13>C$14)),C$14,IF(OR(H37+C$13=C$16,AND(H37<C$16,H37+C$13>C$16)),C$16,H37+C$13))","v":17.628101196109768},1,null,null,null,null,null,0,0]