Notes
Slide Show
Outline
1
Data Entry Management

  • Data Entry Management
2
Manual Data
  • Manual data is common in Industry.
    • Field observations
    • Manual data entry
    • Laboratory results


  • Manual data is in many formats.
    • Paper
    • Electronic
      • Email
      • Text files

  • Manual data comes from many locations.
    • External laboratories
    • Operators in the field
    • Workstations on a network


  • Manual data is not always utilized.
    • For reporting and analysis
    • To manage operations
3
User Needs
  • Consistent entry forms.
    • Build in a familiar environment
    • No programming or specialists


  • One form, many users.
    • Secure solution
    • Data validation


  • Easy to maintain and modify.
    • Changes done in house
    • Grow as needs evolve


  • Report from form and process data combined.
    • Avoid additional software
    • Automatic reports e.g., regulatory
    • On-demand reports e.g., maintenance

4
XLReporter Solution
  • Consistent entry forms.
    • Forms designed in Microsoft Excel
    • Use all the features of Excel


  • One form, many users.
    • Forms stored in a central location
    • Available across the network


  • Easy to maintain and modify.
    • Database managed in Excel
    • No SQL programming


  • Report from form and process data.
    • Reports designed in Excel
      • Automatic
      • Interactive

5
Design a Form in Excel
  • Design a form in minutes.
    • Formatting
    • Calculations
    • Data validation
    • Drop down pick lists


  • Manage the database.
    • No SQL programming
    • Create/modify tables with one click
    • Link the form to the table


6
Deploy the Form
  • Save a form and it’s ready to use.
    • No compiling or scripting


  • Use the form without an Excel license.
    • User access limited by credentials
    • Data validated before stored



7
Produce Reports in Excel
  • Reports designed in minutes.
    • Form data and process data
  • Automatic reports.
    • Schedule in the background
    • View across the network
  • Interactive reports.
    • Produce across the network
  • Publish.
    • Web Pages, PDF
    • Email, FTP
    • File Server, Printer

8
Awards and Testimonials
  • “The automation interface provided by SyTech enables Excel to be used in more niche markets that require automated and unattended operation. This is an example of how Microsoft Office applications can solve critical business problems for our customers and deliver great benefits to creative partners like SyTech.”
  • Microsoft Corp.


9
Information and Download
  • Web
    • www.SyTech.com
    • www.TheReportCompany.com
    • www.XLReporter.net


  • Email
    • sales@SyTech.com


  • Phone
    • 508 520 9957 (9XLR)


10
www.TheReportCompany.com

  • www.TheReportCompany.com