I've been looking through the archives for a quick and dirty
answer to my
problem but, I haven't found it yet.
There are six Locomotive Engineers turns in a particular
pool that runs to
Superior, WI. We calculate the total mileage for the
previous fifteen days
and divide that mileage by the number of turns in the pool
to get an
average mileage per turn to compare to a mileage range.
That range is
3952.1 miles on the low end and 4352.1 miles on the high
end.
If the current average mileage is inside the mileage range,
we make no
change. However, if the mileage is above or below the
range, we add one
turn or reduce one turn and then check to see if the average
mileage is
inside the range. I'm trying to determine how to use a
function to compare
the average mileage to the range to see if one turn, two
turns or three
turns need to be added or reduced or if no change should be
made at all.
That's the easy part!
When adding a turn to the pool, we MUST have the new average
mileage fall
inside the range BUT By reducing one turn, the average
mileage of the turns
in the pool MAY have to be above the mileage range of the
pool -- in this
case, the reduction of the turn is the most important even
though our
average mileage is above the high end mileage of the mileage
range.
For example, the current average mileage for the six turns
is 3932.3 miles
which is below the low end range of the mileage so we MUST
reduce one turn
to get the mileage back inside the range but by reducing to
five turns, the
average mileage then becomes 4718.8 miles which is above the
high end
range -- since the primary goal is to reduce a turn, we
will accept an
average mileage above the mileage range in this case.
Any thoughts on how to do this to automate the change to
return text such
as "ADD ONE", "NO CHANGE" or "CUT
ONE"? Thanks for your thoughts!
Thomas E. Finnegan
BLET Local Chairman
Division 202
Dilworth, Minnesota
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|