LumberJocks

Excel Spreadsheet as a Design Tool

  • Advertise with us
Project by newTim posted 07-13-2008 07:25 PM 5072 views 14 times favorited 16 comments Add to Favorites Watch

From a previous post, here’s one way I use Excel to plan out dimensions. If there’s a way I could post the actual spreadsheet file for a better look. Can this be done?

-- tim hill www.newcalshop.com





16 comments so far

View ChicoWoodnut's profile

ChicoWoodnut

904 posts in 2570 days


#1 posted 07-13-2008 07:55 PM

Hi Tim,

You will need some place on the internet to store the file and then provide a link to let others download it. Here is microsofts file storage solution

There are many others to choose from. Let me know if you need any help. Consulting fees come in at just ~$120/hr (125 Canadian)

Just kidding.

-- Scott - Chico California http://chicowoodnut.home.comcast.net

View lew's profile

lew

10168 posts in 2510 days


#2 posted 07-13-2008 07:56 PM

You could use Google Documents. Store the spreadsheet there and share it. Post the link here.

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View Miket's profile

Miket

308 posts in 2527 days


#3 posted 07-13-2008 07:58 PM

You could also use http://www.box.net

It does the same. Giving you a link so others can download the file. It’s free.

-- It's better to have people think you're stupid rather than open your mouth and remove all doubt.

View Woodhacker's profile

Woodhacker

1139 posts in 2478 days


#4 posted 07-13-2008 08:01 PM

Tim, count me as one interested in seeing how you use excel in this way. Thanks.

-- Martin, Kansas

View newTim's profile

newTim

556 posts in 2361 days


#5 posted 07-14-2008 12:27 AM

To save a copy of a graph spreadsheet go to my website at www.newcalshop.com and click the ‘Click Here to Download Excel Graph Paper File’ on the right side above Tim’s Favorite Links.

There’s not much to it but you can get an idea of the possibilities.

-- tim hill www.newcalshop.com

View brianinpa's profile

brianinpa

1810 posts in 2478 days


#6 posted 07-14-2008 01:58 AM

Tim, I like that! I can even see me using it for my next major undertaking.

-- Brian, Lebanon PA, If you aren’t having fun doing it, find something else to do.

View lew's profile

lew

10168 posts in 2510 days


#7 posted 07-14-2008 02:25 AM

Just downloaded your spreadsheet. Now that is a creative use of Excel!!

Lew

-- Lew- Time traveler. Purveyor of the Universe's finest custom rolling pins.

View CharlieM1958's profile

CharlieM1958

15822 posts in 2973 days


#8 posted 07-14-2008 03:38 AM

Thanks for the download, Tim. Now you’ve got my full respect not only as a woodworker, but as an Excel geek!

-- Charlie M. "Woodworking - patience = firewood"

View tenontim's profile

tenontim

2131 posts in 2499 days


#9 posted 07-14-2008 04:08 AM

Great idea, Tim. It’s very obvious when you see it, that Excel is perfect for making a 2D scale drawing. Thanks for the post and the download.

View Joe Lyddon's profile

Joe Lyddon

7952 posts in 2807 days


#10 posted 07-14-2008 07:31 PM

I have always used MS Paint program for my drawings… I have a Starting file that has a Ruler at the top, bottom, & both sides to make it easier to draw lines, etc. Using Copy/Paste also makes it easier.

I have never tried Excel for doing this…

Sounds interesting… will let you know how I do with it…

Oh, I’ve also tried the FREE Google Sketchup program… have never had a more FRUSTRATING time in my life! Once you get to know some of the Tricks of the program, it can be very useful too… It’s really a COOL program… BUT, so powerful that it’s NOT the easiest program to learn.

Thank you.

-- Have Fun! Joe Lyddon - Alta Loma, CA USA - Home: http://www.WoodworkStuff.net ... My Small Gallery: http://www.ncwoodworker.net/pp/showgallery.php?ppuser=1389&cat=500"

View Taigert's profile

Taigert

593 posts in 2595 days


#11 posted 07-14-2008 08:00 PM

I didn’t know you could do that with excel, thats cool

I’ll have to give it a try

Thanks for the info

-- Taigert - Milan, IN

View newTim's profile

newTim

556 posts in 2361 days


#12 posted 07-14-2008 08:01 PM

Excel works well if you have a bunch of smaller parts that have to fit together. Like a cabinet with drawers. You can ‘program’ excel so that every dimension is automatically updated when a single dimension is changed. You can also create a rough and finished cutlist that will also automatically update.

You can also use it to figure out a cutting plan for sheet goods. It works real well if you want to match up grain as in drawers or cabinet doors.

You can get through the planning very quickly which is what I need as I don’t have enough time to devote to highly detailed planning, but, like all of us, still need to plan before getting into the shop to mess things up.

-- tim hill www.newcalshop.com

View brad's profile

brad

136 posts in 2659 days


#13 posted 07-14-2008 08:44 PM

I’m somewhat of an “excel Geek” myself….this is very cool. Thanks for sharing

-- Brad,--"The way to eat an eliphant is one bite at a time"

View Tim Scoville's profile

Tim Scoville

97 posts in 2090 days


#14 posted 04-25-2009 11:38 PM

Do you still have your spreadsheets for cabinet layouts?

Tim

-- Tim S, WA

View woodfin's profile

woodfin

9 posts in 1768 days


#15 posted 05-12-2010 03:27 PM

wow, more details

-- Woody Harry, Pine Mtn, GA

showing 1 through 15 of 16 comments

Have your say...

You must be signed in to post the comments.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com

Latest Projects | Latest Blog Entries | Latest Forum Topics

GardenTenders.com :: gardening showcase