{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["READ ME","Workmanship Checklist"],"not_rendered":{"charts":0,"images":7,"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":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,3,76,5],[38,3,38,4],[38,5,38,9],[39,3,41,4],[39,5,40,9],[41,5,41,7],[42,3,42,4],[42,5,42,7],[44,3,53,9],[55,3,66,9],[68,3,73,9],[30,3,31,5],[30,6,31,9],[34,3,34,4],[34,5,34,6],[10,3,10,9],[15,3,15,9],[17,3,17,9],[18,3,19,9],[27,3,27,9],[21,3,21,9],[35,3,36,4],[35,5,36,9],[37,3,37,4],[37,5,37,7],[33,3,33,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"SET UP – Workmanship Quality Checklist"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This checklist allows for the identification of workmanship related issues of an SPIS installation."]
[]
[]
[null,null,null,"Tips & Tricks"]
[]
[]
[]
[]
[]
[null,null,null,"Overview"]
[null,null,null,"This tool comprises the following sheets:"]
[]
[null,null,null,"1. Workmanship Checklist",null,null,"for systematically inspecting the SPIS installation"]
[]
[]
[null,null,null,"About"]
[null,null,null,"Published by: ",null,"GIZ & FAO"]
[null,null,null,"Responsible:",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," 1.1 (November 2018)"]
[]
[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":10}
[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":12}
[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, 2018"]

{"sheet":"Workmanship Checklist","index":1,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[1,0,1,4],[0,0,0,4],[42,1,42,4],[43,1,43,4],[41,0,41,2],[41,3,41,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4]]}
["SET UP – Workmanship Quality Checklist"]
["This checklist is designed for SPIS clients and agricultural extension agents who want to verify the quality of workmanship for an SPIS installation. \nThe checklist helps to assess if the quality of installation adheres to best practices, safety requirements and overall installation sustainability. \nIt does not replace the detailed component compliance, performance verification and workmanship checklist of the installer or an external inspector.  "]
["Farm name:"]
["SPIS supplier name:"]
["SPIS installer name:"]
["Inspection date:"]
[null,null,"Yes or No?","Comment and feedback to installer"]
["0. General","Did the farm manager receive written instructions on operation and maintenance of the SPIS components?","No"]
["0. General","Did the farmer receive on-site training on operation, maintenance and potential troubleshooting of the SPIS components?","No"]
["0. General","Did the farmer receive contact details for technicians and other technical support?","No"]
["0. General","Component compliance: are all the component installed (type, brand, quality, size, etc.) exactly the same as what was designed/invoiced? ","No"]
["0. General","Has an acceptance and system test taken place after installation and do all the components, and the entire system, perform as designed? ","No"]
["0. General","Is the installation properly protected from theft, stray animals, vandalism etc? /is the fence high, strong enough?","No"]
["0. General","Have the solar panels been clearly and prominently marked (on the underside) with the farm details or other unique identification?","No"]
["0. General","Have the serial numbers of key components been recorded in order to clearly claim ownership in the event of theft? ","No"]
["1. Solar Generator","Quality of solar panel: are there cracks, brown spots, burn marks, other abnormalities ?","No"]
["1. Solar Generator","Quality of panel cabling: are there any loose, unsealed or hanging cables? Any exposed copper wire visible? Any cables exposed to weather (sun/rain)?","No"]
["1. Solar Generator","Are the solar panels securely mounted (no loose or missing bolts) on the mounting structure?","No"]
["2. Mounting structure","Placement: have objects that might shadow the solar panels been removed? Is there a risk of shade and shadow in the future (e.g. small trees)?","No"]
["2. Mounting structure","Placement: is there enough space between the panels and other components to allow proper maintenance?","No"]
["2. Mounting structure","Are there no signs of corrosion or rust on the metal frames? Note: metal frames should not touch the aluminum solar panel frames as this might increase risk of galvanic corrosion.","No"]
["2. Mounting structure","Is the mounting structure stable and sturdy to withstand strong winds? Are there sufficient cross beams to avoid frame twisting?","No"]
["2. Mounting structure","If the mounting structure is cast into a cement foundation, are no cracks in the foundation? Does the foundation appear strong enough when hitting/kicking it?","No"]
["3. Controller/ Inverter","Is the controller protected against rain, in a casing rain proof or protected from animals/insects and vandals? \n- Check for signs of inhabitations, tightness of cable-glands, locks ","No"]
["3. Controller/ Inverter","Controller cannot over-heat and is placed with sufficient ventilation around it?","No"]
["3. Controller/ Inverter","Grounding/ earthing: Are the vital components of the solar generator protected against lightning? Are grounding cables (usually green/yellow insulation) installed?","No"]
["4. Water pump","Is the pump installation properly protected from theft, stray animals, vandalism, flooding, etc?","No"]
["4. Water pump","Was a well pump installed with a safety rope to allow for safe installation and extraction?","No"]
["4. Water pump","Are the electric cable and water pipe (feeder pipe) exiting the well or borehole protected from chafing and bending or kinks?","No"]
["5. Monitoring system","Are the gauges protected from damage through exposure to weather, people and animals?","No"]
["6. Reservoir","Are feeder pipes leading to and from the reservoir protected against physical damage and securely fastened? Protected against direct sunshine?","No"]
["6. Reservoir","If the reservoir or tank stand is placed onto a concrete foundation, are no cracks in the foundation? Does the foundation appear strong enough?","No"]
["6. Reservoir","If a tank stand is used, is it securely fixed onto the ground, with sufficient cross bars, to avoid toppling over?","No"]
["6. Reservoir","Can the reservoir be easily maintained?\n- Check for drainage pipes, and easy access to clean the inside ","No"]
["6. Reservoir","Is the reservoir closed at the top in order to avoid algae growth (which will clog piping) and reduce evaporation?","No"]
["7. Irrigation head","Can the irrigation head be easily maintained? \n- Check for accessibility to individual components and means to bypass certain components ","No"]
["7. Irrigation head","Is the required equipment for maintenance available and easily accessible \n- Check for storage of brushes, cloths, etc.","No"]
["8. Fertigation system","Is there a proper facility for storage of the chemicals/fertilizers in line with health and safety precautions?","No"]
["9. Irrigation system","Reparability: is it possible to easily replace individual components when they get broken? \n- Check if all the connections can be easily loosened, replaced and fastened","No"]
["9. Irrigation system","Are the drip laterals spaced according to the design and free of kinks and twists? ","No"]
["9. Irrigation system","Are none of the components, connections and fittings leaking?","No"]
["Score:",null,null,{"$f":"COUNTIF(C8:C41,\"Yes\")*2.94/100","v":0}]
["NOTE:","Hard water (with high lime content) will cause scaling up and clogging of irrigation pipes and dripper nozzles, if the irrigation pipes are exposed to heat (e.g. direct sun shine on black piping). Make sure to bury feeder pipes and protect other pipes and drippers from excessive exposure to heat."]
["Additional notes:"]