Compute 2.1
Hotkey: Any (recommended FN+e)
Compute is based on original macro from Pascal Nicolas. In this version you can repeatedly edit your formula, use result of previous calculation (Ans), use built-in stopwatch function for your calculations and finally use customisable separator for pasted results.
By invoking this macro, you'll see wide input dialog where you can insert your formula for calculation.
Press ENTER and you'll see result of your calculation:
Now you can press:
- Enter, result will be pasted into your application and input dialog will appear again with the same formula. It enables you to repeat calculation.
- Space, you'll be able to modify your formula and try calculation again. Nothing will be pasted into your application.
- Delete, input dialog with result will appear. Nothing will be pasted into your application.
Optionally, you can change the way how results will be separated one from another. This could be useful for further use in spreadsheet application. Here are available options:
- None, no separator, just result.
- Enter, enter follows the result.
- Tab, tabulator follows the result.
- Down, down arrow key (specially for sheet application) follows the result.
- Custom, any character which you'd specify.
Stopwatch
Use in your formula new function SEC: Returned value of this function is time in seconds. Stopwatch is terminated by pressing Enter.
I found very useful to use this macro for recording of multiple stopwatch measurements into sheet application. Here is small guide how to do it:
- Set up sheet table as you wish. I used in this example recording of measurements into columns.
- Invoke Compute macro and type formula with sec: function. I used sec:/60 to get result in minutes
- By pressing ENTER, macro starts stopwatch function. You'll see small window in centre of the screen with elapsed time. You can stop it by pressing ENTER.
- After pressing ENTER, select separator option to DOWN and press ENTER
- Result will be pasted into your sheet and cursor is moved down to next cell. Input dialog appears again and you can repeat the whole procedure.
- If you want to record results into rows, simply set Separator to Tab.
Contact:
Any bugs, recommendations, feedback send to osg at atlas dot cz