staffing

Hello all, I am trying to create a staffing budget that will pro-rate their gross salary into each pay period, taking into account any contract changes i.e. a member of staff may reduce hours in year, and I would like to create a template that would allow for the new contract to be entered, and...

Hello, I know that calls and AHT are needed to compute for the occupancy. But just wondering if occupancy can also be computed with just staffing requirement and net schedule staffed? Thanks, Jangjang;)

I'm putting together a spreadsheet that determines how much staffing we need to bring in. Row 5 contains permanent data showing how many people are needed to run a certain line. Row 7 and below show how many hours the line will be running each shift. I'm using the following formula to determine...

Hey, i want to convert a schedule into interval staffing with VBA. How to start this project? 1. Read the data into a array. 2. Calculate each shift duration. 3. ???? Please help me with some guidelines. I dont expect to receive here the full code but at least information what I need to...

Hi, I'm looking for help on finishing up my gnatt chart by applying a format to widen row height based on an input cell. For instance, the row height would adjust for the project schedule phase, based on the number of staff assigned (entered in a column for that same row) that would...

Hello there! I have several forecast models linked to various source files (i.e. sales volumes) and some linked to each other (i.e. staffing model pulls actual from finance model and finance model pulls forecast from staffing model). If I open two files at the same time from Windows Explorer...

Hello, I'm attempting to put together a Holiday Staffing Planner the returns certain values and hourly counts based on data input and filtering from other worksheets. My workbook has the following worksheets: * Holiday Staffing Planner - (User Input Worksheet) * DD_VALUES - Data Validation...

Hi guys! I'm not new here...I have an older account but no idea what email or username I had back in 2016 (Could have been an old employer email).. sorry =( So I've done a search and couldn't really come up with what I'm looking to do specifically.. I have a report that provides me with the...

Hello! I am having trouble with VBA and getting it to work with the formula I made. I am using it to find data on another sheet by going down a column and finding anyone with a "D" in the row then pulling the first column name and pasting it on another sheet. This is used for staffing and since...

Hello everyone, This is my second time using the forum. The first time was a great experience. I received all the help I needed. I need help for the second time now. I was given the following directions..... You need at a minimum 10 weeks of data of arrivals across every hour of the day.</SPAN>...

What a great resource...glad I found this community. I am creating a time off calculator for company I work for. We use a pretty standard PTO methodology that gives employees 2 days annually as "Personal Days" on the anniversary date with additional PTO being accrued on a weekly basis...

Hello all! I have an Excel problem where I need to assign employees to a task based on 1) hours required for that task and 2) employee hours available. Here is the data I have: <tbody> Employee Week Apr 22 hours available Week Apr 29 hours available Employee A 15 20 Employee B 0 10...

I'm in need of a repeatable excel calculation/formula to calculate supervisor to rep ratio based on supervisor time spent on coaching and administrative tasks. Completely stumped on how to create this. Can anyone help?