New Comments

Hello Ishwar,
We have given your swing arm calculation a clearer title, a full description and larger preview pictures taken from your workbook, so that visitors can see what it does before downloading. The way it sets out the three load cases and then shows how the cornering safety factor improves from 1.03 to about 2 makes it a good teaching example.
While writing the description we noticed a few points, which we have mentioned on the page:
- The "Number of riders" input on the Inputs sheet is not used; each sheet assumes two riders of 75 kg.
- In the cornering case the vertical component uses SIN of the lean angle and the horizontal component COS. That is right if 40 degrees is measured from the ground, but if it is the lean from vertical the two are swapped.
- The braking and cornering cases use the whole bike's mass rather than the rear-axle share, which is on the safe side.
If you upload an updated version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Alex,
Thank you for your end plate moment connection workbook. We checked the single 4-tension-bolt example independently and got the same flange force (97.93 kips) and required end plate thickness (0.720 in.), and printing each formula beside its value makes the sheets easy to check.
While rewriting the description we found one point in the end plate shear check. The allowable shear in B105 is calculated as Fv = 0.40 × Fyc, the column yield stress, where we would expect the end plate yield stress Fyp. It makes no difference in the stored example, where the two are the same, but it gives the wrong allowable when the end plate and column grades differ. You may want to consider using Fyp there.
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Alex,
Thank you for your WEIGHTS workbook. We checked the vertical tank example independently and got the same volume (753.4 ft³, 5,636 gal), including the elliptical top and conical bottom.
While rewriting the description we found one small error. On the Horiz. Tank Vol. & Wt. sheet, N14 (area of an elliptical right end) uses $C$13, the left end length Ll, in the first eccentricity term, where the right end length Lr in $C$16 is used everywhere else in the formula. This only affects an elliptical right end whose length differs from the left end.
You may also want to consider the "pipe + contents + ice" columns on the pipe sheets: they put the ice on the insulated diameter even though no insulation is counted, which slightly overstates the ice weight.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Stuart,
Thank you for your cantilever retaining wall calculation. We recalculated the stored example independently and got the same total vertical load (212.2 kN/m), with factors of safety of 2.58 against overturning and 1.38 against sliding.
While rewriting the description we found one error in the final verdict. E112 is =IF(AND(E109>1,E1002),...), and E1002 is an empty cell, which AND ignores. So the verdict only checks that the sliding factor of safety exceeds 1.0: overturning is never checked, and a wall could be reported as satisfactory with a factor of safety just above 1.0 against sliding. You may want to consider testing both factors of safety against the margins you design to (1.5 against sliding is common).
A smaller point: the effective cohesion c′ in E42 is not used in the calculation.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Michael,
Thank you for your Steel Plates calculation. We checked the stored example (encastré plate, point load) independently and got the same capacity, 1.821 kN, and the same deflection-limited allowable load, 1.123 kN.
While rewriting the description we found two errors. In F597 and H597 the denominator is 1333.33 × ln(...) + β: the ln term is scaled by 1000 to give kN, but β is not, so β has almost no effect. For the encastré case this changes the result by under 1%, but for a simply supported plate under a point load the capacity is overestimated by about 15% for the example proportions (1.82 kN against about 1.57 kN). The term should be 1000 × β.
Also, the interpolated α values in D609, D611, D613, D615 and D617 are calculated as =D608+D610/2 instead of =(D608+D610)/2, so they are too large (0.229 instead of 0.155 at L/B = 1.3). This overstates the point-load deflection of simply supported plates, which is conservative.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello David,
Thank you for your Steel Angle Member calculation. We checked the L8x8x1/2 example independently and got the same allowable bending moments (270.3 and 263.2 kip-in, including the leg local buckling check) and shear (51.74 kips).
While rewriting the description we found two errors. The compression capacity (N42:N45, used in N57) uses only the geometric-axis radius of gyration (2.49 in.) with no slender-leg reduction. AISC 360-05 also requires buckling about the principal z-axis (or the Section E5 single-angle slenderness) and the Section E7 reduction, as b/t = 16 exceeds 0.45√(E/Fy) = 12.8. With rz = 1.59 in. we get about 124 kips, or about 100 kips by Section E5, against 153 kips on the sheet. The E5 block in T39:T40 also divides the length in feet by r in inches, but it is not used.
Also, the text "
Hello Alex,
Thank you for your BOLTGRP workbook. We checked the Bolt Stress example independently and got the same tensile stress (33.26 ksi) and reduced allowable tension (33.46 ksi), and the comment boxes explaining each equation make the sheets easy to follow.
While rewriting the description we found one point in the bolt shear check. On the Table XI sheet the allowable bolt shear in B41 is rounded to 0.1 kip before it is compared with the bolt load in D43. In the stored example the exact allowable is 21 × π × 0.75²/4 = 9.278 kips against a bolt load of 25/2.691 = 9.289 kips, so the bolt is about 0.1% overstressed, yet the sheet shows 9.3 kips and reports "Bolt group is adequate!". The other Table sheets appear to round in the same way. Comparing the unrounded values, and rounding only for display, would fix this.
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Viktor,
Thank you for your ASCE 7-05 wind pressure calculation. We checked the stored example independently and got the same Kz (1.130) and qz (35.42 psf) at 160 ft in exposure B.
While rewriting the description we found two errors. Below the minimum height, C25 holds z at 4.6 in both unit systems. That is the code's 4.6 m limit, but in US units it should be 15 ft, so for z under 15 ft Kz and qz are underestimated: at 10 ft in exposure B the sheet gives Kz = 0.512 instead of 0.575, about 11% low.
Also, the topographic factor K2 in C35 uses B41, the hill-shape selector (1 to 3), in place of the distance x from the crest, and there is no input for x. This only matters when Kzt is switched on, which it is not in the stored example.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello,
Thank you for your Simple Bolt Calc. We checked the M16 example independently and got the same preload from the torque (78,750 N) and the same joint slip load (17,325 N).
While rewriting the description we found one error. The look-up cells E5:E11 on the BoltCalc sheet use LOOKUP on the size headings in the Bolt Lookup Table sheet (M6, M8, M10 ... M30). LOOKUP needs those headings in sorted order, and as text they are not, so its search goes wrong for the small sizes: M6 and M8 return the M30 data, and M10 and M12 return #N/A. M14 to M30, including the stored M16 example, are read correctly. HLOOKUP with FALSE as its last argument, or INDEX with an exact MATCH, would fix this.
A smaller point: the grade in E2 is not used, as the tensile strength is typed in E13. You may want to consider linking the two.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Alex,
Thank you for your triangle solver. We checked it with a 3-4-5 triangle and a 10/20/22 triangle, and the angles and areas (6 and 99.92) agree with our own calculations. It also correctly returns #NUM! when the data cannot form a triangle.
While rewriting the description we found one gap. In the ambiguous side-side-angle case only one of the two valid triangles is returned, with no warning. For example, with a = 3, b = 4 and angle A = 30°, the sheet gives B = 41.81° and c = 5.70, but B = 138.19° with c = 1.23 is equally valid and is not shown. A user who needs the obtuse solution would not know it exists.
You may want to consider showing both solutions, or at least a note when the second one exists.
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Shaiq,
Thank you for your continuous beam analysis. We analysed the stored example independently by the flexibility method and the four reactions (93.34, 580.95, 326.43 and 32.59 kN) agree exactly with the sheet.
While rewriting the description we found one point that affects the results. The maximum and minimum moments are taken only at the 31 equally spaced analysis points, so a peak between them is missed. In the stored example the greatest sagging moment occurs under the point loads at 7.2 m and is about 181.96 kNm, whereas the sheet reports 171.87 kNm at 7.605 m, about 6% low. Adding analysis points automatically at each point-load position (and at supports) would capture the true peaks.
We have mentioned this in the file's description so users are aware, with the advice to add analysis points at point-load positions. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello,
Thank you for your allowable bearing capacity calculation. An independent check of your example gave the same square-footing shear value (287.15) and settlement value (121.05) as Page2.
While rewriting the description we found these points on Page2:
- J70 takes the least of the square-footing shear, strip-footing shear and settlement values. The square and strip results are alternative footing shapes, so only the one matching the actual footing should be compared. Because the nested IFs use a strict "
Hello Mike,
Thank you for your anchor rod and rebar anchorage calculation. An independent check of your example gave the same steel strengths (22.72 kips tension, 9.45 kips shear), interaction ratio (0.825) and development length (12.86 in.).
While rewriting the description we found some inputs that do not reach the calculation:
- The material drop-down in D23 (F1554 Grade 55, Fu = 75 ksi in the table) is not used; futa in D32 is typed as 50 ksi.
- The pedestal height (D15), sizes b1 and b2 (D17, D18), edge distances c1 and c2 (D20, D21) and the Y-shear Vuy (D12) are not referenced by any formula. Side-face blowout uses its own typed edge distance of 6.8 in. (D61), although c1 is 4.85 in.
- The interaction check in D49 uses the steel strengths only, not the governing concrete modes, and the pullout result in D57 is not compared with Nu.
You may also want to complete the tie design after D96 with the number of ties.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your steel apex connection calculation. We worked through the bolt forces in your example independently and got the same results, including the top bolt tension of 161.1 kN against a capacity of 159.5 kN.
While rewriting the description we found two points on the APEXRPR sheet:
- D249, D257 and D267 use D73, the haunch strength (265 N/mm² in the example), for the end-plate bending and prying checks instead of D59, the end-plate strength (355 N/mm²). This errs on the safe side.
- D292 takes the bolt shear capacity as At·Po, the proof load (177.9 kN for M22). The BS 5950-1 shear capacity of a grade 8.8 M22 bolt is ps·At, about 375 × 303 = 114 kN. This is unconservative, although the shear in the example is small (1.2 kN per bolt).
A small label slip: C134 reads "Vy = Ta. sin a", but the formula uses the cosine.
We have mentioned the first two points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your machine foundation calculation. An independent check of the sliding mode in your example gave the same natural frequency (11.99 Hz), damping ratio (0.583) and amplitude (0.0545 mm).
While rewriting the description we found two errors on the draw sheet:
- B112 is =4*G*Rv/(1-v)*(1+z/2*Rv), which evaluates 1 + z·Rv/2 (1.489 in the example). The INTRO sheet states the embedment factor as 1 + 0.4(d/ro) (1.102 here), so the vertical stiffness is overstated by about 35%.
- F123 and L123 have the same formula in both branches of the IF, fn/√(1 − 2D²), the rotating-mass peak, so reciprocating machines get the wrong rocking resonant frequency. D122, B122 and P123 use fn·√(1 − 2D²) for that case.
You may also want to consider the ABS(1 − 2D²) in the resonant frequency cells: when D exceeds 0.707 (the vertical mode in the example, D = 0.728) there is no resonant peak, but a frequency is still shown.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your bored pile wall and ground anchor calculation. Our check of the Rankine coefficients and the anchor 1 bond length (5.950 m) agrees with the sheet.
While rewriting the description we found two errors on the MENU sheet:
- EL18:EM26 take SIN(BK17) with the inclination entered in degrees (15), so Excel treats it as 15 radians: sin = 0.650 instead of 0.259. The vertical anchor component in the embedment (D) check is overstated about 2.5 times (on the safe side there). SIN(RADIANS(BK17)) would fix it.
- BZ19 calculates the strand area as a solid circle of the nominal diameter, (BY19·25.4)²·π/4 = 182.4 mm² for a 0.6 in strand, whereas a 0.6 in seven-wire strand has an area of about 140 mm². The strand capacity in CB19 is overstated by about 30%, so the number of strands in CD23 may be too few.
You may also want to reconsider the example's pile modulus of 200 GPa, a steel value, for concrete piles.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello David,
Thank you for your continuous concrete beams calculation. We spot-checked the moment and shear coefficients for the two- and three-span cases and they agree with the standard tables.
While rewriting the description we found three errors:
- Main!H117 (four spans, alternate spans loaded, central point load) gives MC = +0.054, while the neighbouring support moments G117 and I117 are negative. It should be −0.054.
- Tables!AA44 refers to Tables!O444, an empty cell, instead of O44, so the third top layer drops out of the lever-arm sum for the negative-moment capacity.
- Tables!J38 is =H38*I37; it should be =H38*I38, as layer 5 is currently given layer 4's depth.
Two points you may want to consider on the Rectangular Slabs and Beams sheet: γ in E12 (0.85 − 0.007(f′c − 28)) is not capped at 0.85, giving 0.871 at 25 MPa, and the capacity ratio M*/Muo includes no capacity reduction factor φ (0.8 for bending in AS 3600).
We have mentioned the sign error, the missing layer, γ and φ in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello David,
Thank you for your floor vibration calculation. We reproduced the stiffnesses Kx and Ky and the stored frequency of 16.52 Hz from the sheet's formulas.
While rewriting the description we found two errors on the Vibration sheet:
- C23 is entered as OVD(C18)/UND(C20)^2 (and ^4), which Excel evaluates as L/B² and L/B⁴, not (L/B)² and (L/B)⁴. With this correction alone the example gives 17.64 Hz.
- R6:R8 sum I + Ad² with d measured from the top of the flooring and no −Aȳ² term, so IT = 3.35e6 mm⁴ instead of about 1.36e6 mm⁴ about the composite neutral axis (ȳ ≈ 49.0 mm).
With both corrected the example gives 15.99 Hz. The errors partly offset here but can differ more for other proportions.
Also, M13 calculates the flooring stiffness per millimetre width while Kx is per metre, so a factor of 1,000 appears to be missing. You may also want to consider adding a pass/fail message against the required minimum frequency.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello David,
Thank you for your CSA A23.3 anchorage calculation. We checked its formulas against the standard (steel tension, concrete breakout, pullout, side-face blowout, shear breakout and pryout) and they are set out correctly.
While rewriting the description we found the same gap as in your ACI version. The interaction check in AI207/AI208 takes the governing tension resistance from steel, breakout and side-face blowout, but leaves out the pullout resistance in E104. Where pullout governs, the interaction ratio will be unconservative. Including E104 in the minimum would fix this.
There is also a units slip in the labels: L13 and L14 say "(kips)", but the loads are used in kN.
You may also want to consider storing a worked example in the sheet, so users can check their own results against it.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello David,
Thank you for your ACI 318 Appendix D anchorage calculation. An independent check of your example agreed on every mode we tried, including concrete breakout (158.3 kips), shear breakout (199.7 kips) and the interaction ratio of 0.956.
While rewriting the description we found one gap. The interaction check in AI207/AI208 takes the governing tension strength as the minimum of steel, breakout and side-face blowout (E47, E88, E117/E125), but leaves out the pullout strength in E104. Where pullout governs, for example a single anchor with a small head, the interaction ratio will be unconservative. Including E104 in the minimum would fix this.
You may also want to consider E104 itself, which compares the pullout strength of one anchor with the total group load. That is conservative for a group, but comparing like with like would be clearer.
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Blake,
Thank you for your AASHTO LRFD slab calculation. We checked the stored example by hand and got the same flexural resistance, ΦMn = 37.33 k-ft, against Mu = 20.51 k-ft.
While rewriting the description we found two errors:
- C31 (and P12) calculate β1 as MAX(0.85 − 0.05f′c, 0.65) for f′c above 4 ksi. It should be 0.85 − 0.05(f′c − 4). At f′c = 4.5 ksi the sheet gives 0.65 instead of 0.825. β1 only feeds the maximum steel ratio in C36, so this errs on the safe side.
- J48 calculates the steel ratio for crack control as D23·D17/12/(D17·D25). D23 is already the steel area in the width b, so this is correct only when b = 12 in.
You may also want to consider adding the upper limit on Vc of 0.126√f′c·b·de (S5.14.5.3) to H57.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Andy,
Thank you for your press-fit calculator. An independent check of your example gave the same contact pressure (about 55,150 psi), torque capacity (2,185 in·lb) and axial force (3,365 lb).
While rewriting the description we found that the strength warnings in D10:D15 compare the contact pressure in C26 with the yield and tensile strengths. The highest stresses are the hoop stresses at the bores, which are larger than the contact pressure. For the outer tube the peak is p(ro² + r²)/(ro² − r²) = 1.46p, about 80,600 psi in the stored example, above its 60,000 psi yield strength, yet no warning is shown. The bore of a hollow inner tube sees an even higher compressive hoop stress, about 242,000 psi here. Checking these hoop stresses against the material strengths would make the warnings reliable.
A small label slip: B15 reads "TS2 =" for the outer tube yield strength; it should be "YS2".
We have mentioned this in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your axially and laterally loaded pile calculation. We checked the axial capacity in your example (Qb = 751.7 kN, Qs = 367.6 kN, allowable 373.1 kN) and the concrete shear capacity, and both agree with the sheet.
While rewriting the description we found one error. Cell EB10 calculates the frictional lateral capacity as 0.5·γ·D·Kp·T³. Broms' short-pile expression is 0.5γDL³Kp/(e + L); without the division by (e + L) the result has the units of a moment (kN·m) rather than a force, so Hu (180.9 kN in the example) and the moment capacity in EB18 built from it are overstated.
You may also want to consider the stirrup design in HN17, which sizes the stirrups for the average of Vc and Vu; that is unusual, and the example reports "Inadequate Reinforcement".
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your layered-soil bored pile calculation. The finite element model, with soil springs set layer by layer, is a real strength of the sheet.
While rewriting the description we found that the capacity formulas (for example Menu!FG19, FG25, EB12 and EB14) use simple averages of the properties of all four layers, whatever the pile length. In the stored example the pile ends at −11 m, yet layer 4 (c′ = 80, φ = 35°, starting at −18 m) is included. The average cohesion used is 37.5 kN/m², against about 18.6 kN/m² weighted by length along the 7 m embedment, so the shaft resistance is roughly twice what it should be. Weighting each property by the length of pile in each layer would fix this.
Also, EB14 calculates the frictional lateral capacity as 0.5γDKpT³ without dividing by a length as in Broms' expression, so it has the units of a moment and appears to overstate the capacity.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Turan,
Thank you for your retaining wall calculation. We recomputed Ka, the active thrust (41.77), the passive thrust (214.2) and the base pressures (117.8 and 99.0), and all agree with the sheet.
While rewriting the description we found one clear error. On the data sheet, cell EV10 calculates the maximum steel ratio with a concrete strain of 0.03 instead of 0.003. That gives ρmax = 0.0268 in the example, against a balanced ratio of about 0.0169 (0.0108 for a tension-controlled section), so an over-reinforced section would not be flagged. Cell D359 on the report sheet also shows #REF!.
Two further points you may want to consider: the minimum steel ratio in EV8 (340/fy, 0.08% in the example) is below the ACI 318 minimum for slabs and footings of 0.18%, and the sliding and overturning checks count the full passive resistance in front of the wall, which many designers reduce or ignore.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
Hello Doug,
Thank you for your Open Channel Flow calculation. We checked the V channel example independently and got the same discharge (0.01292 ft³/s), and the rectangular, trapezoidal and circular formulas check out too.
While rewriting the description we found one error. For the right-triangular channel, cell W52 calculates (√(b² + d²) + d)/12, which is the wetted perimeter in feet, not the hydraulic radius R = A/P. The label in L52 shows the same formula. As a result the discharge in W53 is greatly overestimated: with b = d = 12 in, R should be about 0.21 ft but the sheet uses 2.41 ft, so Q comes out roughly five times too high. R should be 0.5bd / (√(b² + d²) + d), divided by 12.
A smaller point: the substituted-value text in T41 and T52 picks up input cells from other channels (W23 and W35 instead of W35 and W46). Only the displayed working is affected.
We have mentioned these points in the file's description so users are aware. If you upload a corrected version, we will review it and publish it as the next version.
ExcelCalcs Review Team
excelcalcs-review-team 23 hours ago
Thanks for another contribution Alan, your lifetime free subscription is assured as ever. An independent check of your stored compression spring (music wire, d = 3.2 mm, D = 20 mm, 10 active coils) gave the same rate of 13.271 N/mm, the same Bergsträsser stress of 572.2 MPa at 300 N and the same permissible load of 323.6 N, and your Belleville stack, extension hooks, torsion spring, torsion bars and leaf springs all checked as well. The Optimizer's pick of 3.2 mm wire on an 18.75 mm coil meets the rate, the static safety and the fatigue safety of 1.3.
I also reviewed the calculation against our Good Calculation Guide: https://www.excelcalcs.com/calcs/good-calc-guide
**What works well**
- Fifteen spring types and a fatigue check in one workbook, each section headed, numbered and running down a single column.
- The Check column, which says what to change and by how much, and the Optimizer that searches standard wire sizes.
- The built-in theory manual, with every equation, its source and a table of independent checks.
- A true SI/US switch: re-entering the same spring in lbf and inches gave identical results.
**Suggestions that would make it even better**
- Save the workbook after Excel has calculated it. At present the results are not stored in the file, so a downloaded copy shows blanks until Enable Editing is clicked.
- The About sheet (B20) still says coil stress uses Ks = 1 + 0.5/C; the sheet and manual use the Bergsträsser factor for as-wound springs.
- The bending endurance fractions on the Materials sheet (0.50 and 0.53) are Shigley's 10^6-cycle values, but section 17 uses them at 10^7 cycles. Please also give the source for the 0.8 Sut reference in the fatigue line (Shigley uses 0.67 Sut in torsion).
- A small sketch of each spring with its dimensions marked, and the XLC add-in to show the equations in standard notation.
Hello Alvaro, we have been checking the calculations in our Free Calcs folder, and your simply supported beam sheet has been very popular, with nearly 2,900 downloads. While checking it we found one error in the deflection formula, so we corrected it ourselves and uploaded the result as version 1.2.
**What we corrected**
- E66 and the chart row AF66:AP66, on both sheets, and the written equation beside E66: the deflection added the end slope θA as an extra term (y = yA + θA + θA·x + ...). Roark gives y = yA + θA·x + ..., so we deleted the first θA. For your example in mm the midspan deflection goes from 0.2041 mm to 0.2040 mm, and the deflection at the supports is now 0 instead of 0.00013 mm. The error is in the length unit chosen, so it matters more in metres: the same beam entered in metres gave a midspan deflection 64% too large (0.000334 m instead of 0.000204 m).
- C9: "souce" now reads "source".
We checked every other result independently, by numerical integration of the bending moment, for your example and for a partial trapezoidal load, and the reactions, end slopes, shear, moment and slope all agreed with your sheet to five figures.
Thank you for a clear, well-referenced calculation; showing every Roark equation beside its cell made it quick to check. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Thank you for your shear design calculation, nektor. We have corrected the stirrup spacing check and the Table 19 lookup and would like to publish it with a 3-month XLC Pro award. Before we do, please confirm that the calculation is your own: the cell note in M6 was written by Shailja Patel. Under our Good Calculation Guide you must have the right to give us a calculation, and if you were inspired by another author, credit them on the sheet. If Shailja Patel is a colleague who agrees to it being shared, just say so here and we will credit them in the description. Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
Hello again, Pramudya. We have also translated your belt winder calculation into English and published it as version 1.2, so that more of our members can use it; ExcelCalcs keeps its library in English, and this was the easiest way to meet that rule without changing any of your calculations. All the formulas and results are exactly as in version 1.1; only the labels, headings and chart titles have changed (the picture on Sheet1 still has its original Indonesian labels). Thank you again for sharing such a useful sheet.
Good news, Alexander: we have now published your beam-column calculation. Rather than ask you to make the changes in my earlier comment, we made the formula corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- M40 and M44 now apply φb = 0.9 to Mnz and Mny, as your displayed equations show. The example's interaction ratio becomes 0.422 (it was 0.387).
- M46 now tests whichever equation governs, so a member with Pu/φPn ≥ 0.2 no longer always shows "FAIL". H1-1a now applies from exactly 0.2, and the signs at N40 and N44 now belong to their own equation.
- The ratios at F67 and N32, and the signs at H66 and P31, now use φbMn (0.204 and 0.150).
- F36 now switches to the elastic branch Fcr = 0.877Fe when KL/r exceeds 4.71√(E/Fy).
- Sy and Zy (L4, L5) now use the flange width b instead of the depth d, and Lp (L17) now reads E and Fy from L13 and L14.
- The minor-axis strength (N31) no longer applies lateral-torsional buckling, which does not occur in minor-axis bending; we removed the unused step at row 30.
- Mn in zones 2 and 3 (F56, F63) is now capped at Mp, and F66 no longer fails when Lb equals Lr. It uses IF instead of IFS, so it works in any version of Excel.
- The minor-axis block at rows 79 to 82 is now labelled "Minor Axis" and Mny.
An independent check agreed with your section properties and strengths: φPn = 1,277.5 kN, Mn = 138.18 kN·m in zone 2 and Mny = 67.02 kN·m, giving Pu/φPn = 0.137 and an H1-1b ratio of 0.422, so your example member is adequate. A few points remain for a future version: a flange and web slenderness check, a shear check to AISC G2, clause numbers against each step, and a sketch of the section and axes.
Thank you for a clearly laid-out calculation with the governing equations shown beside the working; that made it easy to check. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Phuong: we have now published your fire pump calculation. Rather than ask you to make the changes in my earlier comment, we made the formula corrections ourselves and uploaded them as version 1.1. We also saved the workbook in the current .xlsx format (it was uploaded as an .xls file).
**What we corrected**
- AK15, the elevation derate, now follows NFPA 20: 3% per 304.8 m (1,000 ft) above 91.4 m (300 ft). Before, it started at 300 m. At a 300 m site C_A is now 0.979 instead of 1.000, and your 2,000 gpm example would need 202.70 kW and a 220 kW drive rather than 198.44 kW and 200 kW.
- AK14, the temperature derate, is now capped at 1, as NFPA derates only above 25 °C. Below 25 °C it used to give a factor above 1 and reduce the drive power.
- AJ35 now picks the drive from the full list of standard sizes in column BD. The reversed list in column BC had lost the 45, 55 and 75 kW sizes, so a 500 gpm pump needing 49.8 kW was given 90 kW; it now gets 55 kW.
An independent check of your example agreed with your sheet: hydraulic power 105.15 kW, drive output 198.44 kW at 150% flow, a 200 kW drive and a 1.115 m³ fuel tank. Your example site is at 5 m and 41 °C, so its results do not change. A few points remain for a future version: say whether the drive is a diesel engine or an electric motor, since the derates are NFPA's engine derates; explain or apply the margin factors in V58:V60, which are all zero; and remove the placeholder sizes 501–503 kW from the size list.
Thank you for a well-organised calculation that takes a fire pump all the way from duty point to accessories. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Renya: we have now published your purlin calculation. Rather than ask you to make the changes in my earlier comment, we made the formula corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- G29, the combined strong-axis stress, no longer subtracts the wind suction from the dead + roof live load. It is now self weight + DL + LL, with wind added only when it is a downward pressure. For your example fbx becomes 94.40 MPa (it was 20.67 MPa).
- AE33:AG33 now use wL²/8 for Mx with two sag rods (it was wL²/9, the moment at the rods). The label in your moment-diagram sketch is changed to match.
- The conclusion in D43 now recommends the section only when both checks pass, and mentions sag rods only when some are chosen.
- Two notes below the conclusion state the load combination used and that wind uplift is not checked.
An independent check of the dead + roof live case gives (5.43 + 88.97)/163.68 + (3.00 + 98.46)/186 = 1.12, which the corrected sheet now shows, so your example LC 120x60x20x4.5 purlin with no sag rod is overstressed by about 12%. With one sag rod at mid-span the same purlin passes at 0.71. Two points remain for a future version: add the wind uplift case (0.6D + 0.6W) with the unbraced bottom flange in compression, and say which code clauses the allowable stresses 0.66 Fy and 0.75 Fy come from, since the cold-formed provisions of NSCP 2015 Chapter 5 / AISI S100 would normally apply to a lipped channel.
Thank you for a clear, compact calculation; the sketches of the load components and of the moment diagrams for each sag-rod case make it easy to follow. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Abhishek: we have now published your bracket connection calculation. Rather than ask you to make the changes in my earlier comment, we made the corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- The 360 mm bracket depth was typed inside the edge-distance formula in F5. It is now a labelled input, "Overall depth of bracket plate D", in row 5, and the edge distance is calculated from it, so the geometry stays right when the number or spacing of rows changes. Your example results are unchanged.
- "Depth of bracket plate" now reads "Height of top bolt row above bottom", which is what the cell holds (307.5 mm), and the neutral-axis expression reads h/7 instead of y/7.
- Three labels were respelt: "Edge distance", "Lever arm of bolt row from NA" and "Tension in ith row bolts".
An independent check agreed with your sheet: Σr² = 110,187 mm² for the four rows gives Ft = 1500 × 250 × 263.57 / (3 × 110,187) = 299.0 kN, and the shear is 1500 / 12 = 125 kN per bolt. Points for a future version: cite the textbook or code the h/7 method comes from and say whether h is the full plate depth or the height of the top bolt row (with the full 360 mm depth the tension would be about 313 kN), and add the bolt capacity and combined shear-and-tension check to make it a complete design aid.
Thank you for a compact, clear calculation; the equation shown beside the result made it easy to check. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Pramudya: we have now published your belt winder calculation. Rather than ask you to make the changes in my earlier comment, we made the corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- Sheet1 now sizes the motor from the peak torque during winding. A new cell B22 takes the maximum total torque from your Sheet2 table, and the power in B24 uses it: 32.21 kW (it was 14.50 kW from the bare drum), or 40.27 kW with the 1.25 factor (it was 18.13 kW).
- The bearing friction on Sheet2 now keeps the load in newtons: column N adds the wound belt weight (already in N) to the reel and drive masses times 9.81, and column R no longer multiplies by 9.81 again. At full roll the bearing torque is 217 N·m (it was 1,883 N·m).
- The reel mass in L20:L49 and the 6 rpm in the power column V now come from the input cells on Sheet1.
- The force–radius chart title no longer says "37 kW Motor", and the red highlight on Sheet2 now marks the new peak row.
An independent check agreed with your bare-drum torque of 23,085 N·m and with the roll diameter of 2.038 m after 150 m; with the bearing term corrected the total torque peaks at 51,273 N·m after 90 m wound, which is 32.2 kW at 6 rpm. Points left for a future version: the picture on Sheet1 does not match the sheet's figures and is best replaced by the live charts; state the assumptions (whole remaining belt sliding at μ = 0.9, no acceleration, bending or drive efficiency); and add a purpose line and a sketch of the winder.
Thank you for a clear calculation; tabulating the whole winding was the right approach and made the peak easy to find. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Luis: we have now published your column confinement calculation. Rather than ask you to make the change in my earlier comment, we made the corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- B72, the final required spacing, now includes the maximum spacing in B54: MIN(B54, B67:B70). Your example stays at 0.107 m because the hoop area governs, but with No. 4 hoops the result is now 0.133 m instead of 0.194 m.
- For spirals, B72 is now also limited to B54 and to a clear pitch of 75 mm. For a 0.50 m circular column with a No. 4 spiral the pitch becomes 88 mm instead of 132 mm.
- C72 now warns ("Paso libre t link to another workbook.
Thank you for a clear and useful detailing sheet; deriving the spiral pitch equation on the page made it easy to check. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Chandni: we have now published your basement wall calculation. Rather than ask you to make the changes in my earlier comment, we made the formula corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- D75, the maximum bar spacing, now takes the lesser of 3d and 450 mm: =MIN(3*D18,450) = 450 mm (MAX gave 540 mm). Your 150 mm spacing still passes.
- D80, the horizontal distribution steel, is now 0.2% of the gross section b × D, as clause 32.5(c) sets it: 460 mm² per metre (it was 360 mm² on b × d). Your T10 at 150 mm (524 mm²) still passes.
- F61 and C62, the shear comparison and "Hence shear reinforcement isn't required", are now formulas comparing τc with τv, so they say "required - NOT OK" if the shear stress is too high.
- G77 and G83 now show OK or NOT OK from the spacing and distribution steel checks instead of a typed "OK".
- The ground level in E19 is now labelled m rather than mm, and the spacing rule in D74 reads "lesser of 3*d and 450 mm".
An independent check agreed with your sheet: Ka = 0.333, a base moment of 33.08 kNm/m, Ast required 687 mm² per metre and τc = 0.455 N/mm² against τv = 0.264 N/mm², so your example wall passes. A few points remain for a future version: say whether the wall is propped by the ground floor slab (which puts tension on the inside face near mid-height), consider at-rest pressure and ground water, and add a sketch of the wall and its pressures.
Thank you for a clearly set out calculation; the formula in words beside every value made it easy to check. I have awarded you a 3-month XLC Pro subscription by way of thanks. Our guidance for authors is in The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Good news, Ronald: we have now published your screw calculation. Rather than ask you to make the changes in my earlier comment, we made the formula corrections ourselves and uploaded them as version 1.1.
**What we corrected**
- E42 now divides by the safety factor, as your written formula says: Fut.Rd = As × fus ÷ Ω = 1.59 kN (it was 1.44 kN).
- E53, the head factor, now follows the head type in E9: 1 for a pan head, 0.5 otherwise. For your countersunk example the bearing utilisation becomes 0.66.
- C62 now compares the utilisation in E61 with 1, so the result reads "0.71 he Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide).
Thank you for another fine contribution, Alan. An independent check of your stored example (3 in × 2 in round tube, fixed–pinned, K = 0.80, L = 100 in, 10,000 lbf, m = 0.132) gave the same slenderness ratio 88.75, Johnson critical stress 26,483 psi, straight-line critical stress 22,702 psi and secant critical stress 24,099 psi, so the governing safety factor of 8.92 checks. Because an older file on the site is also called "Column Buckling", we would like to retitle yours "Column Buckling Calculator – Euler, Johnson, Straight-Line and Secant Methods", which also tells users how much more it does.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: https://www.excelcalcs.com/calcs/good-calc-guide
**What works well**
- Four methods and the squash load side by side, with the governing case and allowable load in one status line.
- The critical stress v. slenderness chart with zones marked, the section drawn to scale and the mode shape.
- The range of sections and materials: AISC v16.0, DIN/EN, MMPDS-01 and digitised custom outlines.
- A live worked example on the Reference sheet that shows the arithmetic for the case entered.
**Suggestions that would make it even better**
- Remove the sheet protection, or at least state the password; our guide asks for unprotected sheets.
- Add a validation line comparing a result with a published example, for instance from Shigley or Timoshenko and Gere.
- Mark the Euler result "not applicable" below the transition slenderness, and describe the straight line as a generic line rather than Tetmajer's.
- Clear the "Prepared by: John Doe" placeholder, and try the XLC add-in to show the equations in standard notation.
Thank you for another substantial contribution, Alan, and apologies for not reviewing it sooner. An independent fine-step integration of your stored example (7075-T6, PT surface flaw a = 0.025 in, c = 0.125 in, 30 ksi, R = 0.1) gave 2,157 cycles to failure against your 2,159, and the Newman–Raju terms and the S–N block lives agree exactly. One part needs correcting: the through-crack and edge-crack options stop at a = t, because the fail test a_end ≥ t (CrackGrowth column R) is applied to in-plane crack lengths, and a through-crack NDE key starts the crack at a = t rather than at the tabulated half-length c. For 0.04 in sheet with a PT-TC flaw (c = 0.10 in) and Kc = 65.1 ksi√in the sheet reports failure at 33 cycles, where integrating from c to Kc gives about 1,200. It errs on the safe side, but those options cannot be used as they are.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: https://www.excelcalcs.com/calcs/good-calc-guide
**What works well**
- The whole 5019 chain in one workbook, from part classification and NDE flaw to a life margin and a summary page.
- Every step of the integration is visible, so a reviewer can see where the life is consumed.
- Each material value cites its MIL-HDBK-5J table or figure, with placeholders marked in orange.
- A clear How_To_Use sheet and hover notes on the inputs.
**Suggestions that would make it even better**
- Apply the a ≥ t failure test to surface and corner cracks only, and start through cracks from c.
- Add a crack-length v. cycles chart and a sketch of the crack geometry.
- Cite the revision of NASA-STD-5009 that the flaw table was checked against.
- Consider an SI option, and try the XLC add-in to show the K solutions as equations.
Thanks for another fine contribution, Alan, and apologies for not reviewing it sooner. StressConc Quick is one of the most complete stress concentration tools we have: an independent check of your defaults gave the same Kt = 2.3461, nominal stress 5,333 psi and peak stress 12,513 psi for case 1b, and the case 1a fit reproduces Roark's semicircular-notch polynomial. One case needs a fix: for case 7b (central hole, in-plane bending) Calc!AD16 still returns the hole-edge stress, 751 psi, although the governing stress is at the plate edge, 3,006 psi (Calc!AI16). The margin shown is therefore +52.2 where it should be +12.3, and with a low allowable it can show a positive margin on a plate that would fail. Your own Validation sheet flags it (128 of 129 checks pass). Taking the larger of AD16 and AI16 would put it right.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: https://www.excelcalcs.com/calcs/good-calc-guide
**What works well**
- Two drop-downs drive 43 cases, and the input table shows exactly which dimensions each case uses.
- The live figure of the selected case, drawn with the book's dimension definitions.
- Range-of-validity warnings instead of silent extrapolation, and a clear statement of scope.
- A Validation sheet that recomputes every case and checks the fits at their limits.
**Suggestions that would make it even better**
- Correct case 7b so that the peak stress and margin use the plate-edge stress where it governs.
- Remove the sheet and workbook protection; our guide asks for unprotected sheets.
- Add short cell comments to the inputs, and try the XLC add-in to show each fit as an equation.
Thanks for this excellent contribution, Alan! An independent check agreed with every result I recomputed (cases 1a, 1b, 8a and 13b at your stored inputs), and a Lévy series solution I wrote for case 7a reproduced your finite-element deflection coefficients to four figures (0.1227 at a/b = 1, 0.6358 at a/b = 2). It also confirms your finding that Roark's fixed-edge β1 for 7a is about 6% low (0.665 against 0.71 at a/b = 1). As this version supersedes v2.0 (file 2059), we have kept this one and removed the earlier copy. Apologies for not reviewing it sooner.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- All 53 sub-cases of Roark's Table 11.4 behind two drop-downs, with the coefficients in use shown so every number can be traced to the book.
- US and SI units, range warnings, margins and a thickness sweep.
- FE deflections for the 27 sub-cases Roark leaves blank, clearly labelled, with live contour charts.
- A Validation sheet and a Technical Basis sheet that is candid about the handbook's own weak spots.
**Suggestions that would make it even better**
- For cases 7 and 9, consider showing the FE fixed-edge stress beside Roark's, or using the larger in the margin, since Roark's value is unconservative.
- Consider leaving the sheets unprotected (the password is already in the Notes) so users can adapt the workbook freely.
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
Thanks for this contribution, Alan! I re-ran your formulas on a random rotation (35°, −20°, 110° about Z, Y, X plus a translation) and the sheet recovered the rotation matrix, the Euler angles and the translation exactly, with residuals below 1e-13; your stored example also checks against Rz(90°)·Rx(90°). One edge case to fix: if the move reverses the edge A→B (for example a 180° turn about Z), the MANUAL MOVES block says "skip step 2" and gives a step-3 angle of 0°, so the part is not moved, yet the check in F50 still reads 0. The matrix results are correct in that case. Apologies for not reviewing it sooner.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- A clear, exact method (frames from three points, R = M′·Mᵀ), fully explained on the How To sheet.
- Results in every form a CAD or FEA package asks for: matrix, 4×4, angle–axis and ZYX Euler angles.
- Built-in rigidity, determinant and residual checks, and four live views of the before and after positions.
- Practical step-by-step instructions for ANSYS and FEMAP, including the rotation-order traps.
**Suggestions that would make it even better**
- In MANUAL MOVES, when A→B and A′→B′ point in opposite directions, use an axis perpendicular to AB (for example u3) for the 180° step 2, and check B as well as C in F50.
- Show a message instead of #DIV/0! in the Euler cells at gimbal lock (β = ±90°).
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
Thanks for another fine contribution, Alan! An independent check of your stored example (60 in steel bar, pinned and roller, 500 lb and 300 lb point loads plus a 100 lb/in patch) gave the same reactions of 938.76 lb and 1,061.24 lb, the same deflection of −0.6591 in at X = 30.3 in including shear, and the same peak von Mises stress of 49.14 ksi. Your I-beam benchmark B9 also checks by hand (0.02724 in). Apologies for not reviewing it sooner.
Your lifetime XLC Pro subscription, awarded for all eight of your calculations, is well deserved.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- A true 3-D Timoshenko finite-element solver in plain worksheet formulas, behind a simple one-page input form.
- Every input row has a plain-English Check cell, and the Validation sheet shows live equilibrium and solver residuals.
- The benchmark appendix (nine cases, 32 checks against closed-form solutions) lets users see how it is known to be right.
- Live model diagram and shear, moment, deflection, rotation and reaction plots in both planes.
**Suggestions that would make it even better**
- The solver uses MINIFS (Quick_Input!P4), which needs Excel 2019 or Microsoft 365; the User Guide says Excel 2013+. Please state the requirement, or replace MINIFS so older versions work.
- Bring the README sheet up to date for the Quick edition (it still describes assigning Section IDs on the Elements sheet).
- Consider an SI option alongside in, lb and psi.
- Cite a textbook source for the Timoshenko element and the stress recovery.
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
Thank you for another excellent contribution, Alan, and apologies for not reviewing it sooner. Bolt Joint Quick is the most complete bolted-joint analysis on the site. An independent recomputation of your stored example (1/4-28 UNF A286, 110 lbf·in, K = 0.20, Γ = 0.35) gave a nominal preload of 2,200 lbf, φ = 0.301, Pp,max = 3,407 lbf, Pp,min = 1,002 lbf, a separation margin of +0.09 and an ultimate tension margin of +3.15, and every formula I traced matches the 5020B or Shigley equation it cites. One practical point: the file was saved without calculated values, so a user who opens it from a download sees blank results until editing is enabled. Opening, recalculating and saving it once in Excel would fix that.
As a thank-you for all eight of your calculations I have awarded you a lifetime XLC Pro subscription.
I also reviewed the calculation against our Good Calculation Guide: https://www.excelcalcs.com/calcs/good-calc-guide
**What works well**
- The whole analysis reads top to bottom on one page, with a status bar showing the governing margin.
- The Report tab shows each equation, the numbers substituted and the 5020B clause, ready for a stress report.
- Live joint, bolt-load, fatigue and interaction charts, and a clear anatomy drawing on the Guide tab.
- A Validation tab against published thread areas and MMPDS tabulated strengths.
**Suggestions that would make it even better**
- Save the workbook with its calculated values.
- Remove the sheet protection; our guide asks for unprotected sheets, and the password is already public.
- Add an end-to-end worked joint compared with a published example (for instance one of Shigley's worked joints) to the Validation tab.
- Try the XLC add-in, which would show the Report tab's equations in standard notation.
Thanks for your debut contribution, Fanil! An independent check of your example (σu = 900 MPa, ψ = 50%, modified universal slopes, Nf = 900) gave the same σ′f = 1,401.4 MPa, K′ = 1,672.1 MPa and strain amplitude 0.008407, and solving back from that strain returned 900 cycles. I have awarded you a 3-month XLC Pro subscription by way of thanks.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- Each coefficient is shown with its formula, so the method can be followed at a glance.
- Drop-down lists for the method, the mean-stress correction and the solve mode, and every input is validated with a clear error message.
- The iterations are done in the cells, with a convergence check, so no Solver or macros are needed.
- The strain–life chart responds to the inputs and marks the design point.
**Suggestions that would make it even better**
- Say how it was validated, for example by comparing the coefficients with published values for a well-known steel.
- Cite the source of each correlation (Manson's universal slopes, Muralidharan and Manson's modified slopes, the four-point correlation, Morrow, Smith–Watson–Topper).
- State the purpose at the top, including which ANSYS strain–life fields the results go into.
- Add cell comments explaining each input and the three solve modes.
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
If you send in an updated version that covers these points, it would qualify for our 12-month XLC Pro award.
Thank you for taking the trouble to upload your calculation, Renya, and apologies for not reviewing it quicker. On this occasion we have decided not to publish the calculation as the governing strength check is unsafe. In your example the sheet shows "Pass!" with an interaction ratio of 0.67, but it reaches that by subtracting the full wind suction from the dead plus roof live load. An independent check of the dead plus roof live case on its own gives (5.43 + 88.97)/163.68 + (3.00 + 98.46)/186 = 1.12, so the LC 120x60x20x4.5 purlin is overstressed by about 12%.
**What needs to change**
- Check each load combination separately (dead + roof live; dead + downward wind + roof live; dead + wind uplift) and report the worst. Wind suction should never reduce the dead + roof live check.
- With two sag rods the strong-axis moment is still wL²/8 at mid-span; wL²/9 is the moment at the rods, as your own sketch shows. The sheet understates Mx by 11% in that case.
- Add the uplift case, where the unbraced bottom flange is in compression.
- Say which code clauses the allowable stresses 0.66 Fy and 0.75 Fy come from, and whether they suit a cold-formed lipped channel (the cold-formed provisions in NSCP 2015 Chapter 5 / AISI S100 would normally apply).
- The conclusion recommends a sag rod at mid-span even when "Sag rod = 0" is chosen.
- Tidy up: the dead-load helper (AE5) adds per-mm unit weights without the thicknesses and is not linked to the dead load used (G7); remove the unused hidden W-shape sheet and the defined names that point to #REF!.
- Add a short statement of the design basis at the top, and say how you checked the results.
What works well: the sketches of the load components and of the moment diagrams for each sag-rod case are clear, and the drop-down lists for section, roof covering and steel grade make the sheet easy to use.
If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Phuong, and apologies for not reviewing it quicker. On this occasion we have decided not to publish the calculation as it needs a correction and some tidying first. An independent check of your example gave the same results (hydraulic power 105.15 kW, drive output 198.44 kW at 150% flow, a 200 kW drive and a 1.115 m³ fuel tank), but the elevation derating is not as NFPA 20 gives it.
**What needs to change**
- Elevation derate (cell AK15): the formula starts derating at 300 m, but NFPA 20 Figure A.11.2.2.4 derates 3% per 304.8 m above 91.4 m (300 ft). At 1,000 m the sheet gives 0.93 where NFPA gives 0.91, so the engine is under-derated at any site above 91 m. Suggested formula: =MIN(1, 1-0.03*(AJ15-91.4)/304.8).
- Say whether the drive is a diesel engine or an electric motor: the temperature and elevation derates are NFPA's engine derates, but the result is picked from a list of electric motor sizes.
- The margin factors (V58:V60) are all zero although the table beside them gives 0.1 to 0.3; apply them or explain why not.
- Please remove the table of pump "experience efficiencies" by manufacturer, and let the user enter the efficiency from the chosen pump's curve.
- Please remove the photograph watermarked plcsaigon.com and the manufacturer's brochure image, which are not yours to publish. The extracts from NFPA 20 used to explain the method are fine.
- Remove the company-specific remarks and prompts, and the old "PIPE WALL THICKNESS CALCULATION SHEET" header.
- The file properties name a different author and company; if the sheet was built on someone else's work, please credit them.
- Add a short purpose statement at the top and say how you checked the results.
If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Paula, and apologies for not reviewing it quicker. On this occasion we have decided not to publish the calculation as several sheets are protected by passwords, which restricts how our users can use it, and the workbook is a calibration laboratory's own certificate template rather than a general calculation: it carries the laboratory's logo and letterhead, a real client's name and address, the meter tag and order numbers and the technician's name. The file properties also name a different author and company.
An independent check of your example gave the same meter-factor uncertainty by the API MPMS 13.1 range method (8.0 × 10⁻⁵), but the certificate quotes the combined standard uncertainty, ±0.0041 m³/h, as if it were the expanded uncertainty at k = 2. The expanded uncertainty is 2.005 × 0.0041 = ±0.0083 m³/h.
**What needs to change**
- Remove all passwords and unhide the calculation sheets.
- Remove the company logo and letterhead and all client, meter, order and personnel details; use a neutral worked example.
- Make sure the method is yours to share, or credit its source.
- Report the expanded uncertainty as k × the combined standard uncertainty (cálculos!H25).
- Divide the prover's certificate uncertainty by its coverage factor rather than by √3.
- Calculate the meter factors from the pulses and prover volume rather than typing them in, and correct the example fluid data (water at 842.5 kg/m³ and 41.5 cP).
- Add an English description of the method and inputs; the sheet itself may stay in Portuguese.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again with a calculation of your own and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Jesse. Solving the interaction equation in closed form is neat, and an independent check of all 1,040 tabulated loads agreed with your arithmetic. On this occasion we have decided not to publish the calculation as it applies some of the CSA O86 modification factors wrongly, which affects the loads in the tables.
**What needs to change**
- Use KSc, not KSb, in the compression strength.
- Check the system factor applied to compression in Case 2 against the standard.
- Apply KSE and the treatment factor to E05 once, not twice.
- Include η in the linear term of the cubic, correct the LSL value to 3,465 psi, and check the Parallam column footnote.
- State the purpose and the standard and edition at the top, and say how you know it is right, for example a worked example or a comparison with a published stud table.
- Add a sketch of the wall showing height, spacing, wind and axial load, and unhide the working columns or label them as a working area.
If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Pramudya. On this occasion we have decided not to publish the calculation as the motor power it reports is less than half of the peak power in its own table.
An independent check agreed with your bare-drum torque of 23,085 N·m and power of 14.5 kW on Sheet1. But as the roll grows the drag torque rises before it falls: your Sheet2 table peaks at 51,778 N·m, which is 32.5 kW at 6 rpm, at about 100 m wound. A motor chosen from Sheet1 (18.1 kW with the 1.25 factor) would be too small.
**What needs to change**
- Size the motor from the peak torque during winding, not the bare-drum value.
- Correct the bearing friction column: the wound belt weight is already in newtons but is added to the reel and drive masses in kg and multiplied by 9.81 again (at full roll this gives 1,883 N·m instead of 217 N·m).
- Replace typed values (reel mass 1,000 kg, 6 rpm) in the formulas with references to the input cells.
- Remove the picture on Sheet1, whose figures do not match the sheet, and correct the "37 kW Motor" chart title.
- Add a line stating the purpose and assumptions, units for the belt dimensions, and a sketch of the winder.
If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Nektor, and apologies for not reviewing it quicker. On this occasion we have decided not to publish the calculation as its final check can show "OK" for a stirrup spacing that IS 456 does not allow.
An independent check of your example agreed with your d = 404 mm, τv = 0.092 N/mm², pt = 0.78% and τc = 0.60 N/mm². But because τv mm).
- Read the Table 19 column that matches the concrete grade: at present M20 and M25 use the M40 values, which overstates τc.
- Use Vus = Vu − τc·b·d for the stirrup design, and interpolate τc automatically rather than from typed bracketing values.
- Replace the typed values of fy (415) and spacing (150 mm) inside formulas with cell references.
- Add a line stating the purpose and the IS 456:2000 clauses used, and a worked example you have checked by hand.
If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Foosa, and apologies for not reviewing it quicker. On this occasion we have decided not to publish the calculation as it is one sheet taken from a larger project workbook: the steel strengths and the design load are read through links to that other workbook, which our users do not have, so it cannot be used on its own.
An independent check agreed with your arithmetic (4,465.5 daN on 1,055.6 mm² gives 42.3 MPa, a ratio of 0.15 to 275 MPa), but the heading says it checks thread shear while it checks washer compression, and the notes about a 50,069 daN preload do not match the 1,067 daN used.
**What needs to change**
- Make the sheet self-contained: put the steel grades and the design load on the sheet as inputs.
- Correct the heading and labels, and make the notes agree with the values used.
- Add a statement of purpose, the code clauses used and a sketch of the washer.
- Remove any client or project details before sharing.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
johnbots 3 days ago
The paper is no longer available on the HSE website but can be found at https://pdfcoffee.com/specification-and-inspection-of-thermoplastic-storage-tanks-pdf-free.html
Thank you for taking the trouble to upload your calculation, Juan, and apologies for taking so long to review it. Our check found the arithmetic correct. On this occasion we have decided not to publish the calculation as it is not in English.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Dorothy, and apologies for taking so long to review it. Our check found the arithmetic correct. On this occasion we have decided not to publish the calculation as it is a cost estimate rather than an engineering calculation, and it seems to be of specific use on one of your projects and not a general calculation any of our users could use easily.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Reigh, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as it identifies itself throughout as a calculation tool belonging to RMD (Rapid Metal Development), and every sheet is password-protected.
- It identifies itself throughout as a calculation tool belonging to RMD (Rapid Metal Development), and we can accept only work that the uploader owns or has the owner's permission to share.
- Every sheet is password-protected; the guide asks for unprotected sheets so others can follow the method.
- The same file was uploaded twice; we have removed the second copy.
If you have written a formwork calculation of your own, for example concrete pressure to CIRIA Report 108 with a form-face and tie check, we'd be glad to have it. An unprotected sheet with a worked example, a sketch and the references cited would earn an XLC Pro subscription.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thanks for your debut contribution, Ahmet! On reflection, the extracts from the ISO 1940 guide are fine, as they help explain the calculation, so we have published it. Our hand check of your worked example gave the same 85 N. I have awarded you a 3-month XLC Pro subscription by way of thanks.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- A compact calculation with the method, the equations and a worked example set out properly.
- Only three inputs, so it is quick to use.
- The sources are listed on the sheet.
**Suggestions that would make it even better**
- Say that the result is the total rotating force, and show how it is shared between the two bearings.
- Show e (µm) and Uper (g·mm) as intermediate results.
- Offer the balance grade as a drop-down list of the standard grades.
- Refer to ISO 21940-11, which replaced ISO 1940-1.
- Add a simple sketch of the rotor and its bearings.
If you send in an updated version that covers these points, it would qualify for our 12-month XLC Pro award.
Thank you for taking the trouble to upload this calculation too, Abhishek, and apologies for taking so long to review it. Our checks of the earth pressure coefficient, thrust and base pressures agreed with yours. On this occasion we have decided not to publish the calculation as the example fails sliding, overturning and bearing while the sheet says it is safe.
**What needs to change**
- Make every "hence safe" line a formula that compares the factor with its limit. As uploaded, the example fails sliding, overturning and bearing while the text says safe.
- Choose example dimensions that pass, and make heel + stem + toe equal the base length.
- Remove the Design Heel sheet or rebuild it in this workbook: it links to a file we don't have and shows 90 errors.
- Replace the numbers typed inside formulas (7 m, 0.7 friction, 20 kN/m³) with references to the input cells.
- The Design Heel sheet carries the Indus Consultrans logo and refers to a project file, and there are two screenshots from the IRS code and another calculation. Please confirm the work is yours to share, and remove the logo, the project reference and the screenshots.
- Explain the wall-back angle, the two seismic coefficients and the 0.42·H and 0.33·H points of application.
- Add a dimensioned sketch of the wall, a drop-down for the seismic zone and a validation note.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Abhishek, and apologies for taking so long to review it. Our hand check of the pier, pile and thermal movements (25.5, 4.9 and 13.3 mm) agreed with yours. On this occasion we have decided not to publish the calculation as several values in the longitudinal-force tables have lost a decimal point.
**What needs to change**
- Check both longitudinal-force tables against the source line by line: several values have lost a decimal point (7497 for 74.97 in G35 of the 25 t sheet) and many are stored as text.
- Explain the +22/9.81*34.3 in the longitudinal force, and make its terms labelled inputs.
- Turn the last line into a real check with a stated limit (what the 33 mm is and where it comes from) and a pass/fail result.
- Remove the scanned design-report page, which the calculation does not use, and credit the Bridge Rules and IS 2911 by clause and table.
- Replace the project-specific entries with a neutral worked example, and link the thermal length and pile load to the inputs above them.
- State the assumptions (uncracked sections, short-term modulus, no pile-cap rotation) and add a validation note.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Abhishek, and apologies for taking so long to review it. Our hand check of the 299 kN tension and 125 kN shear agreed with yours. On this occasion we have decided not to publish the calculation as it needs three small corrections first.
**What needs to change**
- Make the bracket depth (360 mm) an input cell, so the geometry stays right when the rows or spacing change.
- Rename "Depth of bracket plate" to what the cell actually holds, or use the full plate depth for the h/7 neutral axis, and say which the method intends.
- Add a title and a sentence of purpose, and cite the textbook or code the method and the h/7 assumption come from.
**Suggestions that would make it even better**
- If the figure is from a book or standard, replace it with your own sketch (it also shows six rows by two columns, not the four by three in your example).
- Add a short validation note: a worked example from the reference with the same answer.
- Consider adding the bolt capacity and the combined shear-and-tension check.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Abhishek, and apologies for taking so long to review it. A quick anchorage check to the IRS code would be welcome in the repository. On this occasion we have decided not to publish the calculation as the lap lengths are bar-diameter multiples labelled as millimetres.
**What needs to change**
- The lap lengths are multiples of the bar diameter but labelled mm. Multiply by the diameter and show both "× φ" and "mm".
- Interpolate the bond stress across the whole of Table 21 (M20 to M40) and hold the M40 value for higher grades.
- Add a title and a line saying what the sheet calculates, and name the code and edition in a cell.
- Replace the screenshot of Table 21 with the typed values you already have (F3:I5) and a reference to the table and clause.
- Add the other lap conditions and the code's minimum lap length, or say they are not covered.
- Say how you know it is right: a worked example checked by hand is enough.
- A small sketch of a lap and cell comments on the inputs would lift it further.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Thanh Hoài, and apologies for taking so long to review it. The table agreed with the code in all 363 values we checked. On this occasion we have decided not to publish the calculation as the answer cell needs a VBA function that isn't in the file.
**What needs to change**
- The answer cell needs a VBA function that isn't in the file. Upload an .xlsm with the function in place (macros unprotected), or replace it with worksheet formulas or an interpolation of the table.
- Define μ, ν and ω on the first sheet, and name the design standard and the chart or textbook the tool is based on.
- Explain the formula used for ν > 0.5 and compare it with the chart at several points; please remove "100% exact" unless the comparison supports it.
- State the limits: a/h = 0.1 only, the ξR assumed, no slenderness effects.
- Add the interaction chart itself, with the current point marked, and a sketch of the section.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Luis, and apologies for taking so long to review it. Our hand checks of both sheets agreed with your totals. On this occasion we have decided not to publish the calculation as it includes a screenshot of another company's design program.
**The change needed**
- Remove the screenshot of the ACESCO Metaldeck design program (it shows another company's software, logo and a project name), and replace it with your own calculation or a plain reference to the manufacturer's tables.
**Suggestions that would make it even better**
- Name the code and edition and give the table numbers for the façade, partition and live load values; consider updating them to NSR-10.
- State the purpose at the top of each sheet and put units beside every input.
- Add a sketch of the ribbed slab section showing the dimensions you ask for.
- Say how you know it is right, for example a hand-worked example alongside.
- Make occupancies 11 and 16 return a number, and delete the defined names that link to another workbook.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Luis, and apologies for taking so long to review it. Curve-fitting the design charts so the strain updates with the inputs is just what our guide recommends. On this occasion we have decided not to publish the calculation as it includes screenshots of the AASHTO charts and the stored example fails three of its own checks.
**What needs to change**
- Remove the two screenshots of the AASHTO LRFD stress–strain charts and cite the figure and specification in text instead.
- Compare the shear movement with the elastomer thickness only, not the height including the steel plates.
- Leave an example that passes all its checks: the stored one fails three.
- Use the actual shape factor of the chosen bearing when reading the strain, and check the cover layer against the inner layer.
- State the specification and edition, cite the clause for each check, and keep to one unit system.
- Add a sketch of the bearing showing L, W, the layers and the axes of rotation.
- Please confirm that you are free to publish a sheet that came out of project work.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Luis, and apologies for taking so long to review it. The parts that evaluate were checked by hand and agree. On this occasion we have decided not to publish the calculation as 129 cells show #VALUE! and it holds a project's own figures.
**What needs to change**
- Repair C39:D48 so the 129 #VALUE! errors clear, and check that every result shows a number.
- It appears to be a calculation made for a project (the "PAS-1" reference and the linked project files). Please confirm you are free to publish it, and replace the project's figures with a neutral worked example.
- Say where the φMn values come from, and include that calculation or name it as an input.
- Use one concrete strength; remove the unused A5 or link the two.
- Name the code and edition at the top, and cite the clauses for the spectrum, the load group and the live load.
- Add a sketch of the pier, cap beam and axes.
- Explain the iteration in rows 138 to 147 in a short note, and remove the links to other workbooks.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload this calculation too, Luis, and apologies for taking so long to review it. A drift post-processor for ETABS output is a practical tool. On this occasion we have decided not to publish the calculation as every result cell shows #N/A as uploaded.
**What needs to change**
- Upload it with a small worked example filled in (storey names, heights and a few joints), so the sheet shows results.
- Add three or four lines of instructions: which ETABS table to export, where to paste it, and that the base must be storey 1.
- Add the drift limit and a pass/fail column, and report the maximum drift per storey.
- State the purpose and the code edition at the top, and label the drift columns "%".
- Add a chart of maximum drift against storey.
- Clear the old numbers in columns L to O and delete the defined names that link to another workbook.
- Say how you know it is right, for example a comparison with the drifts ETABS itself reports.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Luis, and apologies for taking so long to review it. Our hand checks of your results agreed. On this occasion we have decided not to publish the calculation as the final spacing does not apply the maximum-spacing limits.
**The correction needed**
- The final spacing in B72 should be the minimum of the area-based spacings and the maximum spacing in B54, and the pitch limits should also apply to the spiral case.
**Suggestions that would make it even better**
- State the purpose and the code (NSR-10, Title C) at the top, and correct the "losa" heading.
- Show units beside every input and result (m, mm, MPa).
- Add a sketch of the section showing b, h, cover and the tie legs counted in each direction.
- Say how you know it is right: a worked example checked by hand or against a published one.
- Say whether bc is the full or the core dimension, and delete the defined names that link to another workbook.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Muhammad, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as it is Abbott Aerospace's published sheet (AA-SM-103-002-001), unchanged since 2016, and the guide asks that you own the calculations you upload.
- If you have built on it, for example your own laminate, a validation against test or finite-element results, or an SI version, please upload that version, keeping the Abbott Aerospace credit and saying clearly what you added.
- If you do, add a check that d/b is no more than 0.6 and that D16 and D26 are negligible, and state the units of the D-matrix terms.
A calculation of your own on any subject is always welcome, and would earn an XLC Pro subscription.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, and apologies for taking so long to review it. The neutral axis and stresses agreed exactly with our hand check. On this occasion we have decided not to publish the calculation as the Z-factor formula leaves out a term, and the sheet holds a real project's figures.
**What needs to change**
- The file properties name a different author and a consultancy, and the sheet holds a real project's figures. Please confirm it is your own work or that its author has agreed to publication, credit them, and replace the project data with a neutral worked example.
- The Z-factor in H43 and T43 takes the cube root of A alone; it should be the cube root of dc × A, which makes the result 1.71 times larger.
- Use ^(1/3) in the crack-width formula.
- Remove the sheet password.
- Check the code edition against the method (the Z-factor limits belong to ACI 350-01) and the pH wording in the exposure note.
- Bring the working columns into view or label them, and delete the #REF! names.
- File 941 in the repository covers similar ground; please say in your description what this sheet adds.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, and apologies for taking so long to review it. The wind and concrete figures we recomputed agreed. On this occasion we have decided not to publish the calculation as it is a firm's template with the names removed, and it shows about 630 error values.
**What needs to change**
- The cover sheet and page headers are a firm's letterhead with the names overwritten. Please confirm the package is your own work, or that you have its author's permission, and restore the author's name and credit. We can't publish a firm's template with the names removed.
- The "Steel Sections" sheet is a copy of the AISC shapes database: credit it, or keep only the sections used, and remove its protection.
- Repair the broken references and clear the unused rows, so that no error values remain (there are about 630 now).
- State on the first sheet what the workbook covers and which code editions it follows, noting that they are superseded.
- Correct the roof-angle interpolation to start at 5°.
- Say how you know it is right: one worked example per sheet compared with a hand calculation.
- Explain the Insert and Delete buttons, and move them off Ctrl+I and Ctrl+D.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Yasser, and apologies for taking so long to review it. Putting settings, calculation and method on their own sheets is a good start. On this occasion we have decided not to publish the calculation as most formulas read the cell one row away from the input they need, so the results are not meaningful yet.
**What needs to change**
- Most formulas on the Combined sheet read the cell one row above the input they need: the total load is Pu1 only, and the eccentricity comes out as 500 m.
- Make B and L mean the same thing on every sheet, and line the notes up with the inputs they describe.
- Clear the #NAME? and #VALUE! cells, and finish the Design Assist search or remove that sheet.
- Size the footing on service loads including self-weight, and compare q_max with the allowable pressure.
- Add one-way shear, use the correct load for the second column in the punching check, and cite the edition and clauses of ACI 318 you follow.
- Add the sketch the Drawing sheet promises: plan and section with B, L, S and the column positions.
- Then check it against a textbook worked example and say so on the sheet.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Ronald, and apologies for taking so long to review it. The written formula beside every result makes it easy to follow and to check. On this occasion we have decided not to publish the calculation as cell E42 multiplies by the safety factor instead of dividing.
**What needs to change**
- E42 multiplies by the safety factor; it should divide: As × fus ÷ Ω ÷ 1,000.
- The comparison in C62 should test the utilisation in E61.
- Make the head factor in E53 follow the head type chosen in E9.
- Make the written formula at D48 match the cell formula.
- Check the bearing equation against the TIR and add the actual edge distance as an input.
- Add pull-out and pull-over checks, or say plainly that they are done elsewhere.
- Choose the screw size, grade and alloy from drop-down lists that fill in the properties.
- Say how you know it is right, for example by reproducing a worked example from the TIR. With the corrections, that would bring it close to the 12-month award.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Alexander, and apologies for taking so long to review it. The section properties, column strength and lateral-torsional buckling values all agreed with an independent check. On this occasion we have decided not to publish the calculation as the resistance factor is left out of the interaction equations.
**What needs to change**
- Apply φb = 0.9 to Mnz and Mny in both interaction equations, as your displayed equations show (the example gives 0.387 where 0.422 is correct).
- Make the final verdict test whichever equation governs, and correct the two comparison symbols beside the equations.
- Add the elastic branch Fcr = 0.877Fe for KL/r above 4.71√(E/Fy).
- Use the flange width b, not the depth d, in Sy and Zy; link Lp to the E and Fy cells.
- Remove the lateral-torsional buckling step from the minor-axis strength and cap Mn at Mp.
- Use AISC chapter G for shear, or say that an elastic stress check is intended.
- Add a title naming the specification, clause numbers against each step, a sketch of the section and axes, and a flange and web slenderness check.
- Say how you know it is right: a comparison with a worked example from the AISC Design Examples would do it.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Opel, and apologies for taking so long to review it. The recurrence coefficients are entered correctly, which is the hard part. On this occasion we have decided not to publish the calculation as the load references slip a row, which makes the peak displacement 16% low.
**What needs to change**
- The load references in columns G and H slip a row: row 6 should read F5 and F6, row 7 F6 and F7, and so on. As uploaded the peak displacement is 16% low.
- Report the peaks as the largest absolute values.
- State the units of every quantity, and make Tn, m and k consistent (calculate one from the other two).
- Add a title, a sentence saying what the sheet calculates, and the name of the method and the textbook it comes from.
- The file properties name a different author. Please confirm the work is your own, or credit the original author.
- Say how you know it is right, for example by reproducing a published worked example.
- Add a chart of the ground motion and the response, and a sketch of the mass, spring and damper.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Ali, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as the repository is for calculations and this file contains text only.
A commissioning check sheet would be welcome: input cells for the measured voltage, insulation resistance, vibration and flow, each compared by formula with its acceptance limit, with units against every value, a clear pass/fail for each test, and the standards or manufacturer's limits named.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Nano, and apologies for taking so long to review it. Its results agree with published pipe weights. On this occasion we have decided not to publish the calculation as it carries a company logo and we need to know it is yours to give.
**What needs to change**
- The sheet carries the BA Energy logo twelve times. Please tell us where it comes from: we can publish it only if it is yours to give, and the logo should come off.
- "Pipe WT, cost and span calculator" is already in the repository; please say what yours adds.
- Correct the outside diameters of 1 inch (1.315 in) and 5 inch (5.563 in).
- Mark the non-standard wall thicknesses (XXS above 12 inch, and everything above 42 inch) or replace them with ASME B36.10 values.
- Add a title, a note of what is included (no insulation or fittings), and the source of the dimensions.
- Show units on the table headings, and delete the unused defined names.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Waquarul, and apologies for taking so long to review it. The step-by-step layout with code references is just what the site looks for. On this occasion we have decided not to publish the calculation as the tension check uses the least-loaded bolt row, so the top row fails while the sheet says SAFE.
**What needs to change**
- The tension check uses the least-loaded bolt row. It should use the most heavily loaded row (78.7 kN on your figures), and the combined check likewise; the top row then fails although the sheet says SAFE.
- Replace the typed bolt tensions with formulas driven by the moment, bolt rows and lever arms.
- Make each "SAFE/OK" an IF test so it can report a failure.
- Use k2 = 0.9 unless the bolts are countersunk, and derive k1 and αb from the edge and pitch distances.
- Say which force is shear and which is tension, and include FX.
- Treat the end plate and the beam flange separately in bending, and make the drawing agree with the inputs.
- Replace the pasted extracts of the code with typed formulae and clause numbers.
- Add a line on how the result was checked.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Fabrizio, and apologies for taking so long to review it. The charts make the influence lines easy to see. On this occasion we have decided not to publish the calculation as the propped-cantilever reactions have a sign error, and the sheet uses screenshots of lecture notes.
**What needs to change**
- The reaction lines for the propped cantilever need correcting: RB = x²(3L − x)/(2L³) and RA = 1 − RB. The moment term is subtracted, not added.
- Please replace the screenshots of lecture notes and exam questions with your own sketch and typed formulae, and credit the course or textbook the method comes from.
- Add a title and a line or two saying what each sheet calculates.
- Keep one sheet per beam type with L as the input, and generate the stations from L.
- Add the reaction lines for the fixed-ended beam to complete the set.
- Say how you checked it, for example against tabulated influence coefficients.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Ali, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as the ratings for stainless steel above 1000 °F come out much too high, and we need to know who wrote the sheet.
**What needs to change**
- The sheet is marked "Created by: WS" with a blog address. If it is not your own work, we need the author's agreement and a credit.
- Make every interpolation formula search the full table: for stainless steel above 1000 °F the Class 600 to 2500 ratings come out 40 to 90% too high.
- Handle temperatures below 100 °F and at the top of each table, with a clear message outside the range.
- State the basis of the hydrotest pressure, or remove it.
- Name the B16.5 table and material group used for each material.
- Unhide the Database sheet and remove the unrelated cells in columns N to V.
- Add a short instruction note, a chart of rating against temperature, and metric units.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Hao, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as at present it is a working note rather than a calculation others could use.
- Add a title and a sentence saying what the sheet calculates and for what kind of installation.
- Give every number a label and a unit (kW, kVA, V, A), and explain the abbreviations.
- Link the total in D16 to the sum rather than typing 192, and use the voltage and power factor cells in the formulas instead of typed values.
- Say where the 0.75 utilisation factor comes from, and whether standby units are counted.
A table with one row per load (tag, description, kW, duty or standby, efficiency, power factor) and a worked example would make this a useful calculation, and we'd be glad to review it again.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Chandni, and apologies for taking so long to review it. An independent check of the pressures, moment, steel area and shear strength agreed with yours. On this occasion we have decided not to publish the calculation as the maximum bar spacing takes the larger of the two limits instead of the smaller.
**What needs to change**
- The maximum bar spacing takes the larger of the two limits; it should be the smaller (MIN, not MAX). Please check the clause it comes from.
- Replace the typed "OK", ">" and "shear reinforcement isn't required" with formulas, so the conclusions follow the inputs.
- Base the horizontal steel on the gross wall thickness, and correct the "mm" label on the ground level.
- State at the top what is being designed, the code, and that the wall is treated as a cantilever; say whether at-rest pressure and ground water were considered.
- Add a sketch of the wall showing heights, pressures and the steel face.
- Say how you know it is right; a textbook worked example would do.
- Mark the input cells, and delete the empty Sheet2 and Sheet3.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Pancracio, and apologies for taking so long to review it. On this occasion we have decided not to publish the calculation as it is WSDOT's spreadsheet, credited inside the file to R. Dornsife, and it is password-protected.
- The spreadsheet is credited inside the file to R. Dornsife of WSDOT. The repository can only take calculations that the uploader owns or has permission to share.
- The worksheets are password-protected; the guide asks for unprotected sheets so others can follow the method.
- A calculation of the same title is already in the repository (file 790).
- The same file was uploaded twice; we have removed the second copy.
A bearing design sheet of your own, to the current AASHTO edition and with a worked example and a sketch, would be very welcome, and would earn an XLC Pro subscription.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). We hope that this does not discourage you from trying again and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Gustavo, and apologies for taking so long to review it. An independent calculation confirmed your default results. On this occasion we have decided not to publish the calculation as the confinement term is wrong in its units and brackets.
**What needs to change**
- The confinement term in B39 should be (cb + Ktr)/db, with cb, Ktr and db all in millimetres. At present it is right only when the 2.5 cap governs.
- Apply φ = 0.9 to the tie steel area, or say why it is omitted.
- Apply the 300 mm minimum development length.
- On the "CIRSOC" sheet, calculate (cb + Ktr)/db or warn that 2.5 is assumed.
- Show a unit against every input (s, c1, c2) and keep to one system.
- State the purpose at the top, cite the clause numbers, and add a worked example showing how you know the result is right.
- The file properties name a different author, and one image is a scan of the code's factor tables. Please confirm the sheet is your own work, and type the factors in with a reference instead of the scan.
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thank you for taking the trouble to upload your calculation, Hamdi, and apologies for taking so long to review it. An independent check of the thickness, hydrostatic force, λ, limiting loads and stresses for the NPS 60 nozzle agreed with yours. On this occasion we have decided not to publish the calculation as a few results are wrong and some of the figures appear to be copied from API 650.
**What needs to change**
- The "Smax" column on the first tab refers to an empty column P; it should refer to column Q of the stress tab.
- The fθ coefficient −0.03355 should be −0.3355 (branch Tv/tn tell us whether this replaces your earlier upload (file 1930).
We offer guidance for authors on The Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide). If you upload a corrected version we'll be glad to review it again: a corrected calculation earns a 3-month XLC Pro subscription, and one that follows the guide in full earns 12 months. We hope that this does not discourage you and thanks for your interest in the site.
Thanks for your interest in PUMPFDN, Tarek. Its author, Alex Tomanovich, retired some years ago and has said he doesn't plan to make SI versions of his spreadsheets. He has also said that all of them are protected but not with a password, so you are welcome to modify them for your own use: on the Review tab choose Unprotect Sheet, and no password is needed.
If you convert it, check every constant and table as well as the labels, as some formulas may use US units internally.
If you produce a metric version, you are welcome to upload it with a credit to Alex. A version that follows our Good Calculation Guide (https://www.excelcalcs.com/calcs/good-calc-guide) would earn an XLC Pro subscription.
Thanks for your interest in FOOTINGS, Tarek. Its author, Alex Tomanovich, retired some years ago and has said he doesn't plan to make SI versions of his spreadsheets. He has also said that all of them are protected but not with a password, so you are welcome to modify them for your own use: on the Review tab choose Unprotect Sheet, and no password is needed.
If you convert it, check every constant and table as well as the labels, as some formulas may use US units internally.
If you produce a metric version, you are welcome to upload it with a credit to Alex. A version that follows our Good Calculation Guide (https://www.excelcalcs.com/calcs/good-calc-guide) would earn an XLC Pro subscription.
Thanks for your interest in BEAMCOL9, Tarek. Its author, Alex Tomanovich, retired some years ago and has said he doesn't plan to make SI versions of his spreadsheets. He has also said that all of them are protected but not with a password, so you are welcome to modify them for your own use: on the Review tab choose Unprotect Sheet, and no password is needed.
If you convert it, check every constant and table as well as the labels: BEAMCOL9 works to the AISC 9th Edition ASD Manual, which is in US units, so some formulas use US units internally.
If you produce a metric version, you are welcome to upload it with a credit to Alex. A version that follows our Good Calculation Guide (https://www.excelcalcs.com/calcs/good-calc-guide) would earn an XLC Pro subscription.
Thanks for your question. The Bolt_Database tab can't be extended: it is reference data, the sheets are password-protected and its look-ups are fixed to the existing rows. But you don't need it to analyse a small fastener. The database only feeds the two reference lines on the Analysis page (database proof / yield load and recommended torque); the strength, separation and fatigue checks take the thread from the Threads tab and the strengths from the bolt material you choose.
To analyse an M1.6, M2 or M2.5 fastener:
- On the Threads tab, edit the last row, "User thread ISO" (it is unlocked): d = 1.6 mm and P = 0.35 mm for M1.6, 2 and 0.4 for M2, or 2.5 and 0.45 for M2.5. The sheet then works out the stress area: 1.27, 2.07 and 3.39 mm², the ISO 898-1 values.
- On the Analysis page, choose "User thread ISO" in the Thread drop-down.
The two Bolt DB lines will then read "not in Bolt DB", which is expected, and you will need to enter the tightening torque yourself. As there is only one user row, change it to run each size in turn.
Alan, if you see this: adding M1.6 to M2.5 to the thread table and the database in a future version would be welcome.
Thanks for your debut contribution, Luis! An independent check of your example gave the same coefficient, C = 8.7006. I have awarded you a 3-month XLC Pro subscription by way of thanks.
I also reviewed the calculation against our Good Calculation Guide: [https://www.excelcalcs.com/calcs/good-calc-guide](https://www.excelcalcs.com/calcs/good-calc-guide)
**What works well**
- A clear top-to-bottom layout with numbered headings: inputs, bolt strength, equilibrium, then the bolt table.
- Every bolt's distance, deformation and force is shown, so the method can be followed.
- The chart of the bolts, the load point and the instantaneous centre is drawn from the inputs.
- Drop-down lists for bolt diameter, grade and direction of rotation.
**Suggestions that would make it even better**
- Say at the top that this is the instantaneous centre of rotation method, and that Solver must be run after every change.
- Add a warning when the Solver control cells (B63, B64) are not zero, so a stale result can't be mistaken for an answer.
- Say how it was validated, for example by comparing with the C coefficients tabulated in the AISC Manual.
- Cite the source of the load–deformation relation R = Rult (1 − e^(−10Δ))^0.55 and of the 0.34 in limit.
- Put units beside the single input cells, and remove the unused cells (C43, B61) and the defined names that link to another workbook.
- Consider updating the bolt strengths to NSR-10, which has replaced NSR-98.
- Try the XLC add-in, which shows each formula as an equation so readers can check it at a glance.
If you send in an updated version that covers these points, it would qualify for our 12-month XLC Pro award.
ccfrost 14 days ago
Would like to add M1.6 M2 and M2.5 fasteners but only see one ISO row on Threads tab. Can the Bolt_Database tab be added to?
tarekfarah_26 1 month ago
I'd also love if you guys could provide it in Metric/Si units.
tarekfarah_26 1 month ago
It would be nice to have it in metric units.
tarekfarah_26 1 month ago
It would be very nice to have this sheet in metric version.
johndoyle-admin 2 months ago
Thank you for taking the trouble to upload your calculation. On this occasion we have decided not to publish the calculation as it seems to be of specific use on one of your projects and not a general calculation any of our users could use easily. Also the calculation is in Spanish not English. We offer guidance for authors on [The Good Calculation Guide](/the-good-calculation-guide/). We hope that this does not discourage you from trying again and thanks for your interest in the site.
varunvijay89 3 months ago
Excellent work
eduberrios1 3 months ago
Excelente aporte
johndoyle-admin 4 months ago
Thanks for your debut contribution I have awarded you a 3 month XLC Pro subscription by way of thanks!
johndoyle-admin 4 months ago
Thanks for your debut contribution I have awarded you a 3 month XLC Pro subscription by way of thanks!
johndoyle-admin 4 months ago
Thanks for your debut contribution I have awarded you a 3 month XLC Pro subscription by way of thanks!