Adobe Java Script Calculations

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
I have an Excel sheet that I converted into a fillable PDF using Adobe Pro X. My problem is the formulas do not carry over.

I need to write 2 scripts. One to calculate the final summative rating which is based on values that are weighted differently.

Professional Practice Rating (value * 5)
Self-Assessment Rating (value * 1)
Student Growth Rating: Academic (value * 3)
Student Growth Rating: Other (Value * 1)
Then the total of that is /10 to equal the Final Summative Rating.

The second script is an IF statement. If the Final Summative Rating value =X, then the Rating is Y

If Final Summative Rating is [url removed, login to view] and [url removed, login to view] and [url removed, login to view] = excellent

Skills required:
Adobe LiveCycle Designer, Javascript
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 185
in 7 days
$ 115
in 3 days
$ 166
in 0 days
$ 133
in 3 days
$ 144
in 3 days
$ 35
in 1 days
$ 155
in 3 days
$ 77
in 2 days