# Need help...excel amateur here.

#### kdogg877

##### New Member
I have a task to calculate how many trailers will be filled each week based on a schedule. I have to provide this in weekly buckets, based on sunday to saturday weeks. As you can see by the image, I currently have to estimate what portion of the job will be produced in each week by putting (.2,.3,.3 etc. in the weekly fields) if the job is scheduled to span multiple weeks. Is there an easy formula to provide this calculation, without having to manually type each line and field? How do I attach the file or a picture? Thanks for your help.

Last edited:

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

#### L. Howard

##### Well-known Member
I would be willing to look at your worksheet but I am not compelled at all to deal with what ever that is you posted.

Howard

#### kdogg877

##### New Member
I apologize. I think I've attached an example below. I have a date range of a production job and was looking for an quick way to spread that evenly across weeks (as in what portion will be ran in week 1, week 2, etc.). I would use this to estimate the the truckloads per week of the items being produced.

 Start Date Completion Date Week4 Week5 Week 1 Week 2 Week 3 Week 4 01/29/2013 16:11 3/10/2013 14:46 * 0.2 0.2 0.2 0.2 0.2 3/10/2013 1:58 3/10/2013 22:58 * 1 3/10/2013 15:02 3/11/2013 5:38 * 1 3/7/2013 22:58 3/13/2013 11:34 * 0.5 0.5 3/7/2013 0:56 3/13/2013 20:16 * 0.5 0.5 2/28/2013 13:47 3/6/2013 21:12 * 0.33 0.67 3/7/2013 5:01 3/7/2013 21:49 * 1 2/28/2013 10:54 3/6/2013 16:51 * 0.5 0.5

<colgroup><col style="mso-width-source:userset;mso-width-alt:5302;width:109pt" width="145"> <col style="mso-width-source:userset;mso-width-alt:4973;width:102pt" width="136"> <col style="mso-width-source:userset;mso-width-alt:585;width:12pt" width="16"> <col style="mso-width-source:userset;mso-width-alt:2304; width:47pt" span="2" width="63"> <col style="mso-width-source:userset;mso-width-alt:2486; width:51pt" span="4" width="68"> </colgroup><tbody>
</tbody>

Replies
0
Views
407
Replies
1
Views
234
Replies
6
Views
353
Replies
0
Views
541
Replies
11
Views
534

1,195,594
Messages
6,010,625
Members
441,558
Latest member
lambierules

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