Please turn JavaScript on
header-image

Newton Excel Bach, not (just) an Excel Blog

Want to keep yourself up to date with the latest news from Newton Excel Bach, not (just) an Excel Blog?

Subscribe using the "Follow" button below and we provide you with customized updates, via topic or tag, that get delivered to your email address, your smartphone or on your dedicated news page on follow.it.

You can unsubscribe at any time painlessly.

Title of Newton Excel Bach, not (just) an Excel Blog: " Newton Excel Bach, not (just) an Excel Blog | An Excel blog for engineers and scientists, and an engineering and science blog for Excel users."

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.83 / week

Message History

A comment on my previous post links to a helpful YouTube video on using TrimRange and the Dot operator:

title="Dot Operator will CHANGE how you Write Formulas in Excel | TRIMRANGE Function" width="640" height="360" src="https://www.youtube.com/embed/euzheB5BfTQ?feature=oembed" frameborder="0" allo...

Read full story

I have just discovered the TRIMRANGE function, and its very useful shortcut version, which were introduced to Excel 365 about a year ago. The function excludes all empty rows and/or columns from the outer edges of a range or array, and returns the remainder of the array​​​​​​​​​​​.

The function arguments are:

href="https://newtonexcelbach.com/wp-content/up...

Read full story
py_UMom 1-05

Following the previous post the OptShearCap3600 function has been modified to give correct results with negative bending moments. The revised spreadsheet and Python code can be downloaded from:

href="https://interactiveds.com.au/software/py_UMom.zip" tar...

Read full story
py_UMom 1.04

The py_UMom spreadsheet has been updated with further revisions to the py_OptShearCap3600 function. The new version can be downloaded from:

py_UMom.zip

For more information on the other functions in the spreadsheet see: href="https://newtonexcelba...

Read full story

I recently read an article about connecting Python to the new Mojo language:

Python Can Now Call Mojo

The article had some code examples, including code to plot the Mandelbrot set, comparing plain Python, Python with Numpy, and ...

Read full story