Find Jobs
Hire Freelancers

Create VLookup excel worksheet for gym member tracking

$30-250 AUD

Concluído
Publicado há mais de 9 anos

$30-250 AUD

Pago na entrega
Create a VLookup EXCEL worksheet that I can update weekly or monthly with new data and then keep a running total of member check-ins Broadly speaking - we would like to start a member reward program that includes different levels of attendance i.e. platinum, gold, silver etc in accordance to the members amount of check ins. This will be a new monthly task for all club managers to export data regularly based on the last 30 days check-in and load somewhere (excel or something). Member reward titles: > Club Purple Member – 1000 check-ins > Platinum Member – 500 check-ins > Gold Member - 250 check-ins > Silver Member - 100 check-ins > Bronze Member - 50 check-ins > Rewards Program Qualifier - 25 check – ins Examples of raw data will be available to the right candidate. Please be prepared to provide a detailed proposal for the execution of this project.
ID do Projeto: 6651226

Sobre o projeto

37 propostas
Projeto remoto
Ativo há 9 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
Concedido a:
Avatar do Usuário
Let me create a dashboard for you that will have necessary information selectable in a dynamic way (say you can select Gold Members and it gives you checkins, with top 10 clubs list and so on). I am working as business process improvement professional with extensive knowledge in Excel and Processes streamlining. I managed Excel improvements materials for such companies as AOL, DELL and L’Oreal etc. I will provide you with a high quality and time committed service with outcomes match your needs and look professional and attractive. I can provide you with Excel that will automate majority of these tasks .
$70 AUD em 3 dias
5,0 (13 avaliações)
4,9
4,9
37 freelancers estão ofertando em média $112 AUD for esse trabalho
Avatar do Usuário
Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$85 AUD em 3 dias
5,0 (822 avaliações)
8,8
8,8
Avatar do Usuário
Hi there! I'm an excel expert and I would like to help you with your project. Please consider my proposal and contact me to discuss further details. Regards.
$60 AUD em 2 dias
5,0 (474 avaliações)
8,0
8,0
Avatar do Usuário
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$94 AUD em 5 dias
4,9 (353 avaliações)
8,0
8,0
Avatar do Usuário
Hello! Please share further details of the project and get Vlookup help at affordable price. Thanks
$147 AUD em 3 dias
5,0 (390 avaliações)
7,7
7,7
Avatar do Usuário
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets and formulas. I can easily solve your project. Check my reviews and chat with me. greetings
$45 AUD em 5 dias
4,9 (304 avaliações)
7,3
7,3
Avatar do Usuário
Hi: I have few questions: What format will the data be in (Excel file or text file)? Will the raw data be cumulative (all checkins) or periodic (only for a particular period)? Do you want a summary sheet as the final output where you can see the member name, number of check-ins and his status? Please note that I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more.
$77 AUD em 3 dias
4,9 (171 avaliações)
7,1
7,1
Avatar do Usuário
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$100 AUD em 1 dia
4,9 (175 avaliações)
6,6
6,6
Avatar do Usuário
I am an ACCA(UK) professioanal , APA and Mcom finance. Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing said assignment/job, . i have more than 8 years of experience in advanced excel hire me at fordable cost with best results, readily available for said task........ regards javed
$64 AUD em 2 dias
4,9 (101 avaliações)
6,8
6,8
Avatar do Usuário
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already developed lots of excel based tracking models for various businesses. If you are comfortable with all above along with my ratings and reliability, please send me the information to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$90 AUD em 3 dias
5,0 (186 avaliações)
6,7
6,7
Avatar do Usuário
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$111 AUD em 3 dias
4,9 (114 avaliações)
6,5
6,5
Avatar do Usuário
Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed ANYONE TILL date. I have done more than 130 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Please note that there are lot of time wasters here. If you do plan to select me then I would request you to please explain or give me a sample so that I can give you a demo which will ensure that your time and my time is not wasted.. :) Hope to work with you. Regards Sid
$111 AUD em 1 dia
4,9 (173 avaliações)
6,6
6,6
Avatar do Usuário
Hello, I'm Excel and VBA programmer with over 5 year of experience. I have written many different applications for Excel in recent years. I am confident that I can perform this task. I am currently working in a large trading company in Europe. Thank you very much Jan Krzyzak
$100 AUD em 3 dias
5,0 (97 avaliações)
6,2
6,2
Avatar do Usuário
I am willing to discuss further about the project specifications and deliver the same to your needs .
$264 AUD em 3 dias
4,9 (50 avaliações)
6,0
6,0
Avatar do Usuário
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. If you send me a sample file, I'm ready to create a free draft pilot for you. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$61 AUD em 2 dias
4,9 (64 avaliações)
5,7
5,7
Avatar do Usuário
Hello, Not knowing the exact structure of the data makes it difficult to outline my proposed solution in detail but based on the brief I would envision something along the lines of the following: 1) Each branch location would have a spreadsheet tool where they collect their user information on a daily basis. 2) Within this spreadsheet there would be code that would enable the user of the branch location to press a button and export their data and send via an Outlook email to a defined email address. 3) There would be a separate Master tool that would allow a user to press a button and select the file they would like to import and the code would import that data into predefined areas in the workbook that have reporting tied to it. Some things to keep in mind would be the users' availability to Outlook as well as what version of Excel is being used.
$95 AUD em 3 dias
4,8 (69 avaliações)
5,5
5,5
Avatar do Usuário
Hi, We are a group of analysts working in excel based tool and dashboard design for last 10 years. We can very well do the job. Here is what we can provide based on your requirements. 1. An Excel based worksheet which will have the option to take information from other work sheets from same workbook, collate and will process the information based on logics, and finally will produce the report you want. 2. As a pre-requisit you need to however bring all the input sheets ( raw data from managers) into the interface workbookmanually At this tage if you can provide us with a sample raw data and the calculation details you want,we would send a detailed design plan and then you can decide on the bid. Kindly message for any further details. Regards, Pal
$60 AUD em 5 dias
5,0 (24 avaliações)
4,9
4,9
Avatar do Usuário
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my kind of work. I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$100 AUD em 2 dias
5,0 (35 avaliações)
5,0
5,0
Avatar do Usuário
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. I will submit a more detailed proposal after having a look at the data.
$250 AUD em 3 dias
4,9 (10 avaliações)
3,7
3,7
Avatar do Usuário
I have gone through your requirements as specified in the project description and would like to confirm my ability and availability to assist you in this assignment. I am an excel professional with a proven record of preparing excel project per customer's specifications. My performance on previous such projects can be gauged from customer's testimonials on my profile page. I am looking forward to hearing back from you on this! Kindly send me a PM in case you have any questions/concerns. ============================================================================= Brief info About me ------>>>>> I am a multi-faceted professional having 4 years of experience, starting from working as a research assistant at Georgia Tech, Logistics Analyst at Nokia, Sales & Operations Manager at Sandisk to starting my own company which provides consulting/freelancer services. I have a Masters in Supply Chain Management (IE) from Georgia Tech.
$147 AUD em 3 dias
5,0 (4 avaliações)
3,7
3,7
Avatar do Usuário
I have 20+ years of experience of Spreadsheet modelling using Excel & VBA I have developed Retirement Fund Application that serves 7,500 employees of a company. This application handles individual accounts, operational matters, cheque printing and complete accounting. Understanding on your task: 1) Each manager will submit data , either directly or through email 2) That data will be merged with old data 3) Customers will analysed and they will be oferred rewards as per their commitment with GYM What the solution will look like: 1) Standard format file , that each Manager will send through email and saved in a specific folder 2) A main program will consolidate data from different Managers 3) identify customers eligible for certain compensation 4) Letter/email to respective customer for his status 5) Record of benefits availed by customers 6) Analysis / Dashboard reports on benefits availed and benefits lapsed.
$388 AUD em 10 dias
5,0 (4 avaliações)
3,5
3,5

Sobre o cliente

Bandeira do(a) AUSTRALIA
Sydney, Australia
5,0
1
Método de pagamento verificado
Membro desde out. 22, 2014

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.