Price per cube, superfoot and converter

**steve54123alt** · 28th June 2005, 12:15 PM

Well I hope that this has not be done before, because I just spent an hour or two trying to get it right…<o =""></o>

What it is a calculator that will change all the common units of measure into all the other common units of measure, (only those that I use in the course of woodwork.)<o =""></o>

For example if I have a piece of timber that 1’x1’x1’ and because I’m young and grew up with the metric system I would like that converted to say… millimetres, or Centimetres, or even to a Cube!!! I just enter the measurements that I have in the appropriate boxes and vola!<o =""></o>

But say I’m slightly older and I use inches to measure my boards, and I would like to know how many Super-feet I have… (This is the bit that took the two hours!) I just enter the inches in the inches section and Vola!<o =""></o>

But there is another section which I think is the most worthy, cause until now it’s just a normal calculator… It helps you get an overall price for the timber!<o =""></o>

You enter the size to the timber you have say, 12”x12”x1” (a super-foot) and you also enter the price that you paid and hit enter and straight away with no adding multiplying or CONVERSION! It will give you the price in Super-feet AND the price per CUBE!!!<o =""></o>

I’ve only just finished so there may be a bug or two but I think I got on top of it??? <o =""></o>
You need to have Microsoft Excel or similar spreadsheet program on your computer for it to open, but give it a test run and let me know what you think. It’s a work in progress so feedback is wanted.<o =""></o>

The spreadsheet in protected so you can only enter details in the clear boxes (cells). <o =""></o>

Now to attach the file??? Hmmm hope this works. (You should be able to right click the attachment and left click “save as” or “save target as” and save it where you will be able to find it and give it a run for it’s money.

Cheers
Steve

**steve54123alt** · 28th June 2005, 12:19 PM

What the???

try again...
nope invalid file type... hang on.

**E. maculata** · 28th June 2005, 12:33 PM

Steve, I used to have a program in a handheld for the field, that did some of this, but unfortunately when the battery died, so did my equations...no hardcopy

So I for one would be interested in how yours goes.

**steve54123alt** · 28th June 2005, 12:37 PM

Ok try this...

www.stevecalculator.0catch.com/calculator.xls

still have to right click or it might open in your browser if you left click????

**steve54123alt** · 28th June 2005, 12:41 PM

stupid free web hoasting... please hold

**steve54123alt** · 28th June 2005, 12:51 PM

All sorted!

Try this one.

www.viviendwyer.com.au/calc.xls

It just opened in my browser, or you can save it as before..

cheers
steve.

**shaunburgess** · 28th June 2005, 12:59 PM

Incredible, now i understand what the old fella's are talking about in their feet and inches. I was always confused when that said they had 6 feet (gees talk about expensive shoes)

**steve54123alt** · 28th June 2005, 01:05 PM

hehehe! expensive shoes... thanks shawn. those damed feet took the longest!

**Simomatra** · 28th June 2005, 01:22 PM

Thanks Steve

Have saved it night come in handy for an old fella with small feet

Sam

**Scally** · 28th June 2005, 02:19 PM

I like it Steve
I grew up in the age of conversion so I am constantly converting things.

This should be pretty handy when comparing prices of timber from different sources.

**steve54123alt** · 28th June 2005, 06:17 PM

thanks scally, i'm finding it very useful for just that purpose.

**Optimark** · 28th June 2005, 09:20 PM

Steve, since 1975 I've had a Canon calculator (FC-43) which is a metric converter. It's the only calculator, with which I can use every function.

However it's main use for the last 20 years, has been to convert imperial to metric from any USA plans or schematic diagrams of USA machinery.

Woodworking magazines from America, also have had their measurements converted using the calculator.

That may change, this little spreadsheet could make it reasonably redundant when it comes to woodworking.

I changed to metric in the seventies and am glad I did, things are much easier, mostly!

Many thanks, for sharing this tool.

Mick.

**FlyingDuck** · 28th June 2005, 09:32 PM

Just a question about the price paid field - I take it the price you enter is the price per cubic metre or super foot. Perhaps you could modify the program so you can enter a choice of the three pricing methods of price per L/M, square metre or cubic metre (and imperial equivalents), as timber is sold in any of these methods, and it also would be great if say you paid in L/M, to see the equivalent price in square metres and cubic metres. This would make the program super useful for me.

**Arron** · 28th June 2005, 11:37 PM

Nice. thanks.

Ps. any thoughts abut adding 'board feet', or is that 'super feet'.

Arron

**steve54123alt** · 29th June 2005, 11:15 AM

Michaelvass. I think I understand your question and if I do... that is exactly what the program is for.
You work left to right.<o =""></o>

An example.<o =""></o>

You go to the shop and buy a piece of timber that is 8”x1” and is 72” long. And you pay $200! Fair enough, it’s a nice piece of rosewood with some good figure. So you enter in the inches section, 72, 8 and 1 respectively as you do that it will convert these measurements to metric, and to cubes, and Super feet. You also enter on the right the 200 you paid and for the board. And it will give you the price that a cube of that timber would have cost. Thus enabling you to compare the overall price of irregularly shape timber to a standard.
In this case the 200 bucks you spent on this piece of 8x1 equates to over 20K per cube!!! You got spanked!!! Or did you? The timber was DAR…<o =""></o>

Aaron, Board feet are just that…. Super feet! 12”x12”x1”<o =""></o>
 <o =""></o>

Thanks for the feedback guys.

Thread: Price per cube, superfoot and converter

Thread Tools

Search Thread

Price per cube, superfoot and converter

no attachment

done, i think

Haha!!!!

hehehe

Tags for this Thread

Posting Permissions