=SUM(H16+H27+H39)/3
You can view the formula for each cell in
Excel.
Duane
From:
caf-forum-bounces@xxxxxxxxxxxxxx [mailto:caf-forum-bounces@xxxxxxxxxxxxxx] On Behalf Of Mabry, Roy, Mr, OSD-NII
Sent: Monday, January 09, 2006
10:06 AM
To: 'Chief Architects Forum'
Subject: RE: [caf-forum] Excel
Spreadsheet of OMB EA Assessment Framework Version 2.0 (U)
UNCLASSIFIED
Ira,
Do you
know how the math works in the Spreadsheet to calculate the composite
score? Are there weights assigned to each section? Is each section
averaged and then those averages averaged again to get the composite
score. Any advice you can give will be helpful. Vr, Roy
-----Original
Message-----
From:
caf-forum-bounces@xxxxxxxxxxxxxx [mailto:caf-forum-bounces@xxxxxxxxxxxxxx]
On Behalf Of Ira M. Grossman
Sent: Friday, December 23, 2005
12:37 PM
To: Chief Architects Forum; Chief
Architects Forum
Cc: KENT.CRAIG; Jeff Baer
Subject: [caf-forum] Excel
Spreadsheet of OMB EA Assessment Framework Version 2.0
The
attached Excel Spreadsheet/Template was created by the U. S. Patent and
Trademark Office for use by the Department of Commerce and PTO. I am
forwarding the file in the event other Departments and Agencies wish to use it
to complete their own EA Assessment for OMB's FEAPMO.
Happy
Holidays,
Ira
Grossman
Chair Chief Architects Forum
--
Ira M. Grossman
NOAA OCIO
Chief Enterprise IT Architect
1315 East West Highway (CIO-PPA1)
SSMC3 Room 9752
Silver Spring MD 20910
ph 301 713 3345 ext 140
cell 301 266 0157
fax 301 713 3554
ira.m.grossman@xxxxxxxx