> >
>

# Calculatiion Conundrum

#1
04-01-10, 05:17 AM
Member
Thread Starter
Join Date: Apr 2009
Location: KC
Posts: 80
Calculatiion Conundrum

I am trying to calculate Square Ft. Of course its simple enough, even for a guy like me I did this using Excel and came out with different answers

Someone please, tell me what I'm doing wrong

A room measures 10ft 6in X 10ft 3in or as otherwise stated 126 in X 123 in

if
126 lin in x 123 lin in = 15498 sq in / 144 = 107.625 sq ft
my formula says =sum(in x in)/144

then how does
10ft 6in X 10 ft 3in = 101.5 sq ft

my formula says -sum(ft x ft)+(in x in)/144

Have I misplaced a () ?

Sponsored Links
#2
04-01-10, 05:42 AM
Member
Join Date: Oct 2008
Location: New England
Posts: 10,034
Good morning, I think you just need your coffee.
then how does
10ft 6in X 10 ft 3in = 101.5 sq ft
it doesn't
Not sure how you're multiplying feet and inches times feet and inches, but 10.5 ft X 10.25 ft = 107.625' same as above.

Try the coffee black . I won't share my brain fog episodes.

Bud

#3
04-01-10, 07:04 AM
Banned. Rule And/Or Policy Violation
Join Date: May 2007
Location: Wisconsin
Posts: 8,629
Nevermind. Bud said it. Give him all the glory.

What is odd is even if merlesdad mulitplied 10.6 X 10.3, that would not be the number he posted either. So maybe he simply rang up the wrong number when he was multiplying. But that too strikes me as odd because if he got different answers, wouldn't merlesdad have done the calcs all over again to be sure?

So where did merlesdad go wrong? I might be thinking about this all day now, rather than concentrating on my work. Somehow or another he used numbers less than 10.1 X 10.1. ???????

Maybe merlesdad should Google this all-time prize winner: "The case of the missing dollar". LOL

#4
04-01-10, 08:21 AM
Member
Join Date: Oct 2008
Location: New England
Posts: 10,034
Thanks ecman51, I need all the glory I can get .
So you concentrate on your work, I know how to re-create his answer, but not his thinking.
His second equation is wrong, my formula says -sum(ft x ft)+(in x in)/144 but even that doesn't give his answer. However, if you divide the (in x in) by 12 instead of the 144, you get 1.5, thus the 101.5 wrong answer.

Bud

#5
04-01-10, 09:14 AM
Member
Thread Starter
Join Date: Apr 2009
Location: KC
Posts: 80
It must have been that recurring flashback.

the issue at hand was being able to use feet and inches not
a decimal equivelant if inches.

to do that All I had to do was change the formula

=sum (feet X 12 + inches) X (feet X 12 + inches)/144

all this effectively does is convert the lineal feet to inches, then add the inche measurment.

Thanks to all who helped.

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 Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Thread Tools
Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode