Category Archives for "Fleet Maintenance News"

[Video] How To Export Reports To Excel

We have ro remove the Excel Export button on a large number of  report because Excel was rendering EEquipment numbers with dashes in them as dates and some dates as numbers .

there is a new way to get any report to excel here

https://tatems.com/blog/video-how-to-export-print-reports-to-pdf-and-convert-to-excel-spreadsheet/

The video below shows you how to export a TATEMS Fleet Maintenance Software report to Excel

It also talks about some of the limitations with complex reports.

Ans it mentions the raw data field names that display once the exported report opens in Excel

And it briefly goes over the custom spreadsheets that let you import live data from TATEMS into -> Excel, rather than exporting from a TATEMS Report out to Excel

Thanks for watching!

 

Video – Lube Service Reminder With Filters Report

This 4-minute video shows you what you will find inside the Lube Service report called Lube Service Reminder With Filters and can be found  found in TATEMS under Reports->More Reports->Report Type: Lube/Service

You will also discover how to use the unique sorting criteria for this report so that you can sort by multiple To Go before it's due columns.

Video For Spreadsheet 50

This video goes shows you how to link spreadsheet number 50. TATEMS-PartsVendorHistoryOfInstalledPartsCosts, to your TATEMS database using:

Excel 2016 (should also be the same for Excel 2013 and Excel 2019)

and

Excel 2010 (should also be the same for Excel 2007)

It also goes over how to create the same spreadsheet from scratch if you get an error when you try to link it to your TATEMS data.

You'll also see the spreadsheet columns and how to filter the columns in Excel

the columns are

Parts Vendor

Reference #

Part #

Part Desc

Cost Each

Qty Installed

Total Cost

Date WO Requested

Date WO Completed

Work Order#

Equip #

So to sum it up you will see the Parts Vendor Costs For All Work Orders In Your Fleet and you'll be able to filter by any af these columns.

For example, you can choose to see only what you spent and the parts purchased from a specific vendor for a spefic date range.

You can get this and the other spreadsheets by clicking here

If You get an error when you try to link to the TATEMS database I have another video here that shows you how to get it working

I hope you found this helpful!

Thanks Again

Marc

 

[Video] Making Work Easier And Faster With TATEMS 4.6.24q

In this video I go over some of the improvements we worked on for version 4.6.24q released Aug 25, 2018

Making Your Life Easier And Faster With TATEMS 4.6.24q

⏳Added Button To Open Preferences From Work Order Screen
⏳Added Button To Open My Company Info From Work Order Screen
⏳Added Check box in Preferences to only show Billing Terms On Invoice
⏳Added Double Click to open and edit Service By Dropdown Maintenance
⏳Added Double Click To Open and Edit Short Description Dropdown List Maintenance
⏳Added Double Click To Open My Company Info From Tax Percent Field
⏳Improved Short Description Data Entry Experience to prevent accidental typing over Detailed Descriptions
⏳Added Double Click To Open Personnel Screen From Work Order Labor
⏳Added Double Click To Open And Edit Work Order Labor Descriptions
⏳Added Double Click To Open And Edit Part Parts Manufacturer from Work Order Parts
⏳Added Double Click To Open And Edit Part Parts Vendor from Work Order Parts
🕶Increased The Visual Size Of The Part Number Box on Work Orders
🕶Increased the Visual Size Of The Part Number Box & other fields on Parts Inventory Screen
⏳Added Double Click To Open Dropdown List Maintenance On All Parts Inventory Dropdowns
⏳Added Double Click To Open My Company Info from Parts Inventory Price Increase Box
⏳Added Parts Manufacturer Dropdown List Maintenance Screen and Menu Item

 

There were actually over 33 updates for a grand total of 92 improvements so far since version the last version of 4.6.23 which was 4.6.23g

You can see the list of what we have been working on here:

https://tatems.com/updates/updatelist.cfm

And you can get the latest updates here:

https://tatems.com/updates

 

New Innovations In Heavy Duty Diesel Engines Guaranteed To Transform The Industry

Rudolf Diesel invented the diesel engine over 100 years ago, which was instrumental to the replacement of the steam engine. The diesel engine underwent various changes after the death of its inventor. Today, the diesel engine still has potential for modifications to increase its efficiency with regards to power output, fuel economy, and cleaner exhaust fumes.

The gasoline engine might have surpassed the diesel engine in terms of popularity, but recent advances in diesel engine fuel systems and engine technology are likely to make the diesel engine highly desirable for heavy transport, agriculture, and other systems in the coming years. Caterpillar, Cummins, and other leading diesel engine manufacturers are making advances in terms of refining the traditional diesel engine.

Numerous aspects of the diesel engine have been subject to treatments and modifications over the years in an attempt to increase its efficiency. Engine produce power through the ignition of a mixture of fuel and air to produce energy. In a gasoline engine, the initial ignition is performed by a spark plug. However, the ignition happens directly in a diesel engine without the use of a spark plug.

The air is initially introduced into the combustion chamber where it is subsequently compressed highly and it is heated to as high as 1000°F. Fuel is then injected directly via the pre-chamber into the combustion chamber. The fuel is vaporized due to the extreme heat and it ignites. As ignition heats the air further, it expands and drives the pistons that move the crankshaft.

The efficiency of diesel engines depends on how efficiently the fuel droplets are injected into the pre-chamber. The more widely distributed and the smaller the droplets are, the higher the efficiency of the diesel engine.

The most recent diesel engines have modified pre-chambers and combustion chambers for maximum combustion acoustical attenuation. The engines are turbocharged to ensure maximum power output and performance. The nitrous oxide fumes are then subjected to treatments such as Selective Catalytic reduction and Exhaust Gas Recirculation to minimize emissions in different ways.

The following is a detailed look at the treatments and modifications starting with those already implemented and those still under review.

Innovations in Heavy Duty Engines That Have Already Been Implemented

1. Engine Modifications

I. Combustion Chamber Modifications

Today’s heavy-duty diesel engines have combustion chambers configured and sized to ensure maximum rates of combustion. The greater the rate of combustion, the higher the fuel efficiency and power output and the lower the exhaust emissions.

II. Sound Attenuation

People often associate heavy-duty diesel engines with high noise levels. The noise usually occurs when starting the engine when the fuel is injected into the pre-chamber than vaporized at high temperatures. Advancements in sound attenuation strategies and materials have made it possible to reduce noise levels in these engines significantly.

This is achieved by installing sound attenuation pockets in the pre-chamber. The pockets are designed such that they nullify the detonation waves that combustion causes. The pockets may alternatively be filled with metallic ceramic or porous pellets coated with rhodium or platinum. Rhodium and platinum act as catalysts for ensuring complete combustions while the pellets attenuate the noise levels.

Other modifications for sound attenuation involve the placement of attenuating materials such as sintered or porous ceramic metal close to the mouth of the passage the connects the pre-chamber to the combustion chamber.

2. Advanced Fuel Treatments and Fuel Systems

I. Common Rail Fuel Injection

The Common Rail Fuel injection system is a type of direct fuel injection system that injects fuel from the fuel tank into separate piezoelectric or solenoid valves. Fuel is stored in the fuel tank at high pressures. The CRF is an injection system monitored electronically that allows for more control over the quantity and time of the fuel injection.

The Common Rail Fuel injection system is designed to maintain high-pressure levels to homogenize the mixture of air and fuel by facilitating finer fuel vaporization. This ensures complete combustion and leads to higher power output and lower emissions. Advances in the system include modifications that allow for up to 5 fuel injections for every combustion cycle, which improves fuel economy.

II. Fuel Composition

Diesel fuel usually contains high levels of sulfur. During combustion, diesel fuel produces high particulate matter emissions that tend to clog emission devices and affect the performance of engines. However, a newer version of diesel fuel has been formulated with a lower sulfur content thanks to the Environmental Protection Agency (EPA) mandates that went into effect in 2006.

3. Emission Treatments

1. Selective Catalytic Reduction (SCR)

The Selective Catalytic Reduction method utilizes a reducing catalyst such as aqueous or anhydrous ammonia to convert NOx into water and diatomic nitrogen. While the method was patented back in 1957 and has been used for a long time in commercial boilers and waste management systems, it has only been recently integrated with diesel engines. It can reduce NOx emissions by as much as 95 percent.

2. Exhaust Gas Recirculation (EGR)

Combustion in a diesel engine occurs at very high temperatures with NOx formed as a byproduct. NOx emissions at particular levels can be harmful to the environment and should thus be regulated. Exhaust Gas Recirculation is a treatment used by manufacturers of diesel engines to lower NOx emissions.

In the treatment, part of the exhaust gas is recirculated back into the engine and then mixed with air in the combustion chamber. The process lowers the temperature of the adiabatic flame and increases the heat capacity of the mix and allows for combustion at lower temperatures and reduces the formation of NOx formation, which is usually maximized in the presence of ample oxygen and high temperatures.

Innovations in Heavy Duty Diesel Engines Currently Under Review and Being Slowly Implemented

1. Variable Valve Actuation (VVA)

Variable valve actuation for heavy-duty diesel engines is basically the same concept used on light-duty automotive engines. However, the heavy-duty engines operate at a lower engine speed compared to automotive engines, which means that valve activation and timing have to be optimized differently. It should also meet the engine’s useful life, which is usually over 5 times longer than a regular automobile engine.

Variable valve actuation is also a technology that enables other technologies including cylinder activation, bottoming cycle and/or Atkinson cycle operation when higher low-speed torque is more important than high peak power.

If VVA is optimized for the operating cycle of the engine, it is possible to reduce parasitic losses, which allows the engine to operate in a higher range of efficiency. It is possible to achieve an increase in efficiency of between 2 and 3 percent. However, due to cylinder deactivation, reliability and durability concerns should be understood and addressed.

2. Waste Heat Recovery

The conversion of waste heat into energy is an issue that has been getting a lot of attention in the heavy-duty diesel engine industry, and for good reason. Waste heat accounts for about 50 percent of the energy produced in an engine. Recovering the energy from wasted heat is an area where waste heat recovery systems are used for recapturing energy.

The two main methods used in the recovery of the energy are direct and indirect.

The direct methods use the waste heat to generate electricity by use of a thermoelectric generator. The Thermoelectric generator uses dissimilar materials to generate electricity when exposed to a temperature delta. The electricity produced can be used for supplementary accessory loads through the reduction of power needed from the mechanical power transfer of the engine via the crankshaft and instead produce and store energy.

The indirect methods use the waste heat from the coolant or waste exhaust heat to generate electrical or mechanical power. The Rankine cycle is the most common approach that uses the heat for generating heat and turning a steam expander.

Goals have been set to develop waste heat recovery solutions that can improve the fuel efficiency of heavy-duty diesel engines by more than 7.5 percent by 2020.

The greatest challenges for waste heat recovery solutions to reach commercialization is the cost reduction and how to increase efficiency. Thermoelectric generators currently are about $3,000 per kW, but the target is below $1,000 per kW.

Waste heat recovery operates on the principle of extracting energy from the temperature differential present between 2 heat sources. The efficiency pf the system thus depends on the exhaust temperature or duty cycle of the engine.

Research is underway to find cheaper materials that can operate at lower temperatures. The developers of technology are also working with exhaust system integrators to reduce the packaging space as well as manufacturing costs.

3. Closed Loop Combustion Control

Closed loop combustion control refers to the ability to have real-time control and monitoring of the process of combustion. It makes it possible to optimize the peak cylinder pressure and optimize the fuel injection strategy for a wide variety of environments and operating conditions. Closed loop combustion control is expected to provide an increase in efficiency of between 2 and 4 percent over the standard open loop control.

However, adding complexity to the system results in additional cost and potential reliability risks. Sensors have to be added to the cylinders for monitoring temperature and pressure, along with the NOx sensor as well as a controller capable of processing data quickly. It can add between $30 and $50 for every cylinder. However, the base technology has been shown to be effective in automotive engines and it is thus an issue of scaling and adapting it to heavy-duty engines.

4. Engine Downsizing

Downsizing refers to an engine with a smaller engine displacement, but capable of matching the performance of the original engine. The aim is to reduce engine displacement by over 10 percent that translates to an improvement in fuel efficiency by between 1 and 4 percent.

Downsizing might be more prominent on smaller off-highway equipment than in heavy-duty applications. In some instances, down speeding can be used to provide efficiency improvements. For instance, reducing the engine speed by 200 rpm can lead to an improvement in fuel economy by 1 to 3 percent.

Increasing the cylinder pressure is correlated to the effective compression ration as well as complete fuel ignition. It is not possible to do either of these without thinking about the additional stresses that will be placed on the cylinder heads, engine block, etc.

Design and material selection is critical when it comes to engine downsizing. The trend is towards high strength iron allows that show a 75 percent increase in tensile strength when compared to cast iron. A newer material providing increased strength as well as the potential for smaller package size is compacted graphite iron.

Another area targeted for improvement is in-cylinder fuel/air mixing and fuel injection. Fuel pressure is likely to continue to increase for improved fuel combustion and delivery that results in reduced emissions and enhanced performance.

Improving the injection strategy and spray atomization are other advancements to the fuel delivery system where work is underway to improve mixing and avoid spraying the cylinder walls that results in an increased amount of soot as well as cylinder wall washing.

The designs of pistons and heads are also getting attention in an attempt at increasing combustion efficiency. It builds upon existing technologies such as the Twin Vortex Combustion System from Ricardo that’s currently used to reduce the amount of soot.

The Bottom Line

The technologies discussed here are just some of the few likely to become more common in the next wave of deployment of technology as drivers such as laws governing emissions and the continued economic incentive to lower the operating costs remain.

The market forces are constantly applying pressure for stricter engine requirements and the trends towards improvements in fuel system efficiencies, engine modifications, and emissions treatments are likely to continue in the coming years.

Expectations are likely to be met with innovative technologies that result in improved efficiency, lower emissions, and improved productivity for heavy-duty diesel engines. All these will help heavy-duty diesel engines become even more powerful and efficient as diesel innovators work to complete with the hard-charging competition faced from electric motor and battery makers.

Video [16 min] How to import TATEMS Work Orders Into Quickbooks

In the video below I show you how to use the custom spreadsheet I created called:

120. TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImport

You can find it here:

TATEMS Fleet Maintenance Software Custom Spreadsheets 

You can use it to import Work Orders you created in TATEMS into Quickbooks using a 3rd party tool called Zed Axis .   (They have a free 3o day trial and the cost is under $200 for Zed Axis)

Here are the steps to Import from TATEMS Fleet Maintenance Software To Quickbooks.

  1. Create or Edit Lists in Quickbooks so that you have these 3: Work Order, Parts and Labor (you only need to do this one time)
  2. Open the custom spreadsheet and link if to your TATEMS data file (you only need to do this one time as long as you save the spreadsheet)
  3. Filter the list of work orders in Excel using the Date Completed Field
  4. Copy and paste the invoices including the row with the header names from the list on sheet 1 to Sheet 2 in Excel
  5. Save the spreadsheet but leave it open.
  6. Make sure Quickbooks is open using the Quickbooks  Company file you want to use.
  7. Create a Custom Invoice Layout that adds the “Other” Field In Quickbooks. (This is to display the Equipment Number on the Invoice) and set it as default.  (you only do this once but may need to set it as default each time if you use a different default )
  8. Open Zed Axis and choose Quickbooks Desktop and click the Connect button to connect to the currently open Quickbooks company file
  9. Click the Import Tab in Zed Axis and link to the Excel File
  10. Choose Sheet 2
  11. Create or choose a Mapping Template of the Fields to Map from the Excel Spreadsheet to Quickbooks (You can import the template I already created into Zex Axis.  Right click and Save  http:///pchelpltd.com/tatemsdl/download/TATEMSImportMappingForZedAxis.xml  Then click on the Choose Mapping Dropdown->Import Mapping.  The template only needs to be created or imported once and then can be reused in future imports )
  12. On Import Options Choose your preference “If Already exists” you can choose for example “Skip” to skip importing invoices that have already exist with the same invoice number inside Quickbooks .
  13. If all your invoices that you want imported are selected in the list then click the import button and the process will show you the status until it’s completed.

As noted above many of these steps only have to be completed one time. 

If you are current on your TATEMS support and version upgrades and you need any further customization on this spreadsheet that pulls data from TATEMS and I can get it created for you.

 

All The Best!

Marc Ready

Video of Top 9 Updates to TATEMS Version 4.5.04 released Nov 16 2013

Hi,

I just wanted to give you a quick video rundown of the top 9 updates out of about 24 updates released starting with version 4.5.00 through 4.5.04

Click here to watch a non-YouTube version of video

Here is the list that I go over in the video:

1)      Added Repair Codes Fields to Work Orders Labor and Parts Screens so that you can better categorize costs when multiple repair categories done in a single Work Order

2)      Added list of 15 Repair Codes and descriptions to Repair Codes List

3)      Added new report All Equipment Reports-Repair Codes Cost / Mile/km / Hour Report

4)      Added new report under Work Orders in More Reports called All Work Orders Repair Code Totals by Repair Code

5)      Added new report under Work Orders in More Report called: Work Orders Total Costs by Repair Code

6)      Added Dropdown List Maintenance choice for Repair Codes

7)      Added Work Orders List under forms menu to allow you to see all work orders in one sortable list that show you All or Completed or Non-Default Tax Rate work orders and be able to click to view/edit and work order in the list

8)      Added new Work Orders report under More Reports called: All Work Orders with non-default sales tax charged

9)      Added Edit button to Parts inventory screen to help prevent accidental overwriting of current parts in inventory and changed add button to prevent accidental scrolling to previous record

You can see all the updates here:

http://tatems.com/updates/updatelist.cfm

and I have added a new training video to the updates page where you can download the current update

http://tatems.com/updates.cfm

Thank you for your interest and please leave any comments below.

Marc Ready

New short Video shows new dropdown added to Lube Service – Accomplished by

In the current version of TATEMS “4.3.00” we have added a dropdown to the Accomplished By field so you don’t have to keep typing the same person over and over again, or worry about misspellings.  If you choose to add them to the dropdown you will be presented with the personnel form so you can add the new person.  You also have the option to not add them to the list and they will still be logged as the accomplished by person or entity for that particular Lube Service.This very short video shows you how it works.

Is this helpful for you?   By the way,  I have to get a tooth pulled on Wednesday Feb 23rd at 11:30 AM PDT so I may not be available for the rest of the afternoon.  Wish me luck!

1 … 4 5 6