+ Reply to Thread
Results 1 to 9 of 9

Software Validation for Excel spreadsheets.

  1. #1
    Registered User
    Join Date
    05-27-2016
    Location
    USA
    MS-Off Ver
    MO 2013
    Posts
    5

    Software Validation for Excel spreadsheets.

    Hello,
    I'm new in the forum, I need to apply software validation to verify and validate my excel spreadsheets. Does anyone has an idea of how to do that?

    Thank you.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Software Validation for Excel spreadsheets.

    Hi and welcome to the forum

    Can you explain with some examples what data you have and what rules do you want to apply in order to verify it.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-27-2016
    Location
    USA
    MS-Off Ver
    MO 2013
    Posts
    5

    Re: Software Validation for Excel spreadsheets.

    I work in a quality department, we use excel spreadsheets to make fail and pass decisions towards our product in final inspection. The spreadsheets we use contain different formulas, and measurements as well. An auditor came and told us that we must verify and validate our excel spreadsheets. I have no idea how to verify and validate an excel file, what I've learned so far
    thanks to the research I've done, is that the verification and validation process consist on verifying the formulas used on the spreadsheets are correct, and that our results are in compliance with our formulas.

    Thanks

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Software Validation for Excel spreadsheets.

    Hi,

    Why not ask the auditor what S/HE means by verify and validate and what evidence s/he needs to see that will persuade them that you have verified and validated your data.

    Perhaps one way would be to take your data, get your pencil and calculator out and manually work out what the results should be. Then compare thse with the results Excel is giving you.

  5. #5
    Registered User
    Join Date
    05-27-2016
    Location
    USA
    MS-Off Ver
    MO 2013
    Posts
    5

    Re: Software Validation for Excel spreadsheets.

    Hi,
    I will ask him when he comes back. Talking about the pencil and calculator, can I make a new excel spreadsheet to check my other spreadsheets? Is that a thing? Is that possible?

    Thank you so much for your time.

  6. #6
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Software Validation for Excel spreadsheets.

    Hi,

    There would be little point in using another workbook with calculations that use exactly the same formulae since it would come up with the same answers and wouldn't be proving anything.

    If there are different formulae and different ways ways of arriving at the results using Excel then that might be an option, but in the end I suspect a piece of paper with a series of calculations starting off with simple statements and with each succeeding calculation building on the previous calculations leading to the answer would be the best way.

    What are the calculations just as a matter of interest?

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,789

    Re: Software Validation for Excel spreadsheets.

    I've been intrigued to understand what it is that an auditor is actually looking for to satisfy himself that worksheets are validated and verified. So I googled the phrase 'validating excel spreadsheets'

    Among several web sites that I came across was ..this one.

    I think this is an excellent starting point and if you follow the bullet points and pay attention to what they describe and then write a 'Verification / Validation Process' document that picks up all these points and builds in your particular formulae and rules, I's be surprised if your auditor could find fault.

  8. #8
    Registered User
    Join Date
    05-27-2016
    Location
    USA
    MS-Off Ver
    MO 2013
    Posts
    5

    Re: Software Validation for Excel spreadsheets.

    Hello Richard,
    I appreciate all your help and your time, I followed the link you sent and was pretty useful. I really had a hard time trying to figure out what the auditor really wanted me to do.
    When you google validate excel spreadsheets, the info given is not quite clear. But I finally got an example of what I needed. Here's the link so you can check it.

    Best Regards,
    Andres
    Last edited by andres_lanza; 05-31-2016 at 11:44 AM.

  9. #9
    Registered User
    Join Date
    05-27-2016
    Location
    USA
    MS-Off Ver
    MO 2013
    Posts
    5

    Re: Software Validation for Excel spreadsheets.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can you do a data validation between two spreadsheets?
    By Jtwanabe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2016, 07:50 PM
  2. Software to Display Multiple spreadsheets in rotation
    By thesonofdarwin in forum Excel General
    Replies: 1
    Last Post: 03-22-2014, 06:11 AM
  3. Single validation source for multiple spreadsheets
    By Sabur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2010, 11:18 PM
  4. What's the best RS-232 software for Excel?
    By jrdnoland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2009, 09:08 PM
  5. Can Excel Spreadsheets be saved as Microsoft Works spreadsheets?
    By EXCEL WORKS CONFUSED in forum Excel General
    Replies: 4
    Last Post: 08-18-2006, 06:25 PM
  6. How do I combine data from various Excel spreadsheets into one Excel spreadsheets
    By SouthAfricanStan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2006, 01:10 PM
  7. [SOLVED] How can I get the excel software only?
    By Marta in forum Excel General
    Replies: 1
    Last Post: 07-04-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1