{"id":46632,"date":"2021-03-28T13:34:33","date_gmt":"2021-03-28T17:34:33","guid":{"rendered":"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/?p=77"},"modified":"2022-04-13T10:26:51","modified_gmt":"2022-04-13T14:26:51","slug":"ur-utilities","status":"publish","type":"post","link":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/","title":{"rendered":"Improve Efficiency of Chilled Water Production"},"content":{"rendered":"\n<figure class=\"wp-block-image is-style-default\"><img decoding=\"async\" src=\"https:\/\/asg-architects.com\/wp-content\/gallery\/june2015-urc-chiller-plant\/04_20619_00_asgweb.jpg\" alt=\"URC-Chiller Plant \u2013 Ayers Saint Gross\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-center\" style=\"font-size:15px\">Photo:  Ayers Saint Gross<\/p>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/IMG_2438.jpg\" alt=\"Wade Bennett\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Wade Bennett<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Graduate Student<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/face.jpg\" alt=\"Justin Cavanaugh\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Justin Cavanaugh<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Undergraduate Student<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/IMG_0136-e1620340685603.jpeg\" alt=\"Thayalan Kundralan\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Thayalan Kundralan<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Undergraduate Student<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/Senior-Headshot-e1620340743666.jpg\" alt=\"Jen Rowe\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Jen Rowe<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Graduate Student<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/11148594_955879977787531_4245787622418588141_n-e1620341056807.jpg\" alt=\"Stephen Schneider\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Stephen Schneider<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Undergraduate Student<\/p><\/div><\/div>\n\n\n\n<div class=\"wp-block-coblocks-author\"><figure class=\"wp-block-coblocks-author__avatar\"><img decoding=\"async\" class=\"wp-block-coblocks-author__avatar-img\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/Vigran.Jacob_.Color_-scaled-e1620340900167.jpg\" alt=\"Jacob Vigran\"\/><\/figure><div class=\"wp-block-coblocks-author__content\"><span class=\"wp-block-coblocks-author__name\">Jacob Vigran<\/span><p class=\"wp-block-coblocks-author__biography\">Data Science Undergraduate Student<\/p><\/div><\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Supervisors<\/h2>\n\n\n\n<p class=\"has-text-align-center\" style=\"font-size:24px\"><strong>Ajay Anand<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\" style=\"font-size:24px\"><strong>Pedro Fernandez<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\">Department of Data Science at University of Rochester<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Sponsors<\/h2>\n\n\n\n<p class=\"has-text-align-center\" style=\"font-size:24px\"><strong>Alexander Pfadenhauer<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\" style=\"font-size:24px\"><strong>Tim Vann<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\">University of Rochester Utilities<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Project Vision &amp; Goals<\/h2>\n\n\n\n<p class=\"has-text-align-center\">UR Utilities and Energy Management hopes to improve the efficiency of chilled water production through predictive modeling.&nbsp;<\/p>\n\n\n\n<p class=\"has-text-align-center\">Our team hopes to provide a package of models which can accurately predict, within 500 tons.<\/p>\n\n\n\n<p class=\"has-text-align-center\">1. Daily max CHW demand ( 4-day lookahead)<\/p>\n\n\n\n<p class=\"has-text-align-center\">2. Time of daily max CHW demand<\/p>\n\n\n\n<p class=\"has-text-align-center\">3.  Hour by hour forecast of max CHW demand&nbsp;(24+ hour lookahead)&nbsp;<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Description of Datasets<\/h2>\n\n\n\n<p class=\"has-text-align-center\">Our first dataset includes Time series data of power for each chiller, spanning March 1, 2019 to March 1, 2021; interpolated in 1-minute intervals. This dataset contained occasional negative power values and outliers which were later zeroed out or removed during data cleaning.<\/p>\n\n\n\n<p class=\"has-text-align-center\">The second dataset was weather data pulled from the National Oceanic and Atmospheric administration (NOAA) which gave hourly measurements sporadically. To match power data that was interpolated hourly, we used weather data observation at the 54 min mark as it contained consistent observations. This weather dataset also required a lot of data cleaning because there were multiple instances of strings mixed with integers.<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Data Cleaning<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"388\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-1024x388.png\" alt=\"\" class=\"wp-image-513\" srcset=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-1024x388.png 1024w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-300x114.png 300w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-768x291.png 768w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-1536x583.png 1536w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM-1200x455.png 1200w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/Screen-Shot-2021-05-06-at-5.55.01-PM.png 1571w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Data Cleaning Process<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Exploratory Data Analysis<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/pasted-image-0-2-2.png\" alt=\"\" class=\"wp-image-520\"\/><\/figure><\/div>\n\n\n\n<p class=\"has-text-align-center\">For our initial exploratory data analysis, we performed seasonal decomposition on a variety of levels to get a better understanding of the data we will be working with.&nbsp; In the above graph we extracted the weekly seasonality where we can see peaks in the middle and end of each week. We also extracted the yearly seasonality with an obvious spike in the summer. The daily seasonality shows a dip in the morning with a spike in the evening. Finally, we display the temperature fluctuations throughout the year as we believe this will have a significant impact on our modeling.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-28.png\" alt=\"\" class=\"wp-image-524\" width=\"550\" height=\"420\"\/><\/figure><\/div>\n\n\n\n<p class=\"has-text-align-center\">Next we zoom into a singular and highly variable summer month (August 2019) and again perform a seasonal decomposition. The top row shows how the total power output fluctuates throughout the month. The second row shows us the moving average trend minus the daily seasonality, which can be seen extracted on the third row. The final row shows the error residuals than cannot be explained by just the trend and daily seasonality components.<\/p>\n\n\n\n<div class=\"wp-block-coblocks-gallery-masonry alignwide\"><div class=\"coblocks-gallery has-caption-style-dark has-gutter\"><ul class=\"has-grid-xlrg has-gutter-15 has-gutter-mobile-15\"><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-1-2-1.png\" alt=\"\" data-id=\"526\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-1-2\/\" class=\"wp-image-526\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-2-2.png\" alt=\"\" data-id=\"527\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-2-2\/\" class=\"wp-image-527\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"287\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-3-2.png\" alt=\"\" data-id=\"528\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-3-2\/\" class=\"wp-image-528\" srcset=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-3-2.png 512w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-3-2-300x168.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"285\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-4-3.png\" alt=\"\" data-id=\"529\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-4-3\/\" class=\"wp-image-529\" srcset=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-4-3.png 512w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-4-3-300x167.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure><\/li><\/ul><\/div><\/div>\n\n\n\n<p class=\"has-text-align-center\">For further insight into how the power changes on a day to day basis, we split the mean power output for each hour by season with a 95% confidence interval and displayed them in the graphs above. These graphs show dips in the morning and peaks in the afternoon for the Spring, Summer, and Fall seasons. The Winter season remains fairly uniform throughout the day.<\/p>\n\n\n\n<div class=\"wp-block-coblocks-gallery-masonry\"><div class=\"coblocks-gallery has-no-alignment has-caption-style-dark has-gutter\"><ul class=\"has-grid-xlrg has-gutter-15 has-gutter-mobile-15\"><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"311\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-5-2.png\" alt=\"\" data-id=\"530\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-5-2\/\" class=\"wp-image-530\" srcset=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-5-2.png 512w, https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-5-2-300x182.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-6-2.png\" alt=\"\" data-id=\"531\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-6-2\/\" class=\"wp-image-531\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-7-2.png\" alt=\"\" data-id=\"532\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-7-2\/\" class=\"wp-image-532\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"coblocks-gallery--figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-8-1.png\" alt=\"\" data-id=\"533\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-8-1\/\" class=\"wp-image-533\"\/><\/figure><\/li><\/ul><\/div><\/div>\n\n\n\n<p class=\"has-text-align-center\">Next we want to look at how the power changes throughout the week for each season. These graphs offer alternative information to the weekly seasonality that was displayed in our first seasonal decomposition. There seems to be consistent peaks on Monday and the end of the week for all seasons except the Fall, where we can see a clear increase in the middle of the week. It is interesting to see how the different seasons can reflect different weekly seasonality of power outputs.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<div class=\"wp-block-coblocks-gallery-offset\"><ul class=\"coblocks-gallery has-no-alignment has-caption-style-dark has-large-images has-medium-gutter\"><li class=\"coblocks-gallery--item\"><figure class=\"wp-block-coblocks-gallery-offset__figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-9-1.png\" alt=\"\" data-id=\"534\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-9-1\/\" class=\"wp-image-534\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"wp-block-coblocks-gallery-offset__figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-10-1.png\" alt=\"\" data-id=\"535\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-10-1\/\" class=\"wp-image-535\"\/><\/figure><\/li><\/ul><\/div>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-text-align-center\">We wanted to revisit how temperature and power change throughout the year with a side by side boxplot comparison. In the year of 2019 we can see how there is a clear correlation between the two trends, with both steeply increasing in the summer and decreasing in the winter.<\/p>\n\n\n\n<figure class=\"wp-block-image alignwide size-large\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/pasted-image-0-1-1-1.png\" alt=\"\" class=\"wp-image-537\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-center\">Further looking into the temperature, we created a heatmap of the weather variables that we would go on to use in our modeling. We can see that there are fairly strong correlations between some of the features and we took this into account when using them in our models.<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Modeling<\/h2>\n\n\n\n<p class=\"has-text-align-center\">To achieve our three project goals, we created two separate models. One would provide an hourly forecast of the next 12 hours to predict the current day\u2019s maximum power output and the time it would occur. The other model would forecast the daily max for the next 4 days to predict which day would have the highest.<\/p>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\">Predicting Daily Max<\/h4>\n\n\n\n<p class=\"has-text-align-center\">Initially we looked at various machine learning models as well as traditional SARIMA models to predict the daily maximum power output in tons. After testing with each type of model and adjusting parameters, such as the number of days in the past the model uses for prediction, we found that the Gradient Boosting and Random Forest models had the best performance. We decided to use Gradient Boosting because of its quantile feature.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-11-1.png\" alt=\"\" class=\"wp-image-540\" width=\"554\" height=\"389\"\/><\/figure><\/div>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">Number of Days in to the Future<\/th><th class=\"has-text-align-center\" data-align=\"center\">Mean Absolute Error<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">1<\/td><td class=\"has-text-align-center\" data-align=\"center\">680.7 tons<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">2<\/td><td class=\"has-text-align-center\" data-align=\"center\">898.1 tons<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">3<\/td><td class=\"has-text-align-center\" data-align=\"center\">965.5 tons<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">4<\/td><td class=\"has-text-align-center\" data-align=\"center\">1049.3 tons<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">5<\/td><td class=\"has-text-align-center\" data-align=\"center\">1244.6 tons<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-text-align-center\">Our testing found that including the weather and power data from 7 days before the prediction yielded the best results.<\/p>\n\n\n\n<p class=\"has-text-align-center\">Gradient Boosting Daily Max Results:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-12-1.png\" alt=\"\" class=\"wp-image-541\" width=\"512\" height=\"203\"\/><figcaption>Raw Gradient boosting results for 1 day prediction with cross-validation by month<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-13-1.png\" alt=\"\" class=\"wp-image-542\" width=\"512\" height=\"203\"\/><figcaption>Actual daily max alongside predicted daily max with 90% prediction interval<\/figcaption><\/figure><\/div>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\">Hour by Hour Forecast<\/h4>\n\n\n\n<p class=\"has-text-align-center\">With this approach we only created a machine learning model. For each hour, we captured a 24 hour lookback of max power, dry and wet bulb temperature, as well as a 24 hour lookahead of dry and wet bulb temperatures to serve as our \u201cforecasted\u201d weather data. Using this, we generated two time series features to help describe the trend: exponentially weighted mean and average difference. Once we had all our features, we performed sine and cosine transformations on the daily, weekly, and monthly seasonality. One model was created for each future hour prediction.<\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\"> <\/th><th class=\"has-text-align-center\" data-align=\"center\">Model<\/th><th class=\"has-text-align-center\" data-align=\"center\">Avg. RMSE over 12 hr Prediction (tons)<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">Linear Models<\/td><td class=\"has-text-align-center\" data-align=\"center\">Linear Regression<\/td><td class=\"has-text-align-center\" data-align=\"center\">962.3<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Non-Linear Models<\/td><td class=\"has-text-align-center\" data-align=\"center\">KNN<\/td><td class=\"has-text-align-center\" data-align=\"center\">1251.8<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">SVR<\/td><td class=\"has-text-align-center\" data-align=\"center\">3726.5<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">Decision Tree<\/td><td class=\"has-text-align-center\" data-align=\"center\">756.81<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">Ensemble Methods<\/td><td class=\"has-text-align-center\" data-align=\"center\">AdaBoost<\/td><td class=\"has-text-align-center\" data-align=\"center\">1716.3<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">Random Forest<\/td><td class=\"has-text-align-center\" data-align=\"center\">467.91<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\"><span style=\"color:#f7ce04\" class=\"has-inline-color\">Extra Trees Regressor<\/span><\/td><td class=\"has-text-align-center\" data-align=\"center\"><span style=\"color:#f7ce04\" class=\"has-inline-color\">388.0<\/span><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><\/td><td class=\"has-text-align-center\" data-align=\"center\">Gradient Boost<\/td><td class=\"has-text-align-center\" data-align=\"center\">648.73<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"has-text-align-center\">After testing several models, Extra Trees had the best performance.<\/p>\n\n\n\n<p class=\"has-text-align-center\">After tuning the Extra Trees model, we were able to predict future power usage within approximately 800 tons (95% confidence level) and our average RMSE was 399.73 tons<\/p>\n\n\n\n<div class=\"wp-block-coblocks-gallery-offset alignfull\"><ul class=\"coblocks-gallery has-border-radius-3 has-caption-style-dark has-large-images has-custom-gutter\" style=\"--coblocks-custom-gutter:0.5em\"><li class=\"coblocks-gallery--item\"><figure class=\"wp-block-coblocks-gallery-offset__figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-14-1.png\" alt=\"\" data-id=\"543\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-14-1\/\" class=\"wp-image-543\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"wp-block-coblocks-gallery-offset__figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-15-1.png\" alt=\"\" data-id=\"544\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-15-1\/\" class=\"wp-image-544\"\/><\/figure><\/li><li class=\"coblocks-gallery--item\"><figure class=\"wp-block-coblocks-gallery-offset__figure\"><img decoding=\"async\" src=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/05\/unnamed-16-1.png\" alt=\"\" data-id=\"545\" data-imglink=\"\" data-link=\"https:\/\/seniordesign.digitalscholar.rochester.edu\/ds2021\/2021\/ur-utilities\/attachment\/unnamed-16-1\/\" class=\"wp-image-545\"\/><\/figure><\/li><\/ul><\/div>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"has-text-align-center\">While our models didn\u2019t quite reach the 500 ton MAE benchmark we were aiming for, we were able to get reasonable accuracies for each desired forecast of maximum power output (4-day daily max, current day\u2019s hourly max, and time of current day\u2019s max) within reasonable accuracy.<\/p>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\">Acknowledgement<\/h2>\n\n\n\n<p class=\"has-text-align-center\">Thank you to Alex and Tim for sponsoring us and working to acclimate us to the data. Thank you to Professor Anand for giving us guidance and helping us work through challenges with our project.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The project supported the goal of UR Utilities and Energy Management deparment to improve the efficiency of chilled water production through predictive modeling<\/p>\n","protected":false},"author":6242,"featured_media":60492,"comment_status":"closed","ping_status":"open","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2996,106,2956,3006],"tags":[],"coauthors":[8612],"class_list":["post-46632","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-community-engagement-archive","category-dsc-archive","category-energy-environmental-archive","category-machine-learning-archive"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Improve Efficiency of Chilled Water Production - Senior Design Day<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Improve Efficiency of Chilled Water Production - Senior Design Day\" \/>\n<meta property=\"og:description\" content=\"The project supported the goal of UR Utilities and Energy Management deparment to improve the efficiency of chilled water production through predictive modeling\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/\" \/>\n<meta property=\"og:site_name\" content=\"Senior Design Day\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-28T17:34:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-13T14:26:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1120\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\"},\"headline\":\"Improve Efficiency of Chilled Water Production\",\"datePublished\":\"2021-03-28T17:34:33+00:00\",\"dateModified\":\"2022-04-13T14:26:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/\"},\"wordCount\":1092,\"image\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/UR_Utilities_Image.jpg\",\"articleSection\":[\"Community Engagement Archive\",\"DSC Archive\",\"Energy and Environmental Archive\",\"Machine Learning Archive\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/\",\"name\":\"Improve Efficiency of Chilled Water Production - Senior Design Day\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/UR_Utilities_Image.jpg\",\"datePublished\":\"2021-03-28T17:34:33+00:00\",\"dateModified\":\"2022-04-13T14:26:51+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/UR_Utilities_Image.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/UR_Utilities_Image.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/ur-utilities\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Improve Efficiency of Chilled Water Production\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#website\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/\",\"name\":\"Senior Design Day\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/#\\\/schema\\\/person\\\/351018fbcf84ed8cac6d8072ba5b347c\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.hajim.rochester.edu\\\/senior-design-day\\\/author\\\/seniordesign\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Improve Efficiency of Chilled Water Production - Senior Design Day","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/","og_locale":"en_US","og_type":"article","og_title":"Improve Efficiency of Chilled Water Production - Senior Design Day","og_description":"The project supported the goal of UR Utilities and Energy Management deparment to improve the efficiency of chilled water production through predictive modeling","og_url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/","og_site_name":"Senior Design Day","article_published_time":"2021-03-28T17:34:33+00:00","article_modified_time":"2022-04-13T14:26:51+00:00","og_image":[{"url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg","width":1120,"height":630,"type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#article","isPartOf":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/"},"author":{"name":"admin","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c"},"headline":"Improve Efficiency of Chilled Water Production","datePublished":"2021-03-28T17:34:33+00:00","dateModified":"2022-04-13T14:26:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/"},"wordCount":1092,"image":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg","articleSection":["Community Engagement Archive","DSC Archive","Energy and Environmental Archive","Machine Learning Archive"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/","name":"Improve Efficiency of Chilled Water Production - Senior Design Day","isPartOf":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#primaryimage"},"image":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg","datePublished":"2021-03-28T17:34:33+00:00","dateModified":"2022-04-13T14:26:51+00:00","author":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c"},"breadcrumb":{"@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#primaryimage","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg","contentUrl":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-content\/uploads\/2021\/03\/UR_Utilities_Image.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/ur-utilities\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/"},{"@type":"ListItem","position":2,"name":"Improve Efficiency of Chilled Water Production"}]},{"@type":"WebSite","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#website","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/","name":"Senior Design Day","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/#\/schema\/person\/351018fbcf84ed8cac6d8072ba5b347c","name":"admin","url":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/author\/seniordesign\/"}]}},"_links":{"self":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/46632","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/users\/6242"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/comments?post=46632"}],"version-history":[{"count":4,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/46632\/revisions"}],"predecessor-version":[{"id":60412,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/posts\/46632\/revisions\/60412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/media\/60492"}],"wp:attachment":[{"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/media?parent=46632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/categories?post=46632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/tags?post=46632"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.hajim.rochester.edu\/senior-design-day\/wp-json\/wp\/v2\/coauthors?post=46632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}