Method energyConsumptionByMonth

src/utilities/sql/SqlFile_Impl.cpp:880–900

  }

  boost::optional<double> SqlFile_Impl::energyConsumptionByMonth(const openstudio::EndUseFuelType& t_fuelType,
                                                                 const openstudio::EndUseCategoryType& t_categoryType,
                                                                 const openstudio::MonthOfYear& t_monthOfYear) const {
    // For backward compatibilty, we had to preserve enum valueNames (first param in enum, ((valueName)(valueDescription))
    // You need to be careful about what you are passing here... valueName or valueDescription
    const std::string reportName = "BUILDING ENERGY PERFORMANCE - " + boost::algorithm::to_upper_copy(t_fuelType.valueDescription());
    // So this gets tricky, but we have ((Gas)(Natural Gas)). We didn't want to change to ((NaturalGas)(Natural Gas))
    // So here we take valueDescription ('Natural Gas', then remove the spaces to be NaturalGas)
    const std::string columnName = boost::algorithm::to_upper_copy(t_categoryType.valueName()) + ":"
                                   + boost::algorithm::to_upper_copy(boost::algorithm::erase_all_copy(t_fuelType.valueDescription(), " "));
    const std::string rowName = t_monthOfYear.valueDescription();

    const std::string& s = R"(SELECT Value FROM TabularDataWithStrings
                                  WHERE ReportName=?
                                  AND ReportForString='Meter'
                                  AND RowName=?
                                  AND ColumnName=?
                                  AND Units='J')";

    return execAndReturnFirstDouble(s, reportName, rowName, columnName);
  }

  boost::optional<double> SqlFile_Impl::peakEnergyDemandByMonth(const openstudio::EndUseFuelType& t_fuelType,
                                                                const openstudio::EndUseCategoryType& t_categoryType,