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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
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.

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.

Thanks for the reply,

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
3
Views
168
Replies
2
Views
376
Replies
1
Views
359
Replies
1
Views
407
Replies
18
Views
611

Threads
1,219,792
Messages
6,150,288
Members
450,949
Latest member
faizanmalik10

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.
Allow Ads at MrExcel

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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