Hey @TrevorFedyna
I was just trying to do something similar the other day actually.
The solution I landed on was actually to pull the total Gas from the E+ SQL file output actually. If you use the ‘AnnualBuildingUtilityPerformanceSummary’ table in that file, you can get the total-facility summary of all building energy, by use and by fuel type. You can sort it and sum up the Gas total from that relatively easily.
You can use the SQL query:
SELECT ColumnName, RowName, Value, Units FROM TabularDataWithStrings "
WHERE TableName='End Uses By Subcategory' AND ReportName='AnnualBuildingUtilityPerformanceSummary'"
you can get all that summary data.
I think that is probably a more robust method vs. getting the various loads from the coils and the air-systems and trying to sum them all up (unless you need those all separated out for some reason).