Crab Report Help Guide

Table of Contents

Getting Started

The Crab Report displays your shop's repair orders (ROs) exported from CCC in a customizable grid format. Data is loaded from the file and enhanced with your local data (temporary techs, notes, sublet, start/finish etc.).

First Time Setup:
  1. Log in with your credentials (cell phone) or add new user
  2. Select your shop from the dropdown (if you have access to multiple shops)
  3. Set up the Direct file read (recommended) or use manual upload
  4. Configure your import settings to locate and process exported file in the Settings Manager (βš™οΈgear icon)
  5. Configure your settings in the Settings Manager (βš™οΈgear icon)
↑ Back to Top

Startup Process

When you load the Crab Report, the following happens automatically:

  1. User Authentication Check - Verifies you're logged in
  2. Shop Selection - Loads your assigned shop(s)
  3. Shop Authentication - Verifies the shop is on a trial basis or has a subscription
  4. Settings Load - Retrieves your display preferences, filters, and aliases
  5. CCC Data Load - Fetches the most recent CCC export file on the cloud or any files saved from CCC.
  6. Local Data Load - Retrieves your local data (notes, temporary techs, sublet, start/finish settings)
  7. Data Merge - Combines CCC data with your shop's' Crab data
  8. Display - Renders the grid with your default report view (All ROs)
πŸ’‘ Tip: If you see "Loading..." for more than 30 seconds, try refreshing the page. Check your internet connection if the problem persists.
↑ Back to Top

Sign up

All programs from eShop Technologies are subscription services:

↑ Back to Top

File Import Options

The program needs to know the path to where the report from CCC is saved. This will need to be a folder in which you will need to create.
Go to Settings (βš™οΈgear icon) upper right) to set this up or modify with complete instructions in the settings help.

↑ Back to Top

Troubleshooting: No Shop Listed

Problem: The shop dropdown is empty or shows "No shops available"

Possible Causes & Solutions:

Cause Solution
No shop has been identified
  • Path to CCC export location has not been set yet or has not been authorized
  • Report has not been run or not saved in the designated location
  • Verify the path and that file is saved there
Your account has not been
assigned to any shops
  • Contact support to assign your account to a shop
  • Any shop you have access to in CCC can be opened in this program
  • Set the report in CCC to the shop you want to add and then save it as ususal
Network connectivity issue Check your internet connection and refresh the page
↑ Back to Top

Multi-Shop/Regional User

Design for Multi-Shop/Regional Users:

Adding shops

↑ Back to Top

Main Screen Overview

Header Bar

Filter Row

πŸ’‘ Note: All dropdown menus are built dynamically. This means they are built from the actual display so it will display all items it finds in the current file. No management needed for any lists.

Dropdown filters appear below the header for quick filtering by:

Filter Dropdown Behavior:

Data Grid

Understanding grid colors

The main grid displays your RO data. Features include:

↑ Back to Top

Working with Reports

Available Reports

Filter Dropdown Behavior:
Report Description
All Shows all ROs (default view)
Pre-Production ROs in pre-production phases
Production ROs currently in production
Detail ROs ready for detail (based on calendar date - defaults to today).
Usually displays all phases except Completed and all pre-production phases.
Go List ROs ready to go (based on calendar date - defaults to today).
Usually displays all phases except pre-production phases.
This report includes Completed - Best report to use for forecasting sales.
Refinish Paint technician(s) list - includes all paint technicians
With multiple painters, run the report from the techs dropdown menu
Mech Mechanical technician(s) list - includes all mechanical technicians
With multiple mechanics, run the report from the techs dropdown menu
Sublet ROs with sublet work - by default includes all ROs in the sublet phase. Includes all ROs that have any sublet listed using the Crab sublet manager.
Disassembly ROs in any phase designating disassembly. Usually named Teardown or D/A but you can use whatever phase you want.
Unassigned By default, ROs with no techs (body, frame, paint or mechanical) assigned, and has a repairs completed date
Waiting ROs in a waiting state, by default, phase starts with "W/"
Warranty ROs warranty phase, by default, phase starts with "Warr/"
πŸ’‘ Tip: Customize report filters and sorting in Settings Manager(βš™οΈ) β†’ Reports tab

Further Filtering a Report

After selecting a report, you can further narrow down the results using the filter dropdowns while staying on the same report.

How to Filter Within a Report:
  1. Select a report from the main dropdown (e.g., "Go List")
  2. Hold down the Shift key
  3. While holding Shift, click on a filter dropdown (e.g., "Writers")
  4. Select the value you want to filter by (e.g., a specific writer's name)

Example: You run the "Go List" report and it shows the Go List for all writers. To see only one writer's Go List:

  1. Hold Shift
  2. Click the Writer dropdown
  3. Select the writer you want

The report title will update to show "Go List for [Writer Name]" and only that writer's ROs will be displayed.

πŸ’‘ Normal Click vs. Shift+Click:
↑ Back to Top

Auxiliary Reports

In addition to the main reports dropdown, a row of links on the left side of the screen (below the filter dropdowns) opens special-purpose views. These do not replace the main reports - they give you a different angle on the same data.

Link Description
Workload Shows each technician's current workload - the ROs assigned to them and the hours involved - so you can see at a glance who is loaded up and who has room. Phase cells use the same color coding as the main grid: light blue for started, orange for finished.
Use these values as estimated as only total RO hours is sent from CCC so calculations are used to get the hours.
Calendar Displays your ROs on a monthly calendar so you can see how scheduled work is spread across the days and spot heavy or light days at a glance.
Production Detail A shop-wide production status view organized by technician group (Body, Frame, Paint, Mechanical) plus Detail. When using phase start/finish times, displays where every RO stands in production, with the same light blue (started) / orange (finished) color coding.
Show All Finished Filters the main grid to show every RO that has a Finished time - the ones whose Current Phase is colored orange - regardless of which report you were on. Use this as your "what is done and waiting on a CCC update" list. To return to normal, simply select any report from the main dropdown.
View New Notes Filters the main grid to show ROs whose notes were added or edited since you last clicked View New Notes. Opening it marks those notes as seen, so next time only newer notes show up. Your own notes are included. To return to normal, simply select any report from the main dropdown.
By default, this link is not displayed until there are any new notes.
πŸ’‘ Tip: Workload, Calendar and Production Detail open in their own window over the grid - close them and you are right back where you were. View New Notes and Show All Finished change the main grid itself, so pick a report from the dropdown when you are done with them.
↑ Back to Top

Printing

Any report you see on the screen can be printed by selecting the 'Print' button.
All printing uses your default printer, but can be changed at each print session.

Printing Setup
↑ Back to Top

Phone Version - Setup and Usage

The Crab program is available to use on a smart phone. Due to the amount of data displayed on a computer screen, it has to be completely re-formatted to view an a phone. It has taller rows with 'Stacked' data in them. Also, sublet, notes and repair plan comments are displayed separately by clicking the 'Show' button in the last column.
Note: 'Show' button only appears when there is data to view.

πŸ’‘ Version Note: There are 2 different version of the phone setup. A general user with a desktop version will get a full version on the phone app with all of the report options, all dropdowns (writers, techs, etc.) while the single user version (for techs or departments like refinish and detail) are limited to just their specific list.
Phone versions do not have access to the settings, printing or searching but they can create/edit notes.
Phone Installation
To continue with phone installation, user must already be a registered user or set up as a 'Single User' in the settings. Contact support if you need help with this.

Setting up on an iPhone: If using an iPhone, after the tech's screen is displayed, find the little square icon with an up arrow (next to the address). When clicked, it will bring up several sections and the lower one (should start with 'Copy', will have a button with 3 dots that says 'More'. to Home Screen' Click it and find 'Add to Home Screen' and you're done. You will now have an icon with a Crab on it.
Setting up on an Android: after the tech's creen is displayed, find 'Share' which you may need to click the 3 dots to find it. From there, click 'Add to Home Screen'. You will now have an icon with a Crab on it.


Phone Usage
Now with the new Crab icon, click it to open the program.
If the program is already open, you can click the Refresh/View All (πŸ”„) Button to make sure you have the latest data.
Clicking on a row will now bring up the start/finish screen which the user can select to start, finish or clear the status.
This is an efficient way for the tech to communicate the status back to the person in charge of production.
Status displays on all phones and desktops.
Start times turn light blue while finish times display in orange.
Good opportunity for the person in charge of production to set the status as well to avoid writing notes or remembering status.
Note: If your shop is a current user of eShop Image Manager, pictures can be taken from the start/finish screen from any user as well. Great option for in-process photos!
↑ Back to Top

Editing Data

⚠️ Important Reminder: All edits made in Crab Report (technicians, notes, sublets, time, etc.) are saved to the Crab database ONLY. Changes do NOT sync back to CCC. CCC remains your official system of record.

All data editing in Crab Report can be done through the Detail Row - an expandable panel that appears when you click on any row in the grid. See the Detail Row section below for complete instructions.


Some data editing can be done directly without going through the Detail Row. On the desired row:

Editable Fields

The following fields can be edited through the Detail Row:

Creating Aliases

When clicking on a technician column, if no alias exists for that name, you can create one:

  1. Click on the technician cell
  2. Look for the "Create Display Alias" section
  3. Enter a short alias (defaults to first name)
  4. Click Save
↑ Back to Top

Detail Row - Expanded View

The Detail Row provides a comprehensive view of all RO information and editing options in an expandable panel directly below the selected row.

Opening the Detail Row

  1. Click on any row in the grid - best to click on the RO# itself
  2. The row expands to show a detailed panel below it
  3. Click any row or empty spot in the form to close it

Detail Row Layout

The expanded detail row is organized into two main sections:

Section Contents
Left Side
  • RO Number (with edit alias option)
  • Sublet assignments
  • Notes field
  • Time field
  • Target Date (calculator)
Right Side
  • Estimator assignment
  • Body Technician assignment
  • Paint Technician assignment
  • Mechanical Technician assignment
  • Frame Technician assignment

Editing from Detail Row

Each editable field has its own button or input area:

πŸ’‘ Tip: The Detail Row is especially useful on smaller screens or when you need to see all RO information and editing options at once without scrolling horizontally.
↑ Back to Top

Temporary Writer & Technicians

Crab Report allows you to assign or reassign estimators (writers) and technicians to ROs. This is useful for 'Assigning' a tech or writer to an RO that can't be assigned yet - usually in the event that there is no tech assigned in CCC.'.

⚠️ Remember: Technician and writer assignments made in Crab Report are stored locally and do NOT update CCC. These are for your internal tracking purposes only.

How to Change an Assignment

  1. On the row you want to assign, click the writer column or one of the tech columns - or - Click on the row - Click any row to display the Detail Row panel
  2. Click the appropriate button - On the right side of the Detail Row, click the button for the role you want to change (Estimator, Body Tech, Paint Tech, Mech Tech, Paint Tech)
  3. Select from dropdown - A dropdown appears showing all available techs/writers for that role
  4. Choose a name - Click on the name to assign them - or - Click 'X Remove Temp Assignment' to return to CCC assigned tech/writer
  5. Auto-save - The assignment saves automatically

Available Assignment Fields

Field Description Source List
Estimator The writer/estimator assigned to the RO Writer Groups in Settings
Body Technician Body/collision repair technician Tech Groups in Settings
Paint Technician Painter/refinish technician Painter Groups in Settings
Mechanical Technician Mechanic for mechanical repairs All names from data
Frame Technician Frame/structural repair technician All names from data

Understanding Assignment Colors

Background colors in the grid indicate the status of assignments:

Color Meaning
Yellow No CCC Employee - The CCC file has no one assigned for this role. You have made a local assignment in Crab.
Green Changed from CCC - CCC has someone assigned, but you have changed it to someone different in Crab. This is a temporary override.
White/No Color Original CCC Data - Showing exactly what came from the CCC export file. No local changes have been made.
↑ Back to Top

Sublet Manager

ℹ️ Sublet Manager info: Sublet Manager is a great way to manage all of your sublet work. Don't get too hung up on the word 'Sublet' as we find many users using it for internal mechanical and other processes as well. Some users opt to not use this feature and instead just write these sublet and other process in the notes. This does work but here you'll find there are several shortcomings compared to the Sublet Manager:
Using Sublet Manger
Sublet Manager is specific to an RO. Must be accessed from an RO line.
Open the Sublet Manager either from the Detail Row or from click on the Sublet column of the RO you want to add, edit, remove or mark as complete.

Adding a sublet item

Editing sublet - Includes editing existing, adding, deleting or completing an item

↑ Back to Top

Working with the Target Date Calculator

ℹ️ Target Date Calculator: The Target Date Calculator helps you determine a realistic completion date for a repair order based on labor hours, parts delays, and shop scheduling factors. It uses insurance-specific profiles to apply the correct calculation settings for each job.
By default, it will start with the default settings in regards to many options in the calculator including: hours per day, include weekends, specific skipped holidays and many others. These settings can all be customized to specific insurance companies.

Opening the Target Date Calculator

  1. Click on any row in the grid to expand the Detail Row
  2. Click the πŸ“… Target Date button
  3. The calculator opens with the RO's data pre-loaded

Calculator Layout

The calculator is organized into three columns:

Section Contents
Left Column Start Date, Delays, Options, and the calculated Target Date result
Middle Column RO information, Insurance Profile selector, Estimate Levels table, and Calculation breakdown
Right Column Calendar view showing the date range, or Note Builder for creating documentation

Insurance Profiles

The calculator automatically loads settings based on the RO's insurance company. Each profile can have different default values for:

πŸ’‘ Tip: Use the Profile dropdown at the top of the middle column to switch between insurance profiles and see how different settings affect the target date.

Start Date

The start date defaults to the vehicle's arrival date (Vehicle In). You can change it by:

Delays

Enter the expected delay days for parts or sublet work. The calculator uses the maximum of all delay values (since delays typically run concurrently, not sequentially).

Delay Type Description
New Parts Days waiting for new OEM parts
LKQ Parts Days waiting for recycled/used parts
Recon Parts Days waiting for reconditioned parts
Sublet 1 & 2 Days for sublet work (glass, alignment, etc.) - includes description field

Options (Toggle Switches)

Option Effect When ON
Round Up Any partial day rounds up to a full day (e.g., 3.1 days becomes 4 days)
Include Start Date Counts the start date as Day 1 (adds 1 to total days)
Include Weekends Counts Saturday and Sunday as working days
Include Holidays Counts holidays as working days

How the Calculation Works

Calculation Steps:
  1. Work Days = Total RO Hours Γ· Hours Per Day (HPD)
  2. Add Delays = Total delay value from all delay fields
  3. Add Start Day = +1 if "Include Start Date" is ON
  4. Sub Total = Work Days + Delays + Start Day adjustment
  5. Add Non-Working Days = Weekend days + Holiday days (if not included)
  6. Target Date = Start Date + Total Calendar Days

Example: An RO with 20 hours at 5 HPD = 4 work days. With 2 days parts delay, "Include Start Date" ON, and weekends excluded, the calculation might be: 4 + 2 + 1 = 7 working days, plus 2 weekend days = 9 calendar days from start.

Estimate Levels

The table in the middle column shows the breakdown by estimate level:

⚠️ Note: New or changed estimate levels are highlighted in yellow until saved.

Calendar View

The right column displays a two-month calendar with color coding:

Note Builder

Click the Note button at the top of the right column to switch to the Note Builder view. This helps you create standardized documentation notes.

Note Builder Fields:

The note preview updates automatically as you fill in fields. Click Copy to copy the note to your clipboard for pasting into CCC or other systems.

Saving the Target

Click Save to store the target date calculation for this RO. Saved data includes:

πŸ’‘ Tip: When you reopen the calculator for an RO with saved data, it will restore your previous settings. If the RO hours have changed, a new supplement level will be automatically created.
↑ Back to Top

Auto Print

ℹ️ Auto Print info: Auto Print allows you to configure and print multiple reports at once with a single click. The idea here is that when you know what reports and how many you want to print each morning, you can adjust the settings to print and remember what you want to print every day and you can do so with this feature. In addition, you can override the settings for a one-time print. For instance, you may have 25 reports you print on a daily basis and auto print is set up to print those, you can still print a selection of reports like 1 for each tech. Just clear the auto print, select 1 for each tech, print and then close the auto print without saving. It will retain you daily report settings.

Accessing Auto Print

  1. Click the Auto button in the toolbar
  2. The Auto Print configuration window opens

The Auto Print Window

The Auto Print configuration window displays two tables:

1. Print Types Table

Lists all available report types you can print. Each row shows:

Special "Each" Report Types: Some reports automatically print one copy for each person:

Type Behavior
Each Writer Go List Prints a separate Go List for each estimator
All ROs Each Writer Prints All ROs filtered by each estimator separately
Writer Pre-Production Prints Pre-Production report for each estimator
Writer Production Prints Production report for each estimator
Each Tech Prints Tech report for each body technician separately
Each Painter Prints Refinish report for each paint technician separately

2. Sublet Categories Table

If you have sublet categories configured in Settings, this table allows you to print separate reports for each sublet type (Glass, Alignment, A/C, etc.). Set the quantity for each sublet category you want to print.

Setting Quantities

  1. Click on a row in either table to select it
  2. Use the + and - buttons to adjust the quantity
  3. Set to 0 to exclude a report type from printing

Saving Your Configuration

Click Save to store your Auto Print settings. Your configuration is saved on a per shop basis so all users logged in to this shop will see and print the same list of reports.

Running Auto Print

πŸ’‘ Tip: Use Preview first to make sure everything looks correct before printing. The preview shows all reports combined with page breaks between each one.
Example Configuration:

If you have 3 writers and 5 techs, this would print: 2 + 3 + 5 + 1 = 11 total report pages

↑ Back to Top

Keyboard Shortcuts

Shortcut Action
Ctrl + Shift + R Program reset
Esc Close current form/popup and collapse expanded detail row
Ctrl + P Print current view

Mouse Actions

Action Result
Click row Expand/collapse detail row
Click column header Sort by the selected column
Click editable cell Open editor for that field - estimator, techs, repair plan comments and sublet
Shift + Click filter dropdown Additional filter on the current report
↑ Back to Top

Troubleshooting

Data Not Updating

  1. Verify CCC is exporting to the correct folder. By default it is C:\CCCExport
  2. Click Refresh to manually reload file from CCC
  3. Check your internet connection

Grid Shows "No Data"

Changes Not Saving

Slow Performance

Print Issues

Print Window Not Opening (Popup Blocked)

If clicking Print does nothing or you see a popup blocked message (Chrome):

  1. Look for the popup blocked icon in the address bar after clicking Print
  2. Click the icon and select "Always allow pop-ups from this site"
Click popup blocked icon to allow popups

Or manually enable popups:

πŸ’‘ Tip: The popup blocked icon usually appears as a small window with an X in the address bar, near the bookmark star.

Need more help?
Contact your system administrator or support at (310) 397-9000.