Hi All,
I need some help creating a ranking/ordering system for a university project.
I have trucks entering a site multiple times per day, over 1 month, there are about 1500 truck entries and exits.
I need to rank these trucks from the first time they entered per day per shift.
Each shift is broken into Days and Nights. Days = 6am to 6pm, Nights = 6pm to 6am.
Factors that need to occur:
* If a truck enters more than once in a shift per day, its rank is not counted. Only its first entry is.
* If a new truck enters and meets the requirements, its rank is +1 from the last value (do not count blanks)
* A New Day that is not in the same shift results in starting at 1 again. If it is overnight on the same night, it is a +1 for new trucks.
Here is an example of what I mean
