Tag Archives: Excel

Baby Names and Pivot Tables

Posted on 17/05/2015 by dougaj4

Baby Boom: An Excel Tutorial on Analyzing Large Data Sets is a comprehensive (and free) tutorial looking at analysing public databases of baby names, using Excel: There are professional data analysts out there who tackle “big data” with complex software, … Continue reading →

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

Time to Lookup

Posted on 27/04/2015 by dougaj4

At Daily Dose of Excel Jeff Weir has been looking at alternative methods of applying the VLookup function and ways of getting precise timing of the different formulations. Based on his posts there I have written two Lookup User Defined … Continue reading →

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

Re-sizing Array Functions

Posted on 14/04/2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

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

ConbeamU Update Update

Posted on 13/04/2015 by dougaj4

Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one.  The new version number is … Continue reading →

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

ConbeamU Update; defined support deflections

Posted on 03/04/2015 by dougaj4

As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , , | 12 Comments