Successes - Summary

System Type	# of Systems
Reporting	71
Semiconductor/Pharmaceutical Image Databases	43
Modification of Existing Applications	25
Internet Applications, Websites	17
Project Manager	14
Data Conversion	14
Finance and Accounting	11
Security	8
Real Estate	6
Construction Management	5
Communications	4

Successes - Image Databases

• > 22 semiconductor manufacturing applications in Visual Basic, SQL Server, MS Access, and may other tools for Fortune 100 companies to automate the process of semiconductor manufacturing defect analysis. MS Word data reports, clipboard processing, audit trail, automatic image sensing and importing, COM, data ditto, text data file parsing, and status tracking are some features included in the semiconductor applications.
• > 19 pharmaceutical / pathology applications in Visual Basic, SQL Server, and MS Access for chemical manufacturers and Fortune 100 companies providing image capture and database capabilities including security, COM, audit trail, and data searches. These systems, the development process used to create them, the documentation provided to the customer, and the quality of the system code had to pass FDA approval.
• Conversion of many existing applications into highly functional, normalized, professional, database applications.

Successes - Internet Web Design  

        State-of-the-Art ECommerce and Product Delivery System
      

This completely custom ECommerce system with integrated shopping cart is the basis for a company based on the Application Service Provider (ASP) business model. It is the ultimate in web design. We can do the same for you. Based on Macromedia ColdFusion technology, the system uses a SQL Server database and powerful client-side JavaScript. It allows many partners and vendors to sell products and services online - and take advantage of the synergy between the products being offered. Click the link below to see a detailed PDF document with screenshots of all of the major features of this powerful online marketplace. Here are some of its features:

• Completely database and Cascading Style Sheets (CSS) driven design to allow total control of the visual look and feel of the entire system
• Complete custom shopping cart using direct UPS price quotes and online credit card validation and debits
• Javascript to perform client-side processing that increases the information presented to the user so informative decisions can be made quickly without internet delays
• Many powerful navigation options make it easy for the customer to find the products they need:
• Search engine providing maximally relevant product hits on user queries
• Javascript drop-down menus
• Highly functional history list of 20 pages to quickly get to a previously visited page
• Complementary Product Links are listed whenever a known synergy is identified between products
• Header and footer links to the most important and popular pages (Contact Us, About Us, Request a Custom Quote, etc.)
• Versatile (and standard for the internet) product viewing when more products that can be shown on the screen are to be viewed:
  'Displaying 1 to 8 of 16 Products    Page 1 2 Show All'
• Highly functional product portfolio pages for viewing thumbnail and full sized images of many existing products. Full-size images can be browsed in the detailed portfolio page.
• All customers can request custom price quotes for any product or service not specifically listed on the website. This is a veritable safety net to catch all possible products and services.
• Powerful client-side Quick Quote pages allow immediate feedback on buying options
• Graphical and descriptive email notifications sent to the customer and all vendors and website owners
• Online management of customer and vendor order status information
• Tightly integrated file upload and file management capability
• State-of-the-art Graphics Engine that allows customers to create their own images of the products they will be purchasing
• All product lines can be seen in up to 4 levels of detail on one page. This saves the customer time in reviewing products before a purchase.

• 4 levels of Windows NT security tightly integrated into the systems functions,
• Active Server Pages (ASP)
• JavaScript (for client side data validation and processing compatible with both Internet Explorer and NetScape browsers)
• ActiveX Data Objects (ADO) for MS Access database display and updates
• HTML
• 3rd party hierarchical tree java applet for site navigation
• 3rd party server side component for uploading files from the client computer to the server computer
• 3rd party server side component for automatically emailing project managers based on selected system events
• 3rd party client side component for viewing AutoCAD .dwf files located on the server
• 3rd party client side component for viewing .pdf files located on the server
• View some screenshots of this application.

Successes - Professional Websites  

• 21stsoft.com (this site), of course. It is ranked very high in the top search engines for our selected keywords, has all custom graphics, lists many of our successes, uses custom PayPal shopping cart to sell our products, has a search page...
• Colorado Treasury Management Association - for the professional association, simple but clean and aesthetic.
• Murder by the Book - a mystery bookstore site with the following features:
  • Inventory lookup and secure shopping cart custom created using Microsoft Active Server Pages (ASP). This completely custom coded shopping cart incorporated ASP, Microsoft Access database application and allows the user to easily search the inventory, select, and securely order books from Murder by the Book. It employs the SSL protocol for secure ordering from your browser to the web server, then a Verisign certificate that secures the credit card email from the web server to Murder by the Book. Here are a couple unsolicited customer comments:
    • "Your website is great--I really like the ease of ordering after the author search. One of the best I have seen."
    • "Thanks for shipping the books. I enjoyed the web page, it was real easy to navigate and use. I've got it bookmarked to visit again."
  • Book Club registration - both secure and non-secure. The non-secure method requires the customer to phone in their credit card information.
  • Users can list their favorite mystery books, see those of others, and click on the author's name to perform an inventory search for that author
  • Simple newsletter subscriptions - just enter your email address on any page.
  • Tell-a-friend capability on all pages. This feature is also integrated into the inventory searches. When a user does a book search that they think a friend will be interested in, they can simply click a link and send the same book query to the friend. Click here to perform a mystery book search on 'Agatha' and note the yellow New image near the top.
  • Autoresponder email. This email is sent to all site participants that provide their email to show them all capabilities of Murder by the Book online. Click here to see a picture of this aesthetic, html autoresponder email.
  • All forms are validated using Javascript for required fields, correct email formats, etc. before submission to reduce user frustration.
• Author Steve Jackson - for New York Times best-seller Steve Jackson.

Successes - Real Estate

• See our Internet Applications page for Internet based real estate applications we've successfully completed.
• 1 large Business Process Automation system (overall cost approx. $400K) incorporating the following technologies: Windows NT 4.0, Delphi 2.0 custom applications, ESRI ArcView Geographical Information System (GIS), Off the Shelf geographical databases, etc.  21st designed the complete database and overall system to automate the process of mortgage flood certifications and place the customer in a top market position with respect to all of their nationwide competition.  21st assisted the customer in hiring several vendors to do the specialized programming, then became the technical manager.  Several system components were custom coded by 21st to provide data processing, analysis, and correction.  Turnaround time for customer flood certifications went from 4 - 24 hours to 25 seconds.  The company has since been bought by a major player in the industry, due in part to the new computer system that dramatically improved the company's product and service throughput.
• 1 software package automating the process of performing commercial real estate appraisals.  This client reported that the software designed by 21st Century Technologies, Inc. doubled their productivity and gross profits.
• 1 Property Management report engine for a nationwide real estate property investment and management company. This complex reporting tool fulfilled sophisticated user requirements for information retrieval and provided information rollup to the following levels of property detail: Lease -> Unit -> Building -> City -> State -> Region.
• 1 commercial insurance marketing application for use by insurance agents to increase sales based on real estate information from local County databases.

Successes - Finance/Accounting

• 2 VB6 database applications - Accounts Payable and Bank Deposits - that interfaced to Great Plains Accounting and had several intricate reports.
• 1 database application that automates the creation of Excel spreadsheet financial analysis. The database contained the base information needed for the application. The application sent data to Excel where sophisticated formulas and analysis are created at runtime. This substantially reduced the effort to perform high ended analysis, and allowed the customer to run many investment scenarios in front of clients. Before the application was created, this wasn't possible.
• 1 application automating the financial reporting requirements of one of the largest real estate developers in the Denver metro area. This software included an income projection report that required a rollup of historical monthly/quarterly/yearly information for projection into a 5 year sales projection report.
• 3 OLE Automation applications linking databases to spreadsheets for the purpose of facilitating the analysis of financial and pathology research information contained in the database.
• 1 custom accounting application.

Successes - Reports

• Countless (>200) reports for all applications created by 21st
• 1 commercial reporting utility created in Microsoft Access. This utility is a custom Wizard Add-In for the use of selecting and filtering data, printing reports, and exporting the selected data. This package was marketed by one of our existing clients.
• 1 report engine for a commercial software package being marketed by a client that allows a user to select a report, its parameters, when it should run, and where it should be output. These reports can be set to run daily, weekly, bi-monthly, etc. The outputs provided are spreadsheet, MS word, all available printers, fax, and E-Mail.
• 1 application used by a brick manufacturing company to track production, schedules, and inventories on hand. Factory employees were paid from the information in the reports provided in this system.

Successes - Communications

Successes - Medical Software, Inventory, Demo, etc.

• 1 VB6 voice controlled commercial medical software product that went through many RAD prototypes until the customer accepted the User Interface. The system was then completed through version 2.0. It incorporated VB6, Data Dynamics ActiveReports, Infragistics Developer Suite (9 of their ActiveX component products), Dragon Naturally Speaking for voice control, MS Access 2000 database using ADO. Professional installations were created using Wise InstallBuilder. Reports were subsequently converted to Seagate Crystal Reports 8.0, and the database and VB6 code were converted to use either SQL Server 7.0 or MS Access 2000. Due to the success of version 2, the company changed from a service oriented company to a product driven company. 21st designed and created all software through version 2.0.
• 1 chemical inventory system in MS Access automating the effort to comply with the local Uniform Fire Code (UFC) for a proposed silicon device manufacturing plant. This application linked the UFC tables to the proposed installation data and allowed comparison of unlimited scenarios to Fire Code tables across several years. City approval for the project was gained soon after presentation of the data created in the system.
• 1 Windows demonstration application created in Delphi linking a database with an off the shelf Geographical Information system (GIS). The client took this demo application (with timers, screen savers, reports, etc.) to an industry conference where it proved very effective in attracting customers. This demo initiated approval for the main project.
• 1 Windows demonstration application created in Delphi and successfully used by a client to obtain funding and gain market recognition.