Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add columns in complex workbook (2003 SP 2)

    Before I go home today I wanted to post this. I work for the (US) Department of Veterans Affairs, and we have been given a very nice workbook to help us keep us with sick leave and annual leave. What it lacks is a third set of columns for each day so professionals like me who get comp time can keep track of it. The workbook is pretty complex, at least to me, so I really didn't want to waste a lot of time hacking around on it. I'm not interested in publishing it or anything, it's just for my personal use. Each year's formulas are dependent on the prior years, so I had to delete a bunch of sheets to get it under 100K and not mess the formulas up. A blank file is attached. Any suggestions are appreciated.

    As always, thanks a million.
    Jim Whitt
    Pharmacist
    Temple, Texas

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add columns in complex workbook (2003 SP 2)

    It shouldn't be that hard inserting new columns, just a lot of work, since you'll probably want to adjust the formatting for the inserted columns.
    When you do so, the existing formulas will adjust themselves automatically, so you don't have to worry about that.
    By looking at the formulas in (for example) AC6, AD6 and AE6 on the 2002 or 2003 worksheet you can see how annual leave is calculated; the formulas for sick leave are similar except that "earned" is always 4 for each period. You can imitate these formulas (with the appropriate adjustments) for comp time. Since we don't know what the rules for comp time are, it's impossible to know if and how these formulas will differ from those for annual leave and sick leave.

    You're welcome to ask questions about the formulas.

  3. #3
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add columns in complex workbook (2003 SP 2)

    The comp time formulas shouldn't be quite so hard, since you don't earn some every pay period. The carry over from the previous year will have to be done right. And, you're right that reformatting the columns will be a job. I'll check some of my add-ins to see if they've got a magic wand to wave.

    Good to hear from you again, Hans. Thanks again.
    Jim Whitt
    Pharmacist
    Temple, Texas

Posting Permissions

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