{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["READ ME","Maintenance Checklist","Score Calculation"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":33,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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:  "]
[]
[null,null,null,null,null,"https://poweringag.org"]
[null,null,null,"Version:",null,"2.0 (July 2020)"]
[]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"© GIZ and FAO, 2018"]

{"sheet":"Maintenance Checklist","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,5],[41,1,41,5],[1,0,1,3],[40,1,40,5],[39,0,39,3]]}
["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,"Default Weight"]
[null,null,"Weight","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)",3,"Yes"]
["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",3,"Yes"]
["0. General","Does the farmer have contact details for technicians and other support services?",3,"Yes"]
["0. General","Are owner or location name and/or other identification marks painted on the back sheet of each PV panel still clearly readable?",3,"Yes"]
["1. Solar Generator","Is the safety fence in good condition? \n- Check for holes, corrosion, pole stability, etc. ",3,"Yes"]
["1. Solar Generator","Is the mounting structure mechanically stable? \n- Check for foundation stability, loose screws, etc. ",3,"Yes"]
["1. Solar Generator","Is the mounting structure protected against corrosion? \n- Check for corrosion of screws, washers, nuts, posts, coat of paint, etc",3,"Yes"]
["1. Solar Generator","Is there no shadow on the panels? \n- Check for dust, bird droppings, fast growing bushes and trees, newly erected poles, fences etc. ",3,"Yes"]
["1. Solar Generator","Are all solar panels free of signs of technical defects? \n- Check for broken glass, broken solar cells, burned parts, insufficient insulation of cables, browning of cells, delamination etc. ",3,"Yes"]
["1. Solar Generator","Are there no signs for misuse by people or signs of forced entry to the area?",3,"Yes"]
["2. Controller","Is the controller operating normally? \n- Check for any flashing diodes, etc. ",3,"Yes"]
["2. Controller","Is the controller and its casing free of animals, insects? \n- Check for signs of inhabitations, tightness of cable-glands, etc. ",3,"Yes"]
["2. Controller","The controller cannot over-heat and ventialtion is not blocked by objects?",3,"Yes"]
["4. Water pump","Is the pump inlet free from debris, dirt, mud, sand, etc.?",3,"Yes"]
["4. Water pump","Is the pump functioning normally (no strange sounds, scratching from sand, high muddines of water, etc.)?",3,"Yes"]
["4. Water pump","Is the water pump still well secured (e.g. with safety rope) to the well base?",3,"Yes"]
["5. Pipe system (from the well to the reservoir)","Are there any improvements from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?",3,"Yes"]
["5. Pipe system (from the well to the reservoir)","Are there no leaks, abnormal bends in the pipes from the pump to the reservoir?",3,"Yes"]
["5. Pipe system (from the well to the reservoir)","Are the pipes buried at least 30 cm (or otherwise covered) in the ground between the pump and the reservoir/irrigation system?",3,"Yes"]
["6. Reservoir","Are there no visible faults on the reservoir (cracks, leakages) or on the support of the reservoir (e.g. sagging foundation, loose or missing support struts)?",3,"Yes"]
["6. Reservoir","Is the reservoir flushed regularly (depending on water quality 1-4 times per month)?",3,"Yes"]
["6. Reservoir","Is the water in the reservoir clear from algae and dead animals?",3,"Yes"]
["7. Irrigation head","Is the filter clean? Recommended: clean daily, replace filter mesh every 6 months depending on water quality.",3,"Yes"]
["7. Irrigation head","Are none of the connectors (valves, fittings, etc.) leaking?",3,"Yes"]
["9. Irrigation system","Are pipes going to the field free of any leaks, bends, kinks or other problems?",3,"Yes"]
["9. Irrigation system","Are there any improvements from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?",3,"Yes"]
["9. Irrigation system","Are distribution pipes not leaking and free of bends or kinks? (A large, wet area in the field indicates a leaking drip line.)",3,"Yes"]
["9. Irrigation system","Is water delivery equally well distributed, the uniformity of application at an acceptable level? (Please see Tool 7.2 MAINTAIN- Water Application Uniformity Field guide)",3,"Yes"]
["9. Irrigation system","Are distribution pipes and drip laterals free from rodents or other animals damaging them (e.g. no burrow holes near drip lines)?",3,"Yes"]
["9. Irrigation system","Are none of the drip emitters clogged? (If clogged, tap with a small stick to “open” them up again- at daily interval if necessary)",3,"Yes"]
["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).",3,"Yes"]
["Score:",null,null,null,{"$f":"'Score Calculation'!$E$33","v":0.99999999999999933}]
["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:"]

{"sheet":"Score Calculation","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,null,"Weight","Yes or No?","Actual weight"]
["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)",{"$f":"'Maintenance Checklist'!C9","v":3},{"$f":"'Maintenance Checklist'!D9","v":"Yes"},{"$f":"IF(D2<>\"N/A\",C2/$C$33,0)","v":3.2258064516129031E-2}]
["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",{"$f":"'Maintenance Checklist'!C10","v":3},{"$f":"'Maintenance Checklist'!D10","v":"Yes"},{"$f":"IF(D3<>\"N/A\",C3/$C$33,0)","v":3.2258064516129031E-2}]
["0. General","Does the farmer have contact details for technicians and other support services?",{"$f":"'Maintenance Checklist'!C11","v":3},{"$f":"'Maintenance Checklist'!D11","v":"Yes"},{"$f":"IF(D4<>\"N/A\",C4/$C$33,0)","v":3.2258064516129031E-2}]
["0. General","Are owner or location name and/or other identification marks painted on the back sheet of each PV panel still clearly readable?",{"$f":"'Maintenance Checklist'!C12","v":3},{"$f":"'Maintenance Checklist'!D12","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Is the safety fence in good condition? \n- Check for holes, corrosion, pole stability, etc. ",{"$f":"'Maintenance Checklist'!C13","v":3},{"$f":"'Maintenance Checklist'!D13","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Is the mounting structure mechanically stable? \n- Check for foundation stability, loose screws, etc. ",{"$f":"'Maintenance Checklist'!C14","v":3},{"$f":"'Maintenance Checklist'!D14","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Is the mounting structure protected against corrosion? \n- Check for corrosion of screws, washers, nuts, posts, coat of paint, etc",{"$f":"'Maintenance Checklist'!C15","v":3},{"$f":"'Maintenance Checklist'!D15","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Is there no shadow on the panels? \n- Check for dust, bird droppings, fast growing bushes and trees, newly erected poles, fences etc. ",{"$f":"'Maintenance Checklist'!C16","v":3},{"$f":"'Maintenance Checklist'!D16","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Are all solar panels free of signs of technical defects? \n- Check for broken glass, broken solar cells, burned parts, insufficient insulation of cables, browning of cells, delamination etc. ",{"$f":"'Maintenance Checklist'!C17","v":3},{"$f":"'Maintenance Checklist'!D17","v":"Yes"},3.2258064516129031E-2]
["1. Solar Generator","Are there no signs for misuse by people or signs of forced entry to the area?",{"$f":"'Maintenance Checklist'!C18","v":3},{"$f":"'Maintenance Checklist'!D18","v":"Yes"},3.2258064516129031E-2]
["2. Controller","Is the controller operating normally? \n- Check for any flashing diodes, etc. ",{"$f":"'Maintenance Checklist'!C19","v":3},{"$f":"'Maintenance Checklist'!D19","v":"Yes"},3.2258064516129031E-2]
["2. Controller","Is the controller and its casing free of animals, insects? \n- Check for signs of inhabitations, tightness of cable-glands, etc. ",{"$f":"'Maintenance Checklist'!C20","v":3},{"$f":"'Maintenance Checklist'!D20","v":"Yes"},3.2258064516129031E-2]
["2. Controller","The controller cannot over-heat and ventialtion is not blocked by objects?",{"$f":"'Maintenance Checklist'!C21","v":3},{"$f":"'Maintenance Checklist'!D21","v":"Yes"},3.2258064516129031E-2]
["4. Water pump","Is the pump inlet free from debris, dirt, mud, sand, etc.?",{"$f":"'Maintenance Checklist'!C22","v":3},{"$f":"'Maintenance Checklist'!D22","v":"Yes"},3.2258064516129031E-2]
["4. Water pump","Is the pump functioning normally (no strange sounds, scratching from sand, high muddines of water, etc.)?",{"$f":"'Maintenance Checklist'!C23","v":3},{"$f":"'Maintenance Checklist'!D23","v":"Yes"},3.2258064516129031E-2]
["4. Water pump","Is the water pump still well secured (e.g. with safety rope) to the well base?",{"$f":"'Maintenance Checklist'!C24","v":3},{"$f":"'Maintenance Checklist'!D24","v":"Yes"},3.2258064516129031E-2]
["5. Pipe system (from the well to the reservoir)","Are there any improvements from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?",{"$f":"'Maintenance Checklist'!C25","v":3},{"$f":"'Maintenance Checklist'!D25","v":"Yes"},3.2258064516129031E-2]
["5. Pipe system (from the well to the reservoir)","Are there no leaks, abnormal bends in the pipes from the pump to the reservoir?",{"$f":"'Maintenance Checklist'!C26","v":3},{"$f":"'Maintenance Checklist'!D26","v":"Yes"},3.2258064516129031E-2]
["5. Pipe system (from the well to the reservoir)","Are the pipes buried at least 30 cm (or otherwise covered) in the ground between the pump and the reservoir/irrigation system?",{"$f":"'Maintenance Checklist'!C27","v":3},{"$f":"'Maintenance Checklist'!D27","v":"Yes"},3.2258064516129031E-2]
["6. Reservoir","Are there no visible faults on the reservoir (cracks, leakages) or on the support of the reservoir (e.g. sagging foundation, loose or missing support struts)?",{"$f":"'Maintenance Checklist'!C28","v":3},{"$f":"'Maintenance Checklist'!D28","v":"Yes"},3.2258064516129031E-2]
["6. Reservoir","Is the reservoir flushed regularly (depending on water quality 1-4 times per month)?",{"$f":"'Maintenance Checklist'!C29","v":3},{"$f":"'Maintenance Checklist'!D29","v":"Yes"},3.2258064516129031E-2]
["6. Reservoir","Is the water in the reservoir clear from algae and dead animals?",{"$f":"'Maintenance Checklist'!C30","v":3},{"$f":"'Maintenance Checklist'!D30","v":"Yes"},3.2258064516129031E-2]
["7. Irrigation head","Is the filter clean? Recommended: clean daily, replace filter mesh every 6 months depending on water quality.",{"$f":"'Maintenance Checklist'!C31","v":3},{"$f":"'Maintenance Checklist'!D31","v":"Yes"},3.2258064516129031E-2]
["7. Irrigation head","Are none of the connectors (valves, fittings, etc.) leaking?",{"$f":"'Maintenance Checklist'!C32","v":3},{"$f":"'Maintenance Checklist'!D32","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Are pipes going to the field free of any leaks, bends, kinks or other problems?",{"$f":"'Maintenance Checklist'!C33","v":3},{"$f":"'Maintenance Checklist'!D33","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Are there any impürovements from the original design since the last maintenance visit (extra connections, replacement of pipes, etc.)?",{"$f":"'Maintenance Checklist'!C34","v":3},{"$f":"'Maintenance Checklist'!D34","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Are distribution pipes not leaking and free of bends or kinks? (A large, wet area in the field indicates a leaking drip line.)",{"$f":"'Maintenance Checklist'!C35","v":3},{"$f":"'Maintenance Checklist'!D35","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Is water delivery equally well distributed, the uniformity of application at an acceptable level? (Please see Tool 7.2 MAINTAIN- Water Application Uniformity Field guide)",{"$f":"'Maintenance Checklist'!C36","v":3},{"$f":"'Maintenance Checklist'!D36","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Are distribution pipes and drip laterals free from rodents or other animals damaging them (e.g. no burrow holes near drip lines)?",{"$f":"'Maintenance Checklist'!C37","v":3},{"$f":"'Maintenance Checklist'!D37","v":"Yes"},3.2258064516129031E-2]
["9. Irrigation system","Are none of the drip emitters clogged? (If clogged, tap with a small stick to “open” them up again- at daily interval if necessary)",{"$f":"'Maintenance Checklist'!C38","v":3},{"$f":"'Maintenance Checklist'!D38","v":"Yes"},3.2258064516129031E-2]
["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).",{"$f":"'Maintenance Checklist'!C39","v":3},{"$f":"'Maintenance Checklist'!D39","v":"Yes"},3.2258064516129031E-2]
[null,"Sum Weight:    ",{"$f":"SUMIF($D$2:$D$32,\"<>N/A\",$C$2:$C$32)","v":93},null,{"$f":"SUMIF($D$2:$D$32,\"Yes\",$E$2:$E$32)","v":0.99999999999999933}]