-
You are correct, individually these can be solved just using the worksheet.
However, they are part of a much bigger project which will have several dozen columns (individual equations). These will relate back to a set list of inputs (some of which will have a minimum and maximum value with a specified increment value) and also forwards and backwards along these columns. Changing the maximum and minimum values and the increments of these inputs will change the number of outputs for some columns which will have a snowball effect on the entire worksheet (if set up correctly).
The final solution will depend on several of these equations, which will in turn bring all of the columns & inputs into play.
I have been able to set up equations that use the incremental values of inputs, but have been struggling to then use this list of outputs in the following equations.
The equation I originally sent is a generic equation, I was to then modify it by adding all of the other parts.
The code above works across the required columns, but the solution is rounded. As it sets everything to 'double' I was expecting a more accurate result, the exact solution ideally. Could you advise me on how to generate that in this case?
I have a code that brings inputs into an equation incrementally from specified minimum to maximum. My next aim is to incorporate that code with something similar to what you have provided, allowing for the previously calculated range of solutions to be inputted alongside an input that rises incrementally.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules