schedule

Hello. I'm looking for help in creating a production schedule in excel, Gantt chart style. The schedule is for Mon - Fri, 10 hour shifts. Id like the schedule to show in 1 column the routed time in units per hour to show how many units should be produced every hour, based on the total units...

Morning all, I need some help. I need to create a schedule and cannot figure out how to do it properly. Here's what I need to: Take the value of a cell (in the link below, that's cells B4 and E4) and divide it by the number of hours in the schedule (B1 and E1) and then create a number that...

Hi All, I have recorded a macro to pull data from various different spreadsheets to help determine throughput capacities. The issue I have is that one of the spreadsheets changes name daily. The line in the macro that this refers to is:- Windows("Express Schedule 5-11am.xlsm").Activate My...

<tbody> Schedule Schedule Name %1 %2 %3 %4 %5 %6 %7 1 bla1 2 0 40 6 0 8 0 100 100 2 bla2 100 100 100 100 10 3 immediate 100 100 100 100 100 100 100 </tbody> Ok.. so this is a little complicated. I currently have an If statement written that says...

I'm working with Excel Office 365. (windows 10) I've been asked to streamline a scheduling process using Excel. Once the schedule is complete that "sheet" will need to be sent to employees and client. Here's what I would like to do... 1. Create a workbook with 3 "sheets": Requirements...

<tbody> </tbody> I have a production schedule that I need to modified from 24 hours per day / 7 days a week to 12 hours per day / 5 days a week no weekend. I cannot figure out how to count for the weekend. I am able to adjustment the hours on schedule if we are ahead or behind in...

Hi! I have two schedules - a posted schedule, and one pulled from our time keeping system. I would love to set up a formula that will post the following: If the times listed on both schedules match, or are within 6 minutes of each other, the cell will read "on time" If the times listed on the...

Hi, I am trying add up the amount of times someone works between a certain times over the course of a month on a schedule. For example how many time did they start between 5am and 9am so I have put in the below formula. =SUMPRODUCT(--(AND((LEFT(B6:H6,2)>="05"),(LEFT(B6:H6,2)<"09"))))...

I am trying to create a amortization schedule for an auto loan where the monthly payment changes based on the previous payment. I found a template that creates a amortization schedule but the payment is fixed throughout the schedule. My first payment when I first started paying was $360 for 60...

Hi! I'm really hoping someone here can help me. I'm going to try and be as concise about my question as possible, but please ask for clarification if needed. I have a fillable PDF where users are given approx. 60-240 schedule choices (depending on which group they are in) which they rank...

Hello, I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other...

Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you <colgroup><col width="64" style="width: 48pt;" span="5"> <col width="78" style="width: 58pt...

I’m in need of some help speeding up my Excel spreadsheet. I have been working on a solution for weeks, and I don’t know what else to do. About I track hundreds of project schedules that use the same schedule outline template. Each schedule performs at different time frames. I’m currently...

Hi all, I have a simple VBA workbook code to allow my grouped rows to be grouped and ungrouped when a sheet is locked. I have 2 sheets, Estimate & Schedule. It only works on 1 sheet that i name eg: "Estimate". How can i make it work on both sheets or the entire workbook? Option Explicit...

Hello all, new member to the Community looking for help. I was recently given a project at work and it has to do with Excel. I’m supposed to figure out how much product is being shipped and how many are staying behind. I was given a list of Product that has been delivered and a list of the ones...

Hi all, I was given the following formula by one of you guys on here (Thanks so much) It works apart from the fact I would like it to look down the two columns and match the specific text then do the remainder of the formula rather than be assigned specifically to each row ('PMI Schedule...

Hi, looking for some help - I am at a basic level at excel, have to use the formula wizards for vlookups and generally use google to find an answer and use trial and error to find a solution. To this question though, cant find anything, We run a team of engineers that work over several projects...

Hi there, I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows: A = Staffmember name B = MondayStart Time C = MondayEnd Time D = TuesdayStart Time E = TuesdayEnd Time etc., endingwith M/N for Sunday Start/End Times Anothersheet includes relevant...

Hello, First post on here but have used this site countless times as a reference. I am creating a heat chart for staffing purposes to show how many people are on shift for a specific day/time. The first sheet has schedule info (Name, Start Time, End Time, and 1/0 for each day of the week...

Hello everyone, I am working on creating an employee schedule with multiple employes. I have entered a start time and an end time for each shift. There are days where employess will be off and if working they will receive a half hour lunch. I have looked online and was able to find a formula...