planning

  1. L

    Shift Planner - Excel or not?

    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...
  2. C

    Consolidate forecasts and actual dates into one column with a helper column

    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...
  3. E

    Digital planning board with excel functionality

    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...
  4. G

    Simple for you, difficult for me

    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...
  5. G

    Excel Template for Modeling/Planning Salary

    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...
  6. F

    Forecast and Demand Planning

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

    Capacity analysis

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top