Newton Excel Bach is aimed at people who work with numbers without a $ on the front. Posts will alternate between Excel and engineering/science topics, with the occasional post related to neither when I feel like it.
Contact e-mail: dougjenkins@interactiveds.com.au
About Interactive Design Services
Interactive Design Services is a Sydney based structural design consultancy specialising in the analysis, design and review of bridges, buried structures, retaining walls and related civil engineering structures.
More details may be found at: Interactive Design Services
Newton Excel Bach, not (just) an Excel Blog 
A good day ; I want to say that what is here is the produce of a shinely mind .
I have a very big need of your help ! … I try to get
the solution for an UDF which work in array ; how can I contact you , if you allow me ?
Please very much for help , I have a very big need to have this UDF , and it seems nobody can give me the right solution anymore ;
I put here a link where is described all my problem :
http://groups.google.ro/group/microsoft.public.excel.programming/browse_thread/thread/b87e18a67d2676f/c41b3aeaa334974e?hl=ro&lnk=gst&q=UDF#c41b3aeaa334974e
The thread have name UDF …VBA Formula built …please help , username ytayta555 ;
Thank you very much , and I wait impatient your big help for me .
Respectfully
LikeLike
Dombi – thanks for your comments.
I have left a reply in the thead you linked to.
LikeLike
I didn’t expect to get response from a great personality like you , mr. Doug Jankins , I’m
really surprised . Great atitude …
Now , my problem is solved 98% ; I hope
and please you to help me and to resolve the
last part of 2% . Really , I just wonder what can
I do to can do for you what you just done
fore me .
What a benefit for humanity to have so shinely
and creative minds …
LikeLike
Hi
First of all, thanks for putting this info on, and sharing it.
It is of great quality.
Second, I would like help on using intersection, maybe you could spare me some time, if you can give me a brief overview of the module.
I am a soccer coach, and I’m trying to make some tools in office to analyze the Systems of play, to calculate the number of lines of passes for example, and for that I would need to use an intersection functionality, don’t need to know where is the intersection exactly, but to know how many there are.
Third I made code to calculate the length of a line, and an absolute angle in 0-360 using only left, top, width and height.
For what I can see on your blog mycode is really humble, but if you think that is useful for you or anyone else I would share it gladly.
LikeLike
Hi João – I’m not exactly sure how your line of passes system would work at the moment, but if you would like to send some sketches and/or worksheets to my Gmail account (Dougaj4 at the usual gmail) I will have a look at them when I have time (pretty busy at the moment, so it may not be straight away). I’d be interested to see your line length code as well if you would like to send it.
Thanks for the kind comments.
Doug
LikeLike
Dear Mr Jenkins,
We identified your site as one of the leading information sources on the Internet about Microsoft Excel software. We would like to take this opportunity to introduce you our site, SpreadsheetZONE.
SpreadsheetZONE, a content partner of Microsoft Office Online, is a growing repository of free online Microsoft Excel templates available for everyone for personal or business usage. Most of the templates are developed by SpreadsheetZONE Team, in various categories including finance, sales, education, and project management. Our library grows everyday as new templates are published, and number of our users keeps increasing.
Please visit our site at http://www.spreadsheetzone.com and let us know what you think. We always welcome suggestions from Excel community to improve our site and services.
Thank you,
SpreadsheetZONE Team
LikeLike
HiFirst of all, thanks for putting this info on, and sharing it.It is of great quality.Second, I would like help on using intersection, maybe you could spare me some time, if you can give me a brief overview of the module.I am a soccer coach, and I’m trying to make some tools in office to analyze the Systems of play, to calculate the number of lines of passes for example, and for that I would need to use an intersection functionality, don’t need to know where is the intersection exactly, but to know how many there are.Third I made code to calculate the length of a line, and an absolute angle in 0-360 using only left, top, width and height.For what I can see on your blog mycode is really humble, but if you think that is useful for you or anyone else I would share it gladly.
+1
LikeLike
Hi Beatrix – thanks for the comments.
Could you provide a bit more detail about what you are wanting to do with the intersection calculation, and what data you are working with? There is a spreadsheet on the blog that calculates intersections of lines and/or circles (IP.xls) which may help, but assuming you are wanting to calculate if a moving ball will intersect the path of a moving player it may not be so straightforward.
I’d be interested to see your code. If you would like to e-mail to dougaj4@gmail.com I will have a look.
Doug
LikeLike
I’m a civil engineer in the states and a programming enthusiast. Have you ever thought about setting up a repository for user-submitted code, feedback, or requests?
I’m sure a collection of your readers would be interested in the challenge, including myself.
LikeLike
Good idea!
I’ll set up a separate page for readers programs and ask for submissions when it is ready.
LikeLike
http://www.rondebruin.nl/tips.htm
Happy New Year!
Regards
Alfred
LikeLike
You should consider adding Ron DeBruin’s web page to you list.
Happy New Year!
Regards
Alfred
LikeLike
Hi Doug,
Excellent job on the blog. I find it really helpful and educative, I can learn a lot here. FYI, I also work at engineering consultant specializing in civil engineering works such as structural assessment and design of buildings, bridges, etc. It is based in Jakarta, Indonesia.
When i have free time, i sometime try to make a useful spreadsheet such as beam/column/others design (according to Indonesian building code), ETABS/SAP output processor, etc. Currently I am working on Bill of Quantity spreadsheet to calculate material quantity (concrete and steel) with a good precision (detail calculation) to be used in Value Engineering works.
Unfortunately i have limited knowledge on VBA programming so i keep stumbling on a problem from time to time. Hopefully i can “steal” your time once in a while to discuss about it.
I like this blog and i’ll be glad to take an active role here. I’d gladly share my knowledge and my spreadsheets if it can be of any help here.
Regards
Bob
LikeLike
…this blog helped me develop my skills in VBA in relation to structural engineering, big thanks to mr. Jenkins.. I am also a programming enthusiast here in the Philippines and I was hoping to find a company who gives interest with this kind of trade..
LikeLike
Thank you for taking the time and energy to release this very high quality information. I really enjoy reading your posts and following along. Your code is as previously mentioned is of very high quality. Your comment sections are simply lovely. Very bright and intelligent spot on comments. As someone stated previously Shiny!
LikeLike
Doug – Great blog with tons of interesting info. Thanks for posting regularly. Excel is a great tool for most “day-to-day” math and your blog provides several useful aspects. All the best!
LikeLike
Doug, you have a lot of great information here. I was wondering under what terms you release your excel sheets and scripts? I am working on a column designer web app / side project of mine, and I would like to use some of your PM interaction code as reference when I write the backend algorithms. It will be server side (not publicly visible) and in a different language (go vs VBA). Would this be an acceptable use to you? Best Regards.
LikeLike
Jeremy – Most of the spreadsheets have an “about” page with a licence and disclaimer statement. In summary this says you can use the code as you wish, but it comes with absolutely no warranty.
LikeLike
Hi Doug, thanks for your amazing blog and the wealth of knowledge you share in your blog. I am a civil engineer from Singapore, and I’ll be starting work in the Melbourne Metro Tunnel Project (MTP) this August 2018. I do write some VBA codes and functions to help me with my work too. One Excel VBA function which I completed some time ago, which I found to be quite a challenge to create, was a “ReturnFindAddress” function, which would return (either as a string or an array) the cell addresses of the search results of a specified search string which I supply to the function.
Anyway I just wanted to say Hi, and let you know that I appreciate your blog as it lets me know what is possible in Excel, especially in engineering applications. Cheers and have a good day!
LikeLike
Thanks Jay,
I hope all goes well in Melbourne!
LikeLike
Hello Doug,
Hope you are well. Noticed your replies about VBA and Python on Quora. Do you provide consulting? We have an Excel file that is taking a several seconds to compute, which creates a poor user experience. We have developed a lean Python script using Numpy, but we are having issues running the script in Excel (the Python pluggin is difficult to install). Could we have a call? Hope you can help.
Best,
Daniel
P.S. – Here is our company website: https://www.energystorageconsultants.com
LikeLike
Is the file Vincenty.xlsb available for download? The link does not work.
LikeLike
What happens when you click on the link?
The file downloads for me, but I have converted it to a zip to see if that helps.
Please let me know if that works, and if not if you get any error message.
LikeLike
Doug:
When I clicked the link, the link address flashed in the lower left corner of the window, but nothing else happened.
LikeLike
Doug:
The link address began with interactive….. I copied the link address and added https:// in front of the interactive e.g. https://interactive….. and the file downloaded. Thank you for your help.
LikeLike
David – it seems that when I have been copy and pasting links to my downloads the link has pasted as http:// … (and displays as just the text following the //). I have now edited the Vincenty link to https:// which now displays in full.
Could you let me know if the link now works as intended for you (i.e. without having to copy and paste)? Thanks again for your feedback.
LikeLike
I would like to use the softwares wich comes in the Foundation Analysis and Design book from Joseph Bowles.
I have the exe files but it is impossible to run them in an 64bit I7 PC. They´ve been wrinter in Fortran language.
Can anyone help me ?
Thank you in ad vance
LikeLike
There are a few options, but are you sure the exe file doesn’t work? If you open a command window you should be able run the programs just like on the old PCs they were written for. See https://www.wikihow.com/Use-CMD-(Beginner) for some tips on using cmd, if you are not familiar with it.
You should also be able to work with the source code and either convert it into VBA, or compile it as a dll which you can call from VBA or Python to link to Excel. Obviously there is a lot more coding to do that, but it can make a much more useable application.
To get started look for Fortran in the Categories drop-down in the right hand margin, and that will link to quite a few different articles here with different approaches.
LikeLike