So I wrote a PHP program that would accept the CSV of that Excel file then output the AutoHotkey script to create that specific lookup. Part of my previous job used to be creating bespoke lookup tables in a system based on parameters from a spreadsheet. I've always used to automate little things at my various jobs. It allowed me to call the specific instance more consistently faster and without having to glance down every now and then. Plus I can use Ctrl or alt modifiers to create multiple layers for different kinds of logging. So, for instance, something was happening to my left that I needed to log, I am logging these instances with 1 on the numpad, to my right 3, above that to the right maybe 6? and then there are all the other keys. I found that if I used my numberpad it is easier to correlate geographically so that what I was seeing matched what my hands would do. Some programs I use require me to log data, specifically at times with time stamps. Lots of basic remapping with the numberpad. I hate data entry and if I only have to do it once I will do everything in my power to keep it that way. Inventory, purchasing and sales always took forever to pull info from each individually, simply made it accessible from one location.Ī script that extracts data from. Most useful for me is one of the following,Ĭreating a self updating database to consolidate multiple departments of a job I once had.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |