A dieline is a graphic design as a placeholder for assisting in the proper layout of a document that will be diecut as part of the finishing process. A packaging engineer asked if a script can be written to load the dieline files, view the files, and archive pertinent information. The answer is YES! The script locates the dielines, copies the files to a local directory for analysis, and uses index analysis to document necessary information.
Alpha Live Data Capital Requirements OPC Server Utilized RsLinx OPC Server PC and DDE clients are supported for any number of devices. It also supports applications developed for the RSLinx Classic C API. But note that this is limited to 32bit client only. Additional information is found within Rockwell's documentation. Other OPC servers may be utilized, but have not been tested. Matrikon OPC Cyberlogic Graybox Computer System configure with Python 3 or later Database SQL Express Oracle Microsoft Access Implementation Identify the OPC server’s IP address, all OPC tags should be hosted on the OPC server.
I implemented pytesseract Optical Character Recognition (OCR) that decoded the Bingo board and prompt using Natural Langauge Processing (NLP). I chose Bingo Blitz because the board and gameplay are vexatiously noisy. I utilized Hue, Saturation, & Value (HSV) masking to segment the numbers. Following masking, the standard median blurs, thresholding, dilation, and morphology preprocessed the board for computer vision. The application is built for Window applications utilizing the win32api to move & click with the mouse.
A simplistic script that exports queries an SQL database, defines the data in a pandas DataFrame, exports the DataFrame to an Excel document, and attaches the Excel export to a gmail. The consultant was unable to retrieve the data from remote locations; therefore, the recurring email was advantageous.
Github Project Link
Shopping for an Apartment? This python script will retrieve the searches from aparments.com & return a data frame. Call the function with a single URL or a list of URLs, happy shopping!
Required Modules Scraping Functions BeautifulSoup, pandas, & requests.
Personal Execution Example Seaborn, apartment_scrap, matplotlib, & matplotlib.pyplot.
Github Project Link
The maintenace team requested an End of Shift application to document labor utilization. This Tkinter application is simplistic, which should support longevity and sustainability.
User Requirements: Longevity and sustainability Multiple accounts within the file simultaneously The project began as an Excel Macro file hosted on SharePoint; however, the online functionality prevented multiple accounts active simultaneously.
Thus, I pivoted to the Tkinter module in Python to construct a GUI accessible from multiple accounts.
The Kitchen is an isolated location on the second floor of the plant; the Kitchen, produces caramel for the Alpha line to deposit on a chocolate patty base. The quality technicians observe caramel moisture, the current Key Performance Indicator (KPI), to characterize the caramel. Following the Kitchen production, the caramel flows to the depositor on the plant’s base floor. The caramel is deposited at roughly 62°C, which is significantly greater than the temperature in the Kitchen.
Following the chocolate base, nut depositor, and caramel depositor, the turtle travels through a cooling tunnel and over a wire mesh. To remove overapplied pecans, a spooler transition between the cooling tunnel and wire mesh permits unplaced pecans to fall through the spooler and prevent wire mesh clogging. While producing Original turtles, operations acknowledge significant waste when using the Original spooler. The management staff investigated the statistical difference between utilizing the Original spooler and the Bite spooler during Original turtle production.
Identify scrap redound by utilizing depositing 6.25 grams of caramel relative to the standard 5.10 grams of caramel standard. Financially, caramel is less expensive than pecans; therefore, adjusting the turtle’s component composition is advantageous to reduce direct costs. The management team pursued the Design of Experimentation to identify if it was plausible to reduce pecan contribution and utilize additional caramel. The results yielded inconsistent and larger turtle sizes.
Github Project Link