schedule

Ok just throwing it out there for all you experts as I am not one. I want to be able to randomly generate a schedule for my employees. Basics...Each employee works 4 days a week but not necessarily in a row and 1 of the 4 days must be a Sat or Sun but not both. Each day there are 2...

We have a 32-man golf trip that is split up into 2 teams of 16. We play 4 rounds. I am trying to come up with a schedule where everyone has a different partner all 4 rounds, and everyone will play against different people on the opposing team over the 4 rounds (8 in total), with no overlap or...

I work for a small company who manufactures kitchens in Oxfordshire. We work on the basis of being able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring...

I have a schedule in sheet1 and a schedule in sheet2. I want to "subtract" the table range in sheet2 with the table range in sheet1. Sheet2 is the "skeleton" of the schedule, and the determined values in specific cells. Sheet1 is the "skeleton table", just with cells added afterwards. So i want...

Hi I am trying to create a schedule with multiples conditions as below decription: I have 100 customer, each customer have 1000Kw of electric, and I need theme cut off electric few day in month, which is: Forgive for my poor english ^^ Thank for spend time to read and help.

To anyone who can help!!?? Very new to excel but I know its magic (with the right person creating it). So at my place of work, the first thing I do in the morning is print out all the jobs for each machine we have. Each machine may have 20+ jobs on (11machines in total). I then manually time...

hello good day, i was working on monitoring the 7th day duty of guards, i don't know what formula to be used. i have a thousands of data to check it one by one. i just want to have a formula that marks or emphasized the 7th day data after zero. thank you. attached is a sample.

Hello, I'm trying to design a production schedule and make it visual at the same time. There are 3 machines, and I would like to allocate jobs for each machine, based on 5 days production and 10hr shifts (jobs are not allocated per person, rather, per machine). Ideally I would like to define...

Good afternoon! I am trying to create a rotating work schedule. There are five main colleagues and six jobs. I want to be able to assign these jobs on a daily basis evenly. So every day, someone gets a different job when I click a button perhaps. Is that possible? For the sixth job, I want it...

Hey There is there a way I can create something similar to the outlook Calendar input form that I can use for budgeting analysis on my excel spreadsheet? Is it crazy hard? Would this need to be done with User forms? Is there an alternate method you would suggest? Thanks in advance! Kind...

Hey guys, I am trying to set up a spreadsheet to fill in time slots based on day and time information. There are two sheets in the workbook (Calendar and Log) Here is how I have it set up: The name of this sheet is Calendar A B C 1 Wednesday (August 19, 2020) Thursday (August 20...

I'm hoping someone on here can help we with what I'm trying to create in our Excel work schedule. In the Sheet "Availability" it lists all of the employee's in Column B. With the date listed in Row 2. In the Sheet "Assignments" is where we enter each employee's assignment for that day (Date is...

Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...

I’m interested in a few formulas to calculate total number of days worked and days off in a calendar year, and each month based on known values. For example: Employee Day Rate: $500/day If they work a schedule that is 3 days on and 4 days off that repeats itself for a year, I would like to...

Hi Dears I am not an accountant person that's why i can't calculate this. so please help me i have sheet to calculate the installment amounts of price of the apartment. it's 2500000 $ if cst want to pay 10% (variable percent) in the start which 250000 $ . then install the rest of amount on 1 ...

I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...

Hello, I am wondering if there is a way to calculate months mathematically. For example, if this month is October (10) and I want to go back 3 months to July (7), is there an easy way to show this? Here's what I have: <tbody> A B 1 10 <--using "=MONTH(TODAY())" 2 Oct <--using...

I have a master schedule file to compile projects from various managers. There are four phases with start/end dates. I'd like to be able to enter the dates for the phases, and have the colors change in the cells to the right of the dates based on the entered dates. Is this a stacked conditional...

I have rummaged through posts but cannot get any formulas to work I have a project table that has Project ID's (only one occurrence of each ID) then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a...

HI ALL, I'm planning to use some formulas to return my employee's schedule which looks clean and more simply from a complicated database. Here are what i have in the original schedule @ sheet_schedule for my 3x employee and a formula to return a concise layout @ sheet_result formula in...