Find Jobs
Hire Freelancers

Analyze some Data

$30-250 USD

Cerrado
Publicado hace casi 9 años

$30-250 USD

Pagado a la entrega
I have been trying to figure out a way to create a work sheet to input daily sales report for 80 sales rep working in 4 regions. Each region has 20 reps and one supervisor. Each supervisor has to monitor the sales of their agents. The records they have to input are quantity of SIM cards each agent collected, quantity of recharge vouchers each agent collected, quantity of sim cards and recharge vouchers sold and quantity of each products left. These records needs to be updated daily. The unit cost of each product is NGN100. Supervisor should be able to see a total amount of sales made each day, weekly and monthly for each product and grand total for both products, he should also see quantity sold and quantity remaining for each product, he should be able to filter by date, or agents name. Now since there are four regions, there is also an overall manager that needs to see what's happening in the four regions. He should be able to filter by region, date range, down to individual sales rep if necessary. I need someone to develop this in either excel or Microsoft Access putting into consideration ease of 20 agents for each region inputting the data daily which each of the region's the Supervisor has to view and the overall Manager being able to view for all regions.
ID del proyecto: 7785094

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 9 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
28 freelancers están ofertando un promedio de $160 USD por este trabajo
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$140 USD en 8 días
4,9 (221 comentarios)
7,4
7,4
Avatar del usuario
A proposal has not yet been provided
$200 USD en 2 días
4,9 (123 comentarios)
7,0
7,0
Avatar del usuario
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
$194 USD en 3 días
4,9 (160 comentarios)
6,6
6,6
Avatar del usuario
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
$188 USD en 5 días
4,9 (121 comentarios)
6,8
6,8
Avatar del usuario
Hey, There are multiple ways to go about it and if you could provide more information about the setup you have, I would be able to suggest some options. Do the sales reps and the managers have a common directory that they access? Like an intranet or something? If yes, then only you would be able to create an Excel/Access based system that is easy to use. Another option could be that the users fill their respective numbers in a spreadsheet template we create and send an email daily to their managers. The managers then run another macro that we create and get the data. Again, I find this cumbersome. I believe you would be better-off by creating a web based application wherein the users login and depending upon the kind of access they have, they simply either enter the daily data or view reports. I can help you in creating the best possible solution in all the above ways. Pleas let me know your preferences and we may get started. Thanks and Regards, Rishi (Automyze Consulting)
$333 USD en 15 días
5,0 (113 comentarios)
6,3
6,3
Avatar del usuario
Hello there, I will like to help you out with this project. I have plenty of experience developing this kind of tools on Excel. Also, I will include a really nice user interface. If you want, we could make a test run so you can check my skills. Hope to hear back from you soon. Thanks
$147 USD en 3 días
4,7 (91 comentarios)
6,7
6,7
Avatar del usuario
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$150 USD en 10 días
5,0 (139 comentarios)
6,3
6,3
Avatar del usuario
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to build a Multi-user Microsoft Access Database With different rights for different users. There will be usertype in the database like "Manager" which can see full database with four region, the other user type will be "supervisor" which can only see data for respective region only. I have been built many MS Access databases from scratch. I can make it so it can be use in Multi-user environment (Many user can work simultaneously from different computer) with log-in dialog, search, filter and save the filter features using Microsoft Access with Access Reports. I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, Search data, Validation rules, Filter some data then save the filter with a name so you don't need to filter for future use. The user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. I have 6 year's experience designing and developing Microsoft Access Application with advance knowledge of SQL and VBA. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio
$155 USD en 7 días
4,9 (71 comentarios)
6,0
6,0
Avatar del usuario
HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data operations and also other functions like selecting the data criteria for generation of the reports, the user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form through button clicks to access their functionality. I can offer you with a very dynamic access reports, dynamic in terms of their structure i.e. the structure of a single report can change depending on the data to be displayed on it each time for e.g. access reports can be used to generate invoices on them, now as structure of the invoice is dynamic i.e. there may be any number of items billed, so in such scenarios I can offer you reports which can handle this dynamic nature of such data. Criteria for the data to be displayed on the report can be set on user forms and they can be generated on button clicks. I want to send you an access DEMO application to give you an idea of the functionality that I can offer you, if you could reply me on this message I will be able to send you the demo app. Regards.
$69 USD en 5 días
5,0 (31 comentarios)
5,4
5,4
Avatar del usuario
Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please give me chance to prove myself. Thank u!
$83 USD en 1 día
5,0 (26 comentarios)
4,4
4,4
Avatar del usuario
I am willing to discuss further about the project details and deliver the same to your specifications
$189 USD en 3 días
4,8 (14 comentarios)
4,6
4,6
Avatar del usuario
Hi I read that you're looking for some kind of custom made template in Excel or Access which can help you manage all your 4 regions and 20 reps each with a supervisor on top. This is doable and I can achieve it in about a week, let me know if you want to see a small sample related to this. I have a 100% completion rate and never less than a 5 star rating. In case if I will not be able to do it then I will not be asking for any money. (but this is just too rare :) Regards Extra Mile Services
$97 USD en 5 días
5,0 (15 comentarios)
4,0
4,0
Avatar del usuario
Respected Sir i can develop an application in .net framework (c# or vb.net) for you and another for your sales persons to input data and upload it to your server and generate reports and use queries at your end. Warm Regards vnb400
$250 USD en 10 días
5,0 (25 comentarios)
4,2
4,2
Avatar del usuario
Hi, I can do this very nice in Excel. I have very simple and efficient idea, ideal for such task. Contact me to discuss details. Thanks
$120 USD en 5 días
5,0 (9 comentarios)
4,2
4,2
Avatar del usuario
Hello, I can make an application in MS Access to resolve your problem. It can be done in a day. Please let me know when you want to discuss more about this. Thank you.
$45 USD en 1 día
4,9 (36 comentarios)
3,9
3,9
Avatar del usuario
please check my previous work on projects using Access. I will address data collection & ease of use for you approval prior to dealing with the multi-level reporting.
$250 USD en 30 días
5,0 (4 comentarios)
3,6
3,6
Avatar del usuario
I am database expert having experience of 2 years.I will definitely complete your work and deliver it on time.
$111 USD en 3 días
4,9 (13 comentarios)
3,2
3,2
Avatar del usuario
I deal with similar type of reports all the time since I am with the sales team of an FMCG company. I am confident that I can deliver excellent results! I have a comprehensive knowledge of word processing, spreadsheets and databases. I drive for results and have the ability to meet deadlines and exceed goals. I also maintain a proactive approach to daily routines. I have a strong desire to work hard and perform well.
$277 USD en 5 días
5,0 (2 comentarios)
2,3
2,3
Avatar del usuario
A proposal has not yet been provided
$155 USD en 3 días
5,0 (3 comentarios)
2,5
2,5
Avatar del usuario
Can I help you in your project. I am person from IT having good knowledge about MS Excel and MS Access. Give me a chance. I won't disappoint you. Thank You! Akanksha
$50 USD en 3 días
5,0 (1 comentario)
1,6
1,6

Sobre este cliente

Bandera de NIGERIA
lagos, Nigeria
5,0
9
Miembro desde jun 20, 2013

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.