TeeGen

Tallysheet generator program

Importing DBF files into system, then creates the city Tallysheet needed to collect data from users.

Current version:
1.36
Published:
Feb 2014
Internal ID:
PF375 (type1)
Systems
Big complete systems
VBA - Excel
Macros, or Visual Basic for Application tool
A customized tool to create tallysheets for a test based on user adjustments.
This was a great win, once we presented this tool, we were able to save around 80% of consumed time to create these tallyheets. The tool is completely customized in a way that user (Admin level of users) may change the column mapping allocation table to refer to another column in any of the input files.
Then the regular user will run the tool to create these tests tallysheets.
TeeGen is used to import several dbf files (or csv, xls, xlsxm if found and presented by user) from a defined tree folder structure into spreadsheet, it uses customized rules to do this import, these rules can be modified by "Admin" only, and changed to fit each city needs.

Creating TeeGen created the road into TeeMan, and then using those two tools, we were able to move all data management and storing into database, shown here is the early version of TeeGen.