- Demographic Automation for non HL7 systems
A demonstration of how to import demographic data from an authoritative EMR/EHR system into another clinical system which does not have a HL7 interface.
- Concurrent WiFi Users
This is a graph of wifi access points and the number of connected users. Each individual AP is labeled on the x-axis. The total number of concurrent users on the network is listed in parentheses. For each AP, users are broken down into individual wifi radio bands.
- Geographic Map of IP Traffic
This video shows the geographic destination of outbound Internet traffic from our office throughout the day. The number of concurrent connections is in parentheses. Although a world map is possible, the USA map is more interesting to watch. The Silicon Valley area has been enlarged.
The video itself was created with all open-source tools: Python, R, Mysql, FFMpeg, and ImageMagick.
- Excel Automation with AutoIt
This demonstrates AutoIt's ability to navigate through an Excel spreadsheet. Although this same task can be accomplished using VBA, I really wanted to show off these particular AutoIt features. Now imagine this task with 50 switches and then you can see the value in automating this task.
- Removing Credit Card or Social Security Numbers From Your Network
Quickly remove files containing either CC# or SSNs from your corporate network by using a combination of AutoIT and Excel VBA. This approach allows multiple users to distribute the workload of checking & verifying files with the ability to delete or exclude files. Excluded files are tagged with a reason why they are not going to be deleted. An audit log is created for all delete / exclude operations. Find_SSN program