# Want to calculate square footage of shapes in excel

=?Utf-8?B?TXVkZGxlZA==?=
Guest
Posts: n/a

 9th Jul 2007
In the drawings section, I am wondering how to calculate the square footage
of shapes I put together to mock up countertop drawings. Ideally I want to
set it up so my drawings are 1/4" to the foot scale. Can anyone help on this?
--
DG

=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a

 9th Jul 2007
You're going to do this in Excel? Be warned that scaling in Excel gets
'corrupted' when it is printed out. A better tool for this would be Visio if
you have it available.

Basically, in Excel, you'd put rectangle shapes on your worksheet and use
their properties to set their height/width (and rotation?) while at the same
time setting up formulas to calculate the square footage. Since I'd assume
you already have the actual dimensions available, and you're using 1/4" = 1
foot. To calculate the size of the rectangles, I'd set up a little table
like this:

A B C D
E
1 Feet Inches Total in.
Scale
2 Depth 2 6 =B2+(C2/12) =D2*0.25
3 Width 6 3 =B3+(C3/12) =D3*0.25

Column E will give you the dimensions for your drawing element. By putting
the feet and inches into 2 columns, you don't have to do that part of the

"Muddled" wrote:

> In the drawings section, I am wondering how to calculate the square footage
> of shapes I put together to mock up countertop drawings. Ideally I want to
> set it up so my drawings are 1/4" to the foot scale. Can anyone help on this?
> --
> DG

=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a

 9th Jul 2007
Oh, for the square footage - you could put this in F3:
=D2*D3
and if you want to convert from the scaled dimensions it would look like this:
=(E2*4)*(E3*4)

"Muddled" wrote:

> In the drawings section, I am wondering how to calculate the square footage
> of shapes I put together to mock up countertop drawings. Ideally I want to
> set it up so my drawings are 1/4" to the foot scale. Can anyone help on this?
> --
> DG

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post ShadowDragon28 Windows XP MovieMaker 1 8th Jul 2008 08:41 AM =?Utf-8?B?RVhDRUwgQ09NUEFSSVNPTlMgU1BSRUFEU0hFRVQ= Microsoft Excel Misc 1 31st Jul 2007 09:45 PM Chip Pearson Microsoft Excel Misc 0 16th Jan 2007 11:39 PM xxnonexspamxnonexx@tampascanner.info Freeware 3 17th Apr 2006 01:44 AM keepitcool Microsoft Excel Programming 3 21st Nov 2003 05:55 AM

Features