Excel Seminar 201 Fundamentals and Advanced Tools

Humber ASHRAE had the pleasure of welcoming Michael McEvenue back to host an Excel workshop for students and branch members in February. Michael is a Humber graduate from the Sustainable Energy Building Technology program and past president of the Humber ASHRAE branch (2011/2012).  He was kind enough to donate his time and expertise for us to learn and also capture his workshop on video.

It is uploaded here as a tool for anyone that would like to delve into the useful tips that can help a novice navigate excel software and maximize its potential. It is in two parts as to accommodate the length of the seminar that was held. It begins with a brief background of Michael’s credentials, followed by the topics that will be covered.

Some key topics include:

  • Keyboard shortcuts, Tables,
  • Slicers,
  • Data Cleaning & Basic ETL (extract, transform, and load),
  • Paste Special,
  • Sumifs,
  • Index and Match,
  • Conditional Formatting,
  • Pivot Tables 

Follow along in the exercises using this file20170215 – SEBT – Excel Seminar – Michael McEvenue

part 1

part 2

 We hope you enjoyed this workshop, hopefully it helps with your professional development. A special thanks to Michael for putting together a great presentation, as well as Jeff Taylor and Toban Mills for capturing it and making it available to the public.

So, you want to be an Energy Manager?

As our understanding of building systems adapts to the brave new world of Energy Management, it is essential that students keep up with current trends in how we manage our built environment.  That being said, it was our great honour to host Scott Rouse of Energy@Work for our very first event of 2014.  Not only was he an incredibly dynamic and engaging speaker, but he also had very practical advice for those of us looking to energy the field of Energy Management.

Energy Management is the practice of lowering energy costs by reducing consumption through careful evaluation of energy usage.  Energy Management strategies can help companies financially by reducing utility consumption, can reduce emissions with greater efficiency and can help companies to be more socially responsible.

 

Step 1: The Right Stuff

To get where he is today, Scott built on an extensive background of qualifications to create his skill set as the lead of Energy@Work. He is a Professional Engineer, Certified Energy Manager and Sustainability Development Professional, to list just a few of his qualifications. All the letters after his name indicate the importance of ongoing education within this dynamic field.  Whether you have an advanced diploma, an engineering degree or experience in a related field, it’s always important to maintain credentials and pursue greater knowledge.

As students, more education isn’t always our concern.  Often, what counts the most is experience.    Luckily, the scope of energy management is such that work with utilities, companies or consultants are all potential avenues for success.

Step 2: Know Thy Industry

This is of course true to be successful no matter what type of employment you’re in, but it is essential in the green sector as emerging technologies drive rapid change. Scott discussed a number of trends that he summed up with 5 key words:

Transformation – use lots of different metrics for optimal performance!

Transparency – changes made to the building should be made apparent to the tenants

Context – make your changes effective to maximize the investment

Timelines – keep your measurement dynamic

Experimentation – keep up-to-date with technologies and implementation and don’t be afraid to try new things!

Using benchmarking, real-time monitoring and a focus on safety and tenant comfort, Energy@Work has become a great success. Since 2007, they’ve helped to save over $700k in energy and achieved emissions reductions by 240,000 kg CO2e/year.  Those are some pretty impressive statistics!  Those of us interested in energy management can hope to be a part of making positive changes like these within our own careers.

At present, job prospects appear to be pretty good.  With the right training, we can be poised to meet the demands of property managers as utility prices continue to rise and legislation emphasizes demand-side management.

 

Step 3: Maximize Your Skills

In addition to the key skills of leadership, finances, communication and technical ability, Scott was kind enough to point out some advice that’s especially helpful for new grads:

  • Listen!  Take the time to learn from the expertise of co-workers
  • Network
    • Membership in organizations such as ASHRAE
    • Attend trade shows and conferences
    • Network with whoever you can!
    • Keep yourself aware of trends in the industry, news and politics

F.E.S.T.I. Tour

The first tour of the year was Awesome!

F.E.S.T.I. – Fire Emergency Services Training Institute – Is an 8 year old building that functions as a training facility for fire fighters around the world. With state of the art technology perfectly engineered to work with the HVAC system, there was a lot to see and a lot to be impressed by.

 

 

The front right sloped part of the wall shown above is a solar wall that heats the air behind it and through simple convection, feeds into the outdoor air of the HVAC system.  This lowers the delta T (temperature) for the system, and reduces the overall energy needed to heat the conditioned space.

The white tower like structures are:

  • Left – stairwell using free lighting through opaque R-20 fibreglass wall.

  • Right – a solar chimney that helps move excess warm air at ground level into the HVAC system.

The ceiling in the building was designed using Thermodeck. This concrete prefabrication has connecting holes in it that allow the conditioned air to flow through it to the desired (and controlled) spaces. While doing so, it heats the floor and ceiling (which warms that area as well) and once it gets to its destination, flows into desired rooms like regular ductwork.

 

This picture shows the regular ducts work bringing the conditioned air to the specific Thermodeck where it works it way through a network of engineered holes covering the largest surface area possible, then being released into the space.

Because of the thermal efficiency of the building, the size of the boilers needed for this 36,000 sqft space is very small. They are also able to run the entire hot water heating system off of these instant hot water heaters (they have a high need for showers due to the fire training). These hot water heaters will only run when there is demand for them to, and rarely reach the maximum design output of having all five running (the farthest to the right is the controller).  They sequence between the five of them to create desired water temperatures using Natural Gas as their energy source.

 

 

Something that was integrated into the building design was a very neat floating stair system.  It works based on balancing the weight of the concrete stairs with an overhanging deck, where study areas are.

 

Two days were offered for the tours. Each group had a great time and learnt quite a bit too!

Thanks for participating! We hope to see more of you at our next event!

Feel free to email us at ashrae.humber@gmail.com with any tour, events or speaker ideas.

 

Technical Tour of Humber Lakeshore’s “L” Building

On Friday, April 12, 2013 members of the ASHRAE Humber student branch were pleased to attend a facilities presentation and tour of the Humber College – Lakeshore Campus’ L building, given by Humber’s own Facilities Director Spencer Wood. 

 The L building is the hub of the revitalized Lakeshore Campus, which features state of the art sustainable design techniques that combine design strategies with building technology to achieve higher operational efficiencies and significant energy savings.  Some of these measures include:

  • Green roof
  • Daylighting
  • High efficiency HVAC w/ zone control
  • High efficiency lighting
  • Thermal wheel HRV/ERV
  • Occupancy Sensors

 After the presentation on the building systems we were given a walk-through tour of the mechanical rooms.  With the Lakeshore Campus being set on the grounds of an old hospital for the mentally ill, it is unique in both design and layout.  The L building is new build and central to the campus.  The heritage hospital buildings surround the L building in a semi-circular fashion.  A connection is made underground with a series of service tunnels that are now used to run the heating and cooling loops from the boiler and chiller systems. 

 The feel inside the L building was one of comfort and contentment.  As a place primarily designated for learning, one could tell that the design of the building was done with students in mind.  The building flows from classroom to lecture hall, computer lab to study hall, all quite seamlessly.  The Indoor environmental quality was very good and more than suitable for students’ needs.

 Overall, the L building was an impressive bit of engineered design that fits in perfectly at the Humber-Lakeshore campus.  We are grateful to have had the opportunity for visiting the site.  The ASHRAE Humber Student Branch would like to thank Spencer Wood for a great presentation and tour, his knowledge of the building systems was evident and appreciated.

Design Competition Submission

We are looking for HVAC students that are interested in joining Humber College’s team that will submit an entry in the 2013 ASHRAE Design Competition.

The team will be entering the Integrated Sustainable Building Design category and will be leaded by Jake Harding.

Check out ASHRAE’s website for more details on the design competition: http://www.ashrae.org/membership–conferences/student-zone/design-competition

If you are interested please contact Jake at hrdj0110@humbermail.ca

ASHRAE Scholarships – Engineering Technology Scholarship

ASHRAE annually awards three (3) scholarships, valued at $3,000, to qualified undergraduate Engineering Technology students enrolled full-time in a post-secondary educational institution. Traditionally the recipients have been enrolled in a preparatory curriculum for the HVAC&R profession. Since Humber College hosts … Continue reading