Find Jobs
Hire Freelancers

Access Excel Sales Analysis Reports VBA

£20-250 GBP

Cerrado
Publicado hace más de 12 años

£20-250 GBP

Pagado a la entrega
This project is to create a macro that will pull data from an access database for each months sales of 300 skus and compare the data each fortnight. Please see attachment Sheet 1 is how I want the resulting report to look. It shows the sales of each sku per fortnight, and the percentage increase or decrease in sales compared to the previous fortnight. I want the percentages to be highlighted depending on their value. I want to be able to set the ranges that the highlights apply to as per my example, then choose the start date, then click run. If the last time period is less than a fortnight, just show the sales for that number of days. There is example data in the 'Database' sheet within this file. I would like to see the report running with this data before we move to pulling the data from a query in the Access database. One developer has already tried to do this project but it took about 5 minutes until the report was shown in the excel file. Please only apply for this job if you can get the data shown in less than 15 seconds of processing time on a modern day PC (Core i7 processor)
ID del proyecto: 1236359

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 12 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
15 freelancers están ofertando un promedio de £174 GBP por este trabajo
Avatar del usuario
Access expert here. Please check my profile. Thanks!
£200 GBP en 2 días
5,0 (66 comentarios)
7,0
7,0
Avatar del usuario
Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.
£175 GBP en 2 días
4,7 (76 comentarios)
6,2
6,2
Avatar del usuario
hi, I’m very much familiar with SSIS SSAS SSRS and also during last three years I involved many project in ETL, data warehousing, BI reporting and 5 years of application development experience. I would highly appreciate if you assign this job to me I’m asking only 100 & I have enough confidence for complete this project because of I already completed two project for Interfacing Oracle EBS(Oracle 10g ,Oracle 11g DB) to DB2 systems by using MS SQL server application and all the reports generated by using SSRS . Best Regards, Jinesh
£100 GBP en 1 día
5,0 (66 comentarios)
5,7
5,7
Avatar del usuario
I am a Management Accountant with 20 years experience, and very strong Excel & VBA skills.
£250 GBP en 2 días
5,0 (12 comentarios)
5,2
5,2
Avatar del usuario
Hi! If you have data in MS Access, and database sheet calculating fast in Ms Access I can create query in MS Aceess. It will be work fast. Resul will be past from Acess in up to couple sec. Regards. P.s. If you want I can show expamle.
£250 GBP en 4 días
4,6 (13 comentarios)
4,7
4,7
Avatar del usuario
Please a better solution on PMB. regards
£200 GBP en 3 días
3,8 (4 comentarios)
4,5
4,5
Avatar del usuario
Hello i can do it, but need more details, also send me access file from which you want to pull data,
£200 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please Check My PM
£30 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, Please see PM. Thanks
£250 GBP en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am expert in Excel and helped design the ECDL syllabus and tests at advanced level. Based in Ireland, I am available during the working day for consultation by Skype, messaging or email.
£145 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I think I can do this job.
£150 GBP en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i have a good experience in ms office macros
£200 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, very interested in putting together a solution for you. I have over 15 years experience with Access, Excel. I have written numerous systems using both technologies. Looking at your requirements as well as the issues you have had with a previous attempt at providing you with a solution, I think the are a number of issues you need to be aware of. Firstly you relying on excel performing all of the analysis work on a large data set of information retrieved from an access database. I can see why your previous developer could only come up with a solution that took 5 minutes. Ideally you would won't the data you retrieve from access to have already been grouped into times periods, etc through the query you would run. Then all excel needs to do is present the query results on your report spreadhseet. The SQL query needs to do all of the work. If the example query data set you have provided is an indication of the number of records returned then this approach would take a mater of a few seconds. Hopefully this makes sense. It does also mean that it's unlikely that you will be able to improve much on the 5 minutes processing time if your are wonting a developer to process the data set example you have given first. As stated I think I can help but it will be dependant on whether (if successful with my bid) I have access to a copy of your access database albeit a cut down version of it. Many thanks Gareth
£150 GBP en 14 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
22
Forma de pago verificada
Miembro desde jul 1, 2011

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.