modify the attached .xls macro to give the additional function for getting a forecast output value for the neural net based on a range of inputs
NN_Get(range) where 'range' is range of input columns
Instructions :- follow the instructions on the floating toolbar to 1) locate data 2) set hidden heurons, 3) settings 4) train
output values can be seen in column D of the sheet 'TRAINDATA' the required function should get the output if given an array of input values eg. =NN_Get(A24:C24)
1) Complete and fully-functional working program(s) in XLS form as well as complete source code of all work done.
MS excel 2002