Spreadsheets

Techie Leonard Lin publishes his investment asset allocation in a Google Spreadsheet which employs the super-useful GoogleFinance formula for live-updating stock prices in-sheet. [via] Full Article

Lynette Chandler of Tech Based Marketing has put together a short-and-sweet guide to setting up a data-gathering web form using Google Docs‘ spreadsheets tool. Follow the easy-to-grasp instructions, and you’ve got a clean form that can be embedded on any page and streams data back to a spreadsheet you control. Great for grabbing info for [...]

Goolge seems to be experimenting new functions in Google Docs spreedsheets application. The new functionality found including the ability to record, edit and run macros, edit a shared spreadsheet in “List mode” and a few new functions for use in spreadsheet formulas. A new option found under the Share tab currently offers Googlers the ability to allow [...]

In a strange move, Google has added a new feature to Google Docs that enables users to allow anyone to edit a spreadsheet, advertising the option as a way to make a spreadsheet like a wiki. Previously, individuals could be invited to view or edit a spreadsheet, but they had to create an account with Google after entering a custom URL that effectively served as a security-through-obscurity barrier

eBOOK Details Publisher Peachpit Press Release Date January 7, 2007 ISBN 0321492382 eBOOK Description Microsoft Excel is the world's most-popular spreadsheet program--used by schools, offices, and home users. In Excel 2007, Microsoft has completely redesigned the user interface, making it more intuitive and more attractive. But anyone needing to get started quickly without learning all the {This is a content summary only, visit my blog for full link, other content and more }

Convert a Spreadsheet to an HTML Table [Spreadsheets] When you want to turn that giant spreadsheet into an HTML table without wrangling too many TD's and TR's by hand, you can use a formula to generate the HTML tags for you. The Design Intellection blog describes how to use the =CONCATENATE("text", cell, "text") spreadsheet formula to turn a row of data into an HTML table row. On Friday, Kevin pointed out a web-based HTML table generator that's a simple, fast solution for small tables; but if your data's already in a spreadsheet and the word "concatenate" doesn't make you want to run screaming, this may be a better way to go. Using Spreadsheets to Easily Create HTML Tables and Forms [Design Intellection] Link - Gina Trapani - Sun, 04 May 2008 13:00:00 GMT - Fe

Excel Programming: Your seeable plan for creating mutual spreadsheets (Visual Blueprint) (Paperback)By Jinjer Simon Buy new: $17.8139 utilised and new from $5.00 Customer Rating: First tagged “excel” by V. K. Noll “denalinoll” [...]

Now, normally when I find an XSS vulnerability on a popular domain I just report it to the appropriate security team and move on, but this one is interesting…By taking advantage of the content-type returned by spreadsheets.google.com (and a caching flaw on the part of Google), I was able to pull off a full blown XSS against the google.com domain. For those of you who don’t understand what this means, allow me to elaborate. When Google sets their cookie, it is valid for all of their sub domains. So, when you log into gmail (mail.google.com), your gmail cookie is actually valid for code.google.com, docs.google.com, spreadsheets.google.com…and so on. If someone (like me) finds an XSS vulnerability in any one of these sub domains, I’ll be able to hijack your session and access any g

1. Select all the rows in your Microsoft Office Excel spreadsheet data set. 2. On the Home tab, in the Editing section, click Find & Select, click Go To, click Special, click Blanks, and then click OK. 3. Click the equal sign (=) on the toolbar, select the cell above, and then hold down the CTRL key while you press ENTER. Blanks in the spreadsheet will be filled automatically. 4. Copy all the data, click Paste Special, and then click Values. This will overwrite the formulas and enable you to sort the data by filling in each empty cell with the same information as the one above. This tip will work on any size of data set.

By default the slash (/) key acts as a shortcut to the Excel menu bar. Here’s how to disable this so that you may use the slash character within your Excel 2007 spreadsheet. 1. From the Office Button menu, select Excel Options. 2. Choose Advanced, and then scroll down until you see the Lotus compatibility section. 3. In the Microsoft Office Excel menu key: field, replace the slash with a character that you do not use frequently, and then click OK.

Google Spreadsheets new gadgets feature makes it easy to add a heat map, which can be used to create a world map illustrating the Googleshare for a given keyword across different countries.  Google employee Douwe Osinga called this “Land Geist” a couple of years ago. What’s “googleshare”? Also called mindshare, the Googleshare expresses how much any two given concepts are [...]

Notifications:When working in collaboration with others now you can set notifications if others users who have access to same spreadsheet (of Google Apps), made any revisions. Cool! No need to look at document again and again – just set the notification.To set notification just click on a new link enables by Google at the top bar called Set Notification RulesGadgets:Now the power feature (of Goo

Google Spreadsheets, which’s a part of Google Docs suite (Google’s online office suite) is updated and has added added several new features; better revisions comparison through color highlights, change notifications, and a Google spreadsheet gadgets directory. Now you can get email notifications when your collaborators make changes or edit some specific cells. You can also get [...]

Google Spreadsheets Adds Gadgets and Autocomplete [Google Spreadsheets] Google rolls out a few impressive new features to its online spreadsheets offering today, including cell autocomplete, iGoogle gadgets, and notifications about collaborative edits. Autocomplete works the way any desktop spreadsheet does: as you type, if the cell contents match a past entry, Spreadsheets will suggest the value. As for data collection and sharing, you already know you can ask others to fill in a spreadsheet with a user-friendly form. Now you can get notifications whenever a sheet gets updated, down to a specific range of cells or via a form. Finally, you can track the status of your spreadsheet on your iGoogle homepage by creating a data widget, which updates as your spreadsheet does. Pretty n

I always knew that MS Excel can have immense applications in the field of medicine. I searched for good medical spreadsheets online with no luck for a long time. I was planning to create my own Excel templates for medical applications. But I never got time to learn the application in detail, let alone create my own spreadsheets. I was puzzled why such a simple yet fantastic idea never occurred in

Google Spreadsheets has several new features, as a Google Docs Guide in the official help group on the subject announced today:** Background and text colors based on rules YOU createhttp://documents.google.com/support/spreadsheets/bin/answer.py?answer... - Set text and background colors based on rules you create! A great tool for those of you who want a quick visual summary of complex or changing data. ** Hide and Unhide Datahttp://documents.google.com/support/spreadsheets/bin/answer.py?answer... - Not excited yet? Well, maybe you will be when I mention that this feature enables you to *hide row and columns*! Champagne, anyone?** Print like a pro-To create a better printing experience, we've changed the default printing output. Now, before you print, your spreadsheet is convertedto PDF, creating a more readable, better looking printed spreadsheetfor all.** Banish ugly errors when your formula doesn't compute- Try using the new function IFERROR. IFERROR allows you to choosewhat s

I spent all night last night, that I remember anyway, staring at a spreadsheet. Well, really the layout of an Access Database. That is what I’m working on at work, and I change code to reload the database, and then I look at the Access display to see what my work produced. It was not good, not bad, it just was. But I really didn’t like staring at a spreadsheet all night. I do that during the day!

Google Docs & Spreadsheets is a Free web-based word processor and spreadsheet, which allow you share and collaborate online.Create basic documents and spreadsheets from scratch.You can easily do all the basics, including making bulleted lists, sorting by columns, adding tables, images, comments, formulas, changing fonts and more. And it's free. Upload your existing files.Google Docs & Spreadsheets accepts most popular file formats, including DOC, XLS, ODT, ODS, RTF, CSV, etc. So go ahead and upload your existing files; all your formatting and formulas will come through intact. Familiar desktop feel makes editing a breeze.Just click the toolbar buttons to bold, underline, indent, change the font or number format, change the cell background color and so on.

I am impressed by Google and its frequency of introducing new features to already launched web services unlike Microsoft who launches new betas every now and then and ends up with applications full of bugs and security loop holes. Here we come across another new feature introduced by Google to Google Docs family. Google Docs Get Some Exciting New Features  Google Docs Blog recently reported about the new features and changes that have been made to Google Docs and Spreadsheets. The main changes have been done to the layout of Google Docs and Spreadsheets. The aim is to make Google Docs more visually appealing and easy to use for new users. Google Docs and Spreadsheets New Features  Here are new changes made to Google Docs and Spreadsheets Visual Remake The entire document list has been given a visual remake with new icons, more content and better controls. Folders The new Google Docs has now Folder support. Previously you could tag documents only but now the tags have been converted

Parece que, además de los cambios estéticos que hemos podido apreciar con Google Docs & Spreadsheets, también ha venido la inclusión de algunos nuevos shorcuts, o atajos de teclado, para Google Docs. Pueden encontar los originales aquí, pero me dí con la sorpresa, de que sólo se encontraban en inglés. Así que para aquellos que los buscaban en español, les dejo la lista traducida, después del salto.         Compártelo!

OpenOffice.org is an Open Source, community-developed, multiplatform office-productivity suite. It includes the key desktop applications, such as a word processor, spreadsheet, presentation manager, and drawing program, with a user interface and feature set similar to other office suites.Sophisticated and flexible, OpenOffice.org also works transparently with a variety of file formats, including Microsoft´s.Localizations of OpenOffice.org are available in 27 languages with more being constantly added by the community. OpenOffice.org runs stably and natively on Solaris, Linux (including PPC Linux), and Windows. Additional ports, such as for FreeBSD, IRIX, and Mac OS X, are in various stages of completion.Written in C++ and with documented APIs licensed under the LGPL and SISSL Open Source licenses, OpenOffice.org allows any knowledgeable developer to benefit from the source. And, because the file format for OpenOffice.org is in XML, interoperability is easy, making future development a

As someone who usually work on three different PCs and a laptop, i find Google Docs and Spreadsheets very convenient, due to the fact i can access my documents from each of my computers. As time went by, i started to accumulate lots of docs and spreadsheets in my Google account, and i asked myself how should i backup them. I knew i could open each and every document and just save it as a Microsoft Excel or Microsoft Word document, as well as a PDF document, but i was looking for a more powerful method. I searched a bit and found a nice Greasemonkey script that helped me to accomplish my task. Greasemonkey is a Mozilla Firefox addin that lets you modify the way your Firefox pages look and run.  Note that Greasemonkey scripts work only with Firefox, so if you are using Microsoft Internet Explorer, you will need to install Firefox before moving forward. So here’s what you should do in order to backup your Google docs and Spreadsheets: Open your Firefox

I'm not sure how long this has been available but you can now post to your blog using Google Docs & Spreadsheets. You can add your blog by clicking the Publish button. In the dialog your see a button labeled "Post to blog".Settings support most major Web services like Blogger. There's also support for MetaWeblog enabled blogs like Bloget pictured below:As a blog editor, Google Docs & Spreadsheets is a bit awkward. For instance, to add image from a Web source you have to edit the HTML directly. There is a function to insert pictures from your computer however. One advantage of using Google Docs & Spreadsheets is it does keep a revision history of your document which can sometimes be handy. Also missing are tools to insert tags or blog preview similar to Windows Live Writer. Until there are more blog friendly features I'd stick with a more dedicated blogging editor. Oops! Looks like there still some bugs to iron out. For some reason, Google Docs & Spreadsheets returns

Google Docs and Spreadsheets For all out there who use Google Docs and Spreadsheets there are new treats for you. Google has added new features to Google Docs and Spreadsheets. Also being a very frequent Google Doc user I think that it is necessary for every Google Spreadsheet user to know how to add charts to your Google Documents All thanx to the Official Google Docs Blog that now adding charts and pie diagrams to your Google Docs is no longer a difficult task Adding Charts To Google Docs Here is how Google teaches us to add Charts to Google Docs: Select the cells you want to use for the chart data Click the new chart icon in the toolbar Select your chart type In the popup dialog Customize your chart See it was a simple 4 step easy process New Google Spreadsheet Features Talking about new features Google Spreadsheet comes in our mind. Here is a list of feature updates for Google Spreadsheets: Named ranges: you can define a name for a range of cells, and use this name in formu

Zoho upgraded their spreadsheet program called Sheet last Friday and added Zoho Chat integration.  This allows multiple users to work on a spreadsheet at the same time and to communicate via the Zoho chat feature.  Google Spreadsheets also offers the same functionality and with this update, Zoho joins the group of online collaborative tools.  In addition to the integrated chat, Zoho has added support for the OpenDocument Sheet which allows users of OpenOffice to work and collaborate on these documents as well.  Zoho has a number of online office productivity tools such as a word processor, spreadsheet, presentation, wiki, and more.  Visit their web site for more details.  Their name above is linked to their web site.     News Source: Webware

Google Docs & Spreadsheets중의 Spreadsheets가 금방 새롭게 업데이트를 진행했다. 새로운 버전은 V1.2.0i 이다. 이번에 업데이트한 주요한 목적인 일부 기술문제들을 수정하면서 전체적인 조작성능을 제고시켰다. 주요한 업데이트는 아래와 같다:혹시 여러분들이 원했던 기능이 새로 변경되었는지 보세요.Shreadsheets의 로딩 속도를 제고시켰다;가끔씩 Spreadsheets가 정상적으로 로딩 되지 않는 문제를 해결;Spreadsheets에 연결할 수 없을 때 힌트창이 뜨면서 자동으로 다시 연결을 시도한다;IE 사용자들이 Spreadsheets 화면을 로딩할 수 없을 때 Ctrl+F5를 눌러서 새로고침을 해라는 메시지가 뜬다.(아직도 완전히 해결 안된 모양이다)Google Base의 tsv파일에 대한 지원을 추가했다;Spreadsheets에 있는 링크를 실제 형식으로 보여준다;And lastly, hyperlinks in spreadsheets now appear as actual, worki

For those of you enjoying our new support for document editing through the excellent Zoho Writer, we have added support for Zoho Sheet and Zoho Show today!Zoho Sheet is an online alternative to commercial desktop spreadsheet applications, with great charting features and more! Click Edit with Zoho next to any Excel (.xls) file to view and edit in Sheet, then click save to update the file in your myDataBus account.Zoho Show is a matching tool to create, edit, publish, and show presentations. At this time the Zoho API only supports viewing presentations (we will add support in myDataBus for editing as soon as it is released!), but if you have PowerPoint presentations loaded into your account this is a really great way to preview or even present them to others. Click on "Show with Zoho" to open your presentation in a very useful flash player. Ready to present? There is a full screen icon on the player that gives you a very handy presentation mode!We have added Zoho links to search re

This looks pretty fucking cool. I wonder if I will write my DPhil thesis on this in the end. Can it do footnotes, I wonder? Maybe I could send drafts to my supervisor this way. Footnotes would be good, though, and some sort of compatibility with EndNote or RefWorks. I actually wrote this post in Google Docs & Spreadsheets and posted it to my blog from there. This is really just a trial post, playing around with it.This is what quotations look like. I hope there isn't a box around this.I imagine in future journalists will be using this kind of thing - if they aren't already.Doesn't look like the title of the document has been imported into Blogger. It should be called Google Docs & Spreadsheets. I'll write my ickleReviews with this in future. Better than using the WYSIWYG editor in Blogger, although that has improved; and better than posting them by email, which sometimes messes up the formatting.

Google is finalizing the integration of Docs & Spreadsheets to enhance its free services and software offerings.!!!Google Inc. is finalizing the integration of Docs & Spreadsheets with Google Apps for Your Domain, another step in its strategy to build a suite of hosted applications for organizations. The introduction of the new version of Google Apps for Your Domain including Docs & Spreadsheets will happen this quarter, and it could come as early as next week, several people familiar with the company's plans said. It has been widely assumed that at some point Google would add Docs & Spreadsheets, a word processing and a spreadsheet program, to Google Apps, a suite of communication services for organizations. Docs & Spreadsheets lets multiple users share files and collaborate on them. Google Apps provides white-label versions of several Google communication services, including the Gmail Web mail service, the Talk instant message and voice chat service and the Calendar online sched

Maybe it’s because I’m bad at math and saved by using spreadsheet formula functions or maybe it’s because I’m just an “attention to detail dude” and the thought of throwing important data into a word or plain text document scares me. Either way I’ve always been a spreadsheet fan. Now enter Google Docs & Spreadsheets, an online spreadsheet application that has most of the functionality of Excel, sharing and editing with others in real time, editing from anywhere in the world and massive import and export features all of which elevated me into a much bigger spreadsheet supporter. Go Team!  In fact, I find myself using the Google system on a weekly basis for both clients during correspondence and internally with the gang for collaboration.  Word up to the online spreadsheet! http://spreadsheets.google.com

Now you can get stock market quotes and other data updated to your spreadsheets by using the GoogleFinance function. Using the GoogleFinance function: To use the GoogleFinance function, enter the... This is a content summany only. Please visit Dee's-Planet! Blog for full contents, links and more....

Google has released an API for their Spreadsheets program. You can use it to get a list of spreadsheets for an account, to add or delete rows from a spreadsheets or to send simple SQL-like... This is a content summany only. Please visit Dee's-Planet! Blog for full contents, links and more....

Richard MacManus on the Read/WriteWeb posted about Gizbuzz’s podcast interview with Jen Mazzon and Sam Schillace of the Google Docs and Spreadsheets team (both ex-Writely). They start off by... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Google announced the availability of a Google Docs & Spreadsheets gadget, that lets us “Add stuff you care about to your Google homepage.” You can personalize your Google homepage... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

hopefully daily... at least through weekdays when things are hopping. The hyperlink is available on the 2006 Election page your you can simply book mark the two spreadsheets: http://www.coldheartedtruth.com/senate.html http://www.coldheartedtruth.com/congress.html

Available now is the very first Congressional polling spreadsheet created by Indy Voter. Also available is the Senate polling spreadsheet created by your's truly. I will also add a link to the 2006 Election page sidebar for these spread sheets.

You might have come to know by now that Google has released a service called Google Docs & Spreadsheets . In this service, one can use an online text editor (similar to Microsoft Word and others) to create posts and publish it to their blog. With this service, you can: - Have your documents published online (as a webpage) to share it with others (dedicated URL to each document, as in Google