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 pointSelectwordprevious ()// Condition executed if no data foundIf (?SelectedText="") // Go to subroutine error go(error) endif // Convert selected data block to a tableTableconvertfrom (type: tabularcolumns!)// Set default table styleTableCellNumberFormat (FormatType: General!)// Turn off Update associated charts optionTableupdateassociatedcharts (state: off!)// Insert an equal sign left of data blockType (text: "=") Tablecalculate () // Calculate formula values in the table // If formula syntax is invalid go to elseIf(?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 definedIf(currency) // Specify format data as currency [£00.00] TableCellNumberFormat (FormatType: Currency!) TableCellNumberNegativeNumber (NegDisplayType: Minus!)Endif // Condition executed if negatives definedIf(negatives) // Specify negative format [(9)] Tablecellnumbernegativenumber (negdisplaytype: parentheses!)Endif // Specify commas are not usedTableCellNumberUseCommas (State: No!) // Condition executed if commas definedIf(commas) // Specify format data using commas [2,000] TableCellNumberUseCommas (State: Yes!)Endif // Select the table. Tableselecton (selectionmode: table!)// Select all cells in the current tableSelecttable ()// Delete table convert contents to documentTabledeletetable (delwhat: converttotabs!)// Move insertion point to end of data bockPosWordNext ()// Go to subroutine end Go(end)// If formula syntax is invalid thenElseendif // Identify the subroutine errorLabel(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 documentTabledeletetable (delwhat: converttotabs!)// Delete character right of the insertion pointDeleteCharNext () // Go to subroutine endGo(end) // Identify subroutine oninput.Label(oninput) // Display error message box in event of blank documentMessageBox (; "AUTOMATH UNABLE TO COMPLY"; "No input provided! Sequence terminated."; IconStop!) // Identify the subroutine endLabel (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: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Microsoft Great Plains PM: Payables Management 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 Payables Management (PM) module improves control over your payables. eCommerce development for Microsoft Great Plains: tools and highlights for programmer Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC - Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:? Naming Convention. Cisco CCNA Certification: Becoming A Truly Valuable CCNA. I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates. The CCNA is an exciting beginning to your Cisco career, but just having the certification simply isn't enough. 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. Google Brings the Earth to Your Desktop Google Inc. has launched a new software package that allows you to see satellite images on your desktop. Design a Web Album Using Adobe Photoshop- Part 2 So let's begin crunching down these 300 images using Adobe Photoshop from start to finish. When I say 'crunching', to some 300 images may seem like allot, but it's not. Fast Car Knoppix Small can be beautiful! Working with Knoppix for the past two years has been a joy. Two terms to describe this distribution, simple, elegance. Software Engineering: An Introduction Software Engineering is the Systematic Approach for analysis design implementation and maintenance of Software .It involve the use of Case tools. Rapid Application Development - Is it Really a Need of Today? Rapid Application Development (RAD) is a software development methodology. In this competitive world, software product delivery time should be as little as it can be. Microsoft Great Plains Integrations - Tips for Developer In this short FAQ style article we would like to introduce you - software developer, programmer, database administrator into Microsoft Great Plains Integration tools and optionsMicrosoft Great Plains is main Microsoft Business Solutions product for US mid-market. Historically Great Plains Software designed Great Plains Dynamics and Dynamics C/S+ as multiplatform application and the integration was possible via Great Plains Dexterity or Dexterity-based end user tools, such as Import Utility and later on via Integration Manager. Cisco Certification: Introduction To ISDN, Part IV In part III of this ISDN primer, we learned that PPP has two main methods of authentication that Cisco certification candidates need to know how to configure: PAP and CHAP.PAP has very few advantages over CHAP. Microsoft Great Plains & CRM in Transportation & Logistics - Overview Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company. 15 Questions to Ask Your Software Vendor When making a decision to buy any piece of software there are a number of criteria typically evaluated. One of the most important elements in the decision process is the strength of the company that builds the software. FreeDOS Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use command line operating system that provided you with complete ability to control and troubleshoot your computer. Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security.First, here are some tips to make windows safer :For basic security and update patches install Service Pack 2 for Windows XP or Service Pack 4 for Windows 2000. Microsoft Great Plains Customization: Project Organization - International Business Example Microsoft Business Solutions Great Plains fits to majority of horizontal niches and clientele in the USA, Canada, Mexico, Latin America, U.K. DVD Burning Tips CD and DVD replication is a process that works by creating discs from scratch. Not to be confused with duplication (the act of burning information onto readymade, commercially-available blank CD-Rs and DVD-Rs), replication relies on the use of molds to produce actual discs that already contain digital data. Put Some Pizazz in Your Software Arsenal The software giants don't do everything and don't always produce the result that we want. At least if you're like me, and you're not where you would like to be (profitwise). Software Process Improvement -A Successful Journey Background:For many organizations like ours, the interim target of achieving ISO 9001 or CMM levels is a daunting task. Discipline is no fun -Organizations readily acknowledge that striving to address projects according to ISO 9001 or CMM guidelines requires the creation of new procedures. Microsoft Great Plains Security Setup - Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise. |
home | site map | contact us |