{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["GENERAL_INSTRUCTIONS","PRODUCT_INFORMATION","C1_RESISTANCE","C1_DATA","C2_MAINTENANCE_SERVICING","C2_DATA","C3_GUARANTEE","C3_DATA","C4_DOCUMENTATION","C4_Data","C5_DISASSEMBLY","C5_Data","C6_AVAILABILITY_SP","C6_Data","C7_PRICE","FINAL_SCORE","NOTE_FINALE","ANNEX_1","ANNEX_2","ANNEX_3"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":30,"comments":5,"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":"GENERAL_INSTRUCTIONS","index":0,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[48,2,48,6],[50,2,50,6],[0,2,0,6],[1,2,1,6],[7,2,7,6],[8,2,8,6],[13,3,13,6],[10,2,10,6],[29,3,30,6],[15,3,21,6],[36,3,38,6],[34,4,34,5],[15,1,17,1],[18,1,21,1],[14,3,14,6],[54,2,54,6],[49,2,49,6],[24,3,24,6],[23,3,23,6],[25,3,25,6],[22,3,22,6],[26,3,26,6],[27,3,27,6],[53,2,53,6],[52,2,52,6],[45,2,45,6],[46,2,46,6],[47,2,47,6]]}
[null,null,"DURABILITY INDEX WORKSHEET OF TELEVISION"]
[null,null,"GENERAL INSTRUCTIONS"]
[]
[null,null,"PURPOSE OF THE FILE"]
[null,null,"This Excel file calculates the durability index of a television."]
[]
[null,null,"REGULATORY FRAMEWORK"]
[null,null,"Article L. 541-9-2 of the French Environmental Code states that : Manufacturers, importers, marketers and other retailers which put electrical and electronic equipment (EEE) on the French market have to inform, free of charge, downstream sellers and any person who made the request of \"the durability index\" of their products, as well as the paramaters explaining how such index was established. This durability index will inform consumers about the durability the product category concerned. All information entered in this file must be truthful and verifiable.                                                                                                                                                                                                      "]
[null,null,"The methods and rules of implementation for the durability index are specified in the durability index Decree N°2024-316 for electrical and electronic equipment (EEE), the Decision 2024-04-05 on display conditions and parameters for calculating the durability index and the Decision 2024-04-05 on criteria, subcritera, rating system and display of thedurability index of television."]
[]
[null,null,"A complementary instructions manual provides explanatory informations and additional instructions on how to apply Decree and Orders of the durability index of electrical and electronic equipement."]
[]
[null,null,"FILE CONTENT"]
[null,null,"General instructions","Description of the purpose of this Excel file, description of regulatory framework of the reparabily index and description of file content and how it will be completed."]
[null,null,"Product information","Description of the product and the assessment of its repairability index."]
[null,"Reliability","C1_RESISTANCE TO STRESS AND/OR WEAR","Detailed criteria for assessing the product's durabilty index. For each tab, all the \"orange boxes\" must be filled in by selecting the right information from the \"drop-down menu\" or by entering the right information directly in the box. Once the information has been entered, the box in question turns \"green\". No box should be left blank. Note that the cells must be filled in one by one (they must not be drawn)."]
[null,null,"C2_MAINTENANCE AND SERVICING"]
[null,null,"C3_GUARANTEE AND QUALITY PROCESS"]
[null,"Reparability","C4_DOCUMENTATION"]
[null,null,"C5_DISASSEMBLY"]
[null,null,"C6_AVAILABILITY OF SAPRE PARTS"]
[null,null,"C7_PRICE"]
[null,null,"FINAL SCORE","This tab automatically calculate final score of the durability index of the product and also scores per criteria and sub-criteria, before and after weighting. "]
[null,null,"NOTE FINAL","This tab is the French translation of the \"Final score\" tab. It is automatically completed. This tab is to be sent to all applicants.\n\n"]
[null,null,"Annex 1","Details about the therminology used for the durability index."]
[null,null,"Annex 2","Details about the list of \"basic\" tools and their reference standards."]
[null,null,"Annex 3","Details and application case about the concept of disassembly step."]
[]
[null,null,"RESET ALL DATA"]
[null,null,null,"This button reset all data entered in the workbook. If you want to perform this action, please enable the file macro and click this button. WARNING: this action is irreversible.\n"]
[]
[]
[]
[null,null,"EXTRACTION OF DATA IN CSV"]
[null,null,null,"Name of file to create",null,null,".csv"]
[]
[null,null,null,"This button allows you to extract the data entered in the workbook, then export it to a file in CSV format. If you want to perform this action, please enable the file macro and click this button."]
[]
[]
[]
[]
[null,null,"link to access the data entry platform for TV","https://publier.etalab.studio/fr/upload?schema=etalab%2Findice-durabilite-televiseur"]
[]
[null,null,"OTHER DETAILS OF A TRANSVERSAL NATURE"]
[null,null,"Use of European vocabulary (criteria 4, 5 and 6)"]
[null,null,"The vocabulary used to describe the information to be documented, whatever the category concerned, as well as certain spare parts, is taken from Commission Regulation (EU) 2019/2023 of 1 October 2019 for Televisions and Commission Regulation (EU) 2019/2021 of 1 October 2019 for electronic displays. The list of these documents and items is given in Annex 1 of this notice."]
[null,null,"Different commitments of availability period between documentation and spare parts (criteria 4 and 6)"]
[null,null,"The producer or importer may make different commitments for the periods of availability of documentation and spare parts for the same equipment, for example: 9 years for the availability of documentation and 7 years for the availability of spare parts. "]
[null,null,"Absence of a part on the equipment "]
[null,null,"If the equipment does not include a part listed in List 1 or 2 of the category concerned, then the points corresponding to the part in question are awarded. For WIFI and Bluetooth modules, see the special case of televisions below. "]
[null,null,"Concerning criterion 4 relating to price, the price of the absent part does not appear in the calculation."]
[null,null,"Televisions"]
[null,null,"External power source and remote control"]
[null,null,"The external power source and the remote control do not need to be disassembled for counting the disassembly steps. The steps to be counted are limited to disconnecting the power source and removing the battery  from the remote control. "]

{"sheet":"PRODUCT_INFORMATION","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,1,4],[0,5,1,8],[3,1,3,5],[5,1,5,2],[15,3,15,5],[6,7,6,8],[9,7,9,8],[16,1,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[5,3,5,5],[6,1,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,1,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[6,9,6,11],[7,7,7,8],[7,9,7,11],[8,7,8,8],[8,9,8,11],[9,9,9,11],[10,7,10,8],[10,9,10,11],[11,7,11,8],[11,9,11,11]]}
[null,"INFORMATIONS RELATING TO THE PRODUCT AND \nTHE CALCULATION OF ITS REPAIRABILITY INDEX",null,null,null,"Television"]
[]
[]
[null,null,null,null,null,null,null,"link to access the data entry platform for television"]
[null,null,null,null,null,null,null,"https://publier.etalab.studio/fr/upload?schema=etalab%2Findice-durabilite-televiseur"]
[null,"DATE OF CALCULATION",null,"2025-04-09"]
[null,"REQUESTOR OF THE ASSESSMENT",null,null,null,null,null,"ID UNIQUE ",null,{"$f":"J9&\"-\"&J11&\"-\"&D6","v":"K-43S3--2025-04-09"},null,null,null,"Automatically completed"]
[null,null,"LAST NAME","OKADA",null,null,null,"REFERENTIEL ID MODELE",null,"GTIN_EAN",null,null,null,"The type of reference used for the product itentification according internationnal standard ISO15459 (SH4 ou GTIN_EAN)"]
[null,null,"FIRST NAME","HARUO",null,null,null,"ID MODELE",null,"K-43S3",null,null,null,"Model commercial reference or model identifier"]
[null,null,"MAIL","harry.okada@sony.com",null,null,null,"REFERENTIEL ID METTEUR SUR LE MARCHE",null,"Select a choice",null,null,null,"the type of reference used for the marketer identifier (GLN ou SYDEREP)"]
[null,null,"PHONE NUMBER","81 53750 4266",null,null,null,"ID METTEUR SUR LE MARCHE",null,null,null,null,null,"Official model name (GLN ou SYDEREP)"]
[null,"RESPONSIBLE FOR EVALUATION",null,"A compléter",null,null,null,"URL TABLEAU DETAIL NOTATION",null,"Please fill out",null,null,null,"The link to the detailed rating table (format: https://)"]
[null,null,"LAST NAME","Please fill out"]
[null,null,"FIRST NAME","Please fill out"]
[null,null,"MAIL","Please fill out"]
[null,null,"PHONE NUMBER","Please fill out"]
[null,"RATED PRODUCT"]
[null,null,"Producer's or importer's name or trademark","Sony France, succursale de Sony. Europe B.V."]
[null,null,"Producer or importer adress","Located at 49/51, quai de Dion Bouton, 92800 Puteaux, France "]
[null,null,"Producer's or importer's model identifier","K-43S3"]

{"sheet":"C1_RESISTANCE","index":2,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,2,26,5],[27,1,28,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[22,1,22,5],[10,2,10,5],[11,1,12,5],[20,6,21,7],[7,1,8,5],[20,1,21,5],[14,1,14,2],[17,1,17,9],[0,1,1,7],[0,8,1,11],[7,6,8,7],[9,1,9,5],[3,1,3,2],[5,1,5,9]]}
[null,{"$f":"'C1_DATA'!C1","v":"CRITERION 1: RESISTANCE TO STRESS AND/OR WEAR"},null,null,null,null,null,null,"Television"]
[]
[]
[null,{"$f":"'C1_DATA'!C2","v":"SUB-CRITERION 1.1:"},null,{"$f":"'C1_DATA'!D2","v":"RESISTANCE TO EXTERNAL STRESS"}]
[null,"PRÉCISIONS : "]
[null,"If the model has an equipment safety feature, then the point is awarded."]
[]
[null,"Resistance to external stress",null,null,null,null,"Column A"]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal"]
[null,"1.1","Presence of a switch allowing disconnection from the electricity network",null,null,null,"Presence",{"$f":"IF(G11='C1_DATA'!E6,'C1_DATA'!F6,IF(G11='C1_DATA'!E7,'C1_DATA'!F7,IF(G11='C1_DATA'!E8,'C1_DATA'!F8,0)))","v":1}]
[null,"Total sub-criterion 1.1",null,null,null,null,null,{"$f":"SUM(H11:H11)","v":1},"/ 1"]
[null,null,null,null,null,null,null,{"$f":"H12*10/1","v":10},"/ 10"]
[]
[null,{"$f":"'C1_DATA'!C9","v":"SUB-CRITERION 1.2:"},null,{"$f":"'C1_DATA'!D9","v":"WEAR RESISTANCE"}]
[]
[null,"PRÉCISIONS : "]
[null,"- Carrying out reliability tests: Factory tests carried out on a minimum number of 5 production models per chassis (equivalent model), falling within a clearly defined and documented methodology for validating the reliability of the model concerned. To award points, proof of having passed the tests is required (quality manual integrated into an ISO 9001 certification and summary of test results). These tests are complementary to the tests carried out with the aim of verifying compliance with European regulations. The tests must be carried out on the equipment as a whole, and not on part of the components.\n- Theoretical lifespan of the TV panel: Information provided by panel manufacturers (Proof = technical sheets from panel manufacturers) based on LM 80 and TM 21 standards for LED and LCD televisions and tests by panel manufacturers for OLED televisions\n- Warranty relating to TV panle marking : points are awarded if the guarantee is free of charge for the consumer, over a period of at least 4 years. Maximum points are awarded if the television has technology preventing panel marking\n- Warranty relating to defective pixels: Points are awarded if the guarantee is free of charge for the consumer and is based on the international standard ISO 9241-307."]
[]
[]
[null,"Wear resistance",null,null,null,null,{"$f":"'C1_DATA'!D11","v":"Column A"}]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal","Sub-criterion score out 10","Coefficient du sous critère"]
[null,{"$f":"'C1_DATA'!C10","v":"1.2.A"},"Carrying out reliability tests",null,null,null,"1 or 2 simple test (heat, or shock, ou humindity)",{"$f":"IF(G24='C1_DATA'!E13,'C1_DATA'!F13,IF(G24='C1_DATA'!E14,'C1_DATA'!F14,IF(G24='C1_DATA'!E15,'C1_DATA'!F15,IF(G24='C1_DATA'!E16,'C1_DATA'!F16,0))))","v":1},{"$f":"H24/4*10","v":2.5},4]
[null,{"$f":"'C1_DATA'!C17","v":"1.2.B"},{"$f":"'C1_DATA'!D17","v":"TV panel theoretical lifespan"},null,null,null,"If X  ≥ 40 000 hours",{"$f":"IF(G25='C1_DATA'!E20,'C1_DATA'!F20,IF(G25='C1_DATA'!E21,'C1_DATA'!F21,IF(G25='C1_DATA'!E22,'C1_DATA'!F22,IF(G25='C1_DATA'!E23,'C1_DATA'!F23,IF(G25='C1_DATA'!E24,'C1_DATA'!F24,IF(G25='C1_DATA'!E25,'C1_DATA'!F25,0))))))","v":4},{"$f":"H25/4*10","v":10},5]
[null,{"$f":"'C1_DATA'!C26","v":"1.2.C"},{"$f":"'C1_DATA'!D26","v":"Existence of a TV panel marking warranty and/or anti-marking software"},null,null,null,"Yes",{"$f":"IF(G26='C1_DATA'!E29,'C1_DATA'!F29,IF(G26='C1_DATA'!E30,'C1_DATA'!F30,IF(G26='C1_DATA'!E31,'C1_DATA'!F31,0)))","v":1},{"$f":"H26/1*10","v":10},0.5]
[null,{"$f":"'C1_DATA'!C32","v":"1.2.D"},{"$f":"'C1_DATA'!D32","v":"Existence of a warranty for defective pixels"},null,null,null,"Absence",{"$f":"IF(G27='C1_DATA'!E35,'C1_DATA'!F35,IF(G27='C1_DATA'!E36,'C1_DATA'!F36,IF(G27='C1_DATA'!E37,'C1_DATA'!F37,0)))","v":0},{"$f":"H27/1*10","v":0},0.5]
[null,"Total sub-criterion 1.2"]
[null,null,null,null,null,null,null,{"$f":"(I24*J24+I25*J25+I26*J26++I27*J27)/10","v":6.5},"/ 10"]
[null,null,null,{"$f":"SUM(H28)","v":0},"/",11]
[null,null,null,{"$f":"SUM(H29)","v":6.5},"/",10]

{"sheet":"C1_DATA","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,null,"CRITERION 1: RESISTANCE TO STRESS AND/OR WEAR"]
[null,null,"SUB-CRITERION 1.1:","RESISTANCE TO EXTERNAL STRESS"]
[null,null,"1.1.A","Presence of a switch"]
[null,null,null,"Column A "]
[]
[null,null,null,"Condition 1 : 0 point","Absence",0]
[null,null,null,"Condition 2 : 1 point","Presence",1]
[null,null,null,"Condition 3 : 2 points","Select a choice",0]
[null,null,"SUB-CRITERION 1.2:","WEAR RESISTANCE"]
[null,null,"1.2.A","Existence of reliability test"]
[null,null,null,"Column A"]
[]
[null,null,null,"Condition 1 : 0 point","1 or 2 simple test (heat, or shock, ou humindity)",1]
[null,null,null,"Condition 2 : 1 point","3 simple tests",2]
[null,null,null,"Condition 3 : 2 points","Accelerated ageing tests (ALT or HALT type) - in accordance with standard IEC 62506:2013",4]
[null,null,null,"Condition 4 : 3 points","Select a choice",0]
[null,null,"1.2.B","TV panel theoretical lifespan"]
[null,null,null,"Column A"]
[]
[null,null,null,"Condition 1 : 0 point","If X < 10 000 hours",0]
[null,null,null,"Condition 2 : 1 point","If X ≤ 10 000 hours < 20 000 hours",1]
[null,null,null,"Condition 3 : 2 points","If X ≤ 20 000 hours < 30 000 hours ",2]
[null,null,null,"Condition 4 : 3 points","If X ≤ 30 000 hours < 40 000 hours",3]
[null,null,null,"Condition 5 : 4 points","If X  ≥ 40 000 hours",4]
[null,null,null,"Condition 6 : 5 points","Select a choice",0]
[null,null,"1.2.C","Existence of a TV panel marking warranty and/or anti-marking software"]
[null,null,null,"Column A "]
[]
[null,null,null,"Condition 1 : 0 point","No",0]
[null,null,null,"Condition 2 : 1 point","Yes",1]
[null,null,null,"Condition 5 : 4 points","Select a choice",0]
[null,null,"1.2.D","Existence of a warranty for defective pixels"]
[null,null,null,"Column A"]
[]
[null,null,null,"Condition 1 : 0 point","Absence",0]
[null,null,null,"Condition 2 : 1 point","Existence",1]
[null,null,null,"Condition 3 : 2 points","Select a choice",0]

{"sheet":"C2_MAINTENANCE_SERVICING","index":4,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,10,31,10],[30,11,31,11],[30,12,31,12],[31,2,31,5],[32,2,32,5],[33,1,34,5],[25,8,26,9],[27,1,27,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[25,1,26,5],[25,6,26,7],[10,2,10,5],[11,2,11,5],[14,1,15,5],[21,1,22,7],[12,2,12,5],[13,2,13,5],[9,1,9,5],[0,1,1,7],[0,8,1,11],[3,1,4,7],[7,1,8,5],[7,6,8,7]]}
[null,{"$f":"'C2_DATA'!C1","v":"CRITERION 2 : MAINTENANCE (INCLUDING SOFTWARE) & SERVICING"},null,null,null,null,null,null,"Television"]
[]
[]
[null,{"$f":"'C2_DATA'!C2","v":"SUB-CRITERION 2.1 : MAINTENANCE (INCLUDING SOFTWARE)"}]
[]
[]
[]
[null,"Maintenance",null,null,null,null,{"$f":"'C2_DATA'!D4","v":"Column A"}]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal","Note du sous-critère sur 10","Coefficient du sous critère"]
[null,{"$f":"'C2_DATA'!C3","v":"2.1.A"},{"$f":"'C2_DATA'!D3","v":"Accessibility usage meter"},null,null,null,"Visible or easily accessible: The consumer learns the value displayed by the usage meter by performing three operations or less",{"$f":"IF(G11='C2_DATA'!E6,'C2_DATA'!F6,IF(G11='C2_DATA'!E7,'C2_DATA'!F7,IF(G11='C2_DATA'!E8,'C2_DATA'!F8,IF(G11='C2_DATA'!E9,'C2_DATA'!F9,0))))","v":2},{"$f":"H11/2*10","v":10},3]
[null,{"$f":"'C2_DATA'!C18","v":"2.1.D"},{"$f":"'C2_DATA'!D18","v":"Firmware reset"},null,null,null,"Operating system reset and firmware reset",{"$f":"IF(G12='C2_DATA'!E21,'C2_DATA'!F21,IF(G12='C2_DATA'!E22,'C2_DATA'!F22,IF(G12='C2_DATA'!E25,'C2_DATA'!F25,IF(G12='C2_DATA'!E23,'C2_DATA'!F23,IF(G12='C2_DATA'!E24,'C2_DATA'!F24,0)))))","v":2},{"$f":"H12/2*10","v":10},3]
[null,{"$f":"'C2_DATA'!C31","v":"2.1.C"},{"$f":"'C2_DATA'!D31","v":"Commitment on the duration of the supply of compliance software updates \n(including bug fixes and security updates)"},null,null,null,"If X >12 years",{"$f":"IF(G13='C2_DATA'!E34,'C2_DATA'!F34,IF(G13='C2_DATA'!E35,'C2_DATA'!F35,IF(G13='C2_DATA'!E36,'C2_DATA'!F36,IF(G13='C2_DATA'!E37,'C2_DATA'!F37,IF(G13='C2_DATA'!E38,'C2_DATA'!F38,0)))))","v":12},{"$f":"H13/12*10","v":10},2]
[null,{"$f":"'C2_DATA'!C42","v":"2.1.B"},{"$f":"'C2_DATA'!D42","v":"Commitment on the duration of firmware availability to the consumer"},null,null,null,"If X >12 years",{"$f":"IF(G14='C2_DATA'!E34,'C2_DATA'!F34,IF(G14='C2_DATA'!E35,'C2_DATA'!F35,IF(G14='C2_DATA'!E36,'C2_DATA'!F36,IF(G14='C2_DATA'!E37,'C2_DATA'!F37,IF(G14='C2_DATA'!E38,'C2_DATA'!F38,0)))))","v":12},{"$f":"H14/12*10","v":10},2]
[null,"Total sub-criterion 2.1"]
[null,null,null,null,null,null,null,{"$f":"+SUMPRODUCT(I11:I14,J11:J14)/10","v":10},"/ 10"]
[null,null,null,{"$f":"SUM(H15)","v":0},"/",28]
[null,null,null,{"$f":"SUM(H16)","v":10},"/",10]
[]
[]
[]
[null,{"$f":"'C2_DATA'!C53","v":"SUB-CRITERION 2.2: SERVICING"}]
[]
[]
[]
[null,"Servicing",null,null,null,null,"Column A\nInformation made available directly on the equipment",null,"Column B\nQuality of the model-specific information made available by the manufacturer on a mobile application or on the manufacturer's website, with an indication of the frequency."]
[]
[null,"List of maintenance procedures",null,null,null,null,"Availability","Subtotal","Availability","Subtotal"]
[null,"2.2.A","Choose a good location for the television, in a clean place, away from sources of heat (sun, radiators, fireplaces), plants (pollen, dust, water) and the ground (risk of knocks, dust). \n(sun, radiators, fireplace), plants (pollen, dust, water) and the ground (risk of knocks, dust)",null,null,null,null,null,"Written information + diagram or tutorial video content",{"$f":"IF(I29='C2_DATA'!$E$76,'C2_DATA'!$F$76,IF(I29='C2_DATA'!$E$77,'C2_DATA'!$F$77,IF(I29='C2_DATA'!$E$78,'C2_DATA'!$F$78,IF(I29='C2_DATA'!$E$79,'C2_DATA'!$F$79,IF(I29='C2_DATA'!$E$80,'C2_DATA'!$F$80,IF(I29='C2_DATA'!$E$81,'C2_DATA'!$F$81,IF(I29='C2_DATA'!$E$82,'C2_DATA'!$F$82,IF(I29='C2_DATA'!$E$83,'C2_DATA'!$F$83,0))))))))","v":2}]
[null,"2.2.B","Do not place cloth, paper or other materials over the openings on the top, sides or bottom of the appliance. ",null,null,null,"Information displayed directly on the device via a display in the equipment parameters",{"$f":"IF(G30='C2_DATA'!$E$65,'C2_DATA'!$F$65,IF(G30='C2_DATA'!$E$66,'C2_DATA'!$F$66,IF(G30='C2_DATA'!$E$67,'C2_DATA'!$F$67,IF(G30='C2_DATA'!$E$68,'C2_DATA'!$F$68,IF(G30='C2_DATA'!$E$69,'C2_DATA'!$F$69,0)))))","v":1},"Written information + diagram or tutorial video content",{"$f":"IF(I30='C2_DATA'!$E$76,'C2_DATA'!$F$76,IF(I30='C2_DATA'!$E$77,'C2_DATA'!$F$77,IF(I30='C2_DATA'!$E$78,'C2_DATA'!$F$78,IF(I30='C2_DATA'!$E$79,'C2_DATA'!$F$79,IF(I30='C2_DATA'!$E$80,'C2_DATA'!$F$80,IF(I30='C2_DATA'!$E$81,'C2_DATA'!$F$81,IF(I30='C2_DATA'!$E$82,'C2_DATA'!$F$82,IF(I30='C2_DATA'!$E$83,'C2_DATA'!$F$83,0))))))))","v":2}]
[null,"2.2.C","Switch off the television after use (unless the manufacturer's operating instructions advise against it, \nas is usually the case for OLED televisions) and unplug it if it is not going to be used for \n(if it is an OLED television, leave it on standby before unplugging it)",null,null,null,"Information displayed directly on the device via a display in the equipment parameters",{"$f":"IF(G31='C2_DATA'!$E$65,'C2_DATA'!$F$65,IF(G31='C2_DATA'!$E$66,'C2_DATA'!$F$66,IF(G31='C2_DATA'!$E$67,'C2_DATA'!$F$67,IF(G31='C2_DATA'!$E$68,'C2_DATA'!$F$68,IF(G31='C2_DATA'!$E$69,'C2_DATA'!$F$69,0)))))","v":1},"Written information + diagram or tutorial video content",{"$f":"IF(I31='C2_DATA'!$E$76,'C2_DATA'!$F$76,IF(I31='C2_DATA'!$E$77,'C2_DATA'!$F$77,IF(I31='C2_DATA'!$E$78,'C2_DATA'!$F$78,IF(I31='C2_DATA'!$E$79,'C2_DATA'!$F$79,IF(I31='C2_DATA'!$E$80,'C2_DATA'!$F$80,IF(I31='C2_DATA'!$E$81,'C2_DATA'!$F$81,IF(I31='C2_DATA'!$E$82,'C2_DATA'!$F$82,IF(I31='C2_DATA'!$E$83,'C2_DATA'!$F$83,0))))))))","v":2},"Column","Sub-criterion score out of 10","Sub-criterion coefficient"]
[null,"2.2.D","Store the remote control carefully, do not expose it to liquids and check the condition of the remote control\nbatteries regularly to prevent corrosion of the contacts.",null,null,null,"Information displayed directly on the device via a display in the equipment parameters",{"$f":"IF(G32='C2_DATA'!$E$65,'C2_DATA'!$F$65,IF(G32='C2_DATA'!$E$66,'C2_DATA'!$F$66,IF(G32='C2_DATA'!$E$67,'C2_DATA'!$F$67,IF(G32='C2_DATA'!$E$68,'C2_DATA'!$F$68,IF(G32='C2_DATA'!$E$69,'C2_DATA'!$F$69,0)))))","v":1},"Written information + diagram or tutorial video content",{"$f":"IF(I32='C2_DATA'!$E$76,'C2_DATA'!$F$76,IF(I32='C2_DATA'!$E$77,'C2_DATA'!$F$77,IF(I32='C2_DATA'!$E$78,'C2_DATA'!$F$78,IF(I32='C2_DATA'!$E$79,'C2_DATA'!$F$79,IF(I32='C2_DATA'!$E$80,'C2_DATA'!$F$80,IF(I32='C2_DATA'!$E$81,'C2_DATA'!$F$81,IF(I32='C2_DATA'!$E$82,'C2_DATA'!$F$82,IF(I32='C2_DATA'!$E$83,'C2_DATA'!$F$83,0))))))))","v":2}]
[null,"2.2.E","Clean the screen with a soft, dry cloth after switching off and unplugging the television. \nand avoid glass sprays and other household cleaning agents.",null,null,null,"Information displayed directly on the device via a display in the equipment parameters",{"$f":"IF(G33='C2_DATA'!$E$65,'C2_DATA'!$F$65,IF(G33='C2_DATA'!$E$66,'C2_DATA'!$F$66,IF(G33='C2_DATA'!$E$67,'C2_DATA'!$F$67,IF(G33='C2_DATA'!$E$68,'C2_DATA'!$F$68,IF(G33='C2_DATA'!$E$69,'C2_DATA'!$F$69,0)))))","v":1},"Written information + diagram or tutorial video content",{"$f":"IF(I33='C2_DATA'!$E$76,'C2_DATA'!$F$76,IF(I33='C2_DATA'!$E$77,'C2_DATA'!$F$77,IF(I33='C2_DATA'!$E$78,'C2_DATA'!$F$78,IF(I33='C2_DATA'!$E$79,'C2_DATA'!$F$79,IF(I33='C2_DATA'!$E$80,'C2_DATA'!$F$80,IF(I33='C2_DATA'!$E$81,'C2_DATA'!$F$81,IF(I33='C2_DATA'!$E$82,'C2_DATA'!$F$82,IF(I33='C2_DATA'!$E$83,'C2_DATA'!$F$83,0))))))))","v":2},"A",{"$f":"H34*10/12","v":3.3333333333333335},3]
[null,null,null,null,null,null,null,{"$f":"SUM(H29:H33)","v":4},null,{"$f":"SUM(J29:J33)","v":10},"B",{"$f":"J34","v":10},1]
[null,null,null,null,null,null,null,null,null,null,"Overall score",{"$f":"(L33*M33+L34*M34)/4","v":5},"/ 10"]

{"sheet":"C2_DATA","index":5,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"CRITERION 2 : MAINTENANCE (INCLUDING SOFTWARE) & SERVICING"]
[null,null,"SUB-CRITERION 2.1 : MAINTENANCE (INCLUDING SOFTWARE)","Maintenance (including software)"]
[null,null,"2.1.A","Accessibility usage meter"]
[null,null,null,"Column A"]
[]
[null,null,null,"A : Absence : Absence de compteur ou compteur d'usage inaccessible pour le consommateur = 0 point.","Absence: No meter or meter inaccessible to the consumer",0]
[null,null,null,"- B : Difficilement accessible : Le consommateur prend connaissance de la valeur affichée par le compteur d'usage en effectuant strictement plus de trois manipulations = 1 point.","Difficult to access: The consumer only learns the value displayed by the usage meter by carrying out more than three operations",1]
[null,null,null,"- C : Visible ou facilement accessible : Le consommateur prend connaissance de la valeur affichée par le compteur d'usage en effectuant trois manipulations ou moins = 2 points.","Visible or easily accessible: The consumer learns the value displayed by the usage meter by performing three operations or less",2]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2.1.D","Firmware reset"]
[null,null,null,"Column A"]
[]
[null,null,null,"Impossible 0 point","Impossible",0]
[null,null,null,"Possible 1 point","Firmware reset",1]
[null,null,null,null,"Operating system reset",1]
[null,null,null,null,"Operating system reset and firmware reset",2]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[]
[]
[null,null,"2.1.C","Commitment on the duration of the supply of compliance software updates \n(including bug fixes and security updates)"]
[null,null,null,"Column A"]
[]
[null,null,null,null,"If X ≤ 8 years",0]
[null,null,null,null,"If 8 years < X ≤ 10 years",8]
[null,null,null,null,"If 10 years < X ≤ 12 years",10]
[null,null,null,null,"If X >12 years",12]
[null,null,null,null,"Select a choice",0]
[]
[null,null,"B"]
[]
[null,null,"2.1.B","Commitment on the duration of firmware availability to the consumer"]
[null,null,null,"Column A"]
[]
[null,null,null,null,"If X ≤ 8 years",0]
[null,null,null,null,"If 8 years < X ≤ 10 years",8]
[null,null,null,null,"If 10 years < X ≤ 12 years",10]
[null,null,null,null,"If X >12 years",12]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[null,null,"SUB-CRITERION 2.2: SERVICING","SERVICING"]
[null,null,null,"Quality of the model-specific information made available by the manufacturer on a mobile application or on the manufacturer's website, with an indication of the frequency."]
[]
[null,null,null,"Aucune information : 0 point","Absence of information",0]
[null,null,null,"Information à l'écrit : 1 point","Written information",1]
[null,null,null,"Information écrit + schéma ou du contenu vidéo tuto : 2 points","Written information + diagram or tutorial video content",2]
[null,null,null,null,"Select a choice",0]
[]
[]
[null,null,"2.2.B"]
[null,null,null,"Information provided directly on the equipment (usage meter, indicator light, electronic display)"]
[]
[null,null,null,"Aucun : 0 point","None",0]
[null,null,null,null,"Information displayed directly on the device via a display in the equipment parameters",1]
[null,null,null,null,"Information displayed directly on the device via a regular display determined by the manufacturer",2]
[null,null,null,null,"Information displayed in the parameters and via a regular display determined by the manufacturer",3]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[null,null,null,"Quality of the model-specific information made available by the manufacturer on a mobile application or on the manufacturer's website, with an indication of the frequency."]
[]
[null,null,null,"Aucune information : 0 point","No information",0]
[null,null,null,"Information à l'écrit : 1 point","Written information",1]
[null,null,null,"Information écrit + schéma ou du contenu vidéo tuto : 2 points","Written information + diagram or tutorial video content",2]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[]
[null,null,"2.2.C"]
[null,null,null,"Information provided directly on the equipment (usage meter, indicator light, electronic display)"]
[]
[null,null,null,"Aucun : 0 point","None",0]
[null,null,null,"Signal quelconque directement sur l'appareil : 1 point","Any signal directly on the device",1]
[null,null,null,"Indication à l'utilisateur qu'une phase de maintenance est nécessaire directement accéssible sur l'appareil avec des informations claires sur les manipulations à effectuer : 2 points","Indication to the user that a maintenance phase is required, directly accessible on the device with clear information on the operations to be carried out",2]
[null,null,null,null,"Select a choice"]
[]
[]
[]
[]
[null,null,null,"Quality of the model-specific information made available by the manufacturer on a mobile application or on the manufacturer's website, with an indication of the frequency."]
[]
[null,null,null,"Aucune information : 0 point","No information",0]
[null,null,null,"Information à l'écrit : 1 point","Written information",1]
[null,null,null,"Information écrit + schéma ou du contenu vidéo tuto : 2 points","Written information + diagram or tutorial video content",2]
[null,null,null,null,"Select a choice"]

{"sheet":"C3_GUARANTEE","index":6,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,2,25,5],[26,1,27,5],[10,2,10,5],[11,1,12,5],[16,1,17,7],[22,1,23,5],[22,6,23,7],[24,1,24,5],[19,1,19,9],[9,1,9,5],[0,1,1,7],[0,8,1,11],[7,1,8,5],[7,6,8,7],[3,1,3,5],[5,1,5,9]]}
[null,{"$f":"'C3_DATA'!C1","v":"CRITERION 3 : GUARANTEE AND QUALITY PROCESS"},null,null,null,null,null,null,"Television"]
[]
[]
[null,{"$f":"'C3_DATA'!C2","v":"SUB-CRITERION 3.1 : COMMERCIAL GUARANTEE OF DURABIITY"}]
[null,"PRÉCISIONS : "]
[null,"Determined by the consent of the producer, or marketer, to the consumer of a commercial guarantee of durability defined in article L217-23 of the Consumer Code, for a given period. \nFor the purposes of awarding points, the commercial guarantee of durability is free of charge and must favour the repair of goods over the replacement as new of the products concerned. In addition, any lack of conformity that appears during the period of the commercial guarantee of durability, including for goods containing digital elements, is, in the absence of proof to the contrary, presumed to have existed at the time of delivery, unless this presumption is incompatible with the nature of the goods or the defect claimed."]
[]
[null,"SUB-CRITERION 3.1 : COMMERCIAL GUARANTEE OF DURABIITY",null,null,null,null,{"$f":"'C3_DATA'!D4","v":"Column A"}]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal"]
[null,{"$f":"'C3_DATA'!C3","v":"3.1.A"},{"$f":"'C3_DATA'!D3","v":"Duration of the commercial guarantee of durability"},null,null,null,"No guarantee",{"$f":"IF(G11='C3_DATA'!E6,'C3_DATA'!F6,IF(G11='C3_DATA'!E7,'C3_DATA'!F7,IF(G11='C3_DATA'!E8,'C3_DATA'!F8,IF(G11='C3_DATA'!E10,'C3_DATA'!F10,0))))","v":0}]
[null,"Total sub-criterion 3.1",null,null,null,null,null,{"$f":"SUM(H11:H11)","v":0},"/ 3"]
[null,null,null,null,null,null,null,{"$f":"H12*F15/F14","v":0},"/ 10"]
[null,null,null,{"$f":"SUM(H12)","v":0},"/",3]
[null,null,null,{"$f":"SUM(H13)","v":0},"/",10]
[]
[null,{"$f":"'C3_DATA'!C15","v":"SUB-CRITERION 3.2 : IMPLEMENTATION OF AN UPGRADING PROCESS"}]
[]
[null,"PRÉCISIONS : "]
[null,"Establishment within the company of a documented and demonstrable continuous improvement process to increase the sustainability of each product model put on the market, through product monitoring and improvement:\nTo obtain the points, the manufacturer must be able to show : \n- That failures are identified and monitored by the technical departments of the manufacturer or its subsidiaries - Supporting statistics\n- That these failures are the subject of documented reports according to structured and systematic processes sent up to the central departments (Technical / Quality / R&D)\n- That these reports are taken on board and processed by the R&D departments, with specific modifications being made to the products in order to constantly improve their reliability and durability.\n- That the modifications made are then traced and their impact measured statistically to attest to the effectiveness of the improvements made."]
[]
[]
[null,{"$f":"'C3_DATA'!C15","v":"SUB-CRITERION 3.2 : IMPLEMENTATION OF AN UPGRADING PROCESS"},null,null,null,null,{"$f":"'C3_DATA'!D17","v":"Column A"}]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal"]
[null,{"$f":"'C3_DATA'!C16","v":"3.2.A"},{"$f":"'C3_DATA'!D16","v":"Implementation of a continuous upgrading process\n"},null,null,null,"Yes",{"$f":"IF(G26='C3_DATA'!E19,'C3_DATA'!F19,IF(G26='C3_DATA'!E20,'C3_DATA'!F20,IF(G26='C3_DATA'!E21,'C3_DATA'!F21,0)))","v":1}]
[null,"Total sub-criterion 3.2",null,null,null,null,null,{"$f":"SUM(H26:H26)","v":1},"/ 1"]
[null,null,null,null,null,null,null,{"$f":"H27*F30/F29","v":10},"/ 10"]
[null,null,null,{"$f":"SUM(H27)","v":1},"/",1]
[null,null,null,{"$f":"SUM(H28)","v":10},"/",10]

{"sheet":"C3_DATA","index":7,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"CRITERION 3 : GUARANTEE AND QUALITY PROCESS"]
[null,null,"SUB-CRITERION 3.1 : COMMERCIAL GUARANTEE OF DURABIITY","Commercial guarantee of durability"]
[null,null,"3.1.A","Duration of the commercial guarantee of durability","Determined by the consent of the producer, or marketer, to the consumer of a commercial guarantee of durability defined in article L217-23 of the Consumer Code, for a given period. \nFor the purposes of awarding points, the commercial guarantee of durability is free of charge and must favour the repair of goods over the replacement as new of the products concerned. In addition, any lack of conformity that appears during the period of the commercial guarantee of durability, including for goods containing digital elements, is, in the absence of proof to the contrary, presumed to have existed at the time of delivery, unless this presumption is incompatible with the nature of the goods or the defect claimed."]
[null,null,null,"Column A"]
[]
[null,null,null,"Garantie sans frais de 1 an à compter de la fin de la garantie légale de conformité : 1 point","Free 1-year guarantee from the end of the legal guarantee of conformity",1]
[null,null,null,"Garantie sans frais de 3 years  à compter de la fin de la garantie légale de conformité : 2 points","Free 3-year guarantee from the end of the legal guarantee of conformity",2]
[null,null,null,"Garantie sans frais > 3 years  à compter de la fin de la garantie légale de conformité : 3 points","Free guarantee > 3 years from the end of the legal guarantee of conformity",3]
[null,null,null,null,"No guarantee",0]
[null,null,null,null,"Select a choice",0]
[]
[]
[]
[]
[null,null,"SUB-CRITERION 3.2 : IMPLEMENTATION OF AN UPGRADING PROCESS","Implementation of an upgrading process"]
[null,null,"3.2.A","Implementation of a continuous upgrading process\n","Establishment within the company of a documented and demonstrable continuous improvement process to increase the sustainability of each product model put on the market, through product monitoring and improvement:\nTo obtain the points, the manufacturer must be able to show : \n- That failures are identified and monitored by the technical departments of the manufacturer or its subsidiaries - Supporting statistics\n- That these failures are the subject of documented reports according to structured and systematic processes sent up to the central departments (Technical / Quality / R&D)\n- That these reports are taken on board and processed by the R&D departments, with specific modifications being made to the products in order to constantly improve their reliability and durability.\n- That the modifications made are then traced and their impact measured statistically to attest to the effectiveness of the improvements made."]
[null,null,null,"Column A"]
[]
[null,null,null,"Oui : 1 point","Yes",1]
[null,null,null,"Non : 0 point","No",0]
[null,null,null,null,"Select a choice",0]

{"sheet":"C4_DOCUMENTATION","index":8,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[63,1,64,5],[58,1,59,5],[58,6,59,7],[60,1,60,5],[61,2,61,5],[62,2,62,5],[12,1,12,7],[13,1,13,7],[17,1,17,7],[46,1,47,7],[49,1,49,9],[27,1,27,3],[35,2,35,3],[36,2,36,3],[25,4,26,5],[25,6,26,7],[0,8,1,11],[0,1,1,7],[25,1,26,3],[3,1,4,7],[20,1,20,7],[19,1,19,7],[6,1,6,7],[14,1,14,7],[15,1,15,7],[16,1,16,7],[18,1,18,7],[7,1,7,7],[8,1,8,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[68,5,68,8],[70,5,70,8],[31,2,31,3],[29,2,29,3],[28,2,28,3],[30,2,30,3],[34,2,34,3],[33,2,33,3],[32,2,32,3],[41,1,43,7],[37,2,37,3],[39,1,40,3],[38,2,38,3],[50,1,51,9],[52,1,54,9],[55,1,55,9]]}
[null,"CRITERION 4 : DOCUMENTATION",null,null,null,null,null,null,"Television"]
[]
[]
[null,"SUB-CRITERION 4.1 : COMMITMENT ON THE AVAILABILITY OVER TIME (WITHOUT CHARGE) OF THE TECHNICAL DOCUMENTATION AND THE OTHER DOCUMENTATION RELATED TO USER AND MAINTENANCE INSTRUCTIONS"]
[]
[]
[null,"ADDITIONAL INFORMATIONS: "]
[null,"Documents/informations: The information can be freely distributed at the initiative of the producer in various physical or dematerialized "]
[null,"documents. Scoring points are awarded if the information referred to is available in any document. "]
[null,"Language of documents: In accordance with the law of August 4, 1994 on the use of the French language, information intended for "]
[null,"consumers must be drawn up in French ; English is tolerated for very technical aspects intended for professional repairers (example:"]
[null,"technical bulletins)."]
[null,"Technical bulletins: This wording covers announcements made by the producer to professional repairers, informing them, for example, of "]
[null,"recently discovered bugs, of the corrections to be made, of the supply disruption of parts which have been replaced by others. Points are "]
[null,"awarded if the edition of a technical bulletin is planned on an ongoing basis (when necessary). "]
[null,"Information on access to professional repairers: The producer or importer is free to indicate to consumers the professional repairers of his "]
[null,"choice, but it is advisable to mention at least the repairer directories listed by Ademe : www.annuaire-reparation.fr"]
[null,"Instructions for self-repair: Points corresponding to years of availability are only granted if one or more operations are specified to "]
[null,"consumers for self-repair, with adequate safety instructions, in a specific section under the title “self-repair”, for example in the technical "]
[null,"manual or of the instructions for use and maintenance. Article L 441-5 of the Consumer Code specifies the responsibility of the producer "]
[null,"regarding self-repair."]
[]
[]
[]
[]
[null,"Commitment on the availability over time of the documentation        \n(in years)",null,null,"Repairers",null,"Consumers"]
[]
[null,"Type of documentation",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal"]
[null,"4.1.A","The unequivocal identification of the product (type of product, trademark, trade name, model, and possibly, serial number)",null,"If X ≥ 11 years",{"$f":"IF(E29='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E29='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E29='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E29='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E29='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G29='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G29='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G29='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G29='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G29='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.B ","A dissasembly map or exploded view",null,"If X ≥ 11 years",{"$f":"IF(E30='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E30='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E30='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E30='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E30='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G30='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G30='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G30='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G30='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G30='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.C","Wiring and connection diagrams",null,"If X ≥ 11 years",{"$f":"IF(E31='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E31='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E31='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E31='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E31='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G31='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G31='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G31='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G31='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G31='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.D","Electronic boards diagrams",null,"If X ≥ 11 years",{"$f":"IF(E32='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E32='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E32='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E32='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E32='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G32='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G32='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G32='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G32='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G32='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.E","List of necessary repair and test equipment",null,"If X ≥ 11 years",{"$f":"IF(E33='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E33='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E33='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E33='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E33='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G33='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G33='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G33='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G33='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G33='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.F","Technical manual of instructions for repair",null,"If X ≥ 11 years",{"$f":"IF(E34='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E34='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E34='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E34='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E34='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G34='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G34='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G34='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G34='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G34='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.G","diagnosis fault and error codes",null,"If X ≥ 11 years",{"$f":"IF(E35='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E35='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E35='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E35='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E35='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G35='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G35='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G35='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G35='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G35='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.H","Component and diagnosis information",null,"If X ≥ 11 years",{"$f":"IF(E36='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E36='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E36='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E36='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E36='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G36='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G36='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G36='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G36='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G36='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.I","Instructions for software and firmware (including reset software)",null,"If X ≥ 11 years",{"$f":"IF(E37='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E37='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E37='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E37='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E37='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G37='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G37='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G37='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G37='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G37='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.J","Information on how to access data records of reported failure incidents stored on the product",null,"If X ≥ 11 years",{"$f":"IF(E38='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E38='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E38='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E38='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E38='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G38='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G38='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G38='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G38='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G38='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"4.1.K","Technical bulletins",null,"If X ≥ 11 years",{"$f":"IF(E39='C4_Data'!$E$7,'C4_Data'!$F$7,IF(E39='C4_Data'!$E$8,'C4_Data'!$F$8,IF(E39='C4_Data'!$E$9,'C4_Data'!$F$9,IF(E39='C4_Data'!$E$10,'C4_Data'!$F$10,IF(E39='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11},"If X ≥ 11 years",{"$f":"IF(G39='C4_Data'!$E$7,'C4_Data'!$F$7,IF(G39='C4_Data'!$E$8,'C4_Data'!$F$8,IF(G39='C4_Data'!$E$9,'C4_Data'!$F$9,IF(G39='C4_Data'!$E$10,'C4_Data'!$F$10,IF(G39='C4_Data'!$E$11,'C4_Data'!$F$11,0)))))","v":11}]
[null,"Total sub-criterion 4.1",null,null,null,{"$f":"SUM(F29:F39)","v":121},null,{"$f":"SUM(H29:H39)","v":121},{"$f":"F40+H40","v":242},"/ 242"]
[null,null,null,null,null,null,null,null,{"$f":"I40*10/242","v":10},"/ 10"]
[null,"*Points corresponding to years of availability are only awarded if one or more operations are specified to consumers for self-repair, with adequate safety instructions, in a specific section entitled “self-repair”, for example into a technical manual or user and maintenance instructions. \nSee article L. 441-5 of the French Consumer Code wich specifies the responsibility of the producer for self-repair."]
[]
[]
[]
[]
[null,"SUB-CRITERION 4.2: CONSUMER SUPPORT FOR DIAGNOSIS AND REPAIR"]
[]
[null,"PRECISIONS : "]
[null,"Remote information should concern :\n         - repair assistance for consumers (website, FAQ, etc.), \n         - information on access to professional repairers, with the manufacturer or marketer indicating the professional repairers of their choice or mentioning a directory of repairers listed by ADEME: www.annuaire-reparation.fr) \n         - instructions for self-repair by proposing operations to consumers for self-repair, with the appropriate safety instructions, in a specific section under the heading \"self-repair\", for example in the technical manual. Article L441-5 of the French Consumer Code specifies the producer's responsibility for self-repair. \n"]
[null,"- Remote assistance includes any system whose purpose is to facilitate the search for information in the event of a breakdown, information to identify the origin of a breakdown or remote assistance to carry out repairs. In the case of remote repair assistance, the device must be capable of providing precise technical support to the user."]
[]
[null,"- Remote assistance systems include: remote information (website, FAQ, etc.), remote diagnosis assistance (telephone hotline, chat, application included with the equipment, interactive decision tree, etc.) and remote repair assistance (telephone hotline, video call, remote control of the equipment, etc.)."]
[]
[]
[null,"- Remote assistance systems must be completely free of charge (including telephone calls in the case of a hotline).\n\n- To be awarded points for remote assistance, it must at least concern diagnosis. "]
[]
[]
[null,"CONSUMER SUPPORT FOR DIAGNOSIS AND REPAIR",null,null,null,null,"Consumers"]
[]
[null,"Type of documentation",null,null,null,null,"Select a choice","Subtotal"]
[null,"4.2.A","Consumer information",null,null,null,"Yes",{"$f":"IF(G62='C4_Data'!E27,'C4_Data'!F27,0)","v":1}]
[null,"4.2.B","Remote assistance",null,null,null,"Remote repair assistance",{"$f":"IF(G63='C4_Data'!E33,'C4_Data'!F33,IF(G63='C4_Data'!E34,'C4_Data'!F34,0))","v":4}]
[null,"Total sub-criterion 5.2",null,null,null,null,null,{"$f":"SUM(H62:H63)","v":5},"/ 5"]
[null,null,null,null,null,null,null,{"$f":"H64*10/5","v":10},"/ 10"]
[null,null,null,{"$f":"H64","v":5},"/",5]
[null,null,null,{"$f":"H65","v":10},"/",10]
[]
[null,null,null,"Link to documentation for repairers",null,"Please fill out",null,null,null,null,"(link format : https://)"]
[]
[null,null,null,"Link to documentation for consumeurs",null,"Please fill out",null,null,null,null,"(link format : https://)"]

{"sheet":"C4_Data","index":9,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"CRITERION 5 : DOCUMENTATION"]
[null,null,"SUB-CRITERION 4.1 : COMMITMENT ON THE AVAILABILITY OVER TIME (WITHOUT CHARGE) OF THE TECHNICAL DOCUMENTATION AND THE OTHER DOCUMENTATION RELATED TO USER AND MAINTENANCE INSTRUCTIONS"]
[null,null,"4.1"]
[null,null,null,"Column A : Repairers"]
[]
[null,null,null,"Non disponible  : 0 point","Not available",0]
[null,null,null,"si X < 6 ans : 0 point","If X < 6 years",0]
[null,null,null,"si 7 <= X < 9 ans : 7 points","If 7 ≤ X < 9 years",7]
[null,null,null,"si 9 <= X < 11 ans : 9 points","If 9 ≤ X < 11 years",9]
[null,null,null,"si X ≥ 11 ans : 11 points","If X ≥ 11 years",11]
[null,null,null,"Non applicable : 0 point","Not applicable",11]
[null,null,null,"Choix à sélectionner","Select a choice",0]
[null,null,null,"Consommateurs"]
[]
[null,null,null,"Non disponible  : 0 point","Not available",0]
[null,null,null,"si X < 6 ans : 0 point","If X < 6 years",0]
[null,null,null,"si 7 <= X < 9 ans : 7 points","If 7 ≤ X < 9 years",7]
[null,null,null,"si 9 <= X < 11 ans : 9 points","If 9 ≤ X < 11 years",9]
[null,null,null,"si X ≥ 11 ans : 11 points","If X ≥ 11 years",11]
[null,null,null,"Non applicable : 0 point","Not applicable",11]
[null,null,null,"Choix à sélectionner","Select a choice",0]
[null,null,"SUB-CRITERION 4.2: CONSUMER SUPPORT FOR DIAGNOSIS AND REPAIR"]
[null,null,"4.2.A","Consumer information"]
[null,null,null,"Column A"]
[]
[null,null,null,"No : 0 point","No",0]
[null,null,null,"Yes : 1 point","Yes",1]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,"4.2.B","Remote assistance"]
[null,null,null,"Column A : A remplir"]
[]
[null,null,null,"None : 0 point","None",0]
[null,null,null,"Remote diagnosis assistance : 2 points","Remote diagnosis assistance",2]
[null,null,null,"Remote repair assistance : 4 points","Remote repair assistance",4]
[null,null,null,"Select a choice","Select a choice",0]

{"sheet":"C5_DISASSEMBLY","index":10,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[77,1,78,3],[16,4,17,5],[43,2,43,3],[39,1,39,3],[76,2,76,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[45,1,46,3],[45,4,46,4],[24,1,25,3],[63,4,64,4],[71,2,71,3],[75,2,75,3],[0,10,1,13],[0,1,1,9],[16,1,17,3],[37,1,38,3],[18,1,18,3],[10,1,10,7],[27,1,27,8],[37,4,38,5],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[13,1,13,9],[13,10,13,13],[5,5,5,7],[72,2,72,3],[73,2,73,3],[74,2,74,3],[61,1,62,3],[63,1,64,3],[70,2,70,3],[63,5,64,5],[48,1,48,7],[44,2,44,3],[40,2,40,3],[59,1,59,5],[61,4,62,5],[41,2,41,3],[42,2,42,3],[51,1,51,9],[52,1,52,9],[53,1,53,9],[54,1,54,9],[55,1,55,9],[56,1,56,9],[24,4,25,4],[34,1,34,4],[35,1,35,4],[30,1,30,9],[31,1,31,9],[32,1,32,9],[33,1,33,9],[3,1,3,4],[6,5,6,7],[7,5,7,7],[8,5,8,7],[12,10,12,13]]}
[null,"CRITERION 5 : DISASSEMBLY, ACCESSIBILITY, TOOLS, FASTENERS",null,null,null,null,null,null,null,null,"Television"]
[]
[]
[null,{"$f":"IF(OR(F7=\"Select a choice\",F8=\"Select a choice\",F9=\"Select a choice\"),\"Please answer this 3 questions\",\"\")","v":""}]
[]
[null,"PLEASE yearsWER THE FOLLOWING QUESTIONS :",null,null,null,"ANSWERS"]
[null,"1)","Does the product have any internal power supply ?",null,null,"Yes"]
[null,"2)","Does the porduct have any WiFi module ?",null,null,"Yes"]
[null,"3)","Does the product have any Bluetooth module ?",null,null,"Yes"]
[]
[null,"SUB-CRITERION 5.1 : EASE OF DISASSEMBLY OF SPARE PARTS - BROKEN / MALFUNCTIONING PARTS (LIST 2)"]
[]
[null,"PRECISION : ",null,null,null,null,null,null,null,null,"PARTICULAR CASE OF TELEVISION"]
[null,"Details of the dismantling steps can be found on the right side of this sheet and in Annex 3 grid. A part is considered non-removable if it is not individually accessible and cannot be detached from the equipment or a sub-assembly, with a view to its replacement. In this case, the points for the corresponding criterion 5.1 are not awarded.A link is established between the rating of sub-criterion 5.1 and that of sub-criterion 6.1, in the case where a part cannot be dismantled: the zero score is then passed on from one sub-criterion to another.",null,null,null,null,null,null,null,null,"External power supply and remote control do not need to be disassembled for disassembly steps. For these parts, the steps counted shall be : disconnecting the power cord and removing accumulators and battery from remote control."]
[]
[]
[null,"Ease of disassembly",null,null,"Rating",null,null,"    "]
[]
[null,"List 2 : Broken / malfunctioning parts ",null,null,"Number of steps required to disassemble the spare part","Subtotal"]
[null,"5.1.A","LED bar",null,"If DDi < 8",{"$f":"IF(E20='C5_Data'!$E$6,'C5_Data'!$F$6,IF(E20='C5_Data'!$E$7,'C5_Data'!$F$7,IF(E20='C5_Data'!$E$8,'C5_Data'!$F$8,IF(E20='C5_Data'!$E$9,'C5_Data'!$F$9,IF(E20='C5_Data'!$E$10,'C5_Data'!$F$10,IF(E20='C5_Data'!$E$11,'C5_Data'!$F$11,IF(E20='C5_Data'!$E$12,'C5_Data'!$F$12,0)))))))","v":3}]
[null,"5.1.B ","External power supply"]
[null,"5.1.C","Internal power supply",null,"If DDi < 8",{"$f":"IF($F$7=\"No\",0,IF(E22='C5_Data'!$E$6,'C5_Data'!$F$6,IF(E22='C5_Data'!$E$7,'C5_Data'!$F$7,IF(E22='C5_Data'!$E$8,'C5_Data'!$F$8,IF(E22='C5_Data'!$E$9,'C5_Data'!$F$9,IF(E22='C5_Data'!$E$10,'C5_Data'!$F$10,IF(E22='C5_Data'!$E$11,'C5_Data'!$F$11,IF(E22='C5_Data'!$E$12,'C5_Data'!$F$12,0))))))))","v":3}]
[null,"5.1.D","Main board",null,"If DDi < 8",{"$f":"IF(E23='C5_Data'!$E$6,'C5_Data'!$F$6,IF(E23='C5_Data'!$E$7,'C5_Data'!$F$7,IF(E23='C5_Data'!$E$8,'C5_Data'!$F$8,IF(E23='C5_Data'!$E$9,'C5_Data'!$F$9,IF(E23='C5_Data'!$E$10,'C5_Data'!$F$10,IF(E23='C5_Data'!$E$11,'C5_Data'!$F$11,IF(E23='C5_Data'!$E$12,'C5_Data'!$F$12,0)))))))","v":3}]
[null,"5.1.E","Display panel / LCD panel",null,"If DDi < 8",{"$f":"IF(E24='C5_Data'!$E$6,'C5_Data'!$F$6,IF(E24='C5_Data'!$E$7,'C5_Data'!$F$7,IF(E24='C5_Data'!$E$8,'C5_Data'!$F$8,IF(E24='C5_Data'!$E$9,'C5_Data'!$F$9,IF(E24='C5_Data'!$E$10,'C5_Data'!$F$10,IF(E24='C5_Data'!$E$11,'C5_Data'!$F$11,IF(E24='C5_Data'!$E$12,'C5_Data'!$F$12,0)))))))","v":3}]
[null,"Total sub-criterion 5.1",null,null,null,{"$f":"SUM(F20:F24)","v":12},{"$f":"IF(F7=\"Yes\",\"/ 12\",\"/ 9\")","v":"/ 12"}]
[null,null,null,null,null,{"$f":"IF(F7=\"yes\",F25*10/12,F25*10/9)","v":10},"/ 10"]
[]
[null,"SUB-CRITERION 5.2 : NECESSARY TOOLS TO REMOVE SPARE PARTS - BROKEN / MALFUNCTIONING PARTS (LIST 2) "]
[]
[null,"ADDITIONAL INFORMATIONS: "]
[null,"- Necessary tools to unitarily disassemble a spare part include all tools used to get access and disassemble the concerned part without causing "]
[null,"damage to the product (which might include getting access to fasteners)."]
[null,"- Tools used are classified according to the complexity of the operation to final users and the availability of tools."]
[null,"- In case of using different types of tools in the disassembly and reassembly sequences of a spare part, the worst score shall be considered."]
[]
[null,{"$f":"IF(OR(E21=\"Select a choice\",E22=\"Select a choice\",E23=\"Select a choice\",E24=\"Select a choice\",E20=\"Select a choice\"),\"Please fully complete criterion 5.1 before criterion 5.2\",\"\")","v":""}]
[]
[null,"Necessary tools for disassembly",null,null,"Rating"]
[]
[null,"List 2 : Broken / malfunctioning parts ",null,null,"Type of tools used for disassembly","Subtotal"]
[null,"5.2.A","LED bar",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(E41='C5_Data'!$E$18,'C5_Data'!$F$18,IF(E41='C5_Data'!$E$19,'C5_Data'!$F$19,IF(E41='C5_Data'!$E$20,'C5_Data'!$F$20,IF(E41='C5_Data'!$E$21,'C5_Data'!$F$21,IF(E41='C5_Data'!$E$22,'C5_Data'!$F$22,IF(E41='C5_Data'!$E$23,'C5_Data'!$F$23,IF(E41='C5_Data'!$E$24,'C5_Data'!$F$24,IF(E41='C5_Data'!$E$25,'C5_Data'!$F$25,0))))))))","v":4}]
[null,"5.2.B ","External power supply"]
[null,"5.2.C","Internal power supply",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF($F$7=\"No\",0,IF(E43='C5_Data'!$E$18,'C5_Data'!$F$18,IF(E43='C5_Data'!$E$19,'C5_Data'!$F$19,IF(E43='C5_Data'!$E$20,'C5_Data'!$F$20,IF(E43='C5_Data'!$E$21,'C5_Data'!$F$21,IF(E43='C5_Data'!$E$22,'C5_Data'!$F$22,IF(E43='C5_Data'!$E$23,'C5_Data'!$F$23,IF(E43='C5_Data'!$E$24,'C5_Data'!$F$24,IF(E43='C5_Data'!$E$25,'C5_Data'!$F$25,0)))))))))","v":4}]
[null,"5.2.D","Main board",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(E44='C5_Data'!$E$18,'C5_Data'!$F$18,IF(E44='C5_Data'!$E$19,'C5_Data'!$F$19,IF(E44='C5_Data'!$E$20,'C5_Data'!$F$20,IF(E44='C5_Data'!$E$21,'C5_Data'!$F$21,IF(E44='C5_Data'!$E$22,'C5_Data'!$F$22,IF(E44='C5_Data'!$E$23,'C5_Data'!$F$23,IF(E44='C5_Data'!$E$24,'C5_Data'!$F$24,IF(E44='C5_Data'!$E$25,'C5_Data'!$F$25,0))))))))","v":4}]
[null,"5.2.E","Display panel / LCD panel",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(E45='C5_Data'!$E$18,'C5_Data'!$F$18,IF(E45='C5_Data'!$E$19,'C5_Data'!$F$19,IF(E45='C5_Data'!$E$20,'C5_Data'!$F$20,IF(E45='C5_Data'!$E$21,'C5_Data'!$F$21,IF(E45='C5_Data'!$E$22,'C5_Data'!$F$22,IF(E45='C5_Data'!$E$23,'C5_Data'!$F$23,IF(E45='C5_Data'!$E$24,'C5_Data'!$F$24,IF(E45='C5_Data'!$E$25,'C5_Data'!$F$25,0))))))))","v":4}]
[null,"Total sub-criterion 5.2",null,null,null,{"$f":"SUM(F41:F45)","v":16},{"$f":"IF(F7=\"Yes\",\"/ 16\",\"/ 12\")","v":"/ 16"}]
[null,null,null,null,null,{"$f":"IF(F7=\"YES\",F46*10/16,F46*10/12)","v":10},"/ 10"]
[]
[null,"SUB-CRITERION 5.3 : CHARACTERISTICS OF FASTENERS FOR THE ASSEMBLY OF SPARE PARTS (LISTS 1 AND 2)"]
[]
[null,"ADDITIONAL INFORMATIONS: "]
[null,"- Fasteners : A hardware device that mechanically or magnetically connects or fixes two or more objects, parts or pieces. A fastener is generally "]
[null,"non-permanent, i.e., it can be easily removed or disassembled without damaging the objects, parts or pieces connected or fixed together (e.g., screws"]
[null," or clips). Welds and some glues are in contrast to permanent fixings. Adhesives are considered non-reusable fasteners unless new ones are supplied "]
[null,"with the spare part."]
[null,"- Fasteners removed are classified according to their accessibility, reusability, amovibility and also their constraints imposed to the product "]
[null,"reparability (e.g. fasteners causing damage or leaving welding or glue residues which preclude reusabiliy of the removed part)."]
[null,"- In case of removing different types of fasteners during the disassembly step of a spare part, the worst score shall be considered."]
[]
[null,{"$f":"IF(OR(E20=\"Select a choice\",E22=\"Select a choice\",E23=\"Select a choice\",E24=\"Select a choice\"),\"Please fully complete criterion 5.1 before criterion 5.3\",\"\")","v":""}]
[]
[null,"Fasteners characteristics",null,null,"Rating"]
[]
[null,"List 1 : Functional parts                                                                             List 2 : Broken / malfunctioning parts ",null,null,"Type of fasteners","Subtotal"]
[]
[null,"5.3.A","Rear cover",null,"C : Removable and reusable",{"$f":"IF(E66='C5_Data'!$E$29,'C5_Data'!$F$29,IF(E66='C5_Data'!$E$30,'C5_Data'!$F$30,IF(E66='C5_Data'!$E$31,'C5_Data'!$F$31,IF(E66='C5_Data'!$E$32,'C5_Data'!$F$32,IF(E66='C5_Data'!$E$33,'C5_Data'!$F$33,0)))))","v":2}]
[null,"5.3.B ","Wifi module",null,"C : Removable and reusable",{"$f":"IF(F8=\"No\",0,IF(E67='C5_Data'!$E$29,'C5_Data'!$F$29,IF(E67='C5_Data'!$E$30,'C5_Data'!$F$30,IF(E67='C5_Data'!$E$31,'C5_Data'!$F$31,IF(E67='C5_Data'!$E$32,'C5_Data'!$F$32,IF(E67='C5_Data'!$E$33,'C5_Data'!$F$33,0))))))","v":2}]
[null,"5.3.C","Bluetooth module",null,"C : Removable and reusable",{"$f":"IF(F9=\"No\",0,IF(E68='C5_Data'!$E$29,'C5_Data'!$F$29,IF(E68='C5_Data'!$E$30,'C5_Data'!$F$30,IF(E68='C5_Data'!$E$31,'C5_Data'!$F$31,IF(E68='C5_Data'!$E$32,'C5_Data'!$F$32,IF(E68='C5_Data'!$E$33,'C5_Data'!$F$33,0))))))","v":2}]
[null,"5.3.D","Infrared receiver (IR)",null,"C : Removable and reusable",{"$f":"IF(E69=\"A : Neither removable nor reusable\",0,IF(E69=\"B : Removable but not reusable\",1,IF(E69=\"C : Removable and reusable\",2,IF(E69=\"Part not included\",2,0))))","v":2}]
[null,"5.3.E","Loudspeaker",null,"C : Removable and reusable",2]
[null,"5.3.F ","Connectors to connect external equipment (cable,, antenna, USB, DVD and Blue-Ray)",null,"B : Removable but not reusable",{"$f":"IF(E71=\"A : Neither removable nor reusable\",0,IF(E71=\"B : Removable but not reusable\",1,IF(E71=\"C : Removable and reusable\",2,IF(E71=\"Part not included\",2,0))))","v":1},null,null,null,null,null,null,"Sortie2"]
[null,"5.3.G","Remote control",null,"C : Removable and reusable",2,null,null,"E5","E6","E7","Sortie1","Sortie2"]
[null,"5.3.H","LED bar",null,"C : Removable and reusable",{"$f":"IF(E73=\"A : Neither removable nor reusable\",0,IF(E73=\"B : Removable but not reusable\",1,IF(E73=\"C : Removable and reusable\",2,IF(E73=\"Part not included\",2,0))))","v":2},null,null,"Yes","Yes","Yes","\"22\"",{"$f":"IF(AND($F$7=I73,$F$8=J73,$F$9=K73),L73,\"\")","v":"\"22\""}]
[null,"5.3.I","External power supply",null,null,null,null,null,"Yes","Yes","No","\"20\"",""]
[null,"5.3.J","Internal power supply",null,"C : Removable and reusable",{"$f":"IF(F7=\"No\",0,IF(E75='C5_Data'!$E$29,'C5_Data'!$F$29,IF(E75='C5_Data'!$E$30,'C5_Data'!$F$30,IF(E75='C5_Data'!$E$31,'C5_Data'!$F$31,IF(E75='C5_Data'!$E$32,'C5_Data'!$F$32,IF(E75='C5_Data'!$E$33,'C5_Data'!$F$33,0))))))","v":2},null,null,"Yes","No","Yes","\"20\"",""]
[null,"5.3.K","Main board",null,"C : Removable and reusable",{"$f":"IF(E76=\"A : Neither removable nor reusable\",0,IF(E76=\"B : Removable but not reusable\",1,IF(E76=\"C : Removable and reusable\",2,IF(E76=\"Part not included\",2,0))))","v":2},null,null,"Yes","No","No","\"18\"",""]
[null,"5.3.L","Display panel / LCD panel",null,"C : Removable and reusable",{"$f":"IF(E77=\"A : Neither removable nor reusable\",0,IF(E77=\"B : Removable but not reusable\",1,IF(E77=\"C : Removable and reusable\",2,IF(E77=\"Part not included\",2,0))))","v":2},null,null,"No","Yes","Yes","\"20\"",""]
[null,"Total sub-criterion 5.3",null,null,null,{"$f":"SUM(F66:F77)","v":21},{"$f":"IF(F7=\"Select a choice\",\"/22\",M83)","v":"/22"},null,"No","Yes","No","\"18\"",""]
[null,null,null,null,null,{"$f":"IF(F7=\"Select a choice\",\"0\",F78*10/M82)","v":9.545454545454545},"/10",null,"No","No","Yes","\"18\"",""]
[null,null,null,null,null,null,null,null,"No","No","No","\"16\"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(M73,M74,M75,M76,M77,M78,M79,M80)","v":"\"22\""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID($M$81,FIND(\"\"\"\",$M$81,1)+1,FIND(\"/\",SUBSTITUTE($M$81,\"\"\"\",\"/\",2))-FIND(\"\"\"\",$M$81,1)-1)","v":"22"}]
[null,null,null," ",null,null,null,null,null,null,null,null,{"$f":"\"/\"&MID($M$81,FIND(\"\"\"\",$M$81,1)+1,FIND(\"/\",SUBSTITUTE($M$81,\"\"\"\",\"/\",2))-FIND(\"\"\"\",$M$81,1)-1)","v":"/22"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($F$7=I73,$F$8=J73,$F$9=K73),L73,\"\")","v":"\"22\""}]

{"sheet":"C5_Data","index":11,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"CRITERION 5 : DOCUMENTATION"]
[null,null,"SUB-CRITERION 5.1 : EASE OF DISASSEMBLY OF SPARE PARTS - BROKEN / MALFUNCTIONING PARTS (LIST 2)"]
[]
[]
[]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"Not removable","Not removable",0]
[null,null,null,"If DDi ≥ 12","If DDi ≥ 12",0]
[null,null,null,"If 12 > DDi ≥ 10","If 12 > DDi ≥ 10",1]
[null,null,null,"If 10 > DDi ≥ 8","If 10 > DDi ≥ 8",2]
[null,null,null,"If DDi < 8","If DDi < 8",3]
[null,null,null,"Part not included","Part not included",3]
[null,null,"SUB-CRITERION 5.2: CONSUMER SUPPORT FOR DIAGNOSIS AND REPAIR"]
[null,null,"5.2.A","Consumer information"]
[null,null,null,"Column A"]
[]
[null,null,null,"outils","outils"]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"A : Not removable","A : Not removable",0]
[null,null,null,"B : Removable with proprietary tools","B : Removable with proprietary tools",1]
[null,null,null,"C : Removable with specific tools","C : Removable with specific tools",2]
[null,null,null,"D : Removable with no tool, with tools supplied with the product or with basic tools","D : Removable with no tool, with tools supplied with the product or with basic tools",4]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"Part not included","Part not included",4]
[null,null,null,"A : Not removable","A : Not removable",0]
[null,null,"5.2.B","Remote assistance"]
[null,null,null,"Column A : A remplir"]
[]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"A : Neither removable nor reusable","A : Neither removable nor reusable",0]
[null,null,null,"B : Removable but not reusable","B : Removable but not reusable",1]
[null,null,null,"C : Removable and reusable","C : Removable and reusable",2]
[null,null,null,"Part not included","Part not included",2]

{"sheet":"C6_AVAILABILITY_SP","index":12,"n_rows":79,"n_cols":14,"rows_kept":79,"cut":false,"hidden":false,"merged":[[75,34,75,35],[43,2,43,3],[75,2,75,3],[75,20,75,21],[75,22,75,23],[75,24,75,25],[75,26,75,27],[75,28,75,29],[75,30,75,31],[75,32,75,33],[52,8,52,9],[0,1,1,9],[22,1,22,3],[70,34,70,35],[70,28,70,29],[70,30,70,31],[70,32,70,33],[52,1,53,3],[60,1,61,3],[25,2,25,3],[26,2,26,3],[67,1,68,3],[63,1,63,9],[28,1,29,3],[44,2,44,3],[23,2,23,3],[24,2,24,3],[3,1,3,9],[31,1,31,9],[35,1,36,3],[16,1,16,9],[48,1,48,9],[6,1,6,9],[14,1,14,9],[35,4,35,5],[35,8,35,9],[35,10,35,11],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[20,10,20,11],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[20,8,20,9],[15,1,15,9],[27,2,27,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[42,2,42,3],[52,10,52,11],[73,30,73,31],[70,24,70,25],[70,26,70,27],[73,20,73,21],[73,22,73,23],[70,22,70,23],[70,20,70,21],[37,1,37,3],[56,2,56,3],[41,2,41,3],[53,4,53,5],[45,1,46,3],[67,4,67,5],[68,4,68,5],[52,4,52,5],[52,6,52,7],[35,6,35,7],[67,36,69,36],[68,20,68,27],[68,28,68,35],[69,30,69,31],[69,32,69,33],[69,34,69,35],[53,6,53,7],[53,8,53,9],[53,10,53,11],[67,6,67,7],[67,8,67,9],[67,10,67,11],[68,6,68,7],[68,8,68,9],[68,10,68,11],[0,10,1,13],[20,12,21,12],[69,28,69,29],[67,28,67,35],[69,20,69,21],[69,22,69,23],[69,24,69,25],[69,26,69,27],[67,20,67,27],[18,1,18,11],[50,1,50,11],[65,1,65,11],[57,2,57,3],[54,1,54,3],[58,2,58,3],[59,2,59,3],[55,2,55,3],[33,1,33,11],[5,1,5,9],[7,1,12,9],[13,1,13,9],[20,4,20,5],[20,6,20,7],[20,1,21,3],[77,36,78,36],[71,24,71,25],[71,26,71,27],[71,28,71,29],[71,30,71,31],[71,32,71,33],[71,34,71,35],[74,24,74,25],[74,26,74,27],[74,28,74,29],[74,30,74,31],[74,32,74,33],[74,34,74,35],[76,32,76,33],[76,34,76,35],[72,32,72,33],[72,34,72,35],[76,30,76,31],[76,24,76,25],[76,26,76,27],[76,28,76,29],[72,24,72,25],[72,26,72,27],[72,28,72,29],[77,20,78,27],[77,28,78,35],[77,1,78,3],[76,20,76,21],[69,1,69,3],[76,22,76,23],[74,20,74,21],[74,22,74,23],[71,22,71,23],[71,20,71,21],[72,20,72,21],[72,22,72,23],[72,30,72,31],[74,2,74,3],[76,2,76,3],[70,2,70,3],[71,2,71,3],[73,2,73,3],[72,2,72,3],[73,32,73,33],[73,34,73,35],[73,24,73,25],[73,26,73,27],[73,28,73,29]]}
[null,"CRITERION 6 : AVAILABILITY OF SPARE PARTS",null,null,null,null,null,null,null,null,"Television"]
[]
[]
[null,"SUB-CRITERION 6.1 : COMMITMENT ON THE AVAILABILITY OVER TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS (LIST 2)"]
[]
[null,"ADDITIONAL INFORMATIONS: "]
[null,"Definition of spare parts distributor: The definition of a spare parts distributor is given in the glossary in appendix 1 of the gird"]
[null,"Commitments on the availability of spare parts and delivery times (except Sunday and fest days): To award points to the A columns, the producer should have his own in-house repair service (example: via the after-sales service). Whether for the period of availability of spare parts or the delivery time, the producer or the importer must retain, among all of their practices towards authorized and independent repairers, the period or the most penalizing time for each spare part. In the event that the producer or importer does not make spare parts directly available to independent repairers, then points are not awarded in column C of criterion 6.1, 6.2, 6.3 and 6.4."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C5_DISASSEMBLY'!F7","v":"Yes"},"INTER"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C5_DISASSEMBLY'!F8","v":"Yes"},"WIFI"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C5_DISASSEMBLY'!F9","v":"Yes"},"BLEU"]
[]
[null,"In addition, in the event that the producer or importer does not have an approved repairers network, the points are awarded "]
[null,"based on the most penalizing practices towards independent repairers."]
[null,"Delivery time: The delivery time is understood in working days between the day of the order and the day of arrival at the actor "]
[null,"concerned."]
[]
[null,{"$f":"IF(OR('C5_DISASSEMBLY'!E20=\"Select a choice\",'C5_DISASSEMBLY'!E22=\"Select a choice\",'C5_DISASSEMBLY'!E23=\"Select a choice\",'C5_DISASSEMBLY'!E24=\"Select a choice\"),\"Please fully complete criterion 5.1 before criterion 6.1\",\"\")","v":""}]
[]
[null,"Commitment on the availability over time of spare parts (in years)",null,null,"Column A",null,"Column B",null,"Column C",null,"Column D"]
[null,null,null,null,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
[null,"List 2 : Broken / malfunctioning parts ",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal"]
[null,"6.1.A","LED bar",null,"If X ≥ 11 years",{"$f":"IF(E24='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E24='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E24='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E24='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E24='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E24='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E24='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E24='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E24='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E24='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E24='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G24='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G24='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G24='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G24='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G24='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G24='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G24='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G24='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G24='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G24='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G24='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I24='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I24='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I24='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I24='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I24='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I24='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I24='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I24='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I24='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I24='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I24='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K24='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K24='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K24='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K24='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K24='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K24='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K24='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K24='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K24='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K24='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K24='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},{"$f":"'C5_DISASSEMBLY'!E20","v":"If DDi < 8"}]
[null,"6.1.B ","External power supply",null,null,{"$f":"IF($L$10=\"Yes\",0,IF(E25='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E25='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E25='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E25='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E25='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E25='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E25='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E25='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E25='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E25='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E25='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(G25='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G25='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G25='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G25='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G25='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G25='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G25='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G25='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G25='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G25='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G25='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(I25='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I25='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I25='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I25='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I25='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I25='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I25='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I25='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I25='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I25='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I25='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(K25='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K25='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K25='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K25='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K25='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K25='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K25='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K25='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K25='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K25='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K25='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},{"$f":"'C5_DISASSEMBLY'!E21","v":0}]
[null,"6.1.C","Internal power supply",null,"If X ≥ 11 years",{"$f":"IF($L$10=\"No\",0,IF(E26='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E26='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E26='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E26='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E26='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E26='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E26='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E26='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E26='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E26='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E26='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF($L$10=\"No\",0,IF(G26='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G26='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G26='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G26='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G26='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G26='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G26='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G26='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G26='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G26='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G26='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X < 7 years",{"$f":"IF($L$10=\"No\",0,IF(I26='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I26='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I26='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I26='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I26='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I26='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I26='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I26='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I26='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I26='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I26='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},"If X < 7 years",{"$f":"IF($L$10=\"No\",0,IF(K26='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K26='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K26='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K26='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K26='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K26='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K26='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K26='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K26='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K26='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K26='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},{"$f":"'C5_DISASSEMBLY'!E22","v":"If DDi < 8"}]
[null,"6.1.D","Main board",null,"If X ≥ 11 years",{"$f":"IF(E27='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E27='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E27='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E27='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E27='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E27='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E27='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E27='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E27='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E27='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E27='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G27='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G27='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G27='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G27='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G27='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G27='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G27='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G27='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G27='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G27='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G27='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I27='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I27='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I27='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I27='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I27='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I27='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I27='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I27='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I27='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I27='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I27='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K27='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K27='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K27='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K27='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K27='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K27='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K27='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K27='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K27='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K27='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K27='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},{"$f":"'C5_DISASSEMBLY'!E23","v":"If DDi < 8"}]
[null,"6.1.E","Display panel / LCD panel",null,"If X ≥ 11 years",{"$f":"IF(E28='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E28='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E28='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E28='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E28='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E28='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E28='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E28='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E28='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E28='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E28='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G28='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G28='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G28='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G28='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G28='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G28='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G28='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G28='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G28='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G28='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G28='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I28='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I28='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I28='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I28='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I28='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I28='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I28='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I28='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I28='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I28='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I28='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K28='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K28='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K28='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K28='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K28='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K28='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K28='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K28='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K28='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K28='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K28='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},{"$f":"'C5_DISASSEMBLY'!E24","v":"If DDi < 8"}]
[null,"Total sub-criterion 6.1",null,null,null,{"$f":"SUM(F24:F28)","v":44},null,{"$f":"SUM(H24:H28)","v":44},null,{"$f":"SUM(J24:J28)","v":0},null,{"$f":"SUM(L24:L28)","v":0},{"$f":"F29+H29+J29+L29","v":88},"/ 176"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M29*10/176","v":5},"/ 10"]
[]
[null,"SUB-CRITERION 6.2 : COMMITMENT ON THE AVAILABILITY OVER TIME OF SPARE PARTS - FUNCTIONAL PARTS (LIST 1)"]
[]
[null,{"$f":"IF(OR('C5_DISASSEMBLY'!E66=\"Select a choice\",'C5_DISASSEMBLY'!E67=\"Select a choice\",'C5_DISASSEMBLY'!E68=\"Select a choice\",'C5_DISASSEMBLY'!E69=\"Select a choice\",'C5_DISASSEMBLY'!E70=\"Select a choice\",'C5_DISASSEMBLY'!E72=\"Select a choice\"),\"Please fully complete criterion 5.3 before criterion 6.2\",\"\")","v":""}]
[]
[null,"Commitment on the availability over time of spare parts (in years)",null,null,"Column A",null,"Column B",null,"Column C",null,"Column D"]
[null,null,null,null,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
[null,"List 1 : Functional parts",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal"]
[null,"6.2.A","Rear cover",null,"If X ≥ 11 years",{"$f":"IF(E39='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E39='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E39='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E39='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E39='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E39='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E39='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E39='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E39='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E39='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E39='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G39='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G39='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G39='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G39='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G39='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G39='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G39='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G39='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G39='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G39='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G39='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I39='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I39='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I39='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I39='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I39='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I39='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I39='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I39='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I39='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I39='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I39='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K39='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K39='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K39='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K39='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K39='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K39='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K39='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K39='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K39='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K39='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K39='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0}]
[null,"6.2.B","Wifi module",null,"If X ≥ 11 years",{"$f":"IF($L$11=\"No\",0,IF(E40='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E40='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E40='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E40='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E40='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E40='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E40='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E40='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E40='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E40='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E40='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF($L$11=\"No\",0,IF(G40='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G40='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G40='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G40='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G40='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G40='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G40='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G40='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G40='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G40='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G40='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X < 7 years",{"$f":"IF($L$11=\"No\",0,IF(I40='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I40='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I40='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I40='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I40='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I40='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I40='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I40='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I40='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I40='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I40='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},"If X < 7 years",{"$f":"IF($L$11=\"No\",0,IF(K40='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K40='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K40='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K40='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K40='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K40='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K40='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K40='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K40='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K40='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K40='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0}]
[null,"6.2.C","Bluetooth module",null,"If X ≥ 11 years",{"$f":"IF($L$12=\"No\",0,IF(E41='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E41='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E41='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E41='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E41='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E41='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E41='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E41='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E41='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E41='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E41='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF($L$12=\"No\",0,IF(G41='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G41='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G41='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G41='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G41='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G41='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G41='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G41='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G41='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G41='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G41='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":11},"If X < 7 years",{"$f":"IF($L$12=\"No\",0,IF(I41='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I41='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I41='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I41='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I41='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I41='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I41='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I41='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I41='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I41='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I41='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0},"If X < 7 years",{"$f":"IF($L$12=\"No\",0,IF(K41='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K41='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K41='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K41='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K41='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K41='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K41='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K41='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K41='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K41='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K41='C6_Data'!$E$16,'C6_Data'!$F$16,0))))))))))))","v":0}]
[null,"6.2.D","Infrared receiver (IR)",null,"If X ≥ 11 years",{"$f":"IF(E42='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E42='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E42='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E42='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E42='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E42='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E42='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E42='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E42='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E42='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E42='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G42='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G42='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G42='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G42='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G42='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G42='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G42='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G42='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G42='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G42='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G42='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I42='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I42='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I42='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I42='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I42='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I42='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I42='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I42='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I42='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I42='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I42='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K42='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K42='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K42='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K42='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K42='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K42='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K42='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K42='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K42='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K42='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K42='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0}]
[null,"6.2.E","Loudspeaker",null,"If X ≥ 11 years",{"$f":"IF(E43='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E43='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E43='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E43='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E43='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E43='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E43='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E43='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E43='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E43='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E43='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G43='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G43='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G43='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G43='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G43='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G43='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G43='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G43='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G43='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G43='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G43='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I43='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I43='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I43='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I43='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I43='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I43='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I43='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I43='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I43='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I43='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I43='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K43='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K43='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K43='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K43='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K43='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K43='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K43='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K43='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K43='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K43='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K43='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0}]
[null,"6.2.F","Connectors to connect external equipment (cable,, antenna, USB, DVD and Blue-Ray)",null,"If X ≥ 11 years",{"$f":"IF(E44='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E44='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E44='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E44='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E44='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E44='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E44='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E44='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E44='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E44='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E44='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G44='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G44='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G44='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G44='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G44='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G44='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G44='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G44='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G44='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G44='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G44='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X < 7 years",{"$f":"IF(I44='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I44='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I44='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I44='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I44='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I44='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I44='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I44='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I44='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I44='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I44='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0},"If X < 7 years",{"$f":"IF(K44='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K44='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K44='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K44='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K44='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K44='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K44='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K44='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K44='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K44='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K44='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":0}]
[null,"6.2.G","Remote control",null,"If X ≥ 11 years",{"$f":"IF(E45='C6_Data'!$E$6,'C6_Data'!$F$6,IF(E45='C6_Data'!$E$7,'C6_Data'!$F$7,IF(E45='C6_Data'!$E$8,'C6_Data'!$F$8,IF(E45='C6_Data'!$E$9,'C6_Data'!$F$9,IF(E45='C6_Data'!$E$10,'C6_Data'!$F$10,IF(E45='C6_Data'!$E$11,'C6_Data'!$F$11,IF(E45='C6_Data'!$E$12,'C6_Data'!$F$12,IF(E45='C6_Data'!$E$13,'C6_Data'!$F$13,IF(E45='C6_Data'!$E$14,'C6_Data'!$F$14,IF(E45='C6_Data'!$E$15,'C6_Data'!$F$15,IF(E45='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(G45='C6_Data'!$E$6,'C6_Data'!$F$6,IF(G45='C6_Data'!$E$7,'C6_Data'!$F$7,IF(G45='C6_Data'!$E$8,'C6_Data'!$F$8,IF(G45='C6_Data'!$E$9,'C6_Data'!$F$9,IF(G45='C6_Data'!$E$10,'C6_Data'!$F$10,IF(G45='C6_Data'!$E$11,'C6_Data'!$F$11,IF(G45='C6_Data'!$E$12,'C6_Data'!$F$12,IF(G45='C6_Data'!$E$13,'C6_Data'!$F$13,IF(G45='C6_Data'!$E$14,'C6_Data'!$F$14,IF(G45='C6_Data'!$E$15,'C6_Data'!$F$15,IF(G45='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(I45='C6_Data'!$E$6,'C6_Data'!$F$6,IF(I45='C6_Data'!$E$7,'C6_Data'!$F$7,IF(I45='C6_Data'!$E$8,'C6_Data'!$F$8,IF(I45='C6_Data'!$E$9,'C6_Data'!$F$9,IF(I45='C6_Data'!$E$10,'C6_Data'!$F$10,IF(I45='C6_Data'!$E$11,'C6_Data'!$F$11,IF(I45='C6_Data'!$E$12,'C6_Data'!$F$12,IF(I45='C6_Data'!$E$13,'C6_Data'!$F$13,IF(I45='C6_Data'!$E$14,'C6_Data'!$F$14,IF(I45='C6_Data'!$E$15,'C6_Data'!$F$15,IF(I45='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11},"If X ≥ 11 years",{"$f":"IF(K45='C6_Data'!$E$6,'C6_Data'!$F$6,IF(K45='C6_Data'!$E$7,'C6_Data'!$F$7,IF(K45='C6_Data'!$E$8,'C6_Data'!$F$8,IF(K45='C6_Data'!$E$9,'C6_Data'!$F$9,IF(K45='C6_Data'!$E$10,'C6_Data'!$F$10,IF(K45='C6_Data'!$E$11,'C6_Data'!$F$11,IF(K45='C6_Data'!$E$12,'C6_Data'!$F$12,IF(K45='C6_Data'!$E$13,'C6_Data'!$F$13,IF(K45='C6_Data'!$E$14,'C6_Data'!$F$14,IF(K45='C6_Data'!$E$15,'C6_Data'!$F$15,IF(K45='C6_Data'!$E$16,'C6_Data'!$F$16,0)))))))))))","v":11}]
[null,"Total sub-criterion 6.2 ",null,null,null,{"$f":"SUM(F39:F45)","v":77},null,{"$f":"SUM(H39:H45)","v":77},null,{"$f":"SUM(J39:J45)","v":11},null,{"$f":"SUM(L39:L45)","v":11},{"$f":"F46+H46+J46+L46","v":176},{"$f":"IF(AND(L11=\"No\",L12=\"No\"),\"/220\",IF(OR(L11=\"No\",L12=\"No\"),\"/ 264\",\"/ 308\"))","v":"/ 308"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L11=\"No\",L12=\"No\"),(M46*10/220),IF(OR(L11=\"No\",L12=\"No\"),(M46*10/264),(M46*10/308)))","v":5.7142857142857144},"/ 10"]
[]
[null,"SUB-CRITERION 6.3 : COMMITMENT ON THE DELIVERY TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS (LIST 2)"]
[]
[null,{"$f":"IF(OR(G24=\"Select a choice\",G25=\"Select a choice\",G26=\"Select a choice\",G27=\"Select a choice\",G28=\"Select a choice\",I24=\"Select a choice\",I25=\"Select a choice\",I26=\"Select a choice\",I27=\"Select a choice\",I28=\"Select a choice\",K24=\"Select a choice\",K25=\"Select a choice\",K26=\"Select a choice\",K27=\"Select a choice\",K28=\"Select a choice\",E24=\"Select a choice\",E25=\"Select a choice\",E26=\"Select a choice\",E27=\"Select a choice\",E28=\"Select a choice\"),\"Please fully complete criterion 6.1 before criterion 6.3\",\"\")","v":""}]
[]
[null,"Commitment on the delivery time of spare parts\n(in working days)",null,null,"Column A",null,"Column B",null,"Column C",null,"Column D"]
[null,null,null,null,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
[null,"List 2 : Broken / malfunctioning parts ",null,null,"Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal"]
[null,"6.3.A","LED bar",null,"If X ≤ 3 d",{"$f":"IF(E56='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E56='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E56='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E56='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E56='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E56='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E56='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E56='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G56='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G56='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G56='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G56='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G56='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G56='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G56='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G56='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I56='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I56='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I56='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I56='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I56='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I56='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I56='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I56='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K56='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K56='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K56='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K56='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K56='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K56='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K56='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K56='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.3.B","External power supply",null,null,{"$f":"IF($L$10=\"Yes\",0,IF(E57='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E57='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E57='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E57='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E57='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E57='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E57='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E57='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(G57='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G57='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G57='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G57='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G57='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G57='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G57='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G57='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(I57='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I57='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I57='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I57='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I57='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I57='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I57='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I57='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},null,{"$f":"IF($L$10=\"Yes\",0,IF(K57='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K57='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K57='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K57='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K57='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K57='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K57='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K57='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0}]
[null,"6.3.C","Internal power supply",null,"If X ≤ 3 d",{"$f":"IF($L$10=\"No\",0,IF(E58='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E58='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E58='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E58='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E58='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E58='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E58='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E58='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X ≤ 3 d",{"$f":"IF($L$10=\"No\",0,IF(G58='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G58='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G58='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G58='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G58='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G58='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G58='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G58='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X >10 d",{"$f":"IF($L$10=\"No\",0,IF(I58='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I58='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I58='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I58='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I58='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I58='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I58='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I58='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},"If X >10 d",{"$f":"IF($L$10=\"No\",0,IF(K58='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K58='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K58='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K58='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K58='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K58='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K58='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K58='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0}]
[null,"6.3.D","Main board",null,"If X ≤ 3 d",{"$f":"IF(E59='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E59='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E59='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E59='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E59='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E59='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E59='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E59='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G59='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G59='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G59='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G59='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G59='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G59='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G59='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G59='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I59='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I59='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I59='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I59='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I59='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I59='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I59='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I59='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K59='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K59='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K59='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K59='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K59='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K59='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K59='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K59='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.3.E","Display panel / LCD panel",null,"If X ≤ 3 d",{"$f":"IF(E60='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E60='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E60='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E60='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E60='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E60='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E60='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E60='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G60='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G60='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G60='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G60='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G60='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G60='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G60='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G60='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I60='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I60='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I60='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I60='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I60='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I60='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I60='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I60='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K60='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K60='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K60='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K60='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K60='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K60='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K60='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K60='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"Total sub-criterion 6.3",null,null,null,{"$f":"SUM(F56:F60)","v":12},null,{"$f":"SUM(H56:H60)","v":12},null,{"$f":"SUM(J56:J60)","v":0},null,{"$f":"SUM(L56:L60)","v":0},{"$f":"F61+H61+L61+J61","v":24},"/ 48"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M61*10/48","v":5},"/ 10"]
[]
[null,"SUB-CRITERION 6.4 : COMMITMENT ON THE DELIVERY TIME OF SPARE PARTS - FUNCTIONAL PARTS (LIST 1)"]
[]
[null,{"$f":"IF(OR(G39=\"Select a choice\",G40=\"Select a choice\",G41=\"Select a choice\",G42=\"Select a choice\",G43=\"Select a choice\",G45=\"Select a choice\",I39=\"Select a choice\",I40=\"Select a choice\",I41=\"Select a choice\",I42=\"Select a choice\",I43=\"Select a choice\",I45=\"Select a choice\",K39=\"Select a choice\",K40=\"Select a choice\",K41=\"Select a choice\",K42=\"Select a choice\",K43=\"Select a choice\",K45=\"Select a choice\",E39=\"Select a choice\",E40=\"Select a choice\",E41=\"Select a choice\",E42=\"Select a choice\",E43=\"Select a choice\",E45=\"Select a choice\"),\"Please fully complete criterion 6.2 before criterion 6.4\",\"\")","v":""}]
[]
[null,"Commitment on the delivery time of spare parts\n(in working days)",null,null,"Column A",null,"Column B",null,"Column C",null,"Column D"]
[null,null,null,null,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
[null,"List 1 : Functional parts",null,null,"Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal"]
[null,"6.4.A","Rear cover",null,"If X ≤ 3 d",{"$f":"IF(E71='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E71='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E71='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E71='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E71='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E71='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E71='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E71='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G71='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G71='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G71='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G71='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G71='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G71='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G71='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G71='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I71='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I71='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I71='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I71='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I71='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I71='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I71='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I71='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K71='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K71='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K71='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K71='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K71='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K71='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K71='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K71='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.4.B","Wifi module",null,"If X ≤ 3 d",{"$f":"IF($L$11=\"No\",0,IF(E72='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E72='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E72='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E72='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E72='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E72='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E72='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E72='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X ≤ 3 d",{"$f":"IF($L$11=\"No\",0,IF(G72='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G72='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G72='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G72='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G72='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G72='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G72='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G72='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X >10 d",{"$f":"IF($L$11=\"No\",0,IF(I72='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I72='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I72='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I72='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I72='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I72='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I72='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I72='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},"If X >10 d",{"$f":"IF($L$11=\"No\",0,IF(K72='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K72='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K72='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K72='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K72='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K72='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K72='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K72='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0}]
[null,"6.4.C","Bluetooth module",null,"If X ≤ 3 d",{"$f":"IF($L$12=\"No\",0,IF(E73='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E73='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E73='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E73='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E73='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E73='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E73='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E73='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X ≤ 3 d",{"$f":"IF($L$12=\"No\",0,IF(G73='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G73='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G73='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G73='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G73='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G73='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G73='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G73='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":3},"If X >10 d",{"$f":"IF($L$12=\"No\",0,IF(I73='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I73='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I73='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I73='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I73='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I73='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I73='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I73='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0},"If X >10 d",{"$f":"IF($L$12=\"No\",0,IF(K73='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K73='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K73='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K73='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K73='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K73='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K73='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K73='C6_Data'!$E$31,'C6_Data'!$F$31,0)))))))))","v":0}]
[null,"6.4.D","Infrared receiver (IR)",null,"If X ≤ 3 d",{"$f":"IF(E74='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E74='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E74='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E74='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E74='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E74='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E74='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E74='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G74='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G74='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G74='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G74='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G74='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G74='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G74='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G74='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I74='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I74='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I74='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I74='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I74='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I74='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I74='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I74='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K74='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K74='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K74='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K74='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K74='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K74='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K74='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K74='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.4.E","Loudspeaker",null,"If X ≤ 3 d",{"$f":"IF(E75='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E75='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E75='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E75='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E75='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E75='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E75='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E75='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G75='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G75='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G75='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G75='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G75='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G75='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G75='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G75='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I75='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I75='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I75='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I75='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I75='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I75='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I75='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I75='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K75='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K75='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K75='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K75='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K75='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K75='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K75='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K75='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.4.F","Connectors to connect external equipment (cable,, antenna, USB, DVD and Blue-Ray)",null,"If X ≤ 3 d",{"$f":"IF(E76='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E76='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E76='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E76='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E76='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E76='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E76='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E76='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G76='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G76='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G76='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G76='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G76='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G76='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G76='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G76='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X >10 d",{"$f":"IF(I76='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I76='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I76='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I76='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I76='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I76='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I76='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I76='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0},"If X >10 d",{"$f":"IF(K76='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K76='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K76='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K76='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K76='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K76='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K76='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K76='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":0}]
[null,"6.4.G","Remote control",null,"If X ≤ 3 d",{"$f":"IF(E77='C6_Data'!$E$24,'C6_Data'!$F$24,IF(E77='C6_Data'!$E$25,'C6_Data'!$F$25,IF(E77='C6_Data'!$E$26,'C6_Data'!$F$26,IF(E77='C6_Data'!$E$27,'C6_Data'!$F$27,IF(E77='C6_Data'!$E$28,'C6_Data'!$F$28,IF(E77='C6_Data'!$E$29,'C6_Data'!$F$29,IF(E77='C6_Data'!$E$30,'C6_Data'!$F$30,IF(E77='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(G77='C6_Data'!$E$24,'C6_Data'!$F$24,IF(G77='C6_Data'!$E$25,'C6_Data'!$F$25,IF(G77='C6_Data'!$E$26,'C6_Data'!$F$26,IF(G77='C6_Data'!$E$27,'C6_Data'!$F$27,IF(G77='C6_Data'!$E$28,'C6_Data'!$F$28,IF(G77='C6_Data'!$E$29,'C6_Data'!$F$29,IF(G77='C6_Data'!$E$30,'C6_Data'!$F$30,IF(G77='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(I77='C6_Data'!$E$24,'C6_Data'!$F$24,IF(I77='C6_Data'!$E$25,'C6_Data'!$F$25,IF(I77='C6_Data'!$E$26,'C6_Data'!$F$26,IF(I77='C6_Data'!$E$27,'C6_Data'!$F$27,IF(I77='C6_Data'!$E$28,'C6_Data'!$F$28,IF(I77='C6_Data'!$E$29,'C6_Data'!$F$29,IF(I77='C6_Data'!$E$30,'C6_Data'!$F$30,IF(I77='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3},"If X ≤ 3 d",{"$f":"IF(K77='C6_Data'!$E$24,'C6_Data'!$F$24,IF(K77='C6_Data'!$E$25,'C6_Data'!$F$25,IF(K77='C6_Data'!$E$26,'C6_Data'!$F$26,IF(K77='C6_Data'!$E$27,'C6_Data'!$F$27,IF(K77='C6_Data'!$E$28,'C6_Data'!$F$28,IF(K77='C6_Data'!$E$29,'C6_Data'!$F$29,IF(K77='C6_Data'!$E$30,'C6_Data'!$F$30,IF(K77='C6_Data'!$E$31,'C6_Data'!$F$31,0))))))))","v":3}]
[null,"Total sub-criterion 6.4",null,null,null,{"$f":"SUM(F71:F77)","v":21},null,{"$f":"SUM(H71:H77)","v":21},null,{"$f":"SUM(J71:J77)","v":3},null,{"$f":"SUM(L71:L77)","v":3},{"$f":"F78+H78+L78+J78","v":48},{"$f":"IF(AND(L11=\"No\",L12=\"No\"),\"/60\",IF(OR(L11=\"No\",L12=\"No\"),\"/ 72\",\"/ 84\"))","v":"/ 84"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L11=\"No\",L12=\"No\"),(M78*10/60),IF(OR(L11=\"No\",L12=\"No\"),(M78*10/72),(M78*10/84)))","v":5.7142857142857144},"/ 10"]

{"sheet":"C6_Data","index":13,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,2,0,3]]}
[null,null,"CRITERION 5 : DOCUMENTATION"]
[null,null,"SUB-CRITERION 6.1  and 6.2: COMMITMENT ON THE AVAILABILITY OVER TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS"]
[null,null,"5.1"]
[null,null,null,"Availability time of spare part"]
[]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"If X < 7 years","If X < 7 years",0]
[null,null,null,"If 7 years ≤ X < 9 years","If 7 years ≤ X < 9 years",7]
[null,null,null,"If 9 years ≤ X < 11 years","If 9 years ≤ X < 11 years",9]
[null,null,null,"If X ≥ 11 years","If X ≥ 11 years",11]
[null,null,null,"Not available","Not available",0]
[null,null,null,"Part not included","Part not included",11]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"Not removable et disponible","Not removable and available",0]
[null,null,null,"Not available","Not available",0]
[null,null,null,"Not removable","Not removable",0]
[]
[]
[]
[null,null,"SUB-CRITERION 6.3 and 6.4 :  COMMITMENT ON THE DELIVERY TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS"]
[null,null,"5.2.A","Consumer information"]
[null,null,null,"Delivery time of spare part"]
[]
[null,null,null,"Select a choice","Select a choice",0]
[null,null,null,"If X >10 d","If X >10 d",0]
[null,null,null,"If 10 d ≥ X > 5 d","If 10 d ≥ X > 5 d",1]
[null,null,null,"If 5 d ≥ X > 3 d","If 5 d ≥ X > 3 d",2]
[null,null,null,"If X ≤ 3 d","If X ≤ 3 d",3]
[null,null,null,"Not available","Not available",0]
[null,null,null,"Part not included","Part not included",3]

{"sheet":"C7_PRICE","index":14,"n_rows":143,"n_cols":21,"rows_kept":143,"cut":false,"hidden":false,"merged":[[26,14,28,14],[27,1,27,6],[28,1,28,6],[39,1,40,7],[33,1,33,12],[34,1,34,12],[35,1,35,12],[36,1,36,12],[37,1,37,12],[26,1,26,6],[26,8,28,8],[26,9,28,9],[26,10,28,10],[26,11,28,12],[26,13,28,13],[23,1,25,6],[23,7,23,10],[24,7,25,7],[24,8,25,8],[24,9,25,9],[24,10,25,10],[21,1,21,10],[0,1,1,11],[0,12,1,16],[3,13,19,18],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[9,1,9,11],[10,1,10,11],[11,1,11,11],[12,1,12,11],[13,1,13,11],[19,1,19,11],[14,1,14,11],[15,1,15,11],[16,1,16,11],[17,1,17,11],[18,1,18,11]]}
[null,"CRITERION 7 : PRICE OF SPARE PARTS",null,null,null,null,null,null,null,null,null,null,"Television"]
[]
[]
[null,"ADDITIONAL INFORMATIONS: ",null,null,null,null,null,null,null,null,null,null,null,"Reminder of regulatory provisions\n\"Sub-criterion 7.1. Ratio between the manufacturer's or importer's selling price for parts and the manufacturer's or importer's selling price for equipment.\nThe criterion is established by calculating the ratio between :\n[the pre-tax price of the most expensive part in list 2 + (average of the pre-tax prices of the other parts in list 2)]/2\nand the pre-tax price of the equipment model concerned,\nwhere each price is understood to be the price excluding tax in the price list in force at the time the index is calculated and appearing in the manufacturer's or importer's general terms and conditions of sale, or failing that in any relevant contractual document.\nWhere a manufacturer or importer has, for the parts or equipment in question, several price scales according to the different categories of distributor or seller customers, the prices used to calculate the index are those of the scale which represented the highest proportion of the manufacturer's or importer's sales for the type of part or type of equipment concerned, during the last financial year.\nWhere some of these parts are inseparable, or where the part in question is integrated into a module which is the only one available, the price to be taken into account is the combined price of the parts or the price of the module\"."]
[null,"Deduction of delivery costs: The principle adopted is to make a calculation excluding transport or delivery costs. If the latter are  "]
[null,"included in the tariffs of the general terms and conditions of sale, it is up to the producer or importer to deduct them in order to"]
[null," calculate the ratio. In particular for the price of spare parts, two methods are possible for deducting transport or delivery costs: "]
[null,"individually for each of the parts in list 2 or on a flat-rate basis (in absolute value or as a percentage). The same applies to the "]
[null,"price of new equipment.   "]
[null,"Spare part(s) forming part of a batch: If one or more of the parts in list 2 are part of a batch offered for sale or of any other subset of "]
[null,"inseparable parts, the price of the part concerned is the price of this batch or subset. "]
[null,"Part not available: In the event that, at the time the index is calculated, a part from list 2 is not available, the number of points "]
[null,"awarded for criterion 7 relating to the price of spare parts is 0.  "]
[null,"Parts not managed by the producer or importer: If parts from list 2 are not managed by the producer or importer, the price of the "]
[null,"parts to be considered is then that of the supplier's general terms and conditions of sale at the time of the index calculation. "]
[null,"Options for products with the same reference: If options are offered for the same reference, and do not influence the technical "]
[null,"characteristics for the purpose of calculating the index, then the calculation of the price ratio to be achieved is based on the "]
[null,"price of spare parts and the price of the most current version of the product concerned. "]
[null,"Absence of a part: If the equipment does not include a part listed in list 1 or 2 of the category concerned, then the price of the "]
[null,"absent part does not appear in the calculation of the ratio."]
[]
[null,{"$f":"IF(OR(P24=\"Select a choice\",Q24=\"Select a choice\",R24=\"Select a choice\",S24=\"Select a choice\",P25=\"Select a choice\",Q25=\"Select a choice\",R25=\"Select a choice\",S25=\"Select a choice\",S26=\"Select a choice\",R26=\"Select a choice\",P26=\"Select a choice\",Q26=\"Select a choice\",P27=\"Select a choice\",Q27=\"Select a choice\",R27=\"Select a choice\",S27=\"Select a choice\",P28=\"Select a choice\",Q28=\"Select a choice\",R28=\"Select a choice\",S28=\"Select a choice\"),\"Please fully complete criterion 6.1 before criterion 7\",\"\")","v":""}]
[]
[null,"PRICE Criterion",null,null,null,null,null,"RATING",null,null,null,null,null,null,null,{"$f":"'C6_AVAILABILITY_SP'!E24","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!G24","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!I24","v":"If X < 7 years"},{"$f":"'C6_AVAILABILITY_SP'!K24","v":"If X < 7 years"},null,{"$f":"IF(AND(P24=\"Non disponible\",Q24=\"Non disponible\",R24=\"Non disponible\",S24=\"Non disponible\"),0,\"dispo\")","v":"dispo"}]
[null,null,null,null,null,null,null,"Value                   (euros)","Score                                     (%)","POINTS                                                 (/100)","FINAL SCORE\n(/10)",null,null,null,null,{"$f":"'C6_AVAILABILITY_SP'!E25","v":0},{"$f":"'C6_AVAILABILITY_SP'!G25","v":0},{"$f":"'C6_AVAILABILITY_SP'!I25","v":0},{"$f":"'C6_AVAILABILITY_SP'!K25","v":0},null,"dispo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'C6_AVAILABILITY_SP'!E26","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!G26","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!I26","v":"If X < 7 years"},{"$f":"'C6_AVAILABILITY_SP'!K26","v":"If X < 7 years"},null,{"$f":"IF(AND(P26=\"Non disponible\",Q26=\"Non disponible\",R26=\"Non disponible\",S26=\"Non disponible\"),0,\"dispo\")","v":"dispo"}]
[null,"Pre-tax price of the most expensive spare part (list 2)",null,null,null,null,null,{"$f":"IF(OR(U24=0,U25=0,U26=0,U27=0,U28=0),0,\"Please fill out\")","v":"Please fill out"},{"$f":"IF(ISERROR((($H$27+($H$28))/2)/$H$29),\"0%\",((($H$27+($H$28))/B45)/$H$29))","v":"0%"},{"$f":"IF(N27<0,0,IF(N27>100,100,MROUND(N27,5)))","v":0},{"$f":"IF(N27/10<0,0,IF(N27/10>=10,10,MROUND(N27,5)/10))","v":0},{"$f":"IF(J27<0,\"NOTE DE ZERO                   CAR SCORE HORS BAREME DE NOTATION\")","v":false},null,{"$f":"IF(FORECAST($I$27,B43:B143,C43:C143)=150,0,FORECAST($I$27,B43:B143,C43:C143))","v":0},{"$f":"IF(N27/10<0,0,IF(N27/10>=10,10,N27/10 ))","v":0},{"$f":"'C6_AVAILABILITY_SP'!E27","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!G27","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!I27","v":"If X < 7 years"},{"$f":"'C6_AVAILABILITY_SP'!K27","v":"If X < 7 years"},null,{"$f":"IF(AND(P27=\"Non disponible\",Q27=\"Non disponible\",R27=\"Non disponible\",S27=\"Non disponible\"),0,\"dispo\")","v":"dispo"}]
[null,"Average pre-tax price of other spare parts (list 2)",null,null,null,null,null,{"$f":"IF(OR(U24=0,U25=0,U26=0,U27=0,U28=0),0,\"Please fill out\")","v":"Please fill out"},null,null,null,null,null,null,null,{"$f":"'C6_AVAILABILITY_SP'!E28","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!G28","v":"If X ≥ 11 years"},{"$f":"'C6_AVAILABILITY_SP'!I28","v":"If X < 7 years"},{"$f":"'C6_AVAILABILITY_SP'!K28","v":"If X < 7 years"},null,{"$f":"IF(AND(P28=\"Non disponible\",Q28=\"Non disponible\",R28=\"Non disponible\",S28=\"Non disponible\"),0,\"dispo\")","v":"dispo"}]
[null,"Manufacturer's pre-tax price of concerned model",null,null,null,null,null,{"$f":"IF(OR(U24=0,U25=0,U26=0,U27=0,U28=0),0,\"Please fill out\")","v":"Please fill out"}]
[]
[]
[]
[]
[null,"The number of points obtained for this criterion is determined as follows:"]
[null,"- if the result is greater than 0.3 then the number of points is 0;"]
[null,"- if the result is less than 0.1 then the number of points is 100;"]
[null,"- if the result is between 0.1 and 0.3 then the number of points is determined according to the following correspondence table :"]
[]
[]
[null,"DATA"]
[]
[null,"y","x","a","b","y '",null,"x ' "]
[null,0,{"$f":"$D$43*B43+$E$43","v":0.3},-2E-3,0.3,100,0,{"$f":"$D$43*F43+$E$43","v":9.9999999999999978E-2},{"$f":"IF($I$27>=H43,$I$27,IF($I$27<H43,-2.2))","v":"0%"},0.2]
[null,1,0.29799999999999999,-0.2,0.3,99,0,0.10199999999999998,{"$f":"IF($I$27>=H44,$I$27,IF($I$27<H44,-2.2))","v":"0%"},0.2]
[null,2,0.29599999999999999,-0.2,0.3,98,0,0.10399999999999998,"0%",0.2]
[null,3,0.29399999999999998,-0.2,0.3,97,0,0.10599999999999998,"0%",0.2]
[null,4,0.29199999999999998,-0.2,0.3,96,0,0.10799999999999998,"0%",0.2]
[null,5,0.28999999999999998,-0.2,0.3,95,0,0.10999999999999999,"0%",0.2]
[null,6,0.28799999999999998,-0.2,0.3,94,0,0.11199999999999999,"0%",0.2]
[null,7,0.28599999999999998,-0.2,0.3,93,0,0.11399999999999999,"0%",0.2]
[null,8,0.28399999999999997,-0.2,0.3,92,0,0.11599999999999999,"0%",0.2,null,null,null,null,null,null,null," "]
[null,9,0.28199999999999997,-0.2,0.3,91,0,0.11799999999999999,"0%",0.2]
[null,10,0.27999999999999997,-0.2,0.3,90,0,0.12,"0%",0.2]
[null,11,0.27799999999999997,-0.2,0.3,89,0,0.122,"0%",0.2]
[null,12,0.27599999999999997,-0.2,0.3,88,0,0.124,"0%",0.2]
[null,13,0.27399999999999997,-0.2,0.3,87,0,0.12599999999999997,"0%",0.2]
[null,14,0.27199999999999996,-0.2,0.3,86,0,0.12799999999999997,"0%",0.2]
[null,15,0.27,-0.2,0.3,85,0,0.12999999999999998,"0%",0.2]
[null,16,0.26800000000000002,-0.2,0.3,84,0,0.13199999999999998,"0%",0.2]
[null,17,0.26600000000000001,-0.2,0.3,83,0,0.13399999999999998,"0%",0.2]
[null,18,0.26400000000000001,-0.2,0.3,82,0,0.13599999999999998,"0%",0.2]
[null,19,0.26200000000000001,-0.2,0.3,81,0,0.13799999999999998,"0%",0.2]
[null,20,0.26,-0.2,0.3,80,0,0.13999999999999999,"0%",0.2]
[null,21,0.25800000000000001,-0.2,0.3,79,0,0.14199999999999999,"0%",0.2]
[null,22,0.25600000000000001,-0.2,0.3,78,0,0.14399999999999999,"0%",0.2]
[null,23,0.254,-0.2,0.3,77,0,0.14599999999999999,"0%",0.2]
[null,24,0.252,-0.2,0.3,76,0,0.14799999999999999,"0%",0.2]
[null,25,0.25,-0.2,0.3,75,0,0.15,"0%",0.2]
[null,26,0.248,-0.2,0.3,74,0,0.152,"0%",0.2]
[null,27,0.246,-0.2,0.3,73,0,0.154,"0%",0.2]
[null,28,0.24399999999999999,-0.2,0.3,72,0,0.15599999999999997,"0%",0.2]
[null,29,0.24199999999999999,-0.2,0.3,71,0,0.15799999999999997,"0%",0.2]
[null,30,0.24,-0.2,0.3,70,0,0.15999999999999998,"0%",0.2]
[null,31,0.23799999999999999,-0.2,0.3,69,0,0.16199999999999998,"0%",0.2]
[null,32,0.23599999999999999,-0.2,0.3,68,0,0.16399999999999998,"0%",0.2]
[null,33,0.23399999999999999,-0.2,0.3,67,0,0.16599999999999998,"0%",0.2]
[null,34,0.23199999999999998,-0.2,0.3,66,0,0.16799999999999998,"0%",0.2]
[null,35,0.22999999999999998,-0.2,0.3,65,0,0.16999999999999998,"0%",0.2]
[null,36,0.22799999999999998,-0.2,0.3,64,0,0.17199999999999999,"0%",0.2]
[null,37,0.22599999999999998,-0.2,0.3,63,0,0.17399999999999999,"0%",0.2]
[null,38,0.22399999999999998,-0.2,0.3,62,0,0.17599999999999999,"0%",0.2]
[null,39,0.22199999999999998,-0.2,0.3,61,0,0.17799999999999999,"0%",0.2]
[null,40,0.21999999999999997,-0.2,0.3,60,0,0.18,"0%",0.2]
[null,41,0.21799999999999997,-0.2,0.3,59,0,0.182,"0%",0.2]
[null,42,0.21599999999999997,-0.2,0.3,58,0,0.184,"0%",0.2]
[null,43,0.21399999999999997,-0.2,0.3,57,0,0.186,"0%",0.2]
[null,44,0.21199999999999999,-0.2,0.3,56,0,0.188,"0%",0.2]
[null,45,0.21,-0.2,0.3,55,0,0.19,"0%",0.2]
[null,46,0.20799999999999999,-0.2,0.3,54,0,0.192,"0%",0.2]
[null,47,0.20599999999999999,-0.2,0.3,53,0,0.19400000000000001,"0%",0.2]
[null,48,0.20399999999999999,-0.2,0.3,52,0,0.19599999999999998,"0%",0.2]
[null,49,0.20199999999999999,-0.2,0.3,51,0,0.19799999999999998,"0%",0.2]
[null,50,0.19999999999999998,-0.2,0.3,50,0.2,0.19999999999999998,"0%",0.2]
[null,51,0.19799999999999998,-0.2,0.3,49,0.2,0.20199999999999999,{"$f":"IF($I$27>=H94,$I$27,IF($I$27<H94,-2.2))","v":"0%"},-2.2000000000000002]
[null,52,0.19599999999999998,-0.2,0.3,48,0.2,0.20399999999999999,"0%",-2.2000000000000002]
[null,53,0.19400000000000001,-0.2,0.3,47,0.2,0.20599999999999999,"0%",-2.2000000000000002]
[null,54,0.192,-0.2,0.3,46,0.2,0.20799999999999999,"0%",-2.2000000000000002]
[null,55,0.19,-0.2,0.3,45,0.2,0.21,"0%",-2.2000000000000002]
[null,56,0.188,-0.2,0.3,44,0.2,0.21199999999999999,"0%",-2.2000000000000002]
[null,57,0.186,-0.2,0.3,43,0.2,0.21399999999999997,"0%",-2.2000000000000002]
[null,58,0.184,-0.2,0.3,42,0.2,0.21599999999999997,"0%",-2.2000000000000002]
[null,59,0.182,-0.2,0.3,41,0.2,0.21799999999999997,"0%",-2.2000000000000002]
[null,60,0.18,-0.2,0.3,40,0.2,0.21999999999999997,"0%",-2.2000000000000002]
[null,61,0.17799999999999999,-0.2,0.3,39,0.2,0.22199999999999998,"0%",-2.2000000000000002]
[null,62,0.17599999999999999,-0.2,0.3,38,0.2,0.22399999999999998,{"$f":"IF($I$27>=H105,$I$27,IF($I$27<H105,-2.2))","v":"0%"},-2.2000000000000002]
[null,63,0.17399999999999999,-0.2,0.3,37,0.2,0.22599999999999998,"0%",-2.2000000000000002]
[null,64,{"$f":"$D$43*B107+$E$43","v":0.17199999999999999},-0.2,0.3,36,0.2,{"$f":"$D$43*F107+$E$43","v":0.22799999999999998},"0%",-2.2000000000000002]
[null,65,0.16999999999999998,-0.2,0.3,35,0.2,0.22999999999999998,{"$f":"IF($I$27>=H108,$I$27,IF($I$27<H108,-2.2))","v":"0%"},-2.2000000000000002]
[null,66,0.16799999999999998,-0.2,0.3,34,0.2,0.23199999999999998,"0%",-2.2000000000000002]
[null,67,0.16599999999999998,-0.2,0.3,33,0.2,0.23399999999999999,"0%",-2.2000000000000002]
[null,68,0.16399999999999998,-0.2,0.3,32,0.2,0.23599999999999999,"0%",-2.2000000000000002]
[null,69,0.16199999999999998,-0.2,0.3,31,0.2,0.23799999999999999,"0%",-2.2000000000000002]
[null,70,0.15999999999999998,-0.2,0.3,30,0.2,0.24,"0%",-2.2000000000000002]
[null,71,0.15799999999999997,-0.2,0.3,29,0.2,0.24199999999999999,"0%",-2.2000000000000002]
[null,72,0.15599999999999997,-0.2,0.3,28,0.2,0.24399999999999999,"0%",-2.2000000000000002]
[null,73,0.154,-0.2,0.3,27,0.2,0.246,"0%",-2.2000000000000002]
[null,74,0.152,-0.2,0.3,26,0.2,0.248,"0%",-2.2000000000000002]
[null,75,0.15,-0.2,0.3,25,0.2,0.25,"0%",-2.2000000000000002]
[null,76,0.14799999999999999,-0.2,0.3,24,0.2,0.252,"0%",-2.2000000000000002]
[null,77,0.14599999999999999,-0.2,0.3,23,0.2,0.254,"0%",-2.2000000000000002]
[null,78,0.14399999999999999,-0.2,0.3,22,0.2,0.25600000000000001,"0%",-2.2000000000000002]
[null,79,0.14199999999999999,-0.2,0.3,21,0.2,0.25800000000000001,"0%",-2.2000000000000002]
[null,80,0.13999999999999999,-0.2,0.3,20,0.2,0.26,"0%",-2.2000000000000002]
[null,81,0.13799999999999998,-0.2,0.3,19,0.2,0.26200000000000001,"0%",-2.2000000000000002]
[null,82,0.13599999999999998,-0.2,0.3,18,0.2,0.26400000000000001,"0%",-2.2000000000000002]
[null,83,0.13399999999999998,-0.2,0.3,17,0.2,0.26600000000000001,"0%",-2.2000000000000002]
[null,84,0.13199999999999998,-0.2,0.3,16,0.2,0.26800000000000002,"0%",-2.2000000000000002]
[null,85,0.12999999999999998,-0.2,0.3,15,0.2,0.27,"0%",-2.2000000000000002]
[null,86,0.12799999999999997,-0.2,0.3,14,0.2,0.27199999999999996,"0%",-2.2000000000000002]
[null,87,0.12599999999999997,-0.2,0.3,13,0.2,0.27399999999999997,"0%",-2.2000000000000002]
[null,88,0.124,-0.2,0.3,12,0.2,0.27599999999999997,"0%",-2.2000000000000002]
[null,89,0.122,-0.2,0.3,11,0.2,0.27799999999999997,"0%",-2.2000000000000002]
[null,90,0.12,-0.2,0.3,10,0.2,0.27999999999999997,"0%",-2.2000000000000002]
[null,91,0.11799999999999999,-0.2,0.3,9,0.2,0.28199999999999997,"0%",-2.2000000000000002]
[null,92,0.11599999999999999,-0.2,0.3,8,0.2,0.28399999999999997,"0%",-2.2000000000000002]
[null,93,0.11399999999999999,-0.2,0.3,7,0.2,0.28599999999999998,"0%",-2.2000000000000002]
[null,94,0.11199999999999999,-0.2,0.3,6,0.2,0.28799999999999998,"0%",-2.2000000000000002]
[null,95,0.10999999999999999,-0.2,0.3,5,0.2,0.28999999999999998,"0%",-2.2000000000000002]
[null,96,{"$f":"$D$43*B139+$E$43","v":0.10799999999999998},-0.2,0.3,4,0.2,0.29199999999999998,"0%",-2.2000000000000002]
[null,97,{"$f":"$D$43*B140+$E$43","v":0.10599999999999998},-0.2,0.3,3,0.2,0.29399999999999998,"0%",-2.2000000000000002]
[null,98,{"$f":"$D$43*B141+$E$43","v":0.10399999999999998},-0.2,0.3,2,0.2,0.29599999999999999,"0%",-2.2000000000000002]
[null,99,{"$f":"$D$43*B142+$E$43","v":0.10199999999999998},-0.2,0.3,1,0.2,0.29799999999999999,"0%",-2.2000000000000002]
[null,100,{"$f":"$D$43*B143+$E$43","v":9.9999999999999978E-2},-0.2,0.3,0,0.2,0.3,"0%",-2.2000000000000002]

{"sheet":"FINAL_SCORE","index":15,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,1,5],[0,6,1,9],[5,2,5,3],[5,4,5,9],[3,2,3,9],[7,2,7,3],[7,4,7,9],[8,2,8,3],[8,4,8,9],[6,2,6,3],[6,4,6,9],[13,2,17,2],[13,3,17,5],[13,6,17,6],[13,7,17,7],[13,8,17,8],[18,2,19,2],[18,3,18,5],[18,8,19,8],[19,1,23,1],[19,3,19,5],[20,2,21,2],[20,3,20,5],[20,8,21,8],[21,3,21,5],[22,2,23,2],[22,3,22,5],[22,8,23,8],[23,3,23,5],[24,2,24,7],[25,1,34,1],[25,2,26,2],[25,3,25,5],[25,8,26,8],[26,3,26,5],[27,2,29,2],[27,3,27,5],[27,8,29,8],[28,3,28,5],[29,3,29,5],[30,2,33,2],[30,3,30,5],[30,8,33,8],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,2,35,7],[36,2,37,7],[36,8,37,8]]}
[null,null,"DURABILITY INDEX CALCULATION AND PRESENTATION OF \nTHE PARAMETERS WHICH ALLOWED TO ESTABLISH IT",null,null,null,"Television"]
[]
[]
[null,null,"This \"FINAL_SCORE\" tab in English is purely indicative. In order to meet regulatory obligations, only the \"NOTE_FINALE\" tab in French \n(see the next tab) is to be sent. Note: The results are automatically reported in the French tab."]
[]
[null,null,"Date of calculation",null,{"$f":"PRODUCT_INFORMATION!D6","v":"2025-04-09"}]
[null,null,"Producer's or importer's name or trademark",null,{"$f":"PRODUCT_INFORMATION!D18","v":"Sony France, succursale de Sony. Europe B.V."}]
[null,null,"Producer or importer adress",null,{"$f":"PRODUCT_INFORMATION!D19","v":"Located at 49/51, quai de Dion Bouton, 92800 Puteaux, France "}]
[null,null,"Producer's or importer's model identifier",null,{"$f":"PRODUCT_INFORMATION!D20","v":"K-43S3"}]
[]
[]
[]
[]
[null,null,"Criteria","Sub-criteria",null,null,"Score of subcriterion       /10","Weighting factor of subcriterion","Intermediate calculation"]
[]
[]
[]
[]
[null,null,"CRITERION 1: RESISTANCE TO STRESS AND/OR WEAR","1.1 Resistance to external stress",null,null,{"$f":"'C1_RESISTANCE'!H13","v":10},0.05,{"$f":"G19*H19+G20*H20","v":3.4250000000000003}]
[null,"Reliability",null,"1.2 Wear resistance",null,null,{"$f":"'C1_RESISTANCE'!H29","v":6.5},0.45]
[null,null,"CRITERION 2: MAINTENANCE AND SERVICING","2.1 Maintenance (including software)",null,null,{"$f":"'C2_MAINTENANCE_SERVICING'!H16","v":10},0.24,{"$f":"G21*H21+G22*H22","v":3.2}]
[null,null,null,"2.2 Servicing",null,null,{"$f":"'C2_MAINTENANCE_SERVICING'!L35","v":5},0.16000000000000003]
[null,null,"CRITERION 3: GUARANTEE AND CONTINUOUS IMPROVEMENT","3.1 Commercial guarantee of durability",null,null,{"$f":"'C3_GUARANTEE'!H13","v":0},7.5000000000000011E-2,{"$f":"G23*H23+G24*H24","v":0.25}]
[null,null,null,"3.2 Implementation of a continuous improvement process",null,null,{"$f":"'C3_GUARANTEE'!H28","v":10},2.5000000000000001E-2]
[null,null,"Reliability grade out of 10",null,null,null,null,null,{"$f":"SUM(I19:I24)","v":6.875}]
[null,"Reparability","CRITERION 4 : DOCUMENTATION","4.1 Commitment on the availability over time (without charge) of the technical documentation and the other documentation related to user and maintenance instructions",null,null,{"$f":"'C4_DOCUMENTATION'!I41","v":10},0.2,{"$f":"G26*H26+G27*H27","v":2.5}]
[null,null,null,"4.2 Consumer support for diagnosis and repair",null,null,{"$f":"'C4_DOCUMENTATION'!H65","v":10},0.05]
[null,null,"CRITERION 5 : DISASSEMBLY, ACCESSIBILITY, TOOLS, FASTENERS","5.1 Ease of disassembly parts from List 2*",null,null,{"$f":"'C5_DISASSEMBLY'!F26","v":10},0.13,{"$f":"G28*H28+G29*H29+G30*H30","v":2.4727272727272727}]
[null,null,null,"5.2 Necessary tools (List 2)",null,null,{"$f":"'C5_DISASSEMBLY'!F47","v":10},0.06]
[null,null,null,"5.3 Fasteners characteristics parts from List 1** and List 2",null,null,{"$f":"'C5_DISASSEMBLY'!F79","v":9.545454545454545},0.06]
[null,null,"CRITERION 6 : AVAILABILITY OF SPARE PARTS","6.1 Availability over time parts from List 2",null,null,{"$f":"'C6_AVAILABILITY_SP'!M30","v":5},0.13,{"$f":"G31*H31+G32*H32+G33*H33+G34*H34","v":1.3142857142857143}]
[null,null,null,"6.2 Availability over time parts from List 1",null,null,{"$f":"'C6_AVAILABILITY_SP'!M47","v":5.7142857142857144},0.06]
[null,null,null,"6.3 Delivery time parts from List 2 ",null,null,{"$f":"'C6_AVAILABILITY_SP'!M62","v":5},0.03]
[null,null,null,"6.4 Delivery time parts from List 1",null,null,{"$f":"'C6_AVAILABILITY_SP'!M79","v":5.7142857142857144},0.03]
[null,null,"CRITERION 7 : PRICE OF SPARE PARTS","7. Ratio between price of parts from list 2 to the price of the product",null,null,{"$f":"'C7_PRICE'!K27","v":0},0.25,{"$f":"G35*H35","v":0}]
[null,null,"Reparability grade out of 10",null,null,null,null,null,{"$f":"SUM(I26:I35)","v":6.2870129870129867}]
[null,null,"Index score out of 10",null,null,null,null,null,{"$f":"(I25+I36)/2","v":6.5810064935064929}]

{"sheet":"NOTE_FINALE","index":16,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,2,9,9],[0,2,1,6],[0,7,1,9],[7,2,7,3],[7,4,7,9],[8,2,8,3],[8,4,8,9],[3,2,3,9],[5,2,5,3],[5,4,5,9],[6,2,6,3],[6,4,6,9],[10,2,14,2],[10,3,14,5],[10,6,14,6],[10,7,14,7],[10,8,14,8],[15,1,20,1],[15,2,16,2],[15,3,15,5],[15,8,16,8],[16,3,16,5],[17,3,17,5],[17,8,18,8],[18,3,18,5],[19,3,19,5],[19,8,20,8],[20,3,20,5],[19,2,20,2],[17,2,18,2],[21,2,21,7],[22,1,31,1],[22,2,23,2],[22,3,22,5],[22,8,23,8],[23,3,23,5],[24,3,24,5],[24,8,26,8],[25,3,25,5],[26,3,26,5],[27,3,27,5],[27,8,30,8],[28,3,28,5],[29,3,29,5],[30,3,30,5],[31,3,31,5],[24,2,26,2],[27,2,30,2],[32,2,32,7],[33,2,34,7],[33,8,34,8]]}
[null,null,"CALCUL DE L'INDICE DE DURABILITÉ ET \nPRÉSENTATION DES PARAMÈTRES AYANT PERMIS DE L'ÉTABLIR",null,null,null,null,"Téléviseur"]
[]
[]
[null,null,"FICHE D'INFORMATION À TRANSMETTRE AUX DEMANDEURS "]
[]
[null,null,"Date du calcul",null,{"$f":"PRODUCT_INFORMATION!D6","v":"2025-04-09"}]
[null,null,"Nom ou marque commerciale du fournisseur",null,{"$f":"PRODUCT_INFORMATION!D18","v":"Sony France, succursale de Sony. Europe B.V."}]
[null,null,"Adresse du fournisseur",null,{"$f":"PRODUCT_INFORMATION!D19","v":"Located at 49/51, quai de Dion Bouton, 92800 Puteaux, France "}]
[null,null,"Référence du modèle donnée par le fournisseur",null,{"$f":"PRODUCT_INFORMATION!D20","v":"K-43S3"}]
[]
[null,null,"Critère","Sous-critère",null,null,"Note du sous-critère sur 10","Coefficient du sous critère","Calcul intermediaire"]
[]
[]
[]
[]
[null,"Fiabilité","CRITÈRE 1 : RÉSISTANCE AUX CONTRAINTES ET/OU À L'USURE","SOUS-CRITÈRE 1.1 : RÉSISTANCE AUX CONTRAINTES EXTERIEUR",null,null,{"$f":"'C1_RESISTANCE'!H13","v":10},0.05,{"$f":"G16*H16+G17*H17","v":3.4250000000000003}]
[null,null,null,"SOUS-CRITÈRE 1.2 : RESSISTANCE A L'USURE",null,null,{"$f":"'C1_RESISTANCE'!H29","v":6.5},0.45]
[null,null,"CRITÈRE 2 : MAINTENANCE (Y COMPRIS LOGICIELLE) & ENTRETIEN","SOUS-CRITÈRE 2.1 : MAINTENANCE (Y COMPRIS LOGICIELLE)",null,null,{"$f":"'C2_MAINTENANCE_SERVICING'!H16","v":10},0.24,{"$f":"G18*H18+G19*H19","v":3.2}]
[null,null,null,"SOUS-CRITÈRE 2.2 : ENTRETIEN",null,null,{"$f":"'C2_MAINTENANCE_SERVICING'!L35","v":5},0.16000000000000003]
[null,null,"CRITÈRE 3 : GARANTIE ET PROCESSUS QUALITE","SOUS-CRITÈRE 3.1 : GARANTIE COMMERCIALE DE DURABILITÉ",null,null,{"$f":"'C3_GUARANTEE'!H13","v":0},7.5000000000000011E-2,{"$f":"G20*H20+G21*H21","v":0.25}]
[null,null,null,"SOUS-CRITÈRE 3.2 : MISE EN PLACE D'UN PROCESSUS DE QUALITE",null,null,{"$f":"'C3_GUARANTEE'!H28","v":10},2.5000000000000001E-2]
[null,null,"Note du bloc fiabilité sur 10",null,null,null,null,null,{"$f":"SUM(I16:I21)","v":6.875}]
[null,"Réparabilité","CRITÈRE 4 : DOCUMENTATION","SOUS-CRITÈRE 4.1 : ENGAGEMENT SUR LA DURÉE DE MISE À DISPOSITION SANS FRAIS DE LA DOCUMENTATION TECHNIQUE ET RELATIVE AUX CONSEILS D'UTILISATION ET D'ENTRETIEN",null,null,{"$f":"'C4_DOCUMENTATION'!I41","v":10},0.2,{"$f":"G23*H23+G24*H24","v":2.5}]
[null,null,null,"SOUS-CRITÈRE 4.2 : ACCOMPAGNEMENT DU CONSOMMATEUR POUR LE DIAGNOSTIC ET LA RÉPARATION",null,null,{"$f":"'C4_DOCUMENTATION'!H65","v":10},0.05]
[null,null,"CRITÈRE 5 : DÉMONTABILITÉ, ACCÈS, OUTILS, FIXATIONS","SOUS-CRITÈRE 5.1 : FACILITÉ DE DÉMONTAGE DES PIÈCES DÉTACHÉES - PIÈCES PANNE/CASSE (LISTE 2)",null,null,{"$f":"'C5_DISASSEMBLY'!F26","v":10},0.13,{"$f":"G25*H25+G26*H26+G27*H27","v":2.4727272727272727}]
[null,null,null,"SOUS-CRITÈRE 5.2 : OUTILS NÉCESSAIRES AU DÉMONTAGE DES PIÈCES DÉTACHÉES - PIÈCES PANNE/CASSE (LISTE 2)",null,null,{"$f":"'C5_DISASSEMBLY'!F47","v":10},0.06]
[null,null,null,"SOUS-CRITÈRE 5.3 : CARACTÉRISTIQUES DES FIXATIONS POUR L'ASSEMBLAGE DES PIÈCES DES LISTES 1 ET 2",null,null,{"$f":"'C5_DISASSEMBLY'!F79","v":9.545454545454545},0.06]
[null,null,"CRITÈRE 6 : DISPONIBILITÉ DES PIÈCES DÉTACHÉES","SOUS-CRITÈRE 6.1 : ENGAGEMENT SUR LA DURÉE DE DISPONIBILITÉ DES PIÈCES DÉTACHÉES - PIÈCES PANNE / CASSE (LISTE 2)",null,null,{"$f":"'C6_AVAILABILITY_SP'!M30","v":5},0.13,{"$f":"G28*H28+G29*H29+G30*H30+G31*H31","v":1.3142857142857143}]
[null,null,null,"SOUS-CRITÈRE 6.2 : ENGAGEMENT SUR LA DURÉE DE DISPONIBILITÉ DES PIÈCES DÉTACHÉES - PIÈCES FONCTIONNELLES (LISTE 1)",null,null,{"$f":"'C6_AVAILABILITY_SP'!M47","v":5.7142857142857144},0.06]
[null,null,null,"SOUS-CRITÈRE 6.3 : ENGAGEMENT SUR LES DÉLAIS DE LIVRAISON DES PIÈCES DÉTACHÉES - PIÈCES PANNE / CASSE (LISTE 2)",null,null,{"$f":"'C6_AVAILABILITY_SP'!M62","v":5},0.03]
[null,null,null,"SOUS-CRITÈRE 6.4 : ENGAGEMENT SUR LES DÉLAIS DE LIVRAISON DES PIÈCES DÉTACHÉES - PIÈCES FONCTIONNELLES (LISTE 1)",null,null,{"$f":"'C6_AVAILABILITY_SP'!M79","v":5.7142857142857144},0.03]
[null,null,"CRITÈRE 7: PRIX","SOUS-CRITÈRE 7.1 : PRIX",null,null,{"$f":"'C7_PRICE'!K27","v":0},0.25,{"$f":"G32*H32","v":0}]
[null,null,"Note du bloc réparabilité sur 10",null,null,null,null,null,{"$f":"SUM(I23:I32)","v":6.2870129870129867}]
[null,null,"Note de l'indice sur 10      ",null,null,null,null,null,{"$f":"(I22+I33)/2","v":6.5810064935064929}]

{"sheet":"ANNEX_1","index":17,"n_rows":89,"n_cols":4,"rows_kept":89,"cut":false,"hidden":false,"merged":[[3,6,3,9],[4,1,4,3],[6,3,8,3],[9,3,12,3],[15,3,16,3],[3,1,3,3]]}
[null,"ANNEX 1 : TERMINOLOGY USED FOR THE REPARABILITY INDEX"]
[]
[]
[null,"The definitions of the following terms are specified in the decree relating to the repairability index for electrical and electronic equipment: "]
[null,"\"Making available onthe market\", \"Placing on the market\", \"producer\", \"importer\", \"distributor\", \"Seller\", \"distance selling\", \"model\"."]
[]
[null,"Authorized repairer","The authorized repairer is often referred to as a technical station or authorized service center. It is a professional repairer for whom one or more contracts precisely define the relationship between the authorized repairer and the producer(s).","Based on the technical expertise of the repairability index working groups"]
[null,"Independent repairer","Independent repairers are repairers in the sense of \"professional craftsmen repairers\" designating repair companies listed in the trade directory with an APE or NAFA code. They are professional repairers who do not fall into the category of authorized repairers. For example, 95.11 Z-Z: Repair of computers and peripheral equipment; 95.21 Z-Z: Repair of televisions, radio receivers, VCRs, CD and DVD players, camcorders for domestic use; 95.22 Z-Z: Repair of household appliances and home and garden equipment."]
[null,"Professional repairer","Authorized repairer or independent repairer.  "]
[null,"Distributor of spare parts","Any moral or physica person in the supply chain, other than the producer or importer, who offers a spare part for sale. They are commonly referred to as \"spare parts wholesalers\".","According to Standard NF EN 45554 \"General methods for the evaluation of the repair, reuse and improvement capacity of energy-related products\", 2020."]
[null,"Disassembly","The process by which a product, spare part or fastener is disassembled so that it can then be reassembled and made operational."]
[null,"Reassembly","The process by which a product, a spare part or a fastener is reassembled so as to fulfill its functional role and be made operational."]
[null,"Reuse / Reusable","The process by which a product, spare part or fastener, having reached the end of its first use, is used for the same purpose for which it was designed. Reuse after a second or subsequent use(s) is also considered to be reuse."]
[null,"Factory Restoration","A specific functionality or setting to be activated by the customer, if the product allows it, to restore the default value of a specific functionality of the device as set at the factory and available when the customer first uses the product.","Inspired by the Commission regulation (EU) 2019/2021"]
[null,"Update / Upgrade","The process of improving the functionality, performance, capacity or aesthetics of a product. This process may involve changes to the software, firmware and/or a hardware component of the product.","According to Standard NF EN 45554 \"General methods for the evaluation of the repair, reuse and improvement capacity of energy-related products\", 2020."]
[null,"Corrective update","An update performed after a failure has been detected and intended to restore an asset or software to a state in which it can perform a required function. This type of update corrects hardware or software malfunctions or non-conformity but does not add new functionality.","Inspired by the AFNOR NF EN 13306 X 60-319 standard of June 2011 \"All the technical, administrative and management actions during the life cycle of an asset, intended to maintain or restore it to a state in which it can perform the required function \""]
[null,"Evolutionary update","Upgrading, which consists of gradually modifying the software application by adding new features or additional modules, or by replacing an existing function with another, or even by proposing a different approach."]
[null,"Fastener","A hardware device that mechanically or magnetically connects or fixes two or more objects, parts or pieces. A fastener is generally non-permanent, i.e., it can be easily removed or disassembled without damaging the objects, parts or pieces connected or fixed together (e.g., screws or clips). Welds and some glues are in contrast to permanent fixings. Adhesives are considered non-reusable fasteners unless new ones are supplied with the spare part.","Inspired by, \"Fasteners - Their Needs and Types\", Bright Hub Engineering, 2020."]
[null,"Reusable fastener ","See the definition of \"reusable\".","According to Standard NF EN 45554 \"General methods for the evaluation of the repair, reuse and improvement capacity of energy-related products\", 2020."]
[null,"Removable fastener","An original fastener system that can be completely removed (without causing damage or leaving residue)."]
[null,"Proprietary tool","A tool that is not commercially available and is owned exclusively by one party or company, and under which its use by another party (an end user or customer) involves copyright, license and/or cost.","Inspired by Will Kenton, \"Proprietary Technology\", 2019."]
[null,"Part / Spare parts","A unitary element in the composition of the equipment."]
[]
[]
[null,"VOCABULAIRE EUROPEEN"]
[]
[null,"Eco-conception des Televisions ","Ecodesign of Televisions"]
[null,"RÈGLEMENT (UE) 2019/2023 DE LA COMMISSION  du 1er octobre 2019 établissant des exigences en matière d’écoconception applicables aux Television ménagers et aux Television séchants ménagers conformément à la directive 2009/125/CE du Parlement européen et du Conseil, modifiant le règlement (CE) no 1275/2008 de la Commission et abrogeant le règlement (UE) no 1015/2010 de la Commission.","COMMISSION REGULATION (EU) 2019/2021\nOf 1 October 2019 laying down ecodesign requirements for electronic displays pursuant to Directive 2009/125/EC of the European Parliament and of the Council, amending Commission Regulation (EC) No 1275/2008 and repealing Commission Regulation (EC) No 642/2009\n"]
[]
[null,"Liste des informations à fournir (documentation)"]
[]
[null,"→  Les informations de réparation et d’entretien du Television ménager ou du Television séchant ménager mentionnées au point a) comprennent :"," → the household Television or household washer-dryer repair and maintenance information referred to in (a) shall include :"]
[]
[null,"une identification sans équivoque du Television ménager ou du Television séchant ménager","the unequivocal household Television or household washer-dryer identification"]
[null,"un schéma de démontage ou une vue éclatée","a disassembly map or exploded view"]
[null,"un manuel technique d’instructions relatives à la réparation","technical manual of instructions for repair"]
[null,"une liste du matériel de réparation et de test nécessaire","list of necessary repair and test equipment"]
[null,"les informations concernant les composants et le diagnosis (telles que les valeurs théoriques minimales et maximales pour les mesures)","component and diagnosis information (such as minimum and maximum theoretical values for measurements)"]
[null,"des schémas de câblage et de raccordement","wiring and connection diagrams"]
[null,"les codes d’erreur et de diagnosis (y compris les codes spécifiques au fabricant, le cas échéant)","diagnosis fault and error codes (including manufacturer-specific codes, where applicable)"]
[null,"les instructions pour l’installation des logiciels et micrologiciels pertinents, y compris les logiciels de réinitialisation","instructions for installation of relevant software and firmware including reset software"]
[null,"les informations sur les modalités d’accès aux données relatives aux incidents de défaillance signalés enregistrées dans le Television ménager ou le Television séchant ménager (le cas échéant)","information on how to access data records of reported failure incidents stored on the household Television or washer-dryer (where applicable)"]
[]
[null,"Liste des pièces détachées à mettre à disposition"]
[]
[null,"Moteur et balais de moteur","Motor and motor brushes"]
[null,"Transmission entre moteur et tambour","Transmission between motor and drum"]
[null,"Pompes","Pumps"]
[null,"Amortisseurs et ressorts","Shock absorbers and springs"]
[null,"Tambour de lavage, croisillon de tambour et roulements correspondants (séparément ou en lot)","Washing drum, drum spider and related ball bearings (separately or bundled)"]
[null,"Générateurs de chaleurs et éléments chauffants, y compris les pompes à chaleur, (séparément ou groupés)","Heaters and heating elements, including heat pumps (separately or bundled)"]
[null,"Conduites et matériel connexe y compris l’ensemble des flexibles, vannes, filtres et systèmes aquastop (séparé­ment ou groupés)","Piping and related equipment including all hoses, valves, filters and aquastops (separately or bundled)"]
[null,"Cartes de circuit imprimé","Printed circuit boards"]
[null,"Affichages électroniques","Electronic displays"]
[null,"Manocontacts","Pressure switches"]
[null,"Thermostats et capteurs","Thermostats and sensors"]
[null,"Logiciels et micrologiciels, y compris logiciels de réinitialisation","Software and firmware including reset software"]
[null,"Portes","Door"]
[null,"Charnières et joints de porte","Door hinge and seals"]
[null,"Autres joints","Other seals"]
[null,"Assemblage de verrouillage de la porte","Door locking assembly"]
[null,"Accessoires en matière plastique tels que distributeurs de détergent","Plastic peripherals such as detergent dispensers"]
[null," "]
[]
[null,"Eco-conception des dispositifs d’affichage","Ecodesign of electronic displays"]
[null,"REGLEMENT (UE) 2019/2021 DE LA COMMISSION  du 1er octobre 2019 fixant les exigences en matière d’écoconception pour les dispositifs d’affichage électronique conformément à la directive 2019/125/CE du Parlement européen et du Conseil modifiant le règlement (CE) n°642/2009 de la Commission.","COMMISSION REGULATION (EU) 2019/2021 of 1 October 2019 laying down ecodesign requirements for electronic displays pursuant to Directive 2009/125/EC of the European Parliament and of the Council, amending Commission Regulation (EC) No 1275/2008 and repealing Commission Regulation (EC) No 642/2009"]
[]
[null,"Liste des informations à fournir (documentation) - List of required informations for the consumer"]
[]
[null,"→  Les informations disponibles sur la réparation et la maintenance comprennent :"," → The available repair and maintenance information shall include:"]
[]
[null,"une identification sans équivoque du Television ménager ou du Television séchant ménager","the unequivocal appliance identification"]
[null,"un schéma de démontage ou une vue éclatée","a disassembly map or exploded view"]
[null,"une liste du matériel de réparation et de test nécessaire","list of necessary repair and test equipment"]
[null,"les informations concernant les composants et le diagnosis (telles que les valeurs théoriques minimales et maximales pour les mesures)","component and diagnosis information (such as minimum and maximum theoretical values for measurements)"]
[null,"des schémas de câblage et de raccordement","wiring and connection diagrams"]
[null,"les codes d’erreur et de diagnosis (y compris les codes spécifiques au fabricant, le cas échéant)","diagnosis fault and error codes (including manufacturer-specific codes, where applicable)"]
[null,"les informations sur les modalités d’accès aux données relatives aux incidents de défaillance signalés enregistrées dans le Television ménager ou le Television séchant ménager (le cas échéant)","information on how to access data records of reported failure incidents stored on the household Television or washer-dryer (where applicable)"]
[]
[null,"Liste des pièces détachées à mettre à disposition – List of spare parts to be made available"]
[]
[null,"Les sources d’alimentation internes","Internal power supply"]
[null,"Les sources d’alimentation externes","External power supply"]
[null,"Les connecteurs pour connecter les équipements externes (câble, antenne, USB, DVD et Blue-Ray)","Connectors to connect external equipment (cable, antenna, usb, dvd and blue-ray)"]
[null,"Les condensateurs","Capacitors"]
[null,"Les piles et accumulateurs","Batteries and accumulators"]
[null,"Les modules DVD/Blue-Ray le cas échéant","DVD/Blue-Ray module"]
[null,"Les modules HD/SSD","HD/SSD module"]
[null,"La télécommande","Remote control"]

{"sheet":"ANNEX_2","index":18,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,1,3],[5,1,6,1],[5,3,6,3],[2,1,3,3]]}
[null,"ANNEX 2 : BASIC TOOLS AND THEIR REFERENCE STANDARDS"]
[]
[null,"According to the European Standard NF EN 45554 \"General methods for the assessment of the ability to repair, reuse and upgrade energy-related products\", 2020."]
[]
[]
[null,"Tool type","Illustration","Reference"]
[null,null,"(informative example)"]
[null,"Screwdriver for slotted heads, cross recess or for hexalobular recess heads",null,"ISO 2380, ISO 8764, ISO 10664"]
[null,"Hexagon socket key ",null,"ISO 2936"]
[null,"Combination wrench",null,"ISO 7738"]
[null,"Combination pliers",null,"ISO 5746"]
[null,"Half round nose pliers",null,"ISO 5745"]
[null,"Diagonal cutters",null,"ISO 5749"]
[null,"Multigrip pliers (multiple slip joint pliers)",null,"ISO 8976"]
[null,"Locking pliers"]
[null,"Combination pliers for wire stripping and terminal crimping"]
[null,"Prying lever"]
[null,"Tweezers"]
[null,"Hammer, steel head",null,"ISO 15601"]
[null,"Utility knife (cutter) with snap-off blades"]
[null,"Multimeter"]
[null,"Voltage tester"]
[null,"Soldering iron"]
[null,"Hot glue gun"]
[null,"Magnifying glass"]

{"sheet":"ANNEX_3","index":19,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,1,11]]}
[null,"ANNEX 3 : DETAILS ABOUT THE CONCEPT OF DISASSEMBLY STEP AND APPLICATION CASE"]