Find Jobs
Hire Freelancers

Build an Athlete Template for Tracking Performance Metrics in Excel

$400-900 CAD

Closed
Posted about 8 years ago

$400-900 CAD

Paid on delivery
How does this look for a write-up: We are looking to design an excel based powerlifing template. The end version of this template will be a spreadsheet that athletes can use to program their workouts and track important performance metrics over time. The workout template will need to include various training variables such as: type of exercise, number of sets, number of reps, the weight used, rest, and tempo of movement. Once the template is designed, athletes will use the spreadsheet to fill in the training variables mentioned above. Within the spreadsheet, however, athletes need to have the ability to write their own 3, 4, or 5 day training programs. As well, each program needs to have the ability to be designed into 3 to 6 week blocks of training. We have already created a beta version of this document to help guide the freelancer, which can be made accessible when contracted. The aspect of this template that needs further coding skills is in creating the functions that allows the athlete to see their performance metrics over time. Two key performance metrics need to be tracked within the template: volume of a lift (weight used * sets * reps) and average intensity (i.e. the average weight of each lift). We need to be able to see these metrics on a daily, weekly, and yearly scale. For example, an athlete can perform a squat at 100lbs for 5 sets of 5 reps. The volume for this workout is 2500lbs with an average intensity of 100lbs. We need the template to be able to calculate these metrics , as well make it available in a graph form. Importantly, however, athletes need to be able to have the ability to track their squat metrics (or any other lift) for each session, over multiple weeks and months. More information on the product will be discussed when contracted. Important skills the freelancer needs to possess: -Complex excel functions -Analytical skills -Report building capabilities -Marco & Excel VBA coding
Project ID: 9296189

About the project

12 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $633 CAD for this job
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$600 CAD in 7 days
4.9 (73 reviews)
6.2
6.2
User Avatar
Hello there, I am an expert in Excel and have done more than 475 spreadsheet templates here on freelancer with excellent ratings. As required, I can assure you that I know Complex excel functions, my Analytical skills are excellent, I have done several reports (some example in my profile and can share more) and I am an excellent Marco & Excel VBA programmer. You may see comments of the clients with whom I have worked and they echo the same sentiment. I reviewed the requirements brief you shared and have a high level understanding of what you are looking for. However, I would need more detailed requirements and any look and feel preferences (color combinations, logos etc.) that you may have and based on those, would be able to suggest the best way to go about creating the performance tracking template. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you. Thanks and Regards, Rishi
$666 CAD in 10 days
4.9 (95 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
$600 CAD in 5 days
5.0 (57 reviews)
5.7
5.7
User Avatar
Hi. Your job seems to be fitting to my skillset. (I'm quite good at excel) I have a 6 years of business analyst experience in a global company and 3 years data scientist experience. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. Just drop me a message so that we can discuss further.
$890 CAD in 7 days
5.0 (72 reviews)
5.7
5.7
User Avatar
Hello Sr., how are you ? Jorge is my name and I have experience doing programs using VBA Code (with Excel for example). Several solutions I've created merging VBA Code and EXcel for different customers. You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed. i'm interested to help you on this particular project. What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal. No more Sr.; contact me if you'd like it and I will do the best, Regards. Jorge. P.S.: I will not accept any award before to discuss with you all the details needed.
$780 CAD in 7 days
5.0 (54 reviews)
5.8
5.8
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 55 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$526 CAD in 7 days
4.9 (45 reviews)
5.2
5.2
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$500 CAD in 7 days
4.8 (14 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$694 CAD in 5 days
4.8 (3 reviews)
3.8
3.8
User Avatar
Greetings. I have read your project description and I think it is really very interesting to develop all these metrics calculations. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts and data manipulation. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you for your time.
$722 CAD in 7 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Hi there! As a Freelancer newbie I am willing to complete this project for the base rate to help improve my reputation. My most recent Excel/VBA project involved tracking animal movements on cattle properties (ranches) in Australia on a month by month and yearly basis. Variables to be recorded included animal weights, calves branded, livestock sales/purchases and more. VBA coding was required to provide the ability to: Setup property data (paddocks, varying classes of cattle etc) Enter ‘opening’ figures for the cattle herd Add ‘events’ whilst also controlling the user’s input variables. Functionality was also created to report on and view the progress of the business using actual herd performance (eg weight gain) and external factors (eg rainfall) on a monthly basis with a yearly summary. Thank you for your consideration in completing this project. Regards Nic Walker
$400 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have all the Excel skills to complete this project. I pay attention to detail and format my work for professional quality. Graphs can include a secondary axis if necessary to compare multiple metrics using different measures.
$661 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an athlete too. I'm a 16 times Ironman in Triathlon. I have been doing administration and reporting of my performance in Excel for 20 years. As a financial planning and controlling expert I have the professional competence too. If you want to be more convinced of me, please send further questions or details. Best regadrs Endre Mate (ProfSmart)
$555 CAD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Canada
0.0
0
Member since Sep 29, 2014

Client Verification

Other jobs from this client

Do some Excel Work
$250-750 CAD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.