Excel and Applescript
Dunno if this is possible, but thought I'd ask...
I have a bunch of equations set up in excel, and I want to replace the value of one of the cells incrementally from 0 to 7 by .1 at a time, then have a list of all the corresponding values from another cell. is this possible within the app or with applescript? i really dont wanna plug in all the numbers manually...
I have a bunch of equations set up in excel, and I want to replace the value of one of the cells incrementally from 0 to 7 by .1 at a time, then have a list of all the corresponding values from another cell. is this possible within the app or with applescript? i really dont wanna plug in all the numbers manually...
Comments
Originally posted by ipodandimac
Dunno if this is possible, but thought I'd ask...
I have a bunch of equations set up in excel, and I want to replace the value of one of the cells incrementally from 0 to 7 by .1 at a time, then have a list of all the corresponding values from another cell. is this possible within the app or with applescript? i really dont wanna plug in all the numbers manually...
Figured it out. FYI, there is a tool in Excel called 'Solver' that really kicks ass. You can customize all kinds of parameters and then make Excel figure out the best values for defined cells based on these. So, back to homework...