Excel form and chart related to distributing overtime based of response time to bid and how many times they've taken OT

DFWJoFoster

New Member
Joined
May 4, 2015
Messages
2
I'm looking to make our schedulers lives easier by creating a chart based for giving out over time to our front line employees. we do so by email bid. and email goes out a week prior with available dates and shifts. employees then respond what dates they want to work. they are then selected based off of the email time stamp(first come first serve) but also based off how many times they've taken OT in a month. (e.g. John Doe wants 12/19 AM 12/22 PM 12/23 PM has work OT 4 times this month and his email was sent 1 minute after it went out and was the first to respond) currently they use a pivot chart and manually go through each person to see when they sent the email and how many times they've worked OT. This is time consuming and tedious. I'm trying to create a chart/calendar form that would give them a drop down list focus mainly on how many times they took OT that would change the position of their names depending on how many times there name pops up in the charts cells. We have 3 shifts needing at most and on average 4 AM OTs 4 PM OTs and 1 Over Night. I'm trying to determine the best approach to this. I'm not asking to give me a full module form for VBA but if the community could point me in the right direction and help me brainstorm, I'd much appreciate it.
 

Attachments

  • Cncpt_1_1.png
    Cncpt_1_1.png
    219.3 KB · Views: 7
  • chart_1.png
    chart_1.png
    10.9 KB · Views: 7

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

CSmith

Well-known Member
Joined
Jan 13, 2020
Messages
686
Office Version
  1. 365
  2. 2010
  3. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
More info/details needed to assist...
 

Watch MrExcel Video

Forum statistics

Threads
1,127,589
Messages
5,625,671
Members
416,125
Latest member
NeedExcelHelp2021

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
Top