Now that all the pieces of the puzzle are starting to connect with each other, some pretty cool mashups can be built. Here is one courtesy of Eric Ly from Presdo, based on an idea originally suggested by one of our friends at Google: an Agenda Heat Map, showing the popularity of sessions based on actual user scheduling. As attendees to the Office 2.0 Conference are adding sessions to their Google Calendar, Presdo is fetching the data (anonymously), and feeding it to a Google Spreadsheet, which cells' colors are based on the number of attendees scheduled to attend any particular session. It's interesting to see that out of 400 attendees who received an account on Google Apps on Monday, more than 50 were already using it by Tuesday. We wil publish a revised heat map later tonight. In the meantime, sessions having less than 10 scheduled attendees should really start pimping themselves through blog posts on the conference's website...

Close to 400 Google Apps accounts on the office20.com domain name have now been created and shared with their owners. To do so, we synchronized our RegOnline attendee database with our Salesforce.com instance, exported an attendee list from Salesforce.com into a .csv file, imported the file in Google Spreadsheet, randomly generated temporary passwords using the RANDBETWEEN() function, exported the updated attendee list into another .csv file, and created the accounts in Google Apps using the bulk upload function (very handy). Once all the accounts had been created, we created security tokens for each and every one of them to be used by the Presdo scheduling application.

The final step was to send an email to every attendee with their login and password. To do so, we enlisted the help of Raju Vegesna and his team at Zoho, and built a little application with Zoho Creator. It worked, and tonight Google Apps can claim a few more happy users. Many thanks to all involved — this part of our Office 2.0 Setup is working like a charm!

If you're attending the Office 2.0 Conference, please use this office20.com Google Apps account to do as much as possible during the event, from sending emails to scheduling meetings (instructions coming soon). This is an integral part of our experiment, and the more active participants we get, the better. Also, if you cannot make it to San Francisco but would like to participate in the experiment nonetheless, please send an email to registration@office20.com for a free Google Apps account on the office20.com domain name.

Our goal this year is to provide a fantastic online experience to all our attendees, for both the ones who can make it to San Francisco, and the ones who can't. One part of the challenge is to provide a community website that can be used before, during, and after the conference, for attendees to network and get the most out of their participation. In that respect, Jive Software's Clearspace is doing wonders, with already a dozen active blogs hosted on the site. Another part is to provide the right collaboration tools for attendees to schedule meetings and interact in real time. This is especially important now that we decided to organize the Office 2.0 Launchpad, and must provide the appropriate demo scheduling system for it. On that front, I've got some good news (for a change).

Today, Google gave us 1,000 accounts for Google Apps, hosted on the office20.com domain name. What this means is that all our physical attendees — plus several hundred online attendees — will get a full Google Apps account, with email, chat, calendar, docs, and sites. At $50/user, that's quite a gift, so please let me extend a warm "thank you" to the Google Apps team. You guys and girls rock!

So, how will we use Google Apps during the conference? Well, the first application will be for scheduling meetings. Since there is no way to integrate with everyone's existing calendar seamlessly, we might as well take advantage of the fact that we have a captive audience and know what our attendees are up to on September 3-5 (attending the conference, what else?), and give them an empty calendar to fill up with plenty of demos and meetings. We're also working with Presdo to make the scheduling process even easier. Another application will be to gather feedback from attendees on all our sessions, and provide some real-time heat maps for them. Yet another will be to provide an easy way for attendees to exchange virtual business cards, even though we're not exactly sure how we'll put it together — ideas welcome!

Now, let's take a step back, and look at what's really going on here. With Clearspace, EchoSign, Google Apps, Intacct, Presdo, Salesforce.com, and Veodia (Cf. Office 2.0 Setup), we're putting the foundations for an enterprise IT system that will be used by up to 1,000 end-users scattered around the world, including Groupware, ERP, CRM, Portal, and all the bells and whistles to make it überly sexy, all in one month, with no full-time staff... That's right: a dream enterprise IT system built in one month by part-time amateurs, for the cost of one-year salary of your typical IT guy (if we had to pay for it all)... And make no mistake, we're not talking about an ugly patchwork of standalone applications that do not talk to each, we're building a fully integrated system with single sign-on across the board, and processes that can span four or five applications seamlessly (using Intalio when things get a bit hardcore). If anyone needed proof that Software as a Service works, here is a perfect use case for it.

This Office 2.0 Setup will become our platform for years to come. We will continue documenting it's build-up, and keep improving it year after year, reporting on new integrations developed by our partners, and building some ourselves where they are missing. Let the fun begin!