Title: SoM
1SoM Lab Bench Count
Prepared by Office of Facilities Planning
Management
Vivian Jones Tim Gadus
2(No Transcript)
3What is a lab, that is the question
Professor, a lab is a room used primarily for
laboratory experimentation, research or
training in research methods or professional
research and observation and is coded Room Type
251.
4I have an offer letter for a new Faculty Recruit,
and the recruit is asking how many lab benches
will they have. Where can I find that
information?
53 Benches Alway (dry lab)
2 Benches CCSR (wet lab)
2
1
2 Benches 800 Welch (wet lab)
1 Bench Beckman (wet lab)
2
1
1
6(No Transcript)
7What are the Bench Counts used for?
Department Space Planning Faculty Recruitment
Planning Off Campus Needs SoMs Facility Master
Plan Operating Budget Background Building
Capacity
8Who Uses the Bench Counts?
9What are the current Bench Counts?
10What About Department Bench Counts?
11How Do I Update Bench Counts in iSpace?
- Open two Browser windows
- - iSpace (iSpace - ispace.stanford.edu)
- - Building Search Page
https//maps-secure.stanford.edu/sims/building/bui
lding-search.cfm - In the iSpace window on the Advanced Search page
search by Parent Org., or Division org. code,
Room Type 251 and Most Recent time period. - In the Building Information Page window, enter
Building number based on search result from 2
above. - In the iSpace window, open the room record. If
there is no bench count on the Room Detail Page,
click on the Maintain Current Room Attributes
link. - In the Building Information Page window, count
the number of benches in the lab. - In the iSpace window on the Edit Attributes page,
add the bench count to the Benches field
121. Open two Browser windows -
iSpace - Building Search
132. In the iSpace window on the Advanced Search
page, search by Parent Org., or Division org.
code, Room Type 251 and Most Recent Time Period
14(No Transcript)
153. In the Building Information Page window, enter
building number or name, or use the pick list.
163. and open the Floorplans link
173. and select the appropriate floor
183. the floor plan displays each Research Lab
with built-in case work in green
193. zoom in and count the benches.
1
2
3
4
5
6
7
8
9
10
11
204. Click back on the Room Detail Page
21and click the Maintain Current Room Attributes
to add Bench count.
22and click here to return to search result and
continue with the next room record update.
Add the bench count here.
11
23Repeat the process with your next lab !
24Reporting Bench Counts Using ReportMart
1. Login to Reportmart and click on the word
Browse to display ReportMart reports
25(No Transcript)
263. Select the Space Management folder 4. Select
the folder named Space Coordinator 5. Select the
Download Report
3
4
5
27Under the Primary Search Criteria select
Search by Dept (Org) Parent Org. (Tree) Search
by Room Type Click Process Query
28(No Transcript)
29Select the Rollup Level number, in this case
there is only level 4
30Select the Room Type 251
31Select the Room Status. The room status for
Bench Counts will always be Open
32Double click on the default Start Date
33Double click on the default Stop Date, then click
on Process Query
34The query is completed. Click the OK button.
35In the Selections box, click on the Attributes Tbl
36The Attributes Table is now displayed in the
center of the screen.
37Reportmart displays the Room ID, Bldg. Name, Room
Type, Org ID and Benches.
38Export the results to your desktop
39The data is now in Excel to sort, arrange or even
create a pivot table.
40Timeline We are asking all SoM Space Coordinators
to complete this process by February 24th, 2006.
This data will be most valuable for the SoM
Master Plan that is being developed for the SoM
Institutes and new science building.
THANK YOU!
41?