12 resultados para Excel plugin
em Dalarna University College Electronic Archive
Resumo:
This project was performed at Rochester Institute of Technology to get more understanding and knowledge about AM and FM screenings similarities and differences with considerations of the mottle. By designing a test form conformed to the specific measurements and printing it on Heidelberg's Sunday 2000 press, the project group has evaluated the questions that already existed and the ones that occurred during the project. Hence the first press run left some unexpected phenomenon therefore another press run was performed. Measurements were performed and graphs produced in Excel. The project group evaluated the results and from that able to establish facts and draw conclusions. It has been a great experience for the project group and they have learnt a lot.
Resumo:
Företaget GUTAB använder idag en frågeanalysmodul som är utvecklat i Visual Basic for Applications i Microsoft Excel. GUTAB fann det intressant att veta om modulen kunde konverteras till webbläsaren Internet Explorer samt vilken teknologi som var lämplig för detta. GUTAB var även intresserade av att veta vilken teknologi som kunde användas för att skapa grafiska manipulerbara objekt.En skrivbordsundersökning genomfördes som omfattade teknologierna ASP, ASP.NET, JSP, PHP, ActiveX samt Java applets. Skrivbordsundersökningen utgjordes av två delar där den första delen redogjorde för de två klientbaserade teknologierna ActiveX och Java applets med vilka grafiska manipulerbara objekt kunde realiseras. GUTAB ansåg att ActiveX program var mest lämpliga för detta ändamål.Baserat på skrivbordsundersökningens andra del bestämde GUTAB att ASP och ASP.NET skulle användas för att testa teknologiernas kapacitet att konvertera programlogik samt grafiska objekt från VBA-applikationen i en webbapplikation då dessa två teknologier ansågs som mest lämpliga för en konvertering.Testet som genomfördes visade att det var fullt möjligt att konvertera utvald funktionalitet med båda teknologierna. Dock kunde inte grafiska objekt skapas i asp varför befintliga objekt användes för det ändamålet. Många fördelar identifierades med ASP.NET varför GUTAB beslutade att ASP.net var den mest lämpliga teknologin att använda vid en eventuell konvertering.
Resumo:
Detta examensarbete utfördes på ABB Power Technologies i Ludvika med syfte att förenkla tillverkningen av märkskyltar till mättransformatorer.Tidigare utformades alla skyltar för hand i Excel utifrån data från ett beräkningsprogram. Det gjorde att det behövdes en mall för varje variant i varje språk vilket ledde till väldigt många mallar. På ABB ville man både komma ifrån mängden olika mallar och det tidskrävande handarbetet som dessutom kunde resultera i att skyltarna inte fick enhetligt utseende. Genom att göra ett program som automatiskt genererar skyltarna utifrån en standardmall med hjälp av en fil från beräkningsprogrammet sparas mycket tid och arbete. Den som utformar skylten behöver då bara lägga till några få data själv och kan välja språk direkt i programmet istället för att behöva skriva allt för hand.Resultatet av detta examensarbete blev ett program som används av ABB för att göra skyltar till nästan alla mättransformatorer.
Resumo:
This report discusses developing a software log tool for analysis of industrial processes. The target was to develop software that can help electro Engineers for monitor and fault finding in industrial processes. The tool is called PLS (Process log server), and is developed in Visual Studio.NET Framework 2005. PLS works as a client with Beijer Electronics OPC Server. The program is able to read data from PLC (Programmable Logic Controller), trough the OPC Server. PLS connects to all kind of controllers that is supported by the Beijer Electronics OPC Server. Signal data is stored in a database for later analysis. Chosen signals data can easily be exported into a text file. The text file is adopted for import to MS Office Excel. User manual [UM-07] is written as a separate document. The software acted stable through the function test. The final product becomes a first-rate tool that is simple to use. As an advantage, the software can be developed with more functions in the future.
Resumo:
In schools today, we expect student performances and achievements to be exceptional. Having good reading and writing skills are essential if students want to excel at their school assignments. Students with reading and writing difficulties have to work much harder than their other classmates. Their having to work harder coupled with being teenagers and facing all the uncertainties which are present at that age, these students face the difficult task of trying to find out who they are and who they want to be. In other words, they try to create their own individual identities. This study investigates the experiences of students with reading and writing difficulties in their interactions with other students and school personnel, in different situations. The collection of data has been done through group interviews. Thirteen, 15 year old students participated in these interviews. Some of the factors which characterise a hermeneutic approach have helped to form the basis on which the study lies. A hermeneutic approach suggests that the data collected is sorted and analysed to enable the identification of differences and patterns. These patterns are arranged to give results that are subjective and which also show an interpretation of the data collected. The results show that students are more comfortable with their identities, when they are diagnosed or made aware that their performances in school are directly affected by their reading and writing difficulties. The study also shows that having reading and writing difficulties tells the students who they are but, at the same time, plays an important role in their interactions with other classmates and adults. The outcomes of these interactions greatly affect the formation of their identities. The way in which school personnel treat students is also shown to be of great importance.
Resumo:
In today's society it is becoming more and more important with direct marketing. Some of the direct marketing is done through e-mail, in which companies see an easy way to advertise himself. I did this thesis work at WebDoc Systems. They have a product that creates web documents directly in your browser, also called CMS. The CMS has a module for sending mass e-mail, but this module does not function properly and WebDoc Systems customers are dissatisfied with that part of the product. The problem with the module was that sometimes it didn't send the e-mail, and that it was not possible to obtain some form of follow-up information on the e-mail. The goal of this work was to develop a Web service that could easily send e-mail to many receivers, just as easily be able to view statistics on how mailing has gone. The first step was to do a literature review to get a good picture of available programming platforms, but also to be able create a good application infrastructure. The next step was to implement this design and improve it over time by using an iterative development methodology. The result was an application infrastructure that consists of three main parts and a plugin interface. The parts that were implemented were a Web service application, a Web application and a Windows service application. The three elements cooperate with each other and share a database, and plugins.
Resumo:
To connect different electrical, network and data devices with the minimum cost and shortest path, is a complex job. In huge buildings, where the devices are placed at different locations on different floors and only some specific routes are available to pass the cables and buses, the shortest path search becomes more complex. The aim of this thesis project is, to develop an application which indentifies the best path to connect all objects or devices by following the specific routes.To address the above issue we adopted three algorithms Greedy Algorithm, Simulated Annealing and Exhaustive search and analyzed their results. The given problem is similar to Travelling Salesman Problem. Exhaustive search is a best algorithm to solve this problem as it checks each and every possibility and give the accurate result but it is an impractical solution because of huge time consumption. If no. of objects increased from 12 it takes hours to search the shortest path. Simulated annealing is emerged with some promising results with lower time cost. As of probabilistic nature, Simulated annealing could be non optimal but it gives a near optimal solution in a reasonable duration. Greedy algorithm is not a good choice for this problem. So, simulated annealing is proved best algorithm for this problem. The project has been implemented in C-language which takes input and store output in an Excel Workbook
Resumo:
Test is an area in system development. Test can be performed manually or automated. Test activities can be supported by Word documents and Excel sheets for documenting and executing test cases and as well for follow up, but there are also new test tools designed to support and facilitate the testing process and the activities of the test. This study has described manual test and identified strengths and weaknesses of manual testing with a testing tool called Microsoft Test Manager (MTM) and of manual testing using test cases and test log templates developed by the testers at Sogeti. The result that emerged from the problem and strength analysis and the analysis of literature studies and firsthand experiences (in terms of creating, documenting and executing test cases) addresses the issue of the following weaknesses and strengths. Strengths of the test tool is that it contains needed functionality all in one place and it is available when needed without having to open up other programs which saves many steps of activity. Strengths with test without the support of test tools is mainly that it is easy to learn and gives a good overview, easy to format text as desired and flexible to changes during execution of a test case. Weaknesses in test with the support of test tools include that it is difficult to get a good overview of the entire test case, that it is not possible to format the text in the test steps. It is as well not possible to modify the test steps during execution. It is also difficult to use some of the test design techniques of TMap, for example a checklist, when using the test tool MTM. Weaknesses with test without the support of the testing tool MTM is that the tester gets many more steps of activities to do compared to doing the same activities with the support of the testing tool MTM. There is more to remember because the documents the tester use are not directly linked. Altogether the strengths of the test tool stands out when it comes to supporting the testing process.
Resumo:
The aim of this study is to evaluate the variation of solar radiation data between different data sources that will be free and available at the Solar Energy Research Center (SERC). The comparison between data sources will be carried out for two locations: Stockholm, Sweden and Athens, Greece. For the desired locations, data is gathered for different tilt angles: 0°, 30°, 45°, 60° facing south. The full dataset is available in two excel files: “Stockholm annual irradiation” and “Athens annual irradiation”. The World Radiation Data Center (WRDC) is defined as a reference for the comparison with other dtaasets, because it has the highest time span recorded for Stockholm (1964–2010) and Athens (1964–1986), in form of average monthly irradiation, expressed in kWh/m2. The indicator defined for the data comparison is the estimated standard deviation. The mean biased error (MBE) and the root mean square error (RMSE) were also used as statistical indicators for the horizontal solar irradiation data. The variation in solar irradiation data is categorized in two categories: natural or inter-annual variability, due to different data sources and lastly due to different calculation models. The inter-annual variation for Stockholm is 140.4kWh/m2 or 14.4% and 124.3kWh/m2 or 8.0% for Athens. The estimated deviation for horizontal solar irradiation is 3.7% for Stockholm and 4.4% Athens. This estimated deviation is respectively equal to 4.5% and 3.6% for Stockholm and Athens at 30° tilt, 5.2% and 4.5% at 45° tilt, 5.9% and 7.0% at 60°. NASA’s SSE, SAM and RETScreen (respectively Satel-light) exhibited the highest deviation from WRDC’s data for Stockholm (respectively Athens). The essential source for variation is notably the difference in horizontal solar irradiation. The variation increases by 1-2% per degree of tilt, using different calculation models, as used in PVSYST and Meteonorm. The location and altitude of the data source did not directly influence the variation with the WRDC data. Further examination is suggested in order to improve the methodology of selecting the location; Examining the functional dependence of ground reflected radiation with ambient temperature; variation of ambient temperature and its impact on different solar energy systems; Im pact of variation in solar irradiation and ambient temperature on system output.
Resumo:
Recent developments in biological research, has shown that the initial maximum permissible exposure (MPE) limits for protection of workers from risks associated with artificial optical radiations were more stringent than needed. Using the most recent MPE limits for artificial optical radiation this piece of work was focused on the investigation of the level of visible light attenuation needed by automatic welding filters in case of switching failure. Results from the comparison of different exposure standards were employed in investigating the need of Vis/IR and blue light transmittance requirement for automatic welding filters. Real and arbitrary spectra were taken into consideration for the worst and best case scenarios of artificial optical radiations. An excel worksheet developed during the execution of this project took into consideration the exposure from different light sources and the precision of the spectrometer used in measuring the transmittances of a welding filter. The worksheet was developed and tested with known product properties to investigate the validity of its formulation. The conclusion drawn from this project was that attenuation in the light state will be needed for products with the darkest state shade 11 or higher. Also shown is that current welding filter protects the eye well enough even in the case of switching failure.
Resumo:
The work presented in this thesis concerns the dimensioning of an Energy Storage System (ESS) which will be used as an energy buffer for a grid-connected PV plant. This ESS should help managing the PV plant to inject electricity into the grid according to the requirements of the grid System Operator. It is desired to obtain a final production not below 1300kWh/kWp with a maximum ESS budget of 0.9€/Wp. The PV plant will be sited in Martinique Island and connected to the main grid. This grid is a small one where the perturbations due clouds in the PV generation are not negligible anymore. A software simulation tool, incorporating a model for the PV-plant production, the ESS and the required injection pattern of electricity into the grid has been developed in MS Excel. This tool has been used to optimize the relevant parameters defining the ESS so that the feed-in of electricity into the grid can be controlled to fulfill the conditions given by the System Operator. The inputs used for this simulation tool are, besides the conditions given by the System Operator on the allowed injection pattern, the production data from a similar PV-plant in a close-by location, and variables for defining the ESS. The PV production data used is from a site with similar climate and weather conditions as for the site on the Martinique Island and hence gives information on the short term insolation variations as well as expected annual electricity production. The ESS capacity and the injected electric energy will be the main figures to compare while doing an economic study of the whole plant. Hence, the Net Present Value, Benefit to Cost method and Pay-back period studies are carried on as dependent of the ESS capacity. The conclusion of this work is that it is possible to obtain the requested injection pattern by using an ESS. The design of the ESS can be made within an acceptable budget. The capacity of ESS to link with the PV system depends on the priorities of the final output characteristics, and it also depends on which economic parameter that is chosen as a priority.
Resumo:
Syfte Syftet med studien är att analysera tillslagsprecision i fotboll och jämföra eventuella skillnader mellan juniorer och seniorer på både herr- och damsidan. Metod Totalt 30 elitspelare varav 16 herrar och 14 damer utförde tester i tillslagsprecision. De färdigheter som testades var passning och skott. Upplägget var 60 skott (30 stillaliggande och 30 halvvolley) och 80 passningar (20 stillaliggande bästa fot, 20 rullande bästa fot, 20 stillaliggande näst bästa fot och 20 rullande näst bästa fot). Testresultaten analyserades via Excel och Kinovea, där kunde medelvärden och standardavvikelser för varje testperson och testgrupp räknas ut. Resultat Resultatet visar att det endast var signifkant skillnad på ett av sex moment vad gäller tillslagsprecisionen på herrsidan. På damsidan var det ingen signifikant skillnad på något moment. Slutsatser Författarna har i denna studie identifierat en platå mellan spelare i åldrarna 16-18 år och seniorspelare vad gäller tillslagsprecision. Spelare i åldrarna 16-18 är lika bra som seniorspelare på de individuella färdigheterna passning och skott. Denna platå kan vara resultatet av för lite individuell träning, sk isolerad träning vad det gäller tillslagsprecision, på föreningsträningarna. Om föreningstränarna följer den utbildning SvFF ger dem ska endast två minuter per träning gå till varje individuell färdighet (13 st enligt SvFF). Bristen av tid för dessa färdigheter kan vara en avgörande faktor för att utvecklingen av tillslagsprecision står stilla idag.