Find Jobs
Hire Freelancers

Spreadsheet

£10-20 GBP

Completed
Posted 6 months ago

£10-20 GBP

Paid on delivery
I am looking for a skilled freelancer to create a data analysis spreadsheet for my project. SPREADSHEET INSTRUCTIONS >>>> Spreadsheet on excel to calculate the required pace based on the logic. Here's a step-by-step guide: * Open a new Excel spreadsheet or Google Sheets document. * In cell A1, enter "Total Steps Completed So Far" as a header. * In cell A2, enter the total steps you have completed so far. * In cell B1, enter "Average Pace of Brisk Walking So Far (mph)" as a header. * In cell B2, enter the average pace of brisk walking steps you have completed so far. * In cell C1, enter "Current Day of the Week" as a header. * In cell C2, enter the current day of the week as an integer (e.g., 4 for Thursday). * In cell D1, enter "Remaining Steps Needed" as a header. * In cell D2, enter the following formula to calculate the remaining steps needed:


Copy code=MAX(0, (7 * 3000) - A2) * 

 * In cell E1, enter "Remaining Days in the Week" as a header. * In cell E2, enter the following formula to calculate the remaining days in the week: Copy code =MAX(0, 7 - C2) * In cell F1, enter "Remaining Brisk Walking Steps Needed" as a header. * In cell F2, enter the following formula to calculate the remaining brisk walking steps needed: Copy code =MAX(0, (7 * 3000) - A2) * In cell G1, enter "Average Pace Required" as a header. * In cell G2, enter the target average pace for the week, which is 3.5 mph. * In cell H1, enter "Pace Deficit" as a header. * In cell H2, enter the following formula to calculate the pace deficit: Copy code =MAX(0, G2 - B2) * In cell I1, enter "Pace Adjustment" as a header. * In cell I2, enter the following formula to calculate the pace adjustment: Copy code =IF(E2 > 0, H2 / E2, 0) * In cell J1, enter "Required Pace" as a header. * In cell J2, enter the following formula to calculate the required pace: Copy code =MAX(0, G2 + I2) Now, you can enter your current data in cells A2, B2, and C2, and the spreadsheet will calculate the required pace in cell J2 based on your inputs. Please note that this is a simplified example, and you may want to customize it further or format it according to your needs.
Project ID: 37470695

About the project

22 proposals
Remote project
Active 6 mos 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
Awarded to:
User Avatar
£0 GBP in 1 day
5.0 (410 reviews)
6.9
6.9
22 freelancers are bidding on average £22 GBP for this job
User Avatar
""""""""""""""""""""""ADVANCE EXCEL EXPERT""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
£35 GBP in 1 day
4.9 (274 reviews)
7.3
7.3
User Avatar
Hello, I'm eager to assist with your project by creating a comprehensive data analysis spreadsheet based on your instructions. Following each step meticulously, the Excel sheet will efficiently calculate the required pace for your brisk walking project. My attention to detail and proficiency in spreadsheet design ensures accuracy and functionality. Let's collaborate to tailor the tool to your specific needs. I'm ready to bring your vision to life.
£20 GBP in 1 day
4.8 (89 reviews)
6.1
6.1
User Avatar
Hi there! I can do your Spreadsheet job accurately. My experience with Visual Basic, Data Processing, Excel, Web Search and Data Entry makes me the right person to help you complete this project. I am available to start immediately upon your approval. Message me for further discussions on this project. Thank you Tom M. for your consideration. I appreciate Carolyne
£19 GBP in 1 day
5.0 (4 reviews)
4.3
4.3
User Avatar
Hello there! My name is Basanta, and I am a data entry expert with over 12+ years of experience in different sectors. I understand you are looking for a skilled freelancer to create a data analysis spreadsheet for your project. As someone with extensive knowledge in Excel, VBA/Macro, Ms Access, Work Flow Management, Power BI and more, I am confident that I can provide the solution you are looking for. I have extensive experience in creating various types of spreadsheets such as analysis, inventory tracking and more. My skills include advanced formulas, VBA/Macro programming and more which will be useful for your project. Additionally, I have a degree in business administration which gives me the necessary knowledge to handle large scale projects efficiently. I believe that my experience&skills make me the perfect fit for this project and would love to discuss further if needed! Please feel free to contact me if you have any questions or would like additional information about me or my services. Thank you for your time!
£15 GBP in 1 day
4.9 (60 reviews)
4.3
4.3
User Avatar
Hi there, Once look your sample, You can understand the my work I can help you in Spreadsheet on excel, I understand the you need Spreadsheet on excel. waiting for your response. THANKS Naveen K
£10 GBP in 7 days
5.0 (8 reviews)
4.1
4.1
User Avatar
Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the work. Will wait for your kind response ☺️ Thank You. Regards, UMAIR
£15 GBP in 1 day
5.0 (49 reviews)
4.2
4.2
User Avatar
Hey! I am always on the lookout for new and exciting projects that challenge my skills and push me to bring my best to the table. Your Spreadsheet is exactly the type of project that sparks my interest and motivates me to get involved. With years of experience in Web Search, Data Entry, Excel, Data Processing and Visual Basic, I can assure you of high-quality work that is delivered timely and meets your expectations. Collaborating with you Tom M. would not only be a valuable opportunity for personal and professional growth but also a chance to create something impactful. Please send a message to discuss more regarding this project. Regards, Wilfred
£20 GBP in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
HI, Good Day, I have noticed your project. I hope to work in project. kindly consider my bid for this project. you will get better result thanks.
£15 GBP in 7 days
5.0 (3 reviews)
2.8
2.8
User Avatar
Hi, I am an experienced excel expert and data analyst. I have read your project details carefully and I am confident that I can handle this project perfectly. Furthermore, I have recently completed similar project for my client and he gave me 5-star rating. I am sure that you will also be satisfied with my service like my previous clients. Please, come in chat for further discussion, Best regards, Noor Nawaz
£15 GBP in 1 day
4.9 (3 reviews)
1.8
1.8
User Avatar
Hello, I am excited to submit my bid for the project requiring a skilled analysis spreadsheet on a gambling topic according to your plan. With a commitment to maintaining the original tone, I assure you a polished and coherent final product. I am confident in my ability to meet and exceed your expectations. I have 4 years of experience in [mention relevant niches or industries], which has equipped me with the knowledge and understanding needed to create engaging and informative content. Whether you need blog posts, articles, website content, product descriptions, or any other type of written material, I have the versatility to adapt my writing style to suit your specific needs. I excel at in-depth research to ensure that the content I produce is accurate, well-informed, and relevant to your target audience. Sincerely,
£10 GBP in 1 day
5.0 (1 review)
0.8
0.8
User Avatar
= I understand that you are looking for a skilled freelancer to create a data analysis spreadsheet for your project. I have experience in data entry and data analysis so I believe I am the best fit for this job. My name is Huy. I'm 18 years old and study in Hoa Sen University. I have a 1 year of experience working this job in the company. I have the skills required to create a data analysis spreadsheet such as data entry, Excel skills, knowledge of formulas and calculation techniques etc. I believe that with my skills and expertise I can provide the necessary solution for your project. I would love to discuss further how my skills can benefit you and help you reach your goals for this project Thank you for considering me for this opportunity!
£10 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings sir, I have been working with several companies outside this freelance site as a Microsoft Dynamics 365, Microsoft Excel, and VBA specialist. I understand your need perfectly. I plead that you give me this opportunity to show you how good I can be at handling a task like this. Please check my portfolio, you will see the wonders my hands have worked for both medium and large companies.
£15 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
As working in a tutor company at the post of academic content creator. I was also have to make spreadsheet , so I have a experience in this .
£15 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Lincoln, United Kingdom
5.0
6
Payment method verified
Member since May 28, 2020

Client Verification

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)
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.