I am working on a project with planting driven by screening requirements such that a certain number of trees are required in different areas. I would like to have schedules demonstrating that our planting plan meets the requirements for each area. I have created different work areas and a schedule for each area, with only trees turned on in the schedule (shrubs and groundcover aren't listed). This is 90% of what I need.
The one thing I can't figure out how to do is creating a subtotal showing the number of trees in each area. It would be easy if all the trees in each area were the same species, but they're not. For example, I have an area with 4 Amelanchier and 3 Doug Firs. I would like to generate a schedule that says at the bottom something like "Total: 7 trees." Is there a way to do that?
Currently there isn't this option in the schedule options. It is a high priority of the wish list, though. I'll add this request to that wish list with your ideas of its use.
We have some plant manager and schedule improvements scheduled for this summer, and hope to add this in at that time.
In the meantime, you can send your tree schedules to a spreadsheet in excel, and do a quick sum calculation of the quantity column by highlighting those numbers and seeing the sum at the bottom bar in excel.
I'm having a similar request/issue so I wanted to add my comment on this thread instead of creating a new thread for a similar issue.
In our office we like to format the schedules a little different, not by much, just merge some of the cells, combine sizing information into a few less columns, we change some of the plant category names, etc. Is there a way to make those formatting changes to the schedule and rerun a planting or ref notes schedule and have it only update content not format what we've changed? Currently we run a schedule, edit it and then run a second schedule off to the side that we keep regenerating for updated quantities and then manually input them into the formatted schedule.
One last thing for planting, is there a way to add a column for planting contingencies? Either as individual plants or a contingency, say 10%, of the total number of shrubs, total number of groundcovers, etc? Right now we're doing as you suggest and exporting that to excel.
For the refnotes schedule, we add a symbol column and rearrange the quantity column and line up all of the column sizes so it's formatted the same as the planting schedule, but again, when we regenerate the reformatted schedule it reverts back to default formatting.
I'm not sure that this is helpful, but we actually change some plant categories too. For instance, rather than just trees, shrubs, shrub areas and ground covers, we use sub categories. For some projects we may break the trees up into more categories such as Street Trees, Palm Trees, Deciduous and Evergreen. Or we may split plant categories into California Native and Climate Adapted Ornamental.
After importing the plants while you are editing them for container size, etc. select the "Group" button and select to create your own sub-group.
Also, there is a way to set up the refnotes schedule to have the columns be a certain width. Unfortunately, that width is not saved and be aware that the width of the planting schedules vary depending on the strings of text that are being used for equipment description.This is a situation that I wouldn't know where to start to solve since they're apples and oranges.
Don't forget that you can also add Subcategories, of some sort of additional descriptions under the preferences> plant size. We use special categories to meet special agency requirements. We've added the water zones as well as ultimate expected HxW. These added subcategories are saved with that preference set.
I've added you to the wishlist item for the subcategory totals.
For the contingency cost, I'll add that idea to the wishlist for us to look into.
In the meantime, you might benefit from our Power Tip for Creating An Excel Macro. This goes over how to run a macro in Excel to do repetitive tasks for formatting our schedule outputs to a formal cost estimate or bid sheet.
Like Seaweed said, those plant size preferences are completely customizable. Here's a link for more information on the plant size preferences.
For the refnote formatting, we do have a wishlist item to add the ability to save a default refnote schedule option setup. I'll add you to that. If you find yourself heavily formatting the column arrangement, I'd be curious to see how you're formatting it. Maybe there's a better way, or at the least I can pull some wishlist items from the things you'd like to be more customizable in the reference note schedule.
Just checking int to see if there is any progress on this item. Sub-totalling is something that we really need to demonstrate compliance for a lot of our permitting. This is a feature we'd very much like to have.
Thanks for your response. I hope this doesn't linger too long. We often work on large projects (100+ acres) and the sub-totals are a good feature to have.
I look forward to seeing what other revisions may be forthcoming with regard to schedules. We've been using Land F/X for less than a year, but the schedules could use some attention overall. Other features great to have in the schedule would be custom columns that can be turned on/off arbitrarily (eg: Planting heights and spreads, mature heights), and reorganizing groups (splitting trees into evergreen or ornamental categories).
A plant data overhaul is already in the works that will improve your custom columns.
You can, however, add those in yourself by customizing the plant size preference columns. If none of the plants placed in a project have a "size" set for a particular column, that column won't appear in a schedule. So really you can do that right now.
You can already reorganize groups in the plant preferences. Click on the Plant Groups button in Planting Preferences. You can add, edit, and delete groups from there to add your own "Evergreen" Group (although our default preference set does already have an "Evergreen Trees" Group included). Plant Groups (Subcategories)
If you're thinking about something else, feel free to clarify further (it might be best to make a new forum post about it, though, since it's separate from this post's topic).
There are no replies made for this post yet. Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »