JRC_Design
New Member
- Joined
- Jul 10, 2018
- Messages
- 4
Hello Everyone! I'm a landscape architect and part of my job is working on Tree Preservation Plans. Basically what I'd like to do is input the Species, DBH, & ACTION (In Yellow) and have it populate the cell (In Green) based on the category in F3:N3 (Significant Trees, Heritage Trees, Etc..). The categories table has been attached as well.
I'm usually able to solve my Excel issues but this one is a bit over my head. I'd appreciate any solutions or suggestions you may have. Thanks in advance!!
<tbody>
</tbody>
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
I'm usually able to solve my Excel issues but this one is a bit over my head. I'd appreciate any solutions or suggestions you may have. Thanks in advance!!
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | DESCRIPTION | SMALL TREE / UNDERSTORY SPECIES | TREES | TREES 2.5" TO 6" | |||||||||||||
3 | TREE NUMBER | SPECIES | DBH | ACTION | COMMENTS | SIGNIFICANT TREES: 5" TO 12" | HERITAGE TREES: GREATER THAN 12" | SIGNIFICANT TREES: 6" TO 24" | SIGNIFICANT TREES: 10" TO 24" | HERITAGE TREES: GREATER THAN 24"+ | |||||||
4 | TO REMAIN | TO BE REMOVED | TO REMAIN | TO BE REMOVED | TO REMAIN | TO BE REMOVED | TO REMAIN | TO BE REMOVED | TO REMAIN | TO BE REMOVED (3:1 MITIGATION) | TO BE REMOVED (1:1 MITIGATION) | ||||||
5 | 1061 | LIVE OAK | 12 | PRESERVE | 12 | ||||||||||||
6 | 1062 | HACKBERRY | 15 | REMOVE | 15 | ||||||||||||
7 | 1063 | TEXAS PERSIMMON | 5 | PRESERVE | 5 | ||||||||||||
8 | 1064 | PECAN | 40 | PRESERVE | 40 | ||||||||||||
9 | 1065 | HACKBERRY | 28 | REMOVE | 28 | ||||||||||||
10 | 1066 | TEXAS REDBUD | 8 | REMOVE | 8 | ||||||||||||
11 | 1067 | BUR OAK | 6 | REMOVE | 6 | ||||||||||||
12 | 1068 | MESQUITE | 17 | PRESERVE | 17 | ||||||||||||
13 | 1069 | LIVE OAK | 24 | REMOVE | 24 | ||||||||||||
14 | 1070 | TEXAS MOUNTAIN LAUREL | 12.5 | PRESERVE | 12.5 | ||||||||||||
15 | 1071 | TEXAS PERSIMMON | 13 | REMOVE | 13 | ||||||||||||
16 | 1072 | MONTERREY OAK | 4.5 | PRESERVE | 4.5 | ||||||||||||
17 | 1073 | ANACACHO ORCHID TREE | 3 | REMOVE | EXEMPT | ||||||||||||
18 | 1074 | CHINABERRY | 20 | REMOVE | INVASIVE - EXEMPT | ||||||||||||
19 | 1075 | SALT CEDAR | 26.5 | REMOVE | INVASIVE-EXEMPT | ||||||||||||
20 | 1076 | MESQUITE | 2 | PRESERVE | EXEMPT | ||||||||||||
21 | |||||||||||||||||
22 | SUBTOTAL INCHES | 5 | 8 | 12.5 | 13 | 12 | 6 | 17 | 15 | 40 | 24 | 28 | 4.5 | ||||
23 | TOTAL INCHES BY CATEGORY | 13 | 25.5 | 18 | 32 | 92 | |||||||||||
24 | |||||||||||||||||
25 | UNDERSTORY PRESERVATION | ||||||||||||||||
26 | UNDERSTORY HERITAGE PRESERVATION | ||||||||||||||||
27 | |||||||||||||||||
28 | SIGNIFICANT PRESERVATION | ||||||||||||||||
29 | HERITAGE PRESERVATION (1:1 MITIGATION) | ||||||||||||||||
30 | HERITAGE PRESERVATION (3:1 MITIGATION) | ||||||||||||||||
31 | |||||||||||||||||
32 | MITIGATION REQUIRED | ||||||||||||||||
33 | HERITAGE MITIGATION REQUIRED | ||||||||||||||||
34 | |||||||||||||||||
35 | No category to fall below 20% preservation; | ||||||||||||||||
36 | Preserved- Tree to remain that meets root protection zone requirements described in section 35-523 of the UDC. | ||||||||||||||||
37 | Mitigation 1:1 for significant trees below minimum preservation requirements; 3:1 for heritage trees below 100% preservation | ||||||||||||||||
38 | * Small species: Condalia, Redbud, Tx. Mountain Laurel, Tx. Persimmon, Hawthorn, Possumhaw - these are mitigated at 1:1 for Heritage Trees | ||||||||||||||||
39 | ** Ashe Juniper, Huisache, Mesquite, Arizona Ash, Hackberry protected at 10" dbh and mitigated at 1:1 for heritage trees | ||||||||||||||||
40 | *** Mitigation Trees: Unprotected-sized trees to be used for mitigation calculations; subtract inches from mitigation owed | ||||||||||||||||
41 | **** Unprotected Trees: Removed not counted |
<tbody>
</tbody>
TP - EXAMPLE
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIGNIFICANT TREES: 5" TO 12" | HERITAGE TREES: GREATER THAN 12" | SIGNIFICANT TREES: 10" TO 24" | HERITAGE TREES: GREATER THAN 24"+ /// 1:1 MITIGATION | SIGNIFICANT TREES: 6" TO 24" | HERITAGE TREES: GREATER THAN 24" /// 3:1 MITIGATION | TREES: 2.5" TO 6" | NON-NATIVE /// INVASIVE | |||||||
2 | TEXAS PERSIMMON | TEXAS PERSIMMON | ASHE JUNIPER | ASHE JUNIPER | Anacacho, Orchid tree* | Anacacho, Orchid tree* | TEXAS PERSIMMON | CHINESE PISTACHE | |||||||
3 | TEXAS REDBUD | TEXAS REDBUD | HUISACHE | HUISACHE | Anaqua*, Sandpaper tree | Anaqua*, Sandpaper tree | TEXAS REDBUD | CHINABERRY | |||||||
4 | TEXAS MOUNTAIN LAUREL | TEXAS MOUNTAIN LAUREL | MESQUITE | MESQUITE | Arizona Cypress | Arizona Cypress | TEXAS MOUNTAIN LAUREL | CHINESE TALLOW | |||||||
5 | CONDALIA | CONDALIA | ARIZONA ASH | ARIZONA ASH | Bald Cypress** | Bald Cypress** | CONDALIA | TREE OF HEAVEN | |||||||
6 | POSSUMHAW | POSSUMHAW | HACKBERRY | HACKBERRY | Big Tooth Maple** | Big Tooth Maple** | POSSUMHAW | SALT CEDAR | |||||||
7 | HAWTHORNE | HAWTHORNE | FRAXINUS | FRAXINUS | Black Willow* | Black Willow* | HAWTHORNE | JAPANESE LIGUSTRUM | |||||||
8 | Bur Oak* | Bur Oak* | ASHE JUNIPER | NANDINA | |||||||||||
9 | Carolina Buckthorn* | Carolina Buckthorn* | HUISACHE | PAPER MULBERRY | |||||||||||
10 | Cedar Elm* | Cedar Elm* | MESQUITE | ||||||||||||
11 | Chinquapin Oak* | Chinquapin Oak* | ARIZONA ASH | ||||||||||||
12 | Cottonwood* | Cottonwood* | HACKBERRY | ||||||||||||
13 | Crabapple, Texas* | Crabapple, Texas* | FRAXINUS | ||||||||||||
14 | Desert Willow* | Desert Willow* | Anacacho, Orchid tree* | ||||||||||||
15 | Deodar Cedar | Deodar Cedar | Anaqua*, Sandpaper tree | ||||||||||||
16 | Ebony, Texas* | Ebony, Texas* | Arizona Cypress | ||||||||||||
17 | Escarpment Black Cherry* | Escarpment Black Cherry* | Bald Cypress** | ||||||||||||
18 | Eve's Necklace* | Eve's Necklace* | Big Tooth Maple** | ||||||||||||
19 | Goldenball Lead Tree* | Goldenball Lead Tree* | Black Willow* | ||||||||||||
20 | Honey Locust | Honey Locust | Bur Oak* | ||||||||||||
21 | Italian Stone pine | Italian Stone pine | Carolina Buckthorn* | ||||||||||||
22 | Kidneywood* | Kidneywood* | Cedar Elm* | ||||||||||||
23 | Lacy Oak* | Lacy Oak* | Chinquapin Oak* | ||||||||||||
24 | Live Oak* | Live Oak* | Cottonwood* | ||||||||||||
25 | Monterrey Oak | Monterrey Oak | Crabapple, Texas* | ||||||||||||
26 | Montezuma cypress** | Montezuma cypress** | Desert Willow* | ||||||||||||
27 | Mexican Buckeye* | Mexican Buckeye* | Deodar Cedar | ||||||||||||
28 | Pecan* | Pecan* | Ebony, Texas* | ||||||||||||
29 | Plum, Mexican* | Plum, Mexican* | Escarpment Black Cherry* | ||||||||||||
30 | Retama, Paloverde* | Retama, Paloverde* | Eve's Necklace* | ||||||||||||
31 | Red Oak, Shumard* | Red Oak, Shumard* | Goldenball Lead Tree* | ||||||||||||
32 | Red Oak, Texas* | Red Oak, Texas* | Honey Locust | ||||||||||||
33 | Rusty Blackhaw* | Rusty Blackhaw* | Italian Stone pine | ||||||||||||
34 | Silk-tassle* | Silk-tassle* | Kidneywood* | ||||||||||||
35 | Sycamore, Mexican | Sycamore, Mexican | Lacy Oak* | ||||||||||||
36 | Sycamore,Texas* | Sycamore,Texas* | Live Oak* | ||||||||||||
37 | Texas Pistache* | Texas Pistache* | Monterrey Oak | ||||||||||||
38 | Western Soapberry* | Western Soapberry* | Montezuma cypress** | ||||||||||||
39 | Wild Olive* | Wild Olive* | Mexican Buckeye* | ||||||||||||
40 | Yaupon Holly* | Yaupon Holly* | Pecan* | ||||||||||||
41 | Plum, Mexican* | ||||||||||||||
42 | Retama, Paloverde* | ||||||||||||||
43 | Red Oak, Shumard* | ||||||||||||||
44 | Red Oak, Texas* | ||||||||||||||
45 | Rusty Blackhaw* | ||||||||||||||
46 | Silk-tassle* | ||||||||||||||
47 | Sycamore, Mexican | ||||||||||||||
48 | Sycamore,Texas* | ||||||||||||||
49 | Texas Pistache* | ||||||||||||||
50 | Western Soapberry* | ||||||||||||||
51 | Wild Olive* | ||||||||||||||
52 | Yaupon Holly* |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
CATEGORIES