The organization that I work for has several large databases that recently underwent a change that needs to be closely monitored. These statistics are included in a daily html report. To monitor the effect that these changes had on the databases we need to open each html file and look at 2 specific statistics. To really identify any effect of the changes I would need to be able to graph the changes.
To solve this problem I designed this project that uses VBA to cycle through all files in a directory and search each file for the correct statistics, adding them to an excel spreadsheet and graphing the results. To accomplish this I had to use different references(one for the file system object and one for regular expressions)
Stat Parser(Report)
Stat Parser
Example Files
These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Wednesday, April 11, 2012
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2012
(131)
-
▼
April
(70)
- Android SMS App
- Helping 301 Students Organize Financial Statements
- Joe Hilton - solar field simulator and optimizer
- Jared Miller VBA Final Project Executive Summar...
- Bank Impairment Worksheet
- Pianist's repertoire database
- Your Personal San Francisco Craigslist Search
- House For Rent - KSL Classifieds Web Scraper
- Tax Lien Aggregator
- VBA Tax Preparation Program
- Recipe Organizer
- Financial State of the Union
- I am currently engaged and didn’t quite realize th...
- KSL Cars Classifieds Search and Regression: By Aar...
- Rental Property Analysis
- Student Database
- Couponer's Paradise
- KSL Search
- Schedules Creator
- Book Buyer
- Recipe Grabber
- Sherpa Program
- Executive Summary Pain Weight training pr...
- Stat Parser
- Affordable Home Calculator
- Underwater Audio
- Eating Habits Monitoring System
- Automatic Email Generator for HR Recruiters
- Automating Church Register
- Fantasy Football Analyzer
- Cell Phone Bill Calculator
- Textbook Purchasing Help
- Public Company Comparator
- Arizona Real Estate Wizard
- Housing/Apartment Search
- Cost of Living Analyzer
- Cupcake Chic
- Foreign Receivables Tool
- Budget & Spend Tracker
- Contact Reminder
- VBA Final Project _ Mitchell Wright and Robert Mat...
- NCAA Tourney Analysis
- Excel Custom Shortcuts
- Sixteenth Century Society & Conference
- Marissa Nielsen Final Project
- Dosboss's Streamliner
- Photography Client Tracker and Tools
- Profitability Calculator
- Stubby- A StubHub Bargain Hunter
- Creating Holiday Calendar Events
- Proforma Profit and Loss Statement Generator
- 5-Year Plan Upload
- Bank Branch Call-Log Dashboard
- Mutual Fund Evaluation Tool (Morningstar.com)
- Gavin Gee Genetic Algorithm
- David Katherman Dynamic Database
- Jason Johnson Facebook Scraper and Emailer...
- Blocked Billing Documents in SAP
- March Madness Bracket Picker - Weston Kunz
- Joseph Detro Final Project
- ROWLEY: Suunto Workout Log
- David Long & Adam Richards VBA Final Project - Ref...
- Stock Screener
- Excel Hotkey Upgrade
- Brandon Cook Final Project
- Spec Sheet Automator - VBA Final Project by Nick Lyon
- Plinio Santana's Final VBA project - SENNA'S NEWS
- xlBooster
- David Tate's Final VBA project - Update FX rates
- Library Circulation and In-House Report Builder
-
▼
April
(70)
No comments:
Post a Comment