Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski 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: *

  • Users: SacreBleu
  • Content: Threads
  • Order by date
  1. SacreBleu

    Glulam Beam (less than 12" deep) allowable stress

    Normally, we specify 24F-V4 for ss beams and 24F-V8 for cantilever/continuous. Lately, I have been getting some feedback that "column-rated" Glulams have been installed as beams (we had calculated various 3-1/8" x 9" deep and 5-1/8" x 9" deep beams, to fit within 2x10 floor joists). The builder...
  2. SacreBleu

    Concrete walls - minimum compressive strength?

    In the ACI Code, is there a specified minimum compressive strength for structural, reinforced, concrete walls? I would be comfortable with 28-day f'c=2500 psi for a low-rise structure, but was wondering if the ACI stated a minimum allowable.
  3. SacreBleu

    Minimum compressice strength for walls

    I don't have a current ACI Code. Is there a specified minimum compressive strength for structural, reinforced, concrete walls? I would be comfortable with 28-day f'c=2500 psi for a low-rise structure, but was wondering if the ACI stated a minimum allowable.
  4. SacreBleu

    How to sort automatically by using functions?

    Suppose I have a range of numbers A1:A100. The numbers are not static - they are generated by formula results. They can be in any numerical order, but I need to have Excel sort them automatically, in order to do a DSUM to show a finalized summary table. How is it possible, without using VBA or...
  5. SacreBleu

    Using ASAP Utilities for Excel

    When using the System/"Find and remove external links" option, be careful. If any formula includes an external reference, instead of deleting just the external reference (leaving the rest of the formula intact), ASAP Utilities essentially deletes the entire formula and leaves only the formula...
  6. SacreBleu

    Highlight cells with dependent cells?

    Without using VBA (I am not familiar with VBA), is there an easy way to highlight or mark all the cells in a worksheet that have dependant cell(s)? I am trying to debug a very complicated worksheet, and that would help a lot.
  7. SacreBleu

    How to reduce file size?

    In a previous thread, I was asking how to reduce the file size of my "bloated" Excel workbooks. One suggestion was to restore as many cells as possible to default format settings, i.e., no fill colors or anything other than default. Another suggestion was to use the ASAP Utilities add-in to...
  8. SacreBleu

    Deck vs. balcony live loads

    After all the confusion about definition of "deck" versus "balcony" that endured for years under the UBC codes, the IBC supposedly cleared this up. This relates to residential and multi-family construction. Looking at 2003 IBC Table 1607.1 (2000 IBC is similar),an exterior balcony gets a live...
  9. SacreBleu

    Live Loads for decks and balconies - IBC 2000/2003

    After all the confusion about definition of "deck" versus "balcony" that endured for years under the UBC codes, the IBC supposedly cleared this up. This relates to residential and multi-family construction. Looking at 2003 IBC Table 1607.1 (2000 IBC is similar),an exterior balcony gets a live...
  10. SacreBleu

    Live Loads for Decks and Balconies

    After all the confusion about definition of "deck" versus "balcony" that endured for years under the UBC codes, the IBC supposedly cleared this up. This relates to residential and multi-family construction. Looking at 2003 IBC Table 1607.1 (2000 IBC is similar),an exterior balcony gets a live...
  11. SacreBleu

    Adding data arrays to existing workbook

    Is the following possible without using VB or macros? Suppose we have a data array, for example data in the range of cells A1:D200. This range is named as RAN1. In the workbook, there are a large number of formulae which refer to RAN1, for the purposes of data lookup. Now suppose we find the...
  12. SacreBleu

    Is 4x really minimum wood post size?

    According to a plans review for a multi-family, 3-story wood framed apartment building structure, the "overzealous" 3rd-party plans check engineer (bless his soul) made this comment (bear in mind that the definition of "column" and "post" includes compression members located within wood stud...
  13. SacreBleu

    Conditional Formatting problem

    Is the following possible without using VB or macros? Suppose cell B1 has conditional formatting, such as Cell Value is not equal to cell A1. Now, I need to copy and paste B1 every 10th row, numerous times, down the spreadsheet. What results, such as in cell B11, the conditional formatting...
  14. SacreBleu

    Boss keeping projects on "warming plate"

    What is with this policy? I realize that it is to maximize profits, but if a client is paying a substantial fee for complete and correct engineering calculations and drawings, isn't he being cheated? When all these projects are kept on the "warming plate" until they are due in 3 days, then there...
  15. SacreBleu

    Diameter of wheels of "Ironman" bikes

    Was there a specific reason(s) for the change from 650 cm to 700 cm diameter?
  16. SacreBleu

    Excel runs slowly on computer

    Frequently, my Excell workbooks get very large because of added worksheets and data, and then they run very sluggishly on the computer. What is the best way to upgrade a computer to solve this? More RAM, faster processor chip, both, or what?
  17. SacreBleu

    MTBE concerns

    1) Is the MTBE addition to gasoline producing exhaust emissions which are harmful to the health (including cancer)? I am not talking about gasoline in contact with the skin, just wondering if the MTBE causes levels of any unhealthy gases or particulates in the atmosphere. I live in the Phoenix...
  18. SacreBleu

    Design of uniform thickness PT slab on grade

    At work, we are having a difference of opinion. Design of uniform thickness PT slab, on very expansive soil. The usual designs in this area are almost always 7.5" thickness, with tendons spaced to produce about 50-60 psi final (after friction losses) compression. Unfortunately, this project's...
  19. SacreBleu

    Cannot open Excel workbook

    An excel workbook I had been working on "crashed" and no longer opens. There is some sort of "apologetic" message that apears, asking if I wish to send a report to MS. Is there some way of repairing it? I had been saving it every few minutes while working on it, but did not think of saving it as...
  20. SacreBleu

    Stress reduction at wood stud walls (fire-rated)

    In the UBC and IBC, there is an "obscure" footnote in the fire-rated wall assembly tables. It simply requires a reduction of allowable fc' stress (multiply by 0.78) for design of load-bearing stud walls if wall is fire-rated. (I don't have access to the Codes now, so I can't give a page or...

Part and Inventory Search