Find Jobs
Hire Freelancers

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

$30-250 USD

완료함
게시됨 5년 이상 전

$30-250 USD

제출할때 지불됩니다
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.
프로젝트 ID: 18333630

프로젝트 정보

8 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 15일에
5.0 (45 건의 리뷰)
5.9
5.9
8 이 프로젝트에 프리랜서들의 평균 입찰은 $158 USD입니다.
사용자 아바타
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 3일에
5.0 (72 건의 리뷰)
6.2
6.2
사용자 아바타
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 3일에
4.8 (21 건의 리뷰)
5.7
5.7
사용자 아바타
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 15일에
5.0 (17 건의 리뷰)
5.0
5.0
사용자 아바타
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 1일에
4.4 (9 건의 리뷰)
4.3
4.3
사용자 아바타
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 2일에
4.9 (4 건의 리뷰)
2.8
2.8
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Signal Hill, United States
5.0
8
결제 수단 확인
3월 29, 2018부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.