Find Jobs
Hire Freelancers

Create Graphs From Data in Excel

$30-250 USD

Fechado
Publicado há mais de 13 anos

$30-250 USD

Pago na entrega
This project involves taking data and creating a process that summarizes it in graphs. You have to have knowledge of MACROS and understand data flow and structure in MS Excel. Details: Please open the Attached document. The sheet is hosted in a server and updates everday with new data from previous day into the Data tab. What I need is that when someone puts in a Customer Name in the Front Page and assigns a date then clicks on the Create Graphs button the process runs to get the data and summarize it in the graphs and provide Ontime Information by week for the selected customer ignoring all other customers in the Data tab. I have highlighted in Green all the columns that are used to Create the graphs and data summary. Steps: Manual Entry in Front Page 1. I Enter Customer Name 2. I Enter Date you would like to summarize 3. Click on Create Graphs ..................................................... KEY NOTES...................................... 1. Graphs can be Pivot table Graphs but the layout cannot change. I have to have them look like they do currently 2. This has to be done in Excel not a desktop application 3. Ontime is Summarized by Week this data comes from column "J" 4. Top Reason types is by Month and separated as controllable and Non Controllable this data comes from column "K" and "L" 5. Basically if you can get all the Gray areas filled with data automatically You have accomplished the requirement a) Ontime % Data on the left of the Ontime tab is a summary of count of Late and Early by Week starting with a summary of the week of the date entered in 2 above. b) Summary of Controllable issues and Non Controllable by issues type. This is taking collumn K & L grouping it by controllable or Non-Controllable which is the two options in column L Please feel free to Request any additional iformation. I will try my best to make sure you have all the information you need to allow you to place a good bid. Happy bidding.
ID do Projeto: 869867

Sobre o projeto

43 propostas
Projeto remoto
Ativo há 13 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
43 freelancers estão ofertando em média $69 USD for esse trabalho
Avatar do Usuário
Ready to start now....See PMB please
$100 USD em 2 dias
4,9 (248 avaliações)
6,7
6,7
Avatar do Usuário
Ten years experience in developing automated Excel/Charting/VBA solutions.
$120 USD em 2 dias
4,9 (35 avaliações)
5,6
5,6
Avatar do Usuário
Such jobs are my daily practice, please see PMB for details! Regards!
$80 USD em 3 dias
4,9 (62 avaliações)
5,7
5,7
Avatar do Usuário
Hi, I have more 10 years experience with Excel automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex
$50 USD em 1 dia
4,9 (35 avaliações)
5,5
5,5
Avatar do Usuário
Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM
$100 USD em 2 dias
5,0 (24 avaliações)
5,1
5,1
Avatar do Usuário
Hello Ready to start right now. Please see your PMB for details. Thanks
$30 USD em 2 dias
4,9 (21 avaliações)
4,5
4,5
Avatar do Usuário
I would like to bid. DOnna
$100 USD em 5 dias
4,3 (16 avaliações)
4,9
4,9
Avatar do Usuário
please view PMB.
$45 USD em 1 dia
4,8 (17 avaliações)
4,1
4,1
Avatar do Usuário
Hi, I am interested in this.
$100 USD em 4 dias
5,0 (7 avaliações)
3,3
3,3
Avatar do Usuário
Hello, I would like to make a starting trial on this task. Please see PMB for some other details and past projects here. Best regards.
$50 USD em 2 dias
5,0 (5 avaliações)
3,2
3,2
Avatar do Usuário
Hi I have requested sample file to ascertain if my quote is competitive please
$75 USD em 7 dias
5,0 (7 avaliações)
3,2
3,2
Avatar do Usuário
Hi, Ready to start now. See PMB for details. Kris
$30 USD em 1 dia
5,0 (5 avaliações)
2,5
2,5
Avatar do Usuário
Ready to start right now.
$80 USD em 3 dias
5,0 (4 avaliações)
2,3
2,3
Avatar do Usuário
Please see PM
$50 USD em 1 dia
4,9 (4 avaliações)
2,2
2,2
Avatar do Usuário
I have performed this exact task as part of a bigger project where I analyzed & researched data reporting; improving operational efficiency while assisting a Medicare Administrator to expand from $120 million to a $245 million dollar company in 45 days. I am sure similar succesful results are possible with your project.
$50 USD em 1 dia
5,0 (1 avaliação)
2,1
2,1
Avatar do Usuário
I have over 10 years creating excel solutions for businesses. I can do this quickly and efficiently.
$50 USD em 1 dia
4,8 (1 avaliação)
1,4
1,4
Avatar do Usuário
Hi, I am interested in this project and ready to start immediately. Please see PMB. Regards!
$80 USD em 1 dia
5,0 (1 avaliação)
1,0
1,0
Avatar do Usuário
Hi Sir, Please see PM. Thanks Venkatesh.
$80 USD em 10 dias
3,5 (1 avaliação)
1,1
1,1
Avatar do Usuário
Hello, i have developed various report which gives the graphical presentation of business, on few selections criteria results will change, it will be 100% dynamic report, even if data changes, it will capture the latest data, and selection criteria. would like to take opportunity to work on this project Regards, Savan
$50 USD em 2 dias
5,0 (1 avaliação)
1,0
1,0
Avatar do Usuário
Sir, Long time working on Windows environment and very familiar with office product. Please check pm, thanks. Steve.
$60 USD em 4 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Canal Winchester, United States
5,0
4
Método de pagamento verificado
Membro desde mar. 22, 2008

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.