Over the last several years our office has developed an Excel-based
collection of 344 FAR/DFAR/NFS clauses that have appeared one time or
another in our federal contracts. In addition to the basic
information about each clause, we also have a column indicating to
accept, reject or negotiate the clause.

When we receive a federal contract, we do a “Save As,” renaming the
spreadsheet for the particular contract, and then mark which clauses
are present in the contract. If we find a new clause not on the
spreadsheet, we add the requisite information. Then a sort on clauses
present in the contract and then another on the “Accept/Reject”
column produces a quick way of identifying the problematic clauses as
well as the start of a paper trail for future negotiations with the
agency. The flow-down column also tells us which clauses to flow down
in case there are to be any subcontracts.

We’ve recently updated the speadsheet with changes as of March 31,
2008. It’s available from our Web site at: http://www.ucsc.edu/osp/
ucsc_FAR_DFAR_NFS_03_31_08.xls This should take you directly to the
spreadsheet. If it doesn't, you can go to our Web page at: http://
www.ucsc.edu/osp/ and it is on the right-hand side, "Far Clauses."

The guidance is from the point of view of the University of
California but please feel free to use it and modify it to suit your
own purposes if you find it useful.

Let me know if you have any comments or questions. Thanks, Bill

PS No, we don’t have any plans on adding other federal agencies’
acquisition regulations at this time.

William F. Clark
Director
Office of Sponsored Projects
Kerr 463 (MS OSP)
University of California, Santa Cruz
1156 High Street
Santa Cruz, CA 95064

(831) 459-5278 (voice)
(831) 459-4989 (fax)
xxxxxx@ucsc.edu

======================================================================
 Instructions on how to use the RESADM-L Mailing List, including
 subscription information and a web-searchable archive, are available
 via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================