search

codeforboston / home-energy-analysis-tool

https://www.codeforboston.org/projects/
MIT License
12 stars 30 forks source link

Create a function to determine inclusion enum for a given date #107

Closed jkwan2011 closed 9 months ago

jkwan2011 commented 10 months ago

As part of the calculation for natural gas, the rules engine needs to be able to categorize dates into winter months (INCLUDE), summer months (INCLUDE IN OTHER ANALYSIS), and shoulder months (DO NOT INCLUDE). Finish developing and testing the date_to_analysis_type function based on the month-to-enum map provided.

alanisaac commented 10 months ago

The function should mimic the logic from column F in the Natural Gas sheet in the Excel spreadsheet. This logic references the "Lookup" hidden sheet that has the provided month-to-enum mapping.