Excel Wizzards - Help Please

Reply Subscribe

Thread Tools

Search this Thread

Oct 5, 2005 | 11:49 AM

Blackbird

Thread Starter

TECH Addict

Joined: Nov 2001

Posts: 2,659

Likes: 1

From: Bellevue, Wa

Excel Wizzards - Help Please

if I know 2.3 Volts is 0psi and 5.0 Volts is 14.7 psi how do I calculate lets say 20 data points in between knowing that the relationship is linear?

Oct 5, 2005 | 12:01 PM

silverTA2002

12 Second Club

iTrader: (1)

Joined: May 2005

Posts: 684

Likes: 0

From: Bradenton, FL

Math....

If the difference between voltage is 2.7, and that equals the difference between psi of 14.7, then.....

.1 increase in voltage equals .535 increase in psi.

2.3 0
2.4 .535
2.5 1.07
2.6 1.605

etc.

I think that's right.

Oct 5, 2005 | 12:02 PM

silverTA2002

12 Second Club

iTrader: (1)

Joined: May 2005

Posts: 684

Likes: 0

From: Bradenton, FL

In excel. make this formula

a1 = 2.3

b1 = 0

a2= a1 + .1

b2 = b1 + .1 * 14.7/2.7

Then grab and drag a2 down, and b2 down and the formula will fill as high as you want to go.

Oct 5, 2005 | 12:10 PM

Blackbird

Thread Starter

TECH Addict

Joined: Nov 2001

Posts: 2,659

Likes: 1

From: Bellevue, Wa

oh crap Silver I think your right.

I totally over complicated it didn't I.

Thats what happens. Computers make you lazy. Jeeze I am

now.

Oct 6, 2005 | 12:21 PM

RedHardSupra

TECH Fanatic

iTrader: (1)

Joined: Sep 2003

Posts: 1,904

Likes: 2

From: Laurel, MD

http://allmod.net/hpt/LinearPoints.xls

this is a more flexible one, you can vary number of points, starting and ending ranges, etc.

btw, i see you're in SJ, you need a tune?