Here is a Excel Based Software for calculation of required kVar, For more stuffs like this you can mail me or reply on this post.Capacitor bank calculator.zip