Skip to content

Data analysis > VBA-driven automated regression (supervised ML) in Excel.

Notifications You must be signed in to change notification settings

jbolns/atheoretical

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Atheoretical

A set of VBA scripts to rapidly produce supervised ML analyses in Excel.

Helpful when you run need to run regressions/supervised ML in Excel on a periodical basis and you want to save yourself some time.

Very early stages. Expect bugs. Loads of them.

Notes

  • The mainFiles folder contains an Excel document with clear guidance, preloaded scripts, and pre-populated (dummy) hyper-parameters.

  • The mainFiles folder also contains a (zipped) dataset that can be used for testing (due credits given in Excel file).

  • The individual modules/scripts are given as .bas files, which can be imported easily into Excel's VBA console.

  • Eventually, the file should be able to handle any clean dataset made of quantitative continuous variables. It will take a while until things run smoothly, though.

Pending:

  • Documentation. The Excel file includes guidance, but more detailed documentation would not hurt.
  • Stress testing. The file currently works fully with the sample dataset, but bugs are incredibly likely.
  • Code cleaning. There are still macros that use repeated code sequences.

Usage/Licensing

I honestly have not thought about this just yet. I really do not think the files are yet at production or even pilot-testing level. So, for now, let's say it's all rights reserved.

About

Data analysis > VBA-driven automated regression (supervised ML) in Excel.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages