microsoft.public.word.vba.general

Sent it to me if you want and I will look at it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"jlewis" wrote in message
news:64329CCE-EBEB-4DD4-8B73-29BFC1B68D34@microsoft.com...
>I have created this Word doc with form fields. As a teacher enters credits
> into the first column of each term, Word form calculation fields adds up
> the
> credits and displays the cumulative credits at the top right corner of the
> page.
>
> I would have used Excel for this project, but the end user is only
> receptive
> to the Word document.
>
> I would like to auto-calculate the GPA. Here's how our district figures
> that out:
>
> Earned credit (Word FormField1c) * Grade Letter Points (WordFormField1g) =
> Value
> Add up all Values and then divide by number of Values
>
> (A+, A, A-)=4 points
> (B+, B, B-)=3 points
> (C+, C, C-)=2 points
> (D+, D, D-)=1 points
> (F)=0 points
>
> Example:
>
> .5*4 (for A-) English 9 = 2
> .5*3 (for B) Algebra = 1.5
>
> (2+1.5)/2= 1.75 GPA
>
> Credits and classes are added ongoing.
>
> I would like to send someone the Word doc that I have so far - if anyone
> is
> interested :) Thank you!!