Thread: Anyone use Google Docs?

Revisiting this one folks if I may.

In the end, I started using Google Docs with my staff for some spreadsheets and wonder if anyone can help with some of the functionality and reporting aspects of it.

One of the docs I have created a form or template or my staff to complete which then populates the spreadsheet itself based on the various check boxes and answer they give. They select this doc by going to "Form" on the tool bar and then selecting "go to live form". Also in "Form" you can select "show summary" and this is the sheet I need some help with. Ths summary sheet, by default once a live form is created, compiles all the various information into graphs/charts/percentages etc and is very useful as a running statistic of how things are. What I need though is some way of date ranging this info or locking it off for a month/year for example other wise it simply keeps calculating as it is updated. An quick fix is to create another identical form for each month but this means lots of different sheets and forms and until I find a way, will not total together each month to give year stats.

I hope i'm explaining myself ok but if anyone can help I would be very grateful. Excel has been my friend for many years for collating this kind of info but it appears Google Docs has some build in auto functionality which essentially will negate a lot of formula writing for me, plus allows us one edit and review point.

Thanks in advance for all assistance.

Aye, Mick

I use it for personal stuff that I want access to where ever I am, but it is all fairly meaningless for any one else, and I keep it that way.
Nothing on there that I wouldn't put on a page that was accessible to the world.

cheers

To be honest, what you are trying to achieve may be beyond the capabilities of Google Docs. It certainly lacks most of the functions of Excel.

Have you posted your query on Google Groups?

Alan

its good but not as good as say open office or the microsoft snot in terms of functionality.

Its not touted as secure.... yet.

I used it for stuff that doesnt need to be secure but I need to be able to find in a hurry.

I use Google Docs - specially if I want to share stuff via a website.

If you have a small company and want to share documents, comments on it etc. - try this: Project Management Software, Online Collaboration and Document Sharing ~ Huddle

Free up to 1GB.

Cheers,
Daniel

I know everyone wants everything for free, but sometimes the best things in life aren't free.

I thoroughly recommend LotusLive. They have something for everyone.

https://www.lotuslive.com/compare

If you go to their homepage they have a free trial of LotusLive Engage.

Here is another one of those online applications I use:

Email Hosting, CRM, Project Management, Office Suite, Document Management, Remote Support

Nothing in this life is entirely free and frankly I would barely trust Google with any personal or private data. I know nothing about a couple of those sites already posted and they do not fill me with confidence, IBM on the other hand, I would have no problem with them and I would assume their product is also compatible with the major players and their Symphony, which is pretty cool actually (and free).

Alan