10-20 Measurements with Excel

[Guest guest]

I am trying to put together an Excel spreadsheet that calculates the 10-

20 locations once you have the measurements from inion to nasion, ear-

to-ear, and head circumference. All the measurements are in

millimeters.

I am running into a problem. Math is not my strong area, and I am

having difficulty coming up with an Excel formula for F3, F4, P3, and

P4. It looks like they are not strictly 20% from Fz or Pz but an

intersection between Fz and F5 or F6 and Pz and F7 or F8.

Does anyone have any ideas?

[Guest guest]

,

The attached file is from the Level 1 workshop, used in Attention Development Programs days in Atlanta.

There are two additional meridians beyond the ones you mentioned. The C3 and C4 meridians are the same as the front/back through Cz, except they go through C3 and C4 starting at nasion and ending at inion. F3 and F4 are 30% from the nasion on those; P3 and P4 are 70% from the nasion.

Pete

I am trying to put together an Excel spreadsheet that calculates the 10-20 locations once you have the measurements from inion to nasion, ear-to-ear, and head circumference. All the measurements are in millimeters. I am running into a problem. Math is not my strong area, and I am having difficulty coming up with an Excel formula for F3, F4, P3, and P4. It looks like they are not strictly 20% from Fz or Pz but an

intersection between Fz and F5 or F6 and Pz and F7 or F8.Does anyone have any ideas? -- Van Deusen

pvdtlc@...http://www.brain-trainer.com305/433-3160The Learning Curve, Inc.

[Guest guest]

Thanks, Pete!  This is a great tool!

Jill

From: braintrainer [mailto:braintrainer ] On Behalf Of Van Deusen

Sent: Tuesday, April 24, 2007 4:00

AM

To: braintrainer

Subject: Re: 10-20

Measurements with Excel

,

The attached file is from the Level 1 workshop, used in Attention

Development Programs days in Atlanta.

There are two additional meridians beyond the ones you mentioned.

The C3 and C4 meridians are the same as the front/back through Cz, except they

go through C3 and C4 starting at nasion and ending at inion. F3 and F4

are 30% from the nasion on those; P3 and P4 are 70% from the nasion.

Pete

On 4/24/07,

<ecnath> wrote:

I am trying to put

together an Excel spreadsheet that calculates the 10-

20 locations once you have the measurements from inion to nasion, ear-

to-ear, and head circumference. All the measurements are in

millimeters.

I am running into a problem. Math is not my strong area, and I am

having difficulty coming up with an Excel formula for F3, F4, P3, and

P4. It looks like they are not strictly 20% from Fz or Pz but an

intersection between Fz and F5 or F6 and Pz and F7 or F8.

Does anyone have any ideas?

--

Van Deusen

pvdtlcgmail

http://www.brain-trainer.com

305/433-3160

The Learning Curve, Inc.

--

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 4/19/2007 5:56 PM

--

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 4/19/2007 5:56 PM

[Guest guest]

I am using Yahoo for reading the newsgroup and am unable to download

Pete's file. WOuld someone mind posting it to the files section or

even emaling me the file to ecnath@...? I would appreciate it.

> >

> > I am trying to put together an Excel spreadsheet that

calculates the 10-

> > 20 locations once you have the measurements from inion to nasion,

ear-

> > to-ear, and head circumference. All the measurements are in

> > millimeters.

> >

> > I am running into a problem. Math is not my strong area, and I am

> > having difficulty coming up with an Excel formula for F3, F4, P3,

and

> > P4. It looks like they are not strictly 20% from Fz or Pz but an

> > intersection between Fz and F5 or F6 and Pz and F7 or F8.

> >

> > Does anyone have any ideas?

> >

> >

> >

>

>

>

> --

> Van Deusen

> pvdtlc@...

> http://www.brain-trainer.com

> 305/433-3160

> The Learning Curve, Inc.

>

[Guest guest]

,

It is at http://health.groups.yahoo.com/group/braintrainer/files/Assessment%20Forms/ and the file name is TLC Sitefinder.xls.

Pete

I am using Yahoo for reading the newsgroup and am unable to download Pete's file. WOuld someone mind posting it to the files section or even emaling me the file to

ecnath@...? I would appreciate it.> >> > I am trying to put together an Excel spreadsheet that calculates the 10-

> > 20 locations once you have the measurements from inion to nasion, ear-> > to-ear, and head circumference. All the measurements are in> > millimeters.> >> > I am running into a problem. Math is not my strong area, and I am

> > having difficulty coming up with an Excel formula for F3, F4, P3, and> > P4. It looks like they are not strictly 20% from Fz or Pz but an> > intersection between Fz and F5 or F6 and Pz and F7 or F8.

> >> > Does anyone have any ideas?> >> > > >> > > > -- > Van Deusen> pvdtlc@...>

http://www.brain-trainer.com> 305/433-3160> The Learning Curve, Inc.> -- Van Deusen

pvdtlc@...http://www.brain-trainer.com305/433-3160The Learning Curve, Inc.