microsoft.public.word.vba.general

It's in my response, but here it is dkr@REMOVECAPSmvps.org

--
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:94AFBBC0-58EB-465F-A6EA-1899ED6298F7@microsoft.com...
> 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!!
>>
>>
>>