Create multiple lineups for draft kings

DUNDERHEAD

New Member
Joined
May 6, 2016
Messages
6


WEIGHT CLASS
AGET/F RANKADJ RANKSFIGHTFIGHTERSOPPSALARYPPF-AVGFIGHTSWINLOSSWIN ASPECTTKOSUBDECFINNISHESSTRK/PMSTRK/ABSRBDSTRIKE ASPECTTK/DWNTKDWN/DEFTAKEDOWN ASPECTWIN STREAKSTREAK IMPACTFINNISH STREAKROUND 1 FINROUND 2 FINROUND 3 FINROUND 4 FINROUND 5 FINTHE FINNISHERS BANG FOR THE BUCK LOW TO HIGHTOTAL PACKAGETHE KILLERSTHE ASSASSINATORSULTIMATE FIGHTERFIGHTERSBANGTOTKILL***ULTMY INPUTVOTESFIGHTERS
HEAVY WEIGHT35.003.003.001.00Alistair OvereemAndrei Arlovski10300.0061.6354.0040.0014.0029.6319.0017.004.0032.403.801.701.561.6078.0042.803.004.051.0031.005.000.000.000.0048.26 167.14158.7096.6736.05124.27Alistair Overeem1111116Alistair Overeem
HEAVY WEIGHT37.005.005.001.00Andrei ArlovskiAlistair Overeem9100.0071.5036.0025.0011.0017.3617.003.005.0016.003.102.300.560.3585.0040.990.000.000.0013.003.004.000.000.0024.84 127.2799.7566.3913.0051.86Andrei Arlovski1101104Andrei Arlovski
HEAVY WEIGHT28.000.0020.002.00Stefan StruveAntonio Silva9900.0058.2238.0030.008.0023.687.0016.007.0017.633.403.60-0.160.5062.0038.640.000.000.0014.009.000.000.000.0026.28 170.05106.0964.7714.0014.81Antonio Silva1101104Antonio Silva
HEAVY WEIGHT36.0012.0012.002.00Antonio SilvaStefan Struve9500.0035.3927.0019.008.0013.3714.003.002.0015.212.902.900.000.9065.0032.190.000.000.0012.004.001.000.000.0022.03 268.4482.8054.2112.00-119.44Stefan Struve0001001Stefan Struve
WELTER WEIGHT24.0013.0013.003.00Albert TumenovGunnar Nelson10500.0080.1719.0017.002.0015.2111.000.006.007.124.203.800.360.3083.0066.455.005.590.0010.001.000.000.000.0012.01 130.98106.7384.4115.5975.75Albert Tumenov1111116Albert Tumenov
WELTER WEIGHT27.000.0020.003.00Gunnar NelsonAlbert Tumenov8900.0071.7916.0014.002.0012.254.009.001.0012.071.803.80-1.751.4070.0053.590.000.000.0011.002.000.000.000.0014.29 123.9890.4566.1311.0043.60Gunnar Nelson1001103Gunnar Nelson
BANTOM32.0014.0014.004.00Germaine de RandamieAnna Elmose10000.0045.008.005.003.003.132.000.003.000.803.001.900.690.5078.0030.471.001.601.001.000.000.000.000.003.20 222.2239.8835.963.60-142.78Anna Elmose0000000Anna Elmose
BANTOM31.000.0020.004.00Anna ElmoseGermaine de Randamie9400.0080.003.003.000.003.003.000.000.003.003.502.001.500.5080.0080.003.003.003.001.002.000.000.000.005.50 117.5096.0090.007.0075.50Germaine de Randamie1110115Germaine de Randamie
LT HVY WEIGHT24.0014.0014.005.00Nikita KrylovFrancimar Barroso10100.0080.0823.0019.004.0015.707.0012.000.0019.005.902.702.641.0025.0017.063.003.633.0019.000.000.000.000.0026.63 126.1284.6649.9725.6334.14Nikita Krylov1001114Nikita Krylov
LT HVY WEIGHT36.000.0020.005.00Francimar BarrosoNikita Krylov9300.0043.2522.0018.004.0014.7310.004.004.0010.892.802.300.411.5089.0059.582.002.440.0011.003.000.000.000.0016.19 215.03104.2478.6313.44-18.72Francimar Barroso0111003Francimar Barroso
STRAW30.0010.0010.006.00Karolina KowalkiewiczHeather Jo Clark11200.0060.008.008.000.008.001.002.005.001.134.402.302.100.0089.0089.008.008.000.003.000.000.000.000.003.00 186.67111.23102.1011.0037.66Karolina Kowalkiewicz1111116Karolina Kowalkiewicz
STRAW35.000.0020.006.00Heather Jo ClarkKarolina Kowalkiewicz8200.0059.0011.007.004.004.452.003.002.003.573.704.60-0.571.00100.0040.502.003.140.003.002.000.000.000.007.07 138.9858.1650.146.14-24.54Heather Jo Clark1000001Heather Jo Clark
LIGHT WEIGHT29.000.0020.007.00Rustam KhabilovChris Wade10400.0059.2521.0018.003.0015.434.005.009.004.501.701.80-0.094.5050.0036.731.001.170.007.002.000.000.000.009.92 175.5367.6647.738.17-51.97Rustam Khabilov1000012Rustam Khabilov
LIGHT WEIGHT28.000.0020.007.00Chris WadeRustam Khabilov9000.0081.7512.0011.001.0010.080.004.007.001.452.301.600.644.60100.0084.036.006.551.003.001.000.000.000.005.18 110.09107.9396.4010.55104.79Chris Wade1111116Chris Wade
MIDDLE WEIGHT34.000.0020.008.00Magnus CedenbladGarreth McLellen10600.0062.1317.0013.004.009.946.005.002.009.311.702.70-0.762.8067.0039.183.003.920.007.004.000.000.000.0013.08 170.6274.6655.4210.92-29.62Garreth McLellen1001002Garreth McLellen
MIDDLE WEIGHT33.000.0020.008.00Garreth McLellenMagnus Cedenblad8800.0056.0016.0013.003.0010.563.009.001.0011.083.601.601.631.0023.0015.181.001.231.007.002.001.001.000.0012.74 157.1452.4230.789.23-64.72Magnus Cedenblad1000001Magnus Cedenblad
LIGHT WEIGHT31.000.0020.009.00JOSH EMMITJOHN TUCK9700.0080.009.009.000.009.003.002.004.002.782.802.500.300.7570.0070.009.009.002.004.000.001.000.000.006.50 121.2597.5885.8015.0077.13Jon Tuck1111105Jon Tuck
LIGHT WEIGHT31.000.0020.009.00Jon TuckNick Hein8600.0059.6011.009.002.007.364.004.001.007.113.104.10-0.820.7046.0030.791.001.221.007.000.001.000.000.0010.39 144.3056.0641.599.22-37.43JOSH EMMIT1000012JOSH EMMIT
LIGHT WEIGHT32.000.0020.0010.00Yan CabralReza Madadi10200.0046.1314.0012.002.0010.290.0011.001.0010.081.901.900.003.2033.0024.240.000.000.005.006.000.000.000.0011.08 221.1455.7035.335.00-125.11Yan Cabral0000000Yan Cabral
LIGHT WEIGHT37.000.0020.0010.00Reza MadadiYan Cabral9200.0055.3817.0013.004.009.941.008.004.006.233.003.60-0.463.4089.0052.040.000.000.005.003.001.000.000.0010.13 166.1477.8961.725.00-21.53Reza Madadi1000001Reza Madadi
FLY WEIGHT25.005.005.0011.00Kyoji HoriguchiNeil Seery10700.0067.4218.0016.002.0014.229.001.006.006.253.402.400.891.7945.0035.561.001.130.007.003.000.000.000.0010.41 158.7168.4547.988.13-34.17Kyoji Horiguchi1000034Kyoji Horiguchi
FLY WEIGHT36.000.0020.0011.00Neil SeeryKyoji Horiguchi8700.0051.0027.0016.0011.009.486.006.004.009.003.202.500.411.0060.0021.071.001.691.003.007.002.000.000.0017.30 170.5958.9540.475.69-65.48Neil Seery1000001Neil Seery
WELTER24.000.0020.0012.00Leon EdwardsDominic Waters10900.0046.7513.0010.003.007.695.002.003.004.902.202.30-0.080.5065.0038.460.000.000.005.002.000.000.000.008.45 233.1659.4346.835.00-121.89Leon Edwards0000022Leon Edwards
WELTER WEIGHT26.000.0020.0012.00Dominic WatersLeon Edwards8500.0010.2513.009.004.006.233.002.004.002.780.703.30-1.804.2025.0011.98-2.00-2.890.002.001.002.000.000.005.42 829.2721.7212.71-0.89-795.73Dominic Waters0000000Dominic Waters
FLY WEIGHT29.000.0020.0013.00Willie GatesUlka Sasaki9600.0044.6718.0012.006.008.006.003.003.006.751.905.30-2.270.5073.0032.440.000.000.009.000.000.000.000.0013.50 214.9258.4343.689.00-103.82Willie Gates0000000Willie Gates
FLY WEIGHT26.000.0020.0013.00Ulka SasakiWillie Gates9100.0040.1721.0018.003.0015.432.009.007.006.721.703.40-1.461.8050.0036.73-2.00-2.330.007.004.000.000.000.0011.67 226.5566.7644.614.67-110.51Ulka Sasaki0000000Ulka Sasaki

<colgroup><col span="5"><col><col><col span="25"><col><col span="3"><col><col><col><col span="6"><col><col></colgroup><tbody>
</tbody>
OK SO HERE IS MY SPREAD SHEET. I HAVE FIGURED OUT TO CREATE A SINGLE LINEUP USING SOLVER, SORT OF. WHAT I NEED IS TO KNOW HOW TO CREATE, USING SOLVER SAY 35 LINEUPS. DOING SO IN ONE FELL SWOOP. PLEASE HELP, TOTALY NEWBEE AT EXCEL BUT HAVE LEARNED ALOT IN LAST COUPLE WEEKS. OK MAYBE LIKE 1% OF EXCEL TOTAL KNOWLEDGE BASE.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
What is a lineup? Never heard of that Excel function in all 22 years of using it. A more clearly explained question would go a long way to helping you out.

Still in your 1st month, huh? Well done. Reduce your estimate from 1% to about 0.1%. You haven't even popped the hood yet, but maybe you've seen the tyres and keys in the ignition... and the handbrake is up.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top