|
| | Software Publications:- Delonas, Nicholas. "Financial Toolkit Solutions." Intex Solutions, Inc., (1993).
- Delonas, Nicholas. "Ratio Master" Intex Solutions, Inc., (1991). (Download for free)
Book Publications: Gasteiger, Delonas, Bowers, Fingerman, Plumley, Shafran, and Weberg. Using Lotus SmartSuite 3. Indianapolis: QUE, 1994. Wrote four chapters on integrating SmartSuite applications, such as Lotus 1-2-3, with Lotus Notes. - Gasteiger, Daniel and Nicholas Delonas. The Lotus Guide to 1-2-3 Release 2.4. New York: Brady Computer Books, 1992. Publisher translated this book into German.
- Contributor to: Fielding, Justin. The Lotus Guide to 1-2-3 for Windows. New York: Brady Computer Books, 1991. Wrote three chapters on databases and data analysis.
- Gasteiger, Daniel and Nicholas Delonas. The Lotus Guide to 1-2-3 Release 2.3. New York: Brady Computer Books, 1991.
Technical White Papers "Introduction to Dynamic Data Exchange," Lotus Development Corporation, 1992. - "Advanced Dynamic Data Exchange," Lotus Development Corporation, 1992.
- "Printing in 1-2-3 for Windows," Lotus Development Corporation, 1992.
- "3-D Spreadsheets," Lotus Development Corporation, 1992.
- "High-Performance Printing in Wysiwyg," Lotus Development Corporation, 1992.
- "Creating Applications with Quattro Pro for Windows," Borland International, Inc., 1992.
- "Using Spreadsheet Notebooks in Quattro Pro for Windows," Borland International, Inc., 1992.
- "Database Access in Quattro Pro for Windows," Borland International, Inc., 1992.
Magazine and Newsletter Publications: "If You Must Use File Import . . . ," The Notes Report, (Sept. 94), pp. 1 - 3. Deck: "Sometimes the only way to get information out of an esoteric mainframe application is with a text file. Yes, you can use File Import to bring tabular or structured ASCII files into a Notes view." - "Risky Business," The Notes Report, (Aug. 94), pp. 1 - 3. Deck: "Notes can make you vulnerable to high-tech mischief. Here's how you can minimize the danger."
- "Help," The Notes Report, (Jul. 94) pp. 1 - 4. Deck: "Take the time to design a custom help facility, and users will flock to your applications."
- "Calling a DLL from 1-2-3/W," The Spreadsheet Consultant, (Jan. 94), pp. 18 - 19. Deck: "Last issue we created a standard Windows DLL. This quarter we create a custom AT function that uses it."
- "Change Print Settings on the Fly," The Spreadsheet Consultant, (Jan. 94), pp. 20. Deck: "And do it without a named-settings file."
- "Object-Oriented Macro Development," The Spreadsheet Consultant, (Jan. 94), pp. 15 - 17. Deck: "Try some unconventional techniques on large-scale applications in 3D worksheets."
"Excel 5.0 Gets Smart," Byte, (Nov. 93), pp. 23 - 24. Deck: "Packing lots of new bells and whistles, Excel 5.0 for Windows certainly looks good. But new integration capabilities with other Microsoft Windows applications may prove a stronger incentive to upgrade." - "Write Structured Macros," The Spreadsheet Consultant, (Oct. 93), pp. 8 - 10. Deck: "How to build spreadsheet applications the right way."
- "Add-ins for the Super Spreadsheets," The Spreadsheet Consultant, (Jul. 93), pp. 6 - 9. Deck: "If you can't find the add-in you need, build it."
- "Flash a Message," The Spreadsheet Consultant, (Jul. 93), pp. 11. Deck: "The say routine displays a message for a specific amount of time."
- "Hey Macro! Pick up the Phone!," The Spreadsheet Consultant, (Jul. 93), pp. 4 - 6. Deck: "Add phone dialing to your models with our modem-tapping dial routine."
- "How to write a Windows DLL," The Spreadsheet Consultant, (Jul. 93), pp. 12 - 14. Deck: "To create an add-in for your Windows spreadsheet, you need to code a Dynamic Link Library."
- "Tools to Browse the Red-Black Tree Database," The Spreadsheet Consultant, (Jun. 93), pp. 10 - 12. Deck: "Routines can sort your records every which way."
- "Unbreakable Security," The Spreadsheet Consultant, (Jun. 93), pp. 7 - 10. Deck: "Anyone can buy software to remove password protection from most worksheets. So what if you really want to keep a secret?"
"Big Data Structures III," The Spreadsheet Consultant, (May 93), pp. 11 - 12. Deck: "Deleting nodes from the Red-Black Tree." - "Displaying Messages," The Spreadsheet Consultant, (May 93), pp. 9 - 11. Deck: "Simplify your code and bring consistency to the way you display information."
- "Encapsulated Discourse," The Spreadsheet Consultant, (May 93), pp. 7 - 9. Deck: "Building Custom Dialogs in QPW."
- "Big Data Structures II," The Spreadsheet Consultant, (Apr. 93), pp. 15 - 17. Deck: "Routines that make last month's Red-Black Tree useful."
- "Center Text Across Columns," The Spreadsheet Consultant, (Apr. 93), pp. 5 - 7. Deck: "A macro can center text across columns perfectly -- with or without Wysiwyg."
- "Hello? Is Wysiwyg there?," The Spreadsheet Consultant, (Apr. 93), pp. 13 - 14. Deck: "This subroutine decides if Wysiwyg is present in any current release of 1-2-3."
- "Set Your Image," The Spreadsheet Consultant, (Apr. 93), pp. 3 - 5. Deck: "SETTITLE, SETBORDER, and SETBOTLINE make your apps look professional."
"1-2-3 with Wysiwyg," PC WORLD Lotus Edition, (Feb. 93), pp. . Deck: "Enhance Data-Entry Forms." - "One World, One Macro Language," The Spreadsheet Consultant, (Feb./Mar. 93), pp. 2 - 5. Deck: "Hey folks, let's get the same commands in every spreadsheet."
- "Roll-Your-Own Data Structures -- Big Ones!," The Spreadsheet Consultant, (Feb./Mar. 93), pp. 13 - 16. Deck: "A Red-Black Tree Can Manage 1,000, 100,000, 1,000,000 records, or more!"
- "You Too Can Use Very Large, Off-the-Sheet Data Structures," The Spreadsheet Consultant, (Feb./Mar. 93), pp. 11 - 13. Deck: "A binary-search routine can quickly retrieve records from a huge text file."
- "Optimize Your Code," The Spreadsheet Consultant, (Jan. 93), pp. 10 - 14. Deck: "Use the Zen Timer add-in to check the speed of your macros."
- "Tap 1-2-3 Forms," PC WORLD Lotus Edition, (Jan. 93), pp. . Deck: "Power for Easy Data Entry."
- "Zen Speed," The Spreadsheet Consultant, (Jan. 93), pp. 6 - 8. Deck: "Create a precision macro timer for 1-2-3 Release 2.x."
- "And you think you're tired!," The Spreadsheet Consultant, (Dec. 92), pp. 9. Deck: "The Delonas family doubles its size in a single day."
- "Debugging 1-2-3 2.x Add-ins," The Spreadsheet Consultant, (Dec. 92), pp. 10 - 11. Deck: "How to use Borland's Turbo Assembler and Debugger to compile and debug your assembly-language add-ins."
- "Get a Value, String, or Range," The Spreadsheet Consultant, (Dec. 92), pp. 12 - 13. Deck: "Our getrange routine accepts entries much the way 1-2-3 does."
- "Mortgage Calculations," The 1-2-3 for Windows Report, (Dec./Jan. 93), pp. 14. Deck: "Use this worksheet to plan your house payments."
- "Custom AT Functions for 1-2-3 Release 3.1+ in C.," The Spreadsheet Consultant, (Nov. 92), pp. 11 - 12. Deck: "You can do it, but you still have to deal with LPL."
"Subroutine Returns," The Spreadsheet Consultant, (Nov. 92), pp. 10. Deck: "Use the ret routine to return values or labels to a calling routine." - "1-2-3/W Supports AT ISAPP and AT ISAFF. NOT!," The Spreadsheet Consultant, (Oct. 92), pp. 14
- "Add AT Functions to BalerXE," The Spreadsheet Consultant, (Oct. 92), pp. 5 - 7. Deck: "Use QuickC to add a custom AT function to your baled applications."
- "Pack a Database Range," The Spreadsheet Consultant, (Oct. 92), pp. 9 - 11. Deck: "Create a macro routine that removes all blank records from a database range in the worksheet."
- "Custom Menus for Windows," The 1-2-3 for Windows Report, (Sept. 92), pp. 4 - 5. Deck: "SmartPak lets you create your own Windows-style menus."
- "Export CSV Files," The Spreadsheet Consultant, (Sept. 92), pp. 10 - 12. Deck: "Write a macro routine that can export a range to an Excel-style CSV file."
- "Function-Key Magic," The Spreadsheet Consultant, (Sept. 92), pp. 8 - 9. Deck: "Don't attach your most useful routines to a custom menu when you can assign them to function keys."
- "Homespun AT Functions for 1-2-3/W," The Spreadsheet Consultant, (Sept. 92), pp. 13 - 15. Deck: "You too can create AT functions with the 1-2-3 for Windows Add-In Development Kit and Borland C++."
- "Spreadsheets Under Scrutiny," Byte's Essential Guide to Windows, (Fall 92), pp. 70-72, 74-76, 78, 80. Deck: "Lotus 1-2-3 for Windows 1.1, Excel 4.0, or Quattro Pro for Windows 1.0--Which One's Best for You?"
- "1-2-3 and CSV," The Spreadsheet Consultant, (Aug. 92), pp. 4 -7. Deck: "Use this macro to import comma-separated-values files into 1-2-3."
- "Addvantage: Pascal," Lotus Magazine, (Aug. 92), pp. 55 - 56. Deck: "TechnoJock Software's Turbo Pascal-based system provides an elegant alternative for writing 1-2-3/W add-ins."
- "Can you C the future?," The Spreadsheet Consultant, (Aug. 92), pp. 10 -11. Deck: "Quattro Pro 4.0 lets you develop AT function add-ins in standard C or C++."
- "You can add. But should you?," The Spreadsheet Consultant, (Aug. 92), pp. 3 - 4. Deck: "New toolkits make it easier than ever to create spreadsheet add-ins. But the days of the big money after-market are probably over. Then again . . ."
- "zApp Application Framework," PC Techniques, (Aug./Sep. 92), pp. 78. Deck: "Critique"
- "1-2-3/W: Add-ins On the Way," Lotus Magazine, (Jul. 92), pp. 27 - 29. Deck: "New Toolkit opens 1-2-3 for Windows to sophisticated add-in development."
- "Drilled to Perfection," The Spreadsheet Consultant, (Jul. 92), pp. 12 - 14. Deck: "Use drill-down commands to spice up your data-entry routines in Baler and Ice."
"Control Flicker," The Spreadsheet Consultant, (Jun. 92), pp. 1. Deck: "Our {WINDOWSOFF}{PANELOFF} and {WINDOWSON}{PANELON} routines are infinitely nestable." - "Modeling with Two-Way Data Tables," The 1-2-3 for Windows Report, (Jun. 92), pp. 6 - 8. Deck: "Test the sensitivity of a formula to variations in two of its arguments."
- "Strive to be User Friendly," The Spreadsheet Consultant, (Jun. 92), pp. 4 - 5. Deck: "After all, a happy client is a future client!"
- " AT InfoMania," The 1-2-3 for Windows Report, (Jun. 92), pp. 3 - 5. Deck: "Add flash to your worksheets with 1-2-3/W's AT INFO function."
- "{FORM}," The Spreadsheet Consultant, (Jun. 92), pp. 10 - 13. Deck: "You can't always get what you want, but if you try, sometimes you get what you need."
- "A Depreciable Problem," The 1-2-3 for Windows Report, (May 92), pp. 10 - 12. Deck: "1-2-3's financial functions make it easy to figure depreciation expense."
- "BalerXE 2.0 and Baler 6.0," The Spreadsheet Consultant, (May 92), pp. 9 - 11. Deck: "The long-awaited upgrades to Baler's compilers are about to hit the shelves. They're compatible with both Release 2.3 and Ice!"
- "Investment Analysis with What-If," The 1-2-3 for Windows Report, (May 92), pp. 12 - 14. Deck: "Test the sensitivity of a formula to small changes in one of its arguments."
- "Major-league Macros," The Spreadsheet Consultant, (May 92), pp. 3. Deck: "Lessons learned by low-level-language programmers can help you increase your productivity."
- "Mimic the Functionality of the 1-2-3 Menus," The Spreadsheet Consultant, (May 92), pp. 11 - 13. Deck: "Getting custom menus to work just like 1-2-3's menu system has long been the bane of serious application developers. No more!"
- "Borland C++ 3.0," Lotus Magazine, (Mar. 92), pp. 92. Deck: "State-of-the-Art Tools for Professional Developers"
- "Build Active Links," Lotus Magazine, (Mar. 92), pp. 37-38. Deck: "Use Dynamic Data Exchange to connect applications."
- "Financial Analysis with Style," Lotus Magazine, (Mar. 92), pp. 53 - 57. Deck: "The balance sheet is only the beginning. Now you can analyze vital statistics and dress up the results."
- "Macro Menus," The Spreadsheet Consultant, (Mar. 92), pp. 3 - 7. Deck: "Create your own custom-menu systems."
- "Pick a Color, Any Color," The Spreadsheet Consultant, (Mar. 92), pp. 11 - 14. Deck: "Create a menu that lets both you and your users customize the look of your applications with ease."
- "Add-In Macro Power," Lotus Magazine, (Feb. 92), pp. 29 - 33. Deck: "The 70 new macro commands in Baler's Ice let you build applications with greater security, custom help, and custom menus. Here's how to get it down cold."
- "ObjectVision 2.0," Lotus Magazine, (Feb. 92), pp. 78. Deck: "Do-It-Yourself Windows Programming"
- "DataLens: Through a Glass Brightly," Lotus Magazine, (Jan. 92), pp. 24 - 30. Deck: "1-2-3's DataLens technology offers easy access to a variety of external databases."
- "Macro Compatibility in 1-2-3/W," Lotus Magazine, (Jan. 92), pp. 19 - 21. Deck: "The new Windows version of 1-2-3 offers challenges for the macro developer."
- "1-2-3 for Windows Add-In Development Kit," Lotus Magazine, (Dec. 91), pp. 97
- "Put It There," Lotus Magazine, (Dec. 91), pp. 20 - 22. Deck: " AT INDEX and {PUT} team up to let you quickly enter or change data in a table."
- "Form Letters that Get Attention," Lotus Magazine, (Nov. 91), pp. 20, 22, 24. Deck: "Use WYSIWYG to produce picture-perfect correspondence from your database."
- "Rating Investments with 1-2-3," Lotus Magazine, (Nov. 91), pp. 62 - 65. Deck: "In many cases, net present value is more flexible and more accurate than internal rate of return."
- "The Time Series Machine," Lotus Magazine, (Nov. 91), pp. 68 - 71. Deck: "An ambitious 1-2-3 template brings new perspective to historical data."
- "Good Fences Make Good Worksheets," Lotus Magazine, (Oct. 91), pp. 24, 26, 29. Deck: "1-2-3 Macros: Keep users within a specific range, but give them access to 1-2-3's menus and function keys."
- "The Rise and Fall of the Lotus Programming Language," Lotus Magazine, (Oct. 91), pp. 108
- "E-Mail Options for Spreadsheet Users," Lotus Magazine, (Sept. 91), pp. 40 - 43. Deck: "Want to send a worksheet? Notes, cc:Mail, and AT Mail each have important advantages."
- "Get Your Data Together," Lotus Magazine, (Sept. 91), pp. 28, 30, 32, 34. Deck: "Three File Combine macros that overcome the limitations of file linking."
- "Build Modular Macros," Lotus Magazine, (Aug. 91), pp. 20 - 24. Deck: "Use range names as arguments to add flexibility to your structured programs."
- "Loopy Macros," Lotus Magazine, (Jun. 91), pp. 24, 26, 32. Deck: "When you want a task done repeatedly, don't get bored, get a macro."
- "1-2-3's New Releases: A Double Feature," Lotus Magazine, (May 91), pp. 34 - 39. Deck: "A sneak preview of Release 2.3 and Release 3.1+--coming soon to a screen near you."
- "Pastes that Don't Get Stuck," Lotus Magazine, (May 91), pp. 26, 28, 30. Deck: "Simple macros let you use Windows to copy chunks of text into a 1-2-3 worksheet."
- "Menu Mania," Lotus Magazine, (Apr. 91), pp. 28, 30 - 31. Deck: "Use a macro to fill your screen with dozens of menu choices."
- "Safe File-Saving," Lotus Magazine, (Mar. 91), pp. 30 - 31. Deck: "Prevent file mishaps with save and retrieve macros."
- "In Case of Emergency," Lotus Magazine, (Feb. 91), pp. 20 - 22. Deck: "Use the {ONERROR} command to keep your macros from bombing."
- "Tool for Taxes," Lotus Magazine, (Feb. 91), pp. 36 - 39. Deck: "How to make 1-2-3 act like a paper-tape calculator--only better."
- "Easy Printer Control," Lotus Magazine, (Jan. 91), pp. 26 - 28. Deck: "A custom-menu system adds print attributes to your worksheets."
- "First Impressions of Release 3.1," Lotus Magazine, (Oct. 90), pp. 40 - 42. Deck: "Spreadsheet publishing, virtual-memory, and Windows compatibility add muscle to Release 3."
- "Slide into AT BASE," Lotus Magazine, (Oct. 90), pp. 30 - 33. Deck: "Automated data transfers extend the power of the familiar FORM window."
- "Byways of Allways," Lotus Magazine, (Sept. 90), pp. 66 - 67. Deck: "The less flashy features are often the most useful."
- "What Kind of Cell am I?," Lotus Magazine, (Sept. 90), pp. 36 - 38. Deck: "Efficient macro techniques quickly find and change cells, based on their attributes."
- "Manage Those Macros," Lotus Magazine, (Aug. 90), pp. 18 - 20. Deck: "Try the {DISPATCH} command when a macro library becomes too big to control."
"Building a Fast Megadatabase," Lotus Magazine, (Jul. 90), pp. 25 - 29. Deck: "Advanced hashing techniques quickly search through a million records." - "How NCR Analyzes New-Product Payoff," Lotus Magazine, (Jul. 90), pp. 32 - 36. Deck: "Release 3 and the Add-In Toolkit make it easy for managers to look eight years ahead."
- "On to a Better Replace," Lotus Magazine, (May 90), pp. 36 - 38. Deck: "Globally substitute a tab or a carriage return for any string."
- "Build a Front End to a dBASE III File," Lotus Magazine, (Apr. 90), pp. 20 - 24. Deck: "Learn how to use Release 3's Data External command to link your spreadsheet with database information."
- "The Systems-Development Life Cycle," Lotus Magazine, (Apr. 90), pp. 32 - 37. Deck: "For those really important projects, discover the power of prototypes."
- "Create Macros with Learn Mode," Lotus Magazine, (Mar. 90), pp. 34 - 38. Deck: "Symphony's Learn facility gets you started with macros quickly and easily."
- "From Table to Form in a Snap," Lotus Magazine, (Jan. 90), pp. 38 - 41. Deck: "Build a macro that transforms a simple table into a Symphony database."
- "Macros Can Speed Up Your Work with 1-2-3 Add-Ins," Lotus Magazine, (Jan. 90), pp. 34 - 36. Deck: "Let macros automate procedures when you use programs like Allways."
- "Set up your databases automatically," Lotus Magazine, (Dec. 89), pp. 28 - 31. Deck: "Create data query ranges with a macro that does it all for you."
- "When to avoid the {BRANCH} command," Lotus Magazine, (Dec. 89), pp. 32, 37. Deck: "Replace branches with calls to make your macros more readable and more expandable."
- "Inside the New Macro Commands," Lotus Magazine, (Nov. 89), pp. 28 - 32. Deck: "New options in Releases 2.2 and 3 can make worksheets more powerful and more attractive."
- "Translating 'A Pauper's Notepad'," Lotus Magazine, (Nov. 89), pp. 41 - 44. Deck: "The March AT WORK model didn't work in Symphony . . . until now."
- "Create Form-Filling Input Routines," Lotus Magazine, (Oct. 89), pp. 28 - 31. Deck: "Learn effective screen design for models that require repetitive data entry."
- "How to Create a Vertical Light-Bar Menu," Lotus Magazine, (Oct. 89), pp. 22 - 25. Deck: "Bypass the {MENUBRANCH} command to produce center-screen menus."
- "A Faster Way to Copy," Lotus Magazine, (Sept. 89), pp. 38 - 39. Deck: "Learn how to use macros. Try the speedy {LET} command, which is forty times faster than the Copy command."
- "Choose Formulas Over Macros," Lotus Magazine, (Sept. 89), pp. 81 - 82. Deck: "Formulas and AT functions can analyze data faster than most macro routines can."
- "How to Build a Versatile Toolbox," Lotus Magazine, (Sept. 89), pp. 32 - 34. Deck: "This structured set of macros can help you solve advanced business problems. The {DEFINE} command is the secret."
- "Symphony Typing Tester," Lotus Magazine, (Sept. 89), pp. 40 - 41. Deck: "Create this model to test your typing speed."
- "Attention: Parents of College-Bound Toddlers," Lotus Magazine, (Aug. 89), pp. 32, 37. Deck: "Use this model to figure baby's future tuition costs into your budget."
- "Screen Dialogues That Everyone Can Understand," Lotus Magazine, (Aug. 89), pp. 28 - 30. Deck: "Design a Q&A routine that makes it easy for a user to answer when prompted for information."
- "Branches That Control," Lotus Magazine, (Jul. 89), pp. 37 - 38. Deck: "Add flexibility to your models and avoid crashes."
- "Pick a Card," Lotus Magazine, (Jul. 89), pp. 40. Deck: "This worksheet helps you decide which credit card best suits your payment habits."
- "A To-Do List Manager," Lotus Magazine, (Jun. 89), pp. 82 - 84. Deck: "A 1-2-3 template that will track your schedule."
- "Designing Large-scale Worksheets," Lotus Magazine, (Jun. 89), pp. 30 - 34. Deck: "Tools to help you plan and develop those really big projects."
- "Is that file there?," Lotus Magazine, (Jun. 89), pp. 26 - 27. Deck: "The {OPEN} command can prevent disaster when your macros access the disk."
- "From the Pointer's View," Lotus Magazine, (May 89), pp. 36 - 40. Deck: "The AT CELLPOINTER function lets your macros "see" what they're doing."
- "Macro Letters," Lotus Magazine, (May 89), pp. 30 - 34. Deck: "Work with graphs, simplify data entry, store macros in libraries--your letters let us explore these topics, and more."
- "Around the Worksheet in 80 Centiseconds," Lotus Magazine, (Apr. 89), pp. 35 - 38. Deck: "If you've never written a macro, begin by building these to help you breeze around your spreadsheet."
- "When Your Database Outgrows RAM," Lotus Magazine, (Apr. 89), pp. 27 - 31. Deck: "Sophisticated techniques let you create a disk-based data system in 1-2-3."
- "A Pauper's Notepad," Lotus Magazine, (Mar. 89), pp. 34 - 35. Deck: "Use this 1-2-3 Release 2/2.01 macro to annotate cell entries."
- "Write Function Keys into Your Macros," Lotus Magazine, (Feb. 89), pp. 36 - 38. Deck: "Simple 1-2-3 macros call on function keys to speed up pointer movement, format cells, erase ranges, and retrieve files."
|