VBA - Excel - Mobile Phone Number Data Quality and macro -> EASY contract!
$10-30 USD
착불
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.
프로젝트 ID: #22275483
프로젝트 소개
수상자:
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 기타
이 일자리에 대한 프리랜서 24 명의 평균 입찰가: $64
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
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 기타
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, 기타
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
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 기타
Hi, i am excel experienced freelancer. With more clarity of information, i can do this neat work for you
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, 기타
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
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 기타
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
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.
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
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.
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 기타
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
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 기타
