+ Reply to Thread
Results 1 to 14 of 14

Converting Excel data schedule to calendar

  1. #1
    Registered User
    Join Date
    04-14-2017
    Location
    Greenville, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Converting Excel data schedule to calendar

    Hello all! I am a managing partner in my 9 partner business. I help the office manager with scheduling. I created an Excel spreadsheet (attached) to help plan schedules months in advance. The office manager has been using my spreadsheet to manually enter schedules onto a calendar. There must be an easier way to import this data to a calendar. I tried to change the file to a CSV file but I couldn't figure out how to import multiple subjects (persons) and locations (location of work). Any suggestions? As you can see, we have 13 providers in the business. Thank you!

    Screenshot (15).png
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    It would be helpful if you could show us what your calendar looks like. Do you have one month per sheet, and do you show all 13 names for each day/week? Just a small sample related to the schedule data that you have already posted will suffice.

    It should be possible to display this in a calendar format: it just depends how you would like to format the data.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-14-2017
    Location
    Greenville, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Converting Excel data schedule to calendar

    Pete_UK,
    Thanks for your reply. We have to schedule 8 doctors and 5 nurse practitioners and we are in different places on different days. I have attached a typical monthly schedule with daily assignments. The first 3 initials denote the person and the following initials denote the location/assignment for the day. The schedule attached is something the office manager manually enters. Thanks again for any help that you can provide.
    Jim
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    I've put together a file that will do this for you automatically. Your initial data is in the Schedule sheet - I've not changed this at all. There is also a Calendar sheet which allows you to select the month and year of interest and it will generate the appropriate display from the two drop-downs in cell L5 and L6. It's up to you what you do with it then - you can print it out, or publish it to PDF etc.

    Note that with this display (Sunday to Saturday) then if a 30-day month starts on a Saturday, or if a 31-day month starts on a Friday or a Saturday, then the calendar would occupy 6 weeks, as 1 or 2 days at the end of the month would spill into that 6th week. In order to avoid that, I have arranged for these "orphan" days to be displayed on the top block of the calendar, as with some printed calendars. You can see this with April 2017 and July 2017.

    Hope this helps.

    Pete
    Attached Files Attached Files

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    Thank you for the rep.

    It seems from your comments that this has solved your problem. If that is the case then please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Pete

  6. #6
    Registered User
    Join Date
    04-14-2017
    Location
    Greenville, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Converting Excel data schedule to calendar

    Pete_UK,
    This is EXACTLY what I was looking for. Thanks so much! This will be a tremendous time saver for our group. I apologize if this is not appropriate (as I'm a newbie to this forum) but is there a way that my group could compensate you for your time and excellent help? Have a great week.
    Jim

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    Quote Originally Posted by strob001 View Post
    ... but is there a way that my group could compensate you for your time and excellent help ...
    Thanks for the offer, Jim, but all help given on the forum is FREE - enjoy the community.

    Pete

  8. #8
    Registered User
    Join Date
    09-22-2019
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    1

    Re: Converting Excel data schedule to calendar

    Hi Pete, thanks for the excel spreadsheet!
    Last edited by Cris1616; 09-22-2019 at 06:40 AM.

  9. #9
    Registered User
    Join Date
    10-22-2019
    Location
    US
    MS-Off Ver
    365
    Posts
    2

    Re: Converting Excel data schedule to calendar

    Hi! I'm hoping I can download the calendar you created above to see if it'll meet my need, but I get a php file

  10. #10
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    It worked okay for me when I downloaded it.

    Perhaps you should start a new thread with a title like "Downloads turn into PHP file" to see if any others have had the same happen to them.

    Hope this helps.

    Pete

  11. #11
    Registered User
    Join Date
    10-22-2019
    Location
    US
    MS-Off Ver
    365
    Posts
    2

    Re: Converting Excel data schedule to calendar

    It finally worked. Thanks! My data set is somewhat different and will pulled from a database. Think you can help me, Pete_UK..please?

  12. #12
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    Start your own thread (you should not try to hijack someone else's thread - see Rule 04 at the top of the screen), and attach an example of what your data looks like and how you want it displayed. I'll be logging off shortly for a few hours, but I'll check back later.

    Pete

  13. #13
    Registered User
    Join Date
    11-15-2020
    Location
    England
    MS-Off Ver
    365
    Posts
    1

    Re: Converting Excel data schedule to calendar

    I am not able to download the file

  14. #14
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,757

    Re: Converting Excel data schedule to calendar

    Well, it looks like 325 other people have been able to download it, and it worked for me when I tried it just now, so I don't know how I can advise you further.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Map Schedule Data onto Calendar View Generated by Macro
    By howaboutno in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2016, 03:45 PM
  2. Excel Chart to a monthly calendar schedule
    By nicole7774 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-23-2016, 08:10 PM
  3. Propagate calendar/schedule using data
    By klong in forum Excel General
    Replies: 5
    Last Post: 03-17-2015, 07:56 PM
  4. Replies: 2
    Last Post: 04-13-2012, 01:16 PM
  5. Replies: 0
    Last Post: 03-27-2008, 04:36 PM
  6. [SOLVED] How can I create a calendar from excel data (schedule)?
    By Shelly K in forum Excel General
    Replies: 0
    Last Post: 01-11-2006, 05:00 PM
  7. Exporting Excel Schedule to Outlook Calendar Subfolders
    By littlegreenmen1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2005, 03:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1