I have attached the Excel Template that I have built. I also have attached the instruction for the contract.
Basically, I need to get statistics on the quality of the mobile phone number of my excel extract. I have already started the template excel, I would like someone to help me by completing 2 specific automation tasks in VBA.
1. create a macro that will pull the information from the RAW_TABLE and distribute the proper phone number under the proper city column of the NUMBER_BY_CITY table.
2. See highlighted section in yellow inside NUMBER_BY_CITY table. I need to get the count of red flag for each column.
a. I need to know how the count of many phone numbers are outside the confidence index that we can see for example at o4 and o3 for Abidjan. Note that there is a conditional formatting of o24: o2241 for the length of phone numbers. You can change it if you wish.
b. I need to the total per city and the global total.
c. In addition to show the number of red flag in the highlighted yellow section, the Result need to be brought under the COLUMN_PROFILE table because I will need to create a dashboard will the final result of each city in the end and their data quality issue.
3. Is there anything you can help with the Dashboard section? Getting some graphical visualization on the Phone Number quality per city and per country.
4. There is a library to help validate Phone Number use by Google. If you believe that it can help you. [login to view URL]
If you think you'll be able to return even more statistics than what's already there or if you could also help with the creation of some sort of dashboard, it would be even better. Or, if you believe you could even help with the cleaning of the data with some algorithms that would be really awesome.
27 freelancere byder i gennemsnit $60 på dette job
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hello, I have checked your xlsx and docx and I am very interested it. I can start work immediately. Looking forward to hearing from you. Best regards.
Hi, Im Technical Support from Malaysia. I can do the job based on your requirements. Please see my profile as below, https://www.freelancer.com/u/MunaSyahirah23?w=f Regards Muna