{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["READ ME ","1 General Information","2 Water Supply Situation","3 Energy Supply Situation","4 Agricultural Production","5 Water Pumping Technology","6 Irrigation Technology","7 Management Requirements","8 Financial Assessment","9 Ecological Impacts","10 Training & Acceptance"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":0,"defined_names":67,"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":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[35,3,39,5],[40,3,41,5],[40,6,41,9],[62,6,63,9],[62,3,63,5],[49,3,50,5],[49,6,50,9],[42,6,45,9],[42,3,45,5],[57,6,61,9],[57,3,61,5],[35,6,39,9],[76,3,87,9],[89,3,102,9],[104,3,110,9],[112,3,112,5],[46,6,48,9],[46,3,48,5],[70,3,70,4],[70,5,70,9],[71,3,73,4],[71,5,72,9],[73,5,73,7],[74,3,74,4],[74,5,74,7],[66,3,66,4],[66,5,66,6],[67,3,68,4],[67,5,68,9],[69,3,69,4],[69,5,69,7],[51,3,52,5],[51,6,52,9],[65,3,65,9],[53,6,56,9],[53,3,56,5],[33,3,34,5],[33,6,34,9],[10,3,10,9],[15,3,15,9],[17,3,17,9],[22,3,22,9],[30,3,30,9],[18,3,20,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null," DESIGN – Site Data Collection Tool"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This tool helps with the on-site collection of data required to design an SPIS and to assess its general viability. It is particularly relevant for the module DESIGN, MAINTAIN and SAFEGUARD WATER of the SPIS toolbox."]
[]
[]
[]
[null,null,null,"Tips & Tricks"]
{"$rows_empty":7}
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheets:"]
[]
[null,null,null,"1. General Information",null,null,"for basic location and meteorological data for the site "]
[]
[null,null,null,"2. Water Supply Situation",null,null,"for specifying water source and access related information\nthis checklist is complemented by a checklist tool in: SAFEGUARD WATER – Water Resource Management Tool\n"]
[]
[]
[]
[]
[null,null,null,"3. Energy Supply Situation",null,null,"for specifying energy source and access related information "]
[]
[null,null,null,"4. Agricultural Production",null,null,"for specifying site conditions and type and extent of agricultural production\nthis checklist is complemented by a calculation tool in: IRRIGATE – Soil Tool\n"]
[]
[]
[]
[null,null,null,"5. Water Pumping Technology",null,null,"this checklist is complemented by a calculation tool in: DESIGN – Pump Sizing Tool"]
[]
[]
[null,null,null,"6. Irrigation Technology",null,null,"for specifying irrigation and fertigation mechanism used "]
[]
[null,null,null,"7. Management Requirements",null,null,"for specifying general management related aspects "]
[]
[null,null,null,"8. Financial Assessment",null,null,"this checklist is complemented by a calculation tool in: DESIGN – Simplified Financial Viability Tool & FINANCE – Farm Analysis Tool"]
[]
[]
[]
[null,null,null,"9. Ecological Impacts",null,null,"for specifying environmental impact observations\nthis checklist is complemented by a checklist tool in: SAFEGUARD WATER – Water Resource Management Tool \n"]
[]
[]
[]
[]
[null,null,null,"10. Training and Acceptance",null,null,"For specifying the extent of training and skills development measures "]
[]
[]
[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"]
[]
[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.3 (November 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":14}
[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."]
{"$rows_empty":7}
[null,null,null,"© GIZ and FAO, 2017"]

{"sheet":"1 General Information","index":1,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,4,55,15],[32,1,32,15],[38,4,39,15],[40,4,41,15],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[52,4,53,15],[29,1,29,2],[7,14,7,15],[9,0,9,16],[11,1,11,15],[13,1,14,15],[16,1,17,15],[19,1,20,15],[23,1,23,15],[25,1,25,2],[25,4,25,15],[27,1,27,3],[27,4,27,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data"]
[]
[null,"Country",{"$nulls":8},"Owner"]
[]
[null,"Farm",{"$nulls":8},"Interviewer"]
[]
[null,"District",{"$nulls":6},"Region",{"$nulls":4},"Date"]
[]
["1 GENERAL INFORMATION"]
[]
[null,"1.1 History of the system/farm (ownership, previous irrigation practices, others)"]
{"$rows_empty":11}
[null,"1.2 Geographical Position"]
[]
[null,"Latitude [°]"]
[]
[null,"Longitude [°]"]
[]
[null,"Altitude [m]",{"$nulls":4},"m above sea level"]
[]
[]
[null,"1.3 Climatic Conditions"]
[]
[null,"Humid",{"$nulls":5},"Arid",{"$nulls":5},"Others"]
[]
[null,"Semi-humid",{"$nulls":5},"Semi-arid"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,null,null,"Unit","J","F","M","A","M","J","J","A","S","O","N","D"]
[null,"Insolation / hor.",null,"[kWh/m²d]"]
[null,"Min. Temp.",null,"[°C]"]
[null,"Max. Temp.",null,"[°C]"]
[null,"Mean Temp.",null,"[°C]"]
[null,"Rainfall",null,"mm"]
[null,"ETo",null,"mm"]
[]
[null,"Observation/"]
[null,"Remarks"]

{"sheet":"2 Water Supply Situation","index":2,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,1,23,15],[7,14,7,15],[9,0,9,16],[11,1,11,15],[17,4,18,15],[19,4,20,15],[46,1,46,15],[50,4,51,15],[52,4,53,15],[30,4,31,15],[32,1,34,3],[32,4,33,15],[36,1,36,15],[40,4,41,15],[42,1,44,3],[42,4,43,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["2 WATER SUPPLY SITUATION"]
[]
[null,"2.1 Water Source"]
[]
[null,"Well",null,null,null,"Pond",null,null,null,"Lake",null,null,null,"Canal"]
[]
[null,"Diameter",null,null,"m","Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"2.2 Water Quality"]
[]
[null,"Normal",null,null,null,"Brakish",null,null,null,"Hard",null,null,null,"Others"]
[{"$nulls":5},"(salty)",null,null,null,"(high lime content)"]
[null,"Salinity",null,null,"μS",{"$nulls":4},"Temperature",null,null,"°C"]
[]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. Minerals, Bacteria, Special Silt and Clay)"]
[]
[]
[]
[null,"2.3 Water Availability"]
[]
[null,"Sufficient",null,null,null,"Seasonal",null,null,null,"Scarce",null,null,null,"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. Existing Regulations / Allocations)"]
[]
[]
[]
[null,"2.4 Water Ownership"]
[]
[null,"Private",null,null,null,"Public",null,null,null,"Association",null,null,null,"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]

{"sheet":"3 Energy Supply Situation","index":3,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[23,1,23,15],[19,1,20,3],[47,4,48,15],[49,4,50,15],[13,14,13,15],[36,4,37,15],[43,4,43,5],[43,14,43,15],[41,4,41,15],[45,4,45,8],[45,14,45,15],[31,4,32,15],[29,4,30,15],[31,1,32,3],[49,1,50,3],[7,14,7,15],[9,0,9,16],[11,1,11,15],[17,4,18,15],[19,4,20,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["3 ENERGY SUPPLY SITUATION"]
[]
[null,"3.1 Public Grid supply"]
[]
[null,"Grid connection",null,null,null,"Yes",null,null,"No",null,null,"Grid Voltage [V]"]
[]
[null,"Grid Availability",null,null,null,"24/7",null,null,"hrs/day"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. blackout frequency, loadshedding, etc.)"]
[]
[]
[]
[null,"3.2 Off-grid Supply"]
[]
[null,"Diesel Generator",{"$nulls":5},"Gas Generator",{"$nulls":4},"PV Generator"]
[]
[null,"Hybrid",{"$nulls":5},"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. type of generator)"]
[]
[]
[null,"Conventional Generator"]
[]
[null,"Manufacturer"]
[]
[]
[null,"Purpose",null,null,"Main Supply",{"$nulls":6},"Back-up Supply"]
[]
[null,"Model"]
[]
[null,"Rated Power [kW]",{"$nulls":9},"Frequency [Hz]"]
[]
[null,"Fuel Type",{"$nulls":8},"Fuel Consumption [l/d]"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. type of generator)"]

{"sheet":"4 Agricultural Production","index":4,"n_rows":120,"n_cols":16,"rows_kept":120,"cut":false,"hidden":false,"merged":[[118,1,118,3],[119,1,119,3],[111,1,111,15],[113,1,113,3],[114,1,114,3],[115,1,115,3],[116,1,116,3],[85,1,85,15],[91,4,92,15],[93,4,94,15],[97,1,97,15],[117,1,117,3],[7,14,7,15],[9,0,9,16],[11,1,11,15],[17,4,18,15],[19,4,20,15],[23,1,23,15],[27,3,27,11],[35,1,35,15],[41,4,42,15],[43,4,44,15],[47,1,47,15],[29,4,30,15],[31,4,32,15],[31,1,32,3],[76,1,76,3],[53,4,54,15],[55,4,56,15],[59,1,59,15],[61,6,61,7],[61,13,61,14],[74,1,74,15],[81,1,81,3],[82,1,82,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["4 AGRICULTURAL PRODUCTION"]
[]
[null,"4.1 Terrain"]
[]
[null,"Flat",null,null,null,"Wadi",null,null,null,"Hilly",null,null,null,"Valley"]
[{"$nulls":5},"(dry riverbed)"]
[null,"Slope",null,null,"%",{"$nulls":8},"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"4.2 Soil Type"]
[]
[null,"Clay",null,null,null,"Silt",null,null,null,"Sand",null,null,null,"Variations"]
[]
[null,"Type",{"$nulls":11},"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. water holding capacity)"]
[]
[]
[]
[null,"4.3 Soil Salinity"]
[]
[null,"Low",null,null,null,"Medium",null,null,null,"High",null,null,null,"Others"]
[]
[null,"pH-Value",{"$nulls":7},"Organic Matter Content",{"$nulls":5},"%"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"4.4 Cash Crop Type"]
[]
[null,"Vegetables",null,null,null,"Cereals",null,null,null,"Tree Crops",null,null,null,"Flowers"]
[]
[null,"Others",{"$nulls":7},"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"4.5 Crop Rotation"]
[]
[null,"Number of crops per year",{"$nulls":8},"Fallow Period",{"$nulls":4},"days"]
[{"$nulls":10},"(no crops planted)"]
[null,"Crop 1 (type and duration)",{"$nulls":12},"days per year"]
[]
[null,"Crop 2 (type and duration)",{"$nulls":12},"days per year"]
[]
[null,"Crop 3 (type and duration)",{"$nulls":12},"days per year"]
[]
[null,"Crop 4 (type and duration)",{"$nulls":12},"days per year"]
[]
[null,"Crop 5 (type and duration)",{"$nulls":12},"days per year"]
[]
[]
[null,"4.6 Irrigation Water Demand"]
[]
[null,"Water Demand [m³/d]",null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,"Crop 1"]
[null,"Crop 2"]
[null,"Crop 3",null,"[°C]"]
[null,"Crop 4",null,"[°C]"]
[null,"Crop 5",null,"mm"]
[null,"Total Demand",null,"mm"]
[]
[]
[null,"4.7 Livestock Type"]
[]
[null,"Cattle",null,null,null,"Goats",null,null,null,"Sheep",null,null,null,"Wildlife"]
[]
[null,"Others",{"$nulls":7},"Others"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"4.8 Livestock Quantity"]
[]
[]
[null,"Livestock 1 (type and quantity)",{"$nulls":12},"head per year"]
[]
[null,"Livestock 2 (type and quantity)",{"$nulls":12},"head per year"]
[]
[null,"Livestock 3 (type and quantity)",{"$nulls":12},"head per year"]
[]
[null,"Livestock 4 (type and quantity)",{"$nulls":12},"head per year"]
[]
[null,"Livestock 5 (type and quantity)",{"$nulls":12},"head per year"]
[]
[]
[null,"4.9 Livestock Water Demand"]
[]
[null,"Water Demand [m³/d]",null,null,"J","F","M","A","M","J","J","A","S","O","N","D"]
[null,"Livestock 1"]
[null,"Livestock 2"]
[null,"Livestock 3"]
[null,"Livestock 4"]
[null,"Livestock 5"]
[null,"Total Demand",null,"mm"]

{"sheet":"5 Water Pumping Technology","index":5,"n_rows":171,"n_cols":16,"rows_kept":171,"cut":false,"hidden":false,"merged":[[170,1,170,2],[170,4,170,10],[170,12,170,13],[146,1,146,2],[146,4,146,10],[146,12,146,13],[119,12,119,13],[120,12,120,13],[114,2,114,8],[114,9,114,11],[114,12,114,13],[119,9,119,11],[120,9,120,11],[118,2,118,8],[115,12,115,13],[116,12,116,13],[117,12,117,13],[118,12,118,13],[119,2,119,8],[120,2,120,8],[113,9,113,11],[115,9,115,11],[116,9,116,11],[117,9,117,11],[118,9,118,11],[115,2,115,8],[116,2,116,8],[117,2,117,8],[104,12,104,13],[111,2,111,8],[112,2,112,8],[113,2,113,8],[104,2,104,8],[105,2,105,8],[106,2,106,8],[107,2,107,8],[108,2,108,8],[113,12,113,13],[105,12,105,13],[106,12,106,13],[107,12,107,13],[108,12,108,13],[109,12,109,13],[110,12,110,13],[111,12,111,13],[112,12,112,13],[102,1,102,15],[90,5,90,15],[92,5,92,6],[94,5,94,6],[94,14,94,15],[109,2,109,8],[110,2,110,8],[104,9,104,11],[105,9,105,11],[106,9,106,11],[107,9,107,11],[108,9,108,11],[109,9,109,11],[110,9,110,11],[111,9,111,11],[112,9,112,11],[88,5,88,15],[75,5,75,15],[77,5,77,6],[77,14,77,15],[79,5,79,6],[79,12,79,13],[79,14,79,15],[96,4,97,15],[98,4,99,15],[92,14,92,15],[94,7,94,8],[31,1,31,15],[51,4,52,15],[53,4,54,15],[39,5,39,15],[41,5,41,15],[43,5,43,6],[43,14,43,15],[81,4,82,15],[83,4,84,15],[64,5,64,15],[66,4,67,15],[68,4,69,15],[73,5,73,15],[60,5,60,15],[62,5,62,15],[45,14,45,15],[45,5,45,6],[47,5,47,6],[47,14,47,15],[49,5,49,15],[68,1,69,3],[25,4,26,15],[27,4,28,15],[7,14,7,15],[23,4,23,5],[9,0,9,16],[11,1,11,15],[17,4,17,15],[19,4,19,15],[27,1,28,3]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["5 WATER PUMPING TECHNOLOGY"]
[]
[null,"5.1 Conventional Water Pump"]
[]
[null,"Pump Type",null,null,"Surface Pump",{"$nulls":6},"Submersible Pump"]
[]
[null,"Positive Displacement",{"$nulls":5},"Centrifugal",{"$nulls":5},"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Max. Head",null,null,null,"m",null,"Max. Flow Rate",null,null,null,"m³/h"]
[]
[null,"Operating Time",{"$nulls":4},"h/d"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. installation depth)"]
[]
[]
[]
[null,"5.2 Photovoltaic Pumping System"]
[]
[null,"Solar Cell Type",null,null,"Si-poly",{"$nulls":8},"Si-mono"]
[]
[{"$nulls":4},"Thin-film",{"$nulls":8},"Others"]
[]
[null,"Solar Generator"]
[]
[null,"Module Manufacturer"]
[]
[null,"Model"]
[]
[null,"Module Nom. Power",{"$nulls":5},"Wp",null,null,null,"Modules in Series"]
[]
[null,"Generator Nom. Power",{"$nulls":5},"kWp",null,null,null,"Strings in Parallel"]
[]
[null,"Tilt Agle",{"$nulls":5},"°",null,null,null,"Azimut Angle"]
[]
[null,"Shadings"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[null,"Mounting System",null,null,"Fixed South/North",{"$nulls":8},"Tracking"]
[]
[{"$nulls":4},"Fixed West/East",{"$nulls":8},"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Mounting Type"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. single or double axis tracking)"]
[]
[]
[null,"Controller/Inverter"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null," Nominal Power max.",{"$nulls":5},"kW",null,null,"Number of Controllers"]
[]
[null,"Input Voltage max.",{"$nulls":5},"V",null,null,"Total Power",null,null,null,"kW AC"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[null,"Pump Unit"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Maximum Head",{"$nulls":5},"m",null,"Max. Flow Rate",{"$nulls":4},"m3/d"]
[]
[null,"Max. Flow per day",{"$nulls":5},"m3/d",null,"Total Pump Volume",{"$nulls":4},"m3/a"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"5.3 Determination of Pumping Head"]
["This checklist is complemented by a calculation tool in:",{"$nulls":8},"DESIGN 03 - Pump Sizing Tool"]
[null,"Hg","Geodetic Pumping Head",{"$nulls":9},"m"]
[null,"Hs","Static Water Level",{"$nulls":9},"m"]
[null,"D","Drawdown",{"$nulls":9},"m"]
[null,"Hd","Dynamic Water Level",{"$nulls":9},"m"]
[null,"Hp","Depth of Pump Intake",{"$nulls":9},"m"]
[null,"Hw","Depth of Well",{"$nulls":9},"m"]
[null,"He","Elevation Difference Well/Tank",{"$nulls":9},"m"]
[null,"Ht","Height of Tank Inlet",{"$nulls":9},"m"]
[null,"dw","Diameter of Well Casing",{"$nulls":9},"mm"]
[null,"dr","Diameter of Riser Pipe",{"$nulls":9},"mm/inch"]
[null,"dp","Diameter of Transmission Pipe",{"$nulls":9},"mm/inch"]
[null,"lp","Length of Transmission Pipe",{"$nulls":9},"m"]
[null,"V","Volume of Water Tank",{"$nulls":9},"m3"]
[null,"Hl","Head Loss in Pipeline",{"$nulls":9},"m"]
[null,"Hm","Head Loss in Water Meter",{"$nulls":9},"m"]
[null,"Hf","Head Loss in Filter/Fertigation",{"$nulls":9},"m"]
[null,"Hirrig","Pressure Irrigation System",{"$nulls":9},"m"]
[]
[]
[null,"Direct feed in"]
{"$rows_empty":22}
[null,"Htotal",null,"=","Hs + D + He + Hm + Hf + Hl + Hirrig",{"$nulls":6},"=",null,null,"m"]
[]
[]
[null,"Tank system"]
{"$rows_empty":20}
[null,"Htotal",null,"=","Hs + D + He + Ht + Hm + Hf + Hl",{"$nulls":6},"=",null,null,"m"]

{"sheet":"6 Irrigation Technology","index":6,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[[54,4,55,15],[56,1,57,3],[117,4,118,15],[89,5,89,15],[95,5,95,6],[95,13,95,14],[97,5,97,15],[99,4,100,15],[101,4,102,15],[91,5,91,15],[113,5,113,15],[111,5,111,15],[105,1,105,15],[56,4,57,15],[59,1,59,15],[69,13,69,14],[115,4,116,15],[87,5,87,15],[79,1,79,15],[73,4,74,15],[75,4,76,15],[63,5,63,15],[65,5,65,15],[69,5,69,6],[71,5,71,15],[21,4,22,15],[25,1,25,15],[28,5,28,15],[30,5,30,6],[30,13,30,14],[32,4,33,15],[52,13,52,14],[34,4,35,15],[44,5,44,15],[46,5,46,15],[38,1,38,15],[50,5,50,6],[52,5,52,6],[9,0,9,16],[11,1,11,15],[19,4,20,15],[17,13,17,14],[7,14,7,15],[13,6,13,7],[13,13,13,14],[15,13,15,14],[50,13,50,14]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["6 IRRIGATION TECHNOLOGY"]
[]
[null,"6.1 Irrigated Area"]
[]
[null,"Number of Plots/Sub-Fields",{"$nulls":7},"Size of Plots/Sub-Fields",{"$nulls":5},"ha"]
[]
[{"$nulls":15},"ha"]
[]
[{"$nulls":15},"ha"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"6.2 Feed Pipe"]
[]
[]
[null,"Material"]
[]
[null,"Diameter",{"$nulls":5},"mm",null,null,null,"Length",null,null,null,"m"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"6.3 Water Distribution System"]
[]
[null,"Gravity System",{"$nulls":9},"Pressurized System"]
[]
[null,"Drip",null,null,"Mini-Sprinkler",{"$nulls":4},"Center Pivot",null,null,null,"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Pressure Compensation "]
[]
[null,"Nominal Pressure",{"$nulls":5},"m",null,"Operating Pressure",{"$nulls":5},"m"]
[]
[null,"Nominal Flow",{"$nulls":5},"l/h",null,"Distribution Uniformity",{"$nulls":5},"%"]
[]
[null,"Observation /"]
[null,"Remarks"]
[null,"(e.g. clogging sensitivity, water losses)"]
[]
[]
[null,"6.4 Filter System"]
[]
[null,"Fins",null,null,"Granulate",{"$nulls":4},"Sand",null,null,null,"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Manual Backwashing",{"$nulls":8},"Automatic Backwashing"]
[]
[null,"Nominal Pressure",{"$nulls":5},"m",null,"Operating Presssure",{"$nulls":5},"m"]
[]
[null,"Other Information"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"6.5 Fertigation/Chemication"]
[]
[null,"Fertilizer/Pesticide Application"]
[]
[null,"Manually",null,null,null,"Pressurized Differential Tank",{"$nulls":6},"Bladder Tank"]
[]
[null,"Dosing Pump",{"$nulls":5},"Venturi Nozzle",{"$nulls":5},"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Power Supply"]
[]
[null,"Power Consumption",{"$nulls":4},"W"]
[]
[null,"Nominal Pressure",{"$nulls":5},"m",null,"Operating Presssure",{"$nulls":5},"m"]
[]
[null,"Other Information"]
[]
[null,"Observation /"]
[null,"Remarks"]
[]
[]
[]
[]
[null,"6.6 Monitoring"]
[]
[null,"Soil Moisture",{"$nulls":5},"Flow Rates",{"$nulls":4},"Pressure"]
[]
[null,"Temerature",{"$nulls":5},"Rainfall",{"$nulls":5},"Others"]
[]
[null,"Manufacturer"]
[]
[null,"Model"]
[]
[null,"Observation /"]
[null,"Remarks"]

{"sheet":"7 Management Requirements","index":7,"n_rows":409,"n_cols":16,"rows_kept":409,"cut":false,"hidden":false,"merged":[[389,3,391,15],[394,1,394,15],[401,3,403,15],[406,1,406,15],[408,3,410,15],[361,1,361,15],[370,3,372,15],[375,1,375,15],[377,3,379,15],[382,1,382,15],[340,3,342,15],[345,1,345,15],[347,3,349,15],[352,1,352,15],[356,3,358,15],[317,1,317,15],[324,3,326,15],[329,1,329,15],[333,3,335,15],[338,1,338,15],[286,3,288,15],[291,1,291,15],[298,3,300,15],[303,1,303,15],[312,3,314,15],[265,3,267,15],[270,1,270,15],[272,3,274,15],[277,1,277,15],[279,1,279,15],[242,1,242,15],[244,3,246,15],[249,1,249,15],[253,3,255,15],[258,1,258,15],[221,3,223,15],[226,1,226,15],[228,3,230,15],[233,1,233,15],[237,3,239,15],[189,1,189,15],[193,3,195,15],[198,1,198,15],[207,3,209,15],[212,1,212,15],[161,3,163,15],[166,1,166,15],[175,3,177,15],[180,1,180,15],[184,3,186,15],[136,3,138,15],[141,1,141,15],[143,1,143,15],[152,3,154,15],[157,1,157,15],[129,1,129,5],[129,6,129,7],[129,9,129,13],[129,14,129,15],[132,1,132,15],[9,0,9,16],[11,1,11,15],[7,14,7,15],[13,14,13,15],[14,1,14,5],[15,1,15,5],[16,1,16,5],[14,14,14,15],[15,14,15,15],[16,14,16,15],[13,12,13,13],[13,6,13,8],[13,9,13,11],[13,1,13,5],[14,6,14,8],[14,9,14,11],[14,12,14,13],[15,6,15,8],[15,9,15,11],[15,12,15,13],[16,6,16,8],[16,9,16,11],[16,12,16,13],[17,14,17,15],[18,6,18,8],[18,9,18,11],[18,12,18,13],[18,14,18,15],[24,1,24,5],[24,6,24,8],[24,9,24,11],[24,12,24,13],[24,14,24,15],[17,1,17,5],[18,1,18,5],[17,6,17,8],[17,9,17,11],[17,12,17,13],[25,1,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,13],[25,14,25,15],[26,1,26,5],[26,6,26,8],[26,9,26,11],[26,12,26,13],[26,14,26,15],[27,9,27,11],[27,12,27,13],[27,14,27,15],[30,12,30,13],[30,14,30,15],[28,1,28,5],[28,6,28,8],[28,9,28,11],[28,12,28,13],[28,14,28,15],[75,1,75,15],[84,3,86,15],[89,1,89,15],[93,3,95,15],[98,1,98,15],[100,6,100,7],[66,1,66,15],[20,3,22,15],[32,3,34,15],[61,3,63,15],[70,3,72,15],[37,1,37,15],[39,1,39,15],[48,1,48,15],[29,1,29,5],[29,6,29,8],[29,9,29,11],[29,12,29,13],[29,14,29,15],[30,1,30,5],[30,6,30,8],[30,9,30,11],[27,1,27,5],[27,6,27,8],[127,1,127,15],[109,1,109,5],[111,3,113,15],[116,1,116,15],[122,3,124,15],[109,6,109,7],[102,3,104,15],[100,1,100,5],[107,1,107,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["7 MANAGEMENT REQUIREMENTS"]
[]
[null,"7.1 Players in Farm Management"]
[]
[null,"Internal Players",{"$nulls":4},"Helpful",null,null,"Not Present",null,null,"Missing",null,"Do not Know"]
[null,"Farm Owner"]
[null,"Facility Manager"]
[null,"Foreman"]
[null,"Field Workers"]
[null,"Others"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"Internal Players",{"$nulls":4},"Helpful",null,null,"Not Present",null,null,"Missing",null,"Do not Know"]
[null,"Water Authority"]
[null,"Association"]
[null,"Agricultural Advisors"]
[null,"Agricultural suppliers"]
[null,"Financial advisors"]
[null,"Others"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"7.2 Strategic management (horizon: >5-20 years)"]
[]
[null,"How did you hear about SPIS / Source of Information?"]
[]
[null,null,"Agricultural advisory services",{"$nulls":6},"Financial advisory services"]
[]
[null,null,"Agricultural supplier",{"$nulls":6},"Neighbor/friend"]
[]
[null,null,"Radio/television",{"$nulls":6},"internet"]
[]
[]
[null,"What was the reason to switch from conventional to photovoltaic energy supply?"]
[]
[null,null,"Weak or not existing grid power",{"$nulls":6},"Subsidy cuts for conventional fuel"]
[]
[null,null,"Problems with fuel supply",{"$nulls":6},"Lower technical reliability of convent. System"]
[]
[null,null,"Problems with spare parts supply",{"$nulls":6},"Lower cost of solar system"]
[]
[null,null,"Environmentally sound technology",{"$nulls":6},"Positive (green) image"]
[]
[null,null,"Protection of ground water level and quality"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Could you purchase all components of the SPIS locally?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Which components needed to be imported by you?"]
[]
[null,null,"Solar panels",{"$nulls":6},"Mounting system"]
[]
[null,null,"Pump/ controller",{"$nulls":6},"Irrigation system"]
[]
[null,null,"Fertigation system"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Did the change from conventional to photovoltaic energy supply require a change of the irrigation technology?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How many years of experience do you have with conventional water pumping?"]
[]
[null,"Number of years experience: "]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How many years of experience do you have with photovoltaic water pumping?"]
[]
[null,"Number of years experience: "]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How was the system financed?"]
[]
[null,null,"Own equity",{"$nulls":6},"Standard Bank loan"]
[]
[null,null,"Agricultural credit",{"$nulls":6},"Others"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"If financing was applied"]
[]
[null,"Intereste rate (%)",{"$nulls":7},"Payback time (years)"]
[]
[]
[null,"Would you invest again in a SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"7.3 Tactical management (horizon: <1 year)"]
[]
[null,"What was the reason for choosing the crops mentioned under 4.4?"]
[]
[null,"High market demand",{"$nulls":6},"Pest resistent"]
[]
[null,"High market price",{"$nulls":6},"Other"]
[]
[null,"Low water demand",{"$nulls":6},"Other"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Are sufficient farm workers available during planting and harvesting season?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the technical knowledge of your farm workers?"]
[]
[null,null,"Low",{"$nulls":6},"Excellent"]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[null,null,"High"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Have you ever experienced problems in fuel and spare parts supply of the conventional pumping system?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Have you ever experienced problems in spare parts supply of the photovoltaic pumping system?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the technical reliability of a conventional pumping system?"]
[]
[null,null,"Low",{"$nulls":6},"Excellent"]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[null,null,"High"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the technical reliability of a solar pumping system?"]
[]
[null,null,"Low",{"$nulls":6},"Excellent"]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[null,null,"High"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Regarding SPIS, what needs to be technically improved from your point of view?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Have you ever experienced problems in water availability and supply?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"If yes, what were the reasons for the water shortage?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you have easy market access to sell your products?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the logistical efforts to bring the products to the market?"]
[]
[null,null,"Low",{"$nulls":6},"Difficult"]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Did you notice any other challenges in tactical farm management?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"7.4 Operational management (horizon: 1 day)"]
[]
[null,"Who is operating your SPIS?"]
[]
[null,null,"Foreman",{"$nulls":6},"Other"]
[]
[null,null,"Farm worker"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How is the SPIS being controlled?"]
[]
[null,null,"Automatic Operation",{"$nulls":6},"Manual"]
[]
[null,null,"Semi-Automatic"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How do you determine the daily water demand of the plants?"]
[]
[null,null,"ETo calculation",{"$nulls":6},"Estimation"]
[]
[null,null,"Software",{"$nulls":6},"Other"]
[]
[null,null,"Experience"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"If you have several sub-fields, what is your irrigation technique?"]
[]
[null,null,"Volume Control",{"$nulls":6},"Others"]
[]
[null,null,"Time control"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you suffer from any water losses in the system?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"If yes, what do you do in order to avoid water losses?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"What are the cleaning intervals of filters?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you know about the pressure losses caused by clogged filters?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How do you determine the fertilizer demand of the plants?"]
[]
[null,null,"Calculation",{"$nulls":6},"Estimation"]
[]
[null,null,"Software",{"$nulls":6},"Other"]
[]
[null,null,"Experience"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"What are the fertigation intervals?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the daily maintenance requirements of a conventional pumping system?"]
[]
[null,null,"Low",{"$nulls":6},"High "]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How would you assess the daily maintenance requirements of a photovoltaic pumping system?"]
[]
[null,null,"Low",{"$nulls":6},"High "]
[]
[null,null,"Medium",{"$nulls":6},"Other"]
[]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Any other challenges in operational farm management?"]
[]
[null,"Remarks"]

{"sheet":"8 Financial Assessment","index":8,"n_rows":264,"n_cols":16,"rows_kept":264,"cut":false,"hidden":false,"merged":[[39,1,40,5],[43,1,44,5],[47,1,48,5],[51,1,52,5],[55,1,56,5],[59,1,60,5],[261,6,261,15],[167,6,167,15],[199,6,199,15],[231,6,231,15],[227,6,227,15],[229,6,229,15],[235,6,235,15],[237,6,237,15],[239,6,239,15],[217,6,217,15],[219,6,219,15],[221,6,221,15],[223,6,223,15],[189,6,189,15],[191,6,191,15],[171,6,171,15],[173,6,173,15],[175,6,175,15],[263,6,263,15],[251,6,251,15],[253,6,253,15],[255,6,255,15],[257,6,257,15],[259,6,259,15],[241,6,241,15],[243,6,243,15],[245,6,245,15],[247,6,247,15],[249,6,249,15],[225,6,225,15],[207,6,207,15],[209,6,209,15],[211,6,211,15],[213,6,213,15],[215,6,215,15],[193,6,193,15],[195,6,195,15],[197,6,197,15],[203,6,203,15],[205,6,205,15],[165,6,165,15],[147,6,147,15],[149,6,149,15],[151,6,151,15],[153,6,153,15],[155,6,155,15],[183,6,183,15],[185,6,185,15],[187,6,187,15],[179,6,179,15],[181,6,181,15],[52,6,52,15],[55,6,55,15],[56,6,56,15],[96,6,96,15],[98,6,98,15],[100,6,100,15],[85,6,85,15],[88,1,88,15],[90,6,90,15],[92,6,92,15],[94,6,94,15],[69,6,69,15],[71,6,71,15],[73,6,73,15],[75,6,75,15],[77,6,77,15],[79,6,79,15],[81,6,81,15],[83,6,83,15],[109,6,109,15],[103,1,103,15],[111,6,111,15],[113,6,113,15],[115,6,115,15],[117,6,117,15],[119,6,119,15],[177,6,177,15],[121,6,121,15],[123,6,123,15],[135,6,135,15],[139,6,139,15],[141,6,141,15],[143,6,143,15],[145,6,145,15],[125,6,125,15],[127,6,127,15],[129,6,129,15],[131,6,131,15],[133,6,133,15],[157,6,157,15],[159,6,159,15],[161,6,161,15],[163,6,163,15],[9,0,9,16],[12,1,12,15],[7,14,7,15],[107,6,107,15],[14,14,14,15],[16,14,16,15],[14,6,14,7],[16,6,16,7],[18,6,18,7],[20,11,20,15],[22,6,22,15],[43,6,43,15],[40,6,40,15],[44,6,44,15],[47,6,47,15],[36,1,36,15],[39,6,39,15],[59,6,59,15],[60,6,60,15],[63,1,63,15],[65,6,65,15],[67,6,67,15],[48,6,48,15],[51,6,51,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["8 FINANCIAL ASSESSMENTS"]
["This checklist is complemented by a calculation tool in:",{"$nulls":8},"DESIGN – Simplified Financial Viability Tool"]
["This checklist is complemented by a calculation tool in:",{"$nulls":8},"DESIGN – Farm Analysis Tool"]
[null,"8.1 Investment & Operation Costs"]
[]
[null,"Costs Pump Equipment",{"$nulls":7},"Year of Purchase/Installation"]
[]
[null,"Costs Distribution System",{"$nulls":7},"Year of Purchase/Installation"]
[]
[null,"Annual Maintenance Costs"]
[]
[null,"External Service Provider for O&M",{"$nulls":7},"Company"]
[]
[null,"Operational Costs Categories"]
[]
[null,null,"Type",{"$nulls":5},"Cost",null,null,null,"Frequency"]
[{"$nulls":12}," (Per month? Per year?)"]
{"$rows_empty":10}
[null,"8.2 Financing Strategy"]
[]
[null,"Loan for Pump Equipment",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Interest, Duration, etc.)"]
[]
[]
[null,"Loan for Distribution System",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Interest, Duration, etc.)"]
[]
[]
[null,"Loan for Storage/Filter System",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Interest, Duration, etc.)"]
[]
[]
[null,"Loan for O&M",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Interest, Duration, etc.)"]
[]
[]
[null,"Depreciation of Capital Costs",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Interest, Duration, etc.)"]
[]
[]
[null,"Subsidies",{"$nulls":4},"yes",null,null,"no"]
[null,"(Amount, Duration, etc.)"]
[]
[]
[]
[null,"8.3 Labor Requirements"]
[]
[null,"Farm Labor Requirements"]
[]
[null,"Crop 1 (w/d, EUR per w/d)"]
[]
[null,"Crop 2 (w/d, EUR per w/d)"]
[]
[null,"Crop 3 (w/d, EUR per w/d)"]
[]
[null,"Crop 4 (w/d, EUR per w/d)"]
[]
[null,"Crop 5 (w/d, EUR per w/d)"]
[]
[null,"Irrigation (w/d, EUR per w/d)"]
[]
[null,"Others (w/d, EUR per w/d)"]
{"$rows_empty":8}
[null,"8.4 Fees, Duties & Charges"]
[]
[null,"Water Tariff (EUR/m3)"]
[]
[null,"Electricity Tariff (EUR/kWh)"]
[]
[null,"Diesel Price (EUR/l)"]
[]
[null,"Other Charges & Duties (EUR)"]
[]
[]
[]
[]
[]
[]
[null,"8.5 Agricultural Production & Revenue"]
[]
[null,"Crop 1"]
[]
[null,"Crop Type / Area (ha)"]
[]
[null,"Production (kg)"]
[]
[null,"Sales (kg)"]
[]
[null,"Land Preparation (EUR)"]
[]
[null,"Input Seeds/Fertilizer (EUR)"]
[]
[null,"Input Plant Protection (EUR)"]
[]
[null,"Harvest (EUR)"]
[]
[null,"Transport/Storage (EUR)"]
[]
[null,"Irrigation System Quantity"]
[]
[null,"Pumping Hours"]
[]
[null,"Other Costs (w/d, EUR per w/d)"]
{"$rows_empty":7}
[null,"Market Price Produce (EUR/kg)"]
[]
[null,"Crop 2"]
[]
[null,"Crop Type / Area (ha)"]
[]
[null,"Production (kg)"]
[]
[null,"Sales (kg)"]
[]
[null,"Land Preparation (EUR)"]
[]
[null,"Input Seeds/Fertilizer (EUR)"]
[]
[null,"Input Plant Protection (EUR)"]
[]
[null,"Harvest (EUR)"]
[]
[null,"Transport/Storage (EUR)"]
[]
[null,"Irrigation System Quantity"]
[]
[null,"Pumping Hours"]
[]
[null,"Other Costs (w/d, EUR per w/d)"]
{"$rows_empty":7}
[null,"Market Price Produce (EUR/kg)"]
[]
[null,"Crop 3"]
[]
[null,"Crop Type / Area (ha)"]
[]
[null,"Production (kg)"]
[]
[null,"Sales (kg)"]
[]
[null,"Land Preparation (EUR)"]
[]
[null,"Input Seeds/Fertilizer (EUR)"]
[]
[null,"Input Plant Protection (EUR)"]
[]
[null,"Harvest (EUR)"]
[]
[null,"Transport/Storage (EUR)"]
[]
[null,"Irrigation System Quantity"]
[]
[null,"Pumping Hours"]
[]
[null,"Other Costs (w/d, EUR per w/d)"]
{"$rows_empty":7}
[null,"Market Price Produce (EUR/kg)"]
[]
[null,"Crop 4"]
[]
[null,"Crop Type / Area (ha)"]
[]
[null,"Production (kg)"]
[]
[null,"Sales (kg)"]
[]
[null,"Land Preparation (EUR)"]
[]
[null,"Input Seeds/Fertilizer (EUR)"]
[]
[null,"Input Plant Protection (EUR)"]
[]
[null,"Harvest (EUR)"]
[]
[null,"Transport/Storage (EUR)"]
[]
[null,"Irrigation System Quantity"]
[]
[null,"Pumping Hours"]
[]
[null,"Other Costs (w/d, EUR per w/d)"]
{"$rows_empty":7}
[null,"Market Price Produce (EUR/kg)"]
[]
[null,"Crop 5"]
[]
[null,"Crop Type / Area (ha)"]
[]
[null,"Production (kg)"]
[]
[null,"Sales (kg)"]
[]
[null,"Land Preparation (EUR)"]
[]
[null,"Input Seeds/Fertilizer (EUR)"]
[]
[null,"Input Plant Protection (EUR)"]
[]
[null,"Harvest (EUR)"]
[]
[null,"Transport/Storage (EUR)"]
[]
[null,"Irrigation System Quantity"]
[]
[null,"Pumping Hours"]
[]
[null,"Other Costs (w/d, EUR per w/d)"]
{"$rows_empty":7}
[null,"Market Price Produce (EUR/kg)"]

{"sheet":"9 Ecological Impacts","index":9,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[[97,1,99,3],[58,3,59,15],[62,1,62,15],[64,3,65,15],[68,1,68,15],[73,1,75,3],[76,1,76,15],[80,3,81,15],[84,1,84,15],[92,1,92,15],[89,1,91,3],[54,1,54,15],[56,1,56,5],[56,6,56,7],[56,9,56,13],[56,14,56,15],[21,3,22,15],[25,1,25,15],[31,3,32,15],[44,1,44,15],[50,3,51,15],[35,1,35,15],[41,3,42,15],[9,0,9,16],[7,14,7,15],[11,1,11,15],[15,3,16,15],[19,1,19,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["9 ECOLOGICAL IMPACTS"]
[]
[null,"Do you suffer from salting of soil?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"Which measures do you take to avoid salting of soil ?"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"How do you see the development of your ground water resources?"]
[]
[null,null,"Water resource is very reliable and stable",{"$nulls":7},"Water resource is often interrupted"]
[]
[null,null,"Water resource fluctuates seasonally",{"$nulls":7},"Water availability depends on other persons"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"How do you see the development of ground water resources in surrounding area?"]
[]
[null,null,"Many other pumps already operate",{"$nulls":7},"No control in pumping system development"]
[]
[null,null,"Many new pumping systems planned",{"$nulls":7},"Regular conflict with neighbours"]
[]
[null,"Remarks"]
[]
[]
[null,"Do you observe a ground water level variation?"]
[]
[null,null,"Yes, but only at my own water source",{"$nulls":6},"Yes, water levels in area have declined over years"]
[]
[null,null,"Yes, many dying trees in the area",{"$nulls":6},"No impacts detected"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"What is the maximum draw down of the water level during pumping?"]
[]
[null,"drawdown (m)"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"What do you do to avoid over-pumping of aquifers?"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"Do you see a difference in water quality after installing an SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[null,"e.g. by avoiding leakages of oil and lubricants"]
[]
[]
[null,"Do you see a difference in water availability after installing an SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[null,"Do you see a difference in soil quality after installing an SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[null,"e.g. by avoiding leakages of oil and lubricants"]
[]
[]
[null,"Are there any other environmental benefits you would like to mention?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[null,"e.g. by avoiding leakages of oil and lubricants"]

{"sheet":"10 Training & Acceptance","index":10,"n_rows":91,"n_cols":16,"rows_kept":91,"cut":false,"hidden":false,"merged":[[86,1,86,15],[90,3,92,15],[24,3,26,15],[29,1,29,15],[33,3,35,15],[38,1,38,15],[40,3,42,15],[54,1,54,15],[58,3,60,15],[63,1,63,15],[65,3,67,15],[45,1,45,15],[49,3,51,15],[70,1,70,15],[72,3,74,15],[77,1,77,15],[7,14,7,15],[81,3,83,15],[9,0,9,16],[11,1,11,15],[15,3,17,15],[20,1,20,15]]}
[]
[null,"DESIGN – Site Data Collection Tool",{"$nulls":10},"GPX Data",null,{"$f":"'1 General Information'!O2","v":0},{"$f":"'1 General Information'!P2","v":0}]
[]
[null,"Country",null,{"$f":"'1 General Information'!D4","v":0},{"$nulls":6},"Owner",null,{"$f":"'1 General Information'!M4","v":0}]
[]
[null,"Farm",null,{"$f":"'1 General Information'!D6","v":0},{"$nulls":6},"Interviewer",null,{"$f":"'1 General Information'!M6","v":0}]
[]
[null,"District",null,{"$f":"'1 General Information'!D8","v":0},{"$nulls":4},"Region",null,{"$f":"'1 General Information'!K8","v":0},null,null,"Date",{"$f":"'1 General Information'!O8:P8","v":0}]
[]
["10 TRAINING AND ACCEPTANCE"]
[]
[null,"Do you have an operational manual / training manual for your employees?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you get regular support from agricultural advisory services? What kind?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you have a specific need for training?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Could you please specify the need for training?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Would you be willing to pay for a qualified training on SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Have you ever experienced acceptance problems of farm managers, facility managers or farm workers regarding SPIS?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"If yes, what kind of acceptance problems have you experienced?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"How do you see the role of local / regional authorities in your region / country?"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Do you usually employ women on the farm?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]
[]
[]
[]
[]
[null,"Does the use of an SPIS have an influence on the number and gender of field workers and/or other staff members?"]
[]
[null,null,"Yes",{"$nulls":6},"No"]
[]
[null,"Remarks"]