As a Planning Engineer, you defiantly deal with dates and quantities. Therefore, during your daily tasks you may need to create cash flow, manpower histogram, or even quantity based small schedule. This Excel Spread Sheet will help you to distribute any quantities, man-hours, or even costs between dates. For example, if you have an activity that starts in 1-Oct-2015 and finish in 15-Nov-2015, taken the weeks as periods what would be the planned % in week 1, 2, 3 etc? I have kept this spread sheet unformatted so it will be easy to copy, edit, or use the formula only in your works.
1- Create Cash Flow for a project.
2- Create Manpower Histogram.
3- Create Quantity distribute of an activity/activities.
All the above three items follow one concept. Therefore, i will explain the cash flow and you can do the rest using the same idea. If you have Activity Id, Activity Start Date, Activity Finish Date, and Activity amount you can do cash flow using this sheet by copy the Activity Id, Activity Start Date, Activity Finish Date into the sheet and get the month, weekly, or daily weight (depend on the time frame you will use). The weight is 1000 so if an activity will be completed in two months/weeks/days each one will get weight of 500. After you get the weight distribution based on the time frame, you need to use Vlookup function in excel to find the activity ID, assign each month/week/day weight then multiply by quantities, man-hours, or even costs and divide the total by 1000.
Sound complicated? fine, this is not a stand alone tool. you could consider it as intermediate tool to help you to do some calculations and then get the final results in your own form/dashboard. By doing this exercise for a schedule you will be able to create all of the above three applications (Cash flow, Manpower histogram, and Quantity distribution) using the same file. What will vary is how you are going to use the weight to determine cost, hours, or quantities.
I hope this file will be beneficial to you, use your creativity to create unlimited applications with a single file.
Download the excel spread sheet: Distribute between two dates Excel Tool