Find Jobs
Hire Freelancers

Excel Program Needed

$250-750 USD

Abgeschlossen
Veröffentlicht vor mehr als 7 Jahren

$250-750 USD

Bezahlt bei Lieferung
I need a very experienced MS Excel developer to build an excel application that will process batch csv files and present information in user interface. This is for a VoIP system. There is a scheduled job on the system which is exporting data to an FTP folder every hour. This information contains 28-30k fields of destinations which include country name, breakout (city or mobile carrier), ASR, LCD, top 5 suppliers and top 5 supplier costs for each destinations. The display will also show destinations based on names and not code. When csv is received, we need developer to extract the information and show in GUI something similar to what is shown in in the attached file labeled codes.xls. The sample file labeled raw_cdr is a sample of the raw file containing all the data received from the system.
Projekt-ID: 11338528

Über das Projekt

35 Vorschläge
Remote Projekt
Aktiv vor 8 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
Hello! I am ready to help you with your task! I can do this project as desktop or web-based app with Excel-like functionality. I already had alike experience - developing from scratch responsive web-based CRMs/Dashborads for different companies using PHP+MySQL+jQuery+Bootstrap3+GoogleAPI. - Bookings keeping - bills and invoice making - managers accounts managing - Google Drive files upload - Gmail messages fetching - reports, contracts and other docs in PDF/CSV, charts and etc I can send you screenshots of the system, I guess it's similar to what you need You can also take a look at my portfolio. Please do not hesitate to contact me via messenger!
$333 USD in 5 Tagen
5,0 (3 Bewertungen)
4,9
4,9
35 Freelancer bieten im Durchschnitt $441 USD für diesen Auftrag
Avatar des Nutzers
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$500 USD in 4 Tagen
5,0 (920 Bewertungen)
9,4
9,4
Avatar des Nutzers
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
$250 USD in 6 Tagen
4,9 (559 Bewertungen)
8,5
8,5
Avatar des Nutzers
Hi, my name is Sevinc. I read your "Excel Program Needed" project descriptions carefully before bidding. I checked the attached templates as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$250 USD in 5 Tagen
4,9 (308 Bewertungen)
8,2
8,2
Avatar des Nutzers
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$500 USD in 5 Tagen
5,0 (501 Bewertungen)
8,0
8,0
Avatar des Nutzers
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 regards
$500 USD in 10 Tagen
5,0 (328 Bewertungen)
7,5
7,5
Avatar des Nutzers
Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I have already created something similar to what you need: The Excel macro file was opened every night by Windows Task Scheduler. The macro connected to an ftp server, downloaded a csv file of financial data, connected to our own database, made a comparison between the ftp and the database data and run insert/update SQL statements in Oracle, if it found any missing or different data. In the end it sent a mail from outlook about the number of insert and update statements performed. Beside that I managed to create Excel macros that fill word templates based on cell references, forms with which one can upload or insert data into a database quickly without writing SQL scripts in a DB application. You can also find references on Excel userform projects among my reviews.
$450 USD in 10 Tagen
5,0 (129 Bewertungen)
7,1
7,1
Avatar des Nutzers
I am not a mediator. I will help quickly and efficiently. Ready to do this job. I have several dozens of completed projects in Excel. Maybe your project will be the next? From the Excel, of course, familiar.
$250 USD in 3 Tagen
4,9 (260 Bewertungen)
7,1
7,1
Avatar des Nutzers
So, the excel application will stay on the same FTP folder and when someone opens it, it will process the CSVs and bring the data to the needed layout. (manual or automatic triggered) Lets discuss more on chat. Regards..
$600 USD in 4 Tagen
5,0 (143 Bewertungen)
7,3
7,3
Avatar des Nutzers
Hello , I would like to work on your project. I have great experience using excel and macros / vba. Provide please further details in PM. Thank you. Regards
$300 USD in 5 Tagen
5,0 (193 Bewertungen)
7,0
7,0
Avatar des Nutzers
Hi, Let me introduce myself as an expert Excel programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have more than 10 years of experience to my credit. I have done good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$250 USD in 5 Tagen
4,9 (204 Bewertungen)
7,0
7,0
Avatar des Nutzers
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details. There are a couple of questions I'd like to ask you. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$400 USD in 7 Tagen
4,8 (180 Bewertungen)
7,2
7,2
Avatar des Nutzers
Hi, I have more than 15 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 275 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$500 USD in 15 Tagen
4,9 (129 Bewertungen)
6,4
6,4
Avatar des Nutzers
Hi, I have skills to do this data manage more comfortable to you.. I could satisfy your requirements as you ar doing it, but I really propose to populate a local database with this data in order to manage it more convenientlly. Once in a database you can have a lot of queries to do about all data stored along the days. not only the recent one. My proposal is because I saw your big data stored in the spreadsheet. I you continue this way , probably turn slow your answers... Please chat with me to define details. See my portrait, my profile and comments from my clients as a reference.
$250 USD in 5 Tagen
4,9 (72 Bewertungen)
6,3
6,3
Avatar des Nutzers
***********************Hello*********************** I am interested to work with you. Please contact with me on PM for more discuss about this project. I am waiting for you. You may check my profile for more details about my past experience at-https://www.freelancer.com/u/sajibdigital.html thank you -Sajib
$555 USD in 10 Tagen
5,0 (83 Bewertungen)
5,8
5,8
Avatar des Nutzers
- Looked through the raw cdr and codes files. - Pulling the flle from the FTP folder, consolidating the 25-30 field information and displaying it for the user to look through the data. - Have good expertise in Excel macros and automation using macros, VBA. Formulas, summaries, pivots, data generation, merging, comparision, validation - used extensively. Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
$250 USD in 4 Tagen
4,6 (51 Bewertungen)
6,1
6,1
Avatar des Nutzers
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flaw I am very much able to work on this. ***I am ready to start Waiting for further discussion with thanks and regards
$555 USD in 5 Tagen
4,6 (50 Bewertungen)
5,7
5,7
Avatar des Nutzers
Hi, my name is Anatolii. I have tremendous experience with MS Excel and reporting, I've been used to work for TOP-5 World Banks, and created a lot of Reporting systems, etc. Could you please give more details, it's not really obvious here how to get from the raw file to report, do you have any mapping on columns? Or could you briefly explain the logic can be used to prepare this report? My solution will be quick and bullet proof, I providing the support for all of my solutions. Thank you very much in advance. With Best Regards, Anatolii
$388 USD in 4 Tagen
5,0 (18 Bewertungen)
4,8
4,8
Avatar des Nutzers
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
$388 USD in 7 Tagen
4,6 (68 Bewertungen)
5,3
5,3
Avatar des Nutzers
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble
$566 USD in 20 Tagen
4,8 (30 Bewertungen)
4,8
4,8
Avatar des Nutzers
I have rich experience in Excel development and also have confidence that I can get it done with good quality. Looking forward to hearing from you. Thanks.
$270 USD in 20 Tagen
4,9 (11 Bewertungen)
3,9
3,9

Über den Kunden

Flagge von UNITED STATES
Pittsburgh, United States
5,0
35
Zahlungsmethode verifiziert
Mitglied seit Juni 29, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.