meter cube price to board size price - conversion tool

[old_picker]

anyone know of a utility that will convert a cube price to say 200 x50 or 150x25 or other sizes as required

my brain is finding it tricky to do the sums
excel would do a great job
input meter cube price and board size to yeild a per meter board price
thanks

[NZStu]

I've knocked one up for you quickly - pretty self explanatory: just enter your m/3 price in the blue box and it'll give you a little matrix of linear meter prices of common sizes. Or you can put custom sizes in the green boxes. If you're feeling truly lazy, you can put a length into the yellow box next to those to get a total price for a piece or pieces.

Hope that's what you're after...

[Brosh]

Nicely done NZ Stu - I've just tried your spreadsheet and it is easy and straight forward. Thanks

Brosh

[old_picker]

thanks stu - very neat and exactly what i was after
i usually sit here with a pen and paper scribbling away for an hour and invariably vcome up with a number that is wrong

i am pretty remedial with excel - my brain wont quite get around how it all works

[Rattrap]

Works a bloody treat! thanks so much Stu.

[NZStu]

Glad to be of assistance

[cava]

Just saw this, and it will come in very handy. It's just what I need.

[Pilchard]

Takes the rough calls out of the equation. Shame if your a buyer though and the bloke ain't as quick as you.