Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2010
    Location
    United States
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating new To-do/timeline form

    I volunteer with a cat rescue.
    I have been asked if I can set up a To-do/timeline form showing us when we are supposed to do various things.
    For example, with newborn kittens:
    Distemper shots at 6 wk, then 10 wk then 14 wks.
    Wormer at 4 wks, then every 2 wks until 12 wks, etc. Just to name a few entries.
    If I use Excel to create a timeline, starting at DOB, I have no idea how to set it up. I've set up basic accounting type spreadsheets, but I have no idea where to start on this one. I've been trying to create the timeline, but the syntax is all off. Can anyone help get me going?
    Thanks
    Dave

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    Can you attach a sample of what you envision and we can help with the details? I think it would be easier than have us try to create from scratch what you envision.

    Steve

  4. #3
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    D,

    Maybe something like this can help you out. As you fill in the table, it places the "tasks" and dates on the time line. You can stretch the rows and columns to adjust the size of the timeline if you wish.

    puppy3.png

    HTH,
    Maud
    Attached Files Attached Files
    Last edited by Maudibe; 2014-03-21 at 18:26.

  5. #4
    New Lounger
    Join Date
    Dec 2013
    Posts
    14
    Thanks
    1
    Thanked 3 Times in 3 Posts
    If you want sheets that list all the cats instead of one cat per sheet, here are two possibilities.

    The first (Cats1) shows the date for each procedure for each cat.

    The second (Cats2) is organized by date. For each date, it shows which cats get which procedures.
    Attached Files Attached Files

  6. #5
    New Lounger
    Join Date
    Feb 2010
    Location
    United States
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks to both of you.
    Maudibe's version will work well for me, since I want to have something to give to the new adoptees, to show what has been done. This gives a good graphical chart of our scheduling.
    THill's chart will be good for our own record keeping, especially since we have a large number of cats we need to keep track of. All thes charts will help us keep tabs on when everything is due.
    Thanks

  7. #6
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    If I only knew the difference between a puppy and a kitten!

    Here is a variation of a vertical time line that allows room for more documentation. The table could easily be moved to another sheet which feeds the time line so that only the time line will be presented when printed.

    Kitty1.png
    Attached Files Attached Files
    Last edited by Maudibe; 2014-03-22 at 11:57.

Posting Permissions

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