Answer Happy

You are required to build a table to automatically solve ALL the member forces of the truss shown in Figure 1, once you key in any student ID in the input cell. The variables shown in the figure shall be determined according to the definitions shown in Table 1. Table 1 No. Variable Definition Sample of calculations (ID: 7430602) 2+6=8 1. Pi (kN) Last 1 digit of your ID + 6 2. P: (kN) Last 2 digits of your ID + 10 02+10=12 3. Pi (kN) Last 2 digits of your ID + 30 02+30=32 4. a (m) remainder of 2/4+2=2+2=4 remainder of 0/4+3=0+3=3 5. b (m) (remainder of last digit of your ID divided by 4) +2 (remainder of 2nd last digit of your ID divided by 4) + 3 (remainder of 3rd last digit of your ID divided by 4) + 4 (remainder of 2nd last digit of your ID divided by 4) + 6 6. c (m) remainder of 6/4+4=2+4=6 remainder of 0/4+6-0+6-6 7. d (m) P3 P₂ P2 ↓₁ P2 P₂ ↓↓₁ P₁ P₁ m b d Figure 1 D b K