Spreadsheet: 70483d1271210209-goal-and-seek-analysis-724889-binary-search
Sheet: Bending and Shear

Designation |  | Span |  | [NAME] | S/W | (Fd)      Design Load |  | (My,d) Bending | (fm,y,d)      Design Bending Strength | (σm,y,d)          Design bending Stress | Passes? |  | (Vd)              Design Vertical Shear Force | (fv,d)      Design Shear   Strength | (τd)      Design Shear Stress | Passes? |  | (Fc,90,d)   Design Bearing Force | (fc,90,d)       Design  Bearing Strength | (σc,90,d)    Design Bearing Stress | (fc,90,d) * (Kc,90) | Passes? |  | (σm,y,d) | Kcrit * fm,y,d | Passes? |  | winst,m,G | winst,v,G | winst,G | wfin,G |  | winst,[NAME] | winst,[NAME] | winst,Q1 | wfin,Q1 |  | wfin | wfin Limit | Passes? |  | Bending | Shear | Bearing | Lateral Stability | Deflection | Section Score |  | Sections Suitable
C16 97 X 47 |  | 4000 |  | 0.45325 | 0.0165478023 | 1.153690813242 |  | 2.307381626484 | 11.81743459854021 | 31.30612781086466 | 0 |  | 2.307381626484 | 2.166153846153847 | 0.7591735994134678 | 1 |  | 2.307381626484 | 1.48923076923077 | 1.227330652385106 | 3.974198461538462 | 1 |  | 31.30612781086466 | 11.81743459854021 | 0 |  | 21.90422620429573 | 0.1978529897819697 | 22.1020791940777 | 39.78374254933986 |  | 69.93719243808304 | 0.6317174819039264 | 70.56890991998696 | 87.50544830078384 |  | 127.2891908501237 | 16 | 0 |  | 0 | 1 | 1 | 0 | 0 | 0
C16 120 X 47 |  | 4000 |  | 0.45325 | 0.020471508 | 1.15580961432 |  | 2.31161922864 | 11.32508069268087 | 20.49307826808511 | 0 |  | 2.31161922864 | 2.166153846153847 | 0.6147923480425533 | 1 |  | 2.31161922864 | 1.48923076923077 | 1.229584696085106 | 4.132615384615384 | 1 |  | 20.49307826808511 | 11.32508069268087 | 0 |  | 11.66571877462569 | 0.1612668963404255 | 11.82698567096612 | 21.28857420773901 |  | 36.93853427895981 | 0.5106382978723405 | 37.44917257683215 | 46.43697399527187 |  | 67.72554820301087 | 16 | 0 |  | 0 | 1 | 1 | 0 | 0 | 0
C16 145X47 |  | 4000 |  | 0.45325 | 0.0247364055 | 1.15811265897 |  | 2.31622531794 | 10.90445473030645 | 14.06365462356364 | 0 |  | 2.31622531794 | 2.166153846153847 | 0.509807480104182 | 1 |  | 2.31622531794 | 1.48923076923077 | 1.232034743585107 | 4.304807692307692 | 1 |  | 14.06365462356364 | 10.90445473030645 | 0 |  | 6.671810092272152 | 0.1346638149024211 | 6.806473907174573 | 12.25165303291423 |  | 20.93723801190457 | 0.4225972120322818 | 21.35983522393685 | 26.4861956776817 |  | 38.73784871059593 | 16 | 0 |  | 0 | 1 | 1 | 0 | 0 | 0
C16 170 X 47 |  | 4000 |  | 0.45325 | 0.029001303 | 1.16041570362 |  | 2.32083140724 | 10.83076923076923 | 10.25177681177943 | 1 |  | 2.32083140724 | 2.166153846153847 | 0.4357005145006258 | 1 |  | 2.32083140724 | 1.48923076923077 | 1.234484791085106 | 4.477 | 1 |  | 10.25177681177943 | 10.83076923076923 | 1 |  | 4.176945255964419 | 0.1158851691814768 | 4.292830425145896 | 7.727094765262613 |  | 12.99201856992521 | 0.360450563204005 | 13.35246913312922 | 16.55706172508023 |  | 24.28415649034284 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C16 195 X 47 |  | 4000 |  | 0.45325 | 0.0332662005 | 1.16271874827 |  | 2.32543749654 | 10.83076923076923 | 7.807083793831047 | 1 |  | 2.32543749654 | 2.166153846153847 | 0.3805953349492636 | 1 |  | 2.32543749654 | 1.48923076923077 | 1.236934838585106 | 4.649192307692308 | 1 |  | 7.807083793831047 | 10.83076923076923 | 1 |  | 2.792065549662428 | 0.1019215608248772 | 2.893987110487305 | 5.209176798877149 |  | 8.608342990818128 | 0.3142389525368249 | 8.922581943354952 | 11.06400160976014 |  | 16.27317840863729 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C16 220 X 47 |  | 4000 |  | 0.45325 | 0.037531098 | 1.16502179292 |  | 2.33004358584 | 10.83076923076923 | 6.145710178934412 | 1 |  | 2.33004358584 | 2.166153846153847 | 0.3380140598413926 | 1 |  | 2.33004358584 | 1.48923076923077 | 1.239384886085106 | 4.821384615384615 | 1 |  | 6.145710178934412 | 10.83076923076923 | 1 |  | 1.961335653883658 | 0.09113149982205031 | 2.052467153705709 | 3.694440876670276 |  | 5.994532985916845 | 0.2785299806576403 | 6.273062966574485 | 7.778598078552361 |  | 11.47303895522264 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C16 220 X 47
C16 145 X 75 |  | 4000 |  | 0.45325 | 0.0394729875 | 1.16607041325 |  | 2.3321408265 | 10.90445473030645 | 8.87378197954816 | 1 |  | 2.3321408265 | 2.166153846153847 | 0.3216745967586208 | 1 |  | 2.3321408265 | 1.48923076923077 | 0.7773802755000001 | 4.304807692307692 | 1 |  | 8.87378197954816 | 10.90445473030645 | 1 |  | 4.30990353574699 | 0.08699109296551724 | 4.396894628712507 | 7.914410331682514 |  | 13.12066915412686 | 0.2648275862068966 | 13.38549674033376 | 16.59801595801386 |  | 24.51242628969637 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C16 170 X 75 |  | 4000 |  | 0.45325 | 0.04627867499999999 | 1.1697454845 |  | 2.339490969 | 10.83076923076923 | 6.47609956816609 | 1 |  | 2.339490969 | 2.166153846153847 | 0.2752342316470588 | 1 |  | 2.339490969 | 1.48923076923077 | 0.779830323 | 4.477 | 1 |  | 6.47609956816609 | 10.83076923076923 | 1 |  | 2.711330076667345 | 0.07522314164705882 | 2.786553218314404 | 5.015795792965927 |  | 8.141664970486465 | 0.2258823529411765 | 8.367547323427642 | 10.37575868105028 |  | 15.3915544740162 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C16 170 X 75
C16 195 X 75 |  | 4000 |  | 0.45325 | 0.0530843625 | 1.17342055575 |  | 2.3468411115 | 10.83076923076923 | 4.93746979408284 | 1 |  | 2.3468411115 | 2.166153846153847 | 0.2407016524615385 | 1 |  | 2.3468411115 | 1.48923076923077 | 0.7822803705000001 | 4.649192307692308 | 1 |  | 4.93746979408284 | 10.83076923076923 | 1 |  | 1.82096794169378 | 0.06647261374358975 | 1.88744055543737 | 3.397392999787266 |  | 5.39456160757936 | 0.196923076923077 | 5.591484684502436 | 6.933441008783021 |  | 10.33083400857029 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C16 195 X 75
C16 220 X 75 |  | 4000 |  | 0.45325 | 0.05989005000000001 | 1.177095627 |  | 2.354191254 | 10.83076923076923 | 3.89122521322314 | 1 |  | 2.354191254 | 2.166153846153847 | 0.2140173867272727 | 1 |  | 2.354191254 | 1.48923076923077 | 0.784730418 | 4.821384615384615 | 1 |  | 3.89122521322314 | 10.83076923076923 | 1 |  | 1.285099048334585 | 0.05971084218181818 | 1.344809890516404 | 2.420657802929527 |  | 3.756574004507889 | 0.1745454545454546 | 3.931119459053344 | 4.874588129226146 |  | 7.295245932155673 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C16 220 X 75
C24 97 X 47 |  | 4000 |  | 0.45325 | 0.0187839918 | 1.154898355572 |  | 2.309796711144 | 17.72615189781032 | 31.33889523354507 | 0 |  | 2.309796711144 | 2.707692307692308 | 0.7599682094134679 | 1 |  | 2.309796711144 | 1.692307692307692 | 1.228615271885106 | 4.516134615384615 | 1 |  | 31.33889523354507 | 17.72615189781032 | 0 |  | 16.00617314997969 | 0.1440541665086738 | 16.15022731648836 | 29.07040916967905 |  | 50.86341268224221 | 0.4577662912347293 | 51.32117897347694 | 63.63826192711141 |  | 92.70867109679045 | 16 | 0 |  | 0 | 1 | 1 | 0 | 0 | 0
C24 120 X 47 |  | 4000 |  | 0.45325 | 0.023237928 | 1.15730348112 |  | 2.31460696224 | 16.9876210390213 | 20.51956526808511 | 0 |  | 2.31460696224 | 2.707692307692308 | 0.6155869580425531 | 1 |  | 2.31460696224 | 1.692307692307692 | 1.231173916085106 | 4.696153846153845 | 1 |  | 20.51956526808511 | 16.9876210390213 | 0 |  | 8.53370456336414 | 0.1175425045945113 | 8.65124706795865 | 15.57224472232557 |  | 26.86438856651623 | 0.3700277520814061 | 27.23441631859763 | 33.77067623506107 |  | 49.34292095738664 | 16 | 0 |  | 0 | 1 | 1 | 0 | 0 | 0
C24 145X47 |  | 4000 |  | 0.45325 | 0.028079163 | 1.15991774802 |  | 2.31983549604 | 16.35668209545969 | 14.08557489942571 | 1 |  | 2.31983549604 | 2.707692307692308 | 0.510602090104182 | 1 |  | 2.31983549604 | 1.692307692307692 | 1.233955051085107 | 4.891826923076922 | 1 |  | 14.08557489942571 | 16.35668209545969 | 1 |  | 4.886159150449362 | 0.09826490934958053 | 4.984424059798942 | 8.971963307638097 |  | 15.22708219047605 | 0.3062298637915085 | 15.53331205426756 | 19.26130694729177 |  | 28.23327025492987 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C24 170 X 47 |  | 4000 |  | 0.45325 | 0.032920398 | 1.16253201492 |  | 2.32506402984 | 16.24615384615385 | 10.27047351766178 | 1 |  | 2.32506402984 | 2.707692307692308 | 0.4364951245006258 | 1 |  | 2.32506402984 | 1.692307692307692 | 1.236736186085106 | 5.087499999999999 | 1 |  | 10.27047351766178 | 16.24615384615385 | 1 |  | 3.06246537646736 | 0.08465719505904121 | 3.147122571526402 | 5.664820628747523 |  | 9.448740778127426 | 0.2611960602927573 | 9.709936838420184 | 12.04032167964103 |  | 17.70514230838855 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C24 195 X 47 |  | 4000 |  | 0.45325 | 0.037761633 | 1.16514628182 |  | 2.33029256364 | 16.24615384615385 | 7.823383486138738 | 1 |  | 2.33029256364 | 2.707692307692308 | 0.3813899449492635 | 1 |  | 2.33029256364 | 1.692307692307692 | 1.239517321085106 | 5.283173076923076 | 1 |  | 7.823383486138738 | 16.24615384615385 | 1 |  | 2.049355902713073 | 0.07453863827889658 | 2.123894540991969 | 3.823010173785544 |  | 6.260613084231365 | 0.22770938589625 | 6.488322470127615 | 8.045519862958242 |  | 11.86853003674379 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C24 195 X 47
C24 220 X 47 |  | 4000 |  | 0.45325 | 0.04260286800000001 | 1.16776054872 |  | 2.33552109744 | 16.24615384615385 | 6.160157633479868 | 1 |  | 2.33552109744 | 2.707692307692308 | 0.3388086698413927 | 1 |  | 2.33552109744 | 1.692307692307692 | 1.242298456085107 | 5.478846153846153 | 1 |  | 6.160157633479868 | 16.24615384615385 | 1 |  | 1.441166726490895 | 0.06671975349423934 | 1.507886479985134 | 2.714195663973242 |  | 4.359660353394069 | 0.2018333193171306 | 4.561493672711199 | 5.656252154161887 |  | 8.37044781813513 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C24 220 X 47
C24 145 X 75 |  | 4000 |  | 0.45325 | 0.044807175 | 1.1689508745 |  | 2.337901749 | 16.35668209545969 | 8.895702255410225 | 1 |  | 2.337901749 | 2.707692307692308 | 0.3224692067586206 | 1 |  | 2.337901749 | 1.692307692307692 | 0.7793005829999999 | 4.891826923076922 | 1 |  | 8.895702255410225 | 16.35668209545969 | 1 |  | 3.16840892752197 | 0.06371945867066467 | 3.232128386192635 | 5.817831095146743 |  | 9.542304839364991 | 0.191904047976012 | 9.734208887341003 | 12.07041902030284 |  | 17.88825011544959 | 16 | 0 |  | 1 | 1 | 1 | 1 | 0 | 0
C24 170 X 75 |  | 4000 |  | 0.45325 | 0.05253255 | 1.173122577 |  | 2.346245154 | 16.24615384615385 | 6.494796274048444 | 1 |  | 2.346245154 | 2.707692307692308 | 0.2760288416470588 | 1 |  | 2.346245154 | 1.692307692307692 | 0.782081718 | 5.087499999999999 | 1 |  | 6.494796274048444 | 16.24615384615385 | 1 |  | 1.996563427887669 | 0.05519195771526001 | 2.05175538560293 | 3.693159694085273 |  | 5.92121088762652 | 0.1636828644501279 | 6.084893752076648 | 7.545268252575044 |  | 11.23842794666032 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C24 170 X 75
C24 195 X 75 |  | 4000 |  | 0.45325 | 0.060257925 | 1.1772942795 |  | 2.354588559 | 16.24615384615385 | 4.953769486390533 | 1 |  | 2.354588559 | 2.707692307692308 | 0.2414962624615385 | 1 |  | 2.354588559 | 1.692307692307692 | 0.7848628530000001 | 5.283173076923076 | 1 |  | 4.953769486390533 | 16.24615384615385 | 1 |  | 1.343103096917692 | 0.04885099546636939 | 1.391954092384062 | 2.505517366291311 |  | 3.923317532784989 | 0.1426978818283167 | 4.066015414613306 | 5.041859114120499 |  | 7.547376480411811 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C24 195 X 75
C24 220 X 75 |  | 4000 |  | 0.45325 | 0.06798330000000001 | 1.181465982 |  | 2.362931964 | 16.24615384615385 | 3.905672667768595 | 1 |  | 2.362931964 | 2.707692307692308 | 0.2148119967272727 | 1 |  | 2.362931964 | 1.692307692307692 | 0.7876439879999999 | 5.478846153846153 | 1 |  | 3.905672667768595 | 16.24615384615385 | 1 |  | 0.9493582860915694 | 0.04395116100131753 | 0.9933094470928869 | 1.787957004767196 |  | 2.732053821460283 | 0.1264822134387352 | 2.858536034899019 | 3.544584683274783 |  | 5.33254168804198 | 16 | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | C24 220 X 75