On this page I will publish once in a while some Access and Excel and other small development stuff I manage to accomplish and dare to publish. It's quite a task to polish your stuff in order to make it presentable. Don't expect the entries to quickly.

Comment Management with Perl
A small and simple solution for your homepage

I googled a lot and couldn't find a simple comment management suitable for this site. I didn't want one of the mighty solutions like you find at WorldPress or Serenity. I wanted something simple without database management although something flexible and easy to manage.

Therefore I tinkered something for myself. It took me quite a while - particularly as I have no skills yet in web development. Finally I got something simple which suits me. When you have similar requirements feel free to use it or to change it to your needs. You'll find a simple documentation behind the link on your left.

Addendum (14.04.2010):
I have updated the documentation and the zip file with the scripts. New demands (it's usually just Claudio) like an overview of recent placed comments and the option to include clickable links into your comment are incorporated.
the soon came up the necessity to filter spam entries (I have not much traffic but these robots find you anyway). Thank god the solution someone recommended works just perfectly (cross your fingers!).

New version (16.05.2010):
I have updated the documentation and the zip file with the scripts again. Reason for redesign was the inability of IE to cope with two related JavaScript programs (at least I didn't know how to do it). Being at it I changed the method of storing the comments. Instead of having a flat file for each section I now store everything in one file and just pick the relevant comments programmatically. Made my life much easier - guess I'm endig up at a database eventually.

Read comments and write your own

OrderManagement.xls
A small sample Workbook for small or freelance businesses

I did the first version of this little application for Sabrina when she needed to keep track of her camera and cutting jobs and do some proper looking invoicing. That was an hour job or so and involved a lot of manual handling (the regular copy and paste stuff). With a little time on my hands, I played with it. The goal being: as much automation as possible without using code. Pure function and formula stuff, as it should work not only in Excel but also in Open Source spreadsheet programs like OpenOffice. There is also some hope that it could suit as a training workbook for understanding matrix formulas and functions (I'm an hopeless optimist).
Feel free to test it and have fun

LearningFrench.mdb
An Access sample database