土木毕业设计内力组合EXCEL计算表格

Z3左来地震

层次Mbl Mbr Mc 1.1Mb调整?Mc调Mc 120205.000225.5No0

-8181 110367.00-12403.7Yes3232

-137371371 100288.00-33316.8Yes8080

-98237237 90373.00-63410.3Yes168168

-91242242 80380.00-65418Yes163163

-101255255 70386.00-58424.6Yes153153

-103272272 60361.00-79397.1Yes205205

-74192192 50313.00-27344.3Yes8686

-81258258 40285.00-47313.5Yes137137

-60177177 30263.00-53289.3Yes199199

-249090 20184.00-25202.4Yes108108

-229595 10173.00-43190.3Yes101101

-3889133 Z4左来地震

层次Mbl Mbr Mc 1.1Mb调整?Mc调Mc 12378.0033.00036.3No0

-215215 11455.00154.00-117669.9Yes238238

-213432432 10463.00166.00-140691.9Yes284284

-200408408 9488.00207.00-164764.5Yes331331

-215434434 8498.00225.00-176795.3Yes354354

-220441441 7499.00223.00-179794.2Yes359359

-217436436 6486.00216.00-179772.2Yes358358

-208415415 5459.00185.00-158708.4Yes315315

-197394394 4443.00163.00-161666.6Yes321321

-173345345 3420.00138.00-175613.8Yes346346

-135268268 2400.00109.00-167559.9Yes330330

-116230230 1343.0035.00-161415.8Yes324324

-461569

Z3右来地震

层次Mbl Mbr Mc 1.1Mb调整?Mc调Mc 120-411.000452.1No0

275275 110-653.00179718.3Yes293293

259425425 100-562.00167618.2Yes264264

223354354 90-659.00200724.9Yes327327

242398398 80-680.00209748Yes349349

238399399 70-678.00220745.8Yes363363

232383383 60-673.00196740.3Yes326326

249414414 50-637.00216700.7Yes344344

224356356 40-605.00203665.5Yes332332

204334334 30-595.00211654.5Yes331331

206323323 20-516.00205567.6Yes326326

152242242 10-497.00208546.7Yes370370

99176265 Z4右来地震

层次Mbl Mbr Mc 1.1Mb调整?Mc调Mc 1238.00-419.000460.9No0

244244 11-55.00-524.00138576.4Yes218218

227358358 10-63.00-536.00153589.6Yes246246

214344344 9-94.00-573.00176630.3Yes274274

229356356 8-108.00-587.00191645.7Yes291291

233355355 7-107.00-585.00192643.5Yes293293

230351351 6-104.00-574.00190631.4Yes293293

219338338 5-81.00-541.00170595.1Yes268268

208327327 4-67.00-519.00171570.9Yes276276

182295295 3-50.00-492.00182541.2Yes304304

143237237 2-30.00-463.00176509.3Yes299299

124211211 125.00-389.00167427.9Yes326326

53102153