I need expert statistics done in Microsoft Excel for a fantasy U. S. football league.
- or -
Post a project like this2426
$150
- Posted:
- Proposals: 10
- Remote
- #1678922
- Awarded
Researcher, Data base building, Lead generation, E Mail database, Data Entry, Research base writing, Market Research,
Bay Minette
PHP, Wordpress, Drupal, Magento, Data Entry, Administrative and Technical Support, SEO, Digital Marketing
Kingston
data entry, MS Word ,MS excel ,PDF to ms word, form filling article writing content writing
Hoshiarpur
15654008378048998691249170138486414494731501719176912717900131790327
Description
Experience Level: Expert
General information for the business: Reborn Apps
Industry: Software Development
Description of excel work: I have 40 seasons of statistics compiled for a fantasy U. S. football league.
There are 30 teams in the league as of season 40.
You need to be an expert in Microsoft Excel. You don't need to be an expert in American (U. S.) football.
There is NOTHING difficult here if you an familiar with MS Excel. You will be, PRIMARILY, sorting, adding, and formatting. ...but it will be very repetitive.
You will need to compile individual season statistics for 8 positions: Coaches (CH), Quarterbacks (QB), Runningbacks (RB), Wide Receivers (WR), Place Kickers (PK), and Punters (PR). You will also need to compile the combined season stats for Wide Receivers and Runningbacks.
Note that Coaches, Quaterbacks, Runningbacks, and Wide Receivers all have sub categories
Coaches: Head Coaches (HC), Assistant Coaches (AC)
Quarterbacks: Quaterbacks (QB), Optionbacks (OB), Wingbacks (OB), X-Backs (XB)
Runningbacks: Runningback (RB), Fullback (FB), Halfback (HB), Tailback (TB)
Wide Receivers: Wide Receivers (WR), Split Ends (SE), Tight Ends (TE), Offensive Ends (OE), Power Backs (PB), Flankers (FL)
You will also need to compile cumulative career stats for the 8 positions.
You will also need to do team sorting for 25 specific categories for each team.
Once you create your formulas, combined with the formulas that I provide you, the project will/should become simply repetition.
I will be supplying you with the necessary files for which to assemble the statistics.
I am attaching three spreadsheets.
The first two spreadsheets show all 30 teams, by season 1-40.
The third spreadsheet shows somewhat of (not exactly) a cumulative example/view of how 40 seasons of Quarterback statistics will look.
There will be similar one for each position AS WELL as one for each individual season.
I did not include my self-created formulas for certain statistics such as (rating, average, etc.).
The second page of the 3rd worksheet has a sample of the individual stats that need to be sorted for each team.
Review all of the spreadsheets on the file I uploaded. I need the each player's cumulative career stats added on a season by season basis, as you can see on worksheet 3. I need this for all positions.
I also need season by season stats compiled for each active player per season, on a season by season basis, per position.
I also need team stat category leaders, per season. There will be no cumulative list for team categories. Worksheet 4 shows these categories. The numbers show the ranking of each of the teams per category.
I will provide you the sort categories/criteria.
We will be working together on the project but as you get more familiar with it you will be able to work more independently.
You will also compile these stats per team.
You will be working with another statistician to help you (Statistical Analysis - Fantasy Football - Microsoft Excel Expert - PART 1)
Extra notes: 01.) The price is not negotiable once we begin.
02.) You will only be paid when the work is completed.
03.) I will be providing you the formats and applicable formulas.
04.) You will need to compile the stats in the proper format(s) that I have dictated.
05.) There is no firm TIMETABLE, but you must make progress and check in with me each Monday.
06.) If you do not understand what I need, please leave me free to interact with others who do.
07.) There is NOTHING difficult here if you an familiar with MS Excel. You will be, PRIMARILY, sorting, adding, and formatting. ...but it will be very repetitive.
08.) THE BUDGET is a flat fee of $150.00 for both Statisticians.
09.) Do not ask to speak to me outside of PPH if I have not accepted your offer.
10.) READ ALL OF THE INSTRUCTIONS AND CAREFULLY REVIEW THE FILES BEFORE CONTACTING ME.
11.) For the individual statistics, you will end up with 10 files that will look similar to worksheet 3 on the attached worksheet. I will provide additional files/formats/formulas for examples to help you get started.
12.) I will provide you with sorting categories.
13.) We will be working together on the project but as you get more familiar with it you will be able to work more independently.
14.) DO NOT send me dummy or placeholder bids. Let me know what you believe that you can reasonably complete the project for.
15.) If you are an EXPERT in Microsoft Excel, this project should pose no issues for you. However, again, there is significant repetition.
Extra notes:
Industry: Software Development
Description of excel work: I have 40 seasons of statistics compiled for a fantasy U. S. football league.
There are 30 teams in the league as of season 40.
You need to be an expert in Microsoft Excel. You don't need to be an expert in American (U. S.) football.
There is NOTHING difficult here if you an familiar with MS Excel. You will be, PRIMARILY, sorting, adding, and formatting. ...but it will be very repetitive.
You will need to compile individual season statistics for 8 positions: Coaches (CH), Quarterbacks (QB), Runningbacks (RB), Wide Receivers (WR), Place Kickers (PK), and Punters (PR). You will also need to compile the combined season stats for Wide Receivers and Runningbacks.
Note that Coaches, Quaterbacks, Runningbacks, and Wide Receivers all have sub categories
Coaches: Head Coaches (HC), Assistant Coaches (AC)
Quarterbacks: Quaterbacks (QB), Optionbacks (OB), Wingbacks (OB), X-Backs (XB)
Runningbacks: Runningback (RB), Fullback (FB), Halfback (HB), Tailback (TB)
Wide Receivers: Wide Receivers (WR), Split Ends (SE), Tight Ends (TE), Offensive Ends (OE), Power Backs (PB), Flankers (FL)
You will also need to compile cumulative career stats for the 8 positions.
You will also need to do team sorting for 25 specific categories for each team.
Once you create your formulas, combined with the formulas that I provide you, the project will/should become simply repetition.
I will be supplying you with the necessary files for which to assemble the statistics.
I am attaching three spreadsheets.
The first two spreadsheets show all 30 teams, by season 1-40.
The third spreadsheet shows somewhat of (not exactly) a cumulative example/view of how 40 seasons of Quarterback statistics will look.
There will be similar one for each position AS WELL as one for each individual season.
I did not include my self-created formulas for certain statistics such as (rating, average, etc.).
The second page of the 3rd worksheet has a sample of the individual stats that need to be sorted for each team.
Review all of the spreadsheets on the file I uploaded. I need the each player's cumulative career stats added on a season by season basis, as you can see on worksheet 3. I need this for all positions.
I also need season by season stats compiled for each active player per season, on a season by season basis, per position.
I also need team stat category leaders, per season. There will be no cumulative list for team categories. Worksheet 4 shows these categories. The numbers show the ranking of each of the teams per category.
I will provide you the sort categories/criteria.
We will be working together on the project but as you get more familiar with it you will be able to work more independently.
You will also compile these stats per team.
You will be working with another statistician to help you (Statistical Analysis - Fantasy Football - Microsoft Excel Expert - PART 1)
Extra notes: 01.) The price is not negotiable once we begin.
02.) You will only be paid when the work is completed.
03.) I will be providing you the formats and applicable formulas.
04.) You will need to compile the stats in the proper format(s) that I have dictated.
05.) There is no firm TIMETABLE, but you must make progress and check in with me each Monday.
06.) If you do not understand what I need, please leave me free to interact with others who do.
07.) There is NOTHING difficult here if you an familiar with MS Excel. You will be, PRIMARILY, sorting, adding, and formatting. ...but it will be very repetitive.
08.) THE BUDGET is a flat fee of $150.00 for both Statisticians.
09.) Do not ask to speak to me outside of PPH if I have not accepted your offer.
10.) READ ALL OF THE INSTRUCTIONS AND CAREFULLY REVIEW THE FILES BEFORE CONTACTING ME.
11.) For the individual statistics, you will end up with 10 files that will look similar to worksheet 3 on the attached worksheet. I will provide additional files/formats/formulas for examples to help you get started.
12.) I will provide you with sorting categories.
13.) We will be working together on the project but as you get more familiar with it you will be able to work more independently.
14.) DO NOT send me dummy or placeholder bids. Let me know what you believe that you can reasonably complete the project for.
15.) If you are an EXPERT in Microsoft Excel, this project should pose no issues for you. However, again, there is significant repetition.
Extra notes:
Jaime R.
100% (77)Projects Completed
35
Freelancers worked with
27
Projects awarded
60%
Last project
29 Apr 2020
Dominican Republic
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Are you still actively looking for the Statistics Experts? I would like to bid for it but not sure about its status.
Jaime R.24 Aug 2017It looks as if I've found some statisticians for this project.
...thank you. -
Hi Jaime,
I read the description of your job but attachment is missing. Could you please provide me attachment so that project can be understood completely before biding for this project.
Thanks
Pradeep tripathi
Jaime R.16 Aug 2017...done.
488277482522
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