Tag Archives: Excel

Daniel’s XL Toolbox

Posted on 25/11/2009 by dougaj4

I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a full description. I’ve only had a brief look, but … Continue reading →

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

Some New Links

Posted on 09/11/2009 by dougaj4

A couple of return links to sites that have been sending traffic my way, and are well worth a look: AJP Excel Information (Andy Pope’s site): “The intention of this site is to be a useful resource of alternative solutions … Continue reading →

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

Chart Trend Lines and the Linest Function

Posted on 03/11/2009 by dougaj4

At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading →

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

Reinforced Concrete Section Analysis – with prestress

Posted on 25/10/2009 by dougaj4

The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement.  The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading →

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

Copy and Paste as Picture

Posted on 18/10/2009 by dougaj4

If in Excel 2007 you copy a range to the clipboard and paste into Word as a picture you get the worksheet gridlines displayed, which may well not be what you want. This issue was raised at Smurf on Spreadsheets and … Continue reading →

Posted in Excel | Tagged , , | 10 Comments