# Array Help ! I Think ?

#### snoopsterg

##### New Member
Hi All, Hope this is posted in correct place.

I have a production schedule that i need to make available for my colleagues.

At the moment the data is stored in a SQL database which i have full admin access to and need to export to excel as below

Date Time Cum Total
06:00hrs
08/06/2007 08:00hrs 0 0
10:00hrs M/R 0 0
12:00hrs M/R 0 0
14:00hrs 4500 4500 4500
16:00hrs 18000 18000 22500
18:00hrs 18000 18000 40500
20:00hrs 4500 4500 45000
22:00hrs 0 45000

What this actually depicts is Job Number, start date, start Time, Run speed, Run Minutes, Make Ready minutes (MR).

I can get at all the data but am struggling how to get the following to create the above.

StartDate | EndDate | QTY | MRMins | RunMins | Spd
08/06/2007 10:00 08/06/2007 22:00 45000 120 300 9000

any help would be appreciated

Steve

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Dan Waterloo

##### Well-known Member
Steve,

It looks like
StartDate | EndDate | QTY | MRMins | RunMins | Spd
08/06/2007 10:00 08/06/2007 22:00 45000 120 300 9000

is supposed to be a summary of the dataset you gave above. I can see how MRMins gets to be 45000 but do not see how MRMins is 120, or RunMins is 300, or Spd is 9000. Perhaps you could restate this example and show how the summaries are supposed to get calculated.

#### snoopsterg

##### New Member
Steve,

It looks like
StartDate | EndDate | QTY | MRMins | RunMins | Spd
08/06/2007 10:00 08/06/2007 22:00 45000 120 300 9000

is supposed to be a summary of the dataset you gave above. I can see how MRMins gets to be 45000 but do not see how MRMins is 120, or RunMins is 300, or Spd is 9000. Perhaps you could restate this example and show how the summaries are supposed to get calculated.

I think i gave a confusing statement, if i can clarify:

start date = 08/06/2007 10:00
end Date = 08/06/2007 22:00
QTY Required = 45000
MRMins (M/R) = 120
RunMins = 300
Run Speed (copies per hour) = 9000

M/R = 2 Hrs so in spread sheet should show

Time QTY
10:00 | M/R
12:00 | M/R
14:00 | 18,000

I have to also take into account that we have 3 shifts that have 1 hr breaks at say 12:00, 16:00 and 18:00 where production with cease for that 1 hour period

Hope this explains a little better

Steve

Replies
7
Views
182
Replies
0
Views
362
Replies
9
Views
538
Replies
3
Views
336
Replies
1
Views
118

1,172,201
Messages
5,879,650
Members
433,449
Latest member
Treavus

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back