How much would I need?

[m5rcc]

Morning all,

I wonder if anyone can help for potentially a simple Excel solution.

I send a lot of items in the post and with the price increase by the Royal Mail I now need different stamps than before.

Is it possible to create a spreadsheet that would give me a solution to the question "How many stamps would I need to make.." whatever I need, whether it's £6.71 or £13.27 or £18.01.

There would most probably be no exact answer, so it could be say, one would need 4 x First, 3 x Second, 1 x 14p and there could be a few permutations to get the same answer, however, how do I go about creating such a spreadsheet?

The stamps I have are as follows:

[TABLE="width: 35"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]0.53[/TD]
[/TR]
[TR]
[TD="align: right"]0.62[/TD]
[/TR]
[TR]
[TD="align: right"]0.76[/TD]
[/TR]
[TR]
[TD="align: right"]0.93[/TD]
[/TR]
[TR]
[TD="align: right"]1.28[/TD]
[/TR]
[TR]
[TD="align: right"]1.72[/TD]
[/TR]
[TR]
[TD="align: right"]2.03[/TD]
[/TR]
[TR]
[TD="align: right"]6.4


[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"]
Any help would be most welcome![/TD]
[/TR]
</tbody>[/TABLE]

 

[hippiehacker]

just pm me your mail address i will send you a worksbook

 

[hippiehacker]

sent you a mail with the workbook

 

[m5rcc]

sent you a mail with the workbook

Thanks - I've replied

 

[m5rcc]

Actually one thing I have noticed, is that it rounds up, which is not really what I want to achieve.

For example, if I put 3.90, it will round up to the nearest perfect permutation, i.e. 3.93 (giving
[TABLE="width: 490"]
<tbody>[TR]
[TD]+1.72+1.28+0.93
[/TD]
[/TR]
[TR]
[TD]+2.03+1.28+0.62)
[/TD]
[/TR]
</tbody>[/TABLE]


I don’t want that. If it’s 3.90 I want me to give it the best possible permutation WITH the smallest remainder, for example, 3 x 1.28 with 6p remainder.

Can that be achieved?

 

[m5rcc]

Does anyone know how to 'undervalue' as opposed to over value the calculation?