Why managing RFPs with Excel is a disaster waiting to happen

Issuing a request for proposal (RFP) requires collaboration between internal departments and
external organizations — and managing all of the information that passes between people can
get complicated.

Many organizations turn to Excel to help track and manage this process … but too often that
brings more problems than solutions.

“We were sending out RFPs in Excel documents,” explained Mark Rieder, SVP of HR
Technologies and Benefits Administration at NFP. “The whole process was so piecemeal it
made it very difficult to bring the results together in an easy-to-compare way.”

And Mark’s experience isn’t unique.


 

Below, we explain four of the biggest dangers of relying on Excel for this crucial business
process.

1. Human error

Using Excel comes with a high risk of human error. In fact, Forbes once wrote an article
suggesting Microsoft’s Excel Might Be The Most Dangerous Software On The Planet.

In the article, Forbes explains how an erroneously entered equation in Excel cost investment
bank JP Morgan several billion dollars.

“JP Morgan was running huge bets (tens of billions of dollars, what we might think of as golly
gee gosh that's a lot of money) in London. The way they were checking what they were doing
was playing around in Excel. And not even in the Masters of the Universe style that we might
hope, all integrated, automated and self-checking, but by cutting and pasting from one
spreadsheet to another. And yes, they got one of the equations wrong as a result of which
the bank lost several billion dollars (perhaps we might drop the gee here but it's still golly gosh
that's a lot of money).” 

2. Lack of accountability

Making matters worse, when employees do make mistakes using Excel, it’s almost impossible
to find out who exactly made the mistake.

An article detailing how an Excel error cost Tibco and Goldman $100 million — and led to a
lawsuit — highlights this issue.

“Upon further examination, Tibco and Goldman discovered a key document – a spreadsheet
– had overstated the number of fully diluted shares. This dreadful situation meant that the
implied equity consideration was $4.14 billion instead of $4.24 billion. Moreover, this
spreadsheet error led to a miscalculation of Tibco’s equity value, a $100 million savings for Vista, and a slightly lower payment to Tibco’s shareholders. The mystery regarding who created the $100 million spreadsheet error has yet to be solved.” 

3. Poor information security

The most common way teams collaborate using Excel is to email the spreadsheets back and
forth. Unfortunately, this practice can lead to private information landing in the wrong hands.

The same article that details how Excel landed Tibco and Goldman in hot water explains how
emailing Excel spreadsheets led to disaster for Schwab Retirement Plan Services (SRPS).

“A spreadsheet containing personal information belonging to participants in a company-
sponsored retirement plan serviced by SRPS was accidentally emailed through a secure channel
to a participant in another retirement plan serviced by SRPS. Included in the spreadsheet were
the names, addresses, dates of birth, Social Security numbers, dates of termination (when
applicable), employment statuses, division codes, marital statuses, and account balances for
each of the 9,400 participants.” 

With privacy concerns at the top of everyone’s mind, this isn’t an issue your organization can
afford to ignore.

4. Wasted time

Every hour your employees spend working in Excel is an hour they can’t spend working on
something that’s of real value to your company … and managing RFPs in Excel is often very
time-consuming.

At ihouse, the RFP team used to spend hours poring through Excel spreadsheets just to ensure
the information was accurate.

“When using an Excel template, we would have to go through each category to ensure there
were no errors from all the copy and pasting,” said Ronni Beckwith, Principal, HR Technology
Consulting Practice Leader at the consulting firm. “The Excel formulas would often break in the
process. It took a lot of time to reconcile.”

At NFP, Mark and his team spent hours copying and pasting information vendors submitted into
the appropriate Excel file.

“Their answers would be so long they couldn’t fit [in Excel], so they’d end up submitting proposals in Word documents,” Mark said. “Combining everything into Excel was incredibly time-consuming,”


 

What you can do about it

RFP365 is an automated, end-to-end RFP management solution that can remove these
concerns.

According to Ronnie at ihouse, who previously used Excel to manage RFPs, “RFP365 is much
faster” and “the new electronic process ensures full transparency. If there’s ever a question
about how we came to a decision about a selection, we have a full record of the event.”

Eric Hollenbach, Project Analyst at Lockton touted the increased accuracy of information.

“I have more confidence in our information now,” he said. “Not having to manually compute
Excel matrices not only saves a lot of time, but it also means more data integrity.”

Learn how switching from Excel to RFP365 made issuing RFPs easier for NFP, ihouse, and Lockton.