This intent of this project was to look into and understand cross platform collaboration between Excel documents and tools such as Rhino and Grasshopper. In this case, the project is collecting Sunlight hours data of a predefined building, at any given location based on its context at a defined duration of time.

The workflow begins with creation of an Excel documents which is used to defined the parameters in three different categories –

  1. Building DataHeight | Width | Depth | Number of Floors
  2. Site Coordinates Latitude | Longitude
  3. Solar Analysis PeriodStart Hour | Start Date | Start Month | End Hour | End Date | End Month


The first set of data i.e., Building Data, is used to create a building in Grasshopper for Rhino, with the help of attractor curves input from Rhino the facade can be distorted to break its monotony which aids the analysis. Simultaneously, using the second Data set, which gives a latitude and longitude – which is where the former building will be placed. It also acts as the center point for extracting the city information and generating the buildings context around a kilometer radius of the input coordinate. In the final step, all the three streams are used as an input for the set up of Sunlight hours Analysis in Grasshopper using the LadyBug plugin. The Solar Analysis Period from Excel is used to set up the Analysis engine, the Building is used as the geometry to analyse and the city generated is used in the context within which the analysis takes place.

Once the analysis is completed, we are able to visualise different sunlight hours on the facade and generate a data set that gives the sun light hours for every single surface on the facade of the building.




Solar Analysis is a project of IAAC, Institute for Advanced Architecture of Catalonia developed in the Master in Advanced Architecture 2019/20 by Students: Kristine Kuprijanova, Anton Koshelev, Pratik Borse, Manan Jain and Faculty: Paul Poinet