Technical Note: 20011004049

Activity Report ASCII file

(Maitre'D 2002, and later versions of Maitre'D)

Time and Attendance

ASCII FILE DESCRIPTION
When you generate an activity report on the Back-Office, the system will also create an ASCII file named ACTASCdd.TXT, where dd is 00 for the current day or 01 for Monday, 02 for Tuesday etc...
This file contains the information in the following format:
"WEDNESDAY","30 / 11 / 1994"
"11:00","12:00",49.65,2,0.93,4.9280,9.92,24.82,53.38,2.15
"12:00","13:00",0.00,0,1.00,5.2800,100.00,0.00,0.00,0.00
"13:00","14:00",24.50,1,1.00,5.2800,21.55,24.50,24.50,1.00

First line: Day description, Date

This is the day and date for which the report is generated.
All other lines contain actual data.

Field 1: Start time.

Field 2: End time.

The data for this record was recorded in the time period delimited by these two fields.

Field 3: Sales.

Sales for the given period.

Field 4: Customers.

Number of customer recorded in the given period.

Field 5: Labor hours.

Sum of hours worked by all active employees during the given period. This value is expressed in hundredth of hours.

Ex: The period is one hour and three employees worked the full hour while one worked only 30 minutes and another 15 minutes. This field will contain 3.75 (not 3.45).

Field 6: Salary.

Sum of salary for all active employees during the given period. This field has 4 decimal digits for more accuracy.

Field 7: Labor cost.

This field is calculated as Salary / Sales. If no sales occurred during this period, then labor cost is set to 100 %.

Field 8: Average sales by customers.

This field is calculated as Sales / Customers.

Field 9: Production ratio.

This field is calculated as Sales / Labor hours. The labor hour is considered as full hours, which mean that it is possible for this field to result in value greater than actual sales.

Ex: Sales = $49.65, Labor hours = 0.93 -> result $53.38

Field 10: Customers ratio.

This field is calculated as Customers / Labor hours.