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

Monday, April 14, 2014

Personal Library Value Calculator


Stephen Nemrow
VBA Final Project
I SYS 520
Winter 2014

My wife is employed by a wealthy individual with a large personal library. A large portion of the library consists of  interior design and landscaping books, many of which are still in plastic wrap and have never been read.  My wife's employer is considering donating these books to a local library and wants to know how much the books are worth so she can calculate the tax benefit of the donation.  She has asked my wife to get this information for her.  My wife has gathered over one thousand ISBN numbers and was dreading having to search each book and pull all of the information.

My program takes a list of ISBN numbers and searches amazon for each ISBN.  It then scrapes Amazon for the title, new and used prices, author, published year, and book rating (on a scale of 1 to 5).  It returns the result to excel and summarizes the value of the books, based on whether the book is new or used.

Project Write-Up: http://files.gove.net/shares/files/14w/snn6/Final_WriteUp_StephenNemrow.pdf

Project File: http://files.gove.net/shares/files/14w/snn6/Final_StephenNemrow.xlsm

1 comment:

Blog Archive