MENU

Fun & Interesting

Excel VBA Macros : Revolutionize Solar Loads Application

Video Not Working? Fix It Now

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 | https://youtu.be/mbFPveO7DVE?si=MGWwu5h8xDpsQ-Ux 2) Solar Panel Wind Loads (ASCE 7) in SAP2000 using (Interactive Database and Excel Macros Sheet) https://youtu.be/5NAJw7fB33o?si=OjlKaDTtXz6pDFpi 3) Solar Structure Design | Layout in AutoCAD | Boost Project Efficiency https://youtu.be/tQNfYqaPcv4?si=ewAe1g449ZXRe_5a 4) Modelling Solar Structure using MIDAS GEN - Accelerate Your Project Delivery https://youtu.be/IdSsnZrL4Ho?si=zqnnVCYDN0SO8FFD 5) Solar Load Calculations: Build Wind-Resistant Structures https://youtu.be/KNYqv2kdxQA?si=Iymk_LDHJkaqIHg_ 6) Application of Solar Loads in Midas Gen https://youtu.be/0ar7yzTcSnw?si=TAeMU-JwZc4gKmkU ============================================================================ WIND LOAD CALCULATIONS USING ASCE 7-16 (Application on Real Life Structures) ============================================================================ 1) Basic Mechanism of Wind Load on Structures https://youtu.be/0HsJsvBh1JQ 2) Example Problem 1 - Wind Load Calculations (ASCE 7-16) https://youtu.be/B3wh9LVP1E4 3) Example Problem 2 (MonoSlope Roof) - Wind Load Calculations (ASCE 7-16) https://youtu.be/COFEI0Td5gA 4) Example Problem 3 (Gable Roof Building) - Wind Load Calculations (ASCE 7-16) https://youtu.be/rjJ2yjLxm3w?si=G32fQrfPQ1CjT_T8 =============================================================== Time Lapse Videos =============================================================== 1) Applying Wind Loads in SAP2000 - Example 1 Time Lapse https://youtu.be/KzRpcJb5esA 2) Solar Panel Wind Loads (ASCE 7) in SAP2000 using (Interactive Database and Excel Macros Sheet) https://youtu.be/5NAJw7fB33o =============================================================== THEORETICAL TOPICS =============================================================== 1) Concept of Effective Length Factor for Column Design (Manual Calculations ; Verify from Software) https://youtu.be/mB9kzZdtGXE =============================================================== STEEL CONNECTION DESIGN COURSE USING IDEA STATICA VIDEOS LINKS: =============================================================== 1) Truss Connection (Braces+Bottom Chord) - Steel Connection Design Series using IDEA STATICA https://youtu.be/XCO6kzuJjrs 2) Truss Connection(Top Chord+Braces+Purlins)-Steel Connection Design Series using IDEA STATICA https://youtu.be/2hMIuur-2lg 3) Truss Connection (Main Chords + I Girder)-Steel Connection Design Series using IDEA STATICA https://youtu.be/LjmxToQWIz8 ========================================================================== STEEL STRUCTURES ANALYSIS AND DESIGN COURSE USING MIDAS GEN VIDEOS LINKS: ========================================================================== 1) SIMPLE STEEL TRUSS SHED (Part 1) https://youtu.be/7Gf-Qovq9_k 2) SIMPLE STEEL TRUSS SHED (Part 2) https://youtu.be/08YG9WY3L2s ============================================================================ REINFORCED CONCRETE ANALYSIS AND DESIGN COURSE USING MIDAS GEN VIDEOS LINKS: ============================================================================ 1) INTRODUCTION TO THE COURSE: https://youtu.be/sNxOfkYGZ94 2) EX 1: SIMPLE BEAM ANALYSIS: https://youtu.be/4rRlsPmvSAc 3) EX 2: SIMPLE BEAM DESIGN: https://youtu.be/IUKYsOUJmGo 4) EX 3: BEAM CHECK FOR ANY GIVEN REBARS: https://youtu.be/mnqN5lm4TXE 5) EX 4: ANALYSIS AND DESIGN OF FRAME https://youtu.be/UaK2hBkXSkQ 6) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART1) https://youtu.be/hcjO9KSAypY 7) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART2) https://youtu.be/TBTwq4XKm1Y 8) EX5: MODELLING, ANALYSIS & DESIGN OF ONE STORY HOUSE (PART3) https://youtu.be/Dsc6Aba6ho8 ================================================================ 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

Comment