Recent Comments
Author Archives: dougaj4
Planxty and Little Musgrave
Planxty are one of my favourite groups form the early 70’s, consisting of Christy Moore (vocals, acoustic guitar, bodhrán), Andy Irvine (vocals, mandolin, mandola, bouzouki, hurdy-gurdy, harmonica), Dónal Lunny (bouzouki, guitars), and Liam O’Flynn (uilleann pipes, tin whistle), all … Continue reading
Linking to Python with Excel-Python, and Python matrix functions
I have been experimenting for a few weeks with a new package linking Excel to Python, by the name of ExcelPython. Here is what the author says about it: “ExcelPython is a lightweight, easily distributable library for interfacing Excel and … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Maths, Matrix Functions, Python, Simultaneous equations, sparse matrix solvers, UDF, VBA
5 Comments
Dividing shapes into layers
For reasons that will become apparent in a later post, I need to rotate irregular polygons, defined by the coordinates of each corner, by a specified angle, and then split the resulting shape into horizontal trapezoidal layers. I have written … Continue reading
Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged divide shape into layers, Excel, rotate coordinates, section properties, UDF, VBA
8 Comments
Getting help in 2013
Getting help in Excel 2013 takes you by default to the Microsoft on-line help files, which is not only much slower than connecting to a local file, when you get there finding what you want is even slower. From the … Continue reading
Posted in Excel, VBA
Tagged 2013, Excel, Help, install local help, on-line help, VBA
Leave a comment
Displaying range names
A useful tip, brought to you from Bob Umlas, via Mike Alexander: If you want to display the named ranges in a spreadsheet, one way is to open the Name Manager (from the Formulas ribbon). Another is to press F3, … Continue reading
