+ Reply to Thread
Results 1 to 1 of 1

triple integral using Simpson's 1/3 rule - Problem with finding particular arrays

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    mauritius
    MS-Off Ver
    Excel 2010
    Posts
    15

    triple integral using Simpson's 1/3 rule - Problem with finding particular arrays

    Hello,

    I've recently been able to compute double integrals using Simpson's rule in Excel VBA for both the following types:

    1) ∫ ∫ eqn dydx x: between number and number; y: between number and number
    2) ∫ ∫ eqn dydx x: between number and number; y: between x and 2x (as an example)

    I'm trying to do the same with triple integrals using Simpson's rule in VBA.

    However I'm stuck in finding particular arrays for computation.

    It's difficult to explain. I've uploaded my excel vba file.

    The sheet 2(2) contains the triple integral example in spreadsheet only.

    The other sheets are just preparatory and not operational.

    The VBA code is entered in Cell I3 in sheet 2(2).

    The vba code will compute correctly all the arrays from M21 to AE53, that is, it got the answers for B24-27, B32-35, etc

    I'm computing using loops 1 to N and (variables + loop *step size (a+m*h))

    However i cannot find the other remaining arrays using this set up.

    Can anyone help please?

    Thanks

    PS: The beginning of the code from "h2 = (f - e) / n" to "Next
    Next"

    is the tryout. The part that is ok and correct is below.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simpson's rule in Excel
    By James Silverton in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-20-2015, 10:43 PM
  2. [SOLVED] triple conditional formatting, involving dates and blanks, can't figure out the problem
    By Severine72 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2015, 01:57 AM
  3. Optimization Problem with integral
    By clodilsognatore in forum Excel General
    Replies: 2
    Last Post: 10-02-2014, 12:29 AM
  4. Simpson's rule for integration
    By johnboy12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 08:24 PM
  5. Replies: 2
    Last Post: 02-23-2014, 01:18 PM
  6. Writing an Integral Midpoint,Trapezoidal,Simpson Rule
    By roumieh2000 in forum Excel General
    Replies: 3
    Last Post: 07-09-2013, 11:03 AM
  7. Finding the Maximum Row based on a non duplicate rule
    By beat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2013, 06:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1