Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Taming Symbols in Excel
- Frame Analysis with Excel 1 - Single beam
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Solving non-linear equations with two or more unknowns – 3
Recent Comments
Tag Archives: Excel
Reinforced Concrete Moment Curvature – Development over time
I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working. The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged creep, development over time, Excel, moment curvature, RC Design Functions, Reinforced Concrete, shrinkage, TimeCurve function, UDF, VBA
Leave a comment
Filling Blanks with Go To-Special (and local help rant)
Recently a thread at the Eng-Tips forum prompted me to look for help on the Go To-Special function in Excel. Pressing F5-Alt S, then clicking the help icon in the dialog box brought up: It seems that the offline help … Continue reading
Posted in Excel, VBA
Tagged Excel, Excel Help, Filling Blanks, Go To, Go To-Special, Local Help deficiencies, VBA
13 Comments
A mystery curve links to Jupyter
Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading
Posted in Charts, Charts, Excel, Maths, Newton
Tagged curve generator, Excel, Jupyter, Maths, parametric curve, Python, Scatter chart
2 Comments
ConBeamU 4.05 and ConBeampy 1.02
The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, Python. Excel-Python, UDF, VBA
1 Comment
New and updated links
I have just updated my Blogroll, with 9 new links, and a couple of updates: Colin Caprani’s site is now back on-line I have updated the link to Jon Peltier’s blog dataprose.org was the source of many of the new links, … Continue reading