Excel Formula Development for Scorecard

$10-30 USD

완료함

게시됨

5개월 전

$10-30 USD

제출할때 지불됩니다

I'm seeking a proficient Excel user to help me with a specific problem. I need to calculate yes/no questions on a numerical scorecard, accounting for null cells. Here's what I am looking for: * Average of yes/no responses for cell E10 located on the following 17 worksheets (they are the names of the worksheet): SBT FB - Ashley Meredith SBT FB - Bruce Tworeck SBT FB - Carissa Romero SBT FB - Chris McBratney SBT FB - Danae Bell SBT FB - Danielle Reber SBT FB - Erica Shirer SBT FB - Jenna Laporta SBT FB - Jenna Rohrs SBT FB - Kayla Drost SBT FB - Kimberlee Cooper SBT FB - Lani Harrell SBT FB - Mackenzie Wilkening SBT FB - Mercede Hutchinson SBT FB - Morgan Isham SBT FB - Nicole Foster SBT FB - Wayne Freeman * Note that "yes" is equal to one point while "no" is 0 points. * Account for null cells in computation because some Testers did not enter a value; therefore, the score needs to be normalized so that their worksheet isn't counted in the average. The project involves conditional formatting. Your expertise with numerical data in Excel will be particularly relevant for this project. Ideal Skills: * Advanced proficiency in Excel * Expert experience with conditional formatting * Ability to work with multiple worksheets I need this completed right now. I am working and have to have it figured out tonight. * Strong numerical data analysis skills Thank you.

프로젝트 ID: 37610620

프로젝트 정보

34 제안서

원격근무 프로젝트

활동 중 5개월 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@freelancerabdu34

$0 USD 1일에

5.0

(95 건의 리뷰)

5.6

34 이 프로젝트에 프리랜서들의 평균 입찰은 $22 USD입니다.

@sultanang464

As an Excel specialist with over six years of experience encompassing data entry, processing and analytical assignments, I am confident in my ability to contribute effectively to your project. Throughout my career, I've demonstrated an advanced proficiency in Excel, which I believe sets me distinctively apart for this task. My specialization in conditional formatting aligns perfectly with your requirement to develop complex formulas for scoring a numerical scorecard. What you can depend on from me is not only the incorporation of null cells, with their scores adjusted and worksheets consequently excluded, but a highly organized outcome delivered with speed and accuracy. My strength in numerical data analysis underscores my capacity for quick yet meticulous calculations; a vital skillset for this project and any projects I undertake. Lastly, let me assure you that once we commence work, your satisfaction will become my utmost priority. Dedication to meeting aggressive deadlines without compromising quality is something I consistently adhere to. With this promise of top quality and timeliness backed by my 24-hour online availability, hiring me means gaining a partner dedicated to your success. Let's get the scorecard perfected tonight!

$30 USD 1일에

5.0

(306 건의 리뷰)

7.4

@daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$20 USD 1일에

4.8

(247 건의 리뷰)

7.3

@Giovanni704

Hi there! I possess advanced proficiency in Excel, including extensive experience in handling numerical data analysis and working across multiple worksheets. Understanding the nuances of your specific request, I excel in calculating averages of yes/no responses for cell E10 across the 17 designated worksheets while accounting for null cells. My expertise in conditional formatting allows me to accurately compute scores, assigning one point for "yes" and zero for "no," ensuring normalization for null values to maintain accuracy in the final average. I recognize the urgency of your project and assure you of my commitment to providing a solution promptly while maintaining precision and quality in the computations. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. Send me a message so I can show you my previous work and we can discuss more. Respectfully, Giovanni.

$10 USD 1일에

4.9

(62 건의 리뷰)

7.1

@SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.

$30 USD 1일에

4.9

(130 건의 리뷰)

6.6

@Sunitav36

Hi, I am interested in this project and i am ready to do it for you. To proceed further, I am ready to discuss your project and start immediately. Thanks

$20 USD 1일에

4.6

(24 건의 리뷰)

3.9

@pixelstudio0077

Hi Good evening I have reviewed the complete description of your project and I'm confident I will meet your expectations and give you 100% satisfaction and quality work. My expertise includes Data Processing, Excel, Mathematics, Statistics and Data Entry. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/pixelstudio0077 -Why me or reason to consider me: ✅ Promise to manage UNLIMITED REVISIONS until your complete satisfaction. ✅ Deliver all necessary files with complete copyrights for the final design. ✅ Guaranteed On-Time delivery. ✅ 100% satisfaction guaranteed. I'm all set and available to start working on it right away. It will be a pleasure if you will give me an opportunity to turn your idea into reality. Let's chat now!! Regards, Osama K.

$10 USD 1일에

5.0

(2 건의 리뷰)

2.9

@shishir1166

With my advanced proficiency in Excel and extensive experience with data analysis, I am perfectly positioned to help you with your scorecard project. My skills in creating complex spreadsheets, utilizing advanced functions, creating macros and VBA programming along with deep familiarity with statistical concepts necessitated by this task will be a great asset for developing the formulas you need and achieving the desired results. Furthermore, I can expertly handle conditional formatting to ensure that all the null cells are accounted for in your calculations. Given that some testers did not enter values, normalizing their worksheets is crucial to provide an accurate average score. I assure you that I possess not just theoretical knowledge but also practical expertise to tackle these challenges effectively. Finally, my ability to work with multiple worksheets of various names makes me the ideal candidate for this project. Considering that you require this project completed on an urgent basis, partnering with me would be the right choice as it promises both quality and promptness.

$20 USD 1일에

5.0

(6 건의 리뷰)

3.0

@khanpress713

With over five years of experience using Excel, I have become adept at handling even the most complex numerical data tasks. My expertise in conditional formatting, advanced formula development, and implementing worksheet operations will be key to achieving the goals of your scorecard project. I effortlessly manage multiple worksheets on Excel and possess a sharp eye for detail which is crucial in accounting for null cells, ensuring an accurate average that excludes testers who didn't enter a value. Having dedicated myself to working swiftly and diligently while maintaining high-quality standards over the years, your pressing project timeline is well within my capabilities. I assure you, I can complete this task effectively and provide you with reliable results within hours. Choose proficiency, choose reliability, choose excellence - choose me for this project! Let’s collaborate and ensure your scorecard performs flawlessly by incorporating my strong numerical data analysis skills into it. I am eagerly awaiting the opportunity to contribute to your project!

$10 USD 1일에

5.0

(3 건의 리뷰)

1.8

@iqraahmad22

Hi there! With over 5 years of experience, I have honed my skills in data analysis and entry to an expert level. I am well-versed in using Excel for numerical data analysis and can efficiently utilize conditional formatting to serve your project's requirements. My ability to work with multiple worksheets is especially helpful here as this project involves calculation across 17 different worksheets. As far as conditional logic goes, I'm confident in my handling of null cells and normalizing the score accordingly. Being meticulous and having a strong work ethic, I can ensure that all relevant cells are accounted for during the computation of averages. Additionally, my familiarity with various functions and formulas in Excel will aid me in creating a precise and functional solution for you. Lastly, one thing that makes me confident in my ability to deliver your project on time is my proven experience working under similar pressures. I understand your need to have this figured out tonight, and I promise to prioritize your project accordingly. So let's not waste any more time, just hand over the data into my hands, and I'll transform them into a wonderful scorecard for you! Best Regards, Iqra Ahmad.

$10 USD 1일에

4.4

(6 건의 리뷰)

2.2

@nadiya29

Halo, I am writing to apply for the Excel data analysis position outlined in your job description. With advanced Excel proficiency, extensive experience in conditional formatting, and expertise in numerical data analysis, I am well-equipped to swiftly calculate the average of yes/no responses across 17 specific worksheets. I will ensure accuracy by assigning one point to "yes" and accounting for null cells, eliminating any skewed averages. Available immediately, I am committed to delivering results by tonight and am eager to contribute to your project. Best regards, Nadiya

$20 USD 1일에

5.0

(2 건의 리뷰)

1.3

@khizarhayar50

As a seasoned Data Analyst and Excel expert with 12+ years of experience, I am uniquely positioned to help solve your scorecard conundrum. I have an exceptional grasp of advanced Excel functions and conditional formatting - two key aspects crucial for solving your problem. My proven ability to work with multiple worksheets diligently will be instrumental in delivering an accurate and reliable solution for you. What truly sets me apart is not just my proficiency in Excel but also my strong background in numerical data analysis. From comprehending the average of 'yes/no' responses across different worksheets to accounting for null cells so that their impact on the final score is neutralized, I have dealt with similar complex situations numerous times throughout my career. With me managing this project, you can rest easy knowing that the calculations will be flawless and delivered to you promptly. I understand the importance of time management; hence, I assure you of a swift turnaround while maintaining the quality. Choosing me means incorporating extensive knowledge, reliability, and commitment to seamless execution into your project - keys to a successful collaboration. Let's get this done together!

$10 USD 2일에

0.0

(0 건의 리뷰)

0.0

@andreasodrey

As an advanced Excel user, I'm confident that I have the skills and expertise you need to tackle this project effectively. I have a strong numerical data analysis background which will be tremendously valuable for calculating scores based on yes/no responses. In addition, my expertise with conditional formatting will ensure that the null cells are accounted for in the calculations. With regards to your project deadline, let me assure you that I'll give it my utmost attention and prioritize delivering the completed task to you tonight. Time management is significant in any professional environment, and I understand the role it plays in meeting deadlines like yours. I believe my skills and determination make me a great fit for this job and I look forward to leveraging them to deliver a solution that meets your specifications. Thank you for considering my application, and I'm excited about the potential of working with you!

$15 USD 4일에

0.0

(0 건의 리뷰)

0.0

@TrainerZaf

Based on your urgency, I am here for you. Drawing on over 30 years of experience, my expertise with Excel and data analysis makes me the ideal candidate for your project. I've successfully tackled complex tasks that involve managing multiple worksheets like yours before. Specifically, one ongoing project comes to mind where I analyze data from over 15,000 trucks in a depot park monthly. I am keen on the importance of timely delivery without compromising quality, so you can count on me to complete this job promptly while providing the solid and accurate information you need. I have advanced knowledge of conditional formatting and working with numerical data will prove invaluable for your scorecard. With my help, your 'yes/no' responses can be easily scored, even accounting for null cells to normalize scores. In summary, my deep understanding of Excel's intricate features and functions combined with my impeccable problem-solving skills makes me best suited for this task. My testimonials from satisfied clients speak to my commitment to their success which is exactly what I will bring to your scorecard project. Let's work together and excel your next scorecard assessment!

$33 USD 2일에

0.0

(0 건의 리뷰)

0.0

@Arkanza

With all due respect, my skills as a data entry specialist and an Excel expert may not directly align with the task at hand. Moreover, I understand the sense of urgency associated with this project and regrettably have to inform you that I may not be able to complete it within the desired timeline. However, if given an opportunity, I assure you of my commitment and willingness to understand your project’s requirements entirely. My inherent eye for detail and effective problem-solving skills make me confident in tackling challenging projects like yours. My experience in data manipulation and analysis using Excel combined with my proficiency in conditional formatting positions me favorably for your scorecard project. In conclusion, while I might not fulfill every criterion on your wish list, my strong background in data management and familiarity with Excel makes me a well-suited candidate for your project. I am ready to learn quickly, adapt swiftly and approach each problem creatively to deliver accurate insights. I apologize for any inconvenience caused by my inability to complete it within your given timeframe, but if you can extend some flexibility, I am excited and ready to prove why I am the correct choice for this task!w

$20 USD 7일에

0.0

(0 건의 리뷰)

0.0

@airamair

I can do this based on my experience and i can do it in short time if you let me in to your project. Thank you

$15 USD 1일에

0.0

(0 건의 리뷰)

0.0

@mmhussain51

Hello, I understand your requirement and i have right set of skills to compete your project. I have good knowledge of excel formulas and VBA which gives me an edge when compared with others. Thank you and looking forward for your opportunity.

$30 USD 1일에

0.0

(0 건의 리뷰)

0.0

@ARosanto

I am experienced in processing data using excel 365, especially in creating integrated performance indicators (KPIs) from each work sheet, and I can help you with the problems you are currently facing.

$20 USD 7일에

0.0

(0 건의 리뷰)

0.0

@abdurrahman77785

hallo Iam, ABDURRAHMAN, am proud to present an efficient and reliable data entry service proposal. With professionalism, I offer complete solutions for entering data with high accuracy and optimal speed. My Services include inputting data from various sources into the desired format, database management and data cleaning. I prioritize the security and confidentiality of your data. With competitive prices and flexibility in handling work volumes, I am ready to help your company improve operational efficiency through our data entry services. Contact us for further consultation and discussion about how I can support your data entry needs.

$20 USD 5일에

0.0

(0 건의 리뷰)

0.0

@Emanuelyegon

Hello . I have gone through the description of the project and I believe that my skills in Excel will be of benefit to you.I can assure you of of working on data with conditional formatting with multiple spreadsheets. You can count on my commitment to detail and accuracy to ensure your project's timely completion to your satisfaction. I would like to know the deadline of the work. If you have a question please contact me.

$25 USD 7일에

0.0

(0 건의 리뷰)

0.0

@engimantalaat

I am 9 years experience in data entry field ..it will be my pleasure to join your project ..I will definitely help doing it perfectly and in very short timeframe ..since my main job is depending deeply on data entry. I believe that I am the perfect fit for this job as I have the necessary skills, experience and commitment to deliver quality results. I understand the importance of timely delivery so please feel free to contact me if you're looking for someone who can deliver on schedule. Thank you for considering me for this opportunity!

$10 USD 2일에