2-OFFSET_BAA_Attachment_2_Proposal_Template_LoE_table_Route_DRAFT.XLSX

XLSX spreadsheet 43 KB Posted

Attached to
OFFensive Swarm-Enabled Tactics (OFFSET)
Solicitation number
DARPA-SN-17-02
Issued by

About this file

Draft BAA Attachment 2

View the file

Other files

Show all 11

On GovTribe

Work with this file

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

Text version

Example BAA LOE Template

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrMidJrTotalSubCConsltTotal
1.1.0<Phase 1 Task 1 name>713524068024944- 02001,144Notes
1.1.1<Subtask 1.1.1 name>49080280- 0360- 02005601Numbers are illustrative, see the second tab for a template without numbers
1.1.2<Subtask 1.1.2 name>319516040024584- 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>3656483201,6001,968600- 02,568Adding more tasks will require editing the Total Hours formulas
1.2.2<Subtask 1.2.2 name>31136080200340800- 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>7519624024360100100560
2.1.2<Subtask 2.1.2 name>41108032040440- 0- 0440
2.2.0<Phase 2 Task 2 name>64171805201,8002,5001,240- 03,740
2.2.1<Subtask 2.2.1 name>44351404001,2001,740400- 02,140
2.2.2<Subtask 2.2.2 name>419040120600760840- 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
Project Total Hours7042,1603,6886,5522,7403009,292
Project Total Costs First column is prime, second isTravel$ 91,000$ 24,000$ 4,000$ 119,000
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ 12,000$ - 0$ - 0$ 12,000

&G

Template no numbers

DurationIntensityLabor Hours
SOW Task(months)(hrs/mo)SrMidJrTotalSubCConsltTotal
1.1.0<Phase 1 Task 1 name>n.a.- 0- 0- 0- 0- 0- 0- 0
1.1.1<Subtask 1.1.1 name>n.a.- 0- 0- 0
1.1.2<Subtask 1.1.2 name>n.a.- 0- 0- 0
1.2.0<Phase 1 Task 2 name>n.a.- 0- 0- 0- 0- 0- 0- 0
1.2.1<Subtask 1.2.1 name>n.a.- 0- 0- 0
1.2.2<Subtask 1.2.2 name>n.a.- 0- 0- 0
::::::::::
Phase 1 Total Hours- 0- 0- 0- 0- 0- 0- 0
Phase 1 Costs First column is prime, second isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 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$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0
Project Total Hours- 0- 0- 0- 0- 0- 0- 0
Project Total Costs First column is prime, second isTravel$ - 0$ - 0$ - 0$ - 0
total subcontractor, third is total consultant, fourth is totalMaterials & Equipment$ - 0$ - 0$ - 0$ - 0

&G image1.png

File details come from the government source that posted it. Updated .