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.
  • KIC is licensed under the GNU Public License Version 2
  • KIC is Donateware. If you enjoy the use of it, I ask you to make a donation to Episcopal Relief and Development's MDG Inspiration Fund or another Millennium Development Goal charity of your choice.

About the Programmer

Powered by TypePad

February 14, 2008

New Beta

Hello Keeping It Collared Users!

I've finally sat down and re-done Keeping It Collared. It's much simpler design-wise now.

New features:

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.


Removed feature:

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.


The beta software has no documentation, so refer to the 2.1 documentation or ask questions on the support group at http://groups.yahoo.com/group/keepitcollared/.


David+

February 10, 2008

New Look!

I've added another TypePad Blog to help with tracking Keeping It Collared. It should make for a much better looking page.

David+