Web Scraper Concept for Gathering Data from a Stock Trading Website

Concept in Python for gathering targeted stock data from a given trade platform. April 2025.

Proportionate Allocation Process for Factory Consumer Goods via MS Excel

Example of my process for allocating planned factory production by region using MS Excel formulas. April 2021.

Basic optimization macro for demand versus capacity

Linear optimization iteration to seed one planned bulk order bucket column as part of a basic Excel factory ordering plan. 2019

Update exit-factory dates program example

Visual Basic program for updating exit-factory dates on a set of Excel-exported purchase orders from an enterprise resource planning system. 2015

Update # units on a purchase order program example

Visual Basic for Excel program to update the # of units on a particular purchase order that was downloaded into Excel, based on comparisons with another workbook (i.e. a factory status report). 2015

Combine multiple workbooks of invoice data example

Visual Basic for Excel program to place multiple workbooks worth of invoices into one file for mass data comparison with a particular enterprise resource system of data. 2015

Back to menu (top)

Aescreta - Programming Samples