Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 

Repository files navigation

VBA Math class

Introduction

VBA Math class is one of VBA class family developed or planed todo Planned are: - Astronomy class - Calendar class - WebScrapping class ...

High precision or VBA missing mathematical functions. For example Pi is not an integrated constant nor result of function. Yes you can use atn (arctangente VBA integrated function) to retrieve Pi value. But precision is not there with double data.

Functions are distributed in many categories:

  • Basic
  • Trigonometry ... More in future like UHP (Ultra High Precision) values with Variant/Decimal as integer part and Variant/Decimal as decimal part (Useful for high precision astronomy and molecular calculus)!!!

Basic

Functions in this section are:

  • HPi() wich return at this moment 3,1415926535897955304 in variant decimal subtype
  • IsOddEven wich return if number is odd or even not only for Integer/Long/LongLong VBA datatype but for all types up to maximum value accepted by Variant/Decimal subtype
  • HRnd return a really random number based on based QRNG modified algorithm with parameter really random from life environment. It can return just one decimal value under one, or return a long intger value between two values as parameters.
  • HBase return large numbers specified in base 2 to 36 into other base from 2 to 36. Input and output numbers are defined as Variant/Decimal subtype. All numeric values are accepted as well as integer and float.

Trigonometry

Functions in this section are: - 2D Angle unit conversion all in high precision (3D angle units managed in future version)

  • HDeg2Rad Degree to Radian
  • HDeg2Grad Degree to Gradian
  • HDeg2Arc
  • HRad2Deg
  • HRad2Grad
  • HRad2Arc
  • HGrad2Deg
  • HGrad2Rad
  • HGrad2Arc
  • HArc2Deg
  • HArc2Rad
  • HArc2Grad Usual trigonometry functions in remplacement of integrated to get more precision:
  • HSin
  • HCos
  • HTan
  • HCtg
  • HSec
  • HCosec Extended trigonometry functions are also presents such as: H

Distribution

Distribution is free for usage in compiled mode. Charge is applied for source code due to a long time effort and continuous improvement.

About

High precision or VBA missing mathematical function

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors