Note : In case if possible in spreadsheet then do it or else do
it in...
Develop a spreadsheet to calculate the moments and reactions at the supports of continuous, multi-span beams by the moment distribution method. For each of the two structures illustrated below: (a) Use your spreadsheet to calculate the moments and reactions at the supports. (b) Draw the complete shear and moment diagrams. Label the diagrams with the values for the peak shears and peak midspan moments. NOTE: Assume that is constant in each case. Case 1: Case II: 30 kips 60 kips AKI 4 klt 2.4 kif TIZ T Tim 15ft 1 15ft 20ft 50ft 40ft constant KI = 3610 ** = 3150 ** 1 = 2860 —