Overview

How it Works

Summary

Short discussion of goals
Introducing statistical analysis
Interpreting results (maybe should be a separate web page - yes)

How it works:

Alerts are generated within Mango
An email with the alert goes out to the designated Google Group - a separate Group per building - and built under the building Google User account (not built under my account).
Each email is an Alert post to the Group
I created a designated email for posting to each Group. For WSP it's wsp197-sibley-group@irisbuildings.com (you can see it below).
lerts display by date (another option is by "relevance" which applies only when you do a Search for Messages)
Each day I receive an Abridged list of the previous days alert posts - but there are other options...

Update Options

User email options

No email
Abridged email
Digest email
All Email

Posting Permissions

Default group policy
Override: member is allowed to post
Override: member is not allowed to post
Override: member's posts are moderated

Today's Topic Summary

Here's what the Abridge option looks like.

Notice alerts are first listed at the top of the email.

Google Group Account

You have a choice of building the Group under your personal account or directly in the building account.

If the Group is built in your personal account, then add the building User account and make it an Owner too.

In this case I was logged in as wsp197-sibley@irisbuildings.com. (This means you will, for practical purposes, you need to use a separate browser to avoid being logged out of you current browser's Google account.)

My Groups

Clicking on My Groups produced the following. Notice that the account WSP197... has only 1 group. Further it is not subscribed to any other Groups (but it could be).

Browsing All Groups

Clicking on Browse All produces a list of all the groups you are participating in (that is, are a member of)

Continuing...

Click on the post name to see the details. Or click on "View all topics" to go directly to all Alert posts.

Alerts Web Page

I created a dedicated web page for Alerts. Click on the air handler of choice - which is a link to only those posts.

Easy To Build Links

It's easy to build links in New Sites. I was able to capture the link that did a search for a given topic - in this example "AHU-02", and make it a URL link in New Sites (above). The end result selects only those Alerts of interest - without the complications of using the Group.

Alert Details

I also created a Details tab under Alerts to quickly view all the Alerts

All Alerts

Clicking on it brings up all the Alerts

Energy Optimization

I'm still working on Energy Optimization Alerts. Basically all Alerts, of any type, are collected into a single Group. You find the type of alert (or report) of interest by doing a Search (These links don't work yet - I still need to write some Mango alerts that look at energy usage issues.)

Reports

Reports are embedded PDFs. Multiple PDFs (or any files) can be quickly embedded.

Other Reports

I also added some other reports at the bottom.

Trane Reports - WHOOPS

I also demo'd how to present Trane Reports (which I'll put into SLP).

I even included the Trane videos (which were attach to Jeff Seewald's email to me yesterday).

Well, take a look at it so far with this link. It isn't possible (yet) to completely hide the Google Sites.

Conclusions

Some conclusions:

Google New Sites is VERY nice - easy and fast way to build a custom site. Once the updates are available it will work even better.
Google Groups handles virtually all of Alert routing, subscribing, etc. - VERY nice (but it took awhile to figure it out - still it does about everything you need)
By having a separate Google account for each building, it's possible to isolate customer buildings so that we can use outsiders to build the sites.
Because Google Sites supports multiple users simultaneously editing the same site our productivity should be pretty decent.

The only issue is how to deal with Mango spreadsheets. Here's how I think we can handle them.

Mango spreadsheets, like any other Alert, are emailed to Google Group for that building. That is, there is only a single repository for all spreadsheets and alerts.
Most users won't want to see the details of the spreadsheet - so they won't receive them when they query by air handler, for example. Of course they can go to the repository and view them as they want.

Subscription Options

The clever part is that Group allows a user to subscribe to a given Topic. Below I've clicked on the tiny downbutton just under "scheduled" to pop up a list of options. One option is "Email updates to me". This is pretty cool in that any user (need a Google account, but...) can also receive the same report at almost the same time it is delivered to the Group inbox.

Viewing Attachments

I like the email attachment idea because it's easy to see and use it (but without the graphics operational - they only show up when run in Excel)

Email Attachments

Still, clicking on the image brings up the SS within a window (at least when running gmail).

If you need a more detailed view then open the image in Excel. But most of the time you can just scroll across to see what's going on.

Report abuse