{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Read Me","Maintenance 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":[[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],[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"]
["MAINTAIN 01- Maintenance Checklist"]
["This checklist guides the routine maintenance activities related issues of an SPIS installation."]
[]
[]
[null,"Overview"]
[]
["This tool comprises the following sheets:"]
[]
[null,"1. Maintenance 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":"Maintenance Checklist","index":1,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,5],[5,3,5,4]]}
["MAINTAIN 01- Maintenance Checklist"]
["This checklist on the solar PV generator, water conveyance and irrigation system is designed for producers and extension agents who want to verify the maintenance status of an SPIS. \nIt does not replace the detailed maintenance protocol (checklist, instructions, etc) of the producer."]
["Farm name:"]
["SPIS supplier name:"]
["SPIS installer name:"]
["Inspection date:",null,null,"Previous inspection date:"]
[null,null,"No","Yes","Describe what problem(s) you found","What can you recommend to the farm manager?"]
["0. General","Does the farmer manager have:\n* his/her own (written) instructions and a proper checklist for maintenance of the solar generator system?\n* the tools required to do proper maintenance e.g. cloth covered sponge or soft brush to remove the most stubborn grime on solar panels)"]
["0. General","Does the farmer manager have:\n* his/her own (written) instructions and a proper checklist for maintenance of the irrigation system?\n* the tools required to do proper maintenance e.g. brush, bucket, pincers, pliers, etc"]
["0. General","Are farm name and/or other identification marks painted on the back sheet of each PV panel still clearly readable?"]
["1. Solar Generator","Is the safety fence in good condition? \n- Check for holes, corrosion, pole stability, etc. "]
["1. Solar Generator","Is the mounting structure mechanically stable? \n- Check for foundation stability, loose screws, etc. "]
["1. Solar Generator","Is the mounting structure protected against corrosion? \n- Check for corrosion of screws, washers, nuts, posts, coat of paint, etc"]
["1. Solar Generator","Is there shadow on the panels? \n- Check for dust, bird droppings, fast growing bushes and trees, newly erected poles, fences etc. "]
["1. Solar Generator","Is there any sign of technical defects on the panels? \n- Check for broken glass, broken solar cells, burned parts, insufficient insulation of cables, browning, delamination etc. "]
["1. Solar Generator","Is the controller in normal operation mode? \n- Check for any flashing diodes, etc. "]
["1. Solar Generator","Is the controller and its casing ventilated and free of animals, insects? \n- Check for signs of inhabitations, tightness of cable-glands, etc. "]
["1. Solar Generator","Are there any signs for misuse by people or signs of forced entry to the area?"]
["2. Conveyance system (from the well to the reservoir)","Are there any changes from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?"]
["2. Conveyance system (from the well to the reservoir)","Is the pump inlet free from debris, dirt, etc.?"]
["2. Conveyance system (from the well to the reservoir)","Is the pump functioning normally (no strange sounds, etc.)?"]
["2. Conveyance system (from the well to the reservoir)","Are there any leaks, abnormal bends in the pipes from the pump to the reservoir?"]
["2. Conveyance system (from the well to the reservoir)","Are the pipes buried at least 30 cm in the ground between the pump and the reservoir/irrigation system?"]
["3. Reservoir","Are there any visible defaults on the reservoir (cracks, breaks) or on the support of the reservoir?"]
["3. Reservoir","Is the reservoir flushed regularly (depending on water quality 1-4 times per month)?"]
["3. Reservoir","Is the water in the reservoir clear from algae?"]
["4. Irrigation head","Is the filter clean? Recommended: clean daily, replace filter mesh every 6 months depending on water quality."]
["4. Irrigation head","Are there any leaking connectors (valves, etc.)?"]
["5. Irrigation system","Are there any leaks, bends, kinks or other problems with the pipes going to the field?"]
["5. Irrigation system","Are there any changes from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?"]
["5. Irrigation system","Are there any leaks, bends in the distribution pipes? (A large, wet area in the field indicates a leaking drip line.)"]
["5. Irrigation system","Is the uniformity of application at an acceptable level? (Please see Tool MAINTAIN 03- Water Application Uniformity Field guide)"]
["5. Irrigation system","Are there any signs of rodents or other animals damaging the distribution pipes and drip laterals?"]
["5. Irrigation system","Are there any drip emitters clogged (if clogged you can tap it with a small stick to “open” them up again- at daily interval)"]
["5. Irrigation system","Is the water clean when you flush the drip lines? (Open the ends of the drip lines at least once per week to flush them)."]
["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:"]