Anyone with a formula showing races since layoff (days off determined by user),using fv ?
thanks ,
thorny

Hi,

Not sure this is the most efficient way but this should work:

Create 3 columns:
Column #1 name it LayDays - Then enter the Days Off maybe 45

Column2:
Name it RSL_Check and enter the formula below:

abs($hrDaysOff<=#COLVAL("LayDays") * $ppIndex=0 ) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppIndex=1)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppIndex=2)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppIndex=3)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppIndex=4)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[4]<=#COLVAL("LayDays") ) * abs($ppIndex=5)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[4]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[5]<=#COLVAL("LayDays") ) * abs($ppIndex=6)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[4]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[5]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[6]<=#COLVAL("LayDays") ) * abs($ppIndex=7)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[4]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[5]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[6]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[7]<=#COLVAL("LayDays") ) * abs($ppIndex=8)) +
(abs($hrDaysOff<=#COLVAL("LayDays")) * abs($ppDaysSinceLast[0]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[1]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[2]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[3]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[4]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[5]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[6]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[7]<=#COLVAL("LayDays") ) * abs($ppDaysSinceLast[8]<=#COLVAL("LayDays") ) * abs($ppIndex=9))

Column 3: Name it RSL
Enter this formula:
#hCOLADD("RSL_Check") * abs($ppIndex=0)

Hope that helps:
HP

quote:

COLVAL("LayDays") ) *

I WAS ABLE TO MAKE YOUR FORMULA WORK TO THE HORSE CRITERIA, RATHER THAN THE PAST PERFORMANCE INDEX. THANKS, AGAIN HOLDING PATTERN.
thorny