Method netSiteEnergy

src/utilities/sql/SqlFile_Impl.cpp:943–971

  }

  boost::optional<double> SqlFile_Impl::netSiteEnergy() const {
    boost::optional<double> hours = hoursSimulated();
    if (!hours) {
      LOG(Warn, "Reporting Net Site Energy with unknown number of simulation hours");
    } else if (*hours != 8760) {
      LOG(Warn, "Reporting Net Site Energy with " << *hours << " hrs");
    }

    std::string s = R"(SELECT Value FROM TabularDataWithStrings
                           WHERE ReportName='AnnualBuildingUtilityPerformanceSummary'
                           AND ReportForString='Entire Facility'
                           AND TableName='Site and Source Energy'
                           AND RowName='Net Site Energy'
                           AND ColumnName='Total Energy'
                           AND Units='GJ')";
    boost::optional<double> d = execAndReturnFirstDouble(s);

    if (!d) {
      LOG(Warn, "Tabular results were not found, trying to calculate it ourselves");
      std::string s = " \
          select sum(VariableValue)/1000000000 from ReportMeterData, ReportMeterDataDictionary \
          where (ReportMeterData.ReportMeterDataDictionaryIndex = ReportMeterDataDictionary.ReportMeterDataDictionaryIndex and variablename not like '%EnergyTransfer%')\
          group by ReportingFrequency;\
          ";
      d = execAndReturnFirstDouble(s);
    }

    return d;
  }

  boost::optional<double> SqlFile_Impl::netSourceEnergy() const {
    boost::optional<double> hours = hoursSimulated();