|
AutoSoft Systems | ||||||||||||||||||||||||||||||
| AutoSoft Systems | 2 Round Hill Court | ||||||||||||||||||||||||||||||
| East Greenwich, RI 02818 | |||||||||||||||||||||||||||||||
| 401.885.3631 | |||||||||||||||||||||||||||||||
| 401.884.5653 Fax | |||||||||||||||||||||||||||||||
| 401.996.3631 Cell | |||||||||||||||||||||||||||||||
| AMDG | Decision Ready Information! | autosoft@aol.com | |||||||||||||||||||||||||||||
| Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems. Founded in 1982. | |||||||||||||||||||||||||||||||
| We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice. | |||||||||||||||||||||||||||||||
| Home | About Us | Literature | Wire & Cable | Pharmaceutical & Biotech | Construction Management | Commercial Products | Custom Solutions | ||||||||||||||||||||||||
| Contact Us | Events | Downloads | |||||||||||||||||||||||||||||
| AMDG | |||||||||||||||||||||||||||||||
![MCj04398280000[1]](autotools_files/index_0000_image004.png)
|
|||||||||||||||||||||||||||||||
| Dr. Serdakowski uses the following tools in his development work: | |||||||||||||||||||||||||||||||
| Microsoft
Excel Versions 2016, 2013, 2010, 2007 |
Microsoft Excel with the Visual Basic for Applications Macro language. Although Excel 2013 has been available for more than a year, many users I support are still on Excel 2010 and 2007, with some still on Excel 2003. The Excel/VBA application in combination with ODBC (Open Data Dave Connectivity) is a powerful tool for building reports and analytical tools for AXIOM and many other purposes. The Help files in 2003 are superior to newer versions. Each subsequent version performs a bit slower than the last :(. 2007 also eliminated FoxPro support as part of Microsoft's effort to kill FoxPro (see below). This web site is built in Excel 2010 (just to show what can be done with it). All four versions of Excel can peacefully co-exist on a single computer. | ||||||||||||||||||||||||||||||
| Microsoft SQLServer | SQLServer has proven to be an excellent database that can handle as much data as I can put into it. Tens of millions of records and many many gigabytes. The SQLServer Express is quite powerful and FREE and a good starting point. | ||||||||||||||||||||||||||||||
| Microsoft Azure | For years I looked down on Access as a poor substitute for Visual FoxPro. Starting with version 2007, it behaves much nicer now and can handle up to 2 GB databases quite easily. I am using Access only for the database, I use Excel and VBA for all programming aspects of database development. | ||||||||||||||||||||||||||||||
| Microsoft Access | Microsoft's Azure is basically SQLServer hosted by Microsoft in the cloud. It performs surprisingly well and is quite similar to SQLServer in all aspects. | ||||||||||||||||||||||||||||||
| Microsoft Outlook | This is used in conjunction with Excel/VBA and/or FoxPro via OLE to automatically send emails and text messages as desired. Both periodic and exception reporting can be transmitted this way. | ||||||||||||||||||||||||||||||
| UltraVNC (www.uvnc.com) |
This is a totally free Open Source application for the Microsoft Windows operating system that uses the VNC (Virtual Network Computing) protocol to control another computer's screen remotely. | ||||||||||||||||||||||||||||||
| WS_FTP Pro | An excellent tool for maintaining web sites. The only problem I have is the program remembers your password but only displays it as a series of ooooooo. Make sure you record the password some place else. | ||||||||||||||||||||||||||||||
| Yahoo | Despite Google's market share, I find that Yahoo's search engine does a better job in getting me the information I seek. | ||||||||||||||||||||||||||||||
| America On Line (AOL) | I subscribe to AOL for $4 a month and receive (what appears to be) unlimited installations of McAfee Security Software. I use this for all 6 computers at my home and the 4 at my church. | ||||||||||||||||||||||||||||||
| STOPZilla | STOPZilla offers Spyware, Pop-up and SiteGuard protection. I purchased it for $29.95 years ago and they continue to upgrade it for free. (www.stopzilla.com) | ||||||||||||||||||||||||||||||
| MaxPC | MaxPC - a tool that "scrubs" the registry and improves computer performance. $39.95, works great. (www.is3.com/products/maxpc/home.do) | ||||||||||||||||||||||||||||||
| Advantech Network-based Data Acquisition and Control Hardware | Advantech offers the ADAM 4000 series of low cost data acquistion and control modules that "plug into" a standard Ethernet-based LAN and allow any computer on the network direct access to devices. I use this to measure the level of materials in tanks and silos and using Midwest's fine product, execute automatic inventory adjustments based on the sensor readings. | ||||||||||||||||||||||||||||||
| Monitor Flexar Guided Wave Radar Continuous Level Measurement System | Used to measure the level in tanks and silos. Works well on pelletized compounds with a non-horizontal air interface (level is not flat). | ||||||||||||||||||||||||||||||
| Midwest EZRF | What can I say, simply the best!! EZRF is a bar code scanning system for AXIOM. | ||||||||||||||||||||||||||||||
| Microsoft Visual FoxPro 9.0 | Microsoft has announced that FoxPro is not going to have any more upgrades, with support ending in 2014. | ||||||||||||||||||||||||||||||
|
A major benefit of FoxPro (and the reason why Microsoft wants to kill it) is that once a developer purchases a FoxPro license, he/she can freely distribute an unlimited number of applications built with FoxPro. FoxPro can handle tables with up to 255 fields and 2 GBs in size. With proper indexing, FoxPro has lightning fast SQL execution. Microsoft purchased FoxPro in 1992 to acquire FoxPro's "Rushmore" technology for fast data retrieval. This technology was ported into SQLServer. | ||||||||||||||||||||||||||||||
| Applications I have written in Visual FoxPro continue to run well. If it is not broken, don't fix it. I am not doing any new development in Visual FoxPro, but I continue to support and tweak my legacy applications. | |||||||||||||||||||||||||||||||
| FoxPro can also build stand-alone multi-user applications for custom reporting, analysis and control requirements. A FoxPro application can run on any Windows machine (95-Vista) without the need of an installation. Simply placing 4 FoxPro DLLs in the same folder as the application will allow the application to execute. In the case of multi-user applications, one instance installed on a network drive can be simultaneously executed on an unlimited number of user machines with different operating systems. FoxPro is fully OLE (Object Linking and Embedding) compliant, allowing FoxPro to control or be controlled by other Microsoft applications (Excel, Word, PowerPoint, Outlook...). | |||||||||||||||||||||||||||||||
| A fellow named Tyler Haynes | tyler@courseportal.org | asked me to put a link to his web site: | |||||||||||||||||||||||||||||
| https://www.coursesonline.co.uk/take-note-5-best-note-taking-methods/ | |||||||||||||||||||||||||||||||
| Here is what he claims: | "We put together a killer resource on the best note taking methods to structure and remember important information. There is a ton of information out there on this; our guide was designed to cut through the noise a bit." | ||||||||||||||||||||||||||||||
| I applaud his moxie and honored his request. I know what conventional marketing costs these days. For example, the smallest ad in the e-newsletter of Providence (RI) Business News costs $6,800! The e-newsletter goes out to only 3,600 subscribers (with only 35% of those actually opening the e-newsletter). So please check out his web page. | |||||||||||||||||||||||||||||||
| AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 | |||||||||||||||||||||||||||||||
| This web page was last updated at 11/06/2018 09:07 AM and is written in EXCEL! | |||||||||||||||||||||||||||||||
| AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach | |||||||||||||||||||||||||||||||