固端弯矩求解与绘图输入梁跨满跨均布荷载局部均布荷载!!!!!集中1集中27.8000002.605.2000002.605.27.800007.80000说明:只填带红三角的无色格,注意应按格内批注填,有颜色的格不得随意更改。没有该种荷载时,将有相应荷载下红三角格内数据填为零。节点号杆件号上柱下柱ABBA上柱下柱BC刚度系数ib,icD5E5F5H5I5分配系数#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C7节点号杆件号上柱下柱ABBA上柱下柱BC刚度系数ib,icC16D16E5F5G5H5I5分配系数#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C18层号4层层号3层AB1轴线框架在恒载作用下的弯矩2次分配法计算表(表A)1轴线框架梁柱线刚度、固端弯矩总表AB0102001.22.43.64.867.2q(kN/m),P(kN)L(m)节点号杆件号上柱下柱ABBA上柱下柱BC刚度系数ib,icC27D27E27F27G27H27I27分配系数#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C29节点号杆件号上柱下柱ABBA上柱下柱BC刚度系数ib,icC5D5E5F5G5H5I5分配系数#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C40注:本表采用弯矩二次分配法计算,对框架弯矩进行整体分配和传递,底层与各层的柱的线刚度均不乘以0.9,传递系数均取1/2。本表对力矩分配、传递层号2层层号1层使用方法:只需在该EXCEL A表格中输入相应的梁柱线刚度系数和固端弯矩即可 计算结果EXCEL自动给出尤其对高层演算效率突出!有计算过程和准确的结果 对于更高的楼层只需在本电子表格基础上简单的复制粘贴再将复制的上下柱传递函数改一下即可!ABAB固端弯矩求解与绘图三角1三角2梯形1梯形20003.60003.6001.3514.35.40205.402.70302.37505.804.37507.20没有该种荷载时,将有相应荷载下红三角格内数据填为零。左端固端弯矩右端固端弯矩0均布0均布0局部0局部0集中10集中10集中20集中2-16.707856三角14.09142三角10三角20三角20梯形10梯形10梯形20梯形2-16.71最终4.09142最终-16.714.09142CB上柱下柱CDDC上柱下柱DEEDJ5L5M5N5P5Q5R5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!CB上柱下柱CDDC上柱下柱DEEDJ5K5L5M5N5O5P5Q5R5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!CDE1轴线框架在恒载作用下的弯矩2次分配法计算表(表A)1轴线框架梁柱线刚度、固端弯矩总表CDECB上柱下柱CDDC上柱下柱DEEDJ27K27L5M5N5O5P5Q5R5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!CB上柱下柱CDDC上柱下柱DEEDJ5K5L5M5N5O5P5Q5R5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!注:本表采用弯矩二次分配法计算,对框架弯矩进行整体分配和传递,底层与各层的柱的线刚度均不乘以0.9,传递系数均取1/2。本表对力矩分配、传递使用方法:只需在该EXCEL A表格中输入相应的梁柱线刚度系数和固端弯矩即可 计算结果EXCEL自动给出尤其对高层演算效率突出!有计算过程和准确的结果 对于更高的楼层只需在本电子表格基础上简单的复制粘贴再将复制的上下柱传递函数改一下即可!CDECDE上柱下柱上柱下柱ABBAT5刚度系数ib,ic0.000D5E5F5#VALUE!#VALUE!分配系数#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C70.0000.0000.000分配#VALUE!#VALUE!#VALUE!#VALUE!传递#REF!#VALUE!#VALUE!#VALUE!分配#REF!#REF!#REF!#VALUE!Σ#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱上柱下柱ABBAS5T5刚度系数ib,icC16D16E5F5#VALUE!#VALUE!分配系数#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C180.0000.0000.000荷载类型恒载荷载类型恒载杆件号3层E节点号ABAB杆件号(表B)弯矩2次分配与传递表4层E节点号分配#VALUE!#VALUE!#VALUE!#VALUE!传递#VALUE!#VALUE!#VALUE!#VALUE!分配#VALUE!#VALUE!#VALUE!#VALUE!Σ#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱上柱下柱ABBAS5T5刚度系数ib,icC27D27E27F27#VALUE!#VALUE!分配系数#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C290.0000.0000.000分配#VALUE!#VALUE!#VALUE!#VALUE!传递#VALUE!#REF!#VALUE!#VALUE!分配#VALUE!#VALUE!#VALUE!#VALUE!Σ#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱上柱下柱ABBAS5T5刚度系数ib,icC5D5E5F5#VALUE!#VALUE!分配系数#VALUE!#VALUE!#VALUE!#VALUE!固端弯矩C400.0000.0000.000分配#VALUE!#VALUE!#VALUE!#VALUE!传递#VALUE!#REF!#VALUE!#VALUE!分配#VALUE!#VALUE!#VALUE!#VALUE!Σ#VALUE!#VALUE!#VALUE!#VALUE!恒载荷载类型恒载杆件号荷载类型恒载1层E节点号ABAB杆件号E节点号2层上柱下柱BCCB上柱下柱CDDC上柱0.000H5I5J50.000L5M5N50.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.0000.0000.0000.0000.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱BCCB上柱下柱CDDC上柱G5H5I5J5K5L5M5N5O5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.0000.0000.0000.0000.000CD3层BBCD(表B)弯矩2次分配与传递表4层#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱BCCB上柱下柱CDDC上柱G27H27I27J27K27L5M5N5O5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.0000.0000.0000.0000.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!上柱下柱BCCB上柱下柱CDDC上柱G5H5I5J5K5L5M5N5O5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.0000.0000.0000.0000.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!D1层BCBCD2层下柱DEED上柱下柱P5Q5R50.000T5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#REF!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!下柱DEED上柱下柱P5Q5R5S5T5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.000DEDE#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!下柱DEED上柱下柱P5Q5R5S5T5#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.0000.0000.0000.0000.000#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!下柱DEED上柱下柱P5Q5R5S5T5#VALUE!#VALUE!#VALUE!#VAL