Category :: SQL

Developing a Cost Effective Wireless Data Entry System (Master’s Project)

This paper looks at the design and implementation of a wireless data entry system using cheap and widely available personal digital assistants (PDAs) as a hardware platform. This problem is viewed through the context of a small transportation company that is transitioning to a medium-large scale operation and needs a custom tailored solution to improve payroll efficiency and reduce errors. In my report, I detail the design considerations, the user stories, and the pitfalls that come with implementing a new system that interfaces with existing applications.

 

 

 

My complete Master’s report and presentation used in my defense can be downloaded below.


Download report:
Developing a Cost Effective Wireless Data Entry System

Download presentation: Developing a Cost Effective Wireless Data Entry System

Paypal Helper 2.0

This project is the second revision of the original Paypal Helper.

 

Paypal Helper 2.0 UI

Paypal Helper 2.0 UI

 

Unlike the original, this version makes use of the new, official Paypal API and some SQL to do the heavy lifting. Instead of using a ListView, Paypal Helper 2.0 uses a DataGridView with a Datatable to easily implement different kinds of filtering on the data, so users can narrow down transactions based on multiple sets of criteria. This project is in an alpha state and will probably remain that way unless my ebay store receives the kind of volume it used to.

Graph Theory

TahoeTools – Motion Detection

TahoeTools – Payroll

TahoeTools – Quote

This project is an adaptation of an excel spreadsheet that was used for cost estimation. I added in a MapPoint control, so we wouldn’t need online access to work with maps. I also incorporated live Quickbooks data into this application, so that we could create formal quotes with prefilled fields on company letterhead with very little effort.

Here’s a demo of this application:

[youtube=http://www.youtube.com/watch?v=o8lONjMtU88&hl=en&fs=1&fmt=18]

Due to the sensitive nature of this program I can’t release the source code, but if you have any questions please email me.

Categories