I'm stuck...

[copycollie]

Hi,

can somebody please help me? I am trying to make a sheet whic
calculates how many production our machine can make in 8-hour shifts.
have the formulas to calculate how many minutes it takes us to mak
,for example, 80 tons of a product ,the change-over for the nex
product (and so on), but I cannot get it to split it up per shift:
-Mondaymorning 15 tons of product A
-monday afternoon 3 tons of product A &
12 tons of product B.

I hope somebody can help me.Using Visual basic is not a thing I am goo
at but I am afraid that is the only way to get it to work

 

[BrianB]

Not knowing full details, I can only give a rough outline of the
principles involved.

The important number will be 'Production Tons per Minute'
(PTM)calculated by Number of tons divided by Minutes taken to produce.

You then calculate how much can be made in a certain time with
Tons Produced = Minutes times Production Tons per Minute.

A shift is 480 minutes which will be made up of various production
times less non-productive times taken for takeover.

eg.
Product A 200 minutes @ .1 PTM = 20 tons
Change over 80 minutes - nothing produced.
Product B 200 minutes @ .01 PTM = 2 tons

Total time 480 minutes.

 

[copycollie]

Thnx for trying to give me an answer! Let me try to explain my problem a
bit better.

On sheet A ,
cell B16..B76 contains the tons/min for each article,
cell C16..C76 contains the minutes/ton for each article,
cell E16..E76 contains the (unique) number of each article,
cell H16..H76 contains the number of tons needed,
cell I16..I76 contains the minutes needed per article &
cell J16..J76 contains the minutes needed for the complete production
up to that specific point in the production.

On sheet B, I made a column with 10,080 cells (7 days * 24 hours *60
minutes = 10,080 minutes).
Each cell should represent 1 minute of production time (sheet A, cell
B16) and the adjacent cell the number of the article (sheet A, cell
E16), for the number of minutes needed to make the article (sheet A,
cell I16). After completing this my idea was to take a look at minutes
1 to 480 (1 shift of 8 hours) and recalculate for this shift how much
production of what article we should make.

And the stuff on sheet B is the part where I got stuck.
I hope my problem is a little bit better to understand now.
I can send you my work via mail if needed; it's 731 KB at the moment.

Copycollie

 

[copycollie]

<proudmode> Well, I did it ! And without having to write code
</proudmode>
All it took were about 3,000 formulas. Main trick was using a doubl
IF-function to get a time-value per shift per articlenumber between 0
480 minutes

Copycolli