Re: Deriving Formula from Ordinal Regression Results to Classify New Cases?

Posted by David Marso on
URL: http://spssx-discussion.165.s1.nabble.com/Deriving-Formula-from-Ordinal-Regression-Results-to-Classify-New-Cases-tp5715848p5716046.html

A bit OT but I noticed you mentioned *way back* in the thread you were going to do this using VBA.
Before getting too committed to that approach I would suggest a gander at the VLOOKUP spreadsheet function in Excel and contemplate how it might be very handy for your implementation.  
Excel macros are great but can be a complete pain in the ass from a support perspective.  Many environments do not even allow vba code due to their 'viral' capabilities.  Also if your users have macros turned off by default you will likely receive countless support calls and emails from obnoxious higher management types ;-)
Also, after you finish would you kindly post your final solution for the benefit of others who might later have a similar query and for those who have provided assistance and might be interested in seeing it/using it?  Also be aware that some of us dinosaurs have ancient software and can't read xlsx format.