🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #15221

X workers, Y days, Z products, how to manage input & get productivity stats?

#15221
From: r3mix.net
Date: Tue, 07 Nov 2000 00:00
38 lines
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-mail

Show 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