Home

Project Report 2013

1. 69 Before Installation RR ag te o Uo VD ae iment 69 Reference inthe guide iii itat tatate tdeieieetdesatentetatstletaiuebersdusederosustbiredutuderodddveredauvetsdostier 69 69 2 FT Ne 73 3 Scandinavian Energy Market nee 77 4 Power flow of wind turbine and battery eee 77 5 SkyStream 3 7 JE 78 6 Sky clearness index and daily sun radiation graph 80 7 Homer Solar resources input aa 80 8 Cluster of houses simulation nee ande 81 9 KDIISGXLPB u ee 84 10 martGrid system block diagram seen 85 LT Project Description 3 nen 86 Background Description ttt ttt ttt ttti tht th 89 PRUETT O SC ERE 89 Problem formulation oie det edo 89 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Iiis manner U 90 Choice of model and method ttt ttt ttti 90 Project management methodist tiii 90 System development method nsrununerererereveresrveresrerereserereseseresrseresrererererereserereseveresrseressereresesereseseresr 90 Operating SV SCI RD ldEtet 90 TOOLS used M M 90 uique i ii iiaii iiia 90 Table of figures Figure I Smart GRID System Overview csscosteicestascescascsassttsacesccanadeesseccveasctacenctivadseneosecanestentes 10 Figure 2 Monitoring Use Case D
2. fSelling Buying electricity Chart Figure 21 SmartGrid overview The picture above represents the entire structure of SmartGrid v 1 0 system It consists of several blocks of code which are working individually and as one in order to achieve the final result Steps in the process e First four unit blocks are acquiring all the information necessary from the excel file Each one of them has specific parameters of reading in order to acquire the proper information e The fifth block it is converting from euro to dkk plus MWh to KWh as well as adding the regular taxes for the distribution and transportation 39 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE The output of this process is two arrays which are displaying the production and distribution prices for electrical energy e The sixth block is calculating how much money the user has to pay accordingly to his hourly consumption without using renewable energy e The seventh block is calculating the amount of energy produced per day by a number of solar cells in a specific month of the year The output is therefore transferred to the battery which is found in the eighth block e The eighth block calculates the amount of energy produced by the wind turbine per hour as well as trying to cover the consumption from the household by using the produced and stored energy e Other blocks appearing in the system have the tasks to ease some of the cal
3. For further information about the battery and the wind turbine please refer to the discussion section of this report 9 Testing 9 1 Unit test Unit test represents the smallest piece of code that can be examined in isolation For unit testing the Get Excel Values vi has been used to illustrate the test This unit block has been used four times in order to get the weather forecast production prices for electricity consumption of a household and information regarding sky and sun conditions 43 Ali El Jechy Andrei Ursachi Ivan Nachev Unit Id Name Read from EXCEL RZ Tested By Andrei Ursachi Tested On LabView Test case Test case Id Description 1 Set the path for where the excel file is located Set start row and Set end row and column column Set the sheet from excel file Expected Result Actual Result u Possibility to set starting PASS row and column Possibility to set sending PASS row and column Possibility to set the PASS specific sheet from the Press run so the PASS software will start the above mention steps Put the data in a See the data being put PASS double array into double array Name Date Prepared By Ali amp Ivan 09 12 2013 Approved By Ali amp Ivan 09 12 2013 9 1 1 Before 44 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Figure 25 Read from excel before Steps in ge
4. 11 4 3 Further improvements For SmartGrid v 2 0 the cluster of houses will be connected to the system therefore a battery is necessary to store all the energy provided by each household Since a number of houses will be connected to the same system they will all benefit from the stored energy in the battery 11 4 4 Researches done Some research has been done in order to find a proper battery for system e Flooded type are Lead acid batteries that have caps to add water They are reasonably priced and work well for many years All flooded batteries release gas when charged and should not be used indoors If installed in an enclosure a venting system should be used to vent out the gases which can be explosive e Gel sealed gel batteries have no vents and will not release gas during the charging process like flooded batteries do Venting is therefore not required and they can be used indoors This is a big advantage because it allows the batteries to maintain a more constant temperature and perform better e AGM Absorbed Glass Mat batteries are in my opinion the best available for Solar Power use A woven glass mat is used between the plates to hold the 63 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE electrolyte They are leak spill proof do not out gas when charging and have superior performance They have all the advantages of the sealed gel types and are higher quality maintain voltage better self dis
5. EFIE E EN Dkk TR ECITAICIT TIN RCITCIOC ID e DIEENEEEENEEKENEERENEEKENEERENEERENEERENEENENEERENEERENEERENEERENEERENETENENEEEENEEKENEERENEERENEERENEENENEERENEEEENN 4 2 3 4 5 6 T7 8 Ss DR EZ 2 H iB mmu Time Figure 37 Graph with the prices from NordPoolSpot after running the software Description The picture above shows the actual prices from NordPoolSpot after the running of the software 52 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Time of day Consumption an i a L L u a a a a a a a 1 L E Figure 38 Electricity consumption before running the software Description The above picture displays the electricity consumption on a specific hour of the day In this stage it is empty because the software is not running 53 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE _ Time of day 01 Lu HER fer 31 Du E I HER FE mern eel so 7 fo 75 L 07 1 Loo ee ENS E L5 r9 T as mC ma Lu Ku FE KM kom BE FEE KOR Lou w En ee EN NN 08 Figure 39 Electricity consumption after running the software Description The above picture shows the electricity consumption on a specific hour of the day after running the software 54 Ali El Jechy Andrei Ursachi Ivan Nachev Dk1 consumption NRGI Dk2 consumption NRGI AV DK1 with turbine and battery 25 DK2 with turbine and
6. Most Averages i Figure 56 Sky clearness index and daily sun radiation Te Homer Solar resources input T HOMER PV hydrogen hmr W Fie View Inputs Outputs Window Help daily high daily low min DSH BER Equipment to consider e Hydrogen Tank Hydrogen load File Edit Help 1 HOMER uses the solar resource inputs to calculate the PV array power for each hour of the year Enter the latitude and V either an average daily radiation value or an average cleamess index for each month HOMER uses the latitude value to E calculate the average daily radiation from the cleamess index and vice versa Electrolyzer Hold the pointer over an element or click Help for more information Location ES D ne Latitude 55 50 North C South Time zone gt 3 s a GMT 02 00 Eastern Europe E ast Central Africa x Solar Resource dr Economics Longitude 50 East C West 2 System Control Data source Enter monthly averages Import time series datafile Get Data Via Internet Emissions Baseline data e Constraints Cleamess Daily Radiation Global Horizontal Radiation Month 6 Document nit Ku January i 35 ie February 0 445 140 08 Notes March 0 455 2 440 4 3 April 0 483 3 930 pm May 0517 530 o i June
7. el 4 360 4 249 4 610 4 393 kWh Har du sp rgsm l til regningen s ring 87 80 11 88 Opkr ves via PBS Figure 50 Electricity bill 1 74 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Opg relse med aconto Installationsnummer Opg relse 33956 Lystenlund 47 8355 Solbjerg Lokalenergi Forsyning A S CVR 25567714 a Abonnement 0 219 13 37 DKK ForsyningsEl 707 000 kwh 0 3364 237 86 DKK Moms 25 00 62 81 DKK talt s 314 04 DKK Faktureret aconto i i 156 06 DKK rei Opgorelse 77 7 REGTTIONS xm TITT 598798 DKK Gennemenitig pris pris excl al excl abonnement 0 4206 kr kr pr kwh VE PONENS Lokalenergi Forsyning A S AIS CVR 25567714 B 01 08 2013 31 08 2013 A pris Belab Abonnement 0 219 6 79 DKK ForsyningsEl 373 000 kwh 0 3253 121 34 DKK Moms 25 00 32 04 DKK EEE TETEN es NTE 160 17 DKK Geansinchitig acontopris excl abonnement 0 4066 kr pr kwh Opgorelse El 0 stjysk Energi Net A S CVR 25706900 01 06 2013 31 07 2013 Aftagenummer 232 0033956 8 M lernr Dato GI visning Dato Arsag Made Ny visning ro Enhed 16455329 31 5 2013 2 108 30 6 2013 Ordin r Fjern net 2 474 kWh 16455329 30 6 2013 2 474 31 7 2013 Ordin r Fjern net 2 815 NM kWh 3 g A pris Bel b 3 Abonnement 91 92 DKK Transportbetaling 707 kWh 02020 _ 142 81 DKK Elafgift almindelig 707 kWh 0 6530 461 67 DKK amp Energispareafgift 707 kWh 0 0650
8. 0 166395 Bang V 0 937501 0 982775 Dk2Buying 0 986018 0 986018 NordPoolDk MNA 216528 2 16528 Buyi ici NordPoolDk2 NS 3 696855 gt 422459 5 09758 2 15514 2 31057 334383 350498 141293 1 51214 240303 22225 1123374 132129 fe ov n L oms iori 207653 207663 uo La 1 53403 1 93403 292305 2 92305 o 061 084742 f 084742 1 06054 1 06954 Slaf Ras elz zlelele z sperm Mm Fa Y e D cB b FATA verepertepertepeerrpereeprterpretefererperrepeerepeeeepeeeeprereperreperrr 9 10 11 12 13 14 15 16 17 18 19 0 21 22 Time Information regarding sky and sun io months cCleamessindex Daily Radiation 9o Panay jos fo Maren do pa oi pes Wis may 0 517 532 June Dr 4538 Puy oae 526 auus 046 Ja September 043 12 85 Joctober 0206 November fo4 fom December 0412 Jos lt gt Figure 42 Scenario 1 Focus points e Fluctuation of the production and distribution prices on a 24 hour period blue e Energy consumption covered by wind turbine and battery from 00 00 until 16 00 the household does not need to buy from distributor green e Lower prices for energy for the rest of the day red 57 VIADA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE e For comparison of prices with and without using wind turbine please refer to Dkk using wind turbine and Dkk to pay for today onl
9. Homer website http www homerenergy com Pre DL html 8 NASA history database https eosweb larc nasa gov sse 9 Labview http en wikipedia org wiki Lab VIEW 10 Read Excel library http sourceforge net projects feexcel 11 MyDAQ http sine ni com np app main p ap academic lang da pg 1 sn n17 academ ic n21 16781 fmid 6307 12 MyGrid http sine ni com nips cds view p lang da nid 210999 13 Battery research http www freesunpower com batteries php 68 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Appendix 1 Installation guide SmartGrid Purpose The purpose of this guide is to help the system administrator to set up and run the software Each step it will be presented in chronological order with screenshots and all the necessary information to set up the software Before Installation The system administrator has to make sure that all the tools and files needed for the installation are being provided Information xlsm OpenFile bat Labview Executable software The LabView exe file of the software Server Computer which will run non stop with access to the internet Microsoft Excel Operating system on the machine Reference in the guide Steps Install LabView Executable no data available because of lack of software Copy Install all the necessary files Information xlsm openFile bat and This will explain the abbreviations used in the guide e xlsm represents Informatio
10. SmartGrid v 1 0 as well as the tools devices and requirements needed in order to develop the system The design part consists of displaying the features of the application as well as the overview of the interface Furthermore the main activities and the flow control of the software are being covered in this section The implementation part is explaining how different unit codes have been built as well as the process happening behind each block The testing section creates an overview of how each unit block has been tested individually as well as a group plus the test of working features Scenarios section is VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE illustrating how the system is working with different parameters and what are the focus point and the output of each simulation Discussion section covers why and how different tools have been used and further improvements of the system VIADA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 3 Problem formulation How to reduce the electricity bill for one or several households connected to the same system 3 1 Scope 3 1 1 In scope e Create an algorithm that balances lowers the consumption in a household by using renewable energy sources Predict the prices for the following day for electricity Display the savings in terms of money by using the system 3 1 2 Out of scope e Extend to a neighborhood Extend with wind power Possibly add a battery fo
11. Weather NordPool Hourly Consumption Con Bunning background query Click here to ca Figure 47 Querying weather data 8 Open the openFile bat and wait 30 seconds a Check if it opens the Information xlsm b Wait 30 seconds c Check if the files bat and xlsm files are closing make sure you don t run any other Excel files at the same time it will kill all instances of Microsoft Excel 71 Ali El Jechy Andrei Ursachi Ivan Nachev KA h Information xism Microsoft Excel Home Insert Pagelayout Formulas Data Review fiew Add ins Team 9 cut Calibri yn gt AA Siw H ek y sm X a Ep Wrap Text General E n n OT D A BH D 0 00 C E pone Insert bol Fri s lt SUA B amp c T z Ex Coi c e S Format Painter B I U EET 27 d UM Merge Center sn Formatting as Table Styles Clipboard Font Alignment Numbe Sty D5 p fe A B c E F G H Details Low 5 oC 24km h 8 Thu 5Dec Few morning clouds rain with clear spells during the day Light rain or sleet late at night Ve High 6 oC WSW at 9 Details Low 4 oC 50km h 10 Fri 6Dec Partly cloudy with a chance of sleet or snow showers during the day Light snow during the n High 3 oC W at 11 Details Low 1 oC 49 km h 12 Sat 7Dec Partly cloudy skies Windy especially in the morning High 2 oC WNW at 13 Details Low 0 oC 34 km h 14 Sun 8Dec Chance of sleet or snow early in the morning cloud
12. Yellow Double Blue Integer Purple String Turquoise Path name Brown error cluster 8 1 24hoursUpdate 36 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Time has Elapse d i Elapsed Time s Present s gt i i error out error in no error ras zei Figure 19 24h update The picture above depicts the code block of the 24HoursUpdate vi e Elapsed time it is a unit block from LabView from the basic package through which the system will check if 24 hours passed It represents a countdown of 86400 seconds When the countdown is over the openBat vi is being called e Path is used to set the path for setting which bat file to be opened e Command line is used to set the name of the bat file which will be later on opened e Days passed is used for showing how many days have passed since the 24H update is running The idea behind 24HoursUpdate vi it consists in a while true loop which is running until the system administrator is stopping the system It has a countdown for 24 Hours 86400 seconds and each 24 hours the bat file will be opened in order to proceed with the updates 8 2 Cluster of houses simulation 37 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Time of day Number of Houses Figure 20 Cluster of houses simulation It consists of three Booleans named Housel House2 and House 3 The system is checking whether the auto time
13. and the household electricity consumption Calculates and displays the prices for electricity after taxes Calculates and displays the amount of energy produced by the wind turbine and solar cells and the amount of electricity stored in the battery if Consumption lt if Consumption gt Production Battery Production Battery Calculates the amount of electricity that should be bought to cover the consumption Displays the savings and spending for electricity for that particular day plus savings since the system has been running Figure 14 Getting and processing the information VIA UNIVERSITY COLLEGE 27 via Ali El Jechy Andrei Ursachi Ivan Nachev NIVERSITY The steps and transformations happening in the software as soon as the user is running the system can be illustrated as follow e Getting info from tables vi is reading information from the xlsm such as the weather forecast Denmark s production prices for electricity the average consumption of a household in month October and data regarding the sky condition and sun radiation based on an average values from 2012 information which will be used to calculate the price of the electricity e The user will be able to analyze the weather forecast electricity production prices and the consumption from the household as specified in the system features e Soon as the production prices for electricity have been extracted from the e
14. appendix section of this report Appendix 5 An illustration depicting how the information has been extracted through Homer software can be found in the appendix section Appendix 6 The solar module used in the system is Kyocera KD315GX LPB It has been nominated as the best solar module of 2014 by the Solar panels review toptenreviews com reference 5 The size of a panel is approximately 2 2 m and the efficiency of it is estimated being 16 Further specifications regarding Kyocera KD315GX LPB can be found in the reference section of this report Reference 6 The produced energy by Kyocera KD315GX LPB is being calculated as following Number of Solar Modules Size Efficiency sun radiation m S day on the specific month of the year Note the solar module used in the simulation has been chosen accordingly to a review made by TechMedia Network The sun radiation m day are based on the following coordinates 55 50 N Latitude and 9 50 E Longitude location Horsens Denmark Note the energy produced by the solar module is being calculated using an average estimation per day from year 2012 The real time output of the solar module may be different than the one simulated The purpose of this simulation is to give an overview for the energy produced by a solar module in a specific month of the year and to give an idea to the customer regarding the energy he might be able to produce using a number of solar modules The energ
15. automatically daily to get the value of saving in total in a label Saving in total Orange How much the customer was supposed to pay for electricity from the distributor The customer will be able to see how much he was supposed to pay in the beginning before using the application Dark Purple Information regarding clearness index daily radiation The customer will be able to see the clearness and radiation information from the sun in a table data that is extracted from NASA through the Homer software The radiation is in relation to the solar cells Dark Red Prices for electricity with and without Turbine and Battery the customer will be able to compare the prices for the energy bough from distributor before and after using the system Blue marine 14 Ali El Jechy Andrei Ursachi Ivan Nachev File Edit View Project Operate Tools Window Help De 11 10pt Application Font fv ar 67 Number of Houses Ao To be implemented y SMART GRID For our Household How much supposed to pay 31 5945 How much to pay for today 9 16 7697 g for tod 14 2559 Saving in total 8 0 Time of day Consumption BLS CACA P rer pane EEN EEY EET sr ree rar nd En frem fosse a 23 zo ma r1 EZ sz 177 EE pua zu rv r1 a EN Dc EN EE 71 pu EM EM EE EM EE lt Getting info from tables vi Front Panel Dkk to pay for today
16. battery 25 Prices for electricity with and without Turbine and Battery a un Dkk N w gt o PE NE TI S B S 5 amp Z B 9 340 X RB AEE UT 3B 179 20 2T 22 2 Time Figure 40 Comparison between the prices before running the software Description In the graph above you can see that when the software is not running there is no information regarding the savings by using renewable energy sources Dk1 consumption NRGI IV tovider Dk2 consumption NRGI 25 DK1 with turbine and battery 59 Prices for electricity with and without Turbine and Battery DK2 with turbine and battery IA e pueraquaaapradagpresdquuredrppruraguare porter tp rn prp tr prp bre repr prp kreert per QU PHI 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Time Figure 41 Comparison between the prices after running the software Description In the graph represents in green and blue the prices when using renewable energy and the red and white lines are representing the prices from the distributor 55 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 10 Scenarios to test the functionalities of SmartGrid v1 0 All the scenarios have been simulated according to the energy production prices from 12 12 2013 as well as the weather forecast wind speed from the same date The purpose of these scenarios is to show the functionalities of the system Scenario 1 The purpose of this
17. day Number of Houses 1230 Household payment E gt Selling Buying electricity Chart Figure 65 SmartGrid system block diagram 11 Project Description 86 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Project Description 23 May 2013 Bachelor Thesis Group 24 Ali El Jechy 142528 Andrei Ursachi 142560 Ivan Nachev 126746 Supervisor Poul V ggemose L Descriptions eine 89 40 89 Problem formul tion eMM 89 4 Delimit tions ea 90 S Choiceof model and mehoduupuarsvmsnannnuitunsiusbsnininssninntiaoninbenindnknned 90 5 1 Project management method eese esee eese enne nennen enhn 90 5 2 System development method eese eene 90 87 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 3 Op rating SySlem esie cone rte e mini enainsiheiininiegete 90 5 4 TOOLS USC Lc etiem Coats ease Paces cece ahs ede ated MM ME 90 88 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Background Description This project is part of our Bachelor thesis We are three ICT students in a group who have been assigned to cooperate in a way to come up with a solution for a given case The project assigned to this group is done in cooperation with DSE Airport solutions Our primary source of information about our project is from the book SMART Grid Road Map The
18. ek 57 Fig re R T 59 Figure 44 Senat I ee 60 Figure 45 Balch De COU 6 x sn ee eh 70 Figure 46 Weather forecast enable content esserne renerne rn 70 Figure 47 Querymg weather da 71 Figure 48 Make sure that the batch file closes the excel application 72 Figure 49 Open the batch file in LabView and check the paths ss 72 Figure 50 Electricity bill T 74 Figure ST Electricity bill aiscscccccsscccssesssscceenscssetansateereacesiesieactaceancscentessesacstescsssdacsncatpaanocceseetvcaoes 75 Figure 52 Ferd bill 3 Pec 76 Figure 53 Scandinavian Energy Market kenne 77 Figure 54 Power flow of the wind turbine and the battery sss 78 Figure 55 Wind turbine specifications eese eene treten tn ntennnns 79 Figure 56 Sky clearness index and daily sun radiation ses 80 Figure 57 Homer software Solar resources graph input esee 80 Figure 58 Photo of cluster of houses simulated on the myGrid hardware 1 house CUO SUITE LLL M 81 Figure 59 Software simulation for cluster of houses 1 house consumption 82 Figure 60 Photo of cluster of houses simulated on the myGrid hardware 2 houses CONSUMPUON ETER dtu cft t ieu ind nei 82 Figure 61 Software simulation for cluster o
19. from the produced energy by the wind turbine should not be taken into account e The points in the graph to calculate the function were X 3 6 6 3 and Y 13 50 3 6 And 13 representing the wind speed power 6 3 and 50 representing the power of the turbine in W Note the energy production from the wind turbine has been calculated for the ideal environment perfect weather conditions no energy loss during transportation and conversion from AC to DC The purpose of data is to give an overview for the customer regarding the energy produced by this type of wind turbine The real time production may be different than the one simulated As soon as the energy produced by the wind turbine per hour is being calculated the system is checking the consumption can be covered If the consumption for the household at the specific hour is being handled only the produced energy is being used and the excess is being stored in the battery for later usage If the consumption is bigger than the production the system will check the energy level in the battery and eventually will use it in order to cover the usage If the produced and stored energy cannot cover the consumption the household is buying the necessary amount from the distributor in order to cover the electricity usage of the home Regarding the battery it is used in order to store the energy from the solar cells and the excess of energy produced by the wind turbine The battery is a fictional one wi
20. is set on or off For each scenario it there are two behaviors of the system e Auto control on gt the system will simulate randomly which of the three houses is using electricity at a specific time of a day e Auto control off gt the user will be able to set manually which house is using energy at a specific time of a day Also an instance of a clock has been implemented in order to display the time in the simulation Each second passed in real life its being simulated as one hour 8 3 SmartGrid overview 38 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Path Number of Solar Cells nth of the year T Selling Buying electricity Chart ei Householdipayment Kwh day from Solar Panels rl Informatibn regarding sky and sun Eal 18 output array Prices for electricity with and without Turbine and Battery TE tm et ur kto pay using Turbine and Battery Weather fprecast How much to pay for today lied 123 ei ly m s Saving for today KWh hour Lm peu umption ali Dei Saving in total piz error in Time of day m Em Number of Houses Ez Household payment KEE PVal Sgni NordPoolDkk
21. main goal of the project is to create an algorithm that simulates and balance the energy consumption in a household In terms of electricity production the focus is set on renewable sources as sunlight wind waves or geothermal heat The biggest electricity companies from Denmark are emphasizing on converting the wind power into electrical power Furthermore house owners started to mount solar panels to produce their own electricity in order to buy less from the electricity companies But this comes at a risk for example if the owner is producing too much of its own electricity and the electricity companies are not able to sell the proper amount the price for electrical power is increasing considerable Otherwise instead of saving money more is spent In terms of household appliances better and more sophisticated equipment is being used From washing machines to dryers and electrical cars each device is using a big amount of electricity The bigger quantity of electricity is used the more money has to be paid Furthermore the price for electrical power is fluctuating therefore the money spend Purpose The purpose of this project is to find a viable algorithm that simulates the produced bought electricity and balances the energy consumption in the house in order to save money Problem formulation How to create an algorithm that balances the electricity bought produced and used in a house 89 VIA Ali El Jechy Andrei Ursach
22. o 0 380766 0 404829 48 49 50 5 52 535 55 56 57 58 5 60 61 62 63 64 65 06 67 68 69 70 71 o To 0 338181 0351207 Time 0 0 0 443702 0 443702 DkiBuying RY Jo To 0 349265 0 366132 Dk2Buying NJ Po o 3167 316247 NordPoolDk MENS o fo 347262 347202 Sellina Buvina electricity Chart Node oak o fo 440138 465042 EE bo 3 4011 3 90264 235141 3 3533 6 04864 687227 5 09187 54532 6 1287 6 56361 1 5029 159020 250578 2 59578 Be me 0 490936 0 490336 ml D 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Time Information regarding sky and sun go Panay os fos ess A EE es fo fa May C une for fr Day for NN rs 72 VG lt gt Figure 44 Scenario 3 Focus points 60 Ali El Jechy Andrei Ursachi Ivan Nachev The graph has changed accordingly to the consumption for the specific day red 11 Discussion 11 1 LabView 11 1 1 Why LabView The software was chosen due to its possibilities Reducing test development time as soon as one unit block has been implemented it could have been tested in total isolation For each block a unit test has been done along with the development of the entire system Standalone applications each unit block implemented in the system can be used as a stand alone application Each one of the blocks can be used developing other systems with no problems Graphical programming language less time was spent addressing te
23. only from the provid assez os asser osas fozesses 0205564 az ozna azsszse 020323 asses oassoo oasen oasis osse osos cea vss usar 060703 osssens jonas oseoess or fasssr foss Fosoen2e osoena 2 06374 2 06374 ves was sons sons 2217 229582 2 10717 2 10717 Passe 29576 ler Prices for electricity with and without Turbine and Battery VIA Number of Solar Panels Month of the yearKwh day from Solar Panels eg nimi 2 se 7 5 83334 032225 7 Weather forecast 99 T re westnerbesenption Temp C 9o Menspe Light rain duringthe HighS oc WNW at fee flo OCC Tue 10 Dec Partly cloudy skies High 9 oc Detsis tow 6 oc Dk consumption NRGI l Dk2 consumption NRGI DKI with turbine and battery DK2 with turbine and battery ff PET 0172352585 25 IS BD RR RB RA TR 2 2 Time DkiBuying Dk2Buying NordPoolDk1 NordPoolDk2 CIII TE 13 14 15 16 17 18 19 20 21 2 3 Information regarding sky and sun 9 FMonths clearness Index Daily Radiation February 0 445 134 March 0 55 244 a 0 483 3 93 May s 9 s p 1 June Joa July os 1525 August 0 496 445 september 0453 285 October oce fs November oa ors December foai2 fs Figure 3 Features of the SmartGrid system 5 2 Overview of SmartGrid system The following section of the report contains screen shots of the SmartGrid v1 0 in order t
24. system is getting the necessary information regarding the wind speed for the following day it will convert from Km h to m s in order to facilitate the calculation regarding the produced energy by the wind turbine 31 VIA Ali El Jechy Andrei Ursachi Ivan Nachev NIVERSITY COLLEGE The power flow of electricity using a wind turbine and battery is being explained in the reference section of this report Reference 3 or in the appendix part Appendix 4 The wind turbine used in the system is SKYSTREAM 3 7 It is a small turbine designed for homes and small business The technical specifications are accordingly to the Danish laws The rated power is 2 1 Kw h at 11 m s power which is suitable for a household in Denmark For detailed specification regarding SkyStream 3 7 consult the reference section Reference 4 or the appendix section of this report Appendix 5 The produced energy from the turbine accordingly to the wind speed is being calculated from the Power graphic The following exponential function is calculating as accurate as possible the information extracted from the graph f x 31 25 e 775 The steps concerning the creation of the function can be stated as follows e The power of the turbine has been converted from W into KW e As efficiency range the lowest point where the windmill starts to produce energy wind speed 3 6m s and the highest point wind speed 13m s If the wind speed exceeds 13m s the output
25. the system is not 100 accurate because it is based on average values In order to achieve accurate results the values for the consumption must be updated according to the usage of electricity on hourly based A way to achieve this is simply by subscribing to your electricity provider service The downside of this method is that it costs money 11 8 Sun and sky conditions 11 8 1 Description All the information regarding the sky clearness index and daily sun radiations has been extracted using Homer software from the NASA database Data depicted is an average estimation from the year 2012 for each month of the year 65 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE The presented information has the purpose to inform the user about how much energy a number of solar modules can produce in a specific period of time Real time information may be different than the ones used in this process The only way to receive on spot data regarding how much energy a solar module can produce is by using an actual module and not an instance of it 11 9 Microsoft Excel 11 9 1 Why exactly Microsoft Excel In the beginning of the project the developers were thinking to create web services that could provide the information from external sources After a lot of brainstorming they concluded that this would be time consuming After some researches a breakthrough was made They found out that for the needs they have they could use Micr
26. 0 470 5 380 i 04 2 2 dip 0 482 520 8 August 0496 440 02 September 0 453 2 850 October 0 406 1 500 oaae EAE S E TE TE 0 0 jun November 0 400 0 760 er 4 EG ae December 0412 0 500 on Average 0 472 2 875 Plot Scaled annual average kwh n d 287 Help Cancel OK Tabular Graphic Export Details A Hydrogen tank search space may be insufficient G Completed in 3 seconds JE ep Figure 57 Homer software Solar resources graph input 80 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 8 Cluster of houses simulation Figure 58 Photo of cluster of houses simulated on the myGrid hardware 1 house consumption 81 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 3 24HoursHouseholds vi 8 File Edit View Project Operate Tools Window Hel beem 2 E Time of day House 1 House2 House3 2 P AS House 1 House2 House3 999 1 13PM 12 7 2013 Figure 60 Photo of cluster of houses simulated on the myGrid hardware 2 houses consumption 82 VIADA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE View Project Operate Tools Window Hel E ile Edit View Project Operate Tools Window Help eu rel Time of day House 1 House2 House3 EN 3 Auto Time stop 7 DO 5 1 17PM Wi O ros mulati
27. 45 96 DKK Distributionsafgift 707 kWh 0 0400 28 28 DKK 3 Fe Offentlige forpligtelser 707 kWh 0 1703 120 42 DKK amp Till gsafgift 707 kwh 0 0620 43 83 DKK Moms 25 00 233 73 DKK talt 1 168 62 DKK 2 Faktureretaconto __ EE EE gt Fat 7703 TOpg rese 7 7 5 600 18 DKK Gennemsnitlig pris excl abonnement 1 4904 kr pr kWh Figure 51 Electricity bill 2 75 Ali El Jechy Andrei Ursachi Ivan Nachev VIA UNIVERSITY COLLEGE Opg relse med aconto lt stiysk Energi Net A S CVR 25706900 01 08 2013 31 08 2013 i Bel b Abonnement 46 71 DKK Transportbetaling 373 kWh t 75 35 DKK 4 Elafgift almindelig 373 kWh 0 6530 243 57 DKK Energispareafgift 373 kWh 0 0650 24 25 DKK Distributionsafgift 373 kWh 0 0400 14 92 DKK 3 Offentlige forpligtelser 373 kWh 0 1610 60 05 DKK Till gsafgift 373 kwh 0 0620 23 13 DKK Moms 25 00 121 99 DKK Pat OSE ET Mei ln 609 97 DKK E Gennemsnitlig a pris excl abonnement 1 4788 kr pr kWh M lervisning ved afl sning 31 07 13 d 2 815 kWh Opkr vet aconto forbrug 15 08 2013 for perioden 01 08 13 31 08 13 373 kWh Forventet m lervisning pr 31 08 13 3 188 kWh Specifikation af moms og afgifter Art Afgift Opg relse Aconto fakt Regulering Ny aconto Total El Energispareafgift 45 96 22 17 23 79 24 25 48 03 El Elafgift almindelig 461 67 222 67 239 00 243 57 482 57 E Distributionsafgift 28 28 13 64 14 64 14 92 29 56 El Till gsafgift 43
28. 83 21 14 22 69 23 13 45 82 El Moms Lokalenergi Forsyning A S 62 81 31 22 31 59 32 04 63 63 El Moms stjysk Energi Net A S 233 73 113 69 120 04 121 99 242 03 Figure 52 Electricity bill 3 BSANENAMAMK ARP 09452771 1ROA OROA TI7 76 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Scandinavian Energy Market 41409 nanERESSES VITTIG Figure 53 Scandinavian Energy Market 4 Power flow of wind turbine and battery 77 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE WIND TURBINE Most household wind turbines generate direct current DC electricity A converter changes it to alternating current AC so it can be used in the home Wind turbine systems can either be connected to the national electricity grid or Figure 54 Power flow of the wind turbine and the battery 5 SkyStream 3 7 specifications 78 Ali El Jechy Andrei Ursachi Ivan Nachev Technical Specifications 2 KW at 11 es 24 KW st 13 m s 12 amp 2 72 m 170 Ib 77 kg 1157 f 1087 m Downwind rotor with stall regimon corta Clockw se locking upwind 3 Firerglass reinforced composite 50 330 pm 2165 R s 56 m s Sictiess permanent magnet brusniess Passie 120 240 VAC Spit 1 Ph 60 Hz 120 206 VAC 3 Ph compatible 60 Hz Check with dealer for other configurations Battery Charge Controller kt available for battery chargng systems Electronic stall regulation with ted
29. A Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Figure 7 Production and Distribution prices The graph displayed above represents Dk1Buying the prices for energy after taxes for Jylland DK2Buying the prices of energy after taxes for Sjaelland NordPoolDk1 production prices for energy for Jylland NordPoolDk2 production prices for energy for Sjaelland Note the graph displays the fluctuation in energy prices during a period of 24H Note the tables with further details regarding the prices for each hour can be displayed accordingly to the customer s preferences 5 2 1 5 Consumption of a household plus prices 1 92328 1 98275 Figure 8 Consumption of a household plus prices 19 The picture displayed above is illustrating the consumption of electricity on a 24H basis plus the prices for a specific hour of a day e Time of day represents the specific hour of the day e Consumption represents the amount of Kwh h are being consumed at a specific hour e Dkk to pay with wind turbine and battery represents the amount of money the user has to pay for a specific hour for the energy consumed e Dkk to pay for today from the provider represents the amount of money the user was supposed to pay to the provider for a specific hour accordingly to the consumption Note the purpose of having the two tables is to allow the user to compare the difference in the prices All the prices are being displayed as Danish curr
30. DEERE 62 11 2 7 How did you use the wind Dir bin ua 62 113 to ss 62 11 3 1 Why solar cells mm MM 62 11 3 2 How did you use solar cells ssseiscitssccocscssnsntsssstsccceatiseseestuinceesttnsttossdessseediartuctedatienstcacsysecsastesseteiiens 62 11 4 Battery Mee 63 INE SBIVMIJT 63 IUE MENTI een 63 11 4 3 Further improvements eterne then th ttt htt ttbi htt thes tha 63 11 4 4 Researches CONC NT 63 11 5 NOPGPOOISDOL uti e Iu etate eed pt E E GR aptus dA 64 11 3 1 Whyexactly NordPoolSpot ttt ttt tnter ttt ttr Eb bb EA epu 64 11 5 2 How did you use NordPoolSpot sssrin 64 11 6 Frere PAN eee 64 11 6 1 Why exactly freemeteo com ttt ttt ttt ttt tatit 64 11 6 2 How did you use freemete0 com sssrinin 65 11 7 Consumption in a household en aie 65 LIT DCS EPOS 65 11 7 2 Improvements for the next versin 65 11 8 sun and sky conditions JP 65 11 8 1 Description EDEL DEEP DEDE DEDE EA DE DEL DO DL EA AE een 65 TMS 66 11 9 2 How did you use Microsoft Excel sssr 66 HTTP 66 TITO DOS CHIP OM 66 11 10 2 Improvement mmemnenemerersrserereserereseseresreeseerererereseresrseresreesrererereresereseveresreeressesereseseresesere 66 liM une ee 67 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 13 Reference une 67 1 NordPoolSpot http nordpoolspot com Market d
31. High 6 oC WSW at 9 Details Low 0 oC 26 km h 10 Mon 9Dec Partly cloudy skies High 5 oC WNW at 11 Details Low 2 oC 24km h 12 Tue 10Dec Cloudy skies in the morning chance of rain during the day Cloudy skies during the night High 8 oC WSW at 13 Details Low 5 oC 19 km h 14 Wed 11Dec Few clouds High 8 oC WSW at 15 Details Low 7 oC 18km h Figure 46 Weather forecast enable content 7 Check if all the information is being downloaded Wait for the query to finish less than 20 seconds depends on the internet connection 70 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Ama 97 EF Information xlsm Microsoft Excel Home Insert Page Layout Formulas Data Review View Add Ins Team amp Cut Calibri vil Aa m E Wrap Text General HE d Ea Copy Paste r r v 9 lt 0 00 Conditional For GP Format Painter BEI U 2 ae EH Merge amp Center m 3 5 Pi Formatting as T Clipboard Font Alignment P Number p Style Details Low 4 OG 5Ukm h Fri 6Dec Partly cloudy with a chance of sleet or snow showers during the day Light snow during the n High 3 oC W at Details Low 10C 49km h 5at 7Dec Partly cloudy skies Windy especially in the morning High 2 oC WNW at Details Low 0 oC 34 km h 5un 8Dec Chance of sleet or snow early in the morning cloudy with a chance of showers during the di High 7 oC SW at Low 1 0C 24km h Details ption Payment 3 je t H
32. SYS tern 22 J3 2 24 OUTS Update isk cece HS 24 5 3 3 Running the algorithm mrmnmmeeenesersereresereresreseresrseresrersrererereserereseseresrseresrererererereseveresr 25 5 3 4 Getting and processing the information sssrinin 26 5 3 5 Production Distribution prices in Denmark srr 29 2 9 6 Battery and wind turbine dade el 30 5 3 7 Energy produced by the solar cells n rrrrrunnerseresesrseresrseresrerersseseresesesesrsesesrereesserersseseressseress 32 3 3 0 Household simulaflOns Jui rinii iea EEEE EEE EAEE ERR 34 6 PUrpose uch 36 FE ET VE Rae 36 8 Implementation cs 36 8 1 VO So EE tral eee rede ernennen 36 8 2 Cluster of houses simulation 37 8 3 SmartGrid Eos VLC een 38 8 4 Production and distribution prices eerte 40 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE ea es one ae 41 8 6 Wind turbine and battery ans ee 42 JTD eek 43 NUM te Range een ee A eee eects 43 ILA B f OP E 44 9 12 ED EET TEE 45 9 2 Integration test una 46 9 3 Acceptance test nee 48 10 Scenarios to test the functionalities of SmartGrid v1 0 56 Scenari N een een nike 56 Scenario La 58 PT yeaa cts crac athe ale cca iene 59 AEE ERE ES ER see 61 11 1 Ea DVS nee EE 61 TA Why Lab VieW reninipininnnisininaninminnnanimannuninininnnin n ana ain 61 VTM 62 11 20 Whywind t rbin intitle iiaa DEERE BESIDDE HEE
33. The input in the first field number of solar panels is being set by the administrator in the system The current month of the year was set to December The last field shows how much the four solar modules can produce for a day The efficiency of the production is based on the sun radiation Weather forecast J 0 D Figure 34 Weather information before running the software Description The picture above shows that there are no values in the weather forecast before running the application 50 Ali El Jechy Andrei Ursachi Ivan Nachev Weather forecast Jo fote Weather Description fremt Figure 35 Weather information running the software Description The picture above was taken after running the software It shows the weather forecast for the following two days Dk1Buying Dk2Buying 25 NordPoolDki MN Selling Buying electricity Chart NordPoolDk2 NA mn 1 Dkk O Mreeeqereepeeceqeceeqereepreetpererqeereqertrpretepertepeereqeretptreepetttpretrperrepererprereperetpertepererpereey 042 3 4 53 ff 311 2 2 vu E a 8 THRE 1 e Time Figure 36 Graph with the prices from NordPoolSpot before running the software Description The above empty graph should display the electricity prices from NordPoolSpot It is empty because the software is not running 51 Ali El Jechy Andrei Ursachi Ivan Nachev Dk1Buying IV Dk2Buying nu NordPooIDk NI Selling Buying electricity Chart NordPoolDk2 MEN 3
34. VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Project Report 2013 Smart Grid group 24 Date 13 12 2013 Authors Ali El Jechy 142528 Andrei Ursachi 142560 Ivan Nachev 126746 Supervisor Poul Veggemose VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Contents Table of figures ae ee ee 5 Glossar EEE 6 1 Abstract U 7 2 Intro cision ens 7 3 Problem formulation ui een 9 321560 9 3 1 1 lu 9 3 1 2 Out Of SCOP A m SEREESE REE SEERE 9 3 2 Technical requirements u a 9 23 Introduction to Lab View eee 9 AD 10 4 1 Smart GRID system General idea seen 10 42 Tools and device instances used aaa 11 4 3 BReg irements is En rar aN ere 11 5 Dei ea 12 5 1 Monitoring Use Case diagram ccacccascssctsncssecsesiavesssnsctacesustecsacesceassceienatesncssicensaceauseenceases 13 WAP 06110 en 13 5 1 2 Customer actor and his her use Cases DEDE hti ttti hti hath ER 14 5 2 Overview of SmartGrid systeni ua en nee 15 SE PSR EO RE RE X THE TEEN 15 35 2 2 House simulations tina racial ae sina dave aati david dats dave ca data 21 5 3 Activity diagrams and flow control in the system sese 22 5 3 1 Setting up CHE
35. an be found in the Discussion section of this report 23 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 3 2 24HoursUpdate Description The following diagram depicts the necessary steps in order for the updates to be done automatically and how the software is working Set the path for the folder that contains the bat file Type down the name of the batfile in the specific section Press run The path and the name of file must be the right ones X takes 30 seconds for the update to finish Wait for the batch file to open run the xls and close takes around 15 20 seconds for the update to be done Wait for the updates in the xls to finish Stop the 24h Update No updates will take place Minimize the main window and let the software run in the background X The software will run the update automatically on 24H based since the user presses run Figure 12 24h Update 24 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE The fully description of the installation process can be found in the appendix section of this report As soon as the necessary environment variables have been set accordingly to the installation guide the system administrator has to run the software and check if all the updates are taking place If the installation guide has been followed properly and all the updates are taking place the appli
36. ata1 Elspot Area Prices ALL HOU ly ee 67 2 Nordic power flow http www statnett no en market and operations data from the power system nordic power flow 68 3 Power flow with wind turbine and battery http www energysavingtrust org uk extension estfrontend design est flas h generate your own energy windPovwer html e 68 4 SkyStream 3 7 http www windenergy com sites all files 3 CMLT 1338 01 REV J Skystream spec pdf s rr 68 5 Review for the best solar modules for 2014 http solar panels review toptenreviews com kyocera solar panels review html 68 6 KD315GX LPB http www kyocerasolar com assets 001 5349 pdf 68 7 Homer website http www homerenergy com Pre DL html 68 8 NASA history database https eosweb larc nasa gov sse 68 9 Labview http en wikipedia org wiki LabVIEW ss 68 10 Read Excel library http sourceforge net projects fgexcel 68 11 MyDAQ http sine ni com np app main p ap academic lang da pg 1 sn n17 acad emic n21 16781 fmid 6307 fee ee 68 12 MyGrid http sine ni com nips cds view p lang da nid 210999 68 13 Battery research http www freesunpower com batteries php 68 ET RR E E E 69 1 Installation guide SmartGrid essent ntes 69 Ir
37. attery MZ 2 0 17 0 295658 0 295658 E T 3 E ow J 0 27841 027241 j ES 0 17 029628 0 29628 a Ef i os 0 315816 0315616 uS pus exu CAA gt ER 0 25 0 460119 0460119 5 037 0 731404 0 731404 EA 061 109657 125484 KE 036 6 652741 0 693092 p M 4 43 44 45 46 47 ee NCE 0 766395 0 766395 DkiBuyng MEA 13 051 0537501 0 982775 Dk2Buying ME Da E o 056018 0 986018 NordPoolDk MNA 5 E o0 J 2 16528 2 16528 Selling Buying electricity Chart NordPoo1Dk2 MENS 16 0 74 1 36587 1 53982 Kua 228 482459 509758 Eu all ss 334303 3 5828 Eu Be 242303 222215 En E 120 22757 247 noni a 2 07663 2 07663 2 6 J 252305 2 92305 2 0 61 1 06954 1 06954 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Time information regarding sky and sun Jo Months Cleammess index Daily Radiation go fianuay fus fsa February fous ias March 0455 12 44 api 40 483 393 May fosi7 7538 une oa 5 July 0 482 5 26 August 0 496 4 45 september 0 453 Joss October 0 406 15 November 04 0 76 December 0 412 0 5 Figure 43 Scenario 2 Focus points e Amount of energy produced by 4 solar modules in month July in one day red e The amount of energy stored in the battery at the end of the day blue e Noelectricity has been bought from distributor in that day orange Scenario 3 The pu
38. bove displays that there are no values in the fields before running the software In the first filed it is expected to have the wind speed m s in the second the how much electricity the wind turbine can produce kwh hour and the third field shows how much electricity is stored in the battery kwh m s Windspeed 75 83334 10 32225 lo Figure 31 Wind turbine and battery after running the software 49 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Description The picture above displays the values in the fields after running the code The data in the different fields is based on the calculations done by the algorithm Number of Solar Panels Month of the year Kwh day from Solar Panels ry ny J 0 y 0 0 Figure 32 Solar cells before running the software Description The picture above displays that there are no values in the fields before running the software The first field is a manually operated field where the system administrator must input the number of solar modules that the customer has This operation is done only once in the beginning The second filed is indicating which month of the year it is The third field represents how much the solar module s can produce Number of Solar Panels Month of the year Kwh day from Solar Panels y 12 0 704 Figure 33 Solar cells after running the software Description The picture above displays the actual values in the fields after running the software
39. cation needs to be let to run 24 7 It does not consuming any memory resources it is only notifying the batch file when time to update has come This take place every 24 hours since the system administrators run the program 5 3 3 Running the algorithm Description The following diagram depicts when the user has to run the algorithm in order to get the proper information for the algorithm to function properly 25 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Run the software Every 24 hours the user should run the system in order to get the information Wait forthe software to process allthe information Figure 13 Running the algorithm In order to get all the necessary information for the algorithm to run properly the customer needs to run Getting info from tables vi every 24 hours SmartGrid v1 0 unfortunately has to interact with the user For further ideas on how the system should work in version 2 0 consult the discussion part of this report 5 3 4 Getting and processing the information Description The following diagram pictures how the Getting info from tables vi is working and all the transformations occurred during the calculation of the prices with and without using the wind turbine and solar cells 26 Ali El Jechy Andrei Ursachi Ivan Nachev Read data from xlsm Display information about the weather forecast sun and sky conditions prices from NordPool
40. charge slower and last longer They are more expensive but you usually get what you pay for You will find this type of battery used in airplanes hospitals Further information regarding the described batteries can be found in the reference section reference 13 11 5 NordPoolSpot 11 5 1 Why exactly NordPoolSpot The reason is because this website provides very useful information regarding the electricity production prices for the next day One thing to consider is that the prices are being influenced by the weather conditions in Scandinavia For example if the production of electricity is bigger than the consumption they are being forced to drop the prices or even give it away for free This situation has been covered in the actual system Danish energy marker is being divided into two regions the one is Sjaelland and the other is Jylland In SmartGrid they are being named as DK1 Jylland and DK2 Sjaelland Prices for electrical energy from Norway Sweden and Finland are also being provided by the website 11 5 2 How did you use NordPoolSpot For the SmartGrid project the prices provided by NordPoolSpot are being used in order to calculate the distribution prices for Denmark s energy market by adding taxes regarding transportation and distribution Furthermore the system is using the prices in order to illustrate the fluctuation in time peaks off peaks and also to provide an understandable approach for the user to interpre
41. culations extracting specific data transforming double arrays into graphic representations or converting information which will later be used in the system e All instances of the Excel files sheets are being closed in the end in order to bypass an ActiveX error which the system had in the beginning This happens because LabView cannot open several instances of the same file Note each block might consist of other several coding blocks in order to fulfill their tasks The entire SmartGrid system consists of 18 blocks and each one of them can be accessed individually and run isolated from the main system They are being represented as sub VI s 8 4 Production and distribution prices i spem Figure 22 Production and distribution prices The picture above depicts the phases through which the system is going in order to get the production and distribution taxes in Dkk 40 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Regarding production prices they are being extracted from the double array as an individual element afterwards converted from strings into doubles then converted to the Danish currency system and displayed again in a double array Regarding distribution prices after the production prices have been converted into Dkk additional taxes for distribution and transportation have been added An average of 1 5 dkk has been added to each KWh pro
42. d turbine and Battery Leu cnr anna natura ctn nad 42 Figure 25 Bead from excel before kaken MEAE KR nnne 45 Figure 26 Reading from excel Mer usce itt eitit desse breaker 46 Figure 27 Top down integration Bst nennen ctn rica tuse vacan aos 47 Figure 28 Integration c 48 Figure 29 Acceptance test ee 49 Figure 30 Wind turbine and battery before running the software 49 Figure 31 Wind turbine and battery after running the software 49 Figure 32 Solar cells before running the software eee 50 Figure 33 Solar cells after running the software seen 50 Figure 34 Weather information before running the software sss 50 Figure 35 Weather information running the software seen 51 Figure 36 Graph with the prices from NordPoolSpot before running the software 51 Figure 37 Graph with the prices from NordPoolSpot after running the software 52 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Figure 38 Electricity consumption before running the software ss 53 Figure 39 Electricity consumption after running the software sss 54 Figure 40 Comparison between the prices before running the software 55 Figure 41 Comparison between the prices after running the software 55 Figure 42 Scenario ee u ee
43. duced For further information regarding taxes please consult the appendix section of this report Appendix 2 Path Number of Solar Panels 16 solar panel efficienc Furthermore another conversion is being made each MWh is being converted into Kwh This happens because all the prices from producer are being extracted in euro MWh The conversion rate is 1Euro 7 46Dkk 8 5 Solar cells Figure 23 Solar cells 41 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE The picture above depicts all the steps in finding the amount of electricity produced by a pre set number of solar cells per day in a specific month of the year The number of solar modules are being multiplied by the size of a module in this particular case is 2 2 m The output is afterwards being multiplied with the solar cells efficiency in this case 16 as well as with the daily sun radiation index from a specific month The final result is the amount of energy produced from the solar cells For further details regarding the solar module used in this simulation please refer to the appendix section of this report Appendix 9 A detailed description and steps for the entire process of extracting the amount of energy produced can be found in the design section of this report named Energy produced by the solar cells 8 6 Wind turbine and battery Figure 24 Wind turbine and battery The picture above depicts how the syst
44. e i Infonrmatinn xlsm Run the file every 24 hours in order to get the required information Check all the information regarding the prices weather forecast consumption and other statistics information graphs prices to pay savings etc these are the temporary steps that the system administrator has to follow Further implementation of the software will follow and the user guide will be changed accordingly 2 Energy facture 73 VIMDA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE stjysk Energi Knudsminde 10 8300 Odder CVR nr 64645013 Tlf hovednummer 8780 1177 Fax 8780 1199 Tlf vedr elregningen 8780 1188 i www oestjvsk energi dk maile oestjysk energi dk Kontortid Hverdage kl 8 00 15 00 Q Ostjys k En e rg i Opg relse med aconto Aconto opkr vning for perioden 01 08 13 31 08 13 Opg relse for perioden 01 06 13 31 07 13 Installationsnummer 373 kWh kr 1 89 pr kWh abonnement kr 66 88 707 kWh kr 1 91 pr kWh abonnement kr d 431 61 33956 Lysterilund 47 8355 Solbjerg Kontraktnummer 30676 Bel b El Lokalenergi Forsyning A S CVR 25567714 314 04 DKK El stjysk Energi Net A S CVR 25706900 1 168 62 DKK lalt 1 482 66 DKK Opkr vet aconto forbrug 14 06 2013 for perioden 01 06 13 30 06 13 724 50 DKK 1 aconto rate 770 14 DKK I alt til betaling 1 528 30 DKK Forbrugsudvikling 2012 2013 2011 2012 2010 2011 Forv rsforbrug
45. ected to the system system Solar cells The user should be ableto Have an illustration of Pass see that an instance of solar modules solar cells is being correctly connected to the Figure 32 amp Figure 33 connected to the system system Battery The user should be ableto Have an illustration of Pass see that an illustration of a a battery connected battery is correctly to the system Figure 30 amp Figure 31 connected to the system Weather information Verify that the user can see Get the weather Pass the weather forecast for forecast from the the next 2 days internet temperature weather condition wind speed and Figure 34 amp Figure 35 wind direction o 7 i Prices from Verify that the user gets Get the prices for Pass NordPoolSpot the information regarding electricity from production electricity NordPoolSpot Figure 29 Acceptance test Windspeed m s Electricity Verify that the user willbe Getinformation about Pass consumption able to get information electricity regarding average consumption electricity consumption for Figure 38 amp Figure 39 October Comparison between Compare the prices ofthe Compare the prices in Pass energy prices electricity in a graph when a graph the system is using renewable energy sources Figure 40 amp Figure 41 and when it is not using IEEE x EE Figure 30 Wind turbine and battery before running the software Description The picture a
46. ed electricity Solar cells Battery House hold Savings Wind turbine quawAeg NordPoolSpot ODD y o ve WA Destributor Figure 1 Smart GRID System Overview The sketch above describes the principle behind SmartGrid software The main idea behind the SmartGrid v 1 0 is to save money by lowering the consumption of electricity in a house This is done by using the renewable energy provided by the sun modules and or wind turbine These appliances are accessible on large scale to those who are interested in using green energy sources SmartGrid 1 0 is using both solar cells and a wind turbine to produce electrical energy The acquired production is being used to cover the consumption from the household every hour If the production is bigger than the consumption at a specific time the excess is being stored in the battery for later usage On the other hand if the production is less than the consumption the needed electricity to cover the usage is being bought from the distributor The system also gives the ability to compare the production and distribution electricity prices in Denmark as well as the money the user was supposed to pay Furthermore the system is providing information regarding how much money the customer saved for a specific day and since he installed the system 10 Ali El Jechy Andrei Ursachi Ivan Nachev 4 2 via UNIVERSITY COLLEGE Tools and device instances used In o
47. em is working regarding lowering the energy bought from the producer by using the energy provided by the wind turbine and the energy stored in the battery As soon as the energy provided from the solar modules is being stored in the battery the process of lowering the consumption begins In terms of coding it consists in several cases e If the production from wind turbine is bigger than the consumption at a specific time the household will use as much energy it needs from the turbine and the excess is being stored in the battery for later usage The price for energy the customer has to pay for that hour will be 0 e If the production is less than the consumption the system will check the amount of energy stored in the battery e Ifthe amount of energy stored in the battery is 0 the household will use all the energy provided by the wind turbine at that hour and the necessary will bought from the distributor e If there is energy stored in the battery system will check whether the production and the energy stored is enough to cover the consumption for that hour If this is not enough the rest will be bought from the distributor 42 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE In the end the system will display the amount of money spent from buying from distributor for energy for each hour If the production and the stored energy in the battery is enough to cover the consumption for that hour the price will be 0
48. ency DKK The consumption is being displayed as KWH Note 2 by having two columns in each table the user is able to see the difference in prices for both regions in Denmark Jylland first column and Sjaelland second column Ali El Jechy Andrei Ursachi Ivan Nachev 5 2 1 6 Prices for energy consumed Dk1 consumption NRGI the provider Dk2 consumption NRGI 29 DK1 with turbine and battery AA Prices for electricity with and without Turbine and Battery DK2 with turbine and battery 59 PATPRPETSEPSEUNLURTEJEFTULERLUDEFFELTTTULLFELLELERPERDELTEPELETETLETERL DET Ot 2 Bu 7 6 M 38 1790 20 1223 Time Figure 9 Prices for energy consumed The graph displayed above is showing a comparison between the prices for energy consumed e Dki consumption NRGI is displaying the amount of money the user was supposed to pay for electricity without using any renewable energy if he is living in Jylland e Dk2 consumption NRGI is displaying the amount of money the user was supposed to pay for electricity without using any renewable energy if he is living in Sjaelland e Dk1 with turbine and battery is displaying the actual price for the energy consumed if the user is living in Jylland 20 VIADA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE e Dk1 with turbine and battery is displaying the actual price for the energy consumed if the user is living in Sjaelland Note the graph is displaying the prices for the consump
49. f houses 2 houses consumption 83 Figure 62 Photo of cluster of houses simulated on the myGrid hardware 3 houses Fe SJ g EEE 83 Figure 63 Software simulation for cluster of houses 3 houses consumption 84 Figure 64 KD315GX LPB specifleations uuunsmmmsmeimnmmeinsivnvvvdvnandtnnenknanednet 85 Figure 65 SmartGrid system block diagram eene 86 Glossary e bat refers to openFile bat e xlsm refers to information xlsm e unit block refers to sub Vi e virefersto executable file from LabView VIA Ali El Jechy Andrei Ursachi Ivan Nachev NIVERSITY COLLEGE 1 Abstract The purpose of this project is to depict all the steps done in order to create a powerful tool which has the main purpose to lower the electrical energy facture of a house The main idea behind this project was how to spend less money on electricity bills and how renewable energy sources such as wind and sun can be an aid in fulfilling this task By combining energy provided by a wind turbine and a number of solar modules the system can predict the amount energy bought from the distributor for the following day based on the consumption and stored energy from today plus the self produced energy circumstances for tomorrow 2 Introduction This project is part of the Bachelor thesis The developers are three ICT students in a group who have been assigned to cooperate in a way to come up with a solution for a give
50. from the user 13 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 1 2 Customer actor and his her use cases The user will be prompted only with graphical and statistical information and therefore no further actions are required from the user The following use cases 1 2 10 11 Get weather forecast for 2 days The user will get the Weather automatically for the next 2days from the excel file Red Electricity produced from wind turbine on hourly basis The Customer will get the value of electricity produced from the wind turbine Production from solar cells on daily basis The customer will get the values of the electricity produced from the solar cells Prices from NordPoolSpot for the next day The customer will be able to see the prices from NordPoolSpot on a graph for Jylland and Sjaelland Green Consumption for a household on hourly base for number of houses The customer will be able to see the consumption for his household in a table named Consumption The amount of money the user has to pay on each hour for the electricity bought from distributor Black Battery storage status The customer will see how much electricity stored in the battery in the label called Battery Brown Saving money how much the user saved today in total The customer will be able to see how much saved daily in a label Saving for today and the value will increase
51. g converted from euro MWh to dkk K Wh in order to be more accessible and understandable Kwh is the standard unit for electricity consumption To find out an approximate price for the KWh bought from the energy company an average of 1 5dkk has been added to each KWh produced For further details regarding the taxes for transportation and distribution consult the Energy facture which can be found in appendix section appendix 2 In the end the customer will be able to check the production and distribution prices of electricity for his region in dkk KWh 5 3 6 Battery and wind turbine The following diagram depicts the flow of how electricity is being produced and stored at a specific hour and how the system is helping in reducing the amount of electricity bought from the distributor 30 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Read information from xism Display the weather forecast and the household consumption Calculate the amount of energy produced by the wind turbine if Consumption gt Production if Consumption lt Production Chech the energy level in the battery If Consumption lt Production Battery if Consumption gt Production Battery Store the excess in the battery But necessary electricity from the provider Calculate how much money the user has to pay for electricity Figure 16 Battery and wind turbine As soon as the
52. g values e Applying the function in terms Applying of wind turbine power capacity function e Get the amount of kwh h the wind turbine can produce Figure 27 Top down integration test 47 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Weather forecast Figure 28 Integration test The picture above depicts how the two units black are communicating in order to get the output of the wind turbine in kwh h red Note after each unit block passed the Unit test they have been connected in order to work as a group For an overall image of how each unit block is connected and communicating with each other please refer to the appendix section of this report Appendix 10 Note the purpose of the acceptance test depicted above is to illustrate how each connection and communication between each unit block from the system has been tested 9 3 Acceptance test The customer of the program does the acceptance test The purpose of this test is for the user to see if all the features are being fulfilled 48 Ali El Jechy Andrei Ursachi Ivan Nachev VIA UNIVERSITY COLLEGE Test case Test case description Expected Pass Fail Figure 36 amp Figure 37 prices for the following day Wind turbine The user should be ableto Have an instance ofa Pass see that an instance of a wind turbine wind turbine correctly connected to the Figure 30 amp Figure 31 conn
53. he end the user can see how much money he has to pay to the distributor and the amount of money saved on the specific day plus how much money he saved since he installed the system Detailed explanation of the algorithm The idea behind SmartGrid is to lower as much as possible the cost of electricity for a household This is being done by using the energy produced either by the solar cells and wind turbines or by the stored energy in the battery In first case the system will check if the produced energy by the wind turbine is enough to cover the consumption of the household at a specific hour If the produced energy is bigger than the consumption the excess is being stored in a battery for later usage If the consumption is bigger than the production the system will check how much energy is being stored in the battery then it will use all the produced energy at that specific time plus the energy stored in the battery to cover all 28 COLLEGE VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE the consumption for the household at that time If this is not enough the household will have to buy the necessary amount of energy from the distributor in order to cover its consumption Regarding the energy coming from the solar cells the electricity produced in the specific day is being stored in the battery in order to be used next day to lower the consumption A detailed version of this approach can be found in the Discussi
54. i Ivan Nachev UNIVERSITY COLLEGE Delimitations e The simulation is going to be a desktop application e Basic GUI e When calculating the algorithm dynamic economy and production prognosis won t be taken into account e It will not include any storage capacity batteries to store electricity e No laws or legislation will be taken into account e Used information for simulation might not correspond to real ones Choice of model and method Project management method e SCRUM o SCRUM allows an agile approach to the project thus enabling each of the team members to work on different tasks simultaneously System development method e AUP Agile unified process o The agile unified process consists of certain phases that have to be carried out during the creation of the system These phases will allow the group to focus on the correct tasks at the correct time Operating system e Microsoft Windows 8 and Macintosh OS X Tools used e LabView 2010 e Microsoft Excel e Microsoft Access Database e Dropbox Test strategy The solution needs to be tested by some who has not been concerned in this project someone who can just read the user manual and then will try to use the solution afterwards Of course the development team will test the ready product constantly 90 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 91
55. iagram User eerte tentent 13 Figure 3 Features of the SmartGrid system u 15 Figure 4 Savings and Sx Perit m nesnnninamemmmnnideeienneaasadskebeaeet 16 Figure 5 Solar and wind turbine production eene 17 Figure 6 Solar radiation and sky condition eene tete 18 Figure 7 Production arid Distribution prices ummusmsesmsnsumemnvnevrnvnvnndvnsnsedsentsaee 19 Figure 8 Consumption of a household plus prices seen 19 Figure 9 Prices Tor energy consimel zu e astutia nie ci taxa a RARE eee 20 Figure 10 House simulation 21 Figure 11 Set ng Up The Sysen zu aaa centenarians 22 Figure 1224h Update ee ee 24 Figure 13 Running the algorithm isisisi aaan 26 Figure 14 Getting and processing the information svvevevresrerserrersevsersevrerserserseeersersersees 27 Figure 15 Production distribution prices in Denmark eee 29 Figure 16 Battery and Wind tUrbineueemmnsmnsvnnnenvnmvnjvninddakssbasnsenekatedkek 31 Figure 17 Energy produced by the solar cells 33 Figure 18 Household simulation uns erne ttai a ERAN RR CER ACE 35 ig RDUM A 37 Figure 20 Cluster of houses simulation u 38 Fisure 21 Smart rid overview ea un aix un UU edu ED a HR Rn s tr CE DRESS 39 Figure 22 Production and distribution prices eene 40 Figure 23 Solat Cel e 41 Figure 24 Win
56. lar modules connected to the system e Month of the year indicates which month of the year is being selected in the current system e KWh day solar modules illustrate the quantity of electricity the solar cells produced in a specific day e Wind speed m s indicating the converted wind speed from km h to m s e KWh hour illustrating the output of electricity produced by the wind turbine per hour e Battery indicating the amount of energy stored 5 2 1 3 Solar radiations and sky conditions 17 EN BER fra Ali El Jechy Andrei Ursachi Ivan Nachev Information regarding sky and sun j Months Cleamess index Daily Radiation February 10445 ha o T 1777 FN mm oa ine oar 35 d le 526 August 0 496 4 45 Figure 6 Solar radiation and sky condition The tabled displayed above is showing the conditions for producing solar energy Each month of the year has a specific clearness index percentage of clear sky and daily sun radiation percentage of how effective the sun radiation is Based on this table and on the number of solar modules connected the system is calculating the output of solar energy produced per day in a specific month of the year 5 2 1 4 Production and Distribution prices Dk1Buying Dk2Buying Bad NordPoolDk MEN Selling Buying electricity Chart NordPoolDk2 MEN PIUCe UeeeqeeeepeeeequerepUretqereegeettpertepertepiertgorergeetepetetperes 9 10 11 12 13 14 15 16 17 18 Time 18 VI
57. n case The main goal of the project is how to create an algorithm that simulates and lowers the energy consumption in a household In terms of electricity production the focus is set on renewable sources such as sunlight wind waves or geothermal heat Electricity companies from Denmark are emphasizing on converting the wind power into electrical power Furthermore house owners started to mount solar cells to produce their own electricity in order to buy less from the electricity companies But this comes at a risk for example if the owner is producing too much of its own electricity and the electricity companies are not able to sell the proper amount the price for electrical power is increasing considerably Otherwise instead of saving money they spend more In terms of household appliances better and more sophisticated equipment is being used From washing machines to dryers and electrical cars each device is using a big amount of electricity The bigger quantity of electricity used the more money has to be paid Furthermore the price for electrical power is fluctuating therefore the money spent The system should predict the amount energy bought from the distributor for the following day based on the consumption and stored energy from today plus the self produced energy circumstances for tomorrow The following sections of this report illustrate how the system has been implemented The analysis part consists of the general idea behind
58. n instance of KD315GX LPB solar module has been used to simulate the production of a number of modules in a specific day of the month All the production from the solar cells is being stored in the battery for later usage because no laws were taken into consideration in choosing the model for the system The solar module was picked based on a research done by TechMedia reference 5 The example used was chosen because of its technical specification and output 62 VIA Ali El Jechy Andrei Ursachi Ivan Nachev NIVERSITY COLLEGE The size of a module is 2 2m and the efficiency is around 16 For further information please refer to the appendix appendix 9 or in the reference section reference 6 11 4 Battery 11 4 1 Why battery The battery was chosen in order to store the excess of energy produced by the wind turbine per hour and to store the energy produced by the solar modules per day The main focus point of the SmartGrid v 1 0 was to find a way to lower the prices for electricity facture therefore not many resources have been spent in finding a way to store energy 11 4 2 How did you used The instance of the battery used has infinite capacity and a power loss of 40 The purpose behind using the battery is giving an idea of the user how a real battery can be used in real life Note the instance of the battery is purely fictional Note no selling electricity has been considered during the development of this project
59. n the ism fil Only for the first time when administrator opens the xlsm file Right click on the bat file gt edit as administrator gt set the path to the xlsm file ifthe slsm file didn t opened Run the batch file X takes 30 seconds to open update save and close the xism file This step has been explained in detail in 24HoursUpdate activity diagram Open 24HoursUpdate vi and set the proper settings Si Open Getting Info from et de pete for tables vi the Information xlsm if any errors occured continue from where the error is stated and set the proper path c y s have been displayed This is only for the first time when the administrator is setting up the system Figure 11 Setting Up The System Due to the detailed description of the whole process which can be found in the appendix the diagram does not need further explanations 22 Ali El Jechy Andrei Ursachi Ivan Nachev VIR VERSITY COLLEGE Approach explanation This approach has been chosen for several reasons which can be stated as following The openFile bat file has been used in order to open and close the xlsm file without any human interaction The idea behind this software is to have no actor interaction with the system as soon as it has been installed properly The bat file is called every 24H from the 24HourUpdate vi and without this file the automatically updates from xlsm are
60. n xlsm e bat represents openFile bat e yi represents the executable files from Labview software exe in the same directory on the server computer Open openFile bat right click on the file gt edit The following information should be displayed 69 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE echo off start C Users AndreiUrs Dropbox BachelorProject Andrei Code Information xlsm timeout t 30 taskkill IM excel exe exit Figure 45 Batch file code 5 Change the path from start accordingly so it will open the Information xlsm file start C Users AndreiUrs Dropbox BachelorProject Andrei Code Information xlsm E g start C MyGrid Information xlsm 6 Start the Information xlsm and enable content so it will connect to the internet in orer to download update the necessary files a tab will pop up for the first time when someone is running the file D5 C f 43km h l A B c mum 1 Date Weather Description Temp C 2 Thu 5Dec Cloudy skies in the morning light rain or sleet showers for the rest of the day Very windy eHigh 6 oC WNW at 3 Details Low 2 oC 54km h 4 Fri 6 Dec Light sleet or snow during the day Partly cloudy skies late at night Windy High 3 oC WNW at Details Low 0 oC 6 Sat 7 Dec Partly cloudy skies Windy especially in the morning High 2 oC NW at 7 Details Low 1 oC 29km h 8 Sun 8Dec Light sleet or snow during the day Chance of rain during the night
61. not possible without any user interaction with the system The Information xIsm is a Microsoft Excel file which is storing all the necessary information for the software to work properly information such as 7 days weather forecast Denmark s production electricity prices an average estimation for consumption of a household in month October and an average estimation of the sky clearness and the daily Sun radiation for each month from 2012 Through the xlsm file the information regarding the weather forecast and the prices is being updated automatically as soon as the file is being opened The 24hourUpdate vi is a unit block which is calling the openFile bat every 24 hours Through this file the updates are done automatically without any user interaction As soon as the installation has been completed and no errors have occurred the system administrator has to run the 24hourUpdate and minimize it The software has to run in the background and no user should have access to it By closing this application the cycle will stop and no updates will be done until its running again Being the version 1 0 of the Smart Grid the setup for the system might be too complex for the common user with no IT knowledge which is why a system administrator is necessary to set up all the environmental settings Not so many resources have been allocated to facilitate the installation Further information and ideas regarding the set up system of SmartGrid c
62. nsumption 66 VIA VERSITY COLLEGE Ali El Jechy Andrei Ursachi Ivan Nachev By implementing both algorithms explained above you can determine which one is best for lowering and balancing the costs at the same time The maximum efficiency of the system will be achieved 12 Conclusion SmartGrid v 1 0 represents a great step as a tool that simulates how electricity factures can be reduced and predicts the amount of money spent for buying electrical energy from distributor for the following day The prediction is handled by an advanced algorithm that takes into consideration energy production prices from Denmark weather forecast for a specific city Horsens sky index of clearness and daily sun radiation for a specific region 55 50 N 9 50E as well as the consumption of a household from this area The output of this algorithm is a prediction of the energy bought from the distributor for the following day based on the consumption and stored energy from today plus the self produced energy circumstances for tomorrow The features that SmartGrid software includes are Weather forecast for the next two days Denmark s production and distribution prices for electricity for the next day Household s consumption on hourly basis The amount of energy produced by the wind turbine per hour The amount of energy produced by the solar cells per day Battery storage facility the excess of energy produced by the renewable sources can be st
63. o familiarize and facilitate the understanding of the system 5 2 1 SmartGrid 15 2r LLEGE via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Due to the big size of the Graphical Interface the system will be presented in blocks 5 2 1 1 Savings and expenditures SMART GRID For our Household How much supposed to pay 31 5945 How much to pay for today 16 7697 Saving for today 14 2559 Saving in total 0 Figure 4 Savings and expenditures The picture depicted above displays e How much the user supposed to pay to the distributor for the electricity he used for that day e How much to pay for today for the electricity bought from the distributor if the production and battery cannot cover the consumption If the production and savings are enough to cover the consumption for that day the user does not have to pay anything to the distributor e Savings for today the amount of money the user saved for the specific day by using the renewable energy e Savings in total the amount of money the user has saved since he installed the system 5 2 1 2 Solar and wind turbine production 16 VIADA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Number of Solar Panels Month of the year Kwh day from Solar Panels 94 gi 0 704 Windspeed m s KWh hour Battery 5 83334 0 32225 0 Figure 5 Solar and wind turbine production The picture displayed above illustrates e Number of So
64. o simulate in real time which house is using electricity at a specific time Please refer to the appendix section for picture illustration of the software and hardware working together Appendix 8 The simulation is working on two levels the first one requires a user input in choosing which household to use electricity at a specific time the second one is based on random principle and it is automatically done by the software Note the equivalent of a 24H day in the simulation is 24 seconds real time A new day is being recorded for each 24 seconds of simulation 35 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 6 Purpose The purpose of this project is to create a viable algorithm that simulates the produced bought electricity in order to lower the electricity facture of a household 7 Delimitations e The simulation is going to be a desktop application e No laws or legislation are taken into account e Non real renewable energy sources devices have been used e Non real storage facility device has been used e Electric car 8 Implementation This part of reports contains print screens of the blocks of code sub VI used to implement SmartGrid 1 0 Due to the complexity and the size of the system only the most important parts will be explained The entire system and the main units have been explained earlier in the Design part of this report Color explanations of the implementation e Green Boolean
65. on for cluster of houses 2 houses consumption Figure 62 Photo of cluster of houses simulated on the myGrid hardware 3 houses consumption 83 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE File Edit View Project Operate Tools Window Help EG House2 House 3 Figure 63 Software simulation for cluster of houses 3 houses consumption 9 KD315GX LPB 84 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Module Specification Module Type Voc pm Number CAS Thermal Characteristics Temp Coefficient Voc VIC Isc_ A C 54040 Vpm V C Physical Characteristics 65 43 1662mm 51 97 1320mm Depth 1 817 46mm Weight 60 61b 27 5kg Diameter 28 7mm Quantity 4pcs Figure 64 KD315GX LPB specifications 10 martGrid system block diagram 85 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Month of the year Selling Buying electricity Chart Boe Householdipayment Kwh day From Solar Panels output array Informatibn regarding sky and sun E i23 Prices for electricity with and without Turbine and Battery El weather How much to pay for today Winds m s Cy Saving for today KWh hour Consumption Saving in total Ipeul error in ee error out Time of
66. on part of this report 5 3 5 Production Distribution prices in Denmark The following diagrams display the flow in calculating the distribution prices for a household in Denmark All the data for NorPoolspot market is for the entire Scandinavia Read information from xlsm Danish energy market is being divided in two Jylland and Sjaelland Extract the necessary information for the Danish energy market All the prices are being extracted as Euro MWh These prices are being converted into Dkk MWh Converts the prices accordingly to danish curency and household consumption capacity An average of 1 5dkk is being added for each MWh produced These are the transportation and distribution taxes Add the transportation and distribution taxes Displays the prices for energy in Dkk KWh with and without taxes Figure 15 Production distribution prices in Denmark 29 via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE NordPool is providing information regarding the whole Scandinavian energy market appendix 3 These information are being extracted on daily basis by the xlsm The system extracts only the information regarding the Danish energy market which is divided in two Jylland and Sjaelland The prices are being extracted as euro MWh The software covers both regions As soon as the necessary data is being extracted the prices are bein
67. ored in a battery for later usage Daily sun radiation as well as sky index of clearness e Comparison between the money supposed to be paid each day before and after using renewable energy e The amount of savings each day as well as the amount of savings since the system has been installed The greatest benefit of this software can be the easiness in modeling the user interface accordingly to each customer s preferences as well as easy scalable meaning more than one household can be connected to the same system at a time Based on the above mentioned arguments and features SmartGrid is a great tool that combines renewable energy sources in order to lower the electricity facture 13 References 1 NordPoolSpot http nordpoolspot com Market datal Elspot Area Prices ALL1 Hourly 67 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 2 Nordic power flow http www statnett no en market and operations data from the power system nordic power flow 3 Power flow with wind turbine and battery http www energysavingtrust org uk extension estfrontend design est flas h generate your own energy windPower html 4 SkyStream 3 7 http www windenergy com sites all files 3 CMLT 1338 01 REV J Skystream spec pdf 5 Review for the best solar modules for 2014 http solar panels review toptenreviews com kyocera solar panels review html 6 KD315GX LPB http www kyocerasolar com assets 001 5349 pdf d
68. osoft Excel features such as automatic extracting updating when the file is being opened and saving which are essential for the system 11 9 2 How did you use Microsoft Excel As in the above section was explained the features of excel were exactly for the needs of the developers The simplicity of the data extraction and updating helped the team to save a lot of time and resources 11 10 The algorithm used 11 10 1 Description The algorithm used is based on the consumption of the household As long as the production is bigger than the usage the excess is being stored in the battery and the costs for electricity for that hour will be equal to 0 If the consumption is bigger than the production the system will use the necessary amount of electricity to cover the usage from the battery If this is not enough then the household will buy the necessary energy from the distributor The explained algorithm is efficient if the household has a low to medium energy consumption 11 10 2 Improvement An idea of how to improve the system might be to create a second algorithm that will focus on the provider s prices as well as the peaks and off peaks For example it could buy energy as long as the price is lower than the average for that day meanwhile storing the produced energy in the battery and using it when the prices for electricity are exceeding the average price for that day This suggestion would be effective for a medium to high energy co
69. r storing the produced energy How and when to store the produced electricity e Connect a system of solar cells to the system e Add an electric car e Money invested in wind turbine and solar cells e Political and Legislation aspects For further details regarding the initial purpose of this project please refer to the Project Description section found in the appendix of this report Appendix 9 3 2 Technical requirements In order to run the software the customer will need e Operating system Windows 7 or later e LabView executable software e Microsoft excel software 2010 or later 3 3 Introduction to LabView This is a short description of the LabView software LabView short for Laboratory Virtual Instrument Engineering Workbench is a system design platform and development environment for a visual programming language from National Instruments The graphical language is named G Originally released for the Apple Macintosh in 1986 LabView is commonly used for data acquisition instrument control and industrial automation on a variety of platforms including Microsoft Windows various versions of UNIX Linux and Mac OS X reference 9 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE The reason behind choosing this software in order to develop and fulfill all the requirements can be found in the discussion part of this report LabView 4 Analysis 4 1 Smart GRID system General idea Self produc
70. rder for the system to operate adequately the user s must have either a wind turbine or solar cells installed to his their house s Illustrations of a wind turbine SkyStream 3 7 and a number of solar modules KD315GX LPB have been used for software simulation For simulating a cluster of houses and the energy usage in each one of them myGrid and my DAQ have been used MyDAQ is a data acquisition device that gives the opportunity to measure and analyze live signals Reference 11 The myGrid by Elenco is an AC power grid for NI myDAQ that equips students to investigate the components of a power grid It interfaces with NI myDAQ to demonstrate power monitoring using a motor and a solar panel for three houses The system includes a traditional power source through a motor representing fossil fuels and a renewable power source using a solar panel It models how power is generated transmitted and distributed in a residential setting across three houses Reference 12 4 5 Requirements Requirements Expected results How to create an algorithm that lowers the amount of electricity bought from the distributor to be used in a house Done by figuring out an algorithm that lowers the electricity bought from the distributor From where and how to get the prices of the electricity Done the prices have been taken from NordPoolSpot The data was put in a excel file How to get the weather forecast implemented in the sol
71. rpose of this scenario is to display the prices of electricity on different consumption circumstances 59 Ali El Jechy Andrei Ursachi Ivan Nachev NI Y C Parameters e Wind speed 7 22 m s e 4 solar modules month December e Battery storage 2 89 KW Getting info from tables vi Front Panel 8 File Edit View Project Operate Tools Window Help gt 11 10pt Application Font For er EMI E Number of Solar Cells Month of the yearKwh day from Solar Panels 24 2 0 704 SMART GRID me m Em 722223 0 56166t 0 169001 For our Household How much supposed to pay Weather forecast 39 5724 g o JwexneDescipion Temp C 1 How much to pay for today go fwed 11 Dec Chance of rain earlyin High 8 oC WSW at 10 2822 ess oe oe iein o o Saving for today Thu 12Dec Partly cloudy skies High 7 oc SW at 28 7993 ess flowsoc fak Saving in total 52 6486 Dk1 consumption NRGI Consumption Dkk to pay using Turbine and Battery Dick to pay for today only from the plovider Dk2 consumption NRGI a TEDSD FS ra Ero DK with turbine and battery Eu EN ose osanna Prices for electricity with and without Turbine and Battery DK2 with turbine and battery EE ER ozan 0260975 E ED fo 0 278852 0 278852 o fo 0 385998 0 385998 Ban 106038 1 06038 o fo 0 357047 0 957047 o fo 0 434889 0434889 o ER 041346 0473136 0
72. scenario is to illustrate a how the wind turbine is working in order to lower the costs of electricity bought from the distributor Parameters e Wind speed 7 22 m s e No solar modules involved e Empty battery 56 Ali El Jechy Andrei Ursachi Ivan Nachev ry C a Getting info from tables vi Front Panel ES File Edit View Project Operate Tools Window Help ATEM EE M 10pt Application Font v lov I EIE v 9 se 9 3 Number of Solar Cells Month of the yearKwh day from Solar Panels 0 0 Windspeed m s KWh hour Battery vio 7 22223 0 56166t 0 For our Household How much supposed to pay Weather forecast Beer 31 6488 90 Pate Weather Description Temp C How much to pay for today Jo Wed 11 Dec Chance of rain earlyin High 8 oC WSW at _ 8 59457 Details Low 6 oC 18 km h Saving for today m 12 Dec Partly cloudy skies High 7 oc sw at 22 0694 Details Low 5 oc 26 km h dps b z Saving in total 0 Dk1 consumption NRGI REB HEEAHANER X i Dk2 consumption NRGI E TOL DIUY DK1 with turbine and battery en SS i icity wi i DK with turbine and battery 0 17 0 295658 0295658 3 0 16 027241 o27841 017 029628 0 29628 0 18 0315816 0315816 LIE 0 40353458 dossuse 025 0460119 0460119 037 0 731404 0 731204 061 109657 125484 036 0 652741 0 693982 ER 78 9 30 om 13 14 15 16 17 18 19 20 21 22 23 Et 028995 0 924228 me 0 766395
73. t the taxes A side by side comparison between the prices with and without taxes is available for the user 11 6 Freemeteo com 11 6 1 Why exactly freemeteo com The reasons behind choosing this weather provider are several e Free weather forecast 64 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE e The data is easy to extract forecast is stored in tables e The forecast includes wind speed necessary for the wind turbine 11 6 2 How did you use freemeteo com The above mentioned features of the provider are suitable for this project The data regarding the wind speed is used in order to calculate the production of electricity from the wind turbine 11 7 Consumption in a household 11 7 1 Description The system is using an average statistics regarding hourly consumption of a household in month October During the research period the group took into account the size of the family inhabiting and the appliances The family depicted consists in parents and a child In terms of appliances the family possesses common appliances that can be found in any family such as washing machine dishwasher TV refrigerator microwave and electric oven The household consists of two bedrooms living room kitchen and two bathrooms Consumption from different household might be different accordingly to the number of habitants and the appliances used 11 7 2 Improvements for the next version By using only statistics
74. th a 40 loss The purpose of it is to simulate as close as possible real time conditions of using a battery For further details regarding the battery consult the Discussion section of this report Battery The final stage of the algorithm is to calculate the amount of money spent on buying electricity from the provider if necessary 5 3 7 Energy produced by the solar cells The following diagram depicts how energy coming from solar cells is being produced and stored in the battery for later usage 32 Ali El Jechy Andrei Ursachi Ivan Nachev Read information from xlsm Display data regarding sun and sky conditions Calculate the amount of electricity that is being produced per day by the solar cells Store the energy produced in the battery Figure 17 Energy produced by the solar cells As soon as the necessary data to calculate the solar cells output is being VIA UNIVERSITY COLLEGE extracted from the xlsm file the algorithm is able to predict the amount of electricity a number of solar cells can produce in a specific month of the year 33 VIA VERSITY COLLEGE Ali El Jechy Andrei Ursachi Ivan Nachev Data regarding the sky clearness index and daily sun radiation has been extracted through Homer reference 7 software from the NASA database reference 8 It is based on an average estimation from year 2012 A graph indicating the average sun radiation m day can be found in the
75. the country medium blowing wind can be felt through the entire year The wind turbine was a necessary appliance included in the system because it has constant production of energy That is why the entire system is concentrated around the hourly production of the wind turbine 11 2 2 How did you use the wind turbine In the case of this project an instance of SkyStream 3 7 wind turbine has been used because the specifications met the requirements For example the Danish law allows the customers to use a wind turbine that can produce less than 6 kwh day Another reason is the parameters in which the wind turbine is working properly wind speed Further technical information regarding SkyStream 3 7 can be found in the appendix section of this report appendix 5 Note the data simulated based on the wind turbine might be different in real life conditions Note the purpose of this simulation is to give an idea about how much energy can be produced per hour by this device 11 3 Solar cells 11 3 1 Why solar cells As the world is focusing more and more in producing renewable energy without harming the environment solar cells are being used more and more in terms of this Furthermore more and more household are being equipped with such devices This has been an important factor in deciding what type of renewable energy sources to be used in developing SmartGrid v 1 0 11 3 2 How did you use solar cells In the case of this project a
76. tion for the household on a 24 hour basis 5 2 2 House simulation Time of day House 1 House2 House 3 2 KE House House2 House 3 333 Auto Time stop Figure 10 House simulation The picture above represents the interface for the cluster of houses simulation e The three switches named house 1 house 2 and house 3 is the trigger for which house is using electricity in manual mode e The three circles named housel house 2 and house 3 it is an indicator for what house is using electricity at a specific time e The clock indicates the time of the day in hours e Auto time represents is a button to set the simulation automatically or manually e Stop button is stopping the simulation For examples how the simulation is working please refer to the appendix section of this report Appendix 8 21 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 3 Activity diagrams and flow control in the system 5 3 1 Setting up the system Description The following diagram depicts how the system administrator has to install the system in order for it to work properly A detailed version of it can be found in the Installation Guide for Smart Grid Appendix 1 The steps are being presented in detail in the installation guide the right directory Open the xlsm file enable automatically connection to the internet in the impromit window Enable automatically connection to the internet i
77. tting information from every Excel file in LabView 1 Specify the path to the workbook 2 Specify the specific sheet 3 Specify the start and the end position in terms of rows and columns 4 Press run A detailed version of the steps followed is being presented in the picture above 9 1 2 After 45 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE Det 21 Figure 26 Reading from excel after For this unit test the weather forecast extraction has been selected Note in LabView each unit block can be tested in isolation During the developing period of this project each block has been tested individually After passing the test each one of the block have been integrated in the system and communication between them have been established Note the purpose of the unit test depicted above is to illustrate how each block has been tested individually 9 2 Integration test Integration test is the phase where two or more unit block are combined and tested as a group For illustrating an integration test Weather vi and KwhDayWindmill vi have been chosen 46 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE TOP DOWN INTEGRATION TEST In this approach the highest level modules are tested first and progressively lower level modules are tested after that e Wind speed for next day Weather Forecast e Converting strings to double e Converting the km h to m s Readin
78. undart relay switch como amp mph 30 m s Wireless 2 way interface 140 mph 63 m s 5 year invited warranty Figure 55 Wind turbine specifications VIA UNIVERSITY COLLEGE SKYSTRZAM by Southwest Windpower Take Control of Your Energy Needs Designed for homes and smal businesses the Skystream 3 7 converts wind mo clean electricity you can use It s the test compact user friendly all inclusive wind generator with controls and inverter built in designed to provide quet clean electricity in very low winds Skystream 3 7 can help offset household or small business s total energy needs And because it operates at a low RPM Skystream is as quiet as the trees blowing in the wind Power WI PTE D 2 34 8 7 8 9 19 11 m 6 16 12 14 16 18 2 22 M Average Annual Wine Speec ne ce WINDPOWER www Com 4 SOUTHWEST 928 779 9463 Actual savings is based on wind speed ar the ete and many energy consumpnon Power performance tenting by WINDTEST Kame Wihetrtcog Germany November 14 20 March 22 2008 Wim Combined Standard Unconarey Reference ar density 22 koima da Priced on recycled paper wiih wegetanie irks using 100 new wind energy POs ke Ow 79 Ali El Jechy Andrei Ursachi Ivan Nachev VIA UNIVERSITY COLLEGE 6 Sky clearness index and daily sun radiation graph 10 Scaled data
79. ution Done the weather forecast was taken from freemeteo com and the data was put in a excel file When to use the stored energy from the battery Done by checking when the consumption is higher than the production When to buy energy from the distributor Done by whenever the produced and stored energy is not enough to cover to consumption Compare both cases when using self produced energy and energy from the distributor Done by displaying both cases in a graph How much a household consumes on 24h basis Done the household depicted in the system consumes around 16 kWh per day 11 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 Design The Monitoring Use Case diagram shows what kind of information will get the users that will use the program 12 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 5 1 Monitoring Use Case diagram Use Case Diagram Figure 2 Monitoring Use Case Diagram User 5 1 1 Actor The system has only one actor This actor will be able to monitor different information such as weather forecast electricity consumption and comparison between energy prices for energy bought from the distributor by using or not using the renewable energy produced There is no interaction from this side of the program The user will be prompted only with graphical and statistical information and therefore no further actions are required
80. xcel file the software is adding 1 5 dkk for 1Kwh in order to display the prices after taxes distribution price By analyzing an electricity bill from a customer in Denmark appendix 2 it was found that after adding all the transportation and distribution taxes an average price of 1 5 dkk is being add for every 1Kwh produced A detailed explanation of this process can be found in the Discussion part of this report e The software will then extract the necessary data in order to calculate the price of electricity per hour using the solar cells battery and the wind turbine e Ifthe produced energy by the wind turbine covers the consumption of the household at that specific hour the excess is being stored in the battery for later usage e Ifthe produced energy is lower than the consumption the household will use all the produced energy by the wind turbine and the stored electricity in the battery to cover the usage of electricity in the household If the consumption is not being compensated the household will buy the necessary electricity from the provider in order to cover the consumption e All the energy produced by the solar cells is being stored in the battery in order to be used the next day e Afterwards the user will be informed about the produced energy by each source individually the amount of energy stored in the battery and how much energy the household had to buy from the customer in order to cover the entire consumption e Int
81. xt based coding therefore the focus was set on solving complex system challenges such as the algorithm in lowering the costs of energy The entire system can be easily hardware simulated In this case the cluster of houses has been simulated using myGrid Illustration of the simulation can be found in the appendix section of this report appendix 8 Quickly understand the data LabView is using different colors to express the connection between different blocks At a large scale this is saving a lot of time Debugging method was used to test all the unit blocks The main reason is that all the errors have solved using this method Debugging mode represents itself a unit test Easy to model the user interface can be easily changed accordingly to the customer s preferences For example some users might not be interested in the sun and sky conditions This issue can be really easily solved Scalable very easy to expand For example the actual system will be expanded to a cluster of houses and not many changes in the design have to be done Fun graphical implementation is easy readable easy to understand and to use 61 vi VERSITY COLLEGE RDA via Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 11 2 Wind Turbine 11 2 1 Why wind turbine One of the important factors that were taken into consideration regarding this project was the main source of energy provenience for Denmark Because of the global position of
82. y from producer The first table indicates the amount of money the user has per hour for the energy bought from distributor The second one indicates the amount of money the user was supposed to pay if none of the renewable energy sources have been used orange Scenario 2 The purpose of this scenario is to illustrate the behavior of the system when the production is bigger than the consumption for the entire day Parameter e Wind speed 7 22 m s e 4 solar modules month July in order to have bigger production than consumption e Empty battery 58 Ali El Jechy Andrei Ursachi Ivan Nachev Ba Number of Solar Cells Month of the year Kwh day from Solar Panels 24 27 740608 Windspeed m s KWR hour Battery vio 7 22223 0 56166 2 89677 For our Household Hoar makk suppasei to pay Weather forecast 31 6488 J fos Weather Description frem aa How much to pay for today go JWed 11 Dec Chance of rain earlyin High 8 oC WSW at 0 Tomi owooc fiskmh Saving for today Thu 12 Dec Partly cloudy skies High 7 oc sw at 30 5792 ess flowsoc fak Saving in total 22 0694 Dk1 consumption NRGI nu Time of day Consumption Dkk to pay using Turbine and Battery Dykk to pay for today only from the provider Die consumption NRGI NM HON vay ae DK1 with turbine and battery MZ me EEA EA Prices for electricity with and without Turbine and Battery DK2 with turbine and b
83. y produced by the solar module per day is being stored in the battery for later usage For further information regarding this approach consult the discussion section of this report 5 3 8 Household simulations The following diagram depicts how the system is simulating the consumption of a cluster of composed by three houses The system is imitating on random basis the number of homes consuming electricity at a specific time 34 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE the user has the opportunity to set the automatic simulation on or off Houses will randomly turn on and off their electricity Set autotime off Set autotime on The user has the ability so set which house is using electricity m at a given time Turn on and off which house is using electricity Analyze which household is using electricity at a specific time 24seconds 24hours Figure 18 Household simulation The purpose of this simulating program is to give an idea how three houses can use the SmartGrid together therefore introducing the small community idea where all the produced energy is being stored in a common storage area battery Different houses can use different equipment to produce energy in different conditions and it is believed if the acquired electricity used in common will lower the electricity facture for each household individually The second purpose of the 24HoursHouseholds vi is t
84. y with a chance of showers during the di High 7 oC SW at 15 Details Low 1 oC 24 km h 15 essen c 17 18 a key to continue 19 20 val 22 23 24 25 26 27 28 29 30 31 M 4 gt M Weather lt NordPool Ready Figure 48 Make sure that the batch file closes the excel application 9 Open the 24HoursUpade vi 24HourUpdate vi Front Panel UNE ourUpdate vi Front Pa File Edit View Project Operate Tools Window Help D TE PE APP x Sra or SE C Users AndreiUrs Dropbox BachelorProject Andrei Code Elapsed Time s Days Passed 0 error in no error STOP line openFile bat v lt gt Figure 49 Open the batch file in LabView and check the paths 10 Change the path red accordingly so it will open the openFile bat NRZ B ago Autosum v Ap Fein zr d Sort amp Find amp Clear 7 Filter Select Editi v I J K L El rf DI 100 0 72 VIA Ali El Jechy Andrei Ursachi Ivan Nachev UNIVERSITY COLLEGE 11 12 13 14 15 NOTE Make sure that in the command line is written openFile bat blue Run the 24HoursUpdate and check if the bat files open The 24 hours update is set to open the bat file every 24 hours and update the xlsm accordingly Wait for the xlsm file to close Open the Getting info from tables vi and set the path accordingly set the path to open Information xlsm Path 3 C Users AndreiUrs Dropbox BachelorProject Andrei Cod

Project Report 2013

Contents

Download Pdf Manuals

Related Search

Related Contents