Following on from the previous answers:
The goal-seek function will do what you want. It is under the "What-if analysis" icon on the Data Tab.
If you want more control and more options, or if you need to adjust more than one cell, the solver tool may be worth looking at. It is also on the...
I don't use Calc, but is there something similar to Excel's Paste-Special, that allows you to choose exactly how you want something pasted?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
To clarify a few things:
I am familiar with Strand7, in fact it's the only FEA package I use regularly these days. It's just I haven't used the connection elements before.
The connection elements have to be assigned a stiffness for translation and rotation in each axis direction. If it is...
I am not familiar with using connection elements, or how they work, but I suspect the very high stiffness values you have used may be causing numerical problems. I tried reducing the exponents down from 50 to 10 for translation and 5 for rotation and ran a linear static analysis for gravity...
For anyone wanting a translation:
In the information section under the video, click on "more", then scroll down to the bottom and click "show transcript".
Right-click on the transcript and select "translate to English".
This will convert the transcript to English, and the subtitles will also be...
OK, quick summary of results with supports at the beam ends, and full load applied with specified EI values, using my beam analysis spreadsheet, with the sine load approximated with 32 trapezoidal loads:
With full sinusoidal load applied from 6 to 68":
Reaction = 1633 lb
Deflection at 6" =...
BAretired - sorry, but I can't read that and I have no idea what your point is, or why the analysis is terminated prematurely.
If it helps I'll have a look at the beam supported at the ends only (but it's getting late here, so I might not get back until tomorrow).
Doug Jenkins
Interactive...
I have now done my own analysis with the sine loading and find:
R0 = -3214.9 lbf
R1 = 4849.3 lbf
which is pretty close to the computer results provided. They also agree with results from my continuous beam spreadsheet. My solution uses the "exact" sine distribution, which would account for...
Here are my calculations with the end supports removed to get a determinate structure, then apply a unit load to the left hand end to find the end reactions required to bring the deflections back to zero:
Results are (of course!) exactly the same as before.
Doug Jenkins
Interactive Design...
rb1957 - I'm pretty sure the original question was for 4 rigid pinned supports and he is now asking for 4 spring pinned supports. There is no suggestion of moment fixity, and if the internal supports had fixed moment restraint the problem would effectively be for 3 independent spans.
Doug...
The main point of my previous post was that it simplifies the analysis to do the calculations assuming a unit maximum load, unit span, and unit flexural stiffness. You can then do the calculation with a beam analysis spreadsheet, an FEA program, a pen and paper and slide rule, or anything in...
I agree that it would be quite interesting to look at things like this using symbolic solving software, but for practical purposes if the end result required is some simple coefficients for a particular span arrangement and loading, it seems to me far simpler (and less error prone) to just do a...
No, for a point load applied at the centroid of the distributed load the centroid of the reactions will be the same but each of the reactions changes. The slope of the beam at the two internal supports will change, so the end reactions will change, so the internal reactions must also change...
I suspect that was a typo. I checked the result in my continuous beam spreadsheet and got exactly the same result for the two end reactions.
Also the internal reactions will be in the opposite direction to the end reactions.
Doug Jenkins
Interactive Design Services...
You mean this table?
As for the Commentary being unofficial and out of date, it was prepared by a committee chaired by the chair of the Standards committee and "provides background material and guidance to the requirements of the Standard". It was published in 2021, and the only change to the...
human909 - I was going to post some text from the AS 1170.4 commentary, but I see you already posted it yourself on 20th Feb.
It seems to me that the commentary makes the intended application of the maps perfectly clear. It clearly states that the contours are the outer boundaries with a...
For sole practitioners and small consultancies, have a look at:
Concrete Institute Standards Online
This provides on-line access to all Australian Standards for $320/year
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
I don't know the Etabs API (or even Etabs) either, but the lines:
Dim TableKeyList() As String
Dim WindowHandle As Integer
TableKeyList() = Range("A3:A4").Value
Don't look right.
You can import data from a range into a variant array if you declare it as a Variant.
The code below works for...
The load on the base in the spring model, and in the actual structure, will be a long way from uniform. The pressure will reduce towards the centre line, which will significantly reduce the bending moments in the base.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/