Wonderful.. Thankyou Blanche... I only have to tweak the name of the
variable A6 to plug this in..

This was exactly what I was lookin for.
Dave

Blanche wrote:
For the type of aircraft your club will be flying, the formula in
Kershner will be adequate.

The formula in Excel is

full_va*SQRT(A6/full_weight)

where

full_va printed weight in the POH (usually at gross weight)
full_weight gross weight for aircraft (again, most recent W&B)
A6 column with weight for calculation

I fly a cherokee, so I have weights from 1800 (lightest load with
fuel and me and gear) to 2400 (gross weight) in column A.

And while you're calculating Va, the Glide speed can be done at
the same time since it's also weight-based:

full_glide*SQRT(A6/full_weight)

have fun!