scholarly journals Excel File Processing Based on NPOI Package

2018 ◽  
Author(s):  
Li-hua MA ◽  
Sheng-ming LI ◽  
Xiao-lan WANG ◽  
Feng PANG
Keyword(s):  
File Processing ◽  
Excel File

Advanced File Processing

Linux ◽  
2018 ◽  
pp. 153-188
Author(s):  
Syed Mansoor Sarwar ◽  
Robert M. Koretsky
Keyword(s):  
File Processing

scholarly journals Demagnetization Analysis in Excel (DAIE). An open source workbook in Excel for viewing and analyzing demagnetization data from paleomagnetic discrete samples and u-channels

2013 ◽  
Vol 56 (1) ◽  
Author(s):  
Leonardo Sagnotti
Keyword(s):  
Principal Component Analysis ◽  
Open Source ◽  
Single Cells ◽  
Principal Component ◽  
Component Analysis ◽  
Modular Structure ◽  
Microsoft Excel ◽  
Excel File

<p>The Demagnetization Analysis in Excel (DAIE) software is a single Microsoft Excel file designed for viewing and analyzing stepwise demagnetization data of both discrete and u-channel samples in paleomagnetic studies. DAIE is an Excel workbook and has an open modular structure organized in 10 worksheets. It is designed for an easy use and an interactive operability; all the commands and choices can be entered by sliding menus associated to single cells. The standard demagnetization diagrams and various parameters of common use are shown on the same worksheet including selectable parameters and user's choices. The remanence characteristic components may be computed by principal component analysis (PCA) on a selected interval of demagnetization steps. Saving of the PCA data can be done both sample by sample, or in automatic by applying the selected choices to all the samples included in the file. The whole workbook is free both for use and editing and it is available for download on a dedicated website.</p>

scholarly journals Graphical User Interface for Shuffling of Sections based on Student Profile

2021 ◽  
Vol 9 (VI) ◽  
pp. 2752-2757
Author(s):  
Kotawar Ashwitha
Keyword(s):  
Time Series ◽  
Data Structures ◽  
Graphical User Interface ◽  
Software Library ◽  
Male And Female ◽  
Data Manipulation ◽  
Student Profile ◽  
Python Language ◽  
Python Programming ◽  
Excel File

This project GUI for shuffling of sections is done to automate the hectic work of shuffling students into sections has been programed in python using open source module using pandas and tkinter the overall result achieved to this program is that students got shuffled into sections with same ratio of male and female in all section, and average of ranks of students of all sections are similar as to maintain equality and integrity. This program gives a GUI for the administrator to access the file with data of students stored to manipulate that data. In this project we will implement using python programming language .in python, we will use module pandas, TKinter. Pandas to manipulate data of students from an excel file through python program, TKinter is used to add GUI to the program to select the file to be manipulated pandas is a software library written for the python language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series In particular, it offers data structures and operations for manipulating numerical tables and time series. TKINTER is a software library for creating library for creating GUI using python language.

scholarly journals IMPLEMENTASI PENCATATAN AKTIVITAS MAHASISWA MENGGUNAKAN WEB SERVICE PADA FEEDER PDDIKTI DENGAN METODE EXTREME PROGRAMMING

2020 ◽  
Vol 14 (2) ◽  
pp. 179-188
Author(s):  
Viktor Handrianus Pranatawijaya
Keyword(s):  
Information System ◽  
Web Services ◽  
System Application ◽  
Extreme Programming ◽  
Activity Data ◽  
Student Activities ◽  
Student Activity ◽  
Recording Process ◽  
Academic Information ◽  
Excel File

One of the features in the Feeder PDDIKTI application is the student activity feature. The feature is used to record student activities with participants' activities, supervisors and examiners. The problem with the Feeder PDDIKTI application when recording student activities is that the operator must input data one by one to the application. Therefore DIKTI also provides web services that can be used so that the recording process can be better.Implementation of recording student activities using web services on the Feeder PDDIKTI with extreme programming methods is carried out in accordance with the stages. In the planning part, an analysis is carried out on the business needs and user stories, in the design, use case diagrams and activity diagrams are made, coding is done by implementing the design using the PHP programming language, and testing is done using black box testing.In running the application, upload excel files are used for student activity data, activity participants, supervisors and examiners. After the student activity is successfully uploaded an excel file is generated from the system which contains student activities that already have the id_akt_mhs attribute. These attributes will be used to link student activity data with activity participants, supervisors, and examiners when filling in data in an excel file. Applications made are not yet connected to the Academic Information System Application so that for future development it is expected to be able to connect and retrieve data directly from the Academic Information System Application.

scholarly journals Essais interlaboratoires pour l'identification moléculaire des espèces paléarctiques du sous-genre Avaritia

2009 ◽  
Vol 62 (2-4) ◽  
pp. 102
Author(s):  
Catherine Cetre-Sossah ◽  
Thomas Balenghien ◽  
Jean-Claude Delécolle ◽  
Rudolf Meiswinkel
Keyword(s):  
Deoxyribonucleic Acid ◽  
False Negative ◽  
Chain Reaction ◽  
Negative Results ◽  
False Negative Results ◽  
Ring Trial ◽  
International Experts ◽  
Phosphate Buffered Saline ◽  
Excel File

A ring trial was conducted for molecular identification of Palaearctic species of the subgenus Avaritia, and especially the following four species: Culicoides chiopterus, C. dewulfi, C. obsoletus and C. scoticus. It was based on multiplex polymer­ase chain reaction (PCR) on the molecular markers cytochrome oxidase type 1 (CO1), internal transcribed spacer 2 (ITS-2), and ITS-1. Each of the 13 participating laboratories (from seven dif­ferent countries) received on the 4th of August 2008 a panel of 38 samples of 11 μL of a phosphate-buffered saline (PBS) solu­tion containing parts of a single specimen of insect ground up into 200 μL of PBS, as well as four tubes, identified and men­tioned in the accompanying letter, for which deoxyribonucleic acid (DNA) had already been extracted.  The panel was coded with a letter followed by different num­bers. The laboratories had two months from the date of arrival of the samples to give back the results by sending an Excel file containing the coding. The 38 samples used for the trial were exchanged for identification between two international experts (Drs J.C. Delécolle and R. Meiswinkel). Only one identification differed between the two experts: scoticus vs. obsoletus, and sequencing revealed it to be a C. scoticus specimen.  Only one laboratory used molecular marker ITS-2, five labo­ratories used ITS-1, and four used CO1. Only two found the expected results. The eight remaining laboratories found some false positive or false negative results. Five out of ten correctly identified the species from the DNA samples. Seven out of ten laboratories had 100% sensitivity

Malaria Dashboard: a digital platform for epidemiological data from India (Preprint)

2021 ◽  
Author(s):  
Chander Prakash Yadav ◽  
Amit Sharma
Keyword(s):  
Web Application ◽  
Epidemiological Data ◽  
Web Page ◽  
Digital Tool ◽  
R Software ◽  
Malaria Epidemiology ◽  
Interactive Analysis ◽  
Data Source ◽  
R Packages ◽  
Excel File

BACKGROUND A digital dashboard on malaria epidemiological data will be an invaluable resource for the research community and the planning of malaria control. OBJECTIVE To develop a digital Malaria Dashboard (MDB) for malaria epidemiological data METHODS We have developed a digital Malaria Dashboard (MDB) using the R software. A total of thirteen different R packages were used in this process, within which shiny and ggplot2 were used more intensively. The MDB is a web application that can work online as well as offline. Presently it is available in offline mode only. The MS Excel file may be used as an input data source and any personal computer may be used for this application. RESULTS The MDB is a highly versatile interface that allows prompt and interactive analysis of malaria epidemiological data. The primary interface of MDB is like a web page that has 14 tabs (or pages), some more tabs may be added or deleted as per requirement and each tab corresponds to a particular analysis. A user may move from one tab to another via tab icons. Each tab thus allows flexibility in correlating various parameters like SPR, API, AFI, ABER, RT, malaria cases, death due to malaria, BSC, and BSE. The data can be analyzed in required granularity (national, state, district), and its enhanced visualization allows for facile usage. Using the MDB, one can quickly assess national or more granular scenarios in a time series manner and then compare the malaria epidemiology in various states and their constituent districts. CONCLUSIONS This MDB is a highly effective digital tool for studying the malaria situation and strategizing for malaria elimination and researcher may use it as a prototype for developing some other dashboards in their own fields.

Sign in / Sign up

Export Citation Format

Share Document