Find Jobs
Hire Freelancers

Hire an Excel Expert - Excel Mastersheet required

$10-30 AUD

Terminado
Publicado hace más de 6 años

$10-30 AUD

Pagado a la entrega
Hi, I am looking for an Excel Expert to create x3 master sheets to compile and sort data that I download in excel files on a weekly basis (see example of "Odds" type attached). I download Football match data (x3 different types) from various different leagues. It all comes on a spreadsheet with all leagues mixed together. I would like you to create a sheet for each league (x3 for each data type) that populates the new data each week. So let's say I have the master sheet open and I download the new weekly data for all leagues. I will save it to the same file name each week, the master sheet must populate each sheet with the new league specific data, cumulatively adding it to the existing data (not replacing). The part that is beyond my Excel skills (and why it may need a macro) is the league sheets will cumulatively add each week's data. Whereas the weekly downloaded data will just contain one week every time. This should be a simple task for an Excel expert. I look forward to your proposals. Thanks
ID del proyecto: 15175010

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 7 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
My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and IT and several decades experience in system design and programming in Excel and VBA. Proposed Milestones $25 AUD - Whole project. Additional Services Offered $0.01 AUD - In my approach you'll have opportunity to consult details with me, to test pilot solutions, etc. $0.01 AUD - Consult details, test pilot solutions. Use of macros, fixing of bugs and minor changes are free. $0.01 AUD - Further use of macros, fixing of bugs and minor changes are included without any additional fees. $0.01 AUD - I can start working on the project immediately and complete the job within some hours.
$25 AUD en 1 día
4,9 (62 comentarios)
5,7
5,7
27 freelancers están ofertando un promedio de $46 AUD por este trabajo
Avatar del usuario
Greetings sir, i can help you to to create x3 master sheets to compile and sort data that I download in excel files on a weekly basis and your 100% satisfaction is assured if you allow me to serve. Relevant Skills and Experience I have more than 7 years of experience in excel , macros. Proposed Milestones $50 AUD - Once project is done
$50 AUD en 1 día
5,0 (275 comentarios)
7,6
7,6
Avatar del usuario
Hi Sir/Mam, It is being my pleasure to introduce you to me. I have taken a look at your project description and I am confident that we can work together. I am expert in advance excel. I have knowledge of lots of formulas like countif, sumif, pivot, trim and vlook-up with match. Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786
$25 AUD en 0 día
5,0 (298 comentarios)
7,7
7,7
Avatar del usuario
I have experience in dealing with a number of excel macro based projects. Relevant Skills and Experience 10 years of excel automation experience. Proposed Milestones $150 AUD - Project delivery and acceptance
$150 AUD en 2 días
5,0 (172 comentarios)
7,3
7,3
Avatar del usuario
Hey Mate, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$94 AUD en 1 día
4,9 (158 comentarios)
6,4
6,4
Avatar del usuario
A proposal has not yet been provided
$50 AUD en 1 día
4,9 (279 comentarios)
6,6
6,6
Avatar del usuario
fetch odds data from website automatically Relevant Skills and Experience web scarping/excel Proposed Milestones $100 AUD - Complete tool Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
$100 AUD en 7 días
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones $25 AUD - 100% milestone and release upon completion
$25 AUD en 1 día
4,9 (69 comentarios)
5,5
5,5
Avatar del usuario
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones $35 AUD - VBA Excel
$35 AUD en 1 día
4,9 (40 comentarios)
5,2
5,2
Avatar del usuario
Hi, I am CPA by qualification, having experience of more than 6 years in a reputed MNC as a Financial Analyst, having good knowledge in Accounting and well versed with various Accounting software. Regards Pooja shah
$25 AUD en 1 día
4,9 (27 comentarios)
5,0
5,0
Avatar del usuario
I am an Excel expert. My specialization is creating complex formulas and macros.
$35 AUD en 2 días
4,7 (61 comentarios)
5,3
5,3
Avatar del usuario
Hi I went thru the description, What kind of master sheet you have? It's pretty interesting job Pls contact me and will need to discuss more to understand thanks thushara Relevant Skills and Experience Excel, VBA, Macro Proposed Milestones $20 AUD - once done I need to see the master file, this job can be done. May be I will give you a button to run weekly
$20 AUD en 1 día
5,0 (24 comentarios)
4,2
4,2
Avatar del usuario
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! Relevant Skills and Experience We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Proposed Milestones $30 AUD - Depends on the quantity of work.
$30 AUD en 1 día
4,9 (14 comentarios)
4,3
4,3
Avatar del usuario
Dear Hiring Manager, I have read the project description and I understand that you would like to segregate the data into 3 sheets from he data you download on weekly basis, ensue that the data is appended in each sheet. I have worked on similar projects and recently closed few using VBA/Macro. I will create macro for this. Looking forward to hear from you. Regards Chintu
$26 AUD en 3 días
5,0 (6 comentarios)
3,8
3,8
Avatar del usuario
I can do this. do let me know more detail
$55 AUD en 2 días
4,9 (15 comentarios)
3,6
3,6
Avatar del usuario
A proposal has not yet been provided
$25 AUD en 1 día
4,9 (10 comentarios)
3,7
3,7
Avatar del usuario
I'm a certified expert level Excel user who also trains companies on how to use the software. What you are asking for can be done simply in one day. I look forward to working on this for you. Relevant Skills and Experience Certified Excel expert Six Sigma Black Belt Graduate degree in engineering Proposed Milestones $111 AUD - Project completion
$111 AUD en 1 día
5,0 (2 comentarios)
3,2
3,2
Avatar del usuario
I am a professional typist. I am having a typing speed of 45-50 words per minute with perfect spelling. I am having experience of data entry of 3 years. I can handle this project with much ease Relevant Skills and Experience Excel, Word, Typing, Data Entry. Proposed Milestones $16 AUD - I can complete it well and before time
$16 AUD en 1 día
4,9 (8 comentarios)
3,0
3,0
Avatar del usuario
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time.
$30 AUD en 2 días
5,0 (2 comentarios)
2,4
2,4
Avatar del usuario
About me: Graduated from statistic department in faculty of economic & politic science, Cairo University. Sub-specialized in social science computing Cum. Grade: Good Graduation project grade: Excellent. How can I help you? I have a high scale of experience in statistics analysis and report writing and I can help you in: Regression Analysis: multiple,simple, linear or non-linear Time series Analysis Experimental Designs Factorial analysis : explanatory factorial analysis (EFA) or confirmatory factorial analysis (CFA) SEM Modeles: confirmatory factor analysis, path analysis, partial least squares path modeling, and latent squair modeling. Statistical Modelling of data ANOVA & MANOVA Tables Descriptive Statistics hypothesis testing and t tests & Chi-square test Panel Data Modelling Principle component analysis What packages can I use? I am familiar to do statistical analysis using SPSS, MATLAB, R, STATA and Minitab What My work include? A report with all the results obtained Nice interpretation of the tables, graphs & tests Describing statistical methods I used.  looking forward to here from you soon
$25 AUD en 2 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Hello, I've read your description and I can create the macro you that will do this job. Which are the 3 leagues you want to save? Please contact me for details. Thanks! Relevant Skills and Experience Excel, VBA Proposed Milestones $20 AUD - Project
$20 AUD en 1 día
0,0 (0 comentarios)
3,4
3,4

Sobre este cliente

Bandera de AUSTRALIA
melbourne, Australia
5,0
8
Forma de pago verificada
Miembro desde ene 2, 2017

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.