Need help...excel amateur here.

[kdogg877]

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.

 

[Special-K99]

Tip #2
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html

 

[L. Howard]

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

 

[VoG]

Look here http://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[kdogg877]

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>