search

Temtesb / StatisticsCalculationsForExcel

VBA functions for statistics calculations to be used in Excel and Access
Other
7 stars 1 forks source link

readme

StatisticsCalculationsForExcel

These calculations, functions and subroutines are primarily focused on statistics have been built (or rebuilt from other open source/public domain libraries/projects) in Visual Basic for Applications (VBA) for use primarily in the Microsoft Office Suite.

Installation

This project has not yet been tested on MAC or 64bit Office suite, feel free to provide feedback

Building from source code has some automation, but is still a couple of manual steps:

  1. Download this repository from GitHub and unzip it

  2. Create or move a excel or access file into either the root or a existing 'build' directory of the project

  3. Open that file

  4. Manually import the build_ImportExport.bas module and run the 'ToolImportModules' subroutine

    1. alt + f11 (Launch IDE)
    2. ctl + m (Import File)
    3. ctl + g (Goto Imediate Window)
    4. Type and execute 'ToolImportModules' from the imediate window

  5. Once the code is loaded you can save, close and move your file.

Usage

TODO: Write usage instructions

Contributing

  1. Fork it!
  2. Create your feature branch: git checkout -b my-new-feature
  3. Commit your changes: git commit -am 'Add some feature'
  4. Push to the branch: git push origin my-new-feature
  5. Submit a pull request :D

OR

  1. Provide your comments to an existing issue
  2. If a simmilar one does not exist submit a new issue

History

This project began as a way to build vba functions to statisticaly analyze data using the software that was avialable to us in our work.

The initial functions where built during a Managing Small Business Data Analytics class at Regent University. Those functions that are mentioned as being derived from the course text of 'Essentials of Business Analytics ISBN 978-1-305-62773-4' are all found in the /Excel/Src/basStatsistics.bas file or [General%20VB/src/VB_Statistics.bas](General VB/Src/VB_Statsistics.bas) file.

Credits

This project has been created by (and is managed by) William Young and Jeremy D. Gerdes

Any additional specific attributions to individuals or other copyleft sources are listed in NOTICE.md.

License

When this project is distributed in it's entirety the license is GNU GPL 3.0. Many functions and source files are from multiple projects and have multiple open source or have public source attributions (see NOTICE.md).

All contributions to this project will be published under GNU GPL 3.0. By submitting a pull request, you are certifying that all content added to this project is either in a (c) license that is compatible with the GNU GPL 3.0 license or that you publish those contributions under the GNU GPL 3.0 license.

The full text of each license is listed in LICENSE.md