Dears, I'm actually using the following code to calculte the favorability of a item. But I'm seeing that it's taking to much time to calculate and I do belive that I can do it better. So, Do you have any sugestion to calculate it in another way?
= ( ((((Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])) -(Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness]))))) + ((((Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])) -(Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations]))))) + ((((Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Overall experience])) -(Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience]))))) + ((((Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Slot availability])) -(Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability]))))) + ((((Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Workmanship])) -(Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship]))))) )
/
( ((((Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])) +(Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Neutral"}>} [ Embraer Owned Service Center Network AOG responsiveness]))))) + ((((Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Convenient locations])) +(Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Convenient locations])+Count({$<[ Embraer Owned Service Center Network Convenient locations] = {"Neutral"}>} [ Embraer Owned Service Center Network Convenient locations]))))) + ((((Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Satisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Overall experience])) +(Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Overall experience])+Count({$<[ Embraer Owned Service Center Network Overall experience] = {"Neutral"}>} [ Embraer Owned Service Center Network Overall experience]))))) + ((((Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Satisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Slot availability])) +(Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Slot availability])+Count({$<[ Embraer Owned Service Center Network Slot availability] = {"Neutral"}>} [ Embraer Owned Service Center Network Slot availability]))))) + ((((Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Satisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely satisfied"}>} [ Embraer Owned Service Center Network Workmanship])) +(Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Extremely unsatisfied"}>} [ Embraer Owned Service Center Network Workmanship])+Count({$<[ Embraer Owned Service Center Network Workmanship] = {"Neutral"}>} [ Embraer Owned Service Center Network Workmanship]))))) )
On a quick look I can advice you that set analysis can accomodate multiple conditions bringing down your code size. For example your first term
Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])+Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])
Can be replaced with
Count({$<[ Embraer Owned Service Center Network AOG responsiveness] = {"Satisfied","Extremely Satisfied"}>} [ Embraer Owned Service Center Network AOG responsiveness])
