Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Daily Download 8: Drawing in Excel
- Taming Symbols in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
- Lateral pile analyis with PY curves ...
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Sophea CE on Biaxial bending update Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and…
Category Archives: Newton
Python optional arguments from Excel – Part 2
The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged default arguments, Excel, Python, PyXLL, UDFs, VBA
Leave a comment
Units4Excel Update
As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Evaluate text functions, Excel, UDFs, Unit aware calculations, VBA
5 Comments
More on RC design of circular sections
Following the last post on this topic (Reinforced Concrete Design for Circular Sections to Eurocode 2) I have added provision for parabolic-linear concrete stress blocks to the ULS Design Functions spreadsheet. The Circu function in the RC Design Functions spreadsheet has … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI 318, AS 3600, Circular reinforced concrete sections, Comparison of codes, Eurocode 2, Excel, UDF, ULS Design Functions, VBA
Leave a comment
More Open Source FEA Code Links
The book Nonlinear Finite Element Analysis of Solids and Structures 2nd Edition has an associated python code package called pyFEM, but a search for this code finds several others with the same or similar names: The pyFEM sites associated with the … Continue reading
Lost Sydney
Lost Sydney is a Facebook site with 100’s of photographs of Sydney, some dating back well over 100 years. This is Sydney’s story. Lost Sydney is not just about demolished buildings, it’s also about photos of Sydney’s past. Lost Sydney
Posted in Arch structures, Bach, Historic Bridges, Newton
Tagged Historic photographs, Lost Sydney, Sydney Harbour Bridge
Leave a comment