Closed

Employee Schedules

I have 20+ employees and they all work different hours on different days. I need to graphically see what happens when I move someone's hours on 1 or all of their days.

**I used Excel but it's fine if you prefer to use MS Access.**

1) The current chart (Employee Schedules tab) shows daily schedules on a time scale from 3a ET to 2A ET (24 Hours). I would like the chart to be adjusted so that it shows 12A ET to 11pm ET. E.g. On Monday's schedule, time listed from 12am-2am should be listed on Tuesday’s schedule.

See in the attached Worksheet on tab “Employee Schedules.”

2) I need 2 line charts that automatically reflects the number of people I have working during a given hour - one graph for Mon-Fri and one for Sat-Sun. This would be calculated by summing the number of people that work daily during a given hour and multiplying each point by 4. See the example below:

Weekdays (Mon-Fri) @ 10pm

=======================

Mon - 5

Tues - 6

Wed - 3

Thurs - 11

Fri - 8

===============

Weekly Total = 33

Monthly Total = 33 * 4 = 132 (I realize that some months have more than 4 weeks but this doesn't have to be exact.)

These charts need to update automatically if I change someone’s hours on any or all scheduled days.

See chart example in the attached Worksheet on tab “Employees Per Month M-F.”

3) I need 2 additional line charts that reflect the information from the two charts requested in Item 2 above, in addition to the number of assignments per hour per month. The assignment data is static and so it has to be manually input. The employee hours data should be automatic based on their schedules.

See "Assignments" tab in the attached Worksheet for the Assigment data.

See “Emp and Assig Per Month M-F” tab in the attached Worksheet.

4) I need 2 more charts similar to what I requested in Item 3 above. So this chart needs to show the number of employees per month for a given hour and the number of assignments per hour in a given month. In addition, I would like to color code bars or the areas between these two lines based on their value. There are three categories - high, medium and low. I need to be able to change the values of the categories on the fly.

Low (blue): <50

Medium (green): 50<x<100

High (red): >100

Example: Montly at 12AM ET, my company has 132 people working and 67 assignments. The diffference between the two is 65 (132-67). 65 is in the medium category because it is 50<65<100. The color I chose to associate with this is Green so the drop line between both lines should be colored green. Please note, I want the ability to change the range of the categories. So if I change the category values to:

Low (blue): <20

Medium (green): 20<x<40

High (red): >40

then the bar at 12AM ET (65 value) should now be red because it is greater than 40 (>40)

-- M-F and S-S should have different categories and I should be able to change both independently.

-- See "Assignments" tab in the attached Worksheet for the Assigment data.

Key Considerations:

-- Employee schedules are listed in local time - Eastern Time, Pacific Time and, Japan Time.

-- I have setup the chart the best way I could. Please design as you see fit. For example, it would be great if I could select an employee from a dropdown, modify their hours and have it be automatically reflected visually.

-- There should be charts For Mon-Fri and Sat-Sun.

Skills: Excel, Microsoft Access

See more: excel employee schedule, employee line graph schedule, schedule employees work assignments excel, employee schedules excel, excel current employee chart, employee work schedules excel, employee schedule , employee line graph schedules, work in the pacific, what is people per hour, what graph to use for data, wed design best, want employee, red point, m&a associate, line graph design, i need employees now, i need employee, hour change 2012, graph assignment, employee needs, employee need, design fri, company employee, 2am design

About the Employer:
( 1 review ) Brooklyn, United States

Project ID: #2529508

17 freelancers are bidding on average $151 for this job

kulhanekd

I have 15 years exp in access design. I can assist in building your Database. Access is a better tool then excel. Donna

$150 USD in 4 days
(36 Reviews)
5.8
pipo1982

I can help

$250 USD in 7 days
(4 Reviews)
5.7
mrbrave

Expert in Excel/VBA with over 7 years of experience....Let make it.

$120 USD in 4 days
(71 Reviews)
5.3
sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$135 USD in 7 days
(17 Reviews)
5.0
Nhcuong

Hi, I can do it! I'm programmer for years and very familiar with VBA for excel automation. What is your excel version? Looking forwards to work with you, Cuong NH

$250 USD in 10 days
(22 Reviews)
4.9
funnyhoney

Excel expert here. Would be happy to work on this project.

$250 USD in 10 days
(4 Reviews)
4.0
NEEMISH

sir please see pm

$35 USD in 5 days
(6 Reviews)
3.0
nptganapathy

I can do this easily since I am expert in Excel and VBA. Thanks.

$75 USD in 3 days
(1 Review)
2.4
sureshoragadam

Ready to start the work, gone through your description clear with your requirements.

$75 USD in 3 days
(2 Reviews)
1.5
tbnsskdkdkd

Please check the PMB

$30 USD in 1 day
(0 Reviews)
0.0
nicu66pr

I can use labview to create a very nice user interface based on your excel file.

$200 USD in 5 days
(0 Reviews)
0.0
Yarsek

Hi, as an programmer in an educational school, I used to work with Access in order to create simple planning applications that are working until now. Although I'm mainly using .NET for my projects, I still use Access f More

$150 USD in 5 days
(0 Reviews)
0.0
kenkenko

Experienced in Access. Electrical Engineering graduate. Start doing now. Hope to give you the product ASAP. Really want to take the job. Please give a chance to new bidders.

$200 USD in 5 days
(0 Reviews)
0.0
Alld

i m ready to work plz sighn me

$240 USD in 20 days
(0 Reviews)
0.0
arset

Hello, I used to made same type schedule for Bulgarian hotels & restaurants activity. I believe, that I have an example of you valid table could easily made the asked one. Best regards, A. Setian

$200 USD in 1 day
(0 Reviews)
0.0
anjalisharma1981

I completely understood can do in 3 days

$50 USD in 3 days
(0 Reviews)
0.0
alltechworks

We hereby submit our proposal to develop and supply the Employee Schedules application described in your tender document. We have strong experience building similar applications including Graphical timetabling appli More

$250 USD in 15 days
(0 Reviews)
0.0
hemsingh1

Hi, understood the requirement ready to start. Thanks.

$100 USD in 2 days
(0 Reviews)
1.9