schedule

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...

Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...

Hi, I have a Weekly Schedule sheet that I would to populate with formulas from the Appointments sheet. Does anyone know how to do this? Thank you Excel WorkbookAIKLMNOPQR1INDEX8:00 AMLunch Start12:00 PMMax working hours per day92Lunch End1:00 PM3Lunch Time1:004INVJOB TIMESTART DATEDAYSTART...

I want create new NFL schedule file. anybody have any ideas. Thanks You Thomas

Hi, I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast , <colgroup><col><col><col><col><col></colgroup><tbody> Asset Current Cost Accumulated Depreciation Net Book Value Date Placed In Service...