SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Apr 2004
    Location
    Tokyo, Japan
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Best Excel Tools, Plug-ins, Methods for Analyzing Data

    Does anybody have any essential excel tools for analyzing test result data ???

    Of course we all use Excel to crunch our numbers but I have not seen anyone point out any cool tools or anything for excel. Are there any?


    -------------------------------------------------
    But now that I have your attention: I would like to know if any of you Visual Basic experts out there have any idea as how to create an Excel app that records the time and moves to the next row every time I hit the space bar???
    -------------------------------------------------

  2. #2
    Member
    Join Date
    Apr 2004
    Location
    Tokyo, Japan
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Best Excel Tools, Plug-ins, Methods for Analyzing Data

    Seeing as I am asking for a freebie I might as well share one. Below is a stopwatch tool that has served me well for finding the mean of times:

    -------------------------------------------------
    1. Open a new workbook
    2. Hit ALT+F11 to open the VBE
    3. Double-click on "ThisWorkbook" and insert this code in the edit panel:


    Private Sub Workbook_BeforeClose(Cancel As Boolean)

    Application.OnKey " ", ""

    End Sub


    Private Sub Workbook_Open()

    bStart = False

    Application.OnKey " ", "MyTimer"

    End Sub


    4. Insert a new module. (Insert|Module)
    5. Copy and paste this code into the new module:


    Private Declare Function timeGetTime Lib "winmm.dll" () As Long


    Public bStart As Boolean

    Public iStartTime As Long

    Public iEndTime As Long

    Public iTotalTime As Long


    Public Sub MyTimer()

    bStart = Not (bStart)

    If bStart Then

    iStartTime = timeGetTime

    Else

    iEndTime = timeGetTime

    iTotalTime = iEndTime - iStartTime



    With Sheets("Sheet1").Range("A65536").End(xlUp).Offset( 1, 0)

    .Value = iTotalTime

    .Offset(0, 1).Value = "milliseconds"

    End With

    End If

    End Sub


    6. Save and close your new workbook, then open it.

    7. Pressing the SPACEBAR will now start the timer, pressing it again will stop the timer and put the timed value on Sheet1, beginning in cell A2.

    8. Repeatedly hitting the SPACEBAR will put the next time in cell A3, A4...etc

    NOTE: All times are in Milliseconds.
    -------------------------------------------------
    Regards,

  3. #3
    Moderator JakeBrake's Avatar
    Join Date
    Dec 2000
    Location
    St. Louis - Year 2025
    Posts
    15,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Best Excel Tools, Plug-ins, Methods for Analyzing Data

    Originally posted by westsan:
    Does anybody have any essential excel tools for analyzing test result data ???

    <font size="2" face="Verdana, Arial, Helvetica">To what degree? Depending on the level of desired analyses, Excel may already have these built in. It would seem that this could be a "one-and-done" effort?? Create the sheet, the formulae, save, populate with data-to-be-analyzed, run, save session, repeat as necessary.


    Originally posted by westsan:
    ...

    Of course we all use Excel to crunch our numbers ...
    <font size="2" face="Verdana, Arial, Helvetica">No we don't!

  4. #4
    Member
    Join Date
    Apr 2004
    Location
    Tokyo, Japan
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Best Excel Tools, Plug-ins, Methods for Analyzing Data

    Originally posted by jpensyl:
    </font><blockquote><font size="1" face="Verdana, Arial, Helvetica">quote:</font><hr /><font size="2" face="Verdana, Arial, Helvetica">Originally posted by westsan:
    ...

    Of course we all use Excel to crunch our numbers ...
    <font size="2" face="Verdana, Arial, Helvetica">No we don't! </font><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">What may I ask do you use? Crystal Reports or something?

 

 

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 Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 12.00%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 11:43 PM.

Copyright BetaSoft Inc.