Energize Andover

  • Mission
  • Team
  • Meeting Log
    • Summer 2015
    • Summer 2015 - Presentations
  • Reference
    • Ubuntu, Python etc
    • Metasys - Building Management App >
      • Metasys Logs
    • BACnet
    • Theory Refresher
  • About
  • Community News
    • LED Pilot - Fall 2016
  • Contact
  • 2016-17
  • AGAB
  • Mission
  • Team
  • Meeting Log
    • Summer 2015
    • Summer 2015 - Presentations
  • Reference
    • Ubuntu, Python etc
    • Metasys - Building Management App >
      • Metasys Logs
    • BACnet
    • Theory Refresher
  • About
  • Community News
    • LED Pilot - Fall 2016
  • Contact
  • 2016-17
  • AGAB

Web Platform Dev

On line Tutorials


HTML
Get to know HTML - This tutorial teaches you everything about HTML. 

PHP
Get to know PHP - PHP is a server-side scripting language designed primarily for web development but also used as a general-purpose programming language.  There is one more place where you will get great training on line - PHP tutorial on the PHP website:

Javecript 
 Get to know Javascript - Javecript is most well-known as the scripting language for Web pages. JavaScript runs on the client side of the web, which can be used to design / program how the web pages behave on the occurrence of an event. JavaScript is an easy to learn and also powerful scripting language, widely used for controlling web page behaviour

jQuery
Get to know jQuery -  jQuery is a cross-platform JavaScript library designed to simplify the client-side scripting of HTML. jQuery is the most popular JavaScript library in use today.

djanjo
Getting started

Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design. Built by experienced developers, it takes care of much of the hassle of Web development, so you can focus on writing your app without needing to reinvent the wheel. It’s free and open source. ​

pycharm
Quick Start Guide
This short guide aims to help you get a grip on the IDE.

pandas
  • Tutorials
            This is a guide to many pandas tutorials, geared mainly for new users
  • Intro to pandas data structures
​          A thorough introduction to the pandas library
  • Loading CSV data in Python with pandas​

Ubuntu - Folder

O/S Installation 

Recommended Distribution kit - Version 16.04 (Xenial Xerus)
  • Configuring Laptop for Ubuntu with duel boot - Link
  • ​Recommended Partition for duel boot - Link 
  • Kit information for downloads
  • Upgrade and update 
    • ​​sudo apt-get update && sudo apt-get upgrade - More Info
  • ​Installing Ubuntu from USB stick or drive - Link  
  • Keyboard Shortcuts - Link
  • ​Keyboard shortcut - One Page ​

Web Server Apps Install and configuration 

  • Apache2, php, Anaconda (python library) etc - Link
  • ​Web App developing environment  setup - Link
  • ​Development Platform - Link​

Web App Setup instructions

  • python and Django setup 
  • ​PostgraSQL Setup 
  • Web App setup

Python 

Anakonda libraries

​Anaconda is a completely free Python distribution (including for commercial use and redistribution). It includes more than 300 of the most popular Python packages for science, math, engineering, and data analysis. 
​Downloading Anaconda 

Because Anaconda includes installers for Python 2.7 and 3.5, either is fine. Using either version, you can use Python 3.4 with the conda command. We recommend Python 3.5

​Kit Location (350 MB+) 
  • You should choose appropriate kit for your o/s
               Windows | OS X | Linux
  • Documentation for 330 packages is located here: Anaconda Documentation​​ 
To develop minimal profeciency in developing appliactions for Web deployment, one needs mnimal familiarity with handfull of related technologies. Having a good grasp of these areas becomes important once you start doing serious application development. With this in mind, the follwing is a listing of tutorials found in one of the most popular open souce forum : ​w3schools

Script for Parsing Metasys export

Picture
Script Location on Github
Script Author  : Viraj Navkal

To Run the script

 python script/parse.py -i "data/AHS-ElectricTrend-Nov_Dec2015.csv" -o output.csv -s --start 17:00 --end 8:00
Note
  • Time syntax based on 24 hrs
  • Start  > End  /* Night time use, time line crosses mid night
  • Start < End   /* day time use Time is past mid night
  • -S option produces summary table as in Table here
  • Without -S option you will see tables produced by Girish's script
  • You can be creative with fine names.
  • Try specifying different time intervals like 5 PM till 8 PM and 8 PM till midnight etc. 

Learning Python on line

Picture

​Code Academy

Plots

There are many python libraries that are freely available with wide range of capabilities: From simple plots to complex data set representations.

For most statistical graphing needs matplotlib  is most popular choice. There are also step by step youtube tutorials available on use of this library. Here are handy links for both.    
Picture
  • Plotting using Python, open source free library   matplotlib 
  • Step by step tutorial on using matplotlib             Matplotlib Tutorial Series - Graphing in Python 

Web Proto  new

Extranet

Picture



​Convert raw export from Metasys to per day energy used per feeder csv file
Sample Data file (You will need to download them to use in the "Metasys Parsing" portal)
  • Sample Data file shared folder
  • Parsed File Example
  • 2015-2016 Aug - APR - Daily (Formatted for Web)



IntraNet

AHS Portal