{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ReadMe","Main","Egypt_01","Iran_01"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":82,"comments":3,"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":"ReadMe","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"REal WAter Savings in agricultural systems (REWAS)"]
[null,"A tool to evaluate field scale interventions at system scale levels"]
[null,"ADB, TA9414"]
[]
[null,"Client"]
[null,null,"FAO-RAP"]
[null,null,"Louise Whiting (louise.whiting@fao.org)"]
[null,null,"Hugh Turral (hugh.turral@gmail.com)"]
[]
[null,"Contact, questions, recommendations"]
[null,null,"Alexander Kaune (a.kaune@futurewater.nl)"]
[null,null,"Peter Droogers (p.droogers@futurewater.nl)"]
[]
[null,"References, documentation"]
[null,null,"Kaune, A., P. Droogers, J. van Opstal, P. Steduto,. C. Perry. 2020. REWAS REal WAter Savings tool: Technical document. FutureWater/FAO Report"]

{"sheet":"Main","index":1,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,3,5,8],[22,3,22,8],[44,3,44,8]]}
[]
[null,"Number of scenarios:",2]
[]
[]
[null,"INPUT DATA",null,null,null,null,null,null,null,null,"PLOT",null,null,"PLOT"]
[null,null,null,"Scenario"]
[null,null,null,"Reference ","Sc 20%","Sc 40%","Sc 50%","Scenario D","Scenario E",null,null,null,null,"Select scenario to plot:","Reference "]
[null,"FIELD",null,null,null,null,null,null,null,null,null,null,null,"System plot:"]
[null,"Rainfall","(mm)",50,170.6,170.6,{"$f":"+F9","v":170.6},170.6,170.6,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":50},null,null,"Size (%)",1]
[null,"Irrigation","(mm)",1000,450,360,500,500,500,null,1000,null,null,"Font (pt)",10]
[null,"Crop Transpiration","(mm)",480,424.1,424.1,422.40000000000003,422.40000000000003,422.40000000000003,null,480,null,null,"Follow The Water plot:"]
[null,"Soil Evaporation","(mm)",120,107.3,107.3,120,120,120,null,120,null,null,"Size (%)",1]
[null,"Drainage","(mm)",330.4,151.19999999999999,61.2,10.5,10.5,10.5,null,330.4,null,null,"Font (pt)",12]
[null,"Percolation","(mm)",141.60000000000002,87.3,87.3,4.5,4.5,4.5,null,141.60000000000002,null,null,"Plots can also be moved and resized with mouse"]
[null,"Yield","(kg/ha)",3700,5.3239999999999998,5.3239999999999998,2800,2800,2800,null,3700]
[]
[null,"SYSTEM"]
[null,"Area","(ha)",394200,394200,394200,394200,394200,394200,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":394200}]
[null,"Recoverable drainage fraction RD","(%)",0.8,0.8,0.8,0.8,0.8,0.8]
[null,"Recoverable percolation fraction RP","(%)",0.7,0.7,0.7,0.7,0.7,0.7]
[null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":0}]
[null,"RESULTS"]
[null,null,null,"Scenario"]
[null,null,null,{"$f":"+D7","v":"Reference "},"Sc 20%","Sc 40%","Sc 50%","Scenario D","Scenario E"]
[null,"RESULTS FIELD"]
[null,"Consumption, beneficial BC","(mm)",{"$f":"D11","v":480},424.1,424.1,422.40000000000003,422.40000000000003,422.40000000000003,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":480}]
[null,"Consumption, non-beneficial NBC","(mm)",120,107.3,107.3,120,120,120,null,120]
[null,"Return flows","(mm)",{"$f":"D13+D14","v":472},238.5,148.5,15,15,15,null,472]
[null,"Storage change CS (negative = unsustainable overconsumption)","(mm)",{"$f":"D48-D49","v":-22},{"$f":"E48-E49","v":-149.29999999999984},-149.29999999999995,{"$f":"G48-G49","v":113.19999999999993},113.19999999999993,113.19999999999993,null,-22]
[null,"Apparent Water Savings FWS","(mm)","-",{"$f":"+$D10-E10","v":550},{"$f":"+$D10-F10","v":640},{"$f":"+$D10-G10","v":500},{"$f":"+$D10-H10","v":500},{"$f":"+$D10-I10","v":500},null,"-"]
[null,"Percentage of Apparent Water Savings %FWS","(%)","-",{"$f":"(E30/$D$48)","v":0.52380952380952384},{"$f":"(F30/$D$48)","v":0.60952380952380958},{"$f":"(G30/$D$48)","v":0.47619047619047616},{"$f":"(H30/$D$48)","v":0.47619047619047616},{"$f":"(I30/$D$48)","v":0.47619047619047616},null,"-"]
[]
[null,"RESULTS SYSTEM"]
[null,"Consumption, beneficial BC","(MCM)",{"$f":"D54","v":1892.16},{"$f":"E54","v":1671.8022000000001},1671.8022000000001,{"$f":"G54","v":1665.1007999999999},1665.1007999999999,1665.1007999999999,null,{"$f":"MAX(0,HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE))","v":1892.16}]
[null,"Consumption, non-beneficial NBC","(MCM)",{"$f":"D55","v":473.04},422.97660000000002,422.97660000000002,{"$f":"G55","v":473.04},473.04,473.04,null,{"$f":"MAX(0,HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE))","v":473.04}]
[null,"Return flows, recoverable RF","(MCM)",{"$f":"D61+D64","v":1432.68048},{"$f":"E61+E64","v":717.71993999999995},433.89594,{"$f":"G61+G64","v":45.530099999999997},45.530099999999997,45.530099999999997,null,{"$f":"MAX(0,HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE))","v":1432.68048}]
[null,"Return flows, non-recoverable NRF","(MCM)",{"$f":"D62+D65","v":427.94351999999992},222.44705999999996,151.49106,{"$f":"G62+G65","v":13.599899999999998},13.599899999999998,13.599899999999998,null,{"$f":"MAX(0,HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE))","v":427.94351999999992}]
[null,"Storage change CS","(MCM)",{"$f":"D67-D68","v":-86.723999999999251},{"$f":"E67-E68","v":-588.54059999999981},-588.54060000000027,{"$f":"G67-G68","v":446.23440000000028},446.23440000000028,446.23440000000028,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":-86.723999999999251}]
[null,"Water Productivity WP","(kg/m³)",{"$f":"(D58/(D34+D35))","v":0.61666666666666659},1.0018818216033119E-3,1.0018818216033119E-3,0.51622418879056042,0.51622418879056042,0.51622418879056042,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":0.61666666666666659}]
[null,"Real Water Savings RWS","(MCM)","-",{"$f":"($D$35-E35)+($D$37-E37)","v":255.55985999999996},{"$f":"($D$35-F35)+($D$37-F37)","v":326.51585999999992},{"$f":"($D$35-G35)+($D$37-G37)","v":414.34361999999993},{"$f":"($D$35-H35)+($D$37-H37)","v":414.34361999999993},{"$f":"($D$35-I35)+($D$37-I37)","v":414.34361999999993},null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":"-"}]
[null,"Percentage of Real Water Savings %RWS","(%)","-",{"$f":"(E40/$D$67)","v":6.1742857142857127E-2},{"$f":"(F40/$D$67)","v":7.8885714285714253E-2},{"$f":"(G40/$D$67)","v":0.10010476190476188},{"$f":"(H40/$D$67)","v":0.10010476190476188},{"$f":"(I40/$D$67)","v":0.10010476190476188},null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":"-"}]
[]
[]
[null,"INTERMEDIATE RESULTS (only user internally, do no modify"]
[null,null,null,"Scenario"]
[null,null,null,{"$f":"+D7","v":"Reference "},"Sc 20%","Sc 40%","Sc 50%","Scenario D","Scenario E"]
[null,"FIELD"]
[null,"InflowTotal","(mm)",{"$f":"SUM(D9:D10)","v":1050},620.6,530.6,670.6,670.6,670.6,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":1050}]
[null,"OutflowTotal","(mm)",{"$f":"SUM(D11:D14)","v":1072},769.89999999999986,679.9,557.40000000000009,557.40000000000009,557.40000000000009,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":1072}]
[]
[null,"SYSTEM"]
[null,{"$f":"B9","v":"Rainfall"},"(MCM)",{"$f":"D9*D$18*10/1000000","v":197.1},672.50519999999995,672.50519999999995,672.50519999999995,672.50519999999995,672.50519999999995,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":197.1}]
[null,"Irrigation","(MCM)",3942,1773.9,1419.12,1971,1971,1971,null,3942]
[null,"Crop Transpiration","(MCM)",1892.16,1671.8022000000001,1671.8022000000001,1665.1007999999999,1665.1007999999999,1665.1007999999999,null,1892.16]
[null,"Soil Evaporation","(MCM)",473.04,422.97660000000002,422.97660000000002,473.04,473.04,473.04,null,473.04]
[null,"Drainage","(MCM)",1302.4367999999997,596.03039999999987,241.25040000000001,41.390999999999998,41.390999999999998,41.390999999999998,null,1302.4367999999997]
[null,"Percolation","(MCM)",558.18720000000008,344.13659999999999,344.13659999999999,17.739000000000001,17.739000000000001,17.739000000000001,null,558.18720000000008]
[null,"Production","(Mkg)",{"$f":"(D15*D$18)/1000000","v":1458.54},2.0987207999999997,2.0987207999999997,1103.76,1103.76,1103.76,null,1458.54]
[]
[null,"DrainageTotal","(MCM)",{"$f":"D56","v":1302.4367999999997},{"$f":"E56","v":596.03039999999987},241.25040000000001,41.390999999999998,41.390999999999998,41.390999999999998,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":1302.4367999999997}]
[null,"DrainageRecoverable","(MCM)",{"$f":"(D60)*D19","v":1041.9494399999999},476.82431999999994,193.00032000000002,33.1128,33.1128,33.1128,null,1041.9494399999999]
[null,"DrainageNonRecoverable","(MCM)",{"$f":"(D60)*(1-D19)","v":260.48735999999991},119.20607999999994,48.25007999999999,8.2781999999999982,8.2781999999999982,8.2781999999999982,null,260.48735999999991]
[null,"PercolationTotal","(MCM)",{"$f":"D57","v":558.18720000000008},344.13659999999999,344.13659999999999,17.739000000000001,17.739000000000001,17.739000000000001,null,558.18720000000008]
[null,"PercolationRecoverable","(MCM)",{"$f":"(D63)*D20","v":390.73104000000001},240.89561999999998,240.89561999999998,12.417299999999999,12.417299999999999,12.417299999999999,null,390.73104000000001]
[null,"PercolationNonRecoverable","(MCM)",{"$f":"(D63)*(1-D20)","v":167.45616000000004},103.24098000000001,103.24098000000001,5.3217000000000008,5.3217000000000008,5.3217000000000008,null,167.45616000000004]
[]
[null,"Inflow Total","(MCM)",{"$f":"D52+D53","v":4139.1000000000004},2446.4052000000001,2091.6251999999999,2643.5052000000001,2643.5052000000001,2643.5052000000001,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":4139.1000000000004}]
[null,"Outflow Total ","(MCM)",{"$f":"D61+D62+D64+D65+D54+D55","v":4225.8239999999996},3034.9458,2680.1658000000002,2197.2707999999998,2197.2707999999998,2197.2707999999998,null,{"$f":"HLOOKUP($O$7,$D$7:$I$98,ROW()-ROW($O$7)+1,FALSE)","v":4225.8239999999996}]

{"sheet":"Egypt_01","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,2,15,7]]}
["EFFECTIVE MANAGEMENT OF ON-FARM IRRIGATION FOR SOME MAJOR CROPS IN EGYPT USING CROPWAT MODEL Atef Swelam, Samia, M. El-Marsafawy* and Maha, Elbana***"]
["Misr J. Ag. Eng., 2019, 36 (1): 105 - 122"]
["https://journals.ekb.eg/article_94443.html"]
[]
["Selected: 2013/2014; wheat; Giza, Egypt"]
["26-Nov-2014 / 30-Apr-2015"]
["Scenarios used: 1, 5, 10"]
[]
["ETc (mm)",386]
["Days",{"$f":"DATE(2015,4,30)-DATE(2014,11,26)","v":155}]
["ETc (mm); Fig 7",null,386,386,386,386,386]
["T (%); estimated",null,0.8,0.8,0.8,0.8,0.8]
["Drain (%); estimated",null,0.7,0.7,0.7,0.7,0.7]
[]
["INPUT DATA"]
[null,null,"Scenario"]
[null,null,"Reference ","Sc 1","Sc 5","Sc 10"]
["FIELD"]
["Rainfall","(mm)",50,50,50,50]
["Irrigation","(mm)",{"$f":"7*55","v":385},{"$f":"7*40","v":280},{"$f":"7*80","v":560},{"$f":"6*80","v":480}]
["Crop Transpiration","(mm)",{"$f":"+C11*C12","v":308.8},{"$f":"+D11*D12","v":308.8},308.8,308.8]
["Soil Evaporation","(mm)",{"$f":"+C11-C21","v":77.199999999999989},{"$f":"+D11-D21","v":77.199999999999989},77.199999999999989,77.199999999999989]
["Drainage","(mm)",{"$f":"+(C19+C20-C21-C22)*C13","v":34.299999999999997},{"$f":"+(D19+D20-D21-D22)*D13","v":-39.199999999999996},156.79999999999998,100.8]
["Percolation","(mm)",{"$f":"+(C19+C20-C21-C22)*(1-C13)","v":14.700000000000003},{"$f":"+(D19+D20-D21-D22)*(1-D13)","v":-16.800000000000004},67.200000000000017,43.2]
["Yield","(kg/ha)"]
[]
["SYSTEM"]
["Area","(ha)",1413750,1413750,1413750,1413750]
["Recoverable drainage fraction RD","(%)",0.7,0.7,0.7,0.7]
["Recoverable percolation fraction RP","(%)",0.7,0.7,0.7,0.7]

{"sheet":"Iran_01","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,2,15,7]]}
["Eﬀect and side-eﬀect assessment of diﬀerent agricultural water saving measures in an integrated framework. Leila Goli Raeisi, Saeed Morid, Majid Delavar, Raghavan Srinivasan"]
["Agr Wat Management. 2019"]
[]
[]
["Selected: 2013/2014; wheat; Giza, Egypt"]
["26-Nov-2014 / 30-Apr-2015"]
["Scenarios used: 1, 5, 10"]
[]
["ETa (mm)",null,600,581,561,528]
["T (%); estimated",null,0.8,0.8,0.8,0.8]
["Return (mm)",null,472,280,80,15]
["Drain (%); estimated",null,0.7,0.7,0.7,0.7]
[]
[]
["INPUT DATA"]
[null,null,"Scenario"]
[null,null,"Reference ","Sc 20%","Sc 40%","Sc 50%"]
["FIELD"]
["Rainfall","(mm)",360,{"$f":"+C19","v":360},{"$f":"+D19","v":360},360]
["Irrigation","(mm)",1000,800,600,500]
["Crop Transpiration","(mm)",{"$f":"+C9*C10","v":480},{"$f":"+D9*D10","v":464.8},448.8,422.40000000000003]
["Soil Evaporation","(mm)",{"$f":"+C9-C21","v":120},{"$f":"+C22","v":120},{"$f":"+D22","v":120},120]
["Drainage","(mm)",{"$f":"+C11*C12","v":330.4},{"$f":"+D11*D12","v":196},56,10.5]
["Percolation","(mm)",{"$f":"+C11-C23","v":141.60000000000002},{"$f":"+D11-D23","v":84},24,4.5]
["Yield","(kg/ha)",3700,3400,3200,2800]
[]
["SYSTEM"]
["Area","(ha)",394200,{"$f":"+C28","v":394200},{"$f":"+D28","v":394200},394200]
["Recoverable drainage fraction RD","(%)",0.8,0.8,0.8,0.8]
["Recoverable percolation fraction RP","(%)",0.7,0.7,0.7,0.7]