b POPUP STOPWATCH for Microsoft Excel

Download   Home  Ads        

What's new

This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that generates a popup stopwatch in Microsoft Excel®. See the pictures below.

It has only one file, the ExcelStopwatch.dll, of about 396 kb that can be installed automatically. Except for the dll, no another setting is save in the Microsoft Windows® Register and yes in ExcelStopwatch.ini, ExcelStopwatchHotKey.xla, and ExcelStopwatch.xlam files that are created and maintained by the proper utility. The uninstallation also can be made automatic and completely not leaving any dirt in your Windows Register or disc.

Features:

- Stopwatch

- Countdown (Timer)

- When the countdown expires, it can beep, play a WAV file, run a Windows program and/or alert the expiration

- Can speak (pronounce) in robot voice, announcing second by second the last n seconds of a countdown

- When the countdown expires, it can yet: (1) immediately restarts the same countdown in infinite loop, or (2) simultaneously presses Reset and Start button of the stopwatch to start counting from zero, or (3) simultaneously presses the Start or Restart button to start or restart counting from the current time on the display. These last two options make possible that, when a countdown expires, one or several instances with attached buttons simultaneously start or restart their counts. For example, in a contest with starting shot, you open an instance for each competitor with Start buttons attached, and, in the one of the instances, you set a countdown to generate the starting shot and automatically starts its stopwatch and the stopwatches of all others competitors at the same instant (New in version 3.0 of 11/11/12)

- Allows multiple instances within a single instance of Excel with independent controls, settings, counting, and results. In practice quantities, there is no limit to the number of simultaneous instances, and there is no degradation in the count accuracy or display update

- Start, Stop, Restart, Stop-Insert, and Reset controls of same category in all instances or in only some of them running independently can be attached to be triggered simultaneously with a single click

- Controls of same category attached according to the previous item are distinguished by * in their captions

- Start or Restart controls in all instances or in only some of them running independently can be attached to Stop controls of different categorie to be triggered simultaneously with a single click. Makes it possible that, when starting or restarting an instance, stop all other ones with buttons thus attached (New in version 3.0 of 11/11/12)

- Controls of different categories attached according to the previous item are distinguished by º in their captions (New in version 3.0 of 11/11/12)

- No matter how many instances are opened, the events on all attached buttons happen at the same instant of the click, without more or less milliseconds between instances. You can verify this by turning on the print on the paper ribbon or on a split in sheet (Improved in version 3.0 of 11/11/12)

- The feature of multiple instances can be disabled

- Split time reports (Snapshots) directly in Excel sheets, one new sheet for each popup in the same workbook created during each execution or when saved and closed one

- If, when pressing Split button and Excel cell cursor is over an old split report, you will be prompted to resume it. Or, if the active cell is blank and there is a sufficient blank cell range in front (> 25x8) for a report, you will also be prompted to start a new report right there, from the active cell. If there are no reasons for prompts or if you deny them, follows that described in the previous item, immediately creating a new default sheet for the split time report (New in version 3.0 of 11/11/12)

- Reports of split time with labels (Label Snapshots), allowing set up of as many as 10 snapshot controls in the interface with different labels, background and front colors, and sounds. Labels and colors set up in an interface control are also duly registered in the split sheet cells

- Five display modes

- Display background and front colors can be changed by the user

- The display can be adjusted to any size through an interface control or through the borders

- The control panel can be adjusted to any size through an interface control

- All settings of an instance can be saved in a file on the disc and named by the user to be opened in another parallel or future instance

- The last opened setting or the last closed instance setting will be used as default in the next new instance

- Decimals used for the precision of a millionth of a second

- Can capture and insert into the active cell

- Can capture either positive or negative time in cells. The positives are prepared to be increased by the stopwatch enabling the Restart button and the negatives are prepared for the countdown

- Positive time in cells can be numeric or formatted text, numeric according to Excel definitions to represent dates and times by decimal numbers, or formatted text inserted normally into cells with text format or preceded by a quotation mark in cells without text format. Examples: 5:10.25 or '5:10.25 (Five minutes, ten seconds and twenty-five hundredths of a second), 10 or '10 (Ten seconds)

- Negative time in cells can only be in the formatted text, because Excel does not represent a negative time through a negative decimal number. Therefore, negative time should always be inserted as formatted text between brackets or preceded by a quotation mark and a negative sign. Examples: (5:10.25) or '-5:10.25 (Five minutes, ten seconds and twenty-five hundredths of a second) , (10) or '-10 (Ten seconds). Download and see more examples in the Roast Chicken Recipe Sheet

- The behavior of popup can be set via menu to: Reset the display (Not capture the active cell), Start the stopwatch, Split time in active worksheet or in the background, and Popup in the last saved position

- The behavior of the Stop-Insert button can be set via menu to: (1) Stop, Insert and Close the stopwatch, (2) Stop and Insert, (3) Insert only, or (4) Disable. Options 1 and 2 makes it possible that a single click generates more than one event at the same instant, without more or less milliseconds (Improved in version 3.0 of 11/11/12)

- The Stop-Insert button can also be set to insert the result into the current active cell or into the active cell when started. In this last case, the stopwatch instance is attached to the cell where it originated and the cell address appears in the stopwatch title

- The behavior of the Reset button can be set via menu to: (1) Reset only, (2) Reset and Start, (3) Insert, Reset, and Start, or (4) Disable. Options 2 and 3 makes it possible that a single click generates more than one event at the same instant, without more or less milliseconds (New in version 3.0 of 11/11/12)

- Pops up in small size

- Pops up close to the mouse cursor or optionally at the last saved position

- Can auto-popup when selecting cells with time formats or cells specifically defined to auto-popup

- Auto-popups can happen simultaneously in different cells, although no more than one in each cell

- An instance created in a cell auto-popup is tied to the same cell as the standard

- Can be set up with independent sound from WAV files for each of the following controls: Start, Stop, Restart, Stop-Insert, Snapshot, and Reset, including yet one for each of the 10 Label Snapshots

- All sounds, including the digital paper ribbon one, may be temporarily disabled

- Can print time and setting on a digital paper ribbon in each event

- Can capture back to the display times and settings registered on digital paper ribbon

- Can send some or all lines on the digital paper ribbon to the printer

- Can copy the time on display to Windows Clipboard

- Can paste on display existent the time on Windows Clipboard

- Can be called by the mouse right button (Context menu), or by a button in the Excel Standard toolbar (2007, 2010, or 2013 Ribbon Add-ins tab), or by a keyboard shortcut key set by the proper user (hotkey) (Improved in version 3.0 of 11/11/12)

- Accepts the following hotkeys that make it possible to count time only using the keyboard:

- Popup Stopwatch: Any hotkey defined by user
- Start/Stop/Restart button: Enter or Space
- Stop/Insert button: I
- Reset button: R or Backspace
- Paste from Windows Clipboard: Ctrl + V or V
- Copy to Windows Clipboard: Ctrl + C or C
- Select cell on the Excel: All Excel standard navigate keys. This make possible you select any cell on the Excel to insert a count (Snapshot) on the flight, select directly from the stopwatch without activating the Excel window
(New in version 3.0 of 11/11/12)

- The skin can be set up in: color and background picture, display and controls transparency, hiding title bar, and action of a button when clicking on display

- Can unanchored its window from Excel window, making it possible that it is visible even if Excel window is minimized (New in version 3.0 of 11/11/12)

- Can make its window is always on top in Windows (New in version 3.0 of 11/11/12)

- Can autohide the control panel leaving visible only the count display. When approaching the mouse pointer, a tiny control appears to, if you click, unhide the panel that will be autohidden again when mouse go away (New in version 3.0 of 11/11/12)

- Can anchor in the cell that was active in Excel when it started and so always follows the cell displacement on the screen, upper-left corner with upper-left corner, inclusive disappearing and reappearing if the cell disappear and reappear on screen (New in version 3.0 of 11/11/12)

- Can position itself in-cell where it is anchored adjusting its width and/or its height to cell when the title and control panel are hidden (New in version 3.0 of 11/11/12)

- The Default button in skin settings form allows you to view or restore all skin default settings (New in version 3.0 of 11/11/12)

- All instances running can be closed with a single click by selecting the Close All command in the menu

- Occupies less than 420 Kb when installed

- Can be called too directly from any VBA code thru the fStopwatch() function. See, soon below the pictures for a detailed description of this function and examples of VBA application that use it.

Download:

Tested in Excel 2000, 2002(XP), 2003, 2007, 2010 (32-bit), 2013 (32-bit), and 2016 (32-bit) in MSI-based and Click-To-Run installations of Office 365™ cloud-based services.

 
Download

Download the English version here   
You also can download from this mirror site   
Last update: 02/03/2016 - 717.9kb    
Freeware based in this License Agreement   

Note: The above link downloads the installer and uninstaller package programmed in VBA in a XLS duly converted to EXE by the XLtoEXE to make fully easy the installation by macro and Windows laymen, but, if you're expert and due some reason prefer an installer and uninstaller package in open ZIP, clique here. With this zip package you can install of three ways: (1) Simply act the Install.exe that loads the same XLS in Excel without macro alert; (2) Extract the all package to a folder and act the XLS enabling the macros in Excel and using 123 as password, or (3) Install the DLL manually.

Pictures:

Picture

fStopwatch() Function:

The stopwatch can be called too directly from any VBA code thru the fStopwatch() function that has these 22 optional arguments:

1 - InitialElapsed (Date/Time, Default=0)

2 - ResetAtPupUp (Boolean, Default=True)

3 - StartAtPupUp (String, Default=””) If at any position in the string there is:
     "1" - Start the stopwatch or countdown at the popup
     "2" - Attach the Start button to others instances ones with the same setting
     "3" - Idem for the Stop button
     "4" - Idem for the Restart button
     "5" - Idem for the Stop-Insert button
     "6" - Idem for the Reset button
     "7" - Attach the Start button to the Stop buttons of others instances
(New in version 3.0 of 11/11/12)
     "8" - Attach the Restart button to the Stop buttons of others instances
(New in version 3.0 of 11/11/12)

4 - DisplaySize (Long 20 to 500, Default=0 to use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile)

5 - DisplayMode (Long 0 to 4, Default=0 to use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile.)

6 - DecimalPlaces (Long 0 to 3, Default=-1 to use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile.)

7 - CountDown (Boolean, Default=False)

8 - PaperRibbon (Boolean, Default=False)

9 - Split (Boolean, Default=False. If True, start splitting time in a sheet)

10 - SplitSheet (String, Default="" to create a new time split sheet)

11 - SplitWorkbook (String, Default="" to use the active or to create a new, if SplitSheet="")

12 - SplitStartCellRef (String, Default="A1")

13 - ActivateSplitSheet (Boolean, Default=True)

14 - LeftPos (String, Default="0")

15 - TopPos (String, Default="0"). Where LeftPos and TopPos are the distances in points (1/72 inches) from the center of the Start button to the current mouse position. If the values are preceded by $ (dollar sign), LeftPos and TopPos turn to be the distances from left top corner of the stopwatch to the left top fix corner of the screen. And yet, if there is only the $ without number, will be used the current default position or one saved in the file specified by the argument 21, SavedSettingFile

16 - ShareSplitSheet (Boolean, Default=False to not allow that the split sheet is used simultaneously by other instance)

17 - WaitAndRetValue (Long 0 to 2, Default=0). Where:
     0 - Not return value, not asynchronous, and modeless
     1 - Return value, asynchronous, and modeless
     2 - Return value, asynchronous, and modal

18 - CtrlPanelSize (Long 3 to 50, Default=0 to use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile)

19 - StopInsMode (Long 0 to 4, Default=0). Define the setting to Stop-Insert button, as:
     0 - Use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile;
     1 - Stop, Insert, and Close the stopwatch
     2 - Stop and Insert
     3 - Only Insert
     4 - Disable

20 - SnapshotNumb (Long 0 to 10, Default=0. Define the number of Label Snapshot controls to show. If informed negative (-1) or more than 10, will be used the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile)

21 - SavedSettingFile (String, Default= "" to use the current default setting¹. Due to the quantity and difficult to set some features like colors, fonts, sounds, skin options etc., would not be practical to use arguments to attend all the possible features. The most practical is to open the stopwatch, set any all desired option, and use the 'Save Setting As ...’ command on the menu to save the setting to a file. After inform the file name and its full path thru this argument)

22 - ResetMode (Long 0 to 4, Default=0). Define the setting to Reset button, as: (New in version 3.0 of 11/11/12)
     0 - Use the current default setting¹ or one saved in the file specified by the argument 21, SavedSettingFile;
     1 - Only Reset
     2 - Reset and Start
     3 - Insert, Reset, and Start
     4 - Disable

¹Understand "current default setting" how the last setting set and saved by an instance generated by the Excel interface user because an instance generated by this function does not change the current default setting despite allowing changes normally via interface at runtime. (New in version 3.0 of 11/11/12)

Examples:

1 - The code below calls the ExcelStopwatch with all default arguments, if its current version is duly installed.

Sub YourSub1()
     Dim fRet
     Dim ObjToVBA As Object ‘See Note below
     Set ObjToVBA = Application.COMAddIns("AddInXlStopwatch.ExcelDesigner").Object
     fRet = ObjToVBA.fStopwatch

End Sub

 

2 - The code below calls the ExcelStopwatch with all default arguments, except the 3 (To start at popup and attach Start buttons), the 9 (To start splitting), the 10 (To split on the Sheet3 of the active workbook), and the 12 (To start splitting on cell G10).

Sub YourSub2()
     Dim fRet
     Dim ObjToVBA As Object ‘See Note below
     Set ObjToVBA = Application.COMAddIns("AddInXlStopwatch.ExcelDesigner").Object
     fRet = ObjToVBA.fStopwatch(0, , “12”, , , , , , True, ""Plan3"", , ""G10"")
End Sub

Note: Replace 'As Object' by 'As StopwatchObjToVBA', if you prefer Early Binding method, but you have to use Tools/References... menu and add "Excel Stopwatch © 2003-08 by Francisco Orlando Magalhães Filho" reference. This method makes easy to view the names and positions of function arguments.

 

The fStopwatch() function can give the following returns:
     fRet = False (Cancelled by the user)
     fRet = Elapsed time in the Excel date and time system (Stop-Insert button pressed and using value 2 or 1 on WaitAndRetValue argument)
     fRet = ""Error 1"" (Failure: Sheet to split not found)
     fRet = ""Error 2"" (Failure: Split start cell reference invalid)
     fRet = ""Error 3"" (Failure: An active split started in the same cell already exists, if the value of the ShareSplitSheet argument is False)
     fRet = "" Error 4 "" (Failure: When opening the setting file indicated by SavedSettingFile argument)

 

Finally, to see practical examples that you can improve upon or adapt to other uses, download and see two Stopwatch Sheet Templates for Motocross Race with VBA codes calling the fStopwatch() function.

The first template, an improvement of the example used with the previous version, now using the multiple instances feature of the current version, it uses an instance of a stopwatch and a sheet of division for each pilot. Click here to download the English version.

The second template uses the label snapshots feature of the new version, in which each instance can measure up to ten pilots differentiated by colors, fonts, and sounds. Moreover, as it is more compact, only one stopwatch instance for each tem pilots, the measuring is easier and more precise, and uses a single split sheet that facilitates the report generation. Click here to download the English version. Tips on how to use this second version:
     - Download and install the Stopwatch thru download link above on this page
     - Open the template in Excel
     - Specify the number of pilots and push the Start button
     - In the stopwatch instance opened, insert the pilot name in each Label Snapshot and, if desired, set color and sound for each one
     - After setting all the desired settings of the dozens available, use 'Save Setting As...' command on the menu, so in the next execution, to restore all settings, including pilot names, simply use the command 'Open Setting...'.

 

About Add-in (.xla):

Temporarily unavailable.

 

More information

Home

 





gplus

 

 

Visitas acumuladas em todas as páginas:
Visitas hoje só nesta página: