{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["INSTRUCTIONS","C1_DOCUMENTATION","C2_DISASSEMBLY","C3_AVAILABILITY_SP","C4_PRICE","C5_SPECIFIC","FINAL_SCORE","NOTE_FINALE","ANNEX_1","ANNEX_2","ANNEX_3"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":15,"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":"INSTRUCTIONS","index":0,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,1,13,4],[0,0,0,4],[1,0,1,4],[7,0,7,4],[8,0,8,4],[10,0,10,4],[24,1,24,4],[25,0,26,0],[25,1,25,4],[14,1,18,4],[19,1,19,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[20,1,20,4],[35,0,35,4],[37,0,37,4],[38,0,38,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4]]}
["REPARABILITY INDEX WORKSHEET OF TELEVISION"]
["GENERAL INSTRUCTIONS"]
[]
["PURPOSE OF THE FILE"]
["This Excel file calculate the reparability index of a television."]
[]
["REGULATORY FRAMEWORK"]
["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 reparability index\" of their products, as well as the paramaters explaining how such index was established. This reparability index will inform consumers about the ability to repair the product category concerned. All information entered in this file must be truthful and verifiable.                                                                                                                                                                                                      "]
["The methods and rules of implementation for the reparabilty index are specified in the reparabilty index Decree N°2020-xxx 2020 (date) for electrical and electronic equipment (EEE), the Decision XXXX (date) on display conditions and parameters for calculating the reparability index and the Decision XXXX (date) on criteria, subcritera, rating system and display of the reparability index of televisions."]
[]
["A complementary instructions manual provides explanatory informations and additional instructions on how to apply Decree and Orders of the reparability index of electrical and electronic equipement."]
[]
["FILE CONTENT"]
["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."]
["C1_Documentation","Detailed criteria used to calculate the reparability index of the product.                                    \nOn each tab page, all 'orange boxes' must be completed by selecting the right information from the 'drop-down list' or by directly entered the right information in the box (e.g. criterion 4 : price and file to be send).                                                                                 When the information is enterred, the concerned box change to 'green'.              No box should be left unanswered."]
["C2_Disassembly"]
["C3_Availability of spare parts"]
["C4_Price"]
["C5_Specific"]
["Final score","This tab automatically calculate final score of the reparability index of the product and also scores per criteria and sub-criteria, before and after weighting. "]
["Note finale","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"]
["Annex 1","Details about the therminology used for the reparability index."]
["Annex 2","Details about the list of \"basic\" tools and their reference standards."]
["Annex 3","Details and application case about the concept of disassembly step."]
[]
["REINTIALISER LES CHOIX","This button resets all data entered into the file. If you want to execute this action, please enable macros and click on the button.                                                           WARNING: this action cannot be undone."]
[]
[]
["OTHER DETAILS OF A TRANSVERSAL NATURE"]
["Use of European vocabulary (criteria 1, 2 and 3)"]
["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 washing machines 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."]
["Different commitments of availability period between documentation and spare parts (criteria 1 and 3)"]
["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. "]
["Absence of a part on the equipment "]
["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. "]
["Concerning criterion 4 relating to price, the price of the absent part does not appear in the calculation."]
["Televisions"]
["External power source and remote control"]
["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":"C1_DOCUMENTATION","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,48,6],[13,0,13,6],[44,0,45,2],[39,1,39,2],[0,7,1,10],[0,0,1,6],[32,1,32,2],[30,1,30,2],[29,1,29,2],[31,1,31,2],[26,5,26,6],[27,5,27,6],[27,3,27,4],[28,0,28,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[3,0,4,5],[26,0,27,2],[37,1,37,2],[26,3,26,4],[36,1,36,2],[35,1,35,2],[34,1,34,2],[33,1,33,2],[38,1,38,2],[11,0,11,6],[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[12,0,12,6],[14,0,14,6],[20,0,20,6],[15,0,15,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6]]}
["CRITERION 1 : DOCUMENTATION",null,null,null,null,null,null,"Television"]
[]
[]
["SUB-CRITERION 1.1 : COMMITMENT ON THE AVAILABILITY OVER TIME (WITHOUT CHARGE) OF THE TECHNICAL DOCUMENTATION AND THE OTHER DOCUMENTATION RELATED TO USER AND MAINTENANCE INSTRUCTIONS"]
[]
[]
["ADDITIONAL INFORMATIONS: "]
["Documents/informations: The information can be freely distributed at the initiative of the producer in various physical or dematerialized "]
["documents. Scoring points are awarded if the information referred to is available in any document. "]
["Language of documents: In accordance with the law of August 4, 1994 on the use of the French language, information intended for "]
["consumers must be drawn up in French ; English is tolerated for very technical aspects intended for professional repairers (example:"]
["technical bulletins)."]
["Technical bulletins: This wording covers announcements made by the producer to professional repairers, informing them, for example, of "]
["recently discovered bugs, of the corrections to be made, of the supply disruption of parts which have been replaced by others. Points are "]
["awarded if the edition of a technical bulletin is planned on an ongoing basis (when necessary). "]
["Information on access to professional repairers: The producer or importer is free to indicate to consumers the professional repairers of his "]
["choice, but it is advisable to mention at least the repairer directories listed by Ademe : www.annuaire-reparation.fr"]
["Instructions for self-repair: Points corresponding to years of availability are only granted if one or more operations are specified to "]
["consumers for self-repair, with adequate safety instructions, in a specific section under the title “self-repair”, for example in the technical "]
["manual or of the instructions for use and maintenance. Article L 441-5 of the Consumer Code specifies the responsibility of the producer "]
["regarding self-repair."]
[]
[]
[]
[]
[]
["Commitment on the availability over time of the documentation        (in years)",null,null,"Column B",null,"Column C"]
[null,null,null,"Repairers",null,"Consumers"]
["Type of documentation",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal"]
["1.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(D30=\"if ND ou X < 7 years\",0,IF(D30=\"if 7 years ≤ X < 9 years\",7,IF(D30=\"if 9 years ≤ X < 11 years\",9,IF(D30=\"if X ≥ 11 years\",11,0))))","v":11},"if 7 years ≤ X < 9 years",{"$f":"IF(F30=\"if ND ou X < 7 years\",0,IF(F30=\"if 7 years ≤ X < 9 years\",7,IF(F30=\"if 9 years ≤ X < 11 years\",9,IF(F30=\"if X ≥ 11 years\",11,0))))","v":7}]
["1.1.B ","A dissasembly map or exploded view",null,"if 9 years ≤ X < 11 years",{"$f":"IF(D31=\"if ND ou X < 7 years\",0,IF(D31=\"if 7 years ≤ X < 9 years\",7,IF(D31=\"if 9 years ≤ X < 11 years\",9,IF(D31=\"if X ≥ 11 years\",11,0))))","v":9},"if NA or X < 7 years",{"$f":"IF(F31=\"if ND ou X < 7 years\",0,IF(F31=\"if 7 years ≤ X < 9 years\",7,IF(F31=\"if 9 years ≤ X < 11 years\",9,IF(F31=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.C","Wiring and connection diagrams",null,"if NA or X < 7 years",0,"if NA or X < 7 years",{"$f":"IF(F32=\"if ND ou X < 7 years\",0,IF(F32=\"if 7 years ≤ X < 9 years\",7,IF(F32=\"if 9 years ≤ X < 11 years\",9,IF(F32=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.D","Electronic boards diagrams",null,"if NA or X < 7 years",0,"if NA or X < 7 years",{"$f":"IF(F33=\"if ND ou X < 7 years\",0,IF(F33=\"if 7 years ≤ X < 9 years\",7,IF(F33=\"if 9 years ≤ X < 11 years\",9,IF(F33=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.E","List of necessary repair and test equipment",null,"if 9 years ≤ X < 11 years",9,"if NA or X < 7 years",{"$f":"IF(F34=\"if ND ou X < 7 years\",0,IF(F34=\"if 7 years ≤ X < 9 years\",7,IF(F34=\"if 9 years ≤ X < 11 years\",9,IF(F34=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.F","Technical manual of instructions for repair",null,"if 9 years ≤ X < 11 years",9,"if NA or X < 7 years",{"$f":"IF(F35=\"if ND ou X < 7 years\",0,IF(F35=\"if 7 years ≤ X < 9 years\",7,IF(F35=\"if 9 years ≤ X < 11 years\",9,IF(F35=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.G","Diagnostic fault and error codes",null,"if NA or X < 7 years",0,"if NA or X < 7 years",{"$f":"IF(F36=\"if ND ou X < 7 years\",0,IF(F36=\"if 7 years ≤ X < 9 years\",7,IF(F36=\"if 9 years ≤ X < 11 years\",9,IF(F36=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.H","Component and diagnosis information",null,"if X ≥ 11 years",11,"if NA or X < 7 years",{"$f":"IF(F37=\"if ND ou X < 7 years\",0,IF(F37=\"if 7 years ≤ X < 9 years\",7,IF(F37=\"if 9 years ≤ X < 11 years\",9,IF(F37=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.I","Instructions for software and firmware (including reset software)",null,"if X ≥ 11 years",11,"if X ≥ 11 years",{"$f":"IF(F38=\"if ND ou X < 7 years\",0,IF(F38=\"if 7 years ≤ X < 9 years\",7,IF(F38=\"if 9 years ≤ X < 11 years\",9,IF(F38=\"if X ≥ 11 years\",11,0))))","v":11}]
["1.1.J","Information on how to access data records of reported failure incidents stored on the product",null,"if NA or X < 7 years",0,"if NA or X < 7 years",{"$f":"IF(F39=\"if ND ou X < 7 years\",0,IF(F39=\"if 7 years ≤ X < 9 years\",7,IF(F39=\"if 9 years ≤ X < 11 years\",9,IF(F39=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.K","Technical bulletins",null,"if NA or X < 7 years",{"$f":"IF(D40=\"if ND ou X < 7 years\",0,IF(D40=\"if 7 years ≤ X < 9 years\",7,IF(D40=\"if 9 years ≤ X < 11 years\",9,IF(D40=\"if X ≥ 11 years\",11,0))))","v":0},"if NA or X < 7 years",{"$f":"IF(F40=\"if ND ou X < 7 years\",0,IF(F40=\"if 7 years ≤ X < 9 years\",7,IF(F40=\"if 9 years ≤ X < 11 years\",9,IF(F40=\"if X ≥ 11 years\",11,0))))","v":0}]
["1.1.L","Specific guidance for self-repair (recommended operations, safety and repair instructions, any implications for the guarantee)*",null,null,null,"if NA or X < 7 years",0]
["1.1.M","How to get access to professional repairers",null,null,null,"if X ≥ 11 years",11]
["1.1.N","Failures detection and required action (consumers approach)",null,null,null,"if 7 years ≤ X < 9 years",7]
["1.1.O","User and maintenance instructions",null,null,null,"if 7 years ≤ X < 9 years",7]
["Total sub-criterion 1.1",null,null,null,{"$f":"SUM(E30:E40)","v":60},null,{"$f":"SUM(G30:G44)","v":43},{"$f":"E45+G45","v":103},"/286"]
[null,null,null,null,null,null,null,{"$f":"H45*10/286","v":3.6013986013986012},"/10"]
["*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."]

{"sheet":"C2_DISASSEMBLY","index":2,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[93,3,94,3],[93,4,94,4],[95,3,96,3],[58,3,59,3],[101,0,102,2],[56,0,57,0],[85,0,86,0],[85,1,86,2],[87,1,88,2],[91,1,92,2],[91,0,92,0],[97,0,98,0],[97,1,98,2],[95,0,96,0],[95,1,96,2],[93,0,94,0],[56,1,57,2],[81,1,82,2],[99,1,100,2],[58,1,59,2],[89,0,90,0],[93,1,94,2],[60,0,61,2],[77,0,78,2],[99,0,100,0],[33,0,34,2],[50,0,51,0],[52,0,53,0],[52,1,53,2],[27,4,28,4],[33,3,34,3],[47,3,48,4],[60,3,61,3],[52,4,53,4],[54,3,55,3],[54,4,55,4],[56,3,57,3],[50,4,51,4],[52,3,53,3],[31,0,32,0],[31,1,32,2],[31,3,32,3],[50,1,51,2],[29,3,30,3],[29,4,30,4],[54,0,55,0],[70,0,70,8],[71,0,71,8],[89,1,90,2],[89,3,90,3],[89,4,90,4],[58,0,59,0],[99,4,100,4],[87,0,88,0],[81,3,82,3],[81,4,82,4],[99,3,100,3],[95,4,96,4],[85,3,86,3],[85,4,86,4],[97,3,98,3],[97,4,98,4],[91,3,92,3],[91,4,92,4],[77,3,78,3],[77,4,78,4],[79,3,80,3],[79,4,80,4],[87,3,88,3],[87,4,88,4],[63,0,63,6],[83,0,84,0],[41,0,41,8],[42,0,42,8],[43,0,43,8],[66,0,66,8],[67,0,67,8],[68,0,68,8],[69,0,69,8],[50,3,51,3],[49,0,49,2],[54,1,55,2],[0,9,1,12],[0,0,1,8],[31,4,32,4],[8,0,8,6],[3,4,3,6],[4,4,4,6],[5,4,5,6],[6,4,6,6],[13,0,14,8],[15,0,15,8],[11,9,16,12],[10,9,10,12],[10,0,10,8],[11,0,11,8],[27,3,28,3],[27,1,28,2],[29,0,30,0],[29,1,30,2],[25,4,26,4],[83,1,84,2],[83,3,84,3],[83,4,84,4],[75,3,76,4],[20,0,21,2],[47,0,48,2],[75,0,76,2],[25,0,26,0],[25,1,26,2],[23,0,24,0],[23,1,24,2],[22,0,22,2],[27,0,28,0],[25,3,26,3],[20,3,21,4],[23,3,24,3],[23,4,24,4],[56,4,57,4],[79,0,80,0],[79,1,80,2],[81,0,82,0],[58,4,59,4],[37,0,37,7],[40,0,40,8]]}
["CRITERION 2 : DISASSEMBLY, ACCESSIBILITY, TOOLS, FASTENERS",null,null,null,null,null,null,null,null,"Television"]
[]
[]
["PLEASE ANSWER THE FOLLOWING QUESTIONS :",null,null,null,"ANSWERS"]
["1)","Does the product have any internal power supply ?",null,null,"Yes"]
["2)","Does the porduct have any WiFi module ?",null,null,"Yes"]
["3)","Does the product have any Bluetooth module ?",null,null,"Yes"]
[]
["SUB-CRITERION 2.1 : EASE OF DISASSEMBLY OF SPARE PARTS - BROKEN / MALFUNCTIONING PARTS (LIST 2)"]
[]
["ADDITIONAL INFORMATIONS: ",null,null,null,null,null,null,null,null,"PARTICULAR CASE OF TELEVISION"]
["Details of the dismantling steps can be found on the right side of this sheet and in Annex 3 grid.",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."]
[]
[]
[]
[]
[]
[]
[]
[]
["Ease of disassembly",null,null,"Rating",null,null,"    "]
[]
["List 2 : Broken / malfunctioning parts ",null,null,"Number of steps required to disassemble the spare part","Subtotal"]
["2.1.A","Remote control*",null,"if DDi = 1",{"$f":"IF(D24=\"if NA ou DDi ≥ 4\",0,IF(D24=\"if DDi = 3\",1,IF(D24=\"if DDi = 2\",2,IF(D24=\"if DDi = 1\",3,))))","v":3}]
[]
["2.1.B ","External power supply"]
[]
["2.1.C","Internal power suplly",null,"if DDi < 8",{"$f":"IF(D28=\"if NA ou DDi ≥ 12\",0,IF(D28=\"if 12 > DDi ≥ 10\",1,IF(D28=\"if 10 > DDi ≥ 8\",2,IF(D28=\"if DDi < 8\",3,))))","v":3}]
[]
["2.1.D","Main board",null,"if DDi < 8",{"$f":"IF(D30=\"if NA ou DDi ≥ 12\",0,IF(D30=\"if 12 > DDi ≥ 10\",1,IF(D30=\"if 10 > DDi ≥ 8\",2,IF(D30=\"if DDi < 8\",3,))))","v":3}]
[]
["2.1.E","Display panel/LCD panel ",null,"if 12 > DDi ≥ 10",{"$f":"IF(D32=\"if NA ou DDi ≥ 12\",0,IF(D32=\"if 12 > DDi ≥ 10\",1,IF(D32=\"if 10 > DDi ≥ 8\",2,IF(D32=\"if DDi < 8\",3,))))","v":1}]
[]
["Total sub-criterion 2.1",null,null,null,{"$f":"IF(E5=\"Yes\",SUM(E24,E28,E30,E32),SUM(E24,E30,E32))","v":10},{"$f":"IF(E5=\"Yes\",\"/12\",\"/9\")","v":"/12"}]
[null,null,null,null,{"$f":"IF(E5=\"Yes\",E34*10/12,E34*10/9)","v":8.3333333333333339},"/10"]
["* Requires only to remove accumulators and battery"]
[]
["SUB-CRITERION 2.2 : NECESSARY TOOLS TO REMOVE SPARE PARTS - BROKEN / MALFUNCTIONING PARTS (LIST 2) "]
[]
["ADDITIONAL INFORMATIONS: "]
["- Necessary tools to unitarily disassemble a spare part include all tools used to get access and disassemble the concerned part without causing "]
["damage to the product (which might include getting access to fasteners)."]
["- Tools used are classified according to the complexity of the operation to final users and the availability of tools."]
["- In case of using different types of tools in the disassembly and reassembly sequences of a spare part, the worst score shall be considered."]
[]
[]
[]
["Necessary tools for disassembly",null,null,"Rating"]
[]
["List 2 : Broken / malfunctioning parts ",null,null,"Type of tools used for disassembly","Subtotal"]
["2.2.A","Remote control",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(D51=\"A : Not removable\",0,IF(D51=\"B : Removable with proprietary tools\",1,IF(D51=\"C : Removable with specific tools\",2,IF(D51=\"D : Removable with no tool, with tools supplied with the product or with basic tools\",4,0))))","v":4}]
[]
["2.2.B ","External power supply"]
[]
["2.2.C","Internal power suplly",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(D55=\"A : Not removable\",0,IF(D55=\"B : Removable with proprietary tools\",1,IF(D55=\"C : Removable with specific tools\",2,IF(D55=\"D : Removable with no tool, with tools supplied with the product or with basic tools\",4,0))))","v":4}]
[]
["2.2.D","Main board",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(D57=\"A : Not removable\",0,IF(D57=\"B : Removable with proprietary tools\",1,IF(D57=\"C : Removable with specific tools\",2,IF(D57=\"D : Removable with no tool, with tools supplied with the product or with basic tools\",4,0))))","v":4}]
[]
["2.2.E","Display panel/LCD panel ",null,"D : Removable with no tool, with tools supplied with the product or with basic tools",{"$f":"IF(D59=\"A : Not removable\",0,IF(D59=\"B : Removable with proprietary tools\",1,IF(D59=\"C : Removable with specific tools\",2,IF(D59=\"D : Removable with no tool, with tools supplied with the product or with basic tools\",4,0))))","v":4}]
[]
["Total sub-criterion 2.2",null,null,null,{"$f":"IF(E5=\"Yes\",SUM(E51,E55,E57,E59),SUM(E51,E57,E59))","v":16},{"$f":"IF(E5=\"Yes\",\"/16\",\"/12\")","v":"/16"}]
[null,null,null,null,{"$f":"IF(E5=\"Yes\",E61*10/16,E61*10/12)","v":10},"/10"]
[]
["SUB-CRITERION 2.3 : CHARACTERISTICS OF FASTENERS FOR THE ASSEMBLY OF SPARE PARTS (LISTS 1 AND 2)"]
[]
["ADDITIONAL INFORMATIONS: "]
["- Fasteners : 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."]
["- Fasteners removed are classified according to their accessibility, reusability, amovibility and also their constraints imposed to the product "]
["reparability (e.g. fasteners causing damage or leaving welding or glue residues which preclude reusabiliy of the removed part)."]
["- In case of removing different types of fasteners during the disassembly step of a spare part, the worst score shall be considered."]
[]
[]
["Fasteners characteristics",null,null,"Rating"]
[]
["List 1 : Functional parts                                                                             List 2 : Broken / malfunctioning parts ",null,null,"Type of fasteners","Subtotal"]
[]
["2.3.A","Rear cover",null,"C : Removable and reusable",{"$f":"IF(D80=\"A : Neither removable, nor reusable\",0,IF(D80=\"B : Removable, but not reusable\",1,IF(D80=\"C : Removable and reusable\",2,0)))","v":2}]
[]
["2.3.B ","WiFi module",null,"C : Removable and reusable",{"$f":"IF(D82=\"A : Neither removable, nor reusable\",0,IF(D82=\"B : Removable, but not reusable\",1,IF(D82=\"C : Removable and reusable\",2,0)))","v":2}]
[]
["2.3.C","Bluetooth module",null,"C : Removable and reusable",{"$f":"IF(D84=\"A : Neither removable, nor reusable\",0,IF(D84=\"B : Removable, but not reusable\",1,IF(D84=\"C : Removable and reusable\",2,0)))","v":2}]
[]
["2.3.D","Infrared receiver (IR)",null,"C : Removable and reusable",{"$f":"IF(D86=\"A : Neither removable, nor reusable\",0,IF(D86=\"B : Removable, but not reusable\",1,IF(D86=\"C : Removable and reusable\",2,0)))","v":2}]
[]
["2.3.E","Loudspeaker",null,"C : Removable and reusable",{"$f":"IF(D88=\"A : Neither removable, nor reusable\",0,IF(D88=\"B : Removable, but not reusable\",1,IF(D88=\"C : Removable and reusable\",2,0)))","v":2}]
[]
["2.3.F ","Connectors to connect external equipment (cable, antenna, USB, DVD and Blue-Ray)",null,"A : Neither removable, nor reusable",{"$f":"IF(D90=\"A : Neither removable, nor reusable\",0,IF(D90=\"B : Removable, but not reusable\",1,IF(D90=\"C : Removable and reusable\",2,0)))","v":0}]
[]
["2.3.G ","Remote control",null,"C : Removable and reusable",{"$f":"IF(D92=\"A : Neither removable, nor reusable\",0,IF(D92=\"B : Removable, but not reusable\",1,IF(D92=\"C : Removable and reusable\",2,0)))","v":2},null,null,"E5","E6","E7","Sortie1","Sortie2"]
[null,null,null,null,null,null,null,"YES","YES","YES","\"20\"",{"$f":"IF(AND($E$5=H93,$E$6=I93,$E$7=J93),K93,\"\")","v":"\"20\""}]
["2.3.H","External power supply",null,null,null,null,null,"YES","YES","NO","\"18\"",""]
[null,null,null,null,null,null,null,"YES","NO","YES","\"18\"",""]
["2.3.I","Internal power suplly",null,"C : Removable and reusable",{"$f":"IF(D96=\"A : Neither removable, nor reusable\",0,IF(D96=\"B : Removable, but not reusable\",1,IF(D96=\"C : Removable and reusable\",2,0)))","v":2},null,null,"YES","NO","NO","\"16\"",""]
[null,null,null,null,null,null,null,"NO","YES","YES","\"18\"",""]
["2.3.J","Main board",null,"C : Removable and reusable",{"$f":"IF(D98=\"A : Neither removable, nor reusable\",0,IF(D98=\"B : Removable, but not reusable\",1,IF(D98=\"C : Removable and reusable\",2,0)))","v":2},null,null,"NO","YES","NO","\"16\"",""]
[null,null,null,null,null,null,null,"NO","NO","YES","\"16\"",""]
["2.3.K","Display panel/LCD panel ",null,"C : Removable and reusable",{"$f":"IF(D100=\"A : Neither removable, nor reusable\",0,IF(D100=\"B : Removable, but not reusable\",1,IF(D100=\"C : Removable and reusable\",2,0)))","v":2},null,null,"NO","NO","NO","\"14\"",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L93,L94,L95,L96,L97,L98,L99,L100)","v":"\"20\""}]
["Total sub-criterion 2.3",null,null,null,{"$f":"SUM(E80:E101)","v":18},{"$f":"IF(E5=\"Select a choice\",\"/20\",L103)","v":"/20"},null,null,null,null,null,{"$f":"MID($L$101,FIND(\"\"\"\",$L$101,1)+1,FIND(\"/\",SUBSTITUTE($L$101,\"\"\"\",\"/\",2))-FIND(\"\"\"\",$L$101,1)-1)","v":"20"}]
[null,null,null,null,{"$f":"IF(E5=\"Select a choice\",\"0\",E102*10/L102)","v":9},"/10",null,null,null,null,null,{"$f":"\"/\"&MID($L$101,FIND(\"\"\"\",$L$101,1)+1,FIND(\"/\",SUBSTITUTE($L$101,\"\"\"\",\"/\",2))-FIND(\"\"\"\",$L$101,1)-1)","v":"/20"}]
[]
[]
[]
[null,null," "]

{"sheet":"C3_AVAILABILITY_SP","index":3,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[98,19,99,26],[98,27,99,34],[98,35,99,35],[72,1,73,2],[88,23,89,24],[88,25,89,26],[88,27,89,28],[88,29,89,30],[88,31,89,32],[88,33,89,34],[88,35,89,35],[90,1,91,2],[83,19,83,26],[83,27,83,34],[83,35,85,35],[84,19,84,26],[84,27,84,34],[85,29,85,30],[85,31,85,32],[85,33,85,34],[85,11,85,12],[92,11,93,12],[90,29,91,30],[90,31,91,32],[3,0,3,9],[32,9,33,9],[32,10,33,10],[44,7,45,7],[44,8,45,8],[44,9,45,9],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[30,0,31,0],[30,1,31,2],[28,10,29,10],[28,9,29,9],[28,7,29,7],[30,7,31,7],[28,8,29,8],[30,8,31,8],[41,7,41,8],[41,9,41,10],[30,10,31,10],[30,5,31,5],[28,6,29,6],[30,6,31,6],[24,9,25,9],[44,10,45,10],[42,9,42,10],[24,10,25,10],[30,9,31,9],[50,8,51,8],[43,0,43,2],[24,7,25,7],[26,7,27,7],[24,8,25,8],[42,5,42,6],[42,7,42,8],[26,6,27,6],[28,1,29,2],[32,7,33,7],[32,8,33,8],[42,3,42,4],[48,9,49,9],[50,10,51,10],[48,5,49,5],[48,7,49,7],[48,8,49,8],[50,5,51,5],[50,6,51,6],[70,0,71,0],[70,1,71,2],[86,4,87,4],[86,5,87,5],[86,6,87,6],[86,7,87,7],[86,8,87,8],[86,9,87,9],[79,0,79,8],[72,6,73,6],[72,7,73,7],[72,8,73,8],[74,0,75,0],[74,1,75,2],[74,3,75,3],[74,4,75,4],[74,5,75,5],[74,6,75,6],[74,7,75,7],[74,8,75,8],[72,0,73,0],[72,4,73,4],[72,5,73,5],[85,0,85,2],[84,7,84,8],[84,5,84,6],[66,6,67,6],[83,5,83,6],[68,3,69,3],[68,4,69,4],[68,5,69,5],[68,6,69,6],[70,3,71,3],[70,4,71,4],[70,5,71,5],[70,6,71,6],[72,3,73,3],[84,3,84,4],[83,3,83,4],[63,5,63,6],[66,7,67,7],[66,8,67,8],[50,7,51,7],[50,9,51,9],[64,5,64,6],[64,7,64,8],[92,0,93,0],[92,1,93,2],[86,0,87,0],[88,0,89,0],[88,8,89,8],[90,3,91,3],[90,4,91,4],[92,3,93,3],[92,4,93,4],[92,5,93,5],[92,6,93,6],[92,7,93,7],[92,8,93,8],[90,0,91,0],[88,1,89,2],[90,5,91,5],[90,6,91,6],[90,7,91,7],[86,3,87,3],[90,8,91,8],[88,3,89,3],[88,4,89,4],[88,5,89,5],[88,6,89,6],[0,0,1,8],[23,0,23,2],[32,0,33,0],[32,1,33,2],[32,3,33,3],[48,6,49,6],[68,0,69,0],[68,1,69,2],[66,0,67,0],[34,0,35,2],[66,1,67,2],[59,0,59,8],[63,0,64,2],[68,8,69,8],[66,3,67,3],[66,4,67,4],[66,5,67,5],[63,3,63,4],[44,0,45,0],[44,1,45,2],[46,1,47,2],[46,0,47,0],[50,1,51,2],[50,0,51,0],[0,9,1,12],[21,11,22,11],[22,9,22,10],[21,9,21,10],[26,10,27,10],[26,9,27,9],[54,6,55,6],[54,7,55,7],[54,8,55,8],[52,4,53,4],[52,5,53,5],[52,6,53,6],[52,7,53,7],[52,8,53,8],[56,0,57,2],[52,0,53,0],[52,1,53,2],[90,33,91,34],[90,35,91,35],[90,23,91,24],[90,25,91,26],[90,27,91,28],[86,13,87,14],[86,15,87,16],[86,17,87,18],[86,19,87,20],[88,15,89,16],[88,17,89,18],[88,19,89,20],[88,21,89,22],[90,15,91,16],[90,17,91,18],[90,19,91,20],[90,21,91,22],[88,7,89,7],[85,13,85,14],[92,35,93,35],[92,23,93,24],[92,25,93,26],[92,27,93,28],[92,29,93,30],[92,31,93,32],[92,33,93,34],[85,27,85,28],[86,33,87,34],[86,35,87,35],[86,23,87,24],[86,25,87,26],[86,27,87,28],[86,29,87,30],[86,31,87,32],[85,23,85,24],[85,25,85,26],[88,11,89,12],[88,13,89,14],[92,13,93,14],[92,15,93,16],[92,17,93,18],[76,0,77,2],[83,0,84,2],[68,7,69,7],[86,1,87,2],[92,19,93,20],[92,21,93,22],[46,9,47,9],[46,10,47,10],[48,10,49,10],[85,15,85,16],[85,17,85,18],[85,19,85,20],[85,21,85,22],[63,9,63,10],[64,9,64,10],[52,9,53,9],[52,10,53,10],[54,9,55,9],[54,10,55,10],[86,11,87,12],[90,11,91,12],[90,13,91,14],[84,9,84,10],[83,9,83,10],[50,3,51,3],[50,4,51,4],[48,0,49,0],[48,1,49,2],[98,0,99,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[22,3,22,4],[22,5,22,6],[22,7,22,8],[24,3,25,3],[26,3,27,3],[28,3,29,3],[30,3,31,3],[24,4,25,4],[26,4,27,4],[28,4,29,4],[24,6,25,6],[24,5,25,5],[26,5,27,5],[83,7,83,8],[70,7,71,7],[70,8,71,8],[21,0,22,2],[32,4,33,4],[41,3,41,4],[41,5,41,6],[30,4,31,4],[46,3,47,3],[46,4,47,4],[46,5,47,5],[46,6,47,6],[24,1,25,2],[26,0,27,0],[26,1,27,2],[28,0,29,0],[32,5,33,5],[32,6,33,6],[24,0,25,0],[28,5,29,5],[26,8,27,8],[37,0,37,8],[41,0,42,2],[94,0,95,0],[94,1,95,2],[94,3,95,3],[94,4,95,4],[94,5,95,5],[94,6,95,6],[94,7,95,7],[94,8,95,8],[63,7,63,8],[64,3,64,4],[54,5,55,5],[46,7,47,7],[46,8,47,8],[52,3,53,3],[54,0,55,0],[54,1,55,2],[54,3,55,3],[54,4,55,4],[65,0,65,2],[48,3,49,3],[48,4,49,4],[96,35,97,35],[94,13,95,14],[94,15,95,16],[94,17,95,18],[94,19,95,20],[94,21,95,22],[94,23,95,24],[94,25,95,26],[94,27,95,28],[94,29,95,30],[94,31,95,32],[94,33,95,34],[94,35,95,35],[96,13,97,14],[96,15,97,16],[96,17,97,18],[96,19,97,20],[96,21,97,22],[96,23,97,24],[96,25,97,26],[96,27,97,28],[96,29,97,30],[96,31,97,32],[96,33,97,34],[96,0,97,0],[96,1,97,2],[96,3,97,3],[96,4,97,4],[96,5,97,5],[96,6,97,6],[96,7,97,7],[96,8,97,8],[96,11,97,12],[96,9,97,9],[96,10,97,10],[66,10,67,10],[68,9,69,9],[68,10,69,10],[70,9,71,9],[70,10,71,10],[72,9,73,9],[72,10,73,10],[74,9,75,9],[74,10,75,10],[94,11,95,12],[86,21,87,22],[14,0,14,8],[15,0,15,8],[16,0,16,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[86,10,87,10],[88,9,89,9],[88,10,89,10],[90,9,91,9],[90,10,91,10],[92,9,93,9],[92,10,93,10],[94,9,95,9],[94,10,95,10],[66,9,67,9]]}
["CRITERION 3 : AVAILABILITY OF SPARE PARTS",null,null,null,null,null,null,null,null,"Television"]
[]
[]
["SUB-CRITERION 3.1 : COMMITMENT ON THE AVAILABILITY OVER TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS (LIST 2)"]
[]
["ADDITIONAL INFORMATIONS: "]
["Definition of spare parts distributor: The definition of a spare parts distributor is given in the glossary appended to this manual. "]
["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 available to independent repairers, then points are not awarded "]
["for criterion 3."]
["In addition, in the event that the producer or importer does not have an approved repairers network, the points are awarded "]
["based on the most penalizing practices towards independent repairers."]
["Delivery time: The delivery time is understood in working days between the day of the order and the day of arrival at the actor "]
["concerned."]
[]
[]
[]
[]
["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,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
["List 2 : Broken / malfunctioning parts ",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal"]
["3.1.A","Remote control",null,"if 7 years ≤ X < 9 years",{"$f":"IF(D25=\"if NA or X < 7 years\",0,IF(D25=\"if 7 years ≤ X < 9 years\",7,IF(D25=\"if 9 years ≤ X < 11 years\",9,IF(D25=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(F25=\"if NA or X < 7 years\",0,IF(F25=\"if 7 years ≤ X < 9 years\",7,IF(F25=\"if 9 years ≤ X < 11 years\",9,IF(F25=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(H25=\"if NA or X < 7 years\",0,IF(H25=\"if 7 years ≤ X < 9 years\",7,IF(H25=\"if 9 years ≤ X < 11 years\",9,IF(H25=\"if X ≥ 11 years\",11,0))))","v":7},"if NA or X < 7 years",{"$f":"IF(J25=\"if NA or X < 7 years\",0,IF(J25=\"if 7 years ≤ X < 9 years\",7,IF(J25=\"if 9 years ≤ X < 11 years\",9,IF(J25=\"if X ≥ 11 years\",11,0))))","v":0}]
[]
["3.1.B ","External power supply",null,"Select a choice",{"$f":"IF(D27=\"if NA or X < 7 years\",0,IF(D27=\"if 7 years ≤ X < 9 years\",7,IF(D27=\"if 9 years ≤ X < 11 years\",9,IF(D27=\"if X ≥ 11 years\",11,0))))","v":0},"Select a choice",{"$f":"IF(F27=\"if NA or X < 7 years\",0,IF(F27=\"if 7 years ≤ X < 9 years\",7,IF(F27=\"if 9 years ≤ X < 11 years\",9,IF(F27=\"if X ≥ 11 years\",11,0))))","v":0},"Select a choice",{"$f":"IF(H27=\"if NA or X < 7 years\",0,IF(H27=\"if 7 years ≤ X < 9 years\",7,IF(H27=\"if 9 years ≤ X < 11 years\",9,IF(H27=\"if X ≥ 11 years\",11,0))))","v":0},"Select a choice",{"$f":"IF(J27=\"if NA or X < 7 years\",0,IF(J27=\"if 7 years ≤ X < 9 years\",7,IF(J27=\"if 9 years ≤ X < 11 years\",9,IF(J27=\"if X ≥ 11 years\",11,0))))","v":0}]
[]
["3.1.C","Internal power suplly",null,"if 7 years ≤ X < 9 years",{"$f":"IF(D29=\"if NA or X < 7 years\",0,IF(D29=\"if 7 years ≤ X < 9 years\",7,IF(D29=\"if 9 years ≤ X < 11 years\",9,IF(D29=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(F29=\"if NA or X < 7 years\",0,IF(F29=\"if 7 years ≤ X < 9 years\",7,IF(F29=\"if 9 years ≤ X < 11 years\",9,IF(F29=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(H29=\"if NA or X < 7 years\",0,IF(H29=\"if 7 years ≤ X < 9 years\",7,IF(H29=\"if 9 years ≤ X < 11 years\",9,IF(H29=\"if X ≥ 11 years\",11,0))))","v":7},"if NA or X < 7 years",{"$f":"IF(J29=\"if NA or X < 7 years\",0,IF(J29=\"if 7 years ≤ X < 9 years\",7,IF(J29=\"if 9 years ≤ X < 11 years\",9,IF(J29=\"if X ≥ 11 years\",11,0))))","v":0}]
[]
["3.1.D","Main board",null,"if 7 years ≤ X < 9 years",{"$f":"IF(D31=\"if NA or X < 7 years\",0,IF(D31=\"if 7 years ≤ X < 9 years\",7,IF(D31=\"if 9 years ≤ X < 11 years\",9,IF(D31=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(F31=\"if NA or X < 7 years\",0,IF(F31=\"if 7 years ≤ X < 9 years\",7,IF(F31=\"if 9 years ≤ X < 11 years\",9,IF(F31=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(H31=\"if NA or X < 7 years\",0,IF(H31=\"if 7 years ≤ X < 9 years\",7,IF(H31=\"if 9 years ≤ X < 11 years\",9,IF(H31=\"if X ≥ 11 years\",11,0))))","v":7},"if NA or X < 7 years",{"$f":"IF(J31=\"if NA or X < 7 years\",0,IF(J31=\"if 7 years ≤ X < 9 years\",7,IF(J31=\"if 9 years ≤ X < 11 years\",9,IF(J31=\"if X ≥ 11 years\",11,0))))","v":0}]
[]
["3.1.E","Display panel/LCD panel ",null,"if 7 years ≤ X < 9 years",{"$f":"IF(D33=\"if NA or X < 7 years\",0,IF(D33=\"if 7 years ≤ X < 9 years\",7,IF(D33=\"if 9 years ≤ X < 11 years\",9,IF(D33=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(F33=\"if NA or X < 7 years\",0,IF(F33=\"if 7 years ≤ X < 9 years\",7,IF(F33=\"if 9 years ≤ X < 11 years\",9,IF(F33=\"if X ≥ 11 years\",11,0))))","v":7},"if 7 years ≤ X < 9 years",{"$f":"IF(H33=\"if NA or X < 7 years\",0,IF(H33=\"if 7 years ≤ X < 9 years\",7,IF(H33=\"if 9 years ≤ X < 11 years\",9,IF(H33=\"if X ≥ 11 years\",11,0))))","v":7},"if NA or X < 7 years",{"$f":"IF(J33=\"if NA or X < 7 years\",0,IF(J33=\"if 7 years ≤ X < 9 years\",7,IF(J33=\"if 9 years ≤ X < 11 years\",9,IF(J33=\"if X ≥ 11 years\",11,0))))","v":0}]
[]
["Total sub-criterion 3.1",null,null,null,{"$f":"SUM(E25:E34)","v":28},null,{"$f":"SUM(G25:G34)","v":28},null,{"$f":"SUM(I25:I34)","v":28},null,{"$f":"SUM(K25:K34)","v":0},{"$f":"E35+G35+I35+K35","v":84},"/176"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L35*10/176","v":4.7727272727272725},"/10"]
[]
["SUB-CRITERION 3.2 : COMMITMENT ON THE AVAILABILITY OVER TIME OF SPARE PARTS - FUNCTIONAL PARTS (LIST 1)"]
[]
[]
[]
["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,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
["List 1 : Functional parts",null,null,"Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal","Duration of availability","Subtotal"]
["3.2.A","Rear cover",null,"if X ≥ 11 years",{"$f":"IF(D45=\"if NA or X < 7 years\",0,IF(D45=\"if 7 years ≤ X < 9 years\",7,IF(D45=\"if 9 years ≤ X < 11 years\",9,IF(D45=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F45=\"if NA or X < 7 years\",0,IF(F45=\"if 7 years ≤ X < 9 years\",7,IF(F45=\"if 9 years ≤ X < 11 years\",9,IF(F45=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H45=\"if NA or X < 7 years\",0,IF(H45=\"if 7 years ≤ X < 9 years\",7,IF(H45=\"if 9 years ≤ X < 11 years\",9,IF(H45=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J45=\"if NA or X < 7 years\",0,IF(J45=\"if 7 years ≤ X < 9 years\",7,IF(J45=\"if 9 years ≤ X < 11 years\",9,IF(J45=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["3.2.B","WiFi module",null,"if X ≥ 11 years",{"$f":"IF(D47=\"if NA or X < 7 years\",0,IF(D47=\"if 7 years ≤ X < 9 years\",7,IF(D47=\"if 9 years ≤ X < 11 years\",9,IF(D47=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F47=\"if NA or X < 7 years\",0,IF(F47=\"if 7 years ≤ X < 9 years\",7,IF(F47=\"if 9 years ≤ X < 11 years\",9,IF(F47=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H47=\"if NA or X < 7 years\",0,IF(H47=\"if 7 years ≤ X < 9 years\",7,IF(H47=\"if 9 years ≤ X < 11 years\",9,IF(H47=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J47=\"if NA or X < 7 years\",0,IF(J47=\"if 7 years ≤ X < 9 years\",7,IF(J47=\"if 9 years ≤ X < 11 years\",9,IF(J47=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["3.2.C","Bluetooth module",null,"if X ≥ 11 years",{"$f":"IF(D49=\"if NA or X < 7 years\",0,IF(D49=\"if 7 years ≤ X < 9 years\",7,IF(D49=\"if 9 years ≤ X < 11 years\",9,IF(D49=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F49=\"if NA or X < 7 years\",0,IF(F49=\"if 7 years ≤ X < 9 years\",7,IF(F49=\"if 9 years ≤ X < 11 years\",9,IF(F49=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H49=\"if NA or X < 7 years\",0,IF(H49=\"if 7 years ≤ X < 9 years\",7,IF(H49=\"if 9 years ≤ X < 11 years\",9,IF(H49=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J49=\"if NA or X < 7 years\",0,IF(J49=\"if 7 years ≤ X < 9 years\",7,IF(J49=\"if 9 years ≤ X < 11 years\",9,IF(J49=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["3.2.D","Infrared receiver (IR)",null,"if X ≥ 11 years",{"$f":"IF(D51=\"if NA or X < 7 years\",0,IF(D51=\"if 7 years ≤ X < 9 years\",7,IF(D51=\"if 9 years ≤ X < 11 years\",9,IF(D51=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F51=\"if NA or X < 7 years\",0,IF(F51=\"if 7 years ≤ X < 9 years\",7,IF(F51=\"if 9 years ≤ X < 11 years\",9,IF(F51=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H51=\"if NA or X < 7 years\",0,IF(H51=\"if 7 years ≤ X < 9 years\",7,IF(H51=\"if 9 years ≤ X < 11 years\",9,IF(H51=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J51=\"if NA or X < 7 years\",0,IF(J51=\"if 7 years ≤ X < 9 years\",7,IF(J51=\"if 9 years ≤ X < 11 years\",9,IF(J51=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["3.2.E","Loudspeaker",null,"if X ≥ 11 years",{"$f":"IF(D53=\"if NA or X < 7 years\",0,IF(D53=\"if 7 years ≤ X < 9 years\",7,IF(D53=\"if 9 years ≤ X < 11 years\",9,IF(D53=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F53=\"if NA or X < 7 years\",0,IF(F53=\"if 7 years ≤ X < 9 years\",7,IF(F53=\"if 9 years ≤ X < 11 years\",9,IF(F53=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H53=\"if NA or X < 7 years\",0,IF(H53=\"if 7 years ≤ X < 9 years\",7,IF(H53=\"if 9 years ≤ X < 11 years\",9,IF(H53=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J53=\"if NA or X < 7 years\",0,IF(J53=\"if 7 years ≤ X < 9 years\",7,IF(J53=\"if 9 years ≤ X < 11 years\",9,IF(J53=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["3.2.F","Connectors to connect external equipment (cable, antenna, USB, DVD and Blue-Ray)",null,"if X ≥ 11 years",{"$f":"IF(D55=\"if NA or X < 7 years\",0,IF(D55=\"if 7 years ≤ X < 9 years\",7,IF(D55=\"if 9 years ≤ X < 11 years\",9,IF(D55=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(F55=\"if NA or X < 7 years\",0,IF(F55=\"if 7 years ≤ X < 9 years\",7,IF(F55=\"if 9 years ≤ X < 11 years\",9,IF(F55=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(H55=\"if NA or X < 7 years\",0,IF(H55=\"if 7 years ≤ X < 9 years\",7,IF(H55=\"if 9 years ≤ X < 11 years\",9,IF(H55=\"if X ≥ 11 years\",11,0))))","v":11},"if X ≥ 11 years",{"$f":"IF(J55=\"if NA or X < 7 years\",0,IF(J55=\"if 7 years ≤ X < 9 years\",7,IF(J55=\"if 9 years ≤ X < 11 years\",9,IF(J55=\"if X ≥ 11 years\",11,0))))","v":11}]
[]
["Total sub-criterion 3.2 ",null,null,null,{"$f":"SUM(E45:E56)","v":66},null,{"$f":"SUM(G45:G56)","v":66},null,{"$f":"SUM(I45:I56)","v":66},null,{"$f":"SUM(K45:K56)","v":66},{"$f":"E57+G57+I57+K57","v":264},{"$f":"IF(AND('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),\"/176\",IF(OR('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),\"/220\",\"/264\"))","v":"/264"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),(L57*10/176),IF(OR('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),(L57*10/220),(L57*10/264)))","v":10},"/10"]
[]
["SUB-CRITERION 3.3 : COMMITMENT ON THE DELIVERY TIME OF SPARE PARTS - BROKEN/MALFUNCTIONING PARTS (LIST 2)"]
[]
[]
[]
["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,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
["List 2 : Broken / malfunctioning parts ",null,null,"Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal"]
["3.3.A","Remote control",null,"if X ≤ 3 days",{"$f":"IF(D67=\"if NA ou X>10 days\",0,IF(D67=\"if 10 days ≥ X > 5 days\",1,IF(D67=\"if 5 days ≥ X > 3 days\",2, IF(D67=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(F67=\"if NA ou X>10 days\",0,IF(F67=\"if 10 days ≥ X > 5 days\",1,IF(F67=\"if 5 days ≥ X > 3 days\",2, IF(F67=\"if X ≤ 3 days\",3,0))))","v":3},"if 10 days ≥ X > 5 days",{"$f":"IF(H67=\"if NA ou X>10 days\",0,IF(H67=\"if 10 days ≥ X > 5 days\",1,IF(H67=\"if 5 days ≥ X > 3 days\",2, IF(H67=\"if X ≤ 3 days\",3,0))))","v":1},"if NA or X >10 days",{"$f":"IF(J67=\"if NA ou X>10 days\",0,IF(J67=\"if 10 days ≥ X > 5 days\",1,IF(J67=\"if 5 days ≥ X > 3 days\",2, IF(J67=\"if X ≤ 3 days\",3,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
["3.3.B","External power supply",null,"Select a choice",{"$f":"IF(D69=\"if NA ou X>10 days\",0,IF(D69=\"if 10 days ≥ X > 5 days\",1,IF(D69=\"if 5 days ≥ X > 3 days\",2, IF(D69=\"if X ≤ 3 days\",3,0))))","v":0},"Select a choice",0,"Select a choice",{"$f":"IF(H69=\"if NA ou X>10 days\",0,IF(H69=\"if 10 days ≥ X > 5 days\",1,IF(H69=\"if 5 days ≥ X > 3 days\",2, IF(H69=\"if X ≤ 3 days\",3,0))))","v":0},"Select a choice",{"$f":"IF(J69=\"if NA ou X>10 days\",0,IF(J69=\"if 10 days ≥ X > 5 days\",1,IF(J69=\"if 5 days ≥ X > 3 days\",2, IF(J69=\"if X ≤ 3 days\",3,0))))","v":0}]
[]
["3.3.C","Internal power suplly",null,"if X ≤ 3 days",{"$f":"IF(D71=\"if NA ou X>10 days\",0,IF(D71=\"if 10 days ≥ X > 5 days\",1,IF(D71=\"if 5 days ≥ X > 3 days\",2, IF(D71=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if 10 days ≥ X > 5 days",{"$f":"IF(H71=\"if NA ou X>10 days\",0,IF(H71=\"if 10 days ≥ X > 5 days\",1,IF(H71=\"if 5 days ≥ X > 3 days\",2, IF(H71=\"if X ≤ 3 days\",3,0))))","v":1},"if NA or X >10 days",{"$f":"IF(J71=\"if NA ou X>10 days\",0,IF(J71=\"if 10 days ≥ X > 5 days\",1,IF(J71=\"if 5 days ≥ X > 3 days\",2, IF(J71=\"if X ≤ 3 days\",3,0))))","v":0}]
[]
["3.3.D","Main board",null,"if X ≤ 3 days",{"$f":"IF(D73=\"if NA ou X>10 days\",0,IF(D73=\"if 10 days ≥ X > 5 days\",1,IF(D73=\"if 5 days ≥ X > 3 days\",2, IF(D73=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if 10 days ≥ X > 5 days",{"$f":"IF(H73=\"if NA ou X>10 days\",0,IF(H73=\"if 10 days ≥ X > 5 days\",1,IF(H73=\"if 5 days ≥ X > 3 days\",2, IF(H73=\"if X ≤ 3 days\",3,0))))","v":1},"if NA or X >10 days",{"$f":"IF(J73=\"if NA ou X>10 days\",0,IF(J73=\"if 10 days ≥ X > 5 days\",1,IF(J73=\"if 5 days ≥ X > 3 days\",2, IF(J73=\"if X ≤ 3 days\",3,0))))","v":0}]
[]
["3.3.E","Display panel/LCD panel ",null,"if X ≤ 3 days",{"$f":"IF(D75=\"if NA ou X>10 days\",0,IF(D75=\"if 10 days ≥ X > 5 days\",1,IF(D75=\"if 5 days ≥ X > 3 days\",2, IF(D75=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if 10 days ≥ X > 5 days",{"$f":"IF(H75=\"if NA ou X>10 days\",0,IF(H75=\"if 10 days ≥ X > 5 days\",1,IF(H75=\"if 5 days ≥ X > 3 days\",2, IF(H75=\"if X ≤ 3 days\",3,0))))","v":1},"if NA or X >10 days",{"$f":"IF(J75=\"if NA ou X>10 days\",0,IF(J75=\"if 10 days ≥ X > 5 days\",1,IF(J75=\"if 5 days ≥ X > 3 days\",2, IF(J75=\"if X ≤ 3 days\",3,0))))","v":0}]
[]
["Total sub-criterion 3.3",null,null,null,{"$f":"SUM(E67:E76)","v":12},null,{"$f":"SUM(G67:G76)","v":12},null,{"$f":"SUM(I67:I76)","v":4},null,{"$f":"SUM(K67:K76)","v":0},{"$f":"E77+G77+I77+K77","v":28},"/48"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L77*10/48","v":5.833333333333333},"/10"]
[]
["SUB-CRITERION 3.4 : COMMITMENT ON THE DELIVERY TIME OF SPARE PARTS - FUNCTIONAL PARTS (LIST 1)"]
[]
[]
[]
["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,"Producer",null,"Spare parts retailers",null,"Repairers",null,"Consumers"]
["List 1 : Functional parts",null,null,"Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal","Delivery time","Subtotal"]
["3.4.A","Rear cover",null,"if X ≤ 3 days",{"$f":"IF(D87=\"if NA ou X>10 days\",0,IF(D87=\"if 10 days ≥ X > 5 days\",1,IF(D87=\"if 5 days ≥ X > 3 days\",2, IF(D87=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(F87=\"if NA ou X>10 days\",0,IF(F87=\"if 10 days ≥ X > 5 days\",1,IF(F87=\"if 5 days ≥ X > 3 days\",2, IF(F87=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(H87=\"if NA ou X>10 days\",0,IF(H87=\"if 10 days ≥ X > 5 days\",1,IF(H87=\"if 5 days ≥ X > 3 days\",2, IF(H87=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J87=\"if NA ou X>10 days\",0,IF(J87=\"if 10 days ≥ X > 5 days\",1,IF(J87=\"if 5 days ≥ X > 3 days\",2, IF(J87=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["3.4.B","WiFi module",null,"if X ≤ 3 days",{"$f":"IF(D89=\"if NA ou X>10 days\",0,IF(D89=\"if 10 days ≥ X > 5 days\",1,IF(D89=\"if 5 days ≥ X > 3 days\",2, IF(D89=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if X ≤ 3 days",{"$f":"IF(H89=\"if NA ou X>10 days\",0,IF(H89=\"if 10 days ≥ X > 5 days\",1,IF(H89=\"if 5 days ≥ X > 3 days\",2, IF(H89=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J89=\"if NA ou X>10 days\",0,IF(J89=\"if 10 days ≥ X > 5 days\",1,IF(J89=\"if 5 days ≥ X > 3 days\",2, IF(J89=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["3.4.C","Bluetooth module",null,"if X ≤ 3 days",{"$f":"IF(D91=\"if NA ou X>10 days\",0,IF(D91=\"if 10 days ≥ X > 5 days\",1,IF(D91=\"if 5 days ≥ X > 3 days\",2, IF(D91=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if X ≤ 3 days",{"$f":"IF(H91=\"if NA ou X>10 days\",0,IF(H91=\"if 10 days ≥ X > 5 days\",1,IF(H91=\"if 5 days ≥ X > 3 days\",2, IF(H91=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J91=\"if NA ou X>10 days\",0,IF(J91=\"if 10 days ≥ X > 5 days\",1,IF(J91=\"if 5 days ≥ X > 3 days\",2, IF(J91=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["3.4.D","Infrared receiver (IR)",null,"if X ≤ 3 days",{"$f":"IF(D93=\"if NA ou X>10 days\",0,IF(D93=\"if 10 days ≥ X > 5 days\",1,IF(D93=\"if 5 days ≥ X > 3 days\",2, IF(D93=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",3,"if X ≤ 3 days",{"$f":"IF(H93=\"if NA ou X>10 days\",0,IF(H93=\"if 10 days ≥ X > 5 days\",1,IF(H93=\"if 5 days ≥ X > 3 days\",2, IF(H93=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J93=\"if NA ou X>10 days\",0,IF(J93=\"if 10 days ≥ X > 5 days\",1,IF(J93=\"if 5 days ≥ X > 3 days\",2, IF(J93=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["3.4.E","Loudspeaker",null,"if X ≤ 3 days",{"$f":"IF(D95=\"if NA ou X>10 days\",0,IF(D95=\"if 10 days ≥ X > 5 days\",1,IF(D95=\"if 5 days ≥ X > 3 days\",2, IF(D95=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(F95=\"if NA ou X>10 days\",0,IF(F95=\"if 10 days ≥ X > 5 days\",1,IF(F95=\"if 5 days ≥ X > 3 days\",2, IF(F95=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(H95=\"if NA ou X>10 days\",0,IF(H95=\"if 10 days ≥ X > 5 days\",1,IF(H95=\"if 5 days ≥ X > 3 days\",2, IF(H95=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J95=\"if NA ou X>10 days\",0,IF(J95=\"if 10 days ≥ X > 5 days\",1,IF(J95=\"if 5 days ≥ X > 3 days\",2, IF(J95=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["3.4.F","Connectors to connect external equipment (cable, antenna, USB, DVD and Blue-Ray)",null,"if X ≤ 3 days",{"$f":"IF(D97=\"if NA ou X>10 days\",0,IF(D97=\"if 10 days ≥ X > 5 days\",1,IF(D97=\"if 5 days ≥ X > 3 days\",2, IF(D97=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(F97=\"if NA ou X>10 days\",0,IF(F97=\"if 10 days ≥ X > 5 days\",1,IF(F97=\"if 5 days ≥ X > 3 days\",2, IF(F97=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(H97=\"if NA ou X>10 days\",0,IF(H97=\"if 10 days ≥ X > 5 days\",1,IF(H97=\"if 5 days ≥ X > 3 days\",2, IF(H97=\"if X ≤ 3 days\",3,0))))","v":3},"if X ≤ 3 days",{"$f":"IF(J97=\"if NA ou X>10 days\",0,IF(J97=\"if 10 days ≥ X > 5 days\",1,IF(J97=\"if 5 days ≥ X > 3 days\",2, IF(J97=\"if X ≤ 3 days\",3,0))))","v":3}]
[]
["Total sub-criterion 3.4",null,null,null,{"$f":"SUM(E87:E98)","v":18},null,{"$f":"SUM(G87:G98)","v":18},null,{"$f":"SUM(I87:I98)","v":18},null,{"$f":"SUM(K87:K98)","v":18},{"$f":"E99+G99+I99+K99","v":72},{"$f":"IF(AND('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),\"/48\",IF(OR('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),\"/60\",\"/72\"))","v":"/72"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),(L99*10/48),IF(OR('C2_DISASSEMBLY'!E6=\"No\",'C2_DISASSEMBLY'!E7=\"No\"),(L99*10/60),(L99*10/72)))","v":10},"/10"]

{"sheet":"C4_PRICE","index":4,"n_rows":143,"n_cols":17,"rows_kept":143,"cut":false,"hidden":false,"merged":[[36,0,36,11],[37,0,37,11],[39,0,40,6],[26,13,28,13],[27,0,27,5],[28,0,28,5],[33,0,33,11],[34,0,34,11],[35,0,35,11],[26,0,26,5],[26,7,28,7],[26,8,28,8],[26,9,28,9],[26,10,28,11],[26,12,28,12],[11,0,11,10],[12,0,12,10],[13,0,13,10],[19,0,19,10],[23,0,25,5],[23,6,23,9],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[14,0,14,10],[15,0,15,10],[16,0,16,10],[17,0,17,10],[18,0,18,10],[6,0,6,10],[7,0,7,10],[8,0,8,10],[9,0,9,10],[10,0,10,10],[0,0,1,10],[0,11,1,15],[4,0,4,10],[3,0,3,10],[5,0,5,10]]}
["CRITERION 4 : PRICE OF SPARE PARTS",null,null,null,null,null,null,null,null,null,null,"Television"]
[]
[]
["ADDITIONAL INFORMATIONS: "]
["Deduction of delivery costs: The principle adopted is to make a calculation excluding transport or delivery costs. If the latter are  "]
["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"]
[" calculate the ratio. In particular for the price of spare parts, two methods are possible for deducting transport or delivery costs: "]
["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 "]
["price of new equipment.   "]
["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 "]
["inseparable parts, the price of the part concerned is the price of this batch or subset. "]
["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 "]
["awarded for criterion 4 relating to the price of spare parts is 0.  "]
["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 "]
["parts to be considered is then that of the supplier's general terms and conditions of sale at the time of the index calculation. "]
["Options for products with the same reference: If options are offered for the same reference, and do not influence the technical "]
["characteristics for the purpose of calculating the index, then the calculation of the price ratio to be achieved is based on the "]
["price of spare parts and the price of the most current version of the product concerned. "]
["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 "]
["absent part does not appear in the calculation of the ratio."]
[]
[]
[]
["PRICE Criterion",null,null,null,null,null,"RATING"]
[null,null,null,null,null,null,"Value                   (euros)","Score                                     (%)","POINTS                                                 (/100)","FINAL SCORE\n(/10)"]
[]
["Pre-tax price of the most expensive spare part (list 2)",null,null,null,null,null,1871.59,{"$f":"IF(ISERROR((($G$27+($G$28))/2)/$G$29),\"0%\",((($G$27+($G$28))/A45)/$G$29))","v":0.13655346525880313},{"$f":"IF(M27<0,0,IF(M27>100,100,MROUND(M27,5)))","v":80},{"$f":"IF(M27/10<0,0,IF(M27/10>=10,10,MROUND(M27,5)/10))","v":8},{"$f":"IF(I27<0,\"NOTE DE ZERO                   CAR SCORE HORS BAREME DE NOTATION\")","v":false},null,{"$f":"IF(_xlfn.FORECAST.LINEAR($H$27,A43:A143,B43:B143)=150,0,_xlfn.FORECAST.LINEAR($H$27,A43:A143,B43:B143))","v":81.723267370598435},{"$f":"IF(M27/10<0,0,IF(M27/10>=10,10,M27/10 ))","v":8.1723267370598442}]
["Average pre-tax price of other spare parts (list 2)",null,null,null,null,null,8.5299999999999994]
["Manufacturer's price pre-tax of concerned model",null,null,null,null,null,6884.19]
[]
[]
[]
[]
["The number of points obtained for this criterion is determined as follows:"]
["- if the result is greater than 0.3 then the number of points is 0;"]
["- if the result is less than 0.1 then the number of points is 100;"]
["- if the result is between 0.1 and 0.3 then the number of points is determined according to the following correspondence table :"]
[]
[]
["DATA"]
[]
["y","x","a","b","y '",null,"x ' "]
[0,{"$f":"$C$43*A43+$D$43","v":0.3},-2E-3,0.3,100,0,{"$f":"$C$43*E43+$D$43","v":9.9999999999999978E-2},{"$f":"IF($H$27>=G43,$H$27,IF($H$27<G43,-2.2))","v":0.13655346525880313},0.2]
[1,0.29799999999999999,-0.2,0.3,99,0,0.10199999999999998,0.13655346525880313,0.2]
[2,0.29599999999999999,-0.2,0.3,98,0,0.10399999999999998,0.13655346525880313,0.2]
[3,0.29399999999999998,-0.2,0.3,97,0,0.10599999999999998,0.13655346525880313,0.2]
[4,0.29199999999999998,-0.2,0.3,96,0,0.10799999999999998,0.13655346525880313,0.2]
[5,0.28999999999999998,-0.2,0.3,95,0,0.10999999999999999,0.13655346525880313,0.2]
[6,0.28799999999999998,-0.2,0.3,94,0,0.11199999999999999,0.13655346525880313,0.2]
[7,0.28599999999999998,-0.2,0.3,93,0,0.11399999999999999,0.13655346525880313,0.2]
[8,0.28399999999999997,-0.2,0.3,92,0,0.11599999999999999,0.13655346525880313,0.2,null,null,null,null,null,null,null," "]
[9,0.28199999999999997,-0.2,0.3,91,0,0.11799999999999999,0.13655346525880313,0.2]
[10,0.27999999999999997,-0.2,0.3,90,0,0.12,0.13655346525880313,0.2]
[11,0.27799999999999997,-0.2,0.3,89,0,0.122,0.13655346525880313,0.2]
[12,0.27599999999999997,-0.2,0.3,88,0,0.124,0.13655346525880313,0.2]
[13,0.27399999999999997,-0.2,0.3,87,0,0.12599999999999997,0.13655346525880313,0.2]
[14,0.27199999999999996,-0.2,0.3,86,0,0.12799999999999997,0.13655346525880313,0.2]
[15,0.27,-0.2,0.3,85,0,0.12999999999999998,0.13655346525880313,0.2]
[16,0.26800000000000002,-0.2,0.3,84,0,0.13199999999999998,0.13655346525880313,0.2]
[17,0.26600000000000001,-0.2,0.3,83,0,0.13399999999999998,0.13655346525880313,0.2]
[18,0.26400000000000001,-0.2,0.3,82,0,0.13599999999999998,0.13655346525880313,0.2]
[19,0.26200000000000001,-0.2,0.3,81,0,0.13799999999999998,-2.2000000000000002,0.2]
[20,0.26,-0.2,0.3,80,0,0.13999999999999999,-2.2000000000000002,0.2]
[21,0.25800000000000001,-0.2,0.3,79,0,0.14199999999999999,-2.2000000000000002,0.2]
[22,0.25600000000000001,-0.2,0.3,78,0,0.14399999999999999,-2.2000000000000002,0.2]
[23,0.254,-0.2,0.3,77,0,0.14599999999999999,-2.2000000000000002,0.2]
[24,0.252,-0.2,0.3,76,0,0.14799999999999999,-2.2000000000000002,0.2]
[25,0.25,-0.2,0.3,75,0,0.15,-2.2000000000000002,0.2]
[26,0.248,-0.2,0.3,74,0,0.152,-2.2000000000000002,0.2]
[27,0.246,-0.2,0.3,73,0,0.154,-2.2000000000000002,0.2]
[28,0.24399999999999999,-0.2,0.3,72,0,0.15599999999999997,-2.2000000000000002,0.2]
[29,0.24199999999999999,-0.2,0.3,71,0,0.15799999999999997,-2.2000000000000002,0.2]
[30,0.24,-0.2,0.3,70,0,0.15999999999999998,-2.2000000000000002,0.2]
[31,0.23799999999999999,-0.2,0.3,69,0,0.16199999999999998,-2.2000000000000002,0.2]
[32,0.23599999999999999,-0.2,0.3,68,0,0.16399999999999998,-2.2000000000000002,0.2]
[33,0.23399999999999999,-0.2,0.3,67,0,0.16599999999999998,-2.2000000000000002,0.2]
[34,0.23199999999999998,-0.2,0.3,66,0,0.16799999999999998,-2.2000000000000002,0.2]
[35,0.22999999999999998,-0.2,0.3,65,0,0.16999999999999998,-2.2000000000000002,0.2]
[36,0.22799999999999998,-0.2,0.3,64,0,0.17199999999999999,-2.2000000000000002,0.2]
[37,0.22599999999999998,-0.2,0.3,63,0,0.17399999999999999,-2.2000000000000002,0.2]
[38,0.22399999999999998,-0.2,0.3,62,0,0.17599999999999999,-2.2000000000000002,0.2]
[39,0.22199999999999998,-0.2,0.3,61,0,0.17799999999999999,-2.2000000000000002,0.2]
[40,0.21999999999999997,-0.2,0.3,60,0,0.18,-2.2000000000000002,0.2]
[41,0.21799999999999997,-0.2,0.3,59,0,0.182,-2.2000000000000002,0.2]
[42,0.21599999999999997,-0.2,0.3,58,0,0.184,-2.2000000000000002,0.2]
[43,0.21399999999999997,-0.2,0.3,57,0,0.186,-2.2000000000000002,0.2]
[44,0.21199999999999999,-0.2,0.3,56,0,0.188,-2.2000000000000002,0.2]
[45,0.21,-0.2,0.3,55,0,0.19,-2.2000000000000002,0.2]
[46,0.20799999999999999,-0.2,0.3,54,0,0.192,-2.2000000000000002,0.2]
[47,0.20599999999999999,-0.2,0.3,53,0,0.19400000000000001,-2.2000000000000002,0.2]
[48,0.20399999999999999,-0.2,0.3,52,0,0.19599999999999998,-2.2000000000000002,0.2]
[49,0.20199999999999999,-0.2,0.3,51,0,0.19799999999999998,-2.2000000000000002,0.2]
[50,0.19999999999999998,-0.2,0.3,50,0.2,0.19999999999999998,-2.2000000000000002,0.2]
[51,0.19799999999999998,-0.2,0.3,49,0.2,0.20199999999999999,-2.2000000000000002,-2.2000000000000002]
[52,0.19599999999999998,-0.2,0.3,48,0.2,0.20399999999999999,-2.2000000000000002,-2.2000000000000002]
[53,0.19400000000000001,-0.2,0.3,47,0.2,0.20599999999999999,-2.2000000000000002,-2.2000000000000002]
[54,0.192,-0.2,0.3,46,0.2,0.20799999999999999,-2.2000000000000002,-2.2000000000000002]
[55,0.19,-0.2,0.3,45,0.2,0.21,-2.2000000000000002,-2.2000000000000002]
[56,0.188,-0.2,0.3,44,0.2,0.21199999999999999,-2.2000000000000002,-2.2000000000000002]
[57,0.186,-0.2,0.3,43,0.2,0.21399999999999997,-2.2000000000000002,-2.2000000000000002]
[58,0.184,-0.2,0.3,42,0.2,0.21599999999999997,-2.2000000000000002,-2.2000000000000002]
[59,0.182,-0.2,0.3,41,0.2,0.21799999999999997,-2.2000000000000002,-2.2000000000000002]
[60,0.18,-0.2,0.3,40,0.2,0.21999999999999997,-2.2000000000000002,-2.2000000000000002]
[61,0.17799999999999999,-0.2,0.3,39,0.2,0.22199999999999998,-2.2000000000000002,-2.2000000000000002]
[62,0.17599999999999999,-0.2,0.3,38,0.2,0.22399999999999998,-2.2000000000000002,-2.2000000000000002]
[63,0.17399999999999999,-0.2,0.3,37,0.2,0.22599999999999998,-2.2000000000000002,-2.2000000000000002]
[64,{"$f":"$C$43*A107+$D$43","v":0.17199999999999999},-0.2,0.3,36,0.2,{"$f":"$C$43*E107+$D$43","v":0.22799999999999998},{"$f":"IF($H$27>=G107,$H$27,IF($H$27<G107,-2.2))","v":-2.2000000000000002},-2.2000000000000002]
[65,0.16999999999999998,-0.2,0.3,35,0.2,0.22999999999999998,-2.2000000000000002,-2.2000000000000002]
[66,0.16799999999999998,-0.2,0.3,34,0.2,0.23199999999999998,-2.2000000000000002,-2.2000000000000002]
[67,0.16599999999999998,-0.2,0.3,33,0.2,0.23399999999999999,-2.2000000000000002,-2.2000000000000002]
[68,0.16399999999999998,-0.2,0.3,32,0.2,0.23599999999999999,-2.2000000000000002,-2.2000000000000002]
[69,0.16199999999999998,-0.2,0.3,31,0.2,0.23799999999999999,-2.2000000000000002,-2.2000000000000002]
[70,0.15999999999999998,-0.2,0.3,30,0.2,0.24,-2.2000000000000002,-2.2000000000000002]
[71,0.15799999999999997,-0.2,0.3,29,0.2,0.24199999999999999,-2.2000000000000002,-2.2000000000000002]
[72,0.15599999999999997,-0.2,0.3,28,0.2,0.24399999999999999,-2.2000000000000002,-2.2000000000000002]
[73,0.154,-0.2,0.3,27,0.2,0.246,-2.2000000000000002,-2.2000000000000002]
[74,0.152,-0.2,0.3,26,0.2,0.248,-2.2000000000000002,-2.2000000000000002]
[75,0.15,-0.2,0.3,25,0.2,0.25,-2.2000000000000002,-2.2000000000000002]
[76,0.14799999999999999,-0.2,0.3,24,0.2,0.252,-2.2000000000000002,-2.2000000000000002]
[77,0.14599999999999999,-0.2,0.3,23,0.2,0.254,-2.2000000000000002,-2.2000000000000002]
[78,0.14399999999999999,-0.2,0.3,22,0.2,0.25600000000000001,-2.2000000000000002,-2.2000000000000002]
[79,0.14199999999999999,-0.2,0.3,21,0.2,0.25800000000000001,-2.2000000000000002,-2.2000000000000002]
[80,0.13999999999999999,-0.2,0.3,20,0.2,0.26,-2.2000000000000002,-2.2000000000000002]
[81,0.13799999999999998,-0.2,0.3,19,0.2,0.26200000000000001,-2.2000000000000002,-2.2000000000000002]
[82,0.13599999999999998,-0.2,0.3,18,0.2,0.26400000000000001,-2.2000000000000002,-2.2000000000000002]
[83,0.13399999999999998,-0.2,0.3,17,0.2,0.26600000000000001,-2.2000000000000002,-2.2000000000000002]
[84,0.13199999999999998,-0.2,0.3,16,0.2,0.26800000000000002,-2.2000000000000002,-2.2000000000000002]
[85,0.12999999999999998,-0.2,0.3,15,0.2,0.27,-2.2000000000000002,-2.2000000000000002]
[86,0.12799999999999997,-0.2,0.3,14,0.2,0.27199999999999996,-2.2000000000000002,-2.2000000000000002]
[87,0.12599999999999997,-0.2,0.3,13,0.2,0.27399999999999997,-2.2000000000000002,-2.2000000000000002]
[88,0.124,-0.2,0.3,12,0.2,0.27599999999999997,-2.2000000000000002,-2.2000000000000002]
[89,0.122,-0.2,0.3,11,0.2,0.27799999999999997,-2.2000000000000002,-2.2000000000000002]
[90,0.12,-0.2,0.3,10,0.2,0.27999999999999997,-2.2000000000000002,-2.2000000000000002]
[91,0.11799999999999999,-0.2,0.3,9,0.2,0.28199999999999997,-2.2000000000000002,-2.2000000000000002]
[92,0.11599999999999999,-0.2,0.3,8,0.2,0.28399999999999997,-2.2000000000000002,-2.2000000000000002]
[93,0.11399999999999999,-0.2,0.3,7,0.2,0.28599999999999998,-2.2000000000000002,-2.2000000000000002]
[94,0.11199999999999999,-0.2,0.3,6,0.2,0.28799999999999998,-2.2000000000000002,-2.2000000000000002]
[95,0.10999999999999999,-0.2,0.3,5,0.2,0.28999999999999998,-2.2000000000000002,-2.2000000000000002]
[96,0.10799999999999998,-0.2,0.3,4,0.2,0.29199999999999998,-2.2000000000000002,-2.2000000000000002]
[97,0.10599999999999998,-0.2,0.3,3,0.2,0.29399999999999998,-2.2000000000000002,-2.2000000000000002]
[98,0.10399999999999998,-0.2,0.3,2,0.2,0.29599999999999999,-2.2000000000000002,-2.2000000000000002]
[99,0.10199999999999998,-0.2,0.3,1,0.2,0.29799999999999999,-2.2000000000000002,-2.2000000000000002]
[100,9.9999999999999978E-2,-0.2,0.3,0,0.2,0.3,-2.2000000000000002,-2.2000000000000002]

{"sheet":"C5_SPECIFIC","index":5,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[24,0,25,8],[15,1,15,2],[16,0,17,2],[16,3,17,3],[19,0,19,5],[22,0,23,8],[0,0,1,8],[0,9,1,12],[3,0,3,5],[6,0,7,8],[12,0,14,2],[12,3,12,4],[13,3,13,4],[8,0,8,8],[26,0,26,8],[30,5,30,6],[30,7,30,8],[31,5,31,6],[31,7,31,8],[30,0,32,4],[37,0,37,5],[40,0,41,8],[39,0,39,8],[33,1,33,4],[34,0,35,4],[50,0,51,2],[50,3,51,3],[45,7,45,8],[46,3,46,4],[46,5,46,6],[46,7,46,8],[48,1,48,2],[49,1,49,2],[45,0,47,2],[45,3,45,4],[45,5,45,6]]}
["CRITERION 5 : SPECIFIC CRITERION",null,null,null,null,null,null,null,null,"Television"]
[]
[]
["SUB-CRITERION 5.1 : ACCESSIBILITY OF USAGE-METER TO CONSUMERS"]
[]
["ADDITIONAL INFORMATIONS : "]
["- Definition of the usage meter: The usage meter is a device that cumulatively records the use of the equipment in number of units. This counter can either be visible directly by the consumer each time the device is started up or require a voluntary operation on the part of the user to become aware of the value displayed by the usage counter."]
[]
["Unit of the usage meter: The unit considered is the number of hours of screen use."]
[]
[]
[]
["Usage-counter",null,null,"Column C "]
[null,null,null,"Consumers"]
[null,null,null,"Condition","Subtotal"]
["5.1.A","Accessibility of usage-counter",null,"C : Visible or easily accessible",{"$f":"IF(D16=\"A : Absence\",0,IF(D16=\"B : Not readily accessible\",1,IF(D16=\"C : Visible or easily accessible\",2,0)))","v":2}]
["Total sub-criterion 5.1",null,null,null,{"$f":"SUM(E16:E16)","v":2},"/2"]
[null,null,null,null,{"$f":"E17*10/2","v":10},"/10"]
[]
["SUB-CRITERION 5.2 : FREE REMOTE ASSISTANCE"]
[]
["ADDITIONAL INFORMATIONS : "]
["- A remote assistance support means any system or device which help to easy find general informations in case of failures, to find information in order to identify causes of failures or to provide remote assistance to repair. This system must be able to provide a relevant technical support to consumers."]
[]
["- These remote supports include : remote informations (website, FAQ etc.), remote diagnosis assistance (hotline, chat, application/software included in the equipment, decision tree) or remote repair (hotline, visio, remote control etc.) "]
[]
["- The remote assistance support must be free of charge (including telephone calls to a hotline)."]
[]
[]
[]
["Remote assistance",null,null,null,null,"Column B",null,"Column C "]
[null,null,null,null,null,"Repairers",null,"Consumers"]
[null,null,null,null,null,"Condition ","Subtotal","Condition ","Subtotal"]
["5.2.A","Type of remote assistance",null,null,null,"Up-to-date informations on website",{"$f":"IF(F34=\"Not available\",0,IF(F34=\"Up-to-date informations on website\",1,0))","v":1},"C : Remote diagnosis assistance",{"$f":"IF(H34=\"A : Note available\",0,IF(H34=\"B : Remote informations\",1,IF(H34=\"C : Remote diagnosis assistance\",2,IF(H34=\"D : Remote support for repair\",4,0))))","v":2}]
["Total sub-criterion 5.2",null,null,null,null,null,{"$f":"SUM(G34:G34)","v":1},null,{"$f":"SUM(I34:I34)","v":2},{"$f":"SUM(G35,I35)","v":3},"/5"]
[null,null,null,null,null,null,null,null,null,{"$f":"J35*10/5","v":6},"/10"]
[]
["SUB-CRITERION 5.3 : POSSIBILITY TO RESET SOFTWARES"]
[]
["ADDITIONAL INFORMATIONS : "]
["- The reset softwares means a specific feature or setting to restore (if allowed by the product) the value of a specific feature as set at the factory (to solve problems, bugs or malfunctions) and which is available when the consumer uses the product for the first time."]
[]
[]
[]
[]
["Type de réinitialisation logicielle",null,null,"Column A",null,"Column B",null,"Column C "]
[null,null,null,"Producer",null,"Repairers",null,"Consumers"]
[null,null,null,"Condition (impossible/possible)","Subtotal","Condition (impossible/possible)","Subtotal","Condition (impossible/possible)","Subtotal"]
["5.3.A","Electronic card reset",null,"Possible",{"$f":"IF(D49=\"Impossible\",0,IF(D49=\"Possible\",1,0))","v":1},"Possible",{"$f":"IF(F49=\"Impossible\",0,IF(F49=\"Possible\",1,0))","v":1},"Possible",{"$f":"IF(H49=\"Impossible\",0,IF(H49=\"Possible\",1,0))","v":1}]
["5.3.B","Firmwares reset",null,"Possible",{"$f":"IF(D50=\"Impossible\",0,IF(D50=\"Possible\",1,0))","v":1},"Possible",{"$f":"IF(F50=\"Impossible\",0,IF(F50=\"Possible\",1,0))","v":1},"Possible",{"$f":"IF(H50=\"Impossible\",0,IF(H50=\"Possible\",1,0))","v":1}]
["Total sub-criterion 5.3",null,null,null,{"$f":"SUM(E49:E50)","v":2},null,{"$f":"SUM(G49:G50)","v":2},null,{"$f":"SUM(I49:I50)","v":2},{"$f":"E51+G51+I51","v":6},"/6"]
[null,null,null,null,null,null,null,null,null,{"$f":"J51*10/6","v":10},"/10"]

{"sheet":"FINAL_SCORE","index":6,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,3],[0,4,1,7],[2,0,2,4],[4,2,4,4],[5,0,5,1],[5,2,5,4],[3,0,3,4],[19,0,22,0],[6,2,6,4],[7,2,7,4],[10,0,14,0],[10,1,14,3],[10,4,14,4],[16,0,18,0],[16,1,16,3],[8,0,8,7],[10,7,14,7],[15,1,15,3],[15,7,26,7],[10,5,14,5],[19,1,19,3],[19,6,22,6],[20,1,20,3],[23,1,23,3],[10,6,14,6],[27,7,28,7],[29,0,32,7],[34,0,65,7],[24,0,26,0],[24,1,24,3],[24,6,26,6],[25,1,25,3],[26,1,26,3],[27,0,28,6],[21,1,21,3],[22,1,22,3],[16,6,18,6],[17,1,17,3],[18,1,18,3]]}
["REPAIRABILITY INDEX CALCULATION AND PRESENTATION OF \nTHE PARAMETERS WHICH ALLOWED TO ESTABLISH IT",null,null,null,"Television"]
[]
[]
[]
["Producer's or importer's name or trademark",null,"Loewe"]
["Producer or importer adress",null,"Loewe Technology GmbH, Industriestr. 11, 96317 Kronach"]
["Producer's or importer's model identifier",null,"iconic i.65 "]
["Date of calculation",null,"2023-09-13"]
["This final score sheet in English is only for guidance, the French version must be sent for official circulation"]
[]
["Criteria","Sub-criteria",null,null,"Score of subcriterion       /10","Weighting factor of subcriterion","Score of criterion       /20","Total criteria scores\n/100"]
[]
[]
[]
[]
["CRITERION 1 : DOCUMENTATION","1.1 Availability of the technical documentation and other documentation related to user and maintenance instructions",null,null,{"$f":"'C1_DOCUMENTATION'!H46","v":3.6013986013986012},2,{"$f":"(E16*F16)","v":7.2027972027972025},{"$f":"SUM(G16:G27)","v":72.558857808857809}]
["CRITERION 2 : DISASSEMBLY, ACCESSIBILITY, TOOLS, FASTENERS","2.1 Ease of disassembly parts from List 2*",null,null,{"$f":"'C2_DISASSEMBLY'!E35","v":8.3333333333333339},1,{"$f":"(F17*E17)+(F18*E18)+(F19*E19)","v":17.833333333333336}]
[null,"2.2 Necessary tools (List 2)",null,null,{"$f":"'C2_DISASSEMBLY'!E62","v":10},0.5]
[null,"2.3 Fasteners characteristics parts from List 1** and List 2",null,null,{"$f":"'C2_DISASSEMBLY'!E103","v":9},0.5]
["CRITERION 3 : AVAILABILITY OF SPARE PARTS","3.1 Availability over time parts from List 2",null,null,{"$f":"'C3_AVAILABILITY_SP'!L36","v":4.7727272727272725},1,{"$f":"(F20*E20)+(F21*E21)+(F22*E22)+(F23*E23)","v":13.522727272727273}]
[null,"3.2 Availability over time parts from List 1",null,null,{"$f":"'C3_AVAILABILITY_SP'!L58","v":10},0.5]
[null,"3.3 Delivery time parts from List 2 ",null,null,{"$f":"'C3_AVAILABILITY_SP'!L78","v":5.833333333333333},0.3]
[null,"3.4 Delivery time parts from List 1",null,null,{"$f":"'C3_AVAILABILITY_SP'!L100","v":10},0.2]
["CRITERION 4 : PRICE OF SPARE PARTS","4. Ratio between price of parts from list 2 to the price of the product",null,null,{"$f":"'C4_PRICE'!J27","v":8},2,{"$f":"E24*F24","v":16}]
["CRITERION 5 : SPECIFIC CRITERION","5.1 Accessibility of usage-counter to consumers",null,null,{"$f":"'C5_SPECIFIC'!E18","v":10},1,{"$f":"F25*E25+F26*E26+E27*F27","v":18}]
[null,"5.2 Free remote assistance",null,null,{"$f":"'C5_SPECIFIC'!J36","v":6},0.5]
[null,"5.3 Possibility to reset softwares",null,null,{"$f":"'C5_SPECIFIC'!J52","v":10},0.5]
["Reparability index on 10      ",null,null,null,null,null,null,{"$f":"ROUND(H16/10,1)","v":7.3}]
[]
["* list 2: list of a maximum of 3 to 5 spare parts (depending on the category of equipment concerned) whose broken or malfunctioning parts are the most frequent;\n** list 1: list of a maximum of 10 other spare parts (depending on the category of equipment concerned) whose good condition is necessary for the operation of the equipment."]

{"sheet":"NOTE_FINALE","index":7,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,0,6,1],[6,2,6,4],[0,0,1,3],[0,4,1,7],[3,0,3,4],[5,0,5,1],[5,2,5,4],[7,0,7,1],[7,2,7,4],[8,2,8,4],[10,0,14,0],[10,1,14,3],[10,4,14,4],[16,0,18,0],[16,1,16,3],[16,6,18,6],[17,1,17,3],[18,1,18,3],[10,5,14,5],[10,6,14,6],[10,7,14,7],[15,1,15,3],[15,7,26,7],[19,0,22,0],[19,1,19,3],[19,6,22,6],[20,1,20,3],[21,1,21,3],[22,1,22,3],[27,0,28,6],[27,7,28,7],[29,0,32,7],[23,1,23,3],[24,0,26,0],[24,1,24,3],[24,6,26,6],[25,1,25,3],[26,1,26,3]]}
["CALCUL DE L'INDICE DE RÉPARABILITÉ ET \nPRÉSENTATION DES PARAMÈTRES AYANT PERMIS DE L'ÉTABLIR",null,null,null,"Téléviseur"]
[]
[]
["FICHE D'INFORMATION À TRANSMETTRE AUX DEMANDEURS \n(cf. Article L. 541-9-2 du Code de l’environnement) "]
[]
["Nom ou marque commerciale du producteur ou de l'importateur ",null,{"$f":"FINAL_SCORE!C5","v":"Loewe"}]
["Adresse du producteur ou de l'importateur",null,{"$f":"FINAL_SCORE!C6","v":"Loewe Technology GmbH, Industriestr. 11, 96317 Kronach"}]
["Référence du modèle donnée par le producteur ou l'importateur",null,{"$f":"FINAL_SCORE!C7","v":"iconic i.65 "}]
["Date du calcul",null,{"$f":"FINAL_SCORE!C8","v":45182}]
[]
["Critère","Sous-critère",null,null,"Note du sous-critère sur 10","Coefficient du sous critère","Note du critère sur 20"," Total des notes des critères \nsur 100"]
[]
[]
[]
[]
["CRITÈRE 1 : DOCUMENTATION","1.1 Durée de disponibilité de la documentation technique et relative aux conseils d'utilisation et d'entretien",null,null,{"$f":"FINAL_SCORE!E16","v":3.6013986013986012},2,{"$f":"(E16*F16)","v":7.2027972027972025},{"$f":"SUM(G16:G27)","v":72.558857808857809}]
["CRITÈRE 2 : DÉMONTABILITÉ, ACCÈS, OUTILS, FIXATIONS","2.1 Facilité de démontage des pièces de la liste 2*",null,null,{"$f":"FINAL_SCORE!E17","v":8.3333333333333339},1,{"$f":"(F17*E17)+(F18*E18)+(F19*E19)","v":17.833333333333336}]
[null,"2.2 Outils nécessaires (liste 2)",null,null,{"$f":"FINAL_SCORE!E18","v":10},0.5]
[null,"2.3 Caractéristiques des fixations entre les pièces de la liste 1** et de la liste 2",null,null,{"$f":"FINAL_SCORE!E19","v":9},0.5]
["CRITÈRE 3 : DISPONIBILITÉ DES PIÈCES DÉTACHÉES","3.1 Durée de disponibilité des pièces de la liste 2",null,null,{"$f":"FINAL_SCORE!E20","v":4.7727272727272725},1,{"$f":"(F20*E20)+(F21*E21)+(F22*E22)+(F23*E23)","v":13.522727272727273}]
[null,"3.2 Durée de disponibilité des pièces de la liste 1",null,null,{"$f":"FINAL_SCORE!E21","v":10},0.5]
[null,"3.3 Délais de livraison des pièces de la liste 2",null,null,{"$f":"FINAL_SCORE!E22","v":5.833333333333333},0.3]
[null,"3.4 Délais de livraison des pièces de la liste 1",null,null,{"$f":"FINAL_SCORE!E23","v":10},0.2]
["CRITÈRE 4 : PRIX DES PIÈCES DÉTACHÉES","4. Rapport prix des pièces de la liste 2 sur prix de l’équipement neuf",null,null,{"$f":"FINAL_SCORE!E24","v":8},2,{"$f":"E24*F24","v":16}]
["CRITÈRE 5 : CRITÈRE SPÉCIFIQUE","5.1 Accessibilité du compteur d'usage",null,null,{"$f":"FINAL_SCORE!E25","v":10},1,{"$f":"F25*E25+F26*E26+E27*F27","v":18}]
[null,"5.2 Assistance à distance sans frais",null,null,{"$f":"FINAL_SCORE!E26","v":6},0.5]
[null,"5.3 Possibilité de réinitialisation logicielle",null,null,{"$f":"FINAL_SCORE!E27","v":10},0.5]
["Note de l'indice sur 10      ",null,null,null,null,null,null,{"$f":"ROUND(H16/10,1)","v":7.3}]
[]
["*liste 2 : liste des 3 à 5 pièces détachées au maximum (selon la catégorie d’équipements concernée) dont la casse ou les pannes sont les plus fréquentes ;\n**liste 1 : liste de 10 autres pièces détachées au maximum (selon la catégorie d’équipements concernée) dont le bon état est nécessaire au fonctionnement de l’équipement."]

{"sheet":"ANNEX_1","index":8,"n_rows":89,"n_cols":3,"rows_kept":89,"cut":false,"hidden":false,"merged":[[15,2,16,2],[3,0,3,2],[3,5,3,8],[4,0,4,2],[6,2,8,2],[9,2,12,2]]}
["ANNEX 1 : TERMINOLOGY USED FOR THE REPARABILITY INDEX"]
[]
[]
["The definitions of the following terms are specified in the decree relating to the repairability index for electrical and electronic equipment: "]
["\"Making available onthe market\", \"Placing on the market\", \"producer\", \"importer\", \"distributor\", \"Seller\", \"distance selling\", \"model\"."]
[]
["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"]
["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."]
["Professional repairer","Authorized repairer or independent repairer.  "]
["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."]
["Disassembly","The process by which a product, spare part or fastener is disassembled so that it can then be reassembled and made operational."]
["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."]
["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."]
["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"]
["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."]
["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 \""]
["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."]
["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."]
["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."]
["Removable fastener","An original fastener system that can be completely removed (without causing damage or leaving residue)."]
["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."]
["Part / Spare parts","A unitary element in the composition of the equipment."]
[]
[]
["VOCABULAIRE EUROPEEN"]
[]
["Eco-conception des lave-linges ","Ecodesign of washing machines"]
["RÈGLEMENT (UE) 2019/2023 DE LA COMMISSION  du 1er octobre 2019 établissant des exigences en matière d’écoconception applicables aux lave-linge ménagers et aux lave-linge 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"]
[]
["Liste des informations à fournir (documentation)"]
[]
["→  Les informations de réparation et d’entretien du lave-linge ménager ou du lave-linge séchant ménager mentionnées au point a) comprennent :"," → the household washing machine or household washer-dryer repair and maintenance information referred to in (a) shall include :"]
[]
["une identification sans équivoque du lave-linge ménager ou du lave-linge séchant ménager","the unequivocal household washing machine or household washer-dryer identification"]
["un schéma de démontage ou une vue éclatée","a disassembly map or exploded view"]
["un manuel technique d’instructions relatives à la réparation","technical manual of instructions for repair"]
["une liste du matériel de réparation et de test nécessaire","list of necessary repair and test equipment"]
["les informations concernant les composants et le diagnostic (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)"]
["des schémas de câblage et de raccordement","wiring and connection diagrams"]
["les codes d’erreur et de diagnostic (y compris les codes spécifiques au fabricant, le cas échéant)","diagnostic fault and error codes (including manufacturer-specific codes, where applicable)"]
["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"]
["les informations sur les modalités d’accès aux données relatives aux incidents de défaillance signalés enregistrées dans le lave-linge ménager ou le lave-linge séchant ménager (le cas échéant)","information on how to access data records of reported failure incidents stored on the household washing machine or washer-dryer (where applicable)"]
[]
["Liste des pièces détachées à mettre à disposition"]
[]
["Moteur et balais de moteur","Motor and motor brushes"]
["Transmission entre moteur et tambour","Transmission between motor and drum"]
["Pompes","Pumps"]
["Amortisseurs et ressorts","Shock absorbers and springs"]
["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)"]
["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)"]
["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)"]
["Cartes de circuit imprimé","Printed circuit boards"]
["Affichages électroniques","Electronic displays"]
["Manocontacts","Pressure switches"]
["Thermostats et capteurs","Thermostats and sensors"]
["Logiciels et micrologiciels, y compris logiciels de réinitialisation","Software and firmware including reset software"]
["Portes","Door"]
["Charnières et joints de porte","Door hinge and seals"]
["Autres joints","Other seals"]
["Assemblage de verrouillage de la porte","Door locking assembly"]
["Accessoires en matière plastique tels que distributeurs de détergent","Plastic peripherals such as detergent dispensers"]
[" "]
[]
["Eco-conception des dispositifs d’affichage","Ecodesign of electronic displays"]
["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"]
[]
["Liste des informations à fournir (documentation) - List of required informations for the consumer"]
[]
["→  Les informations disponibles sur la réparation et la maintenance comprennent :"," → The available repair and maintenance information shall include:"]
[]
["une identification sans équivoque du lave-linge ménager ou du lave-linge séchant ménager","the unequivocal appliance identification"]
["un schéma de démontage ou une vue éclatée","a disassembly map or exploded view"]
["une liste du matériel de réparation et de test nécessaire","list of necessary repair and test equipment"]
["les informations concernant les composants et le diagnostic (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)"]
["des schémas de câblage et de raccordement","wiring and connection diagrams"]
["les codes d’erreur et de diagnostic (y compris les codes spécifiques au fabricant, le cas échéant)","diagnostic fault and error codes (including manufacturer-specific codes, where applicable)"]
["les informations sur les modalités d’accès aux données relatives aux incidents de défaillance signalés enregistrées dans le lave-linge ménager ou le lave-linge séchant ménager (le cas échéant)","information on how to access data records of reported failure incidents stored on the household washing machine or washer-dryer (where applicable)"]
[]
["Liste des pièces détachées à mettre à disposition – List of spare parts to be made available"]
[]
["Les sources d’alimentation internes","Internal power supply"]
["Les sources d’alimentation externes","External power supply"]
["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)"]
["Les condensateurs","Capacitors"]
["Les piles et accumulateurs","Batteries and accumulators"]
["Les modules DVD/Blue-Ray le cas échéant","DVD/Blue-Ray module"]
["Les modules HD/SSD","HD/SSD module"]
["La télécommande","Remote control"]

{"sheet":"ANNEX_2","index":9,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,2],[2,0,3,2],[5,0,6,0],[5,2,6,2]]}
["ANNEX 2 : BASIC TOOLS AND THEIR REFERENCE STANDARDS"]
[]
["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."]
[]
[]
["Tool type","Illustration","Reference"]
[null,"(informative example)"]
["Screwdriver for slotted heads, cross recess or for hexalobular recess heads",null,"ISO 2380, ISO 8764, ISO 10664"]
["Hexagon socket key ",null,"ISO 2936"]
["Combination wrench",null,"ISO 7738"]
["Combination pliers",null,"ISO 5746"]
["Half round nose pliers",null,"ISO 5745"]
["Diagonal cutters",null,"ISO 5749"]
["Multigrip pliers (multiple slip joint pliers)",null,"ISO 8976"]
["Locking pliers"]
["Combination pliers for wire stripping and terminal crimping"]
["Prying lever"]
["Tweezers"]
["Hammer, steel head",null,"ISO 15601"]
["Utility knife (cutter) with snap-off blades"]
["Multimeter"]
["Voltage tester"]
["Soldering iron"]
["Hot glue gun"]
["Magnifying glass"]

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