I work in a warehouse and I'm kind of in charge of inventory tracking on everything there (the guy who supervises me is supposed to do it, but he's a kindly old man who's pretty much lost with computers, so he tells what we need to do and I get it done). We've been using Microsoft Office 2010 on a crappy little Windows 7 machine (32-bit, just 1GB of RAM), and it's served us well so far. We actually had a much nicer all-in-one before, but it mysteriously died on us...
Anyhow, we've been gradually pushing into using Google Docs, but the way we're doing so right now is pretty inefficient. How we usually do it is that at the end of the day I save the inventory as a whole new spreadsheet, and email a copy to all relevant people. This means a whole new inventory file is created every day. The files are tiny (relatively speaking) so it doesn't really matter. We've been doing it for about 8 months and we still haven't reached one GB (I think...) I did it this way so that in the event we screwed something up badly, and we had to go back to the way things were say... 15 days ago, I would be able to just pull up the file for that day.
I noticed that when Google Docs makes a change... the past version of it are gone. You can just click undo, undo, undo... forever until it goes back far enough, but that's a very crude approach and I don't know if it keeps really long term changes. Also sometimes it's nice to have today's inventory and last month's, and compare the two side by side. Is there a way to do what I've been doing offline with Excel? To have a Google Docs spreadsheet for every new day? I know Google recently added Google Drive, which gives us something like... 5 GB. That should keep us good with Cloud storage for at least 5 years. But yeah... I'm really not sure how to save as a new Doc. It's annoying because rather than replacing Excel we're now using both sets of inventories, which means I have to keep an eye on both of them. I used to be able to copy-paste the whole spreadsheets, but Google Docs has a 50 000 character limit on it's copy-paste... which severely limits my ability to transfer bulk changes from Excel to the Docs. As is I do this weird thing where I email myself the Excel sheets, then open then as a Google Doc spreadsheet, and copy-paste them onto the primary Doc that everyone uses.
It all feels kind of silly and redundant, rather than Google Docs helping simplify my work I feel like I'm doing the work twice.
Can I save Google Docs in such a way that I can go back and see what my file was like months ago. With pin-point day-to-day accuracy?