[Navigation]

Statistics and Search

  • Old Statistics program - General Statistics
  • Search - Quick database scan - numbers
  • Registered - How Clients have found out about you
  • Generic Scan - Report on a period
  • New - Graphs showing number of new animals/Clients.
  • FDI - Fort Dodge Marketing
  • Waiting Room - Report on Waiting Times
  • Assemble chapter for printing

    If you are looking for a specific report have a look at the
    full list of ALL Client/Animal Based Reports.

    Old Statistics program

    This will scan all the management (and optionally clinical) records and generate some statistics on your database.

    When you run the statistics program Premvet 5 will prompt you:

    Scan clinical records <Y/N> [Y]

    If you answer 'Y'es to this question the report will take longer to run. This is because the system is scanning additional data about the usage of clinical records.

    The report will be printed and contains the following information:

    Overall Summary (Page 1)

                     
                         Total    Small     Farm  Equine

Total animals            10788    10788
%Breakdown                 100      100
Dead animals              1576     1576
No Clinical records        579      579
Master records            2146     2146
Related records           3759     3759
Blank records              138
No. of transactions      45947    45947
Total income            728880   728880
Ave. per transaction     15.86    15.86
Lines per transaction     4.32     4.32
    This first page is the overall summary breaking the information down into the three client types. In the examples shown in this chapter the practice concerned is a 100% small animal practice.

    Total animals
    The total number of management records for the client types, with a percentage breakdown.

    Dead animals
    The number of record cards with 'DD' in the status field.

    No clinical records
    The number of record cards that do not have any clinical records at all.

    Master records
    The number of record cards that are set-up as 'Master' cards (i.e. clients with multiple animals). The figure for related cards is also given.

    Blank records
    These are record cards with no client name.

    If you asked the system to scan clinical records, the following information will also be included on this page:

    No. of transactions
    This is the number of transaction lines used by each client type.

    Total income
    The total income broken down by client type.

    Ave. per transaction
    This is the average income generated per visit per client type.

    Note: A visit is defined as all the work done until the date changes (i.e. any work completed in one day).

    Lines per transaction
    Similar to the above option, except this counts the number of transaction lines used per visit/consultation.

    Small animal records by species (Page 2)

    The next page breaks down the small animal records by species, and presents the information in order; with the largest species group first in the list. Up to 40 species are catered for. 
    Species     Total   %    Dead Actual  Av Age  Av Age Av Weight  
                                     (yr:mo)   Dead   (Kgs)

CANINE       5775   54   773   5002    5:11    8:7   21.87   
FELINE       3898   36   559   3339    5:5     7:8    6.47   
LAGOMORPH     366    3    94    272    2:10    4:0     .00   
RODENTS       256    2    64    192    2:5     3:0     .32  
etc.	     etc.    .....................................
    A 'Fees' column will be included if the clinical records are scanned.

    Canine records by breed (Page 3)

    The next page contains a breakdown of canine records by breed. Like the species, the breed will be given in order with the largest group first. Up to 100 breeds are catered for. 
    Breed        Total   %  Dead Actual  Av Age Av Age Av Weight  
                                     (yr:mo)  Dead  (Kgs)

             2023    35   289   1737    5:10   6:11   20.37   
X- BREED     1112    19   159    956    6:2     8:9   19.99   
LABRADOR      561    10    65    496    6:4     7:0   31.52   
GSD           459     8    72    387    4:2     5:2   34.72
etc.	      etc.    .....................................
    The report is similar to the species report given above. You should note the first entry will often contain a blank. These are records where no breed has been entered.

    Feline records by breed (Page 4)

    An identical report for feline breeds.

    Records by breed (Page 5)

    A single report covering all of the other breeds identified.

    Sex field, small and equine clients (Page 6)

    The next report covers a breakdown of the sex field for both small and equine clients breaking down small animal records by canine and feline e.g. 
    Sex      Total   Canine   Feline  Others  Equine

MN       2007      385      1612     10
M        3279     2501       310    468
F        2425     1854       290    281
etc.	 etc.    ...............................

    Breakdown by income (if clinical records scanned)

    If the clinical records were scanned an additional report will be printed giving a breakdown by income. This is the average amount spent by sex e.g. 
    Sex     Total   Canine  Feline  Others  Equine

MN      66.98   112.49    51.91   694.83
M       61.06    72.66    35.61    13.65
F       60.89    72.12    33.33    11.68
etc.	 etc.    .............................

    Farm and Equine clients

    If any farm records were processed an additional report is printed giving a breakdown by herd type. If any equine clients were processed a report similar to the Canine breakdown is printed; i.e., equine records by breed.

    Management records by month and year

    Once these reports have been printed you will get a breakdown by month and year of the management records added.

    Note: The system will determine when a record was added to the system by looking at the date of the first clinical record. 

    Date       Total      SA    FC

12.89      807      807
01.90      716      716
02.90      516      516
03.90      548      548
etc.	   etc.     etc.

    Clinical records by month and year

    If you asked the program to scan clinical records you will get an additional report similar to the management records, this time based on the clinical records. An additional column will be included to show the total income received that month.

    Usage/averages

    The final page printed will make some rough calculations to determine disk usage and number of records added per month.

    Search for ..

    (Via General Apps -> Statistics)

    This routine is a 'front end' to the Unix grep command. It uses a snap-shot of the database to perform very fast search's and counts of MANAGEMENT data. For example to search 25,000 animal cards for the number of dogs on file takes just over 1 second. This utility is aimed at the 'How many xyz do we have' type questions.

    When selected for the 1st time the system will create the snap-shot of the database and may take a few mins. This snap-shot can be regenerated at will by the menu option Rebuild Search File.

    You will be prompted for text to search for, this can handle regular expressions and a separate guide is available on that. Generally you will type in the text you want and press Return. You will be asked if there is any text to ignore e.g. 

    Search for :   canine
Ignore:        london
    This will search for all 'CANINE' that do NOT have 'LONDON' on the record. The ignore option can be left blank.

    The final option is:

    Summary
    Just a count of the records found
    Records
    List the actual records found. Output can be to the screen, the printer or a file. If the file option is used the resulting file will be in /usr/tmp. The screen will show you the full location.

    Run a Search Routine

    (Via General Apps -> Statistics)

    This routine is for the advanced users, the search routine uses a colon (:) separated ascii text file with all the client information in it. The basic 'Search for..' routine handles the basic queries however with the tools supplied with Unix you can manipulate text very easily - this is where this option comes in.

    You would create (in the script sub-directory a Unix shell script that can use any of the text tools, mawk, grep, wc etc. and then this could be run via this routine

    Make sure the suffix of the script is 'grep' and the system will list all the available script files for you allowing to to select as required.

    What the script does is left to your imagination.

    The name of the text file you will generally process is $VETSYS/ascifile.

    Top Classic New-Style Chapters Sections Index Search