{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Read Me","Water Resource Checklist"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":32,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Read Me","index":0,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,1,38,8],[1,0,1,9],[3,0,3,8],[9,1,9,8],[10,0,10,9],[11,0,11,9],[14,1,14,8],[16,0,16,9],[31,1,31,8],[33,0,33,9],[34,0,34,9],[37,1,37,8],[18,4,19,9],[50,1,50,8],[39,1,39,8],[40,1,40,8],[42,1,42,8],[43,0,43,9],[44,1,44,8],[46,1,49,8]]}
[]
["Read Me Sheet"]
[]
["Solar Powered Irrigation Systems - Manual and Tools"]
[]
[]
[]
[]
[]
[null,"Introduction"]
["SAFEGUARD WATER 02- Water Resource Management Checklist"]
["This checklist guides the regular water resource managment aspects related to an SPIS installation."]
[]
[]
[null,"Overview"]
[]
["This tool comprises the following sheets:"]
[]
[null,"1. Water Resource Checklist",null,null,"for systematically considering the sustainable and legitimate use of water resources"]
{"$rows_empty":12}
[null,"Tips & Tricks"]
[]
["This tool is in a checklist format and can be completed by simply entering text and values into corresponding cells."]
["This tool contains no critical formulas or calculations."]
[]
[]
[null,"About"]
[null,"Authors: Robert Schultz, Michael Eichholz (BGR), GFA Consulting"]
[null,"Version: 1.0 (January 2017)"]
[null,"Published by: Powering Agriculture – An Energy Grand Challenge for Development / BGR"]
[{"$nulls":4},"Internet: https://poweringag.org"]
[null,"Design/layout: "]
["Download link: "]
[null,"Contact: Robert.Schultz@giz.de"]
[]
[null,"GIZ encourages the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ as the source."]
[]
[]
[]
[null,"© GIZ 2017"]

{"sheet":"Water Resource Checklist","index":1,"n_rows":97,"n_cols":8,"rows_kept":97,"cut":false,"hidden":false,"merged":[[92,0,92,7],[89,0,89,2],[83,0,83,2],[94,0,94,3],[94,5,94,7],[54,5,54,7],[55,5,55,6],[86,0,86,2],[1,0,1,7],[36,0,36,2],[65,1,65,2],[66,1,66,2],[67,1,67,2],[93,0,93,3],[93,5,93,7],[82,0,82,3],[82,5,82,7],[85,5,85,7],[87,5,87,7],[88,5,88,7],[90,5,90,7],[91,5,91,7],[84,5,84,7],[84,0,84,3],[85,0,85,3],[87,0,87,3],[88,0,88,3],[90,0,90,3],[91,0,91,3],[7,0,7,7],[12,2,15,3],[30,0,30,7],[29,0,29,7],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[37,0,37,2],[32,4,32,7],[33,4,33,7],[34,4,34,7],[35,4,35,7],[36,4,36,7],[37,4,37,7],[28,0,28,2],[28,3,28,4],[28,5,28,7],[26,2,27,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[21,5,21,6],[20,5,20,6],[22,5,22,6],[23,5,23,6],[16,2,17,3],[18,2,19,3],[17,4,17,7],[19,4,19,7],[15,5,15,7],[16,5,16,7],[18,5,18,7],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[11,2,11,3],[8,4,8,7],[8,0,8,3],[5,4,5,5],[9,4,9,5],[9,0,9,3],[39,0,39,7],[40,0,40,7],[42,4,42,7],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[43,4,43,7],[44,4,44,7],[45,4,45,7],[46,4,46,7],[52,0,52,7],[53,0,53,7],[61,0,61,7],[65,4,65,5],[71,0,71,1],[75,3,75,7],[76,3,76,7],[62,0,62,7],[56,5,56,6],[55,2,59,4],[64,3,64,4],[77,3,77,7],[75,0,75,1],[76,0,76,1],[77,0,77,1],[67,4,67,7],[81,0,81,7],[80,0,80,7],[72,0,73,2],[68,0,68,1],[69,0,70,2],[78,0,79,7]]}
["SAFEGUARD WATER 02- Water Resource Management Checklist"]
["This checklist considers the sustainable and legitimate use of water resources."]
["Farm name:"]
["SPIS supplier name:"]
["SPIS installer name:"]
["Inspection date:",null,null,null,"Previous inspection date:"]
[]
["Water source"]
["Groundwater (skip if not applicable)",null,null,null,"Surface water (skip if not applicable)"]
["Type of well",null,null,null,"Type of water body"]
["Open Well (dugged)",null,"Tube Well (borehole)",null,"Pond"]
["Well characteristics","Value","Comment",null,"Lake"]
["diameter casing (inch/mm)",null,"Information on construction details is important to assess corrosion risk\nCorrosion of casing and mains may affect well efficiency and water quality",null,"River"]
["material of casing",null,null,null,"Canal (large irrigation system)"]
["diameter of raising main (inch/mm)"]
["material of raising main",null,null,null,"Characteristics","Value"]
["depth of screens (filter) (m)",null,"The length and depth of screens gives information on the  layer that is pumped.",null,"denomination of the water body"]
["length of screens (m)",null,null,null,"Name of the lake, river or irrigation canal"]
["Years of operation",null,"Wells need regular revision in order to maintain their yield. ",null,"Name of watershed"]
["Date of construction",null,null,null,"Name of the watershed or overall irrigation system"]
["Hydraulic characteristics","Value","Comment",null,"Water level","Value"]
["dynamic water level (m below ground level)",null,"pumped water level - to assess drawdown of the water table - avoid drying up of screens!",null,"Lowest water level last year",null,null,"in m"]
["static water level (m below ground level)",null,"water level at drilling time or after 24 hours of switching off the pump",null,"High water level last year",null,null,"in m"]
["pumping test data available?",null,"a pumping test gives essential information on the aquifer characteristics",null,"Average water level",null,null,"in m"]
["radius of influence (Ro) (m)",null,"Important to avoid interference with other wells"]
["well efficiency (%)",null,"If efficiency decreases sharply, a new well or rehabilitation should be considered"]
["safe yield (m3/h)",null,"To avoid drying up the well, do not exceed safe yield"]
["safe yield (m3/day)"]
["Current rate of water abstraction (m3/day)",{"$nulls":4},"fill a copy for multiple sources"]
["Ecological observations"]
["Observe the immediate vicinity around the water source to determine whether below is occurring:"]
[]
["Salinity of water is increasing?",null,null,null,"Can be observed through palatability test or laboratory tests "]
["Tree and large shrub mortality above normal?",null,null,null,"May occur because of increased salinity or lowering water table"]
["Frequency of dry running of pump is increasing?",null,null,null,"inscrease pump installation depth or reduce pumping rate"]
["Neighbours complain that water supply interruptions more frequent?",null,null,null,"Discuss and share observations with neighbours"]
["Hardness of water is increasing?",null,null,null,"Risk of pipe clogging increases"]
["Increased frequency of mud in pumped water?",null,null,null,"Pump repair frequency and clogging of pipes is increasing"]
[]
["Efficient water management"]
["Check your water pipes and infrastructure for water efficiency"]
[]
["Is your water supply metered?",null,null,null,"Install water meters at the source (and within the distribution system)"]
["Do you document your water extraction and water use?",null,null,null,"A proper documentation helps to optimize your water use and costs"]
["Do you control your system for leakages?",null,null,null,"Leakage control is crucial to minimize water losses"]
["Do you maintain your infrastructure periodically?",null,null,null,"Prolong the lifetime of your infrastructure and save water by frequent maintenance"]
["Do you operate your system with the appropriate pressure?",null,null,null,"Overpressurized pipes, valves and unions increase the risk of leaks and water loss"]
[]
[]
[]
[]
[]
["Water administration and access"]
["Describe the institutions in charge of distribution and giving access to the water resources."]
["Type of institutions",{"$nulls":4},"Type of agreement"]
["private / own well",null,"Details:",null,null,"Written agreemeent"]
["private entity (e.g. water vendor)",{"$nulls":4},"Verbal agreement"]
["public"]
["common (e.g. user association)"]
["other (specify)"]
[]
["Water Extraction License"]
["Check the status and details of the water extraction license"]
["existing",null,"non-existing",null,"Reason:"]
["IF EXISTING"]
["Issuing authority",null,null,null,"Annual quantity (m3)"]
["Date of issuing"]
["Date of expiry",null,null,null,"Monthly quota (m3): "]
["Conditionality/Restrictions:",null,null,null,"January",null,"July"]
["Details:",null,null,null,"February",null,"August"]
[{"$nulls":4},"March",null,"September"]
["Seasonal restrictions: ",null,null,null,"April",null,"October"]
["Details:",null,null,null,"May",null,"November"]
[{"$nulls":4},"June",null,"December"]
["IF NOT EXISTING"]
["Water license available",null,null,"Complete water licence application process prior to SPIS design / planning !"]
["Water license not available",null,null,"Do not continue with SPIS design / planning !"]
["Water license denied",null,null,"Do not continue with SPIS design / planning !"]
["Details:"]
[]
["Evaluation"]
["Evaluate the answers of the checklist with the following questions. \nIf YES is answered, consider recommendation."]
["Question:",null,null,null,"YES or NO","Recommendation"]
["Water license and safe yield"]
["Flow rate of water license equals safe yield of water source or is smaller?",{"$nulls":4},"Max. flow rate is correctly determined by water license limit !"]
["Flow rate of water license is higher than safe yield of water source?",{"$nulls":4},"Max. flow rate should be determined by safe yield limit, need to revise water license limit !"]
["Pump capacity and water license"]
["Flow rate of existing pump equals water license limit or is lower?",{"$nulls":4},"Pump may be further used or replaced by same capacity !"]
["Flow rate of existing pump is higher than water license limit?",{"$nulls":4},"Pump is oversized. It may not be used further and has to be replaced by lower capacity !"]
["Irrigation system design"]
["Design flow rate (mean) of irrigation system equals pump flow rate or is lower?",{"$nulls":4},"Irrigation system design / capacity may be maintained !"]
["Design flow rate (mean) of irrigation system is higher than pump flow rate?",{"$nulls":4},"Irrigation system design / capacity needs to be revised / downsized !"]
["Ecology and efficiency"]
["Negative ecological impacts can be observed?",{"$nulls":4},"Irrigation system design / capacity needs to be revised / downsized !"]
["Considerable water leakage and losses can be observed?",{"$nulls":4},"Irrigation system components need to be revised and rehabilitated !"]
[]
["Notes:"]