检索结果-内蒙古大学图书馆

4th International Conference on Digital Technologies and Applications (ICDTA)

作者： Ed-daymouni, Oussama El Alaoui, Mustapha Hassouny, Maria El Amraoui, Khalid Elhamdaoui, Abderrahim Gouztal, Oumaima Chakchak, Hind Masmoudi, Lhoussaine Fares, Boubker Rouchdi, Mustapha Mohammed V Univ Fac Sci Energy Res Ctr Grp Semicond & Environm Sensor Technol BP 1014 Rabat Morocco Mohammed V Univ Rabat Fac Sci Phys Dept LCS Lab Rabat Morocco Ctr Natl Rech Sci & Tech UATRS CNRST Unites Appui Tech Rech Sci BP 8027 NU Rabat 10102 Morocco

ISBN: (纸本)9783031686740;9783031686757

The use of Key Performance Indicators (KPIs) is essential for tracking and supervising current performances, defining improvement areas, and assessing the effects of implemented modifications. There are different methods for visualizing and analyzing data that can offer important information and insights to operators and managers. However, many current visualization tools can be costly, time-consuming to develop, require programming skills, and pose accessibility constraints. This study introduces an application that has been developed using Microsoft Excel and Visual Basic for Applications (vba) programming language to expedite and improve KPIs analysis. The application (app) enables automated calculations and generates interactive dashboards. It facilitates KPIs tracking, supervising processes, and enhancing the ability to analyze data and make good decisions. Microsoft Excel and vba language familiarity and accessibility make the app a user-friendly platform for monitoring KPIs data across different organizational levels. These findings explain the adoption of Microsoft Excel and vba language as a technology for data analysis. These tools enable organizations to make informed decisions based on precise and reliable data analysis. The research focuses on key performance indicators relevant to production services in corporations. A vba application has been rapidly developed to present interactive dashboards and comprehensive analysis, ensuring flexibility, accessibility, and reliability simultaneously.

关键词： Excel vba programming KPIs Data analysis

来源：评论

学校读者我要写书评

暂无评论

Excel vba programming For Dummies 5th Edition 5

引用

丛书名： For Dummies

2018年

作者： Michael Alexander

ISBN: (数字)9781119518235

ISBN: (纸本)9781119518174

Take your Excel programming skills to the next level To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (vba). Excelvba programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, youll find an overview of the essential elements and concepts for programming with Excel. In no time, youll discover techniques for handling errors and exterminating bugs, working with range objects and controlling program flow, and much more. With friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, readers will be creating Excel applications custom fit to their unique needs! Fully updated for the new Excel 2019 Step-by-step instructions for creating vba macros to maximize productivity Guidance on customizing your applications so they work the way you want All sample programs, vba code, and worksheets are available at *** Beginning vba programmers rejoice! This easy-to-follow book makes it easier than ever to excel at Excel vba!

关键词： Office 2019 Microsoft Office Microsoft Office 2019 Word Microsoft Word Excel Microsoft Excel Excel vba Excel vba programming vba vba programming programming using Excel vba using Excel vba programming Excel vba programming For Dummies Michael Alexander

来源：评论

学校读者我要写书评

暂无评论

Excel vba programming For Dummies 4

引用

2015年

作者： Walkenbach John

ISBN: (数字)9781119077411

ISBN: (纸本)9781119077398

Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (vba). This 4th edition of Excel vba programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program flow, and much more. With the release of Microsoft Office 2016, Excel will see changes in its operating system, and this fun, hands-on guide will make it easier than ever to harness the power of Visual Basic for Applications and create custom applications and macros on the world's most popular spreadsheet tool. Packed with friendly advice on the easiest ways to develop custom dialog boxes, toolbars, and menus, you'll be creating Excel applications custom-fit to your unique needs in no time at all! Provides step-by-step instructions for creating vba macros to maximize productivity Helps to increase efficiency by demonstrating how to customize your applications so they look and work the way you want Fully updated for Excel 2016 All sample programs, vba code, and worksheets are available at *** If you're a beginning to intermediate vba programmer looking to get up to speed on creating customized solutions with Excel applications, Excel vba programming For Dummies, 4th Edition makes it easier.

关键词： Excel vba programming For Dummies Excel 2016 John Walkenbach Excel vba Excel vba programming vba programming Excel new version of Excel vba code Excel programming Excel programming skills Visual Basic for Applications new edition of Excel vba programming For Dummies new Excel options Excel options Visual Basic Editor Microsoft Office new release of Microsoft Office spreadsheet tool popular spreadsheet tool

来源：评论

学校读者我要写书评

暂无评论

Evaluation of seismic bearing capacity on layered geological strata by the upper-bound numerical method

引用

ENGINEERING GEOLOGY 2024年 341卷

作者： Wang, Nai-Xin Chen, Zu-Yu Sun, Ping Wang, Yu-Jie China Inst Water Resources & Hydropower Res State Key Lab Simulat & Regulat Water Cycle River Beijing 100038 Peoples R China

This study introduces the Energy Method Upper-bound (abbreviated as EMU), originally proposed by Donald and Chen (1997), for calculating bearing capacities with a focus on earthquake loadings affecting layered geological strata. The theoretical components of this study consist of (1) an extension of Prandtl's solution for bearing capacity analysis to inclined surface loads, (2) a mathematical demonstration of the theoretical congruence between EMU and the Prandtl-Reissner solution, and (3) a validation of the numerical outcomes through four illustrative bearing capacity examples with known closed-form solutions. This innovative approach eliminates the semi-empirical coefficients typically required in conventional bearing capacity evaluations, thus enhancing its relevance to seismic analysis for stratified geological formation that can hardly be evaluated with empirical coefficients accurately. The study also discusses various technical aspects such as seismic load determination, the use of undrained shear strength, and specifications for allowable safety factors under seismic conditions. With these methodologies, the paper assesses the seismic bearing capacities of two different buildings, with different scales and footing types. Additionally, a computer program, BEARING-IWHR, featuring an Excel interface and open-source coding, is available online. This method provides a theoretically sound and practically feasible framework for addressing seismic bearing capacity on stratified foundations.

关键词： Layered geological strata Seismic bearing capacity Upper-bound analysis Earthquake loadings vba programming

来源：评论

学校读者我要写书评

暂无评论

DEVELOPING DECISION RULES FOR THE RAINFALL INDEX INSURANCE PROGRAM: AN APPLICATION TO PENNSYLVANIA PRODUCERS

DEVELOPING DECISION RULES FOR THE RAINFALL INDEX INSURANCE P...

引用

作者： Jimenez Maldonado, Alwin J PennState University Libraries

学位级别：Doctor of Philosophy

This study analyzed a pilot insurance program for pastures, rangeland, and forage called Rainfall Index (RI-PRF). It is designed as a risk management tool to insure against declines in the accumulated rainfall index within a geographic grid. Although conceptually RI is an easy to understand risk management tool, it also represents a complex set of choices of coverage levels and index intervals that can be confusing for producers who have seldom used crop insurance before. Overall, the producer’s decision process will consist of the following: 1) should I insure? 2) If I insure, which index intervals should I insure? and 3) If I insure, what level of coverage should I choose? Because the RI insurance policy is not available nationwide, success with this pilot program is critical to its expansion. The expected benefit to forage and livestock producers from this study is to simplify the process of evaluating the multitude of decisions under RI. To generate the probability density functions required for the Monte Carlo simulation, a mean-reverting time series process was the approach used to modeling the rainfall indices. A vba macro program was written to calculate the premium costs and conduct a Monte Carlo simulation of the potential indemnity payments due when the rainfall index falls below a given trigger grid index. The model was evaluated using the historical rainfall index data from a representative grid in ten counties in the state of Pennsylvania as case studies: Beaver, Clearfield, Erie, Greene, Lancaster, Tioga, Venango, Wayne, Westmoreland, and Wyoming. For seven of the 10 counties, the choice with the highest mean net indemnity per acre, regardless of the coverage levels, was to insure for the entire year (January-December). The results also indicate that the mean net indemnities increase as the number of index intervals insured also increase. Moreover, the period from March to May should be insured regardless of the total number of index intervals to insu

关键词： Monte Carlo simulations rainfall index crop insurance mean-reversion process time series analysis vba programming

来源：评论

学校读者我要写书评

暂无评论

Hydropower Computation Using Visual Basic for Application programming

引用

Physics Procedia 2012年 24卷 37-43页

作者： Wang Yan Hu Hongliang State Key Lab. of Hydraulics and Mountain River Eng. Sichuan University Chengdu China School of Hydraulic Engineering Sichuan University Chengdu China

Hydropower computation is essential to determine the operating conditions of hydroelectric station. Among the existing methods for hydropower computation, equal monthly hydropower output and dynamic programming are the most commonly used methods, but both of them are too complex in computation and hard to be finished manually. Taking the advantage of the data processing ability of Microsoft Excel and its attached Visual Basic for Application (vba) program, the complex hydropower computation can be easily achieved. An instance was analyzed in two methods and all delt with vba. vba demonstrates its powerful function in solving problem with complex computation, visualizing, and secondary data processing. The results show that the dynamic programming method was more receptive than the other one.

关键词： hydropower computation output of hydropower station vba programming equal monthly output dynamic programming

来源：评论

学校读者我要写书评

暂无评论

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案：

请选择收藏分类：

通借通还

建议与咨询 留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案： 新增检索档案 确定 取消

请选择收藏分类： 新增自定义分类 确定 取消

通借通还

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

请选择保存的检索档案：

请选择收藏分类：