Excel VBA Macros : Revolutionize Solar Loads Application

Опубликовано: 24 Май 2026
на канале: Analysis & Design Studio
1,247
33

Get ready for an in-depth tutorial! This video is perfect for structural engineers familiar with Midas Gen. In my latest video, I'm unveiling my custom Excel spreadsheet designed for applying solar loads in Midas Gen using tables. With the power of Excel VBA Macros, I've streamlined the process, making load transfer to specific beams in the model effectively, efficiently and in the fastest pace. Join me as I walk you through every step of using this powerful tool. Don't miss out on mastering solar load application—watch now!
#SolarLoads #ExcelVBA #StructuralEngineering #MidasGen #automation

============================================================================
SOLAR PANEL STRUCTURE DESIGN SERIES (From Zero to Hero)
============================================================================

1) Analysis and Design of Solar Structure | Basic Concepts and Considerations |
   • Analysis and Design of Solar Structure | P...  

2) Solar Panel Wind Loads (ASCE 7) in SAP2000 using (Interactive Database and Excel Macros Sheet)
   • Solar Panel Wind Loads (ASCE 7) in SAP2000...  

3) Solar Structure Design | Layout in AutoCAD | Boost Project Efficiency
   • Solar Structure Design | Layout in AutoCAD...  

4) Modelling Solar Structure using MIDAS GEN - Accelerate Your Project Delivery
   • Modelling Solar Structure using MIDAS GEN ...  

5) Solar Load Calculations: Build Wind-Resistant Structures
   • Solar Load Calculations: Build Wind-Resist...  

6) Application of Solar Loads in Midas Gen
   • Application of Solar Loads in Midas Gen  

============================================================================
WIND LOAD CALCULATIONS USING ASCE 7-16 (Application on Real Life Structures)
============================================================================

1) Basic Mechanism of Wind Load on Structures
   • Wind Loads Calculations using ASCE 7-16 - ...  

2) Example Problem 1 - Wind Load Calculations (ASCE 7-16)
   • Example Problem 1 for Wind Load Calculatio...  

3) Example Problem 2 (MonoSlope Roof) - Wind Load Calculations (ASCE 7-16)
   • Example Problem 2 (Mono-slope Roof Buildin...  

4) Example Problem 3 (Gable Roof Building) - Wind Load Calculations (ASCE 7-16)
   • Example Problem 3 (Gable Roof Building) fo...  

===============================================================
Time Lapse Videos
===============================================================

1) Applying Wind Loads in SAP2000 - Example 1 Time Lapse
   • Applying Wind Loads in SAP2000 - Example 1...  

2) Solar Panel Wind Loads (ASCE 7) in SAP2000 using (Interactive Database and Excel Macros Sheet)
   • Solar Panel Wind Loads (ASCE 7) in SAP2000...  

===============================================================
THEORETICAL TOPICS
===============================================================

1) Concept of Effective Length Factor for Column Design (Manual Calculations ; Verify from Software)
   • Concept of Effective Length Factor for Col...  

===============================================================
STEEL CONNECTION DESIGN COURSE USING IDEA STATICA VIDEOS LINKS:
===============================================================
1) Truss Connection (Braces+Bottom Chord) - Steel Connection Design Series using IDEA STATICA
   • Truss Connection (Braces+Bottom Chord) - S...  

2) Truss Connection(Top Chord+Braces+Purlins)-Steel Connection Design Series using IDEA STATICA
   • Truss Connection(Top Chord+Braces+Purlins)...  

3) Truss Connection (Main Chords + I Girder)-Steel Connection Design Series using IDEA STATICA
   • Truss Connection (Main Chords + I Girder)-...  

==========================================================================
STEEL STRUCTURES ANALYSIS AND DESIGN COURSE USING MIDAS GEN VIDEOS LINKS:
==========================================================================
1) SIMPLE STEEL TRUSS SHED (Part 1)
   • Steel Structures: Analysis/Design Course u...  

2) SIMPLE STEEL TRUSS SHED (Part 2)
   • Steel Structures: Analysis/Design Course u...  

============================================================================
REINFORCED CONCRETE ANALYSIS AND DESIGN COURSE USING MIDAS GEN VIDEOS LINKS:
============================================================================
1) INTRODUCTION TO THE COURSE:
   • Reinforced Concrete Analysis & Design Cour...  

2) EX 1: SIMPLE BEAM ANALYSIS:
   • Reinforced Concrete Analysis & Design Cour...  

3) EX 2: SIMPLE BEAM DESIGN:
   • Reinforced Concrete Analysis & Design Cour...  

4) EX 3: BEAM CHECK FOR ANY GIVEN REBARS:
   • Reinforced Concrete Analysis & Design Cour...  

5) EX 4: ANALYSIS AND DESIGN OF FRAME
   • Reinforced Concrete Analysis & Design Cour...  

6) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART1)
   • RC Analysis/Design Course-MIDAS GEN - EX5:...  

7) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART2)
   • RC Analysis/Design Course-MIDAS GEN - EX5:...  

8) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART3)
   • RC Analysis/Design Course-MIDAS GEN - EX5:...  
================================================================

Thank You for Watching our videos.
If you Like our videos then please Hit Like/Subscribe Button and Comments. Also Share with your friends to encourage us.

Best Regards
ANALYSIS AND DESIGN STUDIO