microsoft.public.word.vba.general

OK.... I can't figure out a way to send the actual file. Here's a link to
it, though. If that's going outside the realm of the newsgroup, I totally
understand and I'll keep plugging away at it. Thanks!

http://www.sdb.k12.wi.us/lewis/ILP.doc



"Doug Robbins - Word MVP" wrote:

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