A01_PileVolume CC 06.16.22_R3 ElkClarkIRSC.xlsx

XLSX spreadsheet 85 KB Posted Jul 1, 2022

Attached to: Elk Clark Stewardship IRSC - Coconino National Forest, R3 AZ
Solicitation number: 12363N22Q4069
Issued by: Department of Agriculture Forest Service

View the file

Other files

File	Type	Posted
A01_ScaleDeck CC 06.16.22_R3 ElkClarkIRSC.xlsx	XLSX spreadsheet	Jul 1, 2022
A01_CruiserRept 06.01.22_ElkClarkIRSC.PDF	PDF	Jul 1, 2022
Amendment 01_ElkClarkIRSC.pdf	PDF	Jul 1, 2022
6. SCA Wage Determination 1977-0211 Rev66.pdf	PDF	Jun 17, 2022
4. Appendix C_ElkClark IRSC_12363N22Q4069.pdf	PDF	Jun 17, 2022
1. Solicitation_ElkClark IRSC_12363N22Q4069.pdf	PDF	Jun 17, 2022
3. Appendix B_Scaled_ElkClark IRSC_12363N22Q4069.pdf	PDF	Jun 17, 2022
2. Appendix A_ElkClark IRSC_12363N22Q4069.pdf	PDF	Jun 17, 2022
5. Contract Area Map_ElkClark IRSC_12363N22Q4069.pdf	PDF	Jun 17, 2022

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.

setp 1 Gross Volume

	Pile Volume Calculator
height	0	Instructions: (1) Enter typical dimensions in the red boxes. If the footprint is circular, width is used and any length given is ignored. For a half-sphere only width is used.
width	0
length	0

	Elliptical Parabola Cross-section	Semi-circle or Oval / Ellipse Cross-section
Oval / Ellipse Footprint	Elliptical paraboloid* (oval mound)	Half-ellipsoid
	0	0

From PNW-GTR-364, "Guidelines for Estimating Volume, Biomass, and Smoke Production for Piled Slash" and other sources

Volumes are in the cube of feet (or of any other linear unit used consistently).

* Details for fellow geeks: For several years APCD used the half-ellipsoid shape for piles with oval bases. We recently realized that the vertical cross-section of a half-ellipsoid is a semi-circle, or the same cross-sectional shape as the ice-cream scoop half-sphere. The vertical cross-section of the most commonly used shape, the "round mound", is a parabola. A more accurate volume estimate for piles which are longer than they are wide may come from a shape with an ellipse for the footprint, and a parabola for the vertical cross-section. This shape is the awkwardly-named 'elliptical paraboloid' and as of 6/11 is a new addition to the pile volume calculator spreadsheet.

Tons volume per pile

Guidelines for estmating Volume, Biomass, and smoke production for Piles slash (PNW-GTR-364)					Appendix 1:
Gross Volume					A Hypothetical	Step one—Total gross volume of the pile—
Step 1	0	CF			Example	A. Select a representative pile shape: Pile shape is half-ellipsoid—shape code 6.
Net Volume					Pages 20-21	B. Calculate the gross volume:
Step 2	0.00	CF	0.1	packing ratio (Ponderosa Pine )		Formula method. Volume = = 2178 cubic feet
						Nomagram: Refer to figure 5 and follow the arrowed line to the X-axis at the upper
Step 3			Density			right, where the gross volume equals about 2.2 thousand cubic feet.
			24	pounds per CF (Ponderosa Pine)
						Step two—Net volume of the woody biomass—
Consumable						Formula method: Net volume = Gross volume x packing ratio; therefore,
Step 4	0.00	Pounds				2178*0.20 = 435.6 cubic feet.
	0.00	Tons				Nomagram: Refer to figure 6 and follow the arrowed line to the Y-axis at the left,
						where the net volume equals about 435 cubic feet.
						Step three—Density or weighted-average density of the wood
						Formula method: The pile is 75 percent Douglas-fir and 25 percent western hemlock.
						Refer to table 2 for the densities of Douglas-fir (28.1 Ib/ft3) and western hemlock
						(26.2 Ib/ft3). Calculate the weighted average:
						(0.7528.1)+(0.2526.2)=27.63 pounds per cubic foot.
						Nomagram: Refer to figure 7, where the diagonal line connecting Douglas-fir and
						western hemlock intersects the vertical line representing 75 percent Douglas-fir at
						about 27.7 Ib/ft3 (on the Y-axis).
						16
						Step four—Consumable (oven-dry) mass of wood—
						Formula method: Net wood mass = net wood volume x wood density
						435.6*27.63 = 12,036 pounds or ~ 6 tons.
						Nomagram: Refer to figure 6 and follow the arrowed line to the curves on the right,
						then down to the X-axis, where the net mass of wood is approximately 6.0 tons.

Final volume piles

	Piles	Height	Width	Length	CF	Net CF
(Step 2)	Pounds	Tons
(step 4)	NET CF	Tons	Tons to CF ratio
	1	10	22	133	15,321	1532.05	36769.20	18.38	1532.05	18.38	0.0119969975	1.19
	2	12	66	77	31,931	3193.11	76634.75	38.32	3193.11	38.31	0.0119977076
	3	14	65	88	41,930	4192.98	100631.50	50.32	4192.97	50.31	0.0119986549
	4	7	24	34	2,991	299.08	7177.91	3.59	299.07	3.58	0.0119704417		Total Tons	5646
	5	8	70	67	19,645	1964.54	47149.02	23.57	1964.54	23.57	0.0119977196
	6	8	32	84	11,259	1125.95	27022.72	13.51	1125.94	13.51	0.0119988632
	7	14	42	108	33,251	3325.06	79801.48	39.90	3325.06	39.90	0.0119997835		Tons per load (25 used)	226
	8	12	43	39	10,537	1053.69	25288.56	12.64	1053.69	12.64	0.0119959381
	9	7	56	65	13,341	1334.13	32019.11	16.01	1334.12	16.00	0.0119929242
	10	9	69	57	18,534	1853.38	44481.18	22.24	1853.38	22.24	0.0119996978
	11	11	73	56	23,545	2354.52	56508.46	28.25	2354.51	28.25	0.0119982502
	12	8	32	32	4,289	428.93	10294.37	5.15	428.93	5.14	0.0119833073
	13	7	58	31	6,590	659.00	15816.03	7.91	659.00	7.90	0.0119878604
	14	10	55	26	7,487	748.75	17969.91	8.98	748.74	8.98	0.0119934824
	15	10	98	43	22,064	2206.45	52954.69	26.48	2206.44	26.47	0.0119967006
	16	13	75	33	16,847	1684.68	40432.30	20.22	1684.67	20.21	0.0119964147
	17	14	38	103	28,691	2869.11	68858.68	34.43	2869.11	34.42	0.0119967516
	18	8	58	36	8,746	874.62	20990.87	10.50	874.61	10.49	0.0119939173
	19	15	195	97	148,558	14855.81	356539.35	178.27	14855.80	178.26	0.0119993538
	20	16	71	59	35,094	3509.37	84224.84	42.11	3509.36	42.11	0.0119993389
	21	9	44	33	6,842	684.24	16421.73	8.21	684.24	8.21	0.0119987335
	22	13	88	44	26,356	2635.59	63254.08	31.63	2635.58	31.62	0.0119973592
	23	10	55	36	10,367	1036.73	24881.41	12.44	1036.72	12.44	0.0119993827
	24	13	76	53	27,418	2741.77	65802.54	32.90	2741.77	32.90	0.0119995477
	25	9	98	153	70,658	7065.76	169578.14	84.79	7065.75	84.78	0.0119987262
	26	10	60	133	41,783	4178.32	100279.64	50.14	4178.31	50.13	0.011997913
	27	10	74	40	15,499	1549.85	37196.46	18.60	1549.85	18.59	0.0119947092
	28	10	130	60	40,841	4084.07	98017.69	49.01	4084.07	49.00	0.0119978355
	29	12	112	49	34,482	3448.21	82757.09	41.38	3448.21	41.37	0.0119975292
	30	8	39	41	6,698	669.79	16074.90	8.04	669.78	8.03	0.0119890113
	31	13	37	58	14,607	1460.74	35057.66	17.53	1460.73	17.52	0.011994003
	32	15	86	94	63,492	6349.16	152379.81	76.19	6349.15	76.18	0.0119984565
	33	12	64	92	36,995	3699.54	88788.95	44.39	3699.53	44.39	0.0119988215
	34	12	190	180	214,885	21488.49	515723.85	257.86	21488.49	257.86	0.0119999125
	35	10	49	71	18,216	1821.60	43718.40	21.86	1821.60	21.85	0.0119949495
	36	10	80	124	51,941	5194.10	124658.40	62.33	5194.09	62.32	0.0119982519
	37	18	110	93	96,415	9641.55	231397.15	115.70	9641.54	115.69	0.0119991205
	38	7	49	66	11,853	1185.32	28447.75	14.22	1185.32	14.22	0.0119967604
	39	11	98	134	75,635	7563.49	181523.74	90.76	7563.48	90.76	0.0119997673
	40	14	65	109	51,936	5193.58	124645.83	62.32	5193.57	62.32	0.0119994532
	41	8	51	74	15,808	1580.85	37940.39	18.97	1580.84	18.97	0.0119999494
	42	12	72	50	22,619	2261.95	54286.72	27.14	2261.94	27.14	0.0119985499
	43	15	145	144	163,991	16399.11	393578.73	196.79	16399.11	196.78	0.0119994317
	44	9	39	53	9,741	974.05	23377.22	11.69	974.05	11.68	0.0119911709
	45	12	53	85	28,306	2830.57	67933.80	33.97	2830.57	33.96	0.0119975835
	46	6	57	61	10,923	1092.33	26215.96	13.11	1092.33	13.11	0.0120018676
	47	16	356	106	316,136	31613.64	758727.30	379.36	31613.63	379.36	0.0119998874
	48	10	174	84	76,529	7652.92	183670.07	91.84	7652.91	91.83	0.0119993571
	49	8	52	67	14,594	1459.37	35024.99	17.51	1459.37	17.51	0.011998328
	50	6	450	468	661,619	66161.94	1587886.59	793.94	66161.94	793.94	0.0119999504
	51	6	99	62	19,283	1928.31	46279.43	23.14	1928.30	23.13	0.0119950215
	52	17	70	152	94,709	9470.85	227300.51	113.65	9470.85	113.65	0.0119999789
	53	10	32	152	25,468	2546.78	61122.83	30.56	2546.78	30.56	0.011999466
	54	21	180	258	510,634	51063.45	1225522.73	612.76	51063.44	612.76	0.0119999749
	55	9	114	63	33,844	3384.44	81226.51	40.61	3384.43	40.61	0.0119990663
	56	6	32	90	9,048	904.78	21714.69	10.86	904.77	10.85	0.011991998
	57	16	75	432	271,434	27143.36	651440.65	325.72	27143.36	325.72	0.0119999882
	58	18	280	185	488,203	48820.35	1171688.40	585.84	48820.34	585.84	0.0119999164
	59	73	153	8	46,785	4678.46	112283.03	56.14	4678.45	56.14	0.0119997008
	60	11	59	30	10,194	1019.45	24466.72	12.23	1019.44	12.23	0.0119967825
	61	18	135	44	55,983	5598.32	134359.63	67.18	5598.31	67.17	0.0119982638
	62	11	70	47	18,949	1894.90	45477.70	22.74	1894.90	22.73	0.011995356
	63	14	50	50	18,326	1832.60	43982.30	21.99	1832.59	21.99	0.0119994107
	64	13	54	42	15,438	1543.78	37050.69	18.53	1543.77	18.52	0.0119966057
	65	7	33	34	4,112	411.23	9869.63	4.93	411.23	4.93	0.011988425
	66	15	75	30	17,671	1767.15	42411.50	21.21	1767.14	21.20	0.0119967858
	67	15	233	145	265,347	26534.68	636832.25	318.42	26534.67	318.41	0.0119997724
	68	12	75	29	13,666	1366.59	32798.23	16.40	1366.59	16.39	0.0119933557
	69	7	36	26	3,431	343.06	8233.49	4.12	343.06	4.11	0.0119804116
	70	14	64	69	32,371	3237.10	77690.33	38.85	3237.09	38.84	0.0119984307
	71	12	65	30	12,252	1225.22	29405.31	14.70	1225.22	14.70	0.0119978453

image1.jpeg image2.jpeg image3.jpeg

File details come from the government source that posted it. Updated Jul 1, 2022.