Category Archives: Excel

Another update to IP.xls

Posted on 07/04/2009 by dougaj4

Following some suggestions from Mike Seymour I have modified my polyline intersection function, and added a new version. The changes are: The data ranges for the new function, IP4(), are entered as four separate ranges, so the X and Y … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 1 Comment

Combining text files

Posted on 01/04/2009 by dougaj4

Updated 3 April 2009. Following Jimmy Pena’s comments I have revised the code to read and write the files in one operation, rather than line by line. I have also added the option to add a numbered separator line between … Continue reading →

Posted in Excel, VBA | 10 Comments

Frame Analysis with Excel – 6; Beam end releases and actions

Posted on 29/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 5; Large frames in Excel 2003 Download Frame3.zip – the download file includes complete open source code. The frame analysis spreadsheet presented previously has now been revised to deal with beam end releases (either rotation or translation) … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | 4 Comments

A Sort Function

Posted on 23/03/2009 by dougaj4

There is often a need to sort data within a VBA routine, but VBA does not have a built in sort function, so I recently had a look for what is on offer on the Internet. Chip Pearson has an … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 21 Comments

By Jingo

Posted on 18/03/2009 by dougaj4

Dick Kusleika at Daily-Dose-of-Excel recently posted a video of an animated bingo spreadsheet, using the Jing screen capture program. I had previously posted a still image of my Newton’s Cradle animation, which rather spoils the point, so here it is … Continue reading →

Posted in Animation, Excel, Newton, VBA | 1 Comment