{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PV_system_survey","Explanation","Definitions dropdownlists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":0,"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":"PV_system_survey","index":0,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[27,1,27,6],[11,2,11,6],[67,1,67,6],[57,1,57,6],[47,1,47,6],[37,1,37,6]]}
[null,null,null,null,null,"Survey version ","21 Oktober 2019"]
[]
["PV system basics",null,null,null,"Goal of this survey","How to start ?","Other questions"]
["System ID:",null,null,"PV module type"]
["Source of data",null,null,"Inverter type"]
["Country",null,null,"Mounting system type"]
["Climate zone",null,null,"Grounding of substructure & module frames/conductor"]
["Special stress",null,null,"Other system component"]
["Kind of system",null,null,"Nominal system power",null,"[kWp]"]
["Orientation",null,null,"Date of system start",null,"[MM/YYYY]"]
["Inclination",null,null,"Date of failure documented here",null,"[MM/YYYY]"]
["Comment if a field is orange"]
[]
["Integral data"]
[null,"Following failure specifications are based on investigated percentage of"]
["Total system power loss","Inverter","Cable and interconnector","PV module ","Mounting","Other","Comment"]
["[%]","[%]","[%]","[%]","[%]","[%]"]
[null,0,0,10,0,0]
[]
["Failure specification for",0,"% of the system"]
["Failed system part","Failure 1","Power loss 1","Failure 2","Power loss 2","Safety failure 1","Safety failure 2"]
[" ","specification","[%]","specification","[%]"]
["Inverter","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Cable and interconnector","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["PV module ","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Mounting","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Other system component","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Comment if a field is orange"]
[]
["Failure specification for",0,"% of the system"]
["Failed system part","Failure 1","Power loss 1","Failure 2","Power loss 2","Safety failure 1","Safety failure 2"]
[" ","specification","[%]","specification","[%]"]
["Inverter","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Cable and interconnector","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["PV module ","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Mounting","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Other system component","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Comment if a field is orange"]
[]
["Failure specification for",0,"% of the system"]
["Failed system part","Failure 1","Power loss 1","Failure 2","Power loss 2","Safety failure 1","Safety failure 2"]
[" ","specification","[%]","specification","[%]"]
["Inverter","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Cable and interconnector","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["PV module ","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Mounting","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Other system component","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Comment if a field is orange"]
[]
["Failure specification for",0,"% of the system"]
["Failed system part","Failure 1","Power loss 1","Failure 2","Power loss 2","Safety failure 1","Safety failure 2"]
[" ","specification","[%]","specification","[%]"]
["Inverter","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Cable and interconnector","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["PV module ","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Mounting","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Other system component","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Comment if a field is orange"]
[]
["Failure specification for",0,"% of the system"]
["Failed system part","Failure 1","Power loss 1","Failure 2","Power loss 2","Safety failure 1","Safety failure 2"]
[" ","specification","[%]","specification","[%]"]
["Inverter","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Cable and interconnector","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["PV module ","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Mounting","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Other system component","No failure","No detectable loss","No failure","No detectable loss","No failure","No failure"]
["Comment if a field is orange"]

{"sheet":"Explanation","index":1,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Goal of this survey."]
["We have designed a survey format to collect failure data of PV systems for various climate zones. The goal of the survey is to evaluate the possible different impacts of the failures for various climate zone and give recommendations for test methods depending on the climate zone. "]
[]
["How to start ?"]
[]
["For each PV system please make a new copy of the form with the button \"New from\". Use the new table to input your data. In the original sheet \"PV_system_survey\" you can not enter data. Fill in your data into the green marked fields. Click into the cells or onto the text to get a short description for the expected input. In many cases you can select a predefined item from a drop down list."]
[]
["How to make a copy of the current table or delete a table?"]
[]
["Use the button \"copy form\" to copy the current form. Use this to enter similar systems. To delete the current form use the button \"Delete from\". You can not delete the original sheet \"PV_system_survey\""]
[]
["I am finished, what to do with the document ?"]
[]
["Please send the document in the excel format to Marc Köntges: Marc.Koentges@ISFH.de"]
[]
["Other questions"]
[]
["What should I do if my input does not fit into the survey format ?"]
[]
["There are two possible ways to  solve your problem:"]
["1. If you have information which does not fit into the categories given in the drop down list please choose the item \"other\" and use the comment field in the associated section to specify your input. If you select other from the drop down list the form field color gets orange to remind you to add information into the comment field of the associated section."]
["2. In each drop down list you can choose the item \"unknown\" if you do not know the required data."]
[]
["I have only failure data of a part of PV modules (or other parts) of a PV system. How can I contribute the data into the survey format ?"]
[]
["The section \"Integral data\" is designed to specify the part of a system which is evaluated. For example you have only evaluated the failure of a system by analysing 10 of 1000 PV modules then put into the fields \"Inverter\", \"Cable and Connector\", \"Mounting\", \"Other\" 0% and in the cell \"PV module\" 1%."]
[]
["How could I input data from literature ?"]
[]
["Please fill in the IEEE formatted citation of the literature source into the field System ID. This information will avoid double input of the same literature into the data set."]
[]
["For what is the system ID good for ?"]
[]
["The system ID will be exchanged in the public version of the database with an arbitrary number. If the system ID is a literature citation the system ID will be used as reference. You should use the system ID to avoid double input of the same data for your own reminder. Furthermore the system ID may be used to address questions to the data set contributor."]
[]
["What happens when a Excel cell gets orange ?"]
[]
["A form field gets orange if you choose \"other\" or \"]0%-3%] \". In this case please also add a comment for that input into the form field \"Comment\" of the associated section. You can add multiple comments into this comment form field. You may choose the power loss range ]0%-3%] only if you have measured data relative to an reference system/system part, because typically the measurement error of absolute measurements is about 3%."]

{"sheet":"Definitions dropdownlists","index":2,"n_rows":209,"n_cols":19,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
["Source of data","Country","Climate zone","Special stress","Kind of System","Grounding of substructure of module frames/conductor","Orientation","Inclination","PV module type","Inverter type","Mounting system type","Other component","Inverter_failure","Module_failure","Mounting_failure","Interconnect_failure","Extra comment","Power loss","Safety failure"]
["System owner","Afghanistan","Af","Agricultural environment","Facade/roof integrated commercial","Non/non"," -90° (east)","90 (horizontal)","Monocrystalline Si","Central inverter with trafo","Backrail","Battery ","No failure","No failure","No failure","No failure","Snail track","No detectable loss","No failure"]
["Expert","Albania","Am","Island, coastal region (10 km)","Facade/roof integrated test system","Grounded/non"," -67,5° (east-southeast)",80,"Multicrystalline Si","Central inverter without trafo","Clamps","Main AC cable ","Complete failure ","Acetic acid corrosion","System design failure","Connector does not fit (e.g. different manufacture)",null,"]0%-3%]","Fire/burn mark failure"]
["Installer","Algeria","Aw/As","Located on lake","Floating PV ","Grounded/conductor +"," -45° (southeast)",70,"CdTe","String inverter with trafo","Delta support","Main DC cable ","Failure due to external fire","Animal -> bite/corrosion/dirt","Overload of structure","Connector corroded",null,"]3%-10%]","Electrical isolation fails"]
["Internet survey","Andorra","BWh","Located offshore","Free standing commercial","Grounded/conductor -"," -22,5° (south-southeast)",60,"CIGS","String inverter without trafo","Facade integrated","Optimizer DC/AC","Failure due to internal fire","Biofilm soiling","Material failure","Defect combiner box",null,"]10%-20%]","Mechanical failure"]
["Manufacturer","Angola","BWk","Other","Free standing test system","Non/conductor +","0 (south)",50,"a-Si","Module inverter","Floating mounting system","Optimizer DC/DC","Interconnect failure","Burn marks","Indentation/damage of the roof","Defect string fuse",null,"]20%-30%]","Other"]
["Scientific publication","Antigua and Barbuda","BSh","Unknown","Roof top commercial","Non/conductor -","22,5° (south-southwest)",40,"Multijuntion a-Si","Resistor","Rail system at long sides","Other electric/electronic parts","Partial failure ","CdTe: back contact degradation","Clamp detachment/improperly installed","Animal bite/other animal issue",null,"]30%-40%]","Unknown"]
["Other","Argentina","BSk",null,"Roof top test system","Other","45° (south-west)",30,"Organic","Single module analyser","Rail system at short sides","Other mechanic parts","Theft/vandalism","Cell cracks","Failure due to external fire","Isolation failure",null,"]40%-50%]"]
["Unknown","Armenia","Csa",null,"Tracked system commercial","Unknown","67,5° (west-southwest)",20,"Other","Other","Roof integrated","Power transformer","Other","Corrosion/abrasion of AR coating","Failure due to internal fire","Wrong interconnection",null,"]50%-60%]"]
[null,"Aruba","Csb",null,"Tracked test system",null,"90° (west)",15,"Unknown","Unknown","Other","Other","Unknown","Defect backsheet","Theft/vandalism","Failure due to external fire",null,"]60%-70%]"]
[null,"Australia","Csc",null,"Other",null,"112,5° (west-northwest)",10,null,null,"Unknown","Unknown",null,"Defect junction box","Other","Failure due to internal fire",null,"]70%-80%]"]
[null,"Austria","Cwa",null,"Unknown",null,"135° (northwest)","0 (zenith)",null,null,null,null,null,"Defective bypass diode/wrong dimensioned","Unknown","Theft/vandalism",null,"]80%-90%]"]
[null,"Azerbaijan","Cwb",null,null,null,"157,5° (north-northwest)","other",null,null,null,null,null,"Delamination",null,"Other",null,"]90%-100%]"]
[null,"Bahamas, The","Cwc",null,null,null,"180° (north)","unknown",null,null,null,null,null,"Direct lightning stroke -> defect glass/frame and defect bypass diodes",null,"Unknown",null,"Other"]
[null,"Bahrain","Cfa",null,null,null," -157,5 (north-northeast)",null,null,null,null,null,null,"Discolouring of pottant",null,null,null,"Unknown"]
[null,"Bangladesh","Cfb",null,null,null," -135 (northeast)",null,null,null,null,null,null,"Disconnected cell or string interconnect ribbon"]
[null,"Barbados","Cfc",null,null,null," -112,5 (east-northeast)",null,null,null,null,null,null,"Dust soiling"]
[null,"Belarus","Dsa",null,null,null,"East/west",null,null,null,null,null,null,"Failure due to external fire"]
[null,"Belgium","Dsb",null,null,null,"Tracked",null,null,null,null,null,null,"Failure due to internal fire"]
[null,"Belize","Dsc",null,null,null,"Other",null,null,null,null,null,null,"Frame breakage/bown/defect"]
[null,"Benin","Dsd",null,null,null,"Unknown",null,null,null,null,null,null,"Glass breakage"]
[null,"Bhutan","Dwa",null,null,null,null,null,null,null,null,null,null,"Hail -> glass breakage/cell breakage"]
[null,"Bolivia","Dwb",null,null,null,null,null,null,null,null,null,null,"Humidity corrosion/silver finger corrosion"]
[null,"Bosnia and Herzegovina","Dwc",null,null,null,null,null,null,null,null,null,null,"Isolation failure"]
[null,"Botswana","Dwd",null,null,null,null,null,null,null,null,null,null,"Junction box detached"]
[null,"Brazil","Dfa",null,null,null,null,null,null,null,null,null,null,"LID/LeTID degradation"]
[null,"Brunei ","Dfb",null,null,null,null,null,null,null,null,null,null,"Potential induced corrosion (often with thin film modules)"]
[null,"Bulgaria","Dfc",null,null,null,null,null,null,null,null,null,null,"Potential induced shunts (often named PID-s)"]
[null,"Burkina Faso","Dfd",null,null,null,null,null,null,null,null,null,null,"Potential induced delamination "]
[null,"Burma","ET",null,null,null,null,null,null,null,null,null,null,"Potential induced polarization"]
[null,"Burundi","EF",null,null,null,null,null,null,null,null,null,null,"Snow load -> deformed frame/glass- /cell-breakage"]
[null,"Cambodia","Other",null,null,null,null,null,null,null,null,null,null,"Storm -> deformed frame/glass-/cell-breakage"]
[null,"Cameroon","Unknown",null,null,null,null,null,null,null,null,null,null,"Theft/vandalism"]
[null,"Canada",null,null,null,null,null,null,null,null,null,null,null,"Other"]
[null,"Cape Verde",null,null,null,null,null,null,null,null,null,null,null,"Unknown"]
[null,"Central African Republic"]
[null,"Chad"]
[null,"Chile"]
[null,"China"]
[null,"Colombia"]
[null,"Comoros"]
[null,"Congo, Democratic Republic of the"]
[null,"Congo, Republic of the"]
[null,"Costa Rica"]
[null,"Cote d'Ivoire"]
[null,"Croatia"]
[null,"Cuba"]
[null,"Curacao"]
[null,"Cyprus"]
[null,"Czech Republic"]
[null,"Denmark"]
[null,"Djibouti"]
[null,"Dominica"]
[null,"Dominican Republic"]
[null,"East Timor (see Timor-Leste)"]
[null,"Ecuador"]
[null,"Egypt"]
[null,"El Salvador"]
[null,"Equatorial Guinea"]
[null,"Eritrea"]
[null,"Estonia"]
[null,"Ethiopia"]
[null,"Fiji"]
[null,"Finland"]
[null,"France"]
[null,"Gabon"]
[null,"Gambia, The"]
[null,"Georgia"]
[null,"Germany"]
[null,"Ghana"]
[null,"Greece"]
[null,"Grenada"]
[null,"Guatemala"]
[null,"Guinea"]
[null,"Guinea-Bissau"]
[null,"Guyana"]
[null,"Haiti"]
[null,"Holy See"]
[null,"Honduras"]
[null,"Hong Kong"]
[null,"Hungary"]
[null,"Iceland"]
[null,"India"]
[null,"Indonesia"]
[null,"Iran"]
[null,"Iraq"]
[null,"Ireland"]
[null,"Israel"]
[null,"Italy"]
[null,"Jamaica"]
[null,"Japan"]
[null,"Jordan"]
[null,"Kazakhstan"]
[null,"Kenya"]
[null,"Kiribati"]
[null,"Korea, North"]
[null,"Korea, South"]
[null,"Kosovo"]
[null,"Kuwait"]
[null,"Kyrgyzstan"]
[null,"Laos"]
[null,"Latvia"]
[null,"Lebanon"]
[null,"Lesotho"]
[null,"Liberia"]
[null,"Libya"]
[null,"Liechtenstein"]
[null,"Lithuania"]
[null,"Luxembourg"]
[null,"Macau"]
[null,"Macedonia"]
[null,"Madagascar"]
[null,"Malawi"]
[null,"Malaysia"]
[null,"Maldives"]
[null,"Mali"]
[null,"Malta"]
[null,"Marshall Islands"]
[null,"Mauritania"]
[null,"Mauritius"]
[null,"Mexico"]
[null,"Micronesia"]
[null,"Moldova"]
[null,"Monaco"]
[null,"Mongolia"]
[null,"Montenegro"]
[null,"Morocco"]
[null,"Mozambique"]
[null,"Namibia"]
[null,"Nauru"]
[null,"Nepal"]
[null,"Netherlands"]
[null,"Netherlands Antilles"]
[null,"New Zealand"]
[null,"Nicaragua"]
[null,"Niger"]
[null,"Nigeria"]
[null,"North Korea"]
[null,"Norway"]
[null,"Oman"]
[null,"Pakistan"]
[null,"Palau"]
[null,"Palestinian Territories"]
[null,"Panama"]
[null,"Papua New Guinea"]
[null,"Paraguay"]
[null,"Peru"]
[null,"Philippines"]
[null,"Poland"]
[null,"Portugal"]
[null,"Qatar"]
[null,"Romania"]
[null,"Russia"]
[null,"Rwanda"]
[null,"Saint Kitts and Nevis"]
[null,"Saint Lucia"]
[null,"Saint Vincent and the Grenadines"]
[null,"Samoa "]
[null,"San Marino"]
[null,"Sao Tome and Principe"]
[null,"Saudi Arabia"]
[null,"Senegal"]
[null,"Serbia"]
[null,"Seychelles"]
[null,"Sierra Leone"]
[null,"Singapore"]
[null,"Sint Maarten"]
[null,"Slovakia"]
[null,"Slovenia"]
[null,"Solomon Islands"]
[null,"Somalia"]
[null,"South Africa"]
[null,"South Korea"]
[null,"South Sudan"]
[null,"Spain "]
[null,"Sri Lanka"]
[null,"Sudan"]
[null,"Suriname"]
[null,"Swaziland "]
[null,"Sweden"]
[null,"Switzerland"]
[null,"Syria"]
[null,"Taiwan"]
[null,"Tajikistan"]
[null,"Tanzania"]
[null,"Thailand "]
[null,"Timor-Leste"]
[null,"Togo"]
[null,"Tonga"]
[null,"Trinidad and Tobago"]
[null,"Tunisia"]
[null,"Turkey"]
[null,"Turkmenistan"]
[null,"Tuvalu"]
[null,"Uganda"]
[null,"Ukraine"]
[null,"United Arab Emirates"]
[null,"United Kingdom"]
[null,"United states"]
[null,"Uruguay"]
[null,"Uzbekistan"]
[null,"Vanuatu"]
[null,"Venezuela"]
[null,"Vietnam"]
[null,"Yemen"]
[null,"Zambia"]
[null,"Zimbabwe "]
[null,"other"]
[null,"unknown"]