Find Jobs
Hire Freelancers

Daily Sales Tracker From Different Offices

$750-1000 USD

Opravljeno
Objavljeno pred približno 6 leti

$750-1000 USD

Plačilo ob dostavi
We are a food sales company that collects details from all the reps that work for us on a daily basis. We have 5 offices and every day the director calls the managers of the offices and inputs all the data of the sales reps for the previous day into an Excel spreadsheet, 6 days a week. On the sheet are the details of the sales rep/ i.e. office location, names, rep number, what vehicle he has and vehicle registration. The data the director collects includes; How many boxes sold, boxes pulled, new customers made, how much money paid in, if they have trainees with them on day one/day 2 and their account balance which changes according to whatever they pay in. There are tabs that collate all this information and present it as weekly total for reps and offices, monthly total for reps and offices. Previous years totals What we would like. We want someone to create an app that will facilitate easier data entry of all these data points. The best way would be a userform box that has a drop down of all the offices and reps in those offices. The MD can then select a rep or an office and the reps details populates the data entry box with information like, weekly totals, yearly totals, where on the leaderboard he is, which trainees he has trained and some other info. The data needs to dynamically change as he enters the sales for the previous day. Also, if he selects an office, all the office stats appear i.e. How many reps in that office, their names, the weekly sales totals, yearly sales totals and comparison against the other offices, i.e.leaderboard. The idea is that the director can quickly find out everything there is to know about that rep or any office. We also want to be able to pull reports up that shows all the figures in an easy to read way, like a KPI dashboard i.e. pivot charts or similar. I have included some images, including our current spreadsheet ([login to view URL]) which is what we want to change into a friendly app. There is also a userform image, which shows how we would like to enter the data and view the reps or office details. Please ignore the content and wording. It is just showing you what we can envisage is a good way to access the data. I hope that is clear explanation. We are only using excel VBA as an example. There may be better ways to do what we want but it goes without saying that all of this info must be saved on a daily basis. Thank you. I will answer any questions you have as fast as I can Mike
ID projekta: 16094872

Več o projektu

32 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commented, client gets whole access and rights for the code I made. Warranty covers any bugs detected later. Actually, I would suggest to reconsider the project like this: 1) Automated database per office to enter live sata on regular basis. It might be Excel, while it is better to use MS Access. 2) Central database that collects data from every office as oftenly as you need. It has to be almost the same like (1), while to keep data from all offices. 3) Some sync approach to allow data from (1) to be delivered to (2) in a fully automated way. It might be automated sending/recieving via Outlook, usage of shared cloud folder like Dropbox, whatever else. I do not consider any SQL server in this respect, because it would increase cpst of the project. 4) A Dashboard linked to (2), so one can see data in a suitable format. It might be emplemented on Excel (as a separate file linked to (2)) or Access. (as a part of (2)'s functionality). Correspondingly, there is no place for any form for entering data by derector, all data are already entered in every office. Looking forward for further clarifications of details. Regards, Sergey
$990 USD v 21 dneh
4,9 (14 ocen)
4,7
4,7
32 freelancerjev je oddalo ponudbo s povprečno vrednostjo $1.082 USD za to delo
Avatar uporabnika
Dear, the project is well described. But we need to have a deeper discussion. Also I need to get the source Excel file and be okay about the visualization process (he charts and what you call KPI). Based on my experience, the best way to make such complicated project, is to proceed by steps instead of explaining at the start. Best regards, Issam
$1.250 USD v 15 dneh
4,9 (277 ocen)
7,7
7,7
Avatar uporabnika
Hello, dear I read your job I am interested in your job as .NET programmer. I have experienced in VBA programming to process excel data. So I can do your job. Hoping to contact with you and discuss further. best regards
$1.000 USD v 20 dneh
5,0 (9 ocen)
6,9
6,9
Avatar uporabnika
Hello? How are you? I have good skills in excel vba and macros. I have developed so many apps like loan system and farmer insurance. So i think i can help you then. You can see my reviews. And i can show you the results. Thanks.
$1.250 USD v 20 dneh
4,8 (105 ocen)
6,8
6,8
Avatar uporabnika
Hi, Nice to know your requirement. I am an excel vba expert, have delivered 4 vba projects in the past 20 days. In my experience, have delivered ERP solutions for several companies. My bid is for 85 man hours. Once we have the detailed discussion on the requirements, functionality that is required, I will come up with more accurate cost/time estimate. Looking forward to working with you. Thank you, Regards.
$1.250 USD v 20 dneh
5,0 (109 ocen)
6,4
6,4
Avatar uporabnika
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Excel and Access, of course, familiar. Give me a chance to show what I can do!
$750 USD v 7 dneh
4,9 (166 ocen)
6,6
6,6
Avatar uporabnika
Hi there, I have special skills in developing excel based data management and reporting systems. I can make this file exactly as per your requirements with Excel VBA. Thanks
$1.000 USD v 7 dneh
4,9 (49 ocen)
6,1
6,1
Avatar uporabnika
Hello I can help you to get it done quickly. I have 10+ years experience in php/mysql development. Thanks Guru Venkat
$1.250 USD v 20 dneh
4,9 (22 ocen)
5,4
5,4
Avatar uporabnika
HI, As per my understanding we can build a system, from where every user or manager would login and add details of his performance or sales. Even, we can manage this for all offices and manager users of each offices as well. In this way you also not have call every office responsible person and you will get details as well. Also, we can manage details for each office differently as well. Admin will be there who can see everything and other users can see only specific details like they can add details etc. Please let me know when we can discuss this in more details. Looking forward for your response. Thanks.
$777 USD v 20 dneh
5,0 (6 ocen)
4,1
4,1
Avatar uporabnika
Hello am a professional software Engineere with vast experience in website design, I have read your project details and I have seen its something I can easily do then deliver quality professional web form for you, kindly award me this project
$770 USD v 10 dneh
5,0 (14 ocen)
3,2
3,2
Avatar uporabnika
Hello, We are a team having more than 15 developer that has more than 12 year experience in web/mobile application development. We are looking forward for a good and long work relationship. Thank you
$1.700 USD v 20 dneh
4,6 (1 ocena)
3,2
3,2
Avatar uporabnika
Dear Mike I have read your project description and will be glad to provide you an user friendly app to ease your work. I am graduate in computer science having 4 years of experience in App development and design. I can create an efficient mobile or desktop application for you. We can discuss more in detail about your project on chat. Looking forward to work with you! Regards Ahsan Nazir
$833 USD v 10 dneh
5,0 (2 ocen)
2,0
2,0
Avatar uporabnika
Hello there, Greetings of the day ! We are a small but excellent team of designer and developer. If you will hire us then I am damn sure that you will be fully satisfied with my expertise. I have more than 6+ years of extensive experience with PHP, Java, Microsoft.net, WordPress, Magento, Laravel, CI, YII, AngularJS, NodeJS, Photoshop, Illustrator, Mobile application development in J2ME, Android & iOS, etc. Rather than i have lots of experience with third party software integration, customization, payment gateway integration, API calls, RESTful API calls, Amazon and eBay APIs, etc. I had worked with the JSON and XML data based API also. I need one small meeting on personal message to discuss the complete requirements and then start the work ASAP. Looking forward for your kind reply. Regards, sachin ** Price and time mention over here are just placeholder. It might be change based on the requirements.
$1.250 USD v 20 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hello, I would like to do this project properly. and will do it honestly. i have two more years working experience with this field. thank you
$750 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Dear, After reading your offer this looks like a perfect fit for my skill sets. I am a Bangladeshi with native English. I can guarantee quality in communications. I work extremely fast and with high quality Thank you and I look forward to the opportunity to work with you. Monir Uddin Maruf,
$1.250 USD v 20 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi, I am highly experienced person in website development. I am having more than 15 years of experience in this field. So I can complete the work in very short time period. Please let me know. Thanks
$1.250 USD v 20 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
As I am into data entry work
$750 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Proficient in React native , Reactjs Ionic Framework , MeteorJS and creating hybrid applications. Excellent knowledge of implementing API's and jSON data. Also well in AngularJs, MongoDB, NodeJs.
$972 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED KINGDOM
taunton, United Kingdom
5,0
17
Plačilna metoda je verificirana
Član(ica) od jul. 12, 2009

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.