Category Archives: Excel

Drawing in Excel 9 – Perspective Projection

Posted on 13/01/2009 by dougaj4

Previous post  Download PlotXYZ-xlsb.zip (XL 2007) Download PlotXYZ-xls.zip (XL 2003 and earlier) The drawing program presented in the previous post in this series has been modified to plot perspective projections of line drawings defined by 3D coordinates of line end points, … Continue reading →

Posted in Drawing, Excel, VBA | 3 Comments

Excel 2007 performance – Microsoft looking for feedback

Posted on 08/01/2009 by dougaj4

The latest post on the Microsoft Excel Blog is asking for comment on slow performance of Excel 2007, specifically related to VBA: Microsoft Excel Blog I encourage everyone to respond!

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

Drawing in Excel 8 – scaling and trimming

Posted on 05/01/2009 by dougaj4

Previous Post – Drawing in Excel 7 Download PlotXY-xls.zip (XL 2003 and earlier) Download PlotXY-xlsb.zip (XL 2007) The previous post presented VBA routines to plot drawings in Excel from a series of coordinates, a list of connected points, and a … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , , | 3 Comments

Significant Figures

Posted on 28/12/2008 by dougaj4

Excel does not provide any built in functions to round values to a specified number of significant figures.  The UDF below, recently posted at the Eng-Tips forum, will do the job: Public Function sigfig(my_num, digits) As Double Dim num_places As Integer … Continue reading →

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

Anniversaries

Posted on 27/12/2008 by dougaj4

It has just come to my notice that this year I missed my half millionth Birthhour, which was also my 30 millionth Birthminute. Luckily I still have plenty of time to prepare for my 2 billionth Birthsecond. To avoid missing … Continue reading →

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