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 =...
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...
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...
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...
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...
This seems like it should be simple but maybe it's bed time!
In cell A1 is the formula =B1. Easy enough.
What I would like is for A1 to reference B1 exclusively. In other words "Do not follow the content of B1 around the
sheet when I move it. Is this even possible?
Thanks,
Doug
I found this code somewhere online. I forget who the author was and apologize but it works very well.
I have a column with several measurements in Feet"-Inch" format. The corresponding cells in the column next to it convert the feet and inches to decimals. At the bottom I have a cell that sums...
When you receive a set of plans that needs to be checked for structural integrity you perform necessary calcs on structural members, connections etc. When you find areas that are inadequate you determine what changes need to be made to the plans to rectify the situation. I know that there are...
Hi all. The attached is in my case (and probably yours too!) a waste of time because I've already figured out how to do it using Autocad tools. I'd like to see if it can be done old school with no known numbers involved. Reminds me of trying to trisect an angle using a compass and a straight...
Hi everyone. In the attached I've shown 3 details I'm using to try to determine the allowable wind loads for a wall stiffener in a log home. In this case the post isn't long enough to go from floor to roof. After studying it I feel that I should:
A: Consider the reduced section a cantilever...
I'm trying to find a way to hide a row on sheet 1 if a corresponding cell on sheet 2 is empty. The requirements are as follows:
1. If Sheet2, A1 is empty then hide Sheet1 Row 1.
2. If not then display the contents of Sheet2 A1. (That's the easy part)
3. Updates to Sheet2 have to be reflected on...
Hello All. Hypothetical situation. I have a (4)-2x12 built up wood girder. It's part of a floor system and loaded from one side. All members are (theoretically) identical in size and grade and if properly connected, more than capable of carrying the side load. Joists have adequate connection to...
I'm trying to tweak the following script to apply only to 1 cell.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("h1").Interior.ColorIndex = xlNone Then
With Range("h1").Interior
.ColorIndex = 43
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
With...
Changing cell contents over multiple sheets can be a wonderful thing, UNLESS (yes I was yelling), unless you don't realize you have multiple
sheets selected. Only an idiot would do this right? Well I stand accused.
Is there a setting that let's you know when you are doing this? Obviously...
Seems like this shouldn't be difficult but it must be bed time. Simply put...
Conditional format in cell B1....If A1 is less than zero then format text in this cell (B1) red.
Not sure how to go about this. Any thoughts?
Doug
Hi All,
Given a simple residential floor system situation, joist ends sitting on a wood girder, dead load only...
2x8 SPF floor joists @ 16" o.c. weigh 2.2# +/- per square foot
5/8" OSB weighs 2.2# +/- per square foot
That's a total of 4.3# per square foot. I design at a minimum of 10#. I...
Can someone please show me the steps to adjust the formula in cell B1 to give me decimal inches based on cell A1? The formula in cell C1 works fine but it's referencing B1 which has a bogus result. Studying it I've learned that it doesn't want the dash or spaces between feet and inches but I'd...
I'm designing a rafter framed residential roof. Rafter span is less than 20'. Based on ASCE 7-05 I have to use I*Pg for unbalanced snow load and it will control. See this thread (http://www.eng-tips.com/viewthread.cfm?qid=308556). The pitch of this roof is 12/12 (that's 45 degrees!) Do I...
Not sure how to approach this. It's not 3 simple spans nor does it appear to be a multispan built up beam (Wood 2x). I'm trying to determine the loads on the posts supporting the beam. I can determine the loads based on the 3 simple spans and if the beam is continuous end to end but not sure how...