Consulting

Results 1 to 7 of 7

Thread: filter response (convolution)

  1. #1
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location

    filter response (convolution)

    Dear Sir,

    I am looking for for an estimation of the result of "inupt(x)" convolution "H(x)" (H(x) is the filter response,...

    so far I failed to find and unless the page "http://www.chacocanyon.com/smm/sessions/session04.shtml", but unfortunately after downloading the add-in xlam file "ssm", It was not working!!

    so please let me know if its possible to develops this calculation under excel2010,

    Thank you sir in advance for your support,
    Br,
    Amrane
    Attached Files Attached Files

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,730
    Location
    I commented out a test that seemed backwards

    Just remove the .zip, it's NOT really zipped, merely renamed

    '6/27/2015 - Hossler
    Private Sub Workbook_AddinInstall()
        Call Workbook_Open
    End Sub
    Private Sub Workbook_Open()
        Dim menuBar As CommandBar, i As Integer
    '6/27/2015 - Hossler
    '    If CDbl(Application.Version) >= 12 And Left$(Application.OperatingSystem, 3) <> "Mac" Then Exit Sub
        If CDbl(Application.Version) < 12 Then Exit Sub
        '1 and 2 are the Worksheet Menu Bar and the Chart Menu Bar
        MenuName = ThisWorkbook.Worksheets("Commands").Range("MenuName")
        For i = 1 To 2
            Set menuBar = Application.CommandBars(i)
            If IsAControl(MenuName, menuBar.Controls) Then menuBar.Controls(MenuName).Delete
            BuildMenu menuBar
            'InstallShortcuts
        Next i
        BigWorksheet = True
    End Sub
    Attached Images Attached Images
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location
    Dear Mr PAUL

    Thank you so much for your feedback,
    I added the output signal as per the third column in "response calculation_r2", So Is it correct application of this macro?

    Thank you sir, for your help,

    Amrane
    Attached Files Attached Files

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,730
    Location
    I just fixed the smm.xlam a little using the code in the post - did not add any columns

    Save the file, rename it smm.xlam and add it via Options, Add Ins
    Attached Images Attached Images
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location
    Dear Mr Paul_Hossler

    thank you sir for your remark,

    so looking for the forum to support to elaborate convolution solution under excel

    Br,
    Amrane

  6. #6
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,730
    Location
    Taking another guess, I extracted the macro from the SMM addin and put it into a separate workbook as a function called for each Input and (x)

    I DO NOT KNOW what the 'convolution' is so I only was looking at it from VBA

    If you provide more information, it might help
    Attached Images Attached Images
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  7. #7
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location
    Dear Mr Paul_Hossler

    thank you sir for your support, in the attached file, there is some explanation for the convolution(time domain),based on this rules I added third sheet, its just an idea which need to be commented by forum !!

    so the how to establish dynamic convolution matrix, make calculation ,... get result,

    the below page is the original of the xls workbook:
    http://electron6.phys.utk.edu/animsp...transforms.htm

    Br,
    Amrane
    Attached Files Attached Files

Posting Permissions

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