Add columns in complex workbook (2003 SP 2)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote