KAIROS_BAA_proposal_LoE_table_template_SkillSets.xlsx

23 KB Posted

Attached to
Knowledge-directed Artificial Intelligence Reasoning Over Schemas (KAIROS)
Solicitation number
HR001119S0014
Issued by

About this file

From the source

Not Listed

View the file

Other files

File Type Posted
KAIROS_BAA_final_AMENDED_2018-12-27_v2.pdf PDF
HR001119S0014.pdf PDF
KAIROS_BAA_Attachment_Proposal_Summary_Chart_Template.pptx PPTX presentation

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

BAA LOE Template

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)Srskill setMidskill setJrskill setTotalSubC-Srskill setSubC-Midskill setSubC-Jrskill setConsltTotal
1.1.0<Phase 1 Task 1 name>713524068024944- 02001,144Notes
1.1.1<Subtask 1.1.1 name>49080Engineer280Engineer- 0360- 02005601Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>3195160Software Dev400Software Dev24Software Dev584- 0- 05842Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0<Phase 1 Task 2 name>63851084001,8002,3081,400- 03,7083Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1<Subtask 1.2.1 name>365648Data Scientist320Data Scientist1,600Data Scientist1,968600Software Dev- 02,568Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>311360SME III80SME II200SME I340800Engineer- 01,1404Pasting into proposal as a picture will produce the best results
:::::::::::5If you have more than 12 tasks and subtasks per phase, you can break the table into
Phase 1 Total Hours3481,0801,8243,2521,4002004,652into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
Phase 1 Costs First column is prime, second isTravel$ 44,000$ 12,000$ 2,000$ 58,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 8,000$ - 0$ - 0$ 8,000
2.1.0<Phase 2 Task 1 name>8100176560648001001001,000
2.1.1<Subtask 2.1.1 name>75196Data Scientist240Data Scientist24Data Scientist360100Engineer100560
2.1.2<Subtask 2.1.2 name>411080Software Dev320SME II40Software Dev440- 0- 0440
2.2.0<Phase 2 Task 2 name>64171805201,8002,5001,240- 03,740
2.2.1<Subtask 2.2.1 name>4435140Data Scientist400Data Scientist1,200Data Scientist1,740400Software Dev- 02,140
2.2.2<Subtask 2.2.2 name>419040SME II120Software Dev600SME II760840Engineer- 01,600
:::::::::::
Phase 2 Total Hours3561,0801,8643,3001,3401004,640
Phase 2 Costs First column is prime, second isTravel$ 47,000$ 12,000$ 2,000$ 61,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 4,000$ - 0$ - 0$ 4,000
3.1.0<Phase 3 Task 1 name>971120400120640100100840
3.1.1<Subtask 3.1.1 name>39340Software Dev200Data Scientist40Data Scientist280100Engineer100480
3.1.2<Subtask 3.1.2 name>66080Software Dev200SME II80Software Dev360- 0- 0360
3.2.0<Phase 3 Task 2 name>64601608001,8002,7601,200- 03,960
3.2.1<Subtask 3.2.1 name>437080SME II400Data Scientist1,000Data Scientist1,480600Software Dev- 02,080
3.2.2<Subtask 3.2.2 name>342780SME II400Software Dev800SME II1,280600Engineer- 01,880
:::::::::::
Phase 3 Total Hours2801,2001,9203,4001,3001004,800
Phase 3 Costs First column is prime, second isTravel$ 48,000$ 12,000$ 2,000$ 62,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
Project Total Hours9843,3605,6089,9524,04040014,092
Total Project Costs First column is prime, second isTravel$ 139,000$ 36,000$ 6,000$ 181,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 12,000$ - 0$ - 0$ 12,000

Template no numbers

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)Srskill setMidskill setJrskill setTotalSubC-Srskill setSubC-Midskill setSubC-Jrskill setConsltTotal
1.1.0<Phase 1 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0Notes
1.1.1<Subtask 1.1.1 name>n.a.- 0- 0- 0- 01Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>n.a.- 0- 0- 0- 02Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0<Phase 1 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 03Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1<Subtask 1.2.1 name>n.a.- 0- 0- 0Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>n.a.- 0- 0- 04Pasting into proposal as a picture will produce the best results
:::::::::::5If you have more than 12 tasks and subtasks per phase, you can break the table into
Phase 1 Total Hours- 0- 0- 0- 0- 0- 0- 0into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
Phase 1 Costs First column is prime, second isTravel$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0
2.1.0<Phase 2 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0
2.1.1<Subtask 2.1.1 name>n.a.- 0- 0
2.1.2<Subtask 2.1.2 name>n.a.- 0- 0- 0- 0
2.2.0<Phase 2 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 0
2.2.1<Subtask 2.2.1 name>n.a.- 0- 0- 0
2.2.2<Subtask 2.2.2 name>n.a.- 0- 0- 0
:::::::::::
Phase 2 Total Hours- 0- 0- 0- 0- 0- 0- 0
Phase 2 Costs First column is prime, second isTravel
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0
3.1.0<Phase 3 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0
3.1.1<Subtask 3.1.1 name>n.a.- 0- 0
3.1.2<Subtask 3.1.2 name>n.a.- 0- 0- 0- 0
3.2.0<Phase 3 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 0
3.2.1<Subtask 3.2.1 name>n.a.- 0- 0- 0
3.2.2<Subtask 3.2.2 name>n.a.- 0- 0- 0
:::::::::::
Phase 3 Total Hours- 0- 0- 0- 0- 0- 0- 0
Phase 3 Costs First column is prime, second isTravel
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
Project Total Hours- 0- 0- 0- 0- 0- 0- 0
Total Project Costs First column is prime, second isTravel$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0

File details come from the government source that posted it.