Training Dates - need to analysis them ...

[itr674]

I'm trying to figure out how to get started on code to analysis training dates.

We have a large number of people that have to be trained every year. I trying to find a way to show how many people must be training per month inorder to keep everyone trained without letting anyone go overdue training.

Below are the heading that I am currently using in he file. I don't have any code as of yet ...

'Persons Name    Office    Training Item    Training Completion Date     Next Due

'Person 1                                   10 Mar 02                    10 Mar 03

'Person 2                                   10 Apr 02                    10 Apr 03

'Person 3                                   01 Jan 02                    01 Jan 03

'Person 4                                   10 Jun 02                    10 Jun 03

[ This Message was edited by: em on 2002-10-19 06:41 ]

[plettieri]

Hello em


I read your post 4 times and I think a little more infomation would be needed to help you. What are the parameters of your coding, definition of overdue training, etc.

Care to post a spreadheet sample and your expected out come (most important)would be helpful. I see from your other posts that you have already been introduced to the Colo utility....it would sure help me better understand your requirement.

pll

[PaddyD]

number of people needed to be trained per month = number of people / 12 !

On the assumption that this isn't the correct answer, care to elaborate on the extra parameters we need to consider...


paddy

edit: plettieri - "snap"



[ This Message was edited by: PaddyD on 2002-10-19 08:25 ]

[itr674]

I wiil try to a spreadsheet example using colos--standby ...

[itr674]

I think I was putting to much thought into the project this morning, and think I have it figured out now, but would like a couple of things ...

1. What formula would return "5 months and 10 days" in one cell and "5 months / 160 days" in another cell.

Those two questions apply to cell C10 and 11 on the spreadsheet shown here.

******** ******************** ************************************************************************>

Microsoft Excel - 916 ARW DTTM1.xls ___Running: xl2000 : OS = Windows NT 4
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
C2D2C3D3C4D4C5D5C6D6C7D7C8C12D12 =
	A	B	C	D
2	*	Total*People*in*Organization*=	10	10
3	*	Total*People*Qualified*on*Task*Right*Now*(Quals*+*Within*90*Days)=	3	7
4	*	Total*People*Within*90*of*OverDue*=	2	4
5	*	Total*People*Overdue*Right*Now*=	4	*
6	*	Total*People*Awaiting*Initial*Training*(AIT)*=	2	2
7	*	Total*Peop*with*No*Training*Date*=	1	1
8	*	Today*=	19-Oct-02	*
9	*	Inspectors*Arrive*On:	1-Apr-03	1-May-03
10	*	Months*and*Days*Till*Inspectors*Arrive*=	month*and*days	months*and*day
11	*	Months*/*Days*Till*Inspectors*Arrive*=	month*/*days	months*/*days
12	How*Many*Peope*Must*be*Trained*Per*Month*To*be*Ready*When*Inspectors*Arrive:		1.1	0.3
13	*	*	Trn*Item*1	Trn*Item*2
14	Name	Office	1.**Date*Traing*Occurred 2.**Training*Interval*24*months	1.**Date*Traing*Occurred 2.**Training*Interval*12*Months
15	Person*1	*	01*Jan*02	01*Mar*02
16	Person*2	*	12*Jan*99	01*Mar*02
17	Person*3	*	12*Jan*99	01*Mar*02
18	Person*4	*	AIT	AIT
19	Person*5	*	AIT	AIT
20	Person*6	*	12*Jan*99	12*Jan*02
21	Person*7	*	12*Jan*99	12*Jan*02
22	Person*8	*	12*Jan*01	12*Jan*02
23	Person*9	*	12*Jan*01	12*Jan*02
24	Person*10	*	*	*
916 AGS - DTM (2) *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[ This Message was edited by: em on 2002-10-19 12:21 ]

[plettieri]

Try =DATE.DIFF(c8,c9,2)..for your first question ...this is an add on function found in http://longre.free.fr/english/

a similar function or a variation of the first may fit your needs on the second question. I am looking at that now


My answer came out with French abbbreviations...I may have downloaded the French version..

pll


[ This Message was edited by: plettieri on 2002-10-19 13:06 ]