Spreadsheet: 783537d1654887043-vlookup-index-match-vertical-data-set-column-forces-export-1-
Sheet: Member Forces - Columns

First-order linear
31 1.0 Gk
A/1
 |  |  |  |  |  |  |  |  |  |  |  | Stack A/1
Stack 6, 1000x1000, [NAME] |  |  |  |  |  |  |  |  |  |  |  | Stack A/2
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm] |  |  |  |  | Stack A/3
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  |  |  | Stack A/4
3.1 | -73.6344249353946 | 16.3860696121724 | -141.179218588356 | 52.0399732553175 | 5540.64647084682 | -6.23525976165913 | -1.60875160875161e-17 | 1.6590250965251e-17 |  |  |  | Stack A/5
0.215367188425092 | -73.6344249353946 | 16.3860696121724 | 71.229059641733 | 4.77217919929443 | 5611.3679317509 | -6.23525976165913 | 0.000913484550970992 | 0.00309456598483992 |  |  |  | Stack A/6
0 | -73.6344249353946 | 16.3860696121724 | 87.0874987113674 | 1.24315745758304 | 5616.64800834682 | -6.23525976165913 | 0 | 0 |  |  |  | Stack B/1
Stack 5, 1000x1000, [NAME] |  |  |  |  |  |  |  |  |  |  |  | Stack B/2
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm] |  |  |  |  | Stack B/3
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  |  |  | Stack B/4
2.825 | -51.4174206103841 | -9.6093491184407 | -93.1848633277443 | 10.1632824677487 | 5953.9168139689 | -7.69333129576242 | -4.02187902187902e-17 | 8.04375804375804e-18 |  |  |  | Stack B/5
0.104434348031568 | -51.4174206103841 | -9.6093491184407 | 46.6996050976803 | 36.3061476171516 | 6020.61590184609 | -7.69333129576242 | 0.000136126548015734 | 0.00204233089308101 |  |  |  | Stack B/6
0 | -51.4174206103841 | -9.6093491184407 | 52.0693498965906 | 37.3096937273437 | 6023.1762795939 | -7.69333129576242 | 0 | 0 |  |  |  | Stack C/1
Stack 4, 1000x1000, [NAME] |  |  |  |  |  |  |  |  |  |  |  | Stack C/2
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm] |  |  |  |  | Stack C/5
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  |  |  | Stack C/6
2.825 | -85.1945229147696 | 22.1004207948593 | -121.831077547757 | 17.7586465036086 | 6372.25884776826 | -8.32706620533365 | 3.21750321750322e-17 | 0 |  |  |  | Stack D/1
0 | -85.1945229147696 | 22.1004207948593 | 118.843449686467 | -44.6750422418689 | 6441.51831339326 | -8.32706620533365 | 0 | 0 |  |  |  | Stack D/2
Stack 3, 1000x1000, [NAME] |  |  |  |  |  |  |  |  |  |  |  | Stack D/4
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm] |  |  |  |  | Stack D/5
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  |  |  | Stack D/6
3 | -70.2984390937721 | 8.19386589426467 | -123.310995922793 | 7.14662102071901 | 6800.10260784343 | -6.89762841345217 | 3.21750321750322e-17 | 8.04375804375804e-18 |  |  |  | Stack E/1
0 | -70.2984390937721 | 8.19386589426467 | 87.584321358523 | -17.434976662075 | 6873.65248284342 | -6.89762841345217 | 0 | 0 |  |  |  | Stack E/2
Stack 2, 1000x1000, [NAME] |  |  |  |  |  |  |  |  |  |  |  | Stack E/4
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm] |  |  |  |  | Stack E/5
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  |  |  | Stack E/6
5.15 | -70.7939819492816 | -8.83076250523849 | -124.6501205395 | -9.21557653154843 | 7237.31957746657 | -6.24702172558463 | -3.86100386100386e-16 | 3.21750321750322e-17
5.0843138806261 | -70.7939819492816 | -8.83076250523849 | -119.999938590225 | -8.63551801146676 | 7238.92997942296 | -6.24702172558463 | -0.000134996559284266 | 0.000527580685756668
1.69408787882566 | -70.7939819492816 | -8.83076250523849 | 120.00765978522 | 21.3027626495171 | 7322.04687897436 | -6.24702172558463 | 0.118195700207672 | 0.0242875190293182
0 | -70.7939819492816 | -8.83076250523849 | 239.938886499301 | 36.2628503704298 | 7363.58019621657 | -6.24702172558463 | 0 | 0
Stack 1, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor |  | Below are the original postion values that i overwrite with 'Stack A/1' for the IF statement to recognise
Stack A/1 | 97.7008692130349 | 42.8447028730551 | 125.676056965053 | -2.09603898897867 | 7686.56747097494 | -1.86832337150858 | 1.28700128700129e-16 | 6.43500643500644e-17 |  | 3.5
Stack A/1 | 97.7008692130349 | 42.8447028730551 | 108.62368438531 | -9.57400558584343 | 7690.84651810385 | -1.86832337150858 | 0.000897526936389881 | -0.00815332529740171 |  | 3.32546345066224
Stack A/1 | 97.7008692130349 | 42.8447028730551 | -71.1242563564411 | -88.3987609350656 | 7735.95167318777 | -1.86832337150858 | -0.0415259439574533 | -0.062278522448044 |  | 1.48568513354395
Stack A/1 | 97.7008692130349 | 42.8447028730551 | -216.276985280569 | -152.052499044671 | 7772.37565847494 | -1.86832337150858 | 0 | 0 |  | 0
A/3
Stack 6, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
4.1 | -63.7963567611249 | -11.6745239750487 | -208.88620693844 | -21.1515206624855 | 6537.05912116113 | -5.47486222974949 | 3.21750321750322e-17 | 3.21750321750322e-17
2.52863778143805 | -63.7963567611249 | -11.6745239750487 | -108.63902224211 | -2.80661476839834 | 6575.58361941278 | -5.47486222974949 | -0.0902910455440929 | 0.000939534815383336
0 | -63.7963567611249 | -11.6745239750487 | 52.6788557821716 | 26.7140276352141 | 6637.57728366112 | -5.47486222974949 | 0 | 0
Stack 5, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.725 | 24.2277281435311 | 3.52615971629905 | 52.6788557821711 | 26.714027635213 | 6938.44494359026 | -6.76393556875755 | 3.21750321750322e-17 | -4.02187902187902e-18
0 | 24.2277281435311 | 3.52615971629905 | -37.569431552482 | 13.5790826919991 | 7029.76937171526 | -6.76393556875755 | 0 | 0
Stack 4, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.725 | -3.39864886841957 | 0.542266272896099 | -37.5694315524817 | 13.5790826919995 | 7330.63634264757 | -7.32111189864905 | -3.21750321750322e-17 | -8.04375804375804e-18
0 | -3.39864886841957 | 0.542266272896099 | -24.9094645176188 | 11.5591408254615 | 7421.96077077257 | -7.32111189864905 | 0 | 0
Stack 3, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.9 | -4.74801346966304 | -12.3345387288576 | -64.6211254361342 | -43.4472672605248 | 7711.43692241064 | -6.10174821189999 | 3.21750321750322e-17 | -2.61422136422136e-17
2.0042095612796 | -4.74801346966304 | -12.3345387288576 | -55.6198868974313 | -20.0635666723302 | 7757.91530567533 | -6.10174821189999 | -0.0542288796487968 | -0.0191863666209845
0 | -4.74801346966304 | -12.3345387288576 | -46.1038729044483 | 4.65743378201971 | 7807.05175991064 | -6.10174821189999 | 0 | 0
Stack 2, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
6.05 | -25.4744580527706 | 0.264116175026198 | -46.1038729044478 | 4.65743378201927 | 8112.21579599254 | -5.78236721707006 | -6.43500643500644e-17 | -4.02187902187902e-18
2.11240872924786 | -25.4744580527706 | 0.264116175026198 | 54.2041307512831 | 3.61745223677167 | 8208.75224458085 | -5.78236721707006 | 0.0828689007679706 | 0.00808901225773519
0 | -25.4744580527706 | 0.264116175026198 | 108.016598314814 | 3.05953092311077 | 8260.54137724254 | -5.78236721707006 | 0 | 0
Stack 1, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
Stack A/3 | 101.164554251726 | 7.58602362665216 | 108.016598314814 | 3.05953092311105 | 8708.75237848716 | -1.67724484487702 | 6.43500643500644e-17 | 1.40765765765766e-17
Stack A/3 | 101.164554251726 | 7.58602362665216 | -172.147732890569 | -17.9491440183196 | 8776.64852943986 | -1.67724484487702 | -0.155462045448487 | -0.0175163100209312
Stack A/3 | 101.164554251726 | 7.58602362665216 | -337.10744039278 | -30.3189730341585 | 8816.62552848715 | -1.67724484487702 | 0 | 0
A/2
Stack 6, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
4.1 | -124.840828941862 | -23.2860209792609 | -422.313179600919 | -57.927723668103 | 5870.53836106989 | -5.47486222974949 | -2.57400257400257e-16 | 6.43500643500644e-17
2.4997199757646 | -124.840828941862 | -23.2860209792609 | -222.532894836269 | -20.6635694510653 | 5909.77182631906 | -5.47486222974949 | -0.19059522339441 | -0.0140880020970629
0.350460012724183 | -124.840828941862 | -23.2860209792609 | 45.7825005612515 | 29.3841431381794 | 5962.46442686044 | -5.47486222974949 | -0.0323579294611821 | 0.00101487690094566
0 | -124.840828941862 | -23.2860209792609 | 89.5342190607139 | 37.5449623468668 | 5971.05652356989 | -5.47486222974949 | 0 | 0
Stack 5, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.725 | 42.1906653210634 | 8.27927266085344 | 89.5342190607122 | 37.5449623468665 | 6188.55125680354 | -6.76393556875755 | 3.21750321750322e-17 | 1.40765765765766e-17
0 | 42.1906653210634 | 8.27927266085344 | -67.6260092602491 | 6.70467168518741 | 6279.87568492854 | -6.76393556875755 | 0 | 0
Stack 4, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.725 | -26.5369660105653 | -6.96771016707828 | -67.6260092602481 | 6.70467168518773 | 6497.37050890081 | -7.32111189864905 | -3.21750321750322e-17 | 0
0 | -26.5369660105653 | -6.96771016707828 | 31.2241891291077 | 32.6593920575543 | 6588.69493702581 | -7.32111189864905 | 0 | 0
Stack 3, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
3.9 | -2.45407673333703 | -20.0721716532626 | -63.2768216466052 | -65.5105122184156 | 6815.2504187227 | -6.10174821189999 | 8.04375804375805e-17 | -2.41312741312741e-17
1.97644731397695 | -2.45407673333703 | -20.0721716532626 | -58.5562757544881 | -26.9006325204665 | 6862.40943859367 | -6.10174821189999 | -0.0572599176445096 | -0.0259782160314388
0 | -2.45407673333703 | -20.0721716532626 | -53.7059223865908 | 12.7709572293087 | 6910.8652562227 | -6.10174821189999 | 0 | 0
Stack 2, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
6.05 | -33.2354487226433 | 4.04784111639732 | -53.7059223865909 | 12.7709572293084 | 7131.75983154658 | -5.78236721707006 | 2.57400257400257e-16 | -3.21750321750322e-17
2.18991487341611 | -33.2354487226433 | 4.04784111639732 | 74.5857389030259 | -2.85405405887161 | 7226.39609106311 | -5.78236721707006 | 0.122028893822406 | -0.00130666721009291
0 | -33.2354487226433 | 4.04784111639732 | 147.368542385401 | -11.7184815248954 | 7280.08541279658 | -5.78236721707006 | 0 | 0
Stack 1, 1000x1000, [NAME]
Position | Shear [kN] |  | Moment [kNm] |  | Axial Force | Torsion | Deflection [mm]
[m] | Major | Minor | Major | Minor | [kN] | [kNm] | Major | Minor
Stack A/2 | 95.9699172432504 | -8.65238120849707 | 147.368542385401 | -11.7184815248952 | 7604.96916296365 | -1.67724484487702 | 0 | 3.21750321750322e-17
Stack A/2 | 95.9699172432504 | -8.65238120849707 | 137.569564580973 | -10.8350329000244 | 7607.47242514325 | -1.67724484487702 | 0.000377989944532111 | 0.000143020802201991
Stack A/2 | 95.9699172432504 | -8.65238120849707 | -137.577646306426 | 13.9714754875812 | 7677.76196151978 | -1.67724484487702 | -0.0966366491201374 | 0.010427027097256
Stack A/2 | 95.9699172432504 | -8.65238120849707 | -274.899093484901 | 26.3519957924919 | 7712.84231296365 | -1.67724484487702 | 0 | 0