Drawing on research she had done about the best way to set up user access on MOSS, she worked with the Van Andel Institute's server administrator, Russell VanderMey, to create Active Directory accounts which she could then bring into SharePoint. VanderMey created an external Active Directory domain that's not on the Van Andel Institute's network, yet provides Jeffries with a domain that she can use to create and maintain security for SharePoint users who are not Van Andel employees.

"With MOSS, the maintenance is so much easier because I created security groups for every level necessary on each page and sub-site and I created security groups within SharePoint," says Jeffries. "Now, when someone new joins, I go out to the external active directory site, I get their name and plug them into whatever site they need to belong to."

Jeffries adds that it now takes less than five minutes to provision access for users, because she doesn't have to drill through 30 sub-sites to maintain security.

SharePoint Key to New Submittals Process

In June, 2007, Fahrenkrug came to Jeffries with a new request. A new phase of the project had started—the submittal phase—and he needed technology to support it. During the submittal phase, architects and engineers create drawings which they release to subcontractors, who bid on the projects and create new, more detailed drawings. These documents then get sent back to the architects and engineers for review and approval.

"I thought this was a huge undertaking," says Jeffries of the submittal phase. "If we could get a solution for them using SharePoint, it would be huge."

Her first effort to use Microsoft Office SharePoint Server to automate the submittal process ran into complications. SharePoint's workflow didn't support the architects' and engineers' needs. They wanted to use a certain naming convention for .PDF files, and they didn't want users re-naming files. The problem, says Jeffries: SharePoint wants users to rename .PDF files after they've checked them out of a library and are ready to return them.

To fix this problem, re-coding SharePoint would take too much work and would complicate software updates and patches. So Jeffries wound up creating three separate sites—one called submittals out, where all specifications are uploaded for review; a coordination site, where the architects can review the contractors' changes and suggestions; and a third called submittals in, where the architects submit specs to the owner reps. She says creating three separate sites was much easier than customizing the software. The beauty of SharePoint is that it makes creating these sites a cinch, she says.

Setting up three separate sites also ensured that all of the versioning that needed to take place during each phase of the submittal process happened in the right site, and ensured that versioning was complete at each phase of the submittal process, says Jeffries. The sites went live on July 13.

Today, the Van Andel Institute has four SharePoint sites supporting the construction project, with 18 document libraries for each of the three submittal sites and 25 document libraries on the original SharePoint site used for the design phase of the project, says Jeffries. Each folder within each of the document libraries on the submittal sites can contain 100 or more documents. "The paperwork alone being maintained here is amazing," she adds.

The sites support 108 users and 200 or more gigabytes of storage according to Fahrenkrug.

Fahrenkrug estimates that the new building, which is expected to be complete late next year, is about 40 to 45 percent complete today. "It's right on schedule. It's on budget," he says. And that's due in no small part to SharePoint.

Says Campbell, "The fact that we used SharePoint for the submittal process will definitely keep us on track."