Hi,
I am trying to exact this circled value from the report 'Component Cost Economics Summary' in the eplustbl.csv output file. However, I have no idea how to differentiate the row from the others since they all start with "--".
Any ideas on how to solve this problem? Thanks in advance :)
Assuming this is an EnergyPlus output table, I would recommend using the SQL output file and executing a query such as
SELECT Value FROM TabularDataWithStrings WHERE TableName = ...
This could be accomplished with a Python script using the sqlite3 library.
Making some assumptions: 1) You're using EnergyPlus
2) It appears you've imported the data into Excel, since there are no commas separating each field
3) an Excel Vlookup(datarange,linenumber,7) should work (or something similar)
4) If you're trying to extract the data from another software, a similar lookup function should be available
ps, the format of eplustbl files varies depending on the reports you specify. For a particular set of reports, though, the format will remain stable and you can make your formula appropriately.
Another idea: I use a macro for extracting tariff information which first looks for a unique text string, then offsets specific rows and columns for the data I'm interested in
Comments