Find Jobs
Hire Freelancers

Create Excel program for data review

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
We enter data for construction jobs into monthly tabs. I would like to have a tab that compiles all of the jobs and the cost amounts from each monthly tab and put them in order for us to review totals. Please see the uploaded file for a more clear review of what I'm looking for. The programing is for the first tab "Master Review"
ID del proyecto: 17287089

Información sobre el proyecto

33 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
Hi, I am good at Excel advanced formulas and vba programming. Looking forward to discuss the project in detail. I have reviewed the file. It contains month sheets. And it also contains Summary sheet at the front, having 3 columns. I would like to know the mapping fields. -Chandra
$100 USD en 1 día
5,0 (875 comentarios)
8,0
8,0
33 freelancers están ofertando un promedio de $96 USD por este trabajo
Avatar del usuario
Dear Employer, I completely understand your job and will do the excel coding for you. Please try me for this opportunity. I have an experience of over 10 years of excel coding. Thanks and Regards, Ash
$155 USD en 3 días
5,0 (181 comentarios)
7,6
7,6
Avatar del usuario
Hello PlumbDave , I have checked the attached file and understood your requirement. I am an excel Expert and also can develop in Visual basic.I can complete task within time with 100% accuracy.
$50 USD en 2 días
4,9 (456 comentarios)
7,5
7,5
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. Best regards
$100 USD en 2 días
4,9 (233 comentarios)
6,9
6,9
Avatar del usuario
Hi Dave, I can help you to build excel dashboard for your company. I am WordPress expert, ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always deliver work on time. My motive is to make my employer happy with quality of service. If you are looking for data entry work I hope to deliver you the best of best services. Hire me to get the job Expertise:
$30 USD en 0 día
4,8 (174 comentarios)
6,7
6,7
Avatar del usuario
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can develop the best code the compilation of your monthly data in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks
$30 USD en 1 día
5,0 (83 comentarios)
5,8
5,8
Avatar del usuario
Sir, I am very able to create a macro to suffice your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from you. with thanks and regards
$98 USD en 2 días
4,6 (54 comentarios)
5,8
5,8
Avatar del usuario
Pretty straight forward. Give me the task and consider it done. I have written many similar programs and this can be accomplished quite easily.
$97 USD en 3 días
4,9 (26 comentarios)
4,8
4,8
Avatar del usuario
HI there! I have a large experience in Excel, MACROS, and VBA I have all tools and tricks, I assure you, you will be more than satisfied with our work Can you please share more description and file? We are ready to provide a free sample For a quick sample click the link below https://www.freelancer.com/projects/excel/Excel-Spreadsheet-Formula-Work/ and https://www.freelancer.com/projects/excel/AXIS-CHART-AXIS-CHART-HISTOGRAM/ and https://www.freelancer.com/projects/excel/would-like-hire-Excel-word/ and https://www.freelancer.com/projects/excel/Quick-vowel-sorter-spreadsheet-macro/ Awaiting for your response Thanks!
$40 USD en 0 día
4,8 (15 comentarios)
4,3
4,3
Avatar del usuario
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I have checked your file and read your description as well and well able to do this. I feel fit myself for this project. please contact with me. Thanks.
$88 USD en 1 día
4,8 (24 comentarios)
4,5
4,5
Avatar del usuario
Hi, I went through your requirement, and its a great idea to consolidate the costs in the master review sheet. I think you might need to also consider 3 things. 1> All data in the master review needs to be sorted by dispatch number and then by months. This will give you a better understanding of how a particular dispatch has been trending (cost + invoice). If this is not sorted, then it will becomes a tedious exercise to get such an understanding 2> you can consider displaying this information (from Pt1) for any chosen dispatch number graphically. It will be very effective to get a visual representation 3> Indicators: Lets assume that as a business you have a target to ensure that each dispatch had invoice 90% or 100% every month or 90% or 100% of cost. then maybe you can also have a functionality where any dispatch where this is not true can be highlighted in red, or shown as a separate report I have over 15 years of creating customized excel based solutions for companies like Dupont, Volvo, Accenture, Pratt and Whitney. I pride myself on the quality of work I provide to my customers and the value add I bring to any project that I am associated with. My rates are aligned to this value add and quality. Ofcourse you can try some of the $100 bidders and hopefully they wont waste your time, or you can msg me and I will be glad to discuss your requirements in greater details and also talk about, what we can do to make it better and effective Regards Amin
$300 USD en 3 días
4,9 (6 comentarios)
4,3
4,3
Avatar del usuario
hello there, I understand your calculations, I `m working now on your excel sheet, just chat with me to discuss more details, I have done many excel sheets equations and calculations good luck!
$55 USD en 1 día
4,9 (9 comentarios)
3,9
3,9
Avatar del usuario
Hello I would be happy to help with you query. For reference I would create a button on the master review sheet where this would create a list of unique dispatch numbers to populate into the Dispatch number column. Then I would create a formula in the cost and invoice columns to reference in each month's costs/invoices for that dispatch number. The button would need to be pressed for the master sheet to be populated for new dispatch numbers but this will be quick for the macro to perform the calculations. If this sounds reasonable to you I will be able to get started asap. As background, my name is Steve, I have worked for a global financial services industry based in the UK for over 10 years where I worked with large and complex Excel spreadsheets on a daily basis. Over my 10 years I progressed to become the main port of call for all Excel queries and became the local technology champion for my office. This role required me to design very complex excel and calculations and also required me to automate systems using VBA macros. I hope to hear back from you soon. Kind regards Steve
$100 USD en 1 día
5,0 (8 comentarios)
3,9
3,9
Avatar del usuario
Dear client, I can write a VBA macro to automate this. I will also provide an interface that will allow you to add new tab for the months. Looking Forward
$133 USD en 3 días
4,9 (7 comentarios)
3,7
3,7
Avatar del usuario
Thank you for the opportunity.. I have good experience in this project . i want to do this task . please give me a chance . i will do give you very good service for my best .
$100 USD en 3 días
4,8 (9 comentarios)
3,4
3,4
Avatar del usuario
Hello Sir , i am excel expert ...i can do this job ...Message me so i can start work ..........
$35 USD en 3 días
5,0 (1 comentario)
2,1
2,1
Avatar del usuario
Dear Boss, I can start your project form today. But if you need urgent So I can start from right now . I have very Good Experience about any kind of lead generation, Data Entry, and Data Scraping jobs .kindly give me a chance to working with you. Please Boss response me, I am here waiting for your good news . Boss you can test me before hiring. thank you so much for posting this jobs ! Regards Raisul Islam
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Hiring Manager Thank you for your clear job description. I have read your requirement at my best. I am highly interested to work on your project, please confirm me to start the work from now. I have enough experience on Microsoft Word, Excel, PowerPoint, Data Entry, Copy Writing Thank you for your clear job description. I have read your requirement at my best. I am Dear, Online Searching and Data Support. I am sure to meet your criteria and I shall assure you to give a best work. As per my understanding, my job is as follows: 1) Data processing ,excel work as your requirement. Please share your all document after that I can start the work from now. I am interested to make a long term professional relationship for your future project also. I shall be able to deliver your project with a minimum cost and within your given timeline. Please confirm me to start the work from now. Eagerly waiting for your response. Thanks, Muktaram
$30 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am interested in your projects and also interested to long term relationship. Inbox me details. Waiting for your reply. Thanks Sudarson
$133 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Create tabs for all months. Build out array's on Master Review tab for totals. May need to created a reconciliation tab for 'Dispatches'. Dispatches tab with start date maybe?
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will create this excel file for you hassle free
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Queen Creek, United States
5,0
8
Forma de pago verificada
Miembro desde abr 29, 2015

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.