Im trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula Im getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula Im getting the same total 1,336 for my per hour: (Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process flats
over folds.
Flats are a package type that contain 6 pages average€¦ 6 pages = 1 package
Folds are also a package type that contains 25 pages average€¦ 25 pages = 1
package

It doesn't look as if the problem is with your formula, so perhaps your data
values are wrong?
--
David Biddulph

"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1 package
Folds are also a package type that contains 25 pages average. 25 pages = 1
package

thank you, I will recheck the data source... I'm starting to think I just
don't have enough information.

co-worker just informed me that numbers are pulled off the machine and
printed so the data is accurate. thank you for your help anyway.

"David Biddulph" wrote:

It doesn't look as if the problem is with your formula, so perhaps your data
values are wrong?
--
David Biddulph

"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1 package
Folds are also a package type that contains 25 pages average. 25 pages = 1
package

Are you using absolute references? Is the workbook in manual calculation
mode and needs to be calculated? It seems odd that you would get the exact
same result for two different data sets.


"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1 package
Folds are also a package type that contains 25 pages average. 25 pages = 1
package

Yes the numbers are valid. I must confess I don't understand what you mean
by manual calculation?

"M. Authement" wrote:

Are you using absolute references? Is the workbook in manual calculation
mode and needs to be calculated? It seems odd that you would get the exact
same result for two different data sets.


"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1 package
Folds are also a package type that contains 25 pages average. 25 pages = 1
package

try punching the F9 Function Key to do a re-calculate. Under your
OptionsGeneral check for auto recalc

"tryn''''2learn" wrote:

Yes the numbers are valid. I must confess I don't understand what you mean
by manual calculation?

"M. Authement" wrote:

Are you using absolute references? Is the workbook in manual calculation
mode and needs to be calculated? It seems odd that you would get the exact
same result for two different data sets.


"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at 39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1 package
Folds are also a package type that contains 25 pages average. 25 pages = 1
package

Just to clarify...I was not questioning the validity of the data. In the
formula that you use to calculate per hour, do the cell references have $
next to the column letter or row number? Did you create the formula for the
first set of data and then copy/paste it for the second set? If so, and if
there are $ (absolute references), then that would explain why the results
are the same for the two different data sets.

See Reno's response regarding the manual calculation.

"tryn''''2learn" wrote in message
...
Yes the numbers are valid. I must confess I don't understand what you
mean
by manual calculation?

"M. Authement" wrote:

Are you using absolute references? Is the workbook in manual calculation
mode and needs to be calculated? It seems odd that you would get the
exact
same result for two different data sets.


"tryn''''2learn" wrote in message
...
I'm trying to figure out an item per hour count.
I have a Flat total time of:29:33:34 with flat items processed at
39,496
With my formula I'm getting 1,336 for my items per hour: (Formula)
=time/items/24

Then I have a Fold total time of 292:17:59 with fold items processed at
390,556
With my formula I'm getting the same total 1,336 for my per hour:
(Formula)
=time/items/24

I know this is wrong because it take longer for the machine to process
flats
over folds.
Flats are a package type that contain 6 pages average. 6 pages = 1
package
Folds are also a package type that contains 25 pages average. 25 pages
= 1
package