Format of Charge Information Files
The cost is calculated by multiplying the unit cost and impressions where the "Organization Name", "Model Name", "Service Types", "Output Color", "Size" of the log match.
Default value of the reference destination: {Data Storage Location Folder}\Settings\awjla_charge_info.xls
Format and Cell Default Value
| Organization Name [required] | Model Name [required] | Service Type [required] | Output Color [required] |
Size [required] | Unit Cost [required] |
|---|---|---|---|---|---|
| (Blank) | (Blank) | (Blank) | (Blank) | (Blank) | 10 |
| * | * | Fax Send | * | * | 0 |
| * | * | Fax Direct Send | * | * | 0 |
| * | * | Fax Polling | * | * | 0 |
| * | * | Fax Internet Send | * | * | 0 |
By changing the title of "Model Name [required]" to "Device Name [required]", you also can enter the device name.
To display a numerical value in decimal points for charges in the report, change the Excel cell format for the "Unit Cost" column to the setting for displaying digit numbers in decimal points.
Cell Entry Rules
| * | * | "*" "Print" "System Sheet" "Scan" "Copy" "Print Fax" "Fax Mailbox Print" "Fax Polling Print" | "*" "B/W" "Full Color" "Single Color" | "*" "A3" "B4" "A4" "B5" "A5" | None |
Items for which "*" is set target everything.
Data for which only the unit cost is set on the second row is a basic unit cost. Definitely set the basic unit cost. Enter only the unit cost for the basic unit cost row, and leave all other columns blank.
The priority to decide the unit cost is in the order of Organization name, model name, service types, output color, size. The priority is higher where the value is entered instead of "*".
Entry Columns
In the following example, print charges for full color/ all sizes of FUJIFILM Apeos C7070 used in all Organization names are 50 yen/sheet and the print charges for all types of black and white/all sizes are 10 Yen/sheet. Other charges are 100 yen/sheet from the basic cost.
| Organization Name [required] | Model Name [required] | Service Type [required] | Output Color [required] |
Size [required] | Unit Cost [required] |
|---|---|---|---|---|---|
| (Blank) | (Blank) | (Blank) | (Blank) | (Blank) | 100 |
| * | FUJIFILM Apeos C7070 | Full Color | * | 50 | |
| * | * | Black and White | * | 10 |
Method of adding the charges of BrainTech folds, stamps, etc.
If [Other Charges] sheet is created in the Charges Information file, the charges for BrainTech folds, stamps and paper types can be added.
If fold, stamp, paper type are specified in "Service Types" on the [Other Charges] sheet, the charges can be added. Charges can be set for the size, output color and model name respectively. Do not set the basic unit price.
When the "Model Name", "Service Types", "Output Color", and "Size" are specified, enter the value recorded in the job log respectively.
An example of setting in the [Other Charges] sheet of the Charges Information file is given below.
| Model Name | Service Types | Color Mode | Size | Unit price |
|---|---|---|---|---|
| * | Fan fold | * | * | 10 |
| * | Cross fold | * | A1 | 20 |
| * | Plain paper | * | * | 5 |
| * | Tracing | * | A1 | 20 |
| * | Film | * | A2 | 10 |
| * | Red stamp | * | * | 10 |
Converting from BrainTech paper roll to paper size
BrainTech size conversion table file is used to convert the BrainTech paper roll into paper size (such as A0, A1).
When the "Size" in the job log is "Other", it converts the paper roll to be used into the paper size. The "Length of the used roll" which is retrieved from the job log is divided by the "Length of the size" and multiplied by the "Number of sheets" to get the impressions.
Storage directory and file name of the BrainTech size conversion table file are given below.
{Data Storage Location Folder}\Settings\awjla_bt_size_conversion.xls
BrainTech size conversion table file format is given below. You do not need to edit it.
| Size of roll used [Required] | Size [required] | Vertical length (mm) [Required] |
|---|---|---|
| A0 | Other (convert to A0) | 1189 |
| A1 | Other (convert to A1) | 841 |
| A2 | Other (convert to A2) | 594 |
| (Rest omitted) | ||