{"title":"基于Excel Vba和Sap2000 oapi的平面框架结构参数化研究","authors":"A. Quansah, Zhi-quan Xiao, Tresor Ntaryamira","doi":"10.9790/9622-0707091423","DOIUrl":null,"url":null,"abstract":"In this paper, effects of a critical structural parameter, beam-to-column stiffness ratio (on seismic lateral force distribution and its corresponding displacement (s) on frame members were observed. For this purpose, analysis of 12 samples of a 10-storey frame structure having varying beam/ column stiffness was carried out with the help of software facilities. To save time in the modelling and parameterization of the frame structure, a programming tool has been developed combining the functionality of VBA based excel software, Matlab and SAP2000 OAPI. With the help of this tool, parametric analysis of a significant number of frame models can automatically be generated and executed in SAP2000 in a lesser time of 139.0secs and at a less expense of user input. The core interest in performing the analysis is to estimate the responses of varieties of weakcolumn/strong-beam and strong-column/weak-beam multi-story frame subjected to seismic lateral forces by modelling the frame in its actual form[SAP2000] and idealized stick model [hand computation]. From the analysis of the various models, comparison of SAP2000 lateral force distribution and displacement of frame models is made with that of hand calculation.","PeriodicalId":13972,"journal":{"name":"International Journal of Engineering Research and Applications","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2017-08-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Parametric Investigation of Plane Frame Structure Using Excel Vba And Sap2000 oapi Based Programming\",\"authors\":\"A. Quansah, Zhi-quan Xiao, Tresor Ntaryamira\",\"doi\":\"10.9790/9622-0707091423\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In this paper, effects of a critical structural parameter, beam-to-column stiffness ratio (on seismic lateral force distribution and its corresponding displacement (s) on frame members were observed. For this purpose, analysis of 12 samples of a 10-storey frame structure having varying beam/ column stiffness was carried out with the help of software facilities. To save time in the modelling and parameterization of the frame structure, a programming tool has been developed combining the functionality of VBA based excel software, Matlab and SAP2000 OAPI. With the help of this tool, parametric analysis of a significant number of frame models can automatically be generated and executed in SAP2000 in a lesser time of 139.0secs and at a less expense of user input. The core interest in performing the analysis is to estimate the responses of varieties of weakcolumn/strong-beam and strong-column/weak-beam multi-story frame subjected to seismic lateral forces by modelling the frame in its actual form[SAP2000] and idealized stick model [hand computation]. From the analysis of the various models, comparison of SAP2000 lateral force distribution and displacement of frame models is made with that of hand calculation.\",\"PeriodicalId\":13972,\"journal\":{\"name\":\"International Journal of Engineering Research and Applications\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-08-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Journal of Engineering Research and Applications\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.9790/9622-0707091423\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal of Engineering Research and Applications","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.9790/9622-0707091423","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Parametric Investigation of Plane Frame Structure Using Excel Vba And Sap2000 oapi Based Programming
In this paper, effects of a critical structural parameter, beam-to-column stiffness ratio (on seismic lateral force distribution and its corresponding displacement (s) on frame members were observed. For this purpose, analysis of 12 samples of a 10-storey frame structure having varying beam/ column stiffness was carried out with the help of software facilities. To save time in the modelling and parameterization of the frame structure, a programming tool has been developed combining the functionality of VBA based excel software, Matlab and SAP2000 OAPI. With the help of this tool, parametric analysis of a significant number of frame models can automatically be generated and executed in SAP2000 in a lesser time of 139.0secs and at a less expense of user input. The core interest in performing the analysis is to estimate the responses of varieties of weakcolumn/strong-beam and strong-column/weak-beam multi-story frame subjected to seismic lateral forces by modelling the frame in its actual form[SAP2000] and idealized stick model [hand computation]. From the analysis of the various models, comparison of SAP2000 lateral force distribution and displacement of frame models is made with that of hand calculation.