schedule

I am trying to create a prepaid schedule where the beginning and ending dates are mid-month resulting in pro-rated amounts at the beginning and end of the payment schedule. Can someone please help this frazzled person figure the formulas out for my spreadsheet?? I would be most appreciative...

Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...

I am trying to make an impact report that will quickly allow a customer to quickly understand the impact of set a weeks work and any delays in their schedule. What i would like to do is make a table with Column A being the project ID, Column B to BA represent a work week, and column BB be 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...

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

Hi. I am trying to use a VBA code to pull initials from a table named "PlannersList". It will then take those initials and insert them into query "schedule" in the "initials" parameter. This process will loop until all initials have been utilized. Everything works except for the initials are not...

Hi, Amateur Excel user and could really use the expertise of an Excel Guru. Do you know of any formulas or VBA examples that will allow me to schedule data to be imported from one workbook to another? I.e. Workbook 1 - Cell A2, data imported to workbook 2 cell A2 on the 4th of each month @...

Hello, I have a table with 2 columns (Schedule, Item) of data and I would like to create a formula under the 3rd column using under the criteria below. Criteria : If Column A (Schedule) shows "Yes" and if there are multiple occurrences of the same value on Column B (Item) that satisfies the...

Good morning, i am in the process of trying to get a training calendar built which i already have the calendar part done so that when i change the year on first month it updates it for the year. my next task of trying to figure out is if there is any way to auto populate the information for the...

How do you conver the following schedule How do you convert the following 8 column schedule Date Team ID <tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7...

Hi all! I am having difficulty using formulas to calculate the number of employees who are working each hour. I believe this is because my overnight shift is a little tricky. Here is the formula I am currently using and a snip of how my schedule is built. Any ideas on how to get the overnight to...

Hello, In my work i have to make weekly working schedules for my co-workers. Almost all of them are part time workers and have a first main job. I have 2 or 3 cases that they have a rotating schedule on their first job but it's always the same: example day 1 2 3 4 5 6 7 8...

Good morning everyone, I am working on designing a schedule for equipment in mycompany. I have recently learned about aGannt chart and have been able to build one in my workbook. When a place a start and stop date by a pieceof equipment that time is then blocked off. Here is my problem, often...

I don't know if excel will work for this so let me know thoughts. Trying to create a macro to create a racing schedule. Criteria : Multiple clubs, each club might have 1 to 6 teams. 2 teams race at a time against each other. Each race might be a 3 of 3, 4 of 4, 5 of 5, or best 3 out of 5...

Hi, I've got a dataset of respondents in the format of: Respondent 1 - Choice 1 - Choice 2 - Choice 3 etc. Respondent 2 - Choice 1 - Choice 2 - Choice 3 etc. [for 100s of respondents] I am trying to allocate choices so that each respondent gets as many of their choices as possible The issue...

I have a single workbook with (2) sheet tabs as follows - (Plant Schedule Sheet) and (Master Plant Schedule Sheet) (Master Plant Schedule Sheet) https://imgur.com/bR68kqb (Plant Schedule Sheet) https://imgur.com/VUoAXSw What i would like it to do is that whatever number you put in column...

I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...

I have a worksheet that lists a baseball schedule. I'm trying to find a way where I can enter W or L (win/loss) in a column on the schedule and it will update another worksheet with the total W/L record. Ultimately I would like to have a pivot table that sorts the records from first place to...

Hey there! So...my boss creates these very confusing and messy schedules. I would like to make a auto-populated streamlined version of his schedule. Here is a link to my worksheet (its just a dummy containing no personal information)...

Hello there !!!! I am new to excel and trying to do a pretty big project and I cannot figure out how to solve an error that keeps popping up. I have a weekly schedule which has 7 columns, each one for a day of the week. I am now trying to do a daily schedule which copies all the values from the...