Excel Templates | Excel Spreadsheets | TV Schedule



TV Schedule

Posted on October 29, 2009
Filed Under Calendar | 11 Comments

Pin It

There is a request from people about a possibility to have a calendar where they can customize their favourite TV shows in that calendar. So, they will easily being reminded by the calendar about the date and the time of their favourite TV shows.

TV Schedule

This is the solution of that request where you can easily list your TV shows and let the excel formula display your listing in weekly calendar. This TV schedule will display the date, the time, the TV station and the TV shows. And you can slide right or left to customize the weekly period before you print it.

This TV schedule consists of two worksheets. The first worksheet is TV listing worksheet where you can list your favourite TV shows based on recurring day (for example Heroes movie that is aired every Monday), recurring date (for example Music live show event that occur once a month), or fixed date (for example a Los Angeles Lakers matches). There is a holiday column where you can customize if you have other holidays date instead of default USA holidays.

TV Schedule Setup

Once you finished listing your TV shows, you can go to the second worksheet and see how the formula organize your listing in corresponding day and dates. Input the starting date for slider bar reference. And after that you can slide right or slide left to customize the weekly period of TV schedule.

You can download the file here.



Tags: , , , , ,

Comments

11 Responses to “TV Schedule”

  1. muaz on January 15th, 2010 8:46 am

    can u pls provide me the password of ‘schedule’ sheet?? i want to edit all sundays.. bcox our public holiday is friday and saturday
    thank u in advance
    B.Regards
    Muaz

  2. muaz on January 19th, 2010 7:30 pm

    i hav uprotected the sheet schedule.. btw can u pls tell me why all sundays and holidays are red?

  3. Kumar on February 5th, 2010 3:50 pm

    Sir,

    U have done the great thing , these sheets r very helpful.

    Thanks a lot.

    Regards,
    Aman Kumar

  4. Willy on March 30th, 2010 3:48 pm

    Dear Sir,

    I enjoyed your templates for F1 and The World Cup and I also liked the TV schedules. However, in the pull-down menu for recurring days, ‘SUNDAY’ is not listed. I would appreciate if you can tell me how to go about to include ‘SUNDAY’on the pull down menu. Thank You

    Regards
    Willy

  5. terry on May 25th, 2010 5:14 pm

    Can you tell me how to restrict the day number to 31 day ~
    As I press the “Next” button ~the calender can keep on going until a day that is not specify ~~><! It makes me feel confused a bit ~~

    What I mean is when the “start date” has been set to January~and when I click the “Next” button, the date showing below cannot more that month ~~

    Do you know what I mean ?

    Please get back to me ~thanks alot

  6. jaime on May 7th, 2011 1:56 am

    Hola , como puedo descargar el programa y comenzar a utilizarlo????
    gracias

  7. Anthony on July 26th, 2011 8:03 pm

    Hi – Would you be able to provide me with the password for the schedule tab? I tweaked the TV schedule to use for a charity event and instead of shows I am using it for actual teams. I need to expand the range beyond 1000 rows with input. Thank you so much…. great spreadsheet.

  8. Poca on February 15th, 2012 3:11 pm

    Can you please provide the password to unprotect the tab ? I need to customize this Excel file. Thank you in advance.

  9. Noel on February 28th, 2012 6:16 am

    Hi I was just wondering if there is any way that you can do a Template up for Medication as I take 17 Tablets of a morning 1 at lunch and 7 or 8 in the Evening and one that I can keep a list of them all for any new Doctor that I might have too see if away from my home town…

    Thanking You in Advance

    Noel Roberson

  10. Shiv on May 29th, 2012 3:42 pm

    Can you please share the password to unprotect the Schedule tab? I’d like to modify this to include a start date, so that shows aren’t appearing on the schedule before they actual begin airing. Thanks in advance!

  11. Shirley on September 11th, 2012 3:48 pm

    Can you please share the password to unprotect the Schedule tab?

Leave a Reply