# About Newton Excel Bach

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

### Like this:

Like Loading...

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