Create a spreadsheet with a COUNTA function for my data.
- or -
Post a project like this1678
£95(approx. $119)
- Posted:
- Proposals: 22
- Remote
- #2528607
- Awarded
Front-End-Developer, Back-End-Developer, Web Developer E-commerce Developer, Logo Design
Karachi
I will write your SEO Articles, Resume, WordPress Website, Social Media Accounts, Pages, Ads and Assignments
Lahore
Wordpress |Web developer|Graphic Designer |Logo Designer | Scrapping |Excel VBA |Data Scientist
Rawalpindi
Trusted CRM Consultant and Data Automation Expert. Automating your business, designing your future!
Mumbai
3155613098832208270309805830948883079307305520729765682928746288970827177862642406
Description
Experience Level: Expert
I have an excel spreadsheet with data and i require someone to create a few COUNTA functions.
Data that needs to be counted;
How many systems selected a horse?
Incremental % strike rate;
20% - 24.5%
25% - 29.5%
30% - 34.5%
35% - 39.5%
40% - 44.5%
45% - 49.5%
>=50%
I have names for my systems however the systems will grow to not above 50 so if you want to use numerical values you can instead of the name.
The 'System Pts' and 'System % Pts' Columns - They need to work out how many points i need to place on my wager.
Logic for that section system Pts;
Systems Counted =8 and 10 then 3 points
Logic for System % Pts
% 24.5% and 29.5 and 34.5% and 39.5% and 44.5% and 49.5% then 4 Points.
Finally, the last column 'Pts Avg' works out the average of the previous Pts columns - it is just that the average of the 2 Pts sections.
That's it and data excel is attached for viewing.
Data that needs to be counted;
How many systems selected a horse?
Incremental % strike rate;
20% - 24.5%
25% - 29.5%
30% - 34.5%
35% - 39.5%
40% - 44.5%
45% - 49.5%
>=50%
I have names for my systems however the systems will grow to not above 50 so if you want to use numerical values you can instead of the name.
The 'System Pts' and 'System % Pts' Columns - They need to work out how many points i need to place on my wager.
Logic for that section system Pts;
Systems Counted =8 and 10 then 3 points
Logic for System % Pts
% 24.5% and 29.5 and 34.5% and 39.5% and 44.5% and 49.5% then 4 Points.
Finally, the last column 'Pts Avg' works out the average of the previous Pts columns - it is just that the average of the 2 Pts sections.
That's it and data excel is attached for viewing.
Jay K.
100% (7)Projects Completed
9
Freelancers worked with
5
Projects awarded
8%
Last project
12 Sep 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Jay
When are you looking to have this completed by?
Kind regards
Andy
844717
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies