I created and have been using my Ottawa Grocery Price Book on Google Docs for a couple months now. It lets me keep track of the prices at different grocery stores around Ottawa. I also opened it up to anyone in the world who wanted to write in prices from their receipts, so we could create a full crowdsourced spreadsheet of prices across Ottawa.
There hasn’t been much participation, but I haven’t pushed it much either, so I’m not too sad about that. I use it and enter my own info into it, and it’s been a great tool for me. However, I did get sad about something that appeared there when I looked last night. Someone had changed all the store headings at the top, replacing the Ottawa stores with names I’d never heard of!
Luckily I could tell that not much if any of the prices had been changed, and I could remember the four main stores that I’ve been shopping at, so I changed it back. And then promptly locked the document.
I realized that there could be malicious people out there who could mess the whole thing up for everyone; and the thing that bugged me most was that I actually USE my pricebook, and losing it would really suck for me!
I don’t think it was a malicious person who made the edits this time–probably someone living elsewhere who wanted to set up their own price book, and ended up saving their changes to the master copy instead of making a new copy for their own use–but even that kind of error could really mess things up for me.
So in the interests of preserving my handy tool, I’m changing how the price book works. I’ve made it viewable, but not editable. What this means is that you are free to check out the price book, and even cut & paste it as a basis to create your own, but only I can enter in items and prices.
However, if you still want to contribute to the Price Book, you are welcome to scan your receipt and email it to me at frugalurban at gmail dot com. Then I will add the prices in myself when I have a chance. Just make sure your credit card number or any other identifying information is blacked out or removed!
If anyone has any ideas of how to make the Price Book a little more constrained, but still openly editable (maybe locking some fields? Using a Wiki model??) please comment below! I still think it could be a great tool, but I don’t want to jeopardize my own Price Book! I need it too much 🙂