Transcript Document

EPICS – Habitat For Humanity
Design Review Presentation
7/16/2015
1
Introduction

Team is divided into two subteams
– Architecture / Web Team
• Point of sales database
• Volunteer construction tutorials
– Energy Team
• Setback thermostat analysis
• Solar powered attic fan
7/16/2015
2
Introduction

Resale Store’s Point of Sales Database
– Requested by HFH Resale store
– Implemented in Microsoft Access
– Bar Code System to be added to database

Construction Tutorials
– Included in EPICS HFH Web Project
– Increase effectiveness of HFH volunteers
7/16/2015
3
Introduction

Setback Thermostat Analysis
– Attempt of energy team to decrease
energy usage

Solar Powered Attic Fan
– Idea from previous failed project
– Attempt to decrease energy usage
7/16/2015
4
Point of Sales Database
Functional Specifications

Problem
– No efficient way of keeping track of the donors of the items in
the resale store and products that are in the resale store
– When item is needed Habitat has to look through the store to
see if they have the item
– No way of keeping track of prices of products

Costs
– Very time-consuming and is the only solution they have right
now
– No audit of donors and history of what is sold
– Prices are kept in a record book
7/16/2015
5
Point of Sales Database

Solution
– Database that will allow the user to enter information, query,
and print information about the products in the resale store
and the donors of items in the resale store
– Provide a tool which will organize and manage information
efficiently for Habitat for Humanity

Benefits
– Simplifies the process of organizing and maintaining the
resale store
– Reduces the time needed to find information about a product
in the store
7/16/2015
6
Point of Sales Database
Technical Specifications

Five tables within a Microsoft Access database
–
–
–
–
–
7/16/2015
Donor
Invoice
Product
Product Type
Sold Item
7
Point of Sales Database

Queries
–
–
–
–
–
–
–
–
–
7/16/2015
AllDonors
AllInvoices
AllProdTypes
AllProducts
SearchDate
SearchDonorID
SearchInvoiceNum
SearchProdID
SearchProdType
8
Point of Sales Database

Forms (to add information into the database)
–
–
–
–
–

AddDonor
AddInvoice
AddProduct
AddProductType
AddSoldItem
Reports
– SoldItem (allows the user to print out information about a
product that was sold at the resale store)

Menu (Add information, search, or print reports)
7/16/2015
9
Point of Sales Database
7/16/2015
10
Point of Sales Database

The relationship between the five tables
Product
SoldItem
ProdID
ProdType
DonorID
ProdDesc
ProdPrice
ProdCond
ProdID
InvoiceNum
Invoice
Donor
DonorID
FirstName
LastName
Line1
Line2
City
State
ZipCode
Phone
7/16/2015
ProductType
ProdType
TypeDesc
InvoiceNum
Date
TotalSale
11
Point of Sales Database

Interface with Visual Basic and Bar Code
Scanner System

End Users
– Will be the people working at the resale store of Habitat
for Humanity
7/16/2015
12
Bar Coding System

Use of Visual Basic Required

Use of Bar Coding Software Required

Use of Bar Code Scanner Required
7/16/2015
13
Bar Coding System

Visual Basic used for scanner
– VB code is used to read in the data from the
bar-code scanner

Visual Basic used to search for Data
– VB code is used to look through MS Access for
data entries

Visual Basic used for display
– VB code will then display the entry using
Access
7/16/2015
14
Bar Coding System

Competitors

Strengths

Weaknesses
7/16/2015
15
Bar Coding System

Handheld Charge Couple Devices

Handheld Lasers

Handheld Wireless
7/16/2015
16
Bar Coding System

Handheld CCD’s
– Only Choice

Handheld Lasers
– Not Cost Effective

Handheld Wireless
– Possible Future Use
7/16/2015
17
Bar Coding System

Charge Coupled Device –
SCCD26
– Cost Effective to Laser
– Reads more than 12
symbologies
– 3.2in width window
– 100 scans/sec
– Keyboard Wedge interface
– 0.36lb
7/16/2015
18
Bar Coding System

Charge Coupled Device
SCLR17
– Trade off at 45 scans/sec,
but……
– Reads up to 11.8” away
– Broad reading width – up
to 150mm
– All in one built in decoder
– Keyboard wedge interface
7/16/2015
19
Bar Coding System

Bar Code Labeling
Software
– Visual Basic 6.0
– Compatible with MS
Access
– 11 symbologies
– Active X Controls
7/16/2015
20
Solar Powered Attic Fan

Overview of Requirements for the Solar
Panel

4 main parts of the Solar Panel Project
–
–
–
–
7/16/2015
Construction of Macro Design
Design of Tracking System
Design of Charge Controller
Testing and Analysis
21
Solar Powered Attic Fan

Main Components of the Solar Powered
Fan
–
–
–
–
–
7/16/2015
Solar Panel (10 Watt DC)
Charge Controller (our design and build)
Battery (Deep Cycle 12VDC)
Fan (14 inch DC 550 CFM)
Tracking System (our
design and build)
22
Solar Powered Attic Fan
Circuitry Design - Tracking System
and Charge Controller
 Tracking System

– 6 various light sensing diodes
– Diodes Summed and compared
– Relays tripped to run motors when
center diodes are less than outside
ones.
7/16/2015
23
Solar Powered Attic Fan

Charge Controller Circuit
7/16/2015
24
Solar Powered Attic Fan

Charge Controller Parts
– Initial Charging
– Comparator U2
– LEDs
– Construction
– Use
7/16/2015
25
Conclusion

Point of Sales Database
– Currently involved in its first test run
– Bar Code System design to be finalized and
tested next semester

Solar Powered Attic Fan
– All but tracking to be finalized this semester
– Testing of design without tracking system to
be completed next semester
– Tracking system to be designed next semester
7/16/2015
26