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.

03/30/2009



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.





No comments
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
The true cost of lubrication: Three keys to consider when evaluating oils; Plant Engineering Lubrication Guide; 11 ways to protect bearing assets; Is lubrication part of your KPIs?
Contract maintenance: 5 ways to keep things humming while keeping an eye on costs; Pneumatic systems; Energy monitoring; The sixth 'S' is safety
Transport your data: Supply chain information critical to operational excellence; High-voltage faults; Portable cooling; Safety automation isn't automatic
Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Plant Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.

Maintaining low data center PUE; Using eco mode in UPS systems; Commissioning electrical and power systems; Exploring dc power distribution alternatives
Synchronizing industrial Ethernet networks; Selecting protocol conversion gateways; Integrating HMIs with PLCs and PACs
Why manufacturers need to see energy in a different light: Current approaches to energy management yield quick savings, but leave plant managers searching for ways of improving on those early gains.

Annual Salary Survey

Participate in the 2013 Salary Survey

In a year when manufacturing continued to lead the economic rebound, it makes sense that plant manager bonuses rebounded. Plant Engineering’s annual Salary Survey shows both wages and bonuses rose in 2012 after a retreat the year before.

Average salary across all job titles for plant floor management rose 3.5% to $95,446, and bonus compensation jumped to $15,162, a 4.2% increase from the 2010 level and double the 2011 total, which showed a sharp drop in bonus.

2012 Salary Survey Analysis

2012 Salary Survey Results

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.