| LOG IN | SIGN UP Shopping Cart


 Case Studies

RateExplorer - world-wide shipping system

posted on 4/2/2018 6:51:00 AM

Atlas International performs world-wide shipping of a large variety of goods. One of their biggest challenges is to find the most cost effective solution for each of their clients while assuring a great shipping quality. Their constant hassle of finding the correct vendors having good rates on the required services and having a good overall scoring is greatly improved by their software systems like Traffic II, Rate Quote, Rate Explorer and Vendor Rates. Some of these require massive amounts of data changes at one session or data mining operations and reporting. This is where EasyXLS comes in to help.

Due to its flexibility and good design EasyXLS became an integrated part of the systems and is used to easily export data in nicely formatted excel files where the people can use their knowledge to create reports, find what they are looking for or simply change the data and import the changes back to the application without any effort. A great number of people would rather work in excel than in any other application. This used to have many downsides amongst which concurrency issues and correct data versioning were only two of them. Now that standardized excel files can be read, written, imported and exported from or into any application these problems went away while allowing experienced workers to benefit from their excel expertise.

VMS - Vehicle Management System

posted on 2/19/2018 5:50:00 AM

Subaru Distributors Corp is the manufacturer’s representative for the Subaru brand of vehicles in New York state as well as Northern New Jersey. They have 65 retailers that represent the region and through a franchise agreement they represent the Subaru car brand in all aspects. They support these dealers by wholesaling vehicles, parts and accessories through their facility in N.Y.

VMS is an internal management system created for SDC and their affiliated retailers.

We decided to use EasyXLS to export files, to upload files into the system and also to create reports.

This tool has been proven to be developer’s best friend. The exports were done fast and could be formatted exactly the way we wanted them.

The code for export and upload is very concise and the results are user friendly.

The most gratifying part of using EasyXLS was creating reports.

We could do basically anything that could be done on an Excel file so the clients were very happy.

iTerm - Terminal Management System

posted on 7/31/2017 7:48:00 AM

iTerm is a terminal management system which meets the needs of the smallest terminal, but whose design allows it to scale and flex to meet the needs of large operations with terminal, rail and vessel management needs.

A system which has a flexible inventory management model, providing the simplest of in/out functions, but also has the ability to support detailed reporting and planning functions.

EasyXLS™ is integrated as a reporting tool used to generate fast, accurate, easy to read, xls/xlsx inventory and activity reports.

EasyXLS™ was the most easy to embed component on a pre-existing platform with great impact on speed and usability of the reporting functionality of the system.

Easy Tasking - Task Management System

posted on 1/25/2017 7:53:00 AM

One of the biggest customers for Easy Tasking, needed to create accounts for all their users, and started out manually adding them. It was excruciating work, we had to change something.

They really needed something fast, and powerful.

That is when we came up with the idea, to use EasyXLS.

We created an excel template which they filled with all the information needed for our system. The actual implementation didn’t even take long, thanks to the well-structured, properly documented EasyXLS.

Import is a couple of clicks away, and they saved a lot of time. They can do this again over and over again, anytime they need to add more users.

Since then, we added even more possibilities to our project, they can export all our reports, upload data, ultimately make their life a lot easier.

eTERM - Inventory Status Reporting

posted on 4/16/2013 8:18:00 AM

eTERM is a facility management system that bridges the terminal community (terminal, ocean lines, truckers) by providing remote access from anywhere in the world. It has a proven track record of meeting the demands of small terminals as well as large operations with terminal, rail and vessel management needs.

The on time management decisions as well as short and long time planning are facilitated by the use of the feature-rich, highly performing EasyXLS™ component that transforms the raw data into easy to read, comprehensive inventory snapshots delivered via xls / xlsx exports.

EasyXLS™ is part of the winning formula that has enabled eTERM to emerge as a better, faster, more cost effective way to manage intermodal terminals.

ComPair Data – World Liner Supply Analytics

posted on 7/4/2012 7:48:00 AM

ComPair Data gathers detailed vessel voyage schedule information on liner services on a global basis, enabling companies to more effectively manage and control the procurement of ocean carrier services.

ComPair Data tracks rotation, transit and capacity data on the liner services operated by ocean carriers on all important trade routes making ComPair Data the most comprehensive database of liner shipping available today. 

Delivering business critical information to clients is achieved by using the extremely flexible EasyXLS™ solution that enables users to receive targeted information in MS Excel format. 

EasyXLS™ ensures that ComPair Data clients receive vessel deployment, trade route and transit analysis information on virtually every global trade lane.

CMS - Chassis Management System

posted on 3/22/2012 11:24:00 PM

Consolidated Chassis Management, LLC (CCM) is an affiliate of the Ocean Carrier Equipment Management Association, Inc. (OCEMA), and responsible for developing chassis pools in the US. Their Chassis Management System application uses EasyXLS™ extensively as it proved to be not only the most reliable and flexible solution, but also the best option when it comes to importing or exporting large amount of chassis pool related data. EasyXLS™ makes possible the import of thousands of records into the system and then offers the capability of exporting them into carefully formatted MS Excel files.

The uniqueness of Chassis Management System is represented by its robust reporting capabilities.The system's wide range of reports, that includes financial, terminal inventory and chassis utilization reports, can be rendered to the user in an MS Excel File that keeps the exact formatting of the web reports. Another remarkable application of EasyXLS™ is the auto-scheduled reports functionality that generates and emails the reports to the selected recipients in a matter of seconds.

SATIAMO - saves time and money

posted on 11/6/2008 5:12:00 AM

SATIAMO is a integrated procurement solution that
- SAves TIme And MOney -
during the daily business in purchase departments of companies.
Therefore SATIAMO provides features to easily call for tenders,
manage bookings and subcontractors and to control costs during the complex process of purchasing.
Like in no other business excel is ruling the daily workflows in those departments.
EasyXLS is the component that bridges the gap between the daily business and SATIAMO.
It provides us with the necessary flexibility when importing and exporting large datasets and generating reports.
This way our customers and their subcontractors can do their work in the Microsoft environment,
they are entirely comfortable with and can later on import the data to the system.
From the software-developer side of view all those things can be implemented due to EasyXLS very simple and fast.
Even the important criterion of performance leaves nothing to be desired and requests, even for large datasets, can be serviced in an appropriate amount of time.
The EasyXLS generated files are rather small compared to other Excel-libraries on the market, proofing somehow that EasyXLS-developers did a good job.

SHPA - Pilot Dispatch Reports

posted on 3/3/2006 6:47:00 PM

The Sandy Hook Pilot’s Association (SHPA) www.sandyhookpilots.com pilots are responsible for ensuring the safe passage of all shipping traffic entering or leaving the tri-state area. With more than one hundred pilots and well over 12,000 trips per year, they play a pivotal role in the east coast’s commerce. To schedule, track, and manage the shipping traffic, SHPA leverages the eOPS pilot dispatch system, ePilotstm. While ePilotstm provides numerous HTML based reports that works well when displayed on a computer screen, the ‘back office’ needs data in a format that is both electronically redistributable and that can be ‘reworked’ for ad-hoc requests. 
With uptime requirements of 24x7x365 the solution had to be extremely reliable, and with very large data volumes in many of their yearly reports, the solution had to be very quick. With Microsoft Excel as a clear choice for a tool to store, manipulate and work with the operation information, SHPA chose EasyXLStm to augment the HTML based reports. Today SHPA staff can view reports on the screen as HTML and at the press of a button retrieve an MS Excel file with the data formatted exactly as on the screen, or in some cases with enhanced formatting (summary and detail sheets, a different sheet for each pilot, etc.)  With many of the reports being distributed to the top level association members, presentation and accuracy is of the utmost important.

PMOSystem - bridge man and machine

posted on 3/1/2006 12:47:00 AM

PMO System’s project management application makes extensive use of EasyXLStm to read and write MS Excel files for reporting and importing data.

PMOSystemtm provides carefully formatted reports to the user in the MS Excel file format.  Among the most complicated of the reports are the Timesheets for attaching to electronic invoices, and the multi-sheet budget reports that provide all project(s) information in one master MS Excel file.  Additionally, with only a few lines of code, all of the filtered lists support “Export-to-Excel” and “Export-to-CSV”.

In addition to reporting PMOSystemtm uses EasyXLStm to ease system setup and configuration.  Through the system import screens use EasyXLStm to create a customized data entry excel file complete with default data, drop list selections, field validation and protected cells.  The user reviews and completes the data in the file before uploading it back into the import screen which uses EasyXLStm to open and read the updated excel file into the system and database.  PMOSystemtm uses this method to allow imports of timesheet data, new resources, and even international translation table imports that are used to display the proper language in the user interface.

Among the most amazing uses of EasyXLStm in PMOSystemtm is the email based timesheet.  PMOSystemtm generates and emails a timesheet to selected resources each week.  The timesheet is tailored for each resource.  It includes the resource’s projects, roles, and planned hours by day.  The resource opens the excel file, enters in their hours, and sends the timesheet back to PMOSystemtm for updating.

EasyXLStm  has allowed PMOSystemtm to provide project data in useful formats as well as retrieve and import information from the users in a format both man and machine can work with.

IBM - Transport Lens

posted on 2/27/2006 1:23:00 PM

IBM’s TransportLens product makes use of EasyXLS to natively read and write Microsoft compatible XLS files.  During the process of completing shipping RFPs, TransportLens exports huge XLS files that are distributed to and updated by the individual competing Carriers.  Once the Carriers have completed updating all the requested pricing information in Microsoft Excel, they email the spreadsheets back and TransportLens uses EasyXLS to read the files, validate the contents and store the pricing in the application for consideration of awarding shipping allocation.

Automating the RFP process depended on the versatility and performance requirements required to prepare and process the XLS RFP files.  EasyXLS provided that versatility and performance, allowing detailed control over the XLS file formatting with such features as protected cells, lookup lists, field validations as well as the ability to handle generating and processing many large files simultaneously quickly with minimum performance impact on the production system.

TrackStar™ Electronic Invoice Reports

posted on 10/20/2005 2:58:00 AM

Cornerstone Relocation Group's TrackStar™ system provides their Relocation Counselors with the tools to quickly and effectively manage premium relocation services. Quickly, because their  transferees who are being relocated often call anxious and in a hurry on a cell phone in front of a real estate lawyer or coordinating their moving crew. Effectively because Cornerstone handles many of the fortune 500's most senior executive relocations. TrackStar™ has been the core of their enterprise initiative to help automate the workforce and their processes. Janelle Piatkowski, Cornerstone's President claims that, "There is not one conversation that I have about our company that does not in some way shape or form come back to TrackStar™. TrackStar™ is truly at the core of our business."

TrackStar™ is built with Active Server Pages (ASP), Microsoft SQL Server a large collection of Crystal Reports, fax generation software, a few XML B2B interfaces, and a tightly coupled interface with Solomon's accounting package.

When TrackStar™ needed to generate large electronic invoice reports (EIRs), they turned to EasyXLS™. They knew that they needed a tool that would allow them to quickly generate attractively formatted electronic invoices with a lot of data while putting as little additional burden on their servers as possible. They had previously learned that Crystal Reports™ claimed to output an MS Excel format, but those claims turned out to be greatly exaggerated and OLE Automation had a serious impact on the server performance, often locking up and requiring the server to be restarted.

Each day, Cornerstone's accounting staff generate EIRs not with long arduous manually intensive effort as they once did, but with a filter screen and by pressing a button labeled "Generate EIR". The generated MS Excel file is attached to an email along with an electronic invoice and sent to Cornerstone's clients.

American Express  VISA  Master Card  Discover
Easy to use by programmers in multiple languages
EasyXLS on Facebook EasyXLS on Twitter EasyXLS on Youtube EasyXLS on LinkedIn EasyXLS on PInterest EasyXLS on Reddit RSS News  | Terms of use | Privacy policy | Site map | Contact
© EU Outsourcing, Inc 2000-2022. All Rights Reserved.