begging table formula help

begging table formula help

[scrawler]

Hi Guys,

I might actually have a working, almost sane system that I can
understand and work with. May I beg some help?

| Student | Assgn Points | Points Earned | Possible | Achieved | Percentage |
|---------+--------------+---------------+----------+----------+------------|
| Barney  |           40 |    34.8       |   16     |   14     |    87      |
| Betty   |           40 |               |          |          |            |
| Fred    |           40 |               |          |          |            |
| Wilma   |           40 |               |          |          |            |

It might be obvious but, say, quizzes are worth 40 points. There are
16 questions on the quiz and Barney got 14 right. If I'm really nice,
would somebody concoct a table formula for me? Rounding would be
great. I fully expect to wrestle with formulas on my own at some
point, but it took me an inordinate amount of time to come up with the
table in the first place, so consequently I'm kind of pressed.

Have I mentioned how handsome/beautiful you look today? 


-- 
signature angry: "grrrrr"
:-)

Re: begging table formula help

[scrawler]

On Sun, Sep 06, 2015 at 12:20:05PM -0400, John Kitchin wrote:
> I assume you want to calculate the Points Earned and Percentage columns?
> 
> | Student | Assgn Points | Points Earned | Possible | Achieved | Percentage |
> |---------+--------------+---------------+----------+----------+------------|
> | Barney  |           40 |           35. |       16 |       14 |       87.5 |
> | Barney  |           40 |           35. |       16 |       14 |       87.5 |
> | Betty   |           40 |           30. |       16 |       12 |        75. |
> | Fred    |           40 |           25. |       16 |       10 |       62.5 |
> | Wilma   |           40 |          17.5 |       16 |        7 |      43.75 |
> #+TBLFM: $6 = ($5 / $4) * 100 ::  $3 = ($6 / 100) * $2

Yes, sorry, I looked at my email after I sent it and realized I wasn't
clear about that. Thank you very much for the formula. It's going into
production in about five minutes.
-- 
signature angry: "grrrrr"
:-)