Google Spreadsheets Lock Down Cells with Protected Ranges, New Colors & Patterns; Custom Colors in Calendar; Global Neural Network Cloud Service for Breast Cancer Built Using App Engine

Google Spreadsheets received an update in the "Named Ranges" feature to let you protect a section when working with other in real-time and that "a collaborator didn't intend to be touched." To get started with Protected Ranges in a shared spreadsheet, highlight the cells you'd like to protect, right-click, and choose Name and protect range […]

Google Spreadsheets received an update in the "Named Ranges" feature to let you protect a section when working with other in real-time and that "a collaborator didn't intend to be touched."

To get started with Protected Ranges in a shared spreadsheet, highlight the cells you'd like to protect, right-click, and choose Name and protect range from the menu.

In addition, Spreadsheet also added following new features this month - First up, along with the arrival of protected ranges, you can now add colors and patterns when you apply cell borders in Google spreadsheets.

Also updated, is the "find and replace" to make it possible to search using patterns (also called regular expressions). For example, "^[A-Z]+" will find all the cells that start with uppercase letters.

Click through the presentation below to see the feature in action.

In other Google Docs news, the color palette for Google Calendar now let you customize calendar colors. "Just click the arrow icon next to a calendar in the left sidebar, click "choose custom color" and pick your favorite background color. Select "light text" if the text is hard to read."

"Google Calendar users have had the ability to change the colors of specific events or calendars from a default color palette. Users can now choose a custom color if the default palette does not meet their needs," informs Google. This feature is also available for Google Apps.

Google Calendar Customize ColorsCustomized Color Palette in Google Calendar

Customize Color Palette in Google Calendar

Also, in a blog post, Brittany Wenger, the winner of this year's Google Science Fair explains how she built an application on Google App Engine called the "Global Neural Network Cloud Service for Breast Cancer."

Neural Network for Breast Cancer Data Built on Google App Engine

This artificial neural network can detect complex patterns in data, learning how to classify malignant or cancerous cells it hasn't seen before. Learn more about her project.

"When a patient has a palpable breast lump, the first step a doctor takes is to determine whether the mass is malignant or benign. One relatively simple diagnostic procedure is a form of biopsy called fine needle aspiration (FNA). Though these tests are less invasive than others, they are historically less accurate as well. My goal was to create a tool for doctors to use when interpreting test results from these procedures," explains Wenger.

For this project, "I decided to create a neural network built on Google App Engine, using data published to the Machine Learning Repository by the University of Wisconsin."

"A neural network attempts to replicate the brain as a form of artificial intelligence through networks of computers and can be used to detect extremely complex patterns. It learns from its mistakes, so it can classify a case it hasn't seen before as malignant or cancerous based on specific criteria like clump thickness or bland chromatin. Because the diagnostic power of the network improves the more data it has, building on App Engine is a way to ensure the app can continue to scale easily, no matter how much information goes into the system," she adds.

Finally, If your application needs a way to let users easily choose a file from their Drive, this is for you.

"Users can browse and select files from their Drive file list using the "Google Picker API," which provides a user interface containing a list of all the user's files in Google Drive. Since the user interface is generated by the Picker API, there is very little effort in adding the Picker to an existing site," Google explained.

For a complete example, including how to load the Picker library, please visit our the Drive SDK documentation.

Also, see the Picker API documentation for more information.

Google Picker API for Google Drive