{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Read Me","Workmanship Checklist"],"not_rendered":{"charts":0,"images":3,"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":[[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],[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]]}
[]
["Read Me Sheet"]
[]
["Solar Powered Irrigation Systems - Manual and Tools"]
[]
[]
[]
[]
[]
[null,"Introduction"]
["SET UP 02 - Workmanship Quality Checklist"]
["This checklist allows for the identification of workmanship related issues of an SPIS installation."]
[]
[]
[null,"Overview"]
[]
["This tool comprises the following sheets:"]
[]
[null,"1. Workmanship Checklist",null,null,"for systematically inspecting the SPIS installation"]
{"$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, GFA Consulting"]
[null,"Version: 1.0 (January 2017)"]
[null,"Published by: Powering Agriculture – An Energy Grand Challenge for Development"]
[{"$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":"Workmanship Checklist","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5]]}
["SET UP 02- 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,"No","Yes","Comment and feedback to installer","Action required?"]
["0. General","Did the farm manager receive (written) instructions on operation and maintenance of the SPIS components?"]
["0. General","Component compliance: are all the component installed (type, brand, quality, size, etc.) exactly the same as what was designed/invoiced? "]
["0. General","Has an acceptance and system test taken place after installation and do all the components, and the entire system, perform as designed? "]
["0. General","Is the installation properly protected from theft, stray animals, vandalism etc? /is the fence high, strong enough?"]
["0. General","Have the solar panels been clearly and prominently marked (on the underside) with the farm details or other unique identification?"]
["0. General","Have the serial numbers of key components been recorded in order to clearly claim ownership in the event of theft? "]
["1. Solar Generator","Quality of solar panel: are there cracks, brown spots, other abnormalities ?"]
["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)?"]
["1. Solar Generator","Are the solar panels securely mounted (no loose or missing bolts) on the mounting structure?"]
["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)?"]
["2. Mounting structure","Placement: is there enough space between the panels and other components to allow proper maintenance?"]
["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."]
["2. Mounting structure","Is the mounting structure stable and sturdy to withstand strong winds? Are there sufficient cross beams to avoid frame twisting?"]
["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?"]
["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 "]
["3. Controller/ Inverter","Controller cannot over-heat and is placed with sufficient ventilation around it?"]
["3. Controller/ Inverter","Grounding/ earthing: Are the vital components of the solar generator protected against lightning? Are grounding cables (usually green/yellow insulation) installed?"]
["4. Water pump","Is the pump installation properly protected from theft, stray animals, vandalism, flooding, etc?"]
["4. Water pump","Was a well pump installed with a safety rope to allow for safe installation and extraction?"]
["4. Water pump","Are the electric cable and water pipe (feeder pipe) exiting the well or borehole protected from chafing and bending or kinks?"]
["5. Monitoring system","Are the gauges protected from damage through exposure to weather, people and animals?"]
["6. Reservoir","Are feeder pipes leading to and from the reservoir protected against physical damage and securely fastened? Protected against direct sunshine?"]
["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?"]
["6. Reservoir","If a tank stand is used, is it securely fixed onto the ground, with sufficient cross bars, to avoid toppling over?"]
["6. Reservoir","Can the reservoir be easily maintained?\n- Check for drainage pipes, and easy access to clean the inside "]
["6. Reservoir","Is the reservoir closed at the top in order to avoid algae growth (which will clog piping) and reduce evaporation?"]
["7. Irrigation head","Can the irrigation head be easily maintained? \n- Check for accessibility to individual components and means to bypass certain components "]
["7. Irrigation head","Is the required equipment for maintenance available and easily accessible \n- Check for storage of brushes, cloths, etc."]
["8. Fertigation system","Is there a proper facility for storage of the chemicals/fertilizers in line with health and safety precautions?"]
["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"]
["9. Irrigation system","Are the drip laterals spaced according to the design and free of kinks and twists? "]
["9. Irrigation system","Are none of the components, connections and fittings leaking?"]
["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:"]