{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["READ ME","Maintenance 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":[[32,3,32,9],[33,3,33,9],[30,3,31,5],[30,6,31,9],[10,3,10,9],[15,3,15,9],[17,3,17,9],[18,3,19,9],[21,3,21,9],[27,3,27,9],[34,3,34,4],[34,5,34,6],[35,3,36,4],[35,5,36,9],[37,3,37,4],[37,5,37,7],[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],[68,3,73,9],[55,3,66,9],[44,3,53,9]]}
{"$rows_empty":10}
[null,null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,null,"MAINTAIN – Maintenance Checklist"]
[]
[null,null,null,"Introduction"]
[null,null,null,"This checklist guides the routine maintenance activities related issues of 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. Maintenance 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":"Maintenance Checklist","index":1,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,4],[39,1,39,4],[1,0,1,2],[38,1,38,4],[37,0,37,2]]}
["MAINTAIN – 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:"]
["Previous inspection date:"]
[null,null,"Yes or No?","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)","No"]
["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","No"]
["0. General","Does the farmer have contact details for technicians and other support services?","No"]
["0. General","Are farm name and/or other identification marks painted on the back sheet of each PV panel still clearly readable?","No"]
["1. Solar Generator","Is the safety fence in good condition? \n- Check for holes, corrosion, pole stability, etc. ","No"]
["1. Solar Generator","Is the mounting structure mechanically stable? \n- Check for foundation stability, loose screws, etc. ","No"]
["1. Solar Generator","Is the mounting structure protected against corrosion? \n- Check for corrosion of screws, washers, nuts, posts, coat of paint, etc","No"]
["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. ","No"]
["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 of cells, delamination etc. ","No"]
["1. Solar Generator","Are there any signs for misuse by people or signs of forced entry to the area?","No"]
["2. Controller","Is the controller operating normally? \n- Check for any flashing diodes, etc. ","No"]
["2. Controller","Is the controller and its casing ventilated and free of animals, insects? \n- Check for signs of inhabitations, tightness of cable-glands, etc. ","No"]
["5. 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.)?","No"]
["5. Conveyance system (from the well to the reservoir)","Is the pump inlet free from debris, dirt, mud, sand, etc.?","No"]
["5. Conveyance system (from the well to the reservoir)","Is the pump functioning normally (no strange sounds, scratching from sand, high muddines of water, etc.)?","No"]
["5. Conveyance system (from the well to the reservoir)","Are there any leaks, abnormal bends in the pipes from the pump to the reservoir?","No"]
["5. 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?","No"]
["6. Reservoir","Are there any visible defaults on the reservoir (cracks, breaks) or on the support of the reservoir?","No"]
["6. Reservoir","Is the reservoir flushed regularly (depending on water quality 1-4 times per month)?","No"]
["6. Reservoir","Is the water in the reservoir clear from algae?","No"]
["7. Irrigation head","Is the filter clean? Recommended: clean daily, replace filter mesh every 6 months depending on water quality.","No"]
["7. Irrigation head","Are there any leaking connectors (valves, etc.)?","No"]
["9. Irrigation system","Are there any leaks, bends, kinks or other problems with the pipes going to the field?","No"]
["9. Irrigation system","Are there any changes from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?","No"]
["9. Irrigation system","Are there any leaks, bends in the distribution pipes? (A large, wet area in the field indicates a leaking drip line.)","No"]
["9. Irrigation system","Is the uniformity of application at an acceptable level? (Please see Tool MAINTAIN 03- Water Application Uniformity Field guide)","No"]
["9. Irrigation system","Are there any signs of rodents or other animals damaging the distribution pipes and drip laterals?","No"]
["9. 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)","No"]
["9. 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).","No"]
["Score:",null,null,{"$f":"COUNTIF(C9:C37,\"Yes\")*(100/29)/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:"]