I've actually got the formulas up and running fine. It was fun getting them to work and not as complicated as all that (it's just transposing the arithmetic really - the brain work comes from the people who came up with the formulae!).
Right now, I'm just trying to figure out the best way to architect the application so that it's flexible, maintainable and expandable. Going OO seems like the best bet. I'm just wondering how to implement it so that it meets the above criteria. Sam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] CFC Cohesion Sam, You may want to take a look over at CFLib.org. Many of those formulas are already written up as UDFs, which are essentially just CFC methods. It may save you some time... -Rob "Sam Clement" <[EMAIL PROTECTED]>@cfczone.org on 11/09/2004 10:49:10 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> cc: Subject: RE: [CFCDev] CFC Cohesion Bingo. A lot of this is from a spreadsheet. Unfortunately, using the spreadsheet to power the app is not an option at the moment. The calculations are fairly standard financial calculations (as found in excel): Standard Deviation, Correlation Coefficient etc. Other than the interdependencies with some of the calculations I can't think of any other issues (at the moment). -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patrick McElhaney Sent: Tuesday, November 09, 2004 10:51 AM To: [EMAIL PROTECTED] Subject: Re: [CFCDev] CFC Cohesion This sounds like a spreadsheet. Are the formulas in spreadsheets now? Could they be? Could you work with the spreadsheets programatically, putting the input values in the appropriate cells and getting the output values out of the calculated cells? That way the formulas wouldn't be embedded in the code. You could change them easily. In fact, YOU wouldn't even have to worry about changing the formulas. Just let the business people edit the spreadsheets themselves. I did something like that a few years ago. I had no idea how the formulas worked. In fact the forumlas were developed in paralell to my front end code. Patrick -- Patrick McElhaney 704.560.9117 http://pmcelhaney.blogspot.com I still have 5 gmail invites. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
