Lean - DB

Lean - DB Overview

"Your IR Program is determined by how well you manage your data"!

With Thermal Trend - Lean DB, your information is where you need it—in the palm of your hand—on the plant floor!

 

Lean DB is an easy and effective Enterprise Database system for the Pocket PC and Desktop computers, which allows you superior data management and analysis of your facility's Infrared PdM Inspection Program. The desktop & Pocket PC, share the same database. The only difference between the two versions is that the desktop version has report generation and data export capabilities.

 

You literally take your database right out onto the plant floor, which allows you access to all of the information needed to easily locate equipment that is to be inspected, review equipment’s past problem history, and quickly document any conditions that you find. When using a Pocket PC in the field, you can review information previously recorded into Lean DB and you can record your current findings directly into the database at the time of inspection.

 

Because the desktop & Pocket PC, share the same database, Lean DB reduces the amount of redundant data entry associated with flat file reports, and eliminates errors due to misspelling and mistakes associated with entering the name of a piece of equipment in two different ways. This eliminates the costly time spent in the office typing up the report since everything is already in the database. All you have to do is just select the report that you want and hit the print button.

 

Thermal Trend - Lean DB as compared to other products on the market offers you:
 

  • Open Architecture, non-encrypted database!
  • Works directly with your IR files, no need to save to a bmp format! No out files!
     
  • No ASP hosting of your Data, and no expensive out file fees!
     
  • No expensive hardware requirements, or IT requirements for servers, etc.
     
  • You own your own database! No strings attached.
     
  • You have complete control of your own data, when you want it, where you want it! The database is on your own Desktop/Notebook computer, and on a Pocket PC device.
     

 

Designed . . . by Thermographers, for Thermographers!
 

 

Over 17 years of work and experience from the thermographer's point of view have gone into developing the methods that are utilized in Thermal Trend - Lean DB. Lean DB provides you with the fastest, most reliable and comprehensive method of automated data collection in the field and report generation for electromechanical infrared inspection programs.
 

Thousands of hours of professional development and in-the-field testing have gone in to producing the next generation of Thermal Trend. Lean DB is built upon proven track record of reducing costs while increasing productivity and accountability for PdM programs world wide.
 

Lean DB is the clear choice for any company contemplating how to start or improve the management of their infrared program.

 

 

Take a Tour — Introduction

Flexible Hierarchal Tab Navigation works the way you do!

At the core of Thermal Trend Lean DB is a powerful SQL database that manages all the data associated with your Infrared PdM program — from scheduling your inspection all the way to generating your reports.

User Interface Comparisons

Thermal Trend Lean DB User Interface
for the Desktop and Pocket PC
(view larger image)

It provides an intuitive user interface marked by a series of tabs across the top of the screen.

These tabs allow you to easily navigate through the hierarchical architecture of this robust relational database to gain access to your data quickly and easily.

Both the desktop and Pocket PC software programs have the same look for ease of use and faster learning of the program.

You have no more frustration over trying to remember where to go to access your desired information, or needing to complete one form before changing to another.

When you are ready to conduct your first inspection using Thermal Trend Lean DB, all you need to do is create your site and begin entering your inspection details.

The beauty of using Thermal Trend Lean DB with the Pocket PC is that you will be able to build your route and record your inspection details as you are conducting your inspection. This saves time and offers the assurance that your equipment inventory and associated inspection records will be complete and accurate.

Thermal Trend's intuitive user interface allows you to navigate efficiently for any details at any time. It also allows you to roll up data sets to easily review large amounts of data quickly. The structure of the tab navigation is broken down into seven parts:

  • Sites Tab
    • Create and synchronize your databases
  • Inspections/Reports Tab
    • Create and enter inspection data.
  • Route Tab
    • View and create inspection routes and test status.
  • Items Tab
    • Associate problems with appropriate equipment.
  • History Tab
    • Track and trend problem status over multiple inspections.
  • Details Tab
    • Record detail information about items.
  • Images Tab
    • View and analyze infrared and visual images with Image Analyzer. 

Create your sites and synchronize your data

A site is a single entity where an overall grouping of inspection data is required. It is the top most level of a particular route -- that is, it is the starting point for all inspections conducted at a specific location.

Lean DB Sites Screen User Interface

Lean DB Sites Tab User Interface
(view larger image and additional details)

 

The Sites Tab allows you to add a site, select an existing site, rename a site and delete a site.

You can create as many Sites as you need for different facilities, or specific routes through your facilities. No additional software is required!

From the sites screen, you can readily identify details of a site such as Customer Name and/or Site name, Address information and Contact Information. It also allows you to group sites which may share common characteristrics such as electrical facilities, ships, manufacturing plants, etc.

The site screen presents this information in a columnar format and allows you to filter your site data by simply clicking on the column headings.

Before the inspection is performed, the database can be synchronized with a Pocket PC so you can have access to the complete inventory and associated test status of every piece of equipment while performing your inspection. You literally take your database right out onto the plant floor, which allows you to review information previously recorded into Lean DB and allows you to record your current findings directly into the database at the time of the inspection.

Once your inspection is completed, you can synchronize the database back to the desktop where you can further analyze your findings and report on your results.

 

Create Inspections and Reports

Inspections Tab User Interface

Lean DB Inspections Tab User Interface
(view larger image and additional details)

 

You can create as many sites as you require. A site can be for different facilities or for different routes throughout your facility.

You create inspection records for each site that details when the inspection was performed and includes general notes regarding the inspection.

Printing reports is easily accomplished by selecting the specific inspection that you wish to run the report on and selecting the type of report that you wish to run.

To view the data in the database just use the intuitive drill down tabs.

It’s that simple.

 

Find your equipment quickly and easily

Lean DB Routes Screen User Interface

Lean DB Route Tab User Interface
(view larger image and additional details)

Easily navigate through your equipment inspection list by using a “hierarchal route view” of where your equipment is located.

You can organize your routes in any way you like, with the flexibility to work any way you choose.The user interface is intuitive and powerful.

The standard explorer view lets you easily navigate through your facilities equipment.

Key information about location, equipment and problems remains on the screen in front of you.

 

  • Add and or edit equipment (stop light icons) and locations (doors icons) to your inspection routes.
  • Use barcodes, asset IDs, GPS or name to quickly search for a specific location or equipment in your route inventory.
  • Check off what has been tested or not-tested.

“Smart Icons™”

Identifying RoutesUsing the intuitive "smart icons™" you can easily organize your equipment by locations based on the best way for you to effeciently conduct your inspection.

You can also quickly reconcile any open or closed problems as well as review test status on equipment.

Locations

Doors represent locations within your facility where other locations or equipment is located. The color of the door represents the status of the problems that are contained within the location (a reflection of the equipment problem status).

Green DoorGreen means no problems have been found.

Yellow DoorYellow means there have been problems in the past found in this location that have been verified to be fixed correctly and the problem status was closed.

Red DoorRed indicates that there is an open problem in this location.

Equipment

Stop lights represent equipment that is to be inspected. The color of the stoplight represents the problem status.

Green Light IconA green light means that no problems have been found on the equipment.

Yellow Stop LightA yellow light means a past problem has been found and that it has been repaired and verified with infrared to have been corrected.

Red Stop LightA red light represents a piece of equipment that has an open problem that has not been fixed.

Location And Equipment Test Status

Green Check MarkA green check next to a piece of equipment or a location indicates that the equipment or location has been tested.

Red Check MarkA red check next to a piece of equipment or a location indicated that the equipment or locations has not been tested. 

 

Quicky reconcile status of past problems

Lean DB Items Screen User Interface

Lean DB Items Tab User Interface
(view larger image and additional details)

Items that are found during the inspection are associated with the appropriate equipment that was selected from the Route tab.

This allows you to automatically filter your item list by the entire site, a location, or a specific piece of equipment.

Create, re-document and close Items.

item types

Thermal, Corona, Visual, Roof, Ultrasound, Regulator, Transformer/LTC, Batteries, Pole Trends, Inspection Notes, and repairs are easily tracked as well as Baseline Trending of equipment.

Open Thermal Problem  Open Thermal Problem  Closed Thermal ProblemClosed Thermal Problem  Open Roof ProblemOpen Roof Problem

Open Corona Problem  Open Corona Problem    Open Visual ProblemOpen Visual Problem      Baseline TrendingBaseline Trending

Track Repairs  Track Repairs

Problem status reconciliation allows you to track past problems and check if they have been repaired correctly or if they have come back!

Green Check MarkA green check next to a piece of equipment or a location indicates that the equipment or location has been tested.

Red Check MarkA red check next to a piece of equipment or a location indicated that the equipment or locations has not been tested.

Export problem lists to Excel for creating “Cost Benefit Analysis” reports showing the before vs. after costs.

 

 

View Time Over Temperature Trending and Changes in Severity

Lean DB History Screen User Interface

Lean DB History Tab User Interface
(view larger image and additional details)

“Time over temperature trending” of problem statuses is tracked over multiple inspections automatically as well as scheduling of repairs and corrective actions.

One problem that has been documented in an earlier inspection can have multiple occurrences in the following inspections.

 

 

 

 

 

 

Lean DB History Screen User Interface

Lean DB History Tab User Interface
(view larger image and additional details) 

 

Review specific details for the different items and repairs!

Lean DB Detail Screen User Interface

Lean DB Detail Tab User Interface
(view larger image and additional details)

View past problem data, photos and thermograms. (Works directly with Mikron SIT image files, FLIR jpg files, or standard Windows file formats).

  • Add voice annotation files as attachments for further reference.
  • Enter, update, re-document or close-out Item / Problem data.

 

Grab the power of Thermal Trend - Image Analyzer for full control of your IR images

Lean DB Images Screen User Interface

Lean DB Images Tab User Interface
(view larger image and additional details)

 

The power of Thermal Trend - Image Analyzer is incorporated into Lean DB, allowing you full control of your IR images: SIT, IMG, JPG, TIF, IS2 file formats!

You have all of the analysis tools in Image Analyzer that you can link directly into the database. No need to have to resave your IR images as bmp files to be able to work with them.

 

 

 

 

View both IR and visual images.

Lean DB Images Screen User InterfaceLean DB Images Screen User Interface