Tilted Forum Project Discussion Community - View Single Post

Gatorade Frost · 10-19-2005, 06:57 AM

I'm working out my midterm grades right now and want to set up an excel spread sheet that I'll be able to put in my grades and it'll factor everything for me. Right now this is what I have:

What I'm wanting to do is be able to change the A, B, C, and D (well, A, B, and C) on there so that when I change it, it makes Pts equal to A*(A-Hrs)=pts

And A=4, B=3, C=2, and D=1.

So essentially in a 3 hour class that I have a B in it'll do the math for me and under Pts it'll show up at 9.0 for me without having to do the math.

That way I'll have an automated way to do my midtrm grades and always have an up to date system with minimal work.

I think my wording is slightly confusing, so if you have questions please ask.

Thanks in advance

10-19-2005, 06:57 AM	#1 (permalink)
Gatorade Frost Rookie	Excel Set up for a Transcript I'm working out my midterm grades right now and want to set up an excel spread sheet that I'll be able to put in my grades and it'll factor everything for me. Right now this is what I have: What I'm wanting to do is be able to change the A, B, C, and D (well, A, B, and C) on there so that when I change it, it makes Pts equal to A*(A-Hrs)=pts And A=4, B=3, C=2, and D=1. So essentially in a 3 hour class that I have a B in it'll do the math for me and under Pts it'll show up at 9.0 for me without having to do the math. That way I'll have an automated way to do my midtrm grades and always have an up to date system with minimal work. I think my wording is slightly confusing, so if you have questions please ask. Thanks in advance __________________ I got in a fight one time with a really big guy, and he said, "I'm going to mop the floor with your face." I said, "You'll be sorry." He said, "Oh, yeah? Why?" I said, "Well, you won't be able to get into the corners very well." Emo Philips