| |
| |
|
Software Information |
|
|
|
Corel WordPerfect 7 Macro Programming Example
Case study: She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. Doing this affects her productivity as this process increases the time taken to complete work and wastes time in correcting inevitable errors that occur. Proposal: Feasibility study: User Requirements: The user requires the ability to select the following options for formatting the output:
1) Displaying a sum in standard numbers or currency. Specification: Purposes of using macro: Calculate the sum of any numerical data specified by the user. Data to be embedded in macro: Any numerical data entered by the user. Use of macro: Accelerate processing of data therefore increasing productivity, by cutting out the additional keystrokes needed to run the calculation manually. Solution: Design of the system Typical configurations required: Method of input: Method of output: To VDU at the point of input data. Using this specification I have written an algorithm that makes effective use of the resources available in Corel WordPerfect 7. Algorithm for applications software macro: The solution to the algorithm stated above in the form of a macro that meets all the requirements identified in the analysis is as follows: Macro script: If (?DocBlank) Condition executed if document blank // Go to subroutine oninput go(oninput) endif // Select data block left of insertion point Selectwordprevious () // Condition executed if no data found If (?SelectedText="") // Go to subroutine error go(error) endif // Convert selected data block to a table Tableconvertfrom (type: tabularcolumns!) // Set default table style TableCellNumberFormat (FormatType: General!) // Turn off Update associated charts option Tableupdateassociatedcharts (state: off!) // Insert an equal sign left of data block Type (text: "=") Tablecalculate () // Calculate formula values in the table // If formula syntax is invalid go to else If(?CellFormula) // Display menu dialog box DialogShow(5001;"WordPerfect") // Condition executed if user presses cancel If(MacroDialogResult = 2) // Revert the last operations Undo(1) // Move insertion point to end of data bock PosWordNext () // Go to subroutine end Go(end) Endif // Condition executed if currency is defined If(currency) // Specify format data as currency [£00.00] TableCellNumberFormat (FormatType: Currency!) TableCellNumberNegativeNumber (NegDisplayType: Minus!) Endif // Condition executed if negatives defined If(negatives) // Specify negative format [(9)] Tablecellnumbernegativenumber (negdisplaytype: parentheses!) Endif // Specify commas are not used TableCellNumberUseCommas (State: No!) // Condition executed if commas defined If(commas) // Specify format data using commas [2,000] TableCellNumberUseCommas (State: Yes!) Endif // Select the table. Tableselecton (selectionmode: table!) // Select all cells in the current table Selecttable () // Delete table convert contents to document Tabledeletetable (delwhat: converttotabs!) // Move insertion point to end of data bock PosWordNext () // Go to subroutine end Go(end) // If formula syntax is invalid then Else endif // Identify the subroutine error Label(error) // Display error message box in event of invalid formula MessageBox (; "AUTOMATH UNABLE TO COMPLY"; "Invalid data exists in formula. Sequence terminated."; IconStop!) // Delete table convert contents to document Tabledeletetable (delwhat: converttotabs!) // Delete character right of the insertion point DeleteCharNext () // Go to subroutine end Go(end) // Identify subroutine oninput. Label(oninput) // Display error message box in event of blank document MessageBox (; "AUTOMATH UNABLE TO COMPLY"; "No input provided! Sequence terminated."; IconStop!) // Identify the subroutine end Label (end) // End macro Quit //==================================================== Implementation: The following tests were performed to confirm that the macro meets all of the requirements under real conditions. Tests to be applied: Test # one of basic macro: 1) Find an individual that knows nothing about this macro. 2) Observation of this individual doing the following: [a] Easily using the instructions. [b] Load Corel WordPerfect 7. [c] Enter valid numerical data. [d] Access the macro file. [e] Run the macro. [f] Repeat steps [c] to [e] using all possible combinations of the options. Ideally, the individual should be able to do the above with no assistance. 3) Observation of the macro running as intended in all conditions. Basic test conditions: Valid Input: Output: Invalid Input: output: [a] 5-5 0 [a][nothing] Error [b] 2+2 4 [b] qwerty Error [c] 2-4 -2 [c] 2gh+32 Error [d] 100*200 20000 [d] !"£$% Error [e] 50/1 50 [e] 1+4-1$ Error [f] 1+2-3*4/5 0.6 [f] one*two Error [g] 12345 £12,345.00 [g] a1-d3 Error (??) Test # two of debugged version: 1) Release the software on the LINK bulletin board system (run by Legalease) for evaluation by it's users. (the LINK is a special network for lawyers who often need maths functions in written work). 2) Collect commentary from the people willing to help. 3) Investigate and implement any changes or revisions necessary. Maintenance: I am the website administrator of the Wandle industrial museum (http://www.wandle.org). Established in 1983 by local people to ensure that the history of the valley was no longer neglected but enhanced awareness its heritage for the use and benefits of the community.
MORE RESOURCES:
Software - Google News |
|
|
|
RELATED ARTICLES
The Truth: Netzero 3G We've all seen the ads on TV for Netzero 3G. You know the ones, "speeds so fast you sworn it was broadband" Well if your using it, you may not think it really is. Spyware Protection: A Must for Any Home Computer Now that spyware is the single most dangerous threat to home computers connected to the internet today, getting your hands on some sort of spyware and adware protection is critical. Spyware has outpaced computer viruses in its prevalence, and in the kind of damage it can do to your system. Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist Microsoft Great Plains is main Microsoft Business Solutions product, targeted to mid-size companies. Currently Microsoft is in progress of transforming several ERP products it has: Microsoft Great Plains, Solomon and Navision into several business suites - Microsoft Financial, Microsoft HR, Microsoft Manufacturing, Microsoft Logistics. New SQL Delta Version 3.1 COMMAND LINE FUNCTIONA powerful command line script processor has been introduced to SQL Delta 3.1. Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup - overview Microsoft Great Plains may be recommended for international freight forwarding / transportation company. Great Plains has such features as multicurrency (Euro, Pound, Yuan, Yen, Peso, Real), Spanish, French, Brazilian Portuguese (and if needed Unicode-specific languages such as Chinese, Japanese). Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve - Tips For Developer Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few. Exactly What Does FTP Stand for and What Can it do for Me? FTP stands for "file transfer protocol". FTP is basically a way of sending files over the Internet. Microsoft Great Plains Inventory Control - Overview For Consultant Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features. Great Plains Bill of Materials Setup & Customization for Process Manufacturing - Overview Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity Requirements Planning, Job Costing, Master Production Scheduling, Materials Requirements Planning, etc. However Microsoft Great Manufacturing serves so-called discrete manufacturing market niche. Managing Stress in the Computer Industry - Five Steps to a Stress-free Life It would be easy to think, like most people apparently do, that stress and the computing (and especially programming) industry were unlikely bedfellows. The habitual image of long-haired young "geek" programmers churning out 'software' from their teenage bedrooms is one that many still associate with mainstream programmers. Microsoft CRM: Implementation, Customization, Support - Consultant Overview Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe. We expect substantial number growth of Microsoft CRM implementations across USA. Falling in Love With More Than One Screensaver: The Fun Part Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!As you remember, earlier in my article What to Do if You Fall in Love With More Than One Screensaver we discussed the standard way of switching between multiple screensavers. C++ Tutorial 1, Introduction to C++ Introduction to C++Why Learn C++?C++ may at first seem like a boring, confusing programming language that you can only program command prompt applications with. Well, that is what it is like in the [b]begining[/b]. Corporate ERP: Standard vs. Rich functionality - Microsoft Great Plains Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems. Groupware Finds Home in American Business: Collaboration Tool Analysis What is Groupware?Have you ever had to manage document collaboration in a hurry? No need to be ashamed if you said "yes." Virtually every American business has experienced moments of ad hoc team collaboration. Microsoft Small Business Manager Customization Options - Overview Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based application and successor and small business market niche version of Microsoft Great Plains. Microsoft Great Plains itself has variety of customization and integration tools: Integration Manager, VBA/Modifier, Great Plains Dexterity, SQL Server stored procedures to name a few. 10 Steps To Secure And Manage Your Passwords Passwords protect your most sensitive personal, financial and business information. They are the key to accessing membership, financial, and other web sites that you are a member of. Groupware as a Document Manager: Collaboration Series #3 This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. RFID: Strengthen the Position for SAP; United States SAP Inc., a global leader in client/server enterprise application software that for years been the backbone to RFID application has seen a 1,000% spike year-over-year in customers, interested in RFID deployment. An Introduction to .NET Framework .Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe.
|
|
Home | Site Map | 101InfoLinks.com | Best Book Shop | Sports Fans ONLY 
.
|
| © 2007 |
