{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[14,1,14,12],[22,1,22,12],[39,1,39,12],[63,1,63,12],[0,1,0,12]]}
[null,"ニューラルネットワーク構造"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ランダム（初期値に使用）"]
[null,null,"入力",null,null,null,null,"第1層"]
[null,null,"ｗ１","ｗ２","ｂ１",null,null,"ｗ１","ｗ２","ｗ３","ｂ１"]
["第1層","ｗ１",{"$f":"RAND()","v":0.28160986421740619},{"$f":"RAND()","v":0.99871808108978444},0.56732566180611588,"第2層","ｗ１",{"$f":"RAND()","v":0.74869240299487405},{"$f":"RAND()","v":0.7561865356577272},0.69689877102855136,0.41978896442282387]
[null,"ｗ２",{"$f":"RAND()","v":8.4535606465411917E-2},0.20390568608284765,0.87942494374609326,null,"ｗ２",{"$f":"RAND()","v":0.25115003162510829},0.79740654297456148,0.37850300689153948,0.72518013713620488]
[null,"ｗ３",0.99286680888624623,0.83191120622100501,0.93342626663524153]
[]
[]
[null,"→→→→→→順伝播"]
[]
[null,null,"入力値",null,null,"出力","ｼｸﾞﾓｲﾄﾞ",null,null,null,"出力","ｿﾌﾄﾏｯｸｽ","正解"]
[null,"ｘ１",1,null,"ｚ１",{"$f":"+C26*C35+C27*D35+E35","v":1.2379039942697214},{"$f":"1/(1+EXP(-F26))","v":0.77519896342025496},null,null,"ｚ１",{"$f":"+G26*H35+G27*I35+G28*J35+K35","v":2.1151819389967197},{"$f":"EXP(-1*K26)/(EXP(-1*K26)+EXP(-1*K27))","v":0.28003255802391669},{"$f":"IF(C29=0,1,0)","v":1}]
[null,"ｘ２",0,null,"ｚ２",{"$f":"+C26*C36+C27*D36+E36","v":1.4030002334512155},{"$f":"1/(1+EXP(-F27))","v":0.80265954869540546},null,null,"ｚ２",{"$f":"+G26*H36+G27*I36+G28*J36+K36","v":1.170881822552968},{"$f":"EXP(-1*K27)/(EXP(-1*K26)+EXP(-1*K27))","v":0.71996744197608331},{"$f":"IF(C29=1,1,0)","v":0}]
[null,null,null,null,"ｚ３",{"$f":"+C26*C37+C27*D37+E37","v":0.44731799827800411},{"$f":"1/(1+EXP(-F28))","v":0.61000137511687502}]
[null,"正解",0]
[null,"*)ｚ１=０、ｚ２＝１"]
[null,"学習率",0.1]
[]
[null,null,"入力",null,null,null,null,"第1層"]
[null,null,"ｗ１","ｗ２","ｂ１",null,null,"ｗ１","ｗ２","ｗ３","ｂ１"]
["第1層","ｗ１",0.61879669199920206,0.45790586134731714,0.61910730227051947,"第2層","ｗ１",0.68881918462398506,0.53127515997449604,0.77942144847104144,0.67932878559109133]
[null,"ｗ２",0.77218516438415552,0.4528714916154567,0.63081506906705997,null,"ｗ２",0.50170402209142317,0.203611893116179,0.18969633423631227,0.50281532970749376]
[null,"ｗ３",8.7872493291280218E-2,0.73968592486264539,0.3594455049867239]
[]
[]
[null,"逆伝播←←←←←"]
[null,null,null,null,null,"ｼｸﾞﾓｲﾄﾞ","出力",null,null,null,null,null,"誤差"]
[null,null,null,null,"ｚ１",{"$f":"1/(1+EXP(-G42))","v":0.53362836256862534},{"$f":"+M42*H48+M43*H49","v":0.13471682492350767},null,null,null,null,null,{"$f":"M26-+L26","v":0.71996744197608331}]
[null,null,null,null,"ｚ２",{"$f":"1/(1+EXP(-G43))","v":0.55870472000079707},{"$f":"+M42*I48+M43*I49","v":0.23590688406950927},null,null,null,null,null,{"$f":"M27-+L27","v":-0.71996744197608331}]
[null,null,null,null,"ｚ３",{"$f":"1/(1+EXP(-G44))","v":0.60457937151157348},{"$f":"+M42*J48+M43*J49","v":0.42458288196463145}]
[]
[null,null,"入力",null,null,null,null,"第1層"]
[null,null,"ｗ１","ｗ２","ｂ１",null,null,"ｗ１","ｗ２","ｗ３","ｂ１"]
["第1層","ｗ１",{"$f":"+C35","v":0.61879669199920206},{"$f":"+D35","v":0.45790586134731714},0.61910730227051947,"第2層","ｗ１",{"$f":"+H35","v":0.68881918462398506},0.53127515997449604,0.77942144847104144,0.67932878559109133]
[null,"ｗ２",{"$f":"+C36","v":0.77218516438415552},0.4528714916154567,0.63081506906705997,null,"ｗ２",0.50170402209142317,0.203611893116179,0.18969633423631227,0.50281532970749376]
[null,"ｗ３",{"$f":"+C37","v":8.7872493291280218E-2},{"$f":"+D37","v":0.73968592486264539},0.3594455049867239]
[]
[null,null,"入力",null,null,null,null,"第1層"]
[null,null,"ｗ１","ｗ２","ｂ１",null,null,"ｗ１","ｗ２","ｗ３","ｂ１"]
["第1層","ｗ１",{"$f":"+C26*F42","v":0.53362836256862534},{"$f":"+C27*G42","v":0},{"$f":"+F42","v":0.53362836256862534},"第2層","ｗ１",{"$f":"K26*G26","v":1.6396868465555021},{"$f":"K26*G27","v":1.6977709805637797},{"$f":"K26*G28","v":1.290263891410377},{"$f":"+M42","v":0.71996744197608331}]
[null,"ｗ２",{"$f":"+C26*F43","v":0.55870472000079707},{"$f":"+C27*G43","v":0},{"$f":"+F43","v":0.55870472000079707},null,"ｗ２",{"$f":"K27*G26","v":0.90766637513067971},{"$f":"K27*G27","v":0.93981947526601917},{"$f":"K27*G28","v":0.7142395218566634},{"$f":"+M43","v":-0.71996744197608331}]
[null,"ｗ３",{"$f":"+C26*F44","v":0.60457937151157348},{"$f":"+C27*G44","v":0},{"$f":"+F44","v":0.60457937151157348}]
[]
[null,null,"入力",null,null,null,null,"第1層"]
[null,null,"ｗ１","ｗ２","ｂ１",null,null,"ｗ１","ｗ２","ｗ３","ｂ１"]
["第1層","ｗ１",{"$f":"C48-(C54*$C$31)","v":0.56543385574233951},{"$f":"D48-(D54*$C$31)","v":0.45790586134731714},{"$f":"E48-(E54*$C$31)","v":0.56574446601365691},"第2層","ｗ１",{"$f":"H48-(H54*$C$31)","v":0.5248504999684348},{"$f":"I48-(I54*$C$31)","v":0.36149806191811806},{"$f":"J48-(J54*$C$31)","v":0.65039505933000374},{"$f":"K48-(K54*$C$31)","v":0.60733204139348296}]
[null,"ｗ２",{"$f":"C49-(C55*$C$31)","v":0.71631469238407586},{"$f":"D49-(D55*$C$31)","v":0.4528714916154567},{"$f":"E49-(E55*$C$31)","v":0.57494459706698031},null,"ｗ２",{"$f":"H49-(H55*$C$31)","v":0.41093738457835521},0.10962994558957707,{"$f":"J49-(J55*$C$31)","v":0.11827238205064593},{"$f":"K49-(K55*$C$31)","v":0.57481207390510214}]
[null,"ｗ３",{"$f":"C50-(C56*$C$31)","v":2.7414556140122864E-2},{"$f":"D50-(D56*$C$31)","v":0.73968592486264539},{"$f":"E50-(E56*$C$31)","v":0.29898756783556657}]