Exporting multiple outputs to Excel while running Octopus

Hi everyone,

I'll be using Octopus (MOO) to calculate multiple configurations, is there anyway I can export the results to ONE Excel sheet, I have multiple outputs for each configurations that need to be exported such as Annual DA values, Annual MRT, Annual cooling and heating loads,... etc .

I've used Excel write component from TT toolbox in the past, it has a component called Galapagos listener that can export genomes and fitness values in one Excel sheet, however in this case I need to export many outputs not just the fitness and the genomes values, any ideas?

Thanks

Replies are closed for this discussion.

Replies to This Discussion

Permalink Reply by Abraham Yezioro on March 21, 2015 at 11:26pm

Rania,

Maybe you should look at http://www.grasshopper3d.com/video/pollination-for-honeybee

-A.

Permalink Reply by Ninja on March 22, 2015 at 12:52pm

Abraham,Thanks again, I should credit some of my work to you :) .

I took a look at the the Pollination tool and I have to admit it is awesome. I ran Octopus since last night and I connected 12 lists of data that I wanted to export to the pollination component as a data tree with branches. additionally I connected the file name to a slider, so I can keep each configuration to a separate file. Pollination created .csv files, the files have 12 different data separated by comma, however,pollination recorded the first value in the list, for example I have an hourly list of mean radiant temp. that list has over 8000 values, in the .csv I get one value from this list, I'm guessing it is the first value in the list. Another example, I have a daylighting autonomy list that has about 300 values (the grid nodes values) and again in the .csv file I see only one value. Is it supposed to be this way?

Thanks in advance.

Rania

Permalink Reply by Yassin Ashour on March 22, 2015 at 1:51pm

Hi Rania,

I use Excel Write component from Lunchbox (http://www.grasshopper3d.com/group/lunchbox). Use the recorder component to record all the values you require and then after the MOO is complete, export it into Excel using that component. It has a limitation of 5 inputs, you can use multiples of it and export to several sheets and simply copy all the values into one sheet OR determine which column number to start at for each set you export and export them all into one sheet.

Cheers!

Yassin

Permalink Reply by Örn Erlendsson on May 5, 2015 at 5:55am

TT Toolbox has a write to Excel component that does not have a limitation of the number of inputs (that I know of). I am using it together with the 'Entwine' component and have thus far been able to write 32 columns per sheet. It is very effective when documenting multiple simulation scenarios.

Permalink Reply by Nitë on May 5, 2015 at 6:25am

Hi Örn,

Thank you for your input.I also started usin octopus to optimize Window to Wall ratio and I feel lost when I open the solver window, I read some papers and principle about MOO bu still I need some help.

- Are you using Octopus component or Octopuse?

- When using a SPEA based on what do you decide about the number of generations and elite?

- I put all the values into one number and I got a very big objective of circa 40.000 and the simulation run all night, with no results at the export file.

Do you have time to check my definition?I have posted it on Mostapha's comment below.

Tack så mycket,

Nita

Permalink Reply by Nitë on April 17, 2015 at 11:25am

Hi Rania,

Hope you fixed your exporting problem. I working on my thesis am struggling with a similar problem trying to optimize WWR for multiple objectives using Octopus.I must admit I am a beginner and I find hard times connecting the dots to optimize.Can you give me some hints?A screenshot or Gh how you connected the geometry with genomes so they will change, and objectives with results from HB and LB?

https://www.youtube.com/watch?v=6ssgXi9hSn0

Your help will be very useful and appriciated

many thanks,

Discussion >

http://www.grasshopper3d.com/group/octopus?xg_source=activity

Permalink Reply by Mostapha Sadeghipour Roudsari on April 19, 2015 at 7:18am

Hi Nite, This is an old video but should be a good source to get you started:

Permalink Reply by Nitë on April 19, 2015 at 8:43am

Thanks Mostapha.I came across it but found it a bit hard to follow.Will check ti better now.

Permalink Reply by Nitë on May 5, 2015 at 3:08am

Hi Mostapha,

I checked your video and have a few questions.I followed the same way of combining the objectives at the end(see image) for total radiation for cooling and heating period.The variable was the glazing percentage of an external wall of one room.

I got a huge number for objectives and the simulation run almost 9 hours through the night and at the end(when I stopped it)there where no results to export.Except of the screenshots I made.I read the octopus manual and tried to understand from the forum discussions on how and what to select but still it seems to have lots of errors.

- I also wanted to ask you if the generations can be repetead and visualized as in the third part of your video ( https://www.youtube.com/watch?v=fYw7KexxThM ) without using matlab?only inside the gh canvas with LB HB and Octopus?

Thank you,

Nita

Attachments: