{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["WettbewerbsLernen","ZSP"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"WettbewerbsLernen","index":0,"n_rows":27,"n_cols":29,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,1,29],[19,10,19,25],[18,10,18,25]]}
[null,"Beispiel zum WettbewerbsLernen entsprechend der Publikation:\n \"Private Kollektive Finanzdienstleister 2007\""]
[]
[null,null,null,null,"Init:",null,{"$f":"+IF(ZSP!$F$2=1,I25,IF(ZSP!$F$2=2,Q25,X25))","v":1},{"$f":"+IF(ZSP!$F$2=1,J25,IF(ZSP!$F$2=2,R25,Y25))","v":0},{"$f":"+IF(ZSP!$F$2=1,K25,IF(ZSP!$F$2=2,S25,Z25))","v":1},null,0.28978414868843011,0,0.23581157933491331,null,null,null,null,null,null,null,{"$f":"+IF($Q$10=1,$AA$10,K$3)","v":0.14647179508517527},{"$f":"+IF($Q$10=2,$AA$10,L$3)","v":0},{"$f":"+IF($Q$10=3,$AA$10,M$3)","v":0.23581157933491331}]
[null,null,null,null,null,null,{"$f":"+IF(ZSP!$F$2=1,I26,IF(ZSP!$F$2=2,Q26,X26))","v":0},{"$f":"+IF(ZSP!$F$2=1,J26,IF(ZSP!$F$2=2,R26,Y26))","v":1},{"$f":"+IF(ZSP!$F$2=1,K26,IF(ZSP!$F$2=2,S26,Z26))","v":0},null,0,1,0.55906885852011046,null,null,null,"<",null,null,null,{"$f":"+IF($Q$10=1,$AB$10,K$4)","v":0},{"$f":"+IF($Q$10=2,$AB$10,L$4)","v":1},{"$f":"+IF($Q$10=3,$AB$10,M$4)","v":0.55906885852011046}]
[null,null,null,null,null,null,{"$f":"+IF(ZSP!$F$2=1,I27,IF(ZSP!$F$2=2,Q27,X27))","v":1},{"$f":"+IF(ZSP!$F$2=1,J27,IF(ZSP!$F$2=2,R27,Y27))","v":0},{"$f":"+IF(ZSP!$F$2=1,K27,IF(ZSP!$F$2=2,S27,Z27))","v":1},null,0.95709202648905289,0,0.79488043785502382,null,null,null,null,null,null,null,{"$f":"+IF($Q$10=1,$AC$10,K$5)","v":0.98921484685811634},{"$f":"+IF($Q$10=2,$AC$10,L$5)","v":0},{"$f":"+IF($Q$10=3,$AC$10,M$5)","v":0.79488043785502382}]
[]
[]
[null,null,"Parameter:",null,null,null,null,"Eingabe u:",null,null,null,"Ausgabe",null,null,null,null,"Sieger",null,null,null,null,"w(neu)",null,null,"Norm",null,null,"w-Norm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Lernrate:",null,null,null,0,0,1,null,{"$f":"+$G10*K$3+$H10*K$4+$I10*K$5","v":0.95709202648905289},{"$f":"+$G10*L$3+$H10*L$4+$I10*L$5","v":0},{"$f":"+$G10*M$3+$H10*M$4+$I10*M$5","v":0.79488043785502382},null,null,null,{"$f":"+IF(K10=MAX(K10:M10),1,IF(L10=MAX(K10:M10),2,3))","v":1},null,null,null,{"$f":"+IF($Q10=1,$K$3+$C$11*(G10-$K$3),IF($Q10=2,$L$3+$C$11*(G10-$L$3),$M$3+$C$11*(G10-$M$3)))","v":0.14489207434421505},{"$f":"+IF($Q10=1,$K$4+$C$11*(H10-$K$4),IF($Q10=2,$L$4+$C$11*(H10-$L$4),$M$4+$C$11*(H10-$M$4)))","v":0},{"$f":"+IF($Q10=1,$K$5+$C$11*(I10-$K$5),IF($Q10=2,$L$5+$C$11*(I10-$L$5),$M$5+$C$11*(I10-$M$5)))","v":0.9785460132445265},null,{"$f":"+IF(Y9=1,SQRT(U10*U10+V10*V10+W10*W10),SUM(U10:W10))","v":0.98921484685811634},null,{"$f":"+U10/$Y10","v":0.14647179508517527},{"$f":"+V10/$Y10","v":0},{"$f":"+W10/$Y10","v":0.98921484685811634}]
[null,null,0.5]
[null,null,"Darbietungen"]
[null,null,1,null,null,null,null,"Trainingsdaten u:"]
[null,null,"Vorwärts (0/1):",null,null,null,1,0,2,null,{"$f":"+$G14*K$3+$H14*K$4+$I14*K$5","v":2.2039682016665361},0,1.825572455044961,null,null,null,{"$f":"+IF(K14=MAX(K14:M14),1,IF(L14=MAX(K14:M14),2,3))","v":1},null,null,null,"Zum Trainieren des Netzes Makros aktivieren!"]
[null,null,1,null,null,null,1,1,2,null,2.2039682016665361,1,2.3846413135650715,null,null,null,{"$f":"+IF(K15=MAX(K15:M15),1,IF(L15=MAX(K15:M15),2,3))","v":3}]
[null,null,"Lernfaktor",null,null,null,0,1,1,null,0.95709202648905289,1,1.3539492963751343,null,null,null,{"$f":"+IF(K16=MAX(K16:M16),1,IF(L16=MAX(K16:M16),2,3))","v":3}]
[null,null,1,null,null,null,0,0,1,null,0.95709202648905289,0,0.79488043785502382,null,null,null,{"$f":"+IF(K17=MAX(K17:M17),1,IF(L17=MAX(K17:M17),2,3))","v":1}]
[]
[null,null,"Download der Publikation:",null,null,null,null,null,null,null,"Private Kollektive Finanzdienstleister 2007"]
[]
[]
[null,null,null,null,null,null,"Eingangsvektoren",null,null,null,null,null,null,"Siegerknoten",null,null,null,null,null,null,"Siegerknoten",null,null,null,null,null,null,"Siegerknoten"]
[null,null,null,null,null,null,null,null,null,"Init W",null,null,null,null,null,null,null,"Init W",null,null,null,null,null,null,"Init W"]
[null,null,"Ergebnisse:",null,null,null,"u1","W1",null,null,null,null,3,null,null,"W2",null,null,null,null,1,null,"W3",null,null,null,null,1]
[null,null,null,null,null,null,"u2",null,1,0,0,null,3,null,null,null,1,0,1,null,3,null,null,1,0,1,null,3]
[null,null,null,null,null,null,"u3",null,0,1,0,null,3,null,null,null,0,1,1,null,2,null,null,0,1,0,null,3]
[null,null,null,null,null,null,"u4",null,0,0,1,null,3,null,null,null,1,1,1,null,1,null,null,1,0,1,null,1]

{"sheet":"ZSP","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,"Parameter:","Zeile","Spalte","ParameterWerte:"]
[null,null,"Init-MatrixNr",{"$f":"+ROW(WettbewerbsLernen!$C$19)","v":19},{"$f":"+COLUMN(WettbewerbsLernen!$C$19)","v":3},3]
[null,null,"Lernrate",{"$f":"+ROW(WettbewerbsLernen!$C$11)","v":11},{"$f":"+COLUMN(WettbewerbsLernen!$C$11)","v":3},{"$f":"+WettbewerbsLernen!C11","v":0.5}]
[null,null,"Norm",{"$f":"+ROW(WettbewerbsLernen!$Y$9)","v":9},{"$f":"+COLUMN(WettbewerbsLernen!$Y$9)","v":25},{"$f":"+WettbewerbsLernen!Y9","v":1}]
[null,null,"Trainingsdaten #",null,null,4]
[null,null,"Vorwärts/Rückwärts",{"$f":"+ROW(WettbewerbsLernen!$C$15)","v":15},{"$f":"+COLUMN(WettbewerbsLernen!$C$15)","v":3},{"$f":"+WettbewerbsLernen!C15","v":1}]
[null,null,"Darbietungen",{"$f":"+ROW(WettbewerbsLernen!$C$13)","v":13},{"$f":"+COLUMN(WettbewerbsLernen!$C$13)","v":3},{"$f":"+WettbewerbsLernen!C13","v":1}]
[null,null,"Eingabe",{"$f":"+ROW(WettbewerbsLernen!$G$10)","v":10},{"$f":"+COLUMN(WettbewerbsLernen!$G$10)","v":7},{"$f":"+WettbewerbsLernen!G10","v":0}]
[null,null,"InitMatrix_Anf",{"$f":"+ROW(WettbewerbsLernen!$G$3)","v":3},{"$f":"+COLUMN(WettbewerbsLernen!$G$3)","v":7},{"$f":"+WettbewerbsLernen!G3","v":1}]
[null,null,"InitMatrix_Ende",{"$f":"+ROW(WettbewerbsLernen!$I$5)","v":5},{"$f":"+COLUMN(WettbewerbsLernen!$I$5)","v":9},{"$f":"+WettbewerbsLernen!I5","v":1}]
[null,null,"TrainingSatz1",{"$f":"+ROW(WettbewerbsLernen!$G$14)","v":14},{"$f":"+COLUMN(WettbewerbsLernen!$G$14)","v":7},{"$f":"+WettbewerbsLernen!G14","v":1}]
[null,null,"MatDim",null,null,{"$f":"+E10-E9+1","v":3}]
[null,null,"Sieger",{"$f":"+ROW(WettbewerbsLernen!$Q$10)","v":10},{"$f":"+COLUMN(WettbewerbsLernen!$Q$10)","v":17},{"$f":"+WettbewerbsLernen!Q10","v":1}]
[null,null,"AlleSieger_Anf",{"$f":"+ROW(WettbewerbsLernen!$Q$14)","v":14},{"$f":"+COLUMN(WettbewerbsLernen!$Q$14)","v":17},{"$f":"+WettbewerbsLernen!Q14","v":1}]
[null,null,"Hilf_ItMat_Anf",{"$f":"+ROW(WettbewerbsLernen!$U$3)","v":3},{"$f":"+COLUMN(WettbewerbsLernen!$U$3)","v":21},{"$f":"+WettbewerbsLernen!U3","v":0.14647179508517527}]
[null,null,"LeerRaum ItMat",null,null,{"$f":"+E15-E10-1-F12-1","v":7}]
[null,null,"Lernratenfaktor",17,3,{"$f":"+WettbewerbsLernen!C17","v":1}]