Supplier communication: eXpresso SaaS simplifies Excel collaboration in Covisint automotive community

Automotive portal provider Covisint is making its data more accessible by automating certain information-sharing processes using eXpresso’s SaaS-based communication platform.


When it comes to document collaboration between manufacturers and their Tier 1 suppliers, plenty of technology options can keep everyone tied together closely and securely. But when communicating with Tier 2-level suppliers and below, things get a little dicey.

For one thing, technologies don’t often mesh.

"At this level, people start using [ Microsoft ] Excel spreadsheets for manufacturing information, inventory information, and so on," notes George Langan, CEO of Web-based computing specialist eXpresso Corp . "When you have a very large middle management crew, you can control and manage all of this through brute force."

But, as Langan points out, when such manpower is not available, challenges result.

Recently, though, many of these issues have been addressed as a result of an agreement between eXpresso and Compuware Corp., extending Compuware's Covisint collaboration platform and ecosystem to include eXpresso's subscription-based service—enabling real-time collaboration using Excel.

Joe Barkai, a practice director with IDC Manufacturing Insights , cites the familiarity of Microsoft Excel as a plus that can allow Covisint to expand the reach of its automotive supplier portal.

Covisint, launched about 10 years ago, is the world's largest on-demand centralized collaboration platform, serving about 45,000 customers in a number of industries—including a communication portal that connects about 350,000 members of the automotive industry.

eXpresso is helping Covisint make its data more accessible by automating certain information-sharing processes. Users will be able to subscribe to the eXpresso service through Covisint and establish relationships with colleagues and vendors to share and collaborate on office documents.

Inviting process

eXpresso says its Software-as-a-Service (SaaS)-based application establishes instant file control and distribution across Web-based computing platforms. eXpresso business communities, which focus on live document collaboration with Microsoft Office applications, use a patented invitation process and are governed by a system of rights and privileges. eXpresso can automatically pull data from Microsoft Excel spreadsheets and store all of the elements in a database consisting of enterprise data. Options for PowerPoint and Word recently were added.

"One of the difficulties facing auto manufacturing—and manufacturing in general—is multiple tiers of suppliers," notes Langan, reiterating that the top two tiers are tied together with very sophisticated technology. But below that, Excel is the tool of choice. “Only when there are large numbers of people available can this interaction be managed,” says Langan. “But with all of the industry layoffs, these people are disappearing. And you still have to get the work done.

"We provide a very different approach to handling these documents," Langan continues, pointing out that eXpresso takes all of the elements of a document—the values in every cell, the formulas, the macros, and any graphics—and saves them in a relational database.

Langan says eXpresso lets a Tier 1 supplier have one master spreadsheet that it can share with multiple suppliers, and those suppliers can perform updates to the spreadsheet. With eXpresso technology, the Tier 1 supplier can share the same spreadsheet with 10 suppliers, with each supplier seeing only what is important to them. The suppliers can make updates to their portions of the document, overseen by a person at the Tier 1 supplier who can manage everything.

Changes are documented in real time and eXpresso generates an audit train detailing changes down to the cell level.

eXpresso also has a concept called "alerts and notifications." When the Tier 1 supplier makes the changes it needs, all of the suppliers can be notified via alerts that they must make changes to their bids. When parts are up for recertification, the eXpresso system automatically sends alerts to all the people who need to know.

The continuity benefit

According to Joe Barkai, a practice director for Framingham, Mass.-based IDC Manufacturing Insights , Covisint could benefit from a more comprehensive method to expand its reach beyond the portal.

"If eXpresso provides this, allowing collaboration to extend outside the portal, then this is probably not a bad idea, because Excel is a very familiar interface," he says. But according to Barkai, beyond the IT-related document exchange is the challenge of cementing the information.

"Is there consistency in the way suppliers and OEMs use part numbers?" asks Barkai. "Generally, no. This lack of consistency is the larger challenge. So the question goes beyond,‘Do I have the right workflow with the portal?’ to ‘Do my information structure and governance support collaboration?’ Only when this takes place can suppliers leverage the capabilities that a provider like eXpresso offers," Barkai concludes.

The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
Doubling down on digital manufacturing; Data driving predictive maintenance; Electric motors and generators; Rewarding operational improvement
2017 Lubrication Guide; Software tools; Microgrids and energy strategies; Use robots effectively
Prescriptive maintenance; Hannover Messe 2017 recap; Reduce welding errors
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Mobility as the means to offshore innovation; Preventing another Deepwater Horizon; ROVs as subsea robots; SCADA and the radio spectrum
Research team developing Tesla coil designs; Implementing wireless process sensing
Commissioning electrical systems; Designing emergency and standby generator systems; Paralleling switchgear generator systems
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
Featured articles highlight technologies that enable the Industrial Internet of Things, IIoT-related products and strategies to get data more easily to the user.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me