Web Development

Michael Higgins

About Me

Projects

Deploy on server

Create visuals for data

Improve data re-formatter

Create Database for schools electrical mapping

Tools

Python - Programing language

Pycharm - IDE use for programing and testing

Django - Web framework

PostgreSQL - Database

Pandas - Data analysis Library

Apache - Web server

Deploying the Server

Deployed on apache

Developed in Django

Metasys Data

Pre Formatted data

Post Formatting Data

Creating Graphing

Pyplot -

Improving Reformatter

Electrical Mapping

Problem

Solution

Solution

Future Features

Maps of closet and panel locations

Room and equipment mapping

TRYING TO WRITE A HISTORY TEXTBOOK USING INCOMPLETE AND FAULTY SOURCES

MAPPING THE HIGH SCHOOL

Jordan Altaffer

SOME BACKGROUND• Last summer, we uncovered potential

opportunities through manual data analysis:

Energize Andover Summer 2016 - Jordan 17

• Gymnasium Fan ~$100/day• Collin’s Center Air Conditioning ~$200/day

A NEED FOR CHANGE

Energize Andover Summer 2016 - Jordan 18

School Days 6AM-8PMNight Time, Weekend, Holidays

First Efforts To Find a Problem

Energize Andover Summer 2016 - Jordan 19

• We used a Python script to help parse the 200,000 line csv files that Metasys exports into more manageable 200 line csv files.

ROADBLOCKSchool directories made it nearly impossible to identify source.

Energize Andover Summer 2016 - Jordan 20

UPDATING ROOM NUMBERS AND DECODING THE OUTDATED PLANS

• The school plans and circuit directories have old room numbers that no longer match current room numbers.

• In order to follow the directories and understand the way the school is wired, we had to link the past to the present by linking old numbers to new numbers.

Energize Andover Summer 2016 - Jordan 21

The Table

SOLVING THE POORLY LABELED DIRECTORY

• Naming convention of panels was confusing, and structure was unclear..

• I assembled a map.

Energize Andover Summer 2016 - Jordan 22

HARVESTING DATA• Mike and I wrote a piece of software that

functions as a database and organizes the different aspects of the school.

Energize Andover Summer 2016 - Jordan 23

• This program will facilitate maintenance of our system and pave the way for innovation.

Opportunities With Night-Time Usage

Ajaykarthik AnanthakrishnanFrank Cai

Who Are We?

Last Years Findings got us Thinking...

Can we be smarter about our night-time energy usage?

What Did We Analyze?8/4/15 - 4/18/16Seasonal DataOur Tool bag

Python

Data by season

Recommendations and ImpactsAdditional MetersLocate devices to turned off “when not in use”

HVAC

Timothy Liu

HVAC System

How it works

Andover High School Univent

Idea!!

Create $/hour display on HVAC systems to understand costs.

What I learned?

2016 - Building Energy Boot Camp

Gewdy Espino

Kyle Gosselin Ismael Tatis

Our Experience- Week 1

Our Experience - Week 2

Raspberry Pi

Python

V

What we learned

Our thoughts

THANK YOU!

46

Steve Chinosi Janet Nicosia

Anil NavkalDwayne Scruton