Never underestimate the power of chance encounters.
Case in point: This summer, 乐播传媒 is taking a big step forward in its ability to track the use of electricity on campus. And most of the credit goes to a 乐播传媒 IT staffer and a handful of students who just happened to be in the right places at the right times.
Until now, 乐播传媒 energy manager John Rasmussen has analyzed the electricity usage in each of 28 乐播传媒 buildings by downloading raw data into spreadsheets. It’s a cumbersome process that takes lots of time and repetition, to say nothing of all the 11-by-17-inch printouts needed for annotating the data.
Now, thanks to the efforts of that student-staff team, Rasmussen can simply call up a dynamic online graph, capable of instantly depicting electrical draws for a given building in increments as fine as 15 minutes or as large as several months.
Straightforward and reliable, the setup is 鈥渧ery helpful in understanding where all this energy鈥檚 going,鈥� Rasmussen says, 鈥渁nd where the opportunities might be to make it more efficient.鈥� And it’s key to his larger goal of being able to comprehensively monitor, manage 鈥� and ideally, through consciousness-raising as well as technical upgrades, reduce 鈥� campus consumption of both electricity and fuel for heating buildings.
鈥淭his is a great project because it lets us see things that were invisible previously,鈥� says 乐播传媒 sustainability manager Tom Twist. 鈥淲e can see in real time what the buildings are doing 鈥� for instance, if we’re heating a building to its full capacity at 2 a.m.鈥�
鈥淚f you’re not in the business of energy management, it’s hard to understand the value of being able to quickly visualize energy-use data,鈥� says Rasmussen. His analytical work incorporates not only electrical usage data, but data reflecting the effectiveness of 乐播传媒鈥� campus heating plant in each building that it serves.
Rasmussen adds that it would have cost 乐播传媒 tens of thousands of dollars to purchase the commercial equivalent of the product put together by Maureen Haining, a 乐播传媒 programmer analyst, and five students. He says, 鈥淭hey are pretty sharp kids.鈥�
So what about those chance encounters? A few years ago, Twist made a presentation to Information and Library Services staff. Haining was there, and it came out that she and Twist live near each other up the Maine coast. So they started carpooling to 乐播传媒.
One of their commuting conversations involved Rasmussen’s travails with the electrical-usage data and the efforts of 乐播传媒 EcoReps 鈥� students overseen by Twist who undertake sustainability initiatives 鈥� to help with that. Long story short, Haining started working with the EcoReps, including some tutoring in the use of Python, a popular and powerful programming language.
They got as far as creating a way to depict static snapshots of electrical draw, an improvement over the printed spreadsheets, but not ideal.
Fast-forward to winter 2020, when Haining began teaching 鈥淧rogramming for Data Analysis and Visualization,鈥� a one-time Digital and Computational Studies course based largely on Python. (Perhaps reflecting how DCS has elevated awareness of the power of data at 乐播传媒, digital resources like Python and R no longer seem as occult to casual observers as they once might have.)
And therein lies the other random encounter. It soon became clear that three seniors in the course 鈥� Leo Crossman, Fahim Khan, and Avi Brach-Neufeld 鈥� already had considerable know-how in the snake-named programming language. (Also involved in the project are two EcoReps, Biruk Chafamo 鈥�22 of Addis Ababa, Ethiopia, and Kyung Phil Ko 鈥�22 of Ontario.)
鈥淭hey were doing very well, and were very helpful in the classroom with the other students,鈥� says Haining. In fact, the three let on that they鈥檇 taken the course mostly because they needed the credits. 鈥淪o I said, 鈥榃ell, then, I have a project for you.鈥欌��
Crossman, Khan, and Brach-Neufeld teamed up with the EcoReps, specifically that organization’s Data Group, to help with the electrical usage project. Haining鈥檚 three 鈥渓earned a whole new set of skills for visualization,鈥� she says. 鈥淔ahim had a strong interest in that. Avi leveraged his Python skills to package up and deploy a production level Python application. Leo was very good with JavaScript and knew about web development.鈥�
She adds, 鈥淚n all, they worked extremely well as a cross-functional team.鈥�
鈥淚t was a good opportunity to work on a real-life coding project as part of DCS course work, and I was excited to do it,鈥� says Khan. A physics major from Dhaka, Bangladesh, Khan starts work this summer as a software developer at Tyler Technologies in Falmouth, Maine.
A knotty problem Haining’s team confronted is that the raw data from the electrical submeters is not “clean” 鈥� that is, there may be gaps, spikes, or other anomalies in the data, which emanates from the submeters as data pulses that are stored on a server. (Steam-heat data is even quirkier.)
鈥淭he students automated the process of cleaning the data,鈥� says Twist, 鈥渁s well as creating that easy visualization tool so that anyone can go in and look at the data, and know pretty quickly if the buildings are behaving the way we wanted them to.鈥�
鈥淭hey are really bright, motivated kids,鈥� Haining says, 鈥渁nd they’re really good鈥� with the technology.
But Haining deserves a share of the kudos, too, Twist says. 鈥淢aureen did a really nice job of shepherding them through all the potential pitfalls and problems that could have just stopped everything cold.鈥�
One of the two EcoReps engaged in the project most recently, Kyung Phil Ko is a member of the EcoReps鈥� Data Group. For him and the EcoReps overall, he says, applying data analysis practices to electrical consumption 鈥減rovides valuable insights into larger systemic issues, such as how buildings use an unexpected amount of energy, and cultural issues, like peak energy usage driven by our insatiable demand.鈥�
Those insights can inform how another EcoRep working group, its Media Group, shapes its campus messaging about conserving electricity, as well as 鈥渨hat capital investments we ought to recommend鈥� for a third group, Energy Solutions. That’s a particular interest for Ko, whose sights are set on a career in financial initiatives that support sustainability.
The project overall 鈥渨as definitely a valuable learning experience,鈥� says Brach-Neufeld, a physics major from Silver Spring, Md. Brach-Neufeld, who will start a position as a developer at healthcare software manufacturer Epic Systems in August, did the Python coding that cleans the electrical-use data.
鈥淚n addition to the pure programming knowledge I gained, it was the first time I had delivered a final product,鈥� he says. 鈥淧reviously, all of my programming experience had been primarily for my physics research or my own enjoyment. Although it was a challenge, I learned a lot about how to make my programming user-friendly and professional.鈥�
For Ko, the exposure to programming was fun and beneficial. But more important, he says, 鈥渢he soft skills I learned 鈥� to become more comfortable with uncertainty, particularly in the beginning, and relationship management 鈥� are what I’m going to take away the most. Perhaps I would have been more stressed in the past few months if I didn’t have this project to learn such skills.鈥�
