You have chosen to sponsor your bid up to a maximum amount of .
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