SPECIAL NOTICE
70 -- Request For Information
- Notice Date
- 7/12/2004
- Notice Type
- Special Notice
- NAICS
- 541519
— Other Computer Related Services
- Contracting Office
- Department of the Treasury, Comptroller of the Currency (OCC), Acquisition Management (AQM), 250 E Street, SW Mail Stop 4-13, Washington, DC, 20219
- ZIP Code
- 20219
- Solicitation Number
- Reference-Number-RFI-FINDRS
- Response Due
- 7/29/2004
- Archive Date
- 8/13/2004
- Point of Contact
- Brett Blake, Contract Specialist, Phone 202-874-5541, Fax 202-874-5625, - Brett Blake, Contract Specialist, Phone 202-874-5541, Fax 202-874-5625,
- E-Mail Address
-
brett.blake@occ.treas.gov, brett.blake@occ.treas.gov
- Description
- REQUEST FOR INFORMATION (RFI) The OCC?s Bank Supervision Systems division is looking for Commercial Off-The-Shelf (COTS) software to enhance the capability to meet the formatting requirements of the Financial Institution Data Retrieval System (FINDRS). FINDRS is a web-based reporting application that provides the customer with ad-hoc reports in excel format. Formatting is limited because Excel is not permitted to be run on the IIS server but only on the customer?s desktop. The Microsoft Jet software is currently used to assist in creating the excel report display. OCC would like to test, for demonstration purposes only, any software that meets or exceeds this request for a period of no longer than 60 days and no less than 30 days. OCC Environment: For the FINDRS application the OCC production environment consists of 2 IIS servers (3 cpu?s per IIS server), 1 development IIS server (1 cpu ), 1 maintenance IIS server (1 cpu), 1 preview IIS server (1 cpu) and 1 staging IIS server (1 cpu). Information Sought / Technical Capability: Ad Hoc Reports FINDRS users design these reports on the fly, so we can?t format each report individually because we don?t know what they will contain. But we do want certain formatting to be applied to all ad hoc reports. 1. Formatting for all ad hoc reports (necessary): Font style = Arial, Font size = 8, Numbers displayed using the 1000 Separator (,), Numbers with decimals displayed as 2 decimals, Font style bold for column headers, Cell shading for column headers, Bottom border for column headers, Wrap Text for Column Headers, AutoFit column width to contents, Right Align Column headers for columns that contain numbers and Left Align column headers for columns that contain text. 2. Other Function: Freeze panes. 3. Summary functions for ad hoc reports: Be able to specify columns to summarize and specify the method used to summarize, e.g., SUM, AVERAGE, MEDIAN, TRIMMEAN, COUNT NUMS, MINIMUM, AND MAXIMUM. Also specify whether they want the summary on separate worksheet and/or at the end of the data in the column. Canned Reports FINDRS system administrator designs these reports that any user can run. The system administrator could prepare a sample or a template for each report. 1.Special formatting desired for canned report - Formatting listed above under ad hoc reports plus ability to: Individually format columns in the report (including setting currency formats with 0 decimals, setting number formats with specific decimal places, etc.), Freeze panes at a specific location and Do page setup for printing (including orientation, header, footer, rows to repeat at top and columns to repeat at left, etc.) 2. Functions desired for canned reports (Summary functions listed above for ad hoc reports plus the ability to summarize data using excel pivot table reports and the excel subtotal function. Would also like the ability to include macros and calculations in the spreadsheet). Q-CALC Report 1. Formatting functions needed for the Q-CALC Report: A Q-CALC report would require the ability to perform mathematical functions such as addition, subtraction, multiplication and division. In addition, it would need to utilize the IF function. Listed below are the formatting requirements needed to present the report in a format similar to the current report layout. NUMERIC FORMATTING TEXT, GENERAL, NUMBER, CURRENCY, DATE, PERCENTAGE, FRACTION STYLISTIC FORMATTING FREEZE PANES, FONT, FONT TYPE, FONT STYLE , FONT SIZE, FONT COLOR, CELL HEIGHT AND WIDTH, ROW HEIGHT, COLUMN WIDTH, ALIGNMENT-HORIZONTAL (GENERAL, LEFT, CENTER, RIGHT, FILL, JUSTIFY, CENTER ACROSS SELECTION), VERTICAL (TOP, CENTER, BOTTOM, JUSTIFY), TEXT CONTROL (WRAP TEXT), ORIENTATION, BORDER, BORDER OUTLINE (NONE, OUTLINE), BORDER LINE STYLE, BORDER LINE COLOR, CELL SHADING COLOR, CELL BACKGROUND PATTERN, HORIZONTAL PAGE BREAK, PROTECTION and LOCKED. Responses are welcome via e-mail or fax. Email: brett.blake@occ.treas.gov fax (202) 874-5625
- Place of Performance
- Address: 250 E Street, SW, Mail Stop 4-13, Washington, DC
- Zip Code: 20219
- Country: USA
- Zip Code: 20219
- Record
- SN00619382-W 20040714/040712212555 (fbodaily.com)
- Source
-
FedBizOpps.gov Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |