Author Archives: dougaj4

ConbeamU update

Posted on 28/09/2021 by dougaj4

I recently discovered that the continuous beam function from the ConbeamU spreadsheet was giving incorrect results for cantilevers at the left hand end, if the cantilever had more than one segment and no point loads. The corrected version (Rel 4.16) … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , , , | 4 Comments

Fast Search Reminder

Posted on 30/08/2021 by dougaj4

A recent comment at Opening and searching pdf files from Excel reminded of the linked spreadsheet, which allows pdf files to be opened at a specified page from Excel, and also fast searches of the local hard drive: PdfLink.zip (free download … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 2 Comments

More on Numba

Posted on 15/08/2021 by dougaj4

Following my recent post Making Finite Element Analysis go faster … I have been having a closer look at the options in the Numba just-in-time compiler for improving the performance of Python code. The Numba docs include a series of short … Continue reading →

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

Concrete 2021

Posted on 29/07/2021 by dougaj4

Edit 12th August: Extended early-bird registrations are now finally closing tomorrow, Friday 13th August! Concrete 2021 (the 30th Biennial Conference of the Concrete Institute of Australia) is just around the corner, and this year will be all on-line: The virtual … Continue reading →

Posted in Concrete, Newton | Tagged , , | Leave a comment

Copying charts to a new workbook

Posted on 25/07/2021 by dougaj4

When an Excel worksheet including a chart(s) is copied to a new workbook the chart still links to the data ranges in the original workbook. Over the years I have spent a fair bit of time editing the chart ranges … Continue reading →

Posted in Charts, Charts, Excel | Tagged , , | Leave a comment