Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 18333630

Información sobre el proyecto

8 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 15 días
5,0 (45 comentarios)
5,9
5,9
8 freelancers están ofertando un promedio de $158 USD por este trabajo
Avatar del usuario
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 en 3 días
5,0 (72 comentarios)
6,2
6,2
Avatar del usuario
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 en 3 días
4,8 (21 comentarios)
5,7
5,7
Avatar del usuario
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 en 15 días
5,0 (17 comentarios)
5,0
5,0
Avatar del usuario
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 en 1 día
4,4 (9 comentarios)
4,3
4,3
Avatar del usuario
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 en 2 días
4,9 (4 comentarios)
2,8
2,8
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Signal Hill, United States
5,0
8
Forma de pago verificada
Miembro desde mar 29, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.