Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yakpol

    Bearing Resistance of Culvert Foundations

    Thank you for responses. I was surprised how gray this subject is. We proposed to use bearing capacity based on the larger embedment if eccentricity (M/P) exceeds 0.1 of footing width, which ensures that linear bearing stress on this side is at least 4 times larger than on the side of shallow...
  2. yakpol

    Bearing resistance of culvert footings

    Initially posted this question here: https://www.eng-tips.com/viewthread.cfm?qid=519497 Hope to attract more attention on this forum. Appreciate responses! Yakpol.
  3. yakpol

    Bearing Resistance of Culvert Foundations

    I am designing the arch culverts supported on the spread footing. My question is: can I use larger bearing resistance when maximum stress occurs under the heel of the footing? Tradionally, the bearing resistance is calculated using footing embedment depth (Df per AASHTO) inside the culvert (at...
  4. yakpol

    Interpolate Help

    You may come up with a long cell formula for linear interpolation. Excel still does not have a good built-in function to do this simple task. Or you can use VBA function presented below. Public Function INTER1(Xval As Double, x As Range, Y As Range) Dim Nrow% Nrow =...
  5. yakpol

    RC concrete crack control with bundled bars

    HTURKAK, ACI does not require to increase development length for 2-bar bundles. So, the difference in bond with a single bar must be small and safe to ignore.
  6. yakpol

    RC concrete crack control with bundled bars

    Curios about your opinion about ACI/AASHTO or any other code provisions about bar spacing. E.g. would it be equal to reinforce with #8 spaced at 4" vs bundled (2-#8) spaced at 8" ? The bond area of 2-bar bundle is the same as for 2 single bars. Would it matter? Older ACI/AASHTO provisions were...
  7. yakpol

    UDF will not run in Excel 365

    Sorry for troubling. This UDF does not work only in one particular workbook, but just fine in all others.
  8. yakpol

    UDF will not run in Excel 365

    Thank you for replies. I will try to change properties of the file. Doubt it's going to help. The file I am using has plenty of macros and they run fine. But UDF does not. Wonder if there's a way to register, so it may act as native function.
  9. yakpol

    UDF will not run in Excel 365

    I was surprised to find that UDF do not work in the latest MS office worksheet. UDF name appears on the list after typing "=" sign, but then it becomes unrecognized (#NAME?). If anybody encountered it and managed to solve? Thanks!
  10. yakpol

    general purpose VBA routines that you find useful ?

    One more thing. Disfor() requires these two functions to be placed in ThisWorkbook module, they help to keep screen and print updated. Private Sub Workbook_Activate() Application.CalculateFull End Sub Private Sub Workbook_BeforePrint(Cancel As Boolean) Application.CalculateFull End Sub...
  11. yakpol

    general purpose VBA routines that you find useful ?

    The numbers displayed have the similar format to referenced in the formula. In addition, the second argument (optional) limits precision. Like disfor(A1, 3)
  12. yakpol

    pressure on a wall induced by strip loads

    Case A governs design of the stem, Case B governs the overturning.
  13. yakpol

    general purpose VBA routines that you find useful ?

    Here's my favorite UDF, it shows the numbers behind the variables in excel formulas.
  14. yakpol

    Excel formula help please

    Skip, thanks for showing this technique. Implementing it I came up with this array formula. It looks weird, but works: {=LEFT(A1,LEN(A1)-SUM(ISNUMBER(NUMBERVALUE(RIGHT(A1, ROW(INDIRECT("1:" & LEN(A1))))))*1))}
  15. yakpol

    Anchored End Span Bridge

    Seems like ages ago we designed a 270' concrete bridge tied down at abutments. Link Let me know if you are interested in the plans. Yakpol
  16. yakpol

    Excel formula help please

    Here's a solution without using VBA, just formulas. It works if the number of digits right of the last letter is limited. In the presented formula it's assumed 5, but can be increased if needed. The formula in B1 returns the number of digits past the last symbol, the formula in C1 returns...
  17. yakpol

    PTC Prime (again)

    I like Mathcad Prime the best (as long as the company pays for it). Agree, several things can be improved, and the developer is very slow working on them. Arrays and the Solver do miracles in MathCad. No way I can reproduce many of the longer calculations in SMath. I tried. But... for everyday...
  18. yakpol

    Pivot Table Help for Parent/Child Relationships

    Excel pivot table became really easy to set and it will do the job you ask. Create a filter for the table: Select all data including column headers, from the ribbon select Data/Filter. Filter lists will appear at each column. Now you can hide data whatever you like.
  19. yakpol

    Excel is evil

    The last phrase in the video is my favorite: Excel tolerates all kinds of errors, in fact, it actively generates them. Makes you think twice before you embark on a big spreadsheet. https://blogs.oracle.com/smb/10-of-the-costliest-spreadsheet-boo-boos-in-history Yakpol
  20. yakpol

    [Excel] [Macro Enabled] Rigid Plate Analysis

    Celt, judging from the subject, this project is for entertainment rather than for productivity. Working with live formulas using Smath or MathCad one can come up with a truly elegant solution, working on which would be way more satisfying than worrying about correct cell references in unruly...

Part and Inventory Search

Back
Top