Excel Scoring Algorithm Creation

I'm in need of an expert in complex excel functions to develop a specific formula to calculate scores based on varying variables. The formula should be able to handle one to eight variables flexibly. Key Aspects: 1. Calculate Percentile, Ranking, and Decile for a set of values (~210 rows) for 15 columns with different data range 2. **Weightage Assignment**: The function you create should accommodate user-defined weightage for each variable. This means I should be able to manually assign a weightage value for each variable that the score depends on, with the sum totaling up to 100. 3. **Score Calculation**: The score will be determined by three core values: Percentile, Ranking, and Decile. The usage of these values should hinge on specific conditions rather than their mean or weighted average. 4. **Conditions for Calculation**: The conditions for score calculation will depend on the behaviors of certain variables in the dataset. These conditions are for specific columns and will be further explained once the project starts. Ideal Skills and Experience: - Expert knowledge of advanced Excel functions - Experience with statistical data analysis and scoring systems - Strong attention to detail - Ability to interpret complex requirements NOTE Apply if you have the ability to tackle demanding Excel projects and create intricate algorithms in an efficient manner.