microsoft.public.word.vba.general

Thanks, Doug. I don't see a way to upload it here. Can you give me your
email address please? Thanks again! Janet

"Doug Robbins - Word MVP" wrote:

> 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!!
>
>
>