schedule

  1. E

    Browser Page Refresh: Reflect new data after scheduled refresh

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

    Use Formulas to Fill Weekly Schedule

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

    I need new ideas

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

    Depreciation schedule in Excel for Straight line method

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

    Prepaid 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...
  6. N

    Is this beyond Excel's capabilities?

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

    Conditional Formatting For an Impact report

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

    Schedule chart help

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

    Block Schedule Chart Question

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

    Name Query Not Working

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

    Schedule Data Import - Excel

    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 @...
  12. M

    Requesting Formula Help

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

    Schedule Calendar

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

    Convert 8 columns to two columns

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

    Need formula to calculate # of employees working each hour

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

    Creating working schedules

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

    Reoccuring events in Excel schedule

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

    Schedule creation

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

    Allocate choices to respondents

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

    Macro to copy and paste from one sheet to another in the same workbook

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top