Find Jobs
Hire Freelancers

Daily Sales Tracker From Different Offices

$750-1000 USD

Terminado
Publicado hace alrededor de 6 años

$750-1000 USD

Pagado a la entrega
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 del proyecto: 16094872

Información sobre el proyecto

32 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 21 días
4,9 (14 comentarios)
4,7
4,7
32 freelancers están ofertando un promedio de $1.082 USD por este trabajo
Avatar del usuario
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 en 15 días
4,9 (277 comentarios)
7,7
7,7
Avatar del usuario
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 en 20 días
5,0 (9 comentarios)
6,9
6,9
Avatar del usuario
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 en 20 días
4,8 (105 comentarios)
6,8
6,8
Avatar del usuario
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 en 20 días
5,0 (109 comentarios)
6,4
6,4
Avatar del usuario
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 en 7 días
4,9 (166 comentarios)
6,6
6,6
Avatar del usuario
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 en 7 días
4,9 (49 comentarios)
6,1
6,1
Avatar del usuario
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 en 20 días
4,9 (22 comentarios)
5,4
5,4
Avatar del usuario
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 en 20 días
5,0 (6 comentarios)
4,1
4,1
Avatar del usuario
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 en 10 días
5,0 (14 comentarios)
3,2
3,2
Avatar del usuario
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 en 20 días
4,6 (1 comentario)
3,2
3,2
Avatar del usuario
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 en 10 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
As I am into data entry work
$750 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
taunton, United Kingdom
5,0
17
Forma de pago verificada
Miembro desde jul 12, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.