Write a macro in eksel

Write a macro in eksel for the evaluation of General physical preparation (GPP).
There is an array of data (the file standards for physical training). In which there are the following parameters: age, gender, the result.
There is a file calculation evaluation for certification (the exam file