workload

  1. T

    Evenly assign workload to available employees following priority

    Hello! I have a spreadsheet with a list of items each day pertaining to cases employees work. Each case has an assigned owner but cases pile up and need to be evenly distributed. I’ve attached a dumbed down version of my spreadsheet without sensitive information. I need to assign the list...
  2. B

    Workload tracker help

    I'd like to create a workload tracking tool for a job that has predictable tasks, but is unpredictable regarding the timing of task entry into the workload queue. Tasks arrive at unpredictable times/dates, and have a set number of days between arrival and due date for completion. I would like...
  3. E

    How do I specify different variables in a model?

    Hello! I have a model of the progression of a work based on different stages, streams, etc which is quite complex. You input the productivity and it outputs the end date based on that productivity. Now I want to do the opposite, ie specify the end date and find the minimum productivity that can...
  4. L

    Run autofilter automatically when values in specific cells are changed?

    I have a spreadsheet with multiple sheets. The sheet called “Active Projects” has a table with all active projects in rows and the workload of each project in column H. Rows 1 and 2 are headlines and row 2 contains an Autofilter. What I would like to do is that when: You change the workload...
  5. S

    Help on shift management

    Morning to everyone, I have some trouble to process the worked time of different workers in a month. Here you have a sample below : <colgroup><col><col span="13"><col><col><col span="20"><col></colgroup><tbody> Week from 12/01 to 12/03...
  6. T

    Conditional formatting; What takes up more space?

    Hello! I'm curious about conditional formatting ("CF"). I'm using it in a quite complex workbook and wonder if it's "better" to apply CF to an entire sheet (when possible) than to a certain (big) range. In the matter of saving workload. FWIK a smaller range should take less space than an...

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