Entering Data into Excel

Video on how to enter data into Excel. This includes setting up column headings, changing sheet names, using lists for categorical items, using validation on columns of data, plus how to check validation is operating correctly.

Checking for invalid data in Excel

A video of how to check for invalid data where the data has already been entered into Excel

Machine vision for the automatic classification of images acquired from Non-destructive tests

This project is based on Artificial Intelligence (A.I) and Digital Image processing (I.P) for automatic condition monitoring of sleepers in the railway track. Rail inspection is a very important task in railway maintenance for traffic safety issues and in preventing dangerous situations. Monitoring railway track infrastructure is an important aspect in which the periodical inspection of rail rolling plane is required.Up to the present days the inspection of the railroad is operated manually by trained personnel. A human operator walks along the railway track searching for sleeper anomalies. This monitoring way is not more acceptable for its slowness and subjectivity. Hence, it is desired to automate such intuitive human skills for the development of more robust and reliable testing methods. Images of wooden sleepers have been used as data for my project. The aim of this project is to present a vision based technique for inspecting railway sleepers (wooden planks under the railway track) by automatic interpretation of Non Destructive Test (NDT) data using A.I. techniques in determining the results of inspection.

Geoprocessamento aplicado ao desenvolvimento de uma base de dados do Município de Botucatu

Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq)

Ambiente data cleaning: suporte extensível, semântico e automático para análise e transformação de dados

Pós-graduação em Ciência da Computação - IBILCE

Trauma registry record linkage: methodological approach to benefit from complementary data using the example of the German Pelvic Injury Register and the TraumaRegister DGU(®)

In Germany, hospitals can deliver data from patients with pelvic fractures selectively or twofold to two different trauma registries, i.e. the German Pelvic Injury Register (PIR) and the TraumaRegister DGU(®) (TR). Both registers are anonymous and differ in composition and content. We describe the methodological approach of linking these registries and reidentifying twofold documented patients. The aim of the approach is to create an intersection set that benefit from complementary data of each registry, respectively. Furthermore, the concordance of data entry of some clinical variables entered in both registries was evaluated.

Can prospective usability evaluation predict data errors?

Increasing amounts of clinical research data are collected by manual data entry into electronic source systems and directly from research subjects. For this manual entered source data, common methods of data cleaning such as post-entry identification and resolution of discrepancies and double data entry are not feasible. However data accuracy rates achieved without these mechanisms may be higher than desired for a particular research use. We evaluated a heuristic usability method for utility as a tool to independently and prospectively identify data collection form questions associated with data errors. The method evaluated had a promising sensitivity of 64% and a specificity of 67%. The method was used as described in the literature for usability with no further adaptations or specialization for predicting data errors. We conclude that usability evaluation methodology should be further investigated for use in data quality assurance.

Commercial applications of speech interface technology: an industry at the threshold.

Speech interface technology, which includes automatic speech recognition, synthetic speech, and natural language processing, is beginning to have a significant impact on business and personal computer use. Today, powerful and inexpensive microprocessors and improved algorithms are driving commercial applications in computer command, consumer, data entry, speech-to-text, telephone, and voice verification. Robust speaker-independent recognition systems for command and navigation in personal computers are now available; telephone-based transaction and database inquiry systems using both speech synthesis and recognition are coming into use. Large-vocabulary speech interface systems for document creation and read-aloud proofing are expanding beyond niche markets. Today's applications represent a small preview of a rich future for speech interface technology that will eventually replace keyboards with microphones and loud-speakers to give easy accessibility to increasingly intelligent machines.

Data capturing: studio di fattibilità per l’acquisizione automatizzata delle informazioni lungo la catena produttiva

Il processo di Data Entry manuale non solo è oneroso dal punto di vista temporale ed economico, lo è ancor di più poiché rappresenta una fonte di errore: per questi motivi, l’acquisizione automatizzata delle informazioni lungo la catena produttiva è un obiettivo fortemente desiderato dal Gruppo per migliorare i propri business. Le tecnologie analizzate, ormai diffuse e standardizzate in ampia scala come barcode, etichette logistiche, terminali in radiofrequenza, possono apportare grandi benefici ai processi aziendali, ancor più integrandole su misura agli ERP aziendali, permettendo una registrazione rapida e corretta delle informazioni e la diffusione immediata delle stesse all’intera organizzazione. L’analisi dei processi e dei flussi hanno evidenziato le criticità e permesso di capire dove e quando intervenire con una progettazione che risultasse quanto più la best suite possibile. Il lancio dei fabbisogni, l’entrata, la mappatura e la movimentazione merci in Magazzino, lo stato di produzione, lo scarico componenti ed il carico di produzione in Confezionamento e Semilavorazione, l’istituzione di un magazzino di interscambio Dogana, un flusso di tracciabilità preciso e rapido, sono tutti eventi che modificheranno i processi aziendali, snellendoli e svincolando risorse che potranno essere reinvestite in operatività a valore aggiunto superiore. I risultati potenzialmente ottenibili, comprovati anche dalle esperienze esterne di fornitori e consulenza, hanno generato le condizioni necessarie ad un rapido studio e start dei lavori: il Gruppo è entusiasta ed impaziente di portare a termine quanto prima il progetto e di andare a regime con la nuova modalità operativa, snellita ed ottimizzata.

Planning of automated data acquisition and process control systems (ADACS) /

"January 1980."

Design and implementation of a multisite data repository for pediatric epilepsy

This dissertation established a software-hardware integrated design for a multisite data repository in pediatric epilepsy. A total of 16 institutions formed a consortium for this web-based application. This innovative fully operational web application allows users to upload and retrieve information through a unique human-computer graphical interface that is remotely accessible to all users of the consortium. A solution based on a Linux platform with My-SQL and Personal Home Page scripts (PHP) has been selected. Research was conducted to evaluate mechanisms to electronically transfer diverse datasets from different hospitals and collect the clinical data in concert with their related functional magnetic resonance imaging (fMRI). What was unique in the approach considered is that all pertinent clinical information about patients is synthesized with input from clinical experts into 4 different forms, which were: Clinical, fMRI scoring, Image information, and Neuropsychological data entry forms. A first contribution of this dissertation was in proposing an integrated processing platform that was site and scanner independent in order to uniformly process the varied fMRI datasets and to generate comparative brain activation patterns. The data collection from the consortium complied with the IRB requirements and provides all the safeguards for security and confidentiality requirements. An 1-MR1-based software library was used to perform data processing and statistical analysis to obtain the brain activation maps. Lateralization Index (LI) of healthy control (HC) subjects in contrast to localization-related epilepsy (LRE) subjects were evaluated. Over 110 activation maps were generated, and their respective LIs were computed yielding the following groups: (a) strong right lateralization: (HC=0%, LRE=18%), (b) right lateralization: (HC=2%, LRE=10%), (c) bilateral: (HC=20%, LRE=15%), (d) left lateralization: (HC=42%, LRE=26%), e) strong left lateralization: (HC=36%, LRE=31%). Moreover, nonlinear-multidimensional decision functions were used to seek an optimal separation between typical and atypical brain activations on the basis of the demographics as well as the extent and intensity of these brain activations. The intent was not to seek the highest output measures given the inherent overlap of the data, but rather to assess which of the many dimensions were critical in the overall assessment of typical and atypical language activations with the freedom to select any number of dimensions and impose any degree of complexity in the nonlinearity of the decision space.

Are critically endangered fish back on the menu? Analysis of U.K. fisheries data suggest post-ban landings of prohibited skates in European waters

Skates (Rajidae) have been commercially exploited in Europe for hundreds of years with some species’ abundances declining dramatically during the twentieth century. In 2009 it became “prohibited for EU vessels to target, retain, tranship or land” certain species in some ICES areas, including the critically endangered common skate and the endangered white skate. To examine compliance with skate bans the official UK landings data for 2011–2014 were analysed. Surprisingly, it was found that after the ban prohibited species were still reported landed in UK ports, including 9.6 t of common skate during 2011–2014. The majority of reported landings of common and white skate were from northern UK waters and landed into northern UK ports. Although past landings could not be validated as being actual prohibited species, the landings’ patterns found reflect known abundance distributions that suggest actual landings were made, rather than sporadic occurrence across ports that would be evident if landings were solely due to systematic misidentification or data entry errors. Nevertheless, misreporting and data entry errors could not be discounted as factors contributing to the recorded landings of prohibited species. These findings raise questions about the efficacy of current systems to police skate landings to ensure prohibited species remain protected. By identifying UK ports with the highest apparent landings of prohibited species and those still landing species grouped as'skates and rays’, these results may aid authorities in allocating limited resources more effectively to reduce landings, misreporting and data errors of prohibited species, and increase species-specific landing compliance.

Are critically endangered fish back on the menu? Analysis of U.K. fisheries data suggest post-ban landings of prohibited skates in European waters

Skates (Rajidae) have been commercially exploited in Europe for hundreds of years with some species’ abundances declining dramatically during the twentieth century. In 2009 it became “prohibited for EU vessels to target, retain, tranship or land” certain species in some ICES areas, including the critically endangered common skate and the endangered white skate. To examine compliance with skate bans the official UK landings data for 2011–2014 were analysed. Surprisingly, it was found that after the ban prohibited species were still reported landed in UK ports, including 9.6 t of common skate during 2011–2014. The majority of reported landings of common and white skate were from northern UK waters and landed into northern UK ports. Although past landings could not be validated as being actual prohibited species, the landings’ patterns found reflect known abundance distributions that suggest actual landings were made, rather than sporadic occurrence across ports that would be evident if landings were solely due to systematic misidentification or data entry errors. Nevertheless, misreporting and data entry errors could not be discounted as factors contributing to the recorded landings of prohibited species. These findings raise questions about the efficacy of current systems to police skate landings to ensure prohibited species remain protected. By identifying UK ports with the highest apparent landings of prohibited species and those still landing species grouped as'skates and rays’, these results may aid authorities in allocating limited resources more effectively to reduce landings, misreporting and data errors of prohibited species, and increase species-specific landing compliance.

The Antibiotic Resistance and Prescribing in European Children Project: A Neonatal and Pediatric Antimicrobial Web-based Point Prevalence Survey in 73 Hospitals Worldwide

BACKGROUND: The neonatal and pediatric antimicrobial point prevalence survey (PPS) of the Antibiotic Resistance and Prescribing in European Children project (http://www.arpecproject.eu/) aims to standardize a method for surveillance of antimicrobial use in children and neonates admitted to the hospital within Europe. This article describes the audit criteria used and reports overall country-specific proportions of antimicrobial use. An analytical review presents methodologies on antimicrobial use.

METHODS: A 1-day PPS on antimicrobial use in hospitalized children was organized in September 2011, using a previously validated and standardized method. The survey included all inpatient pediatric and neonatal beds and identified all children receiving an antimicrobial treatment on the day of survey. Mandatory data were age, gender, (birth) weight, underlying diagnosis, antimicrobial agent, dose and indication for treatment. Data were entered through a web-based system for data-entry and reporting, based on the WebPPS program developed for the European Surveillance of Antimicrobial Consumption project.

RESULTS: There were 2760 and 1565 pediatric versus 1154 and 589 neonatal inpatients reported among 50 European (n = 14 countries) and 23 non-European hospitals (n = 9 countries), respectively. Overall, antibiotic pediatric and neonatal use was significantly higher in non-European (43.8%; 95% confidence interval [CI]: 41.3-46.3% and 39.4%; 95% CI: 35.5-43.4%) compared with that in European hospitals (35.4; 95% CI: 33.6-37.2% and 21.8%; 95% CI: 19.4-24.2%). Proportions of antibiotic use were highest in hematology/oncology wards (61.3%; 95% CI: 56.2-66.4%) and pediatric intensive care units (55.8%; 95% CI: 50.3-61.3%).

CONCLUSIONS: An Antibiotic Resistance and Prescribing in European Children standardized web-based method for a 1-day PPS was successfully developed and conducted in 73 hospitals worldwide. It offers a simple, feasible and sustainable way of data collection that can be used globally.

Iowa's Barriers to Prenatal Care Project: 2-14 Data Summary, July 2015

The findings in this summary are based on the Iowa Barriers to Prenatal Care project. Ongoing since 1991, the purpose of this project is to obtain brief, accurate information about women delivering babies in Iowa hospitals. Specifically, the project seeks to learn about women’s experiences getting prenatal or delivery care during their current pregnancy. Other information is included which may be pertinent to health planners or those concerned with the systematic development of health care services. This project is a cooperative venture of all of Iowa’s maternity hospitals, the University of Northern Iowa Center for Social and Behavioral Research, and the Iowa Department of Public Health. The Robert Wood Johnson Foundation funded the first three years of this project. The current funding is provided by the Iowa Department of Public Health. The Director is Dr. Mary Losch, University of Northern Iowa Center for Social and Behavioral Research. The Coordinator for the project is Rodney Muilenburg. The questionnaire is distributed to nearly ninety maternity hospitals across the state of Iowa. Nursing staff or those responsible for obtaining birth certificate information in the obstetrics unit are responsible for approaching all birth mothers prior to dismissal and requesting their participation in the study. The questionnaire takes approximately ten minutes to complete. Completed questionnaires are returned to the University of Northern Iowa Center for Social and Behavioral Research for data entry and analysis. Returns are made monthly, weekly, or biweekly depending on the number of births per week in a given hospital. Except in the case of a mother who is too ill to complete the questionnaire, all mothers are eligible to be recruited for participation. The present yearly report includes an analysis of large Iowa cities, African American mothers, and a trend analysis of the last ten years. Also presented in this report is a frequency analysis of all variables included in the 2012 questionnaire. Unless otherwise noted, all entries reflect percentages. Please note that because percentages were rounded, total values may not equal 100%. Data presented are based upon 2012 questionnaires received to date (n = 23,674). All analyses reflect unweighted percentages of those responding.