FullTiltWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Scripting ======

===== About =====

Scripting allows you to automate frequent computer tasks like backing up folders and processing data.

==== VBA ====

VBA is great for automating tasks in Microsoft office. It integrates tightly with the applications allowing for detailed control. Most of my experience is manipulating data in Excel. VBA allows extending Excel to be very powerful by adding custom buttons and functions. Most frequent tasks in excel can be reduced to a single click.

==== Python ====

Python is great for manipulating data and creating reports. It has a lot of powerful libraries for processing data. This is a great step up from VBA if you need something more powerful. Most of my experience is with a library called [[https://matplotlib.org/stable/plot_types/index.html|Mathplotlib]] that allows for detailed and visually pleasing representation of data. 

==== AHK ====

AutoHotKey is meant for binding hotkeys to common tasks. It can be used to automate interaction with forms that need to be completed frequently or to open frequently used applications. It is also excellent at navigating deep application menus or typing frequent responses with the press of a button.

===== Relevant Projects =====

  * [[projects:potlatch_corp:production_report|Potlatch VBA Production Report]]

FullTiltWiki

User Tools

Site Tools

Page Tools