{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["READ ME","Water Resource Checklist"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":33,"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":80,"n_cols":7,"rows_kept":80,"cut":false,"hidden":false,"merged":[[27,3,27,9],[35,5,37,9],[35,3,37,4],[10,3,10,9],[15,3,15,9],[17,3,17,9],[18,3,19,9],[21,3,21,9],[30,3,31,5],[30,6,31,9],[33,3,33,9],[34,3,34,4],[34,5,34,6],[79,3,79,5],[43,5,43,7],[43,3,43,4],[38,3,38,4],[38,5,38,7],[45,3,56,9],[39,3,39,4],[39,5,39,9],[40,3,42,4],[40,5,41,9],[42,5,42,7],[58,3,70,9],[72,3,77,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"SAFEGUARD WATER – Water Resource Management Checklist"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This checklist guides the regular water resource management aspects related to an SPIS installation."]
[]
[]
[null,null,null,"Tips & Tricks"]
[]
[]
[]
[]
[]
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheet:"]
[]
[null,null,null,"1. Water Resource Checklist",null,null,"for systematically considering the sustainable and legitimate use of water resources"]
[]
[]
[null,null,null,"About"]
[null,null,null,"Published by: ",null,"GIZ & FAO"]
[null,null,null,"Resposible:",null,"GIZ project Sustainable Energy for Food – Powering Agriculture, Bundesanstalt für Geowissenschaften und Rohstoffe (BGR)"]
[]
[]
[null,null,null,"Contact: ",null,"Powering.Agriculture@giz.de"]
[null,null,null,"Download link: ",null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,"About: ",null,"Powering Agriculture: An Energy Grand Challenge for Development. Available at:  "]
[]
[{"$nulls":5},"https://poweringag.org"]
[null,null,null,"Version:",null," 0.2 (October 2017)"]
[]
[null,null,null,"The Toolbox on Solar Powered Irrigation Systems is made possible through the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Cooperation (OPIC) combined resources to create the PAEGC initiative. The objective of PAEGC is to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity and/or value for farmers and agribusinesses in developing countries and emerging regions that lack access to reliable, affordable clean energy."]
{"$rows_empty":12}
[null,null,null,"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners."]
{"$rows_empty":13}
[null,null,null,"GIZ, FAO and the PAEGC Founding Partners encourage 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 and FAO as the source and copyright holder is given."]
[]
[]
[]
[]
[]
[]
[null,null,null,"© GIZ and FAO, 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 – 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 (dug well)",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:"]