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

Streamline performance of Excel in stepwise implementation of numerical solutions

COMPUTER APPLICATIONS IN ENGINEERING EDUCATION 2016年第4期24卷 555-566页

作者： Niazkar, Majid Afzali, Seied Hosein Shiraz Univ Sch Engn Dept Civil & Environm Engn Shiraz Iran

Excel spreadsheet not only provides useful facilities to solve various kinds of engineering problems, but also can be simply utilized to enhance the curriculum of engineering courses. In this paper, first a summary of literature review on the application of spreadsheets was presented. Reviewing the literature of the application of Excel in different engineering fields shows that Excel was only applied for different individual applicants;while it can be utilized to implement the solution of all kinds of physical problems because of various facilities which Excel provides. In this regard, the step-by-step numerical solutions of several examples from all kinds of physical problems in civil engineering were implemented into Excel. The educational merit of this study is the stepwise implementation of Excel and Visual Basic Application (vba) solution to simple examples of all kinds of physical problems without any advanced requirement of prior knowledge of the software. The robust performance of Excel in solving all the considered examples demonstrates that the Excel appraisal in solving engineering problems should be more addressed than what it is in the current literature. (c) 2016 Wiley Periodicals, Inc. Comput Appl Eng Educ 24:555-566, 2016;View this article online at;DOI

关键词： engineering education excel spreadsheet vba code physical problems stepwise implementation numerical solution

来源：评论

学校读者我要写书评

暂无评论

USING PEARSON TYPE IV AND OTHER CINDERELLA DISTRIBUTIONS IN SIMULATION

USING PEARSON TYPE IV AND OTHER CINDERELLA DISTRIBUTIONS IN ...

引用

Winter Simulation Conference (WSC)/Conference on Modeling and Analysis for Semiconductor Manufacturing (MASM)

作者： Cheng, Russell Univ Southampton Southampton SO17 1BJ Hants England

ISBN: (纸本)9781457721090

Univariate continuous distributions with unbounded range of variation have not been so widely used in simulation as those that are bounded (usually to the left). However situations do occur when they are needed, particularly in operations research and financial applications. Two distributions that have such unbounded range are the Pearson Type IV and Johnson SU distributions. Though both are well known in statistics, there is still a lack of methods in the literature for fitting these distributions to data which are both efficient and comprehensively reliable. Indeed the Pearson Type IV has the reputation of being difficult to fit. In this paper we identify the pitfalls and propose a fitting method that avoids them. We also show how to test the goodness of fit of estimated distributions. All the procedures described are included as vba code in an accompanying Excel workbook available online. Two numerical examples are described in detail.

关键词： Excel workbook Fitting Johnson SU distributions Maximum likelihood estimation Moment methods Optimization Pearson Type IV Pearson type IV Probability density function Reliability vba code cinderella distributions computational complexity continuous distributions financial applications mathematics computing spreadsheet programs statistical distributions visual programming

来源：评论

学校读者我要写书评

暂无评论

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

来源：评论

学校读者我要写书评

暂无评论

Design of Purchase-Sales-Inventory Business Software Based on Excel

Design of Purchase-Sales-Inventory Business Software Based o...

引用

2012 National Conference on Information Technology and Computer Science

作者： Wang Shunjin Accounting and Finance Department of Chongqing College of Electronic Engineering Chongqing,China

Purchase-sales-inventory software is a common tool of small business enterprise information and can be designed by using *** paper focuses on the idea of "fool" business software design with Excel sequence,record pointer and ActiveX control,and introduces the skills in invoking development tool,setting Macro security,using name and sequence,using Excel function,eliminating loop computation,designing record pointer,and designing "Reset" and "Confirm" control buttons in software design.

关键词： Software design ActiveX control vba code record pointer purchase-sales-inventory

来源：评论

学校读者我要写书评

暂无评论

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

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案：

请选择收藏分类：

通借通还

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

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

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

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

通借通还

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

请选择保存的检索档案：

请选择收藏分类：