{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Vorzeigemodell","Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vorzeigemodell","index":0,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,8,0,10],[1,8,1,10],[22,8,22,10],[23,8,23,10]]}
[null,null,null,null,null,null,null,null,"Bauteil 1"]
["POS","M","Sollmaß","oTol","uTol","Bemerkung",null,null,"Istmaß",null,null,null,"Gut","Schlecht"]
[1,"W",90,1,-1,"Funktionsmaß",null,null,null,null,null,null,"o","o","Sollten hier Zeilen I und K leer sein die Zellen von M und N löschen"]
[null,null,"Messteil 1",null,null,null,null,null,91,"-",92,null,"o","o","Weil hier in Zelle K die Toleranz rot ist und überschritten ist, muss in der Zelle N ein x stehen"]
[null,null,"Messteil 2",null,null,null,null,null,89,"-",90.5,null,"o","o","Weil hier in Zelle I und auch in Zelle K die Toleranz nicht überschritten werden muss in Zelle M ein x stehen"]
[null,null,"Messteil 3",null,null,null,null,null,87,"-",93,null,"o","o","Weil hier in Zelle I und auch in Zelle K die Toleranz übschritten wird, muss in Zelle N ein x stehen."]
[null,null,"Messteil 4",null,null,null,null,null,88,"-",91,null,"o","o","Weil in Zelle I das Bauteil außerhalb der Toleranz ist, obwohl in Zelle K okay muss dennoch ein x stehen in Zelle N"]
[null,null,"Messteil 5",null,null,null,null,null,91,"-",null,null,"o","o","Ein Wert in Zelle I ist okay und der in Zeile K ist leer…aber es stollte in der Zelle M ein x für gut stehen"]
[2,"W",45,1,-1,"Funktionsmaß",null,null,null,null,null,null,"o","o","Weil Zelle I bzw. K leer ist, müssen die Zeichen aus Zelle M und N gelöscht werden"]
[null,null,"Messteil 1",null,null,null,null,null,43,"-",46,null,"o","o"]
[null,null,"Messteil 2",null,null,null,null,null,45,"-",46.01,null,"o","o"," "]
[null,null,"Messteil 3",null,null,null,null,null,45.5,"-",45.78,null,"o","o"]
[null,null,"Messteil 4",null,null,null,null,null,43.99,"-",46.5,null,"o","o"]
[null,null,"Messteil 5",null,null,null,null,null,44,"-",46,null,"o","o"]
[3,"W",90,1,-1,null,null,null,88.99,null,null,null,"o","o","Bedingte Formatierung in Zeile I wie auch Zeile K vorhanden….Zeile I ist außerhalb und somit Zelle N mit x"]
[4,null,1,0.04,-0.04,null,null,null,1.04,null,null,null,"o","o","Bedingte Formatierung in Zeile I wie auch Zeile K vorhanden….Zeile I ist gut und somit Zelle M mit x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFO: alle Zellen bzw. je nach Nummer haben eine eigene bedingte Formatierung wenn nicht innerhalb der Toleranz"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["So sollte das Ergebnis aussehen:"]
[]
[null,null,null,null,null,null,null,null,"Bauteil 1",null,null,null,null,null,null," "]
["POS","M","Sollmaß","oTol","uTol","Bemerkung",null,null,"Istmaß",null,null,null,"Gut","Schlecht"]
[1,"W",90,1,-1,"Funktionsmaß"]
[null,null,"Messteil 1",null,null,null,null,null,91,"-",92,null,"o","x"]
[null,null,"Messteil 2",null,null,null,null,null,89,"-",90.5,null,"x","o"]
[null,null,"Messteil 3",null,null,null,null,null,87,"-",93,null,"o","x"]
[null,null,"Messteil 4",null,null,null,null,null,88,"-",91,null,"o","x"]
[null,null,"Messteil 5",null,null,null,null,null,91,null,null,null,"x","o"]
[2,"W",45,1,-1,"Funktionsmaß",null,null,null,null,null,null,"o","o"]
[null,null,"Messteil 1",null,null,null,null,null,43,"-",46,null,"o","x"]
[null,null,"Messteil 2",null,null,null,null,null,45,"-",46.01,null,"o","x"]
[null,null,"Messteil 3",null,null,null,null,null,45.5,"-",45.78,null,"x","o"]
[null,null,"Messteil 4",null,null,null,null,null,43.99,"-",46.5,null,"o","x"]
[null,null,"Messteil 5",null,null,null,null,null,44,"-",46,null,"x","o"]
[3,"W",90,1,-1,null,null,null,88.99,null,null,null,"o","x"]
[4,null,1,0.04,-0.04,null,null,null,1.04,null,null,null,"x","o"]

{"sheet":"Tabelle1","index":1,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,8,0,10],[1,8,1,10],[22,8,22,10],[23,8,23,10]]}
[null,null,null,null,null,null,null,null,"Bauteil 1"]
["POS","M","Sollmaß","oTol","uTol","Bemerkung",null,null,"Istmaß",null,null,null,"Gut","Schlecht"]
[1,"W",90,1,-1,"Funktionsmaß",null,null,null,null,null,null,null,null,"Sollten hier Zeilen I und K leer sein die Zellen von M und N löschen"]
[null,null,"Messteil 1",null,null,null,null,null,91,"-",92,null,"o","x","Weil hier in Zelle K die Toleranz rot ist und überschritten ist, muss in der Zelle N ein x stehen"]
[null,null,"Messteil 2",null,null,null,null,null,89,"-",90.5,null,"x","o","Weil hier in Zelle I und auch in Zelle K die Toleranz nicht überschritten werden muss in Zelle M ein x stehen"]
[null,null,"Messteil 3",null,null,null,null,null,87,"-",93,null,"o","x","Weil hier in Zelle I und auch in Zelle K die Toleranz übschritten wird, muss in Zelle N ein x stehen."]
[null,null,"Messteil 4",null,null,null,null,null,88,"-",91,null,"o","x","Weil in Zelle I das Bauteil außerhalb der Toleranz ist, obwohl in Zelle K okay muss dennoch ein x stehen in Zelle N"]
[null,null,"Messteil 5",null,null,null,null,null,91,"-",null,null,"o","x","Ein Wert in Zelle I ist okay und der in Zeile K ist leer…aber es stollte in der Zelle M ein x für gut stehen"]
[2,"W",45,1,-1,"Funktionsmaß",null,null,null,null,null,null,null,null,"Weil Zelle I bzw. K leer ist, müssen die Zeichen aus Zelle M und N gelöscht werden"]
[null,null,"Messteil 1",null,null,null,null,null,43,"-",46,null,"o","x"]
[null,null,"Messteil 2",null,null,null,null,null,45,"-",46.01,null,"o","x"," "]
[null,null,"Messteil 3",null,null,null,null,null,45.5,"-",45.78,null,"x","o"]
[null,null,"Messteil 4",null,null,null,null,null,43.99,"-",46.5,null,"o","x"]
[null,null,"Messteil 5",null,null,null,null,null,44,"-",46,null,"x","o"]
[3,"W",90,1,-1,null,null,null,88.99,null,null,null,"o","x","Bedingte Formatierung in Zeile I wie auch Zeile K vorhanden….Zeile I ist außerhalb und somit Zelle N mit x"]
[4,null,1,0.04,-0.04,null,null,null,1.04,null,null,null,"o","x","Bedingte Formatierung in Zeile I wie auch Zeile K vorhanden….Zeile I ist gut und somit Zelle M mit x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFO: alle Zellen bzw. je nach Nummer haben eine eigene bedingte Formatierung wenn nicht innerhalb der Toleranz"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["So sollte das Ergebnis aussehen:"]
[]
[null,null,null,null,null,null,null,null,"Bauteil 1",null,null,null,null,null,null," "]
["POS","M","Sollmaß","oTol","uTol","Bemerkung",null,null,"Istmaß",null,null,null,"Gut","Schlecht"]
[1,"W",90,1,-1,"Funktionsmaß"]
[null,null,"Messteil 1",null,null,null,null,null,91,"-",92,null,"o","x"]
[null,null,"Messteil 2",null,null,null,null,null,89,"-",90.5,null,"x","o"]
[null,null,"Messteil 3",null,null,null,null,null,87,"-",93,null,"o","x"]
[null,null,"Messteil 4",null,null,null,null,null,88,"-",91,null,"o","x"]
[null,null,"Messteil 5",null,null,null,null,null,91,null,null,null,"x","o"]
[2,"W",45,1,-1,"Funktionsmaß"]
[null,null,"Messteil 1",null,null,null,null,null,43,"-",46,null,"o","x"]
[null,null,"Messteil 2",null,null,null,null,null,45,"-",46.01,null,"o","x"]
[null,null,"Messteil 3",null,null,null,null,null,45.5,"-",45.78,null,"x","o"]
[null,null,"Messteil 4",null,null,null,null,null,43.99,"-",46.5,null,"o","x"]
[null,null,"Messteil 5",null,null,null,null,null,44,"-",46,null,"x","o"]
[3,"W",90,1,-1,null,null,null,88.99,null,null,null,"o","x"]
[4,null,1,0.04,-0.04,null,null,null,1.04,null,null,null,"x","o"]