|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/engineering-calculations-using-microsoft-excel/
课程评论：没有评论
**工程计算与Microsoft Excel (Coursera)** 本课程旨在帮助工程师们掌握使用Microsoft Excel进行工程计算的技能，无需成为专业的软件开发者。课程将指导您如何利用Excel的编程能力，创建自定义的工程计算解决方案，以应对包括EUROCODES在内的现代工程标准。 **课程亮点：** * **快速创建定制化计算：** 您将学会如何在几分钟内构建自己的工程计算模型。 * **直观的输入与可视化：** 学习如何设计简洁的输入参数单元格，并结合图示和标注来直观展示计算基础。 * **灵活的公式与迭代：** 掌握在Excel中定义简单到复杂的数学公式及迭代计算的方法。 * **自动化计算流程：** 了解如何创建按钮来触发计算，并编写代码来执行计算和显示结果。 * **可更新与可维护：** Excel解决方案的优势在于易于随时更新和修改公式。 * **实际应用示例：** 课程将深入讲解如何进行结构分析等实际工程计算，包括数据输入、公式定义、结果显示和单元格格式化。 * **详尽的步骤解析：** 提供易于理解的教学材料，详细解释所有步骤和源代码。 **学习内容包括：** * 设置输入参数单元格 * 创建带标注的计算草图 * 准备结果显示单元格 * 创建触发计算的按钮 * 编写用于执行计算的代码 * 编写用于显示计算结果的代码 * 执行工程计算 本课程为您提供了一个强大、灵活且易于实现的工程计算解决方案，让您可以轻松应对日常工程挑战。
As every Engineer needs to do many daily calculations especially using modern standards like EUROCODES, the need to write custom software solutions is more and more real. Especially if standards includes many complex formulas which are hardly calculated using pocket computers as it was 30 years ago. Then it came programmable pocket computers, I clearly remember as I had SHARP programmable computer, where it was possible to write a complex software, but you couldn't print the results as it is possible now. So today it is possible just by using Microsoft Excel and it's programming abilities to write real software which can solve all daily engineering calculations with ease. What does engineer need? So what does engineer need when creating calculations? First there are input parameters, which should be entered on a very simple and a quick way, then a simple sketch as a graphical representation of the basis of calculation with annotations of input parameters. After that engineer needs to define the mathematical procedure which could be very simple, but it should also enable him, to write also more complex formulas or iterations. This is very easy to do with Excel. Course Structure In this course I will show you that you do not need to be a software developer to create your own customized engineering calculations in a minutes. What is maybe the most important, you can update formulas in your calculation any time you want. This is the solution that every engineer needs, because it offers open-source solution with powerfull programable tools, but on the other side simple enough to be done instantly. We will learn the following topics: - How to create cells where input parameters should be entered - How to create a sketch with anotations of input parameters - How to prepare cells where results of calculation will be written - How to create a push button, where you will trigger start of the calculation - How to write code to perform calculation - How to write code to display the results of calculation - How to perform calculation This course will also show you how to write the software for practical engineering calculation for structural analysis. I will show you in detail, how to enter data, define formulas and actually perform calculation, including how to display results and format cells for results of calculation. I will provide you with an easy-to-follow material explanation, all steps including source code will be explained in detail.
