Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
12
result(s) for
"Macroprogramming."
Sort by:
Microsoft Excel 2019 VBA and macros
\"Renowned Excel experts Bill Jelen (Mr Excel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.\"--Amazon.com.
Book
Integrating large language models with internet of things: applications
This paper identifies and analyzes applications in which Large Language Models (LLMs) can make Internet of Things (IoT) networks more intelligent and responsive through three case studies from critical topics: DDoS attack detection, macroprogramming over IoT systems, and sensor data processing. Our results reveal that the GPT model under few-shot learning achieves 87.6% detection accuracy, whereas the fine-tuned GPT increases the value to 94.9%. Given a macroprogramming framework, the GPT model is capable of writing scripts using high-level functions from the framework to handle possible incidents. Moreover, the GPT model shows efficacy in processing a vast amount of sensor data by offering fast and high-quality responses, which comprise expected results and summarized insights. Overall, the model demonstrates its potential to power a natural language interface. We hope that researchers will find these case studies inspiring to develop further.
Article Highlights
Large language models’ performance surpassed traditional machine learning models’ on IoT cyber threat detection.
Large language model demonstrated sufficient understanding in complicated IoT macroprogramming framwork.
Large language models can contribute to automatic data processing by producing high-quality code scripts.
Journal Article
Excel macros for dummies
Save time and become an Excel wizard with the world's leading Excel macro guide
Do you love Excel and all the things you can do with it, but wish you could just work…faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In Excel Macros For Dummies, you'll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer!
Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you'll find:
* Automations that take your Excel productivity to the next level, and beyond
* Fully updated macros compatible with the newest version of Excel included in Microsoft 365
* Careful explanations of the basics as well as tips for the advanced user
With something for everyone, Excel Macros For Dummies is the productivity supercharger you've been waiting for. Grab a copy today!
eBook
Excel VBA macro tutorial for engineers
This basic Excel Macro tutorial demonstrates how to import and export values from a VBA program, display a message box, and write an IF statement. This video is followed by examples on writing this same program in MATLAB and Python.
Streaming Video
Find equation roots with Excel
Two examples show how to (1) find the roots of a cubic equation and (2) find the roots of the Redlich Kwong equation of state that relates pressure and temperature to molar volume for read gasses.
Streaming Video
Visual Basic for applications (VBA) in Excel
VBA adds programming functionality to Microsoft Excel. A Macro is a VBA program that can be recorded to auto-generate code in VBA. VBA is a simplified form of Visual Basic and lacks full-featured programming support. VBA extends the power of Excel, especially for tasks that are repeated.
Streaming Video
101 ready-to-use excel®formulas
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas
101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work.
Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented.
* Teaches you how to implement the required Excel formula
* Explains and details how the formulas work
* Lets you reuse or customize the given formula to address your particular needs
* Helps you make the formulas a regular part of your new, more efficient workflow
Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.
eBook
Logic Macroprogramming for Wireless Sensor Networks
It is notoriously difficult and tedious to program wireless sensor networks (WSNs). To simplify WSN programming, we propose Sense2P, a logic macroprogramming system for abstracting, programming, and using WSNs as globally deductive databases. Unlike macroprograms in previous works, our logic macroprograms can be described declaratively and imperatively. In Sense2P, logic macroprogrammers can easily express a recursive program or query that is unsupported in existing database abstractions for WSNs. We have evaluated Sense2P analytically and experimentally. Our evaluation result indicates that Sense2P successfully realizes the logic macroprogramming concept while consuming minimal energy as well as maintaining completeness and soundness of the answers.
Journal Article
101 ready-to-use Excel macros
Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips. John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.Visit his website at http://spreadsheetpage.com.
eBook