{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PCN","ExamplePCN","Customer Feedback","Category","Example Customer Feedback","Information Note","Example Information Note"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":44,"comments":6,"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":"PCN","index":0,"n_rows":191,"n_cols":21,"rows_kept":191,"cut":false,"hidden":false,"merged":[[66,1,66,2],[66,3,66,6],[66,7,66,10],[67,1,67,2],[67,3,67,6],[67,7,67,10],[68,1,68,2],[68,3,68,6],[68,7,68,10],[63,1,63,2],[63,3,63,6],[63,7,63,10],[64,1,64,2],[64,3,64,6],[64,7,64,10],[65,1,65,2],[65,3,65,6],[65,7,65,10],[60,1,60,2],[60,3,60,6],[60,7,60,10],[61,1,61,2],[61,3,61,6],[61,7,61,10],[62,1,62,2],[62,3,62,6],[62,7,62,10],[57,1,57,2],[57,3,57,6],[57,7,57,10],[58,1,58,2],[58,3,58,6],[58,7,58,10],[59,1,59,2],[59,3,59,6],[59,7,59,10],[56,7,56,10],[56,3,56,6],[56,1,56,2],[55,7,55,10],[55,3,55,6],[54,7,54,10],[54,3,54,6],[54,1,54,2],[55,1,55,2],[44,2,44,3],[44,4,44,6],[44,7,44,10],[45,2,45,3],[45,4,45,6],[45,7,45,10],[41,2,41,3],[41,4,41,6],[41,7,41,10],[42,2,42,3],[42,4,42,6],[42,7,42,10],[43,2,43,3],[43,4,43,6],[43,7,43,10],[38,2,38,3],[38,4,38,6],[38,7,38,10],[39,2,39,3],[39,4,39,6],[39,7,39,10],[40,2,40,3],[40,4,40,6],[40,7,40,10],[35,2,35,3],[35,4,35,6],[33,7,33,10],[34,7,34,10],[35,7,35,10],[36,2,36,3],[36,4,36,6],[36,7,36,10],[37,2,37,3],[37,4,37,6],[37,7,37,10],[31,2,31,3],[31,4,31,6],[31,7,31,10],[32,2,32,3],[32,4,32,6],[32,7,32,10],[33,2,33,3],[33,4,33,6],[34,2,34,3],[34,4,34,6],[22,7,22,10],[76,1,76,10],[5,1,5,3],[5,4,5,10],[47,1,47,10],[26,7,26,10],[27,7,27,10],[28,7,28,10],[8,4,8,5],[10,6,10,10],[48,1,48,2],[73,4,73,10],[51,7,51,10],[51,3,51,6],[20,7,20,10],[21,7,21,10],[21,4,21,6],[22,4,22,6],[20,1,20,3],[49,3,49,6],[30,7,30,10],[20,4,20,6],[49,7,49,10],[48,7,48,10],[26,2,26,3],[80,1,80,3],[80,6,80,10],[73,1,73,3],[72,1,72,10],[77,1,77,3],[80,4,80,5],[52,7,52,10],[53,1,53,2],[52,3,52,6],[53,3,53,6],[52,1,52,2],[70,3,70,10],[69,3,69,10],[28,2,28,3],[29,7,29,10],[69,1,69,2],[48,3,48,6],[30,4,30,6],[27,2,27,3],[70,1,70,2],[53,7,53,10],[28,4,28,6],[29,4,29,6],[99,1,99,6],[79,1,79,10],[83,6,83,10],[82,6,82,10],[86,4,86,5],[99,7,99,10],[89,4,89,10],[96,1,96,10],[90,8,90,9],[89,1,89,3],[95,1,95,10],[81,1,81,3],[81,6,81,10],[81,4,81,5],[83,4,83,5],[82,1,82,3],[82,4,82,5],[98,1,98,10],[86,1,86,3],[88,1,88,10],[86,6,86,10],[93,1,93,10],[90,4,90,6],[18,1,18,3],[51,1,51,2],[92,1,92,10],[90,1,90,3],[84,1,85,3],[85,4,85,10],[84,4,84,10],[74,1,74,3],[74,4,74,10],[83,1,83,3],[77,4,77,10],[22,1,22,3],[29,2,29,3],[30,2,30,3],[26,4,26,6],[27,4,27,6],[50,1,50,2],[50,7,50,10],[24,1,24,10],[19,7,19,10],[21,1,21,3],[19,4,19,6],[50,3,50,6],[25,7,25,10],[49,1,49,2],[0,1,0,10],[19,1,19,3],[13,1,13,10],[14,1,14,3],[12,1,12,10],[7,1,7,3],[25,2,25,3],[1,1,1,10],[3,1,3,3],[25,4,25,6],[4,1,4,3],[4,4,4,10],[7,4,7,5],[6,4,6,10],[18,4,18,6],[17,1,17,10],[18,7,18,10],[3,4,3,10],[6,1,6,3],[8,1,8,3],[15,4,15,10],[14,4,14,10],[10,1,10,3],[9,4,9,5],[1,11,7,11],[16,1,16,3],[15,1,15,3],[10,4,10,5],[9,1,9,3],[7,6,7,10],[8,6,8,10],[16,4,16,10],[2,2,2,3],[2,4,2,10],[9,6,9,10]]}
[null,"Standardized Information for Process/Product Change Notification (PCN)"]
[null,"1. PCN basic data",null,null,null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,"1.1 Company",null,null,null,null,null,null,null,null,null,null,null,null,"Abfrage Product Category"]
[null,"1.2 PCN No."]
[null,"1.3 Title of PCN"]
[null,"1.4 Product Category ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E6=O20,O9,IF(ISBLANK(E6),\"\",O10))","v":""}]
[null,"1.5 Issue date"]
[null,"1.6 PCN revision history (optional)\n",null,null,"1.7 Issue date of previous revision (optional)",null,"1.8 Delta to previous revision (optional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"active"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"passive"]
[]
[]
[null,"2. PCN Team",null,null,null,null,null,null,null,null,null,null,null,null,"Integrated Circuits"]
[null,"2.1 Contact supplier",null,null,null,null,null,null,null,null,null,null,null,null,"Discrete Semiconductors"]
[null,"2.1.1 Name \n",null,null,null,null,null,null,null,null,null,null,null,null,"Networks & Resistors"]
[null,"2.1.2 Phone\n",null,null,null,null,null,null,null,null,null,null,null,null,"Inductors"]
[null,"2.1.3 Email\n",null,null,null,null,null,null,null,null,null,null,null,null,"Quartz Crystal / SAW"]
[null,"2.2 Team supplier (optional)\n",null,null,null,null,null,null,null,null,null,null,null,null,"Ceramic / Tantalum"]
[null,"2.2.1 Name (optional)\n",null,null,"2.2.2 Phone (optional)\n",null,null,"2.2.3 Email (optional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"semiconductor components"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"passive and other electronic components"]
[]
[]
[]
[null,"3. Changes"]
[null,"No.","3.0 Ident",null,"3.1 Category",null,null,"3.2 Type of change"]
[]
[]
[null,"#3"]
[null,"#4",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"#5"]
[null,"#6"]
[null,"#7"]
[null,"#8"]
[null,"#9",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"#10"]
[null,"#11"]
[null,"#12"]
[null,"#13"]
[null,"#14",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"#15"]
[null,"#16"]
[null,"#17"]
[null,"#18"]
[null,"#19",null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"#20"]
[]
[null,"4. Description of change"]
[null,null,null,"Old",null,null,null,"New"]
[null,"Change #1"]
[null,"Change #2"]
[null,"Change #3"]
[null,"Change #4"]
[null,"Change #5"]
[null,"Change #6"]
[null,"Change #7"]
[null,"Change #8"]
[null,"Change #9"]
[null,"Change #10"]
[null,"Change #11"]
[null,"Change #12"]
[null,"Change #13"]
[null,"Change #14"]
[null,"Change #15"]
[null,"Change #16"]
[null,"Change #17"]
[null,"Change #18"]
[null,"Change #19"]
[null,"Change #20"]
[null,"4.1 Anticipated impact on form, fit, function, reliability or processability?"]
[null,"4.2 Reference parts with customer number (optional)"]
[]
[null,"5. Reason / motivation for change"]
[null,"5.1 Motivation",null,null," "]
[null,"5.2 Additional explanation (optional)"]
[]
[null,"6. Marking of parts / traceability of change"]
[null,"6.1 Description"]
[]
[null,"7. Timing / schedule"]
[null,"7.1 Date of qualification results"]
[null,"7.2 Last order date (optional)"]
[null,"7.3 Last delivery date (optional)"]
[null,"7.4 Intended start of delivery"]
[null,"7.5 Qualification samples available?"]
[]
[null,"7.6 Customer feedback required until"]
[]
[null,"8. Qualification / validation"]
[null,"8.1 Description\n(e.g. qual. plan/report, AEC-Q...)"]
[null,"8.2 Qualification report and qualification results",null,null,null,null,null,{"$f":"IF(E91=\"not applicable\",\" \",\"issue date\")","v":"issue date"},null,null,{"$f":"IF(E91=\"will be available at date:\",\"(expected)\",\" \")","v":" "}]
[]
[null,"9. Input to customer for risk assessment process"]
[]
[]
[null,"10. Attachments (e.g. new datasheet, additional documentation, pictures, process flow, sample plan, ...)"]
[]
[]
[null,"11. Affected parts"]
[null,"11.1 Current",null,null,null,null,null,"11.2 New (if applicable)"]
[null,"11.1.1 Customer Part No.\n","11.1.2 Supplier Part Name","11.1.3 \nSupplier Part No. (optional) ","11.1.4 Package Name","11.1.5 \nPart Description (optional)","11.1.6\nAdditional Part \nInformation (optional)","11.2.2 Supplier Part Name","11.2.3 \nSupplier Part No. (optional) ","11.2.4 Package Name","11.2.6\nAdditional Part \nInformation (optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"ExamplePCN","index":1,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[1,11,7,11],[2,2,2,3],[2,4,2,10],[3,1,3,3],[3,4,3,10],[4,1,4,3],[4,4,4,10],[5,1,5,3],[5,4,5,10],[6,1,6,3],[6,4,6,10],[7,1,7,3],[7,4,7,5],[7,6,7,10],[8,1,8,3],[8,4,8,5],[8,6,8,10],[9,1,9,3],[9,4,9,5],[9,6,9,10],[10,1,10,3],[10,4,10,5],[10,6,10,10],[12,1,12,10],[13,1,13,10],[14,1,14,3],[14,4,14,10],[15,1,15,3],[15,4,15,10],[16,1,16,3],[16,4,16,10],[17,1,17,10],[18,1,18,3],[18,4,18,6],[18,7,18,10],[19,1,19,3],[19,4,19,6],[19,7,19,10],[20,1,20,3],[20,4,20,6],[20,7,20,10],[21,1,21,3],[21,4,21,6],[21,7,21,10],[22,1,22,3],[22,4,22,6],[22,7,22,10],[24,1,24,10],[25,2,25,3],[25,4,25,6],[25,7,25,10],[26,2,26,3],[26,4,26,6],[26,7,26,10],[27,2,27,3],[27,4,27,6],[27,7,27,10],[29,1,29,10],[30,1,30,2],[30,3,30,6],[30,7,30,10],[31,1,31,2],[31,3,31,6],[31,7,31,10],[32,1,32,2],[32,3,32,6],[32,7,32,10],[33,1,33,2],[33,3,33,6],[33,7,33,10],[34,1,34,2],[34,3,34,6],[34,7,34,10],[35,1,35,2],[35,3,35,6],[35,7,35,10],[36,1,36,2],[37,1,37,2],[39,1,39,10],[40,1,40,3],[40,4,40,10],[36,3,36,6],[36,7,36,10],[37,3,37,6],[37,7,37,10],[41,1,41,3],[41,4,41,10],[43,1,43,10],[44,1,44,3],[44,4,44,10],[46,1,46,10],[47,1,47,3],[47,4,47,5],[47,6,47,10],[48,1,48,3],[48,4,48,5],[48,6,48,10],[49,1,49,3],[49,4,49,5],[49,6,49,10],[50,1,50,3],[50,4,50,5],[50,6,50,10],[51,1,52,3],[51,4,51,10],[52,4,52,10],[59,1,59,10],[60,1,60,10],[62,1,62,10],[63,1,63,10],[65,1,65,10],[66,1,66,6],[66,7,66,10],[53,1,53,3],[53,4,53,5],[53,6,53,10],[55,1,55,10],[56,1,56,3],[56,4,56,10],[57,1,57,3],[57,4,57,6],[57,8,57,9]]}
[null,"Standardized Information for Process/Product Change Notification (PCN)"]
[null,"1. PCN basic data",null,null,null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,"1.1 Company",null,null,"\nYour company’s name and address "]
[null,"1.2 PCN No.",null,null,"e.g. CM123456"]
[null,"1.3 Title of PCN",null,null,"e.g. Change of mold compound into green mold for SOT23"]
[null,"1.4 Product Category "]
[null,"1.5 Issue date",null,null,"2015-01-01"]
[null,"1.6 PCN revision history (optional)\n",null,null,"1.7 Issue date of previous revision (optional)",null,"1.8 Delta to previous revision (optional)"]
[null,"e.g. CM1234566",null,null,"2014-10-10",null,"e.g. Change of mold compound into green mold for D2PAK"]
[]
[]
[]
[null,"2. PCN Team"]
[null,"2.1 Contact supplier"]
[null,"2.1.1 Name \n",null,null,"Mr. Mustermann"]
[null,"2.1.2 Phone\n",null,null,"+49 123 456789"]
[null,"2.1.3 Email\n",null,null,"max.mustermann@newcompany.com"]
[null,"2.2 Team supplier (optional)\n"]
[null,"2.2.1 Name (optional)\n",null,null,"2.2.2 Phone (optional)\n",null,null,"2.2.3 Email (optional)"]
[null,"Carl Clever",null,null,"+49 123 987654",null,null,"carl.clever@newcompany.com"]
[]
[]
[]
[]
[null,"3. Changes"]
[null,"No.","3.0 Ident",null,"3.1 Category",null,null,"3.2 Type of change"]
[null,"#1","SEM-DS-02",null,"DATA SHEET",null,null,"Correction of data sheet / errata"]
[null,"#2","SEM-PA-11",null,"PROCESS - ASSEMBLY",null,null,"Change of mold compound"]
[]
[null,"4. Description of change"]
[null,null,null,"Old",null,null,null,"New"]
[null,"Change #1",null,"Old mold compound is not longer RoHS compatible. ",null,null,null," New mold compound will fulfill RoHS requirements."]
[null,"Change #2",null,"Old mold compound is not longer RoHS compatible. ",null,null,null,"New datasheet will give hint to RoHS compatibility."]
[null,"Change #3"]
[null,"Change #4"]
[null,"Change #5"]
[null,"4.6 Anticipated impact on form, fit, function, reliability or processability?",null,"e.g. Change in mold compound could have influence in reliability and processability / manufacturability."]
[null,"4.7 Reference parts with customer number (optional)",null,"e.g. PHB series, PSM series"]
[]
[null,"5. Reason / motivation for change"]
[null,"5.1 Motivation",null,null," e.g. Change to RoHS compatible mold compound because of legal restrictions."]
[null,"5.2 Additional explanation (optional)"]
[]
[null,"6. Marking of parts / traceability of change"]
[null,"6.1 Description",null,null,"e.g. Marking will added with the letter G."]
[]
[null,"7. Timing / schedule"]
[null,"7.1 Date of qualification results",null,null,"2010-06-01"]
[null,"7.2 Last order date (optional)",null,null,"2013-01-31"]
[null,"7.3 Last delivery date (optional)",null,null,"2013-06-30"]
[null,"7.4 Intended start of delivery",null,null,"2012-06-01"]
[null,"7.5 Qualification samples available?",null,null,"Yes, available (date and/or types):"]
[null,null,null,null,"e.g. BAS21"]
[null,"7.6 Customer feedback required until",null,null,"2012-02-01"]
[]
[null,"8. Qualification / validation"]
[null,"8.1 Description\n(e.g. qual. plan/report, AEC-Q...)",null,null,"e.g. AEC-Q101"]
[null,"8.2 Qualification report and qualification results",null,null,"available (see attachement)",null,null,{"$f":"IF(E58=\"not applicable\",\" \",\"issue date\")","v":"issue date"},null,null,{"$f":"IF(E58=\"will be available at date:\",\"(expected)\",\" \")","v":" "}]
[]
[null,"9. Input to customer for risk assessment process"]
[]
[]
[null,"10. Attachments (e.g. new datasheet, additional documentation, pictures, process flow, sample plan, ...)"]
[]
[]
[null,"11. Affected parts"]
[null,"11.1 Current",null,null,null,null,null,"11.2 New (if applicable)"]
[null,"11.1.1 Customer Part No.\n","11.1.2 Supplier Part Name","11.1.3 \nSupplier Part No. (optional) ","11.1.4 Package Name","11.1.5 \nPart Description (optional)","11.1.6\nAdditional Part \nInformation (optional)","11.2.2 Supplier Part Name","11.2.3 \nSupplier Part No. (optional) ","11.2.4 Package Name","11.2.6\nAdditional Part \nInformation (optional)"]
[null,890400001,"BAS10","555 444 002","SOT23","diode","see Chap. 10","BAS10-G","555 445 002","SOT23","see Chap. 10"]
[null,890400002,"BAS20","555 444 004","SOT23","diode","see Chap. 10","BAS20-G","555 445 004","SOT23","see Chap. 10"]
[null,890400003,"BAS30","555 444 006","SOT23","diode","see Chap. 10","BAS30-G","555 445 006","SOT23","see Chap. 10"]
[null,890400004,"BAS40","555 444 008","SOT23","diode","see Chap. 10","BAS40-G","555 445 008","SOT23","see Chap. 10"]
[null,890400005,"BAS50","555 444 010","SOT23","diode","see Chap. 10","BAS50-G","555 445 010","SOT23","see Chap. 10"]
[null,890400006,"BAS60","555 444 012","SOT23","diode","see Chap. 10","BAS60-G","555 445 012","SOT23","see Chap. 10"]
[null,890400007,"BZX84B01","556 434 010","SOT23","diode","see Chap. 10","BZX84B01-G","556 435 010","SOT23","see Chap. 10"]
[null,890400008,"BZX84B02","556 434 012","SOT23","diode","see Chap. 10","BZX84B02-G","556 435 012","SOT23","see Chap. 10"]
[null,890400009,"BZX84B03","556 434 014","SOT23","diode","see Chap. 10","BZX84B03-G","556 435 014","SOT23","see Chap. 10"]
[null,890400010,"BZX84B04","556 434 016","SOT23","diode","see Chap. 10","BZX84B04-G","556 435 016","SOT23","see Chap. 10"]
[null,890400011,"BZX84B05","556 434 018","SOT23","diode","see Chap. 10","BZX84B05-G","556 435 018","SOT23","see Chap. 10"]
[null,890400012,"BZX84B06","556 434 020","SOT23","doide","see Chap. 10","BZX84B06-G","556 435 020","SOT23","see Chap. 10"]
[null,890400013,"BZX84B07","556 434 022","SOT23","diode","see Chap. 10","BZX84B07-G","556 435 022","SOT23","see Chap. 10"]
[null,890400014,"BZX84B08","556 434 024","SOT23","diode","see Chap. 10","BZX84B08-G","556 435 024","SOT23","see Chap. 10"]
[null,890400015,"BZX84B09","556 434 026","SOT23","diode","see Chap. 10","BZX84B09-G","556 435 026","SOT23","see Chap. 10"]
[null,890400016,"BZX84B10","556 434 028","SOT23","diode","see Chap. 10","BZX84B10-G","556 435 028","SOT23","see Chap. 10"]

{"sheet":"Customer Feedback","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,1,27,8],[31,1,31,2],[28,1,28,2],[29,1,29,2],[30,3,30,8],[39,1,39,2],[32,3,32,8],[30,1,30,2],[31,3,31,8],[39,3,39,8],[37,1,37,2],[37,3,37,8],[36,1,36,2],[36,3,36,8],[33,1,33,8],[34,1,34,8],[38,1,38,2],[38,3,38,8],[32,1,32,2],[35,1,35,2],[35,3,35,8],[11,1,12,1],[11,2,11,8],[9,1,10,1],[21,1,22,1],[25,2,25,8],[24,2,24,4],[24,6,24,8],[20,2,20,8],[0,0,122,0],[1,1,1,8],[0,1,0,8],[2,1,2,8],[8,2,8,8],[26,1,26,8],[28,3,28,8],[7,2,7,8],[29,3,29,8],[3,3,3,4],[9,2,9,8],[17,2,17,8],[17,1,18,1],[24,1,25,1],[22,2,22,8],[21,2,21,8],[1,9,6,9],[3,1,3,2],[19,1,20,1],[3,5,3,6],[18,2,18,8],[15,2,16,8],[4,1,4,8],[15,1,16,1],[19,2,19,8],[3,7,3,8],[6,2,6,4],[6,6,6,8],[14,2,14,4],[14,6,14,8],[12,2,12,8],[10,2,10,8]]}
[null,"Customer Feedback/Approval Form"]
[null,"Title of PCN:",null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,{"$f":"IF(PCN!E5=\"\",\"\",PCN!E5)","v":""}]
[null,"Customer PCN No.",null,null,null,"Supplier PCN No.",null,{"$f":"IF(PCN!E4=\"\",\"\",PCN!E4)","v":""}]
[null,"Please check the appropriate box below:"]
[]
[null,null,"1. Feedback",null,null,"date:"]
[null,null,"We agree with this proposed change for the parts as listed in chapter '11. Affected parts'.\nApproval letter will be sent in written form.",null,null,null,null,null,null,null," "]
[null,null,"We agree with this proposed change schedule and will start with the PCN process. Approval letter will be sent in written form after evaluation."]
[null,null,"We disapprove because:"]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Remark:"]
[]
[]
[null,null,"2. Feedback",null,null,"date:"]
[null,null,"We acknowledge qualification / validation as assigned in chapter 8 of the PCN."]
[]
[null,null,"We need more information:",null,null,null,null,null,null,null," "]
[]
[null," ","We need the following samples:"]
[]
[null,null,"Estimated closing date for PCN:"]
[null," "]
[]
[null,null,"Final Feedback/Approval",null,null,"date:"]
[]
[]
[null,"Sender:                                        "]
[null,"Company:              "]
[null,"Name:"]
[null,"Address/Location:"]
[null,"Signature:                                                          "]
[null,"Date:"]
[]
[null,"Please return to: [your Sales partner]                          "]
[null,"Name:",null,{"$f":"IF(PCN!E15=\"\",\"\",PCN!E15)","v":""}]
[null,"Address/Location:"]
[null,"Phone:",null,{"$f":"IF(PCN!E16=\"\",\"\",PCN!E16)","v":""}]
[null,"Fax:"]
[null,"Email:",null,{"$f":"IF(PCN!E17=\"\",\"\",PCN!E17)","v":""}]

{"sheet":"Category","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,"Yes, available (date and/or types):",null,"Form  provided  by ZVEI - Revision 5.2"]
["Active Components – Integrated Circuits ",null,"not applicable because:","available (see attachement)"]
["Active Components – Discrete Components ",null,null,"will be available at date"]
["Optoelectronic Components - LED",null,null,"not applicable"]
["Optoelectronic Components - LD"]
["Optoelectronic Components - PD"]
["MCM"]
["Passive Components – Networks & Resisitors"]
["Passive Components – Inductors"]
["Passive Components – Ceramic / Tantalum"]
["Passive Components – Film Capacitors"]
["Passive Components – Quarz Crystal / SAW"]
["Passive Components – AL-Cap"]
["Passive Components – NTC"]
["Passive Components – PTC"]
["Passive Components – VDR"]
["MEMS"]

{"sheet":"Example Customer Feedback","index":4,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,1,4,8],[15,1,16,1],[6,2,6,4],[7,2,7,8],[8,2,8,8],[9,1,10,1],[9,2,9,8],[10,2,10,8],[6,5,6,6],[6,7,6,8],[14,7,14,8],[14,5,14,6],[0,0,122,0],[0,1,0,8],[1,1,1,8],[2,1,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[11,1,12,1],[11,2,11,8],[14,2,14,4],[17,1,18,1],[17,2,17,8],[18,2,18,8],[15,2,16,8],[12,2,12,8],[19,1,20,1],[19,2,19,8],[20,2,20,8],[21,1,22,1],[21,2,21,8],[22,2,22,8],[24,1,25,1],[24,2,24,4],[25,2,25,8],[24,7,24,8],[24,5,24,6],[32,3,32,8],[33,1,33,8],[34,1,34,8],[26,1,26,8],[27,1,27,8],[28,1,28,2],[28,3,28,8],[29,1,29,2],[29,3,29,8],[1,9,5,9],[38,1,38,2],[38,3,38,8],[39,1,39,2],[39,3,39,8],[35,1,35,2],[35,3,35,8],[36,1,36,2],[36,3,36,8],[37,1,37,2],[30,1,30,2],[30,3,30,8],[37,3,37,8],[31,1,31,2],[31,3,31,8],[32,1,32,2]]}
[null,"Customer Feedback/Approval Form"]
[null,"Title of PCN:",null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Customer PCN No.",null,"PCN4567",null,"Supplier PCN No.",null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Please check the appropriate box below:"]
[]
[null,null,"1. Feedback",null,null,"date:",null,"2012-01-28"]
[null,null,"We agree with this proposed change for the parts as listed in chapter 11. Affected parts.\nApproval letter will be sent in written form.",null,null,null,null,null,null,null," "]
[null,null,"We agree with this proposed change schedule and will start with the PCN Process. Approval letter will be sent in written form"]
[null,null,"We disapprove because:"]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Remark:"]
[null,null,"At the moment we do not agree to your change. We point out that refering to our specification the parts have to be delivered unchanged until the necessary measures at our company finished to assure quality and to introduce the change at our company, and you have got our agreement to deliver the changed version."]
[]
[null,null,"2. Feedback",null,null,"date:",null,"2012-02-14"]
[null,null,"We acknowledge acknowledge qualification / validation as assigned in chapter 8 of the PCN."]
[]
[null,null,"We need more information:",null,null,null,null,null,null,null," "]
[]
[null," ","We need the following samples:"]
[]
[null,null,"Estimated closing date for PCN:"]
[null," "]
[]
[null,null,"Final Feedback/Approval",null,null,"date:"]
[]
[]
[null,"Sender:                                        "]
[null,"Company:              "]
[null,"Name:"]
[null,"Address/Location:"]
[null,"Signature:                                                          "]
[null,"Date:"]
[]
[null,"Please return to: [your Sales partner]                          "]
[null,"Name:",null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Address/Location:"]
[null,"Phone:",null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"Fax:"]
[null,"Email:",null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"Information Note","index":5,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[2,2,2,3],[2,4,2,10],[3,1,3,3],[3,4,3,10],[7,1,7,10],[8,1,8,10],[9,1,9,3],[9,4,9,10],[4,1,4,3],[4,4,4,10],[5,1,5,3],[5,4,5,10],[10,1,10,3],[10,4,10,10],[11,1,11,3],[11,4,11,10],[12,1,12,10],[13,1,13,3],[13,4,13,6],[13,7,13,10],[14,1,14,3],[14,4,14,6],[14,7,14,10],[15,1,15,3],[15,4,15,6],[15,7,15,10],[20,1,20,10],[16,1,16,3],[16,4,16,6],[16,7,16,10],[17,1,17,3],[17,4,17,6],[17,7,17,10],[21,4,21,6],[21,7,21,10],[22,1,22,3],[22,4,22,6],[22,7,22,10],[30,4,30,10],[32,1,32,10],[23,1,23,3],[23,4,23,6],[23,7,23,10],[26,1,26,3],[26,4,26,6],[26,7,26,10],[24,1,24,3],[24,4,24,6],[24,7,24,10],[25,1,25,3],[25,4,25,6],[25,7,25,10],[1,11,8,11],[39,1,39,10],[41,1,41,10],[42,1,42,6],[42,7,42,10],[38,1,38,10],[36,1,36,3],[36,4,36,5],[36,6,36,10],[33,1,33,3],[33,4,33,10],[35,1,35,10],[28,1,28,10],[29,1,29,3],[29,4,29,10],[30,1,30,3]]}
[null,"Standardized Information Note (IN)"]
[null,"1. Information Note basic data",null,null,null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,"1.1 Company"]
[null,"1.2 Information Note  No."]
[null,"1.3 Title of IN"]
[null,"1.4 Issue date"]
[]
[null,"2. Contact"]
[null,"2.1 Contact supplier"]
[null,"2.1.1 Name \n"]
[null,"2.1.2 Phone\n"]
[null,"2.1.3 Email\n"]
[null,"2.2 Team supplier (optional)\n"]
[null,"2.2.1 Name (optional)\n",null,null,"2.2.2 Phone (optional)\n",null,null,"2.2.3 Email (optional)"]
[]
[]
[]
[]
[]
[]
[null,"3. Description "]
[null,null,null,null,"Old",null,null,"New"]
[null,"Description #1",null,null,null,null,null," "]
[null,"Description #2"]
[null,"Description #3"]
[null,"Description #4"]
[null,"Description #5"]
[]
[null,"4. Reason / motivation"]
[null,"4.1 Motivation",null,null," "]
[null,"4.2 Additional explanation (optional)"]
[]
[null,"5. Marking of parts / traceability"]
[null,"5.1 Description"]
[]
[null,"6. Timing / schedule"]
[null,"6.1 Intended start of delivery"]
[]
[null,"7. Attachments (e.g. additional documentation, pictures, part list….)"]
[]
[]
[null,"8. Affected parts"]
[null,"8.1 Current",null,null,null,null,null,"8.2 New (if applicable)"]
[null,"8.1.1 Customer Part No.\n","8.1.2 Supplier Part Name","8.1.3 \nSupplier Part No. (optional) ","8.1.4 Package Name","8.1.5 \nPart Description (optional)","8.1.6\nAdditional Part \nInformation (optional)","8.2.2 Supplier Part Name","8.2.3 \nSupplier Part No. (optional) ","8.2.4 Package Name","8.2.6\nAdditional Part \nInformation (optional)"]

{"sheet":"Example Information Note","index":6,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[41,1,41,10],[33,1,33,3],[33,4,33,10],[35,1,35,10],[42,1,42,6],[42,7,42,10],[36,1,36,3],[36,4,36,5],[36,6,36,10],[38,1,38,10],[39,1,39,10],[32,1,32,10],[25,1,25,3],[25,4,25,6],[25,7,25,10],[26,1,26,3],[26,4,26,6],[26,7,26,10],[28,1,28,10],[29,1,29,3],[29,4,29,10],[30,1,30,3],[30,4,30,10],[23,1,23,3],[23,4,23,6],[23,7,23,10],[24,1,24,3],[24,4,24,6],[24,7,24,10],[20,1,20,10],[21,4,21,6],[21,7,21,10],[22,1,22,3],[22,4,22,6],[22,7,22,10],[16,1,16,3],[16,4,16,6],[16,7,16,10],[17,1,17,3],[17,4,17,6],[17,7,17,10],[14,1,14,3],[14,4,14,6],[14,7,14,10],[15,1,15,3],[15,4,15,6],[15,7,15,10],[9,4,9,10],[11,1,11,3],[11,4,11,10],[12,1,12,10],[13,1,13,3],[13,4,13,6],[13,7,13,10],[10,1,10,3],[10,4,10,10],[9,1,9,3],[1,11,8,11],[0,1,0,10],[1,1,1,10],[2,2,2,3],[2,4,2,10],[3,1,3,3],[3,4,3,10],[4,1,4,3],[4,4,4,10],[5,1,5,3],[5,4,5,10],[7,1,7,10],[8,1,8,10]]}
[null,"Standardized Information Note (IN)"]
[null,"1. Information Note basic data",null,null,null,null,null,null,null,null,null,{"$f":"Category!E1","v":"Form  provided  by ZVEI - Revision 5.2"}]
[null,"1.1 Company",null,null,"ZVEI - Zentralverband Elektrotechnik- und Elektronikindustrie e.V. \n\nZVEI-German Electrical and Electronic Manufacturers`Association "]
[null,"1.2 Information Note  No.",null,null,"e.g.CM1234567"]
[null,"1.3 Title of IN",null,null,"e.g. New company lable and new colour of shipment boxes"]
[null,"1.4 Issue date",null,null,"2012-01-01"]
[]
[null,"2. Contact"]
[null,"2.1 Contact supplier"]
[null,"2.1.1 Name \n",null,null,"Mr. Mustermann"]
[null,"2.1.2 Phone\n",null,null,"+49 123 456789"]
[null,"2.1.3 Email\n",null,null,"max.mustermann@newcompany.com"]
[null,"2.2 Team supplier (optional)\n"]
[null,"2.2.1 Name (optional)\n",null,null,"2.2.2 Phone (optional)\n",null,null,"2.2.3 Email (optional)"]
[null,"Carl Clever",null,null,"+49 123 987654",null,null,"carl.clever@newcompany.com"]
[]
[]
[]
[]
[]
[null,"3. Description "]
[null,null,null,null,"Old",null,null,"New"]
[null,"Description #1",null,null,"zvei",null,null,"ZVEI"]
[null,"Description #2",null,null,"blue paper boxes (outer packaging)",null,null,"blue paper boxes with two red dots (outer packaging)"]
[null,"Description #3"]
[null,"Description #4"]
[null,"Description #5"]
[]
[null,"4. Reason / motivation"]
[null,"4.1 Motivation",null,null," e.g. New corporate design / corporate identity"]
[null,"4.2 Additional explanation (optional)"]
[]
[null,"5. Marking of parts / traceability"]
[null,"5.1 Description",null,null,"e.g. New corporate design / corporate identity"]
[]
[null,"6. Timing / schedule"]
[null,"6.1 Intended start of delivery",null,null,"2012-02-01"]
[]
[null,"7. Attachments (e.g. additional documentation, pictures, part list….)"]
[]
[]
[null,"8. Affected parts"]
[null,"8.1 Current",null,null,null,null,null,"8.2 New (if applicable)"]
[null,"8.1.1 Customer Part No.\n","8.1.2 Supplier Part Name","8.1.3 \nSupplier Part No. (optional) ","8.1.4 Package Name","8.1.5 \nPart Description (optional)","8.1.6\nAdditional Part \nInformation (optional)","8.2.2 Supplier Part Name","8.2.3 \nSupplier Part No. (optional) ","8.2.4 Package Name","8.2.6\nAdditional Part \nInformation (optional)"]
[null,"see \nchapter 7","see \nchapter 7",null,"see \nchapter 7",null,null,"see \nchapter 7",null,"see \nchapter 7"]