This week's challenge we are going to create a Weekly Challenge dream team... on a budget! Provided is a list of participants and the number of Challenges they have completed. But here's the rub, each person on your team is going to cost you some money and each ranking position has a 'salary' or 'value' associated with it. You first task is going to prep the data to attach a value to each person's rank. After assigning values, it's time to recruit your team of people. You goal when recruiting your team is to have a team of people that have completed the most weekly challenges. There are t20 simple rules when building your team: 1) You can only spend $1,500,000, 2) Your team must have 8 people. When you find your team, share your solution, tell us how many challenges your team completed and sound off who made it!
Since there are a lot of answers and only a few 'best answers', we wont be divulging our solution until next week. Good luck!
Note: The rank we used was a dense rank. So if my first two challengers tied, they both would be given a rank of one and the next (third) person would be given a rank of two. Some other methods would have given the third person the rank of three, but for the sake of the challenge we kept it 'dense'.
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #110
EstherB47
110
NicoleJohnson
110
PhilipMannering
110
ggruccio
110
patrick_digan
110
JS420
108
LordNeilLord
108
Natasha
105
jamielaird
104
SeanAdams
99
samN
99
jasperlch
98
LandonG
89
nick_ceneviva
84
CHarrison
79
dsmdavid
73
MarqueeCrew
55
dominiklz
52
JoshKushner
51
asabau
40
Laurap1228
39
kcgreen
39
SGolnik
36
mceleavey
35
wayne_kramer
35
Elena_Caric
34
derekbelyea
34
maxjohnson02
34
alex
33
data_rachel
33
MaxGiegerich
29
aclaxton
29
msicak
28
Ozzy_Campos
26
A_Twa
25
blairmbailey
25
kelly_gilbert
25
BenMoss
24
michalsicak
23
ryan_lambert
23
jdunkerley79
22
KOBoyle
21
Marc
21
TeePee
21
BrendaS
20
JacobR77
20
EmanueleE
19
Joe_Mako
19
MsBindy
19
Syfer889
19
bdaniels
19
locunhalima
19
luciebrett
19
vishalgupta
17
DE0413
16
IlĂas
16
ddiesel
16
ivoller
16
Amarendra
15
dillon_bok
15
samjohnson
15
joshuaburkhow
14
lminors
14
paul_houghton
13
930realm
12
BarnesK
12
Garrett
12
JORGE4900
12
LalaLele66
12
edorlando07
12
kat
12
robcarroll
12
sagarb
12
Caveman88
11
DanielArenas
11
KatieA
11
RWvanLeeuwen
11
WLL
11
adamp
11
gnans19
11
AndyBate
10
David-Carnes
10
JamesLawlor
10
MMehdi
10
NurulShi12
10
Phil_L57
10
ukashi
10
ADerbak
9
Max06270
9
Simona
9
Suzanne
9
Treyson
9
_sbeaumaster
9
dheerajpoojari
9
shanakag
9
tochy
9
DriveMyData
8
Lorna_Eden
8
Mattpannuzzo
8
Philip
8
markp201
8
JoshK
7
MBark
7
OllieClarke
7
brianprestidge
7
fmvizcaino
7
rijuthav
7
Coxta45
6
JaakkoS
6
MarvinPinto
6
MinaGO
6
SimonaLoffredo
6
WaqasA
6
deepsingh
6
elamm43
6
hoheusle
6
jacob
6
michael_d
6
peter_gb
6
samanthaj_hughes
6
AT_12
5
Anurag
5
CaraI
5
Claje
5
KM
5
MGerber
5
MJG
5
Pavel_G
5
PiotrZawieja
5
andypick
5
iain_sterland
5
justin_winter
5
kixe80
5
raj_k
5
remyagr
5
servingmosthigh
5
JohnJPS
4
JordyMicheal
4
Krisss
4
Naledi
4
Pasty
4
PeterV
4
Vijay_M
4
anbhvrma141
4
anthonyd
4
ckaita
4
danfarmerTIL
4
irisTZ
4
jsdeter
4
leesin
4
maesb
4
markcollin
4
santosh_kandregula
4
sikel
4
sunny430
4
AKnutson11
3
AndrewDataKim
3
Arianna_Fuller
3
Borja_Leiva
3
Carlithian
3
CarolineMurnane
3
DanielUpton
3
DataSchoolMarcus
3
DinoF
3
Edwin
3
Gauthier_B
3
Hartwick96
3
JSaumya
3
JefBus
3
JonM
3
JustinMatthews
3
LJoonas
3
Leonam
3
M-Shedid
3
MichaelKaloz
3
MichelKars
3
Niklas
3
PaulRB
3
ShaunaKroeger
3
Sruhl
3
TerryT
3
Tom_Pilgrem
3
ajmnoble
3
cmarchese
3
cmcclellan
3
courtneyg
3
david_elliott
3
espeigle
3
iedroso
3
karolina_m
3
kconner
3
mrichards
3
rajiv_tarafdar
3
robbertbrouwers
3
ruchiu
3
santiesteban
3
shoesnsocks4
3
toddhowl
3
vkarthik21
3
ydmuley
3
AdamR
2
AlexL
2
Auditor
2
Beastmode314
2
Br1
2
Chase
2
CynthiaE
2
Dan_Agenti
2
David92
2
Harbinger
2
JeffF
2
JoeT
2
Kdpalmer
2
LBhat
2
LilianH
2
Nadjet
2
NaiLo
2
NaiLou
2
Ollie_Power
2
PeteV
2
ReinierK
2
SophiaF
2
TimM
2
a_anderson
2
akuma162
2
alexoreilly
2
allanq2001
2
andre347
2
ankit_mandal
2
benbenjoy
2
damianrowe
2
datavizbro
2
dcraft
2
gosaliachirag
2
hstevens
2
joanalytics
2
kamills
2
lbansal
2
lucasmascarenhas
2
mattwilliamson
2
messy_m
2
nick_ceneviva1
2
paultno
2
smerton
2
stubartmess
2
vball5
2
AlexanderMik
1
AndyJK
1
AnetteKyrre
1
Ayelavan
1
Balders
1
BenChan
1
Charity_K_Wilson
1
Comicjess78
1
DRomero
1
DanielaMira
1
DataPrepChad
1
DawsonM
1
Diptesh
1
E0209
1
ErikaW
1
Eyecademy
1
Falk
1
Fz
1
Goldenboi
1
GwenM
1
IJH34
1
J_white
1
JacquesC
1
JamesHa
1
JohnG
1
JustinBabbittEAG
1
KOUnited
1
KayT
1
Krit_Gable
1
LeahK
1
LelandM
1
Lincoyan
1
LukeL
1
Martin_Bosak
1
Matt_Curtis
1
Matthew_Morris
1
MichaelWalsh
1
Michal
1
MikeSp
1
Oliver
1
PJDit
1
Pablo0205
1
Rachel_Burge
1
RebeccaRoland
1
Shem
1
Shevans
1
TomWelgemoed
1
US_KS
1
Vignesh-Sunderrajan
1
Wadim
1
YeungDa
1
ZoeyL1GL
1
akshatoz
1
alexandra_hanna
1
amarrero45
1
ankitthescorpion
1
badiu
1
bkinn
1
charlescolemansm
1
chris_fort
1
chris_love
1
coolvishruth
1
csmilley
1
datatim
1
david_fetters
1
deibell
1
dricke
1
dsnyder
1
goncalopereira
1
iiyoob
1
jamesthomas
1
jamie_moss
1
jason_m_mack
1
jezknee
1
jjc42
1
jmudd
1
karan-sanas
1
kartheek31
1
katelynhweber
1
kksieski
1
klippard001
1
lizpunct
1
marapatricia
1
maraquindoza
1
markusyk
1
mmontgomery
1
morganwhinery
1
naveen_manae
1
ned
1
nrauta
1
nwhaley
1
palessio
1
petgrap
1
philip_ball
1
prajgiri
1
preetham_ts
1
pvara
1
rohanonline
1
rsmith
1
sb_theinfolab
1
sehengratis
1
sharjosh
1
shaunbeckett
1
siddhartha_s
1
smbourke
1
sroy2018
1
sumeetkumar
1
timngwena
1
tom_montpool
1
vuddagiri1991
1
wuyiting1009
1
Weekly Challengers
1
250000
2
240000
3
230000
4
220000
5
210000
6
200000
7
190000
8
180000
9
170000
10
165000
11
160000
12
155000
13
150000
14
145000
15
140000
16
135000
17
130000
18
125000
19
120000
20
118000
21
116000
22
114000
23
112000
24
110000
25
108000
26
106000
27
104000
28
102000
29
100000
30
99000
31
98000
32
97000
33
96000
34
95000
35
94000
36
93000
37
92000
38
91000
39
90000
40
89500
41
89000
42
88500
43
88000
44
87500
45
87000
46
86500
47
86000
48
85500
49
85000
50
84500
Salary
Rank
Int32
4
Empty
If [Row-1:Challenges] = [Challenges] THEN [Row-1:Rank] ELSE [Row-1:Rank] + 1 ENDIF
If [Row-1:Challenges] = [Challenges] THEN [Row-1:Rank] ELSE [...
<=
1500000
==
8
landing
[]
[]
0
{"fileType":"CPLEX_LP","filePath":"","solver":"glpk","inputMode":"matrix","maximize":true,"problemType":"LP"}
matrix
LP
glpk
True
CPLEX_LP
varInRow
True
variable
coefficient
lb
ub
type
Matrix Input Mode
C:\Users\898450\AppData\Local\Temp\Engine_40328_37dec472adb44bb08e193aafca44ee56_\Engine_13768_03772098bf9747c3aae196294d3ec5fb_.yxdb
Single
Profile
C:\Users\898450\AppData\Local\Temp\Engine_40328_37dec472adb44bb08e193aafca44ee56_\Engine_13768_dc0c7007a6a546b3ac9aae13fa266dfb_.yxdb
Single
Profile
Horizontal
challenge_111_solution