Find Jobs
Hire Freelancers

Using LPSolve within R, output teams with constraints for each CPT

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
I need to output the top 20 teams, based on $Points (BG) with the following constraints on Column H. All the following are <= the number after: CPTRB1F(5), CPTRB1D(3), CPTQB1F(2),CPTQB1D(1),CPTWR1,2,3F(1,3,1), CPTWR1,2,3D(1,2,1), DSTF(1), DSTD(1), CPTRB2F(1), CPTRB2D(1), CPTTE1F(1), CPTTE1D(1), CPTPK1F(1), CPTPK1D(1) The critical part of this is the following. For the players the are listed from column N and to the right of column, for each specific CPT there are additional constraints regarding the composition of the players with each specific CPT. The constraints as it relates to EACH CPT is the following in column R, AA, AJ, AS, and BB: The following the constraints are all <= DST1F(6) DST1D(3) QB1F(16) QB1D(11) RB1F(14) RB1D(6) WR1F(11) WR1D(5) WR2F(7) WR2D(3) WR3F(4) WR3D(2) TE1F(9) TE1D(4) PK1F(7) PK1D(5) So the script would have to be able to adjust for the % of CPT. For example CPTRB1F is 5 which is 25% of the total 20 team output. Thus, all the numbers from DST1F would need to be adjusted by 25% and ROUNDUP if possible. The numbers as shown are relative to the entire 20 team output. One way to consider it is these constraints would be applied to a subset composed of each specific CPT. Column V, AE, AN, AW, BF: F(69) And last but not least need to calculate a QB/WR Stack. What this means is looking at columns E, Q, Z, AI, AR, and BA if there is a QBF, then there is at least one WRF. A QBD and WRD would also count. But a QBF and WRD combo would not count. A QBD and WRF combo would not count. The QB and WR must have at least one matching F or D at the end. It doesn't have to be AND. Just one case in a combo would be counted as a "QB Stack". The last constraint would be that >=17 of the 20 teams would include a QB Stack. I'm open to any ideas on how to make this easier for example if the constraints can be %'s of a number that would make it easier for me so I'm open to ideas. I would like the comments in the code to be clear enough that if I wanted to run the script but for a 150 output that it would be very clear on how to do that. Thank you for your time.
Project ID: 18333630

About the project

8 proposals
Remote project
Active 5 yrs 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
Hi, I'm an engineer in operations research. I'm proficient in linear programming and mathematical modelling. I'm also an R programmer and available to work with you. Please contact me for more details. Regards.
$250 USD in 15 days
5.0 (45 reviews)
5.9
5.9
8 freelancers are bidding on average $158 USD for this job
User Avatar
Hello I am an enginner in operational research and decision support I master R programming statistics data mining Linear programming lustring kmeans knn, please contact me for more details about the project best regards
$200 USD in 3 days
5.0 (72 reviews)
6.2
6.2
User Avatar
Hello, Hope you are doing well. I can help with you in your project Using LPSolve within R, output teams with constraints for each CPT. I can assure you the quality job. I have good experience in Linear Programming, R Programming Language. We have worked on several similar projects before! We have worked on 425+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 USD in 3 days
4.8 (21 reviews)
5.7
5.7
User Avatar
Hello, I am a statistician and R programmer. I have read the description of your project, and took some time to open the Excel file and see the data, I can't say I fully understand what the data expresses, because it is full of abreviations that I don't know of. However, if we discuss this further I can help you out with the task. From what I picked about what you need, most of it could be acheived pretty easily just using condition filtering and some other tools (all in R). I will be looking forward to hear from you to discuss more about this. Then things will get clear. Thank you.
$155 USD in 15 days
5.0 (17 reviews)
5.0
5.0
User Avatar
I have a Masters degree in Economics and Statistics with 7years of professional experience working as a Quantitative Analyst (in the field of Statistics). As professional statistical analyst seeking opportunity to provide the highest quality services in the following areas of Statistics, Econometric, SPSS, STATISTICA, SAS, Eviews, Minitab, R language, Mathematica and MS Excel. Looking for outstanding opportunities to apply my academic credentials coupled with my previous experiences. So get your statistical job done here! I can do: Statistical programming like C programming, Computing for Data Analysis, Time Series & Econometric, Economic Modeling, R language and Python, Academic data analysis and report writing.
$30 USD in 1 day
4.4 (9 reviews)
4.3
4.3
User Avatar
Hi, I am interested in your work.I am a professional statistician, I have experience in linear programming with R package.I possessed master of science in statistics, I can timely deliver your work. Relevant Skills and Experience I have skills in operation research and linear programming. I can write statistical report and visualize it. I will deliver your work to meet your requirements.
$111 USD in 2 days
4.9 (4 reviews)
2.8
2.8
User Avatar
Hi, I have used Excel for Mixed Integer Linear Programming (MILP) & R for Quadratic Programming on various financial data (for a course I am presently doing). I can send you some homework as samples so that you better judge my abilities (please initiate chat for the same). I should be be able to meet your analysis request. I just figured out what are QB, RB, FB, WR, TE, OT, etc. I don't watch or follow any football, but I am learning data science. So please let me know if you are interested. Absolute number cutoff and % conversion is no issue. But I couldn't figure out everything as of yet. With DSTF <= 6, do you mean DST + F counts <= 6 ? As of now, I didn't understand 'F' or 'D', besides the fact they are categorical variable. Additionally, is one row one play event? Like A passes to B and B to C and so on? Looking forward to solve this problem. Yours Sincerely, Arunabha Sarkar
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an experienced professional in R programming language , predictive analytics ,SQL and statistics . I am also proficient in visualization dashboards using various tools like tableau , power bi . I also work on AWS , bigdata projects.
$161 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Signal Hill, United States
5.0
8
Payment method verified
Member since Mar 29, 2018

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.