simple question from simple guy

donkey42

a spreadsheet would be able to keep track of figures and possibly log those certain occurrences in a database or notify you by email

BTW: what exactly are you trying to achieve ?so, this is coming from my stupid memoryyes

__________________

simpleton

I cant realy explain what I'm trying to achieve because it concerns a business me and a partner are trying to setup and respectfully I have been sworn to secrecy till we're well on our way and this probably makes it hard to find out what I need to do about this but I'll try n explain this as best as possible using 'letters'....

say for example i got 12 employee's denoted by the first twelve letters of the alphabet:

a b c d e f g h i j k l

and you split the letters into 4 groups/teams:

group 1 - a b c
group 2 - d e f
group 3 - g h i
group 4 - j k l

I wana keep an eye on each groups performance...
say for example they all pack boxes and whichever employee packs the least they get input into the database

i.e.

day 1 - a
day 2 - e
day 3 - i

which would translate to

day 1 - group 1
day 2 - group 2
day 3 - group 3

I want to be notified when a group has not apeared more than say 4 times and for every consecutive time after that.

i.e.

day 1 - a - group 1
day 2 - b - group 1
day 3 - c - group 1
day 4 - d - group 2
day 5 - e - group 2
day 6 - f - group 2
day 7 - g - group 3

therefore...
from day 1-4 there has been no group 3 so i want to be automatically informed on day 5 about group 3 and give them say £1 bonus (perhaps be informed on another field on a database with "pay £1 to group 3). Then again be informed of group 3 on day 6 but give them a £2 bonus instead of £1 for having a 2 day streak after the 4 day period initialy accumilated (the higher the streak of days the higher the bonus per day). On day 7 where group 3 comes to notice they have to accumilate 4 days again so the cycle starts again. Say for example if group 1 was to come to notice 5 days in a row then both group 2 and 3 would get a bonus as both groups qualify for not comming to notice for at least 4 days.

I hope this is not too complicated but I have done this before at school many many years ago but this was in a time when windows OS PC's wernt being used and was conducting this on Acorn computers on RISC OS.

I know I can do all this on a piece of paper and have been, but, with all the other crap I gotta do and the continuous times I get it wrong because of the lack of sleep I get it would make my life so much easier to be able to input this stuff into a field on a database which would accumilate the data and automate the results 4 me.

The example I have given is the best I can give and is of the exact principal of the real model.

So can anyone point me in the right direction at all please??

donkey42

i think a spreadsheet can do everything you want to do, all the database would be doing is keeping a record of payment made to people, well, actually a spreadsheet can recreate the payments made and then you could output the results to a database, to keep records

so, yes, a spreadsheet is all you need

__________________

simpleton

ta