Array Help ! I Think ?

snoopsterg

New Member
Joined
Sep 27, 2006
Messages
6
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Dan Waterloo

Well-known Member
Joined
Jan 4, 2007
Messages
874
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
Joined
Sep 27, 2006
Messages
6
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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,871
Messages
5,627,386
Members
416,245
Latest member
Xterminat

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

Which adblocker are you using?

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
Top