EA_BAA_proposal_LoE_table_template.xlsx

XLSX spreadsheet 20 KB Posted May 12, 2016

Attached to: Enhanced Attribution
Solicitation number: DARPA-BAA-16-34
Issued by: Defense Advanced Research Projects Agency

About this file

From the source

Enhanced Attribution proposal LoE table template

View the file

Other files

File	Type	Posted
DARPA-BAA-16-34.pdf	PDF	Apr 22, 2016

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.

EA BAA LOE Template

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC	Conslt	Total
1.1.0	<Phase 1 Task 1 name>	7	135	240	680	24	944	- 0	200	1,144		Notes
1.1.1	<Subtask 1.1.1 name>	4	90	80	280	- 0	360	- 0	200	560	1	Numbers are illustrative, see the second tab for a template without numbers
1.1.2	<Subtask 1.1.2 name>	3	195	160	400	24	584	- 0	- 0	584	2	Numbers in blue are inputs, numbers in black are computed by formulas
1.2.0	<Phase 1 Task 2 name>	6	385	108	400	1,800	2,308	1,400	- 0	3,708	3	Task lines roll-up subtask numbers, so each Total Hours row should only sum the task lines
1.2.1	<Subtask 1.2.1 name>	3	656	48	320	1,600	1,968	600	- 0	2,568		Adding more tasks will require editing the Total Hours formulas
1.2.2	<Subtask 1.2.2 name>	3	113	60	80	200	340	800	- 0	1,140	4	Pasting into proposal as a picture will produce the best results
:	:	:	:	:	:	:	:	:	:	:	5	If you have more than 12 tasks and subtasks per phase, you can break the table into
			Phase 1 Total Hours	348	1,080	1,824	3,252	1,400	200	4,652		into multiple parts at phase boundaries (e.g., Phase 3 and totals would appear on 2nd page)
			Phase 1 Costs First column is prime, second is			Travel	$ 44,000	$ 12,000	$ 2,000	$ 58,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 8,000	$ - 0	$ - 0	$ 8,000
2.1.0	<Phase 2 Task 1 name>	8	100	176	560	64	800	100	100	1,000
2.1.1	<Subtask 2.1.1 name>	7	51	96	240	24	360	100	100	560
2.1.2	<Subtask 2.1.2 name>	4	110	80	320	40	440	- 0	- 0	440
2.2.0	<Phase 2 Task 2 name>	6	417	180	520	1,800	2,500	1,240	- 0	3,740
2.2.1	<Subtask 2.2.1 name>	4	435	140	400	1,200	1,740	400	- 0	2,140
2.2.2	<Subtask 2.2.2 name>	4	190	40	120	600	760	840	- 0	1,600
:	:	:	:	:	:	:	:	:	:	:
			Phase 2 Total Hours	356	1,080	1,864	3,300	1,340	100	4,640
			Phase 2 Costs First column is prime, second is			Travel	$ 47,000	$ 12,000	$ 2,000	$ 61,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 4,000	$ - 0	$ - 0	$ 4,000
3.1.0	<Phase 3 Task 1 name>	9	71	120	400	120	640	100	100	840
3.1.1	<Subtask 3.1.1 name>	3	93	40	200	40	280	100	100	480
3.1.2	<Subtask 3.1.2 name>	6	60	80	200	80	360	- 0	- 0	360
3.2.0	<Phase 3 Task 2 name>	6	460	160	800	1,800	2,760	1,200	- 0	3,960
3.2.1	<Subtask 3.2.1 name>	4	370	80	400	1,000	1,480	600	- 0	2,080
3.2.2	<Subtask 3.2.2 name>	3	427	80	400	800	1,280	600	- 0	1,880
:	:	:	:	:	:	:	:	:	:	:
			Phase 3 Total Hours	280	1,200	1,920	3,400	1,300	100	4,800
			Phase 3 Costs First column is prime, second is			Travel	$ 48,000	$ 12,000	$ 2,000	$ 62,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ - 0	$ - 0	$ - 0	$ - 0
			Project Total Hours	984	3,360	5,608	9,952	4,040	400	14,092
			Total Project Costs First column is prime, second is			Travel	$ 139,000	$ 36,000	$ 6,000	$ 181,000
			total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ 12,000	$ - 0	$ - 0	$ 12,000

Template no numbers

		Duration	Intensity	Labor Hours
SOW Task		(months)	(hrs/mo)	Sr	Mid	Jr	Total	SubC	Conslt	Total
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
1.2.2	<Subtask 1.2.2 name>		n.a.				- 0			- 0

		Phase 1 Total Hours	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Phase 1 Costs First column is prime, second is			Travel				$ - 0
		total subcontractor, third is total consultant, fourth is total			Materials & Equipment				$ - 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
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
2.2.2	<Subtask 2.2.2 name>	n.a.				- 0			- 0

		Phase 2 Total Hours	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Phase 2 Costs First column is prime, second is			Travel				$ - 0
		total subcontractor, third is total consultant, fourth is total			Materials & Equipment				$ - 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
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
3.2.2	<Subtask 3.2.2 name>	n.a.				- 0			- 0

Phase 3 Total Hours	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Phase 3 Costs First column is prime, second is			Travel				$ - 0
total subcontractor, third is total consultant, fourth is total			Materials & Equipment				$ - 0
Project Total Hours	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Project Costs First column is prime, second is			Travel	$ - 0	$ - 0	$ - 0	$ - 0
total subcontractor, third is total consultant, fourth is total			Materials & Equipment	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it. Updated Nov 14, 2017.