Maybe. Check me if I got the logic. Strategy is, distribute "optimal load" to each server first, then distribute the rest as a ratio of excess Recommended over Optimal. Anything above that is either undistributed, or you could use a similar rule to go up to Max Load if desired.
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Segoe UI,Arial; font-size:11pt; background-color:#ffffff; padding-******2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; *******3**** " /><col style="*******72px;" /><col style="*******9****" /><col style="*******109px;" /><col style="*******109px;" /><col style="*******106px;" /><col style="*******10****" /><col style="*******72px;" /><col style="*******105px;" /><col style="*******99px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >*</td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-weight:bold; text-align:center; ">Server</td><td style="font-weight:bold; text-align:center; ">Max Load</td><td style="font-weight:bold; text-align:center; ">Threshold</td><td style="font-weight:bold; text-align:center; ">Recommended</td><td style="font-weight:bold; text-align:center; ">Optimal</td><td style="font-weight:bold; text-align:center; ">Distribution</td><td style="font-weight:bold; text-align:center; ">60</td><td style="font-weight:bold; text-align:center; ">Suboptimal</td><td style="font-weight:bold; text-align:center; ">Total Load</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Server1</td><td style="text-align:right; ">20.00</td><td style="text-align:right; ">85.00%</td><td style="text-align:right; "> * * * * * * * * *17.0 </td><td style="text-align:right; "> * * * * * * * * * 6.7 </td><td style="text-align:right; "> * * * * * * * *6.67 </td><td style="text-align:right; "> * * * 53.33 </td><td style="text-align:right; "> * * * * * * * 10.33 </td><td style="text-align:right; "> * * * * * * 17.00 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Server2</td><td style="text-align:right; ">10.00</td><td style="text-align:right; ">85.00%</td><td style="text-align:right; "> * * * * * * * * * *8.5 </td><td style="text-align:right; "> * * * * * * * * * 6.7 </td><td style="text-align:right; "> * * * * * * * *6.67 </td><td style="text-align:right; "> * * * 46.67 </td><td style="text-align:right; "> * * * * * * * * 1.83 </td><td style="text-align:right; "> * * * * * * * 8.50 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Server3</td><td style="text-align:right; ">10.00</td><td style="text-align:right; ">85.00%</td><td style="text-align:right; "> * * * * * * * * * *8.5 </td><td style="text-align:right; "> * * * * * * * * * 6.7 </td><td style="text-align:right; "> * * * * * * * *6.67 </td><td style="text-align:right; "> * * * 40.00 </td><td style="text-align:right; "> * * * * * * * * 1.83 </td><td style="text-align:right; "> * * * * * * * 8.50 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Server4</td><td style="text-align:right; ">5.00</td><td style="text-align:right; ">90.00%</td><td style="text-align:right; "> * * * * * * * * * *4.5 </td><td style="text-align:right; "> * * * * * * * * * 4.5 </td><td style="text-align:right; "> * * * * * * * *4.50 </td><td style="text-align:right; "> * * * 35.50 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 4.50 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Server5</td><td style="text-align:right; ">5.00</td><td style="text-align:right; ">90.00%</td><td style="text-align:right; "> * * * * * * * * * *4.5 </td><td style="text-align:right; "> * * * * * * * * * 4.5 </td><td style="text-align:right; "> * * * * * * * *4.50 </td><td style="text-align:right; "> * * * 31.00 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 4.50 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Server6</td><td style="text-align:right; ">5.00</td><td style="text-align:right; ">90.00%</td><td style="text-align:right; "> * * * * * * * * * *4.5 </td><td style="text-align:right; "> * * * * * * * * * 4.5 </td><td style="text-align:right; "> * * * * * * * *4.50 </td><td style="text-align:right; "> * * * 26.50 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 4.50 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Server7</td><td style="text-align:right; ">2.00</td><td style="text-align:right; ">60.00%</td><td style="text-align:right; "> * * * * * * * * * *1.2 </td><td style="text-align:right; "> * * * * * * * * * 1.2 </td><td style="text-align:right; "> * * * * * * * *1.20 </td><td style="text-align:right; "> * * * 25.30 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 1.20 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Server8</td><td style="text-align:right; ">2.00</td><td style="text-align:right; ">60.00%</td><td style="text-align:right; "> * * * * * * * * * *1.2 </td><td style="text-align:right; "> * * * * * * * * * 1.2 </td><td style="text-align:right; "> * * * * * * * *1.20 </td><td style="text-align:right; "> * * * 24.10 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 1.20 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Server9</td><td style="text-align:right; ">1.00</td><td style="text-align:right; ">60.00%</td><td style="text-align:right; "> * * * * * * * * * *0.6 </td><td style="text-align:right; "> * * * * * * * * * 0.6 </td><td style="text-align:right; "> * * * * * * * *0.60 </td><td style="text-align:right; "> * * * 23.50 </td><td style="text-align:right; "> * * * * * * * * * * - *</td><td style="text-align:right; "> * * * * * * * 0.60 </td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >*</td><td >*</td><td >*</td><td style="text-align:right; "> * * * * * * * * *50.5 </td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >*</td><td >*</td><td >*</td><td style="text-align:right; ">Total Load to be distributed</td><td style="text-align:right; ">60</td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >*</td><td >*</td><td >*</td><td style="text-align:right; ">Total Distributed</td><td style="text-align:right; "> * * * * * * * 50.50 </td><td >*</td><td >*</td><td >*</td><td >*</td></tr><tr style="********20px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >*</td><td >*</td><td >*</td><td style="text-align:right; ">Excess / (Undistributed)</td><td style="text-align:right; "> * * * * * * * *(9.50)</td><td >*</td><td >*</td><td >*</td><td >*</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >G1</td><td >=E13</td></tr><tr><td >F2</td><td >=MIN(E2, G1)</td></tr><tr><td >G2</td><td >=G1-F2</td></tr><tr><td >H2</td><td >=MIN($D2-$E2, $G$10*<span style=' color:008000; '>(<span style=' color:#0000ff; '>(D2-E2)</span>/SUMPRODUCT<span style=' color:#0000ff; '>($D$2:$D$10-$E$2:$E$10)</span>)</span>)</td></tr><tr><td >I2</td><td >=F2+H2</td></tr><tr><td >D11</td><td >=SUM(D2:D10)</td></tr><tr><td >E14</td><td >=SUM(I2:I10)</td></tr><tr><td >E15</td><td >=E14-E13</td></tr></table></td></tr></table>