filter response (convolution)

[amrane]

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

[Paul_Hossler]

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

[amrane]

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

[Paul_Hossler]

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

[amrane]

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

[Paul_Hossler]

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

[amrane]

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,:think:

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

Br,
Amrane