Excel type question...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Excel type question.... have I got my sums right?!

8 Posts
3 Users
0 Reactions
49 Views
Posts: 4686
Full Member
Topic starter
 

Need some reassurance that I've got this right... I've created an Excel spreadsheet to help me calculate the best value dressed redwood from a timber merchants. I've got the thickness, breadth, worked out the cross-sectional area, then the volume per metre length, number then required for a metre cubed, then price...

Plan is to build a laminated workbench, btw. If my spreadsheet is correct then the second best option would be my preferred - 45 x 95mm.

Ta!

[img] [/img]


 
Posted : 07/04/2017 9:04 am
Posts: 17273
Free Member
 

Are you making a solid cube of timber?


 
Posted : 07/04/2017 9:07 am
Posts: 71
Free Member
 

Have you thought about wastage? You don't actually want a cubic metre of timber, you want a piece of XxYxZ for a workbench. If you want a worktop 35mm thick then paying for 45mm thick is a waste of materials, even if it's cheaper on paper.

As you say 90x45 would be preferable I'd say you're fine though. Although why not just go for 145x45 as it's 20% cheaper?


 
Posted : 07/04/2017 9:08 am
Posts: 4686
Full Member
Topic starter
 

Are you making a solid cube of timber?

No - that was just a cost comparison method!

As you say 90x45 would be preferable I'd say you're fine though. Although why not just go for 145x45 as it's 20% cheaper?

Ta. The 145x45 would be a bit overkill in terms of thickness but a laminated top 95mm thick would be ideal.


 
Posted : 07/04/2017 9:14 am
Posts: 17273
Free Member
 

No - that was just a cost comparison method!

....and an irrelevant one.

Unless you're buying it by the cubic metre.

Pick the lowest linear metre rate that's thick enough to meet your needs.

You may be overthinking this a bit.


 
Posted : 07/04/2017 9:20 am
Posts: 4686
Full Member
Topic starter
 

You may be overthinking this a bit.

Yeah - undoubtedly!


 
Posted : 07/04/2017 9:24 am
Posts: 17273
Free Member
 

Are you talking about using lengths of timber , butted together to forma solid top?

If so, the calculation you need is cost per m2 of surface area so you need to work out how many 1 m long widths of each size of timber you would need to form the width of workbench you require and then multiply that by the linear metre rate for comparison.

e.g you would need twice as many 45 x 45 than 45 x 95 to form a 45mm thick worktop.


 
Posted : 07/04/2017 9:29 am
Posts: 4686
Full Member
Topic starter
 

Are you talking about using lengths of timber , butted together to forma solid top?

Indeed. The same timber would also be glued together to make the legs, etc. It would be a variation on the Paul Sellers design:

[img] [/img]

A top 95mm thick would be ideal, as would legs 95 x 90mm.

Cheers.


 
Posted : 07/04/2017 9:37 am
Posts: 71
Free Member
 

Ah ha, I was assuming you were going for 45mm thick, with 90mm width, not t'other way around.

I'd go 45x90 then.


 
Posted : 07/04/2017 9:48 am

6 DAYS LEFT
We are currently at 95% of our target!