Programa de gestió per la Pastisseria Mas

En els últims anys, el món de la informàtica ha evolucionat d'una manera inimaginable, tan a nivell de Hardware com de Software. Aquesta evolució ha donat lloc a la creació de moltes empreses dedicades a la programació, on una de les seves principals feines ha estat la realització de programes de gestió d'empreses. Moltes vegades, però, els programes estàndards no poden satisfer el total de les necessitats dels clients, sinó algunes d’aquestes i realitzar un programa personalitzat té un cost elevat. En el cas de la Pastisseria Mas de Navàs, una empresa familiar, per poder realitzar les tasques administratives utilitzen fulls de càlcul, concretament el Microsoft Excel, que permet portar els comptes d'una manera més o menys senzilla, ja que només són necessàries unes nocions bàsiques d'informàtica. El mateix passa amb les dades dels proveïdors, que les guarden en una Base de Dades del tipus Microsoft Access. Una altra de les mancances és el tema dels encàrrecs que es fa de manera manual. Per tant, l’objectiu d’aquest projecte, és realitzar un programa que els hi faciliti la seva activitat. Aquest programa els permetrà gestionar les dades que utilitzen, com la informació sobre els clients, personal, comandes... També s’ha desenvolupat una web que permet obtenir informació sobre les comandes que s’han realitzat. Aquesta aplicació està dissenyada per funcionar en l’entorn Windows XP i s’ha desenvolupat amb el compilador de CodeGear Rad Studio, concretament el C++ Builder 2009. A nivell de base de dades, he utilitzat MySQL i en el cas de la pàgina web, PHP i lamateixa base de dades. L’anàlisi i el disseny ha estat fet en UML.

Programming and analysing measurement experiments using the PicoCricket system

The aim of this project is to get used to another kind of programming. Since now, I used very complex programming languages to develop applications or even to program microcontrollers, but PicoCricket system is the evidence that we don’t need so complex development tools to get functional devices. PicoCricket system is the clear example of simple programming to make devices work the way we programmed it. There’s an easy but effective way to program small, devices just saying what we want them to do. We cannot do complex algorithms and mathematical operations but we can program them in a short time. Nowadays, the easier and faster we produce, the more we earn. So the tendency is to develop fast, cheap and easy, and PicoCricket system can do it.

Traducción técnica del capítulo III del libro Advanced Data Warehouse design: from conventional to spatial and temporal applications

The proposal to work on this final project came after several discussions held with Dr. Elzbieta Malinowski Gadja, who in 2008 published the book entitled Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications). The project was carried out under the technical supervision of Dr. Malinowski and the direct beneficiary was the University of Costa Rica (UCR) where Dr. Malinowski is a professor at the Department of Computer Science and Informatics. The purpose of this project was twofold: First, to translate chapter III of said book with the intention of generating educational material for the use of the UCR and, second, to venture in the field of technical translation related to data warehouse. For the first component, the goal was to generate a final product that would eventually serve as an educational tool for the post-graduate courses of the UCR. For the second component, this project allowed me to acquire new skills and put into practice techniques that have helped me not only to perfom better in my current job as an Assistant Translator of the Inter-American BAnk (IDB), but also to use them in similar projects. The process was lenggthy and required torough research and constant communication with the author. The investigation focused on the search of terms and definitions to prepare the glossary, which was the basis to start the translation project. The translation process itself was carried out by phases, so that comments and corrections by the author could be taken into account in subsequent stages. Later, based on the glossary and the translated text, illustrations had been created in the Visio software were translated. In addition to the technical revision by the author, professor Carme Mangiron was in charge of revising the non-technical text. The result was a high-quality document that is currently used as reference and study material by the Department of Computer Science and Informatics of Costa Rica.

Programa d'anàlisi d'imatges de provetes metal·logràfiques

L’objectiu del present TFM és explorar les possibilitats del programa matemàtic MATLAB i la seva eina Entorn de Disseny d’Interfícies Gràfiques d’Usuari (GUIDE), desenvolupant un programa d’anàlisi d’imatges de provetes metal·logràfiques que es pugui utilitzar per a realitzar pràctiques de laboratori de l’assignatura Tecnologia de Materials de la titulació de Grau en Enginyeria Mecatrònica que s’imparteix a la Universitat de Vic. Les àrees d’interès del treball són la Instrumentació Virtual, la programació MATLAB i les tècniques d’anàlisi d’imatges metal·logràfiques. En la memòria es posa un èmfasi especial en el disseny de la interfície i dels procediments per a efectuar les mesures. El resultat final és un programa que satisfà tots els requeriments que s’havien imposat en la proposta inicial. La interfície del programa és clara i neta, destinant molt espai a la imatge que s’analitza. L’estructura i disposició dels menús i dels comandaments ajuda a que la utilització del programa sigui fàcil i intuïtiva. El programa s’ha estructurat de manera que sigui fàcilment ampliable amb altres rutines de mesura, o amb l’automatització de les rutines existents. Al tractar-se d’un programa que funciona com un instrument de mesura, es dedica un capítol sencer de la memòria a mostrar el procediment de càlcul dels errors que s’ocasionen durant la seva utilització, amb la finalitat de conèixer el seu ordre de magnitud, i de saber-los calcular de nou en cas que variïn les condicions d’utilització. Pel que fa referència a la programació, malgrat que MATLAB no sigui un entorn de programació clàssic, sí que incorpora eines que permeten fer aplicacions no massa complexes, i orientades bàsicament a gràfics o a imatges. L’eina GUIDE simplifica la realització de la interfície d’usuari, malgrat que presenta problemes per tractar dissenys una mica complexos. Per altra banda, el codi generat per GUIDE no és accessible, cosa que no permet modificar manualment la interfície en aquells casos en els que GUIDE té problemes. Malgrat aquests petits problemes, la potència de càlcul de MATLAB compensa sobradament aquestes deficiències.

A Motion compensated filtering approach to remove sunlight flicker in shallow water images

A common problem in video surveys in very shallow waters is the presence of strong light fluctuations, due to sun light refraction. Refracted sunlight casts fast moving patterns, which can significantly degrade the quality of the acquired data. Motivated by the growing need to improve the quality of shallow water imagery, we propose a method to remove sunlight patterns in video sequences. The method exploits the fact that video sequences allow several observations of the same area of the sea floor, over time. It is based on computing the image difference between a given reference frame and the temporal median of a registered set of neighboring images. A key observation is that this difference will have two components with separable spectral content. One is related to the illumination field (lower spatial frequencies) and the other to the registration error (higher frequencies). The illumination field, recovered by lowpass filtering, is used to correct the reference image. In addition to removing the sunflickering patterns, an important advantage of the approach is the ability to preserve the sharpness in corrected image, even in the presence of registration inaccuracies. The effectiveness of the method is illustrated in image sets acquired under strong camera motion containing non-rigid benthic structures. The results testify the good performance and generality of the approach

Labor market heterogeneity and the aggregate matching function

The matching function -a key building block in models of labor market frictions- impliesthat the job finding rate depends only on labor market tightness. We estimate such amatching function and find that the relation, although remarkably stable over 1967-2007,broke down spectacularly after 2007. We argue that labor market heterogeneities are notfully captured by the standard matching function, but that a generalized matching functionthat explicitly takes into account worker heterogeneity and market segmentation is fullyconsistent with the behavior of the job finding rate. The standard matching function canbreak down when, as in the Great Recession, the average characteristics of the unemployedchange too much, or when dispersion in labor market conditions -the extent to which somelabor markets fare worse than others- increases too much.

Spatial and temporal variation of natural toxicity in cnidarians, bryozoans and tunicates in Mediterranean caves

The natural toxicity of cnidarians, bryozoans and tunicates in two caves was assessed using the Microtox® technique in spring and autumn. One cave was located in the Cabrera Archipelago (Balearic Islands) and the other in the Medes Islands (Catalan littoral). The organisms analysed were good representatives of the coverage of each Phylum in the communities; however, these Phyla are less abundant than sponges which are the dominant group in these caves. Seventy-one percent of the species of cnidarians and bryozoans analysed were toxic in one of the caves, communities or seasons, which indicates the relevance of bioactive species in these groups. The tunicate Lissoclinum perforatum was the most toxic species. Although all three Phyla had some highly toxic species, a common pattern that related the caves, communities and seasons was not found. Seasonal variation of toxicity in cnidarians and bryozoans was higher in the Cabrera than in the Medes cave. Moreover, variation in toxicity either between communities or between seasons was a common trait for most cnidarians and bryozoans, whereas tunicates remained toxic throughout communities and seasons.

Growth and externalities across economies : an empirical analysis using spatial econometrics

Recent theoretical models of economic growth have emphasised the role of external effects on the accumulation of factors of production. Although most of the literature has considered the externalities across firms within a region, in this paper we go a step further and consider the possibility that these externalities cross the barriers of regional economies. We assess the role of these external effects in explaining growth and economic convergence. We present a simple growth model, which includes externalities across economies, developing a methodology for testing their existence and estimating their strength. In our view, spatial econometrics is naturally suited to an empirical consideration of these externalities. We obtain evidence on the presence of significant externalities both across Spanish and European regions.

Public health expenditure and spatial interactions in a decentralized national health system

One of the limitations of cross-country health expenditure analysis refers to the fact that the financing, the internal organization and political restraints of health care decision-making are country-specific and heterogeneous. Yet, a potential solution is to examine the influence of such effects in those countries that have undertaken decentralization processes. In such a setting, it is possible to examine potential expenditure spillovers across the geography of a country as well as the influence of the political ideology of regional incumbents on public health expenditure. This paper examines the determinants of public health expenditure within Spanish region-states (Autonomous Communities, ACs), most of them subject to similar financing structures although exhibiting significant heterogeneity as a result of the increasing decentralization, region-specific political factors along with different use of health care inputs, economic dimension and spatial interactions

Aggregate shocks or vertical tax interdependence? Evidende from gasoline and cigarettes

[cat] Besley i Rosen -1998- van ser els primers autors en estimar empíricament la rellevància de les externalitats impositives verticals. Aquests autors varen fer-ho per al cas dels impostos sobre la benzina i el tabac, en concret, per al cas dels EEUU. Ara bé, no varen tenir en compte les diferències en el nivell de vida entre Estats: àrees amb un nivell elevat paguen menys en termes reals que àrees amb un nivell de vida baix, doncs l'impost unitari sobre la benzina o sobre el tabac no difereix d'acord amb l'Estat on l'impost s'aplica. En conseqüència, proposem que la competència impositiva vertical sigui estimada deflactant totes les variables monetàries utilitzant l'anomenat "House Price Index (HPI)", el qual està disponible al nivell dels Estats. Això genera una variable impositiva federal expressada en termes reals i que presenta variació entre Estats. Aquesta estratègia empírica ens permet diferenciar entre la interdependència vertical entre els tipus impositius federals i els estatals de shocks agregats al llarg del temps, utilitzant dades per als EEUU durant el període 1975 a 2006 per a benzina i tabac. Trobem una nivell significatiu de competència impositiva horitzontal, la qual és més elevada en el cas del tabac, però en cap cas reacció impositiva vertical. Els resultats són robustos al període analitzat.

Residual Stress Measurement on a MEMS Structure With High-Spatial Resolution

A new approach to the local measurement of residual stress in microstructures is described in this paper. The presented technique takes advantage of the combined milling-imaging features of a focused ion beam (FIB) equipment to scale down the widely known hole drilling method. This method consists of drilling a small hole in a solid with inherent residual stresses and measuring the strains/displacements caused by the local stress release, that takes place around the hole. In the presented case, the displacements caused by the milling are determined by applying digital image correlation (DIC) techniques to high resolution micrographs taken before and after the milling process. The residual stress value is then obtained by fitting the measured displacements to the analytical solution of the displacement fields. The feasibility of this approach has been demonstrated on a micromachined silicon nitride membrane showing that this method has high potential for applications in the field of mechanical characterization of micro/nanoelectromechanical systems.

Aggregate monotonic stable single-valued solutions for cooperative games

[cat] En aquest treball caracteritzem les solucions puntuals de jocs cooperatius d'utilitat transferible que compleixen selecció del core i monotonia agregada. També mostrem que aquestes dues propietats són compatibles amb la individualitat racional, la propietat del jugador fals i la propietat de simetria. Finalment, caracteritzem les solucions puntuals que compleixen les cinc propietats a l'hora.

Growth and externalities across economies : an empirical analysis using spatial econometrics

Recent theoretical models of economic growth have emphasised the role of external effects on the accumulation of factors of production. Although most of the literature has considered the externalities across firms within a region, in this paper we go a step further and consider the possibility that these externalities cross the barriers of regional economies. We assess the role of these external effects in explaining growth and economic convergence. We present a simple growth model, which includes externalities across economies, developing a methodology for testing their existence and estimating their strength. In our view, spatial econometrics is naturally suited to an empirical consideration of these externalities. We obtain evidence on the presence of significant externalities both across Spanish and European regions.

Aggregate shocks or vertical tax interdependence? Evidende from gasoline and cigarettes

[cat] Besley i Rosen -1998- van ser els primers autors en estimar empíricament la rellevància de les externalitats impositives verticals. Aquests autors varen fer-ho per al cas dels impostos sobre la benzina i el tabac, en concret, per al cas dels EEUU. Ara bé, no varen tenir en compte les diferències en el nivell de vida entre Estats: àrees amb un nivell elevat paguen menys en termes reals que àrees amb un nivell de vida baix, doncs l'impost unitari sobre la benzina o sobre el tabac no difereix d'acord amb l'Estat on l'impost s'aplica. En conseqüència, proposem que la competència impositiva vertical sigui estimada deflactant totes les variables monetàries utilitzant l'anomenat "House Price Index (HPI)", el qual està disponible al nivell dels Estats. Això genera una variable impositiva federal expressada en termes reals i que presenta variació entre Estats. Aquesta estratègia empírica ens permet diferenciar entre la interdependència vertical entre els tipus impositius federals i els estatals de shocks agregats al llarg del temps, utilitzant dades per als EEUU durant el període 1975 a 2006 per a benzina i tabac. Trobem una nivell significatiu de competència impositiva horitzontal, la qual és més elevada en el cas del tabac, però en cap cas reacció impositiva vertical. Els resultats són robustos al període analitzat.

The aggregate claims distribution of a life insurance portfolio with a pairwise positive dependence structure

The individual life model has always been considered as the one closest to the real situation of the total claims of a life insurance portfolio. It only makes the ¿nearly inevitable assumption¿ of independence of the lifelenghts of insured persons in the portfolio. Many clinical studies, however, have demonstrated positive dependence of paired lives such as husband and wife. In our opinion, it won¿t be unrealistic expecting a considerable number of married couples in any life insurance portfolio (e.g. life insurance contracts formalized at the time of signing a mortatge) and these dependences materially increase the values for the stop-loss premiums associated to the aggregate claims of the portfolio. Since the stop-loss order is the order followed by any risk averse decison maker, the simplifying hypothesis of independence constitute a real financial danger for the company, in the sense that most of their decisions are based on the aggregated claims distribution. In this paper, we will determine approximations for the distribution of the aggregate claims of a life insurance portfolio with some married couples and we will describe how to make safe decisions when we don¿t know exactly the dependence structure between the risks in each couple. Results in this paper are partly based on results in Dhaene and Goovaerts (1997)