I am designing digital filters using a program called WinFilter. ([login to view URL]). This program provides output in C and VHDL code. For my purposes, I see two ways to do this:
1) The simplest is to only translate the attached C code to VBA and provide an Excel worksheet that can run this code on a data set.
2) Since this program can output various types of FIR and IIR lowpass, highpass, bandpass, etc. using the forms of Butterworth, Chebychev, and Bessel, I would prefer that the VBA be more adaptable and accommodate the various filter type outputs.
In general, for given type of filter, the calculation in C is the same, but will change with the number of coefficients based on filter order for an IIR filter or number of taps for a FIR filter.
What I would like is:
- Open the output .c file after running Calculate Filter in Winfilter and saving the C code.
- Excel VBA to match the output C code in the output file for the particular filter configuration
- VBA code would operate on a data set, i.e., (x,y) data on a worksheet sheet within the Excel workbook.
Before the VBA code is implemented across the possible filter types and configurations possible within Winfilter, I would like to set a milestone that one VBA translation is made to confirm that the C code is implemented correctly and the translated VBA code correctly process the input data.
Also, if anyone has another way to do what I need from within Excel and not using Winfilter, I will also entertain that as an option.
The C code is not very complicated. Several representative files are attached.
Please let me know if you have any suggestions.
Thanks,
Art
I have a master degree of mechatronics egineering. I have learn about the Digital Signal Processing, so in have much knowlegde about filters such as FIR, IIR... In addition, i am also very good at excel vba. Therefore, I can translate these C code into VBA, and if possible, I will program the filter only in excel based on the formula of each filter. In that case, we will not need to use Winfilter any more. Please hire me to do this job. Thanks
$123 USD in 10 days
0.0 (0 reviews)
0.0
0.0
7 freelancers are bidding on average $210 USD for this job
I am very proficient in c, c++. I have 15 years c++ developing experience now, and I have worked for 5 years. My work is online game developing, and mainly focus on server side, the lauguage is c++ under linux os. So, programming in c++ is never a problem. I used c++ to make many great projects, for example, I made the tools which can convert java files to c++ with the same meaning, of course garbage collection included. I made our own mobile game using c++, I even can show you the demo of client. Trust me, please let expert help you.
Hi, sir.
I'm interested in your job.
I can do this perfectly.
If you give me the chance to do this, I'll do my best and you will be satisfy.
I hope to discuss more detail and forward/
Thanks
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
Iplementing in VBA from scratch would basically be re-inventing the wheel. Your idea of taking the C output from the tool and converting it into a VBA a program is the way to go.
Here is how I would do it.
1. The VBA program would read the .c file.
2. By reading the header comments it would know Filter model and Filter order. It would also read the #define to determine the number of taps/coeffs. The filter order would be used to cross check the number of taps/coeff.
3. The filter model is the structure of the filter which in turn is reflected in the data structures. We therefore know what data structures to expect in the C code.
4. The code representing the actual operations does not have to be read from the file. Given the filter type, these are known opertaions. The VBA code will implement all the filter types as functions. The parameters would be the number of taps/coeffs, and the data structures read from the C file . The appropriate function will be selected by the Filter type read from the C file.
I welcome your comments/questions.
Hello,
I can write Excel VBA code that can automatically import filter coefficients from c file, define filter type (FIR or IIR) and calculate the output data column from input date column.
Regards,
Alexander