Re: Witango-Talk: Sum of Square Root
Pong? Kaustav Acharya Web Developer U. Inc. 12264 El Camino Real, Suite #401 San Diego, CA. 92130 Office: (858) 847-3350 x1004 Fax: (858) 847-3340 email: kacha...@colleges.com http://www.colleges.com Power to the People - http://www.campaign.com Important Note: This e-mail may contain privileged, undisclosed or confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform kacha...@colleges.com Immediately and permanently destroy the original transmittal. On Aug 2, 2010, at 10:01 AM, Robert Shubert wrote: > Ping? > > From: WebDude [mailto:webd...@cipromo.com] > Sent: Thursday, July 22, 2010 10:49 AM > To: witango-talk@witango.com > Subject: RE: Witango-Talk: Sum of Square Root > > Excellent... thank you... > > > > From: Paul Wilson [mailto:pwilson@gmail.com] > Sent: Tuesday, July 20, 2010 7:56 AM > To: witango-talk@witango.com > Subject: Re: Witango-Talk: Sum of Square Root > > Excuse me, I meant the sum of the squares > > I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 > (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 > > It may be a simple as breaking up Excel's fancy SUMSQ into a formula. > sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e > > > On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson > wrote: > I believe it is the sum of the square roots. For example SUMSQ > (2,3,4) = 29 > (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 > > It may be a simple as breaking up Excel's fancy SUMSQ into a formula. > sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e > > > > On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: > I was given an excel file that needs to be converted to a web page. > I am not a Math guru and was wondering if someone could help me out. > > The form has some fields with a formula that looks like this (cell > e is the result)... > > =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e > > bc d e > > Reference: > > > > 0.00 > Sample Measurement: > > > > > All 6 yellow cells will be inputs. What I don't get is how to sum a > square root. Any help would be appreciated. > > Thanks! > > p.s. I hope the format of this email doesn't fall apart. > > __ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > __ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > __ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > To unsubscribe to this list, please send an email to > mails...@witango.com with "unsubscribe witango-talk" in the body. To unsubscribe from this list, please send an email to mails...@witango.com with "unsubscribe witango-talk" in the body.
RE: Witango-Talk: Sum of Square Root
pong _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Monday, August 02, 2010 12:02 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: Sum of Square Root Ping? From: WebDude [mailto:webd...@cipromo.com] Sent: Thursday, July 22, 2010 10:49 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Sum of Square Root Excellent... thank you... _ From: Paul Wilson [mailto:pwilson@gmail.com] Sent: Tuesday, July 20, 2010 7:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Sum of Square Root Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson wrote: I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf _ To unsubscribe to this list, please send an email to mails...@witango.com with "unsubscribe witango-talk" in the body. To unsubscribe from this list, please send an email to mails...@witango.com with "unsubscribe witango-talk" in the body.
RE: Witango-Talk: Sum of Square Root
Ping? From: WebDude [mailto:webd...@cipromo.com] Sent: Thursday, July 22, 2010 10:49 AM To: witango-talk@witango.com Subject: RE: Witango-Talk: Sum of Square Root Excellent... thank you... _ From: Paul Wilson [mailto:pwilson@gmail.com] Sent: Tuesday, July 20, 2010 7:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Sum of Square Root Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson wrote: I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf To unsubscribe to this list, please send an email to mails...@witango.com with "unsubscribe witango-talk" in the body.
RE: Witango-Talk: Sum of Square Root
Excellent... thank you... _ From: Paul Wilson [mailto:pwilson@gmail.com] Sent: Tuesday, July 20, 2010 7:56 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: Sum of Square Root Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson wrote: I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Sum of Square Root
Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson wrote: > I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 > (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 > > It may be a simple as breaking up Excel's fancy SUMSQ into a formula. > sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e > > > > On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: > >> I was given an excel file that needs to be converted to a web page. I am >> not a Math guru and was wondering if someone could help me out. >> >> The form has some fields with a formula that looks like this (cell e is >> the result)... >> >> =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e >> >> bc d e >>Reference: 0.00 Sample Measurement: >> >> All 6 yellow cells will be inputs. What I don't get is how to sum a square >> root. Any help would be appreciated. >> >> Thanks! >> >> p.s. I hope the format of this email doesn't fall apart. >> >> >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> >> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Sum of Square Root
I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:31 AM, WebDude wrote: > I was given an excel file that needs to be converted to a web page. I am > not a Math guru and was wondering if someone could help me out. > > The form has some fields with a formula that looks like this (cell e is the > result)... > > =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e > > bc d e >Reference: 0.00 Sample Measurement: > > All 6 yellow cells will be inputs. What I don't get is how to sum a square > root. Any help would be appreciated. > > Thanks! > > p.s. I hope the format of this email doesn't fall apart. > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Sum of Square Root
Here's a few examples and explanation of the 2 functions. http://www.techonthenet.com/excel/formulas/sumsq.php http://www.techonthenet.com/excel/formulas/sqrt.php Kind regards, WebLogoEmail Rick Sanders Canada: 902-431-7279 USA: 919-799-9076 www.webenergy.ca mcseSmall From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, July 20, 2010 9:32 AM To: witango-talk@witango.com Subject: Witango-Talk: Sum of Square Root I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf<><>
Witango-Talk: Sum of Square Root
I was given an excel file that needs to be converted to a web page. I am not a Math guru and was wondering if someone could help me out. The form has some fields with a formula that looks like this (cell e is the result)... =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e bc d e Reference: 0.00 Sample Measurement: All 6 yellow cells will be inputs. What I don't get is how to sum a square root. Any help would be appreciated. Thanks! p.s. I hope the format of this email doesn't fall apart. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf