Predicting the complexity of a project based on a set of rules- Power Query/VBA/Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2339814%22%20slang%3D%22en-US%22%3EPredicting%20the%20complexity%20of%20a%20project%20based%20on%20a%20set%20of%20rules-%20Power%20Query%2FVBA%2FMacro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20All%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EHope%20you%20are%20doing%20well!...I%20am%20trying%20to%20predict%20the%20complexity%20of%20a%20project%20based%20on%20a%20set%20of%20questions%20(with%20each%20question%20having%20a%20drop%20down%20of%20anwers)-Column%20C(Please%20input%20your%20understanding)%20has%20the%20list%20of%20option%20to%20be%20chosen%20for%20each%20question..Based%20on%20the%20value%20chosen%20-the%20value%20to%20be%20assigned%20it%20can%20be%20taken%20from%20the%20Column%20E%20(notes%20column)%20and%20the%20value%20taken%20from%20the%20column%20E%20should%20be%20multiplied%20with%20value%20from%20Column%20D%20and%20finally%20all%20the%20values%20should%20be%20added%20to%20get%20the%20final%20score%20based%20on%20which%20the%20recommendation%20should%20pop%20up%20as%20a%20dialog%20box%20based%20on%20the%20guildelines%20on%20the%20output%20sheet%20in%20the%20second%20tab%20...The%20recommendation%20should%20come%20up%20as%20a%20dialog%20box%20on%20the%20input%20sheet%20after%20the%20user%20has%20clicked%20through%20all%20the%20options%20in%20the%20input%20sheet...%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ECan%20you%20please%20help%20me%20here...Attached%20the%20file!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EArun%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2339814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi All,

Hope you are doing well!...I am trying to predict the complexity of a project based on a set of questions (with each question having a drop down of anwers)-Column C(Please input your understanding) has the list of option to be chosen for each question..Based on the value chosen -the value to be assigned it can be taken from the Column E (notes column) and the value taken from the column E should be multiplied with value from Column D and finally all the values should be added to get the final score based on which the recommendation should pop up as a dialog box based on the guildelines on the output sheet in the second tab ...The recommendation should come up as a dialog box on the input sheet after the user has clicked through all the options in the input sheet...
Can you please help me here...Attached the file!


Thanks,
Arun

0 Replies