# Help with analysing data

#### DebbyG

##### Board Regular
I am trying to get my brain working today, but to no avail.

I need to analyse the below type of data to show various scenarios

A1 - No of letters
B1 - Qty/Mailing
C1 - No of Mailings is reflecting A1/B1

I can manage thus far!!!

A1 & B1 are likely to increase but not decrease in number

D1 is the maximum time it takes to complete A1 and cannot increase, even if A1 increases.

What I would like is some a form which takes all of the above equasions into account and tells me how many weeks it will take to process 5000 letters as a single or stages mailing, showing a message box, or similar if the completion time calculates to be over the maximum time allowed.

(A1) (B1) (C1) D1
No Letters Qty/Mailing No. Mailings Max Completion
[b1/a1] Time
2500 1000 2.50 20
6000 1000 6.00 22
3000 1500 2.00 22
3000 1000 3.00 22
3000 1800 1.67 22

I'm not sure if I've explained this very clearly.

Any help greatly appreciated.

Thanks

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### BrianB

##### Well-known Member
Calculate the amount of time it takes to process 1 letter:-
=Time Taken divided by number of letters processed in that time

Calculate how long a certain number of letters will take :-
Number of letters to process times the result from above.

Replies
14
Views
327
Replies
3
Views
772
Replies
6
Views
196
Replies
3
Views
149
Replies
2
Views
272

1,195,940
Messages
6,012,426
Members
441,699
Latest member

### 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