Sistemes d'informació : ERP

El treball presentat fa l'estudi i l'anàlisi per a la implementació d'un sistema de gestió integrat ERP (Enterprise Resource Planning) a l'empresa TEXFIL, centrat únicament en solucions empresarials estàndards de paquets integrats per a la planificació dels recursos de l'empresa. Tot i que al llarg del document es fa esment de diferents fabricants de sistemes ERP, nosaltres, a petició del nostre client, ens hem centrat bàsicament en el sistema SAP R/3.

Desarrollo de aplicaciones en entornos de software libre

El projecte té com idea fonamental crear un programari que permeti la instal·lació de paquets per mitjà de la xarxa en diverses màquines que es trobin registrades en la Base de dades, i a la vegada, es tenen dos mòduls un per a l'aplicació servidor i altre per a l'aplicació client.

Compositional Data Analysis with R

R from http://www.r-project.org/ is ‘GNU S’ – a language and environment for statistical computingand graphics. The environment in which many classical and modern statistical techniques havebeen implemented, but many are supplied as packages. There are 8 standard packages and many moreare available through the cran family of Internet sites http://cran.r-project.org .We started to develop a library of functions in R to support the analysis of mixtures and our goal isa MixeR package for compositional data analysis that provides support foroperations on compositions: perturbation and power multiplication, subcomposition with or withoutresiduals, centering of the data, computing Aitchison’s, Euclidean, Bhattacharyya distances,compositional Kullback-Leibler divergence etc.graphical presentation of compositions in ternary diagrams and tetrahedrons with additional features:barycenter, geometric mean of the data set, the percentiles lines, marking and coloring ofsubsets of the data set, theirs geometric means, notation of individual data in the set . . .dealing with zeros and missing values in compositional data sets with R procedures for simpleand multiplicative replacement strategy,the time series analysis of compositional data.We’ll present the current status of MixeR development and illustrate its use on selected data sets

New Features of CoDaPack. An Userfriendly Compositional Data Package

The statistical analysis of compositional data is commonly used in geological studies.As is well-known, compositions should be treated using logratios of parts, which aredifficult to use correctly in standard statistical packages. In this paper we describe thenew features of our freeware package, named CoDaPack, which implements most of thebasic statistical methods suitable for compositional data. An example using real data ispresented to illustrate the use of the package

CODAPACK3D. A new version of Compositional Data Package

The statistical analysis of compositional data should be treated using logratios of parts,which are difficult to use correctly in standard statistical packages. For this reason afreeware package, named CoDaPack was created. This software implements most of thebasic statistical methods suitable for compositional data.In this paper we describe the new version of the package that now is calledCoDaPack3D. It is developed in Visual Basic for applications (associated with Excel©),Visual Basic and Open GL, and it is oriented towards users with a minimum knowledgeof computers with the aim at being simple and easy to use.This new version includes new graphical output in 2D and 3D. These outputs could bezoomed and, in 3D, rotated. Also a customization menu is included and outputs couldbe saved in jpeg format. Also this new version includes an interactive help and alldialog windows have been improved in order to facilitate its use.To use CoDaPack one has to access Excel© and introduce the data in a standardspreadsheet. These should be organized as a matrix where Excel© rows correspond tothe observations and columns to the parts. The user executes macros that returnnumerical or graphical results. There are two kinds of numerical results: new variablesand descriptive statistics, and both appear on the same sheet. Graphical output appearsin independent windows. In the present version there are 8 menus, with a total of 38submenus which, after some dialogue, directly call the corresponding macro. Thedialogues ask the user to input variables and further parameters needed, as well aswhere to put these results. The web site http://ima.udg.es/CoDaPack contains thisfreeware package and only Microsoft Excel© under Microsoft Windows© is required torun the software.Kew words: Compositional data Analysis, Software

Incongruence between test statistics and P values in medical papers

Given an observed test statistic and its degrees of freedom, one may compute the observed P value with most statistical packages. It is unknown to what extent test statistics and P values are congruent in published medical papers. Methods:We checked the congruence of statistical results reported in all the papers of volumes 409–412 of Nature (2001) and a random sample of 63 results from volumes 322–323 of BMJ (2001). We also tested whether the frequencies of the last digit of a sample of 610 test statistics deviated from a uniform distribution (i.e., equally probable digits).Results: 11.6% (21 of 181) and 11.1% (7 of 63) of the statistical results published in Nature and BMJ respectively during 2001 were incongruent, probably mostly due to rounding, transcription, or type-setting errors. At least one such error appeared in 38% and 25% of the papers of Nature and BMJ, respectively. In 12% of the cases, the significance level might change one or more orders of magnitude. The frequencies of the last digit of statistics deviated from the uniform distribution and suggested digit preference in rounding and reporting.Conclusions: this incongruence of test statistics and P values is another example that statistical practice is generally poor, even in the most renowned scientific journals, and that quality of papers should be more controlled and valued

The connectome mapper: an open-source processing pipeline to map connectomes with MRI.

Researchers working in the field of global connectivity analysis using diffusion magnetic resonance imaging (MRI) can count on a wide selection of software packages for processing their data, with methods ranging from the reconstruction of the local intra-voxel axonal structure to the estimation of the trajectories of the underlying fibre tracts. However, each package is generally task-specific and uses its own conventions and file formats. In this article we present the Connectome Mapper, a software pipeline aimed at helping researchers through the tedious process of organising, processing and analysing diffusion MRI data to perform global brain connectivity analyses. Our pipeline is written in Python and is freely available as open-source at www.cmtk.org.

Composition and cost of drugs stored at home by elderly patients.

BACKGROUND: Elderly people often have multiple chronic diseases, are frequently treated by several physicians, and also use over-the-counter medications. Excessive prescribing, imperfect therapeutic adherence, treatment modifications after hospitalization, and oversized drug packages result in home storage of leftover drugs, resulting in a waste of healthcare resources. PATIENTS AND METHODS: All patients aged >/=75 years hospitalized for >24 hours during a 6-month period in an urban teaching hospital in Switzerland were eligible for inclusion in a study collecting sociodemographics, medical, functional, and psychosocial characteristics. Six months later, a research nurse visited the patients at home and recorded the names, number of tablets, and expiration dates of all open or intact drug packages, and the doses actually taken. Acquisition costs of these drugs were computed. RESULTS: One hundred ninety-five patients were included (127 women; mean age 82.2 +/- 4.8 y, range 75-96). They had a total of 2059 drugs (mean per patient 10.3 +/- 6.7, range per patient 1-42), corresponding to a total cost of (US) $62 826 (mean per patient 322 +/- 275, range per patient 10-1571). Self-reported drug intake was regular for 36% of the drugs (46.5% of total costs) and occasional for 11% (6.1%), whereas 35.7% (30.1%) had been stopped during the last month. Cardiovascular drugs amounted to 36.6% of the drugs and 55.5% of the costs. None of the patients' characteristics was significantly associated with a greater number of drugs and higher costs. CONCLUSIONS: Drugs stored at home by elderly patients were worth about $320 per patient. Only about one-third of these drugs were regularly taken. In the context of resources shortage, innovative solutions should be found to reduce the waste linked with drugs stopped in previous months.

Guidelines for the Conversion of Urban Four-Lane Undivided Roadways to Three-Lane Two-Way Left-turn Lane Facilities, April 2001

Four-lane undivided roadways in urban areas can experience a degradation of service and/or safety as traffic volumes increase. In fact, the existence of turning vehicles on this type of roadway has a dramatic effect on both of these factors. The solution identified for these problems is typically the addition of a raised median or two-way left-turn lane (TWLTL). The mobility and safety benefits of these actions have been proven and are discussed in the “Past Research” chapter of this report along with some general cross section selection guidelines. The cost and right-of-way impacts of these actions are widely accepted. These guidelines focus on the evaluation and analysis of an alternative to the typical four-lane undivided cross section improvement approach described above. It has been found that the conversion of a four-lane undivided cross section to three lanes (i.e., one lane in each direction and a TWLTL) can improve safety and maintain an acceptable level of service. These guidelines summarize the results of past research in this area (which is almost nonexistent) and qualitative/quantitative before-and-after safety and operational impacts of case study conversions located throughout the United States and Iowa. Past research confirms that this type of conversion is acceptable or feasible in some situations but for the most part fails to specifically identify those situations. In general, the reviewed case study conversions resulted in a reduction of average or 85th percentile speeds (typically less than five miles per hour) and a relatively dramatic reduction in excessive speeding (a 60 to 70 percent reduction in the number of vehicles traveling five miles per hour faster than the posted speed limit was measured in two cases) and total crashes (reductions between 17 to 62 percent were measured). The 13 roadway conversions considered had average daily traffic volumes of 8,400 to 14,000 vehicles per day (vpd) in Iowa and 9,200 to 24,000 vehicles per day elsewhere. In addition to past research and case study results, a simulation sensitivity analysis was completed to investigate and/or confirm the operational impacts of a four-lane undivided to three-lane conversion. First, the advantages and disadvantages of different corridor simulation packages were identified for this type of analysis. Then, the CORridor SIMulation (CORSIM) software was used x to investigate and evaluate several characteristics related to the operational feasibility of a four-lane undivided to three-lane conversion. Simulated speed and level of service results for both cross sections were documented for different total peak-hour traffic, access densities, and access-point left-turn volumes (for a case study corridor defined by the researchers). These analyses assisted with the identification of the considerations for the operational feasibility determination of a four -lane to three-lane conversion. The results of the simulation analyses primarily confirmed the case study impacts. The CORSIM results indicated only a slight decrease in average arterial speed for through vehicles can be expected for a large range of peak-hour volumes, access densities, and access-point left-turn volumes (given the assumptions and design of the corridor case study evaluated). Typically, the reduction in the simulated average arterial speed (which includes both segment and signal delay) was between zero and four miles per hour when a roadway was converted from a four-lane undivided to a three-lane cross section. The simulated arterial level of service for a converted roadway, however, showed a decrease when the bi-directional peak-hour volume was about 1,750 vehicles per hour (or 17,500 vehicles per day if 10 percent of the daily volume is assumed to occur in the peak hour). Past research by others, however, indicates that 12,000 vehicles per day may be the operational capacity (i.e., level of service E) of a three-lane roadway due to vehicle platooning. The simulation results, along with past research and case study results, appear to support following volume-related feasibility suggestions for four-lane undivided to three-lane cross section conversions. It is recommended that a four-lane undivided to three-lane conversion be considered as a feasible (with respect to volume only) option when bi-directional peak-hour volumes are less than 1,500 vehicles per hour, but that some caution begin to be exercised when the roadway has a bi-directional peak-hour volume between 1,500 and 1,750 vehicles per hour. At and above 1,750 vehicles per hour, the simulation indicated a reduction in arterial level of service. Therefore, at least in Iowa, the feasibility of a four-lane undivided to three-lane conversion should be questioned and/or considered much more closely when a roadway has (or is expected to have) a peak-hour volume of more than 1,750 vehicles. Assuming that 10 percent of the daily traffic occurs during the peak-hour, these volume recommendations would correspond to 15,000 and 17,500 vehicles per day, respectively. These suggestions, however, are based on the results from one idealized case xi study corridor analysis. Individual operational analysis and/or simulations should be completed in detail once a four-lane undivided to three-lane cross section conversion is considered feasible (based on the general suggestions above) for a particular corridor. All of the simulations completed as part of this project also incorporated the optimization of signal timing to minimize vehicle delay along the corridor. A number of determination feasibility factors were identified from a review of the past research, before-and-after case study results, and the simulation sensitivity analysis. The existing and expected (i.e., design period) statuses of these factors are described and should be considered. The characteristics of these factors should be compared to each other, the impacts of other potentially feasible cross section improvements, and the goals/objectives of the community. The factors discussed in these guidelines include • roadway function and environment • overall traffic volume and level of service • turning volumes and patterns • frequent-stop and slow-moving vehicles • weaving, speed, and queues • crash type and patterns • pedestrian and bike activity • right-of-way availability, cost, and acquisition impacts • general characteristics, including - parallel roadways - offset minor street intersections - parallel parking - corner radii - at-grade railroad crossings xii The characteristics of these factors are documented in these guidelines, and their relationship to four-lane undivided to three-lane cross section conversion feasibility identified. This information is summarized along with some evaluative questions in this executive summary and Appendix C. In summary, the results of past research, numerous case studies, and the simulation analyses done as part of this project support the conclusion that in certain circumstances a four-lane undivided to three-lane conversion can be a feasible alternative for the mitigation of operational and/or safety concerns. This feasibility, however, must be determined by an evaluation of the factors identified in these guidelines (along with any others that may be relevant for a individual corridor). The expected benefits, costs, and overall impacts of a four-lane undivided to three-lane conversion should then be compared to the impacts of other feasible alternatives (e.g., adding a raised median) at a particular location.

State Legislation Monitoring Report FY2004, February 2005

The Division of Criminal and Juvenile Justice Planning issued its first state legislation monitoring report in February 2002, covering the first six months’ impact of Senate File 543 (which enacted a number of sentencing changes) on the justice system; monitoring of the correctional impact of this bill was at the request of several members of the legislature. Since then, the Criminal and Juvenile Justice Planning Advisory Council has requested that CJJP monitor the correctional impact of enacted legislation of particular interest. This report covers monitoring results or future plans to monitor the following: 1. Changes in “crack” cocaine and “powder” cocaine penalties under Chapter 124.401 (effective FY2004; see p.3). 2. Commitments to prison involving manufacture, distribution, or possession of methamphetamine under Chapter 124.401 (see p.5). 3. Prosecution of offenders for child endangerment under Chapter 726.6(g) for permitting the presence of a child or minor at a location where a controlled substance manufacturing or a product possession violation occurs (see p.7). 4. Provision of an enhanced penalty for manufacturing of controlled substances under Chapter 124.401C when children are present and the offender is not charged under section 726.6(g) (see p. 7). 5. Creating a new offense when a retailer sells more than two packages of any product containing pseudoephedrine (chapter 126.23A) and providing for an enhanced penalty under Chapter 714.7C when a theft involves more than two packages of similar products (see p.8). 6. Establishment of parole eligibility at 70% of time served for persons sentenced under the “85% law” provisions of Iowa Code Section 902.12. (effective FY2005; see p. 9).

The Standard Biplot

Biplots are graphical displays of data matrices based on the decomposition of a matrix as the product of two matrices. Elements of these two matrices are used as coordinates for the rows and columns of the data matrix, with an interpretation of the joint presentation that relies on the properties of the scalar product. Because the decomposition is not unique, there are several alternative ways to scale the row and column points of the biplot, which can cause confusion amongst users, especially when software packages are not united in their approach to this issue. We propose a new scaling of the solution, called the standard biplot, which applies equally well to a wide variety of analyses such as correspondence analysis, principal component analysis, log-ratio analysis and the graphical results of a discriminant analysis/MANOVA, in fact to any method based on the singular-value decomposition. The standard biplot also handles data matrices with widely different levels of inherent variance. Two concepts taken from correspondence analysis are important to this idea: the weighting of row and column points, and the contributions made by the points to the solution. In the standard biplot one set of points, usually the rows of the data matrix, optimally represent the positions of the cases or sample units, which are weighted and usually standardized in some way unless the matrix contains values that are comparable in their raw form. The other set of points, usually the columns, is represented in accordance with their contributions to the low-dimensional solution. As for any biplot, the projections of the row points onto vectors defined by the column points approximate the centred and (optionally) standardized data. The method is illustrated with several examples to demonstrate how the standard biplot copes in different situations to give a joint map which needs only one common scale on the principal axes, thus avoiding the problem of enlarging or contracting the scale of one set of points to make the biplot readable. The proposal also solves the problem in correspondence analysis of low-frequency categories that are located on the periphery of the map, giving the false impression that they are important.

Taming SIFIs

We model a Systemically Important Financial Institution (SIFI) that is too big(or too interconnected) to fail. Without credible regulation and strong supervision,the shareholders of this institution might deliberately let its managers take excessiverisk. We propose a solution to this problem, showing how insurance againstsystemic shocks can be provided without generating moral hazard. The solutioninvolves levying a systemic tax needed to cover the costs of future crises and moreimportantly establishing a Systemic Risk Authority endowed with special resolutionpowers, including the control of bankers' compensation packages during crisisperiods.

Fiscal policy, pricing frictions and monetary accommodation

We investigate the theoretical conditions for effectiveness of government consumptionexpenditure expansions using US, Euro area and UK data. Fiscal expansions taking placewhen monetary policy is accommodative lead to large output multipliers in normal times.The 2009-2010 packages need not produce significant output multipliers, may havemoderate debt effects, and only generate temporary inflation. Expenditure expansionsaccompanied by deficit/debt consolidations schemes may lead to short run output gains buttheir success depends on how monetary policy and expectations behave. Trade opennessand the cyclicality of the labor wedge explain cross-country differences in the magnitude ofthe multipliers.