Visual Programming Final Assignment
Liliana Viveros Diaz and Renata Stefanelli
[Definition of the Project] The goal of the project is to create a tool for all the IaaC’s Self Sufficient Building Studio to visualize the best option of energy to be implemented into the projects. The idea is that anyone can put their own data (constructed area and energy consumed) and know how efficient are the new technologies proposed (image 1). In this example we try to visualize the amount of energy consumed by each existing building in the block located in between the streets of Pujades and Llull (image 2) and how much new energy off grid it can produce. In order to achieve this we must have calculate the current amount of energy consumed per building by area and zoning.
Image 1. Possible green technologies
Afterwards set every technology connected to an interval selector. Each intejrval selector would set the amount of energy each technology can produce per meter squared or units. In other words, it would set a range of efficiency of energy production. Image 2. Location of the Case Study
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. 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. 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. To visualize this amount of energy (Kwh) we want to do it with Histograms and combine all the information in a 3D visualizator such as
Image 3. Energy of each building (kwh)
[Description of the dataset] 1. 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. 2. Amount of Energy Produced by each alternative technology. Put together in the same CSV file the amount of kw/hr/yr that each alternative technology produces. The technologies being studied are: photovoltaic panels, wind mills, geothermal and hydroelectricity.
We gather all the information about the different technologies into one single spreadsheet in order to send them into Impure. 1 m² of Photovoltaic Panel produce 1,500 Kw/hr/yr in ideal conditions. 1 m² of Geothermal installation can produce 0.08 Kw hr/yr in a place like Barcelona. 1 Wind turbine (A 10Kw model) can generate 10,000 Kw hr/yr at a site with wind speeds averaging 12 miles per hour. For getting the values of the Hidroelectricity energy we should use this formula: E=H*F*e*f E=Energy (Kw.H) H= Height of the building in ft F= Flow in cubic feet per second e= Efficiency (80% on this case) f= Factor (11.8) We have to keep in mind that the values obtained with this formula are correspondent to each existent building on the block. In order to have all the information in one spreadsheet and in Kw.H.m² we sum up all the values and divide it into the amount of constructed area on the block, therefore we get the amount of energy produced by this system in 1m². The challenge of gathering this information was to flatten all the values into a unit of energy, in this case the Kw.H.m², but we finally had the amount of Energy consumed on the entire block in Kw.H.m².
[Structure]
String > CSV Loader Table Visualizator Get Element from List > Number Get Sub List TwoNumbersToList > Number > LengthOfAList Diagnolize Table List Element Selector > GetRow Text Visualizator SubListSelector SameNumber > ListConcat5 > Addition5 Subtraction Histogram Color Picker
[Mockup]
[Achievements] 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 technologies to select to balance with the amount of energy the block already consumes.
[Workspace]
Each technology gathered into a unique CSV, selecting each column (technology) using a GetElementfromList connecting to individual Histograms representing the amount of energy produced by m².
Select the amount of m² used of each technology using a ListElementfromSelection. It is possible to visualize the amount of energy produce by that amount of area using a TextVisualizator. Use a addition and subtraction to know the amount of energy consumed and produced in the block.
[Final Interactive Layout]
In order to graphically visualize these numbers, use ListConcat5 and SubListSelector connected to a Histogram. Pass the mouse over the graphs and the amount of energy and the type of technology used will be shown.