schedule chart

I have a schedule for keeping track of hours worked with a list of employees. I have the Userform that pulls up and shows the current date. Along the top of my excel sheet I have the dates. I want to populate the hours worked in the column of the date shown in the textbox of the userform. So I...

Hi guys, Need some help here. I have a library of recipes which acquire several systems. All recipes have a specific number of hours in which they will take when you run them. Now I wanted to run multiple recipes together but some of the recipes conflict with each other as they acquire the...

Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( https://photos.app.goo.gl/KKYhpmq6LVXaVtAP7 ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...

I am looking to copy an entire row from one tab to the other based on what is in column A. In addition, I would like to sort the rows copied by what is in Column A (in this order...MIDS, DAYS, SWINGS). I would also like to have a definitive break row better the results. I have attached screen...

Need: A schedule in excel is required for a large team. Schedule gets changed every month and people are rotated (mid person will do the night and night will be moved to morning etc). There are five shifts in a day, each shift having 5 teams and each team having at least 8 members...

Here's the scenario: You have 1,2,3,...N tasks to do sequentially, all which take a range of time to complete (column constraint), but you're only allowed to set aside a certain amount of time on each of M days (row constraint) to complete these tasks. Example: You have a 5 chapter book to...

Hello, I am trying to create a drop-down list based on a (rather complicated) formula, and since the validation rule won't accept a formula, I'm not sure how to proceed. Essentially, I am trying to create a spreadsheet for scheduling staff in various locations, based on their qualifications and...

I will try to explain this the best I can! I am attempting to create a schedule at work. In order to do so, I created three sheets. In the first sheet (Wkdays), I have included the names of each employee in column A. The rows (headings) I have labeled Sunday through Monday. I placed a 0 for...

Thank you so much for taking the time to read and respond to my questions. I have a weekly schedule for multiple locations. Each location has different amount of employees assigned. Each day could have a different number of employees and various shifts. An employee could be assigned to location...

I hope y'all can help point me in the right direction. Because I have no idea where to begin. Here is what I have and where I want to go. I have: A spreadsheet that contains job names, start time, and avg execution time (in minutes). this by the way is a huge list. Some jobs run every 5...

Hey guys, I'm working on an NBA spreadsheet involving some various index-match formulas where a reference is being made for a team from the main page to match up with a date (y-axis - current date is always column E) and team (x-axis - varies based on the team the player is on). Basically what...

I'm trying to use if/and functions to create a gantt chart for a schedule. A person working from 8:00 am - 5:00 pm, where if its outside this time range its a 0, inside its a 1. Conditional formatting to do the rest. X axis is the day broken down into hours, y axis is the names of people...