IntactAuto.com - Free Automotive Excel Downloads

Service Management - Profit & Productivity

Listed below are some of the Easy to Use spreadsheets within this workbook, you will also find additional interesting & useful reports which are not mentioned.

Technician Daily Summary:

* Monitor individual technicians daily, weekly, and monthly productivity.
* Track clock and flat rate hours, effectively managing efficiency & guarantees.
* Determine total pay type sales: Customer, Warranty & Internal hours.
* Calculate and manage absentee expense.
* Produce weekly payroll calculations and records.

Shop Productivity:

* Daily, Weekly, Month-To-Date Efficiency and Proficiency values.
* On demand Shop productivity and sales reports.
* Utilization of available shop hours reporting, sold and remaining.
* Percentage of Labor Sales mix calculations.
* Productivity comparison reporting.

File Size: 2.37 MB, file size is relatively large, to download to desktop requires approximately 1 minute on a high-speed (100+) internet connection.

View Sample Worksheets- PDF View, 9 Pages

To download document to your desktop, right click on mouse and select,
"Save Target as". Download Worksheet in XLS format

Workbook Updated: May 18, 2008 - Get The Latest Free Excel Download

©Excel must be installed on your system to actively use worksheets.

Most Commonly Asked Questions:
Why after I download your worksheet, I'm not able to access the pages?
The reason is, Excel has within it's program a Security Setting for Macros.
You will need to adjust your setting. This is simply done by opening Excel and on your ToolBar click on "Tools", next click on "Macros", then click on "Security" and set your Security Level to Medium.

Why when I try to make an entry within a cell do I keep getting the message that the cell is protected?
To simplify the usage of these spreadsheets I’ve incorporated color coding within these worksheets. ONLY cells Yellow in Color allow you to input an entry, occasionally these cells may turn Red if an error entry occurs, these are the ONLY cells that allow an entry. All remaining cells are either information or calculation cell.

Where are the Worksheet Tabs?
This program has built into it an extensive amount of "Forms Buttons" which can be utilized within a spreadsheet. To access different worksheets or reports simply click on a forms button to gain access to any part of this workbook.

How do I use this spreadsheet?
Its a known fact, individuals do not like reading directions, but I've spent an extensive amount of time developing instructions and creating comment boxes throughout this program, please read them. If they don't answer your question it's my fault. E-mail me and I'll be happy to help and update the program to reflect your questions. The intent of this program is to simplify your day not complicate it.

Disclaimer of Warranty.
This software is provided "AS IS" and with all faults. We give No expressed warranties, guarantees or conditions. You cannot recover any damages, including consequential, lost profits, special, indirect or incidental damages beyond $ 1.00 US. This software is provided free of charge and you may install and use an unlimited number of copies. You may copy and distribute the software, provided that each copy is complete and unmodified, including this agreement for each user's acceptance. By downloading the worksheet , You accept these terms. This agreement and any amendments require a written statement.

Need Help?
This program is so easy to use that I'll even setup your default page for free.
As always your feedback is important,
E-mail your comments to: ExcelHelp@IntactAuto.com