×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Compatibility With Excel

Compatibility With Excel

Compatibility With Excel

(OP)
I was just curious of how easy it is to interface RISA 3D (or RISA Floor) with Excel for pre or post processing? We have run into several projects in the past where we either needed to define complex geometry using Excel or strip out results to post process using Excel. Is this an easy option in RISA, or would you really have to fight to make it work?

Thanks!

RE: Compatibility With Excel

The RISA-3D input is spreadsheet based, so it should be very easy to copy and paste from RISA into Excel and vice versa. Spreadsheets are sort-able and such making it even easier. There are only a few items (wall panels and solids are the only ones that come to mind) where you can't manipulate them fully using the spreadsheets.

Output spreadsheets can be copied and pasted into Excel as well. Though not all output is available, so you can only copy and paste what results are shown in the spreadsheets.


RISAFloor is similar, but probably a little trickier. Some of the input is more graphical in nature and is not directly controlled by spreadsheets.

RE: Compatibility With Excel

Just an FYI: I work for RISA. Most people in this forum probably realize that already. But, there wasn't anything in my previous post that suggests this. Therefore, I just wanted to clarify so that you don't come away with the wrong impression.

RE: Compatibility With Excel

This is one of the aspects of Risa that really disappoints me. I really wish it could at least export to .csv files.

RE: Compatibility With Excel

RISA does have a "print to flat file" feature that is essentially a CSV file. Probably should have mentioned this in the first post as well. It only works as part of the report printing. Some companies set up special reports to print out exactly what they need to work with some Macros they create in Excel for post processing.

RE: Compatibility With Excel

I don't use RISA, but I do use another program that has sortable spreadsheet based input and output, and I agree that this feature makes working with Excel (or other spreadsheet programs) very quick and easy.

To my mind copying and pasting (in either direction) is much easier and quicker than saving to a csv.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources