Results 1 to 7 of 7
Thread: Formula help (XP)

20071220, 22:23 #1
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Formula help (XP)
Example: I have been given the dimensions of a corridor by the designer of a building. The dimensions are 8 feet x 27.75 feet. If I multiply that out, using Excel, the answer is exactly 222 square feet. The total square feet number that must be reported to the State of California for this type of corridor, however, is only 1/3 of the total. The architect tells me he reported 73.26 square feet to the State. The "factor" they use is .33 . . . . I have been just multiplying the number of square feet reported to the State by 3 and assuming that would return the actual total square feet of any given space.
Am I doing this incorrectly? Math is NOT my forte . . .
Thanks again
Aunt Linda

20071220, 22:34 #2
 Join Date
 Feb 2002
 Location
 A Magic Forest in Deepest, Darkest Kent
 Posts
 5,681
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: Formula help (XP)
It sounds like some one has their feet and yards mixed up!!!!
8' x 27.75' =222 sq ft
Convert to yards by dividing by 3
8/3 x 27.75/3 = 2.7 x 9.25 = 24.7 sq yds
bbbbuuuttt
2.7 x 27.75 = 74 sq yds
I think somebody has made a mistake by not dividing by 3Jerry

20071220, 23:22 #3
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Formula help (XP)
Yards are not involved . . . at all! I've attached a little itty bitty sample of what the heck I'm talking about  perhaps that will clear what is obviously very, very muddy waters  up.
Me

20071220, 23:27 #4
 Join Date
 Jan 2001
 Posts
 3,788
 Thanks
 0
 Thanked 1 Time in 1 Post
Re: Formula help (XP)
The formula for D2 is:
<code>=C2*0.33</code>

20071220, 23:30 #5
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 28 Times in 28 Posts
Re: Formula help (XP)
The factor is exactly 0.33, not 1/3 = 0.33333333...
Not idea why they use this, but it you want to calculate the "real" area from the number provided by them, divide it by 0.33.
For example, if you're given the number in D2 (73.26), use the formula =D2/0.33 to recover the number 222.

20071221, 00:00 #6
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Formula help (XP)
Your bio is terrific  had to throw that out there.
Thank you for the formula  you helped me understand one side of the problem  Hans provided the other side  now I'm balanced  HA!
Later
Linda

20071221, 00:01 #7
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Formula help (XP)
Thanks for saving me from myself  again.
Later
Linda