View Full Version : Google Docs/spreadsheet/calendar/sync/change format help!

25-08-2010, 02:18 PM
I’m on a bit of a mission here…I’m not even sure if it’s possible to achieve this using Google calendar/apps or not, I’ll leave it for you guys to decide that. Here’s the situation.

A client of mine who runs a trucking business has a daybook – a page for each day – where he writes in info about pickups/drop offs. He wants to move this from a physical book infront of him to a sharable/syncable format on his notebook - probably in Google Docs or Google calendar.

He basically wants the format of a spreadsheet, in a syncable calendar format – time of day doesn’t matter, he just wants to be able to click on a day in the calendar and be presented with the spreadsheet template he’s created and the jobs for that day.

The ideal setup would be that he was able to import his spreadsheet from Google Docs directly into Google calendar – and each day would be a fresh copy of the template.

Google Docs is all good for what he wants apart from the calendar aspect – it’s too difficult for him to navigate between dates – and each new day would mean creating a new tab with that date on it – not efficient enough.

If anyone has any bright ideas on how to get this to work – or knows of another way please do let me know, I’m rather stuck on this one!

Thanks. :)

25-08-2010, 05:21 PM
Looks like you can do it in reverse - Calender into a spread sheet Instructions (http://www.ehow.com/how_6453440_create-calendar-linked-spreadsheet.html)

Using MS products - I personally Use Onenote as a daily calendar, and you can link spreadsheets to that easy enough, also use sharepoint workspace to share/ allow updating from various PC's ( When I'm to lazy to walk inside to make an adjustment):D

26-08-2010, 09:39 AM
Thanks Wainui that looks very promising.


kahawai chaser
26-08-2010, 10:30 AM
Maybe try online collaboration projects/tasks like the free Many Moon for tracking projects, which integrates with Google Calendar, Google Docs and I think Google Apps. Reviews at Digital Inspiration (http://www.labnol.org/software/google-project-management/12840/) and App Appeal (http://www.appappeal.com/app/manymoon/).

Their are others like Zoho projects (http://www.zoho.com/), Office live workspace (http://workspace.officelive.com/en-NZ/), and base camp. (http://basecamphq.com/)