Instructions for NASA Mentor-Protégé Program Semiannual Report,

This text offers guidance to users of assistive technology concerning placement of text and active fields for the Excel form: NASA Mentor-Protégé Program Semiannual Report,

Cells are specified by the row identifier number (side, 1, 2, 3, etc.); and the alphabetical label heading cell (top, A through AB), ranges are provided for merged fields,
If clarification or assistance is needed in preparing this report, please contact the NASA Office of Small Business Programs at 202-358-2088, or send an email to smallbusiness@nasa.gov,

Row 2, B through X, Tile, NASA Mentor-Protégé Program Semiannual Report, NASA insignia displayed to side,

Row 5, B through AB, section heading heading: Instructions,

B through AB, rows through 9: instruction text, in instruction per row, as follows,

Row 6, B through AB, Instruction 1, Reporting requirements: Reports are due for all active agreements. The Mentor and Protégé are required by the NASA FAR,
Row 7, B through AB, Instruction 2, Activity reported should be all and only the activity that occurred during the 6-month semiannual report period idicated below (unless specified otherwise),
Row 8, B through AB, Instruction 3, Reports are due not later than 30 days following the end of each semiannual reporting period,
Row 9, B through AB, Instruction 4, Initial Report Only: The first day of the initial report period is the first day of the month following the month in which the agreement started (date of contract modification),
B through L, Row 11, field label, Is This the Initial Report Under This Agreement?,
M through O, Row 11, empty cell field to be filled in (yes or no), to immediate right, pull down tab for yes or no, yes or no option provided M through O, Row 12,
Q through X, Rows 11 and 12, field label, If No, What Was the Last Day of the Previous Report Period,
Y through AA, Row 11, fill in field for Last Day,
D through L, Row 14, field label, First Day of This Report Period, additional instruction,
B through O, Row 15, (Always the 1st day of a month - if initial report, see instruction 4 above),
M through O, Row 14, fill-in field for First Day,
Q through X, Row 14, field label, Last Day of This Report Period, additional instruction,
Q through AB, Row 15, (End of this semiannual report period, always last day of a month),
Y through AA, Row 14, fill-in field for Last Day,

B through AB, Row 17, Section head, General Information,
B through H, Row 19, field label, Agreement Contract Number,
I through T, Row 19, fill-in field for Agreement Contract Number,
B through H, Row 21, field label, Type of Agreement, Credit or Award Fee Pilot Program, to immediate right, pull down tab for Credit or Award Fee Pilot Program,
I through O, Row 21, fill-in field for Type of Agreement,
C through K, Row 23, Section head, Agreement Period of Performance,
C through F, Row 24, Start Date,
G through K, Row 24, fill-in field for Start Date,
C through F, Row 25, End Date,
G through K, Row 25, fill-in field for End Date,
M through AA, Row 23, Section head, NASA Sponsoring Center,
M through AA, Row 24, fill-in field for NASA Sponsoring Center,

B through AB, Row 27, Section head, Mentor POC Information,
B through E: Row 28, Name,
F through AB, Row 28, fill-in field for Name,
B through E, Row 29, Title,
F through AB, Row 29, fill-in field for Title,
B through E, Row 30, Street Address 1,
F through AB, Row 30, fill-in field for Street Address 1,
B through E, Row 31, Street Address 2,
F through AB, Row 31, fill-in field for Street Address 2,
B through E, Row 32, City,
F through L Row 32, fill-in field for City,
M through N, Row 32, State,
O through U, Row 32, fill-in field for State,
V through W, Row 32, Zip,
X through AB, Row 32, fill-in field for Zip,
B through E, Row 33, Phone,
F through L, Row 33, fill-in field for Phone,
M through N, Row 33, Fax,
O through U, Row 33, fill-in field for Fax,
B through E, Row 34, E-mail,
F through U, Row 34, fill-in field for E-mail,


B through AB, Row 36, Section head, Protégé POC Information,
B through E: Row 37, Name,
F through AB, Row 37, fill-in field for Name,
B through E, Row 38, Title,
F through AB, Row 38, fill-in field for Title,
B through E, Row 39, Street Address 1,
F through AB, Row 39, fill-in field for Street Address 1,
B through E, Row 40, Street Address 2,
F through AB, Row 40, fill-in field for Street Address 2,
B through E, Row 41, City,
F through L, Row 41, fill-in field for City,
M through N, Row 41, State,
O through U, Row 41, fill-in field for State,
V through W, Row 41, Zip,
X through AB, Row 41, fill-in field for Zip,
B through E, Row 42, Phone,
F through L, Row 42, fill-in field for Phone,
M through N, Row 42, Fax,
O through U, Row 42, fill-in field for Fax,
B through E, Row 43, E-mail,
F through U, Row 43, fill-in field for E-mail,


B through AB, Row 45, Section head, NASA Procurement Contracting Officer,
B through E: Row 46, Name,
F through AB, Row 46, fill-in field for Name,
B through E, Row 47, Title,
F through AB, Row 47, fill-in field for Title,
B through E, Row 48, Street Address 1,
F through AB, Row 48, fill-in field for Street Address 1,
B through E, Row 49, Street Address 2,
F through AB, Row 49, fill-in field for Street Address 2,
B through E, Row 50, City,
F through L Row 50, fill-in field for City,
M through N, Row 50, State,
O through U, Row 50 fill-in field for State,
V through W, Row 50, Zip,
X through AB, Row 50, fill-in field for Zip,
B through E, Row 51, Phone,
F through L, Row 51, fill-in field for Phone,
M through N, Row 51, Fax,
O through U, Row 51, fill-in field for Fax,
B through E, Row 52, E-mail,
F through U, Row 52, fill-in field for E-mail,


B through AB, Row 54, Section head, NASA Cotar,
B through E: Row 55, Name,
F through AB, Row 55, fill-in field for Name,
B through E, Row 56, Title,
F through AB, Row 56, fill-in field for Title,
B through E, Row 57, Street Address 1,
F through AB, Row 57, fill-in field for Street Address 1,
B through E, Row 58, Street Address 2,
F through AB, Row 58, fill-in field for Street Address 2,
B through E, Row 59, City,
F through L Row 59, fill-in field for City,
M through N, Row 59, State,
O through U, Row 59, fill-in field for State,
V through W, Row 59, Zip,
X through AB, Row 59, fill-in field for Zip,
B through E, Row 60, Phone,
F through L, Row 60, fill-in field for Phone,
M through N, Row 60, Fax,
O through U, Row 60, fill-in field for Fax,
B through E, Row 61, E-mail,
F through U, Row 61, fill-in field for E-mail,


B through AB, Row 63, Section head, NASA Small Business Specialist,
B through E: Row 64, Name,
F through AB, Row 64, fill-in field for Name,
B through E, Row 65, Title,
F through AB, Row 65, fill-in field for Title,
B through E, Row 66, Street Address 1,
F through AB, Row 66, fill-in field for Street Address 1,
B through E, Row 67, Street Address 2,
F through AB, Row 67, fill-in field for Street Address 2,
B through E, Row 68, City,
F through L Row 68, fill-in field for City,
M through N, Row 68, State,
O through U, Row 68, fill-in field for State,
V through W, Row 68, Zip,
X through AB, Row 68,  fill-in field for Zip,
B through E, Row 69, Phone,
F through L, Row 69, fill-in field for Phone,
M through N, Row 69,  Fax,
O through U, Row 69, fill-in field for Fax,
B through E, Row 70, E-mail,
F through U, Row 70, fill-in field for E-mail,

B through AB, Row 72, Section head, Developmental Task Budget and Variances,

This is a calculating worksheet,

Rows identified as list items 1 through 25 (in the B cell) are provided for Developmental Tasks (that are entered by reporter into cells with range C through J for each row) followed left to right by fields for,

Performed By (i.e, Mentor, HBCU, etc.), located in range K through M; Total Dollars Budgeted for Task (Base), (N through P); Planned Percent Complete as of This Report Period (Base), (Q through S), Dollars Used Based on Percent Completed (Base) (T through V), Actual Dollars Expended as of End of This Report Period (W through Y), and Variance (As of End of This Report Period) (Z through AB),

As the reporter enters a value into each Total Dollars Budgeted field, that value is added to the cumulative corresponding Totals cell field for Total Dollars Budgeted for Task (N through P, spreadsheet Row 100);,

As the reporter enters a value into the next row cell for Planned Percent Complete as of This Report Period (Base) (Q through S), the spreadsheet calculates and provides a corresponding value for Dollars used Based on Percent Completed (T through V); that calculated value is added to the cumulative corresponding Totals cell field for Dollars Used Based on Percent Completed (T through V, spreadsheet row 100);,

As the reporter enters a value for Planned Percent Complete as of This Report Period (Base) (Q through S), the spreadsheet also calculates and provides a preliminary corresponding value for Variance (As of end of This Report) (Z through AB); that calculated value is added to the cumulative corresponding Totals cell field for Variance (Z through AB, spreadsheet row 100);,

As the reporter enters a value for Actual Dollars Expended as of End of this Report Period (W through Y) that value is added to the cumulative Totals cell field for Actual Dollars Expended as of End of Report Period (W through Y, spreadsheet row 100),

As the reporter enters a value for Actual Dollars Expended as of End of this Report Period (W through Y) the spreadsheet also calculates a final value for Variance (As of End of this Report Period) (Z through AB); that value is added to the cumulative Totals cell field for for Variance (As of End of this Report Period) (Z through AB, spreadsheet row 100),

Summary of application worksheet locations for Developmental Task Budget and Variances,
B through AB, Row 72, Title, Developmental Task Budget and Variances,
B through J, Merged Rows 73 and 74, Developmental Tasks heading,
K through M, Merged Rows 73 and 74, Performed by (i.e, Mentor, HBCU, etc.) heading,

N through V, Row 73, Base, 3 column-span major heading,
W through AB, Row 73, As of End of This Report, 2 column-span major heading,
N through P, Row 74, Total Dollars Budgeted for Task (Base) heading,
Q through S, Row 74, Planned Percent Complete as of This Report Period (Base) heading,
T through V, Row 74, Dollars Used Based on Percent Completed (Base), heading,
W through Y, Row 74, Acdtual Dollars Expended as of End of Report Period heading,
Z through AB, Row 74, Variance (As of End of This Report Period) heading,

Rows 75 through 99, for reach row, Cell b provides an incremented numerical tag for the Developmental Tasks field (1, 2, 3, etc.) followed left to right, C through AB, by fields to be completed as listed previously,

Row 100: B through M, Totals label, N through P, calculated Total Dollars Budgeted for Task(Base),(for Developmental Tasks combined), T through V, calculated Dollars Used Based on Percent Completed (Base), (for Developmental Tasks combined), W through Y, calculated Actual Dollars Expended as of End of Report Period (for Developmental Tasks Combined), Z through AB, calculated value for Variance (As of End of this Report Period), (for Developmental Tasks combined),

B through AB, Row 102, Section head, Explanation of Developmental Task Achievements,
Rows 103 through 127, for reach row, Cell b provides an incremented numerical tag for the Explanation of Developmental Task Achievements (1, 2, 3, etc.) followed by the blank field C through AB for reporter to complete,

B through E, Row 129, Section head, Date; F through AB, Section head Capabilities Enhanced (e.g, Database developer can now perform web development as result of Mentor training),

Rows 130 through 135: each row has a blank Date field (B through E) and a blank Capabilities Enhanced field (F through AB) to be completed by reporter,

B through E, Row 137, Section head, Date; F through AB, Section head, Certifications Received (e.g, I S O 9001:2000, C M M I, etc.),

Rows 138 through 141: each row has a blank Date field (B through E) and a blank Certifications Received field (F through AB) to be completed by reporter,

B through E, Row 143, Section head, Date; F through AB, Section head, Technology Transferred,

Rows 144 through 149: each row has a blank Date field (B through E) and a blank Technology Transfered field (F through AB) to be completed by reporter,

Row 151, B through AB, Section head, Revenue, Employees, & Contracts - Prrotégé,

Row 153, B through AB, instructions,

All data entered in this section should reflect only that activity which occurred during the six-month period covered by this report,

Important Note: All dollar figures in this section refer to "invoiced" dollars only, do not include "awarded but not invoiced" dollars,

Row 155, C through Q, field label, Protégé's Gross Revenue During Report Period,
Row 155, R through V, field to be completed for Protégé's Gross Revenue,

Row 156, C through Q, field label, Protégé's Number of Full-Time Employees at End of Report Period,
Row 156, R through V, field to be completed for Protégé's Full Time Employees,

Row 158, J through L, field heading, Proposals Submitted by Protégé (Number),
Row 158, M through O, field heading Prime Contracts Won by Protégé (Number),
Row 158, P through R, field heading Prime Contract Dollars to Protégé,

Row 159, B through I, label NASA, followed by empty fields to be completed by reporter as indicated previously,
J through L, Proposals Submitted by Protégé (Number),
M through O, Prime Contracts Won by Protégé (Number),
P through R, Prime Contract Dollars to Protégé,

Row 160, B through I, label, All Other Federal Government Combined, followed by empty fields to be completed by reporter as indicated previously,
J through L, Proposals Submitted by Protégé (Number),
M through O, Prime Contracts Won by Protégé (Number),
P through R, Prime Contract Dollars to Protégé,

Row 162, J through L, field heading, Subcontracts from Mentor to Protégé (Number),
Row 162 M through O, field heading, Subcontract Dollars from Mentor to Protégé,
Row 162, Q through S, field heading, Subcontracts from Other Than Mentor to Protégé (Number),
Row 162, T through V, field heading, Subcontract Dollars from Other Than Mentor to Protégé,

Row 163, B through I, label, NASA, followed by empty fields to be completed by reporter as indicated previously,
J through L, Subcontracts from Mentor to Protégé (Number),
M through O, Subcontract Dollars from Mentor to Protégé,
Q through S, Subcontracts from Other Than Mentor to Protégé (Number),
T through V, Subcontract Dollars from Other Than Mentor to Protégé,
Row 164, B through I, label, All Other Federal Government Combined, followed by empty fields to be completed by reporter as indicated previously,
J through L, Subcontracts from Mentor to Protégé (Number),
M through O, Subcontract Dollars from Mentor to Protégé,
Q through S, Subcontracts from Other Than Mentor to Protégé (Number),
T through V, Subcontract Dollars from Other Than Mentor to Protégé,


Row 166, J through L, field heading, Subcontracts from Protégé to Mentor (Number),
Row 166 M through O, field heading, Subcontract Dollars from Protégé to Mentor,
Row 166, Q through S, field heading, Subcontracts from Protégé to Other Than Mentor (Number),
Row 166, T through V, field heading, Subcontract Dollars from Protégé to Other Than Mentor,

Row 167, B through I, label, NASA, followed by empty fields to be completed by reporter as indicated previously,
J through L, Subcontracts from Protégé to Mentor (Number),
M through O, Subcontract Dollars from Protégé to Mentor,
Q through S, Subcontracts from Protégé to Other Than Mentor (Number),
T through V, Subcontract Dollars from Protégé to Other Than Mentor,

Row 168, B through I, label, All Other Federal Government Combined, followed by empty fields to be completed by reporter as indicated previously,
J through L, Subcontracts from Protégé to Mentor (Number),
M through O, Subcontract Dollars from Protégé to Mentor,
Q through S, Subcontracts from Protégé to Other Than Mentor (Number),
T through V, Subcontract Dollars from Protégé to Other Than Mentor,

Row 170, B through AB, Section label, NASA Subcontract Awards by Mentor,
Row 171 through 173 merged, B through AB, instruction,
The Mentor is required to submit a copy of the most recent Individual Subcontracting Report (I S R) for the contract which has been identified on the first page,

Row 174, B through AB, Section label, Certification,

Row 176, B through AB, instruction,
By my signature below, I certify that the representations above are true and correct to the best of my knowledge,

Row 178, B, label, Date, to be entered in field Row 179, B through F,
Row 178, G through J, label, Signature of Mentor, to be entered in field Row 179, G through S,
Row 178, T, label, Title, to be entered in field Row 179, T through AB,

Rows 181 and 182 merged, B through AB, instruction,
By my signature below, I certify that the representations above are true and correct to the best of my knowledge,

Row 184, B, label, Date, to be entered in field Row 185, B through F,
Row 184, G through K, label, Signature of Protégé, to be entered in field Row 185, G through S,
Row 184, T, label, Title, to be entered in field Row 185, T through AB,

Row 187 B through AB, Section label, Distribution of Form,
Instructions provided in Rows 189 through 192 merged,

(Distribution for) All Agreements: 1. NASA Center Small Business Specialist,
2. Cotar,
3. NASA Contracting Officer,
4. NASA Headquarters M P Program Manager,

Row 195, B through AB, instruction,
If clarification or assistance is needed in preparing this report, please contact the NASA Office of Small Business Programs at 202-358-2088, or send an email to smallbusiness@nasa.gov,