scholarly journals Proposta de Automatização do Método Leonês para Cálculo da Tarifa do Transporte Público Urbano em Visual Basic for Applications (VBA)

2021 ◽  
Vol 7 ◽  
Author(s):  
Helder Vasconcelos Alves ◽  
Fernando Hideki Hirosue
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Visual Basic For Applications ◽  
De Se

Os métodos de cálculo de tarifas do transporte por ônibus utilizados no Brasil, em sua grande parte, estão obsoletos, sendo necessárias novas formas de se calcular o valor das tarifas. A automatização dos métodos de cálculos faz com que os órgãos competentes e projetistas levem menos tempo com demandas operacionais e possam focar em análises mais profundas sobre os custos do sistema de transporte coletivo urbano. Portanto, este estudo apresenta uma proposta de automatizar um desses métodos de cálculo: o Método Leonês. Tal automatização foi executada no Microsoft Excel através da linguagem de programação própria do software, denominada VBA (Visual Basic for Applications). Por fim, foram obtidos como resultados a planilha final de cálculo, considerações na concepção da planilha e ideias futuras de melhorias possíveis no programa construído.

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

scholarly journals A VBA module simulation for finding optimal lag order in time series models and its use on teaching financial data computation

2020 ◽  
Vol ahead-of-print (ahead-of-print) ◽  
Author(s):  
Alan Mustafa ◽  
Abdulnasser Hatemi-J
Keyword(s):  
Dynamic Model ◽  
Information Criterion ◽  
Visual Basic ◽  
Financial Data ◽  
Data Series ◽  
Time Series Models ◽  
Microsoft Excel ◽  
Step Process ◽  
Visual Basic For Applications ◽  
Multiple Variables

In this study, a tool has been designed and developed for learning about the concept of lag order within a dynamic model, which can be used in any teaching classes on statistics and financial data computation. To show a solution for a complex and multi-step process of finding the optimal lag order for multiple variables data series based on an information criterion a module using Visual Basic for Applications (VBA) for Microsoft Excel (MS Excel) is being developed. This module can be used for estimating a multivariate dynamic model as well as determining the optimal lag order of such a model.

Modeling the Behavior of a 50 MW Direct Steam Generation Plant for Southern Libya Based on the Thermodynamic and Thermophysical Properties of Water Substance

2012 ◽  
Vol 134 (4) ◽  
Author(s):  
Y. Aldali ◽  
B. Davison ◽  
T. Muneer ◽  
D. Henderson
Keyword(s):  
Software Tool ◽  
Visual Basic ◽  
Steam Generation ◽  
Construction Costs ◽  
Microsoft Excel ◽  
Solar Fraction ◽  
Visual Basic For Applications ◽  
Generation Plant ◽  
Direct Steam ◽  
Plant Capacity

This paper presents arguments for the use of direct steam generation (DSG) in preference to other forms of generation in particular locations according to the prevailing environmental and economic conditions. In addition, the paper describes the development of a software tool based on Microsoft Excel and Visual Basic for Applications (VBA), which draws upon established physical relationships in the heat transfer literature to perform plant capacity calculations in a fast and convenient manner. The results of the VBA program determine the solar fraction of the plant, assuming that the plant is in operation for 10 h per day (07:30–17:30 hours), the solar fraction is shown to be 76% and the DSG plant achieves a 76% reduction in emissions. Construction costs are also estimated based on formulae from previous work.

scholarly journals Dimensionamento automático de vigas considerando a protensão parcial

2021 ◽  
Author(s):  
Izaura De Vargas Martins ◽  
Lorenzo Augusto Ruschi e Luchi
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Visual Basic For Applications

Este artigo trata da elaboração de uma ferramenta computacional para o dimensionamento de vigas protendidas biapoiadas conforme a NBR 6118:2014. São contemplados os níveis de protensão completa, limitada e, especialmente, parcial. Para diferentes carregamentos, o programa realiza o pré-dimensionamento da força de protensão, calcula as perdas imediatas e progressivas. Verifica os estados-limites de serviço de compressão excessiva, descompressão, formação e abertura das fissuras, e deformações excessivas. Verifica os estados-limites últimos, no ato da protensão, dimensionamento à flexão e à força cortante. O programa foi desenvolvido utilizando o <em>Microsoft Excel </em>e o<em> Microsoft Visual Basic for Applications</em>, apresenta interface gráfica com o usuário e geração de memoriais de cálculo, servindo como recurso didático no meio acadêmico tanto no nível de graduação e quanto de pós-graduação. Os resultados obtidos são validados pela comparação com exemplos presentes na literatura.

AUTOMATION OF PROCESSING GEODETIC MEASUREMENTS BASED ON EVALUATION OF ACCURACY OF POSITIONING SPECIALIZED NETWORKS’ POINTS IN A PLANE COORDINATE SYSTEM

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
General Purpose ◽  
Automatic Evaluation ◽  
Microsoft Excel ◽  
Geodetic Measurements ◽  
Visual Basic For Applications ◽  
Visual Basic For Application

В данной работе рассматривается возможность использования вычислительных возможностей программ общего назначения при решении геодезических задач посредством использования пакетов Microsoft Excel, Visual Basic for Applications. В статье представлены результаты автоматизации процесса оценки плановой точности положения геодезических пунктов сети трилатерации. This paper reviews the implementation of computing capabilities of general-purpose programs for solving geodetic problems through Microsoft Excel, Visual Basic for Application. The paper presents solution for automatic evaluation of accuracy of positioning specialized networks’ points in a plane coordinate system.

NUMERICAL SOLUTION OF NONLINEAR EQUATIONS IN ELECTRONIC TABLES AND VISUAL BASIC FOR APPLICATIONS

2020 ◽  
pp. 51-57
Author(s):  
A. L. Korolev
Keyword(s):  
Nonlinear Equations ◽  
Visual Basic ◽  
First Year ◽  
State University ◽  
Microsoft Excel ◽  
First Year Students ◽  
Visual Basic For Applications ◽  
Binary Division ◽  
Chord Method ◽  
And Mathematics

The article discusses some methods for numerically finding the roots of nonlinear equations, which are determined by numerical methods using the construction of a spreadsheet Microsoft Excel and an application in the Visual Basic for Applications environment. The simplest methods are used: the binary division method and the chord method. The article presents the construction of spreadsheets, the algorithm, the method of creation the VBA application, and the text of the corresponding procedures. The material of the article can be used in informatics courses, both at school and at university, for the development of interdisciplinary connections between informatics and mathematics and expanding ideas about the possibilities of spreadsheets. The problems presented in the article were successfully solved by 10th grade students (profile "Mathematics. Informatics") and first-year students of pedagogical university of the profiles "Physics. Mathematics", "Physics. Informatics". The article reflects the author's personal experience of teaching the course "Informatics" at South Ural State University of Humanities and Education and at school.

scholarly journals Aplicação do software Excel como ferramenta de ensino para resolução de treliças planas utilizando elementos finitos de barras

2019 ◽  
Vol 40 (2) ◽  
Author(s):  
Charles Jaster De Oliveira ◽  
Luna Ollin Steffen De Oliveira ◽  
Guilherme Macêdo Vogel ◽  
Raphael Brandalise Nunes ◽  
Gabriel Martins Dos Santos
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Visual Basic For Applications

A determinação de esforços axiais e deslocamentos são indispensáveis para a análise e a compreensão de uma treliça. Para tais determinações, há uma constante busca de métodos que possam facilitar e agilizar os cálculos. Através do Método dos Elementos Finitos (MEF), o presente artigo propõe um modelo de planilha eletrônica, desenvolvida no Microsoft Excel®, capaz de calcular os esforços das barras que constituem a treliça plana, bem como os deslocamentos nodais, quando sujeito a forças e restrições de deslocamentos. Afim de não somente apresentar números, de modo didático, o modelo também demonstra graficamente os resultados obtidos utilizando o Visual Basic for Applications (VBA), que é a linguagem de programação do Microsoft Excel®, para ilustrar a estrutura antes e depois da aplicação das forças mostrando os esforços de tração e compressão nas barras e o deslocamento dos nós. O uso da programação no Microsoft Excel® além da facilitar os cálculos, também se faz importante didaticamente, visto que é uma ferramenta capaz de confirmar os resultados que são obtidos via métodos tradicionais, comum nas graduações de engenharia civil e devido a sua fácil curva de aprendizado e a alta disponibilidade do software.

SISTEMA PARA LA ADQUISICIÓN Y PROCESAMIENTO DE DATOS PARA EL ANÁLISIS DE LA OPERACIÓN DEL S.N.I. A PARTIR DE LA APLICACIÓN PI DEL SISTEMA NETWORK MANAGER

2009 ◽  
Vol 5 (1) ◽  
Author(s):  
Roberto Barba ◽  
Raúl Cubillo
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Visual Basic For Applications ◽  
El Sistema ◽  
Network Manager ◽  
Microsoft Office

El Sistema Network Manager de ABB, que actualmente el CENACE utiliza como plataforma para el sistema SCADA, incluye la tecnología de sistemas PI (Plant Information); dicha tecnología se encuentra disponible mediante una aplicación incluida en Excel de Microsoft Office. Considerando la potencialidad de estas herramientas disponibles en el sistema Network Manager, y la necesidad de mantener toda la información del sistema nacional interconectado en una sola fuente de información se planteó el objetivo de crear una aplicación que permita almacenar la información no supervisada en la misma base de datos denominada HIS. El Sistema denominado SADHIS (Sistema de Adquisición de Datos en el Histórico), que actualmente cumple con estos objetivos y utiliza las potencialidades del PI, se desarrolló con el fin de reemplazar al sistema SADYR (Sistema de Adquisición y Registro de información), garantizando que tanto la información supervisada por el sistema SCADA así como la no supervisada, este disponible para la operación en tiempo cuasi real y disponible para realizar cualquier tipo de procesamiento de información post operativa. Las interfaces de ingreso y procesamiento de información que maneja los diferentes módulos de la Aplicación SADHIS están desarrollados mediante programación avanzada de Visual Basic for Applications de Microsoft ®, sobre Microsoft Excel.

scholarly journals IMPLEMENTING AN AUTOMATED SYSTEM TO SIMPLIFY THE DATA MANAGEMENT PROCESS AT PARTS STORAGE AREA OF PT. Z

2017 ◽  
Vol 12 (2) ◽  
pp. 85
Author(s):  
Hery Hamdi Azwir ◽  
M. Yafi Maulidin
Keyword(s):  
Information System ◽  
Current System ◽  
Visual Basic ◽  
Automated System ◽  
User Requirements ◽  
Microsoft Excel ◽  
Advantages And Disadvantages ◽  
Visual Basic For Applications ◽  
Storage Area ◽  
New System

This research concerns about the design and implementation of a new information system which will simplify the processes of the current system and its impact on the warehouse staffs. In order to automate the processes, a programmed information system is designed using Microsoft excel VBA, a basic programming function inside Microsoft excel. First, the current system is analyzed. Next, the user requirements and proposed system requirements are analyzed to make the system design. Then, the program is developed and tested by using VBA (Visual Basic for Applications). Then, the new system is implemented and the implementation results are analyzed. The results found that the new system successfully fulfilled the objectives of this research and the user requirements, although there are still some improvements which need to be done. During two months’ period of implementation, there are some problems encountered which required the programmer to improve the system. Like every system, there are some advantages and disadvantages found in this new system.AbstrakPenelitian ini fokus kepada  desain dan implementasi sistem informasi baru yang akan mengotomatisasi proses dari sistem saat ini dan dampaknya  terhadap staf gudang. Dalam rangka untuk mengotomatisasi proses, sistem informasi yang terprogram dirancang menggunakan Microsoft excel VBA,sebuah  fungsi dasar pemrograman dalam Microsoft excel. Pertama, sistem yang sekarang dianalisis. Selanjutnya, kebutuhan pengguna dan kebutuhan sistem yang diusulkan dianalisis untuk membuat desain sistem. Kemudian, program ini dikembangkan dan diuji dengan menggunakan VBA (Visual Basic for Applications). Kemudian, sistem baru diimplementasikan dan hasil dari implementasi dianalisis. Hasil penelitian menemukan bahwa sistem baru berhasil memenuhi tujuan penelitian ini dan kebutuhan pengguna, meskipun masih ada beberapa perbaikan yang perlu dilakukan. Selama periode dua bulan implementasi, ada beberapa masalah yang dihadapi yang membutuhkan programmer untuk mengembangkan sistemnya. Seperti setiap sistem, ada beberapa kelebihan dan kekurangan yang ditemukan dalam sistem baru ini. 

Sign in / Sign up

Export Citation Format

Share Document