staff

Hi Guys, I have an issue that i can't seem to get my head around. I have a tool that i use to determine how many staff i require to open my restaurant. With the manager starting at 07:00. The tool adds the following for each staff member starting; 07:00 = 1 08:00 = 0.75 09:00 = 0.5 10:00 =...

hi guys I have 10 staffs in a group. Each staff is responsible for the closure of the computerized system at the end of the day. I need a vba code to assign the closure to each staffs.Each staff are entitled two closures per month.Working days are Monday to Friday. Is it possible to have it...

Hi I am creating a "Staff Roster" checklist In cells J5:J11 I have a set value used as the budget number of staff to work that day. In G3:33 I have a list of staff names In J13:33 I enter the task required oppposite that employee which is A, B, C etc, A= Shift manager B=Driver C= Dock etc In...

Hello Folks , I am working on an excel sheet where in i have business done by staff members for 2 weeks. I have 4 staff members , Need to compare their current month business from last month business. A1 has current month business 120000000 B1 has last month business 100000000 I need a...

Hello wise people, I need some help on a specific query. I'm trying out a simple BI to help manage the employees queue work rates. There are two types of queues; Production and non- Production. Production Codes will have volumes ranging from 0 to any number and the non production codes will...

I have a spreadsheet which tracks staff sickness and leave for 100 people. Each staff member has their own worksheet and there is a summary sheet showing sickness by staff member in a graph. I am trying to set it up so that each staff member can only see their own sheet and only the manager...

Hi I have found the forums here a great help in the past but never had to actually post anything for help, so I hope that someone will know a way to help me. The issue I have is that we track holidays and sicknesses at my company on one sheet, this has the dates along the top row, the staff's...

Hi! I have got some code that is working beautifully on PC but not when the file is used on Mac. I'm hoping there is a way to get the code to work on both PC and MAC as we have two people needing to use the file, one with PC and one with a MAC. Any suggestions hugely appreciated! The code is...

Hi experts, I m back with another vague and cryptic problem, and I ll be honest and say this probably isnt even do able. Imagine an office with 106 staff , 6 admins responsible for organising the appointments of 100 staff. A random schedule needs to be designed on a weekly basis (daily if...

Hello guys, I'm having trouble repurposing this macro to include a new sheet ("STAFF INFO") so it sorts that sheet in the exact same way as it would the one in the macro so I don't get mismatched staff names and info. Mind you in Rota (ORIG) I have the names of everyone working in column A...

Hi to all, i want to know since when a staff is at the current Designation? any guidance/tip,,.,.,regards. Pic for the issue https://imgur.com/a/T7ULe OR https://www.photobox.co.uk/my/photo/full?photo_id=500671381803

I manually complete 4 or 5 sheets (some months include 4 weeks, some months stretch to 5 weeks) of weekly staff schedules but want this data to be transposed automatically to a new sheet which will provide an overview of the weekly sheets on a single sheet. This is a screen capture of one my...

I have one worksheet with a table related to "Service" and "Rank" details with their applicable Job Descriptions. In a separate worksheet, I am trying to create a data validation list that's smart enough to list all of the relative "Job Descriptions" (from the other sheet) if the Rank and...

See some interesting staff in one of the file. waht are they?

HI everyone i am new here. i am managing school staff data in excel sheets. i want to create dynamically summary of my all staff with detail and summarize. but i don't have idea for creating summary that impress to my boss. plz suggest me in this regard and help to make this summary...

I'm trying to do a works Rota with let's say 3 people starting at 6 oclcok 5 at 7 oclcok and 1 at 8 o'clock but I want to know the formula . Also I want it as 06:00 07:00 08:00 on the Rota so it's easier to see. 1/3/18 2/3/18 3/3/18 etc Person 1 06:00 Person 2...

Hi, Is it possible to send an email to a defined distribution list at the beginning of every week picking up staff holidays in Excel for the week ahead. Not sure if this can be set to run at 9.00am every Monday? Thanks in advance.

I am using Excel to create staffing rosters and I'm trying to see if there is a function in Excel which will allow me to calculate how many staff are starting at specific times. The Rosters are going to change each time so is there a way of doing this without having to manually request the...

Hi! I'm not sure how to go about solving this - but I need to do an analysis using excel charts to assess if there is a trend between the performance of a list of managers handling their team of staff who are ranked either successful / unsuccessful vs the frequency of their attempts. So my...