Xerox FreeFlow Web Services 6.0 User Guide

0 (0)

Version 6.0, September 2007 701P47577

FreeFlow®

Web Services

Excel Pricing

Xerox Corporation

Global Knowledge & Language Services

800 Phillips Road

Building 845

Webster, New York 14580

Copyright © 1996-2006 Xerox Corporation. All rights reserved. XEROX®, Xerox Canada Ltd®, Xerox Limited®, FreeFlow®, The Document Company® and all identifying numbers used in connection with the Xerox products mentioned in this publication are trademarks of XEROX CORPORATION. Copyright protection claimed includes all forms and matters of copyrightable material and information now allowed by statutory or judicial law or hereinafter granted, including without limitations, material generated from the software programs which are displayed on the screen such as styles, templates, icons, screen displays looks, etc.

While every care has been taken in the preparation of this material, no liability will be accepted by Xerox Corporation arising out of any inaccuracies or omissions. Printed in the United States of America.

Other company trademarks are acknowledged as follows:

Adobe®, the Adobe logo, Acrobat®, the Acrobat logo, Acrobat Reader®, Distiller®, Adobe PDF JobReady™, and PostScript®, and the PostScript logo are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Compaq® and QVision® are registered United States Patent and Trademark Office, for Compaq Computer Corporation. DEC, DEC RAID, and Redundant Array of Independent Disks are registered trademarks of Digital Equipment Corporation. Dundas - This software contains material that is (c) 1997-2000 DUNDAS SOFTWARE LTD., all rights reserved. Hummingbird NFS Solo® is a registered trademark of Hummingbird Communications, Ltd.

Imaging Technology provided under license by Accusoft Corporation. ImageGear © 1996-2005 by AccuSoft Corporation. All Rights Reserved. Intel® and Pentium® are registered trademarks of Intel Corporation.

Novell® and NetWare® are registered trademarks of Novell, Inc. in the United States and other countries. Oracle® is a registered trademark of Oracle Corporation Redwood City, California

Preps™ is a registered trademark of Creo Inc. All rights reserved. Quark® and QuarkXpress® are registered trademarks of Quark, Inc. StorageViewTM is a trademark of CMD Technology, Inc. TextBridge® is a registered Trademark of ScanSoft, Inc.

TIFF® is a registered trademark of Aldus Corporation.

Windows®, Windows XP®, and Internet Explorer are trademarks of Microsoft Corporation; Microsoft® and MS-DOS® are registered trademarks of Microsoft Corporation.

This product includes software developed by the Apache Software Foundation. Copyright © 1999-2003 The Apache Software Foundation. All rights reserved. This software is based in part on the work of Graeme W. Gill.

Includes Adobe® PDF Libraries and Adobe Normalizer technology

The Graphics Interchange Format © is the Copyright property of CompuServe Incorporated. GIFSM is a Service Mark property of CompuServe Incorporated. Portions contain an implementation of the LZW algorithm licensed under U.S. Patent 4,558,302.

All non-Xerox brands and product names are trademarks or registered trademarks of their respective companies.

Changes are periodically made to this document. Changes, technical inaccuracies, and typographical errors will be corrected in subsequent editions.

	Content
Content
Introduction ........................................................................	1
Working with Excel File ............................................................	1
Settings in the FreeFlow Web Services System.........................	2
Pricing Models ..........................................................................	2
Assigning Excel Pricing to a Print Buyer ...................................	3
Excel Pricing File Format .......................................................	5
Excel Pricing with the Book Assembly Module..........................	10
Appendix ...........................................................................	12

Example of Excel Programming and Useful Excel Functions ... 12

Excel Pricing

Content

ii	Excel Pricing

Introduction

Excel Pricing has been developed for Print Providers who prefer a pricing solution other than that provided by FreeFlow Web Services. The reasons Print Providers may prefer an extraneous pricing system are two fold:

•These Print Providers have their own unique way of calculating the price and are not able to find a satisfactory way in which to define pricing within the Web Services system

•The Print Providers already have their own tool by which they can define a price list and calculate prices

Excel Pricing enables the Print Provider to upload an Excel file that contains all pricing parameters and then assign the file to an intended customer.

Note: 1. By working with an Excel file, all calculation methods are possible (i.e. any formula or any information that will generate the specific price can be employed).

2.To activate Excel pricing, the Data Export module must be purchased.

Working with Excel File

To work with Excel Pricing, the Print Provider must first create an Excel file (see page 5 for more complete details) and then upload the file to the Print Buyer account. When the Print Buyer clicks on Get Quote, all relevant information related to the Job and the customer, is exported from the Web Services system (in the background of the Excel file) into the Excel file. The Excel file receives the new information and, according to the formulas that the Print Provider provided, updates and calculates the price. The price and the output device information are automatically imported back to the Web Services system, where it is displayed to the Print Buyer.

Upload Excel File

Print Buyer clicks on Get Quote

Excel File (Background)

Price is displayed

When working with Excel pricing, the Print Provider can price a multitude of additional parameters. A few examples are: B&W and Color Pages, Click Charges, Job Tickets and Paper Types.

Excel Pricing

Settings in the FreeFlow Web Services System

The Settings section describes the interaction between the Web Services and the Excel pricing file for a specific customer.

The following issues are covered in this section:

•The position of Excel pricing within the FreeFlow Web Services pricing models

•How to assign an Excel pricing file to a Print Buyer

•How to download an Excel file that is assigned to a customer

Pricing Models

Xerox FreeFlow Web Services supports a 5 level pricing model. This mechanism comes into action whenever a customer clicks on the Get Quote button located in the Shopping Cart window. In order to calculate and display the price, the system employs one of the following five methods:

Per Job

Template

Customer (Excel)

Job Type

Generic - Production Cost

The Web Services pricing model is hierarchical. The system first checks for the presence of per Job (manual) pricing. If Manual pricing exists, this is the price that is displayed for the Print Buyer. If Manual pricing does not exist, the system searches for Template pricing. If Template pricing does not exist, the system searches for Excel pricing and then for Job Type pricing. If none exist, the system calculates the price according to production costs.

The Excel pricing model is at the customer level, which means that for each customer, there is an option to set the same pricing mechanism or a different one.

2	Excel Pricing

Xerox FreeFlow Web Services 6.0 User Guide

Settings in the FreeFlow Web Services System

Assigning Excel Pricing to a Print Buyer

Assigning an Excel pricing file to a customer is completed out on the Print Provider side. To assign an Excel pricing file to a customer, carry out the following steps:

1Log in as a Print Provider and then click on Customers (choose the relevant customer)/Preferences; the Preferences window appears.

2In the Pricing sub panel, select the Excel option from the Customer Pricing Model dropdown menu; the Excel File link becomes enabled.

3 Select the Excel file to be assigned to the specific customer.

Excel Pricing

+ 15 hidden pages