Tag Archives: Excel

Composite Beam Spreadsheet

Posted on 22/04/2012 by dougaj4

As promised in the previous post, a spreadsheet for designing reinforced or prestressed concrete composite beams has now been uploaded to my web site.  It can be downloaded from: Composite Design Functions-GS.zip .  As usual, the spreadsheet includes full open-source code. … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments

Geometry for Joiners

Posted on 03/04/2012 by dougaj4

A question came up on the ABC Self-Service-Science Forum, asking for a solution to find the dimensions of a diagonal brace looking like the diagram below: The solution is not as simple as it might look because the angle of … Continue reading →

Posted in Coordinate Geometry, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Writing Arrays to the worksheet – VBA function

Posted on 12/03/2012 by dougaj4

Previous posts have looked at the VBA code for efficiently writing a VBA array to the spreadsheet as quickly as possible, most recently here. I have now put this code in a function that can be conveniently called from any … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , | 17 Comments

Getting the address of a selected range

Posted on 01/03/2012 by dougaj4

The Excel Indirect() function allows other functions to use the text in a worksheet cell to define a range, rather than selecting the range, or entering it directly into the function. For instance, if cell A1 contained the text B1:B10, … Continue reading →

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

Newton Excel Shakespeare

Posted on 27/02/2012 by dougaj4

Another excellent link from Al Vachris: Bruce McPherson’s Site This site is all about how to free your Excel data from your desktop and take advantage of web capabilities such as Docs, Maps, Earth , Gadgets, Visualizations and a whole … Continue reading →

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