{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Overview","All Data"],"not_rendered":{"charts":1,"images":1,"macros":1,"defined_names":28},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"All Data","index":1,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[0,0,0,17],[1,0,1,17],[2,3,2,6],[4,13,5,15],[11,1,11,7]]}
["Maching Learning Example in MS Excel"]
["Please only change cells with WHITE backgrounds. Then RUN SOLVER.\nThe others coloured cells containg formulae. This contaings macros so please save-as and enable them GOOD LUCK"]
[{"$nulls":3},"Hidden Layers Data"]
["Training Data Points\nAngle in Degs","Expected O/P Sine","Angle in Radians","n1h1","n2h1","n1h2","n2h2","Output Sine\n by Network",null,"Output Accuracy \nof Network"]
[{"v":0,"d":"0.00"},{"$f":"SIN(C5)","v":{"v":0,"d":"0.00000000"}},{"$f":"RADIANS(A5)","v":0},{"$f":"sigmoid(C5*N$8-$P$8)","v":0.4996986425996008},{"$f":"sigmoid(D5*O$8-$P$8)","v":0.5531188505426948},{"$f":"sigmoid(SUMPRODUCT(D5*N$11+E5*$O$11)-$P$11)","v":0.1504561061650864},{"$f":"sigmoid(SUMPRODUCT(D5*E5,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F5:G5,$N$17:$O$17)-$P$17","v":{"v":-0.08695969188880603,"d":"-0.08695969"}},null,{"$f":"SUMXMY2(B5:B9,H5:H9)","v":{"v":0.1661630682258769,"d":"0.166163068226"}},null," ",null,"Hidden Layers\nWeights and Bias"]
[{"v":10,"d":"10.00"},{"$f":"SIN(C6)","v":{"v":0.17364817766693033,"d":"0.17364818"}},{"$f":"RADIANS(A6)","v":0.17453292519943295},{"$f":"sigmoid(C6*N$8-$P$8)","v":0.594428790556604},{"$f":"sigmoid(D6*O$8-$P$8)","v":0.5631463369443596},{"$f":"sigmoid(SUMPRODUCT(D6*N$11+E6*$O$11)-$P$11)","v":0.1655869870484982},{"$f":"sigmoid(SUMPRODUCT(D6*E6,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F6:G6,$N$17:$O$17)-$P$17","v":0.06200672516784378}]
[{"v":45,"d":"45.00"},{"v":0.7071067811865475,"d":"0.70710678"},{"$f":"RADIANS(A7)","v":0.7853981633974483},{"$f":"sigmoid(C7*N$8-$P$8)","v":0.8487189950289511},0.589788285969892,{"$f":"sigmoid(SUMPRODUCT(D7*N$11+E7*$O$11)-$P$11)","v":0.21219177461140115},{"$f":"sigmoid(SUMPRODUCT(D7*E7,O$11*$O$14)-$P$11)","v":0.0880807821312799},0.5208397749041074,{"$nulls":5},"W1","W2","b1"]
[{"v":70,"d":"70.00"},{"v":0.9396926207859083,"d":"0.93969262"},1.2217304763960306,0.9360378139000843,0.5988246227869589,{"$f":"sigmoid(SUMPRODUCT(D8*N$11+E8*$O$11)-$P$11)","v":0.2302547477760371},{"$f":"sigmoid(SUMPRODUCT(D8*E8,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F8:G8,$N$17:$O$17)-$P$17","v":{"v":0.6986732014216719,"d":"0.69867320"}},{"$nulls":5},{"v":2.1973498166628165,"d":"2.19734982"},{"v":0.42923001009622713,"d":"0.42923001"},{"v":1.2054297475602978E-3,"d":"0.00120543"}]
[{"v":90,"d":"90.00"},{"v":1,"d":"1.00000000"},1.5707963267948966,0.9692425780857781,0.6022436754103635,{"$f":"sigmoid(SUMPRODUCT(D9*N$11+E9*$O$11)-$P$11)","v":0.23740009847161145},{"$f":"sigmoid(SUMPRODUCT(D9*E9,O$11*$O$14)-$P$11)","v":0.0880807821312799},0.7690205460300013,{"$nulls":3}," "]
[{"$nulls":13},"W3","W4","b2"]
[{"$nulls":13},{"v":1.2,"d":"1.20000000"},{"v":0.011987377131369648,"d":"0.01198738"},{"v":2.33729703709491,"d":"2.33729704"},null," "]
[null,"Calculated/Learnt Values of Hidden Layers Fed Back into Neural Network"]
["Testing Data","Sine of angle","Angle in Radians","n1h1","n2h1","n1h2","n2h2","Output by Network",{"$nulls":5},"W5","W6"]
[0,{"$f":"SIN(C14)","v":0},{"$f":"RADIANS(A14)","v":0},{"$f":"sigmoid(C14*N$8-$P$8)","v":0.4996986425996008},{"$f":"sigmoid(D14*O$8-$P$8)","v":0.5531188505426948},{"$f":"sigmoid(SUMPRODUCT(D14*N$11+E14*$O$11)-$P$11)","v":0.1504561061650864},{"$f":"sigmoid(SUMPRODUCT(D14*E14,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F14:G14,$N$17:$O$17)-$P$17","v":-0.08695969188880603},{"$nulls":5},{"v":0,"d":"0.00000000"},{"v":0,"d":"0.00000000"}]
[10,{"$f":"SIN(C15)","v":0.17364817766693033},{"$f":"RADIANS(A15)","v":0.17453292519943295},{"$f":"sigmoid(C15*N$8-$P$8)","v":0.594428790556604},{"$f":"sigmoid(D15*O$8-$P$8)","v":0.5631463369443596},{"$f":"sigmoid(SUMPRODUCT(D15*N$11+E15*$O$11)-$P$11)","v":0.1655869870484982},{"$f":"sigmoid(SUMPRODUCT(D15*E15,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F15:G15,$N$17:$O$17)-$P$17","v":0.06200672516784378}]
[20,{"$f":"SIN(C16)","v":0.3420201433256687},{"$f":"RADIANS(A16)","v":0.3490658503988659},{"$f":"sigmoid(C16*N$8-$P$8)","v":0.6826147594282336},{"$f":"sigmoid(D16*O$8-$P$8)","v":0.5724351081983954},{"$f":"sigmoid(SUMPRODUCT(D16*N$11+E16*$O$11)-$P$11)","v":0.18074660845545132},{"$f":"sigmoid(SUMPRODUCT(D16*E16,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F16:G16,$N$17:$O$17)-$P$17","v":{"v":0.21125609817724156,"d":"0.21125610"}},{"$nulls":5},"W7","W8","b3"]
[30,0.49999999999999994,{"$f":"RADIANS(A17)","v":0.5235987755982988},{"$f":"sigmoid(C17*N$8-$P$8)","v":0.7593874656782635},{"$f":"sigmoid(D17*O$8-$P$8)","v":0.5804805632444362},{"$f":"sigmoid(SUMPRODUCT(D17*N$11+E17*$O$11)-$P$11)","v":0.1948068488726809},{"$f":"sigmoid(SUMPRODUCT(D17*E17,O$11*$O$14)-$P$11)","v":0.0880807821312799},{"$f":"SUMPRODUCT(F17:G17,$N$17:$O$17)-$P$17","v":{"v":0.3496818550151015,"d":"0.34968186"}},{"$nulls":5},{"v":9.845191314668519,"d":"9.84519131"},{"v":8.778249730038236e-15,"d":"0.00000000"},{"v":1.5682288415441599,"d":"1.56822884"}]
[45,{"$f":"SIN(C18)","v":0.7071067811865475},0.7853981633974483,{"$f":"sigmoid(C18*N$8-$P$8)","v":0.8487189950289511},0.589788285969892,0.21219177461140115,0.0880807821312799,{"$f":"SUMPRODUCT(F18:G18,$N$17:$O$17)-$P$17","v":0.5208397749041074}]
[50,{"$f":"SIN(C19)","v":0.766044443118978},0.8726646259971648,0.8717301901524045,0.5921757945680414,0.2168493553254191,0.0880807821312799,{"$f":"SUMPRODUCT(F19:G19,$N$17:$O$17)-$P$17","v":{"v":0.5666945480971248,"d":"0.56669455"}}]
[60,{"$f":"SIN(C20)","v":0.8660254037844386},1.0471975511965976,0.9088649397634817,0.5960194764858356,0.22452052290043883,0.0880807821312799,{"$f":"SUMPRODUCT(F20:G20,$N$17:$O$17)-$P$17","v":0.6422186604800755}]
[70,0.9396926207859083,1.2217304763960306,0.9360378139000843,0.5988246227869589,0.2302547477760371,0.0880807821312799,{"$f":"SUMPRODUCT(F21:G21,$N$17:$O$17)-$P$17","v":0.6986732014216719}]
[80,0.984807753012208,1.3962634015954636,0.9555054475357991,0.600830369782764,0.23442560272424426,0.0880807821312799,{"$f":"SUMPRODUCT(F22:G22,$N$17:$O$17)-$P$17","v":0.739736066332503}]
[90,1,1.5707963267948966,0.9692425780857781,0.6022436754103635,0.23740009847161145,0.0880807821312799,0.7690205460300013]
[]
[]
[]
[]
[]
[]
[{"$nulls":7}," "]
{"$rows_empty":17}
["andrewainger@hotmail.com"]