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

Thursday, December 6, 2012

Extract external data and Word count.


Executive Summary:

My projects contains two parts. The first one is used for extract data from external csv files. The second one is used for counting word appearance in a text file.  I built three userforms to accomplish these tasks.









Part 1:
This semester, I was working on a research project with statistics department about Election Exit& Poll.
During this project, I also needed to calculate sampling data obtained from different polling locations and exported to an excel format, which would be used by BYU boardcasting center to link with their Chyron graphics system. The challenge we faced was that STATA exported a updated data file in a few minutes, which made it impossible for Chyron to link any certain file to create graphics. So I created a excel template that can refresh data automatically with changing csv files. When the user typed the csv filename, the tabname "Electionsresults" will update simultaneously. This program helped BYU broadcasting center to effectively update their graphics shown on TV.

Part 2:
When we read different documents, we can figure out a lot from the content, such as the author's education level, the author's target audiences and writing behaviors.  I created this program to count the frequency of word shown in a text file. This program can also give us Top 10 most common words, and export to a database for further analysis.

File: http://files.gove.net/shares/files/12f/zhangm3/VBAFinalProject.zip
Write-up:http://files.gove.net/shares/files/12f/zhangm3/VBAwriteup.pdf


No comments:

Post a Comment

Blog Archive