Visual Programming Final Assignment Report
Liliana Viveros Diaz and Renata Stefanelli
[Definition of the Project] The goal is to visualize the amount of energy consumed by each existent building in the block located in between the streets of Pujades and Llull (image 1). To visualize this amount of energy (Kwh) we want to do it with a 3D visualizator such as we can see in the image 2. Once we have this data visualized we want to put some sliders that represent “green strategies” or “alternative technologies” such as photovoltaic panels, green roofs, wind mills, etc. that could be implemented into the design of the building. Each slider would correspond to the amount of energy each technology can produce per meter squared or quantity. In other words, it would set a range of efficiency of production. For example assuming that each square meter of photovoltaic panel produces X amount of energy (Kwh), when we move the slider the 3D amount of energy already represented in the
Solar House – Form follows Energy
building, would be reduced, since now its consumption of energy is produced off-grid and no longer from the existent infrastructure of Barcelona as represented in the first graph. At the end we want to visualize if the amount of energy consumed and produced can be balanced according to the strategies that we are using or not in our new design.
[Description of the dataset] 1.Height of the buildings in the block. Create a CSV file that demonstrates the height in meters of each building in the existing block.
2.Areas of the buildings in the block. Create a CSV file that demonstrates the constructed area of each building in the existing block.
3.Amount of Energy Consumed by each existing building. Create a CSV file that demonstrates the amount of kw/hr/yr that each building consumes according to its use and its constructed area.
4.Amount of Energy Produced by each alternative technology. Create a CSV file that demonstrates the amount of kw/hr/yr that each alternative technology produces. The technologies being studied are: photovoltaic panels, wind mills, geothermal and hydroelectricity.
[Structure] String CSV Loader Table Visualizator GetElementfromList Number Histogram ColorPicker
[Mockup]
[Achievements] What we want to achieve is that at the end this project serve as a tool for all the projects of the Self Sufficient Building Studio, that any person can put their own data and know if the technologies that they are proposing are going to be efficient or not. So in order to achieve this we must have every technology with a slider in which you can change the amount of the green technologies according to the different projects and at the end when you set all the parameters of the green technologies you can see if the amount of energy consumed and produced can reach a balance between them, so all the amount of energy that the technologies produce are going to be gathered and sum in one entity and the amount of energy consumed is going to be another separate entity and the subtraction of both is going to be the result of the efficiency or the performance of the block. So far we have achieved to visualize the amount of energy each technology can produce by each m². We were able to combine all the information into a single CSV so we can select each information by using GetElementfromList in order to do the calculations of which techonologies to select to balance with the amount of energy the block already consumes.
[Workspace]
The constructed area demonstrated in a Pie Graph. The height of the buildings demonstrated by a histogram set into temperature colors.
Each technology separated into a CSV and the Histogram representing the amount of energy produced by m².
Each technology gathered into a unique CSV, selecting each column (technology) using an ElementfromList connecting to individual Histograms representing the amount of energy produced by m².
First in order to load the CSV file we used the CsvLoader, then we knew that the Csv file contained 6 columns, the first 5 columns represents the green technologies that can be used in a building in order to decrease the amount of energy that they produce and the last one is the data correspondent to the amount of energy used by the existing buildings in the block, to visualize each of the columns we use a get element from list in which we connect the output of the csv file and the number of the column that we want to visualize (this create a list of numbers with a header) then we connect the output of the getElementFromList to the input of a getSubList and connecting this also to a IntervalSelector, we made this for every of the columns.