Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Board Foot Calculator Spreadsheet

1,314 views
Skip to first unread message

GarageWoodworks

unread,
Dec 14, 2009, 12:28:37 AM12/14/09
to
Hey Gang,

I made a board feet calculator/spreadsheet. I included the lumber
prices for “The Hardwood Store” (where I go in NC). You select your
lumber and thickness from a drop-down list and input length width etc.
The prices change automatically depending on how many bd feet you are
buying (my lumber yard has this feature, you can remove it by having
the same price for all amounts if you need to).

The sheet is “locked” to prevent unwanted accidental changes, but you
can unlock it if you need to.

download:
http://www.garagewoodworks.com/lumber_bd_feet.xls
or here: http://www.garagewoodworks.com/lumberstorage.php (check back
for improvements/mods)

You can change the prices to your lumber yard (in Sheet Two). Let me
know what you think.

It would be nice to take this spreadsheet with me to the lumber yard
and calculate on the fly. There are some iPhone apps that can use
Excel spreadsheets, Documents to Go is one example. Unfortunately
Docs2Go doesn’t like the functions I used in this spreadsheet. Know of
any others that will?

SonomaProducts.com

unread,
Dec 14, 2009, 2:43:12 PM12/14/09
to
Hey, now if you can include the yards tendancy to always round up in
their own favor, and add in undocumented "mill" charges and prices
that change from what you were quoted a week ago over the phone you
might get something that even comes close to what they actually end up
charging.

On Dec 13, 9:28 pm, GarageWoodworks <bgre...@garagewoodworks.com>
wrote:


> Hey Gang,
>
> I made a board feet calculator/spreadsheet. I included the lumber
> prices for “The Hardwood Store” (where I go in NC). You select your
> lumber and thickness from a drop-down list and input length width etc.
> The prices change automatically depending on how many bd feet you are
> buying (my lumber yard has this feature, you can remove it by having
> the same price for all amounts if you need to).
>
> The sheet is “locked” to prevent unwanted accidental changes, but you
> can unlock it if you need to.
>
> download:http://www.garagewoodworks.com/lumber_bd_feet.xls

> or here:http://www.garagewoodworks.com/lumberstorage.php(check back

evodawg

unread,
Dec 14, 2009, 5:01:15 PM12/14/09
to
GarageWoodworks wrote:

Works great in Open Office/Linux too. You must have set up all night
entering price data??

--
"You can lead them to LINUX
but you can't make them THINK"
Running Mandriva release 2008.0 free-i586 using KDE on i586
Website Address http://rentmyhusband.biz/

evodawg

unread,
Dec 14, 2009, 5:05:37 PM12/14/09
to
GarageWoodworks wrote:

OBTW what program are you using to load your images on your website?
Thinking about using something similar on my site.

GarageWoodworks

unread,
Dec 14, 2009, 7:06:55 PM12/14/09
to
On Dec 14, 5:01 pm, evodawg <evod...@nospam.com> wrote:
> GarageWoodworks wrote:
> > Hey Gang,
>
> > I made a board feet calculator/spreadsheet. I included the lumber
> > prices for “The Hardwood Store” (where I go in NC). You select your
> > lumber and thickness from a drop-down list and input length width etc.
> > The prices change automatically depending on how many bd feet you are
> > buying (my lumber yard has this feature, you can remove it by having
> > the same price for all amounts if you need to).
>
> > The sheet is “locked” to prevent unwanted accidental changes, but you
> > can unlock it if you need to.
>
> > download:
> >http://www.garagewoodworks.com/lumber_bd_feet.xls
> > or here:http://www.garagewoodworks.com/lumberstorage.php(check back

> > for improvements/mods)
>
> > You can change the prices to your lumber yard (in Sheet Two). Let me
> > know what you think.
>
> > It would be nice to take this spreadsheet with me to the lumber yard
> > and calculate on the fly. There are some iPhone apps that can use
> > Excel spreadsheets, Documents to Go is one example. Unfortunately
> > Docs2Go doesn’t like the functions I used in this spreadsheet. Know of
> > any others that will?
>
> Works great in Open Office/Linux too. You must have set up all night
> entering price data??
>
> --
> "You can lead them to LINUX
> but you can't make them THINK"
> Running Mandriva release 2008.0 free-i586 using KDE on i586
> Website Addresshttp://rentmyhusband.biz/

Copy - Paste

GarageWoodworks

unread,
Dec 14, 2009, 7:09:38 PM12/14/09
to
On Dec 14, 5:05 pm, evodawg <evod...@nospam.com> wrote:
> GarageWoodworks wrote:
> > Hey Gang,
>
> > I made a board feet calculator/spreadsheet. I included the lumber
> > prices for “The Hardwood Store” (where I go in NC). You select your
> > lumber and thickness from a drop-down list and input length width etc.
> > The prices change automatically depending on how many bd feet you are
> > buying (my lumber yard has this feature, you can remove it by having
> > the same price for all amounts if you need to).
>
> > The sheet is “locked” to prevent unwanted accidental changes, but you
> > can unlock it if you need to.
>
> > download:
> >http://www.garagewoodworks.com/lumber_bd_feet.xls
> > or here:http://www.garagewoodworks.com/lumberstorage.php(check back

> > for improvements/mods)
>
> > You can change the prices to your lumber yard (in Sheet Two). Let me
> > know what you think.
>
> > It would be nice to take this spreadsheet with me to the lumber yard
> > and calculate on the fly. There are some iPhone apps that can use
> > Excel spreadsheets, Documents to Go is one example. Unfortunately
> > Docs2Go doesn’t like the functions I used in this spreadsheet. Know of
> > any others that will?
>
> OBTW what program are you using to load your images on your website?
> Thinking about using something similar on my site.
>
> --
> "You can lead them to LINUX
> but you can't make them THINK"
> Running Mandriva release 2008.0 free-i586 using KDE on i586
> Website Addresshttp://rentmyhusband.biz/

Image Thumbnail Viewer:
http://www.dynamicdrive.com/dynamicindex4/thumbnail.htm

GarageWoodworks

unread,
Dec 14, 2009, 7:11:28 PM12/14/09
to

My yard guys come very close. When I went last weekend a large piece
of 8/4 cherry was priced in my favor by a few bucks.

evodawg

unread,
Dec 15, 2009, 9:21:33 AM12/15/09
to
GarageWoodworks wrote:

Thanks

Joe

unread,
Dec 19, 2009, 10:40:42 AM12/19/09
to

"SonomaProducts.com" <bwx...@yahoo.com> wrote in message
news:1689062f-8948-4b84...@u1g2000pre.googlegroups.com...

Hey, now if you can include the yards tendancy to always round up in
their own favor, and add in undocumented "mill" charges and prices
that change from what you were quoted a week ago over the phone you
might get something that even comes close to what they actually end up
charging.

I've never found a single instance of the yard I use rounding in anyone's
favor but mine. Sorry your experience hasn't been the same.

Price changes over the course of a week? That's pretty standard, imo.

I thought it was a useful sheet.


0 new messages