Hi to all!! My knowledge is very limited to whats out there software wise and have done general google searches to find what Im trying to look for. Maybe I'm looking for the wrong thing?? Im after a software to keep track of figures and alert me when certain occuraces happen. I got i feeling that I'll need a spreadsheet package to automate an alert for me after so much data is inputted using formulae and a database perhaps intergrated with the spreadsheet to simplify the inputting of the data. Am I on the right lines? If not or if so how can i do this? Many thanks and kind regards for taking interest From a very simple guy
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 ?[ot]although, the last time i seriously used a spreadsheet or database was about 12 years ago[/ot]so, this is coming from my stupid memory yes
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??
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
