MODIFY EXISTING EXCEL SPREAD SHEET DESIGN: DATA ENTRY FIELDS, GRAPHS AND PRESENTATION

$30-250 AUD

Completed

Posted

about 7 years ago

$30-250 AUD

Paid on delivery

EXCEL SPREAD SHEET DESIGN: DATA ENTRY FIELDS, GRAPHS AND PRESENTATION I need to effectively measure clients progress and present this to them in a professional looking graph for various strength and aerobic exercises. Attached IPPT excel sheet draft with data entry fields and corresponding chart to measure progress with key and trend lines. • In the existing setup I’ve listed my strength exercises below the data entry fields. These are the exercises I want to track progress for clients by date (x) and weight values (y) in the graphs axis's and must be added to the data entry fields. • Below the strength based exercises I’ve listed the aerobic exercises I want to track progress for clients by date (x) and either distance (y) or time (y) values in the graphs axis's and must be added to the data entry fields NOTE: Due to there been a distance (y) and a time (y) graph axis we require two graph's for the aerobic exercises. NOTE: Require separate excel sheets for strength and aerobic exercises if required we could have 1-2 for aerobic exercises. Require those strength and aerobic exercise fields but also the ability to add more easily which will be incorporated into the graph. All exercises listed must have: Data entry field Key on graph Specific trend line on graph (as per the existing) Should be able to show a printed PDF presentation of this information for the table and graph based progress in a professional manner with company logo (to be provided). Existing setup linked to the graph extends axis when you add higher weight values (y) e.g. 180kg. The graph will automatically increase the value of the graph on the y axis. This must be the case for all other data entry fields added and new ones. Attached existing excel sheet setup with further information. Require this to be modified as detailed above and built with additional exercises listed.

Data Entry

Data Processing

Excel

Project ID: 13315581

About the project

32 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@telfordm

Hi, I am a native Australian finance professional (Melbourne based) with over 15 years experience using Excel. I have built a variety of different Excel models and reporting dashboards, and I can help with your project. I would propose to complete your project by firstly understanding following things: - do you propose to have a new workbook for each client? Or do you propose to include them all in the one spreadsheet? - do you have a feel for how many different graphs you would like? Some of the data (i.e. the strength data) will be difficult to all put into one graph. Is there a logical way that you could see this divided up? - am I correct that there are 10 aerobic exercises that you would like to measure? - are the strength exercises and / or the aerobic exercises all likely to be completed on one day? Or varied? - are you ok with format changes in the spreadsheet? I welcome the opportunity to discuss your project further and to work with you. Thanks & regards Melanie

$150 AUD in 10 days

5.0

(12 reviews)

4.3

32 freelancers are bidding on average $142 AUD for this job

@jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am #1 Excel VBA and Macro programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% 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 sample work before you consider awarding me the project. Thanks, Jay

$150 AUD in 2 days

5.0

(843 reviews)

9.0

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

$200 AUD in 2 days

4.9

(477 reviews)

8.4

@cgullapalli

Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra

$100 AUD in 1 day

5.0

(1107 reviews)

8.3

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet 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).

$150 AUD in 5 days

4.9

(406 reviews)

8.2

@KulfiSoftwares

ZERO ERROR GUARANTEED!! Please read my 170+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.

$200 AUD in 2 days

4.9

(365 reviews)

7.9

@javed1705

A proposal has not yet been provided

$210 AUD in 1 day

4.9

(113 reviews)

6.8

@cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/

$100 AUD in 2 days

4.8

(201 reviews)

7.2

@dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$200 AUD in 10 days

4.9

(175 reviews)

6.5

@sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

$156 AUD in 3 days

4.6

(102 reviews)

6.3

@satishtl

- Can get the excel automated to have the aerobics data collected and represented in graphs. - Display the progress made in terms of date, distance and time. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables

$130 AUD in 3 days

4.7

(51 reviews)

6.1

@AnumZia

I am a graduate in business administration and I can speak and write English well. I am proficient in Data entry, Email collecting, Web research, Excel, Copy Typing, Copy writing, Photoshop Photo Editing, Video Editing, Video Services, After Effects, Animation, Illustration and Admin support tasks. If you hire me, I will do my utmost best and you will be more than satisfied with the results. I am a professional, honest, and punctual human being. I will be available as needed. Please do work with me once and you would never need another VA again.

$31 AUD in 1 day

4.9

(45 reviews)

5.3

@bluefox4ever

Dear Hiring Manager, I want to do your job/project now, let's start immediately. I have read the job description. I've been working in a BPO company for more than 13 years now. My job there honed my skills to be a web search expert, MS Excel expert & MS Word expert. I have good analytical skills and I'm very keen to details. I'm a returning freelancer (not searched and accepted jobs/projects for a few years) so please give me a chance and read my past reviews. My typing speed is 35wpm. I'll try my best to complete it on time and I guarantee 100% accuracy in all my works. I'm available for work on your job/project at this Philippines times (UTC/GMT +8 hours): 5 hours during weekdays (10am-3pm PHT) 10 hours during weekends (10am-8pm PHT). Regards, Oliver

$111 AUD in 7 days

5.0

(14 reviews)

4.2

@Ramez125

Hello I am with more than 3 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards

$30 AUD in 0 day

4.8

(27 reviews)

4.5

@nimesha1994

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right now. I have extensive web search and data entry experience. I have huge knowledge Data entry advantage other task easily and having ability to give back to you fine result. So you can select me for a good result. # My objective is to provide 100% fast and accurate service to my client. # Organize data before inputting. # Attention to detail and accuracy when inputting information. # knowledgeable in microsoft office. I’m hard worker and my goal is client satisfaction to provide the best quality services. Thank You for your time and consideration. Sincerely, Nimesha

$85 AUD in 3 days

5.0

(8 reviews)

4.2

@humayoonsheikh4u

Dear sir, I am an excel professional having hands on expertise in developing spreadsheets for analysis purpose. I have go through your project requirement in details and willing to do it as per your requirement. it seems that you need a dashboard for visualization. Best regards humayoon

$164 AUD in 3 days

4.7

(12 reviews)

4.2

@tutraduccion2010

Hello, I work with Excel on a daily basis, mostly parsing and analyzing data, noticing trends and doing recommendations based on them. I've read your project's description and reviewed the attached Excel file, it's clear what you need done and what you expect from this project. Feel free to contact me through private message if you have any questions or need further information, I'm available to start right away. Kind regards, Adriana

$100 AUD in 5 days

5.0

(5 reviews)

2.7

@Riz31

I have a 13 years if experience....curenntly working as PMO head.....let me help you

$144 AUD in 5 days

0.0

(0 reviews)

0.0

@brunommg

Hello! I am Bruno and I am here to help you with your issue. Depending on the size and content of the task, the payment level can be discussed. If you detail the task a little bit more, we can get an agreement on the budget. I have good experience and knowledge on Excel, as well as a certificate from the Cambridge English Language Assessment. Please contact for further details. Best Regards

$170 AUD in 3 days

0.0

(0 reviews)

0.0

@priyankpadaria

Please share your project verticals so that we can start over our project ASAP.

$125 AUD in 9 days

3.0

(1 review)

0.0

@kexpansions

expert in data entry, data processing, data computing and more. with over 9 years of experience, i have successfully helped my clients with related jobs. Please send me details of the project. looking forward to your reply. Thanks for the opportunity.

$277 AUD in 1 day