Can help calculate ASAP and the last 4 digits ID is 4007, will give like! manual calculation for the member forces of th

[answerhappygod]

Can help calculate ASAP and the last 4 digits ID is
4007, will give like!
manual calculation for the member forces of the truss
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. P; (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₂ P₂ Дн P2 P₂ P₁ a b d Figure 1 D b K a FL