Sunday, January 22, 2012

How to Use the iPhone Camera Zoom, Focus, etc.

To focus on a specific element, just tap the screen where you want the iPhone to focus. A blue rectangle will surround the area, give it a moment to focus (you'll see it happening), then snap your photo.

To zoom, just pinch and drag the screen as you do with other apps. You can also simply slide your finger along the slider bar that appears once you begin pinching the screen.

To use the flash, tap the lightning bolt in the upper left corner. You can select On, Off, or Automatic.

Cool feature - to quickly take a picture while the phone is locked, simply press the home button twice. The camera appears (and the music player does too). Note, if the passcode screen pops up, you can not quickly access the camera from here. You must go back to the home screen which you can do by tapping 'cancel' on the pass code screen. (Until you unlock your phone, assuming it's locked, no one can access your pictures.) You can also use the volume up/down buttons to take the picture.

HDR - This supposedly allows for a better picture but requires more space. Per Apple's web site: "iPhone 4S captures three photos from that one shot, each with a different exposure level. Then it layers the shots together to create a single photo that combines the best parts of each shot. The wide range of light is more accurate in an HDR photo. And iPhone saves both the original and the HDR photo in your Camera Roll."

You can edit red-eye right in the picture. Tap the photo, then edit in the upper right corner. The red circle with the slash through it at the bottom of the screen will guide you through red-eye removal.

If you lose the "transition" swipe option between photos, you can turn that on/off by going into your "camera roll" and tapping the fat right facing arrow at the bottom of the screen. Here is where you can also turn on/off auto-enhance,as well as crop and rotate.

Saturday, January 21, 2012

Enable Right-click for Images in Chrome

UPDATE 9/15/2012:

Chrome has changed since when I posted the below. Go here first to turn off JavaScript (required to make right-click work when it's not enabled), and then come back and continue reading below.


If a web page has the right click disabled, you can enable it by turning off JavaScript (you'll enable it again later in these instructions):

by Tomoya Kawasaki (Google Employee):

"to turn javascript off and on
go to the tool tab at the top
Click on "Options"
Go to "Under The Hood"
Click on "Content Settings"
Click on the "JavaScript" tab"

That's all I had to do, and then re-enabled it afterwards, but here's more if needed:

"As for clearing the cache instead of clicking on "Content Settings"
Click on "Clear Browsing Data" on that same screen
You may find that JavaScript is already on so you may have to download the newer version"

Thanks and source:

Alternatively with the mouse, I've been able to hover to the right of the image, right click and hold, drag the mouse over the image (the image will turn slightly transparent blue), then let go, and hold cursor on the blue (without clicking!) and right click, and then copy. You've now captured it and can paste it elsewhere. If the right click didn't work, just let go of the mouse while the image is still blued and CTRL+C (for copy). 

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Wednesday, January 11, 2012

"OnLive" Free iPad App Windows 7 Office

OnLive, a startup, has developed a free app for the iPad that will let users run a Windows 7 desktop on their iPads, including Word, Excel and PowerPoint. Users will be able to create and edit documents in those applications on their iPads and store them online, using the two gigabytes of free storage OnLive will provide people. Source: Technology - Bits - The New York Times

Not much storage so will need to selectively manage docs.

Tuesday, January 10, 2012

How to Zoom on Google Docs

If you get this message, "Your browser's current zoom setting is not fully supported. Please reset to the default zoom by pressing Ctrl+0"... note that is a ZERO not an "O" in Ctrl+0. Yep, I clicked "O" too.

On the MAC it is cmd+0


Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Automatic Stock Quotes in Google Docs

Here is a list of Common Attributes for automatic stock quotes in Google Docs. This is the starter syntax (put this in any cell): =GoogleFinance(+A2, "Price") where A2 is your Stock Symbol (e.g. AAPL)
  • You can enter a max of 1,000 GoogleFinance functions in a single spreadsheet; two functions in the same cell count as two.
  • If you would like to try using Google Finance in Google spreadsheets, you can use this template to get started. [NOTE: This is not my template but appears to be OK. Source is at the end below.]
STOCKS - The following types of real-time market data are currently available:
  • price: market price of the stock - delayed by up to 20 minutes.
  • priceopen: the opening price of the stock for the current day.
  • high: the highest price the stock traded for the current day.
  • low: the lowest price the stock traded for the current day.
  • volume: number of shares traded of this stock for the current day.
  • marketcap: the market cap of the stock.
  • tradetime: the last time the stock traded.
  • datadelay: the delay in the data presented for this stock using the googleFinance() function.
  • volumeavg: the average volume for this stock.
  • pe: the Price-to-Earnings ratio for this stock.
  • eps: the earnings-per-share for this stock.
  • high52: the 52-week high for this stock.
  • low52: the 52-week low for this stock.
  • change: the change in the price of this stock since yesterday's market close.
  • beta: the beta value of this stock.
  • changepct: the percentage change in the price of this stock since yesterday's close.
  • closeyest: yesterday's closing price of this stock.
  • shares: the number of shares outstanding of this stock.
  • currency: the currency in which this stock is traded.
  • closeYest: the NAV of a mutual fund.
  • date: date at which NAV (net asset value) was reported.
  • returnytd: year-to-date return total.
  • netassets: The day-end net assets of the mutual fund. Net-asset figures are useful in gauging a fund's size, agility, and popularity. They help determine whether a small company fund, for example, can remain in its investment-objective category if its asset base reaches an ungainly size.
  • change: change in NAV value between the most recent reported NAV, and the NAV prior to that.
  • changepct: the % change in the NAV.
  • yieldpct: Also known as the distribution yield, Morningstar computes this End Yield figure by summing the trailing 12-month's income distributions and dividing the sum by the last month's ending NAV, plus capital gains distributed over the same time period. Income refers only to interest payments from fixed-income securities and dividend payments from common stocks.
  • returnday: one-day total return.
  • return1: one-week total return.
  • return4: four-week total return.
  • return13: thirteen-week total return.
  • return52: 52 week total return.
  • return156: 156 week total return.
  • return 260: 260 week total return.
  • incomedividend: the amount of the most recent cash distribution for the fund.
  • incomedividenddate: the date the above occurred.
  • capitalgain: the amount of the most recent capital gain distribution from the fund.
  • capitalgaindate: the date of the above.
  • morningstarrating: the Morningstar "star" rating.
  • expenseratio: The percentage of fund assets used to pay for operating expenses and management fees, including 12b-1 fees, administrative fees, and all other asset-based costs incurred by the fund, except brokerage costs. Fund expenses are reflected in the fund's NAV. Sales charges are not included in the expense ratio.
Use this function:
Syntax: =GoogleFinance("symbol", "attribute", "start_date", "num_days|end_date", "interval") where:
  • "symbol" - stock symbol
  • "attribute" - high, low, open, close, vol, or all (quote also works, and defaults to close).
  • "start_date" - the date for the historical data. When only the start_date is specified, the historical data is just for that day.
Note: The remaining parameters are optional.
  • "num_days" | "end_date" - can be either the end date for the time period over which you want to see historical data, or the number of days from the start date. Any number less than 50 is considered to be num_days. Otherwise it is considered an end_date.
  • "interval" - this specifies the interval "DAILY" or "WEEKLY," or 1 and 7 can also be used. This is the granularity at which the stock data is shown at daily or weekly intervals. Please note that queries for recent dates may not have information, as historical data may not be available for a day or two.
  • open: the opening price of the stock for the indicated day.
  • close: the closing price of the stock for the indicated day.
  • high: the highest price the stock traded to date.
  • low: the lowest price the stock traded to date.
  • volume: number of shares traded of this stock to date.
  • all: the concatenation of date/open/close/high/low/volume returned as a table for historical quotes.

Email Large Files

Saving this app for when I need to email a big file:

Who has Access to My Google Account?

Click the link below to find out who you've given access to your Google Account. You can add or remove access from this page.
Click Revoke Access to remove access.

Change the Size of a Picture

I use "Microsoft Office Picture Manager" File/Export and choose new settings (e.g. make picture 50% of original size).

"Many common picture editing programs allow you to change the quality level of a JPEG picture when it is saved. When using the program, look in the program's Save As dialog box for an option to change the compression or quality level. The lower the quality (or higher the compression), the smaller the file will be when it is saved. "

Monday, January 9, 2012

Where is my Startup Folder - Windows 7

C:\Users\(User-Name)\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Tuesday, January 3, 2012

How to Uninstall VAIO Messenger

Here is how to uninstall VAIO Messenger.

First, note you can simply change the types of messages received: Click on the Settings option in the Start / All Programs / VAIO Messenger menu and uncheck those you do not want to receive. You can uncheck all and thus receive none. However the VAIO Messenger will still be running in the background. Another option may be to simply remove it from the startup folder. Haven't tried that.

[My notes are in red.]


There are two programs you must uninstall in order to completely remove VAIO Messenger. They are VAIO Messenger, and Oasis2service, the service which delivers updates to VAIO Messenger.

If you uninstall VAIO Messenger and the associated service, you will no longer be able to receive critical messages from Sony regarding your PC. [Not sure if that's so critical.]

VAIO Messenger and the Oasis2Service may be uninstalled from the Programs and Features section of the Control Panel.

1) Click on Start menu button and select Control Panel, then select Programs & Features
2) In Programs and Features, click on VAIO Messenger to select the application.
3) Click on Uninstall to uninstall VAIO Messenger.  [A webpage for DDNi will launch in a browser window I just simply closed it, and notice the uninstall program is still in progress.]
4) Click on Oasis2Service to select this service.
5) Click on Uninstall to uninstall Oasis2Service.*
6) Once uninstall is complete, it is recommended you reboot your PC

Source and thanks to:

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

A Quick Method to Parse Text in Excel

I needed to parse out the domain name from a list of email addresses. I simply used Excel's Text to Columns with the @ as the delimiter. But of course!

In Excel: Data > Text to columns > Delimited > Other: @

Monday, January 2, 2012

Sunday, January 1, 2012

Sony VAIO Extended Sheet Battery VGP-BPSC24

VAIO Extended Sheet Battery
Model number: VGP-BPSC24


  • 7.5 hours is standard for the laptop
  • The extended life sheet battery works in tandem with your laptop to give up to 15 hours
  • thus doubling battery life
  • adds 1 pound and 1/3 of an inch
  • when attached and charging, your laptop it will charge the standard battery first up to about 80% full. It will then switch over and start charging the battery pack in case you need to unplug and go.
  • It will discharge the sheet battery first before it starts discharging the standard battery.
  • Sheet battery can also be charged separately with the included adapter.
  • $149 (it came as a bonus with my VPCSA laptop I bought from Sony's website)
  • Manual Instructions below.

Get up to 15 hours total combined battery life4 (double the standard battery life) with this extended sheet battery designed for use with VAIO 13.3" S Series laptops, and compatible with the VGP-PRS20 S Series docking station (sold separately). Boasting a slim, lightweight design, it attaches easily to your standard battery to boost your battery life at home, the office or on the road, and can be charged while attached or independently so it's ready to go at a moment's notice. Featuring dual battery life reporting in your Windows® 7 System Tray, you'll always know how much charge is left before dashing out the door.

More battery life than before

Designed specifically for use with VAIO S Series 13.3" laptops, this extended sheet battery provides amazing battery life around the home, office or while on the road. Enjoy up to 15 hours of total combined battery life (with optional extended battery) --double the standard battery, helping to keep you unplugged longer4.

Perfect for your S Series

Leveraging the latest innovations in lithium polymer technology, the battery of the S Series is integrated into the PC. It conforms to the contours of the chassis offering a thinner battery profile while still supplying up to 15 hours of total combined battery life1 (with optional extended battery). As if that is not enough, it is compatible with your docking station and also made easy to grip when carrying the unit.

Intelligent charge

The S Series knows how to minimize charge time to give you the best battery life when charging on-the-go. And when it’s time to charge, no need for your PC - this extended sheet battery can be charged independently (without laptop).


1. GHz denotes microprocessor internal clock speed and may vary.

2. 1 GB = 1 billion bytes. Actual formatted capacity will be less.

3. Viewable area measured diagonally.

4. Estimates only based upon Sony engineering testing. Actual performance will vary based on notebook settings, environmental conditions, and usage. Battery capacity decreases over time and use.
Certain Microsoft products included with this computer may use technological measures for copy protection. IN SUCH EVENT, YOU WILL NOT BE ABLE TO USE THE PRODUCT IF YOU DO NOT FULLY COMPLY WITH THE PRODUCT ACTIVATION PROCEDURES. Product activation procedures and Microsoft's privacy policy will be detailed during initial launch of the product, or upon cvertain reinstallations of the software product(s) or reconfigurations of the computer and may be completed by internet or telephone (toll charges may apply).

© 2010 Sony Electronics Inc. All rights reserved. Reproduction in whole or in part without written permission is prohibited. Sony, VAIO, Media Gallery, and VAIO Care are trademarks of Sony. PlayStation and PS3 are trademarks of Sony Computer Entertainment Inc. Intel and Core are trademarks of Intel Corporation. Microsoft, Windows, and Excel are trademarks of Microsoft Corporation. Blu-ray Disc is a trademark. Bluetooth is a trademark of Bluetooth SIG, Inc. HDMI is a trademark of HDMI Licencing LLC. All other trademarks are trademarks of their respective owners. Features and specifications are subject to change without notice. All non-metric weights and measurements are approximate and may vary.


Battery Specs:

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Related Posts Plugin for WordPress, Blogger...