Summary Report Template Free Business Templates Business Report Template Free Word #39;s Templates Business Report Template Free Business. Financial Report Template Free Printable Sample MS Word Templates. Here is preview of this Trip Expense Report created using MS Excel. Important The information set out in this topic is presented exclusively for the benefit and use of individuals and organizations outside the United States and its territories or whose products were distributed by Microsoft before January 2010, when Microsoft removed an implementation of particular functionality related to custom XML from Word. This information may not be read or used by individuals or organizations in the United States or its territories whose products were licensed by Microsoft after January 10, 2010; those products will not behave the same as products licensed before that date or licenses for use outside the United States. Rice, Microsoft Corporation Paul Cornell, Microsoft Corporation June 2003 Applies to: Microsoft Office Word 2003 Download. ![]() Contents • • • • • • • • •. Alpine Ski House is a West-coast outdoor-equipment manufacturer. ![]() ![]() Creating and Applying an XML Resume Template in Microsoft Office Word 2003. About the Business. The trip report template must not take a lot of skill to fill out. Free download microsoft word trip report template Files at Software Informer. Microsoft Streets & Trips 2007 is a trip planner for Windows. This application allows. Business Trip Report To From Date Business Trip Overview Travel Destination. Microsoft Word - Business-Trip-Report-Template Author: Birgir Created Date. In addition to making skis, Alpine Ski House has begun making snowboards and snowshoes. Next year, Alpine Ski House plans to add a winter clothing line. In preparation for this new venture, several of Alpine Ski House's 15 sales representatives have been visiting ski resorts across the United States to pitch their idea to clothing stores and gift shops near the ski slopes. During these visits, sales representatives record their findings in a series of trip reports, which are e-mailed back each evening to Alpine Ski House's headquarters. Alpine Ski House's marketing team wants to aggregate all of the sales representatives' trip reports into daily, weekly, and monthly overall trip reports, as well as a final report at the end of the winter season. Although all of the Alpine Ski House's sales representative carry laptops with the Microsoft Office System installed, the sales representatives have created their trip reports in the past using a combination of Microsoft Word documents, e-mail messages, Microsoft Excel spreadsheets, Microsoft PowerPoint presentations, and the like. This has resulted in the marketing team wasting a lot of time copying and pasting the trip reports' information into summary reports. Marketing also has to do a lot of follow-up conversations with sales representatives when key information is missing from the trip reports. This wastes a lot of time for both marketing and sales representatives. ![]() The proposed solution must use Word as the trip report writing application. The trip reports must require the sales representatives to enter the trip details that marketing requires to create their summary reports. The trip report template must not take a lot of skill to fill out. The trip reports must be able to be transformed into other summary report formats. Finally, the trip reports must be flexible to add special trip details or other business insights that deviate from marketing's requirements if needed. ![]() The solution consists of the following components: • The trip report XML schema. • A trip report Word template. • A transform that summarizes the trip report for the marketing department. From an operational perspective, this solution must: • Given a document template, reference the appropriate schemas and transforms with as little user intervention as possible. • Allow users to save instance documents as XML data only without any Word XML document schema markup (although customer-defined transforms can be applied while saving XML data). • Allow users to insert new visit report sections, with the required descendant nodes, as children of the visits report section. • Allow users to insert new visited place report sections, with the required descendant nodes, as children of existing visit report sections. • Allow users to insert new contact report sections, with the required descendant nodes, as children of existing contacts report sections. After consulting with Alpine Ski House marketing department, it was determined that the salespeople needed to capture the following information for their marketing database. • The salesperson's name and e-mail address. • The date that the visits were conducted. • A general summary comprising all of the visits for that date. • For each visited geographical area, an overall visit summary, and the places visited in that area, including site names, site summaries, site addresses, and people contacted at each site. • For each contact, a name, e-mail address, street address, phone number, fax number, mobile phone number, pager number, other means to reach the contact, the visit start and end times, and any other notes about the contact. Based on this information, the following customer-defined schema was created. If you visit multiple people at a location you can record a separate contact for each person visited. You can break individual visits up into multiple 'visitedPlaces' elements if needed. A summary of all of the day's reports. You can break the day's visits up into multiple 'visit' elements if needed. Defines an Alpine Ski House trip report. Accepts United States phone number patterns only. The schema follows this basic pattern. Some of the key schema design decisions include the following: • Define extensible namespaces. When the W3C XML Schemas recommendation was in its infancy, organizations would create some odd-looking namespaces that didn't seem to follow any pattern, such as uri:schemas-myCompany-com#mySchema, schemas.myCompany.com.mySchema, and so on. By convention, organizations are encouraged to use their Internet URL, followed by an internally-agreed-upon naming convention. A namespace should look very much like an Internet address. For example, Alpine Ski House uses as its base namespace, followed by the schema's purpose, followed by which group will primarily use the schema. Following this naming convention, Alpine Ski House could create schema names such as: • • • • • Use a single element component to define the root element, and use a series of complexType components to define all of the root element's descendant elements. For example, the root element is defined in a tripReport element component of type tripReport_type, as follows. The visits_type is defined in yet another complexType component, and so on. The decision was made to add the suffix _type to simpleType and complexType component names to easily distinguish type name definitions from element name definitions. • Embed documentation directly into the schema. Every component allows a child annotation element, which in turn allows a child documentation element, that can contain documentation, for example. Defines an Alpine Ski House trip report.. • Use the minOccurs and maxOccurs attributes wherever possible to strictly define the number of times that a component occurs. • Use strict data typing wherever possible to leverage the applications' built-in schema validation features. • Restrict the range of input values wherever possible to leverage the applications' built-in data input validation features. If you visit multiple people at a location you can record a separate contact for each person visited.. Accepts United States phone number patterns only.. The trip report schema was created with Microsoft Visual Studio.NET as follows: • Start Visual Studio.NET. • On the File menu, point to New, and click File. • In the New File dialog box, open the General folder in the left pane, click the XML Schema icon in the right pane, and click Open. • On the View menu, click Toolbox. • Drag schema components (elements, attributes, simple and complex types, facets, and so on) to the visual designer. • Use the visual designer to customize the schema components. • You can further refine the schema by clicking XML Source on the View menu. • When you're finished creating the schema, click Save on the File menu, and save the.xsd file to the desired location. For help with using schema syntax, click inside of any schema component in Schema or XML view, and on the Help menu, click Dynamic Help. To view the trip report schema in Visual Studio.NET: • Start Visual Studio.NET. • On the File menu, point to Open, and click File. • Locate and click the trip_report_sales.xsd file, and click Open. To assist users in creating XML instance documents, all of the document templates are visually enhanced with things like colors, shading, and text formatting. Users can save the XML instance documents without visual formatting details, leaving the customer-defined XML data unaltered in the saved XML instance documents. To create a document template with embedded customer-defined XML: • Start Word. A new, blank document appears. • On the Tools menu, click Templates And Add-Ins. • If the check box is visible, select it, and click OK. If the check box is not visible: • On the XML Schema tab, click Schema Library. • Click Add Schema. • Locate and click the trip_report_sales.xsd file (include in the download with this article), and click Open. • Click OK twice. • Select the check box, and click OK. After you've attached the trip report schema: • Add text, formatting, colors, and so on to the document. • Use the XML Structure task pane to add elements to the document. • Save the file as a Word document template (.dot). Note If you want to allow users to create valid XML documents without concern for any text formatting interspersed with XML components in the template, before you save the document template, in the XML Structure task pane, click XML Options, select the Ignore Mixed Content check box, and click OK. If the user saves the XML document with XML data only, the text formatting, as well as any other content outside of the embedded elements, will not be saved with the XML document. If the user saves the XML document to the Word XML document schema format, both the embedded elements and the text formatting will be saved with the XML document. • To view the finished version of the trip report document template, use Word to open the TripReportTemplate.dot file (include in the download with this article). Public WithEvents gwdApp As Word.Application Private Const TOOLBAR_NAME = 'Trip Report Actions' Public gcbToolbar As Office.CommandBar Dim wdApp As New DeclareWordApp Public Sub CreateToolbar() Dim cbToolbar As Office.CommandBar Dim blnToolbarExists As Boolean Dim strCaptions(1 To 4) As String Dim strOnActions(1 To 4) As String blnToolbarExists = False ' If the toolbar exists, don't create a duplicate one. When marketing reports their findings to the Alpine Ski House board of directors, they only want to expose the following information: • The salesperson's name and the date that the visits were conducted. • The overall summary of all visits. • The geographical areas visited with the overall visit summary. • The place names and place summaries in each geographical area. • The contacts names and contact notes for each place visited. The following XSL file can be run against the TripReportTemplate.dot to create an XML file with only the above information. Copy the following into a file with an.xsl extension. You can use the transform to change an XML document's actual contents. With the XML document open, when you click Save As on the File menu, select the Apply Transform check box, click Transform, select a transform, click Open, and then click Save. The transform is applied to a copy of the XML document's contents as the XML document is saved. In this article, we examined a fictitious company, the Alpine Ski House, and how they used the XML features of Word to create a system the allowed their sales representatives to record, file, and transform the information compiled from sales trips. The application used XML template where the representative entered data into preformatted fields which could then be saved as XML data only or saved with a transform to convert the data into a summarized format. The representative could also easily add addition elements to the template as needed with a custom toolbar. Using similar features in Word and the other Microsoft Office applications can reduce the effort and duplication common in legacy systems that are often put together piecemeal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |