Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
- Subject: Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
- From: Doug McNutt <email@hidden>
- Date: Tue, 5 Jul 2005 11:47:04 -0600
At 01:02 -0300 7/5/05, Bernardo Hoehl wrote:
>I have my own small company
I will assume that means the task is for employees of your company. For hundreds of employees real databases are the way to go.
>, and have been trying to learn Applescript for the past 18 months.
You're about 1/4 of the way to becoming partially proficient. High school Latin was easier.
Spreadsheets are good. They can handle times as numbers which one can subtract, they format numbers nicely as dates and as currency, they have pretty good macro languages. It's unfortunate that the only excellent one is from the dark side. They do do some things right in Redmond.
When you create your log file think about reading it back directly into MS Excel. If you put tab characters between "columns" and give the file a *.tsv extension Excel will open it directly including conversion of dates "July 5, 2005 10:23" into time sequence numbers. Format each column with things Excel will recognize: digits and decimal points allowed for numbers, xx:xx:xx for a time and the like.
You can easily come up with formats and macros that will make the file readable to the uninitiated while preserving the capability to sort and do arithmetic.
--
Applescript syntax is like English spelling:
Roughly, but not thoroughly, thought through.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden