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
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2014
(127)
-
▼
April
(70)
- Searching cars in Provo on Craigslist has never be...
- Automated Qualtrics to Eventbrite Registration for...
- Dallin Lemich's Executive Summary
- JST BI Blitz!
- Multi-Function Employee Management System
- Consultant Tools
- AMEX to Certiflex
- Automating an Accounting Process
- Point-of-Sale System
- Unemployment PowerPoint Slides Maker
- Box Office Crawler
- Senate Vulnerability
- Software License Mapping
- Econ 110 Independent Study Tool
- Excel Tutorial Framework
- Using VBA to Create a Randomized Seat Assign System
- Using VBA to Create an Adaptive Review for Chemist...
- Using VBA to Model the Forecast of a Bond’s Cash F...
- Internship / Job Hunt Networking Tracker
- <!--[if gte mso 9]> <![endif]--> <!--[if gt...
- 20-Year Financial Plan -- David Sheffield
- Simply Invoicing
- Unknown Label Generator - Zachary Buchanan Exec...
- Employee Essentials Training I work for the Human...
- Tanner's Tantalizing Travels
- The Socializer
- Article Citation Count Scraper
- Hockey Statistic Data Collection Program
- BYU Alumni Records-Stuart Cottle
- Payout by Rank Report
- Be A Philanthropist Decision Support Tool
- Contact Organizer
- Austin Smith - Diet Calculator
- Executive Summary The purpose of my project was t...
- Lead Information I created a VBA project for Ho...
- VBA Reporting
- Deal Finder
- Engagement Survey Analysis
- VBA Final Project: Automated Personal Budget
- Battleship Executive Summary
- In Search of a More Accurate Share Price
- AutoSplit: Split Expenses for You
- Trade Activity Log
- Automated Personal Finance Spreadsheet
- Executive Summary: A friend of mine, who owns a l...
- Graham's 10 Hurdles Stock Screener
- Ashley Rebilas - BYU Arts Supervisor Report
- Isaac Lomeli - Contagious - Company Contact Organizer
- Blushing Rose Floral CRM and Financial System
- Financial Report Downloader
- Student Administrative Data Collector and Email Di...
- Liberty Security Sales Summarizer
- Spend My Cents - Excel Edition - Mack Cope
- Pelatron Technologies Inventory Management
- SML Reservation Generator
- Cell Phone Rentals
- Farmland Tracker
- Stock Analyzer
- NBA Mock Lottery Draft
- Business Intelligence from Twitter
- Data Input and Sort
- PTO Employee Tools
- Personal Library Value Calculator
- Allpine Lumber Price Index and Invoice Creator
- Timecard Reporting System
- BYU BAP Reporting Tool Spencer Mecham Exec...
- Schedule Planner and text message
- Creating a Hydrologic Rainfall Depth-Duration Curv...
- Executive Summary Background In tod...
- Personal Budget Automation
-
▼
April
(70)
No comments:
Post a Comment