A user-friendly excel spreadsheet for dealing with spectroscopic and chromatographic data

Registro completo de metadados
MetadadosDescriçãoIdioma
Autor(es): dc.contributorUniversidade Estadual Paulista (Unesp)-
Autor(es): dc.creatorVieira, Alan Lima [UNESP]-
Autor(es): dc.creatorNespeca, Maurílio Gustavo [UNESP]-
Autor(es): dc.creatorPavini, Weslei Diego [UNESP]-
Autor(es): dc.creatorFerreira, Edilene Cristina [UNESP]-
Autor(es): dc.creatorGomes Neto, José Anchieta [UNESP]-
Data de aceite: dc.date.accessioned2022-02-22T00:32:53Z-
Data de disponibilização: dc.date.available2022-02-22T00:32:53Z-
Data de envio: dc.date.issued2020-12-11-
Data de envio: dc.date.issued2020-12-11-
Data de envio: dc.date.issued2019-11-14-
Fonte completa do material: dc.identifierhttp://dx.doi.org/10.1016/j.chemolab.2019.103816-
Fonte completa do material: dc.identifierhttp://hdl.handle.net/11449/201200-
Fonte: dc.identifier.urihttp://educapes.capes.gov.br/handle/11449/201200-
Descrição: dc.descriptionA user-friendly interface was developed in Excel (Microsoft Office) to deal with spectroscopic and chromatographic data. The Excel spreadsheet includes baseline correction, area and height determination, and identification of variables that represent the maximum height. In addition, the user can quickly evaluate standardization methods and create databases by adding information to the library, where up to 300 peaks can be saved. In the present work, the application of the Excel spreadsheet is exemplified by analytical curves developed with gas chromatography, Raman spectroscopy and laser-induced breakdown spectroscopy (LIBS) data. The analytical parameters obtained by the Excel spreadsheet were compared with the results generated in different software, such as MATLAB (routine), Origin and ChromQuest. The coefficient of determination (R2) and root-mean-square error (RMSE) obtained from Excel spreadsheet were very similar to those from other software. The analytical curves were also submitted to analysis of variance (ANOVA) and, regarding the F-test, all presented values of Fcalculated greater than Fcritical. The relationship between the analytical responses from the Excel spreadsheet and other software showed a coefficient of correlation close to 1. Therefore, the proposed Excel interface is an attractive alternative to expensive software and provides easy handling for LIBS data. The spreadsheet and a short tutorial video are available in the electronic supplementary material (or in the link https://1drv.ms/f/s!AjTI1LyRsk35lYtYOvj6EGyXvFgWlQ).-
Descrição: dc.descriptionCoordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)-
Descrição: dc.descriptionConselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq)-
Descrição: dc.descriptionSão Paulo State University - UNESP Institute of Chemistry, P.O. Box 355-
Descrição: dc.descriptionSão Paulo State University - UNESP Institute of Chemistry, P.O. Box 355-
Descrição: dc.descriptionCNPq: 141977/2016-7-
Descrição: dc.descriptionCNPq: 302414/2017-7-
Idioma: dc.languageen-
Relação: dc.relationChemometrics and Intelligent Laboratory Systems-
???dc.source???: dc.sourceScopus-
Palavras-chave: dc.subjectBaseline correction-
Palavras-chave: dc.subjectChromatographic data-
Palavras-chave: dc.subjectExcel spreadsheet-
Palavras-chave: dc.subjectSpectroscopic data-
Palavras-chave: dc.subjectStandardization-
Palavras-chave: dc.subjectUser-friendly interface-
Título: dc.titleA user-friendly excel spreadsheet for dealing with spectroscopic and chromatographic data-
Tipo de arquivo: dc.typelivro digital-
Aparece nas coleções:Repositório Institucional - Unesp

Não existem arquivos associados a este item.