Find Jobs
Hire Freelancers

An Access Report for Work Items

$250-750 USD

Cancelado
Publicado hace más de 13 años

$250-750 USD

Pagado a la entrega
1. I have two tables that are being exported from an online database in an excel spreadsheet. 2. Each table contains data from a year. 3. The data contained in each table is similar. 4. There are unique item numbers in each table: completion dates for each item number, start dates, labor hours, etc. (date format: mm/dd/yyyy) Example: Item 232323 - Date Created - Date Completed- Assigned to Agent Name- Labor Hours. 5. I need to build a report that can: a. Compare the quantity of items present year to year, quarter to quarter (within years and between years), month to month. b. Apply a numeric index for a range of hours for each item. i. Example, item 2243 had 23 labor hours. I would have a scale where 1-5 gets an index value of 1, 5-10 gets 2, 10- 15 gets 3 etc… ii. Once these indexes are calculated, I need to use this data to have percentage improvements comparisons year to year, quarter to quarter (with and between years), month to month. c. Find turn around times for items. How fast they were completed (diff between date created and execution date) and here’s the catch. There’s another field called date completed. There needs to be a function that uses completion date in the calculation if execution date isn’t there. d. FINALLY: I need to assemble all these numbers (the percentage improvements or decreases for each calculation, and give each calculation a weighted number based on the percentage. I need something like a progress bar at the bottom of the report to display this. e. So need the progress bar, pivot charts to compare values (percentages and quantities), Tables. Etc. Is access the best option or excel to have something this analytical? THE CATCH: the report has to be reproducible, meaning, the end user can throw in next year’s item excel file from the online database and use that to compare last year’s data output. The quantity of items will constantly be increasing. So the xls output files being analyzed will be updated on a regular basis. . ALSO: I need to run multiple filters to weed out outliers in the data as well as specific members assigned to each item. (ex. Brian, bob, sandy, Jill are in the excel output… there are actually far more people in the output file (14000 items)), I would need to input a specific team with specific people (usually 10 people) into the report parameters, and filter those individuals and then run the metrics above. When it comes to outliers, I would want to not include certain data in the calculations for the report. For example, if I'm calculating turn around time, I would want to exclude items that have been worked on for more than 1 year. ALL IN ALL- This isn't too complex for someone who knows their stuff. There's just alot of formulas to put in and some clever design for the report. I'm asking for a performance report essentially. If any teams think they can accomplish the same analysis and task using excel (this includes being able to throw new data in every time we run the report), you are free to bid for that method as well. I need a complete product very soon. THANK YOU. And please let me know if you have additional questions.
ID del proyecto: 755024

Información sobre el proyecto

41 propuestas
Proyecto remoto
Activo hace 14 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
41 freelancers are bidding on average $403 USD for this job
Avatar del usuario
Serious bid here, I can start ASAP.
$750 USD en 15 días
5,0 (64 comentarios)
6,2
6,2
Avatar del usuario
Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.
$650 USD en 15 días
4,8 (92 comentarios)
6,5
6,5
Avatar del usuario
Can be done perfectly. Thanks Al
$350 USD en 5 días
5,0 (35 comentarios)
5,9
5,9
Avatar del usuario
Over ten years experience in developing Excel/Access/VBA solutions.
$250 USD en 7 días
4,9 (35 comentarios)
5,6
5,6
Avatar del usuario
Please see PMB for details. Thanks, Drew
$500 USD en 7 días
5,0 (9 comentarios)
5,6
5,6
Avatar del usuario
Hello Ready to start right now. Please see your PMB for details. Thanks
$250 USD en 7 días
4,9 (40 comentarios)
5,0
5,0
Avatar del usuario
Hello, pleas see PM
$250 USD en 10 días
5,0 (30 comentarios)
5,1
5,1
Avatar del usuario
Hello, please read the PM
$350 USD en 5 días
5,0 (6 comentarios)
3,7
3,7
Avatar del usuario
Please check inbox
$300 USD en 2 días
4,3 (7 comentarios)
3,9
3,9
Avatar del usuario
What MS Access version do you use? If it is Access 2007, I could make it 1 or 2 days completion. The description you placed here is clear enough. But, I need to have the sample of xls file for my designing and programming purpose. Also, if you have something like rough design of report layout that would make it quicker in completion. Let me know.
$450 USD en 0 día
4,9 (4 comentarios)
2,6
2,6
Avatar del usuario
Ready to start right now.
$250 USD en 4 días
5,0 (4 comentarios)
2,6
2,6
Avatar del usuario
Good Morning - please see your private messages for bid details.
$650 USD en 10 días
5,0 (1 comentario)
2,6
2,6
Avatar del usuario
Please, check your PM box
$260 USD en 14 días
5,0 (1 comentario)
2,4
2,4
Avatar del usuario
I am pleased to bid on your project and will produce the report in the format of your choide (Acccess or Excel).
$300 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi Pl see for the sample file that gives you the scale for the labour hrs. I have done similar reports all through my analyst career for the past 7 years Hoping to hear from you Kind Regards Padma
$400 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
creativegreenvn-VietNam
$299 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can do this please check PMB
$499 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
The project can able to do myself and i can able to provide the output as per your expectation, and if can send the format and data points so it will very easier to make the project sucessfull.
$300 USD en 6 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have some application made in Ms Acces and ready to make yours
$250 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please see PMB
$750 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Glastonbury, United States
0,0
0
Miembro desde ago 1, 2010

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.