Completed

VBA - Excel - Mobile Phone Number Data Quality and macro -> EASY contract!

Good day,

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.

TABLE NAME

• RAW_TABLE

• DASHBOARD

• COLUMN_PROFILE

• NUMBER_BY_CITY

Instruction TASK

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.

Skills: Excel, Visual Basic, Data Processing, Data Cleansing, Software Architecture

See more: excel vba templates, how to automate excel reports using macros, excel vba automation examples, vba analysis for excel, excel macro examples xls, excel vba sample projects download, excel macros for data analysis, excel vba report example, web mobile phone number, mobile phone number database, mobile phone number, gps mobile phone number, mobile phone number hiding software, find mobile phone number, mobile phone number list, mobile phone numbers data base, usa mobile phone number database, mobile phone number tracker, phone mobile phone number, example mobile phone number united states

About the Employer:
( 33 reviews ) Verdun, Canada

Project ID: #22275483

Awarded to:

fastwork86

Hi, I am Sumit Choudhary. I saw your requirement for an excel vba expert. I have done many projects in excel. Can send you sample if needed. I have an MBA and have extensive experience in tutoring students in Economi More

$30 USD in 1 day
(1 Review)
1.0

27 freelancers are bidding on average $60 for this job

TonmoyRoy111

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

$30 USD in 1 day
(348 Reviews)
6.9
sky19130

Hello sir. High-quality & Fast-delivery is promised! As a highly skilled full stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my best. My cli More

$1000 USD in 7 days
(8 Reviews)
4.9
Alexsfodik

Hello. How are you. I read your description carefully. I need some question to complete your project. I'm software engineer and algorithm expert. I have many experiences in Access, Excel, VBA. I can complete your proje More

$55 USD in 2 days
(6 Reviews)
4.4
paulodayto08

Hi Good Day! A serious freelancer here. I can help you to complete this project. I saw your file and study the instruction. I can make it automated thru the combination of Excel Formulas and VBA Macro. Please conside More

$25 USD in 1 day
(36 Reviews)
4.5
Baibsma

HI I CAN PROVIDE YOU CANADA MOBILE 5 MILLION NUMBERS WITH FULL DETAIL AS YOU NEEDED CHARGE YOU 250 CAD WE DISCUSS MORE WITH SAMPLE THANKS

$20 USD in 7 days
(7 Reviews)
4.2
ShengJieGuo

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.

$20 USD in 7 days
(5 Reviews)
3.5
Prompty

Hi, i am excel experienced freelancer. With more clarity of information, i can do this neat work for you

$40 USD in 5 days
(4 Reviews)
2.0
TopWritingGuru

Howdy, Hello... I am a professional data entry operator with 12 years of working experience. I can deliver you result within your given time with 100% ERROR FREE and HIGH QUALITY WORK. I can do data entry, Data mining, More

$10 USD in 1 day
(1 Review)
1.2
isratanonti

Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many p More

$10 USD in 7 days
(0 Reviews)
0.0
Aditya1075

Thank you for Providing us bidding opportunity. I have understand your project and will like to work on this It Would be pleasure if you would provide us the opportunity to serve you. I am committed in Time and qual More

$20 USD in 7 days
(1 Review)
0.0
MrLOGANsmart

I will do your assign task with maximizing the efficiency and fully satisfying you with my work.I have more than 2 years experience in Data Entry professional.I am new to this website I will do my work with minimum co More

$10 USD in 3 days
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
MunaSyahirah23

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

$20 USD in 7 days
(0 Reviews)
0.0
Lajand112

We are the best for this project ,we deliver according to your specifications, just give us a trial and you won't regret doing thanks Relevant Skills and Experience Please link in on our bio from our profile for alrea More

$66 USD in 7 days
(0 Reviews)
0.0
SupremeWriters

Hello, Hello, I am an excel expert and I am able to manage bulk data entry within your given deadline. I can manage data entry, Data processing, Internet research, Data mining, data scraping, etc. My ability to accurat More

$10 USD in 1 day
(0 Reviews)
0.0
websiteappdev

Hello, I have 10 years of experience in Mobile Application Development. I am a Web Professionals including Design, Programing, QA, SEO experts along with highly qualified and experienced skills. Android apps: https:// More

$20 USD in 7 days
(0 Reviews)
0.0
ITSolution24x7

I Will Be Your ⭐⭐Virtual Assistant⭐⭐VBA - Excel - Mobile Phone Number Data Quality and macro -> EASY contract! ⭐No advance payment. ⭐Pay once project completed If there's something I did not mention that you need, More

$30 USD in 1 day
(1 Review)
0.0
mintuchhina

hello ,please give me chance to work with you.i can do it in 7 days with a affordable price.i'm a hardworking small cafe woner

$20 USD in 7 days
(0 Reviews)
0.0
priyasuthanpp

Hi, I'm very much interested in your project. I'm very good in Excel and I've all the abilities and experience as per your requirements. I can finish this project in minimum time for you. I'm very glad if you offer me More

$10 USD in 1 day
(0 Reviews)
0.0
putrisriutami

i will do the best

$25 USD in 1 day
(0 Reviews)
0.0