Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Latex Maths Text in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Stereograms
- Deflections and Moments in Rectangular Plates
- The Countif bug (and how to avoid it)
Recent Comments
Category Archives: Coordinate Geometry
Solving the 4 point lift problem …
… with Excel, Python and pyxll. The problem involves the lifting of a precast concrete panel (or any other long thin object) with lifting points at four sections along the length of the panel, and with the load connected to … Continue reading
Posted in Concrete, Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 4 point lifting, Excel, Non-linear solvers, precast lifting, Python, PyXLL, SciPy, UDFs
Leave a comment
Calculating and plotting rotations
This post was prompted by a recent post at Eng-Tips. The original problem seemed simple enough: Im trying to wirte a formula where I imput vessel heading and datum bore heading and it tells me FWD, STBD, AFT or PORT … Continue reading
Posted in Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Calculate rotations, Excel, Mod, Nautical bearings, Plot rotations, VBA, VLookup
Leave a comment
3D plots with the latest Matplotlib
Installing Python on a new computer, I found I had to downgrade Matplotlib to release 3.5.2 to get my 3D plotting functions to work. Further investigation found that the problem was the Axes3D function. Changing: ax = axes3d.Axes3D(fig)to: … Continue reading
Posted in Animation, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
3 Comments
Installing Python and pyxll from scratch
Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading
Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, installation, kaleido, MatPlotlib, mpmath, Numba, Numpy, Pint, plotly, PyPardiso, Python, PyXLL, SciPy, sectionproperties, Sympy
1 Comment
3D Matplotlib Plots in Excel
As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading
Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
2 Comments