Find Jobs
Hire Freelancers

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

$30-250 USD

Slutfört
Publicerad över fem år sedan

$30-250 USD

Betalning vid leverans
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

Om projektet

8 anbud
Distansprojekt
Senaste aktivitet fem år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd 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 Om 15 dagar
5,0 (45 omdömen)
5,9
5,9
8 frilansar lägger i genomsnitt anbud på $158 USD för detta uppdrag
Använd 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 Om 3 dagar
5,0 (72 omdömen)
6,2
6,2
Använd 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 Om 3 dagar
4,8 (21 omdömen)
5,7
5,7
Använd 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 Om 15 dagar
5,0 (17 omdömen)
5,0
5,0
Använd 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 Om 1 dag
4,4 (9 omdömen)
4,3
4,3
Använd 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 Om 2 dagar
4,9 (4 omdömen)
2,8
2,8
Använd 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 Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 3 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för UNITED STATES
Signal Hill, United States
5,0
8
Verifierad betalningsmetod
Medlem sedan mars 29, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.