Author Archives: dougaj4

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

Gravity Calling

Posted on 17/03/2009 by dougaj4

Flipron are a four-piece band that produce an otherworldly collision of bittersweet melody and vaudeville panache. At least that’s what it say’s here This YouTube clip features a video of the title track from thier latest album, Gravity Calling The … Continue reading →

Posted in Bach | Tagged , | Leave a comment