The Wiki for the full KIC Clergy Time Management System can be found here.
What is KIC?
Many clergy persons now have letters of agreement (LOA) that designate a certain amount of blocks of time as a work week (Morning, afternoon and evening). This simple Excel spreadsheet can track these blocks and tell you how you are doing as a steward of your time. It will keep a running average of the number of blocks you work per week. It can alert you if you spend more nights a week than is stipulated in your LOA. It cantrack missed days off and help you track make-ups. It will also track reading time, vacation, continuing ed, sick days and Sundays off.
The new version of KIC is now available in the download links in the sidebar. The full version of KIC 3.0 can now track up to three positions, tallying them up into a master spreadsheet. It also allows much more flexible use and adjustment of weeks and blocks.
In addition, a Google Docs version is now available. It only tracks one position but works the same otherwise.
Q: Which version of KIC should I use?
A: If you don't have Excel or wish to access your timesheet online, use the Google Docs version. If you are a previous user who really liked Comp Time mode, continue to use 2.1. For everyone else, 3.0 is the way to go.
I've finally sat down and re-done Keeping It Collared. It's much simpler design-wise now.
1. Can track multiple positions on multiple sheets, adding all values to the master sheet. (If you only have one position, you can just use the position one sheet)
2. Should use simple enough formulas to be used on Google Docs and Documents to Go for Palm (I haven't checked this yet. If someone would like to, I would appreciate it!.)
3. A "Use?" Column that allows you to tell the sheet not to average that week. Use this when the week is just too bizarre and is throwing off your average.
4. In addition, there is now an "Adjust" column that allows you to add a positive or negative adjustment to the total for the week. I had so many requests for adding everything from sabbatical to maternity leave that it became too complex. Such things would be nice to track, but they are really too infrequent for adding to the main program. You can adjust and notate in the "notes" field why you are making the adjustment.
1. Comp Time Mode. WAY too complex to try to pull off with multiple positions. I'm not even sure how I did it on the first one, and such a mode would kill off Google and DTG compatibility. If you really like comp time mode, stick with KIC 2.
A nice thing about the way I've laid it out is that upgrading from one beta to another will be a simple cut-and-paste operation. If you are willing to test-drive, please let me know so I can figure out how many beta testers I have.