Daily Download 30: Data Transfer, to and from VBA

Posted on 17/10/2012 by dougaj4

Today’s downloads cover procedures and functions for the transfer of data between VBA and the spreadsheet, and within VBA.

Array resources provides a variety of resources and web links covering the transfer of data on the spreadsheet to VBA arrays.
Download: http://www.interactiveds.com.au/software/getarray.zip

Transferring data within VBA discusses alternatives for transferring data between VBA routines.
Download: http://interactiveds.com.au/software/ByRefByVal1.xls

Calling a function as a variable describes how to call another function in VBA as a variable, rather than having the function name hard coded.
Download: http://interactiveds.com.au/software/PassFunc.xls

Getting the address of a selected range does what it says.
Download: http://www.interactiveds.com.au/software/RngAddress.xlsb

Finally Writing Arrays to the worksheet – VBA function provides an efficient VBA function to write data from VBA arrays to the worksheet, with several useful options.
Download: http://www.interactiveds.com.au/software/CopyToRange.xlsb

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged , , , , , , | Leave a comment

Daily Download 29: Using VBA – linking to C

Posted on 16/10/2012 by dougaj4

The final few days of the daily download series will be dealing with the use of VBA, starting with linking to C (and C++).  This was covered in:

Linking Excel to C
Linking Excel to C – 2
Linking Excel to C – 3; Avoiding bottlenecks

The download files are:

http://interactiveds.com.au/software/WalkThrough2.zip
http://interactiveds.com.au/software/Cubicdll.zip

Benchmark of cubic solution routines

Posted in Computing - general, Excel, Link to dll, UDFs, VBA | Tagged , , , , | Leave a comment

Daily Download 28: The Hole Through the Middle of the Earth, using ODE solvers, and Three Blokes

Posted on 16/10/2012 by dougaj4

Today’s download is based on a series of posts on the “hole through the middle of the Earth”, which by devious means has been tied in with the solution of differential equations, buckling of columns, and a story by Bill Baily about when not to offer to buy the first round.

Elegant solutions, Simple Harmonic Motion, and the hole through the middle of the Earth
Elegant solutions, Column buckling, and the hole through the middle of the Earth
More on buckling columns
The hole through the middle of the Earth – acceleration
The hole through the middle of the Earth – revised transit time 
The hole through the middle of the Earth – moved to the Equator
Three blokes go into a pub …
The hole through the middle of the Earth – filled with air

… and for anyone making it to the end and wondering where the next episode is, it hasn’t been written yet.

Here are the download files:

http://interactiveds.com.au/software/Earth%20Density.xls
http://interactiveds.com.au/software/ODESolver-Buckle.zip

And the “three blokes” joke:

Three blokes go into a bar

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Daily Download 27: Miscellaneous

Posted on 15/10/2012 by dougaj4

Just some bits and pieces that don’t really fit in anywhere else today:

Get your spreadsheet to talk to you at: Newton Excel Shakespeare
Download: http://www.interactiveds.com.au/software/Text2Speech.xlsb

Anniversaries gives you the tools to avoid missing significant anniversaries (and also to find the value of phi).
Download: http://interactiveds.com.au/software/Anniversaries.zip

Geometry for Joiners provides a spreadsheet solution to a geometric calculation that may or may not be very useful to joiners.
Download: http://www.interactiveds.com.au/software/FrameBrace.xlsb

Finally my annual statistics summary gives a list of all the posts here that other people have thought to be worth looking at:
http://interactiveds.com.au/software/Stats-year1.xls
http://interactiveds.com.au/software/Stats-year2.xls
http://interactiveds.com.au/software/Stats-year3.xls
http://interactiveds.com.au/software/Stats-year4.xls

Posted in Computing - general, Excel | Tagged , , , | Leave a comment

Daily Download 26: Moving averages and prime numbers

Posted on 13/10/2012 by dougaj4

Today’s downloads are the last of the maths related functions:

http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and

http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified limits, or check if a given number is prime or not.

For more details see:

Moving Average Function

MovAv Function

Finding Prime Numbers with Excel, and using Array Formulas

Prime Function

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment