Doug's Maths Functions

Rating:
3

Description


Function IP: Finds the intersection points of two 2D lines or polylines;
Function IPLC: Finds the intersection points of a 2D line and a circle;
Function IPCC: Finds the intersection points of two circles;
Function IPSSS: finds the 3D intersection points of three spheres;
Function IPSS: finds the location and radius of the intersection circle of two spheres;
Function RtoP, PtoR: Converts rectangular to polar coordinates and polar to rectangular;
Function Rotate: Rotates 2D or 3D rectangular axes about any axis;
Function Interp, Interp2, Loginterp, Loginterp2, Quadinterp: One way and 2 way linear, log interpolation and quadratic interpolation.

Courtesy of Interactive Design Services Pty Ltd - a small civil engineering consultancy based in Sydney, Australia, specializing in analysis, design, review and technical advice related to bridges and soil interaction structures such as retaining walls and buried structures. The principal of the company, Doug Jenkins, has over 30 years experience in the design and construction of bridges, retaining walls, and buried arch structures.

Calculation Reference
Maths

Submitted On:
13 Feb 2009
File Size:
103.50 Kb
Downloads:
380
File Version:
1.0
File Author:
Doug Jenkins
File HomePage:
Click to visit site
Rating:
3

 
This location is for Registered Users Only.
Perhaps you need to login or register.
Be the first to commment on this file!
questio 10 years ago
Very very handy!
questio 10 years ago
Very very handy!
DougJenkins 11 years ago
David J York 2009-02-11 17:44:06 wrote "I only find one Macro in here and as far as exactly how to use it goes, maybe if you understand it and know where the other macros are you can post them as an addenda John".
You find all the functions but you need to look in the Visual basic editor from Excel's main menus select Tools>Macros>Visual Basic Editor. The code you're after can be found in modules named "mInterp" and "mIP". An Example of the use of each macro is included in the worksheets.
I hope this helps you find your way around.
djydave 11 years ago
I only find one Macro in here and as far as exactly how to use it goes, maybe if you understand it and know where the other macros are you can post them as an addenda John. ADMIN: see response follow forum link.
djydave 11 years ago
I only find one Macro in here and as far as exactly how to use it goes, maybe if you understand it and know where the other macros are you can post them as an addenda John. ADMIN: see response follow forum link.
JohnDoyle[Admin] 11 years ago
This is a very poweful set of macros included in this download plus three worsheets to show you exactly how they work. Well done Doug.
JohnDoyle[Admin] 11 years ago
This is a very poweful set of macros included in this download plus three worsheets to show you exactly how they work. Well done Doug.