planning

Hello, hoping for some advice please. I am looking to set up a shift rotation planner for a charity I am involved with, and am not sure if I should be attempting this in Excel or if because of the number of potential volunteers/requirements I should be looking at separate software. Details as...

I am looking to see how to convert raw data as shown in the 1st table and manipulating the data to display as shown in the 2nd table. Specifically, I want the dates to be in a single column with a second column marking if the date is an actual or forecast. Any help would be greatly...

Hello, I would like to make a digital planning board in Excel. It must look like the old fashioned planning board with paper cards. On the left the project. On top the days of te week. Every day people must be moved (drag and drop) to the projects. I have an excel example that I can email...

Hi Guys I have a dataset with car usage on it (driver service). I created a distinct flag and aggregated accordingly, bringing my set down from 50,000 to 10,000. I have the following fields: Date, pick up time, drop off time and location (and some others). I have also created various...

Hello, Just wondering if anyone has a good, ready-built template for modeling direct payroll, or salary planning for a department. Ideally, something that allows for salary increase on a given date, as well as adjustments for vacancy (due to a position being temporarily open/vacant). At my old...

I am beginning to develop a new forecast and demand planning that will utilize the production plan of my customer to tell me how many of each products I will need on a weekly, monthly and yearly basis. I don't want a true forecast because I have the production data. Can any provide any insight...

Dear all, I am working with a workbook, which enables me to 1. have a capacity overview (total, per team, etc) 2. have a demand overview (total, per project, per team, per role) 3. make simulation / what-if scenarios. The 3rd part is in order to make possible "movement" of projects from one...