DJ4500 - FM Accounting Excel Template v101 by hmoda

VIEWS: 20 PAGES: 40

									                                                                         Help section
Introduction
This Excel file will help you to view the usage and accounting reports from the HP Designjet 4000/4500 Printer series.
The HP Designjet 4000/4500 Printer series can be configured to send regular usage reports in XML, by E-mail.
The XML file can be imported into this Excel file (see 'Entry Tab'), where the usage information can be viewed easily (see 'Summ
The 'Summary' tab shows: Total prints (area in m² or ft²), prints per media type, prints per job category (see description below).
The tabs 'Users Summary' and 'Accounts Summary' show details about usage per user or account ID.
This Excel file is to show the usage reports of one printer only.
For more information, please see the HP Designjet 4000/4500 Printer series Using Your Printer (on CD).

© Copyright 2005 Hewlett-Packard Development Company L.P.
Excel template version 1.01 (built on Jan 31st, 2006)

System Requirements and Limitations
- This template requires Excel 2003 installed in your system. Older versions will not work.
- This template works only if macros are enabled. Depending on the Macro Security settings, you may need to enable macros
  explicitly for this Excel file and trust Hewlett-Packard. If your Macro Security level is set to Very High, and you are trying to
  open this Excel file directly from the Internet or from an E-mail attachment, you may not be able to enable the macros.
  In order to change the Macro Security settings, please perform the following steps:
              * Go to Tools -> Options in the Excel menu
              * Select the Security tab
              * Push the Macro Security… button
              * Change the Macro Security level to High or Medium
  For additional details, see the document Viewing accounting reports in Microsoft Excel available on the web.
- You can translate all table names or text (except those that contain currency names and units of measurement).
- You MUST NOT:
              * Move cells
              * Delete or add rows
              * Delete or add columns
              * Change the order of the sheets
   If you do any of these things, the report generation capabilities of this Excel file may be broken.

Quick guide
1a. Go to 'Entry Tab' and choose your units of measurement (m² or ft²) in Step 1.
(When you change the units, the figures are not recalculated! You must regenerate the reports before the change of units takes effect.)


w Please make sure to use 'Clear All Data' before importing data of a different printer. If not, the usage data of old and new prin
Best practice is to save the excel under a different name for each different printer or customer.

1b. Also in the 'Entry tab', in Step 2, you have various options for importing the data (after clicking on 'Import Accounting File' ):
             a. Choose an XML file (the printer sends it by E-mail in a zip file)—it will automatically be added to earlier Excel data
             b. Choose a folder from which to import multiple XML files (each for a different period)—only for multiple files from th
             c. Import the data directly from the printer, giving its IP address and the dates (start and finish).

1c. Once you have the data, you must click on ' Generate Reports' in Step 3 (also in 'Entry Tab'), to organize all data in th
sheets.

2. All other sheets will be filled automatically with information from the imported files.

3. (Optional) To calculate cost information, please go to the 'Costs' sheet and enter or change the ink and media cost data. T
costs will be shown in the 'Costs' sheet, after clicking 'Generate Reports' in 'Entry Tab'
Categories information
The cost of a plot depends on the ink usage and the type of image printed. Typically, plans or line drawings consume less ink tha
To facilitate accounting based on the image type, the following four print categories have been defined.
The category is defined by the ml of ink used per m². The ink usage and the print category are calculated by the printer.

  Print
             ml / m²        ml / ft²
Category
    A          0 - 0.5      0 - 0.046   Typically low-coverage lines
    B         0.5 - 2.0   0.046 - 0.185 Typically high-coverage lines
    C         2.0 - 5.0   0.185 - 0.464 Typically maps or low-coverage renders
    D        5.0 - 10.0   0.464 - 0.929 Typically photographs
esignjet 4000/4500 Printer series.
 reports in XML, by E-mail.
nformation can be viewed easily (see 'Summary').
s per job category (see description below).




y settings, you may need to enable macros
is set to Very High, and you are trying to
y not be able to enable the macros.




xcel available on the web.
s and units of measurement).




e change of units takes effect.)


er. If not, the usage data of old and new printer are added up.


  (after clicking on 'Import Accounting File' ):
automatically be added to earlier Excel data about this printer.
 ferent period)—only for multiple files from the same printer.
dates (start and finish).

so in 'Entry Tab'), to organize all data in the following




r or change the ink and media cost data. The resulting
ab'
, plans or line drawings consume less ink than maps or posters.

egory are calculated by the printer.
                               START HERE

Step 1 -       Choose units of measurement




Step 2 -       Choose the XML file or files to import:        Import Accounting File




Step 3 -       Calculate usage with info in imported files:       Generate Reports




Please clear all data, before importing the accounting data of a different printer
    Clear All Data
Column1   Column2
                                                                USAGE SUMMARY (automatically generated)
                     Media:                  0.0           m²                             PERIOD         Media:
  HISTORICAL
                                        0.0                                               TOTAL
 TOTAL USAGE Ink Mono:                                                                                   Ink Mono:
                                                   0.0     ml                             USAGE
                     Ink CMY:           0.0                                                              Ink CMY:

TOTALS BY PRINT CATEGORY
(data from imported jobs)

Print Category Total m²
         A                    0.0
         B                    0.0
         C                    0.0
         D                    0.0
     TOTAL                  0.0

Totals per media

                                                                                                       m²
Print Category                      Bright                 Heavyweight    Super Heavy
                     Plain / Bond              Coated                                     Matte Film        Clear Film
                                    White                    Coated        Plus Matte
       A                     0.00       0.00        0.00           0.00            0.00           0.00             0.00
       B                     0.00       0.00        0.00           0.00            0.00           0.00             0.00
       C                     0.00       0.00        0.00           0.00            0.00           0.00             0.00
       D                     0.00       0.00        0.00           0.00            0.00           0.00             0.00
     TOTAL                   0.00       0.00        0.00           0.00            0.00           0.00             0.00
ARY (automatically generated)
                                                                 From:            To:

                                  0.0                m²
                           0.0
                                        0.0          ml
                           0.0




       m²
                      Natural      Translucent                    Productivity     High-Gloss
                                                      Vellum
                      Tracing         Bond                        Photo Gloss        Photo
                           0.00               0.00        0.00             0.00           0.00
                           0.00               0.00        0.00             0.00           0.00
                           0.00               0.00        0.00             0.00           0.00
                           0.00               0.00        0.00             0.00           0.00
                           0.00               0.00        0.00             0.00           0.00
                                                      USERS SUMMARY                                (automatically generated)




Username:

                                                                                              m²
Ink Coverage
  Category                                                      Heavyweight    Super Heavy
               TOTAL     Plain / Bond Bright White   Coated
                                                                  Coated        Plus Matte
                                                                                              Matte Film

    A             0.00           0.00         0.00       0.00           0.00           0.00          0.00
    B             0.00           0.00         0.00       0.00           0.00           0.00          0.00
    C             0.00           0.00         0.00       0.00           0.00           0.00          0.00
    D             0.00           0.00         0.00       0.00           0.00           0.00          0.00
  TOTAL           0.00           0.00         0.00       0.00           0.00           0.00          0.00
RY    (automatically generated)




 m²

                              Natural     Translucent               Productivity   High-Gloss
               Clear Film                               Vellum
                              Tracing        Bond                   Photo Gloss      Photo

                      0.00         0.00          0.00        0.00           0.00          0.00
                      0.00         0.00          0.00        0.00           0.00          0.00
                      0.00         0.00          0.00        0.00           0.00          0.00
                      0.00         0.00          0.00        0.00           0.00          0.00
                      0.00         0.00          0.00        0.00           0.00          0.00
                                                     ACCOUNTS SUMMARY                                   (automatically generated)




Account ID:

                                                                                               m²
Ink Coverage
  Category                                                       Heavyweight    Super Heavy
               TOTAL     Plain / Bond Bright White    Coated
                                                                   Coated        Plus Matte
                                                                                               Matte Film

    A             0.00           0.00         0.00        0.00           0.00           0.00          0.00
    B             0.00           0.00         0.00        0.00           0.00           0.00          0.00
    C             0.00           0.00         0.00        0.00           0.00           0.00          0.00
    D             0.00           0.00         0.00        0.00           0.00           0.00          0.00
  TOTAL           0.00           0.00         0.00        0.00           0.00           0.00          0.00
ARY   (automatically generated)




 m²

                         Natural         Translucent               Productivity   High-Gloss
          Clear Film                                   Vellum
                         Tracing            Bond                   Photo Gloss      Photo

                 0.00             0.00          0.00        0.00           0.00          0.00
                 0.00             0.00          0.00        0.00           0.00          0.00
                 0.00             0.00          0.00        0.00           0.00          0.00
                 0.00             0.00          0.00        0.00           0.00          0.00
                 0.00             0.00          0.00        0.00           0.00          0.00
Optional - If you want to calculate costs, FILL IN this information before generating the reports:

               Currency:                                          Ink Costs ($/ml)
                                                                  Cyan                     0.39
                                                                                                            Note: If you want to take into account the
                                                                  Magenta                  0.39             approximate cost of printheads spread over time,
                                                                                                            add an extra 20 percent to ink costs.
                                                                  Yellow                   0.39
                                                                  Black                    0.38

               Media Costs ($/m²)
                                                                  Heavyweight       Super Heavy
                Plain / Bond    Bright White      Coated                                            Matte Film     Clear Film
                                                                    Coated           Plus Matte
                         1.00            1.00              1.00              1.00           1.00            1.00           1.00




                                                                             COST RESULTS (automatically generated)
   CATEGORIES INFO
    Print                                        max ink           max ink
             ml /m²               ml /ft²
  Category                                      cost ($/m²)       cost ($/ft²)
      A        0 - 0.5            0 - 0.046         0.00              0.00
      B       0.5 - 2.0         0.046 - 0.185       0.00              0.00
      C       2.0 - 5.0         0.185 - 0.464       0.00              0.00
      D      5.0 - 10.0         0.464 - 0.929       0.00              0.00




Totals per media (real cost: ink + media)

                                                                                                                 Cost($)
    Print
                                                                                    Heavyweight    Super Heavy
  Category       TOTAL          Plain / Bond    Bright White        Coated
                                                                                      Coated        Plus Matte
                                                                                                                   Matte Film

     A                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     B                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     C                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     D                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
   TOTAL                0.00             0.00              0.00              0.00           0.00            0.00           0.00



Totals per media (max based on categories: ink + media)

                                                                                                                 Cost($)
    Print
                                                                                    Heavyweight    Super Heavy
  Category       TOTAL          Plain / Bond    Bright White        Coated
                                                                                      Coated        Plus Matte
                                                                                                                   Matte Film

     A                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     B                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     C                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
     D                  0.00             0.00              0.00              0.00           0.00            0.00           0.00
   TOTAL                0.00             0.00              0.00              0.00           0.00            0.00           0.00
           If you want to take into account the
     approximate cost of printheads spread over time,
     add an extra 20 percent to ink costs.




                             Natural        Translucent                       Productivity    High-Gloss
                                                                 Vellum
                             Tracing           Bond                           Photo Gloss       Photo
                                    1.00                1.00           1.00            1.00            1.00




ULTS (automatically generated)




         Cost($)
                                              Natural          Translucent                    Productivity    High-Gloss
                            Clear Film                                          Vellum
                                              Tracing             Bond                        Photo Gloss       Photo

                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00




         Cost($)
                                              Natural          Translucent                    Productivity    High-Gloss
                            Clear Film                                          Vellum
                                              Tracing             Bond                        Photo Gloss       Photo

                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
                                    0.00                0.00           0.00            0.00            0.00          0.00
              DETAILS BY USER   (automatically generated)




                                                                       INK INFO     MEDIA INFO
 Account ID         UUID                               Job Name                                       Pages Copies
                                                                  Category    µl   Name          m²

User name:
                       (seconds)
 Print                 Printing                  Printing
          Job Status               Timestamp                Source   Cost($)
Quality                 Time                   Timestamp
              DETAILS BY ACCOUNT   (automatically generated)




  User name           UUID                           Job Name


Account ID:
                                                                        (seconds)
     INK INFO       MEDIA INFO                    Print                  Printing
                                  Pages Copies             Job Status
Category     µl   Name       m²                  Quality                  Time
              Printing
Timestamp                Source   Cost($)
            Timestamp
                 DETAILS BY CATEGORY   (automatically generated)




            Account
User name                  UUID
              ID

Category:
ATEGORY   (automatically generated)




                                                     MEDIA INFO
                               Job Name   Ink µl                   Pages   Copies
                                                   Name       m²
                       (seconds)
 Print                 Printing
          Job Status               Timestamp   Printing Timestamp   Source   Cost($)
Quality                 Time
  MEDIA


Name      Language   Country   Localized Name
Plain     en         US        Plain Paper
Plain     fr         FR        Papier ordinaire
Plain     it         IT        Carta comune
Plain     de         DE        Normales Papier
Plain     es         ES        Papel normal
Plain     pt         PT        Papel Comum
Plain     ja         JP        普通紙
Plain     ko         KR        일반 용지
Plain     zh         CN        普通纸
Plain     zh         TW        普通紙
Plain2    en         US        Max Speed Plain Paper
Plain2    fr         FR        Papier ordinaire vit. max
Plain2    it         IT        Carta comune veloc. max.
Plain2    de         DE        Max. Geschw., Norm. Pap.
Plain2    es         ES        Papel normal de veloc. max
Plain2    pt         PT        Papel Comum Veloc. max
Plain2    ja         JP        普通紙(最高速)
Plain2    ko         KR        최고 속도 일반 용지
Plain2    zh         CN        高速普通纸
Plain2    zh         TW        最高速度普通紙
Bond      en         US        Bond Paper
Bond      fr         FR        Papier
Bond      it         IT        Carta da stampa
Bond      de         DE        Postpapier
Bond      es         ES        Papel bond
Bond      pt         PT        Papel Bond
Bond      ja         JP        ボンド紙
Bond      ko         KR        본드지
Bond      zh         CN        证券纸
Bond      zh         TW        合約紙
Bond2     en         US        Max Speed Bond Paper
Bond2     fr         FR        Papier vitesse max
Bond2     it         IT        Carta stampa veloc. max.
Bond2     de         DE        Max. Geschw., Postpapier
Bond2     es         ES        Papel bond de veloc. max
Bond2     pt         PT        Papel Bond Veloc. max
Bond2     ja         JP        ボンド紙(最高速)
Bond2     ko         KR        최고 속도 본드지
Bond2     zh         CN        高速证券纸
Bond2     zh         TW        最高速合約紙
Midas     en         US        Bright White
Midas     fr         FR        Blanc brillant
Midas     it         IT        Bianco brillante
Midas     de         DE        Hochweiß
Midas     es         ES        Blanco brillante
Midas     pt         PT        Bright White
Midas     ja         JP        インクジェット普通紙
Midas     ko         KR        순백색 잉크젯 전용지
Midas     zh         CN        亮白纸
Midas     zh         TW        超白紙
Midas2       en   US   Max Speed Bright White
Midas2       fr   FR   Blanc brillt vitesse max
Midas2       it   IT   Bianco brill. veloc. max
Midas2       de   DE   Max. Geschwind., hochweiß
Midas2       es   ES   Bco. bri. de veloc. max
Midas2       pt   PT   Bright White Veloc. max
Midas2       ja   JP   インクジェット普通紙(最高速)
Midas2       ko   KR   최고 속도 순백색 용지
Midas2       zh   CN   高速亮白纸
Midas2       zh   TW   最高速超白紙
Coated       en   US   Coated Paper
Coated       fr   FR   Papier couché
Coated       it   IT   Carta patinata
Coated       de   DE   Gestrichenes Papier
Coated       es   ES   Papel recubierto
Coated       pt   PT   Papel Revestido
Coated       ja   JP   コート紙
Coated       ko   KR   코팅지
Coated       zh   CN   涂料纸
Coated       zh   TW   塗層紙
HWCoated     en   US   Heavyweight Coated Paper
HWCoated     fr   FR   Pap couché à fort gram
HWCoated     it   IT   Carta patinata pesante
HWCoated     de   DE   Gestr. Papier, schwer
HWCoated     es   ES   Papel rec. alto gramaje
HWCoated     pt   PT   Papel Revestido Pesado
HWCoated     ja   JP   厚手コート紙
HWCoated     ko   KR   중코팅지
HWCoated     zh   CN   重磅涂料纸
HWCoated     zh   TW   重磅塗層紙
SHWCoated    en   US   Super Heavy Plus Matte
SHWCoated    fr   FR   Tr. fort gr. Plus
SHWCoated    it   IT   Super_Pesante_Plus
SHWCoated    de   DE   Extra-Schwer_Plus
SHWCoated    es   ES   Gram_Extra_Plus
SHWCoated    pt   PT   Superpesado Plus
SHWCoated    ja   JP   プラス スーパーアツデ
SHWCoated    ko   KR   수퍼 중코팅지
SHWCoated    zh   CN   优质重磅涂料纸
SHWCoated    zh   TW   超重磅塗層紙
Matte_Film   en   US   Matte Film
Matte_Film   fr   FR   Film polyest trans mat
Matte_Film   it   IT   Pellicola opaca
Matte_Film   de   DE   Transparentfolie, matt
Matte_Film   es   ES   Transparencia mate
Matte_Film   pt   PT   Filme Opaco
Matte_Film   ja   JP   マットフィルム
Matte_Film   ko   KR   무광택 필름
Matte_Film   zh   CN   磨砂胶片
Matte_Film   zh   TW   霧面膠片
Clear_Film   en   US   Clear Film
Clear_Film   fr   FR   Film polyester transp
Clear_Film   it   IT   Pellicola trasparente
Clear_Film   de   DE   Klare Transparentfolie
Clear_Film   es   ES   Transparencia
Clear_Film   pt   PT   Filme Transparente
Clear_Film    ja   JP   クリアフィルム
Clear_Film    ko   KR   투명 필름
Clear_Film    zh   CN   透明胶片
Clear_Film    zh   TW   透明膠片
              en
Natural_Tracing    US   Natural Tracing Paper
              fr
Natural_Tracing    FR   Papier calque naturel
              it
Natural_Tracing    IT   Traslucido extra
              de
Natural_Tracing    DE   Pauspapier, transparent
              es
Natural_Tracing    ES   Papel Vegetal
              pt
Natural_Tracing    PT   Papel Vegetal
Natural_Tracing
              ja   JP   トレーシングペーパ
Natural_Tracing
              ko   KR   천연 트레이싱지
Natural_Tracing
              zh   CN   本色描图纸
Natural_Tracing
              zh   TW   天然描圖紙
Translucent   en   US   Translucent Bond
Translucent   fr   FR   Papier calque
Translucent   it   IT   Traslucido
Translucent   de   DE   Transparentpapier, weiß
Translucent   es   ES   Papel Translúcido
Translucent   pt   PT   Translúcido Comum
Translucent   ja   JP   半透明ボンド紙
Translucent   ko   KR   반투명 본드지
Translucent   zh   CN   半透明证券纸
Translucent   zh   TW   半透明合約紙
Vellum        en   US   Vellum
Vellum        fr   FR   Papier vélin
Vellum        it   IT   Pergamena
Vellum        de   DE   Velinpapier
Vellum        es   ES   Papel tipo pergamino
Vellum        pt   PT   Vellum
Vellum        ja   JP   ベラム紙
Vellum        ko   KR   모조피지
Vellum        zh   CN   羊皮纸
Vellum        zh   TW   羊皮紙
Gasela        en   US   Productivity Photo Gloss
Gasela        fr   FR   Pap photo glacé produc
Gasela        it   IT   Fotogr. lucida per prod.
Gasela        de   DE   Spezial-Fotopap., glnz.
Gasela        es   ES   Papel foto. brill. prod.
Gasela        pt   PT   Papel Foto Brilh. Prod.
Gasela        ja   JP   光沢フォト用紙2
Gasela        ko   KR   특수광택인화지
Gasela        zh   CN   高效光泽相纸
Gasela        zh   TW   生產力光面相紙
BasicGloss    en   US   High-Gloss Photo Paper
BasicGloss    fr   FR   Papier photo glacé
BasicGloss    it   IT   Fotogr. extra-lucida
BasicGloss    de   DE   Fotopapier, hochglänzend
BasicGloss    es   ES   Papel foto. brillante
BasicGloss    pt   PT   Papel Foto Alto-Brilho
BasicGloss    ja   JP   光沢フォト用紙
BasicGloss    ko   KR   고광택 인화지
BasicGloss    zh   CN   高光相纸
BasicGloss    zh   TW   高光面相紙
    Media usage
Media name    sqm
        Ink usage
color               µl
    1           2         3                                4           5       6     7      8
  LOG                           Last IP: 16.23.86.196              0-A, 1-B
                                                                   2-C, 3-D
                                                                          INK INFO        MEDIA INFO

User name   Account ID   UUID                           Job Name   Category Color    µl   Name
      9    10     11        12          13           14            15           16         17        18     19            20
                       1-Fast                                                            1-Driver
                       2-Normal                                                          3-Scanner
IA INFO                3-Best                  (seconds x 10)                                                PRINTER CONFIGURATION
                                                                              Printing          Product    Serial
     sqi Pages Copies Print Quality Job Status Printing Time    Timestamp                Source                       Product Name
                                                                            Timestamp           Number    Number
         21       22   23   24   25   26



ON

     FW Version

								
To top