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

16 Responses to About Newton Excel Bach

  1. Dombi Eugen Dorel says:

    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

    Like

  2. dougaj4 says:

    Dombi – thanks for your comments.

    I have left a reply in the thead you linked to.

    Like

  3. Dombi Eugen Dorel says:

    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 …

    Like

  4. João Paulo Azevedo says:

    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.

    Like

  5. dougaj4 says:

    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

    Like

  6. nkilic says:

    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

    Like

  7. Beatrix says:

    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

    Like

  8. dougaj4 says:

    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

    Like

  9. dc says:

    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.

    Like

  10. You should consider adding Ron DeBruin’s web page to you list.
    Happy New Year!
    Regards
    Alfred

    Like

  11. superbob3x says:

    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

    Like

  12. Napster says:

    …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..

    Like

  13. cabecker says:

    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!

    Like

  14. 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!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s