ELECTRONIC FILING SPECIFICATIONS.doc

ELECTRONIC FILING SPECIFICATIONS
TWO (2) FORMATS REQUIRED

I. WORKING FILE FORMAT FOR IPUC INTERNAL USE ONLY
All spreadsheet files should be submitted in MICROSOFT EXCEL 97 format. Text files and scanned/photocopied material should be submitted in Adobe PDF format. If files are compressed or “Zipped”, a self extracting unzip file should be included on the disks. Submission on either 3.5” floppy disks or CD is acceptable. Submission as attachments to e-mail ([e-mail]) is also acceptable.

IMPORTANT:
If any spreadsheet files are LINKED to other files, the links must be updated to the file names specified here to maintain the integrity of the file links.

ORGANIZATION OF FILES:
1. Create a Directory named: Company (or intervenor name)

2. Place an Adobe electronic file version of the formal Application or submission within the directory.
File name: Application.pdf

Prepare a short summary in Adobe PDF format that briefly describes the testimony and exhibits of each witness indicating the subject matter addressed, conclusions and recommendations.
File Name : Witness Summary

Create three (3) subdirectories named: Exhibits, Testimony & Workpapers

5. Place worksheets and Adobe PDF files that are electronic versions of numbered exhibits in the “Exhibits” Sub-Directory. File names should be the Exhibit Number followed by the witness’s name
EXAMPLE: Ex 1 Jones
If multiple exhibits are included in one file show the range of exhibit numbers.
EXAMPLE: Ex 1 to 5 Jones

6. Place testimony Adobe format files in the “testimony” Sub-Directory. File names should be the names of the witnesses.
Example: Jones testimony

7. Create Sub-Directories under the “Workpapers” Sub-Directory for each witness. Use the witness’s name for the name of the Sub-Directory Place all work paper files that are not an integral part of an exhibit file in the appropriate witness’s subdirectory. File names should be indicative of the data contained.

The Final Directory Tree should look like the sample shown at the end of these instructions.

TEST ALL WORKSHEET FILES TO VARIFY THE INTEGRITY OF LINKS!!!!

PROTECTION OF PROPRIETARY DATA :
Sensitive proprietary data that has been filed under seal with the Commission SHOULD BE INCLUDED with the electronic filing. Such data should be hidden and protected with a password to limit access. If the proprietary data is included within a file containing data that is not considered proprietary, ONLY the proprietary data should be hidden and protected by a password. The access password will only be provided to individuals who have executed a proprietary agreement with the filing party. This data WILL NOT be posted on the Commission’s Internet Home Page.

II. PUBLIC FORMAT FOR POSTING ON COMMISSION HOME PAGE

On a separate set of Disks or e-mail attachment, submit the following data suitable for posting on the IPUC Internet Homepage. All data should be converted to Adobe PDF format. Work papers are not necessary. Adobe versions of electronic spreadsheet files (Excel, Lotus 123, Quatro Pro) should be formatted for ease of viewing in Adobe format from the Commissions Internet Homepage. If files are compressed or “Zipped”, a self extracting unzip file should be included on the disks.

DIRECTORY STRUCTURE FOR IPUC INTERNAL USE:
The final directory structures should look like the following:

Company (or intervenor name) (Directory)
Application (Adobe file)
Witness Summary (Adobe file)
Exhibits (subdirectory)
Ex 1 Jones (file)
Ex 2 Jones (file)
Ex 3 to 9 Smith (file)
Testimony (subdirectory)
Testimony Jones (Adobe file)
Testimony Smith (Adobe file)
Workpapers (subdirectory)
Jones
File A
File B
Smith
File A
File B
File C

ORGANIZATION OF ADOBE FILES FOR POSTING ON IPUC HOME PAGE
No directory structure is required for this filing. Convert all files (except workpapers) discussed above for the IPUC internal working files to Adobe format. File names should be as discussed above. Worksheet files should be purged of any extraneous data so that only the exhibits are displayed. Per the names used in the directory above, the files should appear as follows:
Application.pdf
Witness summary.pdf
Testimony Jones.pdf
Testimony Smith.pdf
Ex 1 Jones.pdf
Ex 2 Jones.pdf
Ex 3 to 9 Smith.pdf