 Hi, I'm Mark Wachacek. I'm a retired area resource conservationist from Rooking, South Dakota. I'm currently a contractor for the NRCS and I am the primary developer of the Windbreak Workbook. It uses the USDA Natural Resources Conservation Service Windbreak Standard and Technical Notes as its basis. NRCS and its Plant Materials Center in Bismarck, North Dakota, along with South Dakota Conservation Districts, have been working with Windbreaks for more than 80 years. This knowledge and experience along with the experience of other foresters in the state are what makes the Workbook a valuable resource planning tool for both Windbreak Establishment and Renovation. The Workbook is also a source of technical information helpful in developing a plan that will contain species adapted to your soil and your climate. In addition, it contains information that will assist you in maintaining the Windbreak during and after establishment. Next, I'd like to introduce you to Nathan Kafer, a presenter in the tutorial. Nathan. Thank you. Yes, my name is Nathan Kafer. I am a agriforester for the state of South Dakota Department of Ag with the Resource Conservation Forestry Division and through agreement with the National Resource Conservation Services and South Dakota Department of Ag, I am also the NRCS Forester for the state of South Dakota. I work with local conservation districts, NRCS staff, and private landowners to utilize the Windbreak Workbook. It is a tool to help with designing specific windbreaks in the state of South Dakota. Next is a presenter within this workbook, Ryan Forbes. Thank you, Nathan. Like Nathan said, my name is Ryan Forbes. I am the Area Resource Conservationist of Technology in Brookings, South Dakota. I cover 22 counties in Eastern South Dakota. One of my primary tasks in my job is to help conservation planners look at our technical standards and try to figure those out when it comes to what meets the practice standard and when it comes to documentation requirements. The practice we're going to be talking about today is Windbreak establishment 380 and with that Mark, let's see how the workbook works. So I'd like to go through the basics of the Windbreak workbook with you and when you open the workbook up, it opens up to the menu page and this is very intuitive that we have tabs that these links take you to and we'll go into a couple of them just to show you how that works but these tabs are useful for doing various portions of a windbreak plan or a renovation, have lots of technical information and so on. So just to show you how that works is if I click on instructions, it'll take you to a full instructions page that goes through all the instructions of the workbook. You can read them, you can refer to them if needed. I won't go through them in detail here but to show you that there are different buttons or links on every page and usually we have a menu link that takes you back to the menu we were just on. We have a return button which takes you to the previous screen you were just on and then occasionally there's other buttons like to pop into the tools section or so on. So I'm just going to go back to the menu in this case and I'll jump into one more of these. The establishment link takes you to a windbreak establishment. Now if you're going to plan a new windbreak that's the page you want to start on. It has the front page of the CPA 6 and you can go into that here and you see you can click that link and it pops in here and you can come back to that establishment page back to the menu either one with the links. There's the back page the 6E2 that has actually the rows and the species and links and so on and then it has a 6E3 which is a additional back page in case you run out of room on page 2. Obviously then there's this order and cost list we'll get deep into that and I'll show you the example here very soon. So I'm going to hit the return to go back to the previous screen I was on and I'm going to go back to the establishment page and I'm going to go back to the menu where I was and I will go just to show you a couple other things here there's the renovation tab link. Technical information has a ton of things on it we'll go through that more in detail but for design, technical notes, fact sheets, general information, videos, it's got a ton of information there for you. So that I'd like to also add that there's a link to this video that you're watching here now in case you want to watch it again as you open this up and there's also a link to our NRCS's website where you can get the latest version of the South Dakota CPA 6 the windbreak workbook and so you just click on that and you would download the latest version if you think your version is out of date. So that's a quick overview of the spreadsheet and the the basic places that you can move with the different links and so on. The data entry example that I'm going to show you is going to be very useful as you learn how to enter your data into the spreadsheet for establishment windbreaks. So I'm going to open up I'm going to show you how that works. Open up the tool and if I go to the establishment tab there is a shortcut here to the example of the South Dakota CPA 6 E2 and showing this I think will help you understand the easiest simplest quickest way to enter your data and it works really well. It looks complicated it's not I put in here these notes and I've numbered them and if you follow the order of the numbers as you enter your data this will go real fast and easy and when I'm done showing you the example page you will do a real quick windbreak and show you how easy that is but the first thing you would put in is your site number and it says number one so actually site number would be the first thing you put in the second thing you'd put in is the conservation tree and shrub group and you'll notice that the cell is white and the other cells below it are green there's a purpose to that white cells don't have formulas in them green cells have formulas in them I've kept the spreadsheet unlocked so that you can overwrite the formulas if needed but they make the data entry so much faster and easier uh if once you do a few plan a few windbreaks you'll notice that generally the conservation tree and shrub group is the same for the entire belt that you're planning so this just simply repeats it throughout the entire belt but to get back to the order in which you put these in you'd put your site number in then you put your conservation tree and shrub group in and then you'd put your isolation width in so you're moving left to right but then you'll skip over right away the between the row spacing and you'll number your rows one that's number four there you'll see in the comment five and six so you put one two three four five six you put your row numbers in when you have those entered then you'll come back and put your between the row width in and it will auto populate the rest of the belt for you okay so that's that simple then next thing you'll do is you'll put your first species in then your second species in and third and so on until you have your belt populated with the species names the button here as we move left to right this checkbox can show you with a green check mark whether these species are adapted to your conservation tree and shrub group the two things that you need to make sure that you have on turned on or filled in is you need to have that check mark checked you need to have a tree and shrub group entered and you need to have an m l r a entered okay this new version of the spreadsheet lets you click a button and i'll show you that in a moment where you can then enter the mlra right here generally the mlra gets entered on the very first page the six e one as you fill out the the main page of the South Dakota CPA six so we'll go through that in a minute when we make our quick windbreak example up so moving moving on so i've got a checkbox here that if i have the top one checked it means that these species in this column will be alternated with the species uh next to it so here for example honey loas honey locust will get alternated with hackberry and calculation wise what that means is this row planned for a thousand feet will have 500 feet of hackberry and 500 feet of honey locust it's split right down the middle 500 fiber so you wouldn't have to plant every other tree as hackberry you could plant five honey locusts and five hackberry and so on so forth throughout that row but it does calculate that half of the trees will be hackberry and half of them will be honey locust so that's the way that calculates it out this is the full length of the row the feet so the next thing you and in addition to that if i don't have that box checked and i check the bottom box then i can use this spreadsheet in a different way i can only use it one of the two ways not both but if i check the bottom box then that means whatever in this column got applied as opposed to what was planned so and then what this would mean is and we ran we didn't have the honey locust but we substituted them with hackberry and so hackberry actually got applied in row three for a thousand feet so i don't have to use this column at all if i'm not going to alternate or use it as a record of application um but in this case we're gonna in this example we're going to say they were alternated with these different species so the next thing you put in is your feet it defaults to that number of feet throughout the rest of the belt you can however overwrite these formulas and put in a different number of feet if you had the last three rows were 100 feet longer so you could type in 1100 1100 1100 so you can over type the formulas once you over type a formula formula is gone so you won't it won't recalculate anything based on a formula it will be 1100 feet is what's recorded in there it does the calculation on the rods you don't have to do anything with that it does the calculation on the feet it takes 1000 divided by 4 feet apart and you'll need about 250 plants with the fabric tree tubes and seed seedlings sorry you can enter data there because they're white the cells and so you'd either say yes or no and if you say yes if you say yes then the spreadsheet will calculate that you need 1000 feet of fabric on that roll i have the example locked up so i can't enter data into it that's why we got that uh message there tree tubes is the same way you can say yes or no and yes it calculates tree tubes and when you apply them you can get a number of tree tubes applied um yeah or you can type over those numbers if you if you sell more whatever um then when it comes time to application you would put in your isolation row actually what was applied in this case what was planned was 14 foot and actually what was applied was 14 foot and in this example i did the same with the spacing i used the same numbers as what was planned you would actually measure that out and put the the measured numbers in um here the approximate spacing in roll does change a little bit from what was planned here it was planned for six feet it ended up being five feet when we actually got implanted and so it gives you a little different number on the number of trees applied than it does calculating the number of trees that were planned so you you can put in the approximate spacing you can measure i used to measure a few between the trees and i'd measure enough to get some kind of a statistical number that i could count on and then say measure uh there's 500 trees i would measure between uh them five percent of them and that usually would give me a the average of that number between each tree would give me a a relatively good number of how far apart they got planted on the average the length and feet might be different than what was planned so you can put that in it will default into that number above uh on the rest of the belt but you can type over that number if each row is different it calculates the rides it calculates the feet of fabric based on the feet of the length of the row and it'll if you turn this check mark on it will actually tell you how many tree tubes because that calculates based on the number of trees and it'll calculate based on the number of uh of plants that were in that row based on the feet applied in the row spacing so that's a quick overview of uh how to enter your data then of course this will give you totals of feet and rides and approximate plants planned and fabric feet planned and so on so that's real handy in your planning the acres planted just to show you how that is calculated real quick is so i drew up a little chart here just to show you what it does is it looks at the isolation being 10 feet wide and then half of the 14 feet spacing between rows so really this is 10 feet and seven feet and that's what this formula comes up with 10 plus half of 14 times a thousand feet long if the belt was a thousand feet long that row is a thousand feet long that would give you a number of square feet 17 000 a matter of fact and it does that for each uh row and each side of each row gives you a square feet number adds all the square feet up and divides by 43 5 16 gives you a total acres so that it shows you what the calculation how the acres are calculated in uh in this spreadsheet so let's um do an example uh a quick data entry example uh after I show you just a couple of other things if you were doing a uh twin row high density here's an example of how to do that you always have between belts you have to skip two rows then start your next row with an isolation and it's the same process as above your site number your tree and shrub group your isolation then your row numbers your then you come back and put your spacing in so with a twin row high density you'd have a small distance between trees and then you'd have a much larger distance between that twin row then you'd have a twin row again with a small distance between and so you can see how you would set up the twin row high density data entry in the spreadsheet and then a single row that's pretty easy to figure out you'd only have isolation you wouldn't have a between the row spacing there is no between the rows so that's the way all that works um and with that we'll do a quick three row example next complete a three row example to demonstrate uh how easy it is to use the spreadsheet and how an windbreak establishment uh data entry works so you go to the establishment and to be honest with you I won't fill out the front page of the 6e uh you would normally want to do that but in my example I just want to show you that there are two spots that carry over from the 6e and one's the mlra so you do want to tell it uh what mlra you're in you can be in anyone in south dakota here and I happen to have chosen 102a because that's the one I'm in uh today and secondly if you enter whoops excuse me if you enter the section township and range up here it carries over also so we're in section three uh making this up 112 54 I don't that's a record keeping thing but if you those are the two things that line there that carries over to the six cpa 6e2 so I'm going to go back to the establishment page and go into the 6e2 I can also just click the tabs down here and move around so you'll see that ml mlra 102a came in here okay and I'll just show you quick at the bottom section 301 1254 came in here so just to show you that quick so let's get started let's move through here site number one happens to already be populated I I leave that populated when I start conservation tree and shrub you can get this from uh websoil survey and we've got another video that shows you how to do that I believe Ryan Forbes is creating that so I'm going to say I'm in windbreak suitability group three here my isolation is uh 16 feet and remember as I walk through you I told you the next one you want to enter is a row number so I'm going to do a three row windbreak one two and three well then that this cell popped white and so now I'm going to put the between the row spaces spacing excuse me is four or 14 so now it automatically populated you know the bottom isolation the second between the row spacing it does things for you to speed up your planning so now I'm going to put uh some species in here if I click up above this bar it jumps up one screen at a time so if I'm looking for something I can move through them pretty fast I know I'm looking for amber choked cherry and so I'm going to get up here and there's the species I want my second row uh is going to be Manchurian crab level I don't pay so much attention to um the species I put in here but because I'm just showing how data entry works more than anything I'm going to do common lilac so I know it's towards the top so there's common lilac I am I want this button checked so I can see if they are recommended for 102a in windbreak suitability group three and I'm good on all of them so I'm confident that these species are the right species that will grow so when I get over here I actually want to alternate one of these so I'm going to check the top box here's a little reminder about you know what that box checking does for you the the red triangles always give you information give you tips help you with making decisions and so on okay so I will only want to alternate on the lilac row in my example I want to uh uh do late lilac okay so I'm going to alternate common lilac with late lilac all right so I'm I've already set up most of this um I'm going to say that this is six feet apart that the Manchurian crab apple is eight feet apart and six feet apart so the length of row is a thousand feet and that'll fill all this in for me fill all this in for me fabric nope I'm not going to do it I don't even have to put no in if I don't put anything in it knows no but for an example I'm going to say yes on the tree tubes on the Manchurian crab apple okay so I've created my plan it's got its totals down here 1.38 acres planned it actually has the section carried over and what I can do is if if this is just a rectangular windbreak and it's site one I can just pop pull this up and I can put it where I want to show the planters where the site is okay that's what this is all about uh I also would want to put in the producers it'll carry over the name from the first page I forgot it does some other things from the first page brings over the planting type the site prep that you put in there the program and the practice number so it does bring over quite a few things what you'd want to fill in here is the producer's address the address of the site if necessary that can be useful if you use google maps to find a address that type of thing and the phone home and work in the cell phone number enter all that to be helpful for your tree planting crew when it gets applied you want to put in when it got applied who did the work when the fabric was completed and who did the work so yeah that's the basics of the back page the second page and how fast it can be filled in I'll just quickly fill in to put in the same numbers as I had planned just to show you that uh in the row spacing I'm going to say is the same six eight and six and so I should really 1,000 feet get the same numbers over here as and I want to see how many tree tubes I need so there's 125 so I should get the same numbers on the applied as I do on the planned and I do uh get the same numbers the plan doesn't give you the number of it does give you a number of plants when you alternate plants it's got to make a division it's got to decide if it's 59 or 58 well so that's why those two numbers are one off that is it for the quick um tour of how you put in a three-year-old windbreak real fast in the windbreak workbook I want to make sure I covered everything I showed you how the acres are calculated the totals how the totals go to the page one so at the bottom it will give you the acres planned acres applied feet of windbreak applied that is the length of the wind of the windbreak not the number if if you have five rows a thousand feet long it's not going to give you five thousands going to give you one thousand the length of the windbreak itself okay um yeah and if you run out of room on the page 6e2 you can use 6e3 that's just an extension of 6e2 so that is an example of how to quickly put the information in I am going to leave that information in because I'm going to use that in an explanation when I get to the workbook maintenance section once you have their producer that's contact you has an interested in planting a windbreak or shelter belt on their property you'll have to go out and visit with that producer get their objectives on on what they want done what they want this windbreak to do where they want this windbreak and any ideas on how they want the windbreak to be filled in with you know what tree species do they like do they want fabric you know things like that you'll then have of course the landowner will take you to the spot where he wants the trees you would go out you'd measure the belt measure the length measure the width in most cases you will flag it there then and sometimes you will GPS it so you can bring that laid back to your your office for making a map so you'd have that added to their file but once you have all that done it's time then to take that information bring it back to the office sit down and open up our windbreak workbook the windbreak workbook will is a tool that can help you with designing that shelter belt for that producer the first thing I like to do is when you open it up you're here at the front page most the time our producers windbreaks are planted by the local conservation district and if that's the case if that is the case here you would want to go and scroll over until you get to prices open this up and this will give you an area to fill in the prices for the conservation district each conservation district will have different prices so you have to make sure you get the right ones in some will cost it by rod row most cases it's going to be by by foot fill in for the shrubs fill in for the trees and then determine when shrubs and trees start and begin in most cases it's going to be the six and then you fill in for cost per plant cost per foot you would then move to the fabric part you would put in is it going to be per foot is it going to be per rod row and you have of course your hand plants we are as a producer just going to hand plant them and then if the producer wants them to the next thing then you would go to would be the first page of the windbreak sheet this would be where you would start putting in your your generic data your information about this windbreak about the producer the first place would be your producer's name john hartland here years to be planted would be in 2022 what county is that well going to be planted in and then of course the farm tracker field number if you have those available and then what type of windbreak is this going to be in this case we're going to do a field windbreak you can do a living snow fence riparian maybe a wildlife planting there's a farm said windbreak so there's a multiple different types of windbreaks we can do and then you move over to program program is what posture if any can we get into this landowner that we might be able to help them out with planting this windbreak and you got everything from CRP equip gfmp cc rp in this case we're just going to go if we we got a grant form and then you go to your practice but you know what practice are we using under what practice are we going to put this belt under in this case it's a it's a nearly new windbreak new shelter belts we're going to do a windbreak shelter belt establishment which is a 380 the mra that is trees that can be utilized in our area using the expected year expected heights at 20 year sheet in this case we're going to use the 120 point a if you click on it you can change it to what your area actually is and then of course soils always put your soils down research concerns what concerns are we going to be addressing in this case we're going to be addressing soil erosion wind erosion purpose of this planting again why are we planting this belt for this producer why are we designing it why does this the producer want the belt well he wants it to let's see here maybe protect plants from wind damage but in most cases it's going to be protecting reducing erosion from wind is usually one that is what we're going to do especially with a field windbreak now since it is a field windbreak we're probably going to put it into crop fields so that's where you come down here for present ground cover if we're going to put it in the crop field you must ask the landowner what chemicals were put on that field if it was atrazine you'd have to tell the producer then that we'd have to wait a couple years because atrazine will hold up in the soil most cases it's round up so we're good to go it's already dissipated from the soil by the time we are planting in late april early may grass fields you know those are some other spots that we have you put that down once you these aren't term of the present ground cover you then have to come over is following the one of the crop fields it's already been tilled so not following usually not needed until we are about ready to plant the the trees then a producer would come out and hit it with a disc or a rototiller and break it up so it's a little bit easier to plant so in this case we'll hit no those grass I'd say yes especially haven't been touched a lot of times too when we get out there we don't focus on what's above us we don't don't see those utilities so always look up so if there is utilities present we're going to hit yes we're going to make sure we stay away from those utilities and even though this is a crop field it has been tilled probably multiple times I still would recommend checking your cultural resources it's always a good habit to get into check your cultural resources just to make sure we're we're good there so always always put yes for this so site prep needs if we're looking at a grass field a lot of people would do herbicide then maybe rototiller disc and this tapes we're doing crop so what a lot of people would do would just do a disc sometimes they'll rototill as well and then what type of planting how we plant these trees well at the conservation district they usually will machine plant and in some cases and some types of plantings we will have hand plants so you must click those two and then within row how are we controlling the weeds within the row well and once again in most cases we go with the tree fabric that controls our weeds and we then only have to the producer would only have to then control the weeds within the hole around those trees and then you have between rows between rows one and two housing control in the weeds housing control in the grass in between those two rows a lot of time they do it by mowing so you have your mechanical some do it by herbicide as well and then is there going to be tree tubes and in the second sheet that we show you you'll see that this will get filled in and then are we going to have any fencing is there going to be any fences out there are we protecting this from livestock it's simple mathematical equation will help you figure that out and then always put your name always put your date that you design this belt and then practice certification this is when the the planting has been done and you've actually gotten out there and have certified have checked the site you would put the date you did that in you'd put who planted it so what conservation district didn't meet our standards and then put your name your title and the date you've done that and then once you are out there also you can then put how did you measure it maybe you wheeled it maybe we GPSed it so and then put any comments that you would see out there that maybe need to be addressed but this is after the tree plan has been done and you've gone out here and spot checked it but before we get to that we actually have to design the belt so you'll open it in the second page up to here I've already got it down we're only doing one site in this case so we would then come in here and we would do what our soils was our soils were three we'll put that in there we'll do an isolation 25 you then come over here how many rows are we doing there we go and the isolation moves down and then in between rows doing maybe 14 once that is done we would then have to start picking out tree species what tree species would do nice thing about three soil in a 102 a we are open up to a lot of tree species we can plant so maybe we'll do hazelnut maybe then we'll come in here we'll do Kentucky coffee tree now we want some density out there so let's do a conifer so we'll go with the eastern red cedar then after that well you know what we want a little ecstatic so maybe we'll go with the elderberry you know this is pretty diverse but maybe we want to diversify it and more so we click the little tab up here it'll be alternating with you know the hazelnut we're going to leave alone but the Kentucky coffee tree you know we don't plant very much of it so we're a little leery on it so we're going to come out here we're going to plant a tree species along with it that does well box elder you know maybe the elderberry just you know isn't his thing but he wants something a little bit different in there a little bit better looking maybe we'll go with him on our choke cherry and as you notice we've got all these green checks that means these trees match up with this soil and will be suited to be planted within this soil say we change the soil that we change this to a case oil all of a sudden the tree species that we did choose will not work for this soil type anymore so we'd have to come back through here and change them for one instance you know the American hazelnut common lilac that worked for that soil Kentucky coffee tree box elder doesn't work so maybe we'd have to go with Russian olive and we instead of alternating it we'll just do a single roll of it and then maybe with this here you know we don't have what we can do here we still want to alternate it so maybe we'll do a choke cherry well choke cherry don't work so let's go with caragana well caragana works well let's see what we have to alternate that with one of the trident two ones that will help would be if i can find it silver buffalo berry and there now we have a tree plan where the trees actually match up with the soils um so but once you have all that done you then you're spacing in between the rows in this case a lot of shrubs are four to six russian olive are eight to ten cedars anything after row one always do ten or more and then your caragana your silver buffalo which your shrubs can go for you then have how far you measure that we're going to go 900 feet and it fills it in it shows you then how many trees we're going to need at four foot spacing at 900 feet to fill in that row and so forth and and for all the other rows and then say you know yeah you wanted fabric you wanted to get some fabric in here but say you know the cedar found out that sometimes that fabric will girdle that cedar and he doesn't want to deal with that later down so he doesn't want fabric on cedar so we'll just say no and then tubes you know these trees really don't need to be tubes so we'll just say no on all those and you're good to go once you've filled all this up if you scroll down you'll see how many feet we're looking at planting how many broad rows we're looking at planting how many trees we're looking at planting and how much fabric we're looking at being used how many feet of fabric we're going to be used and of course that's different because we're not going to fabric row three which is the cedar row then of course it gives you your acres as well once you've seen this one thing I always recommend is the fill in your legal description for the site and make sure you double check that because maybe you're not going to be the one that goes out there and spot checks it and they're the person that does it's going to use that legal if you have the wrong legal on there they're going to go to a different spot and then not be able to check the site or if there's no legal at all they're not going to know where they're going in the first place but always fill in your legal it's pretty easy and like I said always double check it and then I always like to put some comments on here because you may be designing the belt but somebody else is probably going to be planting it so and they might not have visited the site so I wanted to give them as much information as possible so we put fabric on all rows except for the cedar so they know they're not going to put fabric on the cedar row tubes and trees and rows too now if we were going with the Kentucky coffee tree or the box elder that's what it would work but in this case we're not so I'd be like tubes one thing I'll do is tubes so no tubes usually say no tubes and then we'll go alternate trees and roll four so that they know that they're going to be switching trees for every planting so then you move down into the address you get the address of the producer and then if the site is a different address make sure you write that down and then you would get the numbers cell numbers that you do the most important because those are the ones that you can carry out along and this was filled out from the front page shows us once again what type it is what site prep's being done what type of program it's under and what practice it is once that is done you then come over here to your map location so it shows you that we're in section 25 now you could take a picture of an aerial photo of a site and snip it into here but it's always best to take that photo make it a bigger picture and attach it to the tree plant itself so then when somebody is looking at it they have a large paper that shows them what you're actually looking at in this case what I like to do is just come down here grab one of these and put it in the box where the tree planting is going so if somebody is looking at this and they're going to plant the trees they say okay yeah we're in section 25 but we're in the southeast corner of section 25 that's where the tree plants are going to go and you can change this to you know maybe it's an angle planting maybe it's east west planting and so forth so that's very nice once this is all done you've got this you can then go over to order list and cost estimate this here will show you what the estimated cost for this planting would be it shows you the shrubs how much your shrubs are going to cost it shows you how much your trees are going to cost it shows you how much it's going to cost you for fabric and gives you an estimated total cost for that which is great for producers they can then see that you can then tell them well we know we're going to get you a cost share it's going to be a 50-50 cost share so you're going to have to pay half of this so then they're like okay yep we can budget for this and move forward once this is all done once you have gotten the okay by the producer make sure you give them a copy of this page the second page order list and a map so then they have those for the records you would then also submit this to the conservation district conservation district will then go out and like i said late april may plant the trees once the trees are planted it's time to go out and do a spot check to ensure that the trees and this windbreak was planted correctly and that's what this site overhears for so once again your isolation you'd measure that be still 25 you're between rows you'd measure between the rows they were still 14 and then you'd measure the trees between each tree for each row so the lilacs yeah we're still at four rush all those at 10 sears are at 10 and the uh alternated tree species were also at four so you put that down then what feet so yeah you know we had 900 feet let's say we got down to row three and you know we we uh landowner had a little change he didn't want to go the full length anymore so maybe we were only going to do 800 for rows three and four we change that that still gives you how many rods we planted how many feet you click this i'll give you how much feet of fabric was used once again was there any tubes used no if there was tubes used this would change then if you know so the feet of fabric because we're not fabricing the charrette cedar that's still zero but it still tells us to how many plants were planted and then once again you come down shows you how many acres were planted how many feet how many rods how many feet of fabric how many plants and then if you look on the front page once again it shows you how many acres was planned how many acres was applied how many feet of fabric was applied how many uh feet of windbreak was applied per row and then tree tubes and then also if you went to the order list and cost estimate down here at the bottom it would tell you how much that was actually cost so then this would all then be filed away it would show that you've already checked it so then if records were being pulled you'd have them and say yes i checked them on such and such date this tree planting is good to go they can get their cost share and you'd be perfectly fine all right i'm going to visit with you about the south coat of cpa six r1 and r2 tabs in our in your workbook at this video has been about so where does the six r1 tab come from well it comes from the conservation practice 650 windbreak shelter belt renovation which is completely different than 380 shelter belt establishment these two practices are extremely different on how you approach them and how you need to uh to apply them on the landscape to uh to make them both successful so that being said i'm going to show a quick powerpoint to demonstrate the practices windbreak shelter belt renovation it's conservation practice 650 okay it's located in the field office tech guide like all our conservation practices section four is where it's located underneath the 650 cps conservation practice standard very very different than the windbreak establishment 380 this practice can be much more difficult to get onto landscape and 380 because you're dealing with existing trees some trees roles that will be good some that will be need to be completely removed maybe some type of management activity can be done with some of the roles that are there there'll be building sites around there'll be all kinds of issues with the windbreak establishment our windbreak renovation by definition you're just replacing releasing or removing selected trees or shrubs within these existing windbreaks could be adding roles or selecting some type of management you know to revigorate some roles or do things but at the end of the day your purpose is to restore and enhance the original plan function of the belt infiltration requirements so where does the actual 6r tab that we're going to be talking about here in a little bit come from comes from our infiltration requirements of completing the conservation practice standard so this is how we document what's out there what we're planning on doing and how we sign off on the actual practice that's where the 6r tab comes into play the 6e tab is if you're going to plant new trees in that area that's where you would use that tab in our workbook Woodland Techno 42 41 rather it's located underneath this section filled off this section one underneath technical notes underneath the Woodland Techno Woodland tab okay so topics covered in this are planning considerations like I said there are a lot of planning considerations deal with with these farm said windbreak renovations some different techniques that would be covered like tree removal replacement any improving and coppicing so take a look at the Woodland Techno 41 in the field office that guide underneath section one some key planning considerations to get this practice done this practice could take several years years to complete so be very very patient from the planner side and the producer side what are the objectives of the practice most of the time most producers do not want the entire belt gone because that's their protection so it could be phased out over years and you got to take that into consideration the proper site prep must be done it has to be done with these so removing all the old dead debris level in the land out everything needs to be done for that tree planner to go in there and plant the tree successfully straight without impeding the machine going down there and the fabric machine as well so it has to be done if the site is not done the right way do not plant the trees because you'll have a disaster have a very detailed map right uh right from the beginning an aerial imagery where you can draw where these trees are at the length the species have everything on that map because you really you get a snapshot in time what that's going to look like make sure you get accurate lengths immediately when you're out there on site you need these links because there's no way of going back and re-measured it after the dozer comes in there and destroys all the roles that you're taking out there's just no way to do that you can't measure something that's not there so make sure you get an accurate measurement here's a example what a detailed map may look like so here here's an example for dozer dogwood eastern red cedar roll is good 500 feet long the dogwood roll we're going to do some coppicing on that one Chinese elm we're going to remove and replace there's 500 feet of that green ash remove and replace scotch pine remove and replace and we have an unknown roll we just can't tell what it is we're going to move and replace that a map like this is vital to really set what is out there so you know where you're going to go in the future with each of these roles and someone in the future that's going to be planted them they can have some perspective of what it looks like from the very beginning because when they get out there to plant the new trees or new rows this can look very very different other key planning considerations culture resources they are a must when it comes to shelter power renovation inside these old tree belts you're going to find old buildings machinery vehicles if you can name it you will find it in there is there historical significance to these things you need to know that that's why your culture resource training comes into play work with your culture resource resource specialist on case by case buildings they may ask you to take pictures they may come out on site with you visibility can also be an issue when you're doing your surveys look up are there existing power lines running through the existing trees as the producer is there very power lines somewhere because you're going to be in there with a dozer and cat and digging down a little bit so are you going to run into any of those things so always take power lines and consideration especially around the farm site county zoning are you going to be able to plant new trees you better have that figured out before you go in there tear a bunch of them out if the county isn't going to grandfather you be able to plant them right along that road right along that existing farm site a grandfather in clause or something like that threatened endangered species always something we need to consider one particular species like the northern long year bat in this practice you're probably going to be doing some type of removal alteration or you're burning wood of the trees or shrubs right the active season for the bat is from May 1 to October 1 so so these type of activities cannot occur between those dates so you're going to have to work with the nrcs state biologists in coordination with us fish and wildlife to see if fish and wildlife can say yes the producer can remove the trees at the end of June that type of thing job approval authority also comes into play with this practice plan a few practices with supervision right away because this is there is no site that is going to be the same uh six fifties they just are not a cookie cutter deal what like a 380 can be so do a few of them under supervision with your local district conservationists or a planner that has done these for years why is job approval authority needed it's needed to certify off on the practice and i'll show you where you certify off on the practice on our six r1 tab and also remember partners can obtain job approval authority for this practice that being said let's jump into the worksheet here are the instructions for the form shows you the highlighted areas here in red and what needs to go on those blocks so when in doubt come back to the instructions for the six r form or tab in this workflow here's the six south dakota cpr six r1 make sure you fill in all the the tabs so we got joe farmer anywhere in south dakota i'm doing the assistance here could be a program may not contract number store that in there if you know that make sure you get your section township in range and what type of what type of windbreak are we doing there's all kinds of livestock windbreak living snow fence and we're just doing a typical windbreak renovation renovation objective right that's getting back to our planning process and understand what the objective what the farmer or rancher or producers objective is to fix this tree belt what what is going on out there what type of methods are we going to use well in my example here today we're going to talk about role removal replacement encompassing here's an important deal if we're going to be planting new trees and shrubs in the planning we're going to be using the six e tabs right for establishment getting back to 380 that type of thing okay all right so we've already went into our woodland technical 41 and we reviewed a lot of these renovations methods in that a woodland technical 41 is going to speak to sidebound trees and shrubs how to release those supplemental plantings reinforcement plantings doing some underplantings role removal and that's what we're going to do in our example today thinning pruning and coppicing and we're going to do some coppicing but there's pruning and thinning as well natural regeneration and root pruning so there's all kinds of different methods when it comes to renovation once again a very different practice than the establishment location of the map and what are we going to do for planned maintenance after our renovation and this complete we're going to put some mulch or fabric down mowing between the rows and replant the dead stock if needed we got some notes we could put down here and here's if you have job approval authority once the producers went out there and removed all the things that we need to do do the maintenance on the rows you could sign off on the practice and meet the standards and specifications and we have some graphics down here where you can pull that up here to the map site one with our north arrow all these little sevens, eights, nines and tens back to your directions that corresponds with those numbers so that's where those numbers are coming into play all right so let's go to two South Dakota's SR2 so here's our site try to do this the best that you can once again these sites are going to be completely different they will not be the same and more likely this approximate linear feet could go anywhere from 500 to 380 to 270 there could be all kinds of differences in there but try to to figure out what was actually planted out there and you can go back a lot of conservation districts will have old records old tree plantings they keep those over the years and that might be a starting point to determine what's out there we're just knowing your species so have a wheel or a GPS or something out there and to try to figure out your isolation your isolation goes here into space on our example here we figure right around 14 foot between row spacing and our isolation our north row starting from north to west here's our our dog would we figure is right around six foot in row spacing 500 feet is a roll functioning in this in our example we're going to say yes it is and our method of renovation is going to be some competency okay so we're going to go out there red dozer dogwood is a great species to do this I've done this in the past where you cut them off really early late winter early in the spring not all the way down to the ground and they will resprout and come up and it a couple years it looks like a brand new roll of red dozer dogwood row two eastern red cedar right around 10 feet 500 feet long we're not going to do anything with this particular roll because it's pretty good shape yet and we're not going to put it on our South Dakota CPA 6e form here on our here on our establishment because we're not planting a new roll there Chinese now we're going to take that one completely out there's only a few of them left in there and we're going to plan this particular roll on our new plan green ash the same thing just a few of them left and we're going to plan that on our new plan scotch pine the roll is completely gone but the one that we that are out there we can see they're right around 15 feet about 500 feet again the roll is not functioning and we're going to remove it so you do have different options in here of what you want to do so maybe you want to thin this roll thinning for future under planting so there's all kinds of tabs in here that allow you to do what you're going to do out there unknown roll that you can run into this a lot with these shelter belt renovations absolutely if you don't know the roll you don't know the roll but it brought the approximate space that it was planted if there's a few species still there the linear feet is it functioning and we're going to replace this particular roll if you need to add a list you can come back into here and you can add a different species but there's a quite a few lists in there and there's a return button to go back to where we were if we scroll down we'll see our approximate length rods and how many plants and about the approximate acres you can put some comments in here I went ahead and did this as the wind breaks over 40 years old the first two rolls are so good rest rolls seem to be removed and a location map once again you got some graphics that you can pull up in here you could insert a picture into this file a jpeg that type of thing if you wanted to put that map I showed you earlier my presentation always attach something like that to your your renovation r2 tab so people in the future know what exactly how those rolls laid in here this this information is just so vital get this practice on the ground and plan the right way so all these numbers here when we pick copacin or roll replacement we go back to our six hour one those are the two things that we picked here it automatically fills in our distances based on our linear feet remember once again you can't go re-measure this stuff so you got to do this immediately up front so based off my calculations on the r2 form I had 1500 feet that we're going to remove we're going to do 500 feet of copacin out there so that spreadsheet takes it into account from this worksheet over here and back to there so after visiting the site and talking with a landowner and getting their objectives you then take all the information you gathered from that site visit and bring it back to your office to work on the windbreak workbook now as you work on the tree plan you may run into an area where you might need a little bit more information and that's where the technical informational tab comes in handy you're able to go to the menu page down here the bottom left and then come up here says where it says technical information or you can actually just click it here at the bottom of the tab this then brings you to any technical information that is at your disposal so say that you were looking at the species of trees that can go into the specific soil well you have two options on how to get that information the first review that comes to the left here anything on the left hand side that is highlighted blue is within this workbook you would then click on that area and then that would take you to what you're looking for in this case it was the soil so if I was looking for group three soils and trying to get a definition of that they are in this part once you're done with this you then can go to technical information and it brings you back to that single tab now say it was not highlighted say it was like we have here on one lake woodland technical 42 it is not blue you're not able to get to it it's not within this workbook because it's either being updated or it's just not available on for right now you would then go to the right hand side and that is the website in which this tech guide is found in so there's two different ways of getting to that information if it's within the workbook it would be highlighted blue and on the left side and if it's not it would be on the right side it's highlighted blue and you can find it within the web page you can then scroll down and find all types of other information fact sheets informational sheets say you want some information on site prep that is here as well tree maintenance tree protectors if you wanted some general information if you wanted to know more about renovations farm said windbreaks living cell banks living cell fences windbreak establishments and field windbreak that information is here as well we also will have the video down here training tutorials windbreak design examples and so forth you are then able to gather all the information here to make a very diverse and good windbreak for your producer what i'd like to do now is open up the windbreak workbook and show you the workbook maintenance tab and what you can use that to do so i haven't talked about the cost estimate and order list tab yet but i will in a moment but i want to show you that the vendor can enter their prices that they charge into the into the workbook and using those prices it will give a reasonable cost estimate and it actually will fill out an order list and you could load your truck with these with the trees for that person's planting so it's pretty helpful actually having worked with conservation districts who planted the trees when i was in the field they really could like to use this type of a thing have a list of trees that could be pulled out and loaded up for particular planting so let's take a look at this quick about entering your entering the vendors prices so i've got about four major ways that you can put in your prices i know that conservation districts other vendors they can charge a hundred different ways so this isn't meant to be a billing sheet or anything like that when you get done it is meant to give a general estimate so let's just go through what you can do with this you can do a per rod roll a charge and you put that in here or you you can put in a cost per foot and these two are based on if you split shrubs and trees using two different costs so let's do the per let's go up here and and uh well look at what we've got right now cost is per foot so the vendor charge is for trees and planting per foot is i've got in here 31 cents and you'd fill in what cells are blue so this wants to know per foot like we're checked here what's your charge for trees and planting then what's your charge for shrubs and uh excuse me up here shrubs in planting is 62 cents trees and planting is 31 cents but the difference between shrubs and trees is the shrub rate is going to be used for all plants within row spacing equal to or less than six feet so you can edit that also all right now if i check cost is per rod roll the setup is the same except it's going to ask what's the charge for shrubs and planting per rod roll you put it in the blue cell here um and charge for trees and planting per rod roll and again what's the the spacing uh in feet that we're going to use to differentiate a tree from a shrub all right so that's the difference between checking those two boxes one's rod roll one's uh per foot and it's a separate separate charge for shrubs separate charge for trees what if my i just have one cost per plant okay then i would come down and vendor charge for all trees and shrubs it doesn't matter if their trees are shrubs and planting this is excuse me this one's per plant this one down here if i check this one is uh it's for all trees and shrubs doesn't matter what they are per foot so those are the four different ways you can put in your charge for trees and planting shrubs and planting that type of thing as you can see i've added a section to the right that will help you determine your average cost of a tree per plant or per foot if you charge in different ways for different categories of trees let me show you an example how this would work and why you do it this way this is definitely optional but it may help you to get uh a better estimate on the cost of a particular planting so let's say that the producer came in you designed a windbreak for them and all of the cpa 6c two one and two pages are filled out so a design has been done so you know how many trees are going to be planted you know how many feet are going to be planted and so on but let's say you're the vendor the district or another vendor charges differently for conifers and for deciduous trees to plant the way this works is if you're charging either is by per plant or by per foot you check one of these boxes and we'll just use per foot uh this time that seems like a fairly common way to do it and instead of point three seven as our cost let's say that in this particular tree plan we plan to plant 4 000 feet of conifers at a price of 50 cents each and we're going to plant 8 000 feet of deciduous trees and shrubs and our price that we charge for those are 45 cents each so what this does is calculates the average cost of all of the trees per foot and gives you the answer here and wants you to enter that value here now when you go to the cost estimate and loading form it will be using this cost for each foot that's being planted and it'll be a more accurate cost estimate so i just wanted to show you that part new part that i've added recently and hopefully that might help you if you're district or your vendor charges that way all right you can also come down here and charge per rod or per foot for fabric and put in your number in the blue cell cost per foot or rod roll for fat i said that fabric and then how much use you charge for hand plants and trees tube stakes and insulation there's a place to put a charge for that so with all of that i'm going to go back i guess and put it the way i had it set up because i got numbers in there and we're going to charge by the foot but we're going to charge different for shrubs and trees and when you're all done putting in that information you can go back to your menu or workbook maintenance section so yeah that's how you make changes in that so let's go back to our example and we had remember put in um whoops i'm on renovation i want to be on establishment we put in this small three row windbreak we said how many trees were planned we said what was applied if you remember that so let's go over to the order list and cost estimate just to see how this works we have our costs in now and we have feet equal to or less in spacing how many feet of shrubs and planting were planned how many feet of trees and planting were planned and what the cost per unit is that comes right from the information we just put in here's the estimated cost okay then also it gives you an estimated cost for fabric tree tubes and hand plants totals it up it tells you the acres are planned total feet planned and plan cost of tree shrubs and planting and then it gives you a cost per foot average of this whole thing 51 cents then there's a section for applied this goes through the same kind of calculations and tell you what because sometimes applied is different than planned so let's just look at how this works so if i go back here and i'm going to pick out remember it split 2000 feet of shrubs 1000 feet of trees if i go back to the place where i put prices in and i'll just jump over to that tab and i check that i want to just do cost is per foot okay and it's 37 cents per foot and i go back to my cost list cost estimate and list now there's only one line in here 3000 feet 37 cents and there's my estimate so that's how this changes depending on what prices that you put in okay show you one other quick thing here so oops let me go back to this and show you that remember we alternated common lilac and late lilac so i need half of each tree 84 trees in my planning for each because the entire length of the row is split half lilac half half common lilac half late lilac so let's go back and and look at the six two e and say what if i didn't have that alternated with and i was just using this column as applied i instead of common lilac i applied late lilac okay how would that look on my uh order list okay well it's going to tell you to load up 167 common lilac in the because that's what was planned but when we get to applied it actually applied 167 late lilac so that's how that understands the difference between applied versus alternated with and so on in this sheet okay um so i want to show you another thing let's go back to the menu here let's go back to workbook maintenance let's change a species name edit species list for establishment so here's the establishment list okay establishment list here's a renovation list you might want different trees in your renovation list why because renovation deals only with what was there what what belt are we renovating what was in what was in row one what was in row two so maybe chinese elm was in row four well we'll never have chinese elm planted in our establishment trees so that's why the two lists might be different but let's say uh kind of common over in eastern south dakota we'd like to have uh myers spruce in my list in my drop down list to select from to be planted you can get a variance for that we generally have in the past so you must click this before you uh get done uh with this sheet shoots you back into the 62 if i wanted to add another species uh well is myers spruce in my list actually there it is myers spruce is now on my list but i must say one thing to you is it's going to give you a red x why is it going to give you a red x because we never told it what conservation tree and shrub group it's um suited for and what mlra's it's suited for so it doesn't know so any that you add or change the name on are going to have red x's and if you do a lot of that you may not even want to have this turned on because it doesn't really reflect the the true answer personally i'd leave it on knowing that myers spruce gives me a red x that's kind of uh a bit of a reminder that hey this one isn't currently on the list what list am i talking about i'm talking about the um let's see 20 year height of recommended species so you would not find myers spruce on this list of tall trees and that would be a evergreen at the bottom here myers spruce is now on the list it hasn't been added by nrcs at this point i assume it eventually will um but right now it hasn't so that's how that works i'm looking let's see renovation list uh anything you add will end up on the renovation drop down works the same way okay but it doesn't check to see if that was recommended because we're not looking at that we're just putting down what species are in those old rows that we're going to renovate the next section we're going to cover and our training today is about the tool button so when mark designed this spreadsheet about every single tab when you go through this you'll notice that this tool button is here so it really doesn't matter what tab i guess if you will you go into you can always pull up this tool thing i guess i always stick with the instructions page when i'm trying to get to the tool well let's just go through a quick quick some of these features on this tool button so we have a print and save which is pretty self-explanatory so you can print nice thing about this print option what he put in here is that you can print a couple different pages of the of the 6e or all three pages of the 6r that we covered in this well video cost order document or document uh estimate the and uh example that mark has put into the spreadsheet as well so a couple different options and you just hit the print button and it'll go through save the file so you can save this to file save it to your computer uh save it to a jump drive do whatever that you want with that okay so this is uh two uh these uh worksheets here south dakota or the recommended species the height of 20 years so these worksheets are are put in here so you're able to look up the species and then look at through the the soils and that so when you're designing your tree has establishment um you know what it's uh what what uh soils that the trees are going to be and what height they're going to be at 20 years and the height of maturity and all those type of things and we have it for east eastern south dakota east central and western south dakota edit edit prices so you can go in here if you want to edit this for your conservation district if they do it by rod roll if they do it by trees or shrubs you can go in here and put the the prices in here and for an estimate for the producer same thing with the cost order estimate here you can come in here and it'll give you all your your estimate and you'll be able to print that off for the producer some more design stuff a lot of this stuff comes out of the woodland technical 42 arrangements so when you're designing your belt it's just a quick tab to go down through some information in here about the role arrangements and all those type of things and how it should look your spacing um and uh densities and things of that nature setbacks there's a map in here kind of a diagram uh this is more of a farm site I guess if you will talks about secondary windbreaks primary windbreaks and that and distance and setbacks and all that nice diagram for an example the example the mark's put into here so you can see how it's supposed to look so you make sure you get everything in the right spaces and columns and all the drop downs tree shrub groups let's go through what each one of the groups can do and what is the issue with each of these groups some good information there and then of course the video so this is the obviously the video that we're working on right now isn't in here yet but it will be down here um it'll have uh mark's part uh my part and then Nathan's part and mark will break this out into sections so you just will be able to click on different sections on this so you don't have to watch the whole thing if you just want to watch bits and pieces of it thank you for watching this video about the windbreak workbook we hope it was valuable information and that it will help you be able to figure out how to write a tree plan effectively and efficiently our contact information will be in the next slide thanks again