Article View: be.comp.programming
Article #15221X workers, Y days, Z products, how to manage input & get productivity stats?
From: r3mix.net
Date: Tue, 07 Nov 2000 00:00
Date: Tue, 07 Nov 2000 00:00
38 lines
1834 bytes
1834 bytes
It's a classic problem, but I'm not educated or know an easy solution
myself.
I need to generate a small application that manages
Worker X {
prod A, #A, A% of total products
..
prod Z, #Z, Z% of total products
total production #, 100%
}
for each working day and each worker.
then I'd need a total (&avg) of all days for each worker (*)
and a total of all those, thus all workers all days + a deviation stat
for each worker compared to the global averages.
I tried fiddling around with some spreadsheets, but I find it very
annoying to have to keep copying the same table again and again and to
get (*).
I wouldn't have an idea how to add all those cells to my main stats.
Problem is that eg all stats are in cells C5:C15, C23:C33, C41:C51,
... (for each day). I cannot come up with an easy "SUM" statement to
simply add all these together.
any links, sources, ideas, references?
thanks very much and my apologies for my lack of education on this
issue.
(btw: nederlands=ok hoor)
--
up-to-date ripper & encoder info and the truth about MP3 quality
-> http://www.r3mix.net or http://r3mixnet.cjb.net
Technical Details
Message-ID:
<609g0t0ubund6i2lvqc71ptrgs6b11i532@4ax.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcea4,3b4f01a04b257deb,start X-Google-Attributes: gidfcea4,public From: r3mix.net <news@r3mix.net.net.net.net> Subject: X workers, Y days, Z products, how to manage input & get productivity stats? Date: 2000/11/07 Message-ID: <609g0t0ubund6i2lvqc71ptrgs6b11i532@4ax.com> X-Deja-AN: 690825780 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii X-Complaints-To: abuse@skynet.be X-Trace: news1.skynet.be 973612166 4760 62.4.197.183 (7 Nov 2000 15:49:26 GMT) Organization: http://www.r3mix.net Mime-Version: 1.0 NNTP-Posting-Date: 7 Nov 2000 15:49:26 GMT Newsgroups: be.comp.programming