Archive for the ‘Power User’ Category
Posted by jpluimers on 2015/09/04
OSX: Log shell script events to the OS X system consolemacissues.com (If you are familiar with the Unix command line)
Posted by jpluimers on 2015/08/31
Posted by jpluimers on 2015/08/28
This is not intuitive: you have to right-click the textbox in order to edit it.
Printing in Office 2003 also was non-intuitive: Ctrl-P would crash the Microsoft Office Document Imaging MDI editor with a Microsoft Crash Report. But mouse-clicking the print-icon works. I remember having sending dozens of these reports to Microsoft around 10 years ago, but it never got fixed.
Posted by jpluimers on 2015/08/28
A while ago, I needed to do calculations on partially absolute cell references: for some number of rows, the cells needed to be fixed to the top row of each row group.
For a pure absolute cell reference, you’d prepend a dollar sign to the row or column of a cell. So A1 would become $A1 (to make column A absolute), A$1 (to make row 1 absolute) or $A$1 (to make both column A and row 1 absolute).
There is a nice short cut function key F4 to do this.
Excel does not have a built-in partially absolute cell reference solution.
For all these functions, the ROW and COLUMN numbering starts at 1 (one) not 0 (zero).
The way I solved it was to added the below columns (first the reference:heading, then the formula).
The values in the formulas are for ROW 2 (cells A2..XFD2).
- AF: Calculation
- AG: ZLookup
- AH: Row
Calculates the fixed row of the row group. There are 12 rows per group. ROW numbers start at 1, and there is one heading row, hence the 2+ and the -2.
Without TRUNC, the ROW result would be rounded (that is the default floating point to integer conversion that Excel uses).
There is no need to reference a specific row when calling ROW: if you leave it out, it will return the number of the current row.
returns the address of the calculated ROW (from AH) combined with the
Depending on the value of the D column, it calculates the outcome by combining
- Excel: get content of a cell given the row and column numbers – Stack Overflow.
- ADDRESS function – Excel.
- INDIRECT function – Excel.
- COLUMN function – Excel.
- ROW function – Excel.
- TRUNC function – Excel.
- Use an absolute cell reference – Get to know Excel: Enter formulas.
- Excel functions alphabetical list.
Posted by jpluimers on 2015/08/25
Really really cool!
Vysor (by Koushik Dutta aka Koush) lets you not only share and control your Android device screen from your local Chrome browser, but also remotely to others having a Chrome browser with Vysor installed. And Vysor gives you full ADB access to your Android device.
Some links to get started:
- Chrome app (works on ChromeOS too): Vysor (Beta) – Chrome Web Store.
- Web site: Vysor.
- Videos at the bottom of this post.
- G+ announcement: Vysor Share Remote screen and ADB access….
- Reddit thread: Koush releases Vysor (beta) app for controlling Android phones from a computer : Android.
- Vysor Is The Newest (Early Beta) Android Project From Koush, Allows You To Control Your Phone From Chrome.
- Vysor is an interesting new way to control Android from your computer | Android Central.
To get started:
- Enable ADB on your Android phone.
- Connect your Android phone over USB to your computer.
- Start Vysor.
After connecting over ADB, Vysor sideloads the Android code to share both screen and input. So besides viewing your screen, you can then control it.
Of course your mouse works, including scrolling. And the keyboard for entering text.
There are also some special keys:
- Esc: Back button;
- F1: Menu button;
- Home: Home button.