ChatGPT-Assisted Engineering Spreadsheets 2.0
About This Seminar
After the overwhelming success of our first spreadsheets seminar with 90+ participants, we are back with an advanced sequel that goes deeper into ChatGPT-powered spreadsheet engineering.
This is not a repeat — Spreadsheets 2.0 covers entirely new ground: advanced formula generation, dynamic automation with VBA macros, error-checking workflows, conditional formatting for engineering outputs, and professional-grade calculation sheet templates that you can use directly in your projects.
Whether you attended the first seminar or not, this session is designed to take your engineering spreadsheet skills to a professional level.
What Makes 2.0 Different?
Version 1.0 covered the basics: formula drafting, worksheet organization, and introduction to automation.
Version 2.0 goes advanced: dynamic macros, error-trapping, multi-sheet automation, professional formatting, and complex structural calculation templates.
Detailed Seminar Agenda
Multi-step formula generation techniques. Nested IF, INDEX-MATCH, and array formulas via AI. Engineering-specific formula patterns: interpolation, code lookups, capacity calculations. Debugging formulas with ChatGPT assistance.
Introduction to VBA macros generated by ChatGPT. Automating repetitive tasks: batch calculations, auto-fill, report generation. Creating dynamic dashboards that update automatically. Button-triggered calculations and one-click report generation.
Building self-checking spreadsheets that flag errors. Data validation rules for engineering inputs. Conditional formatting for pass/fail indicators. Creating audit trails and calculation verification systems.
Building a complete RC beam design calculation sheet. Creating a footing design template with auto-sizing. Professional formatting: headers, borders, print areas, company branding. Multi-sheet project workbooks with linked calculations.
Sample Spreadsheets You Will Receive
- RC Beam Design Calculator — Complete flexural and shear design per ACI 318/NSCP
- Isolated Footing Design Sheet — With auto-sizing, punching shear check, and settlement estimate
- Load Combination Generator — Automatic NSCP/ASCE 7 load combination builder
- Steel Section Database — Searchable W-section properties with capacity calculations
- Rebar Schedule Template — Automated bar listing with cut length and weight summary
Your Resource Speaker
Engr. Ruel H. Cepeda
Structural Engineer | AI Practitioner | Founder, RHCEPEDA Engineering Services
Engr. Cepeda is a licensed civil engineer specializing in structural analysis and design, with extensive experience in both local and international projects. He is the creator of RHCES Tools and RHCES Estimator, digital products used by hundreds of practicing engineers across the Philippines, Saudi Arabia, and the UAE.
As an AI practitioner, he actively integrates ChatGPT and modern AI workflows into his engineering practice — from automated spreadsheet generation to building full-featured desktop and web applications. His seminars focus on practical, real-world applications that engineers can immediately use in their daily work.
Who Should Attend
- Graduates of the first ChatGPT Spreadsheets seminar looking for advanced techniques
- Engineers who already use Excel daily and want to work smarter
- Structural designers who produce calculation sheets regularly
- Engineering managers who want standardized calculation templates for their team
- Fresh engineers and students are also welcome (no prerequisite required)
What You Will Receive
Frequently Asked Questions
No. While it helps, this seminar is designed to be self-contained. Basic Excel knowledge is the only prerequisite.
Excel 2016 or newer is recommended. Excel 365 is ideal for the latest formula features. Google Sheets works for most content but VBA macros are Excel-only.
You will learn how to use ChatGPT to generate VBA macros. You do not need to memorize VBA syntax — the AI writes it for you based on your engineering requirements.
Registration Fee
50% OFF — Limited Slots! First 10 participants only.
Comments
Loading comments...
Leave a Comment