* begging table formula help
@ 2015-09-06 12:46 scrawler
[not found] ` <m2zj0zmsei.fsf@vpn-128-237-147-75.library.vpn.cmu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: scrawler @ 2015-09-06 12:46 UTC (permalink / raw)
To: orgmode list
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"
:-)
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: begging table formula help
[not found] ` <m2zj0zmsei.fsf@vpn-128-237-147-75.library.vpn.cmu.edu>
@ 2015-09-06 21:06 ` scrawler
0 siblings, 0 replies; 2+ messages in thread
From: scrawler @ 2015-09-06 21:06 UTC (permalink / raw)
To: orgmode list
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"
:-)
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2015-09-06 21:06 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2015-09-06 12:46 begging table formula help scrawler
[not found] ` <m2zj0zmsei.fsf@vpn-128-237-147-75.library.vpn.cmu.edu>
2015-09-06 21:06 ` scrawler
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).