Multiple Storage Tanks - Inventory Management System
The problem: Multiple storage tanks in continuous service for many years, now it's time to take some out for inspection. What's the minimum number of tanks I need to have taking into account feed rates and export rates (including export delays and defined settling times for each tank). The solution: A simple Excel VBA program to graphically show total storage capacity and instantaneous inventory. You'll see from the Excel VBA code excerpt that I fully comment my code, so that it's easy for you to follow what I'm doing
About Me
Core Competencies: • MT4 Expert Advisor Development / Modification • Database solutions [MS Access] • Advanced Excel Dashboards & Analytics • Advanced MS Word Customizations • VBA (All Office Applications) • Project Scheduling and Tracking [MS Project] • Visual Basic .NET [Desktop apps] • AutoCAD [Engineering Drawing, 2D to 3D] • Academic/Technical Writing Background: Following BSc and MSc degrees in Electrical Engineering and Petroleum Engineering respectively, I have spent the last 13 years working for a Fortune 100 company in the Oil & Gas sector. A significant portion of my time is spent mining data from multiple sources (spreadsheets, Word documents, hard copies, company databases) and translating that into analytics that facilitate decisions.
