Good day,
Is there a feature, or would it be possible to add a feature that outputs a planting schedule where the material is sorted and potentially sub-totaled by the container size?
One often encounters permitting agencies that require calculations based on the total number of container sizes and it would easier to reference an auto-generated schedule instead of having to manually manipulate the data in Excel.
Thank you
Is there a feature, or would it be possible to add a feature that outputs a planting schedule where the material is sorted and potentially sub-totaled by the container size?
One often encounters permitting agencies that require calculations based on the total number of container sizes and it would easier to reference an auto-generated schedule instead of having to manually manipulate the data in Excel.
Thank you
ZEEK MAGALLANES
set the type of the post as
Task — 1 month ago
Zeek, I think this might be a better case for using excel macros with Land F/X plant schedules.
Power Tip: Creating An Excel Macro
Create a plant point field in plant sizes, or use excel to read the size output column and auto-fill a point size column with the correct point value.
You can set it up so it takes a spreadsheet plant schedule output and auto-sorts based on the plant size, and then adds sum calculations.
This would be a better approach since based on that example, you also don't want any species information in this type of schedule. You can also set the macro up to create a condensed schedule look like that, much more easily than would be practical for us to accomplish inside AutoCAD.
-Amanda
Power Tip: Creating An Excel Macro
Create a plant point field in plant sizes, or use excel to read the size output column and auto-fill a point size column with the correct point value.
You can set it up so it takes a spreadsheet plant schedule output and auto-sorts based on the plant size, and then adds sum calculations.
This would be a better approach since based on that example, you also don't want any species information in this type of schedule. You can also set the macro up to create a condensed schedule look like that, much more easily than would be practical for us to accomplish inside AutoCAD.
-Amanda
Hi Amanda,
Thank you for the suggestion, I can see either of those options working for the the 'plant point' example.
However, what prompted the request was the need to verify a cost estimates totals for various plant container sizes. We had to export our schedule to excel, create a table, sort by size, then sum the various totals. Being able to read a sub-total for all the 1gals., 5gals., etc. directly from a custom F/X CAD schedule would have saved a bit of time. I understand a custom macro could be used for this as well, but staying in the F/X CAD environment for all my needs would be convenient, so i figured I throw the suggestion out there for future development.
Thank you for the response, LandF/X is doing an incredible job serving our industry.
Thank you for the suggestion, I can see either of those options working for the the 'plant point' example.
However, what prompted the request was the need to verify a cost estimates totals for various plant container sizes. We had to export our schedule to excel, create a table, sort by size, then sum the various totals. Being able to read a sub-total for all the 1gals., 5gals., etc. directly from a custom F/X CAD schedule would have saved a bit of time. I understand a custom macro could be used for this as well, but staying in the F/X CAD environment for all my needs would be convenient, so i figured I throw the suggestion out there for future development.
Thank you for the response, LandF/X is doing an incredible job serving our industry.
Zeek,
It is currently possible, only requiring you to organize plants into groups per container size.
I could see us adding Size to the Sort by drop down, but that doesn’t solve the issue of how to specify the subtotals are to be by size. It would require adding a Group By setting, to select Plant Group, or Size.
I would think the best immediate solution would be to add Points to one of the user fields, making it extremely easy to sum once kicked into Excel.
—J
It is currently possible, only requiring you to organize plants into groups per container size.
I could see us adding Size to the Sort by drop down, but that doesn’t solve the issue of how to specify the subtotals are to be by size. It would require adding a Group By setting, to select Plant Group, or Size.
I would think the best immediate solution would be to add Points to one of the user fields, making it extremely easy to sum once kicked into Excel.
—J
- Page :
- 1
There are no replies made for this post yet.
Contact
- Land F/X
Our software tailors AutoCAD® to the needs of landscape architects, irrigation designers, and other professionals. We automate your most tedious tasks and ensure accuracy, giving you more time to design.