Find Jobs
Hire Freelancers

Automated Excel Sales Report

$250-750 CAD

Abgeschlossen
Veröffentlicht vor etwa 7 Jahren

$250-750 CAD

Bezahlt bei Lieferung
Hello - I need to automate a weekly sales report. Attached is the weekly raw data of all the sales between Jan 1 and Mar 13, this updates weekly. I have also updated a copy of the report we use today. The current version seems to crash all the time and is a larger file than I would have expected. I would also like to link the data to google map so we can show where the sales are coming from. The most important tabs in the attached spreadsheet are: - Provincial - Doctor Level (sales by doctor) - New Doctors (a list of doctors that have used the product for the first time that month. ) The data will update every week and I need a way for the report to easily update when new data is added.
Projekt-ID: 13463206

Über das Projekt

22 Vorschläge
Remote Projekt
Aktiv vor 7 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 Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - 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 sample work before you consider awarding me the project. Thanks, Jay
$400 CAD in 5 Tagen
5,0 (779 Bewertungen)
8,6
8,6
22 Freelancer bieten im Durchschnitt $377 CAD für diesen Auftrag
Avatar des Nutzers
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$400 CAD in 4 Tagen
4,9 (370 Bewertungen)
8,1
8,1
Avatar des Nutzers
Hello I am Excel Expert and VBA Programmer I have been working as a financial audit so I have proper experience for that job and usually thats what I do on freelancer, creating accounting support excel set ups I checked files and would offer few things If interested, contact me Thanks & Regards
$411 CAD in 5 Tagen
4,9 (203 Bewertungen)
8,2
8,2
Avatar des Nutzers
I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$555 CAD in 10 Tagen
5,0 (207 Bewertungen)
7,1
7,1
Avatar des Nutzers
Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satisfaction. I have also good experience for Website designing, product listing for various forum, magenta, word press, PDF branding (like designing, Branding, editable PDF & conversion etc), web research and searching, Adobe Photoshop/ Corel graphic designing. I have ALISON certified for MS Excel, Excel & Formula, Powerpoint, Word & office 2010. 10 year computer operator and Administrator in an organization. My Freelancer profile and portfolio also show my experience. I am really interested in this project so please give me chance, I hope it will be nice experience for both of us. I will provide you best service in lowest budget with complete accuracy. ready to start now. I have very cooperative nature person and I always give preference to clients satisfaction Regards
$250 CAD in 2 Tagen
4,9 (195 Bewertungen)
6,5
6,5
Avatar des Nutzers
Hi there, Your project immediately caught my eye and I feel I would be a great fit. I have over 15 years of corporate experience working in Excel and google sheets creating advanced automated dashboards, reports and calculators for many different types of businesses and I'd love the opportunity to enhance your existing Excel based sales tracker. I took a look at your existing template as well as the raw data file and it all makes sense how it is put together with the pivots sourcing the data from the data tab which I assume is refreshed with the weekly raw data every week. I also see the extreme slowness of the file and it did crash on me as well a few times. I feel the pivot tables and all of the important data tabs you have mentioned would need to be rebuilt from a fresh file to fix the speed issue. I could add in a 2016 comparison sections as well if need be as I noticed you have all of the 2016 main totals. As for the google map - I also noticed you have the postal code and province in the raw sales data so there are a few different options you could go for the mapping requirements you have listed. There is a great mapping tool in Excel actually (not sure your version?) but also there are many web based free heatmap applications that I could show you. The main tabs you have listed would be redesigned as well and could include a logo or any colors specific to your business. Anyhow - I'd love to explore this further with you. Thanks either way, Shaun
$550 CAD in 5 Tagen
5,0 (93 Bewertungen)
6,6
6,6
Avatar des Nutzers
Hello there It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in VB, VBA, C++, C#, OPPs, HTML5, CSS3, JS, AJAX, JQYERY, React.js, ANGULAR.JS, BACKBONE.JS, BOOTSTRAP, PHP,Wordpress, ASP.NET, MVC, Excel VBA Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great results.I have fast internet connection at home, have my own pc to use anytime and have own space to work. I can work fulltime and will focus to this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible.. MOHSAN IJAZ
$333 CAD in 3 Tagen
5,0 (90 Bewertungen)
6,4
6,4
Avatar des Nutzers
Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this project. I can automatize your excel file to input data and get the reports instantly. Please contact me by chat and then we could discuss better your project! Kind regards, Luis Romero
$250 CAD in 5 Tagen
5,0 (149 Bewertungen)
5,8
5,8
Avatar des Nutzers
A proposal has not yet been provided
$370 CAD in 2 Tagen
5,0 (25 Bewertungen)
5,9
5,9
Avatar des Nutzers
Hello. I have extensive experience in Excel dashboard analyze and reporting in excel, I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project with the highest precision .
$250 CAD in 1 Tag
4,9 (140 Bewertungen)
6,2
6,2
Avatar des Nutzers
I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon,Cellpex,Costco,Yelp,etc., Hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. Please award me this project and contact me for further details
$555 CAD in 10 Tagen
5,0 (51 Bewertungen)
4,7
4,7
Avatar des Nutzers
Hello Sir, I am shahid from kashmir. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I'm interested in your project. Please send me a message so that we can discuss more. I have 8 years of experience in , Data entry, Linkedin, Lead generation , Google Research Expert,Web scraping,Leads, Web Search, Data Mining,Internet research. My key skills are: Research,Data entry,E mails marketing,Python Email developer, software architecture and Scrapping expert with 8 years of experience. Linkedin API developer. . Using,Leads ,Web Search ,Machine Learning,Linkedin, ,Web Services ,Internet Researc,Data mining,Web scrapping, Find contacts,Data Processing, Data Entry, Excel, Leads, Web Search, DataMining,Linkedin,MicrosoftOffice,Emailhandling,CProgramming,C++Programming,Linux,PHP,MYSQL,Java,Javascript,WebsiteDesign,GraphicDesign,CSS,Research,Wordpress,Magento ,Matlab and Mathematica .  I am a highly skilled  provider seeking an opportunity to leverage my expertise and demonstrate my high level of technical an administrative skills,I have completed 40+ projects in web Application,I also work on Data entry, Linkedin, Lead generation , Google Research Expert,Web scraping,Leads, Web Search, Data Mining,Internet research. I can achieve the results that you are asking for. Please check out my portfolio and my past work on my profile through reviews,Looking forward from your end. Thanks
$250 CAD in 5 Tagen
4,5 (8 Bewertungen)
4,6
4,6
Avatar des Nutzers
Hi I am here to assist u inthis project I am an ACCA member currently working in finance dept of Qatar Airways Have great skill and experience in Ms excel can assist u with high regards Plz share more info to proceed Thanks in anticipation Looking forward for this projext positively U can also review my profile for my clients reviews of my excel skills
$250 CAD in 2 Tagen
5,0 (23 Bewertungen)
4,2
4,2
Avatar des Nutzers
I can solve the load of your file by writing efficient queries or designing a VBA form where necessary that will ultimately enhance the performance for your work and make your life easy.. I have 5 years of experience with 100% client satisfaction history. Looking for your response.
$288 CAD in 3 Tagen
5,0 (18 Bewertungen)
3,8
3,8
Avatar des Nutzers
Hello, I looked up the Harmony Sales file. It looks like the macro that process the initial file is not very good - probably it doesn't use arrays, and it puts all the results in the Doc PT sheet, which has 30k lines - hence the size of the file. I created an one line macro to delete the extra lines in this sheet, to see if this really is the issue, but for every "delete" operation my computer almost stumbles, it takes minutes to delete a single line!, probably there are references in other sheets. In short, your actual macro is really bad. I would love to make a clean minimal code to process your data. Thank you for your time, Zoltan later edit - I managed to delete the extra rows in sheet Doc PT and the size of the file decrease from 7,5 MB to 1,3 MB
$250 CAD in 10 Tagen
5,0 (6 Bewertungen)
3,1
3,1
Avatar des Nutzers
Hi Jasonwcrowe, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements and we can move forward to the next step. Thanks, Joseph C Ocero
$749 CAD in 30 Tagen
5,0 (6 Bewertungen)
2,4
2,4
Avatar des Nutzers
Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can do the project very well. THE BID PROPOSAL I will complete your job under your guidance and supervision with 100% accuracy. Why you should hire me… :- * Because I have better experiences in data entry including copy typing, MS-office ,data compiling, data processing and of cause other manually typing works. *I am ready to work even with the lowest budget. * I'm always responsible and put my effort to hand-over the final project before the proposed date. *Revisions are always welcome until you are satisfying. *Although I handover you the completed project, if you think it wouldn't impressed you and I scammed you, don’t worry inform me, I would ready to refund your total cost honestly. Besides, I have attached some samples of my past works very similar to what you are seeking, you can check them also from here:- www.freelancer.com/u/rumesh402.html So I would like to invite you, please review my resume and contact me. your sincerely, Rumesh
$250 CAD in 0 Tag
4,2 (9 Bewertungen)
2,6
2,6
Avatar des Nutzers
Hello, I response to your job advertisement published in the “www.freelancer.com”. I would like to apply for the position of “Automated Excel Sales Report”. I am confident that if provided the opportunity in the area of "Data Entry" I will prove myself to be an important asset for your company through my dedication, sincerity and highest level of professionalism. My computer literacy is “Database Application” from Bangladesh Technical Institute Board & 'Certificate in Office Application & Internet' from ‘Bangladesh Computer & Technical Institute (BCTI), Khulna. I have got my bachelor degree in commerce from Khulna University in 2011 & MBS in 2012. I would request for an interview at your convenience. For any query, you can reach me at Skype & G-Mail. Greetings Protik Golder
$250 CAD in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von CANADA
Brampton, Canada
5,0
8
Zahlungsmethode verifiziert
Mitglied seit Dez. 12, 2014

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.