Welcome to the TRNSYS Users Forum.
The forum is a place where people can interact and have discussions about different topics involving the use of the TRNSYS software package. Here you can post topics for discussion or questions on using TRNSYS and get advice from other users or TRNSYS experts. This forum is not intended for detailed technical support. Users should contact their distributor’s hotline for such assistance.
Some tips for success on using the forum:
- Follow the Forum Rules posted in Forum Administration.
- There are categories for different types of topics and questions. Post your topic or question into the proper category.
- Before posting a topic or question search the existing topics (and the TRNSYS Users listserv archive) to see if a similar topic or question has already been answered.
- Use a descriptive topic name. Don’t use attention getting subjects, they don’t get attention and only annoy people.
- State the version of TRNSYS and which add-ons your are using.
- Include enough specific details for your topic of question to be answered. Just posting “Why am I getting an error?” without describing the specific error and what you are trying to do when you get the error will not receive a response that fixes your issue.
- Remember when people help you, they are doing you a favor. Be patient, help people out by posting good descriptions of what you need help with, and be polite even if a response does not solve your issue.
- Moderators may edit your post for clarity or move your topic to a more appropriate category.
Hello, everyone,
How can I export the walls, floors ceilings and roofs information in TRNBuild to the excel?
The file containing the building's information (extension *.b18) is text based. It can be opened in Excel by selecting File: Open... then selecting the file and specifying that the field delimiter is a tab. It is not an ideal solution but it has been useful to me on some occasions.
kind regards,
David
I don't know what kind of information you want to export to Excel, but if you are referring to wall areas or U-values, look at the end of the .INF file. INF file. There you will find a summary of the walls and windows as follows.
Used opaque construction types
(u-value incl. h_i=7.7 W/m^2 K and h_o=25 W/m^2 K)Construction type name | Total area | u-value | PERT | PENRT
MJ/m2 | m2 | W/m2 K | MJ/m2 | MJ/m2
------------------------------------------------------------------------------------------------------------- -------------------------
EXT_WALL | 281.666 | 0.250 | 0.000 | 0.000
GROUND_FLOOR | 48.000 | 0.295 | 0.000 | 0.000
ADJ_CEILING | 48.000 | 0.896 | 0.000 | 0.000Used window construction types
( u-value not availble - calculated during simulation)Construction type name | Total area | u-value | PERT | PENRT
| m2 | W/m2 K | MJ/m2 | MJ/m2
------------------------------------------------------------------------------------------------------------- -------------------------
EXT_WINDOW1 | 32.000 | -1.000 | 0.000 | 0.000
kind regards,
Yuichi
