ULS Concrete design with Python

Posted on 11/02/2024 by dougaj4

The py_UMom and py_ULS Design Functions have now been updated and can be downloaded from:

py_UMom.zip

py_ULS Design Functions

More details of the two spreadsheets can be found at Python Code Updates – py_UMom and ULS Design Functions – Python version.

The most significant updates are:

  • The calculation of the effective depth for longitudinal force due to shear has been updated to be consistent with the Australian code requirements.
  • An example of the py_UMomR function has been added to the py_UMom spreadsheet.

The py_UMomR function has the same simplified input as py_UMom, specifying a rectangular section with 2 layers of reinforcement, with the addition of an optional range for prestress details. This allows a prestress force to be applied to one or both layers of reinforcement, and/or an additional prestressed tendon to be specified.

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , , | Leave a comment

More from Anne Briggs

Posted on 02/02/2024 by dougaj4

A (comparatively) recent YouTube of Anne Briggs from her brief return to public performances in 1990-91:

Anne Briggs – The Jim Lloyd Sessions, 1990-91

Anne Briggs made two appearances on Jim Lloyd’s ‘Folk on Two’ during her brief 1990-91 return to live performance. On 7/11/90, the show broadcast ‘Martinmas Time’ from Salisbury Arts Centre, recorded during a short tour with Martin Carthy & Dave Swarbrick. On 20/2/91 she was live in the studio, interviewed by Jim and performing four songs. The photos here include: three taken by Eamonn O’Docherty in Ireland 1967; one taken by me in Lincolnshire 1991; several taken by me in Edinburgh 1992 (during the filming of ‘Acoustic Routes’); two taken near Oban in 1997; one taken by Brian Shuel in 1962; and a couple of others from the 60s.

… and an interview from April 2019, reposted this month:

I don’t know who I am, I don’t know what I am… but I am” Anne Briggs interviewed

Posted in Bach | Tagged , , , | Leave a comment

Close to it all ..

Posted on 26/01/2024 by dougaj4

The death of Melanie Safka was reported yesterday.

She was best known for her work in the late 1960’s and 1970’s, but she continued performing throughout her life. Here is a small selection from her live performances over the years.

MELANIE 26 minutes of bliss – 1971:

When I was a young man living in England there was a series of “In Concert” TV programmes broadcast with singer / songwriters of the day including Neil Young, Cat Stevens, Joni Mitchell and of course Melanie Safka. This particular short “concert” was recorded in London on 14/7/1971 and broadcast 8/1/1972. I remember being mesmerised by Melanie’s performance, and its power has not diminished over the intervening years, although sadly the “peace and love” message, so prominent in Melanie’s lyrics, never really got much further than 1971, we all hoped it would after the short lived “halcyon” years of hope from 1967 – 1970. As Joni Mitchell sang in 1972 on California ” Sitting in a park in Paris, France, Reading the news and it sure looks bad, They won’t give peace a chance, That was just a dream some of us had …. “. I’ve remastered this as best I can from the original tape I had – I hope you enjoy it. Peace!

Lay Down / Candles In The Rain MELANIE & DAUGHTERS Live ’91:

MELANIE & MILEY CYRUS Look What They’ve Done To My Song, Ma (2015)

Posted in Bach | Tagged , , , , , | 2 Comments

New GROUPBY and PIVOTBY functions

Posted on 14/01/2024 by dougaj4

Microsoft recently announced two new functions that provide similar functionality to pivot tables, but will update automatically for any change in the referenced data.

These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel.

I’m excited to announce Excel’s new GROUPBY and PIVOTBY functions. These functions allow you to perform data aggregations using a single formula. And while these functions are extremely powerful, they are also simple to get started with. In fact, you can do a data aggregation with just 3 arguments, the same number as a simple XLOOKUP. 

Note: These are preview functions, their signature and results may change substantially before final release based on user feedback. Until final, we do not recommend using them in important workbooks.

https://techcommunity.microsoft.com/t5/excel-blog/new-aggregation-functions-groupby-and-pivotby/ba-p/3965765

See the link above for more details and also the article below from myOnlineTraininghub. Both include full descriptions and examples of the new functions:

The GROUPBY and PIVOTBY functions are a significant breakthrough in Excel’s toolbox of functions.

They let you easily group or aggregate data, a concept that’s been around in Excel since the days of PivotTables in 1993 and Power Query since 2010.

But what’s exciting about GROUPBY and PIVOTBY is that they simplify this process down to a formula.

This means any changes to the source data are instantly updated in your reports, unlike PivotTables which require a click of the Refresh button to update.

But what about Slicers, which are one of the best features of PivotTables?

Don’t worry, I’ll share a clever trick so you can still use Slicers with GROUPBY and PIVOTBY

https://www.myonlinetraininghub.com/excel-groupby-and-pivotby-functions
Posted in Computing - general, Excel | Tagged , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 9 – Special, distance, space and constants functions and FFT

Posted on 08/01/2024 by dougaj4

In the final post in this series I will look at linking Excel to the Scipy special, distance, space and constants functions and also the Fast-Fourier Transform (FFT) functions.

The py_Special-Dist and py_FFT spreadsheet, with associated Python code in PythonSpaceFuncs3.py and pyScipy3.py, are included in the download file. There have been significant changes since the previous post, so download the latest version at:

py_SciPy.zip

Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll

For those installing a new copy of pyxll, a 10% discount on the first year’s fees is available using the coupon code “NEWTONEXCELBACH10”.

The coded Scipy documentation can be displayed in Excel, using the get_docs function:

The Scipy special functions are called with the py_CallfuncS function. The spreadsheet lists the 220 available functions with a description, and is set up to generate simple examples:

The Distance worksheet shows alternative methods to call the distance functions:

The Space worksheet has examples of the py_Delaunay, py_ConvexHull and py_Voronoi functions:

The Scipy constants return a range of physical constants, including definition of units, accessed with py_GetConst:

The NIST CODATA constants can be accessed with the py_GetCodata function:

The py_FFT spreadsheet has an example from the Scipy documentation, using the functions py_fft, py_fftfreq, and py_ifft:

The FFT results are also plotted using Matplotlib with the py_plot function:

More information on using Matplotlib with Excel can be found at:

Posted in AlgLib, Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , , , , | Leave a comment