Write some Software for Excel automated vlookup, sorting, and advanced finding

En curso

Current process

1.

I have a list of business addresses that can get service from a cable provider. On almost a daily basis I have someone go to a website do a lookup for the zip codes that contain the businesses on the list and manually download 250 at a time, until he produces a list of 6000 business names on an excel spreadsheet.

2.

He then does 4 vlookups and creates 4 new columns, 1) Addresses that can get charter coax cable internet, 2) addresses that can get charter fiber internet service, 3) Companies that I know we can’t sell to for example Walmart, Target, and Google, 4) Industries that are difficult to sell to, 5) Companies with certain websites.

3.

He then forwards me the spreadsheet, and I do further sorting which is hard to teach to him. I separate any businesses with 25 or more employees because these are hard to sell to. I also, seperate businesses based on industry description and employee size that are better to sell fiber to rather than coax.

3. I then take out duplicate phone numbers and copy and paste all numbers to a different spreadsheet in one column. I take this spreadsheet and upload to a website called data24-7.com. This website then tells me what the current phone provider is for the company phone numbers.

4. I then take these phone numbers and carrier names add them to the spreadsheet that was downloaded using another vlookup (matching the carrier names to the phone numbers on the spreadsheet. I then give this spreadsheet to my IT person who uploads it into my dialer.

I would like for you to create a software that helps with these processes and does a couple more things. This is what I was thinking.

1. I provide you the spreadsheet with companies and lots of data that we manually download

2. Your tool does the following vlookups. 1) Addresses that can get charter coax internet, 2) addresses that can get charter fiber internet service, 3) Companies that I know we can’t sell to for example Walmart, Target, and Google, 4) Industries that are difficult to sell to, 5) Companies with certain websites.

3. Your tool also does some sorting. 1) Finds companies that are good to sell fiber to based on serviceability, industry description, and size(which are columns on the spreadsheet). For example any imaging companies, hospitals, law firms, accounting firms over 8 employees, construction companies over 30 employees, architecture companies over 15 employees, churches over 20 employees, and other various rules I would give you.

4. There also would be a column that includes what phone provider the company is using. I would like the tool, also creates another column which shows the number of other businesses at the same business address and lists the names of the companies that are also using Charter based on the column with that data.

All in all this may sound complicated but it is actually quite simple. About 5 vlookups, a couple sorts based on some critera, and identifying companys in the same building using a simple excel formula.

Habilidades: Diseñador de aplicaciones, Excel, Arquitectura de software, Desarrollo de software, Extracción de datos web

Ver más: excel automated project visual basic mechanical engineering, excel file write mysql database jsp, excel vba write xml document file, excel macro write xml file, excel vba write xml file, scheduling software excel price, excel vba write csv cvs, sorting text files excel, develop mlm software excel, car park management software excel, java programs read excel sheets write mysql database, let customer write review product website software script, buenos aires software excel, excel automated graph, excel automated graphs

ID de proyecto: #11571547

Adjudicado a:

aarifakhtar

Hi: I have a question: Do you want to automate the task that you do ONLY in Excel (sorting, filtering, etc.)? For instance, the lookup for zip codes and lookup for phone service provider on data24-7 . com can also be a Más

₱9000 PHP en 6 días
(135 comentarios)
6.7

33 los freelancers están ofertando un promedio de ₱10868 para este trabajo.

₱7058 PHP en 3 días
(254 comentarios)
7.6
₱20000 PHP en 7 días
(236 comentarios)
7.1
srinichal

Looking forward to discuss further details about the project and deliver the same to your requirements

₱6588 PHP en 3 días
(124 comentarios)
7.3
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Más

₱26947 PHP en 45 días
(22 comentarios)
6.8
AishaAlimuhammad

Hello, We can get you this software on Google Docs. It will run as a normal software and you will get the desired data easily. I would like to see the file first which you get on Daily basis and if the formatting remai Más

₱25000 PHP en 10 días
(118 comentarios)
6.9
bob1982

Hi, i am very good in excel vba/macro i have read the description and quite sure i am able to do the work with desired accuracy hope to hear from you soon

₱9411 PHP en 10 días
(298 comentarios)
6.8
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. http://www.siddharthrout.com/aboutme/ I am an MS-Excel Expert besides being an MVP (Microsoft Valuable Professional). If you see my reviews by navigatin Más

₱16666 PHP en 3 días
(152 comentarios)
6.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Más

₱10000 PHP en 4 días
(147 comentarios)
6.5
₱10588 PHP en 3 días
(274 comentarios)
6.7
mwarrenschultz

Hello! I am a professional programmer with many years of web scraping experience using Python. I have read your project description, and I can create the program you require. To do so, I will use the libraries Requests Más

₱11111 PHP en 3 días
(46 comentarios)
6.2
₱10000 PHP en 7 días
(51 comentarios)
6.2
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. Please send me more details about the work. It will help me estimate time and cost. I have completed more than 280 project Más

₱10000 PHP en 5 días
(144 comentarios)
6.3
redouaneaberdin

Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

₱10000 PHP en 5 días
(98 comentarios)
5.8
expertatwork

hey there... I can get this automated for you. thank you...

₱5998 PHP en 4 días
(168 comentarios)
6.0
katilinas

Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

₱11764 PHP en 3 días
(76 comentarios)
5.6
rohitpithisaria

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before Más

₱5882 PHP en 3 días
(71 comentarios)
5.6
jayamsoft

Hi, I will develop the MS Excel Ribbon / Tool Bar for your need all the operation will perform through on single click for each of your requirements. We are experienced programmer with more than 5 years of develo Más

₱25882 PHP en 20 días
(14 comentarios)
5.5
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 for further detail Más

₱10000 PHP en 5 días
(129 comentarios)
5.6
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you make this macro you need. Please contact me for more info.

₱4200 PHP en 2 días
(81 comentarios)
5.2
ReflexiveData

Hi, Thanks for posting this project.Please check our website: www.reflexivedata.com & reviews. For excel related projects please check the proposal. I have worked on integrating excel, word, SQL database, Power BI a Más

₱10000 PHP en 2 días
(12 comentarios)
5.1