| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 6.95 MB | Adobe PDF |
Authors
Abstract(s)
Este trabalho detalha o processo de estudo acadêmico para desenvolvimento da otimização de uma folha de cálculo em Excel com base nos resultados gerados pelo ensaio edométrico. Essa pesquisa tem como objetivo tornar o arquivo mais automatizado, garantindo ao usuário um melhor tratamento na aquisição de dados do ensaio de forma mais rápida e evitando erros na obtenção dos resultados. A configuração desta otimização é baseada na criação de linguagem de programação na plataforma VBA e Macros para Excel juntamente com o desenvolvimento da performance visual do arquivo. Os resultados fornecidos pelo ensaio edométrico tornam-se como banco de dados para o arquivo Excel otimizado. Os dados do ensaio são gerados através da plataforma LabVIEW conectados aos sensores LVDT e uma placa de aquisição de dados de 16 bits ao PC, que são executados durante o ensaio de consolidação de maciços terrosos seguidos pelas normas brasileira sobre Solos de Adensamento do DNER-IE 005/94 e a internacional ASTM D2435 / D2435M - 11(2020) Standard Test Methods for One-Dimensional Consolidation Properties of Soils Using Incremental Loading. Conclui-se que o arquivo de cálculo em Excel otimizado está apto para o uso, servindo-se como uma ferramenta de cálculo em auxílio ao usuário que pretende obter resultados após realizar o ensaio edométrico de maciços terrosos. A folha de Excel otimizada executa a maior parte do tratamento dos dados que se pretende com a realização do ensaio, no entanto não se encontra totalmente finalizada. Assim, com a versão desenvolvida neste trabalho, o arquivo de excel permite obter os índices de compressibilidade e de recompressibilidade da amostra/solo e as curvas de relação entre o índice de vazios e tensão vertical efetiva aplicada à amostra. A folha de excel otimizada ainda não permite a obtenção dos coeficientes de consolidação vertical.
This survey details the academic study process for developing the optimization of an Excel spreadsheet based on the results made by the edometric test. This research aims to make the file more automated, ensuring the user a better treatment in the acquisition of test data more quickly and avoiding errors in the results. The setting of this optimization is based on the creation of a programming language on the VBA platform and Macros for Excel including the development of the visual performance of the file. The results provided by the edometric test become a database for the optimized Excel file. The test data is generated through the LabVIEW platform connected to the LVDT sensors and a 16-bit data acquisition board to the computer, which are performed during the consolidation test of earth masses followed by the Brazilian standards on DNER-IE Density Soils 005/94 and the international ASTM D2435 / D2435M - 11 (2020) Standard Test Methods for One-Dimensional Consolidation Properties of Soils Using Incremental Loading. It may conclude that the optimized Excel calculation file is suitable for use, serving as a calculation tool to assist the user who intends to obtain results after carrying out the edometric test of earth masses. The optimized Excel sheet performs most of the data processing intended for the test, however it is not yet complete. Thus, with the version developed in this survey, the excel file allows obtaining the compressibility and recompressibility indices of the sample / soil and the relationship curves between the void index and effective vertical tension applied to the sample. The optimized excel sheet does not allow obtaining the vertical consolidation coefficients.
This survey details the academic study process for developing the optimization of an Excel spreadsheet based on the results made by the edometric test. This research aims to make the file more automated, ensuring the user a better treatment in the acquisition of test data more quickly and avoiding errors in the results. The setting of this optimization is based on the creation of a programming language on the VBA platform and Macros for Excel including the development of the visual performance of the file. The results provided by the edometric test become a database for the optimized Excel file. The test data is generated through the LabVIEW platform connected to the LVDT sensors and a 16-bit data acquisition board to the computer, which are performed during the consolidation test of earth masses followed by the Brazilian standards on DNER-IE Density Soils 005/94 and the international ASTM D2435 / D2435M - 11 (2020) Standard Test Methods for One-Dimensional Consolidation Properties of Soils Using Incremental Loading. It may conclude that the optimized Excel calculation file is suitable for use, serving as a calculation tool to assist the user who intends to obtain results after carrying out the edometric test of earth masses. The optimized Excel sheet performs most of the data processing intended for the test, however it is not yet complete. Thus, with the version developed in this survey, the excel file allows obtaining the compressibility and recompressibility indices of the sample / soil and the relationship curves between the void index and effective vertical tension applied to the sample. The optimized excel sheet does not allow obtaining the vertical consolidation coefficients.
Description
Mestrado de dupla diplomação com a Associação Educativa Evangélica - UniEvangélica
Keywords
Excel Otimização de resultados Ensaio edométrico VBA e Macros para Excel Geotecnia