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. 4thorns

    Reverse engineering section properties

    Hi All. According to a third party report I have, an 8x12 beam notched both sides @ 24" o.c. for 4x8 timber floor joists has the following remaining section properties. (It's basically an inverted "T" at each joist location with the space between the joists acting as solid blocking) Area =...
  2. 4thorns

    Alternate method instead of ridge beam and rafter ties...

    How deep is the garage? (floor joist span) You also have to bear in mind that you are putting floor load on the garage door header as well. Doug
  3. 4thorns

    Combine known column and row based on cell contents VBA

    Figured it out 20 seconds later. "+" = addition. Range("E" [highlight #8AE234]&[/highlight] RN).Select Works perfect.
  4. 4thorns

    Combine known column and row based on cell contents VBA

    Hi All. This seems like it should be easy and I know I've done something similar in the past. Sub ScrollToName() Dim RN As Integer RN = Range("P5").Value ActiveWindow.ScrollRow = RN [highlight #FCE94F]Range("E + RN").Select[/highlight] End Sub It scrolls to the top perfectly but I can't seem...
  5. 4thorns

    Deck ledger to wall detail.

    Mike. I came up with this last night.(I was half asleep so go easy on me) It's probably as complicated as your detail (if not more) but may have some possibilities. I am not a mason and can't tell you what size steel to fabricate it from but as a first attempt I think may have some merit. After...
  6. 4thorns

    Changing the tread size of a staircase in a building

    Interesting question. I believe the US code says that tread widths within any flight of stairs can vary no more than 3/8". Key words being "within any flight of stairs" I haven't found anything regarding successive flights of stairs (separated by landings). Not sure if this is the case here...
  7. 4thorns

    Conditional format based on values, characters and spaces (feet and fractional inches)

    I'm trying to foolproof a spreadsheet. I would like the user to input feet and inches in a certain format. I need a formula to use in conditional formatting that highlights a cell if the input is not correct. It must be input as in these examples, 12'-6" or 12'-6 1/2" The correct procedure...
  8. 4thorns

    LVL Crushing

    Just thought of this. Here's a thought based on my experience with this type of lumber. Most of the time we had full packs of pt lumber delivered to the job site based on the size of decks and such that we were building. If the packs had been exposed while stored at the lumberyard (uncovered)...
  9. 4thorns

    LVL Crushing

    The 2x is appears to be a piece of treated southern pine. The green hue comes from the treating process. It's almost as hard as the concrete it sit's on! If you've ever tried to drive a nail thru it after its aged (even a short while)you know that you have a better chance of hitting the lottery...
  10. 4thorns

    Printing Actual Size Templates

    I just printed a dimension of 6" to pdf from model view to a pdf set at 1:1. Opened the pdf in Adobe Reader and printed it set to "Actual Size". Granted, my eyes aren't what they used to be but my Stanley Power Lock showed it spot on. Printed with an old HP DeskJet 5650. If you are printing...
  11. 4thorns

    Printing Actual Size Templates

    The printer at Staples should have an option to print "Actual size". (or something similar)
  12. 4thorns

    Printing Actual Size Templates

    Are you plotting to pdf from model? Make sure "Fit to paper" is unchecked. In the drop down window next to "Scale" click on 1:1. Doug
  13. 4thorns

    Roof Framing Input

    The roof is a 12/12 pitch. Vertical load should be quite small. At 25' wide it is 12 and a half feet tall +/-. Basically it's a giant sail! As far as vertical loading I agree with Archie: With that said I've attached a drawing that i think is fairly close to the existing structure.(please...
  14. 4thorns

    Runtime error

    Yakov. It looks like your suggestions made the difference. It seems to be working fine now. I'm sure I will have to make changes to it as the spreadsheet progresses but it's a good start. It may not be the prettiest code but with the limited time I have to work on it it'll suffice for now...
  15. 4thorns

    Runtime error

    IRstuff, the code is called by d double click in column "D". Doug, the error code is related to the notes=......vlookup. Thanks, Doug
  16. 4thorns

    Runtime error

    Sorry Guys. Here is the code. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim isect As Range Set isect = Intersect(Target, Range("D:D")) Dim a1 As Range Dim targetoffset As String Dim notes As String Set a1 = Range("a1:a1")...
  17. 4thorns

    Runtime error

    Hi all. I have tried for quite a while to figure out what is wrong with this code. I've attached an image of the code and the error. It has to do with the vlookup portion of the code. I want a message box that shows the notes determined by the vlookup. I think it has something to do with the...
  18. 4thorns

    Sumif with multiple criteria

    Let me try again. Link
  19. 4thorns

    Sumif with multiple criteria

    Thanks for the reply IRstuff, and you are right. That would be perfect if the description of my problem was accurate. I should have done this before. I've included a picture that I hope is a better representation of my dilemma. Thanks again, Doug
  20. 4thorns

    Sumif with multiple criteria

    Hi All, Wondering if you could give me a hand with this. I need a formula that will: Sumif column D if the contents of column C are in column B and have an "x" next to them in column A. I've picked this apart but can't find the right combination of functions to make it happen! A B C...

Part and Inventory Search

Back
Top