Compatibility With Excel

[Nulukkizdin]

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!

 

[JoshPlumSE]

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.

 

[JoshPlumSE]

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.

 

[rn14]

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

 

[JoshPlumSE]

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.

 

[IDS]

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/