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

Befejezett Kiadva: 4 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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.

Excel Visual Basic Adatfeldolgozás Data Cleansing Szoftverarchitektúra

Projektazonosító: #22275483

A projektről

24 ajánlat Távolról teljesíthető projekt Utoljára aktív: 4 évvel ezelőtt

Odaítélve:

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 Továbbiak

$30 USD 1 napon belül
(3 értékelés)
3.8

24 szabadúszó tett átlagosan 64$ összegű árajánlatot erre a munkára

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 1 napon belül
(510 vélemény)
7.8
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 Továbbiak

$25 USD 1 napon belül
(82 vélemény)
5.5
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, Továbbiak

$30 USD 1 napon belül
(3 vélemény)
5.0
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 Továbbiak

$1000 USD 7 napon belül
(8 vélemény)
4.9
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 7 napon belül
(9 vélemény)
5.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 Továbbiak

$10 USD 1 napon belül
(1 Visszajelzés)
2.2
Prompty

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

$40 USD 5 napon belül
(6 vélemény)
2.3
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, Továbbiak

$10 USD 1 napon belül
(1 Visszajelzés)
1.2
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 7 napon belül
(1 Visszajelzés)
0.4
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 Továbbiak

$10 USD 7 napon belül
(0 vélemény)
0.0
varuntec3

I have a really good typing skills as mentioned in my profile 32wpm 90% accuracy I assure u the project will be delivered within 1day

$20 USD 1 napon belül
(0 vélemény)
0.0
jmendozadevelopm

Hi. I am an expert in Excel and 20 years of experience in software development, I know very well the problem that you must solve, so I can help you. You can contact me to expand more details of the requirement.

$30 USD 7 napon belül
(0 vélemény)
0.0
priya17042019

Accepted you proposal

$25 USD 1 napon belül
(0 vélemény)
0.0
premraj31

Hello. I am an office boy where i have to make reports many more by using excel. I have 6 years of experience in this field. So i think i am perfect for this job

$20 USD 3 napon belül
(0 vélemény)
0.0
dobalsantosh

DEAR CLIENT, I CAN DO THIS PROJECT AND TO START THE WORK. IF YOU GIVE ME A CHANCE AND BRIEF ME ABOUT THE WHOLE PROJECT THEN I WILL DO MY 100% AND I WILL TRY TO COMPLETE THE PROJECT IN MINIMUM TIME.

$20 USD 1 napon belül
(0 vélemény)
0.0
putrisriutami

i will do the best

$25 USD 1 napon belül
(0 vélemény)
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 Továbbiak

$10 USD 1 napon belül
(0 vélemény)
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 7 napon belül
(0 vélemény)
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 Továbbiak

$66 USD 7 napon belül
(0 vélemény)
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 Továbbiak

$10 USD 3 napon belül
(0 vélemény)
0.0