I was provided with a number of equations that end in a couple of iterative summation equations. I am trying to convert those equations into DriveWorks and I am not sure the best method to complete this task.
I simplified the equations in this image. I was able to create a calculation table with the formulas to get to this point, my problem is the number of iterations. The typical values for y and x are 31 and 1280. This gives me a total iteration count of nearly 40,000. Ideally this solution would also be able to change the iteration count, but if that is not possible, I can work around it.
As I said, I could create the formulas necessary for the iterations in a calculation table, but to generate 40,000 isn't working. The program was starting to crash around 1,100 lines.
The values of a(h,k) and b(h,k) are affected by the inputs from my Form Design, so if there is a way to make this calculation work within DriveWorks that would be preferred.
I am new to DriveWorks, but have a bit of experience in Excel. Would there possibly be a way that I can link an external excel document to Control and Variable data in DriveWorks to generate the summation total and then have DriveWorks read that result to drive another variable?
The other possible solution I am considering trying is to use a calculation table to generate the first 25 iterations of the h summation equation and then create another calculation table for the next 25 iterations and so on and so forth until I have 50+ calculation tables. Then I can just add the last column of all of those calculation tables to generate my final formula. I don't know if this will run me into the same issue I am currently having with making a single calculation table or not since it would be broken up.
Could I possibly write a macro that could generate this result? I showed a simplified form of my equations, but in total there are around 12 equations that are being used to get the a and b formulas for the iterations.
Any insight would be greatly appreciated
