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

Texas A&M University – Kingsville Computer Science Website

TAMUK CS Website

Main Website Template:TAMUK CS Website

Teacher Website Template:
Teacher Site Template

Tahoe Trucking Website

This site was designed using a completely custom wordpress theme. The logo was completely redesigned and the header image was shot over the course of a few days and stitched together using Photoshop. Since this site was implemented with wordpress, the customer can edit the content like a Word document with no HTML knowledge required.

 

tahoe

 

Site link:    TahoeTrucking.com

DoveCom Website

This site was a blank slate as far as projects go. While working for Integrity Communications, I was asked to create a website for a sister company called DoveCom that, at the time, had no logo, content, or identity of any kind.

 

dovecom

 

With this in mind, I created a logo and layout that reflected the company’s name while at the same time using a few design trends of the time like reflections, gradients, and darker colors.

DiffTool

This tool allows you to compare any two text files and view the changes. It has two resizable panes and leverages the power of HTML and CSS for the display window styles. It also has a numbered code line, so you can compare code a little easier.

 

diff

 

Download File – DiffTool

Paypal Helper

This is a program I wrote to help high volume ebay sellers.

 

 

After struggling with 100+ orders per day on ebay, I realized I needed an automated system. Ebay and paypal are notoriously difficult to work with for large scale operations and the applications that interface with them tend to be short on features. With this in mind, I set out to create my own order processing system.

Before Paypal had an API, it was very difficult to get buyer information for creating internet based shipping labels. This program allowed you to log into your account and retrieve shipping information for your buyers. It also saved transaction snapshots, so you wouldn’t need an internet connection to view archived sales.

This application allowed you to keep in constant communication with your buyers to ensure they were happy by using a click and email system that notifies buyers of their shipment’s status. The notification idea is based on the system used by Dell for shipments where the customer is notified of shipment status through frequent, step-based email.

For example, a step 1 email would say order received, and would be marked as step 1 of 5. A step 2 email would say order confirmed and so on. For my order system, I used the following steps: order received, order processing, order processed, shipping label created, and order shipped. Using this method, customers were much more likely to leave positive feedback because I had kept in constant communication with them through a simple point and click interface.

Once Paypal created an API, I moved to Paypal Helper 2.0, which takes advantage of the new API to streamline large scale ebay order processing.

Dell Sweepstakes Hack (Dellf Project)

Dellf HDTV

Dell ran a Christmas themed contest a few years ago (2004-2005?) called the Dellf Sweepstakes. The idea behind it was pretty neat at the time: register your email address, fill out a CAPTCHA box, and you get three chances to win prizes.

The CAPTCHA design made it very easy to reverse engineer (an evenly spaced grid, solid background, unaltered text). By using the photoshop API and a custom written action I was able to take this:

index

and turn it into this:

index2

From there, I sent the edited image to the Office API and did a quick OCR command to get the text from the image. Then, using the WebBrowser control, I scripted the actions to put the text into the web page and register an email address.

Here’s a view of the program in action:

dellfprogram

It’s important to note that I didn’t collect any prizes. This project was more about the thrill of the chase and not so much the actual prizes. I ended up “winning” almost every prize including the grand prize, a 42in. plasma TV.

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.

CPU Scheduling Simulation

This application allows you to analyze different CPU scheduling algorithms. It currently uses 3 non preemptive algorithms (first in first out, shortest job next, non preemptive priority) and 3 preemptive algorithms (round robin, shortest time remaining, preemptive priority). I designed this application so that additional algorithms can be added in and analyzed alongside the built-in algorithms. Within the interface, you can generate random processes, create/edit your own processes, change the round robin time quantum, set all arrival times to 0, and save/load a set of processes.

Here is an early sketch I made for this application to help plan its implementation:

Early schematic for CPU scheduling program

Early schematic for CPU scheduling program

Here is a screenshot of the working application:

CPU Scheduling Interface

CPU Scheduling Interface

The graph control used in this project is an open source C# control called ZedGraph.

This program is open source and is currently hosted on sourceforge.net at https://sourceforge.net/projects/cpuschedulingsi/.

Download here: SchedulingSimulator.zip

Categories