{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["XOR-Net","Delta-Rule"],"not_rendered":{"charts":0,"images":1,"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":"XOR-Net","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"XOR-Netzwerk"]
[null,1,null,null,null,null,null,2]
[null,null,0,null,null,null,1]
[]
[null,null,null,1,null,1]
[null,null,null,{"$f":"D6*C4","v":0},null,{"$f":"F6*G4","v":1}]
[]
[null,null,null,3]
[null,null,null,1,{"$f":"D7+F7","v":1},1]
[null,null,null,{"$f":"D10*C4","v":0},1.5,{"$f":"F10*G4","v":1}]
[null,null,null,null,{"$f":"IF(E10>=1.5,1,0)","v":0}]
[]
[null,null,null,null,-2]
[null,null,null,null,{"$f":"E14*E12","v":0}]
[]
[]
[null,null,null,4,{"$f":"D11+F11+E15","v":1}]
[null,null,null,null,0.5]
[null,null,null,null,{"$f":"E18>=E19","v":true}]

{"sheet":"Delta-Rule","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"Perzeptron: Delta-Regel",null,null,null,null,null,null,"Uwe Lämmel"]
[null,null,null,"Eingabe: ","Binärzahl",null,null,null,null,"Hochschule Wismar"]
[null,null,null,"Ausgabe:","Dezimalwert",null,null,null,null,"Fakultät für Wirtschaftswissenschaften"]
["2019-09-02"]
[null,null,null,null,"AusgabeNeuronen"]
[null,null,"Eingabe",null,1,2,3,4,5,6,7,8,9]
[null,{"$f":"B15","v":2},{"$f":"MOD(B7,2)","v":0},null,1,0,0,-1,-1,-1,0,0,0]
[null,{"$f":"INT(B7/2)","v":1},{"$f":"MOD(B8,2)","v":1},null,1,1,1,0,0,0,0,0,0]
[null,{"$f":"INT(B8/2)","v":0},{"$f":"MOD(B9,2)","v":0},null,1,1,1,1,1,1,0,0,0]
[null,{"$f":"INT(B9/2)","v":0},{"$f":"MOD(B10,2)","v":0},null,0,0,0,0,0,0,0,0,0]
[null,null,null,"Bias:",0,0,0,0,0,0,0,0,0]
[null,null,null,"Ergebnis:",{"$f":"IF($C7*E7+$C8*E8+$C9*E9+$C10*E10>E11,1,0)","v":1},{"$f":"IF($C7*F7+$C8*F8+$C9*F9+$C10*F10>F11,1,0)","v":1},1,0,0,0,0,0,0]
[null,null,null,"Teaching Input:",{"$f":"IF($C7+2*$C8+4*$C9+8*$C10>=E6,1,0)","v":1},{"$f":"IF($C7+2*$C8+4*$C9+8*$C10>=F6,1,0)","v":1},0,0,0,0,0,0,0]
[]
["Muster:",2,null,"Änderungswerte"]
["Lernrate:",1," ",null,{"$f":"$B$16*$C7*(E$13-E$12)","v":0},{"$f":"$B$16*$C7*(F$13-F$12)","v":0},0,0,0,0,0,0,0]
["Fehler:",{"$f":"SUMX2MY2(E12:M12,E13:M13)","v":1},null,null,{"$f":"$B$16*$C8*(E$13-E$12)","v":0},{"$f":"$B$16*$C8*(F$13-F$12)","v":0},-1,0,0,0,0,0,0]
[null,null,null,null,{"$f":"$B$16*$C9*(E$13-E$12)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"$B$16*$C10*(E$13-E$12)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"neue Gewichte"]
[null,null,null,null,{"$f":"E7+E16","v":1},{"$f":"F7+F16","v":0},0,-1,-1,-1,0,0,0]
[null,null,null,null,{"$f":"E8+E17","v":1},1,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E9+E18","v":1},1,1,1,1,1,0,0,0]
[null,null,null,null,{"$f":"E10+E19","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Problem: ","Änderung der Bias-Werte?"]
[null,null,null,"Stets nur +/- Lernfaktor"]
[]
[null,null,"Kommentar: ","Das Netz ist untrainiert."]
[null,null,null,"Mit einer Lernrate von 1,0 bekommt man kein Ergebnis."]
[null,null,null,"Die Gewichte schwanken von 0,0 auf 1,0 und zurück."]
[null,null,null,"Eine kleinere Lernrate (0,2) bringt gute Ergebnisse."]
[]
[null,null,"Vorgehen:","- Setzen Sie ein Muster (Zahl zwischen 0 und 9)"]
[null,null,null,"- Führen Sie einen Lernschritt aus"]
[null,null,null,"- Probieren Sie, ob die vorher gelernten Zahlen noch erkannt werden"]
[null,null,null,"- Verändern Sie die Lernrate und prbieren Sie erneut"]