Hi Nigel.

Not a problem.

We have a pending value of cases and we wish to ascertain a calculated cycle
time based on incoming receipts per month to figure out approximantely how
long the maximum processing time, expressed in months, should take for each
case. So we take the last month's end pending value, say June, and using
this value as a comparision factor, take each month's receipt value, starting
with June. If the June receipt value is less than the pending value, then
that equals one, we then take the month of May's receipt value and add this
to June's receipt value, if the total value is less than the June End
Penfing, then that equals 2, and so on unitl the last value in the string of
values brings the total to equal or exceed the June End Pedning value in
which case we express this last value as a percent, as illustrated in the
below example. The cycle time is expressed in months. Hope this helps to
clarify the problem.

Thank you.

Mark :)

"Nigel" wrote:

I think I might benefit from a clearer definition of the problem. Can you
express the function required in a more generic form, the examples raises
too many what if questions for me. Sorry

--
Cheers
Nigel



"NWO" wrote in message
...
Hello all.

Here is my business problem for which I am seeking a solution:

Desired outcome - generate a cycle time based on varible number of input
values marked agianst a set vaue. Example, I have a fixed value of 1,000,
and a string of consecutive monthly receipt values (from nearest month to
farthest month), say 300, 200, 300, 450. I need a solution to determine
how
many times of these values go into 1,000, and the last value expressed as
a
decimal, if applicable. So, using the above vlaue would generate a cyckle
time of 3.4444. That is, 300 =1 because 300 < 100, 200 = 2, because
300+200
< 1000, 300 = 3 because 300+200+300 < 1,000., and the difference between
1,000 and 800 divided by 450 = .4444. I have tried countif, sumif, arrays,
and I just can;'t seem to find a solution other than manually performimng
the
calucation every time.

Any ideas to create a specialized formula or function to handle this task?

Thank you.

Mark :)