How many Zs do I need?

I

IAmMe

New member
Joined
Nov 2, 2012
Messages
1
Having a mental block on figuring this out in Excel for work. I'm unsure if this is the right sub-forum, but I really appreciate any help that can be provided.

X process takes 70 seconds to complete per Y.
Y is the number of things requiring processing.
Z can do 5 concurrent Xs at a time across 5 Ys.

If Y is 10, 100, or 100,000, how many Zs are needed to run the Xs:
within 70 seconds,
within 350 seconds,
within 700 seconds?
 
IAmMe said:
Having a mental block on figuring this out in Excel for work. I'm unsure if this is the right sub-forum, but I really appreciate any help that can be provided.

X process takes 70 seconds to complete per Y.
Y is the number of things requiring processing.
Z can do 5 concurrent Xs at a time across 5 Ys.

If Y is 10, 100, or 100,000, how many Zs are needed to run the Xs:
within 70 seconds,
within 350 seconds,
within 700 seconds?
Click to expand...

Depends on length of your siesta!!:)

When get up from your siesta, please share some of your thoughts?

Do you require only one X to complete one Y?
 
IAmMe said:
X process takes 70 seconds to complete per Y

Y is the number of things requiring processing.

Z can do 5 concurrent Xs at a time across 5 Ys.

If Y is 10, 100, or 100,000, how many Zs are needed to run the Xs:
within 70 seconds,
within 350 seconds,
within 700 seconds?
Click to expand...

I'm thinking that I need some clarification. :cool:



From the first two lines quoted above, I get the following impressions.

Y is items-to-do count

Xproc requires 70 seconds to decrement Y (i.e., reduce Y-count by 1)



Regarding the third line above, I'm a bit confused about the phrase "at a time across".

If you're trying to say that Zproc completes 5 Xproc at a time, then "at a time" is redundant because that's what the word "concurrent" means.

If you're trying to describe Y in terms of some unit of time or as some time span, then that seems to contradict my interpretation of Y.



Additionally, if Zproc completes 5 times for every 5-block reduction in Y, then that's the same as saying that Zproc completes once for each Y decrement, yes?



It may help me to understand, if you rephrase the situation. Or, perhaps my post will jog somebody else's train of thought, and they will chime in. Cheers :cool:
 
Last edited:
Oh, Sir Khan was posting whilst I was still texting. He wins this thread. :mrgreen:
 
You must log in or register to reply here.
Top