Sawmill Badger

Start


	.

How To


	How To Use Sawmill Badger

	Setup
	This section is required and sets the parameters for calculations made from data you will input in other sections.
	1. Enter the name of the sawmill;
	2. Provide a name for your mill study (e.g. Clam Lake Lumber – Birch Run);
	3. Enter the species name (only one species is allowed per study);
	4. Select the Log Rule (Doyle, Scribner or International ¼”);
	5. Enter the log grade name and price per MBF;
	6. Enter the price per MBF for each of the lumber grades. Standard grades are listed and up to four custom grades are allowed. Leave any unused grade blank;
	7. Enter the sawing cost per MBF of lumber;
	Descriptions of the any custom grades used can be entered and will be included in the summary report.
	Logs
	In this section you will enter the diameters and lengths of up to thirty logs that are sawn in the mill study. Both small end and large end log diameters are entered in inches and tenths (the large end diameters are necessary for calculating cubic volumes). Lengths are entered in feet and tenths. The board foot and cubic foot volumes of each log are calculated automatically, along with the cost of the log.
	Lumber - Batch Option
	Use this option for a fast summary report of the yield from your study logs
	This section allows you to enter the entire lumber yield of the study logs by grade. A summary report is provided beneath the entry options. This report can be sent to any connected printers or printed to a PDF file format.
	Lumber - Detailed Option
	Use this option to enter the lumber yield by grade from each log individually.
	There is an individual entry table for each log in the study (up to 30). Boards from each log are entered individually. Select the grade of each board from the drop-down list. Enter the board’s thickness in inches and hundredths of an inch (e.g., 1.25). Select the surface measure of the board from the dropdown list (1 to 20). Note: The surface measure is the width of the board in inches and fractions multiplied by the length in whole feet divided by 12.
	Lumber - Detailed Report
	The detailed report section is compiled only if you used the ‘Lumber-Detailed Option’ section to enter the yield of each study log individually. A one-page summary of the entire yield is provided, along with individual reports for each log. Note that the report may have extra blank pages is less than thirty logs were included in the study.
	This report can be sent to any connected printers or printed to a PDF file format.
	Printing & Saving Reports
	Use the “Print This” button at the bottom of the screen to print the Batch or Detailed reports. This will give you the option of sending it to any printer connected to the device.
	To save the report as a PDF file, use the Share Button at the bottom of the screen. Select ‘Options’ at the top of the screen and then choose PDF. This will then give you the option of sharing the report as a PDF file in a text or email or to a file sharing service such as Dropbox or Google Drive.

Setup


Enter Mill Name


Mill Study Title


Enter Species Name


Select Log Rule


Log Grade	Price per
(name)	MBF ($)


Lumber	Price per
Grades	MBF ($)






		1
		2
		3
		4

Sawing Cost
($/MBF)	(typically $150-250/MBF)

¹Cus1 Grade Explanation


²Cus2 Grade Explanation


³Cus3 Grade Explanation


⁴Cus4 Grade Explanation

Logs


	Log Rule:	Log Grade:

	small-end diameter	large-end diameter	LGTH			log
	(0.0 inches)	(0.0 inches)	(feet)	BF	CF	cost
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Lumber - Batch Option

Enter Lumber Yield by Grade Below (light blue cells)
Report shown Below - Send to printer or print to PDF

Lumber	enter yields below
Grade	BF













Batch Lumber Yield Summary Report
Mill Name:			Study:
			LG
Species:			# of logs:
Log Rule:			Log MBF:
			CF (all logs):
Lumber Yield (MBF)			CRR:
Lumber Value			LRF:
Log Cost			Over-run:
Sawing Cost
Net Revenue

Lumber			% of
Grade	BF	value	value










Totals

Lumber - Detailed Option


1	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

2	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

3	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

4	Species:
	Log #
	BF
#	Grade	Thickness 1.00	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

5	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

6	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

7	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

8	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

9	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

10	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

11	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

12	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

13	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

14	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

15	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

16	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

17	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

18	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

19	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

20	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

21	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

22	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

23	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

24	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

25	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

26	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

27	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

28	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

29	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

30	Species:
	Log #
	BF
#	Grade	Thickness Thickness	Surface Measure Surface Measure
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

Lumber Detailed Report

Send to printer or print to PDF

Lumber Yield Summary Report
Mill Name:			Study:
			Log Grade:
Species:				# of logs:
Log Rule:				Log MBF:
				CF (all logs):
Lumber Yield (MBF)				CRR:
Lumber Value				LRF (bf/cf):
Log Cost				Over-run:
Sawing Cost
Net Revenue

Lumber			% of
Grade	BF	value	value		Descriptions:
					Cus1 Grade:
					""

					Cus2 Grade:
					""

					Cus3 Grade:
					""

					Cus4 Grade:
Totals					""





Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals


Species:		lgt ('):		Log Cost:
Log #		dia ("):		Lumber Value:
LG:				Log Volume (MBF):
Grade	BF	%	$	Lumber Volume (MBF):
				Log Cubic Feet:
				CRR:
				LRF:
				Over-run:






Totals

Terminology


		Terminology
	BF	Board Foot; equal to 1" thick x 12" wide x 12" long
	CRR	Cubic Recovery Ratio; The portion of the log that is sawn into usable lumber; Expressed as a percent
	LRF	Lumber Recovery Factor; A measurement of the yield of lumber in relation to the log that was processed; Calculated by dividing the sawn board feet by the cubic feet in the log
	MBF	Thousand Board Feet
	Overrun	The amount of lumber sawn in excess of the board footage scaled in the log; expressed as a percent
	SM	Surface Measure; The surface measure is the width of the board in inches and fractions multiplied by the length in whole feet divided by 12

Installing this App

To install, simply save the mobile website to your home screen.

iPhone

Creating Home Screen Bookmarks | Surfing the Web on the iPad | InformIT

Android

About

The Sawmill Badger - Hardwood Sawmill Analysis Tool is brought to you by the Wood Products Program, University of Wisconsin-Madison Division of Extension; the Forest Products Services Team, Wisconsin Department of Natural Resources; US Forest Service; Northeast Midwest State Forester's Alliance and Northeast Forests, LLC.

In accordance with Federal law and U.S. Department of Agriculture policy, this institution is prohibited from discriminating on the basis of race, color, national origin, sex, age, or disability. (Not all prohibited bases apply to all programs.)

To file a complaint of discrimination, write USDA, Director, Office of Civil Rights, Room 326-W, Whitten Building, 1400 Independence Avenue, SW, Washington, DC 20250-9410 or call (202) 720-5964 (voice and TDD). USDA is an equal opportunity provider and employer.

The app should be used for informational purposes and provides no guarantee of financial success.