Forum Discussion
Converting excel data into a printable calendar template
tammyangel Perhaps you are willing and able to move away from Word, because you could do all within Excel, with Power Query / Power Pivot (provided you are working on a PC, not a Mac).
The attached workbook contains an example that demonstrates what's possible. Sheet1 contains the Events listing (Date, Event) and Sheet2 has a (power) pivot table with the Annual Calendar view you described. All don in a quick-and-dirty manner and most likely it needs to be adapted to your real situation.
Change the events listing (change a date, add, delete, rename), and refresh the pivot table. That's it!
Edit: Added another file ("tammyangel-2.xlsx) . Power Query only. Personally I prefer that one.
Katrina ThompsonMicrosoft
Riny_van_Eekelen This was really helpful! Thanks.
Let's add a few more levels of complexity...
1. Let's use the previous example of 200+ events. Is it possible to add an event type to the data? Without it being part of the event name?
2. I understand that the original question was to format the calendar to be the large yearly calendar. Is it possible to format the pivot table to look like a 'regular' calendar?
Thanks in advance,
1) Yes, that is possible. How would you want to use the event type in the calendar?
2) How would a "regular" calendar look like for you?
- Katrina Thompson
Thanks for the quick reply.
In my use case, I'm collecting a list of workouts related to different running races. I'm training for several races and each one has a different schedule. I'm trying to consolidate all of those in one place.
I'm attaching a spreadsheet based off your original reply.
Hi Riny_van_Eekelen. Can you possibly please explain how you would turn the attached data spreadsheet into a monthly or annual calendar of events - like a monthly planner view not a list as it is now using power query/power pivot? Thank you 🙂
tahnee_h That's a very broad question and not so easy to answer, but the basis for any scheduling would be a list of columns in the correct structure. In your case a table with columns for Date, Time, Location, Function Name, Function Type and Pax.
But that's going to be a lot of information to be fitted inside a calendar template like the one being discussed in this thread. I dare to say that it would be best to use an out of the box calendar system like the ones that are included in your e-mail system. I would never consider developing such a system in Excel myself.
- This kind of calendar is exactly what I generated for the time off calendar I was making. There's no doubt it takes work to produce but it can be done
- Riny_van_Eekelen
how do I create this file please?
could you just give me a few pointers on how I start it?
Thankslearn700 Which file do you mean? This is an old thread. I need to refresh my memory.
Riny_van_Eekelen sorry this is the first I have used this community. It's the file you have attached in this thread.
I have a long list of milestones / events throughout the year in a list in excel (date and process), I wanted to put that into a calendar view to make it easier to see when all our deliverables, budget, etc are throughout the year.
Thanks
So far you have been very helpful. I still can't adapt the table for my needs. Some of my needs are for a class name
Class name | Date| Date| Date| etc. (up to 12 possible dates)
Is there a way to see the table on a normal calendar view or is the list the only way to use that raw data?
Thanks for your insight
RickJ80 Share a file please, because it's difficult to visualise how Class, Date, Date, etc will affect the calendar.
Riny_van_Eekelen Something like this where I can assign a specific name under the first block. The 24 block would be where I enter in the specific class name.
24 Jan 1/8/2024 1/9/2024 1/10/2024 1/16/2024 1/17/2024 1/18/2024 1/22/2024 1/23/2024 1/24/2024 1/29/2024 1/30/2024 1/31/2024 24 Jan 1/22/2024 1/23/2024 1/24/2024 1/29/2024 1/30/2024 1/31/2024 2/5/2024 2/6/2024 2/7/2024 2/12/2024 2/13/2024 2/14/2024 24 Feb 2/5/2024 2/6/2024 2/7/2024 2/12/2024 2/13/2024 2/14/2024 2/20/2024 2/21/2024 2/22/2024 2/26/2024 2/27/2024 2/28/2024
Hi Riny,
Do you have a solution for multi-day events? I am trying to implement the same concept for a year-long calendar of conferences and many are multi-day.
Thanks in advance!
sophiaperigee This is an old and long thread and many different calendar options were discussed. Perhaps better to start a new thread where you focus on your specific situation.
