iSixSigma

Calculating sigma in access

Six Sigma – iSixSigma Forums Old Forums General Calculating sigma in access

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #31071

    Dillon
    Participant

    I am trying to use the Access Macro Transfer spreadsheet to sequentially export a query to Excel, have Excel calculate sigma, then use Transfer spreadsheet to import the same excel file into a table.   From the table I will then create a report indicating sigma level.  However, what is happening is the Excel file afer being imported to is not being saved and I am only importing the values i exported, the sigma value is not exporting back to access.  However, if I manually open the Excel file, save it, and then run the import macro, the equation value returns just fine.  Can anybody help with this?Thank you very much,doug

    0
    #81670

    Logan Luo
    Participant

    It sounds like that after you exported the file to Excel, the exported file overwrote the old Excel file which has the Sigma formula. 
    The other possibility is that after you exported data to Excel (without opening it), the Sigma field in your Excel file would still “remember” the old data. If you import the data without opening the file, you will be end up importing the “old data”. You have to open the Excel file to refresh the “memory” of the Excel file.
    You don’t have to export the data to Excel to have Sigma Level. Use following formula you can have the Sigma Level in Access. I have already done that.
    Process Sigma = 0.8406 + SQRT(29.37 – 2.221 * (ln(DPMO)))

    0
    #81671

    Dillon
    Participant

    Logan:
    Thank you very much for your reply.  I did as you instructed and it works perfect!  I sincerely appreciate your assistance.  Merry Christmas! 
    doug  
     
     

    0
Viewing 3 posts - 1 through 3 (of 3 total)

The forum ‘General’ is closed to new topics and replies.