Excel Automation & data analysis of Foreign Exchange currencies
Budget: ₹600 – ₹1,500 INR
I need someone to develop a VBA/Macro code to automate certain activities on an excel sheet so that I can get the excel sheet in the proper format without manually entering formulas.
The functions to be automated are:
1. Deleting all rows other than RIC, Period, Release / Effective Date, Country, Prior, Median, Highest
Lowest, No. of Forecasts.
2. Adding formulas in Median (=Median), Highest (=Max), Lowest (=Min), No. of Forecasts (=count) for ranges in each column.
4. Detecting outliers based on historical variance across each column and highlighting them yellow.
5. Deleting contributors with no forecasts for any RIC.
6. Formatting Row 23 & 24 so that Organization/Question is on the same level as Sentix Index*, Employment Final QQ, Employment Final YY...
7. Median row should be font 12, bold & in orange.
8. Formatting comments section
9. Additionally, coming up with an advanced analysis of Foreign Exchange currency dataset so that it can be automated and used in practise.
The functions to be automated are:
1. Deleting all rows other than RIC, Period, Release / Effective Date, Country, Prior, Median, Highest
Lowest, No. of Forecasts.
2. Adding formulas in Median (=Median), Highest (=Max), Lowest (=Min), No. of Forecasts (=count) for ranges in each column.
4. Detecting outliers based on historical variance across each column and highlighting them yellow.
5. Deleting contributors with no forecasts for any RIC.
6. Formatting Row 23 & 24 so that Organization/Question is on the same level as Sentix Index*, Employment Final QQ, Employment Final YY...
7. Median row should be font 12, bold & in orange.
8. Formatting comments section
9. Additionally, coming up with an advanced analysis of Foreign Exchange currency dataset so that it can be automated and used in practise.