Internal Fleet Scheduling Process

 

Internal Fleet Scheduling Process

Looking for anyone who is willing to share and discuss their internal scheduling processes. We would like to compare processes and look for possible enhancements and/or improvements that we could capture.

Please respond through this post or send me a message to discuss further.

Thanks

Anonymous (not verified)
Anonymous's picture

I am not sure what you mean "internal scheduling processes" the method I have used for several years works well. I used a single report in my old DOS database. I am redeveloping the database in Access2007 and simplified the report by running one report for PM_A and a different report for PM_C

pm cycle c,b,a,b,c
LOGIC - 4 & ( 2 ! 1 ! 3 !7) & 5 & 6

1 DAYS(SDATE)-DAYS(@.CDL) GT @.PM_CODE*28
2 DAYS(SDATE)-DAYS(@.ADL) GT @.PM_CODE*7
3 ELMVEHM.LAST_METER GT @.PM_SVC_FACTOR + @.AUL
4 ELMVEHM.PM_CODE NE 99
5 DAYS(SDATE)-DAYS(@.BDL) GE @.PM_CODE*7
6 ELMVEHM.DEPT EQ ?LIMITED TO DEPARTMENT
7 ELMVEHM.LIC_EXP_DATE GE DAYS(SDATE)

calculated from PM_CODE,
PM_SVC_FACTOR, ?DL=DATE LAST
?UL=USAGE LAST

NEW EQUIP A,B,C&D= INSVC DATE