scheduling

  1. S

    Scheduling Possibilities?

    Hello, I have Power BI Pro installed as part of our E5 license and I am trying to evaluate it in thoughts of using it instead of our current IBM Cognos setup (that we pay extra for) fo rquerying our SQL server tables... However, the one concern I have that I do not think Power BI can do - but...
  2. P

    Can it be done.... Master scheduler

    Slightly complex and due to restraints i only have Excel to play with. I Want something like this: Tab 1: Data of jobs to be done Tab 2: All staff with how many minutes they work per day Tab 3: All product families we build and how long a batch will take to build in minutes then how many...
  3. E

    Excel Solver Airplane Scheduling

    We have let's say 10 private planes that we use to transport customers. Each customer has their own departure and arrival airports. I am trying to see if Excel Solver can help me decide which plane to use for any of the customers based upon closeness and meeting the departure/arrival time in...
  4. S

    Rounding to the following Sunday

    Racking my brain to get the following to work: =IFERROR(IF(D5=0,"",D5+45),IF(D5="","",D5+7-MOD(D5-1,7))) D5 being the source date that I'm adding 45 days to and then rounding to the following Sunday. Honestly wouldn't mind figuring out the previous Sunday as well. We are trying to set...
  5. M

    Scheduling in Excel (How to skip weekend and holiday)

    Hi I would like to make a basic scheduling in excel. So here is what I want to do: The Completion time simply= Start time + Process timeThe start time formula = The last process time.What I want to make is, how to make the completion time skip the non-working hours and days. For example in...
  6. D

    Scheduling

    I am in the process of creating a scheduling spreadsheet for a small manufacture. We are scheduling machines, not people. I am just about complete, having everything but the following working well: When scheduling 2 jobs that use the same machine and need to be done at the same time, it will...
  7. D

    Solver

    I am required to submit the minimum number of people we need to recruit for our training centre. I heard Solver can help, but I am unable to figure out where to put the constraints and how to set them up since I never used Solver and the problem I have appears to be too complex and I hope solver...
  8. A

    Scheduling Advice

    Hi everyone, I'm trying to make a scheduling template through Excel and was wondering if anyone could provide some advice as to how to go about this. For some context, I am scheduling teams of 3 on 2 shifts per day, everyday. Availabilities for the month are sent in through excel. I was...
  9. J

    Shift Management with fixed pattern, different starting point

    Good day, I am busy building an automated shift system whereby I will be able to generate my own shift system by only indicating the master shift pattern and then I want it for 6 employees with conditional formatting indicated by a separate column. Thus, if the shift pattern is...
  10. K

    Recurring job??

    I have to schedule a soap check for 96 locations six times a year. Any ideas on how this would work or where to start?
  11. F

    Scheduling "Program"

    Hey guys! Currently making sort of a scheduling program on Excel. I need to make a scheduling calendar that keeps note of the delivery shipments. I first used VBA to make a data entry form which lists all the data on another sheet. My problem is matching the data from this sheet onto the...
  12. C

    Scheduling Macro

    Hello, I have a course catalog of many different groups that occur everyday between 9:00 and 4:00 pm, there are over 100 people that are being scheduling in these groups. I'm trying to create an excel document that can help organize everyone so that when certain groups are selected for one...
  13. B

    Scheduling

    I am creating a schedule for instructors, but there are specific parameters such as a requirement that there must be a 24 hour break in a 7 day period. I create the schedule with names in the far left column and the days of the month in the top row from left to right. I would like a conditional...
  14. K

    Scheduling - caluclating hours with varying closing times

    I own a small restaurant. I am redesigning my schedule, and want a column at the end that would tell me how many hours each employee is scheduled for. The issue is that if we close at 9, that doesn't mean the employees walk out the door at 9. They have to clean, count the drawer, prep for the...
  15. L

    scheduling duplicate dates

    Hello, I have a situation where I have to schedule Dr. appointments on every Tuesday and Thursday of each month. There are 2 offices that get scheduled (room 101 and room 505). We can only schedule 1 appointment per day per office. I have 2 columns that have the Tuesday and Thursday dates...
  16. C

    Returning Multiple Information Sets through VLookup or Index Match for a Schedule?

    I am writing a scheduling program for a complicated schedule. I have a schedule Matrix for each day of the week with 6 columns: Staff; Client #; Special (for extra shift information); Time In; Time Out; and Shift Hours. This is vertically organized primarily by client number, but not...
  17. B

    scheduling sheet sufferage

    hey guys i have this scheduling sheet which i need to automate. specifically, in sheet1, my HR planner inputs the dates which each employee is working, over 5 days. in sheet 2, i need to have formula driven range A2:J10 row1 (the date forecast), updates in tandem with the current date. as the...
  18. K

    Formula help

    I am in need of some assistance in tweaking formulas to get the desired results. The situation may be impossible, but I need to ask to satisfy my curiosity. I will try to include the spreadsheet and describe as best as possible...as always thank you for help in advance! I have a file that...
  19. B

    Adjust task dates to spread over time left in project

    Thanks for reading this I have x amount of tasks in a project over a specific time frame The allocated time for each task can vary i.e. they have a start and end date for each specific task I need to be able to change the amount of time (both start and end dates) allocated if the project is...
  20. D

    Count hour funcion

    I'm doing a shift bid at work, and I need a formula that will count weekly hours per shift. I'm sure this is easy, but I've tried and I'm messing it up. Thanks for the help!

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top