Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_2.xlsx

XLSX spreadsheet 61 KB Posted Feb 6, 2014

Attached to: Multiple Award Task Order Contract (MATOC) Federal contract opportunity
Solicitation number: NIHOF2013536
Issued by: Department of Health and Human Services National Institutes of Health

About this file

From the source

Attachment L9 - TOR 214-26 - Task Order Pricing Template - Revision 2

View the file

Other files for this federal contract opportunity

Other files attached to Multiple Award Task Order Contract (MATOC), newest first.
File	Type	Posted
Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_3.xlsx	XLSX spreadsheet	Feb 12, 2014
TOR_00-13_-_Revised_Drawings_-_dated_02-10-14.pdf	PDF	Feb 12, 2014
Section_H_-_Special_Contract_Requirements_-_Revision_1.pdf	PDF	Feb 12, 2014
Section_G_-_Contract_Administration_Data_-_Revision_1.pdf	PDF	Feb 12, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template_-_Revision_3.xlsx	XLSX spreadsheet	Feb 12, 2014
SF_30_-_NIHOF2013536_-_Amendment_0005.pdf	PDF	Feb 12, 2014
Specification_Section_01_33_00_-_Revision_1.pdf	PDF	Feb 12, 2014
Amendment_0005.docx	DOCX document	Feb 12, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_3.xlsx	XLSX spreadsheet	Feb 12, 2014
SF_30_-_NIHOF2013536_-_Amendment_0004.pdf	PDF	Feb 11, 2014
Amendment_0003.docx	DOCX document	Feb 6, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template_-_Revision_2.xlsx	XLSX spreadsheet	Feb 6, 2014
MATOC_Pre-Proposal_Conference_Sign-in_Sheet.pdf	PDF	Feb 6, 2014
SF_30_-_NIHOF2013536_-_Amendment_0003.pdf	PDF	Feb 6, 2014
MATOC_Pre-Proposal_Conference_Briefing.pptx	PPTX presentation	Feb 6, 2014
Attachment_L8_-_TOR_214-26_-_Statement_of_Work_-_Revision_2.pdf	PDF	Feb 3, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Feb 3, 2014
Attachment_L9_-_TOR_214-26_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Feb 3, 2014
SF_30_-_NIHOF2013536_-_Amendment_0002.pdf	PDF	Feb 3, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_2.xlsx	XLSX spreadsheet	Feb 3, 2014
Amendment_0002.docx	DOCX document	Feb 3, 2014
Attachment_L8_-_TOR_214-26_-_Statement_of_Work_-_Revision_1.pdf	PDF	Jan 24, 2014
Statement_of_Work_-_Revision_1_-_01-24-14.pdf	PDF	Jan 24, 2014
Attachment_L7_-_TOR_214-20_-_Task_Order_Pricing_Template.xlsx	XLSX spreadsheet	Jan 24, 2014
Attachment_L4_-_TOR_13-00_-_Statement_of_Work_-_Revision_1.pdf	PDF	Jan 24, 2014
NIH_As-Built_Drawing_LOP_for_Contractors.doc	DOC document	Jan 24, 2014
Specification_Section_01_35_26.docx	DOCX document	Jan 24, 2014
Specification_Section_01_45_00.docx	DOCX document	Jan 24, 2014
Section_J_-_List_of_Attachments_-_Revision_1.pdf	PDF	Jan 24, 2014
Section_L_-_Instructions _Conditions _and_Notices_to_Offerors_-_Revision_1.pdf	PDF	Jan 24, 2014
Attachment_L6_-_TOR_214-20_-_Statement_of_Work_-_Revision_1.pdf	PDF	Jan 24, 2014
Section_E_-_Inspection_and_Acceptance_-_Revision_1.pdf	PDF	Jan 24, 2014
SF_30_-_NIHOF2013536_-_Amendment_0001.pdf	PDF	Jan 24, 2014
Attachment_L2_-_Past_Performance_Transmittal_Letter_-_Revision_1.docx	DOCX document	Jan 24, 2014
Attachment_L5_-_TOR_13-00_-_Task_Order_Pricing_Template_-_Revision_1.xlsx	XLSX spreadsheet	Jan 24, 2014
FMB-NC_Engineering_Guidelines_and_Material_Requirements--Revision_C.pdf	PDF	Jan 17, 2014
Attachment_L3_Past_Performance_Questionnaire.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130093--Highway.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130080--Heavy.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130028--Building.pdf	PDF	Jan 17, 2014
Wage_Determination--NC130019--Heavy_Dredging.pdf	PDF	Jan 17, 2014
Attachment_L4_TOR_213-00--Statement_of_Work.pdf	PDF	Jan 17, 2014
Attachment_L5_TOR_214-20--Statement_of_Work.pdf	PDF	Jan 17, 2014
Safety_and_Health.pdf	PDF	Jan 17, 2014
Attachment_L2_Past_Performance_Transmittal_Letter.pdf	PDF	Jan 17, 2014
Attachment_L6_TOR_214-26--Statement_of_Work.pdf	PDF	Jan 17, 2014
Attachment_L1_Experience_Summary_Sheet.pdf	PDF	Jan 17, 2014
Certificate_of_Current_Cost_or_Pricing_Data.pdf	PDF	Jan 17, 2014
Task_Order_Pricing_Template.xlsx	XLSX spreadsheet	Jan 17, 2014
SF_1442.pdf	PDF	Jan 17, 2014

Show all 50

Multiple Award Task Order Contract (MATOC) has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

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.

TOR 214-26 - Base Price

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
Demolition
Valve removal		EA
Insulation removal		LF
Mechanical
14" High Performance Butterfly Valve installation		EA
Bolt/Gasket kit		EA
Valve Flange cleaning and refacing		FLANGE
Insulation installation		LF
Labeling/valve tags	1	LOT
Additional Items Not Covered in List Above

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Additional Items shall not include an entry that says Miscellaneous. All line items need to be specific work that is being done. If additional rows need to be added other than the	Bond	0.000%	$0.00
3 rows included in the Task Order Pricing Template, only add more rows in the Additional Items category above the row for Task Order Management. Ensure that all costs included	Grand Total		$0
in the Additional Items category are included in the totals.
5) Additional Items shall always include a category. For each item added into the additional items, the contractor shall identify either one included on the Task Order Pricing Template
(e.g. Mechanical, Electrical) or identify a new category. For any additional item, the contractor shall include a unit of measure in the Quantity column.
6) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)
7) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
8) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]

&16Task Order Pricing Template

Option (1)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-1)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
Additional Items Not Covered in List Above

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Additional Items shall not include an entry that says Miscellaneous. All line items need to be specific work that is being done. If additional rows need to be added other than the	Bond	0.000%	$0.00
3 rows included in the Task Order Pricing Template, only add more rows in the Additional Items category above the row for Task Order Management. Ensure that all costs included	Grand Total		$0
in the Additional Items category are included in the totals.
5) Additional Items shall always include a category. For each item added into the additional items, the contractor shall identify either one included on the Task Order Pricing Template
(e.g. Mechanical, Electrical) or identify a new category. For any additional item, the contractor shall include a unit of measure in the Quantity column.
6) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)
7) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
8) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]

&16Task Order Pricing Template

Option (2)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-2)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
Additional Items Not Covered in List Above

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Additional Items shall not include an entry that says Miscellaneous. All line items need to be specific work that is being done. If additional rows need to be added other than the	Bond	0.000%	$0.00
3 rows included in the Task Order Pricing Template, only add more rows in the Additional Items category above the row for Task Order Management. Ensure that all costs included	Grand Total		$0
in the Additional Items category are included in the totals.
5) Additional Items shall always include a category. For each item added into the additional items, the contractor shall identify either one included on the Task Order Pricing Template
(e.g. Mechanical, Electrical) or identify a new category. For any additional item, the contractor shall include a unit of measure in the Quantity column.
6) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)
7) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
8) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]

&16Task Order Pricing Template

Option (3)

TOR#214-26: North Plan HTHW Air Seperator Valve Replacment
Date:
Contractor:
	Quantitiy		Material		Labor			Equipment	Subcontractor
Item	No.	Unit	Unit Cost	Total	Total Hrs	Rate	Total
OPTION 1 - Replace Flanges (V-3)
Replace two 300 lb Class 14" flanges		EA
Misc. welding and fitting material		EA
Weld Testing		EA
Additional Items Not Covered in List Above

Task Order Management

Project Manager

Superintendent

Quality Control Manager

TOTAL LABOR HOURS * Labor hours and rates are crew rates and crew hours 0.0

TOTAL DOLLARS PRIOR TO TAX	$0.00	$0.00	$0.00	$0.00
SALES TAX	$0.00		$0.00
ELEMENT SUBTOTALS	$0.00	$0.00	$0.00	$0.00

Instructions:	Task Order Subtotal		$0.00
1) All costs for a line item within a category shall encompass all costs for that line item for the entire task order	Field Overhead	0.00%	$0.00
2) Labor rates are to include fringe in accordance with the applicable Wage Determinations	G & A	0.00%	$0.00
3) Subcontractor total shall include all costs associated with subcontractor (e.g. overhead/G&A/management/profit charged by subcontractor). The columns available for Task	Profit	0.00%	$0.00
Order Management of the Subcontractor will include only the amounts that the Prime Contractor is charging for management over and above what the Subcontractor is including.	TOTAL (without bond)		$0.00
4) Additional Items shall not include an entry that says Miscellaneous. All line items need to be specific work that is being done. If additional rows need to be added other than the	Bond	0.000%	$0.00
3 rows included in the Task Order Pricing Template, only add more rows in the Additional Items category above the row for Task Order Management. Ensure that all costs included	Grand Total		$0
in the Additional Items category are included in the totals.
5) Additional Items shall always include a category. For each item added into the additional items, the contractor shall identify either one included on the Task Order Pricing Template
(e.g. Mechanical, Electrical) or identify a new category. For any additional item, the contractor shall include a unit of measure in the Quantity column.
6) Sales tax only applies to material and rental equipment bought specifically for performance of the task order (contractor owned equipment is exempt)
7) Task Order Subtotal = Material Element Subtotal + Direct Labor Element Subtotal + Equipment Subtotal + Subcontractor Element Subtotal
8) $30K - $150K (Payment Bond and Irrevocable Letter of Credit), over $150K (Payment and Performance Bonds)
[NOTE: Performance Bond is acceptable in lieu of Irrevocable Letter of Credit]

&16Task Order Pricing Template

Pay Rates

			4D	4D	4D	4D	4D				GB	GB	GB	GB	GB
			Base Year	1st Option	2nd Option	3rd Option	4th Option				Base Year	1st Option	2nd Option	3rd Option	4th Option
			2012	2013	2014	2015	2016
1AA	Professional Cat I	Project Manager	$94.54	$98.32	$102.25	$106.34	$110.60	1AA	Professional Cat I	Project Manager	$58.27
1AB	Professional Cat II	QC Manager	$55.00	$57.20	$59.49	$61.87	$64.34	1AB	Professional Cat II	QC Manager	$41.99
	Professional Level 2	Project Engineer	$137.50	$143.00	$148.72	$154.67	$160.86		Professional Level 2	Project Engineer	$127.50
1AC	Professional Cat III	Non-reg Engineer	$95.15	$98.96	$102.91	$107.03	$111.31	1AC	Professional Cat III	Non-reg Engineer	$95.00
1AD	Professional Cat IV	Secretary, word pro	$29.60	$30.78	$32.02	$33.30	$34.63	1AD	Professional Cat IV	Secretary, word pro	$18.08
1AE	Professional Cat V	Cat 2 Super	$62.75	$65.26	$67.87	$70.59	$73.41	1AE	Professional Cat V	Cat 2 Super	$41.99
1AF	Skill Cat I	Foreman	$39.62	$41.20	$42.85	$44.57	$46.35	1AF	Skill Cat I	Foreman	$32.30
1AG	Skill Cat II	Electrician	$32.35	$33.64	$34.99	$36.39	$37.84	1AG	Skill Cat II	Electrician	$37.45
1AH	Skill Cat III	Carpenter	$29.31	$30.48	$31.70	$32.97	$34.29	1AH	Skill Cat III	Carpenter	$26.29
		HVAC Mechanics	$30.03	$31.23	$32.48	$33.78	$35.13			HVAC Mechanics	$39.27
		Plumbers	$43.75	$45.50	$47.32	$49.21	$51.18			Plumbers	$38.68
		Laborer	$20.73	$21.56	$22.42	$23.32	$24.25			Laborer	$13.31
		Pipefitter	$43.75	$45.50	$47.32	$49.21	$51.18			Pipefitter	$58.10
		Equipment operator	$29.31	$30.48	$31.70	$32.97	$34.29			Equipment operator	$17.61
		Truck driver	$20.57	$21.39	$22.25	$23.14	$24.06			Truck driver	$19.25

Contractor: 4D

Contractor: Guerrero Builders

Bond Calc (1 Sheet)

Total Before Bond=	ERROR:#REF!
Bond=	ERROR:#REF!
Bond Percent=	ERROR:#REF!
Grand Total with Bond=	ERROR:#REF!

Calculations
Up to Amount
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Up to Amount	ERROR:#REF!
$ 100,000.00	ERROR:#REF!	$ 25.00	ERROR:#REF!
$ 400,000.00	ERROR:#REF!	$ 15.00	ERROR:#REF!
$ 2,000,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 10.00	ERROR:#REF!
$ 7,500,000.00	ERROR:#REF!	$ 9.00	ERROR:#REF!
		Total:	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

Bond Calc (2 Sheet)

Total Before Bond=	$0.00
Bond=	$ - 0
Bond Percent=
Grand Total with Bond=	$ - 0

Calculations
Up to Amount
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

Up to Amount	$ - 0
$ 100,000.00	$ - 0	$ 25.00	$ - 0
$ 400,000.00	$ - 0	$ 15.00	$ - 0
$ 2,000,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 10.00	$ - 0
$ 7,500,000.00	$ - 0	$ 9.00	$ - 0
		Total:	$ - 0	$ - 0	1

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