Excel - generating data with specific criteria
<p>I want to do the following in Excel, without VBA/macros:</p>

<ol>
<li><p>input a number, e.g. 10.97</p></li>
<li><p>output a distribution with the following criteria:</p>

<ul>
<li><p>total numbers in distribution = 52</p></li>
<li><p>sum of 52 numbers = input of 10.96</p></li>
<li><p>numbers should be percentages, starting at 100% and declining each time</p></li>
</ul></li>
</ol>

<p>If this isn't clear, here is the reverse:
the sum of this set of numbers is 10.96. </p>

<pre><code>100%
62%
45%
39%
37%
35%
33%
31%
31%
28%
27%
26%
25%
23%
22%
22%
22%
21%
20%
20%
19%
18%
18%
17%
16%
16%
14%
13%
13%
13%
13%
13%
14%
14%
14%
14%
14%
13%
13%
13%
13%
13%
13%
13%
13%
12%
12%
10%
9%
9%
9%
10%
</code></pre>