Permutation query involving 3 people with a limit of 45 as the sum. I'm looking to find all the combinations of numbers possible in the below example. I shall do my very best to explain the situation clearly as I'm not too sure how to derive this outcome myself. Thanks in advance.

I'm looking to have this in spreadsheet format since it will be a long list (from research it seems possible for their to be a function in a spreadsheet that can do this. If I only knew how I would do it myself!

There are 3 people. The sum of numbers between these 3 people can only equal 45 in total no more.

An example of an outcome would be something like this:

30,5,10

5,10,30

10,30,5

10,5,30

30,10,5

5,30,10

I want to extend this simplified example to show all the outcomes possible. Only conditions are that the numbers combined can't exceed 45. 0 is not considered. 

Kind regards,

Harvey :)

*Also if anyone can explain how to do this in a spreadsheet I will be very grateful.
What you are looking for would be something along the lines of $ 0 &lt; x_0 \leq 43, 0 &lt; x_1 \leq 44-x_0, 0 &lt; x_2 \leq 45-(x_0 + x_1)$ where $x_0, x_1, x_1 \in \Bbb N$.
There would be $n-1 \choose k-1$ combinations for writing non-zero positive integral solutions of
$x_1+x_2+.......x_k = n$