Week 4 Demo HFH - Purdue University
Download
Report
Transcript Week 4 Demo HFH - Purdue University
Design Review
Habitat for Humanity
April 1, 2003
July 17, 2015
Habitat for Humanity
Design Review
1
Introduction
Design Review
Project Teams will be presenting technical aspects of
their projects
Expert reviewers invited to review and give feedback
Tutorial
National Database
HEAT
Local Database
July 17, 2015
Habitat for Humanity
Design Review
2
Introduction
New Teams will be giving progress
presentations
Tot Lot
Energy Star
New Headquarters
Large Team
Each team will have 15 minutes including questions
Extra time at the end for questions
July 17, 2015
Habitat for Humanity
Design Review
3
Tutorial Team
Design Review
July 17, 2015
Habitat for Humanity
Design Review
4
Tutorial Team Members
Tim West
Ben Hopkins
Dean Kales
Joe Meyer
Dustin Robbins
John Hostetler
July 17, 2015
Habitat for Humanity
Design Review
5
Tutorial Team Objectives
To design & implement a set of national scale
multimedia tools for use by HFH to enhance
construction proficiency of volunteers
To create a set of standards and specifications
for the presentation of the construction tutorial
tools
To develop a template for future additions to
construction tutorial
July 17, 2015
Habitat for Humanity
Design Review
6
Proposed Tutorial Design
July 17, 2015
Habitat for Humanity
Design Review
7
National Database
Chris Costanzo
Dave Kristof
July 17, 2015
Habitat for Humanity
Design Review
8
Project Overview
This purpose of this project is to help HFH simplify their data
collection and reporting of surveys they issue.
Major specifications were to enter the data into an Access
database.
July 17, 2015
Habitat for Humanity
Design Review
9
Database
Relational Database used to connect user data with answers
to survey questions
July 17, 2015
Habitat for Humanity
Design Review
10
HTML Forms
These forms are how the data will be input by the user.
The main goal for the design of the html forms was simplicity.
I used an embedded table design to create the html forms so
they look exactly like the paper forms that are currently used.
July 17, 2015
Habitat for Humanity
Design Review
11
July 17, 2015
Habitat for Humanity
Design Review
12
July 17, 2015
Habitat for Humanity
Design Review
13
Database Connection
ODBC used to connect to the Access database
What is ODBC and Why use it?
PHP will be used to access and manipulate the form data, as well
as provide the necessary ODBC functions to connect with the
database.
Why use PHP?
July 17, 2015
Easy to learn, free source, lots of documentation.
Built in ODBC functions
Habitat for Humanity
Design Review
14
Form Data
The next design aspect was proper data collection.
Problem
Each question could either have one or more answer, this times 40
questions could lead to hundreds of individual variables.
How would the data stay separated?
Solution – Multidimensional Array
July 17, 2015
Habitat for Humanity
Design Review
15
Array Design
Array Name
Answer 1
Answer 2
Answer 3
…
Var[0][ ]
Var[1][ ]
Var[2][ ]
…
July 17, 2015
Habitat for Humanity
Design Review
16
HTML Code
<!-- TABLE START !-->
<TABLE border=0 size=90%>
<TR>
<td align=left>2.) Before your Habitat home purchase, how satisfied were you
with your life?</td>
</TR>
<TR>
<td align=left><input type="radio" name="var[1][]" value="Very
Satisfied">Very Satisfied</td>
</TR>
<TR>
<td align=left><input type="radio" name="var[1][]"
value="Satisfied">Satisfied</td>
</TR>
<TR><TD><BR></TD></TR> <!-- Space -->
</TABLE>
July 17, 2015
Habitat for Humanity
Design Review
17
Getting data from the array into the database
The next design decision would be inserting the data from the
array into the database with the help of loops.
Since I am working with 2 dimensions, I would need to use
embedded loops.
Luckily PHP has a built in array loop function called “foreach( )”
This function automatically iterates over each element of the
array in order.
July 17, 2015
Habitat for Humanity
Design Review
18
SQL commands to access the proper tables
Structured Query Language is used to communicate with a
database.
It is the standard language for relational database systems.
SQL statements are used to perform tasks such as update data
on a database, or retrieve data from a database. (insert, select…)
July 17, 2015
Habitat for Humanity
Design Review
19
SQL statement example
$sql="insert into Users (userid, answerid) values
('$_POST[userid]','$answerid')";
$result=odbc_exec($connect,$sql);
July 17, 2015
Habitat for Humanity
Design Review
20
Report generator
The last part of this piece of software will be the report
generator.
Now that we have the data in the database, we need a way to
query it out in a customizable way for the user.
The preliminary design will follow the website format of the
surveys.
Habitat mainly interested in finding out how many people
answered a certain question a certain way
July 17, 2015
Habitat for Humanity
Design Review
21
Conclusion
A lot has been accomplished considering the amount of people
who have worked on this project
I have learned many new skills pertaining to database
programming
Overcame many roadblocks throughout the design process
July 17, 2015
Habitat for Humanity
Design Review
22
Design Review
H.E.A.T.
April 1, 2003
July 17, 2015
Habitat for Humanity
Design Review
23
H.E.A.T.
Team Structure and Tasks
Timothy Butler – Rating System
Timothy Butler – Prospect File
Timothy Butler – ArcView GIS
Goal
Develop a feasible system that will help identify
substandard housing.
July 17, 2015
Habitat for Humanity
Design Review
24
Semester Timeline
July 17, 2015
Habitat for Humanity
Design Review
25
ArcView G.I.S.
What is it????
A system of computer software, hardware and data, and user
to help manipulate, analyze and present information that is
tied to a spatial location
How???
Layers of information
Roads
Arial Views
Regions
Specific Addresses
.
July 17, 2015
Habitat for Humanity
Design Review
26
Road Map Layer
July 17, 2015
Habitat for Humanity
Design Review
27
Road Data
http://danpatch.ecn.purdue.edu/~caagis/ftp/gisdata/data.html
July 17, 2015
Habitat for Humanity
Design Review
28
Key Relationships
Data
Relative vector coordinate
system
Themes
Map Locations
Manually position the theme
onto the location
Data
Map Locations
Data
Joining two tables thru address
matching
July 17, 2015
Habitat for Humanity
Design Review
29
Arial Images
Themes
July 17, 2015
Map Locations
Habitat for Humanity
Design Review
30
Regions
July 17, 2015
Habitat for Humanity
Design Review
31
Plotting Rated Homes
Currently – Address
Matching, Manual
Future – Address Matching,
Geocode Editing, Manual
Red dots – “D” houses
Blue dots – “C” houses
Yellow dots – Vacant lots
Green Box – Brown St. and
Cincinnati St., site of field testing
for rating system
July 17, 2015
Habitat for Humanity
Design Review
32
Integration Technique
Save the Prospected File as a delimited text for
compatibility.
Add the database.
Address Match the database to the Road Map
Update the legend
July 17, 2015
Habitat for Humanity
Design Review
33
Before and After
Before Integration
After Integration
July 17, 2015
Habitat for Humanity
Design Review
34
What to Expect???
1st Edition Copy
Documentation
July 17, 2015
Habitat for Humanity
Design Review
35
Local Database
Team
April 1, 2003
July 17, 2015
Habitat for Humanity
Design Review
36
Team Organization
Payam Farazi – Documenter
Matthew Imakyure – Programmer
Nicole Pater – Team Co-Leader
Anne Rendaci – Team Co-Leader
July 17, 2015
Habitat for Humanity
Design Review
37
Accomplishments This Semester
Purchased a new computer for the Restore that will be
capable of handling the database and it’s components
Completion of debugging the Visual Basic Code as well
as the addition of all forms and functions
Completion of relationships in the Access database
Completion of writing the User’s Manual
Visits and meetings with the ReStore management to
organize implementation
July 17, 2015
Habitat for Humanity
Design Review
38
Current Status of System
Point of Sale database including the following:
Calendar functions
Alert notifications
Product and Donor information
Format of product inventory
Program back-up
Secure login and limited access
Total Sales and Product information
July 17, 2015
Habitat for Humanity
Design Review
39
Visual Basic User Interface
July 17, 2015
Habitat for Humanity
Design Review
40
User Options
July 17, 2015
Habitat for Humanity
Design Review
41
Main Menu
July 17, 2015
Habitat for Humanity
Design Review
42
“Add” Tab
July 17, 2015
Habitat for Humanity
Design Review
43
“Calendar” Tab
July 17, 2015
Habitat for Humanity
Design Review
44
“Add Reminders” Form
July 17, 2015
Habitat for Humanity
Design Review
45
“Reminders” Popup
July 17, 2015
Habitat for Humanity
Design Review
46
Relationships within our Database
July 17, 2015
Habitat for Humanity
Design Review
47
User’s Manual
July 17, 2015
Habitat for Humanity
Design Review
48
ReStore
Under new management: Jacob Mathis
Has reorganized store to make entering
inventory easier
Discussions have prompted functional additions
to system as well as removals
Set date for implementation: April 10 – 24
Jacob has agreed to be the User’s Manual editor
July 17, 2015
Habitat for Humanity
Design Review
49
Semester Continuity
April 10 – 24:
Install computer with implemented point of sale
database
Edit User’s Manual
Input inventory into database
Train workers and volunteers
July 17, 2015
Habitat for Humanity
Design Review
50
Semester Continuity
April 24 – end of semester:
Maintenance and follow-ups of point of sale
database
Begin design stages of scanner and cash register to
be completed next semester
July 17, 2015
Habitat for Humanity
Design Review
51
Tot Lot Team
Habitat for Humanity
Casey Collins
Shahreen Hossain
July 17, 2015
Habitat for Humanity
Design Review
52
Bristol Park
Background Information
Located within Bristol Subdivision
Lot Owned by Habitat for Humanity
Park Profile
Lot Dimensions: 40’ x 100’
Passive Environment
Low Maintenance
July 17, 2015
Habitat for Humanity
Design Review
53
Concept A
Large Open Space . Small Planting Space . Economical Gazebo Structure
Concrete Entry Walk
July 17, 2015
Habitat for Humanity
Design Review
54
Concept A – Plant Images
Boxwood
Fothergilla
English Ivy
Black-eyed Susan
July 17, 2015
Habitat for Humanity
Design Review
55
Concept A
Cost Estimate
Budget: $5,000
Estimated Value: $4,450
Key Additions:
Large open space
Economic quality of
gazebo
Moderate quantity of
plants
Standard quality of
amenities
July 17, 2015
PLANTS
Size
Shrubs
Boxwood (ea)
15-18"
Fothergilla (ea)
24-30"
Perennials
Black-Eyed Susan (Spaced 10"x10")
Container 1
Groundcover
English Ivy (ea) Bare root, spaced 8"x8"
Sod
Shade Mix (thousand sqft)
AMENITIES
Walkway
Concrete (lf)
4" thick paving, 4" gravel base
Bench (ea)
Park, precast, concrete with
backs, wood rails, 4' long
Trash (ea) Redwood Slats, painted
STRUCTURES
Gazebo
Wood or plastic, footers
minimal detail
TOTAL
Habitat for Humanity
Design Review
Price
Quantity
Total
$
$
14.00
23.00
14
80
$ 196.00
$ 1,840.00
$
6.00
127
$ 762.00
$
0.60
81
$
48.60
$
8.00
2.833
$
22.66
3'
4'
8' long
$
4.12
$
5.50
$ 385.00
3
9
1
$ 12.36
$ 49.50
$ 385.00
22 gal
$ 134.00
1
$ 134.00
$ 1,000.00
1
$ 1,000.00
$ 4,450.12
56
Concept B
Moderate Open Space . Moderate Planting Space
Exceptional Gazebo Structure . Concrete Pavers
July 17, 2015
Habitat for Humanity
Design Review
57
Concept B - Plant Images
River Birch
Boxwood
Hawthorn
English Ewe
English Ivy
July 17, 2015
Arborvitae
Burning Bush
Habitat for Humanity
Design Review
Hydrangea
Fothergilla
58
Concept B
Cost Estimate
Budget: $10,000
Estimated Value: $6,689
Key Additions:
Average open space
Average quality gazebo
Average quantity of plants
Better quality of amenities
PLANTS
Canopy
River Birch (ea)
Ornamental
Hawthorne (ea)
Shrubs
Boxwood (ea)
Burning Bush (ea)
Fothergilla (ea)
Ewe (ea)
Hydrangea (ea)
Arborvitae (ea)
Groundcover
English Ivy (each bare root)
Bare root, spaced 8"x8"
Sod
Shade Mix (thousand sqft)
AMENITIES
Walkway
Concrete Pavers (sqft)
6"x6"x1.5" with joints
Urn (ea)
Bench (ea)
Park, precast, concrete with
backs, wood rails, 4' long
Trash (ea)
Redwood Slats, painted
STRUCTURES
Gazebo
Average quality wood, concrete base,
average detail
TOTAL
July 17, 2015
Habitat for Humanity
Design Review
Size
Price
Quantity
Total
6-7'
$ 165.00
1
$ 165.00
2-2.5" $ 110.00
1
$ 110.00
15-18"
18-24"
24-30"
18-24"
24-30"
3-4'
$
$
$
$
$
$
14.00
10.50
23.00
17.00
15.50
49.95
51
6
13
25
2
14
$
$
$
$
$
$
-
$
0.60
383
-
$
8.00
1.821
714.00
63.00
299.00
425.00
31.00
699.30
$ 229.80
$
14.57
$
3.00
3'
$ 300.00
8' long $ 385.00
145
$ 435.00
2
2
$ 600.00
$ 770.00
22 gal $ 134.00
1
$ 134.00
$ 2,000.00
1
$ 2,000.00
$ 6,689.67
59
Concept C
Moderate Open Space . Large Planting Space
Grand Gazebo Structure . Concrete Pavers
July 17, 2015
Habitat for Humanity
Design Review
60
Concept C – Plant Images
Hawthorn
Boxwood
Fothergilla
July 17, 2015
River Birch
Serviceberry
English Ewe
Hydrangea
English Ivy
Pachysandra
Habitat for Humanity
Design Review
Lilac
Burning Bush
Black-eyed Susan
61
Concept C
Cost Estimate
Budget: $15,000
Estimated Value: $13,179
Key Additions:
More mature trees
Better quality gazebo
Greater quantity of plants
Greater quantity and better
quality of amenities
PLANTS
Canopy
River Birch (ea)
Ornamental
Hawthorne (ea)
Serviceberry (ea)
Shrubs
Boxwood (ea)
Lilac (ea)
Burning Bush (ea)
Fothergilla (ea)
Ewe (ea)
Hydrangea (ea)
Perennials
Black-Eyed Susan (spaced 10"x10")
Groundcover
English Ivy (Bare root, spaced 8"x8")
Pachysandra (Bare root, spaced 8"x8")
Sod
Fescue (thousand sqft)
AMENITIES
Walkway
Concrete Pavers (sqft)
6"x6"x1.5" with joints
Urn (ea)
Bench (ea)
Park, precast, concrete with
backs, wood rails, 4' long
Trash (ea) Redwood Slats, painted
STRUCTURES
Gazebo
High quality wood, concrete base,
interior seating, finely detailed
TOTAL
July 17, 2015
Habitat for Humanity
Design Review
Size
Price
Quantity
Total
7-8'
$ 235.00
1
$
235.00
2.5-3"
5-6'
$ 145.00
$ 75.00
3
2
$
$
435.00
150.00
18-24"
24-30"
24-30"
24-30"
24-30"
24-30"
$
$
$
$
$
$
16.00
16.50
11.50
23.00
20.00
15.50
48
2
1
167
60
3
$ 768.00
$
33.00
$
11.50
$ 3,841.00
$ 1,200.00
$
46.50
Container 1 $
6.00
180
$ 1,080.00
-
$
$
0.60
0.60
225
273
$
$
135.00
163.80
-
$
10.00
1.517
$
15.17
3'
8' long
$
2.00
$ 500.00
$ 385.00
14
0
2
2
$
28.00
$
$ 1,000.00
$ 770.00
22 gal
$ 134.00
2
$
$ 3,000.00
1
$ 3,000.00
268.00
$ 13,179.97
62
Future Outlook
Revise Conceptual Designs
Finalize Cost Estimates
Further research of various costs
Begin Construction Documents
Make adjustments to fit clients needs
Detailed drawings of site work, construction plan,
planting plan, and details
Review Construction Documents
July 17, 2015
Habitat for Humanity
Design Review
63
Questions?
July 17, 2015
Habitat for Humanity
Design Review
64
HFH Energy Star Team
Brian Wink
Pete Batule
Tom Shaw
7/17/2015
Habitat for Humanity
Design Review
65
Overview
Team Organization
Problem Identification
Road Blocks
Team Objective
Approach
Project Planning Schedule
July 17, 2015
Habitat for Humanity
Design Review
66
Problem Identification
What will it take to standardize home efficiency?
Generic Construction Plan (Bill of Materials)
Contains recommended material properties
Recommended construction techniques
Organized Approach to standardize efficiency
July 17, 2015
Energy Star program
Habitat for Humanity
Design Review
67
Team Objective
Determine the feasibility of standardizing home
efficiency through the Energy Star program
Reasoning:
Qualify Habitat affiliates for the Asset Recovery Program
Want to sell the mortgages
July 17, 2015
Habitat for Humanity
Design Review
68
Roadblocks
Vectren Corp. promised 10 inspections
Original plan depended on 10 inspections
Now have only promised 1
Solicited donations of inspections
Many companies declined
Instructed to discontinue this effort
Re-focused semester objectives and tasks
July 17, 2015
Habitat for Humanity
Design Review
69
Approach
Completed Tasks
Purchase and Learn the REM/Rate software
Initial analysis of average Habitat home
Upcoming Tasks
Establish BOM for an average habitat home
Analyze average Habitat home using software
Facilitate inspection of 1 habitat home
Recommendation to Doug Taylor
July 17, 2015
Habitat for Humanity
Design Review
70
Initial Analysis
Use REM/Design Software
Based on existing BOM
EPICS-HFH online construction resource
Contained some construction material properties
Estimated other material properties and equipment sizes
Generated energy efficiency reports
Determined major energy usage
July 17, 2015
Habitat for Humanity
Design Review
71
Initial Analysis Results
Example:
Annual Energy Cost ($/yr)
Heating 848
Cooling 136
Water Heating 314
Lights & App 348
Total 1646
July 17, 2015
Habitat for Humanity
Design Review
72
Update Bill of Materials
Current BOM is >2 years old
Update the list with :
Commonly used construction material properties
Commonly used mechanical equipment (size and efficiency)
Special construction techniques
Utility Rates
July 17, 2015
Habitat for Humanity
Design Review
73
Estimated Analysis
Use the updated BOM
Enter properties into REM/Design
Estimate energy efficiency of a Lafayette home
First useful analysis to present to Doug Taylor
Will only provide an estimate
Will not be based on an existing home
July 17, 2015
Habitat for Humanity
Design Review
74
Home Inspection
Vectren Corporation
Mike Emge, Inspector
Volunteered to conduct tests (1 house - Evansville)
Conduct blower door test and duct leakage test
Verify equipment SEER ratings and sizes
Verify construction material properties (visually)
July 17, 2015
Habitat for Humanity
Design Review
75
Recommendation
Include results of:
Updated Bill of Materials
Estimated Analysis (using updated BOM)
Inspection of Evansville home
Recommend course of action
Pursue Energy Star Label (or not)
or
Pursue a standardized Bill of Materials
Include minimum recommended properties
July 17, 2015
Habitat for Humanity
Design Review
76
Project Planning Schedule
July 17, 2015
Habitat for Humanity
Design Review
77
Questions?
July 17, 2015
Habitat for Humanity
Design Review
78
New Headquarters
Progress Report
Mike Schilz
Stacie Woodrum
Rich Villanueva
July 17, 2015
Habitat for Humanity
Design Review
79
Semester Goals
Create an initial feasibility report
Find out what Habitat for Humanity’s needs were in
a new headquarters
Research main components of headquarters and
associated costs
Find building purchase costs and operating costs
Create possible layout for new headquarters
Obtain blueprints and store layouts
Use AutoCAD to create a virtual layout
July 17, 2015
Habitat for Humanity
Design Review
80
Habitat for Humanity’s Wants
Headquarters and Regional Support Facility
Large commercial building
Local Affiliate Offices
Regional Affiliate Offices
Training Center
Conference Room with Kitchen
Storage Warehouse
Pre-Fab Building Site
Re-Sale Store
July 17, 2015
Habitat for Humanity
Design Review
81
Initial Research
Purchase Costs of Large Commercial Buildings
Church in Illinois purchasing a Wal-Mart building
58,512 ft2
$1.2 million
Re-building Costs
Demolition Analysis and Cost
Preliminary Remodeling Analysis
Monthly Operating Costs
July 17, 2015
Habitat for Humanity
Design Review
82
Initial Research
Costs and Options
Lighting
Office Lighting
Warehouse lighting
HVAC systems
U.S. Department of Energy Report
Energy Consumption Characteristics of Commercial
Building HVAC Systems
July 17, 2015
Habitat for Humanity
Design Review
83
Initial Research
Reconfigurable Dividing Walls
provide versatility to usable space
several options
July 17, 2015
Tall Walls
Portable classrooms and partitions
Relocatable walls
Habitat for Humanity
Design Review
84
Remaining Tasks
Compile research into a feasibility report
Design layout configuration for headquarters
AutoCAD for design
Based on commercial building layouts and blueprints
Complete final draft of feasibility report and
layout this semester
Next Semester
Refine feasibility study
Further develop possible layouts using Pro/E
July 17, 2015
Habitat for Humanity
Design Review
85
Questions
July 17, 2015
Habitat for Humanity
Design Review
86