Have you ever had a need to filter some tables of data in Excel using masks? If so, this post may be useful to you. The principle is simple: place your data in one sheet (Data), create a mask on another sheet (Mask) consisting of cells filled with ones (where you want to keep the …
Category Archive: Tips and tools
Mar
19
Collaboration on documents
I was advised to use FolderShare application to share documents with my collaborators. But, in fact, we already have subversion for our code development. This automatically raised a question of why would we use FolderShare if we already have subversion installed on our server and in operation. It is not reasonable to compare subversion with …
Nov
15
iPhone/iPod Touch Disk Mode Solution
If you have had the chance to use an iPhone or iPod Touch, you might have noticed a “small” inconvenience: these devices do not appear as removable storage drives in Windows, like prior versions of iPod (classic, nano, etc). This effectively prevents the iPhone and iPod Touch to be used for data transfer. There is …
Oct
09
Slideshare
I just ran across Slideshare, a (beta) website that lets you share slides (yes the name is descriptive). I uploaded my first set of (PowerPoint) slides, and now I can embed them in this post – very cool: P54 Presentation at 2007 ITU Fully Networked Car Workshop View SlideShare presentation or Upload your own. (tags: …
Oct
06
Robert Scoble on getting a job
Looking for a job? Check out this post for excellent suggestions on how to get on top of the resume pile.
Sep
30
Firefox and literature review
Literature review is a big part of a scientific underatkening. Thanks to the Internet, most papers are available on line. This resulted (at least for me) in a big number of papers that I read and stored for feature references… Welcome to the age of data mining. As a researcher I have yet another problem …
Aug
15
Using Adobe Premiere
As many of you may know, I spent a good part of the summer in front of the video-editing computer transcribing data from videos of experiments. I used Adobe Premiere to organize and view the videos. However, Adobe Premiere was made for movie/cinematic editing, not data transcription, so I had to “invent” a few ways …
Aug
11
Where did the multiple windows go in Excel 2007?
I have recently realized that when I open multiple documents in Excel they all show up separately on Taskbar but show up in the same window of Excel. This can be very aggravating for anyone who works with multiple documents and multiple monitors. After becoming fed up with Excel I did some research online and …
Jul
17
Tinyurl.com – a great tool for simplifying web addresses
Check out www.tinyurl.com. It allows you to create tiny URLs out of long and winding ones. This is neat when you want to send a link in an email to someone without having to worry if their email client will interpret the multiple lines of the link correctly. It’s also neat if you want to …
Jul
15
AutoHotKey – free, open-source utility for Windows
Hello, AutoHotKey is a handy utility that can be used for automation tasks. This program can move the mouse or send key events to different applications. It also can show dialogs. I mostly use it as a macro recorder that works across all the applications. It supports a simple (as in easy to learn), but …